Repair Logs

--:--

synced 10d ago

135

Logged Rows

96

Unique Items

4

Technicians

73

Labor Hours

from 132 rows (98%)

2

Search Hours

from 6 rows (4%)

$2,811

Parts Cost

from 38 rows (28%)

Clear 2

DisciplineLens × CodeR24 ×

2025-01-08 → 2026-09-03· 33 min avg/job· 15 brands

Volume by Month hover a column for hours and cost

6

25-01

1

25-02

8

25-03

8

25-04

3

25-05

8

25-06

17

25-07

7

25-08

5

25-09

6

25-10

9

25-11

6

25-12

3

26-01

8

26-02

3

26-03

5

26-04

5

26-05

7

26-06

9

26-07

8

26-08

3

26-09

Useful?

Parts Hold Watchlist 32 jobs waiting on parts

32

Jobs Held

29

Items Held

$0

Parts Value

By Brand

1Sony 34.4% 11 search

2Canon 28.1% 9 search

3Nikon 12.5% 4 search

4Sigma 9.4% 3 search

5Pentax 9.4% 3 search

6Tamron 3.1% 1 search

By Part Needed

1A-2180-241-B 6.3% 2 search

2YA2-3428 3.1% 1 search

3CY1-2497-000-250 3.1% 1 search

4A-5063-061-A 3.1% 1 search

5A-2079-852-B 3.1% 1 search

6955U010, (9550960) 3.1% 1 search

Useful?

Status Funnel where work accumulates

1 Quality Check 4.7% 6 search

2 Re-estimate 0.8% 1 search

3 Parts Hold 25% 32 search

4 Incomplete 0% 0 search

5 Complete 58.6% 75 search

6 Not Repaired 3.1% 4 search

7 Other 7.8% 10

Useful?

Fault Pareto 2 of 13 faults = 80% of work

1Mount Damaged 72%

2Impact Damage 85%

3Parts Loose 88.8%

4Focus Squeek 90.7%

5Parts Missing 92.5%

6AF inop 93.5%

7AF inop, Mount Damaged 94.4%

8Aper Inop 95.3%

9Focus Rough 96.3%

10Inop 97.2%

11Mount Damaged, Focus Stiff 98.1%

12Water Damage 99.1%

Useful?

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

	Mount Damaged	Impact Damage	Parts Loose	Focus Squeek	Parts Missing	AF inop	AF inop, Mount Damaged	Aper Inop	Focus Rough	Inop	Mount Damaged, Focus Stiff	Water Damage
Larry	40	11	2		1	1		1				1
Leo	36		1	2			1		1	1	1
Scott		2	1		1
Scott34	1	1

Useful?

By Diagnosis what actually broke

1Mount Damaged 38 h 77 2Impact Damage 8 h 14 3Parts Loose 2 h 4 4Focus Squeek 1 h 2 5Parts Missing 1 h 2 6AF inop 0 h 1 7AF inop, Mount Damaged 3 h 1 8Aper Inop 1 h 1 9Focus Rough 2 h 1 10Inop 1 h 1 11Mount Damaged, Focus Stiff 0 h 1 12Water Damage 0 h 1 13Weather Seal Damaged 1 h 1

Useful?

By Technician 4 shown

1Larry 38 h 73 2Leo 33 h 56 3Scott 1 h 4 4Scott34 1 h 2

Useful?

By Status 9 shown

1Complete 51 h 75 2Parts Hold 12 h 32 3Quality Check 1 h 6 4AI - Ebay 1 h 5 5Not Repaired 4 h 4 6OEM 2 h 2 7RP Gear 1 h 2 8Kickback 0 h 1 9Re-estimate 0 h 1

Useful?

By Brand 15 shown

1Canon 18 h 37 2Sony 14 h 27 3Nikon 17 h 23 4Sigma 6 h 15 5Tamron 3 h 7 6Pentax 3 h 5 7Olympus 4 h 4 8Other 2 h 4 9Zeiss 2 h 4 10Fujifilm 2 h 3 11Panasonic 1 h 2 12Contax 0 h 1 13Mamiya 2 h 1 14Tokina 1 h 1 15Viltrox 1 h 1

Useful?

By Repair Code 1 shown

Useful?

By Discipline 1 shown

Useful?

By Repair Owner 2 shown

1KEH 73 h 131 2Training 1 h 4

Useful?