{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Monthly Comparison","Quarter Comparison","QUARTER","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Monthly Comparison","index":0,"n_rows":78,"n_cols":7,"rows_kept":78,"cut":false,"hidden":false,"merged":[[0,0,0,6],[16,0,16,6],[32,0,32,6],[48,0,48,6],[64,0,64,6]]}
["All Crown Stores - Actual"]
[0,null,null,null,null,{"$f":"Data!A4","v":"March"}]
[null,"Income",null,null,null,{"$f":"SUM(F19,F35,F51,F67)","v":0}]
[null,"COGS (Materials & Shipping)",null,null,null,{"$f":"SUM(F20,F36,F52,F68)","v":0},{"$f":"F4/$F$3","v":{"$error":"#DIV/0!"}}]
[null,"Gross Profit",null,null,null,0,{"$f":"F5/$F$3","v":{"$error":"#DIV/0!"}}]
[null,null,"Franchise Fees",null,null,0,{"$error":"#DIV/0!"}]
[null,null,"Marketing & Advertising",null,null,0,{"$error":"#DIV/0!"}]
[null,null,"Merchant Fees",null,null,0,{"$error":"#DIV/0!"}]
[null,null,"Payroll ",null,null,0,{"$error":"#DIV/0!"}]
[null,null,"Rent",null,null,0,{"$error":"#DIV/0!"}]
[null,null,"Utilities",null,null,0,{"$error":"#DIV/0!"}]
[null,null,"Other Expenses",null,null,0,{"$error":"#DIV/0!"}]
[null,"Total Expenses",null,null,null,0,{"$error":"#DIV/0!"}]
[null,"Net Income",null,null,null,0,{"$error":"#DIV/0!"}]
[]
[]
[{"$f":"IF(B19=\"\",\"\",Data!G2 & \" Actual Data\")","v":""}]
[null,null,null,null,null,{"$f":"IF(B19=\"\",\"\",Data!A4)","v":""}]
[]
[null,null,null,null,null,null,{"$f":"IF($F$19=\"\",\"\",F20/$F$19)","v":""}]
[null,null,null,null,null,null,{"$f":"IF($F$19=\"\",\"\",F21/$F$19)","v":""}]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[]
[]
[{"$f":"IF(B35=\"\",\"\",Data!G4 & \" Actual Data\")","v":""}]
[null,null,null,null,null,{"$f":"IF('Monthly Comparison'!B35=\"\",\"\",Data!$A$4)","v":""}]
[]
[null,null,null,null,null,null,{"$f":"IF($F$35=\"\",\"\",F36/$F$35)","v":""}]
[null,null,null,null,null,null,{"$f":"IF($F$35=\"\",\"\",F37/$F$35)","v":""}]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[]
[]
[{"$f":"IF(B51=\"\",\"\",Data!G6 & \" Actual Data\")","v":""}]
[null,null,null,null,null,{"$f":"IF(B51=\"\",\"\",Data!A4)","v":""}]
[]
[null,null,null,null,null,null,{"$f":"IF($F$51=\"\",\"\",F52/$F$51)","v":""}]
[null,null,null,null,null,null,{"$f":"IF($F$51=\"\",\"\",F53/$F$51)","v":""}]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[]
[]
[{"$f":"IF(B67=\"\",\"\",Data!G8 & \" Actual Data\")","v":""}]
[null,null,null,null,null,{"$f":"IF(B67=\"\",\"\",Data!A4)","v":""}]
[]
[null,null,null,null,null,null,{"$f":"IF($F$67=\"\",\"\",F68/$F$67)","v":""}]
[null,null,null,null,null,null,{"$f":"IF($F$67=\"\",\"\",F69/$F$67)","v":""}]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]

{"sheet":"Quarter Comparison","index":1,"n_rows":78,"n_cols":29,"rows_kept":78,"cut":false,"hidden":false,"merged":[[64,0,64,12],[0,0,0,12],[16,0,16,12],[32,0,32,12],[48,0,48,12],[0,14,0,26],[16,14,16,26],[32,14,32,26],[48,14,48,26],[64,14,64,26]]}
["All Crown Stores - Actual",null,null,null,null,null,null,null,null,null,null,null,null,null,"All Crown Stores - Projected"]
[0,null,null,{"$f":"Data!H2","v":"Q2"},null,{"$f":"Data!H4","v":"Q3"},null,{"$f":"Data!H6","v":"Q4"},null,{"$f":"Data!H8","v":"Q1"},null,"TOTAL",null,null,null,null,null,{"$f":"Data!H2","v":"Q2"},null,{"$f":"Data!H4","v":"Q3"},null,{"$f":"Data!H6","v":"Q4"},null,{"$f":"Data!H8","v":"Q1"},null,"TOTAL"]
["Income",null,null,{"$f":"SUM(D19,D35,D51,D67)","v":0},null,{"$f":"SUM(F19,F35,F51,F67)","v":0},null,0,null,0,null,{"$f":"SUM(D3,F3,H3,J3)","v":0},null,null,"Income",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X3,V3,T3,R3)","v":0}]
["COGS (Materials & Shipping)",null,null,{"$f":"SUM(D20,D36,D52,D68)","v":0},{"$f":"(D4/$D$3)","v":{"$error":"#DIV/0!"}},0,{"$f":"F4/F3","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H20,H36,H52,H68)","v":0},{"$f":"H4/H3","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J20,J36,J52,J68)","v":0},{"$f":"J4/J3","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D4,F4,H4,J4)","v":0},{"$f":"L4/L3","v":{"$error":"#DIV/0!"}},null,"COGS (Materials & Shipping)",null,null,null,{"$f":"R4/$R$3","v":{"$error":"#DIV/0!"}},null,{"$f":"T4/$T$3","v":{"$error":"#DIV/0!"}},null,{"$f":"V4/$V$3","v":{"$error":"#DIV/0!"}},null,{"$f":"X4/$X$3","v":{"$error":"#DIV/0!"}},{"$f":"SUM(X4,V4,T4,R4)","v":0},{"$f":"Z4/$Z$3","v":{"$error":"#DIV/0!"}}]
["Gross Profit",null,null,0,{"$f":"D5/$D$3","v":{"$error":"#DIV/0!"}},0,{"$f":"F5/F3","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H21,H37,H53,H69)","v":0},{"$f":"H5/H3","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J21,J37,J53,J69)","v":0},{"$f":"J5/J3","v":{"$error":"#DIV/0!"}},0,{"$f":"L5/L3","v":{"$error":"#DIV/0!"}},null,"Gross Profit",null,null,null,{"$f":"R5/$R$3","v":{"$error":"#DIV/0!"}},null,{"$f":"T5/$T$3","v":{"$error":"#DIV/0!"}},null,{"$f":"V5/$V$3","v":{"$error":"#DIV/0!"}},null,{"$f":"X5/$X$3","v":{"$error":"#DIV/0!"}},0,{"$f":"Z5/$Z$3","v":{"$error":"#DIV/0!"}}]
[null,"Franchise Fees",null,0,{"$error":"#DIV/0!"},0,{"$f":"F6/F3","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H22,H38,H54,H70)","v":0},{"$f":"H6/H3","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J22,J38,J54,J70)","v":0},{"$f":"J6/J3","v":{"$error":"#DIV/0!"}},0,{"$f":"L6/L3","v":{"$error":"#DIV/0!"}},null,null,"Franchise Fees",null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,"Marketing & Advertising",null,0,{"$error":"#DIV/0!"},0,{"$f":"F7/F3","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H23,H39,H55,H71)","v":0},{"$f":"H7/H3","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J23,J39,J55,J71)","v":0},{"$f":"J7/J3","v":{"$error":"#DIV/0!"}},0,{"$f":"L7/L3","v":{"$error":"#DIV/0!"}},null,null,"Marketing & Advertising",null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,"Merchant Fees",null,0,{"$error":"#DIV/0!"},0,{"$f":"F8/F3","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H24,H40,H56,H72)","v":0},{"$f":"H8/H3","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J24,J40,J56,J72)","v":0},{"$f":"J8/J3","v":{"$error":"#DIV/0!"}},0,{"$f":"L8/L3","v":{"$error":"#DIV/0!"}},null,null,"Merchant Fees",null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,"Payroll ",null,0,{"$error":"#DIV/0!"},0,{"$f":"F9/F3","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H25,H41,H57,H73)","v":0},{"$f":"H9/H3","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J25,J41,J57,J73)","v":0},{"$f":"J9/J3","v":{"$error":"#DIV/0!"}},0,{"$f":"L9/L3","v":{"$error":"#DIV/0!"}},null,null,"Payroll ",null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,"Rent",null,0,{"$error":"#DIV/0!"},0,{"$f":"F10/F3","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H26,H42,H58,H74)","v":0},{"$f":"H10/H3","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J26,J42,J58,J74)","v":0},{"$f":"J10/J3","v":{"$error":"#DIV/0!"}},0,{"$f":"L10/L3","v":{"$error":"#DIV/0!"}},null,null,"Rent",null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,"Utilities",null,0,{"$error":"#DIV/0!"},0,{"$f":"F11/F3","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H27,H43,H59,H75)","v":0},{"$f":"H11/H3","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J27,J43,J59,J75)","v":0},{"$f":"J11/J3","v":{"$error":"#DIV/0!"}},0,{"$f":"L11/L3","v":{"$error":"#DIV/0!"}},null,null,"Utilities",null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,"Other Expenses",null,0,{"$error":"#DIV/0!"},0,{"$f":"F12/F3","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H28,H44,H60,H76)","v":0},{"$f":"H12/H3","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J28,J44,J60,J76)","v":0},{"$f":"J12/J3","v":{"$error":"#DIV/0!"}},0,{"$f":"L12/L3","v":{"$error":"#DIV/0!"}},null,null,"Other Expenses",null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
["Total Expenses",null,null,0,{"$error":"#DIV/0!"},0,{"$f":"F13/F3","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H29,H45,H61,H77)","v":0},{"$f":"H13/H3","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J29,J45,J61,J77)","v":0},{"$f":"J13/J3","v":{"$error":"#DIV/0!"}},0,{"$f":"L13/L3","v":{"$error":"#DIV/0!"}},null,"Total Expenses",null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
["Net Income",null,null,0,{"$error":"#DIV/0!"},0,{"$f":"F14/F3","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H30,H46,H62,H78)","v":0},{"$f":"H14/H3","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J30,J46,J62,J78)","v":0},{"$f":"J14/J3","v":{"$error":"#DIV/0!"}},0,{"$f":"L14/L3","v":{"$error":"#DIV/0!"}},null,"Net Income",null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[]
[]
[{"$f":"IF(A19=\"\",\"\",Data!G2 & \" Actual Data\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A19=\"\",\"\",Data!G2 & \" Projected Data\")","v":""}]
[null,null,null,{"$f":"D2","v":"Q2"},null,{"$f":"F2","v":"Q3"},null,{"$f":"H2","v":"Q4"},null,{"$f":"J2","v":"Q1"},null,"TOTAL",null,null,null,null,null,{"$f":"D18","v":"Q2"},null,{"$f":"F18","v":"Q3"},null,"Q4",null,"Q1",null,"TOTAL"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$19=\"\",\"\",SUM(D19,F19,H19,J19))","v":""},null,null,{"$f":"IF(A19=\"\",\"\",\"Income\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,{"$f":"IF($D$19=\"\",\"\",D20/$D$19)","v":""},null,{"$f":"IF($F$19=\"\",\"\",F20/$F$19)","v":""},null,{"$f":"IF($H$19=\"\",\"\",H20/$H$19)","v":""},null,{"$f":"IF($J$19=\"\",\"\",J20/$J$19)","v":""},{"$f":"IF($D$19=\"\",\"\",SUM(D20,F20,H20,J20))","v":""},{"$f":"IF($L$19=\"\",\"\",L20/$L$19)","v":""},null,{"$f":"IF(A19=\"\",\"\",\"COGS (Materials & Shipping)\")","v":""}]
[null,null,null,null,{"$f":"IF($D$19=\"\",\"\",D21/$D$19)","v":""},null,{"$f":"IF($F$19=\"\",\"\",F21/$F$19)","v":""},null,{"$f":"IF($H$19=\"\",\"\",H21/$H$19)","v":""},null,{"$f":"IF($J$19=\"\",\"\",J21/$J$19)","v":""},"",{"$f":"IF($L$19=\"\",\"\",L21/$L$19)","v":""},null,{"$f":"IF(A19=\"\",\"\",\"Gross Profit\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A19=\"\",\"\",\"Franchise Fees\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A19=\"\",\"\",\"Marketing & Advertising\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A19=\"\",\"\",\"Merchant Fees\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A19=\"\",\"\",\"Payroll\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A19=\"\",\"\",\"Rent\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A19=\"\",\"\",\"Utilities\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A19=\"\",\"\",\"Other Expenses\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,{"$f":"IF(A19=\"\",\"\",\"Total Expenses\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,{"$f":"IF(A19=\"\",\"\",\"Net Income\")","v":""}]
[]
[]
[{"$f":"IF(A35=\"\",\"\",Data!G4 & \" Actual Data\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A35=\"\",\"\",Data!G4 & \" Projected Data\")","v":""}]
[null,null,null,{"$f":"IF(A35=\"\",\"\",D18)","v":""},null,{"$f":"IF(A35=\"\",\"\",F18)","v":""},null,{"$f":"IF(A35=\"\",\"\",H18)","v":""},null,{"$f":"IF(A35=\"\",\"\",J18)","v":""},null,{"$f":"IF(A35=\"\",\"\",L18)","v":""},null,null,null,null,null,{"$f":"IF(A35=\"\",\"\",R18)","v":""},null,{"$f":"IF(A35=\"\",\"\",T18)","v":""},null,{"$f":"IF(A35=\"\",\"\",V18)","v":""},null,{"$f":"IF(A35=\"\",\"\",X18)","v":""},null,{"$f":"IF(A35=\"\",\"\",Z18)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$35=\"\",\"\",SUM(D35,F35,H35,J35))","v":""},null,null,{"$f":"IF(A35=\"\",\"\",\"Income\")","v":""}]
[null,null,null,null,{"$f":"IF($D$35=\"\",\"\",D36/$D$35)","v":""},null,{"$f":"IF($F$35 = \"\",\"\",F36/$F$35)","v":""},null,{"$f":"IF($H$35=\"\",\"\",H36/$H$35)","v":""},null,{"$f":"IF($J$35 = \"\",\"\",J36/$J$35)","v":""},{"$f":"IF($D$35=\"\",\"\",SUM(D36,F36,H36,J36))","v":""},{"$f":"IF($D$35=\"\",\"\",L36/$L$35)","v":""},null,{"$f":"IF(A35=\"\",\"\",\"COGS (Materials & Shipping)\")","v":""}]
[null,null,null,null,{"$f":"IF($D$35=\"\",\"\",D37/$D$35)","v":""},null,{"$f":"IF($F$35 = \"\",\"\",F37/$F$35)","v":""},null,{"$f":"IF($H$35=\"\",\"\",H37/$H$35)","v":""},null,{"$f":"IF($J$35 = \"\",\"\",J37/$J$35)","v":""},"",{"$f":"IF($D$35=\"\",\"\",L37/$L$35)","v":""},null,{"$f":"IF(A35=\"\",\"\",\"Gross Profit\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A35=\"\",\"\",\"Franchise Fees\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A35=\"\",\"\",\"Marketing & Advertising\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A35=\"\",\"\",\"Merchant Fees\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A35=\"\",\"\",\"Payroll\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A35=\"\",\"\",\"Rent\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A35=\"\",\"\",\"Utilities\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A35=\"\",\"\",\"Other Expenses\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,{"$f":"IF(A35=\"\",\"\",\"Total Expenses\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,{"$f":"IF(A35=\"\",\"\",\"Net Income\")","v":""}]
[]
[]
[{"$f":"IF(A51=\"\",\"\",Data!G6 & \" Actual Data\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A51=\"\",\"\",Data!G6 & \" Projected Data\")","v":""}]
[null,null,null,{"$f":"IF($A$51=\"\",\"\",D34)","v":""},null,{"$f":"IF($A$51=\"\",\"\",F34)","v":""},null,"",null,"",null,"",null,null,null,null,null,{"$f":"IF(A51=\"\",\"\",R34)","v":""},null,{"$f":"IF(A51=\"\",\"\",T34)","v":""},null,{"$f":"IF(A51=\"\",\"\",V34)","v":""},null,{"$f":"IF(A51=\"\",\"\",X34)","v":""},null,{"$f":"IF(A51=\"\",\"\",Z34)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$51=\"\",\"\",SUM(D51,F51,H51,J51))","v":""},null,null,{"$f":"IF(A51=\"\",\"\",\"Income\")","v":""}]
[null,null,null,null,{"$f":"IF($D$51=\"\",\"\",D52/$D$51)","v":""},null,{"$f":"IF($F$51=\"\",\"\",F52/$F$51)","v":""},null,{"$f":"IF($H$51=\"\",\"\",H52/$H$51)","v":""},null,{"$f":"IF($J$51=\"\",\"\",J52/$J$51)","v":""},{"$f":"IF($D$51=\"\",\"\",SUM(D52,F52,H52,J52))","v":""},{"$f":"IF($L$51=\"\",\"\",L52/$L$51)","v":""},null,{"$f":"IF(A51=\"\",\"\",\"COGS (Materials & Shipping)\")","v":""}]
[null,null,null,null,{"$f":"IF($D$51=\"\",\"\",D53/$D$51)","v":""},null,{"$f":"IF($F$51=\"\",\"\",F53/$F$51)","v":""},null,{"$f":"IF($H$51=\"\",\"\",H53/$H$51)","v":""},null,{"$f":"IF($J$51=\"\",\"\",J53/$J$51)","v":""},"",{"$f":"IF($L$51=\"\",\"\",L53/$L$51)","v":""},null,{"$f":"IF(A51=\"\",\"\",\"Gross Profit\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A51=\"\",\"\",\"Franchise Fees\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A51=\"\",\"\",\"Marketing & Advertising\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A51=\"\",\"\",\"Merchant Fees\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A51=\"\",\"\",\"Payroll\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A51=\"\",\"\",\"Rent\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A51=\"\",\"\",\"Utilities\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A51=\"\",\"\",\"Other Expenses\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,{"$f":"IF(A51=\"\",\"\",\"Total Expenses\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,{"$f":"IF(A51=\"\",\"\",\"Net Income\")","v":""}]
[]
[]
[{"$f":"IF(A67=\"\",\"\",Data!G8 & \" Actual Data\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A67=\"\",\"\",Data!G8 & \" Projected Data\")","v":""}]
[null,null,null,{"$f":"IF($A$67=\"\",\"\",D50)","v":""},null,{"$f":"IF($A$67=\"\",\"\",F50)","v":""},null,"",null,"",null,"",null,null,null,null,null,{"$f":"IF(A67=\"\",\"\",R50)","v":""},null,{"$f":"IF(A67=\"\",\"\",T50)","v":""},null,{"$f":"IF(A67=\"\",\"\",V50)","v":""},null,{"$f":"IF(A67=\"\",\"\",X50)","v":""},null,{"$f":"IF(A67=\"\",\"\",Z50)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D67=\"\",\"\",SUM(D67,F67,H67,J67))","v":""},null,null,{"$f":"IF(A67=\"\",\"\",\"Income\")","v":""}]
[null,null,null,null,{"$f":"IF($D$67=\"\",\"\",D68/$D$67)","v":""},null,{"$f":"IF($F$67=\"\",\"\",F68/$F$67)","v":""},null,{"$f":"IF($H$67=\"\",\"\",H68/$H$67)","v":""},null,{"$f":"IF($J$67=\"\",\"\",J68/$J$67)","v":""},{"$f":"IF(D68=\"\",\"\",SUM(D68,F68,H68,J68))","v":""},{"$f":"IF($L$67=\"\",\"\",L68/$L$67)","v":""},null,{"$f":"IF(A67=\"\",\"\",\"COGS (Materials & Shipping)\")","v":""}]
[null,null,null,null,{"$f":"IF($D$67=\"\",\"\",D69/$D$67)","v":""},null,{"$f":"IF($F$67=\"\",\"\",F69/$F$67)","v":""},null,{"$f":"IF($H$67=\"\",\"\",H69/$H$67)","v":""},null,{"$f":"IF($J$67=\"\",\"\",J69/$J$67)","v":""},"",{"$f":"IF($L$67=\"\",\"\",L69/$L$67)","v":""},null,{"$f":"IF(A67=\"\",\"\",\"Gross Profit\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A67=\"\",\"\",\"Franchise Fees\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A67=\"\",\"\",\"Marketing & Advertising\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A67=\"\",\"\",\"Merchant Fees\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A67=\"\",\"\",\"Payroll\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A67=\"\",\"\",\"Rent\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A67=\"\",\"\",\"Utilities\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,null,{"$f":"IF(A67=\"\",\"\",\"Other Expenses\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,{"$f":"IF(A67=\"\",\"\",\"Total Expenses\")","v":""}]
[null,null,null,null,"",null,"",null,"",null,"","","",null,{"$f":"IF(A67=\"\",\"\",\"Net Income\")","v":""}]

{"sheet":"QUARTER","index":2,"n_rows":65,"n_cols":17,"rows_kept":65,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"TODAY()","v":"2015-12-08"}]
["ACTUAL - BASELINE P&L",null,null,"Q3'14",null,"Q4'14",null,"Q1'15",null,"Q2'15",null,"TOTAL",null,"Benchmark"]
["Income",null,null,84401.81,null,108152.57,null,136924.12,null,151274.73000000001,null,480753.23]
["COGS (Materials & Shipping)",null,null,24460.57,{"$f":"D4/D3","v":0.28981096495442454},34274.33,{"$f":"F4/F3","v":0.31690721727648263},50489.5,{"$f":"H4/H3","v":0.36874073026724585},52123.12,{"$f":"J4/J3","v":0.34455933254681731},161347.51999999999,{"$f":"L4/L3","v":0.33561401137128083},0.38]
["Gross Profit",null,null,59941.24,{"$f":"D5/D3","v":0.7101890350455754},73878.240000000005,{"$f":"F5/F3","v":0.68309278272351737},86434.62,{"$f":"H5/H3","v":0.63125926973275415},99151.61,{"$f":"J5/J3","v":0.65544066745318263},319405.71000000002,{"$f":"L5/L3","v":0.66438598862871923},0.62]
[null,"Franchise Fees",null,6147.82,{"$f":"D6/D3","v":7.2839907106257554E-2},5237.4799999999996,{"$f":"F6/F3","v":4.8426773399836906E-2},5577.83,{"$f":"H6/H3","v":4.0736650343270418E-2},7995.28,{"$f":"J6/J3","v":5.2852713734805538E-2},24958.41,{"$f":"L6/L3","v":5.1915220621606639E-2},0.05]
[null,"Marketing & Advertising",null,773.97,{"$f":"D7/D3","v":9.1700640069211792E-3},323,{"$f":"F7/F3","v":2.9865217257435488E-3},2251.7600000000002,{"$f":"H7/H3","v":1.6445312922222909E-2},2541.8000000000002,{"$f":"J7/J3","v":1.6802541971154071E-2},5890.53,{"$f":"L7/L3","v":1.2252710189799452E-2},0.02]
[null,"Merchant Fees",null,1419.72,{"$f":"D8/D3","v":1.6820966280225509E-2},1739.52,{"$f":"F8/F3","v":1.608394511568241E-2},1425.45,{"$f":"H8/H3","v":1.0410510580604791E-2},2268.9899999999998,{"$f":"J8/J3","v":1.4999134356412334E-2},6853.68,{"$f":"L8/L3","v":1.4256128866778494E-2},7.0000000000000001E-3]
[null,"Payroll ",null,32734.23,{"$f":"D9/D3","v":0.38783800963510145},36905.58,{"$f":"F9/F3","v":0.34123627390454059},31588.76,{"$f":"H9/H3","v":0.23070266947854037},37152.15,{"$f":"J9/J3","v":0.24559389397026191},138380.72,{"$f":"L9/L3","v":0.28784147742491506},"16-22%"]
[null,"Rent",null,8529.48,{"$f":"D10/D3","v":0.10105802233388123},8529.48,{"$f":"F10/F3","v":7.8865254889458461E-2},9840.7199999999993,{"$f":"H10/H3","v":7.1869879463165434E-2},8821.32,{"$f":"J10/J3","v":5.8313242403407357E-2},35721,{"$f":"L10/L3","v":7.4302152894531778E-2},6.3E-2,null,null,"COUNTER MUST = 0"]
[null,"Utilities",null,2069.48,{"$f":"D11/D3","v":2.4519379382977689E-2},2349.25,{"$f":"F11/F3","v":2.1721628991340659E-2},2381.34,{"$f":"H11/H3","v":1.7391676499363299E-2},2139.62,{"$f":"J11/J3","v":1.4143935342009863E-2},8939.69,{"$f":"L11/L3","v":1.8595174077145567E-2},1.4999999999999999E-2]
[null,"Other Expenses",null,{"$f":"D13-D6-D7-D8-D9-D10-D11","v":4332.91},{"$f":"D12/D3","v":5.1336695267554099E-2},{"$f":"F13-F6-F7-F8-F9-F10-F11","v":4381.869999999999},{"$f":"F12/F3","v":4.0515634533696228E-2},{"$f":"H13-H6-H7-H8-H9-H10-H11","v":6376.409999999998},{"$f":"H12/H3","v":4.6568931755778295E-2},{"$f":"J13-J6-J7-J8-J9-J10-J11","v":10635.349999999995},{"$f":"J12/J3","v":7.0304868499847892E-2},{"$f":"L13-L6-L7-L8-L9-L10-L11","v":25726.540000000008},{"$f":"L12/L3","v":5.3512984197734897E-2}]
["Total Expenses",null,null,56007.61,{"$f":"D13/D3","v":0.66358304401291868},59466.18,{"$f":"F13/F3","v":0.54983603256029878},59442.27,{"$f":"H13/H3","v":0.43412563104294555},71554.509999999995,{"$f":"J13/J3","v":0.47301033027789896},246470.57,{"$f":"L13/L3","v":0.51267584827251189},0.4]
["Net Income",null,null,3094.42,{"$f":"D14/D3","v":3.6662957820454325E-2},14422.1,{"$f":"F14/F3","v":0.13334958198404345},27500.58,{"$f":"H14/H3","v":0.20084540254850644},27603.58,{"$f":"J14/J3","v":0.18247317314663195},72620.679999999993,{"$f":"L14/L3","v":0.15105604178676033},0.22]
[]
[null,null,null,0.05,null,0.05,null,0.1,null,0.1,null,null,null,"< % of Sales Growth YoY"]
["PROJECTED - Austin P&L",null,null,"Q3'15",null,"Q4'15",null,"Q1'16",null,"Q2'16",null,"TOTAL"]
["Income",null,null,{"$f":"D3*(1+D16)","v":88621.900500000003},null,{"$f":"F3*(1+F16)","v":113560.19850000001},null,{"$f":"H3*(1+H16)","v":150616.53200000001},null,{"$f":"J3*(1+J16)","v":166402.20300000004},null,{"$f":"D18+F18+H18+J18","v":519200.83400000009}]
["COGS (Materials & Shipping)",null,null,{"$f":"D18*$M$19","v":29245.227165000004},{"$f":"D19/D18","v":0.33},{"$f":"F18*$M$19","v":37474.865505000009},{"$f":"F19/F18","v":0.33},{"$f":"H18*$M$19","v":49703.455560000002},{"$f":"H19/H18","v":0.33},{"$f":"J18*$M$19","v":54912.726990000017},{"$f":"J19/J18","v":0.33},{"$f":"L18*$M$19","v":171336.27522000004},0.33]
["Gross Profit",null,null,{"$f":"D18-D19","v":59376.673334999999},{"$f":"D20/D18","v":0.66999999999999993},{"$f":"F18-F19","v":76085.332995000004},{"$f":"F20/F18","v":0.66999999999999993},{"$f":"H18-H19","v":100913.07644},{"$f":"H20/H18","v":0.67},{"$f":"J18-J19","v":111489.47601000001},{"$f":"J20/J18","v":0.66999999999999993},{"$f":"L18-L19","v":347864.55878000008},0.67]
[null,"Franchise Fees",null,{"$f":"D18*$M$21","v":4431.0950250000005},{"$f":"D21/D18","v":0.05},{"$f":"F18*$M$21","v":5678.0099250000012},{"$f":"F21/F18","v":0.05},{"$f":"H18*$M$21","v":7530.8266000000003},{"$f":"H21/H18","v":0.05},{"$f":"J18*$M$21","v":8320.1101500000022},{"$f":"J21/J18","v":0.05},{"$f":"L18*$M$21","v":25960.041700000005},0.05]
[null,"Marketing & Advertising",null,{"$f":"D18*$M$22","v":1772.4380100000001},{"$f":"D22/D18","v":0.02},{"$f":"F18*$M$22","v":2271.2039700000005},{"$f":"F22/F18","v":0.02},{"$f":"H18*$M$22","v":3012.3306400000001},{"$f":"H22/H18","v":0.02},{"$f":"J18*$M$22","v":3328.0440600000006},{"$f":"J22/J18","v":0.02},{"$f":"L18*$M$22","v":10384.016680000002},0.02]
[null,"Merchant Fees",null,{"$f":"D18*$M$23","v":1240.7066070000001},{"$f":"D23/D18","v":1.4E-2},{"$f":"F18*$M$23","v":1589.8427790000003},{"$f":"F23/F18","v":1.4E-2},{"$f":"H18*$M$23","v":2108.6314480000001},{"$f":"H23/H18","v":1.4E-2},{"$f":"J18*$M$23","v":2329.6308420000005},{"$f":"J23/J18","v":1.4E-2},{"$f":"L18*$M$23","v":7268.8116760000012},1.4E-2]
[null,"Payroll ",null,24934,{"$f":"D24/D18","v":0.28135257604862579},24934,{"$f":"F24/F18","v":0.21956636505879301},33358,{"$f":"H24/H18","v":0.22147635161324786},33358,{"$f":"J24/J18","v":0.20046609599273149},{"$f":"D24+F24+H24+J24","v":116584},{"$f":"L24/L18","v":0.2245450938547606},"(Based on Raun PT, Carl 40, Eli 40, John 40, Temp 20 starting Q1'16)"]
[null,"Rent",null,8821.32,{"$f":"D25/D18","v":9.9538826748586814E-2},9141.7800000000007,{"$f":"F25/F18","v":8.0501620468724347E-2},9141.7800000000007,{"$f":"H25/H18","v":6.0695727611096505E-2},9141.7800000000007,{"$f":"J25/J18","v":5.493785439847812E-2},{"$f":"D25+F25+H25+J25","v":36246.659999999996},{"$f":"L25/L18","v":6.9812407119515515E-2}]
[null,"Utilities",null,{"$f":"D11","v":2069.48},{"$f":"D26/D18","v":2.3351789888550179E-2},{"$f":"F11","v":2349.25},{"$f":"F26/F18","v":2.068726570603872E-2},{"$f":"H11","v":2381.34},{"$f":"H26/H18","v":1.5810614999421178E-2},{"$f":"J11","v":2139.62},{"$f":"J26/J18","v":1.2858123038190783E-2},{"$f":"L11","v":8939.69},{"$f":"L26/L18","v":1.7218173420730676E-2}]
[null,"Other Expenses",null,{"$f":"D18*M27","v":4431.0950250000005},{"$f":"D27/D18","v":0.05},{"$f":"M27*F18","v":5678.0099250000012},{"$f":"F27/F18","v":0.05},{"$f":"M27*H18","v":7530.8266000000003},{"$f":"H27/H18","v":0.05},{"$f":"M27*J18","v":8320.1101500000022},{"$f":"J27/J18","v":0.05},{"$f":"D27+F27+H27+J27","v":25960.041700000002},0.05]
["Total Expenses",null,null,{"$f":"SUM(D21:D27)","v":47700.134667000006},{"$f":"D28/D18","v":0.53824319268576282},{"$f":"SUM(F21:F27)","v":51642.096598999997},{"$f":"F28/F18","v":0.45475525123355603},{"$f":"SUM(H21:H27)","v":65063.735287999996},{"$f":"H28/H18","v":0.43198269422376551},{"$f":"SUM(J21:J27)","v":66937.295202000008},{"$f":"J28/J18","v":0.4022620734294004},{"$f":"SUM(L21:L27)","v":231343.26175600002},{"$f":"L28/L18","v":0.44557567439500684}]
["Net Income",null,null,{"$f":"D20-D28","v":11676.538667999994},{"$f":"D29/D18","v":0.13175680731423711},{"$f":"F20-F28","v":24443.236396000008},{"$f":"F29/F18","v":0.21524474876644395},{"$f":"H20-H28","v":35849.341152000008},{"$f":"H29/H18","v":0.23801730577623448},{"$f":"J20-J28","v":44552.180808000005},{"$f":"J29/J18","v":0.26773792657059953},{"$f":"L20-L28","v":116521.29702400006},{"$f":"L29/L18","v":0.22442432560499323}]
[]
[null,null,null,0.1,null,0.25,null,0.35,null,0.45,null,null,null,"< % of Austin Store Sales"]
["PROJECTED - San Marcos P&L",null,null,"Q3'15",null,"Q4'15",null,"Q1'16",null,"Q2'16",null,"TOTAL"]
["Income",null,null,{"$f":"D18*D31","v":8862.1900500000011},null,{"$f":"F18*F31","v":28390.049625000003},null,{"$f":"H18*H31","v":52715.786200000002},null,{"$f":"J18*J31","v":74880.991350000026},null,{"$f":"D33+F33+H33+J33","v":164849.01722500002}]
["COGS (Materials & Shipping)",null,null,{"$f":"D33*M34","v":2924.5227165000006},{"$f":"D34/D33","v":0.33},{"$f":"M34*F33","v":9368.7163762500022},{"$f":"F34/F33","v":0.33},{"$f":"M34*H33","v":17396.209446000001},{"$f":"H34/H33","v":0.33},{"$f":"M34*J33","v":24710.727145500008},{"$f":"J34/J33","v":0.33},{"$f":"M34*L33","v":54400.175684250011},0.33]
["Gross Profit",null,null,{"$f":"D33-D34","v":5937.6673335000005},{"$f":"D35/D33","v":0.66999999999999993},{"$f":"F33-F34","v":19021.333248750001},{"$f":"F35/F33","v":0.66999999999999993},{"$f":"H33-H34","v":35319.576754000002},{"$f":"H35/H33","v":0.67},{"$f":"J33-J34","v":50170.264204500018},{"$f":"J35/J33","v":0.67},{"$f":"L33-L34","v":110448.84154075},0.67]
[null,"Franchise Fees",null,{"$f":"M36*D33","v":443.10950250000008},{"$f":"D36/D33","v":0.05},{"$f":"F33*M36","v":1419.5024812500003},{"$f":"F36/F33","v":0.05},{"$f":"H33*M36","v":2635.7893100000001},{"$f":"H36/H33","v":0.05},{"$f":"J33*M36","v":3744.0495675000016},{"$f":"J36/J33","v":0.05},{"$f":"M36*L33","v":8242.4508612500013},0.05]
[null,"Marketing & Advertising",null,{"$f":"M37*D33","v":177.24380100000002},{"$f":"D37/D33","v":0.02},{"$f":"F33*M37","v":567.80099250000012},{"$f":"F37/F33","v":0.02},{"$f":"H33*M37","v":1054.315724},{"$f":"H37/H33","v":0.02},{"$f":"J33*M37","v":1497.6198270000004},{"$f":"J37/J33","v":0.02},{"$f":"M37*L33","v":3296.9803445000002},0.02]
[null,"Merchant Fees",null,{"$f":"M38*D33","v":124.07066070000002},{"$f":"D38/D33","v":1.4E-2},{"$f":"F33*M38","v":397.46069475000007},{"$f":"F38/F33","v":1.4E-2},{"$f":"H33*M38","v":738.02100680000001},{"$f":"H38/H33","v":1.4E-2},{"$f":"J33*M38","v":1048.3338789000004},{"$f":"J38/J33","v":1.4E-2},{"$f":"M38*L33","v":2307.8862411500004},1.4E-2]
[null,"Payroll ",null,17831,{"$f":"D39/D33","v":2.0120308749190046},17831,{"$f":"F39/F33","v":0.62807216738001737},26255,{"$f":"H39/H33","v":0.49804815393230345},26255,{"$f":"J39/J33","v":0.35062302897783404},{"$f":"D39+F39+H39+J39","v":88172},{"$f":"L39/L33","v":0.53486518442300035},"(Based on Dmitri FT, Tiara 40, Darius 40, Temp 20 starting Q1'16)"]
[null,"Rent",null,512.34,{"$f":"D40/D33","v":5.7811894927710335E-2},1537.02,{"$f":"F40/F33","v":5.4139391100130906E-2},1537.02,{"$f":"H40/H33","v":2.9156731043878465E-2},7880.76,{"$f":"J40/J33","v":0.10524379896581053},{"$f":"D40+F40+H40+J40","v":11467.14},{"$f":"L40/L33","v":6.9561470204876422E-2}]
[null,"Utilities",null,783,{"$f":"D41/D33","v":8.8352878417451666E-2},2349,{"$f":"F41/F33","v":8.2740256921970762E-2},2381,{"$f":"H41/H33","v":4.516673603172023E-2},2140,{"$f":"J41/J33","v":2.8578681470674723E-2},{"$f":"D41+F41+H41+J41","v":7653},{"$f":"L41/L33","v":4.6424298602608785E-2}]
[null,"Other Expenses",null,{"$f":"M42*D33","v":443.10950250000008},{"$f":"D42/D33","v":0.05},{"$f":"M42*F33","v":1419.5024812500003},{"$f":"F42/F33","v":0.05},{"$f":"M42*H33","v":2635.7893100000001},{"$f":"H42/H33","v":0.05},{"$f":"M42*J33","v":3744.0495675000016},{"$f":"J42/J33","v":0.05},{"$f":"M42*L33","v":8242.4508612500013},0.05]
["Total Expenses",null,null,{"$f":"SUM(D36:D42)","v":20313.873466699999},{"$f":"D43/D33","v":2.2921956482641663},{"$f":"SUM(F36:F42)","v":25521.286649750004},{"$f":"F43/F33","v":0.8989518154021191},{"$f":"SUM(H36:H42)","v":37236.935350799999},{"$f":"H43/H33","v":0.70637162100790207},{"$f":"SUM(J36:J42)","v":46309.812840900006},{"$f":"J43/J33","v":0.61844550941431931},{"$f":"SUM(L36:L42)","v":129381.90830815001},{"$f":"L43/L33","v":0.7848509532304857}]
["Net Income",null,null,{"$f":"D35-D43","v":-14376.206133199998},{"$f":"D44/D33","v":-1.6221956482641664},{"$f":"F35-F43","v":-6499.9534010000025},{"$f":"F44/F33","v":-0.22895181540211915},{"$f":"H35-H43","v":-1917.358596799997},{"$f":"H44/H33","v":-3.6371621007902123E-2},{"$f":"J35-J43","v":3860.451363600012},{"$f":"J44/J33","v":5.1554490585680672E-2},{"$f":"L35-L43","v":-18933.066767400014},{"$f":"L44/L33","v":-0.11485095323048573}]
[]
["PROJECTED - Company P&L",null,null,"Q3'15",null,"Q4'15",null,"Q1'16",null,"Q2'16",null,"TOTAL"]
["Income",null,null,{"$f":"D18+D33","v":97484.090550000008},null,{"$f":"F18+F33","v":141950.24812500001},null,{"$f":"H18+H33","v":203332.31820000001},null,{"$f":"J18+J33","v":241283.19435000006},null,{"$f":"D47+F47+H47+J47","v":684049.85122500011},null,{"$f":"(L47-L3)/L3","v":0.42287104597300396},"Growth from 2 stores & better utilization of employees"]
["COGS (Materials & Shipping)",null,null,32169.749881500004,{"$f":"D48/D47","v":0.33},46843.581881250007,{"$f":"F48/F47","v":0.33},67099.665005999996,{"$f":"H48/H47","v":0.32999999999999996},79623.454135500026,{"$f":"J48/J47","v":0.33},{"$f":"L19+L34","v":225736.45090425006},{"$f":"L48/L47","v":0.33}]
["Gross Profit",null,null,65314.340668500001,{"$f":"D49/D47","v":0.66999999999999993},95106.666243750005,{"$f":"F49/F47","v":0.66999999999999993},136232.65319400001,{"$f":"H49/H47","v":0.67},161659.74021450002,{"$f":"J49/J47","v":0.66999999999999993},458313.40032075008,{"$f":"L49/L47","v":0.67}]
[null,"Franchise Fees",null,4874.2045275000009,{"$f":"D50/D47","v":0.05},7097.5124062500017,{"$f":"F50/F47","v":5.000000000000001E-2},10166.61591,{"$f":"H50/H47","v":0.05},12064.159717500004,{"$f":"J50/J47","v":0.05},34202.492561250008,{"$f":"L50/L47","v":0.05}]
[null,"Marketing & Advertising",null,1949.6818110000002,{"$f":"D51/D47","v":0.02},2839.0049625000006,{"$f":"F51/F47","v":2.0000000000000004E-2},4066.6463640000002,{"$f":"H51/H47","v":0.02},4825.6638870000006,{"$f":"J51/J47","v":1.9999999999999997E-2},13680.997024500002,{"$f":"L51/L47","v":0.02}]
[null,"Merchant Fees",null,1364.7772677,{"$f":"D52/D47","v":1.3999999999999999E-2},1987.3034737500004,{"$f":"F52/F47","v":1.4000000000000002E-2},2846.6524548000002,{"$f":"H52/H47","v":1.4E-2},3377.9647209000009,{"$f":"J52/J47","v":1.4E-2},9576.6979171500025,{"$f":"L52/L47","v":1.4000000000000002E-2}]
[null,"Payroll ",null,42765,{"$f":"D53/D47","v":0.4386869668550239},42765,{"$f":"F53/F47","v":0.30126752552303787},59613,{"$f":"H53/H47","v":0.29318015221448451},59613,{"$f":"J53/J47","v":0.24706652347086677},204756,{"$f":"L53/L47","v":0.29932906151989047}]
[null,"Rent",null,9333.66,{"$f":"D54/D47","v":9.5745469310325321E-2},10678.800000000001,{"$f":"F54/F47","v":7.5229174595005666E-2},10678.800000000001,{"$f":"H54/H47","v":5.2518950723299235E-2},17022.54,{"$f":"J54/J47","v":7.055004409178818E-2},47713.799999999996,{"$f":"L54/L47","v":6.9751933889838399E-2}]
[null,"Utilities",null,2852.48,{"$f":"D55/D47","v":2.926097975481395E-2},4698.25,{"$f":"F55/F47","v":3.3097863949225127E-2},4762.34,{"$f":"H55/H47","v":2.3421461192980192E-2},4279.62,{"$f":"J55/J47","v":1.7736917034478904E-2},16592.690000000002,{"$f":"L55/L47","v":2.4256550849745418E-2}]
[null,"Other Expenses",null,4874.2045275000009,{"$f":"D56/D47","v":0.05},7097.5124062500017,{"$f":"F56/F47","v":5.000000000000001E-2},10166.61591,{"$f":"H56/H47","v":0.05},12064.159717500004,{"$f":"J56/J47","v":0.05},34202.492561250001,{"$f":"L56/L47","v":4.9999999999999996E-2}]
["Total Expenses",null,null,68014.008133700001,{"$f":"D57/D47","v":0.6976934159201631},77163.383248750004,{"$f":"F57/F47","v":0.54359456406726869},102300.67063879999,{"$f":"H57/H47","v":0.50312056413076389},113247.10804290001,{"$f":"J57/J47","v":0.46935348459713389},360725.17006415001,{"$f":"L57/L47","v":0.52733754625947427}]
["Net Income",null,null,-2699.6674652000038,{"$f":"D58/D47","v":-2.7693415920163226E-2},17943.282995000005,{"$f":"F58/F47","v":0.12640543593273132},33931.982555200011,{"$f":"H58/H47","v":0.16687943586923612},48412.632171600017,{"$f":"J58/J47","v":0.20064651540286607},97588.230256600044,{"$f":"L58/L47","v":0.14266245374052566}]
[]
[null,null,null,"Comb Bonus",null,"Split Bonus",null,"Split Bonus",null,"Split Bonus",null,"TOTAL"]
["Employee Bonus (Prorated @ 10%)",null,null,{"$f":"D58*0.1","v":-269.96674652000041},null,{"$f":"F58*0.1","v":1794.3282995000006},null,{"$f":"H58*0.1","v":3393.1982555200011},null,{"$f":"J58*0.1","v":4841.2632171600017},null,{"$f":"L58*0.1","v":9758.8230256600054}]
[]
["Prorated = # Hours worked in Quarter X Hourly Pay Rate / All Employees # Hours worked in Quarter X Hourly Rates"]
[]
["Example:  (520 X $10 = 5200 / 2600 X $12 = 31,200) = 16.7% X $4,841 = $808.45 X Performance Rating (A 100%, B 80%, C 60%) = Bonus"]

{"sheet":"Data","index":3,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":true,"merged":[[32,0,32,12]]}
["Number of Stores:","Houston #4","Month:","Quarter:","Counter:","2nd Month","Counter 1","Quarter 1",null,null,"CANCELLED?"]
[4,"Austin","January","Q1",0,{"$f":"IF(A4=C2,C3,IF(A4=C3,C4,IF(A4=C4,C5,IF(A4=C5,C6,IF(A4=C6,C7,IF(A4=C7,C8,IF(A4=C8,C9,IF(A4=C9,C10,IF(A4=C10,C11,IF(A4=C11,C12,IF(A4=C12,C13,IF(A4=C13,C2))))))))))))","v":"April"},"Austin",{"$f":"A6","v":"Q2"}]
["Month Selected:","San Marcos","February","Q2","Q Count:","3rd Month","Counter 2","Quarter 2"]
["March","Houston","March","Q3",0,{"$f":"IF(A4=C2,C4,IF(A4=C3,C5,IF(A4=C4,C6,IF(A4=C5,C7,IF(A4=C6,C8,IF(A4=C7,C9,IF(A4=C8,C10,IF(A4=C9,C11,IF(A4=C10,C12,IF(A4=C11,C13,IF(A4=C12,C2,IF(A4=C13,C3))))))))))))","v":"May"},"San Marcos",{"$f":"IF(A6=D2,D3,IF(A6=D3,D4,IF(A6=D4,D5,IF(A6=D5,D2))))","v":"Q3"}]
["Quarter Selected:","Dallas","April","Q4","Row Count:",null,"Counter 3","Quarter 3"]
["Q2",null,"May",null,0,null,"Dallas",{"$f":"IF(A6=D2,D4,IF(A6=D3,D5,IF(A6=D4,D2,IF(A6=D5,D3))))","v":"Q4"}]
["CheckBox Selected:",null,"June",null,null,null,"Counter 4","Quarter 4"]
["qComp",null,"July",null,null,null,"Houston",{"$f":"IF(A6=D2,D5,IF(A6=D3,D2,IF(A6=D4,D3,IF(A6=D5,D4))))","v":"Q1"}]
["Store Selected:",null,"August",null,null,null,"Counter 5",null,null,null,"Instructions:"]
["Dallas",null,"September",null,null,null,null,null,null,null,"Instructions:                Welcome to the amazing Crown Trophy comparison form.                                             "]
[null,null,"October",null,null,null,"Counter 6",null,null,null,"Pull Data:","1.) Select the \"Show Form\" Report "]
[null,null,"November",null,null,null,null,null,null,null,null,"2.) Next choose the correct store from the dropdown menu "]
[null,null,"December",null,null,null,"Counter 7",null,null,null,null,"3.) Check either \"Monthly\" or \"Quarterly\" depending on the report you wish to run "]
[null,null,null,null,null,null,null,null,null,null,null,"4.) Click on the \"Get Data\" button and then select the correct report that quickbooks generated"]
[null,null,null,null,null,null,null,null,null,null,null,"5.) Now select the next set of data"]
[null,null,null,null,null,null,null,null,null,null,"6.) Nothing goes here"]
[null,null,null,null,null,null,null,null,null,null,"Creating Charts:","The \"Create Chart\" macro will create a chart based on a single line item and is meant for the Quarterly tab."]
[null,null,null,null,null,null,null,null,null,null,null,"1.) Import all the data before you create a chart"]
[null,null,null,null,null,null,null,null,null,null,null,"2.) Select the row that you would like to create a chart of"]
[null,null,null,null,null,null,null,null,null,null,null,"3.) Once the row is selected then click on the \"Create Chart\" button"]
[null,null,null,null,null,null,null,null,null,null,null,"4.) Charts are generated to the right of the projected data and will stack on top of each other. "]
[null,null,null,null,null,null,null,null,null,null,null,"5.) To delete the charts, select the \"Delete Charts\" button which will delete all charts."]