Spreadsheet: chris_stokley__3946__SP15 DJ Charts
Sheet: PX 99 + 00 WD

Weekday
 |  | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 |  | Check
Hour |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | On [NAME] | [NAME]
100 |  | 1.009287081135691 | 0.9770271123153978 | 1.004442620429238 | 1.049778036965511 | 1.122024314266787 | 1.088728790961951 | 1.096208762706098 | 1.038594007167314 | 1.103611310721695 | 1.029070894283977 | 1.014493896896328 | 1.015290944964036 |  | Jan
200 |  | 0.9175833137836655 | 0.9280671258766231 | 0.8868986763641185 | 0.8993923057782074 | 0.9272213304581949 | 0.89669674655366 | 0.9325579508536161 | 0.9414013443807817 | 0.9612046230512398 | 0.9364235979769252 | 0.902276533177391 | 0.9356846212541663 |  | Feb
300 |  | 0.8710506131696589 | 0.8925406931810812 | 0.8102074649857507 | 0.7605282161491196 | 0.7828483741524542 | 0.7962067762280685 | 0.8425535951102757 | 0.8280276668704168 | 0.8416009956303713 | 0.8965696139066047 | 0.826158245341783 | 0.8803243653289892 |  | Mar
400 |  | 0.8572553083868011 | 0.8940584731672307 | 0.8171627966856768 | 0.7792933230639963 | 0.7485140810412018 | 0.7500781698442088 | 0.8254225625216765 | 0.8082267430769844 | 0.8179512706849005 | 0.880376778796767 | 0.8213038040363289 | 0.883520348850444 |  | Apr
500 |  | 0.9300876652630499 | 0.95092083910659 | 0.9375983771425528 | 0.8278359755188756 | 0.7857937545523113 | 0.7365015906760504 | 0.8206676108182066 | 0.8344768895603749 | 0.8599079663364217 | 0.9076385006609681 | 0.9247840609029436 | 0.9323194063468867 |  | May
600 |  | 1.07368421148474 | 1.090089553566303 | 1.125012856811597 | 1.020724976842869 | 0.9272938401108697 | 0.7495452022978917 | 0.8241717376689298 | 0.9738974832214429 | 0.9891513297231328 | 1.044892496826913 | 1.141069443777188 | 1.045598547124511 |  | Jun
700 |  | 0.9205913982641173 | 0.9623575950369242 | 0.9100568653786084 | 0.8021112140266191 | 0.6091912805947893 | 0.3409622345962164 | 0.3768510577589447 | 0.4721774894370426 | 0.6208398492467383 | 0.7605185594945248 | 0.8452509354614063 | 0.9134046352867314 |  | Jul
800 |  | 0.9808842246467393 | 0.9981720715638901 | 0.9692064006116128 | 0.8936925977883453 | 0.7252905100597248 | 0.5048742418280173 | 0.50356826569014 | 0.5658315242827331 | 0.7349429996916408 | 0.8087666383669349 | 0.9481089093127621 | 0.9859530821525148 |  | Aug
900 |  | 0.9977257586109879 | 1.003795657383614 | 0.9804958167995756 | 0.9281105474668802 | 0.8100308814474732 | 0.6015248300914059 | 0.5824833829525082 | 0.6597054906519675 | 0.8312113817234597 | 0.8216416845820167 | 0.9448115224073738 | 0.9887253185041747 |  | Sep
1000 |  | 1.021058938472885 | 0.9971768047941577 | 0.9972701987530472 | 0.9552451870195333 | 0.8917043726586887 | 0.741564069654454 | 0.6890089612067837 | 0.7557221374302251 | 0.9050117992169529 | 0.9356941783945383 | 0.9700209621287003 | 0.996593316894104 |  | Oct
1100 |  | 0.9991279402053448 | 0.9971316127546822 | 1.013562924576097 | 0.9928954663454634 | 0.9962042783744778 | 0.8708946193101441 | 0.8325196736463036 | 0.9004978565119234 | 0.9903269103696339 | 0.9540713354320194 | 0.995072334494991 | 0.9453256486280679 |  | Nov
1200 |  | 0.9744755218761677 | 0.9857316808580039 | 1.00023977512297 | 1.019224773725673 | 1.030097828409191 | 1.016714616367579 | 1.000100826548444 | 1.025722741030479 | 1.019173200053199 | 0.9730256927447278 | 0.9666278997919323 | 0.9228926088354591 |  | Dec
1300 |  | 0.9601767559585136 | 0.9779647029275612 | 0.992139574702763 | 1.040151741489379 | 1.07848777094142 | 1.14895420183939 | 1.153546928432221 | 1.067643333524696 | 1.063325027213507 | 0.99664161907108 | 0.9450510186142207 | 0.9118460490479188
1400 |  | 0.9452881804802373 | 0.9672701305925347 | 0.9844443439761134 | 1.07947672577411 | 1.172723667834276 | 1.292948404142984 | 1.337109581803084 | 1.206220458766264 | 1.104204873307242 | 1.04705421622405 | 0.9477424574007685 | 0.9015353892533381
1500 |  | 0.9226222670379546 | 0.9508522723778883 | 0.9645378503736483 | 1.065609191745342 | 1.202897033850582 | 1.401978079170499 | 1.429829760414717 | 1.345911979394762 | 1.142694345577675 | 1.087892941746233 | 0.9200649243879419 | 0.8816336879719927
1600 |  | 0.9033298892801676 | 0.9376815515729998 | 0.948406156217076 | 1.046184706496257 | 1.272712733428509 | 1.465367370759513 | 1.495764684144612 | 1.418658142986447 | 1.157438725027248 | 1.106857093575579 | 0.9209211287716145 | 0.8690274572828596
1700 |  | 0.9584275340680258 | 0.9508623792015235 | 0.9403400979446999 | 0.9979619675416438 | 1.145348961283625 | 1.425932924811536 | 1.466794949254973 | 1.39254444926119 | 1.130226796555809 | 1.078856586281075 | 0.9986423481742958 | 0.9900011796746767
1800 |  | 1.179118829637788 | 1.058693423027997 | 0.9769457249626208 | 0.9587751898687933 | 1.037031209868656 | 1.2801490719591 | 1.327590411720997 | 1.257518049423393 | 1.115363633515473 | 1.038439390182029 | 1.247011931848783 | 1.191099190198663
1900 |  | 1.175413447926118 | 1.138144300555256 | 1.196829747102979 | 0.9621064350587071 | 0.9752832854720044 | 1.133799425267714 | 1.095660737703128 | 1.094064100495107 | 1.075984401511131 | 1.182198091411601 | 1.240939758687164 | 1.212129973673149
2000 |  | 1.092867038341351 | 1.083845293038956 | 1.122748260192204 | 1.110773962688074 | 0.9901784580220057 | 0.981439445602764 | 0.9763835137985487 | 1.004647156811392 | 1.116118799933546 | 1.233597830961685 | 1.149236583943745 | 1.155129974827328
2100 |  | 1.030263592982268 | 1.026458688052153 | 1.03165342472662 | 1.165125348393823 | 1.114888046244764 | 0.9763142967275809 | 0.9703136617195054 | 1.027310021610606 | 1.072735809855589 | 1.129917349106809 | 1.038434935575656 | 1.091966392433467
2200 |  | 0.9386286822113397 | 0.963861836261865 | 0.9711228385593722 | 0.9825549445713488 | 0.9479296815098212 | 0.8165821678711035 | 0.7624736032050927 | 0.8058250683817725 | 0.9204014472011594 | 0.844826792425109 | 0.9220623489986494 | 1.042736095335558
2300 |  | 1.251398204473554 | 1.213838355358602 | 1.312080161409531 | 1.482430740209799 | 1.4948641313227 | 1.694761252363645 | 1.476849889994283 | 1.403159362541224 | 1.280275910142173 | 1.238496207268932 | 1.267717919593395 | 1.189842628485079
2400 |  | 1.089653602302838 | 1.053457847428177 | 1.106597046171539 | 1.180016425471621 | 1.211440174095484 | 1.287481471074529 | 1.181567890326914 | 1.172216503181462 | 1.146296593710064 | 1.066531910278914 | 1.102196096274642 | 1.11741913764589
Definitions:
 |  | On [NAME]                 -
 |  | [NAME]
 |  | Saturday & Sunday -
 |  | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00
WD1
WD2
WD3
WD4
WD5
WD6
Note - Each four hour block scaler is created by finding the straight average of the associated hourly scalers.