ࡱ > `
! " # $ % & ' ( ) * + , - . / 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 X Y Z [ \ ] ^ _ a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~ R F ? W o r k b o o k N! S u m m a r y I n f o r m a t i o n ( D 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 "7 \ p
James Lyndsay B a = = x FH08 X@ " 1 i Geneva1 i Geneva1 i Geneva1 i Geneva1 i Geneva1 7 i Geneva1 i Geneva1 i Geneva1 i Geneva1
i Geneva1 i Geneva1 i Geneva1 i Geneva1 $ i Geneva1 i Geneva1
i Geneva ""#,##0;\-""#,##0 ""#,##0;[Red]\-""#,##0 ""#,##0.00;\-""#,##0.00 # ""#,##0.00;[Red]\-""#,##0.00 5 * 0 _-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_- , ) ' _-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_- = , 8 _-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_- 4 + / _-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_- " "#,##0;\-" "#,##0 " "#,##0;[Red]\-" "#,##0 " "#,##0.00;\-" "#,##0.00 % " "#,##0.00;[Red]\-" "#,##0.00 8 3 _-" "* #,##0_-;\-" "* #,##0_-;_-" "* "-"_-;_-@_- @ ; _-" "* #,##0.00_-;\-" "* #,##0.00_-;_-" "* "-"??_-;_-@_- "$"#,##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\);_(* "-"??_);_(@_) 0.0
d/m/yyyy dddd + )
@ + @ - @ * @ ) H - @ - H + ` @ + @ ` @ - h @ - ( X + ( ( X -
# H ) # P ) H * # P * H + # P + @ 7 D + H * H ) H + L + # p @ * + - # - # @ - ( ) ) @ ) + \ * # T * # t @ * ` - @ @ @ H # # P # T D * H - H + # T + ) X * # X + ( 8 d q: F 3f f f f ̙ ̙ 3f 3 f ff 3f 3f 3 33 3 3f 33 333 \ ` z4 List Pq
Scheduling
Stats
Check Y Instructions
Flaws License !
;
% Actual_cost;
$
bug_status; p & date_planned;
day_1: day_2: day_3: & divider_area; ( Estimated_cost;
fcost; Fix_retest_status ! ID_list;
prob; " rep_date; p ) Ret_Actual_cost;
* Ret_date_planned;
, Ret_Estimated_cost; % Ret_ID_list; " Ret_risk; $
Ret_Status; $
Ret_t_name; Retest_cost risk;
sane: Status;
t_name;
& tester_names; " version: z @ 3 @ @
" This is a work in progress, and will be buggy. It won't fit your needs, or expectations - it's up to you to take control of it and make it your own. I'd very much like to hear about where you take it. You are welcome to use it for any purpose, but not to sell it. This information should always be included in any redistibution. Distributed under the Creative Commons Attribution-Share Alike 2.5 License. There are no warranties made.7 License: http://creativecommons.org/licenses/by-sa/2.5/ My contact details:
James Lyndsay& Email: jdl@workroom-productions.com AIM/Skype: workroomprds Tel: +44 (0) 20 7372 6986 Mobile: +44 (0) 7904 158 752 Retests VF-136-01 Smoke) This implementation has many known flaws; Easy to get the arrays wrong: (currently) no re-schedule, no link from failure to retest Tester 1 Tester 2 Tester 3 Tester 5 Tester 4 Tester 6 Tester 7 Tester 8 VF-136-29
View files File perm Loginout
Usability Performance QC Test / Test Group ID Blanks in riskK Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License Completed Tests All retests CInstall App Maint =IF(AND(fcost="H", prob="H"),"H",IF(OR(AND(fcost="H", prob="L"),AND(fcost="L", prob="H")), "M", IF(AND(fcost="L", prob="L"), "L", "")))' Heading / area Many Blanks in status
Mult Users
Functionality Rows with all blank pick from list ? Calc or pick hours pick ? Doc edit %Done %Successful1 No longer used - fixes not linked to failed tests Planned retests Sanity check( Number of failed tests without fix entry/ Number of planned tests without estimated costs Cacheing
Compliance> =SUM(IF(Status="Done - passed",1)*IF(Fix_retest_status<>"",1)) % planned tests complete
Compatible
Validation
IV-E136-01 Description/instructions1 Check for left out / unplanned with date / tester M Est. Est. time for these left total) Number of done tests without actual costs Hours spent No. fixed not tested SkypeIn: +44 (0) 20 7871 9675 (please call this number if you know I am away from the landline, and it you be put through to me via Skype)P Visit http://www.workroom-productions.com for papers, recorded talks and tools. ! Workroom Productions Ltd., London Best place to start (according to me, without a clue about who you the reader might be): look at the arrays set up in the List sheet. Look at the ways those lists are used - find out about array formulae if you haven't already. Add a set of sessions, play with their costs, risks, statuses and scheduled dates. Observe related changes in other sheets. Fix bugs. Work out what's going on with the check sheet. Use to manage a few days work. Fix other bugs. Share the sheet, help team members to update the list themselves, put the stats onto a dedicated monitor for real-time metrics. Fix bugs. Talk to me (James) at any time during the process.z Typical use: Fill in 'Lists' with charters. Update charters when sessions are complete. Add to charters when new tests arrive. In this version, VF tests (exploration to verify fix) are treated separately in stats and in list (suggest that new users don't work with these until familiar). Share workbook (may cause crashes, so backup automatically every few hours), display the 'stats' page on a monitor for real-time metrics. Make a new version of whole spreadsheet for new release.e Four families (old/new/investigatory/verify fix) - not treated consistentenly - VF is a speacial caseA Can't (reliably) be used by more than one person at the same time No history+notes Test session repeat / test point - impossible to properly express one charter (test point) done many times in different sessions. Can't cope with session done by many testers0 Finally - I no longer have a list of known bugs! Scheduling is experimental2 Data load to create test data is currently missing total hours Change Wd Combinea =SUM((IF(Status="Done - passed",0,1)*IF(Status="Done - failed",0,1)*IF(Fix_retest_status<>"",1)))= =SUM(IF(Status="Done - failed",1)*IF(Fix_retest_status="",1)) Hours scheduled Blanks in ID Successfully fixed Lock Doc view Word 2 LD Files Who Date planned Status Actual cost planned in progress
done - failed
done - passed left out this time Post-test new guess Recovery Failure Admin Sinstall Today TomorrowQ Important arrays in list: Status, Estimated_cost, Actual_cost, Risk, date_planned This spreadhseet helps you manage test charters (test points) and test sessions. Working from a list of sessions, it allows you to record work and calculates statistics. Are the figures reliable?* Number of sucessful tests with a fix entry+ Number of unfinished tests with cost logged* Number of unfinished tests with fix logged n/a Actual All tests
Planned testsf Uses lots of array formulae - you'll need to understand how these work to be able to modify the sheet.
- Picklists used for testers, state of planningh Named arrays are used - to ensure named arry covers right area, add above the grey area called 'divider'( days away (change this to look forwards) !Experimental! Cost is in hoursb Use autofilters for common enquiries - ie high-risk tests, long tests, tests by particilar tester.@ Use status bar to give counts, sums, max etc. of selected rangesd Take status from pick list - assign your own meaning / add others. Remember to check on stats sheet.
bugs found number done Estimated Time number
Boundaries Volume H Time taken so far
Completion
Fix tested Pre-test estimate of time Estimated cost Version No. failed tests5 Verify fix for #72: Description for bug #72 goes here7 Verify fix for #322: Description for bug #322 goes here6 Give test sessions a meaningful ID to help auto-filter Generally top-down1 Fill in Cost/Likelihood, and Risk is done for you Don't take anything in this for granted -it's a work in progress, it has flaws and bugs, be responsible for your own implementation Bug reports to: UniqueID-GEN-01 UniqueID-GEN-02 UniqueID-GEN-03 UniqueID-GEN-04 UniqueID-GEN-05 Description-0001 Description-0002 Description-0003 Description-0004 Description-0005 General new user exploration L FC Risk not ready James High risk Med risk Low risk Number Hours Total
Successful Worksheets: List contatins the list of tests, stats shows a summary of the state of testing, scheduling shows summary of who's doing what, and check contains internal consistency checks . 3 ] g K m b u S d o| < #
7% /& & & `( * { o+ + - , 7 - ]~. . 3 z 3@y ~ |v$| npп z yz 2_ ߜ z z z 9 ~ x Yv p+u9t` zxpz z vip Y0 p+u9t r s i o n n a m e s d _ c o @ ZK \
d , 2pu90 " {n}jX ߜ ZK @
d P , 2{nؿ@0 \H"`ip {n~ x x n1 jX|0 ߜ ~ 8 P ZKp&p 0 uR ip 0 @ƺ` P uR P~ p&px x ZK njXip @ ~X yzxn " {n}jX| ߜ ~ yz L8 ip Y Z ? V 9
"7 2 S ce g
d MbP?_ * + % M
com.apple.print.PageFormat.FormattingPrinter
com.apple.print.ticket.creator
com.epson.printer.SP750
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.FormattingPrinter
SP 750
com.apple.print.ticket.client
com.epson.printer.SP750
com.apple.print.ticket.modDate
2002-06-28T11:13:06Z
com.apple.print.ticket.stateFlag
1
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
2006-10-02T15:18:25Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMOrientation
com.apple.print.ticket.creator
com.epson.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMOrientation
2
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2006-10-02T15:18:25Z
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
2002-06-20T19:11:58Z
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
2006-10-02T15:18:25Z
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
2002-06-20T19:11:58Z
com.apple.print.ticket.stateFlag
0
com.apple.print.subTicket.paper_info_ticket
com.apple.print.PageFormat.PMAdjustedPageRect
com.apple.print.ticket.creator
com.epson.printer.SP750
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMAdjustedPageRect
0.0
0.0
2404.166666666667
3300.0000000000005
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2006-10-02T15:18:25Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMAdjustedPaperRect
com.apple.print.ticket.creator
com.epson.printer.SP750
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMAdjustedPaperRect
-38.333333333333485
-37.5
2441.666666666667
3470
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2006-10-02T15:18:25Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PaperInfo.PMPaperName
com.apple.print.ticket.creator
com.epson.printer.SP750
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.PMPaperName
iso-a4
com.apple.print.ticket.client
com.epson.printer.SP750
com.apple.print.ticket.modDate
2002-06-28T11:15:46Z
com.apple.print.ticket.stateFlag
1
com.apple.print.PaperInfo.PMUnadjustedPageRect
com.apple.print.ticket.creator
com.epson.printer.SP750
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.PMUnadjustedPageRect
0.0
0.0
792
577
com.apple.print.ticket.client
com.epson.printer.SP750
com.apple.print.ticket.modDate
2002-06-28T11:15:46Z
com.apple.print.ticket.stateFlag
1
com.apple.print.PaperInfo.PMUnadjustedPaperRect
com.apple.print.ticket.creator
com.epson.printer.SP750
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.PMUnadjustedPaperRect
-9
-9
832.79999999999995
586.20000000000005
com.apple.print.ticket.client
com.epson.printer.SP750
com.apple.print.ticket.modDate
2002-06-28T11:15:46Z
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 ,, e
e{ H H ( d h " R ? ? U
} U }
} U } } - } U } } U } *: }
. }
A } }
= } 2 # . k Л 0H
h k .m l@ eg mB h h $ B .m l@ `
o .
" &
"
$
$ @
$
$
$
9
T b
@ c
< d
< e
Z ?
C
H @ C
H B$ H C
H @ C
L B$ C
L @ C
H B$ B% @ MF C
L @ C
L B$ @ L @ @ " " B M~
: ?
. ~
A `S@
= f
Z
Z M~
: ?
. ~
A `S@
= f
@Z H~
: @
. ~
A @S@
= i ~
= @
pZ M~
: ?
. ~
A S@
= f
Z H~
: @
. ~
A `S@
= f
КZ
?
P
ЛZ C
H @ C
H B$ H C
H @ C
L B$ C
L @ C
H B$ B% @ MF C
L @ C
L B$ @ L @ @ " " B H~
: ?
.
A `S@? `@
= f
G G I I J J I K L M
N N
P
Z M~
: ?
. ~
A `S@
= f
P
Z C
H @ C
H B$ H C
H @ C
L B$ C
L @ C
H B$ B% @ MF C
L @ C
L B$ @ L @ @ " " B M~
: ?
. ~
A `S@
= f Z
C
H @ C
H B$ H C
H @ C
L B$ C
L @ C
H B$ B% @ MF C
L @ C
L B$ @ L @ @ " " B Z C
H @ C
H B$ H C
H @ C
L B$ C
L @ C
H B$ B% @ MF C
L @ C
L B$ @ L @ @ " " B Z C
H @ C
H B$ H C
H @ C
L B$ C
L @ C
H B$ B% @ MF C
L @ C
L B$ @ L @ @ " " B Z C
H @ C
H B$ H C
H @ C
L B$ C
L @ C
H B$ B% @ MF C
L @ C
L B$ @ L @ @ " " B
E %
! ! ; 8 B
> >
,
,
-
: .
. /
A 0
= ,
*
.
=
1
.
= f
^
>
.
= j
_
.
= g
`
.
= h
a
.
= i
.
.
. @ D v- - ]6 U 6 b 8 8 8 8 8 * !
# "
. #
$
k %
&
'
Л (
)
*
0 H +
h ,
k -
.m l@ 1 eg mB
!
! .
" W
" . '
# "
$ #
% =
& X
' )
( l
) m
* n
+ o
, 9
- :
- $
1 %
h (
R
C ] F ! Z P d
Z R
C ] F ! Z d
Z R
C ] F ! Z d
Z R
C ] F ! Z d
Z R
C ] F ! Z d
Z R
C ] F ! Z @ d
Z R
C
] F ! Z p d
Z R
C
] F ! Z d
Z R
C ] F ! Z Ь d
Z R
C
] F ! Z d
Z R
C
] F ! Z 0 d
Z R
C
] F ! Z ` d
A > @ @ A
@ ?
7 / % - / % / % # / %
"7 r w
d MbP?_ * + % " ? ? U
} } } @ 31 5 C @ p ]
C ]
p 0 6 p
p
q
6 C @@ A ~
@
y
[ ? @@ D ? `@ D ! ? @ D D
V
Y
Z Tester 1 ! c c d b c c b c c d b c c b ! c c d b c c b c c d b c c b ! c c d b c c b c c d b c c b !W I c c d b c c d b B !K = c d " c d " A ! c d b c
done - passed b c
done - failed b c d b c
done - passed b c
done - failed b ! c c d b c
done - passed b c
done - failed b `c c d b c
done - passed b c
done - failed b |
!
c c d b c
done - passed b c
done - failed b c c d b c
done - passed b c
done - failed b p pZ
Z Tester 2 ! c c d b c c b c c d b c c b ! c c d b c c b c c d b c c b ! c c d b c c b c c d b c c b !W I c c d b c c d b B !K = c d " c d " A ! c d b c
done - passed b c
done - failed b c d b c
done - passed b c
done - failed b ! c c d b c
done - passed b c
done - failed b `c c d b c
done - passed b c
done - failed b |
!
c c d b c
done - passed b c
done - failed b c c d b c
done - passed b c
done - failed b p Z
Z Tester 3 ! c c d b c c b c c d b c c b ! c c d b c c b c c d b c c b ! c c d b c c b c c d b c c b ? !W I c c d b c c d b B ? !K = c d " c d " A ! c d b c
done - passed b c
done - failed b c d b c
done - passed b c
done - failed b ! c c d b c
done - passed b c
done - failed b `c c d b c
done - passed b c
done - failed b |
!
c c d b c
done - passed b c
done - failed b c c d b c
done - passed b c
done - failed b p Z
Z James
! c c d b c c b c c d b c c b
! c c d b c c b c c d b c c b
! c c d b c c b c c d b c c b @
!W I c c d b c c d b B @
!K = c d " c d " A
! c d b c
done - passed b c
done - failed b c d b c
done - passed b c
done - failed b
! c c d b c
done - passed b c
done - failed b `c c d b c
done - passed b c
done - failed b |
!
c c d b c
done - passed b c
done - failed b c c d b c
done - passed b c
done - failed b p
Z
Z Tester 4
!
c c d
b c c b c c d
b c c b
!
c c d
b c c b c c d
b c c b
!
c c d
b c c b c c d
b c c b
!W
I c c d
b c c d
b B
!K
= c d
" c d
" A
!
c d
b c
done - passed b c
done - failed b c d
b c
done - passed b c
done - failed b
!
c c d
b c
done - passed b c
done - failed b `c c d
b c
done - passed b c
done - failed b |
!
c c d
b c
done - passed b c
done - failed b c c d
b c
done - passed b c
done - failed b p
D @[
Z Tester 5 D ! c c d b c c b c c d b c c b D ! c c d b c c b c c d b c c b D ! c c d b c c b c c d b c c b D !W I c c d b c c d b B D !K = c d " c d " A D D ! c d b c
done - passed b c
done - failed b c d b c
done - passed b c
done - failed b D ! c c d b c
done - passed b c
done - failed b `c c d b c
done - passed b c
done - failed b |
D
!
c c d b c
done - passed b c
done - failed b c c d b c
done - passed b c
done - failed b p D D [
Z Tester 5 D
! c c d b c c b c c d b c c b D
! c c d b c c b c c d b c c b D
! c c d b c c b c c d b c c b D
!W I c c d b c c d b B D
!K = c d " c d " A D D
! c d b c
done - passed b c
done - failed b c d b c
done - passed b c
done - failed b D
! c c d b c
done - passed b c
done - failed b `c c d b c
done - passed b c
done - failed b |
D
!
c c d b c
done - passed b c
done - failed b c c d b c
done - passed b c
done - failed b p D
D @[
Z Tester 6
D
!
c c d
b c c b c c d
b c c b
D
!
c c d
b c c b c c d
b c c b
D
!
c c d
b c c b c c d
b c c b
D
!W
I c c d
b c c d
b B
D
!K
= c d
" c d
" A
D
D
!
c d
b c
done - passed b c
done - failed b c d
b c
done - passed b c
done - failed b
D
!
c c d
b c
done - passed b c
done - failed b `c c d
b c
done - passed b c
done - failed b |
D
!
c c d
b c
done - passed b c
done - failed b c c d
b c
done - passed b c
done - failed b p
D D [
Z Tester 7 D ! c c d b c c b c c d b c c b D ! c c d b c c b c c d b c c b D ! c c d b c c b c c d b c c b D @ !W I c c d b c c d b B D @ !K = c d " c d " A D D ? ! c d b c
done - passed b c
done - failed b c d b c
done - passed b c
done - failed b D @ ! c c d b c
done - passed b c
done - failed b `c c d b c
done - passed b c
done - failed b |
D @
!
c c d b c
done - passed b c
done - failed b c c d b c
done - passed b c
done - failed b p D D @#[
Z ! Tester 8 D ! c c d b c c b c c d b c c b D ! c c d b c c b c c d b c c b D ! c c d b c c b c c d b c c b D !W I c c d b c c d b B D !K = c d " c d " A D D ! c d b c
done - passed b c
done - failed b c d b c
done - passed b c
done - failed b D ! c c d b c
done - passed b c
done - failed b `c c d b c
done - passed b c
done - failed b |
D
!
c c d b c
done - passed b c
done - failed b c c d b c
done - passed b c
done - failed b p D D Z
Z " Many D ! c c d b c c b c c d b c c b D ! c c d b c c b c c d b c c b D ! c c d b c c b c c d b c c b D !W I c c d b c c d b B D !K = c d " c d " A D D ! c d b c
done - passed b c
done - failed b c d b c
done - passed b c
done - failed b D ! c c d b c
done - passed b c
done - failed b `c c d b c
done - passed b c
done - failed b |
D
!
c c d b c
done - passed b c
done - failed b c c d b c
done - passed b c
done - failed b p D
D D " #I 8 K lllillllllh> @ @ 7
"7 )
d MbP?_ * + % " ? ? U
} } } ) @ 5 @ ] 0
@ H
0R @ * @ w#) > % `3[ ( We are D d A
% complete We are 17% complete % 4[ ( D : 3 We have not completed a test sucessfully first time= D d A # % of our tests have been successful B ) & 100% of our tests have been successful i % p5[ S We think we have D D
A D A B hours left! We think we have 12 hours left
!7 ) c
done - failed " 7
I
@
!c U D c
done - passed b c
done - failed b
<
2 UUUUUU? D
! @ D D
D
@
!
c c
done - passed b c
done - failed b c c
done - passed b c
done - failed b
F
E
!
0 *@
D D !
U "@ D
D
Q k Q H S 0@ 2 D
n/a D
D D
B @ S '@ * D
n/a D D B
- z -
+ { +
- -
+
/ /
, C
. y
2
3
.
.
,
,
.
. H
,
0
0
1 3 @ !1 # c
" 3 '@ !0 " c b c ` 4 @ ! ~ c
b c not ready
b c left out this time
b 4 '@ ! c
b c not ready
b c left out this time
b c "` 3 ? !^
P c
done - passed b c
done - failed b 3 @ !d V c c
done - passed b c
done - failed b 4 ? !7 ) c
done - passed " 6 @
7 UUUUUU? * D D D
n/a B @ 7 ? * D D D
n/a B
1 @ !3 % c d
" :; "@ !5 ' c d #
" D @ ! c d b c
b c not ready
b c left out this time
b "@ ! c d b c
b c not ready
b c left out this time
b c ? !y k c d b c
done - passed b c
done - failed b x O @ ! q c d b c c
done - passed b c
done - failed b ?
!R D c d b c
done - passed b @
2 UUUUUU? * D D D
n/a B @ 2 ? * D D D
n/a B
B
1 @ !3 % c d
" :; @ !5 ' c d #
" D @ ! c d b c
b c not ready
b c left out this time
b @ ! c d b c
b c not ready
b c left out this time
b c !y k c d b c
done - passed b c
done - failed b x O ! q c d b c c
done - passed b c
done - failed b
!R D c d b c
done - passed b @
2 * D D D
n/a B @ 2 Y * D D D
n/a B n/a
1 !3 % c d
" :; !5 ' c d #
" D ! c d b c
b c not ready
b c left out this time
b ! c d b c
b c not ready
b c left out this time
b c !y k c d b c
done - passed b c
done - failed b x O ! q c d b c c
done - passed b c
done - failed b
!R D c d b c
done - passed b @
2 * D D D
n/a B n/a @ 2 P ( * D D D
n/a B n/a
- ! -
+ 5 +
- -
+ ]
/ 5
. y
2
3
.
.
,
,
.
. H
, (
0
0
1 3 @ !1 # c
" s` 3 ? !0 " c b c ` 4 @ ! ~ c
b c not ready
b c left out this time
b p 4 ? !
c
b c not ready
b c left out this time
b c 3 !^ P c
done - passed b c
done - failed b ` 3 !d V c c
done - passed b c
done - failed b 4 !7 ) c
done - passed " 6 @
7 * D D D
n/a B @ 7 T
* D D D
n/a B n/a 2 \ v ; A * b n \ ~
n H " @ ( 5 " ' T C Yes + @ The spreadsheet looks consistentH @ : The spreadsheet is inconsistent - don't trust the figures! B # The spreadsheet looks consistent ( ( ( !1 ( ( ( # c
"
( x ( ( ( !Z ( ( ( L c
b c not ready
b
( x ( ( ( !^ ( ( ( P c
done - passed b c
done - failed b ( ( ( !d ( ( V c c
done - passed b c
done - failed b DD ( (
( !7 ( ( ( ) c
done - passed " @ (
2 ( * D( D( D(
n/a B @ ( 2 " * D( D( D(
n/a B P H 0 (
> @ @ 7
"7 R
d MbP?_ * + % " ? ? U
} + }
@ 5 @ ] 0 @
H 0 R *
w# )
& 6
\ @ !* c " ! D D T 2 ( L @ Help!
B
( @ !* c " ! D D T
@ !* c " ! D D T
+ @ !q c c
b c
b c
b 2 T (
6 T
\ @ !* c " ! D D
pT
( @ !* c " ! D D
0T
@
!* c " ! D D
@
+
@
!q
c c
b c
b c
b `
( @ p
8 !t f c
b c not ready
b c b !t f c
b c not ready
b c b K @ 5 D D B% @ Help!
B
G !x j c
Done - passed b c
Done - failed b c b Q6 !x j c
Done - passed b c
Done - failed b c b K 0 5 D D B% @ Help!
B
v ! w c
Done - passed
b c
Done - failed
b c b T: ! w c
Done - passed
b c
Done - failed
b c b K T 5 D D B% @ Help!
B
t T !N @ % % @ No!! @ Yes B Yes
A
u > T ( D @ Help!
B
4
F ;
7 > @T
( D @ Help!
B
4
F Z
w > T ( D @ Help!
B
4
F Y
~
D@ . Q - l l l > @ @ 7
"7 0 2 &
d MbP?_ * + % M
com.apple.print.PageFormat.BackupPrintRecord
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.BackupPrintRecord
AAMAAABIAEgAAAAAAzICPP/2//UDQAJIA2cFewPgAAIA
AABIAEgAAAAAAtgCKAABAAAAZAAAAAEAAwMDAP8AAScP
AAEAAQAAAAAAAAAAAAAAAGAIABkBkAAAAAAAIAAAAAAA
AAAAAAEAAAAAAAAAAAAAAAAAAAAAZ3JvdwABAABAAAAA
AAAAA29ybnQAAAABQAAAAAAAAARwcG5mAAAAAUAAAAAA
AAAScHNudAAAAAFAAAAAAAAACgAAAGYAAAABAJwAAAAD
AkE0dAAAAFQAAkE0AAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAACODIRKUCIACEgAqKA4CjEuGAyE
SmAAi9GQAAAAAAAAABkAAAAZClVSygAAAAA=
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2001-02-05T15:36:52Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.FormattingPrinter
com.apple.print.ticket.creator
com.epson.printer.SP750
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.FormattingPrinter
SP 750
com.apple.print.ticket.client
com.epson.printer.SP750
com.apple.print.ticket.modDate
2002-12-18T18:23:07Z
com.apple.print.ticket.stateFlag
1
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
2006-10-02T16:27:36Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMOrientation
com.apple.print.ticket.creator
com.epson.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
2006-10-02T16:27:36Z
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
2005-12-21T18:18:18Z
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
2006-10-02T16:27:36Z
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
2005-12-21T18:18:18Z
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
3299.9999491373701
2404.1667175292969
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2006-10-02T16:27:36Z
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
-37.5
-37.5
3469.9999491373701
2442.5000508626304
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2006-10-02T16:27:36Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PaperInfo.PMCustomPaper
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.PMCustomPaper
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2005-12-21T18:18:18Z
com.apple.print.ticket.stateFlag
1
com.apple.print.PaperInfo.PMPaperName
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.PMPaperName
iso-a4
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2005-12-21T18:18:18Z
com.apple.print.ticket.stateFlag
1
com.apple.print.PaperInfo.PMUnadjustedPageRect
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.PMUnadjustedPageRect
0.0
0.0
791.9999877929688
577.0000122070312
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2005-12-21T18:18:18Z
com.apple.print.ticket.stateFlag
1
com.apple.print.PaperInfo.PMUnadjustedPaperRect
com.apple.print.ticket.creator
com.apple.printingma< snager
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.PMUnadjustedPaperRect
-9
-9
832.79998779296875
586.20001220703125
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2005-12-21T18:18:18Z
com.apple.print.ticket.stateFlag
1
com.apple.print.PaperInfo.ppd.PMPaperName
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.ppd.PMPaperName
iso-a4
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2005-12-21T18:18:18Z
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 ,, e
g{ H H ( d h " d ? ? U
} jV 0 @ 0 D
03 03 03 ` 03 p
V s
V
V M
V
V N
V r
V |
V
V
V
V }
V ~
V
V
V
V $ . , ! # % & ' 0 ) D * + 03 , - 03 /
! V
# V
% V
& V
' V L
) V
* V
+ V
, V
- V J
/ V K v > @ @ 1 1 1
"7 B
d MbP?_ * + % " ? ? U
F 0 @
H
R
O
P
Q
T
U
S T > @ @
"7 !
d MbP?_ * + % " ? ? U
" > @ @
Oh +'0 h p |
' James Lyndsay x James Lyndsay x Microsoft Excel @ 2 @ @ s
՜. +,D ՜. +, L ` h t
' ' WO WO Workroom Productions Ltd. co List Scheduling Stats Check
Instructions Flaws License Worksheets P : B _PID_LINKBASE ' A F Microsoft Excel Worksheet 8FIB Excel.Sheet.8 C o m p O b j X