Funding: I/O, Level 1
Staff to Consumer Ratio: 1:1, 2:1, 3:1
Est. Awake Hrs.: (number)
Est. OSOC Hrs.: (number)
Est. Weekly Revenue: (formula)
The goal is to calculate the “Est. Weekly Revenue” based on the selections that the user makes. There are different rates for each “Funding Type”, each “Staff Ratio”, “Awake Hrs.”, and “OSOC Hrs.”. This is the formula I have tried and it does not seem to work: If (Funding == “I/O” && Consumer_Ratio == “1:1”), (Awake_Hours* 19 + OSOC_Hours * 10.28).round(2), If (Funding == “I/O” && Consumer_Ratio == “2:1”), (Awake_Hours * 38 + OSOC_Hours * 10.28).round(2), If (Funding == “I/O” && Consumer_Ratio == “3:1”), (Awake_Hours * 45 + OSOC_Hours * 10.28).round(2), If (Funding == “Level 1” && Consumer_Ratio == “1:1”), (Awake_Hours * 19 + OSOC_Hours * 10.28).round(2), If (Funding == “Level 1” && Consumer_Ratio == “2:1”), (Awake_Hours * 19 + OSOC_Hours * 10.28).round(2), ), If (Funding == “Level 1” && Consumer_Ratio == “3:1”), (Awake_Hours * 19 + OSOC_Hours * 10.28).round(2)Any thoughts?
Thanks
Nick