C and C tables, ASCE 7-16, able to copy into excel 1

[engreg]

I am trying to make a wind pressure excel sheet using C and C simplified pressures depending on height, wind speed etc. Does anyone know where I can find an excel ready version of the C and C tables for 7-16 so I can plug them into my spreadsheet and then reference them depending on the situation. Just trying to save time over importing the data by hand.

 

[driftLimiter]

You can try to select the text in PDF and copy/past but TBH in my experience manual data entry is my preferred method for this operation. You can try to dig out any equations that the tables are based off and calculate them yourself in excel as well.

 

[SJBombero]

Bluebeam will convert the pdf into an excel file. Sometimes it works well sometimes not so well. I had good luck converting the tables in Ch 13.

 

[robyengIT]

or you can use a software like "dagra graph digitizer"

 

[phamENG]

I just did it the other day. I use Bluebeam, so I selected the text, and copy and pasted it to excel. It seperated lines into rows, but not columns. Go do to Data -> Text to Columns. Use Delimited. Space should work, but look at your data. I had to get creative with the negatives, since it brings those in as a text dash.

 

[BridgeSmith]

Where most or all of the numbers in the table have the same number of digits, I've had success just copying and pasting from a pdf into Excel and then using the "Left" "Mid" and "Right" functions to separate the numbers in each row out into separate columns.

Rod Smith, P.E., The artist formerly known as HotRod10

 

[BridgeSmith]

Go do to Data -> Text to Columns. Use Delimited. Space should work, but look at your data.

I'll have to try that. Seems simpler than what I was doing.

Rod Smith, P.E., The artist formerly known as HotRod10

 

[phamENG]

Rod- hope it works for you. That feature is really handy and I've used it a lot.

Also, keep in mind that the way the tables are shown in ASCE 7 doesn't play nice with most data functions in excel. To use Index/Match to do dynamic lookups, I had to flip and rotate and resort the data to make it all work. It's a time consuming process to get it right. And then there's data interpolation - that's always fun, too.

 

[BridgeSmith]

Rod- hope it works for you. That feature is really handy and I've used it a lot.

Just tried it. Definitely easier.

To use Index/Match to do dynamic lookups, I had to flip and rotate and resort the data to make it all work.

I like the Vlookup function vs. the Index/match combo.

Also, are you familiar with the "Transpose" function? It will rotate a table of values. It takes a little practice figure out, but it works pretty slick.



Rod Smith, P.E., The artist formerly known as HotRod10

 

[driftLimiter]

Between Vlookup, Hlookup, and index/match functions I haven't ever really needed to transpose data to get successful lookups. I guess it depends on what data table we're talking about we could spitball on this all day I'm sure.

 

[phamENG]

Also, are you familiar with the "Transpose" function? It will rotate a table of values. It takes a little practice figure out, but it works pretty slick.

Yes. For this particular exercise, I used it to turn the table 90 degrees, then used sort and filter to have the table go from 200mph to 85 (or whatever the lowest is now), and then used it again to rotate it back.

I like Vlookup as well, but I found Index/Match worked better for me in this application since I had two independent variables (tributary area and wind speed).

 

[BridgeSmith]

Between Vlookup, Hlookup, and index/match functions I haven't ever really needed to transpose data to get successful lookups.

I mostly use the Transpose to get the tables in my design into the orientation that the numbers appear in the details. I agree that for extracting values, the orientation usually doesn't matter.

Rod Smith, P.E., The artist formerly known as HotRod10