•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
To all piping engineers here...how to use Excel to deal with MTOs
Our take
Piping engineers often grapple with the overwhelming complexity of Material Take-Off (MTO) files, which can stretch to tens of thousands of rows. Excel, however, holds powerful tools that can transform your data management experience. By leveraging filtering techniques and Pivot Tables, you can streamline your analysis and gain valuable insights from these extensive datasets. In this discussion, we’ll explore innovative tips and tricks that will enhance your Excel skills, making it easier to navigate and manipulate large MTO files effectively.
Hi all,
The title is pretty explicit...I'm wondering if threre are some piping engineers / designers reading this sub and what tips and tricks they are using with Excel in order to get the most of big MTO files produced by other software. I know you can filter and get most of the numbers concerning pipes and accesories or even setup a Pivot Table for it, but I'm open to all type of nice tricks which makes easier to deal with this really large files .... for the record, we are speaking of files of tens of thousands of rows and around 30 - 40 columns.
Thanks in advance for your suggestions.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience