tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 715004d1611504172-formula-for-closing-balance-copie-de-forum-excel-24-jan-2021-1-
Sheet: Projection

 | Last month | This month | [NAME] | février-2020 | mars-2020 | avril-2020 | mai-2020 | juin-2020 | juillet-2020 | août-2020 | septembre-2020 | octobre-2020 | novembre-2020 | décembre-2020 | janvier-2021 | février-2021 | mars-2021 | avril-2021 | mai-2021 | juin-2021 | juillet-2021 | août-2021 | septembre-2021 | octobre-2021 | novembre-2021 | décembre-2021 | janvier-2022 | [NAME] | mars-2022 | avril-2022 | mai-2022 | juin-2022 | juillet-2022 | août-2022 | septembre-2022 | octobre-2022 | novembre-2022 | décembre-2022
First date |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
Last date |  |  | 2020-01-31 00:00:00 | 2020-02-29 00:00:00 | 2020-03-31 00:00:00 | 2020-04-30 00:00:00 | 2020-05-31 00:00:00 | 2020-06-30 00:00:00 | 2020-07-31 00:00:00 | 2020-08-31 00:00:00 | 2020-09-30 00:00:00 | 2020-10-31 00:00:00 | 2020-11-30 00:00:00 | 2020-12-31 00:00:00 | 2021-01-31 00:00:00 | 2021-02-28 00:00:00 | 2021-03-31 00:00:00 | 2021-04-30 00:00:00 | 2021-05-31 00:00:00 | 2021-06-30 00:00:00 | 2021-07-31 00:00:00 | 2021-08-31 00:00:00 | 2021-09-30 00:00:00 | 2021-10-31 00:00:00 | 2021-11-30 00:00:00 | 2021-12-31 00:00:00 | 2022-01-31 00:00:00 | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00
Épargne et inv.  (défilé [NAME]) | Last month | This month | 2020-01-01 00:00:00
AR | [NAME]? | [NAME]? |  |  |  |  |  |  |  |  |  |  |  | 100
FT |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
PL
UR
 | Last month is now | This month is now
 | December 2020 | January 2021
 | but it will update | but it will update
 | as months go by | as months go by
Spreadsheet: 859524d1707901280-issues-with-lookup-values-having-integers-book1
Sheet: Sheet1

Sl. No | Data 1 | Data 2
1 | 1_XYZ | ABC_1
 | 1.1_XYZ | ABC_1.1
 | 1.2_XYZ | ABC_1.2
 | 1.3_XYZ | ABC_1.3
 | 1.4_XYZ | ABC_1.4 |  |  |  |  |  | Data 1 | Data 2
 | 1.5_XYZ | ABC_1.5 |  |  |  | Original | 1.5
 | 2_XYZ | ABC_2 |  |  |  | Value pasted | 1.4
 | 2.01_XYZ | ABC_2.01 |  |  |  |  | 1
 | 2.02_XYZ | ABC_2.02 |  |  |  |  | 6
 | 2.03_XYZ | ABC_2.03 |  |  |  |  | 10
 | 2.04_XYZ | [NAME] |  |  |  |  | 1.2
 | 3_XYZ | [NAME] |  |  |  |  | 3
 | 4_XYZ | ABC_4 |  |  |  |  | 2.03
 | 5_XYZ | ABC_5 |  |  |  |  | 4
 | 6_XYZ | ABC_6 |  |  |  |  | 9
 | 7_XYZ | ABC_7 |  |  |  |  | 2.02
 | 8_XYZ | ABC_8 |  |  |  |  | 1.3
 | 9_XYZ | ABC_9 |  |  |  |  | 2.04
 | 10_XYZ | ABC_10 |  |  |  |  | 7
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 1.1
 |  |  |  |  |  |  | 8
 |  |  |  |  |  |  | 2.01
Spreadsheet: 728037d1618261191-countifs-returning-spill-or-value-error-test_12april21
Sheet: Support by Prob

Account ID | Product | Support Product ID
111587 | HR | 2004748
111587 | Platform | 2005598
33569 | HR | 2004748
47869 | Commerce | 2005459
558896 | Sales | 2005653
558879 | Platform | 2005598
223564 | Service | 2004879
222368 | HR | 2004748
9998674 | HR | 2004748
657849 | Platform | 2005598
1144578 | Service | 2004879
999867 | Commerce | 2005459
6565674 | Sales | 2005653
33569 | Sales | 2005653
223564 | Platform | 2005598
222368 | Commerce | 2005459
Spreadsheet: mary_hain__25869__Agenda General
Sheet: Sheet1

Bring Your Child To Work Day
Friday, June 29, 2001
Agenda
07:30:00 | Registration
 | [NAME]
09:00:00 | [NAME] Childrens Museum Activity Cheerleading Camp Golden Retriever Hideout Kids Center Booth E Logo Balloon Patrol Car K9 Police Motorcycle SWAT DARE Finger Print Station Bright&Beautiful Therapy Dog  Natural Legacy | Stranger Danger EB4C2 All Ages  Session #10 | EFCU Bingo  EB5C2 All Ages  Session # 20 | Body Shop  Interval Class 6-8 Yrs Session #30 | Body Shop  KickBoxing 12+ Yrs    Session #34 | Business Card (IT)  EB564 9+ Yrs  Session #400 | E Mail (IT)  EB572 9+ Yrs   Session #405 | Thanks, Mr. [NAME] (IT)  EB568 9+ Yrs  Session #410 | Build Your Resume EB20C2 9-12 Yrs Session #50 | Manners for Kids The Energizer 6-8 Yrs Session #61 | SPCA Course EB560 9+ Yrs  Session # 70 | 50th [NAME]9+ Yrs
09:30:00 |  | Stranger Danger EB4C2 All Ages  Session #11 | EFCU Bingo EB5C2 All Ages  Session # 21 | Body Shop  Interval Class 6-8 Yrs Session #31 | Body Shop  KickBoxing 12+ yrs    Session #35 | Business Card (IT)  EB564 9+ Yrs  Session #401 | E Mail (IT)  EB572 9+ Yrs   Session #406 | Thanks, Mr. [NAME] (IT)  EB568 9+ Yrs  Session #411
10:00:00 |  | Stranger Danger EB4C2 All Ages  Session #12 | EFCU Bingo  EB5C2 All Ages  Session # 22 | Body Shop  Interval Class 9-12 Yrs  Session #32 | Body Shop  KickBoxing 12+ Yrs    Session #36 | Business Card (IT) EB564 9+ Yrs  Session #402 | E Mail (IT) EB572 9+ Yrs   Session #407 | Thanks, Mr. [NAME] (IT) EB568 9+ Yrs  Session #412 | Build Your Resume EB20C2 6-8 Yrs Session #51 | Manners for Kids The Energizer 9+ Yrs Session #62
10:30:00 |  | Stranger Danger EB4C2 All Ages  Session #13 | EFCU Bingo  EB5C2 All Ages  Session # 23 | Body Shop  Interval Class 9-12 Yrs  Session #33 | Body Shop  KickBoxing 12+ Yrs    Session #37 | Business Card(IT)  EB564 9+ Yrs  Session #403 | E Mail (IT)  EB572 9+ Yrs   Session #408 | Thanks, Mr. [NAME] (IT)  EB568 9+ Yrs  Session #413 | Build Your Resume EB20C2 12+ Yrs Session #52 |  | SPCA Course EB560 6-8 Yrs  Session # 71
11:00:00 |  | Stranger Danger EB4C2 All Ages  Session #14 | EFCU Bingo  EB5C2 All Ages  Session # 24 |  |  | Business Card (IT)  EB564 9+ Yrs  Session #404 | E Mail (IT)  EB572 9+ Yrs   Session #409 | Thanks, Mr. [NAME])  EB568 9+ Yrs  Session #414
Spreadsheet: 272831d1382526400-lookup-please-help-or-do-i-need-a-macro-ef512_copy_completed_records
Sheet: KIT001

EMBARK DATE | EMBARK LOCATION | DISEMBARK LOCATION | EXPORT LICENSE | DISEMBARK DATE | START STATE | DATE | PROJ | VESSEL | ROUNDS FIRED | TEAM LEADER | [NAME] | END STATE | [NAME] |  | 0
2013-04-05 00:00:00 | MARUITUS | 18N - SEA LION |  | 2013-05-04 00:00:00 | 850 | 2013-04-06 00:00:00 | 13.137 | Vessel A | 8 | Curly watts | Test Fire/Zero |  | Complete
2013-06-30 00:00:00 | 18N - SEA LION | GALLE |  | 2013-07-09 00:00:00 |  | 2013-06-30 00:00:00 | 13.189 | Vessel C | 6 | [NAME] | Test Fire/Zero |  | Complete
2013-07-17 00:00:00 | GALLE | 18N - SEA LION |  | 2013-07-28 00:00:00 |  |  | 13.194 | Vessel N |  | [NAME]
2013-08-05 00:00:00 | 18N - SEA LION | FUJ - SOHA FOLK |  | 2013-08-12 00:00:00 |  | 2013-08-07 00:00:00 | 13.216 | Vessel I | 6 | [NAME] | Test Fire/Zero |  | Complete
Spreadsheet: 60225573-bc1a-4d52-b26b-9365b066cbf5
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Third Party Entity Merch | 9780849921995 | K-Love | It'S A God Thing - Pbk [ | 2014-02-14 | Paperback Book | Na | 15.99 | Y | Available
Spreadsheet: 788420d1658468778-trouble-with-drop-down-lists-and-data-sets-pd-workbook
Sheet: Master Data

Model | Basic PD price | Reel options | Option $ | Reel Blades | Reel blade $
GOLF |  | Cutting Unit Golf |  | Cutting Unit Options
2030A |  | Cutting unit 22in QA5 |  | Rear scraper for 22in QA5
7500A |  | Cutting unit 22in QA7 |  | Front scraper for 22in QA5
7700A |  | Cutting unit 26in QA7 |  | Catchers for 22in QA5
8700A |  | Cutting unit 30in QA7 |  | Front GTC for 22in QA5
8900A |  |  |  | Rear brushes for 22in QA5
1200A |  |  |  | Rear scraper for 22in QA7, 26in QA7 and 30in QA7
7200A |  | Cutting Unit Tractor |  | Front scraper for 22in QA7, 26in QA7 and 30in QA7
2400 |  | Test 1 |  | Catchers for 22in QA7, 26in QA7 and 30in QA7
2550 |  | Test 2 |  | Front GTC for 22in QA7, 26in QA7 and 30in QA7
7400A |  | Test 3 |  | Rear brushes for 22in QA7, 26in QA7 and 30in QA7
2700 |  | Test 4
2750
8800A
9009a
180/220E Hybrid walk behind
180/220/260SL
1600T Series 3
2653B
1200A/1200H
800 Aerator excluding Tines
Tractors
Tractor1
Tractor 2
Tractor 3
Spreadsheet: 844080d1695893621-little-help-with-excel-formatting-cadet-masterlist-draft-2
Sheet: School

ABB | SCHOOL | [NAME] | SYN | HP | MSI | PDG
AIFCP | Agro Industrial Foundation College of the Philippines | Davao City
APC | Aklan Polytechnic College | [NAME]
AIMS | Asian Institute of Maritime Studies | Pasay City
BMA | Baliwag Maritime Academy | Bulacan
CU | Capitol University | Cagayan de Oro City
CLCST | Central Luzon College of Science and Technology | Olongapo City
CPC | [NAME] | Roxas City
DMMA | Davao Merchant Marine Academy College Of Southern Philippines | Davao City
DYCI | Dr. [NAME]'s Colleges Inc. | Bulacan
FEATIU | FEATI University | Manila
IGCFI | Inter-Global College Foundation, Inc. | Quezon
[NAME] | [NAME] | Bacolod
JBLFMU | [NAME] Maritime University (Arevalo), Inc. | Iloilo City
JRMSU | [NAME] | Dapitan City
LIF | Lyceum of Iligan Foundation | Iligan City
LPU | Lyceum of the Philippines University - Lyceum International Maritime Academy | Batangas
MCL | [NAME] | Cabuyao
MPCF | Mariners' Polytechnic Colleges Foundation of Legaspi City (Albay) Inc. | Albay
MAAP | Maritime Academy of Asia and the Pacific | Mariveles, Bataan
MIDWAY | Midway Colleges Inc. | Cabanatuan City
MPC | Mindanao Polytechnic College | General Santos City
MU | Misamis University | Ozamiz City
NMCFI | Negros Maritime College Foundation Inc. | Negros Oriental
OLFU | Our Lady Of Fatima University | Valenzuela City
PIT | Palompon Institute of Technology | Leyte
PAMMA | Pangasinan Merchant Marine Academy | Pangasinan
PMMS | Philippine Merchant Marine School | Las Pinas City
PIMSAT | PIMSAT Colleges Inc. | Dagupan City
PNTC | PNTC Colleges | Dasmarinas, Cavite
TIP - ML | Technological Institute of the Philippines | Manila
TIP - QC | Technological Institute of the Philippines | Quezon City
UA | University of Antique | Antique
UC-METC | University of Cebu - M.E.T.C. | Cebu City
UI | University of Iloilo | Iloilo City
UPHSD | University of Perpetual Help System Dalta | Las Pinas City
UPHSL | University of Perpetual Help System Laguna | Binan City
WBC | West Bay College | Muntinlupa
ZSCMST | Zamboanga State College of Marine Sciences and Technology | Zamboanga City
VMA | VMA Global College and Training Centers, Inc.
Spreadsheet: darrell_schoolcraft__7801__imbalsumm0108
Sheet: by type

TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES |  |  |  |  |  | index
 |  |  |  |  |  | SJ
Positive=due [NAME] |  | Negative = due operator |  |  |  | AVG
 |  |  |  |  |  | NTXPH
DOLLAR VALUED IMBALANCES
 |  | Calc vol @ | CBS | Calc vol | As of
Operator | $[NAME] | [NAME] | Volume | less CBS vol | Date | Imbal Type | Mrktg rep | MS rep | Comments
West of Thoreau
Calpine |  |  |  |  |  | Dollar Valued |  | [NAME]
Citizens-Griffith |  |  |  |  |  | Dollar Valued |  | [NAME]
North Star Steel |  |  |  |  |  | Dollar Valued | M Lokay | [NAME]
Citizens Communications |  |  |  |  |  | Dollar Valued |  | [NAME]
Total WOT
San Juan
TransColorado |  |  |  |  |  | Dollar Valued |  | [NAME]
Burlington |  |  |  |  |  | Dollar Valued |  | [NAME] | balance is cashed out monthly
Total SJ
East of Thoreau
NNG |  |  |  |  |  | Dollar Valued | TK Lohman | [NAME]
Conoco |  |  |  |  |  | Dollar Valued |  | [NAME] | [NAME] and Maljamar
Amoco Abo |  |  |  |  |  | Dollar Valued |  | [NAME]
[NAME] |  |  |  |  |  | Dollar Valued |  | [NAME]
Duke/GPM |  |  |  |  |  | Dollar Valued |  | [NAME] | Crawford, Pecos Diamond, [NAME], Linam Ranch, Artesia
CIG |  |  |  |  |  | Dollar Valued |  | [NAME]
Mewborne |  |  |  |  |  | Dollar Valued |  | [NAME]
EPFS / PG&E TX |  |  |  |  |  | Dollar Valued | TK Lohman | [NAME]
PNM |  |  |  |  |  | Dollar Valued |  | [NAME]
EOG |  |  |  |  |  | Dollar Valued | L Lindberg | [NAME]
[NAME] |  |  |  |  |  | Dollar Valued | TK Lohman | [NAME] | cashed out monthly
Continental |  |  |  |  |  | Dollar Valued |  | [NAME]
El Paso Field Services |  |  |  |  |  | Dollar Valued |  | [NAME]
Agave |  |  |  |  |  | Dollar Valued |  | [NAME]
Total EOT
Total $ Value
TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES |  |  |  |  |  | index
 |  |  |  |  |  | SJ
Positive=due [NAME] |  | Negative = due operator |  |  |  | AVG
 |  |  |  |  |  | NTXPH
VOLUMETRIC IMBALANCES
 |  | Calc$ @curr | If $valued | Calc$ less | As of
Operator | Volume | Mo prices | amount | if $valued | Date | Imbal Type | Mrktg rep | MS rep | Comments
West of Thoreau
Mojave Pipeline |  |  |  |  |  | Volumetric |  | [NAME]
SoCal |  |  |  |  |  | Volumetric |  | [NAME]
PG&E Topock |  |  |  |  |  | Volumetric |  | [NAME]
Total WOT
San Juan
[NAME] |  |  |  |  |  | Volumetric |  | [NAME]
Red Cedar |  |  |  |  |  | Volumetric | L Lindberg | [NAME] | [NAME] is talking to Red Cedar about cash out
Amoco |  |  |  |  |  | Volumetric |  | [NAME]
El Paso |  |  |  |  |  | Volumetric |  | [NAME] | Blanco and Window Rock
Northwest |  |  |  |  |  | Volumetric |  | [NAME]
Total SJ
East of Thoreau
NGPL |  |  |  |  |  | Volumetric |  | [NAME]
Panhandle Eastern |  |  |  |  |  | Volumetric |  | [NAME] | Hansford
Oasis |  |  |  |  |  | Volumetric |  | [NAME]
Lonestar |  |  |  |  |  | Volumetric |  | [NAME]
Total EOT
Total Volumetric imbals
NET IMBAL AMOUNT
NET IMBAL VOLUME
Spreadsheet: 86830d1286804709-sorting-a-row-which-contais-data-repeted-atleast-once-exelprob-1-_swathyp
Sheet: Sheet2

NAME | DETAILS | Text to Columns > | Then sort  each column independently |  |  |  |  | Then get Unique Values > | From D | From E | From F | From G, ...etc |  | Copy the results and Paste Special > values into one column |  |  | Duplicate Values | Transposed and spaced to suit > | Duplicates > | 10A |  | Duplicates > | 10B |  | Duplicates > | BG |  | Duplicates > | FG |  | Duplicates > | XY
[NAME] | 10A,BG,XY |  | 10A | BG | XY |  |  |  | 10A | BG | XY | 0 |  | Filter out Blanks and zeros | 10A |  | 10A |  | [NAME] | 10A,BG,XY |  |  |  |  | [NAME] | 10A,BG,XY |  |  |  |  | [NAME] | 10A,BG,XY
mahesh | 10A,BG |  | 10A | BG | Xy |  |  |  |  |  |  | 0 |  | Copy the result to Duplicate Values column |  |  | 10B |  | mahesh | 10A,BG |  |  |  |  | mahesh | 10A,BG
paru | 10A,PC |  | 10A | BG |  |  |  |  |  |  |  |  |  | Remove the filter |  |  | BG |  | paru | 10A,PC
amal | 10B,BG |  | 10B | FG |  |  |  |  | 10B | FG |  |  |  |  | 10B |  | FG |  |  |  |  | amal | 10B,BG |  | amal | 10B,BG
swathy | 15C,FG |  | 10B | FG |  |  |  |  |  |  | 0 |  |  |  | BG |  | XY |  |  |  |  |  |  |  |  |  |  | swathy | 15C,FG
jinish | 15D,FG,Xy |  | 15D | LD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | jinish | 15D,FG,Xy |  | jinish | 15D,FG,Xy
nandhu | 16N,MC |  | 16N | LM
binu | 10B,LD |  | 17D | MC |  |  |  |  |  |  |  |  |  |  | FG |  |  |  |  |  |  | binu | 10B,LD
vinod | 18J,LM |  | 18J | PC |  |  |  |  |  |  |  |  |  |  | XY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 748996d1632451314-optimize-value-while-staying-in-budget-book1_optimize
Sheet: Converted

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MaxCost
 | Merged |  |  |  |  |  |  | Sorted on Value/Cost Ratio |  |  |  |  |  |  |  | 600
 | Items | Value | Cost | R | RV | RC |  | Items | Value | Cost | R | RV | RC |  | Select | Active_Cost | [NAME].Cost
 | A | 110 | 100 |  |  |  |  | Z | 50 | 10
 | B | 90 | 75 |  |  |  |  | K | 33 | 10
 | C | 85 | 74 |  |  |  |  | P | 15 | 5
 | D | 70 | 70 |  |  |  |  | V | 30 | 10
 | E | 60 | 50 |  |  |  |  | O | 17 | 6
 | F | 45 | 40 |  |  |  |  | N | 18 | 7
 | G | 40 | 30 |  |  |  |  | Y | 75 | 30
 | H | 39 | 30 |  |  |  |  | M | 19 | 8
 | I | 35 | 30 |  |  |  |  | L | 20 | 9
 | J | 34 | 20 |  |  |  |  | J | 34 | 20
 | K | 33 | 10 |  |  |  |  | G | 40 | 30
 | L | 20 | 9 |  |  |  |  | H | 39 | 30
 | M | 19 | 8 |  |  |  |  | B | 90 | 75
 | N | 18 | 7 |  |  |  |  | E | 60 | 50
 | O | 17 | 6 |  |  |  |  | I | 35 | 30
 | P | 15 | 5 |  |  |  |  | R | 115 | 100
 | Q | 150 | 150 |  |  |  |  | C | 85 | 74
 | R | 115 | 100 |  |  |  |  | W | 125 | 110
 | S | 100 | 90 |  |  |  |  | F | 45 | 40
 | T | 50 | 60 |  |  |  |  | S | 100 | 90
 | U | 45 | 50 |  |  |  |  | A | 110 | 100
 | V | 30 | 10 |  |  |  |  | D | 70 | 70
 | W | 125 | 110 |  |  |  |  | Q | 150 | 150
 | X | 100 | 100 |  |  |  |  | X | 100 | 100
 | Y | 75 | 30 |  |  |  |  | U | 45 | 50
 | Z | 50 | 10 |  |  |  |  | T | 50 | 60
Spreadsheet: darrell_schoolcraft__7824__imbalsumm0110
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 66647 | 66187
2 | 71935 | 71189
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-09-30 00:00:00 |  |  | 48683
2001-10-02 00:00:00
CBS Volume
 |  |  | -32354
Spreadsheet: darrell_schoolcraft__7802__imbalsumm0108
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 7793 | 6031 |  |  | 1235 | 1150 | 1454 | 1283
2 | 7791 | 6031 |  |  | 1177 | 1150 | 1476 | 1283
3 | 5994 | 6031 |  |  | 1174 | 1150 | 1523 | 1283
4 | 7564 | 6031 |  |  | 1155 | 1150 | 1485 | 1283
5 | 7266 | 6031 |  |  | 1111 | 1150 | 1460 | 1283
6 | 7106 | 6031 |  |  | 1102 | 1150 | 1390 | 1283
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  |  |  |  |  |  |  | 355533
2001-08-06 00:00:00
CBS Volume
 |  |  | 140156
Spreadsheet: 858806d1707342237-index-match-mmult-fomula-not-working-properly-formula-help
Sheet: Sheet1

1000 | Find Match
1000 | 2 | 3 | 5 | 449
 | 91 | 92 | 93 | 94 | 95 | 43
 | 96
 | 97 | 98 | 99 | 100 | 101
 | 97 | 98 | 99 | 100 | 101
 | 97 | 98 | 99 | 100 | 101
 | 97 | 98 | 99 | 100 | 101
 | 97 | 98 | 99 | 100 | 101
 | 102 | 104 | 417
 | 103 | 104 | 417
 | 102 | 103 | 104 | 417
 | 105 | 106 | 107 | 108 | 466
 | 105 | 106 | 107 | 108 | 466
 | 105 | 106 | 107 | 108 | 466
 | 105 | 106 | 107 | 108 | 466
 | 109
 | 110 | 111 | 112 | 415
 | 110 | 111 | 112 | 415
 | 110 | 111 | 112 | 415
 | 113 | 114 | 115 | 116 | 420
 | 113 | 114 | 115 | 116 | 420
 | 113 | 114 | 115 | 116 | 420
 | 113 | 114 | 115 | 116 | 420
 | 117 | 118 | 371
 | 117 | 118 | 371
 | 119
 | 120
 | 121 | 398
 | 122 | 123 | 403
 | 122 | 123 | 403
 | 124
 | 125 | 126 | 127 | 461
 | 125 | 126 | 127 | 461
 | 125 | 126 | 127 | 461
 | 128 | 129 | 130 | 459
 | 128 | 129 | 130 | 459
 | 128 | 129 | 130 | 459
 | 131 | 493
 | 132
 | 133 | 134 | 135 | 416
 | 133 | 134 | 135 | 416
 | 133 | 134 | 135 | 416 |  | 399
 | 136 | 137 | 388
 | 136 | 137 |  |  |  | 471
 | 138 | 139 | 140 | 141 | 142 | 471
 | 138 | 139 | 140 | 141 | 142 | 471
 | 138 | 139 | 140 | 141 | 142 | 471
 | 138 | 139 | 140 | 141 | 142 | 471
 | 138 | 139 | 140 | 141 | 142
 |  |  |  |  |  | 448
 |  |  |  |  |  | 448
 |  |  |  |  |  | 448
 |  |  |  |  |  | 448
 |  |  |  |  |  | 448
Spreadsheet: larry_campbell__21329__bid&offer_forms_jun2001
Sheet: Offeror

New York Independent System Operator
June 2001 Reconfiguration Transmission Congestion Contract Auction
Offer Form
 | Registrant Name: |  |  | Date:
 |  |  |  | Time:
Offer # | Number of | TCC Contract Number | Point of Injection | Point of Withdrawal | Minimum Offer Price
 | TCCs | From the Summary of Transmission Contracts | ("POI") (from the list | ("POW") (from the list | $/TCC
 | Offered for | dated 5-01-01 Posted on the NYISO Web site | in the auction "Rules") | in the auction "Rules") | OPTIONAL
 | sale | "REQUIRED" | (reference the | (reference the
 |  |  | PTID number) | PTID number)
 | Contact Name:
 | Company Name:
 | Company Address:
 | Contact E-Mail Address:
Spreadsheet: 275738d1383629923-how-to-use-more-than-2-values-in-vookup-as-inputs-parameters-sample
Sheet: Sheet1

 | Sale Quantity in numbers (Cumulative)
 |  | Sale Quantity
[NAME] | Customer name | Month1 | Month2 | Month3 | Month4
USA | Cust1 | 5000 | 5500 | 6500 | 7500
 | Cust2 | 4000 | 4500 | 5000 | 5500
 | Cust3 | 4000
UK | Cust3 |  | 6000 | 8000 | 8500
 | Cust4 | 2000 | 3500 | 4500 | 5000
 | Cust5 | 3500 | 4000
India | Cust5 |  |  | 2250 | 3000
 | Cust6 | 1500 | 2000 | 3000 | 3500
 | Cust7 | 2250 | 4000 | 5500 | 7250
 | My Question:
 | Given the location and the quantity (Please note that the quantity can be same value or in
 | between values given in column C6 to F14 e.g. 6000  which would fall in E7 for Loc USA)
 | as inputs can we findout the customer name and in which month the sale quantity falls
Spreadsheet: 126268d1319608243-automated-list-of-discrepancies-in-columns-and-arrays-separate-sheets-listsampleamended
Sheet: Actual

ID | State | Original Location?
99827 | PA
99828 | PA
99829 | PA
99830 | PA
99831 | PA
99832 | NY
99833 | NY
99834 | NY
99835 | PA
99836 | PA
99837 | NY
99838 | PA
99839 | PA
99840 | PA
99841 | PA
99842 | PA
47443 | NY
47444 | PA
47445 | PA
47448 | NY
47459 | PA
47480 | NY
Spreadsheet: 127656d1320443361-making-vlookup-persistent-sample-1-
Sheet: Key Tag Multi

 | 1 |  |  |  | 2 |  |  |  | 3
 | B14104 |  |  |  | B14105 |  |  |  | B14109
 | 01 Grand Am |  |  |  | 01 Century |  |  |  | 99 Grand Prix
 | Gold |  |  |  | White |  |  |  | Silver
 | 4 |  |  |  | 5 |  |  |  | 6
 | B14111 |  |  |  | B14112 |  |  |  | [NAME]
 | 03 Sable Wagon |  |  |  | 03 Durango |  |  |  | 00 Grand Caravan
 | Red |  |  |  | Grey |  |  |  | Gold
 | 7 |  |  |  | 8 |  |  |  | 9
 | [NAME] |  |  |  | B14120 |  |  |  | B14121
 | 00 Explorer |  |  |  | 02 Regal |  |  |  | 02 Alero
 | Green |  |  |  | Silver |  |  |  | Red
 | 10 |  |  |  | 11 |  |  |  | 12
Spreadsheet: 268290d1380554228-comparing-ranges-and-returning-non-common-items-ef490_missing_products
Sheet: Sheet1

Table 1 | Table 2 |  |  | Missing
Product A | Product A
Product B | Product C
Product C | Product E
Product D | Product G
Product E | Product M
Product F
Product G
Product H
Product I
Product J
Spreadsheet: 852841d1702818842-how-to-adjust-the-dependent-drop-down-list-to-4-levels-of-multiple-words-per-cell-multi-row-drop-downs-access-analytic
Sheet: Inputs

 | 1st Drop Down Ref | Helper1 (1st Selection) | Helper1 (1st Selection) | 2nd DropDown Ref | Helper 2 (2nd Selection) | 3rd DropDown Ref
 | List |  | dd1_row |  |  | dd2_row
 | tbl_dd1 | Row of 1st Selection | Reference of 1st Selection | 2nd Selection Table | Row of 2nd Selection | tbl_dd3 | dd2Check | dd3Check | 1st Choice | Dependent Drop Down (Level 1) | Dependent Drop Down (Level 2)
 |  |  |  |  |  |  |  |  | Coffee | Filter | Filter - 200g
 |  |  |  |  |  |  |  |  | Bottle / Can | Cola | Coke - Zero
 |  |  |  |  |  |  |  |  | Bottle / Can | Water | Sparkling -Ty Nant
 |  |  |  |  |  |  |  |  | Coffee | Espresso | [NAME]
 |  |  |  |  |  |  |  |  | Tea | English Breakfast
Spreadsheet: 158140d1338001416-comparing-rows-between-two-sheets-comparingsheets
Sheet: SheetB

ParentB | ChildB | HelperB
1001 | 1002
1003 | 1001
1003 | 1002
1004 | 1010
1004 | 1011
1008 | 1015
Spreadsheet: 135604d1326135549-formula-to-find-records-based-on-other-values-in-group-book3
Sheet: Sheet2

ID | GROUP | STATUS
Spreadsheet: 815709d1675164244-looking-for-formula-that-filters-upcoming-due-dates-that-havent-been-filed-sample4
Sheet: Sheet1

 |  |  |  |  | Upcoming Dues |  |  |  | Result I would like to see …
Document # | Filed | Due Date |  |  | Document # | Filed | Due Date |  | Document # | Filed | Due Date
Document 1 | NO | 2023-01-31 00:00:00 |  |  |  |  |  |  | Document 1 | NO | 2023-01-31 00:00:00
Document 2 | NO | 2023-02-05 00:00:00 |  |  |  |  |  |  | Document 2 | NO | 2023-02-05 00:00:00
Document 3 | YES | 2023-02-05 00:00:00 |  |  |  |  |  |  | Document 4 | NO | 2023-02-15 00:00:00
Document 4 | NO | 2023-02-15 00:00:00 |  |  |  |  |  |  | Document 5 | NO | 2023-02-15 00:00:00
Document 5 | NO | 2023-02-15 00:00:00