Repair Logs

--:--

synced 14d ago

167

Logged Rows

155

Unique Items

5

Technicians

117

Labor Hours

from 165 rows (99%)

3

Search Hours

from 6 rows (4%)

$139

Parts Cost

from 7 rows (4%)

Clear 3

DisciplineLens × StatusParts Hold × CodeR01 ×

2025-01-02 → 2026-09-10· 42 min avg/job· 15 brands

Volume by Month hover a column for hours and cost

2

25-01

5

25-02

9

25-03

11

25-04

5

25-05

7

25-06

9

25-07

11

25-08

5

25-09

10

25-10

15

25-11

11

25-12

6

26-01

11

26-02

13

26-03

6

26-04

7

26-05

3

26-06

9

26-07

11

26-08

1

26-09

Useful?

Parts Hold Watchlist 167 jobs waiting on parts

167

Jobs Held

155

Items Held

$139

Parts Value

By Brand

1Canon 35.9% 60 search

2Sony 17.4% 29 search

3Sigma 13.2% 22 search

4Nikon 13.2% 22 search

5Tamron 10.2% 17 search

6Fujifilm 3% 5 search

By Part Needed

1Flex 1.8% 3 search

2YG2-2549 1.2% 2 search

31K110-905 1.2% 2 search

4stablizer does not work 0.6% 1 search

5grip 0.6% 1 search

6YG2-3004 0.6% 1 search

Useful?

Status Funnel where work accumulates

1 Quality Check 0% 0 search

2 Re-estimate 0% 0 search

3 Parts Hold 100% 167 search

4 Incomplete 0% 0 search

5 Complete 0% 0 search

6 Not Repaired 0% 0 search

Useful?

Fault Pareto 11 of 28 faults = 80% of work

1Parts Missing 14.9%

2Impact Damage 28.1%

3Parts Loose 37.7%

4AF inop 46.5%

5Mount Damaged 53.5%

6Aper Inop 59.6%

7Error 64.9%

8AF Erratic 70.2%

9Inop 74.6%

10Grip Loose 78.9%

11Zoom Rough 81.6%

12VR Inop 84.2%

Useful?

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

	Parts Missing	Impact Damage	Parts Loose	AF inop	Mount Damaged	Aper Inop	Error	AF Erratic	Inop	Grip Loose	Zoom Rough	VR Inop
Larry	7	8	4	5	4	5	5	4		1	3	3
Leo	6		6	5	4	1	1	1	5	4
Scott34		3	1					1
John	4	3				1
Scott		1

Useful?

By Diagnosis what actually broke

1Parts Missing 5 h 17 2Impact Damage 12 h 15 3Parts Loose 7 h 11 4AF inop 10 h 10 5Mount Damaged 4 h 8 6Aper Inop 6 h 7 7Error 2 h 6 8AF Erratic 6 h 6 9Inop 4 h 5 10Grip Loose 2 h 5 11Zoom Rough 1 h 3 12VR Inop 5 h 3 13Weather Seal Damaged 1 h 2 14IS Inop 3 h 2 15Weather Seal Damaged, Parts Missing 1 h 1

Useful?

By Technician 5 shown

1Larry 49 h 81 2Leo 48 h 68 3Scott34 13 h 8 4John 3 h 8 5Scott 4 h 2

Useful?

By Status 1 shown

1Parts Hold 117 h 167

Useful?

By Brand 15 shown

1Canon 44 h 60 2Sony 17 h 29 3Sigma 17 h 22 4Nikon 16 h 22 5Tamron 13 h 17 6Fujifilm 1 h 5 7Panasonic 1 h 2 8Other 1 h 2 9Hasselblad 3 h 2 10Zeiss 0 h 1 11Viltrox 1 h 1 12Rollei 1 h 1 13Pentax 1 h 1 14Olympus 0 h 1 15Leica 0 h 1

Useful?

By Repair Code 1 shown

Useful?

By Discipline 1 shown

1Lens 117 h 167

Useful?

By Repair Owner 2 shown

1KEH 111 h 165 2Training 5 h 2

Useful?