Program functionality
Purpose: to accept data input and produce formatted excel sheets.
Brief:
We’re 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 don’t 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?
Can create a solution. There will be a single exe file. No needed 3rd party dlls or ocx registrations, No windows libraries. Just a single exe file to work with. Any GUI you want to use. High effeciently database driven language is used.
I do data base design in File Maker Pro. If you were to choose my services I would email you de file but you have to get the application, but believe me it is a very powerful application.
Sir,
I'm a part-time software developer (VB6 & VB.NET) working along my study. I've 6 year experience of VB programming. I think the program should not be any problem for me...
So,please pick me and let the professional do your job...
__________
Thank You
Dear sir/lady.
It's a pleasure for me to introduce myself to you. My Name is Leonel and I have experience doing this kind of projects, I was working for someone else in the past developing a variety of commercial applications, and his first rule was always, do the best to solve the customer needs. I think I would use Borland Delphi to develop your application, because it has a variety of tools to create and improve your application, as well as a powerful and customised environment, and that means, a powerful and customised application for you. The time required for develop, test and improve the application would be 15 days, that guarantees your total satisfaction.
Please feel free to contact me through this site.
Have a nice day.
Sincerely
Leonel López
This is, in fact, what I do every day. I am a programmer in the financial modeling division of a multi-national insurance company. I would use Excel VB for this sort of program because, based on your description, it seems like a spreadsheet with background code would be the most appropriate platform. I have created modeling software for my company and have extensive experience with exactly this type of programming. In terms of timeframe - I would need to see the final project specs but it looks like it could be done in 5 business days.
I am very good at VB programming. I am having 8 years of experience in VB programming. I would like to take up this project and my work product will be delivered with good quality.