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

{"sheet":"Lead data","index":0,"n_rows":9,"n_cols":10,"rows_kept":9}
[]
[null," COMPANY NAME",{"$nulls":7},"Olson Harris Ltd. | Confidential"]
[null,"DETAILED LEADS TRACKER",{"$nulls":7},{"$f":"TODAY()","v":"2022-11-28"}]
[]
[null,"Lead name","Lead contact","Lead source","Lead region","Lead type","Potential opportunity","Chance of sale","Forecast close","Weighted forecast"]
[null,"Adatom Corporation","Madison Butler","Website","North","Strategic",{"v":300000,"d":"$300,000.00"},{"v":0.9,"d":"90%"},"January",{"$f":"IFERROR(IF(LeadData[[#This Row],[Chance of sale]]<>\"\",LeadData[[#This Row],[Chance of sale]]*LeadData[[#This Row],[Potential opportunity]],\"\"),\"\")","v":{"v":270000,"d":"$270,000.00"}}]
[null,"Adventure Works","Jozi Kos","Networking event","South","Strategic",{"v":200000,"d":"$200,000.00"},{"v":0.1,"d":"10%"},"February",{"$f":"IFERROR(IF(LeadData[[#This Row],[Chance of sale]]<>\"\",LeadData[[#This Row],[Chance of sale]]*LeadData[[#This Row],[Potential opportunity]],\"\"),\"\")","v":{"v":20000,"d":"$20,000.00"}}]
[null,"Alpine Ski House","Ashlee Barnes","Networking event","North","Tactical",{"v":100000,"d":"$100,000.00"},{"v":0.2,"d":"20%"},"March",{"$f":"IFERROR(IF(LeadData[[#This Row],[Chance of sale]]<>\"\",LeadData[[#This Row],[Chance of 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 forecast])","v":{"v":310000,"d":"$310,000.00"}}]

{"sheet":"Forecasted sales ","index":1,"n_rows":12,"n_cols":14,"rows_kept":12,"merged":[[1,1,1,2],[2,12,2,13]]}
[]
[null,{"$f":"'Lead data'!B2","v":" COMPANY NAME"},{"$nulls":11},"Olson Harris Ltd. | Confidential"]
[null,"FORECASTED SALES",{"$nulls":10},{"$f":"TrackerDate","v":"2022-11-28"}]
[]
[null,"Lead name","January\nforecast","February \nforecast","March \nforecast","April \nforecast","May \nforecast","June \nforecast","July \nforecast","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":"Adatom Corporation"},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]]= \"January\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":270000,"d":"$270,000"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"February\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"March\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"April\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"May\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"June\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"July\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"August\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"September\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"October\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"November\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"December\",LeadData[Weighted forecast],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 close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]]= \"January\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"February\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":20000,"d":"$20,000"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"March\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"April\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"May\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"June\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"July\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"August\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"September\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"October\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"November\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"December\",LeadData[Weighted forecast],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 close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]]= \"January\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"February\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"March\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":20000,"d":"$20,000"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"April\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"May\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"June\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"July\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"August\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"September\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"October\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"November\",LeadData[Weighted forecast],0),\"\"),\"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"December\",LeadData[Weighted forecast],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 close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]]= \"January\",LeadData[Weighted forecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"February\",LeadData[Weighted forecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"March\",LeadData[Weighted forecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"April\",LeadData[Weighted forecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"May\",LeadData[Weighted forecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"June\",LeadData[Weighted forecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"July\",LeadData[Weighted forecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"August\",LeadData[Weighted forecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"September\",LeadData[Weighted forecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"October\",LeadData[Weighted forecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"November\",LeadData[Weighted forecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"December\",LeadData[Weighted forecast],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 close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]]= \"January\",LeadData[Weighted forecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"February\",LeadData[Weighted forecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"March\",LeadData[Weighted forecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"April\",LeadData[Weighted forecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"May\",LeadData[Weighted forecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"June\",LeadData[Weighted forecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"July\",LeadData[Weighted forecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"August\",LeadData[Weighted forecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"September\",LeadData[Weighted forecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"October\",LeadData[Weighted forecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"November\",LeadData[Weighted forecast],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Forecast close]] <>\"\",IF(LeadData[[#This Row],[Forecast close]] = \"December\",LeadData[Weighted forecast],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 \nforecast])","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":"C11","v":{"v":270000,"d":"$270,000"}},{"$f":"C12+D11","v":{"v":290000,"d":"$290,000"}},{"$f":"D12+E11","v":{"v":310000,"d":"$310,000"}},{"$f":"E12+F11","v":{"v":310000,"d":"$310,000"}},{"$f":"F12+G11","v":{"v":310000,"d":"$310,000"}},{"$f":"G12+H11","v":{"v":310000,"d":"$310,000"}},{"$f":"H12+I11","v":{"v":310000,"d":"$310,000"}},{"$f":"I12+J11","v":{"v":310000,"d":"$310,000"}},{"$f":"J12+K11","v":{"v":310000,"d":"$310,000"}},{"$f":"K12+L11","v":{"v":310000,"d":"$310,000"}},{"$f":"L12+M11","v":{"v":310000,"d":"$310,000"}},{"$f":"M12+N11","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,{"$f":"'Lead data'!B2","v":" COMPANY NAME"}]
[null,"MONTHLY WEIGHTED FORECAST"]