Beam & Column Steel Takeoff

I have a full set of CAD files for a project whose structural scope is limited to beams and columns, and I need an accurate steel take-off with a detailed breakdown of quantities. Your task is to extract every relevant member from the drawings, calculate weights and lengths, include connection plates or stiffeners where shown, and present the data in an organized schedule I can forward directly to fabricators. Please base all numbers on the dimensions in the CAD files—no assumptions—then format the results in Excel (or Google Sheets) with clear fields for member mark, size, length, quantity, unit weight, total weight, and any notes you feel are critical. A concise PDF summary that mirrors the spreadsheet will help for quick review. I will supply the DWG files as soon as we start; let me know if you also want the exported PDFs for cross-checking. Accuracy is essential, so I will spot-check against the model before approving the work.