Project Detail
data entry program
data entry program is project number 271994
posted at Freelancer.com. Click here to post your own project.
Status: Cancelled
Selected Providers: -
Budget: $30-250
Created: 06/08/2008 at 7:15 EDT
Bid Count: 43
Average Bid:
$ 161
08/07/2008 at 7:15 EDT
Project Creator:
dhruvidk
Employer Rating: 
(2 reviews)
Description
Program functionalityPurpose: to accept data input and produce formatted excel sheets.
Brief:
Were looking for a customizable program which is light on resources and can be run on windows. The purpose of the program is for a data entry operator to input select financial data into the respective fields and obtain a formatted output in excel (.xls) format. Key functions:
We need to be able to modify the fields. For instance, we should be able to tell the program which fields we want, say net income, operating expenses, etc. and modify them based on our requirements. The output format should not change.
Some fields will be calculated and some will be input directly. Sometimes a field such as a ratio is available either directly or we have to calculate it. We would like the program to be able to accept both, and automatically turn off the other field. For instance, if we enter net income margin directly, the fields used to calculate it should automatically turn off. FORMULA DEPENDENCY WILL HAVE TO BE ANALYZED PROPERLY
It should have the ability to translate currency by pressing a button. For instance, we should be able to tell it what the currency we are using is, and the currency exchange rates (either standard ones that we provide or specific ones for that file). Based on that, the output should get automatically changed to a language of our choice, with a default USD conversion.
It should have unit conversion. Numbers are usually in millions, thousands or mixed. It should have an option to select the unit for that sheet, and use the default throughout. However, we should be able to selectively change the unit for specific fields as well.
We should be able to add fields on a temporary basis. For instance, for all companies, the sheet should have certain specified metrics. However, sometimes we need to add a few metrics based on the specific conditions of a particular company.
I would also like to explore the possibility of having an internal QC reporting system within the program so the analyst can quickly read through and see what is right and what is not, flag details and so on.
The above are some key requirements of the model. The basic output format, etc. will be provided to shortlisted candidates. Please note that this is my first time hiring a programmer and my budget is very small. I once had an employee write a similar program in VBA (Excel 2003) in a short period of time so I dont think it will be too expensive.
In your bid, please provide the following details:
What language will you use for this and why is that the best option?
Your past experience with such models?
Timeframe for delivery?
Additional information submitted:
06/12/2008 at 8:28 EDT:
I'd like to thank you all for your helpful bids. Before i share further details with you, i'd like to add that i will take some time making a final decision so you needn't worry if i don't respond right away to your PMs.
The source of the data will be SEC filings http://sec.gov/edgar/searchedgar/companysearch.html. you could either go to this website and retrieve an html filing or ask me to send it to you. the idea is as follows:
1. we need to be able to define a certain number of financial metrics, such as revenue, net income, etc. for each industry. Within that industry, the metric names and numbers will not change. The output i will expect will be similar to the file attached. when a different industry is in question, we will need to be able to change the metric names and possibly values.
I'd like to be able to pick on a more qualitative basis amongst all of you. However, very few of you have actually made the effort to explain why i should pick you. it would help if you can look at the file and then explain your methodology (i'm not looking for code, but rather how the process that i want will work).
06/14/2008 at 5:06 EDT:
something to get the ideas flowing. I encourage you to use your own format- give me ideas on how i can improve the form style. this template is designed to give you an idea of how data entry will actually work.
Additional files submitted:
discussion_sample.xls
form specs.ppt
|
Job Type |
|
Provider Rating
WHAT IS FREELANCER.COM?
Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!
We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started!
Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.
- Plendo Sweden AB © 2004-2009
- PRIVACY POLICY
- TERMS
- AFFILIATES
- API
- QUOTES
- CONTACT
Freelancer™ is a trademark of Ignition Networks Pty Limited (ACN 134 845 748)
Newly Outsourced Projects fed by 
Follow our Freelance Jobs on Twitter 
Add to your
Google search results