tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 211236d1359694755-setting-up-an-setting-of-limited-characters-per-cell-longer-than-10
Sheet: Sheet1

1234567890
12345678901
[NAME]
abcdefghijk
Spreadsheet: a59c9971-69fd-45be-b8b8-2a96a06c9e84
Sheet: Sheet1

[NAME] do [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
DESIG/DISIC/SUREC
 |  |  |  | CONTAS SIMPLIFICADAS
Data | Contas correntes simplificadas |  | Contas de poupança simplificadas
 | Quantidade total | Contas ativas | Quantidade total | Contas ativas
2010-01-01 00:00:00 | 10056674 | 5612934 | 194196 | 16804
2010-02-01 00:00:00 | 10059931 | 5518166 | 192281 | 16758
2010-03-01 00:00:00 | 10088540 | 5502644 | 188956 | 17044
2010-04-01 00:00:00 | 10114619 | 5468973 | 180982 | 16534
2010-05-01 00:00:00 | 10110077 | 5428761 | 130725 | 14308
2010-06-01 00:00:00 | 9664591 | 5329344 | 6823 | 6050
2010-07-01 00:00:00 | 9723663 | 6488783 | 7005 | 6188
2010-08-01 00:00:00 | 9765882 | 6539041 | 7128 | 6306
2010-09-01 00:00:00 | 9780119 | 6572166 | 7327 | 6501
2010-10-01 00:00:00 | 9767333 | 6553280 | 9510 | 8695
2010-11-01 00:00:00 | 9832574 | 6578450 | 9592 | 8813
2010-12-01 00:00:00 | 9858300 | 6604702 | 9425 | 8649
2011-01-01 00:00:00 | 9915549 | 5532004 | 9480 | 8715
2011-02-01 00:00:00 | 9996124 | 5587984 | 9510 | 8734
2011-03-01 00:00:00 | 10107039 | 5659534 | 9518 | 8744
2011-04-01 00:00:00 | 10200329 | 5747946 | 9526 | 8724
2011-05-01 00:00:00 | 10326749 | 5922547 | 9969 | 9209
2011-06-01 00:00:00 | 10460769 | 6029378 | 10021 | 9256
2011-07-01 00:00:00 | 10624235 | 6475697 | 10063 | 9306
2011-08-01 00:00:00 | 10808857 | 6632119 | 10140 | 9374
2011-09-01 00:00:00 | 10972695 | 6781104 | 10179 | 9348
2011-10-01 00:00:00 | 11100685 | 6876887 | 11489 | 10724
2011-11-01 00:00:00 | 11249673 | 6976295 | 11565 | 10795
2011-12-01 00:00:00 | 11338900 | 7034795 | 11652 | 10876
2012-01-01 00:00:00 | 11466935 | 6922722 | 11688 | 10925
2012-02-01 00:00:00 | 11575144 | 6911229 | 11752 | 10982
2012-03-01 00:00:00 | 11770578 | 7074386 | 11898 | 11112
2012-04-01 00:00:00 | 11942581 | 7176839 | 11972 | 11182
2012-05-01 00:00:00 | 12108743 | 7305478 | 11995 | 11157
2012-06-01 00:00:00 | 12266125 | 7459965 | 12200 | 11409
2012-07-01 00:00:00 | 12431587 | 7720594 | 12262 | 11388
2012-08-01 00:00:00 | 12578085 | 7877702 | 12354 | 11374
2012-09-01 00:00:00 | 12646188 | 7945213 | 12369 | 11271
2012-10-01 00:00:00 | 12713003 | 8034503 | 12393 | 11220
2012-11-01 00:00:00 | 12809551 | 8315253 | 12559 | 12075
2012-12-01 00:00:00 | 12858787 | 8351747 | 12837 | 12049
Spreadsheet: 839235d1691763374-if-last-10-filtered-rows-of-data-contain-contain-specific-text-formula-help-test
Sheet: Sheet1

Account: |  |  |  |  | Note Description:
1 |  |  |  |  | This is a test string of data.
1 |  |  |  |  | The NOA was mailed yesterday
1 |  |  |  |  | I have a FEN 14x Form
1 |  |  |  |  | The dog pee'd on the grass
1 |  |  |  |  | I went and saw a movie today
1 |  |  |  |  | NOA mailed to the individual who requested it.
1 |  |  |  |  | The grass is green.
1 |  |  |  |  | I have blue jeans on today.
1 |  |  |  |  | Fred failed to pick me up this morning.
1 |  |  |  |  | I watched Lincoln Lawyer on Netflix.
1 |  |  |  |  | This another test of data.
2 |  |  |  |  | This is a test string of data of NOA mailed.
2 |  |  |  |  | The NOA was mailed yesterday
2 |  |  |  |  | I have a FEN 14y Form
2 |  |  |  |  | The dog pee'd on the grass
2 |  |  |  |  | I went and saw a movie today
2 |  |  |  |  | NOA was not mailed to the individual who requested it.
2 |  |  |  |  | The grass is green.
2 |  |  |  |  | I have blue jeans on today.
2 |  |  |  |  | Fred failed to pick me up this morning.
2 |  |  |  |  | I watched Lincoln Lawyer on Netflix.
2 |  |  |  |  | This another test of data.
Spreadsheet: c0b270e7-4a07-4c2e-8e1b-374f6bdcb449
Sheet: 2015-2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Global Studies
Spring 2015
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 701482d1603792762-vlookup-for-multiple-criterias-explicativ
Sheet: the plan

 |  | 2020-10-01 00:00:00 |  |  |  | 2020-11-01 00:00:00 |  |  |  | 2020-12-01 00:00:00
 |  | initial stock | input | consumption | final stock | initial stock | input | consumption | final stock | initial stock | input | consumption | final stock
 | product 1 | 1000 | 500 | 200 |  |  |  | 150
 | product 2 | 1500 | 500 | 700 |  |  |  | 600 |  |  |  | 800
 | product 3 | 2500 | 1000 | 1500 |  |  |  | 1300 |  |  |  | 2000
Spreadsheet: 861260d1709190949-how-to-simply-sum-the-1st-12-rows-of-a-filtered-result-how-to-sum-1st-12-rows-of-subtotal
Sheet: Sheet1

 | Challenge: | Create a forumula that will always sum only the first "n" results of filtering the "Color" column without copying data to a separate sheet or range…or resorting to VBA code.
 |  | The problem is that there is no obvious way to select a range that represents the first 5 results of a filtered list….
 |  |  |  | Sum of 1st 12 rows of filtered results:
 | Color | Value
 | Black | 0
 | [NAME] | 1
 | Red | 2
 | Orange | 3
 | Yellow | 4
 | Green | 5
 | Blue | 6
 | Violet | 7
 | Gray | 8
 | White | 9
 | Black | 10
 | [NAME] | 11
 | Red | 12
 | Orange | 13
 | Yellow | 14
 | Green | 15
 | Blue | 16
 | Violet | 17
 | Gray | 18
 | White | 19
 | Black | 20
 | [NAME] | 21
 | Red | 22
 | Orange | 23
 | Yellow | 24
 | Green | 25
 | Blue | 26
 | Violet | 27
 | Gray | 28
 | White | 29
 | Black | 30
 | [NAME] | 31
 | Red | 32
 | Orange | 33
 | Yellow | 34
 | Green | 35
 | Blue | 36
 | Violet | 37
 | Gray | 38
 | White | 39
Spreadsheet: 678290d1589807835-index-match-cos_excel-help
Sheet: Order

 | Sales person fills these in |  |  | This needs to be pulled in based on column B from COS tab
 | NAAB | Units | Price | COS
 | 001JE00992 | 10 | 15 | 1.395975267284584 | This is from column F
 | 501JE00992 | 10 | 25 | 12.26617807804737 | This is from column G
 | 601JE00992 | 10 | 35 | 15.76617807804737 | This is from column H
Spreadsheet: 67795d1268320722-validation-or-define-problem-supplier-list
Sheet: CocaCola

 | Coca Cola Beverages Ltd
 |  |  | Coca Cola |  |  |  |  |  |  | COKELIST
 | Ser # | Date | Item Name | Outlet Name | QTY | Rate | Amounts | Tax Amount
 | 1 |  | Coke 20 ltr BIB
 | 2 |  | Sprite 20 ltr BIB
 | 3 |  | Fanta 20 ltr BIB
 | 4 |  | Diet Coke 20 ltr BIB
 | 5 |  | Sprite Zero 20 ltr BIB
 | 6 |  | Coke 250 ml N/R
 | 7 |  | Sprite 250 ml N/R
 | 8 |  | Fanta 250 ml N/R
 | 9 |  | Diet Coke 250 ml N/R
 | 10 |  | Sprite Zero 250ml N/R
 | 11 |  | Coke 1.5 ltr Btl
 | 12 |  | Sprite 1.5 ltr Btl
 | 13 |  | Fanta 1.5 ltr Btl
 | 14 |  | Diet Coke 1.5 ltr Btl
 | 15 |  | Plastic Glasses
Spreadsheet: 4445fe5f-61c7-494c-9168-08899020cdd9
Sheet: EL CIVICS

Grant: |  | EL CIVICS
CFDA # |  | 84.002
GRANT NUMBER: |  | 6002
FISCAL YEAR: |  | 2011-12
[NAME]: |  | Not allowed on this grant
Question regarding payments: |  | [NAME]   [PHONE] or [EMAIL]
Questions regarding grant: |  | Marti Rodriguez  [PHONE] or [EMAIL]
LAST DAY TO SUBMIT REQUESTS FOR THIS GRANT  - SEPTEMBER 30, 2012
Code | District/Agency Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | JULY 2011 | JULY 2011 | AUGUST 2011 | AUGUST 2011 | SEPTEMBER 2011 | SEPTEMBER 2011 | OCTOBER 2011 | OCTOBER 2011 | NOVEMBER 2011 | NOVEMBER 2011 | DECEMBER 2011 | DECEMBER 2011 | JANUARY 2012 | JANUARY 2012 | FEBRUARY 2012 | FEBRUARY 2012 | MARCH 2012 | MARCH 2012 | APRIL 2012 | APRIL 2012 | MAY 2012 | MAY 2012 | JUNE 2012 | JUNE 2012 | JULY 2012 | JULY 2012 | AUGUST 2012 | SEPTEMBER 2012 | SEPTEMBER 2012 | OCTOBER 2012 | OCTOBER 2012
0470 | St. Vrain Valley Adult Education | 27757 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21200 |  |  |  |  |  |  |  |  | 6557
1010 | Colorado Springs 11 | 127518 |  |  |  |  |  |  |  |  |  |  | 18033 |  | 8005 |  | 7266 |  | 7637 |  | 9158 |  | 7207 |  | 8535 |  | 8589 |  |  |  | 42596
2180 | Montrose County School District | 15699 |  |  |  |  |  |  |  |  | 1721 |  |  |  |  | 5913 |  |  |  |  |  |  |  | 6325 |  |  | 1740
Y001 | Trinidad State Junior College | 46324 |  |  |  |  |  |  |  |  |  | 9213 |  |  |  |  |  |  | 13201 |  |  |  |  |  | 10761 |  |  |  | 13149
[NAME] | Focus Points/Open Book | 100337 |  |  |  |  |  |  |  | 33444 |  | 16722 |  |  |  |  |  | 16722 |  |  | 33449
Y697 | The Literacy Coalition of Jefferson County | 61859 |  |  |  |  |  |  |  | 15465 |  | 5155 | 5155 |  | 5155 |  |  | 5154 |  | 5154 | 5154 |  |  |  | 5154 | 5155 | 5155
Y699 | Northeastern Junior College | 59192 |  |  |  |  |  |  |  |  |  |  | 11978 |  | 13868 |  |  | 6678 |  |  | 10459
Y701 | Spring Institute for Intercultural Learning | 76009 |  |  |  |  |  |  |  |  |  | 25000 |  |  | 7500 |  | 7200 |  | 7200 | 7200 |  |  | 2353 |  | 5818 |  | 7592 |  | 6146
Y703 | Morgan Community College | 45021 |  |  |  |  |  |  |  |  |  |  | 2476 |  |  |  |  | 7772 |  |  |  |  |  | 13587 |  |  |  |  |  |  |  | 21186
Y705 | Adult Education Center of Durango | 68506 |  |  |  |  |  |  |  | 14480 | 6286 |  | 12420 |  | 6288 |  | 2382 |  | 7238 |  | 6480 |  | 5799 |  |  |  | 7133
Spreadsheet: 815541d1675019093-calculate-the-volume-based-on-the-number-of-the-tank-example-2-1-
Sheet: tank3

cm | Liters | cm | Liters | cm | Liters
300 | 2012351 | 350 |  | 400 | 2012789
301 |  | 351 |  | 401
302 |  | 352 |  | 402
303 |  | 353 |  | 403
304 |  | 354 |  | 404
305 |  | 355 |  | 405
306 |  | 356 |  | 406
307 |  | 357 |  | 407
308 |  | 358 |  | 408
309 |  | 359 |  | 409
 |  |  |  |  |  |  |  | AVERAGE  MILLIMETRES
 |  |  |  |  |  |  |  | 1 | 1019 | 6 | 6117
 |  |  |  |  |  |  |  | 2 | 2039 | 7 | 7136
 |  |  |  |  |  |  |  | 3 | 3058 | 8 | 8156
 |  |  |  |  |  |  |  | 4 | 4078 | 9 | 9175
 |  |  |  |  |  |  |  | 5 | 5097 | 0 | 0
Spreadsheet: 67da9ba4-6341-45cc-8c3e-0671cba15281
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 14998416323 | Brent Jones & The Tp Mobb | Ultimate Weekend, The | 2008-02-12 | Compact Disc | Gospel | 17.99 | Y | Available
Taseis | 14998416392 | Brent Jones & The Tp Mobb | Ultimate Weekend, The | 2008-02-12 | Music DVD | Gospel | 19.99 | Y | Available
Spreadsheet: 215921d1361541678-sum-of-sum-tableau-entrep-ts
Sheet: A9

[NAME]
Nom: | Vanessa Perras
Numéro de téléphone: | [PHONE]
[NAME]: | 40
Paiement dû le: | 2013-02-05 00:00:00
[NAME]: | 1
Réservé:
Prix: | 125
Payé: | NON
Mois réservés
Novembre 2011 | Post-daté
Décembre 2011 | Post-daté
Janvier 2012
Février 2012
Mars 2012
Avril 2012
Mai 2012
[NAME] 2012
Juillet 2012
Août 2012
Septembre 2012
Octobre 2012
Novembre 2012
Décembre 2012
Spreadsheet: 788398d1658437112-inserting-row-above-table-changes-formulas-despite-structured-references-sampleproblem
Sheet: Summary

Column1 | Category A | Category B | Category C | Category D
Total
Spreadsheet: 876840d1723554396-index-match-large-formula-meeting-multiple-criteria-test
Sheet: Data

Account Name | Rep | Total Dollars | Next Account Review/Follow Up Date
Business 1 | Eddie | 558214.5 | QBR
Business 2 | [NAME] | 451411.88 | QBR
Business 3 | Eddie | 411043.56 | No QBR
Business 4 | [NAME] | 303843.48 | No QBR
Business 5 | Eddie | 152055.13 | No QBR
Business 6 | [NAME] | 151978.34 | No QBR
Business 7 | Eddie | 142492.88 | No QBR
Business 8 | [NAME] | 139415.35 | No QBR
Spreadsheet: 102321d1300271443-competition-ladder-all-stats-equal-results-and-ladder
Sheet: Ladder - 2011

 | Pos | Team | P | W | D | L | For | Against | +/- [NAME] | POINTS
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
Spreadsheet: 60718d1261248385-work-schedule-timesheet-copy-of-schedule-timesheet2
Sheet: Jerry

NAME: |  |  |  |  |  | [NAME]
PHONE:
EMPLOYEE#
POSITION: |  |  |  | Floor, Dishes | Cook, Mid/Drive
 | Sun | 10:00-14:00
 | Mon | 07:50-13:00
 | Tue | 10:00-13:00
 | Wed | 11:00-14:00
 | Thu | 14:00-24:00
 | Fri | 16:00-20:00
 | Sat | 13:00-22:00
 |  | Hours:
Date:
Uniform:
Meals:
Other:
Spreadsheet: 028fdd57-cfa1-481f-bebe-0343ae91c357
Sheet: Sheet1

Applicant/Provider: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
RFP No.: |  | Period: _________________ to ____________________ |  | Date Prepared:
Contract No. (As Applicable):
 |  | FULL TIME | ANNUAL SALARY | % OF TIME | TOTAL SALARY
POSITION | POSITION TITLE | EQUIVALENT TO | INCLUDING BUDGETED | BUDGETED TO | BUDGETED
NO. |  | ORGANIZATION | [NAME] INCREASE | THE CONTRACT | TO THE CONTRACT
 |  |  | A | B | A x B
TOTAL:
[NAME]/COMMENTS:
Spreadsheet: 106422d1303680252-sumproduct-of-every-nth-value-in-a-row-book1
Sheet: Sheet1

 |  |  |  |  | total | return | price | val |  | total | return | price | val |  | total | return | price | val |  | total | return | price | val
 | 1 |  |  |  | 1.03 | 3 |  | 0.75 |  | 1.07 | 7 |  | 0.05 |  | 1.11 | 11 |  | 0.15 |  | 1.09 | 9 |  | 0.05
 | 34 | 5.699999999999999 |  |  | 1.04 | 4 |  |  |  | 1.08 | 8 |  |  |  | 1.12 | 12 |  |  |  | 1.1 | 10
Spreadsheet: 0b2c4dd4-7afd-435f-8458-fa7b5b183f8c
Sheet: 13a

 |  | Dealers** |  | Buyside |  | TOTAL
Product |  | Cleared*** | Uncleared | Cleared | Uncleared | Cleared | Uncleared
Single - Name* | Corporate | 506307 | 7533155 | 506307 | 740703 | 1012614 | 8273858
 | Loans |  | 21366 |  |  |  | 21366
 | Municipal |  | 3336 |  | <1,000 |  | 3336
 | Recovery
 | Sovereign | 32408 | 2600249 | 32408 | 240612 | 64816 | 2840862
Index Tranche | Asia |  | <1,000 |  | <100 |  | <1,000
 | Europe |  | 784930 |  | 85183 |  | 870113
 | North America |  | 889359 |  | 32821 |  | 922179
Index | Asia | 1334 | 301211 | 1636 | 45537 | 2970 | 346748
 | Europe | 268673 | 2420514 | 268613 | 358609 | 537286 | 2779123
 | North America | 450605 | 1448441 | 473226 | 302672 | 923831 | 1751113
Other | Exotic
 | Swaptions
 | Total Return Swap
TOTAL |  | 1259327 | 16002561 | 1282190 | 1806137 | 2541517 | 17808698
Estimated gross notional amount outstanding, December 28 weekly snapshot, by product type (millions of USD), all participant types, tenors and currencies.  Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for participant type descriptions.
***See Explanatory Notes for cleared and uncleared descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 803115d1667263350-need-an-excel-formula-to-calculate-after-office-8-hours-ot-from-start-and-end-date-hourscalculation_ot
Sheet: Sheet2

 | 7 AM TO 7 PM
 | START TIME | END TIME |  | Fixed Working Hrs | Complete Actula 8 Hrs | Applied OT from 19:00 PM | Actual [NAME]
Emp_1 | 2022-11-01 10:00:00 | 2022-11-01 22:00:00 |  | 8Hrs | 8 Hrs | 3 Hrs | 2 Hrs | Becoz his total work hrs is 8hrs only
Emp_2 | 2022-11-01 13:00:00 | 2022-11-01 20:00:00 |  | 8Hrs | 6:30 Hrs/M | 1:30 Hrs | 0 | Becoz his total work less than 8Hrs
Emp_3 | 2022-11-01 11:00:00 | 2022-11-01 21:00:00 |  | 8Hrs | 8 Hrs | 2 Hrs | 0 | Becoz his total work hrs is 8hrs only
Emp_4 | 2022-11-01 10:30:00 | 2022-11-01 20:00:00 |  | 8Hrs | 8 Hrs | 2 Hrs | 1:30 Hr
Emp_5 | 2022-11-01 09:00:00 | 2022-11-01 20:00:00 |  | 8Hrs | 8 Hrs | 4 Hrs | 4 Hrs
Emp_6 | 2022-11-01 07:00:00 | 2022-11-01 23:00:00 |  | 8Hrs | 8 Hrs | 4 Hrs | 4 Hrs
Spreadsheet: 686939d1594882327-dertemine-which-months-there-are-between-two-dates-dates-example2-aligw
Sheet: Sheet1

Startdate | Enddate | Expected result 1 | AliGW
2020-01-01 00:00:00 | 2020-02-01 00:00:00 | January, February
2020-01-02 00:00:00 | 2020-03-01 00:00:00 | January, February, March
2020-01-03 00:00:00 | 2020-03-15 00:00:00 | January, February, March
2020-01-04 00:00:00 | 2020-04-01 00:00:00 | January, February, March, April
2020-01-05 00:00:00 | 2020-05-01 00:00:00 | January, February, March, April, May
2020-01-06 00:00:00 | 2020-01-07 00:00:00 | January
2020-01-07 00:00:00 | 2020-02-15 00:00:00 | January, February
2020-01-08 00:00:00 | 2020-03-05 00:00:00 | January, February, March
2020-01-09 00:00:00 | 2020-03-06 00:00:00 | January, February, March
2020-01-10 00:00:00 | 2020-03-07 00:00:00 | January, February, March
2020-01-11 00:00:00 | 2020-03-08 00:00:00 | January, February, March
2020-01-12 00:00:00 | 2020-03-09 00:00:00 | January, February, March
2020-01-13 00:00:00 | 2020-03-10 00:00:00 | January, February, March
2020-01-14 00:00:00 | 2020-06-16 00:00:00 | January, February, March, April, May, June
Spreadsheet: 552119d1513301848-issue-dealing-with-simple-excel-issue-formula-and-pivot-exercise
Sheet: Pivot

Ind | Customer
ACAD | BMSI -Biomedical Sciences Institute
 | BMSI -Biomedical Sciences Institute R
 | Nanyang Technological University
 | Nanyang Technological University-RRR
 | Singapore Polytechnic
ACAD Total
OTRS | Cesco Environmental Technologies Pte Ltd
OTRS Total
PHAR | [NAME]
 | [NAME], Singapore Branch
 | Fisher Scientific Pte Ltd
 | Fluidigm Singapore Pte Ltd
 | Illumina Singapore Pte Ltd
 | JMS Singapore Pte Ltd
 | Lion TCR Pte Ltd
 | Lonza Biologics Tuas Pte Ltd
 | PPD Global Central Lab
 | Tessa Therapeutics Pte Ltd
PHAR Total
SI | Cesco Pipeline Technologies Pte Ltd
SI Total
TEST | Bio-Rad Laboratories (S) Pte Ltd
 | National Neuroscience Institute
TEST Total
(blank) | (blank)
(blank) Total
Grand Total
Spreadsheet: 146415d1332173612-excel-2007-conditional-formatting-a-date-occuring-info
Sheet: Sheet1

NAME | Employee # | R&B Eligible | R&B Allowance | HIRE DATE | RE- APPROVAL DATE
Person 1 | 11030 | Yes | 80.73 | 2010-04-01 00:00:00
Person 2 | 11031 | Yes | 33.63 | 2011-06-06 00:00:00
Person 3 | 11032 | Yes | 31.83 | 2001-10-04 00:00:00
Person 4 | 11033 | Yes | 77.02 | 2011-05-04 00:00:00
Person 5 | 11034 | Yes | 25.25 | 2011-12-31 00:00:00
Spreadsheet: 323c8e52-a966-4f1f-a0a6-0a5350e9e108
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
2750 | 15499 | Monika | Kadlecova | SVK | 92 | 00:18:20 | 00:00:00 | 00:26:11 | 00:00:00 | 00:22:07 | 1 | 01:06:38
2750 | 11121 | Angelika | Perfler | AUT | 91 | 00:17:42 | 00:00:00 | 00:26:59 | 00:00:00 | 00:23:54 | 2 | [NAME]
2750 | 15478 | Beatrice | Wondratschek | GER | 93 | 00:18:17 | 00:00:00 | 00:28:32 | 00:00:00 | 00:24:52 | 3 | 01:11:43
Spreadsheet: 216958d1361937102-multi-conditional-lookup-multi-conditional
Sheet: Sheet2

PRODUCTIVITY | WEEK 1 |  |  |  |  |  |  |  | PRODUCTIVITY | WEEK 2
Name |  |  |  |  |  |  | AVERAGE |  | Name |  |  |  |  |  | AVERAGE
 | 2013-02-01 00:00:00 | 2013-02-04 00:00:00 | 2013-02-05 00:00:00 | 2013-02-06 00:00:00 | 2013-02-07 00:00:00 | 2013-02-08 00:00:00 |  |  |  | 2013-02-11 00:00:00
[NAME], [NAME] |  |  |  |  |  |  |  |  | [NAME], [NAME]
Aviles, [NAME] |  |  |  |  |  |  |  |  | Aviles, [NAME]
Baylongo, [NAME]. Lourdes |  |  |  |  |  |  |  |  | Baylongo, [NAME]. Lourdes
[NAME], [NAME] |  |  |  |  |  |  |  |  | [NAME], [NAME]
Feraldo, Christian |  |  |  |  |  |  |  |  | Feraldo, Christian
Follosco, [NAME] |  |  |  |  |  |  |  |  | Follosco, [NAME]
[NAME], Judi |  |  |  |  |  |  |  |  | [NAME], Judi
[NAME], Guino Christer |  |  |  |  |  |  |  |  | [NAME], Guino Christer
Jonas, [NAME] |  |  |  |  |  |  |  |  | Jonas, [NAME]
Lim, Marianne |  |  |  |  |  |  |  |  | Lim, Marianne
[NAME], [NAME] |  |  |  |  |  |  |  |  | [NAME], [NAME]
Sagun, [NAME] |  |  |  |  |  |  |  |  | Sagun, [NAME]
[NAME], [NAME] |  |  |  |  |  |  |  |  | [NAME], [NAME]
[NAME], Rowena |  |  |  |  |  |  |  |  | [NAME], Rowena
Veluz, Kristine |  |  |  |  |  |  |  |  | Veluz, Kristine
Spreadsheet: 166945d1341851127-adding-multiple-results-using-vlookup-sample-workbook
Sheet: Employee&Dept

Name of Employees | Departments
[NAME] | HR&L
[NAME] | Cross [NAME]
[NAME] | Internal Audit
[NAME] | Accounts
[NAME] | DMU
Annetta Mattocks-McLean | Registry
[NAME] | Credit
[NAME] | Portmore Branch
[NAME] | MIS
[NAME] | HWT Branch
[NAME] | CSU
[NAME] | Marketing Dept.
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Jodi-[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Krystal Roper
[NAME]
Marlet Fender
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Nkachi Reeves
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Sharna Ramsay
Shayon South
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Taeise Hill
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Trudi-[NAME]
Trudi-[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Venese Wright
[NAME]
Lamay Virgo
Denmor Minto
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 215841d1361508267-summing-up-a-range-based-on-a-criteria-smittz32
Sheet: Sheet1

Name | Value |  |  |  |  | Sum of Value
[NAME] | 2 |  | [NAME] | 3 |  | Name | Total
[NAME] | 4 |  | [NAME] | 6 |  | [NAME] | 6
[NAME] | 3 |  | [NAME] | 3 |  | [NAME] | 3
[NAME] | 1 |  |  |  |  | [NAME] | 3
[NAME] | 2 |  |  |  |  | Grand Total | 12
Spreadsheet: 151058d1334767614-office-2003-current-date-in-excel-working-hours
Sheet: Blad1

 |  |  | Working Date |  |  |  | 2012-04-18 00:00:00
 |  |  | Working Hours
Total Working Hours This week
Date | Hour
2012-04-06 00:00:00 | 2
2012-04-07 00:00:00 | 3
2012-04-08 00:00:00 | 5
2012-04-09 00:00:00 | 6
2012-04-10 00:00:00 | 12
2012-04-11 00:00:00 | 3
2012-04-12 00:00:00 | 16
2012-04-13 00:00:00 | 30
2012-04-14 00:00:00 | 3
2012-04-15 00:00:00 | 1
2012-04-16 00:00:00 | 6
2012-04-17 00:00:00 | 3
2012-04-18 00:00:00 | 23
t
t
Spreadsheet: 95431d1295020787-excel-2007-automatically-update-master-sheet-with-information-from-other-sheets-practice-workbook
Sheet: Sheet2

STATUS TRACKER ACFT 99-0001
IMP | STATUS | BOT | ETIC | P+ | BRK WUC | INT | NARRATIVE
 | POSSESION | FIX TIME |  |  | FIX WUC
 | NMCMC | 26 JAN 2300 | 28 JAN 1900 (1) | 4 | 23Z00 | ZZZ | PASSENGER THREW UP IN AISLE
 | CC
 | FMC | 28 JAN 1700 |  |  | 23ZB0 | TWS | CLEANED UP THROW UP
 | CC
 | FMC
 | CC
 | FMC
 | CC
 | FMC
 | CC
 | FMC
 | CC
 | FMC
 | CC
 | FMC
 | CC
 | FMC
 | CC
 | FMC
 | CC
 | FMC
 | CC
 | FMC
 | CC
 | FMC
 | CC
 | FMC
 | CC
 | FMC
 | CC
 | FMC
 | CC
 | FMC
 | CC
 | FMC
 | CC
 | FMC
 | CC
Spreadsheet: 159532d1338733690-count-different-values-in-same-column-with-multiple-criteria-count_-mult_criteria_same_column
Sheet: Sheet1

 |  |  | C1 | C2
 |  |  | R | A |  | =COUNTIFS(Table1[C1];"R";Table1[C2];"x")
 |  |  | R | B
 |  |  | R | C |  | =COUNTIFS(Table1[C1];"R";Table1[C2];"<>"&"x")
 |  |  | R | -
 |  |  | R | x |  | Count C2 items where C1 = "R" and C2 <>"x" and C2 <>"-"
 |  |  | R | x
 |  |  | R | x
 |  |  | P
 |  |  | P
 |  |  | P