create formulas to get the right dwelling, sep, personal, loss and premium2 from using sqft.
I buy mailing list that come in an excel format. They give me the name, address and square footage of the home. I will need formulas to fill out the dwelling, seperate structures, personal property, loss of use and premium.
dwelling will equal square footage (sqft) * 135
Separate Structures(sep) will equal 10% of dwelling
personal property(personal) will equal 70% of dwelling
loss of use(loss) will equal 40% of dwelling.
the premium(premium2) formula is the hard one. As your dwelling amount goes up the price per insurance dollar goes down so I will need options on this formula.
below 750 sqft premium2 = sqft * .58
below 950 sqft premium2 = sqft * .52
below 1100 sq ft premium2 = sqft * .47
below 1300 = * .44
below 1500 = * .42
below 1850 = * .39
below 2200 = * .37
below 2600 = * .36
below 3000 = * .35
below 3350 = * .34
below 3700 = * .33
below 4000 = * .32
over 4000 = * .31
I attached a short sample mailing list. Instead of 10 there will be over a 1000. I also attached the letter that will be mailed out. I'll need the formulas to send to the company that prints, stuffs and mails them for me. Please let me know if you have any questions.
Thanks for your help.