Ask Your Question

Openoffice as appliance service tool

asked 2018-11-20 18:18:18 +0100

projectx gravatar image

updated 2018-11-27 19:07:00 +0100

EasyTrieve gravatar image

Hello everyone.

I am repairing at home electronic controllers for various home appliances for a person. He is asking me if i can attach to each board a description of the problems i found and what did i do to adress them and what parts did i replace.

I'm also trying to create a catalog starting from the parts i see damaged and all the ic's i see on them, so i can find them easilty. Does Libreoffce have something i can add to manage those situations?

edit retag flag offensive close merge delete


If there are only a few repairs you might use calc, or even writer. If you have more I would use base. Here is a page of docs for base I put together as I was learning it. (I once repaired electronic equipment. Sounds like he is trying to collect info, hoping to find cheaper ways to repair stuff. Be sure you charge more if you add this info to your repairs.)

EasyTrieve gravatar imageEasyTrieve ( 2018-11-27 19:04:36 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-11-21 09:16:38 +0100

ebot gravatar image

updated 2018-11-23 10:01:56 +0100

There is no ready made application. But there you can certainly make something. 1. A small base (HSQLDB) with e.g. two tables. 2. A form in Writer 3. A form in Calc How elaborate should the solution be designed? If you only need a small repair report for the respective device, a suitable form would be useful.

But ask yourself: How often do you need such a form? What do you really want to log? Do you really want to collect all the components, although you only want to specify the defective ones? How many devices and types are possible? How many components in total are possible?


A simple repair list in Writer might look like this:

image description

You can label them on the PC or print them blank and make handwritten entries.

edit flag offensive delete link more


If I was working on a project like this I would probably go the route of a simple Calc spreadsheet with columns like... Order #, Date Assigned, Date Completed, Customer Name, Address, City, State, Zip, Appliance Description, Components Replaced, Cost of Parts, Labor Charge, Hours Worked, Tax, Total Charged, Description of Repair(s) Performed, etc. Could either do each part # on a separate line or combined with 1 line per appliance repair procedure. Depends on the details you need to track.

PhLo gravatar imagePhLo ( 2018-11-21 10:14:29 +0100 )edit

If you need to print something like an invoice for customers you might need a more robust solution than a simple spreadsheet can provide, though you could still use a spreadsheet (or a database) and transform each line into a printable invoice via VLookups from one sheet to another.

PhLo gravatar imagePhLo ( 2018-11-21 10:15:54 +0100 )edit

Before switching to using Base, I wrote a simple invoice and inventory system using Google Sheets (like Calc), and something like that would work for you. My needs eventually expanded beyond the limits of Google Sheets, so I switched to LO Base for more complexity.

PhLo gravatar imagePhLo ( 2018-11-21 10:18:24 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-11-20 18:18:18 +0100

Seen: 70 times

Last updated: Nov 23 '18