I have a time record spreadsheet that consists of:
<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 61px"><COL style="WIDTH: 187px"><COL style="WIDTH: 89px"><COL style="WIDTH: 50px"><COL style="WIDTH: 56px"><COL style="WIDTH: 55px"><COL style="WIDTH: 51px"><COL style="WIDTH: 23px"><COL style="WIDTH: 64px"><COL style="WIDTH: 187px"><COL style="WIDTH: 84px"><COL style="WIDTH: 49px"><COL style="WIDTH: 54px"><COL style="WIDTH: 67px"><COL style="WIDTH: 47px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD><TD>N</TD><TD>O</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">39</TD><TD style="TEXT-ALIGN: left; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Self evaluation/Comments:</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt; FONT-WEIGHT: bold" colSpan=5></TD><TD style="FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: left; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Further planning:</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt; FONT-WEIGHT: bold" colSpan=5></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">40</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt" colSpan=2>1. Completed plan activities & results:</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt" colSpan=5>completed Phase II report</TD><TD style="FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt" colSpan=2>1. Activities to complete within next 2 weeks</TD><TD style="FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt" colSpan=5></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">41</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt" colSpan=2>2. Pending activities:</TD><TD style="FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt" colSpan=5></TD><TD style="FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt" colSpan=2>2. Activities to complete within next 4 weeks</TD><TD style="FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt" colSpan=5></TD></TR><TR style="HEIGHT: 33px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">42</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Urgent matters and support needs:</TD><TD style="FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt" colSpan=5></TD><TD style="FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt">3. Further planning</TD><TD style="FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt"></TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt" colSpan=5>Prepare presentation for workshop</TD></TR></TBODY></TABLE>
Overview
<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 238px"><COL style="WIDTH: 252px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>H</TD><TD>I</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="FONT-STYLE: italic; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Plan</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Name</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">emp. 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">1. Completed plan activities & results:</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 10pt">completed Phase II report</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 10pt">3. Further planning</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Prepare presentation for workshop</TD></TR></TBODY></TABLE>
This means that all other fields (such as urgent matters..." would be ignored in this case.
How can I do this?
I use Windows Vista, Office 2007 (but with the xls file format)
- 12 work books with time record information of the 12 employees AND each employee can also complete some fields (see below) in case they need additional help and so on. In Cell B1 is the name of the employee:
<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 61px"><COL style="WIDTH: 187px"><COL style="WIDTH: 89px"><COL style="WIDTH: 50px"><COL style="WIDTH: 56px"><COL style="WIDTH: 55px"><COL style="WIDTH: 51px"><COL style="WIDTH: 23px"><COL style="WIDTH: 64px"><COL style="WIDTH: 187px"><COL style="WIDTH: 84px"><COL style="WIDTH: 49px"><COL style="WIDTH: 54px"><COL style="WIDTH: 67px"><COL style="WIDTH: 47px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD><TD>N</TD><TD>O</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">39</TD><TD style="TEXT-ALIGN: left; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Self evaluation/Comments:</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt; FONT-WEIGHT: bold" colSpan=5></TD><TD style="FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: left; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Further planning:</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt; FONT-WEIGHT: bold" colSpan=5></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">40</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt" colSpan=2>1. Completed plan activities & results:</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt" colSpan=5>completed Phase II report</TD><TD style="FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt" colSpan=2>1. Activities to complete within next 2 weeks</TD><TD style="FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt" colSpan=5></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">41</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt" colSpan=2>2. Pending activities:</TD><TD style="FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt" colSpan=5></TD><TD style="FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt" colSpan=2>2. Activities to complete within next 4 weeks</TD><TD style="FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt" colSpan=5></TD></TR><TR style="HEIGHT: 33px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">42</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Urgent matters and support needs:</TD><TD style="FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt" colSpan=5></TD><TD style="FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt">3. Further planning</TD><TD style="FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt"></TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Times New Roman; FONT-SIZE: 9pt" colSpan=5>Prepare presentation for workshop</TD></TR></TBODY></TABLE>
- Furthermore there is 1 overview work book that consolidates the information found in the 12 employee work sheets.
Overview
<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 238px"><COL style="WIDTH: 252px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>H</TD><TD>I</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="FONT-STYLE: italic; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Plan</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Name</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">emp. 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">1. Completed plan activities & results:</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 10pt">completed Phase II report</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 10pt">3. Further planning</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Prepare presentation for workshop</TD></TR></TBODY></TABLE>
This means that all other fields (such as urgent matters..." would be ignored in this case.
How can I do this?
I use Windows Vista, Office 2007 (but with the xls file format)