{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Control","Account Codes","Maint","M-PWR ME Output","ConstantData","SummaryTemplate","OutputTemplate"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":31,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Control","index":0,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["M-PWR ME Billing Account Code Population Utility"]
[]
["Maintenance Tasks"]
["Please use this button to confirm ",null,null,null,null,"Please use this button to perform account code"]
["that that your account code data is correct",null,null,null,null,"maintenance (assign old data to new codes)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Please use this function to create a report containing M-PWR ME billing detail lines with their account code information"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Version 1.1.0"]

{"sheet":"Account Codes","index":1,"n_rows":1,"n_cols":27,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Product Key","Fund","Department","Unit","Sub Unit","Appropriation","Object","Activity","Task","Sub Task","Task Order","Mjr Program","Program","Program Period","Supplemental Account","Distribution","Rounding Flag","Custom Data 1","Custom Data 2","Custom Data 3","Notes","Validation Messages","Line Item","Attribute 1","Metric 1","Service Category","Service"]

{"sheet":"Maint","index":2,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Old Product Key","New Product Key","Result","Complete"]

{"sheet":"M-PWR ME Output","index":3,"n_rows":1,"n_cols":35,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Period","Consumer","Level 1","Service Category","Service","Service Full","Quantity","Rate","Charges","Dispute","Dispute ID","Attribute 1","Resource","Email Address","Metric 5","Attribute 2","Attribute 3","Attribute 4","Attribute 5","Metric 1","Metric 2","Metric 3","Metric 4","Line Item","Application","Application Description","Server","Database","Environment","Host","Location","Project","Task","Activity","Resource ID"]

{"sheet":"ConstantData","index":4,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Item","Value","Note"]
["Reference Data Worksheet","Account Codes","The sheet where your account code lookup data resides."]
["Bill Worksheet","M-PWR ME Output","The sheet where you paste the M-PWR ME Bill.350 report."]
["Product Key Column (1-Based)",19,"The index of the \"Product Key\" column on the \"M-PWR ME Output\" sheet. The value entered here is required to be a number greater than or equal to 1"]
["Missing Product Key Column (1-Based)",24,"If the data in the product key column is missing, then the value from this column will be used instead"]
["Charges Column (1-Based)",9,"The index of the \"Charges\" column on the \"M-PWR ME Output\" sheet. The value entered here is required to be a number greater than or equal to 1"]
["Rate Column (1-Based)",8,"The index of the \"Rate\" column on the \"M-PWR ME Output\" sheet. The value entered here is required to be a number greater than or equal to 1"]
["Bill Code  Column (1-Based)",2,"The index of the \"Consumer\" column on the \"M-PWR ME Output\" sheet. The value entered here is required to be a number greater than or equal to 1"]
["Bill Code Parse Rule","P","The method used to extract the bill code from the \"Consumer\" data. If left blank this will use the raw value. The value \"P\" will find the value in parentheses and extract it."]
["Output Worksheet","Data Output","Name of Worksheet that will be created where the output will be recorded"]
["TemplateOutput","OutputTemplate","Template worksheet of the output data.  This sheet contains the headings for the combined 350 report with account code and custom data."]
["Number of custom fields",3,"This represents the number of user defined fields in your Account Codes sheet. These fields will appear after the distribution in your output data."]
["Number of account fields",14,"This represents the number of standard accounting fields in your Account Codes sheet. These are the standard fields common to all agencies. These will start on the second column of the Account Codes worksheet and encompass this many fields"]
["Additional Columns to Include in Account Codes","24,12,20,4,5","Comma separated list of columns from the M-PWR output that will be appended to the hash information on the Account Codes Worksheet, in order to provide better information about the hash, allowing a simpler experience for the end user."]
["Quantity Column (1-Based)",7,"The index of the \"Quantity\" column on the \"M-PWR ME Output\" sheet. The value entered here is required to be a number greater than or equal to 1"]
["Create Summary","Y","Set to \"Y\" if you also want to produce the summary output worksheet"]
["SummaryTemplate","SummaryTemplate","Template worksheet of the summary data"]
["SummaryWorksheet","SummaryWorksheet","Name of Worksheet that will be created where the summary will be recorded"]
["SummaryHeaderLinesToSkip",6,"How many lines to keep blank for the summary header"]
["Maintenance Sheet","Maint","The name of the sheet used for account code copying/maintenance"]
["Internal Blank Value","(blank)","How blank account codes will show up in the output"]

{"sheet":"SummaryTemplate","index":5,"n_rows":7,"n_cols":17,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
["Line","Accounting String ","Fund","Department","Unit","Sub Unit","Appropriation","Object","Activity","Task","Sub Task","Task Order","Mjr Program","Program","Program Period","Supplemental Account","Total Amount"]

{"sheet":"OutputTemplate","index":6,"n_rows":1,"n_cols":55,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Period","Consumer","Level 1","Service Category","Service","Service Full","Quantity","Rate","Charges","Dispute","Dispute ID","Attribute 1","Resource","Email Address","Metric 5","Attribute 2","Attribute 3","Attribute 4","Attribute 5","Metric 1","Metric 2","Metric 3","Metric 4","Line Item","Application","Application Description","Server","Database","Environment","Host","Location","Project","Task","Activity","Resource ID","Product Key","BillCode","Fund","Department","Unit","Sub Unit","Appropriation","Object","Activity","Task","Sub Task","Task Order","Mjr Program","Program","Program Period","Supplemental Account","Distribution","Custom Data 1","Custom Data 2","Custom Data 3"]