Hey folks,
I'm a basic excel user here, nothing too advanced. I use Excel for MAC 2011. I'm trying to do a project for work which requires some advanced (to me) functionality. I think I'm pretty good at self teaching, I just need to know where to start looking to learn how to do this type of stuff. I'm hoping you guys can point me in the right direction.
Here's what I want to do:
I work for a specialty construction contractor as an estimator/project manager. I currently use excel to put my estimates together, but it only has some basic formulas for calculation.
I'm hoping to create a workbook that will allow me to efficiently put together pricing for installation of traffic signage. Every quarter, we get a catalog from our supplier with costs for all the components that go into a sign (sign panel, post, concrete footing, fasteners, etc...). I want to create a spreadsheet that allows me to use drop down menus to build a sign out. The drop down menus would reference the current pricing info from a database I create
I know how to do the basic formulas (i.e. take material cost and generate profit margins). What I don't know how to do is create a database of items and costs and then have excel reference this database
For example, I would like my worksheet to look like this:
---------------------------------------------------------------------
SIGN TYPE: <user types in sign name> example: ""30'x30' Stop Sign into landscape"
QUANTITY: <user selects quantity numer> example: "3"
MATERIALS:
POST TYPE: <drop down menu of post types> example: "Green Channel Post - 8' "
PANEL 1 <drop down menu of sign panel types> example: "30"x30" STOP
PANEL 2 <drop down menu of sign panel types> example: "6" x 18" PEDESTRIAN CROSSING"
ADD 1 <drop down menu of general add-ons> example: "Concrete Footing"
ADD 2<drop down menu of general add-ons> example: "Fastening brackets"
LABOR PER SIGN - MAN HOURS <user types numerical value>
COST: <value collected from adding together above selections>
MARGIN <takes costs and calculates profit margins at various percentages>
---------------------------------------------------------------------
What do you guys think? Is this beyond what excel is capable of doing?
Thanks!
Bookmarks