Different scales in a spreadsheet graph 



Zoom the font size for best readability  
Good Morning,  !
It's Tuesday, October 19, 2010
We had a beautiful, warm fall day today. There is still some
snow in the shady spots, but it was warm enough for short 
sleeves in the sun. Even now, at 2 am it is only around Zero
(32 F)

Have FUN!
DearWebby


"You can often measure a person by the size of his dream." --- Robert H. Schuller "A man is not old until regrets take the place of dreams." --- John Barrymore I do not feel obliged to believe that the same God who has endowed us with sense, reason, and intellect has intended us to forgo their use. --- Galileo Galilei
During a service at an old synagogue in Eastern Europe, when the Shema prayer was said, half the congregants stood up and half remained sitting. The half that was seated started yelling at those standing to sit down, and the ones standing yelled at the ones sitting to stand up... The rabbi, learned as he was in the Law and commentaries, didn't know what to do. His congregation suggested that he consult a house-bound 98 year old man, who was one of the original founders of their temple. The rabbi hoped the elderly man would be able to tell him what the actual temple tradition was, so he went to the nursing home with a representative of each faction of the congregation. The one whose followers stood during Shema said to the old man, "Is the tradition to stand during this prayer?" The old man answered, "No, that is not the tradition." The one whose followers sat asked, "Is the tradition to sit during Shema?" The old man answered, "No, that is not the tradition." Then the rabbi said to the old man, "The congregants fight all the time, yelling at each other about whether they should sit or stand..." The old man interrupted, exclaiming, "THAT is the tradition!"
At one point in my life I had considered joining the Baptist Church. For those of you who don't know, the Baptists practice total body immersion to baptize a person. Luckily I even knew a minister in that faith, having once dated his daughter, and I asked him if he would consider performing the service. He paused a minute or two, gave me a long thoughtful look and said, "Yes,....I could do it, if you're serious about this. However, just a quick dipping won't do it for you. We'll have to find a deep place to anchor you overnight."
Learn PHP in 17 hours Learn in 17 hours what took me over 250 hours to hunt down and figure out. Write scripts, install them and use them. Modify and adapt free scripts for your own purposes. Learn PHP in 17 hours
Click through the picture to the large version. Can't do a thing with it until it dries!
If you like the Dear Webby Daily Humor Letter, please vote for it at the Ezine Finder: Thanks for your votes!

An INTERNATIONAL BONEHEAD AWARD goes to Albert Y.M. Huang, 35, San Gabriel, CA Mayor Charged with Assault, Robbery, for Purse-Snatching SAN GABRIEL, Calif. (CBS/AP) A prominent resident of San Gabriel, Calif. in suburban Los Angeles was early arrested Friday after he allegedly snatched a woman's purse and took her for a wild ride, clinging to his sport utility vehicle. That prominent resident is the mayor. San Gabriel police say Mayor Albert Y.M. Huang was booked in jail for investigation of felony assault, felony robbery and misdemeanor battery. Police say the 35-year-old Huang was in a parking lot arguing with the woman about money, when he grabbed her purse and got into his SUV. Investigators say the woman was standing on the running board and reaching through the passenger window when Mayor Huang sped away, reaching speeds of 45 mph for more than a quarter-mile.
From the Tech Support Pits: From: Ellen Re: Different scales on spreadsheet graphs Dear Webby, I need to combine temperature, barometric pressure and humidity in one graph, but because the numbers are so totally different, it makes a huge graph with the lines way too far apart. How do I get them all reasonably in the center? Is there a way to adjust the scale of each series with Excel? Thanks Ellen Dear Ellen On a few spreadsheets, not Excel, you can adjust the scale, but it is quite a hassle. Here is a better way to accomplish that. Lets say you got the page set for a fixed header. Pick three cells in that some way over to te right of the labeled columns, for example T1,U1,V1. If you want to shift the temperature up by 35, put 35 into T1 and if you want to make the barometric pressure number 15 times smaller, put 15 into V1. Put some resaonably average dummy numbers into the first row (2). Now add a new column after the temperature column, let's say temperature is in column C, and in the top cell below the dummy row (D3), put: =if(C3<>"",C3+$T$1, C2+$T$1) That formula looks to see if you have a temperature listed in C3. If you do, it adds whatever you got in T1. $T$1 ensures, that the formula ALWAYS looks it up at that fixed location, not a location relative to the formula. If there is no temperature in C3, it takes the previous reading from C2. That produces a neat flat line from the last reading to the right end of the graph, instead of nothing. Let's say humidity is in column E, and Pressure in column G Put this formula into H3: =if(G3<>"",G3/$V$1, G2/$V$1) Here the formula takes the pressure reading and divides it by whatever is in V1 Copy and paste the formulas down their respective columns a few hundred rows. Now set the graph to take the generated temperature numbers from column D instead of the raw numer from column C and for the humidity, use the column H. If the lines in the graph are still too far apart, play with the "fudge" numbers in T1, and V1. For a finishing touch, narrow the generated columns D and H and make them black on black, so that you don't accidentally punch readings into them. You COULD drag them way over to the right, out of sight, but usuall narrowing them to one character and making them black on black protects them well enough and makes it easier to understand the process a few years later. Once you get the hang of fudging numbers like that, you can call yourself a climate scientist. Have FUN! DearWebby
Secure Uninstaller With this Secure Uninstaller on your computer, you can try anything you want, without any fear about remants left behind. Get Secure Uninstaller !
The town founder had passed away and the whole town turned out, as did his family who arrived from all over the globe. This threw the mortuary into an uproar. They had some employees doing two or three jobs and others switching jobs to get everything done. After the chapel services, all the members of the funeral party piled into the different cars for the drive to the cemetery. The procession was very long, and one group of family members, not knowing their way, wondered how much further it would be and if it was worth lighting up a smoke. The patriarch tapped the driver on the shoulder, and asked "Pardon me....." The driver let out a scream and turned with a grimace of horror to see who had tapped him. In doing so, he drove the car into the ditch and through a small greenhouse, almost overturning it. After calming everyone down, the driver somberly explained, "I'm so sorry for what happened, but you see, I usually drive the hearse."
Daily tip from Thriftyfun.com Keeping Lettuce Fresh I buy romaine lettuce when it is on sale, and have found a way to keep it fresh and crisp for up to 4 weeks. Wash your romaine and core it when you get home from the supermarket. Put it in a colander to drain, then take a large plastic container and line it with enough paper towel to keep the lettuce dry. Layer lettuce and paper towel, and put a sheet of paper towel on top. Close the lid tight and this will keep like new for 4 weeks. Open and close as often as you wish. As long as you put the top on tight, you will always have fresh romaine! I discovered this by accident while doing an ahead of time family meal. When my family found out how long it lasted they were very eager to use the tip as well. This works equally as well for any type of grapes. Much less waste and more savings to be had! Source: My own discovery. By Deborah from East Margaree http://www.thriftyfun.com/ Don't get too carried away with the drying! With lettuce, chard, kale, cabbage, even celery, it is the moisture, that keeps them firm and tasty. I do NOT like limp celery or salad, so I sprinkle some water onto the paper towel, toss the wet greens onto it, fold the damp paper towel ove it, stuff it into a zip-lock bag, and zip it after squishing most of the air out. I don't know if it keeps significantly longer than with dry paper towel, but I DO know it stays firm and tasty longer. Have FUN! DearWebby If you want to have sucess with small back yard or balcony farming with a minimal investment of time or money, check out Food Wealth. Avoid mistakes and focus on what works! DearWebby Check out ThriftyFun's Blog at http://www.myfrugallife.com Thriftyfun.com also has a newsletter. If you want more than just one tip per day, or if you want to share your tips, then you can subscribe to it here:ThriftyFun Highly recommended! If you like the ThriftyFun.com list, you can vote for it here:
A second grader came home from school and said to her mother, "Mom, guess what? We learned how to make babies today." The mother, more that a little surprised, asked fearfully, "That's interesting. How do you make babies?" "It's simple," replied the girl. "You just change 'y' to 'i' and add 'es'."
Ophelia Dingbatter's News
No sermon here and not suitable for church, just jokes and fun for grownups. Read it on-line or subscribe. If you subscribe, look for the double-opt-in confirmation request.
Golfer: "This is the worst course I've ever played on." Caddy: "This isn't the golf course. We left that an hour ago."

Mt. Baker-Snoqualmie





[ view entry ] ( 319 views )   |  permalink  |  print article  |   ( 3 / 425 )

<<First <Back | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | Next> Last>>