{"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,"Wide World Importers "]
[null,"Detailed leads tracker"]
[null,{"$f":"TODAY()","v":"2022-11-10"}]
[{"$nulls":8},{"$f":"Company_Name","v":"Wide World Importers "},"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":"Wide World Importers "}]
[null,"Forecasted sales"]
[null,{"$f":"TrackerDate","v":"2022-11-10"}]
[{"$nulls":11},{"$f":"Company_Name","v":"Wide World Importers "},"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":"Wide World Importers "}]
[null,"Monthly weighted forecast"]
[null," "]