time*treat's Blog

Non-carrying math 

P3: 987 + 456 = 333

P4: 9557 + 1576 = 0023

(use custon formatting to show leading zeroes)

Begin by splitting the old numbers ... sum by column, mod sums by 10, then place the new numbers.

*	D	E	F	G	H
2
3	987	= INT(D3/100)	= INT(MOD(D3,100)/10)	= MOD(D3,10)
4	456	= INT(D4/100)	= INT(MOD(D4,100)/10)	= MOD(D4,10)
5	=E5*100+F5*10+G5	=MOD(E3+E4,10)	=MOD(F3+F4,10)	=MOD(G3+G4,10)
6
7
8	9557	= INT(D8/1000)	= INT(MOD(D8,1000)/100)	= INT(MOD(D8,100)/10)	= MOD(D8,10)
9	1576	= INT(D9/1000)	= INT(MOD(D9,1000)/100)	= INT(MOD(D9,100)/10)	= MOD(D9,10)
10	=E10*1000+F10*100+G10*10+H10	=MOD(E8+E9,10)	=MOD(F8+F9,10)	=MOD(G8+G9,10)	=MOD(H8+H9,10)

Visually =E10&F10&G10&H10 gives the same result as =E10*1000+F10*100+G10*10+H10.
The difference is the first is a text string, the second is still a number. You can do further calculations on the second.

*Sometimes you're not using cell A1

To split a p3 or p4 number into component parts

P3: full number in cell A1: e.g. 234
formula in B1: = INT(A1/100)
formula in C1: = INT(MOD(A1,100)/10)
formula in D1: = MOD(A1,10)

P4: full number in cell A3: e.g. 4321
formula in B3: = INT(A3/1000)
formula in C3: = INT(MOD(A3,1000)/100)
formula in D3: = INT(MOD(A3,100)/10)
formula in E3: = MOD(A3,10)

____	A	B	C	D	E
1	234	2	3	4
2
3	4321	4	3	2	1
4	____	____	____	____	____

'LP Code TOC 1.0'
'LP threads/blogs with code snippets (not cell formulas or "systems").'
'Thread/blog entry may contain multiple code sections.'
'
'https://www.lotterypost.com/thread/number-block 1/number-block 2'
' takes you to a specific reply on a thread'

'https://www.lotterypost.com/thread/number-block 1'
' takes you to the first entry on a thread'
'
'RANGE: All History from Feb 22, 2011 and earlier'
'''''''''''''''''''''''''''''''''''''''''

'BLOGS: Alpha by author'

GASMETERGUY's Blog
https://www.lotterypost.com/blogentry/20245
VBA Lesson 1
December 20, 2007

https://www.lotterypost.com/blogentry/20780
VBA Lesson 2
January 21, 2008


hypersoniq's Blog
https://www.lotterypost.com/blogentry/5982
on to the next thing...
January 14, 2006


JADELottery's Blog
https://blogs.lotterypost.com/jadelottery/2009/04/byte-me.htm
Byte Me
Saturday, April 11, 2009

https://blogs.lotterypost.com/jadelottery/2010/9/combinatorial-index.htm
https://www.lotterypost.com/blogentry/45769
Combinatorial Index
Saturday, September 04, 2010


LottoMining's Blog
https://blogs.lotterypost.com/lottomining/2007/12/access-database-and-vb-db-code-primer-draft-1.htm
Access database and VB DB code primer draft 1
Saturday, December 22, 2007

https://blogs.lotterypost.com/lottomining/2010/05/access-database-code-to-generate-combos-of-3.htm
https://www.lotterypost.com/blogentry/41310
Access database code to generate combos of 3 from Pick 5 table
Sunday, May 23, 2010


Speednet's Blog
https://www.lotterypost.com/blogentry/20433
ChangeAll extension method alters every item in an iCollection(Of T)
January 2, 2008


winsumloosesum's Blog
https://www.lotterypost.com/blogentry/5474
Sum of Digits in 1 Cell - VBA Code
December 14, 2005

https://www.lotterypost.com/blogentry/40102
Excel - Creating Pick 3 and Pick 4 Combinations VBA
April 24, 2010


'FORUMS: Forum Name -> Thread Title'

'2004'
Lottery Systems -> SUMS
https://www.lotterypost.com/topic/82447
March 1, 2004 (first post)

Lottery Discussion -> Combination Vba
https://www.lotterypost.com/topic/85174
April 16, 2004 (first post)


'2005'
Lottery Systems -> Parsing
https://www.lotterypost.com/thread/104896/313359
January 7, 2005 (first post)

Lottery Discussion -> The Trend vs What's Due
https://www.lotterypost.com/thread/108803/349809
March 3, 2005 (first post)

Mathematics -> Excel VS. VB
https://www.lotterypost.com/thread/123519/486805
November 25, 2005 (first post)

Lottery Systems -> Excel Users - Pick 3 & Pick 4
https://www.lotterypost.com/thread/124458/496144
December 9, 2005 (first post)

Lottery Discussion -> Macros in excel
https://www.lotterypost.com/thread/124765/513024
December 15, 2005 (first post)

Lottery Discussion -> Maybe I am not saying what I mean
https://www.lotterypost.com/thread/124805/500018
December 16, 2005 (first post)

Lottery Discussion -> Visual Basic Applications in Excel
https://www.lotterypost.com/thread/125591/508386
December 29, 2005 (first post)


'2006'
Lottery Discussion -> Wheels using excel ?? Why Not!
https://www.lotterypost.com/thread/125920/512316
January 3, 2006 (first post)

Lottery Systems -> excel formula help
https://www.lotterypost.com/thread/126186/516342
January 7, 2006 (first post)

Pick 4 -> Need help with straight pick 4 wheel
https://www.lotterypost.com/thread/126479/518515
January 12, 2006 (first post)

Lottery Systems -> need help from the excel gurus...
https://www.lotterypost.com/thread/127069/526444
January 22, 2006 (first post)

Mathematics -> Macro Lessons??
https://www.lotterypost.com/thread/127438/529568
January 28, 2006 (first post)

Lottery Systems -> Multiple Scenarios, Single Run (MSSR)
https://www.lotterypost.com/thread/128762/543758
February 17, 2006 (first post)

Lottery Systems -> Excel User Defined Functions
https://www.lotterypost.com/thread/138892/653335
July 24, 2006 (first post)


'2007'
Lottery Systems -> Need help with Visual Basic 6
https://www.lotterypost.com/thread/155945/829328
May 12, 2007 (first post)

Mathematics -> Hits against combo in Excel
https://www.lotterypost.com/thread/158893/863994
July 9, 2007 (first post)

Mathematics -> For Excel Wizards Only!
https://www.lotterypost.com/thread/161171/884225
August 19, 2007 (first post)

Lottery Systems -> Free Program coming soon...
https://www.lotterypost.com/thread/166883/938614
December 2, 2007 (first post)

Lottery Systems -> Any have a chart... that
https://www.lotterypost.com/thread/167511/946732
December 15, 2007 (first post)


'2008'
Mathematics -> I need help with visual basics for exel
https://www.lotterypost.com/thread/168513/960640
January 5, 2008 (first post)

Mathematics -> Excel question - I'm stuck
https://www.lotterypost.com/thread/177995/1075647
July 12, 2008 (first post)

Mathematics -> Wheeling
https://www.lotterypost.com/thread/183415/1140899
October 23, 2008 (first post)


'2009'
Mathematics -> help with conditional formating in EXCEL
https://www.lotterypost.com/thread/189763/1240742
February 26, 2009 (first post)


'2010'
Mathematics -> The Quantum Sums
https://www.lotterypost.com/thread/209210/1674532
February 20, 2010 (first post)

Mathematics -> Combinations by number position
https://www.lotterypost.com/topic/216756
July 2, 2010 (first post)


'2011'
Mathematics -> Combinations and Statistics Help
https://www.lotterypost.com/topic/226442
January 20, 2011 (first post)

The Supreme Court ruled that federal law shields vaccine makers from product-liability lawsuits in state court seeking damages for a child's injuries or death from a vaccine's side effects.

http://www.reuters.com/article/2011/02/22/us-pharma-vaccines-lawsuit-idUSTRE71L41420110222

'Cause the astroturfing should really confuse the half-dozen or so people using the Afghani version of social networking ... during the 4 hours per day the power is on.

https://www.fbo.gov/index?s=opportunity&mode=form&id=d88e9d660336be91552fe8c1a51bacb2&tab=core&_cview=1

OK, so they're not the only ones ...

http://www.dailykos.com/story/2011/02/16/945768/-The-HB-Gary-Email-That-Should-Concern-Us-All

This tactic reminds me of the "coaching" that was done during the Healthcare debate.

William Kamkwamba: The Boy Who Harnessed the Wind

First ... they ignore you ...

Then ... they laugh at you and call you crazy ...

Finally ... they want to charge up their cell phones at your place.

(In some places, you'd need planning permission, an EPA impact study, public notice, "approved" materials, inspections ... )

Ky. Sen. Rand Paul (R) addresses the questions posed ...

... rather than discuss something completely different.

Spliced CPAC 10 audio & video onto CPAC 11 results. This clip shows what was broadcast vs. what happened on site.

Fair and Balanced ... only when the right people win.

We Distort. You Comply.

Perhaps that's why their pundits are suddenly asking "Do straw polls matter, anymore?"

Given what Faux did to the reporters in the Monsanto-Milk story, I'm not all that surprised.

Long-term negative implications if "indefinite detention" (along with all the other "gems" in the Orwellian era laws) is allowed to stand.

Good little neo-con goose-steppers won't see it that way until it's them being "loaded onto the trains".

http://www.bloomberg.com/news/2011-02-10/dutch-central-bank-pension-fund-must-sell-gold.html

AMSTERDAM (AP) — A pension fund in the Netherlands says the country's central bank has ordered it to sell its gold holdings because it is overexposed to a fall in the value of the yellow metal.

The Vereenigde Glasfabrieken pension fund said Thursday it wants to keep the gold but a Rotterdam court sided with the bank in a ruling Tuesday. The fund will now sell its gold holdings down from 13 percent of assets to 3 percent at most.

The fund began buying gold in 2008 due to concerns about inflation and the stability of the euro. It argued the investment has performed well since then, rising about 70 percent to around €1,000 per ounce.

The fund had €260 million in assets in December 2008, mostly in Dutch and German government bonds.

Where have I heard this dermo, before?

 

Speaking of "Helping Saddam" ...

http://www.peninsuladailynews.com/article/20110210/news/302109985/counterfeit-collector-coins-from-china-show-up-in-port-angeles

Alright, now it's getting personal.

http://www.reuters.com/article/2011/02/07/us-jpmorgan-gold-idUSTRE7162SG20110207

Mon Feb 7, 2011 9:42am EST

LONDON (Reuters) - J.P. Morgan Chase said ... it would accept physical gold as collateral with its counterparties as a growing number of clients look to use bullion as a hedge against inflation.

Isn't gold that "barbaric" yellow metal that sits there not "doing" anything and not "paying any interest"? 

http://www.hhs.gov/news/press/2011pres/01/20110107a.html

Remember, kiddies, anyone who protests is crazy.

If it weren't for EBT, the streets might be a bit intense here, too.