tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1d57b87d-2c71-4167-9789-29faaa6030b9
Sheet: Blank

 |  | CENTRAL NEW MEXICO COMMUNITY COLLEGE TIMESHEET/LEAVE REGISTER
 |  |  |  |  |  |  | LOC
Pay No | Pay Date |  |  |  |  |  |  | POSITION # |  |  | FTE |  | Employee Class
Earning Desc/Code/Hours |  | Sat | Sun | Mon | [NAME] | Wed | Thur | Fri | Sat | Sun | Mon | [NAME] | Wed | Thur | Fri | Total
Regular
 |  |  |  |  |  |  |  |  |  |  |  |  | Leave Balances:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Hours
INSTRUCTIONS/NOTES |  |  |  |  | PAY CODES | REG-REGULAR     SIC-SICK    SUPP-SUPPLEMENTAL
 |  |  |  |  |  | PER-PERSONAL   HOL-HOLIDAY  LNP-LEAVE NO PAY |  |  |  |  |  |  |  |  | PAY CODES | HOURS BY CODE
Employment Contract |  |  |  |  |  | ANN-ANNUAL  OVT-OVERTIME   OTR-OVERTIME REGULAR |  |  |  |  |  |  |  |  | REG
Employee did not submit |  |  |  |  |  | LGL-LEGAL   SUB-SUBSTITUTE   BRV-BEREAVEMENT |  |  |  |  |  |  |  |  | ANN
correct hours on timesheet; |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SIC
was missing 10 hours. |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PER
 |  |  |  |  | PAY CODES | COST ACCOUNT |  |  | HOURS | RATE | EARNED AMOUNT |  |  |  | HOL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OVT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OTR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LNP
I CERTIFY THE CORRECTNESS OF THE HOURS WORKED AND LEAVE HOURS TAKEN |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LGL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRV
EMPLOYEE'S SIGNATURE |  |  |  |  |  | FINAL PAY? |  |  |  |  |  | SEPARATION DATE
 |  |  |  |  |  | (CHECK BOX IF THIS IS THE EMPLOYEE'S FINAL PAY IN YOUR DEPATMENT)
AUTHORIZED [NAME]'S SIGNATURE
Spreadsheet: 148596d1333478410-how-to-visually-separate-rows-with-same-data-example_reply
Sheet: Sheet1

No | Description | Value 1 | Value2
16054-2 | Lot 2 Guitar.. | 12.95 | 0.177
16054-2 | Lot 2 Guitar.. | 12.95 | 0.177
17169-EDM | New Deluxe [NAME]… | 12.95 | 0.177
17169-EDM | New Deluxe [NAME]… | 12.95 | 0.177
17169-EDM | New Deluxe [NAME]… | 12.95 | 0.177
18013-EDM | Sporting Binoculars… | 12.95 | 0.177
18013-EDM | Sporting Binoculars… | 12.95 | 0.177
18013-EDM | Sporting Binoculars… | 12.95 | 0.177
23041-TAISO752 | [NAME] | 12.95 | 0.177
23041-TAISO752 | [NAME] | 12.95 | 0.177
23041-TAISO752 | [NAME] | 12.95 | 0.177
23139 | [NAME]… | 12.95 | 0.177
23139 | [NAME]… | 12.95 | 0.177
23139 | [NAME]… | 12.95 | 0.177
16086 | New Cymbal… | 12.95 | 0.177
16086 | New Cymbal… | 12.95 | 0.177
16086 | New Cymbal… | 12.95 | 0.177
18065 | New Dart Board… | 12.95 | 0.177
18065 | New Dart Board… | 12.95 | 0.177
18065 | New Dart Board… | 12.95 | 0.177
18065 | New Dart Board… | 12.95 | 0.177
18065 | New Dart Board… | 12.95 | 0.177
23044-BMC | New Deluxe 40 Piece… | 12.95 | 0.177
23044-BMC | New Deluxe 40 Piece… | 12.95 | 0.177
23044-BMC | New Deluxe 40 Piece… | 12.95 | 0.177
Spreadsheet: 786506d1657220803-if-statement-with-time-as-reference-2022-07-07-oeldere-dlealb-book1-2-
Sheet: Sheet1

DOMAINNAME | Shift | Start | End | Late | Exception | Exception |  | 0:05:00 |  | Vlookup table
Bambi.Yudelmo | 09:00-18:00 | 09:00 | 18:00 | 0:05:00 | 5 |  |  |  |  | 00:00:00 | >5
Rhesty.Buenafe | 09:00-18:00 | 09:00 | 18:00 | 0:53:00 |  |  |  |  |  | 00:05:00 | 5
Aileen.Camatura | 09:00-18:00 | 09:00 | 18:00 | 0:01:00 |  |  |  |  |  | 00:05:01 |  | => space
Spreadsheet: 6835c93a-2de5-43f8-8501-57361b198ad2
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Not Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2013
 |  | Data Extracted on: July 24, 2014 (2:48 am)
Period | Value
Q1-2003 | X
Q2-2003 | X
Q3-2003 | X
Q4-2003 | 237399
Q1-2004 | 223675
Q2-2004 | 233241
Q3-2004 | 232983
Q4-2004 | 246201
Q1-2005 | 236033
Q2-2005 | 244136
Q3-2005 | 244711
Q4-2005 | 255856
Q1-2006 | 245182
Q2-2006 | 254735
Q3-2006 | 255745
Q4-2006 | 271401
Q1-2007 | 257973
Q2-2007 | 265739
Q3-2007 | 267325
Q4-2007 | 281304
Q1-2008 | 270223
Q2-2008 | 277650
Q3-2008 | 277603
Q4-2008 | 282873
Q1-2009 | 261921
Q2-2009 | 266862
Q3-2009 | 265511
Q4-2009 | 280665
Q1-2010 | 267597
Q2-2010 | 274785
Q3-2010 | 276049
Q4-2010 | 291794
Q1-2011 | 277416
Q2-2011 | 289110
Q3-2011 | 288779
Q4-2011 | 305253
Q1-2012 | 291952
Q2-2012 | 300081
Q3-2012 | 298950
Q4-2012 | 322308
Q1-2013 | 306040
Q2-2013 | 313234
Q3-2013 | 314646
Q4-2013 | 340055
Spreadsheet: 848358d1699077842-nth-largest-value-with-criteria-ignore-duplicates-nth-largest
Sheet: Sheet1

1 | 25 |  |  | nth | largest + ignore duplicate + criteria
1 | 40 |  |  | 1 | 35
1 | 40 |  |  | 2 | 30
2 | 25 |  |  | 3 | 25
2 | 15 |  |  | 4 | 15
2 | 30
2 | 35
2 | 35
2 | 30
2 | 25
2 | 15
2 | 30
Spreadsheet: 192954d1352651748-picking-up-a-number-which-meets-the-criteria-from-another-column-workbook120
Sheet: Sheet1

2 | 6.666666666666667 |  |  |  | 2
4 | 3.611111111111111 | 5
8 | 3.333333333333333 |  |  |  | 8
 | 3.888888888888889 | 5
12 | 6.666666666666667 |  |  |  | 12
14 | 4.166666666666667 |  |  |  | 14
24 | 3.888888888888889 | 5
28 | 6.666666666666667 |  |  |  | 28
52 | 3.611111111111111 | 5
54 | 4.444444444444445 | 5
56 | 3.888888888888889 | 5
58 | 4.444444444444445 | 5
70 | 3.333333333333333 |  |  |  | 70
72 | 4.444444444444445 | 5
74 | 6.67 |  |  |  | 74
76 | 3.75 |  |  |  | 76
78 | 3.3 |  |  |  | 78
80 | 3.35 |  |  |  | 80
Spreadsheet: 849039d1699608379-sorting-data-and-labelling-data-and-preserving-the-labelling-for-other-data-sets-example-for-forum-10-nov-
Sheet: Selection of DATA

 | [NAME]: = UNIQUE(DATA!C2:G12) |  |  |  |  |  | Requested outcome
 |  |  |  |  |  |  | Copy & Paste the five columns manually below each other |  |  | Copy and paste column H to column K and then apply ("Remove all duplicates")
 |  | An apparatus | A metrology tool | A lithographic apparatus | A litho cell |  | An apparatus |  |  | An apparatus
 | A reticle stage | A lithographic apparatus | A lithographic system | A method of operating an EUV lithographic apparatus |  |  | A reticle stage |  |  | A reticle stage
 | A method for improving a nuisance rate | A system | A non-transitory computer readable medium storing … |  |  |  | A method for improving a nuisance rate in image inspection data |  |  | A method for improving a nuisance rate
 | A height measurement sensor | A lithographic apparatus | An assessment system | A metrology system | A method for determining a focus plane |  | A height measurement sensor |  |  | A height measurement sensor
 | A method for cleaning | A system | A system |  |  |  | A method for cleaning |  |  | A method for cleaning
 | A membrane | A membrane | A pellicle | A patterning device and pellicle assembly | A lithographic apparatus |  | A membrane |  |  | A membrane
 |  |  |  |  |  |  | A charge regulator |  |  | A charge regulator
 |  |  |  |  |  |  | A charged particle-optical device |  |  | A charged particle-optical device
 |  |  |  |  |  |  | An apparatus |  |  | An apparatus
 | Question: HOW to remove all the duplicates from cells B3:[NAME]? |  |  |  |  |  | A lithographic apparatus |  |  | A lithographic apparatus
 |  |  |  |  |  |  | A system |  |  | A system
 |  |  |  |  |  |  | A lithographic apparatus
 |  |  |  |  |  |  | A system |  |  | A metrology tool
 |  |  |  |  |  |  | A membrane |  |  | A lithographic system
 |  |  |  |  |  |  |  |  |  | A non-transitory computer readable medium storing …
 |  |  |  |  |  |  |  |  |  | An assessment system
 |  |  |  |  |  |  | A metrology tool |  |  | A pellicle
 |  |  |  |  |  |  | A lithographic system |  |  | 0
 |  |  |  |  |  |  | A non-transitory computer readable medium storing … |  |  | A method of operating an EUV lithographic apparatus
 |  |  |  |  |  |  | An assessment system |  |  | A metrology system
 |  |  |  |  |  |  | A system |  |  | A patterning device and pellicle assembly
 |  |  |  |  |  |  | A pellicle |  |  | A litho cell
 |  |  |  |  |  |  |  |  |  | A method for determining a focus plane
 |  |  |  |  |  |  | 0 |  |  | A lithographic apparatus
 |  |  |  |  |  |  | A lithographic apparatus
 |  |  |  |  |  |  | A method of operating an EUV lithographic apparatus
 |  |  |  |  |  |  | A metrology system
 |  |  |  |  |  |  | A patterning device and pellicle assembly
 |  |  |  |  |  |  | A litho cell
 |  |  |  |  |  |  | A method for determining a focus plane
 |  |  |  |  |  |  | A lithographic apparatus
 |  |  |  |  |  |  | 0
Spreadsheet: 825176d1681156827-conditional-formatting-for-deadline-dates-cf-example
Sheet: Sheet1

2023-03-01 00:00:00 | Initial Finish | Current Finish |  |  |  |  | RED | YELLOW | GREEN | BLUE | BLACK | CONDITION
Task 1 | 2024-01-15 00:00:00 | 2024-01-15 00:00:00 |  |  |  | Red: Current > Initial (Outside of Calendar Month)
Task 2 | 2023-04-15 00:00:00 | 2023-03-23 00:00:00 |  |  |  | Yellow: Current > Initial (Within Calendar Month)
Task 3 | 2023-05-01 00:00:00 | 2023-05-15 00:00:00 |  |  |  | Green: Current < Initial (Within Calendar Month)
Task 4 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 |  |  |  | Blue: Current < Initial (Outside of Calendar Month)
Task 5 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 |  |  |  | Black: Complete (Any date before present day)
Spreadsheet: 854628d1704437081-simplifying-complex-formula-test-gk3-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1,2 | 4,9,19,25 | 4,10,14,22 | 4,13,19,23 | 4,17,19,24 | 1,14,23,24 |  |  | 1,2 | 4,9,19,25 | 4,10,14,22 | 4,13,19,23 | 4,17,19,24 | 1,14,23,24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 6 | 25 | 0 | 9 | 35 |  |  | 3 | 6 | 25 | 0 | 9 | 35
y/n | a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z
y | 18 | 2 | 2 | 3 | 0 | 2 | 1 | 2 | 1 | 3 | 1 | 2 | 1 | 3 | 26 | 2 | 0 | 22 | 0 | 22 | 2 | 32 | 2 | 4 | 2 | 2
y | 20 | 2 | 2 | 2 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 2 | 1 | 4 | 24 | 0 | 0 | 2 | 0 | 2 | 1 | 3 | 2 | 5 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 9 | 4 | 0 | 11 | 0
y | 10 | 2 | 2 | 222 | 0 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 24 | 0 | 2 | 2 | 0 | 2 | 1 | 3 | 1 | 5 | 0 | 2
n | 12 | 2 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 0 | 0 | 0 | 0 | 22 | 1 | 4 | 2 | 0
y | 15 | 2 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 2 | 0 | 2 | 1 | 22 | 1 | 4 | 2 | 0
y | 20 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | 0 | 1 | 4 | 20 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 2 | 4 | 2 | 0
y | 15 | 2 | 2 | 22 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 1 | 2 | 21 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 2 | 4 | 2 | 0
n | 18 | 2 | 2 | 22 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 1 | 4 | 2 | 0
n | 8 | 2 | 0 | 22 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 24 | 0 | 0 | 2 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 2
y | 14 | 2 | 2 | 3 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 12 | 0 | 2 | 22 | 0 | 2 | 1 | 22 | 2 | 3 | 0 | 2
y | 14 | 2 | 0 | 22 | 0 | 22 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 4 | 0 | 22
y | 18 | 2 | 0 | 22 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 28 | 2 | 0 | 2 | 0 | 2 | 1 | 32 | 2 | 5 | 2 | 2
y | 20 | 2 | 0 | 22 | 0 | 22 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 25 | 0 | 0 | 22 | 0 | 2 | 1 | 2 | 1 | 4 | 0 | 22
y | 24 | 2 | 2 | 222 | 0 | 22 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 15 | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 22
n | 8 | 2 | 0 | 3 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 22 | 0 | 0 | 2 | 0 | 2 | 1 | 2 | 1 | 4 | 0 | 2
y | 18 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | 0 | 1 | 4 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 0
y | 22 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 0 | 2 | 2 | 4 | 20 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | 0 | 0
y | 24 | 2 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 3 | 2 | 5 | 21 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 0
y | 22 | 2 | 2 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 0 | 2 | 2 | 4 | 16 | 2 | 2 | 22 | 0 | 0 | 0 | 22 | 1 | 3 | 2 | 0
Spreadsheet: 827007d1682429706-match-multiple-values-and-return-sum-of-multiple-columns-joboperations_sample
Sheet: Report

WC_CountIf | 1
Sum of Duration | Column Labels
 | CPA01 | CSCSER |  |  | EMBLEG | [NAME] |  | EMBKC | Grand Total
Row Labels |  | 30 | 40 | 50 | 10 | 5 | 20 | 25
1980792
441400-001
1 |  |  |  |  |  |  | 0.33 | 0.25 | 0.5800000000000001
1983022
441200-001
1 |  |  |  |  |  |  | 0.33 | 0.25 | 0.5800000000000001
1993227
430700-001
1 |  |  |  |  | 4.5 |  | 0.33 |  | 4.83
1993229
430700-001
1 |  |  |  |  | 4.5 |  | 0.33 |  | 4.83
1993230
430700-001
1 |  |  |  |  |  |  | 0.33 |  | 0.33
1993231
430700-001
1 |  |  |  |  |  |  | 0.33 |  | 0.33
1993232
430700-001
1 |  |  |  |  |  |  | 0.33 |  | 0.33
2014088
1202300-001
4 |  | 0.88 | 9.88 | 1.52 |  |  |  |  | 12.28
2014429
1201000-001
1 |  | 0.365 | 5.65 | 0.65 |  |  |  |  | 6.665000000000001
2016148
1401400-001
1 | 1.48 |  |  |  |  | 0.25 |  |  | 1.73
Grand Total | 1.48 | 1.245 | 15.53 | 2.17 | 9 | 0.25 | 2.31 | 0.5 | 32.485
Spreadsheet: 105942d1303216776-index-indirect-match-help-projbudg
Sheet: ProjectSummary

Project Name | Project description | Estimated Year1 Cost (£) | Estimated Year2 Cost (£) | Estimated Year3 Cost (£) | Total Estimated Project Cost (£) | Type | Original Start Date | Original End Date | Current Start Date | Current End Date | Priority | [NAME] | Comment
 | brief description |  |  |  |  |  |  |  |  |  |  | G | Future project
 | brief description |  |  |  |  |  |  |  |  |  |  | G | Future project
 | brief description |  |  |  |  |  |  |  |  |  |  | G | Future project
 | brief description |  |  |  |  |  |  |  |  |  |  | G | Future project
 | brief description |  |  |  |  |  |  |  |  |  |  | G | Future project
 | brief description |  |  |  |  |  |  |  |  |  |  | G | Future project
 | brief description |  |  |  |  |  |  |  |  |  |  | G | Future project
 | brief description |  |  |  |  |  |  |  |  |  |  | G | Future project
 | brief description |  |  |  |  |  |  |  |  |  |  | G | Future project
 | brief description |  |  |  |  |  |  |  |  |  |  | G | Future project
 | brief description |  |  |  |  |  |  |  |  |  |  | G | Future project
Spreadsheet: 854789d1704546548-to-calculate-remain-qty-using-correct-formulas-case11001
Sheet: Sheet1

 | 1
 |  |  |  |  |  |  |  |  | ignore
 |  |  |  | Helper column |  |  |  |  | expected result
 |  |  | Total Remain Supply |  |  |  | [NAME]
 |  |  | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 |  | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00
 | FACTORY | AA |  |  |  |  | 60 | 80 | 130 | 80 | 80
 |  | BB |  |  |  |  | 50 | 50 | 50 | 50 | 50
 |  | CC |  |  |  |  | 80 | 50 | 200 | 50 | 200
 |  |  | [NAME] |  |  |  | Delivery Schedule
 |  |  | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 |  | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00
 | CITY A | AA | 50
 |  | BB | 60
 |  | CC | 70
 | CITY B | AA | 80
 |  | BB | 90
 |  | CC | 100
 | CITY C | AA | 110
 |  | BB | 120
 |  | CC | 130
 | total Delivery | AA
 |  | BB
 |  | CC
 |  |  |  |  |  |  | without helper column in blue cells(ungroup the column) so in green cells I would like to have qty of delivery schedule plan based on
 |  |  |  |  |  |  | 1. qty of production schedule on that date
 |  |  |  |  |  |  | 2. remain qty each city each model after minus delivery of previous day start from 2 Jan
 |  |  |  |  |  |  | 2.1 if qty production below the remain, so prorate will apply for each model each city based on prod qty
 |  |  |  |  |  |  | 2.2 if qty production above the remain supply, qty will follow remain qty
Spreadsheet: 43664d1242295874-automatically-adding-tables-upload
Sheet: Comp Sheet

 |  |  |  |  |  |  |  |  | Event | 4 | Lancaster
 |  |  |  |  |  |  |  |  |  | Time | Name | H/Cap | 7/8ths | Stableford | Back 9
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  |  |  |  |  | Score
6 | 7.2 | 7.2 | 7 | 7
9 | 7.4 | 7.600000000000001 | 7.600000000000001 | 7.800000000000001
11 | 8.4 | 8.6 | 8.799999999999999 | 8.799999999999999
4 | 13 | 13.2 | 13.2 | 12.6
1 | 12.6 | 12.8 | 13 | 13.2
10 | 12.8 | 12.8 | 13 | 13.2
7 | 13 | 13.2 | 13.4 | 13.6
8 | 19.4 | 17 | 17.4 | 16.6
2 | 16 | 16 | 16.4 | 16.8
14 | 17 | 17 | 17.4 | 17.8
13 | 18 | 18.4 | 18.8 | 19.2
5 | 26 | 24.8 | 25.4 | 25.4
12 | 27.4 | 27.4 | 27.4 | 26.2
3 | 29.6 | 30.2 | 30.8 | 31.40000000000001
Spreadsheet: 868728d1715391339-two-way-anova-without-replication-help-excel-help
Sheet: Partial Mortality

class limits | partial injury | Bleached
0 | 14 | 0
1-10 | 10 | 0
11-20 | 0 | 0
21-30 | 2 | 1
31-40 | 1 | 1
Anova: Two-Factor Without Replication
SUMMARY | Count | Sum | Average | [NAME]
0 | 2 | 14 | 7 | 98
2024-01-10 00:00:00 | 2 | 10 | 5 | 50
2024-11-20 00:00:00 | 2 | 0 | 0 | 0
21-30 | 2 | 3 | 1.5 | 0.5
31-40 | 2 | 2 | 1 | 0
Partial Injury | 5 | 27 | 5.4 | 38.8
Bleached | 5 | 2 | 0.4 | 0.3
ANOVA
Source of Variation | SS | df | MS | F | P-value | F crit
Rows | 70.4 | 4 | 17.6 | 0.818605 | 0.57456 | 6.388233
Columns | 62.5 | 1 | 62.5 | 2.906977 | 0.163398 | 7.708647
Error | 86 | 4 | 21.5
Total | 218.9 | 9
Spreadsheet: 582647d1531981162-formulas-work-separately-but-not-combined-nanaia-nested-if-statements-aligw
Sheet: REF

REF
"INT | Direction | Substrate | CSV Edge | CSV Edge Code | V Edge Code | V>H EDGE | Top | Code | Dim | Right | Code2 | Dim3 | Bottom | Code4 | Dim5 | Left | Code6 | Dim7 | N | H ALUM | V ALUM | H ZINC | V ZINC | H-A LVLZ 2 | H-A LVLZ 25 | H-A LVLZ 3 | H-A LVLZ 35 | H-A LVLZ 4 | V-A LVLZ 2 | V-A LVLZ 25 | V-A LVLZ 3 | V-A LVLZ 35 | V-A LVLZ 4 | Prog? | Panel Type | Panel Depth | [NAME] | P4 File | V>H P4 File | BA∠1W-X Axis | BA∠2X-X Axis | BA∠3W-Z Axis | BA∠4X-Z Axis | Face X | Face Z | Taper | TDepth | RDepth | BDepth | LDepth | TR∠ | RB∠ | BL∠ | RL∠ | RB dim | RB inches
"INT_ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF(B2="H",(COUNTIF('EDGES & BEND ALLOWANCE'!$Y$2:$Y$319,E2)>0)
\
_Z |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y | CHECK H |  |  | 1
.P4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AE | CHECK V |  |  | 2
// |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Z | CHECK H_2 |  |  | 3
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | '=IF(CSV!AK3="E1",1.25) |  |  |  |  |  |  | AA | CHECK H_25 |  |  | 4
FaceZ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =IF(CSV!AK3="V1","VAR") |  |  |  |  |  |  | AB | CHECK H_3 |  |  | 5
" |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =IF(CSV!AK3="L1","VAR") |  |  |  |  |  |  | AC | CHECK H_35 |  |  | 6
_4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AD | CHECK H_4 |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AF | CHECK HZ |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AG | CHECK VZ |  |  | 9
Spreadsheet: 118060d1313416160-cell-with-formula-will-not-show-thousand-separators-and-decimals-test-drop-down-currency1
Sheet: Sheet1

 |  | EUR | USD
 | USD | 0.7009 | 1
 | EUR | 1 | 1.3247
 | CAD | 0.7038 | 1.0063
Sales Currency: | [NAME] | 0.0564 | 0.0804
USD
Currency Symbol:
Product | Number | Currency | Ex-change rate | Price | Qty | Sales
Lamp | 111 | USD |  | 22 | 7779
Bulb | 222 | EUR |  | 3 | 20
Shelve | 333 | USD |  | 50 | 10
Spreadsheet: jeffrey_a_shankman__13968__Global Hot List 1026
Sheet: Hotlist - Completed

E N R O N   G L O B A L   M A R K E T S  -  H O T  L I S T |  |  |  |  |  |  |  |  |  |  |  | PRIVATE & CONFIDENTIAL
 |  |  |  |  |  |  |  |  |  |  |  | 4Q01 DEALS COMPLETED
 |  | Crude & Products |  |  |  |  |  | Global Risk Markets
 |  | Deal |  | Value |  | Deal Count |  | Deal |  | Value |  | Deal Count
 |  | SUBTOTAL |  |  |  |  |  | SUBTOTAL
 |  | Coal |  |  |  |  |  | Freight
 |  | Deal |  | Value |  | Deal Count |  | Deal |  | Value |  | Deal Count
 |  | SUBTOTAL |  |  |  |  |  | SUBTOTAL
 |  | Vessel / Shipping |  |  |  |  |  | LNG
 |  | Deal |  | Value |  | Deal Count |  | Deal |  | Value |  | Deal Count
 |  | [NAME]
 |  | SUBTOTAL |  |  |  |  |  | SUBTOTAL
 |  | Emissions |  |  |  |  |  | Finance & Structuring
 |  | Deal |  | Value |  | Deal Count |  | Deal |  | Value |  | Deal Count
 |  | SUBTOTAL |  |  |  |  |  | SUBTOTAL
 |  | Weather
 |  | Deal |  | Value |  | Deal Count
 |  | ABN Amro |  | 1104.057
 |  | SUBTOTAL |  |  |  |  |  | TOTAL DEALS COMPLETED
Spreadsheet: 860489d1708569976-splitting-names-in-a-cell-and-take-corresponding-values-testbook-dj-pq
Sheet: Bylines

Site | Year | Month | Quarter | Byline | Count | Byline Type | External | Internal | Total |  | Site | Year | Month | Quarter
Red | 2020 | Dec | Q4 | [NAME] | 100 | Internal |  |  |  |  | site, year, month, quarter, should auto populate |  |  |  |  |  | The formula in column Q slows down when there's lots of data. It also correctly splits the names which have a , in between them along with the values. but I want the corresponding site name, year, month and quarter to display too.
Red | 2020 | Dec | Q4 | [NAME] | 90 | External
Red | 2020 | Dec | Q1 | [NAME] | 80 | External
Yellow | 2020 | Dec | Q1 | [NAME] | 70 | Internal
Yellow | 2020 | Dec | Q1 | [NAME] | 60 | External
Blue | 2020 | Dec | Q1 | [NAME] | 50 | Internal
Yellow | 2020 | Dec | Q2 | Mark | 60 | External |  |  |  |  |  | 2020 | Dec | Q4 | [NAME] | 100
Green | 2020 | Dec | Q2 | [NAME] | 70 | Internal |  |  |  |  | Red | 2020 | Dec | Q4 | [NAME] | 90
Blue | 2020 | Dec | Q4 | Mark | 81 | External |  |  |  |  | Red | 2020 | Dec | Q1 | [NAME] | 80
Green | 2020 | Dec | Q4 | [NAME] | 91 | Internal |  |  |  |  | Yellow | 2020 | Dec | Q1 | [NAME] | 70
Green | 2020 | Dec | Q4 | [NAME] | 100 | Internal |  |  |  |  | Yellow | 2020 | Dec | Q1 | [NAME] | 60
Green | 2023 | Jan | Q1 | [NAME], [NAME] | 2 | Internal |  |  |  |  | Blue | 2020 | Dec | Q1 | [NAME] | 50
 |  |  |  |  |  |  |  |  |  |  | Yellow | 2020 | Dec | Q2 | Mark | 60
 |  |  |  |  |  |  |  |  |  |  | Green | 2020 | Dec | Q2 | [NAME] | 70
 |  |  |  |  |  |  |  |  |  |  | Blue | 2020 | Dec | Q4 | Mark | 81
 |  |  |  |  |  |  |  |  |  |  | Green | 2020 | Dec | Q4 | [NAME] | 91
 |  |  |  |  |  |  |  |  |  |  | Green | 2020 | Dec | Q4 | [NAME] | 100
 |  |  |  |  |  |  |  |  |  |  | Green | 2023 | Jan | Q1 | [NAME] | 2
 |  |  |  |  |  |  |  |  |  |  | Green | 2023 | Jan | Q1 | [NAME] | 2