Repair Logs

--:--

synced 10d ago

612

Logged Rows

479

Unique Items

4

Technicians

620

Labor Hours

from 610 rows (100%)

5

Search Hours

from 16 rows (3%)

$4,654

Parts Cost

from 76 rows (12%)

Clear 2

DisciplineLens × CodeR02 ×

2025-01-02 → 2026-09-14· 61 min avg/job· 16 brands

Volume by Month hover a column for hours and cost

13

25-01

41

25-02

44

25-03

36

25-04

30

25-05

16

25-06

29

25-07

21

25-08

20

25-09

43

25-10

33

25-11

36

25-12

18

26-01

25

26-02

23

26-03

27

26-04

25

26-05

28

26-06

49

26-07

49

26-08

6

26-09

Useful?

Parts Hold Watchlist 59 jobs waiting on parts

59

Jobs Held

50

Items Held

$125

Parts Value

By Brand

1Sigma 27.1% 16 search

2Canon 27.1% 16 search

3Tamron 15.3% 9 search

4Nikon 13.6% 8 search

5Pentax 8.5% 5 search

6Sony 3.4% 2 search

By Part Needed

1VR Flex 3.4% 2 search

2Front Ring 3.4% 2 search

3CY3-2796-000 3.4% 2 search

4lens rebuild 1.7% 1 search

5YG2-2294-000 1.7% 1 search

6YG2-0212-09 / USM F housing 1.7% 1 search

Useful?

Status Funnel where work accumulates

1 Quality Check 6.7% 38 search

2 Re-estimate 0.2% 1 search

3 Parts Hold 10.5% 59 search

4 Incomplete 1.2% 7 search

5 Complete 63.8% 359 search

6 Not Repaired 4.6% 26 search

7 Other 13% 73

Useful?

Fault Pareto 2 of 26 faults = 80% of work

1AF Erratic 41.6%

2AF inop 80.7%

3Focus Squeek 84.1%

4Impact Damage 87.2%

5Focus Rough 89.6%

6Inop 91.1%

7Focus Stiff 92.3%

8Aper Inop 93.2%

9IS Inop 94.2%

10VR Inop 95.2%

11Aper Oily 95.7%

12Focus Loose 96.3%

Useful?

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

	AF Erratic	AF inop	Focus Squeek	Impact Damage	Focus Rough	Inop	Focus Stiff	Aper Inop	IS Inop	VR Inop	Aper Oily	Focus Loose
Larry	126	107	9	13	10	2	4	2	4	5		3
Leo	77	81	9		2	6	1		1
Scott34	9	6		2			1	2			3
Scott	3	8		1				1

Useful?

By Diagnosis what actually broke

1AF Erratic 190 h 215 2AF inop 236 h 202 3Focus Squeek 27 h 18 4Impact Damage 22 h 16 5Focus Rough 7 h 12 6Inop 6 h 8 7Focus Stiff 7 h 6 8Aper Inop 13 h 5 9IS Inop 4 h 5 10VR Inop 7 h 5 11Aper Oily 2 h 3 12Focus Loose 3 h 3 13Error 3 h 2 14Parts Loose 1 h 2 15Parts Missing 2 h 2

Useful?

By Technician 4 shown

1Larry 304 h 344 2Leo 255 h 231 3Scott34 51 h 23 4Scott 10 h 14

Useful?

By Status 10 shown

1Complete 388 h 359 2Parts Hold 55 h 59 3AI - Ebay 39 h 45 4Quality Check 4 h 38 5Not Repaired 31 h 26 6OEM 19 h 16 7RP Gear 8 h 10 8Incomplete 10 h 7 9Mod - Ebay 1 h 2 10Re-estimate 1 h 1

Useful?

By Brand 15 shown

1Canon 159 h 161 2Nikon 174 h 141 3Sigma 84 h 87 4Tamron 78 h 83 5Pentax 34 h 37 6Sony 32 h 36 7Fujifilm 20 h 23 8Other 15 h 12 9Panasonic 8 h 12 10Contax 5 h 4 11Tokina 7 h 4 12Olympus 2 h 3 13Mamiya 1 h 2 14Samyang 1 h 2 15Zeiss 0 h 2

Useful?

By Repair Code 1 shown

Useful?

By Discipline 1 shown

1Lens 620 h 612

Useful?

By Repair Owner 2 shown

1KEH 582 h 577 2Training 38 h 35

Useful?