tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 39137d1237332962-concatenate-with-randomness-676210-combinations
Sheet: Sheet1

Cum: | 729 | 243 | 81 | 27 | 9 | 3
Count: | 3 | 3 | 3 | 3 | 3 | 3
 | Item1 | Item2 | Item3 | Item4 | Item5 | Item6
 | the | quick | [NAME] | fox | jumped | 3024569
 | a | fast | blue | animal | leaped | 3022365
 | this | turbo | black | [NAME] | hopped | 3265418
# | Permutations
1 | the | quick | [NAME] | fox | jumped | 3024569
2 | the | quick | [NAME] | fox | jumped | 3022365
3 | the | quick | [NAME] | fox | jumped | 3265418
4 | the | quick | [NAME] | fox | leaped | 3024569
5 | the | quick | [NAME] | fox | leaped | 3022365
6 | the | quick | [NAME] | fox | leaped | 3265418
7 | the | quick | [NAME] | fox | hopped | 3024569
8 | the | quick | [NAME] | fox | hopped | 3022365
9 | the | quick | [NAME] | fox | hopped | 3265418
10 | the | quick | [NAME] | animal | jumped | 3024569
11 | the | quick | [NAME] | animal | jumped | 3022365
12 | the | quick | [NAME] | animal | jumped | 3265418
13 | the | quick | [NAME] | animal | leaped | 3024569
14 | the | quick | [NAME] | animal | leaped | 3022365
15 | the | quick | [NAME] | animal | leaped | 3265418
16 | the | quick | [NAME] | animal | hopped | 3024569
17 | the | quick | [NAME] | animal | hopped | 3022365
18 | the | quick | [NAME] | animal | hopped | 3265418
19 | the | quick | [NAME] | [NAME] | jumped | 3024569
20 | the | quick | [NAME] | [NAME] | jumped | 3022365
21 | the | quick | [NAME] | [NAME] | jumped | 3265418
22 | the | quick | [NAME] | [NAME] | leaped | 3024569
23 | the | quick | [NAME] | [NAME] | leaped | 3022365
24 | the | quick | [NAME] | [NAME] | leaped | 3265418
25 | the | quick | [NAME] | [NAME] | hopped | 3024569
26 | the | quick | [NAME] | [NAME] | hopped | 3022365
27 | the | quick | [NAME] | [NAME] | hopped | 3265418
28 | the | quick | blue | fox | jumped | 3024569
29 | the | quick | blue | fox | jumped | 3022365
30 | the | quick | blue | fox | jumped | 3265418
31 | the | quick | blue | fox | leaped | 3024569
32 | the | quick | blue | fox | leaped | 3022365
33 | the | quick | blue | fox | leaped | 3265418
34 | the | quick | blue | fox | hopped | 3024569
35 | the | quick | blue | fox | hopped | 3022365
36 | the | quick | blue | fox | hopped | 3265418
37 | the | quick | blue | animal | jumped | 3024569
38 | the | quick | blue | animal | jumped | 3022365
39 | the | quick | blue | animal | jumped | 3265418
40 | the | quick | blue | animal | leaped | 3024569
41 | the | quick | blue | animal | leaped | 3022365
42 | the | quick | blue | animal | leaped | 3265418
43 | the | quick | blue | animal | hopped | 3024569
Spreadsheet: theresa_staab__39630__Citation Statement
Sheet: Enron as Agent Balancing

 |  |  |  | BEAR PAW ENERGY
 |  |  |  | 1400 16th Street, Suite 310
 |  |  |  | Denver, CO  80202
 |  |  |  | (720) 946-3694
 |  | ANTELOPE VALLEY GAS BALANCING STATEMENT
Producer: | Citation Oil & Gas Corp.
 | 8223 Willow Place South
 | Houston, TX  77070-5623
 | Gas | Allocated | Allocated | Gas | Gas | Total | Ft. Union | TCGS | Cumulative
 | Received into | Receipts into | Receipts Into | Delivered | Delivered | Gas | Monthly | Monthly | MMBtu  Due
 | Antelope Valley | Ft. Union | TCGS | Ft. Union | TCGS | Delivered | Imbalance | Imbalance | Producer
 | MMBtu | MMBtu | MMBtu | MMBtu | MMBtu | MMBtu | MMBtu | MMBtu | (Bear Paw)
2001-05-01 00:00:00 | 22226 | 22226 | 0 | 22907 | 0
2001-06-01 00:00:00 | 20114 | 20114 | 0 | 21180 | 0
2001-07-01 00:00:00 | 18940 | 18940 | 0 | 19296 | 0
2001-08-01 00:00:00 | 18629 | 18629 | 0 | 18856 | 0
Spreadsheet: 818753d1677028480-display-the-average-of-the-previous-10-games-dynamically-bostoncelticsplayers
Sheet: Last10Avgs

 | Name | MP | FG | FGA | FG% | 3P | 3PA | 3P% | FT | FTA | ORB | DRB | TRB | AST | STL | BLK | TOV | PF | PTS | GMSC | PM
 | [NAME]
Spreadsheet: 220590d1363199408-error-in-my-index-match-formula-matching-problem
Sheet: Sheet1

code | idType | idHouseModel | idFurnishing | tbTier | tbPropertyCode | [NAME] | tbBlock | tbLot | tbLotArea | tbLotTCP | tbHLTCP
NEP-00-002-011 | HL | SA097 | CO | 1 | NEP | 0 | 2 | 11 | 175 | 1278000 | 4102000
NEP-00-002-011 | HL | SA097 | FR | 1 | NEP | 0 | 2 | 11 | 175 | 1278000 | 3829000
NEP-00-002-011 | HL | SA097 | ST | 1 | NEP | 0 | 2 | 11 | 175 | 1278000 | 3457000
NEP-00-002-011 | HL | SA121 | CO | 1 | NEP | 0 | 2 | 11 | 175 | 1278000 | 4930000
NEP-00-002-011 | HL | SA121 | FR | 1 | NEP | 0 | 2 | 11 | 175 | 1278000 | 4645000
NEP-00-002-011 | HL | SA121 | ST | 1 | NEP | 0 | 2 | 11 | 175 | 1278000 | 4189000
NEP-00-002-011 | LO | LOT** | NA | 1 | NEP | 0 | 2 | 11 | 175 | 1278000 | 0
NEP-00-002-017 | LO | LOT** | NA | 1 | NEP | 0 | 2 | 17 | 167 | 1253000 | 0
NEP-00-002-018 | LO | LOT** | NA | 1 | NEP | 0 | 2 | 18 | 151 | 1133000 | 0
NEP-00-002-019 | LO | LOT** | NA | 1 | NEP | 0 | 2 | 19 | 185 | 1462000 | 0
NEP-00-002-020 | LO | LOT** | NA | 1 | NEP | 0 | 2 | 20 | 170 | 1343000 | 0
Spreadsheet: 862744d1710396990-help-extracting-text-from-inconsistent-text-strings-text-extract-with-pq-too-4-
Sheet: Power Query

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Final Speed
# [NAME] | ML Odds | Med Eqp | Days Since L/R | Run  Style | P T S | [NAME] | Dist/ E2 | Surf PACE Late | SPEED Spd | [NAME] | E1 | Best Pace E2 | Late | Sp1 | Sp2 | Sp3 | Sp4 | ACL | Spd Avg
7 Designated Hitter | 9/2 | [NAME] | 22 | E | 4 | 88 | 82 | 63 | 71 | 107 | 88 | 82 | 63 | 71 | 66 |  |  | (106.6) | 69
9 Kuwait Towers | 5/1 | L | 22 | NA | 3 | 89 | 83 | 61 | 70 | 107 | 89 | 83 | 61 | 70 | 60T | 53 |  |  | 61
3 Macuto | 15/1 | L | 22.. | NA | 2 | 87 | 81 | 58 | 67 | 107 | 87 | 81 | 58 | 67 | 59 | 25 | 63 |  | 50
10 T B Twelve Always | 8/1 | L | 15 | +E/P | 4 | 81 | 73 | 64 | *66* | 107 | 91 | 84 | 81 | 65 | 63 | 69 | 60T | 107.1 | 66
8 Cross Exam | 30/1 | ÈLb | 84 | NA | 2 | 64 | 58 | 71 | (61) | 108 | 64 | 58 | 71 | 48 | 61 |  |  |  | 55
6 Solar Flash | 30/1 | L | 34 | S | 2 | 63 | 54 | 58 | *51* | 109 | 72 | 56 | 62 | 51 | 51 |  |  | 106.8 | 51
13 Decisive Warrior | 15/1 | L | 8 | S | 6 | 90 | 80 | 32 | 50 | 107 | 90 | 80 | 67 | 62 | 63 | 41 | 53 |  | 55
2 Sleipnir | 30/1 | L | 41 | NA | 5 | 81 | 62 | 11 |  | 108 |  |  |  | 57 | 11 | 48 |  |  | 39
1 Builder Jak | 6/1 | L | 8 | S | 4 |  |  |  |  |  |  |  |  | 63 | 64 | 47 | 60 | (105.0) | 58
4 Federal Highway | 6/1 | L | 29 | NA | 4 |  |  |  |  |  |  |  |  | 62 |  |  |  |  | 62
5 No Match [NAME] | 20/1 | L |  | NA |  | No | Starts Available
11 Modern Lane | 3/1 | L | 98 | NA | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | -37
12 Torrefactor | 12/1 | ÈL | 50 | NA |  |  |  |  |  |  |  |  |  | 57T |  |  |  |  | 57 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rcg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Spd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SP4 | ACL | Avg
Spreadsheet: 705311d1606010067-averaging-a-set-of-numbers-depending-on-a-condition-manualexample-201121v2
Sheet: Sheet1

Round | A | B | SD | HCP-SD | Adjustment | HCP | Comment on HCP | Comment on SD | Adjustment? | [NAME]
 | 22 | 10
 | 24 | 13
 | 23 | 12
 | 25 | 14
 | 23 | 15 |  |  |  |  | HCP=Average of 8,11,11
 | 22 | 10 |  |  |  |  | HCP=Average of 8,11,11
 | 21 | 13 |  |  | -1 |  | HCP=Average of 8,8,11
 | 20 | 12 |  |  | -1 |  | HCP=Average of 8,8,8
 | 24 | 14 |  |  | -1 |  | HCP=Average of 8,8,8
 | 25 | 15 |  |  | -1 |  | HCP=Average of 8,8,10
 | 10 | 10 |  |  | -1 | 4.33333333333333 | HCP=Average of -1,7,7 | 8,7-0 >=5 so subract 1 from 5 most recent SDs
 | 23 | 13 |  |  |  | 5 | HCP=Average of -1,7,9
 | 21 | 12 |  |  |  | 5.666666666666667 | HCP=Average of -1,9,9
 | 17 | 14 |  |  | -1 | 3.66666666666667 | HCP=Average of -1,3,9
 | 25 | 15 |  |  | -1 | 3.66666666666667 | HCP=Average of -1,3,9
 | 23 | 10 |  |  | -1 | 7.333333333333333 | HCP=Average of -1,3,9
 | 22 | 13 |  |  | -2 | 7 | HCP=Average of 3,9,9
 | 6 | 12 |  |  | -2 | 1 | HCP=Average of -7,2,8 | 7-(-6) >=5 so subract 1 from 5 most recent SDs
 | 20 | 14 |  |  | -1 | 2.333333333333333 | HCP=Average of -7,6,8
 | 10 | 10 |  |  | -1 | -0.333333333333333 | HCP=Average of -7,0,6
 | 5 | 13 |  |  | -1 | -6 | HCP=Average of -9,-8,-1 | -8-(-0,3) >=5 so subract 1 from 5 most recent SDs |  |  |  | Row # [NAME] | Set adjustment | SD+Adjust | Find smallest 3 | Average
 | 26 | 12 |  |  |  | -6 | HCP=Average of -9,-8,-1 |  |  |  | --------------->
 | 25 | 20 |  |  |  | -1.666666666666667 | HCP=Average of -9,-1,5 |  |  |  |  | 0 | -1 | 5 | -8
 | 23 | 22 |  |  |  | -3 | HCP=Average of -9,-1,1 |  |  |  |  | 0 | -1 | -1 | -1
 | 22 | 21 |  |  |  | -2.333333333333333 | HCP=Average of -9,1,1 |  |  |  |  | 21 | -1 | -9
 | 21 | 19 |  |  |  |  | HCP=Average of 1,1,2 |  |  |  |  | 0 | 0 | 14
 | 20 | 12 |  |  |  |  | HCP=Average of 1,1,2
 |  |  |  | Manual and correct calculation |  |  |  |  | Working solution but not dynamic |  |  | Breakdown of Working solution
Spreadsheet: 825604d1681414368-help-sorting-array-with-formula-sort-test
Sheet: Sheet1

PP |  | [NAME] | Power | E Pace | L Pace |  | >1 | 0 | sum | PP# | Indirect |  | [NAME] |  | [NAME]
 |  | 34.69927296761401 | 11.75285426460712 | 5.514705882352941 | 15.90909090909091 |  |  |  |  | 1 | K2
 |  | 0 | 0 | 0 | 0 |  |  |  |  | 2 | K3
 |  | 6.939854593522801 | 5.03693754197448 | 5.514705882352941 | 47.72727272727273 |  |  |  |  | 3 | K4
 |  |  |  |  |  |  |  |  |  | 4 | K5
 |  | 4.337409120951751 | 4.407320349227669 | 12.86764705882353 | 6.818181818181819 |  |  |  |  | 5 | K6
 |  | 11.566424322538 | 11.75285426460712 | 38.60294117647059 | 7.954545454545455 |  |  |  |  | 6 | K7
 |  | 34.69927296761401 | 35.25856279382135 | 38.60294117647059 | 15.90909090909091 |  |  |  |  | 7 | K8
 |  | 4.95703899537343 | 7.051712558764271 | 0 | 0 |  |  |  |  | 8 | K9
 |  | 6.939854593522801 | 5.03693754197448 | 5.514705882352941 | 7.954545454545455 |  |  |  |  | 9 | K10
 |  | 4.337409120951751 | 4.407320349227669 | 0 | 0 |  |  |  |  | 10 | K11
 |  | 11.566424322538 | 35.25856279382135 | 12.86764705882353 | 15.90909090909091 |  |  |  |  | 11 | K12
 |  | 4.95703899537343 | 5.03693754197448 | 5.514705882352941 | 6.818181818181819 |  |  |  |  | 12 | K13
 |  |  |  |  |  |  |  |  |  | 13 | K14
 |  |  |  |  |  |  |  |  |  | 14 | K15
 |  |  |  |  |  |  |  |  |  | 15 | K16
 |  |  |  |  |  |  |  |  |  | 16 | K17
Spreadsheet: 869070d1715733146-need-a-formula-for-net-sales-my-file-sweetfriend9-
Sheet: Sheet1

 | Date | Vegetables | Column1 | Fruits | Column2 | Milk | Column3 | Column4 |  | Net Sales
 |  | Credit | Cash | Credit | Cash | Credit | Cash | Qty. |  |  | Credit | Cash
 | 2024-05-01 00:00:00 | 1250 | 285 |  |  |  | 50 |  |  | Vegetables
 |  |  | 625 |  |  |  | 80 |  |  | Fruits
 |  |  |  |  |  |  |  |  |  | Milk
 |  |  |  |  |  |  | 70
 |  |  | 205 |  |  |  | 50
 |  |  | 240 |  |  |  | 50
 |  |  | 220 |  |  |  | 50
 |  |  | 724 |  |  |  | 50
Spreadsheet: 212317d1360091387-spend-based-on-region-and-atttributes-challenge-excel-help-2001jesper-oeldere-
Sheet: Sheet1

 | Input Sheet |  |  |  |  | Main sheet
 |  |  |  |  |  | Step 1 |  |  |  |  |  |  |  | Step 2 |  |  | Step 3 my problem
 | Vendor | Spend | Country
 | [NAME] | 12 | Sweden |  |  | Suppliers | [NAME] | Spend | Groping | Assign attribute | Unique | Spend |  | Countries | Regions
 | Banana1 | 10 | Sweden |  |  |  |  |  |  |  |  |  |  |  |  |  | EU
 | banana | 2 | USA |  |  |  | [NAME] |  | [NAME] | Old | [NAME] |  |  | Sweden | EU |  | North. A
 | Grape2 | 3 | USA |  |  |  | Banana1 |  | [NAME] | Old | Grape |  |  | USA | North. A |  | Asia
 | Grape | 24 | Portugal |  |  |  | Grape2 |  | Grape | New | Apple |  |  | Portugal | EU
 | Grape | 53 | USA |  |  |  | Grape |  | Grape | New |  |  |  | Norway | EU
 | Grape17 | 22 | Portugal |  |  |  | Grape17 |  | Grape | New |  |  |  | China | Asia
 | Apple | 245 | Norway |  |  |  | Apple |  | Apple | New
 | Apple | 3 | USA |  |  |  | Orange |  | Apple | New
 | Orange | 24 | China
 | This is a bacis view of my input
 | and its it not fixed values
 | they will change on a monthyly basis |  |  |  | 1 | As a begining i find the unique supplier and |  |  |  |  |  |  | 2 | i group the countries by region |  | 3 | I need to find the regional spend
 |  |  |  |  |  | group them  based on their "skills" |  |  |  |  |  |  |  |  |  |  | But problem is that it have to be devided into groups based on
 |  |  |  |  |  | And assign an attribute |  |  |  |  |  |  |  |  |  |  | the assignd attribute of the supplier
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This means that when looking at the North.A Spend, i will have
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | to be able to devide the spend based on the attribute
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ex. New =25 Old = 75 %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Based on my limited input iam having a hard time trying
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | to figure out how to used theese nessary groupings
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | efficietly, and how to retirve my regional ratios based on Attribute
Spreadsheet: 539672d1506327671-golf-formulas-help-please-golfpayoutsv2
Sheet: Sheet1 (Original)

POT | 60
 | NEXT WEEK
 | POINTS TO BE PULLED
 | 2017-09-18 00:00:00 | 2017-09-25 00:00:00 | 2017-10-02 00:00:00 | 2017-10-09 00:00:00 | 2017-10-16 00:00:00 | 2017-10-23 00:00:00 | 2017-10-30 00:00:00 | 2017-11-06 00:00:00 | 2017-11-13 00:00:00
RAY | 28
STAN | 29
WAYNE | 16
LYNN | 28
MOE | 22
CHRIS | 22
[NAME] | 28
HARRY | 23
PETE | 28
EDD | 19
[NAME] | 9
STEVE | 22
 | ACTUAL
 | POINTS PULLED
 | 28
 | 10
 | 27
 | 28
 | 24
 | 26
 | 7
 | 16
 | 30
 | MONEY
 | WON
# OF PLAYERS
 | if(b122>=8,
Spreadsheet: 93586d1293147888-pulling-data-from-matrixes-on-other-sheets-using-a-drop-down-menu-model
Sheet: California

 |  |  | California
 |  |  |  | [NAME]
Age of Wine | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
20+ years | 400 | 425 | 450 | 500 | 525 | 550 | 575 | 600
11-19 years | 350 | 375 | 400 | 425 | 450 | 475 | 500 | 525
8-10 years | 275 | 300 | 325 | 350 | 375 | 400 | 425 | 450
4-7 years | 200 | 225 | 250 | 275 | 300 | 325 | 350 | 375
1-3 years | 150 | 175 | 200 | 225 | 250 | 275 | 300 | 325
Spreadsheet: 128038d1320757972-excel-2007-drop-down-box-to-read-data-from-a-table-tablelookup
Sheet: Sheet1

Irradiance calc
TILT | 30°
ORIENTATION | SE/SW
 | I WANT THE ANSWER FROM THE ABOVE TWO DROP BOXES TO GO HERE!... I.E HORIZONTAL ANS SOUTH WOULD LEAVE "933" IN THIS CELL
 | ORIENTATION
TILT | South | SE/SW | E/W | NE/NW | North
Horizontal | 933 | 933 | 933 | 933 | 933
30° | 1042 | 997 | 886 | 762 | 709
45° | 1023 | 968 | 829 | 666 | 621
60° | 960 | 900 | 753 | 580 | 485
Vertical | 724 | 684 | 565 | 427 | 360
i am aiming to achieve the result from the two drop down boxes picking the relevant information from the table below.  The table would ideally be placed on a seperate sheet but is not essential.
Spreadsheet: 48810d1248112407-excel-formula-or-macro-test
Sheet: Annexe 2

 | January | February | March | April | May | June | July | August | September | October | November | December | Total
Revenu | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 78
Expense
Salary | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 78
Publicity | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 90
Total expense | 3 | 5 | 7 | 9 | 11 | 13 | 15 | 17 | 19 | 21 | 23 | 25 | 168
Projets spéciaux
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Brochure |  |  |  |  |  |  |  |  |  |  |  |  | 0
Starting |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 798206d1664368286-list-rows-with-unique-values-in-column-a-that-has-highest-values-in-column-b-unique-rows-with-highest-values
Sheet: Sheet2

Sample Data
38203 | 1 | UND 1 | UND 2 | UND 3 | UND 4 | UND 5 | UND 6 | UND 7 | UND 8
38203 | 2 | UND 9 | UND 10 | UND 11 | UND 12 | UND 13 | UND 14 | UND 15 | UND 16
42189 | 1 | UND 17 | UND 18 | UND 19 | UND 20 | UND 21 | UND 22 | UND 23 | UND 24
43869 | 1 | UND 25 | UND 26 | UND 27 | UND 28 | UND 29 | UND 30 | UND 31 | UND 32
45489 | 1 | UND 33 | UND 34 | UND 35 | UND 36 | UND 37 | UND 38 | UND 39 | UND 40
45489 | 2 | UND 41 | UND 42 | UND 43 | UND 44 | UND 45 | UND 46 | UND 47 | UND 48
45580 | 1 | UND 49 | UND 50 | UND 51 | UND 52 | UND 53 | UND 54 | UND 55 | UND 56
45580 | 2 | UND 57 | UND 58 | UND 59 | UND 60 | UND 61 | UND 62 | UND 63 | UND 64
45822 | 1 | UND 65 | UND 66 | UND 67 | UND 68 | UND 69 | UND 70 | UND 71 | UND 72
45822 | 2 | UND 73 | UND 74 | UND 75 | UND 76 | UND 77 | UND 78 | UND 79 | UND 80
45822 | 3 | UND 81 | UND 82 | UND 83 | UND 84 | UND 85 | UND 86 | UND 87 | UND 88
46383 | 1 | UND 89 | UND 90 | UND 91 | UND 92 | UND 93 | UND 94 | UND 95 | UND 96
46456 | 1 | UND 97 | UND 98 | UND 99 | UND 100 | UND 101 | UND 102 | UND 103 | UND 104
46456 | 2 | UND 105 | UND 106 | UND 107 | UND 108 | UND 109 | UND 110 | UND 111 | UND 112
Expected Result
38203 | 2 | UND 9 | UND 10 | UND 11 | UND 12 | UND 13 | UND 14 | UND 15 | UND 16
42189 | 1 | UND 17 | UND 18 | UND 19 | UND 20 | UND 21 | UND 22 | UND 23 | UND 24
43869 | 1 | UND 25 | UND 26 | UND 27 | UND 28 | UND 29 | UND 30 | UND 31 | UND 32
45489 | 2 | UND 41 | UND 42 | UND 43 | UND 44 | UND 45 | UND 46 | UND 47 | UND 48
45580 | 2 | UND 57 | UND 58 | UND 59 | UND 60 | UND 61 | UND 62 | UND 63 | UND 64
45822 | 3 | UND 81 | UND 82 | UND 83 | UND 84 | UND 85 | UND 86 | UND 87 | UND 88
46383 | 1 | UND 89 | UND 90 | UND 91 | UND 92 | UND 93 | UND 94 | UND 95 | UND 96
46456 | 2 | UND 105 | UND 106 | UND 107 | UND 108 | UND 109 | UND 110 | UND 111 | UND 112
Spreadsheet: 29206e1e-e9f4-4e90-ad36-b11d0557b26b
Sheet: Sheet1

 |  | [NAME] Verification
Date: |  |  | [NAME]:
Analyst: |  |  | Meter Program #:
Lab Name: |  |  | NC WW/GW Certificiation #
Instructions:  Fill in the information above.  Enter the actual concentrations of the standards in your curve in cells A19 through A23.  Enter the values that you observe on the meter in cells B19 through B23.  The % Recovery and the Correlation Coefficient will be automatically calulated.
For the curve to pass…
The Correlation Coefficient must be ≥ 0.995
and…
Standard concentrations less than 50 µg/L must have a %  Recovery between 75 - 125 %.
and…
Standard concentrations of 50 µg/L or higher must have a %  Recovery between 90 - 110 %.
Actual, µg/L | Observed, µg/L | % Recovery | Std Pass/Fail | slope | intercept
 | Corr. Coefficient = |  | Corr. Coefficient
 | Gel/Sealed Liquid Standard Observed Concentration = |  |  |  | µg/L
Gel/Sealed Liquid Standard Manufacturer: |  |  |  | Lot #:
 |  | [NAME]:
Spreadsheet: 165378d1341209809-dealing-with-student-grades-book3
Sheet: Sheet1

Student | Score | Grade | Correct Grade
5 | 89.9 | A+ | A+
16 | 83.6 | A+ | A+
19 | 83 | A | A
12 | 80.8 | A | A
2 | 79 | A | A
20 | 76.3 | A | A
14 | 65.2 | A | [NAME]
1 | 63.2 | [NAME] | [NAME]
6 | 61.6 | [NAME] | [NAME]
7 | 59.4 | [NAME] | [NAME]
15 | 50.1 | B | [NAME]
10 | 43.7 | B | [NAME]
18 | 43.7 | B | [NAME]
3 | 42.7 | B | [NAME]
4 | 40.5 | B | [NAME]
17 | 40.2 | C+ | [NAME]
13 | 36.7 | C+ | [NAME]
9 | 35.2 | C+ | [NAME]
11 | 13.4 | C | [NAME]
8 | 10.9 | C | [NAME]
Spreadsheet: 851559d1701774363-basic-vba-or-match-and-index-formula-needed-for-unique-column-with-values-test-list
Sheet: Sheet1

 |  | Main Data |  |  |  |  |  |  |  |  | Outputs |  | Jan-24
 |  | Benfeciary | Dec-23 | Jan-24 | Feb-24 |  |  |  |  |  | Date | Value | Amount | Condition 2 | Condition 3
 |  | A | 1 |  |  |  |  |  |  |  | 2023-12-06 00:00:00 |  | 4
 |  | B | 2 |  |  |  |  |  |  |  | 2023-12-06 00:00:00 | E | 5
 |  | C | 3 |  |  |  |  |  |  |  | 2023-12-18 00:00:00 | F | 6
 |  | D |  | 4 |  |  |  |  |  |  | 2023-12-16 00:00:00 | J | 13
 |  | E |  | 5 |  |  |  |  |  |  | 2023-12-13 00:00:00 | K | 14
 |  | F |  | 6 |  |  |  |  |  |  | 2023-12-30 00:00:00 | L | 15
 |  | G |  |  | 7 |  |  |  |  |  | 2023-12-25 00:00:00 | M | 16
 |  | H |  |  | 8 |  |  |  |  |  | 2023-12-16 00:00:00 | N | 17
 |  | I |  |  | 9
 |  | J | 10 | 13
 |  | K | 11 | 14
 |  | L | 12 | 15 | 18
 |  | M |  | 16 | 19
 |  | N |  | 17 | 20
Spreadsheet: 459848d1462827226-find-sum-of-of-days-w-o-counting-overlapping-days-twice-with-multiple-paramaters-sample
Sheet: Sheet2

File# | Begin | End
ab1 | 2015-10-09 00:00:00 | 2015-12-07 00:00:00
ab2 | 2016-01-04 00:00:00 | 2016-01-28 00:00:00
df5 | 2016-02-26 00:00:00 | 2016-03-02 00:00:00
dft | 2016-02-26 00:00:00 | 2016-03-21 00:00:00
er9 | 2016-03-21 00:00:00 | 2016-04-01 00:00:00
ab1 | 2015-05-22 00:00:00 | 2015-05-28 00:00:00
ab2 | 2015-05-22 00:00:00 | 2015-05-28 00:00:00
df5 | 2015-05-22 00:00:00 | 2015-07-08 00:00:00
dft | 2015-07-10 00:00:00 | 2015-07-10 00:00:00
er9 | 2015-12-21 00:00:00 | 2016-04-12 00:00:00
ab1 | 2016-04-18 00:00:00 | 2016-04-18 00:00:00
ab2 | 2015-10-07 00:00:00 | 2015-11-25 00:00:00
df5 | 2015-11-25 00:00:00 | 2015-12-15 00:00:00
dft | 2016-02-25 00:00:00 | 2016-02-29 00:00:00
er9 | 2016-04-19 07:16:48 | 2016-05-01 00:00:00
ab1 | 2015-01-14 00:00:00 | 2015-09-04 00:00:00
ab2 | 2015-11-19 00:00:00 | 2015-11-23 00:00:00
df5 | 2015-11-24 00:00:00 | 2016-01-28 00:00:00
dft | 2016-02-25 00:00:00 | 2016-03-28 00:00:00
er9 | 2016-04-12 12:26:46 | 2016-05-01 00:00:00
Spreadsheet: 678108d1589721257-merge-two-rows-into-one-merge_rows_example
Sheet: Sheet1

Player | Team | Color | Points
[NAME] | [NAME] | White | 4
[NAME] | [NAME] | White | 2 |  |  |  |  | Player | Team | Color | Sum of Points
[NAME] | [NAME] | White | 3 |  |  |  |  | [NAME] | Tropics | Orange | 13
[NAME] | Tropics | Orange | 6 |  |  |  |  | [NAME] | Gothics | Black | 4
[NAME] | Tropics | Orange | 7 |  |  |  |  | [NAME] | [NAME] | White | 9
[NAME] | Gothics | Black | 4 |  |  |  |  | Mark | Bulls | Grey | 3
Nick | Bluedogs | Blue | 9 |  |  |  |  | Nick | Bluedogs | Blue | 12
Nick | Bluedogs | Blue | 3 |  |  |  |  | [NAME] | Vixens | Yellow | 26
[NAME] | Vixens | Yellow | 5 |  |  |  |  | Grand Total |  |  | 67
[NAME] | Vixens | Yellow | 3
[NAME] | Vixens | Yellow | 10
[NAME] | Vixens | Yellow | 8
Mark | Bulls | Grey | 3
Spreadsheet: 169015d1342679509-matching-info-from-cell-to-cell-and-returning-yes-or-no-test
Sheet: Sheet1

 |  |  |  | [NAME] |  |  |  | BAK RWW 9
 |  |  |  | [NAME] |  |  |  | BAK RWW 4
 |  |  |  | [NAME] |  |  |  | BAK RWW 1
 |  |  |  | BAK Blue |  |  |  | BAK Pears
 |  |  |  | BAK Blue |  |  |  | BAK AW 09
 |  |  |  | BAK EW 9 |  |  |  | BAK AW 15
 |  |  |  | BAK FAV F1 |  |  |  | BAK AW 19
 |  |  |  | BAK FAV F1 |  |  |  | BAK Bandicoot
 |  |  |  | BAK FAV F7 |  |  |  | BAK C31
 |  |  |  | BAK FAV F7 |  |  |  | BAK C42
 |  |  |  | BAK FLAT MR TEST |  |  |  | [NAME]
 |  |  |  | BAK FLAT PRICE |  |  |  | BAK EW 3
 |  |  |  | BAK FLAT PRICE |  |  |  | BAK Young
 |  |  |  | BAK FLAT PRICE |  |  |  | BAK Spinach
 |  |  |  | BAK Grapes |  |  |  | BAK Seals
 |  |  |  | BAK Grapes |  |  |  | [NAME]
 |  |  |  | BAK Grapes |  |  |  | BAK FAV AW1
 |  |  |  | BAK Holiday 4 |  |  |  | BAK FAV AW 10
 |  |  |  | BAK Holiday 4 |  |  |  | BAK FAV C3
 |  |  |  | BAK Ivanhoe |  |  |  | BAK FAV F7
 |  |  |  | BAK JAYDEN |  |  |  | BAK FAV H5
 |  |  |  | BAK JAYDEN |  |  |  | BAK HJH
 |  |  |  | BAK JAYDEN |  |  |  | BAK Kangaroos
 |  |  |  | BAK JAYDEN |  |  |  | BAK Lighthouse
 |  |  |  | BAK JAYDEN |  |  |  | [NAME]
 |  |  |  | BAK KAI |  |  |  | BAK Grapes
Spreadsheet: 593544d1539197872-correct-way-of-linking-data-to-master-workbook-test-sheet
Sheet: DAY 1 Men

 |  |  | Measurement | Macros calculated from Quantity
 |  |  |  | CAL | P | F | C
 |  |  | Breakfast
 |  |  | Lunch
 |  |  | Dinner
 |  |  | Snacks
 | Total - Entire Recipe
 |  |  |  | CAL | P | F | C
 | Per Serving
 | Macro %s
 | Daily Macros |  |  | 2000 | 100
 | Remaining