%   P #hi !"#$%/ q H d GG!P GMENU GMENU2GMENU3G\0G\AG\BG\MG\NG\O 0 # gi( f$%&'(\017 ( U)'*-7777qq1'( FOR MENU, IF NONE EXISTS)+'FORMATION EVALUATION AND VOLUMETRICS 'WELL: '#1'Tony A. Rongey 'DATE: "@7"'LOCATION:'GREELEY CO., KS 'FMT: 'A 'DEPTH:  'VITAL RESULTS:' POROSITY= (?`)'******DEFAULT VALUE FOR SW******** ' SW HARD ROCKS" g? _f e #" '*******DEFAULT VALUE******* ' SW LOW POROSITY CARB=. `ߘ?QQ  fe # 'CALCULATED* 0ꘐY </$?   ' OIL IN PLACE(BO)=; _=݄4"A,Nf c d e  h   'CALCULATED ' RECOVERABLE OIL (BO)= fqo@ f  'CALCULATED"' ESTIMATED GAS RESERVES-MCFhR?n2AYzE@Q?`ffff-@     d   a b 'CALCULATED ' OIL PRICE/BBL " 'ENTER' RECOVERABLE OIL VALUEfqo5A  'CALCULATED' ' GAS PRICE/MCF "(\? 'ENTER' RECOVERABLE GAS VALUE'rAQ?  'CALCULATED,'(VALUED ON 2/3 OF TOTAL GAS IN PLACE) ' COST TO DRILL & COMPLETE "A 'ENTER!' RETURN ON INVESTMENT--OILx@J@   ':1'CALCULATED!' RETURN ON INVESTMENT--GASp\?   ':1'CALCULATED'1 RW DETERMINATION 'FORMATION TEMPERATURE v}?    !T}^?    "'A SURFACE TEMPERATURE(F)= "@P@ "'ENTER "6?`fff3@ $#'B DEPTH(FEET)= # #'ENTER #&   #'K!$'C GRADIENT(PER FOOT IN F)= $~jt? $'ENTER) $( h? @㥛?  !%'D CALCULATED FORM TEMP(F)="%33333[d@  "%'*******DEFAULT VALUE******** %6I?ͪϥ?`ffffI@ $ &'E NORMAL BHP(PSI)=&Xŝ@@z? &'CALCULATED+ 'vv"4??   ('RW FROM SSP (Ymӫ?   *'A SSP= *` *'ENTER+'B RMF@ 75 F= +@ +'ENTER,' RMF@ FORM TEMP= , ,'ENTER-'C CALCULATED RWeq=-T}^?-'CALCULATED.'D CALCULATED RW=.Ymӫ?%.'********DEFAULT FOR SW******** /'E Rxo= /d /'ENTER2'2 POROSITY CALCULATIONS5'SHALE VOLUME7'A CLEAN SAND GR= 7 7'ENTER8'B SHALE GR 8F 8'ENTER9'C FORMATION GR= 9 9'ENTER:'D SHALE INDEX=*:F]tE?   :'CALCULATED";'E SHALE VOLUME OLDER ROCKS=.;w?Q?    ;'CALCULATED"<'F SHALE VOLUME TERT. ROCKS=4<tP?%`|?? @    '<'**********DEFAULT VALUE*********>'DENSITY LOG @'NOTES.A'MATRIX DENSITY SS=2.65,LS=2.71,DOL=2.85A'9B'DRILLING MUD DENSITY: SALT MUD=1.1,FRESH MUD = 1.0#D'A DENSITY OF DRILLING FLUID= D@(? D'ENTERE'B MATRIX DENSITY = E ףp@ E'ENTER"F'C ZONE OF INTEREST DENSITY= F@ F'ENTERG'D SHALE VOLUME= 0GQ?"G'USES DEFAULT UNLESS ENTEREDH'E DENSITY SHALE= H@ H'ENTERI'F LIMESTONE POROSITY=ZINɥ?K@z@ @z@  @z@ @z@  I'CALCULATEDJ'G POROSITY=J0J (?;      )J'******DEFAULT VALUE FOR SW********L'NEUTRON LOG-COMPENSATED N'A NEUTRON POROSITY-LS= 0N ףp= ? N'ENTERO'B DOLO. POROSITY WHEN P' LS POROSITY < 10%=P)'? d P'CALCULATEDI P}h'@:@؟?d   1? d  `k ? Q' LS POROSITY >= 10%=Q.Q?Q? Q'CALCULATEDR'C SANDSTONE POROSITY=R W(?Gz? R'CALCULATEDS'D SHALE VOLUME=0Sw?"S'USES DEFAULT UNLESS ENTEREDT'E POROSITY SH IN LS= 0T(\? T'ENTERU'F CORR LS POROSITY="Ur?n?  U'CALCULATEDV'G CORR DOLO POROSITY="Vh9L?  V'CALCULATEDW'H CORR SS POROSITY="Wrf&;?  W'CALCULATEDY'POROSITY CROSSPLOT['A POROSITY=-0[d0?   #['CALCULATED\'\'B APPARENT MATRIX=&\Z8Z@ 3333?   \'G/CC]'C GAS EFFECT=,]< ; ]'G/CC^'D HYDROCARBON DENSITY =y^PQ7-?j   @?p= ?   (\@?    ^'G/CC_'E API EQUIV. GRAVITY=)_E;T@a@ p`@ _'DEGREES`'F GOR (35 DEGREE OIL)=X`LŬ{?I- 3333? `G?  3333? `G?  ; `':1c'3 SALTWATER SATURATION e'A RT= e  e'ENTER f'B RW=fYmӫ?ȿ"f'USES DEFAULT UNLESS ENTEREDg'C POROSITY=&0g (?;"g'USES DEFAULT UNLESS ENTERED h'D Sxo=,h-ԭ4A?Ŀǿ  ? h'CALCULATED)h4@p= ? 3333@ i(19@ *ip+{?@?~jt?  )m'4 VOLUMETRIC RESERVE DETERMINATIONo'A AREA IN ACRES oD@ o'ENTERp'B THICKNESS IN FEET= p p'ENTERq'C WATER SATURATION0q g?"q'USES DEFAULT UNLESS ENTEREDr'D POROSITYr (?r'***DEFAULT FOR SW***s'E RECOVERY FACTOR= 0s 3333? s'ENTER!t'F FORMATION VOLUME FACTOR= t? t'ENTER<'INSTRUCTIONS:(hit return when finished for main menu)T' This Lotus template is designed for open hole log analysis of oil and /XG\M'gas wells.L' The main menu will give you the various options available includingO'Labels(header information), RW (determines rw using SP method), PorosityQ'(determines shale corrected porosity for density, neutron, and sonic logs)N'SW (water saturation is determined), OIL RES (determines oil reserves),D'PRINT (prints worksheet to EPSON compatibles), FILE (saves orH'erases files with clear macro option), and HELP is where you are.J' The worksheet tells you what must be entered for each category. Q'Default values are labeled "*****DEFAULT******" and are used for remaining-'calculations unless otherwise changed. '/XG\M~                        ! " # $ %'/XMMENU~ 'LABELS 'RW 'POROSITY 'SW'OIL RES 'PRINT 'FILE 'HELP                        ! " # $ % 'WELL NAME, LOCATION, ETC.%'ENTER DEPTH, GRADIENT, RMF,ETC'SHALE, DENSITY, NEUTRON 'SHALE CORRECTED, ENTER RT'BOIP, RECOVERABLE'TURN PRINTER ON'SAVE, GET, ERASE, QUIT'INSTRUCTIONS~'{HOME}{DOWN}{DOWN}{RIGHT}{?}{down}{?}{right}{right}{right}{right}{right}{right}{right}{right}{RIGHT}{?}{DOWN}{?}~/XG\M~'{HOME}{GOTO}A34~{right}{right}{right}{right}{down}{?}{down}{?}{down}{?}{down}{?}{down}{down}{down}{down}{down}{?}{down}{?}{down}{?}{down}{down}{down}{?}/XG\M~ '/XG\N~d'{goto}A101~{right}{right}{right}{right}{down}{?}{down}{?}{down}{?}{down}{down}{down}{?}/XG\M~'{goto}A111~{right}{right}{right}{right}{down}{?}{down}{?}{down}{?}{down}{?}{down}{?}{down}{?}{DOWN}{down}{down}{?}~/XG\M~'/PPAGQ/XG\M~ '/XG\O~'{GOTO}A134~{?}/XG\M~'/XMMENU2~ 'SHALE'DENSITY'NEUTRON'MAIN MENU''GAMMA RAY%'FLUID, MATRIX, SHALE, POROSITY1'LS POROSITY UNITS, CONVERTS TO DOLO AND SS|'{goto}A51~{down}{down}{down}{down}{down}{right}{right}{right}{right}{?}{down}{?}{down}{?}{DOWN}{DOWN}{DOWN}{?}~/XG\N~'{goto}A64~{DOWN}{down}{down}{down}{down}{right}{right}{right}{right}{?}{down}{?}{down}{?}{down}{?}{down}{?}{DOWN}{?}~/XG\N~'{GOTO}A77~{RIGHT}{RIGHT}{RIGHT}{RIGHT}{DOWN}{DOWN}{?}{down}{down}{down}{down}{down}{?}{down}{?}{down}{down}{down}{?}~/XG\N~ '/XG\M~'/XMMENU3~ 'SAVE 'GET 'ERASE'MAIN MENU'NO MENU'TO DISK DRIVE'RETRIEVE FILE ON DISK-'ERASE WORK SHEET - HAS FILE BEEN SAVED'EXIT MENU CONFIGURATION '/FS'/FD~/FR{?} '/WE{?} '/XG\M~ '/XQ~             '