Wikipedia:Reference desk/Archives/Computing/2014 May 16

= May 16 =

Printing Error ?
The 4 abstraction layer chart in your Internet Protocol Suite article did not print along with the rest of the information. It does not appear on the print preview screen, either. I had some help from someone using Microsoft Office which showed a preview of each abstraction layer on separate sheets of paper. At this point, it COULD be all reduced down to one page and thereby completed. So it could be done this way. My question is why won't it simply print out without this type of manipulation? I see that this is a huge hunk of hyperlinks which may have something to do with the fact that it cannot be reproduced as shown by a simple print command. Is this a software, firewall or copyright concern. I would like to make a chart for my wall so that I could study and contemplate abstraction layer interactions. — Preceding unsigned comment added by 71.239.238.205 (talk) 12:57, 16 May 2014 (UTC)


 * Do you mean the big table in the "Layer names and number of layers in the literature" section of Internet protocol suite? That prints fine for me; the whole article, including the table, the photos and diagrams, prints fine.  The two SVG diagrams, when viewed individually, also print fine, on a single page. 87.115.60.38 (talk) 13:10, 16 May 2014 (UTC)


 * Another way to print is to use the Print Screen button on your keyboard to capture what's currently displayed, then do a Paste in MS Paint or some other program. This method does have one drawback, though, it can only capture one screen's worth of data at once.  So, set your screen res as high as it will go, maximize the size of the window, turn off all unnecessary crap on the screen, move the mouse pointer off the screen, then hit Print Screen.  If necessary, you can do multiple screen grabs and then patch the final pic together in Paint, etc. StuRat (talk) 16:22, 16 May 2014 (UTC)

Dear Abby topics in URL
A recent change in uexpress has meant the topic is in the URL for a column by Dear Abby or Richard Reeves or anyone else I might choose to read.

Here is an example of this. However, I don't read the current column because I wait and see if it appeared in a newspaper I read at the library. I've always clicked on the date a month earlier on the calendar, giving myself enough time to have seen the actual newspaper. Now, I have to change the month, like this. Amazingly, I don't have to remove the topic for it to work, even though this is the correct URL for a month early. Why?— Vchimpanzee  ·  talk  ·  contributions  · 15:56, 16 May 2014 (UTC)


 * They've configured their webserver to ignore everything in the URL past the three date entries, so you can put anything there - e.g. . Amazon does this too, for the part of the URL that normally has the product description, e.g. . -- Finlay McWalterᚠTalk 16:06, 16 May 2014 (UTC)


 * So I wonder what the point is in including the topic in the URL?— Vchimpanzee  ·  talk  ·  contributions  · 18:02, 16 May 2014 (UTC)
 * It increases the page's search rank when people search on those terms. 70.36.142.114 (talk) 18:47, 16 May 2014 (UTC)

How to get URLs of the two videos on the webpage?
At http://ias.umn.edu/2009/02/20/gran-torino-panel/ I want to get the direct URLs of the two videos on this page so I can archive them on webcitation.org. I want them archived so people can still access them

Thanks WhisperToMe (talk) 15:59, 16 May 2014 (UTC)


 * http://mediamill.cla.umn.edu/mediamill/download.php?file=28052.flv and http://mediamill.cla.umn.edu/mediamill/download.php?file=28053.flv -- Finlay McWalterᚠTalk 16:12, 16 May 2014 (UTC)
 * ✅ Merci! WhisperToMe (talk) 18:56, 16 May 2014 (UTC)


 * If you need to do this again, I described how I figured it out in, above - your videos worked properly because, unlike that site, they don't block based on referer. -- Finlay McWalterᚠTalk 19:34, 16 May 2014 (UTC)
 * Thanks again! WhisperToMe (talk) 04:06, 17 May 2014 (UTC)

MS Excel
Suppose I calculate the minimum/maximum value of a range of cells, and then want excel to return the row number from which the min/max value was taken. How do I go about it? 117.194.229.160 (talk) 18:05, 16 May 2014 (UTC)


 * Try this: -- Finlay McWalterᚠTalk 18:11, 16 May 2014 (UTC)


 * (ec) One problem, there could be more than one cell equal to the max or min. I suppose you could say something like "for x = 1 to 999: if F(x) = max(F1-F999), then color(F(x)) = Red, else if F(x) = min(F1-F999), then color(F(x)) = Green" (just guessing at the syntax), to make it a bit easier to find the max and min values.  If you're dealing with real numbers, then you might want to modify that to highlight any within a tiny range of the min or max, so you don't miss some due to round-off error.  Integers, money, and time shouldn't have this issue, presumably. StuRat (talk) 18:15, 16 May 2014 (UTC)