We are seeking a skilled developer to create an Impact-Centric ROI Calculator that will accompany our sales training module. The calculator must be designed to have perfect utility across all Business-to-Business (B2B) sales environments, including products, services, hardware, and software (SaaS) sales.
Key Requirements:
Currency Options: The calculator must support three currency options – USD, British Pound Sterling, and Euro. Workbook Structure: The workbook should be organized into five main tabs: Home, Input, Calculations, Output, and Instructions. Home Tab: Create an introductory screen with a purpose statement and basic navigation instructions. Input Tab: Divide the tab into 'Cost Investment' and 'Gains from Investment' sections, each with relevant categories. Include a Rule of Thirds attribution section and a timeframe selection option. Data Validation: Implement data validation to ensure data integrity and minimize user input errors. Calculations Tab: Use Excel formulas to calculate key metrics such as ROI Percentage, Payback Period, and Break-even Point based on the selected timeframe. Include a Rule of Thirds attribution calculation. Output Tab: Display the calculated results in a user-friendly format, incorporating dynamic charts and graphs for visual representation. Instructions Tab: Provide step-by-step instructions on using the calculator, including timeframe selection and interpretation of key metrics. User Guide: Create a separate worksheet named "User Guide" that includes an introduction, overview of each worksheet's purpose, step-by-step instructions, guidance on timeframe selection, and explanation of key metrics. Testing: Ensure the calculator's utility across various B2B sales scenarios, including producers/manufacturers, resellers and distributors, professional service providers, and subscription software providers (SaaS). The ideal candidate should have strong experience in developing complex Excel workbooks, proficiency in Excel formulas and functions, and a deep understanding of data validation and user experience design. If you are interested in this project and possess the required skills, please submit your proposal, along with a portfolio showcasing relevant experience.