Repair Logs

--:--

synced 8d ago

4,957

Logged Rows

3,383

Unique Items

6

Technicians

5,118

Labor Hours

from 4,789 rows (97%)

329

Search Hours

from 2,809 rows (57%)

$138k

Parts Cost

from 1,041 rows (21%)

Clear 2

DisciplineDigital × CodeR01 ×

2016-06-17 → 2026-09-16· 64 min avg/job· 20 brands

Volume by Month hover a column for hours and cost

1

16-06

236

25-01

226

25-02

198

25-03

188

25-04

266

25-05

210

25-06

332

25-07

342

25-08

225

25-09

246

25-10

205

25-11

182

25-12

212

26-01

171

26-02

258

26-03

277

26-04

285

26-05

252

26-06

260

26-07

261

26-08

123

26-09

Useful?

Parts Hold Watchlist 1,101 jobs waiting on parts

1,101

Jobs Held

885

Items Held

$30.2k

Parts Value

By Brand

1Sony 43.8% 482 search

2Canon 27% 297 search

3Nikon 15.6% 172 search

4Leica 6.2% 68 search

5Fujifilm 3.6% 40 search

6Panasonic 2% 22 search

By Part Needed

1lpf 1% 11 search

2main pcb 0.8% 9 search

3LPF 0.8% 9 search

4shutter 0.7% 8 search

5side grip 0.5% 6 search

6rear lcd 0.5% 6 search

Useful?

Status Funnel where work accumulates

1 Quality Check 1.4% 68 search

2 Re-estimate 5.4% 266 search

3 Parts Hold 22.4% 1,101 search

4 Incomplete 1.1% 52 search

5 Complete 55.6% 2,730 search

6 Not Repaired 5.3% 260 search

7 Other 8.8% 431

Useful?

Fault Pareto 12 of 61 faults = 80% of work

1Inop 15%

2Error 29.3%

3Impact Damage 40%

4Parts Missing 49.7%

5LCD Damage 56.9%

6Dial Issues 63.4%

7Sensor Damaged 67.3%

8Parts Loose 71.1%

9Sensor Dirty 74.6%

10Shutter Speeds Inop 77.4%

11Shutter Speeds Off 79.7%

12Grip Loose 82.1%

Useful?

Who Fixes What darker = more jobs

	Inop	Error	Impact Damage	Parts Missing	LCD Damage	Dial Issues	Sensor Damaged	Parts Loose	Sensor Dirty	Shutter Speeds Inop	Shutter Speeds Off	Grip Loose
Noa	359	286	150	228	155	106	67	78	61	20	11	34
Nico	117	223	157	119	64	88	62	46	51	96	84	7
Mika	86	82	80	51	49	17	10	15	23	2	13	10
Quinn	4	17	40	10	15	27	18	5	8			14
Eden	106	4	60	9	10	15	16	6	4	2		4
Dell	5	36		19	37	39	4	21	13	4		37

Useful?

By Diagnosis what actually broke

1Inop 762 h 677 2Error 806 h 648 3Impact Damage 510 h 487 4Parts Missing 323 h 436 5LCD Damage 263 h 330 6Dial Issues 285 h 292 7Sensor Damaged 174 h 177 8Parts Loose 145 h 171 9Sensor Dirty 158 h 160 10Shutter Speeds Inop 178 h 124 11Shutter Speeds Off 207 h 108 12Grip Loose 70 h 106 13Button Issues 100 h 100 14LCD Cracked 80 h 98 15Water Damage 70 h 81

Useful?

By Technician 6 shown

1Noa 1,824 h 1,889 2Nico 1,574 h 1,298 3Mika 477 h 545 4Quinn 526 h 518 5Eden 458 h 384 6Dell 259 h 323

Useful?

By Status 15 shown

1Complete 3,166 h 2,730 2Parts Hold 882 h 1,101 3Re-estimate 185 h 266 4Not Repaired 343 h 260 5Mod - Ebay 173 h 190 6AI - Ebay 86 h 129 7RP Gear 75 h 84 8Quality Check 48 h 68 9Incomplete 63 h 52 10OEM 11 h 8 11Part Order 4 h 6 12parts hold 4 h 3 13Research/Troubleshooting Help 4 h 3 14Parts hold 4 h 2 15Part(s) Retrieval 1 h 2

Useful?

By Brand 15 shown

1Sony 1,600 h 1,638 2Canon 1,407 h 1,488 3Nikon 980 h 963 4Fujifilm 269 h 264 5Leica 439 h 226 6Panasonic 149 h 144 7Olympus 100 h 97 8Ricoh 56 h 54 9Hasselblad 45 h 26 10Pentax 19 h 16 11Sigma 15 h 11 12Other 6 h 6 13Rollei 19 h 4 14Tamron 0 h 3 15Samsung 2 h 3

Useful?

By Repair Code 1 shown

1R01 5,118 h 4,957

Useful?

By Discipline 1 shown

1Digital 5,118 h 4,957

Useful?

By Repair Owner 10 shown

1KEH 3,641 h 3,591 2Customer 1,256 h 1,172 3Extend 69 h 70 4CPR 60 h 62 5Training 64 h 34 6Internal 12 h 12 7Sony Warranty 6 h 5 8Redo 4 h 5 9KEh 5 h 3 10Keh 1 h 1

Useful?