Spreadsheet: 91718d1291387723-charting-help-percentage-budget-used-vs-time-of-year-chart-example
Sheet: Source

 |  |  |  |  |  |  | Division | Program Code | Div-PAC | Budget | EXPENSE | OPEN_ENC | OPEN_PRE
 |  |  |  |  |  |  | 510 | 11000 | 510-11000 | 439684.9826542057 | 311136.9 | 14183.38653723244 | 55000
 |  | Data |  |  |  |  | 510 | 11007 | 510-11007 | 1115.69 | 0 | 200 | 400
Division | Program Code | Sum of Budget Amount | Sum of EXPENSE | Sum of OPEN_ENC | Sum of OPEN_PRE |  | 510 | 11009 | 510-11009 | 11349.36 | 0 | 0 | 80000
510 | 11000 | 439684.9826542057 | 311136.9 | 0 | 0 |  | 510 | 11010 | 510-11010 | 53554.36 | 26213.3 | 2059.783076923077 | 0
 | 11007 | 1115.69 | 0 | 0 | 0 |  | 510 | 11100 | 510-11100 | 100 | 0 | 0 | 0
 | 11009 | 11349.36 | 0 | 0 | 0 |  | 510 | 11300 | 510-11300 | 1400 | 0 | 275 | 0
 | 11010 | 53554.36 | 26213.3 | 0 | 0 |  | 510 | 11301 | 510-11301 | 19074.25 | 0 | 1235 | 5124
 | 11100 | 100 | 0 | 0 | 0 |  | 510 | 13000 | 510-13000 | 1040457.883289365 | 23600.16 | 580 | 0
 | 11300 | 1400 | 0 | 0 | 0 |  | 510 | 20000 | 510-20000 | 1416605 | 0 | 1485358 | 101186.0714285714
 | 11301 | 19074.25 | 0 | 0 | 0 |  | 510 | 80000 | 510-80000 | 950 | 0 | 0 | 0
 | 13000 | 1040457.883289365 | 23600.16 | 580 | 0 |  | 510 | 81300 | 510-81300 | 5856 | 0 | 1952 | 0
 | 20000 | 1416605 | 0 | 1485358 | 0 |  | 510 | 87080 | 510-87080 | 42867 | 0 | 42867 | 0
 | 80000 | 950 | 0 | 0 | 0 |  | 510 | 87085 | 510-87085 | 131377 | 0 | 0 | 62400
 | 81300 | 5856 | 0 | 1952 | 0 |  | 510 | 87087 | 510-87087 | 20000 | 0 | 0 | 0
 | 87080 | 42867 | 0 | 42867 | 0 |  | 510 | 87088 | 510-87088 | 54805 | 0 | 0 | 0
 | 87085 | 131377 | 0 | 0 | 0 |  | 511 | 11000 | 511-11000 | 3318482.130747663 | 306056.9 | 110616.0710249221 | 100560.064568111
 | 87087 | 20000 | 0 | 0 | 0 |  | 511 | 11002 | 511-11002 | 2336783.74 | 133745.82 | 179752.5953846154 | 101599.2930434783
 | 87088 | 54805 | 0 | 0 | 0 |  | 511 | 11003 | 511-11003 | 270000 | 16250.13 | 16875 | 10000
511 | 11000 | 3318482.130747663 | 306056.9 | 0 | 0 |  | 511 | 13000 | 511-13000 | 1272920.139485265 | 23600.16 | 55344.35389066371 | 106076.6782904388
 | 11002 | 2336783.74 | 133745.82 | 0 | 0 |  | 511 | 87081 | 511-87081 | 60532.29262882574 | 0 | 0
 | 11003 | 270000 | 16250.13 | 0 | 0 |  | 513 | 11900 | 513-11900 | 908456 | 0 | 0 | 0
 | 13000 | 1272920.139485265 | 23600.16 | 0 | 0 |  | 513 | 13000 | 513-13000 | 72426.05574160478 | 18205.18 | 4023.669763422488 | 1005.917440855622
 | 87081 | 60532.29262882574 | 0 | 0 | 0 |  | 513 | 21400 | 513-21400 | 71518 | 4000 | 1787.95 | 1007.295774647887
513 | 11900 | 908456 | 0 | 0 | 0 |  | 513 | 22000 | 513-22000 | 16940173 | 228302.53 | 770007.8636363636 | 1058760.8125
 | 13000 | 72426.05574160478 | 18205.18 | 0 | 0 |  | 513 | 22100 | 513-22100 | 6292922 | 119331.75 | 572083.8181818182 | 101498.7419354839
 | 21400 | 71518 | 4000 | 0 | 0 |  | 513 | 22200 | 513-22200 | 2097859 | 33107.94 | 63571.48484848485 | 104892.95
 | 22000 | 16940173 | 228302.53 | 0 | 0 |  | 513 | 22500 | 513-22500 | 8948405 | 149464.36 | 639171.7857142857 | 100543.8764044944
 | 22100 | 6292922 | 119331.75 | 0 | 0 |  | 513 | 87082 | 513-87082 | 311246.32 | 103748.7733333333 | 31124.632 | 103748.7733333333
 | 22200 | 2097859 | 33107.94 | 0 | 0 |  | 513 | 87084 | 513-87084 | 516418 | 103283.6 | 51641.8 | 10125.8431372549
 | 22500 | 8948405 | 149464.36 | 0 | 0 |  | 513 | 87086 | 513-87086 | 489851 | 122462.75 | 40820.91666666666 | 10205.22916666667
 | 87082 | 311246.32 | 0 | 0 | 0 |  | 514 | 11100 | 514-11100 | 125343.82 | 19290.04 | 34.5 | 10445.31833333333
 | 87084 | 516418 | 0 | 0 | 0 |  | 514 | 11600 | 514-11600 | 295688.05 | 6247.94 | 0 | 10196.13965517241
 | 87086 | 489851 | 0 | 0 | 0 |  | 514 | 11900 | 514-11900 | 1920000 | 33000 | 21860 | 101052.6315789474
514 | 11100 | 125343.82 | 19290.04 | 34.5 | 0 |  | 514 | 13000 | 514-13000 | 734186.057304648 | 23600.16 | 0 | 10057.3432507486
 | 11600 | 295688.05 | 6247.94 | 0 | 0 |  | 514 | 20600 | 514-20600 | 235428 | 0 | 173995 | 10236
 | 11900 | 1920000 | 33000 | 21860 | 0 |  | 514 | 80000 | 514-80000 | 6056827.65 | 4216.78 | 0 | 0
 | 13000 | 734186.057304648 | 23600.16 | 0 | 0 |  | 514 | 87081 | 514-87081 | 186166.56 | 10342.58666666667 | 18616.656 | 10342.58666666667
 | 20600 | 235428 | 0 | 173995 | 0 |  | 514 | 87083 | 514-87083 | 43871 | 0 | 0 | 0
 | 80000 | 6056827.65 | 4216.78 | 0 | 0 |  | 514 | 87084 | 514-87084 | 58267 | 0 | 0 | 0
 | 87081 | 186166.56 | 0 | 0 | 0 |  | 516 | 11000 | 516-11000 | 375107.4748224299 | 366387 | 10419.65207840083 | 10138.03986006567
 | 87083 | 43871 | 0 | 0 | 0 |  | 516 | 11300 | 516-11300 | 141493.5 | 9644.9 | 1473.890625 | 10106.67857142857
 | 87084 | 58267 | 0 | 0 | 0 |  | 516 | 13000 | 516-13000 | 1000674.915647205 | 454147.88 | 22237.22034771567 | 100067.4915647205
516 | 11000 | 375107.4748224299 | 366387 | 0 | 0 |  | 516 | 21200 | 516-21200 | 6995506 | 0 | 0 | 0
 | 11300 | 141493.5 | 9644.9 | 0 | 0 |  | 517 | 11000 | 517-11000 | 2011933.589775701 | 366387 | 55887.04416043614 | 100596.6794887851
 | 13000 | 1000674.915647205 | 454147.88 | 0 | 0 |  | 517 | 13000 | 517-13000 | 1527224.528124727 | 233115.94 | 66401.06644020554 | 101814.9685416485
 | 21200 | 6995506 | 0 | 0 | 0 |  | 517 | 13300 | 517-13300 | 370890.14 | 26030.58 | 14265.00538461539 | 10024.05783783784
517 | 11000 | 2011933.589775701 | 366387 | 0 | 0 |  | 517 | 13400 | 517-13400 | 49290 | 4080.75 | 1232.25 | 1005.918367346939
 | 13000 | 1527224.528124727 | 233115.94 | 0 | 0 |  | 517 | 18000 | 517-18000 | 80000 | 0 | 80000 | 0
 | 13300 | 370890.14 | 26030.58 | 0 | 0 |  | 517 | 21500 | 517-21500 | 3000815.6 | 100027.1866666667 | 300081.56 | 100027.1866666667
 | 13400 | 49290 | 4080.75 | 0 | 0 |  | 517 | 27000 | 517-27000 | 1 | 0 | 0 | 0
 | 18000 | 80000 | 0 | 80000 | 0 |  | 517 | 27001 | 517-27001 | 38822.92 | 6603.82 | 588.2260606060606 | 1021.655789473684
 | 21500 | 3000815.6 | 0 | 0 | 0 |  | 517 | 27200 | 517-27200 | 2 | 0 | 0 | 0
 | 27000 | 1 | 0 | 0 | 0 |  | 517 | 27201 | 517-27201 | 63029 | 11168.18 | 5729.909090909091 | 1000.460317460317
 | 27001 | 38822.92 | 6603.82 | 0 | 0 |  | 580 | 13000 | 580-13000 | 28001.51280239521 | 448123.88 | 0 | 0
 | 27200 | 2 | 0 | 0 | 0 |  | 581 | 13000 | 581-13000 | 73827.22560479041 | 453983.88 | 1640.605013439787 | 1011.331857599869
 | 27201 | 63029 | 11168.18 | 0 | 0 |  | 581 | 81300 | 581-81300 | 106754.75 | 3647.19 | 62263 | 0
580 | 13000 | 28001.51280239521 | 448123.88 | 0 | 0 |  | 581 | 87087 | 581-87087 | 361513 | 10042.02777777778 | 36151.3 | 10042.02777777778
581 | 13000 | 73827.22560479041 | 453983.88 | 0 | 0 |  | 595 | 81300 | 595-81300 | 5836 | 693.63 | 0 | 0
 | 81300 | 106754.75 | 3647.19 | 62263 | 0 |  | Grand Total |  |  | 73033690.49862881 | 4313291.604444444 | 4958408.995926726 | 2713322.063149015
 | 87087 | 361513 | 0 | 0 | 0
595 | 81300 | 5836 | 693.63 | 0 | 0
(blank) | (blank)
Grand Total |  | 73033690.49862881 | 3863384.68 | 1868909.5 | 0