How to make a spreadsheet to track weight, with a graph 



Good Morning, ,
Today is Sunday, December 6
Saint Nicholas Day


>From Cora
Thank you, Thank you, Webby,
My windows 10 now feels like 7 again.  
If any out there are unhappy with windows 10, 
do what DearWebby said.  You won't regret it.
Happy again, 
Cora
------------

>From Neil
Re speakers for laptop

If Denise has a Win 10 laptop it likely has bluetooth built 
in. That will allow for wireless transmission of the sound 
to a bluetooth speaker. 
Here is a link for a bluetooth reciever that can be purchased 
for less than $10.00 CAD and can be plugged in to the aux input 
on many boomboxes. This eliminates the need for a wire and allows 
the boombox to be located where convenient. The receiver needs 
periodic recharging depending on usage. A usb cable is provided 
for that purpose. Mine works well with the laptop I have.

Aliexpress Bluetooth

Another option is to purchase wireless bluetooth speakers for 
around $40 to $50. These are smaller than another boombox and still 
deliver decent sound. Obviously if you want to listen to a symphony 
orchestra you need to pick a different option. (Vinyl record and 
really expensive stereo probably).

The link provided is not an affiliate link but takes you to 
Aliexpress.com which ships from manufacturers in China. They accept 
paypal so you do not have to expose credit card info. 

I have purchased many items from Ali Express, all have arrived in 
working order. Do not purchase cellphones or tablets directly 
from China. Cell phones are for European connections and will not 
connect to Canadian carriers. The tablets are cheaply made and 
fail constantly. Stick with the brand names for those purchases.

The computer accessories such as cables, usb hubs, etc. are no 
different than what you can purchase in local stores, but are 
much reduced in price.

The only drawback to ordering this way is the shipping time 
regardless of the claims made on the site is an average of 
six weeks.

Merry Christmas!
Neil

----------------


Have FUN!
DearWebby

http://webby.com/mac.html With THIS LINK you get 50% off!
Check out the 4 top versions at http://webby.com/mac There is one that even protects your phones, not just computers and tablets!
If you can help with the cost of the Humor Letter, please donate what you can!
Today's Bonehead Award goes to a Pregnant teacher arrested for sex with 16 year old student Details at Boneheads ______________________________________________________ Today, December 6, in 1774 Austria became the first nation to introduce a state education system. History ______________________________________________________ Today's mighty oak is just yesterday's nut that held its ground. --- Socratex ______________________________________________________ If you like the Humor Letter, please vote! ______________________________________________________ Two men were talking about their jobs. "The company where I work is putting in a computer system and it is going to put a lot of people out of work. Have they started that over where you work?" "Oh," said his friend, "We've been on computers for more than five years but they can't replace me. Nobody has been able to figure out exactly what I do." ______________________________________________________ Then, there was the young woman who was always tardy. But she dressed in the latest styles. As she was running up to the church just as people were starting to leave she panted: "Is - M ass out?" One of the Ladies society members replied: "No, not quite, but your skirt is mighty short and it might be if you run." ______________________________________________________ ______________________________________________________
If you like the Dear Webby Daily Humor Letter, please vote for it at the Ezine Finder: Thanks for your votes!
______________________________________________________ >Reported by Lillemor An INTERNATIONAL BONEHEAD AWARD has been earned by Virginia Houston Hinckley, 26, Jacksonville, Florida
Pregnant teacher arrested for sex with 16 year old student A St. Johns County English teacher accused of having sex with a 16-year-old student could soon be suspended without pay, a school district spokeswoman said. Virginia Houston Hinckley, a 26-year old St. Augustine High School teacher, has been suspended with pay since October, pending the outcome of the investigation, but the superintendent is recommending at the next school board meeting, Dec. 8, that she be suspended without pay. Hinckley, who lives in Jacksonville, turned herself in Wednesday at the Nassau County Sheriff’s Office after learning a warrant for her arrest had been issued by the St. Johns County Sheriff’s Office. She is charged with having unlawful sexual activity with a minor, which is a second-degree felony. She was released Wednesday after posting $10,000 bond. According to the arrest warrant affidavit, the 16-year-old student said he became “flirty” with Hinckley, his English teacher, days after school began and that he and others commented on how she was pretty and how he “tickled” her. The student initially asked for Hinckley's phone number. She said no, but the following day when he asked again, she gave it to him and told him not to tell anyone, the warrant said. The two began exchanging text messages, including nude photos, according to the student. He said Hinckley sent him photos of her breasts and other body parts, the warrant said. According to the warrant, the student would often go to Hinckley's classroom after school, and when they were alone one day -- on or around Aug. 18 -- they began kissing and touching. She suggested that they go to Treaty Park, on Wildwood Drive, and she followed him there. The student got out of his vehicle and sat in the front seat of Hinckley's vehicle, where they kissed before moving to the back seat and having unprotected sex, the warrant said. Later that day, Hinckley sent the student a text message that said, “You better keep your mouth shut about this.” They continued exchanging text messages for about a week and then stopped all communication, the warrant said. Hinckley denied going to Treaty Park to have sex with the student. Her vehicle was seized and swabbed for DNA after deputies obtained a search warrant. Two warrants for cellphone records revealed there was communication between Hinckley and the student, investigators said. According to the arrest warrant, a witness saw Hinckley waiting for the 16-year-old before they went to Treaty Park. According to her old classmates and friends, Hinckley is married and is expecting her first child next year. School district officials said any steps beyond suspension will have to wait until after the outcome of the legal process.
______________________________________________________ Tech Support Pits From: Lydia Re: Spreadsheet for tracking weight Dear Webby, I need an Excel spreadsheet to track my weight. Unfortunately I have long forgotten all about spreadsheets, so please tell me in small words like you did in the late 80's. And with a graph! Btw., my average weight now is around 150. Thanks Lydia Dear Lydia Sounds like you successfully cured your anorexia! Congratulations! For the graph to make sense it's best to ignore the bottom part, and only show the variations. So let's deduct the bottom 130 pounds and only show what is above 130. Men just focus on the top anyway. OK, in the first column we put the date. Type 12/1/2015 into the first cell. Right Click on it, Format Cells Select Date, and on the right side 14-Mar or whatever short date format you want. OK Now go into the cell below that and type +a1+1. Actually that is Quattro Style, but Excel will "correct" that to =+a1+1 That will show 2-Dec Now copy that cell with CTRL C Paste it down in the same column about 10 rows You might have to click on the big A column header to highlight the entire column, and format the date. On to column B Here you will enter your weight. Just enter some example numbers between 140 and 160. Column C =IF(B1>0,B1-130,"") That first checks if there IS something in column B. If there isn't, there is no point deducting 130 from nothing. However, if there IS something there, it deducts 130 from that, and puts it into Column C. If there is nothing, it does nothing. Leaves cell C empty. Copy that formula down column C as far as you want. Now it gets tricky. Smear column A to selct it. Hold down CTRL and smear colum C down just as far. Yes, I know, normally that would loose the previously selected column A. In this case it doesn't. Once you have Column A and C selected down to equal length, click on the Graph button above. Select either the top for upright bars or the third for lines. The top one works well for what you want. Highlight that and hit Next And Next again Then you can fill in the titles. For the top title type, for example: Weight above 130 Then click on Legend above, and take the checkmark off. That is only if you have different sets of data, for example also the weight of ol Chubby. Then you would use different color bars for you and for him. Then click finish Next rightclick on the dates at the bottom. Excel always messes them up. Right-click them and select Format Axis Select for example 3/14 or any short version. If the date is not rotated to save space, you can do that there too. Same for fonts. The rest is just dragging the graph to where you want it, squishing parts and selecting colors. Once you have made one, you will see how easy it is. Just keep in mind that weird, non-standard way of selecting data ranges. Once you have reached the bottom of the example, you don't have to dump the graph. You can adjust the ranges. Right-click between the columns Select Source Data OK, there you see a witches brew of Gobbledigook. In that you will spot the numbers of the lowest used cells, for example two occurrences of 16, one for the dates and one for the top weights. Change those two to for example 50. Now the graph takes the data for 50 days. If you change it to 365, it will do it for a year. That is all there is to it. Have FUN! DearWebby _____________________________________________________ ______________________________________________________ >From Petra: I wish to complain - the instructions on your deodorant were very misleading. I followed your instructions on a stick of deodorant to the letter: 'Take Off Top, Push Up Bottom', and was left semi-naked in some not inconsiderable pain. And it didn't help my perspiring. ______________________________________________________ If you can help with the cost of the Humor Letter, please donate what you can! ______________________________________________________ Daily tip from Thriftyfun.com Almond Crescent Cookies A twist on the classic sugar cookie recipe, these almond horns are perfect for a Christmas tea or enjoyed alongside hot cocoa on a snowy afternoon. Approximate Time: 90 minutes Yield: 6 dozen Ingredients: 1 cup butter 1/2 cup sugar 1 egg 3 Tbsp milk 1/2 tsp salt 1 tsp amaretto 3 cups flour 1.5 tsp baking powder 1/2 cup cornstarch 1 cup almonds, ground 1 cup confectioners sugar Steps: Mix sugar, butter, egg, milk, and salt thoroughly. Gradually add in flour, baking powder, cornstarch and amaretto until dough is smooth and pliable. Fold in almond bits. Shape dough into small logs (about 1 inch long) and bend to form crescents. Bake at 375 degrees F for 7-9 minutes. Allow to cool slightly, then roll in confectioners sugar. Source: My Italian Grandmother :-) By Rae G. [21] ______________________________________________________
Ophelia Dingbatter's News
No sermon 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.
_____________________________________________________ If you have a lot of tension and you get a headache, do what it says on the aspirin bottle . . . "Take two aspirin" and "Keep away from children." ___________________________________________________
Scat dancing
____________________________________________________ An eccentric philosophy professor gave a one question final exam after an entire semester dealing with a broad array of topics. The class was already seated and ready to go when the professor picked up his chair, plopped it on his desk and wrote on the board: "Using everything we have learned this semester, prove that this chair does not exist." Fingers flew, erasers erased, notebooks were filled in furious fashion. Some students wrote over 30 pages in one hour attempting to refute the existence of the chair. One member of the class however, was up and finished in less than a minute. Weeks later when the grades were posted, the rest of the group wondered how he could have gotten an A when he had barely written anything at all. They found his answer consisted of two words: "What chair?" ____________________________________________________ This is a call that came into the 911 emergency line: 911 operator: 911 what is your emergency? Man: Hey dude, I need an ambulance. 911 operator: A what? Man: I need an ambulance. A woman just got hit by a car. 911 operator: Okay, where are you? Man: I'm down here on Sycamore Street. 911 operator: Where are you? Say it again. This static makes it hard to understand you. Man: I'm at Sycamore Street! 911 operator: Maybe it would be easier to understand you if you spell where you're at. Man: All right. S-y-c-k...no, no that ain't right. S-i- c-k...no...S-e...S-y. I'll tell you what, I'll skid her over to Lee Street; you can pick her up there. ____________________________________________________
Temporary art.

Today, December 6, in
1492 Columbus discovered Hispaniola (now Haiti) and 
 the Dominican Republic. 
1774 Austria became the first nation to introduce a state 
 education system. 
1865 The 13th Amendment to the U.S. Constitution was 
 ratified. The amendment abolished slavery in the U.S. 
1877 Thomas Edison demonstrated the first gramophone, 
 with a recording of himself reciting Mary Had a Little Lamb. 
1884 The construction of the Washington Monument was 
 completed by Army engineers. The project took 34 years. 
1889 Jefferson Davis died in New Orleans. He was the first 
 and only president of the Confederate States of America. 
1907 In Monongah, WV, 361 people were killed in America's 
 worst mine disaster. 
1917 More than 1,600 people died when two munitions ships 
 collided in the harbor at Halifax, Nova Scotia. 
1917 Finland proclaimed independence from Russia. 
1921 The Catholic Irish Free State was created as a self
 -governing dominion of Britain when an Anglo-Irish 
 treaty was signed. 
1926 In Italy, Benito Mussolini introduced a tax on 
 bachelors. 
1947 Everglades National Park in Florida was dedicated 
 by U.S. President Truman. 
1957 America's first attempt at putting a satellite into 
 orbit failed when the satellite blew up on the launch pad 
 at Cape Canaveral, FL. 
1982 11 soldiers and 6 civilians were killed when a bomb 
 exploded in a pub in Ballykelly, Northern Ireland. The 
 Irish National Liberation Army was responsible for 
 planting the bomb. 
1983 In Jerusalem, a bomb planted on a bus exploded killing 
 six Israelis and wounding 44. 
1989 The worst mass shooting in Canadian history occurred when 
 a man gunned down 14 women at the University of Montreal's 
 school of engineering. The man then killed himself. 
1990 Iraq announced that it would release all its 2,000 
 foreign hostages. 
1992 In India, thousands of Hindu extremists destroyed a 
 mosque. The following two months of Hindu-Muslim rioting 
 resulted in at least 2,000 people being killed. 
1994 Orange County, CA, filed for bankruptcy protection due 
 to investment losses of about $2 billion. The county is one 
 of the richest in the U.S. and became the largest 
 municipality to file for bankruptcy. 
1997 A Russian Antonov 124 military transport crashed into a 
 residential area in Irkutsk, Russia, shortly after takeoff. 
 70 people were killed. 
1998 In Venezuela, former Lieutenant Colonel Hugo Chavez was 
 elected president. He had staged a bloody coup attempt 
 against the government six years earlier. 
1998 Astronauts aboard the space shuttle Endeavour connected 
 the first two building blocks of the international space 
 station in the shuttle cargo bay. 
2002 Winona Ryder was sentenced to 36 months of probation and 
 480 hours of community service stemming from her conviction 
 for shoplifting from Saks Fifth Avenue. She was also ordered 
 to pay $10,000 in fines and restitution. 
2002 Officials released the detailed plans for a $4.7 million 
 memorial commemorating Princess Diana. The large oval 
 fountain was planned to be constructed in London's Hyde Park.
2015  smiled.


[ view entry ] ( 10 views )   |  permalink  |  print article  |   ( 3 / 93 )

<<First <Back | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | Next> Last>>