tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 40458d1238768668-identify-if-value-missed-from-lookup-top_example-1-
Sheet: Lookup Sheet

0 | First TOP before 5 weeks | -7
5 | Within Window 1 | 28
15 | Within Window 2 | 98
27 | Within Window 3 | 182
39 | Within Window 4 | 266
51 | Within Window 5 | 350
63 | Within Window 6 | 434
75 | Within Window 7 | 518
87 | Within Window 8 | 602
99 | Within Window 9 | 686
111 | Within Window 10 | 770
123 | Within Window 11 | 854
135 | Within Window 12 | 938
147 | Within Window 13 | 1022
159 | Within Window 14 | 1106
171 | Within Window 15 | 1190
183 | Within Window 16 | 1274
195 | Within Window 17 | 1358
207 | Within Window 18 | 1442
219 | Within Window 19 | 1526
231 | Within Window 20 | 1610
243 | Within Window 21 | 1694
255 | Within Window 22 | 1778
267 | Within Window 23 | 1862
279 | Within Window 24 | 1946
291 | Within Window 25 | 2030
303 | Within Window 26 | 2114
315 | Within Window 27 | 2198
327 | Within Window 28 | 2282
339 | Within Window 29 | 2366
351 | Within Window 30 | 2450
363 | Within Window 31 | 2534
375 | Within Window 32 | 2618
387 | Within Window 33 | 2702
399 | Within Window 34 | 2786
411 | Within Window 35 | 2870
423 | Within Window 36 | 2954
435 | Within Window 37 | 3038
447 | Within Window 38 | 3122
459 | Within Window 39 | 3206
471 | Within Window 40 | 3290
483 | Within Window 41 | 3374
495 | Within Window 42 | 3458
507 | Within Window 43 | 3542
519 | Within Window 44 | 3626
531 | Within Window 45 | 3710
543 | Within Window 46 | 3794
555 | Within Window 47 | 3878
567 | Within Window 48 | 3962
579 | Within Window 49 | 4046
591 | Within Window 50 | 4130
603 | Within Window 51 | 4214
615 | Within Window 52 | 4298
627 | Within Window 53 | 4382
639 | Within Window 54 | 4466
651 | Within Window 55 | 4550
663 | Within Window 56 | 4634
675 | Within Window 57 | 4718
687 | Within Window 58 | 4802
699 | Within Window 59 | 4886
711 | Within Window 60 | 4970
723 | Within Window 61 | 5054
735 | Within Window 62 | 5138
747 | Within Window 63 | 5222
759 | Within Window 64 | 5306
771 | Within Window 65 | 5390
783 | Within Window 66 | 5474
795 | Within Window 67 | 5558
807 | Within Window 68 | 5642
819 | Within Window 69 | 5726
831 | Within Window 70 | 5810
843 | Within Window 71 | 5894
855 | Within Window 72 | 5978
867 | Within Window 73 | 6062
879 | Within Window 74 | 6146
891 | Within Window 75 | 6230
903 | Within Window 76 | 6314
915 | Within Window 77 | 6398
927 | Within Window 78 | 6482
939 | Within Window 79 | 6566
951 | Within Window 80 | 6650
963 | Within Window 81 | 6734
975 | Within Window 82 | 6818
987 | Within Window 83 | 6902
999 | Within Window 84 | 6986
Spreadsheet: 719278d1613585476-how-to-auto-populate-a-cell-dependant-on-another-cell-book2
Sheet: Sheet1

0
10
20
30
40
50
60
70
80
90
100
Spreadsheet: kate_symes__18094__Deal Correction 12-6
Sheet: Prior Day

Date of Inquiry | Adjustment date | Date of applied calc | Deal Date | Desk Involved | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
 | 2000-12-05 00:00:00 | 2000-12-05 00:00:00 | 2000-12-04 00:00:00 | STNW | SC | Houston | APB | CTPY: From Coastal to Mieco |  | 473241 | Mid-C | BOM | [NAME] | 25 | 375 | Mieco
 |  |  |  | SC Count
 | 2000-12-05 00:00:00 | 2000-12-05 00:00:00 | 2000-12-03 00:00:00 | STCA | JM | [NAME] | N/A | Deleted extra strips that duplicated deal |  | 472255/259 | Mead | 2000-12-04 00:00:00 | 6 through 23 | 7 | Transmission | Nevada Power
 | 2000-12-05 00:00:00 | 2000-12-05 00:00:00 | 2000-12-03 00:00:00 | STCA | JM | [NAME] | N/A | From sell to buy |  | 472247 | Nevada System | 2000-12-04 00:00:00 | 6 through 24 | 10 | Index + 4.1 | Saguaro
 |  |  |  | JM Count
 | 2000-12-05 00:00:00 | 2000-12-05 00:00:00 | 2000-12-04 00:00:00 | STCA | CH | [NAME] | N/A | MW: from 200 to 150 in hours 11 - 14 | Real Time change: only made in scheduling | 473260 | NP-15 | 2000-12-04 00:00:00 | RTC | Shaped | Index | [NAME]
 |  |  |  | CH Count
 | 2000-12-05 00:00:00 | 2000-12-05 00:00:00 | 2000-12-05 00:00:00 | LTCA | BB | Houston | APB | Added 3 missing deals |  | 474582 | SP-15 | BOM | On [NAME] | 25 | 400 | Sempra
 |  |  |  | BB Count |  |  | TFS |  |  | 474639 | SP-15 | F-01 | On [NAME] | 25 | 310 | [NAME]
 |  |  |  |  |  |  | TFS |  |  | 474640 | SP-15 | F-01 | On [NAME] | 25 | 309.95 | EES
 | 2000-12-05 00:00:00 | 2000-12-05 00:00:00 | 2000-12-05 00:00:00 | LTNW | MS | Houston | Natsource | Added 3 missing deals |  | 474641 | Mid-C | F-01 | On [NAME] | 25 | 775 | BPA
 |  |  |  | MS Count |  |  | Prebon |  |  | 474642 | Mid-C | F-01 | On [NAME] | 50 | 675 | AEP
 |  |  |  |  |  |  | N/A |  |  | 474643 | Mid-C | F-01 | On [NAME] | 25 | 675 | LTSW
 |  |  |  | Grand Count
Spreadsheet: 728460d1618478081-formula-for-match-report-01
Sheet: WK01

Week 01
KPI |  |  | Delivery Performance
Service Type |  |  | TA |  |  | AM |  |  | A |  |  | B-D |  |  | Total Performance
Depot Number | Region | On [NAME] | Due | Suc. | % | Due | Suc. | % | Due | Suc. | % | Due | Suc. | % | Due | Suc. | %
Overall | N/A | N
001 - Depot 01 | H | Y | 20 | 17 | 85 | 33 | 32 | 96.97 | 301 | 284 | 94.35 | 117 | 111 | 94.87 | 418 | 395 | 94.5
002 - Depot 02 | H | Y | 11 | 11 | 100 | 32 | 31 | 96.88 | 299 | 297 | 99.33 | 121 | 119 | 98.35 | 420 | 416 | 99.05
003 - Depot 03 | M | Y | 16 | 9 | 56.25 | 35 | 26 | 74.29 | 288 | 242 | 84.03 | 142 | 131 | 92.25 | 430 | 373 | 86.74
004 - Depot 04 | P | Y | 8 | 4 | 50 | 47 | 36 | 76.6 | 308 | 254 | 82.47 | 144 | 110 | 76.39 | 452 | 364 | 80.53
005 - Depot 05 | H | Y | 7 | 6 | 85.71 | 27 | 25 | 92.59 | 272 | 266 | 97.79 | 137 | 135 | 98.54 | 409 | 401 | 98.04
006 - Depot 06 | P | N | 6 | 6 | 100 | 50 | 47 | 94 | 403 | 387 | 96.03 | 153 | 150 | 98.04 | 556 | 537 | 96.58
007 - Depot 07 | H | Y | 6 | 3 | 50 | 20 | 17 | 85 | 149 | 133 | 89.26 | 79 | 66 | 83.54 | 228 | 199 | 87.28
008 - Depot 08 | M | Y | 4 | 3 | 75 | 20 | 16 | 80 | 208 | 196 | 94.23 | 78 | 76 | 97.44 | 286 | 272 | 95.1
009 - Depot 09 | M | N | 6 | 6 | 100 | 22 | 21 | 95.45 | 160 | 158 | 98.75 | 67 | 65 | 97.01 | 227 | 223 | 98.24
010 - Depot 10 | M | N | 13 | 8 | 61.54 | 55 | 50 | 90.91 | 402 | 389 | 96.77 | 213 | 209 | 98.12 | 615 | 598 | 97.24
Spreadsheet: 759205d1639415837-time-between-two-dates-and-times-time-between-days-hours-mins
Sheet: Sheet1

 |  |  |  |  | Time
 |  |  | Day of |  | Between
 | Date Time |  | Week |  | Days/Hrs/Mins
Now |  |  |  |  | [h]:mm:ss | d hh:[NAME] |  |  |  |  | d m hh:[NAME] | Days | Hours
Future Date Time 01 | 2022-01-04 08:00:00
Future Date Time 02 | 2022-01-25 08:30:00 |  |  |  |  |  | <-- More then 30 days does not count right
Spreadsheet: 122141d1316628359-help-using-2-drop-down-to-search-worksheet-and-populating-another-sheet-copy-of-sample
Sheet: Sheet 2

Type | Color | Sex | Age
Dog | Black | Male | 10
Cat | [NAME] | Female | 5 | 1
Dog | Black | Male | 10
Cat | White | Female | 5
Dog | [NAME] | Male | 10
Cat | WHite | Female | 5
Dog | Black | Male | 10
Cat | [NAME] | Female | 5 | 2
Spreadsheet: 73450d1274118423-weeks-and-years-example-1
Sheet: Sheet1

Issue Closed | Issue
23/2010 | 1
42/2010 | 2
35/2010 | 3
002/2011 | 4
50/2010 | 5
23/2010 | 6
29/2010 | 7
38/2010 | 8
42/2010 | 9
29/2010 | 10
Spreadsheet: 4ab46486-87fb-415b-b8a0-e9ef2bc23291
Sheet: Sheet1

BEZIRK: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
[NAME] für die [NAME] 2008
Das Anmeldeformular ist bis spätestens Montag, 09. Juni 2008 an das Landessekretariat einzusenden.
Wir bitten, die [NAME] genau, vollständig und leserlich auszufüllen und deutlich anzukreuzen, an welchen [NAME] teilgenommen wird!
Wer noch keine Plastikcard mit Nummer angeben [NAME], muss seine Kartoncard bei der [NAME]!
Vor- und Zuname | genaue Adresse | Geburts- jahrgang | LJ Card Nummer | D I S Z I P L I N E N
 |  |  |  | [NAME] | 1000 m [NAME] | Geländelauf | Mountainbike | Inlineskaten | Staffellauf | Völkerball | Fußball |  | Volleyball
 |  |  |  |  |  |  |  |  |  |  | Burschen | Mädchen | Burschen | Mädchen | Mixed
Bezirksmannschaftsführer: |  | Adr.: |  |  |  |  |  | Tel./Handy:
 |  |  |  |  |  |  |  | [NAME]:
Mannschaftsf. Volleyball: |  | Adr.: |  |  |  |  |  | Tel./Handy:
 |  |  |  |  |  |  |  | [NAME]:
Mannschaftsf. Fußball Bu: |  | Adr.: |  |  |  |  |  | Tel./Handy:
 |  |  |  |  |  |  |  | [NAME]:
Mannschaftsf. Fußball Mä: |  | Adr.: |  |  |  |  |  | Tel./Handy:
 |  |  |  |  |  |  |  | [NAME]:
Nenngeld in Summe von: |  | (€ 4,-- pro Teilnehmer)
Einbezahlt am:
Datum |  | Für die Bezirksgruppe
Spreadsheet: 89ca1838-d0de-4008-8607-127c9254870a
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
35812191 | 2013-05-06 01:53:44 | AXIS | 1 | 6 | 2 | 1322086 | J-DM | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
35827529 | 2013-05-07 03:15:40 | AXIS | 1 | 6 | 1 | 1273321 | yakwaba | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
35827657 | 2013-05-07 03:36:01 | ALLIES | 1 | 6 | 1 | 1273321 | yakwaba | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
35857375 | 2013-05-09 05:32:36 | AXIS | 1 | 6 | 4 | 1325061 | [NAME] | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
35869041 | 2013-05-09 23:58:51 | AXIS | 1 | 6 | 1 | 904518 | lordgun | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
35917008 | 2013-05-13 01:33:55 | AXIS | 1 | 6 | 4 | 800235 | Black Arrow | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
35947388 | 2013-05-15 02:16:19 | AXIS | 1 | 6 | 4 | 828730 | [NAME] | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
35947532 | 2013-05-15 02:35:02 | ALLIES | 1 | 6 | 3 | 828730 | [NAME] | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
35964736 | 2013-05-16 09:01:40 | AXIS | 1 | 6 | 5 | 1009380 | crazy hector | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
35964901 | 2013-05-16 09:16:03 | ALLIES | 1 | 6 | 1 | 1009380 | crazy hector | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
35975719 | 2013-05-17 02:20:10 | AXIS | 1 | 6 | 0 | 771893 | BLaw | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
35975810 | 2013-05-17 02:33:08 | ALLIES | 1 | 6 | 3 | 771893 | BLaw | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
35976882 | 2013-05-17 04:34:12 | ALLIES | 1 | 6 | 1 | 1053985 | Rex Celestis | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
35991816 | 2013-05-18 05:49:47 | AXIS | 1 | 6 | 1 | 1328427 | [NAME] | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
35991936 | 2013-05-18 06:05:07 | ALLIES | 1 | 6 | 0 | 1328427 | [NAME] | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
36005879 | 2013-05-19 04:28:21 | AXIS | 0 | 3 | 6 | 1329784 | Elrik1 | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
36006048 | 2013-05-19 04:39:45 | ALLIES | 1 | 6 | 0 | 1329784 | Elrik1 | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
36037571 | 2013-05-21 03:22:03 | AXIS | 1 | 6 | 5 | 1234801 | GenGSP | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
36037749 | 2013-05-21 03:33:21 | ALLIES | 1 | 6 | 1 | 1234801 | GenGSP | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
Spreadsheet: 880779d1728638659-extract-a-string-starts-with-amb-from-a-cell-rawdataexcel
Sheet: Sheet1

Raw Data | Expected Results to extract Asset name/tag AMB99999999xx or AMB99999999
all macro disable Application Name:  Asset Name: AMB00299999BR  [NAME]'s LAN ID: 10099999A | AMB00299999BR
APEX TABLET TURN TO OLD VERSION. Dashvision eSignature : V1.2.0 Kindly assist. Last week already updatedto the latest version, but this week don't know why, go back to the old version. IP Address : 12.384.3.43 Application Name: AmBanCS Asset Name:  [NAME]'s LAN ID: 10018557A | NIL
no internet/urgent Application Name:  Asset Name: AMB00122323HR  Requester's LAN ID: Abbdfdfd | AMB00122323HR
PC cannot on. Application Name: Desktop - Applications-parent Asset Name: AMB00232323HW  Requester's LAN ID: 10040594B | AMB00232323HW
Unable to login Citrix Application Name:  Asset Name: AMB00434234HS  [NAME]'s LAN ID: dfdsfdfsdf | AMB00434234HS
1. [NAME]2. Please use MST chat to arrange time Thanks. Application Name:  Asset Name: AMB08329230HW  [NAME]'s LAN ID: 1dsffsfsf | AMB08329230HW
AmBancs unable to log in msg : YOU MAY LOGIN TO AMBANCS FROM MICROSOFT INTERNET EXPLORER OR FIREFOX Application Name: AmBanCS Asset Name: AMB00384930HS  Requester's LAN ID: sdfsfsfd | [NAME]
system inaccessible ambancs  Application Name: AmBanCS Asset Name: Others [NAME]'s LAN ID: ddfdfsdfA | NIL
Hardware faulty AMB00275837 [NAME] 10041567 Application Name:  Asset Name: AMB00382039HS  [NAME]'s LAN ID: dfsdfdsY | AMB00275837HS
UNABLE TO ACCESS USING VPN VIA LAPTOP. LAPTOP IP ADDRESS:  USER NAME: GRPUSR\ 93939403A LAPTOP TAG: AMB00820238  request for [NAME].  Application Name:  Asset Name: AMB00268778BR  Requester's LAN ID: 93939403A | AMB00820238
Submitting this request for my colleague as she is unable to connect to the internet and she is currently at Menara AmBank Application Name:  Asset Name: AMB00239943HS  Requester's LAN ID: 393949394 | AMB00239943HS
Unable to connect to LAN network after back from annual leave. LAN ID:10033366A ([NAME]). Asset no: AmB00394304. SN:ldeorpeo. IP:11.788.55.43 Application Name:  Asset Name:  [NAME]'s LAN ID: 109393039 | AmB00394304
Spreadsheet: 858257d1706980355-sort-to-new-columns-current
Sheet: Current

id | Action | CategoryPath | Name | Code | ShortDescription
28937 | Product | 051 Club | Vertigo @ Liverpool 051 (xx.11.1991) | 6173 | Venue
28936 | Product | 051 Club | Parks & Wilson Live @ Club 051 Liverpool (xx.xx.1991) | 18021 | Venue
14848 | Product | Boxed | Johnny Vicious & Todd Terry CatBxd1101 (My Girlfriends Got A Pearl Necklace) (xx.xx.1995) | 23307 | Series
37008 | Product | Boxed | Jeremy Healy & Brandon Block Party Anthems Bxd 505 (xx.xx.1995) | 23533 | Series
15738 | Product | 051 Club | [NAME] @ 051 Club Liverpool (xx.10.1991) | 24270 | Venue
15739 | Product | 051 Club | Sister Bliss Live @ 051 Club Circus 1st Birthday Morecambe Beach (xx.xx.1992) | 24271 | Venue
17953 | Product | Boxed | [NAME] Trip Hop #1 (xx.xx.1996) | 26561 | Series
29806 | Product | A.W.O.L. | [NAME] A.W.O.L. Last Night At The Paradise Club (xx.12.1994) | 36706 | Event
29807 | Product | A.W.O.L. | Dr S [NAME] Last Night At The Paradise Club (xx.12.1994) | 36707 | Event
29808 | Product | A.W.O.L. | [NAME] Last Night At The Paradise Club (xx.12.1994) | 36708 | Event
29809 | Product | A.W.O.L. | Randall & Kenny [NAME] Last Night At The Paradise Club (xx.12.1994) | 36709 | Event
97430 | Product | Dublin Ireland | [NAME] (15.10.1993) | 50853 | City
46325 | Product | 1605 Podcast | Beltek 1605 Podcast #003 (05.04.2011) | 51849 | Podcast
46329 | Product | 1605 Podcast | Da Fresh 1605 Podcast #001 (xx.03.2011) | 51853 | Podcast
46345 | Product | 1605 Podcast | Erphun 1605 Podcast #004 (13.04.2011) | 51869 | Podcast
46396 | Product | 1605 Podcast | [NAME] 1605 Podcast #002 (xx.03.2011) | 51920 | Podcast
55575 | Product | &ME | &ME On The Global Network (13.02.2011) | 60238 | Artist
58441 | Product | 21st Century House Music | [NAME] On 21st Century House Music 024 (31.10.2012) | 61815 | Radio Show
58444 | Product | 21st Century House Music | [NAME] On 21st Century House Music 027 (23.11.2012) | 61818 | Radio Show
58445 | Product | 21st Century House Music | [NAME] On 21st Century House Music 028 (30.11.2012) | 61819 | Radio Show
97479 | Product | Dublin Ireland | [NAME] On Power FM Dublin (19.03.1994) | 83258 | City
97567 | Product | &ME | &ME & Dirk Rumpff On OFFtrack (20.02.2009) | 83331 | Artist
98036 | Product | Dublin | [NAME] @ Sunset Sessions Volume 0 [NAME] (23.09.2023) | 83505 | Country
98037 | Product | Dublin | [NAME] Takeover [NAME] (01.04.2023) | 83506 | Country
98038 | Product | Dublin | [NAME] @ The Final District 8 Dance at The Tivoli Dublin (26.01.2019) | 83510 | Country
98041 | Product | Dublin | Radial Live @ The Hangar Dublin (17.11.2017) | 83515 | Country
Spreadsheet: 888705d1739284673-how-to-use-vlookup-sum-sumifs-with-multiple-criteria-excel-question
Sheet: Sheet1

 | Master table
 |  | ProductGroup | Group3 | Group2 | Group1 | Group2 | Group3 | Group3 | Group2 | Group1 | Group2 | Group3 | Group3 | Group2 | Group1 | Group2 | Group3
 |  | Segment | Large | Large | Large | Large | Large | Medium | Medium | Medium | Medium | Medium | Small | Small | Small | Small | Small
 |  | Product | A | B | C | D | E | A | B | C | D | E | A | B | C | D | E
 |  | COUNTRIES
 |  | Country1 | 12 | 22 | 32 | 42 | 52 | 52 | 62 | 72 | 82 | 92 | 92 | 102 | 112 | 122 | 132
 |  | Country2 | 13 | 17 | 21 | 25 | 29 | 29 | 33 | 37 | 41 | 45 | 45 | 49 | 53 | 57 | 61
 |  | Country3 | 15 | 28 | 41 | 54 | 67 | 67 | 80 | 93 | 106 | 119 | 119 | 132 | 145 | 158 | 171
 |  | Country4 | 40 | 42 | 44 | 46 | 48 | 48 | 50 | 52 | 54 | 56 | 56 | 58 | 60 | 62 | 64
 | New table
 |  | Product Group | Group1 | Group2 | Group3 | Group1 | Group2 | Group3 | Group1 | Group2 | Group3
 |  | Segment | Large | Large | Large | Medium | Medium | Medium | Small | Small | Small
 |  | COUNTRIES
 |  | Country1
 |  | Country2
 |  | Country3
 |  | Country4
 | Products & Group
 |  | Product | ProductGroup
 |  | A | Group3
 |  | B | Group2
 |  | C | Group1
 |  | D | Group2
 |  | E | Group3
 |  |  |  |  |  | How to use vlookup/sum/sumifs
 |  |  |  |  |  | Hi, I would like to create a new table based on a master table (which I cannot change). How do I get the sum of values into the new table using vlookup/sum/sumifs with multiple criteria (see example picture). Since the actual master table is way more complex, I would like to use a single defined ranges for the ProductGroup, Segment, Countries and the values in the master table. Fyi, the country list is the same for both master table and new table.
 |  |  |  |  |  | Thanks for your help!
Spreadsheet: 805806d1668944103-how-to-show-value-added-tax-separate-from-vat-exempt-and-vat-zero-rated-vat-separattion
Sheet: VAT_Payments

[NAME]
Date | TIN | CUSTOMER NAME | TAX IONVOICE NUMBER / REFERENCE | Particulars of Supplies | Exempt Supplies | Zero Rated Supplies | Std Rated (Excl. VAT)
2022-10-03 00:00:00 | 100100100 | Times | 1258 | newspaper |  |  | 6 | to be shown as 5.22 VAT Excl (15%)
2022-10-05 00:00:00 | 100100200 | Butchery | 847 | meat |  |  | 100 | to be shown as 86.96 VAT Excl (15%)
Spreadsheet: 136fa8a6-848a-4007-b4b4-d00e15f737c8
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 12. LEASE FINANCE COMMITMENTS, For Plant and Equipment: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Transport equipment ; |  |  | Original | A2413515K | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Construction and earthmoving equipment ; |  |  | Original | A2413516L | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Agricultural machinery and equipment ; |  |  | Original | A2413517R | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Manufacturing equipment ; |  |  | Original | A2413518T | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Electronic data processing equipment ; |  |  | Original | A2413519V | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Office machines ; |  |  | Original | A2413520C | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Shop and office furniture, fittings and equipment ; |  |  | Original | A2413521F | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Other goods ; |  |  | Original | A2413522J | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Lease Finance - Total ; |  |  | Original | A2413523K | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | DERIVED | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 566593d1521593747-convert-time-series-ohlc-data-frequency-book2-2-
Sheet: Month

Month | Open | High | Low | Last | Change | Settle | Volume | Previous Day Open Interest
2
3
Spreadsheet: elizabeth_sager__9527__NewPowerCompany EES Deals
Sheet: Financial

Deal_No | TermBook_Deal_Id | Deal_Type | Trader | Trade_Dt | Cpty | Buy_Sell | Cmdty | Start_Dt | End_Date | Volume | Price | Total_Volume | TotalPrice | Definition | Price_Type | Nerc | Source | Expired | 2001-09-30 00:00:00
8607 | 5303 | Swap ERCOT Pilot | Sharma | 2001-03-13 00:00:00 | New Power Company | Sell | Energy | 2001-10-01 00:00:00 | 2001-12-31 00:00:00 | 50 | 47 | -51200 | 2406400 | 5x16 HE07-22 | Fixed | ERCOT | ERCOT
9118 | 5500 | Financial | Breen | 2001-04-06 00:00:00 | New Power Company | Sell | Energy | 2001-07-01 00:00:00 | 2001-08-31 00:00:00 | 50 | 123 | -35200 | 4329600 | 5x16 HE08-23 | Swap | NPCC | HUD VL
14596 | NULL | Financial | Breen | 2001-08-03 00:00:00 | New Power Company | Buy | Energy | 2001-07-01 00:00:00 | 2001-08-31 00:00:00 | 50 | 0 | 35200 | 0 | 5x16 HE08-23 | Index | NPCC | HUD VL
9124 | 5507 | Financial | Breen | 2001-04-06 00:00:00 | New Power Company | Sell | Energy | 2001-06-01 00:00:00 | 2001-06-30 00:00:00 | 50 | 90.75 | -16800 | 1524600 | 5x16 HE08-23 | Swap | NPCC | N.Y.C.
5817 | 3310 | Financial | Whalan | 2000-09-27 00:00:00 | New Power Company | Buy | Energy | 2000-10-01 00:00:00 | 2000-10-31 00:00:00 | 25 | 0 | 10400 | 0 | [NAME] | Swap | WSCC | NP15
5965 | NULL | Financial | Whalan | 2000-10-03 00:00:00 | New Power Company | Buy | Energy | 2000-10-05 00:00:00 | 2000-10-31 00:00:00 | 25 | 122 | 9200 | 0 | [NAME] | Swap | WSCC | NP15
5966 | NULL | Financial | Whalan | 2000-10-03 00:00:00 | New Power Company | Buy | Energy | 2000-10-05 00:00:00 | 2000-10-31 00:00:00 | 25 | 123 | 9200 | 0 | [NAME] | Swap | WSCC | NP15
5818 | 3311 | Financial | Whalan | 2000-09-27 00:00:00 | New Power Company | Sell | Energy | 2000-10-01 00:00:00 | 2000-10-31 00:00:00 | 25 | 0 | -10400 | 0 | [NAME] | Swap | WSCC | SP15
5964 | NULL | Financial | Whalan | 2000-10-03 00:00:00 | New Power Company | Sell | Energy | 2000-10-05 00:00:00 | 2000-10-31 00:00:00 | 25 | 110 | -9200 | 0 | [NAME] | Swap | WSCC | SP15
5967 | NULL | Financial | Whalan | 2000-10-03 00:00:00 | New Power Company | Sell | Energy | 2000-10-05 00:00:00 | 2000-10-31 00:00:00 | 25 | 111 | -9200 | 1021200 | [NAME] | Swap | WSCC | SP15
6951 | NULL | Financial | Whalan | 2000-12-29 00:00:00 | New Power Company | Sell | Energy | 2001-01-01 00:00:00 | 2001-01-31 00:00:00 | 0 | 0 | 0 | 0 | 6x8 HE01-06,23-24 | Fixed | WSCC | SP15
Spreadsheet: 043b820a-db5f-4161-8b19-d1b12d8c4399
Sheet: Delta Burke

Team | Tournament | PPB
LASA A | Harvard Delta Burke | 25.97
Hunter A | Harvard Delta Burke | 24
St. Anselm's | Penn QuAC | 22.9
[NAME] | Penn QuAC | 21.96
LASA B | Harvard Delta Burke | 21.12
[NAME] | Harvard Delta Burke | 19.2
St. Joseph's A | Penn QuAC | 18.37
LASA C | Harvard Delta Burke | 18.33
East Brunswick A | Penn QuAC | 17.58
Wilmington Charter A | Penn QuAC | 17.19
Bergen A | Penn QuAC | 16.81
[NAME] B | Penn QuAC | 16.74
LASA D | Harvard Delta Burke | 16.28
Millburn A | Penn QuAC | 15.7
[NAME] | Penn QuAC | 14.95
Wilmington Charter C | Penn QuAC | 14.29
[NAME] | Penn QuAC | 13.93
Mount Pleasant | Penn QuAC | 12.92
St. Joseph's B | Penn QuAC | 12.22
East Brunswick B | Penn QuAC | 11.75
Millburn B | Penn QuAC | 11.25
[NAME] | Penn QuAC | 9.49
St. Joseph's C | Penn QuAC | 8.25
Octorara A | Penn QuAC | 7.5
Bloomfield A | Penn QuAC | 7.3
[NAME] | Penn QuAC | 5.81
Bergen B | Penn QuAC | 5.61
Bloomfield B | Penn QuAC | 2.31