tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 02d8bc85-d1fe-45f3-89f4-8dbee1ad3eeb
Sheet: Sheet1

International Students | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
by Country of Citizenship, Level
Fall 2011
Country of Citizenship | Undergraduate | Graduate | Total
People's Republic of China | 571 | 261 | 832
Saudi Arabia | 52 | 49 | 101
India | 16 | 34 | 50
Germany | 32 | 2 | 34
United States | 16 | 15 | 31
Nigeria | 27 | 2 | 29
Ghana | 10 | 10 | 20
Bangladesh | 13 | 6 | 19
Iran | 2 | 15 | 17
Korea, South | 13 | 3 | 16
Bermuda | 15 |  | 15
United Kingdom | 15 |  | 15
England | 13 | 1 | 14
France | 9 | 3 | 12
Pakistan | 3 | 8 | 11
Russian Federation | 7 | 6 | 13
Trinidad and Tobago | 11 |  | 11
Bahamas | 10 |  | 10
Zimbabwe | 8 | 1 | 9
United Arab Emirates | 4 | 3 | 7
Mexico | 3 | 3 | 6
Turkey | 2 | 4 | 6
Australia | 5 |  | 5
Barbados | 4 | 1 | 5
Colombia | 4 | 1 | 5
Hongkong | 5 |  | 5
Indonesia | 3 | 2 | 5
Libya | 3 | 2 | 5
Sweden | 5 |  | 5
Denmark |  | 4 | 4
Gambia | 4 |  | 4
Italy | 3 | 1 | 4
Jamaica | 4 |  | 4
Japan | 4 |  | 4
Switzerland | 4 |  | 4
Taiwan | 2 | 2 | 4
Venezuela | 2 | 2 | 4
Belgium | 1 | 2 | 3
Cayman Islands | 3 |  | 3
Kenya | 3 |  | 3
Spain | 2 | 1 | 3
Syria | 3 |  | 3
Uganda | 3 |  | 3
Viet Nam | 2 | 1 | 3
Belize | 2 |  | 2
[NAME] | 2 |  | 2
Czech Republic |  | 2 | 2
Eritrea | 1 | 1 | 2
Lithuania | 1 | 1 | 2
Malaysia | 1 | 1 | 2
[NAME] | 2 |  | 2
Nepal | 2 |  | 2
Netherlands Antilles | 2 |  | 2
New Zealand | 1 | 1 | 2
Phillippines | 2 |  | 2
Thailand | 1 | 1 | 2
Afghanistan | 1 |  | 1
Antigua & Barbuda | 1 |  | 1
Austria |  | 1 | 1
[NAME] | 1 |  | 1
Bahrain | 1 |  | 1
Byelorussia (Belarus) | 1 |  | 1
Brazil |  | 1 | 1
Bulgaria | 1 |  | 1
Burundi | 1 |  | 1
Cameroon | 1 |  | 1
Chad | 1 |  | 1
Chile | 1 |  | 1
Congo, Democratic Republic of the | 1 |  | 1
Dominica |  | 1 | 1
Finland | 1 |  | 1
Guernsey | 1 |  | 1
Greece |  | 1 | 1
Grenada | 1 |  | 1
Iraq | 1 |  | 1
[NAME] | 1 |  | 1
Lativia | 1 |  | 1
Madagascar | 1 |  | 1
Morocco | 1 |  | 1
Netherlands | 1 |  | 1
Norway |  | 1 | 1
Portugal | 1 |  | 1
Qatar | 1 |  | 1
Romania |  | 1 | 1
Rwanda | 1 |  | 1
[NAME] and Nevis | 1 |  | 1
Swaziland | 1 |  | 1
Tanzania, United Republic of | 1 |  | 1
Ukraine |  | 1 | 1
Uzbekistan | 1 |  | 1
Total | 965 | 459 | 1424
Spreadsheet: 775087d1648818080-simplifying-a-vlookup-or-suggest-a-better-formula-sample-data
Sheet: TYPE 3

 |  | Other Value not required 1 | Other Value not required 2 | VALUE
1 | [NAME] |  |  | 21
2 | DATA2 |  |  | 22
3 | DATA3 |  |  | 23
4 | DATA4 |  |  | 24
5 | DATA5 |  |  | 25
6 | DATA6 |  |  | 26
7 | DATA7 |  |  | 27
8 | DATA8 |  |  | 28
9 | DATA9 |  |  | 29
10 | DATA10 |  |  | 30
Spreadsheet: 39153d1237351117-counting-data-from-columns-mlbbetsystem-version-5-
Sheet: Series

[NAME] |  | Wins |  |  |  |  |  |  | Starting Bankroll |  | Current Bankroll
[NAME] |  |  |  |  |  |  |  |  | 3000
Date | Bet Unit | Series # | Game # | Bet Team | H/A | VS Team | Line | Risk | To Win | Bankroll | Profit | W/L | Score
2009-04-01 00:00:00 | 1 | 1 | 1 | SEA | AT | CHC | -175 |  |  |  |  | Win
2009-04-01 00:00:00 | 1 | 2 | 1 | BAL | VS | CIN | -154 |  |  |  |  | Loss
2009-04-01 00:00:00 | 1 | 3 | 1 | CHC | AT | FLA | -175 |  |  |  |  | Loss
2009-04-02 00:00:00 | 1 | 2 | 2 | BAL | VS | CIN | -165 |  |  |  |  | Loss
2009-04-02 00:00:00 | 1 | 3 | 2 | CHC | AT | FLA | -144 |  |  |  |  | Loss
2009-04-03 00:00:00 | 1 | 2 | 3 | BAL | VS | CIN | -120 |  |  |  |  | Win
2009-04-03 00:00:00 | 1 | 3 | 3 | CHC | AT | FLA | -150 |  |  |  |  | Win
2009-04-04 00:00:00 | 1 | 4 | 1 | WAS | VS | CIN | 125 |  |  |  |  | Loss
2009-04-04 00:00:00 | 1 | 5 | 1 | ANA | AT | COL | -144 |  |  |  |  | Win
2009-04-05 00:00:00 | 1 | 6 | 1 | BOS | AT | CLE | -180 |  |  |  |  | Loss
2009-04-06 00:00:00 | 1 | 4 | 2 | WAS | VS | CIN | 115 |  |  |  |  | Loss
2009-04-06 00:00:00 | 1 | 6 | 2 | BOS | AT | CLE | -165 |  |  |  |  | Win
2009-04-06 00:00:00 | 1 | 4 | 3 | WAS | VS | CIN | 110 |  |  |  |  | Loss
Spreadsheet: chris_germany__2125__JanCohCHOICE-ENA
Sheet: Jan 27

 | CES/NPC COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2001-01-27 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1515 |  | 1559 |  | 67694 |  |  |  |  |  | 22 | 1 | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 2 | 23
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 6452 |  | 6452 |  | 67694 |  |  |  |  |  | 23 | 3 | 22
 |  |  |  |  |  |  |  |  | 6999 |  | 6999 |  | 68918 | 0 |  |  |  |  | 23 | 4 | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 5 | 22
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 2520 |  | 2648 |  | 67694 |  |  |  |  |  | 24 | 6 | 20
 |  |  |  |  |  |  |  |  | 2400 |  | 2400 |  | 68915 | 0 |  |  |  |  | 23 | 7 | 22
 |  |  |  |  |  |  |  |  | 500 |  | 500 |  | 69148 | 0 |  |  |  |  | 26 | 8 | 23
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 | 0 |  |  |  |  | 24 | 9 | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | 15 | 27
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 19813 |  | 19813 |  | 67694 |  |  |  |  |  | 27 | 35 | 25
 |  |  |  |  |  |  |  |  | 85 |  | 85 |  | 68917 | 0 |  |  |  |  | 23 | 39 | 21
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69149 | 0
 |  |  |  |  |  |  |  |  | 1600 |  | 1600 |  | 69693 | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 2032 |  | 2132 |  | 67694 |  |  |  |  |  | %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Storage
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1425 |  | 1580 |  | 67694 |  |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  | 1915 |  | 1915 |  | 68916 | 0 |  |  |  |  | 1
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 18055 |  | 19910 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 4275 |  | 4702 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 4432 |  | 4773 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 5523 |  | 5809 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 1711 |  | 1867 |  | 67694
 |  |  |  |  |  |  |  |  | 200 |  | 200 |  | 69708 | 0
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 43 |  | 45 |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 3 |  | 3 |  | 69708 | 0
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  | 27835 | Pull from ENA Pool to NPC Pool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 273410d1382707752-find-and-return-the-value-of-a-cell-based-on-other-cells-in-the-same-row-id-search
Sheet: Analysis

 | Location Code | -132871
 | Rank | % Days | ID
 | 1
 | 2
 | 3
 | 4
 | 5
Spreadsheet: 542997d1508191816-bring-premium-when-price-is-above-700-and-ssd-y-also-when-brand-is-apple-and-example-6
Sheet: Sheet2

Units | USD | Column1 | Brand Cluster | Gaming Y/N | SSD Y/N | Pure Premium (Current Formula) |  | Desired result
1 | 3038.105726872247 |  | Apple | Non Gaming | Y |  |  | Premium
1 | 2286.013215859031 |  | Apple | Gaming | Y |  |  | Not Premium
4 | 6723.348017621145 |  | ASUS | Gaming | Y |  |  | Not Premium
32 | 58763.05066079295 |  | ASUS | Gaming | Y |  |  | Not Premium
42 | 24244.43832599119 |  | ASUS | Non Gaming | Y |  |  | Not Premium
1801 | 1212859.170653908 |  | Dell | Non Gaming | Y |  |  | Not Premium
230 | 201450.5506607929 |  | Acer | Non Gaming | Y |  |  | Premium
27 | 21816.62995594714 |  | Apple | Non Gaming | Y |  |  | Premium
154 | 144003.3039647577 |  | Apple | Non Gaming | Y |  |  | Premium
8 | 4366.079295154185 |  | Apple | Non Gaming | Y |  |  | Not Premium |  | The answers in bold are "Not Premium" because the dollar amount is below $700 even though they have SSD.
What I want to bring in column G:
Output "Pure Premium" in column F when:
 | -SSD "Y" and USD/Units =>700
 | Brand [NAME] is "Apple"
But if column "Gaming Y/N" is equal to "Gaming" output "Non Premium"
Taking as example cell C6, my result in G6 is "Premium", however, since this lines price is below $700, eventhough in SSD I have "Y", it should be classified as "Not Premium" due to being below $700.
Current formula: =IF(AND([@[Gaming Y/N]]="Gaming",OR([@USD]/[@Units]>=700,[@[Brand Cluster]]="Apple",[@[SSD Y/N]]="Y")),"Not Premium",IF(OR([@USD]/[@Units]>=700,[@[Brand Cluster]]="Apple",[@[SSD Y/N]]="Y"),"Premium","Not Premium"))
Spreadsheet: michelle_lokay__26570__imbalsumm0012
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 21055 | 19223 | 10745 | 10000
2 | 21202 | 19584 | 10722 | 10000
3 | 17314 | 17788 | 10773 | 10000
4 | 27334 | 19584 | 10003 | 10000
5 | 30871 | 33371 | 10556 | 10500
6 | 31042 | 29250 | 9009 | 10500
7 | 31704 | 34250 | 9973 | 10500
8 | 31619 | 34219 | 9894 | 10000
9 | 31577 | 30678 | 11348 | 8750
10 | 31492 | 30632 | 11398 | 8750 | 671
11 | 31398 | 30267 | 11008 | 8750
12 | 31349 | 32989 | 10713 | 11802 | 1
13 | 31276 | 33000 | 9316 | 11783 | 69
14 | 31176 | 33688 | 10651 | 12500
15 | 31266 | 33750 | 9937 | 12500
16 | 31180 | 33750 | 8772 | 11000
17 | 31204 | 33750 | 10588 | 11000
18 | 31116 | 33750 | 10759 | 11000
19 | 31031 | 27160 | 10512 | 8500
20 | 30984 | 32750 | 10962 | 12000
21 | 38918 | 42749 | 10803 | 12000 | 10737 | 10000
22 | 39201 | 36960 | 10732 | 12000 | 13149 | 10000
23 | 39181 | 37311 | 10339 | 12000 | 13715 | 10000
24 | 39009 | 39743 | 10280 | 12000 | 13618 | 10000
25 | 38731 | 39802 | 10415 | 12000 | 13438 | 10000 | 3235
26
27
28
29
30
31
2000-11-30 00:00:00 |  |  |  |  |  |  |  |  | -532429.6
2000-12-25 00:00:00
 |  |  | 516.78
 |  |  | 212.08
 |  |  | 58.33
 |  |  | 25
Spreadsheet: 66110d1266824562-rolling-up-data-by-date-718994_moncul36
Sheet: Sheet1

dates | mins | a/b |  |  | month |  | a | b
2010-01-12 00:00:00 | 100 | A |  |  | 2010-01-01 00:00:00
2010-01-31 00:00:00 | 200 | A |  |  | 2010-02-01 00:00:00
2010-01-14 00:00:00 | 2010 | B |  |  | 2010-03-01 00:00:00
2010-02-01 00:00:00 | 600 | B |  |  | 2010-04-01 00:00:00
2010-02-01 00:00:00 | 300 | A |  |  | 2010-05-01 00:00:00
2010-02-03 00:00:00 | 500 | A |  |  | 2010-06-01 00:00:00
2010-02-04 00:00:00 | 20 | A |  |  | 2010-07-01 00:00:00
2010-02-05 00:00:00 | 50 | B |  |  | 2010-08-01 00:00:00
2010-02-06 00:00:00 | 60 | B |  |  | 2010-09-01 00:00:00
2010-03-14 00:00:00 | 20 | A |  |  | 2010-10-01 00:00:00
2010-03-15 00:00:00 | 20 | A |  |  | 2010-11-01 00:00:00
2010-03-16 00:00:00 | 20 | A |  |  | 2010-12-01 00:00:00
2010-03-17 00:00:00 | 20 | A |  |  | 2011-01-01 00:00:00
2010-03-18 00:00:00 | 20 | B |  |  | 2011-02-01 00:00:00
 |  |  |  |  | 2011-03-01 00:00:00
 |  |  |  |  | 2011-04-01 00:00:00
 |  |  |  |  | 2011-05-01 00:00:00
Spreadsheet: 1da3b7bd-891e-495e-8212-a474d32400c0
Sheet: 65aaa-major

ISA SENIOR WORLD
JULY 26-27-28, 2013
COLUMBUS, IN
65 AAA DIVISION & 65 MAJOR DIVISION
 |  |  |  |  |  | WON |  |  |  | LOSS
1.  DeClaire Knee & Orthopaedic, 65M |  |  |  |  |  | II
2.  High Five, 65M |  |  |  |  |  |  |  |  |  | II
3.  Chicago Gray Sox |  |  |  |  |  |  |  |  |  | II
4.  Michaels |  |  |  |  |  | II
5.  Windsor Chiefs |  |  |  |  |  | II
6.  Direct Employers, 70M |  |  |  |  |  |  |  |  |  | II
7.  Jim & Joe's 65 |  |  |  |  |  | I |  |  |  | I
Friday, July 26, 2013 - Dunn Sports Complex
TIME |  | RUNS |  | TEAM # |  | RUNS |  | DIA. #
10:30am |  | 2 |  | 3 v 4 |  | 18 |  | #2
noon |  | 24 |  | 2 v 4 |  | 25 |  | #2
1:30pm |  | 13 |  | 7 v 5 |  | 18 |  | #2
3pm |  | 19 |  | 1 v 3 |  | 7 |  | #1
3pm |  | 13 |  | 7 v 6 |  | 10 |  | #2
4:30pm |  | 20 |  | 2 v 5 |  | 31 |  | #1
4:30pm |  | 30 |  | 1 v 6 |  | 11 |  | #2
Saturday, July 27, 2013 - Lincoln Park
TIME |  | RUNS |  | TEAM # |  | RUNS |  | DIA. #
8am |  | X |  | 1 v 5 |  | X |  | #5
8am |  | X |  | 3 v 7 |  | X |  | #6
8am |  | X |  | 4 v 6 |  | X |  | #4
9:30pm |  | X |  | 2 v 7 |  | X |  | #6
[NAME]: AAA 3 seed games for seeding into a double elimination bracket. Major seed into best 2 out of 3
Home Runs - AAA = 3 per team per game then Outs. |  |  |  |  |  |  | Major = 6 per team per game, walks
Teams 3-7 get 5 runs or 11 defensive players when playing team #1 or #2.
When a Major is playing AAA - the AAA home run rule will be used
Retrieving all out of play softballs will be strictly enforced.
Run Rules - 5 runs per ½ inning at bat (except open inning)
Time Limits - RR = 65 + open inn. • Bracket = 70 + open inn. • Championship game(s) = 7 innings full
[NAME] to head (in full RR only), least runs allowed, run differential, coin toss
[NAME] to Change at Discretion of Tournament and Field Directors
Spreadsheet: chris_germany__2011__Lonestarnom0602
Sheet: June 4th Intraday Nom(Piggin)

[NAME]
[NAME] |  |  | [NAME] TO THE PIPE!!  [NAME] TO THE PIPE!!  [NAME] TO THE PIPE!!  [NAME] TO THE PIPE>>!!!!!!!!!!!!!
Dallas, TX  75201-5696 |  |  | STOP READ ABOVE      ^^^^^^^^^^
Attention: | Wilma Easter - Scheduling Department |  |  |  | From: | Enron Capital & Trade
Fax: | 214/875-3810 |  |  |  |  | [NAME]
Phone: | 214/875-3296 |  |  |  |  | 713/853-7750 (Phone)
Backup:  [NAME] 214/875-2674 |  |  |  |  |  | 713/345-7374 (Fax)
Contract #LS-MC-1671 |  |  | Start Date: |  | 2002-06-04 00:00:00 |  | End Date: | 2002-06-04 00:00:00
RECEIPT POINT INFORMATION:
 | STATION # | [NAME] | UPSTREAM K# | Previous Day Nom | NOM QUANTITY | FUEL % | NET QUANTITY | Changes
Cinergy | 17-1201-11 | [NAME] | 01T957 | 2000 | 0 | 0.01 |  | **
Cinergy | 17-1954-50 | Conoco Sterling | Conoco | 8000 | 7100 | 0.01
Cinergy | 17-1240-50 | NNG Sprayberry | 107903 | 10000 | 0 | 0.01
Cinergy |  |  |  |  | 0 | 0.01
 | 17-1240-50 | NNG Sprayberry | 108301 | 0 | 0 | 0.01
 | 17-3000-00 | [NAME] | 01T957 | 0 | 0 | 0.01
[NAME] | 17-3000-00 | [NAME] | 2880600203 | 5000 | 5000 | 0.01
[NAME] | 17-1201-11 | [NAME] | REM | 15000 | 0 | 0.01
 | 18-0006-00 | TW Pecos | 24198 | 5000 | 5000 | 0.01
DELIVERY POINT INFORMATION:
STATION # | [NAME] | UPSTREAM K# |  | Previous Day Nom | NOM QUANTITY | FUEL % | NET QUANTITY
25-0002-00 | Kleburne Plant | 1671 |  | 44550
FYI:  Buy/Sell Information
Cinergy | 17-1201-11 | [NAME] | #01T957 | 0 | 0 | 0 |  | sold to TXU K501 | K2704
Cinergy | 17-1201-11 | [NAME] | #01T957 | 0 | 0 | 0 |  | ** sold to TXU K1901
 |  |  |  |  |  | total sold TXU
Cuts:
Please make all necessary cuts pro ratta per location and counterparty.
Spreadsheet: 678052d1589692070-index-match-for-auto-costings-calculations-jitterbug888_bizcostings-sample
Sheet: LOANS & BIZ COSTS

CATEGORY | ITEM | AVERAGE BILL | PERIOD | DAY | WEEK | MONTH | QTR | BI-ANNUAL | YEAR | COMMENTS
BUSINESS COST | GAS | 36 | quarterly
BUSINESS COST | ELECTRICITY | 100 | quarterly
BUSINESS COST | INTERNET | 90 | monthly
BUSINESS COST | RENT | 6035.7 | monthly
BUSINESS COST | [NAME] | 138 | 6 months
BUSINESS COST | PHONE | 85.85 | monthly
BUSINESS LOAN | MASTERCARD | 265 | monthly
BUSINESS LOAN | VISA | 225 | monthly
BUSINESS LOAN | VISA2 | 315 | monthly
BUSINESS LOAN | LOAN1 | 283.65 | monthly
BUSINESS LOAN | BANK OVERDRAFT | 185 | monthly
BUSINESS COST | CONDO | 3500 | yearly
BUSINESS COST | WAVERLEY COUNCIL | 277 | yearly
CHARITY | CHARITY1 | 10 | monthly
SUBSCRIPTIONS | MAGAZINE | 18.5 | monthly
BUSINESS COST | LAUNDRY | 36 | weekly
BUSINESS COST | CANDLES | 0.75 | daily
BUSINESS COST | LEGAL | 200 | yearly
BUSINESS COST | REPAIRS | 50 | weekly
BUSINESS COST | MANCHESTER | 100 | quarterly
BUSINESS COST | LICENSES | 200 | 6 months
BUSINESS COST | INSURANCE | 100 | yearly
BUSINESS COST | PUBLIC LIABILITY | 200 | 6 months
BUSINESS COST | PROFESSIONAL INDEMNITY | 500 | yearly
PERSONAL LOAN | TOM | 2000 | 2 years
PERSONAL LOAN | CARLIE | 5000 | 5 years
Spreadsheet: joe_parks__14549__Febfisrt2002
Sheet: 1671 Cleburne Intrastate

PIPELINE COMPANY |  |  |  |  |  |  |  |  |  |  |  | From: |  | Enron Capital & Trade
301 South Harwood |  |  |  |  |  |  |  |  |  |  |  | Shipper: |  | Enron Capital & Trade
Dallas, TX 75201-5696 |  |  |  |  |  |  |  |  |  |  |  | Contact: |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Phone: |  | [PHONE]
Attn: |  | [NAME]---Scheduling Department |  |  |  |  |  |  |  |  |  | Fax: |  | [PHONE]
Fax: |  | [PHONE]
 |  | Contract #: | LS-MC-1671 | Start Date: |  |  | End Date: | 2002-01-31 00:00:00
Receipt Point Information
Station # |  | Station Location Description |  | Upstream Shipper & Contract # |  |  | Previous Nom |  | Nominated |  |  | Fuel % | Fuel Amt | Net Quantity
 |  |  |  |  |  |  | Quantity (MMBtu/D) |  | Quantity (MMBtu/D)
18-0006-00-00 |  | TW Pecos |  | 24198 |  |  | 0 |  |  | 0 |  | 0.01
17-1240-50 |  | NNG Sprayberry |  | 108188 |  |  | 0 |  |  | 0 |  | 0.01
17-8060-00 |  | [NAME] |  | 3194 |  |  | 0 |  |  | 0 |  | 0.01
17-1201-11 |  | [NAME] |  | 01T957 |  |  | 0 |  |  | 0 |  | 0.01
17-1201-11 |  | [NAME] |  | REM / Cynergi |  |  | 0 |  |  | 10000 |  | 0.01
17-1201-11 |  | [NAME] |  | REM / Williams |  |  | 0 |  |  | 13715 |  | 0.01
17-7462-50 |  | EPGT-PGE Waha |  | 5096017 |  |  | 0 |  |  | 0 |  | 0.01
17-7462-50 |  | EPGT-PGE Waha |  | 5095037 |  |  | 0 |  |  | 0 |  | 0.01
17-7462-50 |  | EPGT-PGE Waha |  | 5097039 |  |  | 0 |  |  | 0 |  | 0.01
17-8477-01 |  | Sandtrap |  | [NAME] |  |  | 0 |  |  | 0 |  | 0.005
17-6749-04 |  | Teco |  | 3999012 |  |  | 0 |  |  | 0 |  | 0.01
17-6749-04 |  | Teco |  | 3999042 |  |  | 0 |  |  | 4285 |  | 0.01
17-1954-50 |  | Conoco Sterling |  | SS |  |  | 0 |  |  | 10000 |  | 0.01
20-0149-03 |  | Warwink - X2- X36 |  | 1961 |  |  | 0 |  |  | 7000 |  | 0.01
 |  |  |  |  |  |  |  |  |  | 0
Delivery Point Information
Station # |  | Station Location Description |  | Downstream Shipper & Contract # |  |  | Previous Nom |  | Nominated |  |  |  |  | Net Quantity
 |  |  |  |  |  |  | Quantity (MMBtu/D) |  | Quantity (MMBtu/D)
 |  | Payback |  |  |  |  | 0 |  |  | 0
17-0976-13 |  | HPL Texoma |  | 96061532 |  |  | 0 |  |  | 0
17-7227-00 |  | [NAME] |  | 96060506 |  |  | 0 |  |  | 0
17-7227-00 |  | [NAME] |  | 96061532 |  |  | 0 |  |  | 0
20-0149-03 |  | Warwink-Waha |  | LSPGP20 |  |  | 0 |  |  | 0 |  |  | 0
20-0149-03 |  | Warwink-Waha |  | 3094 |  |  | 0 |  |  | 0
25-0002-00 |  | Kleburne Plant |  |  |  |  | 0 |  |  | 44550
 |  |  |  |  |  |  |  |  |  |  |  |  | Total Del:
Spreadsheet: darrell_schoolcraft__7364__imball0201
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1 | -14 |  | -54985 | -54900
2 |  |  | -45523 | -45012
3 | -19469 | -20000 | -31996 | -29900
4 | -10157 | -10000 | -65915 | -65318
5 | -29699 | -29869 | -63672 | -63430
6 | -29789 | -29869 | -64157 | -63430
7 | -29899 | -29869 | -83960 | -83430
8 | -10720 | -10152 | -104080 | -104207
9 | -14972 | -15000 | -57592 | -56846
10 | -14997 | -15000 | -93909 | -93216
11 | -613 |  | -79398 | -78955
12 | -5137 | -5000 | -58921 | -59382
13 | -5527 | -5000 | -59922 | -59382
14 | -5814 | -5000 | -57766 | -57060
15 |  |  | -88029 | -87799
16 | -4789 | -4155 | -81538 | -80882
17 | -22716 | -22154 | -91857 | -91315
18 | -324 |  | -65366 | -64929
19 |  |  | -70622 | -72649
20 |  |  | -72881 | -72649
21 |  |  | -61293 | -62649
22 |  |  | -72050 | -71395
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  | 9676
2002-01-22 00:00:00
CBS $
 |  |  | 19943.24
Spreadsheet: susan_bailey__39390__Sodra
Sheet: export

Buyer | [NAME] | Deal No. | Type | Deal Date | Beg Date | End Date
ECTINTL | SODRASKOEK | NX7500.1 | Swap | 2000-08-31 00:00:00 | 2000-09-01 00:00:00 | 2005-08-31 00:00:00
ECTINTL | SODRASKOEK | V06031.1 | Swap | 2001-03-30 00:00:00 | 2001-04-01 00:00:00 | 2006-03-31 00:00:00
Spreadsheet: 702747d1604509800-vlookup-multiple-criteria-return-unique-values-sample-1-
Sheet: Result

Code | Country | Product | approval | ID
X | Morocco | A | N/A
Y | Morocco | A | approved
Z | Morocco | A | N/A
P | Germany | B | approved
I | Israel | D | approved
L | Morocco | F | approved
K | Algeria | A | N/A
ZZ | Italy | F | N/A
W | Egypt | B | N/A
R | Senegal | G | N/A
U | Algeria | H | approved
P | Algeria | H | N/A
O | Morocco | H | N/A
T | Germany | B | N/A
Spreadsheet: 588305d1535555705-trying-to-condense-daily-shipping-to-semi-weekly-based-on-a-variety-of-shared-locations-shipping-example
Sheet: Sheet1

New Ship Date | Old Ship Date | Sum of Old Charge | Sum of New Carge
2018-04-09 00:00:00 | 2018-04-09 00:00:00 | 48.54 | 48.54
2018-04-12 00:00:00 | 2018-04-10 00:00:00 | 35.09 | 35.8
 | 2018-04-11 00:00:00 | 48.54 | 17.9
 | 2018-04-12 00:00:00 | 12.74 | 0
2018-04-19 00:00:00 | 2018-04-17 00:00:00 | 48.54 | 53.7
 | 2018-04-18 00:00:00 | 48.54 | 0
 | 2018-04-19 00:00:00 | 12.74 | 0
2018-04-23 00:00:00 | 2018-04-20 00:00:00 | 17.19 | 17.19
2018-04-26 00:00:00 | 2018-04-24 00:00:00 | 35.26 | 35.26
 | 2018-04-25 00:00:00 | 17.99 | 0
2018-04-30 00:00:00 | 2018-04-27 00:00:00 | 48.78 | 48.81999999999999
 | 2018-04-30 00:00:00 | 18.03 | 0
Grand Total |  | 391.98 | 257.21
Spreadsheet: 105263d1302688812-search-typed-string-and-paste-related-content-book1_deksiberu
Sheet: Sheet2

 | Device Name | Remaining Time | StartDate | EndDate
 | E63 | None | 2010-03-08 00:00:00 | 2010-03-12 00:00:00
 | E71 | None | 2010-03-10 00:00:00 | 2010-03-14 00:00:00
 | E72 | None | 2010-03-10 00:00:00 | 2010-03-13 00:00:00
 | A23 | 7 day(s) | 2011-04-13 00:00:00 | 2011-04-20 00:00:00
Spreadsheet: 765695d1643508837-determining-work-time-based-on-criteria-splitshiftef-dexter2-
Sheet: Data

Base | 00:10:00 |  |  | Span of Shift
Location A | 00:00:00 |  | Base | Report for Roll Call
Location B | 00:10:00 |  |  | Start 1st Shift of Work | 07:55:00
Location C | 00:15:00 |  |  | End Shift | 10:58:00
Location D | 00:30:00
Combination | 00:15:00 |  |  | Break
 |  |  | Base | Report for 2nd Roll Call
 |  |  |  | Pull out | 14:23:00
 |  |  |  | 11th hr
 |  |  |  | End of 2nd Shift and Work Day | 19:35:00
 |  |  |  | Job Time
 |  |  |  | Report Time
 |  |  |  | Commute Time
 |  |  |  | Work Time
 |  |  |  | Straight Time
 |  |  |  | Over Time
Spreadsheet: 824934d1680965986-identify-cells-in-a-range-of-200-miles-that-fall-within-30-and-40-miles-sample-list-of-towns-and-miles-6-
Sheet: ROUTE STAGES (2)

Home - Virginia | 0
Leon / Casa Botines | 3.34
Mansilla de Las Mulas | 11.1 |  |  |  | This are the results (Actual sum value that is between >=30 and <=40 that I would like the formula to identify in the list
El Burgo Ranero | 22.9
Bercianos Del Camino Real | 27.4
Sahagun | 33.7 |  |  |  | 33.7 |  | 33.7 >=30 and <=40
Terradillos de Los Templarios | 41.3
Ledigos | 43.2
[NAME] | 47
Carrion de los Condes | 57.6
[NAME] | 61.2
[NAME] | 69.6 |  |  |  | 35.9 |  | B12   69.6 -  B6  33.7 = 35.9
Boadilla Del Camino | 73.1
Itero de la Vega | 78.1
Castrojeriz | 85.1
[NAME] | 97.1
[NAME] | 102 |  |  |  | 32.4 |  | B17  102 -  B12  69.6 = 32.4
Tardajos | 103
Burgos | 110
Ibea de Juarros | 119
[NAME] | 132
[NAME] | 136
Villalomez | 137 |  |  |  | 35 |  | B23  132 -  B17  102 = 35
Tosantos | 142
Belorado | 145
Leiva | 155
Herramelluri | 156
Santo Domingo de la Cueza | 162 |  |  |  | 27 |  | B28  162 -  B23  137 = 27 |  |  | In this case, the formula would not place any value…. Unless the formula range criteria is modified to only <=40, the formula will not function from this point down the list because it has no point of reference to sum the next 30 / 40 miles.
[NAME] | 178 |  |  |  | 41 |  | B29  178 -  B23  137 = 41
[NAME] | 200
Los Arcos | 217
Estella-Lizarra | 229
Puente La Reina | 241 |  |  |  |  |  |  |  |  | Can the formula be design to place the sum value closes to 30 or 40?               Or                                                                                                                                            if neither meets the parameter criteria; be design to place the 2nd sum value over >=40?
Obanos | 243
Pamplona | 258
Irurtzun | 272
[NAME] | 279
Jauntsarats | 282
Ola | 286
Saldias | 293
Labaien | 296
Doneztebe/Santesban | 304
Spreadsheet: 827957d1683144991-puzzling-formula-with-several-variables-excel-puzzle-test-dummy-workbook
Sheet: Promotions

Name | Start Position | Promoted On | Promoted To | Promoted On | Promoted To
[NAME] | Director
[NAME] | Senior | 2023-04-13 00:00:00 | Director
[NAME] | Consultant | 2023-04-16 00:00:00 | Senior
Geoff | Assistant
Caroline | Graduate | 2023-04-08 00:00:00 | Assistant | 2023-04-22 00:00:00 | Consultant