Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default How do I use the templates for job cost tracking?

I work for a design/built firm. We provide customers with a typed (Excel) job
estimate. We then use this estimate in-house to maintain cost versus
estimate. We need a template(?) so we can pull some of the information out
for simple reporting purposes.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 207
Default How do I use the templates for job cost tracking?

Vicki,
First open a new workbook, set the worksheet just the way you want,column
width, row height, format cells, put the formulas in that you want.
When it perfect, (before someone gives added input on what it should look
like,and they will).
"File", "Save As", Name the file someething that you can easily remember,
"Save as file type:" select "Template" the file extension will change from
".xls" to ".xlt".
The next time you bring this up to use, when you have typed in all the
customers info,
THIS IS THE IMPORTANT STEP...... "File","Save As", change the "Save as file
type:" to ".xls" or it will change your template.

hth
:-)

"Vicki B" wrote:

I work for a design/built firm. We provide customers with a typed (Excel) job
estimate. We then use this estimate in-house to maintain cost versus
estimate. We need a template(?) so we can pull some of the information out
for simple reporting purposes.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Tracking Cost Price from Different Sheets Rao Ratan Singh Excel Discussion (Misc queries) 0 November 30th 06 10:05 AM
cost control templates khaled Excel Worksheet Functions 0 May 5th 06 08:40 PM
Any templates for cost analysis and presentation ? Desmond Excel Discussion (Misc queries) 1 August 18th 05 07:45 PM
Any cost estimating templates for contractors available? Joe Excel Discussion (Misc queries) 0 April 15th 05 07:33 PM


All times are GMT +1. The time now is 05:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"