tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 93612d1293206491-automatic-number-and-date-sorting-formula-number_n_category_sorting_result_excepted
Sheet: BA_Database

BA Number | Invoice Date | Invoice Number | Invoice Amount | BA First Invoice Date | BA Total Amount | BA Total Rounddown Amount | BA Due Date | Days Left | Payment Bank | Payment Account Number
801102 | 2010-11-10 00:00:00 | INV20918 | 5000 | **would like to find the first invoice date, which is [NAME], from group number of BA number 801102
801102 | 2010-11-13 00:00:00 | INV20919 | 6390
801102 | 2010-11-12 00:00:00 | INV20920 | 8432
801102 | 2010-11-13 00:00:00 | INV20921 | 7582
801102 | 2010-11-09 00:00:00 | INV20922 | 8450
801102 | 2010-11-15 00:00:00 | INV20923 | 31242
801103 | 2010-11-12 00:00:00 | INV20924 | 3912
801103 | 2010-11-06 00:00:00 | INV20925 | 734
801103 | 2010-11-09 00:00:00 | INV20926 | 450
801103 | 2010-11-15 00:00:00 | INV20927 | 12
801104 | 2010-11-15 00:00:00 | INV20927 | 1699
801102 | 2010-11-10 00:00:00 | INV20918 | 5000
801102 | 2010-11-13 00:00:00 | INV20919 | 6390
801102 | 2010-11-12 00:00:00 | INV20920 | 8432
801102 | 2010-11-13 00:00:00 | INV20921 | 7582
801102 | 2010-11-09 00:00:00 | INV20922 | 8450
801102 | 2010-11-15 00:00:00 | INV20923 | 31242
801103 | 2010-11-12 00:00:00 | INV20924 | 3912
801103 | 2010-11-06 00:00:00 | INV20925 | 734
801103 | 2010-11-09 00:00:00 | INV20926 | 450
801103 | 2010-11-15 00:00:00 | INV20927 | 12
801104 | 2010-11-15 00:00:00 | INV20927 | 1699
Spreadsheet: 546414d1510044248-limit-calculated-value-to-18-000-if-age-50-then-26-000-if-50-401-k-savings-calculator
Sheet: 401(k) Balance

401(k) Balance
Your Age: |  |  |  |  | 49
Current 401(k) Balance:
Your Annual Salary:
Your contributions this year:
Cumulative Contributions To-Date:
Employer Match this year:
Employer Contributions To-Date:
Average Return Rate:
Interest Earned:
Savings Projection Chart
Spreadsheet: 887370d1737609155-scraping-data-from-multiple-similar-excel-sheets-lcs_query
Sheet: Sheet1

Names | Week1 | Week2 | Week3
JAE | 0 | 0 | 0
SKP | 0 | 0 | 0
YH | 5 | 5 | 5
SG | 0 | 0 | 0
MA | 8 | 8 | 8
EM | 0 | 0 | 5
JS | 0 | 0 | 0
AM | 0 | 0 | 8
HB | 0 | 0 | 0
SB | 0 | 0 | 0
AB | 2 | 2 | 2
PSD | 0 | 0 | 0
SH | 0 | 0 | 0
MY | 0 | 0 | 0
SAF | 0 | 0 | 0
AAA | 0 | 2 | 0
VD | 0 | 7 | 0
AR | 0 | 0 | 0
SAA | 0 | 0 | 0
HAA | 5 | 5 | 5
AA | 0 | 0 | 0
SHS | 2 | 2 | 2
PN | 7 | 7 | 7
AM | 0 | 0 | 0
SA | 0 | 0 | 5
MAM | 0 | 0 | 0
AAS | 0 | 0 | 2
SAJ | 0 | 0 | 11
IAN | 0 | 0 | 7
MAM | 0 | 0 | 0
Spreadsheet: 804391d1668037293-formula-for-printing-all-sheets-xcvbtr10
Sheet: 9

 |  | [NAME])  YA MSHIRIKA T.A.G HERMON REVIVAL CHURCH |  |  |  |  |  |  |  |  | MWAKA
 |  | JINA KAMILI | WEEKS | JAN | FEB | [NAME] | APRIL | MAY | [NAME] | JULY | AUGU | SEPT | OKT | NOV | DEC | JUMLA
 |  | H | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | JUMLA
Spreadsheet: 743175d1628267416-extract-text-extract-text-in-between
Sheet: Sheet1

Data | Desired result |  | [NAME] | Custom
GERMANY-500-OBERMAIN-C-15_10 | 15 |  | GERMANY-500-OBERMAIN | 15
BRAZIL-5000-SAMBA-C-M_2 | M |  | BRAZIL-5000-SAMBA | M
ITALY-5000-LAZIO-C-XL_2 | XL |  | ITALY-5000-LAZIO | XL
FRANCE-2500-PSG-C-2125_2 | 21/25 |  | FRANCE-2500-PSG | 21/25
AUSTRALIA-1300-SYDNEY-L-2630_6 | 26/30 |  | AUSTRALIA-1300-SYDNEY | 26/30
ENGLAND-500-BECKHAM-L-15_10 | 15 |  | ENGLAND-500-BECKHAM | 15
I want to extract text in between "-C-" (somestimes also can be "-L-", example in cell A7 and A8) and "_"
For those result that have 4 characters, stroke "/" will insert in the middle of the text. Example please refer in cell [NAME] and B7
Spreadsheet: 840479d1692769335-sum-by-matching-in-sheet2-from-sheet1-sum
Sheet: Sheet2

 |  |  |  |  |  |  | Office 365 | Office 2021
 |  |  |  | [NAME]
 |  |  |  | Ma-84/97/140
 |  |  |  | Ash-71/142
 |  |  |  | [NAME] |  |  |  |  | 97
 |  |  |  | M-8/9/44
Spreadsheet: 51361d1250969696-how-to-input-linreg-eq-to-find-predicted-values-of-x-and-ys-math136projectdata
Sheet: 77

http://www.fbi.gov/ucr/cius2007/documents/cius2007datatables.zip |  | This particular file is named 07tbl77.xls within the .zip
R² = [PHONE]
Full-time Law Enforcement Employees
by State, 2007
State | 2007  estimated  population (x) | Total law enforcement employees (y) | Predicted | Residual
ALABAMA | 4533379 | 16347 | 15759.340789303
ALASKA | 681180 | 1888 | 662.6518783825002
ARIZONA | 6054541 | 22144 | 21720.743483482
ARKANSAS | 2832708 | 8455 | 9094.4460040585
CALIFORNIA | 31683834 | 120976 | 122161.4173499755
COLORADO | 4807287 | 16756 | 16832.780626189
CONNECTICUT | 3502309 | 9873 | 11718.598596238
DELAWARE | 853364 | 3125 | 1337.4374446105
DISTRICT OF COLUMBIA | 588292 | 5021 | 298.6257105865
FLORIDA | 18251243 | 74562 | 69519.368589091
GEORGIA | 7708266 | 28979 | 28201.6578571195
HAWAII | 1283388 | 3678 | 3022.6926851185
IDAHO | 1496944 | 4068 | 3859.6142712205
ILLINOIS | 12813230 | 53537 | 48207.9071213575
INDIANA | 5961949 | 16163 | 21357.877333618
IOWA | 2976754 | 7812 | 9658.9593251155
KANSAS | 2691761 | 10532 | 8542.077600472001
KENTUCKY | 4210320 | 10301 | 14493.2791910125
LOUISIANA | 3983159 | 20981 | 13603.039888813
MAINE | 1294381 | 3012 | 3065.774026762
MARYLAND | 5439792 | 20600 | 19311.5547548365
MASSACHUSETTS | 6366891 | 20325 | 22944.836730307
MICHIGAN | 10018999 | 26318 | 37257.373114093
MINNESOTA | 5065797 | 13514 | 17845.876016734
MISSISSIPPI | 2375636 | 8651 | 7303.1902060345
MISSOURI | 5835175 | 19951 | 20861.052626485
MONTANA | 957619 | 2741 | 1746.010652383 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | r | 0.9845648990073556
NEBRASKA | 1700074 | 4621 | 4655.6765770555 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | r^2 | 0.9693680404
NEVADA | 2565382 | 9537 | 8046.8008902415 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | slope | 0.003918979456124113
NEW HAMPSHIRE | 1167387 | 3256 | 2568.087144139 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | y int | -2006.878577427498
NEW JERSEY | 8405701 | 41672 | 30934.891324702
NEW MEXICO | 1850280 | 5644 | 5244.3308118325 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | b
NEW YORK | 18883746 | 86952 | 71998.1348797795
NORTH CAROLINA | 9036361 | 30631 | 33406.434936172
NORTH DAKOTA | 638897 | 1664 | 496.9456681839999
OHIO | 10072335 | 30950 | 37466.395804705
OKLAHOMA | 3617316 | 11266 | 12169.3086715945
OREGON | 3712636 | 10022 | 12542.8657975345
PENNSYLVANIA | 9052251 | 29582 | 33468.707520427
RHODE ISLAND | 1057832 | 3240 | 2138.7433450165
SOUTH CAROLINA | 4406102 | 14999 | 15260.5448354815
SOUTH DAKOTA | 792578 | 2220 | 1099.2183567235
TENNESSEE | 6150558 | 24698 | 22097.0321381335
TEXAS | 23413736 | 84403 | 89751.0728249845
UTAH | 2644187 | 7827 | 8355.636069739001
[NAME] | 342945 | 1481 | -662.8841528
VIRGINIA | 7710724 | 23306 | 28211.2907087305
WASHINGTON | 6459529 | 14637 | 23307.883153228
WEST VIRGINIA | 1799090 | 4212 | 5043.7182512275
WISCONSIN | 5598633 | 18732 | 19934.049377596
WYOMING | 519988 | 2092 | 30.94373481850016
MEAN | 5605224.823529412 | 19959.88235294117
Spreadsheet: 800662d1665780465-find-last-value-based-on-a-criteria-of-another-cell-sampledatanew
Sheet: Blad 1

Day (YYYY-MM-DD) | Value |  | Month (YYYY-MM) | Last Value In Month | My desired output
2022-01-01 00:00:00 | 42 |  | 2022-01 |  | 78
2022-01-02 00:00:00 | 35 |  | 2022-02 |  | 76
2022-01-03 00:00:00 | 65 |  | 2022-03 |  | 92
2022-01-04 00:00:00 | 21 |  | 2022-04 |  | 28
2022-01-05 00:00:00 | 78 |  | 2022-05 |  | 43
2022-02-04 00:00:00 | 97
2022-02-08 00:00:00 | 43
2022-02-16 00:00:00 | 76
2022-03-15 00:00:00 | 92
2022-03-20 00:00:00 | 63
2022-03-22 00:00:00 | 92
2022-04-13 00:00:00 | 87
2022-04-15 00:00:00 | 59
2022-04-21 00:00:00 | 28
2022-05-10 00:00:00 | 37
2022-05-28 00:00:00 | 74
2022-05-29 00:00:00 | 43
Spreadsheet: 33fb5cd7-a8e9-4b0d-ad48-11fe1e6e8060
Sheet: Sheet1

HASIL UJIAN ULANG 1 s.d 12, [NAME] s.d 3 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
No | [NAME] | Nama | Instansi | [NAME] | Propinsi | Bidang Studi | Status PLPG
1 | 11036122710617 | [NAME] | SMP N 23 SURAKARTA | [NAME] | JAWA TENGAH | Keterampilan | LULUS
2 | 11036106310372 | FADHILAH KUSNIATI | SLB B YAAT SURAKARTA | [NAME] | JAWA TENGAH | [NAME] | LULUS
3 | 11036146411026 | SUKASNO | SMK N 9 SKA | [NAME] | JAWA TENGAH | Desain dan [NAME] | TIDAK LULUS
4 | 11036160810373 | ENDANG TRILESTARI | SLB B YAAT SURAKARTA | [NAME] | JAWA TENGAH | [NAME] | TIDAK LULUS
Spreadsheet: 220294d1363113811-populating-data-into-a-summary-tab-using-multiple-data-tabs-formulahelp1
Sheet: DEF

 |  |  |  | 202 | 204 | 52 | 20 | Total
 |  |  | BCB | 2333 | 77 | 66 | 43
 |  |  | MCM | 2 | 0 | 34 | 56
 |  |  | AET | 33 | 5 | 4456 | 0
 |  |  | UHC | 5 | 23 | 0 | 34
 |  |  | WCM | 23 | 3 | 445 | 0
 |  |  | COM | 3 | 44 | 1 | 0
 |  |  | CIG | 11 | 1 | 0 | 34
 |  |  | AFH | 2 | 0 | 0 | 44
 |  |  | UNA | 1 | 1 | 2 | 0
 |  |  | AIS | 3334 | 3333 | 667 | 2367
 |  |  | MMM | 32 | 4 | 3 | 2222
 |  |  | OFN | 1 | 45 | 7 | 777
 |  |  | SSB | 1 | 0 | 777 | 434
 |  |  | SPB | 7675 | 67 | 1 | 1
 |  |  | MHMO | 757 | 0 | 44 | 0
 |  |  | MPPO | 1 | 76 | 4 | 56
Spreadsheet: phillip_m_love__30154__9903_OA
Sheet: SE-LRC-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  LRC
REGION:  SOUTHEAST
 |  |  | Total |  | Reclasses |  |  |  |  |  | May |  |  |  |  |  | August |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  |  |  | 0
 |  | TOTAL
Spreadsheet: 60155d1260702077-annual-summary-with-categories-and-matching-example
Sheet: Output

Year | Country | Category | Cost
2008 | Y | Meat | 20
2009 | X | Meat | 15
 | X | Nuclear | 10
 | Y | Wheat | 10
 | Y | Gas | 5
Spreadsheet: 81450d1281622511-vlookup-value-in-a-cell-containing-multiple-entries-scenarios-document-layout
Sheet: Test Scenarios

Scenario | SR4+ ID | Comments | SR3 Review Update Comments | Action | Brand 1 | Brand 2 | Brand 3 | Platform | Test Responsibility | Product | Product Type | Test Phase | Products | System | Old ID | Requirement Traceability | Condition Traceability | Vlookup ID | Mapped Scripts | Secondary Scripts
Section 1 Description | Section_1 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |  | X
Section 1.1 Description | Section_1.1 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |  | X
Section 1.1.2 Descrption | Section_1.1.2 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |  | X
Detailed Scenario 1 | SCENARIO_0001 | Comments go here. |  | Y | Y | Y | N | Legacy | Team 1 | N/A | N/A | 1 | All - excluding Collections | System 1 |  |  |  |  | Want to map scripts to here.
Detailed Scenario 2 | SCENARIO_0002 | Comments go here. |  | Y | N | N | Y | Legacy | Team 2 | N/A | N/A | 2 | All - excluding Collections | System 2
Detailed Scenario 1 | SCENARIO_0003 | Comments go here. |  | Y | Y | Y | N | Legacy | Team 3 | N/A | N/A | 1 | All - excluding Collections | System 3
Detailed Scenario 2 | SCENARIO_0004 | Comments go here. |  | Y | N | N | Y | Legacy | Team 4 | N/A | N/A | 1 | All - excluding Collections | System 4
Detailed Scenario 1 | SCENARIO_0005 | Comments go here. |  | Y | Y | Y | N | Legacy | Team 1 | N/A | N/A | 1 | All - excluding Collections | System 5
Detailed Scenario 2 | SCENARIO_0006 | Comments go here. |  | Y | N | N | Y | Legacy | Team 2 | N/A | N/A | 2 | All - excluding Collections | System 6
Detailed Scenario 1 | SCENARIO_0007 | Comments go here. |  | Y | Y | Y | N | Legacy | Team 3 | N/A | N/A | 2 | All - excluding Collections | System 7
Detailed Scenario 2 | SCENARIO_0008 | Comments go here. |  | Y | N | N | Y | Legacy | Team 4 | N/A | N/A | 2 | All - excluding Collections | System 8
Spreadsheet: 862743d1710395433-need-help-totaling-based-on-selections-mix-id-calculator-bdh-dj-addtier
Sheet: Price tab

This section is where I manipulate the lists and price.  Can be done on another tab.
Mix ID | Price |  | Add On | Price |  | Distance | Price |  | Tier | Price
COM301510 | 0 |  | Air | 3 |  | 1-10 | 0 |  | T1 | 121
COM351510 | 5 |  | HRWR | 5 |  | 11-20 | 5 |  | T2 | 126
COM401510 | 10 |  | 3/8 Agg | 7 |  | 21-30 | 10 |  | T3 | 131
COM451510 | 15 |  | [NAME] | 13 |  | 31-40 | 20
COM501510 | 20 |  | 1%Retard | 0
COM601510 | 30 |  | 2%Retard | 1
COM701510 | 40 |  | 3%Retard | 2
COM801510 | 50 |  | Fiber | 7
500S | 7 |  | SRA | 75
550S | 12 |  | SS | 7
600S | 17
650S | 22
700S | 27
800S | 32
Spreadsheet: 326888d1403288262-transfer-data-between-multiple-spreadsheets-dummy
Sheet: February

Date | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Productivity | 55 | 65 | 18 | 95 | 75 | 65 | 38 | 19 | 67 | 34
Spreadsheet: 716352d1612183708-rent-spreadsheet-formulas-functions-assistance-please-rent-spread-sheet-help-1-again
Sheet: Payments

Property | Date | Amount
1 | 2020-02-02 00:00:00 | 100
2 | 2020-01-02 00:00:00 | 200
3 | 2020-01-03 00:00:00 | 300
4 | 2020-01-04 00:00:00 | 400
3 | 2020-01-08 00:00:00 | 300
2 | 2020-01-09 00:00:00 | 200
1 | 2020-01-10 00:00:00 | 100
4 | 2020-01-11 00:00:00 | 400
3 | 2020-01-15 00:00:00 | 300
2 | 2020-01-16 00:00:00 | 200
4 | 2020-01-17 00:00:00 | 250
1 | 2020-01-18 00:00:00 | 100
Spreadsheet: 671e085b-3d07-496a-bad5-eb0c1440fce5
Sheet: Sheet1

Previous Semesters |  | Current Semester |  | Semester 1 |  | Semester 2 |  | Semester 3 |  | Semester 4
 |  | (if currently enrolled)
 |  | Enter the number of credits the student is taking and how many you anticipate they will pass |  | Units Planned |  | Units Planned |  | Units Planned |  | Units Planned
Earned Units |  | Earned Units |  | Earned Units |  | Earned Units |  | Earned Units |  | Earned Units
Attempted Units |  | Attempted Units |  | Attempted Units |  | Attempted Units |  | Attempted Units |  | Attempted Units
 |  | Completion Rate |  | Completion Rate |  | Completion Rate |  | Completion Rate |  | Completion Rate
 |  |  |  | If % is greater than or equal to 67%, stop here.  If it's below 67%, continue on to [NAME]. |  | If % is greater than or equal to 67%, stop here.  If it's below 67%, continue on to Semester 3. |  | If % is greater than or equal to 67%, stop here.  If it's below 67%, continue on to [NAME].
Spreadsheet: 703736d1605144896-conditional-formatting-to-highlight-a-cell-red-when-checkbox-is-unchecked-spreadsheet-111120
Sheet: Sheet1

Priority 1 Equipment | Issue | Action Taken | Service State | In Service at Reduced Capacity
hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh |  |  | False | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False |  | If [NAME]:
 |  |  | False |  | * E2: red
 |  |  | False |  | * Column D: red (unchecked), green (checked)
 |  |  | False |  | If [NAME]:
 |  |  | False |  | * E2: yellow
 |  |  | False |  | * Column D: no colour ( regardless checked or unchecked)
 |  |  | False |  | If yes,
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
Spreadsheet: 600532d1543830499-error-with-nesting-if-formulae-races
Sheet: Sheet1

 | Horse Racing / Donl (AUS) 18th Nov : R5 1350m [NAME]
 | Horse Racing / Morp (AUS) 17th Nov : R7 1950m [NAME]
 | Horse Racing / Doom (AUS) 17th Nov : R8 1200m Listed
 | Horse Racing / Morp (AUS) 17th Nov : R6 1250m [NAME]
 | Horse Racing / Rose (AUS) 17th Nov : R4 1900m [NAME]
 | Horse Racing / Sand (AUS) 17th Nov : R4 1800m Grp3
 | Horse Racing / Rose (AUS) 17th Nov : R3 1100m CL2
 | Horse Racing / Morp (AUS) 17th Nov : R2 1400m 3yo
 | Horse Racing / Sand (AUS) 17th Nov : R3 1400m Listed
 | Horse Racing / Doom (AUS) 17th Nov : R2 1050m 2yo
 | Horse Racing / Rose (AUS) 17th Nov : R2 2400m [NAME]
 | Horse Racing / Morp (AUS) 17th Nov : R1 1000m 3yo
 | Horse Racing / Sand (AUS) 17th Nov : R2 3200m Listed
 | Horse Racing / Rose (AUS) 17th Nov : R1 1100m 3yo
 | Horse Racing / Sand (AUS) 17th Nov : R1 1000m Listed
 | Horse Racing / Asct (AUS) 24th Nov : R6 1200m Listed
 | Horse Racing / Doom (AUS) 24th Nov : R9 1200m CL6
 | Horse Racing / Ball (AUS) 24th Nov : R10 1200m [NAME]
 | Horse Racing / Doom (AUS) 24th Nov : R8 1350m [NAME]
 | Horse Racing / Rose (AUS) 24th Nov : R9 1500m [NAME]
 | Horse Racing / Morp (AUS) 24th Nov : R7 1400m [NAME]
 | Horse Racing / GCst (AUS) 24th Nov : R8 1200m CL4
 | Horse Racing / Asct (AUS) 24th Nov : R4 1200m Listed
 | Horse Racing / Gosf (AUS) 24th Nov : R8 1200m [NAME]
 | Horse Racing / Ball (AUS) 24th Nov : R9 1100m [NAME]
 | Horse Racing / Doom (AUS) 24th Nov : R7 1200m Listed
 | Horse Racing / Rose (AUS) 24th Nov : R8 1500m [NAME]
 | Horse Racing / Ball (AUS) 24th Nov : R8 2200m [NAME]
 | Horse Racing / Doom (AUS) 24th Nov : R6 1350m [NAME]
 | Horse Racing / Rose (AUS) 24th Nov : R7 2000m [NAME]
 | Horse Racing / Morp (AUS) 24th Nov : R5 1250m [NAME]
Spreadsheet: 2d492183-e9ab-42ed-9a0e-6762aff26d50
Sheet: BS

 | ADVANCED MICRO DEVICES, INC.
 | CONSOLIDATED BALANCE SHEETS
 | (Millions)
 |  |  |  |  | Apr. 2, |  | Dec. 25,
 |  |  |  |  | 2011 |  | 2010
 | Assets
 | Current assets:
 |  | Cash, cash equivalents and marketable securities |  |  | 1745 |  | 1789
 |  | Accounts receivable, net |  |  | 797 |  | 968
 |  | Inventories, net |  |  | 648 |  | 632
 |  | Prepaid expenses and other current assets |  |  | 221 |  | 205
 |  |  |  | Total current assets | 3411 |  | 3594
 | Property, plant and equipment, net |  |  |  | 676 |  | 700
 | Investment in GLOBALFOUNDRIES |  |  |  | 486 |  | 0
 | Acquisition related intangible assets, net |  |  |  | 28 |  | 37
 | Goodwill |  |  |  | 323 |  | 323
 | Other assets |  |  |  | 285 |  | 310
 | Total Assets |  |  |  | 5209 |  | 4964
 | Liabilities and Stockholders' Equity
 | Current liabilities:
 |  | Accounts payable |  |  | 411 |  | 376
 |  | Accounts payable to GLOBALFOUNDRIES |  |  | 127 |  | 205
 |  | Accrued liabilities |  |  | 605 |  | 698
 |  | Deferred income on shipments to distributors |  |  | 165 |  | 143
 |  | Other short-term obligations |  |  | 34 |  | 229
 |  | Current portion of long-term debt and capital lease obligations |  |  | 4 |  | 4
 |  | Other current liabilities |  |  | 29 |  | 19
 |  |  |  | Total current liabilities | 1375 |  | 1674
 | Long-term debt and capital lease obligations, less current portion |  |  |  | 2192 |  | 2188
 | Other long-term liabilities |  |  |  | 84 |  | 82
 | Accumulated loss in excess of investment in GLOBALFOUNDRIES |  |  |  | 0 |  | 7
 | Stockholders' equity:
 |  | Capital stock:
 |  |  | Common stock, par value |  | 7 |  | 7
 |  |  | Additional paid-in capital |  | 6611 |  | 6575
 |  |  | Treasury stock, at cost |  | -104 |  | -102
 |  | Accumulated deficit |  |  | -4958 |  | -5468
 |  | Accumulated other comprehensive income |  |  | 2 |  | 1
 |  |  |  | Total stockholders' equity | 1558 |  | 1013
 | Total Liabilities and Stockholders' Equity |  |  |  | 5209 |  | 4964
Spreadsheet: 149217d1333747861-intersection-of-two-sets-of-values-studiosa_intersection-of-two-sets-example_06apr12_01
Sheet: Sheet1

 | Input data | Input data | Desired output
 | Set 1 | Set 2 | Intersection of Set 1 and Set 2 | Intersection of Set 1 and Set 2
 | apple | orange | apple
 | orange | grape | orange
 | apple | grape | grape
 | grape | mango
 | pear | apple
 | pear | banana
 | kiwi | orange
 |  | grape