OverviewDailyWeeklyTechniciansTech Overview

Repair Logs

synced 9d ago
1,576
Logged Rows
1,218
Unique Items
23
Technicians
1,787
Labor Hours
from 1,550 rows (98%)
32
Search Hours
from 120 rows (8%)
$15.8k
Parts Cost
from 168 rows (11%)
Clear 1
CodeR02 ×
2025-01-02 → 2026-09-16· 69 min avg/job· 23 brands
Volume by Month hover a column for hours and cost
50
25-01
86
25-02
86
25-03
79
25-04
67
25-05
43
25-06
70
25-07
75
25-08
79
25-09
112
25-10
97
25-11
70
25-12
50
26-01
57
26-02
66
26-03
59
26-04
73
26-05
100
26-06
95
26-07
118
26-08
44
26-09
Useful?
Parts Hold Watchlist 139 jobs waiting on parts
139
Jobs Held
126
Items Held
$3,471
Parts Value
By Brand
1Canon 34.5% 48 search
2Sigma 20.9% 29 search
3Sony 14.4% 20 search
4Nikon 12.9% 18 search
5Tamron 9.4% 13 search
6Pentax 3.6% 5 search
By Part Needed
1VR Flex 1.4% 2 search
2Front Ring 1.4% 2 search
3CY3-2796-000 1.4% 2 search
4AF Motor 1.4% 2 search
5rear element 0.7% 1 search
6mirror box 0.7% 1 search
Useful?
Status Funnel where work accumulates
1 Quality Check 6.3% 94 search
2 Re-estimate 0.1% 1 search
3 Parts Hold 9.3% 139 search
4 Incomplete 0.5% 7 search
5 Complete 66.3% 990 search
6 Not Repaired 4.4% 65 search
7 Other 13.2% 197
Useful?
Fault Pareto 4 of 55 faults = 80% of work
1AF Erratic 38.1%
2AF inop 75.7%
3Impact Damage 79.2%
4Focus Squeek 82.2%
5Inop 84.9%
6Focus Rough 87.2%
7Focus Stiff 88.6%
8Error 89.8%
9No Problem 90.9%
10Aper Inop 91.9%
11VR Inop 92.9%
12IS Inop 93.7%
Useful?
Who Fixes What darker = more jobs
AF ErraticAF inopImpact DamageFocus SqueekInopFocus RoughFocus StiffErrorNo ProblemAper InopVR InopIS Inop
Larry 1261071392104254
Gabe 13011415145983123
Bryan 921241672013713326
Leo 7781962121
Umcolisi 48401232
Darryl 752
Kiersten 131131
Anthony 12321131
Scott34 96212
TK 78
Taylor 242122
Trent 510
Scott 38111
Ben 411111
Useful?
By Diagnosis what actually broke
1AF Erratic 567 h 543 2AF inop 638 h 536 3Impact Damage 52 h 49 4Focus Squeek 68 h 44 5Inop 42 h 38 6Focus Rough 29 h 32 7Focus Stiff 25 h 21 8Error 18 h 16 9No Problem 5 h 16 10Aper Inop 22 h 15 11VR Inop 22 h 14 12IS Inop 8 h 11 13Focus Loose 6 h 6 14Parts Loose 2 h 6 15Zoom Rough 3 h 5
Useful?
By Technician 15 shown
1Larry 304 h 344 2Gabe 383 h 317 3Bryan 297 h 306 4Leo 255 h 231 5Umcolisi 174 h 114 6Darryl 132 h 64 7Kiersten 6 h 30 8Anthony 16 h 25 9Scott34 51 h 23 10TK 4 h 19 11Taylor 49 h 19 12Trent 13 h 17 13Scott 10 h 14 14Ben 12 h 13 15Brice 13 h 10
Useful?
By Status 12 shown
1Complete 1,209 h 990 2Parts Hold 137 h 139 3AI - Ebay 86 h 117 4Quality Check 18 h 94 5Not Repaired 107 h 65 6OEM 28 h 28 7RP Gear 21 h 25 8Mod - Ebay 23 h 23 9Incomplete 10 h 7 10Kickback 2 h 3 11Re-estimate 1 h 1 12Research/Troubleshooting Help 1 h 1
Useful?
By Brand 15 shown
1Canon 547 h 491 2Nikon 614 h 447 3Sigma 182 h 183 4Tamron 172 h 171 5Sony 99 h 107 6Pentax 53 h 54 7Fujifilm 31 h 39 8Other 32 h 24 9Panasonic 11 h 18 10Olympus 5 h 7 11Zeiss 2 h 6 12Contax 7 h 5 13Tokina 7 h 5 14Leica 4 h 3 15Mamiya 2 h 3
Useful?
By Repair Code 1 shown
1R02 1,787 h 1,576
Useful?
By Discipline 5 shown
1Multidiscipline 727 h 634 2Lens 620 h 612 3Apprentice 374 h 259 4Digital 53 h 62 5Film 13 h 9
Useful?
By Repair Owner 5 shown
1KEH 1,716 h 1,524 2Training 67 h 46 3Redo 2 h 3 4Extend 1 h 1 5Customer 0 h 1
Useful?