{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Freestanding wall","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":"Freestanding wall","index":0,"n_rows":63,"n_cols":45,"rows_kept":63,"cut":false,"hidden":false,"merged":[[57,2,60,27],[50,2,50,27],[51,2,51,27],[52,2,52,27],[53,2,55,27],[45,2,46,27],[47,2,47,27],[48,2,48,27],[49,2,49,27],[17,2,17,27],[41,2,42,27],[43,2,43,27],[44,2,44,27],[12,15,12,27],[13,15,13,27],[14,15,14,27],[15,15,15,27],[11,10,11,13],[12,10,12,13],[13,10,13,13],[14,10,14,13],[8,2,8,9],[8,15,8,27],[9,15,9,27],[10,15,10,27],[11,15,11,27],[10,2,10,9],[9,10,9,13],[14,2,14,9],[15,2,15,9],[9,2,9,9],[62,2,62,14],[5,2,5,3],[5,22,5,24],[5,25,5,28],[62,15,62,27],[5,4,5,14],[5,18,5,21],[5,15,5,17],[15,10,15,13],[8,10,8,13],[11,2,11,9],[13,2,13,9],[12,2,12,9],[7,2,7,13],[7,15,7,27],[10,10,10,13],[0,1,0,15],[0,16,0,28],[1,22,1,27],[2,22,2,24],[2,25,2,28],[3,22,3,24],[3,25,3,28],[4,22,4,24],[4,25,4,28],[1,4,4,14],[1,15,3,21],[4,18,4,21],[4,15,4,17]]}
[null,"Version: 1.0. - FREE Lite version",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© 2017 Damian Janicki"]
[null,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,null,null,null,"TEST PROJECT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revision",null,null,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page:",null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Job No:",null,null,22813,null,null,null,"Date:",null,null,{"$f":"TODAY()","v":"2017-11-12"}]
[null,null,"Member: ",null,"FREESTANDING MASONRY WALL",null,null,null,null,null,null,null,null,null,null,"Prepared By:",null,null,"DJ",null,null,null,"Checked By:",null,null,"DJ"]
[]
[null,null,"MASONRY DATA:",null,null,null,null,null,null,null,null,null,null,null,null,"GENERAL NOTES:"]
[null,null,"Wall height above ground 'H' [mm] =",null,null,null,null,null,null,null,800,null,null,null,null,"This specification is for simple plan freestanding walls only;"]
[null,null,"Wind exposure zone:",null,null,null,null,null,null,null,"Zone 4",null,null,null,null,"OPC means Ordinary Portland Cement;"]
[null,null,"Local exposure condition:",null,null,null,null,null,null,null,"Sheltered location",null,null,null,null,"SRPC means Sulphate Resisting Portland Cement;",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sheltered location","Brickwork","Clay","Ready-mixed","Dry soils","Low levels",null,null,215,215,null,null,{"$f":"\"max. 800 mm\"","v":"max. 800 mm"}]
[null,null,"Wall material type:",null,null,null,null,null,null,null,"Brickwork",null,null,null,null,"Given specification is adequate for most conditions;",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exposed location","Blockwork","Calcium silicate","Site mixed","Wet soils","High - Class 2",null,null,200,300,null,null,{"$f":"$AF$18&\" mm wide\"","v":"215 mm wide"}]
[null,null,"Brickwork type:",null,null,null,null,null,null,null,"Clay",null,null,null,null,"An upper height limit of 2500mm has been applied;",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dense concrete",null,null,"High - Class 3",null,null,null,null,null,null,{"$f":"\"min. 275 mm\"","v":"min. 275 mm"}]
[null,null,"Concrete mix:",null,null,null,null,null,null,null,"Ready-mixed",null,null,null,null,{"$f":"IF(AND($K$12=$AH$11,$K$13=$AI$11),\"For walls in areas with high driving rain index provide frost resistant\",\"\")","v":"For walls in areas with high driving rain index provide frost resistant"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High - Class 4",null,null,null,null,null,null,{"$f":"\"min. \"&$AF$19&\" mm\"","v":"min. 575 mm"}]
[null,null,"Ground conditions:",null,null,null,null,null,null,null,"Dry soils",null,null,null,null,{"$f":"IF(AND($K$12=$AH$11,$K$13=$AI$11),\"   clay bricks throughout the wall with desig. (i) mortar below low level dpc\",\"\")","v":"   clay bricks throughout the wall with desig. (i) mortar below low level dpc"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"min. 500 mm"]
[null,null,"Sulphate levels:",null,null,null,null,null,null,null,"Low levels",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,575,650,null,null,{"$f":"\"Use \"&IF(AND($K$15=$AK$12,MATCH($K$16,AL11:AL14,0)>1),\"SRPC mortar below low level dpc.\",IF(AND($K$12=$AH$11,$K$13=$AI$11),\"OPC mortar below low level dpc for FL clay bricks and SRPC mortar for FN bricks.\",\"OPC mortar below low level dpc.\"))","v":"Use OPC mortar below low level dpc for FL clay bricks and SRPC mortar for FN bricks."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GEN 3 (with 125mm nominal slump)","standard ST 2 or a 1 to 8 (OPC)",null,null,null,null,null,425,500]
[null,null,"DIAGRAM:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wall thickness 't' [mm] =",{"$f":"INDEX($AO$11:$AP$12,MATCH($K$12,$AH$11:$AH$12,0),MATCH($K$11,$AG$11:$AG$12,0))","v":215},null,"FND2","1 to 4 (OPC) or 1 to 4 1/2 (SRPC)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Foundation width 'W' [mm] =",{"$f":"IF($AF$18=\"N/A\",\"N/A\",INDEX($AO$16:$AP$17,MATCH($K$12,$AH$11:$AH$12,0),MATCH($K$11,$AG$11:$AG$12,0)))","v":575},null,"FND3","1 to 4 (SRPC)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FND4","1 to 3 1/2 (SRPC)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Foundation concrete mix to be \"&IF(AND($K$14=$AJ$11,$K$15=$AK$11),$AH$17,IF(AND($K$14=$AJ$12,$K$15=$AK$11),$AI$17,INDEX(AH17:AI20,MATCH($K$16,AL11:AL14,0),MATCH($K$14,$AJ$11:$AJ$12,0))))&\" to BS 5328\"&IF($K$14=$AJ$12,\". All site mixes must be carefully batched by weight. Max. 20mm aggregate;\",\";\")","v":"Foundation concrete mix to be GEN 3 (with 125mm nominal slump) to BS 5328;"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"SPECIFICATION:"]
[null,null,"① High level dpc under frost resistant capping or coping. Copings to have min. 45mm overhangs with a drip. Capping to have slates project min. 45mm each side. Otherwise use type F bricks throughout in the wall. For high level dpc use metal, bitumen, polyethylene (a high bond type) or slates or bricks;"]
[]
[null,null,{"$f":"\"② \"&IF($K$12=$AH$11,\"Bricks with min. density of 1200 kg/m3.\",\"Dense concrete blocks to BS 6073, with min. density of 1500 kg/m3;\")&IF(AND($K$12=$AH$11,$K$13=$AI$11),\" If coping/capping has 45mm overhangs then use MN/ML clay bricks, otherwise use FN/FL. All to BS 3921;\",IF(AND($K$12=$AH$11,$K$13=$AI$12),\" Calcium silicate bricks of Class 3 or stronger to BS 187;\",IF(AND($K$12=$AH$11,$K$13=$AI$13),\" Dense concrete bricks to BS 6073;\",\"\")))","v":"② Bricks with min. density of 1200 kg/m3. If coping/capping has 45mm overhangs then use MN/ML clay bricks, otherwise use FN/FL. All to BS 3921;"}]
[null,null,{"$f":"\"③ \"&IF($K$15=$AK$12,\"Mortar to be design. (i) below low level dpc and (ii) above, all to BS5628-1. (i) is 1:1/4:3 and (ii) is 1:1/2:4.5 C:L:S.\",\"Mortar to be designation (ii) to BS5628-1, 1:1/2:4 1/2 Cement:Lime:Sand.\")&\" Use coarser sands (Type S to BS 1200);\"","v":"③ Mortar to be designation (ii) to BS5628-1, 1:1/2:4 1/2 Cement:Lime:Sand. Use coarser sands (Type S to BS 1200);"}]
[null,null,{"$f":"\"④ \"&IF(AND($K$12=$AH$11,$K$13=$AI$11),\"FL/FN clay bricks to BS 3921, with min. density of 1200 kg/m3. \",IF(AND($K$12=$AH$11,$K$13=$AI$12),\"Calcium silicate bricks of Class 4 or stronger to BS 187, with min. density of 1200 kg/m3. \",IF(AND($K$12=$AH$11,$K$13=$AI$13),\"Dense concrete bricks to BS 6073, with min. density of 1200 kg/m3. \",\"Dense concrete blocks to BS 6073, with min. density of 1500 kg/m3. \")))&$AS$16&IF(AND(K12=AH11,K13=AI11),\" Low level dpc not required;\",\" Do not use flexible materials (e.g. bitumen or polyethylene) or slates for low level dpc;\")","v":"④ FL/FN clay bricks to BS 3921, with min. density of 1200 kg/m3. Use OPC mortar below low level dpc for FL clay bricks and SRPC mortar for FN bricks. Low level dpc not required;"}]
[]
[null,null,{"$f":"\"⑤ \"&$AI$21","v":"⑤ Foundation concrete mix to be GEN 3 (with 125mm nominal slump) to BS 5328;"}]
[null,null,"⑥ Foundations to be founded min. 150mm into firm ground. Blind the trench if placing footing several days after digging (or it has rained);"]
[null,null,{"$f":"\"⑦ Movement joints \"&IF(AND($K$12=$AH$11,$K$13=$AI$11),\"to be at max. 12m crs and max. 6m from wall end.\",IF(AND($K$12=$AH$11,$K$13=$AI$12),\"to be at max. 9m crs and max. 4.5m from wall end.\",\"to be at max. 6m crs and max. 3m from wall end.\"))&\" Use 25mm thick continuous 'aerofil' joint with 25x12mm polysulphide sealant;\"","v":"⑦ Movement joints to be at max. 12m crs and max. 6m from wall end. Use 25mm thick continuous 'aerofil' joint with 25x12mm polysulphide sealant;"}]
[null,null,"⑧ Provide 225mm long Ancon stainless steel PPS ties (or equivalent approved) at 300mm crs vertically. One end debonded. Ties centred on the wall;"]
[null,null,"⑨ Typical movement joint is required where freestanding wall abuts that of a building. Provide debonded wall ties as specified in point ⑧ above;"]
[null,null,{"$f":"\"⑩ \"&IF($K$12=$AH$11,\"Bricks to provide moderate degree of adhesion;\",\"Blocks to provide moderate degree of adhesion;\")","v":"⑩ Bricks to provide moderate degree of adhesion;"}]
[null,null,{"$f":"\"⑪ General: (1) Provide bridge over drains or large tree roots. (2) At steps, step length must not be less than footing depth. \"&\"(3) Provide a curb at a distance of 1m from any freestanding wall adjacent to area used by vehicles. (4) If there is a high risk of damage by vehicles, consider building a reinforced wall. (5) \" &IF($K$12=$AH$11,\"Min. 330x330 piers are recommended at wall ends and where a lightweight gate is to be supported (max. 10kg and 0.8m wide);\",\"Min. 450x320 piers are recommended at wall ends and where a lightweight gate is to be supported (max. 10kg and 0.8m wide). Use galvanised or SS ties at each course for strength. \")&\"At piers foundations to be widened so that they are at least 100mm wider than the masonry;\"","v":"⑪ General: (1) Provide bridge over drains or large tree roots. (2) At steps, step length must not be less than footing depth. (3) Provide a curb at a distance of 1m from any freestanding wall adjacent to area used by vehicles. (4) If there is a high risk of damage by vehicles, consider building a reinforced wall. (5) Min. 330x330 piers are recommended at wall ends and where a lightweight gate is to be supported (max. 10kg and 0.8m wide);At piers foundations to be widened so that they are at least 100mm wider than the masonry;"}]
[]
[]
[]
[null,null,"This specification is NOT suitable for: (1) stone walls, retaining walls or parapet walls on buildings. (2) sites with average slope greater than 1 in 10. (3) walls used as vehicle crash barrier or protection. (4) walls adjacent to public right of way where there is risk of crowd pressure or of children playing around the wall. (5) where excessive vibration, eg from traffic, occurs. (6) walls close to a medium (more than 4 storeys) or high rise building (i.e. nearer than a distance equal to height of the building). (7) walls on crest of hill, or in vicinity of extensive hill or mountain range. (8) walls used to support large gate or door. (9) where soil substructure is soft (e.g. soft clay, peat, organic soils) or unstable (e.g. poorly compacted fill). (10) where the difference in ground level between each side of the wall exceeds twice the wall thickness. (11) soils contaminated by industrial waste where acids may be present."]
[]
[]
[]
[]
[null,null,"Spreadsheet provided by: www.YourSpreadsheets.co.uk",null,null,null,null,null,null,null,null,null,null,null,null,"based on rule of thumb given in BRE Good Building Guide 14"]

{"sheet":"from author","index":1,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,1,0,5],[0,6,0,10],[2,2,2,5],[2,6,2,9],[3,2,3,5],[3,6,3,9],[4,12,4,13],[6,2,9,9],[12,2,29,9],[33,2,36,9],[40,2,43,9]]}
[null,"Version: 1.0. - FREE LITE VERSION",null,null,null,null,"© 2017 Damian Janicki"]
[]
[null,null,"For latest updates and news visit:",null,null,null,"Contact me at:"]
[null,null,"www.YourSpreadsheets.co.uk",null,null,null,"info@yourspreadsheets.co.uk"]
[]
[]
[null,null,"General information:\nNote: This spreadsheet contains macros."]
[]
[]
[]
[]
[]
[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 spreadsheet is a freeware and 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 is a Free Lite Version. The full version of the spreadsheet allows to:\n- Input your company information, change logo and change header information\n- Change wall height\n- Change wind exposure zone"]
[]
[]
[]
[]
[]
[]
[null,null,"This spreadsheet is based on BRE GBG 14.\n\nChangelog:\n2017.11.13 - v.1.0. - official release of the spreadsheet."]