I need to create a database from a monthly excel file. Input Information - I have a monthly report that has fixed columns of data. This rows in the report are accounts. The columns represent information about each account. Some columns do not contain information I care about, and could be ignored. There are approximately 5 years of data I would need to import when the DB is set up. The files are text files, but come into MSFT Excel easily (comma delimited). Output or Visualization - I need to be able to look at the data in two ways. First is to look at each account, and track changes in the values. The values will have single event changes (i.e. they do not change month to month). Changes themselves are the events I want to be able to find. Also, I need to be able to look at a column (i.e. a specific data point) to search for changes over time to those fields. I do not own MSFT Access, but could purchase for this project. This is a personal project, so I have a budget.
ADDED - I do not expect this to be "answered" for $38. I would like to find someone who could bid building the DB for me, in a way where I could slurp in the new monthly files as they come. Thanks.
Do I really need to pay $38 for this answer?
You dont have to pay anything but dont you think it might have saved you a lot of time and trouble ?
We are expressly not allowed to negotiate prices here. We generally just answer questions and tell you how to do a job. Some of us will do a small job if they feel the price is right. I dont know that anybody here would do a complete project for you but they might if you posted enough money.
We get paid half of what you offer. The site that i posted has alot more people that do the programming jobs and will bid them for you. That site takes a much smaller commission. You would get a lot more bang for your buck with a lot more people to possibly bid on it.
To me that would seem to be worth something to you. I have friends that have used it succesfully as both buyers and sellers.
If you prefer a refund you can [email protected]
I guess here is my point.
To pay you to say "you cannot bid a job here" is not really worth (or even appropriate for you to ask for) a fee. IMHO anyway. I have used justanswer a few times and always paid an appropriate amount for an answer that helped me.
So I'd say this - if you want to have "earned" the $38, you could answer a general question of "how to do" what I'm looking for. For example. Can I import monthly data sets, and populate a dashboard for each account? Can I search the years of data to find specific events (that are well defined)? Can this all be done in Excel? Do I need a database tool? If so, what one should I buy?
Answers to these won't tell me specifically how to do it, but they will get me pointed (as was you suggesting freelancer.com). Also, a referral would be good, but my budget is limited.