Repair Logs

--:--

synced 9d ago

299

Logged Rows

221

Unique Items

19

Technicians

190

Labor Hours

from 285 rows (95%)

10

Search Hours

from 44 rows (15%)

$5,302

Parts Cost

from 82 rows (27%)

Clear 1

2025-01-08 → 2026-09-16· 40 min avg/job· 18 brands

Volume by Month hover a column for hours and cost

16

25-01

7

25-02

13

25-03

9

25-04

10

25-05

16

25-06

27

25-07

15

25-08

13

25-09

14

25-10

16

25-11

8

25-12

12

26-01

11

26-02

15

26-03

8

26-04

16

26-05

18

26-06

16

26-07

22

26-08

17

26-09

Useful?

Parts Hold Watchlist 55 jobs waiting on parts

55

Jobs Held

49

Items Held

$1,065

Parts Value

By Brand

1Canon 32.7% 18 search

2Sony 27.3% 15 search

3Sigma 12.7% 7 search

4Nikon 12.7% 7 search

5Pentax 5.5% 3 search

6Fujifilm 5.5% 3 search

By Part Needed

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

2lens contact, main pcb 1.8% 1 search

3YF2-2263-000 1.8% 1 search

4YF2-2096-000/ Mount 1.8% 1 search

5YB2-5271-000 1.8% 1 search

6YB2-4251-000/ Cover,Back 1.8% 1 search

Useful?

Status Funnel where work accumulates

1 Quality Check 6.2% 18 search

2 Re-estimate 0.7% 2 search

3 Parts Hold 18.8% 55 search

4 Incomplete 0% 0 search

5 Complete 63.4% 185 search

6 Not Repaired 2.7% 8 search

7 Other 8.2% 24

Useful?

Fault Pareto 2 of 24 faults = 80% of work

1Mount Damaged 65.8%

2Impact Damage 82%

3Parts Loose 85.3%

4AF inop 87.6%

5Parts Missing 89.8%

6Inop 91.7%

7Focus Squeek 92.9%

8Focus Rough 93.6%

9No Problem 94.4%

10AF Erratic 94.7%

11AF inop, Mount Damaged 95.1%

12Aper Inop 95.5%

Useful?

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

	Mount Damaged	Impact Damage	Parts Loose	AF inop	Parts Missing	Inop	Focus Squeek	Focus Rough	No Problem	AF Erratic	AF inop, Mount Damaged	Aper Inop
Larry	40	11	2	1	1							1
Gabe	40	8	2	1	2			1	2
Leo	36		1			1	2	1			1
Bryan	16	19			2	2	1
Umcolisi	19		1
Brice	1			2		1				1
TK	6
Darryl	2			1
Anthony	4
Kiersten	3		1
Scott		2	1		1
Ben		2				1
David	1		1
Joon	3

Useful?

By Diagnosis what actually broke

1Mount Damaged 95 h 175 2Impact Damage 34 h 43 3Parts Loose 5 h 9 4AF inop 7 h 6 5Parts Missing 2 h 6 6Inop 5 h 5 7Focus Squeek 2 h 3 8Focus Rough 5 h 2 9No Problem 1 h 2 10AF Erratic 2 h 1 11AF inop, Mount Damaged 3 h 1 12Aper Inop 1 h 1 13Dial Issues 2 h 1 14Error 0 h 1 15Foot Inop 1 h 1

Useful?

By Technician 15 shown

1Larry 38 h 73 2Gabe 40 h 58 3Leo 33 h 56 4Bryan 24 h 42 5Umcolisi 17 h 22 6Brice 7 h 6 7TK 2 h 6 8Darryl 2 h 5 9Anthony 2 h 4 10Kiersten 1 h 4 11Scott 1 h 4 12Ben 5 h 3 13David 2 h 3 14Joon 4 h 3 15Wayne 3 h 3

Useful?

By Status 11 shown

1Complete 145 h 185 2Parts Hold 19 h 55 3Quality Check 3 h 18 4AI - Ebay 8 h 13 5Not Repaired 6 h 8 6Mod - Ebay 2 h 3 7OEM 2 h 3 8Part Order 0 h 2 9RP Gear 1 h 2 10Re-estimate 1 h 2 11Kickback 0 h 1

Useful?

By Brand 15 shown

1Canon 44 h 89 2Nikon 41 h 56 3Sony 27 h 45 4Sigma 22 h 36 5Tamron 10 h 14 6Fujifilm 11 h 11 7Pentax 9 h 10 8Other 5 h 9 9Mamiya 8 h 7 10Olympus 6 h 6 11Zeiss 3 h 5 12Contax 1 h 2 13Panasonic 1 h 2 14Rokinon 1 h 2 15Voigtländer 1 h 2

Useful?

By Repair Code 1 shown

Useful?

By Discipline 5 shown

1Lens 73 h 135 2Multidiscipline 67 h 103 3Apprentice 24 h 39 4Digital 15 h 14 5Film 10 h 8

Useful?

By Repair Owner 3 shown

1KEH 188 h 294 2Training 1 h 4 3Customer 1 h 1

Useful?