OverviewDailyWeeklyTechniciansTech Overview

Repair Logs

synced 8d 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%
8No Problem 89.8%
9Error 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 StiffNo ProblemErrorAper InopVR InopIS Inop
Remy 1261071392104254
Marlo 13011415145981323
Indigo 921241672013137326
Onyx 7781962121
Shay 48401232
Tatum 752
Hollis 131131
Noa 12321131
Harlow34 96212
Sam 78
Devon 242122
Dell 510
Harlow 38111
Nico 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 8No Problem 5 h 16 9Error 18 h 16 10Aper Inop 22 h 15 11VR Inop 22 h 14 12IS Inop 8 h 11 13Parts Loose 2 h 6 14Focus Loose 6 h 6 15Zoom Stiff 4 h 5
Useful?
By Technician 15 shown
1Remy 304 h 344 2Marlo 383 h 317 3Indigo 297 h 306 4Onyx 255 h 231 5Shay 174 h 114 6Tatum 132 h 64 7Hollis 6 h 30 8Noa 16 h 25 9Harlow34 51 h 23 10Sam 4 h 19 11Devon 49 h 19 12Dell 13 h 17 13Harlow 10 h 14 14Nico 12 h 13 15Eden 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 11Research/Troubleshooting Help 1 h 1 12Re-estimate 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 12Tokina 7 h 5 13Contax 7 h 5 14Mamiya 2 h 3 15Leica 4 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?