Hey all- I asked Ryan to put this up for me as my account was locked. There is a dll that is based on a FoxPro database. It can get called up with excel to lookup properties of sections. The dll is in the public domain by the readme. Its a function with 2 variables, Member/Size (W, S, M, HP.) and property (A, S, I, J, etc) 'Aisc_Search was written and compiled using Microsoft FoxPro V9. It incorporates the AISC Excel table titled AISC.Shapes.Database.v14_0_0.xls' which has been converted from.XLS to.DBF format and compiled into the programs using the filename 'AISC_V14_0_0.DBF'. 'The program is provided as AISC_Search.DLL, a fully functional self contained callable module that may be compiled into other software products.

I was wondering if it is possible to AISCsearch.dll to perform shape property look ups and integrate this with SMath. Here is the search. Also I attached a steel beam calculation example where I just use a matrix to obtain the beam properties. AISC_Search_dll Setup.zip (2,378kb) downloaded 72 time(s).

AISC_Search.DLL is completely self-contained but requires a calling function for use in Excel.' Here it is in Excel- In Excel, we use it to lookup information to use in calculations like this- I do not know enough about programming to figure this out on my own just yet. I have attached the files with dll, docs and dependencies below. Is this something that we can use in smath? Can we call it natively? (2,378kb) downloaded 72 time(s). Best regards Dennis 09 November 2015 20:09:35(UTC) Reason: Not specified.

Obviously it should be possible, writing a wrapper. The problems probably are mostly about the plugin documentation and maybe dependancies (installation failed on my system, because failed attempts to write things in the Windows Registry). Personally being able to choose I'd prefer to write a new library with supports of units and many profiles as possible (European, North American, etc.) and maybe plotting features, freely extensible for further improvements. However there are several examples of wrappers in the, if someone wants to try he can ask here for support in case of issues 10 November 2015 02:01:44(UTC) Reason: Not specified.

(1,079kb) downloaded 35 time(s).The AISC lookup does not like 64 bit excel. I am not sure what in the registry could be written that may be wrong. I wonder if its country or export version sensitive? EDIT 1: The registry info appears to be in the.VBR file. I pasted the info below. EDIT 2: The source for the dll appears to be in the aisc_search.dll.prg file.

EDIT 3: The original source zip did not appear to have the files i was pointing. I have attached a second zip file with the files that get installed by the installer.

The database does have metric units in it as long as you call out the shape as metric. I am not sure that it 'knows' metric shapes. Actually, I seem to recall that they are all metric shapes now and we yanks just get to think of them as US customary. The originator was the founder of Fabtrol and the maintainer is an engineer at Irwin Steel. I have communicated with both in the past.

I will volunteer to communicate/liason with them. I just don't know what to ask them for. I am more than happy to contribute, but I am not sure if my weak programming is up to the task. Dennis aisc_search.VBR contents. DEFINE CLASS AISC_Field_Value AS CUSTOM OLEPUBLIC PROCEDURE AISC_Field_Value_Function LPARAMETERS cThisSize, cThisValue * Set up the environment to operate quietly and with utmost exactitude SET TALK OFF SET EXACT ON * nReturnValue is the value returned from the table. If not found, it returns zero nReturnValue = -1 * lSizeOk is a logical that determines whether the Size passed in is valid * If cThisSize is a character string and is found in the list titled EDI_Std, lSizeOk =.T.

* lValueOk is a logical that determines whether the Value passed in is valid * If cThisValue is a character string and is a valid field name (in the long IF statement below), * then lValueOk becomes.T. LValueOk =.F. * Make sure cThisSize is a character string IF TYPE( 'cThisSize' ) = 'C' lSizeOk =.T. * Convert the string to Caps and remove extraneous spaces cThisSize = UPPER( STRTRAN( cThisSize, ' ', ' )) ENDIF * Make sure cThisValue is a character string IF TYPE( 'cThisValue' ) = 'C' lValueOk =.T.

* Convert the string to Caps cThisValue = UPPER( cThisValue ) ENDIF IF lSizeOk AND lValueOk * Make sure that the field name passed in is a valid choice * If the fields are changed by the AISC in the future, add to or edit this list IF cThisValue = 'METRIC' OR; && added 2011 cThisValue = 'TYPE' OR; cThisValue = 'EDI_STD' OR; && revised name-2006 cThisValue = 'AISC_MAN' OR; && revised name-2006. CThisvalue = 'PB' lValueOk =.T. ELSE lValueOk =.F. So this is proving to be more challenging than I imagined. I think I can do what I want with some judicious trimming and logic. But I need a little help.

Symbolic optimization for importing data from spreadsheets: Does this matter if some of the entries in the cells are text entries? Finding the right row is a challenge. The vlookup function would be what I would use in Excel to find the right row. Once I can get to the right row, I can extract the column that I need.

My challenge is getting to the right row in an efficient manner. Once I can get to the row, I can make the definitions that I need. Thing is how do we 'find' the row efficiently?

Text = SMath.Manager.Symbols.StringChar + text + SMath.Manager.Symbols.StringChar; As for the second point I don't know how you are approaching the marshalling (how you access the data from the plugin? Davide- Thanks for the input. I am working with Windows 10 64 bit for an OS. Curiously, what I found out was that it does not work yet with 64bit Excel.

So is there a difference between the dll getting used in the OS or withing Excel? It does work with Excel 32 bit. A Beautiful Mind Full Movie Mp4 Free Download. Curiously enough, MSOffice installed 32 bit version by default.

You have to manually browse to the 64 bit folder to run setup from there to get a 64bit version. From my accounting friends they all run 32bit excel and avoid it because of all the scripting that they do it was all in 32 bit so no one is upgrading. In talking to the maintainer of the dll, it has not yet been updated to 64 bit. SO I am trying to understand if either of these 2 approaches will work before I brute force a new calc- 1. Can SMath send the 'request' to the dll and retrieve the results it gives? Harmony 650 Serial Number. Since this is how it works now with excel, can smath do it this way? Can smath send the variables to an excel spreadsheet and then get the calculated value from it.

We can have a 3 cell spreadheet that all it does is have the two of them get the variables info from Smath of section and physical properties and the 3rd as the result of the search. Most importantly, what kind of performance/efficiency will this yield. I am not looking to win a race by anymeans. Its more about keeping things clean and efficient. I think instead of a wrapper to make use of a Foxpro 9 database, I would rather have a separate calc sheet with all the information in it and call it from within smath.

Foxpro is no longer supported. Why use it now instead of writing a new one from scratch that is cleaner and with all the stuff we collectively might wany. Thing is the US Imperial shapes and Metric equivalents are 1996 rows by 75 columns currently. I like the idea of having the Euro shapes in there as well, more to the spirit of SMath. Thanks again Dennis. So far, the best way that I have found to push and pull the info I need is using the excel_IO functions. (68kb) downloaded 28 time(s).

(27kb) downloaded 35 time(s). I have attached the small SMath file that calls the aisc.xlsx spreadsheet that I wrote. By simply defining the shape and the property and then sending those to Excel, we can then pull the result of the search back into SMath. This is assuming that you have already installed the AISC_Search tools.

What I would really like to be able to do is do the lookup directly. I think it would be very advantageous to be able to use the information as published directly form AISC.

Conversely, how is this type of data available to our European friends? What do the Eurocodes present to you if anything at all?

I know that the producers provide some of the information. 16 November 2015 20:49:11(UTC) Reason: Not specified. @Dennis - sorry for the lack of involvement, I was really swamped at work before the Thanksgiving break.

I have just got a chance to look into all of this. A few questions: In regards to using excel - It is difficult to use the property lookup spreadsheet because, as far as I know, you can only look up one property, right? What I'd rather do is pull in the entire row into SMath and then assign all the properties I need from that row of information. The hard part about this is that somehow you must utilize 'VLookup' or something similar in excel. Or maybe there is another way around this? This is the problem I ran into last time, so ultimately I pulled all of the 'W' shape properties into SMath and used 'findrow' in Smath. This creates a very bulky.sm file though.

My programming skills are very minimal unfortunately so I'm not sure I'd be much help on the wrapper. Although if there is some documentation to how this can be done I'd be happy to try and give it a shot. I noticed I said 'VLookup' but really I need the entire row. VLookup would actually be pretty simple to implement, but maybe I need index? EDIT: I have (almost) achieved what I was hoping to. I have used multiple 'Vlookups' so that the entire row can be exported back to SMath however I am having a hard time getting everything to 'run smoothly'. I'm not sure what I am doing wrong.

I have Windows 10, excel 2013. Maybe there is a permissions issue.

Can anyone get this to run correctly on their machine? See attached. (1,012kb) downloaded 16 time(s). 28 November 2015 20:23:53(UTC) Reason: Found a way to use VLookup with excel and SMath.

However I am having a hard time getting everything to 'run smoothly'. I'm not sure what I am doing wrong. (1,012kb) downloaded 16 time(s).

What are you referring to when you mention smoothly? If it is related to my plugin I can try to help.

If you are relating that VLookup is slow, Index(Match) is a little faster, see attached. (1,074kb) downloaded 26 time(s). SinneD, I have modified the plugin so all numeric text values are converted to number, not a string. Should help, I would think 30 November 2015 05:07:44(UTC) Reason: Not specified. Sorry I should have been more specific, I couldn't seem to figure out what was going on. Everything seems to run fine when I open and close the program.

However if I change the shape and try to re-calculate nothing happens. However if I save and close SMath (with the changed shape), then open it, everything re-calcs appropriately. Is there a way to 're-calculate' without opening and closing?

Try executing excel_VISIBLE on the.xls file of interest. Than go to excel ->file->options ->formulas and check if re-calculation is enabled. If it is not, you are using old version of excel plugin that has a bug of disabling recalculation. Delete the plugin and re-download it - that should do the trick. Also if xls file needs any permissions to operate (macro?) you should allow them by hand. Excel_IO plugin does everything in a 'quiet' mode, so you will see no prompts or pop-ups (they will drive you nuts with sufficient number of function calls). P.S.: all works on my side 30 November 2015 05:20:13(UTC) Reason: Not specified.

Ryan- I am curious as to why you are taking the approach of vlookup? You will need to know the column for the info that you require- a bit risky because if you are off or something changes, the reference you are relying on can change. Alex- I will update my plugin and try your suggestions. Can you think of a way to do column vectors with ordinates and units?

For example I want to define the following variables as a column vector in SMath, then pass to Excel, do some work then bring the resulting values back to SMAth to do more work. It would be advantageous to be able to have units built in.

For example the 6 row vector defining variables for shape size, area, weight, and 3 physical properties. Shape A W Sx Zx Ix Pass that 1x6 array to Excel. Excel then uses the first argument to find values for A, W, Sx, Zx, and Ix. Return 1x5 that to SMath. As a single operation it works.

But when I try to use it to define variables, then it gives me a syntax error. (39kb) downloaded 14 time(s).

(244kb) downloaded 9 time(s). 04 December 2015 22:06:55(UTC) Reason: Typo. Alex- You replied as I was editing. I though that we could define a group of variables as a column vector. Now that I try it I see that it does not work.

That is the last bit of the worksheet that I posted. EDIT: i am still trying to figure out the PNG function of the plugin. Custom.dll- yes it is a custom dll that i am trying to utilize. Its a search function and database provided by the material code governing body with their data. Its free and redistributable. I was trying to figure out how to use the dll directly with SMath but the responses above tell me its above my ability with programming, so I am stuck with making Excel do my heavy lifting.

For years working with excel we had to rely on tedious row/column lookups. A very clever fellow wrote a foxpro database and search function and wrapped it into a dll so that we can call it as That is how Ryan is doing the data lookup in his spreadsheets. It works, but it is challenging and tedious and can be easily broken with typos. Once the dll is installed, then by enabling the VBA macro one can simply call the functions like this within excel- =AISC(Shape,Prop) to get the right information.

That is what I am trying to do in my excel spreadsheet. Its not the most elegant way, but much cleaner than big datatables and spreadsheet lookups.