C
Clyde_22c
I am going to try and provide you some background information. I wil
attempt to provide the information you need to let me know if 1st i
what we are asking is possible and secondly can you help with some o
the how to questions I might have, and finally an estimated cost o
what you believe it would take you to help with this project. We are
construction company that typically contracts in the plumbing and HVA
arena. Now I am failry familiar with excel. Since I am familiar, thi
project would not in anyway become a real intense project for you.
would need some guidance from time to time in the "how to" department
I have been asked to do something that is normally done with estimatin
software. This company has purchased estimating and other softwares i
the past. They become dust on the bookshelf, because they are to
tedious to develop into a tool that can be used from job to job and/o
the changeover from job to job becomes to tedious to maintain. Due t
those reasons and more, people here tend to not continue with suc
softwares and they then become a waste of money from the purchase o
the software, the load it puts on the computers, and the overhead i
costs in one or more people to try to get these various software
started to begin in the first place.
We do large-scale plumbing contracting jobs that can be worth up to
few million dollars. What we are trying to do is setup a system for th
foreman on site to record progress in the job, both financial and pe
process completion percentage. We are currently setting up larg
listings of varying processes to keep track of these tasks. Fo
instance, digging out a 30 foot long ditch and installing pipe. We wan
to give this job a value in cost per foot (Based on time it takes
burdened labor hours + materials). We then want to be able to place th
number of feet that has been completed into a cell and have tha
number automatically placed into an equation that multiplies what
have in parenthesis above times the run length of pipe installed. I
the value per foot is $25.00. We installed 30 feet in length. I want t
put 30 into the cell representing Apartment #101 and have it calculat
and display $750.00 in the same cell I entered the # 30. We want to b
able to do this for every function on a given job site. We might have
processes we do on a given job or 5,000. That number will be simpl
arbitrary. In the end we want to have the abiltiy to estimate (fo
bidding purposes) what an over all job is going to cost. We want to d
this by entering the estimated scope of each individual process w
project necessary for the given customer job and have the pre-existin
formulas multiply out the costs automatically for whatever variable w
enter with regard to a each specific task.
I am entering in reference numbers per process or task. Such number
might look like 2500-75. I want to be able to give this reference (Nam
or Number) a value. For arguments sake, that reference (Name or Number
might be represented as BAND and have a numeric value of $25. I wan
the person viewing the software to see BAND and not see the numeri
value of $25. Then when the 30 is placed in as a value into anothe
cell, I want the above formula to compute the total value.
I included an attachment of one of the spreadsheets that I have begu
working on for this project. There are several different sheets al
together. They all need to go through some sort of changes. This on
especially. I guess the main point is, we want to accomplish all of ou
tracking, estimating and comparison goals while keeping the input o
information at the job site, as simplistic as possible. We want it t
be really easy for the guys on the job sites. I know this could b
possibly be starting to sound complicated, or a bit like Crissy Sno
from Three's Company, so I will end now. :confused
attempt to provide the information you need to let me know if 1st i
what we are asking is possible and secondly can you help with some o
the how to questions I might have, and finally an estimated cost o
what you believe it would take you to help with this project. We are
construction company that typically contracts in the plumbing and HVA
arena. Now I am failry familiar with excel. Since I am familiar, thi
project would not in anyway become a real intense project for you.
would need some guidance from time to time in the "how to" department
I have been asked to do something that is normally done with estimatin
software. This company has purchased estimating and other softwares i
the past. They become dust on the bookshelf, because they are to
tedious to develop into a tool that can be used from job to job and/o
the changeover from job to job becomes to tedious to maintain. Due t
those reasons and more, people here tend to not continue with suc
softwares and they then become a waste of money from the purchase o
the software, the load it puts on the computers, and the overhead i
costs in one or more people to try to get these various software
started to begin in the first place.
We do large-scale plumbing contracting jobs that can be worth up to
few million dollars. What we are trying to do is setup a system for th
foreman on site to record progress in the job, both financial and pe
process completion percentage. We are currently setting up larg
listings of varying processes to keep track of these tasks. Fo
instance, digging out a 30 foot long ditch and installing pipe. We wan
to give this job a value in cost per foot (Based on time it takes
burdened labor hours + materials). We then want to be able to place th
number of feet that has been completed into a cell and have tha
number automatically placed into an equation that multiplies what
have in parenthesis above times the run length of pipe installed. I
the value per foot is $25.00. We installed 30 feet in length. I want t
put 30 into the cell representing Apartment #101 and have it calculat
and display $750.00 in the same cell I entered the # 30. We want to b
able to do this for every function on a given job site. We might have
processes we do on a given job or 5,000. That number will be simpl
arbitrary. In the end we want to have the abiltiy to estimate (fo
bidding purposes) what an over all job is going to cost. We want to d
this by entering the estimated scope of each individual process w
project necessary for the given customer job and have the pre-existin
formulas multiply out the costs automatically for whatever variable w
enter with regard to a each specific task.
I am entering in reference numbers per process or task. Such number
might look like 2500-75. I want to be able to give this reference (Nam
or Number) a value. For arguments sake, that reference (Name or Number
might be represented as BAND and have a numeric value of $25. I wan
the person viewing the software to see BAND and not see the numeri
value of $25. Then when the 30 is placed in as a value into anothe
cell, I want the above formula to compute the total value.
I included an attachment of one of the spreadsheets that I have begu
working on for this project. There are several different sheets al
together. They all need to go through some sort of changes. This on
especially. I guess the main point is, we want to accomplish all of ou
tracking, estimating and comparison goals while keeping the input o
information at the job site, as simplistic as possible. We want it t
be really easy for the guys on the job sites. I know this could b
possibly be starting to sound complicated, or a bit like Crissy Sno
from Three's Company, so I will end now. :confused