Author Topic: Reports & Exports - Items AND Ancillaries detailed in one report  (Read 3787 times)

0 Members and 1 Guest are viewing this topic.

Offline KuhnsTopic starter

  • Full Member
  • ***
  • Posts: 92
  • Country: us
  • Gender: Male
    • MacDonald-Miller
The Ancillary costs should not always be lumped in with the items, but we should be allowed the ability to separate out each ancillary Quantity, $ & Labor.

For example, if one takes off a clevis hanger, right now one can get a report for the cost of the Clevis Hanger (Item Price List Cost) and the total cost of the Clevis Hanger AND all of the Ancillaries (Nett Item Material Rate).  But there is no way to get the separate individual ancillary quantiy/$/labor in the SAME report as the Clevis Hanger.  How many feet of threaded rod was used?  How much did it cost? Any labor? What about the attachment method? Was it an insert?  beam clamp? how many?  What did they cost?  Is there any labor associated with the attachment?  What about Nuts?  Washers?  How many are being used?  What is their cost?

I know that there are ways to find out the ancillary information, but it needs to be available in the SAME Report/Export as the Items.
Gene L. Kuhns, Jr. - LEED AP
Sr. Estimator, MacDonald-Miller
Seattle, WA
Fabrication 2016 ESTmep

Offline Texmac1011

  • Active Member
  • **
  • Posts: 9
  • Country: us
  • Gender: Male
Re: Reports & Exports - Items AND Ancillaries detailed in one report
« Reply #1 on: Sep 03, 2013, 22:06:49 PM »
I definitely agree.  Running 2 reports to get all the info and then having to do the math to separate the info is way too time consuming.

Offline cnash

  • Premier Member
  • *****
  • Posts: 1324
  • Country: us
  • Gender: Male
    • William R. Nash Companies
Re: Reports & Exports - Items AND Ancillaries detailed in one report
« Reply #2 on: Sep 04, 2013, 12:32:20 PM »
I agree.
The other issue if we must run the ancillary report is that I can't find a way to break everything in those reports. It kinda just lumps whatever... Wherever.
I would really like to have it broken in my standard total summary reports.
Christopher Nash
VDC Content Manager/Support
William R. Nash Companies

Offline cnash

  • Premier Member
  • *****
  • Posts: 1324
  • Country: us
  • Gender: Male
    • William R. Nash Companies
Re: Reports & Exports - Items AND Ancillaries detailed in one report
« Reply #3 on: Sep 17, 2013, 20:38:52 PM »
Also I would like to have the option to break out ancillaries in a standard "Item Data Fields" Export.
Christopher Nash
VDC Content Manager/Support
William R. Nash Companies

Offline KuhnsTopic starter

  • Full Member
  • ***
  • Posts: 92
  • Country: us
  • Gender: Male
    • MacDonald-Miller
Re: Reports & Exports - Items AND Ancillaries detailed in one report
« Reply #4 on: Mar 19, 2015, 20:30:12 PM »
Totally agree...

Makes for interesting Excel programming scenarios when one is looking to see if there is any missing price/labor in your take-off...
Gene L. Kuhns, Jr. - LEED AP
Sr. Estimator, MacDonald-Miller
Seattle, WA
Fabrication 2016 ESTmep

Offline dcapestany

  • Active Member
  • **
  • Posts: 20
  • Country: us
  • Gender: Male
    • Zinger Sheet Metal
Re: Reports & Exports - Items AND Ancillaries detailed in one report
« Reply #5 on: Apr 17, 2015, 18:08:20 PM »
I put a request in on the Fabrication idea station to be able to export all the information in the cost breakdown summary to a CSV. 

Seems like that would solve a lot of frustration with being able to export data, materials, and labor.  Basically that would give you a complete bill of materials that could be used outside of the Fabrication products.