{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Scatter plot Graph &Radar Plots","User Interface for Radar Plot","Radar Plot Raw Data(DNT)","Rb Calculations","Rp Calculations","Rb Calculations (2)","Rp Calculations (2)","Rb Calculations (3)","Rp Calculations (3)","Rb Guides","Rp Guides"],"not_rendered":{"charts":5,"images":2,"macros":1,"external_links":0,"defined_names":7,"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":"Scatter plot Graph &Radar Plots","index":0,"n_rows":106,"n_cols":18,"rows_kept":106,"cut":false,"hidden":false,"merged":[[15,0,17,1],[40,0,41,2],[70,0,71,2],[102,0,103,2],[0,0,0,19],[3,0,5,1],[9,0,11,1],[31,0,32,2]]}
[]
[]
[]
["Risk factor values for location 1: (insert name)"]
[]
[]
["Rp","Rb"]
[{"$f":"'Rp Calculations'!E22","v":""},{"$f":"'Rb Calculations'!E37","v":""}]
[]
["Risk factor values for location 2: (insert name)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"s"]
[]
[]
["Rp","Rb"]
[{"$f":"'Rp Calculations (2)'!E22","v":""},{"$f":"'Rb Calculations (2)'!E37","v":""}]
[]
["Risk factor values for location 3: (insert name)"]
[]
[]
["Rp","Rb"]
[{"$f":"'Rp Calculations (3)'!E22","v":""},{"$f":"'Rb Calculations (3)'!E37","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["risk radar plot for location 1: (insert name)"]
[]
["active fire safety","passive fire safety","evacuation"]
[{"$f":"IFERROR(AVERAGE(AVERAGEIF('Rb Calculations'!A240:B240,\"<>0\"), AVERAGEIF('Rb Calculations'!A245:B245, \"<>0\"),AVERAGEIF('Rb Calculations'!A250:B250,\"<>0\"),AVERAGEIF('Rb Calculations'!A255:B255,\"<>0\")),\"\")","v":""},{"$f":"IFERROR(AVERAGE(AVERAGE(IF('Rb Calculations'!A176=1,1.7,IF('Rb Calculations'!A176=1.5,1.5,IF('Rb Calculations'!A176=2.5,1.3,IF('Rb Calculations'!A176=3,1,\"error\")))),IF('Rb Calculations'!A181=1,1.7,IF('Rb Calculations'!A181=1.5,1.5,IF('Rb Calculations'!A181=2.5,1.3,IF('Rb Calculations'!A181=3,1,\"error\")))),IF('Rb Calculations'!A186=1,1.7,IF('Rb Calculations'!A186=1.5,1.5,IF('Rb Calculations'!A186=2.5,1.3,IF('Rb Calculations'!A186=3,1,\"error\"))))),'Rp Calculations'!L97),\"\")","v":""},{"$f":"'Rp Calculations'!D87","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["risk radar plot for location 2: (insert name)"]
[]
["active fire safety","passive fire safety","evacuation"]
[{"$f":"IFERROR(AVERAGE(AVERAGEIF('Rb Calculations (2)'!A240:B240,\"<>0\"), AVERAGEIF('Rb Calculations (2)'!A245:B245, \"<>0\"),AVERAGEIF('Rb Calculations (2)'!A250:B250,\"<>0\"),AVERAGEIF('Rb Calculations (2)'!A255:B255,\"<>0\")),\"\")","v":""},{"$f":"IFERROR(AVERAGE(AVERAGE(IF('Rb Calculations (2)'!A176=1,1.7,IF('Rb Calculations (2)'!A176=1.5,1.5,IF('Rb Calculations (2)'!A176=2.5,1.3,IF('Rb Calculations (2)'!A176=3,1,\"error\")))),IF('Rb Calculations (2)'!A181=1,1.7,IF('Rb Calculations (2)'!A181=1.5,1.5,IF('Rb Calculations (2)'!A181=2.5,1.3,IF('Rb Calculations (2)'!A181=3,1,\"error\")))),IF('Rb Calculations (2)'!A186=1,1.7,IF('Rb Calculations (2)'!A186=1.5,1.5,IF('Rb Calculations (2)'!A186=2.5,1.3,IF('Rb Calculations (2)'!A186=3,1,\"error\"))))),'Rp Calculations (2)'!L97),\"\")","v":""},{"$f":"'Rp Calculations (2)'!D87","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["risk radar plot for location 3: (insert name)"]
[]
["active fire safety","passive fire safety","evacuation"]
[{"$f":"IFERROR(AVERAGE(AVERAGEIF('Rb Calculations (3)'!A240:B240,\"<>0\"), AVERAGEIF('Rb Calculations (3)'!A245:B245, \"<>0\"),AVERAGEIF('Rb Calculations (3)'!A250:B250,\"<>0\"),AVERAGEIF('Rb Calculations (3)'!A255:B255,\"<>0\")),\"\")","v":""},{"$f":"IFERROR(AVERAGE(AVERAGE(IF('Rb Calculations (3)'!A176=1,1.7,IF('Rb Calculations (3)'!A176=1.5,1.5,IF('Rb Calculations (3)'!A176=2.5,1.3,IF('Rb Calculations (3)'!A176=3,1,\"error\")))),IF('Rb Calculations (3)'!A181=1,1.7,IF('Rb Calculations (3)'!A181=1.5,1.5,IF('Rb Calculations (3)'!A181=2.5,1.3,IF('Rb Calculations (3)'!A181=3,1,\"error\")))),IF('Rb Calculations (3)'!A186=1,1.7,IF('Rb Calculations (3)'!A186=1.5,1.5,IF('Rb Calculations (3)'!A186=2.5,1.3,IF('Rb Calculations (3)'!A186=3,1,\"error\"))))),'Rp Calculations (3)'!L97),\"\")","v":""},{"$f":"'Rp Calculations (3)'!D87","v":""}]

{"sheet":"User Interface for Radar Plot","index":1,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[3,0,6,1],[0,3,0,9],[7,0,8,1],[9,0,12,1]]}
[null,null,null,"Evaluation for Current Fire Safety Systems"]
[]
[null,null,"Inspected safety systems","Area 1","Area 2","Area 3","Area 4","Area 5","Area 6","Area 7"]
["Active Fire \nSafety Systems",null,"Detection System"]
[null,null,"Suppression System"]
[null,null,"Fire extinguisher"]
[null,null,"Hose stream"]
["Passive Fire\nSafety Systems",null,"Forced ventilation"]
[null,null,"Natural ventilation"]
["Evacuation Systems",null,"SIGNS TO EXIT"]
[null,null,"Evacuation stairs"]
[null,null,"Emergency lighting"]
[null,null,"Emergency announcement"]

{"sheet":"Radar Plot Raw Data(DNT)","index":2,"n_rows":11,"n_cols":23,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,13,2,14],[2,17,2,22],[2,1,2,4],[2,5,2,6],[2,7,2,10]]}
[]
[]
[null,"active fire safety applications",null,null,null,"passive fire safety",null,"evacuation system",null,null,null,null,null,"Scaling for Radar Plot Axes",null,null,null,"Data for radar plot on graph worksheet"]
["area","detection system ","suppresion system","fire extinguisher","hose stream","forced ventilation","natural ventilation","signs to exits","evacuation stairs","emergency lighting","emergency announcement",null,"current state of system","Scale for Passive Fire Safety And Evacuation Systems","Scale for Active Fire Safety Systems",null,"Area Name",{"$f":"'User Interface for Radar Plot'!D3","v":"Area 1"},{"$f":"'User Interface for Radar Plot'!E3","v":"Area 2"},{"$f":"'User Interface for Radar Plot'!F3","v":"Area 3"},{"$f":"'User Interface for Radar Plot'!G3","v":"Area 4"},"End Goal","No System Installation"]
["location 1",{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$D$4,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$D$5,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$D$6,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$D$7,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$D$8,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$D$9,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$D$10,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$D$11,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$D$12,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$D$13,$M$5:$O$8,2,FALSE),\"\")","v":""},null,"Not Present",1,1,null,"Active Fire Safety",{"$f":"IFERROR(0.429*B5+0.226*C5+0.151*D5+0.194*E5,\"\")","v":""},{"$f":"IFERROR(0.429*B6+0.226*C6+0.151*D6+0.194*E6,\"\")","v":""},{"$f":"IFERROR(0.429*B7+0.226*C7+0.151*D7+0.194*E7,\"\")","v":""},{"$f":"IFERROR(0.429*B8+0.226*C8+0.151*D8+0.194*E8,\"\")","v":""},3,1]
["location 2",{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$E$4,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$E$5,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$E$6,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$E$7,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$E$8,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$E$9,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$E$10,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$E$11,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$E$12,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$E$13,$M$5:$O$8,2,FALSE),\"\")","v":""},null,"Present, lack maintenance",1.3,1.5,null,"Passive Fire Safety ",{"$f":"IFERROR(0.5*F5+0.5*G5,\"\")","v":""},{"$f":"IFERROR(0.5*F6+0.5*G6,\"\")","v":""},{"$f":"IFERROR(0.5*F7+0.5*G7,\"\")","v":""},{"$f":"IFERROR(0.5*F8+0.5*G8,\"\")","v":""},1.7,1]
["location 3",{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$F$4,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$F$5,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$F$6,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$F$7,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$F$8,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$F$9,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$F$10,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$F$11,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$F$12,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$F$13,$M$5:$O$8,2,FALSE),\"\")","v":""},null,"Present, maintenance, lack system approval",1.5,2.5,null,"Evacuation ",{"$f":"IFERROR(0.203*H5+0.506*I5+0.203*J5+0.098*K5,\"\")","v":""},{"$f":"IFERROR(0.203*H6+0.506*I6+0.203*J6+0.098*K6,\"\")","v":""},{"$f":"IFERROR(0.203*H7+0.506*I7+0.203*J7+0.098*K7,\"\")","v":""},{"$f":"IFERROR(0.203*H8+0.506*I8+0.203*J8+0.098*K8,\"\")","v":""},1.7,1]
["location 4",{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$G$4,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$G$5,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$G$6,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$G$7,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$G$8,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$G$9,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$G$10,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$G$11,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$G$12,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$G$13,$M$5:$O$8,2,FALSE),\"\")","v":""},null,"Ideal",1.7,3]
["location 5",{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$H$4,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$H$5,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$H$6,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$H$7,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$H$8,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$H$9,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$H$10,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$H$11,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$H$12,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$H$13,$M$5:$O$8,2,FALSE),\"\")","v":""}]
["location 6",{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$I$4,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$I$5,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$I$6,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$I$7,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$I$8,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$I$9,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$I$10,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$I$11,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$I$12,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$I$13,$M$5:$O$8,2,FALSE),\"\")","v":""}]
["location 7",{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$J$4,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$J$5,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$J$6,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$J$7,$M$5:$O$8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$J$8,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$J$9,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$J$10,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$J$11,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$J$12,$M$5:$O$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('User Interface for Radar Plot'!$J$13,$M$5:$O$8,2,FALSE),\"\")","v":""}]

{"sheet":"Rb Calculations","index":3,"n_rows":255,"n_cols":9,"rows_kept":255,"cut":false,"hidden":false,"merged":[[197,8,198,9],[196,8,196,9],[234,8,235,9],[233,8,233,9],[206,8,207,9],[205,8,205,9],[162,8,163,9],[161,8,161,9],[169,8,170,9],[168,8,168,9],[188,8,189,9],[187,8,187,9],[45,8,45,9],[46,8,47,9],[53,8,54,9],[52,8,52,9],[59,8,60,9],[58,8,58,9],[36,2,36,3],[34,2,34,4],[39,8,40,9],[38,8,38,9],[170,0,170,4],[128,2,128,4],[153,2,153,4],[136,0,136,1],[141,0,141,1],[146,0,146,1],[151,0,151,1],[156,0,156,1],[111,0,111,1],[116,0,116,1],[121,0,121,1],[126,0,126,1],[172,0,172,1],[177,0,177,1],[161,0,161,3],[162,0,162,3],[163,0,163,4],[168,0,168,3],[169,0,169,3],[131,0,131,1],[47,0,47,7],[45,0,45,4],[52,0,52,4],[53,0,53,3],[76,0,76,1],[81,0,81,1],[86,0,86,1],[91,0,91,1],[96,0,96,1],[101,0,101,1],[106,0,106,1],[59,0,59,2],[38,0,38,3],[39,0,39,3],[40,0,40,4],[46,0,46,3],[71,0,71,1],[54,0,54,7],[58,0,58,3],[60,0,60,4],[61,0,61,1],[66,0,66,1],[251,0,251,1],[233,0,233,5],[234,0,234,4],[235,0,235,4],[208,0,208,1],[218,0,218,1],[213,0,213,2],[223,0,223,1],[228,0,228,1],[236,0,236,1],[241,0,241,1],[246,0,246,1],[207,0,207,4],[205,0,205,5],[206,0,206,4],[196,0,196,3],[197,0,197,3],[198,0,198,4],[182,0,182,1],[187,0,187,3],[188,0,188,3],[189,0,189,4],[191,0,191,1]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(E37 = \"\", \"ALL VALUES ARE NOT SUBMITTED !\",\"\")","v":"ALL VALUES ARE NOT SUBMITTED !"}]
[]
[null,null,"Value of Rb is",null,{"$f":"IFERROR((I40*I47+I54)*I60*I163*I170/(I189*I198*(I207+I235)),\"\")","v":""}]
[]
["Mobile fire load factor (Qm)",null,null,null,null,null,null,null,"value of Qm"]
["click to reference guide for mobile fire load factor",null,null,null,null,null,null,null,{"$f":"A44","v":""}]
["Note: there is only one possible entry for this factor. "]
["entry 1 (in kg/m2)"]
[]
[{"$f":"IFERROR(VLOOKUP(A43,'Rb Guides'!A3:B12,2,FALSE),\"\")","v":""}]
[]
["Flammability factor of the mobile fire load (mu)",null,null,null,null,null,null,null,"Value of Mu"]
["click to reference guide for flammability factor of the mobile fire load",null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGEIF(A51:E51,\"<>0\"),\"\")","v":""}]
["note: do not enter more than one of the same options. If there are multiple flammable materials present, please input them all here. "]
["entry 1","entry 2 (if needed)","entry 3 (if needed)","entry 4 (if needed)","entry 5 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A50,'Rb Guides'!H3:I8,2,FALSE), \"\")","v":""},{"$f":"IFERROR(VLOOKUP(B50,'Rb Guides'!H3:I8,2,FALSE), \"\")","v":""},{"$f":"IFERROR(VLOOKUP(C50,'Rb Guides'!H3:I8,2,FALSE), \"\")","v":""},{"$f":"IFERROR(VLOOKUP(D50,'Rb Guides'!H3:I8,2,FALSE), \"\")","v":""},{"$f":"IFERROR(VLOOKUP(E50,'Rb Guides'!H3:I8,2,FALSE), \"\")","v":""}]
[]
["immobile fire load factor (Qi)",null,null,null,null,null,null,null,"Value of Qi"]
["click to reference guide for immobile fire load factor",null,null,null,null,null,null,null,{"$f":"E57","v":""}]
["note: click through each of the scenarios (1-4) and see which support, ceiling, and wall materials apply to the site. "]
["scenario","support material","ceiling material","wall material","Qi"]
[null,{"$f":"IFERROR(VLOOKUP(A57,'Rb Guides'!O3:P6,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A57,'Rb Guides'!O3:Q6,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A57,'Rb Guides'!O3:R6,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A57,'Rb Guides'!O3:S6,5,FALSE),\"\")","v":""}]
[]
["fire source factor (f)",null,null,null,null,null,null,null,"Value of F"]
["click to reference guide for fire source factor",null,null,null,null,null,null,null,{"$f":"IFERROR(1/3*F67+1/3*F100+1/3*F148, \"\")","v":""}]
["Note: This is a multivariate factor. Fill out each section to obtain value of F."]
["people smoking "]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A64,'Rb Guides'!Y5:Z8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B64,'Rb Guides'!Y5:Z9,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,"human fire source"]
["prohibited behavior related to fire",null,null,null,null,{"$f":"IFERROR(0.429*AVERAGEIF(A65:B65,\"<>0\")+0.571*AVERAGEIF(A70:B70,\"<>0\"),\"\")","v":""}]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A69,'Rb Guides'!AA5:AB8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B69,'Rb Guides'!AA5:AB9,2,FALSE),\"\")","v":""}]
[]
["maintenance schedule"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A74,'Rb Guides'!AC5:AD8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B74,'Rb Guides'!AC5:AD9,2,FALSE),\"\")","v":""}]
[null,null,null,"electric wirings"]
["installation condition",null,null,{"$f":"IFERROR(0.759*AVERAGEIF(A75:B75,\"<>0\")+0.241*AVERAGEIF(A80:B80,\"<>0\"),\"\")","v":""}]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A79,'Rb Guides'!AE5:AF8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B79,'Rb Guides'!AE5:AF9,2,FALSE),\"\")","v":""}]
[]
["equiptment up to standard"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A84,'Rb Guides'!AG5:AH8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B84,'Rb Guides'!AG5:AH9,2,FALSE),\"\")","v":""}]
[]
["heat dissipation condition"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A89,'Rb Guides'!AI5:AJ8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B89,'Rb Guides'!AI5:AJ9,2,FALSE),\"\")","v":""},null,"lighting equpment"]
[null,null,null,{"$f":"IFERROR(0.133*AVERAGEIF(A85:B85,\"<>0\")+0.256*AVERAGEIF(A90:B90,\"<>0\")+0.369*AVERAGEIF(A95:B95,\"<>0\")+0.242*AVERAGEIF(A100:B100,\"<>0\"),\"\")","v":""}]
["flammable materials in proximity"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A94,'Rb Guides'!AK5:AL8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B94,'Rb Guides'!AK5:AL9,2,FALSE),\"\")","v":""}]
[]
["spotlight continuous usage time"]
["entry 1","entry 2 (if needed)"]
[null,null,null,null,null,"electrical fire source"]
[{"$f":"IFERROR(VLOOKUP(A99,'Rb Guides'!AM5:AN8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B99,'Rb Guides'!AM5:AN9,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(0.411*D77+0.263*D91+0.216*D111+0.11*D130,\"\")","v":""}]
[]
["equipment up to standard"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A104,'Rb Guides'!AO5:AP8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B104,'Rb Guides'!AO5:AP9,2,FALSE),\"\")","v":""}]
[]
["heat dissipation condition"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A109,'Rb Guides'!AQ5:AR8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B109,'Rb Guides'!AQ5:AR9,2,FALSE),\"\")","v":""},null,"electric appliances"]
[null,null,null,{"$f":"IFERROR(0.128*AVERAGEIF(A105:B105,\"<>0\")+0.288*AVERAGEIF(A110:B110,\"<>0\")+0.353*AVERAGEIF(A115:B115,\"<>0\")+0.231*AVERAGEIF(A120:B120,\"<>0\"),\"\")","v":""}]
["flammable materials in proximity"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A114,'Rb Guides'!AS5:AT8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B114,'Rb Guides'!AS5:AT9,2,FALSE),\"\")","v":""}]
[]
["grounding condition"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A119,'Rb Guides'!AU5:AV8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B119,'Rb Guides'!AU5:AV9,2,FALSE),\"\")","v":""}]
[]
["equiupment up to standard"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A124,'Rb Guides'!AW5:AX8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B124,'Rb Guides'!AW5:AX9,2,FALSE),\"\")","v":""}]
[]
["appearance of electric sparks"]
["entry 1","entry 2 (if needed)"]
[null,null,"power transformation equipment"]
[{"$f":"IFERROR(VLOOKUP(A129,'Rb Guides'!AY5:AZ8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B129,'Rb Guides'!AY5:AZ9,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(0.36*AVERAGEIF(A125:B125,\"<>0\")+0.354*AVERAGEIF(A130:B130,\"<>0\")+0.286*AVERAGEIF(A135:B135,\"<>0\"),\"\")","v":""}]
[]
["grounding condition"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A134,'Rb Guides'!BA5:BB8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B134,'Rb Guides'!BA5:BB9,2,FALSE),\"\")","v":""}]
[]
["presence of "]
["entry 1"]
[]
[{"$f":"IFERROR(VLOOKUP(A139,'Rb Guides'!BC5:BD6,2,FALSE),\"\")","v":""},null,null,"coal"]
[null,null,null,{"$f":"IFERROR(0.5*A140+0.5*AVERAGEIF(A145:B145,\"<>0\"),\"\")","v":""}]
["protection of "]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A144,'Rb Guides'!BE5:BF8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B144,'Rb Guides'!BE5:BF9,2,FALSE),\"\")","v":""}]
[]
["presence of",null,null,null,null,"fuel source"]
["entry 1",null,null,null,null,{"$f":"IFERROR(0.5*D141+0.5*D155,\"\")","v":""}]
[]
[{"$f":"IFERROR(VLOOKUP(A149,'Rb Guides'!BG5:BH6,2,FALSE),\"\")","v":""}]
[]
["protection of"]
["entry 1","entry 2 (if needed)"]
[null,null,"flammable and combustible fuels"]
[{"$f":"IFERROR(VLOOKUP(A154,'Rb Guides'!BI5:BJ8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B154,'Rb Guides'!BI5:BJ9,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(1/3*A150+1/3*AVERAGEIF(A155:B155,\"<>0\")+1/3*AVERAGEIF(A160:B160,\"<>0\"),\"\")","v":""}]
[]
["containment of"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A159,'Rb Guides'!BK5:BL8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B159,'Rb Guides'!BK5:BL9,2,FALSE),\"\")","v":""}]
[]
["building area factor (S)",null,null,null,null,null,null,null,"Value of S"]
["Click to reference building area factor guide",null,null,null,null,null,null,null,{"$f":"A167","v":""}]
["Note: there is only one possible entry for this factor. "]
["entry 1 (in m2)"]
[]
[{"$f":"IFERROR(VLOOKUP(A166,'Rb Guides'!BR3:BS13,2,FALSE),\"\")","v":""}]
[]
["confinement factor ( c)",null,null,null,null,null,null,null,"Value of C"]
["click to reference confinement factor guide",null,null,null,null,null,null,null,{"$f":"IFERROR(0.169*AVERAGEIF(A176:B176,\"<>0\")+0.479*AVERAGEIF(A181:B181,\"<>0\")+0.352*AVERAGEIF(A186:B186,\"<>0\"),\"\")","v":""}]
["note: choose a value for every sub category of confinement factor."]
[]
["design of ventilation system"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A175,'Rb Guides'!BY3:BZ6,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B175,'Rb Guides'!BY3:BZ7,2,FALSE),\"\")","v":""}]
[]
["usability of ventilation system"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A180,'Rb Guides'!CA3:CB6,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B180, 'Rb Guides'!CA3:CB7,2,FALSE),\"\")","v":""}]
[]
["usability of ventilation system"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A185,'Rb Guides'!CC3:CD6,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B185,'Rb Guides'!CC3:CD7,2,FALSE),\"\")","v":""}]
[]
["building fireproof rating factor (W)",null,null,null,null,null,null,null,"Value of W"]
["click to reference the building fireproof rating factor guide",null,null,null,null,null,null,null,{"$f":"A195","v":""}]
["note: click on reference link above to understand which level to assign to the establishment. "]
[]
["fireproof rating of the building"]
["entry 1"]
[]
[{"$f":"IFERROR(VLOOKUP(A194,'Rb Guides'!CL3:CM6,2,FALSE),\"\")","v":""}]
[]
["factor on reduction of fire spreading (Ri)",null,null,null,null,null,null,null,"Value of Ri"]
["click to reference the factor on reduction of fire spreading guide",null,null,null,null,null,null,null,{"$f":"A204","v":""}]
["note: there is only one possible answer for this factor."]
[]
["scenario"]
["entry 1"]
[]
[{"$f":"IFERROR(VLOOKUP(A203,'Rb Guides'!CX3:CY6,2,FALSE),\"\")","v":""}]
[]
["factor on fire fighting capacity of the fire department (Lo)",null,null,null,null,null,null,null,"Value of Lo"]
["Click to reference the factor on fire fighting capacity of the fire department guide",null,null,null,null,null,null,null,{"$f":"IFERROR(0.276*AVERAGEIF(A212:B212,\"<>0\")+0.176*AVERAGEIF(A217:B217,\"<>0\")+0.144*AVERAGEIF(A222:B222,\"<>0\")+0.255*AVERAGEIF(A227:B227,\"<>0\")+0.151*AVERAGEIF(A232,\"<>0\"),\"\")","v":""}]
["note: there may be more than one answer per variable. "]
["fire department equipment"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A211,'Rb Guides'!DJ4:DK7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B211,'Rb Guides'!DJ4:DK8,2,FALSE),\"\")","v":""}]
[]
["firefighting experience of the fire department"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A216,'Rb Guides'!DL4:DM7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B216,'Rb Guides'!DL4:DM8,2,FALSE),\"\")","v":""}]
[]
["fire lane availability"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A221,'Rb Guides'!DN4:DO7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B221,'Rb Guides'!DN4:DO8,2,FALSE),\"\")","v":""}]
[]
["outdoor fire hydrant"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A226,'Rb Guides'!DP4:DQ7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B226,'Rb Guides'!DP4:DQ8,2,FALSE),\"\")","v":""}]
[]
["nearest fire station response time"]
["entry 1"]
[]
[{"$f":"IFERROR(VLOOKUP(A231,'Rb Guides'!DR4:DS7,2,FALSE),\"\")","v":""}]
[]
["factor on firefighting equipment in the building (Li)",null,null,null,null,null,null,null,"Value of Li"]
["Click here to reference factor on firefighting equiptment in the building guide",null,null,null,null,null,null,null,{"$f":"IFERROR(0.429*AVERAGEIF(A240:B240,\"<>0\")+0.226*AVERAGEIF(A245:B245,\"<>0\")+0.194*AVERAGEIF(A250:B250,\"<>0\")+0.151*AVERAGEIF(A255:B255,\"<>0\"),\"\")","v":""}]
["note: there may be more than one answer per variable. "]
["fire detection system"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A239,'Rb Guides'!DT4:DU7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B239,'Rb Guides'!DT4:DU8,2,FALSE),\"\")","v":""}]
[]
["sprinkler system"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A244,'Rb Guides'!DV4:DW7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B244,'Rb Guides'!DV4:DW8,2,FALSE),\"\")","v":""}]
[]
["indoor fire hydrant"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A249,'Rb Guides'!DX4:DY7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B249,'Rb Guides'!DX4:DY8,2,FALSE),\"\")","v":""}]
[]
["fire extinguisher"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A254,'Rb Guides'!DZ4:EA7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B254,'Rb Guides'!DZ4:EA8,2,FALSE),\"\")","v":""}]

{"sheet":"Rp Calculations","index":4,"n_rows":112,"n_cols":9,"rows_kept":112,"cut":false,"hidden":false,"merged":[[95,8,95,9],[96,8,97,9],[19,2,19,4],[25,8,26,9],[31,8,31,9],[32,8,33,9],[38,8,38,9],[33,0,33,2],[24,8,24,9],[68,8,68,9],[61,8,61,9],[60,8,60,9],[64,8,64,9],[66,8,66,9],[67,8,67,9],[39,8,40,9],[56,8,56,9],[57,8,58,9],[32,0,32,3],[39,0,39,3],[38,0,38,3],[21,2,21,3],[96,0,96,4],[57,0,57,2],[59,0,59,1],[41,0,41,1],[46,0,46,1],[56,0,56,2],[24,0,24,3],[25,0,25,3],[26,0,26,4],[108,0,108,1],[12,0,12,1],[95,0,95,3],[97,0,97,2],[98,0,98,1],[103,0,103,1],[75,0,75,1],[74,0,74,3],[80,0,80,1],[85,0,85,1],[90,0,90,1],[64,0,64,1],[69,0,69,1],[40,0,40,4],[58,0,58,4],[51,0,51,1]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(E22 = \"\", \"ALL VALUES ARE NOT SUBMITTED!\",\"\")","v":"ALL VALUES ARE NOT SUBMITTED!"}]
[]
[null,null,"value of Rp is ",null,{"$f":"IFERROR((I26*I33)/(I40*I58*I97),\"\")","v":""}]
[]
[]
["Smoke Toxicity Factor (T)",null,null,null,null,null,null,null,"value of T"]
["Click to Reference Smoke Toxicity Factor Guide",null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGEIF(A30:D30,\"<>0\"),\"\")","v":""}]
["Note: Do not enter repeat entries in this section. If there are less than 4 entires, choose \"non applicable.\""]
["entry 1","entry 2","entry 3","entry 4"]
[]
[{"$f":"IFERROR(VLOOKUP(A29,'Rp Guides'!A3:B7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B29,'Rp Guides'!A3:B7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C29,'Rp Guides'!A3:B7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D29,'Rp Guides'!A3:B7,2,FALSE),\"\")","v":""}]
[]
["User characteristic factor (F)",null,null,null,null,null,null,null,"value of F"]
["Click to Reference User Characteristic Factor Guide",null,null,null,null,null,null,null,{"$f":"A37","v":""}]
["Note: you can only enter one value in this section."]
["entry 1"]
[]
[{"$f":"IFERROR(VLOOKUP(A36,'Rp Guides'!E3:F8,2,FALSE),\"\")","v":""}]
[]
["Automatic fire alarm factor (K)",null,null,null,null,null,null,null,"value of k"]
["Click to Reference the Automatic Fire Alarm Factor Guide",null,null,null,null,null,null,null,{"$f":"IFERROR(1/3*AVERAGEIF(A45:B45,\"<>0\")+1/3*AVERAGEIF(A50:B50,\"<>0\")+1/3*A55,\"\")","v":""}]
["Note: This is a multivariate factor. Fill out the design of fire detection system section and the usability of fire detection system section. "]
["design of fire detection system(s)"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A44,'Rp Guides'!BL3:BM7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B44,'Rp Guides'!BL3:BM7,2,FALSE),\"\")","v":""}]
[]
["usability of fire detection system(s)"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(DesignofFireDetectionSystem,'Rp Guides'!N3:O7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B49,'Rp Guides'!N3:O7,2,FALSE),\"\")","v":""}]
[]
["system approval "]
["entry 1"]
[]
[{"$f":"IFERROR(VLOOKUP(A54,'Rp Guides'!P2:Q4,2,FALSE),\"\")","v":""}]
[]
["evacuation capacity factor ( E)",null,null,null,null,null,null,null,"Value of E"]
["Click to reference the evacuation capacity factor guide",null,null,null,null,null,null,null,{"$f":"IFERROR(0.381*D68+0.619*D87,\"\")","v":""}]
["Note: This is the evacuation route section. Make sure to fill out all of the subsections. "]
["distance to exits"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A62,'Rp Guides'!AE5:AF8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B62,'Rp Guides'!AE5:AF8,2,FALSE),\"\")","v":""}]
[]
["clearance of the route"]
["entry 1","entry 2 (if needed)"]
[null,null,null,"evacuation route "]
[{"$f":"IFERROR(VLOOKUP(A67,'Rp Guides'!AG5:AH8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B67,'Rp Guides'!AG5:AH8,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(0.052*AVERAGEIF(A63:B63,\"<>0\")+0.336*AVERAGEIF(A68:B68,\"<>0\")+0.612*AVERAGEIF(A73:B73,\"<>0\"),\"\")","v":""}]
[]
["design of the exits"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A72,'Rp Guides'!AI5:AJ8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B72,'Rp Guides'!AI5:AJ8,2,FALSE),\"\")","v":""}]
[]
["Note: This is the evacuation equiptment section. Make sure to fill out all of the subsections. "]
["signs to exits"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A78,'Rp Guides'!AK5:AL8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B78,'Rp Guides'!AK5:AL8,2,FALSE),\"\")","v":""}]
[]
["design of evacuation stairs"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A83,'Rp Guides'!AM5:AN8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B83,'Rp Guides'!AM5:AN8,2,FALSE),\"\")","v":""}]
[]
["emergency lighting system",null,null,"evacuation equiptment"]
["entry 1","entry 2 (if needed)",null,{"$f":"IFERROR(0.203*AVERAGEIF(A79:B79,\"<>0\")+0.506*AVERAGEIF(A84:B84,\"<>0\")+0.203*AVERAGEIF(A89:B89,\"<>0\")+0.098*AVERAGEIF(A94:B94,\"<>0\"),\"\")","v":""}]
[]
[{"$f":"IFERROR(VLOOKUP(A88,'Rp Guides'!AO4:AP8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B88,'Rp Guides'!AO4:AP8,2,FALSE),\"\")","v":""}]
[]
["emergency announcement system"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A93,'Rp Guides'!AQ4:AR7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B93,'Rp Guides'!AQ4:AR7,2,FALSE),\"\")","v":""}]
[]
["ventilation and smoke extraction factor (H)",null,null,null,null,null,null,null,"value of H"]
["Click to reference the ventilation and smoke extraction factor guide",null,null,null,null,null,null,null,{"$f":"IFERROR(1/3*AVERAGEIF(A102:B102,\"<>0\")+1/3*AVERAGEIF(A107:B107,\"<>0\")+1/3*A112,\"\")","v":""}]
["Note: You must fill out every subsection for this factor. "]
["design of smoke extraction system"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A101,'Rp Guides'!BL4:BM7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B101,'Rp Guides'!BL4:BM7,2,FALSE),\"\")","v":""}]
[]
["USABILITY OF SMOKE EXTRACTION SYSTEM"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A106,'Rp Guides'!BN4:BO7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B106,'Rp Guides'!BN4:BO7,2,FALSE),\"\")","v":""}]
[]
["type of smoke extraction/ventilation"]
["Entry 1"]
[]
[{"$f":"IFERROR(VLOOKUP(A111,'Rp Guides'!BP4:BQ6,2,FALSE),\"\")","v":""}]

{"sheet":"Rb Calculations (2)","index":5,"n_rows":255,"n_cols":9,"rows_kept":255,"cut":false,"hidden":false,"merged":[[251,0,251,1],[234,0,234,4],[234,8,235,9],[235,0,235,4],[236,0,236,1],[241,0,241,1],[246,0,246,1],[233,8,233,9],[205,0,205,5],[205,8,205,9],[206,0,206,4],[206,8,207,9],[207,0,207,4],[208,0,208,1],[213,0,213,2],[218,0,218,1],[223,0,223,1],[228,0,228,1],[233,0,233,5],[191,0,191,1],[196,0,196,3],[196,8,196,9],[197,0,197,3],[197,8,198,9],[198,0,198,4],[188,0,188,3],[188,8,189,9],[189,0,189,4],[162,0,162,3],[162,8,163,9],[163,0,163,4],[168,0,168,3],[168,8,168,9],[169,0,169,3],[169,8,170,9],[170,0,170,4],[172,0,172,1],[177,0,177,1],[182,0,182,1],[187,0,187,3],[187,8,187,9],[161,8,161,9],[121,0,121,1],[126,0,126,1],[128,2,128,4],[131,0,131,1],[136,0,136,1],[141,0,141,1],[146,0,146,1],[151,0,151,1],[153,2,153,4],[156,0,156,1],[161,0,161,3],[116,0,116,1],[61,0,61,1],[66,0,66,1],[71,0,71,1],[76,0,76,1],[81,0,81,1],[86,0,86,1],[91,0,91,1],[96,0,96,1],[101,0,101,1],[106,0,106,1],[111,0,111,1],[59,0,59,3],[59,8,60,9],[60,0,60,4],[45,0,45,4],[45,8,45,9],[46,0,46,3],[46,8,47,9],[47,0,47,7],[52,0,52,4],[52,8,52,9],[53,0,53,3],[53,8,54,9],[54,0,54,7],[58,0,58,3],[58,8,58,9],[34,2,34,4],[36,2,36,3],[38,0,38,3],[38,8,38,9],[39,0,39,3],[39,8,40,9],[40,0,40,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(E37 = \"\", \"ALL VALUES ARE NOT SUBMITTED !\",\"\")","v":"ALL VALUES ARE NOT SUBMITTED !"}]
[]
[null,null,"Value of Rb is",null,{"$f":"IFERROR((I40*I47+I54)*I60*I163*I170/(I189*I198*(I207+I235)),\"\")","v":""}]
[]
["Mobile fire load factor (Qm)",null,null,null,null,null,null,null,"value of Qm"]
["click to reference guide for mobile fire load factor",null,null,null,null,null,null,null,{"$f":"A44","v":""}]
["Note: there is only one possible entry for this factor. "]
["entry 1 (in kg/m2)"]
[]
[{"$f":"IFERROR(VLOOKUP(A43,'Rb Guides'!A3:B12,2,FALSE),\"\")","v":""}]
[]
["Flammability factor of the mobile fire load (mu)",null,null,null,null,null,null,null,"Value of Mu"]
["click to reference guide for flammability factor of the mobile fire load",null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGEIF(A51:E51,\"<>0\"),\"\")","v":""}]
["note: do not enter more than one of the same options. If there are multiple flammable materials present, please input them all here. "]
["entry 1","entry 2 (if needed)","entry 3 (if needed)","entry 4 (if needed)","entry 5 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A50,'Rb Guides'!H3:I8,2,FALSE), \"\")","v":""},{"$f":"IFERROR(VLOOKUP(B50,'Rb Guides'!H3:I8,2,FALSE), \"\")","v":""},{"$f":"IFERROR(VLOOKUP(C50,'Rb Guides'!H3:I8,2,FALSE), \"\")","v":""},{"$f":"IFERROR(VLOOKUP(D50,'Rb Guides'!H3:I8,2,FALSE), \"\")","v":""},{"$f":"IFERROR(VLOOKUP(E50,'Rb Guides'!H3:I8,2,FALSE), \"\")","v":""}]
[]
["immobile fire load factor (Qi)",null,null,null,null,null,null,null,"Value of Qi"]
["click to reference guide for immobile fire load factor",null,null,null,null,null,null,null,{"$f":"E57","v":""}]
["note: click through each of the scenarios (1-4) and see which support, ceiling, and wall materials apply to the site. "]
["scenario","support material","ceiling material","wall material","Qi"]
[null,{"$f":"IFERROR(VLOOKUP(A57,'Rb Guides'!O3:P6,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A57,'Rb Guides'!O3:Q6,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A57,'Rb Guides'!O3:R6,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A57,'Rb Guides'!O3:S6,5,FALSE),\"\")","v":""}]
[]
["fire source factor (f)",null,null,null,null,null,null,null,"Value of F"]
["click to reference guide for fire source factor",null,null,null,null,null,null,null,{"$f":"IFERROR(1/3*F67+1/3*F100+1/3*F148, \"\")","v":""}]
["Note: This is a multivariate factor. Fill out each section to obtain value of F."]
["people smoking "]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A64,'Rb Guides'!Y5:Z8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B64,'Rb Guides'!Y5:Z9,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,"human fire source"]
["prohibited behavior related to fire",null,null,null,null,{"$f":"IFERROR(0.429*AVERAGEIF(A65:B65,\"<>0\")+0.571*AVERAGEIF(A70:B70,\"<>0\"),\"\")","v":""}]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A69,'Rb Guides'!AA5:AB8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B69,'Rb Guides'!AA5:AB9,2,FALSE),\"\")","v":""}]
[]
["maintenance schedule"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A74,'Rb Guides'!AC5:AD8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B74,'Rb Guides'!AC5:AD9,2,FALSE),\"\")","v":""}]
[null,null,null,"electric wirings"]
["installation condition",null,null,{"$f":"IFERROR(0.759*AVERAGEIF(A75:B75,\"<>0\")+0.241*AVERAGEIF(A80:B80,\"<>0\"),\"\")","v":""}]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A79,'Rb Guides'!AE5:AF8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B79,'Rb Guides'!AE5:AF9,2,FALSE),\"\")","v":""}]
[]
["equiptment up to standard"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A84,'Rb Guides'!AG5:AH8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B84,'Rb Guides'!AG5:AH9,2,FALSE),\"\")","v":""}]
[]
["heat dissipation condition"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A89,'Rb Guides'!AI5:AJ8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B89,'Rb Guides'!AI5:AJ9,2,FALSE),\"\")","v":""},null,"lighting equpment"]
[null,null,null,{"$f":"IFERROR(0.133*AVERAGEIF(A85:B85,\"<>0\")+0.256*AVERAGEIF(A90:B90,\"<>0\")+0.369*AVERAGEIF(A95:B95,\"<>0\")+0.242*AVERAGEIF(A100:B100,\"<>0\"),\"\")","v":""}]
["flammable materials in proximity"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A94,'Rb Guides'!AK5:AL8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B94,'Rb Guides'!AK5:AL9,2,FALSE),\"\")","v":""}]
[]
["spotlight continuous usage time"]
["entry 1","entry 2 (if needed)"]
[null,null,null,null,null,"electrical fire source"]
[{"$f":"IFERROR(VLOOKUP(A99,'Rb Guides'!AM5:AN8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B99,'Rb Guides'!AM5:AN9,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(0.411*D77+0.263*D91+0.216*D111+0.11*D130,\"\")","v":""}]
[]
["equipment up to standard"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A104,'Rb Guides'!AO5:AP8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B104,'Rb Guides'!AO5:AP9,2,FALSE),\"\")","v":""}]
[]
["heat dissipation condition"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A109,'Rb Guides'!AQ5:AR8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B109,'Rb Guides'!AQ5:AR9,2,FALSE),\"\")","v":""},null,"electric appliances"]
[null,null,null,{"$f":"IFERROR(0.128*AVERAGEIF(A105:B105,\"<>0\")+0.288*AVERAGEIF(A110:B110,\"<>0\")+0.353*AVERAGEIF(A115:B115,\"<>0\")+0.231*AVERAGEIF(A120:B120,\"<>0\"),\"\")","v":""}]
["flammable materials in proximity"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A114,'Rb Guides'!AS5:AT8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B114,'Rb Guides'!AS5:AT9,2,FALSE),\"\")","v":""}]
[]
["grounding condition"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A119,'Rb Guides'!AU5:AV8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B119,'Rb Guides'!AU5:AV9,2,FALSE),\"\")","v":""}]
[]
["equupment up to standard"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A124,'Rb Guides'!AW5:AX8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B124,'Rb Guides'!AW5:AX9,2,FALSE),\"\")","v":""}]
[]
["appearance of electric sparks"]
["entry 1","entry 2 (if needed)"]
[null,null,"power transformation equipment"]
[{"$f":"IFERROR(VLOOKUP(A129,'Rb Guides'!AY5:AZ8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B129,'Rb Guides'!AY5:AZ9,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(0.36*AVERAGEIF(A125:B125,\"<>0\")+0.354*AVERAGEIF(A130:B130,\"<>0\")+0.286*AVERAGEIF(A135:B135,\"<>0\"),\"\")","v":""}]
[]
["grounding condition"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A134,'Rb Guides'!BA5:BB8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B134,'Rb Guides'!BA5:BB9,2,FALSE),\"\")","v":""}]
[]
["presence of "]
["entry 1"]
[]
[{"$f":"IFERROR(VLOOKUP(A139,'Rb Guides'!BC5:BD6,2,FALSE),\"\")","v":""},null,null,"coal"]
[null,null,null,{"$f":"IFERROR(0.5*A140+0.5*AVERAGEIF(A145:B145,\"<>0\"),\"\")","v":""}]
["protection of "]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A144,'Rb Guides'!BE5:BF8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B144,'Rb Guides'!BE5:BF9,2,FALSE),\"\")","v":""}]
[]
["presence of",null,null,null,null,"fuel source"]
["entry 1",null,null,null,null,{"$f":"IFERROR(0.5*D141+0.5*D155,\"\")","v":""}]
[]
[{"$f":"IFERROR(VLOOKUP(A149,'Rb Guides'!BG5:BH6,2,FALSE),\"\")","v":""}]
[]
["protection of"]
["entry 1","entry 2 (if needed)"]
[null,null,"flammable and combustible fuels"]
[{"$f":"IFERROR(VLOOKUP(A154,'Rb Guides'!BI5:BJ8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B154,'Rb Guides'!BI5:BJ9,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(1/3*A150+1/3*AVERAGEIF(A155:B155,\"<>0\")+1/3*AVERAGEIF(A160:B160,\"<>0\"),\"\")","v":""}]
[]
["containment of"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A159,'Rb Guides'!BK5:BL8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B159,'Rb Guides'!BK5:BL9,2,FALSE),\"\")","v":""}]
[]
["building area factor (S)",null,null,null,null,null,null,null,"Value of S"]
["Click to reference building area factor guide",null,null,null,null,null,null,null,{"$f":"A167","v":""}]
["Note: there is only one possible entry for this factor. "]
["entry 1 (in m2)"]
[]
[{"$f":"IFERROR(VLOOKUP(A166,'Rb Guides'!BR3:BS13,2,FALSE),\"\")","v":""}]
[]
["confinement factor ( c)",null,null,null,null,null,null,null,"Value of C"]
["click to reference confinement factor guide",null,null,null,null,null,null,null,{"$f":"IFERROR(0.169*AVERAGEIF(A176:B176,\"<>0\")+0.479*AVERAGEIF(A181:B181,\"<>0\")+0.352*AVERAGEIF(A186:B186,\"<>0\"),\"\")","v":""}]
["note: choose a value for every sub category of confinement factor."]
[]
["design of ventilation system"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A175,'Rb Guides'!BY3:BZ6,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B175,'Rb Guides'!BY3:BZ7,2,FALSE),\"\")","v":""}]
[]
["usability of ventilation system"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A180,'Rb Guides'!CA3:CB6,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B180, 'Rb Guides'!CA3:CB7,2,FALSE),\"\")","v":""}]
[]
["usability of ventilation system"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A185,'Rb Guides'!CC3:CD6,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B185,'Rb Guides'!CC3:CD7,2,FALSE),\"\")","v":""}]
[]
["building fireproof rating factor (W)",null,null,null,null,null,null,null,"Value of W"]
["click to reference the building fireproof rating factor guide",null,null,null,null,null,null,null,{"$f":"A195","v":""}]
["note: click on reference link above to understand which level to assign to the establishment. "]
[]
["fireproof rating of the building"]
["entry 1"]
[]
[{"$f":"IFERROR(VLOOKUP(A194,'Rb Guides'!CL3:CM6,2,FALSE),\"\")","v":""}]
[]
["factor on reduction of fire spreading (Ri)",null,null,null,null,null,null,null,"Value of Ri"]
["click to reference the factor on reduction of fire spreading guide",null,null,null,null,null,null,null,{"$f":"A204","v":""}]
["note: there is only one possible answer for this factor."]
[]
["scenario"]
["entry 1"]
[]
[{"$f":"IFERROR(VLOOKUP(A203,'Rb Guides'!CX3:CY6,2,FALSE),\"\")","v":""}]
[]
["factor on fire fighting capacity of the fire department (Lo)",null,null,null,null,null,null,null,"Value of Lo"]
["Click to reference the factor on fire fighting capacity of the fire department guide",null,null,null,null,null,null,null,{"$f":"IFERROR(0.276*AVERAGEIF(A212:B212,\"<>0\")+0.176*AVERAGEIF(A217:B217,\"<>0\")+0.144*AVERAGEIF(A222:B222,\"<>0\")+0.255*AVERAGEIF(A227:B227,\"<>0\")+0.151*AVERAGEIF(A232,\"<>0\"),\"\")","v":""}]
["note: there may be more than one answer per variable. "]
["fire department equipment"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A211,'Rb Guides'!DJ4:DK7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B211,'Rb Guides'!DJ4:DK8,2,FALSE),\"\")","v":""}]
[]
["firefighting experience of the fire department"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A216,'Rb Guides'!DL4:DM7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B216,'Rb Guides'!DL4:DM8,2,FALSE),\"\")","v":""}]
[]
["fire lane availability"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A221,'Rb Guides'!DN4:DO7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B221,'Rb Guides'!DN4:DO8,2,FALSE),\"\")","v":""}]
[]
["outdoor fire hydrant"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A226,'Rb Guides'!DP4:DQ7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B226,'Rb Guides'!DP4:DQ8,2,FALSE),\"\")","v":""}]
[]
["nearest fire station response time"]
["entry 1"]
[]
[{"$f":"IFERROR(VLOOKUP(A231,'Rb Guides'!DR4:DS7,2,FALSE),\"\")","v":""}]
[]
["factor on firefighting equipment in the building (Li)",null,null,null,null,null,null,null,"Value of Li"]
["Click here to reference factor on firefighting equiptment in the building guide",null,null,null,null,null,null,null,{"$f":"IFERROR(0.429*AVERAGEIF(A240:B240,\"<>0\")+0.226*AVERAGEIF(A245:B245,\"<>0\")+0.194*AVERAGEIF(A250:B250,\"<>0\")+0.151*AVERAGEIF(A255:B255,\"<>0\"),\"\")","v":""}]
["note: there may be more than one answer per variable. "]
["fire detection system"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A239,'Rb Guides'!DT4:DU7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B239,'Rb Guides'!DT4:DU8,2,FALSE),\"\")","v":""}]
[]
["sprinkler system"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A244,'Rb Guides'!DV4:DW7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B244,'Rb Guides'!DV4:DW8,2,FALSE),\"\")","v":""}]
[]
["indoor fire hydrant"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A249,'Rb Guides'!DX4:DY7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B249,'Rb Guides'!DX4:DY8,2,FALSE),\"\")","v":""}]
[]
["fire extinguisher"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A254,'Rb Guides'!DZ4:EA7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B254,'Rb Guides'!DZ4:EA8,2,FALSE),\"\")","v":""}]

{"sheet":"Rp Calculations (2)","index":6,"n_rows":112,"n_cols":9,"rows_kept":112,"cut":false,"hidden":false,"merged":[[98,0,98,1],[103,0,103,1],[108,0,108,1],[90,0,90,1],[95,0,95,3],[95,8,95,9],[96,0,96,4],[96,8,97,9],[97,0,97,2],[68,8,68,9],[69,0,69,1],[74,0,74,3],[75,0,75,1],[80,0,80,1],[85,0,85,1],[67,8,67,9],[56,0,56,2],[56,8,56,9],[57,0,57,2],[57,8,58,9],[58,0,58,4],[59,0,59,1],[60,8,60,9],[61,8,61,9],[64,0,64,1],[64,8,64,9],[66,8,66,9],[51,0,51,1],[31,8,31,9],[32,0,32,3],[32,8,33,9],[33,0,33,2],[38,0,38,3],[38,8,38,9],[39,0,39,3],[39,8,40,9],[40,0,40,4],[41,0,41,1],[46,0,46,1],[25,0,25,3],[25,8,26,9],[26,0,26,4],[12,0,12,1],[19,2,19,4],[21,2,21,3],[24,0,24,3],[24,8,24,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(E22 = \"\", \"ALL VALUES ARE NOT SUBMITTED!\",\"\")","v":"ALL VALUES ARE NOT SUBMITTED!"}]
[]
[null,null,"value of Rp is ",null,{"$f":"IFERROR((I26*I33)/(I40*I58*I97),\"\")","v":""}]
[]
[]
["Smoke Toxicity Factor (T)",null,null,null,null,null,null,null,"value of T"]
["Click to Reference Smoke Toxicity Factor Guide",null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGEIF(A30:D30,\"<>0\"),\"\")","v":""}]
["Note: Do not enter repeat entries in this section. If there are less than 4 entires, choose \"non applicable.\""]
["entry 1","entry 2","entry 3","entry 4"]
[]
[{"$f":"IFERROR(VLOOKUP(A29,'Rp Guides'!A3:B7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B29,'Rp Guides'!A3:B7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C29,'Rp Guides'!A3:B7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D29,'Rp Guides'!A3:B7,2,FALSE),\"\")","v":""}]
[]
["User characteristic factor (F)",null,null,null,null,null,null,null,"value of F"]
["Click to Reference User Characteristic Factor Guide",null,null,null,null,null,null,null,{"$f":"A37","v":""}]
["Note: you can only enter one value in this section."]
["entry 1"]
[]
[{"$f":"IFERROR(VLOOKUP(A36,'Rp Guides'!E3:F8,2,FALSE),\"\")","v":""}]
[]
["Automatic fire alarm factor (K)",null,null,null,null,null,null,null,"value of k"]
["Click to Reference the Automatic Fire Alarm Factor Guide",null,null,null,null,null,null,null,{"$f":"IFERROR(1/3*AVERAGEIF(A45:B45,\"<>0\")+1/3*AVERAGEIF(A50:B50,\"<>0\")+1/3*A55,\"\")","v":""}]
["Note: This is a multivariate factor. Fill out the design of fire detection system section and the usability of fire detection system section. "]
["design of fire detection system(s)"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A44,'Rp Guides'!BL3:BM7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B44,'Rp Guides'!BL3:BM7,2,FALSE),\"\")","v":""}]
[]
["usability of fire detection system(s)"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(DesignofFireDetectionSystem,'Rp Guides'!BN3:BO7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B49,'Rp Guides'!BN3:BO7,2,FALSE),\"\")","v":""}]
[]
["system approval "]
["entry 1"]
[]
[{"$f":"IFERROR(VLOOKUP(A54,'Rp Guides'!P2:Q4,2,FALSE),\"\")","v":""}]
[]
["evacuation capacity factor ( E)",null,null,null,null,null,null,null,"Value of E"]
["Click to reference the evacuation capacity factor guide",null,null,null,null,null,null,null,{"$f":"IFERROR(0.381*D68+0.619*D87,\"\")","v":""}]
["Note: This is the evacuation route section. Make sure to fill out all of the subsections. "]
["distance to exits"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A62,'Rp Guides'!AE5:AF8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B62,'Rp Guides'!AE5:AF8,2,FALSE),\"\")","v":""}]
[]
["clearance of the route"]
["entry 1","entry 2 (if needed)"]
[null,null,null,"evacuation route "]
[{"$f":"IFERROR(VLOOKUP(A67,'Rp Guides'!AG5:AH8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B67,'Rp Guides'!AG5:AH8,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(0.052*AVERAGEIF(A63:B63,\"<>0\")+0.336*AVERAGEIF(A68:B68,\"<>0\")+0.612*AVERAGEIF(A73:B73,\"<>0\"),\"\")","v":""}]
[]
["design of the exits"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A72,'Rp Guides'!AI5:AJ8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B72,'Rp Guides'!AI5:AJ8,2,FALSE),\"\")","v":""}]
[]
["Note: This is the evacuation equiptment section. Make sure to fill out all of the subsections. "]
["signs to exits"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A78,'Rp Guides'!AK5:AL8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B78,'Rp Guides'!AK5:AL8,2,FALSE),\"\")","v":""}]
[]
["design of evacuation stairs"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A83,'Rp Guides'!AM5:AN8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B83,'Rp Guides'!AM5:AN8,2,FALSE),\"\")","v":""}]
[]
["emergency lighting system",null,null,"evacuation equiptment"]
["entry 1","entry 2 (if needed)",null,{"$f":"IFERROR(0.203*AVERAGEIF(A79:B79,\"<>0\")+0.506*AVERAGEIF(A84:B84,\"<>0\")+0.203*AVERAGEIF(A89:B89,\"<>0\")+0.098*AVERAGEIF(A94:B94,\"<>0\"),\"\")","v":""}]
[]
[{"$f":"IFERROR(VLOOKUP(A88,'Rp Guides'!AO4:AP8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B88,'Rp Guides'!AO4:AP8,2,FALSE),\"\")","v":""}]
[]
["emergency announcement system"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A93,'Rp Guides'!AQ4:AR7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B93,'Rp Guides'!AQ4:AR7,2,FALSE),\"\")","v":""}]
[]
["ventilation and smoke extraction factor (H)",null,null,null,null,null,null,null,"value of H"]
["Click to reference the ventilation and smoke extraction factor guide",null,null,null,null,null,null,null,{"$f":"IFERROR(1/3*AVERAGEIF(A102:B102,\"<>0\")+1/3*AVERAGEIF(A107:B107,\"<>0\")+1/3*A112,\"\")","v":""}]
["Note: You must fill out every subsection for this factor. "]
["design of smoke extraction system"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A101,'Rp Guides'!BL4:BM7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B101,'Rp Guides'!BL4:BM7,2,FALSE),\"\")","v":""}]
[]
["USABILITY OF SMOKE EXTRACTION SYSTEM"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A106,'Rp Guides'!BN4:BO7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B106,'Rp Guides'!BN4:BO7,2,FALSE),\"\")","v":""}]
[]
["type of smoke extraction/ventilation"]
["Entry 1"]
[]
[{"$f":"IFERROR(VLOOKUP(A111,'Rp Guides'!BP4:BQ6,2,FALSE),\"\")","v":""}]

{"sheet":"Rb Calculations (3)","index":7,"n_rows":255,"n_cols":9,"rows_kept":255,"cut":false,"hidden":false,"merged":[[251,0,251,1],[234,0,234,4],[234,8,235,9],[235,0,235,4],[236,0,236,1],[241,0,241,1],[246,0,246,1],[233,8,233,9],[205,0,205,5],[205,8,205,9],[206,0,206,4],[206,8,207,9],[207,0,207,4],[208,0,208,1],[213,0,213,2],[218,0,218,1],[223,0,223,1],[228,0,228,1],[233,0,233,5],[191,0,191,1],[196,0,196,3],[196,8,196,9],[197,0,197,3],[197,8,198,9],[198,0,198,4],[188,0,188,3],[188,8,189,9],[189,0,189,4],[162,0,162,3],[162,8,163,9],[163,0,163,4],[168,0,168,3],[168,8,168,9],[169,0,169,3],[169,8,170,9],[170,0,170,4],[172,0,172,1],[177,0,177,1],[182,0,182,1],[187,0,187,3],[187,8,187,9],[161,8,161,9],[121,0,121,1],[126,0,126,1],[128,2,128,4],[131,0,131,1],[136,0,136,1],[141,0,141,1],[146,0,146,1],[151,0,151,1],[153,2,153,4],[156,0,156,1],[161,0,161,3],[116,0,116,1],[61,0,61,1],[66,0,66,1],[71,0,71,1],[76,0,76,1],[81,0,81,1],[86,0,86,1],[91,0,91,1],[96,0,96,1],[101,0,101,1],[106,0,106,1],[111,0,111,1],[59,0,59,3],[59,8,60,9],[60,0,60,4],[45,0,45,4],[45,8,45,9],[46,0,46,3],[46,8,47,9],[47,0,47,7],[52,0,52,4],[52,8,52,9],[53,0,53,3],[53,8,54,9],[54,0,54,7],[58,0,58,3],[58,8,58,9],[34,2,34,4],[36,2,36,3],[38,0,38,3],[38,8,38,9],[39,0,39,3],[39,8,40,9],[40,0,40,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(E37 = \"\", \"ALL VALUES ARE NOT SUBMITTED !\",\"\")","v":"ALL VALUES ARE NOT SUBMITTED !"}]
[]
[null,null,"Value of Rb is",null,{"$f":"IFERROR((I40*I47+I54)*I60*I163*I170/(I189*I198*(I207+I235)),\"\")","v":""}]
[]
["Mobile fire load factor (Qm)",null,null,null,null,null,null,null,"value of Qm"]
["click to reference guide for mobile fire load factor",null,null,null,null,null,null,null,{"$f":"A44","v":""}]
["Note: there is only one possible entry for this factor. "]
["entry 1 (in kg/m2)"]
[]
[{"$f":"IFERROR(VLOOKUP(A43,'Rb Guides'!A3:B12,2,FALSE),\"\")","v":""}]
[]
["Flammability factor of the mobile fire load (mu)",null,null,null,null,null,null,null,"Value of Mu"]
["click to reference guide for flammability factor of the mobile fire load",null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGEIF(A51:E51,\"<>0\"),\"\")","v":""}]
["note: do not enter more than one of the same options. If there are multiple flammable materials present, please input them all here. "]
["entry 1","entry 2 (if needed)","entry 3 (if needed)","entry 4 (if needed)","entry 5 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A50,'Rb Guides'!H3:I8,2,FALSE), \"\")","v":""},{"$f":"IFERROR(VLOOKUP(B50,'Rb Guides'!H3:I8,2,FALSE), \"\")","v":""},{"$f":"IFERROR(VLOOKUP(C50,'Rb Guides'!H3:I8,2,FALSE), \"\")","v":""},{"$f":"IFERROR(VLOOKUP(D50,'Rb Guides'!H3:I8,2,FALSE), \"\")","v":""},{"$f":"IFERROR(VLOOKUP(E50,'Rb Guides'!H3:I8,2,FALSE), \"\")","v":""}]
[]
["immobile fire load factor (Qi)",null,null,null,null,null,null,null,"Value of Qi"]
["click to reference guide for immobile fire load factor",null,null,null,null,null,null,null,{"$f":"E57","v":""}]
["note: click through each of the scenarios (1-4) and see which support, ceiling, and wall materials apply to the site. "]
["scenario","support material","ceiling material","wall material","Qi"]
[null,{"$f":"IFERROR(VLOOKUP(A57,'Rb Guides'!O3:P6,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A57,'Rb Guides'!O3:Q6,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A57,'Rb Guides'!O3:R6,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A57,'Rb Guides'!O3:S6,5,FALSE),\"\")","v":""}]
[]
["fire source factor (f)",null,null,null,null,null,null,null,"Value of F"]
["click to reference guide for fire source factor",null,null,null,null,null,null,null,{"$f":"IFERROR(1/3*F67+1/3*F100+1/3*F148, \"\")","v":""}]
["Note: This is a multivariate factor. Fill out each section to obtain value of F."]
["people smoking "]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A64,'Rb Guides'!Y5:Z8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B64,'Rb Guides'!Y5:Z9,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,"human fire source"]
["prohibited behavior related to fire",null,null,null,null,{"$f":"IFERROR(0.429*AVERAGEIF(A65:B65,\"<>0\")+0.571*AVERAGEIF(A70:B70,\"<>0\"),\"\")","v":""}]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A69,'Rb Guides'!AA5:AB8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B69,'Rb Guides'!AA5:AB9,2,FALSE),\"\")","v":""}]
[]
["maintenance schedule"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A74,'Rb Guides'!AC5:AD8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B74,'Rb Guides'!AC5:AD9,2,FALSE),\"\")","v":""}]
[null,null,null,"electric wirings"]
["installation condition",null,null,{"$f":"IFERROR(0.759*AVERAGEIF(A75:B75,\"<>0\")+0.241*AVERAGEIF(A80:B80,\"<>0\"),\"\")","v":""}]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A79,'Rb Guides'!AE5:AF8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B79,'Rb Guides'!AE5:AF9,2,FALSE),\"\")","v":""}]
[]
["equiptment up to standard"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A84,'Rb Guides'!AG5:AH8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B84,'Rb Guides'!AG5:AH9,2,FALSE),\"\")","v":""}]
[]
["heat dissipation condition"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A89,'Rb Guides'!AI5:AJ8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B89,'Rb Guides'!AI5:AJ9,2,FALSE),\"\")","v":""},null,"lighting equpment"]
[null,null,null,{"$f":"IFERROR(0.133*AVERAGEIF(A85:B85,\"<>0\")+0.256*AVERAGEIF(A90:B90,\"<>0\")+0.369*AVERAGEIF(A95:B95,\"<>0\")+0.242*AVERAGEIF(A100:B100,\"<>0\"),\"\")","v":""}]
["flammable materials in proximity"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A94,'Rb Guides'!AK5:AL8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B94,'Rb Guides'!AK5:AL9,2,FALSE),\"\")","v":""}]
[]
["spotlight continuous usage time"]
["entry 1","entry 2 (if needed)"]
[null,null,null,null,null,"electrical fire source"]
[{"$f":"IFERROR(VLOOKUP(A99,'Rb Guides'!AM5:AN8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B99,'Rb Guides'!AM5:AN9,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(0.411*D77+0.263*D91+0.216*D111+0.11*D130,\"\")","v":""}]
[]
["equipment up to standard"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A104,'Rb Guides'!AO5:AP8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B104,'Rb Guides'!AO5:AP9,2,FALSE),\"\")","v":""}]
[]
["heat dissipation condition"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A109,'Rb Guides'!AQ5:AR8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B109,'Rb Guides'!AQ5:AR9,2,FALSE),\"\")","v":""},null,"electric appliances"]
[null,null,null,{"$f":"IFERROR(0.128*AVERAGEIF(A105:B105,\"<>0\")+0.288*AVERAGEIF(A110:B110,\"<>0\")+0.353*AVERAGEIF(A115:B115,\"<>0\")+0.231*AVERAGEIF(A120:B120,\"<>0\"),\"\")","v":""}]
["flammable materials in proximity"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A114,'Rb Guides'!AS5:AT8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B114,'Rb Guides'!AS5:AT9,2,FALSE),\"\")","v":""}]
[]
["grounding condition"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A119,'Rb Guides'!AU5:AV8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B119,'Rb Guides'!AU5:AV9,2,FALSE),\"\")","v":""}]
[]
["equupment up to standard"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A124,'Rb Guides'!AW5:AX8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B124,'Rb Guides'!AW5:AX9,2,FALSE),\"\")","v":""}]
[]
["appearance of electric sparks"]
["entry 1","entry 2 (if needed)"]
[null,null,"power transformation equipment"]
[{"$f":"IFERROR(VLOOKUP(A129,'Rb Guides'!AY5:AZ8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B129,'Rb Guides'!AY5:AZ9,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(0.36*AVERAGEIF(A125:B125,\"<>0\")+0.354*AVERAGEIF(A130:B130,\"<>0\")+0.286*AVERAGEIF(A135:B135,\"<>0\"),\"\")","v":""}]
[]
["grounding condition"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A134,'Rb Guides'!BA5:BB8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B134,'Rb Guides'!BA5:BB9,2,FALSE),\"\")","v":""}]
[]
["presence of "]
["entry 1"]
[]
[{"$f":"IFERROR(VLOOKUP(A139,'Rb Guides'!BC5:BD6,2,FALSE),\"\")","v":""},null,null,"coal"]
[null,null,null,{"$f":"IFERROR(0.5*A140+0.5*AVERAGEIF(A145:B145,\"<>0\"),\"\")","v":""}]
["protection of "]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A144,'Rb Guides'!BE5:BF8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B144,'Rb Guides'!BE5:BF9,2,FALSE),\"\")","v":""}]
[]
["presence of",null,null,null,null,"fuel source"]
["entry 1",null,null,null,null,{"$f":"IFERROR(0.5*D141+0.5*D155,\"\")","v":""}]
[]
[{"$f":"IFERROR(VLOOKUP(A149,'Rb Guides'!BG5:BH6,2,FALSE),\"\")","v":""}]
[]
["protection of"]
["entry 1","entry 2 (if needed)"]
[null,null,"flammable and combustible fuels"]
[{"$f":"IFERROR(VLOOKUP(A154,'Rb Guides'!BI5:BJ8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B154,'Rb Guides'!BI5:BJ9,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(1/3*A150+1/3*AVERAGEIF(A155:B155,\"<>0\")+1/3*AVERAGEIF(A160:B160,\"<>0\"),\"\")","v":""}]
[]
["containment of"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A159,'Rb Guides'!BK5:BL8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B159,'Rb Guides'!BK5:BL9,2,FALSE),\"\")","v":""}]
[]
["building area factor (S)",null,null,null,null,null,null,null,"Value of S"]
["Click to reference building area factor guide",null,null,null,null,null,null,null,{"$f":"A167","v":""}]
["Note: there is only one possible entry for this factor. "]
["entry 1 (in m2)"]
[]
[{"$f":"IFERROR(VLOOKUP(A166,'Rb Guides'!BR3:BS13,2,FALSE),\"\")","v":""}]
[]
["confinement factor ( c)",null,null,null,null,null,null,null,"Value of C"]
["click to reference confinement factor guide",null,null,null,null,null,null,null,{"$f":"IFERROR(0.169*AVERAGEIF(A176:B176,\"<>0\")+0.479*AVERAGEIF(A181:B181,\"<>0\")+0.352*AVERAGEIF(A186:B186,\"<>0\"),\"\")","v":""}]
["note: choose a value for every sub category of confinement factor."]
[]
["design of ventilation system"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A175,'Rb Guides'!BY3:BZ6,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B175,'Rb Guides'!BY3:BZ7,2,FALSE),\"\")","v":""}]
[]
["usability of ventilation system"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A180,'Rb Guides'!CA3:CB6,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B180, 'Rb Guides'!CA3:CB7,2,FALSE),\"\")","v":""}]
[]
["usability of ventilation system"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A185,'Rb Guides'!CC3:CD6,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B185,'Rb Guides'!CC3:CD7,2,FALSE),\"\")","v":""}]
[]
["building fireproof rating factor (W)",null,null,null,null,null,null,null,"Value of W"]
["click to reference the building fireproof rating factor guide",null,null,null,null,null,null,null,{"$f":"A195","v":""}]
["note: click on reference link above to understand which level to assign to the establishment. "]
[]
["fireproof rating of the building"]
["entry 1"]
[]
[{"$f":"IFERROR(VLOOKUP(A194,'Rb Guides'!CL3:CM6,2,FALSE),\"\")","v":""}]
[]
["factor on reduction of fire spreading (Ri)",null,null,null,null,null,null,null,"Value of Ri"]
["click to reference the factor on reduction of fire spreading guide",null,null,null,null,null,null,null,{"$f":"A204","v":""}]
["note: there is only one possible answer for this factor."]
[]
["scenario"]
["entry 1"]
[]
[{"$f":"IFERROR(VLOOKUP(A203,'Rb Guides'!CX3:CY6,2,FALSE),\"\")","v":""}]
[]
["factor on fire fighting capacity of the fire department (Lo)",null,null,null,null,null,null,null,"Value of Lo"]
["Click to reference the factor on fire fighting capacity of the fire department guide",null,null,null,null,null,null,null,{"$f":"IFERROR(0.276*AVERAGEIF(A212:B212,\"<>0\")+0.176*AVERAGEIF(A217:B217,\"<>0\")+0.144*AVERAGEIF(A222:B222,\"<>0\")+0.255*AVERAGEIF(A227:B227,\"<>0\")+0.151*AVERAGEIF(A232,\"<>0\"),\"\")","v":""}]
["note: there may be more than one answer per variable. "]
["fire department equipment"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A211,'Rb Guides'!DJ4:DK7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B211,'Rb Guides'!DJ4:DK8,2,FALSE),\"\")","v":""}]
[]
["firefighting experience of the fire department"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A216,'Rb Guides'!DL4:DM7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B216,'Rb Guides'!DL4:DM8,2,FALSE),\"\")","v":""}]
[]
["fire lane availability"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A221,'Rb Guides'!DN4:DO7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B221,'Rb Guides'!DN4:DO8,2,FALSE),\"\")","v":""}]
[]
["outdoor fire hydrant"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A226,'Rb Guides'!DP4:DQ7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B226,'Rb Guides'!DP4:DQ8,2,FALSE),\"\")","v":""}]
[]
["nearest fire station response time"]
["entry 1"]
[]
[{"$f":"IFERROR(VLOOKUP(A231,'Rb Guides'!DR4:DS7,2,FALSE),\"\")","v":""}]
[]
["factor on firefighting equipment in the building (Li)",null,null,null,null,null,null,null,"Value of Li"]
["Click here to reference factor on firefighting equiptment in the building guide",null,null,null,null,null,null,null,{"$f":"IFERROR(0.429*AVERAGEIF(A240:B240,\"<>0\")+0.226*AVERAGEIF(A245:B245,\"<>0\")+0.194*AVERAGEIF(A250:B250,\"<>0\")+0.151*AVERAGEIF(A255:B255,\"<>0\"),\"\")","v":""}]
["note: there may be more than one answer per variable. "]
["fire detection system"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A239,'Rb Guides'!DT4:DU7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B239,'Rb Guides'!DT4:DU8,2,FALSE),\"\")","v":""}]
[]
["sprinkler system"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A244,'Rb Guides'!DV4:DW7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B244,'Rb Guides'!DV4:DW8,2,FALSE),\"\")","v":""}]
[]
["indoor fire hydrant"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A249,'Rb Guides'!DX4:DY7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B249,'Rb Guides'!DX4:DY8,2,FALSE),\"\")","v":""}]
[]
["fire extinguisher"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A254,'Rb Guides'!DZ4:EA7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B254,'Rb Guides'!DZ4:EA8,2,FALSE),\"\")","v":""}]

{"sheet":"Rp Calculations (3)","index":8,"n_rows":112,"n_cols":9,"rows_kept":112,"cut":false,"hidden":false,"merged":[[98,0,98,1],[103,0,103,1],[108,0,108,1],[90,0,90,1],[95,0,95,3],[95,8,95,9],[96,0,96,4],[96,8,97,9],[97,0,97,2],[68,8,68,9],[69,0,69,1],[74,0,74,3],[75,0,75,1],[80,0,80,1],[85,0,85,1],[67,8,67,9],[56,0,56,2],[56,8,56,9],[57,0,57,2],[57,8,58,9],[58,0,58,4],[59,0,59,1],[60,8,60,9],[61,8,61,9],[64,0,64,1],[64,8,64,9],[66,8,66,9],[51,0,51,1],[31,8,31,9],[32,0,32,3],[32,8,33,9],[33,0,33,2],[38,0,38,3],[38,8,38,9],[39,0,39,3],[39,8,40,9],[40,0,40,4],[41,0,41,1],[46,0,46,1],[25,0,25,3],[25,8,26,9],[26,0,26,4],[12,0,12,1],[19,2,19,4],[21,2,21,3],[24,0,24,3],[24,8,24,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(E22 = \"\", \"ALL VALUES ARE NOT SUBMITTED!\",\"\")","v":"ALL VALUES ARE NOT SUBMITTED!"}]
[]
[null,null,"value of Rp is ",null,{"$f":"IFERROR((I26*I33)/(I40*I58*I97),\"\")","v":""}]
[]
[]
["Smoke Toxicity Factor (T)",null,null,null,null,null,null,null,"value of T"]
["Click to Reference Smoke Toxicity Factor Guide",null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGEIF(A30:D30,\"<>0\"),\"\")","v":""}]
["Note: Do not enter repeat entries in this section. If there are less than 4 entires, choose \"non applicable.\""]
["entry 1","entry 2","entry 3","entry 4"]
[]
[{"$f":"IFERROR(VLOOKUP(A29,'Rp Guides'!A3:B7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B29,'Rp Guides'!A3:B7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C29,'Rp Guides'!A3:B7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D29,'Rp Guides'!A3:B7,2,FALSE),\"\")","v":""}]
[]
["User characteristic factor (F)",null,null,null,null,null,null,null,"value of F"]
["Click to Reference User Characteristic Factor Guide",null,null,null,null,null,null,null,{"$f":"A37","v":""}]
["Note: you can only enter one value in this section."]
["entry 1"]
[]
[{"$f":"IFERROR(VLOOKUP(A36,'Rp Guides'!E3:F8,2,FALSE),\"\")","v":""}]
[]
["Automatic fire alarm factor (K)",null,null,null,null,null,null,null,"value of k"]
["Click to Reference the Automatic Fire Alarm Factor Guide",null,null,null,null,null,null,null,{"$f":"IFERROR(1/3*AVERAGEIF(A45:B45,\"<>0\")+1/3*AVERAGEIF(A50:B50,\"<>0\")+1/3*A55,\"\")","v":""}]
["Note: This is a multivariate factor. Fill out the design of fire detection system section and the usability of fire detection system section. "]
["design of fire detection system(s)"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A44,'Rp Guides'!BL3:BM7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B44,'Rp Guides'!BL3:BM7,2,FALSE),\"\")","v":""}]
[]
["usability of fire detection system(s)"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(DesignofFireDetectionSystem,'Rp Guides'!BN3:BO7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B49,'Rp Guides'!BN3:BO7,2,FALSE),\"\")","v":""}]
[]
["system approval "]
["entry 1"]
[]
[{"$f":"IFERROR(VLOOKUP(A54,'Rp Guides'!P2:Q4,2,FALSE),\"\")","v":""}]
[]
["evacuation capacity factor ( E)",null,null,null,null,null,null,null,"Value of E"]
["Click to reference the evacuation capacity factor guide",null,null,null,null,null,null,null,{"$f":"IFERROR(0.381*D68+0.619*D87,\"\")","v":""}]
["Note: This is the evacuation route section. Make sure to fill out all of the subsections. "]
["distance to exits"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A62,'Rp Guides'!AE5:AF8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B62,'Rp Guides'!AE5:AF8,2,FALSE),\"\")","v":""}]
[]
["clearance of the route"]
["entry 1","entry 2 (if needed)"]
[null,null,null,"evacuation route "]
[{"$f":"IFERROR(VLOOKUP(A67,'Rp Guides'!AG5:AH8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B67,'Rp Guides'!AG5:AH8,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(0.052*AVERAGEIF(A63:B63,\"<>0\")+0.336*AVERAGEIF(A68:B68,\"<>0\")+0.612*AVERAGEIF(A73:B73,\"<>0\"),\"\")","v":""}]
[]
["design of the exits"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A72,'Rp Guides'!AI5:AJ8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B72,'Rp Guides'!AI5:AJ8,2,FALSE),\"\")","v":""}]
[]
["Note: This is the evacuation equiptment section. Make sure to fill out all of the subsections. "]
["signs to exits"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A78,'Rp Guides'!AK5:AL8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B78,'Rp Guides'!AK5:AL8,2,FALSE),\"\")","v":""}]
[]
["design of evacuation stairs"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A83,'Rp Guides'!AM5:AN8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B83,'Rp Guides'!AM5:AN8,2,FALSE),\"\")","v":""}]
[]
["emergency lighting system",null,null,"evacuation equiptment"]
["entry 1","entry 2 (if needed)",null,{"$f":"IFERROR(0.203*AVERAGEIF(A79:B79,\"<>0\")+0.506*AVERAGEIF(A84:B84,\"<>0\")+0.203*AVERAGEIF(A89:B89,\"<>0\")+0.098*AVERAGEIF(A94:B94,\"<>0\"),\"\")","v":""}]
[]
[{"$f":"IFERROR(VLOOKUP(A88,'Rp Guides'!AO4:AP8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B88,'Rp Guides'!AO4:AP8,2,FALSE),\"\")","v":""}]
[]
["emergency announcement system"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A93,'Rp Guides'!AQ4:AR7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B93,'Rp Guides'!AQ4:AR7,2,FALSE),\"\")","v":""}]
[]
["ventilation and smoke extraction factor (H)",null,null,null,null,null,null,null,"value of H"]
["Click to reference the ventilation and smoke extraction factor guide",null,null,null,null,null,null,null,{"$f":"IFERROR(1/3*AVERAGEIF(A102:B102,\"<>0\")+1/3*AVERAGEIF(A107:B107,\"<>0\")+1/3*A112,\"\")","v":""}]
["Note: You must fill out every subsection for this factor. "]
["design of smoke extraction system"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A101,'Rp Guides'!BL4:BM7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B101,'Rp Guides'!BL4:BM7,2,FALSE),\"\")","v":""}]
[]
["USABILITY OF SMOKE EXTRACTION SYSTEM"]
["entry 1","entry 2 (if needed)"]
[]
[{"$f":"IFERROR(VLOOKUP(A106,'Rp Guides'!BN4:BO7,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B106,'Rp Guides'!BN4:BO7,2,FALSE),\"\")","v":""}]
[]
["type of smoke extraction/ventilation"]
["Entry 1"]
[]
[{"$f":"IFERROR(VLOOKUP(A111,'Rp Guides'!BP4:BQ6,2,FALSE),\"\")","v":""}]

{"sheet":"Rb Guides","index":9,"n_rows":21,"n_cols":131,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,113,1,122],[1,123,1,130],[0,113,0,130],[9,89,14,89],[15,89,15,90],[0,89,0,90],[7,91,7,94],[0,101,0,102],[7,89,8,90],[20,89,20,90],[16,89,16,90],[17,89,17,90],[18,89,18,90],[19,89,19,90],[3,58,3,59],[3,60,3,61],[3,62,3,63],[1,76,1,77],[3,50,3,51],[3,54,3,55],[3,56,3,57],[3,52,3,53],[1,78,1,79],[1,80,1,81],[0,76,0,81],[2,40,2,47],[2,48,2,53],[1,28,1,48],[2,54,2,57],[2,58,2,63],[3,28,3,29],[2,24,3,25],[2,26,3,27],[2,28,2,31],[3,30,3,31],[3,40,3,41],[3,42,3,43],[3,44,3,45],[3,46,3,47],[3,48,3,49],[3,32,3,33],[3,34,3,35],[3,36,3,37],[2,32,2,39],[3,38,3,39],[1,24,1,27],[1,54,1,63],[0,0,0,1],[0,7,0,8],[0,69,0,70],[0,14,0,18],[0,24,0,63]]}
["Mobile Fire Load factor (Qm)",null,null,null,null,null,null,"Flammability factor of the mobile fire load (μ)",null,null,null,null,null,null,"immobile fire load factor (Qi)",null,null,null,null,null,null,null,null,null,"Fire Source Factor",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,"building area factor",null,null,null,null,null,null,"Confinement Factor (C )",null,null,null,null,null,null,null,null,null,null,null,null,"Building fireproof rating factor (W)",null,null,null,null,null,null,null,null,null,null,null,"factor on reduction of fire spreading (Ri)",null,null,null,null,null,null,null,null,null,null,null,"Factor on firefighting capability of the fire department & firefighting equiptment in the building"]
["Mobile fire load (kg/m2)","Qm",null,null,null,null,null,"Major flammable material type","μ",null,null,null,null,null,"Scenario","support material","ceiling material","wall material","Qi",null,null,null,null,null,"Human Source Fire",null,null,null,"Electrical Fire Source",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,"Fuel Source",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"building area (m2)","S",null,null,null,null,null,"Design of ventilation system",null,"usability of ventilation system",null,"choice of fireproof material",null,null,null,null,null,null,null,null,"fireproof rating of the building","W",null,null,null,null,null,null,null,null,null,null,"Scenario","Ri",null,null,null,null,null,null,null,null,null,null,"Lo",null,null,null,null,null,null,null,null,null,"Li"]
["0-15 kg/m2",1,null,null,null,null,null,"wood furniture, flooring, etc.",1,null,null,null,null,null,1,"Concrete, bricks, steel","concrete, steel","concrete, bricks, steel",0,null,null,null,null,null,"People Smoking",null,"Prohibited Behavior Related to Fire",null,"Electric Wirings",null,null,null,"Lighting Equipment",null,null,null,null,null,null,null,"Electric Applicances",null,null,null,null,null,null,null,"Power Transformation Equipment",null,null,null,null,null,"Coal",null,null,null,"Flammable and combustible fuels",null,null,null,null,null,null,null,null,null,null,"5,000-8,000",1,null,null,null,null,null,"reasonable",1,"complete and usable",1,"up to standard",1,null,null,null,null,null,null,null,"level 1",2,null,null,null,null,null,null,null,null,null,null,"Much flammable goods piled loosely across the room, help spread the fire",1,null,null,null,null,null,null,null,null,null,null,"Fire department equipment (0.276)","numerical conversion","Firefighting experience of the fire department (0.176)","numerical conversion","Fire lane availability (0.144)","numerical conversion","Outdoor fire hydrant (0.255)","numerical conversion","Nearest fire station response time (0.151)","numerical conversion","Fire detection system (0.429)","numerical conversion","Sprinkler system (0.226)","numerical conversion","Indoor fire hydrant (0.194)","numerical conversion","Fire Extinguisher (0.151)","numerical conversion"]
["16-30 kg/m2",1.2,null,null,null,null,null,"fiber panel, polyester mattress",1.2,null,null,null,null,null,2,"steel","wood","concrete, steel ",0.2,null,null,null,null,null,null,null,null,null,"maintenance schedule",null,"installation condition",null,"equipment up to standard",null,"heat dissipation condition",null,"flammable materials in proximity",null,"spotlight continous usage time",null,"equiptment up to standard",null,"heat dissipation condition",null,"flammable materials in proximity",null,"grounding condition",null,"equipment up to standard",null,"appearance of electric sparks",null,"grounding conditions",null,"presence",null,"protection of conveyor belt",null,"presence",null,"protection",null,"containment",null,null,null,null,null,null,"8,001-12,000",1.2,null,null,null,null,null,"relatively lreasonable",1.5,"relatively complete and usable",1.5,"relatively up to standard",1.5,null,null,null,null,null,null,null,"level 2",1.8,null,null,null,null,null,null,null,null,null,null,"Moderately flammable goods piled loosely",1.3,null,null,null,null,null,null,null,null,null,null,"advanced",3,"good",3,"clear",3,"completely usable",3,"0-30 minutes",3,"completely usable",3,"completely usable",3,"completely usable",3,"completely usable",3]
["31-60 kg/m2",1.4,null,null,null,null,null,"cotton, linen, rubber, polyethylene",1.5,null,null,null,null,null,3,"wood, steel","wood","concrete, bricks ",0.4,null,null,null,null,null,"Very Rarely ",1,"very rarely ",1,"very often",1,"very good ",1,"all up to standard",1,"very good",1,"none",1,"Less than 6 hours",1,"all up to standard",1,"very good",1,"none",1,"very good",1,"all up to standard",1,"none",1,"all up to standard",1,"no",1,"very good",1,"no ",1,"very good",1,"very good",1,null,null,null,null,null,"12001-17000",1.5,null,null,null,null,null,"partially reasonable",2.5,"partially usable",2.5,"partially up to standard",2.5,null,null,null,null,null,null,null,"level 3",1.2,null,null,null,null,null,null,null,null,null,null,"25%-50% of the goods not easily flammable, good heat dissipation condition, area smaller than 3000 m2",1.6,null,null,null,null,null,null,null,null,null,null,"relatively advanced",2.5,"relatively good",2.5,"relatively clear",2.5,"relatively usable",2.5,"31-45 minutes",2.5,"relatively usable",2.5,"relatively usable",2.5,"relatively usable",2.5,"relatively usable",2.5]
["61-120 kg/m2",1.6,null,null,null,null,null,"polystyrene, floor wax, curtain, sofa, butanol, diesel",2,null,null,null,null,null,4,"wood ","wood","wood, tiles, sheet metals",0.6,null,null,null,null,null,"Not often",1.5,"not often",1.5,"on schedule",1.5,"good",1.5,"most up to standard",1.5,"relatively good",1.5,"few",1.5,"7 to 8 hours",1.5,"most up to standard",1.5,"relatively good",1.5,"few",1.5,"relatively good",1.5,"most up to standard",1.5,"few",1.5,"most up to standard",1.5,"yes",3,"relatively good",1.5,"yes",3,"relatively good",1.5,"relatively good",1.5,null,null,null,null,null,"17001-23000",1.8,null,null,null,null,null,"not reasonable",3,"not usable",3,"not up to standard",3,null,null,null,null,null,null,null,"level 4",1,null,null,null,null,null,null,null,null,null,null,"Goods packed in containers, hard to ignite",2,null,null,null,null,null,null,null,null,null,null,"normal",1.5,"normal",1.5,"partially clear",1.5,"partially usable",1.5,"46-55 minutes",1.5,"partially usable",1.5,"partially usable",1.5,"partially usable",1.5,"partially usable",1.5]
["121-240 kg/m2",2,null,null,null,null,null,"gasoline, alkyl, varnish, pure ethanol, alkali metal",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Normal",2.5,"normal",2.5,"normal ",2.5,"normal",2.5,"some up to standard",2.5,"normal",2.5,"normal",2.5,"9 to 10 hours",2.5,"some up to standard",2.5,"normal",2.5,"normal",2.5,"normal",2.5,"some up to standard",2.5,"normal",2.5,"some up to standard",2.5,null,null,"normal",2.5,null,null,"normal",2.5,"normal",2.5,null,null,null,null,null,"23001-30000",2.1,null,null,null,null,null,"Empty/Non-Applicable",0,"Empty/Non-Applicable",0,"Empty/Non-Applicable",0,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,"not advanced",1,"lack experience",1,"blocked",1,"not usable",1,"more than 55 minutes",1,"not usable",1,"not usable",1,"not usable",1,"not usable",1]
["241-480 kg/m2",2.4,null,null,null,null,null,"empty/non-applicable",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"More than usual ",3,"often",3,"rarely ",3,"messy",3,"not up to standard",3,"bad",3,"a lot",3,"Over 10 hours",3,"not up to standard",3,"bad",3,"a lot",3,"bad",3,"not up to standard",3,"often",3,"not up to standard",3,null,null,"bad",3,null,null,"bad",3,"bad",3,null,null,null,null,null,"30001-38000",2.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name of the structure",null,"Fireproof rating and their requirement, numbers indicate time it takes for material failure, in hours.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Empty/Non-Applicable",0,"Empty/Non-Applicable",0,"Empty/Non-Applicable",0,"Empty/Non-Applicable",0,"Empty/Non-Applicable",0,"Empty/Non-Applicable",0,"Empty/Non-Applicable",0,"Empty/Non-Applicable",0,"Empty/Non-Applicable",0]
["481-960 kg/m2",2.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Empty/Non-Applicable",0,"Empty/Non-Applicable",0,"Empty/Non-Applicable",0,"Empty/Non-Applicable",0,"Empty/Non-Applicable",0,"Empty/Non-Applicable",0,"Empty/Non-Applicable",0,"Empty/Non-Applicable",0,"Empty/Non-Applicable",0,"Empty/Non-Applicable",0,"Empty/Non-Applicable",0,"Empty/Non-Applicable",0,"Empty/Non-Applicable",0,"Empty/Non-Applicable",0,"Empty/Non-Applicable",0,null,null,"Empty/Non-Applicable",0,null,null,"Empty/Non-Applicable",0,"Empty/Non-Applicable",0,null,null,null,null,null,"38001-47000",2.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"level 1","level 2","level 3","level 4"]
["961-1920 kg/m2",3.4,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,null,null,null,null,null,null,null,null,null,null,null,null,null,"47000-57000",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Walls","Firewall","Non-flammable, 3.00","Non-flammable, 3.00","Non-flammable, 3.00","Non-flammable, 3.00"]
["1921-2340 kg/m2",3.9,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,null,null,null,null,null,null,null,null,null,null,null,null,null,"57001-68000",3.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Load-bearing wall","Non-flammable, 3.00","Non-flammable, 2.50","Non-flammable, 2.00","Not-easily-flammable, 0.50"]
[">2340 kg/m2",4,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,null,null,null,null,null,null,null,null,null,null,null,null,null,"68001-80000",3.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-load-bearing exterior wall","Non-flammable, 1.00","Non-flammable, 1.00","Non-flammable, 0.50","Flammable"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">80000",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Walls around staircases, elevators ","Non-flammable, 2.00","Non-flammable, 2.00","Non-flammable, 1.50","Not-easily-flammable, 0.50"]
[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,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,"Walls along escape route","Non-flammable, 1.00","Non-flammable, 1.00","Non-flammable, 0.50","Not-easily-flammable, 0.25"]
[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,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,"Room-dividing walls","Non-flammable, 0.75","Non-flammable, 0.50","Not-easily-flammable, 0.50","Not-easily-flammable, 0.25"]
[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,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,"Columns",null,"Non-flammable, 3.00","Non-flammable, 2.50","Non-flammable, 2.00","Not-easily-flammable, 0.50"]
[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,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,"Beams of roof",null,"Non-flammable, 2.00","Non-flammable, 1.50","Non-flammable, 1.00","Not-easily-flammable, 0.50"]
[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,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,"Flooring",null,"Non-flammable, 1.50","Non-flammable, 1.00","Non-flammable, 0.50","Flammable"]
[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,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,"Roof",null,"Non-flammable, 1.50","Non-flammable, 1.00","Flammable","Flammable"]
[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,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,"Escape stairs",null,"Non-flammable, 1.50","Non-flammable, 1.00","Non-flammable, 1.00","Flammable"]
[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,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,"Drop-down ceiling",null,"Non-flammable, 0.25","Not-easily-flammable, 0.25","Not-easily-flammable, 0.15","Flammable"]

{"sheet":"Rp Guides","index":10,"n_rows":8,"n_cols":69,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,4,0,5],[1,13,1,14],[1,11,1,12],[1,65,1,66],[1,63,1,64],[1,36,1,43],[1,30,1,35],[1,15,1,16],[0,11,0,16],[1,67,1,68],[0,63,0,68],[0,30,0,43],[2,42,2,43],[2,40,2,41],[2,38,2,39],[2,36,2,37],[2,34,2,35],[2,32,2,33],[2,30,2,31]]}
["guide for smoke toxicity factor (T)",null,null,null,"User characteristic factor (f)",null,null,null,null,null,null,"Automatic fire alarm factor (K)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"evacuation capacity factor ( E )",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,"ventilation and smoke extraction factor (H)"]
["Flammable Materials","T",null,null,"Building types","f",null,null,null,null,null,"Design of fire detection system",null,"Usability of the fire detection system",null,"system approval ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"evacuation route (the means of egress)",null,null,null,null,null,"evacuation equiptment",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,"design of smoke extraction system",null,"usability of the smoke extraction system",null,"type of smoke extraction and ventilation"]
["Non applicable/empty",0,null,null,"Office building, station, airport, stadium",1,null,null,null,null,null,"Non applicable/empty",null,"non applicable/empty",null,"yes",1.7,null,null,null,null,null,null,null,null,null,null,null,null,null,"Distance to exits",null,"clearance of the route",null,"Design of the exits",null,"Signs to exits",null,"design of the evacuation stairs",null,"emergency lighting system",null,"emergency announcement system",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"non applicable/empty",0,"non applicable/empty",0,null,0]
["Ethanol, natural gas",1,null,null,"shopping mall, library, theater, museum, restaurant",1.5,null,null,null,null,null,"Reasonable",1.7,"complete and usable",1.7,"no",1,null,null,null,null,null,null,null,null,null,null,null,null,null,"non applicable/empty",null,"non applicable/empty",null,"non applicable/empty",null,"non applicable/empty",null,"non applicable/empty",null,"non applicable/empty",null,"non applicable/empty",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"reasonable",1.7,"complete and usable ",1.7,"forced",1.7]
["Wood, cotton, paper",1.2,null,null,"apartment, house",2,null,null,null,null,null,"Relatively reasonable",1.5,"relatively complete and usable",1.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"up to standard",1.7,"clear ",1.7,"reasonable",1.7,"effective",1.7,"reasonable ",1.7,"complete and usable",1.7,"effective",1.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"relatively reasonable",1.5,"relatively complete and usable ",1.5,"natural",1.5]
["Gasoline, kerosene, diesel, cloths, melamine chipboard",1.5,null,null,"industrial setting",1.75,null,null,null,null,null,"Partially reasonable",1.3,"partially usable",1.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"relatively up to standard",1.5,"relatively clear ",1.5,"relatively reasonable",1.5,"relatively effective",1.5,"relatively reasonable ",1.5,"relatively complete and usable",1.5,"relatively effective",1.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"partially reasonable",1.3,"partially usable",1.3,"none",1]
["Polystyrene, polyurethane, PVC, rubber, neoprene",2,null,null,"hotel, bars, clubs",2.5,null,null,null,null,null,"Not reasonable",1,"not usable",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"not up to standard",1.3,"partially clear ",1.3,"partially reasonable",1.3,"partially effective",1.3,"partially reasonable",1.3,"partially usable",1.3,"partially effective",1.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"not reasonable",1,"not usable",1]
[null,null,null,null,"hospital, kindergarten, and similar environments",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"very not up to standard",1,"blocked",1,"not reasonable",1,"ineffective",1,"not reasonable",1,"not usable",1,"ineffective",1]