spreadsheet help needed - OpenOffice Calc

spreadsheet help needed - OpenOffice Calc I need a spreadsheet created that is in the same format of the attached example PDF. It is for email marketing campaign performance. The winner of this project should be a spreadsheet pro and act as my mentor in describing the formulas needed for the cells. - Please note that I only use OpenOffice Calc or Google docs. I cannot use a function that only works in MS Excel. - Please note that I would like a spreadsheet for dates starting from the 1st of Jan. until the end of Feb. Functions need in the spreadsheet. - I will enter in the value in the Sent column. - the Del and Del% columns should be ignored - We should add a column called OPN. I will insert the values here. This refers to number of emails opened. - the next column OPN% should refer to the percent of the SENT column to the OPN column. For example, we send 100 emails, 10 people open them, that is 10% - We should insert a CLK column. I will insert values here. It should be the number of click-thrus on an email - The CLK% column should be the percent of the OPN column to the CLK column. For example, 10 people open the emails, 5 clicked, that is 50% - The CNV% column should be calculated based on the total orders column to the CLK column. In the PDF the total orders column is shown as #. I would enter in the total orders number. An example for this calculation is 5 people click, and 2 people placed an order. The result in this column should be 40%. - Let's remove the $/Del column - The AOV column should be based on the total dollars column, displayed in the PDF as $, which I would input, and it should be based on the number of orders. So if we have 2 total orders, and a total dollar amount of $30, then AOV (Average Order Value) column should be $15. - Lastly, Weekly totals and monthly totals need to be calculated. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables): a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform OpenOffice Calc