Lab 5 Questions


	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

Lab 5 Questions

Questions?

I had an error pop up when I tried to run ExcelLab() in JES. "A local or global name could not be found. You need to define the function or variable before you try to use it in any way. Please check line 46 of...." Which reads: printNow(index). Is this just a typo in the ExcelCode.py file? Thanks for any clarification/help

It worked for me. I updated the Excel code and took out the print now statements. I would try it again using the version located on the lab5 page. -Albert d'Heurle

it will not let me save the file as a .xls file... so i saved it as a microsoft office excel workbook... is that right?

A .xls file is usually considered a excel workbook file so that should be fine Albert d'Heurle

i cant download the jython file- 404 error

Fixed -Albert d'Heurle

On my graph, 2 of my percent error brackets are much bigger than the other ones. Like, they express a percent error of about 1.5%. The rest don't even come close to this. Has anyone else seen this?

For the percent changes part of the spreadsheet (Column I), my last row says that there was a -100% change from the day before. Doesn't look right... Is it? If not, any ideas what could be causing it?

See comment below where someone is seconding your opinion Larry Olson

Do we need to do anything to let you know if we updated the info with the py file? and is the L$1$ a suggestion or do we actually do anything.

1) No, we should be able to tell , 2) See comment below Larry Olson

I do not have any negative values in my column I, is this wrong?

Most likely Larry Olson

I second the question about the -100% change, can we just delete that piece of information because there is not a 68th cell in column E?

You really shouldnt have that -100% ~ reason why ~ There is no DATA from the 7/13/05 stocks and the formula requires the current day as well as the previous days values. So in reality you shouldnt copy the formula down that far. Larry Olson

I'm pretty sure that the data for column I should begin in I3. Since it is supposed to be the current day (E3) minus the previous day (E2) divided by the previous day (E2), the information for the current day should begin in I3. At least that's what I'm thinking. Hopefully a TA will verify this or explain situation.

you do begin in I3 and read above for why you dont have that -100% issue Larry Olson

Like the person near the top, I cannot save the file as .xls, but I have like 6 different variations of "Microsoft Excel Workbook" file types, each with different year and version numbers. I'm pretty sure I used the latest one I could (it had 2003 in it). Should that work?

Why can't you save it as a .xls? -poof #10

When I tried to save it as StockInfo.xls, a window popped up saying something about not being able to save it with .xls. However, when I selected the file type I mentioned above and saved it, the file was saved as StockInfo.xls. I'm not sure why it made a big deal out of it, but I'm assuming everything is fine since it shows up with .xls now.

Well, what's the verdict? Do we move Column I to begin at I3 or do we delete the 100% change?

It should begin at I3 (from the lab instructions). But you shouldnt have a -100% at the end. Read one of my posts above for why. Larry Olson

Do we actually need to do anything for the absolute formulea part?? It doesn't clearly state if we need to actually do that or if it's just telling us that the function is available??

The absolute formulae part is just an example of what to do IF you DO want the same cell over and over. Looking over it, to complete this lab, you dont need to use absolute formulae. Larry Olson

do we need to format columns G and H to 2 decimal places also?

Dont think so, no. Larry Olson

i dont see where you answered the question as to whether the L$1$ was a suggestion or not and if we do have to show that on our spread sheet i dont understand what its telling us to do

Look at my response for two posts above your current location. Larry Olson

if the directions say to begin at cell 12 ( the aww fooey question)then when do we have to start at 13? also, when we should only select rows 13-66 for conditional formatting?

Cell 12 and 13 or i2 and i3 ? (big difference ~ lets make sure we are talking about the same thing). Assuming ive read your question correctly... Yes it does say to format from cell I2 down the column (Even though there shouldnt really be data in Cell I2 since there would be no Previous day's data. - See the math in the "Vegas Tomorrow?" section then revisit "Aww Fooey"). However, just start the formatting with cell I2 anyway. Larry Olson

Just some advice not on the homework, to copy is MUCH easier. When you select a cell there is a black square on the bottom right of the cell. Click and drag down to the bottom, it copies it all the way down!

In the section "Rounding Third Base . . . Error Bars" You might get an error where excel alerts and says something about not being able to get 32k something ... you need another series ... If you have this error, it is most likely because you have selected the text elements (the names of the columns) when you selected the error bar information. Really, we only need the numerical data from cells G2 and H2 down ... Larry Olson

in the section: Oh Dear, We're backwards: Sorting,
where is this box you refer to(In the upper left hand corner of the spreadsheet is a graybox with no label on it) not seeing it AT ALL

Other than the fact that you just described its exact location ... If you look in the lab at the picture near the top. The box you want is circled there in red with the "select label" caption. Also on Macs, the box will have <> in it Larry Olson

After doing the conditional formatting, the cell borders in "column I" are deleted but all the values that appear are correct. Is that a problem?

Borders arent a super big issue... (they look white now instead of a thin black line im assuming ? ). You can always put them back with other parts of the formatting tools Larry Olson

is motion below= abs(open- low)?

motion above = abs(close - daily Max) , you want motion below which is abs(close - daily min) Larry Olson

do we need borders or anything?

You can put them if you really want but they arent required. Just make absolutely sure it doesnt inadvertently break some other part of the lab ... Larry Olson

In rounding third base the directions say 'press the button. select column G' but when I press the button nothing comes up except an empty box. I tried to type 'column G' in but it's not letting me. What's up with that?

I had the SAME PROBLEM as the person above... there is no box that lets us select ranges or whatever... what do we do?

FOR BOTH OF THE ABOVE... Its not a box that lets you select a column by typing that column into the box. Here is what is meant by selecting column G. After you press the button which brings up the box that you were trying to type into, start at Cell G2, Click on it, hold the mouse down, and drag down to the bottom of the data set. You should see a dotted box surrounding the data you just selected. Then hit enter. Alternately, you can just push the Column label at the top of column G to select the column (It says 'G'). Alternately, ask a friend or see a TA in office hours. Larry Olson

wait do we have to run ExcelLab() or can we just download disneyprices.txt for the assignment without the extra credit?

To get Extra Credit, download ExcelLab() and modify it to run on your computer. Then do the Lab with that data it produces. To avoid Extra Credit and just complete the standard assignment, dowload disneyprices.txt and complete the lab with that file. Larry Olson

It did not say anything in the requirement about this, but do we need to format the 'volume' column so that it has commas delineating 1000s. (ie 1,000,000 instead of 1000000)

Format the column to be a number with 0 decimal places like the lab requests and you should be fine ... the comma is entirely up to you. Larry Olson

how do we turn it in as one file if the graph is supposed to be on a separate workshhet?

nevermind....

I'm not too worried about this, but when I saved my file on my Mac it said that some formulas may not calculate the same in Excel for Windows - will this be a problem?

I wouldnt worry about it. If it turns into an issue, discuss it with your TA. Larry Olson