Cascade Build · revised scope — fuel wording plus extra-trip wording,
the Return Trip category and the Viaje extra checkbox ·
pay dates 2024-09 to 2026-08 · generated September 1, 2026
Scope correction — the first pass undercounted by 2,173 adjustments
The original analysis matched only fuel words (gas, gasolina, diésel, millas).
That missed most of the money, for three reasons:
Crews write about the trip, not the fuel.regresar, viaje,
lejos, vuelta, dos veces — 2,036 adjustments use
travel wording with no fuel word anywhere.
There is a structured Spanish field the first pass never read.Jobs Tasks :: Tipo de Ajuste (field 4589) is a crew-facing checkbox whose four choices are
Diferencias con los planos, Reparaciones, Dificultad extremo, and literally
Viaje extra. So yes — extra trip is already a first-class category that crews
tick. It is not present in the nightly full export at all, only in the live recent view, which is
why it was invisible.
The office has its own travel category.Return Trip on
Payroll Adjustment Category (field 6491) — 244 adjustments, $21,364.
Text matching alone also misses 94 adjustments where the crew ticked
Viaje extra but wrote no trip word — "3 idas a la casa", "yo vengo desde salt lake",
and the misspelling "biaje". Those are now included.
Overlaps: Return Trip ∩ fuel = 84;
Return Trip ∩ trip-text = 164;
Viaje extra ∩ fuel = 74.
The combined population is 3,382 adjustments worth $520,420 —
3.3× the dollars the first pass reported.
Top wording variants
Wording
All matches
New to this pass
regresar
466
378
viaje
368
344
lejos
254
180
trip charge
156
148
viajes
147
132
regresamos
109
101
distance
107
87
vuelta
100
65
viaje extra
86
74
dos veces
76
63
travel
67
50
regrese
61
55
regreso
59
49
drive
58
42
ida
58
25
go back
54
53
distancia
53
31
vueltas
47
40
otra vez
42
36
came back
37
34
far
36
23
idas
35
28
2. Combined headline
Fuel-only (v1)
Combined travel pay
Paid adjustments
1,009
2,666
Median
$70.00
$90.00
Mean
$154.98
$195.21
p75
$125.00
$170.00
p90
$289.04
$380.00
Maximum
$4,659.00
$11,000.00
Total paid
$156,374.43
$520,420.08
% of all 60,995 task-pay rows
2.0%
5.5%
Is this fuel, or labour for a second visit?
It is mostly the second, and that changes the rule design. Only
725 adjustments are fuel-worded with no trip language;
1,389 are the reverse.
Component
Adj
%
trip only
1,389
41.1%
flagged by category only
1,009
29.8%
fuel only
725
21.4%
both
259
7.7%
Cause
Adj
%
Fuel wording only
1,751
51.8%
Trip / distance, no cause stated
1,002
29.6%
Return for warranty / rework
365
10.8%
Return caused by site/material not ready
264
7.8%
The standardisation rule needs two components, not one
264 adjustments say the crew
returned because the site or the material was not ready — that is not a fuel cost, it is a wasted
half-day someone else caused, and pricing it per-mile would underpay it badly. Meanwhile
725 are genuine commute-fuel top-ups.
Fuel by distance + a flat second-visit fee is what the data actually describes. The last row of
the rule table below models exactly that.
3. Division comparison
Division
Travel adj
All tasks
Rate
Total $
Mean $
Median dist
% return-trip
% Unclear/Defer
Fuel-only adj
Fuel-only $
Ogden
634
4,578
13.85%
$74,676
$146
44.5
17.4%
61.8%
379
$40,403
Orem
1,727
32,998
5.23%
$251,229
$183
17.0
17.8%
5.3%
504
$66,135
Salt Lake
645
12,656
5.10%
$99,819
$195
14.2
16.3%
10.5%
222
$28,806
St. George
308
8,635
3.57%
$66,209
$296
6.7
17.5%
15.9%
86
$17,793
Ogden's rate stays the highest on the wider definition, but the gap narrows sharply once
extra-trip pay is counted — the first pass overstated how much of an outlier it was, because
Ogden is where the fuel vocabulary is used, not where all the travel pay is.
4. Areas (combined)
Area
Travel adj
All tasks
Rate
Total $
Mean $
Median dist
Fuel-only
Other
1
1
100.00%
$900
$900
43.6
0
Box Elder/Cache County
293
1,376
21.29%
$21,434
$86
43.7
213
Western Colorado
23
109
21.10%
$4,809
$321
229.5
18
Eastern Idaho
14
80
17.50%
$8,267
$827
145.7
11
Wasatch County
140
1,059
13.22%
$35,242
$299
30.9
41
Iron County
47
378
12.43%
$18,505
$500
45.0
35
Tooele County
134
1,280
10.47%
$13,546
$119
33.5
68
Davis/Weber/Morgan County
304
3,013
10.09%
$40,166
$167
43.9
137
South Utah County
557
9,542
5.84%
$63,765
$145
17.7
164
North Utah County
299
5,829
5.13%
$38,615
$158
12.0
88
West Utah County
546
11,841
4.61%
$59,520
$143
13.6
178
South Salt Lake County
412
9,056
4.55%
$69,399
$219
11.1
126
North Salt Lake County
99
2,320
4.27%
$16,875
$208
22.1
28
North East Utah County
86
2,106
4.08%
$21,078
$281
20.3
18
Central Utah County
98
2,620
3.74%
$32,108
$396
18.7
15
Southern Utah
261
8,257
3.16%
$47,704
$255
5.2
51
5. Crew size
Crew
Adj
Mean $
Median $
$ per person
1
445
$219
$120
$219
2
537
$150
$80
$75
3
468
$156
$75
$52
4
617
$209
$84
$52
5
326
$147
$80
$29
6
249
$143
$80
$24
7+
379
$298
$125
—
6. Task type
Task
Adj
Total $
Mean $
Avg crew
Median dist
Fuel-only
VPO Work
606
$132,256
$236
3.81
13.9
141
Misc. Work
393
$99,670
$269
3.07
25.2
159
Paper/Wire
262
$15,338
$69
3.88
15.3
111
Warranty Work
205
$43,630
$237
3.01
12.9
34
Soffit/Fascia
188
$24,569
$181
2.96
24.0
102
Rock
188
$11,240
$76
3.10
25.2
65
Siding
166
$24,592
$200
5.00
28.8
69
Fix Scaff
161
$13,255
$123
5.11
14.4
36
Set Scaff
141
$14,250
$126
5.99
25.5
49
Stucco Color
132
$8,999
$97
5.28
17.0
45
Housewrap
129
$7,442
$85
4.90
14.6
48
Paint
119
$14,217
$155
4.20
26.6
70
Stucco Brown
101
$4,738
$72
5.74
15.1
57
Remove Scaff
84
$8,794
$137
5.62
19.2
26
Return/Fix
83
$6,305
$117
3.95
22.3
34
Brick
67
$8,499
$177
6.00
24.8
24
7. Reason themes
Theme
Adj
%
Mean $
Total $
Return / second trip
1,432
42.3%
$209
$262,728
Fuel wording present
984
29.1%
$148
$131,306
Long distance / far job
505
14.9%
$181
$70,459
Warranty / repair callback
402
11.9%
$219
$74,323
Site or material not ready
264
7.8%
$240
$53,217
Office 'trip charge'
151
4.5%
$199
$17,896
Equipment fuel
4
0.1%
$148
$590
CM disposition
Evaluation
Adj
%
Valid Request
1,290
38.1%
(not evaluated)
975
28.8%
Unclear - Defer to Office
567
16.8%
Valid Request, but request too high
316
9.3%
Not a Valid Request
145
4.3%
Needs Additional Info (Notify Team)
28
0.8%
Valid Request, Unclear - Defer to Office
25
0.7%
Valid Request, Valid Request, but request too high
8
0.2%
Category
Category
Adj
(none)
1,367
Valid Request
1,000
Grasping
791
Return Trip
244
Low Pay Adjustment
143
Standard Adjustment
110
VPO
60
Estimation Error
21
Misc
14
No Details
11
8. Team-leader outliers
15+ adjustments, ranked by ratio to their own area's mean.
Leader
Area
Adj
Total $
Mean $
Std dev
Area mean
Ratio
Kevin Nehemias
Box Elder/Cache County
29
$6,932
$257
$422
$86
2.97x
William Portio
South Utah County
15
$5,497
$423
$522
$145
2.92x
Alejandro Huerta
South Utah County
38
$15,395
$416
$336
$145
2.88x
Rafael Moguel
Southern Utah
39
$19,750
$705
$2,029
$255
2.77x
Otilio Martinez
Box Elder/Cache County
20
$4,199
$233
$249
$86
2.70x
Francisco Dominguez Hernandez
West Utah County
69
$24,900
$372
$374
$143
2.59x
Guillermo Mondragon
West Utah County
220
$68,710
$362
$600
$143
2.52x
Oscar Ibarra
South Salt Lake County
70
$35,747
$511
$419
$219
2.33x
Cristian Bermudes
South Utah County
65
$15,782
$316
$461
$145
2.18x
David Merino
Box Elder/Cache County
16
$2,228
$186
$280
$86
2.15x
Juan Rivera
Box Elder/Cache County
16
$2,514
$180
$199
$86
2.08x
Keren Avila Herrera
South Salt Lake County
16
$4,950
$354
$487
$219
1.62x
9. Rule simulation — combined population
Do not read these deltas as savings
On the combined population the "actual" column is the wholeAdditional Pay Amount, which bundles the work itself — the repair, the extra scope,
the ladders — with the travel. A travel-only rule priced against it will always look like a huge
cut, because it is not paying for the work. These rows show the shape and relative ranking of the
rules, not a budget. The only clean like-for-like base is the 429 fuel-only requests in the previous
version of this report, where the adjustment really was just the fuel. Separating the travel portion
from the work portion across all 3,382 rows needs the structured fuel/trip amount fields that do
not yet exist — that is the gap, and it is why this stays a jumping-off point rather than a
costed proposal.
Base: paid adjustments in the combined population, actual $520,420.
Tiers by median derived distance — A under 15 mi, B 15–35 mi, C 35 mi+.
Rule
Priced
Modeled
Actual
Delta
Delta %
Mean/adj
More/Less
Tier $25/$50/$85
2,666
$123,435
$520,420
$-396,985
-76%
$46
484/2117
Tier $35/$70/$120
2,666
$173,355
$520,420
$-347,065
-67%
$65
742/1868
Tier $50/$95/$160
2,666
$236,605
$520,420
$-283,815
-55%
$89
1087/1435
$1.50/mi RT, 10-mi free
2,150
$108,917
$398,526
$-289,609
-73%
$51
454/1695
$2.00/mi RT, 15-mi free
2,150
$118,985
$398,526
$-279,541
-70%
$55
452/1698
$25/head cap 5
2,666
$203,200
$520,420
$-317,220
-61%
$76
983/1585
$40/head cap 5
2,666
$325,120
$520,420
$-195,300
-38%
$122
1426/1131
$20/head cap 5 + $60 return fee
2,666
$190,400
$520,420
$-330,020
-63%
$71
892/1625
Same rules on the fuel-only subset (for comparison)
Rule
Priced
Modeled
Actual
Delta
Delta %
Mean/adj
More/Less
Tier $25/$50/$85
1,009
$53,710
$156,374
$-102,664
-66%
$53
297/687
Tier $35/$70/$120
1,009
$75,550
$156,374
$-80,824
-52%
$75
419/573
Tier $50/$95/$160
1,009
$102,435
$156,374
$-53,939
-34%
$102
559/384
$1.50/mi RT, 10-mi free
825
$47,751
$119,299
$-71,549
-60%
$58
248/576
$2.00/mi RT, 15-mi free
825
$53,013
$119,299
$-66,286
-56%
$64
248/577
$25/head cap 5
1,009
$68,650
$156,374
$-87,724
-56%
$68
421/550
$40/head cap 5
1,009
$109,840
$156,374
$-46,534
-30%
$109
585/394
$20/head cap 5 + $60 return fee
1,009
$63,800
$156,374
$-92,574
-59%
$63
377/580
10. Per-division rule deltas
Division
Actual $
Tier $25/$50/$85
Tier $35/$70/$120
$25/head cap 5
$20/head cap 5 + $60 return fee
Ogden
$78,533
$-35,353 (-45%)
$-17,573 (-22%)
$-40,458 (-52%)
$-43,573 (-55%)
Salt Lake
$102,708
$-85,208 (-83%)
$-78,208 (-76%)
$-66,808 (-65%)
$-68,948 (-67%)
Orem
$259,517
$-207,657 (-80%)
$-186,912 (-72%)
$-156,392 (-60%)
$-161,657 (-62%)
St. George
$66,428
$-58,633 (-88%)
$-55,478 (-84%)
$-44,578 (-67%)
$-46,368 (-70%)
Red = the rule pays more than today; green = it pays less.
11. Per-division detail
Ogden
634
Travel adjustments
$78,533
Paid
379
Of which fuel-worded
$80
Median
Distribution (combined vs fuel-only)
Measure
Combined
Fuel-only
Median
$80.00
$70.00
Mean
$154.59
$123.18
p75
$140.96
$107.73
p90
$277.25
$200.00
Max
$4,156.80
$4,156.80
Crew size
Crew
Adj
Mean $
$/person
1
121
$110
$110
2
46
$192
$96
3
89
$191
$64
4
94
$161
$40
5
39
$179
$36
6
113
$96
$16
7+
40
$178
—
Monthly trend
Month
Adj
Total $
Fuel-worded
2025-06
2
$225
1
2025-07
3
$560
1
2025-08
4
$320
2
2025-09
23
$6,345
5
2025-10
8
$675
3
2025-11
7
$2,045
6
2025-12
19
$5,847
2
2026-01
42
$7,210
5
2026-02
56
$6,400
22
2026-03
53
$12,499
32
2026-04
71
$8,833
50
2026-05
63
$7,222
44
2026-06
52
$5,883
43
2026-07
85
$4,164
63
2026-08
146
$6,449
100
Areas within Ogden
Area
Adj
All tasks
Rate
Total $
Mean $
Med dist
Box Elder/Cache County
293
1,376
21.29%
$21,434
$86
43.7
Western Colorado
23
109
21.10%
$4,809
$321
229.5
Eastern Idaho
14
80
17.50%
$8,267
$827
145.7
Davis/Weber/Morgan County
304
3,013
10.09%
$40,166
$167
43.9
Task type
Task
Adj
Total $
Mean $
Set Scaff
69
$4,990
$83
Misc. Work
65
$12,751
$213
Paint
61
$9,053
$174
Soffit/Fascia
58
$8,305
$213
Siding
52
$8,863
$197
VPO Work
42
$5,747
$151
Remove Scaff
42
$2,640
$75
Stucco Color
27
$1,716
$82
Reason themes
Theme
Adj
%
Fuel wording present
325
51.3%
Return / second trip
180
28.4%
Long distance / far job
161
25.4%
Warranty / repair callback
25
3.9%
Site or material not ready
18
2.8%
Office 'trip charge'
7
1.1%
CM disposition
Evaluation
Adj
%
Unclear - Defer to Office
380
59.9%
Valid Request
174
27.4%
(not evaluated)
57
9.0%
Valid Request, Unclear - Defer to Office
12
1.9%
Not a Valid Request
6
0.9%
Valid Request, but request too high
3
0.5%
Top 5 leaders by total $
Leader
Adj
Total $
Mean $
vs div
Kevin Nehemias
26
$6,677
$278
1.80x
Juan Pablo Moreno
65
$6,235
$108
0.70x
Cristian Bermudes
8
$5,262
$658
4.25x
Otilio Martinez
19
$3,749
$221
1.43x
Euddy Enrique Rodriguez-Chima
20
$3,135
$157
1.01x
Salt Lake
645
Travel adjustments
$102,708
Paid
222
Of which fuel-worded
$90
Median
Distribution (combined vs fuel-only)
Measure
Combined
Fuel-only
Median
$90.00
$60.00
Mean
$202.58
$163.67
p75
$165.00
$150.00
p90
$406.00
$300.00
Max
$3,180.00
$2,040.00
Crew size
Crew
Adj
Mean $
$/person
1
99
$264
$264
2
114
$148
$74
3
105
$123
$41
4
116
$301
$75
5
39
$136
$27
6
57
$156
$26
7+
45
$300
—
Monthly trend
Month
Adj
Total $
Fuel-worded
2024-09
10
$5,260
0
2024-10
15
$1,225
5
2024-11
18
$127
2
2024-12
10
$665
4
2025-01
10
$950
4
2025-02
22
$3,665
5
2025-03
15
$530
6
2025-04
12
$545
4
2025-05
33
$6,570
17
2025-06
12
$1,455
4
2025-07
21
$977
9
2025-08
20
$1,560
7
2025-09
12
$805
6
2025-10
19
$1,077
4
2025-11
14
$1,380
1
2025-12
24
$6,758
7
2026-01
29
$11,865
6
2026-02
26
$5,382
11
2026-03
34
$5,996
13
2026-04
47
$9,646
11
2026-05
56
$6,155
18
2026-06
39
$7,460
17
2026-07
71
$8,786
30
2026-08
76
$10,979
31
Areas within Salt Lake
Area
Adj
All tasks
Rate
Total $
Mean $
Med dist
Tooele County
134
1,280
10.47%
$13,546
$119
33.5
South Salt Lake County
412
9,056
4.55%
$69,399
$219
11.1
North Salt Lake County
99
2,320
4.27%
$16,875
$208
22.1
Task type
Task
Adj
Total $
Mean $
VPO Work
138
$33,340
$263
Misc. Work
78
$14,760
$208
Rock
49
$2,630
$67
Paper/Wire
48
$5,571
$136
Warranty Work
45
$8,730
$230
Housewrap
35
$1,981
$76
Soffit/Fascia
33
$2,309
$89
Fix Scaff
25
$1,825
$114
Reason themes
Theme
Adj
%
Return / second trip
279
43.3%
Fuel wording present
174
27.0%
Warranty / repair callback
83
12.9%
Long distance / far job
82
12.7%
Site or material not ready
51
7.9%
Office 'trip charge'
30
4.7%
CM disposition
Evaluation
Adj
%
Valid Request
295
45.7%
(not evaluated)
210
32.6%
Unclear - Defer to Office
56
8.7%
Valid Request, but request too high
54
8.4%
Not a Valid Request
14
2.2%
Valid Request, Unclear - Defer to Office
10
1.6%
Top 5 leaders by total $
Leader
Adj
Total $
Mean $
vs div
Guillermo Mondragon
44
$21,265
$560
2.76x
Oscar Ibarra
25
$13,457
$538
2.66x
Francisco Dominguez Hernandez
14
$7,070
$544
2.68x
Alejandro Huerta
9
$5,705
$634
3.13x
Alvaro Castro
15
$2,905
$208
1.02x
Orem
1,727
Travel adjustments
$259,517
Paid
504
Of which fuel-worded
$90
Median
Distribution (combined vs fuel-only)
Measure
Combined
Fuel-only
Median
$90.00
$70.00
Mean
$189.98
$158.98
p75
$180.00
$120.00
p90
$380.00
$305.00
Max
$9,784.70
$3,300.00
Crew size
Crew
Adj
Mean $
$/person
1
200
$238
$238
2
350
$142
$71
3
241
$154
$51
4
373
$190
$48
5
210
$142
$28
6
69
$200
$33
7+
140
$250
—
Monthly trend
Month
Adj
Total $
Fuel-worded
2024-09
30
$2,495
5
2024-10
27
$1,769
13
2024-11
61
$-149
15
2024-12
33
$3,865
8
2025-01
20
$2,375
6
2025-02
24
$2,410
4
2025-03
39
$6,398
4
2025-04
51
$4,490
8
2025-05
96
$12,780
39
2025-06
80
$13,330
25
2025-07
72
$6,978
26
2025-08
97
$6,012
26
2025-09
74
$6,965
24
2025-10
80
$27,584
17
2025-11
64
$13,530
17
2025-12
63
$9,445
21
2026-01
67
$6,960
18
2026-02
78
$9,469
24
2026-03
73
$13,574
22
2026-04
90
$12,935
32
2026-05
115
$21,806
54
2026-06
93
$18,214
23
2026-07
134
$21,489
39
2026-08
166
$26,504
34
Areas within Orem
Area
Adj
All tasks
Rate
Total $
Mean $
Med dist
Other
1
1
100.00%
$900
$900
43.6
Wasatch County
140
1,059
13.22%
$35,242
$299
30.9
South Utah County
557
9,542
5.84%
$63,765
$145
17.7
North Utah County
299
5,829
5.13%
$38,615
$158
12.0
West Utah County
546
11,841
4.61%
$59,520
$143
13.6
North East Utah County
86
2,106
4.08%
$21,078
$281
20.3
Central Utah County
98
2,620
3.74%
$32,108
$396
18.7
Task type
Task
Adj
Total $
Mean $
VPO Work
366
$72,477
$212
Misc. Work
218
$55,091
$262
Paper/Wire
168
$5,746
$38
Warranty Work
148
$31,925
$235
Rock
112
$5,695
$61
Fix Scaff
105
$6,200
$94
Soffit/Fascia
94
$13,425
$197
Siding
66
$9,980
$263
Reason themes
Theme
Adj
%
Return / second trip
825
47.8%
Fuel wording present
411
23.8%
Warranty / repair callback
243
14.1%
Long distance / far job
220
12.7%
Site or material not ready
160
9.3%
Office 'trip charge'
90
5.2%
CM disposition
Evaluation
Adj
%
Valid Request
719
41.6%
(not evaluated)
547
31.7%
Valid Request, but request too high
222
12.9%
Not a Valid Request
106
6.1%
Unclear - Defer to Office
83
4.8%
Needs Additional Info (Notify Team)
19
1.1%
Top 5 leaders by total $
Leader
Adj
Total $
Mean $
vs div
Guillermo Mondragon
152
$39,115
$294
1.55x
Oscar Ibarra
35
$18,102
$517
2.72x
Francisco Dominguez Hernandez
53
$17,370
$334
1.76x
Alvaro Castro
69
$15,190
$230
1.21x
Alejandro Huerta
29
$9,690
$346
1.82x
St. George
308
Travel adjustments
$66,428
Paid
86
Of which fuel-worded
$110
Median
Distribution (combined vs fuel-only)
Measure
Combined
Fuel-only
Median
$110.00
$80.00
Mean
$297.88
$250.60
p75
$250.00
$190.00
p90
$540.00
$440.00
Max
$11,000.00
$4,659.00
Crew size
Crew
Adj
Mean $
$/person
1
7
$643
$643
2
17
$193
$96
3
21
$215
$72
4
10
$306
$77
5
35
$166
$33
6
10
$356
$59
7+
153
$376
—
Monthly trend
Month
Adj
Total $
Fuel-worded
2024-10
4
$1,250
1
2024-11
9
$785
0
2024-12
3
$340
1
2025-01
12
$2,530
1
2025-02
11
$1,040
3
2025-03
9
$1,870
1
2025-04
6
$280
2
2025-05
13
$2,240
4
2025-06
17
$1,515
5
2025-07
13
$2,385
1
2025-08
14
$1,961
6
2025-09
18
$14,211
2
2025-10
27
$4,402
10
2025-11
20
$2,860
4
2025-12
18
$2,676
7
2026-01
38
$5,630
15
2026-02
19
$5,430
5
2026-03
11
$1,140
6
2026-04
6
$610
3
2026-05
17
$3,336
4
2026-06
5
$50
1
2026-07
7
$5,475
1
2026-08
11
$4,193
3
Areas within St. George
Area
Adj
All tasks
Rate
Total $
Mean $
Med dist
Iron County
47
378
12.43%
$18,505
$500
45.0
Southern Utah
261
8,257
3.16%
$47,704
$255
5.2
Task type
Task
Adj
Total $
Mean $
VPO Work
36
$14,989
$454
Stucco Color
33
$3,285
$137
Siding
28
$2,220
$85
Paper/Wire
23
$3,966
$283
Set Scaff
21
$1,816
$130
Misc. Work
17
$14,665
$978
Paint
17
$1,905
$136
Housewrap
16
$2,397
$200
Reason themes
Theme
Adj
%
Return / second trip
117
38.0%
Fuel wording present
63
20.5%
Long distance / far job
38
12.3%
Warranty / repair callback
35
11.4%
Site or material not ready
30
9.7%
Office 'trip charge'
20
6.5%
CM disposition
Evaluation
Adj
%
(not evaluated)
122
39.6%
Valid Request
77
25.0%
Unclear - Defer to Office
46
14.9%
Valid Request, but request too high
37
12.0%
Not a Valid Request
17
5.5%
Needs Additional Info (Notify Team)
5
1.6%
Top 5 leaders by total $
Leader
Adj
Total $
Mean $
vs div
Rafael Moguel
39
$19,750
$705
2.37x
Anthony Alvarez-Tenorio
7
$8,908
$1,782
5.98x
Armando Segundo-Garcia
70
$8,890
$143
0.48x
Jaime Mata Sánchez
23
$3,715
$310
1.04x
Luis Estrada Puertos
23
$3,020
$178
0.60x
12. Data gaps
No distance or mileage field anywhere on Jobs or Jobs Tasks. Distances here are derived
(team last-known location → job lat/long) and cover
2,757 of 3,382 rows.
Tipo de Ajuste (field 4589) is missing from the nightly full export. Only
316 of 3,382 combined rows have a known value, so every
Viaje extra figure here is a floor, not a total. 138 further Viaje extra rows
exist in the live view but are too recent for the export. Getting this column into the export is the
single cheapest fix in this report.
The two travel categories do not agree.Viaje extra (crew, Spanish) and
Return Trip (office, English) overlap on only a handful of records — they are
recorded independently and neither is reliable alone.
Fuel and trip money share one payout field (Additional Pay Amount), so neither
can be capped or reported independently.
Crew size is not stored per task — taken from the team's current roster.
Not yet computed: subdivision-level tables within each division, and a
requested-vs-granted comparison on the new extra-trip rows. Both are available from the cached data
but were dropped for turnaround.