tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 861154d1709117798-adding-countif-formula-is-there-a-better-way-excel-help
Sheet: Order of Merit

 |  | Cotswold | Caddington | Little Hay | Stanmore | Forest of Dean | Five Lakes | Silverstone | [NAME] | Cainhoe Woods | Batchwood Park
No | MEMBER | ReUnion | Pairs | [NAME] | Memorial | Weekender | Essex | Northants | European | Beds | Last Chance | Masters | Singles | TOTAL | WINS | Helper | Rank
1 | ADAMS. [NAME] | 5 | 3 | 4 | 2
2 | ADAMS. [NAME] | 4 | 4 | 4 | 2
3 | BATTERBEE. [NAME] | 1 | 1 | 5 | 1
4 | BAXTER. [NAME]
5 | BENNETT. [NAME]
6 | BROMLEY. [NAME]
7 | CURT. [NAME]
8 | CURT. Sean
9 | DAVEY. [NAME]
10 | DERBYSHIRE. [NAME]
11 | DONNELLY. [NAME]
12 | DOWNER. [NAME]
13 | FORDE. [NAME]
14 | GARVEY. [NAME]
15 | GELLMAN. [NAME]
16 | GIBOIN. [NAME]
17 | GROUT. [NAME]
18 | HARVEY. [NAME]
19 | HIMSWORTH. [NAME]
20 | HODGES. [NAME]
21 | JUN. [NAME]
22 | KIDD. [NAME]
23 | KNOTT. [NAME]
24 | KOLEK. Darren
25 | KOLEK. [NAME]
26 | LEADBETTER. [NAME]
27 | LEECH. [NAME]
28 | LEECH. [NAME]
29 | LEONARD. [NAME]
30 | LEWIS. [NAME]
31 | LOOM. Scott
32 | MANKTELOW. Trevor
33 | MARVESLEY. [NAME]
34 | MCGILLIVRAY. [NAME]
35 | MCKENZIE. [NAME]
36 | MITCHELL. [NAME]
37 | MOSS. [NAME]
38 | MUNTING. [NAME]
39 | PEARCE. [NAME]
40 | PEARCE. [NAME]
41 | PYM. [NAME]
42 | SMITH. [NAME]
43 | SMITH. [NAME]
44 | TAYLOR. [NAME]
45 | THORPE. [NAME]
46 | VALENTINE. [NAME]
47 | VANN. Martin
48 | [NAME]. [NAME]
49 | WILLS. Stuart
 | Highest Score
Spreadsheet: 692634d1598470513-formula-to-evaluate-two-criteria-and-pull-data-if-both-met-scheduling-dummy-file
Sheet: Meal Delivery Labor

Meal Delivery Labor per Meal Period
Delivered Meals | Labor in Minutes | Total Labor Hours | Double Occupancy | Staffing Needs
0-5 | 15 |  |  | One team member to handle: 1 meal/snack/beverage cart
6-10 | 30
11-15 | 45
16-20 | 120 |  |  | Two team members to handle:  1 meal/snack cart and 1 beverage cart
21-25 | 150
26-30 | 180
31-35 | 210
36-40 | 240
41-45 | 270
45-50 | 300 |  |  | Four team members to handle:  2 meal/snack carts and 2 beverage carts
51-55 | 330
56-60 | 360
61-65 | 390
66-70 | 420
71-75 | 450
76-80 | 480
81-85 | 510 |  |  | Six team members to handle: 3 meal/snack carts and 3 beverage carts
86-90 | 540
91-95 | 570
96-100 | 600
101-105 | 630
106-110 | 660
111-115 | 690
116-120 | 720
121-125 | 750
126-128 | 780
Spreadsheet: 2e417cdd-9f1c-42e2-9e69-6549a73a242e
Sheet: 60 M+,M

ISA SENIOR WORLD
COLUMBUS, IN
JULY 26-27-28, 2013
 | MEN'S 60 MAJOR+ & 60 MAJOR DIVISION
 |  |  |  |  |  | WON |  | LOSS
1.  Line Drive Salsa Bombers |  |  |  |  |  | I |  | I
2.  Jim & Joe's Ice |  |  |  |  |  |  |  | II
3.  Handeland Flooring, M |  |  |  |  |  | III
4.  Michigan Express, M |  |  |  |  |  | II |  | I
5.  [NAME], M |  |  |  |  |  |  |  | II
Friday, July 26 - ALL GAMES AT LINCOLN PARK
TIME |  | RUNS |  | TEAM# |  | RUNS |  | DIA. #
10:30AM |  | 18 |  | 1 v 3 |  | 23 |  | #4
10:30am |  | 14 |  | 5 v 4 |  | 20 |  | #3
Noon |  | 26 |  | 1 v 5 |  | 24 |  | #3
Noon |  | 13 |  | 2 v 3 |  | 22 |  | #5
1:30pm |  | 20 |  | 3 v 4 |  | 14 |  | #5
3pm |  | 18 |  | 2 v 4 |  | 20 |  | #5
Saturday, July 27 - All games at Dunn Sports Complex
Time |  | RUNS |  | Team # |  | RUNS |  | [NAME]. #
8am |  | X |  | 1 v 4 |  | X |  | #1
8am |  | X |  | 2 v 5 |  | X |  | #2
NOTE: TEAM #1 & #2 PLAY HEADS UP.
TEAM #1 & #2 GIVE 5 RUNS OR 11 DEFENSIVE PLAYERS TO TEAMS 3, 4, & 5
[NAME]: | ALL TEAMS WILL PLAY 3 SEED GAMES.
 | Team #1-#2 will play best 2 out of 3.  Teams 3, 4, & 5 will seed into a double elimination bracket.
HOME RUN RULE - Major + is 9 per game , then walks.  Major is 6 per game then walks
 | When M+ is playing M - then you play by the Major rule.
RUN RULE-Major  5 RUNS PER 1/2 INNING + OPEN INNING. Major + 7 runs per inning
TIME LIMITS - SEED GAMES 65 MIN. + OPEN INNING - BRACKET PLAY 70 MIN.+ OPEN
 |  | CHAMPIONSHIP GAME IS 7 INNINGS
[NAME] FLIP
ROSTER IS SUBJECT TO APPROVAL OF SSUSA
YOU MUST WIN YOUR DIVISION TO RECEIVE THE SSUSA TOC BERTH
Spreadsheet: jeff_dasovich__14043__COS & Rates Workpapers for GA II 12-20-2000 Proposal
Sheet: Table of Contents

GAS ACCORD II PROPOSAL DATED 12-20-00
TABLE OF CONTENTS-COS & RATES WORKPAPERS
TAB |  | [NAME] |  | # of Pages
COS Totals |  | Annual COS By Asset Grouping (2003-2007) |  | 3
CAPEX |  | Annual Plant Additions to COS |  | 1
CAPEX Summary |  | Forecasted Capital Expenditures by Major Category |  | 1
2003 Base RO |  | Year 2003 Cost of Service |  | 1
Inflation |  | Escalation Factors for O&M, A&G and CAPEX |  | 1
Annual&WAVG & Addns&Retire |  | Additions and Retirements (2000-2003) |  | 1
wavg plant balances |  | Plant Balances 1999-2003 |  | 1
O&M Expense By UCC |  | O&M Expenses |  | 7
O&M Summary |  | O&M Expenses |  | 1
O&M Details |  | O&M Expenses |  | 8
Cost Rate Summary |  | Rates Summary |  | 1
Spreadsheet: jonathan_mckay__16935__New world
Sheet: Sheet1

New World Products
 | Transco ZN 6 | Tetco M 3 | Dominion | TCO | Col Gulf | [NAME] | [NAME] | Hhub | Sonat la | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Tgt- Sl | [NAME]
Term | Basis | Basis | Basis | Basis | Basis | Gas Daily | Basis | Basis | Basis | Basis | Basis | Basis | Basis | Basis | Basis | Basis
Financial ROM | Yes | Yes |  | Yes | Yes | Yes
First 15days |  |  |  | Yes | Yes | Yes
Last 15days |  |  |  | Yes | Yes | Yes
Jan | Yes | Yes | Yes | Yes | Yes |  | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
Feb | Yes | Yes | Yes | Yes | Yes |  | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
Mar | Yes | Yes | Yes | Yes | Yes |  | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
Jan-Mar | Yes | Yes | Yes | Yes | Yes |  | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
Apr02-Oct02 | Yes | Yes | Yes | Yes | Yes |  | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
Nov02-Mar03 | Yes | Yes | Yes | Yes | Yes |  | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
Apr03-Oct03 | Yes | Yes | Yes | Yes | Yes |  | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
Spreadsheet: 2f237176-33f4-4cd6-9f8a-a04202046515
Sheet: Sheet1

Management Information Systems University Students Survey 2-16-12 | Management Information Systems University Students Survey 2-16-12.1 | Management Information Systems University Students Survey 2-16-12.2 | Management Information Systems University Students Survey 2-16-12.3
I am a current four-year college/university student. | I am a current four-year college/university student. | I am a current four-year college/university student. | I am a current four-year college/university student.
Answer Options | Answer Options | Response Percent | Response Count
Yes | Yes | 0.9 | 18
No | No | 0.1 | 2
answered question | answered question | 20 | 20
skipped question | skipped question | 0 | 0
Spreadsheet: joe_parks__14559__Enron Quotes 02-13-02 Morning
Sheet: Sheet1

 |  |  |  |  |  |  | CENTRAL BASIS QUOTES
 |  |  | Feb-Mar | Apr-Oct2 | Nov-Mar3 | Apr-Oct3 | Nov03 | [NAME] | Nov05 | Nov06 | Nov07 | Nov08
 | [NAME] | ML7
 | [NAME] | Consumers
 | [NAME] | Dawn
 | [NAME] | Parkway
 | [NAME] | [NAME]
 | NGI | Chicago | .015 @ .02 | .025@ .035 | .1175 @  .1225 | .0425 @ .0475 | .075@.0825 | .07@ .08 | .07 @ .08 | .065@ .075 | .065@ .075 | .065@ .075
 | GDM | Mich | .0525 @ .0625 | .0675 @ .0725 | .13@ .1425 | .115 @ .1225 | .1225 @ .13 | .105 @ .115 | .1075 @ .1175 | .1075 @ .1175 | .1075 @ .1175 | .1075 @ .1175
 | IF | Panhandle | -.10  @- .09 | -.115 @ -.11 | -.125 @ -.12 | [NAME] | -.1375 @ -.13 | -.1375 @ -.1325
 | IF | Midcontinent | -.1525 @ -.145 | [NAME] | -.1525 @ -.1425 | -.16 @ -.1525 | -.16 @ -.1525 | -.16  @ -.1525 | -.16  @ -.1525 | -.155  @ -.145 | -.155  @ -.145 | -.155  @ -.145
 | IF | ANR SW | -.1075  @- .095 | -.115  @ -.1125 | -.125@ -.12
 | IF | [NAME] | -.0725  @ -.065 | -.0925 @ -.085 | [NAME] | -.095 @ -.08
 | IF | Vent | -.055  @ -.0525 | -.0925 @ -.085 | [NAME].015
 | IF | ANR LA | -.085 @ -.08 | -.08 @ -.075 | -.085 @ -.08 | -.11 @ -.095
 | IF | NGPL/LA | -.085 @ -.08 | -.065 @ -.06 | -.0775 @ -.0725
 | IF | TRKL/LA | -.09 @ -.0825 | -.085 @ -.0775 | -.095 @ -.085 | -.09 @ -.085 | -.095 @ -.085 | -.095 @ -.085
Spreadsheet: 748643d1632256801-help-with-possible-sum-countif-formula-excel-query
Sheet: Sheet1

Location | Employee |  | Desired Summary |  |  | Location | Count
CCS | Carmel |  | CCS | 1 |  | CCS | 1
CCS | Carmel |  | EPUT | 3 |  | EPUT | 3
CCS | Carmel |  | ESHT | 1 |  | ESHT | 1
EPUT | Samed |  | LNW | 1 |  | LNW | 1
EPUT | [NAME] |  | SPFT | 4 |  | SPFT | 4
EPUT | [NAME] |  | STH | 1 |  | STH | 1
EPUT | [NAME]
EPUT | [NAME]
ESHT | Chizzy
ESHT | Chizzy
LNW | Angie
LNW | Angie
LNW | Angie
LNW | Angie
SPFT | Adey
SPFT | Adey
SPFT | BabaO
SPFT | BabaO
SPFT | BabaO
SPFT | [NAME]
SPFT | [NAME]
SPFT | Chizzy
SPFT | Chizzy
SPFT | Chizzy
SPFT | Chizzy
STH | Claudia
Spreadsheet: 822914d1679589549-retrieving-value-from-adjacent-table-based-on-value-within-table-eflookup
Sheet: Sheet1

Airline | To | Sched. |  | Airline | To | To2 | First Flight | Last Flight
American Airlines | Doha | 11:00:00 |  | American Airlines
American Airlines | [NAME] | 11:10:00
American Airlines | Miami, FL | 11:15:00
American Airlines | Indianapolis, IN | 11:15:00 |  |  | Doha | West Palm Beach, FL
American Airlines | London | 11:20:00
American Airlines | Columbus, OH | 12:00:00
American Airlines | Cleveland, OH | 12:00:00
American Airlines | Boston, MA | 12:05:00 |  |  | 11:20 AM
American Airlines | Worcester, [NAME] | 12:10:00
American Airlines | Boston, MA | 12:10:00
American Airlines | Norfolk, VA | 12:20:00
American Airlines | Jacksonville, FL | 12:20:00
American Airlines | Salt Lake City, UT | 12:27:00
American Airlines | Orlando, FL | 12:30:00
American Airlines | Miami, FL | 12:37:00
American Airlines | West Palm Beach, FL | 12:40:00
American Airlines | [NAME] | 12:41:00
American Airlines | Boston, MA | 13:05:00
American Airlines | Orlando, FL | 13:14:00
American Airlines | Boston, MA | 13:20:00
American Airlines | Tampa, FL | 13:28:00
American Airlines | Syracuse, NY | 13:30:00
American Airlines | San Francisco, CA | 13:30:00
American Airlines | Miami, FL | 13:40:00
American Airlines | Atlanta, GA | 13:40:00
American Airlines | Burlington, VT | 13:44:00
American Airlines | Buffalo, NY | 13:44:00
American Airlines | San Antonio, TX | 13:45:00
American Airlines | Tokyo | 13:45:00
American Airlines | Phoenix, AZ | 13:55:00
American Airlines | West Palm Beach, FL | 14:00:00
Spreadsheet: 34932d1232390524-recognizing-counting-and-displaying-duplicates-gymmembernumbers
Sheet: Duplicate Checking

Duplicates by Week
Week 1 |  | Week 2 |  | Week 3
1531 | 4 | List duplicate address numbers from each week here | List how many times the number was duplicated in the week | 1531 | 4
151 | 4 |  |  | 151 | 4
235 | 4 |  |  | 235 | 4
1584 | 4 |  |  | 1584 | 4
1835 | 4 |  |  | 1835 | 4
1864 | 4 |  |  | 1864 | 4
8484 | 4 |  |  | 8484 | 4
6843 | 4 |  |  | 6843 | 4
1843 | 4 |  |  | 1843 | 4
1834 | 4 |  |  | 1834 | 4
248 | 4 |  |  | 248 | 4
1514 | 4 |  |  | 1514 | 4
154 | 4 |  |  | 154 | 4
354 | 4 |  |  | 354 | 4
236 | 4 |  |  | 236 | 4
1585 | 4 |  |  | 1585 | 4
1837 | 4 |  |  | 1837 | 4
1846 | 4 |  |  | 1846 | 4
2183 | 4 |  |  | 2183 | 4
2481 | 4 |  |  | 2481 | 4
1848 | 4 |  |  | 1848 | 4
3544 | 4 |  |  | 3544 | 4
4842 | 4 |  |  | 4842 | 4
2468 | 4 |  |  | 2468 | 4
Spreadsheet: 83982d1283992874-adding-future-numbers-leave
Sheet: Sheet1

 |  |  | 2010-09-10 00:00:00
Name | Annual Leave | [NAME] | Remaining Days |  | 2010-09-10 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
 |  |  |  |  | 5.41 | 1.66 | 1.66 | 1.66 | 1.66
 |  |  |  |  | 5.62 | 1.66 | 1.66 | 1.66 | 1.66
 |  |  |  |  | 18.79 | 1.66 | 1.66 | 1.66 | 1.66
 |  |  |  |  | 0 | 1.66 | 1.66 | 1.66 | 1.66
Spreadsheet: 122548d1316957606-excel-2007-export-selection-as-a-windows-dos-bat-file-_copy
Sheet: COPY

SOURCE FILE PATH | SOURCE FILENAME | SOURCE FILE EXTENSION | DESTINATION FILE PATH
C:\ | test123 | .xls | G:\All Excel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xcopy " | " " | " /e/s/h/i/y
D:\Excel | test456 | .xls | G:\All Excel
E:\Excel | test789 | .xls | G:\All Excel
C:\ | test1011 | .xls | G:\All Excel
C:\ | test1213 | .xls | G:\All Excel
C:\ | test1415 | .xls | G:\All Excel
 |  |  |  |  |  | Export selection to a bat file with the macro assigned to the above button
Spreadsheet: 846567d1697721734-lookup-multiple-values-and-sum-sample
Sheet: Variance

 |  |  |  | Once variance pasted in, Press CTRL+Z to auto move minus sign
 |  |  | Process [NAME] report
 |  | Material No. or Activity Type ID | Description | Backflushed Material | Actual Usage (Qty) | Designed 0L MR Usage (Qty) | D0L Master Recipe UVar incl DUV Qty | UOM | D0L MR UVar incl DUV % | Zero Loss UVar excl DUV Val | Currency
 |  | 105009205 |  |  | 0 | -0.022 | -0.022 | KG | 100 | -0.1 | GBP
 |  | 43360459 |  |  | 74.9 | 74.172 | -0.728 | KG | -0.99 | -0.19 | GBP
 |  | 43451249 |  |  | 5829 | 5844.319 | 15.319 | KG | 0.26 | 65.7 | GBP
 |  | 43762126 |  |  | 35 | 35 | 0 | EA | 0 | 0 | GBP
 |  | 43961481 | variant a of the same type of material |  | 0 | 21.815 | 21.815 | KG | 100 | 72.04 | GBP
 |  | 43966143 | variant b of the same type of material |  | 12546 | 12465.262 | -80.738 | KG | -0.65 | -253.07 | GBP
 |  | 44015770 | variant c of the same type of material |  | 0 | 21.815 | 21.815 | KG | 100 | 71.77 | GBP
 |  | 44153965 |  |  | 3358 | 3387.916 | 29.916 | KG | 0.88 | 253.92 | GBP
 |  | 102875755 |  |  | 0 | 0.022 | 0.022 | KG | 100 | 0.06 | GBP
 |  | 103004008 |  |  | 0 | 0.022 | 0.022 | KG | 100 | 0.11 | GBP
 |  | 105009205 |  |  | 0 | 0.022 | 0.022 | KG | 100 | 0.1 | GBP
 |  | [NAME] from this column between c5 and c29 |  | [NAME] from this column between c5 and c29 |  |  |  |  | [NAME] value from this column between c5 and c29
 |  | if value any of the yellow ones |  | if value any of the yellow ones |  |  |  |  | if value green
 |  | return SUM of red cells associated with yellow |  | return AVERAGE of blue cells associated with yellow |  |  |  |  | return value of cell associated with green
Spreadsheet: 120356d1315232618-vlookup-to-return-multiple-results-lob-colocations-example
Sheet: Allocations

File Id |  | File Name | Total Location Size | Expiration | Cost Center | Percent Allocated | [NAME] | Status | 1 | LOB | NEF Chargeback | Reserves
AL3946 | AL3946 - 10020001 | [NAME] | 200000 | 2020-12-31 00:00:00 | 10020001 | 100 | 200000 | Active | YES | LOB 1
AL3948 | AL3948 - 10020001 | New York | 100000 | 2020-12-31 00:00:00 | 10020001 | 14 | 14000 | Active | NO | LOB 2 |  |  | 14000
AL3948 | AL3948 - 10020001 | New York | 100000 | 2020-12-31 00:00:00 | 10020001 | 12 | 12000 | Active | NO | LOB 2 |  |  | 12000
AL3948 | AL3948 - 10020001 | New York | 100000 | 2020-12-31 00:00:00 | 10020001 | 26 | 26000 | Active | NO | LOB 3 |  |  | 26000
AL3948 | AL3948 - 10020001 | New York | 100000 | 2020-12-31 00:00:00 | 10020001 | 15 | 15000 | Active | NO | LOB 4 |  |  | 15000
AL3948 | AL3948 - 10020001 | New York | 100000 | 2020-12-31 00:00:00 | 10020001 | 7.000000000000001 | 7000 | Active | NO | LOB 4 |  |  | 7000.000000000001
AL3948 | AL3948 - 10020001 | New York | 100000 | 2020-12-31 00:00:00 | 10020001 | 3 | 3000 | Active | NO | LOB 4 |  |  | 3000
AL3948 | AL3948 - 10020001 | New York | 100000 | 2020-12-31 00:00:00 | 10020001 | 4 | 4000 | Active | NO | LOB 5 |  |  | 4000
AL3948 | AL3948 - 10020001 | New York | 100000 | 2020-12-31 00:00:00 | 10020001 | 6 | 6000 | Active | NO | LOB 4 |  |  | 6000
AL3948 | AL3948 - 10020001 | New York | 100000 | 2020-12-31 00:00:00 | 10020001 | 6 | 6000 | Active | NO | LOB 6 | 1 |  | 6000
AL3948 | AL3948 - 10020001 | New York | 100000 | 2020-12-31 00:00:00 | 10020001 | 4 | 4000 | Active | NO | LOB 7 |  |  | 4000
AL3948 | AL3948 - 10020001 | New York | 100000 | 2020-12-31 00:00:00 | 10020001 | 3 | 3000 | Active | NO | LOB 7 |  |  | 3000
AL3949 | AL3949 - 10020001 | Aventura | 50000 | 2020-12-31 00:00:00 | 10020001 | 100 | 50000 | Active | YES | LOB 1 |  | R
AS3946 | AS3946 - 10020001 | [NAME] | 30000 | 2020-12-31 00:00:00 | 10020001 | 100 | 30000 | Active | YES | LOB 1
Spreadsheet: 784522d1655807520-data-extracting-sorting-and-organizing-drgkt-v3
Sheet: Sheet2

BEGIN:VCARD | N:Smoe;Joe;Dave;Mr.;Sr. | FN:Mr. [NAME], Sr. | TEL;CELL:+[PHONE] | TEL;WORK;FAX:(201) 555-2222 | TEL;HOME;FAX:555 3333 | TEL;PAGER:[PHONE] | END:VCARD
BEGIN:VCARD | N:Doe;Jane;Marie;; | FN:Ms. [NAME] Doe\, | NICKNAME:MayJo | TEL;CELL:+[PHONE] | TEL;HOME:(201) 555 6666 | TEL;WORK:[PHONE] | TEL;VOICE:5558888 | TEL;WORK;FAX:555-9999 | TEL;HOME;FAX:[PHONE] | TEL;PAGER:+[PHONE] | TEL;Custom:666 1111 | TEL;PREF:6662222 | TEL;AnotherCustom:[PHONE] | TEL;CELL:[PHONE] | EMAIL;WORK:[EMAIL] | ORG:Microsoft | TITLE:CEO | END:VCARD
Spreadsheet: 677675d1589468184-search-multiple-columns-return-corresponding-value-search
Sheet: Sheet1

Tens | Color | Code | Hundreds | Color | Code | Thousand | Color | Code
10 | Red | 1R | 100 | Red-Yellow | 1RW | 1000 | Red-Green-Blue | 1RGB
20 | Blue | 2B | 200 | Blue-Red | 2BR | 2000 | Blue-Red-Green | 2BRG
30 | Green | 3G | 300 | Green-Indigo | 3GI | 3000 | Green-Indigo-Purple | 3GIP
40 | Orange | 4O | 400 | Orange-Blue | 4OB | 4000 | Orange-Blue-Red | 4OBR
50 | Purple | 5P | 500 | Purple-Orange | 5PO | 5000 | Purple-Orange-Yellow | 5POY
 | Search | 300
 | Return | Green-Indigo
 | Search | 4000
 | Return | Orange-Blue-Red
 | Search | 20
 | Return | Blue
Spreadsheet: 454971d1460050091-countblanks-with-if-countblank
Sheet: Sheet1

NAME | STATUS | START | END | 2016-04-04 00:00:00 | 2016-04-11 00:00:00 | 2016-04-18 00:00:00 | 2016-04-25 00:00:00 | 2016-05-02 00:00:00 | 2016-05-09 00:00:00 | 2016-05-16 00:00:00 | 2016-05-23 00:00:00 | 2016-05-30 00:00:00 | 2016-06-06 00:00:00 | 2016-06-13 00:00:00 | 2016-06-20 00:00:00 | 2016-06-27 00:00:00 | 2016-07-04 00:00:00 | 2016-07-11 00:00:00 | 2016-07-18 00:00:00 | 2016-07-25 00:00:00 | 2016-08-01 00:00:00 | 2016-08-08 00:00:00 | 2016-08-15 00:00:00 | 2016-08-22 00:00:00 | 2016-08-29 00:00:00 | 2016-09-05 00:00:00 | 2016-09-12 00:00:00 | 2016-09-19 00:00:00 | 2016-09-26 00:00:00 | 2016-10-02 00:00:00
[NAME] |  | 2015-01-01 00:00:00 | 2016-08-07 00:00:00 | Booked | Booked | Booked | Booked | Booked | Booked | Booked | Booked | Booked | Booked | Booked | Booked | Booked | Booked | Booked | Booked | Booked | Booked |  |  |  |  |  |  |  |  | 8
[NAME] | Leaver | 2016-05-23 00:00:00 | 2016-07-31 00:00:00 |  |  |  |  |  |  |  | Booked | Booked | Booked | Booked | Booked |  |  | Booked | Booked | Booked |  |  |  |  |  |  |  |  |  | 2
Spreadsheet: 126299d1319624249-issue-with-setting-up-a-formula-with-more-than-one-condition-ge-report-august-2011-final-test
Sheet: The Netherlands 2011

THE NETHERLANDS
GE Business | GE Sub-business | Matter Number | Matter Description | GE Contact | Office | S&S Contact | Status | Category of Work | Non S&S related sums billed from 01 January to 31 August 2011 (£) | S&S related sums billed from 01 January to 31 August 2011 (£) | Cumulative Total 2011 (£)
Consumer Finance | GE Money | 58391-1 | Advice regarding termination | Mrs. [NAME]-Stahrenberg | Amsterdam | Bardies Bassyouni | Ongoing | 2 | 0 | 0 | 0
Commercial Finance | General Electric Capital Corporation | 9301-4 | GECC EFS/Project Tunisia - Project Finance |  | Amsterdam | [NAME] | Ongoing | 5 | 0 | 0 | 0
NBC Universal | Universal | 60154-2 | [NAME] / employment advice | [NAME] | Amsterdam | Bardies Bassyouni | Ongoing | 6 | 0 | 16344.85 | 16344.85
NBC Universal | NBC Universal Studios & Pictures | 60154-5 | NBC Universal/Computer Generated Solutions | [NAME] | Amsterdam | Polet Johan | Ongoing | 6 | 0 | 13824.74 | 13824.74
Totals for The Netherlands: |  |  |  |  |  |  |  |  | 0 | 30169.59 | 30169.59
Overall Totals: |  |  |  |  |  |  |  |  | 9858.07 | 194361.1 | 204219.17
Spreadsheet: 02e4b555-05a6-40f8-a00e-8401a50136eb
Sheet: 10d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated net notional amount outstanding, February 8 weekly snapshot, by product type and tenor (millions of USD), cleared swaps only, all participant types and tenors.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for tenor bucket descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 852634d1702600698-visit-schedule-visit-schedule
Sheet: CMSVD1

Service User | Start | End | Round
Mr MP | 2023-12-11 06:55:00 | 2023-12-11 07:15:00 | BAR-AM P1
Mrs PF | 2023-12-11 07:15:00 | 2023-12-11 08:00:00 | BAR-AM P1
Miss [NAME] | 2023-12-11 08:00:00 | 2023-12-11 08:15:00 | BAR-AM P1
Mr BD | 2023-12-11 08:15:00 | 2023-12-11 08:30:00 | BAR-AM P1
[NAME] | 2023-12-11 08:30:00 | 2023-12-11 09:15:00 | BAR-AM P1
Mrs AJM | 2023-12-11 09:30:00 | 2023-12-11 09:40:00 | BAR-AM P1
Miss DB | 2023-12-11 09:50:00 | 2023-12-11 10:05:00 | BAR-AM P1
Mr GES | 2023-12-11 10:05:00 | 2023-12-11 10:35:00 | BAR-AM P1
Mr MP | 2023-12-11 11:30:00 | 2023-12-11 11:45:00 | BAR-AM P1
[NAME] | 2023-12-11 11:30:00 | 2023-12-11 11:45:00 | BAR-AM P1
Mr SH | 2023-12-11 11:45:00 | 2023-12-11 12:00:00 | BAR-AM P1
[NAME] | 2023-12-11 12:15:00 | 2023-12-11 12:30:00 | BAR-AM P1
Mr JB | 2023-12-11 12:45:00 | 2023-12-11 13:00:00 | BAR-AM P1
[NAME] | 2023-12-11 13:00:00 | 2023-12-11 13:30:00 | BAR-AM P1
Spreadsheet: 863314d1710850482-using-operators-with-dates-in-cells-if-with-dates-etaf
Sheet: Sheet1

dates | 1st group | 2nd group |  | 1st group start | 1st group end | 2nd group start | 2nd group end
2020-10-18 00:00:00 | yes | no |  | 2020-01-01 00:00:00 | 2021-12-31 00:00:00 | 2022-01-01 00:00:00 | 2023-12-31 00:00:00
2022-04-07 00:00:00 | no | yes
2021-01-05 00:00:00 | yes | no
2021-08-07 00:00:00 | yes | no
2022-04-03 00:00:00 | no | yes
2020-06-06 00:00:00 | yes | no
2020-10-19 00:00:00 | yes | no
2022-06-12 00:00:00 | no | yes
2023-08-29 00:00:00 | no | yes
2021-01-27 00:00:00 | yes | no
2022-06-07 00:00:00 | no | yes
2023-02-03 00:00:00 | no | yes
2023-11-13 00:00:00 | no | yes
2021-05-14 00:00:00 | yes | no
2020-03-04 00:00:00 | yes | no
2022-04-09 00:00:00 | no | yes
2020-01-26 00:00:00 | yes | no
2020-06-15 00:00:00 | yes | no
2022-01-12 00:00:00 | no | yes
This is the formula I want to apply in the columns B&C, I do not want to insert date as a hard core edit inside the formula, but want to refer to the cells contains the dates and use operators only like <,>,=,<=,>=
=IF(A2"<="$F$2&">="$E$2,"yes","no")