Repair Logs

--:--

synced 9d ago

139

Logged Rows

126

Unique Items

15

Technicians

137

Labor Hours

from 132 rows (95%)

9

Search Hours

from 38 rows (27%)

$3,471

Parts Cost

from 28 rows (20%)

Clear 2

StatusParts Hold × CodeR02 ×

2025-01-08 → 2026-09-04· 62 min avg/job· 12 brands

Volume by Month hover a column for hours and cost

5

25-01

10

25-02

6

25-03

4

25-04

3

25-05

6

25-06

4

25-07

6

25-08

5

25-09

8

25-10

8

25-11

5

25-12

7

26-01

7

26-02

7

26-03

4

26-04

7

26-05

8

26-06

14

26-07

13

26-08

2

26-09

Useful?

Parts Hold Watchlist 139 jobs waiting on parts

139

Jobs Held

126

Items Held

$3,471

Parts Value

By Brand

1Canon 34.5% 48 search

2Sigma 20.9% 29 search

3Sony 14.4% 20 search

4Nikon 12.9% 18 search

5Tamron 9.4% 13 search

6Pentax 3.6% 5 search

By Part Needed

1VR Flex 1.4% 2 search

2Front Ring 1.4% 2 search

3CY3-2796-000 1.4% 2 search

4AF Motor 1.4% 2 search

5rear element 0.7% 1 search

6mirror box 0.7% 1 search

Useful?

Status Funnel where work accumulates

1 Quality Check 0% 0 search

2 Re-estimate 0% 0 search

3 Parts Hold 100% 139 search

4 Incomplete 0% 0 search

5 Complete 0% 0 search

6 Not Repaired 0% 0 search

Useful?

Fault Pareto 4 of 21 faults = 80% of work

1AF inop 41.5%

2AF Erratic 69.1%

3Inop 76.4%

4Error 80.5%

5Impact Damage 83.7%

6IS Inop 86.2%

7Parts Loose 87.8%

8Focus Squeek 89.4%

9Zoom Rough 90.2%

10Zoom Loose 91.1%

11VR Inop 91.9%

12Parts Missing 92.7%

Useful?

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

	AF inop	AF Erratic	Inop	Error	Impact Damage	IS Inop	Parts Loose	Focus Squeek	Zoom Rough	Zoom Loose	VR Inop	Parts Missing
Larry	13	6	1		2	1		1		1
Bryan	13	4	6	3	1	2	2
Leo	6	7		1				1				1
Gabe	9	8	1
Umcolisi	5	5									1
Scott34	1	1			1
Trent	1	2
Brice	1	1	1
Darryl
Ben									1
Zibby	1
Wayne	1
Taylor
Daniel

Useful?

By Diagnosis what actually broke

1AF inop 46 h 51 2AF Erratic 43 h 34 3Inop 6 h 9 4Error 5 h 5 5Impact Damage 7 h 4 6IS Inop 2 h 3 7Parts Loose 0 h 2 8Focus Squeek 1 h 2 9Zoom Rough 2 h 1 10Zoom Loose 0 h 1 11VR Inop 1 h 1 12Parts Missing 1 h 1 13No Power 0 h 1 14Grip Loose 0 h 1 15Focus Stiff 1 h 1

Useful?

By Technician 15 shown

1Larry 23 h 32 2Bryan 20 h 32 3Leo 17 h 23 4Gabe 16 h 20 5Umcolisi 32 h 13 6Scott34 15 h 4 7Trent 2 h 3 8Brice 4 h 3 9Darryl 1 h 2 10Ben 2 h 2 11Zibby 1 h 1 12Wayne 2 h 1 13Taylor 1 h 1 14Daniel 3 h 1 15Anthony 0 h 1

Useful?

By Status 1 shown

1Parts Hold 137 h 139

Useful?

By Brand 12 shown

1Canon 44 h 48 2Sigma 27 h 29 3Sony 14 h 20 4Nikon 40 h 18 5Tamron 7 h 13 6Pentax 1 h 5 7Zeiss 0 h 1 8Phase One 2 h 1 9Panasonic 1 h 1 10Other 0 h 1 11Leica 2 h 1 12Fujifilm 1 h 1

Useful?

By Repair Code 1 shown

Useful?

By Discipline 4 shown

1Lens 55 h 59 2Multidiscipline 41 h 54 3Apprentice 34 h 17 4Digital 8 h 9

Useful?

By Repair Owner 2 shown

1KEH 137 h 138 2Training 1 h 1

Useful?