Create a Database and Interface for Daily Excel Files

I get an ftp everyday with an excel spreadsheet. Each spreadsheet is identical except the date. There are 16 columns and 48 rows. Each column has a tree name (like Aspen, Cedar, Birch) and each row has a name (like cash, accrued). The columns are an identifier and the rows are a statistic (usually a dollar amount).

What I need: The creation of a database that automated to update each day that stores the information in a nice format. So, for example, I could output the cash for Aspen for all days that existed.

Furthermore, I would like a button interface. The first set of buttons, I could check the tree names I want. The second set of buttons I could select the row names I want (like cash or accrued). The third set of buttons, I could select the time frame (like 11/2/2014 to 11/20/2014). Then , the result would be generated graphs and statistics well as the data selected of all the 3 buttons.

I have a file I can show to serious workers on this. Not sure how much it should cost.

Thank you.

To clarify, the output and database that updates each day should contain ALL previous files. Like stacking matrices on top of each other and then pulling out slices of the cells.

Habilidades: Programação de Banco de Dados, Excel

Veja mais: what is database programming, what is an interface in programming, what are graphs for, tree update, tree graphs, programming graphs, i need workers for a day, graphs in c programming, graphs and data, excel data programming, excel c# programming, DOllar Tree, create graphs, cost graphs, a name, excel graphs, create a excel, aspen, data statistic, check data excel files, excel spreadsheet check check, excel column update, update daily, check excel files, create database multiple excel files

Acerca do Empregador:
( 3 comentários ) Portland, United States

ID do Projeto: #6789970

Concedido a:


This is a placeholder bid. I would require to see sample files (for couple of dates) and would gauge the exact complexity and might refine my bid (lower/higher) This is my current understand - every day you get exce Mais

$305 USD em 10 dias
(25 Comentários)

41 freelancers estão ofertando em média $415 para esse trabalho


Hi, my name is Sevinc. I am a 5-star excel and vba coding expert here. pls check my profile and feedbacks first to have some idea bout the quality of my previous works. I had many similar excel tasks, including those i Mais

$350 USD in 5 dias
(251 Comentários)

A proposal has not yet been provided

$350 USD in 10 dias
(260 Comentários)

Dear, I am Access/VBA expert since 11 years. I checked your project description, and I confirm I can develop your Access DB. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice

$331 USD in 10 dias
(56 Comentários)

Hello, This could be done adding a new tab in Excel's Ribbon, with a button to start the daily ftp operation and also drop-down lists and buttons to get the desired results (charts and/or data summaries). I need to Mais

$450 USD in 7 dias
(66 Comentários)

Hello there. I am an experienced freelancer and have done in the past projects similar to this. I have created business databases, with filters included to manage the data as your desires. I would like to talk to you t Mais

$400 USD in 5 dias
(83 Comentários)

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Mais

$250 USD in 10 dias
(135 Comentários)

Hey, I am an expert in creating databases and infact have recently completed a similar project (for sports data though). Here is what the client had to say for the work I delivered "awesome work. great communication wi Mais

$388 USD in 7 dias
(94 Comentários)

Can you please show your sample files. I am an Excel expert and can create an easy-to-use template for you. Thanks.

$333 USD in 5 dias
(126 Comentários)

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 215 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive Mais

$400 USD in 10 dias
(115 Comentários)

Hello, I can do this project accurately. I've done similar projects in my full-time work. If you want I can introduce the work done (I need the file), without any obligation to choose my offer. Thank you very Mais

$300 USD in 3 dias
(61 Comentários)

Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have bee Mais

$400 USD in 4 dias
(21 Comentários)

Dear we have a team of 12 people that can handle your [login to view URL] have done many projects..we will follow according to your [login to view URL] only after the [login to view URL] will give you best result with limited [login to view URL] Mais

$315 USD in 5 dias
(23 Comentários)

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 Mais

$500 USD in 7 dias
(42 Comentários)

I can solve this in Excel. See my profile and contact me if you are interested. Thanks, Tom__________________________________________________________________

$500 USD in 10 dias
(34 Comentários)

Hello, I hope all is well. I will admit that I'm a little biased in my preference of Excel vs. Access (or DBs) as I have found that a vast majority of users feel more comfortable working in and updating Excel. My Mais

$275 USD in 3 dias
(70 Comentários)

Hi, My name is Dan. I am an expert in excel and all advanced functionalities. I guess I have understood your requirement precisely. The best thing to do will be to import the file that you received into an excel dat Mais

$300 USD in 3 dias
(11 Comentários)

Hi, I'm VBA developer and understood your requirements Please share excel workbook and more details to start work Thanks

$500 USD in 10 dias
(10 Comentários)

Hi, I have gone through your requirements, I am a Database Programmer at CMMI-5 Level company since August 2004.I am working on MS Access, Shell Script,PL/SQL,T-SQL,MySql,MSSQL Server,Oracle database, I can do your job Mais

$530 USD in 10 dias
(13 Comentários)

Hi I can assure you that i am having the best excel experience and i can do almost everything possible with excel. Please check my review in IF you need see some samples of my work, then, pleas Mais

$684 USD in 10 dias
(8 Comentários)

A proposal has not yet been provided

$555 USD in 10 dias
(1 Comentário)