tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 80874d1281032900-uniquely-rank-based-on-two-criteria-sample1
Sheet: Sheet1

Product ID | Offer $ |  |  |  |  |  | Product ID | 1 | 2 | 3 | 4 | 5 | 6
123456789 | 50 |  |  |  |  |  | 123456789 | 60
123456789 | 20 |  |  |  |  |  | 987654321 | 12
123456789 | 50
123456789 | 20
123456789 | 60
987654321 | 10
123456789 | 25
987654321 | 12
987654321 | 10
Spreadsheet: 735961d1623279180-help-on-calculating-deposit-amounts-based-on-percentages-and-adding-totals-for-each-month-example-summary-sheet-calculation
Sheet: SUPERSEDED Margin Analysis

 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Job #1
Job #2
Job #3
Job #4
Job #5
Job #6
Average
 | Gross Profit | % Complete | Ave Margin
Spreadsheet: 183962d1349103629-excel-pivot-tables-tf-performance-2-latest-q3
Sheet: Sheet10

Ops # | Month | Date | Year | Client | Buyer | Cargo Type | Nominated Cargo Quantity (MT) | Support Craft | Invoiced Ammount ($) | Commenced Fendering | Completed Fendering | Total Fendering Time | Mooring Master
325 | July |  | 2012 | Glencore | Glencore | PMS | 30500 | Glory | 10963.54 | 14:30:00 | 15:56:00 | 01:26:00 | Young Ogori
369 | July |  | 2012 | Glencore | Glencore | PMS | 7350 | Glory | 21391.67 | 18:42:00 | 19:56:00 | 01:14:00 | Philly Okanre
426 | July |  | 2012 | Glencore | Oando | PMS | 10500 | Glory | 7800 |  |  |  | Philly Okanre
775 | Aug |  | 2012 | Glencore | Glencore | PMS | 33000 | Glory |  | 07:00:00 | 08:24:00 | 01:24:00 | young ogori
Spreadsheet: 757992d1638553192-return-different-values-based-on-column-contents-array-excel-problem-aligw
Sheet: Sheet1

[NAME]
Heavenly Milk Pistachio | YES | YES | NO
Evaporated Milk | NO | NO | NO
Condensed Milk | NO | NO | NO
Cream | NO | NO* | NO
[NAME] | NO | NO | NO*
[NAME] | YES | YES | NO
Espresso Milk Cake
Heavenly Espresso Milk Cake | YES | YES | NO
Evaporated Milk | NO | NO | NO
Condensed Milk | NO | NO | NO
Cream | NO | NO | NO
Milk Chocolate Shavings | NO | NO | NO
[NAME] | NO | NO | NO
Chocolate Nut Petal Wafer | YES | YES | NO
Spreadsheet: 293559d1391021975-similar-but-not-duplicate-rows-forum
Sheet: Sheet1

Idnum | D_ID | S_ID | T_ID
90660456 |  | 5004053 | 30010708
90671367 |  |  | 30001398
90671367 | 7008301 | 5004054
90671367 | 7008301 | 5004054 | 30001399
90673772 | 7008302 | 5004055 | 30010709
90673873 | 7008303
90680434 |  | 5004059
90680434 |  |  | 30010710
91433539 |  |  | 30001402
91433539 |  | 5004081
91433539 | 7008326
91433539 | 7008326 |  | 30001403
91433539 | 7008327
91433539 | 7008327 |  | 30001403
91460173 |  |  | 30010735
91635747 | 7008342
91636149 | 7008343
91636149 | 7008344
91637772 | 7008345
100558511 | 7008655
100558511 |  | 5004459
100558511 | 7008655 | 5004459
100558511 |  |  | 30011118
100558511 | 7008656 |  | 30011118
100558511 |  | 5004460 | 30011118
100558511 | 7008656 | 5004460 | 30011118
100571492 |  | 5004461
Spreadsheet: 59834d1260373930-using-pivottable-to-compute-of-total-by-row-field-book1
Sheet: Sheet2

 |  | Standard Pivot Table |  |  |  |  |  |  | Desired Pivot table
 |  | Sum of Total |  |  |  |  |  |  | Sum of Total
 |  | Customer Name | W/N | Total |  |  |  |  | Customer Name | W/N | Total | Total Percent
 |  | a | 1 | 0 |  |  |  |  | a | 1 | 0 | 1
 |  | a Total |  | 0 |  |  |  |  | a Total |  | 0 | 1
 |  | b | 2 | 120000 |  |  |  |  | b | 2 | 120000 | 0.807183937039653
 |  |  | 3 | 28665 |  |  |  |  |  | 3 | 28665 | 0.1928160629603471
 |  | b Total |  | 148665 |  |  |  |  | b Total |  | 148665 | 1
 |  | c | 4 | 43600 |  |  |  |  | c | 4 | 43600 | 1
 |  | c Total |  | 43600 |  |  |  |  | c Total |  | 43600 | 1
 |  | d | 5 | 16750 |  |  |  |  | d | 5 | 16750 | 1
 |  | d Total |  | 16750 |  |  |  |  | d Total |  | 16750 | 1
 |  | e | 6 | 47604 |  |  |  |  | e | 6 | 47604 | 1
 |  | e Total |  | 47604 |  |  |  |  | e Total |  | 47604 | 1
 |  | f | 7 | 323640 |  |  |  |  | f | 7 | 323640 | 0.6386770205334149
 |  |  | 8 | 171295 |  |  |  |  |  | 8 | 171295 | 0.338036646373351
 |  |  | 9 | 11800 |  |  |  |  |  | 9 | 11800 | 0.02328633309323414
 |  | f Total |  | 506735 |  |  |  |  | f Total |  | 506735 | 1
 |  | Grand Total |  | 763354 |  |  |  |  | Grand Total |  | 763354
Spreadsheet: 584009d1532919802-training-matrix-employee-records-management-copy-of-sample-data-trench3368-
Sheet: Employee Query

Report for training outstanding / lapsed by employee
Name | TC1 | TC2 | TC3 | TC4
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 598512d1542562252-creating-a-list-from-cross-referenced-data-sample
Sheet: Sheet1

Person | A | B | C | D | E | F | G |  | RESULTS
#1 | 2 |  |  |  |  |  |  |  | Person | Type
#2 |  |  |  | 1 |  |  |  |  | #1 | A
#3 |  |  |  |  |  |  |  |  | #1 | A
#4 |  |  |  |  |  |  |  |  | #2 | D
#5 |  |  |  |  |  |  | 2 |  | #5 | G
 |  |  |  |  |  |  |  |  | #5 | G
Spreadsheet: 463175d1464343538-split-the-numbers-sample-sheet
Sheet: Data

Date | Vehicle Number | Kgs | Vehicles needed | Vehicle Number
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
2016-06-01 00:00:00 | KA 20 AA 001 | 1420
2016-06-01 00:00:00 | KA 20 AA 002 | 2110
2016-06-01 00:00:00 | KA 20 AA 003 | 17690
2016-06-01 00:00:00 | KA 20 AA 004 | 4100
2016-06-01 00:00:00 | KA 20 AA 005 | 4210
2016-06-01 00:00:00 | KA 20 AA 006 | 5405
2016-06-01 00:00:00 | KA 20 AA 007 | 3900
2016-06-01 00:00:00 | KA 20 AA 008 | 1680
2016-06-01 00:00:00 | KA 20 AA 009 | 4995
2016-06-01 00:00:00 | KA 20 AA 010 | 750
2016-06-01 00:00:00 | KA 20 AA 011 | 1505
2016-06-01 00:00:00 | KA 20 AA 012 | 935
2016-06-01 00:00:00 | KA 20 AA 013 | 11365
2016-06-01 00:00:00 | KA 20 AA 014 | 5240
2016-06-01 00:00:00 | KA 20 AA 015 | 3635
2016-06-01 00:00:00 | KA 20 AA 016 | 1575
2016-06-01 00:00:00 | KA 20 AA 017 | 17475
2016-06-01 00:00:00 | KA 20 AA 018 | 11455
2016-06-01 00:00:00 | KA 20 AA 019 | 12320
2016-06-01 00:00:00 | KA 20 AA 020 | 1125
Spreadsheet: drew_fossum__8992__Fixed3
Sheet: Sempra_2.1_Expired

[NAME]
FUEL HEDGING BOOK
Sempra_2.1
DEAL EXPIRED
Prod. | Contract | Contract | Fixed |  | Fuel | Settled | Futures | (Gains) and Losses
Date | Number | Name | Price |  | Dth | Price | Price | Total | Realized | Unrealized
 |  |  |  |  |  | El Paso Prmn |  | (4) | (4) | (4)
1999-05-01 00:00:00 |  | Sempra | 2.01 |  |  | 2.16
1999-06-01 00:00:00 |  | Sempra | 2.01 |  |  | 2.08
1999-07-01 00:00:00 |  | Sempra | 2.01 |  |  | 2.17
1999-08-01 00:00:00 |  | Sempra | 2.01 |  |  | 2.46
1999-09-01 00:00:00 |  | Sempra | 2.01 |  |  | 2.78
1999-10-01 00:00:00 |  | Sempra | 2.01 |  |  | 2.42
1999-11-01 00:00:00 |  | Sempra | 2.01 |  |  | 2.87
1999-12-01 00:00:00 |  | Sempra | 2.01 |  |  | 2.08
 |  |  |  |  |  | TW Index
1999-05-01 00:00:00 |  | Over-retention | 2.01 |  |  | 2.06
1999-06-01 00:00:00 |  | Over-retention | 2.01 |  |  | 2.07
1999-07-01 00:00:00 |  | Over-retention | 2.01 |  |  | 2.11
1999-08-01 00:00:00 |  | Over-retention | 2.01 |  |  | 2.51
1999-09-01 00:00:00 |  | Over-retention | 2.01 |  |  | 2.36
1999-10-01 00:00:00 |  | Over-retention | 2.01 |  |  | 2.62
1999-11-01 00:00:00 |  | Over-retention | 2.01 |  |  | 2.17
1999-12-01 00:00:00 |  | Over-retention | 2.01 |  |  | 2.24
(4)Gain and [NAME] are a measurement of the effectiveness of meeting the stated hedge objective.
Spreadsheet: 73128d1273773756-reference-another-cell-in-full-referencing-cells-example
Sheet: Sheet1

 | Symbol | Type | Web Link | Markets | Fidelity Trading Fee | [NAME] | Index Fund | 1 Year | 3 Years | 5 Years | 10 Years | 15 Years | MS Overall Rating | Best 3 Months (5 Years) | Worst 3 Months  (5 Years) | Expense Ratio | Y Perf | MS Fee Link | Beta | Alpha | R² | [NAME] | [NAME] | Marketimer Portfolio I | Marketimer Portfolio II | Marketimer Portfolio III | Kiplinger Top 25 | [NAME]'s Funds | Fidelity Fund Pick
Rydex Nasdaq - 100 Fund | RYOCX | Stocks | http://www.google.com/finance?q=RYOCX | US | None | Large Growth (1) | Y | 0.5742 | 0.0289 | 0.053 | -0.0875 | 0.0982 | 3 | 0.5298 | -0.3903 | 0.013 | http://www.schwab.com/public/schwab/research_strategies/mutual_funds/summary/non_schwab/at_a_glance.html?cmsid=P-1018795&lvl1=research_strategies&lvl2=mutual_funds&ticker_sym_nm=ryocx |  | 1.57 | -4.19 | 73.71 | 29.1 | -0.26 | Y | Y
Rydex Nasdaq - 100 Fund | RYOCX | Stocks | http://www.google.com/finance?q=RYOCX | US | None | Large Growth (1) | Y | 0.5742 | 0.0289 | 0.053 | -0.0875 | 0.0982 | 3 | 0.5298 | -0.3903 | 0.013 | http://www.schwab.com/public/schwab/research_strategies/mutual_funds/summary/non_schwab/at_a_glance.html?cmsid=P-1018795&lvl1=research_strategies&lvl2=mutual_funds&ticker_sym_nm=ryocx | 0 | 1.57 | -4.19 | 73.71 | 29.1 | -0.26 | Y | Y | 0 | 0 | 0 | 0
Spreadsheet: 859366d1707769990-populate-a-column-with-data-from-a-changing-list-maplist-match
Sheet: Sheet1

Map Table (Query) Data Source
Headings | Account Description
Soft Costs- [NAME] | Soft Costs- [NAME]
Soft Costs- [NAME] | Words 1
Soft Costs- [NAME] | Words 2
Soft Costs- [NAME] | PM Fee
Soft Costs- [NAME] | Consultant - Other
Allowances - CAP - CAP | Allowances - CAP - CAP
Allowances - CAP - CAP | Words 1
Allowances - CAP - CAP | Words 2
Allowances - CAP - CAP | PM Fee
Allowances - CAP - CAP | Consultant - Other
Allowances - CAP - CAP | JLL FM Support Allowance
Allowances - CAP - CAP | [NAME]
Hard Costs - CAP | Hard Costs - CAP
Hard Costs - CAP | Construction
Owner [NAME] | Owner [NAME]
Owner [NAME] | Project Contingency
Target Table - Cost Group list is fixed and need the Matching items from a variable Map Table like example above
Cost Group | Account Description
Soft Costs- [NAME] | Soft Costs- [NAME]
Soft Costs- [NAME] | Words 1
Soft Costs- [NAME] | Words 2
Soft Costs- [NAME] | PM Fee
Soft Costs- [NAME] | Consultant - Other
Soft Costs- [NAME]
Soft Costs- [NAME]
Soft Costs- [NAME]
Soft Costs- [NAME]
Allowances - CAP - CAP | Allowances - CAP - CAP
Allowances - CAP - CAP | Words 1
Allowances - CAP - CAP | Words 2
Allowances - CAP - CAP | PM Fee
Allowances - CAP - CAP | Consultant - Other
Allowances - CAP - CAP | JLL FM Support Allowance
Allowances - CAP - CAP | [NAME]
Allowances - CAP - CAP
Allowances - CAP - CAP
Allowances - CAP - CAP
Allowances - CAP - CAP
Hard Costs - CAP | Hard Costs - CAP
Hard Costs - CAP | Construction
Hard Costs - CAP
Owner [NAME] | Owner [NAME]
Owner [NAME] | Project Contingency
Spreadsheet: 179109d1347030505-problem-with-formula-that-displays-contents-from-some-cells-but-not-others-pilotlog-and-techlogtest
Sheet: Pilot log1

 |  |  |  |  |  |  | Pilot Log Book
 |  |  |  |  |  |  |  | part 1
 |  | Aircraft |  | Captain |  | Holders Operating | Journey or Nature of flight |  | [NAME] | [NAME] | Single Engine
 | Date | Type | Reg |  |  | Capacity | From | To | (GMT) | (GMT) | In Command | Dual | T.Off | LDGs | Remarks
 |  |  |  |  |  |  | Brought forward from previous record
 | 2012-08-10 00:00:00 | Beagle | G-AXNP | [NAME] |  | P1 | EGCV | [NAME] | 11:30:00 | 12:30:00
 | 2012-08-11 00:00:00 |  | G-AXNP | [NAME] |  | PUT |  |  | 10:05:00 | 11:00:00
 | 2012-08-11 00:00:00 |  | G_AXNP | [NAME] |  | PUT |  |  | 12:22:00 | 12:55:00
 | 2012-09-13 00:00:00 |  | G-AXNP | [NAME] |  | P1 |  |  | 13:02:00 | 14:08:00
 | 2012-09-14 00:00:00 |  | G-AXNP | [NAME] |  | PUT |  |  | 13:00:00 | 13:55:00
 | 2012-11-15 00:00:00 |  | G-BSGL | [NAME] |  | P1 |  |  | 9:10:00 | 11:12:00
 | 2012-11-17 00:00:00 |  | G-BSGL | [NAME] |  | P1/s |  |  | 13:02:00 | 13:55:00
 |  |  |  |  |  | P1/s |  |  | 16:35:00 | 18:00:00
 |  |  |  |  |  | PUT |  |  | 9:00:00 | 15:00:00
 |  |  |  |  |  | PIC |  |  | 14:00:00 | 14:25:00
 |  |  |  |  |  | PIC |  |  | 6:30:00 | 7:35:00
 |  |  |  |  |  |  |  | Total hours
Spreadsheet: e26973ab-4837-481a-a9f7-0470bf50e234
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
38790476 | 2013-12-01 19:57:38 | AXIS | 1 | 6 | 5 | 802263 | Chuikov | 7596 | eastern | 1941-12-07 | 1941-12-08 | Breakout at Klin | Évasion à Klin
38790808 | 2013-12-01 20:11:31 | ALLIES | 0 | 2 | 6 | 802263 | Chuikov | 7596 | eastern | 1941-12-07 | 1941-12-08 | Breakout at Klin | Évasion à Klin
38808049 | 2013-12-02 23:09:10 | AXIS | 1 | 4 | 2 | 959603 | TommyGuts | 6162 | western | 1944-06-06 | 1944-06-06 | Pointe-du-Hoc | Pointe-du-Hoc
38808196 | 2013-12-02 23:24:46 | ALLIES | 1 | 4 | 2 | 959603 | TommyGuts | 6162 | western | 1944-06-06 | 1944-06-06 | Pointe-du-Hoc | Pointe-du-Hoc
38808870 | 2013-12-03 00:08:21 | ALLIES | 1 | 6 | 2 | 1450920 | player1450920 | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
38809045 | 2013-12-03 00:33:19 | AXIS | 1 | 6 | 5 | 418850 | SIR B LAW | 8044 | eastern | 1942-01-26 | 1942-02-07 | Rzhev | Rzhev
38809303 | 2013-12-03 00:51:54 | ALLIES | 0 | 4 | 6 | 418850 | SIR B LAW | 8044 | eastern | 1942-01-26 | 1942-02-07 | Rzhev | Rzhev
38835929 | 2013-12-04 23:48:56 | ALLIES | 1 | 10 | 5 | 867821 | b.kuntscher | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
38836430 | 2013-12-05 00:17:01 | AXIS | 0 | 5 | 10 | 867821 | b.kuntscher | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
38872158 | 2013-12-07 16:39:46 | ALLIES | 0 | 1 | 6 | 678541 | Sauron93 | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
38872338 | 2013-12-07 17:00:14 | AXIS | 0 | 1 | 6 | 678541 | Sauron93 | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
38874183 | 2013-12-07 19:10:54 | AXIS | 0 | 4 | 6 | 1454549 | Avalon6 | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
38874393 | 2013-12-07 19:41:13 | AXIS | 1 | 6 | 5 | 1448307 | K-ami-case | 7669 | pacific | 1941-12-23 | 1941-12-23 | Wake Island | Ile de Wake
38874784 | 2013-12-07 19:54:22 | ALLIES | 0 | 3 | 6 | 1448307 | K-ami-case | 7669 | pacific | 1941-12-23 | 1941-12-23 | Wake Island | Ile de Wake
38874869 | 2013-12-07 20:02:28 | AXIS | 0 | 2 | 4 | 1249072 | player1249072 | 6158 | western | 1944-06-06 | 1944-06-06 | Pegasus Bridge | Pegasus Bridge
Spreadsheet: 137459d1327135527-extending-formulas-on-linked-sheet-to-continue-onto-other-worksheets-copy_dummy-file-with-extended-worksheets
Sheet: Expense Report - Page 3

Name |  | Company | Purpose | Start Date | End Date
Date | Payee | Type of Expense | Purpose | Individuals/Companies | Amount
 |  |  |  | Expense Subtotal (Page 2):
Spreadsheet: 139911d1328542835-ongoing-time-sheet-problem-book1
Sheet: Overall Hours

EMP# | NAME | Week 1 | Week 2
1 | Employee 1
2 | Employee 2
3 | Employee 3
4 | Employee 4
5 | Employee 5
6 | Employee 6
7 | Employee 7
8 | Employee 8
9 | Employee 9
10 | Employee 10
11 | Employee 11
Spreadsheet: 772442d1647275682-not-sure-if-formula-or-code-required-drawing-data-across-sheets-with-cell-value-dependency-test-draft
Sheet: quote

 |  |  | 20
 |  |  | 17
 |  |  | 16
 |  | 0
Spreadsheet: 142980d1330107498-drop-down-list-to-auto-populate-fields-and-multiplied-by-another-field-example-1-
Sheet: Sheet1

 | Selection | Quantity
 | Food 1 | 1
 | Food 2 | 4
 | Food 3 | 99
 | Food 4 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Food 1
 |  |  | QTY | Pizza | Tacos | Apples | Oranges |  |  |  |  |  |  |  |  |  |  | Food 2
 |  | Food 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Food 3
 |  | Food 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Food 4
 |  | Food 3
 |  | Food 4
Spreadsheet: vkaminski__40909__raptor4b
Sheet: Summary

 | Raptor IV Daily Position Report & Summary
 | Inputs:
 | Trade Date | 2001-01-29 00:00:00 | Prior Day
 | Summary:
 | Gains and Losses | Total | Realized | Unrealized
 | Previous Day's Cumulative
 | Today's Activity
 | Cumlative Ending
 | Notional Capacity
 | Credit Capacity
 | Remaining Governance Capacity
Spreadsheet: 677189d1589229341-how-to-transpose-column-into-rows-makeover
Sheet: makeover

company |  |  | company | sector | industry | continent | country | marketvalue | sales | profits | assets | rank | forbeswebpage
sector |  |  | ICBC | Financials | Major [NAME] | Asia | China | 215.6 | 148.7 | 42.7 | 3124.9 | 1 | http://www.forbes.com/companies/icbc/
industry |  |  | China Construction Bank | Financials | Regional Banks | Asia | China | 174.4 | 121.3 | 34.2 | 2449.5 | 2 | http://www.forbes.com/companies/china-construction-bank/
continent |  |  | Agricultural Bank of China | Financials | Regional Banks | Asia | China | 141.1 | 136.4 | 27 | 2405.4 | 3 | http://www.forbes.com/companies/agricultural-bank-of-china/
country
marketvalue
sales
profits
assets
rank
forbeswebpage
ICBC |  | Agricultural Bank of China | Financials | Regional Banks | Asia | China | 141.1 | 136.4 | 27 | 2405.4 | 3 | http://www.forbes.com/companies/agricultural-bank-of-china/
Financials |  | China Construction Bank | Financials | Regional Banks | Asia | China | 174.4 | 121.3 | 34.2 | 2449.5 | 2 | http://www.forbes.com/companies/china-construction-bank/
Major [NAME] |  | ICBC | Financials | Major [NAME] | Asia | China | 215.6 | 148.7 | 42.7 | 3124.9 | 1 | http://www.forbes.com/companies/icbc/
Asia
China
215.6
148.7
42.7
3124.9
1
http://www.forbes.com/companies/icbc/
China Construction Bank
Financials
Regional Banks
Asia
China
174.4
121.3
34.2
2449.5
2
http://www.forbes.com/companies/china-construction-bank/
Agricultural Bank of China
Financials
Regional Banks
Asia
China
141.1
136.4
27
2405.4
3
http://www.forbes.com/companies/agricultural-bank-of-china/
Spreadsheet: 155255d1336744567-complete-a-column-with-1-if-this-year-is-between-2-years-and-the-country-coincide-forum
Sheet: Hoja5

 | country | ccode | year | quarter | BANK CRISES | inicio | fin
 | Argentina | 1 | 1980 | 1 |  | 1980 | 1982
 | Bahrain | 2 | 1980 | 1 |  | #N/A | #N/A
 | Belize | 3 | 1980 | 1 |  | #N/A | #N/A
 | Botswana | 4 | 1980 | 1 |  | #N/A | #N/A
 | Brazil | 5 | 1980 | 1 |  | 1994 | 1998
 | Bulgaria | 6 | 1980 | 1 |  | 1996 | 1997
 | Chile | 7 | 1980 | 1 |  | 1976 | 1976
 | China | 8 | 1980 | 1 |  | #N/A | #N/A
 | Colombia | 9 | 1980 | 1 |  | 1982 | 1982
 | Congo | 10 | 1980 | 1 |  | #N/A | #N/A
 | Costa Rica | 11 | 1980 | 1 |  | 1987 | 1991
 | Croatia | 12 | 1980 | 1 |  | 1998 | 1999
 | Cyprus | 13 | 1980 | 1 |  | #N/A | #N/A
 | Czech Republic | 14 | 1980 | 1 |  | #N/A | #N/A
 | Dominican Republic | 15 | 1980 | 1 |  | #N/A | #N/A
 | Ecuador | 16 | 1980 | 1 |  | 1982 | 1986
 | Egypt | 17 | 1980 | 1 |  | 1980 | 1980
 | El Salvador | 18 | 1980 | 1 |  | 1989 | 1990
 | Estonia | 19 | 1980 | 1 |  | 1992 | 1994
 | Guatemala | 20 | 1980 | 1 |  | #N/A | #N/A
 | Hungary | 21 | 1980 | 1 |  | 1991 | 1995
 | India | 22 | 1980 | 1 |  | 1993 | 1993
 | Indonesia | 23 | 1980 | 1 |  | 1997 | 2001
 | Iran | 24 | 1980 | 1 |  | #N/A | #N/A
 | Kazakhstan | 25 | 1980 | 1 |  | #N/A | #N/A
 | Korea | 26 | 1980 | 1 |  | 1997 | 1998
 | Latvia | 27 | 1980 | 1 |  | 2008 | …
 | Lebanon | 28 | 1980 | 1 |  | 1990 | 1993
 | Lithuania | 29 | 1980 | 1 |  | 1995 | 1996
 | Malaysia | 30 | 1980 | 1 |  | 1997 | 1999
 | Malta | 31 | 1980 | 1 |  | #N/A | #N/A
 | [NAME] | 32 | 1980 | 1 |  | #N/A | #N/A
 | Mexico | 33 | 1980 | 1 |  | 1981 | 1985
 | Moldova | 34 | 1980 | 1 |  | #N/A | #N/A
 | Morocco | 35 | 1980 | 1 |  | 1980 | 1984
 | Pakistan | 36 | 1980 | 1 |  | #N/A | #N/A
 | Panama | 37 | 1980 | 1 |  | 1988 | 1989
 | Peru | 38 | 1980 | 1 |  | 1983 | 1983
 | Philippines | 39 | 1980 | 1 |  | 1983 | 1986
 | Poland | 40 | 1980 | 1 |  | 1992 | 1994
 | Romania | 41 | 1980 | 1 |  | 1990 | 1992
 | Russian Federation | 42 | 1980 | 1 |  | #N/A | #N/A
 | Saudi Arabia | 43 | 1980 | 1 |  | #N/A | #N/A
 | Serbia | 44 | 1980 | 1 |  | #N/A | #N/A
 | Singapore | 45 | 1980 | 1 |  | #N/A | #N/A
 | Slovak Republic | 46 | 1980 | 1 |  | #N/A | #N/A
 | Slovenia | 47 | 1980 | 1 |  | 1992 | 1992
 | South Africa | 48 | 1980 | 1 |  | #N/A | #N/A
 | [NAME] | 49 | 1980 | 1 |  | 1989 | 1991
 | Taiwan | 50 | 1980 | 1 |  | #N/A | #N/A
 | Thailand | 51 | 1980 | 1 |  | 1983 | 1983
 | Trinidad and Tobago | 52 | 1980 | 1 |  | #N/A | #N/A
 | Tunisia | 53 | 1980 | 1 |  | 1991 | 1991
 | Turkey | 54 | 1980 | 1 |  | 1982 | 1984
 | Ukraine | 55 | 1980 | 1 |  | 1998 | 1999
 | Uruguay | 56 | 1980 | 1 |  | 1981 | 1985
 | Venezuela | 57 | 1980 | 1 |  | 1994 | 1998
Spreadsheet: 153549d1335960046-excel-2007-small-function-in-an-array-forum-1-
Sheet: Sheet1

DATE | 2012-01-01 00:00:00 | 2012-01-08 00:00:00 | 2012-01-15 00:00:00 | 2012-01-22 00:00:00 | 2012-01-29 00:00:00 | 2012-02-05 00:00:00 | 2012-02-12 00:00:00 | 2012-02-19 00:00:00 | 2012-02-26 00:00:00 | 2012-03-04 00:00:00 | 2012-03-11 00:00:00 | 2012-03-18 00:00:00 | 2012-03-25 00:00:00 | 2012-04-01 00:00:00 | 2012-04-08 00:00:00 | 2012-04-15 00:00:00 | 2012-04-22 00:00:00 | 2012-04-29 00:00:00 | 2012-05-06 00:00:00 | 2012-05-13 00:00:00 | 2012-05-20 00:00:00
 | 38 | 36 | 40 | 38 | 42 | 36 | 38 | 41 | 35 |  |  | 39 |  | 41
Spreadsheet: 100860d1299082596-looking-up-first-blank-cell-in-a-range-assessments
Sheet: JBloggs

Next
Type
Last Date
Assessment Type | ABM
Assessment | 2009-11-30 00:00:00
Review | 2010-03-31 00:00:00
Review | 2010-09-30 00:00:00
Review
Assessment
Review
Review
Review
Assessment
Review
Review
Review
Assessment
Review
Review
Review
Assessment
Review
Review
Review
Assessment
Review
Review
Review
Assessment
Review
Review
Review
Assessment
Review
Review
Review
Assessment
Review
Review
Review
Assessment
Review
Review
Review
Spreadsheet: 162432d1339868009-the-old-dreaded-inconsistant-formula-error-but-only-when-sorted-euro-challenge-2012
Sheet: Sheet1

 |  |  | EURO CHALLENGE 2012
VERY SIMPLE - JUST PICK 1 TEAM FROM GROUPS 1 - 3, AND 2 FROM GROUP 4!
GROUP 1 | [NAME] |  | GROUP 2 | [NAME] |  | GROUP 3 | [NAME]
HOLLAND |  |  | ENGLAND |  |  | DENMARK
SPAIN |  |  | ITALY |  |  | RUSSIA
GERMANY |  |  | PORTUGAL |  |  | SWEDEN
 |  |  | FRANCE |  |  | CROATIA
 |  |  | GROUP 4 | [NAME]
 |  |  | POLAND
 |  |  | UKRAINE
 |  |  | SWEDEN
 |  |  | [NAME]
 |  |  | CZECH REPUBLIC
[NAME] SCORED IN TOTAL? _______________________________
NAME ______________________________________________________________________
SCORING -
TEAM WIN | 5
TEAM DRAW | 2
GOAL SCORED | 1
HATRICK SCORED | 3
WIN ON PENALTIES | 2
PENALTY MISS | -1
SENDING OFF | -3
Spreadsheet: 167574d1342027389-n-a-error-on-cross-referencing-sample-book1
Sheet: Sheet2

4300
Temp  F | Temp F rounded | Elec Dmnd (kW) | Heat dmnd (kW) | elec load % | heat rate
46 | 50 | 2360.3836 | 4686.357243319268 | 0.5 | 10824
46 | 50 | 2436.9636 | 4613.132911392405 | 0.6000000000000001 | 10618 | 10139
45 | 50 | 2487.004 | 4564.316690107828 | 0.6000000000000001 | 10618 | 10139
45 | 50 | 2445.7828 | 4442.276136896389 | 0.6000000000000001 | 10618 | 10139
45 | 50 | 2478.4144 | 4539.90857946554 | 0.6000000000000001 | 10618 | 10139
42.1 | 40 | 2480.496 | 4271.419362400375 | 0.6000000000000001 | 9960
44.1 | 40 | 2496.6052 | 4124.970698546647 | 0.6000000000000001 | 9960
44.1 | 40 | 2568.9884 | 4198.195030473511 | 0.6000000000000001 | 9960
44.1 | 40 | 2738.702 | 4320.23558368495 | 0.6000000000000001 | 9960
45 | 50 | 2723.7752 | 4442.276136896389 | 0.6000000000000001 | 10618 | 10139
46.9 | 50 | 2727.7956 | 4491.092358180966 | 0.6000000000000001 | 10618 | 10139
50 | 50 | 2736.72 | 4637.541022034692 | 0.6000000000000001 | 10618 | 10139
51.1 | 50 | 2776.7168 | 4881.622128457571 | 0.6000000000000001 | 10618 | 10139
51.1 | 50 | 2790.5904 | 5150.111345522737 | 0.6000000000000001 | 10618 | 10139
50 | 50 | 2801.7072 | 5272.151898734176 | 0.7000000000000001 | 10415 | 9517
50 | 50 | 2820.7256 | 5272.151898734176 | 0.7000000000000001 | 10415 | 9517
50 | 50 | 2697.5388 | 5150.111345522737 | 0.6000000000000001 | 10618 | 10139
48.9 | 50 | 2717.2092 | 5076.887013595874 | 0.6000000000000001 | 10618 | 10139
Spreadsheet: 811738d1672766743-copy-whole-rows-if-condition-is-fulfilled-example-file-1-1-2-
Sheet: Pivot Table

Month | Calendar week | Start | Day | Name | Min. [NAME] at | Sum of Duration
March | 10 | 2023-03-06 00:00:00 | Monday | Appointment 1 | 09:00:00 | 09:00:00
 |  |  |  | Appointment 2 | 11:00:00 | 01:00:00
 |  |  | Monday Total |  | 09:00:00 | 10:00:00
 |  | 06.03.2023 Total |  |  | 09:00:00 | 10:00:00
 |  | 2023-03-07 00:00:00 | Tuesday | Appointment 3 | 08:30:00 | 1900-01-01 00:30:00
 |  |  | Tuesday Total |  | 08:30:00 | 1900-01-01 00:30:00
 |  | 07.03.2023 Total |  |  | 08:30:00 | 1900-01-01 00:30:00
 |  | 2023-03-08 00:00:00 | Wednesday | Appointment 4 | 08:00:00 | 02:30:00
 |  |  | Wednesday Total |  | 08:00:00 | 02:30:00
 |  | 08.03.2023 Total |  |  | 08:00:00 | 02:30:00
 | 10 Total |  |  |  | 08:00:00 | 1900-01-01 13:00:00
March Total |  |  |  |  | 08:00:00 | 1900-01-01 13:00:00