{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Calculation","Allocation","Additional Information"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Calculation","index":0,"n_rows":7,"n_cols":17,"rows_kept":7,"merged":[[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,7,5,7]]}
["Standard Settlement Report Title"]
["SS_<report-code>_<customer id>_<settlement date>_<version>.CSV"]
["<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT"]
[{"$nulls":4},"Asset ID","Asset Name","Location ID","Location Name","Calculation"]
["Trading Date","Trading Interval","DUNS Number","DUNS Name",{"$nulls":4},"Calculation Description","Rate","Quantity","Total Asset Dollars","Allocation Share","Customer Dollars","Comments","Subaccount ID","Subaccount Name"]
["Date","Hour End","String","String","Number","String","Number","String","String","$","Number","$","%","$","String","String","String"]

{"sheet":"Allocation","index":1,"n_rows":7,"n_cols":16,"rows_kept":7,"merged":[[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,7,5,7]]}
["Standard Settlement Report Title"]
["SS_<report-code>_<customer id>_<settlement date>_<version>.CSV"]
["<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT"]
[{"$nulls":4},"Asset ID","Asset Name","Location ID","Location Name","Allocation"]
["Trading Date","Trading Interval","DUNS Number","DUNS Name",{"$nulls":4},"Allocation Description","Total Allocation Factor","Customer Allocation Factor","Total Dollars","Customer Dollars","Comments","Subaccount ID","Subaccount Name"]
["Date","Hour End","String","String","Number","String","Number","String","String","Number","Number","$","$","String","String","String"]

{"sheet":"Additional Information","index":2,"n_rows":1,"n_cols":1,"rows_kept":1}
["<Amplifying text related to report contents included with upload file>"]