{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Description","Report1","Report2","Report3","Report4"],"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,4]]}
["Distributor 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":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Performance Metrics V1.3"]
[]
["Distributor Report 1 - Currency of Tariff Bill File Content"]
[]
["Distributor ID","Metric ID","Reporting Period Type","Date","Actual Performance"]
["0020","1","M",20060131,0.94]
["0020","1","M",20060228,0.96]
["0020","1","M",20060331,0.98]
["0020","1","Q",20060331,{"$f":"AVERAGE(E6:E8)","v":0.96}]

{"sheet":"Report2","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Performance Metrics V1.3"]
[]
["Distributor Report 2 - File Completeness"]
[]
["Distributor ID","Metric ID","Reporting Period Type","Date","Actual Performance"]
["0020","2","M",20060131,0.96]
["0020","2","M",20060228,1]
["0020","2","M",20060331,0.98]
["0020","2","Q",20060331,{"$f":"AVERAGE(E6:E8)","v":0.98}]

{"sheet":"Report3","index":3,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Performance Metrics V1.3"]
[]
["Distributor Report 3 - Invalid File Rejections"]
[]
[]
["Distributor ID","Retailer ID","Metric ID","Reporting Period Type","Date","Rejection Type Code","Count"]
["0020","999999999","5","M",20060131,"6006",1]
["0020","999999999","5","M",20060131,"6027",1]
["0020","999999997","5","M",20060131,"6042",2]
["0020","999999998","5","M",20060228,"6006",2]
["0020","999999999","5","M",20060331,"6006",2]
["0020","999999998","5","M",20060331,"6006",3]
["0020","999999997","5","M",20060331,"6042",3]
["0020","999999999","5","Q",20060331,"6006",3]
["0020","999999999","5","Q",20060331,"6027",1]
["0020","999999998","5","Q",20060331,"6006",5]
["0020","999999997","5","Q",20060131,"6042",5]

{"sheet":"Report4","index":4,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Performance Metrics V1.3"]
[]
["Distributor Report 4 - Invalid File Disputes"]
[]
["Distributor ID","Retailer ID","Metric ID","Reporting Period Type","Date","Dispute Type Code","Count"]
["0020","999999999","8","M",20060131,"7006",1]
["0020","999999999","8","M",20060131,"7027",1]
["0020","999999997","8","M",20060131,"7042",2]
["0020","999999998","8","M",20060228,"7006",2]
["0020","999999999","8","M",20060228,"7006",2]
["0020","999999998","8","M",20060331,"7006",3]
["0020","999999997","8","M",20060331,"7042",3]
["0020","999999999","8","Q",20060331,"7006",3]
["0020","999999999","8","Q",20060331,"7027",1]
["0020","999999998","8","Q",20060331,"7006",5]
["0020","999999997","8","Q",20060131,"7042",5]