tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 766488d1643904997-vba-compare-copy-and-delete-list-text-from-different-sheets-bendt-skov-
Sheet: Rawdata

Company A | Street | PO | City | Country | Phone | Mail | www | Text |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All with Excists are lines which are in Total, and they shouls be copied into a line below this one
Company K |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All with New means that they are not in Total
Company B |  | PO | City | Country | Phone
Company L |  | PO | City | Country | Phone | Mail | www | Text
Company D | Street
Company F |  | PO | City | Country | Phone | Mail | www | Text
Company M | Street | PO | City | Country | Phone | Mail | www | Text
Company H | Street | PO | City |  | Phone
Company N |  |  | City |  | Phone | Mail |  | Text
Company I |  |  | City |  | Phone | Mail |  | Text
Company J |  | PO | City |  | Phone | Mail |  | Text
Company O | Street | PO | City | Country | Phone | Mail |  | Text
Spreadsheet: 66029d1266641844-excel-2007-line-graph-sample
Sheet: Sheet1

 | 19909
-6.50666189193726 | 2005-05-01 00:00:00
-2.13555979728699 | 2005-06-01 00:00:00
-1.0174275636673 | 2005-06-15 00:00:00
0.0788929611444473 | 2005-07-01 00:00:00
 | 7499
-8.16868305206299 | 2005-03-01 00:00:00
-6.01322650909424 | 2005-03-15 00:00:00
-5.87454891204834 | 2005-04-01 00:00:00
-3.97594118118286 | 2005-05-01 00:00:00
-1.56829965114594 | 2005-06-01 00:00:00
-0.653355181217194 | 2005-06-15 00:00:00
Spreadsheet: 46654d1245540376-help-with-employee-database-employees
Sheet: Sheet1

EEO Report
Name | Sex | Race | Birthdate | Hire Date | Salary
[NAME], Desma | Female | African American | 1972-06-18 00:00:00 | 1992-08-14 00:00:00 | 24000
Green, [NAME] | Female | African American | 1970-07-01 00:00:00 | 1990-04-26 00:00:00 | 45000
[NAME], [NAME] | Male | African American | 1950-05-01 00:00:00 | 1988-07-12 00:00:00 | 48600
[NAME], [NAME] | Male | African American | 1968-10-31 00:00:00 | 1986-08-01 00:00:00 | 68000
Sylla, Shella | Female | African American | 1966-02-03 00:00:00 | 1983-10-25 00:00:00 | 85000
An, Bok | Male | Asian American | 1968-12-15 00:00:00 | 1987-07-12 00:00:00 | 52000
[NAME], Pamit | Male | Asian American | 1947-10-01 00:00:00 | 1980-01-15 00:00:00 | 52300
Shah, [NAME] | Female | Asian American | 1962-01-31 00:00:00 | 1985-06-04 00:00:00 | 56000
Chandra, Lavina | Female | Asian American | 1957-11-11 00:00:00 | 1989-10-15 00:00:00 | 62500
Fernandez, [NAME] | Male | Hispanic | 1975-12-01 00:00:00 | 1992-07-12 00:00:00 | 18900
Costo, Bianca | Female | Hispanic | 1970-06-12 00:00:00 | 1992-12-04 00:00:00 | 28000
Lugones, [NAME] | Male | Hispanic | 1971-09-28 00:00:00 | 1991-05-17 00:00:00 | 29900
[NAME], [NAME] | Male | Hispanic | 1955-03-03 00:00:00 | 1988-05-22 00:00:00 | 55000
Hernandez, [NAME] | Female | Hispanic | 1958-04-01 00:00:00 | 1983-05-04 00:00:00 | 65000
[NAME], [NAME] | Male | Non-Hispanic White | 1967-04-03 00:00:00 | 1990-04-17 00:00:00 | 32000
Solis, Jennifer | Female | Non-Hispanic White | 1960-02-02 00:00:00 | 1991-11-03 00:00:00 | 38500
[NAME], [NAME] | Male | Non-Hispanic White | 1941-04-18 00:00:00 | 1989-04-20 00:00:00 | 45500
Cornell, [NAME] | Male | Non-Hispanic White | 1942-10-12 00:00:00 | 1988-09-27 00:00:00 | 47500
[NAME], [NAME] | Male | Non-Hispanic White | 1941-08-22 00:00:00 | 1986-07-08 00:00:00 | 58500
Kinzer, Jessica | Female | Non-Hispanic White | 1962-05-31 00:00:00 | 1984-03-12 00:00:00 | 68500
Adler, [NAME] | Female | Non-Hispanic White | 1973-05-22 00:00:00 | 1982-09-25 00:00:00 | 85000
Race | Number of Employees | Average Salary
African American |  | 54120
Asian American |  | 55700
Hispanic |  | 39360
Non-Hispanic |  | 53642.85714285714
Income Group
$50,000 to $60,000
Hired
Females before 1/1/85
Spreadsheet: 851140d1701366797-athletics-spread-sheet-find-winner-athletics-spreadsheet-attempt-1-ans-3-croy79-
Sheet: Age Champ

 | AGE CHAMPS
 | STUDENT NAME | AGE GROUP | GENDER | HOUSE | POINTS
Winner |  | [NAME] | BOY
 |  | [NAME] | BOY
[NAME] Up |  | [NAME] | BOY
 |  | [NAME] | BOY
Winner |  | [NAME] | GIRL
[NAME] Up
Winner |  | 9YRS | BOY
[NAME] Up
Winner |  | 9YRS | GIRL
[NAME] Up
Winner |  | 10YRS | BOY
[NAME] Up
Winner |  | 10YRS | GIRL
[NAME] Up
Winner |  | 11YRS | BOY
[NAME] Up
Winner |  | 11YRS | GIRL
[NAME] Up
Winner |  | 12YRS | BOY
[NAME] Up
Winner |  | 12YRS | GIRL
[NAME] Up
Spreadsheet: 741544d1627116960-counting-items-taking-more-than-stipulated-time-between-batch-productions-counting-sample-copy
Sheet: Sheet1

Item | Batch | Production Date | [NAME] | Time from expiry to next batch production
[NAME] | 1 | 2021-01-12 00:00:00 | 2021-01-28 00:00:00 | NA
YYY | 1 | 2021-01-03 00:00:00 | 2021-01-06 00:00:00 | NA
ZZZ | 1 | 2021-01-02 00:00:00 | 2021-01-10 00:00:00 | NA
[NAME] | 2 | 2021-02-28 00:00:00 | 2021-02-28 00:00:00
ZZZ | 2 | 2021-01-12 00:00:00 | 2021-01-28 00:00:00
ZZZ | 3 | 2021-03-02 00:00:00 | 2021-03-10 00:00:00
YYY | 2 | 2021-01-12 00:00:00 | 2021-01-18 00:00:00
 |  |  |  | Count of items taking more than 25 days for production of next batch
Spreadsheet: 825455d1681321480-what-s-is-a-simple-formula-to-add-12-24-from-another-worksheet-ak-sample3
Sheet: COVER-24

 | AK |  |  |  |  |  | unlock 1111 |  |  |  |  |  |  | combo | Cover
Well No. | 12H | 13H | 14H | 15H | Total |  |  |  |  |  |  |  |  | combo
Start Date: |  |  |  |  |  |  |  |  |  |  |  |  |  | combo
Online/Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  | combo
Choke |  |  |  |  |  |  |  |  |  |  |  |  |  | lt f
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | lt p
Casing PSI |  |  |  |  |  |  | Copy and paste table into email body |  |  |  |  |  |  | fork
Surface Csg |  |  |  |  |  |  |  |  |  |  |  |  |  | lift
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | trash
Water / Day |  |  |  |  |  | Clear | enter water totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | ft
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | ft
Oil / Day |  |  |  |  |  |  | enter oil totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | plug C
[NAME] to sales |  |  |  |  |  |  |  |  |  |  |  |  |  | plug C
Gas / Day |  |  |  |  |  |  | enter gas totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | plug C
Inj / Day | off | off | off |  |  |  |  |  |  |  |  |  |  | st
 |  |  |  |  |  |  |  |  |  |  |  |  |  | st
Yesterday Lact |  |  |  |  |  |  |  |  |  |  |  |  |  | st
Comments | Hello how are you? Oh Im doing ok. XXXX OPEN WELL XX/128  S/I XXXX psi. Going to the store, I'll be back soon. see you soon. |  |  |  |  |  | gfhghcghghgvhvgvgvhgvhvghvgvgh
 | PM
 | 12H | 13H | 14H | 15H
GAS
WATER
OIL
 | AM |  |  |  |  |  | lact total
 | 12H | 13H | 14H | 15H |  |  | 0430 | 24 b4 |  |  |  |  | IF(g28-h28<0,0,g28-h28)
GAS |  |  |  |  |  | 750 |  | 118029
WATER |  |  |  |  |  | 760
OIL |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | 0
Spreadsheet: benjamin_rogers__1308__site_visit_schedule for Dave Kristich
Sheet: Confirm - Cinergy

 |  | Company | Cinergy
 |  | Company Contact & Number | [NAME] (713) 427-5228
 |  | Site or Sites | [NAME]
 |  | Site Visit Date | Tuesday October 24th
 |  | Directions to Hotels/Site | See DealBench - Due Diligence List/Plant Pictures Section
 |  | Meeting Time/Place | Tuesday Morning
 |  |  | Gleason Plant
 |  |  | 1166 [NAME].
 |  |  | Gleason, TN 38229
 |  | Enron Site Visit Coordinator | [NAME]
 |  |  | Work: (713) 853-7626 / Cell: (713) 515-9477
 |  |  | [NAME] Manager
 |  |  | Work: (901) 648-2190
 |  | Company Site Visit Team | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
Spreadsheet: 36858d1234819235-using-list-function-with-hiding-irrelevant-outputs-monthly-models-6-1-
Sheet: EST Times

 | Car Production Unit | Estimated Time To Process
 | Work Items | Min | [NAME] | [NAME].
1 | AAA | 3.25 | 5 | 4.125
2 | AAB | 0 | 0 | 0
3 | AAC | 18.51 | 32.02 | 25.265
4 | AAD | 2.4675 | 5.785500000000001 | 4.1265
5 | AAE | 4.937925 | 10.527925 | 7.732925
6 | AAF | 4.275 | 8.985 | 6.63
7 | AAG | 8.16125 | 12.04875 | 10.105
8 | AAH | 15.4 | 36.2 | 25.8
9 | AAI | 4 | 7.5 | 5.75
10 | AAJ | 0 | 0 | 0
11 | AAK | 7.8 | 11.53 | 9.665
12 | AAL | 12.9125 | 21.575 | 17.24375
13 | AAM | 12.637125 | 18.787125 | 15.712125
14 | AAN | 4.55 | 9.15 | 6.85
15 | AAO | 4.53469 | 8.26438 | 6.399535
16 | AAP | 9.4402 | 13.8402 | 11.6402
17 | AAQ | 2.0375 | 2.0375 | 2.0375
18 | AAR | 4 | 5 | 4.5
19 | AAS | 4.061850000000001 | 13.9737 | 9.017775
20 | AAT | 4.061850000000001 | 13.9737 | 9.017775
21 | AAU | 4.061850000000001 | 13.9737 | 9.017775
22 | AAV | 4.061850000000001 | 13.9737 | 9.017775
23 | AAW | 0 | 0 | 0
24 | AAX | 2.4 | 7 | 4.7
25 | AAY | 2.4 | 7 | 4.7
26 | AAZ | 2.4 | 7 | 4.7
27 | AAZA | 2.4 | 7 | 4.7
28 | AAZB | 0 | 0 | 0
29 | AAZC | 0 | 0 | 0
30 | AAZD | 8.175 | 9.65 | 8.9125
 | AAZE | 0 | 0 | 0
 | AAZF | 9 | 21.2 | 15.1
 | AAZG | 0 | 0 | 0
 | AAZH | 0 | 0 | 0
 | AAZI | 0 | 0 | 0
Spreadsheet: jeffrey_a_shankman__13934__MgmtSum-Q401-Global-111601
Sheet: Expense Weekly Change

ENRON GLOBAL MARKETS
4th QUARTER 2001 EXPENSES - WEEKLY CHANGE
 |  | Direct Expenses
Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
Crude & Products
Coal
Vessel Trading
Emissions
Weather
Global Risk Markets
Financial Trading
Freight
LNG
Middle East
Puerto Rico
Finance and Structuring
Office of the Chairman
Subtotal Commercial
Group
Other Interest Related Charges
Total
 |  | Operating Expenses
Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
Spreadsheet: kate_symes__18561__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-02-01 00:00:00 |  | 239.7 | 15792 | 151.12 | 4208
 | 2001-01-31 00:00:00 |  | 258.52 | 12800 | 158.13 | 5192 | 175.35 | 3038 | 132 | 1931
 | 2001-01-30 00:00:00 |  | 244.66 | 12560 | 140.9 | 5400 | 178.19 | 3125 | 120.98 | 1446
 | 2001-01-29 00:00:00 |  | 252.84 | 13440 | 177.78 | 5400 | 183 | 4553 | 122.38 | 2433
 | 2001-01-28 00:00:00 |  | 207.5 | 800 | 185 | 200 | 150.26 | 3312 | 132.26 | 2111 |  | 177.78 | 16200
 | 2001-01-27 00:00:00 |  | 225.83 | 13200 | 141.8 | 2840 | 152.11 | 781 | 114.82 | 728
 | 2001-01-26 00:00:00 |  | 225.83 | 13200 | 141.75 | 2800 | 223.17 | 1850 | 161.11 | 180
 | 2001-01-25 00:00:00 |  | 231.78 | 13440 | 144.28 | 3040 | 153.9 | 2315 | 108.66 | 1079
 | 2001-01-24 00:00:00 |  | 222.84 | 13360 | 131.11 | 2880 | 136.45 | 2624 | 93.82 | 933
 | 2001-01-23 00:00:00 |  | 254.26 | 9200 | 143.99 | 4256 | 148.73 | 2079 | 105.08 | 1209
 | 2001-01-22 00:00:00 |  | 324.8 | 9200 | 164 | 2000 | 172.56 | 2925 | 139.79 | 2097
 | 2001-01-21 00:00:00 |  | 177.5 | 2400 | 124.55 | 2200 | 152.69 | 3900 | 141.53 | 2132 |  | 168.33 | 1800
 | 2001-01-20 00:00:00 |  | 452.36 | 4400 | 226.5 | 2000 | 232.31 | 2573 | 148.33 | 1359
 | 2001-01-19 00:00:00 |  | 452.36 | 4400 | 226.5 | 2000 | 273.28 | 6682 | 128.74 | 2093
 | 2001-01-18 00:00:00 |  | 379.51 | 8960 | 214.86 | 2800 | 279.1 | 6115 | 157.96 | 2108
 | 2001-01-17 00:00:00 |  | 220.81 | 12080 | 122 | 3800 | 232.88 | 4018 | 186.65 | 824
 | 2001-01-16 00:00:00 |  | 173.04 | 18112 | 105.14 | 4120 | 231.33 | 632 | 127.03 | 579
 | 2001-01-15 00:00:00 |  | 173.04 | 18112 | 104.82 | 3960 | 169.46 | 718 | 107.24 | 593
 | 2001-01-14 00:00:00 |  | 152.5 | 0 | 103 | 0 | 130.52 | 713 | 116.11 | 446 |  | 107.23 | 13560
 | 2001-01-13 00:00:00 |  | 152.77 | 14160 | 107.23 | 4520 | 138.98 | 1547 | 120.82 | 1165
 | 2001-01-12 00:00:00 |  | 159.03 | 18032 | 90.92 | 3800 | 160.71 | 727 | 98 | 450
 | 2001-01-11 00:00:00 |  | 160.31 | 19472 | 90.92 | 3800 | 153.64 | 1669 | 94.86 | 1106
 | 2001-01-10 00:00:00 |  | 143.16 | 18208 | 84.37 | 3352 | 129.46 | 2981 | 93.14 | 1118
 | 2001-01-09 00:00:00 |  | 132.19 | 14400 | 75.61 | 4552 | 145.14 | 850 | 87.82 | 1753
 | 2001-01-08 00:00:00 |  | 127.4 | 15728 | 68.15 | 5768 | 140.11 | 1652 | 87.68 | 460
 | 2001-01-07 00:00:00 |  | 121.67 | 2400 | 65 | 800 | 84.12 | 1047 | 58.43 | 682 |  | 69.34 | 16944
 | 2001-01-06 00:00:00 |  | 121.11 | 22672 | 71.97 | 5784 | 90.26 | 442 | 59.63 | 622
 | 2001-01-05 00:00:00 |  | 121.35 | 23072 | 72.24 | 5984 | 105.21 | 932 | 98.02 | 734
 | 2001-01-04 00:00:00 |  | 131.61 | 14064 | 79.75 | 6272 | 120.52 | 512 | 71.21 | 514
 | 2001-01-03 00:00:00 |  | 143.06 | 13168 | 85.45 | 3584 | 129.29 | 613 | 75.14 | 791
 | 2001-01-02 00:00:00 |  | 149.82 | 10992 | 93.38 | 2840 | 124.91 | 1327 | 56.75 | 526
 | 2001-01-01 00:00:00 |  | 145 | 0 | 100 | 0 | 70.68 | 2284 | 50.55 | 1025 |  | 93.52 | 7320
Spreadsheet: 121033d1315784076-excel-2007-time-format-conditional-formatting-book5
Sheet: Sheet1

start | finish | elapsed
00:00:00 | 00:00:10
00:00:00 | 00:00:20
00:00:00 | 00:00:30
00:00:00 | 00:00:40
00:00:00 | 00:00:50
00:00:00 | 00:01:00
Spreadsheet: 673458d1587394623-alternative-to-a-heavy-array-index-match-formula-example1
Sheet: Sector Match

 | Investor | Segment | Key Sector Contact | Position | [NAME] | Portfolio 1 | Portfolio 2 | Portfolio 3 | Portfolio 4 | Portfolio 5 |  | Help
 | Investor 1 | B2B Software & Services | First Last 1 | Partner 1 | [EMAIL] | CyberGRX | Toys "R" Us | Crocs | Dealpath | TaskUs
 | Investor 1 | EduTech | First Last 2 | Partner 2 | [EMAIL] | CyberGRX | Toys "R" Us | Crocs | Dealpath | TaskUs |  |  |  |  |  | B2B Software & Services
 | Investor 1 | Consumer Software & Services | First Last 3 | Partner 3 | [EMAIL] | CyberGRX | Toys "R" Us | Crocs | Dealpath | TaskUs |  |  |  |  |  | Consumer Software & Services
 | Investor 2 | Consumer Software & Services | First Last 4 | Partner 4 | [EMAIL] | CyberGRX | Toys "R" Us | Crocs | Dealpath | TaskUs |  |  |  |  |  | Digital Health
 | Investor 2 | Digital Health | First Last 5 | Partner 5 | [EMAIL] | CyberGRX | Toys "R" Us | Crocs | Dealpath | TaskUs |  |  |  |  |  | Ecommerce, Marketplaces & Classifieds
 | Investor 2 | Ecommerce, Marketplaces & Classifieds | First Last 6 | Partner 6 | [EMAIL] | CyberGRX | Toys "R" Us | Crocs | Dealpath | TaskUs |  |  |  |  |  | EduTech
 | Investor 2 | EduTech | First Last 7 | Partner 7 | [EMAIL] | CyberGRX | Toys "R" Us | Crocs | Dealpath | TaskUs |  |  |  |  |  | Fintech & Insurtech
 | Investor 2 | Fintech & Insurtech | First Last 8 | Partner 8 | [EMAIL] | CyberGRX | Toys "R" Us | Crocs | Dealpath | TaskUs |  |  |  |  |  | Industrial Digitisation
 | Investor 2 | Industrial Digitisation | First Last 9 | Partner 9 | [EMAIL] | CyberGRX | Toys "R" Us | Crocs | Dealpath | TaskUs |  |  |  |  |  | Mobility & Travel of the Future
 | Investor 2 | Mobility & Travel of the Future | First Last 10 | Partner 10 | [EMAIL] | CyberGRX | Toys "R" Us | Crocs | Dealpath | TaskUs |  |  |  |  |  | Revolutionary Consumer Products
Spreadsheet: 289b27f3-ee27-41ed-9e56-88012f6c3301
Sheet: $ mono by location

Monograph Expenditures by Location FY11 and FY12
Library | Code | Meaning | FY11 | FY12 | % change | % of total FY12 expend.
[NAME] | rinn | [NAME] | 478.45 | 603.21
URI | riudv | URI Media Rm. | 11232.85 | 9602.25
URI | [NAME] | URI Reference | 58493.07 | 54508.66
URI | riui | URI RI Collection | 2857 | 2207.15
URI | riuin | URI E-Resource | 0 | 61680.18 | N/A
URI | riuo | URI Oversize Stacks | 5300.87 | 5082.59
URI | riup | URI Serial Stacks | 173.18 | 109.2
URI | riur | [NAME] | 0 | 158 | N/A
URI | riuu | [NAME] | 258836.35 | 205026.25
CCE | rixr | CCE Reference | 782.97 | 42.46
CCE | rixv | CCE Video | 0 | 77.95 | N/A
CCE | rixx | CCE Main Collection | 9608.83 | 12155.64
CCE | rixz | CCE Oversize | 33.47 | 0
 |  | TOTAL
Spreadsheet: 825293d1681230204-using-absolute-reference-with-structured-table-references-test
Sheet: Sheet1

Column Number: | 1 | 2 | 3 | 4
 | Order Number | Total | Region | Company |  | Criteria 1 (Company) | Google |  |  | Original | Copied
 | 1 | 88 | 1 | Apple |  | [NAME] (Region) | 2 |  | [NAME]
 | 2 | 162 | 1 | Google
 | 3 | 244 | 2 | Google
 | 4 | 160 | 1 | Microsoft |  |  |  |  |  |  | Doesn’t work | "=SUMIFS(Table1[Region],Table1[Order Number],$H$2,Table1[Company],$H$3)"
 | 5 | 212 | 1 | Apple |  |  |  |  |  |  | Works | "=SUMIFS(Table1[[Total]:[Total]],Table1[[Company]:[Company]],$H$2,Table1[[Region]:[Region]],$H$3)"
 | 6 | 269 | 3 | Apple |  |  |  |  |  |  | Works | "=SUMIFS(INDEX(Table1,,2),INDEX(table1,,4),$H$2,INDEX(table1,,3),$H$3)"
Spreadsheet: 858870d1707380155-return-value-based-on-condition-kl-book
Sheet: Sheet 1

 | 2027-12-15 00:00:00
 |  |  |  |  |  |  |  | Start | End
 |  |  | Yes |  |  |  |  | 2020-12-16 00:00:00 | 2024-12-16 00:00:00
 |  |  |  |  |  |  |  | 2020-12-15 00:00:00 | 2024-12-15 00:00:00
 |  |  |  |  |  |  |  | 2020-12-14 00:00:00 | 2024-12-14 00:00:00
 |  |  |  |  |  | Period range |  | 2020-12-01 00:00:00 | 2025-02-01 00:00:00
Spreadsheet: john_griffith__15759__10_17_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG X1 | 245 | 27 | 30 | 88.1 | 97.9 | 14.32 | 2001-10-17 14:38:00
 | NG Z1 | 270 | 53.5 | 56 | 74.6 | 78.1 | 12.96 | 2001-10-17 14:38:00
 | NG F2 | 290 | 74 | 75 | 73.9 | 74.9 | 13.56 | 2001-10-17 14:38:00
 | NG G2 | 290 | 82 | 85 | 67.8 | 70.3 | 12.59 | 2001-10-17 14:38:00
 | NG H2 | 285 | 82 | 85 | 61.4 | 63.7 | 11.21 | 2001-10-17 14:38:00
 | NG J2 | 280 | 74 | 78 | 51.3 | 54.1 | 9.28 | 2001-10-17 14:38:00
 | NG K2 | 285 | 75 | 79 | 47 | 49.5 | 8.65 | 2001-10-17 14:38:00
 | NG M2 | 285 | 82 | 85 | 47.6 | 49.4 | 8.69 | 2001-10-17 14:38:00
 | NG N2 | 290 | 88 | 93 | 47.5 | 50.2 | 8.91 | 2001-10-17 14:38:00
 | NG Q2 | 295 | 93 | 99 | 46.8 | 49.9 | 8.97 | 2001-10-17 14:38:00
 | NG U2 | 300 | 98 | 104 | 46.2 | 49.1 | 8.99 | 2001-10-17 14:38:00
 | NG V2 | 300 | 102 | 108 | 46.2 | 49 | 8.98 | 2001-10-17 14:38:00
 | [NAME] |  |  |  |  |  | 10.22 | 2001-10-16 14:55:00
 | NG H3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 852310d1702392804-dependable-drop-down-list-based-on-cell-value-twixie
Sheet: Sheet1

A1
A2
A3
A4
A5
A6
A7
A8
A9
A10
A11
A12
A13
A14
A15
A16
A17
A18
A19
B1
B2
B3
B4
B5
B6
B7
B8
B9
B10
B11
B12
B13
B14
B15
B16
B17
B18
B19
C1
C2
[NAME]
C4
C5
C6
C7
C8
C9
C10
C11
C12
C13
C14
C15
C16
C17
C18
C19
Spreadsheet: 823838d1680165485-connecting-formulas-to-option-buttons-runway-30-3-2022
Sheet: Revenues

 | Project | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | Total
 | DPoC for NASENI
 | DPoC for Agric
 | Mercy Crops
 | ABCT
 | WFP SFP
 | local Authentication
 | Soft fruit
 | Other local food processor and distrbuitor
 | Total
 | ABCT
 | Mercy Corps
 | NASENI
 | French
Spreadsheet: 708975d1608116140-vlookup-and-count-book2
Sheet: Sheet1

item code | Total count of items
123 | hot
321 | hot
abc | cold
123 | cold
123 | hot
123 | cold
123 | hot
123 | hot
123 | cold
123 | cold
123 | cold
123 | hot
abc | cold
123 | hot
abc | cold
abc | cold
abc | hot
321 | cold
321 | cold
222 | hot
222 | cold
222 | hot
Spreadsheet: 156894d1337546532-um-by-month-and-by-client-sales-seasonality-by-month1
Sheet: Sales Seasonality by Month

 | Sales Seasonality by Month
 | For the Year 2012
 |  | Actual | % of | Company Index | Industry % | Industry Index |  | Sales by CLIENT:
 |  | Sales | Sales | To Average | of Sales | to Average |  |  | 2012-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 | 2012-01-01 00:00:00 |  |  |  | 0.07 |  |  | SOS
 |  |  |  |  | 0.075 |  |  | VALE
 |  |  |  |  | 0.09 |  |  | ERNEST
 |  |  |  |  | 0.09 |  |  | ALFRED
 |  |  |  |  | 0.09 |  |  | AUGUST
 |  |  |  |  | 0.08
 |  |  |  |  | 0.07
 |  |  |  |  | 0.095
 |  |  |  |  | 0.09
 |  |  |  |  | 0.09
 |  |  |  |  | 0.07
 |  |  |  |  | 0.09
 | Total
 |  |  |  |  |  |  |  | Sales by MONTH:
 |  |  |  |  |  |  |  |  | VALUE
 |  |  |  |  |  |  |  | JAN
 |  |  |  |  |  |  |  | FEV
 |  |  |  |  |  |  |  | MAR
 |  |  |  |  |  |  |  | APR
 |  |  |  |  |  |  |  | MAI
 |  |  |  |  |  |  |  | JUN
 |  |  |  |  |  |  |  | JUL
 |  |  |  |  |  |  |  | AUG
 |  |  |  |  |  |  |  | SEP
 |  |  |  |  |  |  |  | OCT
 |  |  |  |  |  |  |  | NOV
 |  |  |  |  |  |  |  | DEC
 |  |  |  |  |  |  |  | TOTAL:
 |  |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Spreadsheet: 876831d1723550416-use-a-spill-formula-without-actually-creating-a-spill-christopher_garrard-sample-workbook-41-365-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  | True | 10 | 23
 |  |  |  |  |  |  |  |  | False | 20 | 82
 |  |  |  |  |  |  |  |  | True | 30 | 72
 |  |  |  |  |  |  |  |  | False | 40 | 22
 |  |  |  |  |  |  |  |  | True | 50 | 89
 |  |  |  |  |  |  |  |  | False | 60 | 81
 |  |  |  |  |  |  |  |  | True | 70 | 27
 |  |  |  |  |  |  |  |  | False | 80 | 85
 |  |  |  |  |  |  |  |  | True | 90 | 24
 |  |  |  |  |  |  |  |  | False | 100 | 4
 |  |  |  |  |  |  |  |  | True | 110 | 96
 |  |  |  |  |  |  |  |  | False | 120 | 33
Spreadsheet: 873545d1720030005-convert-customer-po-to-data-file-po-to-data
Sheet: data

Item Number | Quantity | PO
ab001 | 123 | PO-01
ab003 | 45 | PO-01
ab004 | 121 | PO-01
ab008 | 12 | PO-01
ab009 | 12 | PO-01
ab002 | 12 | PO-02
ab005 | 45 | PO-02
ab006 | 123 | PO-02
ab007 | 123 | PO-02
ab003 | 12 | PO-03
ab004 | 24 | PO-03
ab006 | 24 | PO-03
ab007 | 24 | PO-03
ab009 | 24 | PO-03
ab001 | 25 | PO-04
ab002 | 23 | PO-04
ab003 | 24 | PO-04
ab005 | 16 | PO-04
ab008 | 16 | PO-04
ab002 | 25 | PO-05
ab004 | 25 | PO-05
ab006 | 25 | PO-05
ab009 | 25 | PO-05
Spreadsheet: 887658d1737952315-lost-in-a-challenging-formula-challenge-costs-with-revenue-word
Sheet: Summary

 |  |  | Lumpsum | Costs
 |  |  | direct cost |  | [NAME] not working despite trimming all the cells
 |  |  | indirect cost |  | [NAME] not working despite trimming all the cells |  | indirect
 |  |  | Open Book Revenue | Costs |  |  | indirect
 |  |  | direct cost |  | [NAME] not working if we add the word Revenue to D12 |  | indirect
 |  |  | indirect cost | ?? |  |  | indirect
 |  |  |  |  |  |  | direct
 |  |  |  |  |  |  | direct
 |  |  |  |  |  |  | direct
 |  |  |  |  |  |  | direct
Spreadsheet: 266818d1379762863-create-tab-update-leaderboards-automatically-calend-rio-e-tabelas
Sheet: Classificação Fair-Play

 | CAMPEONATO GESTLIGA VILA NOVA DE GAIA - 2013 | 2014
 | CLASSIFICAÇÃO FAIR-PLAY
 |  |  | J | A | V | PTS |  | Legenda:
 | 1 | [NAME]
 | 2 | FC Maré Baixa |  |  |  |  |  | [NAME]: 1 ponto
 | 3 | FC Calangas |  |  |  |  |  | Vermelho: 3 pontos
 | 4 | [NAME]
 | 5 | [NAME]
 | 6 | Rayo Vallecano Pedroso
 | 7 | Dream Team FC
 | 8 | [NAME]