tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 108050d1305149862-auto-populating-excel-calendar-ts1019273743
Sheet: FEB

 | February 2011
 | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  |  |  |  | 1 |  | 2 | Groundhog Day | 3 |  | 4 |  | 5
 | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12
 | 13 |  | 14 | [NAME]'s Day | 15 |  | 16 |  | 17 |  | 18 |  | 19
 | 20 |  | 21 | Presidents' Day | 22 |  | 23 |  | 24 |  | 25 |  | 26
 | 27 |  | 28
Spreadsheet: 836462d1689372410-proforma-calculation-based-of-month-and-years-book1-shruder-3-
Sheet: Sheet2

Blank Column | Blank Column | Blank Column | Blank Column | Blank Column | Blank Column | Blank Column | 2023 Amt | Blank Column | Blank Column | Expire Date | Blank Column | Start | End |  | 2024 Amt | Start | End | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00
 |  |  |  |  |  |  | 100000 |  |  | 2025-05-12 00:00:00 | 365 | 2022-05-12 00:00:00 | 2023-05-12 00:00:00 |  | 200000 | 2023-05-13 00:00:00 | 2024-05-12 00:00:00
 |  |  |  |  |  |  | 150000 |  |  | 2026-12-31 00:00:00 | 365 | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  | 175000 | 2024-01-01 00:00:00 | 2024-12-30 00:00:00
Spreadsheet: 877119d1723797835-need-a-formula-to-get-count-rajsoft-second-test-365-aligw
Sheet: Sheet1

 |  | Code details |  |  | # in Project | # in Bench
Names | Codes | CC01 | Project |  |  | 2
EMP 1 | CC01 | CC02 | Project |  | Need to put a count formula in the above cell to check how many are in Project & Bench
EMP 2 | CC02 | [NAME] | Bench
EMP 3 | [NAME]
EMP 4 | CC01
EMP 5 | CC01
EMP 6 | CC02
EMP 7 | [NAME]
Spreadsheet: 87286d1287114518-matching-certain-digits-in-one-column-to-the-another-sample_problem
Sheet: SAMPLE PROBLEM

COLUMN A | COLUMN B | COLUMN C | COLUMN D | COLUMN E | COLUMN F
100000 | A | 10100 | AA | 101001 | AAA
200000 | B | 10101 | BB | 101002 | BBB
300000 | C | 20200 | CC | 101003 | CCC
400000 | D | 20201 | DD | 101004 | DDD
500000 | E | 20202 | EE | 101005 | EEE
 |  | 20203 | FF | 202002 | FFF
 |  | 20204 | GG | 202003 | GGG
 |  | 30200 | HH | 202004 | HHH
 |  | 30201 | II | 202005 | III
 |  | 40300 | JJ | 202006 | JJJ
 |  | 40301 | KK | 302007 | KKK
 |  | 40302 | LL | 302008 | LLL
 |  | 40303 | MM | 403020 | MMM
 |  | 40304 | NN | 403021 | NNN
 |  | 40305 | OO | 403022 | OOO
 |  | 40306 | PP | 504001 | PPP
 |  | 50400 | QQ | 504002 | QQQ
 |  | 50401 | RR | 504003 | RRR
 |  | 50402 | SS | 504004 | SSS
 |  | 50403 | TT | 505001 | TTT
 |  | 50404 | UU | 505002 | UUU
 |  | 50405 | VV | 505003 | VVV
Note: Column A are geocoded information of column B (same goes with C and D; and E and F).
First digits of the geocodes correspond to a certain category (e.g. name of countries); the second and third digits correspond to another category (e.g., name of cities in the countries).
In column E, the fourth, fifth and sixth digits correspond to another category (e.g. name of buildings in particular cities)
Spreadsheet: 871407d1717784779-formula-to-sum-dynamic-ranges-example-book-sums
Sheet: Sheet1 (2)

1 | Item | 57
 | Item | 41
 | Item | 18
 | Shipping | 7
2 | Item | 400
 | Shipping | 6
3 | Item | 40
 | Item | 35
 | Shipping | 8
4 | Item | 64
 | Item | 110
 | Item | 83
 | Item | 25
 | Item | 300
 | Item | 50
 | Shipping | 17
5 | Item | 73
 | Item | 37
 | Shipping | 8
6 | Item | 400
 | Shipping | 6
7 | Item | 48
 | Item | 52
 | Item | 27
 | Item | 45
 | Item | 10
 | Item | 15
 | Item | 13
 | Shipping | 14
8 | Item | 45
 | Item | 69
 | Item | 59
 | Item | 49
 | Shipping | 8
9 | Item | 26
 | Item | 39
 | Shipping | 8
10 | Item | 38
 | Item | 41
 | Item | 42
 | Shipping | 8
Spreadsheet: 171751d1343845882-finding-location-of-largest-value-in-a-list-using-match-find_largest_in_list_using_match
Sheet: Summary_LNR

%age Met
0.9925925925925926
1
0.9880952380952381
0.9864864864864865 |  |  | Why does the above formula not return 26
0.983739837398374
0.9711538461538461
0.975609756097561
1
1
0.9882352941176471
1
0.9910714285714286
1
1
1
1
1
1
1
0.9166666666666666
0.9230769230769231
0.94
1
1
42
1
1
Spreadsheet: barry_tycholiz__847__2002 Plan Worksheet CC107321
Sheet: Headcount Assumptions

NATURAL GAS - WEST ORIGINATION
2002 PLAN HEADCOUNT ASSUMPTIONS
EMPLOYEE |  | TITLE
[NAME] |  | VP
 | 1 | VP Count
[NAME] |  | Director
Open Position |  | Director
 | 2 | Director Count
[NAME] |  | Manager
Kimberly Ward |  | Manager
Open Position |  | Manager
 | 3 | Manager Count
[NAME] |  | Associate
Open Position |  | Associate
 | 2 | Associate Count
[NAME] |  | Analyst
 | 1 | Analyst Count
[NAME] |  | [NAME]
 | 1 | [NAME]
 |  | Grand Total
Spreadsheet: 681662d1591692141-using-excel-to-count-items-separated-by-commas-in-the-same-cell-book
Sheet: Sheet1

City | Items | Quantities
London | Pear,Banana,Orange | 2,4,3
[NAME] | Apple | 4
Salford | Banana,Orange | 4,6
Salford | Strawberry,Orange,Pear | 6,3,4
London | Ice,Melon,Pear | 5,3,2
[NAME] | Pear | 4
Birmingham | Melon,Orange | 4,5
Edinburgh | Grapes,Apple,Orange,Pear,[NAME],Melon | 4,4,5,7,2,3
Chester | Apple,Pear | 2,3
Blackpool | Orange,Banana | 5,6
[NAME] | Banana,Pear,Pineapple | 7,3,4
Spreadsheet: aee9741d-97a3-404a-a3ba-0598acec5021
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
HGU | Test | HGU | Mercury, 24 Hour, [NAME] | Mercury, 24 Hr, U | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | Plastic urine container with no metal cap or glued insert |  |  | 10 | mL | Collection Container/Tube: Clean, plastic urine container with no metal cap or glued insert Submission Container/Tube: Plastic, 10-mL urine tube (Supply T068) or a clean, plastic aliquot container with no metal cap or glued insert [NAME]: 10 mL Collection Instructions: 1. Collect urine for 24 hours. 2. No preservative. 3. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. 4. Refrigerate specimen within 4 hours of completion of 24-hour collection. Additional Information: 1. 24-Hour volume is required. 2. See [NAME] in Special Instructions for multiple collections. 3. High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours.   Urine Preservative Collection Options Ambient	No Refrigerated	Preferred Frozen	Yes 6N HCl	Yes 50% Acetic Acid	Yes Na2CO3	No Toluene	Yes 6N HNO3	Yes Boric Acid	No Thymol	No | 2 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | 0-15 years: not established > or =16 years: 0-9 mcg/specimen Toxic concentration: >50 mcg/specimen The concentration at which toxicity is expressed is widely variable between patients. 50 mcg/specimen is the lowest concentration at which toxicity is usually apparent. | Monday through Friday; 3 p.m. - 9 p.m.; Saturday; 8 a.m. - 3 p.m./Continuously | 1 day | 2 days | 1 | 83825 |  |  |  |  | Rochester
HGU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
HGU | Order Question | TM5 | Collection Duration |  | Plain Text
HGU | Order Question | VL3 | [NAME] |  | Plain Text
HGU | Result | 8592 | Mercury, 24 Hr, U | Mercury, 24 Hr, U | Numeric |  |  |  |  | mcg/spec |  |  |  |  |  |  |  |  |  | 6693-6 | Mercury:MRat:24H:[NAME]:Qn:
HGU | Result | TM5 | Collection Duration | Collection Duration | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13362-9 | Collection duration:Time:*:Urine:Qn:
HGU | Result | VL3 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28009-9 | [NAME] volume:Vol:Pt:[NAME]:Qn:
HGU | Result | 856 | Hg Concentration | Hg Concentration | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 21383-5 | Mercury:MCnc:24H:[NAME]:Qn:
Spreadsheet: 87128d1287014479-create-sheets-data-from-master-sheet-excel-question-example
Sheet: Doe, John

Adult | Date | Transaction Description | Payment Amount | Deposit Amount | Dues | Trips | Fundraising | Popcorn | [NAME].
Doe, [NAME] | 2008-05-21 00:00:00 | opening balance |  | 0
Doe, [NAME] | 2008-05-21 00:00:00 | Mulch job 5/3/08 |  | 14.06 |  |  | 14.06
Doe, [NAME] | 2009-12-15 00:00:00 | Bushwack Patch | -7.5 |  |  |  |  |  | -7.5
Doe, [NAME] | 2010-04-08 00:00:00 | Mulch 2010 |  | 27.69 |  |  | 27.69
Doe, [NAME] | 2010-04-28 00:00:00 | Mulch 2010 |  | 20.54 |  |  | 20.54
Doe, [NAME] | 2010-05-17 00:00:00 | Mulch 2010 |  | 41.25 |  |  | 41.25
Doe, [NAME] | 2010-05-31 00:00:00 | Canoe/Kayak 2010 | -25 |  |  | -25
Doe, [NAME] | 2010-06-08 00:00:00 | Mulch 2010 |  | 11.25 |  |  | 11.25
balance |  |  | 82.28999999999999
or alternatively, this one
balance |  |  | 82.28999999999999
Spreadsheet: 118392d1313658202-copy-conditional-formatting-formula-to-other-cells-without-changing-vlookup-reference-marks
Sheet: Sheet1

 |  | Pupil | :) | : | :( | 2011-09-01 00:00:00 | 2011-09-02 00:00:00 | 2011-09-03 00:00:00 | 2011-09-04 00:00:00 | 2011-09-05 00:00:00 | 2011-09-06 00:00:00
1c | 1.1 | [NAME] |  |  |  | 1c | 1b | 1c | 2a | 3b | 3c
1b | 1.2 | [NAME] |  |  |  | 1c | 1a | 2a | 3c | 2a
1a | 1.3 | [NAME] |  |  |  | 1c | 2c | 1a | 1b | 2a | 3c
2c | 2.1 | [NAME] |  |  |  | 1c | 1c
2b | 2.2 |  |  |  |  | 1b | 1b
2a | 2.3 |  |  |  |  | 1a | 2a
3c | 3.1 |  |  |  |  | 2c | 3b
3b | 3.2 |  |  |  |  | 2b
3a | 3.3 |  |  |  |  | 2a
4c | 4.1 |  |  |  |  | 1c
4b | 4.2 |  |  |  |  | 1b
4a | 4.3 |  |  |  |  | 1a
5c | 5.1 |  |  |  |  | 2c
5b | 5.2 |  |  |  |  | 2b
5a | 5.3 |  |  |  |  | 2a
6c | 6.1
6b | 6.2
6a | 6.3
7c | 7.1
7b | 7.2
7a | 7.3
Spreadsheet: 756363d1637478323-create-items-combination-generator-with-formula-in-excel-item-combinations
Sheet: ITEM Combination

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Combinations
Step 1: Enter the list of items in each columns
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Step 2: Enter Delimiter between values
ITEMS |  | ITEMS |  | ITEMS |  | ITEMS |  | ITEMS |  | ITEMS |  | ITEMS |  | ITEMS |  | ITEMS |  | ITEMS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Delimiter |  | Serial No. | Combinations
List 1 |  | List 2 |  | List 3 |  | List 4 |  | List 5 |  | List 6 |  | List 7 |  | List 8 |  | List 9 |  | List 10 |  | - |  |  | A1 - B1 - C1 - D1 - E1 - F1
A1 |  | B1 |  | C1 |  | D1 |  | E1 |  | F1 |  |  |  |  |  |  |  |  |  |  |  |  | A1 - B1 - C1 - D1 - E1 - F2
A2 |  | B2 |  | C2 |  | D2 |  | E2 |  | F2
A3 |  | B3 |  |  |  | D3
A4
[NAME] 15 Items |  | [NAME] 15 Items |  | [NAME] 15 Items |  | [NAME] 15 Items |  | [NAME] 15 Items |  | [NAME] 15 Items |  | [NAME] 15 Items |  | [NAME] 15 Items |  | [NAME] 15 Items |  | [NAME] 15 Items
Spreadsheet: 685432d1594005032-if-function-keeps-giving-me-value-error-markbook-practice-ii
Sheet: Sheet1

 |  |  | Learning Outcomes Summary |  |  |  | Self Expression |  |  |  |  |  |  |  |  |  | Knowledge |  |  |  |  |  |  |  |  |  | Public Debate |  |  |  |  |  |  |  |  |  | Practical Purposes
Name | Surname | Overall | Self Expression | Knowledge | Public Debate | Practical Purposes
[NAME] | ASPINALL |  |  |  |  |  | H | m | l |  |  |  |  |  |  |  | H | m | l | ns | n
[NAME] | BAJIC |  |  |  |  |  | M | n | l |  |  |  |  |  |  |  | M
[NAME] | BEFEKADU |  |  |  |  |  | L | h | m |  |  |  |  |  |  |  | L
[NAME] | CHU SINGH |  |  |  |  |  | N | m | h |  |  |  |  |  |  |  | N
[NAME] | CHU SINGH |  |  |  |  |  | NS | l | m |  |  |  |  |  |  |  | NS
Spreadsheet: 88f5c341-3586-4562-bf4d-0e6833fa56c3
Sheet: Sheet1

Project Name: | Enter Multi-particiant Project Name | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Date Analyzed: | Enter Date |  | Participant Agency or Group Name: |  |  | Enter the Name of the Agency or Group Covered by this [NAME]
Net Present Value (Net Benefits): | 0
Annualized Return on Investment:
[NAME]: | This Year
Payback Period (in Years): | 0
Inflation Rate: | 0.025
Opportunity Cost of Capital: | 0.05
Project Year Indicators: | 1 | 2 | 3 | 4 | 5
Project Year Labels: | This Year | Year 2 | Year 3 | Year 4 | Year 5
Project Life (Number of Years): | 5
Method for Determining Future Years' Cost of Labor:
Derived by Applying Inflation Rate to Current Costs
Notes and Other Assumptions:
Enter notes here.
Options for Future Year Labor Cost Determination: |  |  | Effective Wage Multiplier: |  | 1.025
Independent of Assumed Inflation Rate (See Notes)
Derived by Applying Inflation Rate to Current Costs
Derived by Applying Average Annual Cost of Living Adjustment to Current Costs:
File Directory and Name:
C:\Documents and Settings\nlerner\My Documents\Active Projects\GITA ROI Book\Templates\Multiparticipant Templates\[Financial Details-Future5.xls]Project Setup Sheet
Spreadsheet: 161332d1339500528-showing-pictures-when-certain-conditions-are-met-images-2
Sheet: Sheet1

1 | Ω |  | 5
2 | [NAME] |  | 2
3 | ↑ |  | 4
4 | → |  | 5
5 | ↓ |  | 4
 |  |  | 1
Spreadsheet: ee723537-e3a2-4912-9d7b-db96ace58f26
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-07-24 09:27:58.660000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.932 | 101.807 | 101.682 | 101.307
3.75 | 101.718 | 101.593 | 101.468 | 101.093 |  | Note: | Refer To Price [NAME]
3.625 | 101.321 | 101.196 | 101.071 | 100.696 |  |  | For all Price Adjs
3.5 | 100.758 | 100.633 | 100.508 | 99.883
3.375 | 99.91 | 99.785 | 99.66 | 99.035
3.25 | 98.986 | 98.861 | 98.736 | 98.111
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 102.125 | 102 | 101.875 | 101.5
3.25 | 101.729 | 101.604 | 101.479 | 101.104
3.125 | 101.435 | 101.31 | 101.185 | 100.81
3 | 101.085 | 100.96 | 100.835 | 100.46
2.875 | 100.494 | 100.369 | 100.244 | 99.619
2.75 | 99.836 | 99.711 | 99.586 | 98.961
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-08-07 09:27:58.660000
30 DAY | 2012-08-22 09:27:58.660000
45 DAY | 2012-09-06 09:27:58.660000
60 DAY | 2012-09-21 09:27:58.660000
90 DAY | 2012-10-21 09:27:58.660000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: b876e504-718b-4b1b-9d5e-76f385871e44
Sheet: TTM Recon Q3FY13

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations
(in millions, except per share data)
 | Trailing Twelve Months Ended December 31, 2012
 | GAAP Results |  | Acquisition-related expenses |  | Amortization of debt discount |  | Certain non-recurring litigation expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) | Gain on strategic investments | Restructuring and other |  | Stock-based compensation |  | Income tax adjustments |  | Non-GAAP Results
Net revenue | 3956 |  | 0 |  | 0 |  | 0 |  | -226 | 0 | 0 |  | 0 |  | 0 |  | 3730
Cost of revenue | 1453 |  | -79 |  | - |  | - |  | 0 | 0 | 0 |  | -2 |  | 0 |  | 1372
Gross profit | 2503 |  | 79 |  | - |  | - |  | -226 | 0 | 0 |  | 2 |  | 0 |  | 2358
Operating expenses:
Marketing and sales | 793 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 |  | -30 |  | 0 |  | 763
General and administrative | 368 |  | 0 |  | 0 |  | -27 |  | 0 | 0 | 0 |  | -32 |  | 0 |  | 309
Research and development | 1174 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 |  | -99 |  | 0 |  | 1075
Acquisition-related contingent consideration | -62 |  | 62 |  | 0 |  | 0 |  | 0 | 0 | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 27 |  | -27 |  | 0 |  | 0 |  | 0 | 0 | 0 |  | 0 |  | 0 |  | 0
Restructuring and other | 26 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | -26 |  | 0 |  | 0 |  | 0
Total operating expenses | 2326 |  | 35 |  | 0 |  | -27 |  | 0 | 0 | -26 |  | -161 |  | 0 |  | 2147
Operating income | 177 |  | 44 |  | 0 |  | 27 |  | -226 | 0 | 26 |  | 163 |  | 0 |  | 211
Gain on strategic investments | 14 |  | 0 |  | 0 |  | 0 |  | 0 | -14 | 0 |  | 0 |  | 0 |  | 0
Interest and other income (expense), net | -21 |  | 0 |  | 20 |  | 0 |  | 0 | 0 | 0 |  | 0 |  | 0 |  | -1
Income before provision for (benefit from) income taxes | 170 |  | 44 |  | 20 |  | 27 |  | -226 | -14 | 26 |  | 163 |  | 0 |  | 210
Provision for (benefit from) income taxes | -5 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 |  | 0 |  | 64 |  | 59
Net income | 175 |  | 44 |  | 20 |  | 27 |  | -226 | -14 | 26 |  | 163 |  | -64 |  | 151
Spreadsheet: 485193d1476775295-sort-base-on-creteria-pivot
Sheet: Sheet1

Region | Category | Date
US | Sales | 2016-05-04 00:00:00
GE | Infra | 2016-08-01 00:00:00
NL | sales | 2016-01-01 00:00:00
MA | Tech | 2016-03-03 00:00:00
TR | Tech | 2016-01-01 00:00:00
US | Tech | 2016-08-15 00:00:00
US | Sales | 2016-07-01 00:00:00
MA | Tech | 2016-07-08 00:00:00
Spreadsheet: 775065d1648807119-if_isna_vlookup-how-to-search-target-data-with-multiple-data-example-if-isna-v-lookup
Sheet: Stock Update

Item | Item Description | Qty | SN# | SO Number
DS II M | DS II M Operating Table | 1 | 13453
DS II M | DS II M Operating Table | 1 | 12785 |  | ?
DS II M | DS II M Operating Table | 1 | 19877 |  | ?
DS II M | DS II M Operating Table | 1 | 17899 |  | ?
DS II M | DS II M Operating Table | 1 | 12778 |  | ?
DS II M | DS II M Operating Table | 1 | 65782 |  | ?
DS II M | DS II M Operating Table | 1 | 68927 |  | ?
DS II M | DS II M Operating Table | 1 | 23475 |  | ?
DS II M | DS II M Operating Table | 1 | 25172 |  | ?
DS II M | DS II M Operating Table | 1 | 12151 |  | ?
DS II M | DS II M Operating Table | 1 | 66367 |  | ?
DS II M | DS II M Operating Table | 1 | 24142 |  | ?
DS II M | DS II M Operating Table | 1 | 12516 |  | ?
DS II M | DS II M Operating Table | 1 | 12517 |  | ?
Spreadsheet: 716266d1612135192-extract-values-into-column-b-of-sheet-named-okay-schedule_sample_extractvalues
Sheet: Here

Name | Area
[NAME], [NAME] | YMCA
Abdelrahman, Habiger | YMCA
Abdelnour, [NAME] | YMCA
Bock, [NAME] | YMCA
Sablan, Yankee | [NAME] Assistant
Abee, Yanagi | YMCA
Super, Kicking | YMCA
Deer, Chiocemax | YMCA
[NAME], Van | YMCA
Hachey, [NAME] | YMCA
Head, Chroster | YMCA
Careema, [NAME] | YMCA
Luther, English | YMCA
Macchio, Hach | YMCA
Otoma, Look | YMCA
Stormy, English | YMCA
Sabio, Faggart | YMCA
Farts, Notso | YMCA
AllGood, Mercy | YMCA
Mercy, Likenother | YMCA
Speaking, Overflow | YMCA
Moo, Kata | YMCA
Bronony, [NAME] | YMCA
Crosser, [NAME] | YMCA
Stone, Stoneage | YMCA
Room, Imptru | YMCA
Macchi, Hable | YMCA
Abell, Fago | Painter
Kinda, Good | Painter
Sable, Yankey | Painter
Spreadsheet: 123759d1317841619-subtotaling-example-for-subtotaling
Sheet: Sheet1

Claim# | Coverage | TotalLossPaid
[PHONE] | Liability-CSL | 60000
[PHONE] | Liability-BI | 45000
[PHONE] | Liability-PD | 0
[PHONE] | Liability-PD | 3816.23
[PHONE] | Liability-BI | 100000
[PHONE] | Liability-PD | 0
[PHONE] | Personal Injury Protect | 10000
[PHONE] | Liability-BI | 106000
[PHONE] | Liability-BI | 30000
[PHONE] | Liability-CSL | 0
[PHONE] | Liability-PD | 4690.26
[PHONE] | Liability-PD | 5968.92
[PHONE] | Liability-CSL | 0
[PHONE] | Liability-CSL | 74000
[PHONE] | Liability-CSL | 0
[PHONE] | Liability-CSL | 869438.65
Spreadsheet: 583822d1532678449-index-formula-output-error-index-formula-sample-workbook
Sheet: Sheet1

 | Name | Value |  |  |  |  |  |  | Expected Results
 | A | 10 |  |  |  | Name | Value |  | Name | Value
 | B | 20 |  |  |  |  |  |  | A | 10
 | C | 30 |  |  |  |  |  |  | B | 20
 | D | 40 |  |  |  |  |  |  | C | 30
 | E | 50 |  |  |  |  |  |  | D | 40
 | F | 60 |  |  |  |  |  |  | E | 50
 | G | 70 |  |  |  |  |  |  | F | 60
 | H | 80 |  |  |  |  |  |  | G | 70
 | I | 90 |  |  |  |  |  |  | H | 80
 | J | 100 |  |  |  |  |  |  | I | 90
 | K | 0 |  |  |  |  |  |  | J | 100
 | L | 0 |  |  |  |  |  |  | X | -10
 | M | 0
 | N | 0
 | O | 0
 | P | 0
 | Q | 0
 | R | 0
 | S | 0
 | T | 0
 | U | 0
 | V | 0
 | W | 0
 | X
Spreadsheet: darrell_schoolcraft__7816__imbalsumm0109
Sheet: PEPL

 | Hansford
 | 8042
Day | Measured | Scheduled
1 | -33502 | -30000
2 | -33521 | -30000
3 | -33529 | -30000
4 | -33511 | -30000
5 | -11993 | -15000
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-08-31 00:00:00 |  |  | 57144
2001-09-05 00:00:00
CBS Dollars
 |  |  | 288089
Spreadsheet: 123755d1317837646-using-a-command-button-to-switch-tabs-in-excel-2007-rosterphnyc
Sheet: Porters

 | August | Mon |  | [NAME] |  | Wed |  | Thurs |  | Fri |  | Sat |  | Sun
 | 2011 | 31 |  | 4
 | PORTERS | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM
 | Name | 10
 | Name
 | Name
 | Name
 | Name
 | Name
 | Name
Spreadsheet: 41244d1239734999-sorting-fun
Sheet: Sheet2

S.No | Student No | Student Name | Total | RANK
 |  |  | 625
16 | 116 | [NAME] | 554 | 1
27 | 127 | Sadabindu | 515 | 2
24 | 124 | Sachish | 506 | 3
6 | 106 | [NAME] | 500 | 4
1 | 101 | Aadit | 497 | 5
25 | 125 | Sachit | 479 | 6
3 | 103 | Aahva | 478 | 7
5 | 105 | Aakarsh | 475 | 8
13 | 113 | [NAME] | 475 | 9
10 | 110 | [NAME] | 473 | 10