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:
( 4 arvostelua ) Cabramatta, Australia

Projektin tunnus: #6196403

Myönnetty käyttäjälle:


Hi I think I can help you with finishing off the project and I have put a quick sample together of what I think you may be looking for. The data is based on the first 11 weeks of the 2010 data with some charts sh Lisää

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

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


Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have done lots of these kind of projects and will deliver flawless work Looking for further discussions in this reg Lisää

$422 AUD 5 päivässä
(231 arvostelua)

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ä
(90 arvostelua)

A proposal has not yet been provided

$555 AUD 30 päivässä
(15 arvostelua)

Hello. I've found you project very interesting and I love numbers too so let's discuss about details. Wait for your response. Best regards

$250 AUD 30 päivässä
(22 arvostelua)

Hi there! My name is Conrad Gillard and I would like to help you with your pattern recognition project. I have extensive experience with VBA programming to process data, and I am confident that I can develop the sp Lisää

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

Our team of skilled professionals are highly experienced and have many years’ worth of experience in their field. We offer complete solutions for websites, company branding, marketing and much more: Web Design: We h Lisää

$515 AUD 10 päivässä
(2 arvostelua)

10+ years of experience proving expert Excel Consultant services to business. It is our mission to provide clients with a wide range of Microsoft Excel and Access services like no other, to surpass all expectations an Lisää

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

A proposal has not yet been provided

$555 AUD 30 päivässä
(0 arvostelua)

A proposal has not yet been provided

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

I'm a Microsoft MVP (Most Valuable Professional). Highly specialized in Excel and Excel VBA. I have 20 years of Excel development experience. My Excel shareware products have received 5-star ratings from PC Magazine, P Lisää

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