Spreadsheet: 753002d1635178355-calculating-actual-and-budget-from-data-drop-test-mma
Sheet: Data

 |  |  |  | Actual |  |  |  |  |  |  |  |  |  |  |  | Budget
 |  |  |  | Period | Period | Period | Period | Period | Period | Period | Period | Period | Period | Period | Period | Period | Period | Period | Period | Period | Period | Period | Period | Period | Period | Period | Period
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
FA | 146 | 520200 | 0 | -1000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -750 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FA | 150 | 520153 | 0 | -20000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -15000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FA | 165 | 510100 | 0 | -16000 | -16000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -12000 | -12000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FA | 165 | 510101 | 0 | -5000 | -5000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -3750 | -3750 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FA | 165 | 510130 | 0 | 2500 | 2500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1875 | 1875 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FA | 165 | 510200 | 0 | -6000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -4500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FA | 165 | 510201 | 0 | -700 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -525 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FA | 166 | 510150 | 0 | -500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -375 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FA | 166 | 530700 | 0 | -50 | -60 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -37.5 | -45 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FA | 166 | 580300 | 0 | -20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FA | 180 | 530100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FA | 260 | 510251 | 0 | -8000 | -5000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -6000 | -3750 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FA | 260 | 525300 | 0 | -70 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -52.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FA | 300 | 520201 | 0 | -500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -375 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FA | 302 | 520202 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FP | 146 | 520200 | 0 | -250 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -187.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FP | 150 | 520153 | 0 | -5000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -3750 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FP | 165 | 510100 | 0 | -4000 | -4000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -3000 | -3000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FP | 165 | 510101 | 0 | -1250 | -1250 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -937.5 | -937.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FP | 165 | 510130 | 0 | 625 | 625 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 468.75 | 468.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FP | 165 | 510200 | 0 | -1500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1125 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FP | 165 | 510201 | 0 | -175 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -131.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FP | 166 | 510150 | 0 | -125 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -93.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FP | 166 | 530700 | 0 | -12.5 | -15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -9.375 | -11.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FP | 166 | 580300 | 0 | -5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -3.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FP | 180 | 530100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FP | 260 | 510251 | 0 | -2000 | -1250 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1500 | -937.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FP | 260 | 525300 | 0 | -17.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -13.125 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FP | 300 | 520201 | 0 | -125 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -93.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FP | 302 | 520202 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0