tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 20e79060-eb87-4948-9a32-35f1c442d3b5
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: New Home Sales
 |  | New Single-family [NAME]: United States
 |  | Seasonally Adjusted All Houses [Thousands of Units]
 |  | Period: 2008 to 2012
 |  | Data Extracted on: November 25, 2014 (11:35 pm)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2008
2009
2010
2011
2012
Spreadsheet: 763963d1642507903-order-scheduler-formula-help-required-please-order-schedule-test
Sheet: Summary

WK No: | WK2 |  |  |  | [NAME]
Code: |  | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8 | Product 9 | Product 10 | Product 11 | Product 12 | Product 13 | Product 14 | Product 15 | Product 16 | Product 17 | Product 18 | Product 19 | Product 20 | Product 21 | Product 22 | Product 23 | Product 24 | Product 25 | Product 26
 | Order Number
 | Quantity
 | Required By
 | Notes:
 | Other Details
 | Order Number
 | Quantity
 | Required By
 | Notes:
 | Other Details
 | Order Number
 | Quantity
 | Required By
 | Notes:
 | Other Details
 | Order Number
 | Quantity
 | Required By
 | Notes:
 | Other Details
 | Order Number
 | Quantity
 | Required By
 | Notes:
 | Other Details
 | Order Number
 | Quantity
 | Required By
 | Notes:
 | Other Details
Spreadsheet: 721675d1614811053-formula-to-index-and-match-off-multiple-criteria-then-return-data-sample
Sheet: Sheet1

ISSUE DATE | CHECK NO. | Initials | Last Name | UNIT # | SSN | # of checks | Checks to Include | Mailing Address | City | State | Zip
2020-06-10 00:00:00 | 03-751585 | K | VANG | 483 | 007 | 3 | 03-751585, 03-653270, 03-653271 | 4836 E Main AVE | FRESNO | CA | 93727
2020-12-03 00:00:00 | 01-310346 | F | HAMMOUDEH | 22 | 011 | 1 | 01-310346 | 3447 N Main ST | VISALIA | CA | 93291
2020-04-01 00:00:00 | 03-490036 | L N | ARAIM | 181 | 021 | 1 | 03-490036 | 1785 E Main AVE | FRESNO | CA | 93720
2020-06-08 00:00:00 | 03-737644 | M A | LOERA | 411 | 024 | 2 | 03-737644, 03-677118
2021-01-12 00:00:00 | 01-421581 | A D | VAWTER | 283 | 024 | 1 | 01-421581
2020-06-18 00:00:00 | 03-768143 | L E | PARRA PLASECIA | 200 | 032 | 1 | 03-768143
2020-10-01 00:00:00 | 01-103436 | J | LOPEZ RODRIGUEZ | 301 | 034 | 1 | 01-103436
Spreadsheet: 741886d1627395518-how-to-use-filter-on-two-columns-retrieve-values-based-on-conditions-in-two-columns-rubsley-
Sheet: Sample

Data: |  |  |  |  | What I want it to look like: |  |  |  |  |  |  |  |  |  |  | How to use FILTER on two columns? (excelforum.com)
 |  |  |  |  |  | [NAME] |  |  |  |  | Manually Placed
DAN | GREG | 1 | 0 |  |  |  |  |  |  |  | 1 | 0.5 | 1 | 0
STEVE | TREVOR | 0.5 | 0.5 |  |  |  |  |  |  |  | 0.5 | 1 | 0.5
GREG | STEVE | 0 | 1 |  |  |  |  |  |  |  | 0 | 0 | 0
STEVE | DAN | 0.5 | 0.5 |  |  |  |  |  |  |  | 0.5 | 0 | 1
DAN | TREVOR | 1 | 0 |  |  |  |  |  |  |  | 1
DAN | BOB | 0 | 1
TREVOR | GREG | 1 | 0
Spreadsheet: 328874d1404123944-sumifs-selecting-a-column-from-a-range-example-sheet
Sheet: Sheet 3

March 2014
Done By | Activity 1 | Activity 2 | Activity 3 | Activity 7 | Activity 8 | Activity 9 | Total
BC | 94 | 0 | 0 | 0 | 0 | 0
CD | 2 | 0 | 0 | 0 | 0 | 0
FG | 10 | 0 | 0 | 0 | 0 | 1
GH | 0 | 0 | 0 | 1 | 0 | 0
HI | 7 | 0 | 0 | 1 | 0 | 0
JK | 2 | 0 | 0 | 1 | 0 | 0
KL | 19 | 1 | 1 | 49 | 2 | 0
LM | 50 | 0 | 0 | 0 | 0 | 0
Totals for Activity
Spreadsheet: 68819d1269364900-using-min-and-max-function-to-find-times-sample
Sheet: Sheet 1

ID | Start Date & Time | End Date & Time |  | Start Date & Time | End Date & Time
1 | 2010-03-18 01:25:26 | 2010-03-18 01:26:20 |  | 01:25 AM | 01:26 AM
2 | 2010-03-11 16:15:58 | 2010-03-11 16:16:26 |  | 04:15 PM | 04:16 PM
3 | 2010-03-08 11:55:31 | 2010-03-08 11:55:31 |  | 11:55 AM | 11:55 AM
 | MINIMUM START | 2010-03-08 11:55:31 |  | MINIMUM START | 1900-01-01 00:00:00
 | MINIMUM END | 2010-03-08 11:55:31 |  | MINIMUM END | 1900-01-01 00:00:00
 | MAXIMUM START | 2010-03-18 01:25:26 |  | MAXIMUM START | 1900-01-01 00:00:00
 | MAXIMUM END | 2010-03-18 01:26:20 |  | MAXIMUM END | 1900-01-01 00:00:00
Spreadsheet: darrell_schoolcraft__7876__SUNFLOWER - NNG1
Sheet: APR

NORTHERN NATURAL GAS NOMINATION FORM
FOR SUNFLOWER ELECTRIC (S4 & S5)
ON BEHALF OF WEST PLAINS ENERGY
FOR MONTH OF: |  |  | APRIL
TO: | JENNIFER MOSSER |  | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  | FROM: | [NAME]
 | [NAME] |  | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE]
 | [NAME] |  | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  | FAX: | [PHONE]
 | [NAME] |  | [PHONE]
FAX: | [PHONE]
 |  |  |  |  |  | TOTAL |  |  |  |  | TOTAL |  |  |  |  | TOTAL
 | VOLUME |  |  |  |  | VOLUME |  |  |  |  | VOLUME |  |  |  |  | VOLUME
GAS | 1ST |  |  | CON | GAS | 2ND |  |  | CON | GAS | 3RD |  |  | CON | GAS | 4TH |  |  | CON | GAS
DAY | NOM | DATE | TIME | FIRM | PRICE | NOM | DATE | TIME | FIRM | PRICE | NOM | DATE | TIME | FIRM | PRICE | NOM | DATE | TIME | FIRM | PRICE
1 | 150 | 2001-03-30 00:00:00 | 07:57:00 |  |  | 7500 | 2001-04-02 00:00:00 | 07:53:00
2 | 150 | 2001-03-30 00:00:00 | 07:57:00 |  |  | 7500 | 2001-04-02 00:00:00 | 07:53:00
3 | 150 | 2001-04-02 00:00:00 | 07:53:00 |  |  | 7500 | 2001-04-03 00:00:00 | 07:59:00 |  |  | 10000 | 2001-04-03 00:00:00 | 10:29:00
4 | 7500 | 2001-04-03 00:00:00 | 07:59:00
5 | 7500 | 2001-04-04 00:00:00 | 07:53:00
6 | 7500 | 2001-04-05 00:00:00 | 08:13:00
7 | 1000 | 2001-04-06 00:00:00 | 07:53:00
8 | 0 | 2001-04-06 00:00:00 | 08:08:00
9 | 0 | 2001-04-06 00:00:00 | 08:08:00
10 | 150 | 2001-04-09 00:00:00 | 07:27:00
11 | 150 | 2001-04-10 00:00:00 | 07:04:00
12 | 150 | 2001-04-11 00:00:00 | 07:08:00
13 | 150 | 2001-04-12 00:00:00 | 07:12:00
14 | 150 | 2001-04-12 00:00:00 | 07:13:00
15 | 150 | 2001-04-12 00:00:00 | 07:13:00
16 | 150 | 2001-04-12 00:00:00 | 07:13:00
17 | 150 | 2001-04-16 00:00:00 | 07:17:00
18 | 150 | 2001-04-17 00:00:00 | 08:04:00
19 | 150 | 2001-04-18 00:00:00 | 07:05:00
20 | 1400 | 2001-04-19 00:00:00 | 07:36:00
21 | 150 | 2001-04-20 00:00:00 | 07:45:00
22 | 150 | 2001-04-20 00:00:00 | 07:45:00
23 | 150 | 2001-04-20 00:00:00 | 07:45:00
24 | 150 | 2001-04-23 00:00:00 | 07:21:00
25 | 150 | 2001-04-24 00:00:00 | 07:41:00
26 | 150 | 2001-04-25 00:00:00 | 07:14:00
27 | 150 | 2001-04-26 00:00:00 | 07:29:00 |  |  | 450 | 2001-04-26 00:00:00 | 12:23:00
28 | 150 | 2001-04-27 00:00:00 | 07:36:00
29 | 150 | 2001-04-27 00:00:00 | 07:36:00
30 | 150 | 2001-04-27 00:00:00 | 07:36:00
31
Spreadsheet: 708821d1608041547-excel-top-10-dashboard-book
Sheet: RESULTS HERE

ID | RMA Number | Serial Number | Client | Days in service | Current Status
1 |  |  |  |  |  | All results should populate automatically. Top 10 from days in service (Highest to lowest).
2
3 |  |  |  |  |  | 2nd idea: When "Days in service" is more than 10 days values should show in this table. Same top10 needed.
4
5
6
7
8
9
10
Spreadsheet: 129217d1321500676-update-multiple-cells-based-on-value-in-another-cell-pay-slip
Sheet: Template

PAY ADVICE
Payment date: | 2011-11-14 00:00:00 |  |  |  |  | Gemima Puddleduck
Pay Period: | 2011-11-07 00:00:00 | - | 2011-11-14 00:00:00 |  |  | Employee No:
Company Name |  |  |  |  |  | Job Classification:
Address
Address
Address
[NAME]:
Description |  |  |  | Hours | Rate |  |  |  | Amount
Normal Hours |  |  |  | 15 |  | 19.43 |  |  | 291.5 | 291.5
Overtime |  |  |  |  |  |  |  |  | 0
Gross |  |  |  |  |  |  |  |  | 291.5 | 291.5
PAYG Withholding |  |  |  |  |  |  |  |  | 7
Net Pay |  |  |  |  |  |  |  |  | 284.5 | 284.5
Gross YTD |  |  |  |  |  |  |  |  | 0
Tax YTD |  |  |  |  |  |  |  |  | 0
Net YTD |  |  |  |  |  |  |  |  | 0
Annual Leave Accrued |  |  |  |  |  |  |  |  | 0
Personal/Carers Leave Accrued |  |  |  |  |  |  |  |  | 0
Spreadsheet: 0d269823-451d-4e6c-9fba-0da48e538b92
Sheet: Equipo de Trabajo

EQUIPO DE TRABAJO
NOMBRE | PROFESIÓN | ROL | [NAME]
[NAME] | Economista | Coordinadora | [EMAIL]
Enriqueta Matinez | Sociologa | Técnica (Social) | [NAME]
[NAME] | Economista | [NAME] | [NAME]
[NAME] | Bióloga | [NAME] (Modelo de Gestión Territorial) | [EMAIL]
[NAME] | Arquitecto | Técnico(Límites territoriales) | [EMAIL]
[NAME] | Ing. [NAME] | Técnica(SIG) | [EMAIL]
[NAME] | Arquitecto | Técnico(Medio físico) | [EMAIL]
Esteban Valarezo | Ing. [NAME] | Técnico (Planes y Programas) | [EMAIL]
[NAME] | Arquitecto | Técnico (Planes Rurales) | [EMAIL]
[NAME] | Economista | Técnico (Económica) | [EMAIL]
Stefany Vega | Secretaria | Trámites | [NAME]
Spreadsheet: 857943d1706786750-formula-to-add-the-next-consecutive-letter-to-a-concat-cell-demo-ans2
Sheet: Manual Timesheets

Worksheet
Manual Entry | Manual Entry | Visual helper to show each day separated out on the invoice | Result I want the formula to produce | FORMULA
Date | Invoice # | Ticket Demo Helper | Ticket # | Column1
2024-01-04 00:00:00 | 24-001 |  | 24-001A
2024-01-04 00:00:00 | 24-001 |  | 24-001A
2024-01-05 00:00:00 | 24-001 |  | 24-001B
2024-01-13 00:00:00 | 24-001 |  | 24-001C
2024-01-05 00:00:00 | 24-002 |  | 24-002A
2024-01-05 00:00:00 | 24-002 |  | 24-002A
2024-01-06 00:00:00 | 24-002 |  | 24-002B
2024-01-06 00:00:00 | 24-002 |  | 24-002B
2024-01-07 00:00:00 | 24-002 |  | 24-002C
2024-01-07 00:00:00 | 24-002 |  | 24-002C
2024-01-08 00:00:00 | 24-002 |  | 24-002D
2024-01-13 00:00:00 | 24-002 |  | 24-002E
2024-01-13 00:00:00 | 24-002 |  | 24-002E
2024-01-08 00:00:00 | 24-003 |  | 24-003A
2024-01-08 00:00:00 | 24-003 |  | 24-003A
2024-01-09 00:00:00 | 24-003 |  | 24-003B
2024-01-09 00:00:00 | 24-003 |  | 24-003B
2024-01-13 00:00:00 | 24-003 |  | 24-003C
Spreadsheet: 04824e75-467e-4c89-b94d-ea8837e4b039
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
FUNB | Test | FUNB | Fungal Ident Panel B | Fungal Ident Panel B |  |  |  |  |  |  | This test is for Billing Purposes Only.  This is not an orderable test. |  |  |  |  |  |  | 1 | 87107 |  |  |  |  | Rochester
FUNB | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: 860801d1708799751-non-sequential-row-problem-ef1631_irregular_rows
Sheet: 1214

Row | Data
3
Spreadsheet: 212520d1360157717-need-help-auto-generate-columns-stafprofile
Sheet: bmi

Name | BMI
Spreadsheet: 219281d1362697936-reduce-percentage-yearly-yearly-average
Sheet: Sheet1

Year Month | Year | Monthly | (Yearly Average) | Reduce 10% from [NAME] in Yearly average
2010-01-01 00:00:00 | 2010 | 6737.58865248227 | 7400.387995875934
2010-02-01 00:00:00 | 2010 | 4504.504504504504 | 7400.387995875934
2010-03-01 00:00:00 | 2010 | 6965.174129353234 | 7400.387995875934
2010-04-01 00:00:00 | 2010 | 6550.218340611354 | 7400.387995875934
2010-05-01 00:00:00 | 2010 | 6609.19540229885 | 7400.387995875934
2010-06-01 00:00:00 | 2010 | 5636.070853462158 | 7400.387995875934
2010-07-01 00:00:00 | 2010 | 5536.130536130536 | 7400.387995875934
2010-08-01 00:00:00 | 2010 | 5747.126436781609 | 7400.387995875934
2010-09-01 00:00:00 | 2010 | 5610.561056105611 | 7400.387995875934
2010-10-01 00:00:00 | 2010 | 10752.68817204301 | 7400.387995875934
2010-11-01 00:00:00 | 2010 | 11168.38487972509 | 7400.387995875934
2010-12-01 00:00:00 | 2010 | 12987.01298701299 | 7400.387995875934
2011-01-01 00:00:00 | 2011 | 15350.87719298246 | 19699.04727202049
2011-02-01 00:00:00 | 2011 | 18518.51851851852 | 19699.04727202049
2011-03-01 00:00:00 | 2011 | 12527.23311546841 | 19699.04727202049
2011-04-01 00:00:00 | 2011 | 14367.81609195402 | 19699.04727202049
2011-05-01 00:00:00 | 2011 | 13071.8954248366 | 19699.04727202049
2011-06-01 00:00:00 | 2011 | 18229.16666666667 | 19699.04727202049
2011-07-01 00:00:00 | 2011 | 18867.92452830189 | 19699.04727202049
2011-08-01 00:00:00 | 2011 | 23616.73414304993 | 19699.04727202049
2011-09-01 00:00:00 | 2011 | 27224.43559096946 | 19699.04727202049
2011-10-01 00:00:00 | 2011 | 27906.97674418605 | 19699.04727202049
2011-11-01 00:00:00 | 2011 | 15456.98924731183 | 19699.04727202049
2011-12-01 00:00:00 | 2011 | 31250 | 19699.04727202049
2012-01-01 00:00:00 | 2012 | 15337.42331288343 | 8295.803090594338
2012-02-01 00:00:00 | 2012 | 8375.209380234504 | 8295.803090594338
2012-03-01 00:00:00 | 2012 | 9157.509157509157 | 8295.803090594338
2012-04-01 00:00:00 | 2012 | 3623.188405797101 | 8295.803090594338
2012-05-01 00:00:00 | 2012 | 11217.94871794872 | 8295.803090594338
2012-06-01 00:00:00 | 2012 | 12910.79812206573 | 8295.803090594338
2012-07-01 00:00:00 | 2012 | 10040.16064257028 | 8295.803090594338
2012-08-01 00:00:00 | 2012 | 2777.777777777778 | 8295.803090594338
2012-09-01 00:00:00 | 2012 | 6024.096385542169 | 8295.803090594338
2012-10-01 00:00:00 | 2012 | 992.063492063492 | 8295.803090594338
2012-11-01 00:00:00 | 2012 | 5555.555555555556 | 8295.803090594338
2012-12-01 00:00:00 | 2012 | 13537.90613718412 | 8295.803090594338
Spreadsheet: 67cb04e9-aa78-44bf-a0d6-9b56873f4ad6
Sheet: Sheet1

Facility Name | Facility State | FacilityType | Permit Number | 2000Total | 2001Total | 2002Total | 2003Total | 2004Total | 2005Total
CENTRAL CAROLINA TIRE MONOFILL | NC | TIRELF | 4304 | 61104.23 | 66010 | 71111.9 | 77671.97 | 79710.356 | 86142.24599999998
US TIRE DISPOSAL | NC | TIRELF | 1303 | 89426.06 | 92865.77 | 152432.28 | 13282.37 | 18138.67 | 22439.73
Spreadsheet: 770930d1646337240-need-help-with-adding-new-criteria-to-formula-book1
Sheet: Data

Y/N Indicator | ID | Stat | Type | Form | Date
 | 1 | Complete | Add | GF | 2019-01-31 00:00:00
 | 2 | Open | [NAME] | MB | 2020-07-15 00:00:00
 | 3 | Pre-Submit | Add | GF | 2021-04-14 00:00:00
 | 4 | Open | Add | MB | 2021-10-01 00:00:00
 | 5 | Complete | [NAME] | MB | 2022-01-02 00:00:00
Spreadsheet: 02800982-1fef-4dd0-863d-26ea08b8b39c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 44. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (QLD), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | A2413781A | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413782C | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413783F | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413784J | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413785K | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413786L | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413787R | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413788T | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413789V | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413790C | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413791F | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 0bcc2616-63dd-430e-ab74-d2d8ec591b73
Sheet: Sheet1

Unnamed: 0 | Wytheville Community College | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | Inventory Report Form
WCC Inventory Number: |  |  |  |  |  | Location of Item
Description:
Quantity |  |  |  |  |  | Serial Number
Check Appropriate [NAME])
Lost/Stolen: |  | Date Item Determined Missing:
 |  |  | Reason:
Surplus |  | Model NO. |  |  |  | Condition:
 |  | Reason:
Cannibalized: used for parts
Transferred: |  | From: | Room |  | Person |  |  | Dept
 |  | To: | Room |  | Person |  |  | Dept
Remarks:
Initiated By: |  |  |  |  | Date: |  | Received by:
 |  |  |  |  |  |  |  | Date:
Please Return to the Business Office After Completion.
Spreadsheet: 321f532f-1847-4501-8235-5cd1c2986200
Sheet: Sheet1

Locality | n | µ | h | π
HBwh | 10 | 6 | 0.867 ± 0.085 | 0.0056 ± 0.0006
HBjz | 10 | 7 | 0.911 ± 0.077 | 0.0025 ± 0.0004
HBqj | 10 | 6 | 0.911 ± 0.062 | 0.0032 ± 0.0004
HByx | 10 | 8 | 0.945 ± 0.054 | 0.0045 ± 0.0006
HBhh | 10 | 2 | 0.533 ± 0.095 | 0.0013 ± 0.0002
HBga | 10 | 3 | 0.644 ± 0.101 | 0.0033 ± 0.0005
HNlx | 10 | 4 | 0.711 ± 0.117 | 0.0011 ± 0.0003
HNxy | 10 | 3 | 0.644 ± 0.101 | 0.0016 ± 0.0003
HNhr | 10 | 7 | 0.911 ± 0.077 | 0.0033 ± 0.0005
AHtl | 10 | 3 | 0.644 ± 0.101 | 0.0023 ± 0.0003
AHgc | 10 | 4 | 0.644 ± 0.152 | 0.0017 ± 0.0007
AHzy | 10 | 2 | 0.467 ± 0.132 | 0.0006 ± 0.0002
JXxj | 10 | 5 | 0.844 ± 0.080 | 0.0025 ± 0.0006
JXpz | 10 | 3 | 0.644 ± 0.101 | 0.0035 ± 0.0005
[NAME] | 10 | 5 | 0.867 ± 0.071 | 0.0030 ± 0.0004
[NAME] | 10 | 2 | 0.200 ± 0.154 | 0.0010 ± 0.0008
YNey | 10 | 1 | 0.000 ± 0.000 | 0.0000 ± 0.0000
YNhq | 10 | 1 | 0.000 ± 0.000 | 0.0000 ± 0.0000
All | 180 | 39 | 0.916 ± 0.011 | 0.0035 ± 0.0002
The names of sample localities were abbreviated as the same as in Table 1.
For Cytb-ND4L-ND4, the haplotype and nucleotide diversity in populations in the ML reaches were all higher than those in populations in the SW China region.
n, the number of worms sequenced; µ, the number of unique haplotypes within a locality; h, haplotype diversity ± standard deviation; π, nucleotide diversity ± standard deviation.
Spreadsheet: bcbcfa26-503b-4b57-b037-e1a3905aa3d3
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Radebeul, Stadt - Variante 1
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 15 | 4809 | 4919 | 4929 | 4783
15 - 65 | 20622 | 20687 | 20564 | 20286
65 und mehr | 8338 | 8369 | 8915 | 9364
Insgesamt | 33769 | 33975 | 34408 | 34433
%
unter 15 | 14.24087180550209 | 14.47829286239882 | 14.32515694024646 | 13.89074434408852
15 - 65 | 61.06784328822292 | 60.88888888888889 | 59.76517089049058 | 58.9144134986786
65 und mehr | 24.69128490627498 | 24.63281824871229 | 25.90967216926296 | 27.19484215723288
Insgesamt | 100 | 100 | 100 | 100
Abhängigkeitsquotient
Jugendquotient | 23.31975560081467 | 23.7782182046696 | 23.96907216494845 | 23.5778369318742
Altenquotient | 40.43254776452333 | 40.45535843766616 | 43.35246061077611 | 46.15991324065858
Gesamtquotient | 63.75230336533799 | 64.23357664233576 | 67.32153277572456 | 69.73775017253278
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 747266d1631323615-calculate-response-time-between-set-hours-sla-hours-between-dates-shift-work-xlsx-
Sheet: SLA

Start date | End date | All-In-One | Using Helpers |  |  |  |  |  |  |  | Check
2021-08-20 07:00:00 | 2021-08-30 00:00:00
2021-06-27 18:02:21 | 2021-07-01 08:47:14
2021-06-27 19:11:47 | 2021-07-01 08:48:35
2021-06-28 20:26:18 | 2021-07-04 12:12:58
2021-06-28 20:34:35 | 2021-07-04 12:13:54
2021-06-28 21:34:13 | 2021-07-04 12:15:49
2021-06-28 21:30:20 | 2021-07-04 12:19:03
2021-06-28 21:45:49 | 2021-07-04 12:21:38
2021-06-28 21:43:23 | 2021-07-04 12:25:27
2021-06-29 09:51:09 | 2021-07-01 08:36:10
2021-06-29 10:00:21 | 2021-07-01 15:54:41
2021-06-29 10:08:49 | 2021-07-01 08:28:25
2021-06-29 14:00:56 | 2021-07-03 16:20:16
2021-06-29 16:05:17 | 2021-07-01 14:18:42
2021-06-29 16:04:46 | 2021-07-02 13:54:26
2021-06-29 16:15:25 | 2021-07-01 14:08:32
2021-06-29 02:32:37 | 2021-07-24 13:22:53
2021-05-16 18:32:14 | 2021-06-01 20:00:00
2021-06-30 18:32:14 | 2021-07-04 13:27:00
Spreadsheet: 113758d1309565771-issue-with-date-month-year-formating-month-year-dropdown-list
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | 2010-08-01 00:00:00 | select date from sheet2 cell B2
 |  | Date |  |  |  |  |  |  |  |  | Match Date |  | 2
 | 1999-02-01 00:00:00 | 1999-02-01 00:00:00 |  |  |  |  |  |  |  |  | no |  |  | 20
 | 1999-02-09 00:00:00 | 1999-02-09 00:00:00 |  |  |  |  |  |  |  |  | no |  |  | 21
 | 1999-02-09 00:00:00 | 1999-02-09 00:00:00 |  |  |  |  |  |  |  |  | no
 | 1999-02-10 00:00:00 | 1999-02-10 00:00:00 |  |  |  |  |  |  |  |  | no
 | 1999-02-10 00:00:00 | 1999-02-10 00:00:00 |  |  |  |  |  |  |  |  | no
 | 1999-03-01 00:00:00 | 1999-03-01 00:00:00 |  |  |  |  |  |  |  |  | no
 | 1999-03-01 00:00:00 | 1999-03-01 00:00:00 |  |  |  |  |  |  |  |  | no
 | 1999-03-02 00:00:00 | 1999-03-02 00:00:00 |  |  |  |  |  |  |  |  | no
 | 1999-03-02 00:00:00 | 1999-03-02 00:00:00 |  |  |  |  |  |  |  |  | no
 | 1999-03-03 00:00:00 | 1999-03-03 00:00:00 |  |  |  |  |  |  |  |  | no
 | 1999-04-01 00:00:00 | 1999-04-01 00:00:00 |  |  |  |  |  |  |  |  | no
 | 1999-04-02 00:00:00 | 1999-04-02 00:00:00 |  |  |  |  |  |  |  |  | no
 | 1999-04-03 00:00:00 | 1999-04-03 00:00:00 |  |  |  |  |  |  |  |  | no
 | 2010-08-01 00:00:00 | 2010-08-01 00:00:00 |  |  |  |  |  |  |  |  | yes | 1
 | 2010-08-01 00:00:00 | 2010-08-01 00:00:00 |  |  |  |  |  |  |  |  | yes | 2
 | 2010-08-02 00:00:00 | 2010-08-02 00:00:00 |  |  |  |  |  |  |  |  | no
 | 2010-08-03 00:00:00 | 2010-08-03 00:00:00 |  |  |  |  |  |  |  |  | no
 | 2010-08-03 00:00:00 | 2010-08-03 00:00:00 |  |  |  |  |  |  |  |  | no
Spreadsheet: 217371d1362057697-match-and-sum-with-date-range-neagtive-values-find-and-sum
Sheet: Sheet1

 |  |  | Date Range |  | Source |  | Date Date | A | B | C |  | Kgs
 |  |  | 2013-02-01 00:00:00 | 2013-02-27 00:00:00 | A |  | 2013-02-02 00:00:00 | 0.03 | 0.04 |  |  | 100
 |  |  | 2013-02-01 00:00:00 | 2013-02-27 00:00:00 | B |  | 2013-02-03 00:00:00 | 0.03 | 0.02 |  |  | 100
 |  |  | 2013-02-01 00:00:00 | 2013-02-27 00:00:00 | C |  | 2013-02-03 00:00:00 | 0.03 | 0.04 |  |  | 100
 |  |  | 2013-01-01 00:00:00 | 2013-01-12 00:00:00 | A |  | 2013-01-01 00:00:00 | 0.03 | 0.04 |  |  | 100
Description |  |  | Match Date Range |  | Source |  |  |  |  |  |  | Kg
Sumif for this date range if negative % column K and source is A |  |  | 2013-02-01 00:00:00 | 2013-02-27 00:00:00 | A |  |  |  |  |  |  |  | Result
Sumif for this date range if negative % column K and source is B |  |  | 2013-02-01 00:00:00 | 2013-02-27 00:00:00 | B |  |  |  |  |  |  | 0 | Result
Sumif for this date range if negative % column K and source is C |  |  | 2013-02-01 00:00:00 | 2013-02-27 00:00:00 | C |  |  |  |  |  |  |  | Result
Sumif for this date range if negative % column K and source is A |  |  | 2013-01-01 00:00:00 | 2013-01-12 00:00:00 | A |  |  |  |  |  |  |  | Result