WHAT IT NEEDS TO DO
I would like a Visual Basic program that does the same calculations as the Excel spreadsheet I have attached with a few modifications.
I need to be able to enter:
% Coverted to sales
Daily PPC budget
The Output should show:
Cost Per Click
# Click throughs
Monthly CostMonthly Clickthroughs
# of Sales
Note that there is no COGS (Cost Of Goods Sold) entered like the spreadsheet so the calculations will need to be changed to address that.
Instead of a hard coded Cost Per Click I want to be able to enter a min, max and step value. Min and max would be the least and most values to pay per click and the step would be the price to increment and should be four places (from 00.01 to 99.99).
Need the ability to export the calculation to a CSV (comma separated) file so it can be imported in to Excel.
Negative number should be red with a negative sign before them, not in brackets like the spreadsheet is doing.
No directions at the bottom like the spreadsheet has. The directions will go in the "Help" pull down menu (see below)
HOW IT NEEDS TO LOOK
+ If possible, I would like no installer, just an exe file that runs on Windows 2000/XP/Vista.
+ I would like to enter the info on the top half of a screen and have the calculations on the bottom half.
+ The info should be entered on the top left side of the screen and our website URL will go on the top right part of the screen.(URL will be provided to the winning bidder)
+ The screen should be a standard Windows screen that is resizable, minimize and exit.
+ If the calculations are more rows than the bottom half of the screen will fit, there should be a right hand scroll bar for the bottom half.
+ There should be the following pull down menus & options
+ An "Export" option to export the calculations to CSV (comma separated). This should popup a window to choose where to save the CSV file.
+ An "Exit" option to exit the program
+ A "Help" option that will give a brief overview of the software. (I will provide this after I see the software so I can write something up and you can paste it into the Software.
+ An "About" option that will have our website URL. (I will provide this)
Please let me know what version of VB you will be using when you bid.
Will need an executable to test before payment. Once payment is made, source code and ownership will be transferred to us.
Please ask me any questions if I have left something out or not been clear on anything.