Need help with formula Rows 36 – Actual Demand (Lifeguards/Day) – For each day of the week, determine how many lifeguards are needed. This is based on the Standard Demand and on whether the week is a holiday- week. Remember, the demand is higher on every day of the week if one of the days is a holiday (A “Y” in B14). The resulting values provide you with the minimum number of lifeguards that need to be scheduled for each day. Tip: Use the IF-function, and use proper references (relative or absolute). If B36 is done correctly, you can copy the formula across to Column H. Holidays week? Yes or no the B14 cell had Y Standard Demands (lifeguards/Days): cell going through B30 to H30 B30= 22 C30=17 D30=13 E30=14 F30=15 G30=18 H30=24 Addition demands for holiday weeks per day is cell B32 = 5
Need help with formula Rows 36 – Actual Demand (Lifeguards/Day) – For each day of the week, determine how many lifeguards are needed. This is based on the Standard Demand and on whether the week is a holiday- week. Remember, the demand is higher on every day of the week if one of the days is a holiday (A “Y” in B14). The resulting values provide you with the minimum number of lifeguards that need to be scheduled for each day. Tip: Use the IF-function, and use proper references (relative or absolute). If B36 is done correctly, you can copy the formula across to Column H. Holidays week? Yes or no the B14 cell had Y Standard Demands (lifeguards/Days): cell going through B30 to H30 B30= 22 C30=17 D30=13 E30=14 F30=15 G30=18 H30=24 Addition demands for holiday weeks per day is cell B32 = 5
Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
Related questions
Question
Please help. Need help with formula
Rows 36 – Actual Demand (Lifeguards/Day) – For each day of the week, determine how many
lifeguards are needed. This is based on the Standard Demand and on whether the week is a holiday-
week. Remember, the demand is higher on every day of the week if one of the days is a holiday (A
“Y” in B14). The resulting values provide you with the minimum number of lifeguards that need to be
scheduled for each day. Tip: Use the IF-function, and use proper references (relative or absolute). If
B36 is done correctly, you can copy the formula across to Column H.
Holidays week? Yes or no the B14 cell had Y
Standard Demands (lifeguards/Days): cell going through B30 to H30
B30= 22
C30=17
D30=13
E30=14
F30=15
G30=18
H30=24
Addition demands for holiday weeks per day is cell B32 = 5
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Recommended textbooks for you
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,