Tank Size
Tank Size
Tank Size
Tank Sizing
Service
Storage Temperature °C
Viscosity cP
Type of Roof
Working Capacity m3
Tank Size Selection (from Process Standard 102, Appendix-10 to 13 or Vendor data)
Heat Loss Calculation (Note for Average, Summer & Winter Case if required)
Tank Area
Wall Area,Aw 0.0 m2
Roof Area,Ar 0.0 m2
Floor Area Af 0.0 m2
Page 1
A FOSTER WHEELER ENERGY LIMITED
SUBJECT [Enter Subject here]
PROJECT [Enter Project here] REV DATE ORIGINATOR CHECKER APPROVER
CONTRACT NO. [Enter Contract No.]
LOCATION [Enter Location here]
CALC NO. [Enter Calc. No. here]
TANK SIZING
TankSize 2.00
Coil Sizing
Temperature Tank 0 °C
Steam °C
Delta T 0 °C
Page 2
This sheet should never be visible to the user.
The next expiry date is calculated
It is the definitive statement of program name, version number, here. It onlt becomes "alive" when
version date, expiry date and user password. it is transferred to the range
"ExpiryDate" by using the
These details are reference by various cell formulae and by VBA Administration facility.
code.
The expiry date is set to 15th
September.
Revision: 2.00
Name: TankSize
Password:
Sheet Password: wardlaw
'file:///conversion/tmp/scratch/457081852.xls'#$Formula
Expiry
Dates
xt expiry date is calculated 15-Sep-01 27-Jan-20
onlt becomes "alive" when 15-Sep-02 26-Apr-20
sferred to the range
15-Sep-03 20
Date" by using the
tration facility. 15-Sep-04 15-Sep-20
15-Sep-05
piry date is set to 15th 15-Sep-06
ber. 15-Sep-07
15-Sep-08 These fields are used to generate an appropriate
at after June 15th, the expiry
15-Sep-09 expiry date for the application.
set to 15th September Next
15-Sep-10 This expiry date is copied to the rangename
15-Sep-11 "ExpiryDate" when an authorised administrator
15-Sep-12 requests it via the frmAdministration form and VBA
code.
15-Sep-13
It is not anticipated that any changes will be needed
15-Sep-14 here until 2022 !!!
15-Sep-15
15-Sep-16
15-Sep-17
15-Sep-18
15-Sep-19
15-Sep-20
15-Sep-21
15-Sep-22
15-Sep-23
ate an appropriate
e rangename
ed administrator
ation form and VBA
This example allows the user to readily customise an opening Splash Page.
It uses a Splash Form, and most of the VBA code is within the form itself. The form simply has to be
imported into the user's Excel application.
A little code has to be put into Workbook_Open(...). This is described in the VBA with this (current)
workbook.
The user must have a worksheet called Splash, and the items to appear on the Splash Form must be
layed out on the worksheet using the identical cell references as shown here. (Cell formatting is not
necessary, only helpful). You can hide this "Splash" worksheet from the users by bringing it up on the
screen as your active sheet, then clicking on 'Format'=>'Sheet'=>'Hide'.
(The code can optionally include a timer, so the form displays for just 6 seconds, then closes. This
would replace the "OKAY" button).
Show Splash
simply has to be
Form
ith this (current)
sh Form must be
ormatting is not
nging it up on the
l be automatically
n closes. This