Repair Logs

--:--

synced 8d ago

11,070

Logged Rows

8,532

Unique Items

6

Technicians

9,275

Labor Hours

from 11,016 rows (100%)

194

Search Hours

from 691 rows (6%)

$110k

Parts Cost

from 2,835 rows (26%)

Clear 1

DisciplineLens ×

2025-01-02 → 2026-09-16· 51 min avg/job· 39 brands

Volume by Month hover a column for hours and cost

499

25-01

572

25-02

635

25-03

785

25-04

643

25-05

626

25-06

696

25-07

557

25-08

434

25-09

621

25-10

493

25-11

569

25-12

511

26-01

531

26-02

474

26-03

536

26-04

448

26-05

466

26-06

471

26-07

371

26-08

132

26-09

Useful?

Parts Hold Watchlist 941 jobs waiting on parts

941

Jobs Held

844

Items Held

$2,354

Parts Value

By Brand

1Canon 28.8% 271 search

2Nikon 14.8% 139 search

3Sony 13.8% 130 search

4Sigma 11.6% 109 search

5Tamron 7% 66 search

6Other 6.4% 60 search

By Part Needed

1Grip 0.4% 4 search

2Front Ring 0.4% 4 search

3Flex 0.4% 4 search

4A-2180-241-B 0.4% 4 search

5glued grip 0.3% 3 search

6YA2-3463-000 0.3% 3 search

Useful?

Status Funnel where work accumulates

1 Quality Check 6.3% 636 search

2 Re-estimate 1.7% 175 search

3 Parts Hold 9.3% 941 search

4 Incomplete 0.3% 30 search

5 Complete 73.1% 7,380 search

6 Not Repaired 3.6% 368 search

7 Other 5.5% 559

Useful?

Fault Pareto 16 of 157 faults = 80% of work

1Parts Missing 26.3%

2Parts Loose 36.7%

3Weather Seal Damaged 42.9%

4AF inop 47.3%

5Grip Loose 51.6%

6AF Erratic 55.7%

7Impact Damage 59.7%

8Aper Inop 62.6%

9Focus Squeek 65.5%

10Focus Stiff 68.1%

11Focus Rough 70.5%

12Inop 72.8%

Useful?

Who Fixes What darker = more jobs

	Parts Missing	Parts Loose	Weather Seal Damaged	AF inop	Grip Loose	AF Erratic	Impact Damage	Aper Inop	Focus Squeek	Focus Stiff	Focus Rough	Inop
Remy	43	114	52	193	16	202	106	125	119	78	125	3
Onyx	44	101	68	135	29	115	1	78	111	115	59	44
Reese	1,725	361			15		120	17		8	2	117
Harlow	354	273	188	17	56	3	75	10		9	7	26
Harlow34	4	3	210	18	231	22	25	15	2	5	10
Mika

Useful?

By Diagnosis what actually broke

1Parts Missing 639 h 2,170 2Parts Loose 399 h 852 3Weather Seal Damaged 227 h 518 4AF inop 433 h 363 5Grip Loose 167 h 347 6AF Erratic 351 h 342 7Impact Damage 261 h 327 8Aper Inop 333 h 245 9Focus Squeek 322 h 232 10Focus Stiff 286 h 215 11Focus Rough 238 h 203 12Inop 184 h 190 13Zoom Stiff 215 h 178 14Foam Bad 14 h 147 15Seals Bad 71 h 141

Useful?

By Technician 6 shown

1Remy 3,132 h 2,994 2Onyx 3,147 h 2,968 3Reese 1,366 h 2,932 4Harlow 923 h 1,396 5Harlow34 706 h 779 6Mika 1 h 1

Useful?

By Status 14 shown

1Complete 6,037 h 7,380 2Parts Hold 581 h 941 3Quality Check 115 h 636 4Not Repaired 335 h 368 5AI - Ebay 194 h 283 6Re-estimate 108 h 175 7OEM 82 h 95 8Mod - Ebay 73 h 83 9RP Gear 69 h 79 10Incomplete 48 h 30 11End of day 12 h 10 12Research/Troubleshooting Help 13 h 5 13Kickback 14 h 3 14END OF DAY 2 h 1

Useful?

By Brand 15 shown

1Canon 2,132 h 2,861 2Nikon 2,007 h 2,203 3Hasselblad 839 h 843 4Sony 613 h 833 5Other 355 h 826 6Sigma 550 h 662 7Tamron 384 h 492 8Leica 214 h 427 9Fujifilm 197 h 317 10Pentax 166 h 227 11Mamiya 215 h 226 12Olympus 87 h 135 13Panasonic 64 h 116 14Rollei 184 h 89 15Minolta 36 h 69

Useful?

By Repair Code 15 shown

1J01 666 h 1,618 2R01 1,358 h 1,379 3R22 919 h 806 4QAMIS 200 h 694 5R02 620 h 612 6R20 433 h 358 7SEAL 97 h 307 8grip 156 h 266 9seal 155 h 259 10INV 47 h 183 11J03 331 h 180 12J06 54 h 161 13R25 214 h 146 14R24 73 h 135 15R23 124 h 135

Useful?

By Discipline 1 shown

1Lens 9,275 h 11,070

Useful?

By Repair Owner 10 shown

1KEH 6,264 h 8,639 2Customer 1,188 h 1,146 3CPR 370 h 429 4Training 560 h 332 5Internal 263 h 180 6Extend 128 h 120 7Admin 380 h 108 8Redo 34 h 40 9CUSTOMER 3 h 1 10CUST0MER 4 h 1

Useful?