\p Robert White B8= hZL,8= hZL,> 8= hZL,> """  d_FGIHJKL/9NO"@ExampleCensus 4Example     cB  d_"*+%1 Arial1 Arial1 Arial1 Arial1lTimes New Romanew Roman`?2\b0Db0be0Fb1 Arial&C&F:&A &Cp &P of &N&?'?(?)?M d,"d,??@V General00.00#,##0 #,##0.00#,##0_);\(#,##0\)#,##0_);[Red]\(#,##0\)#,##0.00_);\(#,##0.00\)#,##0.00_);[Red]\(#,##0.00\)"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)0%0.00% 0.00E+00 #\ ?/? #\ ??/?? m/d/yy d\-mmm\-yy d\-mmm mmm\-yy h:mm\ AM/PMh:mm:ss\ AM/PMh:mm h:mm:ss m/d/yy\ h:mm ##0.0E+0mm:ss@52_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),)_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)41_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)C C  C  C  C  C C C C C C C C C C C  C ! C  C  C  C  C  C  C "pC "pC  C #0ǓU} } I}  } I }  } } }  } } m } m2   0 = `L dn C G mb [  $  e  }  t q q q q q q q q q q q q qb q T TT T Field Data Type DescriptionMedical Text91Y/Yes=Medical Coverage, N/No= No Medical CoverageSingle Text>6S = Employee Only, F = Employee + 1 or more dependents DOB Text Date of Birth MM/DD/YYYY Sex Text$Gender, M = Male, F = FemaleSalaryIntegerD<Annual salary in thousands of dollars (ie 20 = $20,000/year) LifeInteger4,Life Coverage Amount in Thousands of Dollars Example Census Worksheet  A B C D E F G~ ? MEDICAL  SINGLE or  SEX or ANNUAL STD ~ @ BENEFIT FAMILY DOB GENDER SALARY (x1000)  LIFE (x1000) ~ @ Y S  03/15/1904 F~ .@~ I@ ~ @ Y S 10/15/1908 F~ >@~ I@~ @ Y F 04/15/1909 F~ <@~ I@~ @ Y S 08/15/1910 M~ F@~ 4@~ @ N F 03/15/1911 F~ I@~ 4@~  @ Y S 10/15/1911 M~ @P@~ 4@~ "@ Y S 02/15/1915 F~ 4@~ I@~ $@ N S 12/15/1915 F~ 9@~ I@~ &@ Y F 03/15/1916 M~ 7@~ I@~ (@ Y F 04/15/1916 F~ >@~ 4@~ *@ Y S 10/15/1917 F~ @@~ 4@~ ,@ Y S 12/15/1918 F~ @@~ I@~ .@ Y S 03/15/1919 F~ ?@~ 4@~ 0@ Y S 01/15/1921 M~ D@~ I@~ 1@~ 2@~ 3@RJIf employee does not require medical coverage, indicate with 'N' or simply 4 ,exclude from census and footnote accordingly;= hZL,> """" Census  jp$B  d_"*+%1 Arial1 Arial1 Arial1 Arial&?'?(?)?"??an@V General00.00#,##0 #,##0.00#,##0_);\(#,##0\)#,##0_);[Red]\(#,##0\)#,##0.00_);\(#,##0.00\)#,##0.00_);[Red]\(#,##0.00\)"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)0%0.00% 0.00E+00 #\ ?/? #\ ??/?? m/d/yy d\-mmm\-yy d\-mmm mmm\-yy h:mm\ AM/PMh:mm:ss\ AM/PMh:mm h:mm:ss m/d/yy\ h:mm ##0.0E+0mm:ss@52_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),)_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)41_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)C C  C  C  C  C C C C C C C C C C C  C ! C  C  C  C  C #U} $  MEDICALSINGLE DOB SEXSALARY LIFE= hZL,> "