SmartRate - Smart - DEMOSPP.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	Smart Carrier			ShippingHub SmartRate template
2				ShippingHub SmartRate template
3				ShippingHub Smart Transportation Services
4				ShippingHub SmartCarrier
5	Carrier and Shipper information
6	Effective Date	3/15/2021	Expiry Date	12/31/2021			Smart Shipper
7	Carrier Name	Smart Carrier
8	Contact/eMail	Mr sales	rates@shippinghub.net	999-999-9999
9	Account Code	ShippingHub
10	Carrier Code / Prefix	Smart	Master Carrier	Smart			Insert client slogan here
11	Shipper Name	ShippingHub			DEMOSPP	Table
12	Address	39 Oakmoor Lane			LoadAll	Y
13		Markham	ON	L6B 0P1			Slogan here
14	Contact/eMail	Rates department	rates@shippinghub.net	(416) 342-5621			Slogan here
15	Annual Freight	$150,000		Per week	15	shipments	Slogan here
16	Payment due	30		Interest	1.50%		Slogan here
17	Standard parameters
18	UOM	Imperial	Currency	CAD
22	Liability	$2	per pound
23	Declare Val.	2.00%	Maximum	$50,000
42	Lanes and Rates
43	Service	LTL	Rate by	Weight	InBetween	N	Disc Base	Rate	Disc%		Density
44	Min Wt	20	Max Wt	99999	Min S Wt	0	Max S Wt	99999	Class		Fuel
45	RateGroup	LTL			Rate Column Indicators		0	1	1	1	1	1
46	Origin City	Prov	Destination City	Prov	Postal From	Postal To	MIN	LTL	1000	2000	5000	10000
47	CALGARY	AB	VANCOUVER	BC			79.45	23.44	18.29	16.41	14.39	9.29
48	CALGARY	AB	CONCORD	ON			104.81	24.46	18.54	17.09	15.81	11.41
49	CALGARY	AB	LAVAL	QC			113.29	31.86	28.65	26.65	25.36	16.04
50	COCHRANE	AB	CONCORD	ON			80.97	24.69	18.77	17.32	16.03	11.57
51	EDMONTON	AB	CONCORD	ON			104.81	21.42	15.57	14.12	12.89	9.15
52	EDMONTON	AB	LAVAL	QC			113.29	31.98	28.74	26.79	25.45	16.13
53	LETHBRIDGE	AB	CONCORD	ON			80.97	28.41	21.68	20.11	18.49	13.33
54	MEDICINE HAT	AB	CONCORD	ON			80.97	29.71	22.99	21.39	19.80	14.35
55	RED DEER	AB	CONCORD	ON			104.81	26.26	20.02	18.53	17.12	12.37
56	RED DEER	AB	LAVAL	QC			113.29	33.50	30.25	28.30	27.00	17.11
57	COQUITLAM	BC	CALGARY	AB			79.45	22.29	17.06	15.24	13.20	8.89
58	COQUITLAM	BC	EDMONTON	AB			79.45	23.69	18.24	16.88	14.92	10.27
59	COQUITLAM	BC	RED DEER	AB			79.45	23.41	18.00	16.65	14.70	10.16
60	COQUITLAM	BC	CRANBROOK	BC			142.32	49.83	34.53	29.50	23.75	19.22
61	COQUITLAM	BC	KAMLOOPS	BC			79.45	20.78	15.12	13.70	11.64	8.28
62	COQUITLAM	BC	KELOWNA	BC			79.45	18.49	12.80	11.34	9.29	6.79
63	COQUITLAM	BC	PENTICTON	BC			79.45	18.49	12.80	11.34	9.29	6.79
64	COQUITLAM	BC	PRINCE GEORGE	BC			106.99	51.90	33.78	29.12	17.95	12.72
65	COQUITLAM	BC	SAANICHTON	BC			79.45	21.69	16.06	12.86	10.73	7.43
66	COQUITLAM	BC	SALMON ARM	BC			79.45	18.49	12.80	11.34	9.29	6.79
67	COQUITLAM	BC	VANCOUVER	BC			66.39	19.46	14.35	10.95	8.06	6.67
68	COQUITLAM	BC	VERNON	BC			79.45	18.49	12.80	11.34	9.29	6.79
69	COQUITLAM	BC	VICTORIA	BC			79.45	21.69	16.54	13.22	10.73	7.43
70	COQUITLAM	BC	WILLIAMS LAKE	BC			172.01	50.72	30.65	23.31	18.31	14.05
71	COQUITLAM	BC	WINNIPEG	MB			87.93	27.20	22.31	21.12	19.39	13.11
72	COQUITLAM	BC	LAVAL	QC			113.29	38.49	34.71	31.24	29.13	19.34
73	COQUITLAM	BC	REGINA	SK			83.69	23.39	18.64	17.44	15.75	10.83
74	COQUITLAM	BC	SASKATOON	SK			83.69	23.10	18.37	17.19	15.49	10.64
75	KAMLOOPS	BC	CONCORD	ON			104.81	28.39	22.36	20.73	19.15	13.78
76	KAMLOOPS	BC	LAVAL	QC			113.29	38.07	34.51	32.49	31.02	19.65
77	KELOWNA	BC	CONCORD	ON			104.81	27.99	22.14	20.56	19.07	13.82
78	KELOWNA	BC	LAVAL	QC			113.29	36.48	32.93	30.88	29.44	18.64
79	NANAIMO	BC	CONCORD	ON			90.69	28.38	23.03	21.56	20.31	14.83
80	PENTICTON	BC	CONCORD	ON			80.97	28.23	22.36	20.80	19.29	13.97
81	VANCOUVER	BC	CONCORD	ON			104.81	27.29	23.21	20.80	19.15	14.49
82	VANCOUVER	BC	LAVAL	QC			113.29	38.49	34.71	31.24	29.13	19.34
83	VICTORIA	BC	CONCORD	ON			121.70	28.77	23.32	21.85	20.59	15.03
84	VICTORIA	BC	LAVAL	QC			130.19	41.65	37.54	34.00	31.74	20.99
85	WHISTLER	BC	CONCORD	ON			80.97	28.02	23.95	21.53	19.89	15.09
86	MITCHELL	MB	CONCORD	ON			66.93	18.83	13.99	12.55	11.47	8.12
87	WINKLER	MB	CONCORD	ON			66.93	19.17	14.34	12.90	11.81	8.39
88	WINNIPEG	MB	CALGARY	AB			79.45	24.94	18.30	18.11	16.98	11.01
89	WINNIPEG	MB	EDMONTON	AB			79.45	23.81	17.80	17.63	16.61	10.73
90	WINNIPEG	MB	RED DEER	AB			79.45	27.24	20.61	20.39	19.28	12.58
91	WINNIPEG	MB	KAMLOOPS	BC			87.93	34.54	27.18	26.78	25.49	16.64
92	WINNIPEG	MB	KELOWNA	BC			87.93	32.23	24.88	24.51	22.99	15.09
93	WINNIPEG	MB	VANCOUVER	BC			104.81	34.79	28.51	26.55	24.62	16.50
94	WINNIPEG	MB	VICTORIA	BC			104.81	38.43	31.74	29.79	27.69	18.39
95	WINNIPEG	MB	WINNIPEG	MB			62.14	9.74	4.22	4.12	3.68	2.16
96	WINNIPEG	MB	CONCORD	ON			87.93	18.41	13.57	12.13	11.05	7.80
97	WINNIPEG	MB	OTTAWA	ON			87.93	23.00	19.59	17.33	15.87	10.03
98	WINNIPEG	MB	LAVAL	QC			96.37	24.33	21.10	19.15	17.83	11.28
99	WINNIPEG	MB	REGINA	SK			71.01	16.81	10.93	10.78	9.81	6.22
100	WINNIPEG	MB	SASKATOON	SK			71.01	18.37	12.59	12.46	11.51	7.24
101	ALMA	NB	CONCORD	ON			62.08	15.09	10.51	9.11	7.92	5.35
102	BATHURST	NB	CONCORD	ON			64.77	17.02	12.16	10.73	9.36	6.39
103	BLACKVILLE	NB	CONCORD	ON			64.77	17.42	12.54	11.13	9.76	6.69
104	CAMPBELLTON	NB	CONCORD	ON			64.77	17.30	12.45	11.02	9.64	6.62
105	CHATHAM	NB	CONCORD	ON			64.77	17.23	12.37	10.93	9.56	6.56
106	CHIPMAN	NB	CONCORD	ON			64.77	16.23	11.66	10.32	9.11	6.36
107	DOAKTOWN	NB	CONCORD	ON			64.77	16.30	11.73	10.38	9.17	6.39
108	EDMUNDSTON	NB	CONCORD	ON			64.77	16.28	11.71	10.34	9.10	6.30
109	FREDERICTON	NB	CONCORD	ON			64.77	15.97	11.40	10.04	8.85	6.14
110	GAGETOWN	NB	CONCORD	ON			64.77	16.17	11.60	10.24	9.05	6.30
111	GRAND FALLS	NB	CONCORD	ON			64.77	13.97	10.11	8.87	8.01	5.66
112	HARTLAND	NB	CONCORD	ON			64.77	13.65	9.79	8.55	7.68	5.43
113	KEDGWICK	NB	CONCORD	ON			86.15	21.60	16.86	12.83	10.41	7.63
114	MCADAM	NB	CONCORD	ON			64.77	16.23	11.66	10.32	9.11	6.36
115	MILLVILLE	NB	CONCORD	ON			64.77	13.78	9.92	8.69	7.82	5.53
116	MONCTON	NB	CONCORD	ON			62.08	14.83	10.24	8.86	7.65	5.16
117	PETITCODIAC	NB	CONCORD	ON			62.08	14.96	10.36	8.97	7.76	5.25
118	PORT ELGIN	NB	CONCORD	ON			62.08	15.02	10.42	9.04	7.83	5.29
119	RICHIBUCTO	NB	CONCORD	ON			62.08	15.02	10.42	9.04	7.83	5.29
120	ROGERSVILLE	NB	CONCORD	ON			62.08	15.04	10.46	9.07	7.87	5.33
121	SACKVILLE	NB	CONCORD	ON			62.08	14.93	10.34	8.95	7.73	5.24