tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: michelle_lokay__26699__imball0112
Sheet: williams

 | Milagro |  | La Maquina |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  | San Juan
1 | 322629 | 331878 | 57888 | 53010 | 28945 | 27522 | 102884 | 96422 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
2 | 308281 | 323091 | 64639 | 53010 | 28613 | 30000 | 99906 | 92814 |  |  |  | [NAME] |  |  | -34361 |  | 25006
3 | 293611 | 296350 | 63639 | 53010 | 29345 | 38526 | 77909 | 69180 |  |  |  | 2000-12-01 00:00:00 | 19698194 | 19662410 |  | 7.95
4 | 298687 | 291389 | 53723 | 53011 | 29404 | 34124 | 107008 | 105603 |  |  |  | 2001-01-01 00:00:00 | 18949781 | 18975457 |  | 8.1
5 |  |  |  |  |  |  |  |  |  |  |  | 2001-02-01 00:00:00 | 15256233 | 15290953 |  | 5.61
6 |  |  |  |  |  |  |  |  |  |  |  | 2001-03-01 00:00:00 | 17049350 | 17089226 |  | 4.87
7 |  |  |  |  |  |  |  |  |  |  |  | 2001-04-01 00:00:00 | 17652369 | 17743987 |  | 4.62
8 |  |  |  |  |  |  |  |  |  |  |  | 2001-05-01 00:00:00 | 16124989 | 16282021 |  | 3.44
9 |  |  |  |  |  |  |  |  |  |  |  | 2001-06-01 00:00:00 | 15928675 | 15936227 |  | 2.58
10 |  |  |  |  |  |  |  |  |  |  |  | 2001-07-01 00:00:00 | 16669639 | 16693576 |  | 2.45
11 |  |  |  |  |  |  |  |  |  |  |  | 2001-08-01 00:00:00 | 17850737 | 17815859 |  | 2.61
12 |  |  |  |  |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | 16552948 | 16508018 |  | 1.73
13 |  |  |  |  |  |  |  |  |  |  |  | 2001-10-01 00:00:00 | 17924814 | 17872479 |  | 2.06
14 |  |  |  |  |  |  |  |  |  |  |  | 2001-11-01 00:00:00 |  |  |  | 1.98
15 |  |  |  |  |  |  |  |  |  |  |  | 2001-12-01 00:00:00
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  |  |  |  |  |  |  | 135711
2001-12-04 00:00:00
CBS Dollars
 |  |  | 1018719
 |  |  | 300359.04
 |  |  | -250735.54
 |  |  | 44931.54
 |  |  | 2153062.32
 |  |  | 0.0238
 |  |  | 0.0153
 |  |  | 2444.99
 |  |  | 250
Spreadsheet: sally_beck__33866__EGM_MgmtSum-Q4-1207
Sheet: Expense Weekly Change

ENRON GLOBAL MARKETS
4TH QUARTER 2000 EXPENSES - WEEKLY CHANGE
 |  | Direct Expenses
Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
Liquids
Coal
Emissions |  |  |  |  |  | Nox Tech R&D Project
Weather
Global Risk Markets |  |  |  |  |  | Employee cost and EEX legal
Financial Trading
Transportation |  |  |  |  |  | McKinsey study; Diamond Tech study
Office of the Chairman
Subtotal
LNG
Middle East
Puerto Rico
Subtotal Commercial
Total
Group
Other Interest Related Charges
Total
 |  | Operating Expenses
Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
Spreadsheet: 732962d1621339062-splitting-excel-array-formula-due-to-huge-data-amount-testfile
Sheet: Sheet1

ID | Name | OpenedTime | Result
ticket1 | abc | 2021-01-01 00:00:25
ticket2 | abc1 | 2021-01-01 00:03:16
ticket3 | abc1 | 2021-01-01 00:04:48
ticket4 | abc2 | 2021-01-01 00:05:25
ticket5 | abc2 | 2021-03-01 00:06:08
ticket6 | abc1 | 2021-02-01 00:03:56
[NAME] | abc2 | 2021-03-01 00:07:15
[NAME] | abc1 | 2021-02-01 00:07:21
ticket9 | abc | 2021-01-01 00:07:23
ticket10 | abc | 2021-03-03 00:07:53
ticket11 | abc2 | 2021-07-01 00:10:25
ticket12 | abc1 | 2021-02-01 00:10:35
Spreadsheet: 269871d1381312092-how-to-get-results-depending-of-a-text-in-other-column-960075
Sheet: Sheet2

Supplier | SupplierCode | TypeCode
Axis PEC | PEC | M
cyber port | CP | B
Farnell | FA | B
FIRST4MAGNETS | F4M | B
GGR [NAME] | GGR | B
[NAME]. | [NAME] | M
[NAME] | LS | B
[NAME] | MI | B
RS | RS | B
Scan Buddy | SB | B
[NAME] | SB | B
Stella Seven | SS | B
Spreadsheet: 169218d1342728869-need-help-finding-average-if-specific-employees-have-hours-test
Sheet: Sheet1

 | Employee 1 | Employee2 | Employee3 | Employee4
Hourly rate | 205 | 133 | 153 | 121 |  |  | Average Rate Per Hour:
 |  |  |  |  |  |  |  | How do I calculate the average hourly rate for the emplyees working?  But if we add horus to Employee 2, then he is than calculated into the average?  Should we take the value of the total hours?
Phase 1 Hours | 20 |  | 5 | 2 |  |  |  | If we can do this even deeper and take the average based on percentage, that would be even better and more accurate!
Phase 2 Hours | 40 |  | 6 | 2
Phase 3 Hours | 10 |  |  | 1
Total Hours
Spreadsheet: 149753d1334116995-excel-2007-how-to-make-a-timeline-scedule-timeline
Sheet: Mods Checklist

Description of Milestone | Expected Time | Actual time
Pre-deployment workbook, and pre-activity checklist filled out and submitted | Before Technician leaves for site
For ETTCs (IP) sites (second or third node B), call UMTS ETTC's PCO to verify SIAD port 4 and/or 5 is configured, call the NIC to verify they can ping the SIAD IP address. | Before Technician arrives at site
Tech arrived at site | example  12:00:00 AM
Notify Ericsson PM of site arrival time, Site ID, SOW, MOP to be used, LDO login contact, NIC Engineer. | plus thirty minutes
For ATM sites, on the way to site or before loading any SW or scripts, call the PCO, check status of T1's.  Ask if  [NAME] are built to the MSN, if not, ask them to complete them. | plus fifteen minutes
Inventory of materials and HW check against RFDS, The person taking updates needs to check inventory against scope. | plus an hour and a half
Request LKF (For Special Events only the phrase "Special Event Site" should be the first words in the subject line of the LKF request) | plus three and a half hours
On traditional sites, Notify Ericsson PM once SW and scripts are loaded (before calling the NIC to integrate) on [NAME], notification is not required. | plus four hours
Obtain permission from Ericsson PM to transmit, specify wether dummy loads or antennas are to be used, email should have site id and "Permission to Call Test" in subject line | plus four and a half hours
Notify Ericsson PM once call testing is completed | plus four and a half hours
Completed workbook and COP submitted | plus one hour
Spreadsheet: 838697d1691260587-transpose-rows-data-into-multiple-columns-data-transpose_rows_to_multicolumns
Sheet: Sheet1

Group | Value |  |  | Group |  |  |  |  |  |  | Value
Group_01 | Val_A |  |  | Group_01 | Val_A | Val_B | Val_C |  |  | Group_01 | Val_A | Val_B | Val_C
Group_01 | Val_B |  |  | Group_02 | Val_X | Val_Y | Val_Z |  |  | Group_02 | Val_X | Val_Y | Val_Z
Group_01 | Val_C |  |  | Group_03 | Val_L | Val_M | Val_N |  |  | Group_03 | Val_L | Val_M | Val_N
Group_02 | Val_X |  |  | Group_04 | Val_Z |  |  |  |  | Group_04 | Val_Z
Group_02 | Val_Y |  |  | Group_05 | Val_L | Val_X |  |  |  | Group_05 | Val_L | Val_X
Group_02 | Val_Z
Group_03 | Val_L
Group_03 | Val_M
Group_03 | Val_N
Group_04 | Val_Z
Group_05 | Val_L
Group_05 | Val_X
Spreadsheet: 77347d1277841271-go-to-a-cell-in-column-based-on-a-reference-number-example
Sheet: Macro Solution

15143-1 | <== Enter a file code
Case Number | Name | Cert Number | Date Received | RFA | Date of RFA
41454-1 | DUSTIN | 709553082 | 2009-10-20 00:00:00
44987-1 | COSMIN | 805855525 | 2010-04-21 00:00:00
15143-1 | [NAME] | 725752088 | 2010-04-30 00:00:00
15144-1 | D | 726031012 | 2010-04-30 00:00:00
15843-1 | RUBEN | 624998061 | 2010-04-30 00:00:00
15711-1 | REGINA | 805298117 | 2010-05-18 00:00:00
19221-1 | BRYANT | 703698082 | 2010-05-18 00:00:00
21712-1 | THOMAS | 725453118 | 2010-05-18 00:00:00
21717-1 | [NAME] | 727052054 | 2010-05-18 00:00:00
21917-1 | MACK | 633253047 | 2010-05-18 00:00:00
12092-1 | TINA | 701241543 | 2010-05-19 00:00:00
12093-1 | RYAN | 702231024 | 2010-05-19 00:00:00
12108-1 | LANNIE | 722153008 | 2010-05-19 00:00:00
12767-1 | JEAN | 611153515 | 2010-05-19 00:00:00
14151-1 | [NAME] | 727152195 | 2010-05-20 00:00:00
18395-1 | [NAME] | 805853731 | 2010-05-22 00:00:00
18396-1 | [NAME] | 809352069 | 2010-05-22 00:00:00
Spreadsheet: 710260d1608813719-formula-to-compare-two-shets-and-extrct-items-in-column-a-that-are-unique-to-both-comparing-account-numbers-on-different-sheets
Sheet: Per AFS

Account Number | not in GL |  | AFS | GL
7103000
7103001
7103003
7106115
7103020
7103021
7103022
7103023
7103028
7103040
7103041
7103043
7103048
Spreadsheet: 169f3bfa-893a-43ca-9673-97518e41200a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | art. 20 §  2.2 | art. 24 § 3b | art.25 § 3
 |  | Exemption of  compulsory classification The Member States concerned shall notify the Commission of their decision referred to in the first subparagraph, specifying the maximum permitted number of slaughters in each of the slaughterhouses which are exempt from application of the Community scale. | On-the-spot checks For the application of the provisions in paragraphs 1 and 2, Member States shall notify to the Commission the measures they have taken for the application of these provisions by 1 July 2009 at the latest and thereafter within one month after any changes in the information to be notified. | Representative markets  Member States shall notify to the Commission the representative markets or quotation centres referred to in paragraph 1 by 1 July 2009 at the latest and thereafter within one month after any changes in the information to be notified.
1 | BE | X | X | X
2 | BG | X | X | X
3 | CZ | X | X | X
4 | DK |  | X | X
5 | DE | X | X | X
6 | EE | X | X | X
7 | IE | X | X | X
8 | EL
9 | ES |  | X | X
10 | FR | X | X | X
11 | IT | X |  | X
12 | CY | X | X | X
13 | LV | X | X | X
14 | LT | X | X
15 | LU | X | X | X
16 | [NAME]
17 | MT
18 | NL | X | X | X
19 | AT | X | X | X
20 | PL | X | X | X
21 | PT | X | X
22 | RO | X | X | X
23 | SI | X | X | X
24 | SK |  | X
25 | FI | X | X | X
26 | SE | X | X | X
27 | UK | X | X | X
Spreadsheet: 216964d1361942514-sum-of-year-month-and-days-experience-calculator
Sheet: Experience Calculator

Company | Start Date | End Date | Duration
[NAME] | 2008-06-16 00:00:00 | 2008-12-31 00:00:00 | 0 years, 6 months, 15 days
[NAME] | 2009-01-01 00:00:00 | 2010-05-31 00:00:00 | 1 years, 4 months, 30 days
[NAME] | 2010-07-23 00:00:00 | 2012-02-19 00:00:00 | 1 years, 6 months, 27 days
[NAME] | 2012-05-28 00:00:00 | 2013-02-27 00:00:00 | 0 years, 8 months, 30 days
E | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 years, 0 months, 0 days
F | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 years, 0 months, 0 days
G | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 years, 0 months, 0 days
H | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 years, 0 months, 0 days
I | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 years, 0 months, 0 days
G | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 years, 0 months, 0 days
K | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 years, 0 months, 0 days
 |  | Total | 0
Spreadsheet: 214720d1361086326-smoothing-data-febnmae-ver-1
Sheet: Febnorm

 |  |  | FEBRUARY
 | Normal |  |  | Record
 | Maximum | Minimum | Mean | Maximum | Year | Minimum | 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
Spreadsheet: 555145d1515456696-stats-points-tracking-for-a-disc-golf-league-golf-disc-tournament-2018
Sheet: Tournament 2

 |  |  | Tournament 2
 |  |  |  |  |  |  | Player
 |  |  | Player | Score |  |  | Low Score
 |  |  |  | 41
 |  |  |  | 29
 |  |  |  | 42
 |  |  |  | 66
 |  |  |  | 67
 |  |  |  | 37
 |  |  |  | 67
 |  |  |  | 71
 |  |  |  | 25
 |  |  |  | 29
 |  |  |  | 31
 |  |  |  | 29
 |  |  |  | 48
 |  |  |  | 32
 |  |  |  | 51
 |  |  |  | 29
 |  |  |  | 47
 |  |  |  | 63
 |  |  |  | 64
 |  |  |  | 63
 |  |  |  | 55
 |  |  |  | 70
 |  |  |  | 66
 |  |  |  | 47
 |  |  |  | 29
 |  |  |  | 62
 |  |  |  | 73
 |  |  |  | 61
 |  |  |  | 61
 |  |  |  | 33
 |  |  |  | 63
 |  |  |  | 33
 |  |  |  | 49
 |  |  |  | 66
 |  |  |  | 49
 |  |  |  | 62
 |  |  |  | 56
 |  |  |  | 67
 |  |  |  | 39
 |  |  |  | 70
 |  |  |  | 60
 |  |  |  | 39
 |  |  |  | 47
 |  |  |  | 65
 |  |  |  | 56
 |  |  |  | 33
 |  |  |  | 62
 |  |  |  | 35
 |  |  |  | 57
 |  |  |  | 62
 |  | x | x | x
Spreadsheet: 47514d1246543363-determining-top-contributors-top-50-percent-test
Sheet: Sheet1

ID# | Sales | Cumulative % of Sales | Top 50%
72123 | 70 | 0.06711409395973154 | 1
63602 | 69 | 0.1332694151486098 | 1
71791 | 57 | 0.1879194630872483 | 1
69221 | 45 | 0.2310642377756472 | 1
72551 | 45 | 0.274209012464046 | 1
72075 | 42 | 0.3144774688398849 | 1
71793 | 41 | 0.3537871524448706 | 1
71734 | 40 | 0.3921380632790029 | 1
69696 | 40 | 0.4304889741131352 | 1
61383 | 33 | 0.4621284755512943 | 1
72272 | 32 | 0.4928092042186002 | 1
69932 | 30 | 0.5215723873441994 | 0 | This person needs to be included as they pushed over the 50% mark.
60171 | 30 | 0.5503355704697986 | 0
71077 | 29 | 0.5781399808245445 | 0
70257 | 24 | 0.6011505273250239 | 0
70299 | 23 | 0.62320230105465 | 0
63991 | 23 | 0.6452540747842761 | 0
71589 | 21 | 0.6653883029721956 | 0
72257 | 20 | 0.6845637583892618 | 0
72550 | 20 | 0.7037392138063279 | 0
72474 | 19 | 0.7219558964525408 | 0
64757 | 16 | 0.7372962607861937 | 0
68352 | 16 | 0.7526366251198466 | 0
71371 | 15 | 0.7670182166826462 | 0
68249 | 15 | 0.7813998082454459 | 0
72560 | 15 | 0.7957813998082455 | 0
70026 | 13 | 0.8082454458293384 | 0
41567 | 13 | 0.8207094918504314 | 0
69689 | 13 | 0.8331735378715245 | 0
72121 | 12 | 0.8446788111217641 | 0
69368 | 11 | 0.8552253116011506 | 0
72546 | 11 | 0.8657718120805369 | 0
72547 | 11 | 0.8763183125599233 | 0
71583 | 11 | 0.8868648130393096 | 0
69222 | 10 | 0.8964525407478428 | 0
64721 | 9 | 0.9050814956855225 | 0
72684 | 9 | 0.9137104506232023 | 0
60513 | 8 | 0.9213806327900288 | 0
71577 | 7 | 0.9280920421860019 | 0
72558 | 6 | 0.9338446788111218 | 0
71994 | 6 | 0.9395973154362416 | 0
70967 | 5 | 0.9443911792905082 | 0
70608 | 5 | 0.9491850431447747 | 0
68956 | 5 | 0.9539789069990412 | 0
69553 | 5 | 0.9587727708533078 | 0
72748 | 4 | 0.962607861936721 | 0
72657 | 4 | 0.9664429530201343 | 0
67914 | 4 | 0.9702780441035475 | 0
68693 | 4 | 0.9741131351869607 | 0
32917 | 4 | 0.9779482262703739 | 0
72554 | 3 | 0.9808245445829339 | 0
72747 | 2 | 0.9827420901246404 | 0
72669 | 2 | 0.9846596356663471 | 0
40064 | 2 | 0.9865771812080537 | 0
72751 | 2 | 0.9884947267497604 | 0
32720 | 1 | 0.9894534995206136 | 0
72682 | 2 | 0.9913710450623202 | 0
65817 | 1 | 0.9923298178331735 | 0
12235 | 1 | 0.9932885906040269 | 0
61096 | 1 | 0.9942473633748802 | 0
71604 | 1 | 0.9952061361457335 | 0
63925 | 1 | 0.9961649089165868 | 0
70118 | 1 | 0.99712368168744 | 0
40153 | 1 | 0.9980824544582934 | 0
72746 | 1 | 0.9990412272291467 | 0
72805 | 1 | 1 | 0
Spreadsheet: 160817d1339221369-vlookup-on-another-sheet-cerca-2-oeldere5-
Sheet: Foglio2

 |  |  | 2012-05-01 00:00:00 | 3
MATTINA=  MORNING |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | helpcollomn |  | helpcollomn |  | helpcollomn
ADDETTI | Cod. turno | Turno | Straordinario | FERIE | [NAME] |  |  |  |  | By changing the date in E1, must enter their data in the columns ABF from sheet1 automatically.  The column C, I set myself.  The column D and E do not need  Only formulas thanks for your help |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ADDETTI |  | Cod. turno |  | [NAME]
SERENA | 35 | 08.00-16.00 |  |  | LORENZO
GIOVANNI | 30 | 05.30-13.30 |  |  | GIACOMO
PAOLA | 32 | 06.00-14.00 |  |  | VALENTINA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SERENA | 8 | 35 | 8
MARIA | 56 | 05.00-13.00 |  |  | ANNA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GIOVANNI | 9 | 30 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LORENZO | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GIACOMO | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAOLA | 13 | 32 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VALENTINA | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ANNA | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MARIA | 17 | 56 | 17
POMERIGGIO= AFTERNOON
ADDETTI | Cod. turno | Turno | Straordinario | MALATTIA
MANUELA | 51 | 15.30-23.30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MANUELA | 21 | 51 | 21
EVELINA | 34 | 14.00-22.00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EVELINA | 22 | 34 | 22
FRANCESCO | 31 | 22.00-06.00
DALILA | 42 | 13.30-21.30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FRANCESCO | 27 | 31 | 27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DALILA | 29 | 42 | 29
Spreadsheet: 76914d1277378856-summary-for-list-sample-2-
Sheet: Sheet1

SO NO | Line | Despatch
10000001 | 1 | NOT OTD
10000001 | 2 | OTD
10000001 | 3 | OTD
10000001 | 4 | OTD
10000001 | 5 | NOT OTD |  | Ex 1: The order no 10000001 contains 9 line, and Descpatch result have  Both OTD & NOTD.  The final result of order is NOT OTD
10000001 | 6 | NOT OTD |  | EX2: The order No 10000001 Contains 13 Lines, The results of the order is OTD. [NAME] is not avalible against this order in any line.
10000001 | 7 | NOT OTD
10000001 | 8 | NOT OTD |  | OTD  - ON time Delivery
10000001 | 9 | NOT OTD |  | NOTD - NOT On time Delivery
10000002 | 1 | OTD
10000002 | 2 | OTD
10000002 | 3 | OTD |  | 10000001 | not otd | NOT OTD |  | NOT OTD | NOT OTD
10000002 | 4 | OTD |  | 10000002 | otd | OTD |  | OTD | OTD
10000002 | 5 | OTD |  | 10000003 | not otd | NOT OTD |  | NOT OTD | NOT OTD
10000002 | 6 | OTD |  | 10000004 | not otd | NOT OTD |  | NOT OTD | NOT OTD
10000002 | 7 | OTD |  | 10000005 | not otd | NOT OTD |  | NOT OTD | NOT OTD
10000002 | 8 | OTD |  | 10000006 | otd | OTD |  | OTD | OTD
10000002 | 9 | OTD |  | 10000007 | otd | OTD
10000002 | 10 | OTD |  | 10000008 | otd | OTD |  | OTD | OTD
10000002 | 11 | OTD |  | 10000009 | not otd | NOT OTD |  | NOT OTD | NOT OTD
10000002 | 12 | OTD |  | 10000010 | otd | OTD |  | OTD | OTD
10000002 | 13 | OTD |  | 10000011 | otd | OTD
10000003 | 1 | NOT OTD |  | 10000012 | otd | OTD
10000004 | 1 | OTD |  | 10000013 | otd | OTD
10000004 | 2 | OTD |  | 10000014 | otd | OTD
10000004 | 3 | NOT OTD |  | 10000015 | otd | OTD
10000005 | 1 | NOT OTD |  | 10000016 | otd | OTD
10000005 | 2 | NOT OTD
10000006 | 1 | OTD
10000006 | 2 | OTD
10000008 | 1 | OTD
10000008 | 2 | NOTD
10000008 | 3 | OTD
10000009 | 1 | OTD
10000009 | 2 | OTD
10000009 | 3 | NOT OTD
10000009 | 4 | NOT OTD
10000009 | 5 | NOT OTD
10000009 | 6 | NOT OTD
10000009 | 7 | NOT OTD
10000009 | 8 | OTD
10000009 | 9 | NOT OTD
10000010 | 1 | OTD
10000010 | 2 | OTD
10000010 | 3 | OTD
10000010 | 4 | OTD
10000010 | 5 | OTD
10000010 | 6 | OTD
Spreadsheet: 794880d1662378235-absence-trackershowing-extra-days-in-some-months-how-to-fix-employee-absence-tracker
Sheet: Jan Abs Data 

 |  |  | PLEASE NOTE:  The start day is the first day of leave/sickness and the end date is the last day of leave/sickness and NOT the day that they retun to work
 | Employee Name | Start Date | End Date | Type of Leave | Reason for Sickness Absence | Other reasons for Leave Of Absence | Days | Self Cert Completed | Teaching / Non Teaching | Continued absence from previous month? | Has a Doctors Note been submitted? | Doctors Note Start | Doctors Note End | Is the [NAME] ongoing at the end of the month
 | Employee 1 | 2022-12-22 00:00:00 | 2022-12-30 00:00:00 | Sickness Absence | Heart (Pressure, Circulation etc)
 | Employee 1 | 2022-08-03 00:00:00 | 2022-08-05 00:00:00 | Sickness Absence | Mental Health (Stress / Anxiety etc)
 | Employee 1 | 2022-08-10 00:00:00 | 2022-08-12 00:00:00 | Sickness Absence | Back / Neck
 | Employee 1 | 2022-08-17 00:00:00 | 2022-08-19 00:00:00 | Dependant Care Paid
 | Employee 1 | 2022-08-24 00:00:00 | 2022-08-26 00:00:00 | Compassionate Paid
 | Employee 1 | 2022-12-22 00:00:00 | 2022-12-29 00:00:00 | Leave of Absence Paid |  | Fertility
 | Employee 1 | 2022-03-03 00:00:00 | 2022-03-10 00:00:00 | Leave of Absence Unpaid |  | Study Leave
 | Employee 1 | 2022-05-05 00:00:00 | 2022-05-15 00:00:00 | Dependant Care Unpaid
 | Employee 1
 | Employee 1
Spreadsheet: 120001d1314907595-is-there-a-way-to-merge-information-automatically-from-dissimilar-tabs-sample
Sheet: Master

Serial# | Item Name 1 | Item Name 1
159263 | Desk | Small
134570 | Desk | Medium
321146 | Keyboard | Wireless
449321 | Keyboard
157943 | Monitor
321648 | Monitor | 15
166624 | Monitor | 17
13476 | Monitor | 19
445568 | Monitor | 20
156461 | Monitor | 22
321648 | [NAME]
Spreadsheet: 69225d1269746335-splitting-a-column-with-a-1000-entries-into-multiple-columns-3d_data
Sheet: Folha1

 | 0 | 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 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48
0 | -3.0265 | 325.3 | 549.10195 | 753.0255 | 911.33825 | 1019.17025 | 1074.0115 | 1074.54995
1 | 12.1746 | 257.91744 | 523.16925 | 732.8855000000001 | 894.6104 | 1004.7088 | 1060.774225 | 1061.7004
2 | -1.61415 | 161.77835 | 296.68035 | 413.4467999999999 | 503.38395 | 564.4248249999999 | 595.4181249999999 | 595.8806500000001
3 | -5.1451 | 53.3479 | 84.61395 | 105.98135 | 121.766675 | 132.090625 | 137.08715 | 136.76465
4 | 0.6253 | 42.81165 | 79.13485 | 105.99015 | 124.2401 | 135.79855 | 141.269 | 140.85455
5 | 6.44095 | 33.58035 | 73.133075 | 101.39895 | 121.20695 | 133.690125 | 139.49915 | 138.9436
6 | -0.6152000000000015 | 177.5461 | 334.81625 | 463.827275 | 556.031275 | 614.16575 | 640.45755 | 635.7634499999999
7 | 1.01785 | 340.51992 | 630.524725 | 841.8093 | 996.690475 | 1096.310175 | 1141.07435 | 1131.2523
8 | -27.65555 | 395.401375 | 640.77955 | 846.21555 | 998.5241500000001 | 1097.3037 | 1141.72215 | 1131.503225
9 | 1.77715 | 338.39416 | 629.0595000000001 | 844.20115 | 1002.486 | 1104.935275 | 1151.435575 | 1141.942
10 | 0.7529500000000002 | 168.5233 | 328.09295 | 458.63395 | 553.51325 | 614.080575 | 641.8207249999999 | 637.27605
11 | 5.24355 | 24.467175 | 56.10795 | 82.632975 | 102.55495 | 115.34545 | 121.18025 | 120.30515
12 | -1.8358 | 29.57715 | 57.9493 | 84.84245 | 105.19765 | 118.31215 | 124.3402 | 123.54405
13 | 5.24355 | 24.467175 | 56.10795 | 82.632975 | 102.55495 | 115.34545 | 121.18025 | 120.30515
14 | 0.7529500000000002 | 168.5233 | 328.09295 | 458.63395 | 553.51325 | 614.080575 | 641.820725 | 637.27605
15 | 1.77715 | 338.39416 | 629.0595000000001 | 844.20115 | 1002.486 | 1104.935275 | 1151.435575 | 1141.942
16 | -27.65555 | 395.401375 | 640.77955 | 846.21555 | 998.5241500000001 | 1097.3037 | 1141.72215 | 1131.503225
17 | 1.01785 | 340.51992 | 630.524725 | 841.8093000000001 | 996.690475 | 1096.310175 | 1141.07435 | 1131.2523
18 | -0.6152000000000015 | 177.5461 | 334.81625 | 463.827275 | 556.031275 | 614.16575 | 640.4575500000001 | 635.76345
19 | 6.44095 | 33.58035 | 73.133075 | 101.39895 | 121.20695 | 133.690125 | 139.49915 | 138.9436
20 | 0.6253 | 42.81165 | 79.13485 | 105.99015 | 124.2401 | 135.79855 | 141.269 | 140.85455
21 | -5.1451 | 53.3479 | 84.61395 | 105.98135 | 121.766675 | 132.090625 | 137.08715 | 136.76465
22 | -1.61415 | 161.77835 | 296.68035 | 413.4467999999999 | 503.38395 | 564.424825 | 595.4181249999999 | 595.8806500000001
23 | 12.1746 | 257.91744 | 523.16925 | 732.8854999999999 | 894.6104 | 1004.7088 | 1060.774225 | 1061.7004
24 | -3.0265 | 325.3 | 549.10195 | 753.0255 | 911.33825 | 1019.17025 | 1074.0115 | 1074.54995
Spreadsheet: 466847d1466470179-rank-with-multiple-criteria-rankw-criteria-ex
Sheet: Input

 | Rank | Type of Fruit | Category | Rank_Category
 | 1 | Granny | Apples
 | 2 | [NAME] | Pears
 | 3 | Navel | Oranges
 | 1 | Clementine | Oranges
 | 2 | [NAME] | Oranges
 | 1 | Bosc | Pears
Spreadsheet: 806277d1669208371-using-logical-function-for-dates-timesheet-help
Sheet: Sheet2

 |  |  |  |  |  | Name:
 |  |  |  |  |  | Department:
 |  |  |  |  |  | Date:
 | Auto Mileage Record
Date |  | Travel From Point of Origin |  |  | To Destination |  |  | Purpose |  | # of Miles |  | Toll/Parking
 |  |  |  |  |  |  |  | Sub-Total
 |  |  |  |  |  |  |  | Mileage Earned
 |  |  |  |  |  |  |  | Grand Total
Travelers Signature |  |  |  |  |  |  | Date Prepared
Supervisor Signature |  |  |  |  |  |  | Date Prepared