Inventory template question

Using them, Making them , Finding them

Inventory template question

Postby Grannykat » Fri Feb 10, 2017 2:54 am

I have three (3) columns on the right side of my inventory sheet in which I enter cost, selling price, sold price. It would be a wonderful asset if each column kept a running total (sum). Can anyone tell me (in very simple terms) how to accomplish this?
Open Office 3.1 on Windows 8
Grannykat
 
Posts: 2
Joined: Fri Feb 10, 2017 2:40 am

Re: Inventory template question

Postby robleyd » Fri Feb 10, 2017 4:34 am

The attached spreadsheet should point you in the right direction. It simply adds the amount in the column on the left of current cell to the subtotal in the row above the current cell.

 Edit: My solution is for a spreadsheet and I just noticed this is in the Writer section. Is your inventory actually a Writer document? 
Attachments
running_total.ods
(8.15 KiB) Downloaded 75 times
Cheers
David
Apache OpenOffice 4.1.4 - Windows 7
Apache OpenOffice 4.1.5 - Slackware 14.2 - 64 bit
User avatar
robleyd
Moderator
 
Posts: 1585
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Inventory template question

Postby Grannykat » Mon Feb 13, 2017 4:10 am

I suppose a spreadsheet would work. Is it possible to move it all from the inventory form to a spreadsheet without manually re-entering every item?. I have over 7.5k items.
Open Office 3.1 on Windows 8
Grannykat
 
Posts: 2
Joined: Fri Feb 10, 2017 2:40 am

Re: Inventory template question

Postby RusselB » Mon Feb 13, 2017 6:20 am

If your data is already in a table, then you can use the SUM function in a row of the table. The function can be entered using Table -> Function (F2)

If you want to go over to a spreadsheet, you should be able to just copy your data from the Writer document, then paste it into a Calc document.
Paste Special (Ctrl+Shift+V) might be a better idea than Paste (ctrl+v), especially if you are copying a formatted table into Calc.
OpenOffice 4.1.4 and LibreOffice 5.2.7.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
RusselB
Volunteer
 
Posts: 4321
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Inventory template question

Postby Villeroy » Mon Feb 13, 2017 12:23 pm

Having a spreadsheet with data and calculations...

menu:File>New>Database...
[X] Connect to existing database
Type: Spreadsheet
Specify the spreadsheet document
[X] Register the database
Save the database
Click the [Tables] section
Right-click the "database table" (it is just an alternative view on your spreadsheet data) and choose "Create Report..."
Follow the instructions.
The result is a Writer document with all the table data pulled from the spreadsheet. The Writer document is embedded in the database document.
The report is filled with table data every time you open it. After the spreadsheet document had been modified or exchanged completely, you should restart the office suite. Otherwise the changes won't be reflected in the database report. This is a draw back when using spreadsheets as data sources.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 25261
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Inventory template question

Postby RusselB » Tue Feb 14, 2017 2:04 am

@Villeroy: It's my understanding that the data is already in a Writer document and the OP was wondering about how to transfer the data to a spreadsheet.
OpenOffice 4.1.4 and LibreOffice 5.2.7.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
RusselB
Volunteer
 
Posts: 4321
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Inventory template question

Postby Villeroy » Tue Feb 14, 2017 2:14 am

Copy&Paste-Special as HTML
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 25261
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Templates

Who is online

Users browsing this forum: No registered users and 3 guests