Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 4th 12, 10:29 AM
Junior Member
 
First recorded activity by ExcelBanter: May 2012
Posts: 3
Default 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   Report Post  
Old May 4th 12, 03:04 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2011
Posts: 621
Default 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
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

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

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

Quote:
Originally Posted by glennib View Post
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.

Its 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.
Fell free to ask anything about your question.

Have a nice day.
Attached Files
File Type: zip 04-05-2012_ExcelBanter_Paint_Calculator_GLENNIB.zip (1.8 KB, 33 views)
__________________
I hope it can help you.

Best regards,
Marcilio Lobo
---------------------------
Belo Horizonte, Brazil

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

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   Report Post  
Old May 6th 12, 09:33 AM
Junior Member
 
First recorded activity by ExcelBanter: May 2012
Posts: 3
Default

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


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
Excel Template (Creating a Function in the template) Excel Worksheet Functions 3 March 6th 09 07:17 AM
creating template enyaw Excel Programming 7 April 28th 06 12:55 AM
template creating Div. F-II Excel Discussion (Misc queries) 2 February 10th 06 02:19 PM
Template for estimating sign pricing and quoting ? Lance Excel Discussion (Misc queries) 3 March 28th 05 06:27 PM
Template for estimating sign pricing and quoting ? Lance Excel Discussion (Misc queries) 0 March 26th 05 01:21 AM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017