{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Revenue Per Foot Calculator"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":1,"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":"Revenue Per Foot Calculator","index":0,"n_rows":30,"n_cols":14,"rows_kept":30,"cut":false,"hidden":false,"merged":[[21,1,21,6],[21,8,21,12]]}
[]
[null,null,"Retail Revenue as % of Total Revenue"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sponsored by SalonBiz™"]
[]
[null,"ANNUAL RETAIL SALES (A) enter  ",null,null,null,null,150000,null,"(retail only)"]
[]
[null,"ANNUAL TOTAL SALES (B) enter  ",null,null,null,null,1000000,null,"(service and retail)"]
[]
[null,"RETAIL PERCENTAGE (A / B) ",null,null,null,null,{"$f":"G13/G15","v":0.15}]
[]
[null,"RANKING (BY QUARTILE)",null,null,null,null,{"$f":"IF(G17>=M25,I25,IF(G17>=M26,I26,IF(G17>=M27,I27,I28)))","v":2},null,"(see below)"]
[]
[]
[null,"Definitions. The quartiles divide the data into four equal regions. Expressed in terms of rank (1, 2, 3 or 4), the quartile measure shows how well your business has performed compared to other businesses. The 1st quartile is TOP, the 4th quartile is BOTTOM. The quartiles are based on research by the 2 to 10 Project™. ",null,null,null,null,null,null,"Quartiles: COMPOSITE"]
[]
[null,null,null,null,null,null,null,null,"Rank",null,"top",null,"bottom"]
[null,null,null,null,null,null,null,null,1,null,0.245,"+",0.185]
[null,null,null,null,null,null,null,null,2,null,{"$f":"M25","v":0.185},null,0.14199999999999999]
[null,null,null,null,null,null,null,null,3,null,{"$f":"M26","v":0.14199999999999999},null,0.112]
[null,null,null,null,null,null,null,null,4,null,{"$f":"M27","v":0.112},null,6.8000000000000005E-2,"-"]
[]
[null,null,null,null,null,null,null,null,"AVERAGE ",null,{"$f":"K27","v":0.14199999999999999}]