Data Entry into Excel with formulas and tables to help find patterns
$250-750 AUD
Paid on delivery
This started out as a small personal fun project but I am lacking into Excel expertise. Had too many exciting ideas and now what I want out of it I dont know how to finish it.
Essentially what I want is for someone to input data which is a 4 digit number (1234) into an excel spread sheet and calculate the amount off times a number is odd/even, or big/small(0-9).
There's 14 years of data which is approximately 250 numbers per year.
[url removed, login to view]
This website houses the numbers so if you can copy and paste you might not even have to manually put the data in. The data for each year must be seperated into the 5 different days/columns as you see it on the website.
I want each digit in each number to be treated as if its on its own. For example 1234, 1 is small and odd, 2 is small and odd etc etc. Ive added my Excel sheet that i started with a template of what I want in the Monday 14 Tab. This is an examply only and if you cn come up with a better way then go for it.
Data for this current year 2014 is ongoing so needs room to input more date and update as it goes along. But also would need to be easily compared to past results. Also blank templates for 2015 and future years.
Also would be great to be able to draw a data table to easily see any patterns that come up similar to the casino game of Baccarat (Pictured in excel sheet)
As you can tell I'm trying to beat the lottery :) This is just a fun little personal project so if someone can work with me and ask as many questions and also make it nice to look at.
I think the data entry and simple calculations side is easy. Just coming up with the overall design layout so that its easy to read may take some time. And the baccarat style table Im not sure if its even possible in excel.
Nothing is set in concrete and happy to hear ideas and answer any questions to clear anything up
Project ID: #6196581
About the project
12 freelancers are bidding on average $289 for this job
Hi, I'll be happy to help you with this project as I have plenty of experience in generating combinations and iterations in Excel Please feel free to message me if you need to discuss any questions
hi, i am expert in web scraping and interested in this project, let me do this work with perfection, accuracy and according to your requirements, plz contact with me so we can discuss further about the project and plz More
Sir, I read you project and fully understand after bidding on this project, my bid promises 100% satisfaction at the end of the project. I am expert of Microsoft Office, Excel, Word, Web Search, Web Scraping, Data En More
as this project you are saying is long and want some additional ideas to make it work for future. i want to add my knowledge to this project because it also seems to be promising for future project from your side.
hello, i can help you complete this work. I have written various scripts that does such sort of works in a daily basis in my current company and i can easily write a script that can perform the work you desire with 0% More
Hello my friend, I can help you with your project and I'm available to start working right now. Please feel free to contact me at any time. Thanks in advance for your consideration and best regards
WHAT FUN! INTERESTING PROJECT THAT I WOULD LOVE TO WORK ON WITH YOU! From what I understand, you want the 4 digit number of winning tickets (14 years worth = 3500 numbers) entered into Excel. The way these numbers More
I'm pretty new to freelancer and would love the opportunity to work on this project with you. I have done a lot of data comparison and have done some similar work for past lottery odds. I'll make sure you get exactly w More
Hi Sir, I can convert the data into your excel files. BTW, I am a good programmer, I can do anything you want for the data formation. Now I understand each day have five digits out, but I don't know what is the m More
