Repair Logs

--:--

synced 8d ago

308

Logged Rows

225

Unique Items

1

Technicians

478

Labor Hours

from 300 rows (97%)

38

Search Hours

from 125 rows (41%)

$2,516

Parts Cost

from 57 rows (19%)

Clear 2

TechnicianShay × CodeR01 ×

2025-03-09 → 2026-09-16· 96 min avg/job· 16 brands

Volume by Month hover a column for hours and cost

1

25-03

7

25-10

16

25-11

34

25-12

30

26-01

17

26-02

32

26-03

31

26-04

32

26-05

36

26-06

39

26-07

20

26-08

13

26-09

Useful?

Parts Hold Watchlist 47 jobs waiting on parts

47

Jobs Held

41

Items Held

$1,532

Parts Value

By Brand

1Canon 44.7% 21 search

2Nikon 19.1% 9 search

3Sony 10.6% 5 search

4Zeiss 8.5% 4 search

5Sigma 4.3% 2 search

6Pentax 4.3% 2 search

By Part Needed

1Yb2-1192, YB2-1199 2.1% 1 search

2YH1-3006-000 2.1% 1 search

3YG@-0212-009 2.1% 1 search

4YG2-4392, YG2-4391, YG2-4407 2.1% 1 search

5YG2-3534-010, YG2-3538, YF2-2073 2.1% 1 search

6YG2-2482-000 2.1% 1 search

Useful?

Status Funnel where work accumulates

1 Quality Check 0% 0 search

2 Re-estimate 0% 0 search

3 Parts Hold 15.5% 47 search

4 Incomplete 0% 0 search

5 Complete 71.3% 216 search

6 Not Repaired 10.2% 31 search

7 Other 3% 9

Useful?

Fault Pareto 44 of 104 faults = 80% of work

1Parts Loose 8.7%

2AF inop 17%

3Focus Stiff 22.3%

4Parts Missing 27%

5Impact Damage 31.7%

6Focus Rough 35.3%

7AF Erratic 39%

8Zoom Stiff 42.3%

9Focus Squeek 45.3%

10Zoom Rough 48%

11Weather Seal Damaged 50.7%

12Mount Damaged 53.3%

Useful?

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

	Parts Loose	AF inop	Focus Stiff	Parts Missing	Impact Damage	Focus Rough	AF Erratic	Zoom Stiff	Focus Squeek	Zoom Rough	Weather Seal Damaged	Mount Damaged
Shay	26	25	16	14	14	11	11	10	9	8	8	8

Useful?

By Diagnosis what actually broke

1Parts Loose 24 h 26 2AF inop 65 h 25 3Focus Stiff 24 h 16 4Parts Missing 11 h 14 5Impact Damage 10 h 14 6Focus Rough 15 h 11 7AF Erratic 20 h 11 8Zoom Stiff 29 h 10 9Focus Squeek 20 h 9 10Zoom Rough 6 h 8 11Weather Seal Damaged 6 h 8 12Mount Damaged 4 h 8 13Aper Sticky 10 h 8 14Aper Inop 17 h 8 15Grip Loose 4 h 6

Useful?

By Technician 1 shown

1Shay 478 h 308

Useful?

By Status 6 shown

1Complete 325 h 216 2Parts Hold 76 h 47 3Not Repaired 60 h 31 4Mod - Ebay 6 h 4 5Kickback 1 h 4 6Part Order 0 h 1

Useful?

By Brand 15 shown

1Canon 214 h 135 2Nikon 166 h 99 3Sony 34 h 16 4Sigma 13 h 12 5Tamron 6 h 10 6Pentax 13 h 10 7Zeiss 14 h 8 8Olympus 7 h 5 9Fujifilm 3 h 4 10Minolta 3 h 2 11Samyang 0 h 1 12Rokinon 0 h 1 13Panasonic 0 h 1 14Other 0 h 1 15Leica 1 h 1

Useful?

By Repair Code 1 shown

Useful?

By Discipline 1 shown

1Apprentice 478 h 308

Useful?

By Repair Owner 6 shown

1KEH 427 h 293 2Training 46 h 10 3Redo 2 h 2 4Internal 1 h 1 5Customer 0 h 1 6Admin 2 h 1

Useful?