tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 686c7227-ca51-4198-9285-21c7c60f7f0c
Sheet: Discharge Qual Eval Directions

NOTES for conducting qualitative evaluations on discharge transects:
Full background information is found in CDFW Discharge SOP: CDFW-IFP-002
1. When conducting the qualitative evaluation, the hydrographer should consider factors that could affect the quality of discharge
measurements, as fully outlined in CDFW-IFP-002, Section 3.3. Specifiy conditions that could affect the quality of discharge measurements
as outlined below:
Flow and Spacing of Observation Verticals: A minimum of 20 vertical "cell" measurements are required per discharge transect,
 |  |  |  |  | with no more than 5% of the total flow occurring in any one cell or between
 |  |  |  |  | any two vertical measurement points, as outlined in Section 3.2, Step 6. Using fewer
 |  |  |  |  | vertical measurements may reduce the accuracy of the discharge measurement.
Measuring Section: Consider the conditions in the transect that could affect the accuracy of the discharge measurement. Such
 |  | conditions include: uniformity of depths, smoothness of the streambed, composition and uniformity of the streambed
 |  | (silt, gravel, cobbles, detritus), presence of bridge piers or other obstructions, and the ability to accurately measure depth.
Velocity Conditions: Consider the factors present that could affect the accuracy of measuring velocity. Such conditions could include:
 |  | smoothness of velocity, very slow or very high velocity, turbulence, factors that could affect the vertical distribution
 |  | of velocity, and the use of the one-point, two-point or three-point method. The Discharge Data Input form provided does not
 |  | calculate three-point velocities.
Equipment: Consider the working condition of the velocity meter being used to conduct field work.
Rapidly Changing State: Rapidly changing states can negatively affect the accuracy of discharge measurements, and should be avoided
 |  |  | when determining where to conduct discharge measurements. Consider effects of any change in staff gage level
 |  |  | that occurred over the duration of the discharge measurement.
Ice: The presence of ice generally decreases the accuracy of velocity and depth measurements. Ice affects velocity distribution and may
negatively affect equipment.
Wind: Wind can affect accuracy of discharge measurements by changing the vertical distributions of velocities, and may obscure the angle
 | of the current or produce waves that complicate depth readings.
Remarks: Describe information about equipment, weather, and any other conditions affecting the qualitative evaluation result.
Spreadsheet: 803694d1667612466-this-formula-doesnt-work-properly-when-quoting-symbols-forumhelp115
Sheet: Sheet1

NAME | physical | chemistry | geography | mathematics |  | mathematics
A | 91 | 89.5 | 94 | 85 |  | <60
B | 96 | 81 | 97 | 85 |  |  |  | Result shoild be like this
C | 92.5 | 98 | 83 | 86 |  |  |  | G
D | 92 | 89 | 91 | 64 |  |  |  | M
E | 91 | 88.5 | 92 | 83 |  |  |  | N
F | 93 | 71.5 | 88 | 83 |  |  |  | V
G | 84.5 | 88 | 80 | 58 |  |  |  | Y
H | 84 | 89.5 | 75 | 68
I | 91.5 | 72 | 84 | 78
J | 92 | 95.5 | 59 | 72
K | 89 | 76.5 | 75 | 65
L | 93.5 | 80 | 63 | 70
M | 78 | 84 | 55 | 20
N | 86 | 74 | 57 | 52
O | 89.5 | 78 | 47 | 77.5
P | 87 | 64 | 62 | 65
Q | 86.5 | 72.5 | 53 | 84
R | 85 | 61.5 | 65 | 76
S | 93 | 58 | 59 | 73
T | 79 | 58.5 | 69 | 79
U | 70.5 | 60.5 | 74 | 66
V | 88 | 57 | 59 | 42
W | 89 | 58 | 55 | 70
X | 70 | 51.5 | 72 | 74
Y | 74.5 | 59 | 54 | 57
Z | 86 | 75 | 21 | 75
Spreadsheet: 14ee8c85-2f17-4279-bc2b-8a48df84b096
Sheet: Sheet1

CERTIFICATION TEST PASS RATES*  ([NAME] and Updated 11/7/11)
 | COMPLETION YEAR 2005 |  |  |  |  |  | COMPLETION YEAR 2006 |  |  |  |  |  | COMPLETION YEAR 2007 |  |  |  |  |  | COMPLETION YEAR 2008 |  |  |  |  |  | COMPLETION YEAR 2009 |  |  |  |  |  | COMPLETION YEAR 2010 |  |  | COMPLETION YEAR 2011
 | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | FINAL |  |  | FINAL
Name of Test | Tests Taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate
School Counselor | 18 | 18 |  | 18 | 18 |  | 16 | 16 |  | 16 | 16 |  | 15 | 15 |  | 16 | 16 |  | 12 | 12 |  | 14 | 14 | 1 | 43 | 43 | 1 | 43 | 43 | 1 | 20 | 19 | 0.95 | 16 | 12 | 0.75
*Data obtained from Texas Education Agency's Accountability System for Educator Preparation (ASEP) report on pass rates sorted by Test.
*2010 Texas Education Agency starting using one yearly pass rate.
90
Spreadsheet: 9e6ac919-3730-4652-9999-0dd5cba47059
Sheet: Summer 2014

3.961 Faith Formation Through Adult Baptismal  Prep. | [NAME] | Faith Forming Faith | [NAME] | 13.6 | 9781610975278 | WIPF & Stock
 |  | Faith Shaping Ministry | [NAME] | 17 | 9781620325827 | WIPF & Stock
 |  | The Hallelujah Highway | Turner | 19 | 9781568543208 | [NAME] | Recommended
 |  | Go Make Disciples | Bushkofsky | 12.99 | 9781451426120 | A/F | Recommended
 |  | Washed and Welcome | Schnekloth | 45.95 | 9781451401301 | A/F | Recommended
4.204  Diaconal Ministry | Oldenburg | Life Together | [NAME] | 11.75 | 9780060608521 | HarperCollins
 |  | From Word & Sacrament | Larson | 19.99 | 9786000111137 | ELCA
Certificate Courses
Worship | Oldenburg | ELW - Pew Edition |  | 21.4 | 9780806656182 | A/F
 |  | Word, Water, Bread & Wine | Willimon | 13.5 | 9780817008581 | Judson Press
 |  | The Sunday Assembly | Brugh/Lathrop | 33.25 | 9780806670133 | A/F
 |  | Strong, Loving & Wise | Hovda | 15.95 | 9780814612538 | Liturgical Press | Recommended
 |  | ELW - Leader's  Edition |  | 42.75 | 9780806656205 | A/F | Recommended
 |  | Inside Out | Schattauer | 17.6 | 9780800631567 | A/F | Recommended
Introduction to Scripture | [NAME] | O.T. : Text and Context 3rd. | Matthews, Victor | 35 | 9780801048357 | Baker Book House
 |  | Introducing the N.T. | [NAME], [NAME] | 39.95 | 9780801028687 | Baker Book House
Spreadsheet: eric_saibi__9839__100401R
Sheet: Shawnee 01

Owner Name |  | Tenessee Valley Authority
Station Name |  | Shawnee Power Station
Unit Name |  | Shawnee 01
NERC Region |  | SERC
State |  | KY
Fuel Type |  | Coal
Capacity |  | 175 MW
Start Date |  | 2001-10-12 00:00:00
End Date |  | 2001-11-03 00:00:00
Prv. Start Date |  | 2001-10-05 00:00:00
Prv. End Date |  | 2001-10-27 00:00:00
Comments |  | Turbine work.
SIC |  | 4911
Plant ID |  | 1012980
Unit ID |  | 1003674
Outage ID |  | 15184
Spreadsheet: 880673d1728505969-reference-a-worksheet-using-cell-text-example
Sheet: Sheet1

Date | Transaction Type | Amount
2024-09-30 00:00:00 | Credit | 0.41
2024-09-17 00:00:00 | Credit | 546
2024-08-31 00:00:00 | Credit | 0.42
2024-07-31 00:00:00 | Credit | 0.42
2024-07-17 00:00:00 | Credit | 300
2024-06-30 00:00:00 | Credit | 0.4
2024-06-12 00:00:00 | Credit | 2000
2024-05-31 00:00:00 | Credit | 0.4
2024-05-25 00:00:00 | Debit | -56.12
2024-05-23 00:00:00 | Debit | -60.61
2024-05-22 00:00:00 | Debit | -29.18
2024-05-22 00:00:00 | Debit | -22.66
2024-05-22 00:00:00 | Credit | 164.75
2024-05-16 00:00:00 | Debit | -16.17
Spreadsheet: 9ba3f2bf-86e3-489c-acdc-950649aad0e2
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
4394 | 11532 | Franck | Paget | FRA | 0 | 01:23:15 | [NAME] | 02:10:34 | 00:01:39 | 00:45:59 | 1 | 04:22:55
4394 | 7963 | Etienne | Caprin | FRA | 0 | 02:00:44 | 00:02:16 | [NAME] | 00:02:05 | 01:12:29 | 2 | 06:09:21
Spreadsheet: richard_ring__31530__MGMT List_E and G
Sheet: Sheet1

We're Here For You
Send your inquiries, questions and/or comments to the Retail Access Mailbox first!
Each ESCO/Marketer has been assigned a Senior Customer Service Representative who will
handle all questions and requests, but all ESCO requests must always be sent in writing to
[EMAIL].  This will allow for a faster and more accurate response in the
event that your SCSR is away from the office or on another assignment.  Please see the
attached list for your SCSR's name and phone number.
Name | Organization | Title | Phone
[NAME] | Retail Choice Operations | Section Manager | [PHONE]
[NAME] | Retail Choice Operations | Senior Specialist | [PHONE]
[NAME] | Retail Choice Operations | Supervisor | [PHONE]
[NAME] | Retail Choice Operations | Supervisor | [PHONE]
[NAME] | Gas Supply | Manager | [PHONE]
[NAME] | Gas Supply | Senior Analyst | [PHONE]
[NAME] | Gas Supply | Analyst | [PHONE]
[NAME] | Gas Supply | Analyst | [PHONE]
Maxine Hall | Gas Supply | Analyst | [PHONE]
Electric Retail Access - Supporting Systems
Retail Access Information System (RAIS) |  | http://www.coned.com/retailaccess
Gas Retail Access - Supporting Systems
Transportation Customer Information System |  | www.coned.com/tcis
Customer Service Online |  | www.coned.com
 |  | (click "customer service" in the tool bar)
Spreadsheet: 0bf94d9c-7afa-408e-ac98-2f147e007b4f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
5 Teams 3 GG
 | LMPO
 | (2
 | 8am     F4
ADM | I'd Hit That | (6 |  |  | 5 Teams
(1 |  | 10:20   F4
8am     F1
 | 9:10     F1   (3
[NAME]
 | Woopass
 |  |  | 1:50    F1
Loser's Bracket |  |  | (10
 | L-6
 | 11:30    F4     (8
 | [NAME]
 |  |  |  | (11
L-1 |  | 3rd   (9 |  | 3pm   F1 | 1st Place
(4* |  | 12:40   F1
9:10     F4
L-2
 | 11:30     F1   (7
[NAME] |  |  |  | L-10
(5*
10:20     F1
L-4
NOTE: An * next to a game number in the losers bracket denotes the loser of that game is still in the tournament. The team that loses game #4 could possibly lose their first 3 games and still remain in the tournament. This is done to insure that the loser of game #3 will play a minimum of 3 games.
Spreadsheet: 141470d1329290737-excel-2007-if-contains-text-then-write-this-or-this-if-cell-contains-certain-text
Sheet: Sheet1

Original | Output
atlas234
Atlas596
AtLaS455
LeN24
LEN35
len757
Sol5464
SOL657
SoLlll33
Malll44
MAL445
malllldsdf
Spreadsheet: 218825d1362589364-formula-for-searching-one-sheet-based-on-info-from-another-and-pulling-corresponding-data-sample
Sheet: Report

p-1001 | <--- select P-number from this list
 | Name | Information | Date
 |  |  |  | <--- the formula should search "Information" for the p-number selected in A4, and return the values corresponding to each… the data starts three rows down and one column over, which is giving me  issues
 |  |  |  |  | for other parts of the spreadsheet I am using the following formula to pull data (please excuse my named ranges, they are not used in this spreadsheet), this is just to give an idea of what ive been working with
 |  |  |  |  | {=IF(ROWS(E$10:E15)<=$F$9,INDEX(TaskListRangeDyn,SMALL(IF(TasksRangeDyn=Report!$A$4,ROW(TasksRangeDyn)-ROW(Tasks!$C$7)+1),ROWS(E$10:E10))),"")}
 |  |  |  |  | example output | Name | Inforamtion | Date
 |  |  |  |  | for p-1003 | a1 | closed | 2012-02-02 00:00:00
 |  |  |  |  |  | a2 | closed | 2013-03-08 00:00:00
 |  |  |  |  |  | a3 | closed | 2009-04-20 00:00:00
 |  |  |  |  |  | a4 | closed | 2014-01-06 00:00:00
Spreadsheet: 754773d1636493202-searching-a-value-different-tabs-using-some-conditionals-planilha-de-transporte-2022-1-
Sheet: LISTAS

 | FILIAIS | DESTINOS | VEÍCULOS
 | SP | ARACAJÚ - SE | IVECO | VAN
 | GO | ATIBAIA - SP | VUK (4,8m)
 | BA | BELÉM - MA | TRUCK (10m)
 | PR | BELO HORIZONTE - MG | CARRETA(14,5m)
 |  | BRAGANÇA PAULISTA - SP
 |  | BRASÍLIA - DF
 |  | CAMPINAS - SP
 |  | CAMPO GRANDE - GO
 |  | CAMPOS DO JORDÃO - SP
 |  | CURITÍBA - PR
 |  | FLORIANÓPOLIS - SC
 |  | FORTALEZA - CE
 |  | FOZ DO IGUAÇU - PR
 |  | GOIÂNIA - GO
 |  | [NAME]
 |  | ILHA DE COMANDATUBA - BA
 |  | ITATIBA - SP
 |  | ITÚ - SP
 |  | JOÃO PESSOAS - PA
 |  | JUNDIAÍ - SP
 |  | MOGI DAS CRUZES - SP
 |  | PORTO ALEGRE - RS
 |  | [NAME] DO FORTE - BA
 |  | RECIFE - PE
 |  | RIBERÃO PRETO - SP
 |  | RIO DE JANEIRO - RJ
 |  | SALVADOR - BA
 |  | SÃO PAULO - SP
 |  | SOROCABA - SP
 |  | VALINHOS - SP
 |  | VINHEDO - SP
 |  | VITÓRIA - ES
Spreadsheet: 489999d1479554512-football-predictions-football-predictions
Sheet: Week 31

Fixtures | Week 31 |  |  |  |  | Player Scores
Home Team | Score |  |  | Away Team |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Damian West | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  |  |  |  | Weekly Total
Spreadsheet: 161119d1339422520-conditional-format-for-lowest-when-there-are-blanks-bobby1949_solution
Sheet: Sheet1

Week1 | Week2 | Week3 | Week4 | Week5 | Week6 | Week7 | Week8 | Week9 | Week10
15 | 40 | 8 | 22 | 45 | 88 | 72 | 80 | 60 | 44
50 | 48 | 48 | 4 | 9 | 5 | 54 | 8 | 60 | 64
99 | 73 | 51 | 67 | 34 | 27 | 20 | 60 | 53 | 51
75 | 66 | 67 | 34 | 1 | 77 | 87 | 12 | 85 | 65
27 | 94 | 28 | 44 | 78 | 27 | 58 | 11 | 86 | 77
64 | 86 | 73 | 94 | 8 | 96 | 84 | 91 | 41 | 49
94 | 21 | 89 | 84 | 95 | 8 | 55 | 52 | 74 | 71
78 | 15 | 53 | 91 | 18 | 63 | 87 | 87 | 13 | 52
91 | 85 | 93 | 1 | 43 | 59 | 5 | 91 | 3 | 29
37 | 95 | 10 | 55 | 83 | 100 | 63 | 85 | 47 | 67
78 | 85 | 31 | 39 | 84 | 61 | 39 | 76 | 42 | 36
70 | 66 | 7 | 93 | 19 | 70 | 94 | 59 | 6 | 18
74 | 15 | 13 | 22 | 62 | 78 | 21 | 61 | 61 | 91
41 | 1 | 82 | 70 | 29 | 54 | 56 | 23 | 16 | 91
30 | 13 | 5 | 43 | 87 | 96 | 73 | 86 | 21 | 93
63 | 48 | 44 | 30 | 61 | 3 | 94 | 86 | 52 | 12
3 | 73 | 2 | 23 | 15 | 72 | 31 | 89 | 89 | 57
6 | 3 | 76 | 12 | 15 | 71 | 84 | 47 | 89 | 65
66 | 90 | 89 | 70 | 79 | 5 | 60 | 2 | 92 | 32
27 | 35 | 39 | 7 | 88 | 71 | 15 | 20 | 85 | 64
29 | 10 | 4 | 54 | 65 | 40 | 61 | 91 | 13 | 15
23 | 49 | 78 | 68 | 6 | 91 | 33 | 3 | 36 | 68
64 | 34 | 71 | 31 | 65 | 42 | 29 | 73 | 18 | 67
23 | 56 | 86 | 79 | 92 | 38 | 69 | 91 | 80 | 24
50 | 37 | 60 | 79 | 38 | 24 | 75 | 96 | 13 | 1
51 | 74 | 1 | 7 | 94 | 63 | 5 | 41 | 78 | 57
44 | 31 | 24 | 34 | 44 | 48 | 6 | 12 | 23 | 66
49 | 51 | 51 | 80 | 76 | 98 | 21 | 38 | 4 | 29
Spreadsheet: 215103d1361266807-sumif-not-working-staff-requirements
Sheet: Machine 7

 | Staff [NAME] by Job
Machine: | 7 - RDKP54
Start Date:
End Date:
Tool | Staff Required | Start Date | End Date
Spreadsheet: 26ac145f-277a-45ed-a0f6-79920065beca
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
FCASG | Test | FCASG | [NAME] | [NAME] | Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Draw blood in a plain, red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis:	NA Thawing:	Warm OK; Cold OK Lipemia:	NA Icterus:	NA Other:	NA | < 2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.   Test Performed by:  Viracor-IBT Laboratories                               1001 NW Technology Dr.                               Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FCASG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FCASG | Result | FCASG | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 818484d1676874096-allocate-amount-by-matching-month-s-with-percentages-distribution-by-month-by-percentage
Sheet: Sheet1

 |  |  | At Month | 2 Months After | 4 Months After | 8 Months After
 |  |  | 0.1 | 0.2 | 0.3 | 0.4
 | Amount | Start |  | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00
 |  | 2023-01-31 00:00:00
 | 130 | 2023-04-30 00:00:00
 | 1000 | 2023-02-28 00:00:00
 | 398 | 2023-06-30 00:00:00
Spreadsheet: 34275d1231432420-consolidate-data-from-multiple-worksheets-example3
Sheet: Transfer

Alphanumeric Index | License Holder / Site Operator Name | Site Name | District | OPRA Code | Site Type | Throughput | [NAME]
T1 | [NAME] | abcc | district | A15 | T
T2 | [NAME] | PASDOASKD | district 4 | A10 | T
Spreadsheet: 828364d1683452213-outputting-contents-of-a-cell-with-multiple-inputs-example-testing
Sheet: Sheet1

Date of match | Match and scoreline |  |  | Inputs |  |  |  | Outputs
2018-01-01 00:00:00 | Cincinnati Cats 3-0 Dallas Dogs |  |  | Team 1 | Team 2 |  |  | 2018-01-01 00:00:00 | Cincinnati Cats 3-0 Dallas Dogs
2018-01-07 00:00:00 | Cincinnati Cats 2-3 Saudi Squirrels |  |  | Cats | Dogs |  |  | 2018-01-24 00:00:00 | Cincinnati Cats 1-3 Dallas Dogs
2018-01-12 00:00:00 | Dallas Dogs 1-3 Saudi Squirrels |  |  |  |  |  |  | 2018-02-05 00:00:00 | Cincinnati Cats 3-2 Dallas Dogs
2018-01-24 00:00:00 | Cincinnati Cats 1-3 Dallas Dogs
2018-01-31 00:00:00 | Dallas Dogs 3-2 Saudi Squirrels
2018-02-05 00:00:00 | Cincinnati Cats 3-2 Dallas Dogs
Spreadsheet: 677596d1589412667-trying-to-use-autofill-with-conditional-formatting-with-no-luck-example
Sheet: Sheet1

Correct Conditional Formatted in B3 |  |  | After dragging D3 to remaining cells for autofill
Current Share Price | Share Price Target |  | Current Share Price | Share Price Target
106.335 | 50.2 |  | 106.335 | 50.2
50.99 | 107 |  | 50.99 | 107
263.14 | 75 |  | 263.14 | 75
25.8 | 258 |  | 25.8 | 50
43.525 | 25.2 |  | 43.525 | 25.2
214.945 | 42 |  | 214.945 | 42
41.96 | 172 |  | 41.96 | 105
76.195 | 10.6 |  | 76.195 | 10.6
119.13 | 23.6 |  | 119.13 | 23.6
Spreadsheet: b07dba5f-3925-4477-b639-8fb65d4acd7a
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
4080 | 7646 | Claudia | Rivas | MEX | 21 | [NAME] | 00:00:30 | 00:14:15 | 00:00:44 | 00:10:23 | 1 | [NAME]
Spreadsheet: 137321d1327062220-using-left-with-offset-to-get-a-dynamic-drop-down-list-leftfunctionusingrange
Sheet: Sheet3

Fruit
Apple | Ap |  | Ap | Ap | Av | Ba | Bl | Bl | Bl | Br | Ch | Ch | Cl | Co | Cr | Cu | Du | Fi | Gr | Gr | Gu | Ja | Ki | Le | [NAME] | [NAME] | Ma | Ma | Ma | Me | Ne | Or | Pa | Pe | Pe | Pe | Pi | Pl | Po | Qu | Sa | Sh | St | Ta | Ug | Wa
[NAME] | Ap
Avocado | Av
[NAME] | Ba
Blackberry | Bl
Blackcurrant | Bl
Blueberry | Bl |  | Melon | Me
Breadfruit | Br
Cherimoya | Ch
[NAME] | Ch
Clementine | Cl
Coconut | Co
[NAME] | Cr
[NAME] | Cu
Durian | Du
Fig | Fi
Grape | Gr
Grapefruit | Gr
Guava | Gu
Jackfruit | Ja
Kiwi | Ki
Lemon | Le
Lime | [NAME]
[NAME] | [NAME]
Mandarin | Ma
Mango | Ma
Mangosteen | Ma
Melon | Me
Nectarine | Ne
Orange | Or
Papaya | Pa
Peach | Pe
Pear | Pe
Persimmon | Pe
Pineapple | Pi
Plum | Pl
Pomegranate | Po
[NAME] | Qu
Satsuma | Sa
Sharon Fruit (Persimmon) | Sh
[NAME] | St
Tamarillo | Ta
Ugli Fruit | Ug
Watermelon | Wa
Spreadsheet: 682271d1591986284-summing-based-on-multiple-criteria-in-another-column-sumifs-problem
Sheet: Sheet1

column A |  |  | Criteria A
15 |  |  | 15
22.5 |  |  | 22.5
24 |  |  | 24
27 |  |  | 27
30 |  |  | 30
39 |  |  | 39
45 |  |  | 45
2
234
45
2
12
2334
2
Spreadsheet: 598893d1542781316-check-duplicate-values-and-combine-cell-values-to-form-a-single-entry-calc
Sheet: Sheet1

1 | 12 | 2
1 | 32 | 3
1 | 12 | 4 | 1
2 | 12 | 4
4 | 23 | 2
5 | 34 | 3
5 | 34 | 3 | 5
6 | 56 | 6
6 | 67 | 7
6 | 78 | 7 | 6
7 | 78 | 8
8 | 67 | 9
67 | 56 | 5
67 | 67 | 5
67 | 89 | 7
67 | 99 | 7 | 67
87 | 23 | 2
76 | 34 | 2
54 | 45 | 5
32 | 45 | 5
24 | 45 | 5
24 | 45 | 5 | 24
Spreadsheet: 159624d1338788676-formula-to-calculate-how-many-people-staying-at-camp-each-night-camp-spreadsheet-example
Sheet: July 2012

MONTH |  | July |  |  | 2012-07-01 00:00:00
YEAR |  | 2012 |  |  | ROOM AVAILABILITY TABLE
DISPLAY |  | ROOM NUMBER |  |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
1 |  |  | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5 |  | 8 | 9 | 10 | 11 | 12 | 13 | 14
 |  |  | 6
 |  |  | 7
 |  |  | 8
 |  |  | 9
 |  |  | 10 |  | 15 | 16 | 17 | 18 | 19 | 20 | 21
 |  |  | 11 |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
 |  |  | 12
 |  |  | 13
 |  |  | 14
 |  |  | 15 |  | 22 | 23 | 24 | 25 | 26 | 27 | 28
 |  |  | 16 |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
 |  |  | 17
 |  |  | 18
 |  |  | 19
 |  |  | 20 |  | 29 | 30 | 31
 |  |  | 21 |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
 |  |  | 22
 |  |  | 23
 |  |  | 24
 |  |  | 25
 |  |  | 26
 |  |  | 27
 |  |  | 28
 |  |  | 29
 |  |  | 30
 |  |  | 31
 |  |  | 32
 |  |  | 33
 |  |  | 34
 |  |  | 35
Spreadsheet: 294631d1391455378-would-like-to-reveal-rows-depending-on-input-example
Sheet: Request Form

Item | Quantity | Request
Spreadsheet: 2626f745-0417-4f1f-9a5c-a817c6643f85
Sheet: Sheet1

Table S3. Sequence characteristics and transcription status of L1s within a 6-Mb genomic region of the 10q25 neocentromere | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
L1 classification | L1 nomenclature | L1 subfamily | Genomic size | Genomic position | Promoter sequence identity (%) | Transcriptional activity
Full-length L1 | L1a | L1PA6 | 6161 | chr10:117003059-117009219 | 0.83 | No
 | L1b | L1PA2 | 6207 | chr10:117111837-117118043 | 0.92 | Yes
 | L1c | L1PA3 | 6135 | chr10:117280128-117286262 | 0.72 | No
 | L1d | L1PA3 | 6039 | chr10:117331247-117337285 | 0.92 | No
 | L1e | L1PA2 | 6025 | chr10:118828540-118834564 | 0.91 | No
 | L1f | L1PA2 | 6000 | chr10:119582389-119588388 | 0.73 | No
[NAME] (with or without promoter) | L1g | L1PA4 | 5556 | chr10:115421758-115427313 |  | No
 | L1h | L1PA8A | 5309 | chr10:117065491-117070799 |  | No
 | L1i | L1P3 (+L1PA7) | 236 (+ 6221) | chr10:117235244-117241464 | 0.96 | No
 | L1j | L1PA7 | 5673 | chr10:117502684-117508356 |  | No
 | L1k | L1PA7 | 6441 | chr10:118682672-118689112 | 0.74 | No
L1 promoter only | L1l | L1PA8A | 333 | chr10:115561128-115561460 | 0.59 | No
 | L1m | L1P | 463 | chr10:116828536-116828998 | 0.83 | No
Spreadsheet: 710289d1608823089-how-to-lookup-and-match-a-day-between-2-dates-and-return-the-holiday-name-using-named-ranges-with-index-aggregate-and-countifs-bassemch-
Sheet: Sheet5

Holiday name | Holiday Date | Start Date | End Date | Holiday Count |  | EXTRA
 |  | 2021-10-24 00:00:00 | 2021-11-27 00:00:00 |  | If a Holiday Day falls between start date C and End date D, then show the Holiday name in A and relative date in B
 |  | 2021-11-28 00:00:00 | 2022-01-15 00:00:00 |  |  | Holidays list and names are in Sheet "Holidays" and named holiday_dates & holiday_names
 |  | 2022-01-16 00:00:00 | 2022-02-19 00:00:00
 |  | 2022-02-20 00:00:00 | 2022-03-26 00:00:00
 |  | 2022-03-27 00:00:00 | 2022-05-15 00:00:00
 |  | 2022-05-20 00:00:00 | 2022-06-26 00:00:00
 |  | 2022-07-02 00:00:00 | 2022-08-12 00:00:00
 |  | 2022-08-13 00:00:00 | 2022-09-18 00:00:00
 |  | 2022-09-23 00:00:00 | 2022-10-29 00:00:00
 |  | 2022-10-30 00:00:00 | 2022-12-11 00:00:00
 |  | 2022-12-16 00:00:00 | 2023-02-03 00:00:00
 |  | 2023-02-04 00:00:00 | 2023-03-10 00:00:00
 |  | 2023-03-11 00:00:00 | 2023-04-21 00:00:00
 |  | 2023-04-22 00:00:00 | 2023-06-09 00:00:00
 |  | 2023-06-10 00:00:00 | 2023-08-05 00:00:00
 |  | 2023-08-06 00:00:00 | 2023-09-23 00:00:00
 |  | 2023-09-24 00:00:00 | 2023-11-03 00:00:00