ABCDEFGHIJKLMNOPQRSTUVWX
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 RouteGoogle API Cost for One RouteMonthly Cost for 20 RoutesMonthly Cost for 30 RoutesMonthly Cost for 40 RoutesMonthly Cost for 60 Routes
6
Enter Number of Stops:255\$0.197\$3.94\$5.91\$7.88\$11.82
7
Enter Number of Routes/Month5810\$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 APIGoogle Pricing per 1000 calls# of API Calls required for above routeCost of Google API Calls for above route20\$2.22\$44.44\$66.66\$88.88\$133.32
10
11
Distance Matrix (to compute time and distances between stops)\$5.00650\$3.25030\$4.82\$96.44\$144.66\$192.88\$289.32
12
Directions Advanced (driving directions for selected route)\$10.001\$0.01035\$6.50\$129.94\$194.91\$259.88\$389.82
13
Dynamic Maps (display map for selected route)\$7.001\$0.00740\$8.42\$168.44\$252.66\$336.88\$505.32
14
Total Cost for One Route Calculation
\$3.39745\$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.026areas 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
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