ࡱ > X j
! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F G H I J K L M N O P Q R S T U V W [ \ ] ^ _ ` a b c d e f g h i R F uY W o r k b o o k S u m m a r y I n f o r m a t i o n ( Z D o c u m e n t S u m m a r y I n f o r m a t i o n 8 @ \ p David Brown B a = = $a78 @ " 1 H Verdana1 H Verdana1 H Verdana1 H Verdana1 H Verdana1 Q H Verdana1 H Verdana1 H Verdana1 H Verdana1 = H Verdana1 Q H Verdana1 Q H Verdana "$"#,##0_);\("$"#,##0\) ! "$"#,##0_);[Red]\("$"#,##0\) " "$"#,##0.00_);\("$"#,##0.00\) ' " "$"#,##0.00_);[Red]\("$"#,##0.00\) 7 * 2 _("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_) . ) ) _(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_) ? , : _("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_) 6 + 1 _(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) + ) , *
( ( ( 8 d q: F c -2 NW g F SW c -2 NW g F SW ̙ ̙ 3f 3 f ff 3f 3f 3 33 3 3f 33 333 \ ` Sheet1 k Sheet2 Sheet3 !
;
߮ f^ f H ( @ Z R 3 @ @
Time Smoothed Protein Assay Smoothed cell count
Time steps dB/dt dV/dt Protein decay rate Protein smoothing parameter Cell count smoothing parameter Protein assay (B) Cell count (V) Inferred gene expression
}
|2l N 2C0 b & b& " e N N"
~ " e *< N N"
~ P T& ^ b Ur4b N# O & IJ / O e 9p O~Ȟ( pJ|& T
~v ^
~ U OJȿ0 4H@ UP H
~ OJȿ`
~J 0_Th @
{ _T` Xp ɥ JPP $ K N#M JPP
|2l
{ _T Xp ɒ N" B 0 hh H pN H ZH p N#0 JPPL
|2l N Z `
{ O ,w H
! ,w N O
|2 H
{
|2| N" JPP H
~J N Jp H P c c "
@ - =
d MbP?_ * + % o l &L
&CInferring Gene Expression from Reporter Protein Levels
Credit: David Brown and Phoebe Lostroh (2008)&R
M
com.apple.print.PageFormat.PMHorizontalRes
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMHorizontalRes
300
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2008-08-08T21:46:58Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMOrientation
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMOrientation
1
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2008-08-08T21:46:58Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMScaling
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMScaling
1
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2008-08-04T20:56:32Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMVerticalRes
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMVerticalRes
300
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2008-08-08T21:46:58Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMVerticalScaling
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMVerticalScaling
1
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2008-08-04T20:56:32Z
com.apple.print.ticket.stateFlag
0
com.apple.print.subTicket.paper_info_ticket
com.apple.print.PageFormat.PMAdjustedPageRect
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMAdjustedPageRect
0.0
0.0
3058.3333333333335
2400
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2008-08-08T21:46:58Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMAdjustedPaperRect
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMAdjustedPaperRect
-75
-75
3225.0000000000005
2475
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2008-08-08T21:46:58Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PaperInfo.PMPaperName
com.apple.print.ticket.creator
com.apple.print.pm.PostScript
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.PMPaperName
na-letter
com.apple.print.ticket.client
com.apple.print.pm.PostScript
com.apple.print.ticket.modDate
2003-07-01T17:49:36Z
com.apple.print.ticket.stateFlag
1
com.apple.print.PaperInfo.PMUnadjustedPageRect
com.apple.print.ticket.creator
com.apple.print.pm.PostScript
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.PMUnadjustedPageRect
0.0
0.0
734
576
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2008-08-04T20:56:32Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PaperInfo.PMUnadjustedPaperRect
com.apple.print.ticket.creator
com.apple.print.pm.PostScript
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.PMUnadjustedPaperRect
-18
-18
774
594
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2008-08-04T20:56:32Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PaperInfo.ppd.PMPaperName
com.apple.print.ticket.creator
com.apple.print.pm.PostScript
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.ppd.PMPaperName
US Letter
com.apple.print.ticket.client
com.apple.print.pm.PostScript
com.apple.print.ticket.modDate
2003-07-01T17:49:36Z
com.apple.print.ticket.stateFlag
1
com.apple.print.ticket.APIVersion
00.20
com.apple.print.ticket.privateLock
com.apple.print.ticket.type
com.apple.print.PaperInfoTicket
com.apple.print.ticket.APIVersion
00.20
com.apple.print.ticket.privateLock
com.apple.print.ticket.type
com.apple.print.PageFormatTicket
M z ,, ` g( H H ( d h " d ? ? U
} } m } m } }
} } I } I } } }
}
H |A rp .D iT tE p a 8
0 ? |A
0 0
? W2ġ? ? W2ġ? @ L L j ` L L L L L L@L@ L LL L@L @ {Gz? j ` L L L L L L@L@ L LL L@L @ @ [@ S㥛? W2ġ? @ ? S㥛? ?
l b LL LLL L L LL LL LL LL
i|?5?
l
b LL LLL L L LL LL LL LL 2M9? L , " L L L L L @ @ Dl? W2ġ? @ @ Dl? gfffff@
V-?
[Q)"@ @ 8@ oʡ? W2ġ? @ (@ oʡ? @
M?
ya),@ @ 4@ A@ W2ġ? @ B@ Q? @0@
.$?
DQu<@ $@ 2@ N@ W2ġ? @ 33333SS@ 333333? L1@
z&1?
<$4A@ (@ @ V-? W2ġ? @ 33333SZ@ V-? ffffff!@
~?5^I?
G6@ ,@ @ MbX? W2ġ? @ fffff\@ MbX? hfffff@
Q ?
enw&@
0@ \@
`"?
W2ġ?
@
\@
`"?
?
V-?
"{} @ 2@ @ V-? W2ġ? @
33333S]@
V-?
`fffff?
&1|?
V4@
4@ u@ Zd;? W2ġ? @ fffff^@ Zd;?
6@ u@
Zd;?
W2ġ?
" O T
` ( ltnc ltnc
j
0 N M ? : O - b ]
`
P# @ "
? ? 3 h
t h
t S3 d 2 3 P P PWZZ `}K @ G `}K @ @ @ @ C DG @PG@ GP < ` {W/ ^l((x(ȿ^|((x(Ƞ(D *JH =ʘ @G C D C DPuN Q ` `
H (D(D
H(D(D*JH Ռ? B]@H XH@B@H(x(Ƞ(D (x(Ƞ(D
(J(Ƞ(D*JHp^|((x(Ƞ(D *I ʘ H(D
(J(D *JI
ɐ*пI *Ƞ(H(D(D(I (D(D*IA I(DC0 (J(C0 (ȿ`,((x(Ƞ(D *JI(Ȑʘ *Ip
Ip(D *JJ
"d (6n (D (6n (D
I(D(D*JIпa I *d^|I 6n K * (x(Ƞ(D
(J(Ƞ(D*JJ `,((x(Ƞ(D *J ʘ J`
(J(D *JKp
"d ɐ*пKpbt* Ja((J(D(D*J@ JKC0 J( (C0 C0 (x(Ƞ(D (6n (Ƞ(D*K K `+
`+
#K@ l (6n (D ɐ*Kp *fontKpcd!p K *d`, 6n L * 6n L *^`( (*<
(J(DL6n K
ɐ*пL
"
"d
#
"
!
!
"
#<
"
#`
#
#
!
"
#
#
"@
!
"d (Ƞ(DC0 (x(Ƞ(D (6n (Ƞ(D*L PL sclrP8 A 6n (D 6n (D =
=
=
*dPstrk lg٢ sclr truefont !itran @ H H
H
^ǃ? 8pʠp.6$ }
0 P ( 8 5@ 8 P(D P 8 8 `+
`+
P`+
strk lg٢ strk lg٢ sclr true }
0 P @ H Ԍ ^ . 8 B " 8 " HԌ B H 8 8 >. 8 P P _ / "@H 8 HC@ =
=
=
P8 7> 8 P P . 8 > 8 " " `+
8 7>. 8 P uz 8 > 8 8 P/ B@"$ 8 " " `0 : ^ nb P8 ydy 8pʠ a pv
P8 P8 v-v-^ t!:c `0 8pʠ R xtx b R R
R R T T U U
N M S S 4 3 Q
Protein DataQ ; Q ; Q 3 _ c R R R R T T c U U
N M ] c c T T c c U U S S 4 E S S 4 3 Q
Inferred ExpressionQ ; Q ; Q 3 _ -2 R R R R T T -2 U U
N M ] -2 -2 T T -2 -2 U U S S 4 E S S 4 D
$ % M 3 O & Q 4 $ % M 3 O & Q 4 F A \ q R
3 O G ` 3 * # M 4 3 * # M ! R R R R T T U U S S 4 5 2 3 R R T T U U
N f N @ S S 4 3 d "
R R T T U U e
! i 3 O e
% M @ 3 O Q 4 2 3 R R R R T T U U
N M S S 4 S S 4 S S 4 S S 4 S S
4 e e e
0 q~
X P P ? " ] 4 @~
q~
p
9;+
X X
_ < ` Overview:
This worksheet carries out calculation of gene expression levels from reporter enzyme data. It implements the main model (non-GFP) of Brown and Lostroh (2008). Please consult the paper for details on the model's assumptions and interpretation of the output. The example "data" are model-generated and do not represent any specific gene.
< _px
0 r~
X P P ? " I #@ b ] 4 @~
r~
q
_o+
X X
lx < m Instructions:
1. In column A, enter the times at which data were collected (e.g. hours after innoculation). The time points do not need to be evenly spaced.
To allow for the "smoothing" of the data, it is necessary to create copies of the first and last data points and place them before and after the real data set.
In the example, the real data runs from t = 0 to t = 20. The first row of data is a copy of the first data point, shifted to an earlier time. The last row of data is a copy of the last data point, shifted to a later time. The times used in these extra data points should correspond to typical time steps in the actual data.
2. In column B, enter the data for reporter enzyme levels per cell (e.g. Miller units for beta-galactosidase). The first and last values in the column will be copies of the first and last values in the actual data.
3. In column C, enter the cell population data (e.g. OD600). These are relative values only. Include copies of the first and last values, as before.
4. In column D, enter the assumed in vivo decay rate of the reporter enzyme, in the same units as the time data (e.g. per hour). This may be constant or vary over time. The decay rate can be computed from the half-life H as: LN(2)/H
5. In columns E and F, enter the value of the smoothing parameters you wish to use. This must be between 0 and 1, inclusive. If the value is 0, no smoothing is done and the raw data is used. Larger values correspond to more aggressive smoothing, leveling off peaks and valleys.
6. Evaluate columns H-L to determine the inferred dynamics of the reporter protein synthesis. The units are: relative level of synthesis per unit time. Note that each expression estimate uses data from the previous and the next time step. Thus, there are no values computed for the first time or the last real time points (if computed, they are not meaningful).
< x E
a d o l L David Brown David Brown > @ d d @ 7 .
*
List1 Time ~ 4 Verdana d o @ pU }* im Protein assay (B) ~ 4 Verdana o @ pU }* ro in Cell count (V) ~ 4 Verdanaana o @ pU }* el co Protein decay rate ~ 4 Verdana o @ pU }* ro in Protein smoothing parameter ~ 4 Verdana o @ pU }* ro in Cell count smoothing parameter ~ 4 Verdana o @ pU }* el co
Time steps ~ 4 Verdanater ~ 4 Verdana o @ pU }* im st Smoothed protein assay ~ 4 Verdana Verdana o @ pU }* mo he Smoothed cell count ~ 4 Verdanaana Verdana o @ pU }* mo he dB/dt ~ 4 Verdana~ 4 Verdanaana Verdana o @ pU }* B/
@ dV/dt ~ 4 Verdana~ 4 Verdanaana Verdana o @ pU } Inferred gene expression ~ 4 Verdanaerdana o @ pU }* nf re
@
d MbP?_ * + % M
com.apple.print.PageFormat.PMHorizontalRes
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMHorizontalRes
300
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2008-08-08T21:39:31Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMOrientation
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMOrientation
1
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2008-08-08T21:39:31Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMScaling
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMScaling
1
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2008-08-04T20:56:32Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMVerticalRes
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMVerticalRes
300
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2008-08-08T21:39:31Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMVerticalScaling
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMVerticalScaling
1
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2008-08-04T20:56:32Z
com.apple.print.ticket.stateFlag
0
com.apple.print.subTicket.paper_info_ticket
com.apple.print.PageFormat.PMAdjustedPageRect
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMAdjustedPageRect
0.0
0.0
3058.3333333333335
2400
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2008-08-08T21:39:31Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMAdjustedPaperRect
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMAdjustedPaperRect
-75
-75
3225.0000000000005
2475
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2008-08-08T21:39:31Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PaperInfo.PMPaperName
com.apple.print.ticket.creator
com.apple.print.pm.PostScript
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.PMPaperName
na-letter
com.apple.print.ticket.client
com.apple.print.pm.PostScript
com.apple.print.ticket.modDate
2003-07-01T17:49:36Z
com.apple.print.ticket.stateFlag
1
com.apple.print.PaperInfo.PMUnadjustedPageRect
com.apple.print.ticket.creator
com.apple.print.pm.PostScript
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.PMUnadjustedPageRect
0.0
0.0
734
576
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2008-08-04T20:56:32Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PaperInfo.PMUnadjustedPaperRect
com.apple.print.ticket.creator
com.apple.print.pm.PostScript
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.PMUnadjustedPaperRect
-18
-18
774
594
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2008-08-04T20:56:32Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PaperInfo.ppd.PMPaperName
com.apple.print.ticket.creator
com.apple.print.pm.PostScript
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.ppd.PMPaperName
US Letter
com.apple.print.ticket.client
com.apple.print.pm.PostScript
com.apple.print.ticket.modDate
2003-07-01T17:49:36Z
com.apple.print.ticket.stateFlag
1
com.apple.print.ticket.APIVersion
00.20
com.apple.print.ticket.privateLock
com.apple.print.ticket.type
com.apple.print.PaperInfoTicket
com.apple.print.ticket.APIVersion
00.20
com.apple.print.ticket.privateLock
com.apple.print.ticket.type
com.apple.print.PageFormatTicket
M z ,, ` g( H H ( d h " d ? ? U
}
> @ d d @ 7
@
d MbP?_ * + % M
com.apple.print.PageFormat.PMHorizontalRes
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMHorizontalRes
300
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2008-08-08T21:39:31Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMOrientation
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMOrientation
1
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2008-08-08T21:39:31Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMScaling
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMScaling
1
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2008-08-04T20:56:32Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMVerticalRes
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMVerticalRes
300
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2008-08-08T21:39:31Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMVerticalScaling
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMVerticalScaling
1
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2008-08-04T20:56:32Z
com.apple.print.ticket.stateFlag
0
com.apple.print.subTicket.paper_info_ticket
com.apple.print.PageFormat.PMAdjustedPageRect
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMAdjustedPageRect
0.0
0.0
3058.3333333333335
2400
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2008-08-08T21:39:31Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMAdjustedPaperRect
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMAdjustedPaperRect
-75
-75
3225.0000000000005
2475
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2008-08-08T21:39:31Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PaperInfo.PMPaperName
com.apple.print.ticket.creator
com.apple.print.pm.PostScript
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.PMPaperName
na-letter
com.apple.print.ticket.client
com.apple.print.pm.PostScript
com.apple.print.ticket.modDate
2003-07-01T17:49:36Z
com.apple.print.ticket.stateFlag
1
com.apple.print.PaperInfo.PMUnadjustedPageRect
com.apple.print.ticket.creator
com.apple.print.pm.PostScript
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.PMUnadjustedPageRect
0.0
0.0
734
576
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2008-08-04T20:56:32Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PaperInfo.PMUnadjustedPaperRect
com.apple.print.ticket.creator
com.apple.print.pm.PostScript
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.PMUnadjustedPaperRect
-18
-18
774
594
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2008-08-04T20:56:32Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PaperInfo.ppd.PMPaperName
com.apple.print.ticket.creator
com.apple.print.pm.PostScript
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.ppd.PMPaperName
US Letter
com.apple.print.ticket.client
com.apple.print.pm.PostScript
com.apple.print.ticket.modDate
2003-07-01T17:49:36Z
com.apple.print.ticket.stateFlag
1
com.apple.print.ticket.APIVersion
00.20
com.apple.print.ticket.privateLock
com.apple.print.ticket.type
com.apple.print.PaperInfoTicket
com.apple.print.ticket.APIVersion
00.20
com.apple.print.ticket.privateLock
com.apple.print.ticket.type
com.apple.print.PageFormatTicket
M z ,, ` g( H H ( d h " d ? ? U
}
> @ d d @ 7
՜. +,0 P X x
' The Sheet1 Sheet2 Sheet3 Worksheets F Microsoft Excel Worksheet 8FIB Excel.Sheet.8
Oh +'0 l H P d x
' David Brown David Brown Microsoft Excel @ -ظ@ wrQN G PICT Q H H Q
Q H H mLm Q Q G { J{ !+{%L!K{ s{!+!K{%L!+!L{ s{ !K{ s{ b {wJ{!K%L{{!K!+s{ !L{{!K%Ls{!+!Ks{ f {wJ{%L!K!K{{%L%L!Ks{%L%L!+{{%L!K!Ks{ %Ls{ c: k|g9 # g9w w Jw w J r g9w gZo{wo{Vo{wo{c9sk{w Jww_Zcwo{VVwc9sk{w
skZo{wwo{wo{Vo{Vk{wc9w J x g9w
g:RRJSo{NB2RNVk{w JwwRwwNB3RVwVNVk{wJ ZNtRZVRVNRJso{NVk{Vw J { g9w
VwVRVkZZZVVc9g:w JwwVZcZZRVwVVg9g:wJ Z Vco{VVRRRRkZVc9g:Vw J ' g9w w Jw Jw w J ' g9w w Jw Jw w J o g9w o{so{sk{o{k{sw Jwk{wo{swwsk{wVo{wsVk{o{wk{o{k{w Jw wsk{wskZw J s g9w
_ JtZJt^_B2RZsw JRg9RRRg9kZNVk{No{wRVFsF3Ng9_B1w Jw NVo{RRk{w J q g9w N ZJt^JtNtJscNw JRZVRVNkZVc9g:VkZwRJtRZRZNtJtsw Jw c9g:VJto{w J 5 g9w wg9k{w Jw Jw wg9Vw J ' g9w w Jw Jw w J g9ZJSZskZo{wwo{w w g:RVg:^o{w wJwc9g:VwZZo{w w sw wJwso{ so{s k{wwo{Vo{w wwJ g9 %Lg9 wRVNRZVNF3o{w w wNRcwZw JwZwVcg:wZw wRZsw JwNVVB1Ng:_B1NtR VNB2JSo{w J g9 !+g9 wRVVck{VZZsw wNtZZw^w JwZwk{Bww^wg9NtwJwNNtFsJtRwNtJtRco{ Z^RkZw J h g9 !Lg9w wkZ w_sw JwkZg:w_sw wc9o{w JwZw w J A g9w w w wJw w wJw w wwJ g9 g9 g9 g9 !Kg9cF1{g9 ^R{g9 ^R{^R{o{Rg9^R{^R{g9F1w=cF1kZg9 g9 g9 !Kg9ckZJR{g9 Ro{g9g9 Ro{g9Ro{g9Rg9Ro{g9Ro{g9B{NsF1{Nsg9 g9 g9g9%L!Kg9F1JRwg9 ZNswg9 ZNsw^ZNswo{9g9ZNsw^ZNswcJRskZBwkZcg9 g9 3 g9 g9 g9 g9 g9 g9 g9 g9 g9 g9 !Lg9^R{g9 ^R{g9 ^R{^R{o{Rg9^R{^R{g9F1w=cF1kZg9 ^R{g9 g9 %Lg9Ro{g9g9 Ro{g9g9 Ro{g9Ro{g9Rg9Ro{g9Ro{g9B{NsF1{Nsg9 Ro{g9g9 g9 !Kg9ZNswg9 ZNswg9 ZNsw^ZNswo{9g9ZNsw^ZNswcJRskZBwkZcg9 Nswg9 3 g9 g9 g9 g9 g9 g9 Jg9 g9 g9 g9 !Kg9cF1{g9 o{Ro{Rg9!^R{^R{cF1{cF1kZg9^R{^R{g9F1w=cF1kZg9^R{ g9 g9g9%L%Lg9JR{g9 RRg9!Ro{g9Ro{g9JR{Nsg9Ro{g9Ro{g9B{NsF1{Nsg9Ro{g9 g9F1JRwg9
o{9^o{9g9!ZNsw^ZNswF1JRwkZcg9ZNsw^ZNswcJRskZBwkZcg9ZNswg9 1 g9 g9 g9 g9 g9g9 Jg9 g9 g9 g9 %Lg9=g9 cF1{RVwg9!^R{^R{cRZJRwg9^R{^R{g9F1w=cF1kZg9^R{g9 g9 !Kg9NsF1{g9 JR{^Nswg9!Ro{g9Ro{g9BNssNsJRcg9Ro{g9Ro{g9B{NsF1{Nsg9Ro{g9g9 g9 !Kg9kZBwg9 JRw^cJRsg9!ZNsw^ZNswRNso{o{F1{g9ZNsw^ZNswcJRskZBwkZcg9ZNswg9 - g9 g9 g9 g9 g9 g9 Jg9 g9 g9g9!Lg9cRg9 o{Rc {g9F1wg9!^R{o{RcRZJRwg9^R{^R{g9F1w=cF1kZg9^R{g9 g9g9!+!Lg9BNssg9
R {B{g9!Ro{g9RBNssNsJRcg9Ro{g9Ro{g9B{NsF1{Nsg9Ro{g9g9 g9g9!K%Lg9RNso{g9 o{9F1JR ^cJRsg9!ZNsw^o{9RNso{o{F1{g9ZNsw^ZNswcJRskZBwkZcg9ZNswg9 - g9 g9 g9 g9 g9 g9 Jg9 g9 g9 !Kg9ZNswg9 g9F1wcR o{Rg9!^R{g9F1wRVwRVwg9^R{^R{g9F1w=cF1kZg9^R{g9 g9 !Kg9Ns=wg9
B{BNss Rg9!Ro{g9B{^Nsw^Nswg9Ro{g9Ro{g9B{NsF1{Nsg9Ro{g9g9 g9NsRo{g9 cJRsRNso{^ 9g9!ZNsw^cJRscJRscJRsg9ZNsw^ZNswcJRskZBwkZcg9ZNswg9 - g9 g9 g9 g9 g9 g9 - g9 g9 g9 g9 g9 g9 g9 g9 g9g9!L%Lg9o{R^R{g9 cF1kZcF1kZg9F1 g9^R{cRg9^R{^R{g9F1w=cF1kZg9^R{g9 g9 !Kg9RRo{g9g9NsNsB g9 Ro{g9BNssg9Ro{g9Ro{g9B{NsF1{Nsg9Ro{g9g9 g9g9!+!K%Lg9o{9ZNswg9 kZckZc^cJRs g9 ZNsw^RNso{g9ZNsw^ZNswcJRskZBwkZcg9ZNswg9 ) g9 g9 g9 g9 g9 g9 g9 g9 g9g9!L!Kg9o{RcF1{g9o{R^R{RVwg9F1w !^R{ZNsw^R{g9F1wg9^R{^R{g9F1w=cF1kZg9^R{g9 g9g9!+g9!+g9RJR{g9RRo{g9^NswB{g9 !Ro{g9Ns=wRo{g9B{g9Ro{g9Ro{g9B{NsF1{Nsg9Ro{g9g9 g9 %Lg9o{9F1JRwg9o{9ZNswcJRs^cJRsg9 !ZNsw^NsRo{ZNswcJRsg9ZNsw^ZNswcJRskZBwkZcg9ZNswg9 ) g9 g9g9 g9 g9 g9 g9 g9 g9g9!Kg9!K!Kg9o{R=g9o{Ro{RcF1{o{Rg9 !^R{ZJRwo{RcF1kZg9^R{^R{g9F1w=cF1kZg9^R{g9 g9g9!Lg9%Lg9%Lg9RNsF1{g9RRJR{Rg9 !Ro{g9NsJRcRNsg9Ro{g9Ro{g9B{NsF1{Nsg9Ro{g9g9 g9g9%Lg9!K!+g9o{9kZBwg9o{9o{9F1JRw^o{9g9 !ZNsw^o{F1{o{9kZcg9ZNsw^ZNswcJRskZBwkZcg9ZNswg9 - g9 g9 g9 g9 g9 g9 g9 g9 g9g9%Lg9g9%Lg9o{RcRg9o{Ro{R=RVwg9$ ^R{ZJRwcRZNswg9^R{^R{g9F1w=cF1kZg9^R{g9 g9g9!Lg9g9%Lg9RBNssg9
RRNsF1{^Nswg9# Ro{g9NsJRcBNssNs=wg9Ro{g9Ro{g9B{NsF1{Nsg9Ro{g9g9 g9g9!Kg9g9!Kg9o{9RNso{g9o{9o{9kZBw^cJRsg9# ZNsw^o{F1{RNso{NsRo{g9ZNsw^ZNswcJRskZBwkZcg9ZNswg9 - g9 g9 g9 g9 g9 g9 g9 g9 g9g9!+g9g9!Kg9o{RZNswg9o{Ro{RcF1kZg9F1wg9! R{ZJRwZNswZNswg9^R{^R{g9F1w=cF1kZg9^R{g9 g9g9!Lg9g9%Lg9RNs=wg9RRNsB{g9! o{g9NsJRcNs=wNs=wg9Ro{g9Ro{g9B{NsF1{Nsg9Ro{g9g9 g9g9!+g9!+!Kg9o{9NsRo{g9o{9o{9kZc^cJRsg9!Z w^o{F1{NsRo{NsRo{g9ZNsw^ZNswcJRskZBwkZcg9ZNswg9 - g9 g9 g9 g9 g9 g9 g9 g9 g9g9!Kg9g9%Lg9cF1{^R{g9o{RcF1{^R{o{Rg9!^R ZJRwZJRwcRg9^R{^R{g9F1w=cF1kZg9^R{g9 a_ C o m p O b j X