Difference between revisions of "Russ Laher's spreadsheet"

From CoolWiki
Jump to navigationJump to search
m
m
Line 7: Line 7:
 
[[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.]]
+
There is a Windows version of the spreadsheet, and a Mac version of the spreadsheet. They are both too big to post here, so you need to get them from me. Russ tested the Mac version under Excel 2004 for Mac, v. 11.4.1.
 
 
[[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.

There is a Windows version of the spreadsheet, and a Mac version of the spreadsheet. They are both too big to post here, so you need to get them from me. Russ tested the Mac version under Excel 2004 for Mac, v. 11.4.1.