Repair Logs

--:--

synced 9d ago

231

Logged Rows

168

Unique Items

1

Technicians

255

Labor Hours

from 230 rows (100%)

5

Search Hours

from 16 rows (7%)

$1,837

Parts Cost

from 28 rows (12%)

Clear 2

TechnicianOnyx × CodeR02 ×

2025-01-09 → 2026-08-31· 67 min avg/job· 15 brands

Volume by Month hover a column for hours and cost

5

25-01

27

25-02

26

25-03

7

25-04

13

25-05

6

25-06

17

25-07

6

25-08

7

25-09

18

25-10

16

25-11

9

25-12

10

26-01

8

26-02

4

26-03

6

26-04

5

26-05

3

26-06

15

26-07

23

26-08

Useful?

Parts Hold Watchlist 23 jobs waiting on parts

23

Jobs Held

19

Items Held

$0

Parts Value

By Brand

1Sigma 43.5% 10 search

2Tamron 17.4% 4 search

3Nikon 13% 3 search

4Canon 13% 3 search

5Sony 4.3% 1 search

6Panasonic 4.3% 1 search

By Part Needed

1VR Flex 8.7% 2 search

2Front Ring 8.7% 2 search

3CY3-2796-000 8.7% 2 search

4YG2-2294-000 4.3% 1 search

5MA Ring guts 4.3% 1 search

6MA Ring 4.3% 1 search

Useful?

Status Funnel where work accumulates

1 Quality Check 0.5% 1 search

2 Re-estimate 0.5% 1 search

3 Parts Hold 12.5% 23 search

4 Incomplete 0% 0 search

5 Complete 67.4% 124 search

6 Not Repaired 0.5% 1 search

7 Other 18.5% 34

Useful?

Fault Pareto 2 of 16 faults = 80% of work

1AF inop 43.1%

2AF Erratic 84%

3Focus Squeek 88.8%

4Inop 92%

5Parts Missing 93.1%

6Focus Rough 94.1%

7Error 95.2%

8IS Inop 95.7%

9Focus Stiff 96.3%

10Error, Grip Loose 96.8%

11Advance Inop 97.3%

12AF inop, Zoom Rough 97.9%

Useful?

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

	AF inop	AF Erratic	Focus Squeek	Inop	Parts Missing	Focus Rough	Error	IS Inop	Focus Stiff	Error, Grip Loose	Advance Inop	AF inop, Zoom Rough
Onyx	81	77	9	6	2	2	2	1	1	1	1	1

Useful?

By Diagnosis what actually broke

1AF inop 98 h 81 2AF Erratic 72 h 77 3Focus Squeek 17 h 9 4Inop 5 h 6 5Parts Missing 2 h 2 6Focus Rough 3 h 2 7Error 3 h 2 8IS Inop 2 h 1 9Focus Stiff 1 h 1 10Error, Grip Loose 2 h 1 11Advance Inop 4 h 1 12AF inop, Zoom Rough 1 h 1 13AF inop, Focus Stiff, Grip Loose 2 h 1 14AF inop, Focus Stiff 1 h 1 15AF inop, Focus Squeek, Grip Loose, Parts Loose 3 h 1

Useful?

By Technician 1 shown

1Onyx 255 h 231

Useful?

By Status 9 shown

1Complete 137 h 124 2Parts Hold 17 h 23 3AI - Ebay 18 h 20 4OEM 17 h 11 5RP Gear 3 h 2 6Re-estimate 1 h 1 7Quality Check 0 h 1 8Not Repaired 1 h 1 9Mod - Ebay 1 h 1

Useful?

By Brand 15 shown

1Canon 54 h 47 2Sigma 43 h 46 3Nikon 69 h 44 4Tamron 30 h 36 5Sony 16 h 16 6Other 14 h 10 7Fujifilm 7 h 10 8Panasonic 5 h 7 9Pentax 8 h 5 10Contax 5 h 4 11Mamiya 1 h 2 12Zeiss 0 h 1 13Tokina 3 h 1 14Samyang 1 h 1 15Olympus 1 h 1

Useful?

By Repair Code 1 shown

Useful?

By Discipline 1 shown

1Lens 255 h 231

Useful?

By Repair Owner 2 shown

1KEH 244 h 226 2Training 11 h 5

Useful?