{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["BL_SHORTFALL"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"BL_SHORTFALL","index":0,"n_rows":7,"n_cols":25,"rows_kept":7,"merged":[[4,0,4,9]]}
["Detail Shortfall Allocation Customer Report",{"$nulls":10},"Detail Shortfall Allocation Customer Report"]
["BL_SHORTFALL_<customer id>_<invoicedate>00_<version>.CSV",{"$nulls":10},"BL_SHORTFALL_<customer id>_<invoicedate>00_<version>.CSV"]
["<Customer Name>",{"$nulls":10},"<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT",{"$nulls":10},"Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT"]
[]
["ISO Charge Remittance Total (A)","UNSEC MMP Pool ISO Remittance Total (B)","UNSEC MMP Pool ISO Remittance Total Reduction (C)","UNSEC MMP ISO Remittance Total Reduction (D=(A/B)*C)","UNSEC NMMP Pool ISO Remittance Total (E)","UNSEC NMMP Pool ISO Remittance Total Reduction (F)","UNSEC NMMP ISO Remittance Total Reduction (G=(A/E)*F)","Pool ISO Remittance Total (H)","Pool ISO Remittance Total Reduction (I)","ISO Remittance Total Reduction (J=((A-(D+G))/H)*I)","Transmission Remittance Total (K)","UNSEC MMP Pool Transmission Remittance Total (L)","UNSEC MMP Pool Transmission Remittance Total Reduction (M)","UNSEC MMP Transmission Remittance Total Reduction (N=(K/L)*M)","UNSEC NMMP Pool Transmission Remittance Total (O)","UNSEC NMMP Pool Transmission Remittance Total Reduction (P)","UNSEC NMMP Transmission Remittance Total Reduction (Q=(K/O)*P)","Pool Transmission Remittance Total (R)","Pool Transmission Remittance Total Reduction (S)","Transmission Remittance Total Reduction (T=((K-(N+Q))/R)*S)","Remittance Total (U)","Pool Remittance Total (V)","Pool Excess Transmission Remittance Total Reduction (W)","Excess Transmission Remittance Total Reduction (X=(U/V)*W)","Total Remittance Reduction (Y=D+G+J+N+Q+T+X)"]
["$","$","$","$","$","$","$","$","$","$","$","$","$","$","$","$","$","$","$","$","$","$","$","$","$"]