| View previous topic :: View next topic |
| Author |
Message |
sirius Newbie

Joined: 22 May 2008 Posts: 2
|
Posted: Thu May 22, 2008 2:24 am Post subject: Template Setup Question - tabs. |
|
|
I wonder if anyone can advise me here.
Im not too familiar with spreadsheets, however, my needs are very simple.
What I want to do, is create a sheet template which has embedded pictures assigned to various parts of the sheet, and title boxes/laid out grids which similarly have standard text in some of the boxes and editable/changeable text in other boxes ("cells").
But, what I need to do, if possible, is I want to be able to start a new 'tab' (sheet) within the spreadsheet document and the default template to load every time in the new sheet, where I then fill in the new documents information into the pre-made layout.
Here is a picture to help explain:
http://img376.imageshack.us/my.php?image=jobrecordsra5.jpg
Each 'job' we do, we assign a number. The tabs/pages/sheets at the bottom will be named to match the job.
The aim is to electronically record our jobs, in compliance to ISO9001 / 9002, document the design information, record times and prices etc etc. This way, we can easily find the information all in one place - what the job looks like, who it was for, how much it cost, how long it took to design, what the customer component number was, when it was done, etc etc. Maybe even search the spreadsheet for information, if its possible.
I also want to do one for Engineering Machining. With boxes for the machining 3d model picture, and spreadsheet allocation "cells" to instruct the machine shop on which tools to use and what the various steps are to make the part.
Again, that would be best if we can make the job numbers roll along the bottom of the spreadsheet in tabs.
Is this possible? If not, Is it possible in Microsoft products? Is there another program better suited to this task than using Spreadsheets?.
I tried the Writng package in Open Office, but it doesnt have tabbed pages along the bottom, and therefore scrolling down would be problematic finding jobs.
Thanks,
Sirius. |
|
| Back to top |
|
 |
jrkrideau Super User

Joined: 08 Aug 2005 Posts: 6733 Location: Kingston ON Canada
|
Posted: Thu May 22, 2008 4:45 am Post subject: Re: Template Setup Question - tabs. |
|
|
| sirius wrote: | I wonder if anyone can advise me here.
Im not too familiar with spreadsheets, however, my needs are very simple.
What I want to do, is create a sheet template which has embedded pictures assigned to various parts of the sheet, and title boxes/laid out grids which similarly have standard text in some of the boxes and editable/changeable text in other boxes ("cells").
But, what I need to do, if possible, is I want to be able to start a new 'tab' (sheet) within the spreadsheet document and the default template to load every time in the new sheet, where I then fill in the new documents information into the pre-made layout.
Here is a picture to help explain:
http://img376.imageshack.us/my.php?image=jobrecordsra5.jpg
Each 'job' we do, we assign a number. The tabs/pages/sheets at the bottom will be named to match the job.
The aim is to electronically record our jobs, in compliance to ISO9001 / 9002, document the design information, record times and prices etc etc. This way, we can easily find the information all in one place - what the job looks like, who it was for, how much it cost, how long it took to design, what the customer component number was, when it was done, etc etc. Maybe even search the spreadsheet for information, if its possible.
I also want to do one for Engineering Machining. With boxes for the machining 3d model picture, and spreadsheet allocation "cells" to instruct the machine shop on which tools to use and what the various steps are to make the part.
Again, that would be best if we can make the job numbers roll along the bottom of the spreadsheet in tabs.
Is this possible? If not, Is it possible in Microsoft products? Is there another program better suited to this task than using Spreadsheets?.
I tried the Writng package in Open Office, but it doesnt have tabbed pages along the bottom, and therefore scrolling down would be problematic finding jobs.
Thanks,
Sirius. |
Hi,
I think I understand what you want but I am not sure that a spreadsheet is the way to go. You probably could get it to work but it's not the right tool for the job.
You might want to have a look at using a data base to handle this. In fact it looks lilke exactly the type of thing that a data base is intended for. _________________ jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
 |
sirius Newbie

Joined: 22 May 2008 Posts: 2
|
Posted: Thu May 22, 2008 5:53 am Post subject: |
|
|
Thankyou for your reply.
Im not very accustomed to office software besides typing a few documents, because Im more a Computer Aided Designer and general graphics software/Audio software person. Im pretty new to Open Office, and I must say Im very impressed with it so far.
I notice there is a "base" program in the suite, but it told me I need a JRE installing and before I have that I cant use it....so Im doing that downloading now from Sun Micro.
I will see how I go on (and maybe re-post in the base forum).
Cheers
Sirius. |
|
| Back to top |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|