Computer Tutorials

We will be using Excel and Maple. ProDesktop and Abaqus may be used if desired.

	EXCEL TUTORIALS Most of you have used Excel in EN3 or your other courses. In this case you need no further introduction. If you haven't used a spreadsheet, or are unfamiliar with EXCEL, there are several good tutorials available online, including Basic EXCEL spreadhseet tutorials: http://www.usd.edu/trio/tut/excel/ http://homepage.cs.uri.edu/tutorials/csc101/pc/excel97/excel.html http://www.baycongroup.com/el0.htm http://david.horner.faculty.noctrl.edu/Excel_tutorial/home.html http://phoenix.phys.clemson.edu/tutorials/excel/index.html Advanced Basic EXCEL solver tutorial http://www.kem.ae.poznan.pl/Books/Excel-Solver/T2/T2.htm Advanced EXCEL solver tutorial http://www.solver.com/tutorial.htm We will make extensive use of the EXCEL solver feature. If installed, the Solver is available as an option under the Tools menu. If you do not see Solver on your Tools menu, you have to install it. To do so, find the Add Ins... option on the Tools menu and select it. Then scroll down the list of add ins until you find the Solver Add-In and check the box as shown below. Then hit OK. If you are asked whether you want to install the add-in, reply Yes.... You don't have to install other Add-Ins, just the solver. If the installation is successful, you will find that Solver... has been added to your Tools.... menu. If you want a solver button to appear on your tool bar, follow these instructions (provided by Erin Carey) 1. Right click on the toolbar and go down to customize 2. Select Built-in Menus on the left hand side 3. After you select that on the left, you should be able to select an object from the right...drag Tools up to the toolbar 4. Hit the down arrow next to tools on the toolbar...you should be able to then select solver. Drag it up to the tool bar, press ctrl, and then drop it on the toolbar. 5. You can then get rid of the Tool drop down by dragging and dropping it in another part on the sheet (it should go away)
	Here are links to download the 2-d and 3-d Excel structural analysis programs used in En3.
	There is a specially written Maple truss analysis program. To download the program itself, right click here. You should use "save target as..." to save the file as Truss.mws. For your first run, try the tutorial input file. (Right click to save this as tutorial.inp.txt.)
	To log on to the computer facility for the first time, enter your user name (6 characters of your last name, followed by your initials, up to 8 characters) and your password (set to the last character of your SISD number, in lower case (usually d), followed by the last 6 numbers of your SISD number). You will be asked to change your password and should do so. DONT FORGET YOUR NEW PASSWORD!!!. William Jefferson Clinton would log on as clintowj; George W. Bush would be bushgw. Those without middle names leave off this initial. Although Wyle E. Coyote would be coyotewe, The Road Runner would log on as runnerr. If you can't get on, email Tina_Trahan. Include your SIS number in the message. Her desk is on the north side of the 3rd floor of B&H, and her phone number is (3-1427).