ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   creating a estimating template (https://www.excelbanter.com/new-users-excel/445968-creating-estimating-template.html)

 glennib May 4th 12 10:29 AM

creating a estimating template

hello all,

im new to excel and need to create a estimating system for my painting business.

so ill be needing a 5 cell equasion which would be length x heigh = sqm x price per sqm = dollar amount total

where should i start for this.. is there any tutorials u could recommend based on my simple requirements ? thansk

 Gord Dibben[_2_] May 4th 12 03:04 PM

creating a estimating template

Simplest terms..........

A1...........length
B1..........height
C1..........price/sqm

D1..........=A1*B1*C1 returns amount total

Gord

On Fri, 4 May 2012 09:29:04 +0000, glennib
wrote:

hello all,

im new to excel and need to create a estimating system for my painting

so ill be needing a 5 cell equasion which would be length x heigh = sqm
x price per sqm = dollar amount total

where should i start for this.. is there any tutorials u could recommend
based on my simple requirements ? thansk

 Spencer101 May 4th 12 04:58 PM

Quote:
 Originally Posted by glennib (Post 1601479) hello all, im new to excel and need to create a estimating system for my painting business. so ill be needing a 5 cell equasion which would be length x heigh = sqm x price per sqm = dollar amount total where should i start for this.. is there any tutorials u could recommend based on my simple requirements ? thansk
Hi, if you put the width in metres in A1, height in metres in B1 and cost per square metre in C1 and the formula =(A1*B1)*C1 in cell D1, that will give you the cost for the job.

Hope that helps.

S.

 Mazzaropi May 4th 12 06:02 PM

1 Attachment(s)
Quote:
 Originally Posted by glennib (Post 1601479) hello all, im new to excel and need to create a estimating system for my painting business. so ill be needing a 5 cell equasion which would be length x heigh = sqm x price per sqm = dollar amount total where should i start for this.. is there any tutorials u could recommend based on my simple requirements ? thansk
<<<<< HELP from BRAZIL

Dear glennib, Good Afternoon.

Itīs simple to implement this on Excel.

I did an example for you.
Take a look at this and tell me if it worked for you.

Have a nice day.

 glennib May 6th 12 09:05 AM

thank you all so much ! i really appreciate the help you guys have given me special thanks also for putting it all together for me Mazzaropi !!

ill have a tinker with it as it is perfect for what i was after just have to add some more columes for walls , ceilings etc but i think by the example ill have a basic understanding :D

thank you all very much

glenn - S & A Painting

 glennib May 6th 12 09:33 AM

hey just got a question lol

is it possible to completely delete the colums i wont be using once template has been made ? as ill be using this on a tablet pc and would like it to perfectly fit the screen so if i wont be needing colum ghijk can those be deleted from the spread sheet ?

thanks

 All times are GMT +1. The time now is 03:45 PM.