Repair Logs

--:--

synced 9d ago

109

Logged Rows

84

Unique Items

3

Technicians

113

Labor Hours

from 108 rows (99%)

1

Search Hours

from 2 rows (2%)

$848

Parts Cost

from 45 rows (41%)

Clear 2

DisciplineLens × CodeR03 ×

2025-01-13 → 2026-09-14· 63 min avg/job· 11 brands

Volume by Month hover a column for hours and cost

2

25-01

2

25-02

3

25-03

8

25-04

5

25-05

9

25-06

6

25-07

7

25-08

4

25-09

9

25-10

7

25-11

4

25-12

6

26-01

5

26-02

4

26-03

3

26-04

3

26-05

9

26-06

6

26-07

6

26-08

1

26-09

Useful?

Parts Hold Watchlist 14 jobs waiting on parts

14

Jobs Held

13

Items Held

$11

Parts Value

By Brand

1Canon 57.1% 8 search

2Tamron 14.3% 2 search

3Sigma 14.3% 2 search

4Nikon 7.1% 1 search

5Fujifilm 7.1% 1 search

By Part Needed

1YG2-4429-000 7.1% 1 search

2YG2-3140-010 7.1% 1 search

3YG2-3001 7.1% 1 search

4Seal,aperture flex 7.1% 1 search

5Main PCB Board 7.1% 1 search

601A2750 7.1% 1 search

Useful?

Status Funnel where work accumulates

1 Quality Check 3% 3 search

2 Re-estimate 1% 1 search

3 Parts Hold 13.9% 14 search

4 Incomplete 0% 0 search

5 Complete 60.4% 61 search

6 Not Repaired 3% 3 search

7 Other 18.8% 19

Useful?

Fault Pareto 2 of 10 faults = 80% of work

1Error 68.5%

2Aper Inop 81.5%

3Inop 89.1%

4AF inop 93.5%

5VR Inop 94.6%

6Focus Stiff, Inop, Error 95.7%

7Focus Stiff 96.7%

8Error, Inop 97.8%

9Error, Aper Inop 98.9%

10AF inop, Focus Stiff, Error 100%

Useful?

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

	Error	Aper Inop	Inop	AF inop	VR Inop	Focus Stiff, Inop, Error	Focus Stiff	Error, Inop	Error, Aper Inop	AF inop, Focus Stiff, Error
Remy	29	9	1		1
Onyx	33	3	6	4		1	1	1	1	1
Harlow34	1

Useful?

By Diagnosis what actually broke

1Error 73 h 63 2Aper Inop 11 h 12 3Inop 4 h 7 4AF inop 4 h 4 5VR Inop 1 h 1 6Focus Stiff, Inop, Error 3 h 1 7Focus Stiff 0 h 1 8Error, Inop 1 h 1 9Error, Aper Inop 2 h 1 10AF inop, Focus Stiff, Error 1 h 1

Useful?

By Technician 3 shown

1Remy 47 h 55 2Onyx 66 h 53 3Harlow34 1 h 1

Useful?

By Status 8 shown

1Complete 80 h 61 2Parts Hold 8 h 14 3OEM 4 h 8 4AI - Ebay 8 h 7 5RP Gear 4 h 4 6Quality Check 0 h 3 7Not Repaired 2 h 3 8Re-estimate 0 h 1

Useful?

By Brand 11 shown

1Canon 60 h 53 2Tamron 14 h 13 3Fujifilm 10 h 12 4Sigma 13 h 10 5Sony 6 h 6 6Nikon 6 h 6 7Viltrox 1 h 3 8Olympus 2 h 3 9Zeiss 1 h 1 10Samyang 1 h 1 11Panasonic 1 h 1

Useful?

By Repair Code 1 shown

Useful?

By Discipline 1 shown

1Lens 113 h 109

Useful?

By Repair Owner 2 shown

1KEH 110 h 104 2Training 4 h 5

Useful?