{"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]]}
[]
[]
[null,"Detailed Leads Tracker"]
[null,{"$f":"TODAY()","v":"2022-06-22"}]
[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[[#This Row],[Chance \nof Sale]]<>\"\",LeadData[[#This Row],[Chance \nof Sale]]*LeadData[[#This Row],[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[[#This Row],[Chance \nof Sale]]<>\"\",LeadData[[#This Row],[Chance \nof Sale]]*LeadData[[#This Row],[Potential Opportunity]],\"\"),\"\")","v":{"v":20000,"d":"£20,000.00"}}]
[null,"Alpine Ski House",null,"Networking event","North","Tactical",{"v":100000,"d":"£100,000.00"},{"v":0.2,"d":"20%"},"March",{"$f":"IFERROR(IF(LeadData[[#This Row],[Chance \nof Sale]]<>\"\",LeadData[[#This Row],[Chance \nof Sale]]*LeadData[[#This Row],[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,12,4,13]]}
[]
[]
[null,"Forecasted Sales"]
[null,{"$f":"TrackerDate","v":"2022-06-22"}]
[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[[#This Row],[Lead Name]] <> \"\", ROW(ForecastedSales[Lead name])<>LastEntry),LeadData[Lead Name], \"\"),\"\")","v":"Adatum Corporation"},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]]= \"January\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":270000,"d":"£270,000"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"February\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"March\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"April\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0.00"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"May\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"June\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"July\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"August\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0.00"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"September\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"October\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"November\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"December\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}}]
[null,{"$f":"IFERROR(IF(AND(LeadData[[#This Row],[Lead Name]] <> \"\", ROW(ForecastedSales[Lead name])<>LastEntry),LeadData[Lead Name], \"\"),\"\")","v":"Adventure Works"},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]]= \"January\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"February\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":20000,"d":"£20,000"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"March\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"April\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0.00"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"May\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"June\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"July\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"August\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0.00"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"September\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"October\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"November\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"December\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}}]
[null,{"$f":"IFERROR(IF(AND(LeadData[[#This Row],[Lead Name]] <> \"\", ROW(ForecastedSales[Lead name])<>LastEntry),LeadData[Lead Name], \"\"),\"\")","v":"Alpine Ski House"},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]]= \"January\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"February\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"March\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":20000,"d":"£20,000"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"April\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0.00"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"May\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"June\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"July\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"August\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0.00"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"September\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"October\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"November\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"December\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":{"v":0,"d":"£0"}}]
[null,{"$f":"IFERROR(IF(AND(LeadData[[#This Row],[Lead Name]] <> \"\", ROW(ForecastedSales[Lead name])<>LastEntry),LeadData[Lead Name], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]]= \"January\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"February\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"March\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"April\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"May\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"June\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"July\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"August\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"September\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"October\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"November\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"December\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(LeadData[[#This Row],[Lead Name]] <> \"\", ROW(ForecastedSales[Lead name])<>LastEntry),LeadData[Lead Name], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]]= \"January\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"February\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"March\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"April\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"May\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"June\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"July\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"August\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"September\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"October\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"November\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"December\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(LeadData[[#This Row],[Lead Name]] <> \"\", ROW(ForecastedSales[Lead name])<>LastEntry),LeadData[Lead Name], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]]= \"January\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"February\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"March\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"April\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"May\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"June\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"July\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"August\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"September\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"October\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"November\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"December\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(LeadData[[#This Row],[Lead Name]] <> \"\", ROW(ForecastedSales[Lead name])<>LastEntry),LeadData[Lead Name], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]]= \"January\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"February\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"March\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"April\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"May\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"June\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"July\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"August\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"September\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"October\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[Forecast \nClose]] = \"November\",LeadData[Weighted \nForecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast \nClose]] <>\"\",IF(LeadData[[#This Row],[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"]