Spreadsheet: 120880d1315598051-is-it-possible-to-hide-certain-cells-with-a-check-box-with-out-using-vba-sample
Sheet: Sheet1

Annual Fire Pump Test |  |  |  |  |  | Wolverine Fire Protection Co.
 |  |  |  |  |  | PO Box 219 / 8067 [NAME].
Project: |  |  |  |  |  | Mt. Morris, MI. 48458-0219
 |  |  |  |  |  | Phone:(810) 686-4630
 |  |  |  |  |  | Fax:(810) 686-0440
 |  |  |  |  |  | P.O. No: | -
Test Date: |  |  | Time: |  |  | WFPC Job No: | 2010-0011
Owner Rep: |  |  |  |  |  | WFPC Rep:
 | -
Fire Pump Assembly Data:
Fire Pump |  |  |  |  | Fire Pump Controller
Pump Type |  |  |  |  | Controller Type
Rotation |  |  |  |  | Manufacturer
Manufacturer |  |  |  |  | Model No.
Model No. |  |  |  |  | Serial No.
Serial No. |  |  |  |  | Interupting Capacity
Rated Gpm |  | 1000 |  |  | Volt/Phase/Cycle
Rated Pressure \ 2.31 |  | 90 |  |  | Rated Hp.
Rated Churn Pressure |  | 110 |  |  | Start Method
Rated 150% Pressure |  | 65 |  |  | Start Pressure (psi)
Rated Rpm |  |  |  |  | Stop Pressure (psi)
Fire Pump Driver |  |  |  |  | Jockey Pump & Controller
Type |  |  |  |  | [NAME]
Manufacturer |  |  |  |  | Model No.
Model No. |  |  |  |  | Rated Hp.
Serial No. |  |  |  |  | [NAME]
Rated  Hp. |  |  |  |  | Model No.
Rated RPM |  |  |  |  | Serial No.
Service Factor |  |  |  |  | Volt/Phase/Cycle
Rated Amps |  |  |  |  | Start Pressure (psi)
Volt/Phase/Cycle |  |  |  |  | Stop Pressure (psi)
Fire Pump Test Data:
 | Discharge | Suction | Net Pump | [NAME] | Total | Speed | Volts | Amps
Test | Pressure | Pressure | Pressure | Pitot Pressure (psi) | Flow | rpm
 | [NAME] | [NAME] | [NAME] | Flow per Nozzle (gpm) | GPM
 |  |  |  | 0 |  |  | 494 | 35
Churn | 150 | 50 | 100 | 0 | 0 | 3581 | 496 | 36
 |  |  |  | 0 |  |  | 495 | 36
 |  |  |  | 2 |  |  | 492 | 58
1 | 140 | 40 | 100 | 18 | 1000 | 3552 | 492 | 59
 |  |  |  | 376 |  |  | 493 | 57
 |  |  |  | 3 |  |  | 495 | 66
1.5 | 102 | 34 | 68 | 18 | 1500 | 3541 | 494 | 66
 |  |  |  | 376 |  |  | 494 | 64
Test Nozzles = 1-3/4" Underwriters Playpipe with 0.97 Coefficient
Remarks:
See [NAME] below.
Curve (●) = Fire Pump Test |  |  |  |  |  | Curve (■) = Fire Pump Rating
Pump | Net | Total |  |  |  | Pump | Pressure | Flow
Test | Pump | Flow |  |  |  | Rated | [NAME] | Gpm
Points | Pressure | Gpm | Pump Test Curve Results |  |  | Points
Churn | 100 | 0 |  |  |  | Churn | 110 | 0
1 | 100 | 1000 | Pass |  |  | 1 | 90 | 1000
1.5 | 68 | 1500 | Pass |  |  | 1.5 | 65 | 1500
Fire Pump Performance Curve
 |  |  |  | GPM | PSI
 |  | System Demand: |  | 500 | 123 | Pass |  |  |  | So the yellow cells are what I need to be hidden with the click of the second check box |  |  |  |  |  |  |  | ( (check box to remove system demand information check box)
 |  |  |  |  |  |  |  |  |  | I have gotten the pass cell ( G97) to hide with the box but I cant figure out the rest
 | [NAME] to remove Churn Pressure Line and Churn Pass/Fail Cell
 | Check Box to remove System Demand Information | Check Box to remove System Demand information
 |  | Don't touch or even look at the orange cells!!
 |  | Flow |  |  | Rated Curve | Test Curve
 |  | 0 |  | #N/A | 110 | 100
 |  | 1000 |  | 90 | 90 | 100
 |  | 1500 |  |  | 65 | 68
 |  |  |  | 90
 |  |  |  |  | a | a | 0 | Pass
 |  |  |  | Pass | Pass | 1
 |  |  |  | Difference | Run | D. (Y) | D. (X)
 |  |  |  | 10 | 1000 | 123 | 500
 |  |  |  | 5 | 0.5
 | Stop It! |  |  | [NAME]
 |  |  |  | 145
 | Suction Supply
0 | 50
1000 | 40
1500 | 34
 | System Performance
0 | 150
1000 | 140
1500 | 102