Em Andamento

Simple Web App - Grabs numbers from CSV and compares against user's numbers

I would like to create a simple website that allows users to enter 6 lottery numbers, and the site then calculates how much they would have won, had they played those numbers every week since the lottery began in 1994.

The lottery results are available at [url removed, login to view]

The information I would like to extract is the Day (Wed or Sat), Date, N1-N6, BN (bonus ball), Jackpot and Wins (the number of jackpot winners).

I would like the data to be extracted to a database on my server. The database should be updated twice weekly (on a Wednesday night after the lottery and a Saturday night after the lottery) by cron job.

User will enter 6 numbers, and the app will then compare the numbers with the numbers in the database. Based on the numbers in the database, the app will then calculate how many times they would have won. When comparing users numbers against the DB, it should check in this order...

6 Numbers

5 Numbers + Bonus Ball

5 Numbers

4 Numbers

3 Numbers

The jackpot (the amount they would win if they matched all 6 numbers) for each draw is included in the CSV file, and that should be used when calculating how much the user would have won, had they matched 6 numbers. For example, on Saturday 18 December 2010, the jackpot was ?956813 and there were 5 wins. When calculating the winnings, please add the user to the winners, making the total winners 6, and therefore their winnings ?159469 (please round to nearest ?).

Other wins should use the following approximate winning figures...

5 Numbers + Bonus = ?100000

5 Numbers = ?1500

4 Numbers = ?62

3 Numbers = ?10

So, the numbers should be compared against each week draw and then a total amount of winnings should be calculated.

I have attached a pdf of wireframes. More details on this project available below...

## Deliverables

I would like to create a simple website that allows users to enter 6 lottery numbers, and the site then calculates how much they would have won, had they played those numbers every week since the lottery began in 1994.

The lottery results are available at [url removed, login to view]

The information I would like to extract is the Day (Wed or Sat), Date, N1-N6, BN (bonus ball), Jackpot and Wins (the number of jackpot winners).

I would like the data to be extracted to a database on my server. The database should be updated twice weekly (on a Wednesday night after the lottery and a Saturday night after the lottery) by cron job.

User will enter 6 numbers, and the app will then compare the numbers with the numbers in the database. Based on the numbers in the database, the app will then calculate how many times they would have won. When comparing users numbers against the DB, it should check in this order...

6 Numbers

5 Numbers + Bonus Ball

5 Numbers

4 Numbers

3 Numbers

The jackpot (the amount they would win if they matched all 6 numbers) for each draw is included in the CSV file, and that should be used when calculating how much the user would have won, had they matched 6 numbers. For example, on Saturday 18 December 2010, the jackpot was ?956813 and there were 5 wins. When calculating the winnings, please add the user to the winners, making the total winners 6, and therefore their winnings ?159469 (please round to nearest ?).

Other wins should use the following approximate winning figures...

5 Numbers + Bonus = ?100000

5 Numbers = ?1500

4 Numbers = ?62

3 Numbers = ?10

So, the numbers should be compared against each week draw and then a total amount of winnings should be calculated.

There are two types of draws... Saturday Draws and Wednesday Draws. I would like the user to define whether they want to calculate their winnings from Saturday Draws, Wednesday Draws or Both.

I would like the user to be able to select "Win Details" link on the results page, which will open up a window which shows them details of their wins. The format for this page is included in the attached wireframes.

I have attached a pdf which shows how the site should be laid out. Dont worry about the actual look and feel of it, I'll have a designer do this, I just included this so you can see all aspects of the site I'd like you to code (I will code the FB and Twitter buttons).

If it will take longer than about 5 seconds to calculate the results, please let me know so that I can have a "Calculating..." animated gif made up to show while the app is calculating.

Any questions, please ask.

Habilidades: Amazon Web Services, Engenharia, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, Hospedagem Web, Gestão de Site , Teste de Website

Ver mais: wed designer job, wed designer, website designer app, web designer pdf, web designer job available, web designer database, web database designer, web app designer, simple web designer, simple php app, machine designer, how to draw like a designer, how to create a simple php web, how much is a web designer, how much for a web designer, how can you use web designer, designer job app, database web designer, create wed site, create php web app, code winners, bn. com, app designer job, animated web buttons, animated buttons web

Acerca do Empregador:
( 17 comentários ) United Kingdom

ID do Projeto: #2996303

Premiar a:

gsmsl

See private message.

$34 USD em 6 dias
(16 Avaliações)
2.7

2 freelancers estão ofertando em média $43 para este trabalho

kondenzator

See private message.

$51 USD in 6 dias
(13 Comentários)
4.6