tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 84535d1284580779-extract-data-from-cells-budget-tracking
Sheet: Budget

Project Name: | Service Desk Tool Implementation
Project Manager:
 |  |  |  |  |  | Total Budget | 200000
 |  |  | Project Phase | % | start | End | Planned Budget
 |  |  | Pre-Initiation (10%) | 10 | 2010-09-01 00:00:00 | 2010-09-25 00:00:00 | 20000
 |  |  | Initiation (10%) | 10 | 2010-09-26 00:00:00 | 2010-10-10 00:00:00 | 20000
 |  |  | Planning (15%) | 15 | 2010-10-11 00:00:00 | 2010-11-11 00:00:00 | 30000
 |  |  | Execution (60%) | 60 | 2010-11-11 00:00:00 | 2011-02-01 00:00:00 | 120000
 |  |  | Closeout (5%) | 5 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 10000
 |  |  | Q1 | Q2 | Q3 | Q4
Planned Budget
Planned work (%)
Planned work Cumulative
Actual Work
Actual Work Cumulative
Actual Cost
Actual Cost Cumaltive
PV
EV
SPI
CPI
Spreadsheet: 13661f8a-c072-4b3e-ac63-bc1f18610be0
Sheet: performance

District/Agency Name
IRN
Date Completed
Section I: All Children Are Born Ready to Learn | Performance Indicator | Rating
Outcome 1:  The early education and care program facilitates and supports the healthy development of the children it serves. | 1.1, 1.2
 | 1.3, 1.4
 | 1.5, 1.6, 1.7
 | 2.1, 2.2
 | 3.1, 3.2
 | 4.1, 4.2, 4.3
Section II:  Environments Matter | Performance Indicator | Rating
Outcome 1:  The learning envirornment is organized to support and facilitate your children's thinking abilities, learning processes, social competencies and general well-being. | 1.1, 1.2
 | 1.3
 | 1.4
 | 2.1
 | 2.2, 2.3
 | 2.4
 | 2.5
 | 2.6
 | 3.1, 3.2
 | 3.3, 3.4
 | 3.5
Outcome 2:  Educators have the knowledge and skills necessary to support children's learning and development. | 1.1
 | 1.2
 | 1.3
 | 2.1, 2.2
 | 2.3, 2.4
 | 31., 3.2
 | 3.3
Section III:  Relationships Are Influencial | Performance Indicator | Rating
Outcome 1:  Educators receive supportive supervision and participate in ongoing professional development to ensure their knowledge and skills reflect the profession's expanding knowledge base. | 1.1
 | 2.1, 2.2, 2.3
 | 2.4
 | 3.1, 3.2
Outcome 2:  [NAME]'s development and learning are enhanced when the program establishes and maintains relationships with their families. | 1.1. 1.2, 1.3, 1.4
 | 1.5
Section IV:  Communication Is Critical | Performance Indicator | Rating
Outcome 1:  Program leaders communicate with families, school administrators and community organizations to ensure coordination and continuity of services. | 1.1, 1.2
 | 2.1, 2.2
Outcome 2:  Program leaders and staff demonstrate responsibility for their obligations to their children, families and communities. | 1.1
 | 1.2
 | 2.1, 2.2
 | 3.1, 3.2
Spreadsheet: 107617d1304726333-lookup-values-dummy-files
Sheet: Data2

VP | Functional Area | FA ID | Metric | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00
Satryb | BUS - Wireless Tech Support | 238971 | Xfer | 13.25 | 13.25 | 12.62725 | 12.03376925 | 11.46818209525 | 10.92917753677325 | 10.41550619254491 | 9.925977401495295 | 9.925977401495295 | 9.925977401495295 | 9.925977401495295 | 9.925977401495295
Satryb | TS - UBP Technical Support Svcs | 329662 | Xfer | 18.75 | 18.75 | 17.86875 | 17.02891875 | 16.22855956875 | 15.46581726901875 | 14.73892385737487 | 14.04619443607825 | 14.04619443607825 | 14.04619443607825 | 14.04619443607825 | 14.04619443607825
Satryb | TS - UBP Advanced Tech Support | 329663 | Xfer | 10 | 10 | 9.53 | 9.082089999999999 | 8.655231769999999 | 8.24843587681 | 7.860759390599929 | 7.491303699241731 | 7.491303699241731 | 7.491303699241731 | 7.491303699241731 | 7.491303699241731
Satryb | Enhanced Wireless Technical Service, EWT | 428937 | Xfer | 7 | 7 | 6.671 | 6.357463000000001 | 6.058662239 | 5.773905113767 | 5.502531573419951 | 5.243912589469213 | 5.243912589469213 | 5.243912589469213 | 5.243912589469213 | 5.243912589469213
Satryb | Spanish Technical Support | 512724 | Xfer | 11 | 11 | 10.483 | 9.990298999999998 | 9.520754946999999 | 9.073279464490998 | 8.64683532965992 | 8.240434069165904 | 8.240434069165904 | 8.240434069165904 | 8.240434069165904 | 8.240434069165904
Satryb | iDEN Tech Tier 1 | 516627 | Xfer | 15.5 | 15.5 | 14.7715 | 14.0772395 | 13.4156092435 | 12.7850756090555 | 12.18417705542989 | 11.61152073382468 | 11.61152073382468 | 11.61152073382468 | 11.61152073382468 | 11.61152073382468
Satryb | iDEN Tech Tier 2 | 516654 | Xfer | 15.5 | 15.5 | 14.7715 | 14.0772395 | 13.4156092435 | 12.7850756090555 | 12.18417705542989 | 11.61152073382468 | 11.61152073382468 | 11.61152073382468 | 11.61152073382468 | 11.61152073382468
Spreadsheet: david_delainey__8062__Sweetwater_129 MW_13June00_Breakeven
Sheet: JrDebt

 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | Junior Debt - PTC Monetization
 | PTC MONETIZATION
 | Forecasted PTC -- Project Year |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Pre-Exclusion  PTC Subject to Monetization
 | Initial Excluded PTC
 | Final Excluded PTC
 | PTC Subject to Monetization
 | PTC Allocated for Monetization - Oustide Equity
 | PTC Allocated for Monetization - EWC
 | Monetization Rate / Additional Outside Equity
 | Monetization Rate / Additional  EWC Equity
 | Total Monetized PTC  for JR Debt
 | PTC for Monetization - Test 1
 | PROJECT CASH
 | Net Project Cash Available for JR Debt -- Project Year
 | Project Cash for JR Debt Coverage Ratio
 | Total Project Cash for JR Debt
 | Total Cash Available for JR Debt - Test 2
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | Target Coverage Ratios
 | Actual Coverage Ratios
 | JR Debt Interest Rate
 | PVF
 | Total Cash for JR Debt = min(Test1,Test2)
 | PV
 | Total PV + Fine Tuner
 | Target Term |  |  |  |  |  | Actual Term
 |  |  | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 30
 | Project Start Date
 | Days in Period
 | Beginning Loan Balance
 | Interest
 | Principal
 | Ending Balance
 | First Payment Date
 | Days in Period
 | Mid-Year Loan Balance
 | Interest
 | Principal
 | Ending Balance
 | Second Payment Date
 | PROJECT YEAR
 | Annual Interest Payment
 | Annual Principle Payment
 | Total P & I Payment
 | Counter Beginning Period
 | Counter Mid Year
 | Average Life
 | ADJUSTMENT FOR CALENDAR YEAR
 | CALANDAR YEAR to rest of model
 | Beginning Balance
 | Total Annual Interest
 | Total Annual Principle
 | Ending Balance
 | Additional Equity --  Outside
 | Additional Equity -- EWC
Spreadsheet: 103185d1300979604-rank-by-team-sample-rank2-
Sheet: Sheet1

 |  |  |  |  |  | alternative
 | Team | Agent ID | [NAME] | Overall Rank | Team Ranking | Team Ranking
 | A | 1 | 0.9999999999999999 | 1 | 1 | 1
 | A | 3 | 0.9999999999999999 | 1 | 1 | 2
 | B | 6 | 0.9999999999999999 | 1 | 1 | 1
 | B | 7 | 0.9999999999999999 | 1 | 1 | 2
 | B | 8 | 0.9999999999999999 | 1 | 1 | 3
 | A | 2 | 2 | 6 | 3 | 3
 | A | 4 | 3 | 7 | 4 | 4
 | B | 5 | 4 | 8 | 4 | 4
Spreadsheet: 845301d1696846483-data-cleansing-data-cleansing
Sheet: Data

Table Name - Conversion |  |  |  | Table Name - MyList
Find | Replace |  |  | List For Cleaning |  |  | List after cleaning
Alabama | AL |  |  | Alabama- United States
Georgia | GA |  |  | Alaska, U.S
Kansas | KS |  |  | U.S- Arizona
New Mexico | NM |  |  | U.S.A/ California
New York | NY |  |  | United States Of ;Florida
Pennsylvania | PA |  |  | Georgia ;United States
Texas | TX |  |  | Kansas   U.S
Virginia | VA |  |  | United States  Louisiana
United States | U.S.A |  |  | U.S /  Maine
- |  |  |  | U.S.A #  Maryland
, |  |  |  | New Mexico -  United States
# |  |  |  | New York -  United States
/ |  |  |  | Pennsylvania /  U.S.A
 |  |  |  | Texas /
 |  |  |  | Virginia#
Spreadsheet: darrell_schoolcraft__7808__imbalsumm0108
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1 | -68011 | -37500 | -90 | -29410
2 | -49057 | -20000 |  | -27910
3 | -48415 | -11000 |  | -36910
4 | -29951 |  |  | -29410
5 | -29999 |  |  | -29410
6 | -29297 |  |  | -28307
7 | -64051 | -11000 |  | -51049
8 | -35246 |  |  | -34257
9 | -61903 | -10000 |  | -49974
10 | -63569 | -17500 |  | -44910
11 | -57587 | -27000 |  | -28288
12 | -57418 | -27000 |  | -28592
13 | -57225 | -27000 |  | -28771
14 | -88695 | -12000 |  | -75910
15 | -79069 | -11998 | -23700 | -90257
16 | -46861 | -5000 | -44315 | -84512
17 | -62441 |  |  | -60910
18 | -81752 | -48000 | -65196 | -97157
19 | -76011 | -48000 | -60094 | -88748
20 | -84945 | -48000 | -68581 | -102023
21
22
23
24
25
26
27
28
29
30
31
 | 2001-07-31 00:00:00 |  |  |  | 36339
 | 2001-08-20 00:00:00
CBS Dollars
 |  |  | -29968.41
Spreadsheet: lynn_blair__24470__NNGWKednotes_2001
Sheet: June 23 & 24,2001

NNG WEEKEND NOTES
For cc Mail distribution:  [NAME], [NAME], [NAME], S. January, [NAME], [NAME], [NAME], TMS OnCall
SATURDAY |  |  | 2001-06-23 00:00:00
Mail distribution send to the above listing on Sunday evening.
H:\DATA\Process Guidelines\[NNGWKednotes Template.xls]Dec 25 & 26
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 7:00 A.M. Non-grid:
 | Gas Day: | FRI |  |  | No difficulties with the process.
 | 8:00 AM Final Storage
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SAT |  |  | Allocated storage injections
 | 5:00 P.M. Intraday 2:
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 11:30 A.M. Timely
 | Gas Day: | SUN |  |  | No difficulties with the process
 | 6:00 P.M. Evening
 | Other Comments: |  |  |  | Allocated storage injection
 | On Call Reps. |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
SUNDAY
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 7:00 A.M. Non-grid:
 | Gas Day: | SAT |  |  | No difficuties with the process.
 | 8:00 AM Final Storage
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 5:00 P.M. Intraday 2:
 | Gas Day: | MON |  |  | No difficulties with the process.
 | 11:30 A.M. Timely
 | Gas Day: | MON |  |  | No difficulties with the process.
 | 6:00 P.M. Evening
 | Other Comments:
 | On Call Reps: |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
Spreadsheet: 722253d1615138023-find-criteria-then-count-book1
Sheet: Sheet1

 |  | Excel 2010+ | Excel 2007
1 | U |  |  | (2 because letter "U" appeared 2 times until it changed to letter "R" in row 3)
2 | U
3 | R |  |  | (1 because letter "R" appeared 1 time until it changed to letter "U" in row 4)
4 | U |  |  | (4 because letter "U" appeared 4 times until it changed to letter "R" in row 8)
5 | U
6 | U
7 | U
8 | R |  |  | ERROR ("ERROR' because letter "R" has not been changed until the last letter in row 9)
9 | R
Spreadsheet: 91858d1291561194-vlookup-error-test-database
Sheet: Roofing

Product | Unit | Price | Labour
.42 Zincalume CGI | m2 | 10 | 3
.42 Zincalume Superdek | m2 | 11 | 4
.42 Zincalume Smartspan | m2 | 12 | 5
.42 Zincalume Prodek | m2 | 13 | 6
.55 Colorbond Smartspan | m2 | 13.57 | 5.5
Spreadsheet: 148493d1333448308-pie-chart-not-grouping-categories-together-pie-chart
Sheet: Sheet1

UNIT | DATE | PD | ISSUE | FAULT | CATEGORY | COST | TID | FROM | TO | COMM | CANCEL | ID | FROM | TO | COMM
66720 | 2012-03-23 00:00:00 | 13 | Failed | Engine temp sensor | Electrical/sensor | 15201 | 4E33 | Felixstowe | Doncaster | C | 1 | 6C21 | Immingham | Eggborough | N
66711 | 2012-03-27 00:00:00 | 13 | Failed | [NAME] coupling adrift | Electrical/Gen | 7160 | 6F12 | Port of Tyne | [NAME] | N | 0
66723 | 2012-03-28 00:00:00 | 13 | Failed | Engine piston rings | Engine/pistons | 741 | 6Y21 | North Blyth | Ferrybridge | N | 1 | 6H92 | Port of Tyne | Drax | N
66720 | 2012-03-30 00:00:00 | 13 | Delayed | Engine temp sensor | Electrical/sensor | 1411 | 4M23 | Felixstowe | [NAME] | C | 0
Spreadsheet: 706361d1606660768-used-index-and-mutch-function-and-i-need-specific-cell-not-value-indexmuchfunction
Sheet: Data1

info1 | info2 | NAME | [NAME] | [NAME]
A | A | ALPHA | A | A
D | D | DELTA | D | D
F | F | PHOTO | F | F
Spreadsheet: 68dfa23b-6b55-46e2-8c2d-24cb6efb0abc
Sheet: Sheet1

INTERNAL APPROVAL FORM | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
THE UNIVERSITY OF TULSA -  OFFICE OF RESEARCH AND SPONSORED PROGRAMS
Project Title: |  |  |  |  |  |  |  |  |  |  |  | Proposal No. : (ORSP)
Sponsoring Agency: |  |  |  |  |  |  |  |  |  |  |  | CFDA#:
Project Period of Performance: |  |  |  |  | Proposal Due Date: |  |  |  | Proposal Submission Date (ORSP):
Principal Investigator/Co-P.I. |  |  |  | Department |  |  | Date |  | Signature
TYPE OF APPLICATION |  |  |  |  | PROJECT TYPE |  |  |  | SPONSOR TYPE
 |  | New |  |  |  |  | Research |  |  |  |  | Federal
 |  | Renewal |  |  |  |  | Training |  |  |  |  | State
 |  | Preliminary |  |  |  |  | Equipment |  |  |  |  | Business
 |  | Revision |  |  |  |  | Other |  |  |  |  | Non-Profit
 |  | Supplement
REQUESTED BUDGET
 |  |  |  |  | Direct |  |  | Indirect |  |  |  | Total
Sponsor |  |  |  |  |  |  |  |  |  |  |  | 0
TU Cost Share |  |  |  |  |  |  |  |  |  |  |  | 0
Third Party Cost Share |  |  |  |  |  |  |  |  |  |  |  | 0
Third Party Name: |  |  |  |  |  |  |  |  |  | Proposal Number:
 |  |  |  |  |  |  |  |  |  |  | INITIAL BELOW
Does this project request funding for academic year release time? |  |  |  |  |  |  |  |  | Yes | No | PI: |  | Chair:
Will this project require additional laboratory and/or office space? |  |  |  |  |  |  |  |  | Yes | No | PI: |  | Chair:
 | If yes, Is space available to accommodate this project? |  |  |  |  |  |  |  | Yes | No | PI: |  | Chair:
 | Where: |  |  |  |  |  |  |  |  |  |  |  | [NAME]:
Does this project require support personnel such as a secretary, clerical |  |  |  |  |  |  |  |  | Yes | No | PI: |  | Chair:
assistant, technician, etc.? If yes, explain:
UNIVERSITY COST SHARE APPROVAL
BUDGET CATEGORY |  |  |  |  | COST SHARE AMOUNT |  |  | Cost Share Approval
 |  |  |  |  |  |  |  | Signature |  |  |  |  | Date
AUTHORIZED SIGNATURES
SEE ABOVE
Principal Investigator(s) |  |  |  |  | Date |  |  | Budget Approval (ORSP) |  |  |  |  | Date
Department Chair(s) |  |  |  |  | Date |  |  | Research/Sponsored Programs |  |  |  |  | Date
College Dean(s) |  |  |  |  | Date |  |  | Other |  |  |  |  | Date
*Complete Page Two and Conflict of Interest Form for compliance/certification requirements |  |  |  |  |  |  |  |  |  |  |  |  | Rev. 1-2012
Spreadsheet: 684341d1593311885-rank-in-order-and-shade-using-conditional-formatting-rankandshade-khanaran-
Sheet: Sheet1

BP | [NAME] | Last Race | BioV | JT | JH | WT | SR | DOB | SIRE |  | CON | OR | TOT | OB | CB | MERIT | TIME | Raj | Book | Diff | OR | PRB | BioV | SR | CON | PRB
 |  |  | 17 |  |  |  |  |  |  |  | 70 | 114.5 | 25.4 | 10 | 66 | - | 63
 |  |  | 32 |  |  |  |  |  |  |  | 35 | 100 | 22.1 | 16 | 35 | - | 63.2
 |  |  | 42 |  |  |  |  |  |  |  | 27 | 242.5 | 48.5 | 1.5 | 2.8 | - | 64.5
 |  |  | 25 |  |  |  |  |  |  |  | 29 | 91.5 | 21.5 | 4.5 | 35 | - | 65
 |  |  | 27 |  |  |  |  |  |  |  | 32 | 159 | 24.2 | 8 | 66 | - | 67.9
 |  |  | 27.3 |  |  |  |  |  |  |  |  | 74 | 20.6 | 12 | 6 | - | 999.8
 |  |  |  |  |  |  |  |  |  |  |  | 56.5 | 15.3 | 33 | 35 | - | 999.8
 |  |  |  |  | Col S need to rank column  N from highest to lowest
 |  |  |  |  | Col T need to rank column  P from LOWEST TO HIGHEST
 |  |  |  |  | Col V need to rank column  M from highest to lowest
 |  |  |  |  | Col S need to rank column  N from highest to lowest
 |  |  |  |  |  |  |  | Ranking to be 1 ,2,3,4 and shaded green orange blue red
Spreadsheet: 59d58617-d57e-43fe-9a6d-48dbc761b5ad
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Quelle: http://ergebnisse.vimentis.ch/
Frage:
[NAME] müssen gleich behandelt werden wie private [NAME] (sie erhalten keine [NAME] öffentlichen Hand und können [NAME] gehen).
 | Wenn am nächsten Sonntag Nationalratswahlen wären, würden Sie wählen gehen?
Antwort | Ja | Eher ja | Weiss nicht / [NAME] | Eher nein | [NAME]
[NAME] | 0.26 | 0.21 | 0.24 | 0.29 | 0.28
[NAME] | 0.64 | 0.65 | 0.59 | 0.56 | 0.56
Neutral / Weiss nicht | 0.09 | 0.14 | 0.17 | 0.15 | 0.16
Angaben zu den [NAME]
Erhebungsjahr | 2010
Stichprobengrösse | 29292
Erhebungszeitraum | 02.10.2010 bis: 06.12.2010
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 204878d1357671437-nested-if-example
Sheet: Sheet1

A1 | B1 | C1 | 2012-06-04 00:00:00 | 2012-07-02 00:00:00 | 2012-08-06 00:00:00 | 2012-09-03 00:00:00 | 2012-10-01 00:00:00 | 2012-11-05 00:00:00
123 | Example | TCAT001
456 | Example | TCAT002
789 | Example | TCAT003
101 | Example | TCAT004
102 | Example | TCAT005
103 | Example | TCAT006
104 | Example | TCAT007
105 | Example | TCAT008
106 | Example | TCAT009
107 | Example | TCAT010
108 | Example | TCAT011
Spreadsheet: 215210d1361306072-incriment-time-in-hours-between-8am-9pm-book1
Sheet: Sheet1

2013-01-01 00:00:00 |  | 2013-01-01 00:00:00
2013-01-01 08:00:00 |  | 2013-01-01 08:00:00
2013-01-01 09:00:00 |  | 2013-01-01 09:00:00
2013-01-01 10:00:00 |  | 2013-01-01 10:00:00
2013-01-01 11:00:00 |  | 2013-01-01 11:00:00
2013-01-01 12:00:00 |  | 2013-01-01 12:00:00
2013-01-01 13:00:00 |  | 2013-01-01 13:00:00
2013-01-01 14:00:00 |  | 2013-01-01 14:00:00
2013-01-01 15:00:00 |  | 2013-01-01 15:00:00
2013-01-01 16:00:00 |  | 2013-01-01 16:00:00
2013-01-01 17:00:00 |  | 2013-01-01 17:00:00
2013-01-01 18:00:00 |  | 2013-01-01 18:00:00
2013-01-01 19:00:00 |  | 2013-01-01 19:00:00
2013-01-01 20:00:00 |  | 2013-01-01 20:00:00
2013-01-01 21:00:00 |  | 2013-01-01 21:00:00
2013-01-02 08:00:00 |  | 2013-01-02 08:00:00
2013-01-02 09:00:00 |  | 2013-01-02 09:00:00
2013-01-02 10:00:00 |  | 2013-01-02 10:00:00
2013-01-02 11:00:00 |  | 2013-01-02 11:00:00
2013-01-02 12:00:00 |  | 2013-01-02 12:00:00
2013-01-02 13:00:00 |  | 2013-01-02 13:00:00
2013-01-02 14:00:00 |  | 2013-01-02 14:00:00
2013-01-02 15:00:00 |  | 2013-01-02 15:00:00
2013-01-02 16:00:00 |  | 2013-01-02 16:00:00
2013-01-02 17:00:00 |  | 2013-01-02 17:00:00
2013-01-02 18:00:00 |  | 2013-01-02 18:00:00
2013-01-02 19:00:00 |  | 2013-01-02 19:00:00
2013-01-02 20:00:00 |  | 2013-01-02 20:00:00
2013-01-02 21:00:00 |  | 2013-01-02 21:00:00
2013-01-03 08:00:00 |  | 2013-01-03 08:00:00
2013-01-03 09:00:00 |  | 2013-01-03 09:00:00
2013-01-03 10:00:00 |  | 2013-01-03 10:00:00
2013-01-03 11:00:00 |  | 2013-01-03 11:00:00
2013-01-03 12:00:00 |  | 2013-01-03 12:00:00
2013-01-03 13:00:00 |  | 2013-01-03 13:00:00
2013-01-03 14:00:00 |  | 2013-01-03 14:00:00
2013-01-03 15:00:00 |  | 2013-01-03 15:00:00
2013-01-03 16:00:00 |  | 2013-01-03 16:00:00
2013-01-03 17:00:00 |  | 2013-01-03 17:00:00
2013-01-03 18:00:00 |  | 2013-01-03 18:00:00
2013-01-03 19:00:00 |  | 2013-01-03 19:00:00
2013-01-03 20:00:00 |  | 2013-01-03 20:00:00
2013-01-03 21:00:00 |  | 2013-01-03 21:00:00
2013-01-04 08:00:00 |  | 2013-01-04 08:00:00
2013-01-04 09:00:00 |  | 2013-01-04 09:00:00
2013-01-04 10:00:00 |  | 2013-01-04 10:00:00
2013-01-04 11:00:00 |  | 2013-01-04 11:00:00
2013-01-04 12:00:00 |  | 2013-01-04 12:00:00
2013-01-04 13:00:00 |  | 2013-01-04 13:00:00
2013-01-04 14:00:00 |  | 2013-01-04 14:00:00
2013-01-04 15:00:00 |  | 2013-01-04 15:00:00
2013-01-04 16:00:00 |  | 2013-01-04 16:00:00
2013-01-04 17:00:00 |  | 2013-01-04 17:00:00
2013-01-04 18:00:00 |  | 2013-01-04 18:00:00
2013-01-04 19:00:00 |  | 2013-01-04 19:00:00
2013-01-04 20:00:00 |  | 2013-01-04 20:00:00
2013-01-04 21:00:00 |  | 2013-01-04 21:00:00
Spreadsheet: 125787d1319215670-excel-2007-formula-help-time-calculation-time-calulator-example
Sheet: 10-10 to 10-15

Actual Time
Week Day |  | Time In | Lunch Out | Lunch In | Time Out
2011-10-10 00:00:00 |  | 08:23:00 | 15:08:00 | 15:23:00 | 17:23:00
2011-10-11 00:00:00 |  | 08:02:00 | 13:00:00 | 13:30:00 | 16:54:00 |  | Hours Left:
2011-10-12 00:00:00 |  | 08:12:00 | 13:16:00 | 13:45:00 | 18:35:00 |  | [NAME]:
2011-10-13 00:00:00 |  | 08:13:00 | 12:02:00 | 12:23:00 | 16:30:00
2011-10-14 00:00:00 |  | 08:10:00 | 13:25:00
2011-10-15 00:00:00
Peoplesoft Time
Week Day |  | Time In | Lunch Out | Lunch In | Time Out |  | Total Hours
2011-10-10 00:00:00 |  |  |  |  |  |  |  |  |  | Time Out Calculator
2011-10-11 00:00:00 |  |  |  |  |  |  |  |  |  | Hours Needed: |  | Converted: | [NAME]:
2011-10-12 00:00:00 |  |  |  |  |  |  |  |  |  | 06:15:00
2011-10-13 00:00:00 |  |  |  |  |  |  |  |  |  | Time In: |  | 08:00:00
2011-10-14 00:00:00 |  |  |  |  |  |  |  |  |  | Lunch Out: |  | 13:00:00
2011-10-15 00:00:00 |  |  |  |  |  |  |  |  |  | Lunch In: |  | 13:33:00
 |  |  |  |  |  |  |  |  |  | Time Out: