Category : Lotus and other Spreadsheets
Archive   : 123TUTOR.ZIP
Filename : TUTORIAL.WKS

'}/


ÿ


q %H





 





         !
#
%
&
'
AGE

BIRTHDATECLOSING

COMMENT

DATADATEDBIRTHDUEDATEEFW  ESTAGE
(
,ESTAGE2
1
2HIGHEFW INPCMTS
JUNK1
JUNK2JUNK4LBWGT

LETTER"ALMP LMPDATELOWEFW

MBIRTHMENUMESSAGE((MONTH?MONTHDUEÿÿÿÿMTHTABLENAMETITLE!!OPERATOROZWGT

PATFNAMEPATINFO
PATNAME

PHYSNAMEREPORT1!!REPORT2!!YBIRTH\0

\M\P!!\V!!.Å
ABDPERÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ!ÿÿ!ÿÿ!ÿÿ!ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ





ÿ>@àu@\q2 \q3 Gestational Age (in weeks) \b41 > Exam date : \v1 qq
.Å
BPDÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ!ÿÿ!ÿÿ!ÿÿ!ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ





ÿ.@ÀW@\q2 \q3 Gestational Age (in weeks) \b9 > Exam date: \v1 qq
.Å
EFWÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ!ÿÿ!ÿÿ!ÿÿ!ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ





ÿY@@¯@\q2 \q3 Gestational Age (in weeks) \b69 > Exam date: \v1 qq
.Å
FEMURÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ!ÿÿ!ÿÿ!ÿÿ!ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ





ÿ@@U@\q2 \q3 Gestational Age (in weeks) \b21 > Exam date : \v1 qq
.Å
HDPERÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ!ÿÿ!ÿÿ!ÿÿ!ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ





i@\q2 \q3 Gestational Age (in weeks) \b12 > Exam date : \v1 qq
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ

0
ÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿ# ÿÿÿÿ ÿÿÿÿÿÿÿÿ$
%òopyright 1984 (Philippe Jeanty M.D.)|| &òPatient: Foucher '((

PB)
'*ÿÿÿÿÿÿÿÿ!-µ
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ!ÿÿ!ÿÿ!ÿÿ!ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ





ÿY@@¯@\q2 \q3 Gestational Age (in weeks) \b69 > Exam date: \v1 qq
$ÿ
'D A T A I N P U T A R E A"Patient's information:
rƒyÿ'<-- Today's Date
ÿ"MACROS ÿ '\Pÿ!'Is the printer "ON" ?ÿ"'Print the reportÿ#'Main Menuÿ

\~ÿ
\~ÿ
\~ÿ
'Predicted ageÿ

'Predicted sizeÿ
"Last Name :
'Foucher ÿ
'\0,ÿ
'{GOTO}message~/DFDATE~@TODAY~~~/XG\M~Pÿ!
'Please make sure that the printer is "ON", then select "Print the report"Fÿ"
'Please be patient, printing the report takes about 4 minutes !~ÿ#
'Returns to the main menu ÿ' Dataÿ^Meanÿ' in weekÿ
' in mmÿ"First Name : 'Adeleÿ!'/XMAH1~/xmY48~#ÿ"'/REy35..ae100~/XGAH5~/XMAH1~
ÿ#'/XG\m~
ÿ'# 1
ÿ'# 2
ÿ'5thÿ'50thÿ'95th
ÿ
'5thÿ'50thÿ '95thÿ"Birthday (MM/DD/YY) :
ÿ'/
ÿ'/
8Gñ<@8
ÿ¿€
û¿€
ý¿€7
ÿ¿€
û¿€
ý¿€6
m
";ÿ'<-- Patient's age ÿ'\Mÿ'{GOTO}message~/XMmenu~ÿ'? ÿ'Nameÿ'Dataÿ'Comments
ÿ'Reportÿ'Prepareÿ'Exitbÿ!'{GOTO}estage2~/Cestage~~{DOWN}{EDIT}{CALC}{HOME}'{DOWN}{DOWN}{EDIT}{CALC}{HOME}'{END}{DOWN}!ÿ
" Biparietal Diameter (mm)
B <€P@-Q
iQ
;2Q
;"|8ñ,EßÖ~Û7@)

€€

€€Âõ(\ú?Ház®Gñ?
;^ñü‰·Çs¦9@O
ý¿€¦(—Æ/|@C65uÃÛÝ?
ý¿€ ͣĩ44n?
ý¿€

å>Ú¼“ý>
ý¿€
 ;8ñÌΏ¸hq;@)
ÿ¿€
ÿ¿€Âõ(\ú?Ház®Gñ? ; "|7€
¿YexÙM@(
€€ 

€€Âõ(\ú?Ö ˜£@
;_€󰹚JP@P

€€ ü©ñÒM¢3@&䃞Í*@

€€ mp–’¥?

€€
 CgãÒBS?

€€

;7€ †àÆÙ5Q@(
€€ 
ÿ¿€Âõ(\ú?Ö ˜£@ ;
"|;ÿ,
ö¿€
ö¿€
ü¿€
ö¿€
þ¿€
;;"Referring physician:'Herodote0ÿ'Enter administrative data for the patientÿ'Enter measurementsEÿ'Enter your comments and suggestions regarding this examinationÿ'Print the reportQÿ"Prepare for a entering a new patient WARNING: this erase the current data 8ÿ'Quit the program, and return to LOTUS Access MenuŠÿ!'{DOWN}The expected due date based on the LMP is{DOWN}@month(duedate)~{EDIT}{CALC}{HOME}~/RNDmonthdue~/RNCmonthdue~~/XCmonth?~{DOWN}ÿ
"Abdominal Diam #1
7 <€K@-þ¿€ÿ¿€Q
xÿ¿€þ¿€Q
;2þ¿€ÿ¿€Q
;"| "| €
 € € 
"| $ÿ'{GOTO}p1~/XIpatname<>1~/XG\M~ÿ'/RIdata~/XG\m~"ÿ'{GOTO}a13~/RIinpcmts~/XG\m~ÿ'/XMAH1~/xmY48~Rÿ'/REjunk1~/REjunk2~/REybirth~/REjunk4~{GOTO}patname~1~{GOTO}message~/XMmenu~ ÿ'/QYEY‡ÿ!'@day(duedate)~{EDIT}{CALC}{HOME}'{END}, 19{DOWN}@year(duedate)~{EDIT}{CALC}{HOME}'~{UP}/RJ.{DOWN}~{EDIT}.{LEFT}{LEFT}{LEFT}{BS}~ÿ
"Abdominal Diam #2
5 <€J@-þ¿€ÿ¿€Q
xÿ¿€þ¿€Q
;2þ¿€ÿ¿€Q
;"| "| €
 € € 
"| 'ÿ'/XLPatient's LAST NAME:~patname~“ÿ!'{END}{UP}/RJ{END}{DOWN}{RIGHT}{RIGHT}{RIGHT}{RIGHT}{RIGHT}{RIGHT}{RIGHT}{RIGHT}{RIGHT}{RIGHT}{RIGHT}{RIGHT}{RIGHT}~/RNCestage2~.{END}{DOWN}~ÿ
'Abdominal Perimeter:&ÿÍѬ4e@à†DTû!ù?
€þ¿
€ÿ¿ "Operator:'Vesalius)ÿ'/XLPatient's FIRST NAME:~patfname~ € Ùÿ!"{GOTO}y41~To Dr{DOWN}/Cphysname~~{UP}/RJ{RIGHT}{RIGHT}{DOWN}~{RIGHT}{RIGHT}{RIGHT}{UP}{UP}{UP}{UP}{UP}{UP}" Examination performed on {RIGHT}{RIGHT}{RIGHT}@month(date)~/RNDmonthdue~/RNCmonthdue~~/XCmonth?~{DOWN}  %ÿ
"Estimated Fetal Weight (g) -->–€ (…@‡


3
xœ¢#¹üû?sh‘í|?Å?

 Zd;ßO§?

 ^ºI +@



è

è?; "| "|u€
4ùÓ°ô¿ƒ@f

€€
€€

€€
>íð×dÍ@‚hØÞÙ?
€€ 3"æÌUw…?
€€

Ùv7ãÑ?
€€
 

;p€ “ä¾Ou4‹@a

€€


€€RgIÛS
á?

€€ ˜`º¼?

€€ 
Âë#?

€€

«'ÖjGõ>

€€


;u€ &Äýý¤’@f
ÿ¿€
€€
ÿ¿€
Ñ6®—@P¤ €’§Ù?
€€ ª¾-7œ"…?
€€

k±3?
€€
 
 ;
"|Rÿ C
ö¿€
ö¿€
þ¿€
ö¿€
ü¿€
ö¿€
þ¿€
;;;Tÿ '/XNMONTH of BIRTHDATE (type 0 if unknown):~mbirth~/XImbirth>12~/XGmonthbirth~¥ÿ! '@day(date)~{EDIT}{CALC}{HOME}'{END}, 19{DOWN}@year(date)~{EDIT}{CALC}{HOME}'~{UP}{UP}/RJ.{DOWN}{DOWN}{RIGHT}{RIGHT}~{EDIT}.{LEFT}{LEFT}{LEFT}{BS}~{DOWN}{DOWN}ÿ

'EFW (pounds + ounces)ÿ
ð?
 Å
"ÿ
'lbs.(ÿ
@


Å

 ?
ÿ
'ounces €
€
 ÿ
'/XImbirth=0~/XGphysintro~Cÿ!
'{LEFT}"Re:{RIGHT}/Cpatinfo~~{GOTO}ae39~/XIq4=0~ ~/XGreport1~  q     ñ  € € ÿ"LMP (MM-DD-YY):
 ÿ'/
ÿ'/
T òÀ4Þ@
ÿ¿€
û¿€
ý¿€6lÿ'/XNPatient's DAY of BIRTHDATE:~dbirth~/XIdbirth<1#AND#dbirth>@VLOOKUP(mbirth,mthtable,1)~/XGdaybirth~5ÿ!'+birthdate~{EDIT}{CALC}{HOME}'{END} years old~ €& €'ÿ
'C O M M E N T S: q   q  ñ € € ÿ "Nbr of days elapsed:>ÿ f@/
€ô¿
€ÿ¿

€ô¿
€ÿ¿
@

€ô¿
€ÿ¿
;ÿ 'daysVÿ '/XNPatient's YEAR of BIRTHDATE:~ybirth~/XI@year(@today)-ybirth>45~/XGyearbirth~yÿ! '{GOTO}Y41~{DOWN}{DOWN}{DOWN}{DOWN}Dear Dr{DOWN}/Cphysname~~{EDIT},{UP}/RJ{RIGHT}{RIGHT}{RIGHT}{RIGHT}{DOWN}{DOWN}~ €& €' ÿ

'~~~~~~~~~~~~~~~~ ñ
ÿ
"Nbr of weeks elapsed:€
I’$I’$9@
   ÿ
'weeks €
4ÿ
'{CALC}{GOTO}p6~/XLPhysician's name:~physname~oÿ!
'{DOWN}{DOWN}{DOWN}' Thank you for refering to us Ms{DOWN}/Cpatname~~{DOWN}/Cpatfname~~{EDIT} ~{DOWN} €&
€'
Q
' This baby looks great, it size and weight are appropriate for its age     ñ ñ ñ ñ  € €  
ÿ"Due Date (from LMP) :)òÀzÞ@
€ý¿2
€þ¿2
€ý¿
;;&ÿ'{GOTO}p9~/XLOperator:~operator~]ÿ!'who is currently{DOWN}/Cage~~{EDIT}{HOME}@INT~{EDIT}{CALC}{HOME}'{DOWN}weeks by dates. €& €'`
'and no evidence of congenital malformations are seen. The fetal sexe is that of a female.     ñ ñ ñ   €
 € €  
 òÿ'{GOTO}p12~/RIlmp~{?}Yÿ!'{UP}{UP}{END}{UP}/RJ.{END}{DOWN}{RIGHT}{RIGHT}{RIGHT}{RIGHT}{RIGHT}{RIGHT}{RIGHT}~ €& €' 
 €  ñ ñ   €
 € €  
8ÿ'Please move the cursor with the <-- and --> arrow ò
ÿ'/XG\m~ÿ!'{END}{DOWN}{DOWN}{DOWN} €& €' 
       €
 € €  
:ÿ'When you have seen the age, type and extra ò
ÿ'MONTH?)ÿ!'/Cestage2~~{END}{DOWN}{DOWN}{DOWN} €& €' 
 q q   €
 € €  òÿ'Month table: mthtable!ÿ'/XImonthdue=1~January~/XR~<ÿ!' The estimated fetal weight (EFW) is{DOWN}/Cefw~~ €& €' 
 q q   €
 € € 
ÿ

ÿ"ÿ'/XImonthdue=2~February~/XR~žÿ!'{EDIT}{CALC}{HOME}'{DOWN}grams (which is about{DOWN}/Clbwgt~~{EDIT}{CALC}{HOME}'{DOWN}pounds and {DOWN}/Cozwgt~~{EDIT}{CALC}{HOME}'{DOWN}ounces).{DOWN} €& €' 
ÿ
ÿÿ'/XImonthdue=3~March~/XR~bÿ!'/XIefw  € €  

ÿ
ÿÿ'/XImonthdue=4~April~/XR~Wÿ!'/XIefw>highefw~The estimated fetal weight indicated that the fetus is too large. €& €'     ñ ñ ñ   €
 € €  

ÿ
ÿÿ'/XImonthdue=5~May~/XR~Tÿ!'{UP}{END}{UP}/RJ{END}{DOWN}{RIGHT}{RIGHT}{RIGHT}{RIGHT}{RIGHT}{RIGHT}{RIGHT}~ €& €'     ñ ñ ñ   €
 € €  
 
ÿ
ÿÿ'/XImonthdue=6~June~/XR~ÿ!'{END}{DOWN}{DOWN}{DOWN} €& €'     ñ ñ ñ   €
 € €  
 
ÿ
ÿÿ'/XImonthdue=7~July~/XR~lÿ!'/Ccomment~~/RJ.{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{RIGHT}{RIGHT}{RIGHT}{RIGHT}{RIGHT}{RIGHT}{RIGHT}~ €& €'       €
 € €  
 
ÿ
ÿ ÿ'/XImonthdue=8~August~/XR~^ÿ!'{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{END}{UP}{DOWN}{DOWN} €& €'       €
 € €  
 
ÿ
ÿ#ÿ'/XImonthdue=9~September~/XR~ r 0ÿ!'/Cclosing~~{DOWN}{DOWN}{DOWN}{DOWN}{DOWN} €& €'        €
 € €  
 
ÿ
ÿ"ÿ'/XImonthdue=10~October~/XR~7ÿ!'{RIGHT}{RIGHT}{RIGHT}{RIGHT}/Coperator~~{EDIT} ~ €& €' €     €
 € €  

ÿ

ÿ#ÿ'/XImonthdue=11~November~/XR~Wÿ!'{GOTO}y35~/RNCletter~{BS}.{RIGHT}{RIGHT}{RIGHT}{RIGHT}{END}{DOWN}{RIGHT}{RIGHT}~ €& €' €     €
 € €  

ÿ
ÿ#ÿ'/XImonthdue=12~December~/XR~ÿ!'/Cpatname~nametitle~ €& €'        €
 € €  

ÿ
ÿÿ!'/PPCAAOHPatient: €& €'       €
 € €  
  !'Foucher ÿ#'!This line should remain! €& €'ÿ
' Sincerely yours, €   €
€ € 
   !ÿ 'Dummy range below:Monthdueÿ! '~ML1~~R80~OFQ €! !  ! €
! €! € ! 
! ! !ÿ!!'Rletter~GPQ/XG\m~ " " ò"!ÿ"" Examination performed on "'March 1, 1985. €
# €# € # q$ q$ $ $ $ €
$ €$ € $
ÿ$"Re:$'Foucher q% q% % % % €
% €% € % % % %'Adele & & & & & & &&'28 years old ' ' ' ',ÿ
(" The estimated gestational age is €( (  ( €
( €( € ( 
( ( ( ( (('To Dr Herodoteÿ
)9@
" ) ) ) )  ) €
) €) € ) 
),)'Please select one of the above option ) ) )ÿ
*'weeks and * *  * 
* * * * *!ÿ
+@


)
" + + + +  + €
+ €+ € + 
+ + + + +ÿ
,"days, based on the BPD. , , , ,  , €
, €, € , 
, , , , , €,,'Dear Dr Herodote, -  - 
- - - - - . . . .  . €
. €. € . 
. . / / / /  / €
/ €/ € / 
/ / / / / /Nÿ/' Thank you for refering to us Ms Foucher Adele who is currently 25 0 0 0 0  0 €
0 €0 € 0 
0ÿ0'weeks by dates.Jÿ
1' The estimated gestational age is 25 weeks and 4 days, based on 1  1 
1 1  1 
1Eÿ
2'the BPD. The expected due date based on the LMP June 13, 1985. €2 2  2 €
2 €2 € 2 
2Jÿ2' The estimated gestational age is 25 weeks and 4 days, based on °3 3  3 °
3 °3 ° 3 
3Eÿ3'the BPD. The expected due date based on the LMP June 13, 1985. 4 5 5 5 5Kÿ5' The estimated fetal weight (EFW) is 677 grams (which is about 1 6 6 6 6ÿ6'pounds and 8 ounces). 7 €7 7 8 8 8 8M8' This baby looks great, it size and weight are appropriate for its 9Jÿ9'age and no evidence of congenital malformations are seen. The fetal : : : : :'sexe is that of a female. : ; ; ; ; ; ; < < < < <ÿ<' Sincerely yours, < = = = = = = = = = > > > > > ? ? ? ? ?  ? @ @ @ @ @ @  @ 
@ €@ € @ @ @  @ A A A A A  A 
A €A € A A AA'Vesalius  A ‚B B ‚B  B ‚
B ‚B ‚ B 
B B B ‚C C  C 
C C C ñC r C D D E E €F F F €
F €F € F F F "F €G G G €
G €G € G G G H H €
H H H K K K K  K 
K MÿR' ÿS' ÿT' 
V W W X Y '[ '\ $] %] &] ^ #^ $^ %^ &^ _ '_ 
` ñ` '` ña !a #a $a %a ò&a 'a ñb #b $b %b &b ñc !c #c $c %c &c qd e ñf ñg 
h ñh 
i ñi 
j ñj 
k ñk 
l 
}