Repair Logs

--:--

synced 9d 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%

3Error 92.6%

4Focus Squeek 94.3%

5AF Erratic 95.1%

6Button Issues 95.9%

7IS Inop, Parts Loose 96.7%

8Mount Damaged 97.5%

9VR Inop, Button Issues 98.4%

10VR Inop, Focus Squeek 99.2%

11Water Damage 100%

Useful?

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

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

Useful?

By Diagnosis what actually broke

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

Useful?

By Technician 2 shown

1Larry 70 h 84 2Leo 54 h 51

Useful?

By Status 8 shown

1Complete 85 h 83 2Parts Hold 9 h 11 3Quality Check 1 h 8 4AI - Ebay 7 h 6 5Not Repaired 5 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 3Sigma 22 h 22 4Tamron 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?