{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["Cover","Page 1","Conversion Sheet A","Page 2","Page 3","Page 4","Page 5","Page 6","Page 7","Page 8","CV"],"not_rendered":{"charts":1,"images":2,"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":49,"n_cols":11,"rows_kept":49,"merged":[[1,10,9,36],[53,12,53,13],[53,14,53,18],[53,20,53,22],[53,23,53,24]]}
[]
[{"$nulls":10},"\nInstructions Sheet \n(MSW3: Large Domestic and Large Fire Service Connections)\n\n*2-inch and smaller diameter water service connection is classified as small service connection and 3-inch and larger diameter water service connection is classified as large service connection"]
{"$rows_empty":45}
[null,"DIM*- Domestic Irrigation Mechanical"]
[null,"WSFU*= Water Supply Fixture Units"]

{"sheet":"Page 1","index":1,"n_rows":52,"n_cols":36,"rows_kept":52,"merged":[[1,10,9,21],[1,22,2,28],[1,29,2,36],[3,22,3,28],[3,29,3,36],[4,22,4,28],[4,29,4,36],[5,22,5,28],[5,29,5,36],[6,22,6,28],[6,29,6,36],[13,4,14,10],[13,11,14,14],[13,15,14,20],[13,21,14,24],[13,26,14,28],[13,30,14,34],[15,21,15,24],[15,26,15,28],[15,30,15,34],[16,21,16,24],[16,26,16,28],[16,30,16,34],[17,21,17,24],[17,26,17,28],[17,30,17,34],[18,21,18,24],[18,26,18,28],[18,30,18,34],[19,21,19,24],[19,26,19,28],[19,30,19,34],[20,21,20,24],[20,26,20,28],[20,30,20,34],[21,21,21,24],[21,26,21,28],[21,30,21,34],[22,21,22,24],[22,26,22,28],[22,30,22,34],[23,21,23,24],[23,26,23,28],[23,30,23,34],[24,21,24,24],[24,26,24,28],[24,30,24,34],[25,21,25,24],[25,26,25,28],[25,30,25,34],[26,21,26,24],[26,26,26,28],[26,30,26,34],[27,21,27,24],[27,26,27,28],[27,30,27,34],[28,21,28,24],[28,26,28,28],[28,30,28,34],[29,21,29,24],[29,26,29,28],[29,30,29,34],[30,21,30,24],[30,26,30,28],[30,30,30,34],[31,21,31,24],[31,26,31,28],[31,30,31,34],[32,21,32,24],[32,26,32,28],[32,30,32,34],[33,21,33,24],[33,26,33,28],[33,30,33,34],[34,21,34,24],[34,26,34,28],[34,30,34,34],[35,21,35,24],[35,26,35,28],[35,30,35,34],[36,21,36,24],[36,26,36,28],[36,30,36,34],[37,4,42,10],[37,21,37,24],[37,26,37,28],[37,30,37,34],[38,21,38,24],[38,26,38,28],[38,30,38,34],[39,21,39,24],[39,26,39,28],[39,30,39,34],[40,21,40,24],[40,26,40,28],[40,30,40,34],[41,21,41,24],[41,26,41,28],[41,30,41,34],[42,21,42,24],[42,26,42,28],[42,30,42,34],[43,21,43,24],[43,26,43,28],[43,30,43,34],[44,21,44,24],[44,26,44,28],[44,30,44,34],[45,21,45,24],[45,26,45,28],[45,30,45,34],[46,30,46,34],[47,30,47,34],[48,1,50,21]]}
[]
[{"$nulls":10},"Water Supply Fixture Units Worksheet (MSW3)",{"$nulls":11},"Project Address:"]
[]
[{"$nulls":22},"Square #:"]
[{"$nulls":22},"Lot #:"]
[{"$nulls":22},"DC Water Tracking #:"]
[{"$nulls":22},"DCRA Tracking #:"]
[]
[{"$nulls":33},"Input Cells"]
[]
[]
[{"$nulls":3},"Predominant Supply Systems:",{"$nulls":17},"Type of Occupancy:"]
[]
[{"$nulls":4},"Fixture Type ",{"$nulls":6},"Occupancy",{"$nulls":3},"Type of Supply Control",{"$nulls":5},"Number of\n Fixtures",{"$nulls":4},"Load Value ",{"$nulls":3},"WSFU"]
[]
[{"$nulls":4},"Full-bath group**",{"$nulls":6},"Private",{"$nulls":3},"Flush Tank",{"$nulls":9},"x",3.6,null,null,"=",{"$f":"IF(V16*AA16=0,\" \",V16*AA16)","v":" "}]
[{"$nulls":11},"Private",{"$nulls":3},"Flushometer Valve",{"$nulls":9},"x",{"v":8,"d":"8.0"},null,null,"=",{"$f":"IF(V17*AA17=0,\" \",V17*AA17)","v":" "}]
[{"$nulls":4},"Bathtub",{"$nulls":6},"Private",{"$nulls":3},"Faucet",{"$nulls":9},"x",1.4,null,null,"="," "]
[{"$nulls":11},"Public",{"$nulls":3},"Faucet",{"$nulls":9},"x",{"v":4,"d":"4.0"},null,null,"="," "]
[{"$nulls":4},"Bidet",{"$nulls":6},"Private",{"$nulls":3},"Faucet",{"$nulls":9},"x",{"v":2,"d":"2.0"},null,null,"="," "]
[{"$nulls":4},"Combination fixture",{"$nulls":6},"Private",{"$nulls":3},"Faucet",{"$nulls":9},"x",{"v":3,"d":"3.0"},null,null,"="," "]
[{"$nulls":4},"Dishwashing machine",{"$nulls":6},"Private",{"$nulls":3},"Automatic",{"$nulls":9},"x",1.4,null,null,"="," "]
[{"$nulls":4},"Drinking Fountain",{"$nulls":6},"Office, etc.",{"$nulls":3},"3/8\" Valve",{"$nulls":9},"x",0.25,null,null,"="," "]
[{"$nulls":4},"Kitchen sink",{"$nulls":6},"Private",{"$nulls":3},"Faucet",{"$nulls":9},"x",1.4,null,null,"="," "]
[{"$nulls":11},"Commercial",{"$nulls":3},"Faucet",{"$nulls":9},"x",{"v":3,"d":"3.0"},null,null,"="," "]
[{"$nulls":4},"Laundry trays (1-3)",{"$nulls":6},"Private",{"$nulls":3},"Faucet",{"$nulls":9},"x",1.4,null,null,"="," "]
[{"$nulls":4},"Lavatory sink",{"$nulls":6},"Private",{"$nulls":3},"Faucet",{"$nulls":9},"x",0.7,null,null,"="," "]
[{"$nulls":11},"Public",{"$nulls":3},"Faucet",{"$nulls":9},"x",{"v":2,"d":"2.0"},null,null,"="," "]
[{"$nulls":4},"Service sink",{"$nulls":6},"Public",{"$nulls":3},"Faucet",{"$nulls":9},"x",{"v":3,"d":"3.0"},null,null,"="," "]
[{"$nulls":4},"Shower head",{"$nulls":6},"Private",{"$nulls":3},"Mixing Valve",{"$nulls":9},"x",1.4,null,null,"="," "]
[{"$nulls":11},"Public",{"$nulls":3},"Mixing Valve",{"$nulls":9},"x",{"v":3,"d":"3.0"},null,null,"="," "]
[{"$nulls":4},"Urinal**",{"$nulls":6},"Public",{"$nulls":3},"1\" Flushometer Valve",{"$nulls":9},"x",{"v":10,"d":"10.0"},null,null,"="," "]
[{"$nulls":11},"Public",{"$nulls":3},"3/4\" Flushometer Valve",{"$nulls":9},"x",{"v":5,"d":"5.0"},null,null,"="," "]
[{"$nulls":11},"Public",{"$nulls":3},"Flush Tank",{"$nulls":9},"x",{"v":3,"d":"3.0"},null,null,"="," "]
[{"$nulls":4},"Washing machine (8 lb)",{"$nulls":6},"Private",{"$nulls":3},"Automatic",{"$nulls":9},"x",1.4,null,null,"="," "]
[{"$nulls":4},"Washing machine (8 lb)",{"$nulls":6},"Public",{"$nulls":3},"Automatic",{"$nulls":9},"X",{"v":3,"d":"3.0"},null,null,"="," "]
[{"$nulls":4},"Washing machine (15 lb)",{"$nulls":6},"Public",{"$nulls":3},"Automatic",{"$nulls":9},"x",{"v":4,"d":"4.0"},null,null,"="," "]
[{"$nulls":4},"Water closet**",{"$nulls":6},"Private",{"$nulls":3},"Flush Tank",{"$nulls":9},"x",{"v":2.2,"d":"2.20"},null,null,"=",{"$f":"IF(V38*AA38=0,\" \",V38*AA38)","v":" "}]
[{"$nulls":11},"Private",{"$nulls":3},"Flushometer Valve",{"$nulls":9},"x",{"v":6,"d":"6.00"},null,null,"=",{"$f":"IF(V39*AA39=0,\" \",V39*AA39)","v":" "}]
[{"$nulls":11},"Private",{"$nulls":3},"Flushometer Tank",{"$nulls":9},"x",{"v":2,"d":"2.00"},null,null,"=",{"$f":"IF(V40*AA40=0,\" \",V40*AA40)","v":" "}]
[{"$nulls":11},"Public",{"$nulls":3},"Flushometer Valve",{"$nulls":9},"x",{"v":10,"d":"10.00"},null,null,"=",{"$f":"IF(V41*AA41=0,\" \",V41*AA41)","v":" "}]
[{"$nulls":11},"Public",{"$nulls":3},"Flush Tank",{"$nulls":9},"x",{"v":5,"d":"5.00"},null,null,"=",{"$f":"IF(V42*AA42=0,\" \",V42*AA42)","v":" "}]
[{"$nulls":11},"Public",{"$nulls":3},"Flushometer Tank",{"$nulls":9},"x",{"v":2,"d":"2.00"},null,null,"=",{"$f":"IF(V43*AA43=0,\" \",V43*AA43)","v":" "}]
[{"$nulls":4},"Other",{"$nulls":20},"x",{"v":0,"d":"0.0"},null,null,"="," "]
[{"$nulls":4},"Other",{"$nulls":20},"x",{"v":0,"d":"0.0"},null,null,"="," "]
[{"$nulls":4},"Other",{"$nulls":20},"x",{"v":0,"d":"0.0"},null,null,"="," "]
[{"$nulls":22},"Total WSFU2:",{"$nulls":7},{"$f":"IF(SUM(AE16:AI46)=0,\" \",SUM(AE16:AI46))","v":" "}]
[null,"1Domestic demand is calculated as per International Plumbing Code 2012 edition.",{"$nulls":20},"Domestic Demand1:",{"$nulls":7},{"$f":"IF(AE47=\" \",\" \",IF(AE47>5000,\"NA\",IF('Conversion Sheet A'!B29=1,'Conversion Sheet A'!C4,'Conversion Sheet A'!C18)))","v":" "},{"$nulls":4},"GPM"]
[null,"2If the total WSFU is greater than 5000, this spreadsheet can not be used in calculating domestic demand.  Provide an alternative method for computing the proposed domestic demand."]
[]
[]
[null,"** See the definition on page 6"]

{"sheet":"Conversion Sheet A","index":2,"n_rows":54,"n_cols":16,"rows_kept":54,"hidden":true,"merged":[[0,5,0,6],[0,8,0,9],[0,12,0,13],[1,11,1,15],[9,11,9,15],[9,17,9,21],[19,11,19,15],[27,11,27,15]]}
["System Type","FlushTank",{"$nulls":3},"FlushTank",null,null,"FlushometerValve"]
[{"$nulls":5},"WSFU","GPM",null,"WSFU","GPM",null,"Domestic Demand WFSU to GPM (FlushTank)"]
[null,"WSFU","Demand",null,null,1,{"v":3,"d":"3.0"},null,1,{"v":15,"d":"15.0"},null,"Row",{"$f":"MATCH($B$4,$F$1:$F$54)","v":{"$error":"#N/A"}},null,"Row",{"$f":"MATCH(B4,$F$1:$F$54)+1","v":{"$error":"#N/A"}}]
["Domestic Demand",{"$f":"'Page 1'!AE47","v":" "},{"$f":"M8","v":{"$error":"#N/A"}},null,null,2,{"v":5,"d":"5.0"},null,2,{"v":15,"d":"15.0"},null,"GPM",{"$f":"INDEX($F$1:$G$54,M3,2)","v":{"$error":"#N/A"}},null,"GPM",{"$f":"INDEX($F$1:$G$54,P3,2)","v":{"$error":"#N/A"}}]
[{"$nulls":5},3,6.5,null,3,{"v":15,"d":"15.0"},null,"WSFUs",{"$f":"INDEX($F$1:$G$54,M3,1)","v":{"$error":"#N/A"}},null,"WSFUs",{"$f":"INDEX($F$1:$G$54,P3,1)","v":{"$error":"#N/A"}}]
[{"$nulls":5},4,{"v":8,"d":"8.0"},null,4,{"v":15,"d":"15.0"}]
[{"$nulls":5},5,9.4,null,5,{"v":15,"d":"15.0"},null,"Slope",{"$f":"IFERROR(((P4-M4)/(P5-M5)),0)","v":0}]
[{"$nulls":5},6,10.7,null,6,17.4,null,"GPM",{"$f":"M4 + M7*(B4-M5)","v":{"$error":"#N/A"}}]
[{"$nulls":5},7,11.8,null,7,19.8]
[{"$nulls":5},8,12.8,null,8,22.2]
[{"$nulls":5},9,13.7,null,9,24.6]
[{"$nulls":5},10,14.6,null,10,{"v":27,"d":"27.0"}]
[{"$nulls":5},11,15.4,null,11,27.8]
[{"$nulls":5},12,{"v":16,"d":"16.0"},null,12,28.6]
[{"$nulls":5},13,16.5,null,13,29.4]
["System Type","Flushometer Valve",{"$nulls":3},14,{"v":17,"d":"17.0"},null,14,30.2]
[null,"WSFU","Demand",null,null,15,17.5,null,15,{"v":31,"d":"31.0"}]
["Domestic Demand",{"$f":"'Page 1'!AE47","v":" "},{"$f":"M26","v":{"$error":"#N/A"}},null,null,16,{"v":18,"d":"18.0"},null,16,31.8]
[{"$nulls":5},17,18.4,null,17,32.6]
[{"$nulls":5},18,18.8,null,18,33.4,null,"Domestic Demand WFSU to GPM (FlushometerValve)"]
[{"$nulls":5},19,19.2,null,19,34.2,null,"Row",{"$f":"MATCH(B18,$I$1:$I$54)","v":{"$error":"#N/A"}},null,"Row",{"$f":"MATCH(B18,$I$1:$I$54)+1","v":{"$error":"#N/A"}}]
[{"$nulls":5},20,19.6,null,20,{"v":35,"d":"35.0"},null,"GPM",{"$f":"INDEX($I$1:$J$54,$M$21,2)","v":{"$error":"#N/A"}},null,"GPM",{"$f":"INDEX($I$1:$J$54,$P$21,2)","v":{"$error":"#N/A"}}]
[{"$nulls":5},25,21.5,null,25,{"v":38,"d":"38.0"},null,"WSFUs",{"$f":"INDEX($I$1:$J$54,$M$21,1)","v":{"$error":"#N/A"}},null,"WSFUs",{"$f":"INDEX($I$1:$J$54,$P$21,1)","v":{"$error":"#N/A"}}]
[{"$nulls":5},30,23.3,null,30,{"v":42,"d":"42.0"}]
["Supply Systems Predominantly",{"$nulls":4},35,24.9,null,35,{"v":44,"d":"44.0"},null,"Slope",{"$f":"IFERROR(((P22-M22)/(P23-M23)),0)","v":0}]
["Input Range",{"$nulls":4},40,26.3,null,40,{"v":46,"d":"46.0"},null,"GPM",{"$f":"M22 + M25*(B18-M23)","v":{"$error":"#N/A"}}]
["Flush Tanks",{"$nulls":4},45,27.7,null,45,{"v":48,"d":"48.0"}]
["Flushometer Valves",{"$nulls":4},50,29.1,null,50,{"v":50,"d":"50.0"}]
["FlushTank/ Flushometer Valve Value",1,{"$nulls":3},60,{"v":32,"d":"32.0"},null,60,{"v":54,"d":"54.0"}]
[{"$nulls":5},70,{"v":35,"d":"35.0"},null,70,{"v":58,"d":"58.0"}]
["Type of Occupancy:",{"$nulls":4},80,{"v":38,"d":"38.0"},null,80,61.2]
["Residential Building",{"$nulls":4},90,{"v":41,"d":"41.0"},null,90,64.3]
["Non-Residential Building",{"$nulls":4},100,43.5,null,100,67.5]
[2,{"$nulls":4},120,{"v":48,"d":"48.0"},null,120,{"v":73,"d":"73.0"}]
[{"$nulls":5},140,52.5,null,140,{"v":77,"d":"77.0"}]
[{"$nulls":5},160,{"v":57,"d":"57.0"},null,160,{"v":81,"d":"81.0"}]
[{"$nulls":5},180,{"v":61,"d":"61.0"},null,180,85.5]
[{"$nulls":5},200,{"v":65,"d":"65.0"},null,200,{"v":90,"d":"90.0"}]
[{"$nulls":5},225,{"v":70,"d":"70.0"},null,225,95.5]
[{"$nulls":5},250,{"v":75,"d":"75.0"},null,250,{"v":101,"d":"101.0"}]
[{"$nulls":5},275,{"v":80,"d":"80.0"},null,275,104.5]
[{"$nulls":5},300,{"v":85,"d":"85.0"},null,300,{"v":108,"d":"108.0"}]
[{"$nulls":5},400,{"v":105,"d":"105.0"},null,400,{"v":127,"d":"127.0"}]
[{"$nulls":5},500,{"v":124,"d":"124.0"},null,500,{"v":143,"d":"143.0"}]
[{"$nulls":5},750,{"v":170,"d":"170.0"},null,750,{"v":177,"d":"177.0"}]
[{"$nulls":5},1000,{"v":208,"d":"208.0"},null,1000,{"v":208,"d":"208.0"}]
[{"$nulls":5},1250,{"v":239,"d":"239.0"},null,1250,{"v":239,"d":"239.0"}]
[{"$nulls":5},1500,{"v":269,"d":"269.0"},null,1500,{"v":269,"d":"269.0"}]
[{"$nulls":5},1750,{"v":297,"d":"297.0"},null,1750,{"v":297,"d":"297.0"}]
[{"$nulls":5},2000,{"v":325,"d":"325.0"},null,2000,{"v":325,"d":"325.0"}]
[{"$nulls":5},2500,{"v":380,"d":"380.0"},null,2500,{"v":380,"d":"380.0"}]
[{"$nulls":5},3000,{"v":433,"d":"433.0"},null,3000,{"v":433,"d":"433.0"}]
[{"$nulls":5},4000,{"v":525,"d":"525.0"},null,4000,{"v":525,"d":"525.0"}]
[{"$nulls":5},5000,{"v":593,"d":"593.0"},null,5000,{"v":593,"d":"593.0"}]

{"sheet":"Page 2","index":3,"n_rows":87,"n_cols":35,"rows_kept":87,"merged":[[1,10,9,21],[1,22,2,28],[1,29,2,36],[3,22,3,28],[3,29,3,36],[4,22,4,28],[4,29,4,36],[5,22,5,28],[5,29,5,36],[6,22,6,28],[6,29,6,36],[14,2,14,14],[14,15,14,16],[14,20,15,20],[14,21,15,31],[14,32,15,33],[14,34,15,35],[15,2,15,14],[15,15,15,16],[16,1,17,1],[16,2,17,14],[16,15,17,16],[16,17,17,18],[16,20,17,20],[16,21,17,31],[16,32,17,35],[18,2,18,14],[18,15,18,16],[18,32,18,33],[18,34,18,35],[19,2,19,14],[19,15,19,16],[19,20,20,31],[19,32,20,33],[19,34,20,35],[20,1,21,1],[20,2,21,14],[20,15,21,16],[20,17,21,18],[21,20,21,31],[21,32,21,33],[21,34,21,35],[22,1,24,1],[22,2,24,14],[22,15,24,16],[22,17,24,18],[25,1,26,1],[25,2,26,14],[25,15,26,18],[26,20,27,35],[27,15,27,16],[27,17,27,18],[28,15,28,16],[28,17,28,18],[28,20,29,31],[28,32,29,33],[28,34,29,35],[30,1,31,14],[30,20,31,31],[32,1,33,14],[32,15,33,18],[32,20,34,31],[32,32,34,35],[34,1,35,14],[34,15,35,18],[39,1,41,36],[42,1,43,36],[44,1,45,36],[46,0,47,37],[48,0,51,6],[48,7,51,13],[48,14,51,20],[48,21,51,27],[48,28,51,32],[48,33,51,37],[72,13,72,15],[73,13,73,15],[85,13,85,15],[86,13,86,15]]}
[]
[{"$nulls":10},"Meter Sizing Worksheet (MSW3)",{"$nulls":11},"Project Address:",{"$nulls":6},{"$f":"IF('Page 1'!AD2=\"\",\"\",'Page 1'!AD2)","v":""}]
[]
[{"$nulls":22},"Square #:",{"$nulls":6},{"$f":"IF('Page 1'!AD4=\"\",\"\",'Page 1'!AD4)","v":""}]
[{"$nulls":22},"Lot #:",{"$nulls":6},{"$f":"IF('Page 1'!AD5=\"\",\"\",'Page 1'!AD5)","v":""}]
[{"$nulls":22},"DC Water Tracking #:",{"$nulls":6},{"$f":"IF('Page 1'!AD6=\"\",\"\",'Page 1'!AD6)","v":""}]
[{"$nulls":22},"DCRA Tracking #:",{"$nulls":6},{"$f":"IF('Page 1'!AD7=\"\",\"\",'Page 1'!AD7)","v":""}]
[]
[{"$nulls":33},"Input Cells"]
[]
[]
[null,"Proposed Meter Type:"]
[]
[null,"Domestic Meter Size",{"$nulls":18},"Fire Demand"]
[null,"a","Total Water Supply Fixture Units (WSFU)",{"$nulls":12},{"$f":"'Page 1'!AE47","v":" "},null,"wsfu",null,null,"l","Total Fire Demand (Per NFPA requirements)",{"$nulls":12},"gpm"]
[null,"b","Domestic Demand 1",{"$nulls":12},{"$f":"'Page 1'!AE48","v":" "},null,"gpm"]
[null,"c","Total Hose Bibs and/ or Lawn Sprinkler Demand",{"$nulls":14},"gpm",null,null,"m","Fire Pump Proposed?"]
[]
[null,"d","Total Continuous Mechanical Demand",{"$nulls":14},"gpm",null,null,"n","Fire Pump Flow Rating",{"$nulls":12},"gpm"]
[null,"e","Total Intermittent Mechanical Demand",{"$nulls":14},"gpm",null,null,"Pump Test Demand (150% of Fire Pump Flow Rating)",{"$nulls":11},{"$f":"1.5*AG19","v":0},null,"gpm"]
[null,"f","Total Continuous Demand (Hose Bibs and/ or Lawn Sprinkler + Continuous Mechanical)",{"$nulls":12},{"$f":"IF((P17+P19)=\"\",\"\", P17+P19)","v":0},null,"gpm"]
[{"$nulls":20},"Maximum Fire Demand",{"$nulls":11},{"$f":"MAX(AG20,AG15)","v":0},null,"gpm"]
[null,"g","Total DIM (Domestic + Irrigation + Mechanical (cont.) + Mechanical (inter.)) Demand  ",{"$nulls":12},{"$f":"SUM(P16:Q20)","v":0},null,"gpm"]
[]
[]
[null,"i","Domestic Booster Pump Proposed?"]
[{"$nulls":20},"Below Section is only Applicable to Meter for Combined Domestic and Fire Services"]
[null,"j","Pump Maximum Demand",{"$nulls":12},0,null,"gpm"]
[null,"k","Maximum DIM* Demand",{"$nulls":12},{"$f":"MAX(P23,P28)","v":0},null,"gpm",null,null,"Maximum Combined Demand",{"$nulls":11},{"$f":"IF(G58=1,\"NA\", P29+AG22)","v":"NA"},null,"gpm"]
[]
[null,"Select System Availability Fee (SAF) Meter Size/ Domestic Meter Size 2",{"$nulls":18},"Select Combined Meter Size 3"]
[]
[null,"Is Maximum DIM* Demand is less than or equal to Allowable Maximum Flow Rate through Meter?",{"$nulls":13},{"$f":"IF(G69=1,\"NA\",IF(P29<=N73,\"YES\",\"NO\"))","v":"NA"},{"$nulls":4},"Is Maximum Combined Demand is less than or equal to Allowable Maximum Flow Rate through Meter?",{"$nulls":11},{"$f":"IF(G58=1,\"NA\",IF(G84=1,\"NA\",IF(AG29<=N86,\"YES\",\"NO\")))","v":"NA"}]
[]
[null,"Is Total Continuous Demand is less than or equal to Allowable High-Normal Flow Rate through Meter?",{"$nulls":13},{"$f":"IF(G69=1,\"NA\",IF(P21<=N74,\"YES\",\"NO\"))","v":"NA"}]
[]
[]
[]
[null,"DIM*- Domestic Irrigation Mechanical"]
[null,"1 The domestic demand should be computed by using total Water Supply Fixture Units.  The domestic demand value should be based on District of Columbia adopted current version of the International Plumbing Code (IPC) or International Residential Code (IRC) as applicable to the project.  IPC or IRC has  tables to determine demands based on type of supply systems (predominately used flush tanks or flushometers). "]
[]
[]
[null,"2 The System Availability Fee (SAF) meter size shall be computed for the peak water demand excluding fire demand.  The domestic meter size will be same as SAF meter size for the separate domestic service meter.  Use DC Water 'Table C- AWWA meter standards' to determine size of the meter"]
[]
[null,"3 Combined meter size (domestic + fire) may be different from SAF meter size and will be determined based on combined flow demand.  Use DC Water 'Table C- AWWA meter standards' to determine size of the meter."]
[]
["By signing this document, the designer is responsible for determining required domestic, irrigation, mechanical, and fire flows in addition to the proper sizing of meters. By submitting this application, I affirm that the information provided is correct."]
[]
["Designer’s Name:",{"$nulls":13},"Designer’s Signature:",{"$nulls":13},"DC License #:"]
[]
[]
[]
[]
[]
[null,null,"Separate or Combined meter?"]
[null,null,"Input Range",{"$nulls":3},"Separate Domestic and Fire Services"]
[{"$nulls":6},"Combined Domestic and Fire Services"]
[null,null,"Cell Link",{"$nulls":3},1]
[]
[]
[]
[null,null,"SAF Meter ",{"$nulls":7},"Domestic Pump?",{"$nulls":8},"Fire Pump?"]
[null,null,"Input Range",{"$nulls":3},"NA",{"$nulls":3},"Input Range",{"$nulls":3},"YES",{"$nulls":4},"Input Range",{"$nulls":3},"YES"]
[{"$nulls":6},"2\"",{"$nulls":7},"NO",{"$nulls":8},"NO"]
[{"$nulls":6},"3\"",{"$nulls":3},"Cell Link",{"$nulls":3},1,{"$nulls":4},"Cell Link",{"$nulls":3},1]
[{"$nulls":6},"4\""]
[{"$nulls":6},"6\""]
[{"$nulls":6},"8\""]
[null,null,"Cell Link",{"$nulls":3},1]
[]
[]
[]
[null,null,"Allowable Maximum Flow Rate, gpm",{"$nulls":10},{"$f":"INDEX('Page 3'!AF35:AF44,(G69-1),1)","v":{"$error":"#VALUE!"}}]
[null,null,"Allowable High-Normal Flow Rate, gpm",{"$nulls":10},{"$f":"INDEX('Page 3'!AC35:AC39,(G69-1),1)","v":{"$error":"#VALUE!"}}]
[]
[]
[null,null,"Combined Meter "]
[null,null,"Input Range",{"$nulls":3},"NA"]
[{"$nulls":6},{"$f":"IF($G$58=1,\"NA\",\"3\"\" FS\")","v":"NA"}]
[{"$nulls":6},{"$f":"IF($G$58=1,\"NA\",\"4\"\" FS\")","v":"NA"}]
[{"$nulls":6},{"$f":"IF($G$58=1,\"NA\",\"6\"\"FS\")","v":"NA"}]
[{"$nulls":6},{"$f":"IF($G$58=1,\"NA\",\"8\"\"FS\")","v":"NA"}]
[{"$nulls":6},{"$f":"IF($G$58=1,\"NA\",\"10\"\"FS\")","v":"NA"}]
[null,null,"Cell Link",{"$nulls":3},1]
[]
[null,null,"Allowable Maximum Flow Rate, gpm",{"$nulls":10},{"$f":"INDEX('Page 3'!AF40:AF44,(G84-1),1)","v":{"$error":"#VALUE!"}}]
[null,null,"Allowable High-Normal Flow Rate, gpm",{"$nulls":10},{"$f":"INDEX('Page 3'!AC40:AC44,(G84-1),1)","v":{"$error":"#VALUE!"}}]

{"sheet":"Page 3","index":4,"n_rows":47,"n_cols":35,"rows_kept":47,"merged":[[1,10,9,21],[1,22,2,28],[1,29,2,36],[3,22,3,28],[3,29,3,36],[4,22,4,28],[4,29,4,36],[5,22,5,28],[5,29,5,36],[6,22,6,28],[6,29,6,36],[8,30,8,31],[10,11,10,19],[10,25,10,27],[10,32,10,34],[11,1,12,16],[11,18,11,35],[12,31,12,35],[13,11,13,12],[13,15,13,16],[13,31,13,35],[14,11,14,12],[14,13,14,14],[14,15,14,16],[14,31,14,35],[15,11,15,12],[15,13,15,14],[15,15,15,16],[16,11,16,12],[16,13,16,14],[16,15,16,16],[16,18,16,35],[17,11,17,12],[17,13,17,14],[17,15,17,16],[17,34,17,35],[18,11,18,12],[18,13,18,14],[18,15,18,16],[18,18,19,18],[18,19,19,28],[18,30,19,31],[18,32,19,33],[18,34,19,35],[19,11,19,12],[19,13,19,14],[19,15,19,16],[20,11,20,12],[20,13,20,14],[20,15,20,16],[20,30,20,31],[20,32,20,33],[20,34,20,35],[21,11,21,12],[21,13,21,14],[21,15,21,16],[21,30,21,31],[21,32,21,33],[21,34,21,35],[22,30,22,31],[22,32,22,33],[22,34,22,35],[23,30,23,31],[23,32,23,33],[23,34,23,35],[24,30,24,31],[24,32,24,33],[24,34,24,35],[25,1,25,16],[25,30,25,31],[25,32,25,33],[25,34,25,35],[26,15,26,16],[26,30,26,31],[26,32,26,33],[26,34,26,35],[27,11,27,12],[27,13,27,14],[27,15,27,16],[27,18,28,18],[27,19,28,28],[27,30,28,31],[27,32,28,33],[27,34,28,35],[28,11,28,12],[28,13,28,14],[28,15,28,16],[29,11,29,12],[29,13,29,14],[29,15,29,16],[30,18,30,33],[31,18,33,27],[31,28,33,30],[31,31,33,33],[34,28,34,30],[34,31,34,33],[35,28,35,30],[35,31,35,33],[36,28,36,30],[36,31,36,33],[37,28,37,30],[37,31,37,33],[38,28,38,30],[38,31,38,33],[39,28,39,30],[39,31,39,33],[40,28,40,30],[40,31,40,33],[41,28,41,30],[41,31,41,33],[42,28,42,30],[42,31,42,33],[43,28,43,30],[43,31,43,33]]}
[]
[{"$nulls":10},"Pipe Losses Computation Worksheet (MSW3)",{"$nulls":11},"Project Address:",{"$nulls":6},{"$f":"IF('Page 1'!AD2=\"\",\"\",'Page 1'!AD2)","v":""}]
[]
[{"$nulls":22},"Square #:",{"$nulls":6},{"$f":"IF('Page 1'!AD4=\"\",\"\",'Page 1'!AD4)","v":""}]
[{"$nulls":22},"Lot #:",{"$nulls":6},{"$f":"IF('Page 1'!AD5=\"\",\"\",'Page 1'!AD5)","v":""}]
[{"$nulls":22},"DC Water Tracking #:",{"$nulls":6},{"$f":"IF('Page 1'!AD6=\"\",\"\",'Page 1'!AD6)","v":""}]
[{"$nulls":22},"DCRA Tracking #:",{"$nulls":6},{"$f":"IF('Page 1'!AD7=\"\",\"\",'Page 1'!AD7)","v":""}]
[]
[{"$nulls":33},"Input Cells"]
[]
[]
[null,"Table A- Total Pipe Losses (Main to the Bldg.)",{"$nulls":16},"Hydrant Flow Test Results"]
[{"$nulls":18},"Date of Test:"]
[{"$nulls":11},"Dom.",null,"Fire",null,"Comb.",null,null,"Static Pressure, psi"]
[null,"a","Pipe Length (Main to Bldg.), ft",{"$nulls":15},"Residual Pressure, psi"]
[null,"b","Maximum Demand, gpm",{"$nulls":8},{"$f":"'Page 2'!P29","v":0},null,{"$f":"'Page 2'!AG22","v":0},null,{"$f":"'Page 2'!AG29","v":"NA"}]
[null,"c","Pipe Size, inch",{"$nulls":15},"Available Pressure at the Highest Fixture"]
[null,"d","C Value",{"$nulls":27},"Dom.",null,"Fire",null,"Comb."]
[null,"e","Pipe Friction Losses, psi",{"$nulls":8},{"$f":"IFERROR(4.52*L15*((L16/L18)^1.85)*(1/L17^4.87),\" \")","v":" "},null,{"$f":"IFERROR(4.52*N15*((N16/N18)^1.85)*(1/N17^4.87),\" \")","v":" "},null,{"$f":"IFERROR(4.52*P15*((P16/P18)^1.85)*(1/P17^4.87),\" \")","v":" "},null,null,"l","Design Pressure at the Main, psi"]
[null,"f","Other Pipe Losses (if any), psi"]
[null,"g","Total Pipe Losses (Main to Bldg.), psi",{"$nulls":8},{"$f":"IFERROR(SUM(L19+L20), \" \")","v":" "},null,{"$f":"IFERROR(N19+N20,\" \")","v":" "},null,{"$f":"IFERROR(P19+P20,\" \")","v":" "},null,null,"m","Total Pipe Losses, psi (See Table A)",{"$nulls":9},"-",{"$f":"L21","v":" "},null,{"$f":"N21","v":" "},null,{"$f":"P21","v":" "}]
[null,"h","V (fps) 1",{"$nulls":8},{"$f":"IFERROR((L16/(7.48*60))   /   (PI()* (L17/24)^2),\" \")","v":" "},null,{"$f":"IFERROR((N16/(7.48*60))   /   (PI()* (N17/24)^2),\" \")","v":" "},null,{"$f":"IFERROR((P16/(7.48*60))   /   (PI()* (P17/24)^2),\" \")","v":" "},null,null,"n"," Meter Loss2, psi",{"$nulls":9},"-"]
[{"$nulls":18},"o","Static Head Loss, psi (See Table B)",{"$nulls":9},"-",{"$f":"L30","v":{"v":0,"d":"0.0"}},null,{"$f":"N30","v":{"v":0,"d":"0.0"}},null,{"$f":"P30","v":{"v":0,"d":"0.0"}}]
[{"$nulls":18},"p","Backflow Prevention Assembly Loss, psi",{"$nulls":9},"-"]
[{"$nulls":18},"q","Pipe Losses inside the Building3, psi",{"$nulls":9},"-"]
[null,"Table B- Static Head Loss (Main to Highest Fixture)",{"$nulls":16},"r","Special Fixture Loss- Other (if any), psi",{"$nulls":9},"-"]
[{"$nulls":11},"Dom.",null,"Fire",null,"Comb.",null,null,"s","Pressure Gain due to the pump, psi",{"$nulls":9},"+"]
[null,"i","Supply Main Elevation, ft",{"$nulls":15},"t","Maximum Pressure Available at the Highest Fixture, psi",{"$nulls":9},"=",{"$f":"AE19-SUM(AE21:AE26)+AE27","v":{"v":0,"d":"0.0"}},null,{"$f":"AG19-SUM(AG21:AG26)+AG27","v":{"v":0,"d":"0.0"}},null,{"$f":"AI19-SUM(AI21:AI26)+AI27","v":{"v":0,"d":"0.0"}}]
[null,"j","Highest Fixture Elevation, ft"]
[null,"k","Static Head Loss, psi",{"$nulls":8},{"$f":"(L29-L28)/2.31","v":{"v":0,"d":"0.0"}},null,{"$f":"(N29-N28)/2.31","v":{"v":0,"d":"0.0"}},null,{"$f":"(P29-P28)/2.31","v":{"v":0,"d":"0.0"}}]
[{"$nulls":18},"*Table C - AWWA Water Meter Standards"]
[{"$nulls":18},"Meter Size",{"$nulls":9},"High-Normal Flow Rate, gpm",null,null,"Maximum Flow Rate, gpm"]
[]
[]
[{"$nulls":18},"2\" (PD)",{"$nulls":9},80,null,null,160]
[{"$nulls":18},"3\" (Compound Class II)",{"$nulls":9},175,null,null,350]
[{"$nulls":18},"4\" (Compound Class II)",{"$nulls":9},300,null,null,600]
[{"$nulls":18},"6\" (Compound Class II)",{"$nulls":9},675,null,null,1350]
[{"$nulls":18},"8\" (Compound Class II)",{"$nulls":9},900,null,null,1600]
[{"$nulls":18},"3\" (FS)",{"$nulls":9},250,null,null,350]
[{"$nulls":18},"4\" (FS)",{"$nulls":9},400,null,null,700]
[{"$nulls":18},"6\" (FS)",{"$nulls":9},900,null,null,1600]
[{"$nulls":18},"8\" (FS)",{"$nulls":9},1600,null,null,2800]
[{"$nulls":18},"10\" (FS)",{"$nulls":9},2200,null,null,4400]
[{"$nulls":18},"Source: AWWA, M22, 3rd Ed."]
[{"$nulls":18},"PD - Positive Displacement"]
[{"$nulls":18},"FS - Fire Service, type II-Compound"]

{"sheet":"Page 4","index":5,"n_rows":13,"n_cols":30,"rows_kept":13,"merged":[[1,10,9,21],[1,22,2,28],[1,29,2,36],[3,22,3,28],[3,29,3,36],[4,22,4,28],[4,29,4,36],[5,22,5,28],[5,29,5,36],[6,22,6,28],[6,29,6,36],[11,13,11,15],[12,13,12,15],[12,17,12,19]]}
[]
[{"$nulls":10},"Domestic Demand vs Total WSFU* Chart",{"$nulls":11},"Project Address:",{"$nulls":6},{"$f":"IF('Page 1'!AD2=\"\",\"\",'Page 1'!AD2)","v":""}]
[]
[{"$nulls":22},"Square #:",{"$nulls":6},{"$f":"IF('Page 1'!AD4=\"\",\"\",'Page 1'!AD4)","v":""}]
[{"$nulls":22},"Lot #:",{"$nulls":6},{"$f":"IF('Page 1'!AD5=\"\",\"\",'Page 1'!AD5)","v":""}]
[{"$nulls":22},"DC Water Tracking#:",{"$nulls":6},{"$f":"IF('Page 1'!AD6=\"\",\"\",'Page 1'!AD6)","v":""}]
[{"$nulls":22},"DCRA Tracking #:",{"$nulls":6},{"$f":"IF('Page 1'!AD7=\"\",\"\",'Page 1'!AD7)","v":""}]
[]
[]
[]
[]
[{"$nulls":3},"Total WSFUs:",{"$nulls":9},{"$f":"'Page 1'!AE47","v":" "},{"$nulls":3},"Predominate Supply Systems:",{"$nulls":10},{"$f":"IF('Conversion Sheet A'!B29=1,\"Flush Tanks\",\"Flushometer Valves\")","v":"Flush Tanks"}]
[{"$nulls":3},"Domestic Demand, gpm",{"$nulls":9},{"$f":"'Page 1'!AE48","v":" "}]

{"sheet":"Page 5","index":6,"n_rows":1,"n_cols":1,"rows_kept":1,"merged":[[0,0,4,8],[5,0,5,8],[18,0,18,8]]}
["DEFINITIONS (MSW1)"]

{"sheet":"Page 6","index":7,"n_rows":60,"n_cols":7,"rows_kept":60,"merged":[[0,0,4,7],[6,2,7,2]]}
["Pressure Loss Through Water Meters, PSI \nFor Reference Only (Source: AWWA, M22, 3rd Ed.)"]
[]
[]
[]
[]
[]
[null,null,"Flow, \nGPM","Nominal Meter Size, in."]
[{"$nulls":3},2,3,4,6]
[null,null,30,{"v":0.5277033671289547,"d":"0.5"}]
[null,null,32,{"v":0.6004091643778329,"d":"0.6"}]
[null,null,34,{"v":0.6778056582234128,"d":"0.7"}]
[null,null,36,{"v":0.7598928486656946,"d":"0.8"}]
[null,null,38,{"v":0.8466707357046783,"d":"0.8"}]
[null,null,40,{"v":0.9381393193403639,"d":"0.9"}]
[null,null,42,{"v":1.034298599572751,"d":"1.0"}]
[null,null,44,{"v":1.13514857640184,"d":"1.1"}]
[null,null,46,{"v":1.2406892498276312,"d":"1.2"}]
[null,null,48,{"v":1.3509206198501238,"d":"1.4"}]
[null,null,50,{"v":1.4658426864693184,"d":"1.5"}]
[null,null,52,{"v":1.5854554496852147,"d":"1.6"}]
[null,null,54,{"v":1.7097589094978132,"d":"1.7"}]
[null,null,56,{"v":1.838753065907113,"d":"1.8"}]
[null,null,58,{"v":1.9724379189131147,"d":"2.0"}]
[null,null,60,{"v":2.110813468515819,"d":"2.1"}]
[null,null,65,{"v":2.4772741401331477,"d":"2.5"},{"v":0.5188163006555812,"d":"0.5"}]
[null,null,70,{"v":2.873051665479864,"d":"2.9"},{"v":0.6017041120029225,"d":"0.6"}]
[null,null,75,{"v":3.2981460445559665,"d":"3.3"},{"v":0.6907317612278449,"d":"0.7"}]
[null,null,80,{"v":3.7525572773614555,"d":"3.8"},{"v":0.7858992483303479,"d":"0.8"}]
[null,null,85,{"v":4.2362853638963305,"d":"4.2"},{"v":0.8872065733104317,"d":"0.9"}]
[null,null,90,{"v":4.7493303041605905,"d":"4.7"},{"v":0.9946537361680964,"d":"1.0"}]
[null,null,95,{"v":5.291692098154239,"d":"5.3"},{"v":1.108240736903342,"d":"1.1"}]
[null,null,100,{"v":5.8633707458772735,"d":"5.9"},{"v":1.2279675755161683,"d":"1.2"}]
[null,null,110,{"v":7.094678602511501,"d":"7.1"},{"v":1.485840766374564,"d":"1.5"},{"v":0.4594445480542086,"d":"0.5"}]
[null,null,120,{"v":8.443253874063275,"d":"8.4"},{"v":1.7682733087432827,"d":"1.8"},{"v":0.5467769828083143,"d":"0.5"}]
[null,null,130,{"v":9.909096560532591,"d":"9.9"},{"v":2.0752652026223246,"d":"2.1"},{"v":0.6417035423236468,"d":"0.6"}]
[null,null,140,{"v":11.492206661919456,"d":"11.5"},{"v":2.40681644801169,"d":"2.4"},{"v":0.7442242266002056,"d":"0.7"}]
[null,null,150,{"v":13.192584178223866,"d":"13.2"},{"v":2.7629270449113794,"d":"2.8"},{"v":0.8543390356379913,"d":"0.9"}]
[null,null,160,{"v":15.010229109445822,"d":"15.0"},{"v":3.1435969933213914,"d":"3.1"},{"v":0.9720479694370034,"d":"1.0"}]
[null,null,170,null,{"v":3.548826293241727,"d":"3.5"},{"v":1.097351027997242,"d":"1.1"}]
[null,null,180,null,{"v":3.9786149446723855,"d":"4.0"},{"v":1.2302482113187074,"d":"1.2"}]
[null,null,190,null,{"v":4.432962947613368,"d":"4.4"},{"v":1.3707395194013994,"d":"1.4"}]
[null,null,200,null,{"v":4.911870302064673,"d":"4.9"},{"v":1.5188249522453177,"d":"1.5"}]
[null,null,220,null,{"v":5.943363065498256,"d":"5.9"},{"v":1.8377781922168344,"d":"1.8"}]
[null,null,240,null,{"v":7.073093234973131,"d":"7.1"},{"v":2.1871079312332573,"d":"2.2"},{"v":0.5123973792381102,"d":"0.5"}]
[null,null,260,null,{"v":8.301060810489298,"d":"8.3"},{"v":2.566814169294587,"d":"2.6"},{"v":0.6013552575780601,"d":"0.6"}]
[null,null,280,null,{"v":9.62726579204676,"d":"9.6"},{"v":2.9768969064008224,"d":"3.0"},{"v":0.6974297661852057,"d":"0.7"}]
[null,null,300,null,{"v":11.051708179645518,"d":"11.1"},{"v":3.417356142551965,"d":"3.4"},{"v":0.8006209050595472,"d":"0.8"}]
[null,null,350,null,{"v":15.042602800073064,"d":"15.0"},{"v":4.651401416251286,"d":"4.7"},{"v":1.089734009664384,"d":"1.1"}]
[null,null,400,null,null,{"v":6.075299808981271,"d":"6.1"},{"v":1.4233260534391954,"d":"1.4"}]
[null,null,450,null,null,{"v":7.689051320741921,"d":"7.7"},{"v":1.8013970363839813,"d":"1.8"}]
[null,null,500,null,null,{"v":9.492655951533237,"d":"9.5"},{"v":2.223946958498743,"d":"2.2"}]
[null,null,600,null,null,{"v":13.66942457020786,"d":"13.7"},{"v":3.2024836202381888,"d":"3.2"}]
[null,null,650,null,null,{"v":16.04258855809117,"d":"16.0"},{"v":3.7584703598628755,"d":"3.8"}]
[null,null,700,{"$nulls":3},{"v":4.358936038657536,"d":"4.4"}]
[null,null,800,{"$nulls":3},{"v":5.6933042137567815,"d":"5.7"}]
[null,null,900,{"$nulls":3},{"v":7.205588145535925,"d":"7.2"}]
[null,null,1000,{"$nulls":3},{"v":8.895787833994971,"d":"8.9"}]
[null,null,1100,{"$nulls":3},{"v":10.763903279133913,"d":"10.8"}]
[null,null,1200,{"$nulls":3},{"v":12.809934480952755,"d":"12.8"}]
[null,null,1300,{"$nulls":3},{"v":15.033881439451502,"d":"15.0"}]

{"sheet":"Page 7","index":8,"n_rows":64,"n_cols":7,"rows_kept":64,"merged":[[0,0,4,7],[6,2,7,2],[6,3,6,6]]}
["Pressure Loss Through BPA* (DCV), PSI \nFor Reference Only (Source: AWWA, M22, 3rd Ed.)"]
[]
[]
[]
[]
[]
[null,null,"Flow, \nGPM","Nominal Size, in."]
[{"$nulls":3},3,4,6,8]
[null,null,50]
[null,null,52]
[null,null,54,{"v":4.170899596487064,"d":"4.2"}]
[null,null,56,{"v":4.1837932560299835,"d":"4.2"},{"v":4.07476857346309,"d":"4.1"}]
[null,null,58,{"v":4.197155775919919,"d":"4.2"},{"v":4.080204553931708,"d":"4.1"}]
[null,null,60,{"v":4.210987156156869,"d":"4.2"},{"v":4.085831270557119,"d":"4.1"}]
[null,null,65,{"v":4.247616870767437,"d":"4.2"},{"v":4.100732532806619,"d":"4.1"}]
[null,null,70,{"v":4.287176962546849,"d":"4.3"},{"v":4.116825896036079,"d":"4.1"},{"v":4.0294869202615065,"d":"4.0"}]
[null,null,75,{"v":4.329667431495108,"d":"4.3"},{"v":4.134111360245498,"d":"4.1"},{"v":4.033849780912444,"d":"4.0"}]
[null,null,80,{"v":4.375088277612211,"d":"4.4"},{"v":4.152588925434879,"d":"4.2"},{"v":4.038513528504826,"d":"4.0"}]
[null,null,85,{"v":4.42343950089816,"d":"4.4"},{"v":4.172258591604218,"d":"4.2"},{"v":4.0434781630386505,"d":"4.0"}]
[null,null,90,{"v":4.474721101352955,"d":"4.5"},{"v":4.193120358753518,"d":"4.2"},{"v":4.048743684513919,"d":"4.0"}]
[null,null,95,{"v":4.528933078976595,"d":"4.5"},{"v":4.215174226882778,"d":"4.2"},{"v":4.054310092930632,"d":"4.1"},{"v":4.021168760746569,"d":"4.0"}]
[null,null,100,{"v":4.58607543376908,"d":"4.6"},{"v":4.238420195991997,"d":"4.2"},{"v":4.06017738828879,"d":"4.1"},{"v":4.023455690577917,"d":"4.0"}]
[null,null,110,{"v":4.709151274860587,"d":"4.7"},{"v":4.288488437150317,"d":"4.3"},{"v":4.072814639829435,"d":"4.1"},{"v":4.028381385599279,"d":"4.0"}]
[null,null,120,{"v":4.843948624627476,"d":"4.8"},{"v":4.343325082228477,"d":"4.3"},{"v":4.086655439135857,"d":"4.1"},{"v":4.0337761944322,"d":"4.0"}]
[null,null,130,{"v":4.990467483069746,"d":"5.0"},{"v":4.4029301312264755,"d":"4.4"},{"v":4.101699786208054,"d":"4.1"},{"v":4.0396401170766785,"d":"4.0"}]
[null,null,140,{"v":5.148707850187398,"d":"5.1"},{"v":4.467303584144315,"d":"4.5"},{"v":4.117947681046028,"d":"4.1"},{"v":4.045973153532716,"d":"4.0"}]
[null,null,150,{"v":5.318669725980431,"d":"5.3"},{"v":4.5364454409819945,"d":"4.5"},{"v":4.135399123649776,"d":"4.1"},{"v":4.052775303800312,"d":"4.1"}]
[null,null,160,{"v":5.500353110448846,"d":"5.5"},{"v":4.610355701739514,"d":"4.6"},{"v":4.154054114019301,"d":"4.2"},{"v":4.060046567879466,"d":"4.1"}]
[null,null,170,{"v":5.6937580035926425,"d":"5.7"},{"v":4.689034366416873,"d":"4.7"},{"v":4.173912652154602,"d":"4.2"},{"v":4.0677869457701785,"d":"4.1"}]
[null,null,180,{"v":5.89888440541182,"d":"5.9"},{"v":4.772481435014072,"d":"4.8"},{"v":4.194974738055678,"d":"4.2"},{"v":4.075996437472449,"d":"4.1"}]
[null,null,190,{"v":6.11573231590638,"d":"6.1"},{"v":4.8606969075311115,"d":"4.9"},{"v":4.21724037172253,"d":"4.2"},{"v":4.084675042986278,"d":"4.1"}]
[null,null,200,{"v":6.344301735076321,"d":"6.3"},{"v":4.95368078396799,"d":"5.0"},{"v":4.240709553155158,"d":"4.2"},{"v":4.093822762311666,"d":"4.1"}]
[null,null,220,{"v":6.836605099442349,"d":"6.8"},{"v":5.1539537486012685,"d":"5.2"},{"v":4.2912585593177415,"d":"4.3"},{"v":4.113525542397116,"d":"4.1"}]
[null,null,240,{"v":7.375794498509903,"d":"7.4"},{"v":5.373300328913906,"d":"5.4"},{"v":4.346621756543428,"d":"4.3"},{"v":4.135104777728799,"d":"4.1"}]
[null,null,260,{"v":7.961869932278983,"d":"8.0"},{"v":5.611720524905904,"d":"5.6"},{"v":4.406799144832217,"d":"4.4"},{"v":4.158560468306715,"d":"4.2"}]
[null,null,280,{"v":8.594831400749591,"d":"8.6"},{"v":5.869214336577261,"d":"5.9"},{"v":4.4717907241841095,"d":"4.5"},{"v":4.1838926141308646,"d":"4.2"}]
[null,null,300,{"v":9.274678903921723,"d":"9.3"},{"v":6.145781763927978,"d":"6.1"},{"v":4.541596494599106,"d":"4.5"},{"v":4.211101215201248,"d":"4.2"}]
[null,null,350,{"v":11.179424063671235,"d":"11.2"},{"v":6.92064740090197,"d":"6.9"},{"v":4.737173006537671,"d":"4.7"},{"v":4.287332209579477,"d":"4.3"}]
[null,null,400,null,{"v":7.814723135871961,"d":"7.8"},{"v":4.962838212620632,"d":"5.0"},{"v":4.375291049246663,"d":"4.4"}]
[null,null,450,null,{"v":8.82800896883795,"d":"8.8"},{"v":5.218592112847988,"d":"5.2"},{"v":4.474977734202808,"d":"4.5"}]
[null,null,500,null,{"v":9.96050489979994,"d":"10.0"},{"v":5.504434707219738,"d":"5.5"},{"v":4.586392264447911,"d":"4.6"}]
[null,null,600,null,null,{"v":6.166385978396422,"d":"6.2"},{"v":4.844404860804992,"d":"4.8"}]
[null,null,650,null,null,{"v":6.542494655201357,"d":"6.5"},{"v":4.991002926916969,"d":"5.0"}]
[null,null,700,null,null,{"v":6.948692026150686,"d":"6.9"},{"v":5.1493288383179046,"d":"5.1"}]
[null,null,800,null,null,{"v":7.851352850482528,"d":"7.9"},{"v":5.501164196986651,"d":"5.5"}]
[null,null,900,null,null,{"v":8.87436845139195,"d":"8.9"},{"v":5.899910936811231,"d":"5.9"}]
[null,null,1000,null,null,{"v":10.01773882887895,"d":"10.0"},{"v":6.345569057791643,"d":"6.3"}]
[null,null,1100,{"$nulls":3},{"v":6.838138559927888,"d":"6.8"}]
[null,null,1200,{"$nulls":3},{"v":7.377619443219965,"d":"7.4"}]
[null,null,1300,{"$nulls":3},{"v":7.964011707667876,"d":"8.0"}]
[null,null,1400,{"$nulls":3},{"v":8.597315353271618,"d":"8.6"}]
[null,null,1500,{"$nulls":3},{"v":9.277530380031195,"d":"9.3"}]
[null,null,1600,{"$nulls":3},{"v":10.004656787946605,"d":"10.0"}]
{"$rows_empty":10}
["*BPA- Backflow Prevention Assemblies"]

{"sheet":"Page 8","index":9,"n_rows":64,"n_cols":7,"rows_kept":64,"merged":[[0,0,4,7],[6,2,7,2],[6,3,6,6]]}
["Pressure Loss Through BPA* (RPZ), PSI \nFor Reference Only (Source: AWWA, M22, 3rd Ed.)"]
[]
[]
[]
[]
[]
[null,null,"Flow, \nGPM","Nominal Size, in."]
[{"$nulls":3},3,4,6,8]
[null,null,50,{"v":10.122099048701891,"d":"10.1"},{"v":10.039736699332,"d":"10.0"},{"v":10.010029564714799,"d":"10.0"}]
[null,null,52,{"v":10.132062331075966,"d":"10.1"},{"v":10.04297921399749,"d":"10.0"},{"v":10.010847977195526,"d":"10.0"}]
[null,null,54,{"v":10.142416330405887,"d":"10.1"},{"v":10.046348886100844,"d":"10.0"},{"v":10.011698484283341,"d":"10.0"}]
[null,null,56,{"v":10.153161046691652,"d":"10.2"},{"v":10.04984571564206,"d":"10.0"},{"v":10.012581085978242,"d":"10.0"}]
[null,null,58,{"v":10.164296479933265,"d":"10.2"},{"v":10.053469702621138,"d":"10.1"},{"v":10.013495782280232,"d":"10.0"}]
[null,null,60,{"v":10.175822630130725,"d":"10.2"},{"v":10.05722084703808,"d":"10.1"},{"v":10.01444257318931,"d":"10.0"}]
[null,null,65,{"v":10.206347392306197,"d":"10.2"},{"v":10.067155021871079,"d":"10.1"},{"v":10.01694996436801,"d":"10.0"}]
[null,null,70,{"v":10.239314135455707,"d":"10.2"},{"v":10.077883930690719,"d":"10.1"},{"v":10.019657946841004,"d":"10.0"}]
[null,null,75,{"v":10.274722859579256,"d":"10.3"},{"v":10.089407573496999,"d":"10.1"},{"v":10.022566520608295,"d":"10.0"}]
[null,null,80,{"v":10.312573564676843,"d":"10.3"},{"v":10.10172595028992,"d":"10.1"},{"v":10.025675685669883,"d":"10.0"}]
[null,null,85,{"v":10.352866250748468,"d":"10.4"},{"v":10.114839061069478,"d":"10.1"},{"v":10.028985442025768,"d":"10.0"}]
[null,null,90,{"v":10.395600917794129,"d":"10.4"},{"v":10.128746905835678,"d":"10.1"},{"v":10.032495789675947,"d":"10.0"}]
[null,null,95,{"v":10.440777565813828,"d":"10.4"},{"v":10.143449484588519,"d":"10.1"},{"v":10.03620672862042,"d":"10.0"},{"v":10.014195521912406,"d":"10.0"}]
[null,null,100,{"v":10.488396194807567,"d":"10.5"},{"v":10.158946797327998,"d":"10.2"},{"v":10.040118258859193,"d":"10.0"},{"v":10.01572911015225,"d":"10.0"}]
[null,null,110,{"v":10.590959395717157,"d":"10.6"},{"v":10.192325624766879,"d":"10.2"},{"v":10.048543093219623,"d":"10.0"},{"v":10.019032223284222,"d":"10.0"}]
[null,null,120,{"v":10.703290520522897,"d":"10.7"},{"v":10.228883388152317,"d":"10.2"},{"v":10.057770292757239,"d":"10.1"},{"v":10.02264991861924,"d":"10.0"}]
[null,null,130,{"v":10.825389569224788,"d":"10.8"},{"v":10.268620087484317,"d":"10.3"},{"v":10.067799857472036,"d":"10.1"},{"v":10.026582196157301,"d":"10.0"}]
[null,null,140,{"v":10.957256541822831,"d":"11.0"},{"v":10.311535722762876,"d":"10.3"},{"v":10.078631787364019,"d":"10.1"},{"v":10.03082905589841,"d":"10.0"}]
[null,null,150,{"v":11.098891438317025,"d":"11.1"},{"v":10.357630293987997,"d":"10.4"},{"v":10.090266082433184,"d":"10.1"},{"v":10.035390497842561,"d":"10.0"}]
[null,null,160,{"v":11.250294258707372,"d":"11.3"},{"v":10.406903801159675,"d":"10.4"},{"v":10.102702742679535,"d":"10.1"},{"v":10.040266521989759,"d":"10.0"}]
[null,null,170,{"v":11.411465002993868,"d":"11.4"},{"v":10.459356244277915,"d":"10.5"},{"v":10.115941768103069,"d":"10.1"},{"v":10.045457128340002,"d":"10.0"}]
[null,null,180,{"v":11.582403671176516,"d":"11.6"},{"v":10.514987623342714,"d":"10.5"},{"v":10.129983158703785,"d":"10.1"},{"v":10.050962316893289,"d":"10.1"}]
[null,null,190,{"v":11.763110263255317,"d":"11.8"},{"v":10.573797938354074,"d":"10.6"},{"v":10.144826914481687,"d":"10.1"},{"v":10.056782087649623,"d":"10.1"}]
[null,null,200,{"v":11.953584779230267,"d":"12.0"},{"v":10.635787189311994,"d":"10.6"},{"v":10.160473035436771,"d":"10.2"},{"v":10.062916440609,"d":"10.1"}]
[null,null,220,{"v":12.363837582868625,"d":"12.4"},{"v":10.769302499067512,"d":"10.8"},{"v":10.194172372878494,"d":"10.2"},{"v":10.07612889313689,"d":"10.1"}]
[null,null,240,{"v":12.813162082091587,"d":"12.8"},{"v":10.91553355260927,"d":"10.9"},{"v":10.231081171028952,"d":"10.2"},{"v":10.090599674476959,"d":"10.1"}]
[null,null,260,{"v":13.301558276899152,"d":"13.3"},{"v":11.07448034993727,"d":"11.1"},{"v":10.271199429888144,"d":"10.3"},{"v":10.10632878462921,"d":"10.1"}]
[null,null,280,{"v":13.829026167291325,"d":"13.8"},{"v":11.246142891051507,"d":"11.2"},{"v":10.314527149456072,"d":"10.3"},{"v":10.123316223593639,"d":"10.1"}]
[null,null,300,{"v":14.395565753268102,"d":"14.4"},{"v":11.430521175951986,"d":"11.4"},{"v":10.361064329732738,"d":"10.4"},{"v":10.14156199137025,"d":"10.1"}]
[null,null,350,null,{"v":11.94709826726798,"d":"11.9"},{"v":10.491448671025115,"d":"10.5"},{"v":10.192681599365061,"d":"10.2"}]
[null,null,400,null,{"v":12.543148757247973,"d":"12.5"},{"v":10.641892141747087,"d":"10.6"},{"v":10.251665762435998,"d":"10.3"}]
[null,null,450,null,{"v":13.218672645891967,"d":"13.2"},{"v":10.812394741898657,"d":"10.8"},{"v":10.31851448058306,"d":"10.3"}]
[null,null,500,null,{"v":13.97366993319996,"d":"14.0"},{"v":11.002956471479825,"d":"11.0"},{"v":10.393227753806245,"d":"10.4"}]
[null,null,600,null,null,{"v":11.444257318930948,"d":"11.4"},{"v":10.566247965480994,"d":"10.6"}]
[null,null,650,null,null,{"v":11.694996436800905,"d":"11.7"},{"v":10.664554903932556,"d":"10.7"}]
[null,null,700,null,null,{"v":11.965794684100457,"d":"12.0"},{"v":10.770726397460242,"d":"10.8"}]
[null,null,800,null,null,{"v":12.567568566988353,"d":"12.6"},{"v":11.00666304974399,"d":"11.0"}]
[null,null,900,null,null,{"v":13.249578967594633,"d":"13.2"},{"v":11.274057922332236,"d":"11.3"}]
[null,null,1000,null,null,{"v":14.0118258859193,"d":"14.0"},{"v":11.572911015224983,"d":"11.6"}]
[null,null,1100,{"$nulls":3},{"v":11.903222328422231,"d":"11.9"}]
[null,null,1200,{"$nulls":3},{"v":12.264991861923978,"d":"12.3"}]
[null,null,1300,{"$nulls":3},{"v":12.658219615730223,"d":"12.7"}]
[null,null,1400,{"$nulls":3},{"v":13.08290558984097,"d":"13.1"}]
[null,null,1500,{"$nulls":3},{"v":13.539049784256214,"d":"13.5"}]
[null,null,1600,{"$nulls":3},{"v":14.02665219897596,"d":"14.0"}]
{"$rows_empty":10}
["*BPA- Backflow Prevention Assemblies"]

{"sheet":"CV","index":10,"n_rows":54,"n_cols":47,"rows_kept":54,"hidden":true}
[{"$nulls":39},"Chart Values",null,null,"Flush Tanks",null,null,"Flushometer Valves"]
[{"$nulls":39},"WSFU","GPM",null,"WSFU","GPM",null,"WSFU","GPM"]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ3,AT3)","v":1},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR3,AU3)","v":{"v":3,"d":"3.0"}},null,1,{"v":3,"d":"3.0"},null,1,{"v":15,"d":"15.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ4,AT4)","v":2},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR4,AU4)","v":{"v":5,"d":"5.0"}},null,2,{"v":5,"d":"5.0"},null,2,{"v":15,"d":"15.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ5,AT5)","v":3},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR5,AU5)","v":6.5},null,3,6.5,null,3,{"v":15,"d":"15.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ6,AT6)","v":4},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR6,AU6)","v":{"v":8,"d":"8.0"}},null,4,{"v":8,"d":"8.0"},null,4,{"v":15,"d":"15.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ7,AT7)","v":5},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR7,AU7)","v":9.4},null,5,9.4,null,5,{"v":15,"d":"15.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ8,AT8)","v":6},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR8,AU8)","v":10.7},null,6,10.7,null,6,17.4]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ9,AT9)","v":7},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR9,AU9)","v":11.8},null,7,11.8,null,7,19.8]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ10,AT10)","v":8},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR10,AU10)","v":12.8},null,8,12.8,null,8,22.2]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ11,AT11)","v":9},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR11,AU11)","v":13.7},null,9,13.7,null,9,24.6]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ12,AT12)","v":10},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR12,AU12)","v":14.6},null,10,14.6,null,10,{"v":27,"d":"27.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ13,AT13)","v":11},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR13,AU13)","v":15.4},null,11,15.4,null,11,27.8]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ14,AT14)","v":12},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR14,AU14)","v":{"v":16,"d":"16.0"}},null,12,{"v":16,"d":"16.0"},null,12,28.6]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ15,AT15)","v":13},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR15,AU15)","v":16.5},null,13,16.5,null,13,29.4]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ16,AT16)","v":14},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR16,AU16)","v":{"v":17,"d":"17.0"}},null,14,{"v":17,"d":"17.0"},null,14,30.2]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ17,AT17)","v":15},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR17,AU17)","v":17.5},null,15,17.5,null,15,{"v":31,"d":"31.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ18,AT18)","v":16},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR18,AU18)","v":{"v":18,"d":"18.0"}},null,16,{"v":18,"d":"18.0"},null,16,31.8]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ19,AT19)","v":17},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR19,AU19)","v":18.4},null,17,18.4,null,17,32.6]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ20,AT20)","v":18},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR20,AU20)","v":18.8},null,18,18.8,null,18,33.4]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ21,AT21)","v":19},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR21,AU21)","v":19.2},null,19,19.2,null,19,34.2]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ22,AT22)","v":20},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR22,AU22)","v":19.6},null,20,19.6,null,20,{"v":35,"d":"35.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ23,AT23)","v":25},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR23,AU23)","v":21.5},null,25,21.5,null,25,{"v":38,"d":"38.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ24,AT24)","v":30},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR24,AU24)","v":23.3},null,30,23.3,null,30,{"v":42,"d":"42.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ25,AT25)","v":35},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR25,AU25)","v":24.9},null,35,24.9,null,35,{"v":44,"d":"44.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ26,AT26)","v":40},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR26,AU26)","v":26.3},null,40,26.3,null,40,{"v":46,"d":"46.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ27,AT27)","v":45},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR27,AU27)","v":27.7},null,45,27.7,null,45,{"v":48,"d":"48.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ28,AT28)","v":50},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR28,AU28)","v":29.1},null,50,29.1,null,50,{"v":50,"d":"50.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ29,AT29)","v":60},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR29,AU29)","v":{"v":32,"d":"32.0"}},null,60,{"v":32,"d":"32.0"},null,60,{"v":54,"d":"54.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ30,AT30)","v":70},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR30,AU30)","v":{"v":35,"d":"35.0"}},null,70,{"v":35,"d":"35.0"},null,70,{"v":58,"d":"58.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ31,AT31)","v":80},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR31,AU31)","v":{"v":38,"d":"38.0"}},null,80,{"v":38,"d":"38.0"},null,80,61.2]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ32,AT32)","v":90},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR32,AU32)","v":{"v":41,"d":"41.0"}},null,90,{"v":41,"d":"41.0"},null,90,64.3]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ33,AT33)","v":100},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR33,AU33)","v":43.5},null,100,43.5,null,100,67.5]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ34,AT34)","v":120},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR34,AU34)","v":{"v":48,"d":"48.0"}},null,120,{"v":48,"d":"48.0"},null,120,{"v":73,"d":"73.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ35,AT35)","v":140},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR35,AU35)","v":52.5},null,140,52.5,null,140,{"v":77,"d":"77.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ36,AT36)","v":160},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR36,AU36)","v":{"v":57,"d":"57.0"}},null,160,{"v":57,"d":"57.0"},null,160,{"v":81,"d":"81.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ37,AT37)","v":180},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR37,AU37)","v":{"v":61,"d":"61.0"}},null,180,{"v":61,"d":"61.0"},null,180,85.5]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ38,AT38)","v":200},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR38,AU38)","v":{"v":65,"d":"65.0"}},null,200,{"v":65,"d":"65.0"},null,200,{"v":90,"d":"90.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ39,AT39)","v":225},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR39,AU39)","v":{"v":70,"d":"70.0"}},null,225,{"v":70,"d":"70.0"},null,225,95.5]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ40,AT40)","v":250},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR40,AU40)","v":{"v":75,"d":"75.0"}},null,250,{"v":75,"d":"75.0"},null,250,{"v":101,"d":"101.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ41,AT41)","v":275},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR41,AU41)","v":{"v":80,"d":"80.0"}},null,275,{"v":80,"d":"80.0"},null,275,104.5]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ42,AT42)","v":300},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR42,AU42)","v":{"v":85,"d":"85.0"}},null,300,{"v":85,"d":"85.0"},null,300,{"v":108,"d":"108.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ43,AT43)","v":400},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR43,AU43)","v":{"v":105,"d":"105.0"}},null,400,{"v":105,"d":"105.0"},null,400,{"v":127,"d":"127.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ44,AT44)","v":500},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR44,AU44)","v":{"v":124,"d":"124.0"}},null,500,{"v":124,"d":"124.0"},null,500,{"v":143,"d":"143.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ45,AT45)","v":750},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR45,AU45)","v":{"v":170,"d":"170.0"}},null,750,{"v":170,"d":"170.0"},null,750,{"v":177,"d":"177.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ46,AT46)","v":1000},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR46,AU46)","v":{"v":208,"d":"208.0"}},null,1000,{"v":208,"d":"208.0"},null,1000,{"v":208,"d":"208.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ47,AT47)","v":1250},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR47,AU47)","v":{"v":239,"d":"239.0"}},null,1250,{"v":239,"d":"239.0"},null,1250,{"v":239,"d":"239.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ48,AT48)","v":1500},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR48,AU48)","v":{"v":269,"d":"269.0"}},null,1500,{"v":269,"d":"269.0"},null,1500,{"v":269,"d":"269.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ49,AT49)","v":1750},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR49,AU49)","v":{"v":297,"d":"297.0"}},null,1750,{"v":297,"d":"297.0"},null,1750,{"v":297,"d":"297.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ50,AT50)","v":2000},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR50,AU50)","v":{"v":325,"d":"325.0"}},null,2000,{"v":325,"d":"325.0"},null,2000,{"v":325,"d":"325.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ51,AT51)","v":2500},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR51,AU51)","v":{"v":380,"d":"380.0"}},null,2500,{"v":380,"d":"380.0"},null,2500,{"v":380,"d":"380.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ52,AT52)","v":3000},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR52,AU52)","v":{"v":433,"d":"433.0"}},null,3000,{"v":433,"d":"433.0"},null,3000,{"v":433,"d":"433.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ53,AT53)","v":4000},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR53,AU53)","v":{"v":525,"d":"525.0"}},null,4000,{"v":525,"d":"525.0"},null,4000,{"v":525,"d":"525.0"}]
[{"$nulls":39},{"$f":"IF('Conversion Sheet A'!$B$29=1,AQ54,AT54)","v":5000},{"$f":"IF('Conversion Sheet A'!$B$29=1,AR54,AU54)","v":{"v":593,"d":"593.0"}},null,5000,{"v":593,"d":"593.0"},null,5000,{"v":593,"d":"593.0"}]