tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 12c6b00a-d4e3-42b7-9570-7bbf154551e4
Sheet: Example

Worksheet for Calculating Grain Contributions from a Recipe
1. Creditable Grain Ingredient | 2. Quantity | 3. [NAME] to [NAME] | [NAME]
[NAME] Flour | 10 cups | 120 | 1200
[NAME] flour | 25 ounces | 28.35 | 708.75
4. Total [NAME]
5. Total grams divided by number of portions in recipe:
Total grams of creditable grains from step 4
Enter Number of portions | 50
[NAME] of creditable grains per portion
6. Divide number of grams per portion
Grains/serving
7. Round down to the nearest 0.25 grains/serving
Ounce equivalent grains
* Must enter information into silver fields
Spreadsheet: 166299d1341523891-using-mod-row-to-display-in-every-nth-cell-with-some-cells-skipped-example2
Sheet: Setup

 |  |  |  |  |  |  | 7
 |  |  |  |  |  |  | Frequency | Days Per week
 | Item 1 | 10 | 100 | mg | box |  | 7
 | Item 2 | 10 | 100 | mg | box |  | 3
 | Item 3 | 10 | 100 | mg | box |  | 1
Spreadsheet: 896f7fd1-bfa4-4c0b-8a72-74cfcc6648e0
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
3548 | 9955 | [NAME] | Bethaz | ITA | 46 | 00:16:11 | 00:00:29 | [NAME] | 00:00:41 | 00:20:22 | 1 | 00:56:50
3548 | 15431 | [NAME] | [NAME] | GER | 43 | 00:16:31 | 00:00:41 | 00:19:05 | 00:00:56 | 00:21:40 | 2 | 00:58:56
3548 | 10299 | Ivano | Basso | ITA | 45 | 00:17:18 | 00:00:43 | 00:20:30 | 00:00:58 | 00:23:00 | 3 | 01:02:34
Spreadsheet: 702382d1604327619-subtract-1-from-last-5-records-manualexamplev2
Sheet: Manual -what i would like

HOW IT IS CURRENTLY |  |  |  |  |  | WHAT I WOULD LIKE
A | B | A-B | SUM last 5 |  |  | A | B | SUM last 5
3 | 3 |  |  |  |  | 3 | 3 | 0
3 | 3 |  |  |  |  | 3 | 3 | -1
3 | 3 |  |  |  |  | 3 | 3 | -1
3 | 3 |  |  |  |  | 3 | 3 | -1
3 | 3 |  |  |  |  | 3 | 3 | -2
3 | 4 |  |  |  |  | 4 | 5 | -2
3 | 3 |  |  |  |  | 8 | 8 | -1
3 | 3 |  |  |  |  | 6 | 6 | -1
3 | 4 |  |  |  |  | 2 | 1 | -1
3 | 3 |  |  |  |  | 3 | 3 | 0
3 | 3 |  |  |  |  | 4 | 4 | 0
Spreadsheet: 31947d1227980527-lookup-for-vertical-and-horizontal-corresponding-values-sample
Sheet: Sheet1

Number | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | Largest Values |  | Vertical Value | Horizontal Value
1 |  | 22 | 23 | 27 | 22 | 26 | 27 | 28 | 29 | 32 |  | 37 | = | 7 | 10
2 | 22 |  | 21 | 19 | 27 | 26 | 23 | 26 | 23 | 18 |  | 33 | = | 3 | 5
3 | 23 | 21 |  | 22 | 33 | 23 | 27 | 21 | 22 | 24 |  | 32 | = | 1 | 10
4 | 27 | 19 | 22 |  | 26 | 21 | 32 | 17 | 21 | 23 |  | 32 | = | 4 | 7
5 | 22 | 27 | 33 | 26 |  | 31 | 29 | 31 | 27 | 27 |  | 31 | = | 5 | 8
6 | 26 | 26 | 23 | 21 | 31 |  | 21 | 22 | 25 | 24 |  | 31 | = | 5 | 6
7 | 27 | 23 | 27 | 32 | 29 | 21 |  | 20 | 19 | 37 |  | 29 | = | 1 | 9
8 | 28 | 26 | 21 | 17 | 31 | 22 | 20 |  | 24 | 24 |  | 29 | = | 5 | 7
9 | 29 | 23 | 22 | 21 | 27 | 25 | 19 | 24 |  | 20 |  | 28 | = | 1 | 8
10 | 32 | 18 | 24 | 23 | 27 | 24 | 37 | 24 | 20 |  |  | 27 | = | 1 | 10 | The nos in cell P11 should be 7 instead of 10.
 |  |  |  |  |  |  |  |  |  |  |  | 27 | = | 1 | 9 | The nos in cell P12 should be 4 instead of 9.
 |  |  |  |  |  |  |  |  |  |  |  | 27 | = | 2 | 7 | The nos in cell P13 should be 5 instead of 7.
 |  |  |  |  |  |  |  |  |  |  |  | 27 | = | 3 | 7
 |  |  |  |  |  |  |  |  |  |  |  | 27 | = | 4 | 5 | The nos in cell O15 and P15 should be 5, 10 respectively.
 |  |  |  |  |  |  |  |  |  |  |  | 27 | = | 5 | 5 | The nos in cell O16 and P16 should be 5, 9 respectively.
Spreadsheet: 71314d1271977412-pulling-data-into-summary-page-example-2a
Sheet: Scrubbed Data

 | Total | Jan | Feb | March | April | May | June | July | Aug | Sept | Oct | Nov | Dec
CAROLINE
2007 | 5700 | 200 | 250 | 300 | 350 | 400 | 450 | 500 | 550 | 600 | 650 | 700 | 750
2008 | 4215 | 150 | 175 | 150 | 155 | 160 | 200 | 500 | 600 | 750 | 1000 | 250 | 125
2009 | 2400 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
 | 12315 | 550 | 625 | 650 | 705 | 760 | 850 | 1200 | 1350 | 1550 | 1850 | 1150 | 1075
BETTY
2007 | 7800 | 375 | 425 | 475 | 525 | 575 | 625 | 675 | 725 | 775 | 825 | 875 | 925
2008 | 4380 | 275 | 125 | 400 | 155 | 165 | 175 | 185 | 700 | 900 | 950 | 225 | 125
2009 | 2400 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
 | 14580 | 850 | 750 | 1075 | 880 | 940 | 1000 | 1060 | 1625 | 1875 | 1975 | 1300 | 1250
JOE
2007 | 6300 | 250 | 300 | 350 | 400 | 450 | 500 | 550 | 600 | 650 | 700 | 750 | 800
2008 | 4215 | 150 | 175 | 150 | 155 | 160 | 200 | 500 | 600 | 750 | 1000 | 250 | 125
2009 | 2400 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
 | 12915 | 600 | 675 | 700 | 755 | 810 | 900 | 1250 | 1400 | 1600 | 1900 | 1200 | 1125
Spreadsheet: 1095fd74-f3af-41b2-91f4-11a72b4da839
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
260703 | 63723 | [NAME] | Curran | GBR | 24 | [NAME] | 00:00:29 | 00:38:34 | [NAME] | 00:09:51 | 3 | 01:07:12
260703 | 73378 | [NAME] | [NAME] | CAN | 23 | 00:21:27 | 00:00:34 | 00:43:28 | 00:00:58 | 00:11:36 | 5 | 01:18:01
260703 | 74983 | [NAME] | Hecox | USA | 26 | [NAME] | 00:00:32 | 00:41:43 | 00:01:09 | 00:12:10 | 4 | 01:16:21
260703 | 69374 | Ivana | Kuriackova | SVK | 27 | [NAME] | 00:00:28 | 00:38:33 | 00:00:46 | 00:09:25 | 2 | 01:06:39
260703 | 47186 | Georgina | Schwiening | GBR | 22 | 00:17:30 | 00:00:29 | 00:33:55 | 00:00:49 | 00:09:52 | 1 | 01:02:32
Spreadsheet: 73936d1274469658-auto-filter-function-for-hiding-columns-730195-auto-filter-function-for-hiding-columns
Sheet: Sheet1

 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | Week 14 | Week 15 | Week 16
Week 1
Week 2
Week 3
Week 4
Week 5
Week 6
Week 7
Week 8
Week 9
Week 10
Week 11
Week 12
Week 13
Week 14
Week 15
Week 16
Spreadsheet: 473875d1470465504-separation-of-data-sample1
Sheet: jan

factory | sale | income | work day
a | 10 | 200 | 5
b | 20 | 300 | 6
c | 15 | 300 | 5
d | 5 | 500 | 4
Spreadsheet: 0232c878-9ca4-4b74-bb6e-287db0a8cef9
Sheet: Sheet1

Table 2--World cotton supply and use estimates | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  |  |  |  | 2012/13
Item | 2011/12 |  | July |  | Aug. |  | Sep.
 | Million 480-lb. [NAME]
Supply:
Beginning stocks--
World | 49.52 |  | 66.68 |  | 67.8 |  | 69.88
Foreign | 46.92 |  | 63.38 |  | 64.5 |  | 66.53
Production--
World | 124.16 |  | 113.81 |  | 114.11 |  | 114.03
Foreign | 108.59 |  | 96.81 |  | 96.46 |  | 96.92
Imports--
World | 44.91 |  | 37.39 |  | 37.2 |  | 36.6
Foreign | 44.89 |  | 37.39 |  | 37.19 |  | 36.59
Use:
[NAME] use--
World | 104.28 |  | 108.98 |  | 108.16 |  | 107.55
Foreign | 100.98 |  | 105.58 |  | 104.76 |  | 104.15
Exports--
World | 44.97 |  | 37.39 |  | 37.21 |  | 36.6
Foreign | 33.26 |  | 25.29 |  | 25.11 |  | 24.8
Ending stocks--
World | 69.88 |  | 72.39 |  | 74.67 |  | 76.52
Foreign | 66.53 |  | 67.59 |  | 69.17 | 71.22 | 71.22
 | Percent
Stocks-to-use ratio:
World | 67 |  | 66.4 |  | 69 |  | 71.1
Foreign | 65.9 |  | 64 |  | 66 |  | 68.4
 | 3
Last update: 09/13/12.
Source: USDA, World Agricultural Outlook Board.
Spreadsheet: 138647d1327782070-excel-2007-macro-for-inserting-rows-with-formulas-test-populated
Sheet: 55-85

Phase | Task | Description |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor Total | Quantity | Unit | Unit Price | Owned Equipment | Rented Equipment | Material | Subs | Other | [NAME] % | [NAME] Cost | Total Cost
 |  |  |  |  |  |  |  |  |  | Hours | Hours | Hours | Hours | Hours | Hours | Hours
 | 10
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
 | 50
 |  | Subtotals
PHASE 55 - | 60
 |  | Subtotals
 |  | Phase 55 Total
 | 10
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
 |  | Subtotals
 | 50
 |  | Subtotals
PHASE 60 - | 60
 |  | Subtotals
 |  | Phase 60 Total
 | 10
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
 |  | Subtotals
 | 50
 |  | Subtotals
PHASE 65 - | 60
 |  | Subtotals
 |  | Phase 65 Total
 | 10
 |  | .
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
 |  | Subtotals
 | 50
 |  | Subtotals
PHASE 70 - | 60
 |  | Subtotals
 |  | Phase 70 Total
 | 10
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
 |  | Subtotals
 | 50
 |  | Subtotals
PHASE 75 - | 60
 |  | Subtotals
 |  | Phase 75 Total
 | 10
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
 |  | Subtotals
 | 50
 |  | Subtotals
PHASE 80 - | 60
 |  | Subtotals
 |  | Phase 80 Total
 | 10
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
 |  | Subtotals
 | 50
 |  | Subtotals
PHASE 85 - | 60
 |  | Subtotals
 |  | Phase 85 Total
 |  | Page Totals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Page Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total (excluding markup)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Percentage
Spreadsheet: 791666d1660540926-calculation-formula-problem-more-efficient-formula-aligw
Sheet: Sheet1

A | Cancel | 0 | Complete | 8 | Complete | 7 | Cancel | 4 | sa | Member |  |  | You: | AliGW:
C | Complete | 0 | Complete | 8 | Complete | 7 | Complete | 4 | ds | Claim
B | Complete | 0 | Complete | 8 | Complete | 7 | Complete | 4 | fd | Member
D | Panding | 1 | Panding | 8 | Panding | 7 | Panding | 4 | sa | Member
A | Complete | 1 | Complete | 3 | Panding | 5 | Panding | 0 | rf | Claim
C | Complete | 1 | Complete | 3 | Cancel | 5 | Complete | 0 | hg | Member
B | Panding | 5 | Panding | 3 | Panding | 5 | Cancel | 0 | fd | Claim
D | Complete | 5 | Cancel | 3 | Complete | 9 | Complete | 2 | gg | Member
B | Cancel | 5 | Cancel | 2 | Cancel | 9 | Cancel | 2 | rr | Member
C | Complete | 5 | Complete | 2 | Complete | 9 | Complete | 2 | tt | Other
Spreadsheet: 705626d1606232940-how-can-i-use-index-and-match-to-populate-dropdown-list-with-multiple-values-im
Sheet: Sheet1

Searchstring
A |  |  |  |  | Dropdown:
 |  |  |  |  | 1
 | A | 1
 | B | 2
 | C | 3
 | A | 4
 | A | 5
 | D | 6
 | F | 7
Spreadsheet: louise_kitchen__24097__NEWCO HEADCOUNT NAMES1
Sheet: Portland Admin

Portland Administrative Staff |  |  | ok
Gustafson | [NAME] | Sr. Admin | 4000
[NAME] | [NAME] | [NAME] | 4500
Chatterton | [NAME] | [NAME] | 1500
Rodriguez | Grace |  | 3000
Sheppard | Kathy |  | 2000
Villeggiante | Theresa |  | 1500
 |  | 3
 |  | 6
Spreadsheet: 126644d1319805782-non-summarising-reports-book1
Sheet: Data Sheet

PO | CAT | ID | TYPE | DATE
CHINA | 1. Number | 1 | One | 2011-11-25 00:00:00
CHINA | 1. Number | 2 | Two | 2011-11-26 00:00:00
CHINA | 1. Number | 3 | Three | 2011-11-27 00:00:00
CHINA | 2. Colour | 4 | Red | 2011-10-28 00:00:00
CHINA | 2. Colour | 5 | Blue | 2011-10-29 00:00:00
CHINA | 2. Colour | 6 | Green | 2011-10-30 00:00:00
CANADA | 1. Number | 7 | One | 2011-11-25 00:00:00
CANADA | 1. Number | 8 | Two | 2011-11-26 00:00:00
CANADA | 1. Number | 9 | Three | 2011-11-27 00:00:00
CANADA | 2. Colour | 10 | Red | 2011-10-28 00:00:00
CANADA | 2. Colour | 11 | Blue | 2011-10-29 00:00:00
CANADA | 2. Colour | 12 | Green | 2011-10-30 00:00:00
Spreadsheet: 144957d1331224578-multiple-formula-test-ppo
Sheet: PPL

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date
 |  |  |  |  |  | Please arrange for the following items to be picked and issued to the workshop by;
Project Picking List |  |  |  |  |  | Requested By; |  |  |  |  |  |  |  |  |  |  |  |  | Picked By; |  | Received By;
Contract
Site
PO Number | Supplier | Item | 0 | Qty | 0 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | PRICE | SUB TOTAL | DISC % | £ |  | PO Number | Accepted? | Oty Ordered | Qty Delivered | Qty Issued | Locations
125555 | GGG | 1 | 1 | 2 |  | PLUGS
125555 | GGG | 2 |  | 2 |  | PLUGS
125555 | GGG | 3 |  | 4 |  | PLUGS
125555 | GGG | 4 |  | 10 |  | PLUGS
125555 | GGG | 5 |  | 4 |  | PLUGS
125555 | GGG | 6 |  | 1 |  | PLUGS
125555 | GGG | 7 |  | 5 |  | PLUGS
125555 | GGG | 8 |  | 5 |  | PLUGS
125555 | GGG | 9 |  | 10 |  | PLUGS
125555 | GGG | 10 |  | 8 |  | PLUGS
127777 | TFI | 1 |  | 10 |  | BITS
127777 | TFI | 2 |  | 10 |  | BITS
127777 | TFI | 3 |  | 1 |  | BITS
127777 | TFI | 4 |  | 2 |  | BITS
127777 | TFI | 5 |  | 3 |  | BITS
127777 | TFI | 6 |  | 5 |  | BITS
127777 | TFI | 7 |  | 5 |  | BITS
127777 | TFI | 8 |  | 6 |  | BITS
127777 | TFI | 9 |  | 10 |  | BITS
Spreadsheet: 268625d1380718368-finding-the-lowest-2-values-across-two-rows-return-row-headers-sampledata
Sheet: Sheet1

Category | Q | H | L | Z
No of Answers | 22 | 3 | 7 | 3
% Correct | 57.1 | 47.8 | 51.4 | 60
Sample % Correct | 66 | 55 | 65.3 | 54.7
Difference % | -8.9 | -7.2 | -13.9 | 5.3
Category | AP | RM | SR | ST
No of Answers | 7 | 9 | 10 | 9
% Correct | 65.2 | 59.6 | 54 | 45.2
Sample % Correct | 74 | 66.3 | 58.3 | 60
Difference % | -8.8 | -6.7 | -4.3 | -14.8
Expected Result: | -14.8 | ST | -13.9 | L
Spreadsheet: 264099b3-7447-435c-bdab-6c575d592007
Sheet: Sheet1

Table 2--Feed and residual use of wheat and coarse grains, 7/13/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Market year and quarter 1/ |  | Corn  (million metric tons) | Sorghum  (million metric tons) | Barley  (million metric tons) | Oats  (million metric tons) | Feed grains  (million metric tons) | Wheat  (million metric tons) | Energy feeds  (million metric tons) | Grain consuming animal units  (millions) | Energy feeds per grain consuming animal unit  (tons)
2010/11 | Q1 Sep-Nov | 52.56517625243693 | 2.278308027407873 | 0.03339892280853589 | 0.3692424370254856 | 55.24612563967882 | -1.710578956392525 | 53.5355466832863
 | [NAME] | 39.60915204511249 | 0.4116261200332755 | 0.1558688972531346 | 0.2912426710792143 | 40.46788973347812 | -0.07359084686626552 | 40.39429888661186
 | [NAME] | 18.19006432848806 | 0.3621446216176741 | 0.1719587303401672 | 0.2628795321828414 | 18.98704721262874 | -1.653072499503316 | 17.33397471312542
 | [NAME] | 11.37261625802519 | 0.09990284048694062 | 0.568935627059877 | 0.6743722960217218 | 12.71582702159373 | 5.569308480093186 | 18.28513550168691
 | MY Sep-Aug | 121.7370088840627 | 3.151981609545763 | 0.9301621774617146 | 1.597736936309263 | 127.4168896073794 | 2.13206617733108 | 129.5489557847105 | 92.94302041484113 | 1.393853515912037
2011/12 | Q1 Sep-Nov | 46.29057679729223 | 1.126669333790554 | -0.004724619458573851 | 0.3372977317653548 | 47.74981924338957 | -0.4613035704079884 | 47.28851567298158
 | [NAME] | 39.23443383945184 | 0.1455741619198212 | 0.2551947680826917 | 0.228396523304222 | 39.86359929275856 | 1.196694943622988 | 41.06029423638155
 | [NAME] | 21.70319991363599 | 0.390009715951306 | -0.121250717810128 | 0.2127575611601443 | 22.18471647293731 | -1.712892278132034 | 20.47182419480528
 | MY Sep-Aug | 115.5753684758657 | 1.905088491360424 | 1.139460642232546 | 1.401960063902111 | 120.0218776733608 | 6.870701644091368 | 126.8925793174521 | 93.80282381822707 | 1.352758628709803
2012/13 | MY Sep-Aug | 121.9256634470671 | 2.540117988480565 | 0.9688343852143358 | 1.419736993223323 | 126.8543528139854 | 5.43298579076141 | 132.2873386047468 | 92.93021126700579 | 1.423512728542719
1/ Corn and sorghum, September 1-August 31 marketing year; Barley and oats, June 1-May 31 marketing year. Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates and supporting materials.
Data run: 7/12/2012
Spreadsheet: 61f32a4e-8c49-453b-bfaa-a64afeb3af2b
Sheet: Sheet1

Species | Designed By | Production | [NAME] | ABI Taqman ID | Forward Primer | Probe | [NAME] | Notes
Human | Our Lab | ABI | mt-12S | - | ATCACTGCTGTTTCCC | ATGCAGCTCAAAACGCTTAGC | GCTGGCACGAAATTGACCAA
Human | Our Lab | ABI | mt-16S | - | CAAAGCGCCTTCCCC | CCCTGTACGAAAGGACAAGAGAAAT | [NAME]
Human | Our Lab | ABI | mt-ATP6 | - | ACTGCAGGCCACCTAC | CGTACGCCTAACCGCTAACATT | GCGACAGCGATTTCTAGGATAGT
Human | Our Lab | ABI | mt-ATP8 | - | CCCACCATAATTACCC | GCCCCAACTAAATACTACCGTATGG | [NAME]
Human | Our Lab | ABI | mt-COX1 | - | TAGCTGCTGGCATCACT | CAGCAGTCCTACTTCTCCTATCTCT | GGGTCGAAGAAGGTGGTGTT
Human | Our Lab | ABI | mt-COX2 | - | CCCGCCATCATCCTAG | GCCCTTTTCCTAACACTCACAACAA | [NAME]
Human | Our Lab | ABI | mt-COX3 | - | ACCCTCCTACAAGCCTC | [NAME] | GCCGTCGGAAATGGTGAAG
Human | Our Lab | ABI | mt-CYTB | - | CCCTCGGCTTACTTCT | TCACCTCCCATTCCGATAAAATCAC | GGGTTGGCTAGGGTATAATTGTCTG
Human | Our Lab | ABI | mt-ND1 | - | CACCGCCCCGACCTT | CCCTAAAACCCGCCACATCT | GGCTAGAATAAATAGGAGGCCTAGGT
Human | Our Lab | ABI | mt-ND2 | - | TTGCAGGCACACTCATC | AACCCGTCATCTACTCTACCATCT | GCTTCTGTGGAACGAGGGTTTATTT
Human | Our Lab | ABI | mt-ND3 | - | TCGAAGCCGCACTCGT | CCACAACTCAACGGCTACATAGAAA | GGGTAAAAGGAGGGCAATTTCTAGA
Human | Our Lab | ABI | mt-ND4 | - | CTCCTGAGCCAACAAC | TCACAACACCCTAGGCTCACTAA | GGGAGTCATAAGTGGAGTCCGT
Human | Our Lab | ABI | mt-ND4L | - | CTCAACACCCACTCCC | TCCTCCCTACTATGCCTAGAAGGA | CTTCGCAGGCGGCAAA
Human | Our Lab | ABI | mt-ND5 | - | TCGCTGTCACTTTCC | CGGAAGCCTATTCGCAGGATT | GTAGTTGAGGTCTAGGGCTGTTAGA
Human | Our Lab | ABI | mt-ND6 | - | CCACCACCCCATCATAC | GGTTAGCGATGGAGGTAGGATTG | AAAGCCCCCGCACCAATA
Human | ABI | ABI | C14orf2 | Hs00191690_m1
Human | ABI | ABI | SLIRP | Hs00364015_m1
Human | ABI | ABI | USMG5 | Hs00262094_m1
Human | ABI | ABI | CHCHD2 | Hs00853326_g1
Human | ABI | ABI | PARK7 | Hs00994896_g1
Human | ABI | ABI | ACTB | 4352668
Human | ABI | ABI | HPRT | 4333768
Human | ABI | ABI | LRPPRC | Hs00370167_m1
Human | ABI | ABI | UQCRC1 | Hs00163415_m1
Human | ABI | ABI | TFAM | Hs01082775_m1
Human | ABI | ABI | TFB1M | Hs00274971_m1
Human | ABI | ABI | TFB2M | Hs00254651_m1
[NAME] | ABI | ABI | ActB | 4352933
[NAME] | Our Lab | ABI | mt-Cox1 | - | GGGCAGCCATGAAGTCATTCTA | ATCGTATGCTTCAACAAATT | TGATCTTTATAATTTGAGAGGCCTTTGCT
Reagents for measuring mtDNA:
Species | Designed By | Production | [NAME] | ABI Taqman ID | Forward Primer | Probe | [NAME] | Notes
Human | Our Lab | ABI | mt-ND2 | - | TGTTGGTTATACCCTTCCCGTACTA | [NAME] | CCTGCAAAGATGGTAGAGTAGATGA | Human mtDNA assay
Human | PMID15649380 | ABI | ALUYB8 | - | CTTGCAGTGAGCCGAGATT | ACTGCAGTCCGCAGTCCGGCCT | GAGACGGAGTCTCGCTCTGTC | Human genomic DNA control.
[NAME] | Our Lab | ABI | mt-Cox1 | - | GGGCAGCCATGAAGTCATTCTA | ATCGTATGCTTCAACAAATT | TGATCTTTATAATTTGAGAGGCCTTTGCT | Mouse mtDNA assay
[NAME] | ABI | ABI | [NAME] | Mm00809079_s1 |  |  |  | Mouse genomic DNA control.
Spreadsheet: 755850d1637142922-create-a-rolling-4-week-13-week-avaerage-only-taking-into-account-full-weeks-example
Sheet: Sheet1

Range | Target | Predicted | COM | Vs. Target | Vs. Predicted | Conversion
4 Week
13 Week
YTD
Week Ending | Target | Predicted | COM | Vs. RDT | Vs. Predicted | Conversion
2021-07-09 00:00:00 | 15 | 17 | 15
2021-07-16 00:00:00 | 14 | 16 | 14
2021-07-23 00:00:00 | 16 | 18 | 14
2021-07-30 00:00:00 | 12 | 15 | 12
2021-08-06 00:00:00 | 11 | 14 | 13
2021-08-13 00:00:00 | 12 | 16 | 14
2021-08-20 00:00:00 | 13 | 16 | 13
2021-08-27 00:00:00 | 14 | 14 | 13
2021-09-03 00:00:00 | 14 | 18 | 16
2021-09-10 00:00:00 | 14 | 17 | 17
2021-09-17 00:00:00 | 15 | 17 | 15
2021-09-24 00:00:00 | 14 | 18 | 15
2021-10-01 00:00:00 | 15 | 14 | 11
2021-10-08 00:00:00 | 15 | 15 | 14
2021-10-15 00:00:00 | 14 | 16 | 16
2021-10-22 00:00:00 | 13 | 16 | 14
2021-10-29 00:00:00 | 10 | 14 | 14
2021-11-05 00:00:00 | 13 | 15 | 14
2021-11-12 00:00:00 | 10 | 12 | 11
2021-11-19 00:00:00 | 14 | 16 | 12
2021-11-26 00:00:00
2021-12-03 00:00:00
2021-12-10 00:00:00
2021-12-17 00:00:00
2021-12-24 00:00:00
2021-12-31 00:00:00
2022-01-07 00:00:00
2022-01-14 00:00:00
2022-01-21 00:00:00
2022-01-28 00:00:00
2022-02-04 00:00:00
2022-02-11 00:00:00
2022-02-18 00:00:00
2022-02-25 00:00:00
2022-03-04 00:00:00
2022-03-11 00:00:00
2022-03-18 00:00:00
2022-03-25 00:00:00
Spreadsheet: 7f52984b-bb6d-41c1-9b08-f5a440c0bdd0
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42768832 | 2014-08-18 00:33:04 | ALLIES | 0 | 2 | 6 | 256598 | sam1812 | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
42917514 | 2014-08-28 15:50:09 | AXIS | 0 | 3 | 6 | 1507591 | darckjester | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
42917769 | 2014-08-28 16:10:45 | ALLIES | 1 | 6 | 4 | 1507591 | darckjester | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
42945431 | 2014-08-30 16:27:42 | ALLIES | 1 | 6 | 5 | 512573 | Vangoce | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
42945755 | 2014-08-30 16:57:52 | AXIS | 0 | 2 | 6 | 512573 | Vangoce | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
42973185 | 2014-09-01 13:06:08 | AXIS | 1 | 6 | 2 | 1602314 | JL67 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42973315 | 2014-09-01 13:26:17 | ALLIES | 1 | 6 | 4 | 1602314 | JL67 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
Spreadsheet: d59f93f6-316a-441b-b55d-53553016028e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
7995 | 55725 | Francesco | Tanara | ITA | 133 | 00:20:32 | 00:00:00 | 00:25:19 | 00:00:00 | 00:25:36 | 1 | 01:11:27
7995 | 46517 | Evgeny | Chagin | RUS | 134 | 00:20:49 | 00:00:00 | 00:24:02 | 00:00:00 | [NAME] | 2 | 01:11:39
7995 | 15596 | Francesco | Dutto | ITA | 132 | 00:20:59 | 00:00:00 | 00:23:38 | 00:00:00 | [NAME] | 3 | 01:13:14
7995 | 55728 | Davide | Boni | ITA | 129 | 00:24:18 | 00:00:00 | 00:23:15 | 00:00:00 | 00:34:46 | 4 | 01:22:19
Spreadsheet: 231935d1367270008-excel-grouping-modgroups
Sheet: Sheet1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Spreadsheet: 41375d1239829654-counting-insertions-that-within-2-weeks-of-a-changing-date-range-insertion-order-within-2-weeks
Sheet: pd4 exp

Advertiserid | Advertiser | Date | Insertions
1010001000 | ABC | 2008-04-03 00:00:00 | 1
1010001616 | ABC | 2008-04-12 00:00:00 | 1
1010001616 | ABC | 2008-04-17 00:00:00 | 1
1010001616 | ABC | 2008-05-01 00:00:00 | 1
1010008903 | DEF | 2008-04-03 00:00:00 | 1
1010008903 | DEF | 2008-04-22 00:00:00 | 1
1010008903 | DEF | 2008-04-24 00:00:00 | 1
1010008903 | DEF | 2008-05-01 00:00:00 | 1
1010010590 | DEF | 2008-04-12 00:00:00 | 1
1010010590 | DEF | 2008-04-19 00:00:00 | 1
1010010590 | DEF | 2008-04-20 00:00:00 | 1
1010010590 | DEF | 2008-04-26 00:00:00 | 1
1010014839 | KLM | 2008-04-03 00:00:00 | 1
1010014839 | KLM | 2008-04-10 00:00:00 | 1
1010014839 | KLM | 2008-04-17 00:00:00 | 1
1010014839 | KLM | 2008-04-24 00:00:00 | 1
1010019907 | KLM | 2008-04-06 00:00:00 | 1
1010019907 | KLM | 2008-04-10 00:00:00 | 1
1010019907 | KLM | 2008-04-11 00:00:00 | 1
1010019907 | KLM | 2008-04-12 00:00:00 | 1
1010017100 | XYZ | 2008-04-10 00:00:00 | 0
1010017100 | XYZ | 2008-04-24 00:00:00 | 1
1010017100 | XYZ | 2008-04-24 00:00:00 | 1
1010017100 | XYZ | 2008-05-01 00:00:00 | 0
1010017100 | XYZ | 2008-04-04 00:00:00 | 1
1010017100 | XYZ | 2008-04-05 00:00:00 | 0
1010017100 | XYZ | 2008-04-25 00:00:00 | 1
1010017100 | XYZ | 2008-04-26 00:00:00 | 1
1010017100 | XYZ | 2008-04-03 00:00:00 | 1
1010017100 | XYZ | 2008-04-10 00:00:00 | 1
1010017100 | XYZ | 2008-04-17 00:00:00 | 1
1010017100 | XYZ | 2008-05-01 00:00:00 | 1
1010017100 | XYZ | 2008-04-03 00:00:00 | 1
1010017100 | XYZ | 2008-04-03 00:00:00 | 1
Spreadsheet: 168095d1342212370-sorting-and-returning-values-using-formula-column-sort-across-sheet-by-value-return-row-label
Sheet: Sheet1

 | Math | English | Spanish
anne | 85 | 90 | 95
tom | 82 | 87 | 89
sue | 98 | 89 | 93
howard | 70 | 75 | 85
Math
sue
anne
tom
howard
Spreadsheet: 814637d1674522064-transfer-selected-data-from-a-master-sheet-to-another-sheet-in-a-different-cell-address-player-test
Sheet: DALLAS

 |  | DALLAS
 | TEE | LAST NAME | FIRST NAME | ORDER
 |  |  | [NAME]
 |  | Canter | Cole
 |  | Faust | Hugh
 |  | Fraiser | [NAME]
 |  | Grainger | Gil
 |  | Heuber | Hal
 |  | Jaimeson | [NAME]
 |  | Sellers | [NAME]
 |  | Wilde | [NAME]
 |  | Zeller | [NAME]