Repair Logs

--:--

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

3AF Erratic 90.2%

4Error 91.9%

5Zoom Rough 93.1%

6Button Issues 93.9%

7Focus Squeek 94.7%

8No Problem 95.5%

9AF inop 95.9%

10IS Inop, Parts Loose 96.3%

11Impact Damage 96.7%

12Inop 97.2%

Useful?

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

	VR Inop	IS Inop	AF Erratic	Error	Zoom Rough	Button Issues	Focus Squeek	No Problem	AF inop	IS Inop, Parts Loose	Impact Damage	Inop
Larry	45	26	1	2		1	1
Gabe	30	21		1	1	1		1			1
Leo	22	18					1			1
Bryan	24	14	2		2			1	1
Darryl	4
Umcolisi	6	4
Taylor	1		1
Anthony		1		1
Brice
Joon
Kiersten	1
TK		1
Wayne												1

Useful?

By Diagnosis what actually broke

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

Useful?

By Technician 13 shown

1Larry 70 h 84 2Gabe 70 h 57 3Leo 54 h 51 4Bryan 38 h 44 5Darryl 25 h 11 6Umcolisi 19 h 10 7Taylor 11 h 4 8Anthony 0 h 2 9Brice 0 h 1 10Joon 3 h 1 11Kiersten 0 h 1 12TK 0 h 1 13Wayne 0 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 6OEM 4 h 7 7RP Gear 7 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 5Olympus 3 h 3 6Panasonic 1 h 3 7Sony 2 h 3 8Contax 0 h 1 9Mamiya 1 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?