Excel formulas made for mailer list

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.

Jim Hubbard

Habilidades: Excel

Veja mais: thanks letter sample, price list excel formula, buy a mailing list, excel help formula, need help to seperate, Excel Formulas, excel format formula, excel 2010 create list, excel format price list, excel short list, address excel format, excel macro create spreadsheet template list data, excel macro create spreadsheets list, excel macro create multiple spreadsheets list, questions formula, need 1500 dollar, format price list excel format, letter company property, 1500 excel, format price list excel, 1000 list excel, excel separate address, dwelling, fill mailing address, create list domain names excel

Acerca do Empregador:
( 0 comentários ) United States

ID do Projeto: #6827706

1 freelancer is bidding on average $8 for this job


Hired by the Employer

$8 USD / hora
(481 Comentários)