tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 743965d1628843978-highlight-date-range-on-calendar-399
Sheet: 3099 Calendar

 | 2021 | AUGUST |  | MONDAY |  | 399 Issue [NAME]
 | CALENDAR YEAR | CALENDAR MONTH |  | FIRST DAY OF WEEK
 |  | 44404 | 44405 | 44406 | 44407 | 44408 | 44409
 |  | 2021-07-27 00:00:00 | 2021-07-28 00:00:00 | 2021-07-29 00:00:00 | 2021-07-30 00:00:00 | 2021-07-31 00:00:00 | 2021-08-01 00:00:00
 |  | 2021-08-03 00:00:00 | 2021-08-04 00:00:00 | 2021-08-05 00:00:00 | 2021-08-06 00:00:00 | 2021-08-07 00:00:00 | 2021-08-08 00:00:00
 |  | 2021-08-10 00:00:00 | 2021-08-11 00:00:00 | 2021-08-12 00:00:00 | 2021-08-13 00:00:00 | 2021-08-14 00:00:00 | 2021-08-15 00:00:00
 |  | 2021-08-17 00:00:00 | 2021-08-18 00:00:00 | 2021-08-19 00:00:00 | 2021-08-20 00:00:00 | 2021-08-21 00:00:00 | 2021-08-22 00:00:00
 |  | 2021-08-24 00:00:00 | 2021-08-25 00:00:00 | 2021-08-26 00:00:00 | 2021-08-27 00:00:00 | 2021-08-28 00:00:00 | 2021-08-29 00:00:00
 |  | 2021-08-31 00:00:00 | 2021-09-01 00:00:00 | 2021-09-02 00:00:00 | 2021-09-03 00:00:00 | 2021-09-04 00:00:00 | 2021-09-05 00:00:00
Spreadsheet: 321dcd96-5757-4762-8c07-b850e4c519e2
Sheet: Sheet1

SCA largest shareholders | No. of A shares | No. of B shares | % of votes | % of shares
Industrivärden AB | 43100000 | 27700000 | 29.23 | 10.04
Handelsbanken* | 20845246 | 13030333 | 14.12 | 4.44
Norges Bank Investment Management** |  |  | 7.84 | 7.19
Skandia | 3243247 | 552516 | 2.1 | 0.54
[NAME] | 2478000 | 3785000 | 1.82 | 0.89
SEB* | 706787 | 12271491 | 1.23 | 1.84
AMF - Försäkring och Fonder |  | 18905014 | 1.2 | 2.68
[NAME] fonder | 27331 | 14312001 | 0.93 | 2.03
[NAME] | 350000 | 6225558 | 0.62 | 0.93
[NAME] | 399943 | 5728729 | 0.62 | 0.87
Spreadsheet: 826265d1681904823-formula-for-an-action-monitoring-spreadsheet-ifs-problem-for-excel-forum-aligw
Sheet: Sheet1

Question A | My first problem is how to automatically fill the 'action due date' with one formula from the 'date of inspection' and 'category of action' where Low=3months, Medium=2 weeks and High=same day.
Date of inspection | Category | Date action due
2022-01-21 00:00:00 | Low
2022-01-21 00:00:00 | Medium
2022-01-21 00:00:00 | High
 |  |  | To be blank
Question B | My second problem is that I'd like a single formula to write 'complete', 'overdue', or 'in date' in the final column. Some of the actions were due in the past, some are due in the future and some are complete.
Action due date | Date action completed | Compliance as of today
2022-01-21 00:00:00 | 2022-01-19 00:00:00
2022-01-21 00:00:00 | 2023-01-23 00:00:00
2023-03-30 00:00:00 | 2023-03-30 00:00:00
2022-01-21 00:00:00
2023-04-30 00:00:00
Spreadsheet: 541340d1507227689-help-finding-the-lowest-cost-based-on-a-few-criteria-sample
Sheet: Sheet1

Status | FT
Working Spousal Surcharge | Yes
[NAME] | <$70K
Coverage Tier Medical | EE_Only
Zip Code | 60174
Rating Band | 15
 | Aetna | Cigna | [NAME] | Geisinger | Health Net | Kaiser | Kaiser WA | United | UPMC
[NAME] | 480.78 | 380.88 | N/A | N/A | N/A | N/A | N/A | 509.8 | N/A
[NAME] | 512.57 | 408.93 | N/A | N/A | N/A | N/A | N/A | 563 | N/A
Silver | 577.75 | 463.55 | N/A | N/A | N/A | N/A | N/A | 591.5 | N/A
Gold | 707.42 | 612.72 | N/A | N/A | N/A | N/A | N/A | 773.81 | N/A
Platinum | 897.05 | 741.42 | N/A | N/A | N/A | N/A | N/A | 985.51 | N/A
Lowest Cost Bronze Carrier amoung Aetna, Cigna, United and Kaiser (if cell A6 is 14 or 15)
Rate: Lowest cost bronze price amoung Aetna, Cigna, United and Kaiser (if cell A6 is 14 or 15 Kaiser bronze should be pulled otherwise lowest cost bronze plan)
Spreadsheet: 140576d1328809467-dropdown-menus-with-filtering-report
Sheet: Lists

Location Area | 3rd floor Admin area | Bar | Clasp offices | Dining
3rd floor Admin area | Accounts office | Bar cellar | Office 12 | Mezzanine
Bar | Admin toilets | Bar store 19 | Office 13a | [NAME]
Clasp offices | BD office | Bar wine store | Office 13b | [NAME]
Dining | IT office | [NAME]'s bar (Back of house) | Office 14a | Cedar Restaurant
 | Johns office | [NAME]'s bar (FOH) | Office 14b | Dining room 3/4
 | [NAME] office | Games Room | Office corridor | Dining room 5
 | [NAME]'s office | Bar entrance foyer |  | DR 5 corridor
 | PA's office
 | Personnel office
 | Trainers office
 | [NAME] office
 | Server room
Location Area | Location
3rd floor Admin area
Bar
Bar
Clasp offices
Dining
Spreadsheet: 764505d1642775125-extracting-text-from-a-string-email-extract
Sheet: Sheet1

Device name | Managed by | Ownership | Compliance | OS | OS version | Last check-in | Enrollment date | Primary user UPN
iPhone-FFMFF0NWPLJM | Intune | Corporate | Compliant | iOS/iPadOS | 15.2.1 | 2022-01-20 12:56:05.323000 | 2021-06-15 04:28:35.018000 | [EMAIL]
iPhone-C8RCF6QZN72J | Intune | Corporate | Compliant | iOS/iPadOS | 15.2.1 | 2022-01-20 17:56:32.201000 | 2020-08-26 17:05:33.880000 | [EMAIL]
aaron.delorme_AndroidEnterprise_11/1/2021_10:44 PM | Intune | Corporate | Compliant | Android (Fully Managed) | 11 | 2022-01-20 19:48:52.490000 | 2021-11-01 22:44:12.788000 | [EMAIL]
iPhone-FFMFG5MBPLJM | Intune | Corporate | Compliant | iOS/iPadOS | 15.2.1 | 2022-01-20 17:56:49.179000 | 2021-06-22 17:59:47.667000 | [EMAIL]
iPhone-FFNFRW10PLJM | Intune | Corporate | Compliant | iOS/iPadOS | 15.2.1 | 2022-01-20 18:56:29.027000 | 2021-07-08 18:18:40.569000 | [EMAIL]
[NAME].Lawrence_AndroidEnterprise_6/14/2021_8:01 PM | Intune | Corporate | Noncompliant | Android (Fully Managed) | 11 | 2022-01-20 14:00:59.032000 | 2021-06-14 20:01:30.403000 | [EMAIL]
aaron.moran_AndroidEnterprise_12/6/2021_1:44 PM | Intune | Corporate | Compliant | Android (Fully Managed) | 11 | 2022-01-20 20:02:36.913000 | 2021-12-06 13:44:55.427000 | [EMAIL]
Aarti.Dewan_AndroidForWork_4/21/2021_10:55 AM | Intune | Personal | Noncompliant | Android (Personally-Owned Work Profile) | 9 | 2022-01-09 01:11:24 | 2021-04-21 10:55:55 | [EMAIL]
iPhone-F71WD3KQHG7K | Intune | Corporate | Compliant | iOS/iPadOS | 15.2.1 | 2022-01-20 19:56:04.438000 | 2020-06-17 11:10:00.202000 | [EMAIL]
Spreadsheet: 74669d1275177816-find-most-frequent-minimum-value-and-return-the-name-frequency
Sheet: 5

 | Product |  |  |  | wastage
 | product1 |  |  |  | 12
 | product2 |  |  |  | 24
 | product3 |  |  |  | 26
 | product4 |  |  |  | 6
 | product5 |  |  |  | 35
 | product6 |  |  |  | 20
 | product7 |  |  |  | 12
 | product8 |  |  |  | 17
 | product9 |  |  |  | 14
 | product10 |  |  |  | 13
 | product11 |  |  |  | 8
 | product12 |  |  |  | 26
 | product13 |  |  |  | 24
 | product14 |  |  |  | 26
 | product15 |  |  |  | 20
 | product16 |  |  |  | 7
 | product17 |  |  |  | 11
 | product18 |  |  |  | 35
Spreadsheet: 872236d1718637358-help-with-doing-a-transpose-basicall-columns-combined-into-a-column-rows-become-column-sampleprofiledata
Sheet: Sheet1

What I have:
Profile | Object | Permission1 | Permission2 | Permission3 | Permission4 | Permission5
P1 | O1 | F | F | T | T | T
P1 | O2 | T | T | F | F | F
P2 | O1 | F | T | F | T | F
P3 | O3 | T | T | T | F | F
What I want:
 | P1 | P2 | P3
O1
Permission 1 | F | F
Permission 2 | F | T
Permission 3 | T | F
Permission 4 | T | T
Permission 5 | T | F
O2
Permission 1 | T
Permission 2 | T
Permission 3 | F
Permission 4 | F
Permission 5 | F
O3
Permission 1 |  |  | T
Permission 2 |  |  | T
Permission 3 |  |  | T
Permission 4 |  |  | F
Permission 5 |  |  | F
Spreadsheet: 676381d1588779866-detecting-schedule-conflicts-minimal-sample-shoefits-
Sheet: 4-David

 | Schedule for employee #: | 4
 |  |  |  |  |  |  |  |  | Conflict detection |  |  |  |  |  | contains the lowest Employee # besides me who is also scheduled
Customer # | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Day with first conflict
1 | 0 | 1 | 0 | 1 | 0 | 1 | 0
2 | 0 | 0 | 0 | 0 | 0 | 0 | 1
3 | 0 | 1 | 0 | 1 | 0 | 1 | 0
 |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Spreadsheet: sara_shackleton__36526__Legal Agreements Status
Sheet: Sheet1

Legal Agreement Status
Updated | 2001-03-05 00:00:00
Date | Type | Company | Broker | Requested by | Priority | Comments
2000-12-05 00:00:00 | Electronic Trading Agreement | ECT Investments | [NAME], LLC | [NAME] | HIGH | Under ENA review
2000-12-06 00:00:00 | Electronic Trading Agreement | ECT Investments | Merrill Lynch | [NAME] |  | Under ENA review
 | Electronic Trading Agreement | ECT Investments | Bear Stearns | [NAME] | HIGH | Negotiating
 | Electronic Trading Agreement | ECT Investments | JP Morgan | [NAME] | HIGH | Negotiating
 | Electronic Trading Agreement | ECT Investments | Salomon Smith Barney Inc | [NAME] | HIGH | Under ENA review
2000-05-19 00:00:00 | Executing Broker Agreement | ECT Investments | Frost Securities |  |  | Under ENA review
2000-06-01 00:00:00 | Executing Broker Agreement | ECT Investments | ING Barrings - Furman Selz |  |  | EXECUTED
2000-07-10 00:00:00 | Executing Broker Agreement | ECT Investments | Lehman Brothers |  |  | EXECUTED
2000-07-13 00:00:00 | Executing Broker Agreement | ECT Investments | Jefferies & Co |  |  | EXECUTED
2000-08-08 00:00:00 | Executing Broker Agreement | ECT Investments | Simmons & Co |  |  | Under broker's review
2000-08-31 00:00:00 | Executing Broker Agreement | ECT Investments | [NAME] |  | HIGH | Pending final draft from broker
2000-09-22 00:00:00 | Executing Broker Agreement | ECT Investments | Deutsche Bank Securities
2001-01-10 00:00:00 | Executing Broker Agreement | ECT Investments | ITG |  |  | EXECUTED
 | Executing Broker Agreement | ECT Investments | [NAME] |  |  | Pending final draft from broker
 | Executing Broker Agreement | ECT Investments | Salomon Smith Barney Inc |  |  | EXECUTED
 | Options [NAME] | ECT Investments | Goldman Sachs |  |  | Under review
2001-01-09 00:00:00 | Letter of Guarantee | ENA | Bear Stearns | [NAME] |  | EXECUTED
2001-01-17 00:00:00 | Stock Loan Agreement | ENA | Bear Stearns | [NAME] |  | EXECUTED
2001-02-12 00:00:00 | Futures Clearing | ENA | jp morgan chase futures agree | Hickerson | HIGH | Negotiated (SS)
2001-02-13 00:00:00 | On-line trading | ENA | Goldman Sachs | Delage |  | [NAME] covered under ENA already
2001-02-13 00:00:00 | On-line trading | ENA | UBS TP trader, I-dealer, website | Delage |  | Jurgen has in London, extend to DD, [NAME], 1/[PHONE]
TBD - 2/13/01 | Futures Clearing | ENA | [NAME] | Hickerson |  | To be received over next few weeks,
 | Custody agreement | ena | Chase Bond Custody Account | Shahi/Adams |  | Negotiating
Spreadsheet: 117065d1312414825-vlookup-multiple-tables-786864-vlookup-multiple-tables-test-file
Sheet: Sales information

Address Number | Street | zCode | SalePrice | Sale Date
834 | 22ND ST | 10111 | 249800 | 2007-06-12 00:00:00
1480 | 24TH ST | 10111 | 208800 | 2007-04-07 00:00:00
1480 | 26TH ST | 10111 | 178800 | 2007-06-12 00:00:00
2080 | 26TH ST | 10111 | 288888 | 2007-07-17 00:00:00
120 | 28TH ST | 10111 | 1080000 | 2006-11-01 00:00:00
1890 | 29TH ST | 10111 | 299500 | 2007-07-05 00:00:00
Spreadsheet: 859094d1707548797-looking-for-non-array-formula-to-do-sequential-numbering-based-on-value-on-b1-sequential-numbering_sample
Sheet: HERE

Select Value | 8
 | Row Format |  | Column Format
Desired Outcome | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
Spreadsheet: 536d4224-37d0-42e8-85a7-80739b40642c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: U.S. International Trade in Goods and Services
 |  | Balance of Payment Goods and Services: United States
 |  | Seasonally Adjusted Balance [Millions of Dollars]
 |  | Period: 1992 to 2012
 |  | Data Extracted on: July 31, 2014 (10:13 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
1992 | -2026 | -831 | -2641 | -3109 | -3919 | -2824 | -2781 | -4455 | -3530 | -3520 | -3968 | -5603
1993 | -3871 | -3596 | -6777 | -6445 | -4369 | -6929 | -6382 | -5581 | -7031 | -6594 | -7016 | -5719
1994 | -6207 | -9245 | -6466 | -7887 | -7728 | -8380 | -8739 | -8303 | -8310 | -9158 | -9615 | -8456
1995 | -9324 | -8817 | -9708 | -9609 | -9090 | -10623 | -7688 | -6704 | -5924 | -6114 | -6514 | -6271
1996 | -8465 | -7319 | -7756 | -8744 | -9259 | -7460 | -10132 | -10357 | -10195 | -6635 | -7268 | -10475
1997 | -11269 | -9776 | -8383 | -8086 | -8394 | -7154 | -7033 | -8743 | -9269 | -9089 | -9786 | -11289
1998 | -10776 | -11564 | -12880 | -13940 | -14202 | -13247 | -13949 | -16028 | -14820 | -14815 | -15173 | -14745
1999 | -15946 | -18786 | -17900 | -18254 | -20229 | -23115 | -23421 | -22977 | -22899 | -23531 | -25224 | -26337
2000 | -27088 | -29930 | -31154 | -28800 | -29813 | -30966 | -31426 | -30035 | -34018 | -33224 | -32607 | -33454
2001 | -34817 | -29349 | -32732 | -31217 | -27446 | -29140 | -30081 | -28171 | -31141 | -30839 | -29737 | -26839
2002 | -29355 | -32287 | -30825 | -33666 | -33921 | -34900 | -33650 | -35743 | -36519 | -35171 | -39624 | -43294
2003 | -40740 | -39363 | -43355 | -41987 | -40779 | -39621 | -41363 | -39802 | -41706 | -41271 | -39841 | -44064
2004 | -44352 | -44322 | -46484 | -47479 | -48169 | -54702 | -51293 | -53316 | -51489 | -54961 | -58819 | -54500
2005 | -55561 | -57454 | -52619 | -57115 | -56264 | -58260 | -58063 | -58388 | -64923 | -67140 | -64090 | -64366
2006 | -66680 | -62851 | -62574 | -62844 | -64844 | -63481 | -66525 | -67823 | -64936 | -58990 | -58575 | -61592
2007 | -57656 | -58478 | -61797 | -60514 | -59288 | -59520 | -59914 | -57005 | -57794 | -56538 | -59717 | -57154
2008 | -61139 | -64348 | -60064 | -63528 | -62151 | -60670 | -66842 | -62108 | -60499 | -60191 | -44724 | -42463
2009 | -37842 | -27767 | -29162 | -29705 | -25372 | -26367 | -32790 | -31267 | -34491 | -33826 | -37203 | -37983
2010 | -37154 | -41034 | -39766 | -40864 | -41333 | -46557 | -40413 | -44921 | -44042 | -39998 | -37762 | -40815
2011 | -47123 | -43718 | -43478 | -42227 | -47220 | -49433 | -45689 | -44968 | -43305 | -44962 | -47044 | -49460
2012 | -51266 | -43338 | -49850 | -47773 | -47184 | -43078 | -43834 | -44536 | -40150 | -42358 | -46604 | -37634
Spreadsheet: 672874d1587051255-sumif-font-color-or-dont-sum-if-condition-map1
Sheet: Blad1

 |  |  |  | 1. | Hey there, I have conditional formatting for the font color on C10:C23, so the values are there but not visible
 |  |  |  | 2. | The conditional formatting says =B9=B10, because I dont want the costs for duplicate job titles to show
 |  |  |  | 3. | Now i want to sum the values in C10:C23 that have black text (so no conditional formatting)
 | Begrote formatie | [NAME] | Verschil | 4. | There probably is an easier way to do this without summing up if conditional formatting but instead based on column B, but I have no idea how to do it
 |  | 426553.92 |  | 5. | The idea is: if B10=B11, Dont add C11 to the sum, if B11=B12 dont add C12 to the sum, etc.
Functie | [NAME]. per formpl. | Begr. per medew.
Adviseur I | 46278.24000000001 | 46278.24000000001
[NAME] | 54115.56 | 608.04
[NAME] | 54115.56 | 46527.36
[NAME] | 26436 | 52872
[NAME] | 26436 | -26436
Medewerker administratief & secretarieel III | 22881.84 | 22881.84
Medewerker ontwikkeling I | 129840 | 64920
Medewerker ontwikkeling I | 129840 | 64920
Medewerker ontwikkeling II | 40738.68000000001 | 40738.68000000001
Projectleider II | 187618.8 | 64920
Projectleider II | 187618.8 | 51733.92
Projectleider II | 187618.8 | 64919.99999999999
Projectleider II (T) | 64920 | 57778.8
Projectleider II (T) | 64920 | 7141.200000000001
Spreadsheet: 728834d1618685680-not-sure-how-to-get-this-conditional-formatting-to-work-wine-list-etaf
Sheet: Sheet2

Star |  |  | Variety | Start | End |  |  | Year
« |  |  | Beaujolais | 3 | 5 |  |  | 2006 |  | Red |  | US |  | Napa |  |  | Row | Column
«« |  |  | Bordeaux Red | 7 | 15 |  |  | 2007 |  | White |  | France |  | Sonoma |  | A | 1 | 1
««« |  |  | [NAME] | 7 | 15 |  |  | 2008 |  | Rouse |  | New Zeland |  | [NAME] |  | B | 2 | 2
«««« |  |  | Merlot | 5 | 12 |  |  | 2009 |  | Sparkling |  | Australia |  | Russian River |  | C | 3 | 3
««««« |  |  | Pinot Noir | 2 | 5 |  |  | 2010 |  |  |  | Argentina |  | Oregon |  |  | 4 | 4
 |  |  | [NAME] | 3 | 5 |  |  | 2011 |  |  |  | Germany |  | Boudeaux |  |  |  | 5
 |  |  | White Wines | 3 | 5 |  |  | 2012 |  |  |  | South Africa |  | Tuscany
 |  |  | Chardonnay | 4 | 8 |  |  | 2013 |  |  |  |  |  | Chateau de Pape
 |  |  | [NAME] | 3 | 5 |  |  | 2014 |  |  |  |  |  | Rhine River
 |  |  | Riesling | 6 | 8 |  |  | 2015
 |  |  | Sauvignon Blanc | 1 | 2 |  |  | 2016
 |  |  | Pinot Gris | 1 | 2 |  |  | 2017
 |  |  | Champagne | 4 | 10 |  |  | 2018
 |  |  |  |  |  |  |  | 2019
 |  |  |  |  |  |  |  | 2020
 |  |  |  |  |  |  |  | 2021
 |  |  |  |  |  |  |  | 2022
 |  |  |  |  |  |  |  | 2023
 |  |  |  |  |  |  |  | 2024
 |  |  |  |  |  |  |  | 2025
 |  |  |  |  |  |  |  | 2026
Spreadsheet: 169507d1342903556-compare-records-of-two-tables-multiple-criteria-include-blanks-2012-07-21-demo-filters
Sheet: Priority

 | Var1 | Var2 | Date Begin | Date End | Filter | Result
IF( | Match | Match | <=@Date | >=@Date | >@Cost | 1
IF(OR( | Match | Match | <=@Date | Blank | >@Cost | 1
, | Match | Match | Blank | >=@Date | >@Cost | 1
, | Match | Match | Blank | Blank | >@Cost | 1
IF( | Match | Blank | <=@Date | >=@Date | >@Cost | 1
IF(OR( | Match | Blank | <=@Date | Blank | >@Cost | 1
, | Match | Blank | Blank | >=@Date | >@Cost | 1
, | Match | Blank | Blank | Blank | >@Cost | 1
IF( | Blank | Match | <=@Date | >=@Date | >@Cost | 1
IF(OR( | Blank | Match | <=@Date | Blank | >@Cost | 1
, | Blank | Match | Blank | >=@Date | >@Cost | 1
, | Blank | Match | Blank | Blank | >@Cost | 1
IF( | Blank | Blank | <=@Date | >=@Date | >@Cost | 1
IF(OR( | Blank | Blank | <=@Date | Blank | >@Cost | 1
, | Blank | Blank | Blank | >=@Date | >@Cost | 1
, | Blank | Blank | Blank | Blank | >@Cost | 1
IF( | Match | Match | <=@Date | >=@Date | <@Cost | 1
IF(OR( | Match | Match | <=@Date | Blank | <@Cost | 0
, | Match | Match | Blank | >=@Date | <@Cost | 0
, | Match | Match | Blank | Blank | <@Cost | 0
IF( | Match | Blank | <=@Date | >=@Date | <@Cost | 0
IF(OR( | Match | Blank | <=@Date | Blank | <@Cost | 0
, | Match | Blank | Blank | >=@Date | <@Cost | 0
, | Match | Blank | Blank | Blank | <@Cost | 0
IF( | Blank | Match | <=@Date | >=@Date | <@Cost | 0
IF(OR( | Blank | Match | <=@Date | Blank | <@Cost | 0
, | Blank | Match | Blank | >=@Date | <@Cost | 0
, | Blank | Match | Blank | Blank | <@Cost | 0
IF( | Blank | Blank | <=@Date | >=@Date | <@Cost | 0
IF(OR( | Blank | Blank | <=@Date | Blank | <@Cost | 0
, | Blank | Blank | Blank | >=@Date | <@Cost | 0
, | Blank | Blank | Blank | Blank | <@Cost | 0
IF( | Blank | Blank | Blank | Blank | Blank | 0
Spreadsheet: kate_symes__18906__SP 15 pages
Sheet: DJ SP15

 |  |  | Firm | Volume | Firm | Volume | Sun & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-03-22 00:00:00 |  | 279.47 | 27312 | 173.78 | 5920
 | 2001-03-21 00:00:00 |  | 395 | 15200 | 222.02 | 8392
 | 2001-03-20 00:00:00 |  | 379.17 | 18400 | 211.59 | 9640
 | 2001-03-19 00:00:00 |  | 313.9 | 18736 | 207.5 | 11648
 | 2001-03-18 00:00:00 |  |  |  |  |  | 196.24 | 29832
 | 2001-03-17 00:00:00 |  | 205.5 | 18592 | 148.56 | 7024
 | 2001-03-16 00:00:00 |  | 205.98 | 17600 | 148.56 | 7024
 | 2001-03-15 00:00:00 |  | 184.07 | 20192 | 129.29 | 6440
 | 2001-03-14 00:00:00 |  | 169.24 | 16576 | 110.08 | 7280
 | 2001-03-13 00:00:00 |  | 170.67 | 19648 | 104.69 | 3840
 | 2001-03-12 00:00:00 |  | 183.93 | 23040 | 107.19 | 6880
 | 2001-03-11 00:00:00 |  |  |  |  |  | 107.67 | 17640
 | 2001-03-10 00:00:00 |  | 156.73 | 17840 | 98.45 | 6040
 | 2001-03-09 00:00:00 |  | 157.31 | 16960 | 98.45 | 6040
 | 2001-03-08 00:00:00 |  | 213.95 | 22880 | 131.78 | 6600
 | 2001-03-07 00:00:00 |  | 313.92 | 24048 | 201.19 | 6080
 | 2001-03-06 00:00:00 |  | 339.12 | 29856 | 231.76 | 7080
 | 2001-03-05 00:00:00 |  | 299.82 | 13200 | 217.92 | 3080
 | 2001-03-04 00:00:00 |  |  |  |  |  | 217.92 | 9240
 | 2001-03-03 00:00:00 |  | 248.15 | 15920 | 165.24 | 2720
 | 2001-03-02 00:00:00 |  | 248.24 | 16400 | 165.07 | 3320
 | 2001-03-01 00:00:00 |  | 264.44 | 17648 | 164.24 | 7520
 | 2001-02-28 00:00:00 |  | 181.23 | 21200 | 120.65 | 4728
 | 2001-02-27 00:00:00 |  | 185.42 | 15344 | 116.58 | 2800
 | 2001-02-26 00:00:00 |  | 193.48 | 13840 | 132.88 | 4800
 | 2001-02-25 00:00:00 |  |  |  |  |  | 132.88 | 14400
 | 2001-02-24 00:00:00 |  | 177.7 | 16000 | 131.62 | 11200
 | 2001-02-23 00:00:00 |  | 179.36 | 17040 | 131.62 | 11200
 | 2001-02-22 00:00:00 |  | 229.75 | 23200 | 149.39 | 6448
 | 2001-02-21 00:00:00 |  | 236.72 | 25840 | 160.28 | 7840
 | 2001-02-20 00:00:00 |  | 262.61 | 9200 | 190 | 5200
Spreadsheet: 188089d1350672882-matching-two-columns-of-data-in-two-different-worksheets-dummy-worksheet
Sheet: Daily Bond Log

Daily Bond Log
Date | Agency Name | Case  # | [NAME] | Check # | Cash | Amount | Dist. To | Posted By | Rcptd | frwrd
2012-10-15 00:00:00 | County Sheriffs Office | 1233533A | [NAME] | 6184 |  | 250 | [NAME] | self | X
 | County Sheriffs Office | 10-20880 | [NAME] |  | x | 202 | clerk2 | self
 | County Sheriffs Office | 10-20880 | [NAME] | surety |  | 0 | clerk3 | Acme Bail Bonds
 | County Sheriffs Office |  | [NAME] |  | x | 150 | clerk3 | [NAME]
 | County Sheriffs Office | 12-25260 | [NAME] |  | x | 250 | clerk4 | [NAME]
 | County Sheriffs Office |  | [NAME] |  | x | 350 | clerk5 | [NAME]
 | County Sheriffs Office | 12-25259 | Rita Doe | 2598672 |  | 350 | [NAME] | [NAME]
 | County Sheriffs Office |  | [NAME] |  | x | 350 | clerk3 | [NAME] cole
2012-10-16 00:00:00 | County Sheriffs Office | 12-25254 | [NAME] |  | x | 350 | clerk4 | self
 | State police | 12-25218 | [NAME] | 756 |  | 350 | [NAME] | self
 | state police | 12-25275 | [NAME] |  | x | 500 | [NAME] | self
Spreadsheet: 715129d1611580504-combined-if-statements-football-example-formula-help
Sheet: Sheet1

 | 2
 | Win %
 |  |  |  | 1.3 | 1.7 | 2.9
Score @60' | Score @ FT | Trade Result | Goal Time | 61'+ (1.4+) | 71'+ (1.8+) | 81'+ (2.8+) | Implied Return
1-1 | 2-2 | W | 66 | 1
0-0 | 0-1 | W | 81 | 1 | 1
0-0 | 0-0 | L |  | 0 | 0 | 0
1-1 | 3-1 | W | 66 | 1
2-2 | 4-2 | W | 73 | 1 | 1
1-1 | 1-1 | L |  | 0 | 0 | 0
1-1 | 2-1 | W | 69 | 1
2-2 | 3-3 | W | 68 | 1
0-0 | 0-0 | L |  | 0 | 0 | 0
0-0 | 2-1 | W | 68 | 1
0-0 | 0-1 | W | 72 | 1 | 1
Spreadsheet: 82586d1282654116-fill-a-cell-based-on-3-inputs-that-correspond-to-multiple-data-tables-crew-manning-example
Sheet: Go Transit

 | POB | 0 - 12 | 13 - 18 | 19 - 30 | 31 - 40 | 41 - 50 | 51 - 60 | 61 - 70 | 71 - 85 | 86 - 95 | 96 + |  | OPERATIONAL MANNING COSTS
 | Master |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  | Pre-EBA | Post-EBA
 | Chief Mate / First Officer |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |  | Valid To | 2009-12-31 00:00:00 | 2010-06-30 00:00:00 | 2010-06-30 00:00:00
 | Second Mate |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | Native Currency | AUD | AUD | AUD
 | Chief Engineer |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | Master
 | First Engineer |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | Chief Mate / First Officer
 | Second Engineer |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |  | Second Mate
 | Electrician |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | Chief Engineer
 | Chief Integrated Rating ([NAME]) |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | First Engineer
 | Integrated Rating |  |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 |  | Second Engineer
 | Crane Operator |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | Electrician
 | Chief Caterer |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | Chief Integrated Rating ([NAME])
 | Chief [NAME] |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | Integrated Rating
 | [NAME] |  |  | 1 | 1 | 1 | 2 | 2 | 3 | 3 | 3 |  | Crane Operator
 | Caterer ([NAME]) |  |  | 0 | 1 | 2 | 2 | 3 | 3 | 4 | 5 |  | Chief Caterer
 | Total Manning |  |  |  |  |  |  |  |  |  |  |  | Chief [NAME]
 | Total Cost Up To 31-Dec-09 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Total Cost Up To 30-Jun-10 pre-EBA |  |  |  |  |  |  |  |  |  |  |  | Caterer ([NAME])
 | Total Cost Up To 6-Sep-10 pre-EBA
 | Total Cost Up To 30-Jun-11 post-EBA
 | Total Cost Up To 30-Jun-12 post-EBA