Description of this paper

Loading

need help creating a template in Excel. Its a form id like to use-(Answered)

Description

Step-by-step Instant Solution


Question

need help creating a template in Excel.? Its a form id like to use for testing fire pumps.? I have a basic layout but would like it tweaked a bit.


This is the template i have now. ?

I would like the graph and test data to be on the same page

There are some calculations that need to be entered. discharge psi minus suction psi = net psi and so fourth.

?Remember i want the entire workbook on 1 page.?


let me send you the actual work book so you can see all the calls that need to be put in place. ( Check for this link Sunset Station excel file )


I need tropicana format.. check attach file

i need this "pump data and the graph on the same page!!" ( Attach?SUNSET STATION CASINO PUMP 2015 (1) Electric Pump Data.pdf)


Annual Electric Fire Pump Test

 


 

GESCO NV

 

Company:

 


 

DESERT FIRE

 


 

Inspector:

 


 

Brian Swett

 


 

FIRE PUMP SALES & SERVICE

 


 

Location:

 


 

SUNSET STATION CASINO PUMP 1301 W. SUNSET

 


 

Date of Current Test:

 


 

November 23, 2015

 


 

(702) 357-6494

 


 

Pump Manufacturer &

 

Model #:

 


 

PATTERSON 8X6X12 SSCH

 


 

Pump Serial #

 


 

Electric Motor Manufacturer

 

& Model

 


 

MARATHON 3K447TST

 


 

Electric Motor Serial #

 


 

GPM

 

PUMP RATING

 


 

1,250

 


 

Controller Manufacturer and Model:

 


 

PSI

 


 

RPM

 


 

BHP

 


 

Max Churn Pressure

 


 

Max BHP

 


 

250

 


 

3560

 


 

350

 


 

262

 


 

350

 


 

FIRETROL FTA 1900 -AE350 B

 


 

Fire Marshal Minimum Flow Points

 


 

Type Starting: ACL

 


 

Factory Certified Test Curve

 


 

Pressure Drop

 


 

FPC0110384

 


 

HORIZONTAL SPLITCASE

 


 

Bjswett@cox.net

 


 

09319240-994-01

 


 

Max Suction Pressure

 

78

 

H.P.

 


 

Pump Type:

 


 

40

 


 

Field Certified Test Curve

 


 

Impeller Diameter

 


 

Rated Voltage

 


 

14.15

 


 

440-480

 


 

Full Load Amps

 

395

 


 

Flow Test Device Used:

 


 

pitot

 


 

Inspectors Comments or Recommendations:

 


 

Fire Pump Settings:

 


 

Jockey Pump Settings:

 


 

GPM

 


 

PSI

 


 

GPM

 


 

PSI

 


 

GPM

 


 

PSI

 


 

Start:

 


 

210

 


 

Start:

 


 

240

 


 

Churn

 


 

0

 


 

248.9

 


 

0

 


 

262

 


 

0

 


 

261

 


 

Stop:

 


 

260

 


 

Stop:

 


 

260

 


 

Rated

 


 

1250

 


 

237.5

 


 

1250

 


 

250

 


 

1250

 


 

250

 


 

Casing Relief Valve OK;

 


 

150%

 


 

1875

 


 

223.2

 


 

1875

 


 

235

 


 

1875

 


 

237

 


 

Main Relief Valve Setting:

 


 

NA

 


 

Stuffing Box Adjusted:

 


 

Yes

 


 

Bearings Checked:

 


 

Yes

 


 

Annual Fire Pump Test for year:

 

Pressure Readings

 

Discharge

 

Suction PSIG

 

PSIG

 

1

 

262

 


 

2015

 


 

Net PSIG

 


 

Actual Flowing Condition

 

RPM Reading

 


 

261

 


 

3587

 


 

Discharge

 

Coefficient

 


 

2015

 


 

Adjusted for RPM

 


 

Outlet

 

Diameter

 


 

Auto or Manual Stop:

 

Individual Outlet Pitot Readings

 


 

Total gpm

 

0

 


 

0

 


 

250

 


 

250

 


 

3577

 


 

0.97

 


 

1.75

 


 

22

 


 

22

 


 

22

 


 

0

 


 

225

 


 

225

 


 

3572

 


 

0.97

 


 

1.75

 


 

28

 


 

28

 


 

28

 


 

Annual Fire Pump Test for year:

 


 

257.085599

 


 

3560

 


 

1240.97987 247.629354

 


 

3560

 


 

1875.59943 1869.29842 223.490781

 


 

3560

 


 

1246.9059

 

28

 


 

Adjusted GPM Adjusted PSI Adjusted RPM

 

0

 


 

0

 


 

0

 


 

0

 


 

0

 


 

0

 


 

0

 


 

0

 


 

0

 


 

0

 


 

0

 


 

0

 


 

0

 


 

0

 


 

0

 


 

0

 


 

0

 


 

Actual Flowing Condition

 


 

Adjusted for RPM

 


 

Yes

 


 

Measured

 

Voltage

 


 

MANUAL

 


 

Measured Amps

 

Leg 1

 


 

Leg 2

 


 

Leg 3

 


 

 

Paper#9256793 | Written in 27-Jul-2016

Price : $16
SiteLock