OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Template Setup Question - tabs.

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
sirius
Newbie
Newbie


Joined: 22 May 2008
Posts: 2

PostPosted: Thu May 22, 2008 2:24 am    Post subject: Template Setup Question - tabs. Reply with quote

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
View user's profile Send private message
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada

PostPosted: Thu May 22, 2008 4:45 am    Post subject: Re: Template Setup Question - tabs. Reply with quote

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
View user's profile Send private message
sirius
Newbie
Newbie


Joined: 22 May 2008
Posts: 2

PostPosted: Thu May 22, 2008 5:53 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
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