Remember Me?

#1
May 4th 12, 10:29 AM
 Junior Member First recorded activity by ExcelBanter: May 2012 Posts: 3
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

#2
May 4th 12, 03:04 PM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Mar 2011 Posts: 621
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

#3
May 4th 12, 04:58 PM
 Senior Member First recorded activity by ExcelBanter: Mar 2012 Posts: 663

Quote:
 Originally Posted by glennib 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.
#4
May 4th 12, 06:02 PM
 Senior Member First recorded activity by ExcelBanter: Jul 2010 Location: Belo Horizonte, Brazil Posts: 170

Quote:
 Originally Posted by glennib 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.
Attached Files
 04-05-2012_ExcelBanter_Paint_Calculator_GLENNIB.zip (1.8 KB, 33 views)
__________________

Best regards,
Marcilio Lobão
---------------------------
Belo Horizonte, Brazil

Last edited by Mazzaropi : May 4th 12 at 06:06 PM Reason: .
#5
May 6th 12, 09:05 AM
 Junior Member First recorded activity by ExcelBanter: May 2012 Posts: 3

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

thank you all very much

glenn - S & A Painting

#6
May 6th 12, 09:33 AM
 Junior Member First recorded activity by ExcelBanter: May 2012 Posts: 3

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post TÃ© Excel Worksheet Functions 3 March 6th 09 07:17 AM enyaw Excel Programming 7 April 28th 06 12:55 AM Div. F-II Excel Discussion (Misc queries) 2 February 10th 06 02:19 PM Lance Excel Discussion (Misc queries) 3 March 28th 05 06:27 PM Lance Excel Discussion (Misc queries) 0 March 26th 05 01:21 AM

All times are GMT +1. The time now is 09:22 PM.