2 Dashboards + SQL Server + Shiny + R + Python
Budget: $30 – $250 USD
2 Dashboards + SQL Server + Shiny + R + Python
Requirements
1 dashboard in R + Shiny
1 dashboard in Python
You will send a zip with README.txt that includes instructions. Setup only. No other docs requires.
zip will include code
2 tabs in chrome browser
Tab 1: Shiny + R dashboard
Tab 2: Python dashboard
Exact same Roulette simulation in both R and Python
2 Chrome tabs
Roulette simulation - Red/Black
Radio Button:
- 0
- 0 and 00
These are the green spaces on a roulette wheel.
Simulation must save results in SQL Server tables.
Tables:
Simulation
SimulationID
Number Char(2) so it can save 1-36 0 and 00
Red Bit
WinAmount Int (+ when red, - when black)
Bankroll
Use standard red black numbers where 0 and 00 are green.
Red: 1,3,5…12,14…23,25… see the image below
Black: 2,4,6…17,20…29…
https://images.app.goo.gl/MdMWwQytN4Vqio929
Simulation dashboard must work with radio button:
-0
-0 and 00
Inputs for R+Shiny and Python dashboards:
Starting bankroll:
Default to 2,000
Starting bet:
Default to 5
When lose, double your bet.
Round 1 start at $5
5 L
10 L
20 L
40 L
80 W
When won 80, profited 5 total
Now bankroll is 2005
Now start again at 5.
This will be called Round 2
Save the results at each step.
Also save the results of the total simulation including outputs
Simulation SQL Server Table
SimulationID INT
(Inputs)
StartingBet INT
BankrollStart INT
BankrollEnd INT
Simulations INT
SimulationsBust INT = start at 1… when your bankroll = 0 because you busted out, save it here.
CreatedDate DateTime
Simulations need to include charts or graphs that shows the bankroll going up, then down, then up…
When bankroll is 0, stop the simulation and run the next.
After 25 simulations stop. Simulations text box defaulted to 25.
After 10 rounds, stop. Input: Rounds text box defaulted to 10
You should have 25 records in the simulations table. Bankroll restarts at 2,000 and minute bet resets to 5 for each simulation.
Inputs are exactly the same on both Chrome tabs.
Must use a good random number generator.
Generate numbers -1 through 36
-1 == 00
0 == 0
1-36 = #
Simulations should prove that a wheel with 0 and 00 will go bust = faster. Wheel with only 0 (European roulette) should last longer before busting out = bankroll of 0.
Bet size cannot exceed bankroll. The last spin should be all in.
Only start simulations when inputs are correct (no letters in input fields) … and user clicks on [Start Simulation] in chrome tabs.
Budget $100 per tab = $200
Milestones will not be released until code is tested and working correctly.
Requirements
1 dashboard in R + Shiny
1 dashboard in Python
You will send a zip with README.txt that includes instructions. Setup only. No other docs requires.
zip will include code
2 tabs in chrome browser
Tab 1: Shiny + R dashboard
Tab 2: Python dashboard
Exact same Roulette simulation in both R and Python
2 Chrome tabs
Roulette simulation - Red/Black
Radio Button:
- 0
- 0 and 00
These are the green spaces on a roulette wheel.
Simulation must save results in SQL Server tables.
Tables:
Simulation
SimulationID
Number Char(2) so it can save 1-36 0 and 00
Red Bit
WinAmount Int (+ when red, - when black)
Bankroll
Use standard red black numbers where 0 and 00 are green.
Red: 1,3,5…12,14…23,25… see the image below
Black: 2,4,6…17,20…29…
https://images.app.goo.gl/MdMWwQytN4Vqio929
Simulation dashboard must work with radio button:
-0
-0 and 00
Inputs for R+Shiny and Python dashboards:
Starting bankroll:
Default to 2,000
Starting bet:
Default to 5
When lose, double your bet.
Round 1 start at $5
5 L
10 L
20 L
40 L
80 W
When won 80, profited 5 total
Now bankroll is 2005
Now start again at 5.
This will be called Round 2
Save the results at each step.
Also save the results of the total simulation including outputs
Simulation SQL Server Table
SimulationID INT
(Inputs)
StartingBet INT
BankrollStart INT
BankrollEnd INT
Simulations INT
SimulationsBust INT = start at 1… when your bankroll = 0 because you busted out, save it here.
CreatedDate DateTime
Simulations need to include charts or graphs that shows the bankroll going up, then down, then up…
When bankroll is 0, stop the simulation and run the next.
After 25 simulations stop. Simulations text box defaulted to 25.
After 10 rounds, stop. Input: Rounds text box defaulted to 10
You should have 25 records in the simulations table. Bankroll restarts at 2,000 and minute bet resets to 5 for each simulation.
Inputs are exactly the same on both Chrome tabs.
Must use a good random number generator.
Generate numbers -1 through 36
-1 == 00
0 == 0
1-36 = #
Simulations should prove that a wheel with 0 and 00 will go bust = faster. Wheel with only 0 (European roulette) should last longer before busting out = bankroll of 0.
Bet size cannot exceed bankroll. The last spin should be all in.
Only start simulations when inputs are correct (no letters in input fields) … and user clicks on [Start Simulation] in chrome tabs.
Budget $100 per tab = $200
Milestones will not be released until code is tested and working correctly.