Spreadsheet: 127694d1320490228-automating-daily-calculation-from-subtotals-example-excel-forum
Sheet: workheet 2

Date | Overs | Shorts | Cummulative
2011-09-19 00:00:00 | 0.01273885350318471 | 0.02547770700636943 | 0.03821656050955415
2011-09-20 00:00:00 | 0.008620689655172414 | 0.02586206896551724 | 0.03448275862068965
2011-09-21 00:00:00 | 0 | 0 | 0
2011-09-22 00:00:00 | 0 | 0 | 0
2011-09-23 00:00:00 | 0.005847953216374269 | 0.01754385964912281 | 0.02339181286549707
2011-09-26 00:00:00 | 0 | 0.02293577981651376 | 0.02293577981651376
2011-09-27 00:00:00 | 0 | 0.004975124378109453 | 0.004975124378109453
2011-09-28 00:00:00 | 0 | 0.00546448087431694 | 0.00546448087431694
2011-09-29 00:00:00 | 0 | 0.03773584905660377 | 0.03773584905660377
2011-09-30 00:00:00 | 0.0091324200913242 | 0 | 0.0091324200913242
2011-10-03 00:00:00 | 0.007117437722419928 | 0 | 0.007117437722419928
2011-10-04 00:00:00 | 0.06153846153846154 | 0.01538461538461539 | 0.07692307692307693
2011-10-05 00:00:00 | 0 | 0.005988023952095809 | 0.005988023952095809
2011-10-06 00:00:00 | 0.004291845493562232 | 0 | 0.004291845493562232
2011-10-07 00:00:00 | 0.01734104046242774 | 0 | 0.01734104046242774
2011-10-10 00:00:00 | 0 | 0 | 0
2011-10-11 00:00:00 | 0 | 0 | 0
2011-10-12 00:00:00 | 0.016 | 0.044 | 0.06
2011-10-13 00:00:00 | 0 | 0.02409638554216868 | 0.02409638554216868
2011-10-14 00:00:00 | 0 | 0.0103448275862069 | 0.0103448275862069
2011-10-17 00:00:00 | 0.004694835680751174 | 0 | 0.004694835680751174
2011-10-18 00:00:00 | 0.003558718861209964 | 0.03558718861209965 | 0.03914590747330961
2011-10-19 00:00:00 | 0.01011804384485666 | 0.00505902192242833 | 0.01517706576728499
2011-10-20 00:00:00 | 0.005576208178438661 | 0.003717472118959108 | 0.009293680297397768
2011-10-21 00:00:00 | 0 | 0 | 0
2011-10-24 00:00:00 | 0.01366742596810934 | 0 | 0.01366742596810934
2011-10-25 00:00:00 | 0 | 0.004081632653061225 | 0.004081632653061225
2011-10-26 00:00:00 | 0.006172839506172839 | 0 | 0.006172839506172839
2011-10-27 00:00:00 | 0.001865671641791045 | 0 | 0.001865671641791045
2011-10-28 00:00:00 | 0 | 0.02083333333333333 | 0.02083333333333333
2011-10-31 00:00:00 | 0 | 0.003012048192771084 | 0.003012048192771084
2011-11-01 00:00:00 | 0.004132231404958678 | 0.004132231404958678 | 0.008264462809917356
2011-11-02 00:00:00 | 0.01458670988654781 | 0.006482982171799027 | 0.02106969205834684
2011-11-03 00:00:00 | 0 | 0 | 0
2011-11-04 00:00:00 | 0.01595744680851064 | 0 | 0.01595744680851064
2011-11-07 00:00:00
2011-11-08 00:00:00
2011-11-09 00:00:00
2011-11-10 00:00:00
2011-11-11 00:00:00
2011-11-14 00:00:00
2011-11-15 00:00:00
2011-11-16 00:00:00
2011-11-17 00:00:00
2011-11-18 00:00:00
2011-11-21 00:00:00
2011-11-22 00:00:00
2011-11-23 00:00:00
2011-11-24 00:00:00
2011-11-25 00:00:00
2011-11-28 00:00:00
2011-11-29 00:00:00
2011-11-30 00:00:00
2011-12-01 00:00:00
2011-12-02 00:00:00
2011-12-05 00:00:00
2011-12-06 00:00:00
2011-12-07 00:00:00
2011-12-08 00:00:00
2011-12-09 00:00:00
2011-12-12 00:00:00
2011-12-13 00:00:00
2011-12-14 00:00:00
2011-12-15 00:00:00
2011-12-16 00:00:00
2011-12-19 00:00:00
2011-12-20 00:00:00
2011-12-21 00:00:00
2011-12-22 00:00:00
2011-12-23 00:00:00
2011-12-26 00:00:00
2011-12-27 00:00:00
2011-12-28 00:00:00
2011-12-29 00:00:00
2011-12-30 00:00:00