Repair Logs

--:--

synced 8d ago

382

Logged Rows

246

Unique Items

7

Technicians

529

Labor Hours

from 379 rows (99%)

23

Search Hours

from 62 rows (16%)

$568

Parts Cost

from 16 rows (4%)

Clear 2

DisciplineApprentice × CodeR22 ×

2025-01-15 → 2026-09-15· 84 min avg/job· 15 brands

Volume by Month hover a column for hours and cost

5

25-01

4

25-02

6

25-03

6

25-04

11

25-05

14

25-06

20

25-07

1

25-08

8

25-09

11

25-10

11

25-11

16

25-12

6

26-01

11

26-02

34

26-03

33

26-04

18

26-05

42

26-06

50

26-07

47

26-08

28

26-09

Useful?

Parts Hold Watchlist 25 jobs waiting on parts

25

Jobs Held

23

Items Held

$314

Parts Value

By Brand

1Nikon 52% 13 search

2Canon 16% 4 search

3Tamron 8% 2 search

4Sigma 8% 2 search

5Olympus 4% 1 search

6Minolta 4% 1 search

By Part Needed

1YF2-2073-000 4% 1 search

2VR Flex 4% 1 search

3RP: zoom grip 4% 1 search

4RP: Photo interupters (2) 4% 1 search

5RP: Main Board 4% 1 search

6RP: Inner Zoom Barrel 4% 1 search

Useful?

Status Funnel where work accumulates

1 Quality Check 24.4% 86 search

2 Re-estimate 0% 0 search

3 Parts Hold 7.1% 25 search

4 Incomplete 0% 0 search

5 Complete 60.2% 212 search

6 Not Repaired 4.3% 15 search

7 Other 4% 14

Useful?

Fault Pareto 8 of 51 faults = 80% of work

1Focus Stiff 21.7%

2Zoom Stiff 38.8%

3Focus Rough 53.1%

4Zoom Loose 60.6%

5Zoom Rough 67.1%

6Focus Loose 73%

7Focus Squeek 77.6%

8AF Erratic 80.4%

9AF inop 82.3%

10Zoom Rough, Zoom Stiff 83.5%

11Inop 84.8%

12Focus Stiff, Focus Rough 86%

Useful?

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

	Focus Stiff	Zoom Stiff	Focus Rough	Zoom Loose	Zoom Rough	Focus Loose	Focus Squeek	AF Erratic	AF inop	Zoom Rough, Zoom Stiff	Inop	Focus Stiff, Focus Rough
Shay	50	31	25	12	13	13	8	6	5	4	2	4
Tatum	2	1	4		1	1	1	1	1
Hollis	12	9	7	5	5	3	3	1
Sam	3	11	9	5	2	2	1	1			2
Devon	2	2		1			1
Dell	1		1				1
Casey		1		1

Useful?

By Diagnosis what actually broke

1Focus Stiff 92 h 70 2Zoom Stiff 79 h 55 3Focus Rough 46 h 46 4Zoom Loose 17 h 24 5Zoom Rough 31 h 21 6Focus Loose 18 h 19 7Focus Squeek 22 h 15 8AF Erratic 8 h 9 9AF inop 9 h 6 10Zoom Rough, Zoom Stiff 10 h 4 11Inop 2 h 4 12Focus Stiff, Focus Rough 4 h 4 13Zoom Loose, Parts Loose 3 h 2 14Parts Loose 1 h 2 15Focus Stiff, Parts Loose 5 h 2

Useful?

By Technician 7 shown

1Shay 337 h 216 2Tatum 144 h 67 3Hollis 8 h 46 4Sam 10 h 40 5Devon 24 h 8 6Dell 2 h 3 7Casey 4 h 2

Useful?

By Status 8 shown

1Complete 334 h 212 2Quality Check 18 h 86 3Parts Hold 43 h 25 4Not Repaired 32 h 15 5Kickback 5 h 7 6Mod - Ebay 5 h 3 7RP Gear 6 h 2 8AI - Ebay 2 h 2

Useful?

By Brand 15 shown

1Nikon 294 h 189 2Canon 93 h 78 3Tamron 44 h 32 4Sigma 34 h 26 5Sony 16 h 17 6Pentax 12 h 7 7Olympus 9 h 7 8Fujifilm 8 h 7 9Minolta 5 h 5 10Zeiss 2 h 3 11Other 2 h 3 12Mamiya 4 h 3 13Yashica 0 h 1 14Panasonic 1 h 1 15Contax 1 h 1

Useful?

By Repair Code 1 shown

Useful?

By Discipline 1 shown

1Apprentice 529 h 382

Useful?

By Repair Owner 3 shown

1KEH 508 h 371 2Training 15 h 6 3Redo 1 h 2

Useful?