Spreadsheet: 853247d1703146979-working-out-a-daily-percentage-of-a-monthly-total-sample-file
Sheet: Sheet1

Period number | Date | Day | Total | Percentage of period total
434 | 2020-01-05 00:00:00 | Sun | 37300.35890198231
434 | 2020-01-06 00:00:00 | Mon | 91113.03446822759
434 | 2020-01-07 00:00:00 | Tue | 92530.80119363008
434 | 2020-01-08 00:00:00 | Wed | 95116.04313017344
434 | 2020-01-09 00:00:00 | Thu | 91300.86598344015
434 | 2020-01-10 00:00:00 | Fri | 105085.7125205541
434 | 2020-01-11 00:00:00 | Sat | 45595.19728171766
434 | 2020-01-12 00:00:00 | Sun | 23343.03246387991
434 | 2020-01-13 00:00:00 | Mon | 92600.33497570395
434 | 2020-01-14 00:00:00 | Tue | 103339.5416555732
434 | 2020-01-15 00:00:00 | Wed | 99011.43998652874
434 | 2020-01-16 00:00:00 | Thu | 98777.70413466568
434 | 2020-01-17 00:00:00 | Fri | 106666.6277735931
434 | 2020-01-18 00:00:00 | Sat | 98909.69791578861
434 | 2020-01-19 00:00:00 | Sun | 41199.21739683914
434 | 2020-01-20 00:00:00 | Mon | 96883.88686229418
434 | 2020-01-21 00:00:00 | Tue | 99583.5133754093
434 | 2020-01-22 00:00:00 | Wed | 101633.4053923925
434 | 2020-01-23 00:00:00 | Thu | 101320.8043851037
434 | 2020-01-24 00:00:00 | Fri | 113912.5896873699
434 | 2020-01-25 00:00:00 | Sat | 108279.4503032548
434 | 2020-01-26 00:00:00 | Sun | 47278.30612356224
434 | 2020-01-27 00:00:00 | Mon | 101412.9140704483
434 | 2020-01-28 00:00:00 | Tue | 104218.9483409795
434 | 2020-01-29 00:00:00 | Wed | 102892.8397828562
434 | 2020-01-30 00:00:00 | Thu | 98925.95256614353
434 | 2020-01-31 00:00:00 | Fri | 112380.8899034611
434 | 2020-02-01 00:00:00 | Sat | 101092.0352319602
435 | 2020-02-02 00:00:00 | Sun | 42708.19077145541
435 | 2020-02-03 00:00:00 | Mon | 98611.99700465845
435 | 2020-02-04 00:00:00 | Tue | 102348.7605140314
435 | 2020-02-05 00:00:00 | Wed | 104284.86997853
435 | 2020-02-06 00:00:00 | Thu | 106317.3032969839
435 | 2020-02-07 00:00:00 | Fri | 112459.604552865
435 | 2020-02-08 00:00:00 | Sat | 90137.00291682259
435 | 2020-02-09 00:00:00 | Sun | 28643.55353980609
435 | 2020-02-10 00:00:00 | Mon | 96029.91569457299
435 | 2020-02-11 00:00:00 | Tue | 100367.0477249258
435 | 2020-02-12 00:00:00 | Wed | 101572.1494415179
435 | 2020-02-13 00:00:00 | Thu | 104324.3025562429
435 | 2020-02-14 00:00:00 | Fri | 114163.4832257187
435 | 2020-02-15 00:00:00 | Sat | 78434.40719137991
435 | 2020-02-16 00:00:00 | Sun | 47313.37402664279
435 | 2020-02-17 00:00:00 | Mon | 102912.4055656908
435 | 2020-02-18 00:00:00 | Tue | 108311.9596039647
435 | 2020-02-19 00:00:00 | Wed | 105804.8302927381
435 | 2020-02-20 00:00:00 | Thu | 104535.4625048352
435 | 2020-02-21 00:00:00 | Fri | 113577.4127768103
435 | 2020-02-22 00:00:00 | Sat | 84370.06367932292
435 | 2020-02-23 00:00:00 | Sun | 46339.14854749946
435 | 2020-02-24 00:00:00 | Mon | 91318.47518799132
435 | 2020-02-25 00:00:00 | Tue | 105481.9948759665
435 | 2020-02-26 00:00:00 | Wed | 102923.844023348
435 | 2020-02-27 00:00:00 | Thu | 106557.96242585
435 | 2020-02-28 00:00:00 | Fri | 108605.7473585279
435 | 2020-02-29 00:00:00 | Sat | 98875.23203679528
436 | 2020-03-01 00:00:00 | Sun | 63353.97468020235
436 | 2020-03-02 00:00:00 | Mon | 150445.0906685109
436 | 2020-03-03 00:00:00 | Tue | 153656.7343560564
436 | 2020-03-04 00:00:00 | Wed | 156637.2092776084
436 | 2020-03-05 00:00:00 | Thu | 159095.6089959612
436 | 2020-03-06 00:00:00 | Fri | 165298.7138434426
436 | 2020-03-07 00:00:00 | Sat | 118631.0042285779
436 | 2020-03-08 00:00:00 | Sun | 60681.57219333081
436 | 2020-03-09 00:00:00 | Mon | 147402.5892760834
436 | 2020-03-10 00:00:00 | Tue | 147251.5284983054
436 | 2020-03-11 00:00:00 | Wed | 142687.4330897147
436 | 2020-03-12 00:00:00 | Thu | 143469.0581747324
436 | 2020-03-13 00:00:00 | Fri | 146085.1561898867
436 | 2020-03-14 00:00:00 | Sat | 109743.3662560095
436 | 2020-03-15 00:00:00 | Sun | 51619.29880645244
436 | 2020-03-16 00:00:00 | Mon | 113580.5388915355
436 | 2020-03-17 00:00:00 | Tue | 90271.40312046678
436 | 2020-03-18 00:00:00 | Wed | 69689.3721482226
436 | 2020-03-19 00:00:00 | Thu | 63334.51988306428
436 | 2020-03-20 00:00:00 | Fri | 57000.2668148757
436 | 2020-03-21 00:00:00 | Sat | 25870.76035423639
436 | 2020-03-22 00:00:00 | Sun | 11569.88229799216
436 | 2020-03-23 00:00:00 | Mon | 24692.71516753479
436 | 2020-03-24 00:00:00 | Tue | 12743.12100540082
436 | 2020-03-25 00:00:00 | Wed | 9615.247385532155
436 | 2020-03-26 00:00:00 | Thu | 8432.395719537626
436 | 2020-03-27 00:00:00 | Fri | 8192.300634857236
436 | 2020-03-28 00:00:00 | Sat | 4583.550205728801