tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 752675d1634896075-deleting-certain-values-book2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 |  | 2 |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 6 | 6 |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 7 |  |  | 7 | 7 |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 9 |  |  | 9 | 9 |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 1 | 1 |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 |  | 2 | 2 |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 |  | 3 | 3 |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 7 |  |  |  | 7 |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 1 | 1 | 1 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 2 | 2 | 2 |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 6 |  |  | 6 |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 8 |  |  |  | 8 |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 9
Spreadsheet: 232492d1367433360-how-to-use-buttons-to-lookup-data-then-calculate-output-sheet-metal-analysis-solution
Sheet: Galvanized

Material | Gage | Length (ft) | width (ft) | [NAME]. ft. | thickness | tolerance | sheet weight (lb) | Price per 100 weight (lbs) (cwt) | nominal wieght (esitimated pounds ordered) | amount shipped (lbs) | date paid | date invoiced | total estimated price | invoice amount | total price paid or cost | Invoice # | actual cost per sheet | cost per sqft | number of sheets on hand | lbs on hand | total area onhand (ftsq) | dollar amount on hand | total cost/lb on hand actual | cost/sqft on hand | Vendor
Galvanized | 26 | 8 | 4 | 0.906 |  |  |  | 51.95 | 2000 | 2088 | 2006-07-23 00:00:00 | 2006-06-09 00:00:00 |  | 1084.72 |  | 58218 |  |  | 73
Galvanized | 26 | 10 | 4 | 0.906
Galvanized | 24 | 8 | 4 | 1.156 |  |  |  | 45.95 | 3000 | 3071 | 2006-04-25 00:00:00 | 2006-03-24 00:00:00 |  | 1411.12 |  | 57609
Galvanized | 24 | 10 | 4 | 1.156 |  |  |  | 50.95 | 3000 | 3145 | 2006-08-23 00:00:00 | 2006-07-27 00:00:00 |  | 1602.38 |  | 58587
Galvanized | 22 | 8 | 4 | 1.406 |  |  |  | 49.95 | 2500 | 2390 | 2006-07-23 00:00:00 | 2006-06-09 00:00:00 |  | 1193.81 |  | 58218
Galvanized | 22 | 10 | 4 | 1.406 |  |  |  | 49.95 | 3000 | 2981 | 2006-08-23 00:00:00 | 2006-07-27 00:00:00 |  | 1489.01 |  | 58587
Galvanized | 22 | 8 | 4 | 1.406 |  |  |  | 45.95 | 3000 | 3431 | 2006-04-25 00:00:00 | 2006-03-24 00:00:00 |  | 1576.55 |  | 57609
Galvanized | 22 | 10 | 4 | 1.406
Galvanized | 20 | 8 | 4 | 1.656 |  |  |  | 44.95 | 2500 | 2414 | 2006-01-27 00:00:00 | 2006-01-06 00:00:00 |  | 1085.09 |  | 57025
Galvanized | 20 | 10 | 4 | 1.656
Galvanized | 18 | 8 | 4 | 2.156 |  |  |  | 44.95 | 2500 | 2422 | 2006-01-27 00:00:00 | 2006-01-06 00:00:00 |  | 1088.69
Galvanized | 18 | 10 | 4 | 2.156 |  |  |  | 48.95 | 2500 | 2415 | 2006-07-23 00:00:00 | 2006-06-09 00:00:00 |  | 1182.14 |  | 58218
Galvanized | 16 | 8 | 4 | 2.656 |  |  |  | 49.5 |  | 1700 | 2006-08-23 00:00:00 | 2006-07-27 00:00:00 |  | 841.5 |  | 58587
Galvanized | 16 | 10 | 4 | 2.656
Galvanized | 14 | 8 | 4 | 3.281
Galvanized | 14 | 10 | 4 | 3.281
Galvanized | 12 | 8 | 4 | 4.531
Galvanized | 12 | 10 | 4 | 4.531
Material | Gage | Length (ft) | width (ft) | Lbs per Sq. ft. | thickness | tolerance | sheet weight (lb)
Galvanized | 26 | 8 | 4 | 0.906
Galvanized | 26 | 10 | 4 | 0.906
Galvanized | 24 | 8 | 4 | 1.156
Galvanized | 24 | 10 | 4 | 1.156
Galvanized | 22 | 8 | 4 | 1.406
Galvanized | 22 | 10 | 4 | 1.406
Galvanized | 22 | 8 | 4 | 1.406
Galvanized | 22 | 10 | 4 | 1.406
Galvanized | 20 | 8 | 4 | 1.656
Galvanized | 20 | 10 | 4 | 1.656
Galvanized | 18 | 8 | 4 | 2.156
Galvanized | 18 | 10 | 4 | 2.156
Galvanized | 16 | 8 | 4 | 2.656
Galvanized | 16 | 10 | 4 | 2.656
Galvanized | 14 | 8 | 4 | 3.281
Galvanized | 14 | 10 | 4 | 3.281
Galvanized | 12 | 8 | 4 | 4.531
Galvanized | 12 | 10 | 4 | 4.531
Spreadsheet: 37660d1235687061-accrued-vacation-time-off-tracker-2009
Sheet: Master Tracker

Employee Name: | Date(s) Used | Description | Vacation Hours | Personal / Float Hours | Sick/Family Care Hours | Bereavement | Jury
FIRST NAME & LAST NAME |  |  | 80 | 24 | 40 | NA | NA
Hire Date:
00/00/0000
Today's Date:
2009-02-26 00:00:00
YTD Vacation Hours Accrued
 |  | TOTAL REMAINING: | 80 | 24 | 40
 |  | TOTAL USED: | 0 | 0 | 0 | 0 | 0
 |  |  |  | 2009-01-01 00:00:00 | New Year's Day
 |  |  |  | 2009-05-25 00:00:00 | Memorial Day
 |  |  |  | 2009-07-04 00:00:00 | Independence Day
 |  |  |  | 2009-09-07 00:00:00 | Labor Day
 |  |  |  | 2009-11-26 00:00:00 | Thanksgiving Day
 |  |  |  | 2009-11-27 00:00:00 | Day after Thanksgiving
 |  |  |  | 2009-12-25 00:00:00 | Christmas Day
 | *2009 total reflects time accrued by 12/31/09.  Time off requested by not accrued is granted solely at managers' discretion.
Spreadsheet: 119328d1314320408-multiple-condition-lookup-sample
Sheet: Query Results

ID | Check # | PaychkName | Empl Rcd# | [NAME] | Group | Co | NID | Net Pay | Death Date | Last | First Name
580204320 | 2508982595 | Smith,[NAME] | 2 | 71100 | PB3 | U0F | 559529923 | 353.49 |  | Smith | [NAME]
580204320 | 1500552463 | Smith,[NAME] | 3 | 74100 | [NAME] | U0M | 559529923 | 77 |  | Smith | [NAME]
585008650 | 1500555107 | REICH,[NAME] | 2 | 74100 | [NAME] | U0M | 163261926 | 77 |  | REICH | [NAME]
585008650 | 2508921390 | REICH,[NAME] | 1 | 71100 | PB7 | U0F | 163261926 | 720.3 |  | REICH | [NAME]
590095013 | 2509084600 | Beel,[NAME] | 1 | 70100 | P48 | U0A | 308567620 | 362.85 | 2011-07-20 00:00:00 | Beel | [NAME]
590095013 | 2509084600 | Beel,[NAME] | 1 | 70100 | P48 | U0A | 308567620 | -362.85 | 2011-07-20 00:00:00 | Beel | [NAME]
Spreadsheet: 70027d1270676417-how-to-change-cell-values-based-on-a-set-number-2009-8teams-
Sheet: WEEK 2A

MUV | BET TEAM | VS TEAM | GAME 1 | [NAME] | G1 $ Win | [NAME] | G1 $ Risk | G1   Result | GAME 2 | [NAME] | G2 $ Win | [NAME] | G2 $ Risk | G2 Result | GAME 3 | [NAME] | G2 $ Win | [NAME] | G2 $ Risk | G3 Result | TOT Units Risked | TOT Units Won | TOT Units Lost | TOT Unit Profit | TOT $$$ Profit
14.7875 | NYY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
295.75 | BOS | X | -175 | 15.7875 | 315.75 | 3.04390625 | 60.878125 | L | -155 | 19.83140625 | 396.628125 | 8.9640859375 | 179.28171875 | L | -250 | 27.7954921875 | 555.90984375 | 34.36841796874999 | 687.368359375 | W | 46.37641015625 | 15.7875 | 0 | 15.7875 | 315.75
 | MIN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | CHC | X | -210 | 15.7875 | 315.75 | 3.6526875 | 73.05375 | W |  |  |  |  |  |  |  |  |  |  |  |  | 3.6526875 | 15.7875 | 0 | 15.7875 | 315.75
 | WAS | X | -155 | 15.7875 | 315.75 | 2.69603125 | 53.920625 | W |  |  |  |  |  |  |  |  |  |  |  |  | 2.69603125 | 15.7875 | 0 | 15.7875 | 315.75
 | PIT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | KC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | SD | X | -155 | 15.7875 | 315.75 | 2.69603125 | 53.920625 | W |  |  |  |  |  |  |  |  |  |  |  |  | 2.69603125 | 15.7875 | 0 | 15.7875 | 315.75
 |  | 4 |  |  |  |  |  | 3 |  |  |  |  |  | 0 |  |  |  |  |  | 1 | 55.42116015624999 | 63.15000000000001 | 0 | 63.15000000000001 | 1263
RETURN TO MLB OVERALL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOT L | 0 | 1108.423203125
WEEK 2A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOT W | 4
Spreadsheet: 761599d1641095671-how-to-add-data-from-another-sheet-vlookup-test-020222-vlookup-how-to-append-data-from-another-sheet
Sheet: CONTRACTS

NAME | AGE | MARKS | NAME | RANK | CLASS | RESULT
ABHILASH | 11 | 250
BEENA | 12 | 32
CHANDU | 14 | 365
[NAME] | 12 | 145
[NAME] | 47 | 541
FATHIMA | 14 | 256
GANGA | 16 | 321
HARI | 13 | 125
INDRAJITH | 16 | 2145
[NAME] | 25 | 236
 |  |  |  |  |  | I want the data from sheet named VOLT to  be appended to col D of this sheet.
 |  |  |  |  |  | '=VLOOKUP(A2,VOLT!$B$3:$E$8,MATCH(VOLT!B$3,VOLT!$B$2:$E$2,0),0)
 |  |  |  |  |  | =IFERROR(VLOOKUP(A2,VOLT!$B$3:$C$8,COLUMN(VOLT!B3),0),"DATA")
Spreadsheet: 133371d1324367803-calculating-a-column-with-another-sheet-dummy-sheet
Sheet: Vertical + update

 |  |  | 12/15 | 12/31 | 01/15 | 01/31 | 02/15 | 02/28 | 03/15 | 03/31 end
Account 1 |  | 917.175209
Item 17 | 5 | 122.866 | 120 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Item 79 | 5 | 51.41 | 51.25
Item 43 | 5 | 66.59 | 62.5
Item 11 | 5 | 73.7 | 71
Item 2 | 5 | 79.9 | 72.425
Item 61 | 5 | 53.6 | 49
Item 22 | 5 | 61.993209 | 55.5
Item 14 | 5 | 97.116 | 96.25
Item 54 | 5 | 40 | 40
Item 77 | 30 | 270 | 265.5
invested |  | 917.175209 | 883.425 | 0 | 0 | 0 | 0 | 0 | 0 | 0
liquid | 82.825 | 82.825 | 82.825 | 82.825 | 82.825 | 82.825 | 82.825 | 82.825 | 82.825 | 82.825
total portfolio |  | 1000.000209 | 966.25 | 82.825 | 82.825 | 82.825 | 82.825 | 82.825 | 82.825 | 82.825
Account 2 |  | 928.825717
Item 80 | 1 | 107.717717 | 107.117
Item 22 | 18 | 236.278 | 199.8
Item 79 | 20 | 224.83 | 205
Item 77 | 40 | 360 | 354
IOTMs invested |  | 928.825717 | 865.9169999999999 | 0 | 0 | 0 | 0 | 0 | 0 | 0
liquid meat | 71.174 | 71.174 | 71.174 | 71.174 | 71.174 | 71.174 | 71.174 | 71.174 | 71.174 | 71.174
total portfolio |  | 999.999717 | 937.0909999999999 | 71.174 | 71.174 | 71.174 | 71.174 | 71.174 | 71.174 | 71.174
Spreadsheet: 836654d1689565491-automatic-fill-in-daily-plant-data-collection-in-different-sheets-project-plant-data-collection
Sheet: Leaf Length

Treatments | Plant samples | 3.Jul.2023 | 4.Jul.2023
B10F0 | 1 | 2.1
B10F0 | 2 | 3
B10F0 | 3 | 3.1
B10F0 | 4 | 2.7
B10F0 | 5 | 2.2
B10F0 | 6 | 2.6
B10F0 | 7 | 2.6
B10F0 | 8 | 3.2
B10F0 | 9 | 2.3
B9F1 | 1 | 2.8
B9F1 | 2 | 2.4
B9F1 | 3 | 2.6
B9F1 | 4 | 2.6
B9F1 | 5 | 3.2
B9F1 | 6 | 2.5
B9F1 | 7 | 2.6
B9F1 | 8 | 2.2
B9F1 | 9 | 2.6
B8F2 | 1 | 3.1
B8F2 | 2 | 3.2
B8F2 | 3 | 2.6
B8F2 | 4 | 3.1
B8F2 | 5 | 2.4
B8F2 | 6 | 2.1
B8F2 | 7 | 3
B8F2 | 8 | 2.9
B8F2 | 9 | 3.2
B7F3 | 1 | 2.2
B7F3 | 2 | 2.3
B7F3 | 3 | 2.7
B7F3 | 4 | 2.6
B7F3 | 5 | 2.7
B7F3 | 6 | 3
B7F3 | 7 | 2.9
B7F3 | 8 | 2.2
B7F3 | 9 | 2.1
B6F4 | 1 | 3.2
B6F4 | 2 | 3.1
B6F4 | 3 | 3.1
B6F4 | 4 | 2.7
B6F4 | 5 | 2.6
B6F4 | 6 | 2.2
B6F4 | 7 | 2.8
B6F4 | 8 | 2.7
B6F4 | 9 | 2.7
B0F10 | 1 | 3
B0F10 | 2 | 2.9
B0F10 | 3 | 2.5
B0F10 | 4 | 2.9
B0F10 | 5 | 2.3
B0F10 | 6 | 2.6
B0F10 | 7 | 2.1
B0F10 | 8 | 2.5
B0F10 | 9 | 3.1
Spreadsheet: 83425d1283409530-data-validation-lists-creating-lists-based-on-data-from-another-list-opc-list
Sheet: Sheet1

 | SBIF | AENV | JCCR | PKIF
 | SGIF | AOIF | [NAME] | PPIN
 | SHIN | BAIF | JHSS | PSIF |  |  |  |  |  |  | BU | OPC
 | SODA | BXIF | JINF | [NAME] |  |  |  | Data From |  |  | MIN | RIWN
 | UNIF | CBIF | [NAME] | QCRR |  |  | BIF | List1 | When PAE is chosen i only want the data from list1 to appear in the OPC column as a drop down list
 | VCAN | CLOC | JNGT | QENV |  |  | MIN | List2
 | VESA | CYAN | JSMC | QHIN |  |  | PAE | List3
 | VPIN | DBIF | [NAME] | QNMM |  |  | WAE | List4
 | VTAS | ENVR | LPIN | RDEL
 | [NAME] | EWAE | MBIF | RIWN |  |  |  |  |  |  | BIF | AOIF
 |  | GHIN | MHIN |  |  |  |  |  | When BIF is chosen i only want the data from list2 to appear in the OPC colum as a drop down list
 |  | HARB | MVSP
 |  | HDEL | MWST
 |  | [NAME] | NBIF
 |  | JAKA | NEIF
 |  |  | NWMM
 |  |  | [NAME]
 |  |  | PHIL
 |  |  | PINT
Have been named as ranges | List1 | List2 | List3 | List4
Spreadsheet: 799887d1665388956-case-sensitive-with-match-while-using-arrays-excel_double_control
Sheet: double_control

UNMATCH | (case-sensitive)
GRADES
grade | location |  |  | label | value
A | US |  |  | location | MX
A | DE |  |  | grade | A
B | MX |  |  | grade | B
C | US |  |  | location | US
D | DE |  |  | location | NL
a | MX |  |  | grade | C
F | US |  |  | client_group | a
A | DE |  |  | client_group | a
A | MX
B | FR
B | DE
D | MX |  | should be 4
A | FR
B | US
Spreadsheet: 525599d1498799622-skipping-blank-cells-when-copying-values-to-another-tab-excel_forum_questions
Sheet: SheetNo_1

 | 0 | 750000
 | 1 | 60000
 | 2 | 890000
 | 3 | 560000
 | 4 | 67000
Result needed:
Spreadsheet: 680310d1590933299-how-to-copy-every-10-rows-from-multiple-sheets-to-one-sheet-2020-05-30-oeldere3-rezalearner-680235d1590866880-how-to-copy-every-10-rows-from-multiple-she
Sheet: allsheets

 |  |  |  |  |  |  |  |  | Oeldere (2) =>
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
 |  |  |  |  |  |  | ...
Spreadsheet: b05d710e-141a-4187-ab10-edad15543430
Sheet: Table 10

Table 10
[NAME] (1,000 tons)
Week ending 10/25/2014 | Corn | Wheat | Soybeans | Other | Total
Mississippi River
Rock Island, IL (L15) |  | 0 |  | 0
Winfield, MO (L25)
Alton, IL (L26)
Granite City, IL (L27)
Illinois River (L8)
Ohio River (L52) |  |  |  |  |  | n/a
Arkansas River (L1)
Weekly total - 2014
Weekly total - 2013
2014 YTD1
2013 YTD
2014 as % of 2013 YTD
Last 4 weeks as % of 20132
Total 2013
1 Weekly total, YTD (year-to-date) and calendar year total includes Miss/27, [NAME], and Ark/1; "Other" refers to oats, barley, sorghum, and rye.
2 As a percent of same period in 2013.
Note:  Total may not add exactly, due to rounding
Source:  U.S. Army Corps of Engineers
Spreadsheet: 94672d1294419651-excel-2007-pivot-table-or-something-else-instead-759040
Sheet: Data

Name | Shares | Value | Grant Number | Grant Date | EmployeeID | Address | [NAME]
[NAME] | 250 |  | BB1 | 2009-01-01 00:00:00 | 12345 |  | mailto:[EMAIL]
[NAME] | 250 |  | P30013 | 2010-01-01 00:00:00 | 12345 |  | mailto:[EMAIL]
[NAME] | 500 |  | MD1 | 2009-01-01 00:00:00 | 54321 |  | mailto:[EMAIL]
[NAME] | 500 |  | ME2 | 2010-01-01 00:00:00 | 54321 |  | mailto:[EMAIL]
[NAME] | 500 |  | IJ1 | 2008-03-31 00:00:00 | 54321 |  | mailto:[EMAIL]
[NAME] | 1000 |  | P30012 | 2005-01-01 00:00:00 | 23451 |  | mailto:[EMAIL]
[NAME] | 1000 |  | P30078 | 2010-03-31 00:00:00 | 23451 |  | mailto:[EMAIL]
[NAME] | 1000 |  | J0089 | 4/1/206 | 23451 |  | mailto:[EMAIL]
 |  |  | Name | Total Shares Held | Value of Shares Held | Address | [NAME] | Employee ID
 |  |  | [NAME] | 500 |  | 123 Sample Way | [EMAIL] | 12345
 |  |  | [NAME] | 1500 |  | 123 Sample Way | [EMAIL] | 54321
 |  |  | [NAME] | 3000 |  | 123 Sample Way | [EMAIL] | 23451
Spreadsheet: 732782d1621241961-need-help-with-formula-to-search-rows-and-find-the-cell-thats-increasing-increase
Sheet: Ark1

 |  |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  |  |  | Date of increase: | Increase in % | Increase in value
 |  |  |  | 2 | - | - | 2021-01-01 00:00:00 | 2 | - | - | 2021-03-01 00:00:00 | 2.5 | - | - | 2021-05-01 00:00:00 | 2.5 | - | - | 2021-07-01 00:00:00 |  |  | 2021-05-01 00:00:00 | 0.25 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The increase went from 2 to 2,5, 01.03.2021. Equals 0.5, 25 %.
Spreadsheet: 153145d1335786900-how-to-extract-large-and-small-amounts-from-vlookup-match
Sheet: Sheet1

 | match | first | second | third
 | high
 | low
 | average
 | [NAME] | first | second | third
 | high |  |  |  |  | rand values | rank
 | low
 | average
Spreadsheet: 818818d1677069262-hour-computation-hour-computation-2
Sheet: Sheet1

 | Start | 22:00:00 | 21:00:00 | 23:00:00 | 18:00:00 | 21:00:00 |  | 20:00:00
 | End | 06:00:00 | 07:00:00 | 05:00:00 | 04:00:00 |  | 06:00:00 | 02:00:00
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | formulatext:
 | formulatext:
Spreadsheet: 811656d1672733895-formula-for-averaging-a-range-of-cells-according-to-subject-by-table-name-test-5
Sheet: Subject Analysis

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year | Group
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-2018 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-2019 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019-2020 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-2021 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-2022 | 5
 |  | Name | Name 10 |  | Year | Subject 1 | Subject 2 | Subject 3 | Subject 4 | Subject 5 | Subject 6 | Subject 7 | Subject 8 |  | 2022-2023
 |  |  |  |  | 2017-2018
 |  |  |  |  | 2018-2019
 |  |  |  |  | 2019-2020
 |  |  |  |  | 2020-2021
 |  |  |  |  | 2021-2022
 |  |  |  |  | 2022-2023
Spreadsheet: 775997d1649431228-pulling-multiple-zip-codes-from-a-report-zip-code-test
Sheet: Sheet1

Platform | Issuer Subscriber ID | Member [NAME] | Relationship Code | Effective Date | Termination Date | Mailing Address 1 | Mailing Address 2 | Mailing Address City | Mailing Address State | Mailing Address Zip Code | Mailing Address Country | [NAME]
On Exchange | 1 | Member [NAME] | Subscriber | 01/01/2022 | 12/31/2022 | Number and Street | Apt # | City | State | 53189 | US | email address
On Exchange | 2 | Member [NAME] | Subscriber | 01/01/2022 | 12/31/2022 | #N/A |  | #N/A | #N/A | 53092 | US | email address
On Exchange | 3 | Member [NAME] | Subscriber | 01/01/2022 | 12/31/2022 | #N/A |  | #N/A | #N/A | 54220 | US | email address
Spreadsheet: 21cfb8cc-0546-4513-affb-a75861d52a41
Sheet: Denials 2006

MULTNOMAH COUNTY LOAN DENIAL RATES BY INCOME-RACE GROUPINGS : 2006
FHA Loans for Home Purchase & Occupation
I.  Total Applications
Race/Ethnicity | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total
American Indian | 0 | 0 | 5 | 4 | 6 | 15
Asian | 1 | 3 | 6 | 5 | 6 | 21
Blacks | 0 | 2 | 8 | 2 | 5 | 17
Native Hawaiian or Pacific Islander | 0 | 0 | 0 | 0 | 0 | 0
White | 1 | 20 | 112 | 65 | 110 | 313
Hispanic | 1 | 3 | 12 | 5 | 9 | 30
Overall Total | 4 | 29 | 131 | 71 | 128 | 368
II.  Total Denials
 | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total
American Indian | 0 | 0 | 0 | 0 | 1 | 1
Asian | 0 | 0 | 0 | 0 | 2 | 2
Blacks | 0 | 2 | 1 | 1 | 1 | 5
Native Hawaiian or Pacific Islander | 0 | 0 | 0 | 0 | 0 | 0
White | 0 | 9 | 14 | 6 | 16 | 45
Hispanic | 0 | 1 | 1 | 1 | 2 | 5
Overall Total | 0 | 12 | 16 | 7 | 18 | 53
III. Denial Rates (II/I) * 100
 | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total
American Indian | 0 | 0
Asian
Blacks | 0
Native Hawaiian or Pacific Islander | 0 | 0 | 0 | 0 | 0 | 0
White
Hispanic
Overall Total
Source: HMDA (LAR)
Note: Data reported here is for Multnomah County. These are loans for the purpose of purchasing a home. The loans are for homes that are meant for a primary occupancy of the owner. These are all represented for conventional loans. For ethnic and racial breakout, these are loans originated by households where either the applicant or co-applicant are representative of that group.
Spreadsheet: 119699d1314669448-counting-cells-without-repeat-pt-squirrel_example-book
Sheet: Sheet1

Name | Event | Time Start | Time End |  |  |  |  | [NAME] | Chill Hotel | Holiday Inn
[NAME] | [NAME] | 1200 | 1500 |  | [NAME]
[NAME] | Chill Hotel | 900 | 1400 |  | [NAME]
[NAME] | Chill Hotel | 1200 | 1500 |  | [NAME]
[NAME] | Holiday Inn | 1509 | 1709
[NAME] | Holiday Inn | 1809 | 1909
 |  |  |  |  | Row Labels | Count of Event
 |  |  |  |  | [NAME] | 2
 |  |  |  |  | Chill Hotel | 1
 |  |  |  |  | [NAME] | 1
 |  |  |  |  | [NAME] | 1
 |  |  |  |  | Chill Hotel | 1
 |  |  |  |  | [NAME] | 2
 |  |  |  |  | Holiday Inn | 2
 |  |  |  |  | Grand Total | 5
Spreadsheet: 780884d1652853454-generating-random-array-with-conditions-random-weights
Sheet: Sheet1

 |  | Example List |  | Conditions
 |  | 0.02092005660623625 |  | 1. Generate 30 weights.
 |  | 0.03709348467934822 |  | 2. Each weight must be less than 10%
 |  | 0.05847144688689439 |  | 3. Sum of all weights must be 100%
 |  | 0.01960041415196592 |  | 4. For weights that are above 5%, sum of them must be not greater than 40%.
 |  | 0.04621567233992637
 |  | 0.01133416730281202
 |  | 0.0320378561195098 |  | Condition 1
 |  | 0.02556246045137877 |  | Condition 2
 |  | 0.02351647362474594 |  | Condition 3
 |  | 0.06804675739146045 |  | Condition 4
 |  | 0.009909331526363318
 |  | 0.008645657724656622
 |  | 0.0639556698486989
 |  | 0.049
 |  | 0.04214969644853481
 |  | 0.05837044896057407
 |  | 0.04329714540041499
 |  | 0.01246179792804267
 |  | 0.01303951103344359
 |  | 0.05014358541913974
 |  | 0.049
 |  | 0.01918305355761488
 |  | 0.001309060460912069
 |  | 0.0365193252656001
 |  | 0.01271532300781198
 |  | 0.05912374943988485
 |  | 0.0126827219983936
 |  | 0.03285134429847211
 |  | 0.04068176213071856