The Job Cost Spreadsheet by Date Range report is a transaction driven report by “cost type”. When adding Units and Unit Cost you will need to create a formula to specify the cost type of the transaction. For example, the Formula for Total Material Cost on the  (found under Tools>Total Material Cost> ) Is ASUM(Cost Code(JC Transaction), IF(Cost Trans Condition (Design Formula) AND Accumulate As Lkup (Design Formula) = “Material”, Amount (JC Transaction) – Non costed tax (JC Transaction))) This forumula is used on the col Material for the total cost, it isolated the tran type of "Material"

In essence you will need to isolate the transaction type with a formula for each unit and unit cost and then drop the formula onto appropriate column on the report.

I hope this helps.

robg- Thanks for your response but I don't understand.  I was able to add the columns for the units & unit costs by using this response from Rhonda V..............."For the Labor Estimate:  Copy the existing design formula named "Total Labor Estimate" and name the copy "Total Labor Est Units" as the new formula.  Change the new design formula "Total Labor Est Units" by changing Amount (JC Transactions) to Units (JC Transactions) =this is at the end of the formula.  Then create a new formula named "Unit Cost per Est" which will be Total Labor Estimate (design formula) / Total Labor Est Units (design formula).  I think this will work for each category such that copying existing formula and changing the "amount" to "units" in JC Transactions and then dividing the 'amount formula' by the new 'units formula' you will have the unit cost and/or cost per unit." ....................  I don't understand how you response helps me with converting hours to "Square Yards" for example.  Please excuse my ignorance for not understanding.  Is there anyway that you could explain this by using an example of "hours" in payroll?  Or were you trying to help me with adding the columns for units & unit costs and not touching on the hours conversion issue?

Ronnie, I was explaining from the point of view of writing the formula from scratch. RhondaV is better, she borrowed the existing formula and modifeid by changing the amounts to units, for the converstion. The formulas are desinged to isolate the transaction by cost and category. Her idea is excellent and simplier.

Another option may be to use Production Units on your cost codes. Production units are used to track job progress by cost code and are updated through Enter Misc Worksheets. You could then add these fields to the report to see the total productions units.

You can read more about how Production Units work in the Job Cost Help Topics by entering "Production Units" on the Index tab.

Great Question!

If I understand correctly, you want the number of square yards instead of hours.  When you set up the job, could you put the number of square yards into the Size field under JC-Set Up Job - General Tab-Size?  If you could use the "Size" field shown on the General Tab, you could change the "Total Labor Est Units" formula with simply Size (JC-Job).   To clarify your report, you could use the Unit Description on the JC-Set Up Job - General Tab - Unit Description to report along side your calculations to clarify if your intention was to use square yards, square acres, etc.  

Rhonda  V - It appears the size field relates to the job as a whole.  Our jobs contain different items which are estimated with different units for each item.  For example, a job consists of 1 item that is billed as "Acres", the next item billed as "Square Yards", the next item as "TONs".  All of these on the same job.  So I'm not sure how I would use the size field to capture all of the items and be able to report each of them separately.

In this situation, I think you should look at Jesse's response about Production Units.  I believe if you can set up different cost codes to correlate to the different units (i.e. cc1= acres, cc2= sq yrds, cc3= tons, etc.), then you could pull that information into the "Total Labor Est Units" formula and get it to work.  I believe you'd enter the size or the number of acres, square yards, and/or tons on each cost code through Enter Misc Worksheets task.  I'm not familiar with Production Units so if it were me, I'd create a copy of the company folder and test it or play with it.