Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

SMath - New Found Feature

SMath - New Found Feature

RE: SMath - New Found Feature

This is from the description of the function:

importData("1:fileName", "2:delimiter", "3:delimiter", "4:delimiter", "5:number", "6:number", "7:number", "8:number", "9:number") - Returns a matrix of loaded data from specified file "1:fileName". Function can be used with 1-9 of the arguments specified. Digit 0 (zero) can be used for the arguments (except "1:fileName") to get the built-in default values. Function is able to read data with manually specified Decimal Symbol ("2:delimiter"), Arguments Separator ("3:delimiter") and columns delimiters ("4:delimiter"). To read a specific region of the data file rows an columns ranges can be requested ("5:number" - start row, "6:number" - end row, "7:number" - start column, "8:number" - end column). To read a data represented symbolically "9:number" can be set to 1.

TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm

RE: SMath - New Found Feature

IRS: illustrated in the example. I have a lot of data in excel spreadsheet format... that I can now input into SMath... have to use a little judgement... the AISC and CISC shape database would be one huge matrix... <G> My scanner OCR creates a really good CSV file. As Mark Twain said (I think), "I haven't had so much fun since the orphanage burned down." You can easily select a specific bit of data...


RE: SMath - New Found Feature

IIRC, when this was done in Mathcad, the array would load values from the data file every time the sheet was refreshed, making it possible to update the values in MathCAD "on the fly" as the other file changed.
Does SMath work this way?

It would be fun to do a real-time or "near" real-time vibration analysis with SMath Studio. I don't think it has Fourier transforms, yet...

No one believes the theory except the one who developed it. Everyone believes the experiment except the one who ran it.

RE: SMath - New Found Feature

I'll try inputting the ASCE steel section excel data... an array of 30 or so values for 200 sections, and see how that runs, both for loading and recycling. Stuff I've done is small and time for loading negligible.

When I used to program, I'd have ASCII data files that I used the extension *.adf. I'd search for *.bdf files and if not existing, would load the *.adf file. Import these as variables (usually Type) and immediately store them as binary files aka *.bdf. When running a program and loading data, it was so much faster to load and save the data as binary. This was back before Windows, when machines were much slower... Kept it up with Delphi after windows.

I was able to load the first 116 lines so, a matrix 116x30... had to modify it to remove characters and the program doesn't seem to like nul cells. There is an error in line 117 that I couldn't find.

The data is loaded as soon as I change the filename and hit <Enter> and doesn't seem to slow anything down.


RE: SMath - New Found Feature

By copying line 116 through to line 375, the program loads the 375x30 array without a glitch. A couple of caveats. I don't know if you can have a column of string variables. SMath accommodates this within the program so it might from a *.csv file. Will find out. And it does not appear to accommodate a 'nul' cell. I'll have to dig in to that and will keep you posted.


RE: SMath - New Found Feature

If you use a 'nul', the function simply removes it and does not leave a cell where the nul was.

The function will not accept an alphanumeric value. Input string error...

It's been fun... next step is to remove the 'W' and 'x' values and to recreate a string variable where the Wzz x zzz column was. Should also be able to modify cells to incorporate units by multiplying the cell value by the unit.


RE: SMath - New Found Feature

I found doing some cleanup to the AISC shape database file was worthwhile. I went thru and swapped all the '--' or empty cells to 0 and changed the text from unicode to ansi so there are no more special characters. All pretty easy to do within excel or a text editor but it makes sorting and grouping a bit easier having the 0 in properties that don't exist. I also pulled out the units and definitions as separate csv's and mapped them to the shape indexes.

Open Source Structural Applications: https://github.com/buddyd16/Structural-Engineering

RE: SMath - New Found Feature

Celt83... I suspected it was some sort of embedded character that was causing the glitch... thanks,


RE: SMath - New Found Feature

yeah if I remember right in the 15th edition excel file a large portion of the double hyphens are actually the unicode equivalent which gave me all kinds of issues when I was working with it in python and the associated gui I use. A quick save to csv then find/replace fixed it right up.

Open Source Structural Applications: https://github.com/buddyd16/Structural-Engineering

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


White Paper - How ESI is Helping Move New Medical Device Product to Market Quicker & More Cost Effic
Early Supplier Involvement has long been a strategy employed by manufacturers to produce innovative products. Now, it almost seems like a necessity. Because decisions made in the design phase can positively affect product quality and costs, this can help add value to OEM bottom lines. This white paper will discuss many facets of ESI, including why it’s so valuable today, what challenges limit the benefits of ESI, how cost is impacted, and more. Download Now
White Paper - Moving to a Driverless Future
This white paper describes what we see as the best practices to support a sustainable engineering process for autonomous vehicle design. It exposes how to use simulation and testing in common frameworks to enable design exploration, verification and validation for the development of autonomous cars at a system, software and full-vehicle level to drive a mature product development process for automated driving. Download Now
Research Report - How Engineers are Using Remote Access
Remote access enables engineers to work from anywhere provided they have an internet connection. We surveyed our audience of engineers, designers and product managers to learn how they use remote access within their organizations. We wanted to know which industries have adopted remote access, which software they are using, and what features matter most. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close