Spreadsheet: 174127d1344938983-multiplation-by-if-calculations-l-d
Sheet: XX

 |  | Company | XXXX |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | Current Year | 2012 |  |  |  | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar
 |  | Current Month | 3 |  |  | % per month | 0.082 | 0.082 | 0.082 | 0.082 | 0.082 | 0.082 | 0.082 | 0.082 | 0.09799999999999999 | 0.082 | 0.082 | 0.082 | 0.9999999999999999
 |  | Year to Date | 103
 |  |  | Month | 3 | 2012
Dr | Cr |  | Annual Budget | Monthly Budget | Balance to Post
71151 | 66010 | 1
501 | 996 |  | 9962.717466942955 | 816.9428322893224
501 | 998 |  | 9962.717466942955 | 816.9428322893224 | 1634
502 | 996 |  | 10747.99425527046 | 881.3355289321776
502 | 998 |  | 15047.19195737865 | 1233.869740505049 | 2115
503 | 996 |  | 9439.199608057952 | 774.0143678607521
503 | 998 |  | 7551.359686446363 | 619.2114942886018 | 1393
504 | 996 |  | 4392.401142225849 | 360.1768936625197
504 | 998 |  | 2635.440685335509 | 216.1061361975118 | 576
505 | 996 |  | 4719.599804028976 | 387.0071839303761
505 | 998 |  | 3775.679843223181 | 309.6057471443009 | 697
506 | 996 |  | 10905.04961293596 | 894.2140682607487
506 | 998 |  | 16357.57441940394 | 1341.321102391123 | 2236
507 | 996 |  | 0 | 0
507 | 998 |  | 0 | 0 | 0
508 | 997 |  | 15193.35773099613 | 1245.855333941683
508 | 998 |  | 1215.46861847969 | 99.66842671533462 | 1346
509 | 997 |  | 0 | 0
509 | 998 |  | 0 | 0 | 0
510 | 997 |  | 15193.35773099613 | 1245.855333941683
510 | 998 |  | 1215.46861847969 | 99.66842671533462 | 1346
511 | 997 |  | 0 | 0
511 | 998 |  | 0 | 0 | 0
512 | 996 |  | 4392.401142225849 | 360.1768936625197
512 | 998 |  | 2635.440685335509 | 216.1061361975118 | 576
513 | 997 |  | 0 | 0
513 | 998 |  | 0 | 0 | 0
514 | 996 |  | 13856.76987811481 | 1136.255130005414
514 | 998 |  | 10161.63124395086 | 833.2537620039706 | 1970
515 | 996 |  | 0 | 0
515 | 998 |  | 0 | 0 | 0
516 | 996 |  | 13856.76987811481 | 1136.255130005414
516 | 998 |  | 10161.63124395086 | 833.2537620039706 | 1970
517 | 996 |  | 10747.99425527046 | 881.3355289321776
517 | 998 |  | 15047.19195737865 | 1233.869740505049 | 2115
519 | 996 |  | 4392.401142225849 | 360.1768936625197
519 | 998 |  | 2635.440685335509 | 216.1061361975118 | 576 | 226202.2507590476
 | 996 | TOTAL |  |  | 7988
 | 997 | TOTAL |  |  | 2492
 | 998 | TOTAL |  |  | 8069 | 0.4154377580998698
71166 | 66010 | 2
501 | 996 |  | 1275.227835768698 | 104.5686825330333
501 | 998 |  | 1275.227835768698 | 104.5686825330333 | 209
502 | 996 |  | 1375.743264674619 | 112.8109477033187
502 | 998 |  | 1926.040570544466 | 157.9353267846463 | 271
503 | 996 |  | 1208.217549831418 | 99.07383908617628
503 | 998 |  | 966.5740398651344 | 79.25907126894103 | 178
504 | 996 |  | 562.2273462049087 | 46.10264238880251
504 | 998 |  | 337.3364077229452 | 27.66158543328151 | 74
505 | 996 |  | 604.108774915709 | 49.53691954308814
505 | 998 |  | 483.2870199325672 | 39.62953563447051 | 89
506 | 996 |  | 1395.846350455803 | 114.4594007373758
506 | 998 |  | 2093.769525683704 | 171.6891011060638 | 286
507 | 996 |  | 0 | 0
507 | 998 |  | 0 | 0 | 0
508 | 997 |  | 1944.749789567504 | 159.4694827445354
508 | 998 |  | 155.5799831654004 | 12.75755861956283 | 172
509 | 997 |  | 0 | 0
509 | 998 |  | 0 | 0 | 0
510 | 997 |  | 1944.749789567504 | 159.4694827445354
510 | 998 |  | 155.5799831654004 | 12.75755861956283 | 172
511 | 997 |  | 0 | 0
511 | 998 |  | 0 | 0 | 0
512 | 996 |  | 562.2273462049087 | 46.10264238880251
512 | 998 |  | 337.3364077229452 | 27.66158543328151 | 74
513 | 997 |  | 0 | 0
513 | 998 |  | 0 | 0 | 0
514 | 996 |  | 1773.666544398695 | 145.440656640693
514 | 998 |  | 1300.68879922571 | 106.6564815365082 | 252
515 | 996 |  | 0 | 0
515 | 998 |  | 0 | 0 | 0
516 | 996 |  | 1773.666544398695 | 145.440656640693
516 | 998 |  | 1300.68879922571 | 106.6564815365082 | 252
517 | 996 |  | 1375.743264674619 | 112.8109477033187
517 | 998 |  | 1926.040570544466 | 157.9353267846463 | 271
519 | 996 |  | 562.2273462049087 | 46.10264238880251
519 | 998 |  | 337.3364077229452 | 27.66158543328151 | 74 | 28953.88809715809 |  |  |  |  |  |  |  |  | 0.128
 | 996 | TOTAL |  |  | 1022
 | 997 | TOTAL |  |  | 319
 | 998 | TOTAL |  |  | 1033 | -0.2188239669626455
71181 | 66010 | 3
501 | 996 |  | 498.1358733471478 | 40.84714161446612
501 | 998 |  | 498.1358733471478 | 40.84714161446612 | 82
502 | 996 |  | 537.399712763523 | 44.06677644660888
502 | 998 |  | 752.3595978689323 | 61.69348702525245 | 106
503 | 996 |  | 471.9599804028977 | 38.70071839303761
503 | 998 |  | 377.5679843223181 | 30.96057471443009 | 70
504 | 996 |  | 219.6200571112925 | 18.00884468312599
504 | 998 |  | 131.7720342667755 | 10.80530680987559 | 29
505 | 996 |  | 235.9799902014488 | 19.35035919651881
505 | 998 |  | 188.7839921611591 | 15.48028735721504 | 35
506 | 996 |  | 545.2524806467981 | 44.71070341303744
506 | 998 |  | 817.8787209701969 | 67.06605511955615 | 112
507 | 996 |  | 0 | 0
507 | 998 |  | 0 | 0 | 0
508 | 997 |  | 759.6678865498064 | 62.29276669708413
508 | 998 |  | 60.77343092398452 | 4.983421335766731 | 67
509 | 997 |  | 0 | 0
509 | 998 |  | 0 | 0 | 0
510 | 997 |  | 759.6678865498064 | 62.29276669708413
510 | 998 |  | 60.77343092398452 | 4.983421335766731 | 67
511 | 997 |  | 0 | 0
511 | 998 |  | 0 | 0 | 0
512 | 996 |  | 219.6200571112925 | 18.00884468312599
512 | 998 |  | 131.7720342667755 | 10.80530680987559 | 29
513 | 997 |  | 0 | 0
513 | 998 |  | 0 | 0 | 0
514 | 996 |  | 692.8384939057404 | 56.81275650027072
514 | 998 |  | 508.081562197543 | 41.66268810019853 | 98
515 | 996 |  | 0 | 0
515 | 998 |  | 0 | 0 | 0
516 | 996 |  | 692.8384939057404 | 56.81275650027072
516 | 998 |  | 508.081562197543 | 41.66268810019853 | 98
517 | 996 |  | 537.399712763523 | 44.06677644660888
517 | 998 |  | 752.3595978689323 | 61.69348702525245 | 106
519 | 996 |  | 219.6200571112925 | 18.00884468312599
519 | 998 |  | 131.7720342667755 | 10.80530680987559 | 29 | 11310.11253795238 |  |  |  |  |  |  |  |  | 0.04999999999999998
 | 996 | TOTAL |  |  | 399
 | 997 | TOTAL |  |  | 125
 | 998 | TOTAL |  |  | 403 | -0.4292281120948473
 |  |  | 266466.2513941581 |  | 43702
 |  |  | 246159.8155107457