{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Cover","Model information and guide","FAST colour guide","Inputs -->","Inputs","Calcs-->","Time","Calculations","Outputs-->","Working capital costs","Integrity checks-->","Check"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":8,"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":"Cover","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Model information and guide","index":1,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[10,2,10,7]]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Model information and guide"}]
[]
[null,"Model name:","REC22 - September 2022 consultaiton: Working capital model"]
[null,"Version number:",1]
[null,"Filename:",{"$f":" MID(CELL(\"filename\"), FIND(\"[\", CELL(\"filename\"), 1) + 1, FIND(\"]\", CELL(\"filename\"), 1) - FIND(\"[\", CELL(\"filename\"), 1) - 1)","v":"REC22 September consultation - Working capital model.xlsm"}]
[null,"Date:","2022-09-01"]
[null,"Author: ","Samuel Adams - Associate, Economist"]
[null,"Author contact information:","samuel.adams@ofwat.gov.uk"]
[]
[]
[null,"Summary of model:","The REC22 working capital model considers the cost to a Retailer of financing working capital requirements for a notional Group One customer. The modelled working capital (W.C.) requirements and associated cost is to be considered alongside the proposed allowed net margin of 2%. \n\nThe spreadsheet model is set over 3 notional financial years (01 April to 31 March) – FY-1, FY, and FY+1. Please note that the spreadsheet model this is represented by the period 01/03/2023 to 30/06/2026, this is for illustrative purposes only and should not be viewed as a calculation of working capital costs during this period. The modelling period is set over three financial years to incorporate the opening and closing balance sheet position of the notional customer given the model assumes an opening outstanding balance of zero in period FY-1. Our assessment of working capital costs is determined in financial year FY as we view this as representative of a BAU payment schedule that would be expected from an established Group One customer that reflects outstanding balances due (assuming no changes to pricing and consumption in the period). Therefore, the financial years FY-1 and FY+1 should not to be considered as representative of our estimate of working capital costs.\n\nThis model is used to consider a range of working capital costs that an efficient Retailer may incur in serving a Group One customer. Working capital is financed with respect to an assumed annual financing cost that is used to determine the monthly working capital cost using the relevant monthly compound interest rate.  A range of output reflecting a varied annual financing cost is included in the accompanying consultation document. This model considers a single assumed financing cost for illustrative purposes only. Section A4.6.1 in appendix 1 of the REC22 September consultation document provides a range of modelled working capital costs, dependent on the assumed annual financing cost.\n\nThe model incorporates assumptions about the notional Group One customer's billing arrangements and the timing of Retailer payment of wholesale charges. The model assumes the following:\n1. The Group One customer is billed quarterly in arrears. \n2. The Retailer pays wholesale charges one month in advance. \n\nTo account for differing customer payment dates we have assumed 50% of the scheduled payment is paid on the 15th day of each month and 50% is paid on the last day of each month. \n\nThe model incorporates an assumption of an outstanding debt profile for an efficient Retailer. As such, model assumes 84% of the payment due from the notional customer is received within 90 days of the billing being issued to the customer. The remaining 16% of revenue is excluded from our modelled working capital costs. Our model considers the value of debt up to 90 days only as we have assumed that an efficient Retailer would collect payment within 90 days.\n\nDetails of our methodology, an example calculation, and a guide to the sheets in this Excel model are included in section A4.6 in appendix 1 of the REC22 September consultation document."]
[]
[null,null,"Follow link >>","https://www.ofwat.gov.uk/consultation/business-retail-market-2021-22-review-of-the-retail-exit-code-consultation-on-proposals"]
[]
[]
[null,"Error check status",{"$f":" Check!C$8","v":0}]
[]
[]
["END"]

{"sheet":"FAST colour guide","index":2,"n_rows":55,"n_cols":7,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"FAST colour guide"}]
[]
["Cell / Row / Column colour"]
[]
[null,"Font colour"]
[null,null,null,null,"Ofwat second blue text (no shade)",null,"Imported from another sheet/section"]
[]
[null,null,null,null,"Ofwat red text (no shade)",null,"Exported to another sheet/section *"]
[]
[null,null,null,null,"Black text (no shade)",null,"Neither imported nor exported"]
[]
[null,null,null,null,"* Except from input sheets (sheets with 'Inp' prefix)"]
[]
[null,null,null,null,"Ofwat dark green (no shade)",null,"Documentation"]
[]
[null,"Font and shade combinations"]
[null,null,null,null,"Black text + light yellow shade",null,"Inputs"]
[]
[null,null,null,null,"Black text + light grey shade on ENTIRE row",null,"Within-worksheet counter-flow "]
[]
[null,null,null,null,"Ofwat second blue text + light grey shade",null,"Between-worksheet counter-flow "]
[]
[null,null,null,null,"Light blue",null,"Stored/dead/hard coded outputs"]
[]
[null,null,null,null,"White text (Franklin Gothic Demi) + Ofwat purple shade",null,"Warning text"]
[]
[null,null,null,null,0,null,"Conditional formatting for error checks*"]
[]
[null,null,null,null,"* returns green when value is zero. For all other values it returns red"]
[]
[null,"Other"]
[null,null,null,null,"Empty cell with light grey shade",null,"Empty cells being referenced/used"]
[]
[null,null,null,null,"Entire row/column with blue text + Ofwat light blue shade",null,"Section separator"]
[]
[null,"Checks and administration"]
[]
[null,null,null,null,"Lemon shade",null,"Values or logic to be reviewed/discussed"]
[]
[null,"Worksheet tab colour coding"]
[]
[null,null,null,null,"Ofwat yellow – 50%",null,"Input sheets"]
[]
[null,null,null,null,"Ofwat grey – 33%",null,"Documentation and calculation cheets"]
[]
[null,null,null,null,"Second blue – 66%",null,"Cached results sheets"]
[]
[null,null,null,null,"Ofwat purple – 66%",null,"Quality control"]
[]
[null,null,null,null,"Ofwat yellow – 100%",null,"Temporary"]
[]
[null,null,null,null,"Ofwat green – 66%",null,"Outputs"]
[]
[]
["END"]

{"sheet":"Inputs -->","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Inputs","index":4,"n_rows":76,"n_cols":50,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Inputs"}]
[null,null,null,null,{"$f":" Time!E$24","v":"Model Period BEG"},null,null,null,null,null,{"$f":" Time!K$24","v":"2023-03-01"},{"$f":" Time!L$24","v":"2023-04-01"},{"$f":" Time!M$24","v":"2023-05-01"},{"$f":" Time!N$24","v":"2023-06-01"},{"$f":" Time!O$24","v":"2023-07-01"},{"$f":" Time!P$24","v":"2023-08-01"},{"$f":" Time!Q$24","v":"2023-09-01"},{"$f":" Time!R$24","v":"2023-10-01"},{"$f":" Time!S$24","v":"2023-11-01"},{"$f":" Time!T$24","v":"2023-12-01"},{"$f":" Time!U$24","v":"2024-01-01"},{"$f":" Time!V$24","v":"2024-02-01"},{"$f":" Time!W$24","v":"2024-03-01"},{"$f":" Time!X$24","v":"2024-04-01"},{"$f":" Time!Y$24","v":"2024-05-01"},{"$f":" Time!Z$24","v":"2024-06-01"},{"$f":" Time!AA$24","v":"2024-07-01"},{"$f":" Time!AB$24","v":"2024-08-01"},{"$f":" Time!AC$24","v":"2024-09-01"},{"$f":" Time!AD$24","v":"2024-10-01"},{"$f":" Time!AE$24","v":"2024-11-01"},{"$f":" Time!AF$24","v":"2024-12-01"},{"$f":" Time!AG$24","v":"2025-01-01"},{"$f":" Time!AH$24","v":"2025-02-01"},{"$f":" Time!AI$24","v":"2025-03-01"},{"$f":" Time!AJ$24","v":"2025-04-01"},{"$f":" Time!AK$24","v":"2025-05-01"},{"$f":" Time!AL$24","v":"2025-06-01"},{"$f":" Time!AM$24","v":"2025-07-01"},{"$f":" Time!AN$24","v":"2025-08-01"},{"$f":" Time!AO$24","v":"2025-09-01"},{"$f":" Time!AP$24","v":"2025-10-01"},{"$f":" Time!AQ$24","v":"2025-11-01"},{"$f":" Time!AR$24","v":"2025-12-01"},{"$f":" Time!AS$24","v":"2026-01-01"},{"$f":" Time!AT$24","v":"2026-02-01"},{"$f":" Time!AU$24","v":"2026-03-01"},{"$f":" Time!AV$24","v":"2026-04-01"},{"$f":" Time!AW$24","v":"2026-05-01"},{"$f":" Time!AX$24","v":"2026-06-01"}]
[null,null,null,null,{"$f":" Time!E$27","v":"Model Period END"},{"$f":" Check!F$8","v":0},"Error chks",null,null,null,{"$f":" Time!K$27","v":"2023-03-31"},{"$f":" Time!L$27","v":"2023-04-30"},{"$f":" Time!M$27","v":"2023-05-31"},{"$f":" Time!N$27","v":"2023-06-30"},{"$f":" Time!O$27","v":"2023-07-31"},{"$f":" Time!P$27","v":"2023-08-31"},{"$f":" Time!Q$27","v":"2023-09-30"},{"$f":" Time!R$27","v":"2023-10-31"},{"$f":" Time!S$27","v":"2023-11-30"},{"$f":" Time!T$27","v":"2023-12-31"},{"$f":" Time!U$27","v":"2024-01-31"},{"$f":" Time!V$27","v":"2024-02-29"},{"$f":" Time!W$27","v":"2024-03-31"},{"$f":" Time!X$27","v":"2024-04-30"},{"$f":" Time!Y$27","v":"2024-05-31"},{"$f":" Time!Z$27","v":"2024-06-30"},{"$f":" Time!AA$27","v":"2024-07-31"},{"$f":" Time!AB$27","v":"2024-08-31"},{"$f":" Time!AC$27","v":"2024-09-30"},{"$f":" Time!AD$27","v":"2024-10-31"},{"$f":" Time!AE$27","v":"2024-11-30"},{"$f":" Time!AF$27","v":"2024-12-31"},{"$f":" Time!AG$27","v":"2025-01-31"},{"$f":" Time!AH$27","v":"2025-02-28"},{"$f":" Time!AI$27","v":"2025-03-31"},{"$f":" Time!AJ$27","v":"2025-04-30"},{"$f":" Time!AK$27","v":"2025-05-31"},{"$f":" Time!AL$27","v":"2025-06-30"},{"$f":" Time!AM$27","v":"2025-07-31"},{"$f":" Time!AN$27","v":"2025-08-31"},{"$f":" Time!AO$27","v":"2025-09-30"},{"$f":" Time!AP$27","v":"2025-10-31"},{"$f":" Time!AQ$27","v":"2025-11-30"},{"$f":" Time!AR$27","v":"2025-12-31"},{"$f":" Time!AS$27","v":"2026-01-31"},{"$f":" Time!AT$27","v":"2026-02-28"},{"$f":" Time!AU$27","v":"2026-03-31"},{"$f":" Time!AV$27","v":"2026-04-30"},{"$f":" Time!AW$27","v":"2026-05-31"},{"$f":" Time!AX$27","v":"2026-06-30"}]
[null,null,null,null,{"$f":" Time!E$100","v":"Period reference"},null,null,null,null,null,{"$f":" Time!K$100","v":"Pre model period"},{"$f":" Time!L$100","v":"Pre model period"},{"$f":" Time!M$100","v":"Pre model period"},{"$f":" Time!N$100","v":"Pre model period"},{"$f":" Time!O$100","v":"Pre model period"},{"$f":" Time!P$100","v":"Pre model period"},{"$f":" Time!Q$100","v":"Pre model period"},{"$f":" Time!R$100","v":"Pre model period"},{"$f":" Time!S$100","v":"Pre model period"},{"$f":" Time!T$100","v":"Pre model period"},{"$f":" Time!U$100","v":"Pre model period"},{"$f":" Time!V$100","v":"Pre model period"},{"$f":" Time!W$100","v":"Pre model period"},{"$f":" Time!X$100","v":"W.C. model period"},{"$f":" Time!Y$100","v":"W.C. model period"},{"$f":" Time!Z$100","v":"W.C. model period"},{"$f":" Time!AA$100","v":"W.C. model period"},{"$f":" Time!AB$100","v":"W.C. model period"},{"$f":" Time!AC$100","v":"W.C. model period"},{"$f":" Time!AD$100","v":"W.C. model period"},{"$f":" Time!AE$100","v":"W.C. model period"},{"$f":" Time!AF$100","v":"W.C. model period"},{"$f":" Time!AG$100","v":"W.C. model period"},{"$f":" Time!AH$100","v":"W.C. model period"},{"$f":" Time!AI$100","v":"W.C. model period"},{"$f":" Time!AJ$100","v":"Post model period"},{"$f":" Time!AK$100","v":"Post model period"},{"$f":" Time!AL$100","v":"Post model period"},{"$f":" Time!AM$100","v":"Post model period"},{"$f":" Time!AN$100","v":"Post model period"},{"$f":" Time!AO$100","v":"Post model period"},{"$f":" Time!AP$100","v":"Post model period"},{"$f":" Time!AQ$100","v":"Post model period"},{"$f":" Time!AR$100","v":"Post model period"},{"$f":" Time!AS$100","v":"Post model period"},{"$f":" Time!AT$100","v":"Post model period"},{"$f":" Time!AU$100","v":"Post model period"},{"$f":" Time!AV$100","v":"Post model period"},{"$f":" Time!AW$100","v":"Post model period"},{"$f":" Time!AX$100","v":"Post model period"}]
[null,null,null,null,{"$f":" Time!E$91","v":"Financial Year Reference"},null,null,null,null,null,{"$f":" Time!K$91","v":"FY-2"},{"$f":" Time!L$91","v":"FY-1"},{"$f":" Time!M$91","v":"FY-1"},{"$f":" Time!N$91","v":"FY-1"},{"$f":" Time!O$91","v":"FY-1"},{"$f":" Time!P$91","v":"FY-1"},{"$f":" Time!Q$91","v":"FY-1"},{"$f":" Time!R$91","v":"FY-1"},{"$f":" Time!S$91","v":"FY-1"},{"$f":" Time!T$91","v":"FY-1"},{"$f":" Time!U$91","v":"FY-1"},{"$f":" Time!V$91","v":"FY-1"},{"$f":" Time!W$91","v":"FY-1"},{"$f":" Time!X$91","v":"FY"},{"$f":" Time!Y$91","v":"FY"},{"$f":" Time!Z$91","v":"FY"},{"$f":" Time!AA$91","v":"FY"},{"$f":" Time!AB$91","v":"FY"},{"$f":" Time!AC$91","v":"FY"},{"$f":" Time!AD$91","v":"FY"},{"$f":" Time!AE$91","v":"FY"},{"$f":" Time!AF$91","v":"FY"},{"$f":" Time!AG$91","v":"FY"},{"$f":" Time!AH$91","v":"FY"},{"$f":" Time!AI$91","v":"FY"},{"$f":" Time!AJ$91","v":"FY+1"},{"$f":" Time!AK$91","v":"FY+1"},{"$f":" Time!AL$91","v":"FY+1"},{"$f":" Time!AM$91","v":"FY+1"},{"$f":" Time!AN$91","v":"FY+1"},{"$f":" Time!AO$91","v":"FY+1"},{"$f":" Time!AP$91","v":"FY+1"},{"$f":" Time!AQ$91","v":"FY+1"},{"$f":" Time!AR$91","v":"FY+1"},{"$f":" Time!AS$91","v":"FY+1"},{"$f":" Time!AT$91","v":"FY+1"},{"$f":" Time!AU$91","v":"FY+1"},{"$f":" Time!AV$91","v":"FY+2"},{"$f":" Time!AW$91","v":"FY+2"},{"$f":" Time!AX$91","v":"FY+2"}]
[null,null,null,null,{"$f":" Time!E$11","v":"Model column counter"},"Constant","Unit","Total",null,null,{"$f":" Time!K$11","v":1},{"$f":" Time!L$11","v":2},{"$f":" Time!M$11","v":3},{"$f":" Time!N$11","v":4},{"$f":" Time!O$11","v":5},{"$f":" Time!P$11","v":6},{"$f":" Time!Q$11","v":7},{"$f":" Time!R$11","v":8},{"$f":" Time!S$11","v":9},{"$f":" Time!T$11","v":10},{"$f":" Time!U$11","v":11},{"$f":" Time!V$11","v":12},{"$f":" Time!W$11","v":13},{"$f":" Time!X$11","v":14},{"$f":" Time!Y$11","v":15},{"$f":" Time!Z$11","v":16},{"$f":" Time!AA$11","v":17},{"$f":" Time!AB$11","v":18},{"$f":" Time!AC$11","v":19},{"$f":" Time!AD$11","v":20},{"$f":" Time!AE$11","v":21},{"$f":" Time!AF$11","v":22},{"$f":" Time!AG$11","v":23},{"$f":" Time!AH$11","v":24},{"$f":" Time!AI$11","v":25},{"$f":" Time!AJ$11","v":26},{"$f":" Time!AK$11","v":27},{"$f":" Time!AL$11","v":28},{"$f":" Time!AM$11","v":29},{"$f":" Time!AN$11","v":30},{"$f":" Time!AO$11","v":31},{"$f":" Time!AP$11","v":32},{"$f":" Time!AQ$11","v":33},{"$f":" Time!AR$11","v":34},{"$f":" Time!AS$11","v":35},{"$f":" Time!AT$11","v":36},{"$f":" Time!AU$11","v":37},{"$f":" Time!AV$11","v":38},{"$f":" Time!AW$11","v":39},{"$f":" Time!AX$11","v":40}]
[]
["TIME"]
[]
[null,"Total Modelling Period"]
[null,null,null,null,"First date of modelling period","2023-03-01","date"]
[null,null,null,null,"Length of modelling period",39,"months"]
[null,null,null,null,"Last modelling period",{"$f":" DATE( YEAR(F11), MONTH( F11 )  + F12 + 1, DAY( F11 )  - 1 )","v":"2026-06-30"},"date"]
[]
[null,"Working Capital Modelling Period"]
[null,null,null,null,"Working capital modelling period start date (FY)",{"$f":" DATE( YEAR( F11 ) + 1, MONTH( F11 ) + 1, DAY( F11 ) )","v":"2024-04-01"},"date"]
[null,null,null,null,"Last working capital modelling period date (FY)",{"$f":" DATE( YEAR(F16) + 1, MONTH( F16 ), DAY( F16 ) - 1 )","v":"2025-03-31"},"date"]
[]
[null,"Pre Working Capital Modelling Period"]
[null,null,null,null,"Financial year before the working capital modelling period (FY-1)",{"$f":" DATE( YEAR( F16 ), MONTH( F16 ) - 12, DAY( F16 ) )","v":"2023-04-01"},"date"]
[null,null,null,null,"Last date of the modelling period (FY-1)",{"$f":" DATE( YEAR( F20 ) + 1, MONTH( F20 ), DAY( F20 ) -1)","v":"2024-03-31"},"date"]
[]
[null,"Post Working Capital Modelling Period"]
[null,null,null,null,"Financial year after the working capital modelling period (FY+1)",{"$f":" DATE( YEAR( F16 ) + 1, MONTH( F16 ), DAY( F16 ) )","v":"2025-04-01"},"date"]
[]
[]
["CUSTOMER PAYMENT INPUTS"]
[]
[null,"Customer Billing Inputs"]
[null,null,null,null,"Annual bill",500,"£"]
[null,null,null,null,"Wholesale charge proportion",0.9,"%"]
[null,null,null,null,"Retail cost proportion",0.1,"%"]
[]
[null,null,null,null,"Annual wholesale charge",{"$f":" - F$30 * F31","v":-450},"£"]
[null,null,null,null,"Annual retail cost",{"$f":" -  F$30 * F32","v":-50},"£"]
[]
[null,null,null,null,"Monthly wholesale charge",{"$f":" F34 / 12","v":-37.5},"£"]
[null,null,null,null,"Monthly retail cost",{"$f":" F35 / 12","v":-4.166666666666667},"£"]
[]
[null,"Customer Billing Period"]
[null,null,null,null,"3 year payment period",36,"months"]
[]
[]
["CUSTOMER PAYMENT TIMING INPUT"]
[]
[null,null,null,null,"Number of customer payments in a financial year",4,"#"]
[]
[null,null,null,null,"Customer payment month 1",6,"month #"]
[null,null,null,null,"Customer payment month 2",9,"month #"]
[null,null,null,null,"Customer payment month 3",12,"month #"]
[null,null,null,null,"Customer payment month 4",3,"month #"]
[]
[null,null,null,null,"Proportion of payment received on day 15 of the month",0.5,"%"]
[]
[]
["OUTSTANDING DEBT PROFILE"]
[]
[null,null,null,null,"% revenue collected after 30 days",0.52,"%"]
[null,null,null,null,"% revenue collected after 60 days",0.68,"%"]
[null,null,null,null,"% revenue collected after 90 days",0.84,"%"]
[]
[]
["FINANCING COST INPUT"]
[]
[null,null,null,null,"Annual financing cost",0.05,"%"]
[null,null,null,null,"Monthly interest rate (monthly compound interest rate)",{"$f":" ( 1+ F65 ) ^ ( 1 / 12) - 1","v":4.0741237836483535E-3},"%"]
[]
[]
["FINANCIAL YEAR PARAMETERS"]
[]
[null,null,null,null,"Financial Year End Month Number",3,"month #"]
[]
[null,null,null,null,"Number of months in the financial year",12,"months"]
[]
[]
["END"]

{"sheet":"Calcs-->","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Time","index":6,"n_rows":111,"n_cols":50,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Time"}]
[null,null,null,null,{"$f":" Time!E$24","v":"Model Period BEG"},null,null,null,null,null,{"$f":" Time!K$24","v":"2023-03-01"},{"$f":" Time!L$24","v":"2023-04-01"},{"$f":" Time!M$24","v":"2023-05-01"},{"$f":" Time!N$24","v":"2023-06-01"},{"$f":" Time!O$24","v":"2023-07-01"},{"$f":" Time!P$24","v":"2023-08-01"},{"$f":" Time!Q$24","v":"2023-09-01"},{"$f":" Time!R$24","v":"2023-10-01"},{"$f":" Time!S$24","v":"2023-11-01"},{"$f":" Time!T$24","v":"2023-12-01"},{"$f":" Time!U$24","v":"2024-01-01"},{"$f":" Time!V$24","v":"2024-02-01"},{"$f":" Time!W$24","v":"2024-03-01"},{"$f":" Time!X$24","v":"2024-04-01"},{"$f":" Time!Y$24","v":"2024-05-01"},{"$f":" Time!Z$24","v":"2024-06-01"},{"$f":" Time!AA$24","v":"2024-07-01"},{"$f":" Time!AB$24","v":"2024-08-01"},{"$f":" Time!AC$24","v":"2024-09-01"},{"$f":" Time!AD$24","v":"2024-10-01"},{"$f":" Time!AE$24","v":"2024-11-01"},{"$f":" Time!AF$24","v":"2024-12-01"},{"$f":" Time!AG$24","v":"2025-01-01"},{"$f":" Time!AH$24","v":"2025-02-01"},{"$f":" Time!AI$24","v":"2025-03-01"},{"$f":" Time!AJ$24","v":"2025-04-01"},{"$f":" Time!AK$24","v":"2025-05-01"},{"$f":" Time!AL$24","v":"2025-06-01"},{"$f":" Time!AM$24","v":"2025-07-01"},{"$f":" Time!AN$24","v":"2025-08-01"},{"$f":" Time!AO$24","v":"2025-09-01"},{"$f":" Time!AP$24","v":"2025-10-01"},{"$f":" Time!AQ$24","v":"2025-11-01"},{"$f":" Time!AR$24","v":"2025-12-01"},{"$f":" Time!AS$24","v":"2026-01-01"},{"$f":" Time!AT$24","v":"2026-02-01"},{"$f":" Time!AU$24","v":"2026-03-01"},{"$f":" Time!AV$24","v":"2026-04-01"},{"$f":" Time!AW$24","v":"2026-05-01"},{"$f":" Time!AX$24","v":"2026-06-01"}]
[null,null,null,null,{"$f":" Time!E$27","v":"Model Period END"},{"$f":" Check!F$8","v":0},"Error chks",null,null,null,{"$f":" Time!K$27","v":"2023-03-31"},{"$f":" Time!L$27","v":"2023-04-30"},{"$f":" Time!M$27","v":"2023-05-31"},{"$f":" Time!N$27","v":"2023-06-30"},{"$f":" Time!O$27","v":"2023-07-31"},{"$f":" Time!P$27","v":"2023-08-31"},{"$f":" Time!Q$27","v":"2023-09-30"},{"$f":" Time!R$27","v":"2023-10-31"},{"$f":" Time!S$27","v":"2023-11-30"},{"$f":" Time!T$27","v":"2023-12-31"},{"$f":" Time!U$27","v":"2024-01-31"},{"$f":" Time!V$27","v":"2024-02-29"},{"$f":" Time!W$27","v":"2024-03-31"},{"$f":" Time!X$27","v":"2024-04-30"},{"$f":" Time!Y$27","v":"2024-05-31"},{"$f":" Time!Z$27","v":"2024-06-30"},{"$f":" Time!AA$27","v":"2024-07-31"},{"$f":" Time!AB$27","v":"2024-08-31"},{"$f":" Time!AC$27","v":"2024-09-30"},{"$f":" Time!AD$27","v":"2024-10-31"},{"$f":" Time!AE$27","v":"2024-11-30"},{"$f":" Time!AF$27","v":"2024-12-31"},{"$f":" Time!AG$27","v":"2025-01-31"},{"$f":" Time!AH$27","v":"2025-02-28"},{"$f":" Time!AI$27","v":"2025-03-31"},{"$f":" Time!AJ$27","v":"2025-04-30"},{"$f":" Time!AK$27","v":"2025-05-31"},{"$f":" Time!AL$27","v":"2025-06-30"},{"$f":" Time!AM$27","v":"2025-07-31"},{"$f":" Time!AN$27","v":"2025-08-31"},{"$f":" Time!AO$27","v":"2025-09-30"},{"$f":" Time!AP$27","v":"2025-10-31"},{"$f":" Time!AQ$27","v":"2025-11-30"},{"$f":" Time!AR$27","v":"2025-12-31"},{"$f":" Time!AS$27","v":"2026-01-31"},{"$f":" Time!AT$27","v":"2026-02-28"},{"$f":" Time!AU$27","v":"2026-03-31"},{"$f":" Time!AV$27","v":"2026-04-30"},{"$f":" Time!AW$27","v":"2026-05-31"},{"$f":" Time!AX$27","v":"2026-06-30"}]
[null,null,null,null,{"$f":" Time!E$100","v":"Period reference"},null,null,null,null,null,{"$f":" Time!K$100","v":"Pre model period"},{"$f":" Time!L$100","v":"Pre model period"},{"$f":" Time!M$100","v":"Pre model period"},{"$f":" Time!N$100","v":"Pre model period"},{"$f":" Time!O$100","v":"Pre model period"},{"$f":" Time!P$100","v":"Pre model period"},{"$f":" Time!Q$100","v":"Pre model period"},{"$f":" Time!R$100","v":"Pre model period"},{"$f":" Time!S$100","v":"Pre model period"},{"$f":" Time!T$100","v":"Pre model period"},{"$f":" Time!U$100","v":"Pre model period"},{"$f":" Time!V$100","v":"Pre model period"},{"$f":" Time!W$100","v":"Pre model period"},{"$f":" Time!X$100","v":"W.C. model period"},{"$f":" Time!Y$100","v":"W.C. model period"},{"$f":" Time!Z$100","v":"W.C. model period"},{"$f":" Time!AA$100","v":"W.C. model period"},{"$f":" Time!AB$100","v":"W.C. model period"},{"$f":" Time!AC$100","v":"W.C. model period"},{"$f":" Time!AD$100","v":"W.C. model period"},{"$f":" Time!AE$100","v":"W.C. model period"},{"$f":" Time!AF$100","v":"W.C. model period"},{"$f":" Time!AG$100","v":"W.C. model period"},{"$f":" Time!AH$100","v":"W.C. model period"},{"$f":" Time!AI$100","v":"W.C. model period"},{"$f":" Time!AJ$100","v":"Post model period"},{"$f":" Time!AK$100","v":"Post model period"},{"$f":" Time!AL$100","v":"Post model period"},{"$f":" Time!AM$100","v":"Post model period"},{"$f":" Time!AN$100","v":"Post model period"},{"$f":" Time!AO$100","v":"Post model period"},{"$f":" Time!AP$100","v":"Post model period"},{"$f":" Time!AQ$100","v":"Post model period"},{"$f":" Time!AR$100","v":"Post model period"},{"$f":" Time!AS$100","v":"Post model period"},{"$f":" Time!AT$100","v":"Post model period"},{"$f":" Time!AU$100","v":"Post model period"},{"$f":" Time!AV$100","v":"Post model period"},{"$f":" Time!AW$100","v":"Post model period"},{"$f":" Time!AX$100","v":"Post model period"}]
[null,null,null,null,{"$f":" Time!E$91","v":"Financial Year Reference"},null,null,null,null,null,{"$f":" Time!K$91","v":"FY-2"},{"$f":" Time!L$91","v":"FY-1"},{"$f":" Time!M$91","v":"FY-1"},{"$f":" Time!N$91","v":"FY-1"},{"$f":" Time!O$91","v":"FY-1"},{"$f":" Time!P$91","v":"FY-1"},{"$f":" Time!Q$91","v":"FY-1"},{"$f":" Time!R$91","v":"FY-1"},{"$f":" Time!S$91","v":"FY-1"},{"$f":" Time!T$91","v":"FY-1"},{"$f":" Time!U$91","v":"FY-1"},{"$f":" Time!V$91","v":"FY-1"},{"$f":" Time!W$91","v":"FY-1"},{"$f":" Time!X$91","v":"FY"},{"$f":" Time!Y$91","v":"FY"},{"$f":" Time!Z$91","v":"FY"},{"$f":" Time!AA$91","v":"FY"},{"$f":" Time!AB$91","v":"FY"},{"$f":" Time!AC$91","v":"FY"},{"$f":" Time!AD$91","v":"FY"},{"$f":" Time!AE$91","v":"FY"},{"$f":" Time!AF$91","v":"FY"},{"$f":" Time!AG$91","v":"FY"},{"$f":" Time!AH$91","v":"FY"},{"$f":" Time!AI$91","v":"FY"},{"$f":" Time!AJ$91","v":"FY+1"},{"$f":" Time!AK$91","v":"FY+1"},{"$f":" Time!AL$91","v":"FY+1"},{"$f":" Time!AM$91","v":"FY+1"},{"$f":" Time!AN$91","v":"FY+1"},{"$f":" Time!AO$91","v":"FY+1"},{"$f":" Time!AP$91","v":"FY+1"},{"$f":" Time!AQ$91","v":"FY+1"},{"$f":" Time!AR$91","v":"FY+1"},{"$f":" Time!AS$91","v":"FY+1"},{"$f":" Time!AT$91","v":"FY+1"},{"$f":" Time!AU$91","v":"FY+1"},{"$f":" Time!AV$91","v":"FY+2"},{"$f":" Time!AW$91","v":"FY+2"},{"$f":" Time!AX$91","v":"FY+2"}]
[null,null,null,null,{"$f":" Time!E$11","v":"Model column counter"},"Constant","Unit","Total",null,null,{"$f":" Time!K$11","v":1},{"$f":" Time!L$11","v":2},{"$f":" Time!M$11","v":3},{"$f":" Time!N$11","v":4},{"$f":" Time!O$11","v":5},{"$f":" Time!P$11","v":6},{"$f":" Time!Q$11","v":7},{"$f":" Time!R$11","v":8},{"$f":" Time!S$11","v":9},{"$f":" Time!T$11","v":10},{"$f":" Time!U$11","v":11},{"$f":" Time!V$11","v":12},{"$f":" Time!W$11","v":13},{"$f":" Time!X$11","v":14},{"$f":" Time!Y$11","v":15},{"$f":" Time!Z$11","v":16},{"$f":" Time!AA$11","v":17},{"$f":" Time!AB$11","v":18},{"$f":" Time!AC$11","v":19},{"$f":" Time!AD$11","v":20},{"$f":" Time!AE$11","v":21},{"$f":" Time!AF$11","v":22},{"$f":" Time!AG$11","v":23},{"$f":" Time!AH$11","v":24},{"$f":" Time!AI$11","v":25},{"$f":" Time!AJ$11","v":26},{"$f":" Time!AK$11","v":27},{"$f":" Time!AL$11","v":28},{"$f":" Time!AM$11","v":29},{"$f":" Time!AN$11","v":30},{"$f":" Time!AO$11","v":31},{"$f":" Time!AP$11","v":32},{"$f":" Time!AQ$11","v":33},{"$f":" Time!AR$11","v":34},{"$f":" Time!AS$11","v":35},{"$f":" Time!AT$11","v":36},{"$f":" Time!AU$11","v":37},{"$f":" Time!AV$11","v":38},{"$f":" Time!AW$11","v":39},{"$f":" Time!AX$11","v":40}]
[]
["MODEL PERIOD"]
[]
[null,"Model Column Counter "]
[null,null,null,null,"Model column counter",null,"counter",null,null,null,{"$f":" J11 + 1","v":1},{"$f":" K11 + 1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,{"$f":" AQ11 + 1","v":34},35,36,37,38,39,{"$f":" AW11 + 1","v":40}]
[null,null,null,null,"Model Column Total",{"$f":" MAX( K11:AX11 )","v":40},"columns"]
[]
[null,null,null,null,{"$f":" E$11","v":"Model column counter"},null,"counter",null,null,null,{"$f":" K$11","v":1},{"$f":" L$11","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40]
[null,null,null,null,"First model column flag",null,"flag",{"$f":" SUM( K15:AX15 )","v":1},null,null,{"$f":" IF( K14 = 1, 1, 0 )","v":1},{"$f":" IF( L14 = 1, 1, 0 )","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"First model column total",{"$f":" H15","v":1},"columns"]
[]
[null,"Modelling Period"]
[null,null,null,null,{"$f":" Inputs!E$11","v":"First date of modelling period"},{"$f":" Inputs!F$11","v":"2023-03-01"},{"$f":" Inputs!G$11","v":"date"}]
[null,null,null,null,"First model period BEG",{"$f":" DATE(YEAR(F19), MONTH(F19), 1)","v":"2023-03-01"},"month"]
[]
[null,null,null,null,{"$f":" E$20","v":"First model period BEG"},{"$f":" F$20","v":"2023-03-01"},{"$f":" G$20","v":"month"}]
[null,null,null,null,{"$f":" E$15","v":"First model column flag"},0,"flag",1,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Model Period BEG",null,"date",null,null,null,{"$f":" IF( K23 = 1, $F22, J27 + 1)","v":"2023-03-01"},{"$f":" IF( L23 = 1, $F22, K27 + 1)","v":"2023-04-01"},{"$f":" IF( M23 = 1, $F22, L27 + 1)","v":"2023-05-01"},"2023-06-01","2023-07-01","2023-08-01","2023-09-01","2023-10-01","2023-11-01","2023-12-01","2024-01-01","2024-02-01","2024-03-01","2024-04-01","2024-05-01","2024-06-01","2024-07-01","2024-08-01","2024-09-01","2024-10-01","2024-11-01","2024-12-01","2025-01-01","2025-02-01","2025-03-01","2025-04-01","2025-05-01","2025-06-01","2025-07-01","2025-08-01","2025-09-01","2025-10-01","2025-11-01","2025-12-01","2026-01-01","2026-02-01","2026-03-01","2026-04-01","2026-05-01","2026-06-01"]
[]
[null,null,null,null,{"$f":" E24","v":"Model Period BEG"},{"$f":" F24","v":"00:00:00"},"date","00:00:00",null,null,"2023-03-01","2023-04-01","2023-05-01","2023-06-01","2023-07-01","2023-08-01","2023-09-01","2023-10-01","2023-11-01","2023-12-01","2024-01-01","2024-02-01","2024-03-01","2024-04-01","2024-05-01","2024-06-01","2024-07-01","2024-08-01","2024-09-01","2024-10-01","2024-11-01","2024-12-01","2025-01-01","2025-02-01","2025-03-01","2025-04-01","2025-05-01","2025-06-01","2025-07-01","2025-08-01","2025-09-01","2025-10-01","2025-11-01","2025-12-01","2026-01-01","2026-02-01","2026-03-01","2026-04-01","2026-05-01","2026-06-01"]
[null,null,null,null,"Model Period END",null,"date",null,null,null,{"$f":" DATE(YEAR(K26), MONTH(K26) + 1, DAY(1) - 1)","v":"2023-03-31"},{"$f":" DATE(YEAR(L26), MONTH(L26) + 1, DAY(1) - 1)","v":"2023-04-30"},"2023-05-31","2023-06-30","2023-07-31","2023-08-31","2023-09-30","2023-10-31","2023-11-30","2023-12-31","2024-01-31","2024-02-29","2024-03-31","2024-04-30","2024-05-31","2024-06-30","2024-07-31","2024-08-31","2024-09-30","2024-10-31","2024-11-30","2024-12-31","2025-01-31","2025-02-28","2025-03-31","2025-04-30","2025-05-31","2025-06-30","2025-07-31","2025-08-31","2025-09-30","2025-10-31","2025-11-30","2025-12-31","2026-01-31","2026-02-28","2026-03-31","2026-04-30","2026-05-31","2026-06-30"]
[]
[]
["WORKING CAPITAL MODELLING PERIOD"]
[]
[null,null,null,null,{"$f":" Inputs!E16","v":"Working capital modelling period start date (FY)"},{"$f":" Inputs!F16","v":"2024-04-01"},{"$f":" Inputs!G16","v":"date"}]
[null,null,null,null,{"$f":" Inputs!E17","v":"Last working capital modelling period date (FY)"},{"$f":" Inputs!F17","v":"2025-03-31"},{"$f":" Inputs!G17","v":"date"}]
[null,null,null,null,{"$f":" E$27","v":"Model Period END"},{"$f":" F$27","v":"00:00:00"},{"$f":" G$27","v":"date"},"00:00:00",null,null,"2023-03-31","2023-04-30","2023-05-31","2023-06-30",{"$f":" O$27","v":"2023-07-31"},{"$f":" P$27","v":"2023-08-31"},"2023-09-30","2023-10-31","2023-11-30","2023-12-31","2024-01-31","2024-02-29","2024-03-31","2024-04-30","2024-05-31","2024-06-30","2024-07-31","2024-08-31","2024-09-30","2024-10-31","2024-11-30","2024-12-31","2025-01-31","2025-02-28","2025-03-31","2025-04-30","2025-05-31","2025-06-30","2025-07-31","2025-08-31","2025-09-30","2025-10-31","2025-11-30","2025-12-31","2026-01-31","2026-02-28","2026-03-31","2026-04-30","2026-05-31","2026-06-30"]
[null,null,null,null,"Working capital modelling period flag",null,"flag",{"$f":" SUM( K35:AX35 )","v":12},null,null,{"$f":" IF( AND( $F32 < K34, $F33 >= K34 ), 1, 0 )","v":0},{"$f":" IF( AND( $F32 < L34, $F33 >= L34 ), 1, 0 )","v":0},0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Working capital period total",{"$f":" SUM( K35:AX35 )","v":12},"columns"]
[]
[]
["PRE/POST MODEL PERIOD"]
[]
[null,"Pre model period"]
[null,null,null,null,{"$f":" Inputs!E$20","v":"Financial year before the working capital modelling period (FY-1)"},{"$f":" Inputs!F$20","v":"2023-04-01"},{"$f":" Inputs!G$20","v":"date"},{"$f":" Inputs!H$20","v":"00:00:00"}]
[null,null,null,null,{"$f":" Inputs!E$21","v":"Last date of the modelling period (FY-1)"},{"$f":" Inputs!F$21","v":"2024-03-31"},{"$f":" Inputs!G$21","v":"date"}]
[null,null,null,null,{"$f":" E$27","v":"Model Period END"},{"$f":" F$27","v":"00:00:00"},"date","00:00:00",null,null,{"$f":" K$27","v":"2023-03-31"},{"$f":" L$27","v":"2023-04-30"},"2023-05-31","2023-06-30","2023-07-31","2023-08-31","2023-09-30","2023-10-31","2023-11-30","2023-12-31","2024-01-31","2024-02-29","2024-03-31","2024-04-30","2024-05-31","2024-06-30","2024-07-31","2024-08-31","2024-09-30","2024-10-31","2024-11-30","2024-12-31","2025-01-31","2025-02-28","2025-03-31","2025-04-30","2025-05-31","2025-06-30","2025-07-31","2025-08-31","2025-09-30","2025-10-31","2025-11-30","2025-12-31","2026-01-31","2026-02-28","2026-03-31","2026-04-30","2026-05-31","2026-06-30"]
[null,null,null,null,"Pre model period flag",null,"flag",{"$f":" SUM( K45:AX45 )","v":12},null,null,{"$f":" IF( AND( K44 > $F42, K44 <= $F43 ), 1, 0 )","v":0},{"$f":" IF( AND( L44 > $F42, L44 <= $F43 ), 1, 0 )","v":1},1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Pre model period total",{"$f":" SUM( K45:AX45 )","v":12},"columns"]
[]
[null,"Post model period"]
[null,null,null,null,{"$f":" Inputs!E$24","v":"Financial year after the working capital modelling period (FY+1)"},{"$f":" Inputs!F$24","v":"2025-04-01"},{"$f":" Inputs!G$24","v":"date"},{"$f":" Inputs!H$24","v":"00:00:00"}]
[null,null,null,null,{"$f":" E$27","v":"Model Period END"},{"$f":" F$27","v":"00:00:00"},"date","00:00:00",null,null,{"$f":" K$27","v":"2023-03-31"},{"$f":" L$27","v":"2023-04-30"},"2023-05-31","2023-06-30","2023-07-31","2023-08-31","2023-09-30","2023-10-31","2023-11-30","2023-12-31","2024-01-31","2024-02-29","2024-03-31","2024-04-30","2024-05-31","2024-06-30","2024-07-31","2024-08-31","2024-09-30","2024-10-31","2024-11-30","2024-12-31","2025-01-31","2025-02-28","2025-03-31","2025-04-30","2025-05-31","2025-06-30","2025-07-31","2025-08-31","2025-09-30","2025-10-31","2025-11-30","2025-12-31","2026-01-31","2026-02-28","2026-03-31","2026-04-30","2026-05-31","2026-06-30"]
[null,null,null,null,"Post model period flag",null,"flag",{"$f":" SUM( K51:AX51 )","v":15},null,null,{"$f":" IF( AND( K50 > $F49 ), 1, 0 )","v":0},{"$f":" IF( AND( L50 > $F49 ), 1, 0 )","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,"Post model period total",{"$f":" SUM( K51:AX51 )","v":15},"columns"]
[]
[]
["CUSTOMER PAYMENT SCHEDULES"]
[]
[null,null,null,null,{"$f":" Inputs!E41","v":"3 year payment period"},{"$f":" Inputs!F41","v":36},{"$f":" Inputs!G41","v":"months"},{"$f":" Inputs!H41","v":0}]
[null,null,null,null,{"$f":" E11","v":"Model column counter"},{"$f":" F11","v":0},{"$f":" G11","v":"counter"},{"$f":" H11","v":0},null,{"$f":" J11","v":0},{"$f":" K11","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40]
[null,null,null,null,"Customer bill payment period flag",0,"flag",{"$f":" SUM( K59:AX59 )","v":36},null,null,{"$f":" IF( AND( J58 <= $F57, J58 > 0 ), 1, 0 )","v":0},{"$f":" IF( AND( K58 <= $F57, K58 > 0 ), 1, 0 )","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0]
[]
[null,null,null,null,{"$f":" E59","v":"Customer bill payment period flag"},{"$f":" F59","v":0},"flag",36,null,0,{"$f":" K59","v":0},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0]
[null,null,null,null,{"$f":" E27","v":"Model Period END"},{"$f":" F27","v":"00:00:00"},{"$f":" G27","v":"date"},{"$f":" H27","v":"00:00:00"},null,{"$f":" J27","v":"00:00:00"},"2023-03-31","2023-04-30","2023-05-31","2023-06-30","2023-07-31","2023-08-31","2023-09-30","2023-10-31","2023-11-30","2023-12-31","2024-01-31","2024-02-29","2024-03-31","2024-04-30","2024-05-31","2024-06-30","2024-07-31","2024-08-31","2024-09-30","2024-10-31","2024-11-30","2024-12-31","2025-01-31","2025-02-28","2025-03-31","2025-04-30","2025-05-31","2025-06-30","2025-07-31","2025-08-31","2025-09-30","2025-10-31","2025-11-30","2025-12-31","2026-01-31","2026-02-28","2026-03-31","2026-04-30","2026-05-31","2026-06-30"]
[null,null,null,null,"Month number",0,"month",null,null,null,{"$f":" MONTH( K62 )","v":3},{"$f":" MONTH( L62 )","v":4},5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6]
[]
[null,null,null,null,{"$f":" Inputs!E48","v":"Customer payment month 1"},{"$f":" Inputs!F48","v":6},{"$f":" Inputs!G48","v":"month #"}]
[null,null,null,null,{"$f":" Inputs!E49","v":"Customer payment month 2"},{"$f":" Inputs!F49","v":9},{"$f":" Inputs!G49","v":"month #"}]
[null,null,null,null,{"$f":" Inputs!E50","v":"Customer payment month 3"},{"$f":" Inputs!F50","v":12},{"$f":" Inputs!G50","v":"month #"}]
[null,null,null,null,{"$f":" Inputs!E51","v":"Customer payment month 4"},{"$f":" Inputs!F51","v":3},{"$f":" Inputs!G51","v":"month #"}]
[]
[null,null,null,null,"Customer payment schedule flag",0,"flag",{"$f":" SUM( K70:AX70 )","v":12},null,null,{"$f":" IF( ISNA( MATCH( K61  * K63, $F65:$F68, 0 ) ), 0, 1  )","v":0},{"$f":" IF( ISNA( MATCH( L61  * L63, $F65:$F68, 0 ) ), 0, 1  )","v":0},0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,0]
[]
[]
["WHOLESALER AND RETAIL PAYMENT PERIOD"]
[]
[null,"Wholesaler charge payment period"]
[null,null,null,null,{"$f":" Inputs!E41","v":"3 year payment period"},{"$f":" Inputs!F41","v":36},{"$f":" Inputs!G41","v":"months"},{"$f":" Inputs!H41","v":0}]
[null,null,null,null,{"$f":" E11","v":"Model column counter"},{"$f":" F11","v":0},{"$f":" G11","v":"counter"},{"$f":" H11","v":0},null,{"$f":" J11","v":0},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40]
[null,null,null,null,"Wholesale charge payment flag",0,"flag",{"$f":" SUM( K78:AX78 )","v":37},null,null,{"$f":" IF( J77 <= $F76, 1, 0 )","v":1},{"$f":" IF( K77 <= $F76, 1, 0 )","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0]
[]
[null,"Retail cost payment period"]
[null,null,null,null,{"$f":" Inputs!E41","v":"3 year payment period"},{"$f":" Inputs!F41","v":36},{"$f":" Inputs!G41","v":"months"},{"$f":" Inputs!H41","v":0}]
[null,null,null,null,{"$f":" E11","v":"Model column counter"},{"$f":" F11","v":0},{"$f":" G11","v":"counter"},{"$f":" H11","v":0},null,{"$f":" J11","v":0},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40]
[null,null,null,null,"Retail cost payment flag",0,"flag",{"$f":" SUM( K83:AX83 )","v":36},null,null,{"$f":" IF( AND( J82 <= $F81, J82 > 0 ), 1, 0 )","v":0},{"$f":" IF( AND( K82 <= $F81, K82 > 0 ), 1, 0 )","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0]
[]
[]
["FINANCIAL YEAR"]
[]
[null,null,null,null,{"$f":" Inputs!E71","v":"Financial Year End Month Number"},{"$f":"Inputs!F71","v":3},{"$f":"Inputs!G71","v":"month #"}]
[null,null,null,null,{"$f":" E$27","v":"Model Period END"},{"$f":" F$27","v":"00:00:00"},"date","00:00:00",null,"00:00:00","2023-03-31","2023-04-30","2023-05-31","2023-06-30","2023-07-31","2023-08-31","2023-09-30","2023-10-31","2023-11-30","2023-12-31","2024-01-31","2024-02-29","2024-03-31","2024-04-30","2024-05-31","2024-06-30","2024-07-31","2024-08-31","2024-09-30","2024-10-31","2024-11-30","2024-12-31","2025-01-31","2025-02-28","2025-03-31","2025-04-30","2025-05-31","2025-06-30","2025-07-31","2025-08-31","2025-09-30","2025-10-31","2025-11-30","2025-12-31","2026-01-31","2026-02-28","2026-03-31","2026-04-30","2026-05-31","2026-06-30"]
[null,null,null,null,"Financial Year Ending",null,"year #",null,null,null,{"$f":" IF( MONTH( K89 ) <= $F88, YEAR( K89 ), YEAR( K89 ) + 1 )","v":2023},{"$f":" IF( MONTH( L89 ) <= $F88, YEAR( L89 ), YEAR( L89 ) + 1 )","v":2024},2024,2024,2024,2024,2024,2024,2024,2024,2024,2024,2024,2025,2025,2025,2025,2025,2025,2025,2025,2025,2025,2025,2025,2026,2026,2026,2026,2026,2026,2026,2026,2026,2026,2026,2026,2027,2027,2027]
[null,null,null,null,"Financial Year Reference",null,"label",null,null,null,{"$f":" _xlfn.IFS( K90 = 2023, \"FY-2\", K90 = 2024, \"FY-1\", K90 = 2025, \"FY\", K90 = 2026, \"FY+1\", K90 = 2027, \"FY+2\")","v":"FY-2"},{"$f":" _xlfn.IFS( L90 = 2023, \"FY-2\", L90 = 2024, \"FY-1\", L90 = 2025, \"FY\", L90 = 2026, \"FY+1\", L90 = 2027, \"FY+2\")","v":"FY-1"},{"$f":" _xlfn.IFS( M90 = 2023, \"FY-2\", M90 = 2024, \"FY-1\", M90 = 2025, \"FY\", M90 = 2026, \"FY+1\", M90 = 2027, \"FY+2\")","v":"FY-1"},{"$f":" _xlfn.IFS( N90 = 2023, \"FY-2\", N90 = 2024, \"FY-1\", N90 = 2025, \"FY\", N90 = 2026, \"FY+1\", N90 = 2027, \"FY+2\")","v":"FY-1"},{"$f":" _xlfn.IFS( O90 = 2023, \"FY-2\", O90 = 2024, \"FY-1\", O90 = 2025, \"FY\", O90 = 2026, \"FY+1\", O90 = 2027, \"FY+2\")","v":"FY-1"},{"$f":" _xlfn.IFS( P90 = 2023, \"FY-2\", P90 = 2024, \"FY-1\", P90 = 2025, \"FY\", P90 = 2026, \"FY+1\", P90 = 2027, \"FY+2\")","v":"FY-1"},{"$f":" _xlfn.IFS( Q90 = 2023, \"FY-2\", Q90 = 2024, \"FY-1\", Q90 = 2025, \"FY\", Q90 = 2026, \"FY+1\", Q90 = 2027, \"FY+2\")","v":"FY-1"},{"$f":" _xlfn.IFS( R90 = 2023, \"FY-2\", R90 = 2024, \"FY-1\", R90 = 2025, \"FY\", R90 = 2026, \"FY+1\", R90 = 2027, \"FY+2\")","v":"FY-1"},{"$f":" _xlfn.IFS( S90 = 2023, \"FY-2\", S90 = 2024, \"FY-1\", S90 = 2025, \"FY\", S90 = 2026, \"FY+1\", S90 = 2027, \"FY+2\")","v":"FY-1"},{"$f":" _xlfn.IFS( T90 = 2023, \"FY-2\", T90 = 2024, \"FY-1\", T90 = 2025, \"FY\", T90 = 2026, \"FY+1\", T90 = 2027, \"FY+2\")","v":"FY-1"},{"$f":" _xlfn.IFS( U90 = 2023, \"FY-2\", U90 = 2024, \"FY-1\", U90 = 2025, \"FY\", U90 = 2026, \"FY+1\", U90 = 2027, \"FY+2\")","v":"FY-1"},{"$f":" _xlfn.IFS( V90 = 2023, \"FY-2\", V90 = 2024, \"FY-1\", V90 = 2025, \"FY\", V90 = 2026, \"FY+1\", V90 = 2027, \"FY+2\")","v":"FY-1"},{"$f":" _xlfn.IFS( W90 = 2023, \"FY-2\", W90 = 2024, \"FY-1\", W90 = 2025, \"FY\", W90 = 2026, \"FY+1\", W90 = 2027, \"FY+2\")","v":"FY-1"},{"$f":" _xlfn.IFS( X90 = 2023, \"FY-2\", X90 = 2024, \"FY-1\", X90 = 2025, \"FY\", X90 = 2026, \"FY+1\", X90 = 2027, \"FY+2\")","v":"FY"},{"$f":" _xlfn.IFS( Y90 = 2023, \"FY-2\", Y90 = 2024, \"FY-1\", Y90 = 2025, \"FY\", Y90 = 2026, \"FY+1\", Y90 = 2027, \"FY+2\")","v":"FY"},{"$f":" _xlfn.IFS( Z90 = 2023, \"FY-2\", Z90 = 2024, \"FY-1\", Z90 = 2025, \"FY\", Z90 = 2026, \"FY+1\", Z90 = 2027, \"FY+2\")","v":"FY"},{"$f":" _xlfn.IFS( AA90 = 2023, \"FY-2\", AA90 = 2024, \"FY-1\", AA90 = 2025, \"FY\", AA90 = 2026, \"FY+1\", AA90 = 2027, \"FY+2\")","v":"FY"},{"$f":" _xlfn.IFS( AB90 = 2023, \"FY-2\", AB90 = 2024, \"FY-1\", AB90 = 2025, \"FY\", AB90 = 2026, \"FY+1\", AB90 = 2027, \"FY+2\")","v":"FY"},{"$f":" _xlfn.IFS( AC90 = 2023, \"FY-2\", AC90 = 2024, \"FY-1\", AC90 = 2025, \"FY\", AC90 = 2026, \"FY+1\", AC90 = 2027, \"FY+2\")","v":"FY"},{"$f":" _xlfn.IFS( AD90 = 2023, \"FY-2\", AD90 = 2024, \"FY-1\", AD90 = 2025, \"FY\", AD90 = 2026, \"FY+1\", AD90 = 2027, \"FY+2\")","v":"FY"},{"$f":" _xlfn.IFS( AE90 = 2023, \"FY-2\", AE90 = 2024, \"FY-1\", AE90 = 2025, \"FY\", AE90 = 2026, \"FY+1\", AE90 = 2027, \"FY+2\")","v":"FY"},{"$f":" _xlfn.IFS( AF90 = 2023, \"FY-2\", AF90 = 2024, \"FY-1\", AF90 = 2025, \"FY\", AF90 = 2026, \"FY+1\", AF90 = 2027, \"FY+2\")","v":"FY"},{"$f":" _xlfn.IFS( AG90 = 2023, \"FY-2\", AG90 = 2024, \"FY-1\", AG90 = 2025, \"FY\", AG90 = 2026, \"FY+1\", AG90 = 2027, \"FY+2\")","v":"FY"},{"$f":" _xlfn.IFS( AH90 = 2023, \"FY-2\", AH90 = 2024, \"FY-1\", AH90 = 2025, \"FY\", AH90 = 2026, \"FY+1\", AH90 = 2027, \"FY+2\")","v":"FY"},{"$f":" _xlfn.IFS( AI90 = 2023, \"FY-2\", AI90 = 2024, \"FY-1\", AI90 = 2025, \"FY\", AI90 = 2026, \"FY+1\", AI90 = 2027, \"FY+2\")","v":"FY"},{"$f":" _xlfn.IFS( AJ90 = 2023, \"FY-2\", AJ90 = 2024, \"FY-1\", AJ90 = 2025, \"FY\", AJ90 = 2026, \"FY+1\", AJ90 = 2027, \"FY+2\")","v":"FY+1"},{"$f":" _xlfn.IFS( AK90 = 2023, \"FY-2\", AK90 = 2024, \"FY-1\", AK90 = 2025, \"FY\", AK90 = 2026, \"FY+1\", AK90 = 2027, \"FY+2\")","v":"FY+1"},{"$f":" _xlfn.IFS( AL90 = 2023, \"FY-2\", AL90 = 2024, \"FY-1\", AL90 = 2025, \"FY\", AL90 = 2026, \"FY+1\", AL90 = 2027, \"FY+2\")","v":"FY+1"},{"$f":" _xlfn.IFS( AM90 = 2023, \"FY-2\", AM90 = 2024, \"FY-1\", AM90 = 2025, \"FY\", AM90 = 2026, \"FY+1\", AM90 = 2027, \"FY+2\")","v":"FY+1"},{"$f":" _xlfn.IFS( AN90 = 2023, \"FY-2\", AN90 = 2024, \"FY-1\", AN90 = 2025, \"FY\", AN90 = 2026, \"FY+1\", AN90 = 2027, \"FY+2\")","v":"FY+1"},{"$f":" _xlfn.IFS( AO90 = 2023, \"FY-2\", AO90 = 2024, \"FY-1\", AO90 = 2025, \"FY\", AO90 = 2026, \"FY+1\", AO90 = 2027, \"FY+2\")","v":"FY+1"},{"$f":" _xlfn.IFS( AP90 = 2023, \"FY-2\", AP90 = 2024, \"FY-1\", AP90 = 2025, \"FY\", AP90 = 2026, \"FY+1\", AP90 = 2027, \"FY+2\")","v":"FY+1"},{"$f":" _xlfn.IFS( AQ90 = 2023, \"FY-2\", AQ90 = 2024, \"FY-1\", AQ90 = 2025, \"FY\", AQ90 = 2026, \"FY+1\", AQ90 = 2027, \"FY+2\")","v":"FY+1"},{"$f":" _xlfn.IFS( AR90 = 2023, \"FY-2\", AR90 = 2024, \"FY-1\", AR90 = 2025, \"FY\", AR90 = 2026, \"FY+1\", AR90 = 2027, \"FY+2\")","v":"FY+1"},{"$f":" _xlfn.IFS( AS90 = 2023, \"FY-2\", AS90 = 2024, \"FY-1\", AS90 = 2025, \"FY\", AS90 = 2026, \"FY+1\", AS90 = 2027, \"FY+2\")","v":"FY+1"},{"$f":" _xlfn.IFS( AT90 = 2023, \"FY-2\", AT90 = 2024, \"FY-1\", AT90 = 2025, \"FY\", AT90 = 2026, \"FY+1\", AT90 = 2027, \"FY+2\")","v":"FY+1"},{"$f":" _xlfn.IFS( AU90 = 2023, \"FY-2\", AU90 = 2024, \"FY-1\", AU90 = 2025, \"FY\", AU90 = 2026, \"FY+1\", AU90 = 2027, \"FY+2\")","v":"FY+1"},{"$f":" _xlfn.IFS( AV90 = 2023, \"FY-2\", AV90 = 2024, \"FY-1\", AV90 = 2025, \"FY\", AV90 = 2026, \"FY+1\", AV90 = 2027, \"FY+2\")","v":"FY+2"},{"$f":" _xlfn.IFS( AW90 = 2023, \"FY-2\", AW90 = 2024, \"FY-1\", AW90 = 2025, \"FY\", AW90 = 2026, \"FY+1\", AW90 = 2027, \"FY+2\")","v":"FY+2"},{"$f":" _xlfn.IFS( AX90 = 2023, \"FY-2\", AX90 = 2024, \"FY-1\", AX90 = 2025, \"FY\", AX90 = 2026, \"FY+1\", AX90 = 2027, \"FY+2\")","v":"FY+2"}]
[]
["LABELS"]
[]
[null,null,null,null,{"$f":" E15","v":"First model column flag"},0,"flag",1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E45","v":"Pre model period flag"},0,"flag",12,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E35","v":"Working capital modelling period flag"},{"$f":" F35","v":0},"flag",12,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E51","v":"Post model period flag"},{"$f":" F51","v":0},"flag",15,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[]
[null,null,null,null,"Period reference",null,"label",null,null,null,{"$f":" _xlfn.IFS( OR( K95 = 1, K96 = 1 ), \"Pre model period\", K97 = 1, \"W.C. model period\", K98 = 1, \"Post model period\" )","v":"Pre model period"},{"$f":" _xlfn.IFS( OR( L95 = 1, L96 = 1 ), \"Pre model period\", L97 = 1, \"W.C. model period\", L98 = 1, \"Post model period\" )","v":"Pre model period"},{"$f":" _xlfn.IFS( OR( M95 = 1, M96 = 1 ), \"Pre model period\", M97 = 1, \"W.C. model period\", M98 = 1, \"Post model period\" )","v":"Pre model period"},{"$f":" _xlfn.IFS( OR( N95 = 1, N96 = 1 ), \"Pre model period\", N97 = 1, \"W.C. model period\", N98 = 1, \"Post model period\" )","v":"Pre model period"},{"$f":" _xlfn.IFS( OR( O95 = 1, O96 = 1 ), \"Pre model period\", O97 = 1, \"W.C. model period\", O98 = 1, \"Post model period\" )","v":"Pre model period"},{"$f":" _xlfn.IFS( OR( P95 = 1, P96 = 1 ), \"Pre model period\", P97 = 1, \"W.C. model period\", P98 = 1, \"Post model period\" )","v":"Pre model period"},{"$f":" _xlfn.IFS( OR( Q95 = 1, Q96 = 1 ), \"Pre model period\", Q97 = 1, \"W.C. model period\", Q98 = 1, \"Post model period\" )","v":"Pre model period"},{"$f":" _xlfn.IFS( OR( R95 = 1, R96 = 1 ), \"Pre model period\", R97 = 1, \"W.C. model period\", R98 = 1, \"Post model period\" )","v":"Pre model period"},{"$f":" _xlfn.IFS( OR( S95 = 1, S96 = 1 ), \"Pre model period\", S97 = 1, \"W.C. model period\", S98 = 1, \"Post model period\" )","v":"Pre model period"},{"$f":" _xlfn.IFS( OR( T95 = 1, T96 = 1 ), \"Pre model period\", T97 = 1, \"W.C. model period\", T98 = 1, \"Post model period\" )","v":"Pre model period"},{"$f":" _xlfn.IFS( OR( U95 = 1, U96 = 1 ), \"Pre model period\", U97 = 1, \"W.C. model period\", U98 = 1, \"Post model period\" )","v":"Pre model period"},{"$f":" _xlfn.IFS( OR( V95 = 1, V96 = 1 ), \"Pre model period\", V97 = 1, \"W.C. model period\", V98 = 1, \"Post model period\" )","v":"Pre model period"},{"$f":" _xlfn.IFS( OR( W95 = 1, W96 = 1 ), \"Pre model period\", W97 = 1, \"W.C. model period\", W98 = 1, \"Post model period\" )","v":"Pre model period"},{"$f":" _xlfn.IFS( OR( X95 = 1, X96 = 1 ), \"Pre model period\", X97 = 1, \"W.C. model period\", X98 = 1, \"Post model period\" )","v":"W.C. model period"},{"$f":" _xlfn.IFS( OR( Y95 = 1, Y96 = 1 ), \"Pre model period\", Y97 = 1, \"W.C. model period\", Y98 = 1, \"Post model period\" )","v":"W.C. model period"},{"$f":" _xlfn.IFS( OR( Z95 = 1, Z96 = 1 ), \"Pre model period\", Z97 = 1, \"W.C. model period\", Z98 = 1, \"Post model period\" )","v":"W.C. model period"},{"$f":" _xlfn.IFS( OR( AA95 = 1, AA96 = 1 ), \"Pre model period\", AA97 = 1, \"W.C. model period\", AA98 = 1, \"Post model period\" )","v":"W.C. model period"},{"$f":" _xlfn.IFS( OR( AB95 = 1, AB96 = 1 ), \"Pre model period\", AB97 = 1, \"W.C. model period\", AB98 = 1, \"Post model period\" )","v":"W.C. model period"},{"$f":" _xlfn.IFS( OR( AC95 = 1, AC96 = 1 ), \"Pre model period\", AC97 = 1, \"W.C. model period\", AC98 = 1, \"Post model period\" )","v":"W.C. model period"},{"$f":" _xlfn.IFS( OR( AD95 = 1, AD96 = 1 ), \"Pre model period\", AD97 = 1, \"W.C. model period\", AD98 = 1, \"Post model period\" )","v":"W.C. model period"},{"$f":" _xlfn.IFS( OR( AE95 = 1, AE96 = 1 ), \"Pre model period\", AE97 = 1, \"W.C. model period\", AE98 = 1, \"Post model period\" )","v":"W.C. model period"},{"$f":" _xlfn.IFS( OR( AF95 = 1, AF96 = 1 ), \"Pre model period\", AF97 = 1, \"W.C. model period\", AF98 = 1, \"Post model period\" )","v":"W.C. model period"},{"$f":" _xlfn.IFS( OR( AG95 = 1, AG96 = 1 ), \"Pre model period\", AG97 = 1, \"W.C. model period\", AG98 = 1, \"Post model period\" )","v":"W.C. model period"},{"$f":" _xlfn.IFS( OR( AH95 = 1, AH96 = 1 ), \"Pre model period\", AH97 = 1, \"W.C. model period\", AH98 = 1, \"Post model period\" )","v":"W.C. model period"},{"$f":" _xlfn.IFS( OR( AI95 = 1, AI96 = 1 ), \"Pre model period\", AI97 = 1, \"W.C. model period\", AI98 = 1, \"Post model period\" )","v":"W.C. model period"},{"$f":" _xlfn.IFS( OR( AJ95 = 1, AJ96 = 1 ), \"Pre model period\", AJ97 = 1, \"W.C. model period\", AJ98 = 1, \"Post model period\" )","v":"Post model period"},{"$f":" _xlfn.IFS( OR( AK95 = 1, AK96 = 1 ), \"Pre model period\", AK97 = 1, \"W.C. model period\", AK98 = 1, \"Post model period\" )","v":"Post model period"},{"$f":" _xlfn.IFS( OR( AL95 = 1, AL96 = 1 ), \"Pre model period\", AL97 = 1, \"W.C. model period\", AL98 = 1, \"Post model period\" )","v":"Post model period"},{"$f":" _xlfn.IFS( OR( AM95 = 1, AM96 = 1 ), \"Pre model period\", AM97 = 1, \"W.C. model period\", AM98 = 1, \"Post model period\" )","v":"Post model period"},{"$f":" _xlfn.IFS( OR( AN95 = 1, AN96 = 1 ), \"Pre model period\", AN97 = 1, \"W.C. model period\", AN98 = 1, \"Post model period\" )","v":"Post model period"},{"$f":" _xlfn.IFS( OR( AO95 = 1, AO96 = 1 ), \"Pre model period\", AO97 = 1, \"W.C. model period\", AO98 = 1, \"Post model period\" )","v":"Post model period"},{"$f":" _xlfn.IFS( OR( AP95 = 1, AP96 = 1 ), \"Pre model period\", AP97 = 1, \"W.C. model period\", AP98 = 1, \"Post model period\" )","v":"Post model period"},{"$f":" _xlfn.IFS( OR( AQ95 = 1, AQ96 = 1 ), \"Pre model period\", AQ97 = 1, \"W.C. model period\", AQ98 = 1, \"Post model period\" )","v":"Post model period"},{"$f":" _xlfn.IFS( OR( AR95 = 1, AR96 = 1 ), \"Pre model period\", AR97 = 1, \"W.C. model period\", AR98 = 1, \"Post model period\" )","v":"Post model period"},{"$f":" _xlfn.IFS( OR( AS95 = 1, AS96 = 1 ), \"Pre model period\", AS97 = 1, \"W.C. model period\", AS98 = 1, \"Post model period\" )","v":"Post model period"},{"$f":" _xlfn.IFS( OR( AT95 = 1, AT96 = 1 ), \"Pre model period\", AT97 = 1, \"W.C. model period\", AT98 = 1, \"Post model period\" )","v":"Post model period"},{"$f":" _xlfn.IFS( OR( AU95 = 1, AU96 = 1 ), \"Pre model period\", AU97 = 1, \"W.C. model period\", AU98 = 1, \"Post model period\" )","v":"Post model period"},{"$f":" _xlfn.IFS( OR( AV95 = 1, AV96 = 1 ), \"Pre model period\", AV97 = 1, \"W.C. model period\", AV98 = 1, \"Post model period\" )","v":"Post model period"},{"$f":" _xlfn.IFS( OR( AW95 = 1, AW96 = 1 ), \"Pre model period\", AW97 = 1, \"W.C. model period\", AW98 = 1, \"Post model period\" )","v":"Post model period"},{"$f":" _xlfn.IFS( OR( AX95 = 1, AX96 = 1 ), \"Pre model period\", AX97 = 1, \"W.C. model period\", AX98 = 1, \"Post model period\" )","v":"Post model period"}]
[]
["MODELLING PERIOD CHECK"]
[]
[null,null,null,null,{"$f":" E$12","v":"Model Column Total"},{"$f":" F$12","v":40},{"$f":" G$12","v":"columns"}]
[null,null,null,"less",{"$f":" E$36","v":"Working capital period total"},{"$f":" F$36","v":12},{"$f":" G$36","v":"columns"}]
[null,null,null,"less",{"$f":" E46","v":"Pre model period total"},{"$f":" F46","v":12},{"$f":" G46","v":"columns"}]
[null,null,null,"less",{"$f":" E52","v":"Post model period total"},{"$f":" F52","v":15},{"$f":" G52","v":"columns"}]
[null,null,null,"less",{"$f":" E16","v":"First model column total"},{"$f":" F16","v":1},"columns"]
[null,null,null,null,"Modelling Period - Check",{"$f":" IF( F104 - SUM( F105:F108 ) <> 0, 1, 0 )","v":0},"check"]
[]
["END"]

{"sheet":"Calculations","index":7,"n_rows":100,"n_cols":16384,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Calculations"}]
[null,null,null,null,{"$f":" Time!E$24","v":"Model Period BEG"},null,null,null,null,null,{"$f":" Time!K$24","v":"2023-03-01"},{"$f":" Time!L$24","v":"2023-04-01"},{"$f":" Time!M$24","v":"2023-05-01"},{"$f":" Time!N$24","v":"2023-06-01"},{"$f":" Time!O$24","v":"2023-07-01"},{"$f":" Time!P$24","v":"2023-08-01"},{"$f":" Time!Q$24","v":"2023-09-01"},{"$f":" Time!R$24","v":"2023-10-01"},{"$f":" Time!S$24","v":"2023-11-01"},{"$f":" Time!T$24","v":"2023-12-01"},{"$f":" Time!U$24","v":"2024-01-01"},{"$f":" Time!V$24","v":"2024-02-01"},{"$f":" Time!W$24","v":"2024-03-01"},{"$f":" Time!X$24","v":"2024-04-01"},{"$f":" Time!Y$24","v":"2024-05-01"},{"$f":" Time!Z$24","v":"2024-06-01"},{"$f":" Time!AA$24","v":"2024-07-01"},{"$f":" Time!AB$24","v":"2024-08-01"},{"$f":" Time!AC$24","v":"2024-09-01"},{"$f":" Time!AD$24","v":"2024-10-01"},{"$f":" Time!AE$24","v":"2024-11-01"},{"$f":" Time!AF$24","v":"2024-12-01"},{"$f":" Time!AG$24","v":"2025-01-01"},{"$f":" Time!AH$24","v":"2025-02-01"},{"$f":" Time!AI$24","v":"2025-03-01"},{"$f":" Time!AJ$24","v":"2025-04-01"},{"$f":" Time!AK$24","v":"2025-05-01"},{"$f":" Time!AL$24","v":"2025-06-01"},{"$f":" Time!AM$24","v":"2025-07-01"},{"$f":" Time!AN$24","v":"2025-08-01"},{"$f":" Time!AO$24","v":"2025-09-01"},{"$f":" Time!AP$24","v":"2025-10-01"},{"$f":" Time!AQ$24","v":"2025-11-01"},{"$f":" Time!AR$24","v":"2025-12-01"},{"$f":" Time!AS$24","v":"2026-01-01"},{"$f":" Time!AT$24","v":"2026-02-01"},{"$f":" Time!AU$24","v":"2026-03-01"},{"$f":" Time!AV$24","v":"2026-04-01"},{"$f":" Time!AW$24","v":"2026-05-01"},{"$f":" Time!AX$24","v":"2026-06-01"}]
[null,null,null,null,{"$f":" Time!E$27","v":"Model Period END"},{"$f":" Check!F$8","v":0},"Error chks",null,null,null,{"$f":" Time!K$27","v":"2023-03-31"},{"$f":" Time!L$27","v":"2023-04-30"},{"$f":" Time!M$27","v":"2023-05-31"},{"$f":" Time!N$27","v":"2023-06-30"},{"$f":" Time!O$27","v":"2023-07-31"},{"$f":" Time!P$27","v":"2023-08-31"},{"$f":" Time!Q$27","v":"2023-09-30"},{"$f":" Time!R$27","v":"2023-10-31"},{"$f":" Time!S$27","v":"2023-11-30"},{"$f":" Time!T$27","v":"2023-12-31"},{"$f":" Time!U$27","v":"2024-01-31"},{"$f":" Time!V$27","v":"2024-02-29"},{"$f":" Time!W$27","v":"2024-03-31"},{"$f":" Time!X$27","v":"2024-04-30"},{"$f":" Time!Y$27","v":"2024-05-31"},{"$f":" Time!Z$27","v":"2024-06-30"},{"$f":" Time!AA$27","v":"2024-07-31"},{"$f":" Time!AB$27","v":"2024-08-31"},{"$f":" Time!AC$27","v":"2024-09-30"},{"$f":" Time!AD$27","v":"2024-10-31"},{"$f":" Time!AE$27","v":"2024-11-30"},{"$f":" Time!AF$27","v":"2024-12-31"},{"$f":" Time!AG$27","v":"2025-01-31"},{"$f":" Time!AH$27","v":"2025-02-28"},{"$f":" Time!AI$27","v":"2025-03-31"},{"$f":" Time!AJ$27","v":"2025-04-30"},{"$f":" Time!AK$27","v":"2025-05-31"},{"$f":" Time!AL$27","v":"2025-06-30"},{"$f":" Time!AM$27","v":"2025-07-31"},{"$f":" Time!AN$27","v":"2025-08-31"},{"$f":" Time!AO$27","v":"2025-09-30"},{"$f":" Time!AP$27","v":"2025-10-31"},{"$f":" Time!AQ$27","v":"2025-11-30"},{"$f":" Time!AR$27","v":"2025-12-31"},{"$f":" Time!AS$27","v":"2026-01-31"},{"$f":" Time!AT$27","v":"2026-02-28"},{"$f":" Time!AU$27","v":"2026-03-31"},{"$f":" Time!AV$27","v":"2026-04-30"},{"$f":" Time!AW$27","v":"2026-05-31"},{"$f":" Time!AX$27","v":"2026-06-30"}]
[null,null,null,null,{"$f":" Time!E$100","v":"Period reference"},null,null,null,null,null,{"$f":" Time!K$100","v":"Pre model period"},{"$f":" Time!L$100","v":"Pre model period"},{"$f":" Time!M$100","v":"Pre model period"},{"$f":" Time!N$100","v":"Pre model period"},{"$f":" Time!O$100","v":"Pre model period"},{"$f":" Time!P$100","v":"Pre model period"},{"$f":" Time!Q$100","v":"Pre model period"},{"$f":" Time!R$100","v":"Pre model period"},{"$f":" Time!S$100","v":"Pre model period"},{"$f":" Time!T$100","v":"Pre model period"},{"$f":" Time!U$100","v":"Pre model period"},{"$f":" Time!V$100","v":"Pre model period"},{"$f":" Time!W$100","v":"Pre model period"},{"$f":" Time!X$100","v":"W.C. model period"},{"$f":" Time!Y$100","v":"W.C. model period"},{"$f":" Time!Z$100","v":"W.C. model period"},{"$f":" Time!AA$100","v":"W.C. model period"},{"$f":" Time!AB$100","v":"W.C. model period"},{"$f":" Time!AC$100","v":"W.C. model period"},{"$f":" Time!AD$100","v":"W.C. model period"},{"$f":" Time!AE$100","v":"W.C. model period"},{"$f":" Time!AF$100","v":"W.C. model period"},{"$f":" Time!AG$100","v":"W.C. model period"},{"$f":" Time!AH$100","v":"W.C. model period"},{"$f":" Time!AI$100","v":"W.C. model period"},{"$f":" Time!AJ$100","v":"Post model period"},{"$f":" Time!AK$100","v":"Post model period"},{"$f":" Time!AL$100","v":"Post model period"},{"$f":" Time!AM$100","v":"Post model period"},{"$f":" Time!AN$100","v":"Post model period"},{"$f":" Time!AO$100","v":"Post model period"},{"$f":" Time!AP$100","v":"Post model period"},{"$f":" Time!AQ$100","v":"Post model period"},{"$f":" Time!AR$100","v":"Post model period"},{"$f":" Time!AS$100","v":"Post model period"},{"$f":" Time!AT$100","v":"Post model period"},{"$f":" Time!AU$100","v":"Post model period"},{"$f":" Time!AV$100","v":"Post model period"},{"$f":" Time!AW$100","v":"Post model period"},{"$f":" Time!AX$100","v":"Post model period"}]
[null,null,null,null,{"$f":" Time!E$91","v":"Financial Year Reference"},null,null,null,null,null,{"$f":" Time!K$91","v":"FY-2"},{"$f":" Time!L$91","v":"FY-1"},{"$f":" Time!M$91","v":"FY-1"},{"$f":" Time!N$91","v":"FY-1"},{"$f":" Time!O$91","v":"FY-1"},{"$f":" Time!P$91","v":"FY-1"},{"$f":" Time!Q$91","v":"FY-1"},{"$f":" Time!R$91","v":"FY-1"},{"$f":" Time!S$91","v":"FY-1"},{"$f":" Time!T$91","v":"FY-1"},{"$f":" Time!U$91","v":"FY-1"},{"$f":" Time!V$91","v":"FY-1"},{"$f":" Time!W$91","v":"FY-1"},{"$f":" Time!X$91","v":"FY"},{"$f":" Time!Y$91","v":"FY"},{"$f":" Time!Z$91","v":"FY"},{"$f":" Time!AA$91","v":"FY"},{"$f":" Time!AB$91","v":"FY"},{"$f":" Time!AC$91","v":"FY"},{"$f":" Time!AD$91","v":"FY"},{"$f":" Time!AE$91","v":"FY"},{"$f":" Time!AF$91","v":"FY"},{"$f":" Time!AG$91","v":"FY"},{"$f":" Time!AH$91","v":"FY"},{"$f":" Time!AI$91","v":"FY"},{"$f":" Time!AJ$91","v":"FY+1"},{"$f":" Time!AK$91","v":"FY+1"},{"$f":" Time!AL$91","v":"FY+1"},{"$f":" Time!AM$91","v":"FY+1"},{"$f":" Time!AN$91","v":"FY+1"},{"$f":" Time!AO$91","v":"FY+1"},{"$f":" Time!AP$91","v":"FY+1"},{"$f":" Time!AQ$91","v":"FY+1"},{"$f":" Time!AR$91","v":"FY+1"},{"$f":" Time!AS$91","v":"FY+1"},{"$f":" Time!AT$91","v":"FY+1"},{"$f":" Time!AU$91","v":"FY+1"},{"$f":" Time!AV$91","v":"FY+2"},{"$f":" Time!AW$91","v":"FY+2"},{"$f":" Time!AX$91","v":"FY+2"}]
[null,null,null,null,{"$f":" Time!E$11","v":"Model column counter"},"Constant","Unit","Total",null,null,{"$f":" Time!K$11","v":1},{"$f":" Time!L$11","v":2},{"$f":" Time!M$11","v":3},{"$f":" Time!N$11","v":4},{"$f":" Time!O$11","v":5},{"$f":" Time!P$11","v":6},{"$f":" Time!Q$11","v":7},{"$f":" Time!R$11","v":8},{"$f":" Time!S$11","v":9},{"$f":" Time!T$11","v":10},{"$f":" Time!U$11","v":11},{"$f":" Time!V$11","v":12},{"$f":" Time!W$11","v":13},{"$f":" Time!X$11","v":14},{"$f":" Time!Y$11","v":15},{"$f":" Time!Z$11","v":16},{"$f":" Time!AA$11","v":17},{"$f":" Time!AB$11","v":18},{"$f":" Time!AC$11","v":19},{"$f":" Time!AD$11","v":20},{"$f":" Time!AE$11","v":21},{"$f":" Time!AF$11","v":22},{"$f":" Time!AG$11","v":23},{"$f":" Time!AH$11","v":24},{"$f":" Time!AI$11","v":25},{"$f":" Time!AJ$11","v":26},{"$f":" Time!AK$11","v":27},{"$f":" Time!AL$11","v":28},{"$f":" Time!AM$11","v":29},{"$f":" Time!AN$11","v":30},{"$f":" Time!AO$11","v":31},{"$f":" Time!AP$11","v":32},{"$f":" Time!AQ$11","v":33},{"$f":" Time!AR$11","v":34},{"$f":" Time!AS$11","v":35},{"$f":" Time!AT$11","v":36},{"$f":" Time!AU$11","v":37},{"$f":" Time!AV$11","v":38},{"$f":" Time!AW$11","v":39},{"$f":" Time!AX$11","v":40}]
[]
["WORKING CAPITAL COST FOR A NOTIONAL REC GROUP ONE CUSTOMER"]
[]
[null,"Total Retailer Outflow"]
[null,null,null,null,{"$f":" Inputs!E37","v":"Monthly wholesale charge"},{"$f":" Inputs!F37","v":-37.5},{"$f":" Inputs!G37","v":"£"},{"$f":" Inputs!H37","v":0}]
[null,null,null,null,{"$f":" Time!E78","v":"Wholesale charge payment flag"},{"$f":" Time!F78","v":0},{"$f":" Time!G78","v":"flag"},{"$f":" Time!H78","v":37},null,null,{"$f":" Time!K78","v":1},{"$f":" Time!L78","v":1},{"$f":" Time!M78","v":1},{"$f":" Time!N78","v":1},{"$f":" Time!O78","v":1},{"$f":" Time!P78","v":1},{"$f":" Time!Q78","v":1},{"$f":" Time!R78","v":1},{"$f":" Time!S78","v":1},{"$f":" Time!T78","v":1},{"$f":" Time!U78","v":1},{"$f":" Time!V78","v":1},{"$f":" Time!W78","v":1},{"$f":" Time!X78","v":1},{"$f":" Time!Y78","v":1},{"$f":" Time!Z78","v":1},{"$f":" Time!AA78","v":1},{"$f":" Time!AB78","v":1},{"$f":" Time!AC78","v":1},{"$f":" Time!AD78","v":1},{"$f":" Time!AE78","v":1},{"$f":" Time!AF78","v":1},{"$f":" Time!AG78","v":1},{"$f":" Time!AH78","v":1},{"$f":" Time!AI78","v":1},{"$f":" Time!AJ78","v":1},{"$f":" Time!AK78","v":1},{"$f":" Time!AL78","v":1},{"$f":" Time!AM78","v":1},{"$f":" Time!AN78","v":1},{"$f":" Time!AO78","v":1},{"$f":" Time!AP78","v":1},{"$f":" Time!AQ78","v":1},{"$f":" Time!AR78","v":1},{"$f":" Time!AS78","v":1},{"$f":" Time!AT78","v":1},{"$f":" Time!AU78","v":1},{"$f":" Time!AV78","v":0},{"$f":" Time!AW78","v":0},{"$f":" Time!AX78","v":0}]
[null,null,null,null,"Wholesale charge",0,"£",{"$f":" SUM( K13:AX13 )","v":-1387.5},null,null,{"$f":" K12 * $F11","v":-37.5},{"$f":" L12 * $F11","v":-37.5},-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,0,0,0]
[]
[null,null,null,null,{"$f":" Inputs!E38","v":"Monthly retail cost"},{"$f":" Inputs!F38","v":-4.166666666666667},{"$f":" Inputs!G38","v":"£"},{"$f":" Inputs!H38","v":0}]
[null,null,null,null,{"$f":" Time!E83","v":"Retail cost payment flag"},null,{"$f":" Time!G83","v":"flag"},{"$f":" Time!H83","v":36},null,null,{"$f":" Time!K83","v":0},{"$f":" Time!L83","v":1},{"$f":" Time!M83","v":1},{"$f":" Time!N83","v":1},{"$f":" Time!O83","v":1},{"$f":" Time!P83","v":1},{"$f":" Time!Q83","v":1},{"$f":" Time!R83","v":1},{"$f":" Time!S83","v":1},{"$f":" Time!T83","v":1},{"$f":" Time!U83","v":1},{"$f":" Time!V83","v":1},{"$f":" Time!W83","v":1},{"$f":" Time!X83","v":1},{"$f":" Time!Y83","v":1},{"$f":" Time!Z83","v":1},{"$f":" Time!AA83","v":1},{"$f":" Time!AB83","v":1},{"$f":" Time!AC83","v":1},{"$f":" Time!AD83","v":1},{"$f":" Time!AE83","v":1},{"$f":" Time!AF83","v":1},{"$f":" Time!AG83","v":1},{"$f":" Time!AH83","v":1},{"$f":" Time!AI83","v":1},{"$f":" Time!AJ83","v":1},{"$f":" Time!AK83","v":1},{"$f":" Time!AL83","v":1},{"$f":" Time!AM83","v":1},{"$f":" Time!AN83","v":1},{"$f":" Time!AO83","v":1},{"$f":" Time!AP83","v":1},{"$f":" Time!AQ83","v":1},{"$f":" Time!AR83","v":1},{"$f":" Time!AS83","v":1},{"$f":" Time!AT83","v":1},{"$f":" Time!AU83","v":1},{"$f":" Time!AV83","v":0},{"$f":" Time!AW83","v":0},{"$f":" Time!AX83","v":0}]
[null,null,null,null,"Retail cost",0,"£",{"$f":" SUM( K17:AX17 )","v":-150},null,null,{"$f":" K16 * $F15","v":0},{"$f":" L16 * $F15","v":-4.166666666666667},{"$f":" M16 * $F15","v":-4.166666666666667},{"$f":" N16 * $F15","v":-4.166666666666667},{"$f":" O16 * $F15","v":-4.166666666666667},{"$f":" P16 * $F15","v":-4.166666666666667},{"$f":" Q16 * $F15","v":-4.166666666666667},{"$f":" R16 * $F15","v":-4.166666666666667},{"$f":" S16 * $F15","v":-4.166666666666667},{"$f":" T16 * $F15","v":-4.166666666666667},{"$f":" U16 * $F15","v":-4.166666666666667},{"$f":" V16 * $F15","v":-4.166666666666667},{"$f":" W16 * $F15","v":-4.166666666666667},{"$f":" X16 * $F15","v":-4.166666666666667},{"$f":" Y16 * $F15","v":-4.166666666666667},{"$f":" Z16 * $F15","v":-4.166666666666667},{"$f":" AA16 * $F15","v":-4.166666666666667},{"$f":" AB16 * $F15","v":-4.166666666666667},{"$f":" AC16 * $F15","v":-4.166666666666667},{"$f":" AD16 * $F15","v":-4.166666666666667},{"$f":" AE16 * $F15","v":-4.166666666666667},{"$f":" AF16 * $F15","v":-4.166666666666667},{"$f":" AG16 * $F15","v":-4.166666666666667},{"$f":" AH16 * $F15","v":-4.166666666666667},{"$f":" AI16 * $F15","v":-4.166666666666667},{"$f":" AJ16 * $F15","v":-4.166666666666667},{"$f":" AK16 * $F15","v":-4.166666666666667},{"$f":" AL16 * $F15","v":-4.166666666666667},{"$f":" AM16 * $F15","v":-4.166666666666667},{"$f":" AN16 * $F15","v":-4.166666666666667},{"$f":" AO16 * $F15","v":-4.166666666666667},{"$f":" AP16 * $F15","v":-4.166666666666667},{"$f":" AQ16 * $F15","v":-4.166666666666667},{"$f":" AR16 * $F15","v":-4.166666666666667},{"$f":" AS16 * $F15","v":-4.166666666666667},{"$f":" AT16 * $F15","v":-4.166666666666667},{"$f":" AU16 * $F15","v":-4.166666666666667},{"$f":" AV16 * $F15","v":0},{"$f":" AW16 * $F15","v":0},{"$f":" AX16 * $F15","v":0}]
[]
[null,null,null,null,{"$f":" E13","v":"Wholesale charge"},{"$f":" F13","v":0},"£",-1387.5,null,null,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,-37.5,0,0,0]
[null,null,null,null,{"$f":" E17","v":"Retail cost"},{"$f":" F17","v":0},"£",-150,null,null,0,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,-4.166666666666667,0,0,0]
[null,null,null,null,"Total Retailer outflow - CALC",0,"£",{"$f":" SUM( K21:AX21 )","v":-1537.5000000000005},null,null,{"$f":" K19 + K20","v":-37.5},{"$f":" L19 + L20","v":-41.666666666666664},-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,0,0,0]
[]
[null,"Bill issued"]
[null,null,null,null,{"$f":" Inputs!E30","v":"Annual bill"},{"$f":" Inputs!F30","v":500},{"$f":" Inputs!G30","v":"£"}]
[null,null,null,null,{"$f":" Inputs!E46","v":"Number of customer payments in a financial year"},{"$f":" Inputs!F46","v":4},{"$f":" Inputs!G46","v":"#"}]
[null,null,null,null,"Bill issued to customer - CALC",{"$f":" F24 / F25","v":125},"£"]
[]
[null,null,null,null,{"$f":" E26","v":"Bill issued to customer - CALC"},{"$f":" F26","v":125},"£",0]
[null,null,null,null,{"$f":" Time!E70","v":"Customer payment schedule flag"},null,{"$f":" Time!G70","v":"flag"},{"$f":" Time!H70","v":12},null,null,{"$f":" Time!K70","v":0},{"$f":" Time!L70","v":0},{"$f":" Time!M70","v":0},{"$f":" Time!N70","v":1},{"$f":" Time!O70","v":0},{"$f":" Time!P70","v":0},{"$f":" Time!Q70","v":1},{"$f":" Time!R70","v":0},{"$f":" Time!S70","v":0},{"$f":" Time!T70","v":1},{"$f":" Time!U70","v":0},{"$f":" Time!V70","v":0},{"$f":" Time!W70","v":1},{"$f":" Time!X70","v":0},{"$f":" Time!Y70","v":0},{"$f":" Time!Z70","v":1},{"$f":" Time!AA70","v":0},{"$f":" Time!AB70","v":0},{"$f":" Time!AC70","v":1},{"$f":" Time!AD70","v":0},{"$f":" Time!AE70","v":0},{"$f":" Time!AF70","v":1},{"$f":" Time!AG70","v":0},{"$f":" Time!AH70","v":0},{"$f":" Time!AI70","v":1},{"$f":" Time!AJ70","v":0},{"$f":" Time!AK70","v":0},{"$f":" Time!AL70","v":1},{"$f":" Time!AM70","v":0},{"$f":" Time!AN70","v":0},{"$f":" Time!AO70","v":1},{"$f":" Time!AP70","v":0},{"$f":" Time!AQ70","v":0},{"$f":" Time!AR70","v":1},{"$f":" Time!AS70","v":0},{"$f":" Time!AT70","v":0},{"$f":" Time!AU70","v":1},{"$f":" Time!AV70","v":0},{"$f":" Time!AW70","v":0},{"$f":" Time!AX70","v":0}]
[null,null,null,null,"Value of customer bills issued",null,"£",{"$f":" SUM( K30:AX30 )","v":1500},null,null,{"$f":" K29 * $F28","v":0},{"$f":" L29 * $F28","v":0},0,125,0,0,125,0,0,125,0,0,125,0,0,125,0,0,125,0,0,125,0,0,125,0,0,125,0,0,125,0,0,125,0,0,125,0,0,0]
[null,null,null,null,"Value of customer bills issued - TOTAL",{"$f":" H30","v":1500},"£"]
[]
[null,"Total Retailer Inflow"]
[null,null,null,null,{"$f":" E30","v":"Value of customer bills issued"},{"$f":"F30","v":0},"£",1500,null,0,0,0,0,125,0,0,125,0,0,125,0,0,125,0,0,125,0,0,125,0,0,125,0,0,125,0,0,125,0,0,125,0,0,125,0,0,125,0,0,0]
[null,null,null,null,{"$f":" Inputs!E53","v":"Proportion of payment received on day 15 of the month"},{"$f":" Inputs!F53","v":0.5},{"$f":" Inputs!G53","v":"%"}]
[]
[null,null,null,null,{"$f":" Inputs!E58","v":"% revenue collected after 30 days"},{"$f":" Inputs!F58","v":0.52},{"$f":" Inputs!G58","v":"%"}]
[null,null,null,null,{"$f":" Inputs!E59","v":"% revenue collected after 60 days"},{"$f":" Inputs!F59","v":0.68},{"$f":" Inputs!G59","v":"%"}]
[null,null,null,null,{"$f":" Inputs!E60","v":"% revenue collected after 90 days"},{"$f":" Inputs!F60","v":0.84},{"$f":" Inputs!G60","v":"%"}]
[]
[null,null,null,null,"Payment received 15 days after the bill is issued to the customer",null,"£",{"$f":" SUM( K41:AX41 )","v":390},null,null,{"$f":" K34 * $F35 * $F37","v":0},{"$f":" L34 * $F35 * $F37","v":0},0,32.5,0,0,32.5,0,0,32.5,0,0,32.5,0,0,32.5,0,0,32.5,0,0,32.5,0,0,32.5,0,0,32.5,0,0,32.5,0,0,32.5,0,0,32.5,0,0,0]
[null,null,null,null,"Payment received 30 days after the bill is issued to the customer",null,"£",{"$f":" SUM( K42:AX42 )","v":390},null,null,{"$f":" K34 * ( 1- $F35 ) * $F37","v":0},{"$f":" L34 * ( 1- $F35 ) * $F37","v":0},0,32.5,0,0,32.5,0,0,32.5,0,0,32.5,0,0,32.5,0,0,32.5,0,0,32.5,0,0,32.5,0,0,32.5,0,0,32.5,0,0,32.5,0,0,32.5,0,0,0]
[null,null,null,null,"Payment received 45 days after the bill is issued to the customer",null,"£",{"$f":" SUM( K43:AX43 )","v":120.00000000000001},null,null,{"$f":" J34 * $F35 * ( $F38 - $F37 )","v":0},{"$f":" K34 * $F35 * ( $F38 - $F37 )","v":0},0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0]
[null,null,null,null,"Payment received 60 days after the bill is issued to the customer",null,"£",{"$f":" SUM( K44:AX44 )","v":120.00000000000001},null,null,{"$f":" J34 * ( 1 - $F35 ) * ( $F38 - $F37 )","v":0},{"$f":" K34 * ( 1 - $F35 ) * ( $F38 - $F37 )","v":0},0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0]
[null,null,null,null,"Payment received 75 days after the bill is issued to the customer",null,"£",{"$f":" SUM( K45:AX45 )","v":119.99999999999996},null,null,{"$f":" I34 * $F35 * ( $F39 - $F38 )","v":0},{"$f":" J34 * $F35 * ( $F39 - $F38 )","v":0},0,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0]
[null,null,null,null,"Payment received 90 days after the bill is issued to the customer",null,"£",119.99999999999996,null,null,{"$f":" I34 * ( 1 - $F35 ) * ( $F39 - $F38 )","v":0},{"$f":" J34 * ( 1 - $F35 ) * ( $F39 - $F38 )","v":0},0,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0]
[null,null,null,null,"Total Retailer inflow - CALC",null,"£",{"$f":" SUM( K47:AX47)","v":1260},null,null,{"$f":" SUM( K41:K46 )","v":0},{"$f":" SUM( L41:L46 )","v":0},0,65,20.000000000000004,19.999999999999989,65,20.000000000000004,19.999999999999989,65,20.000000000000004,19.999999999999989,65,20.000000000000004,19.999999999999989,65,20.000000000000004,19.999999999999989,65,20.000000000000004,19.999999999999989,65,20.000000000000004,19.999999999999989,65,20.000000000000004,19.999999999999989,65,20.000000000000004,19.999999999999989,65,20.000000000000004,19.999999999999989,65,20.000000000000004,19.999999999999989,65,20.000000000000004,19.999999999999989,0]
[null,null,null,null,"Total Retailer inflow - TOTAL",{"$f":" H47","v":1260},"£"]
[]
[null,"Balance at the end of the month accounting for unrecovered revenue"]
[null,null,null,null,{"$f":" Inputs!E60","v":"% revenue collected after 90 days"},{"$f":" Inputs!F60","v":0.84},{"$f":" Inputs!G60","v":"%"}]
[null,null,null,null,"% of revenue outstanding after 90 days",{"$f":" 1 - F51","v":0.16000000000000003},"%"]
[]
[null,null,null,null,{"$f":" E21","v":"Total Retailer outflow - CALC"},0,"£",-1537.5000000000005,0,0,-37.5,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,0,0,0]
[null,null,null,null,{"$f":" E52","v":"% of revenue outstanding after 90 days"},{"$f":" F52","v":0.16000000000000003},"%"]
[null,null,null,null,"Value of revenue outstanding after 90 days",null,"£",{"$f":" SUM( K56:AX56 )","v":-245.99999999999991},null,null,{"$f":" K54 * $F52","v":-6.0000000000000009},-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,0,0,0]
[]
[null,null,null,null,{"$f":" E21","v":"Total Retailer outflow - CALC"},0,"£",-1537.5000000000005,0,0,-37.5,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,0,0,0]
[null,null,null,null,{"$f":" E56","v":"Value of revenue outstanding after 90 days"},{"$f":" F56","v":0},"£",{"$f":" H56","v":-245.99999999999991},0,0,-6.0000000000000009,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,-6.6666666666666679,0,0,0]
[null,null,null,null,{"$f":" E47","v":"Total Retailer inflow - CALC"},0,"£",1260,0,0,0,0,0,65,20.000000000000004,19.999999999999989,65,20.000000000000004,19.999999999999989,65,20.000000000000004,19.999999999999989,65,20.000000000000004,19.999999999999989,65,20.000000000000004,19.999999999999989,65,20.000000000000004,19.999999999999989,65,20.000000000000004,19.999999999999989,65,20.000000000000004,19.999999999999989,65,20.000000000000004,19.999999999999989,65,20.000000000000004,19.999999999999989,65,20.000000000000004,19.999999999999989,65,20.000000000000004,19.999999999999989,0]
[null,null,null,null,"Balance at the end of the period accounting for revenue collected within 90 days",null,"£",null,null,null,{"$f":" K58 - K59 + K60 + J61","v":-31.5},-66.5,-101.5,-71.5,-86.5,-101.50000000000001,-71.500000000000014,-86.500000000000014,-101.50000000000003,-71.500000000000028,-86.500000000000028,-101.50000000000004,-71.500000000000043,-86.500000000000043,-101.50000000000006,-71.500000000000057,-86.500000000000057,-101.50000000000007,-71.500000000000071,-86.500000000000071,-101.50000000000009,-71.500000000000085,-86.500000000000085,-101.5000000000001,-71.500000000000099,-86.500000000000099,-101.50000000000011,-71.500000000000114,-86.500000000000114,-101.50000000000013,-71.500000000000128,-86.500000000000128,-101.50000000000014,-71.500000000000142,-86.500000000000142,-101.50000000000016,-71.500000000000156,-51.500000000000156,-31.500000000000167,-31.500000000000167]
[]
[null,"Balance at the start of the month accounting for unrecovered revenue"]
[null,null,null,null,{"$f":" E61","v":"Balance at the end of the period accounting for revenue collected within 90 days"},{"$f":" F61","v":0},"£",0,0,0,{"$f":" K61","v":-31.5},-66.5,-101.5,-71.5,-86.5,-101.50000000000001,-71.500000000000014,-86.500000000000014,-101.50000000000003,-71.500000000000028,-86.500000000000028,-101.50000000000004,-71.500000000000043,-86.500000000000043,-101.50000000000006,-71.500000000000057,-86.500000000000057,-101.50000000000007,-71.500000000000071,-86.500000000000071,-101.50000000000009,-71.500000000000085,-86.500000000000085,-101.5000000000001,-71.500000000000099,-86.500000000000099,-101.50000000000011,-71.500000000000114,-86.500000000000114,-101.50000000000013,-71.500000000000128,-86.500000000000128,-101.50000000000014,-71.500000000000142,-86.500000000000142,-101.50000000000016,-71.500000000000156,-51.500000000000156,-31.500000000000167,-31.500000000000167]
[null,null,null,null,"Balance at the start of the period accounting for revenue collected within 90 days",null,"£",null,null,null,{"$f":" J64","v":0},{"$f":" K64","v":-31.5},-66.5,-101.5,-71.5,-86.5,-101.50000000000001,-71.500000000000014,-86.500000000000014,-101.50000000000003,-71.500000000000028,-86.500000000000028,-101.50000000000004,-71.500000000000043,-86.500000000000043,-101.50000000000006,-71.500000000000057,-86.500000000000057,-101.50000000000007,-71.500000000000071,-86.500000000000071,-101.50000000000009,-71.500000000000085,-86.500000000000085,-101.5000000000001,-71.500000000000099,-86.500000000000099,-101.50000000000011,-71.500000000000114,-86.500000000000114,-101.50000000000013,-71.500000000000128,-86.500000000000128,-101.50000000000014,-71.500000000000142,-86.500000000000142,-101.50000000000016,-71.500000000000156,-51.500000000000156,-31.500000000000167]
[]
[null,"Working capital requirement"]
[null,null,null,null,{"$f":" E65","v":"Balance at the start of the period accounting for revenue collected within 90 days"},{"$f":" F65","v":0},"£",0,0,0,0,-31.5,-66.5,-101.5,-71.5,-86.5,-101.50000000000001,-71.500000000000014,-86.500000000000014,-101.50000000000003,-71.500000000000028,-86.500000000000028,-101.50000000000004,-71.500000000000043,-86.500000000000043,-101.50000000000006,-71.500000000000057,-86.500000000000057,-101.50000000000007,-71.500000000000071,-86.500000000000071,-101.50000000000009,-71.500000000000085,-86.500000000000085,-101.5000000000001,-71.500000000000099,-86.500000000000099,-101.50000000000011,-71.500000000000114,-86.500000000000114,-101.50000000000013,-71.500000000000128,-86.500000000000128,-101.50000000000014,-71.500000000000142,-86.500000000000142,-101.50000000000016,-71.500000000000156,-51.500000000000156,-31.500000000000167]
[null,null,null,null,{"$f":" E21","v":"Total Retailer outflow - CALC"},0,"£",-1537.5000000000005,0,0,-37.5,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,-41.666666666666664,0,0,0]
[null,null,null,null,{"$f":" E56","v":"Value of revenue outstanding after 90 days"},{"$f":" F56","v":0},{"$f":" G56","v":"£"},{"$f":" - H56","v":245.99999999999991},0,0,6.0000000000000009,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,6.6666666666666679,0,0,0]
[null,null,null,null,{"$f":" E41","v":"Payment received 15 days after the bill is issued to the customer"},0,"£",390,0,0,0,0,0,32.5,0,0,32.5,0,0,32.5,0,0,32.5,0,0,32.5,0,0,32.5,0,0,32.5,0,0,32.5,0,0,32.5,0,0,32.5,0,0,32.5,0,0,32.5,0,0,0]
[null,null,null,null,{"$f":" E43","v":"Payment received 45 days after the bill is issued to the customer"},0,"£",120.00000000000001,0,0,0,0,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0,10.000000000000002,0,0]
[null,null,null,null,{"$f":" E45","v":"Payment received 75 days after the bill is issued to the customer"},0,"£",119.99999999999996,0,0,0,0,0,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0,0,9.9999999999999947,0]
[null,null,null,null,"Monthly working capital requirement - CALC",null,"£",null,null,null,{"$f":" K68 + K69 + K70 + (K71 + K72 + K73) * 0.5","v":-31.5},{"$f":" L68 + L69 + L70 + (L71 + L72 + L73) * 0.5","v":-66.499999999999986},-101.49999999999999,-120.25,-101.49999999999999,-116.49999999999999,-120.25000000000003,-101.50000000000001,-116.50000000000001,-120.25000000000003,-101.50000000000001,-116.50000000000001,-120.25000000000006,-101.50000000000004,-116.50000000000004,-120.25000000000006,-101.50000000000004,-116.50000000000004,-120.25000000000009,-101.50000000000007,-116.50000000000007,-120.25000000000009,-101.50000000000007,-116.50000000000007,-120.25000000000011,-101.5000000000001,-116.5000000000001,-120.25000000000011,-101.5000000000001,-116.5000000000001,-120.25000000000014,-101.50000000000013,-116.50000000000013,-120.25000000000014,-101.50000000000013,-116.50000000000013,-120.25000000000017,-66.500000000000156,-46.500000000000156,-31.500000000000167,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" BX68 + BX69 + BX70 + (BX71 + BX72 + BX73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" EJ68 + EJ69 + EJ70 + (EJ71 + EJ72 + EJ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" GV68 + GV69 + GV70 + (GV71 + GV72 + GV73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" JH68 + JH69 + JH70 + (JH71 + JH72 + JH73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" LT68 + LT69 + LT70 + (LT71 + LT72 + LT73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" OF68 + OF69 + OF70 + (OF71 + OF72 + OF73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" QR68 + QR69 + QR70 + (QR71 + QR72 + QR73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" TD68 + TD69 + TD70 + (TD71 + TD72 + TD73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" VP68 + VP69 + VP70 + (VP71 + VP72 + VP73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" YB68 + YB69 + YB70 + (YB71 + YB72 + YB73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" AAN68 + AAN69 + AAN70 + (AAN71 + AAN72 + AAN73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" ACZ68 + ACZ69 + ACZ70 + (ACZ71 + ACZ72 + ACZ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" AFL68 + AFL69 + AFL70 + (AFL71 + AFL72 + AFL73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" AHX68 + AHX69 + AHX70 + (AHX71 + AHX72 + AHX73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" AKJ68 + AKJ69 + AKJ70 + (AKJ71 + AKJ72 + AKJ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" AMV68 + AMV69 + AMV70 + (AMV71 + AMV72 + AMV73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" APH68 + APH69 + APH70 + (APH71 + APH72 + APH73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" ART68 + ART69 + ART70 + (ART71 + ART72 + ART73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" AUF68 + AUF69 + AUF70 + (AUF71 + AUF72 + AUF73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" AWR68 + AWR69 + AWR70 + (AWR71 + AWR72 + AWR73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" AZD68 + AZD69 + AZD70 + (AZD71 + AZD72 + AZD73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" BBP68 + BBP69 + BBP70 + (BBP71 + BBP72 + BBP73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" BEB68 + BEB69 + BEB70 + (BEB71 + BEB72 + BEB73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" BGN68 + BGN69 + BGN70 + (BGN71 + BGN72 + BGN73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" BIZ68 + BIZ69 + BIZ70 + (BIZ71 + BIZ72 + BIZ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" BLL68 + BLL69 + BLL70 + (BLL71 + BLL72 + BLL73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" BNX68 + BNX69 + BNX70 + (BNX71 + BNX72 + BNX73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" BQJ68 + BQJ69 + BQJ70 + (BQJ71 + BQJ72 + BQJ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" BSV68 + BSV69 + BSV70 + (BSV71 + BSV72 + BSV73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" BVH68 + BVH69 + BVH70 + (BVH71 + BVH72 + BVH73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" BXT68 + BXT69 + BXT70 + (BXT71 + BXT72 + BXT73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" CAF68 + CAF69 + CAF70 + (CAF71 + CAF72 + CAF73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" CCR68 + CCR69 + CCR70 + (CCR71 + CCR72 + CCR73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" CFD68 + CFD69 + CFD70 + (CFD71 + CFD72 + CFD73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" CHP68 + CHP69 + CHP70 + (CHP71 + CHP72 + CHP73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" CKB68 + CKB69 + CKB70 + (CKB71 + CKB72 + CKB73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" CMN68 + CMN69 + CMN70 + (CMN71 + CMN72 + CMN73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" COZ68 + COZ69 + COZ70 + (COZ71 + COZ72 + COZ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" CRL68 + CRL69 + CRL70 + (CRL71 + CRL72 + CRL73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" CTX68 + CTX69 + CTX70 + (CTX71 + CTX72 + CTX73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" CWJ68 + CWJ69 + CWJ70 + (CWJ71 + CWJ72 + CWJ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" CYV68 + CYV69 + CYV70 + (CYV71 + CYV72 + CYV73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" DBH68 + DBH69 + DBH70 + (DBH71 + DBH72 + DBH73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" DDT68 + DDT69 + DDT70 + (DDT71 + DDT72 + DDT73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" DGF68 + DGF69 + DGF70 + (DGF71 + DGF72 + DGF73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" DIR68 + DIR69 + DIR70 + (DIR71 + DIR72 + DIR73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" DLD68 + DLD69 + DLD70 + (DLD71 + DLD72 + DLD73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" DNP68 + DNP69 + DNP70 + (DNP71 + DNP72 + DNP73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" DQB68 + DQB69 + DQB70 + (DQB71 + DQB72 + DQB73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" DSN68 + DSN69 + DSN70 + (DSN71 + DSN72 + DSN73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" DUZ68 + DUZ69 + DUZ70 + (DUZ71 + DUZ72 + DUZ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" DXL68 + DXL69 + DXL70 + (DXL71 + DXL72 + DXL73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" DZX68 + DZX69 + DZX70 + (DZX71 + DZX72 + DZX73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" ECJ68 + ECJ69 + ECJ70 + (ECJ71 + ECJ72 + ECJ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" EEV68 + EEV69 + EEV70 + (EEV71 + EEV72 + EEV73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" EHH68 + EHH69 + EHH70 + (EHH71 + EHH72 + EHH73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" EJT68 + EJT69 + EJT70 + (EJT71 + EJT72 + EJT73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" EMF68 + EMF69 + EMF70 + (EMF71 + EMF72 + EMF73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" EOR68 + EOR69 + EOR70 + (EOR71 + EOR72 + EOR73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" ERD68 + ERD69 + ERD70 + (ERD71 + ERD72 + ERD73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" ETP68 + ETP69 + ETP70 + (ETP71 + ETP72 + ETP73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" EWB68 + EWB69 + EWB70 + (EWB71 + EWB72 + EWB73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" EYN68 + EYN69 + EYN70 + (EYN71 + EYN72 + EYN73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" FAZ68 + FAZ69 + FAZ70 + (FAZ71 + FAZ72 + FAZ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" FDL68 + FDL69 + FDL70 + (FDL71 + FDL72 + FDL73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" FFX68 + FFX69 + FFX70 + (FFX71 + FFX72 + FFX73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" FIJ68 + FIJ69 + FIJ70 + (FIJ71 + FIJ72 + FIJ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" FKV68 + FKV69 + FKV70 + (FKV71 + FKV72 + FKV73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" FNH68 + FNH69 + FNH70 + (FNH71 + FNH72 + FNH73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" FPT68 + FPT69 + FPT70 + (FPT71 + FPT72 + FPT73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" FSF68 + FSF69 + FSF70 + (FSF71 + FSF72 + FSF73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" FUR68 + FUR69 + FUR70 + (FUR71 + FUR72 + FUR73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" FXD68 + FXD69 + FXD70 + (FXD71 + FXD72 + FXD73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" FZP68 + FZP69 + FZP70 + (FZP71 + FZP72 + FZP73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" GCB68 + GCB69 + GCB70 + (GCB71 + GCB72 + GCB73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" GEN68 + GEN69 + GEN70 + (GEN71 + GEN72 + GEN73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" GGZ68 + GGZ69 + GGZ70 + (GGZ71 + GGZ72 + GGZ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" GJL68 + GJL69 + GJL70 + (GJL71 + GJL72 + GJL73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" GLX68 + GLX69 + GLX70 + (GLX71 + GLX72 + GLX73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" GOJ68 + GOJ69 + GOJ70 + (GOJ71 + GOJ72 + GOJ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" GQV68 + GQV69 + GQV70 + (GQV71 + GQV72 + GQV73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" GTH68 + GTH69 + GTH70 + (GTH71 + GTH72 + GTH73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" GVT68 + GVT69 + GVT70 + (GVT71 + GVT72 + GVT73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" GYF68 + GYF69 + GYF70 + (GYF71 + GYF72 + GYF73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" HAR68 + HAR69 + HAR70 + (HAR71 + HAR72 + HAR73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" HDD68 + HDD69 + HDD70 + (HDD71 + HDD72 + HDD73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" HFP68 + HFP69 + HFP70 + (HFP71 + HFP72 + HFP73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" HIB68 + HIB69 + HIB70 + (HIB71 + HIB72 + HIB73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" HKN68 + HKN69 + HKN70 + (HKN71 + HKN72 + HKN73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" HMZ68 + HMZ69 + HMZ70 + (HMZ71 + HMZ72 + HMZ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" HPL68 + HPL69 + HPL70 + (HPL71 + HPL72 + HPL73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" HRX68 + HRX69 + HRX70 + (HRX71 + HRX72 + HRX73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" HUJ68 + HUJ69 + HUJ70 + (HUJ71 + HUJ72 + HUJ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" HWV68 + HWV69 + HWV70 + (HWV71 + HWV72 + HWV73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" HZH68 + HZH69 + HZH70 + (HZH71 + HZH72 + HZH73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" IBT68 + IBT69 + IBT70 + (IBT71 + IBT72 + IBT73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" IEF68 + IEF69 + IEF70 + (IEF71 + IEF72 + IEF73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" IGR68 + IGR69 + IGR70 + (IGR71 + IGR72 + IGR73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" IJD68 + IJD69 + IJD70 + (IJD71 + IJD72 + IJD73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" ILP68 + ILP69 + ILP70 + (ILP71 + ILP72 + ILP73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" IOB68 + IOB69 + IOB70 + (IOB71 + IOB72 + IOB73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" IQN68 + IQN69 + IQN70 + (IQN71 + IQN72 + IQN73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" ISZ68 + ISZ69 + ISZ70 + (ISZ71 + ISZ72 + ISZ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" IVL68 + IVL69 + IVL70 + (IVL71 + IVL72 + IVL73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" IXX68 + IXX69 + IXX70 + (IXX71 + IXX72 + IXX73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" JAJ68 + JAJ69 + JAJ70 + (JAJ71 + JAJ72 + JAJ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" JCV68 + JCV69 + JCV70 + (JCV71 + JCV72 + JCV73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" JFH68 + JFH69 + JFH70 + (JFH71 + JFH72 + JFH73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" JHT68 + JHT69 + JHT70 + (JHT71 + JHT72 + JHT73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" JKF68 + JKF69 + JKF70 + (JKF71 + JKF72 + JKF73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" JMR68 + JMR69 + JMR70 + (JMR71 + JMR72 + JMR73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" JPD68 + JPD69 + JPD70 + (JPD71 + JPD72 + JPD73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" JRP68 + JRP69 + JRP70 + (JRP71 + JRP72 + JRP73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" JUB68 + JUB69 + JUB70 + (JUB71 + JUB72 + JUB73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" JWN68 + JWN69 + JWN70 + (JWN71 + JWN72 + JWN73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" JYZ68 + JYZ69 + JYZ70 + (JYZ71 + JYZ72 + JYZ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" KBL68 + KBL69 + KBL70 + (KBL71 + KBL72 + KBL73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" KDX68 + KDX69 + KDX70 + (KDX71 + KDX72 + KDX73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" KGJ68 + KGJ69 + KGJ70 + (KGJ71 + KGJ72 + KGJ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" KIV68 + KIV69 + KIV70 + (KIV71 + KIV72 + KIV73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" KLH68 + KLH69 + KLH70 + (KLH71 + KLH72 + KLH73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" KNT68 + KNT69 + KNT70 + (KNT71 + KNT72 + KNT73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" KQF68 + KQF69 + KQF70 + (KQF71 + KQF72 + KQF73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" KSR68 + KSR69 + KSR70 + (KSR71 + KSR72 + KSR73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" KVD68 + KVD69 + KVD70 + (KVD71 + KVD72 + KVD73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" KXP68 + KXP69 + KXP70 + (KXP71 + KXP72 + KXP73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" LAB68 + LAB69 + LAB70 + (LAB71 + LAB72 + LAB73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" LCN68 + LCN69 + LCN70 + (LCN71 + LCN72 + LCN73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" LEZ68 + LEZ69 + LEZ70 + (LEZ71 + LEZ72 + LEZ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" LHL68 + LHL69 + LHL70 + (LHL71 + LHL72 + LHL73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" LJX68 + LJX69 + LJX70 + (LJX71 + LJX72 + LJX73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" LMJ68 + LMJ69 + LMJ70 + (LMJ71 + LMJ72 + LMJ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" LOV68 + LOV69 + LOV70 + (LOV71 + LOV72 + LOV73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" LRH68 + LRH69 + LRH70 + (LRH71 + LRH72 + LRH73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" LTT68 + LTT69 + LTT70 + (LTT71 + LTT72 + LTT73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" LWF68 + LWF69 + LWF70 + (LWF71 + LWF72 + LWF73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" LYR68 + LYR69 + LYR70 + (LYR71 + LYR72 + LYR73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" MBD68 + MBD69 + MBD70 + (MBD71 + MBD72 + MBD73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" MDP68 + MDP69 + MDP70 + (MDP71 + MDP72 + MDP73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" MGB68 + MGB69 + MGB70 + (MGB71 + MGB72 + MGB73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" MIN68 + MIN69 + MIN70 + (MIN71 + MIN72 + MIN73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" MKZ68 + MKZ69 + MKZ70 + (MKZ71 + MKZ72 + MKZ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" MNL68 + MNL69 + MNL70 + (MNL71 + MNL72 + MNL73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" MPX68 + MPX69 + MPX70 + (MPX71 + MPX72 + MPX73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" MSJ68 + MSJ69 + MSJ70 + (MSJ71 + MSJ72 + MSJ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" MUV68 + MUV69 + MUV70 + (MUV71 + MUV72 + MUV73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" MXH68 + MXH69 + MXH70 + (MXH71 + MXH72 + MXH73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" MZT68 + MZT69 + MZT70 + (MZT71 + MZT72 + MZT73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" NCF68 + NCF69 + NCF70 + (NCF71 + NCF72 + NCF73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" NER68 + NER69 + NER70 + (NER71 + NER72 + NER73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" NHD68 + NHD69 + NHD70 + (NHD71 + NHD72 + NHD73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" NJP68 + NJP69 + NJP70 + (NJP71 + NJP72 + NJP73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" NMB68 + NMB69 + NMB70 + (NMB71 + NMB72 + NMB73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" NON68 + NON69 + NON70 + (NON71 + NON72 + NON73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" NQZ68 + NQZ69 + NQZ70 + (NQZ71 + NQZ72 + NQZ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" NTL68 + NTL69 + NTL70 + (NTL71 + NTL72 + NTL73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" NVX68 + NVX69 + NVX70 + (NVX71 + NVX72 + NVX73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" NYJ68 + NYJ69 + NYJ70 + (NYJ71 + NYJ72 + NYJ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" OAV68 + OAV69 + OAV70 + (OAV71 + OAV72 + OAV73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" ODH68 + ODH69 + ODH70 + (ODH71 + ODH72 + ODH73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" OFT68 + OFT69 + OFT70 + (OFT71 + OFT72 + OFT73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" OIF68 + OIF69 + OIF70 + (OIF71 + OIF72 + OIF73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" OKR68 + OKR69 + OKR70 + (OKR71 + OKR72 + OKR73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" OND68 + OND69 + OND70 + (OND71 + OND72 + OND73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" OPP68 + OPP69 + OPP70 + (OPP71 + OPP72 + OPP73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" OSB68 + OSB69 + OSB70 + (OSB71 + OSB72 + OSB73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" OUN68 + OUN69 + OUN70 + (OUN71 + OUN72 + OUN73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" OWZ68 + OWZ69 + OWZ70 + (OWZ71 + OWZ72 + OWZ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" OZL68 + OZL69 + OZL70 + (OZL71 + OZL72 + OZL73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" PBX68 + PBX69 + PBX70 + (PBX71 + PBX72 + PBX73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" PEJ68 + PEJ69 + PEJ70 + (PEJ71 + PEJ72 + PEJ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" PGV68 + PGV69 + PGV70 + (PGV71 + PGV72 + PGV73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" PJH68 + PJH69 + PJH70 + (PJH71 + PJH72 + PJH73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" PLT68 + PLT69 + PLT70 + (PLT71 + PLT72 + PLT73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" POF68 + POF69 + POF70 + (POF71 + POF72 + POF73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" PQR68 + PQR69 + PQR70 + (PQR71 + PQR72 + PQR73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" PTD68 + PTD69 + PTD70 + (PTD71 + PTD72 + PTD73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" PVP68 + PVP69 + PVP70 + (PVP71 + PVP72 + PVP73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" PYB68 + PYB69 + PYB70 + (PYB71 + PYB72 + PYB73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" QAN68 + QAN69 + QAN70 + (QAN71 + QAN72 + QAN73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" QCZ68 + QCZ69 + QCZ70 + (QCZ71 + QCZ72 + QCZ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" QFL68 + QFL69 + QFL70 + (QFL71 + QFL72 + QFL73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" QHX68 + QHX69 + QHX70 + (QHX71 + QHX72 + QHX73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" QKJ68 + QKJ69 + QKJ70 + (QKJ71 + QKJ72 + QKJ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" QMV68 + QMV69 + QMV70 + (QMV71 + QMV72 + QMV73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" QPH68 + QPH69 + QPH70 + (QPH71 + QPH72 + QPH73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" QRT68 + QRT69 + QRT70 + (QRT71 + QRT72 + QRT73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" QUF68 + QUF69 + QUF70 + (QUF71 + QUF72 + QUF73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" QWR68 + QWR69 + QWR70 + (QWR71 + QWR72 + QWR73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" QZD68 + QZD69 + QZD70 + (QZD71 + QZD72 + QZD73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" RBP68 + RBP69 + RBP70 + (RBP71 + RBP72 + RBP73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" REB68 + REB69 + REB70 + (REB71 + REB72 + REB73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" RGN68 + RGN69 + RGN70 + (RGN71 + RGN72 + RGN73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" RIZ68 + RIZ69 + RIZ70 + (RIZ71 + RIZ72 + RIZ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" RLL68 + RLL69 + RLL70 + (RLL71 + RLL72 + RLL73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" RNX68 + RNX69 + RNX70 + (RNX71 + RNX72 + RNX73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" RQJ68 + RQJ69 + RQJ70 + (RQJ71 + RQJ72 + RQJ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" RSV68 + RSV69 + RSV70 + (RSV71 + RSV72 + RSV73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" RVH68 + RVH69 + RVH70 + (RVH71 + RVH72 + RVH73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" RXT68 + RXT69 + RXT70 + (RXT71 + RXT72 + RXT73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" SAF68 + SAF69 + SAF70 + (SAF71 + SAF72 + SAF73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" SCR68 + SCR69 + SCR70 + (SCR71 + SCR72 + SCR73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" SFD68 + SFD69 + SFD70 + (SFD71 + SFD72 + SFD73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" SHP68 + SHP69 + SHP70 + (SHP71 + SHP72 + SHP73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" SKB68 + SKB69 + SKB70 + (SKB71 + SKB72 + SKB73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" SMN68 + SMN69 + SMN70 + (SMN71 + SMN72 + SMN73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" SOZ68 + SOZ69 + SOZ70 + (SOZ71 + SOZ72 + SOZ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" SRL68 + SRL69 + SRL70 + (SRL71 + SRL72 + SRL73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" STX68 + STX69 + STX70 + (STX71 + STX72 + STX73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" SWJ68 + SWJ69 + SWJ70 + (SWJ71 + SWJ72 + SWJ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" SYV68 + SYV69 + SYV70 + (SYV71 + SYV72 + SYV73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" TBH68 + TBH69 + TBH70 + (TBH71 + TBH72 + TBH73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" TDT68 + TDT69 + TDT70 + (TDT71 + TDT72 + TDT73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" TGF68 + TGF69 + TGF70 + (TGF71 + TGF72 + TGF73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" TIR68 + TIR69 + TIR70 + (TIR71 + TIR72 + TIR73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" TLD68 + TLD69 + TLD70 + (TLD71 + TLD72 + TLD73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" TNP68 + TNP69 + TNP70 + (TNP71 + TNP72 + TNP73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" TQB68 + TQB69 + TQB70 + (TQB71 + TQB72 + TQB73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" TSN68 + TSN69 + TSN70 + (TSN71 + TSN72 + TSN73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" TUZ68 + TUZ69 + TUZ70 + (TUZ71 + TUZ72 + TUZ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" TXL68 + TXL69 + TXL70 + (TXL71 + TXL72 + TXL73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" TZX68 + TZX69 + TZX70 + (TZX71 + TZX72 + TZX73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" UCJ68 + UCJ69 + UCJ70 + (UCJ71 + UCJ72 + UCJ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" UEV68 + UEV69 + UEV70 + (UEV71 + UEV72 + UEV73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" UHH68 + UHH69 + UHH70 + (UHH71 + UHH72 + UHH73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" UJT68 + UJT69 + UJT70 + (UJT71 + UJT72 + UJT73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" UMF68 + UMF69 + UMF70 + (UMF71 + UMF72 + UMF73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" UOR68 + UOR69 + UOR70 + (UOR71 + UOR72 + UOR73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" URD68 + URD69 + URD70 + (URD71 + URD72 + URD73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" UTP68 + UTP69 + UTP70 + (UTP71 + UTP72 + UTP73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" UWB68 + UWB69 + UWB70 + (UWB71 + UWB72 + UWB73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" UYN68 + UYN69 + UYN70 + (UYN71 + UYN72 + UYN73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" VAZ68 + VAZ69 + VAZ70 + (VAZ71 + VAZ72 + VAZ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" VDL68 + VDL69 + VDL70 + (VDL71 + VDL72 + VDL73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" VFX68 + VFX69 + VFX70 + (VFX71 + VFX72 + VFX73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" VIJ68 + VIJ69 + VIJ70 + (VIJ71 + VIJ72 + VIJ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" VKV68 + VKV69 + VKV70 + (VKV71 + VKV72 + VKV73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" VNH68 + VNH69 + VNH70 + (VNH71 + VNH72 + VNH73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" VPT68 + VPT69 + VPT70 + (VPT71 + VPT72 + VPT73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" VSF68 + VSF69 + VSF70 + (VSF71 + VSF72 + VSF73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" VUR68 + VUR69 + VUR70 + (VUR71 + VUR72 + VUR73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" VXD68 + VXD69 + VXD70 + (VXD71 + VXD72 + VXD73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" VZP68 + VZP69 + VZP70 + (VZP71 + VZP72 + VZP73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" WCB68 + WCB69 + WCB70 + (WCB71 + WCB72 + WCB73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" WEN68 + WEN69 + WEN70 + (WEN71 + WEN72 + WEN73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" WGZ68 + WGZ69 + WGZ70 + (WGZ71 + WGZ72 + WGZ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" WJL68 + WJL69 + WJL70 + (WJL71 + WJL72 + WJL73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" WLX68 + WLX69 + WLX70 + (WLX71 + WLX72 + WLX73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" WOJ68 + WOJ69 + WOJ70 + (WOJ71 + WOJ72 + WOJ73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" WQV68 + WQV69 + WQV70 + (WQV71 + WQV72 + WQV73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" WTH68 + WTH69 + WTH70 + (WTH71 + WTH72 + WTH73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" WVT68 + WVT69 + WVT70 + (WVT71 + WVT72 + WVT73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" WYF68 + WYF69 + WYF70 + (WYF71 + WYF72 + WYF73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" XAR68 + XAR69 + XAR70 + (XAR71 + XAR72 + XAR73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" XDD68 + XDD69 + XDD70 + (XDD71 + XDD72 + XDD73) * 0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E74","v":"Monthly working capital requirement - CALC"},{"$f":" F74","v":0},"£",0,0,0,-31.5,-66.499999999999986,-101.49999999999999,-120.25,-101.49999999999999,-116.49999999999999,-120.25000000000003,-101.50000000000001,-116.50000000000001,-120.25000000000003,-101.50000000000001,-116.50000000000001,-120.25000000000006,-101.50000000000004,-116.50000000000004,-120.25000000000006,-101.50000000000004,-116.50000000000004,-120.25000000000009,-101.50000000000007,-116.50000000000007,-120.25000000000009,-101.50000000000007,-116.50000000000007,-120.25000000000011,-101.5000000000001,-116.5000000000001,-120.25000000000011,-101.5000000000001,-116.5000000000001,-120.25000000000014,-101.50000000000013,-116.50000000000013,-120.25000000000014,-101.50000000000013,-116.50000000000013,-120.25000000000017,-66.500000000000156,-46.500000000000156,-31.500000000000167]
[null,null,null,null,{"$f":" Inputs!E66","v":"Monthly interest rate (monthly compound interest rate)"},{"$f":" Inputs!F66","v":4.0741237836483535E-3},{"$f":" Inputs!G66","v":"%"}]
[null,null,null,null,"Monthly cost of financing working capital",null,"£",null,null,null,{"$f":" K76 * $F77","v":-0.12833489918492313},{"$f":" L76 * $F77","v":-0.27092923161261545},-0.41352356404030782,-0.48991338498371451,-0.41352356404030782,-0.47463542079503312,-0.48991338498371462,-0.41352356404030793,-0.47463542079503324,-0.48991338498371462,-0.41352356404030793,-0.47463542079503324,-0.48991338498371473,-0.41352356404030804,-0.47463542079503335,-0.48991338498371473,-0.41352356404030804,-0.47463542079503335,-0.48991338498371484,-0.41352356404030816,-0.47463542079503346,-0.48991338498371484,-0.41352356404030816,-0.47463542079503346,-0.48991338498371495,-0.41352356404030827,-0.47463542079503357,-0.48991338498371495,-0.41352356404030827,-0.47463542079503357,-0.48991338498371506,-0.41352356404030838,-0.47463542079503368,-0.48991338498371506,-0.41352356404030838,-0.47463542079503368,-0.48991338498371523,-0.27092923161261612,-0.18944675593964908,-0.12833489918492383]
[]
[null,null,null,null,{"$f":" E78","v":"Monthly cost of financing working capital"},{"$f":" F78","v":0},"£",0,0,0,{"$f":" K78","v":-0.12833489918492313},-0.27092923161261545,-0.41352356404030782,-0.48991338498371451,-0.41352356404030782,-0.47463542079503312,-0.48991338498371462,-0.41352356404030793,-0.47463542079503324,-0.48991338498371462,-0.41352356404030793,-0.47463542079503324,-0.48991338498371473,-0.41352356404030804,-0.47463542079503335,-0.48991338498371473,-0.41352356404030804,-0.47463542079503335,-0.48991338498371484,-0.41352356404030816,-0.47463542079503346,-0.48991338498371484,-0.41352356404030816,-0.47463542079503346,-0.48991338498371495,-0.41352356404030827,-0.47463542079503357,-0.48991338498371495,-0.41352356404030827,-0.47463542079503357,-0.48991338498371506,-0.41352356404030838,-0.47463542079503368,-0.48991338498371506,-0.41352356404030838,-0.47463542079503368,-0.48991338498371523,-0.27092923161261612,-0.18944675593964908,-0.12833489918492383]
[null,null,null,null,{"$f":" Time!E35","v":"Working capital modelling period flag"},{"$f":" Time!F35","v":0},{"$f":" Time!G35","v":"flag"},{"$f":" Time!H35","v":12},{"$f":" Time!I35","v":0},{"$f":" Time!J35","v":0},{"$f":" Time!K35","v":0},{"$f":" Time!L35","v":0},{"$f":" Time!M35","v":0},{"$f":" Time!N35","v":0},{"$f":" Time!O35","v":0},{"$f":" Time!P35","v":0},{"$f":" Time!Q35","v":0},{"$f":" Time!R35","v":0},{"$f":" Time!S35","v":0},{"$f":" Time!T35","v":0},{"$f":" Time!U35","v":0},{"$f":" Time!V35","v":0},{"$f":" Time!W35","v":0},{"$f":" Time!X35","v":1},{"$f":" Time!Y35","v":1},{"$f":" Time!Z35","v":1},{"$f":" Time!AA35","v":1},{"$f":" Time!AB35","v":1},{"$f":" Time!AC35","v":1},{"$f":" Time!AD35","v":1},{"$f":" Time!AE35","v":1},{"$f":" Time!AF35","v":1},{"$f":" Time!AG35","v":1},{"$f":" Time!AH35","v":1},{"$f":" Time!AI35","v":1},{"$f":" Time!AJ35","v":0},{"$f":" Time!AK35","v":0},{"$f":" Time!AL35","v":0},{"$f":" Time!AM35","v":0},{"$f":" Time!AN35","v":0},{"$f":" Time!AO35","v":0},{"$f":" Time!AP35","v":0},{"$f":" Time!AQ35","v":0},{"$f":" Time!AR35","v":0},{"$f":" Time!AS35","v":0},{"$f":" Time!AT35","v":0},{"$f":" Time!AU35","v":0},{"$f":" Time!AV35","v":0},{"$f":" Time!AW35","v":0},{"$f":" Time!AX35","v":0}]
[null,null,null,null,"Total working capital cost for period FY",null,"£",{"$f":" SUM( K82:AX82 )","v":-5.5122894792762258},null,null,{"$f":" K80 * K81","v":0},{"$f":" L80 * L81","v":0},0,0,0,0,0,0,0,0,0,0,0,-0.41352356404030804,-0.47463542079503335,-0.48991338498371473,-0.41352356404030804,-0.47463542079503335,-0.48991338498371484,-0.41352356404030816,-0.47463542079503346,-0.48991338498371484,-0.41352356404030816,-0.47463542079503346,-0.48991338498371495,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Total working capital cost for period FY - TOTAL",{"$f":"  H82 * -1","v":5.5122894792762258},"£"]
[]
[null,null,null,null,{"$f":" E83","v":"Total working capital cost for period FY - TOTAL"},{"$f":" F83","v":5.5122894792762258},{"$f":" G83","v":"£"},0]
[null,null,null,null,{"$f":" Inputs!E30","v":"Annual bill"},{"$f":" Inputs!F30","v":500},{"$f":" Inputs!G30","v":"£"},{"$f":" Inputs!H30","v":0}]
[null,null,null,null,"Working capital cost as a proportion of the annual customer bill",{"$f":" F85 / F86","v":1.1024578958552451E-2},"%"]
[]
[null,"Difference in the value of customer bill to be collected within 90 days and the total Retailer inflow accounting for unrecovered revenue"]
[]
[null,null,null,null,{"$f":" E31","v":"Value of customer bills issued - TOTAL"},{"$f":" F31","v":1500},{"$f":" G31","v":"£"}]
[null,null,null,null,{"$f":" Inputs!E60","v":"% revenue collected after 90 days"},{"$f":" Inputs!F60","v":0.84},{"$f":" Inputs!G60","v":"%"}]
[null,null,null,null,"Total value of customer bill modelled - CALC",{"$f":" F91 * F92","v":1260},"£"]
[null,null,null,null,{"$f":" E48","v":"Total Retailer inflow - TOTAL"},{"$f":" F48","v":1260},{"$f":" G48","v":"£"}]
[]
[null,null,null,null,"Difference in the value of customer bill to be collected within 90 days and the total Retailer inflow accounting for unrecovered revenue",{"$f":" F93 - F94","v":0},"£"]
[null,null,null,null,"Difference in the value of customer bill to be collected within 90 days and the total Retailer inflow accounting for unrecovered revenue - Check",{"$f":" IF( $F96 <> 0, 1, 0 )","v":0},"check"]
[]
[]
["END"]

{"sheet":"Outputs-->","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Working capital costs","index":9,"n_rows":17,"n_cols":50,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Working capital costs"}]
[null,null,null,null,{"$f":" Time!E$24","v":"Model Period BEG"},null,null,null,null,null,{"$f":" Time!K$24","v":"2023-03-01"},{"$f":" Time!L$24","v":"2023-04-01"},{"$f":" Time!M$24","v":"2023-05-01"},{"$f":" Time!N$24","v":"2023-06-01"},{"$f":" Time!O$24","v":"2023-07-01"},{"$f":" Time!P$24","v":"2023-08-01"},{"$f":" Time!Q$24","v":"2023-09-01"},{"$f":" Time!R$24","v":"2023-10-01"},{"$f":" Time!S$24","v":"2023-11-01"},{"$f":" Time!T$24","v":"2023-12-01"},{"$f":" Time!U$24","v":"2024-01-01"},{"$f":" Time!V$24","v":"2024-02-01"},{"$f":" Time!W$24","v":"2024-03-01"},{"$f":" Time!X$24","v":"2024-04-01"},{"$f":" Time!Y$24","v":"2024-05-01"},{"$f":" Time!Z$24","v":"2024-06-01"},{"$f":" Time!AA$24","v":"2024-07-01"},{"$f":" Time!AB$24","v":"2024-08-01"},{"$f":" Time!AC$24","v":"2024-09-01"},{"$f":" Time!AD$24","v":"2024-10-01"},{"$f":" Time!AE$24","v":"2024-11-01"},{"$f":" Time!AF$24","v":"2024-12-01"},{"$f":" Time!AG$24","v":"2025-01-01"},{"$f":" Time!AH$24","v":"2025-02-01"},{"$f":" Time!AI$24","v":"2025-03-01"},{"$f":" Time!AJ$24","v":"2025-04-01"},{"$f":" Time!AK$24","v":"2025-05-01"},{"$f":" Time!AL$24","v":"2025-06-01"},{"$f":" Time!AM$24","v":"2025-07-01"},{"$f":" Time!AN$24","v":"2025-08-01"},{"$f":" Time!AO$24","v":"2025-09-01"},{"$f":" Time!AP$24","v":"2025-10-01"},{"$f":" Time!AQ$24","v":"2025-11-01"},{"$f":" Time!AR$24","v":"2025-12-01"},{"$f":" Time!AS$24","v":"2026-01-01"},{"$f":" Time!AT$24","v":"2026-02-01"},{"$f":" Time!AU$24","v":"2026-03-01"},{"$f":" Time!AV$24","v":"2026-04-01"},{"$f":" Time!AW$24","v":"2026-05-01"},{"$f":" Time!AX$24","v":"2026-06-01"}]
[null,null,null,null,{"$f":" Time!E$27","v":"Model Period END"},{"$f":" Check!F$8","v":0},"Error chks",null,null,null,{"$f":" Time!K$27","v":"2023-03-31"},{"$f":" Time!L$27","v":"2023-04-30"},{"$f":" Time!M$27","v":"2023-05-31"},{"$f":" Time!N$27","v":"2023-06-30"},{"$f":" Time!O$27","v":"2023-07-31"},{"$f":" Time!P$27","v":"2023-08-31"},{"$f":" Time!Q$27","v":"2023-09-30"},{"$f":" Time!R$27","v":"2023-10-31"},{"$f":" Time!S$27","v":"2023-11-30"},{"$f":" Time!T$27","v":"2023-12-31"},{"$f":" Time!U$27","v":"2024-01-31"},{"$f":" Time!V$27","v":"2024-02-29"},{"$f":" Time!W$27","v":"2024-03-31"},{"$f":" Time!X$27","v":"2024-04-30"},{"$f":" Time!Y$27","v":"2024-05-31"},{"$f":" Time!Z$27","v":"2024-06-30"},{"$f":" Time!AA$27","v":"2024-07-31"},{"$f":" Time!AB$27","v":"2024-08-31"},{"$f":" Time!AC$27","v":"2024-09-30"},{"$f":" Time!AD$27","v":"2024-10-31"},{"$f":" Time!AE$27","v":"2024-11-30"},{"$f":" Time!AF$27","v":"2024-12-31"},{"$f":" Time!AG$27","v":"2025-01-31"},{"$f":" Time!AH$27","v":"2025-02-28"},{"$f":" Time!AI$27","v":"2025-03-31"},{"$f":" Time!AJ$27","v":"2025-04-30"},{"$f":" Time!AK$27","v":"2025-05-31"},{"$f":" Time!AL$27","v":"2025-06-30"},{"$f":" Time!AM$27","v":"2025-07-31"},{"$f":" Time!AN$27","v":"2025-08-31"},{"$f":" Time!AO$27","v":"2025-09-30"},{"$f":" Time!AP$27","v":"2025-10-31"},{"$f":" Time!AQ$27","v":"2025-11-30"},{"$f":" Time!AR$27","v":"2025-12-31"},{"$f":" Time!AS$27","v":"2026-01-31"},{"$f":" Time!AT$27","v":"2026-02-28"},{"$f":" Time!AU$27","v":"2026-03-31"},{"$f":" Time!AV$27","v":"2026-04-30"},{"$f":" Time!AW$27","v":"2026-05-31"},{"$f":" Time!AX$27","v":"2026-06-30"}]
[null,null,null,null,{"$f":" Time!E$100","v":"Period reference"},null,null,null,null,null,{"$f":" Time!K$100","v":"Pre model period"},{"$f":" Time!L$100","v":"Pre model period"},{"$f":" Time!M$100","v":"Pre model period"},{"$f":" Time!N$100","v":"Pre model period"},{"$f":" Time!O$100","v":"Pre model period"},{"$f":" Time!P$100","v":"Pre model period"},{"$f":" Time!Q$100","v":"Pre model period"},{"$f":" Time!R$100","v":"Pre model period"},{"$f":" Time!S$100","v":"Pre model period"},{"$f":" Time!T$100","v":"Pre model period"},{"$f":" Time!U$100","v":"Pre model period"},{"$f":" Time!V$100","v":"Pre model period"},{"$f":" Time!W$100","v":"Pre model period"},{"$f":" Time!X$100","v":"W.C. model period"},{"$f":" Time!Y$100","v":"W.C. model period"},{"$f":" Time!Z$100","v":"W.C. model period"},{"$f":" Time!AA$100","v":"W.C. model period"},{"$f":" Time!AB$100","v":"W.C. model period"},{"$f":" Time!AC$100","v":"W.C. model period"},{"$f":" Time!AD$100","v":"W.C. model period"},{"$f":" Time!AE$100","v":"W.C. model period"},{"$f":" Time!AF$100","v":"W.C. model period"},{"$f":" Time!AG$100","v":"W.C. model period"},{"$f":" Time!AH$100","v":"W.C. model period"},{"$f":" Time!AI$100","v":"W.C. model period"},{"$f":" Time!AJ$100","v":"Post model period"},{"$f":" Time!AK$100","v":"Post model period"},{"$f":" Time!AL$100","v":"Post model period"},{"$f":" Time!AM$100","v":"Post model period"},{"$f":" Time!AN$100","v":"Post model period"},{"$f":" Time!AO$100","v":"Post model period"},{"$f":" Time!AP$100","v":"Post model period"},{"$f":" Time!AQ$100","v":"Post model period"},{"$f":" Time!AR$100","v":"Post model period"},{"$f":" Time!AS$100","v":"Post model period"},{"$f":" Time!AT$100","v":"Post model period"},{"$f":" Time!AU$100","v":"Post model period"},{"$f":" Time!AV$100","v":"Post model period"},{"$f":" Time!AW$100","v":"Post model period"},{"$f":" Time!AX$100","v":"Post model period"}]
[null,null,null,null,{"$f":" Time!E$91","v":"Financial Year Reference"},null,null,null,null,null,{"$f":" Time!K$91","v":"FY-2"},{"$f":" Time!L$91","v":"FY-1"},{"$f":" Time!M$91","v":"FY-1"},{"$f":" Time!N$91","v":"FY-1"},{"$f":" Time!O$91","v":"FY-1"},{"$f":" Time!P$91","v":"FY-1"},{"$f":" Time!Q$91","v":"FY-1"},{"$f":" Time!R$91","v":"FY-1"},{"$f":" Time!S$91","v":"FY-1"},{"$f":" Time!T$91","v":"FY-1"},{"$f":" Time!U$91","v":"FY-1"},{"$f":" Time!V$91","v":"FY-1"},{"$f":" Time!W$91","v":"FY-1"},{"$f":" Time!X$91","v":"FY"},{"$f":" Time!Y$91","v":"FY"},{"$f":" Time!Z$91","v":"FY"},{"$f":" Time!AA$91","v":"FY"},{"$f":" Time!AB$91","v":"FY"},{"$f":" Time!AC$91","v":"FY"},{"$f":" Time!AD$91","v":"FY"},{"$f":" Time!AE$91","v":"FY"},{"$f":" Time!AF$91","v":"FY"},{"$f":" Time!AG$91","v":"FY"},{"$f":" Time!AH$91","v":"FY"},{"$f":" Time!AI$91","v":"FY"},{"$f":" Time!AJ$91","v":"FY+1"},{"$f":" Time!AK$91","v":"FY+1"},{"$f":" Time!AL$91","v":"FY+1"},{"$f":" Time!AM$91","v":"FY+1"},{"$f":" Time!AN$91","v":"FY+1"},{"$f":" Time!AO$91","v":"FY+1"},{"$f":" Time!AP$91","v":"FY+1"},{"$f":" Time!AQ$91","v":"FY+1"},{"$f":" Time!AR$91","v":"FY+1"},{"$f":" Time!AS$91","v":"FY+1"},{"$f":" Time!AT$91","v":"FY+1"},{"$f":" Time!AU$91","v":"FY+1"},{"$f":" Time!AV$91","v":"FY+2"},{"$f":" Time!AW$91","v":"FY+2"},{"$f":" Time!AX$91","v":"FY+2"}]
[null,null,null,null,{"$f":" Time!E$11","v":"Model column counter"},"Constant","Unit","Total",null,null,{"$f":" Time!K$11","v":1},{"$f":" Time!L$11","v":2},{"$f":" Time!M$11","v":3},{"$f":" Time!N$11","v":4},{"$f":" Time!O$11","v":5},{"$f":" Time!P$11","v":6},{"$f":" Time!Q$11","v":7},{"$f":" Time!R$11","v":8},{"$f":" Time!S$11","v":9},{"$f":" Time!T$11","v":10},{"$f":" Time!U$11","v":11},{"$f":" Time!V$11","v":12},{"$f":" Time!W$11","v":13},{"$f":" Time!X$11","v":14},{"$f":" Time!Y$11","v":15},{"$f":" Time!Z$11","v":16},{"$f":" Time!AA$11","v":17},{"$f":" Time!AB$11","v":18},{"$f":" Time!AC$11","v":19},{"$f":" Time!AD$11","v":20},{"$f":" Time!AE$11","v":21},{"$f":" Time!AF$11","v":22},{"$f":" Time!AG$11","v":23},{"$f":" Time!AH$11","v":24},{"$f":" Time!AI$11","v":25},{"$f":" Time!AJ$11","v":26},{"$f":" Time!AK$11","v":27},{"$f":" Time!AL$11","v":28},{"$f":" Time!AM$11","v":29},{"$f":" Time!AN$11","v":30},{"$f":" Time!AO$11","v":31},{"$f":" Time!AP$11","v":32},{"$f":" Time!AQ$11","v":33},{"$f":" Time!AR$11","v":34},{"$f":" Time!AS$11","v":35},{"$f":" Time!AT$11","v":36},{"$f":" Time!AU$11","v":37},{"$f":" Time!AV$11","v":38},{"$f":" Time!AW$11","v":39},{"$f":" Time!AX$11","v":40}]
[]
["WORKING CAPITAL COSTS FOR A NOTIONAL GROUP ONE CUSTOMER"]
[]
[null,null,null,null,{"$f":" Inputs!E65","v":"Annual financing cost"},{"$f":" Inputs!F65","v":0.05},{"$f":" Inputs!G65","v":"%"}]
[]
[null,null,null,null,{"$f":" Calculations!E85","v":"Total working capital cost for period FY - TOTAL"},{"$f":" Calculations!F85","v":5.5122894792762258},{"$f":" Calculations!G85","v":"£"}]
[null,null,null,null,{"$f":" Calculations!E86","v":"Annual bill"},{"$f":" Calculations!F86","v":500},{"$f":" Calculations!G86","v":"£"}]
[null,null,null,null,{"$f":" Calculations!E87","v":"Working capital cost as a proportion of the annual customer bill"},{"$f":" Calculations!F87","v":1.1024578958552451E-2},{"$f":" Calculations!G87","v":"%"}]
[]
[]
["END"]

{"sheet":"Integrity checks-->","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Check","index":11,"n_rows":15,"n_cols":50,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Check"}]
[null,null,null,null,{"$f":" Time!E$24","v":"Model Period BEG"},null,null,null,null,null,{"$f":" Time!K$24","v":"2023-03-01"},{"$f":" Time!L$24","v":"2023-04-01"},{"$f":" Time!M$24","v":"2023-05-01"},{"$f":" Time!N$24","v":"2023-06-01"},{"$f":" Time!O$24","v":"2023-07-01"},{"$f":" Time!P$24","v":"2023-08-01"},{"$f":" Time!Q$24","v":"2023-09-01"},{"$f":" Time!R$24","v":"2023-10-01"},{"$f":" Time!S$24","v":"2023-11-01"},{"$f":" Time!T$24","v":"2023-12-01"},{"$f":" Time!U$24","v":"2024-01-01"},{"$f":" Time!V$24","v":"2024-02-01"},{"$f":" Time!W$24","v":"2024-03-01"},{"$f":" Time!X$24","v":"2024-04-01"},{"$f":" Time!Y$24","v":"2024-05-01"},{"$f":" Time!Z$24","v":"2024-06-01"},{"$f":" Time!AA$24","v":"2024-07-01"},{"$f":" Time!AB$24","v":"2024-08-01"},{"$f":" Time!AC$24","v":"2024-09-01"},{"$f":" Time!AD$24","v":"2024-10-01"},{"$f":" Time!AE$24","v":"2024-11-01"},{"$f":" Time!AF$24","v":"2024-12-01"},{"$f":" Time!AG$24","v":"2025-01-01"},{"$f":" Time!AH$24","v":"2025-02-01"},{"$f":" Time!AI$24","v":"2025-03-01"},{"$f":" Time!AJ$24","v":"2025-04-01"},{"$f":" Time!AK$24","v":"2025-05-01"},{"$f":" Time!AL$24","v":"2025-06-01"},{"$f":" Time!AM$24","v":"2025-07-01"},{"$f":" Time!AN$24","v":"2025-08-01"},{"$f":" Time!AO$24","v":"2025-09-01"},{"$f":" Time!AP$24","v":"2025-10-01"},{"$f":" Time!AQ$24","v":"2025-11-01"},{"$f":" Time!AR$24","v":"2025-12-01"},{"$f":" Time!AS$24","v":"2026-01-01"},{"$f":" Time!AT$24","v":"2026-02-01"},{"$f":" Time!AU$24","v":"2026-03-01"},{"$f":" Time!AV$24","v":"2026-04-01"},{"$f":" Time!AW$24","v":"2026-05-01"},{"$f":" Time!AX$24","v":"2026-06-01"}]
[null,null,null,null,{"$f":" Time!E$27","v":"Model Period END"},{"$f":" Check!F$8","v":0},"Error chks",null,null,null,{"$f":" Time!K$27","v":"2023-03-31"},{"$f":" Time!L$27","v":"2023-04-30"},{"$f":" Time!M$27","v":"2023-05-31"},{"$f":" Time!N$27","v":"2023-06-30"},{"$f":" Time!O$27","v":"2023-07-31"},{"$f":" Time!P$27","v":"2023-08-31"},{"$f":" Time!Q$27","v":"2023-09-30"},{"$f":" Time!R$27","v":"2023-10-31"},{"$f":" Time!S$27","v":"2023-11-30"},{"$f":" Time!T$27","v":"2023-12-31"},{"$f":" Time!U$27","v":"2024-01-31"},{"$f":" Time!V$27","v":"2024-02-29"},{"$f":" Time!W$27","v":"2024-03-31"},{"$f":" Time!X$27","v":"2024-04-30"},{"$f":" Time!Y$27","v":"2024-05-31"},{"$f":" Time!Z$27","v":"2024-06-30"},{"$f":" Time!AA$27","v":"2024-07-31"},{"$f":" Time!AB$27","v":"2024-08-31"},{"$f":" Time!AC$27","v":"2024-09-30"},{"$f":" Time!AD$27","v":"2024-10-31"},{"$f":" Time!AE$27","v":"2024-11-30"},{"$f":" Time!AF$27","v":"2024-12-31"},{"$f":" Time!AG$27","v":"2025-01-31"},{"$f":" Time!AH$27","v":"2025-02-28"},{"$f":" Time!AI$27","v":"2025-03-31"},{"$f":" Time!AJ$27","v":"2025-04-30"},{"$f":" Time!AK$27","v":"2025-05-31"},{"$f":" Time!AL$27","v":"2025-06-30"},{"$f":" Time!AM$27","v":"2025-07-31"},{"$f":" Time!AN$27","v":"2025-08-31"},{"$f":" Time!AO$27","v":"2025-09-30"},{"$f":" Time!AP$27","v":"2025-10-31"},{"$f":" Time!AQ$27","v":"2025-11-30"},{"$f":" Time!AR$27","v":"2025-12-31"},{"$f":" Time!AS$27","v":"2026-01-31"},{"$f":" Time!AT$27","v":"2026-02-28"},{"$f":" Time!AU$27","v":"2026-03-31"},{"$f":" Time!AV$27","v":"2026-04-30"},{"$f":" Time!AW$27","v":"2026-05-31"},{"$f":" Time!AX$27","v":"2026-06-30"}]
[null,null,null,null,{"$f":" Time!E$100","v":"Period reference"},null,null,null,null,null,{"$f":" Time!K$100","v":"Pre model period"},{"$f":" Time!L$100","v":"Pre model period"},{"$f":" Time!M$100","v":"Pre model period"},{"$f":" Time!N$100","v":"Pre model period"},{"$f":" Time!O$100","v":"Pre model period"},{"$f":" Time!P$100","v":"Pre model period"},{"$f":" Time!Q$100","v":"Pre model period"},{"$f":" Time!R$100","v":"Pre model period"},{"$f":" Time!S$100","v":"Pre model period"},{"$f":" Time!T$100","v":"Pre model period"},{"$f":" Time!U$100","v":"Pre model period"},{"$f":" Time!V$100","v":"Pre model period"},{"$f":" Time!W$100","v":"Pre model period"},{"$f":" Time!X$100","v":"W.C. model period"},{"$f":" Time!Y$100","v":"W.C. model period"},{"$f":" Time!Z$100","v":"W.C. model period"},{"$f":" Time!AA$100","v":"W.C. model period"},{"$f":" Time!AB$100","v":"W.C. model period"},{"$f":" Time!AC$100","v":"W.C. model period"},{"$f":" Time!AD$100","v":"W.C. model period"},{"$f":" Time!AE$100","v":"W.C. model period"},{"$f":" Time!AF$100","v":"W.C. model period"},{"$f":" Time!AG$100","v":"W.C. model period"},{"$f":" Time!AH$100","v":"W.C. model period"},{"$f":" Time!AI$100","v":"W.C. model period"},{"$f":" Time!AJ$100","v":"Post model period"},{"$f":" Time!AK$100","v":"Post model period"},{"$f":" Time!AL$100","v":"Post model period"},{"$f":" Time!AM$100","v":"Post model period"},{"$f":" Time!AN$100","v":"Post model period"},{"$f":" Time!AO$100","v":"Post model period"},{"$f":" Time!AP$100","v":"Post model period"},{"$f":" Time!AQ$100","v":"Post model period"},{"$f":" Time!AR$100","v":"Post model period"},{"$f":" Time!AS$100","v":"Post model period"},{"$f":" Time!AT$100","v":"Post model period"},{"$f":" Time!AU$100","v":"Post model period"},{"$f":" Time!AV$100","v":"Post model period"},{"$f":" Time!AW$100","v":"Post model period"},{"$f":" Time!AX$100","v":"Post model period"}]
[null,null,null,null,{"$f":" Time!E$91","v":"Financial Year Reference"},null,null,null,null,null,{"$f":" Time!K$91","v":"FY-2"},{"$f":" Time!L$91","v":"FY-1"},{"$f":" Time!M$91","v":"FY-1"},{"$f":" Time!N$91","v":"FY-1"},{"$f":" Time!O$91","v":"FY-1"},{"$f":" Time!P$91","v":"FY-1"},{"$f":" Time!Q$91","v":"FY-1"},{"$f":" Time!R$91","v":"FY-1"},{"$f":" Time!S$91","v":"FY-1"},{"$f":" Time!T$91","v":"FY-1"},{"$f":" Time!U$91","v":"FY-1"},{"$f":" Time!V$91","v":"FY-1"},{"$f":" Time!W$91","v":"FY-1"},{"$f":" Time!X$91","v":"FY"},{"$f":" Time!Y$91","v":"FY"},{"$f":" Time!Z$91","v":"FY"},{"$f":" Time!AA$91","v":"FY"},{"$f":" Time!AB$91","v":"FY"},{"$f":" Time!AC$91","v":"FY"},{"$f":" Time!AD$91","v":"FY"},{"$f":" Time!AE$91","v":"FY"},{"$f":" Time!AF$91","v":"FY"},{"$f":" Time!AG$91","v":"FY"},{"$f":" Time!AH$91","v":"FY"},{"$f":" Time!AI$91","v":"FY"},{"$f":" Time!AJ$91","v":"FY+1"},{"$f":" Time!AK$91","v":"FY+1"},{"$f":" Time!AL$91","v":"FY+1"},{"$f":" Time!AM$91","v":"FY+1"},{"$f":" Time!AN$91","v":"FY+1"},{"$f":" Time!AO$91","v":"FY+1"},{"$f":" Time!AP$91","v":"FY+1"},{"$f":" Time!AQ$91","v":"FY+1"},{"$f":" Time!AR$91","v":"FY+1"},{"$f":" Time!AS$91","v":"FY+1"},{"$f":" Time!AT$91","v":"FY+1"},{"$f":" Time!AU$91","v":"FY+1"},{"$f":" Time!AV$91","v":"FY+2"},{"$f":" Time!AW$91","v":"FY+2"},{"$f":" Time!AX$91","v":"FY+2"}]
[null,null,null,null,{"$f":" Time!E$11","v":"Model column counter"},"Constant","Unit","Total",null,null,{"$f":" Time!K$11","v":1},{"$f":" Time!L$11","v":2},{"$f":" Time!M$11","v":3},{"$f":" Time!N$11","v":4},{"$f":" Time!O$11","v":5},{"$f":" Time!P$11","v":6},{"$f":" Time!Q$11","v":7},{"$f":" Time!R$11","v":8},{"$f":" Time!S$11","v":9},{"$f":" Time!T$11","v":10},{"$f":" Time!U$11","v":11},{"$f":" Time!V$11","v":12},{"$f":" Time!W$11","v":13},{"$f":" Time!X$11","v":14},{"$f":" Time!Y$11","v":15},{"$f":" Time!Z$11","v":16},{"$f":" Time!AA$11","v":17},{"$f":" Time!AB$11","v":18},{"$f":" Time!AC$11","v":19},{"$f":" Time!AD$11","v":20},{"$f":" Time!AE$11","v":21},{"$f":" Time!AF$11","v":22},{"$f":" Time!AG$11","v":23},{"$f":" Time!AH$11","v":24},{"$f":" Time!AI$11","v":25},{"$f":" Time!AJ$11","v":26},{"$f":" Time!AK$11","v":27},{"$f":" Time!AL$11","v":28},{"$f":" Time!AM$11","v":29},{"$f":" Time!AN$11","v":30},{"$f":" Time!AO$11","v":31},{"$f":" Time!AP$11","v":32},{"$f":" Time!AQ$11","v":33},{"$f":" Time!AR$11","v":34},{"$f":" Time!AS$11","v":35},{"$f":" Time!AT$11","v":36},{"$f":" Time!AU$11","v":37},{"$f":" Time!AV$11","v":38},{"$f":" Time!AW$11","v":39},{"$f":" Time!AX$11","v":40}]
[]
[null,null,null,null,"Total error checks",{"$f":" SUM(F11:F14)","v":0},"check"]
[]
["[Do not delete]"]
[]
[null,null,null,null,{"$f":"Time!E109","v":"Modelling Period - Check"},{"$f":" Time!F109","v":0},{"$f":" Time!G109","v":"check"}]
[null,null,null,null,{"$f":"Calculations!E97","v":"Difference in the value of customer bill to be collected within 90 days and the total Retailer inflow accounting for unrecovered revenue - Check"},{"$f":" Calculations!F97","v":0},{"$f":"Calculations!G97","v":"check"}]
[]
["END"]