Re: Oooooooooops! (Just Spotted Your Excel Document, Mike
Posted: Thu Mar 30, 2000 2:34 pm
OK. Here is the latest version of the spreadsheet as requested by 'In the
slow lane'
pasted unamended from spreadsheet to e-mail.
NAME TYPE CHASSIS BODY BODY SERIAL NUMBER MONTH YEAR
ADJUSTED DIFF1 DIFF2 SUFFIX SPLIT BUILD HYPO
PREFIX CODE SUFFIX CHASSIS (MONTH) (BAL)
MONTH DIFF
fitz TA 2070 B270 900 7183 2 38 820 -80 20
TA 2361 B270 1201 8215 4 38 1111 -90 10
woodson TC 556 B280 405 A 1306 3 46 305 -100 0 1 306 7 6
wescott TC 3387 B280 3209 A 16710 8 47 3136 -73 27 16
710 24 8
terryVP TC 3452 B280 3263 A 16840 9 47 3201 -62 38 16
840 25 9
grunau TC 5054 B280 4829 A 29990 4 48 4803 -26 74 29
990 32 3
norris TC 5221 B280 4996 A 31162 4 48 4970 -26 74 31
162 32 1
old TC 6710 B280 6484 A 32487 10 48 6459 -25 75 32 487
38 6
fritz TC 6756 B280 6530 A 32534 10 48 6505 -25 75 32
534 38 6
tc48td50 TC 6768 B280 6542 A 32557 10 48 6517 -25 75
32 557 38 6
shade TC 7344 B280 7116 A 33101 12 48 7093 -23 77 33
101 40 7
hill TC 7387 B280 7159 A 33167 12 48 7136 -23 77 33
167 40 7
tabbert TC 7538 B280 7310 A 33339 1 49 7287 -23 77 33
339 41 8
barker TC 7934 B280 7706 A 33356 2 49 7683 -23 77 33
356 42 9
barker TC 7992 B280 7764 A 37944 2 49 7741 -23 77 37
944 42 5
barker TC 8007 B280 7779 A 38148 2 49 7756 -23 77 38
148 42 4
mccombs TC 8126 B280 7895 A 38224 3 49 7875 -20 80 38
224 43 5
oldfield TC 8343 B280 8110 A 38253 4 49 8092 -18 82
38 253 44 6
franks TC 8332 B280 8099 A 38421 3 49 8081 -18 82 38
421 43 5
grunau TC 8654 B280 8421 A 38745 5 49 8403 -18 82 38
745 45 7
sherrell TC 9491 B280 9240 A 39102 8 49 9240 0 100
39 102 48 9
grunau TC 5573 B280 5348 A 29971 5 48 5322 -26 74 29
971 33 4 plate not on car
You can copy this straight into your own spreadsheet.
Mike
slow lane'
pasted unamended from spreadsheet to e-mail.
NAME TYPE CHASSIS BODY BODY SERIAL NUMBER MONTH YEAR
ADJUSTED DIFF1 DIFF2 SUFFIX SPLIT BUILD HYPO
PREFIX CODE SUFFIX CHASSIS (MONTH) (BAL)
MONTH DIFF
fitz TA 2070 B270 900 7183 2 38 820 -80 20
TA 2361 B270 1201 8215 4 38 1111 -90 10
woodson TC 556 B280 405 A 1306 3 46 305 -100 0 1 306 7 6
wescott TC 3387 B280 3209 A 16710 8 47 3136 -73 27 16
710 24 8
terryVP TC 3452 B280 3263 A 16840 9 47 3201 -62 38 16
840 25 9
grunau TC 5054 B280 4829 A 29990 4 48 4803 -26 74 29
990 32 3
norris TC 5221 B280 4996 A 31162 4 48 4970 -26 74 31
162 32 1
old TC 6710 B280 6484 A 32487 10 48 6459 -25 75 32 487
38 6
fritz TC 6756 B280 6530 A 32534 10 48 6505 -25 75 32
534 38 6
tc48td50 TC 6768 B280 6542 A 32557 10 48 6517 -25 75
32 557 38 6
shade TC 7344 B280 7116 A 33101 12 48 7093 -23 77 33
101 40 7
hill TC 7387 B280 7159 A 33167 12 48 7136 -23 77 33
167 40 7
tabbert TC 7538 B280 7310 A 33339 1 49 7287 -23 77 33
339 41 8
barker TC 7934 B280 7706 A 33356 2 49 7683 -23 77 33
356 42 9
barker TC 7992 B280 7764 A 37944 2 49 7741 -23 77 37
944 42 5
barker TC 8007 B280 7779 A 38148 2 49 7756 -23 77 38
148 42 4
mccombs TC 8126 B280 7895 A 38224 3 49 7875 -20 80 38
224 43 5
oldfield TC 8343 B280 8110 A 38253 4 49 8092 -18 82
38 253 44 6
franks TC 8332 B280 8099 A 38421 3 49 8081 -18 82 38
421 43 5
grunau TC 8654 B280 8421 A 38745 5 49 8403 -18 82 38
745 45 7
sherrell TC 9491 B280 9240 A 39102 8 49 9240 0 100
39 102 48 9
grunau TC 5573 B280 5348 A 29971 5 48 5322 -26 74 29
971 33 4 plate not on car
You can copy this straight into your own spreadsheet.
Mike