tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 32503d1228726327-matrix-problem-in-excel-matrix2
Sheet: matrix

 | c1 | c2 | c3 | c4 | c5 | c6 | c7 | c8 | c9
l1 | 1 | 0
l2 | 0 | 0
l3 | 0 | 0
[NAME] | 1 | 0
l5 | 0 | 1
l6 | 0 | 1
[NAME] | 0 | 1
[NAME] | 0 | 0
l9 | 0 | 1
I need a formula to display in sheet "c1" the lines with "1" value in the matrix, something like that
l2
[NAME]
for sheet c2
l5
l6
[NAME]
l9
and so on…
the actual formula shows "0" values, and I need to remove these "0" value
Spreadsheet: 37800d1235828817-rank-function-and-array-formula-error-book1
Sheet: Sheet1

Race No | Horse No | Rating | Rank
1 | 1 | 3
1 | 2 | 4
1 | 3 | 5
1 | 4 | 6
1 | 5 | 2
1 | 6 | 11
1 | 7 | 12
1 | 8 | 15
1 | 9 | 2.5
1 | 10 | 3
1 | 11 | 3
1 | 12 | 8
2 | 1 | 1
2 | 2 | 12
2 | 3 | 3
2 | 4 | 4
2 | 5 | 5
2 | 6 | 6
2 | 7 | 2
2 | 8 | 11
2 | 9 | 12
2 | 10 | 15
2 | 11 | 2.5
2 | 12 | 3
2 | 13 | 3
2 | 14 | 13
2 | 15 | 13
2 | 16 | 19
2 | 17 | 2
2 | 18 | 2
3 | 1 | 5
3 | 2 | 5
3 | 3 | 8
3 | 4 | 9
3 | 5 | 10
3 | 6 | 11
3 | 7 | 11
3 | 8 | 11
3 | 9 | 1
3 | 10 | 12
3 | 11 | 4
3 | 12 | 5
3 | 13 | 6
Spreadsheet: 756328d1637437781-need-formula-to-deduct-and-add-in-carton-box-pump-formula-pump-short
Sheet: Stocks Check

1 carton | = 16box |  |  |  | used | stock in | balance ingredient | CUSTOMER | contractor [NAME] | total | SQL  balance | + | - |  |  | Ca | B | P | Cu | Mod(Cu,3) | Sum(P,Mod(Cu,3)) | Mod(P,5) | Sum(B,[NAME])) | [NAME]) | Sum(Ca,[NAME]))
1 box | = 5pump |  |  |  |  |  | 1ca 10b 3p
 |  |  |  |  |  | 10b
unit |  |  |  |  | 1CA |  |  | 1CA | 4b 3p |  | 1ca 1b 4p | 3b | 1p
carton | = CA
box | = B
pump | = P
Spreadsheet: 735643d1623118908-countifs-formula-not-working-please-assist-education-count-sheet
Sheet: Array Info

Regular Investigators | Overseas Investigators | 900 Investigators | NCH Investigators
AAngelo | NMantinzo | AArguell | EFuentes
ACooper | Overseas | WTheodor | JHudman
Atyler |  |  | KMartine
[NAME] |  |  | NCH
BRENDA |  |  | SRoden
Educat1
Educat2
IOkon
JEbare
[NAME]
[NAME]
[NAME]
NJackson
PAlvaren
[NAME]
SSanderc
VJenning
Spreadsheet: 65552d1266278964-excel-2007-match-function-salesviewsortedtable
Sheet: SalesViewSortedTable

recordNumber | departmentNumber | majorDepartmentNumber | isMajorDept | departmentDescription | itemCount | netSales | voidAmount | refundAmount | returnAmount | storeCouponAmount | cmRewardsAmount | markdownAmount
8 | 51 | 1051 |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
91 | 401 | 4000 |  | Money Orders | 11 | 2437.47 | 0 | 0 | 0 | 0 | 0 | 0
98 | 408 | 4000 |  | [NAME] | 6 | 160 | 0 | 0 | 0 | 0 | 0 | 0
100 | 410 | 4000 |  | Copy Machine | 186 | 14.02 | 8.91 | 0 | 0 | 0 | 0 | 0
104 | 415 | 4000 |  | SBC Payments | 2 | 134.52 | 0 | 0 | 0 | 0 | 0 | 0
108 | 419 | 4000 |  | Scratch Off | 140 | 484 | 0 | 0 | 0 | 0 | 0 | 0
110 | 421 | 4000 |  | On-Line Lotto | 146 | 545 | 5 | 0 | 0 | 0 | 0 | 0
123 | 434 | 4000 |  | Postage | 30 | 46.64 | 0 | 0 | 0 | 0 | 0 | 0
149 | 506 | 5000 |  | [NAME] | 46 | -502 | 0.01 | 0 | 0 | 0 | 0 | 0
155 | 512 | 5000 |  | Employee Discount | 0 | -139.83 | 0 | 0 | 0 | 0 | 139.83 | 0
139 | 865 | 4000 |  | House Charge Payment | 11 | 1339.16 | 0 | 0 | 0 | 0 | 0 | 0
7 | 1051 | 1051 | * | COUPONS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
89 | 4000 | 4000 | * | MISC PAID IN | 542 | 5390.76 | 13.91 | 0 | 0 | 0 | 0 | 0
142 | 5000 | 5000 | * | MISC PAID OUTS | 46 | -641.83 | 0.01 | 0 | 0 | 0 | 139.83 | 0
140 | 9025 | 4000 |  | Blackhawk Gift Cards | 9 | 225 | 0 | 0 | 0 | 0 | 0 | 0
141 | 9026 | 4000 |  | Blackhawk Fees | 1 | 4.95 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 708936d1608102304-combine-data-feom-2-rows-in-2-comlumns-into-one-row-and-column-d-and-p-ans2
Sheet: Mar

name | bol date | am/pm | d/p |  |  | total
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7
kate | 2020-03-02 00:00:00 | am | d
kitty | 2020-03-06 00:00:00 | pm | d
mary | 2020-03-15 00:00:00 | am | p
 |  |  |  |  | Total
Spreadsheet: 78175d1278587493-why-is-my-vlookup-formula-not-working-test1
Sheet: Sheet1

 | A | B | X | Y | Z
1 | ID | Name |  | Name | Code
2 | 111 | A | #N/A | E | [NAME]
3 | 222 | B | #N/A | C | UUU
4 | 333 | C | #N/A | D | GGG
5 | 444 | D | #N/A | B | BBB
6 | 555 | E | #N/A | A | NNN
Spreadsheet: 787397d1657783731-combine-vlookup-match-and-countifs-ask-for-help-online
Sheet: Sheet1

Person | Fruits
A | Apple
A | [NAME]
A | Watermelon
A | Watermelon
B | Watermelon
B | [NAME]
C | Watermelon
C | Apple
D | Apple
D | Apple
Spreadsheet: 151207d1334830416-can-i-sort-horizontally-some-how-when-i-have-merged-cells-horizontal-sort
Sheet: Sheet3

 |  | 1/. Copy A:B and Paste Special > Values to D:E | [NAME] | 1
 |  |  | [NAME] | 2
 |  | 2/. Sort D:E (no header) | [NAME] | 3
 |  | Sort by Column D Ascending, Then by Column E ascending | [NAME] | 4
 |  |  | [NAME] | 9
 |  | 3/. Copy the result in Column E | [NAME] | 10
 |  | Then Paste Special > All and Check the Transpose option to say Sheet2!B1 | [NAME] | 11
 |  |  | [NAME] | 12
 |  |  | [NAME] | 5
 |  |  | [NAME] | 6
 |  |  | [NAME] | 7
 |  |  | [NAME] | 8
 |  |  | [NAME] | 13
 |  |  | [NAME] | 14
 |  |  | [NAME] | 15
 |  |  | [NAME] | 16
Spreadsheet: 89859d1289584937-help-with-counting-with-conditions-and-merged-cells-excel-help2
Sheet: Sheet3

School
 | State | Region | MD/MPH? |  | [NAME] | Behavioral Science | BioChem | Biology | Bio/Zoology | Calc | English | Math | Computer Science | Genetics | Humanities | Organic Chemistry | Physics | Psych | Social Sciences | Other
Med School A | CA | West | Yes | Required | ● |  | ● | ● |  |  | ● |  |  |  | ● | ● | ● |  | ● | Molecular Biology (1)
 |  |  |  | Recommended |  |  |  |  |  | ● |  | ● | ●
 |  |  |  | Semesters | 2 |  | 1 | 2 |  |  |  |  |  |  |  | 1 | 2
Med School B | IL | Midwest | Yes | Required | ● |  |  | ● |  |  |  |  |  |  |  | ● | ●
 |  |  |  | Recommended |  | ● | ● |  |  | ● | ● |  |  | ● | ● |  |  |  | ●
 |  |  |  | Semesters | 2 |  |  | 2 |  |  |  |  |  |  |  | 2 | 2
 |  |  | # of Schools Requiring... |  | 2 | 0 | 1 | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 2 | 2 | 0 | 1
 |  |  |  | 1 Semester | 0 |  | 1 |  |  |  |  |  |  |  |  | 1
 |  |  |  | 2 Semesters | 2 |  |  | 2 |  |  |  |  |  |  |  | 1 | 2
 |  |  |  | >2 Semesters
 |  |  | By Region:
● |  |  |  | West | 1 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 1
 |  |  |  | Midwest | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0
Number of Schools:  2 |  |  |  | South | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
West  1 |  |  |  | New England | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Midwest  1 |  |  |  | Mid-Atlantic | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
South  0 |  |  |  | Southwest | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
New England  0
Mid-Atlantic  0
Southwest 0
 |  |  | # of Schools Recommending… |  | 0 | 1 | 1 | 0 | 0 | 2 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 1
Spreadsheet: 864800d1711949502-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record-aligw
Sheet: MEG

Raw Material |  | MEG
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 17124
Total
Spreadsheet: 1ffd9a9d-ae62-446a-a55f-5bfd3a47ac55
Sheet: Sheet1

Campus | Last Name | First Name | [NAME] | Phone Number | Fax Number | Street | Street2 | City | State | Zip
Appalachian State University | Scott | Lloyd | [EMAIL] | [PHONE] | [PHONE] | Academy Drive |  | Boone | NC | 28608
East Carolina University | Britt | [NAME] | [EMAIL] | [PHONE] | [PHONE] | East Fifth Street |  | Greenville | NC | 27858
Elizabeth City State University | Dutch | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1704 Weeksville Road |  | Elizabeth City | NC | 27909
Fayetteville State University | [NAME] | Ulisa | [EMAIL] | [PHONE] | [PHONE] | 1200 Murchison Road |  | Fayetteville | NC | 28301
NC Agricultural and Technical State University | Scales | Keyana |  | [PHONE] | [PHONE] | 1601 East Market Street |  | Greensboro | NC | 27411
North Carolina Central University | Brooks | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1801 Fayetteville Street |  | [NAME] | NC | 27707
NC State University | Griffin | [NAME] | [EMAIL] | [PHONE] | [PHONE] |  |  | Raleigh | NC | 27695
UNC Asheville | [NAME] | Shannon | [EMAIL] | [PHONE] |  | 1 University Heights |  | Asheville | NC | 28804
UNC-Chapel Hill |  |  |  |  |  |  |  | Chapel Hill | NC | 27599
UNC Charlotte |  |  |  |  |  | 9201 University City Boulevard |  | Charlotte | NC | 28223
UNC Greensboro | [NAME] | Elise | [EMAIL] | [PHONE] | [PHONE] | Post Office Box 26170 |  | Greensboro | NC | 27402
UNC Pembroke | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1 University Drive |  | Pembroke | NC | 28372
[NAME] | Moreno | Marcio | [EMAIL] | [PHONE] |  | 601 South College Road |  | [NAME] | NC | 28403
UNC School of the Arts | [NAME] | Sheeler | [EMAIL] | [PHONE] | [PHONE] | 1533 South Main St. |  | Winston-Salem | NC | 27127
Western Carolina University |  |  |  |  |  |  |  | Cullowhee | NC | 28723
Winston-Salem State University | Pollard | [NAME] | [EMAIL] | [PHONE] |  | 601 [NAME], Jr. Drive |  | Winston-Salem | NC | 27110
North Carolina School of Science and Mathematics | Mason | Letita | [EMAIL] | [PHONE] | [PHONE] | 1219 Broad Street |  | [NAME] | NC | 27705
Spreadsheet: 07ce9bcd-03ea-4948-a4f8-39f941fedb6c
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (2 Entries):
 | 14 Wireless 14.3 Wireless applications 14.3.6 TV receiver subsystems
No. | Company | Country | City | [NAME] | Hall/Booth
1 | Samsung Electro-Mechanics GmbH | Germany | Schwalbach | 65824 | B6.173
2 | Seltech | France | ORLY | 94310 | A5.210
Spreadsheet: richard_shapiro__32195__mar01
Sheet: mar01.xls

COST CENTER | MONTHLY ACTUALS | MONTHLY BUDGET | MONTHLY [NAME] | ANNUAL BUDGET | YEAR TO DATE ACTUALS | YEAR TO DATE AVAILABLE
100042 - Robertson | 490193.49 | 161856 |  | 1942180 | 761325.73
100062 - Shapiro | 2804005.75 | 1772467 |  | 21437581 | 6143986.54
100072 - Ryall | 34735.5 | 31839 |  | 382068 | 57752.83
100085 - Kaufman | 24733.14 | 63000 |  | 766000 | 168981.2
100086 - Dadson | 3906.74 | 75323.67 |  | 816758 | 62046.69
100087 - Montovano | 127068.8 | 63333 |  | 760000 | 300451.09
100088 - Migden | 28172 | 12916 |  | 634992 | -74824.68
100100 - Charvel | 78212.99 | 70007 |  | 839251 | 206766.26
100108 - Steffes | 50385.32 | 27450 |  | 329200 | 123591.86
103885 - Kingerski | 16679.62 | 39583 |  | 474996 | 59430.75
103886 - Yoho | 3788.84 | 10000 |  | 120000 | 8874.62
103887 - Nord | 40838.7 | 27500 |  | 330000 | 69758.61
TOTAL
Spreadsheet: 485419d1476877808-i-need-to-find-a-formula-that-calculates-how-much-time-falls-into-a-certain-criteria-sampel-work-cal-_-as-_-different-options-available
Sheet: PayRates

 | Rates of pay per Hr | Times | Rate |  | Named Ranges are set in this file as follows:
 | Base Pay | 00-24 | 13.74
 | Mon-Fri evening extra | 18-24 | 0.75 |  |  | Pay 'Names' | Value | Reference
 | Sat pm/eve extra | 14-24 | 2.05 |  |  | NR_BasePay | 13.74 | PayRates!$D$3
 | Night extra | 00-06 | 1.5 |  |  | NR_MFEvePay | 0.75 | PayRates!$D$4
 | Sunday extra | 00-24 | 2.35 |  |  | NR_SatEvePay | 2.05 | PayRates!$D$5
 |  |  |  |  |  | NR_NightPay | 1.5 | PayRates!$D$6
 |  |  |  |  |  | NR_SunPay | 2.35 | PayRates!$D$7
 |  |  |  |  |  | Time Period 'Names' | Value | [NAME] | Notes
 |  |  |  |  |  | NR_MFEveStart | 0.75 |  | Equivalent to 18:00
 |  |  |  |  |  | NR_MFEveEnd | 1 |  | Equivalent to 24:00
 |  |  |  |  |  | NR_SatEveStart | {…} | MOD(TIME(14,0,0),1) | Gives exact value of 14:00
 |  |  |  |  |  | NR_SatEveEnd | 1 |  | Equivalent to 24:00
 |  |  |  |  |  | NR_NightStart | 0 |  | Equivalent to 00:00
 |  |  |  |  |  | NR_NightEnd | 0.25 |  | Equivalent to 06:00
Spreadsheet: a5afd202-d3b3-44ad-9ae9-f8df6896b1c1
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7571 | 58763 | Cristina | Milton | GBR | 1101 | 01:24:19 | 00:03:20 | 04:04:58 | 00:02:08 | 02:59:07 | 1 | 08:33:51
7571 | 54808 | [NAME] | Burgess | CAN | 1103 | 01:30:15 | 00:05:04 | [NAME] | 00:03:30 | 03:11:08 | 2 | 08:51:46
7571 | 18298 | [NAME] | [NAME] | DEN | 1104 | [NAME] | 00:05:12 | 04:09:51 | 00:02:16 | 03:13:29 | 3 | 09:06:14
7571 | 34269 | [NAME] | Rich | USA | 1102 | 02:07:49 | [NAME] | 04:20:17 | 00:03:32 | 03:34:42 | 4 | 10:08:20
Spreadsheet: kate_symes__18779__MidC
Sheet: DJ Mid-C 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-03-05 00:00:00 |  | 322.23 | 12560 | 296.39 | 4712
 | 2001-03-04 00:00:00 |  | 310 | 0 | 270 | 0 | 289.47 | 475 | 246.67 | 375 |  | 296.48 | 15336
 | 2001-03-03 00:00:00 |  | 305.25 | 20560 | 267.01 | 8232 | 250.36 | 685 | 281.25 | 160
 | 2001-03-02 00:00:00 |  | 305.25 | 20560 | 267.01 | 8232 | 377.23 | 90 | 300 | 100
 | 2001-03-01 00:00:00 |  | 298.9 | 27200 | 269.54 | 7872 | 372.61 | 244 | 255 | 160
 | 2001-02-28 00:00:00 |  | 200.96 | 25024 | 183.83 | 13864 | 316.43 | 2298 | 258.89 | 1480
 | 2001-02-27 00:00:00 |  | 201.92 | 15424 | 178.85 | 6464 | 244.23 | 455 | 204.11 | 1255
 | 2001-02-26 00:00:00 |  | 245.45 | 11424 | 227.06 | 6928 | 198.18 | 550 | 160 | 50
 | 2001-02-25 00:00:00 |  | 240 | 800 | 210 | 0 | 173.83 | 962 | 159.04 | 584 |  | 227.06 | 20784
 | 2001-02-24 00:00:00 |  | 194.5 | 20624 | 152.04 | 7328 | 186.82 | 2727 | 184.22 | 870
 | 2001-02-23 00:00:00 |  | 194.65 | 20624 | 152.04 | 7328 | 278.92 | 300 | 186.49 | 208
 | 2001-02-22 00:00:00 |  | 253.75 | 17824 | 217.96 | 5880 | 190.34 | 576 | 143.24 | 795
 | 2001-02-21 00:00:00 |  | 291.88 | 11824 | 261.34 | 6928 | 295 | 50 | 220.57 | 485
 | 2001-02-20 00:00:00 |  | 326.7 | 22224 | 310.97 | 5328 | 275 | 78 | 222.94 | 375
 | 2001-02-19 00:00:00 |  | 326.67 | 22624 | 310.97 | 5328 | 335.35 | 174 | 259.78 | 115
 | 2001-02-18 00:00:00 |  | 325 | 800 | 310 | 0 | 275.26 | 476 | 266.22 | 555 |  | 336.69 | 11784
 | 2001-02-17 00:00:00 |  | 349.98 | 15824 | 336.58 | 3800 | 347.69 | 281 | 332.5 | 0
 | 2001-02-16 00:00:00 |  | 460.66 | 15248 | 410.94 | 5160 | 397.28 | 230 | 350 | 40
 | 2001-02-15 00:00:00 |  | 460.66 | 15248 | 410.94 | 5160 | 348.8 | 1693 | 398.23 | 784
 | 2001-02-14 00:00:00 |  | 327.05 | 15664 | 314.82 | 3928 | 479.05 | 452 | 472.12 | 165
 | 2001-02-13 00:00:00 |  | 335.68 | 13424 | 322.6 | 4728 | 386.38 | 1053 | 330 | 0
 | 2001-02-12 00:00:00 |  | 302.64 | 12624 | 279.2 | 4528 | 271.84 | 1346 | 324.32 | 544
 | 2001-02-11 00:00:00 |  | 285 | 0 | 270 | 0 | 312.37 | 316 | 326.04 | 96 |  | 278.81 | 12600
 | 2001-02-10 00:00:00 |  | 276.16 | 15824 | 238.78 | 3328 | 322.06 | 790 | 309.3 | 328
 | 2001-02-09 00:00:00 |  | 276.16 | 15824 | 238.78 | 3328 | 341.87 | 3340 | 307.19 | 1050
 | 2001-02-08 00:00:00 |  | 381.43 | 15120 | 316.79 | 3376 | 341.12 | 2521 | 320.97 | 373
 | 2001-02-07 00:00:00 |  | 274.49 | 8688 | 253.14 | 4024 | 294.97 | 2143 | 251.02 | 216
 | 2001-02-06 00:00:00 |  | 213.71 | 10784 | 195.79 | 4096 | 259.92 | 63 | 196.16 | 307
 | 2001-02-05 00:00:00 |  | 200.43 | 11824 | 196.63 | 3968 | 204.52 | 1904 | 179.61 | 727
 | 2001-02-04 00:00:00 |  | 200 | 0 | 185 | 0 | 181.95 | 1513 | 175.11 | 1100 |  | 196.25 | 10704
 | 2001-02-03 00:00:00 |  | 222.8 | 15824 | 195.9 | 7648 | 185 | 35 | 199.94 | 233
 |  |  |  |  |  | ..
Spreadsheet: 674977d1588096967-simplifying-values-for-a-point-system-test
Sheet: Sheet1

 | Value | Points
MSI Alpha 15 - CC | 16
Lenovo Ideapad S540 - CC | 12
Acer Swift 5 - CC | 16
Dell Inspiron - Dell | 16
Acer Aspire 5 - Best Buy | 16
Acer Aspire 5 - Amazon | 12
IdeaPad 5 - Lenovo | 8
Lenovo Legion Y540 - Costco | 16
MSI GF63 - Newegg | 16
Spreadsheet: 162730d4-bae1-4fbb-919a-dbacff91fd6d
Sheet: Sheet1

Table 6--Wholesale corn milling product and byproduct prices, 3/12/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Mkt year and month 1/ | Corn meal, yellow,  Chicago, IL (dollars per cwt) |  | Corn meal, yellow,  New York, NY (dollars per cwt) |  | Corn starch,  Midwest 3/ (dollars per cwt) |  | Dextrose,  Midwest (cents per pound) |  | High-fructose corn syrup (42%),  Midwest (cents per pound)
 | 2011/12 | 2012/13 | 2011/12 | 2012/13 | 2011/12 | 2012/13 | 2011/12 | 2012/13 | 2011/12 | 2012/13
Sep | 27.9925 | 29.205 | 30.2975 | 31.03 | 23.25999999999998 | 24.21999999999998 | 30.85 | 34.85 | 21.375 | 23.375
Oct | 26.7825 | 28.555 | 29.0875 | 30.385 | 22.62999999999998 | 23.04999999999998 | 30.85 | 34.85 | 21.375 | 23.3765
Nov | 26.8975 | 28.34 | 29.2025 | 30.17 | 20.04999999999998 | 22.23999999999998 | 30.85 | 35.35 | 21.375 | 23.375
Dec | 25.74 | 28.01 | 28.045 | 29.84 | 20.88999999999998 | 22.26999999999998 | 30.85 | 35.1 | 21.375 | 23.375
Jan | 24.855 | 27.93166666666667 | 26.555 | 29.76166666666667 | 19.89999999999998 | 22.77999999999998 | 34.85 | 35.35 | 23.375 | 25.875
Feb | 26.39833333333333 | 27.37 | 30.37 | 29.2 | 21.39999999999998 | 22.26999999999998 | 33.85 | 35.35 | 23.375 | 25.875
Mar | 26.1675 |  | 27.92 |  | 21.78999999999998 |  | 35.85 |  | 23.375
Apr | 25.5175 |  | 27.545 |  | 22.08999999999998 |  | 34.85 |  | 23.375
May | 24.485 |  | 26.7675 |  | 21.33999999999998 |  | 34.85 |  | 23.375
Jun | 24.295 |  | 25.995 |  | 21.24999999999998 |  | 34.85 |  | 23.375
Jul | 28.345 |  | 30.045 |  | 20.64999999999998 |  | 35.35 |  | 23.375
Aug | 29.86166666666666 |  | 31.56166666666667 |  | 24.09999999999998 |  | 34.85 |  | 23.375
Mkt year 2/ | 26.44479166666666 |  | 28.61597222222223 |  | 21.61249999999998 |  | 33.55833333333334 |  | 22.70833333333333
1/ September-August. Latest month is preliminary. 2/ Simple average of monthly prices for the marketing year. 3/ Bulk-industrial, unmodified. Source: Milling and Baking News, except for corn starch which is from private industry.
Date run: 3/10/2013
Spreadsheet: 273107d1382615183-find-out-specifi-numbers-from-range-0a1_sample-book
Sheet: Sheet1

 |  |  | Sl.No.
 |  |  | 376098
 |  |  | 648086
 |  |  | 285876
 |  |  | 776497
 |  |  | 627364
 |  |  | 636706
 |  |  | 860739
 |  |  | 691335
 |  |  | 434687
 |  |  | 746902
 |  |  | 961479
 |  |  | 319203
 |  |  | 324338
 |  |  | 607694
 |  |  | 259854
 |  |  | 664462
 |  |  | 331795
 |  |  | 206787
 |  |  | 362939
 |  |  | 971919
Spreadsheet: 117155d1312478308-lookup-help-2011-master-schedule
Sheet: 2011 Big 10

Day | Thurs | Sat | Fri | Sat | Fri | Sat | Sat | Sat | Sat | Sat | Sat | Sat | Sat | Sat | Fri | Sat | Thur | Sat | Sat
Date | 2011-09-01 00:00:00 | 2011-09-03 00:00:00 | 2011-09-09 00:00:00 | 2011-09-10 00:00:00 | 2011-09-16 00:00:00 | 2011-09-17 00:00:00 | 2011-09-24 00:00:00 | 2011-10-01 00:00:00 | 2011-10-08 00:00:00 | 2011-10-15 00:00:00 | 2011-10-22 00:00:00 | 2011-10-29 00:00:00 | 2011-11-05 00:00:00 | 2011-11-12 00:00:00 | 2011-11-18 00:00:00 | 2011-11-19 00:00:00 | 2011-11-24 00:00:00 | 2011-11-26 00:00:00 | 2011-12-03 00:00:00
Illinois |  | [NAME] |  | SDakSt |  | ArizSt | WMich | NW | @IND | OHIOST | @PUR | @PENNST | OPEN | MICH |  | WISC |  | @MINN
Indiana |  | @BallSt |  | Virginia |  | SCarSt | @NTexas | PENNST | ILL | @WISC | @IOWA | NW | @OHIOST | OPEN |  | @MICHST |  | PUR
Iowa |  | TnTech |  | @IowaSt |  | PITT | Monroe | OPEN | @PENNST | NW | IND | @MINN | MICH | MICHST |  | @PUR |  | @NEB
Michigan |  | WMich |  | NDame |  | EMich | SDiegoSt | MINN | @NW | @MICHST | OPEN | PUR | @IOWA | @ILL |  | NEB |  | OHIOST
[NAME] |  | [NAME] |  | FlaAtl |  | @NDame | CMich | @OHIOST | OPEN | MICH | WISC | @NEB | MINN | @IOWA |  | IND |  | @NW
Minnesota |  | [NAME] |  | NMexSt |  | MiamiO | NDakSt | @MICH | @PUR | OPEN | NEB | IOWA | @MICHST | WISC |  | @NW |  | ILL
Nebraska |  | UTChat |  | Fresno |  | UWash | @Wyo | @WISC | OHIOST | OPEN | @MINN | MICHST | NW | @PENNST |  | @MICH |  | IOWA
Northwestern |  | @BC |  | EIllinois |  | @Army | OPEN | @ILL | MICH | @IOWA | PENNST | @IND | @NEB | [NAME] |  | MINN |  | MICHST
Ohio State |  | Akron |  | Toledo |  | @MiamiFl | Colorado | MICHST | @NEB | @ILL | OPEN | WISC | IND | @PUR |  | PENNST |  | @MICH
Penn State |  | IndSt |  | Bama |  | @Temple | EMich | @IND | IOWA | PUR | @NW | ILL | OPEN | NEB |  | @OHIOST |  | @WISC
Purdue |  | MTenn |  | @Rice |  | SEMO | OPEN | NDame | MINN | @PENNST | ILL | @MICH | @WISC | OHIOST |  | IOWA |  | @IND
Wisconsin |  | UNLV |  | OreSt |  | NIllinois | SDakota | NEB | OPEN | IND | @MICHST | @OHIOST | PUR | @MINN |  | @ILL |  | PENNST
Texas |  | [NAME] |  | BYU |  | @UCLA | OPEN | @ISU | OKLA | OKSt | OPEN | KU | TTU | [NAME] |  | KSU | @TAMU |  | @Baylor
Arizona St. | [NAME] |  | Mizzou |  |  | @ILL | @USC | @OreSt | @Utah | @Oregon | OPEN | CU | @UCLA | [NAME] |  | Arizona |  | Cal
Iowa St. |  | UNI |  | Iowa | @UCONN |  | OPEN | Texas | @Baylor | @Mizzou | TAMU | TTU | KU | OPEN | OKSt |  |  | @OU | @KSU
Spreadsheet: 542840d1508141425-drop-down-lists-book-gk-final-6-
Sheet: Sheet1

Agent Name |  | Agent | Tasks |  |  |  |  | Agent |  | Tasks
 |  | IB_ | AGENT_PG_01.001.Inbound |  |  |  |  | IB_
 |  | IB_ | AGENT_PG_01.031.BCT
 |  | IB_ | AGENT_PG_01.038.GEM
 |  | IB_ | AGENT_PG_01.050.Billing_Overflow
 |  | IB_ | AGENT_PG_01.059.RS_Overflow
 |  | IB_ | AGENT_PG_01.125.Billing_3rdShift
 |  | IB_2 | AGENT_PG_01.162.MMOF_IB
 |  | IB_2 | AGENT_PG_01.166.ProdOF_IB
 |  | IB_2 | AGENT_PG_01.247.DaVinciSales_OF
 |  | IB_ | AGENT_PG_01.251.UK
 |  | IB_ | AGENT_PG_01.259.SMB_OF
 |  | IB_ | AGENT_PG_01.267.UK_Hosting_OF
 |  | IB_ | AGENT_PG_01.269.UK_Prod_OF
 |  | IB_ | AGENT_PG_01.316.SmartLine_OF
 |  | IB_ | AGENT_PG_01.322.CA
 |  | IB_ | AGENT_PG_01.326.CA_Hosting_OF
 |  | IB_ | AGENT_PG_01.328.CA_Prod_OF
 |  | IB_ | [NAME]
 |  | IB_ | AGENT_PG_01.334.AU_Hosting_OF
 |  | IB_ | AGENT_PG_01.336.AU_Prod_OF
Spreadsheet: 684021d1593100475-automated-creation-of-a-two-unique-lists-from-a-source-sheet-companyandworker
Sheet: Raw Data

WEEK | COMPANY | WORKER | INVOICE | SALARY
25 | Company 1 | Worker 1 | 150 | 100
25 | Company 2 | Worker 2 | 100 | 80
25 | Company 1 | Worker 3 | 50 | 40
25 | Company 3 | Worker 1 | 200 | 150
26 | Company 1 | Worker 3 | 50 | 40
26 | Company 4 | Worker 1 | 100 | 80
26 | Company 2 | Worker 3 | 100 | 70
27 | Company 2 | Worker 3 | 100 | 70
27 | Company 2 | Worker 2 | 100 | 80
Spreadsheet: 851987d1702092628-return-name-from-a-list-by-certain-country-and-number-of-employees-book1
Sheet: Sheet1

 | Factory | Country | City | Employees |  |  | THAILAND | INDONESIA | VIETNAM | LAOS | INDIA
 | Fac01 | India | Vita | 38 |  |  |  |  |  |  |  | << [NAME] return only factory from that country sorted by smallest to highest employees
 | Fac02 | India | Vadodara | 44
 | Fac03 | India | Karjat | 42
 | Fac04 | Indonesia | Bali | 120
 | Fac05 | Indonesia | Bali | 175
 | Fac06 | Laos | Vientiane | 94
 | Fac07 | Thailand | Bangkok | 390
 | Fac08 | Thailand | [NAME] | 128
 | Fac09 | Thailand | Bangkok | 194
 | Fac10 | Thailand | Pattaya | 164
 | Fac11 | Thailand | Bangkok | 224
 | Fac12 | Thailand | [NAME] | 41
 | Fac13 | Thailand | Kanchanaburi | 50
 | Fac14 | Thailand | Pattaya | 64
 | Fac15 | Thailand | [NAME] | 63
 | Fac16 | Thailand | [NAME] | 147
 | Fac17 | Thailand | Pattaya | 44
 | Fac18 | Thailand | Bangkok | 86
 | Fac19 | Thailand | Bangkok | 494
 | Fac20 | Thailand | [NAME] | 413
 | Fac21 | Thailand | Phuket | 180
 | Fac22 | Thailand | Samui | 51
 | Fac23 | Thailand | [NAME] | 25
 | Fac24 | Thailand | [NAME] | 69
 | Fac25 | Vietnam | [NAME] | 268