Category : Lotus and other Spreadsheets
Archive   : UTILITY.ZIP
Filename : UTILITIE.WKS

</


ÿ


ÿñ 
H
\Mÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ <0
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿ# ÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ$
%ò&ò'(\029 (
ˆB)
'*ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ-µ
1<ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ

1988 Utilities 1033 7th St. Month $ Billed Gas Elect. qq
ÿ' ÿ
'Gas Bill Analyzer ÿ
^Month
ÿ
^Day

Æ%ÿ'Last Meter Reading


€


4&ÿ'Present Reading


€ÿ
'Cubic Ft.ÿ€[@
ÿ¿þ¿
ÿ¿ý¿
ÿ'Cost per Day
ÿ'/xmn6~ÿ
'Gas Dataÿ'Elect. Dataÿ'Print Reportÿ'View Graphÿ'Print Graphÿ'Quit w/save
ÿ
'ThermsÿëQ¸…Û[@
€ÿ¿h‘í|?5ð?4¢íI«MÚ¾ö?%

€ €X
€ý¿

€ý¿6X
۟
€ü¿6
 ÿ
'enter gas dataÿ'enter elect.dataÿ'print combined reportÿ'view graphÿ'print graph!ÿ'Quits macro and saves file
ÿ
'{home}ÿ'{home}{pgdn}{pgdn}ÿ'/ppgq~/xgl6~
ÿ'/gvÿ'/gpg~q~ ÿ'/fs~rÿ' *ÿ
'/xnEnter previous meter reading~b3~+ÿ'/xnEnter previous meter reading~b37~
ÿ'/xgl6~
ÿ'/xglr~
ÿ'{home}!ÿ
'Customer Charge (see stmt)
¢ š™™™™™@ÿ
'/xnEnter month read~f3~ÿ '/xnEnter month read~e37~ÿ ' 
ÿ '/xqÿ

'  ÿ
'First
ÿ
2ÿ
"X
ÿ
x(
ô‰<¹?¢
žï§ÆK·@
ý¿€
ÿ¿€ÿ

'/xnEnter day read~g3~ÿ
'/xnEnter day read~f37~ÿ
' ÿ
' ÿ'NextÿÖ£p=
·N@
ÿ¿û¿
€ÿ¿
ÿ"X
ÿ¸…ëQ¸¾?¢>Æܵ„|@
ý¿€
ÿ¿€#ÿ
'/xnEnter present reading~b4~*ÿ'/xnEnter present meter reading~b38~ÿ
'Cost of
ÿ 'Gasÿ ëQ¸…Û[@
ÿ¿ú¿ÿ "X
 ¸…ëQ¸¾?¢ cîZB¾*@
ý¿€
ÿ¿€ÿ
'/xnEnter month read~f4~ÿ '/xnEnter month read~e38~ÿ

'Iowa Sales Taxÿ
nÅþ²{>@ €ü¿€ÿ¿P
ÿ
"X ÿ
"4.00%%¢
€Ì|?ó?
ý¿€¤p=
×£ð?
ý¿€
ÿ

'/xnEnter day read~g4~ÿ
'/xnEnter day read~f38~¢'--------- ÿ
'/xnEnter cost of gas~f12~ÿ'/xnEnter cost/unit~c43~¢¦…Ë*lF?@ €ú¿€þ¿P
 ÿ'Total-ÿ
'/xie20=0~/xnEnter Jan Total~e20~/xgl6~-ÿ'/xie50=0~/xnEnter Jan Total~e50~/xgl6~"=========
"========="========="========="========="========="========="========="=========-ÿ
'/xie21=0~/xnEnter Feb Total~e21~/xgl6~-ÿ'/xie51=0~/xnEnter Feb Total~e51~/xgl6~'Date
"%Colder "CCF's
"Therms"Cost' 'Billed to Date  -ÿ
'/xie22=0~/xnEnter Mar Total~e22~/xgl6~-ÿ'/xie52=0~/xnEnter Mar Total~e52~/xgl6~"=========
"========="========="========='========="========="========="========="=========-ÿ
'/xie23=0~/xnEnter Apr Total~e23~/xgl6~-ÿ'/xie53=0~/xnEnter Apr Total~e53~/xgl6~
'Jan 05

'15%
æ
é
" "" þ¿€þ¿ €P
  ,ÿ
'/xie24=0~/xnEnter May Total~e24~/xgl6,ÿ'/xie54=0~/xnEnter May Total~e54~/xgl6
'Feb 03 
  
" " "  -ÿ
'/xie25=0~/xnEnter Jun Total~e25~/xgl6~-ÿ'/xie55=0~/xnEnter Jun Total~e55~/xgl6~
'Mar 
  
" " "  -ÿ
'/xie26=0~/xnEnter Jul Total~e26~/xgl6~-ÿ'/xie56=0~/xnEnter Jul Total~e56~/xgl6~
'Apr 
  
" " "  -ÿ
'/xie27=0~/xnEnter Aug Total~e27~/xgl6~-ÿ'/xie57=0~/xnEnter Aug Total~e57~/xgl6~
'May 
  
" " "  -ÿ
'/xie28=0~/xnEnter Sep Total~e28~/xgl^~-ÿ'/xie58=0~/xnEnter Sep Total~e58~/xgl^~
'Jun 
  "' " "  -ÿ
'/xie29=0~/xnEnter Oct Total~e29~/xgl6~-ÿ'/xie59=0~/xnEnter Oct Total~e59~/xgl6~
'Jul 
  "' " "  -ÿ
'/xie30=0~/xnEnter Nov Total~e30~/xgl6~-ÿ'/xie60=0~/xnEnter Nov Total~e60~/xgl6~
'Aug 
  "' " "  -ÿ
'/xie31=0~/xnEnter Dec Total~e31~/xgl6~-ÿ'/xie61=0~/xnEnter Dec Total~e61~/xgl6~
'Sep 
  "' " "  
ÿ
'/xgl6~
'Oct 
  "' " "  
'Nov 
  "' " "  
'Dec 
  "' " "    
  "' " "   '=========
'========= '========= '========= '========= '========= '========= '=========  ! 
!ÿ!'Electrical Billing ! ! ! ! ! !"' 
"ÿ"'1033 7th St. " " " " " " # 
# # # # # # # # $ÿ
$'Meter Reading $ $ ÿ$^Month
$^Day$'Cost per Day $$'No of Days %

%Lÿ%'Previous %
%

€%
4¢%Yi…·lÝ@%
€€X
þ¿
€
ÿ¿
€6X
þ¿€
ÿ¿€6
  %%
ü¿
€
ü¿€
 &

&ŸOÿ&'Present &
&

€& & & & ' 
' ' ' ' ' ' ' 'ÿ
)'Killowattÿ)'Cost per!¢)|a2UpP@
û¿€
ü¿€
þ¿€
ÿ)'Net Amount ÿ
*'Hoursÿ*'unit
ÿ*'Factorÿ*'Adjustment¢*©kí}ª
@
€ÿ¿{®Gáz¤?ÿ*'Sales Taxÿ
+ðˆ@
€û¿
€ú¿

+#Ûù~j¼´?
+Ǻ¸ðV? ÿ+Žuq
àñ¿
ÿ¿€
ý¿€
¢+'---------¢,yçP†ªQ@
€ý¿
€þ¿  ÿ,'Totalÿ-' ¢-' ÿ.'===========ÿ
.'===========ÿ.'===========ÿ.'===========ÿ.'===========ÿ.'===========ÿ.'===========ÿ/'Date ÿ
/'Kwh'sÿ/'Total Costÿ/'Cost to Dateÿ0'===========ÿ
0'===========ÿ0'===========ÿ0'===========ÿ0'===========ÿ0'===========ÿ0'===========
1'Jan 15

1
"1)\ÂõQ@ ¢1
"1
2'Feb¢2' ¢2 ¢2
3'Mar¢3' ¢3 ¢3
4'Apr¢4' ¢4 ¢4
5'May¢5' ¢5 ¢5
6'Jun¢6' ¢6 ¢6
7'Jul¢7' ¢7 ¢7
8'Aug¢8' ¢8 ¢8
9'Sep¢9' ¢9 ¢9
:'Oct¢:' ¢: ¢:
;'Nov¢;' ¢; ¢;
<'Dec¢<' ¢< ¢<