Need Custom Excel Spreadsheet - New Software Features ROI

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.

Evner: Excel

Se mere: software sales salary, software engineers looking for a job, sales job opportunities, management job opportunities, looking for software engineers, excel opportunities, excel job opportunities, engineers looking for a job, custom list in excel, custom graphs in excel, create charts and graphs, cost of software engineers, cost of sales template, cost graphs, cost engineers, investment summary, new software, need help excel, cost spreadsheet template, salary software, roi, excel graphs, excel charts, excel calculation, customer spreadsheet

Om arbejdsgiveren:
( 0 bedømmelser ) United States

Projekt ID: #5990563

1 freelancer is bidding on average $75 for this job


Hired by the Employer

$75 USD in 15 dage
(35 bedømmelser)