Em Andamento

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 displayed...as 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.

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

Ver mais: tree update, tree graphs, programming graphs, need workers day, graphs programming, graphs data, excel data programming, dollar tree, create graphs, cost graphs, a name, excel graphs, create excel, aspen, data statistic, check data excel files, excel column update, update daily, check excel files, spreadsheet graphs, excel database update, database selected row, excel database format, programming statistics, graphs creation

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

ID do Projeto: #6789970

Premiar a:

Premshanks

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
(54 Avaliações)
4.7

44 freelancers estão ofertando em média $422 para este trabalho

seaanddream

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
(108 Comentários)
6.5
best4best

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
(86 Comentários)
5.5
dpune

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
(45 Comentários)
5.5
chriskerpini

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
(28 Comentários)
5.4
sonarkaushik

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
(34 Comentários)
5.4
wsh2

statsphd writes: "I have a file I can show" Although I have a very good idea of what you require, it would be of great benefit to see what you envision. At your earliest convenience, please attach what you have so f Mais

$555 USD in 10 dias
(16 Comentários)
5.3
shikhamehta

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
(52 Comentários)
5.2
carivera

Hello dear contractor, I've done similar app for a local call center, I have the skill, the experience and the will to work on this project. I can build you a very user-friendly interface to manage the filter fea Mais

$444 USD in 3 dias
(22 Comentários)
5.2
kher78

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
(56 Comentários)
5.1
bizwizz

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
(6 Comentários)
4.6
mkhrsunil

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
(9 Comentários)
4.4
tomislav1975

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

$500 USD in 10 dias
(17 Comentários)
4.4
muzammil21

Dear we have a team of 12 people that can handle your task.we have done many projects..we will follow according to your instruction.pay only after the result.we will give you best result with limited time.comp Mais

$315 USD in 5 dias
(10 Comentários)
4.3
paris2785

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
(28 Comentários)
4.3
dank111

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
(9 Comentários)
4.2
fabest

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
(7 Comentários)
4.1
DanielVizcaya91

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
(6 Comentários)
3.8
P0L

A proposal has not yet been provided

$350 USD in 10 dias
(13 Comentários)
3.7
acronymsolutions

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
(8 Comentários)
3.7
ayanbishnu

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 freelancer.com IF you need see some samples of my work, then, pleas Mais

$684 USD in 10 dias
(6 Comentários)
3.4