{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Water calculator","Front end","calculation","lookup tables","Output","Assumptions","Data extract","Sheet2","Activity database from wat 01","logic tree","Sheet1"],"not_rendered":{"charts":1,"images":4,"macros":1,"external_links":0,"defined_names":6,"comments":5,"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":"Water calculator","index":0,"n_rows":333,"n_cols":5,"rows_kept":333,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Versie:","Datum:",null,"Wijzigingen:"]
["1.1 ","07-03-2025",null,"Eerste versie"]
["1.2","2025-03-19",null,"Output-blad aangepast: verbeterpercentage, EP en ingevulde waarden zichtbaar, velden toegevoegd om projectinformatie in te vullen, blad als pdf op te slaan/printen"]
["1.3","2025-05-21",null,"Output-blad aangepast: Aantal gebouwgebruikers toegevoegd en berekening 'detailed approach' gecorrigeerd."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"No"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"No"]

{"sheet":"Front end","index":1,"n_rows":360,"n_cols":8,"rows_kept":360,"cut":false,"hidden":true,"merged":[]}
[null,null,"Mandatory data entry","Mandatory data entry - predicted water use"]
[null,null,"Conditonal data entry"]
[null,null,"Optional data entry"]
[]
[]
["Heading","Question ID","Conditional criteria","Question","Answers","Data entry permitted",null,"warning"]
["Building details"]
["Building type",1,"Mandatory","What is the building type?",null,"Selected from building type lookup table"]
["Floor area",2,"Mandatory","What is the building floor area in m2",null,"Enter a positive number >=0 to 2dps"]
["Number of occupants",3,"Mandatory - Predicted water use","What is the estimated number of occupants (during occupied hours)",null,"Enter a positive number >=0 to 2dps"]
["Number of occupied days per year",4,"Mandatory - Predicted water use","What is the number of days the building is occupied",null,"Enter a positive number >=0 to 2dps"]
["Unregulated water uses"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Water compenents present (Regulated)"]
["Water compenents present",5,"Mandatory",{"$f":"CONCATENATE(\"Are there any \",+'lookup tables'!C35,\"'s present?\")","v":"Are there any WC''s present?"},null,"Select yes or no"]
["Water compenents present",6,"Mandatory",{"$f":"CONCATENATE(\"Are there any \",+'lookup tables'!C36,\"'s present?\")","v":"Are there any Urinal with timed flush's present?"},null,"Select yes or no"]
["Water compenents present",7,"Mandatory","Do any the urinals have a timed flush",null,"Select yes or no",null,"WORDT OVERGESLAGEN"]
["Water compenents present",8,"Mandatory","Do any the urinals have a sensor controlled flush",null,"Select yes or no"]
["Water compenents present",9,"Mandatory","Are any of the urinals waterless",null,"Select yes or no"]
["Water compenents present",10,"Mandatory",{"$f":"CONCATENATE(\"Are there any \",+'lookup tables'!C39,\"'s present?\")","v":"Are there any Wash hand basin tap's present?"},null,"Select yes or no"]
["Water compenents present",11,"Mandatory",{"$f":"CONCATENATE(\"Are there any \",+'lookup tables'!C40,\"'s present?\")","v":"Are there any Shower's present?"},null,"Select yes or no"]
["Water compenents present",12,"Mandatory",{"$f":"CONCATENATE(\"Are there any \",+'lookup tables'!C41,\"'s present?\")","v":"Are there any Bath's present?"},null,"Select yes or no"]
["Water compenents present",13,"Mandatory",{"$f":"CONCATENATE(\"Are there any \",+'lookup tables'!C42,\"'s present?\")","v":"Are there any Kitchen taps: kitchenette's present?"},null,"Select yes or no"]
["Water compenents present",14,"Mandatory",{"$f":"CONCATENATE(\"Are there any \",+'lookup tables'!C43,\"'s present?\")","v":"Are there any Domestic sized washing machines's present?"},null,"Select yes or no"]
["Water compenents present",15,"Mandatory",{"$f":"CONCATENATE(\"Are there any \",+'lookup tables'!C44,\"'s present?\")","v":"Are there any Domestic sized dishwashers's present?"},null,"Select yes or no"]
["Water compenents present",16,"only display question if commercial scale food preparation area is selected",{"$f":"CONCATENATE(\"Are there any \",+'lookup tables'!C45,\"'s present?\")","v":"Are there any Kitchen taps: restaurant (pre-rinse nozzles only)'s present?"},null,"Select yes or no"]
["Water compenents present",17,"only display question if commercial scale food preparation area is selected",{"$f":"CONCATENATE(\"Are there any \",+'lookup tables'!C46,\"'s present?\")","v":"Are there any Waste disposal unit (commercial kitchens only)'s present?"},null,"Select yes or no"]
["Water compenents present",18,"only display question if commercial scale food preparation area is selected",{"$f":"CONCATENATE(\"Are there any \",+'lookup tables'!C47,\"'s present?\")","v":"Are there any Commercial sized dishwashers's present?"},null,"Select yes or no"]
["Water compenents present",19,"only display question if answer to commercial scale washing machines are selected",{"$f":"CONCATENATE(\"Are there any \",+'lookup tables'!C48,\"'s present?\")","v":"Are there any Commercial or industrial sized washing machines's present?"},null,"Select yes or no"]
["Checkpoint",null,"All previous questions need to be answered before proceeding to then next question "," if check point condition is not met display \"Please complete questions above to proceed\""]
["Checkpoint",null,"If the answer to all water consumption present questions is no - fiilter out credits - otherwise proceed to water component types question"]
["Number of water component types"]
["Number of water component types",16,{"$f":"CONCATENATE(\"Only display if the answer to Are \",+'lookup tables'!C35,\"s present? Is Yes\")","v":"Only display if the answer to Are WC's present? Is Yes"},{"$f":"CONCATENATE(\"How many different types of \",+'lookup tables'!C35,\"s are installed?\")","v":"How many different types of WC's are installed?"},null,"Enter whole number between 1 and 8"]
["Number of water component types",17,{"$f":"CONCATENATE(\"Only display if the answer to Are \",+'lookup tables'!C36,\" present? Is Yes\")","v":"Only display if the answer to Are Urinal with timed flush present? Is Yes"},{"$f":"CONCATENATE(\"How many different types of \",+'lookup tables'!C36,\"s are installed?\")","v":"How many different types of Urinal with timed flushs are installed?"},null,"Enter whole number between 1 and 8"]
["Number of water component types",18,{"$f":"CONCATENATE(\"Only display if the answer to Are \",+'lookup tables'!C37,\" present? Is Yes\")","v":"Only display if the answer to Are Urinal with automatic sensor flush present? Is Yes"},{"$f":"CONCATENATE(\"How many different types of \",+'lookup tables'!C37,\"s are installed?\")","v":"How many different types of Urinal with automatic sensor flushs are installed?"},null,"Enter whole number between 1 and 8"]
["Number of water component types",19,{"$f":"CONCATENATE(\"Only display if the answer to Are \",+'lookup tables'!C39,\"s present? Is Yes\")","v":"Only display if the answer to Are Wash hand basin taps present? Is Yes"},{"$f":"CONCATENATE(\"How many different types of \",+'lookup tables'!C39,\"s are installed?\")","v":"How many different types of Wash hand basin taps are installed?"},null,"Enter whole number between 1 and 8"]
["Number of water component types",20,{"$f":"CONCATENATE(\"Only display if the answer to Are \",+'lookup tables'!C40,\"s present? Is Yes\")","v":"Only display if the answer to Are Showers present? Is Yes"},{"$f":"CONCATENATE(\"How many different types of \",+'lookup tables'!C40,\"s are installed?\")","v":"How many different types of Showers are installed?"},null,"Enter whole number between 1 and 8"]
["Number of water component types",21,{"$f":"CONCATENATE(\"Only display if the answer to Are \",+'lookup tables'!C41,\"s present? Is Yes\")","v":"Only display if the answer to Are Baths present? Is Yes"},{"$f":"CONCATENATE(\"How many different types of \",+'lookup tables'!C41,\"s are installed?\")","v":"How many different types of Baths are installed?"},null,"Enter whole number between 1 and 8"]
["Number of water component types",22,{"$f":"CONCATENATE(\"Only display if the answer to Are \",+'lookup tables'!C42,\" present? Is Yes\")","v":"Only display if the answer to Are Kitchen taps: kitchenette present? Is Yes"},{"$f":"CONCATENATE(\"How many different types of \",+'lookup tables'!C42,\" are installed?\")","v":"How many different types of Kitchen taps: kitchenette are installed?"},null,"Enter whole number between 1 and 8"]
["Number of water component types",23,{"$f":"CONCATENATE(\"Only display if the answer to Are \",+'lookup tables'!C43,\"s present? Is Yes\")","v":"Only display if the answer to Are Domestic sized washing machiness present? Is Yes"},{"$f":"CONCATENATE(\"How many different types of \",+'lookup tables'!C43,\" are installed?\")","v":"How many different types of Domestic sized washing machines are installed?"},null,"Enter whole number between 1 and 8"]
["Number of water component types",24,{"$f":"CONCATENATE(\"Only display if the answer to Are \",+'lookup tables'!C44,\" present? Is Yes\")","v":"Only display if the answer to Are Domestic sized dishwashers present? Is Yes"},{"$f":"CONCATENATE(\"How many different types of \",+'lookup tables'!C44,\" are installed?\")","v":"How many different types of Domestic sized dishwashers are installed?"},null,"Enter whole number between 1 and 8"]
["Number of water component types",25,{"$f":"CONCATENATE(\"Only display if the answer to Are \",+'lookup tables'!C45,\" present? Is Yes\")","v":"Only display if the answer to Are Kitchen taps: restaurant (pre-rinse nozzles only) present? Is Yes"},{"$f":"CONCATENATE(\"How many different types of \",+'lookup tables'!C45,\" are installed?\")","v":"How many different types of Kitchen taps: restaurant (pre-rinse nozzles only) are installed?"},null,"Enter whole number between 1 and 8"]
["Number of water component types",26,{"$f":"CONCATENATE(\"Only display if the answer to Are \",+'lookup tables'!C46,\" present? Is Yes\")","v":"Only display if the answer to Are Waste disposal unit (commercial kitchens only) present? Is Yes"},{"$f":"CONCATENATE(\"How many different types of \",+'lookup tables'!C46,\" are installed?\")","v":"How many different types of Waste disposal unit (commercial kitchens only) are installed?"},null,"Enter whole number between 1 and 8"]
["Number of water component types",27,{"$f":"CONCATENATE(\"Only display if the answer to Are \",+'lookup tables'!C47,\" present? Is Yes\")","v":"Only display if the answer to Are Commercial sized dishwashers present? Is Yes"},{"$f":"CONCATENATE(\"How many different types of \",+'lookup tables'!C47,\" are installed?\")","v":"How many different types of Commercial sized dishwashers are installed?"},null,"Enter whole number between 1 and 8"]
["Number of water component types",28,{"$f":"CONCATENATE(\"Only display if the answer to Are \",+'lookup tables'!C48,\" present? Is Yes\")","v":"Only display if the answer to Are Commercial or industrial sized washing machines present? Is Yes"},{"$f":"CONCATENATE(\"How many different types of \",+'lookup tables'!C48,\" are installed?\")","v":"How many different types of Commercial or industrial sized washing machines are installed?"},null,"Enter whole number between 1 and 8"]
["Components details"]
["Component details WCs"]
["Component details WCs",29,{"$f":"CONCATENATE(\"Only display if the answer to \",D$57, \"is >=1\")","v":"Only display if the answer to How many different types of WC's are installed?is >=1"},{"$f":"CONCATENATE(\"Enter number of Type 1 \",+'lookup tables'!C$35,\"s installed\")","v":"Enter number of Type 1 WC's installed"},null,"Enter an integer >=1"]
["Component details WCs",30,{"$f":"CONCATENATE(\"Only display if the answer to \",D$57, \"is >=1\")","v":"Only display if the answer to How many different types of WC's are installed?is >=1"},"Enter full flush volume of Type 1 component in litres",null,"Enter a positive number >=0 to 2dps",null,"if value = 0 "]
["Component details WCs",null,{"$f":"+C73","v":"Only display if the answer to How many different types of WC's are installed?is >=1"},"Enter reduced flush volume of Type 1 component in litres",null,{"$f":"+F73","v":"Enter a positive number >=0 to 2dps"}]
["Component details WCs",31,{"$f":"CONCATENATE(\"Only display if the answer to \",D$57, \"is >=2\")","v":"Only display if the answer to How many different types of WC's are installed?is >=2"},{"$f":"CONCATENATE(\"Enter number of Type 2 \",+'lookup tables'!C$35,\"s installed\")","v":"Enter number of Type 2 WC's installed"},null,"Enter an integer >=1"]
["Component details WCs",32,{"$f":"CONCATENATE(\"Only display if the answer to \",D$57, \"is >=2\")","v":"Only display if the answer to How many different types of WC's are installed?is >=2"},"Enter full flush volume of Type 2 component in litres",null,"Enter a positive number to 2dps"]
["Component details WCs",null,{"$f":"+C76","v":"Only display if the answer to How many different types of WC's are installed?is >=2"},"Enter reduced flush volume of Type 2 component in litres",null,{"$f":"+F76","v":"Enter a positive number to 2dps"}]
["Component details WCs",33,{"$f":"CONCATENATE(\"Only display if the answer to \",D$57, \"is >=3\")","v":"Only display if the answer to How many different types of WC's are installed?is >=3"},{"$f":"CONCATENATE(\"Enter number of Type 3 \",+'lookup tables'!C$35,\"s installed\")","v":"Enter number of Type 3 WC's installed"},null,"Enter an integer >=1"]
["Component details WCs",34,{"$f":"CONCATENATE(\"Only display if the answer to \",D$57, \"is >=3\")","v":"Only display if the answer to How many different types of WC's are installed?is >=3"},"Enter full flush volume of Type 3 component in litres",null,"Enter a positive number to 2dps"]
["Component details WCs",null,{"$f":"+C79","v":"Only display if the answer to How many different types of WC's are installed?is >=3"},"Enter reduced flush volume of Type 3 component in litres",null,{"$f":"+F79","v":"Enter a positive number to 2dps"}]
["Component details WCs",35,{"$f":"CONCATENATE(\"Only display if the answer to \",D$57, \"is >=4\")","v":"Only display if the answer to How many different types of WC's are installed?is >=4"},{"$f":"CONCATENATE(\"Enter number of Type 4 \",+'lookup tables'!C$35,\"s installed\")","v":"Enter number of Type 4 WC's installed"},null,"Enter an integer >=1"]
["Component details WCs",36,{"$f":"CONCATENATE(\"Only display if the answer to \",D$57, \"is >=4\")","v":"Only display if the answer to How many different types of WC's are installed?is >=4"},"Enter full flush volume of Type 4 component in litres",null,"Enter a positive number to 2dps"]
["Component details WCs",null,{"$f":"+C82","v":"Only display if the answer to How many different types of WC's are installed?is >=4"},"Enter reduced flush volume of Type 4 component in litres",null,{"$f":"+F82","v":"Enter a positive number to 2dps"}]
["Component details WCs",37,{"$f":"CONCATENATE(\"Only display if the answer to \",D$57, \"is >=5\")","v":"Only display if the answer to How many different types of WC's are installed?is >=5"},{"$f":"CONCATENATE(\"Enter number of Type 5 \",+'lookup tables'!C$35,\"s installed\")","v":"Enter number of Type 5 WC's installed"},null,"Enter an integer >=1"]
["Component details WCs",38,{"$f":"CONCATENATE(\"Only display if the answer to \",D$57, \"is >=5\")","v":"Only display if the answer to How many different types of WC's are installed?is >=5"},"Enter full flush volume of Type 5 component in litres",null,"Enter a positive number to 2dps"]
["Component details WCs",null,{"$f":"+C85","v":"Only display if the answer to How many different types of WC's are installed?is >=5"},"Enter reduced flush volume of Type 5 component in litres",null,{"$f":"+F85","v":"Enter a positive number to 2dps"}]
["Component details WCs",39,{"$f":"CONCATENATE(\"Only display if the answer to \",D$57, \"is >=6\")","v":"Only display if the answer to How many different types of WC's are installed?is >=6"},{"$f":"CONCATENATE(\"Enter number of Type 6 \",+'lookup tables'!C$35,\"s installed\")","v":"Enter number of Type 6 WC's installed"},null,"Enter an integer >=1"]
["Component details WCs",40,{"$f":"CONCATENATE(\"Only display if the answer to \",D$57, \"is >=6\")","v":"Only display if the answer to How many different types of WC's are installed?is >=6"},"Enter full flush volume of Type 6 component in litres",null,"Enter a positive number to 2dps"]
["Component details WCs",null,{"$f":"+C88","v":"Only display if the answer to How many different types of WC's are installed?is >=6"},"Enter reduced flush volume of Type 6 component in litres",null,{"$f":"+F88","v":"Enter a positive number to 2dps"}]
["Component details WCs",41,{"$f":"CONCATENATE(\"Only display if the answer to \",D$57, \"is >=7\")","v":"Only display if the answer to How many different types of WC's are installed?is >=7"},{"$f":"CONCATENATE(\"Enter number of Type 7 \",+'lookup tables'!C$35,\"s installed\")","v":"Enter number of Type 7 WC's installed"},null,"Enter an integer >=1"]
["Component details WCs",42,{"$f":"CONCATENATE(\"Only display if the answer to \",D$57, \"is >=7\")","v":"Only display if the answer to How many different types of WC's are installed?is >=7"},"Enter full flush volume of Type 7 component in litres",null,"Enter a positive number to 2dps"]
["Component details WCs",null,{"$f":"+C91","v":"Only display if the answer to How many different types of WC's are installed?is >=7"},"Enter reduced flush volume of Type 7 component in litres",null,{"$f":"+F91","v":"Enter a positive number to 2dps"}]
["Component details WCs",43,{"$f":"CONCATENATE(\"Only display if the answer to \",D$57, \"is >=8\")","v":"Only display if the answer to How many different types of WC's are installed?is >=8"},{"$f":"CONCATENATE(\"Enter number of Type 8 \",+'lookup tables'!C$35,\"s installed\")","v":"Enter number of Type 8 WC's installed"},null,"Enter an integer >=1"]
["Component details WCs",44,{"$f":"CONCATENATE(\"Only display if the answer to \",D$57, \"is >=8\")","v":"Only display if the answer to How many different types of WC's are installed?is >=8"},"Enter full flush volume of Type 8 component in litres",null,"Enter a positive number to 2dps"]
[null,null,{"$f":"+C94","v":"Only display if the answer to How many different types of WC's are installed?is >=8"},"Enter reduced flush volume of Type 8 component in litres",null,{"$f":"+F94","v":"Enter a positive number to 2dps"}]
["Component details timed flush urinals"]
["Component details timed flush urinals",45,{"$f":"CONCATENATE(\"Only display if the answer to \",D$58, \"is >=1\")","v":"Only display if the answer to How many different types of Urinal with timed flushs are installed?is >=1"},{"$f":"CONCATENATE(\"Enter number of Type 1 \",+'lookup tables'!C$36,\"s installed\")","v":"Enter number of Type 1 Urinal with timed flushs installed"},null,"Enter an integer >=1"]
["Component details timed flush urinals",46,{"$f":"CONCATENATE(\"Only display if the answer to \",D$58, \"is >=1\")","v":"Only display if the answer to How many different types of Urinal with timed flushs are installed?is >=1"},"Enter average flush volume of Type 1 component  in litres per bowl per hour",null,"Enter a positive number to 2dps"]
["Component details timed flush urinals",47,{"$f":"CONCATENATE(\"Only display if the answer to \",D$58, \"is >=2\")","v":"Only display if the answer to How many different types of Urinal with timed flushs are installed?is >=2"},{"$f":"CONCATENATE(\"Enter number of Type 2 \",+'lookup tables'!C$36,\"s installed\")","v":"Enter number of Type 2 Urinal with timed flushs installed"},null,"Enter an integer >=1"]
["Component details timed flush urinals",48,{"$f":"CONCATENATE(\"Only display if the answer to \",D$58, \"is >=2\")","v":"Only display if the answer to How many different types of Urinal with timed flushs are installed?is >=2"},"Enter average flush volume of Type 2 component  in litres per bowl per hour",null,"Enter a positive number to 2dps"]
["Component details timed flush urinals",49,{"$f":"CONCATENATE(\"Only display if the answer to \",D$58, \"is >=3\")","v":"Only display if the answer to How many different types of Urinal with timed flushs are installed?is >=3"},{"$f":"CONCATENATE(\"Enter number of Type 3 \",+'lookup tables'!C$36,\"s installed\")","v":"Enter number of Type 3 Urinal with timed flushs installed"},null,"Enter an integer >=1"]
["Component details timed flush urinals",50,{"$f":"CONCATENATE(\"Only display if the answer to \",D$58, \"is >=3\")","v":"Only display if the answer to How many different types of Urinal with timed flushs are installed?is >=3"},"Enter average flush volume of Type 3 component  in litres per bowl per hour",null,"Enter a positive number to 2dps"]
["Component details timed flush urinals",51,{"$f":"CONCATENATE(\"Only display if the answer to \",D$58, \"is >=4\")","v":"Only display if the answer to How many different types of Urinal with timed flushs are installed?is >=4"},{"$f":"CONCATENATE(\"Enter number of Type 4 \",+'lookup tables'!C$36,\"s installed\")","v":"Enter number of Type 4 Urinal with timed flushs installed"},null,"Enter an integer >=1"]
["Component details timed flush urinals",52,{"$f":"CONCATENATE(\"Only display if the answer to \",D$58, \"is >=4\")","v":"Only display if the answer to How many different types of Urinal with timed flushs are installed?is >=4"},"Enter average flush volume of Type 4 component  in litres per bowl per hour",null,"Enter a positive number to 2dps"]
["Component details timed flush urinals",53,{"$f":"CONCATENATE(\"Only display if the answer to \",D$58, \"is >=5\")","v":"Only display if the answer to How many different types of Urinal with timed flushs are installed?is >=5"},{"$f":"CONCATENATE(\"Enter number of Type 5 \",+'lookup tables'!C$36,\"s installed\")","v":"Enter number of Type 5 Urinal with timed flushs installed"},null,"Enter an integer >=1"]
["Component details timed flush urinals",54,{"$f":"CONCATENATE(\"Only display if the answer to \",D$58, \"is >=5\")","v":"Only display if the answer to How many different types of Urinal with timed flushs are installed?is >=5"},"Enter average flush volume of Type 5 component  in litres per bowl per hour",null,"Enter a positive number to 2dps"]
["Component details timed flush urinals",55,{"$f":"CONCATENATE(\"Only display if the answer to \",D$58, \"is >=6\")","v":"Only display if the answer to How many different types of Urinal with timed flushs are installed?is >=6"},{"$f":"CONCATENATE(\"Enter number of Type 6 \",+'lookup tables'!C$36,\"s installed\")","v":"Enter number of Type 6 Urinal with timed flushs installed"},null,"Enter an integer >=1"]
["Component details timed flush urinals",56,{"$f":"CONCATENATE(\"Only display if the answer to \",D$58, \"is >=6\")","v":"Only display if the answer to How many different types of Urinal with timed flushs are installed?is >=6"},"Enter average flush volume of Type 6 component  in litres per bowl per hour",null,"Enter a positive number to 2dps"]
["Component details timed flush urinals",57,{"$f":"CONCATENATE(\"Only display if the answer to \",D$58, \"is >=7\")","v":"Only display if the answer to How many different types of Urinal with timed flushs are installed?is >=7"},{"$f":"CONCATENATE(\"Enter number of Type 7 \",+'lookup tables'!C$36,\"s installed\")","v":"Enter number of Type 7 Urinal with timed flushs installed"},null,"Enter an integer >=1"]
["Component details timed flush urinals",58,{"$f":"CONCATENATE(\"Only display if the answer to \",D$58, \"is >=7\")","v":"Only display if the answer to How many different types of Urinal with timed flushs are installed?is >=7"},"Enter average flush volume of Type 7 component  in litres per bowl per hour",null,"Enter a positive number to 2dps"]
["Component details timed flush urinals",59,{"$f":"CONCATENATE(\"Only display if the answer to \",D$58, \"is >=8\")","v":"Only display if the answer to How many different types of Urinal with timed flushs are installed?is >=8"},{"$f":"CONCATENATE(\"Enter number of Type 8 \",+'lookup tables'!C$36,\"s installed\")","v":"Enter number of Type 8 Urinal with timed flushs installed"},null,"Enter an integer >=1"]
["Component details timed flush urinals",60,{"$f":"CONCATENATE(\"Only display if the answer to \",D$58, \"is >=8\")","v":"Only display if the answer to How many different types of Urinal with timed flushs are installed?is >=8"},"Enter average flush volume of Type 8 component  in litres per bowl per hour",null,"Enter a positive number to 2dps"]
["Component details sensor flush urinals"]
["Component details sensor flush urinals",61,{"$f":"CONCATENATE(\"Only display if the answer to \",D$59, \"is >=1\")","v":"Only display if the answer to How many different types of Urinal with automatic sensor flushs are installed?is >=1"},{"$f":"CONCATENATE(\"Enter number of Type 1 \",+'lookup tables'!C$37,\"s installed\")","v":"Enter number of Type 1 Urinal with automatic sensor flushs installed"},null,"Enter an integer >=1"]
["Component details sensor flush urinals",62,{"$f":"CONCATENATE(\"Only display if the answer to \",D$59, \"is >=1\")","v":"Only display if the answer to How many different types of Urinal with automatic sensor flushs are installed?is >=1"},"Enter average flush volume of Type 1 component  in litres",null,"Enter a positive number to 2dps"]
["Component details sensor flush urinals",63,{"$f":"CONCATENATE(\"Only display if the answer to \",D$59, \"is >=2\")","v":"Only display if the answer to How many different types of Urinal with automatic sensor flushs are installed?is >=2"},{"$f":"CONCATENATE(\"Enter number of Type 2 \",+'lookup tables'!C$37,\"s installed\")","v":"Enter number of Type 2 Urinal with automatic sensor flushs installed"},null,"Enter an integer >=1"]
["Component details sensor flush urinals",64,{"$f":"CONCATENATE(\"Only display if the answer to \",D$59, \"is >=2\")","v":"Only display if the answer to How many different types of Urinal with automatic sensor flushs are installed?is >=2"},"Enter average flush volume of Type 2 component  in litres",null,"Enter a positive number to 2dps"]
["Component details sensor flush urinals",65,{"$f":"CONCATENATE(\"Only display if the answer to \",D$59, \"is >=3\")","v":"Only display if the answer to How many different types of Urinal with automatic sensor flushs are installed?is >=3"},{"$f":"CONCATENATE(\"Enter number of Type 3 \",+'lookup tables'!C$37,\"s installed\")","v":"Enter number of Type 3 Urinal with automatic sensor flushs installed"},null,"Enter an integer >=1"]
["Component details sensor flush urinals",66,{"$f":"CONCATENATE(\"Only display if the answer to \",D$59, \"is >=3\")","v":"Only display if the answer to How many different types of Urinal with automatic sensor flushs are installed?is >=3"},"Enter average flush volume of Type 3 component  in litres",null,"Enter a positive number to 2dps"]
["Component details sensor flush urinals",67,{"$f":"CONCATENATE(\"Only display if the answer to \",D$59, \"is >=4\")","v":"Only display if the answer to How many different types of Urinal with automatic sensor flushs are installed?is >=4"},{"$f":"CONCATENATE(\"Enter number of Type 4 \",+'lookup tables'!C$37,\"s installed\")","v":"Enter number of Type 4 Urinal with automatic sensor flushs installed"},null,"Enter an integer >=1"]
["Component details sensor flush urinals",68,{"$f":"CONCATENATE(\"Only display if the answer to \",D$59, \"is >=4\")","v":"Only display if the answer to How many different types of Urinal with automatic sensor flushs are installed?is >=4"},"Enter average flush volume of Type 4 component  in litres",null,"Enter a positive number to 2dps"]
["Component details sensor flush urinals",69,{"$f":"CONCATENATE(\"Only display if the answer to \",D$59, \"is >=5\")","v":"Only display if the answer to How many different types of Urinal with automatic sensor flushs are installed?is >=5"},{"$f":"CONCATENATE(\"Enter number of Type 5 \",+'lookup tables'!C$37,\"s installed\")","v":"Enter number of Type 5 Urinal with automatic sensor flushs installed"},null,"Enter an integer >=1"]
["Component details sensor flush urinals",70,{"$f":"CONCATENATE(\"Only display if the answer to \",D$59, \"is >=5\")","v":"Only display if the answer to How many different types of Urinal with automatic sensor flushs are installed?is >=5"},"Enter average flush volume of Type 5 component  in litres",null,"Enter a positive number to 2dps"]
["Component details sensor flush urinals",71,{"$f":"CONCATENATE(\"Only display if the answer to \",D$59, \"is >=6\")","v":"Only display if the answer to How many different types of Urinal with automatic sensor flushs are installed?is >=6"},{"$f":"CONCATENATE(\"Enter number of Type 6 \",+'lookup tables'!C$37,\"s installed\")","v":"Enter number of Type 6 Urinal with automatic sensor flushs installed"},null,"Enter an integer >=1"]
["Component details sensor flush urinals",72,{"$f":"CONCATENATE(\"Only display if the answer to \",D$59, \"is >=6\")","v":"Only display if the answer to How many different types of Urinal with automatic sensor flushs are installed?is >=6"},"Enter average flush volume of Type 6 component  in litres",null,"Enter a positive number to 2dps"]
["Component details sensor flush urinals",73,{"$f":"CONCATENATE(\"Only display if the answer to \",D$59, \"is >=7\")","v":"Only display if the answer to How many different types of Urinal with automatic sensor flushs are installed?is >=7"},{"$f":"CONCATENATE(\"Enter number of Type 7 \",+'lookup tables'!C$37,\"s installed\")","v":"Enter number of Type 7 Urinal with automatic sensor flushs installed"},null,"Enter an integer >=1"]
["Component details sensor flush urinals",74,{"$f":"CONCATENATE(\"Only display if the answer to \",D$59, \"is >=7\")","v":"Only display if the answer to How many different types of Urinal with automatic sensor flushs are installed?is >=7"},"Enter average flush volume of Type 7 component  in litres",null,"Enter a positive number to 2dps"]
["Component details sensor flush urinals",75,{"$f":"CONCATENATE(\"Only display if the answer to \",D$59, \"is >=8\")","v":"Only display if the answer to How many different types of Urinal with automatic sensor flushs are installed?is >=8"},{"$f":"CONCATENATE(\"Enter number of Type 8 \",+'lookup tables'!C$37,\"s installed\")","v":"Enter number of Type 8 Urinal with automatic sensor flushs installed"},null,"Enter an integer >=1"]
["Component details sensor flush urinals",76,{"$f":"CONCATENATE(\"Only display if the answer to \",D$59, \"is >=8\")","v":"Only display if the answer to How many different types of Urinal with automatic sensor flushs are installed?is >=8"},"Enter average flush volume of Type 8 component  in litres",null,"Enter a positive number to 2dps"]
["Component details waterless urinals"]
["Component details waterless urinals",44,{"$f":"CONCATENATE(\"Only display if the answer to \",+D43, \" is Yes\")","v":"Only display if the answer to Are any of the urinals waterless is Yes"},{"$f":"CONCATENATE(\"Enter number of \",+'lookup tables'!C38,\" installed\")","v":"Enter number of Waterless urinals installed"},null,"Enter an integer >=1"]
["Component details Wash hand basin taps"]
["Component details Wash hand basin taps",60,{"$f":"CONCATENATE(\"Only display if the answer to \",D$60, \"is >=1\")","v":"Only display if the answer to How many different types of Wash hand basin taps are installed?is >=1"},{"$f":"CONCATENATE(\"Enter number of Type 1 \",+'lookup tables'!C$39,\"s installed\")","v":"Enter number of Type 1 Wash hand basin taps installed"},null,"Enter an integer >=1"]
["Component details Wash hand basin taps",61,{"$f":"CONCATENATE(\"Only display if the answer to \",D$60, \"is >=1\")","v":"Only display if the answer to How many different types of Wash hand basin taps are installed?is >=1"},"Enter flow rate of Type 1 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Wash hand basin taps",62,{"$f":"CONCATENATE(\"Only display if the answer to \",D$60, \"is >=2\")","v":"Only display if the answer to How many different types of Wash hand basin taps are installed?is >=2"},{"$f":"CONCATENATE(\"Enter number of Type 2 \",+'lookup tables'!C$39,\"s installed\")","v":"Enter number of Type 2 Wash hand basin taps installed"},null,"Enter an integer >=1"]
["Component details Wash hand basin taps",63,{"$f":"CONCATENATE(\"Only display if the answer to \",D$60, \"is >=2\")","v":"Only display if the answer to How many different types of Wash hand basin taps are installed?is >=2"},"Enter flow rate of Type 2 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Wash hand basin taps",64,{"$f":"CONCATENATE(\"Only display if the answer to \",D$60, \"is >=3\")","v":"Only display if the answer to How many different types of Wash hand basin taps are installed?is >=3"},{"$f":"CONCATENATE(\"Enter number of Type 3 \",+'lookup tables'!C$39,\"s installed\")","v":"Enter number of Type 3 Wash hand basin taps installed"},null,"Enter an integer >=1"]
["Component details Wash hand basin taps",65,{"$f":"CONCATENATE(\"Only display if the answer to \",D$60, \"is >=3\")","v":"Only display if the answer to How many different types of Wash hand basin taps are installed?is >=3"},"Enter flow rate of Type 3 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Wash hand basin taps",66,{"$f":"CONCATENATE(\"Only display if the answer to \",D$60, \"is >=4\")","v":"Only display if the answer to How many different types of Wash hand basin taps are installed?is >=4"},{"$f":"CONCATENATE(\"Enter number of Type 4 \",+'lookup tables'!C$39,\"s installed\")","v":"Enter number of Type 4 Wash hand basin taps installed"},null,"Enter an integer >=1"]
["Component details Wash hand basin taps",67,{"$f":"CONCATENATE(\"Only display if the answer to \",D$60, \"is >=4\")","v":"Only display if the answer to How many different types of Wash hand basin taps are installed?is >=4"},"Enter flow rate of Type 4 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Wash hand basin taps",68,{"$f":"CONCATENATE(\"Only display if the answer to \",D$60, \"is >=5\")","v":"Only display if the answer to How many different types of Wash hand basin taps are installed?is >=5"},{"$f":"CONCATENATE(\"Enter number of Type 5 \",+'lookup tables'!C$39,\"s installed\")","v":"Enter number of Type 5 Wash hand basin taps installed"},null,"Enter an integer >=1"]
["Component details Wash hand basin taps",69,{"$f":"CONCATENATE(\"Only display if the answer to \",D$60, \"is >=5\")","v":"Only display if the answer to How many different types of Wash hand basin taps are installed?is >=5"},"Enter flow rate of Type 5 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Wash hand basin taps",70,{"$f":"CONCATENATE(\"Only display if the answer to \",D$60, \"is >=6\")","v":"Only display if the answer to How many different types of Wash hand basin taps are installed?is >=6"},{"$f":"CONCATENATE(\"Enter number of Type 6 \",+'lookup tables'!C$39,\"s installed\")","v":"Enter number of Type 6 Wash hand basin taps installed"},null,"Enter an integer >=1"]
["Component details Wash hand basin taps",71,{"$f":"CONCATENATE(\"Only display if the answer to \",D$60, \"is >=6\")","v":"Only display if the answer to How many different types of Wash hand basin taps are installed?is >=6"},"Enter flow rate of Type 6 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Wash hand basin taps",72,{"$f":"CONCATENATE(\"Only display if the answer to \",D$60, \"is >=7\")","v":"Only display if the answer to How many different types of Wash hand basin taps are installed?is >=7"},{"$f":"CONCATENATE(\"Enter number of Type 7 \",+'lookup tables'!C$39,\"s installed\")","v":"Enter number of Type 7 Wash hand basin taps installed"},null,"Enter an integer >=1"]
["Component details Wash hand basin taps",73,{"$f":"CONCATENATE(\"Only display if the answer to \",D$60, \"is >=7\")","v":"Only display if the answer to How many different types of Wash hand basin taps are installed?is >=7"},"Enter flow rate of Type 7 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Wash hand basin taps",74,{"$f":"CONCATENATE(\"Only display if the answer to \",D$60, \"is >=8\")","v":"Only display if the answer to How many different types of Wash hand basin taps are installed?is >=8"},{"$f":"CONCATENATE(\"Enter number of Type 8 \",+'lookup tables'!C$39,\"s installed\")","v":"Enter number of Type 8 Wash hand basin taps installed"},null,"Enter an integer >=1"]
["Component details Wash hand basin taps",75,{"$f":"CONCATENATE(\"Only display if the answer to \",D$60, \"is >=8\")","v":"Only display if the answer to How many different types of Wash hand basin taps are installed?is >=8"},"Enter flow rate of Type 8 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Showers"]
["Component details Showers",76,{"$f":"CONCATENATE(\"Only display if the answer to \",D$61, \"is >=1\")","v":"Only display if the answer to How many different types of Showers are installed?is >=1"},{"$f":"CONCATENATE(\"Enter number of Type 1 \",+'lookup tables'!C$40,\"s installed\")","v":"Enter number of Type 1 Showers installed"},null,"Enter an integer >=1"]
["Component details Showers",77,{"$f":"CONCATENATE(\"Only display if the answer to \",D$61, \"is >=1\")","v":"Only display if the answer to How many different types of Showers are installed?is >=1"},"Enter flow rate of Type 1 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Showers",78,{"$f":"CONCATENATE(\"Only display if the answer to \",D$61, \"is >=2\")","v":"Only display if the answer to How many different types of Showers are installed?is >=2"},{"$f":"CONCATENATE(\"Enter number of Type 2 \",+'lookup tables'!C$40,\"s installed\")","v":"Enter number of Type 2 Showers installed"},null,"Enter an integer >=1"]
["Component details Showers",79,{"$f":"CONCATENATE(\"Only display if the answer to \",D$61, \"is >=2\")","v":"Only display if the answer to How many different types of Showers are installed?is >=2"},"Enter flow rate of Type 2 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Showers",80,{"$f":"CONCATENATE(\"Only display if the answer to \",D$61, \"is >=3\")","v":"Only display if the answer to How many different types of Showers are installed?is >=3"},{"$f":"CONCATENATE(\"Enter number of Type 3 \",+'lookup tables'!C$40,\"s installed\")","v":"Enter number of Type 3 Showers installed"},null,"Enter an integer >=1"]
["Component details Showers",81,{"$f":"CONCATENATE(\"Only display if the answer to \",D$61, \"is >=3\")","v":"Only display if the answer to How many different types of Showers are installed?is >=3"},"Enter flow rate of Type 3 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Showers",82,{"$f":"CONCATENATE(\"Only display if the answer to \",D$61, \"is >=4\")","v":"Only display if the answer to How many different types of Showers are installed?is >=4"},{"$f":"CONCATENATE(\"Enter number of Type 4 \",+'lookup tables'!C$40,\"s installed\")","v":"Enter number of Type 4 Showers installed"},null,"Enter an integer >=1"]
["Component details Showers",83,{"$f":"CONCATENATE(\"Only display if the answer to \",D$61, \"is >=4\")","v":"Only display if the answer to How many different types of Showers are installed?is >=4"},"Enter flow rate of Type 4 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Showers",84,{"$f":"CONCATENATE(\"Only display if the answer to \",D$61, \"is >=5\")","v":"Only display if the answer to How many different types of Showers are installed?is >=5"},{"$f":"CONCATENATE(\"Enter number of Type 5 \",+'lookup tables'!C$40,\"s installed\")","v":"Enter number of Type 5 Showers installed"},null,"Enter an integer >=1"]
["Component details Showers",85,{"$f":"CONCATENATE(\"Only display if the answer to \",D$61, \"is >=5\")","v":"Only display if the answer to How many different types of Showers are installed?is >=5"},"Enter flow rate of Type 5 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Showers",86,{"$f":"CONCATENATE(\"Only display if the answer to \",D$61, \"is >=6\")","v":"Only display if the answer to How many different types of Showers are installed?is >=6"},{"$f":"CONCATENATE(\"Enter number of Type 6 \",+'lookup tables'!C$40,\"s installed\")","v":"Enter number of Type 6 Showers installed"},null,"Enter an integer >=1"]
["Component details Showers",87,{"$f":"CONCATENATE(\"Only display if the answer to \",D$61, \"is >=6\")","v":"Only display if the answer to How many different types of Showers are installed?is >=6"},"Enter flow rate of Type 6 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Showers",88,{"$f":"CONCATENATE(\"Only display if the answer to \",D$61, \"is >=7\")","v":"Only display if the answer to How many different types of Showers are installed?is >=7"},{"$f":"CONCATENATE(\"Enter number of Type 7 \",+'lookup tables'!C$40,\"s installed\")","v":"Enter number of Type 7 Showers installed"},null,"Enter an integer >=1"]
["Component details Showers",89,{"$f":"CONCATENATE(\"Only display if the answer to \",D$61, \"is >=7\")","v":"Only display if the answer to How many different types of Showers are installed?is >=7"},"Enter flow rate of Type 7 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Showers",90,{"$f":"CONCATENATE(\"Only display if the answer to \",D$61, \"is >=8\")","v":"Only display if the answer to How many different types of Showers are installed?is >=8"},{"$f":"CONCATENATE(\"Enter number of Type 8 \",+'lookup tables'!C$40,\"s installed\")","v":"Enter number of Type 8 Showers installed"},null,"Enter an integer >=1"]
["Component details Showers",91,{"$f":"CONCATENATE(\"Only display if the answer to \",D$61, \"is >=8\")","v":"Only display if the answer to How many different types of Showers are installed?is >=8"},"Enter flow rate of Type 8 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Baths"]
["Component details Baths",92,{"$f":"CONCATENATE(\"Only display if the answer to \",D$62, \"is >=1\")","v":"Only display if the answer to How many different types of Baths are installed?is >=1"},{"$f":"CONCATENATE(\"Enter number of Type 1 \",+'lookup tables'!C$41,\"s installed\")","v":"Enter number of Type 1 Baths installed"},null,"Enter an integer >=1"]
["Component details Baths",93,{"$f":"CONCATENATE(\"Only display if the answer to \",D$62, \"is >=1\")","v":"Only display if the answer to How many different types of Baths are installed?is >=1"},"Enter average flush flow rate of Type 1 component  in litres",null,"Enter a positive number to 2dps"]
["Component details Baths",94,{"$f":"CONCATENATE(\"Only display if the answer to \",D$62, \"is >=2\")","v":"Only display if the answer to How many different types of Baths are installed?is >=2"},{"$f":"CONCATENATE(\"Enter number of Type 2 \",+'lookup tables'!C$41,\"s installed\")","v":"Enter number of Type 2 Baths installed"},null,"Enter an integer >=1"]
["Component details Baths",95,{"$f":"CONCATENATE(\"Only display if the answer to \",D$62, \"is >=2\")","v":"Only display if the answer to How many different types of Baths are installed?is >=2"},"Enter average flush flow rate of Type 2 component  in litres",null,"Enter a positive number to 2dps"]
["Component details Baths",96,{"$f":"CONCATENATE(\"Only display if the answer to \",D$62, \"is >=3\")","v":"Only display if the answer to How many different types of Baths are installed?is >=3"},{"$f":"CONCATENATE(\"Enter number of Type 3 \",+'lookup tables'!C$41,\"s installed\")","v":"Enter number of Type 3 Baths installed"},null,"Enter an integer >=1"]
["Component details Baths",97,{"$f":"CONCATENATE(\"Only display if the answer to \",D$62, \"is >=3\")","v":"Only display if the answer to How many different types of Baths are installed?is >=3"},"Enter average flush flow rate of Type 3 component  in litres",null,"Enter a positive number to 2dps"]
["Component details Baths",98,{"$f":"CONCATENATE(\"Only display if the answer to \",D$62, \"is >=4\")","v":"Only display if the answer to How many different types of Baths are installed?is >=4"},{"$f":"CONCATENATE(\"Enter number of Type 4 \",+'lookup tables'!C$41,\"s installed\")","v":"Enter number of Type 4 Baths installed"},null,"Enter an integer >=1"]
["Component details Baths",99,{"$f":"CONCATENATE(\"Only display if the answer to \",D$62, \"is >=4\")","v":"Only display if the answer to How many different types of Baths are installed?is >=4"},"Enter average flush flow rate of Type 4 component  in litres",null,"Enter a positive number to 2dps"]
["Component details Baths",100,{"$f":"CONCATENATE(\"Only display if the answer to \",D$62, \"is >=5\")","v":"Only display if the answer to How many different types of Baths are installed?is >=5"},{"$f":"CONCATENATE(\"Enter number of Type 5 \",+'lookup tables'!C$41,\"s installed\")","v":"Enter number of Type 5 Baths installed"},null,"Enter an integer >=1"]
["Component details Baths",101,{"$f":"CONCATENATE(\"Only display if the answer to \",D$62, \"is >=5\")","v":"Only display if the answer to How many different types of Baths are installed?is >=5"},"Enter average flush flow rate of Type 5 component  in litres",null,"Enter a positive number to 2dps"]
["Component details Baths",102,{"$f":"CONCATENATE(\"Only display if the answer to \",D$62, \"is >=6\")","v":"Only display if the answer to How many different types of Baths are installed?is >=6"},{"$f":"CONCATENATE(\"Enter number of Type 6 \",+'lookup tables'!C$41,\"s installed\")","v":"Enter number of Type 6 Baths installed"},null,"Enter an integer >=1"]
["Component details Baths",103,{"$f":"CONCATENATE(\"Only display if the answer to \",D$62, \"is >=6\")","v":"Only display if the answer to How many different types of Baths are installed?is >=6"},"Enter average flush flow rate of Type 6 component  in litres",null,"Enter a positive number to 2dps"]
["Component details Baths",104,{"$f":"CONCATENATE(\"Only display if the answer to \",D$62, \"is >=7\")","v":"Only display if the answer to How many different types of Baths are installed?is >=7"},{"$f":"CONCATENATE(\"Enter number of Type 7 \",+'lookup tables'!C$41,\"s installed\")","v":"Enter number of Type 7 Baths installed"},null,"Enter an integer >=1"]
["Component details Baths",105,{"$f":"CONCATENATE(\"Only display if the answer to \",D$62, \"is >=7\")","v":"Only display if the answer to How many different types of Baths are installed?is >=7"},"Enter average flush flow rate of Type 7 component  in litres",null,"Enter a positive number to 2dps"]
["Component details Baths",106,{"$f":"CONCATENATE(\"Only display if the answer to \",D$62, \"is >=8\")","v":"Only display if the answer to How many different types of Baths are installed?is >=8"},{"$f":"CONCATENATE(\"Enter number of Type 8 \",+'lookup tables'!C$41,\"s installed\")","v":"Enter number of Type 8 Baths installed"},null,"Enter an integer >=1"]
["Component details Baths",107,{"$f":"CONCATENATE(\"Only display if the answer to \",D$62, \"is >=8\")","v":"Only display if the answer to How many different types of Baths are installed?is >=8"},"Enter average flush flow rate of Type 8 component  in litres",null,"Enter a positive number to 2dps"]
["Component details Kitchen taps: kitchenette"]
["Component details Kitchen taps: kitchenette",108,{"$f":"CONCATENATE(\"Only display if the answer to \",D$63, \"is >=1\")","v":"Only display if the answer to How many different types of Kitchen taps: kitchenette are installed?is >=1"},{"$f":"CONCATENATE(\"Enter number of Type 1 \",+'lookup tables'!C$42,\"s installed\")","v":"Enter number of Type 1 Kitchen taps: kitchenettes installed"},null,"Enter an integer >=1"]
["Component details Kitchen taps: kitchenette",109,{"$f":"CONCATENATE(\"Only display if the answer to \",D$63, \"is >=1\")","v":"Only display if the answer to How many different types of Kitchen taps: kitchenette are installed?is >=1"},"Enter flow rate of Type 1 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Kitchen taps: kitchenette",110,{"$f":"CONCATENATE(\"Only display if the answer to \",D$63, \"is >=2\")","v":"Only display if the answer to How many different types of Kitchen taps: kitchenette are installed?is >=2"},{"$f":"CONCATENATE(\"Enter number of Type 2 \",+'lookup tables'!C$42,\"s installed\")","v":"Enter number of Type 2 Kitchen taps: kitchenettes installed"},null,"Enter an integer >=1"]
["Component details Kitchen taps: kitchenette",111,{"$f":"CONCATENATE(\"Only display if the answer to \",D$63, \"is >=2\")","v":"Only display if the answer to How many different types of Kitchen taps: kitchenette are installed?is >=2"},"Enter flow rate of Type 2 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Kitchen taps: kitchenette",112,{"$f":"CONCATENATE(\"Only display if the answer to \",D$63, \"is >=3\")","v":"Only display if the answer to How many different types of Kitchen taps: kitchenette are installed?is >=3"},{"$f":"CONCATENATE(\"Enter number of Type 3 \",+'lookup tables'!C$42,\"s installed\")","v":"Enter number of Type 3 Kitchen taps: kitchenettes installed"},null,"Enter an integer >=1"]
["Component details Kitchen taps: kitchenette",113,{"$f":"CONCATENATE(\"Only display if the answer to \",D$63, \"is >=3\")","v":"Only display if the answer to How many different types of Kitchen taps: kitchenette are installed?is >=3"},"Enter flow rate of Type 3 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Kitchen taps: kitchenette",114,{"$f":"CONCATENATE(\"Only display if the answer to \",D$63, \"is >=4\")","v":"Only display if the answer to How many different types of Kitchen taps: kitchenette are installed?is >=4"},{"$f":"CONCATENATE(\"Enter number of Type 4 \",+'lookup tables'!C$42,\"s installed\")","v":"Enter number of Type 4 Kitchen taps: kitchenettes installed"},null,"Enter an integer >=1"]
["Component details Kitchen taps: kitchenette",115,{"$f":"CONCATENATE(\"Only display if the answer to \",D$63, \"is >=4\")","v":"Only display if the answer to How many different types of Kitchen taps: kitchenette are installed?is >=4"},"Enter flow rate of Type 4 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Kitchen taps: kitchenette",116,{"$f":"CONCATENATE(\"Only display if the answer to \",D$63, \"is >=5\")","v":"Only display if the answer to How many different types of Kitchen taps: kitchenette are installed?is >=5"},{"$f":"CONCATENATE(\"Enter number of Type 5 \",+'lookup tables'!C$42,\"s installed\")","v":"Enter number of Type 5 Kitchen taps: kitchenettes installed"},null,"Enter an integer >=1"]
["Component details Kitchen taps: kitchenette",117,{"$f":"CONCATENATE(\"Only display if the answer to \",D$63, \"is >=5\")","v":"Only display if the answer to How many different types of Kitchen taps: kitchenette are installed?is >=5"},"Enter flow rate of Type 5 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Kitchen taps: kitchenette",118,{"$f":"CONCATENATE(\"Only display if the answer to \",D$63, \"is >=6\")","v":"Only display if the answer to How many different types of Kitchen taps: kitchenette are installed?is >=6"},{"$f":"CONCATENATE(\"Enter number of Type 6 \",+'lookup tables'!C$42,\"s installed\")","v":"Enter number of Type 6 Kitchen taps: kitchenettes installed"},null,"Enter an integer >=1"]
["Component details Kitchen taps: kitchenette",119,{"$f":"CONCATENATE(\"Only display if the answer to \",D$63, \"is >=6\")","v":"Only display if the answer to How many different types of Kitchen taps: kitchenette are installed?is >=6"},"Enter flow rate of Type 6 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Kitchen taps: kitchenette",120,{"$f":"CONCATENATE(\"Only display if the answer to \",D$63, \"is >=7\")","v":"Only display if the answer to How many different types of Kitchen taps: kitchenette are installed?is >=7"},{"$f":"CONCATENATE(\"Enter number of Type 7 \",+'lookup tables'!C$42,\"s installed\")","v":"Enter number of Type 7 Kitchen taps: kitchenettes installed"},null,"Enter an integer >=1"]
["Component details Kitchen taps: kitchenette",121,{"$f":"CONCATENATE(\"Only display if the answer to \",D$63, \"is >=7\")","v":"Only display if the answer to How many different types of Kitchen taps: kitchenette are installed?is >=7"},"Enter flow rate of Type 7 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Kitchen taps: kitchenette",122,{"$f":"CONCATENATE(\"Only display if the answer to \",D$63, \"is >=8\")","v":"Only display if the answer to How many different types of Kitchen taps: kitchenette are installed?is >=8"},{"$f":"CONCATENATE(\"Enter number of Type 8 \",+'lookup tables'!C$42,\"s installed\")","v":"Enter number of Type 8 Kitchen taps: kitchenettes installed"},null,"Enter an integer >=1"]
["Component details Kitchen taps: kitchenette",123,{"$f":"CONCATENATE(\"Only display if the answer to \",D$63, \"is >=8\")","v":"Only display if the answer to How many different types of Kitchen taps: kitchenette are installed?is >=8"},"Enter flow rate of Type 8 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Domestic sized washing machines"]
["Component details Domestic sized washing machines",124,{"$f":"CONCATENATE(\"Only display if the answer to \",D$64, \"is >=1\")","v":"Only display if the answer to How many different types of Domestic sized washing machines are installed?is >=1"},{"$f":"CONCATENATE(\"Enter number of Type 1 \",+'lookup tables'!C$43,\"s installed\")","v":"Enter number of Type 1 Domestic sized washing machiness installed"},null,"Enter an integer >=1"]
["Component details Domestic sized washing machines",125,{"$f":"CONCATENATE(\"Only display if the answer to \",D$64, \"is >=1\")","v":"Only display if the answer to How many different types of Domestic sized washing machines are installed?is >=1"},"Enter flow rate of Type 1 component  in litres per cycle",null,"Enter a positive number to 2dps"]
["Component details Domestic sized washing machines",126,{"$f":"CONCATENATE(\"Only display if the answer to \",D$64, \"is >=2\")","v":"Only display if the answer to How many different types of Domestic sized washing machines are installed?is >=2"},{"$f":"CONCATENATE(\"Enter number of Type 2 \",+'lookup tables'!C$43,\"s installed\")","v":"Enter number of Type 2 Domestic sized washing machiness installed"},null,"Enter an integer >=1"]
["Component details Domestic sized washing machines",127,{"$f":"CONCATENATE(\"Only display if the answer to \",D$64, \"is >=2\")","v":"Only display if the answer to How many different types of Domestic sized washing machines are installed?is >=2"},"Enter flow rate of Type 2 component  in litres per cycle",null,"Enter a positive number to 2dps"]
["Component details Domestic sized washing machines",128,{"$f":"CONCATENATE(\"Only display if the answer to \",D$64, \"is >=3\")","v":"Only display if the answer to How many different types of Domestic sized washing machines are installed?is >=3"},{"$f":"CONCATENATE(\"Enter number of Type 3 \",+'lookup tables'!C$43,\"s installed\")","v":"Enter number of Type 3 Domestic sized washing machiness installed"},null,"Enter an integer >=1"]
["Component details Domestic sized washing machines",129,{"$f":"CONCATENATE(\"Only display if the answer to \",D$64, \"is >=3\")","v":"Only display if the answer to How many different types of Domestic sized washing machines are installed?is >=3"},"Enter flow rate of Type 3 component  in litres per cycle",null,"Enter a positive number to 2dps"]
["Component details Domestic sized washing machines",130,{"$f":"CONCATENATE(\"Only display if the answer to \",D$64, \"is >=4\")","v":"Only display if the answer to How many different types of Domestic sized washing machines are installed?is >=4"},{"$f":"CONCATENATE(\"Enter number of Type 4 \",+'lookup tables'!C$43,\"s installed\")","v":"Enter number of Type 4 Domestic sized washing machiness installed"},null,"Enter an integer >=1"]
["Component details Domestic sized washing machines",131,{"$f":"CONCATENATE(\"Only display if the answer to \",D$64, \"is >=4\")","v":"Only display if the answer to How many different types of Domestic sized washing machines are installed?is >=4"},"Enter flow rate of Type 4 component  in litres per cycle",null,"Enter a positive number to 2dps"]
["Component details Domestic sized washing machines",132,{"$f":"CONCATENATE(\"Only display if the answer to \",D$64, \"is >=5\")","v":"Only display if the answer to How many different types of Domestic sized washing machines are installed?is >=5"},{"$f":"CONCATENATE(\"Enter number of Type 5 \",+'lookup tables'!C$43,\"s installed\")","v":"Enter number of Type 5 Domestic sized washing machiness installed"},null,"Enter an integer >=1"]
["Component details Domestic sized washing machines",133,{"$f":"CONCATENATE(\"Only display if the answer to \",D$64, \"is >=5\")","v":"Only display if the answer to How many different types of Domestic sized washing machines are installed?is >=5"},"Enter flow rate of Type 5 component  in litres per cycle",null,"Enter a positive number to 2dps"]
["Component details Domestic sized washing machines",134,{"$f":"CONCATENATE(\"Only display if the answer to \",D$64, \"is >=6\")","v":"Only display if the answer to How many different types of Domestic sized washing machines are installed?is >=6"},{"$f":"CONCATENATE(\"Enter number of Type 6 \",+'lookup tables'!C$43,\"s installed\")","v":"Enter number of Type 6 Domestic sized washing machiness installed"},null,"Enter an integer >=1"]
["Component details Domestic sized washing machines",135,{"$f":"CONCATENATE(\"Only display if the answer to \",D$64, \"is >=6\")","v":"Only display if the answer to How many different types of Domestic sized washing machines are installed?is >=6"},"Enter flow rate of Type 6 component  in litres per cycle",null,"Enter a positive number to 2dps"]
["Component details Domestic sized washing machines",136,{"$f":"CONCATENATE(\"Only display if the answer to \",D$64, \"is >=7\")","v":"Only display if the answer to How many different types of Domestic sized washing machines are installed?is >=7"},{"$f":"CONCATENATE(\"Enter number of Type 7 \",+'lookup tables'!C$43,\"s installed\")","v":"Enter number of Type 7 Domestic sized washing machiness installed"},null,"Enter an integer >=1"]
["Component details Domestic sized washing machines",137,{"$f":"CONCATENATE(\"Only display if the answer to \",D$64, \"is >=7\")","v":"Only display if the answer to How many different types of Domestic sized washing machines are installed?is >=7"},"Enter flow rate of Type 7 component  in litres per cycle",null,"Enter a positive number to 2dps"]
["Component details Domestic sized washing machines",138,{"$f":"CONCATENATE(\"Only display if the answer to \",D$64, \"is >=8\")","v":"Only display if the answer to How many different types of Domestic sized washing machines are installed?is >=8"},{"$f":"CONCATENATE(\"Enter number of Type 8 \",+'lookup tables'!C$43,\"s installed\")","v":"Enter number of Type 8 Domestic sized washing machiness installed"},null,"Enter an integer >=1"]
["Component details Domestic sized washing machines",139,{"$f":"CONCATENATE(\"Only display if the answer to \",D$64, \"is >=8\")","v":"Only display if the answer to How many different types of Domestic sized washing machines are installed?is >=8"},"Enter flow rate of Type 8 component  in litres per cycle",null,"Enter a positive number to 2dps"]
["Component details Domestic sized dishwasher"]
["Component details Domestic sized dishwasher",140,{"$f":"CONCATENATE(\"Only display if the answer to \",D$65, \"is >=1\")","v":"Only display if the answer to How many different types of Domestic sized dishwashers are installed?is >=1"},{"$f":"CONCATENATE(\"Enter number of Type 1 \",+'lookup tables'!C$44,\"s installed\")","v":"Enter number of Type 1 Domestic sized dishwasherss installed"},null,"Enter an integer >=1"]
["Component details Domestic sized dishwasher",141,{"$f":"CONCATENATE(\"Only display if the answer to \",D$65, \"is >=1\")","v":"Only display if the answer to How many different types of Domestic sized dishwashers are installed?is >=1"},"Enter flow rate of Type 1 component  in litres per cycle",null,"Enter a positive number to 2dps"]
["Component details Domestic sized dishwasher",142,{"$f":"CONCATENATE(\"Only display if the answer to \",D$65, \"is >=2\")","v":"Only display if the answer to How many different types of Domestic sized dishwashers are installed?is >=2"},{"$f":"CONCATENATE(\"Enter number of Type 2 \",+'lookup tables'!C$44,\"s installed\")","v":"Enter number of Type 2 Domestic sized dishwasherss installed"},null,"Enter an integer >=1"]
["Component details Domestic sized dishwasher",143,{"$f":"CONCATENATE(\"Only display if the answer to \",D$65, \"is >=2\")","v":"Only display if the answer to How many different types of Domestic sized dishwashers are installed?is >=2"},"Enter flow rate of Type 2 component  in litres per cycle",null,"Enter a positive number to 2dps"]
["Component details Domestic sized dishwasher",144,{"$f":"CONCATENATE(\"Only display if the answer to \",D$65, \"is >=3\")","v":"Only display if the answer to How many different types of Domestic sized dishwashers are installed?is >=3"},{"$f":"CONCATENATE(\"Enter number of Type 3 \",+'lookup tables'!C$44,\"s installed\")","v":"Enter number of Type 3 Domestic sized dishwasherss installed"},null,"Enter an integer >=1"]
["Component details Domestic sized dishwasher",145,{"$f":"CONCATENATE(\"Only display if the answer to \",D$65, \"is >=3\")","v":"Only display if the answer to How many different types of Domestic sized dishwashers are installed?is >=3"},"Enter flow rate of Type 3 component  in litres per cycle",null,"Enter a positive number to 2dps"]
["Component details Domestic sized dishwasher",146,{"$f":"CONCATENATE(\"Only display if the answer to \",D$65, \"is >=4\")","v":"Only display if the answer to How many different types of Domestic sized dishwashers are installed?is >=4"},{"$f":"CONCATENATE(\"Enter number of Type 4 \",+'lookup tables'!C$44,\"s installed\")","v":"Enter number of Type 4 Domestic sized dishwasherss installed"},null,"Enter an integer >=1"]
["Component details Domestic sized dishwasher",147,{"$f":"CONCATENATE(\"Only display if the answer to \",D$65, \"is >=4\")","v":"Only display if the answer to How many different types of Domestic sized dishwashers are installed?is >=4"},"Enter flow rate of Type 4 component  in litres per cycle",null,"Enter a positive number to 2dps"]
["Component details Domestic sized dishwasher",148,{"$f":"CONCATENATE(\"Only display if the answer to \",D$65, \"is >=5\")","v":"Only display if the answer to How many different types of Domestic sized dishwashers are installed?is >=5"},{"$f":"CONCATENATE(\"Enter number of Type 5 \",+'lookup tables'!C$44,\"s installed\")","v":"Enter number of Type 5 Domestic sized dishwasherss installed"},null,"Enter an integer >=1"]
["Component details Domestic sized dishwasher",149,{"$f":"CONCATENATE(\"Only display if the answer to \",D$65, \"is >=5\")","v":"Only display if the answer to How many different types of Domestic sized dishwashers are installed?is >=5"},"Enter flow rate of Type 5 component  in litres per cycle",null,"Enter a positive number to 2dps"]
["Component details Domestic sized dishwasher",150,{"$f":"CONCATENATE(\"Only display if the answer to \",D$65, \"is >=6\")","v":"Only display if the answer to How many different types of Domestic sized dishwashers are installed?is >=6"},{"$f":"CONCATENATE(\"Enter number of Type 6 \",+'lookup tables'!C$44,\"s installed\")","v":"Enter number of Type 6 Domestic sized dishwasherss installed"},null,"Enter an integer >=1"]
["Component details Domestic sized dishwasher",151,{"$f":"CONCATENATE(\"Only display if the answer to \",D$65, \"is >=6\")","v":"Only display if the answer to How many different types of Domestic sized dishwashers are installed?is >=6"},"Enter flow rate of Type 6 component  in litres per cycle",null,"Enter a positive number to 2dps"]
["Component details Domestic sized dishwasher",152,{"$f":"CONCATENATE(\"Only display if the answer to \",D$65, \"is >=7\")","v":"Only display if the answer to How many different types of Domestic sized dishwashers are installed?is >=7"},{"$f":"CONCATENATE(\"Enter number of Type 7 \",+'lookup tables'!C$44,\"s installed\")","v":"Enter number of Type 7 Domestic sized dishwasherss installed"},null,"Enter an integer >=1"]
["Component details Domestic sized dishwasher",153,{"$f":"CONCATENATE(\"Only display if the answer to \",D$65, \"is >=7\")","v":"Only display if the answer to How many different types of Domestic sized dishwashers are installed?is >=7"},"Enter flow rate of Type 7 component  in litres per cycle",null,"Enter a positive number to 2dps"]
["Component details Domestic sized dishwasher",154,{"$f":"CONCATENATE(\"Only display if the answer to \",D$65, \"is >=8\")","v":"Only display if the answer to How many different types of Domestic sized dishwashers are installed?is >=8"},{"$f":"CONCATENATE(\"Enter number of Type 8 \",+'lookup tables'!C$44,\"s installed\")","v":"Enter number of Type 8 Domestic sized dishwasherss installed"},null,"Enter an integer >=1"]
["Component details Domestic sized dishwasher",155,{"$f":"CONCATENATE(\"Only display if the answer to \",D$65, \"is >=8\")","v":"Only display if the answer to How many different types of Domestic sized dishwashers are installed?is >=8"},"Enter flow rate of Type 8 component  in litres per cycle",null,"Enter a positive number to 2dps"]
["Component details Kitchen taps: restaurant (pre-rinse nozzles only)"]
["Component details Kitchen taps: restaurant (pre-rinse nozzles only)",156,{"$f":"CONCATENATE(\"Only display if the answer to \",D$66, \"is >=1\")","v":"Only display if the answer to How many different types of Kitchen taps: restaurant (pre-rinse nozzles only) are installed?is >=1"},{"$f":"CONCATENATE(\"Enter number of Type 1 \",+'lookup tables'!C$45,\"s installed\")","v":"Enter number of Type 1 Kitchen taps: restaurant (pre-rinse nozzles only)s installed"},null,"Enter an integer >=1"]
["Component details Kitchen taps: restaurant (pre-rinse nozzles only)",157,{"$f":"CONCATENATE(\"Only display if the answer to \",D$66, \"is >=1\")","v":"Only display if the answer to How many different types of Kitchen taps: restaurant (pre-rinse nozzles only) are installed?is >=1"},"Enter flow rate of Type 1 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Kitchen taps: restaurant (pre-rinse nozzles only)",158,{"$f":"CONCATENATE(\"Only display if the answer to \",D$66, \"is >=2\")","v":"Only display if the answer to How many different types of Kitchen taps: restaurant (pre-rinse nozzles only) are installed?is >=2"},{"$f":"CONCATENATE(\"Enter number of Type 2 \",+'lookup tables'!C$45,\"s installed\")","v":"Enter number of Type 2 Kitchen taps: restaurant (pre-rinse nozzles only)s installed"},null,"Enter an integer >=1"]
["Component details Kitchen taps: restaurant (pre-rinse nozzles only)",159,{"$f":"CONCATENATE(\"Only display if the answer to \",D$66, \"is >=2\")","v":"Only display if the answer to How many different types of Kitchen taps: restaurant (pre-rinse nozzles only) are installed?is >=2"},"Enter flow rate of Type 2 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Kitchen taps: restaurant (pre-rinse nozzles only)",160,{"$f":"CONCATENATE(\"Only display if the answer to \",D$66, \"is >=3\")","v":"Only display if the answer to How many different types of Kitchen taps: restaurant (pre-rinse nozzles only) are installed?is >=3"},{"$f":"CONCATENATE(\"Enter number of Type 3 \",+'lookup tables'!C$45,\"s installed\")","v":"Enter number of Type 3 Kitchen taps: restaurant (pre-rinse nozzles only)s installed"},null,"Enter an integer >=1"]
["Component details Kitchen taps: restaurant (pre-rinse nozzles only)",161,{"$f":"CONCATENATE(\"Only display if the answer to \",D$66, \"is >=3\")","v":"Only display if the answer to How many different types of Kitchen taps: restaurant (pre-rinse nozzles only) are installed?is >=3"},"Enter flow rate of Type 3 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Kitchen taps: restaurant (pre-rinse nozzles only)",162,{"$f":"CONCATENATE(\"Only display if the answer to \",D$66, \"is >=4\")","v":"Only display if the answer to How many different types of Kitchen taps: restaurant (pre-rinse nozzles only) are installed?is >=4"},{"$f":"CONCATENATE(\"Enter number of Type 4 \",+'lookup tables'!C$45,\"s installed\")","v":"Enter number of Type 4 Kitchen taps: restaurant (pre-rinse nozzles only)s installed"},null,"Enter an integer >=1"]
["Component details Kitchen taps: restaurant (pre-rinse nozzles only)",163,{"$f":"CONCATENATE(\"Only display if the answer to \",D$66, \"is >=4\")","v":"Only display if the answer to How many different types of Kitchen taps: restaurant (pre-rinse nozzles only) are installed?is >=4"},"Enter flow rate of Type 4 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Kitchen taps: restaurant (pre-rinse nozzles only)",164,{"$f":"CONCATENATE(\"Only display if the answer to \",D$66, \"is >=5\")","v":"Only display if the answer to How many different types of Kitchen taps: restaurant (pre-rinse nozzles only) are installed?is >=5"},{"$f":"CONCATENATE(\"Enter number of Type 5 \",+'lookup tables'!C$45,\"s installed\")","v":"Enter number of Type 5 Kitchen taps: restaurant (pre-rinse nozzles only)s installed"},null,"Enter an integer >=1"]
["Component details Kitchen taps: restaurant (pre-rinse nozzles only)",165,{"$f":"CONCATENATE(\"Only display if the answer to \",D$66, \"is >=5\")","v":"Only display if the answer to How many different types of Kitchen taps: restaurant (pre-rinse nozzles only) are installed?is >=5"},"Enter flow rate of Type 5 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Kitchen taps: restaurant (pre-rinse nozzles only)",166,{"$f":"CONCATENATE(\"Only display if the answer to \",D$66, \"is >=6\")","v":"Only display if the answer to How many different types of Kitchen taps: restaurant (pre-rinse nozzles only) are installed?is >=6"},{"$f":"CONCATENATE(\"Enter number of Type 6 \",+'lookup tables'!C$45,\"s installed\")","v":"Enter number of Type 6 Kitchen taps: restaurant (pre-rinse nozzles only)s installed"},null,"Enter an integer >=1"]
["Component details Kitchen taps: restaurant (pre-rinse nozzles only)",167,{"$f":"CONCATENATE(\"Only display if the answer to \",D$66, \"is >=6\")","v":"Only display if the answer to How many different types of Kitchen taps: restaurant (pre-rinse nozzles only) are installed?is >=6"},"Enter flow rate of Type 6 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Kitchen taps: restaurant (pre-rinse nozzles only)",168,{"$f":"CONCATENATE(\"Only display if the answer to \",D$66, \"is >=7\")","v":"Only display if the answer to How many different types of Kitchen taps: restaurant (pre-rinse nozzles only) are installed?is >=7"},{"$f":"CONCATENATE(\"Enter number of Type 7 \",+'lookup tables'!C$45,\"s installed\")","v":"Enter number of Type 7 Kitchen taps: restaurant (pre-rinse nozzles only)s installed"},null,"Enter an integer >=1"]
["Component details Kitchen taps: restaurant (pre-rinse nozzles only)",169,{"$f":"CONCATENATE(\"Only display if the answer to \",D$66, \"is >=7\")","v":"Only display if the answer to How many different types of Kitchen taps: restaurant (pre-rinse nozzles only) are installed?is >=7"},"Enter flow rate of Type 7 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Kitchen taps: restaurant (pre-rinse nozzles only)",170,{"$f":"CONCATENATE(\"Only display if the answer to \",D$66, \"is >=8\")","v":"Only display if the answer to How many different types of Kitchen taps: restaurant (pre-rinse nozzles only) are installed?is >=8"},{"$f":"CONCATENATE(\"Enter number of Type 8 \",+'lookup tables'!C$45,\"s installed\")","v":"Enter number of Type 8 Kitchen taps: restaurant (pre-rinse nozzles only)s installed"},null,"Enter an integer >=1"]
["Component details Kitchen taps: restaurant (pre-rinse nozzles only)",171,{"$f":"CONCATENATE(\"Only display if the answer to \",D$66, \"is >=8\")","v":"Only display if the answer to How many different types of Kitchen taps: restaurant (pre-rinse nozzles only) are installed?is >=8"},"Enter flow rate of Type 8 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Waste disposal unit (commercial kitchens only)"]
["Component details Waste disposal unit (commercial kitchens only)",172,{"$f":"CONCATENATE(\"Only display if the answer to \",D$67, \"is >=1\")","v":"Only display if the answer to How many different types of Waste disposal unit (commercial kitchens only) are installed?is >=1"},{"$f":"CONCATENATE(\"Enter number of Type 1 \",+'Activity database from wat 01'!B121,\"s installed\")","v":"Enter number of Type 1 Waste disposal unit (commercial kitchens only)s installed"},null,"Enter an integer >=1"]
["Component details Waste disposal unit (commercial kitchens only)",173,{"$f":"CONCATENATE(\"Only display if the answer to \",D$67, \"is >=1\")","v":"Only display if the answer to How many different types of Waste disposal unit (commercial kitchens only) are installed?is >=1"},"Enter flow rate of Type 1 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Waste disposal unit (commercial kitchens only)",174,{"$f":"CONCATENATE(\"Only display if the answer to \",D$67, \"is >=2\")","v":"Only display if the answer to How many different types of Waste disposal unit (commercial kitchens only) are installed?is >=2"},{"$f":"CONCATENATE(\"Enter number of Type 2 \",+'Activity database from wat 01'!B$121,\"s installed\")","v":"Enter number of Type 2 Waste disposal unit (commercial kitchens only)s installed"},null,"Enter an integer >=1"]
["Component details Waste disposal unit (commercial kitchens only)",175,{"$f":"CONCATENATE(\"Only display if the answer to \",D$67, \"is >=2\")","v":"Only display if the answer to How many different types of Waste disposal unit (commercial kitchens only) are installed?is >=2"},"Enter flow rate of Type 2 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Waste disposal unit (commercial kitchens only)",176,{"$f":"CONCATENATE(\"Only display if the answer to \",D$67, \"is >=3\")","v":"Only display if the answer to How many different types of Waste disposal unit (commercial kitchens only) are installed?is >=3"},{"$f":"CONCATENATE(\"Enter number of Type 3 \",+'Activity database from wat 01'!B$121,\"s installed\")","v":"Enter number of Type 3 Waste disposal unit (commercial kitchens only)s installed"},null,"Enter an integer >=1"]
["Component details Waste disposal unit (commercial kitchens only)",177,{"$f":"CONCATENATE(\"Only display if the answer to \",D$67, \"is >=3\")","v":"Only display if the answer to How many different types of Waste disposal unit (commercial kitchens only) are installed?is >=3"},"Enter flow rate of Type 3 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Waste disposal unit (commercial kitchens only)",178,{"$f":"CONCATENATE(\"Only display if the answer to \",D$67, \"is >=4\")","v":"Only display if the answer to How many different types of Waste disposal unit (commercial kitchens only) are installed?is >=4"},{"$f":"CONCATENATE(\"Enter number of Type 4 \",+'Activity database from wat 01'!B$121,\"s installed\")","v":"Enter number of Type 4 Waste disposal unit (commercial kitchens only)s installed"},null,"Enter an integer >=1"]
["Component details Waste disposal unit (commercial kitchens only)",179,{"$f":"CONCATENATE(\"Only display if the answer to \",D$67, \"is >=4\")","v":"Only display if the answer to How many different types of Waste disposal unit (commercial kitchens only) are installed?is >=4"},"Enter flow rate of Type 4 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Waste disposal unit (commercial kitchens only)",180,{"$f":"CONCATENATE(\"Only display if the answer to \",D$67, \"is >=5\")","v":"Only display if the answer to How many different types of Waste disposal unit (commercial kitchens only) are installed?is >=5"},{"$f":"CONCATENATE(\"Enter number of Type 5 \",+'Activity database from wat 01'!B$121,\"s installed\")","v":"Enter number of Type 5 Waste disposal unit (commercial kitchens only)s installed"},null,"Enter an integer >=1"]
["Component details Waste disposal unit (commercial kitchens only)",181,{"$f":"CONCATENATE(\"Only display if the answer to \",D$67, \"is >=5\")","v":"Only display if the answer to How many different types of Waste disposal unit (commercial kitchens only) are installed?is >=5"},"Enter flow rate of Type 5 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Waste disposal unit (commercial kitchens only)",182,{"$f":"CONCATENATE(\"Only display if the answer to \",D$67, \"is >=6\")","v":"Only display if the answer to How many different types of Waste disposal unit (commercial kitchens only) are installed?is >=6"},{"$f":"CONCATENATE(\"Enter number of Type 6 \",+'Activity database from wat 01'!B$121,\"s installed\")","v":"Enter number of Type 6 Waste disposal unit (commercial kitchens only)s installed"},null,"Enter an integer >=1"]
["Component details Waste disposal unit (commercial kitchens only)",183,{"$f":"CONCATENATE(\"Only display if the answer to \",D$67, \"is >=6\")","v":"Only display if the answer to How many different types of Waste disposal unit (commercial kitchens only) are installed?is >=6"},"Enter flow rate of Type 6 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Waste disposal unit (commercial kitchens only)",184,{"$f":"CONCATENATE(\"Only display if the answer to \",D$67, \"is >=7\")","v":"Only display if the answer to How many different types of Waste disposal unit (commercial kitchens only) are installed?is >=7"},{"$f":"CONCATENATE(\"Enter number of Type 7 \",+'Activity database from wat 01'!B$121,\"s installed\")","v":"Enter number of Type 7 Waste disposal unit (commercial kitchens only)s installed"},null,"Enter an integer >=1"]
["Component details Waste disposal unit (commercial kitchens only)",185,{"$f":"CONCATENATE(\"Only display if the answer to \",D$67, \"is >=7\")","v":"Only display if the answer to How many different types of Waste disposal unit (commercial kitchens only) are installed?is >=7"},"Enter flow rate of Type 7 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Waste disposal unit (commercial kitchens only)",186,{"$f":"CONCATENATE(\"Only display if the answer to \",D$67, \"is >=8\")","v":"Only display if the answer to How many different types of Waste disposal unit (commercial kitchens only) are installed?is >=8"},{"$f":"CONCATENATE(\"Enter number of Type 8 \",+'Activity database from wat 01'!B$121,\"s installed\")","v":"Enter number of Type 8 Waste disposal unit (commercial kitchens only)s installed"},null,"Enter an integer >=1"]
["Component details Waste disposal unit (commercial kitchens only)",187,{"$f":"CONCATENATE(\"Only display if the answer to \",D$67, \"is >=8\")","v":"Only display if the answer to How many different types of Waste disposal unit (commercial kitchens only) are installed?is >=8"},"Enter flow rate of Type 8 component  in litres per minute",null,"Enter a positive number to 2dps"]
["Component details Commercial sized dishwasher"]
["Component details Commercial sized dishwasher",188,{"$f":"CONCATENATE(\"Only display if the answer to \",D$68, \"is >=1\")","v":"Only display if the answer to How many different types of Commercial sized dishwashers are installed?is >=1"},{"$f":"CONCATENATE(\"Enter number of Type 1 \",+'Activity database from wat 01'!B122,\"s installed\")","v":"Enter number of Type 1 Commercial sized dishwasherss installed"},null,"Enter an integer >=1"]
["Component details Commercial sized dishwasher",189,{"$f":"CONCATENATE(\"Only display if the answer to \",D$68, \"is >=1\")","v":"Only display if the answer to How many different types of Commercial sized dishwashers are installed?is >=1"},"Enter water consumption of Type 1 component  in litres per rack",null,"Enter a positive number to 2dps"]
["Component details Commercial sized dishwasher",190,{"$f":"CONCATENATE(\"Only display if the answer to \",D$68, \"is >=2\")","v":"Only display if the answer to How many different types of Commercial sized dishwashers are installed?is >=2"},{"$f":"CONCATENATE(\"Enter number of Type 2 \",+'Activity database from wat 01'!B$122,\"s installed\")","v":"Enter number of Type 2 Commercial sized dishwasherss installed"},null,"Enter an integer >=1"]
["Component details Commercial sized dishwasher",191,{"$f":"CONCATENATE(\"Only display if the answer to \",D$68, \"is >=2\")","v":"Only display if the answer to How many different types of Commercial sized dishwashers are installed?is >=2"},"Enter water consumption of Type 2 component  in litres per rack",null,"Enter a positive number to 2dps"]
["Component details Commercial sized dishwasher",192,{"$f":"CONCATENATE(\"Only display if the answer to \",D$68, \"is >=3\")","v":"Only display if the answer to How many different types of Commercial sized dishwashers are installed?is >=3"},{"$f":"CONCATENATE(\"Enter number of Type 3 \",+'Activity database from wat 01'!B$122,\"s installed\")","v":"Enter number of Type 3 Commercial sized dishwasherss installed"},null,"Enter an integer >=1"]
["Component details Commercial sized dishwasher",193,{"$f":"CONCATENATE(\"Only display if the answer to \",D$68, \"is >=3\")","v":"Only display if the answer to How many different types of Commercial sized dishwashers are installed?is >=3"},"Enter water consumption of Type 3 component  in litres per rack",null,"Enter a positive number to 2dps"]
["Component details Commercial sized dishwasher",194,{"$f":"CONCATENATE(\"Only display if the answer to \",D$68, \"is >=4\")","v":"Only display if the answer to How many different types of Commercial sized dishwashers are installed?is >=4"},{"$f":"CONCATENATE(\"Enter number of Type 4 \",+'Activity database from wat 01'!B$122,\"s installed\")","v":"Enter number of Type 4 Commercial sized dishwasherss installed"},null,"Enter an integer >=1"]
["Component details Commercial sized dishwasher",195,{"$f":"CONCATENATE(\"Only display if the answer to \",D$68, \"is >=4\")","v":"Only display if the answer to How many different types of Commercial sized dishwashers are installed?is >=4"},"Enter water consumption of Type 4 component  in litres per rack",null,"Enter a positive number to 2dps"]
["Component details Commercial sized dishwasher",196,{"$f":"CONCATENATE(\"Only display if the answer to \",D$68, \"is >=5\")","v":"Only display if the answer to How many different types of Commercial sized dishwashers are installed?is >=5"},{"$f":"CONCATENATE(\"Enter number of Type 5 \",+'Activity database from wat 01'!B$122,\"s installed\")","v":"Enter number of Type 5 Commercial sized dishwasherss installed"},null,"Enter an integer >=1"]
["Component details Commercial sized dishwasher",197,{"$f":"CONCATENATE(\"Only display if the answer to \",D$68, \"is >=5\")","v":"Only display if the answer to How many different types of Commercial sized dishwashers are installed?is >=5"},"Enter water consumption of Type 5 component  in litres per rack",null,"Enter a positive number to 2dps"]
["Component details Commercial sized dishwasher",198,{"$f":"CONCATENATE(\"Only display if the answer to \",D$68, \"is >=6\")","v":"Only display if the answer to How many different types of Commercial sized dishwashers are installed?is >=6"},{"$f":"CONCATENATE(\"Enter number of Type 6 \",+'Activity database from wat 01'!B$122,\"s installed\")","v":"Enter number of Type 6 Commercial sized dishwasherss installed"},null,"Enter an integer >=1"]
["Component details Commercial sized dishwasher",199,{"$f":"CONCATENATE(\"Only display if the answer to \",D$68, \"is >=6\")","v":"Only display if the answer to How many different types of Commercial sized dishwashers are installed?is >=6"},"Enter water consumption of Type 6 component  in litres per rack",null,"Enter a positive number to 2dps"]
["Component details Commercial sized dishwasher",200,{"$f":"CONCATENATE(\"Only display if the answer to \",D$68, \"is >=7\")","v":"Only display if the answer to How many different types of Commercial sized dishwashers are installed?is >=7"},{"$f":"CONCATENATE(\"Enter number of Type 7 \",+'Activity database from wat 01'!B$122,\"s installed\")","v":"Enter number of Type 7 Commercial sized dishwasherss installed"},null,"Enter an integer >=1"]
["Component details Commercial sized dishwasher",201,{"$f":"CONCATENATE(\"Only display if the answer to \",D$68, \"is >=7\")","v":"Only display if the answer to How many different types of Commercial sized dishwashers are installed?is >=7"},"Enter water consumption of Type 7 component  in litres per rack",null,"Enter a positive number to 2dps"]
["Component details Commercial sized dishwasher",202,{"$f":"CONCATENATE(\"Only display if the answer to \",D$68, \"is >=8\")","v":"Only display if the answer to How many different types of Commercial sized dishwashers are installed?is >=8"},{"$f":"CONCATENATE(\"Enter number of Type 8 \",+'Activity database from wat 01'!B$122,\"s installed\")","v":"Enter number of Type 8 Commercial sized dishwasherss installed"},null,"Enter an integer >=1"]
["Component details Commercial sized dishwasher",203,{"$f":"CONCATENATE(\"Only display if the answer to \",D$68, \"is >=8\")","v":"Only display if the answer to How many different types of Commercial sized dishwashers are installed?is >=8"},"Enter water consumption of Type 8 component  in litres per rack",null,"Enter a positive number to 2dps"]
["Component details Commercial sized industrial sized washing machine"]
["Component details Commercial sized industrial sized washing machine",204,{"$f":"CONCATENATE(\"Only display if the answer to \",D$69, \"is >=1\")","v":"Only display if the answer to How many different types of Commercial or industrial sized washing machines are installed?is >=1"},{"$f":"CONCATENATE(\"Enter number of Type 1 \",+'Activity database from wat 01'!B$123,\"s installed\")","v":"Enter number of Type 1 Commercial/Industrial sized washing machiness installed"},null,"Enter an integer >=1"]
["Component details Commercial sized industrial sized washing machine",205,{"$f":"CONCATENATE(\"Only display if the answer to \",D$69, \"is >=1\")","v":"Only display if the answer to How many different types of Commercial or industrial sized washing machines are installed?is >=1"},"Enter water consumption of Type 1 component  in litres per kg",null,"Enter a positive number to 2dps"]
["Component details Commercial sized industrial sized washing machine",206,{"$f":"CONCATENATE(\"Only display if the answer to \",D$69, \"is >=2\")","v":"Only display if the answer to How many different types of Commercial or industrial sized washing machines are installed?is >=2"},{"$f":"CONCATENATE(\"Enter number of Type 2 \",+'Activity database from wat 01'!B$123,\"s installed\")","v":"Enter number of Type 2 Commercial/Industrial sized washing machiness installed"},null,"Enter an integer >=1"]
["Component details Commercial sized industrial sized washing machine",207,{"$f":"CONCATENATE(\"Only display if the answer to \",D$69, \"is >=2\")","v":"Only display if the answer to How many different types of Commercial or industrial sized washing machines are installed?is >=2"},"Enter water consumption of Type 2 component  in litres per kg",null,"Enter a positive number to 2dps"]
["Component details Commercial sized industrial sized washing machine",208,{"$f":"CONCATENATE(\"Only display if the answer to \",D$69, \"is >=3\")","v":"Only display if the answer to How many different types of Commercial or industrial sized washing machines are installed?is >=3"},{"$f":"CONCATENATE(\"Enter number of Type 3 \",+'Activity database from wat 01'!B$123,\"s installed\")","v":"Enter number of Type 3 Commercial/Industrial sized washing machiness installed"},null,"Enter an integer >=1"]
["Component details Commercial sized industrial sized washing machine",209,{"$f":"CONCATENATE(\"Only display if the answer to \",D$69, \"is >=3\")","v":"Only display if the answer to How many different types of Commercial or industrial sized washing machines are installed?is >=3"},"Enter water consumption of Type 3 component  in litres per kg",null,"Enter a positive number to 2dps"]
["Component details Commercial sized industrial sized washing machine",210,{"$f":"CONCATENATE(\"Only display if the answer to \",D$69, \"is >=4\")","v":"Only display if the answer to How many different types of Commercial or industrial sized washing machines are installed?is >=4"},{"$f":"CONCATENATE(\"Enter number of Type 4 \",+'Activity database from wat 01'!B$123,\"s installed\")","v":"Enter number of Type 4 Commercial/Industrial sized washing machiness installed"},null,"Enter an integer >=1"]
["Component details Commercial sized industrial sized washing machine",211,{"$f":"CONCATENATE(\"Only display if the answer to \",D$69, \"is >=4\")","v":"Only display if the answer to How many different types of Commercial or industrial sized washing machines are installed?is >=4"},"Enter water consumption of Type 4 component  in litres per kg",null,"Enter a positive number to 2dps"]
["Component details Commercial sized industrial sized washing machine",212,{"$f":"CONCATENATE(\"Only display if the answer to \",D$69, \"is >=5\")","v":"Only display if the answer to How many different types of Commercial or industrial sized washing machines are installed?is >=5"},{"$f":"CONCATENATE(\"Enter number of Type 5 \",+'Activity database from wat 01'!B$123,\"s installed\")","v":"Enter number of Type 5 Commercial/Industrial sized washing machiness installed"},null,"Enter an integer >=1"]
["Component details Commercial sized industrial sized washing machine",213,{"$f":"CONCATENATE(\"Only display if the answer to \",D$69, \"is >=5\")","v":"Only display if the answer to How many different types of Commercial or industrial sized washing machines are installed?is >=5"},"Enter water consumption of Type 5 component  in litres per kg",null,"Enter a positive number to 2dps"]
["Component details Commercial sized industrial sized washing machine",214,{"$f":"CONCATENATE(\"Only display if the answer to \",D$69, \"is >=6\")","v":"Only display if the answer to How many different types of Commercial or industrial sized washing machines are installed?is >=6"},{"$f":"CONCATENATE(\"Enter number of Type 6 \",+'Activity database from wat 01'!B$123,\"s installed\")","v":"Enter number of Type 6 Commercial/Industrial sized washing machiness installed"},null,"Enter an integer >=1"]
["Component details Commercial sized industrial sized washing machine",215,{"$f":"CONCATENATE(\"Only display if the answer to \",D$69, \"is >=6\")","v":"Only display if the answer to How many different types of Commercial or industrial sized washing machines are installed?is >=6"},"Enter water consumption of Type 6 component  in litres per kg",null,"Enter a positive number to 2dps"]
["Component details Commercial sized industrial sized washing machine",216,{"$f":"CONCATENATE(\"Only display if the answer to \",D$69, \"is >=7\")","v":"Only display if the answer to How many different types of Commercial or industrial sized washing machines are installed?is >=7"},{"$f":"CONCATENATE(\"Enter number of Type 7 \",+'Activity database from wat 01'!B$123,\"s installed\")","v":"Enter number of Type 7 Commercial/Industrial sized washing machiness installed"},null,"Enter an integer >=1"]
["Component details Commercial sized industrial sized washing machine",217,{"$f":"CONCATENATE(\"Only display if the answer to \",D$69, \"is >=7\")","v":"Only display if the answer to How many different types of Commercial or industrial sized washing machines are installed?is >=7"},"Enter water consumption of Type 7 component  in litres per kg",null,"Enter a positive number to 2dps"]
["Component details Commercial sized industrial sized washing machine",218,{"$f":"CONCATENATE(\"Only display if the answer to \",D$69, \"is >=8\")","v":"Only display if the answer to How many different types of Commercial or industrial sized washing machines are installed?is >=8"},{"$f":"CONCATENATE(\"Enter number of Type 8 \",+'Activity database from wat 01'!B$123,\"s installed\")","v":"Enter number of Type 8 Commercial/Industrial sized washing machiness installed"},null,"Enter an integer >=1"]
["Component details Commercial sized industrial sized washing machine",219,{"$f":"CONCATENATE(\"Only display if the answer to \",D$69, \"is >=8\")","v":"Only display if the answer to How many different types of Commercial or industrial sized washing machines are installed?is >=8"},"Enter water consumption of Type 8 component  in litres per kg",null,"Enter a positive number to 2dps"]
["Checkpoint",null,"All previously displayed questions need to be answered for water using components and Types indicated",null," If check point condition is not met display \"Please enter details for all water components present\""]
["Grey water and blackwater collection"]
["Grey and black water collection",220,"Mandatory","Does the building collect any grey water or black water?","No","Select yes or no"]
["Grey and black water collection",221,"only display if the answer to Does the building use any grey water or black water is yes",{"$f":"CONCATENATE(\"Is black water collected from \",+calculation!$D22,\"s?\")","v":"Is black water collected from WCs?"},null,"Select yes or no"]
["Grey and black water collection",222,{"$f":"CONCATENATE(\"only display if the answer to \",+D305,\"  is yes\")","v":"only display if the answer to Is black water collected from WCs?  is yes"},"From what % of components is black water collected?",null,"Enter a % between 0-100%"]
["Grey and black water collection",223,"only display if the answer to Does the building use any grey water or black water is yes",{"$f":"CONCATENATE(\"Is black water collected from \",+calculation!$D23,\"s?\")","v":"Is black water collected from Urinal timed flushs?"},null,"Select yes or no"]
["Grey and black water collection",null,{"$f":"CONCATENATE(\"only display if the answer to \",+D307,\"  is yes\")","v":"only display if the answer to Is black water collected from Urinal timed flushs?  is yes"},"From what % of components is black water collected?",null,"Enter a % between 0-100%"]
["Grey and black water collection",null,"only display if the answer to Does the building use any grey water or black water is yes",{"$f":"CONCATENATE(\"Is black water collected from \",+calculation!$D24,\"s?\")","v":"Is black water collected from Urinal automatic sensor flushs?"},null,"Select yes or no"]
["Grey and black water collection",null,{"$f":"CONCATENATE(\"only display if the answer to \",+D309,\"  is yes\")","v":"only display if the answer to Is black water collected from Urinal automatic sensor flushs?  is yes"},"From what % of components is black water collected?",null,"Enter a % between 0-100%"]
["Grey and black water collection",null,"only display if the answer to Does the building use any grey water or black water is yes",{"$f":"CONCATENATE(\"Is black water collected from \",+calculation!$D25,\"s?\")","v":"Is black water collected from Urinal waterlesss?"},null,"Select yes or no"]
["Grey and black water collection",null,{"$f":"CONCATENATE(\"only display if the answer to \",+D311,\"  is yes\")","v":"only display if the answer to Is black water collected from Urinal waterlesss?  is yes"},"From what % of components is black water collected?",null,"Enter a % between 0-100%"]
["Grey and black water collection",null,"only display if the answer to Does the building use any grey water or black water is yes",{"$f":"CONCATENATE(\"Is grey water collected from \",+calculation!$D26,\"s?\")","v":"Is grey water collected from Wash hand basin taps?"},null,"Select yes or no"]
["Grey and black water collection",225,{"$f":"CONCATENATE(\"only display if the answer to \",+D313,\"  is yes\")","v":"only display if the answer to Is grey water collected from Wash hand basin taps?  is yes"},"From what % of components is grey water collected?",null,"Enter a % between 0-100%"]
["Grey and black water collection",226,"only display if the answer to Does the building use any grey water or black water is yes",{"$f":"CONCATENATE(\"Is grey water collected from \",+calculation!$D27,\"s?\")","v":"Is grey water collected from Showers?"},null,"Select yes or no"]
["Grey and black water collection",227,{"$f":"CONCATENATE(\"only display if the answer to \",+D315,\"  is yes\")","v":"only display if the answer to Is grey water collected from Showers?  is yes"},"From what % of components is grey water collected?",null,"Enter a % between 0-100%"]
["Grey and black water collection",228,"only display if the answer to Does the building use any grey water or black water is yes",{"$f":"CONCATENATE(\"Is grey water collected from \",+calculation!$D28,\"s?\")","v":"Is grey water collected from Baths?"},null,"Select yes or no"]
["Grey and black water collection",229,{"$f":"CONCATENATE(\"only display if the answer to \",+D317,\"  is yes\")","v":"only display if the answer to Is grey water collected from Baths?  is yes"},"From what % of components is grey water collected?",null,"Enter a % between 0-100%"]
["Grey and black water collection",230,"only display if the answer to Does the building use any grey water or black water is yes",{"$f":"CONCATENATE(\"Is grey water collected from \",+calculation!$D29,\"s?\")","v":"Is grey water collected from Kitchen taps: kitchenettes?"},null,"Select yes or no"]
["Grey and black water collection",231,{"$f":"CONCATENATE(\"only display if the answer to \",+D319,\"  is yes\")","v":"only display if the answer to Is grey water collected from Kitchen taps: kitchenettes?  is yes"},"From what % of components is grey water collected?",null,"Enter a % between 0-100%"]
["Grey and black water collection",232,"only display if the answer to Does the building use any grey water or black water is yes",{"$f":"CONCATENATE(\"Is grey water collected from \",+calculation!$D30,\"s?\")","v":"Is grey water collected from Domestic sized washing machines per cycles?"},null,"Select yes or no"]
["Grey and black water collection",233,{"$f":"CONCATENATE(\"only display if the answer to \",+D321,\"  is yes\")","v":"only display if the answer to Is grey water collected from Domestic sized washing machines per cycles?  is yes"},"From what % of components is grey water collected?",null,"Enter a % between 0-100%"]
["Grey and black water collection",null,"only display if the answer to Does the building use any grey water or black water is yes",{"$f":"CONCATENATE(\"Is grey water collected from \",+calculation!$D31,\"s?\")","v":"Is grey water collected from Domestic sized dishwashers per cycles?"},null,"Select yes or no"]
["Grey and black water collection",null,{"$f":"CONCATENATE(\"only display if the answer to \",+D323,\"  is yes\")","v":"only display if the answer to Is grey water collected from Domestic sized dishwashers per cycles?  is yes"},"From what % of components is grey water collected?",null,"Enter a % between 0-100%"]
["Grey and black water collection",null,"only display if the answer to Does the building use any grey water or black water is yes",{"$f":"CONCATENATE(\"Is grey water collected from \",+calculation!$D32,\"s?\")","v":"Is grey water collected from Kitchen taps: restaurant (pre-rinse nozzles only)s?"},null,"Select yes or no"]
["Grey and black water collection",null,{"$f":"CONCATENATE(\"only display if the answer to \",+D325,\"  is yes\")","v":"only display if the answer to Is grey water collected from Kitchen taps: restaurant (pre-rinse nozzles only)s?  is yes"},"From what % of components is grey water collected?",null,"Enter a % between 0-100%"]
["Grey and black water collection",null,"only display if the answer to Does the building use any grey water or black water is yes",{"$f":"CONCATENATE(\"Is grey water collected from \",+calculation!$D33,\"s?\")","v":"Is grey water collected from Waste disposal unit (commercial kitchens only)s?"},null,"Select yes or no"]
["Grey and black water collection",null,{"$f":"CONCATENATE(\"only display if the answer to \",+D327,\"  is yes\")","v":"only display if the answer to Is grey water collected from Waste disposal unit (commercial kitchens only)s?  is yes"},"From what % of components is grey water collected?",null,"Enter a % between 0-100%"]
["Grey and black water collection",null,"only display if the answer to Does the building use any grey water or black water is yes",{"$f":"CONCATENATE(\"Is grey water collected from \",+calculation!$D34,\"s?\")","v":"Is grey water collected from Commercial sized dishwashers per racks?"},null,"Select yes or no"]
["Grey and black water collection",null,{"$f":"CONCATENATE(\"only display if the answer to \",+D329,\"  is yes\")","v":"only display if the answer to Is grey water collected from Commercial sized dishwashers per racks?  is yes"},"From what % of components is grey water collected?",null,"Enter a % between 0-100%"]
["Checkpoint",null,"All grey and blackwater collection questions need to be answered",null," If check point condition is not met display \"Please answer all grey water and black water collection questions\""]
["Rainwater"]
["Rainwater",null,"Mandatory","Does the building have any rainwater collection?","No","Select yes or no"]
["Rainwater",null,{"$f":"CONCATENATE(\"only display if the answer to \",+D333,\"  is yes\")","v":"only display if the answer to Does the building have any rainwater collection?  is yes"},"Has, or will, the rainwater system be specified and installed in compliance with BS EN 16941-1:2018 Rainwater Harvesting Systems - Code of practice",null,"Select yes or no"]
["Rainwater",null,{"$f":"CONCATENATE(\"only display if the answer to \",+D334,\"  is yes\")","v":"only display if the answer to Has, or will, the rainwater system be specified and installed in compliance with BS EN 16941-1:2018 Rainwater Harvesting Systems - Code of practice  is yes"},"How has the storage capacity for the proposed system been calculated?",null,"Select approach"]
["Rainwater",null,{"$f":"CONCATENATE(\"only display if the answer to \",+D335,\"  is \", 'lookup tables'!A$7)","v":"only display if the answer to How has the storage capacity for the proposed system been calculated?  is BS EN 16941-1:2018 'basic approach'"},"Horizontal projection of the collection area (m²)",null,"Enter a positive number to 2dps"]
["Rainwater",null,{"$f":"+C336","v":"only display if the answer to How has the storage capacity for the proposed system been calculated?  is BS EN 16941-1:2018 'basic approach'"},"Annual rainfall (mm/year)",null,"Enter a positive number to 2dps"]
["Rainwater",null,{"$f":"+C336","v":"only display if the answer to How has the storage capacity for the proposed system been calculated?  is BS EN 16941-1:2018 'basic approach'"},"Hydraulic treatment efficiency coefficient (%)",null,"Enter a % between 0-100%"]
["Rainwater",null,{"$f":"+C338","v":"only display if the answer to How has the storage capacity for the proposed system been calculated?  is BS EN 16941-1:2018 'basic approach'"},"Surface yield coefficient (%)",null,"Enter a % between 0-100%"]
["Rainwater","is that really litres",{"$f":"CONCATENATE(\"only display if the answer to \",+D335,\"  is \", 'lookup tables'!A$8)","v":"only display if the answer to How has the storage capacity for the proposed system been calculated?  is BS EN 16941-1:2018 'detailed approach'"},"Yearly rainfall collection (litres)",null,"Enter a positive number to 2dps"]
["Checkpoint",null,"All previously dispalayed questions need to be answered for grey water collection"]
["Other recycled water sources"]
["Other recycled water sources",null,"Mandatory","Does the building use any other source of recycled water collection?","No","Select yes or no"]
["Other recycled water sources",null,{"$f":"CONCATENATE(\"only display if the answer to \",+D343,\"  is yes\")","v":"only display if the answer to Does the building use any other source of recycled water collection?  is yes"},"Please enter source","No","Free text up to 50 characters"]
["Other recycled water sources",null,{"$f":"+C344","v":"only display if the answer to Does the building use any other source of recycled water collection?  is yes"},"Annual other recycled water used in the buildling m3",null,"Enter a positive number to 2dps"]
["Checkpoint",null,"All previously diplayed question need to be answered for other recycled water sources"]
["Use of recycled water"]
["Use of recycled water",null,"only display if the answer to mandatory grey and black water collection or rainwater or other recycled water sources question is yes","Is recycled water used for WC flushing?","No","Select yes or no"]
["Use of recycled water",null,"only display if the answer to mandatory grey and black water collection or rainwater or other recycled water sources question is yes","what % of WCs use recycled water?",null,"Enter a % between 0-100%"]
["Use of recycled water",null,"only display if the answer to mandatory grey and black water collection or rainwater or other recycled water sources question is yes","Is recycled water used for urinals with timed flushing?",null,"Select yes or no"]
["Use of recycled water",null,"only display if the answer to mandatory grey and black water collection or rainwater or other recycled water sources question is yes","what % of urinals use recycled water?",null,"Enter a % between 0-100%"]
["Use of recycled water",null,"only display if the answer to mandatory grey and black water collection or rainwater or other recycled water sources question is yes","Is recycled water used for urinals with automatic sensor flushing installed)",null,"Select yes or no"]
["Use of recycled water",null,"only display if the answer to mandatory grey and black water collection or rainwater or other recycled water sources question is yes","what % of urinals use recycled water?",null,"Enter a % between 0-100%"]
["Checkpoint",null,"All previously diplayed question need to be answered for use of recycled water",null," If check point condition is not met display \"Please answer all recycled water use wuetions questions\""]
["Sewage connections",null,"This question is required for reporting carbon impacts","Is the building connected to a sewer network","Yes","Select yes or no"]
[]
[]
["Extra toegevoegd omdat de BRE zijn werk niet doet"]
["Grey and black water collection",null,"only display if the answer to Does the building use any grey water or black water is yes",{"$f":"CONCATENATE(\"Is grey water collected from \",+calculation!$D35,\"s?\")","v":"Is grey water collected from Commercial or industrial sized washing machines per kgs?"},null,"Select yes or no"]
["Grey and black water collection",null,{"$f":"CONCATENATE(\"only display if the answer to \",+D359,\"  is yes\")","v":"only display if the answer to Is grey water collected from Commercial or industrial sized washing machines per kgs?  is yes"},"From what % of components is grey water collected?",null,"Enter a % between 0-100%"]

{"sheet":"calculation","index":2,"n_rows":75,"n_cols":33,"rows_kept":75,"cut":false,"hidden":true,"merged":[[19,16,19,23],[19,24,19,31],[52,16,52,23],[52,24,52,31]]}
[]
[]
[null,null,null,"BASELINE","From user data entry","Baseline values * adjustment factor",null,"takes account of alternative options (WC/urinal and shower/bath) and also typical % bath fill and tap full volume","from building type lookup","from building type lookup (for total building or food prepar","from building type lookup","volume* factor*uses per day (div occupant density for fixed uses","lt per person*occupancy density*m2 (Total or food preparation as approprite)","lt/m2*1,000/ occupied days per year","m3/m2/year*m2"]
[null,null,null,null,"number of items","Average water use ltrs","Unit","Adjustment factor","Use per day","occupancy density","occupied days per year","lt per person per day","lt/m2 per day","m3/m2 per year","m3/year"]
["uses per person per day","people related usage",null,"WC",{"$f":"+E22","v":0},{"$f":"+'lookup tables'!D35*H5","v":6},"per use",{"$f":"+H22","v":1},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"J55","v":{"$error":"#DIV/0!"}},{"$f":"+'Front end'!$E$11","v":0},{"$f":"+F5*I5","v":{"$error":"#N/A"}},{"$f":"+J5*L5","v":{"$error":"#DIV/0!"}},{"$f":"+M5/1000*K5","v":{"$error":"#DIV/0!"}},{"$f":"+N5*'Front end'!E$9","v":{"$error":"#DIV/0!"}}]
["uses per person per day","people related usage",null,"Urinals",{"$f":"+E23+E24+E25","v":0},{"$f":"+'Activity database from wat 01'!C113*H6","v":7.5},"per hour",1,{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"J56","v":{"$error":"#DIV/0!"}},{"$f":"+'Front end'!$E$11","v":0},{"$f":"+F6*I6/(J6*'Front end'!$E$9)","v":{"$error":"#N/A"}},{"$f":"+J6*L6","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"+N6*'Front end'!E$9","v":{"$error":"#DIV/0!"}}]
["uses per person per day","people related usage",null,"Wash hand basin tap",{"$f":"+E26","v":0},{"$f":"+'Activity database from wat 01'!C110*H7","v":0},"per use",{"$f":"+H24","v":0},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,8,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$f":"+'Front end'!$E$11","v":0},{"$f":"+F7*I7","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N7*'Front end'!E$9","v":{"$error":"#DIV/0!"}}]
["uses per person per day","people related usage",null,"Shower",0,{"$f":"+'Activity database from wat 01'!C111*calculation!H8","v":0},"per use",0,{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,9,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$f":"+'Front end'!$E$11","v":0},{"$error":"#N/A"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N8*'Front end'!E$9","v":{"$error":"#DIV/0!"}}]
["uses per person per day","people related usage",null,"Bath",0,{"$f":"+'Activity database from wat 01'!C112*calculation!H9","v":0},"per use",0,{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,10,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$f":"+'Front end'!$E$11","v":0},{"$error":"#N/A"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N9*'Front end'!E$9","v":{"$error":"#DIV/0!"}}]
["uses per person per day","people related usage",null,"Kitchen taps: kitchenette",0,{"$f":"+'Activity database from wat 01'!C117*calculation!H10","v":10},"per use",1,{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,11,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$f":"+'Front end'!$E$11","v":0},{"$error":"#N/A"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N10*'Front end'!E$9","v":{"$error":"#DIV/0!"}}]
["uses per person per day","people related usage",null,"Domestic sized washing machines per cycle",0,{"$f":"+'Activity database from wat 01'!C120*calculation!H11","v":36},"per use",{"$f":"+H28","v":0.4},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,12,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$f":"+'Front end'!$E$11","v":0},{"$error":"#N/A"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N11*'Front end'!E$9","v":{"$error":"#DIV/0!"}}]
["uses per person per day","people related usage",null,"Domestic sized dishwashers per cycle",0,{"$f":"+'Activity database from wat 01'!C119*calculation!H12","v":0},"per use",0,{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,13,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$f":"+'Front end'!$E$11","v":0},{"$error":"#N/A"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N12*'Front end'!E$9","v":{"$error":"#DIV/0!"}}]
["uses per day","fixed usage",null,"Kitchen taps: restaurant (pre-rinse nozzles only)",0,{"$f":"+'Activity database from wat 01'!C118*calculation!H13","v":0},"per minute",0,{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$T$30,14,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$f":"+'Front end'!$E$11","v":0},{"$f":"+F13*I13/(J13*'Front end'!$E$9)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N13*'Front end'!E$9","v":{"$error":"#DIV/0!"}}]
["uses per day","fixed usage",null,"Waste disposal unit (commercial kitchens only)",0,{"$f":"+'Activity database from wat 01'!C121*calculation!H14","v":0},"per minute",0,{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$T$30,15,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$f":"+'Front end'!$E$11","v":0},{"$f":"+F14*I14/(J14*'Front end'!$E$9)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N14*'Front end'!E$9","v":{"$error":"#DIV/0!"}}]
["uses per day","fixed usage",null,"Commercial sized dishwashers per rack",0,{"$f":"+'Activity database from wat 01'!C122*calculation!H15","v":0},"per rack",0,{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$T$30,16,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$f":"+'Front end'!$E$11","v":0},{"$f":"+F15*I15/(J15*'Front end'!$E$9)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N15*'Front end'!E$9","v":{"$error":"#DIV/0!"}}]
["uses per day","fixed usage",null,"Commercial or industrial sized washing machines per kg",0,{"$f":"+F35","v":0},"per kg",0,{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$T$30,17,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$f":"+'Front end'!$E$11","v":0},{"$f":"+F16*I16/(J16*'Front end'!$E$9)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N16*'Front end'!E$9","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L3:L16)","v":{"$error":"#N/A"}},{"$f":"SUM(M3:M16)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N3:N16)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(O3:O16)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,"BUILDING Standard occupancy","From user data entry","From user data entry * adjustment factor",null,"takes account of alternative options (WC/urinal and shower/bath) and also typical % bath fill and tap full volume","from building type lookup","from building type lookup (for total building or food prepar","from building type lookup","volume* factor*uses per day (div occupant density for fixed uses","lt per person*occupancy density*m2","lt/m2*1,000/ occupied days per year","m3/m2/year*m2",null,"Number of each type of component",null,null,null,null,null,null,null,"Water consumption for each type of componets (litres per X)",null,null,null,null,null,null,null,"Black water and Grey water recovery rate"]
[null,null,null,null,"number of items","Average water use ltrs","Unit","Adjustment factor","Use per day","occupancy density","occupied days per year","lt per person per day","lt/m2 per day","m3/m2 per year","m3/year",null,"Type 1","Type 2","Type 3","Type 4","Type 5","Type 6","Type 7","Type 8","Type 1","Type 2","Type 3","Type 4","Type 5","Type 6","Type 7","Type 8"]
["uses per person per day","people related usage",null,"WC",{"$f":"SUM(Q22:X22)","v":0},{"$f":"IF(E22=0,0,(SUMPRODUCT(Q22:X22,Y22:AF22)/E22)*H22)","v":0},"per use",{"$f":"IF(SUM(E23:E25)=0,1,+Assumptions!A3)","v":1},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"J5","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$G$30,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"+F22*I22","v":{"$error":"#N/A"}},{"$f":"+J22*L22","v":{"$error":"#DIV/0!"}},{"$f":"+M22/1000*K22","v":{"$error":"#DIV/0!"}},{"$f":"+N22*'Front end'!E$9","v":{"$error":"#DIV/0!"}},null,{"$f":"+'Front end'!E72","v":0},{"$f":"+'Front end'!E75","v":0},{"$f":"+'Front end'!E78","v":0},{"$f":"+'Front end'!E81","v":0},{"$f":"+'Front end'!E84","v":0},{"$f":"+'Front end'!E87","v":0},{"$f":"+'Front end'!E90","v":0},{"$f":"+'Front end'!E93","v":0},{"$f":"(+'Front end'!$E73*1+'Front end'!$E74*3)/4","v":0},{"$f":"(+'Front end'!$E76*1+'Front end'!$E77*3)/4","v":0},{"$f":"(+'Front end'!$E79*1+'Front end'!$E80*3)/4","v":0},{"$f":"(+'Front end'!$E82*1+'Front end'!$E83*3)/4","v":0},{"$f":"(+'Front end'!$E85*1+'Front end'!$E86*3)/4","v":0},{"$f":"(+'Front end'!$E88*1+'Front end'!$E89*3)/4","v":0},{"$f":"(+'Front end'!$E91*1+'Front end'!$E92*3)/4","v":0},{"$f":"(+'Front end'!$E94*1+'Front end'!$E95*3)/4","v":0},{"$f":"+'Front end'!E306*Assumptions!A$8/100","v":0}]
["uses per person per day","people related usage",null,"Urinal timed flush",0,0,"per hour",{"$f":"IF(E23=0,0,E23/SUM(E23:E25))","v":0},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"J6","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$G$30,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"+F23*I23/(J23*'Front end'!$E$9)","v":{"$error":"#N/A"}},{"$f":"+J23*L23","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"+N23*'Front end'!E$9","v":{"$error":"#DIV/0!"}},null,{"$f":"+'Front end'!E97","v":0},{"$f":"+'Front end'!E99","v":0},{"$f":"+'Front end'!E101","v":0},{"$f":"+'Front end'!E103","v":0},{"$f":"+'Front end'!E105","v":0},{"$f":"+'Front end'!E107","v":0},{"$f":"+'Front end'!E109","v":0},{"$f":"+'Front end'!E111","v":0},{"$f":"+'Front end'!E98","v":0},{"$f":"+'Front end'!E100","v":0},{"$f":"+'Front end'!E102","v":0},{"$f":"+'Front end'!E104","v":0},{"$f":"+'Front end'!E106","v":0},{"$f":"+'Front end'!E108","v":0},{"$f":"+'Front end'!E110","v":0},{"$f":"+'Front end'!E112","v":0},{"$f":"+'Front end'!E308/100*Assumptions!A8","v":0}]
["uses per person per day","people related usage",null,"Urinal automatic sensor flush",0,0,"per use",{"$f":"IF(E24=0,0,E24/SUM(E23:E25))","v":0},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,7,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$G$30,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"+F24*I24","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N24*'Front end'!E$9","v":{"$error":"#DIV/0!"}},null,{"$f":"+'Front end'!E114","v":0},{"$f":"+'Front end'!E116","v":0},{"$f":"+'Front end'!E118","v":0},{"$f":"+'Front end'!E120","v":0},{"$f":"+'Front end'!E122","v":0},{"$f":"+'Front end'!E124","v":0},{"$f":"+'Front end'!E126","v":0},{"$f":"+'Front end'!E128","v":0},{"$f":"+'Front end'!E115","v":0},{"$f":"+'Front end'!E117","v":0},{"$f":"+'Front end'!E119","v":0},{"$f":"+'Front end'!E121","v":0},{"$f":"+'Front end'!E123","v":0},{"$f":"+'Front end'!E125","v":0},{"$f":"+'Front end'!E127","v":0},{"$f":"+'Front end'!E129","v":0},{"$f":"+'Front end'!E310*Assumptions!A$8/100","v":0}]
["uses per person per day","people related usage",null,"Urinal waterless",0,0,"per use",{"$f":"IF(E25=0,0,E25/SUM(E23:E25))","v":0},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,7,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$G$30,4,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N25*'Front end'!E$9","v":{"$error":"#DIV/0!"}},null,{"$f":"+'Front end'!E131","v":0},null,null,null,null,null,null,null,0]
["uses per person per day","people related usage",null,"Wash hand basin tap",0,0,"per use",{"$f":"IF('Front end'!E44=\"yes\",1,0)*Assumptions!A6","v":0},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,8,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$G$30,4,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N26*'Front end'!E$9","v":{"$error":"#DIV/0!"}},null,{"$f":"+'Front end'!E133","v":0},{"$f":"+'Front end'!E135","v":0},{"$f":"+'Front end'!E137","v":0},{"$f":"+'Front end'!E139","v":0},{"$f":"+'Front end'!E141","v":0},{"$f":"+'Front end'!E143","v":0},{"$f":"+'Front end'!E145","v":0},{"$f":"+'Front end'!E147","v":0},{"$f":"+'Front end'!E134","v":0},{"$f":"+'Front end'!E136","v":0},{"$f":"+'Front end'!E138","v":0},{"$f":"+'Front end'!E140","v":0},{"$f":"+'Front end'!E142","v":0},{"$f":"+'Front end'!E144","v":0},{"$f":"+'Front end'!E146","v":0},{"$f":"+'Front end'!E148","v":0},{"$f":"+'Front end'!E314*Assumptions!A$7/100","v":0}]
["uses per person per day","people related usage",null,"Shower",0,0,"per use",{"$f":"IF(AND('Front end'!E45=\"yes\",'Front end'!E46=\"yes\"),+Assumptions!A4,1)","v":1},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,9,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$G$30,4,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N27*'Front end'!E$9","v":{"$error":"#DIV/0!"}},null,{"$f":"+'Front end'!E150","v":0},{"$f":"+'Front end'!E152","v":0},{"$f":"+'Front end'!E154","v":0},{"$f":"+'Front end'!E156","v":0},{"$f":"+'Front end'!E158","v":0},{"$f":"+'Front end'!E160","v":0},{"$f":"+'Front end'!E162","v":0},{"$f":"+'Front end'!E164","v":0},{"$f":"+'Front end'!E151","v":0},{"$f":"+'Front end'!E153","v":0},{"$f":"+'Front end'!E155","v":0},{"$f":"+'Front end'!E157","v":0},{"$f":"+'Front end'!E159","v":0},{"$f":"+'Front end'!E161","v":0},{"$f":"+'Front end'!E163","v":0},{"$f":"+'Front end'!E165","v":0},{"$f":"+'Front end'!E316*Assumptions!A$7/100","v":0}]
["uses per person per day","people related usage",null,"Bath",0,0,"per use",{"$f":"IF(AND('Front end'!E45=\"yes\",'Front end'!E46=\"yes\"),1-+Assumptions!A4,1)*+Assumptions!A5","v":0.4},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,10,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$G$30,4,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N28*'Front end'!E$9","v":{"$error":"#DIV/0!"}},null,{"$f":"+'Front end'!E167","v":0},{"$f":"+'Front end'!E169","v":0},{"$f":"+'Front end'!E171","v":0},{"$f":"+'Front end'!E173","v":0},{"$f":"+'Front end'!E175","v":0},{"$f":"+'Front end'!E177","v":0},{"$f":"+'Front end'!E179","v":0},{"$f":"+'Front end'!E181","v":0},{"$f":"+'Front end'!E168","v":0},{"$f":"+'Front end'!E170","v":0},{"$f":"+'Front end'!E172","v":0},{"$f":"+'Front end'!E174","v":0},{"$f":"+'Front end'!E176","v":0},{"$f":"+'Front end'!E178","v":0},{"$f":"+'Front end'!E180","v":0},{"$f":"+'Front end'!E182","v":0},{"$f":"+'Front end'!E318*Assumptions!A$7/100","v":0}]
["uses per person per day","people related usage",null,"Kitchen taps: kitchenette",0,0,"per use",{"$f":"IF('Front end'!E47=\"yes\",1,0)*Assumptions!A6","v":0},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,11,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$G$30,4,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N29*'Front end'!E$9","v":{"$error":"#DIV/0!"}},null,{"$f":"+'Front end'!E184","v":0},{"$f":"+'Front end'!E186","v":0},{"$f":"+'Front end'!E188","v":0},{"$f":"+'Front end'!E190","v":0},{"$f":"+'Front end'!E192","v":0},{"$f":"+'Front end'!E194","v":0},{"$f":"+'Front end'!E196","v":0},{"$f":"+'Front end'!E198","v":0},{"$f":"+'Front end'!E185","v":0},{"$f":"+'Front end'!E187","v":0},{"$f":"+'Front end'!E189","v":0},{"$f":"+'Front end'!E191","v":0},{"$f":"+'Front end'!E193","v":0},{"$f":"+'Front end'!E195","v":0},{"$f":"+'Front end'!E197","v":0},{"$f":"+'Front end'!E199","v":0},{"$f":"+'Front end'!E320*Assumptions!A$7/100","v":0}]
["uses per person per day","people related usage",null,"Domestic sized washing machines per cycle",0,0,"per use",{"$f":"IF('Front end'!E48=\"yes\",1,0)","v":0},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,12,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$G$30,4,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N30*'Front end'!E$9","v":{"$error":"#DIV/0!"}},null,{"$f":"+'Front end'!E201","v":0},{"$f":"+'Front end'!E203","v":0},{"$f":"+'Front end'!E205","v":0},{"$f":"+'Front end'!E207","v":0},{"$f":"+'Front end'!E209","v":0},{"$f":"+'Front end'!E211","v":0},{"$f":"+'Front end'!E213","v":0},{"$f":"+'Front end'!E215","v":0},{"$f":"+'Front end'!E202","v":0},{"$f":"+'Front end'!E204","v":0},{"$f":"+'Front end'!E206","v":0},{"$f":"+'Front end'!E208","v":0},{"$f":"+'Front end'!E210","v":0},{"$f":"+'Front end'!E212","v":0},{"$f":"+'Front end'!E214","v":0},{"$f":"+'Front end'!E216","v":0},{"$f":"+'Front end'!E322*Assumptions!A$7/100","v":0}]
["uses per person per day","people related usage",null,"Domestic sized dishwashers per cycle",0,0,"per use",{"$f":"IF('Front end'!E49=\"yes\",1,0)","v":0},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,13,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$G$30,4,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N31*'Front end'!E$9","v":{"$error":"#DIV/0!"}},null,{"$f":"+'Front end'!E218","v":0},{"$f":"+'Front end'!E220","v":0},{"$f":"+'Front end'!E222","v":0},{"$f":"+'Front end'!E224","v":0},{"$f":"+'Front end'!E226","v":0},{"$f":"+'Front end'!E228","v":0},{"$f":"+'Front end'!E230","v":0},{"$f":"+'Front end'!E232","v":0},{"$f":"+'Front end'!E219","v":0},{"$f":"+'Front end'!E221","v":0},{"$f":"+'Front end'!E223","v":0},{"$f":"+'Front end'!E225","v":0},{"$f":"+'Front end'!E227","v":0},{"$f":"+'Front end'!E229","v":0},{"$f":"+'Front end'!E231","v":0},{"$f":"+'Front end'!E233","v":0},{"$f":"+'Front end'!E324*Assumptions!A$7/100","v":0}]
["uses per day","fixed usage",null,"Kitchen taps: restaurant (pre-rinse nozzles only)",0,0,"per minute",{"$f":"IF('Front end'!E50=\"yes\",1,0)","v":0},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$T$30,14,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$G$30,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"+F32*I32/(J32*'Front end'!$E$9)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N32*'Front end'!E$9","v":{"$error":"#DIV/0!"}},null,{"$f":"+'Front end'!E235","v":0},{"$f":"+'Front end'!E237","v":0},{"$f":"+'Front end'!E239","v":0},{"$f":"+'Front end'!E241","v":0},{"$f":"+'Front end'!E243","v":0},{"$f":"+'Front end'!E245","v":0},{"$f":"+'Front end'!E247","v":0},{"$f":"+'Front end'!E249","v":0},{"$f":"+'Front end'!E236","v":0},{"$f":"+'Front end'!E238","v":0},{"$f":"+'Front end'!E240","v":0},{"$f":"+'Front end'!E242","v":0},{"$f":"+'Front end'!E244","v":0},{"$f":"+'Front end'!E246","v":0},{"$f":"+'Front end'!E248","v":0},{"$f":"+'Front end'!E250","v":0},{"$f":"+'Front end'!E326*Assumptions!A$7/100","v":0}]
["uses per day","fixed usage",null,"Waste disposal unit (commercial kitchens only)",0,0,"per minute",{"$f":"IF('Front end'!E51=\"yes\",1,0)","v":0},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$T$30,15,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$G$30,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"+F33*I33/(J33*'Front end'!$E$9)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N33*'Front end'!E$9","v":{"$error":"#DIV/0!"}},null,{"$f":"+'Front end'!E252","v":0},{"$f":"+'Front end'!E254","v":0},{"$f":"+'Front end'!E256","v":0},{"$f":"+'Front end'!E258","v":0},{"$f":"+'Front end'!E260","v":0},{"$f":"+'Front end'!E262","v":0},{"$f":"+'Front end'!E264","v":0},{"$f":"+'Front end'!E266","v":0},{"$f":"+'Front end'!E253","v":0},{"$f":"+'Front end'!E255","v":0},{"$f":"+'Front end'!E257","v":0},{"$f":"+'Front end'!E259","v":0},{"$f":"+'Front end'!E261","v":0},{"$f":"+'Front end'!E263","v":0},{"$f":"+'Front end'!E265","v":0},{"$f":"+'Front end'!E267","v":0},{"$f":"+'Front end'!E328*Assumptions!A$7/100","v":0}]
["uses per day","fixed usage",null,"Commercial sized dishwashers per rack",0,0,"per rack",{"$f":"IF('Front end'!E52=\"yes\",1,0)","v":0},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$T$30,16,FALSE)","v":{"$error":"#N/A"}},{"$f":"J5","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$G$30,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"+F34*I34/(J34*'Front end'!$E$9)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$f":"+'Front end'!E269","v":0},{"$f":"+'Front end'!E271","v":0},{"$f":"+'Front end'!E273","v":0},{"$f":"+'Front end'!E275","v":0},{"$f":"+'Front end'!E277","v":0},{"$f":"+'Front end'!E279","v":0},{"$f":"+'Front end'!E281","v":0},{"$f":"+'Front end'!E283","v":0},{"$f":"+'Front end'!E270","v":0},{"$f":"+'Front end'!E272","v":0},{"$f":"+'Front end'!E274","v":0},{"$f":"+'Front end'!E276","v":0},{"$f":"+'Front end'!E278","v":0},{"$f":"+'Front end'!E280","v":0},{"$f":"+'Front end'!E282","v":0},{"$f":"+'Front end'!E284","v":0},{"$f":"+'Front end'!E330*Assumptions!A$7/100","v":0}]
["uses per day","fixed usage",null,"Commercial or industrial sized washing machines per kg",0,0,"per kg",{"$f":"IF('Front end'!E53=\"yes\",1,0)","v":0},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$T$30,17,FALSE)","v":{"$error":"#N/A"}},{"$f":"J5","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$G$30,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"+F35*I35/(J35*'Front end'!$E$9)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$f":"+'Front end'!E286","v":0},{"$f":"+'Front end'!E288","v":0},{"$f":"+'Front end'!E290","v":0},{"$f":"+'Front end'!E292","v":0},{"$f":"+'Front end'!E294","v":0},{"$f":"+'Front end'!E296","v":0},{"$f":"+'Front end'!E298","v":0},{"$f":"+'Front end'!E300","v":0},{"$f":"+'Front end'!E287","v":0},{"$f":"+'Front end'!E289","v":0},{"$f":"+'Front end'!E291","v":0},{"$f":"+'Front end'!E293","v":0},{"$f":"+'Front end'!E295","v":0},{"$f":"+'Front end'!E297","v":0},{"$f":"+'Front end'!E299","v":0},{"$f":"+'Front end'!E301","v":0},{"$f":"+'Front end'!E360*Assumptions!A$7/100","v":0}]
[null,null,null,"Total water use",null,null,null,null,null,null,null,{"$f":"SUM(L22:L35)","v":{"$error":"#N/A"}},{"$f":"SUM(M22:M35)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N22:N35)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(O22:O35)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Rainwater available",null,null,null,null,null,null,null,{"$f":"+M37/J35","v":{"$error":"#DIV/0!"}},{"$f":"IF('Front end'!E335='lookup tables'!$A$7,((+'Front end'!E$336*'Front end'!E$337*'Front end'!E$338/100*'Front end'!E$339/100)/365)/'Front end'!$E$9,'Front end'!E$340/365/'Front end'!$E$9)","v":{"$error":"#DIV/0!"}},{"$f":"+M37/1000*365","v":{"$error":"#DIV/0!"}},{"$f":"+N37*'Front end'!E9","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Grey and blackwater available",null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(L22:L35,$AG$22:$AG$35)","v":{"$error":"#N/A"}},{"$f":"SUMPRODUCT(M22:M35,$AG$22:$AG$35)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"SUMPRODUCT(O22:O35,$AG$22:$AG$35)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Recycled water use",null,null,null,null,null,null,null,{"$f":"+'Front end'!$E$349/100*calculation!L22+'Front end'!$E$351/100*calculation!L23+'Front end'!$E$353*calculation!L24/100","v":{"$error":"#N/A"}},{"$f":"+'Front end'!$E349/100*calculation!M22+'Front end'!$E351/100*calculation!M23+'Front end'!$E353*calculation!M24/100","v":{"$error":"#DIV/0!"}},{"$f":"+'Front end'!$E349/100*calculation!N22+'Front end'!$E351/100*calculation!N23+'Front end'!$E353*calculation!N24/100","v":{"$error":"#DIV/0!"}},{"$f":"+'Front end'!$E349/100*calculation!O22+'Front end'!$E351/100*calculation!O23+'Front end'!$E353*calculation!O24/100","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Non-network water use",null,null,null,null,null,null,null,{"$f":"+M40/J35","v":{"$error":"#DIV/0!"}},{"$f":"+N40/1000*365","v":{"$error":"#DIV/0!"}},{"$f":"+O40/'Front end'!E9","v":{"$error":"#DIV/0!"}},{"$f":"+'Front end'!E345","v":0}]
[null,null,null,"Network water use",null,null,null,null,null,null,null,{"$f":"+L36-(L40+L39)","v":{"$error":"#N/A"}},{"$f":"+M36-M40+M39","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"Water disposed of via  sewage network",null,null,null,null,null,null,null,{"$f":"+L36-L39","v":{"$error":"#N/A"}},{"$f":"+M36-M39","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[null,null,null,"EUT requirements"]
[null,null,null,"wash hand basin taps and kitchen taps have a maximum water flow of 6 litres/min;"]
[null,null,null,"showers have a maximum water flow of 8 litres/min;"]
[null,null,null,"(c) WCs, including suites, bowls and flushing cisterns, have a full flush volume of a maximum of 6 litres and a maximum average flush volume of 3,5 litres;"]
[null,null,null,"(d) urinals use a maximum of 2 litres/bowl/hour. Flushing urinals have a maximum full flush volume of 1 litre."]
[]
[]
[]
[null,null,null,"BUILDING Actual occupancy","From user data entry","From user data entry * adjustment factor",null,"takes account of alternative options (WC/urinal and shower/bath) and also typical % bath fill and tap full volume","from building type lookup","from building type lookup (for total building or food prepar","from building type lookup","volume* factor*uses per day (div occupant density for fixed uses","lt per person*occupancy density*m2","lt/m2*1,000/ occupied days per year","m3/m2/year*m2",null,"Number of each type of component",null,null,null,null,null,null,null,"Water consumption for each type of componets (litres per X)",null,null,null,null,null,null,null,"Black water and Grey water recovery rate"]
[null,null,null,null,"number of items","Average water use ltrs","Unit","Adjustment factor","Use per day","occupancy density","occupied days per year","lt per person per day","lt/m2 per day","m3/m2 per year","m3/year",null,"Type 1","Type 2","Type 3","Type 4","Type 5","Type 6","Type 7","Type 8","Type 1","Type 2","Type 3","Type 4","Type 5","Type 6","Type 7","Type 8"]
["uses per person per day","people related usage",null,"WC",{"$f":"SUM(Q55:X55)","v":0},{"$f":"IF(E55=0,0,(SUMPRODUCT(Q55:X55,Y55:AF55)/E55)*H55)","v":0},"per use",{"$f":"+H22","v":1},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"+'Front end'!E10/'Front end'!E9","v":{"$error":"#DIV/0!"}},{"$f":"+'Front end'!E11","v":0},{"$f":"+F55*I55","v":{"$error":"#N/A"}},{"$f":"+J55*L55","v":{"$error":"#DIV/0!"}},{"$f":"+M55/1000*K55","v":{"$error":"#DIV/0!"}},{"$f":"+N55*'Front end'!E$9","v":{"$error":"#DIV/0!"}},null,{"$f":"+Q22","v":0},{"$f":"+R22","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AG22","v":0}]
["uses per person per day","people related usage",null,"Urinal timed flush",0,{"$f":"IF(E56=0,0,(SUMPRODUCT(Q56:X56,Y56:AF56)/E56)*H56)","v":0},"per hour",{"$f":"+H23","v":0},{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"+J55","v":{"$error":"#DIV/0!"}},{"$f":"+K55","v":0},{"$f":"+F56*I56/(J56*'Front end'!$E$9)","v":{"$error":"#N/A"}},{"$f":"+J56*L56","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"+N56*'Front end'!E$9","v":{"$error":"#DIV/0!"}},null,{"$f":"+Q23","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["uses per person per day","people related usage",null,"Urinal automatic sensor flush",0,0,"per use",0,{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,7,FALSE)","v":{"$error":"#N/A"}},{"$f":"+J56","v":{"$error":"#DIV/0!"}},{"$f":"+K56","v":0},{"$f":"+F57*I57","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N57*'Front end'!E$9","v":{"$error":"#DIV/0!"}},null,{"$f":"+Q24","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["uses per person per day","people related usage",null,"Urinal waterless",0,0,"per use",0,{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,7,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},0,{"$error":"#N/A"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N58*'Front end'!E$9","v":{"$error":"#DIV/0!"}},null,{"$f":"+Q25","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["uses per person per day","people related usage",null,"Wash hand basin tap",0,0,"per use",0,{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,8,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},0,{"$error":"#N/A"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N59*'Front end'!E$9","v":{"$error":"#DIV/0!"}},null,{"$f":"+Q26","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["uses per person per day","people related usage",null,"Shower",0,0,"per use",1,{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,9,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},0,{"$error":"#N/A"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N60*'Front end'!E$9","v":{"$error":"#DIV/0!"}},null,{"$f":"+Q27","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["uses per person per day","people related usage",null,"Bath",0,0,"per use",0.4,{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,10,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},0,{"$error":"#N/A"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N61*'Front end'!E$9","v":{"$error":"#DIV/0!"}},null,{"$f":"+Q28","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["uses per person per day","people related usage",null,"Kitchen taps: kitchenette",0,0,"per use",0,{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,11,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},0,{"$error":"#N/A"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N62*'Front end'!E$9","v":{"$error":"#DIV/0!"}},null,{"$f":"+Q29","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["uses per person per day","people related usage",null,"Domestic sized washing machines per cycle",0,0,"per use",0,{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,12,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},0,{"$error":"#N/A"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N63*'Front end'!E$9","v":{"$error":"#DIV/0!"}},null,{"$f":"+Q30","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["uses per person per day","people related usage",null,"Domestic sized dishwashers per cycle",0,0,"per use",0,{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$O$30,13,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},0,{"$error":"#N/A"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N64*'Front end'!E$9","v":{"$error":"#DIV/0!"}},null,{"$f":"+Q31","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["uses per day","fixed usage",null,"Kitchen taps: restaurant (pre-rinse nozzles only)",0,0,"per minute",0,{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$T$30,14,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},0,{"$f":"+F65*I65/(J65*'Front end'!$E$9)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N65*'Front end'!E$9","v":{"$error":"#DIV/0!"}},null,{"$f":"+Q32","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["uses per day","fixed usage",null,"Waste disposal unit (commercial kitchens only)",0,0,"per minute",0,{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$T$30,15,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},0,{"$f":"+F66*I66/(J66*'Front end'!$E$9)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N66*'Front end'!E$9","v":{"$error":"#DIV/0!"}},null,{"$f":"+Q33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["uses per day","fixed usage",null,"Commercial sized dishwashers per rack",0,0,"per rack",0,{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$T$30,16,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},0,{"$f":"+F67*I67/(J67*'Front end'!$E$9)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N67*'Front end'!E$9","v":{"$error":"#DIV/0!"}},null,{"$f":"+Q34","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["uses per day","fixed usage",null,"Commercial or industrial sized washing machines per kg",0,0,"per kg",0,{"$f":"VLOOKUP('Front end'!E$8,'lookup tables'!$C$7:$T$30,17,FALSE)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},0,{"$f":"+F68*I68/(J68*'Front end'!$E$9)","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+N68*'Front end'!E$9","v":{"$error":"#DIV/0!"}},null,{"$f":"+Q35","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total water use",null,null,null,null,null,null,null,{"$f":"SUM(L55:L68)","v":{"$error":"#N/A"}},{"$f":"SUM(M55:M68)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N55:N68)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(O55:O68)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Rainwater available",null,null,null,null,null,null,null,{"$f":"+M70/J68","v":{"$error":"#DIV/0!"}},{"$f":"IF('Front end'!E335='lookup tables'!$A$7,((+'Front end'!E$336*'Front end'!E$337*'Front end'!E$338/100*'Front end'!E$339/100)/365)/'Front end'!$E$9,'Front end'!E$340/365/'Front end'!$E$9)","v":{"$error":"#DIV/0!"}},{"$f":"+M70/1000*365","v":{"$error":"#DIV/0!"}},{"$f":"+N70*'Front end'!E69","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Grey and blackwater available",null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(L55:L68,$AG$22:$AG$35)","v":{"$error":"#N/A"}},{"$f":"SUMPRODUCT(M55:M68,$AG$22:$AG$35)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"SUMPRODUCT(O55:O68,$AG$55:$AG$68)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Recycled water use",null,null,null,null,null,null,null,{"$f":"+'Front end'!$E$349/100*calculation!L55+'Front end'!$E$351/100*calculation!L56+'Front end'!$E$353*calculation!L57/100","v":{"$error":"#N/A"}},{"$f":"+'Front end'!$E382/100*calculation!M55+'Front end'!$E384/100*calculation!M56+'Front end'!$E386*calculation!M57/100","v":{"$error":"#DIV/0!"}},{"$f":"+'Front end'!$E382/100*calculation!N55+'Front end'!$E384/100*calculation!N56+'Front end'!$E386*calculation!N57/100","v":{"$error":"#DIV/0!"}},{"$f":"+'Front end'!$E382/100*calculation!O55+'Front end'!$E384/100*calculation!O56+'Front end'!$E386*calculation!O57/100","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Non-network water use",null,null,null,null,null,null,null,{"$f":"+M73/J68","v":{"$error":"#DIV/0!"}},{"$f":"+N73/1000*N73","v":{"$error":"#DIV/0!"}},{"$f":"+O73/'Front end'!E9","v":{"$error":"#DIV/0!"}},{"$f":"+'Front end'!E345","v":0}]
[null,null,null,"Network water use",null,null,null,null,null,null,null,{"$f":"+L69-(L73+L72)","v":{"$error":"#N/A"}},{"$f":"+M69-M73+M72","v":{"$error":"#DIV/0!"}},{"$f":"+N69-N73+N72","v":{"$error":"#DIV/0!"}},{"$f":"+O69-O73+O72","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Water disposed of via  sewage network",null,null,null,null,null,null,null,{"$f":"+L69-L72","v":{"$error":"#N/A"}},{"$f":"+M69-M72","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"lookup tables","index":3,"n_rows":66,"n_cols":19,"rows_kept":66,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"From Wat 01 activity database"]
[null,null,null,"New Assumption"]
[null,null,null,"Derived from Wat 01 activity database"]
[null,null,null,null,null,null,"usage per person per day","usage per person per day","usage per person per day","usage per person per day","usage per person per day","usage minutes per person per day","usage per person per day","usage per person per day","usage per person per day","per minute","per minute","usage per person per day"]
["water storage capacity calculation","Yes/No","Building type lookup","Occupant density (people per m2 per year)","Occupant density (food prepartion area","Number of days","occupancy hours per day","WC","Urinal","Wash hand basin tap","Shower","Bath","Kitchen taps: kitchenette","Domestic sized washing machines","Domestic sized dishwashers","Kitchen taps: restaurant (pre-rinse nozzles only)","Waste disposal unit (commercial kitchens only)","Commercial sized dishwashers","Commercial or industrial sized washing machines"]
[null,null,null,null,null,null,null,"uses per day","uses per day","uses per day","uses per day","uses per day","uses per day","uses per day","uses per day","per day (fixed use)","per day (fixed use)","per day (fixed use)","per day (fixed use)"]
["BS EN 16941-1:2018 'basic approach'","Yes","Retail",3.7258928571428575E-2,3.7258928571428575E-2,{"$f":"+'Activity database from wat 01'!D34","v":362},{"$f":"+'Activity database from wat 01'!E34","v":13},{"$f":"+'Activity database from wat 01'!K34","v":0.85184051840518404},{"$f":"+'Activity database from wat 01'!L34","v":0.70479497794977952},{"$f":"+'Activity database from wat 01'!M34","v":0.85184051840518404},{"$f":"+'Activity database from wat 01'!N34","v":4.8600486004860038E-4},{"$f":"+K7","v":4.8600486004860038E-4},{"$f":"+'Activity database from wat 01'!R46","v":1.6200162001620014E-2},{"$f":"+'Activity database from wat 01'!U46","v":6.4800648006480054E-4},6.4800648006480054E-4,{"$f":"+'Activity database from wat 01'!AI47","v":60},{"$f":"+'Activity database from wat 01'!AM47","v":30},20,3]
["BS EN 16941-1:2018 'detailed approach'","No","Retail services",{"$f":"+D7","v":3.7258928571428575E-2},{"$f":"+E7","v":3.7258928571428575E-2},{"$f":"+'Activity database from wat 01'!D37","v":304},{"$f":"+'Activity database from wat 01'!E37","v":8},{"$f":"+H7","v":0.85184051840518404},{"$f":"+I7","v":0.70479497794977952},0.85184051840518404,4.8600486004860038E-4,4.8600486004860038E-4,1.6200162001620014E-2,6.4800648006480054E-4,6.4800648006480054E-4,{"$f":"+P7","v":60},{"$f":"+Q7","v":30},20,3]
[null,null,"Restaurant and Cafes/Drinking Establishments and Hot Food takeaways",6.637916666666667E-2,6.637916666666667E-2,{"$f":"+F8","v":304},{"$f":"+G8","v":8},{"$f":"+H10","v":4},{"$f":"+I10","v":3},4,0.03,0.03,1,0.04,0.04,{"$f":"+P8","v":60},{"$f":"+Q8","v":30},{"$f":"+R8","v":20},3]
[null,null,"Office",4.2656597222083335E-2,4.2656597222083335E-2,{"$f":"+'Activity database from wat 01'!D4","v":253},{"$f":"+'Activity database from wat 01'!E10","v":10},4,3,4,0.03,{"$f":"+K10","v":0.03},1,{"$f":"1/25","v":0.04},0.04,60,30,20,3]
[null,null,"Industrial",1.4909579918032784E-2,1.4909579918032784E-2,{"$f":"+F10","v":253},{"$f":"+G10","v":10},4,3,4,0.03,{"$f":"+K11","v":0.03},1,{"$f":"1/25","v":0.04},0.04,60,30,20,3]
[null,null,"Warehouse",7.47844684414846E-3,7.4784468441484644E-3,{"$f":"+F7","v":362},{"$f":"+G7","v":13},4,3,4,0.03,{"$f":"+K12","v":0.03},1,{"$f":"1/25","v":0.04},0.04,60,30,20,3]
[null,null,"Hotel",4.6594376044299654E-2,4.6594376044299654E-2,{"$f":"+F7","v":362},24,{"$f":"+H12","v":4},{"$f":"+I12","v":3},4,1,1,1,null,null,60,30,20,3]
[null,null,"Hospital",9.224166666666668E-2,9.224166666666668E-2,365,24,{"$f":"+H15","v":7},null,null,null,null,null,null,null,60,30,20,3]
[null,null,"Care Home",5.5260150611358527E-2,5.5260150611358527E-2,365,24,7,6,7,0.5,0.5,1,0.3,0.3,60,30,20,3]
[null,null,"Residential schools",5.2742307529612079E-2,5.2742307529612079E-2,{"$f":"+'Activity database from wat 01'!D17","v":195},24,{"$f":"+H15","v":7},{"$f":"+I15","v":6},7,0.5,0.5,1,0.3,0.3,60,30,20,3]
[null,null,"Universities and colleges",5.4813599921170519E-2,5.4813599921170519E-2,{"$f":"+'Activity database from wat 01'!D18","v":195},{"$f":"+G7","v":13},{"$f":"+H16","v":7},6,7,0.5,0.5,1,0.3,0.3,60,30,20,3]
[null,null,"Secure Residential Institutions",5.4813599921170519E-2,5.4813599921170519E-2,365,24,7,6,7,0.5,0.5,1,0.3,0.3,60,30,20,3]
[null,null,"Community/Day Centre",4.3963541666666668E-2,4.3963541666666668E-2,{"$f":"+F10","v":253},{"$f":"+G8","v":8},{"$f":"+H10","v":4},{"$f":"+I10","v":3},4,0.03,0.03,1,0.04,0.04,60,30,20,3]
[null,null,"Crown and County Courts",4.76482638875E-2,4.76482638875E-2,{"$f":"+F10","v":253},{"$f":"+G8","v":8},{"$f":"+H11","v":4},3,4,0.03,0.03,1,0.04,0.04,60,30,20,3]
[null,null,"Non-residential school",0.10415557097808105,0.10415557097808105,{"$f":"+F17","v":195},{"$f":"+'Activity database from wat 01'!E17","v":10},4,3,4,0.03,0.03,1,0.04,0.04,60,30,20,3]
[null,null,"Libraries Museums and Galleries",4.6929895947722476E-2,4.6929895947722476E-2,{"$f":"+F10","v":253},{"$f":"+G8","v":8},{"$f":"+H7","v":0.85184051840518404},{"$f":"+I7","v":0.70479497794977952},0.85184051840518404,4.8600486004860038E-4,4.8600486004860038E-4,1.6200162001620014E-2,6.4800648006480054E-4,6.4800648006480054E-4,60,30,20,3]
[null,null,"Primary Health Care Building",4.2166666666666672E-2,4.2166666666666672E-2,{"$f":"+F10","v":253},{"$f":"+G10","v":10},{"$f":"+H8","v":0.85184051840518404},0.70479497794977952,0.85184051840518404,4.8600486004860038E-4,4.8600486004860038E-4,1.6200162001620014E-2,6.4800648006480054E-4,6.4800648006480054E-4,60,30,20,3]
[null,null,"Swimming pool/Ice rink",4.7454728133037666E-2,4.7454728133037666E-2,{"$f":"+F7","v":362},{"$f":"+G7","v":13},4,3,4,0.03,0.03,1,0.04,0.04,60,30,20,3]
[null,null,"Dry sports centre",3.9589215573138409E-2,3.9589215573138409E-2,{"$f":"+F24","v":362},{"$f":"+G7","v":13},4,3,4,0.03,0.03,1,0.04,0.04,60,30,20,3]
[null,null,"Nightclub",5.964230401733852E-2,5.964230401733852E-2,{"$f":"+F10","v":253},{"$f":"+G8","v":8},4,3,4,0.03,0.03,1,0.04,0.04,60,30,20,3]
[null,null,"Theatre",6.0343692901851299E-2,6.0343692901851299E-2,{"$f":"+F10","v":253},{"$f":"+G26","v":8},7,6,7,0.5,0.5,1,0.3,0.3,60,30,20,3]
[null,null,"Emergency services",4.8848343925663854E-2,4.8848343925663854E-2,365,24,{"$f":"+H15","v":7},{"$f":"+I15","v":6},7,0.5,0.5,1,0.3,0.3,60,30,20,3]
[null,null,"Passenger terminals",8.532853284899139E-2,8.532853284899139E-2,362,24,{"$f":"+H8","v":0.85184051840518404},{"$f":"+I8","v":0.70479497794977952},0.85184051840518404,4.8600486004860038E-4,4.8600486004860038E-4,1.6200162001620014E-2,6.4800648006480054E-4,6.4800648006480054E-4,60,30,20,3]
[null,null,"Residential- homes",{"$f":"3/50","v":0.06},{"$f":"3/50","v":0.06},365,24,7,6,7,0.5,0.5,1,0.3,0.3,60,30,20,3]
[null,null,"food preparation area"]
[]
[null,null,null,"Baseline","EUT"]
[null,"Max flush volume","WC full flush volume",null,6]
[null,"Effective flush volume (litres)","WC'",{"$f":"'Activity database from wat 01'!C107","v":6},3.5]
[null,"Volume (litres/bowl/hour)","Urinal with timed flush",{"$f":"AVERAGE('Activity database from wat 01'!C113:C114)","v":8.75},2]
[null,"Effective flush volume (litres)","Urinal with automatic sensor flush",null,1]
[null,null,"Waterless urinals"]
[null,"Volume (litres/min)","Wash hand basin tap",{"$f":"+'Activity database from wat 01'!C110","v":10},6]
[null,"Volume (litres/min)","Shower",{"$f":"+'Activity database from wat 01'!C111","v":12},8]
[null,"Volume (litres)","Bath",{"$f":"+'Activity database from wat 01'!C112","v":200}]
[null,"Volume (litres/min)","Kitchen taps: kitchenette",{"$f":"+'Activity database from wat 01'!C117","v":10},6]
[null,"Volume (litres/min)","Domestic sized washing machines",{"$f":"+'Activity database from wat 01'!C120","v":90}]
[null,"Volume (litres/cycle)","Domestic sized dishwashers",{"$f":"+'Activity database from wat 01'!C119","v":17}]
[null,"Volume (litres/use)","Kitchen taps: restaurant (pre-rinse nozzles only)",{"$f":"+'Activity database from wat 01'!C118","v":10.3}]
[null,"Volume (litres/min)","Waste disposal unit (commercial kitchens only)",{"$f":"+'Activity database from wat 01'!C121","v":17}]
[null,"Volume (litres/rack)","Commercial sized dishwashers",{"$f":"+'Activity database from wat 01'!C122","v":8}]
[null,"Volume (litres/kg)","Commercial or industrial sized washing machines",{"$f":"+'Activity database from wat 01'!C123","v":14}]
[null,"% of WC/urinal flushing demand (generated by same level microcomponent specification) met by specified grey/rainwater system"]
[]
[]
[null,"% improvement","Number of credits",null,null,"% improvement","Number of credits"]
[null,0.75,5,null,null,0,0]
[null,0.6,4,null,null,0.15,1]
[null,0.45,3,null,null,0.3,2]
[null,0.3,2,null,null,0.45,3]
[null,0.15,1,null,null,0.6,4]
[null,0,0,null,null,0.75,5]
[]
[]
[null,"water supply",0.1766845465790137,"kgCO2e/m3"]
[null,"water treatment",0.20131829171065632,"kgCO2e/m3"]
[]
[]
[]
[null,"m3 to lts",1000]

{"sheet":"Output","index":4,"n_rows":64,"n_cols":15,"rows_kept":64,"cut":false,"hidden":true,"merged":[[15,1,15,9],[16,1,16,9],[17,1,17,9],[20,1,20,9],[0,1,1,10],[5,2,5,9],[3,2,3,9],[4,2,4,9],[6,2,6,9],[7,2,7,9],[10,1,10,9],[11,1,11,9],[12,1,12,9],[13,1,13,9],[14,1,14,9],[62,1,62,9],[63,1,63,9],[48,1,48,9],[49,1,49,9],[50,1,50,9],[51,1,51,9],[59,1,59,9],[52,1,52,9],[53,1,53,9],[54,1,54,9],[55,1,55,9],[56,1,56,9],[23,11,23,12],[24,11,26,12],[24,13,26,13],[60,1,60,9],[61,1,61,9],[47,1,47,9],[40,1,40,4],[29,3,29,9],[41,1,41,4],[42,1,42,4],[43,1,43,4],[44,1,44,4],[23,1,24,1],[23,2,23,9]]}
[{"$f":"'Water calculator'!A44","v":"Versie:"},"BREEAM-NL Nieuwbouw en Renovatie Utiliteit v6.1.1 - WAT 01 - Watercalculator"]
[{"$f":"'Water calculator'!A47","v":"1.3"}]
[]
[null,"Projectnaam:"]
[null,"Registratienummer:"]
[null,"Opdrachtgever:"]
[null,"BREEAM-NL Expert"]
[null,"BREEAM-NL Assessor"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Percentage verbetering:",{"$f":"_xlfn.IFS(M11=\"EP behaald\",\"EP-Score\",M11=\" \",\" \")","v":{"$error":"#N/A"}}]
[null,"Aantal BREEAM-NL punten in te vullen in de Assessmenttool",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP((1-calculation!L74/calculation!L17),'lookup tables'!F53:G58,2,TRUE)","v":{"$error":"#N/A"}},{"$f":"1-calculation!L74/calculation!L17","v":{"$error":"#N/A"}},{"$f":"IF(L11>=85%,\"EP behaald\",\" \")","v":{"$error":"#N/A"}}]
[null,"All WCs have a maximum flush volume of 6 litres",null,null,null,null,null,null,null,null,{"$f":"IF(AND(+'Front end'!E73<=+'lookup tables'!E34,+'Front end'!E76<=+'lookup tables'!E34,+'Front end'!E79<=++'lookup tables'!E34,+'Front end'!E82<=+'lookup tables'!E34,+'Front end'!E85<=+'lookup tables'!E34,+'Front end'!E88<=+'lookup tables'!E34,+'Front end'!E91<=+'lookup tables'!E34,+'Front end'!E94<=++'lookup tables'!E34),\"Yes\",\"No\")","v":"Yes"}]
[null,"All WCs have an average flush volume of 3.5 litres or less",null,null,null,null,null,null,null,null,{"$f":"IF(AND(+'Front end'!E74<=+'lookup tables'!E35,+'Front end'!E77<=+'lookup tables'!E35,+'Front end'!E80<=++'lookup tables'!E35,+'Front end'!E83<=+'lookup tables'!E35,+'Front end'!E86<=+'lookup tables'!E35,+'Front end'!E89<=+'lookup tables'!E35,+'Front end'!E92<=+'lookup tables'!E35,+'Front end'!E95<=++'lookup tables'!E35),\"Yes\",\"No\")","v":"Yes"}]
[null,"All urinals with timed flush use a maximum of 2 litres per bowl per hour",null,null,null,null,null,null,null,null,{"$f":"IF(AND(+'Front end'!E98<=+'lookup tables'!E36,+'Front end'!E100<=+'lookup tables'!E36,+'Front end'!E102<=++'lookup tables'!E36,+'Front end'!E104<=+'lookup tables'!E36,+'Front end'!E106<=+'lookup tables'!E36,+'Front end'!E108<=+'lookup tables'!E36,+'Front end'!E110<=+'lookup tables'!E36,+'Front end'!E112<=++'lookup tables'!E36),\"Yes\",\"No\")","v":"Yes"}]
[null,"All fllushing urinals have a maximum full flush volume of 1 litre",null,null,null,null,null,null,null,null,{"$f":"IF(AND(+'Front end'!E115<=+'lookup tables'!E37,+'Front end'!E117<=+'lookup tables'!E37,+'Front end'!E119<=++'lookup tables'!E37,+'Front end'!E121<=+'lookup tables'!E37,+'Front end'!E123<=+'lookup tables'!E37,+'Front end'!E125<=+'lookup tables'!E37,+'Front end'!E127<=+'lookup tables'!E37,+'Front end'!E129<=++'lookup tables'!E37),\"Yes\",\"No\")","v":"Yes"}]
[null,"All showers have a maximum water flow of 8 litres per minute",null,null,null,null,null,null,null,null,{"$f":"IF(AND(+'Front end'!E151<=+'lookup tables'!E40,+'Front end'!E153<=+'lookup tables'!E40,+'Front end'!E155<=++'lookup tables'!E40,+'Front end'!E157<=+'lookup tables'!E40,+'Front end'!E159<=+'lookup tables'!E40,+'Front end'!E161<=+'lookup tables'!E40,+'Front end'!E163<=+'lookup tables'!E40,+'Front end'!E165<=++'lookup tables'!E40),\"Yes\",\"No\")","v":"Yes"}]
[null,"All wash hand basin taps have a maximum water flow of 6 litres per minute",null,null,null,null,null,null,null,null,{"$f":"IF(AND(+'Front end'!E134<=+'lookup tables'!E39,+'Front end'!E136<=+'lookup tables'!E39,+'Front end'!E138<=++'lookup tables'!E39,+'Front end'!E140<=+'lookup tables'!E39,+'Front end'!E142<=+'lookup tables'!E39,+'Front end'!E144<=+'lookup tables'!E39,+'Front end'!E146<=+'lookup tables'!E39,+'Front end'!E148<=++'lookup tables'!E39),\"Yes\",\"No\")","v":"Yes"}]
[null,"All kitchen taps have a maximum water flow of 6 litres per minute",null,null,null,null,null,null,null,null,{"$f":"IF(AND(+'Front end'!E185<=+'lookup tables'!E42,+'Front end'!E187<=+'lookup tables'!E42,+'Front end'!E189<=++'lookup tables'!E42,+'Front end'!E191<=+'lookup tables'!E42,+'Front end'!E193<=+'lookup tables'!E42,+'Front end'!E195<=+'lookup tables'!E42,+'Front end'!E197<=+'lookup tables'!E42,+'Front end'!E199<=++'lookup tables'!E42),\"Yes\",\"No\")","v":"Yes"}]
[]
[]
[null,"EUT water using component requirements met?",null,null,null,null,null,null,null,null,{"$f":"IF(AND(Output!K12=\"yes\",Output!K13=\"Yes\",Output!K14=\"Yes\",Output!K15=\"Yes\"),\"Yes\",\"No\")","v":"Yes"}]
[]
[]
[null,"Voorziening:","Ingevulde waterverbruik:",null,null,null,null,null,null,null,null,"Aantal gebouwgebruikers",null,{"$f":"'Front end'!E10","v":0}]
[null,null,"Type 1","Type 2","Type 3","Type 4","Type 5","Type 6","Type 7","Type 8"]
[null,"WC full flush, litres",{"$f":"'Front end'!E73","v":0},{"$f":"'Front end'!E76","v":0},{"$f":"'Front end'!E79","v":0},{"$f":"'Front end'!E82","v":0},{"$f":"'Front end'!E85","v":0},{"$f":"'Front end'!E88","v":0},{"$f":"'Front end'!E91","v":0},{"$f":"'Front end'!E94","v":0}]
[null,"WC reduced flush, litres",{"$f":"'Front end'!E74","v":0},{"$f":"'Front end'!E77","v":0},{"$f":"'Front end'!E80","v":0},{"$f":"'Front end'!E83","v":0},{"$f":"'Front end'!E86","v":0},{"$f":"'Front end'!E89","v":0},{"$f":"'Front end'!E92","v":0},{"$f":"'Front end'!E95","v":0}]
[null,"Urinal litre/hour",{"$f":"'Front end'!E98","v":0},{"$f":"'Front end'!E100","v":0},{"$f":"'Front end'!E102","v":0},{"$f":"'Front end'!E104","v":0},{"$f":"'Front end'!E106","v":0},{"$f":"'Front end'!E108","v":0},{"$f":"'Front end'!E110","v":0},{"$f":"'Front end'!E112","v":0}]
[null,"Urinal litres/flush",{"$f":"'Front end'!E115","v":0},{"$f":"'Front end'!E117","v":0},{"$f":"'Front end'!E119","v":0},{"$f":"'Front end'!E121","v":0},{"$f":"'Front end'!E123","v":0},{"$f":"'Front end'!E125","v":0},{"$f":"'Front end'!E127","v":0},{"$f":"'Front end'!E129","v":0}]
[null,"Urinals, waterless, amount",{"$f":"'Front end'!E131","v":0},"(totaal aantal aanwezige waterloze urinoirs)"]
[null,"Wash hand basin tap, litres/min.",{"$f":"'Front end'!E134","v":0},{"$f":"'Front end'!E136","v":0},{"$f":"'Front end'!E138","v":0},{"$f":"'Front end'!E140","v":0},{"$f":"'Front end'!E142","v":0},{"$f":"'Front end'!E144","v":0},{"$f":"'Front end'!E146","v":0},{"$f":"'Front end'!E148","v":0}]
[null,"Showers, litres/min.",{"$f":"'Front end'!E151","v":0},{"$f":"'Front end'!E153","v":0},{"$f":"'Front end'!E155","v":0},{"$f":"'Front end'!E157","v":0},{"$f":"'Front end'!E159","v":0},{"$f":"'Front end'!E161","v":0},{"$f":"'Front end'!E163","v":0},{"$f":"'Front end'!E165","v":0}]
[null,"Baths, litres",{"$f":"'Front end'!E168","v":0},{"$f":"'Front end'!E170","v":0},{"$f":"'Front end'!E172","v":0},{"$f":"'Front end'!E174","v":0},{"$f":"'Front end'!E176","v":0},{"$f":"'Front end'!E178","v":0},{"$f":"'Front end'!E180","v":0},{"$f":"'Front end'!E182","v":0}]
[null,"Kitchen taps, litres/min.",{"$f":"'Front end'!E185","v":0},{"$f":"'Front end'!E187","v":0},{"$f":"'Front end'!E189","v":0},{"$f":"'Front end'!E191","v":0},{"$f":"'Front end'!E193","v":0},{"$f":"'Front end'!E195","v":0},{"$f":"'Front end'!E197","v":0},{"$f":"'Front end'!E199","v":0}]
[null,"Domestic washing machine l/cycle",{"$f":"'Front end'!E202","v":0},{"$f":"'Front end'!E204","v":0},{"$f":"'Front end'!E206","v":0},{"$f":"'Front end'!E208","v":0},{"$f":"'Front end'!E210","v":0},{"$f":"'Front end'!E212","v":0},{"$f":"'Front end'!E214","v":0},{"$f":"'Front end'!E216","v":0}]
[null,"Domestic dishwashers, l/cycle",{"$f":"'Front end'!E219","v":0},{"$f":"'Front end'!E221","v":0},{"$f":"'Front end'!E223","v":0},{"$f":"'Front end'!E225","v":0},{"$f":"'Front end'!E227","v":0},{"$f":"'Front end'!E229","v":0},{"$f":"'Front end'!E231","v":0},{"$f":"'Front end'!E233","v":0}]
[null,"Restaurant kitchen taps, l/min",{"$f":"'Front end'!E236","v":0},{"$f":"'Front end'!E238","v":0},{"$f":"'Front end'!E240","v":0},{"$f":"'Front end'!E242","v":0},{"$f":"'Front end'!E244","v":0},{"$f":"'Front end'!E246","v":0},{"$f":"'Front end'!E248","v":0},{"$f":"'Front end'!E250","v":0}]
[null,"Waste disposal unit, litres/min",{"$f":"'Front end'!E253","v":0},{"$f":"'Front end'!E255","v":0},{"$f":"'Front end'!E257","v":0},{"$f":"'Front end'!E259","v":0},{"$f":"'Front end'!E261","v":0},{"$f":"'Front end'!E263","v":0},{"$f":"'Front end'!E265","v":0},{"$f":"'Front end'!E267","v":0}]
[null,"Commercial dishwasher, litres/rack",{"$f":"'Front end'!E270","v":0},{"$f":"'Front end'!E272","v":0},{"$f":"'Front end'!E274","v":0},{"$f":"'Front end'!E276","v":0},{"$f":"'Front end'!E278","v":0},{"$f":"'Front end'!E280","v":0},{"$f":"'Front end'!E282","v":0},{"$f":"'Front end'!E284","v":0}]
[null,"Comm/industr washing machine l/kg",{"$f":"'Front end'!E287","v":0},{"$f":"'Front end'!E289","v":0},{"$f":"'Front end'!E291","v":0},{"$f":"'Front end'!E293","v":0},{"$f":"'Front end'!E295","v":0},{"$f":"'Front end'!E297","v":0},{"$f":"'Front end'!E299","v":0},{"$f":"'Front end'!E301","v":0}]
[null,{"$f":"'Front end'!D304","v":"Does the building collect any grey water or black water?"},null,null,null,{"$f":"IF('Front end'!E304=\" \",\" \",'Front end'!E304)","v":"No"}]
[null,{"$f":"'Front end'!D333","v":"Does the building have any rainwater collection?"},null,null,null,{"$f":"IF('Front end'!E333=\" \",\" \",'Front end'!E333)","v":"No"}]
[null,{"$f":"'Front end'!D348","v":"Is recycled water used for WC flushing?"},null,null,null,{"$f":"IF('Front end'!E348=\" \",\" \",'Front end'!E348)","v":"No"}]
[null,{"$f":"'Front end'!D350","v":"Is recycled water used for urinals with timed flushing?"},null,null,null,{"$f":"IF('Front end'!E350=\"\",\"\",'Front end'!E350)","v":""}]
[null,"Is recycled water used for urinals with sensor/button flush?",null,null,null,{"$f":"IF('Front end'!E352=\"\",\"\",'Front end'!E352)","v":""}]
[]
[]
[null,"Water using component/other water sources",null,null,null,null,null,null,null,null,{"$f":"+calculation!L21","v":"lt per person per day"},{"$f":"+calculation!M21","v":"lt/m2 per day"},{"$f":"+calculation!N21","v":"m3/m2 per year"},{"$f":"+calculation!O21","v":"m3/year"}]
[null,"WC & urinals",null,null,null,null,null,null,null,null,{"$f":"+calculation!L55+calculation!L56+calculation!L57+calculation!L58","v":{"$error":"#N/A"}},{"$f":"+calculation!M55+calculation!M56+calculation!M57+calculation!M58","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!N55+calculation!N56+calculation!N57+calculation!N58","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!O55+calculation!O56+calculation!O57+calculation!O58","v":{"$error":"#DIV/0!"}}]
[null,"Wash hand basin tap",null,null,null,null,null,null,null,null,{"$f":"+calculation!L59","v":{"$error":"#N/A"}},{"$f":"+calculation!M59","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!N59","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!O59","v":{"$error":"#DIV/0!"}}]
[null,"Shower/bath",null,null,null,null,null,null,null,null,{"$f":"+calculation!L60+calculation!L61","v":{"$error":"#N/A"}},{"$f":"+calculation!M60+calculation!M61","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!N60+calculation!N61","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!O60+calculation!O61","v":{"$error":"#DIV/0!"}}]
[null,"Kitchen taps: kitchenette",null,null,null,null,null,null,null,null,{"$f":"+calculation!L62","v":{"$error":"#N/A"}},{"$f":"+calculation!M62","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!N62","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!O62","v":{"$error":"#DIV/0!"}}]
[null,"Domestic sized washing machine",null,null,null,null,null,null,null,null,{"$f":"+calculation!L63","v":{"$error":"#N/A"}},{"$f":"+calculation!M63","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!N63","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!O63","v":{"$error":"#DIV/0!"}}]
[null,"Domestic sized dishwasher",null,null,null,null,null,null,null,null,{"$f":"+calculation!L64","v":{"$error":"#N/A"}},{"$f":"+calculation!M64","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!N64","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!O64","v":{"$error":"#DIV/0!"}}]
[null,"Commercial kitchen",null,null,null,null,null,null,null,null,{"$f":"+calculation!L65+calculation!L66+calculation!L67","v":{"$error":"#N/A"}},{"$f":"+calculation!M65+calculation!M66+calculation!M67","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!N65+calculation!N66+calculation!N67","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!O65+calculation!O66+calculation!O67","v":{"$error":"#DIV/0!"}}]
[null,"Commercial washing",null,null,null,null,null,null,null,null,{"$f":"+calculation!L68","v":{"$error":"#N/A"}},{"$f":"+calculation!M68","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!N68","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!O68","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"+calculation!D36","v":"Total water use"},null,null,null,null,null,null,null,null,{"$f":"+calculation!L69","v":{"$error":"#N/A"}},{"$f":"+calculation!M69","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!N69","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!O69","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"+calculation!D37","v":"Rainwater available"},null,null,null,null,null,null,null,{"$f":"+calculation!L37","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!M37","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!N37","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!O37","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"+calculation!D38","v":"Grey and blackwater available"},null,null,null,null,null,null,null,{"$f":"+calculation!L38","v":{"$error":"#N/A"}},{"$f":"+calculation!M38","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!N38","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!O38","v":{"$error":"#DIV/0!"}},{"$f":"+O57-O58","v":0}]
[null,{"$f":"+calculation!D39","v":"Recycled water use"},null,null,null,null,null,null,null,null,{"$f":"+calculation!L72","v":{"$error":"#N/A"}},{"$f":"+calculation!M72","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!N72","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!O72","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"+calculation!D40","v":"Non-network water use"},null,null,null,null,null,null,null,null,{"$f":"+calculation!L73","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!M73","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!N73","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!O73","v":0}]
[null,{"$f":"+calculation!D41","v":"Network water use"},null,null,null,null,null,null,null,null,{"$f":"+calculation!L74","v":{"$error":"#N/A"}},{"$f":"+calculation!M74","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!N74","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!O74","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"+calculation!D42","v":"Water disposed of via  sewage network"},null,null,null,null,null,null,null,null,{"$f":"+calculation!L75","v":{"$error":"#N/A"}},{"$f":"+calculation!M75","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!N75","v":{"$error":"#DIV/0!"}},{"$f":"+calculation!O75","v":{"$error":"#DIV/0!"}}]
[null,"Carbon impact kgCO2e",null,null,null,null,null,null,null,null,{"$f":"+K62*'lookup tables'!$C61/'lookup tables'!C66+Output!K63*'lookup tables'!$C62/'lookup tables'!C66","v":{"$error":"#N/A"}},{"$f":"+L62*'lookup tables'!$C61/'lookup tables'!C66+Output!L63*'lookup tables'!$C62/'lookup tables'!C66","v":{"$error":"#DIV/0!"}},{"$f":"+M62*'lookup tables'!$C61+Output!M63*'lookup tables'!$C62","v":{"$error":"#DIV/0!"}},{"$f":"+N62*'lookup tables'!$C61+Output!N63*'lookup tables'!$C62","v":{"$error":"#DIV/0!"}}]

{"sheet":"Assumptions","index":5,"n_rows":58,"n_cols":7,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
[]
[]
[{"$f":"0.5*6/7","v":0.42857142857142855},"assume urinals get used in preference to toilets 45% of the time (50% male & a ratio of 7:1 urine:stool)",null,null,null,null,"https://www.medicalnewstoday.com/articles/321461"]
[0.78,"preference for showers over baths where both are installed",null,null,null,"https://www.independent.co.uk/life-style/health-and-families/health-news/shower-bath-choice-victorian-plumbing-survey-results-a8845946.html"]
[0.4,"typical fill of max bath capacity"]
[{"$f":"+'Activity database from wat 01'!AR37","v":0.67700000000000005},"typical % of full flow rate for taps"]
[0.95,"percentage recovery grey water"]
[0.8,"percentage recovery black water"]
[]
[]
[]
[null,"References"]
[null,"https://www.south-staffs-water.co.uk/media/1509/waterusebusiness.pdf"]
[null,"https://www.waterwise.org.uk/wp-content/uploads/2018/02/CIRIA-2006_Water-Key-Performance-Indicators-and-Benchmarks-for-Offices-and-Hotels.pdf"]
[null,"https://powerhousedynamics.com/resources/white-papers/water-water-everywhere-and-10-ways-restaurants-stem-flow/#:~:text=While%20there%20are%20studies%20that,gallons%20per%20seat%20per%20day."]
[null,"https://www.statista.com/statistics/656780/water-consumption-in-cafes-and-restaurants-united-kingdom-uk/"]
[null,"https://www.ashland.or.us/SIB/files/AWE_Commercial_Kitchens_Guide.pdf"]
[null,"https://sustain.ubc.ca/sites/default/files/2018-48%20Water%20benchmarking%20study%20-%20Restaurants%20%26%20microbreweries%20in%20the%20City%20of%20Vancouver_Sirikan.pdf"]
[null,"https://www.mdpi.com/2073-4441/14/23/3828"]
[null,"https://sustainablebuild.co.uk/grey-and-black-water-recycling-design/"]
[null,"https://aquacell.com.au/commercial-water-recycling-systems/blackwater/"]
[null,"https://www.designingbuildings.co.uk/wiki/Black_water_recycling#:~:text=Treatment%20is%20generally%20by%20a,Green%20Age%2C%20Recycling%20Domestic%20Sewage."]
[null,"https://jla.com/laundry-equipment/washing-machines/smart-wash/?_gl=1*ty1kz0*_up*MQ..&gclid=CjwKCAjwsKqoBhBPEiwALrrqiCVPF7o3Oea1vnL_3cX4YgmImwL8njiBLRKCORZXk4-sF3WDU5RyxBoC77AQAvD_BwE"]
["0.25*full+0.75*reduced","https://kb.breeam.com/us/knowledgebase/effective-flush-volume-efv-example-calculation/"]
[null,"greywater needs filtration"]
[null,"blackwater needs onsite sewage treatment"]
[]
[]
[]
[]
[]
[]
[]
[null,"Can be collected from","Treatment","can be used for"]
["Greywater","Everything except toilets","Filtration only","Toilets or watering non-food plants","Confirm that the blackwater treatment system meets local regulatory requirements"]
["Blackwater","WCs and urinals","Settlement, bacterial breakdown, filtration, aeration and chemical treatment","Toilets or watering plants","Confirm that the greywater treatment system meets local regulatory requirements"]
[]
[]
[]
[]
[null,"Replace the following text:"]
[null,"'Rainwater: In accordance with BS8515 ‘intermediate approach’:"]
[null,"1. Collection area (m²)"]
[null,"2. Yield co-efficient (%)"]
[null,"3. Hydraulic filter efficiency (%)"]
[null,"4. Rainfall (average mm/year)."]
[null,"Rainwater: In accordance with BS8515 ‘detailed approach’:"]
[null,"1. Daily rainfall collection (litres)'"]
[]
[null,"with"]
[]
[null,"'Rainwater: In accordance with BS EN 16941‑1:2018‘basic approach’:"]
[null,"1. Horizontal projection of the collection area (m²)"]
[null,"2. Surface yield coefficient (%)"]
[null,"3. Hydraulic treatment efficiency coefficient (%)"]
[null,"4. Anual rainfall (mm/year)."]
[null,"Rainwater: In accordance with BS EN 16941‑1:2018 ‘detailed approach’:"]
[null,"1. Daily rainfall collection (litres)'"]

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

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

{"sheet":"Activity database from wat 01","index":8,"n_rows":129,"n_cols":58,"rows_kept":129,"cut":false,"hidden":true,"merged":[[1,6,1,7]]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,null,1,2,3,4,5,6,7,8]
[null,null,"Building occupation data",null,null,"User","Gender ratio",null,"Component uses/person/day (unless stated differently for specific uses or activity areas)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Usage factors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adjustment factors",null,null,"Microcomponent Performance Levels for BREEAM water consumption method benchmarking"]
["Building category and main activity area/function","Description","Occupant density (person/m2)","No. days/yr building occupied","default daily hrs of operation","Type","Ratio male users","Ratio female users","WC - male (urinals installed)","WC - male (no urinals installed)","WC - female","Urinal","Wash hand basin taps","Shower use","Shower use (bath present)","Bath use (no shower present) ","Bath use (shower present)","Kitchen taps - kitchenette","Kitchen taps - pre-rinse nozzle","blank column","Dishwasher","Washing machine","Waste disposal unit","Fixed use - vessel filling","Fixed use - food preparation","Fixed use - kitchen cleaning","WC (factor of use","Urinals (factor of use)","Wash hand basin taps (mins/use)","Showers (no bath present) - mins/use","Showers (bath present) mins/use","Bath (No shower present) ratio","Bath (shower present) ratio","Kitchen taps - kitchenette mins/day","Kitchen taps - pre-rinse nozzle","blank","Dishwasher","Washing machine","Waste dispoal unit","Fixed use - vessel filling","Fixed use - food preparation","Fixed use - kitchen cleaning","Baths","Taps",null,"Component","Baseline","Level 1","Level 2","Level 3","Level 4","Level 5","Unit",null,"BREEAM credit benchmarks",null,null,"Sources of data/information"]
["Office","TCP Classification B1: Offices and workshop business (including those with a basic (category 1) laboratory area)","-",253,10,"Staff",0.5,0.5,1,4,4,3,4,0.03,"N/A","N/A","N/A","-","-","-","-","N/A","-",1.58,"-","-",1,1,0.25,5.6,4.37,1,1,"-","-","-","-","-","-",1,"-","-",0.4,0.67700000000000005,null,"WC - male (urinals installed)",6,4.5,4,3.75,3.5,3,"Effective flush volume (litres)",null,0,"0 credits",null,"SD129: Certification and Listing of Low Flush WC appliances"]
["Office - Office areas","Cellular or open plan office space, including staff kitchen where present/adjacent and reception areas. Exlcude meeting rooms, visitor waiting or circulation areas.",0.111,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,0.04,null,null,null,null,null,null,null,null,null,null,null,null,0.67,null,null,1,"N/A",null,null,null,null,null,null,null,"WC - male (no urinals installed)",6,4.5,4,3.75,3.5,3,"Effective flush volume (litres)",null,0.125,"1 credit",null,"Waterwise "]
["Office - Staff canteen dining area","Seated dining areas that accompany a permanently staffed kitchen preparing food for consumption on the premises (excludes small un-staffed kitchen's used by office staff to re-heat food, make tea etc.)",4.3299999999999998E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"see usage factor",null,"see usage factor","N/A","see usage factor",null,5849.0006400000002,13810.991040000001,null,null,null,null,null,null,null,null,60,null,0.217,"N/A",30,null,1,1,null,null,null,"WC - female",6,4.5,4,3.75,3.5,3,"Effective flush volume (litres)",null,0.25,"2 credits",null,"Water efficient product labelling scheme"]
["Office - Small workshop / laboratory space","Small scale workshop or category 1 laboratory area",6.8000000000000005E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wash hand basin taps",10,8,6,5,4,3,"Volume (litres/min)",null,0.4,"3 credits",null,"Water Supply (water fittings) Regulations 1999: WC Suite Performance Specifications"]
["Office - Fitness suite/gym (with changing facility and showers)","A fitness suite or gym that is part of the office building/development  and used by the building's employees only. The gym will have its own changing facility with showers.",0,null,null,null,null,null,null,null,null,null,null,0.154,null,null,null,null,null,null,null,null,null,0.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Showers",12,10,8,6,5,3.5,"Volume (litres/min)",null,0.5,"4 credits",null,"(Very early) Draft BS8542"]
["Industrial - 24hr x 7 day operation","TCP Classification B2 to B8: general and specialist industrail and warehouse and storage units operating 24 hours a day 7 days a week.","-",365,24,"Staff",0.5,0.5,1,4,4,3,4,0.03,"N/A","N/A","N/A","-","-","-","-","N/A","-",1.58,"-","-",1,1,0.25,5.6,4.37,1,1,"-","-","-","-","-","-",1,"-","-",0.4,0.67700000000000005,null,"Baths",200,180,160,140,120,100,"Volume (litres)",null,0.55000000000000004,"5 credits",null,"SD174: Certification and Listing of Water Efficient Terminal Fittings (table 2.0)"]
["Industrial - typical business hours of operation","TCP Classification B2 to B8: general and specialist industrial and warehouse and storage units operating 24 hours a day 7 days a week.","-",253,10,"Staff",0.5,0.5,1,4,4,3,4,0.03,"N/A","N/A","N/A","-","-","-","-","N/A","-",1.58,"-","-",1,1,0.25,5.6,4.37,1,1,"-","-","-","-","-","-",1,"-","-",0.4,0.67700000000000005,null,"Urinal (2 or more urinals) - Automatically operated flushing cistern",7.5,6,3,1.5,0.75,0,"Volume (litres/bowl/hour)",null,0.65,"Exemplary level",null,"CLG Water Calculation Method for New Dwelling"]
["Industrial - process area","Main process based operational/manufacturing/workshop area",2.24E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urinal (1 urinal only) - Automatically operated flushing cistern",10,8,4,2,1,0,"Volume (litres/bowl/hour)",null,0.55000000000000004,"5 credits",null,"Conserving Water in Buildings - Environment Agency"]
["Industrial - Laboratory area","Large or small category 1 laboratory area.",0.1069,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urinal - Manual/automatic operated pressure flushing valve",1.5,"-","-","-","-","-","Volume (Litres/flush/bowl)",null,null,null,null,"SD175 Certification and Listing of Water Efficient Baths "]
["Industrial - Warehouse storage","Permanently or intermittently occupied warehouse storage areas.",1.0800000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Greywater/rainwater system",0,0,0,0.25,0.5,0.75,"% of WC/urinal flushing demand (generated by same level microcomponent specification) met by specified grey/rainwater system",null,null,null,null,"BNWAT07: Baths - water efficiency performance tests Version 2.0"]
["Industrial - Office areas","Cellular or open plan office space, including staff kitchen where present/adjacent and reception areas. Exlcude meeting rooms, visitor waiting or circulation areas.",9.9400000000000002E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,0.04,null,null,null,null,null,null,null,null,null,null,null,null,0.67,null,null,1,"N/A",null,null,null,null,null,null,null,"Kitchen taps - kitchenette",10,8,7,6,5,5,"Volume (litres/min)",null,null,null,null,"CLG Research to Assess the Costs and Benefits of Improvements to the Water Efficiency of New Non-household Buildings (BD2683), 2009."]
["Industrial - Staff canteen dining area","Seated dining areas that accompany a permanently staffed kitchen preparing food for consumption on the premises (excludes small un-staffed kitchen's used by office staff to re-heat food, make tea etc.)",{"$f":"0.0402","v":4.02E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"see usage factor",null,"see usage factor","N/A","see usage factor",null,{"$error":"#NAME?"},253.8228,null,null,null,null,null,null,null,null,60,null,0.20100000000000001,"N/A",30,null,1,1,null,null,null,"Kitchen taps - pre-rinse nozzle",10.3,9,8.3000000000000007,7.3,6.3,6,"Volume (litres/min)",null,null,null,null,"Waterwise 2007 Dishwasher rankings"]
["Industrial - Fitness suite/gym (with changing facility and showers)","A fitness suite or gym that is part of the office building/development  and used by the building's employees only. The gym will have its own changing facility with showers.",0,null,null,null,null,null,null,null,null,null,null,0.154,null,null,null,null,null,null,null,null,null,0.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Domestic sized dishwashers",17,13,13,12,11,10,"Volume (litres/cycle)",null,null,null,null,"Waterwise 2007 Washing machine rankings"]
["Education - pre-school or primary school","TCP Classification D1: non-residential pre-school and primary schools.","-",195,10,"Pupils/staff",0.5,0.5,0.36,2.1,2.1,1.74,2.1,1.4E-3,"N/A","N/A","N/A",0.05,"-","-","-","N/A","-",1.98,"-","-",1,1,0.25,5.6,"N/A",1,1,"-","-","-","-","-","-",1,"-","-",0.4,0.67700000000000005,null,"Domestic sized washing machines",90,60,50,40,35,30,"Volume (litres/use)",null,null,null,null,"Water UK - Macerators, the impact on sewers http://www.water.org.uk/home/policy/positions/waste-macerators-position-paper"]
["Education - secondary school or academy","TCP Classification D1: non-residential secondary schools, academies and all-age range schools","-",195,10,"Pupils/staff",0.5,0.5,0.37,2.13,2.1,1.76,2.13,2E-3,"N/A","N/A","N/A",0.06,"-","-","-","N/A","-",1.97,"-","-",1,1,0.25,5.6,1.4,1,1,"-","-","-","-","-","-",1,"-","-",0.4,0.67700000000000005,null,{"$f":"W3","v":"Waste disposal unit"},17,17,0,0,0,0,"Volume (litres/min)",null,null,null,null,"Water Efficient Buildings, water and planning, guidance for planners http://www.water-efficient-buildings.org.uk/"]
["Education - sixth form or further education college","TCP Classification D1: non-residential sixth form and further education colleges","-",195,10,"Staff/students",0.5,0.5,1,4,4,3,4,0.03,"N/A","N/A","N/A",5.0999999999999997E-2,"-","-","-","N/A","-",1.58,"-","-",1,1,0.25,5.6,4.37,1,1,"-","-","-","-","-","-",1,"-","-",0.4,0.67700000000000005,null,"Commercial sized dishwashers",8,7,6,5,4,3,"Volume (litres/rack)",null,null,null,null,"AECB Water Standards vol 2."]
["Education - higher education college","TCP Classification D1: non-residential higher education learning resource centres/teaching facility only.","-",195,10,"Staff/students",0.5,0.5,1,4,4,3,4,0.03,"N/A","N/A","N/A",6.0999999999999999E-2,"-","-","-","N/A","-",1.58,"-","-",1,1,0.25,5.6,4.37,1,1,"-","-","-","-","-","-",1,"-","-",0.4,0.67700000000000005,null,"Commercial/Industrial sized washing machines",14,12,10,7.5,5,4.5,"Volume (litres/kg)",null,null,null,null,"Enahnced Capital Allowance Water Technology List criteria"]
["Education - Classroom areas","Include basic classroom areas only. Exclude halls, specialist practical classrooms, i.e. ICT, and learning resource/library areas.",0.53200000000000003,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BNWAT22: Domestic water consumption in domestic and non-domestic properties"]
["Education - Staff office and adminstration areas","Cellular or open plan office space, including staff rooms and staff kitchen where present/adjacent and reception areas (including library reception desk areas if present). Exlcudes meeting rooms, visitor waiting or circulation areas and other such spaces not permanently occupied.",0.10299999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5999999999999999E-3,null,null,null,null,null,null,null,null,null,null,null,null,0.67,null,null,1,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"National Statistics, DfE: School Workforce in England, November 2010 (statistical first release)"]
["Education - Common room","Student common room.",0.10299999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Building Bulletin 99 (2nd Edition), Briefing Framework for Primary School Projects"]
["Education - dining area","Seated dining areas that accompany a permanently staffed kitchen preparing food for consumption on the premises (excludes small un-staffed kitchen's used by staff to re-heat food, make tea etc.)","See note",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"see usage factor",null,"see usage factor","N/A","see usage factor",null,false,0,null,null,null,null,null,null,null,null,60,null,0.45,"N/A",30,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Building Bulletin 98 (2nd Edition), Briefing Framework for Secondary School Projects"]
[null,"Changing facility with showers to be used by pupils ",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The Building Regulations 2000 Approved Document B Fire Safety"]
["Education - Lecture theatre","Lecture theatre with permanent seating and/or stage used by lecturers and/or for staged performances.",0.21830985915493001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Employment Densities, a full guide, Arup Economics and Planning, 2001 (produced for English Partnerships and Regional Development Agencies)"]
["Education - Study area","Study/write-up area in sixth form, further and/or Higer Education colleges.",0.625]
["Education - Workshop","Small scale workshop type space used for practical/vocational demonstrations/learning.",6.3259259264444506E-2]
["Education - Information Technology space","Laboratory/room containing I.T equipment and used for teaching/research related to information technology",0.23100000000000001]
["Education - Laboratory","Laboratory space for teaching/learning related to science based subjects.",0.10625]
["Retail - Shop / retail unit(s) / retail warehouse","TCP Classification A1 Shops: shop/retail unit(s)/retail warehouse(s). ","-",362,8.5,"-",0.35243002430024301,0.64756997569975705,0.14734068040680409,0.85184051840518404,0.85184051840518404,0.70479497794977952,0.85184051840518404,4.8600486004860038E-4,"N/A","N/A","N/A","-","-","-","-","N/A","-",2.5596255962559624E-2,"-","-",1,1,0.25,5.6,4.37,1,1,"-","-","-","-","-","-",{"$f":"AN32","v":1},"-","-",0.4,0.67700000000000005]
[null,null,"-","-","-","Staff",0.5,0.5,1,4,4,3,4,0.03,"N/A","N/A","N/A","-","-","-","-","N/A","-",1.58,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",1,"-","-","-","-"]
[null,null,"-","-","-","Customer",0.35,0.65,0.1333,0.8,0.8,0.66700000000000004,0.8,"-","N/A","N/A","N/A","-","-","-","-","N/A","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["Retail - Supermarket","TCP Classification A1 Shops: supermarket","-",362,13,"-",0.35243002430024301,0.64756997569975705,0.14734068040680409,0.85184051840518404,0.85184051840518404,0.70479497794977952,0.85184051840518404,4.8600486004860038E-4,"N/A","N/A","N/A","-","-","-","-","N/A","-",2.5596255962559624E-2,"-","-",1,1,0.25,5.6,4.37,1,1,"-","-","-","-","-","-",{"$f":"AN35","v":1},"-","-",0.4,0.67700000000000005]
[null,null,"-","-","-","Staff",0.5,0.5,1,4,4,3,4,0.03,"N/A","N/A","N/A","-","-","-","-","N/A","-",1.58,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",1,"-","-","-","-"]
[null,null,"-","-","-","Customers",0.35,0.65,0.1333,0.8,0.8,0.66700000000000004,0.8,"-","N/A","N/A","N/A","-","-","-","-","N/A","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["Retail - Service provider","TCP Classification A2: Financial and professional services - Financial services such as banks and building societies, professional services (other than health and medical services) including estate and employment agencies and betting offices. \n","-",304,8,"-",0.35243002430024301,0.64756997569975705,0.14734068040680409,0.85184051840518404,0.85184051840518404,0.70479497794977952,0.85184051840518404,4.8600486004860038E-4,"N/A","N/A","N/A","-","-","-","-","N/A","-",2.5596255962559624E-2,"-","-",1,1,0.25,5.6,4.37,1,1,"-","-","-","-","-","-",{"$f":"AN38","v":1},"-","-",0.4,0.67700000000000005]
[null,null,"-","-","-","Staff",0.5,0.5,1,4,4,3,4,0.03,"N/A","N/A","N/A","-","-","-","-","N/A","-",1.58,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",1,"-","-","-","-"]
[null,null,"-","-","-","Customer",0.35,0.65,0.1333,0.8,0.8,0.66700000000000004,0.8,"-","N/A","N/A","N/A","-","-","-","-","N/A","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["Retail - Shopping centre/complex","TCP Classification A1 - A2: mixture of shops, professional services.","-",362,9,"-",0.35243002430024301,0.64756997569975705,0.14734068040680409,0.85184051840518404,0.85184051840518404,0.70479497794977952,0.85184051840518404,4.8600486004860038E-4,"N/A","N/A","N/A","-","-","-","-","N/A","-",2.5596255962559624E-2,"-","-",1,1,0.25,5.6,4.37,1,1,"-","-","-","-","-","-",{"$f":"AN41","v":1},"-","-",0.4,0.67700000000000005]
[null,null,"-","-","-","Staff",0.5,0.5,1,4,4,3,4,0.03,"N/A","N/A","N/A","-","-","-","-","N/A","-",1.58,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",1,"-","-","-","-"]
[null,null,"-","-","-","Customer",0.35,0.65,0.1333,0.8,0.8,0.66700000000000004,0.8,"-","N/A","N/A","N/A","-","-","-","-","N/A","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["Retail - sales areas for display of bulky items","A retail sales/display area trading predominantly in bulky items, e.g. furniture, floor coverings, cycles, prams, large domestic appliances or other bulky goods, or trading on a wholesale self-selection basis.",0.14299999999999999]
["Retail - sales areas for display of non bulky items and/or customer service area.","A general sales/display areas in department stores, supermarkets, shops and/or customer service waiting and/or collection areas e.g. in banks, post office, bookmakers etc.",0.5]
["Retail - concourse/shopping mall","The central (shared) area within a shopping centre used for access by shoppers (typically a covered area containing one or more of benches, cafes, escalators etc.)",1.43]
["Retail - Staff office area and staffroom","Staff office space and staffroom, often located in 'back of house' areas.",9.5142857142857168E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.6200162001620014E-2,null,null,6.4800648006480054E-4,null,null,null,null,null,null,null,null,null,null,null,null,0.67,null,null,1,"N/A"]
["Retail - Staff canteen dining area","Seated areas in a staff canteen that accompany a food preparation areas where food and drink is consumed by staff on the premises.",4.9700000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"see usage factor",null,"see usage factor","N/A","see usage factor",null,"see note","See note",null,null,null,null,null,null,null,null,60,null,0.248,"N/A",30,null,1,1]
["Retail - Goods-in and storage area","Internal areas for receiving and storing goods.",1.0999999999999999E-2]
["Retail - Workshop","A workshop / vehicle servicing area within a car showroom or general workshop in other type of retail development.",6.8000000000000005E-2]
["Restaurants and cafés","TCP Classification A3 Restaurants and cafés - For the sale of food and drink for consumption on the premises - restaurants, snack bars and cafes. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Restaurants and cafés - Eating and drinking area","Seated areas that accompany a food preparation areas where food and drink is consumed by customers on the premises (includes customer service/counter areas)",0.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Restaurants and cafés - Food preparation area","Kitchen areas in cafes/restaurants contained within the development used to prepare food for customers",0.108,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,0.44,null,null,null,null,null,1]
["Restaurants and cafés - Office area","Generic office space used by staff",0.109,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
["Should we have fixed use in the baseline for waste disposal, showers and pre-rinse taps regardless of whether they're specified in actual building.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Should litres/meal be adjusted to account for fact not three courses?"]
[]
["A4 Drinking establishments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,0.44,null,null,null,null,null,1]
["A5 Hot food takeaways",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,0.44,null,null,null,null,null,1]
["B1 Business - Workshop/light industry"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["B2 General industrial - process/manufacturing unit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["B8 Storage or distribution - Warehouse unit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Hotels",null,"Occupant density  (person/room)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kg/ room/ night"]
["Hotel - Bedroom",null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.6]
["Hotel - Staff",null,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Hotel - restaurant"]
["C1 Boarding and guest houses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Hospital",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Care home",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Sheltered accommodation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Hall of residence",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Prison houseblock",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["C2A Secure Residential Institution - Secure local authority accommodation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["C2A Secure Residential Institution - Military barracks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["D1 Non-residential Institutions - Library",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["D1 Non-residential Institutions - Museum or Gallery",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["D1 Non-residential Institutions - Community centre, day centre or place of worship",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["D1 Non-residential Institutions - Primary Health Care Building",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["D1 Non-residential Institutions - Creche",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["D1 Non-residential Institutions - Crown and County Courts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["D1 Non-residential Institutions - School",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["D1 Non-residential Institutions - Further/ Higher education building or training centre",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["D2 General Assembly and Leisure - Theatre or cinema",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["D2 General Assembly and Leisure - leisure centre/gym",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["D2 General Assembly and Leisure -Swimming pool",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["D2 General Assembly and Leisure - Night Club or dance hall",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Residential spaces",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Other - Bus/train stations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Other - Emergency services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Other - Telephone exchanges",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Other - Car Parks 24 hrs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Other - Stand alone utility block",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Other - Petrol stations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Other - Hostel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Other - motor vehicle showroom",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Other - Launderette",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Microcomponent Performance Levels for BREEAM water consumption method benchmarking"]
["EU tax minimum requirements","Component","Baseline","Level 1","Level 2","Level 3","Level 4","Level 5","Unit"]
[{"$f":"+C107","v":6},"WC - male (urinals installed)",6,4.5,4,3.75,3.5,3,"Effective flush volume (litres)"]
[6,"WC - male (no urinals installed)",6,4.5,4,3.75,3.5,3,"Effective flush volume (litres)"]
[6,"WC - female",6,4.5,4,3.75,3.5,3,"Effective flush volume (litres)"]
[10,"Wash hand basin taps",10,8,6,5,4,3,"Volume (litres/min)"]
[12,"Showers",12,10,8,6,5,3.5,"Volume (litres/min)"]
[200,"Baths",200,180,160,140,120,100,"Volume (litres)"]
[7.5,"Urinal (2 or more urinals) - Automatically operated flushing cistern",7.5,6,3,1.5,0.75,0,"Volume (litres/bowl/hour)"]
[10,"Urinal (1 urinal only) - Automatically operated flushing cistern",10,8,4,2,1,0,"Volume (litres/bowl/hour)"]
[1.5,"Urinal - Manual/automatic operated pressure flushing valve",1.5,"-","-","-","-","-","Volume (Litres/flush/bowl)"]
[0,"Greywater/rainwater system",0,0,0,0.25,0.5,0.75,"% of WC/urinal flushing demand (generated by same level microcomponent specification) met by specified grey/rainwater system"]
[10,"Kitchen taps - kitchenette",10,8,7,6,5,5,"Volume (litres/min)"]
[10.3,"Kitchen taps - pre-rinse nozzle",10.3,9,8.3000000000000007,7.3,6.3,6,"Volume (litres/min)"]
[17,"Domestic sized dishwashers",17,13,13,12,11,10,"Volume (litres/cycle)"]
[90,"Domestic sized washing machines",90,60,50,40,35,30,"Volume (litres/use)"]
[17,"Waste disposal unit (commercial kitchens only)",17,17,0,0,0,0,"Volume (litres/min)"]
[8,"Commercial sized dishwashers",8,7,6,5,4,3,"Volume (litres/rack)"]
[14,"Commercial/Industrial sized washing machines",14,12,10,7.5,5,4.5,"Volume (litres/kg)"]
[]
[]
[null,null,{"$f":"AVERAGE(,C107:C109,C113:C115)","v":5.2857142857142856},4.583333333333333,3.1666666666666665,2.4583333333333335,2.0416666666666665,1.5]
[null,null,null,{"$f":"+(D126-D116/2)/$C$126","v":0.86711711711711703},{"$f":"+(E126-E116/2)/$C$126","v":0.59909909909909909},{"$f":"+(F126-F116/2)/$C$126","v":0.44144144144144148},{"$f":"+(G126-G116/2)/$C$126","v":0.33896396396396394},{"$f":"+(H126-H116/2)/$C$126","v":0.21283783783783786}]
[null,null,"% reduction",{"$f":"1-D127","v":0.13288288288288297},{"$f":"1-E127","v":0.40090090090090091},{"$f":"1-F127","v":0.55855855855855852},{"$f":"1-G127","v":0.66103603603603611},{"$f":"1-H127","v":0.78716216216216217}]
[null,null,"% reduction",0.15,0.3,0.45,0.6,0.75]

{"sheet":"logic tree","index":9,"n_rows":35,"n_cols":21,"rows_kept":35,"cut":false,"hidden":true,"merged":[[9,15,13,15],[9,19,13,19],[29,10,31,10],[29,12,30,12]]}
[]
[null,null,null,null,null,"Asset Water Caclulator"]
[]
[]
[]
[]
[null,null,null,null,null,"Has the building type been selected?","Building type determines annual usage rates for each component"]
[null,null,null,null,"N",null,"Y"]
[null,null,null,null,null,null,"Have installed water using components been selected?","Components present used to determine baseline and building water consumption",null,null,null,null,null,null,null,"Baseline water consumption",null,null,null,"Building water consumption"]
[null,null,null,null,null,"N",null,"Y",null,null,null,null,null,null,null,"Determined by \n- building type\n- water using components present\n- baseline water consumption values (fixed values)",null,null,null,"Determined by \n- building type\n- water consumption of installed components\nMinus\n- grey water use\n- rainwater use"]
[null,null,null,null,null,null,null,"Are there no water using components in the building?"]
[null,null,null,null,null,"Filter out credits","N",null,"Y"]
[null,null,null,null,null,null,null,null,"For each water using component selected"]
[null,null,null,null,null,null,null,null,"Has number of different types been specified"]
[null,null,null,null,null,null,null,"N",null,"Y"]
[null,null,null,null,null,null,null,null,null,"For each component type ",null,null,null,null,null,null,null,"% improvement over baseline",null,null,"Reporting metrics"]
[null,null,null,null,null,null,null,null,null,"Has the number of items and water consumption been specified","Performance of of installed items determines building water consumption",null,null,null,null,null,null,"Number of credits",null,null,"-m3 per year\n-m3/m2 per year\n-litres/person/day\n"]
[null,null,null,null,null,null,null,null,"N",null,"Y"]
[null,null,null,null,null,null,null,null,null,null,"Do you want to check against EU water criteria?"]
[null,null,null,null,null,null,null,null,null,"N",null,"Y","EU taxonomy output"]
[null,null,null,null,null,null,null,null,null,null,"Does the building use any recycled grey water?"]
[null,null,null,null,null,null,null,null,null,"N",null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,"For each water using component"]
[null,null,null,null,null,null,null,null,null,null,null,"Has the % of components from which grey water has been collected been specified","Determines grey water consumption"]
[null,null,null,null,null,null,null,null,null,null,"N",null,"Y"]
[null,null,null,null,null,null,null,null,null,null,"Does the building use any rainwater?"]
[null,null,null,null,null,null,null,null,null,"N",null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,"Has the rainwater system been measured using Standard A?"]
[null,null,null,null,null,null,null,null,null,null,"N",null,"Y"]
[null,null,null,null,null,null,null,null,null,null,"Has the rainwater system been measured using Standard B?",null,"Have outputs from Standard A been entered?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Determines rainwater consumption"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,"N",null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,"Have outputs from Standard B been entered?","Determines rainwater consumption"]
[null,null,null,null,null,null,null,null,null,null,"N",null,"Y"]

{"sheet":"Sheet1","index":10,"n_rows":96,"n_cols":58,"rows_kept":96,"cut":false,"hidden":true,"merged":[[1,6,1,7]]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,null,1,2,3,4,5,6,7,8]
[null,null,"Building occupation data",null,null,"User","Gender ratio",null,"Component uses/person/day (unless stated differently for specific uses or activity areas)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Usage factors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adjustment factors",null,null,"Microcomponent Performance Levels for BREEAM water consumption method benchmarking"]
["Building category and main activity area/function","Description","Occupant density (person/m2)","No. days/yr building occupied","default daily hrs of operation","Type","Ratio male users","Ratio female users","WC - male (urinals installed)","WC - male (no urinals installed)","WC - female","Urinal","Wash hand basin taps","Shower use","Shower use (bath present)","Bath use (no shower present) ","Bath use (shower present)","Kitchen taps - kitchenette","Kitchen taps - pre-rinse nozzle","blank column","Dishwasher","Washing machine","Waste disposal unit","Fixed use - vessel filling","Fixed use - food preparation","Fixed use - kitchen cleaning","WC (factor of use","Urinals (factor of use)","Wash hand basin taps (mins/use)","Showers (no bath present) - mins/use","Showers (bath present) mins/use","Bath (No shower present) ratio","Bath (shower present) ratio","Kitchen taps - kitchenette mins/day","Kitchen taps - pre-rinse nozzle","blank","Dishwasher","Washing machine","Waste dispoal unit","Fixed use - vessel filling","Fixed use - food preparation","Fixed use - kitchen cleaning","Baths","Taps",null,"Component","Baseline","Level 1","Level 2","Level 3","Level 4","Level 5","Unit",null,"BREEAM credit benchmarks",null,null,"Sources of data/information"]
["Office","TCP Classification B1: Offices and workshop business (including those with a basic (category 1) laboratory area)","-",253,10,"Staff",0.5,0.5,1,4,4,3,4,0.03,"N/A","N/A","N/A","-","-","-","-","N/A","-",1.58,"-","-",1,1,0.25,5.6,4.37,1,1,"-","-","-","-","-","-",1,"-","-",0.4,0.67700000000000005,null,"WC - male (urinals installed)",6,4.5,4,3.75,3.5,3,"Effective flush volume (litres)",null,0,"0 credits",null,"SD129: Certification and Listing of Low Flush WC appliances"]
["Office - Office areas","Cellular or open plan office space, including staff kitchen where present/adjacent and reception areas. Exlcude meeting rooms, visitor waiting or circulation areas.",0.111,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,0.04,null,null,null,null,null,null,null,null,null,null,null,null,0.67,null,null,1,"N/A",null,null,null,null,null,null,null,"WC - male (no urinals installed)",6,4.5,4,3.75,3.5,3,"Effective flush volume (litres)",null,0.125,"1 credit",null,"Waterwise "]
["Office - Staff canteen dining area","Seated dining areas that accompany a permanently staffed kitchen preparing food for consumption on the premises (excludes small un-staffed kitchen's used by office staff to re-heat food, make tea etc.)",4.3299999999999998E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"see usage factor",null,"see usage factor","N/A","see usage factor",null,5849.0006400000002,13810.991040000001,null,null,null,null,null,null,null,null,60,null,0.217,"N/A",30,null,1,1,null,null,null,"WC - female",6,4.5,4,3.75,3.5,3,"Effective flush volume (litres)",null,0.25,"2 credits",null,"Water efficient product labelling scheme"]
["Office - Small workshop / laboratory space","Small scale workshop or category 1 laboratory area",6.8000000000000005E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wash hand basin taps",10,8,6,5,4,3,"Volume (litres/min)",null,0.4,"3 credits",null,"Water Supply (water fittings) Regulations 1999: WC Suite Performance Specifications"]
["Office - Fitness suite/gym (with changing facility and showers)","A fitness suite or gym that is part of the office building/development  and used by the building's employees only. The gym will have its own changing facility with showers.",0,null,null,null,null,null,null,null,null,null,null,0.154,null,null,null,null,null,null,null,null,null,0.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Showers",12,10,8,6,5,3.5,"Volume (litres/min)",null,0.5,"4 credits",null,"(Very early) Draft BS8542"]
["Industrial - 24hr x 7 day operation","TCP Classification B2 to B8: general and specialist industrail and warehouse and storage units operating 24 hours a day 7 days a week.","-",365,24,"Staff",0.5,0.5,1,4,4,3,4,0.03,"N/A","N/A","N/A","-","-","-","-","N/A","-",1.58,"-","-",1,1,0.25,5.6,4.37,1,1,"-","-","-","-","-","-",1,"-","-",0.4,0.67700000000000005,null,"Baths",200,180,160,140,120,100,"Volume (litres)",null,0.55000000000000004,"5 credits",null,"SD174: Certification and Listing of Water Efficient Terminal Fittings (table 2.0)"]
["Industrial - typical business hours of operation","TCP Classification B2 to B8: general and specialist industrial and warehouse and storage units operating 24 hours a day 7 days a week.","-",253,10,"Staff",0.5,0.5,1,4,4,3,4,0.03,"N/A","N/A","N/A","-","-","-","-","N/A","-",1.58,"-","-",1,1,0.25,5.6,4.37,1,1,"-","-","-","-","-","-",1,"-","-",0.4,0.67700000000000005,null,"Urinal (2 or more urinals) - Automatically operated flushing cistern",7.5,6,3,1.5,0.75,0,"Volume (litres/bowl/hour)",null,0.65,"Exemplary level",null,"CLG Water Calculation Method for New Dwelling"]
["Industrial - process area","Main process based operational/manufacturing/workshop area",2.24E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urinal (1 urinal only) - Automatically operated flushing cistern",10,8,4,2,1,0,"Volume (litres/bowl/hour)",null,0.55000000000000004,"5 credits",null,"Conserving Water in Buildings - Environment Agency"]
["Industrial - Laboratory area","Large or small category 1 laboratory area.",0.1069,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urinal - Manual/automatic operated pressure flushing valve",1.5,"-","-","-","-","-","Volume (Litres/flush/bowl)",null,null,null,null,"SD175 Certification and Listing of Water Efficient Baths "]
["Industrial - Warehouse storage","Permanently or intermittently occupied warehouse storage areas.",1.0800000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Greywater/rainwater system",0,0,0,0.25,0.5,0.75,"% of WC/urinal flushing demand (generated by same level microcomponent specification) met by specified grey/rainwater system",null,null,null,null,"BNWAT07: Baths - water efficiency performance tests Version 2.0"]
["Industrial - Office areas","Cellular or open plan office space, including staff kitchen where present/adjacent and reception areas. Exlcude meeting rooms, visitor waiting or circulation areas.",9.9400000000000002E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,0.04,null,null,null,null,null,null,null,null,null,null,null,null,0.67,null,null,1,"N/A",null,null,null,null,null,null,null,"Kitchen taps - kitchenette",10,8,7,6,5,5,"Volume (litres/min)",null,null,null,null,"CLG Research to Assess the Costs and Benefits of Improvements to the Water Efficiency of New Non-household Buildings (BD2683), 2009."]
["Industrial - Staff canteen dining area","Seated dining areas that accompany a permanently staffed kitchen preparing food for consumption on the premises (excludes small un-staffed kitchen's used by office staff to re-heat food, make tea etc.)",{"$f":"0.0402","v":4.02E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"see usage factor",null,"see usage factor","N/A","see usage factor",null,{"$error":"#NAME?"},253.8228,null,null,null,null,null,null,null,null,60,null,0.20100000000000001,"N/A",30,null,1,1,null,null,null,"Kitchen taps - pre-rinse nozzle",10.3,9,8.3000000000000007,7.3,6.3,6,"Volume (litres/min)",null,null,null,null,"Waterwise 2007 Dishwasher rankings"]
["Industrial - Fitness suite/gym (with changing facility and showers)","A fitness suite or gym that is part of the office building/development  and used by the building's employees only. The gym will have its own changing facility with showers.",0,null,null,null,null,null,null,null,null,null,null,0.154,null,null,null,null,null,null,null,null,null,0.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Domestic sized dishwashers",17,13,13,12,11,10,"Volume (litres/cycle)",null,null,null,null,"Waterwise 2007 Washing machine rankings"]
["Education - pre-school or primary school","TCP Classification D1: non-residential pre-school and primary schools.","-",195,10,"Pupils/staff",0.5,0.5,0.36,2.1,2.1,1.74,2.1,1.4E-3,"N/A","N/A","N/A",0.05,"-","-","-","N/A","-",1.98,"-","-",1,1,0.25,5.6,"N/A",1,1,"-","-","-","-","-","-",1,"-","-",0.4,0.67700000000000005,null,"Domestic sized washing machines",90,60,50,40,35,30,"Volume (litres/use)",null,null,null,null,"Water UK - Macerators, the impact on sewers http://www.water.org.uk/home/policy/positions/waste-macerators-position-paper"]
["Education - secondary school or academy","TCP Classification D1: non-residential secondary schools, academies and all-age range schools","-",195,10,"Pupils/staff",0.5,0.5,0.37,2.13,2.1,1.76,2.13,2E-3,"N/A","N/A","N/A",0.06,"-","-","-","N/A","-",1.97,"-","-",1,1,0.25,5.6,1.4,1,1,"-","-","-","-","-","-",1,"-","-",0.4,0.67700000000000005,null,{"$f":"W3","v":"Waste disposal unit"},17,17,0,0,0,0,"Volume (litres/min)",null,null,null,null,"Water Efficient Buildings, water and planning, guidance for planners http://www.water-efficient-buildings.org.uk/"]
["Education - sixth form or further education college","TCP Classification D1: non-residential sixth form and further education colleges","-",195,10,"Staff/students",0.5,0.5,1,4,4,3,4,0.03,"N/A","N/A","N/A",5.0999999999999997E-2,"-","-","-","N/A","-",1.58,"-","-",1,1,0.25,5.6,4.37,1,1,"-","-","-","-","-","-",1,"-","-",0.4,0.67700000000000005,null,"Commercial sized dishwashers",8,7,6,5,4,3,"Volume (litres/rack)",null,null,null,null,"AECB Water Standards vol 2."]
["Education - higher education college","TCP Classification D1: non-residential higher education learning resource centres/teaching facility only.","-",195,10,"Staff/students",0.5,0.5,1,4,4,3,4,0.03,"N/A","N/A","N/A",6.0999999999999999E-2,"-","-","-","N/A","-",1.58,"-","-",1,1,0.25,5.6,4.37,1,1,"-","-","-","-","-","-",1,"-","-",0.4,0.67700000000000005,null,"Commercial/Industrial sized washing machines",14,12,10,7.5,5,4.5,"Volume (litres/kg)",null,null,null,null,"Enahnced Capital Allowance Water Technology List criteria"]
["Education - Classroom areas","Include basic classroom areas only. Exclude halls, specialist practical classrooms, i.e. ICT, and learning resource/library areas.",0.53200000000000003,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BNWAT22: Domestic water consumption in domestic and non-domestic properties"]
["Education - Staff office and adminstration areas","Cellular or open plan office space, including staff rooms and staff kitchen where present/adjacent and reception areas (including library reception desk areas if present). Exlcudes meeting rooms, visitor waiting or circulation areas and other such spaces not permanently occupied.",0.10299999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5999999999999999E-3,null,null,null,null,null,null,null,null,null,null,null,null,0.67,null,null,1,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"National Statistics, DfE: School Workforce in England, November 2010 (statistical first release)"]
["Education - Common room","Student common room.",0.10299999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Building Bulletin 99 (2nd Edition), Briefing Framework for Primary School Projects"]
["Education - dining area","Seated dining areas that accompany a permanently staffed kitchen preparing food for consumption on the premises (excludes small un-staffed kitchen's used by staff to re-heat food, make tea etc.)","See note",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"see usage factor",null,"see usage factor","N/A","see usage factor",null,false,0,null,null,null,null,null,null,null,null,60,null,0.45,"N/A",30,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Building Bulletin 98 (2nd Edition), Briefing Framework for Secondary School Projects"]
["Education - Changing facilities with showers ","Changing facility with showers to be used by pupils ",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The Building Regulations 2000 Approved Document B Fire Safety"]
["Education - Lecture theatre","Lecture theatre with permanent seating and/or stage used by lecturers and/or for staged performances.",0.21830985915493001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Employment Densities, a full guide, Arup Economics and Planning, 2001 (produced for English Partnerships and Regional Development Agencies)"]
["Education - Study area","Study/write-up area in sixth form, further and/or Higer Education colleges.",0.625]
["Education - Workshop","Small scale workshop type space used for practical/vocational demonstrations/learning.",6.3259259264444506E-2]
["Education - Information Technology space","Laboratory/room containing I.T equipment and used for teaching/research related to information technology",0.23100000000000001]
["Education - Laboratory","Laboratory space for teaching/learning related to science based subjects.",0.10625]
["Retail - Shop / retail unit(s) / retail warehouse","TCP Classification A1 Shops: shop/retail unit(s)/retail warehouse(s). ","-",362,8.5,"-",0.35243002430024301,0.64756997569975705,0.14734068040680409,0.85184051840518404,0.85184051840518404,0.70479497794977952,0.85184051840518404,4.8600486004860038E-4,"N/A","N/A","N/A","-","-","-","-","N/A","-",2.5596255962559624E-2,"-","-",1,1,0.25,5.6,4.37,1,1,"-","-","-","-","-","-",{"$f":"AN32","v":1},"-","-",0.4,0.67700000000000005]
[null,null,"-","-","-","Staff",0.5,0.5,1,4,4,3,4,0.03,"N/A","N/A","N/A","-","-","-","-","N/A","-",1.58,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",1,"-","-","-","-"]
[null,null,"-","-","-","Customer",0.35,0.65,0.1333,0.8,0.8,0.66700000000000004,0.8,"-","N/A","N/A","N/A","-","-","-","-","N/A","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["Retail - Supermarket","TCP Classification A1 Shops: supermarket","-",362,13,"-",0.35243002430024301,0.64756997569975705,0.14734068040680409,0.85184051840518404,0.85184051840518404,0.70479497794977952,0.85184051840518404,4.8600486004860038E-4,"N/A","N/A","N/A","-","-","-","-","N/A","-",2.5596255962559624E-2,"-","-",1,1,0.25,5.6,4.37,1,1,"-","-","-","-","-","-",{"$f":"AN35","v":1},"-","-",0.4,0.67700000000000005]
[null,null,"-","-","-","Staff",0.5,0.5,1,4,4,3,4,0.03,"N/A","N/A","N/A","-","-","-","-","N/A","-",1.58,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",1,"-","-","-","-"]
[null,null,"-","-","-","Customers",0.35,0.65,0.1333,0.8,0.8,0.66700000000000004,0.8,"-","N/A","N/A","N/A","-","-","-","-","N/A","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["Retail - Service provider","TCP Classification A2: Financial and professional services - Financial services such as banks and building societies, professional services (other than health and medical services) including estate and employment agencies and betting offices. \n","-",304,8,"-",0.35243002430024301,0.64756997569975705,0.14734068040680409,0.85184051840518404,0.85184051840518404,0.70479497794977952,0.85184051840518404,4.8600486004860038E-4,"N/A","N/A","N/A","-","-","-","-","N/A","-",2.5596255962559624E-2,"-","-",1,1,0.25,5.6,4.37,1,1,"-","-","-","-","-","-",{"$f":"AN38","v":1},"-","-",0.4,0.67700000000000005]
[null,null,"-","-","-","Staff",0.5,0.5,1,4,4,3,4,0.03,"N/A","N/A","N/A","-","-","-","-","N/A","-",1.58,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",1,"-","-","-","-"]
[null,null,"-","-","-","Customer",0.35,0.65,0.1333,0.8,0.8,0.66700000000000004,0.8,"-","N/A","N/A","N/A","-","-","-","-","N/A","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["Retail - Shopping centre/complex","TCP Classification A1 - A2: mixture of shops, professional services.","-",362,9,"-",0.35243002430024301,0.64756997569975705,0.14734068040680409,0.85184051840518404,0.85184051840518404,0.70479497794977952,0.85184051840518404,4.8600486004860038E-4,"N/A","N/A","N/A","-","-","-","-","N/A","-",2.5596255962559624E-2,"-","-",1,1,0.25,5.6,4.37,1,1,"-","-","-","-","-","-",{"$f":"AN41","v":1},"-","-",0.4,0.67700000000000005]
[null,null,"-","-","-","Staff",0.5,0.5,1,4,4,3,4,0.03,"N/A","N/A","N/A","-","-","-","-","N/A","-",1.58,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",1,"-","-","-","-"]
[null,null,"-","-","-","Customer",0.35,0.65,0.1333,0.8,0.8,0.66700000000000004,0.8,"-","N/A","N/A","N/A","-","-","-","-","N/A","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["Retail - sales areas for display of bulky items","A retail sales/display area trading predominantly in bulky items, e.g. furniture, floor coverings, cycles, prams, large domestic appliances or other bulky goods, or trading on a wholesale self-selection basis.",0.14299999999999999]
["Retail - sales areas for display of non bulky items and/or customer service area.","A general sales/display areas in department stores, supermarkets, shops and/or customer service waiting and/or collection areas e.g. in banks, post office, bookmakers etc.",0.5]
["Retail - concourse/shopping mall","The central (shared) area within a shopping centre used for access by shoppers (typically a covered area containing one or more of benches, cafes, escalators etc.)",1.43]
["Retail - Staff office area and staffroom","Staff office space and staffroom, often located in 'back of house' areas.",9.5142857142857168E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.6200162001620014E-2,null,null,6.4800648006480054E-4,null,null,null,null,null,null,null,null,null,null,null,null,0.67,null,null,1,"N/A"]
["Retail - Staff canteen dining area","Seated areas in a staff canteen that accompany a food preparation areas where food and drink is consumed by staff on the premises.",4.9700000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"see usage factor",null,"see usage factor","N/A","see usage factor",null,"see note",0,null,null,null,null,null,null,null,null,60,null,0.248,"N/A",30,null,1,1]
["Retail - Goods-in and storage area","Internal areas for receiving and storing goods.",1.0999999999999999E-2]
["Retail - Workshop","A workshop / vehicle servicing area within a car showroom or general workshop in other type of retail development.",6.8000000000000005E-2]
["Restaurants and cafés","TCP Classification A3 Restaurants and cafés - For the sale of food and drink for consumption on the premises - restaurants, snack bars and cafes. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Restaurants and cafés - Eating and drinking area","Seated areas that accompany a food preparation areas where food and drink is consumed by customers on the premises (includes customer service/counter areas)",0.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Restaurants and cafés - Food preparation area","Kitchen areas in cafes/restaurants contained within the development used to prepare food for customers",0.108,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,0.44,null,null,null,null,null,1]
["Restaurants and cafés - Office area","Generic office space used by staff",0.109,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
["Should we have fixed use in the baseline for waste disposal, showers and pre-rinse taps regardless of whether they're specified in actual building.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Should litres/meal be adjusted to account for fact not three courses?"]
[]
["A4 Drinking establishments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,0.44,null,null,null,null,null,1]
["A5 Hot food takeaways",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,0.44,null,null,null,null,null,1]
["B1 Business - Workshop/light industry"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["B2 General industrial - process/manufacturing unit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["B8 Storage or distribution - Warehouse unit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Hotels",null,"Occupant density  (person/room)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kg/ room/ night"]
["Hotel - Bedroom",null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.6]
["Hotel - Staff",null,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Hotel - restaurant"]
["C1 Boarding and guest houses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Hospital",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Care home",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Sheltered accommodation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Hall of residence",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Prison houseblock",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["C2A Secure Residential Institution - Secure local authority accommodation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["C2A Secure Residential Institution - Military barracks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["D1 Non-residential Institutions - Library",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["D1 Non-residential Institutions - Museum or Gallery",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["D1 Non-residential Institutions - Community centre, day centre or place of worship",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["D1 Non-residential Institutions - Primary Health Care Building",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["D1 Non-residential Institutions - Creche",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["D1 Non-residential Institutions - Crown and County Courts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["D1 Non-residential Institutions - School",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["D1 Non-residential Institutions - Further/ Higher education building or training centre",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["D2 General Assembly and Leisure - Theatre or cinema",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["D2 General Assembly and Leisure - leisure centre/gym",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["D2 General Assembly and Leisure -Swimming pool",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["D2 General Assembly and Leisure - Night Club or dance hall",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Residential spaces",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Other - Bus/train stations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Other - Emergency services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Other - Telephone exchanges",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Other - Car Parks 24 hrs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Other - Stand alone utility block",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Other - Petrol stations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Other - Hostel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Other - motor vehicle showroom",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]
["Other - Launderette",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,5.6,4.37,1,1,null,null,null,null,null,null,1]