Repair Logs

--:--

synced 8d ago

135

Logged Rows

110

Unique Items

2

Technicians

124

Labor Hours

from 135 rows (100%)

0

Search Hours

from 0 rows (0%)

$380

Parts Cost

from 16 rows (12%)

Clear 2

DisciplineLens × CodeR23 ×

2025-01-08 → 2026-09-10· 55 min avg/job· 7 brands

Volume by Month hover a column for hours and cost

2

25-01

4

25-02

9

25-03

4

25-04

4

25-05

3

25-06

3

25-07

8

25-08

4

25-09

2

25-10

5

25-11

4

25-12

6

26-01

7

26-02

9

26-03

5

26-04

11

26-05

23

26-06

11

26-07

8

26-08

3

26-09

Useful?

Parts Hold Watchlist 11 jobs waiting on parts

11

Jobs Held

10

Items Held

$0

Parts Value

By Brand

1Sigma 36.4% 4 search

2Nikon 36.4% 4 search

3Canon 18.2% 2 search

4Tamron 9.1% 1 search

By Part Needed

1Flex 9.1% 1 search

2CY3-2498-000-200 9.1% 1 search

35767Z40 9.1% 1 search

45767FE0 9.1% 1 search

Useful?

Status Funnel where work accumulates

1 Quality Check 6.3% 8 search

2 Re-estimate 0% 0 search

3 Parts Hold 8.7% 11 search

4 Incomplete 0% 0 search

5 Complete 65.9% 83 search

6 Not Repaired 4.8% 6 search

7 Other 14.3% 18

Useful?

Fault Pareto 2 of 11 faults = 80% of work

1VR Inop 54.9%

2IS Inop 91%

3Focus Squeek 92.6%

4Error 94.3%

5Water Damage 95.1%

6VR Inop, Focus Squeek 95.9%

7VR Inop, Button Issues 96.7%

8Mount Damaged 97.5%

9IS Inop, Parts Loose 98.4%

10Button Issues 99.2%

11AF Erratic 100%

Useful?

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

	VR Inop	IS Inop	Focus Squeek	Error	Water Damage	VR Inop, Focus Squeek	VR Inop, Button Issues	Mount Damaged	IS Inop, Parts Loose	Button Issues	AF Erratic
Remy	45	26	1	2	1			1		1	1
Onyx	22	18	1			1	1		1

Useful?

By Diagnosis what actually broke

1VR Inop 56 h 67 2IS Inop 42 h 44 3Focus Squeek 3 h 2 4Error 6 h 2 5Water Damage 0 h 1 6VR Inop, Focus Squeek 4 h 1 7VR Inop, Button Issues 1 h 1 8Mount Damaged 0 h 1 9IS Inop, Parts Loose 1 h 1 10Button Issues 0 h 1 11AF Erratic 1 h 1

Useful?

By Technician 2 shown

1Remy 70 h 84 2Onyx 54 h 51

Useful?

By Status 8 shown

1Complete 85 h 83 2Parts Hold 9 h 11 3Quality Check 1 h 8 4Not Repaired 5 h 6 5AI - Ebay 7 h 6 6OEM 3 h 5 7RP Gear 2 h 4 8Mod - Ebay 4 h 3

Useful?

By Brand 7 shown

1Nikon 55 h 58 2Canon 21 h 27 3Tamron 22 h 22 4Sigma 22 h 22 5Panasonic 1 h 3 6Sony 2 h 2 7Olympus 1 h 1

Useful?

By Repair Code 1 shown

Useful?

By Discipline 1 shown

1Lens 124 h 135

Useful?

By Repair Owner 2 shown

1KEH 123 h 131 2Training 1 h 4

Useful?