ABCDEFGHIJKLMNOPQRSTUVW
1
2
Source: How to Automate Employee Cell Phone Data Usage Analysis with Google Sheets (Free Template)
3
July 2019 Wireless Charges Breakdown
4
5
Current ChargesData UsedMinutes Used
6
$1,250.0672.74 GB12,834
7
8
Previous MonthTop 5 Data UsersTop 5 Airtime Users
9
June 2019 Charges$1,223.19HAL HOOPER22.42 GBRYAN WILSON1,922
10
Amount Difference$26.87JEFF COLEMAN8.44 GBJOHN DOE1,598
11
% Difference2.2%DAN STONE6.78 GBJEFF COLEMAN1,427
12
Current Month Charges BreakdownSOPHIE SAL6.66 GBDAN STONE1,219
13
Monthly Access$674.49KATE HILL5.53 GBJANE DOE1,058
14
Equipment Charges$366.60Bottom 3 Data UsersBottom 3 Airtime Users
15
Usage / purchase charges$128.50GARY SMITH0.23 GBGARY SMITH64
16
Taxes, surcharges, fees$55.30JOE JOHNSON0.15 GBPAULA GOSSETT32
17
Surcharges and OC&Cs$25.17PAULA GOSSETT0.03 GBJOE JOHNSON5
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
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