{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["ENMAX Power","EPCOR Distribution","FortisAlberta","ATCO Electric","ATCO Gas"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ENMAX Power","index":0,"n_rows":127,"n_cols":5,"rows_kept":127,"cut":false,"hidden":false,"merged":[]}
["ENMAX Power"]
["Last Updated: 2005-06-16"]
[]
["Situation","Transaction","Start Date","End Date"]
["Initial Energize (May 6, 2008 - 14:00)","SMC",20080506000000]
[null,"ENC",20080506000000]
[null,"DCM",20080506000000,20080609000000]
[null,"TBF-TH",20080506,20080608]
[null,"TBF-DU",20080506,20080608]
[]
["De-Enrollment (June 2, 2008)","DCM (pre)",20080406000000,20080509000000]
[null,"SRR",20080601140000,null,"Received June 1, 14:00"]
[null,"SRO",20080602000000]
[null,"CSE",20080509000000,20080602000000]
[null,"TBF-TH",20080509,20080601,"Off-Cycle"]
[null,"TBF-DU",20080509,20080601,"Off-Cycle"]
["Enrollment switch (June 2, 2008)","SRR",20080601140000,null,"Received June 1, 14:00"]
[null,"SRN",20080602000000]
[null,"CSE",20080509000000,20080602000000]
[null,"SMC",20080602000000]
[null,"DCM (During)",20080509000000,20080609000000]
[null,"TBF-TH",20080602,20080608]
[null,"TBF-DU",20080602,20080608]
[]
["Temp De-energize (July 1, 2008 at 14:00)","DEC",20080701000000]
[null,"SMC",20080701000000]
["De-Energize Reading","DCM",20080609000000,20080701000000]
[null,"TBF-TH",20080609,20080631]
[null,"TBF-DU",20080609,20080631]
["Re-Energize (July 1, 2008 at 14:00)","ENC",20080701000000]
[null,"SMC",20080701000000]
["Normal Reading","DCM",20080701000000,20080709000000]
[null,"TBF-TH",20080701,20080708]
[null,"TBF-DU",20080701,20080708]
[]
["Energize (Aug 1, 2008 at 14:00)","ENC",20080801000000]
[null,"SMC",20080801000000]
["Energize Reading","DCM",20080709000000,20080801000000]
[null,"TBF-TH",20080709,20080731]
[null,"TBF-DU",20080709,20080731]
["Normal Reading","DCM",20080801000000,20080809000000]
[null,"TBF-TH",20080801,20080808]
[null,"TBF-DU",20080801,20080808]
[]
["Meter Switch C/C (Sept 1, 2008 at 14:00)","SMC",20080901000000]
["Old Meter - C","DCM",20080809000000,20080901000000]
[null,"TBF-TH",20080809,20080831]
[null,"TBF-DU",20080809,20080831]
["New Meter - C","DCM",20080901000000,20080909000000]
[null,"TBF-TH",20080901,20080908]
[null,"TBF-DU",20080901,20080908]
[]
["Meter Swich C/I (Sept 1, 2008 at 14:00)","SMC",20080901000000]
["Old Meter - C","DCM",20080809000000,20080901000000]
[null,"TBF-TH",20080809,20080831]
[null,"TBF-DU",20080809,20080831]
["New Meter - I","DIM",20080901000000,20080909000000,"Zero fill first day 00:00 - 14:00"]
[null,"TBF-TH",20080901,20080908]
[null,"TBF-DU",20080901,20080908]
[]
["Meter Switch I/C (Sept 1, 2008 at 14:00)","SMC",20080902000000]
["Old Meter - I","DIM",20080809000000,20080902000000,"Zero fill last day 14:00 - next day 00:00"]
[null,"TBF-TH",20080809,20080901]
[null,"TBF-DU",20080809,20080901]
["New Meter - C","DCM",20080902000000,20080909000000]
[null,"TBF-TH",20080902,20080908]
[null,"TBF-DU",20080902,20080908]
[]
["Meter Switch I/I (Sept 4, 2008 at 14:02)","SMC",20080904140200]
[null,"DIM",20080901000000,20081001000000,"Zero fill any outages"]
[null,"TBF-TH",20080901,20080930]
[null,"TBF-DU",20080901,20080930]
[]
["Regular Normal Read (Oct 9, 2008 at 14:00)","DCM",20080909000000,20081009000000]
[null,"TBF-TH",20080909,20081008]
[null,"TBF-DU",20080909,20081008]
["Next Normal Read (Nov 10 at 13:00)","DCM",20081009000000,20081110000000]
[null,"TBF-TH",20081009,20081109]
[null,"TBF-DU",20081009,20081109]
[]
["Site Removal - Same day DEC C (Nov 7, 2008 at 14:00)","DEC",null,20081107000000]
[null,"SRE",null,20081107000000]
[null,"DCM",20081009000000,20081107000000]
[null,"TBF-TH",20081009,20081106,"Off-Cycle"]
[null,"TBF-DU",20081009,20081106,"Off-Cycle"]
[]
["Site Removal - After DEC C (Nov 9, 2008 at 14:00)","DEC",null,20081107000000]
[null,"SRE",null,20081107000000]
[null,"DCM",20081009000000,20081107000000]
[null,"TBF-TH",20081009,20081106,"Off-Cycle"]
[null,"TBF-DU",20081009,20081106,"Off-Cycle"]
[]
["Site Removal - Same day DEC I (Nov 7, 2008 at 14:00)","DEC",null,20081108000000]
[null,"SRE",null,20081108000000]
[null,"DIM",20081009000000,20081108000000,"Zero Fill from 14:00 - next day 00:00"]
[null,"TBF-TH",20081009,20081107,"Off-Cycle"]
[null,"TBF-DU",20081009,20081107,"Off-Cycle"]
[]
["Site Removal - After DEC I (Nov 9, 2008 at 14:00)","DEC",null,20081108000000]
[null,"SRE",null,20081108000000]
[null,"DIM",20081009000000,20081108000000,"Zero Fill from 14:00 - next day 00:00"]
[null,"TBF-TH",20081009,20081107,"Off-Cycle"]
[null,"TBF-DU",20081009,20081107,"Off-Cycle"]
[]
["De/Energize Same day C (Nov 7, 2008 at 14:00)","DEC",null,20081107000000]
[null,"SMC",null,20081107000000]
[null,"ENC",null,20081107000000]
[null,"SMC",null,20081107000000]
["De-Energize Reading","DCM",20081009000000,20081107000000]
[null,"TBF-TH",20081009,20081106]
[null,"TBF-DU",20081009,20081106]
["Energize Reading","DCM",20081107000000,20081109000000]
[null,"TBF-TH",20081107,20081108]
[null,"TBF-DU",20081107,20081108]
[]
["Create Site Nov7, Enroll Nov8, Energize Nov9 at 14:00","SRN",20081108000000]
[null,"ENC",20081109000000]
[null,"DCM",20081109000000,20081210000000]
[null,"TBF-TH",20081109,20081209]
[null,"TBF-DU",20081109,20081209]
[]
["Customer Switch - June 2","CSA",20080602]
[null,"TBF-TH",20080509,20080601,"Off-Cycle"]
[null,"TBF-DU",20080509,20080601,"Off-Cycle"]
[null,"DCM (During)",20080509000000,20080609000000]
[null,"TBF-TH",20080602,20080608]
[null,"TBF-DU",20080602,20080608]

{"sheet":"EPCOR Distribution","index":1,"n_rows":121,"n_cols":5,"rows_kept":121,"cut":false,"hidden":false,"merged":[]}
["EPCOR Distribution"]
["Last Updated: 2006-02-16"]
[]
["Situation","Transaction","Start Date","End Date"]
["Initial Energize (May 6, 2005 - 14:00)","SMC",20050507000000]
[null,"ENC",20050507000000]
[null,"DCM",20050507000000,20050609000000]
[null,"TBF-TH",20050507,20050608]
[null,"TBF-DU",20050507,20050608]
[]
["De-Enrollment (June 2, 2005)","DCM (pre)",20050406000000,20050509000000]
[null,"SRR",20050601140000,null,"Received June 1, 14:00"]
[null,"SRO",20050602000000]
[null,"CSE",20050509000000,20050602000000]
[null,"TBF-TH",20050509,20050601,"Off-Cycle"]
[null,"TBF-DU",20050509,20050601,"Off-Cycle"]
["Enrollment switch (June 2, 2005)","SRR",20050601140000,null,"Received June 1, 14:00"]
[null,"SRN",20050602000000]
[null,"CSE",20050509000000,20050602000000]
[null,"SMC",20050602000000]
[null,"DCM (During)",20050509000000,20050609000000]
[null,"TBF-TH",20050602,20050608]
[null,"TBF-DU",20050602,20050608]
[]
["Temp De-energize (July 1, 2005 at 14:00)","DEC",20050702000000]
["De-Energize Reading","DCM",20050609000000,20050702000000]
[null,"TBF-TH",20050609,20050701]
[null,"TBF-DU",20050609,20050701]
["Normal Reading","DCM",20050702000000,20050709000000]
[null,"TBF-TH",20050702,20050708]
[null,"TBF-DU",20050702,20050708]
[]
["Energize (Aug 1, 2005 at 14:00)","ENC",20050802000000]
["Energize Reading","DCM",20050709000000,20050802000000]
[null,"TBF-TH",20050709,20050801]
[null,"TBF-DU",20050709,20050801]
["Normal Reading","DCM",20050802000000,20050809000000]
[null,"TBF-TH",20050802,20050808]
[null,"TBF-DU",20050802,20050808]
[]
["Meter Switch C/C (Sept 1, 2005 at 14:00)","SMC",20050902000000]
["Old Meter - C","DCM",20050809000000,20050902000000]
[null,"TBF-TH",20050809,20050901]
[null,"TBF-DU",20050809,20050901]
["New Meter - C","DCM",20050902000000,20050909000000]
[null,"TBF-TH",20050902,20050908]
[null,"TBF-DU",20050902,20050908]
[]
["Meter Swich C/I (Sept 1, 2005 at 14:00)","SMC",20050901000000]
["Old Meter - C","DCM",20050809000000,20050901000000]
[null,"TBF-TH",20050809,20050831]
[null,"TBF-DU",20050809,20050831]
["New Meter - I","DIM",20050901000000,20050909000000,"Zero fill first day 00:00 - 14:00"]
[null,"TBF-TH",20050901,20050908]
[null,"TBF-DU",20050901,20050908]
[]
["Meter Switch I/C (Sept 1, 2005 at 14:00)","SMC",20050902000000]
["Old Meter - I","DIM",20050809000000,20050902000000,"Zero fill last day 14:00 - next day 00:00"]
[null,"TBF-TH",20050809,20050901]
[null,"TBF-DU",20050809,20050901]
["New Meter - C","DCM",20050902000000,20050909000000]
[null,"TBF-TH",20050902,20050908]
[null,"TBF-DU",20050902,20050908]
[]
["Regular Normal Read (Oct 9, 2005 at 14:00)","DCM",20050909000000,20051010000000]
[null,"TBF-TH",20050909,20051009]
[null,"TBF-DU",20050909,20051009]
["Next Normal Read (Nov 10 at 13:00)","DCM",20051010000000,20051111000000]
[null,"TBF-TH",20051010,20051110]
[null,"TBF-DU",20051010,20051110]
[]
["Site Removal - Same day DEC C (Nov 7, 2005 at 14:00)","DEC",null,20051108000000]
[null,"SRE",null,20051108000000]
[null,"DCM",20051009000000,20051108000000]
[null,"TBF-TH",20051009,20051107,"Off-Cycle"]
[null,"TBF-DU",20051009,20051107,"Off-Cycle"]
[]
["Site Removal - After DEC C (Nov 9, 2005 at 14:00)","DEC",null,20051108000000]
[null,"SRE",null,20051110000000]
[null,"DCM",20051009000000,20051108000000]
[null,"TBF-TH",20051009,20051107,"Off-Cycle"]
[null,"TBF-DU",20051009,20051107,"Off-Cycle"]
[null,"TBF-TH",20051008,20051109,"Off-Cycle"]
[null,"TBF-DU",20051008,20051109,"Off-Cycle"]
[]
["Site Removal - Same day DEC I (Nov 7, 2005 at 14:00)","DEC",null,20051108000000]
[null,"SRE",null,20051108000000]
[null,"DIM",20051009000000,20051108000000,"Zero Fill from 14:00 - next day 00:00"]
[null,"TBF-TH",20051009,20051107,"Off-Cycle"]
[null,"TBF-DU",20051009,20051107,"Off-Cycle"]
[]
["Site Removal - After DEC I (Nov 9, 2005 at 14:00)","DEC",null,20051108000000]
[null,"SRE",null,20051110000000]
[null,"DIM",20051009000000,20051108000000,"Zero Fill from 14:00 - next day 00:00"]
[null,"TBF-TH",20051009,20051107,"Off-Cycle"]
[null,"TBF-DU",20051009,20051107,"Off-Cycle"]
[null,"TBF-TH",20051008,20051109,"Off-Cycle"]
[null,"TBF-DU",20051008,20051109,"Off-Cycle"]
[]
["De/Energize Same day C (Nov 7, 2005 at 14:00)","DEC",null,20051108000000]
[null,"ENC",null,20051108000000]
["De-Energize Reading","DCM",20051009000000,20051108000000]
["Energize Reading","DCM",20051108000000,20051109000000]
[null,"TBF-TH",20051009,20051108]
[null,"TBF-DU",20051009,20051107]
[null,"TBF-DU",20051108,20051108]
[]
["Create Site Nov7, Enroll Nov8, Energize Nov9 at 14:00","SRN",20051109000000]
[null,"ENC",20051110000000]
[null,"DCM",20051110000000,20051210000000]
[null,"TBF-TH",20051109,20051109]
[null,"TBF-DU",20051109,20051109]
[null,"TBF-TH",20051110,20051209]
[null,"TBF-DU",20051110,20051209]
[]
["Customer Switch - June 2","CSA",20050602]
[null,"TBF-TH",20050509,20050601,"Off-Cycle"]
[null,"TBF-DU",20050509,20050601,"Off-Cycle"]
[null,"DCM (During)",20050509000000,20050609000000]
[null,"TBF-TH",20050602,20050608]
[null,"TBF-DU",20050602,20050608]

{"sheet":"FortisAlberta","index":2,"n_rows":130,"n_cols":5,"rows_kept":130,"cut":false,"hidden":false,"merged":[]}
["FortisAlberta"]
["Last Updated: 2005-06-15"]
[]
["Situation","Transaction","Actual date/time","Start Date","End Date"]
["Initial Energize ","SMC",20041221030545,20041221000000]
[null,"ENC",null,20041221000000]
["SITE ID 0040000238722 ","DCM",20050223140000,"20041221000000-20050223000000"]
[null,"TBF-TH",null,"20041221 - 20050126"]
[null,"TBF-DU",null,"20041221 - 20050126"]
[null,"TBF-TH",null,"20050127-20050223"]
[null,"TBF-DU",null,"20050127-20050223"]
[]
["De-Enrollment","DCM (pre)",null,"20041130000000 - 20041230000000"]
[null,"SRR",null,20041231000000]
["SITE ID 0040277949523","SRO",null,20050101000000]
["retailer switch, old site","CSE",null,"generated from EVE"]
[null,"TBF-TH",null,"20041201 - 20041230"]
[null,"TBF-DU",null,"20041201 - 20041230"]
[null,"TBF-TH",null,"20041231 - 20041231"]
[null,"TBF-DU",null,"20041231 - 20041231"]
["Enrollment switch","SRR",20041231213000,20041231213000]
[null,"SRN",null,20050101000000]
["SITE ID 0040277949523","CSE",null,"generated from EVE"]
["retailer switch, new site","SMC",null,20050101000000]
[null,"DCM (During)",20050201140000,"20041230000000-20050201000000"]
[null,"TBF-TH",null,"20050101 - 20050201"]
[null,"TBF-DU",null,"20050101 - 20050201"]
[]
["Temp De-energize","DEC",null,20050104000000]
["De-Energize Reading","DCM",20050104140000,"20041214000000 - 20050104000000"]
["disconnection","TBF-TH",null,"20041215-20050104"]
["Site ID 0040206596002","TBF-DU",null,"20041215-20050104"]
["Normal Reading","DCM",20050207140000,"20050104000000 - 20050207000000"]
[null,"TBF-TH",null,"20050105 - 20050207"]
[null,"TBF-DU",null,"20050105 - 20050207"]
[]
["Energize","ENC",20050323090000,20050323000000]
["Energize Reading","DCM",20050323140000,"20050207000000 - 20050323000000"]
["reconnection","TBF-TH",null,"20050208 - 20050323"]
["Site ID 0040206596002","TBF-DU",null,"20050208 - 20050323"]
["Normal Reading","DCM",20050408140000,"20050323000000 - 20050408000000"]
[null,"TBF-TH",null,"20050324 - 20050408"]
[null,"TBF-DU",null,"20050324 - 20050408"]
[]
["Meter Switch C/C","SMC",null,"no SMC sent for C to C exchanges - SSC pg 101"]
["Old Meter - C","DCM",20050106140000,"20041008000000 - 20050106000000"]
["2 to 3 register change","TBF-TH",null,"20041009 - 20050105"]
["Site ID 0040284971000 (work completed on 6th)","TBF-DU",null,"20041009 - 20050105"]
["New Meter - C","DCM",20050207140000,"20050106000000 - 20050207000000"]
[null,"TBF-TH",null,"20050106 - 20050207"]
[null,"TBF-DU",null,"20050106 - 20050207"]
[]
["Meter Swich C/I","SMC",20050525140000,20050524000000]
["Old Meter - C","DCM",20050323140000,"20050506000000 - 20050523000000"]
[null,"TBF-TH",null,"20050507 - 20050523"]
["Site ID 0040579698990","TBF-DU",null,"20050507 - 20050523"]
["New Meter - I","DIM",null,"every 15 min, beginning 20050523 (00:00:00)"]
[null,"TBF-TH",null,"alignment is fine"]
[null,"TBF-DU",null,"alignment is fine"]
[]
["Meter Switch I/C","SMC",null,20050324000000]
["Old Meter - I","DIM",null,"every 15 up to end of 20050323 (235959)"]
[null,"TBF-TH",null,"20050301 - 20050323"]
[null,"TBF-DU",null,"20050301 - 20050323"]
["New Meter - C","DCM",20050331140000,"20050324000000 - 20050331000000"]
[null,"TBF-TH",null,"20050324 - 20050331"]
[null,"TBF-DU",null,"20050324 - 20050331"]
[]
["Regular Normal Read","DCM",20050303140000,"20050107000000 - 20050303000000"]
[null,"TBF-TH",null,"20050108 - 20050201"]
[null,"TBF-DU",null,"20050108 - 20050201"]
[null,"TBF-TH",null,"20050202-20050303"]
[null,"TBF-DU",null,"20050202-20050303"]
["Next Normal Read","DCM",20050505140000,"20050303000000 - 20050505000000"]
[null,"TBF-TH",null,"20050304 - 20050404"]
[null,"TBF-DU",null,"20050304 - 20050404"]
[null,"TBF-TH",null,"20050405-20050505"]
["Site ID 0040531540003","TBF-DU",null,"20050405-20050505"]
[]
["Site Removal - Same day DEC C","DEC",null,20050505000000]
[null,"SRO",null,20050506000000]
["DER 20050505140000","DCM",20050504140000,"20050330000000 - 20050504000000"]
[null,"TBF-TH",null,"20050331 - 20050504"]
[null,"TBF-DU",null,"20050331 - 20050504"]
["Assume Salvage site","TBF-TH",null,"20050505-20050505"]
[null,"TBF-DU",null,"20050505-20050505"]
[]
["Site Removal - After DEC C","DEC",null,20050502000000]
[null,"SRO",null,20050521000000]
["Assume Salvage site","DCM",null,"20050501000000 - 20050521000000"]
[null,"TBF-TH",null,"20050501 - 20050520"]
[null,"TBF-DU",null,"20050501 - 20050520"]
[null,"TBF-TH",null,"20050521-20050521"]
[null,"TBF-DU",null,"20050521-20050521"]
[]
["Site Removal - Same day DEC I","DEC"]
[null,"SRO",null,"same process as Cumulative"]
[null,"DIM"]
[null,"TBF-TH"]
[null,"TBF-DU"]
[]
["Site Removal - After DEC I","DEC"]
[null,"SRO",null,"same process as Cumulative"]
[null,"DIM"]
[null,"TBF-TH"]
[null,"TBF-DU"]
[]
["De/Energize Same day C","DEC",null,20050518000000]
[null,"ENC",null,20050518000000]
["De-Energize Reading","DCM",20050518140000,"20050511000000 - 20050518000000"]
[null,"TBF-TH",null,"20050512 - 20050518"]
[null,"TBF-DU",null,"20050512 - 20050518"]
["Energize Reading","DCM","2005051914000 / 2005060914000","20050518000000 - 20050519000000 / 20050519000000-20050609000000"]
[null,"TBF-TH",null,"20050519 - 20050609"]
[null,"TBF-DU",null,"20050519 - 20050609"]
[]
["Create Site","SRN",null,20041215000000]
[null,"SMC",null,20041215000000]
[null,"SMC",null,20050106000000]
["enroll 20041215","ENC",null,20050106000000]
["ENR 20050106","DCM",20050112140000,"20050106000000 - 20050120000000"]
[null,"TBF-TH",null,"20041215-20050105 / 20050106-20050120"]
[null,"TBF-DU",null,"20041215-20050105 / 20050106-20050120"]
[]
["Customer Switch - June 2","CSA"]
[null,"TBF-TH"]
[null,"TBF-DU",null,"not applicable for July"]
[null,"DCM (During)"]
[null,"TBF-TH"]
[null,"TBF-DU"]

{"sheet":"ATCO Electric","index":3,"n_rows":132,"n_cols":5,"rows_kept":132,"cut":false,"hidden":false,"merged":[]}
["ATCO Electric","Note - Effective October 1, 2006; Presentation of Last Reading Datetime in DCMs and Last Reading Datetime in other transactions changed to actual deemed datetime of 23:59:59"]
["Last Updated: 2006-09-29"]
[]
["Situation","Transaction","Start Date","End Date"]
["Initial Energize (May 6, 2005 - 14:00)","SMC","20050507 00:00:00",null,"(Last Reading Datetime is the same as DCM)"]
[null,"ENC","20050506 23:59:59"]
[null,"DCM","20050506 23:59:59","20050602 23:59:59"]
[null,"TBF-TH",20050507,20050602]
[null,"TBF-DU",20050507,20050602]
[]
["De-Enrollment (June 2, 2005)","DCM (pre)","20050428 23:59:59","20050530 23:59:59"]
[null,"SRR",null,null,"Received June 1, 2005"]
[null,"SRO","20050602 00:00:00"]
[null,"CSE","20050428 23:59:59","20050602 00:00:00"]
[null,"TBF-TH","20050531","20050601"]
[null,"TBF-DU","20050531","20050601"]
[]
["Enrollment switch (June 2, 2005)","SRR",null,null,"Received June 1, 2005"]
[null,"SRN","20050602 00:00:00"]
[null,"CSE","20050530 23:59:59","20050602 00:00:00"]
[null,"SMC","20050602 00:00:00",null,"(Last Reading Datetime is the same as DCM)"]
[null,"DCM (During)","20050530 23:59:59","20050629 23:59:59"]
[null,"TBF-TH","20050531","20050629"]
[null,"TBF-DU","20050531","20050629"]
[]
["Temp De-energize (July 1, 2005 at 14:00)","DEC","20050701 23:59:59"]
[null,"SMC","20050702 00:00:00",null,"(Last Reading Datetime is the same as DCM)"]
["De-Energize Reading","DCM","20050609 23:59:59","20050701 23:59:59"]
[null,"TBF-TH","20050610","20050701"]
[null,"TBF-DU","20050610","20050701"]
["Normal Reading","DCM","20050701 23:59:59","20050710 23:59:59"]
[null,"TBF-TH","20050702","20050710"]
[null,"TBF-DU","20050702","20050710"]
[]
["Energize (Aug 1, 2005 at 14:00)","ENC","20050801 23:59:59"]
[null,"SMC","20050802 00:00:00",null,"(Last Reading Datetime is the same as DCM)"]
["Energize Reading","DCM","20050710 23:59:59","20050801 23:59:59"]
[null,"TBF-TH","20050711","20050801"]
[null,"TBF-DU","20050711","20050801"]
["Normal Reading","DCM","20050801 23:59:59","20050810 23:59:59"]
[null,"TBF-TH","20050802","20050810"]
[null,"TBF-DU","20050802","20050810"]
[]
["Meter Switch C/C (Sept 1, 2005 at 14:00)","SMC","NA"]
["Old Meter - C","DCM","20050810 23:59:59","20050901 23:59:59"]
[null,"TBF-TH",null,null,"No TBF-TH"]
[null,"TBF-DU",null,null,"No TBF-DU"]
["New Meter - C","DCM","2005901 23:59:59","20050910 23:59:59"]
[null,"TBF-TH","20050811","20050910"]
[null,"TBF-DU","20050811","20050901"]
[null,"TBF-DU","20050902","20050910","Will have 2 DU records"]
[]
["Meter Swich C/I (Sept 1, 2005 at 14:00)","SMC","20050901 00:00:00",null,"(Datetime Effective) (Last Reading Datetime is the same as DCM)"]
["Old Meter - C","DCM","20050810 23:59:59","20050831 23:59:59"]
[null,"TBF-TH","20050811","20050831"]
[null,"TBF-DU","20050811","20050831"]
["New Meter - I","DIM","20050901 00:00:00","20050910 23:59:59"]
[null,"TBF-TH","20050901","20050910"]
[null,"TBF-DU","20050901","20050910"]
[]
["Meter Switch I/C (Sept 1, 2005 at 14:00)","SMC","20050902 00:00:00",null,"(Last Reading Datetime is the same as DCM)"]
["Old Meter - I","DIM","20050811 00:00:00","20050901 23:59:59"]
[null,"TBF-TH","20050811","20050901"]
[null,"TBF-DU","20050811","20050901"]
["New Meter - C","DCM","20050901 23:59:59","20050910 23:59:59"]
[null,"TBF-TH","20050902","20050910"]
[null,"TBF-DU","20050902","20050910"]
[]
["Regular Normal Read (Oct 9, 2005 at 14:00)","DCM","20050910 23:59:59","20051009 23:59:59"]
[null,"TBF-TH","20050911","20051009"]
[null,"TBF-DU","20050911","20051009"]
["Next Normal Read (Nov 10 at 13:00)","DCM","20051009 23:59:59","20051110 23:59:59"]
[null,"TBF-TH","20051010","20051110"]
[null,"TBF-DU","20051010","20051110"]
[]
["Site Removal - Same day DEC C (Nov 7, 2005 at 14:00)","DEC",null,null,"AE will not use this transaction"]
[null,"SRE",null,null,"AE will never salvage a site until an SRO\nhas been sent"]
[null,"DCM"]
[null,"TBF-TH"]
[null,"TBF-DU"]
[]
["Site Removal - After DEC C (Nov 9, 2005 at 14:00)","DEC",null,null,"AE will not use this transaction"]
[null,"SRE",null,null,"AE will never salvage a site until an SRO\nhas been sent"]
[null,"DCM"]
[null,"TBF-TH"]
[null,"TBF-DU"]
[null,"TBF-TH"]
[null,"TBF-DU"]
[]
["Site Removal - Same day DEC I (Nov 7, 2005 at 14:00)","DEC",null,null,"AE will not use this transaction"]
[null,"SRE",null,null,"AE will never salvage a site until an SRO\nhas been sent"]
[null,"DIM"]
[null,"TBF-TH"]
[null,"TBF-DU"]
[]
["Site Removal - After DEC I (Nov 9, 2005 at 14:00)","DEC",null,null,"AE will not use this transaction"]
[null,"SRE",null,null,"AE will never salvage a site until an SRO\nhas been sent"]
[null,"DIM"]
[null,"TBF-TH"]
[null,"TBF-DU"]
[null,"TBF-TH"]
[null,"TBF-DU"]
[]
["De/Energize Same day C (Nov 17, 2005 at 14:00)","DEC",null,"20051117 23:59:59"]
[null,"SMC",null,"20051118 00:00:00","(Last Reading Datetime is the same as DCM)"]
["De-Energize Reading","DCM","NA","NA"]
[null,"TBF-TH",null,null,"Will not trigger a TBF event"]
[null,"TBF-DU"]
["Energize Reading","DCM","20051110 23:59:59","20051117 23:59:59"]
[null,"TBF-TH",null,null,"Will not trigger a TBF event"]
[null,"TBF-DU"]
[{"$nulls":4},"Note:  The energize read is used because this is the latest read that we have for the day"]
[]
[]
[]
[]
[]
["Create Site Nov 7, Enroll Nov 8, Energize Nov 9 at 14:00","SRN","20051109 00:00:00"]
[null,"ENC","20051109 23:59:59"]
[null,"SMC","20051110 00:00:00",null,"(Datetime Effective) (Last Reading Datetime is the same as DCM)"]
[null,"DCM","20051109 23:59:59","20051125 23:59:59"]
[null,"TBF-TH","20051109","20051109","Energize period.  Note that there is no tariff period for the de-energized period as this is the first energize for a new site."]
[null,"TBF-DU","20051109","20051109"]
[null,"TBF-TH","20051110","20051125","Energize period"]
[null,"TBF-DU","20051110","20051125"]
[]
["Customer Switch - June 2","CSA","20050602",null,"Interpret to be the last day of the tariff period"]
[null,"TBF-TH","20050518","20050602"]
[null,"TBF-DU","20050518","20050602"]
[null,"DCM (During)","20050517 23:59:59","20050615 23:59:59"]
[null,"TBF-TH","20050603","20050615"]
[null,"TBF-DU","20050603","20050615"]

{"sheet":"ATCO Gas","index":4,"n_rows":133,"n_cols":5,"rows_kept":133,"cut":false,"hidden":false,"merged":[]}
["ATCO Gas","Note - Effective October 1, 2006; Presentation of Last Reading Datetime in DCMs and Last Reading Datetime in other transactions changed to actual deemed datetime of 23:59:59"]
["Last Updated: 2006-09-29"]
[]
["Situation","Transaction","Start Date","End Date"]
["Initial Energize (May 6, 2005 - 14:00)","SMC","20050507 00:00:00",null," (Last Reading Datetime is the same as DCM)"]
[null,"ENC","20050506 23:59:59"]
[null,"DCM","20050506 23:59:59","20050602 23:59:59"]
[null,"TBF-TH",20050507,20050602]
[null,"TBF-DU",20050507,20050602]
[]
["De-Enrollment (June 2, 2005)","DCM (pre)","20050428 23:59:59","20050530 23:59:59"]
[null,"SRR",null,null,"Received June 1, 2005"]
[null,"SRO","20050602 00:00:00"]
[null,"CSE","20050428 23:59:59","20050602 00:00:00"]
[null,"TBF-TH","20050531","20050601"]
[null,"TBF-DU","20050531","20050601"]
[]
["Enrollment switch (June 2, 2005)","SRR",null,null,"Received June 1, 2005"]
[null,"SRN","20050602 00:00:00"]
[null,"CSE","20050530 23:59:59","20050602 00:00:00"]
[null,"SMC","20050602 00:00:00",null,"(Last Reading Datetime is the same as DCM)"]
[null,"DCM (During)","20050530 23:59:59","20050629 23:59:59"]
[null,"TBF-TH","20050531","20050629"]
[null,"TBF-DU","20050531","20050629"]
[]
["Temp De-energize (July 1, 2005 at 14:00)","DEC","20050701 23:59:59"]
[null,"SMC","20050702 00:00:00",null,"(Last Reading Datetime is the same as DCM)"]
["De-Energize Reading","DCM","20050609 23:59:59","20050701 23:59:59"]
[null,"TBF-TH","20050610","20050701"]
[null,"TBF-DU","20050610","20050701"]
["Normal Reading","DCM","20050701 23:59:59","20050710 23:59:59"]
[null,"TBF-TH","20050702","20050710"]
[null,"TBF-DU","20050702","20050710"]
[]
["Energize (Aug 1, 2005 at 14:00)","ENC","20050801 23:59:59"]
[null,"SMC","20050802 00:00:00",null,"(Last Reading Datetime is the same as DCM)"]
["Energize Reading","DCM","20050710 23:59:59","20050801 23:59:59"]
[null,"TBF-TH","20050711","20050801"]
[null,"TBF-DU","20050711","20050801"]
["Normal Reading","DCM","20050801 23:59:59","20050810 23:59:59"]
[null,"TBF-TH","20050802","20050810"]
[null,"TBF-DU","20050802","20050810"]
[]
["Meter Switch C/C (Sept 1, 2005 at 14:00)","SMC","NA"]
["Old Meter - C","DCM","20050810 23:59:59","20050901 23:59:59"]
[null,"TBF-TH",null,null,"No TBF-TH"]
[null,"TBF-DU",null,null,"No TBF-DU"]
["New Meter - C","DCM","2005901 23:59:59","20050910 23:59:59"]
[null,"TBF-TH","20050811","20050910"]
[null,"TBF-DU","20050811","20050901"]
[null,"TBF-DU","20050902","20050910","Will have 2 DU records"]
[]
["Meter Swich C/I (Sept 1, 2005 at 14:00)","SMC",null,null,"NA"]
["Old Meter - C","DCM"]
[null,"TBF-TH"]
[null,"TBF-DU"]
["New Meter - I","DIM"]
[null,"TBF-TH"]
[null,"TBF-DU"]
[]
["Meter Switch I/C (Sept 1, 2005 at 14:00)","SMC",null,null,"NA"]
["Old Meter - I","DIM"]
[null,"TBF-TH"]
[null,"TBF-DU"]
["New Meter - C","DCM"]
[null,"TBF-TH"]
[null,"TBF-DU"]
[]
["Regular Normal Read (Oct 9, 2005 at 14:00)","DCM","20050910 23:59:59","20051009 23:59:59"]
[null,"TBF-TH","20050911","20051009"]
[null,"TBF-DU","20050911","20051009"]
["Next Normal Read (Nov 10 at 13:00)","DCM","20051009 23:59:59","20051110 23:59:59"]
[null,"TBF-TH","20051010","20051110"]
[null,"TBF-DU","20051010","20051110"]
[]
["Site Removal - Same day DEC C (Nov 7, 2005 at 14:00)","DEC",null,null,"AG will not use this transaction"]
[null,"SRE",null,null,"AG will never salvage a site until an SRO\nhas been sent"]
[null,"DCM"]
[null,"TBF-TH"]
[null,"TBF-DU"]
[]
["Site Removal - After DEC C (Nov 9, 2005 at 14:00)","DEC",null,null,"AG will not use this transaction"]
[null,"SRE",null,null,"AG will never salvage a site until an SRO\nhas been sent"]
[null,"DCM"]
[null,"TBF-TH"]
[null,"TBF-DU"]
[null,"TBF-TH"]
[null,"TBF-DU"]
[]
["Site Removal - Same day DEC I (Nov 7, 2005 at 14:00)","DEC",null,null,"AG will not use this transaction"]
[null,"SRE",null,null,"AG will never salvage a site until an SRO\nhas been sent"]
[null,"DIM"]
[null,"TBF-TH"]
[null,"TBF-DU"]
[]
["Site Removal - After DEC I (Nov 9, 2005 at 14:00)","DEC",null,null,"AG will not use this transaction"]
[null,"SRE",null,null,"AG will never salvage a site until an SRO\nhas been sent"]
[null,"DIM"]
[null,"TBF-TH"]
[null,"TBF-DU"]
[null,"TBF-TH"]
[null,"TBF-DU"]
[]
["De/Energize Same day C (Nov 17, 2005 at 14:00)","DEC",null,"20051117 23:59:59"]
[null,"SMC",null,"20051118 00:00:00","(Last Reading Datetime is the same as DCM)"]
["De-Energize Reading","DCM","NA"]
[null,"TBF-TH",null,null,"Will not trigger a TBF event"]
[null,"TBF-DU"]
["Energize Reading","DCM","20051110 23:59:59","20051117 23:59:59"]
[null,"TBF-TH",null,null,"Will not trigger a TBF event"]
[null,"TBF-DU"]
[{"$nulls":4},"Note:  The energize read is used because this is the latest read that we have for the day"]
[]
[]
[]
[]
[]
[]
["Create Site Nov 7, Enroll Nov 8, Energize Nov 9 at 14:00","SRN","20051109 00:00:00"]
[null,"ENC","20051109 23:59:59"]
[null,"SMC","20051110 00:00:00",null,"(Datetime Effective) (Last Reading Datetime is the same as DCM)"]
[null,"DCM","20051109 23:59:59","20051125 23:59:59"]
[null,"TBF-TH","20051109","20051109","Energize period.  Note that there is no tariff period for the de-energized period as this is the first energize for a new site."]
[null,"TBF-DU","20051109","20051109"]
[null,"TBF-TH","20051110","20051125","Energize period"]
[null,"TBF-DU","20051110","20051125"]
[]
["Customer Switch - June 2","CSA","20050602",null,"Interpret to be the last day of the tariff period"]
[null,"TBF-TH","20050518","20050602"]
[null,"TBF-DU","20050518","20050602"]
[null,"DCM (During)","20050517 23:59:59","20050615 23:59:59"]
[null,"TBF-TH","20050603","20050615"]
[null,"TBF-DU","20050603","20050615"]