Home

Example Solutions: The Time Sheet

 

Introduction

A time sheet is a list that holds the time values worked by an employee or a contractor over a time period. In many companies, employees or contractors are usually asked to use a piece of paper on which they should record the necessary information for one or two weeks worth of the time they spent performing a duty. Nowadays, most companies use an electronic means of collecting the time. In an Intranet, employees may have to access an application from a shared drive, open the appropriate document, fill out their time sheet, and submit it.

 

A Paper Time Sheet

A paper time sheet is a physical list of values on a piece of paper. An employee would usually keep the paper that he or she can pick up at any time and modify it various times during the time period. If people from the accounting or payroll department wants to examine the time sheet of one particular employee, they would have to call the employee and request it. This is can be difficult or problematic if the employee and the company's accounting are not physically close, which is not uncommon nowadays (it is not surprising anymore for somebody located in New York to work for an employer who resides in San Francisco, or for a contractor in Adelaide to work for a company in Sydney). When the time period is over, such as at the end of the week or at the end of the two-week period, the employee can submit the time sheet. The time sheet is then sent to the accounting or payroll department.

An Electronic Time Sheet

An electronic time sheet is accessed using a computer. Usually, all employees time sheets are stored somewhere in a database on a computer. As stated earlier, an employee can access it any time, so can the accounting or payroll department. This means that, at any time, a supervisor can check the time sheet, for any reason. To make this possible, an application, namely a database is created, stored somewhere in a common computer such as a server, and given access to those who can use it.

One of the advantages of using paper time sheet is that, since the employee keeps the time sheet, there is no risk of having a duplicate time sheet. On the other hand, if you create an electronic table of time sheets, when an employee who wants to fill out his or her time sheet opens it, you need to make sure that the right time sheet is opened. In the same way, if somebody from the payroll department wants to check one particular employee's time sheet, you need to make it possible and easy to locate the right time sheet.

In the solution we are going to apply, we will create a table of employees and the time sheet they can fill out. In our time sheet, we will create a certain column, named TimeSheetCode, that will hold a unique number. We will come back to the role of this column.

Practical Learning Practical Learning: Introducing the Time Sheet

  1. If you want to practice with this exercise, start Microsoft SQL Server with the SQL Server Management Studio and connect to the server
  2. On the main menu, click File -> New -> Query With Current Connection and type the following:
     
    -- =============================================
    -- Database:     ynb1
    -- For:          Yugo National Bank
    -- Author:       FunctionX
    -- Date Created: Monday 24 April 2007
    -- =============================================
    USE master
    GO
    
    -- Drop the database if it already exists
    IF  EXISTS (
    	SELECT name 
    		FROM sys.databases 
    		WHERE name = N'ynb1'
    )
    DROP DATABASE ynb1
    GO
    CREATE DATABASE ynb1
    GO
    -- =========================================
    -- Database: ynb1
    -- For:      Yugo National Bank
    -- Table:    Employees
    -- =========================================
    USE ynb1;
    GO
    IF OBJECT_ID('dbo.Employees', 'U') IS NOT NULL
      DROP TABLE dbo.Employees
    GO
    CREATE TABLE Employees
    (
        EmployeeID int Identity(1,1) NOT NULL,
        EmployeeNumber varchar(20),
        FirstName varchar(20) NULL,
        LastName varchar(20) NOT NULL,
        Title varchar(80) NULL,
        HourlySalary smallmoney NULL,
        CONSTRAINT PK_Employees PRIMARY KEY (EmployeeID)
    );
    GO
    
    INSERT INTO Employees(EmployeeNumber, FirstName,
        LastName, Title, HourlySalary)
    VALUES('88024', 'Matthew', 
           'Larson', 'Account Manager' , 32.15);
    GO
    INSERT INTO Employees(EmployeeNumber, FirstName,
        LastName, Title, HourlySalary)
    VALUES('25711', 'Patricia', 
           'Katts', 'Regional Manager' , 42.15);
    GO
    INSERT INTO Employees(EmployeeNumber, FirstName,
        LastName, Title, HourlySalary)
    VALUES('20410', 'Helene', 
           'Boileau', 'Cashier' , 12.15);
    GO
    INSERT INTO Employees(EmployeeNumber, FirstName,
        LastName, Title, HourlySalary)
    VALUES('91272', 'Peter', 
           'Ulm', 'Head Cashier' , 22.15);
    GO
    INSERT INTO Employees(EmployeeNumber, FirstName,
        LastName, Title, HourlySalary)
    VALUES('29475', 'Victoria', 
           'Canston', 'Cashier' , 14.25);
    GO
    -- =========================================
    -- Database: ynb1
    -- For:      Yugo National Bank
    -- Table:    TimeSheets
    -- =========================================
    IF OBJECT_ID('dbo.TimeSheets', 'U') IS NOT NULL
      DROP TABLE dbo.TimeSheets
    GO
    
    CREATE TABLE dbo.TimeSheets
    (
        TimeSheetID int identity(1,1) NOT NULL, 
        EmployeeNumber varchar(5) NOT NULL, 
        StartDate datetime NOT NULL,
        TimeSheetCode varchar(15),
        Week1Monday varchar(6),
        Week1Tuesday varchar(6),
        Week1Wednesday varchar(6),
        Week1Thursday varchar(6),
        Week1Friday varchar(6),
        Week1Saturday varchar(6),
        Week1Sunday varchar(6),
        Week2Monday varchar(6),
        Week2Tuesday varchar(6),
        Week2Wednesday varchar(6),
        Week2Thursday varchar(6),
        Week2Friday varchar(6),
        Week2Saturday varchar(6),
        Week2Sunday varchar(6),
        Notes text,
        CONSTRAINT PK_TimeSheets PRIMARY KEY(TimeSheetID)
    )
    GO
    INSERT INTO TimeSheets(EmployeeNumber, StartDate, TimeSheetCode,
        Week1Monday, Week1Tuesday, Week1Wednesday, Week1Thursday,
        Week1Friday, Week1Saturday, Week1Sunday, Week2Monday,
        Week2Tuesday, Week2Wednesday, Week2Thursday, Week2Friday,
        Week2Saturday, Week2Sunday, Notes)
    VALUES('20410', '2007/01/01', '2041020070101', '0.00', '8.50', 
           '9.50', '8.50', '9.00', '0.00', '0.00', '10.00', '9.50',
           '8.50', '10.50', '9.00', '0.00', '0.00', 'Nothing to signal');
    GO
    INSERT INTO TimeSheets(EmployeeNumber, StartDate, TimeSheetCode,
        Week1Monday, Week1Tuesday, Week1Wednesday, Week1Thursday,
        Week1Friday, Week1Saturday, Week1Sunday, Week2Monday,
        Week2Tuesday, Week2Wednesday, Week2Thursday, Week2Friday,
        Week2Saturday, Week2Sunday)
    VALUES('88024', '2007/01/01', '8802420070101', '0.00', '4.00', 
           '6.00', '5.50', '6.50', '0.00', '0.00', '4.00', '6.00',
           '6.50', '4.00', '5.50', '0.00', '0.00');
    GO
    INSERT INTO TimeSheets(EmployeeNumber, StartDate, TimeSheetCode,
        Week1Monday, Week1Tuesday, Week1Wednesday, Week1Thursday,
        Week1Friday, Week1Saturday, Week1Sunday, Week2Monday,
        Week2Tuesday, Week2Wednesday, Week2Thursday, Week2Friday,
        Week2Saturday, Week2Sunday)
    VALUES('94272', '2007/01/15', '9427220070115', '8.50', '8.00', 
           '9.00', '8.50', '9.50', '0.00', '0.00', '5.50', '6.50',
           '4.50', '6.00', '4.00', '0.00', '0.00');
    GO
    INSERT INTO TimeSheets(EmployeeNumber, StartDate, TimeSheetCode,
        Week1Monday, Week1Tuesday, Week1Wednesday, Week1Thursday,
        Week1Friday, Week1Saturday, Week1Sunday, Week2Monday,
        Week2Tuesday, Week2Wednesday, Week2Thursday, Week2Friday,
        Week2Saturday, Week2Sunday)
    VALUES('88024', '2007/01/15', '8802420070115', '8.00', '8.50', 
           '9.50', '9.50', '8.50', '0.00', '0.00', '10.00', '9.00',
           '8.50', '8.00', '8.50', '0.00', '0.00');
    GO
    INSERT INTO TimeSheets(EmployeeNumber, StartDate, TimeSheetCode,
        Week1Monday, Week1Tuesday, Week1Wednesday, Week1Thursday,
        Week1Friday, Week1Saturday, Week1Sunday, Week2Monday,
        Week2Tuesday, Week2Wednesday, Week2Thursday, Week2Friday,
        Week2Saturday, Week2Sunday)
    VALUES('20410', '2007/01/15', '2041020070115', '8.00', '8.00', 
           '6.00', '8.00', '6.00', '0.00', '0.00', '8.00', '8.00',
           '8.00', '8.50', '8.00', '0.00', '0.00');
    GO
  3. Press F5 to execute the statement

Time Sheet Implementation

To address our problem of an electronic time, we will create a time sheet in which two pieces of information are required: an employee's number and a starting period. After an employee has opened a time sheet:

  1. The employee must first provide an employee number, which we will check in the Employees table. If the employee provides a valid employee number, we can continue with the time sheet. If the employee number is invalid, we will let the user know and we cannot continue with the time sheet
  2. After the employee has provided a valid employee number, we will request the starting period. After entering a (valid) date, we will check the time. If there is a record that holds both the employee number and the start date, this means that the employee had previously worked on a time sheet and we will open that existing time sheet.

After the the employee or contractor has entered a valid employee number and a start date, we will create a number called a time sheet code, represented in the TimeSheet as the TimeSheetCode column. This number is created as follows:

0000000000000

The first 5 digits represent the employee's number. The second 4 digits represent the year of the start date. The next 2 digits represent the month, and the last 2 digits represent the day. This number must be unique so that there would not be a duplicate number throughout the time sheet.

To make sure the value of the TimeSheetCode is unique for each record, after the employee has provided a valid employee number and a start date, we will create the time sheet code and check if that number exists in the TimeSheet table already:

  • If that number exists already, this means that the employee has previously worked on that time sheet and he or she simply wants to verify or update it. We will then open the time values for that record and let the user view or change it
  • If there is no record with the specified time sheet code, we will conclude that the employee is working on a new time sheet

Practical Learning Practical Learning: Implementing the Time Sheet

  1. Start Microsoft Visual C#
  2. On the main menu, click File -> New -> Web Site...
  3. Set the name to ynb2, set the language to Visual C#, and click OK
  4. In the Solution Explorer, right-click Default.aspx and click Rename
  5. Set the name to timesheet.aspx and press Enter
  6. Design the form as follows:
     
    Control Text Name Other Properties
    Label Employee #:    
    TextBox   txtEmployeeNumber  
    Button ... btnLocateEmployee  
    Label . lblEmployeeName  
    Label Start Date:    
    TextBox   txtStartDate  
    Button Locate btnLocateTimeSheet  
    Label End Date:    
    TextBox   txtEndDate  
    Label Mon    
    Label Tue    
    Label Wed    
    Label Thu    
    Label Fri    
    Label Sat    
    Label Sun    
    Label Week 1:    
    TextBox 0.00 txtWeek1Monday  
    TextBox 0.00 txtWeek1Tuesday  
    TextBox 0.00 txtWeek1Wednesday  
    TextBox 0.00 txtWeek1Thursday  
    TextBox 0.00 txtWeek1Friday  
    TextBox 0.00 txtWeek1Saturday  
    TextBox 0.00 txtWeek1Sunday  
    Label Week 2:    
    TextBox 0.00 txtWeek2Monday  
    TextBox 0.00 txtWeek2Tuesday  
    TextBox 0.00 txtWeek2Wednesday  
    TextBox 0.00 txtWeek2Thursday  
    TextBox 0.00 txtWeek2Friday  
    TextBox 0.00 txtWeek2Saturday  
    TextBox 0.00 txtWeek2Sunday  
    Label Notes    
    TextBox   txtNotes TextMode: Multiline
    Button Submit btnSubmit  
  7. Double the button on the right side of the txtEmployeeNumber text box
  8. Return to the form and double-click the button on the right side of the txtStartDate text box
  9. Return to the form and double-click the Submit button
  10. Change the file as follows:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class _Default : System.Web.UI.Page 
{
    bool ValidTimeSheet;
    bool bNewRecord;
    string strTimeSheetCode;

    protected void Page_Load(object sender, EventArgs e)
    {

    }
  
    protected void btnLocateEmployee_Click(object sender, EventArgs e)
    {
        if (this.txtEmployeeNumber.Text == "")
        {
            ValidTimeSheet = false;
            return;
        }

        string strSelect =
         string.Concat("SELECT * FROM Employees WHERE EmployeeNumber = '",
                         this.txtEmployeeNumber.Text, "';");

        SqlConnection conDatabase =
             new SqlConnection("Data Source=(local);Database='ynb1';" +
             "Integrated Security=true");
        SqlCommand cmdDatabase = new SqlCommand(strSelect, conDatabase);

        DataSet dsEmployees = new DataSet();
        SqlDataAdapter sda = new SqlDataAdapter();

        sda.SelectCommand = cmdDatabase;
        sda.Fill(dsEmployees);

        try
        {
            DataRow recEmployee = dsEmployees.Tables[0].Rows[0];

            if (recEmployee.IsNull("EmployeeNumber"))
            {
                ValidTimeSheet = false;
                throw new System.IndexOutOfRangeException("Bad Employee Number!");
            }
            else
            {
                String strFullName =
                    (string)recEmployee["FirstName"] +
                        " " + (string)recEmployee["LastName"];
                lblEmployeeName.Text = "Welcome " + strFullName;
                ValidTimeSheet = true;

            }
        }
        catch (IndexOutOfRangeException)
        {
            ValidTimeSheet = false;
            lblEmployeeName.Text = "";
            lblEmployeeName.Text = "There is no employee with that number!";
            txtEmployeeNumber.Text = "";
        }

        txtStartDate.Text = DateTime.Today.ToString("dddd MMMM dd, yyyy");
        txtEndDate.Text = DateTime.Today.AddDays(14).ToString("dddd MMMM dd, yyyy");

        txtWeek1Monday.Text = "0.00";
        txtWeek1Tuesday.Text = "0.00";
        txtWeek1Wednesday.Text = "0.00";
        txtWeek1Thursday.Text = "0.00";
        txtWeek1Friday.Text = "0.00";
        txtWeek1Saturday.Text = "0.00";
        txtWeek1Sunday.Text = "0.00";

        txtWeek2Monday.Text = "0.00";
        txtWeek2Tuesday.Text = "0.00";
        txtWeek2Wednesday.Text = "0.00";
        txtWeek2Thursday.Text = "0.00";
        txtWeek2Friday.Text = "0.00";
        txtWeek2Saturday.Text = "0.00";
        txtWeek2Sunday.Text = "0.00";

        conDatabase.Close();


    }
    protected void btnLocateTimeSheet_Click(object sender, EventArgs e)
    {
        txtEndDate.Text = DateTime.Parse(txtStartDate.Text).AddDays(14).ToString("dddd MMMM dd, yyyy");


        if (txtEmployeeNumber.Text.Equals(""))
        {
            ValidTimeSheet = false;
            return;
        }

        string strMonth;
        string strDay;
        int iMonth;
        int iDay;
        DateTime dteStart = DateTime.Today;

        try
        {
            dteStart = DateTime.Parse(txtStartDate.Text);
        }
        catch (FormatException)
        {
            // Invalid date
        }

        iMonth = dteStart.Month;
        iDay = dteStart.Day;

        if (iMonth < 10)
            strMonth = dteStart.Year + "0" + iMonth.ToString();
        else
            strMonth = dteStart.Year + iMonth.ToString();

        if (iDay < 10)
            strDay = strMonth + "0" + iDay.ToString();
        else
            strDay = strMonth + iDay.ToString();

        strTimeSheetCode = txtEmployeeNumber.Text + strDay;
        SqlConnection conTimeSheet = null;
        string strSQL =
        String.Concat("SELECT * FROM dbo.TimeSheets WHERE TimeSheetCode = '",
                 strTimeSheetCode, "';");

        conTimeSheet =
             new SqlConnection("Data Source=(local);Database='ynb1';" +
                     "Integrated Security=true");
        SqlCommand cmdTimeSheet = new SqlCommand(strSQL, conTimeSheet);

        DataSet dsTimeSheet = new DataSet("TimeSheetSet");
        SqlDataAdapter sdaTimeSheet = new SqlDataAdapter();
        sdaTimeSheet.SelectCommand = cmdTimeSheet;
        sdaTimeSheet.Fill(dsTimeSheet);

        conTimeSheet.Close();

        try
        {
            DataRow recTimeSheet = dsTimeSheet.Tables[0].Rows[0];
            strTimeSheetCode = (string)(recTimeSheet["TimeSheetCode"]);

            if (recTimeSheet.IsNull("TimeSheetCode"))
            {
                bNewRecord = true;
                throw new System.IndexOutOfRangeException(
                "No TimeSheet with that number exists!");
            }
            else
            {
                txtWeek1Monday.Text = (string)recTimeSheet["Week1Monday"];
                txtWeek1Tuesday.Text = (string)recTimeSheet["Week1Tuesday"];
                txtWeek1Wednesday.Text = (string)recTimeSheet["Week1Wednesday"];
                txtWeek1Thursday.Text = (string)recTimeSheet["Week1Thursday"];
                txtWeek1Friday.Text = (string)recTimeSheet["Week1Friday"];
                txtWeek1Saturday.Text = (string)recTimeSheet["Week1Saturday"];
                txtWeek1Sunday.Text = (string)recTimeSheet["Week1Sunday"];

                txtWeek2Monday.Text = (string)recTimeSheet["Week2Monday"];
                txtWeek2Tuesday.Text = (string)recTimeSheet["Week2Tuesday"];
                txtWeek2Wednesday.Text = (string)recTimeSheet["Week2Wednesday"];
                txtWeek2Thursday.Text = (string)recTimeSheet["Week2Thursday"];
                txtWeek2Friday.Text = (string)recTimeSheet["Week2Friday"];
                txtWeek2Saturday.Text = (string)recTimeSheet["Week2Saturday"];
                txtWeek2Sunday.Text = (string)recTimeSheet["Week2Sunday"];

                bNewRecord = false;
            }
        }
        catch (IndexOutOfRangeException)
        {
            txtWeek1Monday.Text = "0.00";
            txtWeek1Tuesday.Text = "0.00";
            txtWeek1Wednesday.Text = "0.00";
            txtWeek1Thursday.Text = "0.00";
            txtWeek1Friday.Text = "0.00";
            txtWeek1Saturday.Text = "0.00";
            txtWeek1Sunday.Text = "0.00";

            txtWeek2Monday.Text = "0.00";
            txtWeek2Tuesday.Text = "0.00";
            txtWeek2Wednesday.Text = "0.00";
            txtWeek2Thursday.Text = "0.00";
            txtWeek2Friday.Text = "0.00";
            txtWeek2Saturday.Text = "0.00";
            txtWeek2Sunday.Text = "0.00";

            bNewRecord = true;
        }
    }
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        string strTimeSheet = "";

        // If this is new record, then create a new time sheet
        if (bNewRecord == true)
        {
            strTimeSheet = String.Concat("INSERT INTO dbo.TimeSheets(TimeSheetCode, ",
                        "EmployeeNumber, StartDate, Week1Monday, Week1Tuesday, ",
                        "Week1Wednesday, Week1Thursday, Week1Friday, Week1Saturday, Week1Sunday, ",
                        "Week2Monday, Week2Tuesday, Week2Wednesday, Week2Thursday, Week2Friday, ",
                        "Week2Saturday, Week2Sunday, Notes) ",
                        "VALUES('", strTimeSheetCode, "', '", txtEmployeeNumber.Text, "', '",
                        DateTime.Parse(txtStartDate.Text).ToString("MM/dd/yyyy"), "', '", txtWeek1Monday.Text, "', '",
                        txtWeek1Tuesday.Text, "', '", txtWeek1Wednesday.Text, "', '", txtWeek1Thursday.Text, "', '",
                        txtWeek1Friday.Text, "', '", txtWeek1Saturday.Text, "', '",
                        txtWeek1Sunday.Text, "', '", txtWeek2Monday.Text, "', '", txtWeek2Tuesday.Text, "', '",
                        txtWeek2Wednesday.Text, "', '", txtWeek2Thursday.Text, "', '", txtWeek2Friday.Text, "', '",
                            txtWeek2Saturday.Text, "', '", txtWeek2Sunday.Text, "', '", txtNotes.Text, "');");
        }
        // If this is an existing record, then, only update it
        if (bNewRecord == false)
        {
            strTimeSheet = String.Concat("UPDATE TimeSheets SET Week1Monday = '", txtWeek1Monday.Text,
                        "', Week1Tuesday = '", txtWeek1Tuesday.Text, "', Week1Wednesday = '", txtWeek1Wednesday.Text,
                        "', Week1Thursday = '", txtWeek1Thursday.Text, "', Week1Friday = '", txtWeek1Friday.Text,
                        "', Week1Saturday = '", txtWeek1Saturday.Text, "', Week1Sunday = '", txtWeek1Sunday.Text,
                        "', Week2Monday = '", txtWeek2Monday.Text, "', Week2Tuesday = '", txtWeek2Tuesday.Text,
                        "', Week2Wednesday = '", txtWeek2Wednesday.Text, "', Week2Thursday = '", txtWeek2Thursday.Text,
                        "', Week2Friday = '", txtWeek2Friday.Text, "', Week2Saturday = '", txtWeek2Saturday.Text,
                        "', Week2Sunday = '", txtWeek2Sunday.Text, "', Notes = '", txtNotes.Text,
                        "' WHERE TimeSheetCode = '", strTimeSheetCode, "';");
        }

        if (this.ValidTimeSheet == true)
        {
            SqlConnection conTimeSheet =
                        new SqlConnection("Data Source=(local);Database='ynb1';" +
                        "Integrated Security=true");
            SqlCommand cmdTimeSheet = new SqlCommand(strTimeSheet, conTimeSheet);

            conTimeSheet.Open();
            cmdTimeSheet.ExecuteNonQuery();
            conTimeSheet.Close();
        }
    }
}

Home Copyright 2007 FunctionX, Inc.

 

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="timesheet.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Yugo National Bank - Employees Time Sheet</title>
</head>
<body>
    <form id="frmTimeSheet" runat="server" method="post">
    <div>
        <h1>YNB - Employees Time Sheet</h1>
        
        <table width="520">
            <tr>
                <td style="width: 84px">
                    <asp:Label ID="Label1" runat="server" Text="Employee #:"></asp:Label></td>
                <td style="width: 52px">
                    <asp:TextBox ID="txtEmployeeNumber" runat="server" Width="57px"></asp:TextBox>
                    <asp:Button ID="btnLocateEmployee" runat="server" OnClick="btnLocateEmployee_Click"
                        Text="..." /></td>
                <td style="width: 227px">
                    &nbsp;<asp:Label ID="lblEmployeeName" runat="server" Text="." Width="202px"></asp:Label></td>
            </tr>
            <tr>
                <td style="width: 84px">
                    <asp:Label ID="Label2" runat="server" Text="Start Date:"></asp:Label></td>
                <td colspan="1" style="width: 100px">
                    <asp:TextBox ID="txtStartDate" runat="server" Width="198px"></asp:TextBox></td>
                <td style="width: 100px" colspan="2">
                    &nbsp;<asp:Button ID="btnLocateTimeSheet" runat="server" OnClick="btnLocateTimeSheet_Click"
                        Text="Locate" /></td>
            </tr>
            <tr>
                <td style="width: 84px">
                    <asp:Label ID="Label3" runat="server" Text="End Date:"></asp:Label></td>
                <td colspan="1" style="width: 100px">
                    <asp:TextBox ID="txtEndDate" runat="server" Width="197px"></asp:TextBox></td>
                <td style="width: 100px" colspan="2">
                    </td>
            </tr>
        </table>
        <br />
        <table width="520">
            <tr>
                <td style="width: 200px">
                </td>
                <td style="width: 100px">
                    Mon</td>
                <td style="width: 100px">
                    Tue</td>
                <td style="width: 100px">
                    Wed</td>
                <td style="width: 100px">
                    Thu</td>
                <td style="width: 100px">
                    Fri</td>
                <td style="width: 100px">
                    Sat</td>
                <td style="width: 100px">
                    Sun</td>
            </tr>
            <tr>
                <td style="width: 200px">
                    Week 1:</td>
                <td style="width: 100px">
                    <asp:TextBox ID="txtWeek1Monday" runat="server" Width="40px">0.00</asp:TextBox></td>
                <td style="width: 100px">
                    <asp:TextBox ID="txtWeek1Tuesday" runat="server" Width="40px">0.00</asp:TextBox></td>
                <td style="width: 100px">
                    <asp:TextBox ID="txtWeek1Wednesday" runat="server" Width="40px">0.00</asp:TextBox></td>
                <td style="width: 100px">
                    <asp:TextBox ID="txtWeek1Thursday" runat="server" Width="40px">0.00</asp:TextBox></td>
                <td style="width: 100px">
                    <asp:TextBox ID="txtWeek1Friday" runat="server" Width="40px">0.00</asp:TextBox></td>
                <td style="width: 100px">
                    <asp:TextBox ID="txtWeek1Saturday" runat="server" Width="40px">0.00</asp:TextBox></td>
                <td style="width: 100px">
                    <asp:TextBox ID="txtWeek1Sunday" runat="server" Width="40px">0.00</asp:TextBox></td>
            </tr>
            <tr>
                <td style="width: 200px">
                    Week 2:</td>
                <td style="width: 100px">
                    <asp:TextBox ID="txtWeek2Monday" runat="server" Width="40px">0.00</asp:TextBox></td>
                <td style="width: 100px">
                    <asp:TextBox ID="txtWeek2Tuesday" runat="server" Width="40px">0.00</asp:TextBox></td>
                <td style="width: 100px">
                    <asp:TextBox ID="txtWeek2Wednesday" runat="server" Width="40px">0.00</asp:TextBox></td>
                <td style="width: 100px">
                    <asp:TextBox ID="txtWeek2Thursday" runat="server" Width="40px">0.00</asp:TextBox></td>
                <td style="width: 100px">
                    <asp:TextBox ID="txtWeek2Friday" runat="server" Width="40px">0.00</asp:TextBox></td>
                <td style="width: 100px">
                    <asp:TextBox ID="txtWeek2Saturday" runat="server" Width="40px">0.00</asp:TextBox></td>
                <td style="width: 100px">
                    <asp:TextBox ID="txtWeek2Sunday" runat="server" Width="40px">0.00</asp:TextBox></td>
            </tr>
        </table>

    </div>
        &nbsp;<table width="520">
            <tr>
                <td style="width: 208px" valign="top">
                    Notes:</td>
                <td style="width: 472px">
                    <asp:TextBox ID="txtNotes" runat="server" Height="77px" TextMode="MultiLine" Width="431px"></asp:TextBox></td>
            </tr>
        </table>
        &nbsp;<table width="520">
            <tr>
                <td style="width: 5103px">
                </td>
                <td style="width: 434px">
                    <asp:Button ID="btnSubmit" runat="server" Text="Submit" Width="91px" /></td>
            </tr>
        </table>
    </form>
</body>
</html>