{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Description","Report1","Report2","Report3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"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":"Description","index":0,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[[2,0,2,6]]}
["Retailer Performance Metrics V1.3"]
["AUC Rule 004: Alberta Tariff Billing Code (V1.4)"]
["Each sheet in this workbook relates to the corresponding performance measure described in the word template.The purpose of this document is to provide guidelines that must be followed for reporting data. Completed documents are to be submitted to the AUC via the AUC’s IAR system."]

{"sheet":"Report1","index":1,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Performance Metrics V1.3"]
[]
["Retailer Report 1 - Reported File Rejections"]
[]
["Retailer ID","Distributor ID","Metric ID","Reporting Period Type","Date","Rejection Type Code","Count"]
["999999999","0010","4","M",20060131,"6006",1]
["999999999","0010","4","M",20060131,"6003",1]
["999999999","0020","4","M",20060131,"6001",1]
["999999999","0030","4","M",20060131,"6042",2]
["999999999","0040","4","M",20060131,"6003",1]
["999999999","0001","4","M",20060131,"6012",3]
["999999999","0010","4","M",20060228,"6006",2]
["999999999","0030","4","M",20060228,"6042",2]
["999999999","0040","4","M",20060228,"6003",3]
["999999999","0001","4","M",20060228,"6012",1]
["999999999","0003","4","M",20060228,"6004",1]
["999999999","0010","4","M",20060331,"6006",2]
["999999999","0030","4","M",20060331,"6042",2]
["999999999","0001","4","M",20060331,"6012",1]
["999999999","0003","4","M",20060331,"6004",3]
["999999999","0010","4","Q",20060331,"6006",5]
["999999999","0010","4","Q",20060331,"6003",1]
["999999999","0020","4","Q",20060331,"6001",1]
["999999999","0030","4","Q",20060331,"6042",6]
["999999999","0040","4","Q",20060331,"6003",4]
["999999999","0001","4","Q",20060331,"6012",5]
["999999999","0003","4","Q",20060331,"6004",4]

{"sheet":"Report2","index":2,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Performance Metrics V1.3"]
[]
["Retailer Report 2 - Reported tariff bill file disputes"]
[]
["Retailer ID","Distributor ID","Metric ID","Reporting Period Type","Date","Dispute Type Code","Count"]
["999999999","0010","6","M",20060131,"7006",1]
["999999999","0010","6","M",20060131,"7003",1]
["999999999","0020","6","M",20060131,"7001",1]
["999999999","0030","6","M",20060131,"7042",2]
["999999999","0040","6","M",20060131,"7003",1]
["999999999","0001","6","M",20060131,"7012",3]
["999999999","0010","6","M",20060228,"7006",2]
["999999999","0030","6","M",20060228,"7042",2]
["999999999","0040","6","M",20060228,"7003",3]
["999999999","0001","6","M",20060228,"7012",1]
["999999999","0003","6","M",20060228,"7004",1]
["999999999","0010","6","M",20060331,"7006",2]
["999999999","0030","6","M",20060331,"7042",2]
["999999999","0001","6","M",20060331,"7012",1]
["999999999","0003","6","M",20060331,"7004",3]
["999999999","0010","6","Q",20060331,"7006",5]
["999999999","0010","6","Q",20060331,"7003",1]
["999999999","0020","6","Q",20060331,"7001",1]
["999999999","0030","6","Q",20060331,"7042",6]
["999999999","0040","6","Q",20060331,"7003",4]
["999999999","0001","6","Q",20060331,"7012",5]
["999999999","0003","6","Q",20060331,"7004",4]

{"sheet":"Report3","index":3,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Performance Metrics V1.3"]
[]
["Retailer Report 3 - Reported distinct tariff bill period disputes"]
[]
["Retailer ID","Distributor ID","Metric ID","Reporting Period Type","Date","Dispute Type Code","Count"]
["999999999","0010","7","M",20060131,"7006",1]
["999999999","0010","7","M",20060131,"7003",1]
["999999999","0020","7","M",20060131,"7001",1]
["999999999","0030","7","M",20060131,"7042",2]
["999999999","0040","7","M",20060131,"7003",1]
["999999999","0001","7","M",20060131,"7012",3]
["999999999","0010","7","M",20060228,"7006",2]
["999999999","0030","7","M",20060228,"7042",2]
["999999999","0040","7","M",20060228,"7003",3]
["999999999","0001","7","M",20060228,"7012",1]
["999999999","0003","7","M",20060228,"7004",1]
["999999999","0010","7","M",20060331,"7006",2]
["999999999","0030","7","M",20060331,"7042",2]
["999999999","0001","7","M",20060331,"7012",1]
["999999999","0003","7","M",20060331,"7004",3]
["999999999","0010","7","Q",20060331,"7006",5]
["999999999","0010","7","Q",20060331,"7003",1]
["999999999","0020","7","Q",20060331,"7001",1]
["999999999","0030","7","Q",20060331,"7042",6]
["999999999","0040","7","Q",20060331,"7003",4]
["999999999","0001","7","Q",20060331,"7012",5]
["999999999","0003","7","Q",20060331,"7004",4]