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.