Spreadsheet: richard_shapiro__32160__csp analysis
Sheet: Price

 | Offer |  |  |  | Mid |  |  |  | Shopping Credit |  |  | Shopping |  | Offer - Mid |  |  |  | Shopping - Offer
Load Definition GS1 | 2001-04-25 00:00:00 | 2001-04-19 00:00:00 | 2001-03-19 00:00:00 |  | 2001-04-25 00:00:00 | 2001-04-19 00:00:00 | 2001-03-19 00:00:00 |  | 2001-04-25 00:00:00 | 2001-04-19 00:00:00 | 2001-03-19 00:00:00 | Credit |  | 2001-04-25 00:00:00 | 2001-04-19 00:00:00 | 2001-03-19 00:00:00 |  | 2001-04-25 00:00:00 | 2001-04-19 00:00:00 | 2001-03-19 00:00:00
College_Electric Heat_GS1 | 69.23704947033754 | 43.97258387134766 | 42.47201722956659 |  | 65.79332260385124 | 41.87578853207329 | 40.62228814238876 |  | 49.96465152644399 | 49.96468121524352 | 49.9662836653284
Convenience Store_Electric Heat_GS1 | 70.34961942195281 | 46.23496334127667 | 44.95894549638178 |  | 66.96006346390483 | 44.15914383246532 | 43.13147265421112 |  | 52.07132965297635 | 52.07125674241291 | 52.07240164328566
Fast Food 2 Meal_Electric_GS1 | 52.25206425949457 | 48.50494308513719 | 47.50269609137114 |  | 50.42420496132033 | 46.88950229106322 | 45.64216301037232 |  | 51.06952840441845 | 51.06951243536739 | 51.07187275409914
Fast Food 3 meal_Electric Heat_GS1 | 69.04256355868615 | 46.8990731584657 | 45.54546034278965 |  | 65.80530015987036 | 44.86371792901823 | 43.7053649591448 |  | 50.93501292336273 | 50.93499249514204 | 50.9366871675942
Fast Food24_Electric Heat_GS1 | 68.7848229641083 | 46.62585047481265 | 45.23956012159882 |  | 65.54296455842287 | 44.58838987238993 | 43.40097756371431 |  | 50.85929318617649 | 50.85926896716795 | 50.86052813658202
Grocery_Electric Heat_GS1 | 53.76527438047966 | 46.19793449365631 | 45.30895015168398 |  | 51.6507950999984 | 44.50294810557549 | 43.45896413391169 |  | 49.71481120010273 | 49.71480937552295 | 49.71523648374379
Hospital CV_Electric Heat_GS1 | 69.20323769527693 | 44.82983151328031 | 43.43805908895402 |  | 65.7742143214765 | 42.73254857764466 | 41.58432905362559 |  | 49.64625791239293 | 49.64625993226083 | 49.64670391003834
Hospital VAV_Electric Heat_GS1 | 67.22256430396486 | 45.44707973160288 | 43.99213304027916 |  | 64.00769883728549 | 43.42252364835701 | 42.15334601969762 |  | 49.65796903111778 | 49.6579679552031 | 49.65834311961193
Hotel_Electric Heat_GS1 | 51.04038200646592 | 46.71676517341942 | 45.53136913533481 |  | 49.14673136905362 | 45.0691901663503 | 43.64518534698197 |  | 49.6969195866313 | 49.69692163664052 | 49.69786508573218
Large Office CV_Electric Heat_GS1 | 71.57431973387392 | 46.17055918673371 | 44.7356746603997 |  | 68.13211063717345 | 44.06619247429371 | 42.87655260570844 |  | 49.65144037833659 | 49.65144409073387 | 49.65186929987345
[NAME] | 71.57161857627412 | 46.32005425767219 | 44.92294920959603 |  | 68.14424244463633 | 44.22549227999784 | 43.0708642415092 |  | 49.65597956979502 | 49.65598201494584 | 49.65646209365755
Large Retail_Electric Heat_GS1 | 49.744158948993 | 49.95002666301402 | 48.71526379244953 |  | 48.24815769873423 | 48.45556641977536 | 46.77758417108189 |  | 49.98745746951132 | 49.98748924923122 | 49.99133645857487
Nursing Home_Electric Heat_GS1 | 67.63110936275294 | 46.30214263767493 | 44.76295197232946 |  | 64.41934481368598 | 44.24486437755873 | 42.86538241618436 |  | 50.0112388443396 | 50.01127378414525 | 50.0146327781956
Restaurant 2 Meal_Electric_GS1 | 52.29895181994661 | 48.01824710805342 | 46.98522200579806 |  | 50.41468408528909 | 46.37515267064541 | 45.10496636579597 |  | 50.65080964189404 | 50.65083617226276 | 50.65431698032757
Restaurant 3 meal_Electric Heat_GS1 | 68.4581546541389 | 46.57645736517133 | 45.14804399005097 |  | 65.22546624870836 | 44.53238942957645 | 43.29038786446862 |  | 50.56053412662615 | 50.5605470852341 | 50.56347169362174
School_Electric Heat_GS1 | 67.59103800261461 | 41.92637334536495 | 40.26255984582802 |  | 64.07406867439347 | 39.78862640695368 | 38.37853255643749 |  | 50.47821690944412 | 50.47838080790893 | 50.4828126709399
Small Office_Electric Heat_GS1 | 69.67702699195613 | 44.78556724379564 | 47.2 |  | 66.24285993919945 | 42.69259179139927 | 41.54022100931707 |  | 52.42391257472043 | 52.42407879406179 | 52.44203727762813
Small Retail_Electric Heat_GS1 | 71.15587438599239 | 46.43739630177307 | 45.14589838655875 |  | 67.71037727428069 | 44.32766760086498 | 43.28001595340139 |  | 53.29464937316278 | 53.29479414680732 | 53.31342166460671
College_Gas Heat_GS1 | 68.29879765077386 | 43.91027733131594 | 42.581602480504 |  | 64.951091703266 | 41.87905372526092 | 40.7942317976316 |  | 50.37110732433616 | 50.37108901625722 | 50.37076016481771
Convenience Store_Gas Heat_GS1 | 70.58236434508508 | 46.45692936610622 | 47.33 |  | 67.19403025001365 | 44.38091982503243 | 43.35798732821702 |  | 52.5962341075321 | 52.59613477956637 | 52.59686339988827
Fast Food 2 Meal_Gas_GS1 | 71.92597234444317 | 49.38358032874994 | 48.11421850151634 |  | 68.66606450081949 | 47.33828944373832 | 46.27430517527755 |  | 53.99965370041537 | 53.99935189825966 | 54.00614277754934
Fast Food 3 meal_Gas Heat_GS1 | 71.76937734504592 | 47.77117944020348 | 46.59480375842431 |  | 68.3932209268951 | 45.69946073600968 | 44.76755055302741 |  | 53.69130553361853 | 53.69102585557208 | 53.69632978383671
Fast Food24_Gas Heat_GS1 | 71.00887187025951 | 47.10097051912089 | 45.88047178655261 |  | 67.6358680074994 | 45.03193337650948 | 44.05716847493274 |  | 53.39167562720811 | 53.39141727271777 | 53.39552429022584
Grocery_Gas Heat_GS1 | 51.79169369854515 | 46.53899010402959 | 45.59807275899041 |  | 49.86466913543357 | 44.90801815420178 | 43.76317363450642 |  | 49.7590600312308 | 49.75905135645188 | 49.75937690583319
Hospital CV_Gas Heat_GS1 | 49.92687187657003 | 46.95161164663282 | 45.96401267689832 |  | 48.18129262736378 | 45.38102553685366 | 44.13599552394903 |  | 49.72584799336217 | 49.7258350449125 | 49.72639646422451
Hospital VAV_Gas Heat_GS1 | 49.93647879966981 | 47.10919292432567 | 46.12311764243817 |  | 48.205796522851 | 45.54527572558046 | 44.29916206515639 |  | 49.74487696024777 | 49.74486061395304 | 49.74544760374346
Hotel_Gas Heat_GS1 | 49.46593374700766 | 49.63516095926178 | 48.75095668595776 |  | 48.45064449880272 | 48.6217288656352 | 46.89143903560488 |  | 49.82875839649645 | 49.82873104541604 | 49.82995690866304
Large Office CV_Gas Heat_GS1 | 69.87762853993755 | 47.02762070450994 | 45.6548005942569 |  | 66.65429254906249 | 45.01353704979957 | 43.83950727907878 |  | 49.68839713307661 | 49.68839218387811 | 49.68850806929208
Large OfficeVAV_Gas Heat_GS1 | 68.068522068001 | 46.9541730615482 | 45.54503456835189 |  | 64.96629044863793 | 44.98214423043839 | 43.73712460533551 |  | 49.69667113846068 | 49.69666223997426 | 49.69690055473128
Large Retail_Gas Heat_GS1 | 51.67804645721819 | 51.93232950137702 | 52.26363804780785 |  | 50.1407210663147 | 50.39637236442463 | 50.37795454828721 |  | 50.61648723545396 | 50.61637410738201 | 50.62164529296314
Nursing Home_Gas Heat_GS1 | 49.4796601053464 | 49.6447759645173 | 48.85257214903091 |  | 48.41172656864543 | 48.57881003186787 | 47.00698824835713 |  | 50.69545806455756 | 50.69533178199725 | 50.70076370405626
Restaurant 2 Meal_Gas_GS1 | 54.00220582260066 | 49.03184935976888 | 48.14906721506784 |  | 52.0900521215097 | 47.39838498930823 | 46.29857439768352 |  | 52.46788991732686 | 52.4677051654174 | 52.47534440299366
Restaurant 3 meal_Gas Heat_GS1 | 54.65652469209576 | 47.52810201783717 | 46.63074740170272 |  | 52.58483893615983 | 45.8542193905833 | 44.79399685292853 |  | 52.19009965308919 | 52.18992926895474 | 52.19625724844244
School_Gas Heat_GS1 | 66.57491217689832 | 41.95598416840988 | 40.60009741962125 |  | 63.213190594241 | 39.92906019770567 | 38.82407411698426 |  | 51.96350192399136 | 51.96359587290841 | 51.95358743981449
Small Office_Gas Heat_GS1 | 72.33603548386341 | 47.75959791659329 | 46.64079172808469 |  | 69.00208493903065 | 45.7292727162954 | 44.84633619070525 |  | 54.07898322452074 | 54.07866641040544 | 54.08559376195164
Small Retail_Gas Heat_GS1 | 73.53272833884219 | 49.28756208733683 | 48.24998696784467 |  | 70.15479097320781 | 47.2151614910546 | 46.4188716217224 |  | 55.47540466460111 | 55.47502607639711 | 55.48280676177306
Load Definition GS2
College_Electric Heat_GS2 | 71.63406996702989 | 46.38275637631448 | 45.08819167615429 |  | 68.1903431005436 | 44.2859610370401 | 43.23846258897647 |  | 66.4825439302818 | 66.48250674365016 | 66.48716558446641
Convenience Store_Electric Heat_GS2 | 72.6560212956143 | 48.55440080659945 | 47.47638329371903 |  | 69.26646533756632 | 46.47858129778811 | 45.64891045154836 |  | 65.90177724969719 | 65.90177183236122 | 65.90187458675825
Fast Food 2 Meal_Electric_GS2 | 75.68716552457354 | 51.12884656774425 | 50.16455942060401 |  | 72.25898812799969 | 49.02162584454467 | 48.30402633960519 |  | 66.04129035047876 | 66.04128676242931 | 66.04155466046497
Fast Food 3 meal_Electric Heat_GS2 | 73.58005545927935 | 49.25855272534558 | 48.2171241904123 |  | 70.17376533036538 | 47.17180664354479 | 46.37702880676746 |  | 65.99461871911551 | 65.99461029986557 | 65.99458281483456
Fast Food24_Electric Heat_GS2 | 73.25973528495433 | 49.00442717817297 | 47.93497896854932 |  | 69.85510607868109 | 46.91757525067414 | 46.0963964106648 |  | 65.94272426970099 | 65.94271969627238 | 65.9428719860452
Grocery_Electric Heat_GS2 | 73.61834120092477 | 49.24812268158276 | 48.15563863518005 |  | 70.20103688964883 | 47.15222004652506 | 46.30565261740775 |  | 66.0056914157322 | 66.00566720684154 | 66.00461260788772
Hospital CV_Electric Heat_GS2 | 71.71362271727205 | 47.35419025510326 | 46.14240069036882 |  | 68.28459934347163 | 45.2569073194676 | 44.2886706550404 |  | 66.091227333622 | 66.09121318200258 | 66.09233592867331
Hospital VAV_Electric Heat_GS2 | 72.15421473486303 | 47.96137976148661 | 46.81839597826143 |  | 68.75098063918497 | 45.87979639539007 | 44.9796089576799 |  | 66.07329370079752 | 66.07328689212086 | 66.0730741204307
Hotel_Electric Heat_GS2 | 74.03010205966723 | 49.43698295249344 | 48.23941248948612 |  | 70.56799493880561 | 47.30685942254587 | 46.35322870113328 |  | 66.1890280828097 | 66.18901124402446 | 66.18957872929053
Large Office CV_Electric Heat_GS2 | 74.16625613209014 | 48.77684195180449 | 56.58 |  | 70.72404703538966 | 46.67247523936448 | 45.68800160692818 |  | 66.56738944850903 | 66.56728002222272 | 66.57325733990074
Large [NAME] | 74.19782294822448 | 48.96086102011954 | 47.76000137350556 |  | 70.77044681658668 | 46.86629904244521 | 45.90791640541874 |  | 66.36076588156695 | 66.36071949999632 | 66.36802121634469
Large Retail_Electric Heat_GS2 | 77.75654641822562 | 52.2797165436231 | 51.19675118427655 |  | 74.22589983031219 | 50.10091033244537 | 49.25907156290893 |  | 66.33846815684258 | 66.33843159307953 | 66.34246941628477
Nursing Home_Electric Heat_GS2 | 73.41356936728845 | 48.47647314939257 | 47.23629843351181 |  | 69.92355713675349 | 46.33460207338945 | 45.33872887736671 |  | 66.18166129183487 | 66.18164406280827 | 66.18508684226218
Restaurant 2 Meal_Electric_GS2 | 75.37424540600209 | 50.6429884017512 | 49.5979631974911 |  | 71.9153891527069 | 48.51478078918753 | 47.71770755748899 |  | 66.06460647073155 | 66.06461629858113 | 66.06478850039592
Restaurant 3 meal_Electric Heat_GS2 | 73.34661971127613 | 48.88681264881051 | 47.77480244879931 |  | 69.91416155791315 | 46.78213234011103 | 45.91714632321695 |  | 66.00600421520178 | 66.00600289546325 | 66.00605578531102
School_Electric Heat_GS2 | 69.57368568009116 | 43.91939777336093 | 42.46708543697122 |  | 66.05671635187001 | 41.78165083494965 | 40.5830581475807 |  | 66.99118738835149 | 66.99112982437107 | 67.00894303673151
Small Office_Electric Heat_GS2 | 71.68349666906005 | 46.80302235689927 | 45.53179320987797 |  | 68.24932961630337 | 44.7100469045029 | 43.67933623649574 |  | 66.1872886846913 | 66.18731629609778 | 66.18812083299741
Small Retail_Electric Heat_GS2 | 73.07404304502461 | 48.36613959242732 | 47.19967767991068 |  | 69.62854593331288 | 46.25641089151923 | 45.33379524675332 |  | 66.16581600184855 | 66.16583387103059 | 66.16658994857062
College_Gas Heat_GS2 | 70.93308739442917 | 46.55944969011436 | 45.471054903344 |  | 67.58538144692129 | 44.52822608405936 | 43.6836842204716 |  | 66.23698294300056 | 66.23704787585832 | 66.23599612410786
Convenience Store_Gas Heat_GS2 | 72.82262786929607 | 48.70987061524168 | 47.63069260752623 |  | 69.43429377422463 | 46.63386107416787 | 45.80366614687923 |  | 65.89351818059653 | 65.8935087047637 | 65.89345830903753
Fast Food 2 Meal_Gas_GS2 | 75.60661534726763 | 51.38844458599782 | 50.4191045699453 |  | 72.21771398947205 | 49.30402286293837 | 48.57919124370651 |  | 65.98814559382389 | 65.98813603448966 | 65.9887707378977
Fast Food 3 meal_Gas Heat_GS2 | 73.9301543923456 | 49.94431384388313 | 48.92858826304288 |  | 70.55399797419477 | 47.87259513968934 | 47.10133505764598 |  | 65.95336914338728 | 65.95335942427683 | 65.95380531616686
Fast Food24_Gas Heat_GS2 | 73.20898721395703 | 49.31365819514735 | 48.26002867593355 |  | 69.83598335119692 | 47.24462105253593 | 46.43672536431368 |  | 65.91962521781197 | 65.91961549095082 | 65.91993815799671
Grocery_Gas Heat_GS2 | 73.70293860199675 | 49.59436047642934 | 48.55503619301177 |  | 70.31195350650688 | 47.51404241052526 | 46.72013706852777 |  | 65.92135883220521 | 65.92136788938524 | 65.92160933733157
Hospital CV_Gas Heat_GS2 | 73.86617473362624 | 50.0257904111704 | 49.00866148273931 |  | 70.49709291031776 | 47.95840774336907 | 47.18064432979002 |  | 66.04817566169953 | 66.04817569924111 | 66.04980643032891
Hospital VAV_Gas Heat_GS2 | 74.04364033949922 | 50.2044462404445 | 49.19622568124106 |  | 70.6815410949544 | 48.14152900973899 | 47.37227010395929 |  | 66.03874253690816 | 66.03874045005963 | 66.04002817861081
Hotel_Gas Heat_GS2 | 76.72724657202626 | 52.79890651341913 | 51.85868118443873 |  | 73.33118929779803 | 50.69949677262555 | 49.99916353408585 |  | 66.12318999567776 | 66.12322682538776 | 66.12489946810219
Large Office CV_Gas Heat_GS2 | 74.59751737023835 | 49.79733339351902 | 48.75505611449218 |  | 71.22670834952517 | 47.73856101613053 | 46.93976279931406 |  | 66.20129527730421 | 66.20132223723937 | 66.20124135569998
Large OfficeVAV_Gas Heat_GS2 | 74.09552698659165 | 49.6965470939307 | 48.68165417140064 |  | 70.74331996553867 | 47.64892583451094 | 46.87374420838425 |  | 66.21070804462498 | 66.21073231182403 | 66.21139570033223
Large Retail_Gas Heat_GS2 | 80.16882164481395 | 55.99328114476727 | 55.26187862489014 |  | 76.74973544306764 | 53.87089997869948 | 53.37619512536949 |  | 66.1574646818923 | 66.15752442800563 | 66.15712014091655
Nursing Home_Gas Heat_GS2 | 76.58655835714472 | 52.70787062351469 | 51.81714302634936 |  | 73.21147807050781 | 50.62720678282292 | 49.9715591256756 |  | 66.09826767939302 | 66.09829875183223 | 66.09915677031333
Restaurant 2 Meal_Gas_GS2 | 75.91943511694252 | 51.68345772279586 | 50.70355177811022 |  | 72.51932368290942 | 49.58914426340334 | 48.8530589607259 |  | 66.00760420847546 | 66.00761588427119 | 66.00804853006692
Restaurant 3 meal_Gas Heat_GS2 | 74.21439181028705 | 50.22444145032409 | 56.06 |  | 70.82870854936526 | 48.14438078230125 | 47.36584988652064 |  | 65.958073447743 | 65.95808278264477 | 65.95842362240901
School_Gas Heat_GS2 | 68.78322925679466 | 44.17666233017511 | 43.09825113699217 |  | 65.42150767413733 | 42.14973835947089 | 41.32222783435517 |  | 66.5125288039843 | 66.51263706202735 | 66.50902461208612
Small Office_Gas Heat_GS2 | 74.55299068347585 | 49.98926246493922 | 49.02892666998735 |  | 71.21904013864308 | 47.95893726464132 | 47.2344711326079 |  | 66.28147349736113 | 66.28148585083187 | 66.28271079271457
Small Retail_Gas Heat_GS2 | 75.81765218176812 | 51.46906525276421 | 50.56746078905977 |  | 72.43971481613374 | 49.39666465648199 | 48.73634544293749 |  | 66.20562981661595 | 66.20564021626895 | 66.20644369919681