tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: monique_sanchez__28300__pos
Sheet: Sheet4

CurveGrp-> | IF-ELPO/PERMIAN | IF-ELPO/SJ | IF-HEHUB | IF-NWPL_ROCKY_M | IF-WAHA-TX | NG | NGI-MALIN | NGI-SOCAL | GDP-CAL BORDER | GDP-ELPO/PERM2 | GDP-ELPO/SANJUA | GDP-HEHUB | GDP-MALIN-CTYGA
Curve->
Risk-> | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | PRC | [NAME] | [NAME] | IM | IM | IM | IM | IM
PubCode->
DealType->
2001-05-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2001-05-22 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.5 | 0 | 0 | 0 | -0.5
2001-05-23 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.5 | 0 | 0 | 0 | -0.5
2001-05-24 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.5 | 0 | 0 | 0 | -0.5
2001-05-25 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.5 | 0 | 0 | 0 | -0.5
2001-05-26 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.5 | 0 | 0 | 0 | -0.5
2001-05-27 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.5 | 0 | 0 | 0 | -0.5
2001-05-28 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.5 | 0 | 0 | 0 | -0.5
2001-05-29 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.5 | 0 | 0 | 0 | -0.5
2001-05-30 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.5 | 0 | 0 | 0 | -0.5
2001-05-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.5 | 0 | 0 | 0 | -0.5
Jun, 2001 | 0 | -85.8 | 0 | -74.9 | 0 | -149.8 | 0 | 30 | 0 | 0 | 15 | 0 | 0
Jul, 2001 | 0 | -71.6 | 0 | -77.1 | 0 | 0 | 0 | 13 | 0 | 0 | 0 | 0 | 0
Aug, 2001 | 0 | -71.4 | 0 | -76.8 | 0 | 0 | 0 | -2.5 | 0 | 0 | 0 | 0 | 0
Sep, 2001 | 0 | -69.2 | 0 | -74.1 | 0 | 0 | 0 | 12.5 | 0 | 0 | 0 | 0 | 0
Oct, 2001 | 0 | -15.3 | 0 | -61.1 | 0 | 0 | 0 | 0.7 | 0 | 0 | 0 | 0 | 0
Nov, 2001 | 0 | -29.4 | 0 | 0 | 0 | 0 | -14.7 | 0 | 0 | 0 | 0 | 0 | 0
Dec, 2001 | 0 | -30.3 | 0 | 0 | 0 | 0 | -15.2 | 0 | 0 | 0 | 0 | 0 | 0
Jan, 2002 | 0 | -30.2 | 0 | 0 | 0 | 0 | -15.1 | 0 | 0 | 0 | 0 | 0 | 0
Feb, 2002 | 0 | -27.2 | 0 | 0 | 0 | 0 | -13.6 | 0 | 0 | 0 | 0 | 0 | 0
Mar, 2002 | 0 | -30 | 0 | 0 | 0 | 0 | -15 | 0 | 0 | 0 | 0 | 0 | 0
Apr, 2002 | 0 | 0 | 0 | -28.9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
May, 2002 | 0 | 0 | 0 | -29.8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Jun, 2002 | 0 | 0 | 0 | -28.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Jul, 2002 | 0 | 0 | 0 | -29.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Aug, 2002 | 0 | 0 | 0 | -29.4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sep, 2002 | 0 | 0 | 0 | -28.3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Oct, 2002 | 0 | 0 | 0 | -29.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 89913d1289658477-auto-populate-test-1-
Sheet: Sheet1

 |  | Company | Date | Qty | Pepsi | Coke | Sprite | DR Pepper | [NAME] | MR Pib | Aquafina | Gatorade
1 | 1 | Company A | 2010-11-05 00:00:00 | 5 | 0 | x | 0 | 0 | 0 | x | 0 | x
2 | 2 | Company B | 2010-11-05 00:00:00 | 4 | 0 | 0 | 0 | x | x | 0 | 0 | 0
3 | 4 | Company D | 2010-11-07 00:00:00 | 2 | 0 | 0 | 0 | 0 | 0 | x | 0 | 0
4 | 5 | Company E | 2010-11-08 00:00:00 | 1 | 0 | x | 0 | 0 | 0 | 0 | 0 | 0
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
Spreadsheet: 270654d1381574797-required-an-excel-formula-to-meet-the-multiple-conditiond-book1
Sheet: Sheet1

 | X | Y | Z | To be considered at the time of working | Desired Result
 | HR |  |  | If "HR" exist in one column and other two column are empty,then,put 1 | 1
 | HR | HR |  | If "HR" exist in two column and one column is empty,then,put 1 | 1
 | HR | HR | HR | If "HR" exist in all three column,then,put 1 | 1
 | HR | PB | MAH | If "HR" exist in any one of the 3 columns,then,put 2 | 2
 | PB | HR | HR | If "HR" exist twice in any two of the 3 columns,then,put 2 | 2
 | CH | HR |  | If "HR" exist once in any of the three column ,then,put 2 | 2
 | PB |  |  | If "HR" not exist in any of the 3 columns,then put 3 | 3
 | PB | KAR |  | If "HR" not exist in any of the 3 columns,then put 3 | 3
 | MAH | KAR | DEL | If "HR" not exist in any of the 3 columns,then put 3 | 3
Spreadsheet: 104254d1301916052-need-with-nested-if-statement-test_dip79
Sheet: Sheet4

 | Price | code |  |  |  |  |  |  | code
 | 34 | #12 |  | SUM IF | #12 | 4967 |  |  | #12
 | 56 | #20 |  |  | #16 | 5252 |  |  | #16
 | 77 | #12 |  |  | #20 | 6865 |  |  | #20
 | 898 | #16 |  |  | #8 | 7702 |  |  | #8
 | 79 | #12 |  |  | Total | 24786
 | 24 | #8
 | 23 | #20
 | 34 | #12
 | 4354 | #16
 | 4656 | #12
 | 7678 | #8
 | 6786 | #20
 | 87 | #12
Total | 24786
Spreadsheet: 839081d1691648760-sumif-formula-help-financial-report-2023-season-financial-report
Sheet: Report

 | Debit | Credit
INT | 0.52 | 65531.88
PLAYHQ | 2715.85 | 294456.85
OTH- | 0 | 25848.19
SPO | 1500 | 29171.42
KID | 805 | 44204.81
REIMB | 0 | 294926.06
UNI | 0 | 43207.94
SQ | 5486.360000000001 | 186874.71
WAFC | 0 | 25384.96
WDL | 0 | 7435.71
OTH+ | 657 | 51395.95
GRNT | 1608.25 | 9829.71
TRO | 0 | 8010.31
Spreadsheet: 683733d1592920272-index-and-match-with-averageif-averageexample2
Sheet: Sheet2

Name | Criteria1 | Criteria2 | Criteria3 | Criteria4 | Addition | Average
Option1 | Not Applicable | Not Applicable | Not Applicable | Not Applicable
Option2 | Moderate | Not Applicable | Moderate | Moderate
Option3 | Good | Good | Good | Good
Option4 | Moderate | Moderate | Moderate | Moderate
Spreadsheet: 127616d1320427485-excel-2007-maintain-formula-while-sorting-cells-dummy-beforeandafter-book1
Sheet: AFTER Cost of Supplies

Iteam # | Beads | Price | Quanity | Notes
BEad0007 | Black 6mm | 3 | 1 | Store A
[NAME] | Blue 6mm | 4 | 1 | Store A
BEad0006 | Brown 6mm | 9 | 2 | Store B
BEad0003 | Green 6mm | 6 | 1 | Store B
BEad0004 | Purple 6mm | 1 | 2 | Store C
BEad0001 | Red 6mm | 2 | 1 | Store A
BEad0005 | Yellow 6mm | 7 | 5 | Store B
 | I used Home - Editing - Sort & Filter - Sort A-Z on this sheet to sort the beads alphabetically
Spreadsheet: 194385d1353147682-how-do-i-get-excel-to-ignore-cells-that-have-no-data-entry-yet-when-calculating-mode-test-14
Sheet: Sheet1

Student Name | WAF1 | WAF2 | WAF3 | WAF4 | WAF5 | WAF6 | WAF7 | WAF8 | MODE | W Actual Mark | [NAME] | RAF2 | RAF3 | [NAME] | RAF5 | RAF6 | RAF7 | MODE | R Actual Mark | S&LAF1 | S&LAF2 | S&LAF3 | S&LAF4 | MODE | S&L Act.[NAME]
Student | 4a | 6a | 4b | 6a | 3a | 7a | 6a | 2a |  |  | 3a | 4b | 4a | 7a | 6b | 6c | 3a
Student | 4a | 3a | 4b | 3a | 3a | 3a |  | 2a |  |  | 3a | 4a | 2a | 4a | 5a | 3a | 4a |  |  | 3a | 2a | 2a | 4c
Student | 4a | 2a | 4b | 2a | 3a | 1b | 2a | 2a |  |  | 5a | 7b | 4a | 6c |  | 4a | 5b
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Spreadsheet: 57915d1258129879-vlookup-with-multiple-criteria-and-ranking-apples-test-2-
Sheet: Data

Field1 | Field2 | Field3 |  | lookup >> | Apple
Apple | 15 | 200
[NAME] | 20 | 125 |  |  | 200 , 15
[NAME] | 25 | 200 |  |  | 210 , 15
Apple | 15 | 210
[NAME] | 15 | 250
Apple | 15 | 100
Spreadsheet: 861660d1709547353-issue-with-drop-down-box-dropdown-aligw
Sheet: Sheet1

 |  | Invoice | Taken |  | Select the Invoice No
 |  | 111 | Taken |  | 112
 |  | 112 |  |  |  |  |  |  | 113
 |  | 113 |  |  |  |  |  |  | 114
 |  | 114 |  |  | a) I hope to select only those are not "taken" |  |  |  | 115
 |  | 115 |  |  |  |  |  |  | 116
 |  | 116 |  |  |  |  |  |  | 117
 |  | 117
 |  | **I would like to Strikthought the Invoice no if  D column is "taken"
Spreadsheet: 865985d1712921810-conditional-sum-through-many-sheets-example
Sheet: Summary

Total Commision |  |  |  |  |  | SHEETNAME
Salesman 1 |  |  |  |  |  | SALE 1
Salesman 2 |  |  |  |  |  | SALE 2
Salesman 3 |  |  |  |  |  | SALE 3
Salesman 4 |  |  |  |  |  | SALE 4
Salesman 5
Total Product Sales
Product 1
Product 2
Spreadsheet: 873419d1719924401-weighting-different-filters-construction-test
Sheet: Analytics

 |  |  |  | Category Weightings
Shop | Weighting |  | Date |  | Vegetable | Carbs | Drink | Dairy | Meat | Condiment | Fish | Other
 | 0.25
M&S | 0.25 |  | 2024-03-01 00:00:00
Tesco | 0.5 |  | 2024-12-01 00:00:00
Spreadsheet: 856613d1705807673-travel-total-calculation-calculator
Sheet: Calculator

Total trip days: | 8
Trip date: | Jan 20 - Jan 27
Trip location: | Virginia, Washington DC (also the cities of Alexandria, Falls Church and Fairfax, and the counties of Arlington and Fairfax, in Virginia; and the counties of Montgomery and [NAME] in Maryland)
Per diem rates
 | Lodging | M&IE
January 20* | $193 | $79 | Breakfast $18 / Lunch $20 / Dinner $36 / Incidentals $5
January 21 - 26 | $1158 | $474 | Breakfast $108 / Lunch $120 / Dinner $216 / Incidentals $30
January 27* | $193 | $79 | Breakfast $18 / Lunch $20 / Dinner $36 / Incidentals $5
Trip totals: | $2176
Lodging total: | $1544
Meals total: | $592
Incidentals total: | $40
*The amount received on the first and last day of travel equals 75% of total M&IE
Spreadsheet: 842440d1694519949-combine-all-columns-into-1-workbook
Sheet: Sheet2

Value
5. [NAME]
4. Birchgrove Buddy
4. Queen Babs
6. [NAME]
6. Closed Route
2. [NAME]
5. [NAME]
6. [NAME]
5. Slippy Ella
4. Avonside Jap
2. [NAME]
2. [NAME]
4. [NAME]
1. [NAME]
4. Hitthelids Keely
1. [NAME]
6. Runaway Jaycee
1. [NAME]
6. [NAME]
5. [NAME]
3. Elvis Racer
3. [NAME]
1. [NAME]
2. Help Me Out
2. [NAME]
1. Wheres Speedy
1. Insane Simone
4. Doonanes Cocoon
3. [NAME]
3. Paramaribo
1. [NAME]
2. Punk Rock Sheena
2. Punkrocksiouxsie
6. Cinders
2. Radical News
1. Springview Hero
6. [NAME]
1. [NAME]
4. Tommys Arcade
5. Swift Eden
3. [NAME]
3. Hyde Park Conan
2. Coologue Pest
1. [NAME]
5. Paisleys China
3. Aero [NAME]
5. [NAME]
1. Highview Dusk
4. Highview Peek
4. Congress Champ
2. Bramble Charge
1. [NAME]
4. [NAME]
1. [NAME]
5. [NAME] On Fire
2. [NAME]
5. Mind The Deck
4. Gaffers Way
5. [NAME]
5. [NAME]
6. Handy Forward
5. [NAME]
4. [NAME]
1. Ballyblack Bess
2. [NAME]
5. Monleek Valencia
4. Up Rising
2. Evening Route
2. Lakeside Lady
6. [NAME]
4. Final Blast
3. Creevy Tiger
6. Bertha Peevly
4. [NAME]
3. Charlies Choice
3. [NAME]
3. Bally Diva
4. Leave A Legacy
3. Fairest Enda
6. Roicead
6. Mouser
5. [NAME]
4. [NAME]
6. [NAME]
5. [NAME]
2. Roman Razzle
5. [NAME]
5. Bluehouse Troy
3. Jamies Boy
3. [NAME]
4. Corbrack Duchess
5. [NAME]
2. Shanbally [NAME]
6. [NAME]
5. Coolemore North
3. Almost Midnight
2. Wellfield Blue
1. Burgess Bono
6. Fionns Pet
3. [NAME]
2. [NAME]
4. Callumslittlegem
6. In The Ghetto
2. [NAME]
3. Simply Gorgeous
6. Savana Paddy
2. Unknown Wings
2. [NAME]
2. [NAME]
4. Ciarans Diva
3. Deacon Kissy
3. Santro Mint
4. [NAME]
4. Kanturk Joke
2. Levante Princess
6. Alone
4. [NAME]
6. Raha Princess
1. Dainty Diva
6. Late Bolger
5. Romeo Expo
3. Orange Sydney
4. Young Henry
4. Hawk
6. [NAME]
2. [NAME]
Spreadsheet: 35996d1233747903-multiple-vlookup-excelexample
Sheet: Sheet1

 | BDOT-ALMOND | BDOT-DEWBERRY | BDOT-MELON | BDOT-NOUGAT | BF-BLUEBERRY | BF-NEOPOLITAN | BF-RASPBERRY | BST-AUTUMN
DA-102/1
DA-103/2
DA-103/3 |  |  | X | x
DA-105/1/2 | X
[NAME]
[NAME]
[NAME] |  | X |  |  | x
DA-111/2
DA-111/3
DA-111/4
[NAME] |  |  | X
DC-103/11
DC-103/13
DC-103/14
DC-103/15
DC-103/16
DC-103/17
DC-103/7
DC-105/1 |  |  |  |  |  |  | x
DC-105/2
DC-105/3
DC-105/4
[NAME]
[NAME] |  |  |  |  |  | x
DC-107/2
DC-107/3
DC-107/4
DC-108/2
[NAME]
DC-110/2 |  |  |  |  |  |  |  | x
DC-110/3
[NAME]
DC-111/1 | X
DC-111/2
DC-111/3
 | DA-105/1/2 | [NAME]
 | DC-111/1
Spreadsheet: 855688d1705190617-updating-a-calendar-from-dates-test-calendar-v2-taflorida-
Sheet: March

 |  |  | [NAME]
 |  |  | SUNDAY |  | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | SATURDAY
3
1
2
Spreadsheet: 63758d1264624845-solved-vlookup-or-index-function-pe-template
Sheet: Prac List

Practice Name
[NAME] |  |  |  | Yes | 1
[NAME] |  |  |  | No | 2
[NAME]
[NAME]
COLLEGE STATION
[NAME] I
Dallas Cardi II
Dallas DPS
Dallas Methodist
Dallas MFM
Dallas North
DALLAS SOUTH
DALLAS SOUTH
EL PASO
El Paso Cardi
FORT WORTH
FORT WORTH MFM
HARLINGEN
HOUSTON MFM
HOUSTON NW
HOUSTON ST JOE
HOUSTON SW
HOUSTON WOMENS
Lafayette
[NAME]
San Antonio
San Antonio Cardi
San Antonio DPS
San Antonio MFM
Spreadsheet: 776042d1649452946-spill-filter-formula-upwards-book1
Sheet: Sheet2

 |  |  |  | F1601 | 4100C BOSS
 |  |  |  | F1602 | 4100C BOSS
 |  |  |  | F1603 | 4100C BOSS
 |  |  |  | F1604 | 4100C BOSS
 |  |  |  | F1605 | 4100C BOSS
 |  |  |  | F1606 | 4100C BOSS
 |  |  |  | F1607 | 4100C BOSS
 |  |  |  | R0248 | 6020B
 |  |  |  | F1302 | EX2500
 |  |  |  | F1401 | EX8000
 |  |  |  | F1402 | EX8000
 |  |  |  | F1403 | EX8000
Spreadsheet: 744319d1629148553-subtract-2-cells-if-amount-in-cell-b-is-greater-than-cell-c-i-need-the-sum-to-go-alt-cell-sample-worksheet
Sheet: Aug 2021

Subscriptions | [NAME] | [NAME] | Amount owed by [NAME] | Amount owed by [NAME]
Gas |  | 35
Gas |  | 35
Net Flix |  | 12.99
Cox |  | 175.59
HBO Max | 14.99
Disney Plus | 8.89
MS Office | 11.06
You Tube | 9.99
Spotify | 12.99
Billie | 10
Club Carwash | 21.75
Discovery plus | 7.78
Chewy | 56.71
Sprint | 135.83
Totals
One Half
Spreadsheet: 785819d1656706951-if-statements-for-multiple-dates-and-date-ranges-that-correspond-to-different-formulas-excel-example-etaf
Sheet: Detail by Workstream

 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2023-02-01 00:00:00 | Seniority | [NAME] | Monthly Cost | Start Date | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2022 Fcst | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2023 Fcst |  | Notes:
Position | Phase 1 | Phase 2 | Phase 3 | Phase 4 | Phase 5
Employee 1 |  |  | 0 |  |  | Director |  |  | 2022-08-01 00:00:00
Employee 2 |  |  |  |  |  | Director |  |  | 2022-03-01 00:00:00
Spreadsheet: 834544d1687890737-cf-rule-does-not-fire-when-expected-same-rule-works-ok-in-google-sheets-cf-rule-for-calendar-doesnt-fire
Sheet: May 2023

2023-05-01 00:00:00
Mon |  | Tue |  | Wed |  | Thu |  | Fri |  | Sat |  | Sun
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Column: | A | B | C | D
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] for CF rule:
 |  |  |  |  |  |  |  |  |  | 1900-01-27 00:00:00
Spreadsheet: 142025d1329583504-excel-2010-data-pulling-resident-roster-feb-7-2012
Sheet: Roster Card

Resident Name | [NAME]
Admission Date | 2010-04-14 00:00:00
Diet | Regular
Texture | Minced
[NAME] | Regular
Portion [NAME] | Regular
Nutrition Risk | High
Home Area | Mayfair
Room # | 150A
Table # | 7
Height(CM) | 141cm
GWR(KG) | 45-55kg
Method of Choice | Visual/Verbal
Interventions | None
Supplements | None
Allergies | NKA
Intolerances | None
Assisted Devices | Plastic [NAME], Lip Plate
Special Notes | No Skins, Seeds
Breakfast Specials | None
Breakfast Fluids | [NAME], [NAME], 125ml Juice, Coffee or Tea
Lunch Specials | None
[NAME] | [NAME],Coffee or Tea, Apple Juice
Dinner Specials | None
Dinner Fluids | 250mls Water,250mls Milk, 125mls Juice, Apple Juice
Dislikes | None
Spreadsheet: 115013d1310654235-reformatting-a-table-help-lookup-two-values-together
Sheet: Sheet1

Key | Name | Date | [NAME] |  | Date | Name 2 | Name 3 | Name 4 | Name 5 | Name 6 | Name 7 | Name 8
Name 240740 | Name 2 | 2011-07-16 00:00:00 | Info forName 2, 07/16/2011 |  | 2011-07-16 00:00:00 | Info forName 2, 07/16/2011 | Info forName 3, 07/16/2011 | Info forName 4, 07/16/2011 | Info forName 5, 07/16/2011 | Info forName 6, 07/16/2011 | Info forName 7, 07/16/2011 | Info forName 8, 07/16/2011
Name 340740 | Name 3 | 2011-07-16 00:00:00 | Info forName 3, 07/16/2011 |  | 2011-07-17 00:00:00 | Info forName 2, 07/17/2011 | Info forName 3, 07/17/2011 | Info forName 4, 07/17/2011 | Info forName 5, 07/17/2011 | Info forName 6, 07/17/2011 | Info forName 7, 07/17/2011 | Info forName 8, 07/17/2011
Name 440740 | Name 4 | 2011-07-16 00:00:00 | Info forName 4, 07/16/2011 |  | 2011-07-18 00:00:00 | Info forName 2, 07/18/2011 | Info forName 3, 07/18/2011 | Info forName 4, 07/18/2011 | Info forName 5, 07/18/2011 | Info forName 6, 07/18/2011 | Info forName 7, 07/18/2011 | Info forName 8, 07/18/2011
Name 540740 | Name 5 | 2011-07-16 00:00:00 | Info forName 5, 07/16/2011
Name 640740 | Name 6 | 2011-07-16 00:00:00 | Info forName 6, 07/16/2011
Name 740740 | Name 7 | 2011-07-16 00:00:00 | Info forName 7, 07/16/2011
Name 840740 | Name 8 | 2011-07-16 00:00:00 | Info forName 8, 07/16/2011
Name 240741 | Name 2 | 2011-07-17 00:00:00 | Info forName 2, 07/17/2011
Name 340741 | Name 3 | 2011-07-17 00:00:00 | Info forName 3, 07/17/2011
Name 440741 | Name 4 | 2011-07-17 00:00:00 | Info forName 4, 07/17/2011
Name 540741 | Name 5 | 2011-07-17 00:00:00 | Info forName 5, 07/17/2011
Name 640741 | Name 6 | 2011-07-17 00:00:00 | Info forName 6, 07/17/2011
Name 740741 | Name 7 | 2011-07-17 00:00:00 | Info forName 7, 07/17/2011
Name 840741 | Name 8 | 2011-07-17 00:00:00 | Info forName 8, 07/17/2011
Name 240742 | Name 2 | 2011-07-18 00:00:00 | Info forName 2, 07/18/2011
Name 340742 | Name 3 | 2011-07-18 00:00:00 | Info forName 3, 07/18/2011
Name 440742 | Name 4 | 2011-07-18 00:00:00 | Info forName 4, 07/18/2011
Name 540742 | Name 5 | 2011-07-18 00:00:00 | Info forName 5, 07/18/2011
Name 640742 | Name 6 | 2011-07-18 00:00:00 | Info forName 6, 07/18/2011
Name 740742 | Name 7 | 2011-07-18 00:00:00 | Info forName 7, 07/18/2011
Name 840742 | Name 8 | 2011-07-18 00:00:00 | Info forName 8, 07/18/2011
Name 240743 | Name 2 | 2011-07-19 00:00:00 | Info forName 2, 07/19/2011
Name 340743 | Name 3 | 2011-07-19 00:00:00 | Info forName 3, 07/19/2011
Name 440743 | Name 4 | 2011-07-19 00:00:00 | Info forName 4, 07/19/2011
Name 540743 | Name 5 | 2011-07-19 00:00:00 | Info forName 5, 07/19/2011
Name 640743 | Name 6 | 2011-07-19 00:00:00 | Info forName 6, 07/19/2011
Name 740743 | Name 7 | 2011-07-19 00:00:00 | Info forName 7, 07/19/2011
Name 840743 | Name 8 | 2011-07-19 00:00:00 | Info forName 8, 07/19/2011
Spreadsheet: 844273d1695999973-divide-by-number-of-years-in-dropdown-list-otherwise-0-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Years | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  | 10000000
 |  |  |  |  |  |  |  | Divide by
 |  |  |  |  |  |  |  | 5 | Year
 |  |  |  |  |  |  |  | 10 | Year
 |  |  |  |  |  |  |  | 15 | Year
 |  |  |  |  |  |  |  | 20 | Years
 |  |  |  |  |  |  | Dropdown list | 25 | Years
 |  |  |  |  |  |  |  | 30 | Years
 |  |  |  |  |  |  | I want to have a formula in cell N7 where the number will be divided by the years selected in the dropdown list and otherwise 0 for other years
Spreadsheet: 753164d1635272287-formula-to-get-unique-list-of-values-from-multiple-columns-in-a-table-fx-to-get-unique-list-from-multi-cols4
Sheet: Sheet2

 | Planned |  |  | Expected
 | Milestone Master List | Due Date |  | Milestones | Due Date | Dependent MSs  comma-delimited | 1 | 2 | 3 | 1 | 2 | 3
 | MS_1 | 2022-10-24 00:00:00 |  | MS_1 |  | MS_2, MS_3, MS_4 |  | MS_3 | MS_4 | 2022-05-31 00:00:00 |  | 2022-12-24 00:00:00
 | MS_2 | 2022-10-01 00:00:00 |  | MS_5 | 2022-10-24 00:00:00 | MS_6 | MS_6 |  |  | 2023-05-31 00:00:00
 | MS_3 | 2022-10-01 00:00:00 |  | MS_7 | 2022-05-03 00:00:00 | MS_8, MS_9, MS_10 | MS_8 | MS_9 | MS_10 |  | 2022-04-17 00:00:00
 | MS_4 | 2022-10-01 00:00:00 |  | MS_11 | 2022-07-01 00:00:00 | MS_12 | MS_12
 | MS_5 | 2022-10-24 00:00:00 |  | MS_13 | 2022-04-19 00:00:00 | MS_14 | MS_14 |  |  | 2022-06-17 00:00:00
 | MS_6 | 2022-09-01 00:00:00
 | MS_7 | 2022-05-03 00:00:00
 | MS_8 | 2022-04-30 00:00:00 |  |  |  |  |  |  |  |  |  |  | Desired List
 | MS_9 | 2022-04-30 00:00:00 |  |  |  |  |  |  |  |  |  |  | MS_4 | 2022-12-24 00:00:00
 | MS_10 | 2022-04-30 00:00:00 |  |  |  |  | MS_3 |  |  | 2022-12-24 00:00:00 |  |  | MS_6 | 2023-05-31 00:00:00
 | MS_11 | 2022-07-01 00:00:00 |  |  |  |  | MS_4 |  |  | 2023-05-31 00:00:00 |  |  | MS_14 | 2022-06-17 00:00:00
 | MS_12 | 2022-06-01 00:00:00 |  |  |  |  | MS_6 |  |  | 2022-04-17 00:00:00
 | MS_13 | 2022-04-19 00:00:00 |  |  |  |  | MS_8 |  |  | 2022-06-17 00:00:00 |  |  |  | 2022-12-24 00:00:00
 | MS_14 | 2022-01-01 00:00:00 |  |  |  |  | MS_9 |  |  |  |  |  | MS_6 | 2023-05-31 00:00:00
 |  |  |  |  |  |  | MS_10 |  |  |  |  |  | MS_14 | 2022-06-17 00:00:00
 |  |  |  |  |  |  | MS_12
 |  |  |  |  |  |  | MS_14 |  |  |  |  |  |  | 2022-12-24 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | MS_6 | 2023-05-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | MS_14 | 2022-06-17 00:00:00
 |  |  |  |  |  |  |  | MS_3 | MS_4
 |  |  |  |  |  |  | MS_6
 |  |  |  |  |  |  | MS_8 | MS_9 | MS_10
 |  |  |  |  |  |  | MS_12
 |  |  |  |  |  |  | MS_14
Spreadsheet: eric_saibi__9851__101001
Sheet: San Onofre 02

Owner Name |  | Southern California Edison Company
Station Name |  | San Onofre Nuclear Power Station
Unit Name |  | SONGS 02
NERC Region |  | WSCC
State |  | CA
Fuel Type |  | Nuclear
Capacity |  | 1,127 MW
Start Date |  | 2001-10-13 00:00:00
End Date |  | 2001-11-01 00:00:00
Comments |  | Minor Inspection on MSR, and changing seals on valves
SIC |  | 4911
Plant ID |  | 1014484
Unit ID |  | 1006753
Outage ID |  | 18619
Spreadsheet: 116675d1311975742-selective-columns-midshires-golf-society-1
Sheet: mastergrid

Green = 2011 Yellow = 2010 Blue = 2009 | [NAME]. K | Weed. S | Watson. K | [NAME]. D | Thompson. A | Smith. S | [NAME]. R | Scott. B | Pym. K | Pennington. C | Pearce. S | [NAME]. R | [NAME]. A | Mitchell. A | [NAME]. A | Marvesley. J | [NAME]. T | Loom. S | [NAME]. D | Haines. M | [NAME]. J | Dooley. J | Clarke. D | Bromley. R | Basil. G | Ankers. N | Adams. L | Adams. B
Adams. B
Adams. L
Ankers. N
Basil. G
Bromley. R
Clarke. D
Dooley. J
[NAME]. J
Haines. M
[NAME]. D
Loom. S
[NAME]. T
Marvesley. J
[NAME]. A
Mitchell. A
[NAME]. A
[NAME]. R
Pearce. S
Pennington. C
Pym. K
Scott. B
[NAME]. R
Smith. S
Thompson. A
[NAME]. D
Watson. K
Weed. S
[NAME]. K
Spreadsheet: 7a036cfc-3376-48e4-b363-6adba36124c5
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
THCM | Test | THCM | 11-nor-Delta-9-Tetrahydrocannabinol-9-Carboxylic Acid (Carboxy-THC), Meconium | Carboxy-THC Confirmation, M | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | Stool Container: Stool |  |  | 0.5 | g | Chain-of-custody is recommended for this test. Chain-of-Custody Meconium Kit (Supply T653) is available upon request.   Container/Tube: Stool container (Supply T288) [NAME]: 5 g (approximately 1 tablespoon) Collection Instructions: Collect entire random meconium specimen. Additional Information:  1. For chain-of-custody information, see Chain-of-Custody Meconium Kit (Supply T653). 2. Specimen that arrives with a broken seal does not meet the chain-of-custody requirements. 3. The laboratory recommends sending chain-of-custody specimens by overnight shipment. | 1 g (approximately 0.5 teaspoon) | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Grossly bloody reject; Pink OK | Negative Positives are reported with a quantitative LC-MS/MS result. [NAME] concentrations Tetrahydrocannabinol carboxylic acid ([NAME]) by LC-MS/MS: >10 ng/g | Monday through Friday, Sunday; Varies | 2 days |  | 1 | 80299 |  |  |  |  | Rochester
THCM | [NAME] | [NAME] | Meconium |  |  |  | Frozen | 14 days
THCM | Result | 31863 | THC | THC | Numeric |  |  |  |  | ng/g |  |  |  |  |  |  |  |  |  | In Process
THCM | Result | 31876 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69050-3
THCM | Result | 31877 | Chain of Custody | Chain of Custody | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process