tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2963bd30-0403-4da9-887f-a3c2dc585cd9
Sheet: Sheet1

Unnamed: 0 | KOULU | Myönnetyt kerhotunnit | Lisätunnit | PIDETYT TUNNIT | Pidetty % | Tunteja jäljellä | Hyv. Ylitys | Väh. Syksy
1 | Aunela | 68 | 30 | 98 | 1 | 0
2 | C.O.Malm | 60 | 40 | 97 | 0.97 | 3
3 | Cygnaeus | 111 |  | 111 | 1 | 0
4 | Haarla | 71 |  | 70 | 0.9859154929577465 | 1
5 | Hannunniittu | 125 | 50 | 169 | 0.9657142857142857 | 6
6 | Hepokulta | 90 | 60 | 150 | 1 | 0
7 | Ilpoinen | 114 | 60 | 174 | 1 | 0
8 | Jäkärlä | 61 | 40 | 101 | 1 | 0
9 | Kakskerta | 40 | 8 | 39 | 0.8125 | 9
10 | Katariina | 75 |  | 80 | 1.066666666666667 | -5 | -5
11 | Kerttuli | 75 | 60 | 135 | 1 | 0
12 | Kiinamylly | 15 |  | 13 | 0.8666666666666667 | 2
13 | Klassikko | 60 |  | 48 | 0.8 | 12
14 | [NAME] | 38 | 15 | 53 | 1 | 0
15 | Lauste | 63 | 40 | 103 | 1 | 0
16 | Luolavuori | 150 | 40 | 190 | 1 | 0
17 | Luostarivuori | 140 |  | 113 | 0.8071428571428572 | 27
18 | Martti | 60 | 25 | 85 | 1 | 0
19 | Mikael | 75 | 50 | 125 | 1 | 0
20 | Moisio | 104 | 40 | 100 | 0.6944444444444444 | 44
21 | Nummenpakka | 168 | 40 | 208 | 1 | 0
22 | Paattinen | 65 |  | 63 | 0.9692307692307692 | 2
23 | Pallivaha | 63 | 15 | 75 | 0.9615384615384616 | 3
24 | [NAME] | 86 |  | 86 | 1 | 0
25 | Puolala | 240 |  | 225 | 0.9375 | 15
26 | Puropelto | 133 | 40 | 179 | 1.034682080924856 | -6 | -5 | -1
27 | Pääskyvuori | 84 | 18 | 106 | 1.03921568627451 | -4 | -4
28 | [NAME] | 190 | 25 | 215 | 1 | 0
29 | Rieskalähde | 149 | 12 | 162 | 1.006211180124224 | -1 | -1
30 | Runosmäki | 78 | 20 | 79 | 0.8061224489795918 | 19
31 | Samppalinna | 54 | 30 | 84 | 1 | 0
32 | S.t Olofsskolan | 107 | 40 | 152 | 1.034013605442177 | -5 | -5
33 | Sirkkala ja Sirkkalabacken | 100 | 30 | 128 | 0.9846153846153847 | 2
34 | [NAME] | 89 | 60 | 151 | 1.013422818791946 | -2 | -2
35 | [NAME] | 104 |  | 123 | 1.182692307692308 | -19 | -5 | -14
36 | Turun kansainvälinen koulu | 50 |  | 55 | 1.1 | -5 | -5
37 | Turun lyseon koulu | 60 |  | 55 | 0.9166666666666666 | 5
38 | Turun normaalikoulu | 200 | 50 | 255 | 1.02 | -5 | -5
39 | Varissuo | 55 | 45 | 87 | 0.87 | 13
40 | [NAME] | 183 | 40 | 226 | 1.013452914798206 | -3 | -3
41 | [NAME] | 114 |  | 94 | 0.8245614035087719 | 20
42 | Wäinö Aaltonen | 130 | 30 | 165 | 1.03125 | -5 | -5
 | YHTEENSÄ | 4097 | 1053 | 5027 | 0.976116504854369 | 123 | -45 | -15
 | 5150
Spreadsheet: 106bc592-9882-4046-97dd-751e581a9869
Sheet: Sheet1

Unnamed: 0 | Breitband/Festnetz: Operative Entwicklung.a | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | 2008 | 2007 | Veränderung | Veränderung | 2006x
 |  | in Mio. € | in Mio. € | in Mio. € | in % | in Mio. €
 | Gesamtumsatz | 21 331 | 22 690 | (1 359) | (6,0) | 24 515
 | Inland | 19 055 | 20 078 | (1 023) | (5,1) | 21 835
 | davon: Netzkommunikation | 9 026 | 10 138 | (1 112) | (11,0) | 11 240
 | davon: Wholesale-Services | 4 404 | 4 482 | (78) | (1,7) | 4 302
 | davon: IP/Internet | 2 504 | 2 452 | 52 | 2.1 | 3 000
 | davon: [NAME] | 2 111 | 2 405 | (294) | (12,2) | 2 536
 | Ausland | 2 329 | 2 654 | (325) | (12,2) | 2 680
 | EBIT ([NAME]) | 2 914 | 3 250 | (336) | (10,3) | 3 356
 | EBIT-Marge (in %) | 13.7 | 14,3 |  |  | 13,7
 | Abschreibungen | (3 612) | (3 675) | 63 | 1.7 | (3 839)
 | EBITDAc | 6 526 | 6 925 | (399) | (5,8) | 7 195
 | EBITDA-wirksame Sondereinflüssec | (903) | (845) | (58) | (6,9) | (1 553)
 | EBITDA bereinigtc | 7 429 | 7 770 | (341) | (4,4) | 8 748
 | Inland | 6 461 | 6 792 | (331) | (4,9) | 7 903
 | Ausland | 970 | 979 | (9) | (0,9) | 845
 | EBITDA-Marge bereinigt c (in %) | 34.8 | 34,2 |  |  | 35,7
 | Inland (in %) | 33.9 | 33,8 |  |  | 36,2
 | Ausland (in %) | 41.6 | 36,9 |  |  | 31,5
 | Cash Capexd | (3 134) | (2 805) | (329) | (11,7) | (3 250)
 | [NAME] | 94 287 | 97 690 | (3 403) | (3,5) | 107 006
 | Inland | 78 808 | 79 704 | (896) | (1,1) | 86 315
 | Ausland | 15 479 | 17 986 | (2 507) | (13,9) | 20 691
a | Im [NAME] des operativen Segments Breitband/Festnetz sind die zugeordneten Gesellschaften T-Online France seit 30. Juni 2007 und T-Online Spain seit 31. [NAME] 2007 nicht mehr enthalten. [NAME] [NAME] erfolgt entsprechend [NAME] der Muttergesellschaft im [NAME]. [NAME] November 2007 wird die Immobilien Scout GmbH im [NAME] voll [NAME]. [NAME]. Januar 2008 erfolgten die Verlagerung der ActiveBilling und die Eingliederung der Call-Center-Aktivitäten der T-Mobile Deutschland GmbH in das operative Segment Breitband/Festnetz.
b | Die sonstigen Umsatzerlöse aus übrigen Festnetzleistungen wurden umgegliedert und zusammengefasst in übrige Festnetzleistungen. Vorjahreswerte wurden angepasst.
c | Die Deutsche Telekom definiert das EBITDA als [NAME] abzüglich Abschreibungen auf immaterielle Vermögenswerte und Sachanlagen. Eine detaillierte [NAME]wirksamen Sondereinflüsse, des bereinigten EBITDA und der bereinigten EBITDA-Marge findet sich im [NAME]“.
d | Investitionen in Sachanlagen und immaterielle Vermögenswerte (ohne [NAME]) [NAME].
e | Personal im [NAME].
Spreadsheet: 695489d1600244353-want-to-make-short-a-formula-last-digit-find-out
Sheet: Sheet1

(18 Digit) | (20 Digit) |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
898801540111125447 |  |  |  | Account number
898801540111125448 |  |  |  | Double every other
898801540111125449 |  |  |  | Sum digits
 |  |  |  | 1. Compute the sum of the sum digits
 |  |  |  | 2. Multiply by 9
 |  |  |  | 3. 603 [NAME] is then 3, which is the check digit
Spreadsheet: 802094d1666642030-count-total-occurrences-without-counting-duplicates-2023-interview-tracker-building-
Sheet: Interview Log

Date | [NAME] | NSO | Check In | Scheduled Time | Start | End | Gross Wait Time | Net Wait Time | Interview Length
2023-01-01 00:00:00 |  | [NAME] | 08:00:00 | 08:30:00 | 08:30:00 | 08:30:00
2023-01-05 00:00:00 |  | [NAME] | 12:00:00 | 12:30:00 | 12:30:00 | 12:50:00
2023-02-01 00:00:00 |  | DSO | 15:00:00 | 15:15:00 | 15:30:00 | 15:45:00
2023-02-02 00:00:00 |  | McHugh | 16:00:00 | 16:15:00 | 16:30:00 | 16:45:00
2023-02-03 00:00:00 |  | Butler | 17:00:00 | 17:15:00 | 17:30:00 | 17:45:00
2023-02-04 00:00:00 |  | Butler | 18:00:00 | 18:15:00 | 18:30:00 | 18:45:00
Spreadsheet: 704147d1605380949-matching-lists-with-a-function-excel-forum-test-question
Sheet: Testing

 |  |  |  |  | Company | A | B | C | D | E | F | G | i | j
 | Industries in portfolio | Weight per industry |  |  | Weight | 0.09365190488019692 | 0.2685576206499402 | 0.09480364038752512 | 0.1125087509315508 | 0.07872450938325692 | 0.1913461755606242
 | Telecommunications Equipment |  |  |  | Industry | Telecommunications Equipment | Specialty Telecommunications | Cable/Satellite TV | Airlines | Investment Banks/Brokers | Airlines | Motor Vehicles | Motor Vehicles | Airlines
 | Specialty Telecommunications
 | Cable/Satellite TV
 | Airlines
 | Investment Banks/Brokers
 | Motor Vehicles
Spreadsheet: 291016d1390103508-if-there-is-yes-in-the-cell-then-automatically-copy-that-to-another-sheet-vaccine-list
Sheet: Vaccine List 2014

[NAME] and requst list 2014
R. No | DOB | Mother's Name | Name | Adress | Age Up to date | Age in Months | date of vaccination | OPV 2 nd | OPV 3 rd | OPV 4 th | [NAME] | [NAME] nd | Panta 3 rd | Measles | MMR | Vit A 1st | Vit A 2nd | Vit A 3rd | Vit A 4th | Vit A 5th | Vit A 6th | Vit A 7th | Vit A 8th | Vit A 9th
2013/01 | 2013-01-03 00:00:00 | Fathima | [NAME] [NAME] | Muzikeege |  |  | 2014-02-04 00:00:00
2013/02 | 2013-01-08 00:00:00 |  | Aishath Yaan Binthu Nashikh | Nooraaneevilla |  |  | 2014-02-04 00:00:00
2013/03 | 2013-01-14 00:00:00 |  | Abdulla Anees |  |  |  | 2014-02-04 00:00:00
2013/04 | 2013-01-31 00:00:00 |  | [NAME] | Thoothaage |  |  | 2014-02-04 00:00:00
2013/05 | 2013-02-01 00:00:00 |  | [NAME] | Raygasdhoshuge |  |  | 2014-02-04 00:00:00
2013/06 | 2013-02-06 00:00:00 |  | [NAME] | Evar Blue |  |  | 2014-02-04 00:00:00
2013/07 | 2013-03-27 00:00:00 |  | [NAME] | Hifasheyhage |  |  | 2014-02-04 00:00:00
2013/08 | 2013-03-28 00:00:00 |  | [NAME] | Raybageechaage |  |  | 2014-02-04 00:00:00
2013/09 | 2013-02-12 00:00:00 |  | [NAME] | Bageechage |  |  | 2014-02-04 00:00:00
2013/10 | 2013-04-09 00:00:00 |  | [NAME] | Naares |  |  | 2014-02-04 00:00:00
2013/11 | 2013-04-28 00:00:00 |  | Razeen Yazeedh | Fahivaa |  |  | 2014-02-04 00:00:00
2013/12 | 2013-04-28 00:00:00 |  | Nooraa Binth Fahumee | Shabnameege |  |  | 2014-02-04 00:00:00
2013/13 | 2013-04-28 00:00:00 |  | [NAME] | Shabnameege |  |  | 2014-02-04 00:00:00
2013/14 | 2013-05-02 00:00:00 |  | Ahna Binth Aarif | [NAME] |  |  | 2014-02-04 00:00:00
2013/15 | 2013-05-12 00:00:00 |  | Nooh [NAME] | Blue Light |  |  | 2014-02-04 00:00:00
2013/16 | 2013-05-27 00:00:00 |  | Yazdhaan Yamin Hameed | Dunthari |  |  | 2014-02-04 00:00:00
2013/17 | 2013-06-12 00:00:00 |  | Neem Fazeel | Blue Star |  |  | 2014-02-04 00:00:00
2013/18 | 2013-06-30 00:00:00 |  | Eelaak Binth Nishaam | Guleynooranmaage |  |  | 2014-02-04 00:00:00
2013/19 | 2013-06-26 00:00:00 |  | [NAME] | Kulhithulhaage |  |  | 2014-02-04 00:00:00
2013/20 | 2013-08-01 00:00:00 |  | [NAME] | Noovilaa |  |  | 2014-02-04 00:00:00
2013/21 | 2013-08-09 00:00:00 |  | Leen Binth Saamiru | Raygasdhoshuge |  |  | 2014-02-04 00:00:00
2013/22 | 2013-08-30 00:00:00 |  | [NAME] |  |  |  | 2014-02-04 00:00:00
2013/23 | 2013-09-20 00:00:00 |  | [NAME] | Kinaaraa |  |  | 2014-02-04 00:00:00
2013/24 | 2013-10-03 00:00:00 |  | [NAME] | Saturn |  |  | 2014-02-04 00:00:00
2013/25 | 2013-10-06 00:00:00 |  | [NAME] | Neeraaz |  |  | 2014-02-04 00:00:00
2013/26 | 2013-10-26 00:00:00 |  | Haazin [NAME] | [NAME] |  |  | 2014-02-04 00:00:00
2013/27 | 2013-10-26 00:00:00 |  | [NAME] Hunaif | [NAME] |  |  | 2014-02-04 00:00:00
2013/28 | 2013-11-28 00:00:00 |  | [NAME] | [NAME] |  |  | 2014-02-04 00:00:00
 |  |  |  |  |  |  | 2014-02-04 00:00:00
 |  |  |  |  |  |  | 2014-02-04 00:00:00
 |  |  |  |  |  |  | 2014-02-04 00:00:00
 |  |  |  |  |  |  | 2014-02-04 00:00:00
Spreadsheet: 889138d1739868277-filter-formula-filter-for-several-criteria-array-in-another-array-extended-function-exampleproblem-filter_extended
Sheet: Sheet1

Cable name | Cable from | Cable to | Note
 |  |  |  |  |  | Search terms (if I know only parts of what I want to search) | Search terms (if I know only parts of what I want to search) |  |  | OriginK | DestinationK | test4
 | OriginA | DestinationA | test1 |  |  | (To filter by column A) | (To filter by column D) |  | OriginP-DestinationP | [NAME] | DestinationP | test5
 | OriginA | DestinationS | test2 |  |  | P | test2 |  | [NAME] | [NAME] | DestinationV | test5
 | OriginA | DestinationT | test1 |  |  | K |  |  | OriginP-DestinationW | [NAME] | DestinationW | test5
 | OriginB | DestinationB | test1
 | OriginC | DestinationC | test1
 | OriginD | DestinationD | test1
 | OriginE | DestinationE | test1
 | OriginF | DestinationF | test1 |  |  |  | How do I have to modify the formula in J2 to add a filter function for column D3:D25, allowing me to filter further down as per strings in H4 to H8?
 | OriginG | DestinationG | test2
 | OriginH | DestinationH | test3
 | OriginI | DestinationI | test4
 | OriginJ | DestinationJ | test4
 | OriginK | DestinationK | test4
 | OriginL | DestinationL | test4 |  |  |  |  |  |  | OriginA | DestinationS | test2
 | OriginL | [NAME] | test4 |  |  |  |  |  | OriginG-DestinationG | OriginG | DestinationG | test2
 | OriginM | DestinationM | test4 |  |  |  |  |  | OriginK-DestinationK | OriginK | DestinationK | test4
 | OriginN | DestinationN | test4 |  |  |  |  |  | OriginP-DestinationP | [NAME] | DestinationP | test5
 | OriginO | DestinationO | test5 |  |  |  |  |  | [NAME] | [NAME] | DestinationV | test5
 | [NAME] | DestinationP | test5 |  |  |  |  |  | OriginP-DestinationW | [NAME] | DestinationW | test5
 | [NAME] | DestinationV | test5
 | [NAME] | DestinationW | test5
 | OriginQ | DestinationQ | test5
 | OriginR | DestinationR | test5
Spreadsheet: 804062d1667863927-if-and-then-formula-issue-vlookup-eba
Sheet: Sheet1

Single Nozzle
Nozzle Information | Input |  | Fabrication Information |  |  |  | Pipe | OD | Sch/ID | BC | # of bolts | [NAME] | bolt diameter
[NAME] in inches | 8 |  | Pipe Cut Length |  |  |  | 0.5 | 3.5 | 0.965 | 2.38 | 4 | 0.625 | 0.5
Pipe size (inches, in shortest decimal form, ie.: 0.5, 0.75, 1, 1.25, 1.5, 2, 2.5, etc… | 6 |  | Flange OD (inches) |  |  |  | 0.75 | 3.88 | 1.175 | 2.75 | 4 | 0.625 | 0.5
Pipe type (Sch or OD) | OD |  | Flange ID (inches) |  |  |  | 1 | 4.25 | 1.445 | 3.12 | 4 | 0.625 | 0.5
End Flange Type (150# or PL) |  |  | Flange BC (inches) |  |  |  | 1.25 | 4.62 | 1.785 | 3.5 | 4 | 0.625 | 0.5
If plate, thickness? (inches in decimal, ie.: 0.25) |  |  | # of bolts in flange |  |  |  | 1.5 | 5 | 2.025 | 3.88 | 4 | 0.625 | 0.5
If plate, bolt size? (inches in decimal, ie.: 0.5) |  |  | Degree of bolt spacing |  |  |  | 2 | 6 | 2.505 | 4.75 | 4 | 0.75 | 0.625
Wall Flange Type (150# or PL) |  |  | 150# flange bolt hole diameter |  |  |  | 2.5 | 7 | 3.005 | 5.5 | 4 | 0.75 | 0.625
If plate, thickness? (inches in decimal, ie.: 0.25) |  |  | 150# flange bolt diameter |  |  |  | 3 | 7.5 | 3.625 | 6 | 4 | 0.75 | 0.625
If plate, bolt size? (inches in decimal, ie.: 0.5) |  |  | End flange plate bolt hole diameter |  |  |  | 3.5 | 8.5 | 4.125 | 7 | 8 | 0.75 | 0.625
Material Type |  |  | End flange plate bolt diameter |  |  |  | 4 | 9 | 4.625 | 7.5 | 8 | 0.75 | 0.625
If other material type, specify |  |  | Wall flange plate bolt hole diameter |  |  |  | 5 | 10 | 5.685 | 8.5 | 8 | 0.875 | 0.75
Material Finish |  |  | Wall flange plate bolt diameter |  |  |  | 6 | 11 | 6.755 | 9.5 | 8 | 0.875 | 0.75
If other material finish, specify (if powder coat, specify color) |  |  |  |  |  |  | 8 | 13.5 | 8.755 | 11.75 | 8 | 0.875 | 0.75
Backer flange required?  (If yes, copy "Wall Flange" requirements/dims/etc…) |  |  |  |  |  |  | 10 | 16 | 10.925 | 14.25 | 12 | 1 | 0.875
 |  |  |  |  |  |  | 12 | 19 | 12.925 | 17 | 12 | 1 | 0.875
 |  |  |  |  |  |  | 14 | 21 | 14.125 | 18.75 | 12 | 1.125 | 1
 |  |  |  |  |  |  | 16 | 23.5 | 16.125 | 21.25 | 16 | 1.125 | 1
 |  |  |  |  |  |  | 18 | 25 | 18.125 | 22.75 | 16 | 1.25 | 1.125
 |  |  |  |  |  |  | 20 | 27.5 | 20.125 | 25 | 20 | 1.25 | 1.125
 |  |  |  |  |  |  | 24 | 32 | 24.125 | 29.5 | 20 | 1.375 | 1.25
Spreadsheet: 29276cf9-5d0d-48f4-99b1-ca8f4b85e82c
Sheet: Sheet1

State Auditor (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 5/24/2013 8:59:54 PM
Precincts Reporting: 528/528 - Total Ballots Cast: 321133
2008 General Election - OFFICIAL RESULTS
Precinct | [NAME] | [NAME] R ([NAME]) [NAME] | TOTALS
Precinct 1001 | 220 | 358 | 578
Precinct 1002 | 247 | 370 | 617
Precinct 1003 | 246 | 436 | 682
Precinct 1004 | 203 | 474 | 677
Precinct 1005 | 84 | 190 | 274
Precinct 1606 | 158 | 157 | 315
TOTAL | 1158 | 1985 | 3143
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 693349d1598942743-conditional-formatting-traffic-light-system-for-birthdays-cf-staff-birthdays-aligw
Sheet: KAMAR

Staff
 |  |  | Date Diff (for reference - you can delete this column)
Surname | First Name | Date of Birth
Person | A | 1995-04-25 00:00:00
Person | B | 1971-09-08 00:00:00
Person | C | 1956-10-13 00:00:00
Person | D | 1989-06-18 00:00:00
Person | E | 1960-05-30 00:00:00
Person | F | 1976-11-08 00:00:00
Person | G | 1963-06-26 00:00:00
Person | H | 1952-05-24 00:00:00
Spreadsheet: 9d3d57f4-0860-43fe-bfef-a678462b2378
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Direzione Finanza Bilancio e Tributi
Settore Gestione Economali
Ufficio Mezzi Motorizzati
 |  |  |  | ALLEGATO C
SCHEDA LAVORI NR.                MEZZO
OFFICINA |  |  |  | KM:
CAUSA:
CONTROLLO | GUASTO |  | DANNO/INCIDENTE |  | ALTRO (specificare)……………….……….
NOTE
 | DATA | ORA | FIRMA | FIRMA | NOTE
ENTRATA
INZIO LAVORI
RICONSEGNABILE
FINE LAVORI
COLLAUDO
Spreadsheet: 130839d1322608830-inserting-a-measure-in-a-powerpivot-pivot-table-to-count-unique-values-example
Sheet: pivot

Row Labels | Count of cust_uid
4355 | 36
4435 | 1
4437 | 3
4451 | 175
4673 | 154
4685 | 3
4751 | 489
4753 | 114
4755 | 3
4757 | 20
Grand Total | 998
Spreadsheet: stacey_white__39067__DPR 1024
Sheet: Summary

Show
y
y
y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
y
y
y
y | 2001-10-24 00:00:00
y |  |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
y | Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD
y
y | ENRON SOUTH AMERICA
y
y | MODESTO MARANZANA PLANT
y | MM PLANT MANAGER
y
y
y
y
y | SOUTH AMERICA TRADING
y
y | SA GAS TRADING |  |  | 35.0 Bcf |  |  | 20.0 Bcf |  |  |  | 2000
y | SA POWER TRADING |  |  | 3.5 Mil MWH |  |  | 2.0 Mil MWH |  |  |  | 5000
y | CUIABA HISTORICAL
y
y | SA GAS TRADING
y
y | ARGENTINA
y | GAS TRADING
n | Intramonth
n | Firm
y | TRANSPORT
y
y | CREDIT |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
n |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
n |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
y
y | SA POWER TRADING
y
y | ARGENTINA
y | POWER TRADING
n | Ezezia Power Trading
n | Rio Cuarto Power Trading
y | MODESTO MARANZANA POWER
y | FIN'L POWER TRADING WITH ENA |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
y
y | BRAZIL/BOLIVIA
y | POWER TRADING
y | POWER CERTIFICATE TRADING
y | FIN'L POWER TRADING WITH ENA |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
y
y | [NAME]
y | CRUDE
y | GAS
n | GNS |  | 0
n | SC |  | 0
n | TBS |  | 0
n | TBS Crude |  | 0
Spreadsheet: 857812d1706709568-formula-to-extract-unmatched-items-formula-extract-items-not-matched
Sheet: Internal Creditors

Trans | Name | Period Month | Period Year | Reference
Invoice | Creditor | 2 | 2024 | 876915
Invoice | Creditor | 3 | 2024 | 877018
Invoice | Creditor | 4 | 2024 | 817255
Invoice | Creditor | 4 | 2024 | 877088
Invoice | Creditor | 4 | 2024 | 877061
Invoice | Creditor | 4 | 2024 | 877078
Invoice | Creditor | 4 | 2024 | 877075
Invoice | Creditor | 4 | 2024 | 877076
Invoice | Creditor | 11 | 2023 | 972023
Invoice | Creditor | 11 | 2023 | 972023
Spreadsheet: 866475d1713383680-xlookup-or-filter-matrix-result-expected-but-value-returned-sample-xlookup-function
Sheet: report

Report year | 2023 | (incl. full previous year)
Report month YTD | 4
Year | Month | S | D |  | [NAME]
 | 1 | 2648304.801830514 | 8349.350269863186
2022 | 2 | 831038.8896120455 | 1990.906188025606
2022 | 3 | 1320874.366336618 | 3825.111384460901
2022 | 4 | 821195.99757967 | 1880.41189908372
2022 | 5 | 1994106.210609958 | 5213.321450985314
2022 | 6 | 2980814.392447427 | 6075.176904732019
2022 | 7 | 1887708.502473384 | 3423.313970126773
2022 | 8 | 2617657.815009173 | 8441.763675160035
2022 | 9 | 10949723.044342 | 27014.84915275512
2022 | 10 | 15010019.27018026 | 33258.78097150747
2022 | 11 | 9284204.647054804 | 20776.94429521777
2022 | 12 | 4011518.983425146 | 12007.71572737542
2023 | 1 | -10284.50392936376 | 38.17075436174218
2023 | 2 | 27711.69580454287 | 86.3864440818376
2023 | 3 | 6541.788175535272 | 41.18423496924814
2023 | 4 | 830902.6710169546 | 2434.892330864817
 |  |  |  |  | Report
 |  |  |  |  | 1. Include all individual months, year to date, starting on January of the previous year
 |  |  |  |  | 2. Retrieve the S and D values from the PERF table, and mark them up with the S_CORR and D_CORR valyes from the TAA table
 |  |  |  |  | Problem
 |  |  |  |  | The XLOOKUP formula cannot find a match in the TAA table, but this does exist
Spreadsheet: 696a8134-1558-4715-8055-d342e920224b
Sheet: Sheet1

[NAME] zur Radbundesliga 2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Straße Männer
 |  | Landesverbands-Mannschaft |  |  | Vereinsmannschaft
 |  | [NAME] (nur deutsche U 23-Fahrer) |  |  | Renngemeinschaft
Namentliche Nennung der [NAME] lt. Generalausschreibung bis spätestens zum 28. Februar 2012!
Offizieller Mannschaftsname:
 | Nr. | Zu- und [NAME] | [NAME] | Kader | UCI-Code* | Lizenz-Nr.
 | 1.
 | 2.
Min. | 3.
 | 4.
 | 5.
 | 6.
 | 7.
 | 8.
[NAME]. | 9.
 | 10.
 | 11.
 | 12.
 | 13.
 | 14.
Sportliche/r Leiter/in und [NAME]/in:
Nr. | Vor- und Nachname: |  | Adresse/E-mail |  |  | Lizenz-Nr.:
1.
2.
Anschrift des verantwortlichen Ansprechpartners (bezügl. Schriftverkehr: Name, [NAME], Telefon, Fax, E-mail)
Name/Vorname:
Straße/Ort:
Telefon/Fax:
Handynummer:
E-mail:
Bankverbindung:
BLZ:
Konto-Nr.:
Nenngelder in Höhe von |  |  | Überweisung ([NAME] beifügen)
€ 510,- bezahlt durch:
[NAME]: Es wird ausdrücklich bestätigt, dass alle [NAME], [NAME] bzw. Sportgruppen ihr Einverständnis zur  Meldung gegeben haben, im Besitz einer gültigen Lizenz sind und die Generalausschreibung und das Reglement der Radbundesliga anerkennen.
Ort/Datum: |  |  | Unterschrift/Stempel:
 |  | BDR-Bankverbindungen: | Commerzbank AG Frankfurt/Main, Kto.-Nr. 5 100 677 00 (BLZ 500 800 00)
 | * UCI-Code setzt sich wie folgt zusammen: GER für Deutschland + Geburtsjahr + Monat + Tag (Bsp.: GER 19660508)
Formular zu senden an [EMAIL] in Digitalform und unterschrieben an die
Geschäftsstelle des BDR ([NAME] 4, 60528 Frankfurt/Main)
Spreadsheet: 66483d1267123901-show-status-calculate-based-on-today-system-date-criteria-temp
Sheet: Sheet1

code | name | city | category | date | status | In F column : Required formula
AK0001 | ABCD | PARIS | IND | 2009-02-15 00:00:00 | PW | if column D= IND & date (column E) is before one year then status is "PW" calculate with today system date
AK0002 | BCDE | LUSANGEL | G | 2008-12-12 00:00:00 | W | if column D= G & date (column E) is within two year then status is "W" calculate with today system date
AK0003 | CDEF | PARTH | G | 2007-12-12 00:00:00 | PW | if column D= G & date (column E) is before two year then status is "PW" calculate with today system date
AK0004 | DEFG | SYDENY | IND | 2010-01-10 00:00:00 | W | if column D= IND & date (column E) is within one year then status is "W" calculate with today system date
AK0005 | EFGH | COLOMBO | G | 2008-03-11 00:00:00 | W | if column D= G & date (column E) is within two year then status is "W" calculate with today system date
 |  |  |  |  |  | in f column "pw" or "w" automatic show by formula
auto genrated alfa_numric code& code not repeated
Spreadsheet: 0a379928-a7f3-47bb-908f-f8e3939b92db
Sheet: Ten Sports (India)

Ten Sports (India)
Date | Start (IST) | End (IST) | Notes
2010-11-21 00:00:00 | 19:30:00 | 21:30:00 | Round [NAME] (Singles)
2010-11-22 00:00:00 | 01:30:00 | 03:30:00 | Round [NAME] (Singles)
2010-11-22 00:00:00 | 19:30:00 | 21:30:00 | Round [NAME] (Singles)
2010-11-23 00:00:00 | 01:30:00 | 03:30:00 | Round [NAME] (Singles)
2010-11-23 00:00:00 | 19:30:00 | 21:30:00 | Round [NAME] (Singles)
2010-11-24 00:00:00 | 05:30:00 | 07:30:00 | Round [NAME] (Singles)
2010-11-24 00:00:00 | 19:30:00 | 21:30:00 | Round [NAME] (Singles)
2010-11-25 00:00:00 | 05:30:00 | 07:30:00 | Round [NAME] (Singles)
2010-11-25 00:00:00 | 19:30:00 | 21:30:00 | Round [NAME] (Singles)
2010-11-26 00:00:00 | 03:30:00 | 05:30:00 | Round [NAME] (Singles)
2010-11-26 00:00:00 | 19:30:00 | 21:30:00 | Round [NAME] (Singles)
2010-11-27 00:00:00 | 01:30:00 | 03:30:00 | Round [NAME] (Singles)
2010-11-27 00:00:00 | 19:30:00 | 22:00:00 | Semi-Final 1 - Live (Singles)
2010-11-28 00:00:00 | 01:30:00 | 04:00:00 | Semi-Final 2 - Live (Singles)
2010-11-28 00:00:00 | 23:00:00 | 02:00 (29/11) | Singles Final - Live
2010-11-29 00:00:00 | 11:00:00 | 14:00:00 | Singles Final - Repeat
Spreadsheet: 145690d1331711816-column-graph-with-superimposed-line-graphline
Sheet: Sheet1

 | 1020T | 1074T | 1154T | 1202T | 1231_T | 1323_T | 1417_T | 1430T | 1433T | 1445T
SNP | 1852.272014 | 1945.770518 | 2605.620194 | 373.14384 | 740.175917 | 1964.41428 | 2071.872664 | 2213.056035 | 1752.916106 | 1819.257325
MA | 1882.812897 | 2064.180964 | 2632.76429 | 401.601733 | 778.409546 | 1950.876405 | 2096.075003 | 2217.195002 | 1787.736089 | 1827.311136
3rd | 130 | 118 | 127 | 96 | 1200 | 540 | 610 | 251 | 687 | 354