tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 10688e21-50c7-42b3-9f2f-b7d2c537a667
Sheet: Non-Western

 |  |  | NON-WESTERN |  | COURSES IN RED  ARE FALL  2012   PURPLE J-TERM   GREEN BOTH FALL & J-TERM
ARTH | ARTH 210 |  | counts as HIST101, cross-listed with CLAS 210 |  | INST | INST 245 |  | cross-listed with EVST 245
 | ARTH 211 |  | cross-listed with CLAS 211 |  |  | INST 483 |  | Spring 2006, cross-listed with HIST 481
 | ARTH 227
 | ARTH 228 |  |  |  | JAPN | JAPN 220
 | ARTH 235 |  |  |  |  | JAPN 221 |  | cross-listed with HIST 221
 |  |  |  |  |  | JAPN 381 & 382
ASTU | ASTU 230 |  | cross-listed with FLET 230
 | ASTU 231 |  | cross-listed with FLET 231 |  | MATH | MATH 270
 | ASTU 232 |  | cross-listed with FLET 232
 | ASTU 290 |  | cross-listed with HIST 290 |  | MUSC | MUSC 240
 | ASTU 292 |  | cross-listed with FILM 292
 | ASTU 381 |  | Spring 2009 (Japanese Literature: [NAME])
 | ASTU 390 |  |  |  | PHIL | PHIL 220
BLST | BLST 160 |  |  |  |  | PHIL 343
 |  |  |  |  |  | PHIL 381 |  | Spring 2010 (Confucian Tradition)
CHIN | CHIN 221
CLAS | CLAS 210 |  | counts as HIST101, cross-listing with ARTH 210 |  | PSCI | PSCI 328
 | CLAS 211 |  | cross-listed with ARTH 211 |  |  | PSCI 333
 |  |  |  |  |  | PSCI 334
 |  |  |  |  |  | PSCI 335
COMM | COMM 332 |  |  |  |  | PSCI 336
 |  |  |  |  |  | PSCI 337
ECON | ECON 481 |  | Fall 2009 (Contemporary China's Economy) |  |  | PSCI 338
 |  |  |  |  |  | PSCI 381 |  | Spring 2011 (Political Islam in the Middle East)
ENGL | ENGL 272
 | ENGL 369
 | ENGL 370 |  |  |  | PSYC | PSYC 160
 |  |  |  |  |  | PSYC 162
EVST | EVST 245 |  | cross-listed with INST 245 |  |  | PSYC 175
 |  |  |  |  |  | PSYC 180
FILM | FILM 292 |  | cross-listed with ASTU 292 |  |  | PSYC 186
FLET |  |  |  |  | RELS | RELS 221
 | FLET 230 |  | cross-listed with ASTU 230 |  |  | RELS 223
 | FLET 231 |  | cross-listed with ASTU 231 |  |  | RELS 225
 | FLET 232 |  | cross-listed with ASTU 232 |  |  | RELS 229
 | FLET 248 |  |  |  |  | RELS 245
 | FLET 249 |  |  |  |  | RELS 248
HIST
 | HIST 100 |  | Modern Iraq only |  | SOCI | SOCI 210
 | HIST 221 |  | cross-listed with JAPN 221; J-Term 11 Travel |  |  | SOCI 215
 | HIST 251 |  |  |  |  | SOCI 230
 | HIST 252 |  |  |  |  | SOCI 260
 | HIST 281 |  |  |  |  | SOCI 265
 | HIST 282 |  |  |  |  | SOCI 273 |  | J-Term 2012 Society/Environment in Brazil
 | HIST 290 |  |  |  |  | SOCI 270 |  | cross-listed with PSYC 180 - deleted Spring 2007
 | HIST 320 |  |  |  |  | SOCI 383 |  | J-Term 2009, 2011 (Global, Env, Social Dynamics Brazil)
 | HIST 332 |  |  |  |  | SOCI 383 |  | J-Term 2008, 2010 (Globalization & Social Change Ghana)
 | HIST 347
 | HIST 348 |  |  |  | HONR | HONR 215
 | HIST 361 |  |  |  |  | HONR 259
 | HIST 365 |  |  |  |  | HONR 290
 | HIST 367
 | HIST 382 |  | Native American History
 | HIST 391
 | HIST 392
 | HIST 394
 | HIST 396
 | HIST 397
Spreadsheet: 865615d1712661503-new-invoice-allocation-register-test-invoice-allocation-register-emmagizer-amended-1-aligw
Sheet: All jobs

 |  |  |  | JN23/002 | JN23/001 | JN23/001 | JN23/002 | JN23/003 | JN23/003 | JN23/001 | JN23/004 | JN23/003
PO | PO Description | PO status | PO Value  (ex GST) | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-07-31 00:00:00 | 2023-07-31 00:00:00 | 2023-08-29 00:00:00 | 2023-08-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-14 00:00:00 | PO Balance | Comments
 |  |  |  | 4211358 | 1611994 | 1625078 | 4219458 | 240035 | 240087 | 1638146 | 1638138 | 240141
 |  |  |  | 3012 | 2295 | 1000.5 | 3348 | 5403.6 | 1553.8 | 564 | 4017 | -529.2
 |  |  |  | PAID | APPROVED | PAID | APPROVED | PENDING APPROVAL | PENDING APPROVAL | QUERY/ISSUE | APPROVED | PENDING APPROVAL
3926 | JN23/001 Insurance claim (Quote 27/9/2023) | Open | 1997.5
3814 | JN23/001 Insurance claim (Quote 23/05/2023) | Open | 5300 |  | 2295 | 1000.5 |  |  |  | 564 |  |  |  | PO to be closed
3857 | JN23/002 - Supply agreement template (Quote 13/7/2023) | Open | 3960 |  |  |  | 3348
3788 | JN23/002 -Supply agreement template (Quote 19/4/2023) | Open | 3620 | 3012
3856 | JN23/003 Request for access to documents (Quote 5/7/2023) | Open | 6599 |  |  |  |  | 5403.6 | 1553.8 |  |  | -529.2
3874 | JN23/003 Request for access to documents (Quote 1/8/2023) | Open | 6984
3880 | JN23/004 Termination advice (Quote 9/8/2023) | Open | 4825 |  |  |  |  |  |  |  | 4017
3931 | JB23/005 Insurance claim 2 | Open | 3170
 |  |  | BALANCE/CHECK
Back to Register
Spreadsheet: fe07adfc-56b0-489e-b0bc-8eb3a8a36a7a
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42822410 | 2014-08-21 21:59:58 | AXIS | 0 | 2 | 6 | 357537 | Praxeo | 6154 | mediterranean | 1944-08-20 | 1944-08-26 | Toulon | Toulon
42822715 | 2014-08-21 22:20:53 | ALLIES | 0 | 4 | 6 | 357537 | Praxeo | 6154 | mediterranean | 1944-08-20 | 1944-08-26 | Toulon | Toulon
Spreadsheet: 143578d1330465063-look-up-a-value-with-multiple-criteria-theoretically-should-be-a-simple-index-match-excel-forum-example2
Sheet: Sheet1

Employees' Work Schedule
 | [NAME] | Becky | [NAME] | [NAME]
2012-02-23 00:00:00 |  |  |  |  |  | 1. =INDEX(Sheet2!$B$2:$I$15,MATCH($A3,Sheet2!$A$2:$A$15,0),MATCH(B$2,Sheet2!$B$1:$I$1,0))
2012-02-26 00:00:00
2012-02-28 00:00:00
2012-03-02 00:00:00
2012-03-05 00:00:00
2012-03-06 00:00:00
NOTE: Data source is on "Sheet2"
Spreadsheet: 45649d1244464241-grabbing-data-from-a-cell-on-another-worksheet-if-workbook_fault_example-1-
Sheet: IHT411

description | holding | min price |  |  |  |  | Sort IDS
UNITED KINGDOM(GOVERNMENT OF) 4% STK 07/03/2009 GBP100 | 10000 | 100 |  |  |  |  | 1 | 2 | 3 |  |  | 6
ELECTRIC & GENERAL INV TST PLC ORD GBP0.05 | 2000 | 150
MONKS INVESTMENT TRUST ORD GBP0.05 | 350 | 25
Pearson PLC | 4000 | 400
UNITED KINGDOM(GOVERNMENT OF) 4% STK 07/03/2009 GBP100 | 5000 | 700
ELECTRIC & GENERAL INV TST PLC ORD GBP0.05 | 1000 | 450
Spreadsheet: 71120d1271851789-merge-cells-maybe-then-delete-duplicates-726060
Sheet: Currently

 | Part number | Part Name | Rev Level |  | Part number
40 | 0000123 | CYL BLK CORE | 4 |  | 0000123 | x5 | CYL BLK CORE | 4
41 | 0000222 | CYL BLK CAST [NAME] | 4 |  | 0000222 | x2 | CYL BLK CAST [NAME] | 4
42 | 0000123 | CYL BLK CORE | 4 |  | 0000333 | x2 | CYL BLK CAST [NAME] | 4
43 | 0000333 | CYL BLK CAST [NAME] | 4 |  | 0000444 | [NAME] | CYL BLK CAST WTR CORE | 4
44 | 0000123 | CYL BLK CORE | 4 |  | 0000555 | [NAME] | CYL BLK CAST MACH REF | 4
45 | 0000444 | CYL BLK CAST WTR CORE | 4 |  | 0000777 | x1 | CYL BLK CAST RT CORE | 4
46 | 0000555 | CYL BLK CAST MACH REF | 4
47 | 0000444 | CYL BLK CAST WTR CORE | 4
48 | 0000555 | CYL BLK CAST MACH REF | 4
49 | 0000222 | CYL BLK CAST [NAME] | 4
50 | 0000123 | CYL BLK CORE | 4
51 | 0000333 | CYL BLK CAST [NAME] | 4
52 | 0000123 | CYL BLK CORE | 4
53 | 0000444 | CYL BLK CAST WTR CORE | 4
54 | 0000555 | CYL BLK CAST MACH REF | 4
55 | 0000777 | CYL BLK CAST RT CORE | 4
Spreadsheet: 127270d1320262174-excel-2008-line-chart-interval-engcbrcdr
Sheet: Sheet1

England
 | 1750 | 1800 | 1850 | 1875 | 1900 | 1925 | 1950 | 1975 | 1993
CBR | 40 | 34 | 34 | 33 | 28 | 18 | 16 | 13 | 13
CDR | 40 | 20 | 22 | 22 | 16 | 13 | 12 | 12 | 12
Spreadsheet: 796794d1663540298-average-formula-using-table-references-instead-of-ranges-with-unconventional-data-table-test-hd
Sheet: Section 2

Name | Ref | Year | Sept | March |  |  | Year | Sept | March | Average
Name 1 | C | 2016-2017 | -1/0 | 1/8 |  | AVERAGE | 2016-2017
Name 2 | C | 2016-2017 | 0/5 | 0/6 |  | AVERAGE | 2017-2018
Name 3 | C | 2016-2017 | 1/7 | 3/2 |  | AVERAGE | 2018-2019
Name 4 | C | 2016-2017 | 1/9 | 2/11 |  | AVERAGE | 2019-2020
Name 5 | C | 2016-2017 | -1/5 | -0/11 |  | AVERAGE | 2020-2021
Name 6 | C | 2016-2017 | 1/0 | 1/1 |  | AVERAGE | 2021-2022
Name 7 | C | 2017-2018 | 1/1 | 4/7
Name 8 | C | 2017-2018 | -0/7 | 1/1
Name 9 | C | 2017-2018 | 0/10 | 0/7
Name 10 | C | 2017-2018 | 3/5 | 3/1
Name 11 | C | 2017-2018 | -0/4 | 1/4
Name 12 | C | 2017-2018 | 0/6 | 1/7
Name 13 | H | 2018-2019 | 3/3 | 3/8
Name 14 | H | 2018-2019 | -0/5 | 0/1
Name 15 | H | 2018-2019 | 0/9 | 1/4
Name 16 | H | 2018-2019 | 0/4 | 1/1
Name 17 | H | 2018-2019 | 2/4 | 1/6
Name 18 | H | 2018-2019 | 1/11 | 2/9
Name 19 | D | 2019-2020 | 0/3 | 2/10
Name 20 | D | 2019-2020 | 3/8 | 3/5
Name 21 | D | 2019-2020 | 1/1 | 3/9
Name 22 | D | 2019-2020 | -0/9 | 1/1
Name 23 | D | 2019-2020 | 0/1 | 1/0
Name 24 | D | 2019-2020 | 1/6 | 1/8
Name 25 | D | 2019-2020 | 1/2 | 2/2
Name 26 | G | 2019-2020 | -0/1 | 2/2
Name 27 | G | 2020-2021 | 2/7 | 2/3
Name 28 | G | 2020-2021 | 2/1 | 1/5
Name 29 | G | 2020-2021 | -1/5 | -0/10
Name 30 | G | 2020-2021 | -1/3 | 0/1
Name 31 | G | 2020-2021 | -0/3 | 0/0
Name 32 | G | 2020-2021 | 0/2 | -0/4
Name 33 | M | 2021-2022 | 1/1 | 1/11
Name 34 | M | 2021-2022 | 1/0 | 1/1
Name 35 | M | 2021-2022 | 2/1 | 2/10
Name 36 | M | 2021-2022 | 0/4 | 0/0
Name 37 | M | 2021-2022 | 2/9 | 1/11
Name 38 | M | 2021-2022 | 0/6 | 0/11
Name 39 | M | 2021-2022 | -1/5 | -1/6
Name 40 | M | 2021-2022 | 0/7 | 1/10
 |  | Average
Spreadsheet: 687573d1595280496-formula-help-if-countif-vlookup-2020-07-20-oeldere-vmj222-687552d1595272160-formula-help-if-countif-vlookup-excel-example
Sheet: month

month | Tone | Media Inquiries Rec'd
4 | Neutral | Yes
4 | Mention
4 | Mention |  |  |  |  | Count Media Inquiries Rec'd | Kolomlabels
4 | Advertising | Yes |  |  |  | Rijlabels | 4 | 5 | Eindtotaal
4 | Positive |  |  |  |  | Advertising | 1 |  | 1
4 | Advertising |  |  |  |  | Yes | 1 |  | 1
4 | Neutral | Yes |  |  |  | (leeg)
5 | Positive | Yes |  |  |  | Mention |  | 1 | 1
5 | Mention | Yes |  |  |  | Yes |  | 1 | 1
5 | Positive |  |  |  |  | (leeg)
5 | Neutral |  |  |  |  | Neutral | 2 |  | 2
5 | Mention |  |  |  |  | Yes | 2 |  | 2
 |  |  |  |  |  | (leeg)
 |  |  |  |  |  | Positive |  | 1 | 1
 |  |  |  |  |  | Yes |  | 1 | 1
 |  |  |  |  |  | (leeg)
 |  |  |  |  |  | Eindtotaal | 3 | 2 | 5
Spreadsheet: michelle_lokay__26569__imbalsumm0012
Sheet: Conoco

 | Maljamar |  | Zia
Day | Measured | Scheduled | Measured | Scheduled
1 | 29632 | 30000 | 22925 | 25000
2 | 19946 | 30000 | 25047 | 25000
3 | 24779 | 29992 | 18690 | 24993
4 | 22643 | 30000 | 17753 | 25000
5 | 25628 | 30000 | 17735 | 25000
6 | 26763 | 30000 | 32416 | 25000
7 | 27062 | 30300 | 36668 | 25000
8 | 28834 | 29390 | 37663 | 32222
9 | 29402 | 30000 | 34971 | 25000
10 | 29274 | 30000 | 33463 | 25000
11 | 27694 | 30000 | 33683 | 25000
12 | 24700 | 30000 | 27303 | 31000
13 | 28925 | 29989 | 30174 | 30989
14 | 29257 | 30000 | 31971 | 28000
15 | 30136 | 29981 | 34927 | 24984
16 | 29674 | 30000 | 34403 | 28000
17 | 29616 | 30000 | 33558 | 28000
18 | 29698 | 30000 | 31944 | 28000
19 | 27720 | 30000 | 34470 | 28000
20
21
22
23
24
25
26
27
28
29
30
31
2000-11-30 00:00:00 |  | 622338.78 |  | -1050867.92
2000-12-19 00:00:00
Spreadsheet: 134359d1325248887-function-and-percentage-issue-microsoft-office-excel-worksheet
Sheet: Sheet1

 | MEN | WOMEN | TOTAL
ATHENS | 3000000 | 4000000
PATRA | 150000 | 100000
THESSALONIKI | 1500000 | 1750000
[NAME] | 15000 | 30000
GIANNENA | 50000 | 10000
[NAME] | 300 | 500
Κ.Δ DESPHINA | 700 | 600
RETHYMNO | 17000 | 16000
Κ.Δ PYLI | 15000 | 13000
Spreadsheet: 883510d1732120504-calculating-percentage-returns-over-different-intervals-stock-returns
Sheet: Monthly Returns

Date_T1 | 01/02/2024
Date_T2 | 11/18/2024
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | January | February | March | April | May | June | July | August | September | October | November | December
AMD
AVGO
NVDA
BRO
MMC
CMG
AAPL
MSFT
MA
V
MCO
BAC
JPM
COST
LULU
TSMC
TSLA
WKHS
SPY
VOO
 | =IF(AND(VALUE(LEFT('Monthly Returns'!$B$2,FIND("/",$B$2)-1))='Historical Data'!$W:$W,VALUE(RIGHT('Monthly Returns'!$B$2,4)),'Historical Data'!$V:$V),1,0)
 | =INDEX('Historical Data'!$B$1:AE1260,SMALL(IF((VALUE(LEFT($B$2,FIND("/",$B$2)='Historical Data'!$W:$W)*(VALUE(RIGHT('Monthly Returns'!$B$2,4))='Historical Data'!$V:$V),ROW(A:A),""),1))
 | =INDEX(E:E,SMALL(IF((A1>=C:[NAME]:D),ROW(A:A),""),1))
 | INDEX('Historical Data'!$B$1:U1260,MINIFS('Historical Data'!$B:$B,'Historical Data'!$X:$X,VALUE(LEFT('Monthly Returns'!$B$2,FIND("/",'Monthly Returns'!$B$2)-1)),'Historical Data'!$W:$W,VALUE(RIGHT('Monthly Returns'!$B$2,4))),MATCH('YTD Returns'!$A5,'Historical Data'!$B$1:$U$1,0))
 | =MINIFS('Historical Data'!$B:$B,'Historical Data'!$X:$X,VALUE(LEFT('Monthly Returns'!$B$2,FIND("/",'Monthly Returns'!$B$2)-1)),'Historical Data'!$W:$W,VALUE(RIGHT('Monthly Returns'!$B$2,4)))
Spreadsheet: 701590d1603821796-subtracting-time-sample-1-
Sheet: Sheet2

Date | Time (Start) | Time (End) | Subtraction | Hours | Minutes | Seconds
2015-10-22 00:00:00 | 2015-10-22 13:30:00 | 2015-10-22 19:30:00 | 06:00:00 | 6 | 0 | 0
2015-10-24 00:00:00 | 2015-10-24 10:10:00 | 2015-10-24 16:10:00 | 06:00:00 | 6 | 0 | 0
2015-11-07 00:00:00 | 2015-11-07 19:50:00 | 2015-11-08 19:50:00 | 1900-01-01 00:00:00 | 0 | 0 | 0
2015-11-24 00:00:00 | 2015-11-24 17:00:00 | 2015-11-24 00:00:00 | 1899-12-29 07:00:00 | -17 | 0 | 0
2015-12-03 00:00:00 | 2015-12-03 15:30:00 | 2015-12-03 00:00:00 | 1899-12-29 08:30:00 | -15 | -30 | 0
2015-12-22 00:00:00 | 2015-12-22 00:00:00 | 2015-12-22 00:00:00 | 00:00:00 | 0 | 0 | 0
Spreadsheet: hunter_shively__12662__Nov_01 Volume Changes
Sheet: Nov 16

Pipeline | Producer | Deal | Zone | Current Volume | New Volume | Change | Index | GDA
ANR | Spinnaker | 1139883 | Gath | 2331 | 1000 |  | -865 | -466
ANR | Ralaco | 969536 | Gath | 2308 | 2314 |  |  | 6
ANR | Riceland | 969604 | Gath | 4000 | 4015 |  |  | 15
FGT | Riverside | 1142968 | Zone 1 | 2158 | 2000 |  |  | -158
SNAT | Linder | 1135987 | Holly Beach | 4002 | 4000 |  |  | -2
TENN | KCS | 954745 | Zone 100 | 363 | 229 |  |  | -134
TENN | KCS | 954753 | Zone 100 | 417 | 0 |  |  | -417
TENN | Linder | 1136017 | Zone 500 | 535 | 500 |  |  | -35
TETCO | Riverside | 1142943 | ELA | 6900 | 7000 |  |  | 100
TETCO | Cohort | 1139749 | ETX | 1 | 10000 |  | 9999 |  | Had been off line due to water
TRCO | Linder | 1136009 | [NAME] | 400 | 300 |  |  | -100
TRCO | Tristar | 1139955 | Z3 | 728 | 709 |  |  | -19
TRNKL | Nexen | 1131034 | ELA | 5000 | 4400 |  |  | -600 | Flash Gas
 |  |  |  |  |  | Daily Total
 |  |  |  |  |  | MTD Total | -36378 | 38281
Spreadsheet: 105609d1302901519-data-formatting-copy-of-book1
Sheet: Raw data

Trip000R00909001
123456 | Trip000R00909001
123457 | Trip000R00909001
123567 | Trip000R00909001
123456 | Trip000R00909001
123457 | Trip000R00909001
123567 | Trip000R00909001
123456 | Trip000R00909001
123457 | Trip000R00909001
TripM000002
123456 | TripM000002
123457 | TripM000002
123567 | TripM000002
123456 | TripM000002
123457 | TripM000002
123567 | TripM000002
123456 | TripM000002
123457 | TripM000002
TripM000003
T123456 | TripM000003
T123457 | TripM000003
123567T | TripM000003
Spreadsheet: 811099d1672278932-hide-row-hide-empty-row
Sheet: Sheet1

 | No. | Name | Matric No. | Math | Sc | Arts | Eng | Geog | History
 | 1 | [NAME] | 68751
 | 2 | Alexandra | 41803
 | 3 | [NAME] | 20636
 | 4 | Amanda | 34789
 | 5 | Amelia | 76662
 | 6 | [NAME] | 26158
 | 7 | [NAME] | 95100
 | 8 | [NAME] | 21301
 | 9 | Anna | 96074
 | 10 | Anne | 89705
 | 11 | [NAME] | 17900
 | 12 | Ava | 90594
 | 13 | [NAME] | 13064
 | 14 | [NAME] | 12687
 | 15 | Carol | 80939
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
Spreadsheet: 546148d1509895862-having-issue-with-drop-down-that-can-retreive-data-data-validation-punch-in-punch-out
Sheet: whats desired

2017-10-23 00:00:00 |  |  | [NAME]
all data as It relates to that employee appears as such after drop down chosen
date | Name | Duration | Punch in | Punch out
Spreadsheet: 196a3eec-fdb3-408f-beee-f2fa3651227a
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44459013 | 2014-12-15 21:10:55 | AXIS | 0 | 4 | 6 | 1007775 | [NAME] | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
44459370 | 2014-12-15 21:29:32 | ALLIES | 1 | 6 | 2 | 1007775 | [NAME] | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
44460749 | 2014-12-15 23:03:53 | AXIS | 0 | 4 | 6 | 1239735 | Vaillants | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
44461197 | 2014-12-15 23:31:13 | ALLIES | 1 | 6 | 5 | 1239735 | Vaillants | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
44486471 | 2014-12-17 20:55:12 | AXIS | 1 | 6 | 3 | 225841 | sacas | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
44486786 | 2014-12-17 21:22:29 | ALLIES | 0 | 5 | 6 | 225841 | sacas | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
44500130 | 2014-12-18 21:48:12 | ALLIES | 0 | 4 | 6 | 1682958 | player1682958 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
44500442 | 2014-12-18 22:09:24 | AXIS | 0 | 4 | 6 | 1682958 | player1682958 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
44510699 | 2014-12-19 17:36:18 | ALLIES | 0 | 4 | 6 | 478428 | Endicott | 12503 | eastern | 1941-07-22 | 1941-07-22 | Lipovec | Lipovec
44511326 | 2014-12-19 18:18:36 | AXIS | 1 | 7 | 5 | 901544 | manu76 | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
44511537 | 2014-12-19 18:44:17 | ALLIES | 0 | 6 | 7 | 901544 | manu76 | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
44511957 | 2014-12-19 19:18:44 | AXIS | 1 | 6 | 1 | 478428 | Endicott | 12503 | eastern | 1941-07-22 | 1941-07-22 | Lipovec | Lipovec
Spreadsheet: 164451d1340777082-ranking-from-different-sheets-at-the-same-time-example
Sheet: Results

Rank | Company | Sales
1 | Monoprix | 100000
2 | Mazda | 70000
3 | [NAME] | 50000
4 | CCC | 30000
5 | ACC | 20000
6 | Azadea | 15000
Spreadsheet: 789373d1659064936-need-help-to-distribute-amount-as-per-day-difference-duty-exmp
Sheet: Scenario 2

 | Duty Amount | Debit | Credit | Duty Date |  | Duty Amount | Debit | Credit | Duty Date
 | 0 |  |  | 2020-09-19 00:00:00 |  | 0 |  |  | 2020-09-19 00:00:00
 | 528.08 |  |  | 2020-10-13 00:00:00 |  | 528.08 |  |  | 2020-10-13 00:00:00
 | 1252.08 |  |  | 2020-11-20 00:00:00 |  | 1252.08 | 1153.23 |  | 2020-11-20 00:00:00 |  | 35
 | 864.08 |  |  | 2020-12-14 00:00:00 |  | 864.08 | 864.08 |  | 2020-12-14 00:00:00
 | 854.09 |  |  | 2021-01-09 00:00:00 |  | 854.09 | 854.09 |  | 2021-01-09 00:00:00
 | 995.07 |  |  | 2021-02-12 00:00:00 |  | 995.07 | 995.07 |  | 2021-02-12 00:00:00
 | 628.11 |  |  | 2021-03-02 00:00:00 |  | 628.11 | 628.11 |  | 2021-03-02 00:00:00
 | 686.83 |  |  | 2021-03-27 00:00:00 |  | 686.83 | 686.83 |  | 2021-03-27 00:00:00
 | 791.2 |  |  | 2021-04-26 00:00:00 |  | 791.2 | 791.2 |  | 2021-04-26 00:00:00
 | 718.04 |  |  | 2021-05-25 00:00:00 |  | 718.04 | 718.04 |  | 2021-05-25 00:00:00
 | 727 |  |  | 2021-06-25 00:00:00 |  | 727 | 703.5483870967741 | 23.45161290322585 | 2021-06-25 00:00:00 |  | 30
 | 5812.24 |  |  | 2021-07-24 00:00:00 |  | 5812.24 |  | 5812.24 | 2021-07-24 00:00:00
 | 7404.36 |  |  | 2021-08-26 00:00:00 |  | 7404.36 |  | 7404.36 | 2021-08-26 00:00:00
 | 6131.32 |  |  | 2021-09-27 00:00:00 |  | 6131.32 |  | 6131.32 | 2021-09-27 00:00:00
 | 5814.71 |  |  | 2021-10-30 00:00:00 |  | 5814.71 |  | 5814.71 | 2021-10-30 00:00:00
 | 4130.82 |  |  | 2021-12-01 00:00:00 |  | 4130.82 |  | 4130.82 | 2021-12-01 00:00:00
Extra Duty Collection Date From | 2020-10-17 00:00:00 | To | 2021-06-24 00:00:00
Duty Relief Date From | 2021-06-25 00:00:00 | To | 2023-06-24 00:00:00 |  | >> If Dates range are as shown in Cell B22, D22, B23 and D23 then expected result should be as shown in H2:I21
 |  |  |  |  | >> Please Check the Sheet Scenario 1 also
 |  |  |  |  | So I need the formula which can give the both results as per shown in Scenario 1 and Scenario 2
Spreadsheet: 588035d1535455316-using-index-function-with-multiple-input-values-spreadsheet-select-v4
Sheet: Type D

Size | 100 | 125 | 150 | 175 | 200 | 225 | 250 | 275 | 300 | 325 | 350
Length | 200 | 250 | 300 | 350 | 400 | 450 | 500 | 550 | 600 | 650 | 700
[NAME] | 350 | 500 | 650 | 800 | 950 | 1100 | 1250 | 1400 | 1550 | 1700 | 1850
Spreadsheet: 812053d1672931208-find-characters-in-cells-and-return-specified-text-example
Sheet: Sheet2

Colour Code
BE0001
BE0002
BE0003
BE0004
BE0005
BE0006
BE0007
BE0008
BE0009
BE0010
BE0011
BE0012
BE0013
BE0015
BE0016
BE0018
BE0019
BE0021
BE0022
BE0024
BE0025
BE0027
BE0028
BE0030
BE0031
BE0032
BE0033
BE0034
BE0035
BE0037
BE0040
BE0042
BEBE01
BEBE02
[NAME]
BERD01
BERD02
BERD03
BEWE01
BEWE02
BEWE03
BEWE04
BEWE06
BK0001
BK0008
BKBE01
BKBE02
BKBN01
BKBN02
BKGN01
BKGY01
BKGY02
BKMC01
BKNL01
BKPK01
BKRD01
BKRD04
BKWE01
BKWE02
BKWE03
BKWE09
BKWE10
BKWE11
BN0001
BN0002
BN0003
BN0004
BN0005
BN0006
BN0007
BN0008
BN0009
BN0010
BN0011
BN0012
BN0013
BN0014
BN0015
BN0016
BN0017
BN0018
BN0019
BN0022
CCBE01
CCBK01
CCGN01
CCOR01
CCRD01
DM001W
EU0001
GN0001
GN0002
GN0003
GN0004
GN0005
GN0006
GN0007
GN0008
GN0009
GN0010
GN0011
GN0012
GN0013
GN0014
GN0015
GN0016
GN0019
GN0020
GN0024
GN0026
GN0028
GN0029
GN0030
GN0031
GN0032
GN0034
GN0035
GN0036
GN0037
GN0040
GN0041
GN0047
GN0049
GNBK01
GNBK04
GNBK06
GNPK04
GNWE01
GNWE02
GY0001
GY0002
GY0003
GY0004
GY0005
GY0006
GY0014
GY0015
GY001M
GY001W
GY002M
GY003M
GY004M
GY005M
GY006M
GY007M
GY008M
GY009M
GY010M
GY012M
I0004W
IN0007
IN001W
IN002W
IN006W
IO0001
IO0005
[NAME]
IO001W
IO002W
IO003W
IO004W
IO005W
LD0001
LDBE01
LDBK01
LDGN01
LDOR01
LDRD01
MC0001
MC0002
MC0003
MC0004
MC0005
MC0006
MC0011
MC0012
MC0013
MC0015
MC0017
MC0018
MC0021
MC0022
MCBK03
MCBK04
MI0001
[NAME]
MLBK01
NL0001
NL0002
NL0003
NL0006
NL0007
NL0008
NL0011
NL0014
NL001M
NLBE01
NLBE02
NLBK01
NLBK03
NLBN01
NLBN06
NLBNO1
NO0001
OE0001
OE0002
OE0003
OE0004
OE0008
OEWE01
OEWE03
PE0001
PE0002
PE0003
PE0004
PE0006
PE0007
PE0010
PE0011
PE0014
PE0015
PEMC01
PK0001
PK0002
PK0003
PK0004
PK0005
PK0006
PK0008
PK0013
PK0014
PK0015
PK0017
PK0020
PK0022
PT0001
PT0002
PT0003
PT0004
PT0005
PT0006
PT0007
PT0008
PT0009
RD0001
RD0002
RD0003
RD0004
RD0005
RD0006
RD0007
RD0008
RD0009
RD0010
RD0011
RD0012
RD0013
RD0014
RD0016
RD0017
RD0020
RD0021
RD0022
RD0023
RD0024
RD0025
RD0026
RD0027
RD0028
RD0029
RD0030
RD0033
RD0035
RD0037
RD0038
RD0039
RD0040
RDBK04
RDBK05
[NAME]
RDBK09
RDNL01
RDWE01
SE0001
SEBE01
SEBK01
SEGN01
SEOR01
SERD01
WE0001
WE0002
WEBE02
WEBK01
WEBK02
WEBK04
YW0003
YW0005
YW0007
YW0008
ST0001
PK0026
Spreadsheet: 770443d1646069139-sorting-multiple-columns-by-matching-values-in-rows-sample-workbook
Sheet: IDEAL OUTCOME

Name 2020 | 2020 ID# | Name 2021 | 2021 ID# | 2020 Sales | 2021 Sales | 2020 Units Sold | 2021 Units Sold | INCREASE/DECREASE SALES | INCREASE/DECREASE UNITS
[NAME] | 5678 | [NAME] | 5678 | 700 | 750 | 14 | 15
Mark | 1234 | Mark | 1234 | 100 | 600 | 2 | 12
[NAME] | 1011 | [NAME] | 1011 | 150 | 850 | 3 | 17
[NAME] | 8910 | [NAME] | 8910 | 300 | 100 | 6 | 2
[NAME] | 2044 | [NAME] | 2044 | 900 | 200 | 18 | 4
[NAME] | 1555 | [NAME] | 1555 | 400 | 350 | 8 | 7
 |  | Julie | 1599 |  | 1000 |  | 20