ࡱ>   !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSUVW`YZ[\]^_TabcRoot EntryFׯQ8(Book BCompObjjSummaryInformation(X  FMicrosoft Excel 5.0 WorksheetBiff5Excel.Sheet.59q_Oh+'Oh+'0 PhG(mv; t     ``iݜ*o?H6A^BbzbO/:7@ p;  DescriptionFormulaNumbers! # Check DigitDigit Position~ ?@D@ L@@@@   @  "@  $@  &@  (@*@Airline Ticket #T?@?@"@"@@@ @?@@@Airline Ticket # 6C "   *&  d?_*+%&A &LJessica Waggener &D&C &R&F &AM{Genigraphics Driver D5dGenigraphics Driverd "d,X??U} m}  }  } } I} } I} m} } m} } } $ } m} m  F0+@F gg j JP@g Ҧ  ;  DescriptionFormulaNumbers!   # Check DigitDigit Position~ ?@D@L@@@@ L  @   L "@   $@   &@   USPS Order #H@"@@@"@ @ @@@@?  USPS Order #cuA   ~  ?Check Formula:  Order # mod 9/ MOD(I6,9) d$  D A'(computer overload??) : 2Check Formula (Using Divisibility Rule for Nines): (  Sum of first 10 Position Digits:  SUM(C5:L5)! P@  % 5' Remainder when sum divided by 9  MOD(F8,9) ?  D  A' @ D  A' Answer = Check Digit? IF(F9=M5, TRUE, FALSE); %D D  @ @B uA~ n;E^td5dH(}Vg>   "   (F0  d?_*+%&A &LJessica Waggener &D&C &R&F &AMHP LaserJet 4Si MX@w ,,@MSUDNHP LaserJet 4Si MX ;d "d,X??U} } } m } } I} } I} m} } m} } $ } m    F0 +@ F   g g  j +P@g ,Ҧ@  ;  7 DescriptionFormulasNumbers!   # Check DigitDigit Position~ ?@D@ L@@@@   @  "@  $@  AM Express #B@?@ @@@?@@  AM Express #~ NU;2   ~  @ Check Formula  Order # mod 9' MOD(I6,9) @  D A': 2Value needed for whole number to be divisible by 9 9-D9 @  D Value = check ? IF(D10=L6,TRUE, FALSE)7 !D D  @B G ?Check Formula (Using Divisibility Trick for Casting Out Nines):  Sum of ALL Digits:  SUM(C5:L5)! B@ % 5'Remainder when sum divided by 9 MOD(F8,9)  D  A' Answer = 0 ?IF(F9=0, TRUE, FALSE):$D  @ @Bc3X^B)RpeYd>   "   n2@  d?_*+%&A&LJessica Waggener &D&R&F &A MHP LaserJet 4Si MX@w ,X@MSUDNHP LaserJet 4Si MX ;d "d,X??U} } } } } } I} } I} m} } } m} } } } I} m} m  F0F gg@jPg Ҧ@  ; 7 `} †N DescriptionNFormulas @??Numbers!??????@@@@?@ OOP category codeQRmanufacturer codeRRRRS  R product code RRRRSN check digitODigit PositionO~ B?TB@DB@LB@LB@LB@ L T B@   L B @   L B"@   B$@ B&@ TB(@L(OOBTBBBBBTBBBBBTBNUPC CodeO~ B T $B@B@BBB T$ B?B@B@B?B?T~ B(OOBCBBBBBCBBBBBCBO>Check Formula:$UVWWWWWKHHHHHKX#OSum of Odd Position Digits:OC5+F5+H5+K5+M5+O578773Y&@DDDD D DZ787777789 O*3 OG8*37877I@@D97877777894 O,Sum of Even Position Digits, including check OE5+G5+I5+L5+N5+Q5 78773 I@DDDD D D 9787777789 O Total Sum OG10+G9 7877 ID@  D D 9787777789 ODivisible by 10?$ OIF(MOD(G11,10)=0,TRUE,FALSE) :;::8 [ "D  A'  B \:;:::::;<>Product Category ?@@A First Digit AB G Sample UPC  GGH  LProduct HMDNational Brand Products EFFF 0, 6, or 7 FF :0 51500 02500 0  :::  J Magic Shell :=DRandom Weight Items EFF~ F@FF::::J:=DHealth-Related/ Drugs EFF~ F@ FF :3 09040 10146 4  :::  J Ibuprofen :=DCoupons EFF~ F@FF::::J:=6D.Product marked for price-reduction by retailer EFF~ F@FF::::J:= DBooks EFF~ F"@FF::::J:=*f hoB,,LpzYMt>   "   >BJ  d?_*+%&A &LJessica Waggener &D&C &R&F &AMHP LaserJet 4Si MX@w ,,@MSUDNHP LaserJet 4Si MX ;d "d,X??U} } } } } I} } I} } } $} } m} m    F0  F   g g  J@j P@g IҦ@  ,;@ g@ 7 DescriptionFormulasNumbers!  /Federal Reserve District1Bank Identification$$$   check digitDigit Position~ ?@D@L@@D@ D @   L  @   L  "@ D   Bank Code@??  @@  ~  @% &Check Formula:  Multiplier@@"@@@"@@@ Digit * Multiplier = C8*C5 DD2@ LL"@  LL@  E@  2@ Sum of New Products =  SUM(C9:K9)! W@ %   Sum(mod 10)  MOD(F10,10) @  D  A' Remainder = check digit? IF(F11=M5,TRUE,FALSE) 3  D D  B  ^e~~&6Ze\R>   "   LV  d?_*+%&A&LJessica Waggener&C &R&F &AMHP LaserJet 4Si MX@w ,,@MSUDNHP LaserJet 4Si MX ;d "d,X??U} } } m} } m F0FJ@ ggX@j P@g Ҧ@  I;@ +@ I7@,@g @`} DescriptionFormulasNumbers! $$$$  check digitDigit Position~ ?@D@L@@L@@  L  @  "@ D  $@   L &@   (@ *@ ,@  Credit Card #T@?@@@? "@@@@?%  Odds%@D@D@D D  "@ D  @D ? D Evens %?D@DD ?D  @ D  @ D &Check Formula: " Sum of Odd Position Digits  SUM(C7:O7)! 9@ %5 *2 F10*2 I@ D 1 )Plus the number of odd position digits >4 F11+COUNTIF(C7:O7,">4")) J@ D %>4AZ0 (Plus the sum of the even position digits F12+SUM(C8:O8)& Q@ D %|+ #Check Digit ? (10-Sum(mod10)) 10-MOD(F13,10)$ @  D  A'New SumF14+F13 Q@  D D New Sum Mod 10 =0?$IF(MOD(F15,10)=0,TRUE,FALSE)8"D A'  B$ ,a1q4aAxqI>   "   Xa  d?_*+%&A &LJessica Waggener &D&C &R&F &AMHP LaserJet 4Si MX@w ,,@MSUDNHP LaserJet 4Si MX ;d "d,X??U} $} $} $ } } } I} } } $} $} m} m  F0@F ;ggJ@jP@g  Ҧ@  ,;@ @ 7 DescriptionFormulas Numbers! *)"Language of Country of Publication!Publisher - - - - Book   check digitDigit Position~ ?@D@L@@L@  @   L  @   "@    $@D  *ISBN #  ~ + , 6+@+?+@+@+@+@+@+ @  ,~  *@ % &Check Formula: Weights~ $@6"@ @@@@@@@ Digit * weight = L8*L5 LLO@ @E@E@  LL$@  (@  5@  0@ D D / 'Sum of weighted values plus check digit  SUM(C9:L9)+N5& k@ % 5D   Sum(mod 11)  MOD(G10,11)   D  A'  Value =0? IF(G11=0,TRUE,FALSE)  2  D   B  i(<[vR>   "   cs  d?_*+%&A &LJessica Waggener &D&C &R&F &AMHP LaserJet 4Si MX@w ,,@MSUDNHP LaserJet 4Si MX ;d "d,X??U} I} m4} m} } } I} m} I} } } $} m  F0@F ;ggjJP@g Ҧ@  I;@  @ Y7@ Description3Formulas Numbers!$) check digit ?Digit Position~ ?@D@ L@@@  @   @  "@  $@  &@(@*@,@.@.Code # 3 ~ +@ , +?+ +S +A0++?+@+@+@+@+@ +Z +A*<D Y+Digit ASCII Value5CODE(C5)I@DAy  H@ LAyH@T@@P@H@ H@ K@  I@  I@  I@ I@ V@@P@&Check Formula:$Value of Position&5IF(CODE(C5)<58,C5,CODE(C5)-55)@-@*DAy: $DAy7B-<4*LAy: ,LAy7B -? - -<@ -$@ -  -?  -@  -@  -@  -@ -@ -A@ -$@ Weights~ .@~ ,@*@D(@ L&@$@ "@   @  @  @  @ @@@ value * weight = 4C9*C8 >@ DD   ,@   LL   u@  [@     "@   H@   ,@   2@   $@   @  @Z@  4@  Sum of New Values 4 SUM(C10:Q10)! @  %  , $Check Digit Value 36-sum(mod36) 436-MOD(G11,36)$ A@ $D $A'% Representation of Check ValueA < +D  $ D 7@AoBY New Sum mod 36 4MOD(G12+G11,36)  %  D D $A' $ IF(G12<10,G12, CHAR(G12+55)) -oA B|Z>   "   uK  d?_*+%&A &LJessica Waggener &D&C &R&F &A&p= ף?'Q?MHP LaserJet 4Si MX@w ,X@MSUDNHP LaserJet 4Si MX ;d "d,X??U} } } m} } } I} m} I} } } $} I} } m  F0@F ;gbg+@jJP@g Ҧ@  I;@  @ Y7@ DescriptionFormulas Numbers!$*) check digit ?Digit Position~ ?@D@L@@@  @   @  "@  $@  &@(@*@,@.@0@1@D ]VIN #^MY VIN~ _@` _T~ _? _A _E__"@   _B~  _  _S  _C*_?_?_@_"@_@_aF<D U_Digit ASCII Value2CODE(C5)I@DAy  U@LAyH@@P@@Q@H@  L@  P@  H@  T@  P@H@H@J@L@J@H@LAy&Check Formula:*Value of Position&5IF(CODE(C5)<58,C5,CODE(C5)-55)@-@ *DAy: $DAy7B-4*LAy: ,LAy7B-=@ -? -$@ -,@ -  -"@  -&@  -  -<@  -(@ -? -? -@ -"@ -@ @- *DAy: $DAy7BWeights~ 2@~ 1@0@D.@L,@*@  (@  &@  $@  "@   @@@@@@@ value * weight = C9*C8 B@ DD   ~@   LL 0@  b@  h@     [@   @^@      o@   X@  @  @  9@  B@  (@     Sum of New Values  SUM(C10:T10)! H@  % 5, $Check Digit Value 36-sum(mod36) 36-MOD(G11,36)$ >@ $D $A'% Representation of Check ValueA < +D  $ D 7@AoBU New Sum mod 36 MOD(G12+G11,36)  % D D $A' $ IF(G12<10,G12, CHAR(G12+55)) XuG> yHdZ> "    w  d?_*+%&A &LJessica Waggener &D&C &R&F &AMHP LaserJet 4Si MX@w ,,@MSUDNHP LaserJet 4Si MX ;d "d,X??U} } m} I } } $} I} } I} } m} } m} I} m} m  F0F gbFg@j P@g Ҧ  DescriptionFormulas Numbers!'geographic area(!/Sectional Center Facility//Local Post Office! 0  /Delivery Sector ! !Location !  "  check digit ?Digit Position~ ?@D@L@@  @   L @   L  @   L~  "@ $@D  Zip Code~ @@??@ @@@  @DCheck Formula: Sum of First 9 Digits SUM(C5:M5)!;@ % 5%Check Digit 10-sum(mod10) 10-MOD(G8,10)$@ D A' Sum divisible by 10?(  IF(MOD((G9+G8),10)=0,TRUE,FALSE)> (DD A'  B  0k:\j>   "     d?_*+%&APage &PMHP LaserJet 4Si MX@w XX@MSUDNHP LaserJet 4Si MX ;d "dXX??U} m  > "     d?_*+%&APage &PMHP LaserJet 4Si MX@w XX@MSUDNHP LaserJet 4Si MX ;d "dXX??U} m  > "     d?_*+%&APage &PMHP LaserJet 4Si MX@w XX@MSUDNHP LaserJet 4Si MX ;d "dXX??U} m  > "    Ù  d?_*+%&APage &PMHP LaserJet 4Si MX@w XX@MSUDNHP LaserJet 4Si MX ;d "dXX??U} m  > "    ˛  d?_*+%&APage &PMHP LaserJet 4Si MX@w XX@MSUDNHP LaserJet 4Si MX ;d "dXX??U} m  > "    ӝ  d?_*+%&APage &PMHP LaserJet 4Si MX@w XX@MSUDNHP LaserJet 4Si MX ;d "dXX??U} m  > " 2 H IX3 2 Y Zi4 2 j kz5 2 { |6 2 7 2 8 2 92 102 112 12 2 cA 2 -B 2 :/NC 2 XPjD 2 vlE"Systemn-'- "Geneva- --'- " 2  Description 2 Formula -  !M !O !i !k ! ! ! ! ! ! ! ! ! !  !& !( !F !H 2 Numbers!  --'-- - --'- - XH 2 HDigit Position   2 HE1 2 Ha2 2 H3--'- - --'- - ---'-- zj 2 jAirline Ticket # - 2 jE1 2 ja2 2 j1--'- - --'- - { 2 {Airline Ticket # -_Oh+'Oh+'0 PhG(mv; t     ``iݜ*o?H6A^BbzbO/(fvEE>j(9jJ2 """)))000___UUUMMMBBB999 ```( +9%I;/]E:IS+!!lYQGj2ga1aS {Cg..&YQFh.IRj#SjJu3lJA7e ,N, QdoV YC6r3w_GqC-}zn#&s[ Rp$L 6n{DuqVJ4H2Aph6B"}3%6Z\H"BMXR ӕ$sVo<gX .YLg:}ߚ=VCq8SeFMjLZc"LeN?Pppiiiwwwfxю7Tvpxd?2}Dx#$_`,19م>w؁V!0ȳypQit|45'  ' -  "- "- !-""- !"-GG- !G-XX- !X-ii- !i-zz- !z-- !-- !-- !-- !-- !-- !-- !-- !-- !---- !--NN- !N-jj- !j-- !-'- -   "-""- !n"-GG- !nG-XX- !nX-ii- !ni-zz- !nz-- !n-- !n-- !n-- !n-- !n-- !n-- !n-- !---- !--NN- !N-jj- !j-- !-'- "Geneva-   2  -  "-- !-- !-- !-- !--  2  "1 2 7 $G2-'- - --'- - -   !, !. !M !O !i !k ! ! ! ! ! !--'--   2 Check Formula:  --'-- - --'- -  $2 Ticket Number Mod 7     ! ! 2 #NUM! --'- - --'- - --'- - -   !, !. !M !O !i !k ! ! ! ! ! !--'--   2 Check Formula?  --'-- --'- -  "-- !-- !-'Check Digit SpreadsheetJames W. Wilson