tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 162479d1339923051-tournament-ranking-problem-euros2012
Sheet: Sheet1

Match results
GROUP A |  |  |  |  | Goals Table |  |  |  |  |  |  | Points Table
Poland | 1 | 1 | Greece |  | Goals | POL | GRE | RUS | CZR | Total |  | Points | POL | GRE | RUS | CZR | Total | Rank
Russia | 4 | 1 | Czech Republic |  | POL |  | 1 | 1 | 0 |  |  | POL |  | 1 | 1 | 0 |  | 4
Greece | 1 | 2 | Czech Republic |  | GRE | 1 |  | 1 | 1 |  |  | GRE | 1 |  | 3 | 0 |  | 3
Poland | 1 | 1 | Russia |  | RUS | 1 | 0 |  | 4 |  |  | RUS | 1 | 0 |  | 3 |  | 2
Greece | 1 | 0 | Russia |  | CZR | 1 | 2 | 1 |  |  |  | CZR | 3 | 3 | 0 |  |  | 1
Czech Republic | 1 | 0 | Poland
 |  |  |  |  |  | GOALS |  |  |  |  |  |  |  |  |  | Points:
 |  | Rank | GROUP A |  | Pts | For | Against | Diff. |  |  |  |  |  |  |  | Win= | 3 points
 |  | 1 | Czech Republic |  | 6 | 4 | 5 |  |  |  |  |  |  |  |  | Draw= | 1 point
 |  | 2 | Russia |  | 4 | 5 | 3
 |  | 3 | Greece |  | 4 | 3 | 3
 |  | 4 | Poland |  | 2 | 2 | 3
Old Rule |  |  | Russia finish ahead of Greece having a better goal difference.
(as table above)
New Rule |  |  | Greece finish above Russia because in the game played between them, Greece won.
Spreadsheet: 112419d1308573497-creating-a-matrix-from-a-database-sandy24_data
Sheet: Sheet1

PLAYER | PLAYER | PLAYER | PLAYER | PLAYER | PERF SCORE
25 | 44 | [NAME] | 69 | 7 | 6
16 | 808 | 1313 | 10 | 1701 | -4
00 | 69 | 12 | XIII | x86_64 | -4
25 | 10 | 44 | [NAME] | 7 | 4
16 | 808 | 1313 | [NAME] | 1701 | -3
00 | 12 | 69 | XIII | 10 | -4
25 | x86_64 | [NAME] | 44 | 7 | 1
16 | 808 | 12 | 1313 | 1701 | -5
00 | XIII | 69 | 10 | 1701 | -3
25 | 44 | x86_64 | [NAME] | 7 | 8
16 | 12 | 808 | 1313 | 1701 | -1
00 | x86_64 | 69 | XIII | 10 | 0
25 | [NAME] | 44 | 12 | 7 | 3
16 | 808 | 1313 | 10 | 1701 | 1
00 | XIII | 69 | [NAME] | x86_64 | 3
25 | 10 | 44 | 69 | 7 | 3
16 | 808 | 12 | 1313 | 1701 | 3
00 | [NAME] | 44 | 1313 | 7 | 4
00 | 10 | 25 | XIII | 7 | -9
16 | x86_64 | 10 | XIII | [NAME] | 1
25 | 1313 | 44 | XIII | 7 | 0
 | [NAME] | 1701 | 00 | 7 | 10 | 12 | 16 | 25 | 44 | 69 | 808 | 1313 | XIII | X86_64
[NAME]
1701
00
7
10
12
16
25
44
69
808
1313
XIII
X86_64
Spreadsheet: 466378d1466162509-i-would-just-like-to-add-two-more-players-sport_tournament_16_teams
Sheet: GroupD

GROUP D
 |  |  |  |  |  |  | Table |  |  |  |  |  |  |  |  |  |  |  | GP | W | D | L | GF | GA | [NAME] | PTS | rank
Team name | Bonus/penalty points
team1 |  |  |  |  |  |  |  | GP | W | D | L | GF | GA | [NAME] | PTS
team2
team3
team4
[NAME]
[NAME]
team7
team8
team9
team10
team11
team12
team13
team14
team15
team16
ROUND 1
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
ROUND 2
ROUND 3
ROUND 4
Spreadsheet: 288581d1389240074-conditional-formatting-to-achieve-traffic-light-results-for-3-different-values-product-review
Sheet: AFTER

Product Review
Code | Name | Last Reviewed |  | Code | Name | Last Reviewed
2251 | Test |  |  | 5651 | Test 3
2131 | Test 1 |  |  | 5654 | Test 4
2121 | Test 2 |  |  | 5152 | Test 5
Spreadsheet: 225653d1365078128-populate-data-based-on-cell-information-test
Sheet: Sheet2

TYPE | CODE | OTHER | PRICE |  | 1 | [NAME]
Buckle Only | 94972 | L/H | 9 |  | 2 | Buckle Only
Buckle Only | 94973 | R/H | 9 |  | 3 | Complete
Buckle Only | 95899 | n/a | 9.5 |  | 4 | Reel Only
Complete | 95286 | n/a | 13.5
Complete | 102047 | n/a | 13.5
Complete | 94787 | n/a | 14.5
Complete | 91074 | n/a | 18.5
Complete | 96809 | n/a | 26
Complete | 99765 | n/a | 28.5
Complete | 92618 | n/a | 29.5
Complete | 93202 | n/a | 29.5
Complete | 99052 | ORION 403134 | 29.5
Complete | 96876 | n/a | 32.5
Complete | 96174 | Suitable Alternative | 32.5
Complete | 94970 | n/a | 34
Complete | 94972 | L/H | 34
Complete | 94973 | R/H | 34
Reel Only | 95899 | n/a | 28.5
Reel Only | 97191 | n/a | 29.5
Reel Only | 94944 | n/a | 29.5
Reel Only | 105319 | n/a | 29.5
Reel Only | 94972 | L/H | 32.5
Reel Only | 94973 | R/H | 32.5
Reel Only | 99541 | n/a | 78
Spreadsheet: 681747d1591722766-find-column-number-for-max-value-based-on-dynamic-range-2020-06-09-oeldere2-wtrfilesx-681742d1591720757-find-column-number-for-max-value-based-on-dyn
Sheet: Sheet1

Name | January | February | March | April | tekst | Name: | [NAME]: | Highest Month
[NAME] | 35 | 26 | 19 | 41 |  | [NAME] |  |  |  | April
[NAME] | 23 | 44 | 40 | 36 |  | [NAME]
[NAME] | 17 | 47 | 50 | 29 |  | [NAME]
Spreadsheet: 44546d1243331020-automatic-week-commence-date-needed-weekly-business-master-main
Sheet: Expenses Detail

Day/Date | Receipt No. | Supplier | Product | Cost (inc vat) | Cost Group
 |  |  |  |  |  | ARE YOUR EXPENSES CORRECT? |  |  | YES
 |  |  |  |  |  |  | Wages (1) |  | Drinks Cost (4)
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | [NAME] (2) |  | Sundry Costs (5)
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | Advertising/PR (3) |  | Food Purchases (6)
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  | 0
Spreadsheet: 98019d1297114134-drop-down-selection-change-price-in-another-cell-copy-of-sample-bid
Sheet: Sheet1

 | Product | Quantity | Total | Price |  |  | [NAME]. | Divided | [NAME] | Storm Door |  |  | [NAME]. | 5
 | [NAME] | 1 | 1 | 15 |  |  | 7 | 8 | 6 | 10 |  |  | Divided | 10
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 15
 |  |  |  |  |  |  |  |  |  |  |  |  | Storm Door | 20
Spreadsheet: 836440d1689354891-cleanup-of-data-that-is-merged-by-client-and-requires-text-to-columns-and-transposing-cleanup
Sheet: Example 1

Client Account | Contact Names | Contact Emails
Client 1 | [NAME] | [EMAIL]
 | [NAME] | [EMAIL]
 | [NAME] | [EMAIL]
Client 2 | [NAME] | [EMAIL]
Client 3 | [NAME] 3;John Apple 4;John Apple 5;John Apple 6 | [EMAIL];[EMAIL];[EMAIL];[EMAIL]
 | [NAME] 3;John Apple 4;John Apple 5;John Apple 6 | [EMAIL];[EMAIL];[EMAIL];[EMAIL]
 | [NAME] 3;John Apple 4;John Apple 5;John Apple 6 | [EMAIL];[EMAIL];[EMAIL];[EMAIL]
 | [NAME] 3;John Apple 4;John Apple 5;John Apple 6 | [EMAIL];[EMAIL];[EMAIL];[EMAIL]
 | [NAME] 3;John Apple 4;John Apple 5;John Apple 6 | [EMAIL];[EMAIL];[EMAIL];[EMAIL]
 | [NAME] 3;John Apple 4;John Apple 5;John Apple 6 | [EMAIL];[EMAIL];[EMAIL];[EMAIL]
 | [NAME] 3;John Apple 4;John Apple 5;John Apple 6 | [EMAIL];[EMAIL];[EMAIL];[EMAIL]
 | [NAME] 3;John Apple 4;John Apple 5;John Apple 6 | [EMAIL];[EMAIL];[EMAIL];[EMAIL]
 | [NAME] 3;John Apple 4;John Apple 5;John Apple 6 | [EMAIL];[EMAIL];[EMAIL];[EMAIL]
 | [NAME] 3;John Apple 4;John Apple 5;John Apple 6 | [EMAIL];[EMAIL];[EMAIL];[EMAIL]
 | [NAME] 3;John Apple 4;John Apple 5;John Apple 6 | [EMAIL];[EMAIL];[EMAIL];[EMAIL]
 | [NAME] 3;John Apple 4;John Apple 5;John Apple 6 | [EMAIL];[EMAIL];[EMAIL];[EMAIL]
Client 4 | [NAME] 7;John Apple 8; [NAME] 9 | [NAME]
Spreadsheet: 834691d1687996680-replace-names-with-numbers-excel-help-
Sheet: Sheet1

FIRST WORKSHEET
Sample assessment
This is what we receive from the company that provides the assessments (Excel form)
STUDENT  ASSESSMENT IDENTIFICATION NUMBER | Student  Name | Test A Score | Test B Score | Test B Score | Test B Score
issued by the company preparing the test
12345678 | [NAME] | 23 | 14 | 450 | 1
23456789 | [NAME] | 57 | 9 | 345 | 2
SECOND WORKSHEET
This is the data that our SIS provides
STUDENT IDENTIFICATION NUMBER
87654321 | [NAME]
98765432 | [NAME]
OK, here's the issue.  We need to report the data in Worksheet #1 but can not submit names.  So in place of the names
we need to use our Student Identification number.
Spreadsheet: 117540d1312854079-compare-two-columns-as-a-percentage-inspectors-pass-fail
Sheet: Sheet1

Inspector | No of inspections | No of Passes | No of fails | Pass fail rate |  |  |  | Totals
289 | 1 | 1 |  |  |  |  |  | Inspections
270 | 1 | 0 | 1 |  |  |  |  | Passes
296 | 2 | 0 | 2 |  |  |  |  | Fails Pass Fail rate
268 | 1 |  | 1
G702 | 2 | 2
272 | 2 | 2
339 | 1 | 1
Spreadsheet: 703026d1604676175-vlookup-for-duplicate-row-duplicate
Sheet: Sheet1

Country | City | Remark 1 | Remark 2 | Remark 3 |  |  | Result 1 |  |  |  |  |  |  | Result 2
France | Saint-Denis | 3 | 3 | 0 |  |  | Country | City | Remark 1 | Remark 2 | Remark 3 |  |  | Country | City | Remark 1 | Remark 2 | Remark 3
France | Reims | 0 | 0 | 0
France | Toulon | 2 | 8 | 0
France | Angers | 0 | 0 | 0
France | Le Mans | 2 | 9 | 0
Russia | Moscow | 0 | 0 | 0
Russia | Saint Petersburg | 1 | 1 | 0
Russia | Krasnoyarsk | 3 | 3 | 0
Russia | Krasnodar | 1 | 5 | 0
Russia | Kemerovo | 0 | 0 | 0
UK | Birmingham | 0 | 0 | 0
UK | Bradford | 2 | 6 | 0
UK | Bristol | 1 | 1 | 0
UK | Cambridge | 0 | 0 | 0
UK | Carlisle | 1 | 1 | 0
USA | NEW YORK | 1 | 9 | 0
USA | TEXAS | 0 | 0 | 0
USA | Los Angeles | 0 | 0 | 0
USA | Columbus | 2 | 2 | 0
USA | Indianapolis | 0 | 0 | 0
USA | Denver | 2 | 2 | 0
Spreadsheet: 30702d1226397085-excel-2007-customer-retention-models-example-worksheet-v2
Sheet: Output

Output
 | % retained in
Customers joining in | August | September | October | November | December | January | February | March | April | May | June | July | August | September | October | November | December | January | February | March
August | 1 | 0.8 | 0.7 | 0.5 | 0.3 | 0.2 | 0.18 | 0.15 | 0.12 | 0.1 | 0.08 | 0.05 | 0 | 0.01 | 0.02 | 0
September |  | 1 | 0.7 | 0.6 | 0.5 | 0.4 | 0.35 | 0.3 | 0.25 | 0.2 | 0.15 | 0.1 | 0.05 | 0.03 | 0.05 | 0.02 | 0
October |  |  | 1 | 0.8 | 0.7 | 0.5 | 0.3 | 0.2 | 0.18 | 0.15 | 0.12 | 0.1 | 0.08 | 0.05 | 0 | 0.01 | 0.02 | 0
November |  |  |  | 1 | 0.7 | 0.6 | 0.5 | 0.4 | 0.35 | 0.3 | 0.25 | 0.2 | 0.15 | 0.1 | 0.05 | 0.03 | 0.05 | 0.02 | 0
December |  |  |  |  | 1 | 0.8 | 0.7 | 0.5 | 0.3 | 0.2 | 0.18 | 0.15 | 0.12 | 0.1 | 0.08 | 0.05 | 0 | 0.01 | 0.02 | 0
January |  |  |  |  |  | 1 | 0.7 | 0.6 | 0.5 | 0.4 | 0.35 | 0.3 | 0.25 | 0.2 | 0.15 | 0.1 | 0.05 | 0.03 | 0.05 | 0.02 | 0
February |  |  |  |  |  |  | 1 | 0.8 | 0.7 | 0.5 | 0.3 | 0.2 | 0.18 | 0.15 | 0.12 | 0.1 | 0.08 | 0.05 | 0 | 0.01 | 0.02 | 0
March |  |  |  |  |  |  |  | 1 | 0.7 | 0.6 | 0.5 | 0.4 | 0.35 | 0.3 | 0.25 | 0.2 | 0.15 | 0.1 | 0.05 | 0.03 | 0.05 | 0.02 | 0
April |  |  |  |  |  |  |  |  | 1 | 0.8 | 0.7 | 0.5 | 0.3 | 0.2 | 0.18 | 0.15 | 0.12 | 0.1 | 0.08 | 0.05 | 0 | 0.01 | 0.02 | 0
May |  |  |  |  |  |  |  |  |  | 1 | 0.7 | 0.6 | 0.5 | 0.4 | 0.35 | 0.3 | 0.25 | 0.2 | 0.15 | 0.1 | 0.05 | 0.03 | 0.05 | 0.02 | 0
June |  |  |  |  |  |  |  |  |  |  | 1 | 0.8 | 0.7 | 0.5 | 0.3 | 0.2 | 0.18 | 0.15 | 0.12 | 0.1 | 0.08 | 0.05 | 0 | 0.01 | 0.02 | 0
July |  |  |  |  |  |  |  |  |  |  |  | 1 | 0.7 | 0.6 | 0.5 | 0.4 | 0.35 | 0.3 | 0.25 | 0.2 | 0.15 | 0.1 | 0.05 | 0.03 | 0.05 | 0.02 | 0
Spreadsheet: 717209ea-51ca-4241-9768-e3ff113ec9f5
Sheet: Highly Expressed Genes

Supplementary Table S2b.  List of 32 highly expressed ASD genes identified.
FABP7
GNAS
GPX1
HNRNPH2
HRAS
PDZD4
RPL10
SEZ6L2
TSPAN7
MAP2
PRKCB
MEF2C
RAPGEF4
APC
DCX
RIMS3
GABRB3
HSD11B1L
[NAME]
GLO1
HLA-A
DLX1
[NAME]
CNR1
ADORA2A
PCDH10
NLGN3
RELN
CADM1
CADPS2
CDH22
DHCR7
Spreadsheet: 142319d1329772462-using-an-index-formula-to-reference-a-pivot-table-index-referencing-pivot-table-sample
Sheet: Sheet1

Facility | Month | Category | In Time/ Out Time |  |  | Count of Facility | Operation Month | Category | In Time/ Out Time
Site A | 2011-12-01 00:00:00 | 1 | In-time |  |  |  | 2011-12-01 00:00:00 |  |  |  |  |  | 2012-01-01 00:00:00
Site A | 2011-12-01 00:00:00 | 2 | In-time |  |  |  | 1 |  | 2 |  | 3 |  | 1 |  | 2 |  | 3
Site A | 2011-12-01 00:00:00 | 3 | In-time |  |  | Facility | In-time | Out-of-time | In-time | Out-of-time | In-time | Out-of-time | In-time | Out-of-time | In-time | Out-of-time | In-time | Out-of-time
Site A | 2011-12-01 00:00:00 | 1 | Out-of-time |  |  | Site A | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Site A | 2011-12-01 00:00:00 | 2 | Out-of-time |  |  | Site B | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1
Site A | 2011-12-01 00:00:00 | 3 | Out-of-time
Site A | 2011-12-01 00:00:00 | 2 | In-time
Site A | 2012-01-01 00:00:00 | 1 | In-time
Site A | 2012-01-01 00:00:00 | 2 | In-time
Site A | 2012-01-01 00:00:00 | 3 | In-time |  |  | Site | Month | Category | Total In-time
Site A | 2012-01-01 00:00:00 | 1 | Out-of-time |  |  | Site A | 2011-12-01 00:00:00 | 2 | ?????
Site A | 2012-01-01 00:00:00 | 2 | Out-of-time
Site A | 2012-01-01 00:00:00 | 3 | Out-of-time
Site B | 2011-12-01 00:00:00 | 2 | Out-of-time
Site B | 2011-12-01 00:00:00 | 1 | In-time
Site B | 2011-12-01 00:00:00 | 2 | In-time
Site B | 2011-12-01 00:00:00 | 3 | In-time
Site B | 2011-12-01 00:00:00 | 1 | Out-of-time
Site B | 2011-12-01 00:00:00 | 2 | Out-of-time
Site B | 2011-12-01 00:00:00 | 3 | Out-of-time
Site B | 2012-01-01 00:00:00 | 1 | In-time
Site B | 2012-01-01 00:00:00 | 2 | In-time
Site B | 2012-01-01 00:00:00 | 3 | In-time
Site B | 2012-01-01 00:00:00 | 2 | In-time
Site B | 2012-01-01 00:00:00 | 1 | Out-of-time
Site B | 2012-01-01 00:00:00 | 2 | Out-of-time
Site B | 2012-01-01 00:00:00 | 3 | Out-of-time
Spreadsheet: 69613d1270147061-unwanted-formatting-of-downloads-xmpl
Sheet: FAZ

 |  |  | 2010-03-23 00:00:00 | 13.84 | 2010-06-14 00:00:00 | 13.61 | 13.67 | 54,496,200 | 13.67
 |  |  | 2010-03-22 00:00:00 | 14.55 | 14.59 | 13.90 | 13.93 | 65,725,700 | 13.93
 |  |  | 2010-03-19 00:00:00 | 13.80 | 14.30 | 13.72 | 14.17 | 60,984,100 | 14.17
 |  |  | 2010-03-18 00:00:00 | 13.73 | 2010-09-14 00:00:00 | 13.70 | 13.87 | 52,759,800 | 13.87
 |  |  | 2010-03-17 00:00:00 | 13.99 | 2010-01-14 00:00:00 | 13.52 | 13.71 | 67,370,800 | 13.71
 |  |  | 2010-03-16 00:00:00 | 14.54 | 14.70 | 14.16 | 14.18 | 53,567,600 | 14.18
 |  |  | 2010-03-15 00:00:00 | 14.99 | 15.22 | 14.66 | 14.74 | 63,392,500 | 14.74
 |  |  | 2010-03-12 00:00:00 | 14.30 | 14.92 | 14.25 | 14.65 | 65,973,700 | 14.65
 |  |  | 2010-03-11 00:00:00 | 2010-11-15 00:00:00 | 15.15 | 14.62 | 14.64 | 60,313,100 | 14.64
 |  |  | 2010-03-10 00:00:00 | 15.24 | 15.33 | 14.78 | 14.98 | 78,721,400 | 14.98
 |  |  | 2010-03-09 00:00:00 | 15.90 | 2010-01-16 00:00:00 | 15.21 | 15.54 | 65,274,300 | 15.54
 |  |  | 2010-03-08 00:00:00 | 15.77 | 15.82 | 15.55 | 15.66 | 36,778,700 | 15.66
 |  |  | 2010-03-05 00:00:00 | 16.55 | 16.66 | 15.77 | 15.84 | 67,997,500 | 15.84
 |  |  | 2010-03-04 00:00:00 | 17.17 | 17.26 | 16.81 | 16.87 | 44,368,500 | 16.87
 |  |  | 2010-03-03 00:00:00 | 17.22 | 17.41 | 16.88 | 17.30 | 49,107,100 | 17.30
 |  |  | 2010-03-02 00:00:00 | 17.36 | 17.38 | 16.88 | 17.24 | 57,720,400 | 17.24
 |  |  | 2010-03-01 00:00:00 | 17.48 | 17.69 | 17.34 | 17.48 | 41,113,300 | 17.48
 |  |  | 2010-02-26 00:00:00 | 17.93 | 18.18 | 17.46 | 17.65 | 50,833,100 | 17.65
 |  |  | 2010-02-25 00:00:00 | 18.40 | 18.75 | 17.90 | 17.91 | 76,544,900 | 17.91
 |  |  | 2010-02-24 00:00:00 | 18.63 | 18.63 | 17.73 | 17.79 | 65,476,100 | 17.79
 |  |  | 2010-02-23 00:00:00 | 18.00 | 18.84 | 17.64 | 18.65 | 74,605,300 | 18.65
 |  |  | 2010-02-22 00:00:00 | 18.19 | 18.28 | 17.50 | 17.85 | 56,528,400 | 17.85
Spreadsheet: 714812d1611384807-google-sheets-countifs-and-sumif-formulas-returning-0-copy-of-terrenos-familia-4-
Sheet: Vista Cibeles #98

 | VISTA CIBELES #98 |  |  | Renta
 |  |  |  | Meses rentados |  |  | Gastos
 |  |  |  | Ingresos |  |  | Ingresos
 |  |  |  |  |  |  | [NAME]
 | Fecha de pago | Propriedad | Persona | Descripcion | [NAME] | Monto | Recibo/Factura | Comentarios
Spreadsheet: 703130d1604771875-maximum-sum-in-a-column-with-a-criterion-glenns-saturday-puzzle
Sheet: Sheet2

Block A |  |  |  |  |  |  | Block B |  |  |  |  |  |  | Block C |  |  |  |  |  |  | Block D
Company | Name | Sales |  |  |  |  | Company | Name | Sales |  |  |  |  | Company | Name | Sales |  |  |  |  | Company | Name | Sales
A | Ana | 174 |  | Name | Amount |  | A | Ana | 174 |  | Name | Amount |  | A | Ana | 174 |  | Name | Amount |  | A | Ana | 174 |  | Name | Amount
A | [NAME] | 174 |  |  |  |  | A | [NAME] | 174 |  |  |  |  | A | [NAME] | 174 |  |  |  |  | A | [NAME] | 174
A | [NAME] | 25 |  |  |  |  | A | [NAME] | 25 |  |  |  |  | A | [NAME] | 25 |  |  |  |  | A | [NAME] | 25
A | [NAME] | 96 |  |  |  |  | A | [NAME] | 1004 |  |  |  |  | A | [NAME] | 100000 |  |  |  |  | A | [NAME] | 1000000
A | [NAME] | 100 |  |  |  |  | A | [NAME] | 1000 |  |  |  |  | A | [NAME] | 100000 |  |  |  |  | A | [NAME] | 1000000
A | [NAME] | 45 |  |  |  |  | A | [NAME] | 45 |  |  |  |  | A | [NAME] | 45 |  |  |  |  | A | [NAME] | 45
B | [NAME] | 541 |  |  |  |  | B | [NAME] | 541 |  |  |  |  | B | [NAME] | 541 |  |  |  |  | B | [NAME] | 541
B | Ana | 54 |  |  |  |  | B | Ana | 54 |  |  |  |  | B | Ana | 54 |  |  |  |  | B | Ana | 54
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Block E
 |  | 98 |  | Exact |  |  |  |  |  |  |  |  |  | Company | Name | Sales
 |  |  |  | Less than |  |  |  |  |  |  |  |  |  | A | Ana | 174 |  | Name | Amount
 |  |  |  | Greater |  |  |  |  |  |  |  |  |  | A | [NAME] | 174
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A | [NAME] | 25
 |  |  |  | Exact |  |  |  |  |  |  |  |  |  | A | [NAME] | 100000
 |  |  |  | Less than |  |  |  |  |  |  |  |  |  | A | [NAME] | 100000
 |  |  |  | Greater |  |  |  |  |  |  |  |  |  | A | [NAME] | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  | B | [NAME] | 541
 |  |  |  |  |  |  |  |  |  |  |  |  |  | B | Ana | 54
Spreadsheet: 885245d1734687201-date-of-birth-and-gender-identifucation-excel-forum-id-number-jt-
Sheet: Sheet1

 | National Identity Number
 |  |  | 6 Digits from L/H | Gender
 | 8111146100141 |  | 811114 | 6100 | Male
 | 8811131100150 |  | 881113 | 1100 | Female
TABLE
Name | ID No# |  | DATE OF BIRTH | GENDER
[NAME] | [PHONE] |  | 1981-11-14 00:00:00 | Male
[NAME] | [PHONE] |  | 2013-11-13 00:00:00 | Female
[NAME] | [PHONE] |  | 2000-11-13 00:00:00 | Female
[NAME] | [PHONE] |  | 2024-11-13 00:00:00 | Female
Spreadsheet: 63fdb613-72ab-4f7e-a450-52acf31ab023
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
258966 | 44213 | Victoria | [NAME] | GBR |  | 00:55:31 | 00:01:15 | 01:42:21 | 00:01:20 | 00:30:19 | 1 | 03:10:45
258966 | 63948 | Steffi | [NAME] | GER |  | 00:57:47 | 00:01:13 | 01:47:11 | 00:01:18 | 00:31:27 | 2 | 03:18:55
258966 | 71564 | [NAME] | [NAME] | GER |  | 01:04:14 | 00:01:24 | 01:49:13 | 00:02:05 | 00:34:16 | 3 | 03:31:09
258966 | 71563 | [NAME] | Paterink | NED |  | 01:03:40 | 00:01:31 | 01:47:44 | 00:02:08 | 00:36:46 | 4 | [NAME]
258966 | 57190 | Suzanne | Vanderwijst | NED |  | 01:10:55 | 00:01:44 | 01:56:31 | 00:01:45 | 00:38:07 | 5 | 03:49:01
Spreadsheet: 258793d1376854846-adult-baseball-league-schedule-2013fall-schedule-1-
Sheet: REDWINGS

Game # | week # | Visitors | Home | Field
3 | 1 | TIGERS | REDWINGS | LBU
10 | 2 | MUDCATS | REDWINGS | [NAME]
7 | 2 | SEADOGS | REDWINGS | LBU
14 | 3 | REDWINGS | MUDCATS | CCC
17 | 3 | REDWINGS | TIGERS | [NAME]
20 | 4 | REDWINGS | KEYS | CCC
27 | 5 | SENATORS | REDWINGS | LBU
29 | 5 | REDWINGS | SEADOGS | [NAME]
32 | 6 | REDWINGS | BAYSOX | LBU
37 | 7 | BYE | REDWINGS
Spreadsheet: 809253d1670992074-attendance-tracker-pto-tracker-ex
Sheet: Tracker

 | Tracker
 |  |  |  |  |  |  | X | PTO Approved
 | Name | Vacation start | Vacation end | Type | Days |  | N | Not approved
 | Employee 1 | 2023-01-04 00:00:00 | 2023-01-10 00:00:00 | X
 | Employee 6 | 2023-01-13 00:00:00 | 2023-01-18 00:00:00 | N
 | Employee 33 | 2023-01-09 00:00:00 | 2023-01-09 00:00:00 | X
 | Employee 23 | 2023-01-23 00:00:00 | 2023-01-29 00:00:00 | X
 | Employee 31 | 2023-02-08 00:00:00 | 2023-02-12 00:00:00 | X
 | Employee 51 | 2023-02-15 00:00:00 | 2023-02-23 00:00:00 | X
Spreadsheet: 832482d1686349753-lookup-to-return-values-if-asterix-is-present-s666-pq-lookup-to-return-values-if-asterix-is-present
Sheet: Sheet1

Required? | Fruit | Colour |  | Fruit | Colour
* | apple | blue |  | apple | blue
 | pear | green |  | orange | yellow
* | orange | yellow |  | kiwi | orange
 | grape | pink |  | mango | red
* | kiwi | orange
* | mango | red
Spreadsheet: 47065db9-76c6-4dec-8f27-452953837d52
Sheet: CSSF

Cost per Square Foot
Month Reported | 2011-10-01 00:00:00
Facility Type | NC AVG + 1STD | [NAME]
Athletic | 315 | 188
Auditorium/Theater | 536 | 359
Classroom, General | 393 | 221
Classroom, Medical/Healthcare | 364 | 255
Food Service | 313 | 226
Healthcare Facility, Clinic | 398 | 167
Healthcare Facility, Hospital | 426 | 340
Housing, Apartments | 170 | 81
Housing, Dormitory | 233 | 154
Laboratory, General | 484 | 374
Laboratory, Medical/Healthcare | 644 | 534
Library/Study Facilities | 317 | 183
Office, General | 260 | 122
Office, High Rise | 219 | 117
Office, Technology | 412 | 386
Other | 402 | 178
Parking | 62 | 0
Physical Plant | 587 | 289
Student Center | 393 | 141
Spreadsheet: 121465d1316084740-automatically-fill-data-depending-on-choice-from-drop-down-menu-excel-help-solved
Sheet: CL. Hungary Bulgaria Romania

Reporting Period: |  | P08 |  |  | HR Scorecard
 |  |  |  |  | Key Performance Indicator
 | Result Level: |  | Please Select Required Level | KPI Definition
 |  |  | KPIs | Unit | P 08/11 | P 09/11 | P 10/11 | P 11/11 | P 12/12 | Target | Comment
 |  |  |  | % | 3 | 6 | 7 | 8 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Please Select Required Level
 |  |  |  | % |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SE Region
 |  |  |  | % | 3 | 6 | 7 | 8 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cluster Italy/Spain
 |  |  |  | % | 3 | 6 | 7 | 8 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cluster Portugal
 |  |  |  | % | 3 | 6 | 7 | 8 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cluster Hungary/Bulgaria/Romania
 |  |  |  | % | 3 | 6 | 7 | 8 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cluster Israel/Greece/Cyprus/Malta/Albania
 |  |  |  | € | 3 | 6 | 7 | 8 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cluster Hungary/Bulgaria/Romania
 |  |  |  | Avearge number | 3 | 6 | 7 | 8 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | % | 3 | 6 | 7 | 8 | 6
 |  |  |  | Avearge number | 3 | 6 | 7 | 8 | 6
 |  |  |  | % | 3 | 6 | 7 | 8 | 6
 |  |  |  | % | 3 | 6 | 7 | 8 | 6
 |  |  |  | % | 3 | 6 | 7 | 8 | 6
 |  |  |  | % | 3 | 6 | 7 | 8 | 6
 |  |  |  | % | 3 | 6 | 7 | 8 | 6
 |  |  |  | % | 3 | 6 | 7 | 8 | 6
 |  |  |  |  | 3 | 6 | 7 | 8 | 6
 |  |  |  | % | 3 | 6 | 7 | 8 | 6
Spreadsheet: 45404d1244131175-matching-and-copying-data-from-one-worksheet-to-another-sample
Sheet: Inventory

Number | Application1 | Application2 | Application3 | Application4 | Application5
104-01189A | Green 83-86
104-01283 | Orange 88-89
104-01338A | Blue 90-92 AA
104-01338B | Blue 90-92 exc. AA
104-01360A | Red 91-92 | Red 93-94
104-01360A | Red 91-92 | Red 93-94
104-01360C
Spreadsheet: 884178d1733242864-match-break-time-with-time-zone-timezoneproblem
Sheet: Sheet1

Employee | Position | Time Zone | Sunday | Sunday Break (Eastern Time Zone) | [NAME] (their time zone)
Employee A | P1 | PHST | 08:00 AM - 07:00 PM | 1:00 PM - 2:00 PM | 2:00:00 AM -3:00 PM | expected result
Employee B | P2 | CST | 07:00 AM - 05:00 PM | 11:00 AM - 12:00 PM | 10:00 AM - 11:00 AM | expected result
Employee C | P3 | PHST | 07:00 AM - 06:00 PM | 12:00 PM - 1:00 PM | 1:00:00 AM - 2:00 AM | expected result