Database/spreadsheet help.... thanks

[Korn]

I have a question to those of you that deal with database's and spreadsheets...

Is it possible to do the following?
When you make a database, have it so that when you enter info into the database it automatically fills in a spreadsheet to the way you customize it?

Example: Say you have a spread sheet that lists each NHL team. And you want to fill in each game they've played and their score. Ex. Vancouver 4, Montreal 3... Instead of having to open up Vancouvers sheet and entering Vancouver 4 Montreal 3... and then opening up Montreals page and entering Montreal 3 Vancouver 4.... Is there a way to just create a form on the database so that you just enter the info for the game once and then it will automatically take that info and fill in both pages on the spreadsheet for both teams?

Hope this makes sense...

Thanks

Korn

(ps: i'm using Access and Excel)

 

[phoenix566]

Not really sure how you can accomplish that, but perhaps having an array formula can do the trick. Limited info on arrays can be found in 'help'.

 

[Korn]

Thanks for responding Phoenix...

I'll take a look at that... but I have found another way to do it... Theres an option in Excel.. "DATA/Get external data" Then that allows you to select an alternate file such as a database to get data from and then it lets you create a query to gather the data that you want...

I have a question about your wagertracker software... I was just curious if theres an easy way to modify it so that you can make the Units as Units to bet and not units to "win". The way it is set right now is that if your unit is $100 and if you put it down as a 1 unit play on say a ML of -200 and you lose it will come up as -$200 loss... and if you won it would be +$100. I'm just curious as to if its possible to make it so that if you play 1 unit on -200 and you lose it will show up as -$100 but if you won it would show up as +$50... If theres an easy way to do this please let me know.... if not thats alright..

Thanks for your time and I am getting good use out of your program... Out of the limited time that I've used it, it is really showing me how bad Parlays and teasers really are and how much they are costing me!

Thanks again
Korn

 

[phoenix566]

The easy way to accomplish what you want is to enter Odds instead of the money line. -200 translates to .50 odds (positive value of 1/ml). When you enter it this way, a loss appears as -100 and a win as 50. This also allows both 'x unit to win' and 'to risk x unit' to be calculated under the 'x unit' tallies.

I too discovered that in the long run (even short run) parlays and teasers are sucker bets. Ultimately it takes 'luck' to hit them given all the variables involved and all the teams involved. Then again for 5 or 10 bucks on line, its like buying some 'pick 5' tickets and can't hurt that much?