Change Contents of the Bubble
Welcome to CS1315. Click on the python to add comments.

Looking for the book? They have it at the Engineer's Bookstore at 748 Marietta St NW. Here is there website: http://www.engrbookstore.com/ - Monica

Hotspots: Slides and Code • TA Corner • Comments? • Announcements • FAQ • Static Webspace
View this PageEdit this PageUploads to this PageHistory of this PageHomeRecent ChangesSearchHelp Guide

Excel Lab Questions- Spring 2008

Ask Excel Lab Questions here.

I have Office 2004 for Macs... Which Excel lab instructions should I use?
The original instructions. Not the ones for 2007. Thanks! Brittany Duncan
for "rounding third base" i am unable to enter parameters (the G & H) without getting an error and when i click on the buttons next to the + and - nothing appears. how does this work?
Please see a TA and show them what is going on. I can't diagnose an error without seeing it. Thanks! Brittany Duncan
I know that in Excel 2007, the buttons are pretty frustrating to use, which is why the instructions recommend typing in the range of cells manually. If you're using Excel 2003, the same procedure should work. Take a look at the Excel 2007 instructions for this part of the lab and see if that's any help. Joshua Cuneo
For percent change, should there not be an answer for the last row because there isn't a day that follows it? Otherwise it shows -100%
There should not be one for the first day, but there should be one for the last day. It should be calculated based on the day before. Thanks! Brittany Duncan
Where are we supposed to turn this in on T-Square? There isn't an option to submit it under "Assignments".
It is there now. Sorry for the hold-up. Thanks! Brittany Duncan
If someone could answer the question that the person had about "Rounding Third Base"...that would be great. I am having the same exact problem. I keep getting an error message.
Please don't post a question more than one time in a row. That is very frustrating and rude. Thanks! Brittany Duncan
Just to let you know, there is a major error with the excel part of the lab. Everytime I save my document StockInfo.xls and try to re-open it, it simply opens it as the DisneyStock.txt file (I have tried it on a Mac and PC and it has deleted my work twice now). Also, you cannot submit this lab as one file because it does not allow for both the adjusted stocks AND the graph to be saved at the same time. It only allows for the current page to be saved.
Are you using Excel 2007? If so, follow those directions for saving the graph. I don't know why you are having that problem with the .txt file, but please see a TA regarding this. Thanks! Brittany Duncan
This is not a problem with the lab. You need to save the spreadsheet as an Excel workbook (you could use Save As...). Simply giving the file the extension .xls doesn't turn a text file into a spreadsheet. Colin Potts
I'm confused about the "motion below the close" statement and what it should read as...thanks!
I don't know whether you're asking about the column label for the motion below the close column or the formula that you're supposed to use. In either case, the point is to figure these out yourself based on the preceding steps for motion above the close. If you're stuck on this point, I suggest contacting a TA over IM or seeing one during office hours. Sorry that we can't be more help on this page. Joshua Cuneo
The most current data off of the yahoo website that i uploaded in JES has a day where data is not given. Should I just delete the row in the excel program for this day as to keep the appearance of a correct spreadsheet?
Upon adding the error bars, my previously evenly spaced chart becomes squashed. It seems the Y-axis has increased on the chart, no longer proportional with the graph. I am using the correct values for the error bars and for the data series. Is this possibly a Mac thing or the result from using the latest data?


Link to this Page