{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Lead Data","Forecasted Sales ","Monthly Weighted Forecast"],"not_rendered":{"charts":1,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Lead Data","index":0,"n_rows":9,"n_cols":10,"rows_kept":9}
[null,"Company Name"]
[null,"Detailed Leads Tracker"]
[null,{"$f":"TODAY()","v":"2022-04-01"}]
[{"$nulls":8},{"$f":"Company_Name","v":"Company Name"},"CONFIDENTIAL"]
[null,"Lead Name","Lead Contact","Lead \nSource","Lead \nRegion","Lead \nType","Potential Opportunity","Chance \nof Sale","Forecast \nClose","Weighted \nForecast"]
[null,"A. Datum Corporation",{"$nulls":3},"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",{"$nulls":3},"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",{"$nulls":3},"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":21,"n_cols":14,"rows_kept":21,"merged":[[3,12,3,13]]}
[null,{"$f":"Company_Name","v":"Company Name"}]
[null,"Forecasted Sales"]
[null,{"$f":"TrackerDate","v":"2022-04-01"}]
[{"$nulls":11},{"$f":"Company_Name","v":"Company Name"},"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":"A. Datum 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"}},{"$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"}},{"$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"}},{"$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"}},{"$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"}},{"$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"}},{"$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,{"$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,{"$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":"C20","v":{"v":270000,"d":"£270,000"}},{"$f":"C21+D20","v":{"v":290000,"d":"£290,000"}},{"$f":"D21+E20","v":{"v":310000,"d":"£310,000"}},{"$f":"E21+F20","v":{"v":310000,"d":"£310,000"}},{"$f":"F21+G20","v":{"v":310000,"d":"£310,000"}},{"$f":"G21+H20","v":{"v":310000,"d":"£310,000"}},{"$f":"H21+I20","v":{"v":310000,"d":"£310,000"}},{"$f":"I21+J20","v":{"v":310000,"d":"£310,000"}},{"$f":"J21+K20","v":{"v":310000,"d":"£310,000"}},{"$f":"K21+L20","v":{"v":310000,"d":"£310,000"}},{"$f":"L21+M20","v":{"v":310000,"d":"£310,000"}},{"$f":"M21+N20","v":{"v":310000,"d":"£310,000"}}]

{"sheet":"Monthly Weighted Forecast","index":2,"n_rows":3,"n_cols":2,"rows_kept":3}
[null,{"$f":"Company_Name","v":"Company Name"}]
[null,"Monthly Weighted Forecast"]
[null," "]