Data Entry into Excel with formulas and tables to help find patterns

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

Taidot: kaikki käy, tiedonsyöttö, tiedonlouhinta, tietojenkäsittely, Excel

Näytä lisää: what is the data entry work, what is date entry, want excel spread sheet, template website answer sheet, table on how to design website, small houses design, room design layout, make a spread sheet, lottery website design template, html spread sheet, how to know how i work with formulas on excel, how to draw anything you want, how to design a room, how can i make data entry, help find , game design website templates, game design patterns, fun with excel, find website help design room, draw anything you want

Tietoa työnantajasta:
( 0 arvostelua ) Nucet, Romania

Projektin tunnus: #6196581

12 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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

$250 AUD 2 päivässä
(98 arvostelua)

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 Lisää

$250 AUD 10 päivässä
(74 arvostelua)

Hi I have seen your job post regarding data entry and I am interested in your project. As a bachelor in engineering and having almost 3 years of working experience, I think you will find the skills I have you are lo Lisää

$270 AUD 10 päivässä
(1 arvostelu)

Hi!! This is Ms.Farhana. I read your job details step by step and also see the attach [login to view URL] instruction is very clear. I can do this with in 100% accurately. Please sir give me a chance to do this work.I Lisää

$277 AUD 10 päivässä
(3 arvostelua)

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 Lisää

$500 AUD 10 päivässä
(1 arvostelu)

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.

$250 AUD 5 päivässä
(0 arvostelua)

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% Lisää

$333 AUD 10 päivässä
(0 arvostelua)

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

$250 AUD 5 päivässä
(0 arvostelua)

1) Data Can be updated 2) We can have a display of digits of the number(ascending order/descending order) when you click the excel box 3) We can have which is the largest and smallest number in a particular year We Lisää

$272 AUD 10 päivässä
(0 arvostelua)

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 Lisää

$250 AUD 10 päivässä
(0 arvostelua)

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 Lisää

$333 AUD 4 päivässä
(0 arvostelua)

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 Lisää

$250 AUD 7 päivässä
(0 arvostelua)

. . .

$250 AUD 3 päivässä
(0 arvostelua)