Home
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
schTechLIBr01.xls (1 viewing) (1) Guest
This area of the Forum is reserved for notes about the Version history of items in the repository. A link to the related repository item is always included at the top of each thread.
Go to bottom Favoured: 0
TOPIC: schTechLIBr01.xls
#1356
InfoJunkie65 (User)
Industrial, Manufacturing, Mechanical, Structural
Frog Prince (Platinum Boarder)
Posts: 57
graphgraph
User Offline Click here to see the profile of this user
Gender: Male MiScion Location: Adelaide, South Australia Birthdate: 1965-07-29
schTechLIBr01.xls 10 Years, 1 Month ago Karma: 7  
This forum thread will track of the version history of the following download:
schTechLIBr01.xls
 
Logged Logged  
  The administrator has disabled public write access.
#2097
InfoJunkie65 (User)
Industrial, Manufacturing, Mechanical, Structural
Frog Prince (Platinum Boarder)
Posts: 57
graphgraph
User Offline Click here to see the profile of this user
Gender: Male MiScion Location: Adelaide, South Australia Birthdate: 1965-07-29
Re:schTechLIBr01.xls 8 Years, 8 Months ago Karma: 7  
New functions added to assist with calculating windloads in the quadrants about the orthogonal axes of a building, relative to the 8 cardinal compass directions.

The workbook already in '.xla' format.

To simplify conversion of my highly linked workbooks. I have assumed shared documents folder is available to most people, and setup ExelCalcs (spelt as shown) folder to place dependent files in. I assume this will allow the workbooks to be easily tested without modification before moving over into own systems.

Though still may not work. Excel has a habit of updating drive names and messing all paths up when a file is simply copied from one drive to another. To avoid such problems typically have to use Excel "save as" menu option.

Unfortunately I don't yet have installation or configuration macros, so some messing around has to be accepted to get the workbooks to work on another machine. Something which I have to do locally in any case: moving between office computers and network and stand alone home computers.
 
Logged Logged  
  The administrator has disabled public write access.
#3239
InfoJunkie65 (User)
Industrial, Manufacturing, Mechanical, Structural
Frog Prince (Platinum Boarder)
Posts: 57
graphgraph
User Offline Click here to see the profile of this user
Gender: Male MiScion Location: Adelaide, South Australia Birthdate: 1965-07-29
Re:schTechLIBr01.xls 4 Years, 9 Months ago Karma: 7  
I have searched the modules, and removed the hardcoded paths that I could find. I have added a worksheet with environment parameters. This basically uses worksheet functions to get the name of the workbook and obtain the path to the workbook, paths to materials databases are then built up from there.

The assumption is that schTechLIb be placed in a folder called ExcelCalcs and below this another folder be created called materials, this is where the materials database will be located (.xls and .mdb).

I have further checked and only AS4600 functions use data access objects (DAO) to obtain section properties from the MS Access file. Even so it still requires the materials spreadsheet (.xls) to fill drop down lists and display information on the worksheet. Originally schStruMtrl.xls used exactly the same information as struMtrl.mdb as it was directly linked to and refreshed on opening. However that only works if everyone has the same version of Office: at one stage we had Excel97 and XP and 2003 in the office, and needed different versions of the access table and spreadsheet, so the link to the Access database was broken and the spreadsheet and made static so access to Access wasn't required. Note that DAO and also MS Query should be available on all Windows machines, MS Access is not required.

The functions using DAO are containers for other functions, rather than pass all the parameters required via the spreadsheet, just the section name is passed and DAO is used to get all the section properties from a database. These properties are then passed to functions with long lists of parameters. These other functions can be used in the worksheet instead if users do not like the DAO functions and cannot add new sections to the MS Access tables. However some functions to further reduce the parameter lists make use of record structures to pass information around, and functions so written cannot be called in worksheet cells as have no way of assigning values to the fields of the record structure.

Sorry, I've always used spreadsheets and databases together (Lotus 123 and Dbase), (Quattro Pro and Paradox), and now (Excel and Access). Traditionally spreadsheets had memory limits and databases didn't, this not so much as issue as it used to be. However it is still easier to manipulate data in a database than a spreadsheet: records and fields are more directly accessible than messing with vlookup in a spreadsheet. Plus a formula is written once and more reliably applied to all data, compared to copy pasting a formula in a spreadsheet. And if need formula to change based on contents of a record, then also easier to implement in a database management system. I once had to mess around processing railway curve data in Lotus, memory had to be removed from other computers to create one computer which could handle the data, and its was filled with messy formula. It would have been better in FoxBase which is what I recommended, but had to use Lotus because that's all the design engineer could use and limited license for FoxBase. With MS Office however I do not see the reason not to have the professional version with MS Access. Though vba and DAO does diminish the need somewhat.

Any case I have now tested use of schTechLIB (with AS4100 and AS4600) by creating folders on my profile under my documents, from there I copied and set up in shared documents. I also created a limited user account and under my documents and copied from the shared folders. I didn't time it but in each case I'm guessing it took less than a minute to set up and fix links: and that included time to void original locations on my computer so that would crash with bad links.

schTechLIB should be added to Excel (Add-in's) first, before any links are updated. If this is done then Excel will automatically update the invisible links to the user defined functions. Do not put schTechLIB in the Excel default add-in's folder it doesn't need to be there, place it in mydocuments/excelcalcs or any where else it is easy to find and remember. The dafult setting for schTechLIB is that it will find the materials database in a folder below where it is located. mydocuments/excelcalcs/materials.
 
Logged Logged  
  The administrator has disabled public write access.
#3275
InfoJunkie65 (User)
Industrial, Manufacturing, Mechanical, Structural
Frog Prince (Platinum Boarder)
Posts: 57
graphgraph
User Offline Click here to see the profile of this user
Gender: Male MiScion Location: Adelaide, South Australia Birthdate: 1965-07-29
Re:schTechLIBr01.xls 4 Years, 8 Months ago Karma: 7  
Revisions:

1) Added functions to AS1170.2:1989 Appendix E for calculating terrain category from surface roughness length (z0). Refer to design chart in current commentary to AS1170.2.

2) Added functions relating mean return period, risk and life expectancy. Refer to Wind loading of Structures by John Holmes for background.

3) Revised terrain category multiplier (Mz,cat) functions, so that works with region W, for New Zealand.
 
Logged Logged  
  The administrator has disabled public write access.
Go to top
We have 9 guests and 39 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.

 

 

Real Time Analytics