### Pasting a census from a spreadsheet

The `Census | Paste census data` command fills the census with data from the clipboard. Any cells that were already there are deleted.

Usually you get the data from a spreadsheet, but you can copy plain text from anywhere. The columns must be separated by tab characters; most spreadsheets take care of that automatically. The first row contains headers that tell what each column means. The other rows give the values for each column. Each row must have the same number of columns. No entry can be blank. Check your input carefully, because errors are not detected when you paste it.

For example, here is a census you can copy and paste:

    Gender	UnderwritingClass	IssueAge	Payment	DeathBenefitOption

    Female	Preferred	30	sevenpay,7;0	b,7;a
    Male	Preferred	35	sevenpay,7;0	b,7;a
    Female	Standard	40	sevenpay,7;0	b,7;a
    Male	Standard	45	sevenpay,7;0	b,7;a
    Female	Preferred	50	sevenpay,7;0	b,7;a
    Male	Preferred	55	sevenpay,7;0	b,7;a
    Female	Standard	60	sevenpay,7;0	b,7;a

You can use these column headers:

`InsuredName` |  | Full name of insured
`EmployeeClass` |  | Any distinct phrases, like `Owners`, `Managers`, and `All others`
`Gender` |  | `{Male, Female, Unisex}`
`UnderwritingClass` |  | `{Preferred, Standard, Ultra, Rated}`
`Smoking` |  | `{Smoker, Nonsmoker, Unismoke}`
`IssueAge` |  | Insurance age at issue
`RetirementAge` |  | Insurance age at retirement
`State` |  | Two-letter postal abbreviation
`WaiverOfPremiumBenefit` |  | `{Yes, No}`
`AccidentalDeathBenefit` |  | `{Yes, No}`
`DeathBenefitOption` |  | sequence: `{a, b, rop}`
`SpecifiedAmount` |  | sequence: number, or `{maximum, target, sevenpay, glp, gsp, corridor, salary}`
`Payment` |  | Employee payment sequence: number, or `{minimum, target, sevenpay, glp, gsp, corridor, table}`
`PaymentMode` |  | Employee payment mode sequence: `{annual, semiannual, quarterly, monthly}`
`CorporationPayment` |  | Corporation payment sequence: number, or `{minimum, target, sevenpay, glp, gsp, corridor, table}`
`CorporationPaymentMode` |  | Corporation payment mode sequence: `{annual, semiannual, quarterly, monthly}`

Copyright © 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014 Gregory W. Chicares. This program, including its documentation, is free software. Read the terms under which you can redistribute and modify it.

Maintained by Gregory W. Chicares. The latest version of this file can be found at the `lmi` website.