{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":76,"n_cols":9,"rows_kept":76,"merged":[[5,5,5,6],[12,5,12,6],[18,0,18,2],[25,0,25,2],[34,0,34,2],[47,0,47,2],[59,0,59,2],[67,0,67,2]]}
[]
[]
[]
[]
[]
["FUNDING","Estimated","Actual","Difference"]
["Investor funding",400,600,{"$f":"Sheet1!$B7-Sheet1!$C7","v":{"v":-200,"d":"-$200.00"}}]
["Owner 1",null,null,{"$f":"Sheet1!$B8-Sheet1!$C8","v":{"v":0,"d":"$0.00"}}]
["Owner 2",null,null,{"$f":"Sheet1!$B9-Sheet1!$C9","v":{"v":0,"d":"$0.00"}}]
["Other",null,null,{"$f":"Sheet1!$B10-Sheet1!$C10","v":{"v":0,"d":"$0.00"}}]
["Loan funding",null,null,{"$f":"Sheet1!$B11-Sheet1!$C11","v":{"v":0,"d":"$0.00"}}]
["Bank loan",null,null,{"$f":"Sheet1!$B12-Sheet1!$C12","v":{"v":0,"d":"$0.00"}}]
["Non-bank loan",null,null,{"$f":"Sheet1!$B13-Sheet1!$C13","v":{"v":0,"d":"$0.00"}}]
["Other funding",null,null,{"$f":"Sheet1!$B14-Sheet1!$C14","v":{"v":0,"d":"$0.00"}}]
["Grant",null,null,{"$f":"Sheet1!$B15-Sheet1!$C15","v":{"v":0,"d":"$0.00"}}]
["Other",null,null,{"$f":"Sheet1!$B16-Sheet1!$C16","v":{"v":0,"d":"$0.00"}}]
["TOTAL FUNDING",{"$f":"SUM(Sheet1!$B$7:$B$16)","v":400},{"$f":"SUM(Sheet1!$C$7:$C$16)","v":600},{"$f":"SUM(Sheet1!$D$7:$D$16)","v":-200}]
[]
["PRE-OPEN COSTS AT A GLANCE",{"$nulls":4},"AVERAGE MONTHLY COSTS","Estimated","Actual","Difference"]
["Administration Costs",{"$f":"SUM(Sheet1!$C$28:$C$31)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},"Advertising ",800,600,{"$f":"Table29[[#This Row],[Estimated]]-Table29[[#This Row],[Actual]]","v":{"v":200,"d":"$200.00"}}]
["Office Costs",{"$f":"SUM(Sheet1!$C$37:$C$45)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},"Business Insurance",null,null,{"$f":"Table29[[#This Row],[Estimated]]-Table29[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
["Marketing Costs",{"v":0,"d":"$0.00"},"TOTAL",null,null,"Business Vehicle Insurance",null,null,{"$f":"Table29[[#This Row],[Estimated]]-Table29[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
["Pre-Opening Labor  Costs",{"v":0,"d":"$0.00"},{"$f":"SUM(B20:B24)","v":{"v":0,"d":"$0.00"}},null,null,"Employee Salaries and Commissions",null,null,{"$f":"Table29[[#This Row],[Estimated]]-Table29[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
["Miscellaneous",{"v":0,"d":"$0.00"},{"$nulls":3},"Equipment Lease Payments",null,null,{"$f":"Table29[[#This Row],[Estimated]]-Table29[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":5},"Inventory, raw materials, parts",null,null,{"$f":"Table29[[#This Row],[Estimated]]-Table29[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
["ADMINISTRATION COSTS",{"$nulls":4},"Franchise Fee",null,null,{"$f":"Table29[[#This Row],[Estimated]]-Table29[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
["ITEM","DUE BY DATE","AMOUNT","PRICE",null,"Health Insurance",null,null,{"$f":"Table29[[#This Row],[Estimated]]-Table29[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
["Licenses and permits",{"$nulls":4},"Internet Connection",null,null,{"$f":"Table29[[#This Row],[Estimated]]-Table29[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
["Business Insurance",{"$nulls":4},"Loan and Credit Card Fees",null,null,{"$f":"Table29[[#This Row],[Estimated]]-Table29[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
["Legal fees",{"$nulls":4},"Legal/Accounting Fees",null,null,{"$f":"Table29[[#This Row],[Estimated]]-Table29[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
["Franchise fee",{"$nulls":4},"Merchant Account Fees",null,null,{"$f":"Table29[[#This Row],[Estimated]]-Table29[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
["Total",null,null,{"$f":"SUM(D28*C28+D29*C29+D30*C30+D31*C31)","v":{"v":0,"d":"$0.00"}},null,"Miscellaneous Expenses",null,null,{"$f":"Table29[[#This Row],[Estimated]]-Table29[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"$f":"Table29[[#This Row],[Estimated]]-Table29[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":5},"Mortgage Payments",null,null,{"$f":"Table29[[#This Row],[Estimated]]-Table29[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
["OFFICE COSTS",{"$nulls":4},"Lease Payment",null,null,{"$f":"Table29[[#This Row],[Estimated]]-Table29[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
["ITEM","DUE BY DATE","AMOUNT","PRICE",null,"Owner Salary",null,null,{"$f":"Table29[[#This Row],[Estimated]]-Table29[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
["Security system installation",{"$nulls":4},"Payroll taxes ",null,null,{"$f":"Table29[[#This Row],[Estimated]]-Table29[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
["Internet setup desposit",{"$nulls":4},"Postage/Shipping Costs",null,null,{"$f":"Table29[[#This Row],[Estimated]]-Table29[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
["Office furniture",{"$nulls":4},"Security System Monthly Payment",null,null,{"$f":"Table29[[#This Row],[Estimated]]-Table29[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
["Rent",{"$nulls":4},"Supplies",null,null,{"$f":"Table29[[#This Row],[Estimated]]-Table29[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
["Installation fees",{"$nulls":4},"Telephone",null,null,{"$f":"Table29[[#This Row],[Estimated]]-Table29[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
["Inventory",{"$nulls":4},"Travel",null,null,{"$f":"Table29[[#This Row],[Estimated]]-Table29[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
["Telephone",{"$nulls":4},"Public Utilities",null,null,{"$f":"Table29[[#This Row],[Estimated]]-Table29[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
["   Hardware/Software",{"$nulls":4},"Website Hosting/Maintenance",null,null,{"$f":"Table29[[#This Row],[Estimated]]-Table29[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
["   Office stationery",{"$nulls":4},"Other 1 (specify)",null,null,{"$f":"Table29[[#This Row],[Estimated]]-Table29[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
["Total",null,null,{"$f":"SUM(D37*C37+D38*C38+D39*C39+D40*C40+D41*C41+D42*C42+D43*C43+D44*C44+D45*C45)","v":0},null,"Other 2 (specify)",null,null,{"$f":"Table29[[#This Row],[Estimated]]-Table29[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[]
["MARKETING COSTS",{"$nulls":4},"TOTAL AVERAGE MONTHLY COSTS"]
["ITEM","DUE BY DATE","AMOUNT","PRICE",null,null,{"$f":"SUM(Table29[Estimated])","v":800},{"$f":"SUM(Table29[Actual])","v":600},{"$f":"SUM(Table29[Difference])","v":200}]
["Advertising for opening"]
["Basic Website"]
["Logo design"]
["Flyers and brochures"]
["Business cards"]
["Promotional materials"]
["Yellow Pages"]
["  Internet marketing"]
["Total",null,null,{"$f":"SUM(D50*C50+D51*C51+D52*C52+D53*C53+D54*C54+D55*C55+D56*C56+D57*C57)","v":0}]
[]
["PRE-OPENING LABOR COSTS"]
["ITEM","DUE BY DATE","AMOUNT","PRICE"]
["HR agency fee"]
["Job ad placement fee"]
["Training costs"]
["Other"]
["Total",null,null,{"$f":"SUM(D62*C62+D63*C63+D64*C64+D65*C65)","v":0}]
[]
["MISCELLANEOUS"]
["ITEM","DUE BY DATE","AMOUNT","PRICE"]
["Contingencies Reserve"]
["Decorations"]
["Food and beverages for the opening day"]
["Other"]
["Total",null,null,{"$f":"SUM(D70*C70+D71*C71+D72*C72+D73*C73)","v":0}]
[]
["TOTAL PRE-OPEN COSTS",null,null,{"$f":"SUM(D74+D66+D58+D46+D32)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}