tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 69858d1270545531-financial-predictions-financial-predictions
Sheet: Sheet1

Log No | Scheme | Length of Course (Years) | Course Start Date | Course End Date | Amount Approved
D.001 | B | 1 | 2010-05-01 00:00:00 | 2011-02-01 00:00:00 | 350
D.002 | A | 2 | 2010-05-02 00:00:00 | 2012-02-02 00:00:00 | 350 |  |  |  | Select Criteria
D.003 | B | 3 | 2010-05-03 00:00:00 | 2013-02-03 00:00:00 | 350 |  |  |  | > |  | <=
D.004 | B | 4 | 2010-05-04 00:00:00 | 2014-02-04 00:00:00 | 350 |  |  |  | Select Financial Year
D.005 | B | 5 | 2010-05-05 00:00:00 | 2015-02-01 00:00:00 | 350 |  |  |  | 2010-04-01 00:00:00 |  | 2011-03-31 00:00:00
D.006 | A | 3 | 2011-05-05 00:00:00 | 2014-08-01 00:00:00 | 350
D.007 | C | 4 | 2011-12-01 00:00:00 | 2015-09-01 00:00:00 | 350 |  |  |  | Course Start Date |  | Course Start Date |  | Scheme
D.008 | B | 3 | 2012-09-01 00:00:00 | 2015-08-01 00:00:00 | 350 |  |  |  | >01/04/10 |  | <=31/03/11 |  | C
D.009 | A | 3 | 2013-08-01 00:00:00 | 2016-08-01 00:00:00 | 350
[NAME] | B | 2 | 2014-06-01 00:00:00 | 2016-09-01 00:00:00 | 350 |  |  |  | Total per financial Year  (Scheme Costs)
 |  |  |  |  |  |  |  |  | Scheme |  |  | Amount Approved
 |  |  |  |  |  |  |  |  | Scheme
 |  |  |  |  |  |  |  |  | C |  |  | 0
 |  |  |  |  |  |  |  |  | Scheme
 |  |  |  |  |  |  |  |  | C
Spreadsheet: c74c1c95-46ca-4530-b72c-362b9d7a0f76
Sheet: Sheet1

 | First Name | Last Name | City | Country | club
1 | Maria | Alamo | barcelona | Spain
2 | Storme | [NAME] | Ongar | United Kingdom
3 | Augusta | Barrios | Lima | Peru
4 | Lisandra | [NAME] | Ribeirao Preto | Brazil
5 | Nina | [NAME] | Åros | Norway
6 | Carole | Binjacar | Paris | France
7 | Céline | BOUSREZ | TANNERON | France
8 | Monika | Büchi | Aarau | Suisse
9 | Zoe | Campbell | coventry | United Kingdom
10 | Beky | Cann | Chesham | United Kingdom
11 | [NAME] | CAYATTE | PARIS | France
12 | [NAME] | Clement | Distrito Federal | Mexico
13 | Els | Eeckhout | gent | Belgium
14 | [NAME] | Fowler | whitby | United Kingdom
15 | Elaine | Garvican | [NAME] | United Kingdom
16 | Emeline | GEOFFROY | Bezaumont | France
17 | [NAME] | Gries | Ipsach | Switzerland
18 | Monika | Haegele | Tuebingen | Germany
19 | LAURE | HALLAIS | VIOLAINES | France
20 | [NAME] | [NAME] | [NAME] | Austria
21 | [NAME] | Jones | London | United Kingdom
22 | Růžena | Kavanová | Studeněves | Czech Republic
23 | [NAME] | [NAME] | Andover | United Kingdom
24 | Anouk | Molliex | [NAME] | United Kingdom
25 | Michela | Perito | [NAME] | Italy
26 | [NAME] | POPIEUL | Saint Vincent de Tyrosse | France
27 | Anne-Sophie | REMY | Antony | France
28 | Sonia | Reynaud | Pérols | France
29 | VERENE | ROULIN | / | Suisse
30 | [NAME] | SANSANO CANALES | ELX | Spain
31 | [NAME] | Short | Shenfield | United Kingdom
32 | Rebecca | Smith | Barcelona | Spain
33 | Lindha | Stolpe | UPPSALA | Sweden
34 | Sandra | Stopp | Nürnberg | Germany
35 | [NAME] | Toms | Hibridge | United Kingdom
36 | [NAME] | Toth | VIDRERES | Spain
37 | Rosario | Truchero | [NAME] | Spain
38 | Maria | Vallejo | San salvador de jujuy | Argentina
39 | BRIDGET | VAN BREDA | CONSTANTIA CAPE TOWN | Afrique du Sud
40 | Nóra | Vándor | Keszthely | Hungary
41 | Leontien | Waaijer | Doorn | The Netherlands
42 | Christine | Weiss | Feldafing | Germany
43 | [NAME] | Westley | Pitsford | United Kingdom
44 | Alayna | [NAME] | Kaysville | United States
45 | AMANDA | WILMER | London | United Kingdom
46 | Simone | Zahradka | London | United Kingdom
 | 46 | 46 | 46 | 46
Spreadsheet: 846122d1697438159-show-working-instructions-depending-on-ghs-hazard-pictograms-sample-book-glenn-and-hansd-112-1-
Sheet: Search

 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Room 2, 1, 5, 7
 |  |  |  |  |  |  |  |  |  |  |  | Room 3, 1, 5, 7
 | Organische Peroxide CD |  | Brennbare Flüssigkeiten 1 |  |  |  |  |  |  |  |  | Room 6, 4, 5
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 | Possible Rooms: |  |  |  |  |  |  |  |  |  | Possible Rooms | #N/A
 | Room 1, depending, if possible in room 6 Room 2, [NAME] 10 g, if possible in room 6 Room 3, if possible in room 6 Room 4, if possible in room 6
 |  |  |  |  |  |  |  |  |  |  |  | Hans
 | Chemical is a |  | Powder |  |  |  |  |  |  |  |  | Room 2, 1, 5, 7
 |  |  |  |  |  |  |  |  |  |  |  | Room 3, 1, 5, 7
 | Special Requirements: |  |  |  |  |  |  |  |  |  | Special Requirements | Room 6, 1, 5
 | B12: be aware of B15: if, then do [NAME]: Need xy B59: not allowed to
Spreadsheet: 21504c0f-d24c-4110-8376-d869b306cc51
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 | Unnamed: 12 | Unnamed: 13
Cuadro 3.13-03
REPÚBLICA DOMINICANA: [NAME] suscritas de aseguradoras por año, según ramo de seguro, 2001-2011
(En RD$)
Años | Total | Total seguros de vida | Vida individual | Vida colectiva | Total seguros generales | Accidentes personales y salud | Incendio y aliados | [NAME] y aéreas | Transporte de carga | Vehículos de motor | Agrícola y pecuario | Fianzas | Otros seguros
2001 | 7658530050 | 697307650 | 153251143 | 544056507 | 6961222400 | 1464370894 | 2101231075 | 59271973 | 137801942 | 2383834367 | 468106 | 192692385 | 621551658
2002 | 9580468548 | 779482264 | 148617447 | 630864817 | 8800986284 | 1721201258 | 3059090321 | 71727627 | 174606819 | 2881857972 | 17841949 | 227016519 | 647643819
2003 | 9872859677 | 837968353 | 127804905 | 710163448 | 9034891324 | 683713232 | 3810035645 | 123246080 | 139973922 | 3189729676 | 27539889 | 260342435 | 800310445
2004 | 15076815415 | 846098420 | 70838206 | 775260214 | 14230716995 | 1239352257 | 5701993029 | 167478938 | 254723336 | 5789812522 | 0 | 417333508 | 660023405
2005 | 14471570379 | 1259418438 | 105750147 | 1153668291 | 13212151941 | 1547235038 | 4910539435 | 121915721 | 268327562 | 5376341368 | 0 | 446978826 | 540813991
2006 | 17605181335 | 1223675077 | 69559123 | 1154115954 | 16381506258 | 1861431383 | 6322000369 | 272781443 | 323302283 | 6473058165 | 21819791 | 529942443 | 577170381
2007 | 20281104636 | 1473457039 | 67127676 | 1406329363 | 18807647597 | 1914093078 | 6651728753 | 306471395 | 390223779 | 8059452956 | 27564982 | 545453634 | 912659020
2008 | 22093713070.24 | 1739572909.51 | 56260005.06 | 1683312904.45 | 20354140160.73 | 1858537346.26 | 7504845066.13 | 365845117.77 | 521034774.86 | 8462799900.400001 | 87073109.61 | 666807449.6800001 | 887197396.02
2009 | 23425753172.52 | 2357185956 | 80493562.92 | 2276692393.55 | 21068567216 | 2208160275.2 | 7612033445.740001 | 505533551.03 | 447239231.67 | 8376230853.75 | 109312249.83 | 719957899.7399999 | 1090099709.09
2010 | 24693805651.81 | 2355349200.84 | 86617595.91 | 2268731604.93 | 22338456450.97 | 2651512304.09 | 8244447014.38 | 918077707.63 | 530908114.49 | 8221620288.82 | 0 | 787962585.4699999 | 983928436.0899999
2011 | 27126827560.83 | 2886379394.39 | 76736599.09 | 2809642795.3 | 24240448166.44 | 3001339883.84 | 9177589333.54 | 475884849 | 562537822.5 | 9183777728.24 | 129997097.51 | 825076096.8100001 | 884245355
Fuente: [NAME]
Spreadsheet: 1ab3e0c0-ea94-45da-a22d-c63eab93d6bb
Sheet: Sheet1

1 | 2 | 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 | 1.1 | 2.1 | 3.1 | 4.1 | 5.1 | 6.1 | 7.1 | 8.1
 |  |  |  |  | Susan0412
 |  |  |  |  |  |  |  |  | SUNSET
 |  |  |  |  |  |  | Karen & Paul |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Honeymoon
 |  |  |  |  |  |  |  | Jay & Susan ( first timers )
 |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wedding
 |  |  |  |  |  |  |  |  |  |  | bveg912     J & B   ( first timers )
 |  |  |  |  |  |  |  |  |  |  | Rick & Mary
 |  |  |  |  |  |  |  |  | Todd & Linda
 |  |  |  |  |  |  |  |  |  |  |  | thewooduls
 |  |  |  |  |  |  |  |  |  | Paul Frances |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Anniversary
 |  |  |  |  |  |  |  |  |  |  | Vicki528 ( first timers )
 |  |  |  |  |  |  |  |  |  |  | Chris&Vicki   first timers
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | first timers
 |  |  |  |  |  |  |  |  |  |  |  | Heather & Jim |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Birthday
 |  |  |  |  |  |  |  |  |  |  |  | Grady
 |  |  |  |  |  |  |  |  |  |  |  | dawi
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | lamdam
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sunny23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Andy & Meredith
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lisa531
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | keenercam
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]    (first timers)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jam24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Csmarine01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JoeinShannon
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JPTexan82
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mike & Sue
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Melvin76
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VA couple
Spreadsheet: 285116d1387463901-auto-populating-column-of-data-autopop
Sheet: Sheet2

August | 2013-08-02 00:00:00
August
August
August
August
August
August
August
August | 2013-08-03 00:00:00
August
August
August
August
August
August
August
September | 2013-09-04 00:00:00
September
September
September
September
September
September
September
October | 2013-10-05 00:00:00
October
October
October
October
October
October
October
Spreadsheet: 107424d1304599166-need-formula-for-a-macro-function-example
Sheet: 31

873
Name | Amount
Name 1 | 174
Name 3 | 140
Name 2 | 125
Name 3 | 178
Name 3 | 128
Name 3 | 153
Name 1 | 136
Name 1 | 165
Name 3 | 136
Name 3 | 131
Name 2 | 111
Name 2 | 117
Name 2 | 178
Name 2 | 100
Name 2 | 145
Name 3 | 170
Name 2 | 165
Name 2 | 164
Name 1 | 175
Name 2 | 139
Name 2 | 110
Name 2 | 108
Name 2 | 170
Name 1 | 123
Name 1 | 100
Spreadsheet: 0f59a97a-f7db-4e46-b2cf-c3b4e0c64720
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 | Unnamed: 12
 | Sustainability Committee Application Pool |  | 09.01.09
 | Name | Occupation | Resident | Age | Born | Expertise |  |  | Interest |  |  | Notes
 |  |  | Years |  |  | Environment | Economic | Social | Environment | Economic | Social
 | [NAME]* | Business Owner | 20 | 52 | 1957 |  | P
 | [NAME] | Toxicologist, Business Owner | 32 | 51 | 1958 | 4 | 2 | 1 | 5 | 3 | 3
 | [NAME] | Banker, NCSECU | 3.1 | 25 | 1984
 | [NAME] | Marketing, Technology Sector | 12 | 53 | 1956 | 1 | 3 | 1 | 4 | 5 | 3
 | [NAME] | UNC School of Medicine | 6.5 | 38 | 1969 | 1 | 1 | 1 | 5 | 5 | 5
 | [NAME]* | Public Health Consultant | 5.1 | 24 | 1985
 | [NAME] |  | 3.1 | 63 | 1946 | 3 | 2 | 3 | 5 | 4 | 5
 | [NAME] | Brand Manager, [NAME]'s Bees | 1.5 | 39 | 1970 | 5 | 5 | 3 | 5 | 5 | 5
 | [NAME] | Student | 3.25 | 22 | 1987
 | [NAME] | Coffee Shop Mgr; Env. Educator | 7 | 30 | 1979 | 4 | 3 | 4 | 5 | 5 | 5
 | Paulette Bekolo | Self Employed | 9 | 47 | 1962 | 1 | 4 | 2 | 5 | 5 | 5 | Needs Nomination
 |  | Average | 9.616666666666665 | 40.5 |  | 2.714285714285714 | 2.857142857142857 | 2.142857142857143 | 4.857142857142857 | 4.571428571428571 | 4.428571428571429
 |  | Total |  |  |  | 19 | 20 | 15 | 34 | 32 | 31
 |  | Reported Expertise (4,5 or P) |  |  |  | 6 | 3 | 2
 | *Resides outside of Chapel Hill
Spreadsheet: 767757d1644607106-sumifs-function-that-can-sum-data-imported-as-text-without-user-changing-the-imported-data-excel-sum-example
Sheet: Sheet1

Category | Sub | Gross amount |  |  |  | Category | Sub | Amt
A | R1 | 50.00 |  |  |  | A | R1
B | R2 | 25.00 |  |  |  | A | R2 |  | < [NAME] doesn’t work because the Gross Amounts come in as text.  I don't want the user to have to manipulate the original data (for example, by converting the text to numbers).
C | R1 | 50.00 |  |  |  | B | R1
C | R1 | 25.00 |  |  |  | B | R2
A | R1 | 25.00 |  |  |  | C | R1
B | R1 | 25.00 |  |  |  | C | R2
C | R1 | 25.00
C | R1 | 25.00
C | R2 | 50.00
B | R1 | 31.00
B | R1 | 20.00
A | R2 | 150.00
C | R2 | 25.00
A | R2 | 25.00
B | R2 | 100.00
C | R1 | 25.00
B | R2 | 20.00
C | R2 | 50.00
Spreadsheet: 825590d1681407124-sumif-using-different-criteria-is-column-is-empty-book1
Sheet: Sheet1

Type | Cost per day | Inbound Date | Est Outbound Date | Actual Outbound Date
Door | 1 | 2021-01-01 00:00:00 |  | 2021-01-15 00:00:00 |  |  |  | 2021-01-31 00:00:00
Furniture | 2 | 2021-02-03 00:00:00 |  |  |  |  | Door
Furniture | 3 | 2021-02-15 00:00:00 |  |  |  |  | Furniture
Furniture | 4 | 2021-01-11 00:00:00 |  | 2021-01-15 00:00:00 |  |  | Carpet
Furniture | 5 | 2021-02-01 00:00:00 |  |  |  |  | TV
Furniture | 6 | 2021-03-15 00:00:00
Carpet | 7 | 2021-03-12 00:00:00 |  | 2021-01-15 00:00:00
Door | 8 | 2021-01-11 00:00:00 |  |  |  |  |  | * How do I create a formula that will take (D-C+1)*B if E is blank
Door | 9 | 2021-02-03 00:00:00 |  |  |  |  |  | * and if E is NOT blank, take (E-C+1)*B
Door | 10 | 2021-05-17 00:00:00 |  |  |  |  |  | * The result of to be shown respective in their month column (I:P) base on D (if E is blank) and E (if E is not blank)
TV | 11 | 2021-05-01 00:00:00 |  | 2021-06-20 00:00:00 |  |  |  | * best is no helper column
TV | 12 | 2021-05-01 00:00:00
Furniture | 13 | 2021-01-16 00:00:00
Furniture | 14 | 2021-02-01 00:00:00 |  | 2021-03-12 00:00:00
Furniture | 15 | 2021-02-15 00:00:00
Furniture | 16 | 2021-01-11 00:00:00 |  | 2021-03-12 00:00:00
Spreadsheet: 0128deec-f9e8-44e1-a593-94101b46d300
Sheet: Sheet1

Table S1 Variants typed in 5q34 to produce a NPL score (affected only analysis) of 4.24 among BRCA1 mutation carrier families | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Gene | Nucleotide change | Amino acid change | Minor allele frequency (%) | rs# | NCBI build 36.3 ([NAME] bp) | r2 rs299290 HapMap CEU phase III
CCNG1 | C > T | --- | 37.85 | rs299322 | 162799126 | 0.78
CCNG1 | A > G | --- | 2.55 | rs2069345 | 162799242 | 0.02
HMMR | G > A | R317H (NP_036617) | 6.21 | rs2303078 | 162833734 | 0.01
HMMR | T > C | V353A (NP_036617) | 18.83 | rs299290 | 162835094 | 1
HMMR | T > C | A469V (NP_036617) | 16.98 | rs299295 | 162842294 | 0.76
Spreadsheet: 4b40f4ae-9e9d-4e59-85a1-44e7ce607614
Sheet: Sheet1

Judgeship Number 4 (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 5/23/2013 3:23:39 PM
Precincts Reporting: 607/607 - Total Ballots Cast: 316016
2004 General Election - OFFICIAL RESULTS
Precinct | [NAME] | [NAME] | TOTALS
Precinct 0201 | 45 | 24 | 69
Precinct 0202 | 177 | 114 | 291
Precinct 0203 | 199 | 106 | 305
Precinct 0204 | 85 | 61 | 146
Precinct 0205 | 66 | 39 | 105
Precinct 0206 | 40 | 42 | 82
TOTAL | 612 | 386 | 998
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 772977d1647544005-conditional-formatting-lowest-value-based-on-conditions-in-another-column-excel-test-formatting
Sheet: Sheet1

 |  |  |  | MOST STRINGENT CRITERIA FOR LAND USE AND SOIL TYPE
 |  |  |  | Benzene | Toluene | Ethylbenzene | Xylenes | PHC F1 | PHC F2 | PHC F3 | PHC F4
 |  |  | YES | 78 | 640 | 1700 | 480 | 12000 | 6800 | 15000 | 21000
 |  |  | YES | 1.7 | 2100 | 1000 | 280 | 710 | 3600 | - | -
 |  |  | YES | 1.6 | 1900 | 930 | 250 | 610 | 3100 | - | -
 |  |  | NO | 0.046 | 0.52 | 0.073 | 0.99 | 1100 | 1500 | - | -
 |  |  | YES | 1100 | 9200 | 24000 | 6900 | 30000 | 30000 | 30000 | 300000
 |  |  | YES | 60 | 110 | 120 | 65 | 210 | 150 | 1300 | 5600
 |  |  | YES | - | - | - | - | - | - | - | -
 |  |  | YES | - | - | - | - | - | - | - | -
 |  |  | YES | - | - | - | - | - | - | - | -
 |  |  | NO | 7.9 | 63000 | - | - | 30000 | 30000 | - | -
 |  |  | NO | - | - | - | - | - | - | - | -
 |  |  | NO | - | - | - | - | - | - | - | -
 |  |  | NO | - | - | - | - | - | - | - | -
 |  |  | YES | 440 | 1100 | 790 | 930 | 3000 | 2100 | 4300 | 30000
 |  |  | YES | - | - | - | - | 800 | 1000 | 3500 | 10000
 |  |  |  | Benzene | Toluene | Ethylbenzene | Xylenes | PHC F1 | PHC F2 | PHC F3 | PHC F4
 |  |  |  | 1.6 | 110 | 120 | 65 | 210 | 150 | 1300 | 5600
 |  |  |  | <0.010 | <0.080 | <0.010 | <0.100 | - | - | - | -
 |  |  |  | <0.04 | <0.10 | <0.10 | <0.1 | - | - | - | -
 |  |  |  | <0.0050 | <0.020 | <0.010 | <0.040 | <12 | <10 | <50 | <50
 |  |  |  | <0.0050 | <0.020 | <0.010 | <0.040 | <12 | 45 | 170 | 160
 |  |  |  | <0.0050 | <0.020 | <0.010 | 0.12 | <12 | 39 | <50 | <50
 |  |  |  | 0.045 | 0.24 | 8.1 | 98 | 1100 | 2600 | <50 | <50
Spreadsheet: 454966d1460048916-team-composition-maker-for-game-ferdyhar
Sheet: Sheet1

Example Team Selection |  |  |  |  |  |  |  |  |  |  |  | RATING | SCORE
 |  |  |  |  |  |  |  |  |  |  |  | No | 1
 | [NAME] field 1 | [NAME] field 2 | [NAME] field 3 | [NAME] field 4 | [NAME] field 5 |  |  |  |  |  |  | Badly | 2
 | Result field 1 | Result field 2 | Result field 3 | Result field 4 | Result field 5 |  |  |  |  |  |  | Average | 3
 |  |  |  |  |  |  |  |  |  |  |  | Well | 4
 |  |  |  |  |  |  |  |  |  |  |  | Godly | 5
In the insert fields i will manually type in a character name, in het result field a persons name will be put.
I wanne have it so it automatically makes a team with the 5 characters i give it with the highest possible skill level (overall) and also considering that a skill level of No means it is not an option for that person.
 |  |  |  |  |  |  |  |  | Strongest with character:
 | Character 1 |  |  |  |  |  |  |  | 1st | 2nd | 3rd | 4th | 5th
player 1 | 4 | 2 | 3 | 2 | 4 | 3 | 2
 | 2 | 1 | 3 | 2 | 3 | 5 | 1
 | 4 | 4 | 3 | 1 | 4 | 1 | 1
 | 5 | 2 | 5 | 2 | 4 | 1 | 4
 | 2 | 5 | 4 | 3 | 1 | 5 | 3
 | 2 | 1 | 5 | 2 | 4 | 4 | 5
 | 5 | 2 | 1 | 5 | 4 | 4 | 1
 | 1 | 4 | 5 | 2 | 5 | 1 | 2
 | 4 | 1 | 2 | 1 | 4 | 1 | 3
 | 4 | 5 | 3 | 3 | 4 | 2 | 1
 | 5 | 3 | 1 | 2 | 5 | 3 | 3
 | 1 | 3 | 2 | 1 | 4 | 4 | 4
 | 1 | 2 | 2 | 3 | 3 | 4 | 2
 | 3 | 5 | 4 | 3 | 2 | 1 | 5
 | 1 | 4 | 3 | 4 | 3 | 4 | 1
 | 5 | 4 | 4 | 5 | 1 | 4 | 2
BEST AT CHARACTER
2nd BEST
3rd BEST
4th BEST
5th BEST
Spreadsheet: 196840d1354120908-spreadsheet-to-show-the-results-of-golf-competitions-golf-league-table-including-reults
Sheet: COLLINGTREE

 |  | THE CROWN GOLF SOCIETY ANSTEY LEICESTER
 |  |  | RESULT COLLINGTREE PARK G.C 2012
 | PLAYER | HANDICAP | POINTS SCORED | LEADERBOARD POINTS
1ST |  |  |  | 30
2ND |  |  |  | 29
3RD |  |  |  | 28
4TH |  |  |  | 27
5TH |  |  |  | 26
6TH |  |  |  | 25
7TH |  |  |  | 24
8TH |  |  |  | 23
9TH |  |  |  | 22
10TH |  |  |  | 21
11TH |  |  |  | 20
12TH |  |  |  | 19
13TH |  |  |  | 18
14TH |  |  |  | 17
15TH |  |  |  | 16
16TH |  |  |  | 15
17TH |  |  |  | 14
18TH |  |  |  | 13
19TH |  |  |  | 12
20TH |  |  |  | 11
21ST |  |  |  | 10
22ND |  |  |  | 9
23RD |  |  |  | 8
24TH |  |  |  | 7
25TH |  |  |  | 6
26TH |  |  |  | 5
27TH |  |  |  | 4
28TH |  |  |  | 3
29TH |  |  |  | 2
30TH |  |  |  | 1
31st |  |  |  | 0
32nd |  |  |  | 0
33rd |  |  |  | 0
34th |  |  |  | 0
35th |  |  |  | 0
36th |  |  |  | 0
37th |  |  |  | 0
38th |  |  |  | 0
39th |  |  |  | 0
40th |  |  |  | 0
41st |  |  |  | 0
42nd |  |  |  | 0
43rd |  |  |  | 0
44th |  |  |  | 0
45th |  |  |  | 0
46th |  |  |  | 0
47th |  |  |  | 0
48th |  |  |  | 0
49th |  |  |  | 0
50th |  |  |  | 0
 | LONGEST DRIVE |  |  | 28TH JULY 2012
 | NEAREST PIN
Spreadsheet: 692787d1598558288-logistics-problem-solution-needed-diesel-logistics
Sheet: Sheet3

Column 1 | Column 2 | Column 3 | Column 4 | column 5
Km reading | Diesel | Total Diesel | Km travelled | Tank Full
4000 | 10 | NA | NA | NO
5000 | 20 | 30 |  | YES
6000 | 30 | NA | NA | NO
7000 | 40 | NA | NA | NO
8000 | 50 | 120 | 3000 | YES
9000 | 60 | 60 | 1000 | YES
Input Column:1,2,5{Red font}
Output Column:3,4{Black Font}
Column "Tank Full" entry could be either "YES" or "NO" only
if entry in column "Tank Full" is "NO" THEN Column "Total Diesel" and column "km travelled" should display"NA"
However if entry in column "Tank Full" is "YES" THEN Column"Total Diesel" should be sum of column "diesel" till the preceding "tank full" is "no"
Like C4 is B3+B4
C7 Is B5+B6+B7
C8 is B8
When "TANK FULL" IS "YES" then column "Km travelled" should be difference between column "Km reading" of current "tak full" is"yes" to the previous column "Km reading " corresponding to "tank full " is "yes"
Like [NAME] is A7-A4
D8 Is A8-A7
D4 Cell can be manually set to zero.
Spreadsheet: 214652d1361033726-finding-the-2nd-lookup-value-when-counter-gets-to-zero-sample-ans2
Sheet: Sheet1

TABLE 1 |  |  | TABLE 2
NAme | Sessions in PAckAge | Helper column | NAme | [NAME] | [NAME]
[NAME] | 12 |  | [NAME] |  |  |  | In Column E Array formula is used
[NAME] | 18 |  | Kelly |  |  |  | Column C is helper column.
[NAME] | 9 |  | Kelly |  |  |  | Values in Column B are changed.
Kelly | 4 |  | [NAME]
Adam | 2 |  | Kelly
[NAME] | 10 |  | Kelly
[NAME] | 20 |  | Kelly
Kelly | 8 |  | Kelly
Adam | 12 |  | Kelly
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Adam
 |  |  | Adam
 |  |  | Adam
 |  |  | Adam
 |  |  | Kelly
 |  |  | Adam
 |  |  | Adam
 |  |  | [NAME]
 |  |  | Adam
 |  |  | Adam
Spreadsheet: 109998d1306802630-probability-question-talent-competition-yes-votes-probability
Sheet: Sheet1

 |  | Yes | No
 | Act 1 | 0.1 | 0.9 | 0.3549547034092503 | No
 | Act 2 | 0.6 | 0.4 | 0.8319897028737643 | No
 | Act 3 | 0.3 | 0.7 | 0.2406164142474673 | Yes
 | Act 4 | 0.01 | 0.99 | 0.7019340892177506 | No
 | Act 5 | 0.05 | 0.95 | 0.328887857371122 | No
 | Act 6 | 0.1 | 0.9 | 0.4660160055435271 | No
 | Act 7 | 0.4 | 0.6 | 0.495968172155613 | No | 1
 | Yes Votes |  | Probability
 | 0 | 614 | 0.1227263641814911
 | 1 | 1881 | 0.3759744153507895
 | 2 | 1677 | 0.335198880671597
 | 3 | 713 | 0.1425144913052169
 | 4 | 111 | 0.02218668798720768
 | 5 | 6 | 0.001199280431740955
 | 6 | 1 | 0.0001998800719568259
 | 7 |  | 0
 | Total | 5003
Spreadsheet: 879499d1727084091-fishing-league-table-and-result-spreadsheet-fgpac-2024-league-table
Sheet: 3

Croft Fisheries | Huyton 1 | 18th September 2016
Name | lbs | oz | Oz (total) | Points
 | 1 | 15
 | 5 | 4
 | 13 | 0
 | 0 | 0
 | 6 | 8
 | 11 | 14
 | 1 | 6
 | 15 | 0
 | 5 | 2
 | 2 | 1
 | 1 | 13
 | 6 | 15
 | 0 | 0
 | 1 | 3
 | 11 | 5
 | 0 | 0
Spreadsheet: 174007d1344883971-hello-and-need-help-pulling-data-from-3-sheets-into-1-sheet-via-onclick-function-example1
Sheet: Parts List

Part Description | Part Number | [NAME]
 |  | CNS2345vX | DK-2345-10060-1A | DK-3456-10048-3A | DB-3456-10050-3A | DK-4567-10048-3A | DB-4567-10050-3A | DK-5678-10048-3A | DB-5678-10050-3A
1  Comp Battery Safety Note | 1234567-0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Quick Start Guide | CS-216703-MAP1 |  | 1
[NAME] | CS-213120-UGP4 |  |  | 1 |  | 1
Dev Board | CNS23451vX |  | 1
2345 SB-SPI Converter | 247446??? |  | 1 |  |  |  | 1
DEV-PC-4567 Interface board | DEV-PC-4567 |  | 1 |  |  | 1 | 1
Wired Headphone Adaptor | CNS11007v2 |  | 1 |  |  |  | 1
Light Blue RJ24 cable | 111 |  | 1
USB Cable | 22232 |  | 1
Serial Cable | 11325 |  | 1
Mini USB Cable | 2345 |  | 1 | 1 |  | 1 |  | 1
Pro Signal audio Cables | 2345 |  | 2
Headset w/Boom Mic | 11661 |  | 1 |  |  | 1 |  | 1
Boom Mic Soc | 1235661 |  | 1
Unknown [NAME] labled [NAME] | 12366 |  |  | 1
Comp2345 Development Board | 131236 |  |  | 1 | 1 |  |  |  | 1
USB Dongle | qer12345y |  |  | 1 |  |  | 1
USB to SPI Adaptor | CNS10020V3A |  |  | 1
Coin Cell Battery | CR2032 |  |  | 1 | 1
Adaptor Cable | ???? |  |  | 1
Spreadsheet: 863197d1710777005-vlookup-if-with-conditions-in-two-columns-solar-salaried-employee-list-test_3
Sheet: WD DROP

Employee ID | [NAME] | [NAME] | [NAME] First Name | Original Hire Date | Work Phone # | Personal Phone #
1001 | [NAME] | Roman | [NAME] | 2003-07-07 00:00:00 | +[PHONE] | +[PHONE]
1036 | [NAME] | [NAME] | [NAME] | 2004-10-18 00:00:00 | +[PHONE] | +[PHONE]
1037 | [NAME] | Soto | [NAME] | 2004-10-18 00:00:00 |  | +[PHONE]
1068 | [NAME] | Jones | Kayla | 2011-08-25 00:00:00 | +[PHONE] | +[PHONE]