{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Revenue Input","Optimistic Revenue","Most Likely Revenue","Pessimistic Revenue","Mean Revenue","Monthly Revenue","Cumulative Revenue"],"not_rendered":{"charts":4,"defined_names":1},"unopened":[{"sheet":"Monthly Revenue","index":5,"reason":"not_a_worksheet"},{"sheet":"Cumulative Revenue","index":6,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900"}

{"sheet":"Revenue Input","index":0,"n_rows":35,"n_cols":7,"rows_kept":35}
["[Company Name] "]
["Detailed Revenue Plan—Input"]
["[Company Name] Confidential"]
["[Date]"]
[]
["FISCAL YEAR BEGINNING","2016-07-01"]
[]
["Gray cells are calculated for you, and they generally should not be altered. "]
[]
["Opportunity\nname","Sales\ncategory","Optimistic\nforecast","Most likely\nforecast","Pessimistic\nforecast","Forecast\nclose","Mean\nforecast"]
["A. Datum Corporation","Consulting",{"v":150000,"d":"$150,000"},{"v":120000,"d":"$120,000"},{"v":90000,"d":"$90,000"},"January",{"$f":"(C11+4*D11+E11)/6","v":{"v":120000,"d":"$120,000"}}]
["Adventure Works","Products",{"v":145200,"d":"$145,200"},{"v":122000,"d":"$122,000"},{"v":89000,"d":"$89,000"},"February",{"$f":"(C12+4*D12+E12)/6","v":{"v":120366.66666666667,"d":"$120,367"}}]
["Alpine Ski House","Training",{"v":162500,"d":"$162,500"},{"v":120000,"d":"$120,000"},{"v":84000,"d":"$84,000"},"March",{"v":121083.33333333333,"d":"$121,083"}]
["Baldwin Museum of Science","Mixture",{"v":147500,"d":"$147,500"},{"v":125000,"d":"$125,000"},{"v":99000,"d":"$99,000"},"April",{"v":124416.66666666667,"d":"$124,417"}]
["Blue Yonder Airlines","Prof. services",{"v":148000,"d":"$148,000"},{"v":140000,"d":"$140,000"},{"v":132000,"d":"$132,000"},"May",{"v":140000,"d":"$140,000"}]
["City Power & Light","Support",{"v":175000,"d":"$175,000"},{"v":150000,"d":"$150,000"},{"v":125000,"d":"$125,000"},"June",{"v":150000,"d":"$150,000"}]
["Coho Vineyard","Mixture",{"v":149000,"d":"$149,000"},{"v":125000,"d":"$125,000"},{"v":101000,"d":"$101,000"},"July",{"v":125000,"d":"$125,000"}]
["Coho Winery","Training",{"v":142000,"d":"$142,000"},{"v":131000,"d":"$131,000"},{"v":119000,"d":"$119,000"},"August",{"v":130833.33333333333,"d":"$130,833"}]
["Coho Vineyard & Winery","Consulting",{"v":189900,"d":"$189,900"},{"v":175000,"d":"$175,000"},{"v":145000,"d":"$145,000"},"September",{"v":172483.33333333334,"d":"$172,483"}]
["Contoso, Ltd.","Mixture",{"v":172500,"d":"$172,500"},{"v":156000,"d":"$156,000"},{"v":142000,"d":"$142,000"},"October",{"v":156416.66666666666,"d":"$156,417"}]
["Contoso Pharmaceuticals","Products",{"v":163500,"d":"$163,500"},{"v":146000,"d":"$146,000"},{"v":123000,"d":"$123,000"},"November",{"v":145083.33333333334,"d":"$145,083"}]
["Consolidated Messenger","Products",{"v":155500,"d":"$155,500"},{"v":150000,"d":"$150,000"},{"v":141000,"d":"$141,000"},"December",{"v":149416.66666666666,"d":"$149,417"}]
["Fabrikam, Inc.","Consulting",{"v":166000,"d":"$166,000"},{"v":133000,"d":"$133,000"},{"v":112000,"d":"$112,000"},"January",{"v":135000,"d":"$135,000"}]
["Fourth Coffee","Training",{"v":180000,"d":"$180,000"},{"v":170000,"d":"$170,000"},{"v":160000,"d":"$160,000"},"March",{"v":170000,"d":"$170,000"}]
["Graphic Design Institute","Services",{"v":140000,"d":"$140,000"},{"v":120000,"d":"$120,000"},{"v":100000,"d":"$100,000"},"May",{"v":120000,"d":"$120,000"}]
["Humongous Insurance","Support",{"v":155000,"d":"$155,000"},{"v":135000,"d":"$135,000"},{"v":115000,"d":"$115,000"},"June",{"v":135000,"d":"$135,000"}]
["Litware, Inc.","Prof. services",{"v":173200,"d":"$173,200"},{"v":168500,"d":"$168,500"},{"v":161900,"d":"$161,900"},"October",{"v":168183.33333333334,"d":"$168,183"}]
["Lucerne Publishing","Services",{"v":146500,"d":"$146,500"},{"v":142400,"d":"$142,400"},{"v":137500,"d":"$137,500"},"December",{"v":142266.66666666666,"d":"$142,267"}]
["Margie's Travel","Support",{"v":156750,"d":"$156,750"},{"v":152500,"d":"$152,500"},{"v":145200,"d":"$145,200"},"November",{"v":151991.66666666666,"d":"$151,992"}]
["Northwind Traders","Prof. services",{"v":162000,"d":"$162,000"},{"v":142000,"d":"$142,000"},{"v":122000,"d":"$122,000"},"February",{"v":142000,"d":"$142,000"}]
["Proseware, Inc.","Mixture",{"v":157000,"d":"$157,000"},{"v":143000,"d":"$143,000"},{"v":127000,"d":"$127,000"},"March",{"v":142666.66666666666,"d":"$142,667"}]
["School of Fine Art","Services",{"v":173000,"d":"$173,000"},{"v":165000,"d":"$165,000"},{"v":154000,"d":"$154,000"},"April",{"v":164500,"d":"$164,500"}]
["Southridge Video","Mixture",{"v":171000,"d":"$171,000"},{"v":161000,"d":"$161,000"},{"v":151000,"d":"$151,000"},"August",{"v":161000,"d":"$161,000"}]
["Tailspin Toys","Products",{"v":168000,"d":"$168,000"},{"v":146000,"d":"$146,000"},{"v":129000,"d":"$129,000"},"September",{"v":146833.33333333334,"d":"$146,833"}]
["Total",null,{"$f":"SUBTOTAL(109,[Optimistic\nforecast])","v":{"v":3849050,"d":"$3,849,050"}},{"$f":"SUBTOTAL(109,[Most likely\nforecast])","v":{"v":3438400,"d":"$3,438,400"}},{"$f":"SUBTOTAL(109,[Pessimistic\nforecast])","v":{"v":3004600,"d":"$3,004,600"}},null,{"$f":"SUBTOTAL(109,[Mean\nforecast])","v":{"v":3434541.6666666665,"d":"$3,434,542"}}]

{"sheet":"Optimistic Revenue","index":1,"n_rows":33,"n_cols":12,"rows_kept":33,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3]]}
[{"$f":"'Revenue Input'!A1","v":"[Company Name] "}]
["Optimistic Revenue Forecast"]
["[Company Name] Confidential"]
["[Date]"]
[]
["These cells are calculated for you, and they generally should not be altered."]
["Jul-16","Aug-16","Sep-16","Oct-16","Nov-16","Dec-16","Jan-17","Feb-17","Mar-17","Apr-17","May-17","Jun-17"]
[{"$f":"IF('Revenue Input'!$F11 = \"January\",'Revenue Input'!$C11,0)","v":{"v":150000,"d":"$150,000"}},{"$f":"IF('Revenue Input'!$F11 = \"February\",'Revenue Input'!$C11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"March\",'Revenue Input'!$C11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"April\",'Revenue Input'!$C11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"May\",'Revenue Input'!$C11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"June\",'Revenue Input'!$C11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"July\",'Revenue Input'!$C11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"August\",'Revenue Input'!$C11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"September\",'Revenue Input'!$C11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"October\",'Revenue Input'!$C11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"November\",'Revenue Input'!$C11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"December\",'Revenue Input'!$C11,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F12 = \"January\",'Revenue Input'!$C12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"February\",'Revenue Input'!$C12,0)","v":{"v":145200,"d":"$145,200"}},{"$f":"IF('Revenue Input'!$F12 = \"March\",'Revenue Input'!$C12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"April\",'Revenue Input'!$C12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"May\",'Revenue Input'!$C12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"June\",'Revenue Input'!$C12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"July\",'Revenue Input'!$C12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"August\",'Revenue Input'!$C12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"September\",'Revenue Input'!$C12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"October\",'Revenue Input'!$C12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"November\",'Revenue Input'!$C12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"December\",'Revenue Input'!$C12,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F13 = \"January\",'Revenue Input'!$C13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"February\",'Revenue Input'!$C13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"March\",'Revenue Input'!$C13,0)","v":{"v":162500,"d":"$162,500"}},{"$f":"IF('Revenue Input'!$F13 = \"April\",'Revenue Input'!$C13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"May\",'Revenue Input'!$C13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"June\",'Revenue Input'!$C13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"July\",'Revenue Input'!$C13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"August\",'Revenue Input'!$C13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"September\",'Revenue Input'!$C13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"October\",'Revenue Input'!$C13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"November\",'Revenue Input'!$C13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"December\",'Revenue Input'!$C13,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F14 = \"January\",'Revenue Input'!$C14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"February\",'Revenue Input'!$C14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"March\",'Revenue Input'!$C14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"April\",'Revenue Input'!$C14,0)","v":{"v":147500,"d":"$147,500"}},{"$f":"IF('Revenue Input'!$F14 = \"May\",'Revenue Input'!$C14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"June\",'Revenue Input'!$C14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"July\",'Revenue Input'!$C14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"August\",'Revenue Input'!$C14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"September\",'Revenue Input'!$C14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"October\",'Revenue Input'!$C14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"November\",'Revenue Input'!$C14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"December\",'Revenue Input'!$C14,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F15 = \"January\",'Revenue Input'!$C15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"February\",'Revenue Input'!$C15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"March\",'Revenue Input'!$C15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"April\",'Revenue Input'!$C15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"May\",'Revenue Input'!$C15,0)","v":{"v":148000,"d":"$148,000"}},{"$f":"IF('Revenue Input'!$F15 = \"June\",'Revenue Input'!$C15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"July\",'Revenue Input'!$C15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"August\",'Revenue Input'!$C15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"September\",'Revenue Input'!$C15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"October\",'Revenue Input'!$C15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"November\",'Revenue Input'!$C15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"December\",'Revenue Input'!$C15,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F16 = \"January\",'Revenue Input'!$C16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"February\",'Revenue Input'!$C16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"March\",'Revenue Input'!$C16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"April\",'Revenue Input'!$C16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"May\",'Revenue Input'!$C16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"June\",'Revenue Input'!$C16,0)","v":{"v":175000,"d":"$175,000"}},{"$f":"IF('Revenue Input'!$F16 = \"July\",'Revenue Input'!$C16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"August\",'Revenue Input'!$C16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"September\",'Revenue Input'!$C16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"October\",'Revenue Input'!$C16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"November\",'Revenue Input'!$C16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"December\",'Revenue Input'!$C16,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F17 = \"January\",'Revenue Input'!$C17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"February\",'Revenue Input'!$C17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"March\",'Revenue Input'!$C17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"April\",'Revenue Input'!$C17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"May\",'Revenue Input'!$C17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"June\",'Revenue Input'!$C17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"July\",'Revenue Input'!$C17,0)","v":{"v":149000,"d":"$149,000"}},{"$f":"IF('Revenue Input'!$F17 = \"August\",'Revenue Input'!$C17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"September\",'Revenue Input'!$C17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"October\",'Revenue Input'!$C17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"November\",'Revenue Input'!$C17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"December\",'Revenue Input'!$C17,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F18 = \"January\",'Revenue Input'!$C18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"February\",'Revenue Input'!$C18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"March\",'Revenue Input'!$C18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"April\",'Revenue Input'!$C18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"May\",'Revenue Input'!$C18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"June\",'Revenue Input'!$C18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"July\",'Revenue Input'!$C18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"August\",'Revenue Input'!$C18,0)","v":{"v":142000,"d":"$142,000"}},{"$f":"IF('Revenue Input'!$F18 = \"September\",'Revenue Input'!$C18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"October\",'Revenue Input'!$C18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"November\",'Revenue Input'!$C18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"December\",'Revenue Input'!$C18,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F19 = \"January\",'Revenue Input'!$C19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"February\",'Revenue Input'!$C19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"March\",'Revenue Input'!$C19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"April\",'Revenue Input'!$C19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"May\",'Revenue Input'!$C19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"June\",'Revenue Input'!$C19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"July\",'Revenue Input'!$C19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"August\",'Revenue Input'!$C19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"September\",'Revenue Input'!$C19,0)","v":{"v":189900,"d":"$189,900"}},{"$f":"IF('Revenue Input'!$F19 = \"October\",'Revenue Input'!$C19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"November\",'Revenue Input'!$C19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"December\",'Revenue Input'!$C19,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F20 = \"January\",'Revenue Input'!$C20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"February\",'Revenue Input'!$C20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"March\",'Revenue Input'!$C20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"April\",'Revenue Input'!$C20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"May\",'Revenue Input'!$C20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"June\",'Revenue Input'!$C20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"July\",'Revenue Input'!$C20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"August\",'Revenue Input'!$C20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"September\",'Revenue Input'!$C20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"October\",'Revenue Input'!$C20,0)","v":{"v":172500,"d":"$172,500"}},{"$f":"IF('Revenue Input'!$F20 = \"November\",'Revenue Input'!$C20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"December\",'Revenue Input'!$C20,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F21 = \"January\",'Revenue Input'!$C21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"February\",'Revenue Input'!$C21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"March\",'Revenue Input'!$C21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"April\",'Revenue Input'!$C21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"May\",'Revenue Input'!$C21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"June\",'Revenue Input'!$C21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"July\",'Revenue Input'!$C21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"August\",'Revenue Input'!$C21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"September\",'Revenue Input'!$C21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"October\",'Revenue Input'!$C21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"November\",'Revenue Input'!$C21,0)","v":{"v":163500,"d":"$163,500"}},{"$f":"IF('Revenue Input'!$F21 = \"December\",'Revenue Input'!$C21,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F22 = \"January\",'Revenue Input'!$C22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"February\",'Revenue Input'!$C22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"March\",'Revenue Input'!$C22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"April\",'Revenue Input'!$C22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"May\",'Revenue Input'!$C22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"June\",'Revenue Input'!$C22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"July\",'Revenue Input'!$C22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"August\",'Revenue Input'!$C22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"September\",'Revenue Input'!$C22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"October\",'Revenue Input'!$C22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"November\",'Revenue Input'!$C22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"December\",'Revenue Input'!$C22,0)","v":{"v":155500,"d":"$155,500"}}]
[{"$f":"IF('Revenue Input'!$F23 = \"January\",'Revenue Input'!$C23,0)","v":{"v":166000,"d":"$166,000"}},{"$f":"IF('Revenue Input'!$F23 = \"February\",'Revenue Input'!$C23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"March\",'Revenue Input'!$C23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"April\",'Revenue Input'!$C23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"May\",'Revenue Input'!$C23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"June\",'Revenue Input'!$C23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"July\",'Revenue Input'!$C23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"August\",'Revenue Input'!$C23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"September\",'Revenue Input'!$C23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"October\",'Revenue Input'!$C23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"November\",'Revenue Input'!$C23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"December\",'Revenue Input'!$C23,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F24 = \"January\",'Revenue Input'!$C24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"February\",'Revenue Input'!$C24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"March\",'Revenue Input'!$C24,0)","v":{"v":180000,"d":"$180,000"}},{"$f":"IF('Revenue Input'!$F24 = \"April\",'Revenue Input'!$C24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"May\",'Revenue Input'!$C24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"June\",'Revenue Input'!$C24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"July\",'Revenue Input'!$C24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"August\",'Revenue Input'!$C24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"September\",'Revenue Input'!$C24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"October\",'Revenue Input'!$C24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"November\",'Revenue Input'!$C24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"December\",'Revenue Input'!$C24,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F25 = \"January\",'Revenue Input'!$C25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"February\",'Revenue Input'!$C25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"March\",'Revenue Input'!$C25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"April\",'Revenue Input'!$C25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"May\",'Revenue Input'!$C25,0)","v":{"v":140000,"d":"$140,000"}},{"$f":"IF('Revenue Input'!$F25 = \"June\",'Revenue Input'!$C25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"July\",'Revenue Input'!$C25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"August\",'Revenue Input'!$C25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"September\",'Revenue Input'!$C25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"October\",'Revenue Input'!$C25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"November\",'Revenue Input'!$C25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"December\",'Revenue Input'!$C25,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F26 = \"January\",'Revenue Input'!$C26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"February\",'Revenue Input'!$C26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"March\",'Revenue Input'!$C26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"April\",'Revenue Input'!$C26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"May\",'Revenue Input'!$C26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"June\",'Revenue Input'!$C26,0)","v":{"v":155000,"d":"$155,000"}},{"$f":"IF('Revenue Input'!$F26 = \"July\",'Revenue Input'!$C26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"August\",'Revenue Input'!$C26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"September\",'Revenue Input'!$C26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"October\",'Revenue Input'!$C26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"November\",'Revenue Input'!$C26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"December\",'Revenue Input'!$C26,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F27 = \"January\",'Revenue Input'!$C27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"February\",'Revenue Input'!$C27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"March\",'Revenue Input'!$C27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"April\",'Revenue Input'!$C27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"May\",'Revenue Input'!$C27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"June\",'Revenue Input'!$C27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"July\",'Revenue Input'!$C27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"August\",'Revenue Input'!$C27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"September\",'Revenue Input'!$C27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"October\",'Revenue Input'!$C27,0)","v":{"v":173200,"d":"$173,200"}},{"$f":"IF('Revenue Input'!$F27 = \"November\",'Revenue Input'!$C27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"December\",'Revenue Input'!$C27,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F28 = \"January\",'Revenue Input'!$C28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"February\",'Revenue Input'!$C28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"March\",'Revenue Input'!$C28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"April\",'Revenue Input'!$C28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"May\",'Revenue Input'!$C28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"June\",'Revenue Input'!$C28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"July\",'Revenue Input'!$C28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"August\",'Revenue Input'!$C28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"September\",'Revenue Input'!$C28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"October\",'Revenue Input'!$C28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"November\",'Revenue Input'!$C28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"December\",'Revenue Input'!$C28,0)","v":{"v":146500,"d":"$146,500"}}]
[{"$f":"IF('Revenue Input'!$F29 = \"January\",'Revenue Input'!$C29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"February\",'Revenue Input'!$C29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"March\",'Revenue Input'!$C29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"April\",'Revenue Input'!$C29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"May\",'Revenue Input'!$C29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"June\",'Revenue Input'!$C29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"July\",'Revenue Input'!$C29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"August\",'Revenue Input'!$C29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"September\",'Revenue Input'!$C29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"October\",'Revenue Input'!$C29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"November\",'Revenue Input'!$C29,0)","v":{"v":156750,"d":"$156,750"}},{"$f":"IF('Revenue Input'!$F29 = \"December\",'Revenue Input'!$C29,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F30 = \"January\",'Revenue Input'!$C30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"February\",'Revenue Input'!$C30,0)","v":{"v":162000,"d":"$162,000"}},{"$f":"IF('Revenue Input'!$F30 = \"March\",'Revenue Input'!$C30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"April\",'Revenue Input'!$C30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"May\",'Revenue Input'!$C30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"June\",'Revenue Input'!$C30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"July\",'Revenue Input'!$C30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"August\",'Revenue Input'!$C30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"September\",'Revenue Input'!$C30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"October\",'Revenue Input'!$C30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"November\",'Revenue Input'!$C30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"December\",'Revenue Input'!$C30,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F31 = \"January\",'Revenue Input'!$C31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"February\",'Revenue Input'!$C31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"March\",'Revenue Input'!$C31,0)","v":{"v":157000,"d":"$157,000"}},{"$f":"IF('Revenue Input'!$F31 = \"April\",'Revenue Input'!$C31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"May\",'Revenue Input'!$C31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"June\",'Revenue Input'!$C31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"July\",'Revenue Input'!$C31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"August\",'Revenue Input'!$C31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"September\",'Revenue Input'!$C31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"October\",'Revenue Input'!$C31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"November\",'Revenue Input'!$C31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"December\",'Revenue Input'!$C31,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F32 = \"January\",'Revenue Input'!$C32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"February\",'Revenue Input'!$C32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"March\",'Revenue Input'!$C32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"April\",'Revenue Input'!$C32,0)","v":{"v":173000,"d":"$173,000"}},{"$f":"IF('Revenue Input'!$F32 = \"May\",'Revenue Input'!$C32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"June\",'Revenue Input'!$C32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"July\",'Revenue Input'!$C32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"August\",'Revenue Input'!$C32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"September\",'Revenue Input'!$C32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"October\",'Revenue Input'!$C32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"November\",'Revenue Input'!$C32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"December\",'Revenue Input'!$C32,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F33 = \"January\",'Revenue Input'!$C33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"February\",'Revenue Input'!$C33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"March\",'Revenue Input'!$C33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"April\",'Revenue Input'!$C33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"May\",'Revenue Input'!$C33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"June\",'Revenue Input'!$C33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"July\",'Revenue Input'!$C33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"August\",'Revenue Input'!$C33,0)","v":{"v":171000,"d":"$171,000"}},{"$f":"IF('Revenue Input'!$F33 = \"September\",'Revenue Input'!$C33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"October\",'Revenue Input'!$C33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"November\",'Revenue Input'!$C33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"December\",'Revenue Input'!$C33,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F34 = \"January\",'Revenue Input'!$C34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"February\",'Revenue Input'!$C34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"March\",'Revenue Input'!$C34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"April\",'Revenue Input'!$C34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"May\",'Revenue Input'!$C34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"June\",'Revenue Input'!$C34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"July\",'Revenue Input'!$C34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"August\",'Revenue Input'!$C34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"September\",'Revenue Input'!$C34,0)","v":{"v":168000,"d":"$168,000"}},{"$f":"IF('Revenue Input'!$F34 = \"October\",'Revenue Input'!$C34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"November\",'Revenue Input'!$C34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"December\",'Revenue Input'!$C34,0)","v":0}]
[{"$f":"SUBTOTAL(109,[Jul-16])","v":{"v":316000,"d":"$316,000"}},{"$f":"SUBTOTAL(109,[Aug-16])","v":{"v":307200,"d":"$307,200"}},{"$f":"SUBTOTAL(109,[Sep-16])","v":{"v":499500,"d":"$499,500"}},{"$f":"SUBTOTAL(109,[Oct-16])","v":{"v":320500,"d":"$320,500"}},{"$f":"SUBTOTAL(109,[Nov-16])","v":{"v":288000,"d":"$288,000"}},{"$f":"SUBTOTAL(109,[Dec-16])","v":{"v":330000,"d":"$330,000"}},{"$f":"SUBTOTAL(109,[Jan-17])","v":{"v":149000,"d":"$149,000"}},{"$f":"SUBTOTAL(109,[Feb-17])","v":{"v":313000,"d":"$313,000"}},{"$f":"SUBTOTAL(109,[Mar-17])","v":{"v":357900,"d":"$357,900"}},{"$f":"SUBTOTAL(109,[Apr-17])","v":{"v":345700,"d":"$345,700"}},{"$f":"SUBTOTAL(109,[May-17])","v":{"v":320250,"d":"$320,250"}},{"$f":"SUBTOTAL(109,[Jun-17])","v":{"v":302000,"d":"$302,000"}}]
["Running Totals",{"$f":"A32+B32","v":{"v":623200,"d":"$623,200"}},{"$f":"B33+C32","v":{"v":1122700,"d":"$1,122,700"}},{"v":1443200,"d":"$1,443,200"},{"v":1731200,"d":"$1,731,200"},{"v":2061200,"d":"$2,061,200"},{"v":2210200,"d":"$2,210,200"},{"v":2523200,"d":"$2,523,200"},{"v":2881100,"d":"$2,881,100"},{"v":3226800,"d":"$3,226,800"},{"v":3547050,"d":"$3,547,050"},{"v":3849050,"d":"$3,849,050"}]

{"sheet":"Most Likely Revenue","index":2,"n_rows":33,"n_cols":12,"rows_kept":33,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3]]}
[{"$f":"'Revenue Input'!A1","v":"[Company Name] "}]
["Most Likely Revenue Forecast"]
["[Company Name] Confidential"]
["[Date]"]
[]
["These cells are calculated for you, and they generally should not be altered."]
["Jul-16","Aug-16","Sep-16","Oct-16","Nov-16","Dec-16","Jan-17","Feb-17","Mar-17","Apr-17","May-17","Jun-17"]
[{"$f":"IF('Revenue Input'!$F11 = \"January\",'Revenue Input'!$D11,0)","v":{"v":120000,"d":"$120,000"}},{"$f":"IF('Revenue Input'!$F11 = \"February\",'Revenue Input'!$D11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"March\",'Revenue Input'!$D11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"April\",'Revenue Input'!$D11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"May\",'Revenue Input'!$D11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"June\",'Revenue Input'!$D11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"July\",'Revenue Input'!$D11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"August\",'Revenue Input'!$D11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"September\",'Revenue Input'!$D11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"October\",'Revenue Input'!$D11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"November\",'Revenue Input'!$D11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"December\",'Revenue Input'!$D11,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F12 = \"January\",'Revenue Input'!$D12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"February\",'Revenue Input'!$D12,0)","v":{"v":122000,"d":"$122,000"}},{"$f":"IF('Revenue Input'!$F12 = \"March\",'Revenue Input'!$D12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"April\",'Revenue Input'!$D12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"May\",'Revenue Input'!$D12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"June\",'Revenue Input'!$D12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"July\",'Revenue Input'!$D12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"August\",'Revenue Input'!$D12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"September\",'Revenue Input'!$D12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"October\",'Revenue Input'!$D12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"November\",'Revenue Input'!$D12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"December\",'Revenue Input'!$D12,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F13 = \"January\",'Revenue Input'!$D13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"February\",'Revenue Input'!$D13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"March\",'Revenue Input'!$D13,0)","v":{"v":120000,"d":"$120,000"}},{"$f":"IF('Revenue Input'!$F13 = \"April\",'Revenue Input'!$D13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"May\",'Revenue Input'!$D13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"June\",'Revenue Input'!$D13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"July\",'Revenue Input'!$D13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"August\",'Revenue Input'!$D13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"September\",'Revenue Input'!$D13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"October\",'Revenue Input'!$D13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"November\",'Revenue Input'!$D13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"December\",'Revenue Input'!$D13,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F14 = \"January\",'Revenue Input'!$D14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"February\",'Revenue Input'!$D14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"March\",'Revenue Input'!$D14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"April\",'Revenue Input'!$D14,0)","v":{"v":125000,"d":"$125,000"}},{"$f":"IF('Revenue Input'!$F14 = \"May\",'Revenue Input'!$D14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"June\",'Revenue Input'!$D14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"July\",'Revenue Input'!$D14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"August\",'Revenue Input'!$D14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"September\",'Revenue Input'!$D14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"October\",'Revenue Input'!$D14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"November\",'Revenue Input'!$D14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"December\",'Revenue Input'!$D14,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F15 = \"January\",'Revenue Input'!$D15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"February\",'Revenue Input'!$D15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"March\",'Revenue Input'!$D15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"April\",'Revenue Input'!$D15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"May\",'Revenue Input'!$D15,0)","v":{"v":140000,"d":"$140,000"}},{"$f":"IF('Revenue Input'!$F15 = \"June\",'Revenue Input'!$D15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"July\",'Revenue Input'!$D15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"August\",'Revenue Input'!$D15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"September\",'Revenue Input'!$D15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"October\",'Revenue Input'!$D15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"November\",'Revenue Input'!$D15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"December\",'Revenue Input'!$D15,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F16 = \"January\",'Revenue Input'!$D16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"February\",'Revenue Input'!$D16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"March\",'Revenue Input'!$D16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"April\",'Revenue Input'!$D16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"May\",'Revenue Input'!$D16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"June\",'Revenue Input'!$D16,0)","v":{"v":150000,"d":"$150,000"}},{"$f":"IF('Revenue Input'!$F16 = \"July\",'Revenue Input'!$D16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"August\",'Revenue Input'!$D16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"September\",'Revenue Input'!$D16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"October\",'Revenue Input'!$D16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"November\",'Revenue Input'!$D16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"December\",'Revenue Input'!$D16,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F17 = \"January\",'Revenue Input'!$D17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"February\",'Revenue Input'!$D17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"March\",'Revenue Input'!$D17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"April\",'Revenue Input'!$D17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"May\",'Revenue Input'!$D17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"June\",'Revenue Input'!$D17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"July\",'Revenue Input'!$D17,0)","v":{"v":125000,"d":"$125,000"}},{"$f":"IF('Revenue Input'!$F17 = \"August\",'Revenue Input'!$D17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"September\",'Revenue Input'!$D17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"October\",'Revenue Input'!$D17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"November\",'Revenue Input'!$D17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"December\",'Revenue Input'!$D17,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F18 = \"January\",'Revenue Input'!$D18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"February\",'Revenue Input'!$D18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"March\",'Revenue Input'!$D18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"April\",'Revenue Input'!$D18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"May\",'Revenue Input'!$D18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"June\",'Revenue Input'!$D18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"July\",'Revenue Input'!$D18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"August\",'Revenue Input'!$D18,0)","v":{"v":131000,"d":"$131,000"}},{"$f":"IF('Revenue Input'!$F18 = \"September\",'Revenue Input'!$D18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"October\",'Revenue Input'!$D18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"November\",'Revenue Input'!$D18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"December\",'Revenue Input'!$D18,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F19 = \"January\",'Revenue Input'!$D19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"February\",'Revenue Input'!$D19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"March\",'Revenue Input'!$D19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"April\",'Revenue Input'!$D19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"May\",'Revenue Input'!$D19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"June\",'Revenue Input'!$D19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"July\",'Revenue Input'!$D19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"August\",'Revenue Input'!$D19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"September\",'Revenue Input'!$D19,0)","v":{"v":175000,"d":"$175,000"}},{"$f":"IF('Revenue Input'!$F19 = \"October\",'Revenue Input'!$D19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"November\",'Revenue Input'!$D19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"December\",'Revenue Input'!$D19,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F20 = \"January\",'Revenue Input'!$D20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"February\",'Revenue Input'!$D20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"March\",'Revenue Input'!$D20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"April\",'Revenue Input'!$D20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"May\",'Revenue Input'!$D20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"June\",'Revenue Input'!$D20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"July\",'Revenue Input'!$D20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"August\",'Revenue Input'!$D20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"September\",'Revenue Input'!$D20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"October\",'Revenue Input'!$D20,0)","v":{"v":156000,"d":"$156,000"}},{"$f":"IF('Revenue Input'!$F20 = \"November\",'Revenue Input'!$D20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"December\",'Revenue Input'!$D20,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F21 = \"January\",'Revenue Input'!$D21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"February\",'Revenue Input'!$D21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"March\",'Revenue Input'!$D21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"April\",'Revenue Input'!$D21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"May\",'Revenue Input'!$D21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"June\",'Revenue Input'!$D21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"July\",'Revenue Input'!$D21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"August\",'Revenue Input'!$D21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"September\",'Revenue Input'!$D21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"October\",'Revenue Input'!$D21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"November\",'Revenue Input'!$D21,0)","v":{"v":146000,"d":"$146,000"}},{"$f":"IF('Revenue Input'!$F21 = \"December\",'Revenue Input'!$D21,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F22 = \"January\",'Revenue Input'!$D22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"February\",'Revenue Input'!$D22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"March\",'Revenue Input'!$D22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"April\",'Revenue Input'!$D22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"May\",'Revenue Input'!$D22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"June\",'Revenue Input'!$D22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"July\",'Revenue Input'!$D22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"August\",'Revenue Input'!$D22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"September\",'Revenue Input'!$D22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"October\",'Revenue Input'!$D22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"November\",'Revenue Input'!$D22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"December\",'Revenue Input'!$D22,0)","v":{"v":150000,"d":"$150,000"}}]
[{"$f":"IF('Revenue Input'!$F23 = \"January\",'Revenue Input'!$D23,0)","v":{"v":133000,"d":"$133,000"}},{"$f":"IF('Revenue Input'!$F23 = \"February\",'Revenue Input'!$D23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"March\",'Revenue Input'!$D23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"April\",'Revenue Input'!$D23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"May\",'Revenue Input'!$D23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"June\",'Revenue Input'!$D23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"July\",'Revenue Input'!$D23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"August\",'Revenue Input'!$D23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"September\",'Revenue Input'!$D23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"October\",'Revenue Input'!$D23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"November\",'Revenue Input'!$D23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"December\",'Revenue Input'!$D23,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F24 = \"January\",'Revenue Input'!$D24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"February\",'Revenue Input'!$D24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"March\",'Revenue Input'!$D24,0)","v":{"v":170000,"d":"$170,000"}},{"$f":"IF('Revenue Input'!$F24 = \"April\",'Revenue Input'!$D24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"May\",'Revenue Input'!$D24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"June\",'Revenue Input'!$D24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"July\",'Revenue Input'!$D24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"August\",'Revenue Input'!$D24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"September\",'Revenue Input'!$D24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"October\",'Revenue Input'!$D24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"November\",'Revenue Input'!$D24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"December\",'Revenue Input'!$D24,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F25 = \"January\",'Revenue Input'!$D25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"February\",'Revenue Input'!$D25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"March\",'Revenue Input'!$D25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"April\",'Revenue Input'!$D25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"May\",'Revenue Input'!$D25,0)","v":{"v":120000,"d":"$120,000"}},{"$f":"IF('Revenue Input'!$F25 = \"June\",'Revenue Input'!$D25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"July\",'Revenue Input'!$D25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"August\",'Revenue Input'!$D25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"September\",'Revenue Input'!$D25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"October\",'Revenue Input'!$D25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"November\",'Revenue Input'!$D25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"December\",'Revenue Input'!$D25,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F26 = \"January\",'Revenue Input'!$D26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"February\",'Revenue Input'!$D26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"March\",'Revenue Input'!$D26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"April\",'Revenue Input'!$D26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"May\",'Revenue Input'!$D26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"June\",'Revenue Input'!$D26,0)","v":{"v":135000,"d":"$135,000"}},{"$f":"IF('Revenue Input'!$F26 = \"July\",'Revenue Input'!$D26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"August\",'Revenue Input'!$D26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"September\",'Revenue Input'!$D26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"October\",'Revenue Input'!$D26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"November\",'Revenue Input'!$D26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"December\",'Revenue Input'!$D26,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F27 = \"January\",'Revenue Input'!$D27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"February\",'Revenue Input'!$D27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"March\",'Revenue Input'!$D27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"April\",'Revenue Input'!$D27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"May\",'Revenue Input'!$D27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"June\",'Revenue Input'!$D27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"July\",'Revenue Input'!$D27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"August\",'Revenue Input'!$D27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"September\",'Revenue Input'!$D27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"October\",'Revenue Input'!$D27,0)","v":{"v":168500,"d":"$168,500"}},{"$f":"IF('Revenue Input'!$F27 = \"November\",'Revenue Input'!$D27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"December\",'Revenue Input'!$D27,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F28 = \"January\",'Revenue Input'!$D28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"February\",'Revenue Input'!$D28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"March\",'Revenue Input'!$D28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"April\",'Revenue Input'!$D28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"May\",'Revenue Input'!$D28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"June\",'Revenue Input'!$D28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"July\",'Revenue Input'!$D28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"August\",'Revenue Input'!$D28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"September\",'Revenue Input'!$D28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"October\",'Revenue Input'!$D28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"November\",'Revenue Input'!$D28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"December\",'Revenue Input'!$D28,0)","v":{"v":142400,"d":"$142,400"}}]
[{"$f":"IF('Revenue Input'!$F29 = \"January\",'Revenue Input'!$D29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"February\",'Revenue Input'!$D29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"March\",'Revenue Input'!$D29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"April\",'Revenue Input'!$D29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"May\",'Revenue Input'!$D29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"June\",'Revenue Input'!$D29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"July\",'Revenue Input'!$D29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"August\",'Revenue Input'!$D29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"September\",'Revenue Input'!$D29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"October\",'Revenue Input'!$D29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"November\",'Revenue Input'!$D29,0)","v":{"v":152500,"d":"$152,500"}},{"$f":"IF('Revenue Input'!$F29 = \"December\",'Revenue Input'!$D29,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F30 = \"January\",'Revenue Input'!$D30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"February\",'Revenue Input'!$D30,0)","v":{"v":142000,"d":"$142,000"}},{"$f":"IF('Revenue Input'!$F30 = \"March\",'Revenue Input'!$D30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"April\",'Revenue Input'!$D30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"May\",'Revenue Input'!$D30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"June\",'Revenue Input'!$D30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"July\",'Revenue Input'!$D30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"August\",'Revenue Input'!$D30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"September\",'Revenue Input'!$D30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"October\",'Revenue Input'!$D30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"November\",'Revenue Input'!$D30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"December\",'Revenue Input'!$D30,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F31 = \"January\",'Revenue Input'!$D31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"February\",'Revenue Input'!$D31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"March\",'Revenue Input'!$D31,0)","v":{"v":143000,"d":"$143,000"}},{"$f":"IF('Revenue Input'!$F31 = \"April\",'Revenue Input'!$D31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"May\",'Revenue Input'!$D31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"June\",'Revenue Input'!$D31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"July\",'Revenue Input'!$D31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"August\",'Revenue Input'!$D31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"September\",'Revenue Input'!$D31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"October\",'Revenue Input'!$D31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"November\",'Revenue Input'!$D31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"December\",'Revenue Input'!$D31,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F32 = \"January\",'Revenue Input'!$D32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"February\",'Revenue Input'!$D32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"March\",'Revenue Input'!$D32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"April\",'Revenue Input'!$D32,0)","v":{"v":165000,"d":"$165,000"}},{"$f":"IF('Revenue Input'!$F32 = \"May\",'Revenue Input'!$D32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"June\",'Revenue Input'!$D32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"July\",'Revenue Input'!$D32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"August\",'Revenue Input'!$D32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"September\",'Revenue Input'!$D32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"October\",'Revenue Input'!$D32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"November\",'Revenue Input'!$D32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"December\",'Revenue Input'!$D32,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F33 = \"January\",'Revenue Input'!$D33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"February\",'Revenue Input'!$D33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"March\",'Revenue Input'!$D33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"April\",'Revenue Input'!$D33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"May\",'Revenue Input'!$D33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"June\",'Revenue Input'!$D33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"July\",'Revenue Input'!$D33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"August\",'Revenue Input'!$D33,0)","v":{"v":161000,"d":"$161,000"}},{"$f":"IF('Revenue Input'!$F33 = \"September\",'Revenue Input'!$D33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"October\",'Revenue Input'!$D33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"November\",'Revenue Input'!$D33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"December\",'Revenue Input'!$D33,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F34 = \"January\",'Revenue Input'!$D34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"February\",'Revenue Input'!$D34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"March\",'Revenue Input'!$D34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"April\",'Revenue Input'!$D34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"May\",'Revenue Input'!$D34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"June\",'Revenue Input'!$D34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"July\",'Revenue Input'!$D34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"August\",'Revenue Input'!$D34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"September\",'Revenue Input'!$D34,0)","v":{"v":146000,"d":"$146,000"}},{"$f":"IF('Revenue Input'!$F34 = \"October\",'Revenue Input'!$D34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"November\",'Revenue Input'!$D34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"December\",'Revenue Input'!$D34,0)","v":0}]
[{"$f":"SUBTOTAL(109,[Jul-16])","v":{"v":253000,"d":"$253,000"}},{"$f":"SUBTOTAL(109,[Aug-16])","v":{"v":264000,"d":"$264,000"}},{"$f":"SUBTOTAL(109,[Sep-16])","v":{"v":433000,"d":"$433,000"}},{"$f":"SUBTOTAL(109,[Oct-16])","v":{"v":290000,"d":"$290,000"}},{"$f":"SUBTOTAL(109,[Nov-16])","v":{"v":260000,"d":"$260,000"}},{"$f":"SUBTOTAL(109,[Dec-16])","v":{"v":285000,"d":"$285,000"}},{"$f":"SUBTOTAL(109,[Jan-17])","v":{"v":125000,"d":"$125,000"}},{"$f":"SUBTOTAL(109,[Feb-17])","v":{"v":292000,"d":"$292,000"}},{"$f":"SUBTOTAL(109,[Mar-17])","v":{"v":321000,"d":"$321,000"}},{"$f":"SUBTOTAL(109,[Apr-17])","v":{"v":324500,"d":"$324,500"}},{"$f":"SUBTOTAL(109,[May-17])","v":{"v":298500,"d":"$298,500"}},{"$f":"SUBTOTAL(109,[Jun-17])","v":{"v":292400,"d":"$292,400"}}]
["Running Totals",{"$f":"A32+B32","v":{"v":517000,"d":"$517,000"}},{"$f":"B33+C32","v":{"v":950000,"d":"$950,000"}},{"$f":"C33+D32","v":{"v":1240000,"d":"$1,240,000"}},{"v":1500000,"d":"$1,500,000"},{"v":1785000,"d":"$1,785,000"},{"v":1910000,"d":"$1,910,000"},{"v":2202000,"d":"$2,202,000"},{"v":2523000,"d":"$2,523,000"},{"v":2847500,"d":"$2,847,500"},{"v":3146000,"d":"$3,146,000"},{"v":3438400,"d":"$3,438,400"}]

{"sheet":"Pessimistic Revenue","index":3,"n_rows":33,"n_cols":12,"rows_kept":33,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3]]}
[{"$f":"'Revenue Input'!A1","v":"[Company Name] "}]
["Pessimistic Revenue Forecast"]
["[Company Name] Confidential"]
["[Date]"]
[]
["These cells are calculated for you, and they generally should not be altered."]
["Jul-16","Aug-16","Sep-16","Oct-16","Nov-16","Dec-16","Jan-17","Feb-17","Mar-17","Apr-17","May-17","Jun-17"]
[{"$f":"IF('Revenue Input'!$F11 = \"January\",'Revenue Input'!$E11,0)","v":{"v":90000,"d":"$90,000"}},{"$f":"IF('Revenue Input'!$F11 = \"February\",'Revenue Input'!$E11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"March\",'Revenue Input'!$E11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"April\",'Revenue Input'!$E11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"May\",'Revenue Input'!$E11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"June\",'Revenue Input'!$E11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"July\",'Revenue Input'!$E11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"August\",'Revenue Input'!$E11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"September\",'Revenue Input'!$E11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"October\",'Revenue Input'!$E11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"November\",'Revenue Input'!$E11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"December\",'Revenue Input'!$E11,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F12 = \"January\",'Revenue Input'!$E12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"February\",'Revenue Input'!$E12,0)","v":{"v":89000,"d":"$89,000"}},{"$f":"IF('Revenue Input'!$F12 = \"March\",'Revenue Input'!$E12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"April\",'Revenue Input'!$E12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"May\",'Revenue Input'!$E12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"June\",'Revenue Input'!$E12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"July\",'Revenue Input'!$E12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"August\",'Revenue Input'!$E12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"September\",'Revenue Input'!$E12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"October\",'Revenue Input'!$E12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"November\",'Revenue Input'!$E12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"December\",'Revenue Input'!$E12,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F13 = \"January\",'Revenue Input'!$E13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"February\",'Revenue Input'!$E13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"March\",'Revenue Input'!$E13,0)","v":{"v":84000,"d":"$84,000"}},{"$f":"IF('Revenue Input'!$F13 = \"April\",'Revenue Input'!$E13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"May\",'Revenue Input'!$E13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"June\",'Revenue Input'!$E13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"July\",'Revenue Input'!$E13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"August\",'Revenue Input'!$E13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"September\",'Revenue Input'!$E13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"October\",'Revenue Input'!$E13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"November\",'Revenue Input'!$E13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"December\",'Revenue Input'!$E13,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F14 = \"January\",'Revenue Input'!$E14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"February\",'Revenue Input'!$E14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"March\",'Revenue Input'!$E14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"April\",'Revenue Input'!$E14,0)","v":{"v":99000,"d":"$99,000"}},{"$f":"IF('Revenue Input'!$F14 = \"May\",'Revenue Input'!$E14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"June\",'Revenue Input'!$E14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"July\",'Revenue Input'!$E14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"August\",'Revenue Input'!$E14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"September\",'Revenue Input'!$E14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"October\",'Revenue Input'!$E14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"November\",'Revenue Input'!$E14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"December\",'Revenue Input'!$E14,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F15 = \"January\",'Revenue Input'!$E15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"February\",'Revenue Input'!$E15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"March\",'Revenue Input'!$E15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"April\",'Revenue Input'!$E15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"May\",'Revenue Input'!$E15,0)","v":{"v":132000,"d":"$132,000"}},{"$f":"IF('Revenue Input'!$F15 = \"June\",'Revenue Input'!$E15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"July\",'Revenue Input'!$E15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"August\",'Revenue Input'!$E15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"September\",'Revenue Input'!$E15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"October\",'Revenue Input'!$E15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"November\",'Revenue Input'!$E15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"December\",'Revenue Input'!$E15,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F16 = \"January\",'Revenue Input'!$E16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"February\",'Revenue Input'!$E16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"March\",'Revenue Input'!$E16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"April\",'Revenue Input'!$E16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"May\",'Revenue Input'!$E16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"June\",'Revenue Input'!$E16,0)","v":{"v":125000,"d":"$125,000"}},{"$f":"IF('Revenue Input'!$F16 = \"July\",'Revenue Input'!$E16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"August\",'Revenue Input'!$E16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"September\",'Revenue Input'!$E16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"October\",'Revenue Input'!$E16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"November\",'Revenue Input'!$E16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"December\",'Revenue Input'!$E16,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F17 = \"January\",'Revenue Input'!$E17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"February\",'Revenue Input'!$E17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"March\",'Revenue Input'!$E17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"April\",'Revenue Input'!$E17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"May\",'Revenue Input'!$E17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"June\",'Revenue Input'!$E17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"July\",'Revenue Input'!$E17,0)","v":{"v":101000,"d":"$101,000"}},{"$f":"IF('Revenue Input'!$F17 = \"August\",'Revenue Input'!$E17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"September\",'Revenue Input'!$E17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"October\",'Revenue Input'!$E17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"November\",'Revenue Input'!$E17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"December\",'Revenue Input'!$E17,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F18 = \"January\",'Revenue Input'!$E18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"February\",'Revenue Input'!$E18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"March\",'Revenue Input'!$E18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"April\",'Revenue Input'!$E18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"May\",'Revenue Input'!$E18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"June\",'Revenue Input'!$E18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"July\",'Revenue Input'!$E18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"August\",'Revenue Input'!$E18,0)","v":{"v":119000,"d":"$119,000"}},{"$f":"IF('Revenue Input'!$F18 = \"September\",'Revenue Input'!$E18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"October\",'Revenue Input'!$E18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"November\",'Revenue Input'!$E18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"December\",'Revenue Input'!$E18,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F19 = \"January\",'Revenue Input'!$E19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"February\",'Revenue Input'!$E19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"March\",'Revenue Input'!$E19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"April\",'Revenue Input'!$E19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"May\",'Revenue Input'!$E19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"June\",'Revenue Input'!$E19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"July\",'Revenue Input'!$E19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"August\",'Revenue Input'!$E19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"September\",'Revenue Input'!$E19,0)","v":{"v":145000,"d":"$145,000"}},{"$f":"IF('Revenue Input'!$F19 = \"October\",'Revenue Input'!$E19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"November\",'Revenue Input'!$E19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"December\",'Revenue Input'!$E19,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F20 = \"January\",'Revenue Input'!$E20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"February\",'Revenue Input'!$E20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"March\",'Revenue Input'!$E20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"April\",'Revenue Input'!$E20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"May\",'Revenue Input'!$E20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"June\",'Revenue Input'!$E20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"July\",'Revenue Input'!$E20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"August\",'Revenue Input'!$E20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"September\",'Revenue Input'!$E20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"October\",'Revenue Input'!$E20,0)","v":{"v":142000,"d":"$142,000"}},{"$f":"IF('Revenue Input'!$F20 = \"November\",'Revenue Input'!$E20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"December\",'Revenue Input'!$E20,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F21 = \"January\",'Revenue Input'!$E21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"February\",'Revenue Input'!$E21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"March\",'Revenue Input'!$E21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"April\",'Revenue Input'!$E21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"May\",'Revenue Input'!$E21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"June\",'Revenue Input'!$E21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"July\",'Revenue Input'!$E21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"August\",'Revenue Input'!$E21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"September\",'Revenue Input'!$E21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"October\",'Revenue Input'!$E21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"November\",'Revenue Input'!$E21,0)","v":{"v":123000,"d":"$123,000"}},{"$f":"IF('Revenue Input'!$F21 = \"December\",'Revenue Input'!$E21,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F22 = \"January\",'Revenue Input'!$E22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"February\",'Revenue Input'!$E22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"March\",'Revenue Input'!$E22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"April\",'Revenue Input'!$E22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"May\",'Revenue Input'!$E22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"June\",'Revenue Input'!$E22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"July\",'Revenue Input'!$E22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"August\",'Revenue Input'!$E22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"September\",'Revenue Input'!$E22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"October\",'Revenue Input'!$E22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"November\",'Revenue Input'!$E22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"December\",'Revenue Input'!$E22,0)","v":{"v":141000,"d":"$141,000"}}]
[{"$f":"IF('Revenue Input'!$F23 = \"January\",'Revenue Input'!$E23,0)","v":{"v":112000,"d":"$112,000"}},{"$f":"IF('Revenue Input'!$F23 = \"February\",'Revenue Input'!$E23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"March\",'Revenue Input'!$E23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"April\",'Revenue Input'!$E23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"May\",'Revenue Input'!$E23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"June\",'Revenue Input'!$E23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"July\",'Revenue Input'!$E23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"August\",'Revenue Input'!$E23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"September\",'Revenue Input'!$E23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"October\",'Revenue Input'!$E23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"November\",'Revenue Input'!$E23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"December\",'Revenue Input'!$E23,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F24 = \"January\",'Revenue Input'!$E24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"February\",'Revenue Input'!$E24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"March\",'Revenue Input'!$E24,0)","v":{"v":160000,"d":"$160,000"}},{"$f":"IF('Revenue Input'!$F24 = \"April\",'Revenue Input'!$E24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"May\",'Revenue Input'!$E24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"June\",'Revenue Input'!$E24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"July\",'Revenue Input'!$E24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"August\",'Revenue Input'!$E24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"September\",'Revenue Input'!$E24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"October\",'Revenue Input'!$E24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"November\",'Revenue Input'!$E24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"December\",'Revenue Input'!$E24,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F25 = \"January\",'Revenue Input'!$E25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"February\",'Revenue Input'!$E25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"March\",'Revenue Input'!$E25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"April\",'Revenue Input'!$E25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"May\",'Revenue Input'!$E25,0)","v":{"v":100000,"d":"$100,000"}},{"$f":"IF('Revenue Input'!$F25 = \"June\",'Revenue Input'!$E25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"July\",'Revenue Input'!$E25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"August\",'Revenue Input'!$E25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"September\",'Revenue Input'!$E25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"October\",'Revenue Input'!$E25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"November\",'Revenue Input'!$E25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"December\",'Revenue Input'!$E25,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F26 = \"January\",'Revenue Input'!$E26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"February\",'Revenue Input'!$E26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"March\",'Revenue Input'!$E26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"April\",'Revenue Input'!$E26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"May\",'Revenue Input'!$E26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"June\",'Revenue Input'!$E26,0)","v":{"v":115000,"d":"$115,000"}},{"$f":"IF('Revenue Input'!$F26 = \"July\",'Revenue Input'!$E26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"August\",'Revenue Input'!$E26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"September\",'Revenue Input'!$E26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"October\",'Revenue Input'!$E26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"November\",'Revenue Input'!$E26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"December\",'Revenue Input'!$E26,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F27 = \"January\",'Revenue Input'!$E27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"February\",'Revenue Input'!$E27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"March\",'Revenue Input'!$E27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"April\",'Revenue Input'!$E27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"May\",'Revenue Input'!$E27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"June\",'Revenue Input'!$E27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"July\",'Revenue Input'!$E27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"August\",'Revenue Input'!$E27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"September\",'Revenue Input'!$E27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"October\",'Revenue Input'!$E27,0)","v":{"v":161900,"d":"$161,900"}},{"$f":"IF('Revenue Input'!$F27 = \"November\",'Revenue Input'!$E27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"December\",'Revenue Input'!$E27,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F28 = \"January\",'Revenue Input'!$E28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"February\",'Revenue Input'!$E28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"March\",'Revenue Input'!$E28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"April\",'Revenue Input'!$E28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"May\",'Revenue Input'!$E28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"June\",'Revenue Input'!$E28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"July\",'Revenue Input'!$E28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"August\",'Revenue Input'!$E28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"September\",'Revenue Input'!$E28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"October\",'Revenue Input'!$E28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"November\",'Revenue Input'!$E28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"December\",'Revenue Input'!$E28,0)","v":{"v":137500,"d":"$137,500"}}]
[{"$f":"IF('Revenue Input'!$F29 = \"January\",'Revenue Input'!$E29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"February\",'Revenue Input'!$E29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"March\",'Revenue Input'!$E29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"April\",'Revenue Input'!$E29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"May\",'Revenue Input'!$E29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"June\",'Revenue Input'!$E29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"July\",'Revenue Input'!$E29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"August\",'Revenue Input'!$E29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"September\",'Revenue Input'!$E29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"October\",'Revenue Input'!$E29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"November\",'Revenue Input'!$E29,0)","v":{"v":145200,"d":"$145,200"}},{"$f":"IF('Revenue Input'!$F29 = \"December\",'Revenue Input'!$E29,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F30 = \"January\",'Revenue Input'!$E30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"February\",'Revenue Input'!$E30,0)","v":{"v":122000,"d":"$122,000"}},{"$f":"IF('Revenue Input'!$F30 = \"March\",'Revenue Input'!$E30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"April\",'Revenue Input'!$E30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"May\",'Revenue Input'!$E30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"June\",'Revenue Input'!$E30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"July\",'Revenue Input'!$E30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"August\",'Revenue Input'!$E30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"September\",'Revenue Input'!$E30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"October\",'Revenue Input'!$E30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"November\",'Revenue Input'!$E30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"December\",'Revenue Input'!$E30,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F31 = \"January\",'Revenue Input'!$E31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"February\",'Revenue Input'!$E31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"March\",'Revenue Input'!$E31,0)","v":{"v":127000,"d":"$127,000"}},{"$f":"IF('Revenue Input'!$F31 = \"April\",'Revenue Input'!$E31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"May\",'Revenue Input'!$E31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"June\",'Revenue Input'!$E31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"July\",'Revenue Input'!$E31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"August\",'Revenue Input'!$E31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"September\",'Revenue Input'!$E31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"October\",'Revenue Input'!$E31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"November\",'Revenue Input'!$E31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"December\",'Revenue Input'!$E31,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F32 = \"January\",'Revenue Input'!$E32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"February\",'Revenue Input'!$E32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"March\",'Revenue Input'!$E32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"April\",'Revenue Input'!$E32,0)","v":{"v":154000,"d":"$154,000"}},{"$f":"IF('Revenue Input'!$F32 = \"May\",'Revenue Input'!$E32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"June\",'Revenue Input'!$E32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"July\",'Revenue Input'!$E32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"August\",'Revenue Input'!$E32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"September\",'Revenue Input'!$E32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"October\",'Revenue Input'!$E32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"November\",'Revenue Input'!$E32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"December\",'Revenue Input'!$E32,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F33 = \"January\",'Revenue Input'!$E33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"February\",'Revenue Input'!$E33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"March\",'Revenue Input'!$E33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"April\",'Revenue Input'!$E33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"May\",'Revenue Input'!$E33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"June\",'Revenue Input'!$E33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"July\",'Revenue Input'!$E33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"August\",'Revenue Input'!$E33,0)","v":{"v":151000,"d":"$151,000"}},{"$f":"IF('Revenue Input'!$F33 = \"September\",'Revenue Input'!$E33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"October\",'Revenue Input'!$E33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"November\",'Revenue Input'!$E33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"December\",'Revenue Input'!$E33,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F34 = \"January\",'Revenue Input'!$E34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"February\",'Revenue Input'!$E34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"March\",'Revenue Input'!$E34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"April\",'Revenue Input'!$E34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"May\",'Revenue Input'!$E34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"June\",'Revenue Input'!$E34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"July\",'Revenue Input'!$E34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"August\",'Revenue Input'!$E34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"September\",'Revenue Input'!$E34,0)","v":{"v":129000,"d":"$129,000"}},{"$f":"IF('Revenue Input'!$F34 = \"October\",'Revenue Input'!$E34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"November\",'Revenue Input'!$E34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"December\",'Revenue Input'!$E34,0)","v":0}]
[{"$f":"SUBTOTAL(109,[Jul-16])","v":{"v":202000,"d":"$202,000"}},{"$f":"SUBTOTAL(109,[Aug-16])","v":{"v":211000,"d":"$211,000"}},{"$f":"SUBTOTAL(109,[Sep-16])","v":{"v":371000,"d":"$371,000"}},{"$f":"SUBTOTAL(109,[Oct-16])","v":{"v":253000,"d":"$253,000"}},{"$f":"SUBTOTAL(109,[Nov-16])","v":{"v":232000,"d":"$232,000"}},{"$f":"SUBTOTAL(109,[Dec-16])","v":{"v":240000,"d":"$240,000"}},{"$f":"SUBTOTAL(109,[Jan-17])","v":{"v":101000,"d":"$101,000"}},{"$f":"SUBTOTAL(109,[Feb-17])","v":{"v":270000,"d":"$270,000"}},{"$f":"SUBTOTAL(109,[Mar-17])","v":{"v":274000,"d":"$274,000"}},{"$f":"SUBTOTAL(109,[Apr-17])","v":{"v":303900,"d":"$303,900"}},{"$f":"SUBTOTAL(109,[May-17])","v":{"v":268200,"d":"$268,200"}},{"$f":"SUBTOTAL(109,[Jun-17])","v":{"v":278500,"d":"$278,500"}}]
["Running Totals",{"$f":"A32+B32","v":{"v":413000,"d":"$413,000"}},{"$f":"B33+C32","v":{"v":784000,"d":"$784,000"}},{"$f":"C33+D32","v":{"v":1037000,"d":"$1,037,000"}},{"v":1269000,"d":"$1,269,000"},{"v":1509000,"d":"$1,509,000"},{"v":1610000,"d":"$1,610,000"},{"v":1880000,"d":"$1,880,000"},{"v":2154000,"d":"$2,154,000"},{"v":2457900,"d":"$2,457,900"},{"v":2726100,"d":"$2,726,100"},{"v":3004600,"d":"$3,004,600"}]

{"sheet":"Mean Revenue","index":4,"n_rows":33,"n_cols":12,"rows_kept":33,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3]]}
[{"$f":"'Revenue Input'!A1","v":"[Company Name] "}]
["Mean Revenue Forecast"]
["[Company Name] Confidential"]
["[Date]"]
[]
["These cells are calculated for you, and they generally should not be altered."]
["Jul-16","Aug-16","Sep-16","Oct-16","Nov-16","Dec-16","Jan-17","Feb-17","Mar-17","Apr-17","May-17","Jun-17"]
[{"$f":"IF('Revenue Input'!$F11 = \"January\",'Revenue Input'!$G11,0)","v":{"v":120000,"d":"$120,000"}},{"$f":"IF('Revenue Input'!$F11 = \"February\",'Revenue Input'!$G11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"March\",'Revenue Input'!$G11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"April\",'Revenue Input'!$G11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"May\",'Revenue Input'!$G11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"June\",'Revenue Input'!$G11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"July\",'Revenue Input'!$G11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"August\",'Revenue Input'!$G11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"September\",'Revenue Input'!$G11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"October\",'Revenue Input'!$G11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"November\",'Revenue Input'!$G11,0)","v":0},{"$f":"IF('Revenue Input'!$F11 = \"December\",'Revenue Input'!$G11,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F12 = \"January\",'Revenue Input'!$G12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"February\",'Revenue Input'!$G12,0)","v":{"v":120366.66666666667,"d":"$120,367"}},{"$f":"IF('Revenue Input'!$F12 = \"March\",'Revenue Input'!$G12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"April\",'Revenue Input'!$G12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"May\",'Revenue Input'!$G12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"June\",'Revenue Input'!$G12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"July\",'Revenue Input'!$G12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"August\",'Revenue Input'!$G12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"September\",'Revenue Input'!$G12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"October\",'Revenue Input'!$G12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"November\",'Revenue Input'!$G12,0)","v":0},{"$f":"IF('Revenue Input'!$F12 = \"December\",'Revenue Input'!$G12,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F13 = \"January\",'Revenue Input'!$G13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"February\",'Revenue Input'!$G13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"March\",'Revenue Input'!$G13,0)","v":{"v":121083.33333333333,"d":"$121,083"}},{"$f":"IF('Revenue Input'!$F13 = \"April\",'Revenue Input'!$G13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"May\",'Revenue Input'!$G13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"June\",'Revenue Input'!$G13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"July\",'Revenue Input'!$G13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"August\",'Revenue Input'!$G13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"September\",'Revenue Input'!$G13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"October\",'Revenue Input'!$G13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"November\",'Revenue Input'!$G13,0)","v":0},{"$f":"IF('Revenue Input'!$F13 = \"December\",'Revenue Input'!$G13,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F14 = \"January\",'Revenue Input'!$G14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"February\",'Revenue Input'!$G14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"March\",'Revenue Input'!$G14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"April\",'Revenue Input'!$G14,0)","v":{"v":124416.66666666667,"d":"$124,417"}},{"$f":"IF('Revenue Input'!$F14 = \"May\",'Revenue Input'!$G14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"June\",'Revenue Input'!$G14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"July\",'Revenue Input'!$G14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"August\",'Revenue Input'!$G14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"September\",'Revenue Input'!$G14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"October\",'Revenue Input'!$G14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"November\",'Revenue Input'!$G14,0)","v":0},{"$f":"IF('Revenue Input'!$F14 = \"December\",'Revenue Input'!$G14,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F15 = \"January\",'Revenue Input'!$G15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"February\",'Revenue Input'!$G15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"March\",'Revenue Input'!$G15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"April\",'Revenue Input'!$G15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"May\",'Revenue Input'!$G15,0)","v":{"v":140000,"d":"$140,000"}},{"$f":"IF('Revenue Input'!$F15 = \"June\",'Revenue Input'!$G15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"July\",'Revenue Input'!$G15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"August\",'Revenue Input'!$G15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"September\",'Revenue Input'!$G15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"October\",'Revenue Input'!$G15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"November\",'Revenue Input'!$G15,0)","v":0},{"$f":"IF('Revenue Input'!$F15 = \"December\",'Revenue Input'!$G15,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F16 = \"January\",'Revenue Input'!$G16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"February\",'Revenue Input'!$G16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"March\",'Revenue Input'!$G16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"April\",'Revenue Input'!$G16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"May\",'Revenue Input'!$G16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"June\",'Revenue Input'!$G16,0)","v":{"v":150000,"d":"$150,000"}},{"$f":"IF('Revenue Input'!$F16 = \"July\",'Revenue Input'!$G16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"August\",'Revenue Input'!$G16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"September\",'Revenue Input'!$G16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"October\",'Revenue Input'!$G16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"November\",'Revenue Input'!$G16,0)","v":0},{"$f":"IF('Revenue Input'!$F16 = \"December\",'Revenue Input'!$G16,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F17 = \"January\",'Revenue Input'!$G17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"February\",'Revenue Input'!$G17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"March\",'Revenue Input'!$G17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"April\",'Revenue Input'!$G17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"May\",'Revenue Input'!$G17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"June\",'Revenue Input'!$G17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"July\",'Revenue Input'!$G17,0)","v":{"v":125000,"d":"$125,000"}},{"$f":"IF('Revenue Input'!$F17 = \"August\",'Revenue Input'!$G17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"September\",'Revenue Input'!$G17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"October\",'Revenue Input'!$G17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"November\",'Revenue Input'!$G17,0)","v":0},{"$f":"IF('Revenue Input'!$F17 = \"December\",'Revenue Input'!$G17,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F18 = \"January\",'Revenue Input'!$G18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"February\",'Revenue Input'!$G18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"March\",'Revenue Input'!$G18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"April\",'Revenue Input'!$G18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"May\",'Revenue Input'!$G18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"June\",'Revenue Input'!$G18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"July\",'Revenue Input'!$G18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"August\",'Revenue Input'!$G18,0)","v":{"v":130833.33333333333,"d":"$130,833"}},{"$f":"IF('Revenue Input'!$F18 = \"September\",'Revenue Input'!$G18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"October\",'Revenue Input'!$G18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"November\",'Revenue Input'!$G18,0)","v":0},{"$f":"IF('Revenue Input'!$F18 = \"December\",'Revenue Input'!$G18,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F19 = \"January\",'Revenue Input'!$G19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"February\",'Revenue Input'!$G19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"March\",'Revenue Input'!$G19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"April\",'Revenue Input'!$G19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"May\",'Revenue Input'!$G19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"June\",'Revenue Input'!$G19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"July\",'Revenue Input'!$G19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"August\",'Revenue Input'!$G19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"September\",'Revenue Input'!$G19,0)","v":{"v":172483.33333333334,"d":"$172,483"}},{"$f":"IF('Revenue Input'!$F19 = \"October\",'Revenue Input'!$G19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"November\",'Revenue Input'!$G19,0)","v":0},{"$f":"IF('Revenue Input'!$F19 = \"December\",'Revenue Input'!$G19,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F20 = \"January\",'Revenue Input'!$G20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"February\",'Revenue Input'!$G20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"March\",'Revenue Input'!$G20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"April\",'Revenue Input'!$G20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"May\",'Revenue Input'!$G20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"June\",'Revenue Input'!$G20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"July\",'Revenue Input'!$G20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"August\",'Revenue Input'!$G20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"September\",'Revenue Input'!$G20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"October\",'Revenue Input'!$G20,0)","v":{"v":156416.66666666666,"d":"$156,417"}},{"$f":"IF('Revenue Input'!$F20 = \"November\",'Revenue Input'!$G20,0)","v":0},{"$f":"IF('Revenue Input'!$F20 = \"December\",'Revenue Input'!$G20,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F21 = \"January\",'Revenue Input'!$G21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"February\",'Revenue Input'!$G21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"March\",'Revenue Input'!$G21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"April\",'Revenue Input'!$G21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"May\",'Revenue Input'!$G21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"June\",'Revenue Input'!$G21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"July\",'Revenue Input'!$G21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"August\",'Revenue Input'!$G21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"September\",'Revenue Input'!$G21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"October\",'Revenue Input'!$G21,0)","v":0},{"$f":"IF('Revenue Input'!$F21 = \"November\",'Revenue Input'!$G21,0)","v":{"v":145083.33333333334,"d":"$145,083"}},{"$f":"IF('Revenue Input'!$F21 = \"December\",'Revenue Input'!$G21,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F22 = \"January\",'Revenue Input'!$G22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"February\",'Revenue Input'!$G22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"March\",'Revenue Input'!$G22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"April\",'Revenue Input'!$G22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"May\",'Revenue Input'!$G22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"June\",'Revenue Input'!$G22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"July\",'Revenue Input'!$G22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"August\",'Revenue Input'!$G22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"September\",'Revenue Input'!$G22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"October\",'Revenue Input'!$G22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"November\",'Revenue Input'!$G22,0)","v":0},{"$f":"IF('Revenue Input'!$F22 = \"December\",'Revenue Input'!$G22,0)","v":{"v":149416.66666666666,"d":"$149,417"}}]
[{"$f":"IF('Revenue Input'!$F23 = \"January\",'Revenue Input'!$G23,0)","v":{"v":135000,"d":"$135,000"}},{"$f":"IF('Revenue Input'!$F23 = \"February\",'Revenue Input'!$G23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"March\",'Revenue Input'!$G23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"April\",'Revenue Input'!$G23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"May\",'Revenue Input'!$G23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"June\",'Revenue Input'!$G23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"July\",'Revenue Input'!$G23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"August\",'Revenue Input'!$G23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"September\",'Revenue Input'!$G23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"October\",'Revenue Input'!$G23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"November\",'Revenue Input'!$G23,0)","v":0},{"$f":"IF('Revenue Input'!$F23 = \"December\",'Revenue Input'!$G23,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F24 = \"January\",'Revenue Input'!$G24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"February\",'Revenue Input'!$G24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"March\",'Revenue Input'!$G24,0)","v":{"v":170000,"d":"$170,000"}},{"$f":"IF('Revenue Input'!$F24 = \"April\",'Revenue Input'!$G24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"May\",'Revenue Input'!$G24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"June\",'Revenue Input'!$G24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"July\",'Revenue Input'!$G24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"August\",'Revenue Input'!$G24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"September\",'Revenue Input'!$G24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"October\",'Revenue Input'!$G24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"November\",'Revenue Input'!$G24,0)","v":0},{"$f":"IF('Revenue Input'!$F24 = \"December\",'Revenue Input'!$G24,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F25 = \"January\",'Revenue Input'!$G25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"February\",'Revenue Input'!$G25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"March\",'Revenue Input'!$G25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"April\",'Revenue Input'!$G25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"May\",'Revenue Input'!$G25,0)","v":{"v":120000,"d":"$120,000"}},{"$f":"IF('Revenue Input'!$F25 = \"June\",'Revenue Input'!$G25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"July\",'Revenue Input'!$G25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"August\",'Revenue Input'!$G25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"September\",'Revenue Input'!$G25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"October\",'Revenue Input'!$G25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"November\",'Revenue Input'!$G25,0)","v":0},{"$f":"IF('Revenue Input'!$F25 = \"December\",'Revenue Input'!$G25,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F26 = \"January\",'Revenue Input'!$G26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"February\",'Revenue Input'!$G26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"March\",'Revenue Input'!$G26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"April\",'Revenue Input'!$G26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"May\",'Revenue Input'!$G26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"June\",'Revenue Input'!$G26,0)","v":{"v":135000,"d":"$135,000"}},{"$f":"IF('Revenue Input'!$F26 = \"July\",'Revenue Input'!$G26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"August\",'Revenue Input'!$G26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"September\",'Revenue Input'!$G26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"October\",'Revenue Input'!$G26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"November\",'Revenue Input'!$G26,0)","v":0},{"$f":"IF('Revenue Input'!$F26 = \"December\",'Revenue Input'!$G26,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F27 = \"January\",'Revenue Input'!$G27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"February\",'Revenue Input'!$G27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"March\",'Revenue Input'!$G27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"April\",'Revenue Input'!$G27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"May\",'Revenue Input'!$G27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"June\",'Revenue Input'!$G27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"July\",'Revenue Input'!$G27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"August\",'Revenue Input'!$G27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"September\",'Revenue Input'!$G27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"October\",'Revenue Input'!$G27,0)","v":{"v":168183.33333333334,"d":"$168,183"}},{"$f":"IF('Revenue Input'!$F27 = \"November\",'Revenue Input'!$G27,0)","v":0},{"$f":"IF('Revenue Input'!$F27 = \"December\",'Revenue Input'!$G27,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F28 = \"January\",'Revenue Input'!$G28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"February\",'Revenue Input'!$G28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"March\",'Revenue Input'!$G28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"April\",'Revenue Input'!$G28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"May\",'Revenue Input'!$G28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"June\",'Revenue Input'!$G28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"July\",'Revenue Input'!$G28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"August\",'Revenue Input'!$G28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"September\",'Revenue Input'!$G28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"October\",'Revenue Input'!$G28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"November\",'Revenue Input'!$G28,0)","v":0},{"$f":"IF('Revenue Input'!$F28 = \"December\",'Revenue Input'!$G28,0)","v":{"v":142266.66666666666,"d":"$142,267"}}]
[{"$f":"IF('Revenue Input'!$F29 = \"January\",'Revenue Input'!$G29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"February\",'Revenue Input'!$G29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"March\",'Revenue Input'!$G29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"April\",'Revenue Input'!$G29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"May\",'Revenue Input'!$G29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"June\",'Revenue Input'!$G29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"July\",'Revenue Input'!$G29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"August\",'Revenue Input'!$G29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"September\",'Revenue Input'!$G29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"October\",'Revenue Input'!$G29,0)","v":0},{"$f":"IF('Revenue Input'!$F29 = \"November\",'Revenue Input'!$G29,0)","v":{"v":151991.66666666666,"d":"$151,992"}},{"$f":"IF('Revenue Input'!$F29 = \"December\",'Revenue Input'!$G29,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F30 = \"January\",'Revenue Input'!$G30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"February\",'Revenue Input'!$G30,0)","v":{"v":142000,"d":"$142,000"}},{"$f":"IF('Revenue Input'!$F30 = \"March\",'Revenue Input'!$G30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"April\",'Revenue Input'!$G30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"May\",'Revenue Input'!$G30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"June\",'Revenue Input'!$G30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"July\",'Revenue Input'!$G30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"August\",'Revenue Input'!$G30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"September\",'Revenue Input'!$G30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"October\",'Revenue Input'!$G30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"November\",'Revenue Input'!$G30,0)","v":0},{"$f":"IF('Revenue Input'!$F30 = \"December\",'Revenue Input'!$G30,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F31 = \"January\",'Revenue Input'!$G31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"February\",'Revenue Input'!$G31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"March\",'Revenue Input'!$G31,0)","v":{"v":142666.66666666666,"d":"$142,667"}},{"$f":"IF('Revenue Input'!$F31 = \"April\",'Revenue Input'!$G31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"May\",'Revenue Input'!$G31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"June\",'Revenue Input'!$G31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"July\",'Revenue Input'!$G31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"August\",'Revenue Input'!$G31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"September\",'Revenue Input'!$G31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"October\",'Revenue Input'!$G31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"November\",'Revenue Input'!$G31,0)","v":0},{"$f":"IF('Revenue Input'!$F31 = \"December\",'Revenue Input'!$G31,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F32 = \"January\",'Revenue Input'!$G32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"February\",'Revenue Input'!$G32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"March\",'Revenue Input'!$G32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"April\",'Revenue Input'!$G32,0)","v":{"v":164500,"d":"$164,500"}},{"$f":"IF('Revenue Input'!$F32 = \"May\",'Revenue Input'!$G32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"June\",'Revenue Input'!$G32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"July\",'Revenue Input'!$G32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"August\",'Revenue Input'!$G32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"September\",'Revenue Input'!$G32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"October\",'Revenue Input'!$G32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"November\",'Revenue Input'!$G32,0)","v":0},{"$f":"IF('Revenue Input'!$F32 = \"December\",'Revenue Input'!$G32,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F33 = \"January\",'Revenue Input'!$G33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"February\",'Revenue Input'!$G33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"March\",'Revenue Input'!$G33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"April\",'Revenue Input'!$G33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"May\",'Revenue Input'!$G33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"June\",'Revenue Input'!$G33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"July\",'Revenue Input'!$G33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"August\",'Revenue Input'!$G33,0)","v":{"v":161000,"d":"$161,000"}},{"$f":"IF('Revenue Input'!$F33 = \"September\",'Revenue Input'!$G33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"October\",'Revenue Input'!$G33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"November\",'Revenue Input'!$G33,0)","v":0},{"$f":"IF('Revenue Input'!$F33 = \"December\",'Revenue Input'!$G33,0)","v":0}]
[{"$f":"IF('Revenue Input'!$F34 = \"January\",'Revenue Input'!$G34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"February\",'Revenue Input'!$G34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"March\",'Revenue Input'!$G34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"April\",'Revenue Input'!$G34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"May\",'Revenue Input'!$G34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"June\",'Revenue Input'!$G34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"July\",'Revenue Input'!$G34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"August\",'Revenue Input'!$G34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"September\",'Revenue Input'!$G34,0)","v":{"v":146833.33333333334,"d":"$146,833"}},{"$f":"IF('Revenue Input'!$F34 = \"October\",'Revenue Input'!$G34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"November\",'Revenue Input'!$G34,0)","v":0},{"$f":"IF('Revenue Input'!$F34 = \"December\",'Revenue Input'!$G34,0)","v":0}]
[{"$f":"SUBTOTAL(109,[Jul-16])","v":{"v":255000,"d":"$255,000"}},{"$f":"SUBTOTAL(109,[Aug-16])","v":{"v":262366.6666666667,"d":"$262,367"}},{"$f":"SUBTOTAL(109,[Sep-16])","v":{"v":433750,"d":"$433,750"}},{"$f":"SUBTOTAL(109,[Oct-16])","v":{"v":288916.6666666667,"d":"$288,917"}},{"$f":"SUBTOTAL(109,[Nov-16])","v":{"v":260000,"d":"$260,000"}},{"$f":"SUBTOTAL(109,[Dec-16])","v":{"v":285000,"d":"$285,000"}},{"$f":"SUBTOTAL(109,[Jan-17])","v":{"v":125000,"d":"$125,000"}},{"$f":"SUBTOTAL(109,[Feb-17])","v":{"v":291833.3333333333,"d":"$291,833"}},{"$f":"SUBTOTAL(109,[Mar-17])","v":{"v":319316.6666666667,"d":"$319,317"}},{"$f":"SUBTOTAL(109,[Apr-17])","v":{"v":324600,"d":"$324,600"}},{"$f":"SUBTOTAL(109,[May-17])","v":{"v":297075,"d":"$297,075"}},{"$f":"SUBTOTAL(109,[Jun-17])","v":{"v":291683.3333333333,"d":"$291,683"}}]
["Running Totals",{"$f":"A32+B32","v":{"v":517366.6666666667,"d":"$517,367"}},{"$f":"B33+C32","v":{"v":951116.6666666667,"d":"$951,117"}},{"$f":"C33+D32","v":{"v":1240033.3333333335,"d":"$1,240,033"}},{"v":1500033.3333333335,"d":"$1,500,033"},{"v":1785033.3333333335,"d":"$1,785,033"},{"v":1910033.3333333335,"d":"$1,910,033"},{"v":2201866.666666667,"d":"$2,201,867"},{"v":2521183.3333333335,"d":"$2,521,183"},{"v":2845783.3333333335,"d":"$2,845,783"},{"v":3142858.3333333335,"d":"$3,142,858"},{"v":3434541.666666667,"d":"$3,434,542"}]