Spreadsheet: 269238d1381072760-complete-sheet-shows-formulas-useage-spread-sheet-treecko-oeldere-
Sheet: ppd AHAM DDLB

Define name "ppd_AHAM" |  | Define list "DHM_60to65" | Define list "DHM_70to92" | Define list "DHM_110to135" | Define list "DHM_170to176" |  | Create filter list section called "ClassList" | Define list | Negative Air Machines | Province | Tax
Class 1 Refrig (Standard)  WTR DHM (60-65) |  | Drizair 1200  60 ppd  WRT DHM | [NAME] 200  100 ppd WTR DHM> | Dry Air Atlantic  140 ppd WTR DHM>> | LGR 3500i  170 ppd  WTR DHM>>> |  | Class 1 Refrig (Standard) | DHM_60to65 | PRED600 600 CFM WTR NAFAN | Alberta GST 5% | 0.05
Class 1 Refrig (Gas Bypass)  WTR DHM> (70-100) |  | Phoenix R125  65 ppd  WTR DHM | [NAME]  70 ppd  WTE DHM> | LGR 2000  110 ppd WTR DHM>> | Phoenix 270 HTx  161 ppd  WTR DHM>>> |  | Class 1 Refrig (Gas Bypass) | DHM_70to92 | PRED1200 900 CFM WTRNAFAN> | British Columbia GST 7% | 0.07
Class 1 Refrig (GAS Bypass) WTR DHM>> (110-150) |  |  | Phoenix R150  75 ppd  WTR DHM> | LGR 2800i  130 ppd WTR DHM>> | Phoenix 300  176 ppd  WTR DHM>>> |  | Class 1 Refrig (GAS Bypass) | DHM_110to135 | PRED 1200UV  900 CFM WTR NAFAN> | Manitoba GST 13% | 0.13
Class 1 Refrig (GAS Bypass) WTR DHM>>> (170-176) |  |  | Phoenix R175  92 ppd  WTR DHM> | LGR 7000LXi  130 ppd WTR DHM>> |  |  | Class 1 Refrig (GAS Bypass) | DHM_170to176 | PAS600  600 WTRNAFAN | New Brunswick GST 13% | 0.13
Class 2 Refrig (Standard)  WTR DHM (60-65) |  |  |  | Phoenix 200 HT  135 ppd WTR DHM>> |  |  | Class 2 Refrig (Standard) | DHM_60to65 | PAS 1200  900CFM  WTR NAFAN> | Newfoundland GST 13% | 0.13
Class 2 Refrig (Gas Bypass)  WTR DHM> (70-100) |  |  |  | Phoenix 200 MAX 128 ppd WTR DHM>> |  |  | Class 2 Refrig (Gas Bypass) | DHM_70to92 | PAS1600SHS  1900 CFM WTR NAFAN>> | NWT  GST 5% | 0.05
Class 2 Refrig (Gas Bypass)  WTR DHM>> (110-150) |  |  |  | Phoenix R200  125 ppd  WTR DHM>> |  |  | Class 2 Refrig (Gas Bypass) | DHM_110to135 | PAS2400 2100 CFM  WTRNAFAN>> | Ontario GST 13% | 0.13
Class 2 Refrig (Gas Bypass)  WTR DHM>>> (170-176) |  |  |  |  |  |  | Class 2 Refrig (Gas Bypass) | DHM_170to176 | PAS500  400 CFM  WTR NAFAN>> | PEI GST 14% | 0.14
Class 3 Refrig (Standard) WTR DHM (60-65) |  |  |  |  |  |  | Class 3 Refrig (Standard) WTR DHM (60-65) | DHM_60to65 |  | Quebec GST 14.975% | 0.07
Class 3 Refrig (Gas Bypass) WTR DHM> (70-100) |  |  |  |  |  |  | Class 3 Refrig (Gas Bypass) WTR DHM> (70-100) | DHM_70to92 |  | Saskatchewan GST 10% | 0.1
Class 3 Refrig (Gas Bypass) WTR DHM>> (110-150) |  |  |  |  |  |  | Class 3 Refrig (Gas Bypass) WTR DHM>> (110-150) | DHM_110to135
Class 3 Refrig ([NAME]) WTR DHM>>> (170-176) |  |  |  |  |  |  | Class 3 Refrig ([NAME]) WTR DHM>>> (170-176) | DHM_170to176
Class 4 Refrig (Standard) (60-65) |  |  |  |  |  |  | Class 4 Refrig (Standard) (60-65) | DHM_60to65
Class 4 Refrig (Gas Bypass)WTR DHM> (70-100) |  | WTR DHM |  |  |  |  | Class 4 Refrig (Gas Bypass)WTR DHM> (70-92) | DHM_70to92
Class 4 Refrig (Gas Bypass) WTR DHM>> (110-150) |  | Drizair 1200  60 ppd  WRT DHM |  |  |  |  | Class 4 Refrig (Gas Bypass) WTR DHM>> (110-150) | DHM_110to135
Class 4 Refrig ([NAME]) WTR DHM>>> (170-176) |  | Phoenix R125  65 ppd  WTR DHM |  |  |  |  | Class 4 Refrig ([NAME]) WTR DHM>>> (170-176) | DHM_170to176
 |  | WTR DHM>
 |  | [NAME]  70 ppd  WTE DHM>
 |  | Phoenix R150  75 ppd  WTR DHM>
 |  | Phoenix R175  92 ppd  WTR DHM>
 |  | WTR DHM>>
 |  | LGR 2000  110 ppd WTR DHM>>
 |  | LGR 2800i  130 ppd WTR DHM>>
 |  | LGR 7000LXi  130 ppd WTR DHM>>
 |  | Phoenix R200  125 ppd  WTR DHM>>
 |  | Phoenix 200 MAX 128 ppd WTR DHM>>
 |  | Phoenix 200 HT  135 ppd WTR DHM>>
 |  | WTR DHM>>
 |  | LGR 3500i  170 ppd  WTR DHM>>>
 |  | Phoenix 270 HTx  161 ppd  WTR DHM>>>
 |  | Phoenix 300  176 ppd  WTR DHM>>>
 |  | W*L*H measurements    (=E7/60) | Class 1  (Lands in F and I columns) | Class 2  (Lands in F and I columns) | Class 3  (Lands in F and I columns) |  | Class 4  (Lands in F and I columns)
 |  | Drizair 1200  60 ppd  WRT DHM | E7/60 | E11/60 | E15/60 |  | N/A
 |  | Phoenix R125  65 ppd  WTR DHM | E7/65 | E11/65 | E15/65 |  | N/A
 |  | [NAME] 200  100 ppd WTR DHM> | E8/100 | E12/100 | E16/100 |  | E20/100
 |  | [NAME]  70 ppd  WTE DHM> | E8/70 | E12/70 | E16/70 |  | E20/70
 |  | Phoenix R150  75 ppd  WTR DHM> | E8/75 | E12/75 | E16/75 |  | E20/75
 |  | Phoenix R175  92 ppd  WTR DHM> | E8/92 | E12/92 | E16/92 |  | E20/92
 |  | Dry Air Atlantic  140 ppd WTR DHM>> | E9/140 | E13/140 | [NAME] |  | E21/140
 |  | LGR 2000  110 ppd WTR DHM>> | E9/110 | E13/110 | E17/110 |  | E21/110
 |  | LGR 2800i  130 ppd WTR DHM>> | E9/148 | E13/148 | E17/148 |  | E21/148
 |  | LGR 7000LXi  155 ppd WTR DHM>> | E9/155 | E13/155 | E17/155 |  | E21/155
 |  | Phoenix 200 HT  135 ppd WTR DHM>> | E9/135 | E13/135 | E17/135 |  | E21/135
 |  | Phoenix 200 MAX 128 ppd WTR DHM>> | E9/128 | E13/128 | E17/128 |  | E21/128
 |  | Phoenix R200  125 ppd  WTR DHM>> | E9/125 | E13/125 | E17/125 |  | E21/125
 |  | LGR 3500i  170 ppd  WTR DHM>>> | E10/170 | E14/170 | E18/170 |  | E22/170
 |  | Phoenix 270 HTx  161 ppd  WTR DHM>>> | E10/161 | E14/161 | E18/161 |  | E22/161
 |  | Phoenix 300  176 ppd  WTR DHM>>> | E10/176 | E14/176 | E18/176 |  | E22/176
 |  | CF measurements | Class 1  (Lands in F and I columns) | Class 2  (Lands in F and I columns) | Class 3  (Lands in F and I columns) |  | Class 4  (Lands in F and I columns)
 |  | Drizair 1200  60 ppd  WRT DHM | E23/60 | E27/60 | E31/60 |  | N/A
 |  | Phoenix R125  65 ppd  WTR DHM | E23/65 | E27/65 | E31/65 |  | N/A
 |  | [NAME] 200  100 ppd WTR DHM> | E24/100 | E28/100 | E32/100 |  | E36/100
 |  | [NAME]  70 ppd  WTE DHM> | E24/70 | E28/70 | E32/70 |  | E36/70
 |  | Phoenix R150  75 ppd  WTR DHM> | E24/75 | E28/75 | E32/75 |  | E36/75
 |  | Phoenix R175  92 ppd  WTR DHM> | E24/92 | E28/92 | E32/92 |  | E36/92
 |  | Dry Air Atlantic  140 ppd WTR DHM>> | E25/140 | E29/140 | E33/140 |  | E37/140
 |  | LGR 2000  110 ppd WTR DHM>> | E25/110 | E29/110 | E33/110 |  | E37/110
 |  | LGR 2800i  130 ppd WTR DHM>> | E25/148 | E29/148 | E33/148 |  | E37/148
 |  | LGR 7000LXi  155 ppd WTR DHM>> | E25/155 | E29/155 | E33/155 |  | E37/155
 |  | Phoenix 200 HT  135 ppd WTR DHM>> | E25/135 | E29/135 | E33/135 |  | E37/135
 |  | Phoenix 200 MAX 128 ppd WTR DHM>> | E25/128 | E29/128 | E33/128 |  | E37/128
 |  | Phoenix R200  125 ppd  WTR DHM>> | E25/125 | E29/125 | E33/125 |  | E37/125
 |  | LGR 3500i  170 ppd  WTR DHM>>> | [NAME] | E30/170 | E34/170 |  | E38/170
 |  | Phoenix 270 HTx  161 ppd  WTR DHM>>> | E26/161 | E30/161 | E34/161 |  | E38/161
 |  | Phoenix 300  176 ppd  WTR DHM>>> | E26/176 | E30/176 | E34/176 |  | E38/176