Need Custom Excel Spreadsheet - New Software Features ROI - open to bidding
$30-250 USD
In Bearbeitung
Veröffentlicht vor fast 10 Jahren
$30-250 USD
Bezahlt bei Lieferung
I need a custom Excel spreadsheet for job cost management.
Basically, I need it to do the following:
1. On the first tab, have a reports list with charts stating profits/losses, etc, by software feature that graphs the amount of work to complete the feature as well as a return on investment calculation that is based on the number of sales opportunities that could use this feature to help close the deal.
2. Needs to have summary by software feature on the first page as well (only total profit or loss)
3. On the inner pages, I need to be enter the software feature title, the estimated final price of the project, i.e. number of engineers, salary, and hours to complete. These features need to be able to be tracked individually and referenced to various sales opportunities. Additionally, i need a tab that allows me to enter sales opportunities and multiple features that are requirement to help secure the deal.
4. Each tab should be a different project. However a single tab is needed to list all of the sales opportunites. This Opportunity tab should read Customer Name, Model Number, QTY, Revenue, SFDC #, Close Date, iDate, FEATURES Required
5. Projects (tabs) should automatically be in alphabetical order
6. Each time I create a new tab, the default template needs to be there.
I'm looking to spend $75.
Dear Sir
This project seems interesting and doable based on my past experience with this type of problem.
THE SOLUTION:
============
I have read the project description and understood the requirements. In fact I have concluded in the past a very SIMILAR project. 50 % is DONE. I can use some of the routines to this project.
I can present you with a FREE SAMPLE. Just send me a message with relevant files so that I can START WORKING.
Thanks.
ABOUT TABLASSUS SOFTWARE:
==========================
I've been working on this kind of work on the past 8 years (handling complex data in excel files). In my actual work I deal with complex data structures (using excel) so achieving your goal shouldn't be a problem.
I have +20 years of programming experience being highly skilled in Visual Basic (VB or VBA for applications).
I have a daily job on a worldwide well know corporation (Bureau Veritas) as programmer / consultant. I also teach Physics, Math and chemistry.
I also excel at Math, Statistics and genetic algorithms applied to computation.
I have Skype / MSN in case you need to schedule up a meeting. I have excellent communications skills / english language background.
Even so, it seems a very nice and challeging project.
Feel free to ask for more details / information
Looking forward to hear from you and start this interesting project.
Best regards
Filipe Francisco , VB Expert
==============================
Tablassus Software
"Simple solutions for complex problems"
$66 USD in 1 Tag
5,0 (13 Bewertungen)
4,6
4,6
8 Freelancer bieten im Durchschnitt $102 USD für diesen Auftrag
Hi, I'll be happy to help you with this project. I have experience in both job costing concepts and Microsoft Excel
Please feel free to message me if you need to discuss any questions you might have prior to award
Hi there. I am ready to kick off with the project. I have done a few very similar projects in Excel before and I can design a profit/loss sheet as required. Kindly discuss.
Regards.
Usman.
Hello
I'm a software engineer with good knowledge in excel macro.
I can help you to do your job.
please contact me for future details.
best regards
hossein
Hello, my name is Cristian, I have a degree in Business and I am Financial Advisor. Besides working with excel every day, and I have a lot of experience creating complex formulas and spredsheets that allow me to obtain the information needed for better decision making. Greetings.
Hi there,
I've been working with Excel since before '98 and I've been using all possible versions of it.
I have many years of experience working with macros and writing code / debugging Excel VBA code.
You may check my portfolio images to see few pieces of my kind of work.
(This is what I do on daily basis).
I am a professional and I can do a very good job. Also fast and accurate.
Kind Regards,
Jon
Experienced software professional with 20 years in design, development and maintenance of applications.
Based on my experience, Excel will not be able to take the load and maintenance will become a problem for you.
If you are the only person who will be maintaining the data, then the best option will be is to create an Access Database with Forms for data capturing and reports. If you need the reports to be circulated as Excel files, that can be done but will take some effort to get them formatted automatically.
I have several years experience building Excel spreadsheets using complex formulas and built-in tools such as Pivot Tables.I have earned a Masters in Finance and have built many ROI templates. I would be happy to discuss this project further with you. Please contact me through Freelancer and we will get your project completed.
Thanks
Chuck