{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Lead data","Forecasted sales ","Monthly Weighted Forecast"],"not_rendered":{"charts":1,"images":1,"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"Lead data","index":0,"n_rows":10,"n_cols":10,"rows_kept":10,"merged":[[2,1,2,2],[3,4,3,8],[4,1,4,8]]}
[]
[]
[null,"Detailed leads tracker"]
[null,{"$f":"TODAY()","v":"2019-11-17"}]
[null,"Company name\t\t\t\t\t\t\t\t\t\t",{"$nulls":7},"CONFIDENTIAL"]
[null,"Lead name","Lead contact","Lead \nSource","Lead \nRegion","Lead \nType","Potential opportunity","Chance \nof sale","Forecast \nClose","Weighted \nForecast"]
[null,"Adatum Corporation",null,"Website","North","Strategic",{"v":300000,"d":"£300,000.00"},{"v":0.9,"d":"90%"},"January",{"$f":"IFERROR(IF(LeadData[Chance \nof sale]<>\"\",LeadData[Chance \nof sale]*LeadData[Potential opportunity],\"\"),\"\")","v":{"v":270000,"d":"£270,000.00"}}]
[null,"Adventure Works",null,"Networking event","South","Strategic",{"v":200000,"d":"£200,000.00"},{"v":0.1,"d":"10%"},"February",{"$f":"IFERROR(IF(LeadData[Chance \nof sale]<>\"\",LeadData[Chance \nof sale]*LeadData[Potential opportunity],\"\"),\"\")","v":{"v":20000,"d":"£20,000.00"}}]
[null,"Alpine ski chalet",null,"Networking event","North","Tactical",{"v":100000,"d":"£100,000.00"},{"v":0.2,"d":"20%"},"March",{"$f":"IFERROR(IF(LeadData[Chance \nof sale]<>\"\",LeadData[Chance \nof sale]*LeadData[Potential opportunity],\"\"),\"\")","v":{"v":20000,"d":"£20,000.00"}}]
[null,"Total",{"$nulls":4},{"$f":"SUBTOTAL(109,LeadData[Potential opportunity])","v":{"v":600000,"d":"£600,000.00"}},null,null,{"$f":"SUBTOTAL(109,LeadData[Weighted \nForecast])","v":{"v":310000,"d":"£310,000.00"}}]

{"sheet":"Forecasted sales ","index":1,"n_rows":15,"n_cols":14,"rows_kept":15,"merged":[[0,5,0,9],[2,1,2,2],[4,1,4,11],[4,12,4,13]]}
[]
[]
[null,"Forecasted sales"]
[null,{"$f":"TrackerDate","v":"2019-11-17"}]
[null,{"$f":"'Lead data'!B5:I5","v":"Company name\t\t\t\t\t\t\t\t\t\t"},{"$nulls":10},"CONFIDENTIAL"]
[null,"Lead name","January \nForecast","February \nForecast","March \nForecast","April \nForecast","May \nForecast","June \nForecast","July Forecast","August \nForecast","September \nForecast","October \nForecast","November \nForecast","December \nForecast"]
[null,{"$f":"IFERROR(IF(AND(LeadData[Lead name] <> \"\", ROW(ForecastedSales[Lead name])<>LastEntry),LeadData[Lead name], \"\"),\"\")","v":"Adatum Corporation"},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"January\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":270000,"d":"£270,000"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"February\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"March\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"April\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"May\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"June\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"July\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"August\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"September\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"October\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"November\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"December\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}}]
[null,{"$f":"IFERROR(IF(AND(LeadData[Lead name] <> \"\", ROW(ForecastedSales[Lead name])<>LastEntry),LeadData[Lead name], \"\"),\"\")","v":"Adventure Works"},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"January\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"February\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":20000,"d":"£20,000"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"March\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"April\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"May\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"June\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"July\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"August\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"September\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"October\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"November\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"December\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}}]
[null,{"$f":"IFERROR(IF(AND(LeadData[Lead name] <> \"\", ROW(ForecastedSales[Lead name])<>LastEntry),LeadData[Lead name], \"\"),\"\")","v":"Alpine ski chalet"},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"January\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"February\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"March\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":20000,"d":"£20,000"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"April\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"May\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"June\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"July\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"August\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"September\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"October\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"November\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"December\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}}]
[null,{"$f":"IFERROR(IF(AND(LeadData[Lead name] <> \"\", ROW(ForecastedSales[Lead name])<>LastEntry),LeadData[Lead name], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"January\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"February\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"March\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"April\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"May\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"June\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"July\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"August\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"September\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"October\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"November\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"December\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(LeadData[Lead name] <> \"\", ROW(ForecastedSales[Lead name])<>LastEntry),LeadData[Lead name], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"January\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"February\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"March\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"April\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"May\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"June\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"July\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"August\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"September\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"October\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"November\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"December\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(LeadData[Lead name] <> \"\", ROW(ForecastedSales[Lead name])<>LastEntry),LeadData[Lead name], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"January\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"February\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"March\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"April\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"May\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"June\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"July\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"August\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"September\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"October\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"November\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"December\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(LeadData[Lead name] <> \"\", ROW(ForecastedSales[Lead name])<>LastEntry),LeadData[Lead name], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"January\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"February\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"March\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"April\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"May\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"June\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"July\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"August\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"September\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"October\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"November\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[Forecast \nClose] <>\"\",IF(LeadData[Forecast \nClose] = \"December\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""}]
[null,"Total",{"$f":"SUBTOTAL(109,ForecastedSales[January \nForecast])","v":{"v":270000,"d":"£270,000"}},{"$f":"SUBTOTAL(109,ForecastedSales[February \nForecast])","v":{"v":20000,"d":"£20,000"}},{"$f":"SUBTOTAL(109,ForecastedSales[March \nForecast])","v":{"v":20000,"d":"£20,000"}},{"$f":"SUBTOTAL(109,ForecastedSales[April \nForecast])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,ForecastedSales[May \nForecast])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,ForecastedSales[June \nForecast])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,ForecastedSales[July Forecast])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,ForecastedSales[August \nForecast])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,ForecastedSales[September \nForecast])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,ForecastedSales[October \nForecast])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,ForecastedSales[November \nForecast])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,ForecastedSales[December \nForecast])","v":{"v":0,"d":"£0"}}]
[null,"Cumulative total",{"$f":"C14","v":{"v":270000,"d":"£270,000"}},{"$f":"C15+D14","v":{"v":290000,"d":"£290,000"}},{"$f":"D15+E14","v":{"v":310000,"d":"£310,000"}},{"$f":"E15+F14","v":{"v":310000,"d":"£310,000"}},{"$f":"F15+G14","v":{"v":310000,"d":"£310,000"}},{"$f":"G15+H14","v":{"v":310000,"d":"£310,000"}},{"$f":"H15+I14","v":{"v":310000,"d":"£310,000"}},{"$f":"I15+J14","v":{"v":310000,"d":"£310,000"}},{"$f":"J15+K14","v":{"v":310000,"d":"£310,000"}},{"$f":"K15+L14","v":{"v":310000,"d":"£310,000"}},{"$f":"L15+M14","v":{"v":310000,"d":"£310,000"}},{"$f":"M15+N14","v":{"v":310000,"d":"£310,000"}}]

{"sheet":"Monthly Weighted Forecast","index":2,"n_rows":3,"n_cols":2,"rows_kept":3,"merged":[[0,5,0,9]]}
[]
[]
[null,"Monthly Weighted Forecast"]