jimomura@lsuc.uucp (Jim Omura) (04/28/88)
I thought about computerizing Canadian Postage for my office
but I came to the conclusion that is wasn't worth the effort.
I have the information organized in a spreadsheet and have
provided it in 3 forms in this sharfile. It's an interesting
problem. I expect most people will agree with me that it
does not seem amenable to computerizing. If you do find
a neat solution, I would of course be interested in hearing
about it.
Cheers! -- Jim O.
# This is a shell archive.
# Remove everything above and including the cut line.
# Then run the rest of the file through sh.
#----cut here-----cut here-----cut here-----cut here----#
#!/bin/sh
# shar: Shell Archiver
# Run the following text with /bin/sh to create:
# README
# post.spl
# post.odf
# postage.uue
# This archive created:
# By: Jim Omura ()
sed 's/^X//' << \SHAR_EOF > README
X88/04/27
X
X This is my 2nd version of this posting. It is an
Xexperiment to see if a table as complex as this can be
Xuseful in a spreadsheet form.
X
X This set of files contains information on Postal Rates
Xwithin Canada from Jan. 1, 1988. The included files are
X'post.spl' which is a printout of a Dynacalc spreadsheet,
Xthe Uuencoded spreadsheet and an ODF file to use the
Xinformation in other programs (such as other spreadsheets).
XSee description of ODF files in BIX 'canada/long.messages'.
X
XCheers! -- Jim O.
SHAR_EOF
sed 's/^X//' << \SHAR_EOF > post.spl
X
X
XLetter Rates April 27, 1988 PAGE 1
X
X
XPostal Rates Within Canada Effective 1988/01 /01
XPer Canada Post Corporation
X
X First Class Letter and Post Cards
X Leave a Clear strip 19 mm across Bottom
X
XMinimums: Stamped Mail:
X 10 cm * 7 cm * 0.018 cm
X
X Metered and postage Paid in Cash:
X 14 cm * 9 cm * 0.018 cm
XItems Not less than 10 cm * 7 cm. * 0.018 cm.
XPaid by Meter or In Cash & Under 50 gm. are Oversize
X
XMaximums: In CM.
X Len. Width Thick Grams. Max. Fixed Factor
X 25.5 15 .5 30 .37
X 50 .57
X
X Oversize Letter Rates
X
XMinimums: 25.5 cm * 15 cm. *0.5 cm
X
XMaximums: In CM.
X 38 27 2 30 .47
X 50 .74
X 100 .74
X 200 1.11
X 300 1.48
X 400 1.85
X 500 2.22
X
XFirst Class volume discounts on enquiry.
X
XThird Class Quantity Addressed Mail From Mar. 1, 1988
X
XRate: National Distribution Guide
X Presorted Mail 0.20
X
XMinimums: 10 cm. * 7 cm. * 0.018 cm.
X 5000 units Provincially or
X 10000 units Nationally
X
XMaximums: In CM.
X 38 27 2
X
XSubject to General Limits on 3rd Class Mail
XItems must be presorted and Bundled per postal requirements
X
XHouseholder (Unaddressed) Mail
X
XThird Class. Discounts based on annual guaranteed postage
XLetter Rates April 27, 1988 PAGE 2
X
XAgreement must be signed for weight, size and rates.
X
XSpecial Services:
XAck. of Receipt (Registered Mail)
X Cards available before mailing .62
X after mailing 1.03
X
XBusiness Reply Ask Postmaster
X Charge added onto 1st Class .043
X
XCertified Mail (proof of delivery)
X Per Kit, above 1st or 4th
X class rate 1.55
X
XCOD Up to 100.00 (+Postage) 2.05
X Each added $100.00
X up to 1000.00 .37
X Additional indemnity where value
X of contents exceeds COD
X per 100.00
X up to 1000.00 .37
X
XInsurance: Max. Rate
X 10.00 .25
X 50.00 .37
X 100.00 .43
X
X From 100.00
X To 1000.00 .43 + .37/ 100.00
X
XMoney Orders up to 200.00 .85
X
XProof of Delivery with Insurance
X Parcel Only
X Up to 100.00 .77 (Base Rate)
X Amnts over 100.00
X Up to 1000.00 Base Rate + .37/ 100.00
X
XRegistered Mail
X (Proof of Delivery)
X First 100.00 2.70
X Over 100.00
X Up to 1000.00 +.37/ 100.00
X
XSpecial Delivery
X (Must be handled in Post Office)
X Up to 38 cm * 27 cm * 2 cm
X First Class letter rate +
X A. if in postal zone with
X same 1st letter 1.83
X B. otherwise 2.63
SHAR_EOF
sed 's/^X//' << \SHAR_EOF > post.odf
X*DYNACALC Data File
X* April 27, 1988
X/Row
XPostal Rates
X>
XWithin Canad
Xnada
XEffective
X 1988/01
X/01
X@
XPer
XCanada Post
Xst Corporation
Xation
X>
X>
X>
X@
X>
X>
X>
X>
X>
X>
X>
X@
X>
XFirst Class
Xss Letter and
X and Post Cards
Xrds
X>
X>
X@
X>
XLeave a Cl
Xlear strip
Xp 19 mm across
Xss Bottom
X>
X>
X@
X>
X>
X>
X>
X>
X>
X>
X@
XMinimums:
XStamped
XMail:
X>
X>
X>
X>
X@
X>
X'10 cm *
X'7 cm *
X'0.018 cm
X>
X>
X>
X@
X>
X>
X>
X>
X>
X>
X>
X@
X>
XMetered and
Xnd postage
Xe Paid in Cash
Xsh:
X>
X>
X@
X>
X'14 cm *
X'9 cm *
X'0.018 cm
X>
X>
X>
X@
XItems Not less
Xss than
X'10 cm *
X'7 cm. *
X'0.018 cm.
X>
X>
X@
XPaid by Meter
Xr or In Cas
Xash & Under
Xer 50 gm.
Xare Oversize
Xize
X>
X@
X>
X>
X>
X>
X>
X>
X>
X@
XMaximums:
XIn CM.
X>
X>
X>
X>
X>
X@
XLen.
XWidth
XThick
XGrams. Max.
XFixed
XFactor
X>
X@
X25.5
X15
X.5
X30
X.37
X>
X>
X@
X>
X>
X>
X50
X.57
X>
X>
X@
X>
X>
X>
X>
X>
X>
X>
X@
X>
XOversize Le
XLetter Rate
Xtes
X>
X>
X>
X@
X>
X>
X>
X>
X>
X>
X>
X@
XMinimums:
X'25.5 cm *
X 15 cm. *
X'0.5 cm
X>
X>
X>
X@
X>
X>
X>
X>
X>
X>
X>
X@
XMaximums:
XIn CM.
X>
X>
X>
X>
X>
X@
X38
X27
X2
X30
X.47
X>
X>
X@
X>
X>
X>
X50
X.74
X>
X>
X@
X>
X>
X>
X100
X.74
X>
X>
X@
X>
X>
X>
X200
X1.11
X>
X>
X@
X>
X>
X>
X300
X1.48
X>
X>
X@
X>
X>
X>
X400
X1.85
X>
X>
X@
X>
X>
X>
X500
X2.22
X>
X>
X@
X>
X>
X>
X>
X>
X>
X>
X@
XFirst Class vo
Xvolume discount
Xscounts on
Xn enquiry.
X>
X>
X>
X@
X>
X>
X>
X>
X>
X>
X>
X@
XThird Class
XQuantity Add
XAddressed M
X Mail From Mar
Xar. 1, 1988
X'88
X>
X@
X>
X>
X>
X>
X>
X>
X>
X@
XRate:
XNational
XDistribution
Xion Guide
X>
X>
X>
X@
X>
XPresorted Ma
X Mail
X>
X.2
X>
X>
X@
X>
X>
X>
X>
X>
X>
X>
X@
XMinimums:
X'10 cm. * 7
X'7 cm. *
X'0.018 cm.
X>
X>
X>
X@
X>
X5000
X units Prov
Xovincially or
Xr
X>
X>
X@
X>
X10000
X units Natio
Xtionally
X>
X>
X>
X@
X>
X>
X>
X>
X>
X>
X>
X@
XMaximums:
XIn CM.
X>
X>
X>
X>
X>
X@
X38
X27
X2
X>
X>
X>
X>
X@
X>
X>
X>
X>
X>
X>
X>
X@
XSubject to
XGeneral Lim
Ximits on 3
X'3rd Class Mail
Xil
X>
X>
X@
XItems must be
Xe presorted
Xed and Bun
Xndled per post
Xstal requi
Xirements
X>
X@
X>
X>
X>
X>
X>
X>
X>
X@
XHouseholder (Un
X(Unaddress
Xsed) Mail
X>
X>
X>
X>
X@
X>
X>
X>
X>
X>
X>
X>
X@
XThird Class.
X Discounts
Xts based on
Xon annual guar
Xaranteed post
Xpostage
X>
X@
XAgreement must
Xst be signed
Xned for we
Xeight,
Xsize and re
Xrates.
X>
X@
X>
X>
X>
X>
X>
X>
X>
X@
XSpecial Service
Xices:
X>
X>
X>
X>
X>
X@
XAck. of Receip
Xipt (Registe
Xstered Mail
Xil)
X>
X>
X>
X@
X>
XCards avail
Xilable before
Xfore mailing
X.62
X>
X>
X@
X>
X>
Xafter mail
Xling
X1.03
X>
X>
X@
X>
X>
X>
X>
X>
X>
X>
X@
XBusiness Reply
Xly Ask Post
Xstmaster
X>
X>
X>
X>
X@
X>
XCharge added
Xded onto 1st
X'1st Class
X>
X.043
X>
X@
X>
X>
X>
X>
X>
X>
X>
X@
XCertified Mail
Xil (proof of
X of delivery
Xery)
X>
X>
X>
X@
X>
XPer Kit, ab
Xabove 1st or
X or 4th
X>
X>
X>
X@
X>
Xclass rate
Xe
X>
X1.55
X>
X>
X@
X>
X>
X>
X>
X>
X>
X>
X@
XCOD
XUp to
X100
X (+Postage)
X2.05
X>
X>
X@
X>
XEach added
Xd $100.00
X>
X>
X>
X>
X@
X>
Xup to
X1000
X>
X>
X.37
X>
X@
X>
XAdditional
Xl indemnity
Xty where value
Xue
X>
X>
X@
X>
Xof contents
Xts exceeds
Xs COD
X>
X>
X>
X@
X>
Xper
X100
X>
X>
X>
X>
X@
X>
Xup to
X1000
X>
X>
X.37
X>
X@
X>
X>
X>
X>
X>
X>
X>
X@
XInsurance:
X>
XMax.
XRate
X>
X>
X>
X@
X>
X>
X10
X.25
X>
X>
X>
X@
X>
X>
X50
X.37
X>
X>
X>
X@
X>
X>
X100
X.43
X>
X>
X>
X@
X>
X>
X>
X>
X>
X>
X>
X@
X>
XFrom
X100
X>
X>
X>
X>
X@
X>
XTo
X1000
X.43
X + .37/
X100
X>
X@
X>
X>
X>
X>
X>
X>
X>
X@
XMoney Orders:
X up to
X200
X.85
X>
X>
X>
X@
X>
X>
X>
X>
X>
X>
X>
X@
XProof of Delivery
Xivery with
Xh Insuranc
Xce
X>
X>
X>
X@
X>
XParcel Only
Xly
X>
X>
X>
X>
X@
X>
XUp to
X100
X.77
X (Base Rate
Xte)
X>
X@
X>
XAmnts over
Xr 100.00
X>
X>
X>
X>
X@
X>
XUp to
X1000
XBase Rate
X + .37/
X100
X>
X@
X>
X>
X>
X>
X>
X>
X>
X@
XRegistered Mail
Xail
X>
X>
X>
X>
X>
X@
X>
X(Proof of de
X Delivery)
X)
X>
X>
X>
X@
X>
XFirst
X100
X2.7
X>
X>
X>
X@
X>
XOver
X100
X>
X>
X>
X>
X@
X>
XUp to
X1000
X>
X +.37/
X100
X>
X@
X>
X>
X>
X>
X>
X>
X>
X@
XSpecial Deliver
Xvery
X>
X>
X>
X>
X>
X@
X>
X(Must be han
Xhandled in
Xn Post Office
Xe)
X>
X>
X@
X>
XUp to
X'38 cm *
X'27 cm *
X'2 cm
X>
X>
X@
X>
XFirst Class
Xss letter r
X rate +
X>
X>
X>
X@
X>
XA. if in post
Xpostal zone
Xne with
X>
X>
X>
X@
X>
Xsame 1st
Xletter
X1.83
X>
X>
X>
X@
X>
XB. otherwise
Xise
X2.63
X>
X>
X>
X@
SHAR_EOF
sed 's/^X//' << \SHAR_EOF > postage.uue
X
Xbegin 644 postage.cal
XM__^`@0P`#``,`P``````\"H`!B(,``0$!B('%````P(`````"0`````#`DL`=
XM``````````````````````````````````````````,"!1```",`````!_\`#
XM.4\```````XP4&]S=&%L(%)A=&5S``$%,%!E<@`&"S!-:6YI;75M<SH`"Q$P+
XM271E;7,@3F]T(&QE<W,@``P/,%!A:60@8GD@365T97(`#@LP36%X:6UU;7,Z_
XM``\&,DQE;BX`$`J@3````````(4`%0LP36EN:6UU;7,Z`!<+,$UA>&EM=6US;
XM.@`8"J`8````````A@`@$#!&:7)S="!#;&%S<R!V;P`B#3!4:&ER9"!#;&%S:
XM<P`D!S!2871E.@`G"S!-:6YI;75M<SH`*PLP36%X:6UU;7,Z`"P*H!@`````>
XM``"&`"X,,%-U8FIE8W0@=&\`+P\P271E;7,@;75S="!B90`Q$3!(;W5S96AO0
XM;&1E<B`H56X`,PXP5&AI<F0@0VQA<W,N`#00,$%G<F5E;65N="!M=7-T`#81>
XM,%-P96-I86P@4V5R=FEC90`W$#!!8VLN(&]F(%)E8V5I<``[$#!"=7-I;F5S7
XM<R!297!L>0`^$#!#97)T:69I960@36%I;`!"!3!#3T0`2@PP26YS=7)A;F-E*
XM.@!2#S!-;VYE>2!/<F1E<G,Z`%03,%!R;V]F(&]F($1E;&EV97)Y`%H1,%)ED
XM9VES=&5R960@36%I;`!@$3!3<&5C:6%L($1E;&EV97(!`0TP0V%N861A(%!O=
XM<W0!`PTP1FER<W0@0VQA<W,!!`PP3&5A=F4@82!#;`$&"3!3=&%M<&5D`0<*D
XM,#$P(&-M("H@`0D-,$UE=&5R960@86YD`0H),#$T(&-M("H!"PDP<W,@=&AAV
XM;@$,#3!R(&]R($EN($-A<P$."#!);B!#32X!#P<R5VED=&@!$`J@<```````)
XM`(0!$PTP3W9E<G-I>F4@3&4!%0LP,C4N-2!C;2`J`1<(,$EN($--+@$8"J!82
XM````````A0$@$3!V;VQU;64@9&ES8V]U;G0!(@XP475A;G1I='D@061D`20*@
XM,$YA=&EO;F%L`24.,%!R97-O<G1E9"!-80$G##`Q,"!C;2X@*B`W`2@*H!Q`#
XM``````"-`2D*H!Q```````".`2L(,$EN($--+@$L"J!8````````A0$N#3!'K
XM96YE<F%L($QI;0$O#3!E('!R97-O<G1E9`$Q##`H56YA9&1R97-S`3,.,"`@T
XM1&ES8V]U;G1S(`$T#C!S="!B92!S:6=N960!-@<P:6-E<SH!-PXP:7!T("A2@
XM96=I<W1E`3@-,$-A<F1S(&%V86EL`3L-,&QY($%S:R!0;W-T`3P.,$-H87)G4
XM92!A9&1E9`$^#C!I;"`H<')O;V8@;V8!/PTP4&5R($MI="P@86(!0`PP8VQA4
XM<W,@<F%T90%""#!5<"!T;R`!0PPP16%C:"!A9&1E9`%$"#!U<"!T;R`!10TP@
XM061D:71I;VYA;"`!1@TP;V8@8V]N=&5N=',!1P4P<&5R`4@(,'5P('1O(`%/=
XM!C!&<F]M`5`$,%1O`5((,"!U<"!T;P%4#3!I=F5R>2!W:71H(`%5#3!087)C[
XM96P@3VYL>0%6!S!5<"!T;P%7#3!!;6YT<R!O=F5R(`%8!S!5<"!T;P%:!3!A&
XM:6P!6PXP*%!R;V]F(&]F(&1E`5P',$9I<G-T`5T&,$]V97(!7@<P57`@=&\!F
XM8`8P=F5R>0%A#C`H375S="!B92!H86X!8@<P57`@=&\!8PTP1FER<W0@0VQA&
XM<W,!9`\P02X@:68@:6X@<&]S=`%E"C!S86UE(#%S=`%F#C!"+B!O=&AE<G=IZ
XM<V4"``XP5VET:&EN($-A;F%D`@$0,'-T($-O<G!O<F%T:6]N`@,/,'-S($QE7
XM='1E<B!A;F0"!`PP;&5A<B!S=')I<`(&!S!-86EL.@('"#`W(&-M("H""0PP_
XM;F0@<&]S=&%G90(*"#`Y(&-M("H""PDP,3`@8VT@*@(,#3!A<V@@)B!5;F1EV
XM<@(/!S)4:&EC:P(0"J``````````@`(3#3!,971T97(@4F%T90(5"S`@,34@1
XM8VTN("H"&`J@`````````(("(`PP<V-O=6YT<R!O;@(B#3!!9&1R97-S960@(
XM30(D#C!$:7-T<FEB=71I;VX")0<P($UA:6P")PDP-R!C;2X@*@(H#3`@=6YI&
XM=',@4')O=@(I#C`@=6YI=',@3F%T:6\"+`J@`````````(("+@PP:6UI=',@1
XM;VX@,P(O##!E9"!A;F0@0G5N`C$+,'-E9"D@36%I;`(S#C!T<R!B87-E9"!O\
XM;B`"-`PP;F5D(&9O<B!W90(W#3!S=&5R960@36%I;`(X#S!I;&%B;&4@8F5FI
XM;W)E`CD,,&%F=&5R(&UA:6P".PLP<W1M87-T97(@`CP.,&1E9"!O;G1O(#%SJ
XM=`(^#C`@;V8@9&5L:79E<GD"/PXP86)O=F4@,7-T(&]R`D`#,&4"0@JF2```&
XM`````(<"0PLP9"`D,3`P+C`P`D0*IGH```````"*`D4-,&P@:6YD96UN:71YI
XM`D8,,'1S(&5X8V5E9',"1PJF2````````(<"2`JF>@```````(H"2@8R36%X<
XM+@)+"J8@````````A`),"J9(````````A@)-"J9(````````AP)/"J9(````R
XM````AP)0"J9Z````````B@)2"J9(````````B`)4##!H($EN<W5R86YC`E4$9
XM,&QY`E8*ID@```````"'`E<*,'(@,3`P+C`P`E@*IGH```````"*`EL,,"!$[
XM96QI=F5R>2D"7`JF2````````(<"70JF2````````(<"7@JF>@```````(H"Z
XM80TP:&%N9&QE9"!I;B`"8@DP,S@@8VT@*@)C#3!S<R!L971T97(@<@)D#3!PD
XM;W-T86P@>F]N90)E"#!L971T97("9@4P:7-E`P`&,&YA9&$#`0<P871I;VX#R
XM`Q$P(&%N9"!0;W-T($-A<F1S`P00,'`@,3D@;6T@86-R;W-S`P<*,#`N,#$X+
XM(&-M`PD0,&4@4&%I9"!I;B!#87-H`PH*,#`N,#$X(&-M`PL),#<@8VTN("H#L
XM#`LP97(@-3`@9VTN`P\-,D=R86US+B!-87@N`Q`*H'````````"%`Q$*H$@`J
XM``````"&`Q,%,'1E<P,5"#`P+C4@8VT#&`J@<````````(4#&0J@2```````X
XM`(8#&@J@2````````(<#&PJ@2````````(@#'`J@%@```````(D#'0J@2```N
XM`````(D#'@J@>@```````(D#(`PP;B!E;G%U:7)Y+@,B$#`@36%I;"!&<F]M[
XM($UA<@,D"S!I;VX@1W5I9&4#)PLP,"XP,3@@8VTN`R@0,&]V:6YC:6%L;'D@U
XM;W(@`RD*,'1I;VYA;&QY`RX0,#-R9"!#;&%S<R!-86EL`R\0,&YD;&5D('!ET
XM<B!P;W-T`S,0,&]N(&%N;G5A;"!G=6%R`S0(,&5I9VAT+`,W!3!I;"D#.`XPK
XM9F]R92!M86EL:6YG`SD&,&QI;F<#/`LP,7-T($-L87-S`SX&,&5R>2D#/PDP<
XM(&]R(#1T:`-"#3`@*"M0;W-T86=E*0-%$#!T>2!W:&5R92!V86QU90-&!S!S"
XM($-/1`-*!C)2871E`TL*H`````````!_`TP*H#UPH]<*/7%_`TT*H%PH]<*/9
XM7"E_`T\",`-0"J!<*/7"CUPI?P-2"J!9F9F9F9F9@`-4!#!C90-6"J!%'KA1#
XMZX4?@`-8"S)"87-E(%)A=&4#6P,P*0-<"J8LS,S,S,S-@@-A#S!N(%!O<W0@%
XM3V9F:6-E`V(),#(W(&-M("H#8PDP(')A=&4@*P-D"C!N92!W:71H(`-E"J!JO
XM/7"CUPH]@0-F"J`H4>N%'KA2@@0`"S!%9F9E8W1I=F4$`P4P<F1S!`0+,'-S3
XM($)O='1O;00)!3!S:#H$"PLP,"XP,3@@8VTN!`P.,&%R92!/=F5R<VEZ900/;
XM!S)&:7AE9`00"J`]<*/7"CUQ?P01"J`1ZX4>N%'L@`08"J!PH]<*/7"D?P09_
XM"J`]<*/7"CUQ@`0:"J`]<*/7"CUQ@`0;"J`.%'KA1ZX4@00<"J`]<*/7"CUQI
XM@00="J!LS,S,S,S-@00>"J`.%'KA1ZX4@@0B#3!A<BX@,2P@,3DX.`0D`C`$/
XM)0JF3,S,S,S,S7X$*`0P<B`$+@0P:6P$+PPP<W1A;"!R97%U:00S#S!A<F%N6
XM=&5E9"!P;W-T!#0-,'-I>F4@86YD(')E!#@*H!ZX4>N%'KB`!#D*H`/7"CUP-
XMH]>!!$`*H$9F9F9F9F:!!$(*H`,S,S,S,S."!$4$,'5E!%`),"`K("XS-R\$5
XM40(P!%8-,"`H0F%S92!2871E!%@),"`K("XS-R\$7@@P("LN,S<O!&$$,&4IC
XM!&(&,#(@8VT$90(P!0`*,"`Q.3@X+S`Q!0P%,&EZ904/"#)&86-T;W(%(@0PX
XM.#@%)`(P!2\*,&ER96UE;G1S!3,),'!O<W1A9V4%-`@P<F%T97,N!3L",`4\U
XM"J`P(,2;I>-4?`5``C`%0@(P!40*H#UPH]<*/7%_!4@*H#UPH]<*/7%_!5`*F
XMID@```````"'!58%-G1E*058"J9(````````AP5>"J9(````````AP8`!3`OU
X),#$&)`(V__\`!
X``
Xend
Xsize 3519
SHAR_EOF
# End of shell archive
exit 0
--
Jim Omura, 2A King George's Drive, Toronto, (416) 652-3880
ihnp4!utzoo!lsuc!jimomura
Byte Information eXchange: jimomura