We are looking for someone to correct or rebuild a Excel file, see attachment; "Green Beans ROI Sample" that must calculate numbers, see "ROI Layout" attachment. This is what i want the end product to resemble after your creative input as a Excel file when completed, But “Important” it needs to be able to export out as a PDF that firmly fits onto a 8 1/2" x 11" sheet of paper with no cell boxes lines showing.
Below is explanation for "ROI Layout" with references in "red" pointing to fields needing active.
(A) This is where we will type, size/price of our product, or it can be radius buttons that activate a size/price in the box, (A) There are 10 product sizes.
3/4"= $600, 1 inch = $1,500, 1 ½ inch = $2,200, 2 inch = $3,750, 3 inch = $6,200, 4 inch = $8,500, 6 inch = $12,000, 8 inch = $16,000, 10 inch = $22,000, 12 inch = $23,500 the prices are what's going be calculated like (C) and (D) rows from "A" for example; (A) we put 3/4 = $600,
(C) and (D) we will type manually our clients monthly and yearly water bill cost which will calculate across the row at 10% to 40% savings, see attachment; "Green Beans ROI Sample"
(E) Sewer yearly/monthly billing row section is to calculate out from 10% to 40% saving, which it not doing NOW "Working" see attachment; "Green Beans ROI Sample" now, of course all will start out as # "0" zero.
C, D, E, F is to work from "A" as # dollar numbers across the row.
(F) is a add up total of C, D, E rows
(G) is to represent how many months it will take the client to pay off the product "Return On Investment" for example, if (A) is, 1" valve costing $1,500 it calculate and divide it up (F) all across the row. Example circled in green "ROI Layout" shows total saving at 10%, is $260 per year for C, D, E, divide that by $1,500 = 5.7 months to pay our product off (G) must represent this calculation across the row.
(B) must be centered copy in the 8 1/5 x 11" sheet, which we could edit and add or take out copy , but not much more copy than what you see.
(A) "Row field" you may have to invent how it work and effects (G) row after C, D, E, F, which will establish manually.