Difference between revisions of "Russ Laher's spreadsheet"
m |
m |
||
Line 6: | Line 6: | ||
[[Media:NotesonTeachers_v2.0.xls.doc | Russ' documentation and notes.]] | [[Media:NotesonTeachers_v2.0.xls.doc | Russ' documentation and notes.]] | ||
+ | |||
+ | [[Media:Teachers_v2.2_Win.xls | Windows version of spreadsheet.]] | ||
+ | |||
+ | [[Media:Teachers_v2.2_Mac.xls | Mac version of spreadsheet.]] Russ tested the Mac version under Excel 2004 for Mac, v. 11.4.1. |
Revision as of 20:54, 14 May 2008
Russ Laher (SSC) developed a spreadsheet that can absorb a data table and produce an SED, with interactive blackbody fitting.
When you open up the workbook, you need "Enable macros". Also, if you haven't done so already, you must also activate the Solver Add-In in your installation of Excel, which can be done via the following menus: Tools > Add-Ins > check "Solver Add-in". You may need to have your Excel CD-ROM handy.
For Mac users, if possible, you will need to have the 2004 version of Excel for Mac installed, because the later version does not support Microsoft Visual Basic Applications. If it's too late, and you've already upgraded, there is a workaround, it's just not as user-friendly.
Russ' documentation and notes.
Windows version of spreadsheet.
Mac version of spreadsheet. Russ tested the Mac version under Excel 2004 for Mac, v. 11.4.1.