Adding Labour Costs
Morning,
Is there a way to add labour costs to the report to that it is counted in the total cost but the working is not shown?
Views: 251
Replies to This Discussion
-
Permalink Reply by Render Plus on
-
Do you want to add labor for each row of the report?
You can have attrbiutes which are used in the calculation, but not shown in the report. You check the 'Suppress' field on the attribute. And then use a calculation to add them to the total cost per line.
Or do you want to add Labor as an additional Row, which does not show up on the report, but is added to the totals?
In this case you would create a "Labor" component and we would have to add an attribute to the component to cause it to be added to the totals but not shown on the report. If this is what you want, I will have to add add a new feature to do it.
-
Permalink Reply by Scott Francis Allan on
-
Al,
I am trying to create a design and costing solution using sketchup and spacedesign to cost and present as an a4/a3 for each project.
The report that will include bathroom components, shower, bath wc etc with costs, I then require to add advertising, plumbing, electrical, profit, VAT as a total without the client seeing the individual figures but the total given for the project. One of these hidden cost is commision which will be based on the total pre VAT then VAT added to the new total.
If a client want extra element such as lighting, a componant can be created with a labout cost which will then be added to the project also.
Al Hart said:Do you want to add labor for each row of the report?
You can have attrbiutes which are used in the calculation, but not shown in the report. You check the 'Suppress' field on the attribute. And then use a calculation to add them to the total cost per line.
Or do you want to add Labor as an additional Row, which does not show up on the report, but is added to the totals?
In this case you would create a "Labor" component and we would have to add an attribute to the component to cause it to be added to the totals but not shown on the report. If this is what you want, I will have to add add a new feature to do it.
-
-
Will the total of all add-on costs be shown as a line item in the report, or only in the totals?
We don't have a provision for sub-totals, and then calculations from the sub-total, or seperating out VAT into a separate line item. However, you can save the report data as a CSV file and then add more to it and reformat it in Excel.
-
-
Selected totals could be shown, extras works to be undertaken for example.
The idea is not to export to another file as this will allow for possible user error. The ideal is to have set costs already as part of the total with components making up the remainer of the cost plan then 2 % values added to these and finally a total.
I hope I am explaining myself. If needed I can send a sample cost breakdown to assist.
-
-
See if you can set up an excel spread sheet to show me a sample of what you are looking for.
It will be best if you can create what you want without sub totals. (As this adds a lot of complexity to SpaceDesign Reporting. But I will consider it. (For example if you can calculate VAT row by row, rather than at the end)
We can do a lot with rows created by invisible components.
-
-
Al,
This is the list I am currently working with;
Advertising = £(hidden value)
Plumbing = £(hidden value)
Electrics =£(hidden value)
Joiner = £(hidden value)
Tiles = £(based on area of wall calculation if possible)
Tiler = £(based on titles x value)
Products = £(component total)
Profit as a % of total = £(hidden value)
Commission at 11.1% = (hidden value)
Total Cost = (value)
VAT =(value)
Contract Price =(value)
Do you have an email address as i have a sample .skp file I can forward as it wont upload for some reason.
-
-
You can send a .SKP file to al.hart@renderplus.com
I presume that all of these items are calculated from totals of the components.
Are the tiles calculated from total area - even though it is not quite correct. (Rather than doing a total for each wall and rounding up the dimensions)
Have you done any ruby programming at all?
The easiest way for us to do this might to call a ruby script. We could make the totals of each column available to it, and it could add the, (non hidden), line items to the report.
The ruby script would look like this
def add_ons(totals)
advertising = 1800.00
plumbing = 1400.00
electrics = 800.00
joiner = 1200.00
tiles = total['Area'] / 144.0
tiles = tiles.ceil #rounds up to next integer
tiler = tiles * 1.45
products = total['extended cost']
profit = products * (1.0/0.75)
new_total = products + advertising + plumbing + electrics + joiner + tiler + profit
commission = new_total * 1.111
total_cost = new_total + commission
vat = total_cost * 0.175
contact_price = total_cost + vat
# add rows to report
sd_add_row("Total Cost", total_cost)
sd_add_row("VAT", vat)
sd_add_row("Contract Price", contrace_price
end#def
You would have to create a ruby file like this for each project.
-
-
This new feature "Custom Report Rows" will probably do what you need.
Here is a sample report with VAT added:
(Ignore the $ signs - the currency signs, and decimal point symbol are determined by your Windows settings)
The Total row was added by the report. The VAT and Total Cost rows were added by the ruby script, based on the calculated total cost.
This will required that you make changes to a default ruby script, which is then saved in your model, so you can repeat the same results:
(This looks confusing, but it won't be that hard to make a few changes)
# ruby file to generate custom report data
# copyright 2011 Render Plus Systems
# For use with SpaceDesign
# for documentation see:
# replace "extended_cost" with the name of your total cost column.
# calculate new values and add to new rows.
def add_custom_rows
trace("ADD CUSTOM ROWS") # traces are displayed on the ruby console.
#get total_cost
total_cost = total_row["extended_cost"] # replace "extended_cost" with the name of your extended_cost column
total_cost = total_cost.to_f # make sure this has a value if nil
trace("TOTAL COST: %s", total_cost)
# calucalte VAT from total cost
vat = total_cost * 0.175
# add a divider line in extended_cost column
# custom_row is a hash array. You can add values to if for any attributes included in the report
# start a new custom row
# ---------- will appear in the name or description column
custom_row = start_custom_row("----------") # start a new custom row
custom_row["extended_cost"] = "----------" # add a divider line in extended_cost column
# add the custom row to report
add_custom_row
# display VAT calculation
custom_row = start_custom_row("VAT") # start a new custom row
svalue = sprintf("%.2f", vat) # format to two decimal places
svalue2 = dll_call_format_currency(svalue) # add currency formating
trace("VAT: %s", svalue2) # display on ruby console
custom_row["extended_cost"] = svalue2 # this adds the currency value to the entended_cost column
add_custom_row # add the custom row to report
# add a divider line in extended_cost column
custom_row = start_custom_row("===========") # start a new custom row
custom_row["extended_cost"] = "===========" # add a divider line in extended_cost column
add_custom_row # add the custom row to report
# display new total cost
custom_row = start_custom_row("Total Cost") # start a new custom row
svalue = sprintf("%.2f", vat + total_cost) # format to two decimal places
svalue2 = dll_call_format_currency(svalue) # add currency formating
custom_row["extended_cost"] = svalue2
add_custom_row # add the custom row to report
end#def
-
-
Al,
The example looks great, which ruby files requires altering with the code above?
-
-
Take a look at the documentation for this: Custom Report Rows
The ruby code is saved in the SketchUp model, and accessed with three buttons on the Report Setup Wizard. You save the ruby code to a text file, edit it and reload it.
I will be uploading a new version with this feature enabled later today.
Al
Scott Francis Allan said:Al,
The example looks great, which ruby files requires altering with the code above?
-
-
Al,
How will I be able to download the update? Also, can the report calculate areas of a component ie a flat wall of a given material and report on these which in turn can be given a value and shown as a total?
-
-
I will add a post here when the new version is uploaded.
You can calculate "area", but you need to decide which dimensions to multiply to calculate the area, based on te original orientation of the component - before rotation. (Scaling is handled peoperly)
We call the three edges %w%, %d%, and %h% (for width, depth and height. w, d, and h are set to the x, y, and z values of the bounding box of the component definition. Depending on how the component was draw you will need to select the proper ones so multiply.
If you draw an angled wall in place, and then make it a component, the bounding box will not be correct. You would need to draw your wall square to a plane, and then rotate and scale it into place for this to work properly.
You would need to have drawn all walls consistently to make this work.
Here is an attribute set to calculate the area of a component, based on width and height:
Since SketchUp likes to store all dimension in inches, I added " /144.0 " to the calculation to change it to square feet.
Then I added these lines to the custom rows script:
total_area = total_row["Total Area"] # replace "extended_cost" with the name of your extended_cost column
total_area = total_area.to_f # make sure this has a value if nil
trace("total_area : %s", total_area)
#calculate tiles from total area
tiles = total_area/4
tiles = tiles.ceil # round up to next full tile
trace("tiles: %s", tiles) # display on ruby console
Note the "total_area/4" and the ".ceil" functions were to round the number of tiles up to the next full 4 SQFT tile. If you wanted to round up to the noxt whole tile per wall, you would add a similar, clever function to caluclate the number of tiles base on the width and height of the wall.
e.g.
tiles = (%w%/24).ceil * (%h%/24).ceil
This would round the width up to the next 24 inches, and round the height up to the next 24" before calculating the number of tiles per wall.
Here is the report I get:
(I added three columns called W, D, and H just for testing. If you are getting the wrong areas for walls, these may help you determine why they are not calculating properly.
About
Search
Enter a phrase here to search the entire Render Plus web site:
Translate
Latest Activity
© 2024 Created by Render Plus.
Powered by
