{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["SWOT","RISK","P&L","PLAN","FUNDING"],"read":"whole","date_system":"1900"}

{"sheet":"SWOT","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"merged":[[4,2,11,2],[12,2,19,2]]}
[]
[]
[]
[{"$nulls":3},"Positive","Negative"]
[null,null,"Internal","Strengths","Weaknesses"]
{"$rows_empty":7}
[null,null,"External","Opportunities","Threats"]

{"sheet":"RISK","index":1,"n_rows":2,"n_cols":8,"rows_kept":2}
["Risk","Impact (e.g. Cost, Schedule, Technical)","Likelihood of occurrence ","Severity of consequences ","Risk Magnitude","Precaution Measures","Mitigation plan","Cost of risk mitigation (low, moderate, high)"]
[null,null,"risk levels: please use colour codes and indicate low/moderate/high "]

{"sheet":"P&L","index":2,"n_rows":51,"n_cols":5,"rows_kept":51}
[null,"Year -1","Year 1","Year 2","Year 3"]
[null,"€","€","€","€"]
["Sales Revenue"]
["Product/Service 1"]
["Product/Service 2"]
["…"]
["Product/Service n"]
["Total Sales Revenue  [J]",{"$f":"SUM(B4:B7)","v":0},{"$f":"SUM(C4:C7)","v":0},{"$f":"SUM(D4:D7)","v":0},{"$f":"SUM(E4:E7)","v":0}]
["Direct cost of Sales"]
["Product/Service 1"]
["Product/Service 2"]
["….."]
["Product/Service 4"]
["Total Cost of Sales  [K]",{"$f":"SUM(B10:B13)","v":0},{"$f":"SUM(C10:C13)","v":0},{"$f":"SUM(D10:D13)","v":0},{"$f":"SUM(E10:E13)","v":0}]
["Gross Profit  [L=J-K]",{"$f":"+B8-B14","v":0},{"$f":"+C8-C14","v":0},{"$f":"+D8-D14","v":0},{"$f":"+E8-E14","v":0}]
["Operating Expenses"]
["Sales and Marketing"]
["Advertising"]
["Direct marketing"]
["Other expenses (specify)"]
["Total Sales and Marketing Expenses  [M]",{"$f":"SUM(B18:B20)","v":0},{"$f":"SUM(C18:C20)","v":0},{"$f":"SUM(D18:D20)","v":0},{"$f":"SUM(E18:E20)","v":0}]
[]
["Research and Development"]
["Technology licenses"]
["Patents "]
["Other expenses (specify)"]
["Total Research and Development Expenses  [N]",{"$f":"SUM(B24:B26)","v":0},{"$f":"SUM(C24:C26)","v":0},{"$f":"SUM(D24:D26)","v":0},{"$f":"SUM(E24:E26)","v":0}]
[]
["General and Adminstrative"]
["Wages and salaries"]
["Outside services"]
["Meals and entertainment"]
["Rent"]
["Telephone"]
["Utilities"]
["Depreciation"]
["Insurance"]
["Repairs and maintenance"]
["Other expenses (specify)"]
["Total General and Adminstrative Expenses  [O]",{"$f":"SUM(B30:B39)","v":0},{"$f":"SUM(C30:C39)","v":0},{"$f":"SUM(D30:D39)","v":0},{"$f":"SUM(E30:E39)","v":0}]
["Total Operating Expenses  [P=M+N+O]",{"$f":"+B21+B27+B40","v":0},{"$f":"+C21+C27+C40","v":0},{"$f":"+D21+D27+D40","v":0},{"$f":"+E21+E27+E40","v":0}]
[]
["Income from Operations  [Q=L-P]",{"$f":"+B15-B41","v":0},{"$f":"+C15-C41","v":0},{"$f":"+D15-D41","v":0},{"$f":"+E15-E41","v":0}]
[]
["Other Income  [R]"]
[]
["Taxes"]
["Taxes"]
["Total Taxes  [S]",{"$f":"SUM(B48)","v":0},{"$f":"SUM(C48)","v":0},{"$f":"SUM(D48)","v":0},{"$f":"SUM(E48)","v":0}]
[]
["Net Profit  [T=Q+R-S]",{"$f":"+B43+B45-B48","v":0},{"$f":"+C43+C45-C48","v":0},{"$f":"+D43+D45-D48","v":0},{"$f":"+E43+E45-E48","v":0}]

{"sheet":"PLAN","index":3,"n_rows":15,"n_cols":15,"rows_kept":15,"merged":[[0,0,0,14],[2,0,3,0],[2,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2]]}
["INCUBATION TIME "]
[null,null,"Months",1,2,3,4,5,6,7,8,9,10,11,"…"]
["Task","MILESTONES / MEETINGS",null,"KO",{"$nulls":5},"MTR",{"$nulls":4},"FR"]
[]
["Task 1","e.g Design studies …"]
["Task 2","e.g Design experiments …"]
["Task 3","e.g Engineering design …"]
["Task 4","e.g Performance analysis …"]
["Task 5","e.g Market studies …"]
["Task 6","e.g Business Plan …"]
["Task 7","e.g IPR studies …"]
["…","e.g  Management …"]
[{"$nulls":12},"KO= Kick Off"]
[{"$nulls":12},"MTR= Mid Term Review"]
[{"$nulls":12},"FR= Final Review"]

{"sheet":"FUNDING","index":4,"n_rows":9,"n_cols":11,"rows_kept":9,"merged":[[0,0,1,0],[0,1,0,3],[0,4,1,4],[0,5,0,8],[0,9,1,9]]}
["TASKS","COSTS (€)",null,null,"TOTAL COSTS (€)","FUNDING (€)",{"$nulls":3},"TOTAL FUNDING (€)","COST"]
[null,"Product development","IPR Management","other",null,"Incentive ESA","Incentive local","Loan request","Other sources",null,"Experts (hour)"]
["Task 1",{"$nulls":3},{"$f":"SUM(B3:D3)","v":{"v":0,"d":"0 €"}},{"$nulls":4},{"$f":"SUM(F3:I3)","v":{"v":0,"d":"0 €"}}]
["Task 2",{"$nulls":3},{"$f":"SUM(B4:D4)","v":{"v":0,"d":"0 €"}},{"$nulls":4},{"$f":"SUM(F4:I4)","v":{"v":0,"d":"0 €"}}]
["Task 3",{"$nulls":3},{"v":0,"d":"0 €"},{"$nulls":4},{"$f":"SUM(F5:I5)","v":{"v":0,"d":"0 €"}}]
["Task 4",{"$nulls":3},{"v":0,"d":"0 €"},{"$nulls":4},{"$f":"SUM(F6:I6)","v":{"v":0,"d":"0 €"}}]
["Task 5",{"$nulls":3},{"v":0,"d":"0 €"},{"$nulls":4},{"v":0,"d":"0 €"}]
["….",{"$nulls":3},{"v":0,"d":"0 €"},{"$nulls":4},{"v":0,"d":"0 €"}]
["TOTAL",{"$f":"SUM(B3:B8)","v":{"v":0,"d":"0 €"}},{"$f":"SUM(C3:C8)","v":{"v":0,"d":"0 €"}},{"$f":"SUM(D3:D8)","v":{"v":0,"d":"0 €"}},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},0]