Employee Absence Tracker (online)

3/ Employee Name A. Jackson B. Brown S. Young M. Jordan

M

Medical Leave

V

Vacation

F

Funeral

S

Sick

1

2

3

4

5

6

7

8

9

#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A Thu

H

Holiday

10

11

12

Fri

Sat

13

14

Sun Mon Tue

15

16

17

18

Wed Thu

Fri

Sat

19

20

21

22

23

Sun Mon Tue Wed Thu

24

25

Fri

Sat

26

27

28

### ### ###

Sun Mon Tue ### ### ###

Follow the steps to enable your online Employee Absence Tracker. 1) Select the month and type the year: July

2009

2) Fill the employee list on the right. Leave the unused ones blank. >>Your Employee Absence Tracker is ready to use. Further steps are for online use. 3) Visit the site below: http://www.spreadsheetweb.com/getting_started.htm You will only need the username and password to create your online tracker. 4) Visit the site below: https://www4.spreadsheetweb.com/SpreadsheetWEB// Login to page with your new account information. 5) Click "Add Web Application" to upload this file. Your online tracker will be created automatically. You can simply use the tracker from that link or place it on your website.

6) You can save the files and update them online. Your files will be saved with Month / Year that you entered in Step 1. Changing the Month/Year and repeating Step 5 you can create a tracker every month. In order to update presaved tracker day by day, you need to use "Data" tab. You will see all saved trackers listed in tab. Simply clicking on the file name that you want to update, you can reach the tracker. >>Your online evaluation form will look like:

https://www4.spreadsheetweb.com/SpreadSheetWEB/Output.aspx?ApplicationID=55551111-2b41-4129-9c55-056f5 >>In order to see more online applications created with PSW you can check the link below: http://www.spreadsheetweb.com/demos.htm

ee Absence Tracker. Employee Name 1

A. Jackson

2

B. Brown

3

S. Young

4

M. Jordan

5 6 7 8 9 automatically.

h / Year that you entered in Step 1.

will see all saved trackers listed in the

10 11 12 13 14 15 16

=55551111-2b41-4129-9c55-056f5c1be0d1&Act=View&RecordID=2 17 18 19 20

Months January February March April May June July August September October November December

1 2 3 4 5 6 7 8 9 10 11 12

31

Month First Day

#N/A #N/A

First Day

#N/A

29? NbOfDays

TRUE #N/A

28 31 30 31 30 31 31 30 31 30 31

Hide? 29 30 31 #REF! #REF! #REF!

Day Indices 1 Sun 2 Mon 3 Tue 4 Wed 5 Thu 6 Fri 7 Sat 1 Sun 2 Mon 3 Tue 4 Wed 5 Thu 6 Fri 7 Sat

%3c%3fxml+version%3d%221.0%22+encoding%3d%22utf-16%22%3f%3e%0d%0a%3cPageInputCel %3c%3fxml+version%3d%221.0%22+encoding%3d%22utf-16%22%3f%3e%0d%0a%3cTables+xmln e%3d%22Calibri%22+WrapText%3d%22False%22+FontSize%3d%229%22+X%3d%224%2 owSpan%3d%2220%22+ColSpan%3d%221%22+Format%3d%22General%22+W ze%3d%229%22+X%3d%229%22+Y%3d%2210%22+%2f%3e%0d%0 2224.75%22+Text%3d%22%22+Height%3d%2215%22+Alig %3d%2217%22+Y%3d%2223%22+%2f%3e%0d% ++++%3cGridCell+Style%3d%22Class5 %22+Align%3d%22Center%22 2f%3e%0d%0a++++ %3c%3fxml+version%3d%221.0%22+encoding%3d%22utf-16%22%3f%3e%0d%0a%3cPageLayouts+ Black ;borderrightcolor: #215867 ;borderbottomcolor: #215867 ;backgro undcolor:Whi te; textalign:cen ter;vertic alalign:bott om;} tr-TR 2.0.0.0

Type:Sys tem.Null Referenc eExcepti on Message: Object reference not set to an instance of an object. StackTra ce: at Pagos.Sp readshee tWEB.Wiz ard.Help ers.Excel Helper.G etFormul aA1(Ran ge Range)_x 000D_ at Pagos.Sp readshee tWEB.Wiz ard.Type s.Input.S avingCell s.Load() UEsFBgAAAAAAAAAAAAAAAAAAAAAAAA%3d%3d

%3c%3fxml+version%3d%221.0%22+encoding%3d%22utf-16%22%3f%3e%0d%0a%3cSavingCells+ d%0a++++%3cValueType%3eText%3c%2fValueType%3e%0d%0a++%3c%2fCells%3e%0 %3cValueType%3eText%3c%2fValueType%3e%0d%0a++%3c%2fCells%3e%0d% ls%3e%0d%0a++++%3cNameIndex%3e563%3c%2fNameIndex%3e%

%0a%3cPageInputCells+xmlns%3axsi%3d%22http%3a%2f%2fwww.w3.org%2f2001%2fXMLSchema-instance%2 2+Text%3d%22%22+Height%3d%2215.75%22+Align%3d%22Center%22+CellHasFormula%3d%22F %22%22+ColSpan%3d%22%22+Format%3d%22General%22+Width%3d%2224.75%22+T %0a%3cPageLayouts+xmlns%3axsi%3d%22http%3a%2f%2fwww.w3.org%2f2001%2fXMLSchema-instance%22+

%2fNameIndex%3e%0d%0a++++%3cLabel%3eD_519%3c%2fLabel%3e%0d%0a++++%3cValueType%3eText

LSchema-instance%22+xmlns%3axsd%3d%22http%3a%2f%2fwww.w3.org%2f2001%2fXMLSchema%22%3e% %3d%2224.75%22+Text%3d%22%22+Height%3d%2215.75%22+Align%3d%22Left%22+CellHasFormula%3d% chema-instance%22+xmlns%3axsd%3d%22http%3a%2f%2fwww.w3.org%2f2001%2fXMLSchema%22+IsTabsV

3cValueType%3eText%3c%2fValueType%3e%0d%0a++%3c%2fCells%3e%0d%0a++%3cCells%3e%0d%0a++

MLSchema%22%3e%0d%0a++%3cInputCells+InputPrefix%3d%22PSWInput_%22+ListPrefix%3d%22PSWList_% CellHasFormula%3d%22False%22+FontName%3d%22Calibri%22+WrapText%3d%22False%22+FontSize%3d% Schema%22+IsTabsVisible%3d%22true%22+InitialPageIndex%3d%220%22%3e%0d%0a++%3cPageLayout+In

Cells%3e%0d%0a++++%3cNameIndex%3e564%3c%2fNameIndex%3e%0d%0a++++%3cLabel%3eD_619%3c

x%3d%22PSWList_%22+CellCount%3d%2231%22%3e%0d%0a++++%3cCells%3e%0d%0a++++++%3cAddr %22+FontSize%3d%229%22+X%3d%2219%22+Y%3d%2227%22+%2f%3e%0d%0a++++++%3cTD+Style%3 ++%3cPageLayout+Index%3d%220%22+IsPageHidingEnabled%3d%22false%22+Order%3d%220%22+FileNam

cLabel%3eD_619%3c%2fLabel%3e%0d%0a++++%3cValueType%3eText%3c%2fValueType%3e%0d%0a++%3

0a++++++%3cAddress%3e%3d'Employee+Absence'!%24E%247%3c%2fAddress%3e%0d%0a++++++%3cL +++%3cTD+Style%3d%22Class45%22+Merge%3d%22False%22+RowSpan%3d%22%22+ColSpan%3d%22%2 d%220%22+FileName%3d%221.+Employee+Absence%22+IsAjaxEnabled%3d%22false%22+Recipient%3d%2

pe%3e%0d%0a++%3c%2fCells%3e%0d%0a++%3cCells%3e%0d%0a++++%3cNameIndex%3e565%3c%2fNa

d%0a++++++%3cListItemsAddress%3e%3d'Employee+Absence'!%24E%247%3a%24E%2426%3c%2fListItem +ColSpan%3d%22%22+Format%3d%22General%22+Width%3d%2224.75%22+Text%3d%22%22+Height%3d% 22+Recipient%3d%22Enter+e-mail+address+here.%22+Location%3d%22Bottom%22+Alignment%3d%22Cen

x%3e565%3c%2fNameIndex%3e%0d%0a++++%3cLabel%3eD_719%3c%2fLabel%3e%0d%0a++++%3cValu

2426%3c%2fListItemsAddress%3e%0d%0a++++++%3cNameIndex%3e0%3c%2fNameIndex%3e%0d%0a+++ %22%22+Height%3d%2215.75%22+Align%3d%22Left%22+CellHasFormula%3d%22False%22+FontName%3d% ignment%3d%22Center%22+AutoResponseEmail%3d%22False%22+NotificationEmail%3d%22False%22+Page

d%0a++++%3cValueType%3eText%3c%2fValueType%3e%0d%0a++%3c%2fCells%3e%0d%0a++%3cCells%

dex%3e%0d%0a++++++%3cIsHidingEnabled%3efalse%3c%2fIsHidingEnabled%3e%0d%0a++++++%3cIsDi %22+FontName%3d%22Calibri%22+WrapText%3d%22False%22+FontSize%3d%229%22+X%3d%2220%22+Y d%22False%22+PageForwarding%3d%22False%22+PageForwardingCustomPage%3d%22False%22+PageForwa

0d%0a++%3cCells%3e%0d%0a++++%3cNameIndex%3e566%3c%2fNameIndex%3e%0d%0a++++%3cLabel

%0a++++++%3cIsDisablingEnabled%3efalse%3c%2fIsDisablingEnabled%3e%0d%0a++++++%3cRequiresVa +X%3d%2220%22+Y%3d%2227%22+%2f%3e%0d%0a++++++%3cTD+Style%3d%22Class45%22+Merge%3 False%22+PageForwardingIsExternalURL%3d%22False%22+PageForwardingExternalURL%3d%22None%22%3e

%0a++++%3cLabel%3eD_819%3c%2fLabel%3e%0d%0a++++%3cValueType%3eText%3c%2fValueType%3e

+++%3cRequiresValidation%3efalse%3c%2fRequiresValidation%3e%0d%0a++++++%3cIsRequired%3efalse ass45%22+Merge%3d%22False%22+RowSpan%3d%22%22+ColSpan%3d%22%22+Format%3d%22General%2 %3d%22None%22%3e%0d%0a++++%3cControls%3e%0d%0a++++++%3cPageControl+Enabled%3d%22false

3c%2fValueType%3e%0d%0a++%3c%2fCells%3e%0d%0a++%3cCells%3e%0d%0a++++%3cNameIndex%3e

cIsRequired%3efalse%3c%2fIsRequired%3e%0d%0a++++++%3cType%3eGrid%3c%2fType%3e%0d%0a+++ at%3d%22General%22+Width%3d%2224.75%22+Text%3d%22%22+Height%3d%2215.75%22+Align%3d%22 Enabled%3d%22false%22+Type%3d%22Calculate%22+Order%3d%220%22+CellLink%3d%22DEFAULT%22+N

+%3cNameIndex%3e567%3c%2fNameIndex%3e%0d%0a++++%3cLabel%3eD_919%3c%2fLabel%3e%0d%0a+

pe%3e%0d%0a++++++%3cDefaultValue+%2f%3e%0d%0a++++++%3cValueType+%2f%3e%0d%0a++++ 5%22+Align%3d%22Left%22+CellHasFormula%3d%22False%22+FontName%3d%22Calibri%22+WrapText%3d d%22DEFAULT%22+Name%3d%22Calculate%22+%2f%3e%0d%0a++++++%3cPageControl+Enabled%3d%22

2fLabel%3e%0d%0a++++%3cValueType%3eText%3c%2fValueType%3e%0d%0a++%3c%2fCells%3e%0d%0a

2f%3e%0d%0a++++%3c%2fCells%3e%0d%0a++++%3cCells%3e%0d%0a++++++%3cAddress%3e%3d'Emp ri%22+WrapText%3d%22False%22+FontSize%3d%229%22+X%3d%2221%22+Y%3d%2227%22+%2f%3e%0d rol+Enabled%3d%22false%22+Type%3d%22Reset%22+Order%3d%221%22+CellLink%3d%22DEFAULT%22+

%2fCells%3e%0d%0a++%3cCells%3e%0d%0a++++%3cNameIndex%3e568%3c%2fNameIndex%3e%0d%0a+

Address%3e%3d'Employee+Absence'!%24F%247%3c%2fAddress%3e%0d%0a++++++%3cListItemsAddress% 27%22+%2f%3e%0d%0a++++++%3cTD+Style%3d%22Class45%22+Merge%3d%22False%22+RowSpan%3d d%22DEFAULT%22+Name%3d%22Reset%22+%2f%3e%0d%0a++++++%3cPageControl+Enabled%3d%22fa

Index%3e%0d%0a++++%3cLabel%3eD_1019%3c%2fLabel%3e%0d%0a++++%3cValueType%3eText%3c%2

3cListItemsAddress%3e%3d'Employee+Absence'!%24F%247%3a%24F%2426%3c%2fListItemsAddress%3e%0 se%22+RowSpan%3d%22%22+ColSpan%3d%22%22+Format%3d%22General%22+Width%3d%2224.75%22+ +Enabled%3d%22false%22+Type%3d%22Send+Results%22+Order%3d%222%22+CellLink%3d%22DEFAULT

Type%3eText%3c%2fValueType%3e%0d%0a++%3c%2fCells%3e%0d%0a++%3cCells%3e%0d%0a++++%3c

temsAddress%3e%0d%0a++++++%3cNameIndex%3e1%3c%2fNameIndex%3e%0d%0a++++++%3cIsHidin %3d%2224.75%22+Text%3d%22%22+Height%3d%2215.75%22+Align%3d%22Left%22+CellHasFormula%3d nk%3d%22DEFAULT%22+Name%3d%22Submit%22+%2f%3e%0d%0a++++++%3cPageControl+Enabled%3d

e%0d%0a++++%3cNameIndex%3e569%3c%2fNameIndex%3e%0d%0a++++%3cLabel%3eD_1119%3c%2fLa

++++++%3cIsHidingEnabled%3efalse%3c%2fIsHidingEnabled%3e%0d%0a++++++%3cIsDisablingEnabled% +CellHasFormula%3d%22False%22+FontName%3d%22Calibri%22+WrapText%3d%22False%22+FontSize%3d% Control+Enabled%3d%22true%22+Type%3d%22Save%22+Order%3d%223%22+CellLink%3d%22%3d'Employ

%3eD_1119%3c%2fLabel%3e%0d%0a++++%3cValueType%3eText%3c%2fValueType%3e%0d%0a++%3c%2fC

IsDisablingEnabled%3efalse%3c%2fIsDisablingEnabled%3e%0d%0a++++++%3cRequiresValidation%3efalse% e%22+FontSize%3d%229%22+X%3d%2222%22+Y%3d%2227%22+%2f%3e%0d%0a++++++%3cTD+Style% %3d%22%3d'Employee+Absence'!%24AH%242%22+Name%3d%22Save%22+%2f%3e%0d%0a++++++%3c

%0d%0a++%3c%2fCells%3e%0d%0a++%3cCells%3e%0d%0a++++%3cNameIndex%3e570%3c%2fNameInd

sValidation%3efalse%3c%2fRequiresValidation%3e%0d%0a++++++%3cIsRequired%3efalse%3c%2fIsRequire ++++%3cTD+Style%3d%22Class45%22+Merge%3d%22False%22+RowSpan%3d%22%22+ColSpan%3d%22% 0d%0a++++++%3cPageControl+Enabled%3d%22false%22+Type%3d%22Back%22+Order%3d%225%22+Ce

570%3c%2fNameIndex%3e%0d%0a++++%3cLabel%3eD_1219%3c%2fLabel%3e%0d%0a++++%3cValueTyp

alse%3c%2fIsRequired%3e%0d%0a++++++%3cType%3eGrid%3c%2fType%3e%0d%0a++++++%3cDefaultV 2+ColSpan%3d%22%22+Format%3d%22General%22+Width%3d%2224.75%22+Text%3d%22%22+Height%3d er%3d%225%22+CellLink%3d%22DEFAULT%22+Name%3d%22Back%22+%2f%3e%0d%0a++++++%3cPage

a++++%3cValueType%3eText%3c%2fValueType%3e%0d%0a++%3c%2fCells%3e%0d%0a++%3cCells%3e%0

+++++%3cDefaultValue+%2f%3e%0d%0a++++++%3cValueType+%2f%3e%0d%0a++++%3c%2fCells%3e %22%22+Height%3d%2215.75%22+Align%3d%22Left%22+CellHasFormula%3d%22False%22+FontName%3d 0a++++++%3cPageControl+Enabled%3d%22false%22+Type%3d%22Next%22+Order%3d%224%22+CellLink

a++%3cCells%3e%0d%0a++++%3cNameIndex%3e571%3c%2fNameIndex%3e%0d%0a++++%3cLabel%3eD

+++%3c%2fCells%3e%0d%0a++++%3cCells%3e%0d%0a++++++%3cAddress%3e%3d'Employee+Absence'! e%22+FontName%3d%22Calibri%22+WrapText%3d%22False%22+FontSize%3d%229%22+X%3d%2223%22+ 3d%224%22+CellLink%3d%22DEFAULT%22+Name%3d%22Next%22+%2f%3e%0d%0a++++%3c%2fControls

++++%3cLabel%3eD_1319%3c%2fLabel%3e%0d%0a++++%3cValueType%3eText%3c%2fValueType%3e%0d

Employee+Absence'!%24G%247%3c%2fAddress%3e%0d%0a++++++%3cListItemsAddress%3e%3d'Employe +X%3d%2223%22+Y%3d%2227%22+%2f%3e%0d%0a++++++%3cTD+Style%3d%22Class45%22+Merge% +++%3c%2fControls%3e%0d%0a++%3c%2fPageLayout%3e%0d%0a++%3cApplicationName%3eEmployee+A

2fValueType%3e%0d%0a++%3c%2fCells%3e%0d%0a++%3cCells%3e%0d%0a++++%3cNameIndex%3e572

ess%3e%3d'Employee+Absence'!%24G%247%3a%24G%2426%3c%2fListItemsAddress%3e%0d%0a++++++% lass45%22+Merge%3d%22False%22+RowSpan%3d%22%22+ColSpan%3d%22%22+Format%3d%22General% ame%3eEmployee+Absence+Trackerx%3c%2fApplicationName%3e%0d%0a%3c%2fPageLayouts%3e

cNameIndex%3e572%3c%2fNameIndex%3e%0d%0a++++%3cLabel%3eD_1419%3c%2fLabel%3e%0d%0a++

e%0d%0a++++++%3cNameIndex%3e2%3c%2fNameIndex%3e%0d%0a++++++%3cIsHidingEnabled%3efal mat%3d%22General%22+Width%3d%2224.75%22+Text%3d%22%22+Height%3d%2215.75%22+Align%3d%22 Layouts%3e

abel%3e%0d%0a++++%3cValueType%3eText%3c%2fValueType%3e%0d%0a++%3c%2fCells%3e%0d%0a++

HidingEnabled%3efalse%3c%2fIsHidingEnabled%3e%0d%0a++++++%3cIsDisablingEnabled%3efalse%3c%2fI 75%22+Align%3d%22Left%22+CellHasFormula%3d%22False%22+FontName%3d%22Calibri%22+WrapText%3

fCells%3e%0d%0a++%3cCells%3e%0d%0a++++%3cNameIndex%3e573%3c%2fNameIndex%3e%0d%0a+++

ed%3efalse%3c%2fIsDisablingEnabled%3e%0d%0a++++++%3cRequiresValidation%3efalse%3c%2fRequires bri%22+WrapText%3d%22False%22+FontSize%3d%229%22+X%3d%2224%22+Y%3d%2227%22+%2f%3e%0

dex%3e%0d%0a++++%3cLabel%3eD_1519%3c%2fLabel%3e%0d%0a++++%3cValueType%3eText%3c%2fV

alse%3c%2fRequiresValidation%3e%0d%0a++++++%3cIsRequired%3efalse%3c%2fIsRequired%3e%0d%0a+ 227%22+%2f%3e%0d%0a++++++%3cTD+Style%3d%22Class45%22+Merge%3d%22False%22+RowSpan%3

pe%3eText%3c%2fValueType%3e%0d%0a++%3c%2fCells%3e%0d%0a++%3cCells%3e%0d%0a++++%3cNa