Spreadsheet: 67752d1268298573-a-formula-which-calculates-a-single-value-from-multiple-criteria-revision-calculation-sheet
Sheet: REVISION

CHANGES TO                                                             TYP WK SCH | A | B | C | D | E | F | G | H | I | J | K | L
 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | UNITS PER WEEK | # OF WEEKS IN REV | "H" x "I" | PARTIAL WEEK UNITS | TOTAL           "J" + "K"
SERVICE PROCEDURE CODE | MON | TUES | WED | THURS | FRI | SAT | SUN |  |  |  |  |  |  |  |  |  |  |  |  | KEY
S5125 U1 | 36 | 36 | 36 | 36 | 28 | 64 | 64 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | = | SUN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | = | MON
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | = | TUES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | = | WED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | = | THURS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | = | FRI
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | = | SAT
REQUESTED CHANGES TO ALTERNATE SCHEDULE
# OF HOLIDAYS | 0 |  | 2 |  | 0 |  | 0 |  | 0
SERVICE PROCEDURE CODE | 2010-03-14 00:00:00 | 2010-03-31 00:00:00 | 2010-04-01 00:00:00 | 2010-04-30 00:00:00 |  |  |  |  |  |  | TOTAL UNITS |  |  |  |  |  |  | FOR 24 HOUR CLIENTS IN DAY PROGRAM:
 |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | To determine units needed for holidays, subtract total units (day & night) from 96 to get the totals units needed per holiday.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36 |  |  | 96
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | + | 32 |  | - | 68
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | = | SAT
CODE | PROVIDER # |  | [NAME] |  |  | RATE | TOTAL UNITS | TOTAL COST |  | START | END
 |  |  |  |  |  |  |  |  |  | 2010-03-14 00:00:00 | 2010-04-30 00:00:00
 |  |  |  |  |  | 0 |  |  |  | # [NAME] | # DAYS
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0 |  |  |  | STARTING DAY | ENDING DAY
 |  |  |  |  |  | 0
 |  |  |  |  | TOTAL REVISION COST:
 | # DAYS | Units/Qtr | # DAYS | Units/Qtr | # DAYS | Units/Qtr | # DAYS | Units/Qtr | # DAYS | Units/Qtr
MON
TUES
WED
THUR
FRI
SAT
SUN
TOTALS
 | alt sch |  | alt sch |  | alt sch |  | alt sch |  | alt sch
CURRENT PA
NEW PA TOTAL
 | # DAYS | Units/Qtr | # DAYS | Units/Qtr | # DAYS | Units/Qtr | # DAYS | Units/Qtr | # DAYS | Units/Qtr
MON
TUES
WED
THUR
FRI
SAT
SUN
TOTALS
 | alt sch |  | alt sch |  | alt sch |  | alt sch |  | alt sch
CURRENT PA
NEW PA TOTAL
 | # DAYS | Units/Qtr | # DAYS | Units/Qtr | # DAYS | Units/Qtr | # DAYS | Units/Qtr | # DAYS | Units/Qtr
MON
TUES
WED
THUR
FRI
SAT
SUN
TOTALS
 | alt sch |  | alt sch |  | alt sch |  | alt sch |  | alt sch
CURRENT PA
NEW PA TOTAL
 | # DAYS | Units/Qtr | # DAYS | Units/Qtr | # DAYS | Units/Qtr | # DAYS | Units/Qtr | # DAYS | Units/Qtr
MON
TUES
WED
THUR
FRI
SAT
SUN
TOTALS
 | alt sch |  | alt sch |  | alt sch |  | alt sch |  | alt sch
CURRENT PA
NEW PA TOTAL
0 | # DAYS | Units/Qtr | # DAYS | Units/Qtr | # DAYS | Units/Qtr | # DAYS | Units/Qtr | # DAYS | Units/Qtr
MON
TUES
WED
THUR
FRI
SAT
SUN
TOTALS
 | alt sch |  | alt sch |  | alt sch |  | alt sch |  | alt sch
CURRENT PA
NEW PA TOTAL
 | # DAYS | Units/Qtr | # DAYS | Units/Qtr | # DAYS | Units/Qtr | # DAYS | Units/Qtr | # DAYS | Units/Qtr
MON
TUES
WED
THUR
FRI
SAT
SUN
TOTALS
 | alt sch |  | alt sch |  | alt sch |  | alt sch |  | alt sch
CURRENT PA
NEW PA TOTAL
 |  |  |  |  |  | CLIENT NAME:
YEARLY PA TOTAL