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.
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...
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.
STF
SparWeb
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.
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.
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.
dik:
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.
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.
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
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
As a 3D printer owner, you may be already reaping the benefits of 3D printing, such as rapid production, design freedoms and easy access to fresh prints of the machine. We dive into scenarios to help you decide when you need to outsource your project to a service provider.
Download Now
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
Talk To Other Members
RE: SMath - New Found Feature
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
Dik
RE: SMath - New Found Feature
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.
STF
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.
Dik
RE: SMath - New Found Feature
Cheers
Greg Locock
New here? Try reading these, they might help FAQ731-376: Eng-Tips.com Forum Policies http://eng-tips.com/market.cfm?
RE: SMath - New Found Feature
Dik
RE: SMath - New Found Feature
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.
Dik
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
Dik
RE: SMath - New Found Feature
Open Source Structural Applications: https://github.com/buddyd16/Structural-Engineering