Shop jobs list (current)
A spreadsheet file for the Sample Fix-It Shop, kept on the shop computer and emailed home now and then.
| Row | A | B | C | D | E | F | G | H | I | J | K | L |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Job | First | Last | Phone | Item | Problem | In | Out | Status | Paid | Notes | |
| 2 | 1 | Sample | Customer 1 | 555-0101 | customer1@example.com | TABLE LAMP | Flickers | 10/2 | Oct 7 | picked up | Y | |
| 3 | 2 | Sample | Customer 2 | 555 0102 | customer2@example.com | toaster | One side stays cold | Oct 5 | 10/10/26 | PU | ||
| 4 | 3 | Sample | Customer 3 | 5550103 | customer3@example.com | mantel clock | Stops at night | 10/8/26 | PART ORDERED | spring is on order | ||
| 5 | 4 | Sample | Customer 4 | 555.0104 | VACUUM CLEANER | No suction | 2026-10-09 | done | called once, no answer (call?) | |||
| 6 | 4 | Sample | Customer 4 | 555-0104 | VACUUM CLEANER | No suction | 2026-10-09 | in | dup? | |||
| 7 | 5 | Sample | Customer 5 | 555-0105 | customer5@example.com | sewing machine | Thread jams | 10/12 | in | |||
| 8 | 6 | Sample | Customer 1 | 555 0101 | customer1@example.com | radio | No sound | Oct 14 | DONE | CALL | ||
| 9 | 7 | Sample | Customer 6 | 5550106 | customer6@example.com | FLOOR FAN | Rattles | 10/15/26 | 2026-10-20 | gone | Y | |
| 10 | 8 | Sample | Customer 7 | 555.0107 | customer7@example.com | stand mixer | Will not turn on | 2026-10-19 | waiting | motor brush is on order (call?) | ||
| 11 | 9 | Sample | Customer 8 | 555-0108 | desk lamp | Switch is broken | 10/20 | Oct 25 | picked up | pd | ||
| 12 | 10 | Sample | Customer 9 | 555 0109 | customer9@example.com | RECORD PLAYER | Plays too fast | Oct 22 | working on it | |||
| 13 | 11 | Sample | Customer 10 | 5550110 | customer10@example.com | coffee maker | Leaks | 10/26/26 | ready!! | CALL | ||
| 14 | 12 | Sample | Customer 11 | 555.0111 | customer11@example.com | hair dryer | Cuts out | 2026-10-28 | 10/28 | picked up | ? | |
| 15 | 13 | Sample | Customer 12 | 555-0112 | customer12@example.com | ELECTRIC KETTLE | Will not shut off | 11/2 | in | |||
| 16 | 14 | Sample | Customer 3 | 555 0103 | wall clock | Hands are loose | Nov 3 | DONE | CALL | |||
| 17 | 15 | Sample | Customer 13 | 5550113 | customer13@example.com | space heater | Smells hot | 11/5/26 | PART ORDERED | new switch is on order | ||
| 18 | 16 | Sample | Customer 14 | 555.0114 | customer14@example.com | BLENDER | Cracked jar | 2026-11-09 | waiting | jar is on order (call?) | ||
| 19 | 17 | Sample | Customer 15 | 555-0115 | customer15@example.com | floor lamp | Needs a new cord | 11/10 | in | |||
| 20 | 18 | Sample | Customer 16 | 555 0116 | customer16@example.com | electric drill | Sparks | Nov 12 | working on it | |||
| 21 | ||||||||||||
| 22 | ||||||||||||
| 23 | ||||||||||||
| 24 |
- Jobs 2026
- Jobs OLD
- Copy of Jobs 2026
- Sheet4
What it was like
A spreadsheet is a good tool, and this one did its job for years. It grew one row at a time. Different people typed dates and notes in different ways. To find a job, you scrolled or used find. There was one copy at the shop and an older one at home, and nobody was sure which was newest.