Repair Logs

--:--

synced 8d ago

1,540

Logged Rows

1,069

Unique Items

1

Technicians

1,640

Labor Hours

from 1,502 rows (98%)

113

Search Hours

from 408 rows (26%)

$5,597

Parts Cost

from 314 rows (20%)

Clear 2

TechnicianShay × DisciplineApprentice ×

2025-01-15 → 2026-09-16· 66 min avg/job· 23 brands

Volume by Month hover a column for hours and cost

1

25-01

1

25-02

2

25-03

202

25-09

116

25-10

147

25-11

104

25-12

76

26-01

51

26-02

123

26-03

99

26-04

119

26-05

124

26-06

154

26-07

154

26-08

67

26-09

Useful?

Parts Hold Watchlist 126 jobs waiting on parts

126

Jobs Held

111

Items Held

$2,108

Parts Value

By Brand

1Canon 32.5% 41 search

2Nikon 31.7% 40 search

3Sigma 7.9% 10 search

4Tamron 5.6% 7 search

5Sony 4.8% 6 search

6Fujifilm 4% 5 search

By Part Needed

1Zoom Grip 0.8% 1 search

2Yb2-1192, YB2-1199 0.8% 1 search

3YH1-3006-000 0.8% 1 search

4YG@-0212-009 0.8% 1 search

5YG2-4392, YG2-4391, YG2-4407 0.8% 1 search

6YG2-3534-010, YG2-3538, YF2-2073 0.8% 1 search

Useful?

Status Funnel where work accumulates

1 Quality Check 0.2% 3 search

2 Re-estimate 0% 0 search

3 Parts Hold 9.5% 126 search

4 Incomplete 0% 0 search

5 Complete 78.9% 1,044 search

6 Not Repaired 7.4% 98 search

7 Other 4% 53

Useful?

Fault Pareto 20 of 181 faults = 80% of work

1Grip Loose 16.5%

2Weather Seal Damaged 30.6%

3Focus Stiff 36.4%

4AF inop 41.9%

5AF Erratic 47.1%

6Aper Inop 51.6%

7Zoom Stiff 54.8%

8Aper Sticky 57.8%

9Focus Rough 60.8%

10Aper Oily 63.7%

11Focus Squeek 66.3%

12Mount Damaged 68.6%

Useful?

Who Fixes What 12 single-tech faults · darker = more jobs

	Grip Loose	Weather Seal Damaged	Focus Stiff	AF inop	AF Erratic	Aper Inop	Zoom Stiff	Aper Sticky	Focus Rough	Aper Oily	Focus Squeek	Mount Damaged
Shay	216	185	76	72	68	59	42	40	39	38	34	30

Useful?

By Diagnosis what actually broke

1Grip Loose 60 h 216 2Weather Seal Damaged 60 h 185 3Focus Stiff 116 h 76 4AF inop 141 h 72 5AF Erratic 104 h 68 6Aper Inop 96 h 59 7Zoom Stiff 94 h 42 8Aper Sticky 42 h 40 9Focus Rough 56 h 39 10Aper Oily 60 h 38 11Focus Squeek 63 h 34 12Mount Damaged 22 h 30 13Parts Loose 25 h 28 14Impact Damage 18 h 25 15Zoom Rough 30 h 22

Useful?

By Technician 1 shown

1Shay 1,640 h 1,540

Useful?

By Status 9 shown

1Complete 1,072 h 1,044 2Parts Hold 204 h 126 3Not Repaired 164 h 98 4Kickback 13 h 24 5Mod - Ebay 32 h 21 6Quality Check 0 h 3 7Part Order 0 h 3 8AI - Ebay 3 h 3 9RP Gear 6 h 2

Useful?

By Brand 15 shown

1Canon 466 h 499 2Nikon 625 h 440 3Tamron 65 h 79 4Sigma 81 h 74 5Sony 62 h 61 6Pentax 51 h 39 7Olympus 39 h 32 8Fujifilm 22 h 26 9Zeiss 21 h 12 10Minolta 23 h 12 11Other 17 h 10 12Contax 8 h 9 13Panasonic 2 h 8 14Hasselblad 0 h 4 15Yashica 1 h 3

Useful?

By Repair Code 15 shown

1R01 478 h 308 2GRIPL 80 h 226 3R22 337 h 216 4SEAL 61 h 181 5R20 195 h 135 6R02 174 h 114 7R25 38 h 24 8R24 17 h 22 9R13 16 h 19 10R03 20 h 13 11FILTR 9 h 12 12R23 19 h 10 13QC 0 h 3 14SEAL, R20 2 h 2 15Rebuild (RP) 5 h 2

Useful?

By Discipline 1 shown

1Apprentice 1,640 h 1,540

Useful?

By Repair Owner 7 shown

1KEH 1,438 h 1,318 2Training 89 h 27 3Admin 16 h 21 4Redo 4 h 6 5Internal 5 h 6 6Customer 1 h 5 7CPR 0 h 1

Useful?