Thursday, September 28, 2023

I Earned Playing Video Games

I hand washed and hand waxed my car for the first time on Sun Sep 24, 2023. I was in sixth grade the last time I hand washed a car. My dad told my brother and I we don't wash the family car anymore because he didn't want to take us to Chuck E. Cheese as a reward.

I played a video game and watched a movie in the evening. The job was completed. I earned the leisure. I didn't earn the leisure to play video games in Oct-Nov 2007. I helped my dad and his friend install a new roof for the friend's house every Sat. I didn't want to help. My attitude was uncooperative. I assisted with some effort. I thought about playing video games many times throughout the day. I played video games without feeling guilty for a poor effort on Sat's nights.

The roofing installation might have been completed sooner if I gave it 100% effort.

Saturday, September 23, 2023

Instant Bullets Blog Sep 23, 2023

*2 X 0 = 0. Double nothing results in nothing.

*Combat The Snitch Economy. A secret shopper doesn't rat out the employees. He or she gets paid to eat and always gives a positive review.

*Condoms are 98% effective. Condoms are 2% ineffective. Prevent the 2% failure rate. Don't ejaculate inside a woman wearing a condom. Pull out the penis before ejaculating inside the condom. It's better than unplanned pregnancies. No birth control is 100% effective.

Further, condoms are one time use. Use once. Throw away.

*Open the windows. Close the windows. Summer season. The house is cooler inside. The weather is hotter outside. Windows close. On the other hand, the house is hotter inside. The weather is cooler outside. Windows open.

Winter season. The house is warmer inside. The weather is cooler outside. Windows close. The house is cooler inside. The weather is warmer outside. Windows open. It's a judgement call.

*The Perfect Bid. Watch The Price Is Right Documentary on the Showcase Showdown perfect bid. The documentary explains the truth when Terry Kniess bided perfectly on his showcase with help from Ted Slauson in 2008. The documentary is free with ads on YouTube Perfect Bid: The Contestant Who Knew Too Much.

*virile: having strength, full of energy, and a strong sex drive. Pronounced ve-ril. For example, some women find bald men quite virile.

*Steve Jobs: Some people say, "Give the customers want they want." But that's not my approach. Our job is to figure out what they're going to want before they do. I think Henry Ford once said, "If I'd asked customers what they wanted, they would have told me, 'A faster horse!'" People don't know what they want until you show it to them. That's why I never rely on market research. Our task is to read things that are not yet on the page." The quote is from Steve Jobs by Walter Isaacson on page 567.

*premeditated: an action thought out or planned beforehand. Full conscious willful intent and a measure of forethought and planning. Thought of or planned before being done. Planned in advance with a purpose; no accident. Done deliberately. Planned in advanced. Planned. Calculated. Deliberate.

*Christmas One Week Later. My acceptance to the families celebrating Christmas one week later. These families are poor. These families take advantage of the after Christmas sales. No right or wrong.

*Teenage Pregnancies. Here are some YouTube videos on teen pregnancies: I Think I'm Having A Baby Abc Afterschool Special Full, Some Girls (1987 documentary on teenage pregnancy), Teenage Pregnancy in the 1950s, and When Teens Get Pregnant (1982)

*I Heart Trivia. There are four chambers in the human heart. Listen to Neil Young - Heart of Gold (Official Audio) by Neil Young. Christiaan Barnard performed the first successful human-to-human heart transplant. Sisters Ann Wilson and Nancy Wilson are members of the band Heart.

*The Renaissance. The renaissance short definition is rebirth or revival. Michaelangelo created the statue David between 1501 and 1504. Leonardo da Vinci is considered the most diversely talented person. Venus is standing on a seashell in The Birth Of Venus by Sandro Botticelli.

Oregon Ducks Head Coach Dan Lanning's pregame speech before defeating the Colorado Buffaleos 42-6 The Cinderella story is OVER! - Dan Lanning's speech before Oregon vs. Colorado. "This game ain't gonna be played in Hollywood, it's gonna be played on the grass."

Wednesday, September 20, 2023

I Have A Brain

I'm lucky I have a brain. Physical, mental, emotional, financial, and spiritual are strong. Physical, mental, emotional, financial, and spiritual are connected to my brain. Strong minds and strong bodies complement each other. Motivation or desire is focused. There is no point doing nothing. I might as well do something, anything to increase my chances of earning freedom. I do something, anything to seek new adventures and to experience new experiences. Use my brain or lose my brain. Take nothing for granted.

I can't imagine my life without a brain. I don't want to imagine my life without a brain. I see, hear, read, taste, and feel stupidity. I see, hear, read, taste, and feel unmotivated people. I'm lucky I'm not stupid. I'm lucky I'm motivated. I made more of my share of life mistakes. I assure the world lessons are learned. I assure the world more intelligent mistakes are made. I continue living a life with a brain.

Sunday, September 17, 2023

Selected The Price Is Right YouTube Videos Bob Barker Era

Television game show host Bob Barker past away on Aug 26, 2023 at the age of 99. Barker hosted Truth Or Consequences and The Price Is Right. I watched The Price Is Right during my summer vacations from grade school and when I'm sick on school days. Here are some of my favorite Price Is Right pricing games.

Punch-A-Bunch. Contestants punch a hole to reveal a winning cash paper.

EPIC Price Is Right gamble! It pays off BIG! Bryan ignores his wife to give up $5,000. Watch Bob Barker's poker face.

Sweet Senior Is Shocked When She Wins $10,000 Playing PUNCH-A-BUNCH! - The Price Is Right 1984. Watch Bob Barker's poker face on her first punch.

Sound the Alarm! TPIR Contestant Wins $10K Playing Punch-A-Bunch! - The Price Is Right 1985. The contestant's reaction is shaking.

Fun Contestant Wins $10K With First Punch Playing PUNCH-A-BUNCH! - The Price Is Right 1983. The contestant dances a winner.

Shell Game. Contestants guess where the ball is hidden under a shell.

A "Dirty Rotten Trick"/cheat on playing Shell Game -- The Price is Right. The contestant cheats and gets away with it.

Three Strikes. Contestants draw numbers to the price of the car or strikes from a bag.

Wow! TPIR Contestant Makes History Winning 3 STRIKES Without a Strike! - The Price Is Right 1984. The contestant draws numbers only with many miss guesses.

Contestant Makes TPIR History When She Plays a PERFECT GAME of 3 STRIKES! - The Price Is Right 1984. A perfect game no strikes and no miss guesses.

The Price is Right - Jonathon Berg PAINFULLY LOSES "3 Strikes"! (Friday, May 12, 2000). Contestant doesn't win the $41K Lincoln Town Car last number after drawing five consecutive numbers even with the one strike chip rule.

The Price is Right: April 2, 2004 (Longest playing of 3 Strikes!). The UCSC Banana Slug student doesn't win the $40K Lincoln LS after drawing many numbers and guessing many times even with the one strike chip rule. Time stamped.

Race Game. Contestants place the correct prices on four prizes in 45 seconds.

The Price Is Right Super Fan Quickly Beats RACE GAME While In Heels! - The Price Is Right 1983. Wearing heels!

Savvy Contestant Gets Four Prices Right on First Try During RACE GAME! - The Price Is Right 1984. Contestant guesses correctly the first time.

The Price is Right - Pregnant Race Game Perfection!. Nothing to worry. Victory in 9 seconds.

Switcheroo. Contestants insert blocks with numbers to complete the price for five prizes.

TPIR Contestant Goes For EVERY PRIZE While Playing SWITCHEROO - The Price Is Right 1983. Contestant takes a chance with three correct to win all five prizes.

The Price is Right 99 Year Old Contestant. The contestant played Switcheroo with a broken timer.

Other Videos

One of the Worst The Price Is Right Players Ever. The dumbest contestant wins Ten Chances. My all-time favorite.

The Price is Right - Little Sweet Surprise. A five year old boy from MA is given gifts which includes 1980s GoBots and Transformers Dinobots.

Saturday, September 16, 2023

Excel Tips I Tweeted

Here are my Excel tips from my Twitter @ININ61.

*Aug 11, 2023: Use EDATE() to return a date a number of months away. =EDATE("6/11/2023",1) returns 7/11/2023 +30 days. =EDATE("8/11/2023",-1) returns 7/11/2023 -31 days. =EDATE("2/29/2024",12) returns 2/28/2025 +365 days. #exceltip (Tweet ID-1690037846034563072)

*Jul 25, 2023: Left click the plus sign New Sheet on the worksheet tabs along the bottom inserts a new worksheet. Double left click New Sheet inserts a new worksheet and user renames the worksheet. #exceltip (Tweet ID-1683930698934280192)

*Jun 8, 2023: Press Alt, O, D to open the Conditional Formatting Rules Manager window. Press Alt, D, S to open the Sort window. #exceltip (Tweet ID-1666924039124963329)

*May 29, 2023: Press Ctrl+Shift+F to open Format Cells window Font tab active. It can be faster than Ctrl+1, F which also opens Format Cells window select Font tab. One less key stroke. #exceltip (Tweet ID-1663339001967939585)

*Apr 25, 2023: Excel table opened. Column filters on. Press Alt+Shift+Down on a column cell or press Alt+Down on a column header to open the filter drop down menu. Immediately press E to begin typing the search filter. #exceltip (Tweet ID-1650989145823793152)

*Mar 14, 2023: Display a decimal number as a whole number and fraction. Cell A1 is 333.33. Cell B1 is =TEXT(A1,"# ?/?") returns 333 1/3; =TEXT(A1,"# ??/??") returns 333 32/97. Cell A1 351.67. Cell B1 =TEXT(A1,"# ?/?") returns 351 2/3. 314.25 returns 314 1/4. 4.34 returns 4 1/3. #exceltip RM: Initial draft is Display a decimal number as a whole number and a fraction using the TEXT function. Cell A1 is 333.33. Cell B1 is =TEXT(A1,"# ?/?") returns 333 1/3; =TEXT(A1,"# ??/??") returns 333 32/97. Cell A1 is 351.67. Cell B1 is =TEXT(A1,"# ?/?") returns 351 2/3. Cell A1 314.25. Cell B1 i=TEXT(A1,"# ?/?") returns 314 1/4. 4.34 returns 4 1/3. #exceltip (Tweet ID-1635779231727886336)

*Dec 19, 2022: Press Ctrl+F to open Find and Replace window. Press Find Next search downwards. Hold Shift when pressing Find Next search upwards. (Tweet ID-1604903555747311617)

*Nov 23, 2022: Double click an option in a dialog box or pop-up window instead of pressing OK to execute. For example, press Ctrl+Shift+= *equal sign* to insert a row. Double click Entire row instead of selecting Entire row and pressing OK. #exceltip (Tweet ID-1595497363715420161)

*Sep 28, 2022: Extract unique values or extract duplicate values. Cells A1:A7 is a fruit table. Cell A1 is the column header. Cell C1 is =UNIQUE(A2:A7,0,0) returns unique values. Cell E1 is =UNIQUE(A2:A7,0,1) returns duplicate values only [--Apple and Orange are duplicates, formula returns Apple and Orange.] #exceltip (Tweet ID-1575184416179003392)

*Sep 16, 2022: Excel worksheet with multiple blank rows unconnected to be deleted. Select the entire cells. Press Ctrl+G. Press Special. Select Blanks. Press OK. Right mouse click a selected cell. Select Entire row. Press OK. Multiple blank rows deleted. #exceltip RM: Okay to select the leftmost column of data instead of the entire cells. (Tweet ID-1570830416139157505)

*Aug 29, 2022: Select all cells in an Excel table except the column headers. Press Ctrl+Spacebar, Shift+Spacebar. Or point cursor to the upper left of the Excel table. Cursor turns into an arrow pointing down and right or southeast. Single mouse click. #exceltip (Tweet ID-1564344389182185472)

*Jun 14, 2022: Left mouse click a calculation on the status bar to copy to clipboard. Paste anywhere. Highlight cells A1:A10. Left mouse click Sum: 55. Paste the sum 55 on cell B1. #exceltip (Tweet ID-1536811675348652032)

*Jun 7, 2022: Copy a cell or a text in Excel or another program. Press Alt+Ctrl+V to open the Paste Special window. There must be something to be pasted for Alt+Ctrl+V to work. #exceltip (Tweet ID-1534256145094782978)

*Apr 15, 2022: Press Alt+*number* to use the tools in the Quick Access Toolbar. My three tools are Format Painter, Speak Cells, and Select Objects from left to right in Excel. Alt+1 activates Format Painter. Alt+2 activates Speak Cells. Alt+3 activates Select Objects. #exceltip (Tweet ID-1515084816261152769)

*Jan 7, 2022: Scroll left and right on a worksheet without using the horizontal scroll bar. Hold Ctrl+Shift, scroll up and scroll down on your mouse wheel scroll the worksheet left and right. #exceltip (Tweet ID-1479586187027222529)

*Dec 29, 2021: Use TEXTJOIN to combine text from multiple cells. Cells A1 is Apple, A2 is Orange, A3 is Banana. Cell A5 is =TEXTJOIN(", ",TRUE,A1:A3) returns Apple, Orange, Banana for which TRUE ignores blank cells. #exceltip (Tweet ID-1476318390008442887)

*Dec 17, 2021: Press Shift+F2 to insert a New Note in a cell. Press Esc, Esc to save note and exit. Edit an existing note press Shift+F2. Save edit and exit press Esc, Esc. #exceltip (Tweet ID-1471999977983340547)

*Nov 1, 2021: Excel press Alt+Ctrl++ (plus sign) to zoom in. Excel press Alt+Ctrl+- (minus sign) to zoom out. Excel press Alt, W, G to zoom in at selected cell. #exceltip (Tweet ID-1455324557909192709)

*Sep 3, 2021: Use Excel to print the file names in a folder. Click Data-->Get Data--From File-->From Folder. Click the folder in Browse window. Click Open. Click Load. A pivot table is created with the file name, dates, extensions, and path. #exceltip (Tweet ID-1433949522053328896)

*Aug 20, 2021: Cell A1 is 1. Cell A2 is 2. Cell A3 is 3. Cell A4 is 4. Cell A5 is 5. Cell A10 is =SUM(A1:A5). Press Ctrl+' on cell A10 highlights cells A1:A5 used in formula. Press ESC to exit. Also, press Ctrl+[ selects cells A1:A5 used in formula. #exceltip (Tweet ID-1428835342447112193)

*Jun 24, 2021: A faster way to switch Excel windows is View-->Switch Windows-->select Excel window or Alt, W, W, number for which the number references an open Excel file. It may be faster than Ctrl+F6. #exceltip (Tweet ID-1408182043725352962)

*Jun 10, 2021: Use LEN and SUBSTITUTE to count specific characters in an Excel cell. Cell A1 is mississippi. Count the i's =LEN(A1)-LEN(SUBSTITUTE(A1,"i","")) returns 4. LEN of mississippi is 11. LEN and SUBSTITUTE replaces the letter i with nothing returns 7. 11-7=4. #exceltip (Tweet ID-1403165898676998144)

*May 25, 2021: A quicker way to copy and paste one time use. Copy the cell or cells to copy Ctrl+C. Go to the cell to paste and press Enter which is a little quicker than Ctrl+V. #exceltip (Tweet ID-1397294669780766723)

*May 25, 2021: Use F4 to paste multiple times. Cell A1 is Today is Tuesday. Press Ctrl+C to copy. Go to cell C5. Press Alt, E, S, Enter to paste using Paste Special. Go to cell G5. Press F4 to paste. Go to cell G8. Paste F4 to paste. #exceltip (Tweet ID-1397293933739143168)

*May 12, 2021: Use Excel TRUNC function to return a number without its decimal number. =TRUNC(7999.51,0) returns 7999. =TRUNC(7999.49,0) returns 7999. #exceltip (Tweet ID-1392612685137678343)

*May 12, 2021: Use Excel INT function to round down nearest integer. =INT(7.9) returns 7. =INT(7.1) returns 7. =INT(-7.9) returns -8. =INT(-7.1) returns -8. #exceltip (Tweet ID-1392611926908096512)

*Mar 25, 2021: Press Alt+Enter in an Excel cell to insert a new line or insert a line break. Alt+Enter also enables Wrap Text. To wrap text without line break, Alt+Enter, Ctrl+Enter, F2, Backspace, Enter. #exceltip (Tweet ID-1375245314588696577)

*Jan 16, 2021: Excel table shortcut keys. Ctrl+Spacebar selects a column, Shift+Spacebar selects a row. Access the filter drop down menu press Alt+Down Arrow if cursor on the column header; otherwise Alt+Shift+Down Arrow. Access drop down menu Alt+Down Arrow. #exceltips (Tweet ID-1350646794649104385)

*Sep 21, 2020: The CONVERT function takes a measurement and converts to another measurement. Cell A1 is 50. Cell B1 is =CONVERT(A1,"sec","hr") converts 50 seconds to 0.013889 hours. Cell C1 is =CONVERT(A1,"in","ft") converts 50 inches to 4.166667 feet. #exceltip (Tweet ID-1308290224846327808)

*Sep 18, 2020: Display the number zero as n/a or as a blank cell in Excel using Format Cells. Numbers are between 0 and 99,999. \n Cell A1 is 0. Cell B1 displays n/a custom format cell #,###;;"n/a". Cell C1 displays blank cell custom format cell #,###;; #exceltip (Tweet ID-1307048633209171973)

*Aug 14, 2020: Excel Microsoft 365 view the same worksheet in multiple windows View-->New Window or Alt,W,N. Likewise for Excel 2016 View-->New Window. #exceltip (Tweet ID-1294340056790966272)

*Jun 18, 2020: Excel format cells tip. Cell A1 is My number is *number*. Press Ctrl+A1-->Number-->Category-->Custom-->Type. Under Type, type "My number is "#. Press OK. User types a number in Cell A1 instead of typing My number is *number*. Cell A1 displays My number is *number*. #exceltip (Tweet ID-1273699206100746240)

*Jun 2, 2020: Shortcut keys to insert an Excel new worksheet and name the new worksheet. Shift+F11, Alt, H, O, R, type worksheet name. #exceltip (Tweet ID-1267943510088380417)

*May 19, 2020: Excel users press F1 opening the Help pane instead of ESC. \n The shortcut keys to close are Ctrl, Space, C when the Help pane is focused. It can work with other task panes. #exceltip (Tweet ID-1262812478276161536)

*Apr 23, 2020: AutoFit column size hover the mouse between column identification letters and double-click. The double-click resizes to greatest length. If you want to AutoFit column size at shorter length, select the cell with shorter length text on column, press Alt, H, O, I. #exceltip (Tweet ID-1253405685947088896)

*Jan 3, 2020: Press Ctrl+G to open the Go To window. Cursor is at cell G100. User wants to go to cell J5. Press Ctrl+G, type J5 at Reference, press OK. Cursor is at cell J5. #exceltip (Tweet ID-1213233121530826752)

*Jan 3, 2020: Press Ctrl+' to copy the exact Excel formula above a cell. Press Ctrl+Shift+' to copy the value from the Excel formula above a cell. #exceltip (Tweet ID-1213232369559228416)

*Nov 9, 2019: Audit Excel formulas for consistency. Highlight a column of formulas. Press Ctrl+Shift+\\ (Backspace). Highlighted cells afterwards are the inconsistent formulas. Press Ctrl+\\ (Backspace) for a row of formulas. #exceltip https://t.co/PvZNH0vxvv (Tweet ID-1193279270426050560)

*Oct 26, 2019: Hold the Ctrl key when clicking cells in a formula. The comma separators are automatically inserted. e.g. SUM function hold Ctrl clicking cells A1, B5, C9, D10. Result is =SUM(A1,B5,C9,D10) with commas automatically inserted. #exceltip (Tweet ID-1188157535238230016)

*Sep 13, 2019: #exceltip Cells A1:A20 contain integers. Need to add 100 to each integer. Type 100 at cell C1. Copy cell C1. Highlight cells A1:A20. Home-->Paste-->Paste Special or Alt, H, V, S. (Tweet ID-1172579024549240832)

*Aug 10, 2019: View two worksheets in two windows in the same Excel file. View-->New Window or Alt+W+N, click on another worksheet on new Excel window. See the two worksheets. Can arrange the Excel windows View-->Arrange All such as Tiled or Horizontal. #exceltip (Tweet ID-1160280578081427456)

*Jul 13, 2019: An efficient way to format cells consistently is save the cell formatting. Home-->Styles-->Cell Styles-->New Cell Style. Complete the attributes including the style name and formatting. Keyboard shortcut Alt+H+J opens Cell Styles. #exceltip (Tweet ID-1150135338360119296)

*Jul 13, 2019: Ctrl + F1 to collapse the ribbon or pin the ribbon. Another method to collapse the ribbon or pin the ribbon is double click a menu object such as Home, Insert, or Data. #exceltip (Tweet ID-1150134239985192960)

*Jul 3, 2019: Highlight an Excel table without the headers. Hover cursor to the top left of the table to see a diagonal arrow pointing down and right or southeast. Single click. Table is highlighted except the headers. #exceltip (Tweet ID-1146612561208467456)

*May 21, 2019: Slicers and a total row are available for a table itself. Right mouse click anywhere on the table-->Table-->Totals Row to insert a total row. Table Tools-->Design-->Tools-->Insert Slicer to insert a slicer. #exceltip (Tweet ID-1131022721372917760)

*Apr 25, 2019: The Excel AVERAGE() functions include cells containing zeros calculating the average and excludes blank cells. If you must include zeros for display and not in average calculation, then type ">0" in the criteria; e.g. =AVERAGEIF(A1:A30,">0"). #exceltip (Tweet ID-1121525498733944832)

*Apr 1, 2019: Excel short cut key to insert today's date in a cell is Ctrl+;. Excel short cut key to insert current time in a cell is Ctrl+Shift+;. #exceltip (Tweet ID-1112790426795171840)

*Mar 19, 2019: Type CHAR(13) in an Excel formula for a carriage return. A good use for CHAR(13) is a formula label for a chart. e.g. ="B4label = "&B4&CHAR(13)&"B5label = "&B5&CHAR(10)&"b6label = "&B6 #exceltip (Tweet ID-1108126732781932544)

*Feb 19, 2019: One way to print selected cells in an Excel worksheet is File-->Print--> under Settings first drop down box select Print Selection. A quicker way is Ctrl+P, under Settings first drop down box select Print Selection. #exceltip (Tweet ID-1098063153655513089)

*Feb 18, 2019: Use DOLLAR(number,decimal places) to add the dollar sign in an Excel cell. =DOLLAR(5,0) is $5. ="I won "&DOLLAR(5,0) is I won $5. ="I won "&DOLLAR(5,2) is I won $5.00. #exceltip (Tweet ID-1097715959853240320)

*Jan 18, 2019: Select an entire column. Select column B type B:B. =COUNTIF(B:B,A1). Select multiple contiguous columns. Select columns E to G type E:G. =VLOOKUP(A1,E:G,3,0). #exceltip (Tweet ID-1086449171849142272)

*Jan 18, 2019: Split a column or separate a column with a common character Data-->Text To Columns. Can save time instead of writing formulas. #exceltip (Tweet ID-1086448132123049985)

*Jan 18, 2019: A quick way to open the Excel Page Setup window is Page Layout-->under Page Setup group click bottom right arrow. Short cut keys Atl+P+S+P is another way. #exceltip (Tweet ID-1086447268968853505)

*Jan 18, 2019: A quick way to add text to a header or footer is Insert-->Text-->Header/Footer. View-->Page Layout double click Add header works, too. #exceltip (Tweet ID-1086445724911337472)

*Jan 18, 2019: A quick way to rotate an Excel file orientation from portrait to landscape and vice versa is Page Layout-->Orientation-->Portrait or Landscape #exceltip (Tweet ID-1086444720065105923)

*Jul 30, 2018: #exceltip A table with named columns. Create a helper column to filter the table. OR criteria =OR([column1]="Hat",[column2]="Fred",[column3]>25). AND criteria =AND([column1]="Cat",[column2]="Ratbag",[column3]>=63). (Tweet ID-1024066197233397760)

*May 21, 2018: Excel tip. Logical formula equal sign = is case insensitive. Cell A1 is rad. Cell A2 is Rad. =A1=A2 returns TRUE. ="rad"="Rad" returns TRUE. #exceltip (Tweet ID-998668958629687296)

*May 9, 2018: Excel tip. Cells A1:E10 have numbers. Highlight cells A1:F11. Press Alt + =. Excel adds =SUM() to F1:F11 and A11:F11 adding the rows and columns. #exceltip (Tweet ID-994300830109990912)

*Apr 11, 2018: In Excel, Alt, I, R inserts new row above. e.g. Cursor on cell A5. Press Alt, I, R. New row inserted at row 5. #exceltip (Tweet ID-984157390948843520)

*Feb 2, 2018: Excel tip. Highlight or select multiple cells. Pressing tab moves active cell only to highlighted or selected cells. e.g. highlight A1:E5. Press tab active cell cycles highlighted A1:E5 cells only. (Tweet ID-959575640021151744)

*Dec 20, 2017: Excel tip. Alt, E, A, F clears cell formatting. Alt, E, A, A deletes entire cell. (Tweet ID-943688412753666049)

*Nov 27, 2017: Excel tip. Ctrl+Left click the left arrow at the worksheet bar scrolls to the first sheet. Ctrl+Right click the right arrow at the worksheet bar scrolls to the last sheet. (Tweet ID-935247792712249344)

*Nov 7, 2017: Excel tip. Ctrl + Shift + L inserts the Filter on a row of column headers. (Tweet ID-928092804617707520)

*Nov 7, 2017: Excel tip. Ctrl+X to cut a formula in a cell. Paste the formula in another worksheet same file. The pasted formula in the new worksheet contains the cell references referencing the originating formula. (Tweet ID-928092562694402048)

*Oct 3, 2017: Excel tip. Right mouse click sheet scroll arrows a list of all the sheets in the Excel file appears. Select the sheet to view. (Tweet ID-915325707617673216)

*Sep 18, 2017: Excel tip. Deactivate GETPIVOTDATA cell referencing in pivot table. File->Options->Formulas->uncheck Use GetPivotData functions for Pivot... (Tweet ID-909952106169171968)

*Sep 7, 2017: Excel tip. Use integer INT() function to remove decimals. =INT(16.98748754) returns 16. Likewise for INT(16.11245478) and INT(16.45487897). (Tweet ID-905873049810984960)

*Aug 15, 2017: Excel tip. Ctrl + Shift + ~ converts a cell to General format. General format useful to see what's really in the cell. No format deception. (Tweet ID-897542826581426176)

*May 3, 2016: EOMONTH(A1,1) returns 6/30/14. EOMONTH(A1,-1) returns 4/30/14. EOMONTH(A1,-1)+1 returns 5/1/14. #exceltip (Tweet ID-727711932099264512)

*May 3, 2016: Use EOMONTH() to find the last day of a month. Cell A1 is 5/3/14. EOMONTH(A1,0) returns 5/31/14. EOMONTH(A1,0)+1 returns 6/1/14 #exceltip (Tweet ID-727711362898612226)

*Mar 2, 2016: Under Data tab, there's a Get External Data Excel wizard importing data from various database. No need open database. #exceltip (Tweet ID-705175893849714689)

*Jan 7, 2016: TRIM function removes excess spaces before and after a text string including excess spaces between words #exceltip (Tweet ID-685233340509626368)

*Nov 18, 2015: The AVERAGE function ignores cells with text when calculating the average. #exceltip (Tweet ID-667071715919327232)

*Nov 17, 2015: 3-D cell reference steps: 1 Click on first sheet. 2 Highlight range. 3 Hold Shift key. 4 Click on last sheet. Source ExcelIsFun #exceltips (Tweet ID-666759708796059648)

*Nov 15, 2015: Use Alt, E, A, A shortcut key combination to clear cells content in Excel #exceltip (Tweet ID-665840573140496384)

*Jun 10, 2015: Excel tip: Press Ctrl+Enter after typing a formula in a cell to keep the cell with formula active. (Tweet ID-608731198718758913)

*May 13, 2015: #exceltip =RANDBETWEEN(x,y) generates a random number between x and y. x and y are numbers. (Tweet ID-598642900793044000)

*May 11, 2015: #exceltip Sometimes an Excel formula converts number into text. To convert text back to number, add zero, multiply by one, double negative, (Tweet ID-597696951363112000)

*May 11, 2015: #exceltip Press Ctrl + Shift + ` or ~ button to convert a cell to General format. (Tweet ID-597688670691328000)

*May 6, 2015: #exceltip Column A has numbers 1, 2, 3, 4, 5. Sum is 15. On Cell A6, press Alt + = (Alt and Equal). Excel adds formula =SUM(A1:A5) (Tweet ID-596149904935784000)

*Jul 26, 2012: Excel tip. The Format Painter copies a cell's format settings including font, color, and format. (Tweet ID-228568175074213000)

Sunday, September 10, 2023

Schools Give Out An Unlimited A Grades

I admit I'm not education professional. If schools want to give out more A's for an easier school day, need to give out more A's while convincing more students to attend classes for more funding, feel less guilty conscious being dishonest, turn off their sincerities, and stop caring, then all of the above are accomplished easily. Students must not be fooled life in the classrooms reflect real life. The purpose of going to school is to learn. Students learn the ABC's and 123's; in particular, college bound high school students prepare for college enrollment taking required classes and exams. Nothing more. Nothing less. Anything taught outside the ABC's and 123's are bonuses and exceptions.

True A graded students learn outside the classroom 365 days a year. True A graded students are not the 3.5's and the 4.0's. Never stop learning. Never stop innovating--innovate infinitely. If students don't participate in athletics, then exercise at home. Read leisure books. Learn life skills such as cooking, tying knots, programming, Excel, changing the oil in a car, running basic PC, and sewing. There's nothing wrong with playing video games, watching movies, and socializing with friends. Know the priorities. Strengthen your self-confidence, self-esteem, socializing skills, and communication skills. Discover motivation. I will is more important than I know. It's okay to make mistakes. Make intelligent mistakes to learn from them. Schools teach none of the above.

The real life is not A grades. The real life is not feel good participation awards. People show up resulting in people succeeding is false. Students attend school whether they like it or not. Students attend school whether they're present or the minds are someplace else. The real life is people don't do anything not feeling up to it. People do quit. People say goodbye. The real life is limited opportunities for too many people.

People should wonder why the big successful people didn't earn A's and B's. They earned C's. Or they dropped out of college such as Bill Gates, the late Steve Jobs, and some professional athletes.

Friday, September 08, 2023

Review My Daily Life Rules For 2023

The last time I reviewed was Mar 10, 2018 That Was Quick. Review My Daily Life Rules Again. I take the time to updated and to revise my rules. Think simple. Avoid complications. I remove rule number 9 and rule number 10. The two rules aren't use daily. I removed rule number 7 from Review My Daily Life Rules on Mar 3, 2018.

My latest life daily rules in its entirety below:

1. Don't criticize, condemn, and complain, and don't compare with others.
2. Don't act like a jerk or bitch.
3. Always speak calmly and be calm.
4. Don't daydream when driving.
5. Keep your head up high . . . look at their cute face when talking.
6. Breath with your nose and stand up straight.
7. Have faith. Believe in yourself.
8. Let me think. Be discrete.
9. Welcome a roller coaster life.
10. Back in time and front and present.

Update On A Past Blog

A random thought appeared on my head. I added a class on the first day of instruction for the first time in my college years. The class was Economics 103 Mathematical Methods For Economics during Spring Semester 1996 at San Jose State University. I earned an easy A grade because I took Mathematics 30 Calculus I. I incorrectly said it was an irony from Top Ten Life Ironies written on Dec 25, 2013. It was a highlight for the year 1996 written on Dec 5, 2013. I correctly said it was good timing from Top Ten Good Breaks And Good Timing written on Jul 8, 2013.

Saturday, September 02, 2023

Shelter In-Place COVID-19 Blog August 2023

California issued shelter in-place orders on Tue Mar 17, 2020. I have been logging the highlights and lowlights. The late summer COVID-19 surge continues appearing in more headlines. Also, new variants appearing in headlines. August was the slowest month of the year.

Tue Aug 1. Japan approved the nation's first vaccine developed domestically. The vaccine is Daichirona made by Daiichi Sankyo. Daichirona is administered as a booster. Japan used Pfizer and Moderna beforehand.

Thur Aug 3. Shopped at Costco. Ate pizza for dinner at Tony & Alba's.

Mon Aug 7. The EG.5 variant was the dominant strain in the US. The Center For Disease Control (CDC) estimated 17.3% cases were EG.5, 15.6% cases were XBB.1.16, 11.2% cases were XBB.2.23, 10.3% cases were XBB.1.5, and 8.6% cases were FL.1.5.1. EG.5 is nicknamed Eris. All other variants were descendants of the XBB strain.

The Eris strain was growing in the United Kingdom.

Thur Aug 10. Shopped for used books at the Saratoga Library and the Los Gatos Library. Ate lunch at Chipotle.

Mon Aug 14. Morning errands at Safeway, Books, Inc., and Chevron.

Tue Aug 15. Utah resident Gordon Pederson was arrested for selling a fake cure. The fake cure was an alkaline silver solution. Pederson was on the run since Aug 2020. The charges included mail fraud, wire fraud, and felony introduction of misbranded drugs into interstate commerce with intent to defraud and mislead.

Wed Aug 16. The CDC reported COVID-19 hospitalizations increased 60% since early Jul. The increase was 14% since last week. Hospitalization rates were higher in the south including Florida, Alabama, and Louisiana. Wastewater samples indicated transmissions increased. The number of deaths increased slightly.

Thur Aug 17. The CDC tracked a new highly mutated variant strain BA.2.86 in Michigan. The World Health Organization (WHO) monitored BA.2.86 due to the large number of mutations. Denmark and Israel reported a case of BA.2.86.

Mon Aug 21. COVID-19 hospitalizations and deaths increased because of three variants spreading in the US. EG.5 or Eris was the dominate strain estimated 20.6% of infections. FL.1.5.1 or Formax was the second dominate strain estimated 13.3% of infections.

Wed Aug 23. The US Justice Department announced 371 arrests totaling $836 million in COVID-19 fraud. A total of 3,200 arrests totaling $1.4 billion in stolen pandemic aid. There are five COVID-19 Fraud Enforcement Strike Forces in Colorado, New Jersey, California, Florida, and Maryland.

Thur Aug 24. Shopped at Smart & Final, Trader Joe's, and Safeway.

The Lee County School District and Magoffin County School District in Kentucky cancelled in-person classes due to an increase in COVID-19 cases for the week. Classwork was completed remotely. Students return to classes on Mon Aug 28. Some of the school staff tested positive.

Also, the Runge School District in Texas closed since Tue Aug 22. The school reopens on Tue Aug 29.

Kaiser Permanente hospital in Santa Rosa, CA resumed mask requirements for doctors and staff. Patients and visitors were encouraged to wear masks.

Fri Aug 25. President Joe Biden requested more money from Congress for COVID-19 updated vaccines. The virus continued to mutate. Pfizer, Moderna, and Novavax are manufacturing the updated XBB vaccine version.

Mon Aug 28. Shopped at Target, Smart & Final, and Trader Joe's.

Canada reported a case of BA.2.86.

Wed Aug 30. Red flag warning. Spare the air alert. The cause was the Northern California wildfires. No wind to dissipate.

A local tabletop gaming group meeting monthly at a local library organizer encouraged all attendees to get tested. The organizer tested positive being sick days after the meetup.

Thur Aug 31. Afternoon errands at Smart & Final and Lucky.

The State Of California Public Health announced the state's positivity rate was 13%. The rate was 3% at the start of the summer. The state's daily hospitalizations increased from 186 to 336.

Update On A Past Blog

There was another incident I failed to check my receipt. I blogged the first incident Stop And Smell The Roses And Read Your Receipt on Feb 3, 2022. I purchased three packs of chicken at the same supermarket on two days. I returned the three packs of chicken second day purchase to the same supermarket using the three packs of chicken first day purchase receipt. In other words, I used the first receipt on the second purchase. My emotional anger wasting time returning the chicken overwhelmed being calm. I admit I made a mistake.