{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Home Page","Site","Structure","Construction","Results","FAQ","Exposure Map","EQ Regions","Wind Regions","text_sheet","tracking_sheet","data_sheet","print_sheet"],"not_rendered":{"charts":4,"images":8,"macros":1,"external_links":0,"defined_names":93,"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":"Home Page","index":0,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[29,10,30,10],[20,3,31,8],[19,9,20,9],[19,10,20,10],[21,9,23,9],[21,10,23,10],[26,9,28,9],[27,10,28,10],[29,9,30,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"Tabout0","v":"The Prefab Toolkit enables costs to be combined with time in order to assess the merits of prefabrication at the start of the design and construction process.\nThe user inputs parameters that cover site, structure and construction conditions of the design.  Once the user has entered all the necessary information the tool will present the best prefabrication option suitable for their design. From there the tool will assess the time and cost benefits of building with prefabrication rather than a traditional style of build. Through graphical and written comparisons traditional and prefabricated can be measured against each other.\nThe Prefab Toolkit was developed and funded through PrefabNZ Incorporated and Victoria University of Wellington, with additional development by BRANZ Ltd."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"©2013 PrefabNZ Inc."]

{"sheet":"Site","index":1,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[[10,11,29,12],[29,9,30,9],[29,10,30,10],[26,9,28,9],[27,10,28,10],[17,9,18,9],[17,10,18,10],[19,9,20,9],[19,10,20,10],[21,9,23,9],[21,10,23,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Did you know?"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tabout1","v":"Prefab’s sustainability merits include reduced material waste through efficient ordering, indoor protection, pre-planning and cutting, and re-use. Up to 60% of material usage can be saved using modular construction. \nCurrently, 40% of our country’s waste is created by the New Zealand construction industry so there are good reasons to be making improvements. \n\nPotential benefits include less disruption, noise, pollution, effluence, ground-works, traffic and fewer deliveries. \n\nIt has been estimated that a prefab building contributes 15% less greenhouse gas emissions in its construction compared with traditional construction. "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"©2013 PrefabNZ Inc."]

{"sheet":"Structure","index":2,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[[29,10,30,10],[10,11,11,12],[13,11,14,12],[16,11,16,12],[17,9,18,9],[17,10,18,10],[19,9,20,9],[19,10,20,10],[21,9,23,9],[21,10,23,10],[26,9,28,9],[27,10,28,10],[29,9,30,9],[18,11,30,12]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Did you know?"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tabout2A","v":"Prefabrication can be a high quality built solution:"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tabout2B","v":"“Improvement in quality is regarded as the principal advantage of prefabricated housing” "}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tabout2C","v":"according to UK research by Brian Cook in 2005."}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tabout3C","v":"Prefab comes in all shapes and sizes, from small components such as pre-nailed wall frames, to panels, larger modules (3D volumes) or even complete buildings.  Hybrid prefab is a mixture of several prefab systems, or prefab with traditional construction. Prefab can be made of timber, concrete, metals or plastics or any combination.\n\nFactory testing and quality controls enable a tighter building envelope and better energy efficiencies for reduced running costs throughout the building’s life-cycle. "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"©2013 PrefabNZ Inc."]

{"sheet":"Construction","index":3,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[[21,9,23,9],[21,10,23,10],[26,9,28,9],[27,10,28,10],[10,11,16,12],[17,11,23,12],[24,11,30,12],[29,9,30,9],[29,10,30,10],[17,9,18,9],[17,10,18,10],[19,9,20,9],[19,10,20,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Did you know?"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"text_sheet!C17","v":"Prefab is a way to create innovative high-quality buildings on time and within budget.  Your home probably has prefab roof trusses and wall frames.  Your bach might be a transportable building.  Your workplace may use precast concrete elements."}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tabout3B","v":"Prefab is short for prefabrication. It refers to any part of a building that is made away from the final building site, which is why it can also be referred to as offsite construction.\nPrefab is a complimentary system to traditional construction."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"©2013 PrefabNZ Inc."]

{"sheet":"Results","index":4,"n_rows":167,"n_cols":12,"rows_kept":167,"cut":false,"hidden":false,"merged":[[10,3,10,8],[28,3,28,4],[27,3,27,8],[30,10,31,10],[10,11,13,12],[18,10,19,10],[20,10,21,10],[22,10,24,10],[28,10,29,10],[15,11,18,12],[48,3,48,8],[70,3,70,8],[30,3,34,8],[29,3,29,8],[36,3,36,8],[42,3,42,8],[37,3,40,8],[43,3,46,8],[113,3,113,8],[96,3,96,8],[98,3,98,8],[100,3,100,8],[102,3,102,8],[104,3,104,8],[106,3,107,8],[109,3,109,8],[111,3,111,8],[149,3,150,8],[151,3,153,8],[154,3,155,8],[159,3,163,8],[115,3,115,8],[116,3,122,8],[124,3,124,8],[125,3,131,8],[133,3,133,8],[134,3,139,8],[141,3,141,8],[142,3,144,8],[145,3,146,8],[147,3,148,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Your Project Summary",null,null,null,null,null,null,null,{"$f":"Tabout5","v":"Thanks for using the Prefab Toolkit – for more info about prefab get in touch with PrefabNZ – email info@prefabnz.com or visit www.prefabnz.com"}]
[]
[null,null,null,"Site",null,null,"Structure"]
[null,null,null,"EQ Region",{"$f":"data_sheet!$E$3","v":"Zone 1"},null,"No. of Floors",{"$f":"NoOfFloors","v":1}]
[null,null,null,"Exposure Zone",{"$f":"data_sheet!$E$8","v":"B"},null,"Floor Area",{"$f":"data_sheet!H13","v":"100 m²"}]
[null,null,null,"Wind Regions",{"$f":"data_sheet!$E$12","v":"A"},null,"External Walls",{"$f":"ExternalWalls","v":4},null,null,null,{"$f":"Tabout6","v":"Should you require further information relating to BRANZ products, services and information please contact (04) 237 1170 or email branz@branz.co.nz"}]
[null,null,null,"Site Access",{"$f":"data_sheet!$E$16","v":"Suburban"},null,"Window:Wall",{"$f":"data_sheet!H14","v":"25 %"}]
[null,null,null,"Access Restrictions",{"$f":"IF(data_sheet!$H$3=TRUE,\"Yes\",\"No\")","v":"No"}]
[null,null,null,"Site Restrictions",{"$f":"IF(data_sheet!$H$4=TRUE,\"Yes\",\"No\")","v":"No"},null,"Construction"]
[null,null,null,"Distance from Town",{"$f":"data_sheet!H15","v":"30 km"},null,"Foundations",{"$f":"data_sheet!$N$3","v":"Timber Subfloor on Piles"}]
[null,null,null,null,null,null,"Lower Wall Framing",{"$f":"data_sheet!$N$10","v":"Timber"}]
[null,null,null,null,null,null,"Lower Wall Cladding",{"$f":"data_sheet!$N$14","v":"Weatherboards"}]
[null,null,null,null,null,null,"Upper Wall Framing",{"$f":"data_sheet!$N$20","v":"Not Applicable"}]
[null,null,null,null,null,null,"Upper Wall Cladding",{"$f":"data_sheet!$N$25","v":"Not Applicable"}]
[null,null,null,null,null,null,"Roof Cladding",{"$f":"data_sheet!$N$35","v":"Long Run Metal"}]
[]
[]
[null,null,null,"Recommendations"]
[]
[null,null,null,{"$f":"\"Recommended: \"&IF(OptionComplete,\"Transportable\",IF(OptionModular,\"Hybrid/Modular\",IF(OptionOpen,\"Open Panelised\",IF(OptionClosed,\"Closed Panelised\",\"Prefabrication is Inappropriate\"))))","v":"Recommended: Transportable"}]
[null,null,null,{"$f":"IF(OptionComplete,TcompleteIsBest,IF(OptionModular,TmodularIsBest,IF(OptionOpen,TopenIsBest,IF(OptionClosed,TclosedIsBest,TnoRecommend))))","v":"Based on the information supplied, the best prefabrication method to use would be the transportable building option. Transportable buildings are commonly known as portable, relocatable, or offsite-built dwellings in New Zealand. Transportable buildings are constructed in a factory or yard and then moved to site where they are attached to permanent foundations."}]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"IF(AND(OptionComplete,OptionModular),\"Alternatively: Hybrid/Modular\",IF(OR(OptionComplete,OptionModular),IF(OptionOpen,\"Alternatively: Open or Closed Panelised\",IF(OptionClosed,\"Alternatively: Closed Panelised\")),\"\"))","v":"Alternatively: Hybrid/Modular"}]
[null,null,null,{"$f":"IF(AND(OptionComplete,OptionModular),TmodularAlternative,IF(OR(OptionComplete,OptionModular),IF(OptionOpen,TopenClosedAlternative,IF(OptionClosed,TclosedAlternative)),\"\"))","v":"An alternative prefabrication method for your circumstances is hybrid/modular. Modular, sectional, or volumetric prefabrication refer to three-dimensional structural units which are combined at site with other units or systems. Cores and pods are non-structural units used inside conventional buildings or modules.  "}]
[]
[]
[]
[]
[null,null,null,{"$f":"IF(AND(OptionComplete,OptionModular,OptionClosed),\"Alternatively: Open or Closed Panelised\",\"\")","v":"Alternatively: Open or Closed Panelised"}]
[null,null,null,{"$f":"IF(AND(OptionComplete,OptionModular,OptionClosed),TopenClosedAlternative,\"\")","v":"An alternative prefabrication method for your circumstances is closed or open panelised. Panelised or non-volumetric prefabrication is made of manufactured panel elements that can be classified as open  or closed: Open refers to framing elements, whereas closed panels incorporate services with windows and doors, exterior cladding and interior lining. "}]
[]
[]
[]
[]
[null,null,null,"Prefabrication is faster than traditional construction."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Prefabrication results in less greenhouse gas emissions."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"*Carbon dioxide emissions in tonnes"]
[]
[null,null,null,"Sustainability Benefits of Prefabrication"]
[]
[null,null,null,"Factory-control makes best use of materials and produces less waste."]
[]
[null,null,null,"Reduced energy consumption compared to on-site construction."]
[]
[null,null,null,"Reduced transport costs as site travelling is minimised."]
[]
[null,null,null,"Minimal site disruption minimizes production times and long-term footprint."]
[]
[null,null,null,"Because construction is done in a controlled environment the health and safety of workers can be closely monitored."]
[]
[]
[null,null,null,"Tool and material security as work is done in a secure facility."]
[]
[null,null,null,"Reduced noise levels onsite. Neighbours do not have to ‘put up’ with construction noise."]
[]
[null,null,null,"Issues to Consider"]
[]
[null,null,null,{"$f":"SUBSTITUTE(TyourEQ,\"X\",IF(data_sheet!E3>=3,\"high\",IF(data_sheet!E3>=2,\"moderate\",\"low\")))","v":"Your site is in a high risk earthquake zone."}]
[null,null,null,{"$f":"TinfoEQ","v":"Wind and earthquake forces exert horizontal forces on buildings. Bracing design involves the determination of both the extent of these forces, called the bracing demand, and also the determination of the capacity of the building and its elements to resist these forces, called bracing capacity (NZS 3604:2011).  The earthquake bracing demand on the building structure shall be assessed on the basis of the building location (ie earthquake zone) amongst other things. Prefabricated buildings can be made as strong as necessary to provide the bracing required."}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"SUBSTITUTE(TyourExposure,\"X\",IF(data_sheet!E8>=3,\"high\",IF(data_sheet!E10>=2,\"moderate\",\"low\")))","v":"Your site is exposed to high levels of sea salt and other corrosive substances."}]
[null,null,null,{"$f":"TinfoExposure","v":"All buildings in New Zealand are classified into exposure zones.  The zoning reflects site exposure to sea spray or geothermal areas and will determine the materials that can be used. For example, metal claddings and fastenings will rust more quickly than stainless steel fastenings when exposed to sea spray.  The site zone will affect guarantees manufacturers offer on their products. Prefabrication is no different in this regard to traditional construction and can be used in corrosion zones, with choices about materials used determining the durability at the structure."}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"SUBSTITUTE(TyourWind,\"X\",IF(data_sheet!E12>=3,\"exposed to lee winds\",IF(data_sheet!E17>=2,\"subject to strong winds\",\"not subject to strong winds\")))","v":"Your site is in a region exposed to lee winds."}]
[null,null,null,{"$f":"TinfoWindRegions","v":"Buildings are required to withstand lateral loads applied by wind. The amount of bracing required to resist the lateral loads on the building is based on the design wind speed. NZS 3604 divides New Zealand into two wind regions (A and W) and several lee zone areas-these are areas where the landforms create localized wind acceleration resulting in higher wind speeds than the rest of the region. Prefabrication is no different in this regard to traditional construction, and can be designed to have the required bracing elements."}]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TyourSiteAccess,\"Xa\",IF(SiteAccess=1,\"an urban\",IF(SiteAccess=2,\"a suburban\",\"a rural\"))),\"Xb\",IF(AccessRestricted,\" Access to your site is restricted. \",\"\")),\"Xc\",IF(SiteRestricted,\" There are obstructions around your site.\",\"\"))","v":"Your site is situated in a suburban location.  "}]
[null,null,null,{"$f":"TinfoSiteAccessA","v":"Site access is a very important aspect of any construction project. It is necessary to have a clear understanding of the site and the methods of delivery to and from as this can have influence on both cost and time overruns. We have broken this into three types of site:"}]
[]
[]
[null,null,null,{"$f":"TinfoSiteAccessB","v":"• Urban locations typically require craneage to access sites, which is specific to the site and not assessed with this tool."}]
[]
[null,null,null,{"$f":"TinfoSiteAccessC","v":"• Suburban locations may have infrastructure and utility lines that restrict access, which are site specific and no assessed with this tool."}]
[]
[null,null,null,{"$f":"TinfoSiteAccessD","v":"• Rural locations are likely to have slope or vegetation restrictions, and potentially narrow difficult roads, which are site specific and not assessed with this tool."}]
[]
[null,null,null,{"$f":"TinfoSiteAccessE","v":"• Access restrictions: there is no access for HGV's or large mobile cranes due to low road bridges, long/windy/narrow driveways, or poor bearing surfaces.  This restricts access to small rigid HGV's with Hilabs, and LGVs."}]
[]
[]
[null,null,null,{"$f":"TinfoSiteAccessF","v":"• Site restrictions: there is no ability to swing a load due to neighbouring buildings, infrastructure, vegetation, etc. Hence no craneage is possible."}]
[]
[]
[]
[null,null,null,"Disclaimer"]
[null,null,null,{"$f":"Tabout4","v":"PrefabNZ Incorporated can not be held responsible for the reliability of the Prefab Toolkit results. The results are limited by the quality of case study data which has been supplied confidentially by other parties. The Prefab Toolkit will be updated over time with future versions of increasing accuracy. The purpose of the Prefab Toolkit is as a 'conversation starter' to enable projects to consider prefabrication as an alternative to traditional construction methods. Any feedback about the Prefab Toolkit can be directed to info@prefabnz.com"}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"©2013 PrefabNZ Inc."]

{"sheet":"FAQ","index":5,"n_rows":80,"n_cols":12,"rows_kept":80,"cut":false,"hidden":false,"merged":[[12,11,12,12],[15,11,16,12],[14,11,14,12],[18,11,18,12],[21,11,22,12],[20,11,20,12],[28,10,29,10],[30,10,31,10],[18,10,19,10],[20,10,21,10],[22,10,24,10],[23,3,23,8],[24,3,25,8],[55,3,55,9],[50,3,50,8],[51,3,53,8],[45,3,45,8],[46,3,48,8],[27,3,27,8],[10,3,10,8],[15,3,15,8],[16,3,18,8],[19,3,21,8],[11,3,13,8],[67,3,67,8],[68,3,70,8],[72,3,72,8],[73,3,77,8],[28,3,31,8],[33,3,33,8],[34,3,36,8],[38,3,38,8],[39,3,43,8],[56,3,59,8],[62,3,65,8],[61,3,61,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"text_sheet!C49","v":"What makes prefab so special?"},null,null,null,null,null,null,null,"Links (click to access)"]
[null,null,null,{"$f":"text_sheet!C50","v":"Prefab is an agent for innovation and can offer higher-quality, more timely and cost-effective built solutions to clients. Unless you know about the range of available options, you won’t be able to benefit from them!"}]
[null,null,null,null,null,null,null,null,null,null,null,"PrefabNZ Homepage"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"PrefabNZ Directory"]
[null,null,null,{"$f":"text_sheet!C51","v":"How exactly does prefab improve quality?"},null,null,null,null,null,null,null,"For access to PrefabNZ services and industry contacts."]
[null,null,null,{"$f":"text_sheet!C52","v":"By constructing parts (components, panels, modules or complete buildings) in a controlled environment, away from inclement weather, where worker and resource use can be closely monitored and enhanced."}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"BRANZ Homepage"]
[null,null,null,{"$f":"text_sheet!C53","v":"“This type of construction method  allows for greater quality control, as faults can be identified early and easily managed and addressed placing more professionalism back into the industry” Collin Clench (Performance Assurance Manager, Hutt City Council)"}]
[null,null,null,null,null,null,null,null,null,null,null,"BRANZ SR 279"]
[null,null,null,null,null,null,null,null,null,null,null,"Study report on costs and emissions of prefab projects"]
[]
[null,null,null,{"$f":"text_sheet!C54","v":"How does prefab save time?"}]
[null,null,null,{"$f":"text_sheet!C55","v":"“By constructing parts off site (in a factory or yard) at the same time as on site construction takes place.”  Michelle Kaufmann (Prefab Green)"}]
[]
[]
[null,null,null,{"$f":"text_sheet!C56","v":"I thought prefab was meant to be cheaper - how does prefab save money?"}]
[null,null,null,{"$f":"text_sheet!C57","v":"Prefab is primarily a way to a higher quality built solution. It is possible to save money by repeating elements or details, reusing templates or jigs, and other efficiencies in a controlled environment. Also, cost savings can be achieved from a reduced timeframe and subsequent reduced borrowings."}]
[]
[]
[]
[]
[null,null,null,{"$f":"text_sheet!C58","v":"But isn’t prefab flimsy, temporary and mobile?"}]
[null,null,null,{"$f":"text_sheet!C59","v":"Not anymore! Past prefabs may have had one or all of these attributes but today the use of the computer for mass-customisation enables a variety of high-quality products to be designed, fabricated and constructed."}]
[]
[]
[]
[null,null,null,{"$f":"text_sheet!C60","v":"Don’t all prefabs look the same – little boxes of ticky-tacky…?"}]
[null,null,null,{"$f":"text_sheet!C61","v":"Surprisingly, even cultures that appear to have more homogeneity than our own (such as Japan) claim that each prefab building is unique. As a general rule, the smaller the component, the greater the variation and computer-aided-design enables customisation by clients. We have moved from an era of ‘mass-standardisation’ in the mid-20th-century to an era of ‘mass-customisation’ today."}]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"text_sheet!C62","v":"What’s so great about joining PrefabNZ?"}]
[null,null,null,{"$f":"text_sheet!C63","v":"Lots of tangible stuff (web, e-news, database, events etc.) but also, you get to connect your business with other industry players to either buy or sell prefab or offsite systems, technologies and production capabilities from or to related product and service providers."}]
[]
[]
[]
[null,null,null,{"$f":"text_sheet!C64","v":"How will joining PrefabNZ help develop my business?"}]
[null,null,null,{"$f":"text_sheet!C65","v":"Through awareness of current research and development initiatives and possible collaborations and joint ventures with like-minded, compatible businesses. Why re-invent the wheel…"}]
[]
[]
[]
[null,null,null,{"$f":"text_sheet!C66","v":"When is the best time to consider prefab options?"}]
[null,null,null,{"$f":"text_sheet!C67","v":"Learn about prefab options NOW so you have them in your prefab tool-box. Consider prefab as EARLY in the design process as possible. Meet with specifiers, potential contractors and the client early in the design process to find out when the design needs to be frozen, for potential prefab benefits to be maximised."}]
[]
[]
[]
[]
[null,null,null,{"$f":"text_sheet!C68","v":"Why will prefab work now when it has failed in the past?"}]
[null,null,null,{"$f":"text_sheet!C69","v":"Today we have learnt from past mistakes and now understand that it takes more than great design – marketing and financial factors are crucial at start-up. We also have improved technologies (computer to machinery fabrication) and the market demand is there due to increased global prefab awareness since the early 2000s."}]
[]
[]
[]
[]
[null,null,null,{"$f":"text_sheet!C70","v":"How can prefab be a more sustainable construction option?"}]
[null,null,null,{"$f":"text_sheet!C71","v":"In a controlled environment it is possible to minimise material waste through careful use and re-use, and to achieve minimal construction tolerances to prevent energy loss (and reduce running costs)."}]
[]
[]
[]
[null,null,null,{"$f":"text_sheet!C72","v":"What does BIM and inter-operability have to do with prefab?"}]
[null,null,null,{"$f":"text_sheet!C73","v":"Industry buzz-words BIM (building information management) and inter-operability are ways for the industry to collaborate during the design and construction process, by working off a shared digital model with components (or panels or modules) traceable from design to fabrication to installation. This process is more efficient and productive. Many see this as the way of the future."}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"©2013 PrefabNZ Inc."]

{"sheet":"Exposure Map","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"EQ Regions","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Wind Regions","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"text_sheet","index":9,"n_rows":73,"n_cols":3,"rows_kept":73,"cut":false,"hidden":true,"merged":[[39,1,45,1],[39,0,45,0],[13,0,15,1],[29,1,34,1],[29,0,34,0],[16,1,18,1]]}
[null,"Title","  Text"]
[null,"Recommendations"]
[null,"Transportable is Best","Based on the information supplied, the best prefabrication method to use would be the transportable building option. Transportable buildings are commonly known as portable, relocatable, or offsite-built dwellings in New Zealand. Transportable buildings are constructed in a factory or yard and then moved to site where they are attached to permanent foundations."]
[null,"Hybrid/Modular is Best","Based on the information supplied hybrid/modular prefabrication would be the best prefabrication method to use. Modular, sectional, or volumetric prefabrication refer to three-dimensional structural units which are combined at site with other units or systems. Cores and pods are non-structural units used inside conventional buildings or modules.  "]
[null,"Panel (Open) is Best","Based on the information supplied the best prefabrication method to use would be open panelised prefabrication. Panelised or non-volumetric prefabrication is made of manufactured panel elements that can be classified as open  or closed: Open refers to framing elements."]
[null,"Panel (Closed) is Best","Based on the information supplied the best prefabrication method to use would be closed panelised prefabrication. Panelised or non-volumetric prefabrication is made of manufactured panel elements that can be classified as open  or closed: Closed panels incorporate services with windows and doors, exterior cladding and interior lining. "]
[null,"Hybrid/Modular is Alternative","An alternative prefabrication method for your circumstances is hybrid/modular. Modular, sectional, or volumetric prefabrication refer to three-dimensional structural units which are combined at site with other units or systems. Cores and pods are non-structural units used inside conventional buildings or modules.  "]
[null,"Panel (Closed) is Alternative","An alternative prefabrication method for your circumstances is closed panelised. Panelised or non-volumetric prefabrication is made of manufactured panel elements that can be classified as open  or closed: Closed panels incorporate services with windows and doors, exterior cladding and interior lining. "]
[null,"Panel (Open or Closed) is Alternative","An alternative prefabrication method for your circumstances is closed or open panelised. Panelised or non-volumetric prefabrication is made of manufactured panel elements that can be classified as open  or closed: Open refers to framing elements, whereas closed panels incorporate services with windows and doors, exterior cladding and interior lining. "]
[null,"No Recommendation","Unfortunately there is no obvious prefabrication solution available to you. If you wish to further explore whether a prefabrication solution is possible then please contact info@prefabnz.com"]
[null,"Popup Boxes"]
[null,"About Box 0 Introduction","The Prefab Toolkit enables costs to be combined with time in order to assess the merits of prefabrication at the start of the design and construction process.\nThe user inputs parameters that cover site, structure and construction conditions of the design.  Once the user has entered all the necessary information the tool will present the best prefabrication option suitable for their design. From there the tool will assess the time and cost benefits of building with prefabrication rather than a traditional style of build. Through graphical and written comparisons traditional and prefabricated can be measured against each other.\nThe Prefab Toolkit was developed and funded through PrefabNZ Incorporated and Victoria University of Wellington, with additional development by BRANZ Ltd."]
[null,"About Box 1 Site (Did you know?)","Prefab’s sustainability merits include reduced material waste through efficient ordering, indoor protection, pre-planning and cutting, and re-use. Up to 60% of material usage can be saved using modular construction. \nCurrently, 40% of our country’s waste is created by the New Zealand construction industry so there are good reasons to be making improvements. \n\nPotential benefits include less disruption, noise, pollution, effluence, ground-works, traffic and fewer deliveries. \n\nIt has been estimated that a prefab building contributes 15% less greenhouse gas emissions in its construction compared with traditional construction. "]
["About Box 2 Structure (Did you know?)",null,"Prefabrication can be a high quality built solution:"]
[null,null,"“Improvement in quality is regarded as the principal advantage of prefabricated housing” "]
[null,null,"according to UK research by Brian Cook in 2005."]
[null,"About Box 3 Construction (Did you know?)","Prefab is a way to create innovative high-quality buildings on time and within budget.  Your home probably has prefab roof trusses and wall frames.  Your bach might be a transportable building.  Your workplace may use precast concrete elements."]
[null,null,"Prefab is short for prefabrication. It refers to any part of a building that is made away from the final building site, which is why it can also be referred to as offsite construction.\nPrefab is a complimentary system to traditional construction."]
[null,null,"Prefab comes in all shapes and sizes, from small components such as pre-nailed wall frames, to panels, larger modules (3D volumes) or even complete buildings.  Hybrid prefab is a mixture of several prefab systems, or prefab with traditional construction. Prefab can be made of timber, concrete, metals or plastics or any combination.\n\nFactory testing and quality controls enable a tighter building envelope and better energy efficiencies for reduced running costs throughout the building’s life-cycle. "]
[null,"About Box 4 Results (Disclaimer)","PrefabNZ Incorporated can not be held responsible for the reliability of the Prefab Toolkit results. The results are limited by the quality of case study data which has been supplied confidentially by other parties. The Prefab Toolkit will be updated over time with future versions of increasing accuracy. The purpose of the Prefab Toolkit is as a 'conversation starter' to enable projects to consider prefabrication as an alternative to traditional construction methods. Any feedback about the Prefab Toolkit can be directed to info@prefabnz.com"]
[null,"About Box 5 Results (PrefabNZ)","Thanks for using the Prefab Toolkit – for more info about prefab get in touch with PrefabNZ – email info@prefabnz.com or visit www.prefabnz.com"]
[null,"About Box 6 Results (BRANZ)","Should you require further information relating to BRANZ products, services and information please contact (04) 237 1170 or email branz@branz.co.nz"]
[null,"Enter Distance from Town","Approximately how far out of the nearest large town/city \n(pop. 10 000 or more) are you?"]
[null,"Enter External Walls","The shape of the outside perimeter is an important consideration in estimating the total construction cost. Generally, the more complex the shape, the more expensive the structure per square metre of floor area. If the shape is complex it is going to be more difficult to construct and to break down into modular or regular components. Determine the complexity of the design by specifying the number of external walls."]
[null,"Enter Number of Floors","Although prefabrication is not limited to any scale, for the purpose of maintaining a constant scope this toolkit only allows input of up to 3 floors."]
[null,"Enter Window Ratio","Not only do windows play an important part in the aesthetics and environmental control of a building, but they also have bearing on the structure. Although for aesthetic purposes it may be desired to have large facades of glazing, it can be an impractical exercise requiring extra bracing resulting in the expenditure of more money and time. Acknowledging this is an important aspect in the design phase. Typically less than 30% is a recommended ratio of windows to wall."]
[null,"Info Earthquake Regions","Wind and earthquake forces exert horizontal forces on buildings. Bracing design involves the determination of both the extent of these forces, called the bracing demand, and also the determination of the capacity of the building and its elements to resist these forces, called bracing capacity (NZS 3604:2011).  The earthquake bracing demand on the building structure shall be assessed on the basis of the building location (ie earthquake zone) amongst other things. Prefabricated buildings can be made as strong as necessary to provide the bracing required."]
[null,"Info Exposure Zones","All buildings in New Zealand are classified into exposure zones.  The zoning reflects site exposure to sea spray or geothermal areas and will determine the materials that can be used. For example, metal claddings and fastenings will rust more quickly than stainless steel fastenings when exposed to sea spray.  The site zone will affect guarantees manufacturers offer on their products. Prefabrication is no different in this regard to traditional construction and can be used in corrosion zones, with choices about materials used determining the durability at the structure."]
[null,"Info Wind Regions","Buildings are required to withstand lateral loads applied by wind. The amount of bracing required to resist the lateral loads on the building is based on the design wind speed. NZS 3604 divides New Zealand into two wind regions (A and W) and several lee zone areas-these are areas where the landforms create localized wind acceleration resulting in higher wind speeds than the rest of the region. Prefabrication is no different in this regard to traditional construction, and can be designed to have the required bracing elements."]
[null,"Info Site Access","Site access is a very important aspect of any construction project. It is necessary to have a clear understanding of the site and the methods of delivery to and from as this can have influence on both cost and time overruns. We have broken this into three types of site:"]
[null,null,"• Urban locations typically require craneage to access sites, which is specific to the site and not assessed with this tool."]
[null,null,"• Suburban locations may have infrastructure and utility lines that restrict access, which are site specific and no assessed with this tool."]
[null,null,"• Rural locations are likely to have slope or vegetation restrictions, and potentially narrow difficult roads, which are site specific and not assessed with this tool."]
[null,null,"• Access restrictions: there is no access for HGV's or large mobile cranes due to low road bridges, long/windy/narrow driveways, or poor bearing surfaces.  This restricts access to small rigid HGV's with Hilabs, and LGVs."]
[null,null,"• Site restrictions: there is no ability to swing a load due to neighbouring buildings, infrastructure, vegetation, etc. Hence no craneage is possible."]
[null,"Summary"]
[null,"Your Earthquake Region","Your site is in a X risk earthquake zone."]
[null,"Your Exposure Zone","Your site is exposed to X levels of sea salt and other corrosive substances."]
[null,"Your Wind Region","Your site is in a region X."]
[null,"Sustainability Benefits of Prefab","Factory-control makes best use of materials and produces less waste."]
[null,null,"Reduced energy consumption compared to on-site construction."]
[null,null,"Reduced transport costs as site travelling is minimised."]
[null,null,"Minimal site disruption minimizes production times and long-term footprint."]
[null,null,"Because construction is done in a controlled environment the health and safety of workers can be closely monitored."]
[null,null,"Tool and material security as work is done in a secure facility."]
[null,null,"Reduced noise levels onsite. Neighbours do not have to ‘put up’ with construction noise."]
[null,"Your Site Access","Your site is situated in Xa location. Xb Xc"]
[null,"FAQ"]
[null,"FAQ Title A","What makes prefab so special?"]
[null,"FAQ Text A","Prefab is an agent for innovation and can offer higher-quality, more timely and cost-effective built solutions to clients. Unless you know about the range of available options, you won’t be able to benefit from them!"]
[null,"FAQ Title B","How exactly does prefab improve quality?"]
[null,"FAQ Text B1","By constructing parts (components, panels, modules or complete buildings) in a controlled environment, away from inclement weather, where worker and resource use can be closely monitored and enhanced."]
[null,"FAQ Text B2","“This type of construction method  allows for greater quality control, as faults can be identified early and easily managed and addressed placing more professionalism back into the industry” Collin Clench (Performance Assurance Manager, Hutt City Council)"]
[null,"FAQ Title C","How does prefab save time?"]
[null,"FAQ Text C","“By constructing parts off site (in a factory or yard) at the same time as on site construction takes place.”  Michelle Kaufmann (Prefab Green)"]
[null,"FAQ Title D","I thought prefab was meant to be cheaper - how does prefab save money?"]
[null,"FAQ Text D","Prefab is primarily a way to a higher quality built solution. It is possible to save money by repeating elements or details, reusing templates or jigs, and other efficiencies in a controlled environment. Also, cost savings can be achieved from a reduced timeframe and subsequent reduced borrowings."]
[null,"FAQ Title E","But isn’t prefab flimsy, temporary and mobile?"]
[null,"FAQ Text E","Not anymore! Past prefabs may have had one or all of these attributes but today the use of the computer for mass-customisation enables a variety of high-quality products to be designed, fabricated and constructed."]
[null,"FAQ Title F","Don’t all prefabs look the same – little boxes of ticky-tacky…?"]
[null,"FAQ Text F","Surprisingly, even cultures that appear to have more homogeneity than our own (such as Japan) claim that each prefab building is unique. As a general rule, the smaller the component, the greater the variation and computer-aided-design enables customisation by clients. We have moved from an era of ‘mass-standardisation’ in the mid-20th-century to an era of ‘mass-customisation’ today."]
[null,"FAQ Title G","What’s so great about joining PrefabNZ?"]
[null,"FAQ Text G","Lots of tangible stuff (web, e-news, database, events etc.) but also, you get to connect your business with other industry players to either buy or sell prefab or offsite systems, technologies and production capabilities from or to related product and service providers."]
[null,"FAQ Title H","How will joining PrefabNZ help develop my business?"]
[null,"FAQ Text H","Through awareness of current research and development initiatives and possible collaborations and joint ventures with like-minded, compatible businesses. Why re-invent the wheel…"]
[null,"FAQ Title I","When is the best time to consider prefab options?"]
[null,"FAQ Text I","Learn about prefab options NOW so you have them in your prefab tool-box. Consider prefab as EARLY in the design process as possible. Meet with specifiers, potential contractors and the client early in the design process to find out when the design needs to be frozen, for potential prefab benefits to be maximised."]
[null,"FAQ Title J","Why will prefab work now when it has failed in the past?"]
[null,"FAQ Text J","Today we have learnt from past mistakes and now understand that it takes more than great design – marketing and financial factors are crucial at start-up. We also have improved technologies (computer to machinery fabrication) and the market demand is there due to increased global prefab awareness since the early 2000s."]
[null,"FAQ Title K","How can prefab be a more sustainable construction option?"]
[null,"FAQ Text K","In a controlled environment it is possible to minimise material waste through careful use and re-use, and to achieve minimal construction tolerances to prevent energy loss (and reduce running costs)."]
[null,"FAQ Title L","What does BIM and inter-operability have to do with prefab?"]
[null,"FAQ Text L","Industry buzz-words BIM (building information management) and inter-operability are ways for the industry to collaborate during the design and construction process, by working off a shared digital model with components (or panels or modules) traceable from design to fabrication to installation. This process is more efficient and productive. Many see this as the way of the future."]

{"sheet":"tracking_sheet","index":10,"n_rows":47,"n_cols":33,"rows_kept":47,"cut":false,"hidden":true,"merged":[[9,7,9,11],[17,13,17,18],[24,13,24,18],[0,13,0,18],[6,13,7,18],[9,13,9,18],[15,13,15,18],[0,3,0,4],[8,2,8,3],[0,7,0,11],[1,25,1,28],[1,29,1,32],[0,20,0,32]]}
[null,null,null,"Prefab Recommendations",null,null,null,"Time of Construction",null,null,null,null,null,"Base Emission Levels (kg CO2·e)",null,null,null,null,null,null,"Total Greenhouse Gas Emmisions (tonnes of CO2)"]
[null,null,null,"Transportable",{"$f":"AND(NOT(AccessRestricted),FloorArea<=140,NoOfFloors<=1,Distance<=30,WindowWall<=30,ExternalWalls<=6,Foundation=1)","v":true},null,null,"Build Style","B (days)","TB=B·a·KT (days)","Non-Advised","Advised",null,"Type","Embodied","Waste","Transport","Construction","Total ('000)",null,"Build Style",null,null,null,null,"Non-Advised (days)",null,null,null,"Advised (days)"]
[null,null,null,"Modular/Hybrid",{"$f":"AND(NOT(SiteRestricted),FloorArea<=300,NoOfFloors<=2,Distance<=150,WindowWall<=35,ExternalWalls<=12,LowerFraming<3)","v":true},null,null,"Transportable",72,{"$f":"ROUND(I3*$F$45*$F$47,0)","v":45},{"$f":"IF(OptionComplete,0,J3)","v":0},{"$f":"IF(OptionComplete,J3,0)","v":45},null,"Traditional",5030,1500,420,410,{"$f":"SUM(O3:R3)/1000","v":7.36},null,null,{"$f":"O26","v":"Embodied"},{"$f":"P26","v":"Waste"},"Transport","Construction",{"$f":"V3","v":"Embodied"},{"$f":"W3","v":"Waste"},"Transport","Construction","Embodied","Waste","Transport","Construction"]
[null,null,null,"Panel (Closed)",{"$f":"AND(FloorArea<=300,NoOfFloors<=3,Distance<=200,WindowWall<=50,ExternalWalls<=20,LowerFraming<3)","v":true},null,null,"Hybrid/Modular",36,{"$f":"ROUND(I4*$F$45*$F$47,0)","v":23},{"$f":"IF(OptionModular,0,J4)","v":0},{"$f":"IF(OptionModular,J4,0)","v":23},null,"Transportable",5030,560,200,670,{"$f":"SUM(O4:R4)/1000","v":6.46},null,"Transportable",{"$f":"O28/1000","v":2.3916666666666666},{"$f":"P28/1000","v":0.46666666666666667},0.16792750000000001,0.55833333333333324,{"$f":"IF(OptionComplete,0,V4)","v":0},{"$f":"IF(OptionComplete,0,W4)","v":0},{"$f":"IF(OptionComplete,0,X4)","v":0},{"$f":"IF(OptionComplete,0,Y4)","v":0},{"$f":"IF(OptionComplete,V4,0)","v":2.3916666666666666},{"$f":"IF(OptionComplete,W4,0)","v":0.46666666666666667},{"$f":"IF(OptionComplete,X4,0)","v":0.16792750000000001},{"$f":"IF(OptionComplete,Y4,0)","v":0.55833333333333324}]
[null,null,null,"Panel (Open)",{"$f":"AND(FloorArea<=300,NoOfFloors<=3,Distance<=50,WindowWall<=50,ExternalWalls<=20,LowerFraming<3)","v":true},null,null,"Panelised",60,{"$f":"ROUND(I5*$F$45*$F$47,0)","v":38},{"$f":"IF(OR(OptionClosed,OptionOpen),0,J5)","v":0},{"$f":"IF(OR(OptionClosed,OptionOpen),J5,0)","v":38},null,"Panelised",5030,730,240,460,6.46,null,"Hybrid/Modular",{"$f":"O29/1000","v":2.3916666666666666},0.60833333333333328,0.19972916666666665,0.38333333333333336,{"$f":"IF(OptionModular,0,V5)","v":0},{"$f":"IF(OptionModular,0,W5)","v":0},{"$f":"IF(OptionModular,0,X5)","v":0},{"$f":"IF(OptionModular,0,Y5)","v":0},{"$f":"IF(OptionModular,V5,0)","v":2.3916666666666666},{"$f":"IF(OptionModular,W5,0)","v":0.60833333333333328},{"$f":"IF(OptionModular,X5,0)","v":0.19972916666666665},{"$f":"IF(OptionModular,Y5,0)","v":0.38333333333333336}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Hybrid/Modular",5030,580,200,660,6.47,null,"Panelised",2.3916666666666666,0.48333333333333334,0.16693749999999996,0.55000000000000004,{"$f":"IF(OR(OptionClosed,OptionOpen),0,V6)","v":0},{"$f":"IF(OR(OptionClosed,OptionOpen),0,W6)","v":0},{"$f":"IF(OR(OptionClosed,OptionOpen),0,X6)","v":0},{"$f":"IF(OR(OptionClosed,OptionOpen),0,Y6)","v":0},{"$f":"IF(OR(OptionClosed,OptionOpen),V6,0)","v":2.3916666666666666},{"$f":"IF(OR(OptionClosed,OptionOpen),W6,0)","v":0.48333333333333334},{"$f":"IF(OR(OptionClosed,OptionOpen),X6,0)","v":0.16693749999999996},{"$f":"IF(OR(OptionClosed,OptionOpen),Y6,0)","v":0.55000000000000004}]
[null,null,null,null,null,null,null,"Traditional",84,{"$f":"ROUND(I7*$F$45*$F$47,0)","v":53},0,{"$f":"J7","v":53},null,"120 m2 floor area, timber frame, timber foundation, fibre-cement cladding, steel long-run roof"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Traditional",{"$f":"O27/1000","v":2.3916666666666666},{"$f":"P27/1000","v":1.25},0.35107500000000003,0.34166666666666662,0,0,0,0,{"$f":"V8","v":2.3916666666666666},{"$f":"W8","v":1.25},0.35107500000000003,0.34166666666666662]
[null,null,"Construction Material Time Factor",null,"Ke","Ks"]
[null,null,"Subfloor framing",null,null,null,null,"Construction Material Embodied Emissions",null,null,null,null,null,"Base Emission Levels per House Size (kg CO2·e/m2)"]
[null,null,null,"Timber framing on piles",10,{"$f":"IF(Foundation=1,tracking_sheet!E11,\"\")","v":10},null,"Concrete slab on grade",null,null,51,{"$f":"IF(Foundation=2,K11,\"\")","v":""},null,"Type","Embodied","Waste","Transport","Construction","Total"]
[null,null,null,"Concrete slab on grade",30,{"$f":"IF(Foundation=2,tracking_sheet!E12,\"\")","v":""},null,"Steel Framing",null,null,20,{"$f":"IF(LowerFraming=2,K12,\"\")","v":""},null,"Traditional",{"$f":"O3/120","v":41.916666666666664},{"$f":"P3/120","v":12.5},3.5,3.4166666666666665,{"$f":"SUM(O12:R12)","v":61.333333333333329}]
[null,null,"Floor cladding",null,null,null,null,"Weatherboards",null,null,-18,{"$f":"IF(LowerCladding=1,K13,\"\")","v":-18},null,"Transportable",{"$f":"O4/120","v":41.916666666666664},4.666666666666667,1.6666666666666667,5.583333333333333,{"$f":"SUM(O13:R13)","v":53.833333333333329}]
[null,null,null,"Exposed/carpeted concrete",10,{"$f":"IF(FloorSurface=1,tracking_sheet!E14,\"\")","v":""},null,"Steel Cladding",null,null,4,{"$f":"IF(LowerCladding=6,K14,\"\")","v":""},null,"Panelised",41.916666666666664,6.083333333333333,2,3.8333333333333335,53.833333333333336]
[null,null,null,"Timber floor boards",20,{"$f":"IF(FloorSurface=2,tracking_sheet!E15,\"\")","v":20},null,"Concrete Tile Roof",null,null,-4.5999999999999996,{"$f":"IF(RoofCladding=3,K15,\"\")","v":""},null,"Hybrid/Modular",41.916666666666664,4.833333333333333,1.6666666666666667,5.5,53.916666666666664]
[null,null,null,"Sheet flooring",10,{"$f":"IF(FloorSurface=3,tracking_sheet!E16,\"\")","v":""},null,null,null,null,"Total Change",{"$f":"SUM(L11:L15)","v":-18},null,"Timber frame, timber foundation, fibre-cement cladding, steel long-run roof"]
[null,null,"Lower wall framing"]
[null,null,null,"Timber",20,{"$f":"IF(LowerFraming=1,tracking_sheet!E18,\"\")","v":20},null,null,null,null,null,null,null,"Final Emission Levels per House Size (kg CO2·e/m2)"]
[null,null,null,"Steel",10,{"$f":"IF(LowerFraming=2,tracking_sheet!E19,\"\")","v":""},null,null,null,null,null,null,null,"Type","Embodied","Waste","Transport","Construction","Total"]
[null,null,null,"Masonry",20,{"$f":"IF(LowerFraming=3,tracking_sheet!E20,\"\")","v":""},null,null,null,"Transport Factor","120 m²","kg CO2·e/m²",null,"Traditional",{"$f":"O12+$L$16","v":23.916666666666664},{"$f":"P12","v":12.5},{"$f":"L21","v":3.5107500000000007},3.4166666666666665,{"$f":"SUM(O20:R20)","v":43.34408333333333}]
[null,null,"Lower wall cladding",null,null,null,null,null,null,"Traditional",{"$f":"140.43*MAX(Distance,30)/10","v":421.29000000000008},{"$f":"K21/120","v":3.5107500000000007},null,"Transportable",{"$f":"O13+$L$16","v":23.916666666666664},{"$f":"P13","v":4.666666666666667},{"$f":"L22","v":1.6792750000000001},5.583333333333333,{"$f":"SUM(O21:R21)","v":35.845941666666668}]
[null,null,null,"Weatherboards",20,{"$f":"IF(LowerCladding=1,tracking_sheet!E22,\"\")","v":20},null,null,null,"Transportable",{"$f":"14.091*MAX(Distance,30)/10+159.24","v":201.51300000000001},{"$f":"K22/120","v":1.6792750000000001},null,"Panelised",{"$f":"O14+$L$16","v":23.916666666666664},6.083333333333333,1.9972916666666667,3.8333333333333335,35.830624999999998]
[null,null,null,"Fibrecement/Plywood",10,{"$f":"IF(LowerCladding=2,tracking_sheet!E23,\"\")","v":""},null,null,null,"Panelised",{"$f":"63.427*MAX(Distance,30)/10+49.394","v":239.67500000000001},1.9972916666666667,null,"Hybrid/Modular",{"$f":"O15+$L$16","v":23.916666666666664},4.833333333333333,1.6693749999999998,5.5,35.919374999999995]
[null,null,null,"Brick Veneer",20,{"$f":"IF(LowerCladding=3,tracking_sheet!E24,\"\")","v":""},null,null,null,"Hybrid/Modular",{"$f":"46.573*MAX(Distance,30)/10+60.606","v":200.32499999999999},1.6693749999999998,null,"Timber frame, timber foundation, fibre-cement cladding, steel long-run roof"]
[null,null,null,"Stucco/Plaster",20,{"$f":"IF(LowerCladding=4,tracking_sheet!E25,\"\")","v":""},null,null,null,null,null,null,null,"Final Emission Levels (kg CO2·e)"]
[null,null,null,"Steel",10,{"$f":"IF(LowerCladding=5,tracking_sheet!E26,\"\")","v":""},null,null,null,null,null,null,null,"Type","Embodied","Waste","Transport","Construction","Total ('000)"]
[null,null,"Upper wall framing",null,null,null,null,null,null,null,null,null,null,"Traditional",{"$f":"O20*FloorArea","v":2391.6666666666665},1250,351.07500000000005,341.66666666666663,{"$f":"SUM(O27:R27)/1000","v":4.3344083333333341}]
[null,null,null,"Timber",20,{"$f":"IF(UpperFraming=2,tracking_sheet!E28,\"\")","v":""},null,null,null,null,null,null,null,"Transportable",2391.6666666666665,466.66666666666669,167.92750000000001,558.33333333333326,{"$f":"SUM(O28:R28)/1000","v":3.5845941666666659}]
[null,null,null,"Steel ",10,{"$f":"IF(UpperFraming=3,tracking_sheet!E29,\"\")","v":""},null,null,null,null,null,null,null,"Panelised",2391.6666666666665,608.33333333333326,199.72916666666666,383.33333333333337,3.5830625]
[null,null,null,"Masonry",20,{"$f":"IF(UpperFraming=4,tracking_sheet!E30,\"\")","v":""},null,null,null,null,null,null,null,"Hybrid/Modular",2391.6666666666665,483.33333333333331,166.93749999999997,550,3.5919374999999998]
[null,null,"Upper wall cladding"]
[null,null,null,"Weatherboards",20,{"$f":"IF(UpperCladding=2,tracking_sheet!E32,\"\")","v":""}]
[null,null,null,"Fibrecement/Plywood",10,{"$f":"IF(UpperCladding=3,tracking_sheet!E33,\"\")","v":""}]
[null,null,null,"Brick Veneer",20,{"$f":"IF(UpperCladding=4,tracking_sheet!E34,\"\")","v":""}]
[null,null,null,"Stucco/Plaster",20,{"$f":"IF(UpperCladding=5,tracking_sheet!E35,\"\")","v":""}]
[null,null,null,"Steel",10,{"$f":"IF(UpperCladding=6,tracking_sheet!E36,\"\")","v":""}]
[null,null,"Roof Framing"]
[null,null,null,"Roof Trusses",20,{"$f":"IF(RoofFraming=1,tracking_sheet!E38,\"\")","v":20}]
[null,null,null,"Skillion Trusses",10,{"$f":"IF(RoofFraming=2,tracking_sheet!E39,\"\")","v":""}]
[null,null,"Roof cladding"]
[null,null,null,"Profiled aluminum/zinc coated steel",10,{"$f":"IF(RoofCladding=1,tracking_sheet!E41,\"\")","v":10}]
[null,null,null,"Asphault shingles",10,{"$f":"IF(RoofCladding=2,tracking_sheet!E42,\"\")","v":""}]
[null,null,null,"Concrete/clay tiles",15,{"$f":"IF(RoofCladding=3,tracking_sheet!E43,\"\")","v":""}]
[null,null,null,null,"KT",{"$f":"SUM(F11:F43)","v":100}]
[null,null,null,null,"KF=KT/80",{"$f":"F44/80","v":1.25}]
[]
[null,null,null,null,"a = Floor Area/200",{"$f":"FloorArea/200","v":0.5}]

{"sheet":"data_sheet","index":11,"n_rows":37,"n_cols":17,"rows_kept":37,"cut":false,"hidden":true,"merged":[[13,13,17,13],[13,12,17,12],[24,13,29,13],[24,12,29,12],[0,9,0,13],[1,12,1,13],[31,12,32,12],[31,9,32,9],[15,3,17,3],[24,9,29,9],[13,9,17,9],[0,6,0,7],[7,0,9,0],[7,3,9,3],[7,4,9,4],[15,4,17,4],[15,0,17,0],[11,0,13,0],[0,0,0,4],[1,3,1,4],[11,4,13,4],[11,3,13,3],[2,3,5,3],[2,0,5,0],[2,4,5,4],[34,9,36,9],[34,13,36,13],[34,12,36,12],[31,13,32,13],[2,9,3,9],[2,12,3,12],[2,13,3,13],[5,9,7,9],[5,12,7,12],[5,13,7,13],[9,9,11,9],[9,12,11,12],[9,13,11,13],[19,9,22,9],[19,13,22,13],[19,12,22,12]]}
["Site",null,null,null,null,null,"Numeric",null,null,"Construction"]
["Factor","Opt","Range","Selection",null,null,"Factor","Selection",null,"Factor","Opt","Range","Selection"]
["Earthquake Region",1,"Zone 1",1,{"$f":"VLOOKUP(D3,B3:C6,2,FALSE)","v":"Zone 1"},null,"Access Restrictions",false,null,"Foundations",1,"Timber Subfloor on Piles",1,{"$f":"VLOOKUP(M3,K3:L4,2,FALSE)","v":"Timber Subfloor on Piles"}]
[null,2,"Zone 2",null,null,null,"Site Restrictions",false,null,null,2,"Concrete Slab on Grade"]
[null,3,"Zone 3",null,null,null,"Distance from Town",30]
[null,4,"Zone 4",null,null,null,"No. of Floors",1,null,"Floor Surface",1,"Exposed/Covered Concrete",2,{"$f":"VLOOKUP(M6,K6:L8,2,FALSE)","v":"Timber Floor Boards"}]
[null,null,null,null,null,null,"Floor Area",100,null,null,2,"Timber Floor Boards"]
["Exposure Zone",1,"B",1,{"$f":"VLOOKUP(D8,B8:C10,2,FALSE)","v":"B"},null,"External Walls",4,null,null,3,"Sheet"]
[null,2,"C",null,null,null,"Window/Wall",25,null,null,null,null,null,null,null,null,"²"]
[null,3,"D",null,null,null,null,null,null,"Lower Wall Framing",1,"Timber",1,{"$f":"VLOOKUP(M10,K10:L12,2,FALSE)","v":"Timber"}]
[null,null,null,null,null,null,null,null,null,null,2,"Steel"]
["Wind Regions",1,"A",1,{"$f":"VLOOKUP(D12,B12:C14,2,FALSE)","v":"A"},null,"With Units",null,null,null,3,"Masonry"]
[null,2,"W",null,null,null,"Floor Area",{"$f":"FloorArea&\" m²\"","v":"100 m²"}]
[null,3,"Lee Zone",null,null,null,"Window/Wall",{"$f":"WindowWall&\" %\"","v":"25 %"},null,"Lower Wall Cladding",1,"Weatherboards",1,{"$f":"VLOOKUP(M14,K14:L18,2,FALSE)","v":"Weatherboards"}]
[null,null,null,null,null,null,"Distance",{"$f":"Distance&\" km\"","v":"30 km"},null,null,2,"Fibrecement/Plywood"]
["Site Access",1,"Urban",2,{"$f":"VLOOKUP(D16,B16:C18,2,FALSE)","v":"Suburban"},null,null,null,null,null,3,"Brick Veneer (Built Onsite)"]
[null,2,"Suburban",null,null,null,null,null,null,null,4,"Plaster/Stucco (Built Onsite)"]
[null,3,"Rural",null,null,null,null,null,null,null,5,"Steel"]
[]
[null,null,null,null,null,null,null,null,null,"Upper Wall Framing",1,"Not Applicable",1,{"$f":"VLOOKUP(M20,K20:L23,2,FALSE)","v":"Not Applicable"}]
[null,null,null,null,null,null,null,null,null,null,2,"Timber"]
[null,null,null,null,null,null,null,null,null,null,3,"Steel"]
[null,null,null,null,null,null,null,null,null,null,4,"Masonry"]
[]
[null,null,null,null,null,null,null,null,null,"Upper Wall Cladding",1,"Not Applicable",1,{"$f":"VLOOKUP(M25,K25:L30,2,FALSE)","v":"Not Applicable"}]
[null,null,null,null,null,null,null,null,null,null,2,"Weatherboards"]
[null,null,null,null,null,null,null,null,null,null,3,"Fibrecement/Plywood"]
[null,null,null,null,null,null,null,null,null,null,4,"Brick Veneer (Built Onsite)"]
[null,null,null,null,null,null,null,null,null,null,5,"Plaster/Stucco (Built Onsite)"]
[null,null,null,null,null,null,null,null,null,null,6,"Steel"]
[]
[null,null,null,null,null,null,null,null,null,"Roof Framing",1,"Roof Trusses",1,{"$f":"VLOOKUP(M32,K32:L33,2,FALSE)","v":"Roof Trusses"}]
[null,null,null,null,null,null,null,null,null,null,2,"Skillion"]
[]
[null,null,null,null,null,null,null,null,null,"Roof Cladding",1,"Long Run Metal",1,{"$f":"VLOOKUP(M35,K35:L37,2,FALSE)","v":"Long Run Metal"}]
[null,null,null,null,null,null,null,null,null,null,2,"Metal Tiles"]
[null,null,null,null,null,null,null,null,null,null,3,"Concrete/Clay Tiles"]

{"sheet":"print_sheet","index":12,"n_rows":128,"n_cols":31,"rows_kept":128,"cut":false,"hidden":true,"merged":[[114,2,115,37],[116,2,117,37],[118,2,119,37],[120,2,121,37],[103,2,107,37],[109,2,109,37],[110,2,112,37],[113,2,113,37],[95,2,95,37],[96,2,100,37],[102,2,102,37],[84,2,84,37],[86,2,86,37],[88,2,88,37],[72,2,72,37],[74,2,74,37],[76,2,76,37],[78,2,78,37],[89,2,93,37],[80,2,80,37],[82,2,82,37],[1,30,1,36],[2,30,2,36],[17,2,17,37],[14,22,14,28],[10,2,10,8],[11,2,11,8],[12,2,12,8],[11,30,11,37],[15,10,15,12],[14,10,14,12],[13,22,13,28],[12,13,12,18],[12,20,12,21],[12,30,12,37],[14,30,14,37],[0,13,3,28],[52,2,52,37],[20,2,23,37],[19,2,19,37],[25,2,25,37],[30,2,30,37],[31,2,33,37],[26,2,28,37],[35,2,35,37],[13,30,13,37],[9,30,9,37],[14,2,14,8],[15,2,15,8],[9,2,9,8],[8,13,8,18],[8,20,8,21],[9,20,9,21],[10,20,10,21],[11,20,11,21],[8,22,8,28],[9,22,9,28],[10,22,10,28],[11,22,11,28],[12,22,12,28],[4,15,4,26],[126,2,126,36],[127,2,131,36],[6,2,6,37],[13,10,13,12],[9,13,9,18],[10,13,10,18],[11,13,11,18],[8,2,8,8],[13,2,13,8],[12,10,12,12],[11,10,11,12],[10,10,10,12],[9,10,9,12],[10,30,10,37],[70,2,70,37]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Prefab Toolkit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Report Produced:"]
[null,null,null,null,null,null,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":"TODAY()","v":"2013-05-27"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version 2"]
[]
[null,null,"Data Provided"]
[]
[null,null,"Site",null,null,null,null,null,null,null,null,null,null,"Structure",null,null,null,null,null,null,null,null,"Construction"]
[null,null,"Site Access",null,null,null,null,null,null,null,{"$f":"data_sheet!$E$16","v":"Suburban"},null,null,"No. of Floors",null,null,null,null,null,null,{"$f":"NoOfFloors","v":1},null,"Foundations",null,null,null,null,null,null,null,{"$f":"data_sheet!$N$3","v":"Timber Subfloor on Piles"}]
[null,null,"Access Restrictions",null,null,null,null,null,null,null,{"$f":"IF(data_sheet!$H$3=TRUE,\"Yes\",\"No\")","v":"No"},null,null,"Floor Area (m²)",null,null,null,null,null,null,{"$f":"FloorArea","v":100},null,"Lower Wall Framing",null,null,null,null,null,null,null,{"$f":"data_sheet!$N$10","v":"Timber"}]
[null,null,"Site Restrictions",null,null,null,null,null,null,null,{"$f":"IF(data_sheet!$H$4=TRUE,\"Yes\",\"No\")","v":"No"},null,null,"External Walls",null,null,null,null,null,null,{"$f":"ExternalWalls","v":4},null,"Lower Wall Cladding",null,null,null,null,null,null,null,{"$f":"data_sheet!$N$14","v":"Weatherboards"}]
[null,null,"Distance from Town",null,null,null,null,null,null,null,{"$f":"Distance","v":30},null,null,"Window:Wall (%)",null,null,null,null,null,null,{"$f":"WindowWall","v":25},null,"Upper Wall Framing",null,null,null,null,null,null,null,{"$f":"data_sheet!$N$20","v":"Not Applicable"}]
[null,null,"EQ Region",null,null,null,null,null,null,null,{"$f":"data_sheet!$E$3","v":"Zone 1"},null,null,null,null,null,null,null,null,null,null,null,"Upper Wall Cladding",null,null,null,null,null,null,null,{"$f":"data_sheet!$N$25","v":"Not Applicable"}]
[null,null,"Exposure Zone",null,null,null,null,null,null,null,{"$f":"data_sheet!$E$8","v":"B"},null,null,null,null,null,null,null,null,null,null,null,"Roof Cladding",null,null,null,null,null,null,null,{"$f":"data_sheet!$N$35","v":"Long Run Metal"}]
[null,null,"Wind Regions",null,null,null,null,null,null,null,{"$f":"data_sheet!$E$12","v":"A"}]
[]
[null,null,"Recommendations"]
[]
[null,null,{"$f":"\"Recommended: \"&IF(OptionComplete,\"Transportable\",IF(OptionModular,\"Hybrid/Modular\",IF(OptionOpen,\"Open Panelised\",IF(OptionClosed,\"Closed Panelised\",\"Prefabrication is Inappropriate\"))))","v":"Recommended: Transportable"}]
[null,null,{"$f":"IF(OptionComplete,TcompleteIsBest,IF(OptionModular,TmodularIsBest,IF(OptionOpen,TopenIsBest,IF(OptionClosed,TclosedIsBest,TnoRecommend))))","v":"Based on the information supplied, the best prefabrication method to use would be the transportable building option. Transportable buildings are commonly known as portable, relocatable, or offsite-built dwellings in New Zealand. Transportable buildings are constructed in a factory or yard and then moved to site where they are attached to permanent foundations."}]
[]
[]
[]
[]
[null,null,{"$f":"IF(AND(OptionComplete,OptionModular),\"Alternatively: Hybrid/Modular\",IF(OR(OptionComplete,OptionModular),IF(OptionOpen,\"Alternatively: Open or Closed Panelised\",IF(OptionClosed,\"Alternatively: Closed Panelised\")),\"\"))","v":"Alternatively: Hybrid/Modular"}]
[null,null,{"$f":"IF(AND(OptionComplete,OptionModular),TmodularAlternative,IF(OR(OptionComplete,OptionModular),IF(OptionOpen,TopenClosedAlternative,IF(OptionClosed,TclosedAlternative)),\"\"))","v":"An alternative prefabrication method for your circumstances is hybrid/modular. Modular, sectional, or volumetric prefabrication refer to three-dimensional structural units which are combined at site with other units or systems. Cores and pods are non-structural units used inside conventional buildings or modules.  "}]
[]
[]
[]
[null,null,{"$f":"IF(AND(OptionComplete,OptionModular,OptionClosed),\"Alternatively: Open or ClosedPanelised\",\"\")","v":"Alternatively: Open or ClosedPanelised"}]
[null,null,{"$f":"IF(AND(OptionComplete,OptionModular,OptionClosed),TopenClosedAlternative,\"\")","v":"An alternative prefabrication method for your circumstances is closed or open panelised. Panelised or non-volumetric prefabrication is made of manufactured panel elements that can be classified as open  or closed: Open refers to framing elements, whereas closed panels incorporate services with windows and doors, exterior cladding and interior lining. "}]
[]
[]
[]
[null,null,"Prefabrication is faster than traditional construction."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Prefabrication results in less greenhouse gas emissions."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"*Carbon dioxide emissions in tonnes"]
[]
[null,null,"Sustainability Benefits of Prefabrication"]
[]
[null,null,"Factory-control makes best use of materials and produces less waste."]
[]
[null,null,"Reduced energy consumption compared to on-site construction."]
[]
[null,null,"Reduced transport costs as site travelling is minimised."]
[]
[null,null,"Minimal site disruption minimizes production times and long-term footprint."]
[]
[null,null,"Because construction is done in a controlled environment the health and safety of workers can be closely monitored."]
[]
[null,null,"Tool and material security as work is done in a secure facility."]
[]
[null,null,"Reduced noise levels onsite. Neighbours do not have to ‘put up’ with construction noise."]
[]
[null,null,"Issues to Consider"]
[]
[null,null,{"$f":"SUBSTITUTE(TyourEQ,\"X\",IF(data_sheet!D3>=3,\"high\",IF(data_sheet!D3>=2,\"moderate\",\"low\")))","v":"Your site is in a low risk earthquake zone."}]
[null,null,{"$f":"text_sheet!C27","v":"Wind and earthquake forces exert horizontal forces on buildings. Bracing design involves the determination of both the extent of these forces, called the bracing demand, and also the determination of the capacity of the building and its elements to resist these forces, called bracing capacity (NZS 3604:2011).  The earthquake bracing demand on the building structure shall be assessed on the basis of the building location (ie earthquake zone) amongst other things. Prefabricated buildings can be made as strong as necessary to provide the bracing required."}]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUBSTITUTE(TyourExposure,\"X\",IF(data_sheet!D8>=3,\"high\",IF(data_sheet!D10>=2,\"moderate\",\"low\")))","v":"Your site is exposed to low levels of sea salt and other corrosive substances."}]
[null,null,{"$f":"text_sheet!C28","v":"All buildings in New Zealand are classified into exposure zones.  The zoning reflects site exposure to sea spray or geothermal areas and will determine the materials that can be used. For example, metal claddings and fastenings will rust more quickly than stainless steel fastenings when exposed to sea spray.  The site zone will affect guarantees manufacturers offer on their products. Prefabrication is no different in this regard to traditional construction and can be used in corrosion zones, with choices about materials used determining the durability at the structure."}]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUBSTITUTE(TyourWind,\"X\",IF(data_sheet!D12>=3,\"exposed to lee winds\",IF(data_sheet!D17>=2,\"subject to strong winds\",\"not subject to strong winds\")))","v":"Your site is in a region not subject to strong winds."}]
[null,null,{"$f":"text_sheet!C29","v":"Buildings are required to withstand lateral loads applied by wind. The amount of bracing required to resist the lateral loads on the building is based on the design wind speed. NZS 3604 divides New Zealand into two wind regions (A and W) and several lee zone areas-these are areas where the landforms create localized wind acceleration resulting in higher wind speeds than the rest of the region. Prefabrication is no different in this regard to traditional construction, and can be designed to have the required bracing elements."}]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TyourSiteAccess,\"Xa\",IF(SiteAccess=1,\"an urban\",IF(SiteAccess=2,\"a suburban\",\"a rural\"))),\"Xb\",IF(AccessRestricted,\" Access to your site is restricted. \",\"\")),\"Xc\",IF(SiteRestricted,\" There are obstructions around your site.\",\"\"))","v":"Your site is situated in a suburban location.  "}]
[null,null,{"$f":"TinfoSiteAccessA","v":"Site access is a very important aspect of any construction project. It is necessary to have a clear understanding of the site and the methods of delivery to and from as this can have influence on both cost and time overruns. We have broken this into three types of site:"}]
[]
[]
[null,null,{"$f":"TinfoSiteAccessB","v":"• Urban locations typically require craneage to access sites, which is specific to the site and not assessed with this tool."}]
[null,null,{"$f":"TinfoSiteAccessC","v":"• Suburban locations may have infrastructure and utility lines that restrict access, which are site specific and no assessed with this tool."}]
[]
[null,null,{"$f":"TinfoSiteAccessD","v":"• Rural locations are likely to have slope or vegetation restrictions, and potentially narrow difficult roads, which are site specific and not assessed with this tool."}]
[]
[null,null,{"$f":"TinfoSiteAccessE","v":"• Access restrictions: there is no access for HGV's or large mobile cranes due to low road bridges, long/windy/narrow driveways, or poor bearing surfaces.  This restricts access to small rigid HGV's with Hilabs, and LGVs."}]
[]
[null,null,{"$f":"TinfoSiteAccessF","v":"• Site restrictions: there is no ability to swing a load due to neighbouring buildings, infrastructure, vegetation, etc. Hence no craneage is possible."}]
[]
[]
[]
[]
[]
[null,null,"Disclaimer"]
[null,null,{"$f":"Tabout4","v":"PrefabNZ Incorporated can not be held responsible for the reliability of the Prefab Toolkit results. The results are limited by the quality of case study data which has been supplied confidentially by other parties. The Prefab Toolkit will be updated over time with future versions of increasing accuracy. The purpose of the Prefab Toolkit is as a 'conversation starter' to enable projects to consider prefabrication as an alternative to traditional construction methods. Any feedback about the Prefab Toolkit can be directed to info@prefabnz.com"}]