{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Dashboard","Sales","Income","Expenses","Taxes","Categories"],"not_rendered":{"images":1,"defined_names":34},"read":"whole","date_system":"1900"}

{"sheet":"Dashboard","index":0,"n_rows":19,"n_cols":8,"rows_kept":19,"merged":[[0,2,0,4],[0,6,3,7],[4,1,4,7]]}
[null,"Profit and loss statement","For the [month or year] ending [day/month/year]"]
[null,"Company name","Stated in 000s"]
[null,"Current Gross margin [L/J]",{"$f":"IFERROR(IF(Total_Gross_Profit=0,\"-\",Total_Gross_Profit/Total_Sales_Revenue),\"-\")","v":"-"}]
[null,"Current Return on sales [T/J]",{"$f":"IFERROR(IF(Net_Profit=0,\"-\",Net_Profit/Total_Sales_Revenue),\"-\")","v":"-"}]
[null,"Do not modify the categories in this worksheet or the formulae may break. Use the Category worksheet to add categories and update the corresponding worksheets with entries. This worksheet will update automatically."]
[null,"Summary","Total Prior Period","Total Budget","Total Current\nPeriod","Total Current Period as % of Sales","Total % Change from Prior Period","Total % Change from Budget"]
[null,"Total Sales Revenue [J]",{"$f":"SUMIFS(SalesRevenue[Prior Period],SalesRevenue[Revenue Type],\"Sales Revenue\")","v":0},{"$f":"SUMIFS(SalesRevenue[Budget],SalesRevenue[Revenue Type],\"Sales Revenue\")","v":0},{"$f":"SUMIFS(SalesRevenue[Current Period],SalesRevenue[Revenue Type],\"Sales Revenue\")","v":0},{"$f":"SUMIFS(SalesRevenue[Current Period as % of Sales],SalesRevenue[Revenue Type],\"Sales Revenue\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(SalesRevenue[% Change from Prior Period],SalesRevenue[Revenue Type],\"Sales Revenue\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(SalesRevenue[% Change from Budget],SalesRevenue[Revenue Type],\"Sales Revenue\")","v":{"v":0,"d":"0.00%"}}]
[null,"Total Cost of Sales [K]",{"$f":"SUMIFS(SalesRevenue[Prior Period],SalesRevenue[Revenue Type],\"Cost of Sales\")","v":0},{"$f":"SUMIFS(SalesRevenue[Budget],SalesRevenue[Revenue Type],\"Cost of Sales\")","v":0},{"$f":"SUMIFS(SalesRevenue[Current Period],SalesRevenue[Revenue Type],\"Cost of Sales\")","v":0},{"$f":"SUMIFS(SalesRevenue[Current Period as % of Sales],SalesRevenue[Revenue Type],\"Cost of Sales\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(SalesRevenue[% Change from Prior Period],SalesRevenue[Revenue Type],\"Cost of Sales\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(SalesRevenue[% Change from Budget],SalesRevenue[Revenue Type],\"Cost of Sales\")","v":{"v":0,"d":"0.00%"}}]
[null,"Total Sales and Marketing Expenses [M]",{"$f":"SUMIFS(OperatingExpenses[Prior Period],OperatingExpenses[Expense Type],\"Sales and marketing\")","v":0},{"$f":"SUMIFS(OperatingExpenses[Budget],OperatingExpenses[Expense Type],\"Sales and marketing\")","v":0},{"$f":"SUMIFS(OperatingExpenses[Current Period],OperatingExpenses[Expense Type],\"Sales and marketing\")","v":0},{"$f":"SUMIFS(OperatingExpenses[Current Period as % of Sales],OperatingExpenses[Expense Type],\"Sales and marketing\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(OperatingExpenses[% Change from Prior Period],OperatingExpenses[Expense Type],\"Sales and marketing\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(OperatingExpenses[% Change from Budget],OperatingExpenses[Expense Type],\"Sales and marketing\")","v":{"v":0,"d":"0.00%"}}]
[null,"Total Research and Development Expenses [N]",{"$f":"SUMIFS(OperatingExpenses[Prior Period],OperatingExpenses[Expense Type],\"Research and development\")","v":0},{"$f":"SUMIFS(OperatingExpenses[Budget],OperatingExpenses[Expense Type],\"Research and development\")","v":0},{"$f":"SUMIFS(OperatingExpenses[Current Period],OperatingExpenses[Expense Type],\"Research and development\")","v":0},{"$f":"SUMIFS(OperatingExpenses[Current Period as % of Sales],OperatingExpenses[Expense Type],\"Research and development\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(OperatingExpenses[% Change from Prior Period],OperatingExpenses[Expense Type],\"Research and development\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(OperatingExpenses[% Change from Budget],OperatingExpenses[Expense Type],\"Research and development\")","v":{"v":0,"d":"0.00%"}}]
[null,"Total General and Administrative Expenses [O]",{"$f":"SUMIFS(OperatingExpenses[Prior Period],OperatingExpenses[Expense Type],\"General and administrative\")","v":0},{"$f":"SUMIFS(OperatingExpenses[Budget],OperatingExpenses[Expense Type],\"General and administrative\")","v":0},{"$f":"SUMIFS(OperatingExpenses[Current Period],OperatingExpenses[Expense Type],\"General and administrative\")","v":0},{"$f":"SUMIFS(OperatingExpenses[Current Period as % of Sales],OperatingExpenses[Expense Type],\"General and administrative\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(OperatingExpenses[% Change from Prior Period],OperatingExpenses[Expense Type],\"General and administrative\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(OperatingExpenses[% Change from Budget],OperatingExpenses[Expense Type],\"General and administrative\")","v":{"v":0,"d":"0.00%"}}]
[null,"Total Other Operating Expenses [P]",{"$f":"OperatingExpenses[[#Totals],[Prior Period]]-SUM(C9:C11)","v":0},{"$f":"OperatingExpenses[[#Totals],[Budget]]-SUM(D9:D11)","v":0},{"$f":"OperatingExpenses[[#Totals],[Current Period]]-SUM(E9:E11)","v":0},{"$f":"OperatingExpenses[[#Totals],[Current Period as % of Sales]]-SUM(F9:F11)","v":{"v":0,"d":"0.00%"}},{"$f":"OperatingExpenses[[#Totals],[% Change from Prior Period]]-SUM(G9:G11)","v":{"v":0,"d":"0.00%"}},{"$f":"OperatingExpenses[[#Totals],[% Change from Budget]]-SUM(H9:H11)","v":{"v":0,"d":"0.00%"}}]
[null,"Other Income [S]",{"$f":"Income[[#Totals],[Prior Period]]","v":0},{"$f":"Income[[#Totals],[Budget]]","v":0},{"$f":"Income[[#Totals],[Current Period]]","v":0},{"$f":"Income[[#Totals],[Current Period as % of Sales]]","v":{"v":0,"d":"0.00%"}},{"$f":"Income[[#Totals],[% Change from Prior Period]]","v":{"v":0,"d":"0.00%"}},{"$f":"Income[[#Totals],[% Change from Budget]]","v":{"v":0,"d":"0.00%"}}]
[null,"Total Taxes [T]",{"$f":"Taxes[[#Totals],[Prior Period]]","v":0},{"$f":"Taxes[[#Totals],[Budget]]","v":0},{"$f":"Taxes[[#Totals],[Current Period]]","v":0},{"$f":"Taxes[[#Totals],[Current Period as % of Sales]]","v":{"v":0,"d":"0.00%"}},{"$f":"Taxes[[#Totals],[% Change from Prior Period]]","v":{"v":0,"d":"0.00%"}},{"$f":"Taxes[[#Totals],[% Change from Budget]]","v":{"v":0,"d":"0.00%"}}]
[]
[null,"Gross Profit [L=J-K]",{"$f":"IFERROR(C7-C8,\"-\")","v":0},{"$f":"IFERROR(D7-D8,\"-\")","v":0},{"$f":"IFERROR(Total_Sales_Revenue-Total_Cost_Sales,\"-\")","v":0},{"$f":"IFERROR(IF(Total_Sales_Revenue=0,\"0.00%\",Total_Gross_Profit/Total_Sales_Revenue),\"-\")","v":"0.00%"},{"$f":"IFERROR(IF(C16=Total_Gross_Profit,0,IF(Total_Gross_Profit>C16,ABS((Total_Gross_Profit/C16)-1),IF(AND(Total_Gross_Profit<C16,C16<0),-((Total_Gross_Profit/C16)-1),(Total_Gross_Profit/C16)-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(D16=Total_Gross_Profit,0,IF(Total_Gross_Profit>D16,ABS((Total_Gross_Profit/D16)-1),IF(AND(Total_Gross_Profit<D16,D16<0),-((Total_Gross_Profit/D16)-1),(Total_Gross_Profit/D16)-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"Total Operating Expenses [Q=M+N+O+P]",{"$f":"IFERROR(C9+C10+C11+C12,\"-\")","v":0},{"$f":"IFERROR(D9+D10+D11+D12,\"-\")","v":0},{"$f":"IFERROR(Total_Sales_and_Marketing+Total_Research_and_Development+Total_General_and_Administrative+Total_Other_Expenses,\"-\")","v":0},{"$f":"IFERROR(IF(Total_Sales_Revenue=0,\"0.00%\",Total_Operating_Expenses/Total_Sales_Revenue),\"-\")","v":"0.00%"},{"$f":"IFERROR(IF(C17=Total_Operating_Expenses,0,IF(Total_Operating_Expenses>C17,ABS((Total_Operating_Expenses/C17)-1),IF(AND(Total_Operating_Expenses<C17,C17<0),-((Total_Operating_Expenses/C17)-1),(Total_Operating_Expenses/C17)-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(D17=Total_Operating_Expenses,0,IF(Total_Operating_Expenses>D17,ABS((Total_Operating_Expenses/D17)-1),IF(AND(Total_Operating_Expenses<D17,D17<0),-((Total_Operating_Expenses/D17)-1),(Total_Operating_Expenses/D17)-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"Income from Operations [R=L-Q]",{"$f":"IFERROR(C16-C17,\"-\")","v":0},{"$f":"IFERROR(D16-D17,\"-\")","v":0},{"$f":"IFERROR(Total_Gross_Profit-Total_Operating_Expenses,\"-\")","v":0},{"$f":"IFERROR(IF(Total_Sales_Revenue=0,\"0.00%\",Total_Income_Operations/Total_Sales_Revenue),\"-\")","v":"0.00%"},{"$f":"IFERROR(IF(C18=Total_Income_Operations,0,IF(Total_Income_Operations>C18,ABS((Total_Income_Operations/C18)-1),IF(AND(Total_Income_Operations<C18,C18<0),-((Total_Income_Operations/C18)-1),(Total_Income_Operations/C18)-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(D18=Total_Income_Operations,0,IF(Total_Income_Operations>D18,ABS((Total_Income_Operations/D18)-1),IF(AND(Total_Income_Operations<D18,D18<0),-((Total_Income_Operations/D18)-1),(Total_Income_Operations/D18)-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"Net Profit [U=R+S-T]",{"$f":"IFERROR(C18+C13-C14,\"-\")","v":0},{"$f":"IFERROR(D18+D13-D14,\"-\")","v":0},{"$f":"Total_Income_Operations+Total_Other_Income-Total_Taxes","v":0},{"$f":"IFERROR(IF(Total_Sales_Revenue=0,\"0.00%\",Net_Profit/Total_Sales_Revenue),\"-\")","v":"0.00%"},{"$f":"IFERROR(IF(C19=Net_Profit,0,IF(Net_Profit>C19,ABS((Net_Profit/C19)-1),IF(AND(Net_Profit<C19,C19<0),-((Net_Profit/C19)-1),(Net_Profit/C19)-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(D19=Net_Profit,0,IF(Net_Profit>D19,ABS((Net_Profit/D19)-1),IF(AND(Net_Profit<D19,D19<0),-((Net_Profit/D19)-1),(Net_Profit/D19)-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]

{"sheet":"Sales","index":1,"n_rows":13,"n_cols":9,"rows_kept":13,"merged":[[0,7,2,8]]}
[null,{"$f":"Workbook_Title","v":"Profit and loss statement"}]
[null,{"$f":"Company_Name","v":"Company name"},"Stated in 000s"]
[null,"Sales Revenue",{"$f":"IFERROR(Sales_Revenue,\"-\")","v":0}]
[null,"Revenue Type","Description","Prior Period","Budget","Current Period","Current Period as % of Sales","% Change from Prior Period","% Change from Budget"]
[null,"Sales Revenue","Product/Service 1",{"$nulls":3},{"$f":"IFERROR(IF(SalesRevenue[[#Totals],[Current Period]]=0,\"-\",SalesRevenue[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(SalesRevenue[[#This Row],[Prior Period]]=SalesRevenue[[#This Row],[Current Period]],0,IF(SalesRevenue[[#This Row],[Current Period]]>SalesRevenue[[#This Row],[Prior Period]],ABS((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Prior Period]])-1),IF(AND(SalesRevenue[[#This Row],[Current Period]]<SalesRevenue[[#This Row],[Prior Period]],SalesRevenue[[#This Row],[Prior Period]]<0),-((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Prior Period]])-1),(SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(SalesRevenue[[#This Row],[Budget]]=SalesRevenue[[#This Row],[Current Period]],0,IF(SalesRevenue[[#This Row],[Current Period]]>SalesRevenue[[#This Row],[Budget]],ABS((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Budget]])-1),IF(AND(SalesRevenue[[#This Row],[Current Period]]<SalesRevenue[[#This Row],[Budget]],SalesRevenue[[#This Row],[Budget]]<0),-((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Budget]])-1),(SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"Sales Revenue","Product/Service 2",{"$nulls":3},{"$f":"IFERROR(IF(SalesRevenue[[#Totals],[Current Period]]=0,\"-\",SalesRevenue[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(SalesRevenue[[#This Row],[Prior Period]]=SalesRevenue[[#This Row],[Current Period]],0,IF(SalesRevenue[[#This Row],[Current Period]]>SalesRevenue[[#This Row],[Prior Period]],ABS((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Prior Period]])-1),IF(AND(SalesRevenue[[#This Row],[Current Period]]<SalesRevenue[[#This Row],[Prior Period]],SalesRevenue[[#This Row],[Prior Period]]<0),-((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Prior Period]])-1),(SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(SalesRevenue[[#This Row],[Budget]]=SalesRevenue[[#This Row],[Current Period]],0,IF(SalesRevenue[[#This Row],[Current Period]]>SalesRevenue[[#This Row],[Budget]],ABS((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Budget]])-1),IF(AND(SalesRevenue[[#This Row],[Current Period]]<SalesRevenue[[#This Row],[Budget]],SalesRevenue[[#This Row],[Budget]]<0),-((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Budget]])-1),(SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"Sales Revenue","Product/Service 3",{"$nulls":3},{"$f":"IFERROR(IF(SalesRevenue[[#Totals],[Current Period]]=0,\"-\",SalesRevenue[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(SalesRevenue[[#This Row],[Prior Period]]=SalesRevenue[[#This Row],[Current Period]],0,IF(SalesRevenue[[#This Row],[Current Period]]>SalesRevenue[[#This Row],[Prior Period]],ABS((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Prior Period]])-1),IF(AND(SalesRevenue[[#This Row],[Current Period]]<SalesRevenue[[#This Row],[Prior Period]],SalesRevenue[[#This Row],[Prior Period]]<0),-((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Prior Period]])-1),(SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(SalesRevenue[[#This Row],[Budget]]=SalesRevenue[[#This Row],[Current Period]],0,IF(SalesRevenue[[#This Row],[Current Period]]>SalesRevenue[[#This Row],[Budget]],ABS((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Budget]])-1),IF(AND(SalesRevenue[[#This Row],[Current Period]]<SalesRevenue[[#This Row],[Budget]],SalesRevenue[[#This Row],[Budget]]<0),-((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Budget]])-1),(SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"Sales Revenue","Product/Service 4",{"$nulls":3},{"$f":"IFERROR(IF(SalesRevenue[[#Totals],[Current Period]]=0,\"-\",SalesRevenue[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(SalesRevenue[[#This Row],[Prior Period]]=SalesRevenue[[#This Row],[Current Period]],0,IF(SalesRevenue[[#This Row],[Current Period]]>SalesRevenue[[#This Row],[Prior Period]],ABS((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Prior Period]])-1),IF(AND(SalesRevenue[[#This Row],[Current Period]]<SalesRevenue[[#This Row],[Prior Period]],SalesRevenue[[#This Row],[Prior Period]]<0),-((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Prior Period]])-1),(SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(SalesRevenue[[#This Row],[Budget]]=SalesRevenue[[#This Row],[Current Period]],0,IF(SalesRevenue[[#This Row],[Current Period]]>SalesRevenue[[#This Row],[Budget]],ABS((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Budget]])-1),IF(AND(SalesRevenue[[#This Row],[Current Period]]<SalesRevenue[[#This Row],[Budget]],SalesRevenue[[#This Row],[Budget]]<0),-((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Budget]])-1),(SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"Cost of Sales","Product/Service 1",{"$nulls":3},{"$f":"IFERROR(IF(SalesRevenue[[#Totals],[Current Period]]=0,\"-\",SalesRevenue[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(SalesRevenue[[#This Row],[Prior Period]]=SalesRevenue[[#This Row],[Current Period]],0,IF(SalesRevenue[[#This Row],[Current Period]]>SalesRevenue[[#This Row],[Prior Period]],ABS((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Prior Period]])-1),IF(AND(SalesRevenue[[#This Row],[Current Period]]<SalesRevenue[[#This Row],[Prior Period]],SalesRevenue[[#This Row],[Prior Period]]<0),-((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Prior Period]])-1),(SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(SalesRevenue[[#This Row],[Budget]]=SalesRevenue[[#This Row],[Current Period]],0,IF(SalesRevenue[[#This Row],[Current Period]]>SalesRevenue[[#This Row],[Budget]],ABS((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Budget]])-1),IF(AND(SalesRevenue[[#This Row],[Current Period]]<SalesRevenue[[#This Row],[Budget]],SalesRevenue[[#This Row],[Budget]]<0),-((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Budget]])-1),(SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"Cost of Sales","Product/Service 2",{"$nulls":3},{"$f":"IFERROR(IF(SalesRevenue[[#Totals],[Current Period]]=0,\"-\",SalesRevenue[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(SalesRevenue[[#This Row],[Prior Period]]=SalesRevenue[[#This Row],[Current Period]],0,IF(SalesRevenue[[#This Row],[Current Period]]>SalesRevenue[[#This Row],[Prior Period]],ABS((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Prior Period]])-1),IF(AND(SalesRevenue[[#This Row],[Current Period]]<SalesRevenue[[#This Row],[Prior Period]],SalesRevenue[[#This Row],[Prior Period]]<0),-((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Prior Period]])-1),(SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(SalesRevenue[[#This Row],[Budget]]=SalesRevenue[[#This Row],[Current Period]],0,IF(SalesRevenue[[#This Row],[Current Period]]>SalesRevenue[[#This Row],[Budget]],ABS((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Budget]])-1),IF(AND(SalesRevenue[[#This Row],[Current Period]]<SalesRevenue[[#This Row],[Budget]],SalesRevenue[[#This Row],[Budget]]<0),-((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Budget]])-1),(SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"Cost of Sales","Product/Service 3",{"$nulls":3},{"$f":"IFERROR(IF(SalesRevenue[[#Totals],[Current Period]]=0,\"-\",SalesRevenue[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(SalesRevenue[[#This Row],[Prior Period]]=SalesRevenue[[#This Row],[Current Period]],0,IF(SalesRevenue[[#This Row],[Current Period]]>SalesRevenue[[#This Row],[Prior Period]],ABS((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Prior Period]])-1),IF(AND(SalesRevenue[[#This Row],[Current Period]]<SalesRevenue[[#This Row],[Prior Period]],SalesRevenue[[#This Row],[Prior Period]]<0),-((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Prior Period]])-1),(SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(SalesRevenue[[#This Row],[Budget]]=SalesRevenue[[#This Row],[Current Period]],0,IF(SalesRevenue[[#This Row],[Current Period]]>SalesRevenue[[#This Row],[Budget]],ABS((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Budget]])-1),IF(AND(SalesRevenue[[#This Row],[Current Period]]<SalesRevenue[[#This Row],[Budget]],SalesRevenue[[#This Row],[Budget]]<0),-((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Budget]])-1),(SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"Cost of Sales","Product/Service 4",{"$nulls":3},{"$f":"IFERROR(IF(SalesRevenue[[#Totals],[Current Period]]=0,\"-\",SalesRevenue[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(SalesRevenue[[#This Row],[Prior Period]]=SalesRevenue[[#This Row],[Current Period]],0,IF(SalesRevenue[[#This Row],[Current Period]]>SalesRevenue[[#This Row],[Prior Period]],ABS((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Prior Period]])-1),IF(AND(SalesRevenue[[#This Row],[Current Period]]<SalesRevenue[[#This Row],[Prior Period]],SalesRevenue[[#This Row],[Prior Period]]<0),-((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Prior Period]])-1),(SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(SalesRevenue[[#This Row],[Budget]]=SalesRevenue[[#This Row],[Current Period]],0,IF(SalesRevenue[[#This Row],[Current Period]]>SalesRevenue[[#This Row],[Budget]],ABS((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Budget]])-1),IF(AND(SalesRevenue[[#This Row],[Current Period]]<SalesRevenue[[#This Row],[Budget]],SalesRevenue[[#This Row],[Budget]]<0),-((SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Budget]])-1),(SalesRevenue[[#This Row],[Current Period]]/SalesRevenue[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"Total Sales Revenue",null,{"$f":"SUBTOTAL(109,SalesRevenue[Prior Period])","v":0},{"$f":"SUBTOTAL(109,SalesRevenue[Budget])","v":0},{"$f":"SUBTOTAL(109,SalesRevenue[Current Period])","v":0},{"$f":"SUBTOTAL(109,SalesRevenue[Current Period as % of Sales])","v":{"v":0,"d":"0.00%"}},{"$f":"SUBTOTAL(109,SalesRevenue[% Change from Prior Period])","v":{"v":0,"d":"0.00%"}},{"$f":"SUBTOTAL(109,SalesRevenue[% Change from Budget])","v":{"v":0,"d":"0.00%"}}]

{"sheet":"Income","index":2,"n_rows":7,"n_cols":9,"rows_kept":7,"merged":[[0,7,2,8]]}
[null,{"$f":"Workbook_Title","v":"Profit and loss statement"}]
[null,{"$f":"Company_Name","v":"Company name"},"Stated in 000s"]
[null,"Income",{"$f":"IFERROR(Income[[#Totals],[Current Period]],\"-\")","v":0}]
[null,"Income Type","Description","Prior Period","Budget","Current Period","Current Period as % of Sales","% Change from Prior Period","% Change from Budget"]
[null,"Income","Other Income",{"$nulls":3},{"$f":"IFERROR(IF(Sales_Revenue=0,\"-\",Income[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(Income[[#This Row],[Prior Period]]=Income[[#This Row],[Current Period]],0,IF(Income[[#This Row],[Current Period]]>Income[[#This Row],[Prior Period]],ABS((Income[[#This Row],[Current Period]]/Income[[#This Row],[Prior Period]])-1),IF(AND(Income[[#This Row],[Current Period]]<Income[[#This Row],[Prior Period]],Income[[#This Row],[Prior Period]]<0),-((Income[[#This Row],[Current Period]]/Income[[#This Row],[Prior Period]])-1),(Income[[#This Row],[Current Period]]/Income[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(Income[[#This Row],[Budget]]=Income[[#This Row],[Current Period]],0,IF(Income[[#This Row],[Current Period]]>Income[[#This Row],[Budget]],ABS((Income[[#This Row],[Current Period]]/Income[[#This Row],[Budget]])-1),IF(AND(Income[[#This Row],[Current Period]]<Income[[#This Row],[Budget]],Income[[#This Row],[Budget]]<0),-((Income[[#This Row],[Current Period]]/Income[[#This Row],[Budget]])-1),(Income[[#This Row],[Current Period]]/Income[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[{"$nulls":6},{"$f":"IFERROR(IF(Sales_Revenue=0,\"-\",Income[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(Income[[#This Row],[Prior Period]]=Income[[#This Row],[Current Period]],0,IF(Income[[#This Row],[Current Period]]>Income[[#This Row],[Prior Period]],ABS((Income[[#This Row],[Current Period]]/Income[[#This Row],[Prior Period]])-1),IF(AND(Income[[#This Row],[Current Period]]<Income[[#This Row],[Prior Period]],Income[[#This Row],[Prior Period]]<0),-((Income[[#This Row],[Current Period]]/Income[[#This Row],[Prior Period]])-1),(Income[[#This Row],[Current Period]]/Income[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(Income[[#This Row],[Budget]]=Income[[#This Row],[Current Period]],0,IF(Income[[#This Row],[Current Period]]>Income[[#This Row],[Budget]],ABS((Income[[#This Row],[Current Period]]/Income[[#This Row],[Budget]])-1),IF(AND(Income[[#This Row],[Current Period]]<Income[[#This Row],[Budget]],Income[[#This Row],[Budget]]<0),-((Income[[#This Row],[Current Period]]/Income[[#This Row],[Budget]])-1),(Income[[#This Row],[Current Period]]/Income[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"Total Sales Income",null,{"$f":"SUBTOTAL(109,Income[Prior Period])","v":0},{"$f":"SUBTOTAL(109,Income[Budget])","v":0},{"$f":"SUBTOTAL(109,Income[Current Period])","v":0},{"$f":"SUBTOTAL(109,Income[Current Period as % of Sales])","v":{"v":0,"d":"0.00%"}},{"$f":"SUBTOTAL(109,Income[% Change from Prior Period])","v":{"v":0,"d":"0.00%"}},{"$f":"SUBTOTAL(109,Income[% Change from Budget])","v":{"v":0,"d":"0.00%"}}]

{"sheet":"Expenses","index":3,"n_rows":25,"n_cols":9,"rows_kept":25,"merged":[[0,7,2,8]]}
[null,{"$f":"Workbook_Title","v":"Profit and loss statement"}]
[null,{"$f":"Company_Name","v":"Company name"},"Stated in 000s"]
[null,"Operating Expenses",{"$f":"IFERROR(OperatingExpenses[[#Totals],[Current Period]],\"-\")","v":0}]
[null,"Expense Type","Description","Prior Period","Budget","Current Period","Current Period as % of Sales","% Change from Prior Period","% Change from Budget"]
[null,"Sales and marketing","Advertising",{"$nulls":3},{"$f":"IFERROR(IF(Sales_Revenue=0,\"-\",OperatingExpenses[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Prior Period]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Prior Period]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Prior Period]],OperatingExpenses[[#This Row],[Prior Period]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Budget]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Budget]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Budget]],OperatingExpenses[[#This Row],[Budget]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"Sales and marketing","Direct marketing",{"$nulls":3},{"$f":"IFERROR(IF(Sales_Revenue=0,\"-\",OperatingExpenses[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Prior Period]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Prior Period]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Prior Period]],OperatingExpenses[[#This Row],[Prior Period]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Budget]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Budget]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Budget]],OperatingExpenses[[#This Row],[Budget]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"Sales and marketing","Other expenses (specify)",{"$nulls":3},{"$f":"IFERROR(IF(Sales_Revenue=0,\"-\",OperatingExpenses[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Prior Period]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Prior Period]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Prior Period]],OperatingExpenses[[#This Row],[Prior Period]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Budget]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Budget]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Budget]],OperatingExpenses[[#This Row],[Budget]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"Sales and marketing","Other expenses (specify)",{"$nulls":3},{"$f":"IFERROR(IF(Sales_Revenue=0,\"-\",OperatingExpenses[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Prior Period]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Prior Period]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Prior Period]],OperatingExpenses[[#This Row],[Prior Period]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Budget]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Budget]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Budget]],OperatingExpenses[[#This Row],[Budget]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"Research and development","Technology licences",{"$nulls":3},{"$f":"IFERROR(IF(Sales_Revenue=0,\"-\",OperatingExpenses[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Prior Period]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Prior Period]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Prior Period]],OperatingExpenses[[#This Row],[Prior Period]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Budget]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Budget]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Budget]],OperatingExpenses[[#This Row],[Budget]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"Research and development","Patents ",{"$nulls":3},{"$f":"IFERROR(IF(Sales_Revenue=0,\"-\",OperatingExpenses[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Prior Period]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Prior Period]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Prior Period]],OperatingExpenses[[#This Row],[Prior Period]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Budget]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Budget]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Budget]],OperatingExpenses[[#This Row],[Budget]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"Research and development","Other expenses (specify)",{"$nulls":3},{"$f":"IFERROR(IF(Sales_Revenue=0,\"-\",OperatingExpenses[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Prior Period]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Prior Period]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Prior Period]],OperatingExpenses[[#This Row],[Prior Period]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Budget]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Budget]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Budget]],OperatingExpenses[[#This Row],[Budget]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"Research and development","Other expenses (specify)",{"$nulls":3},{"$f":"IFERROR(IF(Sales_Revenue=0,\"-\",OperatingExpenses[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Prior Period]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Prior Period]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Prior Period]],OperatingExpenses[[#This Row],[Prior Period]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Budget]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Budget]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Budget]],OperatingExpenses[[#This Row],[Budget]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"General and administrative","Wages and salaries",{"$nulls":3},{"$f":"IFERROR(IF(Sales_Revenue=0,\"-\",OperatingExpenses[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Prior Period]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Prior Period]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Prior Period]],OperatingExpenses[[#This Row],[Prior Period]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Budget]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Budget]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Budget]],OperatingExpenses[[#This Row],[Budget]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"General and administrative","Outside services",{"$nulls":3},{"$f":"IFERROR(IF(Sales_Revenue=0,\"-\",OperatingExpenses[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Prior Period]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Prior Period]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Prior Period]],OperatingExpenses[[#This Row],[Prior Period]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Budget]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Budget]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Budget]],OperatingExpenses[[#This Row],[Budget]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"General and administrative","Supplies",{"$nulls":3},{"$f":"IFERROR(IF(Sales_Revenue=0,\"-\",OperatingExpenses[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Prior Period]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Prior Period]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Prior Period]],OperatingExpenses[[#This Row],[Prior Period]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Budget]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Budget]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Budget]],OperatingExpenses[[#This Row],[Budget]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"General and administrative","Meals and entertainment",{"$nulls":3},{"$f":"IFERROR(IF(Sales_Revenue=0,\"-\",OperatingExpenses[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Prior Period]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Prior Period]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Prior Period]],OperatingExpenses[[#This Row],[Prior Period]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Budget]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Budget]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Budget]],OperatingExpenses[[#This Row],[Budget]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"General and administrative","Rent",{"$nulls":3},{"$f":"IFERROR(IF(Sales_Revenue=0,\"-\",OperatingExpenses[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Prior Period]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Prior Period]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Prior Period]],OperatingExpenses[[#This Row],[Prior Period]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Budget]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Budget]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Budget]],OperatingExpenses[[#This Row],[Budget]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"General and administrative","Telephone",{"$nulls":3},{"$f":"IFERROR(IF(Sales_Revenue=0,\"-\",OperatingExpenses[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Prior Period]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Prior Period]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Prior Period]],OperatingExpenses[[#This Row],[Prior Period]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Budget]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Budget]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Budget]],OperatingExpenses[[#This Row],[Budget]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"General and administrative","Utilities",{"$nulls":3},{"$f":"IFERROR(IF(Sales_Revenue=0,\"-\",OperatingExpenses[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Prior Period]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Prior Period]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Prior Period]],OperatingExpenses[[#This Row],[Prior Period]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Budget]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Budget]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Budget]],OperatingExpenses[[#This Row],[Budget]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"General and administrative","Depreciation",{"$nulls":3},{"$f":"IFERROR(IF(Sales_Revenue=0,\"-\",OperatingExpenses[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Prior Period]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Prior Period]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Prior Period]],OperatingExpenses[[#This Row],[Prior Period]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Budget]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Budget]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Budget]],OperatingExpenses[[#This Row],[Budget]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"General and administrative","Insurance",{"$nulls":3},{"$f":"IFERROR(IF(Sales_Revenue=0,\"-\",OperatingExpenses[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Prior Period]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Prior Period]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Prior Period]],OperatingExpenses[[#This Row],[Prior Period]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Budget]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Budget]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Budget]],OperatingExpenses[[#This Row],[Budget]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"General and administrative","Repairs and maintenance",{"$nulls":3},{"$f":"IFERROR(IF(Sales_Revenue=0,\"-\",OperatingExpenses[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Prior Period]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Prior Period]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Prior Period]],OperatingExpenses[[#This Row],[Prior Period]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Budget]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Budget]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Budget]],OperatingExpenses[[#This Row],[Budget]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"General and administrative","Other expenses (specify)",{"$nulls":3},{"$f":"IFERROR(IF(Sales_Revenue=0,\"-\",OperatingExpenses[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Prior Period]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Prior Period]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Prior Period]],OperatingExpenses[[#This Row],[Prior Period]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Budget]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Budget]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Budget]],OperatingExpenses[[#This Row],[Budget]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"General and administrative","Other expenses (specify)",{"$nulls":3},{"$f":"IFERROR(IF(Sales_Revenue=0,\"-\",OperatingExpenses[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Prior Period]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Prior Period]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Prior Period]],OperatingExpenses[[#This Row],[Prior Period]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[Budget]]=OperatingExpenses[[#This Row],[Current Period]],0,IF(OperatingExpenses[[#This Row],[Current Period]]>OperatingExpenses[[#This Row],[Budget]],ABS((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),IF(AND(OperatingExpenses[[#This Row],[Current Period]]<OperatingExpenses[[#This Row],[Budget]],OperatingExpenses[[#This Row],[Budget]]<0),-((OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1),(OperatingExpenses[[#This Row],[Current Period]]/OperatingExpenses[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"Total Operating Expenses",null,{"$f":"SUBTOTAL(109,OperatingExpenses[Prior Period])","v":0},{"$f":"SUBTOTAL(109,OperatingExpenses[Budget])","v":0},{"$f":"SUBTOTAL(109,OperatingExpenses[Current Period])","v":0},{"$f":"SUBTOTAL(109,OperatingExpenses[Current Period as % of Sales])","v":{"v":0,"d":"0.00%"}},{"$f":"SUBTOTAL(109,OperatingExpenses[% Change from Prior Period])","v":{"v":0,"d":"0.00%"}},{"$f":"SUBTOTAL(109,OperatingExpenses[% Change from Budget])","v":{"v":0,"d":"0.00%"}}]

{"sheet":"Taxes","index":4,"n_rows":10,"n_cols":9,"rows_kept":10,"merged":[[0,7,2,8]]}
[null,{"$f":"Workbook_Title","v":"Profit and loss statement"}]
[null,{"$f":"Company_Name","v":"Company name"},"Stated in 000s"]
[null,"Taxes",{"$f":"IFERROR(Taxes[[#Totals],[Current Period]],\"-\")","v":0}]
[null,"Type","Description","Prior Period","Budget","Current Period","Current Period as % of Sales","% Change from Prior Period","% Change from Budget"]
[null,"Taxes","Income taxes",{"$nulls":3},{"$f":"IFERROR(IF(Sales_Revenue=0,\"-\",Taxes[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(Taxes[[#This Row],[Prior Period]]=Taxes[[#This Row],[Current Period]],0,IF(Taxes[[#This Row],[Current Period]]>Taxes[[#This Row],[Prior Period]],ABS((Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Prior Period]])-1),IF(AND(Taxes[[#This Row],[Current Period]]<Taxes[[#This Row],[Prior Period]],Taxes[[#This Row],[Prior Period]]<0),-((Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Prior Period]])-1),(Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(Taxes[[#This Row],[Budget]]=Taxes[[#This Row],[Current Period]],0,IF(Taxes[[#This Row],[Current Period]]>Taxes[[#This Row],[Budget]],ABS((Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Budget]])-1),IF(AND(Taxes[[#This Row],[Current Period]]<Taxes[[#This Row],[Budget]],Taxes[[#This Row],[Budget]]<0),-((Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Budget]])-1),(Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"Taxes","Payroll taxes",{"$nulls":3},{"$f":"IFERROR(IF(Sales_Revenue=0,\"-\",Taxes[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(Taxes[[#This Row],[Prior Period]]=Taxes[[#This Row],[Current Period]],0,IF(Taxes[[#This Row],[Current Period]]>Taxes[[#This Row],[Prior Period]],ABS((Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Prior Period]])-1),IF(AND(Taxes[[#This Row],[Current Period]]<Taxes[[#This Row],[Prior Period]],Taxes[[#This Row],[Prior Period]]<0),-((Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Prior Period]])-1),(Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(Taxes[[#This Row],[Budget]]=Taxes[[#This Row],[Current Period]],0,IF(Taxes[[#This Row],[Current Period]]>Taxes[[#This Row],[Budget]],ABS((Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Budget]])-1),IF(AND(Taxes[[#This Row],[Current Period]]<Taxes[[#This Row],[Budget]],Taxes[[#This Row],[Budget]]<0),-((Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Budget]])-1),(Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"Taxes","Stamp duty land tax",{"$nulls":3},{"$f":"IFERROR(IF(Sales_Revenue=0,\"-\",Taxes[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(Taxes[[#This Row],[Prior Period]]=Taxes[[#This Row],[Current Period]],0,IF(Taxes[[#This Row],[Current Period]]>Taxes[[#This Row],[Prior Period]],ABS((Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Prior Period]])-1),IF(AND(Taxes[[#This Row],[Current Period]]<Taxes[[#This Row],[Prior Period]],Taxes[[#This Row],[Prior Period]]<0),-((Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Prior Period]])-1),(Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(Taxes[[#This Row],[Budget]]=Taxes[[#This Row],[Current Period]],0,IF(Taxes[[#This Row],[Current Period]]>Taxes[[#This Row],[Budget]],ABS((Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Budget]])-1),IF(AND(Taxes[[#This Row],[Current Period]]<Taxes[[#This Row],[Budget]],Taxes[[#This Row],[Budget]]<0),-((Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Budget]])-1),(Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"Taxes","Other taxes (specify)",{"$nulls":3},{"$f":"IFERROR(IF(Sales_Revenue=0,\"-\",Taxes[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(Taxes[[#This Row],[Prior Period]]=Taxes[[#This Row],[Current Period]],0,IF(Taxes[[#This Row],[Current Period]]>Taxes[[#This Row],[Prior Period]],ABS((Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Prior Period]])-1),IF(AND(Taxes[[#This Row],[Current Period]]<Taxes[[#This Row],[Prior Period]],Taxes[[#This Row],[Prior Period]]<0),-((Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Prior Period]])-1),(Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(Taxes[[#This Row],[Budget]]=Taxes[[#This Row],[Current Period]],0,IF(Taxes[[#This Row],[Current Period]]>Taxes[[#This Row],[Budget]],ABS((Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Budget]])-1),IF(AND(Taxes[[#This Row],[Current Period]]<Taxes[[#This Row],[Budget]],Taxes[[#This Row],[Budget]]<0),-((Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Budget]])-1),(Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"Taxes","Other taxes (specify)",{"$nulls":3},{"$f":"IFERROR(IF(Sales_Revenue=0,\"-\",Taxes[Current Period]/Sales_Revenue),\"-\")","v":"-"},{"$f":"IFERROR(IF(Taxes[[#This Row],[Prior Period]]=Taxes[[#This Row],[Current Period]],0,IF(Taxes[[#This Row],[Current Period]]>Taxes[[#This Row],[Prior Period]],ABS((Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Prior Period]])-1),IF(AND(Taxes[[#This Row],[Current Period]]<Taxes[[#This Row],[Prior Period]],Taxes[[#This Row],[Prior Period]]<0),-((Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Prior Period]])-1),(Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Prior Period]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(Taxes[[#This Row],[Budget]]=Taxes[[#This Row],[Current Period]],0,IF(Taxes[[#This Row],[Current Period]]>Taxes[[#This Row],[Budget]],ABS((Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Budget]])-1),IF(AND(Taxes[[#This Row],[Current Period]]<Taxes[[#This Row],[Budget]],Taxes[[#This Row],[Budget]]<0),-((Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Budget]])-1),(Taxes[[#This Row],[Current Period]]/Taxes[[#This Row],[Budget]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"Total taxes",null,{"$f":"SUBTOTAL(109,Taxes[Prior Period])","v":0},{"$f":"SUBTOTAL(109,Taxes[Budget])","v":0},{"$f":"SUBTOTAL(109,Taxes[Current Period])","v":0},{"$f":"IFERROR(SUBTOTAL(109,Taxes[Current Period as % of Sales]),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUBTOTAL(109,Taxes[% Change from Prior Period])","v":{"v":0,"d":"0.00%"}},{"$f":"SUBTOTAL(109,Taxes[% Change from Budget])","v":{"v":0,"d":"0.00%"}}]

{"sheet":"Categories","index":5,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"Categories"]
[null,"Sales Revenue"]
[null,"Cost of Sales"]
[null,"Income"]
[null,"Sales and marketing"]
[null,"Research and development"]
[null,"General and administrative"]
[null,"Taxes"]