{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Notes","Forecast","Forecast Updated","Data","Policy - updated","Month Rank","Dispensing Days","Regression Feed xyrs","Test","Regression Feed FUpdated","Policy - not updated"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":6,"comments":2,"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":"Notes","index":0,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[[34,0,34,13],[9,0,9,13],[14,0,14,13],[15,0,15,13],[17,0,17,13],[18,0,18,13]]}
["Please read before using spreadsheet"]
[]
["Updating forecast for new financial year"]
["'Data' sheet"]
["Enter the historical monthly actual spend (£s) for the year mentioned in column heading"]
["Enter the total cumulative policy/local adjustments (£) that apply for each month in the year mentioned. "]
["If you don't know of any policy/local adjustments, enter the same amount as March in the previous year for all months in the last column."]
["For more information on the cumulative policy/local adjustments see the accompanying guide."]
["Do not cut and paste data within this workbook.  You can copy data in from another workbook if needed."]
["Please note, if one yellow cell is left blank before the curretn year, the forecast will not run and a message will appear.  "]
[]
["'Forecast' sheet"]
["Once all data is filled in, click the button 'Update regression for new financial year'."]
["This will automatically calculate the predicted spend for each month and end of year forecast.  The regression for this forecast is based on the previous years data."]
["If the forecast column is blank and you haven't received a pop up window informing that data is missing, then press F9.  For the forecast to automatically appear, calculations need to be on automatic.  To do this, go to the 'Options' menu under the 'Tools' bar, then click on the 'Calculations' tab and select the 'Automatic' box and click 'OK'. "]
[]
["'Forecast Updated' sheet"]
["To calculate the predicted spend for future months in 2021/22 taking into account the data for the months in 2021/22 already passed, click the button 'Update regression for new financial year taking into account most recent months'."]
["This calculates the regression from previous years data along with the 2021/22 months with data.  Therefore, the months already passed in 2021/22 will not have a predicted spend."]
["If the forecast column is blank follow the instructions under the 'Forecast' sheet heading above."]
[]
["Entering data for current financial year"]
["'Data' sheet"]
["When you know the monthly spend for the previous month, enter this value in the last column of the 'Actual Spend' table."]
["If there have been any policy adjustments in this month, add them to the last column of the 'Policy Adjustment' table."]
[]
["'Forecast' and 'Forecast Updated' sheet"]
["The monthly spend will now be included in this sheet."]
["The end of year forecast is calculated using the actual monthly spend for previous months and the predicted spend for future months."]
[]
[]
["For more information, see the Guide on running the Forecast Template."]
[]
["Regression Statistics"]
["The R square value is the variation between the regression line and the actual data points.  It is used to say how suitable the regression is for forecasting, the closer to 1, the more suitable the regression is."]
["The R square value for regression on 'Forecast' sheet is:",null,null,null,null,"The R square value for regression on 'Forecast Updated' sheet is:"]
[null,{"$f":"IF(Forecast!J7=\"\",\"\",Forecast!J7)","v":""},null,null,null,null,null,{"$f":"IF('Forecast Updated'!J10=\"\",\"\",'Forecast Updated'!J10)","v":""}]
[]
["If the P value is smaller than either 0.05 or 0.01, depending on the confidence level, the variables are said to be significant to the regression."]
["P values for the regression on 'Forecast' sheet",null,null,null,null,"P values for the regression on 'Forecast Updated' sheet"]
["Dispensing days",{"$f":"IF(Forecast!M20=\"\",\"\",Forecast!M20)","v":""},null,null,null,"Dispensing days",null,{"$f":"IF('Forecast Updated'!M23=\"\",\"\",'Forecast Updated'!M23)","v":""}]
["Year",{"$f":"IF(Forecast!M21=\"\",\"\",Forecast!M21)","v":""},null,null,null,"Year",null,{"$f":"IF('Forecast Updated'!M24=\"\",\"\",'Forecast Updated'!M24)","v":""}]
["Month",{"$f":"IF(Forecast!M22=\"\",\"\",Forecast!M22)","v":""},null,null,null,"Month",null,{"$f":"IF('Forecast Updated'!M25=\"\",\"\",'Forecast Updated'!M25)","v":""}]

{"sheet":"Forecast","index":1,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Forecast that fixes the regression at the start of the year"]
[]
["Forecast for monthly and end of year spend for 2021/22",null,null,null,null,null,null,null,"SUMMARY OUTPUT"]
[]
[null,null,null,null,null,null,null,null,"Regression Statistics"]
["Month","Actual monthly spend (£)",null,"Predicted monthly spend (£)",null,"End of year forecast (£)","Updated end of year forecast % change from 2020/21"]
["April",{"$f":"IF(Data!G7=\"\",\"\",Data!G7)","v":""},null,{"$f":"IF($I$5=\"\",\"\",'Regression Feed xyrs'!G64)","v":0},null,{"$f":"IF(B7=\"\",\"\",SUM($B$7:B7)+SUM(D8:$D$18))","v":""},{"$f":"IF(F7=\"\",\"\",(F7-$B$31)/$B$31)","v":""}]
["May",{"$f":"IF(Data!G8=\"\",\"\",Data!G8)","v":""},null,{"$f":"IF($I$5=\"\",\"\",'Regression Feed xyrs'!G65)","v":0},null,{"$f":"IF(B8=\"\",\"\",SUM($B$7:B8)+SUM(D9:$D$18))","v":""},{"$f":"IF(F8=\"\",\"\",(F8-$B$31)/$B$31)","v":""}]
["June",{"$f":"IF(Data!G9=\"\",\"\",Data!G9)","v":""},null,{"$f":"IF($I$5=\"\",\"\",'Regression Feed xyrs'!G66)","v":0},null,{"$f":"IF(B9=\"\",\"\",SUM($B$7:B9)+SUM(D10:$D$18))","v":""},""]
["July",{"$f":"IF(Data!G10=\"\",\"\",Data!G10)","v":""},null,{"$f":"IF($I$5=\"\",\"\",'Regression Feed xyrs'!G67)","v":0},null,{"$f":"IF(B10=\"\",\"\",SUM($B$7:B10)+SUM(D11:$D$18))","v":""},""]
["August",{"$f":"IF(Data!G11=\"\",\"\",Data!G11)","v":""},null,{"$f":"IF($I$5=\"\",\"\",'Regression Feed xyrs'!G68)","v":0},null,{"$f":"IF(B11=\"\",\"\",SUM($B$7:B11)+SUM(D12:$D$18))","v":""},""]
["September",{"$f":"IF(Data!G12=\"\",\"\",Data!G12)","v":""},null,{"$f":"IF($I$5=\"\",\"\",'Regression Feed xyrs'!G69)","v":0},null,{"$f":"IF(B12=\"\",\"\",SUM($B$7:B12)+SUM(D13:$D$18))","v":""},""]
["October",{"$f":"IF(Data!G13=\"\",\"\",Data!G13)","v":""},null,{"$f":"IF($I$5=\"\",\"\",'Regression Feed xyrs'!G70)","v":0},null,{"$f":"IF(B13=\"\",\"\",SUM($B$7:B13)+SUM(D14:$D$18))","v":""},""]
["November",{"$f":"IF(Data!G14=\"\",\"\",Data!G14)","v":""},null,{"$f":"IF($I$5=\"\",\"\",'Regression Feed xyrs'!G71)","v":0},null,{"$f":"IF(B14=\"\",\"\",SUM($B$7:B14)+SUM(D15:$D$18))","v":""},""]
["December",{"$f":"IF(Data!G15=\"\",\"\",Data!G15)","v":""},null,{"$f":"IF($I$5=\"\",\"\",'Regression Feed xyrs'!G72)","v":0},null,{"$f":"IF(B15=\"\",\"\",SUM($B$7:B15)+SUM(D16:$D$18))","v":""},""]
["January",{"$f":"IF(Data!G16=\"\",\"\",Data!G16)","v":""},null,{"$f":"IF($I$5=\"\",\"\",'Regression Feed xyrs'!G73)","v":0},null,{"$f":"IF(B16=\"\",\"\",SUM($B$7:B16)+SUM(D17:$D$18))","v":""},""]
["February",{"$f":"IF(Data!G17=\"\",\"\",Data!G17)","v":""},null,{"$f":"IF($I$5=\"\",\"\",'Regression Feed xyrs'!G74)","v":0},null,{"$f":"IF(B17=\"\",\"\",SUM($B$7:B17)+SUM(D18:$D$18))","v":""},""]
["March",{"$f":"IF(Data!G18=\"\",\"\",Data!G18)","v":""},null,{"$f":"IF($I$5=\"\",\"\",'Regression Feed xyrs'!G75)","v":0},null,null,""]
[null,null,{"$f":"IF(AND(B7=\"\",D7=\"\"),\"\",IF(AND(B7=\"\",D7<>\"\"),\"End of Year\",\"\"))","v":"End of Year"},{"$f":"IF(AND(B7=\"\",D7=\"\"),\"\",IF(AND(B7=\"\",D7<>\"\"),SUM(D7:D18),\"\"))","v":0}]
[]
[]
[]
[]
[]
[]
["Year","End of year totals","% change"]
["2016/17",{"$f":"SUM(Data!B7:B18)","v":0}]
["2017/18",{"$f":"SUM(Data!C7:C18)","v":0},{"$f":"IF(B27=0,\"\",(B28-B27)/B27)","v":""}]
["2018/19",{"$f":"SUM(Data!D7:D18)","v":0},{"$f":"IF(B28=0,\"\",(B29-B28)/B28)","v":""}]
["2019/20",{"$f":"SUM(Data!E7:E18)","v":0},{"$f":"IF(B29=0,\"\",(B30-B29)/B29)","v":""}]
["2020/21",{"$f":"SUM(Data!F7:F18)","v":0},{"$f":"IF(B30=0,\"\",(B31-B30)/B30)","v":""}]
["2021/22",{"$f":"IF(AND(D19=\"\",F7=\"\"),\"\",IF(D19=\"\",OFFSET(F6,12-A34,0),D19))","v":0},{"$f":"IF(B31=0,\"\",IF(B32=\"\",\"\",(B32-B31)/B31))","v":""}]
[]
[{"$f":"COUNTBLANK(F7:F18)","v":12},null,null,null,"Adjusting for rounding error in sum"]
["Profile excluding drugs costs previously met centrally",null,null,null,{"$f":"1-D48","v":{"$error":"#VALUE!"}}]
["2021/22","Profile","Rounded","Cumulative profile","Adjusted profile","Cumulative"]
["April",{"$f":"B7/$B$32","v":{"$error":"#VALUE!"}},{"$f":"ROUND(B37,4)","v":{"$error":"#VALUE!"}},{"$f":"C37","v":{"$error":"#VALUE!"}},{"$f":"C37+($E$35/12)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(E37,4)","v":{"$error":"#VALUE!"}},{"$f":"F37","v":{"$error":"#VALUE!"}}]
["May",{"$f":"B8/$B$32","v":{"$error":"#VALUE!"}},{"$f":"ROUND(B38,4)","v":{"$error":"#VALUE!"}},{"$f":"D37+C38","v":{"$error":"#VALUE!"}},{"$f":"C38+($E$35/12)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(E38,4)","v":{"$error":"#VALUE!"}},{"$f":"G37+F38","v":{"$error":"#VALUE!"}}]
["June",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"D38+C39","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["July",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"D39+C40","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["August",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["September",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["October",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"ROUNDDOWN(E43,4)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
["November",{"$f":"D14/$B$32","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#VALUE!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
["December",{"$f":"D15/$B$32","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#VALUE!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
["January",{"$f":"D16/$B$32","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#VALUE!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
["February",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
["March",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"D47+C48","v":{"$error":"#VALUE!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,{"$f":"SUM(B37:B48)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]

{"sheet":"Forecast Updated","index":2,"n_rows":49,"n_cols":7,"rows_kept":49,"cut":false,"hidden":false,"merged":[[4,0,4,11]]}
["Forecast which updates the regression as the year progresses"]
[]
["Forecast for monthly and end of year spend for 2021/22"]
[]
[]
[]
["Month","Actual monthly spend (£)",null,"Predicted monthly spend (£)",null,"End of year forecast (£)","Updated end of year forecast % change from 2020/21"]
["April",{"$f":"IF(Data!G7=\"\",\"\",Data!G7)","v":""},null,{"$f":"IF($I$6=\"\",\"\",'Regression Feed FUpdated'!G64)","v":""},null,{"$f":"IF(D9=\"\",\"\",IF(B8=\"\",\"\",SUM($B$8:B8)+SUM(D9:$D$19)))","v":""},{"$f":"IF(F8=\"\",\"\",(F8-$B$32)/$B$32)","v":""}]
["May",{"$f":"IF(Data!G8=\"\",\"\",Data!G8)","v":""},null,{"$f":"IF($I$6=\"\",\"\",'Regression Feed FUpdated'!G65)","v":""},null,{"$f":"IF(D10=\"\",\"\",IF(B9=\"\",\"\",SUM($B$8:B9)+SUM(D10:$D$19)))","v":""},{"$f":"IF(F9=\"\",\"\",(F9-$B$32)/$B$32)","v":""}]
["June",{"$f":"IF(Data!G9=\"\",\"\",Data!G9)","v":""},null,{"$f":"IF($I$6=\"\",\"\",'Regression Feed FUpdated'!G66)","v":""},null,{"$f":"IF(D11=\"\",\"\",IF(B10=\"\",\"\",SUM($B$8:B10)+SUM(D11:$D$19)))","v":""},""]
["July",{"$f":"IF(Data!G10=\"\",\"\",Data!G10)","v":""},null,{"$f":"IF($I$6=\"\",\"\",'Regression Feed FUpdated'!G67)","v":""},null,{"$f":"IF(D12=\"\",\"\",IF(B11=\"\",\"\",SUM($B$8:B11)+SUM(D12:$D$19)))","v":""},""]
["August",{"$f":"IF(Data!G11=\"\",\"\",Data!G11)","v":""},null,{"$f":"IF($I$6=\"\",\"\",'Regression Feed FUpdated'!G68)","v":""},null,{"$f":"IF(D13=\"\",\"\",IF(B12=\"\",\"\",SUM($B$8:B12)+SUM(D13:$D$19)))","v":""},""]
["September",{"$f":"IF(Data!G12=\"\",\"\",Data!G12)","v":""},null,{"$f":"IF($I$6=\"\",\"\",'Regression Feed FUpdated'!G69)","v":""},null,{"$f":"IF(D14=\"\",\"\",IF(B13=\"\",\"\",SUM($B$8:B13)+SUM(D14:$D$19)))","v":""},""]
["October",{"$f":"IF(Data!G13=\"\",\"\",Data!G13)","v":""},null,{"$f":"IF($I$6=\"\",\"\",'Regression Feed FUpdated'!G70)","v":""},null,{"$f":"IF(D15=\"\",\"\",IF(B14=\"\",\"\",SUM($B$8:B14)+SUM(D15:$D$19)))","v":""},""]
["November",{"$f":"IF(Data!G14=\"\",\"\",Data!G14)","v":""},null,{"$f":"IF($I$6=\"\",\"\",'Regression Feed FUpdated'!G71)","v":""},null,{"$f":"IF(D16=\"\",\"\",IF(B15=\"\",\"\",SUM($B$8:B15)+SUM(D16:$D$19)))","v":""},""]
["December",{"$f":"IF(Data!G15=\"\",\"\",Data!G15)","v":""},null,{"$f":"IF($I$6=\"\",\"\",'Regression Feed FUpdated'!G72)","v":""},null,{"$f":"IF(D17=\"\",\"\",IF(B16=\"\",\"\",SUM($B$8:B16)+SUM(D17:$D$19)))","v":""},""]
["January",{"$f":"IF(Data!G16=\"\",\"\",Data!G16)","v":""},null,{"$f":"IF($I$6=\"\",\"\",'Regression Feed FUpdated'!G73)","v":""},null,{"$f":"IF(D18=\"\",\"\",IF(B17=\"\",\"\",SUM($B$8:B17)+SUM(D18:$D$19)))","v":""},""]
["February",{"$f":"IF(Data!G17=\"\",\"\",Data!G17)","v":""},null,{"$f":"IF($I$6=\"\",\"\",'Regression Feed FUpdated'!G74)","v":""},null,{"$f":"IF(D19=\"\",\"\",IF(B18=\"\",\"\",SUM($B$8:B18)+SUM(D19:$D$19)))","v":""},""]
["March",{"$f":"IF(Data!G18=\"\",\"\",Data!G18)","v":""},null,{"$f":"IF($I$6=\"\",\"\",'Regression Feed FUpdated'!G75)","v":""},null,{"$f":"IF(D20=\"\",\"\",IF(B19=\"\",\"\",SUM($B$8:B19)+SUM(D$19:$D20)))","v":""},""]
[null,null,{"$f":"IF(AND(B8=\"\",D8=\"\"),\"\",IF(AND(B8=\"\",D8<>\"\"),\"End of Year\",\"\"))","v":""},{"$f":"IF(AND(B8=\"\",D8=\"\"),\"\",IF(AND(B8=\"\",D8<>\"\"),SUM(D8:D19),\"\"))","v":""}]
[]
[]
[]
[]
[]
[]
["Year","End of year totals","% change"]
["2016/17",{"$f":"SUM(Data!B7:B18)","v":0}]
["2017/18",{"$f":"SUM(Data!C7:C18)","v":0},{"$f":"IF(B28=0,\"\",(B29-B28)/B28)","v":""}]
["2018/19",{"$f":"SUM(Data!D7:D18)","v":0},{"$f":"IF(B29=0,\"\",(B30-B29)/B29)","v":""}]
["2019/20",{"$f":"SUM(Data!E7:E18)","v":0},{"$f":"IF(B30=0,\"\",(B31-B30)/B30)","v":""}]
["2020/21",{"$f":"SUM(Data!F7:F18)","v":0},{"$f":"IF(B31=0,\"\",(B32-B31)/B31)","v":""}]
["2021/22",{"$f":"IF(D20=\"\",OFFSET(F7,A34,0),D20)","v":""},{"$f":"IF(B32=0,\"\",IF(B33=\"\",\"\",(B33-B32)/B32))","v":""}]
[{"$f":"COUNTBLANK(D8:D19)","v":12},null,null,null,"Adjusting for rounding error in sum"]
["Profile excluding drugs costs previously met centrally",null,null,null,{"$f":"1-D48","v":{"$error":"#VALUE!"}}]
["2021/22",null,"Profile","Cumulative profile","Adjusted profile","Rounded","Cumulative"]
["April",{"$f":"B8/$B$33","v":{"$error":"#VALUE!"}},{"$f":"ROUND(B37,4)","v":{"$error":"#VALUE!"}},{"$f":"C37","v":{"$error":"#VALUE!"}},{"$f":"B37+$E$35/12","v":{"$error":"#VALUE!"}},{"$f":"ROUND(E37,4)","v":{"$error":"#VALUE!"}},{"$f":"F37","v":{"$error":"#VALUE!"}}]
["May",{"$f":"B9/$B$33","v":{"$error":"#VALUE!"}},{"$f":"ROUND(B38,4)","v":{"$error":"#VALUE!"}},{"$f":"D37+C38","v":{"$error":"#VALUE!"}},{"$f":"B38+$E$35/12","v":{"$error":"#VALUE!"}},{"$f":"ROUND(E38,4)","v":{"$error":"#VALUE!"}},{"$f":"G37+F38","v":{"$error":"#VALUE!"}}]
["June",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"D38+C39","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"G38+F39","v":{"$error":"#VALUE!"}}]
["July",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["August",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["September",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["October",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["November",{"$f":"D15/$B$33","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["December",{"$f":"D16/$B$33","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["January",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["February",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["March",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"G47+F48","v":{"$error":"#VALUE!"}}]
[null,{"$f":"SUM(B37:B48)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$f":"SUM(F37:F48)","v":{"$error":"#VALUE!"}}]

{"sheet":"Data","index":3,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[21,1,21,6],[4,1,4,6]]}
["Data entry sheet"]
[]
["Actual monthly drugs spend (£)",null,null,{"$f":"IF(OR(H7<>\"\",H8<>\"\",H9<>\"\",H10<>\"\",H11<>\"\",H12<>\"\",H13<>\"\",H14<>\"\",H15<>\"\",H16<>\"\",H17<>\"\",H18<>\"\",H24<>\"\",H25<>\"\",H26<>\"\",H27<>\"\",H28<>\"\",H29<>\"\",H30<>\"\",H31<>\"\",H32<>\"\",H33<>\"\",H34<>\"\",H35<>\"\"),\"Data missing, forecast will not run\",\"\")","v":"Data missing, forecast will not run"}]
[]
[null,"Year"]
["Month","2016/17","2017/18","2018/19","2019/20","2020/21","2021/22"]
["April",null,null,null,null,null,null,{"$f":"IF(OR(B7=\"\",C7=\"\",D7=\"\",E7=\"\",F7=\"\"),\"Data missing, please enter value in blank cell between B5 and F5\",\"\")","v":"Data missing, please enter value in blank cell between B5 and F5"}]
["May",null,null,null,null,null,null,{"$f":"IF(OR(B8=\"\",C8=\"\",D8=\"\",E8=\"\",F8=\"\"),\"Data missing, please enter value in blank cell between B6 and F6\",\"\")","v":"Data missing, please enter value in blank cell between B6 and F6"}]
["June",null,null,null,null,null,null,{"$f":"IF(OR(B9=\"\",C9=\"\",D9=\"\",E9=\"\",F9=\"\"),\"Data missing, please enter value in blank cell between B7 and F7\",\"\")","v":"Data missing, please enter value in blank cell between B7 and F7"}]
["July",null,null,null,null,null,null,{"$f":"IF(OR(B10=\"\",C10=\"\",D10=\"\",E10=\"\",F10=\"\"),\"Data missing, please enter value in blank cell between B8 and F8\",\"\")","v":"Data missing, please enter value in blank cell between B8 and F8"}]
["August",null,null,null,null,null,null,{"$f":"IF(OR(B11=\"\",C11=\"\",D11=\"\",E11=\"\",F11=\"\"),\"Data missing, please enter value in blank cell between B9 and F9\",\"\")","v":"Data missing, please enter value in blank cell between B9 and F9"}]
["September",null,null,null,null,null,null,{"$f":"IF(OR(B12=\"\",C12=\"\",D12=\"\",E12=\"\",F12=\"\"),\"Data missing, please enter value in blank cell between B10 and F10\",\"\")","v":"Data missing, please enter value in blank cell between B10 and F10"}]
["October",null,null,null,null,null,null,{"$f":"IF(OR(B13=\"\",C13=\"\",D13=\"\",E13=\"\",F13=\"\"),\"Data missing, please enter value in blank cell between B11 and F11\",\"\")","v":"Data missing, please enter value in blank cell between B11 and F11"}]
["November",null,null,null,null,null,null,{"$f":"IF(OR(B14=\"\",C14=\"\",D14=\"\",E14=\"\",F14=\"\"),\"Data missing, please enter value in blank cell between B12 and F12\",\"\")","v":"Data missing, please enter value in blank cell between B12 and F12"}]
["December",null,null,null,null,null,null,{"$f":"IF(OR(B15=\"\",C15=\"\",D15=\"\",E15=\"\",F15=\"\"),\"Data missing, please enter value in blank cell between B13 and F13\",\"\")","v":"Data missing, please enter value in blank cell between B13 and F13"}]
["January",null,null,null,null,null,null,{"$f":"IF(OR(B16=\"\",C16=\"\",D16=\"\",E16=\"\",F16=\"\"),\"Data missing, please enter value in blank cell between B14 and F14\",\"\")","v":"Data missing, please enter value in blank cell between B14 and F14"}]
["February",null,null,null,null,null,null,{"$f":"IF(OR(B17=\"\",C17=\"\",D17=\"\",E17=\"\",F17=\"\"),\"Data missing, please enter value in blank cell between B15 and F15\",\"\")","v":"Data missing, please enter value in blank cell between B15 and F15"}]
["March",null,null,null,null,null,null,{"$f":"IF(OR(B18=\"\",C18=\"\",D18=\"\",E18=\"\",F18=\"\"),\"Data missing, please enter value in blank cell between B16 and F16\",\"\")","v":"Data missing, please enter value in blank cell between B16 and F16"}]
[]
["Policy/local  adjustments (£)"]
[]
[null,"Year"]
["Month","2016/17","2017/18","2018/19","2019/20","2020/21","2021/22"]
["April",null,null,null,null,null,null,{"$f":"IF(OR(B24=\"\",C24=\"\",D24=\"\",E24=\"\",F24=\"\",G24=\"\"),\"Data missing, please enter value in blank cell between B22 and G22\",\"\")","v":"Data missing, please enter value in blank cell between B22 and G22"}]
["May",null,null,null,null,null,null,{"$f":"IF(OR(B25=\"\",C25=\"\",D25=\"\",E25=\"\",F25=\"\",G25=\"\"),\"Data missing, please enter value in blank cell between B23 and G23\",\"\")","v":"Data missing, please enter value in blank cell between B23 and G23"}]
["June",null,null,null,null,null,null,{"$f":"IF(OR(B26=\"\",C26=\"\",D26=\"\",E26=\"\",F26=\"\",G26=\"\"),\"Data missing, please enter value in blank cell between B24 and G24\",\"\")","v":"Data missing, please enter value in blank cell between B24 and G24"}]
["July",null,null,null,null,null,null,{"$f":"IF(OR(B27=\"\",C27=\"\",D27=\"\",E27=\"\",F27=\"\",G27=\"\"),\"Data missing, please enter value in blank cell between B25 and G25\",\"\")","v":"Data missing, please enter value in blank cell between B25 and G25"}]
["August",null,null,null,null,null,null,{"$f":"IF(OR(B28=\"\",C28=\"\",D28=\"\",E28=\"\",F28=\"\",G28=\"\"),\"Data missing, please enter value in blank cell between B26 and G26\",\"\")","v":"Data missing, please enter value in blank cell between B26 and G26"}]
["September",null,null,null,null,null,null,{"$f":"IF(OR(B29=\"\",C29=\"\",D29=\"\",E29=\"\",F29=\"\",G29=\"\"),\"Data missing, please enter value in blank cell between B27 and G27\",\"\")","v":"Data missing, please enter value in blank cell between B27 and G27"}]
["October",null,null,null,null,null,null,{"$f":"IF(OR(B30=\"\",C30=\"\",D30=\"\",E30=\"\",F30=\"\",G30=\"\"),\"Data missing, please enter value in blank cell between B28 and G28\",\"\")","v":"Data missing, please enter value in blank cell between B28 and G28"}]
["November",null,null,null,null,null,null,{"$f":"IF(OR(B31=\"\",C31=\"\",D31=\"\",E31=\"\",F31=\"\",G31=\"\"),\"Data missing, please enter value in blank cell between B29 and G29\",\"\")","v":"Data missing, please enter value in blank cell between B29 and G29"}]
["December",null,null,null,null,null,null,{"$f":"IF(OR(B32=\"\",C32=\"\",D32=\"\",E32=\"\",F32=\"\",G32=\"\"),\"Data missing, please enter value in blank cell between B30 and G30\",\"\")","v":"Data missing, please enter value in blank cell between B30 and G30"}]
["January",null,null,null,null,null,null,{"$f":"IF(OR(B33=\"\",C33=\"\",D33=\"\",E33=\"\",F33=\"\",G33=\"\"),\"Data missing, please enter value in blank cell between B31 and G31\",\"\")","v":"Data missing, please enter value in blank cell between B31 and G31"}]
["February",null,null,null,null,null,null,{"$f":"IF(OR(B34=\"\",C34=\"\",D34=\"\",E34=\"\",F34=\"\",G34=\"\"),\"Data missing, please enter value in blank cell between B32 and G32\",\"\")","v":"Data missing, please enter value in blank cell between B32 and G32"}]
["March",null,null,null,null,null,null,{"$f":"IF(OR(B35=\"\",C35=\"\",D35=\"\",E35=\"\",F35=\"\",G35=\"\"),\"Data missing, please enter value in blank cell between B33 and G33\",\"\")","v":"Data missing, please enter value in blank cell between B33 and G33"}]

{"sheet":"Policy - updated","index":4,"n_rows":57,"n_cols":5,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["Policy Impact"]
[]
[]
["Date","Type","Impact per year","Per month","Net impact since April 2015"]
["2003-12-01","1st generic",-150,{"$f":"C5/12","v":-12.5}]
["2004-10-01","2nd generic",-150,{"$f":"C6/12","v":-12.5}]
["2005-02-01","PPRS 05",{"$f":"-1800/5","v":-360},-30]
["2005-04-01","CatM1",-300,-25]
["2006-10-01","CatM2",-300,-25]
["2007-07-01","CatM technical adju",-120,-10]
["2007-10-01","CatM3",-400,-33.333333333333336]
["2008-10-01","CatM4",-130,-10.833333333333334]
["2009-03-01","PPRS 09 (-3.9%)",-160,-13.333333333333334]
["2009-10-01","CatM5",-80,-6.666666666666667]
["2010-02-01","PPRS 09 (-1.9%)",-80,-6.666666666666667]
["2010-10-01","CatM6",-240,-20]
["2011-01-01","PPRS09 (+0.1%)",5.7,0.47500000000000003]
["2011-04-01","CatM7",-90,-7.5]
["2011-04-01","QP indicators & QIPP",-150,-12.5]
["2011-10-01","CatM8",-156,-13]
["2012-01-01","PPRS09 (+0.2%)",{"$f":"2*C17","v":11.4},0.95000000000000007]
["2012-04-01","CatM9",-40,-3.3333333333333335]
["2012-04-01","QP indicators & QIPP",-100,-8.3333333333333339]
["2012-06-01","Atorvastatin",-203,-16.916666666666668]
["2012-10-01","CatM10",-290,-24.166666666666668]
["2013-01-01","PPRS09 (+0.2%)",{"$f":"2*C17","v":11.4},0.95000000000000007]
["2013-04-01","CatM",0,0]
["2013-10-01","CatM11",-80,-6.666666666666667]
["2014-04-01","CatM",-120,-10]
["2014-10-01","CatM",120,10]
["2016-01-01","CatM",-45,{"$f":"C31/3","v":-15},{"$f":"SUM(D31:$D$31)","v":-15}]
["2016-06-01","CatM",-144,-12,{"$f":"SUM(D$31:$D32)","v":-27}]
["2017-08-01","CatM",-144,-15,{"$f":"SUM(D$31:$D33)","v":-42}]
["2018-08-01","CatM",{"$f":"12*D34","v":180},15,{"$f":"SUM(D$31:$D34)","v":-27}]
["2018-11-01","CatM",{"$f":"12*D35","v":-120},-10,{"$f":"SUM(D$31:$D35)","v":-37}]
["2019-04-01","CatM",120,10,{"$f":"SUM(D$31:$D36)","v":-27}]
["2019-08-01","CatM",180,15,{"$f":"SUM(D$31:$D37)","v":-12}]
["2020-06-01","CatM",{"$f":"12*D38","v":180},15,{"$f":"SUM(D$31:$D38)","v":3}]
["2020-10-01","CatM",-93.2,{"$f":"C39/12","v":-7.7666666666666666},{"$f":"SUM(D$31:$D39)","v":-4.7666666666666666}]
["2021-01-01","CatM",108.8,{"$f":"C40/12","v":9.0666666666666664},{"$f":"SUM(D$31:$D40)","v":4.3}]
["2021-04-01","CatM",41.6,3.4666666666666668,{"$f":"SUM(D$31:$D41)","v":7.7666666666666666}]
["2021-07-01","CatM",-195.6,-16.3,{"$f":"SUM(D$31:$D42)","v":-8.533333333333335}]
["2021-10-01","CatM",-107.2,-8.9333333333333336,{"$f":"SUM(D$31:$D43)","v":-17.466666666666669}]
["2022-01-01","CatM",-197.2,-16.433333333333334,{"$f":"SUM(D$31:$D44)","v":-33.900000000000006}]
[]
[]
[]
[]
[]
[]
[]
[]
["https://psnc.org.uk/funding-and-statistics/funding-distribution/summary-of-funding-changes/"]
[]
["Contact: Bayan Amin (bayan.amin@dhsc.gov.uk)"]
[]
["Description of Cateogry M: https://psnc.org.uk/funding-and-statistics/funding-distribution/retained-margin-category-m/"]

{"sheet":"Month Rank","index":5,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Ranking Months for forecast"]
[]
[null,{"$f":"Data!B5","v":"Year"}]
[{"$f":"Data!A6","v":"Month"},{"$f":"Data!B6","v":"2016/17"},{"$f":"Data!C6","v":"2017/18"},{"$f":"Data!D6","v":"2018/19"},{"$f":"Data!E6","v":"2019/20"},{"$f":"Data!F6","v":"2020/21"},"Total across 5 years","Month Rank"]
[{"$f":"Data!A7","v":"April"},{"$f":"Data!B7/'Dispensing Days'!K4","v":0},{"$f":"Data!C7/'Dispensing Days'!L4","v":0},{"$f":"Data!D7/'Dispensing Days'!M4","v":0},{"$f":"Data!E7/'Dispensing Days'!N4","v":0},{"$f":"Data!F7/'Dispensing Days'!O4","v":0},{"$f":"SUM(B5:F5)","v":0},{"$f":"RANK(G5,$G$5:$G$16,1)","v":1}]
[{"$f":"Data!A8","v":"May"},{"$f":"Data!B8/'Dispensing Days'!K5","v":0},{"$f":"Data!C8/'Dispensing Days'!L5","v":0},{"$f":"Data!D8/'Dispensing Days'!M5","v":0},{"$f":"Data!E8/'Dispensing Days'!N5","v":0},{"$f":"Data!F8/'Dispensing Days'!O5","v":0},{"$f":"SUM(B6:F6)","v":0},{"$f":"RANK(G6,$G$5:$G$16,1)","v":1}]
[{"$f":"Data!A9","v":"June"},{"$f":"Data!B9/'Dispensing Days'!K6","v":0},{"$f":"Data!C9/'Dispensing Days'!L6","v":0},{"$f":"Data!D9/'Dispensing Days'!M6","v":0},{"$f":"Data!E9/'Dispensing Days'!N6","v":0},{"$f":"Data!F9/'Dispensing Days'!O6","v":0},0,1]
[{"$f":"Data!A10","v":"July"},{"$f":"Data!B10/'Dispensing Days'!K7","v":0},{"$f":"Data!C10/'Dispensing Days'!L7","v":0},{"$f":"Data!D10/'Dispensing Days'!M7","v":0},{"$f":"Data!E10/'Dispensing Days'!N7","v":0},{"$f":"Data!F10/'Dispensing Days'!O7","v":0},0,1]
[{"$f":"Data!A11","v":"August"},{"$f":"Data!B11/'Dispensing Days'!K8","v":0},{"$f":"Data!C11/'Dispensing Days'!L8","v":0},{"$f":"Data!D11/'Dispensing Days'!M8","v":0},{"$f":"Data!E11/'Dispensing Days'!N8","v":0},{"$f":"Data!F11/'Dispensing Days'!O8","v":0},0,1]
[{"$f":"Data!A12","v":"September"},{"$f":"Data!B12/'Dispensing Days'!K9","v":0},{"$f":"Data!C12/'Dispensing Days'!L9","v":0},{"$f":"Data!D12/'Dispensing Days'!M9","v":0},{"$f":"Data!E12/'Dispensing Days'!N9","v":0},{"$f":"Data!F12/'Dispensing Days'!O9","v":0},0,1]
[{"$f":"Data!A13","v":"October"},{"$f":"Data!B13/'Dispensing Days'!K10","v":0},{"$f":"Data!C13/'Dispensing Days'!L10","v":0},{"$f":"Data!D13/'Dispensing Days'!M10","v":0},{"$f":"Data!E13/'Dispensing Days'!N10","v":0},{"$f":"Data!F13/'Dispensing Days'!O10","v":0},0,1]
[{"$f":"Data!A14","v":"November"},{"$f":"Data!B14/'Dispensing Days'!K11","v":0},{"$f":"Data!C14/'Dispensing Days'!L11","v":0},{"$f":"Data!D14/'Dispensing Days'!M11","v":0},{"$f":"Data!E14/'Dispensing Days'!N11","v":0},{"$f":"Data!F14/'Dispensing Days'!O11","v":0},0,1]
[{"$f":"Data!A15","v":"December"},{"$f":"Data!B15/'Dispensing Days'!K12","v":0},{"$f":"Data!C15/'Dispensing Days'!L12","v":0},{"$f":"Data!D15/'Dispensing Days'!M12","v":0},{"$f":"Data!E15/'Dispensing Days'!N12","v":0},{"$f":"Data!F15/'Dispensing Days'!O12","v":0},0,1]
[{"$f":"Data!A16","v":"January"},{"$f":"Data!B16/'Dispensing Days'!K13","v":0},{"$f":"Data!C16/'Dispensing Days'!L13","v":0},{"$f":"Data!D16/'Dispensing Days'!M13","v":0},{"$f":"Data!E16/'Dispensing Days'!N13","v":0},{"$f":"Data!F16/'Dispensing Days'!O13","v":0},0,1]
[{"$f":"Data!A17","v":"February"},{"$f":"Data!B17/'Dispensing Days'!K14","v":0},{"$f":"Data!C17/'Dispensing Days'!L14","v":0},{"$f":"Data!D17/'Dispensing Days'!M14","v":0},{"$f":"Data!E17/'Dispensing Days'!N14","v":0},{"$f":"Data!F17/'Dispensing Days'!O14","v":0},0,1]
[{"$f":"Data!A18","v":"March"},{"$f":"Data!B18/'Dispensing Days'!K15","v":0},{"$f":"Data!C18/'Dispensing Days'!L15","v":0},{"$f":"Data!D18/'Dispensing Days'!M15","v":0},{"$f":"Data!E18/'Dispensing Days'!N15","v":0},{"$f":"Data!F18/'Dispensing Days'!O15","v":0},0,1]

{"sheet":"Dispensing Days","index":6,"n_rows":15,"n_cols":18,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Dispensing days"]
[]
[null,"2005/06","2006/07","2007/08","2008/09","2009/10","2010/11","2011/12","2012/13","2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21","2021/22"]
["April",26,24,23,26,24,24,23,23,25,24,24,26,23,24,24,24,24]
["May",24,25,25,25,24,24,24,26,25,25,24,24,25,25,25,24,24]
["June",26,26,26,25,26,26,26,24,25,25,26,26,26,26,25,26,26]
["July",26,26,26,27,27,27,26,26,27,27,27,26,26,26,27,27,27]
["August",26,26,26,25,25,25,26,26,26,25,25,26,26,26,26,25,25]
["September",26,26,25,26,26,26,26,25,25,26,26,26,26,25,25,26,26]
["October",26,26,27,27,27,26,26,27,27,27,27,26,26,27,27,27,26]
["November",26,26,26,25,25,26,26,26,26,25,25,26,26,26,26,25,26]
["December",24,24,24,25,24,24,25,24,24,25,24,25,24,24,24,24,24]
["January",25,26,26,26,25,24,25,26,26,26,25,25,26,26,26,25,24]
["February",24,24,25,24,24,24,25,24,24,24,25,24,24,24,25,24,24]
["March",27,27,24,26,27,27,27,25,26,26,25,27,26,26,26,27,27]

{"sheet":"Regression Feed xyrs","index":7,"n_rows":77,"n_cols":8,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
["Feed for running regression"]
[]
["year","Month","Historical","Dispensing days","year","month","Predicted spend"]
[{"$f":"Data!B6","v":"2016/17"},"April",{"$f":"Data!B7+Data!B24","v":0},{"$f":"INDEX(DispensingDays,MATCH(B4,DDMonth,0),MATCH($A$4,DDYear,0))","v":26},{"$f":"IF(C4=0,0,1)","v":0},{"$f":"'Month Rank'!H5","v":1},null,{"$f":"RANK(C4,$C$4:$C$15)","v":1}]
[null,"May",{"$f":"Data!B8+Data!B25","v":0},{"$f":"INDEX(DispensingDays,MATCH(B5,DDMonth,0),MATCH($A$4,DDYear,0))","v":24},{"$f":"IF(C5=0,0,1)","v":0},{"$f":"'Month Rank'!H6","v":1},null,{"$f":"RANK(C5,$C$4:$C$15)","v":1}]
[null,"June",{"$f":"Data!B9+Data!B26","v":0},26,0,{"$f":"'Month Rank'!H7","v":1},null,1]
[null,"July",{"$f":"Data!B10+Data!B27","v":0},26,0,{"$f":"'Month Rank'!H8","v":1},null,1]
[null,"August",{"$f":"Data!B11+Data!B28","v":0},26,0,{"$f":"'Month Rank'!H9","v":1},null,1]
[null,"September",{"$f":"Data!B12+Data!B29","v":0},26,0,{"$f":"'Month Rank'!H10","v":1},null,1]
[null,"October",{"$f":"Data!B13+Data!B30","v":0},26,0,{"$f":"'Month Rank'!H11","v":1},null,1]
[null,"November",{"$f":"Data!B14+Data!B31","v":0},26,0,{"$f":"'Month Rank'!H12","v":1},null,1]
[null,"December",{"$f":"Data!B15+Data!B32","v":0},25,0,{"$f":"'Month Rank'!H13","v":1},null,1]
[null,"January",{"$f":"Data!B16+Data!B33","v":0},25,0,{"$f":"'Month Rank'!H14","v":1},null,1]
[null,"February",{"$f":"Data!B17+Data!B34","v":0},24,0,{"$f":"'Month Rank'!H15","v":1},null,1]
[null,"March",{"$f":"Data!B18+Data!B35","v":0},27,0,{"$f":"'Month Rank'!H16","v":1},null,1]
[{"$f":"Data!C6","v":"2017/18"},"April",{"$f":"Data!C7+Data!C24","v":0},{"$f":"INDEX(DispensingDays,MATCH(B16,DDMonth,0),MATCH($A$16,DDYear,0))","v":23},{"$f":"IF(C16=0,0,E4+1)","v":0},{"$f":"'Month Rank'!H5","v":1},null,{"$f":"F4-F16","v":0}]
[null,"May",{"$f":"Data!C8+Data!C25","v":0},25,{"$f":"IF(C17=0,0,E5+1)","v":0},{"$f":"'Month Rank'!H6","v":1},null,{"$f":"F5-F17","v":0}]
[null,"June",{"$f":"Data!C9+Data!C26","v":0},26,0,{"$f":"'Month Rank'!H7","v":1},null,0]
[null,"July",{"$f":"Data!C10+Data!C27","v":0},26,0,{"$f":"'Month Rank'!H8","v":1},null,0]
[null,"August",{"$f":"Data!C11+Data!C28","v":0},26,0,{"$f":"'Month Rank'!H9","v":1},null,0]
[null,"September",{"$f":"Data!C12+Data!C29","v":0},26,0,{"$f":"'Month Rank'!H10","v":1},null,0]
[null,"October",{"$f":"Data!C13+Data!C30","v":0},26,0,{"$f":"'Month Rank'!H11","v":1},null,0]
[null,"November",{"$f":"Data!C14+Data!C31","v":0},26,0,{"$f":"'Month Rank'!H12","v":1},null,0]
[null,"December",{"$f":"Data!C15+Data!C32","v":0},24,0,{"$f":"'Month Rank'!H13","v":1},null,0]
[null,"January",{"$f":"Data!C16+Data!C33","v":0},26,0,{"$f":"'Month Rank'!H14","v":1},null,0]
[null,"February",{"$f":"Data!C17+Data!C34","v":0},24,0,{"$f":"'Month Rank'!H15","v":1},null,0]
[null,"March",{"$f":"Data!C18+Data!C35","v":0},26,0,{"$f":"'Month Rank'!H16","v":1},null,0]
[{"$f":"Data!D6","v":"2018/19"},"April",{"$f":"Data!D7+Data!D24","v":0},{"$f":"INDEX(DispensingDays,MATCH(B28,DDMonth,0),MATCH($A$28,DDYear,0))","v":24},0,{"$f":"'Month Rank'!H5","v":1},null,0]
[null,"May",{"$f":"Data!D8+Data!D25","v":0},25,0,{"$f":"'Month Rank'!H6","v":1},null,0]
[null,"June",{"$f":"Data!D9+Data!D26","v":0},26,0,{"$f":"'Month Rank'!H7","v":1},null,0]
[null,"July",{"$f":"Data!D10+Data!D27","v":0},26,0,{"$f":"'Month Rank'!H8","v":1},null,0]
[null,"August",{"$f":"Data!D11+Data!D28","v":0},26,0,{"$f":"'Month Rank'!H9","v":1},null,0]
[null,"September",{"$f":"Data!D12+Data!D29","v":0},25,0,{"$f":"'Month Rank'!H10","v":1},null,0]
[null,"October",{"$f":"Data!D13+Data!D30","v":0},27,0,{"$f":"'Month Rank'!H11","v":1},null,0]
[null,"November",{"$f":"Data!D14+Data!D31","v":0},26,0,{"$f":"'Month Rank'!H12","v":1},null,0]
[null,"December",{"$f":"Data!D15+Data!D32","v":0},24,0,{"$f":"'Month Rank'!H13","v":1},null,0]
[null,"January",{"$f":"Data!D16+Data!D33","v":0},26,0,{"$f":"'Month Rank'!H14","v":1},null,0]
[null,"February",{"$f":"Data!D17+Data!D34","v":0},24,0,{"$f":"'Month Rank'!H15","v":1},null,0]
[null,"March",{"$f":"Data!D18+Data!D35","v":0},26,0,{"$f":"'Month Rank'!H16","v":1},null,0]
[{"$f":"Data!E6","v":"2019/20"},"April",{"$f":"Data!E7+Data!E24","v":0},{"$f":"INDEX(DispensingDays,MATCH(B40,DDMonth,0),MATCH($A$40,DDYear,0))","v":24},0,{"$f":"'Month Rank'!H5","v":1},null,0]
[null,"May",{"$f":"Data!E8+Data!E25","v":0},25,0,{"$f":"'Month Rank'!H6","v":1},null,0]
[null,"June",{"$f":"Data!E9+Data!E26","v":0},25,0,{"$f":"'Month Rank'!H7","v":1},null,0]
[null,"July",{"$f":"Data!E10+Data!E27","v":0},27,0,{"$f":"'Month Rank'!H8","v":1},null,0]
[null,"August",{"$f":"Data!E11+Data!E28","v":0},26,0,{"$f":"'Month Rank'!H9","v":1},null,0]
[null,"September",{"$f":"Data!E12+Data!E29","v":0},25,0,{"$f":"'Month Rank'!H10","v":1},null,0]
[null,"October",{"$f":"Data!E13+Data!E30","v":0},27,0,{"$f":"'Month Rank'!H11","v":1},null,0]
[null,"November",{"$f":"Data!E14+Data!E31","v":0},26,0,{"$f":"'Month Rank'!H12","v":1},null,0]
[null,"December",{"$f":"Data!E15+Data!E32","v":0},24,0,{"$f":"'Month Rank'!H13","v":1},null,0]
[null,"January",{"$f":"Data!E16+Data!E33","v":0},26,0,{"$f":"'Month Rank'!H14","v":1},null,0]
[null,"February",{"$f":"Data!E17+Data!E34","v":0},25,0,{"$f":"'Month Rank'!H15","v":1},null,0]
[null,"March",{"$f":"Data!E18+Data!E35","v":0},26,0,{"$f":"'Month Rank'!H16","v":1},null,0]
[{"$f":"Data!F6","v":"2020/21"},"April",{"$f":"Data!F7+Data!F24","v":0},{"$f":"INDEX(DispensingDays,MATCH(B52,DDMonth,0),MATCH($A$52,DDYear,0))","v":24},0,{"$f":"'Month Rank'!H5","v":1},null,0]
[null,"May",{"$f":"Data!F8+Data!F25","v":0},24,0,{"$f":"'Month Rank'!H6","v":1},null,0]
[null,"June",{"$f":"Data!F9+Data!F26","v":0},26,0,{"$f":"'Month Rank'!H7","v":1},null,0]
[null,"July",{"$f":"Data!F10+Data!F27","v":0},27,0,{"$f":"'Month Rank'!H8","v":1},null,0]
[null,"August",{"$f":"Data!F11+Data!F28","v":0},25,0,{"$f":"'Month Rank'!H9","v":1},null,0]
[null,"September",{"$f":"Data!F12+Data!F29","v":0},26,0,{"$f":"'Month Rank'!H10","v":1},null,0]
[null,"October",{"$f":"Data!F13+Data!F30","v":0},27,0,{"$f":"'Month Rank'!H11","v":1},null,0]
[null,"November",{"$f":"Data!F14+Data!F31","v":0},25,0,{"$f":"'Month Rank'!H12","v":1},null,0]
[null,"December",{"$f":"Data!F15+Data!F32","v":0},24,0,{"$f":"'Month Rank'!H13","v":1},null,0]
[null,"January",{"$f":"Data!F16+Data!F33","v":0},25,0,{"$f":"'Month Rank'!H14","v":1},null,0]
[null,"February",{"$f":"Data!F17+Data!F34","v":0},24,0,{"$f":"'Month Rank'!H15","v":1},null,0]
[null,"March",{"$f":"Data!F18+Data!F35","v":0},27,0,{"$f":"'Month Rank'!H16","v":1},null,0]
[{"$f":"Data!G6","v":"2021/22"},"April",{"$f":"Data!G7+Data!G24","v":0},{"$f":"INDEX(DispensingDays,MATCH(B64,DDMonth,0),MATCH($A$64,DDYear,0))","v":24},{"$f":"E52+1","v":1},{"$f":"'Month Rank'!H5","v":1}]
[null,"May",{"$f":"Data!G8+Data!G25","v":0},{"$f":"INDEX(DispensingDays,MATCH(B65,DDMonth,0),MATCH($A$64,DDYear,0))","v":24},{"$f":"E53+1","v":1},{"$f":"'Month Rank'!H6","v":1}]
[null,"June",{"$f":"Data!G9+Data!G26","v":0},26,1,{"$f":"'Month Rank'!H7","v":1},{"$f":"Forecast!$J$19+D66*Forecast!$J$20+E66*Forecast!$J$21+F66*Forecast!$J$22-Data!G26","v":0}]
[null,"July",{"$f":"Data!G10+Data!G27","v":0},27,1,{"$f":"'Month Rank'!H8","v":1},{"$f":"Forecast!$J$19+D67*Forecast!$J$20+E67*Forecast!$J$21+F67*Forecast!$J$22-Data!G27","v":0}]
[null,"August",{"$f":"Data!G11+Data!G28","v":0},25,1,{"$f":"'Month Rank'!H9","v":1},{"$f":"Forecast!$J$19+D68*Forecast!$J$20+E68*Forecast!$J$21+F68*Forecast!$J$22-Data!G28","v":0}]
[null,"September",{"$f":"Data!G12+Data!G29","v":0},26,1,{"$f":"'Month Rank'!H10","v":1},{"$f":"Forecast!$J$19+D69*Forecast!$J$20+E69*Forecast!$J$21+F69*Forecast!$J$22-Data!G29","v":0}]
[null,"October",{"$f":"Data!G13+Data!G30","v":0},26,1,{"$f":"'Month Rank'!H11","v":1},{"$f":"Forecast!$J$19+D70*Forecast!$J$20+E70*Forecast!$J$21+F70*Forecast!$J$22-Data!G30","v":0}]
[null,"November",null,26,1,{"$f":"'Month Rank'!H12","v":1},{"$f":"Forecast!$J$19+D71*Forecast!$J$20+E71*Forecast!$J$21+F71*Forecast!$J$22-Data!G31","v":0}]
[null,"December",null,24,1,{"$f":"'Month Rank'!H13","v":1},{"$f":"Forecast!$J$19+D72*Forecast!$J$20+E72*Forecast!$J$21+F72*Forecast!$J$22-Data!G32","v":0}]
[null,"January",null,24,1,{"$f":"'Month Rank'!H14","v":1},{"$f":"Forecast!$J$19+D73*Forecast!$J$20+E73*Forecast!$J$21+F73*Forecast!$J$22-Data!G33","v":0}]
[null,"February",null,24,1,{"$f":"'Month Rank'!H15","v":1},{"$f":"Forecast!$J$19+D74*Forecast!$J$20+E74*Forecast!$J$21+F74*Forecast!$J$22-Data!G34","v":0}]
[null,"March",null,27,1,{"$f":"'Month Rank'!H16","v":1},{"$f":"Forecast!$J$19+D75*Forecast!$J$20+E75*Forecast!$J$21+F75*Forecast!$J$22-Data!G35","v":0}]
[]
[null,null,null,null,null,null,{"$f":"SUM(G64:G75)+SUM(C64:C75)","v":0}]

{"sheet":"Test","index":8,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["SUMMARY OUTPUT"]
[]
["Regression Statistics"]
["Multiple R",0.94675904131896715]
["R Square",0.89635268231920984]
["Adjusted R Square",0.89149421430292275]
["Standard Error",19944088.611836858]
["Observations",68]
[]
["ANOVA"]
[null,"df","SS","MS","F","Significance F"]
["Regression",3,2.2015533758514627E+17,7.3385112528382096E+16,184.49286468787429,1.9271858058638496E-31]
["Residual",64,2.5457066915635244E+16,397766670556800.69]
["Total",67,2.456124045007815E+17]
[]
[null,"Coefficients","Standard Error","t Stat","P-value","Lower 95%","Upper 95%","Lower 95.0%","Upper 95.0%"]
["Intercept",66259929.477924868,60951714.340607792,1.0870888570525503,0.28107481274189733,-55505117.741808459,188024976.69765818,-55505117.741808459,188024976.69765818]
["X Variable 1",20461180.263346486,2334475.0219550529,8.7647886873558658,1.4580514625249047E-12,15797530.284722924,25124830.241970047,15797530.284722924,25124830.241970047]
["X Variable 2",31829427.766404893,1472502.2174283722,21.615877646685576,4.0966149445591268E-31,28887766.420599669,34771089.112210117,28887766.420599669,34771089.112210117]
["X Variable 3",3483634.5766923139,734600.52023061051,4.7422163213261941,1.2235989511495012E-5,2016101.3333504172,4951167.8200342106,2016101.3333504172,4951167.8200342106]
[]
[]
[]
[]
[]
[]
[24,6,12,642566770.65031099,null,null,{"$f":"$B$17+A27*$B$18+B27*$B$19+C27*B20","v":790108437.31697762},{"$f":"G27-Data!G32","v":790108437.31697762}]
[26,6,4,655620054.56346548,null,null,{"$f":"$B$17+A28*$B$18+B28*$B$19+C28*B21","v":789227182.92336285},{"$f":"G28-Data!G33","v":789227182.92336285}]
[24,6,1,604246790.30669558,null,null,748304822.39666986,{"$f":"G29-Data!G34","v":748304822.39666986}]
[26,6,6,662587323.71685016,null,null,789227182.92336285,{"$f":"G30-Data!G35","v":789227182.92336285}]

{"sheet":"Regression Feed FUpdated","index":9,"n_rows":77,"n_cols":8,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
["Feed for running regression that updates with most recent months"]
[]
["year","Month","Historical","Dispensing days","year","month","Predicted spend"]
[{"$f":"Data!B6","v":"2016/17"},"April",{"$f":"Data!B7+Data!B24","v":0},{"$f":"INDEX(DispensingDays,MATCH(B4,DDMonth,0),MATCH($A$4,DDYear,0))","v":26},{"$f":"IF(C4=0,0,1)","v":0},{"$f":"'Month Rank'!H5","v":1},null,"month rank based on data for that year, not total across few years"]
[null,"May",{"$f":"Data!B8+Data!B25","v":0},24,0,{"$f":"'Month Rank'!H6","v":1}]
[null,"June",{"$f":"Data!B9+Data!B26","v":0},26,0,{"$f":"'Month Rank'!H7","v":1}]
[null,"July",{"$f":"Data!B10+Data!B27","v":0},26,0,{"$f":"'Month Rank'!H8","v":1}]
[null,"August",{"$f":"Data!B11+Data!B28","v":0},26,0,{"$f":"'Month Rank'!H9","v":1}]
[null,"September",{"$f":"Data!B12+Data!B29","v":0},26,0,{"$f":"'Month Rank'!H10","v":1}]
[null,"October",{"$f":"Data!B13+Data!B30","v":0},26,0,{"$f":"'Month Rank'!H11","v":1}]
[null,"November",{"$f":"Data!B14+Data!B31","v":0},26,0,{"$f":"'Month Rank'!H12","v":1}]
[null,"December",{"$f":"Data!B15+Data!B32","v":0},25,0,{"$f":"'Month Rank'!H13","v":1}]
[null,"January",{"$f":"Data!B16+Data!B33","v":0},25,0,{"$f":"'Month Rank'!H14","v":1}]
[null,"February",{"$f":"Data!B17+Data!B34","v":0},24,0,{"$f":"'Month Rank'!H15","v":1}]
[null,"March",{"$f":"Data!B18+Data!B35","v":0},27,0,{"$f":"'Month Rank'!H16","v":1}]
[{"$f":"Data!C6","v":"2017/18"},"April",{"$f":"Data!C7+Data!C24","v":0},{"$f":"INDEX(DispensingDays,MATCH(B16,DDMonth,0),MATCH($A$16,DDYear,0))","v":23},{"$f":"IF(C16=0,0,E4+1)","v":0},{"$f":"'Month Rank'!H5","v":1}]
[null,"May",{"$f":"Data!C8+Data!C25","v":0},25,0,{"$f":"'Month Rank'!H6","v":1}]
[null,"June",{"$f":"Data!C9+Data!C26","v":0},26,0,{"$f":"'Month Rank'!H7","v":1}]
[null,"July",{"$f":"Data!C10+Data!C27","v":0},26,0,{"$f":"'Month Rank'!H8","v":1}]
[null,"August",{"$f":"Data!C11+Data!C28","v":0},26,0,{"$f":"'Month Rank'!H9","v":1}]
[null,"September",{"$f":"Data!C12+Data!C29","v":0},26,0,{"$f":"'Month Rank'!H10","v":1}]
[null,"October",{"$f":"Data!C13+Data!C30","v":0},26,0,{"$f":"'Month Rank'!H11","v":1}]
[null,"November",{"$f":"Data!C14+Data!C31","v":0},26,0,{"$f":"'Month Rank'!H12","v":1}]
[null,"December",{"$f":"Data!C15+Data!C32","v":0},24,0,{"$f":"'Month Rank'!H13","v":1}]
[null,"January",{"$f":"Data!C16+Data!C33","v":0},26,0,{"$f":"'Month Rank'!H14","v":1}]
[null,"February",{"$f":"Data!C17+Data!C34","v":0},24,0,{"$f":"'Month Rank'!H15","v":1}]
[null,"March",{"$f":"Data!C18+Data!C35","v":0},26,0,{"$f":"'Month Rank'!H16","v":1}]
[{"$f":"Data!D6","v":"2018/19"},"April",{"$f":"Data!D7+Data!D24","v":0},{"$f":"INDEX(DispensingDays,MATCH(B28,DDMonth,0),MATCH($A$28,DDYear,0))","v":24},0,{"$f":"'Month Rank'!H5","v":1}]
[null,"May",{"$f":"Data!D8+Data!D25","v":0},25,0,{"$f":"'Month Rank'!H6","v":1}]
[null,"June",{"$f":"Data!D9+Data!D26","v":0},26,0,{"$f":"'Month Rank'!H7","v":1}]
[null,"July",{"$f":"Data!D10+Data!D27","v":0},26,0,{"$f":"'Month Rank'!H8","v":1}]
[null,"August",{"$f":"Data!D11+Data!D28","v":0},26,0,{"$f":"'Month Rank'!H9","v":1}]
[null,"September",{"$f":"Data!D12+Data!D29","v":0},25,0,{"$f":"'Month Rank'!H10","v":1}]
[null,"October",{"$f":"Data!D13+Data!D30","v":0},27,0,{"$f":"'Month Rank'!H11","v":1}]
[null,"November",{"$f":"Data!D14+Data!D31","v":0},26,0,{"$f":"'Month Rank'!H12","v":1}]
[null,"December",{"$f":"Data!D15+Data!D32","v":0},24,0,{"$f":"'Month Rank'!H13","v":1}]
[null,"January",{"$f":"Data!D16+Data!D33","v":0},26,0,{"$f":"'Month Rank'!H14","v":1}]
[null,"February",{"$f":"Data!D17+Data!D34","v":0},24,0,{"$f":"'Month Rank'!H15","v":1}]
[null,"March",{"$f":"Data!D18+Data!D35","v":0},26,0,{"$f":"'Month Rank'!H16","v":1}]
[{"$f":"Data!E6","v":"2019/20"},"April",{"$f":"Data!E7+Data!E24","v":0},{"$f":"INDEX(DispensingDays,MATCH(B40,DDMonth,0),MATCH($A$40,DDYear,0))","v":24},0,{"$f":"'Month Rank'!H5","v":1}]
[null,"May",{"$f":"Data!E8+Data!E25","v":0},25,0,{"$f":"'Month Rank'!H6","v":1}]
[null,"June",{"$f":"Data!E9+Data!E26","v":0},25,0,{"$f":"'Month Rank'!H7","v":1}]
[null,"July",{"$f":"Data!E10+Data!E27","v":0},27,0,{"$f":"'Month Rank'!H8","v":1}]
[null,"August",{"$f":"Data!E11+Data!E28","v":0},26,0,{"$f":"'Month Rank'!H9","v":1}]
[null,"September",{"$f":"Data!E12+Data!E29","v":0},25,0,{"$f":"'Month Rank'!H10","v":1}]
[null,"October",{"$f":"Data!E13+Data!E30","v":0},27,0,{"$f":"'Month Rank'!H11","v":1}]
[null,"November",{"$f":"Data!E14+Data!E31","v":0},26,0,{"$f":"'Month Rank'!H12","v":1}]
[null,"December",{"$f":"Data!E15+Data!E32","v":0},24,0,{"$f":"'Month Rank'!H13","v":1}]
[null,"January",{"$f":"Data!E16+Data!E33","v":0},26,0,{"$f":"'Month Rank'!H14","v":1}]
[null,"February",{"$f":"Data!E17+Data!E34","v":0},25,0,{"$f":"'Month Rank'!H15","v":1}]
[null,"March",{"$f":"Data!E18+Data!E35","v":0},26,0,{"$f":"'Month Rank'!H16","v":1}]
[{"$f":"Data!F6","v":"2020/21"},"April",{"$f":"Data!F7+Data!F24","v":0},{"$f":"INDEX(DispensingDays,MATCH(B52,DDMonth,0),MATCH($A$52,DDYear,0))","v":24},0,{"$f":"'Month Rank'!H5","v":1}]
[null,"May",{"$f":"Data!F8+Data!F25","v":0},24,0,{"$f":"'Month Rank'!H6","v":1}]
[null,"June",{"$f":"Data!F9+Data!F26","v":0},26,0,{"$f":"'Month Rank'!H7","v":1}]
[null,"July",{"$f":"Data!F10+Data!F27","v":0},27,0,{"$f":"'Month Rank'!H8","v":1}]
[null,"August",{"$f":"Data!F11+Data!F28","v":0},25,0,{"$f":"'Month Rank'!H9","v":1}]
[null,"September",{"$f":"Data!F12+Data!F29","v":0},26,0,{"$f":"'Month Rank'!H10","v":1}]
[null,"October",{"$f":"Data!F13+Data!F30","v":0},27,0,{"$f":"'Month Rank'!H11","v":1}]
[null,"November",{"$f":"Data!F14+Data!F31","v":0},25,0,{"$f":"'Month Rank'!H12","v":1}]
[null,"December",{"$f":"Data!F15+Data!F32","v":0},24,0,{"$f":"'Month Rank'!H13","v":1}]
[null,"January",{"$f":"Data!F16+Data!F33","v":0},25,0,{"$f":"'Month Rank'!H14","v":1}]
[null,"February",{"$f":"Data!F17+Data!F34","v":0},24,0,{"$f":"'Month Rank'!H15","v":1}]
[null,"March",{"$f":"Data!F18+Data!F35","v":0},27,0,{"$f":"'Month Rank'!H16","v":1}]
[{"$f":"Data!G6","v":"2021/22"},"April",{"$f":"Data!G7+Data!G24","v":0},{"$f":"INDEX(DispensingDays,MATCH(B64,DDMonth,0),MATCH($A$64,DDYear,0))","v":24},{"$f":"E52+1","v":1},{"$f":"'Month Rank'!H5","v":1},{"$f":"IF(C64<>\"\",\"\",'Forecast Updated'!$J$22+D64*'Forecast Updated'!$J$23+E64*'Forecast Updated'!$J$24+F64*'Forecast Updated'!$J$25-Data!G24)","v":""}]
[null,"May",{"$f":"Data!G8+Data!G25","v":0},24,1,{"$f":"'Month Rank'!H6","v":1},{"$f":"IF(C65<>\"\",\"\",'Forecast Updated'!$J$22+D65*'Forecast Updated'!$J$23+E65*'Forecast Updated'!$J$24+F65*'Forecast Updated'!$J$25-Data!G25)","v":""}]
[null,"June",{"$f":"Data!G9+Data!G26","v":0},26,1,{"$f":"'Month Rank'!H7","v":1},{"$f":"IF(C66<>\"\",\"\",'Forecast Updated'!$J$22+D66*'Forecast Updated'!$J$23+E66*'Forecast Updated'!$J$24+F66*'Forecast Updated'!$J$25-Data!G26)","v":""}]
[null,"July",{"$f":"Data!G10+Data!G27","v":0},27,1,{"$f":"'Month Rank'!H8","v":1},{"$f":"IF(C67<>\"\",\"\",'Forecast Updated'!$J$22+D67*'Forecast Updated'!$J$23+E67*'Forecast Updated'!$J$24+F67*'Forecast Updated'!$J$25-Data!G27)","v":""}]
[null,"August",{"$f":"Data!G11+Data!G28","v":0},25,1,{"$f":"'Month Rank'!H9","v":1},{"$f":"IF(C68<>\"\",\"\",'Forecast Updated'!$J$22+D68*'Forecast Updated'!$J$23+E68*'Forecast Updated'!$J$24+F68*'Forecast Updated'!$J$25-Data!G28)","v":""}]
[null,"September",{"$f":"Data!G12+Data!G29","v":0},26,1,{"$f":"'Month Rank'!H10","v":1},{"$f":"IF(C69<>\"\",\"\",'Forecast Updated'!$J$22+D69*'Forecast Updated'!$J$23+E69*'Forecast Updated'!$J$24+F69*'Forecast Updated'!$J$25-Data!G29)","v":""}]
[null,"October",{"$f":"Data!G13+Data!G30","v":0},26,1,{"$f":"'Month Rank'!H11","v":1},{"$f":"IF(C70<>\"\",\"\",'Forecast Updated'!$J$22+D70*'Forecast Updated'!$J$23+E70*'Forecast Updated'!$J$24+F70*'Forecast Updated'!$J$25-Data!G30)","v":""}]
[null,"November",null,26,1,{"$f":"'Month Rank'!H12","v":1},{"$f":"IF(C71<>\"\",\"\",'Forecast Updated'!$J$22+D71*'Forecast Updated'!$J$23+E71*'Forecast Updated'!$J$24+F71*'Forecast Updated'!$J$25-Data!G31)","v":0}]
[null,"December",null,24,1,{"$f":"'Month Rank'!H13","v":1},{"$f":"IF(C72<>\"\",\"\",'Forecast Updated'!$J$22+D72*'Forecast Updated'!$J$23+E72*'Forecast Updated'!$J$24+F72*'Forecast Updated'!$J$25-Data!G32)","v":0}]
[null,"January",null,24,1,{"$f":"'Month Rank'!H14","v":1},{"$f":"IF(C73<>\"\",\"\",'Forecast Updated'!$J$22+D73*'Forecast Updated'!$J$23+E73*'Forecast Updated'!$J$24+F73*'Forecast Updated'!$J$25-Data!G33)","v":0}]
[null,"February",null,24,1,{"$f":"'Month Rank'!H15","v":1},{"$f":"IF(C74<>\"\",\"\",'Forecast Updated'!$J$22+D74*'Forecast Updated'!$J$23+E74*'Forecast Updated'!$J$24+F74*'Forecast Updated'!$J$25-Data!G34)","v":0}]
[null,"March",null,27,1,{"$f":"'Month Rank'!H16","v":1},{"$f":"IF(C75<>\"\",\"\",'Forecast Updated'!$J$22+D75*'Forecast Updated'!$J$23+E75*'Forecast Updated'!$J$24+F75*'Forecast Updated'!$J$25-Data!G35)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"SUM(G64:G75)+SUM(C64:C75)","v":0}]

{"sheet":"Policy - not updated","index":10,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Policy Impact",null,"Taken from 20130221 National forecast incl DCMC"]
[]
["Policy changes used in the model - internal estimate"]
[]
["Date","Type","Impact per year","Per month"]
["2003-12-01","1st generic",-150,{"$f":"C6/12","v":-12.5}]
["2004-10-01","2nd generic",-150,-12.5]
["2005-02-01","PPRS 05",{"$f":"-1800/5","v":-360},-30]
["2005-04-01","CatM1",-300,-25]
["2006-10-01","CatM2",-300,-25]
["2007-07-01","CatM technical adju",-120,-10]
["2007-10-01","CatM3",-400,-33.333333333333336]
["2008-10-01","CatM4",-130,-10.833333333333334]
["2009-03-01","PPRS 09 (3.9%)",-160,-13.333333333333334]
["2009-10-01","CatM5",-80,-6.666666666666667]
["2010-02-01","PPRS 09 (1.9%)",-80,-6.666666666666667]
["2010-10-01","CatM6",-240,-20]
["2011-01-01","PPRS09",5.7,0.47500000000000003]
["2011-04-01","CatM7",-90,-7.5]
["2011-04-01","QP indicators & QIPP",-150,-12.5]
["2011-10-01","CatM8",-156,-13]
["2012-04-01","CatM9",-40,-3.3333333333333335]
["2012-04-01","QP indicators & QIPP",-100,-8.3333333333333339]
["2012-06-01","Atorvastatin",-266.91289109999997,-22.242740924999996]
["2012-10-01","CatM10",-185,{"$f":"C25/12","v":-15.416666666666666}]
[]
["Restricted Policy"]