Driving Route Planner Google API Cost Calculator

	A	B	C	D	F	G	H	I	J	K	X
1	Driving Route Planner Google API Cost Calculator				Costs for Selected Routes assuming Same Start and End Point						YES
2											NO
3	The following table computes the current* Google API costs based on the number of stops in your route.				The following table shows the Cost of the Google API Calls for Various Numbers of Stops assuming the same Start and End Point:
4
5	Same Start and End Point?	YES	<<< User input area to left. All other cells in this sheet are protected.		# of Stops Per Route	Google API Cost for One Route	Monthly Cost for 20 Routes	Monthly Cost for 30 Routes	Monthly Cost for 40 Routes	Monthly Cost for 60 Routes
6	Enter Number of Stops:	25			5	$0.197	$3.94	$5.91	$7.88	$11.82
7	Enter Number of Routes/Month	58			10	$0.622	$12.44	$18.66	$24.88	$37.32
8					15	$1.297	$25.94	$38.91	$51.88	$77.82
9	Name of Google API	Google Pricing per 1000 calls	# of API Calls required for above route	Cost of Google API Calls for above route	20	$2.22	$44.44	$66.66	$88.88	$133.32
10	Directions (for address lookup)	$5.00	26	$0.130	25	$3.40	$67.94	$101.91	$135.88	$203.82
11	Distance Matrix (to compute time and distances between stops)	$5.00	650	$3.250	30	$4.82	$96.44	$144.66	$192.88	$289.32
12	Directions Advanced (driving directions for selected route)	$10.00	1	$0.010	35	$6.50	$129.94	$194.91	$259.88	$389.82
13	Dynamic Maps (display map for selected route)	$7.00	1	$0.007	40	$8.42	$168.44	$252.66	$336.88	$505.32
14	Total Cost for One Route Calculation			$3.397	45	$10.60	$211.94	$317.91	$423.88	$635.82
15					50	$13.02	$260.44	$390.66	$520.88	$781.32
16
17	Total Monthly Cost for 58 Routes of 25 Stops			$197.026			areas in green above fall within Google's current $200/month credit
18							areas in yellow above would be charged for usage exceeding $200/month
19
20	Important Notes				Important Notes
21	* All Prices are in US Dollars				* All Prices are in US Dollars
22
23	* Prices current as of December 15, 2018 from:				* Prices current as of December 15, 2018 from:
24	https://cloud.google.com/maps-platform/pricing/sheet/				https://cloud.google.com/maps-platform/pricing/sheet/
25
26	* Google currently provides a free $200 monthly credit towards the above costs				* Google currently provides a free $200 monthly credit towards the above costs
27
28
29
30
31
32
33
34
35						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
36						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
37						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
38						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
39						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
40						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
41						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
42						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
43						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
44						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
45						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
46						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
47						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
48						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
49						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK			QWNMHNJMJMNKJKJKHKUBBJHKJJHJJHJJNKJHKHQWHJUBGJGHHHGHGJGGHGHGGHGHHGJKK
50						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
51						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
52						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
53						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
54						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
55						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
56						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
57						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
58						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
59						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
60						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
61						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
62						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
63						QWUBVHGJHJHJHJHJHHJJJJKHJHKHIIIJK
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100