LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Making an estimate

I have Excel 2010 and i am trying to make an estimating program to coorespond with our products. I have been using a template that was provided by Excel 2010 and trying to incorporate our estimating program that we have had on Excel for a few years.
The problem I am having is with the description line on the estimate template. I have it set up so i can fill out a questionaire and after answering the questions then i have a static list of what i want in the description line and a value in the cell next to it that will change if that item is to be included in the estimate.
The chart looks like this:

A B

UT 4542.461
TT Rec 0
Hydraulic Motor 0
Vinyl Recessed Housing 852.5
GRO4000 Undertrack Retainers 350
GRO4100 Undertrack Retainers 0
DDO4000 Double Deck Retainers 0
Vinyl Liner Kit 0
Vertical Flush Mounted Tracks 0
Horizontal Flush Mounted Tracks 0
Top Track 0
Aluminum Lid 0
Adjustable Walk on Lid Brackets 1615
Installation of Brackets 275
Installation 1400


These are two different columns. In Column A the words are static and the values(column B) will change based on the questions that are answered. Basically I want everything that has a value 0 in column B to be on the estimate. I want the description line to show the words in column A that coorespond with column B without any spaces in between them. Different estimates will have a different number of line items so i want to only include the line items in the estimate that will be included in the quote.
I hope i am explaining it correctly. Let me know if you need more information. Thanks.


 
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
Standard Error of the Estimate iperlovsky Excel Worksheet Functions 2 November 3rd 09 03:53 PM
Estimate time of arrival (ETA) LOSTHOUND Excel Discussion (Misc queries) 1 April 28th 08 08:50 PM
How to indicate that a value is an estimate? couture57 Excel Discussion (Misc queries) 7 March 26th 08 12:43 AM
How to set up a cost estimate spreadsheet? mgirving Excel Worksheet Functions 2 September 1st 06 03:47 PM
Template for estimate DIDI50 Excel Discussion (Misc queries) 0 January 19th 05 12:13 AM


All times are GMT +1. The time now is 12:02 AM.

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

About Us

"It's about Microsoft Excel"