Difference between revisions of "Caesar"
(→Download) |
(→Download) |
||
| Line 19: | Line 19: | ||
===Download=== | ===Download=== | ||
* [[media:caesar.ods|Caesar version 0.1]] | * [[media:caesar.ods|Caesar version 0.1]] | ||
| + | ===Instructions=== | ||
| + | Caesar.ods is a spreadsheet that can be opened by OpenOffice.org spreadsheet. It has three tabs: config, inventory, and invoices. The main purpose of the config tab is to point to the productlist.xls spreadsheet that you have downloaded from CSPS. The productlist.xls contains all the prices and item descriptions that will be used by Caesar. Without it, the caesar.ods will have lots of broken link errors. | ||
| + | |||
| + | After the config tab is properly filled in, the inventory tab can be populated with the inventory by entering the product ID of each item, quantity on hand, and location. | ||
| + | |||
| + | The invoice tab can generate an invoice in a similar fashion. Enter a product ID and quantity, and the invoice will determine the price and grand total. | ||
===Licensing=== | ===Licensing=== | ||
Revision as of 18:25, 13 November 2009
Contents
Caesar: Inventory and Invoice Software for Reading Rooms
This is an open source project to provide a free tool for Christian Science Reading Rooms to manage their inventory. It is based on the product list published by the Christian Science Publishing Society.
It is essentially a set of macros that run within a spreadsheet to allow a Reading Room librarian to record sales transactions and to have those transactions directly applied to current inventory records.
The first stages of development have shown the limitations spreadsheet macros. So now, the direction is to make Caesar based on the Open Office database which will be driven by the spreadsheet published by the Publishing Society.
When a new price list is published, it will be seamlessly inserted into the spreadsheet, causing all the prices to update, but leaving the inventory records intact.
Requirements
- Open Office Calc (http://www.openoffice.org)
- Windows, Mac, or Linux
Availability
Version 1.0 of Caesar will be available for free download from this site in the winter of 2009. A test version is available now in the Download section.
Download
Instructions
Caesar.ods is a spreadsheet that can be opened by OpenOffice.org spreadsheet. It has three tabs: config, inventory, and invoices. The main purpose of the config tab is to point to the productlist.xls spreadsheet that you have downloaded from CSPS. The productlist.xls contains all the prices and item descriptions that will be used by Caesar. Without it, the caesar.ods will have lots of broken link errors.
After the config tab is properly filled in, the inventory tab can be populated with the inventory by entering the product ID of each item, quantity on hand, and location.
The invoice tab can generate an invoice in a similar fashion. Enter a product ID and quantity, and the invoice will determine the price and grand total.
Licensing
Licensing will be based on the Open Office Suite license.
Note about the name
The idea is to "render unto Caesar the things that are Caesar's" while not being distracted from the main goal of publishing and healing.
