Repair Logs

--:--

synced 8d ago

268

Logged Rows

216

Unique Items

13

Technicians

290

Labor Hours

from 266 rows (99%)

2

Search Hours

from 10 rows (4%)

$1,094

Parts Cost

from 28 rows (10%)

Clear 1

2025-01-08 → 2026-09-16· 65 min avg/job· 9 brands

Volume by Month hover a column for hours and cost

10

25-01

12

25-02

22

25-03

11

25-04

10

25-05

5

25-06

10

25-07

19

25-08

14

25-09

8

25-10

6

25-11

10

25-12

11

26-01

12

26-02

16

26-03

8

26-04

19

26-05

32

26-06

14

26-07

12

26-08

7

26-09

Useful?

Parts Hold Watchlist 23 jobs waiting on parts

23

Jobs Held

21

Items Held

$240

Parts Value

By Brand

1Sigma 34.8% 8 search

2Nikon 30.4% 7 search

3Canon 26.1% 6 search

4Tamron 8.7% 2 search

By Part Needed

1MPC 4.3% 1 search

2I.S Flex- Not sold by Canon/ Ebay Only 4.3% 1 search

3Flex 4.3% 1 search

4CY3-2498-000-200 4.3% 1 search

57297Y80/ OS3 unit - 7297YA0/ OSFPC 4.3% 1 search

66357Y50 / OS Unit 4.3% 1 search

Useful?

Status Funnel where work accumulates

1 Quality Check 4.3% 11 search

2 Re-estimate 0% 0 search

3 Parts Hold 9.1% 23 search

4 Incomplete 0% 0 search

5 Complete 68% 172 search

6 Not Repaired 3.6% 9 search

7 Other 15% 38

Useful?

Fault Pareto 2 of 19 faults = 80% of work

1VR Inop 54.1%

2IS Inop 88.6%

3Error 90.2%

4AF Erratic 91.9%

5Zoom Rough 93.1%

6No Problem 93.9%

7Focus Squeek 94.7%

8Button Issues 95.5%

9Water Damage 95.9%

10VR Inop, Focus Squeek 96.3%

11VR Inop, Button Issues 96.7%

12Parts Missing 97.2%

Useful?

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

	VR Inop	IS Inop	Error	AF Erratic	Zoom Rough	No Problem	Focus Squeek	Button Issues	Water Damage	VR Inop, Focus Squeek	VR Inop, Button Issues	Parts Missing
Remy	45	26	2	1			1	1	1
Marlo	30	21	1		1	1		1
Onyx	22	18					1			1	1
Indigo	24	14		2	2	1
Tatum	4
Shay	6	4
Devon	1			1								1
Noa		1	1
Yara
Sam		1
Hollis	1
Eden
Arden

Useful?

By Diagnosis what actually broke

1VR Inop 134 h 133 2IS Inop 86 h 85 3Error 8 h 4 4AF Erratic 4 h 4 5Zoom Rough 5 h 3 6No Problem 1 h 2 7Focus Squeek 3 h 2 8Button Issues 1 h 2 9Water Damage 0 h 1 10VR Inop, Focus Squeek 4 h 1 11VR Inop, Button Issues 1 h 1 12Parts Missing 1 h 1 13Parts Loose 0 h 1 14No Power 3 h 1 15Mount Damaged 0 h 1

Useful?

By Technician 13 shown

1Remy 70 h 84 2Marlo 70 h 57 3Onyx 54 h 51 4Indigo 38 h 44 5Tatum 25 h 11 6Shay 19 h 10 7Devon 11 h 4 8Noa 0 h 2 9Yara 0 h 1 10Sam 0 h 1 11Hollis 0 h 1 12Eden 0 h 1 13Arden 3 h 1

Useful?

By Status 8 shown

1Complete 199 h 172 2Parts Hold 17 h 23 3AI - Ebay 15 h 19 4Quality Check 1 h 11 5Not Repaired 11 h 9 6RP Gear 7 h 7 7OEM 4 h 7 8Mod - Ebay 4 h 5

Useful?

By Brand 9 shown

1Nikon 145 h 115 2Canon 58 h 55 3Tamron 45 h 47 4Sigma 36 h 40 5Sony 2 h 3 6Panasonic 1 h 3 7Olympus 3 h 3 8Mamiya 1 h 1 9Contax 0 h 1

Useful?

By Repair Code 1 shown

Useful?

By Discipline 5 shown

1Lens 124 h 135 2Multidiscipline 108 h 102 3Apprentice 55 h 27 4Digital 0 h 3 5Film 3 h 1

Useful?

By Repair Owner 3 shown

1KEH 287 h 263 2Training 1 h 4 3Keh 2 h 1

Useful?