{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Column No1","from author"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"Column No1","index":0,"n_rows":52,"n_cols":22,"rows_kept":52,"cut":false,"hidden":false,"merged":[[6,2,6,9],[6,11,6,17],[7,2,7,8],[8,2,8,8],[9,2,9,8],[3,11,3,12],[4,11,4,12],[4,3,4,10],[1,3,3,10],[1,11,2,14],[4,13,4,14],[3,13,3,14],[2,16,2,18],[3,16,3,18],[4,16,4,18],[42,10,42,11],[43,10,43,11],[27,10,27,11],[28,10,28,11],[29,10,29,11],[30,10,30,11],[31,10,31,11],[32,10,32,11],[15,10,15,11],[16,10,16,11],[17,10,17,11],[18,10,18,11],[19,10,19,11],[44,10,44,11],[45,10,45,11],[46,10,46,11],[47,10,47,11],[48,10,48,11],[40,10,40,11],[41,10,41,11],[24,10,24,11],[25,10,25,11],[26,10,26,11],[51,2,51,7],[12,16,13,17],[12,13,13,14],[12,15,14,15],[12,2,14,2],[12,3,13,4],[12,5,13,7],[50,16,50,17],[20,10,20,11],[21,10,21,11],[22,10,22,11],[23,10,23,11],[49,10,49,11],[33,10,33,11],[34,10,34,11],[35,10,35,11],[0,1,0,11],[12,8,12,9],[0,12,0,18],[10,2,10,17],[50,9,50,15],[14,10,14,11],[12,10,13,12],[11,2,11,9],[11,10,11,17],[7,11,7,16],[8,11,8,16],[9,11,9,16],[36,10,36,11],[37,10,37,11],[38,10,38,11],[39,10,39,11]]}
[null,"version: 1.0.",null,null,null,null,null,null,null,null,null,null,"© 2014 Damian Janicki"]
[null,null,null,"  YourSpreadsheets™\n   2nd Floor, 52 Marcus Hill, London\n   www.YourSpreadsheets.co.uk\n   Tel: 020 7542 8734",null,null,null,null,null,null,null,"TEST PROJECT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revision:","B"]
[null,null,null,null,null,null,null,null,null,null,null,"Job No:",null,22668,null,"Page:","C/01"]
[null,null,"Column:","AT GRIDLINE A-5",null,null,null,null,null,null,null,"Calcs By:",null,"DJ",null,"Date:",{"$f":"TODAY()","v":"2014-12-30"}]
[]
[null,null,"BUILDING DATA",null,null,null,null,null,null,null,null,"LOADING DATA"]
[null,null,"Number of storeys above ground:",null,null,null,null,null,null,24,null,"Permanent and S.Permanent load safety factor:",null,null,null,null,null,1.35,null,null,"Imposed load reduction:"]
[null,null,"Number of storeys below ground:",null,null,null,null,null,null,10,null,"Variable load safety factor:",null,null,null,null,null,1.5,null,null,"include"]
[null,null,{"$f":"\"Unfactored \"&IF($C$5=$U$13,\"column\",\"wall\")&\" self weight [kN per storey]:\"","v":"Unfactored column self weight [kN per storey]:"},null,null,null,null,null,null,12.5,null,"Variable load reduction:",null,null,null,null,null,"include",null,null,"ignore"]
[null,null,{"$f":"IF($J$8+$J$9>34,\"Maximum number of storeys (above and below ground) is 34. Revise your input.\",\"\")","v":""}]
[null,null,"LOAD TAKE DOWN: ",null,null,null,null,null,null,null,{"$f":"INDEX($V$13:$V$14,MATCH($C$5,$U$13:$U$14,0))&\" \"&$D$5","v":"COLUMN AT GRIDLINE A-5"},null,null,null,null,null,null,null,null,null,"Element:"]
[null,null,"LEVEL","LOADED AREA\n[m]",null,"UNFACTORED FLOOR \nLOADS [kN/m2]",null,null,"UNF. WALL LOAD",null,"UNF. LOADS \nPER LEVEL [kN]",null,null,"TOTAL UNF. \nLOADS [kN]",null,"VARIABLE LOAD RED. [%]","TOTAL FACTORED LOADS [kN]",null,null,null,"Column:","COLUMN"]
[null,null,null,null,null,null,null,null,"[m]","[kN/m]",null,null,null,null,null,null,null,null,null,null,"Wall:","WALL"]
[null,null,null,"X dir.","Y dir.","PERM.","S.PERM.","VARIABLE","LENGTH","LOAD","PERM.",null,"VARIABLE","PERM.","VARIABLE",null,"PERM.","VARIABLE"]
[null,null,{"$f":"J8","v":24},6,6,6,6,6,{"$f":"D16","v":6},0,{"$f":"D16*E16*(F16+G16)+I16*J16","v":432},null,{"$f":"D16*E16*H16","v":216},{"$f":"K16","v":432},{"$f":"M16","v":216},0,{"$f":"$R$8*N16","v":583.20000000000005},{"$f":"$R$9*O16*(1-P16/100)","v":324},null,1]
[null,null,{"$f":"IF($J$8=T16,\"Gr. floor\",IF(AND($J$8<T16,T16<$J$8+$J$9+1),\"B-\"&T16-$J$8,IF($C$16-T16<1,\"\",$C$16-T16)))","v":23},6,6,6,6,6,{"$f":"D17","v":6},12,{"$f":"IF(C17=\"\",\"\",$J$10+D17*E17*(F17+G17)+I17*J17)","v":516.5},null,{"$f":"IF(C17=\"\",\"\",D17*E17*H17)","v":216},{"$f":"IF(C17=\"\",\"\",K17+N16)","v":948.5},{"$f":"IF(C17=\"\",\"\",M17+O16)","v":432},{"$f":"IF($R$10=$U$9,IF(T17<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T17-1,'from author'!$W$3:$W$8,1),2),0),0)","v":0},{"$f":"IF(C17=\"\",\"\",$R$8*N17)","v":1280.4750000000001},{"$f":"IF(C17=\"\",\"\",$R$9*O17*(1-P17/100))","v":648},null,2]
[null,null,22,6,6,6,6,6,6,12,{"$f":"IF(C18=\"\",\"\",$J$10+D18*E18*(F18+G18)+I18*J18)","v":516.5},null,216,{"$f":"IF(C18=\"\",\"\",K18+N17)","v":1465},648,{"$f":"IF($R$10=$U$9,IF(T18<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T18-1,'from author'!$W$3:$W$8,1),2),0),0)","v":10},1977.7500000000002,874.80000000000007,null,3]
[null,null,21,6,6,6,6,6,6,12,516.5,null,216,{"$f":"IF(C19=\"\",\"\",K19+N18)","v":1981.5},864,{"$f":"IF($R$10=$U$9,IF(T19<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T19-1,'from author'!$W$3:$W$8,1),2),0),0)","v":20},2675.0250000000001,1036.8,null,4]
[null,null,20,6,6,6,6,6,6,12,516.5,null,216,2498,1080,{"$f":"IF($R$10=$U$9,IF(T20<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T20-1,'from author'!$W$3:$W$8,1),2),0),0)","v":30},3372.3,1134,null,5]
[null,null,19,6,6,6,6,6,6,12,516.5,null,216,3014.5,1296,{"$f":"IF($R$10=$U$9,IF(T21<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T21-1,'from author'!$W$3:$W$8,1),2),0),0)","v":40},4069.5750000000003,1166.3999999999999,null,6]
[null,null,18,6,6,6,6,6,6,12,516.5,null,216,3531,1512,{"$f":"IF($R$10=$U$9,IF(T22<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T22-1,'from author'!$W$3:$W$8,1),2),0),0)","v":40},4766.8500000000004,1360.8,null,7]
[null,null,17,6,6,6,6,6,6,12,516.5,null,216,4047.5,1728,{"$f":"IF($R$10=$U$9,IF(T23<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T23-1,'from author'!$W$3:$W$8,1),2),0),0)","v":40},5464.125,1555.2,null,8]
[null,null,16,6,6,6,6,6,6,12,516.5,null,216,4564,1944,{"$f":"IF($R$10=$U$9,IF(T24<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T24-1,'from author'!$W$3:$W$8,1),2),0),0)","v":40},6161.4000000000005,1749.6,null,9]
[null,null,15,6,6,6,6,6,6,12,516.5,null,216,5080.5,2160,{"$f":"IF($R$10=$U$9,IF(T25<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T25-1,'from author'!$W$3:$W$8,1),2),0),0)","v":40},6858.6750000000002,1944,null,10]
[null,null,14,6,6,6,6,6,6,12,516.5,null,216,5597,2376,{"$f":"IF($R$10=$U$9,IF(T26<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T26-1,'from author'!$W$3:$W$8,1),2),0),0)","v":40},7555.9500000000007,2138.4,null,11]
[null,null,13,6,6,6,6,6,6,12,516.5,null,216,6113.5,2592,{"$f":"IF($R$10=$U$9,IF(T27<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T27-1,'from author'!$W$3:$W$8,1),2),0),0)","v":50},8253.2250000000004,1944,null,12]
[null,null,12,6,6,6,6,6,6,12,516.5,null,216,6630,2808,{"$f":"IF($R$10=$U$9,IF(T28<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T28-1,'from author'!$W$3:$W$8,1),2),0),0)","v":50},8950.5,2106,null,13]
[null,null,11,6,6,6,6,6,6,12,516.5,null,216,7146.5,3024,{"$f":"IF($R$10=$U$9,IF(T29<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T29-1,'from author'!$W$3:$W$8,1),2),0),0)","v":50},9647.7750000000015,2268,null,14]
[null,null,10,6,6,6,6,6,6,12,516.5,null,216,7663,3240,{"$f":"IF($R$10=$U$9,IF(T30<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T30-1,'from author'!$W$3:$W$8,1),2),0),0)","v":50},10345.050000000001,2430,null,15]
[null,null,9,6,6,6,6,6,6,12,516.5,null,216,8179.5,3456,{"$f":"IF($R$10=$U$9,IF(T31<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T31-1,'from author'!$W$3:$W$8,1),2),0),0)","v":50},11042.325000000001,2592,null,16]
[null,null,8,6,6,6,6,6,6,12,516.5,null,216,8696,3672,{"$f":"IF($R$10=$U$9,IF(T32<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T32-1,'from author'!$W$3:$W$8,1),2),0),0)","v":50},11739.6,2754,null,17]
[null,null,7,6,6,6,6,6,6,12,516.5,null,216,9212.5,3888,{"$f":"IF($R$10=$U$9,IF(T33<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T33-1,'from author'!$W$3:$W$8,1),2),0),0)","v":50},12436.875,2916,null,18]
[null,null,6,6,6,6,6,6,6,12,516.5,null,216,9729,4104,{"$f":"IF($R$10=$U$9,IF(T34<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T34-1,'from author'!$W$3:$W$8,1),2),0),0)","v":50},13134.150000000001,3078,null,19]
[null,null,5,6,6,6,6,6,6,12,516.5,null,216,10245.5,4320,{"$f":"IF($R$10=$U$9,IF(T35<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T35-1,'from author'!$W$3:$W$8,1),2),0),0)","v":50},13831.425000000001,3240,null,20]
[null,null,4,6,6,6,6,6,6,12,516.5,null,216,10762,4536,{"$f":"IF($R$10=$U$9,IF(T36<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T36-1,'from author'!$W$3:$W$8,1),2),0),0)","v":50},14528.7,3402,null,21]
[null,null,3,6,6,6,6,6,6,12,516.5,null,216,11278.5,4752,{"$f":"IF($R$10=$U$9,IF(T37<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T37-1,'from author'!$W$3:$W$8,1),2),0),0)","v":50},15225.975,3564,null,22]
[null,null,2,6,6,6,6,6,6,12,516.5,null,216,11795,4968,{"$f":"IF($R$10=$U$9,IF(T38<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T38-1,'from author'!$W$3:$W$8,1),2),0),0)","v":50},15923.250000000002,3726,null,23]
[null,null,1,6,6,6,6,6,6,12,516.5,null,216,12311.5,5184,{"$f":"IF($R$10=$U$9,IF(T39<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T39-1,'from author'!$W$3:$W$8,1),2),0),0)","v":50},16620.525000000001,3888,null,24]
[null,null,"Gr. floor",6,6,6,6,6,6,12,516.5,null,216,12828,5400,{"$f":"IF($R$10=$U$9,IF(T40<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T40-1,'from author'!$W$3:$W$8,1),2),0),0)","v":50},17317.800000000003,4050,null,25]
[null,null,"B-1",6,6,6,6,6,6,12,516.5,null,216,13344.5,5616,{"$f":"IF($R$10=$U$9,IF(T41<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T41-1,'from author'!$W$3:$W$8,1),2),0),0)","v":50},18015.075000000001,4212,null,26]
[null,null,"B-2",6,6,6,6,6,6,12,516.5,null,216,13861,5832,{"$f":"IF($R$10=$U$9,IF(T42<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T42-1,'from author'!$W$3:$W$8,1),2),0),0)","v":50},18712.350000000002,4374,null,27]
[null,null,"B-3",6,6,6,6,6,6,12,516.5,null,216,14377.5,6048,{"$f":"IF($R$10=$U$9,IF(T43<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T43-1,'from author'!$W$3:$W$8,1),2),0),0)","v":50},19409.625,4536,null,28]
[null,null,"B-4",6,6,6,6,6,6,12,516.5,null,216,14894,6264,{"$f":"IF($R$10=$U$9,IF(T44<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T44-1,'from author'!$W$3:$W$8,1),2),0),0)","v":50},20106.900000000001,4698,null,29]
[null,null,"B-5",6,6,6,6,6,6,12,516.5,null,216,15410.5,6480,{"$f":"IF($R$10=$U$9,IF(T45<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T45-1,'from author'!$W$3:$W$8,1),2),0),0)","v":50},20804.175000000003,4860,null,30]
[null,null,"B-6",6,6,6,6,6,6,12,516.5,null,216,15927,6696,{"$f":"IF($R$10=$U$9,IF(T46<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T46-1,'from author'!$W$3:$W$8,1),2),0),0)","v":50},21501.45,5022,null,31]
[null,null,"B-7",6,6,6,6,6,6,12,516.5,null,216,16443.5,6912,{"$f":"IF($R$10=$U$9,IF(T47<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T47-1,'from author'!$W$3:$W$8,1),2),0),0)","v":50},22198.725000000002,5184,null,32]
[null,null,"B-8",6,6,6,6,6,6,12,516.5,null,216,16960,7128,{"$f":"IF($R$10=$U$9,IF(T48<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T48-1,'from author'!$W$3:$W$8,1),2),0),0)","v":50},22896,5346,null,33]
[null,null,"B-9",6,6,6,6,6,6,12,516.5,null,216,17476.5,7344,{"$f":"IF($R$10=$U$9,IF(T49<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T49-1,'from author'!$W$3:$W$8,1),2),0),0)","v":50},23593.275000000001,5508,null,34]
[null,null,"B-10",6,6,6,6,6,6,12,516.5,null,216,17993,7560,{"$f":"IF($R$10=$U$9,IF(T50<$J$8+$J$9+2,INDEX('from author'!$W$3:$X$8,MATCH(T50-1,'from author'!$W$3:$W$8,1),2),0),0)","v":50},24290.550000000003,5670,null,35]
[null,null,null,null,null,null,null,null,null,{"$f":"\"TOTAL FACTORED AND REDUCED LOAD ON \"&INDEX($V$13:$V$14,MATCH($C$5,$U$13:$U$14,0))&\" [kN]:\"","v":"TOTAL FACTORED AND REDUCED LOAD ON COLUMN [kN]:"},null,null,null,null,null,null,{"$f":"INDEX(Q16:R50,$J$8+$J$9+1,1)+INDEX(Q16:R50,$J$8+$J$9+1,2)","v":29960.550000000003}]
[null,null,"Spreadsheet provided by: www.YourSpreadsheets.co.uk"]

{"sheet":"from author","index":1,"n_rows":35,"n_cols":24,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,2,38,9],[12,2,30,9],[6,2,9,9],[0,6,0,10],[0,1,0,5],[4,12,4,13],[2,2,2,5],[2,6,2,9],[3,2,3,5],[3,6,3,9]]}
[null,"Version: 1.0.",null,null,null,null,"© 2014 Damian Janicki"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of storeys:","Reduction:"]
[null,null,"For latest updates and news visit:",null,null,null,"Contact me at:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0]
[null,null,"www.YourSpreadsheets.co.uk",null,null,null,"info@yourspreadsheets.co.uk",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,30]
[null,null,"General information:\nNote: This spreadsheet contains macros. These must be enabled to use this spreadsheet.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,50]
[]
[]
[]
[]
[null,null,"The Author takes no liability for use of this spreadsheet and gives no guarantee that it is error free. \n\nIn no event shall the Author be responsible for any special, incidental or consequential damages whatsoever arising from the use of this spreadsheet, even if the Author has been advised of the possibility of such damage.\n\nThis is a FREE spreadsheet. The spreadsheet can be distributed freely but only in its original form.\n\nReverse-engineering, decompiling or disassembling of this spreadsheet is not allowable.\n\nBy using this spreadsheet you understand and agree with the above terms and conditions. You also acknowledge that you do not become the owner of this spreadsheet.\n\nDamian Janicki"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"This spreadsheet is in accordance with EN 1991-1 + UK N.A.\n\nChangelog:\n30.12.2014 - official release of the spreadsheets version 1.0."]