tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 47997d1247169996-how-to-pull-info-in-column-c-when-a-and-b-match-certain-criteria-sap-log-audit-template-07-09-09-fs
Sheet: 9W - RM

Name | Advocate | Beginning of Year Goals | Mid-Year Updates | End of Year Updates | TOTAL | Student Snapshots TOTAL
Spreadsheet: 547250d1510429201-nedd-help-learning-how-to-setup-a-running-total-on-a-worksheet-sdf
Sheet: Sheet1

Name | Donation |  |  | Названия строк | donation_
[NAME] | 1 |  |  | [NAME] | 23
[NAME] | 2 |  |  | glae | 27
mary | 3 |  |  | guy | 28
henry | 4 |  |  | henry | 25
suzi | 5 |  |  | huge | 31
glae | 6 |  |  | mary | 24
guy | 7 |  |  | susan | 28
huge | 10 |  |  | suzi | 26
susan | 7 |  |  | [NAME] | 22
[NAME] | 7 |  |  | Общий итог | 234
[NAME] | 7
mary | 7
henry | 7
suzi | 7
glae | 7
guy | 7
huge | 7
susan | 7
[NAME] | 7
[NAME] | 7
mary | 7
henry | 7
suzi | 7
glae | 7
guy | 7
huge | 7
susan | 7
[NAME] | 7
[NAME] | 7
mary | 7
henry | 7
suzi | 7
glae | 7
guy | 7
huge | 7
susan | 7
Spreadsheet: 40a96ec0-caa3-43a3-a317-8d9db9f94b8b
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42464029 | 2014-07-26 19:42:28 | ALLIES | 0 | 2 | 5 | 1604880 | 22lecruel | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
42471850 | 2014-07-27 09:08:58 | ALLIES | 1 | 5 | 4 | 1583109 | Gollum2 | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
42472026 | 2014-07-27 09:32:36 | AXIS | 1 | 5 | 3 | 1583109 | Gollum2 | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
Spreadsheet: 041d257f-f5a9-4ca5-b431-641572128420
Sheet: Restated

THOMSON REUTERS CORPORATION
Reconciliations from Reported to Restated Operating Results -- Non- IFRS Measures (unaudited)
(millions of U.S. dollars, except as otherwise indicated and except for per share data)
ONGOING BUSINESSES - RESTATED
EXCLUDES CORPORATE SERVICES AND OTHER PLANNED 2013 DISPOSALS; INCLUDES ADOPTION OF 2013 ACCOUNTING STANDARDS |  |  | 2010 |  | 2011 |  | 2012
 |  |  | Full Year |  | Full Year |  | Q1 | Q2 | Q3 | Q4 |  | Full Year
Revenues from ongoing businesses- Reported |  |  |  |  |  |  | 3187 | 3189 | 3165 | 3358
IFRS accounting adjustment- Joint Venture |  |  | -150 | 0 | -157 |  | -39 | -37 | -35 | -35 |  | -146
2013 Announced disposals |  |  | -307 |  | -319 |  | -76 | -78 | -78 | -78 |  | -310
Revenues from ongoing businesses- Restated
Adjusted EBITDA- Reported |  |  |  |  |  |  | 825 | 892 | 864 | 948
Adjusted EBITDA margin -Reported
Adjustments:
IFRS accounting adjustment- Joint Venture |  |  | -52 |  | -56 |  | -14 | -11 | -10 | -11 |  | -46
IFRS accounting adjustment- Pension |  |  | -13 |  | -31 |  | -12 | -12 | -12 | -12 |  | -48
2013 Announced disposals |  |  |  |  |  |  | -27 | -33 | -33 | -32
Adjusted EBITDA- Restated
Adjusted EBITDA margin -Restated
Underlying Operating Profit- Reported |  |  |  |  |  |  | 545 | 617 | 585 | 658
Underlying Operating Profit margin -Reported
Adjustments:
IFRS accounting adjustment- Joint Venture |  |  | -37 |  | -42 |  | -10 | -9 | -6 | -8 |  | -33
IFRS accounting adjustment- Pension |  |  | -13 |  | -31 |  | -12 | -12 | -12 | -12 |  | -48
2013 Announced disposals |  |  |  |  |  |  | -26 | -29 | -33 | -31
Underlying Operating Profit - Restated
Underlying Operating Profit margin - Restated
Adjusted earnings from continuing operations- Reported |  |  |  |  |  |  | 365 | 449 | 445 | 497
Adjusted earnings per share from continuing operations- Reported
Adjustments:
IFRS accounting adjustment- Joint Venture |  |  | -20 |  | -24 |  | -6 | -5 | -4 | -4 |  | -19
IFRS accounting adjustment- Pension |  |  | -42 |  | -61 |  | -20 | -20 | -21 | -20 |  | -81
2013 Announced disposals |  |  |  |  |  |  | -19 | -22 | -25 | -23
Adjusted earnings from continuing operations- Restated
Adjusted earnings per share from continuing operations- Restated
Diluted weighted average common shares  (in millions)
Spreadsheet: 25439d1216747838-creating-formulae-to-work-out-us-withholding-tax-taxes
Sheet: Retirement Savings

AIG | 55000
Federal Tax
Wage Bracket |  | Tax Rate | Tax Amount
Minimum | Maximum
0 | 7825 | 0.1 | 782.5
7825 | 31850 | 0.15 | 3603.75
31850 | 77100 | 0.25 | 5787.5
77100 | 160850 | 0.28
160850 | 349700 | 0.33
349700 | - - - - - | 0.35
 |  | 0.1849772727272727 | 10173.75
New York State
Wage Bracket |  | Tax Rate | Tax Amount
Minimum | Maximum
0 | 8000 | 0.04
8001 | 11000 | 0.045
11001 | 13000 | 0.0525
13001 | 20000 | 0.059
20001 | 100000 | 0.0685 | 3767.5
100001 | 500000 | 0.07375
500001 | - - - - - | 0.077
 |  | 0.0685 | 3767.5
FICA
AIG |  | Tax Rate | Tax Amount
55000 |  | 0.0145 | 797.5
Social Security
AIG |  | Tax Rate | Tax Amount
55000 |  | 0.062 | 3410
Totals |  | 0.3299772727272727 | 18148.75
Spreadsheet: 737918d1624664765-vlookup-matching-wrong-rows-vlookup-picking-wrong-matches
Sheet: Sheet1

 | Lookup Value |  | Return Value |  |  | Select Name in B3:
 | Name |  | Wages: |  |  | [NAME] and Yasmin are correct
 |  |  |  |  |  | Olive shows the Header
 |  |  |  |  |  | [NAME] and [NAME] show blanks
 |  |  |  |  |  | [NAME] shows Olive's wages
 | Name | Shift | Machine | Wages:
 | [NAME] | Early | 1 | 67
 | Olive | Late | 1 | 93
 | Yasmin | Night | 1 | 74
 | George | Early | 2 | 57
 | [NAME] | Late | 2 | 67
 | [NAME] | Night | 2 | 59
 | [NAME] | Early | 3 | 58
Spreadsheet: 122852d1317207305-choose-data-to-populate-main-worksheet-populate_worksheet-1-
Sheet: Dados AV1

A | D | B |  | L |  |  | MENTION COLUMN IN A:E
Código | Idade_1 | Sexo | Sexo_VAR | IMC_1 | Categoria
CT1 | 11 | 1 | 11.1 | 20.92 | EP
CT2 | 11 | 2 | 11 | 24.72 | EP |  |  |  | BP | N | EP | O
CT3 | 12 | 2 | 12 | 25.8 | EP |  |  | nº | 0 | 1 | 3 | 1 | 5
CT4 | 11 | 2 | 11 | 28.55 | O |  |  | % | 0 | 0.2 | 0.6 | 0.2 | 1
CT5 | 12 | 2 | 12 | 15.8 | N
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
Spreadsheet: sara_shackleton__36360__Merita3
Sheet: Sheet1

Paper/Pulp Deal Ticket
 |  |  |  |  |  |  |  | ERMS Deal Ticket Number:
Deal Date: |  | 1999-06-23 00:00:00 |  |  |  |  |  |  | (to be completed by [NAME])
ECT: |  | Buys | x | Sells | Counterparty Name: |  |  | Merita Bank
ECT Trader: | [NAME] |  |  |  | Counterparty Contact: |  |  | [NAME]
Commission $ |  | 1250 |  |  | [NAME]: |  |  | TFS
Credit Reserve $ |  |  |  |  | Counterparty Phone #: |  |  | 358-9165-59022 (phone)
 |  |  |  |  |  |  |  | 358-9726-1313 (fax)
Deal Type: | x | Financial |  | Physical | Credit Approved By:
Option Style: |  | European |  | Asian |  | American
Option Type: |  | Call |  | Put |  | Swaption
For Physical Deals:
Delivery Location |  |  |  |  | Pricing: |  |  |  |  | Price Index:
 |  |  |  |  |  | Physical Prem |  |  |  | (ex: OCC11 - Official Board Markets)
Commodity |  |  |  |  |  | Storage
 |  |  |  |  |  | Other
 |  |  |  |  |  | Total
Commodity |  | Swap/Forward |  |  |  |  |  | Futures
 |  | NBSK - Europe |  | [NAME] |  |  |  | NBSK - Europe OMLX (London)
 |  | NBSK - US |  | [NAME] |  |  | x | Other-List | NBSK Pulpex Dec. 99 Future
 |  | LWC34 (Light Weight Coated)
 |  | Newsprint
 |  | 26# [NAME]
 |  | 26# [NAME] -PPW
 |  | OCC (Old Corrguated Containers)
 |  | ONP-CN8 (Old Newsprint Chicago High #8)
 |  | ONP-SF8 (Old Newsprint SanFranciso High #8)
 |  | 42# linerboard [NAME]
 |  | 42#UBLB-EAST (Unbleached Kraftliner)
 |  | Other  - List
Settlment: |  |  |  |  |  |  |  |  |  | Fall Back Pricing:
Price Index (Swaps/Forwards)
 |  | RISI - Recovered Materials Monitor |  |  |  |  |  |  |  |  | Default
 |  | RISI - Paper Trader |  |  |  |  |  |  |  | x | None
 |  | RISI - World Pulp Monthly |  |  |  |  |  |  |  |  | Other - Identify
 |  | RISI - Paper Packaging Monitor
 |  | Pulp & Paper Week
 |  | Official Board Markets
 | x | Other - (Please Identify)________________________ |  |  | NBSK Pulpex futures
Payment/Settlement Date
 |  | Qtrly |  | Business Days After Price is Known
 |  | Monthly
 | x | Other | X | the payment date is 12/20/99.  See below for settlement method
Term & Price
 |  |  |  |  |  |  |  |  |  |  |  | x | ISDA Master
Tons/Month |  | Metric |  | Short Ton |  | 5000 | tons total |  |  |  |  |  | ECT Master
Fixed Price $/Ton | x | Metric |  | Short Ton |  | 507 | $ |  |  |  |  |  | Other (List) ________________
 |  | Delivery Start (month/year) |  |  |  | 1999-06-28 00:00:00 | Date
 |  | Delivery End (month/year) |  |  |  | 1999-12-15 00:00:00 | Date
Other:
This is a single payment swap.  The final settlement price will be the average of the last trade price of each trading day.  Should no trades occur on a trading day,
the prior day's price will be used.
Spreadsheet: 857586d1706562476-filter-function-based-on-a-date-nested-in-xlookup-job-schedule-dataset-xlookup-with-filter-question-etaf
Sheet: Sheet4

Job # | Bay # | Phase 60 | Phase 65 | Phase 70 | Phase 80 | Phase 90
8000 | 25 | 2023-01-31 00:00:00 | 2023-02-02 00:00:00 | 2023-02-12 00:00:00 | 2023-02-28 00:00:00 | 2023-03-14 00:00:00
7999 | 24
7998 | 5
7997 | 4
7996 | 3
8001 | 2
8002 | 2
8003 | 21
8004 | 22
8005 | 25 | 2024-04-01 00:00:00
Date | 2024-04-01 00:00:00
Lookup Values w/o date filter |  | Return Values
Bay # |  | Job #
Lookup Values w date filter |  | Return Values
Bay # |  | Job #
 |  |  | 7999
 |  |  | 7998
 |  |  | 7997
 |  |  | 7996
 |  |  | 8001
 |  |  | 8002
 |  |  | 8003
 |  |  | 8004
 |  |  | 8005
Spreadsheet: 67088d1267714674-excel-2007-summary-data-based-on-some-merged-cells-and-corresponding-pass-fail-status-summary-based-on-merged-data
Sheet: Data

Serial Number | Description | Steps | Overall Staus
Sno1 | Step1 | Pass
 | [NAME] | Fail
 | Step3 | Fail
 | Step4 | Pass
 | Step 5 | Pass
Sno2 | Step1 | Pass
 | [NAME] | Pass
 | Step3 | Pass
 | Step4 | Pass
 | Step5 | Pass
 | Step6 | Fail
Sno3 | Step1 | Pass
 | [NAME] | Pass
 | Step3 | Pass
Sno4 | Step1 | Pass
 | [NAME] | Pass
 | Step3 | Pass
 | Step4 | Pass
 | Step5 | Pass
 | Step6 | Pass
 | [NAME] | Pass
 | Step8 | Pass
 | Step9 | Pass
Sno5 | Step1
 | [NAME]
 | Step3
Spreadsheet: 876262d1722950420-i-have-a-excel-sheet-of-finance-calculator-i-want-help-regarding-some-formula-new-calc1
Sheet: Sheet1

EASY EMI CALCULATOR
 |  | LAPTOP AMOUNT : | 30000 |  |  |  |  |  | EMI'S
 |  |  |  |  |  |  |  |  | FILE CHARGE
 |  | LOAN AMT : | 40000 |  |  |  |  |  | PROCESSING FEES
 |  | FILE CHARGE | 500 |  |  |  |  |  | LAPTOP BALANCE AMOUNT
 |  | PROCESSING | 1.8 | % |  | DOWN PAYMENT :
 |  | SCHEME | 12 | 4 |  |  |  |  |  |  |  |  | TOTAL | EXTRA
 |  |  |  |  |  |  |  |  | DOWNPAYMENT
 |  |  |  |  |  |  | AMOUNT |  | EMI's
 |  |  |  |  |  | MONTHLY EMI : |  | X |  | =
 |  | ELIGIBILITY
40000
Spreadsheet: 0f1f7833-0537-44d1-a158-126a5c6b18b8
Sheet: T59

الجدول 59: وفيات الرضع المسجلة، 2000-2012
Table 59: Registered infant deaths, 2000-2012
Country | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | البلد
Bahrain | 117 | 117 | 94 | 107 | 141 | 134 | 115 | 133 | 127 | 128 | ... | … | … | البحرين
Egypt | 55214 | 49149 | 37904 | 38859 | 40177 | 39146 | 35952 | 34612 | 32174 | 25760 | 31698 | 35997 | … | مصر
Iraq | … | … | 12447 | 9638 | 10972 | 12460 | 48078 | 26171 | 31421 | 26992 | 25967 | … | … | العراق
Jordan | … | … | … | … | … | … | … | … | … | … | … | … | … | الأردن
Kuwait | 379 | 420 | 418 | 412 | 422 | 420 | 456 | 449 | 494 | 606 | 496 | 484 | … | الكويت
Lebanon | … | … | … | … | … | … | … | … | … | … | … | … | … | لبنان
Libya | … | … | … | … | … | … | … | … | … | … | … | … | … | ليبيا
Morocco | … | … | … | … | … | … | … | … | … | … | … | … | … | [NAME]
Oman | 368 | 335 | 332 | 335 | 336 | 315 | 499 | 503 | 507 | 622 | 581 | 640 | … | عمان
Palestine | 1056 | 1138 | 1126 | 1150 | 1103 | 1057 | 906 | 806 | 372 | 352 | 362 | 369 | … | فلسطين
Qatar | 132 | 111 | 107 | 137 | 113 | 110 | 114 | 117 | 132 | 130 | 132 | 156 | … | قطر
Saudi Arabia | 11707 | 11568 | 11432 | 11297 | 11165 | 11078 | 10954 | 10782 | 10576 | 10409 | … | ... | … | المملكة العربية السعودية
Sudan | ... | ... | ... | ... | ... | ... | ... | ... | … | … | … | … | … | السودان
Syrian Arab Republic | … | … | … | … | … | … | … | … | … | … | … | … | … | الجمهورية العربية السورية
Tunis | 3866 | 3737 | 3602 | 35454 | 3443 | 3473 | 3405 | … | … | … | … | 3267 | … | تونس
United Arab Emirates | 418 | 469 | 457 | 488 | 550 | 502 | 447 | 528 | 540 | 528 | 562 | ... | … | الإمارات العربية المتحدة
Yemen | … | … | … | … | … | … | … | … | … | … | … | … | … | اليمن
Spreadsheet: 56769d1256861371-kind-of-complicated-different-excel-sheets-linked-but-not-working-in-older-excel-exercices
Sheet: Noms

Noms | Total |  |  | Exercice 1 |  |  | Exercice 2 |  |  |  | Total | Nb fait | [NAME]
 | Total ex | [NAME] | Place | fait = 1 | option | note | fait = 1 | option | note
Stephen |  |  |  |  | 0 |  |  | 0
[NAME] |  |  |  |  | 1 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | entrer
Somme
[NAME]
Note la plus élevée
Note la plus plus basse
option à remplir pour chaque élève avant de commencer l'exercice | 0 | ne pas voir les notes |  |  |  | Base notation moyenne : sur |  |  |  | 20
 | 1 | voir les notes |  |  |  | Decote pour affichage |  |  |  | 0.25
 | 2 | élève absent
Spreadsheet: 741560d1627139193-auto-populate-table-with-start-and-end-year-expanding-fill-and-border-formatting-zainmerchant-
Sheet: Working

Financial Figures
Sales
Gross Profit
Free Cashflow
NPV
IRR
Lease
Sales
Gross Profit
Net Income
Asset Management
Sales
Gross Profit
Net Income
Spreadsheet: 83854d1283885778-fill-in-rows-fill-in-rows-with-text
Sheet: Sheet1

3M*8511 |  | 3M*8511
 |  | 3M*8511
99*CAB-1/0-500-FT |  | 99*CAB-1/0-500-FT
ACH*SSF500C |  | ACH*SSF500C
 |  | ACH*SSF500C
AER*15902-00000 |  | AER*15902-00000
 |  | AER*15902-00000
AER*331-4000 |  | AER*331-4000
 |  | AER*331-4000
AER*H7A-PTL |  | AER*H7A-PTL
 |  | AER*H7A-PTL
 |  | AER*H7A-PTL
AMI*A2M-S-10 |  | AMI*A2M-S-10
ANA*70 S2-116-1M |  | ANA*70 S2-116-1M
Spreadsheet: 73605d1274249159-goal-seek-as-a-formula-example
Sheet: Sheet1

Numer of Items | 144
Auction End Price | 275
Shipping In | 70.66
Buyer Premium | 0.05
Selling Price | 1.99 | 0.0687999747761383
Shipping Out | 4.99
Shipping Costs Per Item | 2.26
Mailers | 0.1
Revenue
Merchandise
Shipping In
Buyer Premium
Mailers
Fees
Shipping Out
Expenses
Profit
Break Even Sales Price
Break Even Sales
IRR
Spreadsheet: 738637d1625159077-find-the-min-and-max-revisions-with-alpha-or-numeric-find-min-max-revision
Sheet: Sheet1

doc number | revision |  |  | Search for:
Apple | 0 |  |  | Doc number | Min Rev | [NAME]
Apple | 2 |  |  | Apple | 0 | ZA
[NAME] | 1 |  |  | [NAME] | 1 | 2
Apple | 1 |  |  | Grapes | 0 | 1
Orange | 0
[NAME] | 2 |  |  | note:
Apple | A |  |  | I have a large spreadsheet with repeating doc numbers but of different revisions
Grapes | 1 |  |  | I need to find the min and [NAME] revision wherein numerical revisions are lower and
Apple | ZA |  |  | Alphabet revisions are highest. In this case the ascending revision sequence for Apple is (0,1,2,A,ZA)
Grapes | 0 |  |  | [NAME] is (1,2)
 |  |  |  | [NAME] is (0,1)
Spreadsheet: 858790d1707336802-conditional-format-all-columns-if-a-cell-value-excel-forum-week-cf
Sheet: Sheet1

 | WEEK NUMBER
 | 1
[NAME]
Barnsley Chop |  |  |  |  |  |  |  |  |  |  |  | Current  Week
Beverley S |  |  |  |  |  |  |  |  |  |  |  | 6
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Fran
[NAME]
[NAME]
Jake
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 156406d1337280605-excel-2007-need-to-create-batting-order-depending-on-stats-and-cant-have-a-player-twice-in-line-up-softball-stats-monday-night
Sheet: Blank

 | Game # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | Total
 | Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Home |  |  |  |  |  |  |  | 0 | 0 | 0
 | Location |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Visitor |  |  |  |  |  |  |  | 0 | 0 | 0
 | Opponent
 | Result | Loss
# | Name | G | AB | 1B | 2B | 3B | HR | BB | SAC | R | RBI | BA | OBP | SLG | OPS
1 | Scott | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | n/a | n/a | n/a | n/a
2 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | n/a | n/a | n/a | n/a
3 | Jared | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | n/a | n/a | n/a | n/a
4 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | n/a | n/a | n/a | n/a
5 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | n/a | n/a | n/a | n/a
6 | Joel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | n/a | n/a | n/a | n/a
7 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | n/a | n/a | n/a | n/a
8 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | n/a | n/a | n/a | n/a
9 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | n/a | n/a | n/a | n/a
10 | Kris | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | n/a | n/a | n/a | n/a
11 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | n/a | n/a | n/a | n/a
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | n/a | n/a | n/a | n/a
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | n/a | n/a | n/a | n/a
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | n/a | n/a | n/a | n/a
 | TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | n/a | n/a | n/a | n/a
 | MAX
Spreadsheet: 730851d1619993831-manipulate-data-tables-sarah-problems
Sheet: Problem2

Original |  |  |  |  |  |  | Goal
Time Interval |  | Event Onset Time |  | Try Pivot Table Groups for this answer. |  |  | Time Interval | Event Onset Time
0 - 7.5 sec. |  | 0.4 |  |  |  |  | 0 - 7.5 sec. | 0.4
7.7 - 12 sec. |  | 3.7 |  |  |  |  | 0 - 7.5 sec. | 3.7
12 - 19.3 sec. |  | 5.2 |  | Row Labels | Count of Event Onset Time |  | 0 - 7.5 sec. | 5.2
19.3 -24.4 sec. |  | 9.1 |  | 0-7.5 | 3 |  | 7.7 - 12 sec. | 9.1
24.4-27 sec. |  | 9.8 |  | 7.5-15 | 5 |  | 7.7 - 12 sec. | 9.8
27 -31.8 sec. |  | 11.7 |  | 15-22.5 | 4 |  | 7.7 - 12 sec. | 11.7
 |  | 12.9 |  | 22.5-30 | 7 |  | 12 - 19.3 sec. | 12.9
 |  | 14.9 |  | 30-37.5 | 1 |  | 12 - 19.3 sec. | 14.9
 |  | 17 |  | Grand Total | 20 |  | 12 - 19.3 sec. | 17
 |  | 19.1 |  |  |  |  | 12 - 19.3 sec. | 19.1
 |  | 19.4 |  |  |  |  | 19.3 -24.4 sec. | 19.4
 |  | 22.2 |  |  |  |  | 19.3 -24.4 sec. | 22.2
 |  | 23.7 |  |  |  |  | 19.3 -24.4 sec. | 23.7
 |  | 24.9 |  |  |  |  | 19.3 -24.4 sec. | 24.9
 |  | 25.7 |  |  |  |  | 24.4-27 sec. | 25.7
 |  | 26.1 |  |  |  |  | 24.4-27 sec. | 26.1
 |  | 26.8 |  |  |  |  | 24.4-27 sec. | 26.8
 |  | 28.2 |  |  |  |  | 27 -31.8 sec. | 28.2
 |  | 29.5 |  |  |  |  | 28 -31.8 sec. | 29.5
 |  | 31.7 |  |  |  |  | 29 -31.8 sec. | 31.7
Spreadsheet: 43512d1242154252-how-to-extract-dates-from-cells-and-list-them-seperately-in-a-new-tab-calendar
Sheet: Events

Month | December |  |  |  | January |  |  |  | February |  |  |  | March
Quarter | 4th Quarter 2009 |  |  |  | 1st Quarter 2010
Week (Mon Start) | 7 | 14 | 21 | 28 | 4 | 11 | 18 | 25 | 1 | 8 | 15 | 22 | 1 | 8 | 15 | 22 | 29
EVENT
Shows |  |  |  |  | 1 - Australia |  |  |  | 2 - Singapore |  |  |  | 1 - England
PR | 7 - TV Interview |  |  |  | 3 - Photoshoot
DIGITAL
Launch | 7 - Band Website |  |  |  | 4 - Band Radio Show |  |  |  |  |  |  |  |  | 8 - Band Profile
Send |  |  | 23 - Band Photos |  |  |  | 13 - Band Interview |  |  |  |  |  |  |  |  |  | 29 - Band Digital Media
Spreadsheet: 547340d1510503270-filling-across-a-range-of-sheets-test
Sheet: Shiznet

BOAT NAME
OWNER NAME
MOORING TYPE
ADDRESS
HOME TEL
MOBILE TEL
[NAME]
BOAT TYPE
LENGTH
HULL COLOUR
UPPER DECK
TENDER?
DURATION
FEE
NEXT INVOICE DUE DATE | 2015-05-28 00:00:00
INVOICE DUE DATE | INVOICE REMINDER DATE | INVOICE SENT DATE | DATE PAID | NOTES
2015-05-28 00:00:00
Spreadsheet: 870331d1716879086-fetch-applicable-irr-base-on-slab-wise-conditions-roi-chart-template-280524
Sheet: ROI Chart

 | Business Volume - in lakhs | Weighted Avg IRR ----> | 14.00-14.99% | 15.00-15.99% | 16.00 - 16.99% | 17.00 - 17.99% | 18.00 - 18.49% | 18.50 - 18.99% | 19.00 - 19.49% | 19.50 - 20.49% | 20.50 - 21.49% | 21.50% +
 |  | Tenure
 | 0 - 9.99 | up to 17 months | 0.0225 |  |  |  |  |  |  |  |  |  | Applicable IRR
 |  | Between 18 to 24 months | 0.0335
 |  | Greater than 24 months | 0.0445
 | 10.00 - 14.99 | up to 17 months | 0.0235
 |  | Between 18 to 24 months | 0.0335
 |  | Greater than 24 months | 0.0445
 | 15.00 - 19.99 | up to 17 months | 0.0245
 |  | Between 18 to 24 months | 0.0345
 |  | Greater than 24 months | 0.0445
 | 20.00 - 24.99 | up to 17 months | 0.0255
 |  | Between 18 to 24 months | 0.0355
 |  | Greater than 24 months | 0.0455
 | 25.00 + | up to 17 months | 0.0265 | 0.029 | 0.031 | 0.0325 | 0.034 | 0.035 | 0.036 | 0.037 | 0.038 | 0.039
 |  | Between 18 to 24 months | 0.0365 | 0.029 | 0.031 | 0.0325 | 0.034 | 0.035 | 0.036 | 0.037 | 0.038 | 0.039
 |  | Greater than 24 months | 0.0465 | 0.029 | 0.031 | 0.0325 | 0.034 | 0.035 | 0.036 | 0.037 | 0.038 | 0.039
 |  |  | Business volume | AVG IRR | Tenure | Applicable IRR
 |  |  | 800000 | 0.154 | 16 |  | <------
 |  |  | 1600000 | 0.1767 | 27 |  | <------
 |  |  | 2700000 | 0.214 | 21 |  | <------
Spreadsheet: 743808d1628746184-sumproduct-with-substitute-book1
Sheet: Sheet1

No . | Name | Attendance | Alternative |  | SUMPRODUCT | SUMPRODUCT+SUBSTITUTE
1 | A | Yes |  | Yes |  |  | Attended
2 | B | Yes |  | No |  |  | Not Attended
3 | C | No
4 | D | No
5 | E | Yes
6 | F | Yes
7 | G | Yes
8 | H | Yes
9 | I | Yes
10 | J | Yes
Spreadsheet: 877268d1724060473-identifying-cell-value-increases-when-data-is-updated-test-data
Sheet: Summary

 | Sum of Hours Spent |  | Status
 | Code | Name | CLOSED | [NAME] | ON HOLD | Grand Total
 | 2 | Project 3 |  |  | 12 | 12
 | 5 | Project 6 | 0 |  |  | 0
 | 6 | Project 7 |  | 100 |  | 100
 | 12 | Project 13 | 10 |  |  | 10
 | 18 | Project 19 |  | 36 |  | 36
 | 43 | Project 44 |  | 186 |  | 186
 | 50 | Project 51 |  |  | 0 | 0
 | 65 | Project 66 |  |  | 23 | 23
 | Grand Total |  | 10 | 322 | 35 | 367
Spreadsheet: 125570d1319108890-excel-2007-moving-values-between-sheets-by-using-number-commands-weight-and-buildup
Sheet: ULD3&4

3 |  |  |  |  |  |  | 4
 |  |  |  | Aircraft Position |  |  |  |  |  |  | Aircraft Position
Built up by: |  |  | Origin | ULD Ident |  |  | Built up by: |  |  | Origin | ULD Ident
Total Pages: |  |  | KEF |  |  |  | Total Pages: |  |  | KEF
AWB | DEST | PCS | WEIGHT |  | Flight Number |  | AWB | DEST | PCS | WEIGHT |  | Flight Number
 |  |  |  |  | Offload Point |  |  |  |  |  |  | Offload Point
 |  |  |  |  | Final Dest |  |  |  |  |  |  | Final Dest
ULD Tare Weight: |  |  |  |  |  |  |  | ULD Tare Weight:
RMK | Total |  |  |  |  |  | RMK | Total
Spreadsheet: 703630d1605092481-lost-in-vlookup-offset-index-etc-example
Sheet: ROOM OVERVIEW

 |  | Dimensions
 | Room no. | Area | Height | Volume | Heat load | Cooling load
 | A0001 | 10 | 2 |  | Lookup value in sheet "CALC" on room no | Lookup value in sheet "CALC" on room no
 | A0002 | 20 | 2 |  | Lookup value in sheet "CALC" on room no | Lookup value in sheet "CALC" on room no
 | A0003 | 30 | 2 |  | Lookup value in sheet "CALC" on room no | Lookup value in sheet "CALC" on room no
 | A0004 | 40 | 2 |  | Lookup value in sheet "CALC" on room no | Lookup value in sheet "CALC" on room no