Lotto Forums
How To Win

Go Back   Lotto Forums > Lotto Forums General Discussion > Questions & Answers

Questions & Answers Got Questions? We Have Answers.

Reply
 
Thread Tools Display Modes
  #1  
Old 05-10-2008, 09:32 AM
Winalot2007 Winalot2007 is offline
Registered User
 
Join Date: Oct 2007
Posts: 40
Excel - VTRAC Conversion Formula - Pick 3

Looking for a for Excel formula for Pick 3 Combos.

Digits To VTRAC Chart

0 and 5 = VTRAC = 1
1 and 6 = VTRAC = 2
2 and 7 = VTRAC = 3
3 and 8 = VTRAC = 4
4 and 9 = VTRAC = 5

In cell A1 I enter a Digit 7
In cell B1 I enter the formula =MOD(A1,5)+1
This would give me a VTRAC of 3 (1 Position or Number)
(See chart above) Digit 7 = VTRAC 3

If I enter 725 in cell A1, what formula could I use where cell B1 the result would be 331?
(Digit Combo 725 = VTRAC Combo 331)

Thanks!!
Reply With Quote
  #2  
Old 05-10-2008, 01:23 PM
Excellence Excellence is offline
Registered User
 
Join Date: Jul 2007
Posts: 71
=VALUE(CONCATENATE(MOD(VALUE(LEFT(A2;1));5)+1;MOD( VALUE(MID(A2;2;1));5)+1;MOD(VALUE(RIGHT(A2;1));5)+ 1))

It should work if I understand correct what you want.
Reply With Quote
  #3  
Old 05-10-2008, 04:02 PM
Winalot2007 Winalot2007 is offline
Registered User
 
Join Date: Oct 2007
Posts: 40
=VALUE(CONCATENATE(MOD(VALUE(LEFT(A2,1)),5)+1,MOD( VALUE(MID(A2,2,1)),5)+1,MOD(VALUE(RIGHT(A2,1)),5)+ 1))

Excellence this worked great.

The only problem is when you have a digit combos 000 through 099.
Reply With Quote
  #4  
Old 05-10-2008, 06:23 PM
Winalot2007 Winalot2007 is offline
Registered User
 
Join Date: Oct 2007
Posts: 40
OK,

Here is the corrected formula.

=VALUE(CONCATENATE(MOD(VALUE(LEFT(TEXT(A1,"000"),1 )),5)+1,MOD( VALUE(MID(TEXT(A1,"000"),2,1)),5)+1,MOD(VALUE(RIGH T(A1,1)),5)+1))
Reply With Quote
  #5  
Old 05-15-2008, 02:59 PM
GillesD's Avatar
GillesD GillesD is offline
Registered User
 
Join Date: Oct 1999
Location: Montréal
Posts: 715
VTRAC formula

If you want to reduce the size of your file, especially if you have a lot of numbers for which you calculate the VTRAC value, you may want to use this shorter formula:

=MOD(INT(A9/100),5)*100+MOD(INT(A9/10),5)*10+MOD(A9,5)+111

It works since, in Excel, doing calculations on a string representing a number will usually result in a value. Even, it is not necessary to format the cell as "000" (three digits) since VTRAC values will range from 111 to 555.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
johnny40 systems johnny40 Anything Goes 16 01-29-2007 07:23 PM
Pick 3 & Pick Canada's Hot Picks - Predictor Genie's Todd Kelly The Daily Lottos 0 05-15-2002 11:34 AM
Predictor Genie Tuesday Hot Picks Todd Kelly The Daily Lottos 5 05-08-2002 04:56 PM
Predictor Genie "Canada's Hot Picks" Yea Todd Kelly The Daily Lottos 0 05-01-2002 11:14 AM
Predictor Genie Canada Hot Picks Todd Kelly The Daily Lottos 0 04-30-2002 11:03 AM


All times are GMT -5. The time now is 04:34 AM.

Silver Lotto System
Silver Lotto System

 

Free Lottery Secrets Report
Free Lottery Secrets Report

 

Megamillions 125x125
NEW Lottosend

 


Get Your Best Bet Days

 

Lottosend  468x60

Powered by vBulletin
Copyright © 2000 - 2014 Jelsoft Enterprises Ltd.
Copyright © 1999 - 2014 LottoForums.com