{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Dry Storage Calculator"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Dry Storage Calculator","index":0,"n_rows":58,"n_cols":12,"rows_kept":58,"cut":false,"hidden":false,"merged":[[29,0,29,12],[31,0,31,4],[32,0,32,4],[33,0,33,4],[35,0,35,12],[34,0,34,4],[30,0,30,12],[31,7,34,12],[0,0,0,12],[8,0,8,12],[9,0,9,4],[1,0,1,12],[3,0,3,1],[3,2,3,12],[2,0,2,12],[4,0,4,1],[4,2,4,12],[6,0,7,12],[5,0,5,12],[10,0,10,9],[24,0,24,4],[17,10,19,12],[20,0,20,12],[11,0,11,3],[12,0,12,3],[10,10,12,12],[14,0,14,12],[25,0,25,4],[23,0,23,12],[28,0,28,12],[27,7,27,12],[9,7,9,12],[24,7,26,12],[26,0,26,4],[27,0,27,4],[16,7,16,12],[15,0,15,12],[16,0,16,4],[21,0,22,12],[17,0,17,9],[18,0,18,3],[19,0,19,3],[13,0,13,12],[36,0,36,12],[38,4,38,5],[42,4,42,5],[44,4,44,5],[43,4,43,5],[38,0,39,2],[39,4,39,5],[37,0,37,11],[38,10,38,11],[38,6,38,9],[57,1,65,11],[56,0,56,12],[46,4,46,5],[48,4,48,5],[45,4,45,5],[49,4,49,5],[50,4,50,5],[52,4,52,5],[54,4,54,5],[40,0,54,2],[51,4,51,5],[47,4,47,5],[40,4,40,5],[41,4,41,5],[55,0,55,9],[53,4,53,5]]}
["                              Dry Storage Calculator                                   "]
["          Developed by the Plan Review Unit of the Environmental Health Section                                                                                                            NC Division of Public Health"]
[]
["Establishment Name:",null,"WINGSTOP"]
["Address:",null,"2880 NORTHTOWNE"]
[]
["Area of Dry Storage Room Needed (sq. ft.)"]
[]
["Based on: \nMeal size of 0.1 cu.ft. (ft³), 5 feet usable height"]
["Enter number of meals between deliveries:",null,null,null,null,null,"meals"]
["Area (sq. ft.) of dry storage room needed, depending on percent of usable floor area:"]
["Percent of usable floor area: ",null,null,null,0.3,0.4,0.5,0.6,0.7,0.8]
["Square feet (ft²) storage area needed:",null,null,null,{"$f":"F10*0.1/(5*E12)","v":0},{"$f":"F10*0.1/(5*F12)","v":0},{"$f":"F10*0.1/(5*G12)","v":0},{"$f":"F10*0.1/(5*H12)","v":0},{"$f":"F10*0.1/(5*I12)","v":0},{"$f":"F10*0.1/(5*J12)","v":0}]
[]
["Meals Supported by Dry Storage Room"]
["Based on: \nMeal size of 0.1 cu.ft. (ft³), 5 feet usable height"]
["Enter sq. ft. area of storage room (length x width):",null,null,null,null,null,"sq. ft."]
["Number of meals supported, depending on percent of usable floor area:"]
["                                                                       Percent of usable floor area:                                                                      ",null,null,null,0.3,0.4,0.5,0.6,0.7,0.8]
["Number of meals supported:",null,null,null,{"$f":"F17*50*E19","v":0},{"$f":"F17*50*F19","v":0},{"$f":"F17*50*G19","v":0},{"$f":"F17*50*H19","v":0},{"$f":"F17*50*I19","v":0},{"$f":"F17*50*J19","v":0}]
[]
["Linear feet of Shelving Needed (ft.)"]
[]
["             Based on: \nMeal size of 0.1 cu. ft. (ft³), 80% usable shelf height"]
["Enter number of meals between deliveries:",null,null,null,null,900,"meals"]
["Enter depth of shelves (ft.):",null,null,null,null,1,"ft."]
["Enter space between shelves (ft.):",null,null,null,null,1.3,"ft."]
["Linear feet of shelving needed:",null,null,null,null,{"$f":"IF(F26=0,\"\",(0.1*F25)/(F26*F27*0.8))","v":86.538461538461533},"ft."]
[]
["Meals Supported by Linear Shelving"]
["Based on 80% usable shelf height"]
["Enter length of shelves (ft.):",null,null,null,null,370,"ft."]
["Enter depth of shelves (ft.):",null,null,null,null,1,"ft."]
["Enter space between shelves (ft.):",null,null,null,null,1.3,"ft."]
["Number of meals supported:",null,null,null,null,{"$f":"IF(F33=0,\"\",((F32*(F33*F34*0.8))/0.1))","v":3848},"meals"]
[]
["Meals Supported by Existing or Proposed Shelving Racks"]
["Based on 4 shelves per rack, 18 inches between shelves"]
["Enter the existing or proposed number of various size shelving racks:",null,null,"Number\nof racks","Shelf size",null,"Linear feet of shelving",null,null,null,"Meals Supported"]
[null,null,null,0,"12 in. x 3 ft.",null,{"$f":"12*D40","v":0},"ft. of 12\" deep shelves",null,null,{"$f":"12*G40","v":0},"meals"]
[null,null,null,0,"18 in. x 3 ft.",null,{"$f":"12*D41","v":0},"ft. of 18\" deep shelves",null,null,{"$f":"12*1.5*G41","v":0},"meals"]
[null,null,null,0,"24 in. x 3 ft.",null,{"$f":"12*D42","v":0},"ft. of 24\" deep shelves",null,null,{"$f":"12*2*G42","v":0},"meals"]
[null,null,null,0,"30 in. x 3 ft.",null,{"$f":"12*D43","v":0},"ft. of 30\" deep shelves",null,null,{"$f":"12*2.5*G43","v":0},"meals"]
[null,null,null,0,"12 in. x 4 ft.",null,{"$f":"16*D44","v":0},"ft. of 12\" deep shelves",null,null,{"$f":"12*G44","v":0},"meals"]
[null,null,null,0,"18 in. x 4 ft.",null,{"$f":"16*D45","v":0},"ft. of 18\" deep shelves",null,null,{"$f":"12*1.5*G45","v":0},"meals"]
[null,null,null,0,"24 in. x 4 ft.",null,{"$f":"16*D46","v":0},"ft. of 24\" deep shelves",null,null,{"$f":"12*2*G46","v":0},"meals"]
[null,null,null,0,"30 in. x 4 ft.",null,{"$f":"16*D47","v":0},"ft. of 30\" deep shelves",null,null,{"$f":"12*2.5*G47","v":0},"meals"]
[null,null,null,0,"12 in. x 5 ft.",null,{"$f":"20*D48","v":0},"ft. of 12\" deep shelves",null,null,{"$f":"12*G48","v":0},"meals"]
[null,null,null,0,"18 in. x 5 ft.",null,{"$f":"20*D49","v":0},"ft. of 18\" deep shelves",null,null,{"$f":"12*1.5*G49","v":0},"meals"]
[null,null,null,0,"24 in. x 5 ft.",null,{"$f":"20*D50","v":0},"ft. of 24\" deep shelves",null,null,{"$f":"12*2*G50","v":0},"meals"]
[null,null,null,0,"30 in. x 5 ft.",null,{"$f":"20*D51","v":0},"ft. of 30\" deep shelves",null,null,{"$f":"12*2.5*G51","v":0},"meals"]
[null,null,null,0,"12 in. x 6 ft.",null,{"$f":"24*D52","v":0},"ft. of 12\" deep shelves",null,null,{"$f":"12*G52","v":0},"meals"]
[null,null,null,0,"18 in. x 6 ft.",null,{"$f":"24*D53","v":0},"ft. of 18\" deep shelves",null,null,{"$f":"12*1.5*G53","v":0},"meals"]
[null,null,null,0,"24 in. x 6 ft.",null,{"$f":"24*D54","v":0},"ft. of 24\" deep shelves",null,null,{"$f":"12*2*G54","v":0},"meals"]
[null,null,null,0,"30 in. x 6 ft.",null,{"$f":"24*D55","v":0},"ft. of 30\" deep shelves",null,null,{"$f":"12*2.5*G55","v":0},"meals"]
["Total number of meals supported:",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K40:K55)","v":0},"meals"]
[]
[null,"Delivery Frequency: 2x per week for cold & dry\n\nEstimated Meals per Day: 300\n\nThe current storage is deemed sufficient for the facility. See attached for reference. The current space provides 3848 meals, while with 900 MBD (meals between deliveries) 87 ft of shelving is needed. \n\n***Note, if delivery frequency changes or estimated number of meals increases the current calculations will be invalid and the calculations must be reviewed with updated.***\n"]