tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0612f054-4720-455a-acf4-51001bae7d2e
Sheet: Nitrate Conversions

Nitrate Conversions Assistant
enter values in cells with blue text; all other values are calculated
[NAME] (NO3-N) to Nitrate (NO3)
Nitrate-nitrogen (NO3-N) | 300 | enter value either in percent or ppm
Nitrate (NO3) |  | result is in the same units
[NAME] (NO3) to Nitrate-nitrogen (NO3-N)
Nitrate (NO3) | 0.4 | enter value either in percent or ppm
Nitrate-nitrogen (NO3-N) |  | result is in the same units
[NAME] from ppm to percent
[NAME] | 300
percent
Convert from percent to ppm
percent | 0.02
[NAME]
Other Nitrate Conversions (enter either as percent or ppm, result will be in the same units)
 |  | NO3-N | NO2-N | NO3 | NO2 | NaNO3 | KNO3 |  | Molecular weight
Nitrate-nitrogen (NO3-N) | 1 |  |  |  |  |  |  |  | 14
Nitrite-nitrogen (NO2-N) | 1 |  |  |  |  |  |  |  | 14
Nitrate (NO3) | 1 |  |  |  |  |  |  |  | 62
Nitrite (NO2) | 1 |  |  |  |  |  |  |  | 46
Sodium nitrate (NaNO3) | 1 |  |  |  |  |  |  |  | 85
Potassium nitrate (KNO3) | 1 |  |  |  |  |  |  |  | 101
Spreadsheet: andy_zipper__184__DYNEGY-ICE VOL May17
Sheet: Enron Activity - Dynegy Direct

DYNEGY DIRECT
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Note: Total Activity for Dynegy Direct is not available, therefore Enron's percentage can not be calculated
Enron North America - Dynegy Direct |  |  |  |  | Enron Power Marketing - Dynegy Direct |  |  |  |  | Enron Global Liquids - Dynegy Direct
 |  | Data |  |  |  |  | Data |  |  |  |  | Data
Major Commodity | Enron Trader | Transactions | Notional Volume |  | Major Commodity | Enron Trader | Transactions | Notional Volume |  | Major Commodity | Enron Trader | Transactions | Notional Volume
US Natural Gas | [NAME] | 1 | 10000 |  | Power | [NAME] | 3 | 54400 |  | (blank) | No Activity | 1 | 0
 | [NAME] | 2 | 20000 |  |  | [NAME] | 7 | 38400 |  | (blank) Total |  | 1 | 0
US Natural Gas Total |  | 3 | 30000 |  | Power Total |  | 10 | 92800 |  | Grand Total |  | 1 | 0
Grand Total |  | 3 | 30000 |  | Grand Total |  | 10 | 92800
Spreadsheet: 123673d1317801706-average-vlookup-over-multiple-sheets-test-data-file2
Sheet: 4

FLIGHTS | TIMES
VX921 | 00:07:00
VX751 | 00:11:00
VX300 | 00:14:00
VX925 | 00:19:00
VX833 | 00:20:00
VX67 | 00:22:00
VX853 | 00:15:00
VX903 | 00:15:00
VX11 | 00:23:00
VX953 | 00:15:00
VX927 | 00:14:00
VX351 | 00:21:00
VX905 | 00:25:00
VX69 | 00:21:00
[NAME] | 00:18:00
VX753 | 00:17:00
VX23 | 00:19:00
VX251 | 00:16:00
VX929 | 00:15:00
VX961 | 00:14:00
VX837 | 00:21:00
VX909 | 00:15:00
VX861 | 00:18:00
VX945 | 00:12:00
VX755 | 00:17:00
VX947 | 00:17:00
VX913 | 00:14:00
VX305 | 00:16:00
VX27 | 00:23:00
[NAME] | 00:19:00
VX759 | 00:18:00
VX349 | 00:15:00
VX865 | 00:21:00
VX969 | 00:14:00
VX77 | 00:14:00
VX29 | 00:14:00
Spreadsheet: 65950d1266576356-lookup-formula-demo-v2
Sheet: GH

 | Name | Birthday |  |  | Address | phone | Start date
 |  |  |  |  | Job | Cell | Quit Date
Jan | MrA | 1976 | Jan | 12 | Don't know street | 55223273 | 2007-03-02 00:00:00
Jan |  |  |  |  | Secretary | 905555221
Mar | MrB | 1978 | Mar | 23 | Have not a clue Rd | 22555 | 2008-04-06 00:00:00
Mar |  |  |  |  | Manager | 905555221
Jan | MrC | 1979 | Jan | 24 | Wouldn't know how to to get there Street | 552222552 | 2010-01-02 00:00:00
Jan |  |  |  |  | sales clerk | 905555221
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Spreadsheet: 231685d1367185904-autopopulate-between-worksheets-in-quotation-excel-test-run-online
Sheet: sheet1

 |  | Go Back
[NAME] | SKU | Item Number | Description |  | List price | Discount % | Cost | [NAME] % | Sell Price / Unit | Net Sell Price
 | Ea. | testrun | test |  | 200 | 0.5 |  | 0.6
 | Ea. | 8500C28 | panic white 48" |  | 187.7 | 0.5 |  | 0.6
 | Ea. | 8500C | black |  | 224.6 | 0.5 |  | 0.6
 | Ea. | 8500C | yellow |  | 269.9 | 0.5 |  | 0.6
 | Ea. | 8500C3 | red |  | 306 | 0.5 |  | 0.6
 | Ea. | 85 | pink |  | 390.4 | 0.5 |  | 0.6
 | Ea. | 8500EX | big blue turn |  | 56.6 | 0.5 |  | 0.6
 | Ea. | 8500EXT96 | sign 3 |  | 61.2 | 0.5 |  | 0.6
 | Ea. | 8500hh | Fiction items |  | 202.7 | 0.5 |  | 0.6
 | Ea. | 8500y6 | almost done |  | 239.4 | 0.5 |  | 0.6
 | Ea. | 8500FC3 | Purple dino |  | 283.5 | 0.5 |  | 0.6
 | Ea. | [NAME] | expencive thing |  | 320.4 | 0.5 |  | 0.6
 | Ea. | 8500VBS   yy | cheap thing |  | 25 | 0.5 |  | 0.6
Spreadsheet: darrell_schoolcraft__7783__imbalsumm0107
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 78448 | 77619
2 | 85041 | 84335
3 | 98229 | 102930
4 | 97181 | 96001
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
2001-06-30 00:00:00 |  |  | 59179
2001-07-04 00:00:00
Spreadsheet: 81634d1281732405-excel-2007-matching-then-aligning-data-across-rows-and-down-columns-sample-data
Sheet: Desired

Incident Number | Open Date | Incident Number2 | Close Date
18690854 | 2010-06-29 00:00:00 | 18690854 | 2010-07-29 00:00:00
19083831 | 2010-07-07 00:00:00 | 19083831 | 2010-07-05 00:00:00
19517855 | 2010-07-14 00:00:00 | 19517855 | 2010-07-29 00:00:00
19483038 | 2010-07-15 00:00:00 | 19483038 | 2010-06-29 00:00:00
19825122 | 2010-07-21 00:00:00 | 19825122 | 2010-07-12 00:00:00
18566410 | 2010-06-28 00:00:00 | 18566410 | 2010-08-05 00:00:00
18575364 | 2010-06-28 00:00:00 | 18575364 | 2010-08-01 00:00:00
18595537 | 2010-06-30 00:00:00 | 18595537 | 2010-07-05 00:00:00
18596538 | 2010-06-29 00:00:00 | 18596538 | 2010-07-23 00:00:00
18615046 | 2010-06-28 00:00:00 | 18615046 | 2010-07-17 00:00:00
18624512 | 2010-06-29 00:00:00 | 18624512 | 2010-07-18 00:00:00
18688235 | 2010-06-28 00:00:00 | 18688235 | 2010-07-25 00:00:00
18688952 | 2010-07-01 00:00:00 | 18688952 | 2010-07-17 00:00:00
18689252 | 2010-07-01 00:00:00 | 18689252 | 2010-07-09 00:00:00
18689860 | 2010-07-02 00:00:00 | 18689860 | 2010-07-05 00:00:00
18691207 | 2010-07-02 00:00:00 | 18691207 | 2010-07-22 00:00:00
18691335 | 2010-06-28 00:00:00 | 18691335 | 2010-07-29 00:00:00
18691723 | 2010-07-01 00:00:00 | 18691723 | 2010-07-09 00:00:00
18691910 | 2010-06-30 00:00:00 | 18691910 | 2010-08-01 00:00:00
18691943 | 2010-07-02 00:00:00 | 18691943 | 2010-06-30 00:00:00
18692409 | 2010-06-28 00:00:00
18693151 | 2010-07-02 00:00:00
18694040 | 2010-07-01 00:00:00
18694909 | 2010-06-30 00:00:00
18697854 | 2010-07-01 00:00:00
18699920 | 2010-07-01 00:00:00
18717816 | 2010-06-30 00:00:00
18719178 | 2010-06-30 00:00:00
18721990 | 2010-06-28 00:00:00
18759256 | 2010-07-01 00:00:00
Spreadsheet: 876362d1723042688-sort-by-letter-grade-sample-v2
Sheet: Sheet2

Answer:
City | Sales | Grade
NY | 5 | A+
Berlin | 4.5 | A
LA | 3 | A-
Paris | 1.2 | B
Toronto | 0.7 | B-
Hong Kong | 0.5 | C
Spreadsheet: 118171d1313502864-formula-with-the-fastest-calculation-dealing-with-2-or-more-criteria-fastest-way
Sheet: Data Source

Sales No | Salesman | Product | Brand | Sales ($)
161434 | Mark | Shoes | Nike | 1166
188134 | Mark |  |  | 1604 |  |  | This is a subtotal of Sales for Mark & thus excluded in my Calculation
188134 | Mark | T-Shirt | Adidas | 438
159073 | Louis | T-Shirt | Puma | 1398
159073 | Louis |  |  | 1398
107544 | [NAME] | Wristband | Adidas | 1276
199036 | [NAME] |  |  | 2934
199036 | [NAME] | Singlet | Adidas | 739
108536 | [NAME] | Shoes | Puma | 919
Spreadsheet: 56982d1257174085-making-if-formulation-come-back-as-n-a-sample
Sheet: Sheet1

72007 | A01 | 2007 | TECHNICAL WRITER | 0 | 0 | 0 | 0 | 25 | 0 |  | 46 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 16
79302 | A01 | 9302 | TELECOMMUNICATIONS MANAGEMENT | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 4
72004 | A01 | 2004 | VIDEO JOURNALISM AND DOCUMENTARY PRODUCTION | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 13
Total A01
Percentage Increase/Decrease
Spreadsheet: 171004d1343571307-gathering-data-and-shortening-it-test
Sheet: Roster

 |  |  |  |  |  |  |  | Payroll |  |  |  |  | Contact |  |  |  |  |  |  |  | Name |  |  |  |  |  |  |  |  | ID |  |  | Monday |  |  |  |  |  |  |  | Tuesday |  |  |  |  |  |  |  | Wednesday |  |  |  |  |  |  |  | Thursday |  |  |  |  |  |  |  | Friday |  |  |  |  |  |  |  | Saturday |  |  |  |  |  |  |  | Sunday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | D/S |  |  |  |  |  |  |  | M/S |  |  |  |  |  |  |  | M/S |  |  |  |  |  |  |  | M/S
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A/S |  |  |  |  |  |  |  | A/S |  |  |  |  |  |  |  | A/S |  |  |  |  |  |  |  | D/S
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | N/S |  |  |  |  |  |  |  | N/S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D/S
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | E |  |  |  |  |  |  |  | E |  |  |  |  |  |  |  | D/S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/S |  |  |  |  |  |  |  | N/S |  |  |  |  |  |  |  | N/S
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/S |  |  |  |  |  |  |  | N/S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average Mill |  |  |  |  |  |  |  |  |  |  |  | D/S |  |  |  |  |  |  |  | D/S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D/S |  |  |  |  |  |  |  | D/S |  |  |  |  |  |  |  | D/S
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/S |  |  |  |  |  |  |  | N/S
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | N/S |  |  |  |  |  |  |  | N/S |  |  |  |  |  |  |  | N/S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/S |  |  |  |  |  |  |  | N/S
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Raj Mahumg |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E |  |  |  |  |  |  |  | E |  |  |  |  |  |  |  | E |  |  |  |  |  |  |  | D/S |  |  |  |  |  |  |  | D/S
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KEY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D/S |  |  |  |  |  |  |  |  | Day Shift (12H)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/S |  |  |  |  |  |  |  |  | Night Shift (12H)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M/S//A/S |  |  |  |  |  |  |  |  | Morn/Afternoon (6H)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E/L |  |  |  |  |  |  |  |  | Extra Duty(10.5H)
Spreadsheet: 127145d1320178681-count-example
Sheet: Sheet1

 |  |  |  | Item |  |  |  |  |  |  |  |  |  | Order No |  |  |  |  |  |  | Item | Unique Count
 |  |  |  | 000000000000000007 |  |  |  |  |  |  |  |  |  | 123 |  |  |  |  |  |  | 000000000000000007
 |  |  |  | 000000000000000007 |  |  |  |  |  |  |  |  |  | 124 |  |  |  |  |  |  | 000000000000000018
 |  |  |  | 000000000000000007 |  |  |  |  |  |  |  |  |  | 125
 |  |  |  | 000000000000000007 |  |  |  |  |  |  |  |  |  | 126
 |  |  |  | 000000000000000007 |  |  |  |  |  |  |  |  |  | 123
 |  |  |  | 000000000000000007 |  |  |  |  |  |  |  |  |  | 123
 |  |  |  | 000000000000000007 |  |  |  |  |  |  |  |  |  | 123
 |  |  |  | 000000000000000007 |  |  |  |  |  |  |  |  |  | 130
 |  |  |  | 000000000000000007 |  |  |  |  |  |  |  |  |  | 131
 |  |  |  | 000000000000000007 |  |  |  |  |  |  |  |  |  | 132
 |  |  |  | 000000000000000007 |  |  |  |  |  |  |  |  |  | 133
 |  |  |  | 000000000000000007 |  |  |  |  |  |  |  |  |  | 134
 |  |  |  | 000000000000000007 |  |  |  |  |  |  |  |  |  | 135
 |  |  |  | 000000000000000018 |  |  |  |  |  |  |  |  |  | 123
 |  |  |  | 000000000000000018 |  |  |  |  |  |  |  |  |  | 124
 |  |  |  | 000000000000000018 |  |  |  |  |  |  |  |  |  | 125
 |  |  |  | 000000000000000018 |  |  |  |  |  |  |  |  |  | 126
 |  |  |  | 000000000000000018 |  |  |  |  |  |  |  |  |  | 123
 |  |  |  | 000000000000000018 |  |  |  |  |  |  |  |  |  | 123
 |  |  |  | 000000000000000018 |  |  |  |  |  |  |  |  |  | 123
 |  |  |  | 000000000000000018 |  |  |  |  |  |  |  |  |  | 130
 |  |  |  | 000000000000000018 |  |  |  |  |  |  |  |  |  | 131
 |  |  |  | 000000000000000018 |  |  |  |  |  |  |  |  |  | 132
 |  |  |  | 000000000000000018 |  |  |  |  |  |  |  |  |  | 133
 |  |  |  | 000000000000000018 |  |  |  |  |  |  |  |  |  | 134
Spreadsheet: 146885d1332403039-excel-2007-automating-stock-portfolio-workbook-portfolio-example
Sheet: 123_Closed

 | Account no. | 123
 | STOCK | XYZ
 | Trade |  |  |  |  | Total | Total |  | Euro:1USD | Euro:1USD
 | Date | Account no. | Stock | No. of shares | Price | Amount | Amount |  | Transaction date | Current
 |  |  |  |  | Euro | Euro | USD
 | 2010-12-07 00:00:00 | 123 | XYZ | 60000 | 16 | 960960 |  |  | 0.755
 | 2010-12-09 00:00:00 | 123 | XYZ | -30000 | 30.6709 | -918271.19 |  |  | 0.758
 | 2010-12-10 00:00:00 | 123 | XYZ | -30000 | 31.919 | -955638.67 |  |  | 0.757
 | Total: | XYZ
Spreadsheet: 12c810e1-855d-4246-aa19-d6943d4d0dec
Sheet: Format Requirements

Field Name | Definition | Allowable Values | Comments/Description | Example Value
SP_NUMBER | VARCHAR2(20) |  | Diplays the Primary State Project Number | 2771-31
DATE_STRIPED | DATE |  | Displays the date when the line was installed. | 2007-06-25 00:00:00
BEGIN_TIME | HH:MM:SS |  | Displays the time that striping started. | 13:24:45
END_TIME | HH:MM:SS |  | Displays the time that striping ended. | 15:28:30
ROUTE_SYSTEM_ABBR | VARCHAR2(2) | I = Interstate US = US Trunk MN = Minnesota Trunk | Displays the route system class. | MN
ROUTE_NUMBER | VARCHAR2(4) |  | Displays the route number with system type. | 210
DIRECTION | VARCHAR2(1) | I = Increasing D = Decreasing | Direction of travel on roadway. | I
FROM_REF_POST_OFFSET | VARCHAR2(10) |  | Displays the starting reference post number with offset value where retroreflectivity readings were taken. | 196+00.245
TO_REF_POST_OFFSET | VARCHAR2(10) |  | Displays the ending reference post number with offset value where retroreflectivity readings were taken. | 216+00.518
FROM_LONGITUDE | NUMBER(10,7) |  | Displays the geographic longitude value of the starting point location. | -93.1179478
FROM_LATITUDE | NUMBER(10,7) |  | Displays the geographic longitude value of the starting point location. | 44.9389797
TO_LONGITUDE | NUMBER(10,7) |  | Displays the geographic longitude value of the ending point location. | -93.1349833
TO_LATITUDE | NUMBER(10,7) |  | Displays the geographic longitude value of the ending point location. | 44.931421
LINE_TYPE_CODE | VARCHAR2(3) | CL = Center Line REL = Right Edge Line LEL = Left Edge Line LL = [NAME] (White) 1LL = Leftmost Lane Line in Multilane 2LL = Second to Left Most Lane Line in Multilane xLL = etc | Marking line type | REL
RETROREFLECTIVITY | NUMBER(5,1) |  | Displays the average retroreflectivity reading in the mile increment | 1000.4
STANDARD_DEVIATION | NUMBER(3) |  | Displays the standard deviation of retroreflective reading in the mile increment | 25
RETROREFLECTIVITY_10TH_MILE_AVG | NUMBER(5,1) |  | Displays the average retroreflectivity reading in the 10th mile increment | 1000.4
STANDARD_DEVIATION_10TH_MILE | NUMBER(3) |  | Displays the standard deviation of retroreflective reading in the 10th mile increment | 25
MARKING_TYPE_CODE | VARCHAR2(3) | E = Epoxy Paint L = Latex Paint T = Tape TH = Thermoplastic PU = Polyurea Paint MMA = [NAME] U = Unknown | Marking Material Type | E
GROOVED | VARCHAR2(3) | Yes/No | Displays the presence of a pavement groove. | Yes
RUMBLE_STRIPE | VARCHAR2(3) | Yes/No | Displays the presence of a pavement rumble stripe. | Yes
COMMENTS | VARCHAR2(100) |  | Displays commentary about the roadway or collection process.
YEAR_LINE_INSTALLED | NUMBER(4) |  | Displays the year the line was installed | 2012
CONTRAST | VARCHAR2(3) | Yes/No | Displays the contrast value of the pavement marking. | No
Spreadsheet: 852690d1702642887-search-entire-workbook-and-display-results-search
Sheet: CAT A

Original Part No. | Customer A Part No. | Customer B Part No. | Customer C Part No.
AA001MX | A001F | AA-001-F | [NAME]
AA002MX | A002F | AA-002-F | A2MX
AA003MX | A003F | AA-003-F | A3MX
[NAME] | A004F | AA-004-F | A4MX
AA005MX | A005F | AA-005-F | A5MX
Spreadsheet: 107893d1305040771-excel-cell-display-page-breaks-temp800
Sheet: Sheet1

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
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
Spreadsheet: 0a379928-a7f3-47bb-908f-f8e3939b92db
Sheet: Sport+ (France)

[NAME] (France)
Date | Start (CET) | End (CET) | Notes
2010-11-22 00:00:00 | 00:15:00 | 01:45:00 | Round [NAME] (Singles)
2010-11-22 00:00:00 | 18:45:00 | 20:30:00 | Round [NAME] (Singles)
2010-11-23 00:00:00 | 18:45:00 | 20:30:00 | Round [NAME] (Singles)
2010-11-24 00:00:00 | 00:00:00 | 01:30:00 | Round [NAME] (Singles)
2010-11-24 00:00:00 | 18:00:00 | 19:00:00 | Round [NAME] (Singles)
2010-11-25 00:00:00 | 00:45:00 | 01:45:00 | Round [NAME] (Singles)
2010-11-25 00:00:00 | 18:00:00 | 19:00:00 | Round [NAME] (Singles)
2010-11-25 00:00:00 | 23:30:00 | 01:00 (26/11) | Round [NAME] (Singles)
2010-11-26 00:00:00 | 19:00:00 | 20:30:00 | Round [NAME] (Singles)
2010-11-27 00:00:00 | 00:00:00 | 001:45 | Round [NAME] (Singles)
2010-11-27 00:00:00 | 23:30:00 | 02:00 (28/11) | Semi-Finals - Delayed (Singles)
2010-11-28 00:00:00 | 00:45:00 | 01:45:00 | Singles Final - Delayed
2010-11-30 00:00:00 | 15:15:00 | 16:15:00 | Highlights Show
Spreadsheet: 732930d1621324603-formula-to-sum-concatenated-trucks-sum-concatenated-trucks-ans-1-
Sheet: Data

Date | Supplier | Truck | Quantity
2021-04-01 00:00:00 | Company 1 | 6578 | 17.46
2021-04-01 00:00:00 | Company 1 | 7496 | 20
2021-04-01 00:00:00 | Company 2 | 2951 | 48.02
2021-04-01 00:00:00 | Company 3 | 2971 | 26.78
2021-04-01 00:00:00 | Company 4 | 2473 | 52
2021-04-01 00:00:00 | Company 4 | 7416 | 54.54
2021-04-01 00:00:00 | Company 5 | 9241 | 40
2021-04-01 00:00:00 | Company 5 | 8162 | 52.5
2021-04-01 00:00:00 | Company 5 | 2493 | 46
2021-04-01 00:00:00 | Company 5 | 3697 | 83.94
2021-04-02 00:00:00 | Company 4 | 3724 | 43
2021-04-02 00:00:00 | Company 4 | 1564 | 52
2021-04-02 00:00:00 | Company 4 | 4571 | 60
2021-04-02 00:00:00 | Company 4 | 8947 | 37.32
2021-04-02 00:00:00 | Company 2 | 7415 | 42
Spreadsheet: 494002d1482065841-conditional-formatting-with-a-index-match-array-formula-copy_v2
Sheet: ExecView

SITE | AVAILABLE _T1 | AVAILABLE_T2 | ORDER_T1 | [NAME] | AVAILABLE_T3 | Order_T3 | Man.
SITE1 |  |  |  |  |  |  | HDS
SITE2 |  |  |  |  |  |  | HDS
SITE3 |  |  |  |  |  |  | HDS
SITE1 |  |  |  |  |  |  | HP
SITE2 |  |  |  |  |  |  | HP
SITE3 |  |  |  |  |  |  | HP
SITE1 |  |  |  |  |  |  | Cloudian
SITE2 |  |  |  |  |  |  | Cloudian
SITE3 |  |  |  |  |  |  | Cloudian
SITE1 |  |  |  |  |  |  | SwiftStack
SITE2 |  |  |  |  |  |  | SwiftStack
SITE3 |  |  |  |  |  |  | SwiftStack
SITE1 |  |  |  |  |  |  | HCP
SITE2 |  |  |  |  |  |  | HCP
SITE3 |  |  |  |  |  |  | HCP
Spreadsheet: 735023d1622647619-counting-duplicates-in-specific-case-example-39-ans
Sheet: Sheet1

 |  |  |  |  |  |  | FORMULA
 | Name | Group |  |  | Attended more than once from Group A | A
 | B.Almond | A |  |  | Attended more than once from Group B | B
 | C.Carrot | B |  |  | Attended more than once from Group C | C
 | D.Juice | C
 | B.Almond | A
 | A.Cabbage | C
 | C.Carrot | B
 | B.Fairy | A
 | B.Fairy | A
Spreadsheet: 71e107f3-3711-4d93-9384-71cc03006386
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4041 | 5407 | Ricarda | Lisk | GER | 31 | 00:20:24 | 00:01:04 | 01:08:59 | 00:00:24 | 00:38:47 | 1 | [NAME]
4041 | 6224 | Kerry | Lang | GBR | 32 | 00:19:25 | 00:01:09 | [NAME] | 00:00:28 | 00:39:25 | 2 | 02:10:22
4041 | 7804 | Corinne | [NAME] | RSA | 33 | [NAME] | 00:01:13 | 01:11:47 | 00:00:32 | [NAME] | 3 | 02:16:14
4041 | 11325 | Eva | [NAME] | NED | 35 | 00:23:18 | 00:01:12 | 01:11:14 | 00:00:32 | [NAME] | 4 | 02:17:20
4041 | 5393 | Lucie | [NAME] | CZE | 34 | 00:20:01 | 00:01:22 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: chris_germany__1768__Post Close Stg settle
Sheet: example

 |  |  |  |  | P | Q
 |  | original [NAME] |  | April | 2 | 1000
 |  |  |  | May | 2.2 | 900
 |  |  |  | June | 2.35 | 950
 |  |  |  | July | 2.4 | 1050
 |  | Pre-close |  | April | 2 | 1000
 |  |  |  | May | 2.2 | 900
 |  |  |  | June | 2.35 | 950
 |  |  |  | July | 2.3 | 1060
 |  | Post-close |  | April | 2 | 1000
 |  |  |  | May | 2.2 | 900
 |  |  |  | June | 2.35 | 950
 |  |  |  | July | 2.3 | 1070
Spreadsheet: 767567d1644519547-sorting-in-several-tables-book1123-nawalanek1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Selected nr: | 75
 |  | nr | score |  | nr | score |  | nr | score |  |  | Table 1 |  | Table2 |  | Table3
 |  | 473 | 4 |  | 283 | -9 |  | 142 | 168.4 |  |  | nr | score | nr | score | nr | score
 |  | 163 | 3 |  | 371 | -8.5 |  | 283 | 162.3
 |  | 508 | 4 |  | 214 | -8 |  | 371 | 156.2
 |  | 534 | 3 |  | 405 | -7.5 |  | 214 | 150.1
 |  | 568 | 3 |  | 354 | -7 |  | 405 | 144
 |  | 84 | 2.8 |  | 314 | -6.5 |  | 354 | 137.9
 |  | 406 | 2.6 |  | 50 | -6 |  | 314 | 131.8
 |  | 576 | 2.4 |  | 538 | -5.5 |  | 50 | 125.7
 |  | 428 | 2.2 |  | 582 | -5 |  | 538 | 119.6
 |  | 124 | 2 |  | 326 | -4.5 |  | 582 | 113.5
 |  | 339 | 1.8 |  | 75 | -4 |  | 326 | 107.4
 |  | 135 | 1.6 |  | 288 | -3.5 |  | 75 | 101.3
 |  | 183 | 1.4 |  | 453 | -3 |  | 288 | 95.2
 |  | 404 | 1.2 |  | 206 | -2.5 |  | 453 | 89.1
 |  | 206 | 1 |  | 404 | -2 |  | 206 | 83
 |  | 453 | 0.8 |  | 183 | -1.5 |  | 404 | 76.9
 |  | 288 | 0.6 |  | 135 | -1 |  | 183 | 70.8
 |  | 75 | 0.4 |  | 339 | -0.5 |  | 135 | 64.7
 |  | 326 | 0.2 |  | 124 | 0 |  | 339 | 58.6
 |  | 582 | 0 |  | 428 | 0.5 |  | 124 | 52.5
 |  | 538 | -0.2 |  | 576 | 1 |  | 428 | 46.4
 |  | 50 | -0.4 |  | 406 | 1.5 |  | 576 | 40.3
 |  | 314 | -0.600000000000001 |  | 142 | 2 |  | 406 | 34.2
 |  | 354 | -0.8 |  | 84 | 2 |  | 568 | 34
 |  | 405 | -1 |  | 568 | 2.5 |  | 84 | 28.1
 |  | 214 | -1.2 |  | 163 | 3 |  | 473 | 4
 |  | 371 | -1.4 |  | 534 | 3 |  | 508 | 4
 |  | 283 | -1.6 |  | 508 | 4 |  | 534 | 4
 |  | 142 | -1.8 |  | 473 | 5 |  | 163 | 3
Spreadsheet: 28074d1221908962-pivot-table-calculated-field-book11
Sheet: Sheet4

Count of ID | OT
ID | Late | On Time | Grand Total |  | ot %
A | 2 | 2 | 4 |  | 0.5
B | 2 | 1 | 3 |  | 0.3333333333333333
C | 2 |  | 2 |  | 0
D |  | 1 | 1 |  | 1
Grand Total | 6 | 4 | 10 |  | 0.4