tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 50843d1250348038-concatenate-formula-help-sample4
Sheet: merge

 |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 0 |  | 45678
Example:1: |  |  |  |  |  |  |  |  |  | 0 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 |  | 90098
Target Column: U, Cell 3 (will be selected at random every time) |  |  |  |  |  |  |  |  |  | 4 | 5 | 4 | 5 | 4 | 5 | 4 | 5 | 4 | 5 | 3212 | 76543
Number of digit in entry will be: four(selected at random) |  |  |  |  |  |  |  |  |  | 2 | 3 | 2 | 2 | 3 | 2 | 3 | 2 | 3 | 2 | 3456 | 21454
Starting point from Col.K to T:  [NAME] onwards(this may change every time) |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 0 | 7890 | so on
Result will be as is from U3 downwards: |  |  |  |  |  |  |  |  |  | 0 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | so on | so on
 |  |  |  |  |  |  |  |  |  | 4 | 5 | 4 | 5 | 4 | 5 | 4 | 5 | 4 | 5 | so on | so on
 |  |  |  |  |  |  |  |  |  | 2 | 3 | 2 | 2 | 3 | 2 | 3 | 2 | 3 | 2 | so on
 |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1
Example:2 |  |  |  |  |  |  |  |  |  | 4 | 5 | 4 | 5 | 4 | 5 | 4 | 5 | 4 | 5
Target Column: V, Cell 1 (will be selected at random every time) |  |  |  |  |  |  |  |  |  | 2 | 3 | 2 | 2 | 3 | 2 | 3 | 2 | 3 | 2
Number of digit in entry will be: five(selected at random) |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 0
Starting point from Col.K to T:  N13 onwards(this may change every time) |  |  |  |  |  |  |  |  |  | 0 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1
Result will be as is from V1 downwards: |  |  |  |  |  |  |  |  |  | 4 | 5 | 4 | 5 | 4 | 5 | 4 | 5 | 4 | 5
 |  |  |  |  |  |  |  |  |  | 2 | 3 | 2 | 2 | 3 | 2 | 3 | 2 | 3 | 2
 |  |  |  |  |  |  |  |  |  | These entries are spread upto ten thousand)
Spreadsheet: 270310d1381434681-counting-unique-values-into-tw-odifferent-columns-solution
Sheet: Sheet1

 | Data |  |  |  |  |  | Have so far |  |  | Need
 | type | color | CP | date | data for formula |  |  |  |  |  | CP1 | CP2
 | car | red | CP1 | 2013-01-01 00:00:00 |  |  | Jan 2013 |  |  | Jan 2013
 | car | red | CP1 | 2013-01-04 00:00:00 |  |  | Feb 2013 |  |  | Feb 2013
 | van | red | CP1 | 2013-01-04 00:00:00 |  |  | Mar 2013 |  |  | Mar 2013
 | van | red | CP1 | 2013-01-04 00:00:00 |  |  | Apr 2013 |  |  | Apr 2013
 | van | red | CP1 | 2013-01-04 00:00:00 |  |  | May 2013 |  |  | May 2013
 | car | blue | CP1 | 2013-01-04 00:00:00 |  |  | Jun 2013 |  |  | Jun 2013
 | truck | grey | CP1 | 2013-01-15 00:00:00 |  |  | Jul 2013 |  |  | Jul 2013
 | truck | grey | CP1 | 2013-01-15 00:00:00 |  |  | Aug 2013 |  |  | Aug 2013
 | truck | grey | CP1 | 2013-01-15 00:00:00 |  |  | Sep 2013 |  |  | Sep 2013
 | scooter | green | CP1 | 2013-03-01 00:00:00 |  |  | Oct 2013 |  |  | Oct 2013
 | scooter | green | CP1 | 2013-03-01 00:00:00 |  |  | Nov 2013 |  |  | Nov 2013
 | scooter | green | CP1 | 2013-03-01 00:00:00 |  |  | Dec 2013 |  |  | Dec 2013
 | car | green | CP1 | 2013-04-01 00:00:00
 | car | green | CP1 | 2013-04-01 00:00:00
 | truck | grey | CP2 | 2013-01-25 00:00:00
 | truck | grey | CP2 | 2013-01-25 00:00:00
 | truck | grey | CP2 | 2013-01-25 00:00:00
 | car | red | CP2 | 2013-02-24 00:00:00
 | van | red | CP2 | 2013-02-16 00:00:00
 | van | red | CP2 | 2013-02-16 00:00:00
 | van | red | CP2 | 2013-02-16 00:00:00
 | car | blue | CP2 | 2013-02-20 00:00:00
 | scooter | green | CP2 | 2013-03-23 00:00:00
 | scooter | green | CP2 | 2013-03-23 00:00:00
 | car | green | CP2 | 2013-05-11 00:00:00
 | car | green | CP2 | 2013-05-11 00:00:00
Spreadsheet: 695683d1600341869-merging-data-by-using-unique-reference-in-excel-investor-detail_merge_fund_perf_chris
Sheet: Merged using Power Query

Inv Ref | Sal | Name | Surname | Add 1 | Add 2 | Add 3 | Add 4 | Add 5 | Inv Ref.1 | Total Contribution | Units | Unit price | Current Value | Gains or Losses
EXA001 | Mr | [NAME] | [NAME] | Buckingham Palace | Buckingham Gate | London | England | UK20 9BP | EXA001 | 100000 | 1000 | 135.448 | 135448 | 35448
EXA002 |  |  |  |  |  |  |  |  | EXA002 | 112000 | 112 | 1209.357142857143 | 135448 | 23448
EXA003 |  |  |  |  |  |  |  |  | EXA003 | 124000 | 124 | 1092.322580645161 | 135448 | 11448
EXA004 |  |  |  |  |  |  |  |  | EXA004 | 136000 | 136 | 995.9411764705883 | 135448 | -552
EXA005 |  |  |  |  |  |  |  |  | EXA005 | 148000 | 148 | 915.1891891891892 | 135448 | -12552
EXA006 |  |  |  |  |  |  |  |  | EXA006 | 160000 | 160 | 846.55 | 135448 | -24552
EXA007 |  |  |  |  |  |  |  |  | EXA007 | 172000 | 172 | 787.4883720930233 | 135448 | -36552
EXA008 |  |  |  |  |  |  |  |  | EXA008 | 184000 | 184 | 736.1304347826087 | 135448 | -48552
EXA009 |  |  |  |  |  |  |  |  | EXA009 | 196000 | 196 | 691.0612244897959 | 135448 | -60552
EXA010 |  |  |  |  |  |  |  |  | EXA010 | 208000 | 208 | 651.1923076923077 | 135448 | -72552
EXA011 |  |  |  |  |  |  |  |  | EXA011 | 220000 | 220 | 615.6727272727272 | 135448 | -84552
EXA012 |  |  |  |  |  |  |  |  | EXA012 | 232000 | 232 | 583.8275862068965 | 135448 | -96552
EXA013 |  |  |  |  |  |  |  |  | EXA013 | 244000 | 244 | 555.1147540983607 | 135448 | -108552
EXA014 |  |  |  |  |  |  |  |  | EXA014 | 256000 | 256 | 529.09375 | 135448 | -120552
EXA015 |  |  |  |  |  |  |  |  | EXA015 | 268000 | 268 | 505.4029850746269 | 135448 | -132552
EXA016 |  |  |  |  |  |  |  |  | EXA016 | 280000 | 280 | 483.7428571428571 | 135448 | -144552
EXA017 |  |  |  |  |  |  |  |  | EXA017 | 292000 | 292 | 463.8630136986301 | 135448 | -156552
EXA018 |  |  |  |  |  |  |  |  | EXA018 | 304000 | 304 | 445.5526315789473 | 135448 | -168552
EXA019 |  |  |  |  |  |  |  |  | EXA019 | 316000 | 316 | 428.632911392405 | 135448 | -180552
EXA020 |  |  |  |  |  |  |  |  | EXA020 | 328000 | 328 | 412.9512195121951 | 135448 | -192552
EXA021 |  |  |  |  |  |  |  |  | EXA021 | 340000 | 340 | 398.3764705882353 | 135448 | -204552
EXA022 |  |  |  |  |  |  |  |  | EXA022 | 352000 | 352 | 384.7954545454546 | 135448 | -216552
EXA023 |  |  |  |  |  |  |  |  | EXA023 | 364000 | 364 | 372.1098901098901 | 135448 | -228552
EXA024 |  |  |  |  |  |  |  |  | EXA024 | 376000 | 376 | 360.2340425531915 | 135448 | -240552
EXA025 |  |  |  |  |  |  |  |  | EXA025 | 388000 | 388 | 349.0927835051546 | 135448 | -252552
EXA026 |  |  |  |  |  |  |  |  | EXA026 | 400000 | 400 | 338.62 | 135448 | -264552
EXA027 |  |  |  |  |  |  |  |  | EXA027 | 412000 | 412 | 328.7572815533981 | 135448 | -276552
EXA028 |  |  |  |  |  |  |  |  | EXA028 | 424000 | 424 | 319.4528301886792 | 135448 | -288552
EXA029 |  |  |  |  |  |  |  |  | EXA029 | 436000 | 436 | 310.6605504587156 | 135448 | -300552
EXA030 |  |  |  |  |  |  |  |  | EXA030 | 448000 | 448 | 302.3392857142857 | 135448 | -312552
Spreadsheet: theresa_staab__39608__north central purchase detail 2001
Sheet: Aug 01

North Central Oil | Contact: | [NAME] |  |  | Enron North America
 | PH: | (713) 268-4532
 | FAX: |  |  |  | [NAME] | PH:  [PHONE]
 | E-Mail: | [EMAIL] |  |  |  | FAX:  [PHONE]
Aug, 2001
First of Month Nomination: | 24446
Btu factor
Transportation | 0.14 | per [NAME] (25,000/d)
IF CIG Index | 2.03
 |  | Index Discount/Premium | Lost Creek Transport/MMBtu | Total Net Back
Net Backs: | CIG GD | 0.03 | -0.15185676496
 | Firm Quantity | 0 | -0.15185676496
 | IF CIG (90%) | 0.04 | -0.15185676496
 |  | 90% of FOM Nom. Less Firm Quantity | 90% of FOM less Firm Quantity | Firm Quantity | Firm Quantity Volume MMBtu | GD Volume | CIG GD Volume MMBtu |  | Total Net Receipts MMBtu | $ CIG +.04 | $ [NAME] | $ CIG GD | Total Payment
 | CIG GD Rockies | IF CIG less Netback |  | CIG less Netback | 15000 | [NAME] less Netback
2001-08-01 00:00:00 | 2.445 |  |  |  |  |  |  |  | 24110.46
 | 2.62 |  |  |  |  |  |  |  | 24200.55
 | 2.48 |  |  |  |  |  |  |  | 24200.55
 | 2.33 |  |  |  |  |  |  |  | 24200.55
 | 2.33 |  |  |  |  |  |  |  | 24200.55
 | 2.33 |  |  |  |  |  |  |  | 24200.55
 | 2.345 |  |  |  |  |  |  |  | 23217.48
 | 2.405 |  |  |  |  |  |  |  | 23217.48
 | 2.425 |  |  |  |  |  |  |  | 22727.43
 | 2.415 |  |  |  |  |  |  |  | 22727.43
 | 2.23 |  |  |  |  |  |  |  | 22727.43
 | 2.23 |  |  |  |  |  |  |  | 22727.43
 | 2.23 |  |  |  |  |  |  |  | 22727.43
 | 2.08 |  |  |  |  |  |  |  | 24873.75
 | 2.27 |  |  |  |  |  |  |  | 24873.75
 | 2.445 |  |  |  |  |  |  |  | 24873.75
 | 2.905 |  |  |  |  |  |  |  | 24076.8
 | 2.62 |  |  |  |  |  |  |  | 24076.8
 | 2.62 |  |  |  |  |  |  |  | 24076.8
 | 2.62 |  |  |  |  |  |  |  | 24076.8
 | 2.545 |  |  |  |  |  |  |  | 24076.8
 | 2.645 |  |  |  |  |  |  |  | 24076.8
 | 2.755 |  |  |  |  |  |  |  | 23585.76
 | 2.265 |  |  |  |  |  |  |  | 23585.76
 | 2.155 |  |  |  |  |  |  |  | 23585.76
 | 2.155 |  |  |  |  |  |  |  | 23585.76
 | 2.155 |  |  |  |  |  |  |  | 23585.76
 | 2.135 |  |  |  |  |  |  |  | 18073.44
 | 2.175 |  |  |  |  |  |  |  | 18073.44
 | 2.17 |  |  |  |  |  |  |  | 18073.44
 | 2.18 |  |  |  |  |  |  |  | 18073.44
 |  |  |  |  |  |  |  |  | avg. $/MMBtu
Spreadsheet: 766923d1644167998-modify-existing-formula-to-only-include-results-based-on-a-date-range-month-test-data-for-upload
Sheet: gsp Output by Month

Site | Location | Franchise | Unique Vehicles Seen Total | Jan | Feb | March | April | May | June | July | Aug | Sept | Oct | Nov | Dec
001 |  |  |  | 9 | 2 | 3 | 2 | 2 | 1
002
003
004
005
006
007
008
009
010
021
022
023
024
025
026
027
028
029
030
031
032
033 | Void | Void
034 | Void | Void
035 | Void | Void
036 | Void | Void
037 | Void | Void
038 | Void | Void
039 | Void | Void
040 | Void | Void
041 | Void | Void
042 | Void | Void
043 | Void | Void
044 | Void | Void
045 | Void | Void
Spreadsheet: 685315d1593907914-need-help-extracting-the-value-in-a-table-based-on-a-calculated-time-using-match-or-index-example
Sheet: Sheet1

 | Time |  |  |  |  | Time |  | Table location
 | 19.723
 | 19.32 |  |  |  | 1st [NAME] with fastest time =
 | 18.48
 | 18.432 |  |  |  | 2nd Div starts 1 second slower than the fastest time = |  |  |  | Location 24 is the correctly found cell.  What formula will show the value in that cell (15.782)?
 | 18.428
 | 18.427 |  |  |  | 3rd Div starts 2.5 seconds slower than the fastest time = |  |  |  | Location 14 is the correctly found cell.  What formula will show the value in that cell (17.194)?
 | 18.327
 | 17.439
 | 17.423
 | 17.423
 | 17.353
 | 17.35
 | 17.307
3rd Div | 17.194
 | 17.078
 | 16.938
 | 16.8
 | 16.45
 | 16.384
 | 16.283
 | 16.213
 | 15.923
 | 15.837
2nd Div | 15.782
 | 15.38
 | 15.328
 | 15.32
 | 15.2
 | 15.029
 | 15.025
 | 14.829
 | 14.75
1st Div | 14.582
Spreadsheet: 728884d1618761380-count-duplicate-values-if-they-appear-in-the-same-month-example-1
Sheet: Sheet1

Customer Email Address |  |  | Date |  |  |  |  |  | Multiple Subscription
Email Address T |  |  | 2020-12-01 00:00:00
Email Address T |  |  | 2020-12-04 00:00:00
Email Address T |  |  | 2020-12-25 00:00:00 |  |  |  |  |  | 3
Email Address T |  |  | 2021-01-08 00:00:00
Email Address V |  |  | 2021-01-28 00:00:00
[NAME] |  |  | 2021-02-12 00:00:00
Email Address X |  |  | 2021-01-16 00:00:00
Email Address Y |  |  | 2021-02-05 00:00:00
Email Address Y |  |  | 2021-02-12 00:00:00 |  |  |  |  |  | 2
Email Address Z |  |  | 2021-01-06 00:00:00
Email Address Z |  |  | 2021-02-06 00:00:00
Spreadsheet: 489999d1479554512-football-predictions-football-predictions
Sheet: Week 11

Fixtures | Week 11 |  |  |  |  | Player Scores
Home Team | Score |  |  | Away Team |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Damian West | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Bournemouth |  | - |  | Sunderland |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Burnley |  | - |  | Crystal Palace |  | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Manchester City |  | - |  | Middlesbrough |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
West Ham |  | - |  | Stoke City |  | 0 | 5 | 0 | 0 | 5 | 5 | 0 | 5 | 5 | 0 | 5 | 0 | 5 | 0 | 2 | 5 | 5 | 0 | 5 | 0
Chelsea |  | - |  | Everton |  | 2 | 2 | 2 | 0 | 2 | 2 | 0 | 2 | 2 | 2 | 2 | 2 | 2 | 0 | 2 | 2 | 2 | 0 | 2 | 2
Arsenal |  | - |  | Tottenham |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0
Hull City |  | - |  | Southampton |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Liverpool |  | - |  | Watford |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 0 | 2 | 2 | 2 | 2 | 2 | 2
Swansea City |  | - |  | [NAME] |  | 0 | 2 | 5 | 2 | 0 | 0 | 2 | 2 | 0 | 2 | 2 | 2 | 0 | 0 | 2 | 2 | 2 | 0 | 2 | 2
Leicester City |  | - |  | West Brom |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Home Team | Score |  |  | Away Team | Weekly Total
Bournemouth | 1 | - | 2 | Sunderland |  | 2-0 | 2-0 | 3-1 | 1-1 | 3-0 | 1-0 | 2-0 | 1-1 | 1-2 | 2-1 | 2-0 | 1-1 | 0-1 |  | 1-1 | 3-1 | 2-1 | 2-1 | 2-1 | 2-1
Burnley | 3 | - | 2 | Crystal Palace |  | 1-2 | 1-1 | 1-1 | 1-2 | 2-1 | 2-1 | 0-0 | 1-1 | 0-2 | 1-0 | 0-1 | 1-1 | 0-2 |  | 0-1 | 1-2 | 0-1 | 0-0 | 1-1 | 0-1
Manchester City | 1 | - | 1 | Middlesbrough |  | 2-0 | 3-0 | 4-0 | 3-1 | 3-1 | 3-1 | 5-0 | 2-0 | 3-0 | 3-0 | 3-0 | 2-0 | 3-0 |  | 3-1 | 3-1 | 2-0 | 2-1 | 3-0 | 3-0
West Ham | 1 | - | 1 | Stoke City |  | 1-0 | 1-1 | 2-1 | 1-0 | 1-1 | 1-1 | 0-1 | 1-1 | 1-1 | 2-0 | 1-1 | 1-2 | 1-1 |  | 2-2 | 1-1 | 1-1 | 2-0 | 1-1 | 1-2
Chelsea | 5 | - | 0 | Everton |  | 2-1 | 2-0 | 2-1 | 1-1 | 2-1 | 2-1 | 2-2 | 2-1 | 2-1 | 2-1 | 3-1 | 1-0 | 3-1 |  | 1-0 | 2-1 | 2-1 | 0-1 | 2-0 | 2-1
Arsenal | 1 | - | 1 | Tottenham |  | 2-0 | 3-1 | 3-2 | 2-1 | 3-0 | 2-1 | 2-0 | 2-1 | 2-1 | 1-1 | 3-0 | 2-1 | 3-1 |  | 2-1 | 1-0 | 1-1 | 3-1 | 2-1 | 2-1
Hull City | 2 | - | 1 | Southampton |  | 1-2 | 1-2 | 1-2 | 1-3 | 1-2 | 0-1 | 1-2 | 1-2 | 0-2 | 1-1 | 0-1 | 1-2 | 1-2 |  | 0-1 | 1-2 | 1-2 | 0-2 | 1-2 | 1-1
Liverpool | 6 | - | 1 | Watford |  | 3-1 | 2-1 | 2-0 | 3-0 | 4-0 | 3-2 | 3-1 | 2-1 | 2-1 | 2-0 | 3-1 | 2-0 | 2-0 |  | 2-1 | 3-0 | 2-1 | 2-0 | 3-1 | 3-1
Swansea City | 1 | - | 3 | [NAME] |  | 2-2 | 1-2 | 1-3 | 1-2 | 0-0 | 1-1 | 0-2 | 1-2 | 1-1 | 1-2 | 1-2 | 1-2 | 2-1 |  | 0-1 | 1-2 | 1-2 | 1-0 | 1-2 | 0-2
Leicester City | 1 | - | 2 | West Brom |  | 2-1 | 2-0 | 1-0 | 1-0 | 2-1 | 2-0 | 2-0 | 1-0 | 2-2 | 3-1 | 2-1 | 2-0 | 4-0 |  | 2-0 | 2-1 | 2-0 | 2-0 | 2-0 | 1-1
Spreadsheet: 031b74af-dfe2-4031-bbdd-2e9708dd4319
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  |  |  | International Taekwon-Do Federation
International Instructor Course  14-16 November 2014
 |  | City: | Treviso |  | Country: | Italy
Individual Application Form
Participant:
 | name |  |  |  | surname |  |  | M/F
ITF degree number |  |  |  |  | ITF Online number
 |  |  |  |  | (ask your national association)
ITF Plaque number
(your plaque must be paid for 2014)
Country
Date of Birth: |  |  |  |  | Nationality:
 | year | month | day
e.mail:
Your NA/AA
(Your Federation/Association must approve your application)
This is confirm that I,
in the position of :
approve the participation of the above mentioned person
to participate at the IIC to be held on 14-16 November 2014 in Treviso, Italy
NOTE:
This aplication will not be acepted without the proper plaque and certificate numbers.
Any NA or AA must request the IIC certificate ONLINE prior to the event
This application Form MUST be sent on or before May 1st, 2014 to [EMAIL]
Spreadsheet: 74117d1274717988-excel-2007-need-a-formula-to-search-specific-worksheet-sample
Sheet: Totals

 |  |  | 13
SKU # | [NAME] | Yesterday | Day | 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 | 31
12456 | Chicken
Spreadsheet: 74117d1274717988-excel-2007-need-a-formula-to-search-specific-worksheet-sample
Sheet: 14

SKU # | [NAME] | AMOUNT | CODE DATE | AMOUNT | CODE DATE | AMOUNT | CODE DATE | AMOUNT | CODE DATE | AMOUNT | CODE DATE |  |  |  | Total
12456 | Chicken
Spreadsheet: 5b9b41e5-8096-4ed7-8ab2-49960862ea20
Sheet: Sheet1

NP | Cognome | Nome | Under 35 (non aver compiuto 36 anni alla data del XX/XX/XXXX) | Data Nascita | [NAME] (indicare Città/Provincia) | CF | [NAME] di iscrizione (se consulente non richiesto) | Nr. di iscrizione  (se consulente non richiesto) | Data di abilitazione professionale  (è richiesto per un solo componente dei [NAME]) | Forma di partecipazione al concorso | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Tipologia concorrente (vedi art. 2.2 del disciplinare di concorso) | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19
 |  |  |  |  |  |  |  |  |  | Concorrente singolo | Capogruppo mandatario di Raggruppamento Temporaneo | Mandante Raggruppamento Temporaneo | [NAME](di concorrente singolo o di Raggruppamento Temporaneo) | Libero [NAME] | Libero professionista associato (indicare nome studio associato) | Società di Ingegneria (indicare nome Società di Ingegneria) | Società di professionisti (indicare nome società) | Prestatori di servizi di ingegneria ed architettura (specificare) | Altro - solo per consulenti e collaboratori (es. [NAME], artista, studente)
1 | COGNOME | Nome | SI/NO | GG/MM/AAAA | CITTA (PROV) | XXXXXXXXXXXXXXX | indicare | 2222 | 2222 | SI/NO | SI/NO | SI/NO | SI/NO | SI/NO | SI/NO (nome studio associato) | SI/NO (Società di Ingegneria) | SI/NO (nome [NAME]) | SI/NO (indicare) | SI/NO (indicare)
 | [NAME] tante righe quanti sono i componenti del "gruppo di progetto".
 | [NAME] da compilare per ogni soggetto che partecipa al "gruppo" di progetto e quindi: concorrente singolo/capogruppo, mandante del raggruppamento, consulenti e collaboratori)
 | [NAME]
NP | Cognome | Nome | Under 35 (non aver compiuto 36 anni alla data del XX/XX/XXXX) | Data Nascita | [NAME] (indicare Città/Provincia) | CF | [NAME] di iscrizione/[NAME] (se consulente non richiesto) | Nr. di iscrizione  (se consulente non richiesto) | Data di abilitazione professionale  (è richiesto per un solo componente dei [NAME]) | Forma di partecipazione al concorso |  |  |  | Tipologia concorrente (vedi art. 2.2 del disciplinare di concorso)
 |  |  |  |  |  |  |  |  |  | Concorrente singolo | Capogruppo mandatario di Raggruppamento Temporaneo | Mandante Raggruppamento Temporaneo | [NAME](di concorrente singolo o di Raggruppamento Temporaneo) | Libero [NAME] | Libero professionista associato (indicare nome studio associato) | Società di Ingegneria (indicare nome Società di Ingegneria) | Società di professionisti (indicare nome società) | Prestatori di servizi di ingegneria ed architettura (specificare) | Altro - solo per consulenti e collaboratori (es. [NAME], artista, studente)
1 | ROSSI | Mario | SI | 1980-09-29 00:00:00 | TORINO (TO) | DLVNLG80P29I138T | Architetti PPC - CESENA | 452 | 12/10/2007 | NO | SI | NO | NO | NO | SI (UN STUDIO) | NO | NO | NO | NO
2 | BIANCHI | Gianni | NO | 1940-09-29 00:00:00 | TORINO (TO) | ABCDEF40P29I138T | Architetti PPC - ROMA | 2780 | 12/10/1982 | NO | NO | SI | NO | SI | NO | NO | NO | NO | NO
3 | VERDE | [NAME] | NO | 1936-09-29 00:00:00 | TORINO (TO) | ABCDEF36P29I138T | nessuno |  |  | NO | NO | NO | SI | NO | NO | NO | NO | NO | Disegnatore
Spreadsheet: 107203d1304425256-dependent-lookups-dependentlistswithduplicatesremoved
Sheet: Lists

Concrete Blocks | Bricks | Paving Slabs | Tiles | Remove duplicates from lists
Thermalite | [NAME] | Garden Slabs | [NAME] | Thermalite | [NAME] | Garden Slabs | [NAME]
Ready Block | Coal Board | [NAME] | Redland | Ready Block | Coal Board | [NAME] | Redland
 | Engineering | [NAME] | [NAME] |  | Engineering | [NAME]
 | Firebricks | Hi-Grip Slabs | Redland |  | Firebricks | Hi-Grip Slabs
 | [NAME] | Garden Slabs | [NAME]
 | Coal Board | [NAME] | Redland
 | Engineering | [NAME]
 | Firebricks | Hi-Grip Slabs
Spreadsheet: 48650d1247861809-ammending-conditional-array-code-to-include-another-condition-conditon-to-exclude-lowest-value
Sheet: Sheet1

 | Want abilities to exclude smallest value in the C12:H12 range and use the next smallest value when a "Flag" value is placed into S12
 |  |  |  |  |  |  |  | Everything on this side are Lowest of the price quotes
 |  | Company | Company | Company | Company | Company | Company | If there is a flag found in column S for the item, the price display'd should be for the flag used. |  |  |  |  |  |  |  |  |  | Override Low price
 | Before Correction: | C | D | E | F | G | H | [NAME] are within the cells below: |  |  |  |  |  |  |  |  | P=Purchase | Flag=Select
8 | Little Mule Replacement Part,ReturnSpring 23L1 (Qty:2/tool)  for 344B | 0 | 3.85 | 6.09 | 5.49 | 0 |  |  | No Bid | 3.85 |  |  | No Bid | No Bid | Little Mule Replacement Part,ReturnSpring 23L1 (Qty:2/tool)  for 344B , (31) | 4
19 | 1840 PVC Hook fits all standard bucket ,Estex | 9.95 |  | 7.85 | 15.96 | 0 |  |  |  |  | 7.85 |  | No Bid |  | [NAME],Pg193,YellowPolymer Bucket Hook Cat HL5511 (Prefer a ETN-47-500 if available) | 8 | P
23 | LITTLE MULE WIRE GRIPS - .70-1.25,1200lb Safeload Wt 8lb | 0 | 336.24 | 257.03 | 267 |  |  |  | No Bid |  | 257.03 |  |  |  | EALMG-4800 Wire Grip 12,000# .70-1.25 pg214 | 2 | P
 |  | 0 | 0 | 0 | 0 | 0 | 0
 | Result After Formula Correction: | 0 | 0 | 0 | 0 | 0 | 0
8 | Little Mule Replacement Part,ReturnSpring 23L1 (Qty:2/tool)  for 344B | 0 |  | 6.09 | 5.49 | 0 |  |  | No Bid |  |  | 5.49 | No Bid | No Bid | Little Mule Replacement Part,ReturnSpring 23L1 (Qty:2/tool)  for 344B , (31) | 4 | P | D | 5.49  is not lowest price but offers better quality thus item is chosen for purchase
19 | 1840 PVC Hook fits all standard bucket ,Estex | 9.95 |  |  | 15.96 | 0 |  |  | 9.95 |  |  |  | No Bid | No Bid | [NAME],Pg193,YellowPolymer Bucket Hook Cat HL5511 (Prefer a ETN-47-500 if available) | 8 | P | E
23 | LITTLE MULE WIRE GRIPS - .70-1.25,1200lb Safeload Wt 8lb | 0 | 336.24 | 257.03 | 267 |  |  |  | No Bid |  | 257.03 |  |  |  | EALMG-4800 Wire Grip 12,000# .70-1.25 pg214 | 2 | P |  | 336.24 is not lowest price but offers features we want.
 |  |  |  |  |  |  |  |  |  | Flag Legend |  |  |  |  | No flag in cell S19, thus the lowest value/price gets displayed
 |  |  |  |  |  |  |  |  |  | C = C12 | Company C's price
 |  |  |  |  |  |  |  |  |  | D = D12 | Company D's price
 |  |  |  |  |  |  |  |  |  | E = E12 | Company E's price
 |  |  |  |  |  |  |  |  |  | F = F12 | Company F's price
 |  |  |  |  |  |  |  |  |  | G = G12 | Company G's Price |  |  | Change The Flag Values COL S to see new results.
 |  |  |  |  |  |  |  |  |  | H = H12 | Company H's Price