tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 063026eb-2384-4a02-98c0-a3de0df0f51f
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 36. LEASE FINANCE COMMITMENTS, By Purpose: State (TAS), 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 | A2413895X | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413896A | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413897C | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413898F | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413899J | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413900F | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413901J | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413902K | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413903L | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413904R | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | A2413905T | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413906V | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413907W | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413908X | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413909A | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413910K | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 699674d1602697276-vlookup-via-dropdown-from-second-sheet-sampledata2a-1-
Sheet: Sheet2

 | Course Name | Duration | Cost | Deposit |  |  | Payment Terms | Monthly Payment Period |  | Weekly Payment Period
 | Example 1 | 12 Months | 2000 | 100 | Weekly |  | Weekly | 2 Months | 2 | 4 Weeks | 4
 | Example 2 | 13 Months | 3000 | 100 | Monthly |  | Monthly | 3 Months | 3 | 6 Weeks | 6
 | Example 3 | 14 Months | 4000 | 100 | Monthly |  |  | 4 Months | 4 | 8 Weeks | 8
 | Example 4 | 15 Months | 5000 | 100 | Monthly |  |  | 5 Months | 5 | 10 Weeks | 10
 | Example 5 | 16 Months | 6000 | 100 | Monthly |  |  | 6 Months | 6 | 12 Weeks | 12
 | Example 6 | 17 Months | 7000 | 100 | Monthly |  |  | 7 Months | 7 | 14 Weeks | 14
 | Example 7 | 18 Months | 5000 | 100 | Monthly |  |  | 8 Months | 8 | 16 Weeks | 16
 | Example 8 | 19 Months | 9000 | 100 | Monthly |  |  | 9 Months | 9 | 18 Weeks | 18
 | Example 9 | 20 Months | 1000 | 100 | Monthly |  |  | 10 Months | 10 | 20 Weeks | 20
 | Example 10 | 21 Months | 2500 | 500 | Monthly |  |  | 11 Months | 11
 | Example 11 | 22 Months | 3500 | 100 | Monthly |  |  | 12 Months | 12
 | Example 12 | 23 Months | 4750 | 100 | Monthly
Spreadsheet: 99837d1298394406-vlookup-and-sumif-internal-price-list
Sheet: Sheet1

 | Part Number | Manfc | Minimum | # on Hand |  | List Price | Extended
 | 90-555 | Grey | 8 | 6 | Current sensor | 167.63
 | 91-500 | Black | 4 | 6 | Current switch | 135.93
 | 555-123 | Acme | 3 | 3 | RJ11 to Service Modem
 | 555-897 | Acme | 3 | 2 | [NAME]
 | 555-450 | Acme | 3 | 3 | Trunk Isolator
Spreadsheet: 761963d1641316602-google-sheets-how-to-pull-row-numbers-from-different-sheets-based-on-date-solved-reddit-pls-help-sheet-2-
Sheet: Tertiary

 | Date | width | length | unique id | location | source | lane
 | 2021-12-29 11:05:00 | 1.5 | 20 | 58048752 | 60 | 1CH2145033 | 3
 | 2021-12-29 15:25:00 | 1.5 | 20 | 58048752 | 60 | 1CH2145033 | 4
 | 2021-12-30 11:31:00 | 1.5 | 20 | 58048752 | 60 | 1CH2145033 | 3
 | 2021-12-30 15:12:00 | 1.5 | 20 | 1100028429 | 60 | 1CH2145033 | 6
 | 2021-12-31 07:10:00 | 1.5 | 20 | 1100028429 | 60 | 1CH2145033 | 4
 | 2022-01-01 07:26:00 | 1.5 | 20 | 2425333 | 60 | 1CH2145033 | 3
 | 2022-01-01 08:06:00 | 1.5 | 20 | 2425333 | 60 | 1CH2145033 | 2
 | 2022-01-01 07:26:00 | 1.5 | 20 | 2425333 | 60 | 1CH2145033 | 5
Spreadsheet: 865381d1712414320-scheduling-rules-help-excelforum-help-file
Sheet: JULY

Month: | Year:
APR | 2024 | CALLS | Off Request | Employees
Day | Date
Saturday | 2024-06-01 00:00:00 |  | AA,HH,JJ,CC | AA
Sunday | 2024-06-02 00:00:00 |  | AA,HH,JJ,CC | BB
Monday | 2024-06-03 00:00:00 |  | AA,HH,JJ,CC | CC
Tuesday | 2024-06-04 00:00:00 |  | AA,HH,JJ,CC | DD
Wednesday | 2024-06-05 00:00:00 |  | AA,HH,JJ,CC | EE
Thursday | 2024-06-06 00:00:00 |  |  | FF
Friday | 2024-06-07 00:00:00 |  |  | GG
Saturday | 2024-06-08 00:00:00 |  |  | HH
Sunday | 2024-06-09 00:00:00 |  |  | II
Monday | 2024-06-10 00:00:00 |  |  | JJ
Tuesday | 2024-06-11 00:00:00
Wednesday | 2024-06-12 00:00:00 |  | GG
Thursday | 2024-06-13 00:00:00 |  | GG
Friday | 2024-06-14 00:00:00 |  | GG
Saturday | 2024-06-15 00:00:00 |  | GG
Sunday | 2024-06-16 00:00:00 |  | GG
Monday | 2024-06-17 00:00:00
Tuesday | 2024-06-18 00:00:00
Wednesday | 2024-06-19 00:00:00
Thursday | 2024-06-20 00:00:00
Friday | 2024-06-21 00:00:00
Saturday | 2024-06-22 00:00:00 |  | EE
Sunday | 2024-06-23 00:00:00 |  | EE
Monday | 2024-06-24 00:00:00 |  | EE
Tuesday | 2024-06-25 00:00:00 |  | DD
Wednesday | 2024-06-26 00:00:00 |  | DD
Thursday | 2024-06-27 00:00:00 |  | DD
Friday | 2024-06-28 00:00:00 |  | DD
Saturday | 2024-06-29 00:00:00
Sunday | 2024-06-30 00:00:00
Spreadsheet: 861956d1709771124-simplifying-cohort-analysis-formula-in-1-row-book1-29-
Sheet: Sheet1

Month | 1
New Users | 100 | 0 | 0 | 50 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0
Intake Decay 1
Intake Decay 2 | 0 | 0 | 0
Intake Decay 3 | 0 | 0 | 0 | 0 | 0
Total
Total
This is a cohort analysis. I am trying to find a formula that gets me the total in 1 row as opposed to adding the decay rows together. Only  use row 1 and 3.
Spreadsheet: 024a6895-f9cf-43e6-a545-19ec9921e56a
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
10/16/2010 | Women's Swimming & Diving | PENN STATE | 12:00 AM | L, 67-174
10/23/2010 | Women's Swimming & Diving | at [NAME] | 12:00 AM | W, 170.5-124.5
11/05/2010 | Women's Swimming & Diving | at Louisville | 12:00 AM | L, 105-186
11/06/2010 | Women's Swimming & Diving | at Cincinnati | 12:00 AM | L, 130-162
11/13/2010 | Women's Swimming & Diving | RUTGERS | 12:00 AM | W, 148-146
11/18/2010 | Women's Swimming & Diving | UNC Nike Cup (Chapel Hill, N.C.) | 12:00 AM | 5th place
11/19/2010 | Women's Swimming & Diving | UNC Nike Cup (Chapel Hill, N.C.) | 12:00 AM | 4th place
11/20/2010 | Women's Swimming & Diving | UNC Nike Cup (Chapel Hill, N.C.) | 12:00 AM | 4th place
12/31/2010 | Women's Swimming & Diving | at UC Santa Barbara | 12:00 AM | L, 103-158
01/08/2011 | Women's Swimming & Diving | at Pitt | 12:00 AM | L, 104-194
01/22/2011 | Women's Swimming & Diving | MARYLAND | 12:00 AM | L, 96-202
01/29/2011 | Women's Swimming & Diving | OHIO | 12:00 AM | L, 122-176
02/16/2011 | Women's Swimming & Diving | BIG EAST Swimming Championships (Louisville, Ky.) | 12:00 AM | 7th place
02/17/2011 | Women's Swimming & Diving | BIG EAST Swimming Championships (Louisville, Ky.) | 12:00 AM | 4th place
02/18/2011 | Women's Swimming & Diving | BIG EAST Swimming Championships (Louisville, Ky.) | 12:00 AM | 3rd place
02/19/2011 | Women's Swimming & Diving | BIG EAST Swimming Championships (Louisville, Ky.) | 12:00 AM | 3rd place
03/03/2011 | Women's Swimming & Diving | Indianapolis Grand Prix (Indianapolis, Ind.) | 12:00 AM | 9:00 a.m.
03/04/2011 | Women's Swimming & Diving | Indianapolis Grand Prix (Indianapolis, Ind.) | 12:00 AM | 9:00 a.m.
03/05/2011 | Women's Swimming & Diving | Indianapolis Grand Prix (Indianapolis, Ind.) | 12:00 AM | 9:00 a.m.
03/06/2011 | Women's Swimming & Diving | Indianapolis Grand Prix (Indianapolis, Ind.) | 12:00 AM | 9:00 a.m.
03/17/2011 | Women's Swimming & Diving | NCAA Women's Championships (Austin, Texas) | 12:00 AM | Noon
03/18/2011 | Women's Swimming & Diving | NCAA Women's Championships (Austin, Texas) | 12:00 AM | Noon
03/19/2011 | Women's Swimming & Diving | NCAA Women's Championships (Austin, Texas) | 12:00 AM | Noon
Spreadsheet: 847783d1698657883-conditional-formatting-training-certificate-expiration-dates-course-matrix-august-2023
Sheet: Working at Height

 |  | Working at Height
 |  |  | (2 Years)
 | Name | Course | Date of course | Date of renewal
 | [NAME] | Working at height | N/A | Not required |  |  | Key
 | [NAME] | Working at height | 25/04/23 | 25/04/25 |  |  |  | Not due
 | [NAME] | Working at height | 2023-05-03 00:00:00 | 2025-05-03 00:00:00 |  |  |  | Overdue
 | [NAME] | Working at height | 29/04/23 | 29/04/25 |  |  |  | Due within the next week
 | [NAME] | Working at height |  | Required |  |  |  | Required
 | [NAME] | Working at height |  | Required |  |  |  | Not Required
 | [NAME] | Working at height | N/A | Not required
 | [NAME] | Working at height | 2023-05-04 00:00:00 | 2025-05-04 00:00:00
 | [NAME] | Working at height | 2023-09-05 00:00:00 | 2025-09-05 00:00:00
 | [NAME] | Working at height | 2023-05-09 00:00:00 | 2025-05-09 00:00:00
 | [NAME] | Working at height |  | Not required
 | Greg Love | Working at height | N/A | Not required
 | [NAME] | Working at height | 2023-03-05 00:00:00 | 2025-03-05 00:00:00
 | [NAME] | Working at height | 2023-03-05 00:00:00 | 2025-03-05 00:00:00
 | [NAME] Parkinson | Working at height | 2021-02-17 00:00:00 | 2023-02-17 00:00:00
 | [NAME] | Working at height |  | Required
 | [NAME] | Working at height | N/A | Not required
 | [NAME] | Working at height | 2023-03-04 00:00:00 | 30/04/25
 | [NAME] | Working at height | 2023-09-05 00:00:00 | 2025-09-05 00:00:00
 | [NAME] | Working at height | 26/04/23 | 26/04/25
 | [NAME] | Working at height |  | Required
 | [NAME] | Working at height | 2019-01-18 00:00:00 | Not required
 | [NAME] | Working at height | 27/04/23 | 27/04/25
 | [NAME] | Working at height | N/A | Not required
 | [NAME] | Working at height | 27/04/23 | 27/04/25
 | [NAME] | Working at height | N/A | Not required
 | [NAME] | Working at height |  | Required
 | [NAME] | Working at height | N/A | Not required
 | [NAME] | Working at height | 29/04/23 | 29/04/25
 | [NAME] | Working at height | N/A | Not required
Spreadsheet: 754958d1636595431-ar-aging-using-fifo-method-fifo-aging-formula
Sheet: Sheet1

 | Ending Balance | Customer Invoice 0-30 Days | Customer Invoice 31-60 Days | Customer Invoice 61-90 Days | Customer Invoice 91-120 Days | Customer Invoice 121-180 Days | Customer Invoice 181-1 Yr | Customer Invoice 1+ Yr | Payment 0-30 Days | Payment 31-60 Days | Payment 61-90 Days | Payment 91-120 Days | Payment 121-180 Days | Payment 181-1 Yr | Payment 1+ Yr
Output |  | 0 | -150000 | -150000 | -37500 | -37500 | -150000 | 0 | 41641.79 | 40298.51 | 41641.79 | 41641.79 | 81940.3 | 161194.03 | 0
Output |  | 0 | -150000 | -150000 | -37500 | -37500 | -150000 | 0 | 141641.79 | 140298.51 | 41641.79 | 41641.79 | 81940.3 | 161194.03 | 0
Calculated results
Calculated results
Desired Results |  | 83358.21000000006 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 78e860fe-a9a6-4af5-a013-6333059056c6
Sheet: Human Footprint

Table 1. Percentage Human Development in the entire Boreal Plains Ecozone and nested ecoregions (circa 2010; ABMI source data)
Human Development Category | Boreal Transition | Clear Hills Upland | Mid-Boreal Uplands | Peace Lowland | Slave River Lowland | [NAME] | Western Alberta Upland | Western Boreal | Total human footprint (%)
Cultivation and Irrigation Infrastructure | 46.82697543737049 | <1 | 1.443039042659768 | 30.84947423481059 | <1 | <1 | 4.246976425075887 | 10.59070319532746 | 11.67592123347548
Residential, Commercial, and Energy Infrastructure | 4.184366584254177 | 2.145173718636597 | 2.374638510506364 | 2.070419390299937 | 0.74373634097358 | 2.275515218020914 | 3.160618538913779 | 2.862452983978022 | 2.512880581706524
Transportation Infrastructure | 2.549320456012806 | <1 | <1 | 1.347192224878335 | <1 | <1 | 1.317804880495512 | 1.056089711252353 | 0.9110837285961663
[NAME] | 0.8109987336713271 | 5.220734091979426 | 3.697488185950364 | 3.168237036865415 | <1 | 3.119653717866652 | 18.07355917634034 | 9.179572307012352 | 5.749091373949316
Total Human Development (%) | 54.3716612113088 | 7.906965621816287 | 7.858752787328231 | 37.43532288685427 | 1.303690358844463 | 5.880697054803066 | 26.79895902082552 | 23.68881819757019 | 20.84897691772749
Table 2. Percentage of human development in the JCA Oil Sands Region (circa 2010; ABMI source data)
Human Development Category | Percent Human Footprint (%)
Cultivation and Irrigation Infrastructure | 6
[NAME] | 3
Residential, Commercial, and Energy Infrastructure | 2
Transportation Infrastructure | <1
Total Human Footprint (%) | 11.55121664130378
Spreadsheet: 145822d1331754217-pivot-tables-combining-data-from-multiple-columns-excel-2003-combining-data_pt_jpr73
Sheet: Pivot

Count of Number |  |  |  | Classification 1 | Data | Total
Classification 1 | Classification 2 | Total |  | Type A | Count of Classification 1 | 2
Type A | Type B | 1 |  |  | Count of Classification 2 | 0
 | Type C | 1 |  |  | Total Type A | 2
Total Type A |  | 2 |  | Type B | Count of Classification 1 | 4
Type B | Type C | 2 |  |  | Count of Classification 2 | 1
 | Type D | 1 |  |  | Total Type B | 5
 | (vide) | 1 |  | Type C | Count of Classification 1 | 2
Total Type B |  | 4 |  |  | Count of Classification 2 | 3
Type C | (vide) | 2 |  |  | Total Type C | 5
Total Type C |  | 2 |  | Type D | Count of Classification 1 | 1
Type D | (vide) | 1 |  |  | Count of Classification 2 | 1
Total Type D |  | 1 |  |  | Total Type D | 2
Total général |  | 9 |  | Total Count of Classification 1 |  | 9
 |  |  |  | Total Count of Classification 2 |  | 5
Classification total |  | Total |  | Total Count |  | 14
Type A |  | 2
Type B |  | 5 |  |  | Classification 1+2
Type C |  | 5 |  |  | Type A | 2
Type D |  | 2 |  |  | Type B | 5
 |  |  |  |  | Type C | 5
 |  |  |  |  | Type D | 2
 |  |  |  |  | Total Count | 14
Spreadsheet: 161890d1339669354-creating-a-process-schedule-from-project-data-projectsdocument
Sheet: Sheet1

project 1 | process 1 | process 2 | process 3 | process 4 |  | process 1 schedule listed here | process 2 schedule listed here | process 3 schedule listed here | process 4 schedule listed here
project 2 | process 3
project 3 | process 2 | process 4
project 4 | process 1 | process 3 | process 4
project 5 | process 4 | process 2 | process 1
Spreadsheet: 739100d1625506604-macro-to-compare-references-and-values-and-extract-items-not-matching-to-a-seperate-sheet-macro-to-compare-ref-numbers-and-extract-items-that-do-not-match
Sheet: Manual Recon

Purchase.Reference | Purchase.Date Processed | Purchase.Balance
9285 | 03-MAY-2021 | 411.21
9290 | 03-MAY-2021 | 198.09
9305 | 03-MAY-2021 | 38.89
9320 | 04-MAY-2021 | 365.44
9321 | 05-MAY-2021 | 1046.95
9327 | 05-MAY-2021 | 910.47
9334 | 06-MAY-2021 | 150.53
9338 | 06-MAY-2021 | 1225.6
634985 | 03-MAY-2021 | 620.75
634654 | 03-MAY-2021 | 400.35
9285 | 03-MAY-2021 | 415.75
635080 | 06-MAY-2021 | 88.5
634958 | 03-MAY-2021 | 705.65
635146 | 03-MAY-2021 | 730.25
635196 | 06-MAY-2021 | 801.75
Spreadsheet: 47986d1247159237-top-5-scores-690553_softz
Sheet: Bowling Stats

Bowling Stats - New Zealand U19 Season 13 - Manager: Gumboot |  |  |  |  |  |  |  |  |  |  |  |  | Wicket Types
Player | Style | Overs | Balls | Runs | Wickets | 5fa | Maidens | No-Balls | Wides | Average | Srike Rate | Econ | LBW | Caught | Bowled | C & B | Hit Wicket | Stumping
[NAME] | RFM
[NAME] | LFM
[NAME] | RM
[NAME] | [NAME]
Conor [NAME] | [NAME]
[NAME] | RF
[NAME] May | LF
[NAME] | [NAME]
Lucas Marthinus | [NAME]
[NAME] | [NAME]
[NAME] | LFM
[NAME] | RFM
Totals
Most Balls bowled |  |  | Best Econ Rate |  |  |  | Most Wickets |  |  |  | Most Runs Conceded
Spreadsheet: daren_farmer__5316__Enron Nom Change
Sheet: Sheet1

To:   [NAME]          (Enron) |  |  |  |  |  | Phone: | (713) 853-9272
From:  Jan Svajian      ([NAME]) |  |  |  |  |  | FAX: | (713) 646-2391
Date:  6/20/00 |  |  |  |  |  | E-Mail: | [EMAIL]
Subject:  Nomination Change Effective June 21st
Effective Date | CTP NAME | Gross Vol. (MMBtu/d) | DBQ Available | Excess Available | First of the month original nomination |  | Pipeline affected
2000-06-21 00:00:00 | [NAME] | 1 | 1 |  | 105 |  | Tennessee
xc:  [NAME]
Phone: | [PHONE]
Fax: | [PHONE]
Spreadsheet: 0f5d1feb-673f-48ff-af58-740d1807e773
Sheet: 1.4

Table 1.4: Population etimates by age groups, nationality, residence and sex in Jordan,  2012
 | Nationals |  | Non- Nationals |  | Urban |  | Rural |  | Total
Age group | Male | Female | Male | Female | Male | Female | Male | Female | Male | Female | Both sexes
0-4 | ... | ... | ... | ... | ... | ... | ... | ... | 417805 | 396195 | 814000
5-9 | ... | ... | ... | ... | ... | ... | ... | ... | 412685 | 391970 | 804655
10-14 | ... | ... | ... | ... | ... | ... | ... | ... | 392565 | 371105 | 763670
15-19 | ... | ... | ... | ... | ... | ... | ... | ... | 360725 | 340000 | 700725
20-24 | ... | ... | ... | ... | ... | ... | ... | ... | 350580 | 325555 | 676135
25-29 | ... | ... | ... | ... | ... | ... | ... | ... | 300645 | 270435 | 571080
30-34 | ... | ... | ... | ... | ... | ... | ... | ... | 259775 | 239845 | 499620
35-39 | ... | ... | ... | ... | ... | ... | ... | ... | 210320 | 194500 | 404820
40-44 | ... | ... | ... | ... | ... | ... | ... | ... | 155410 | 146740 | 302150
45-49 | ... | ... | ... | ... | ... | ... | ... | ... | 109210 | 104140 | 213350
50-54 | ... | ... | ... | ... | ... | ... | ... | ... | 81010 | 79500 | 160510
55-59 | ... | ... | ... | ... | ... | ... | ... | ... | 69920 | 72420 | 142340
60-64 | ... | ... | ... | ... | ... | ... | ... | ... | 65305 | 58340 | 123645
65-69 | ... | ... | ... | ... | ... | ... | ... | ... | 47635 | 44355 | 91990
70-74 | ... | ... | ... | ... | ... | ... | ... | ... | 30140 | 29830 | 59970
75+ | ... | ... | ... | ... | ... | ... | ... | ... | 29270 | 30070 | 59340
Not stated | … | … | … | … | … | … | … | … | … | … | …
Total | ... | ... | ... | ... | ... | ... | ... | ...
Spreadsheet: 177965d1346571314-merge-duplicates-based-on-two-variables-merging-duplicates
Sheet: Sheet1

Model | Description | Price | Size | Color
1 | AAA | 10 | 0-14 | black |  |  |  | Sum of Price
1 | AAA | 10 | 0-14 | white |  |  |  | Description | Color | Size | Price | Total
2 | BBB | 11 | 0-14 | black |  |  |  | AAA | black | 0-14 | 10 | 10
2 | BBB | 12 | 16-24 | black |  |  |  |  | white | 0-14 | 10 | 10
3 | CCC | 12 | 0-14 | blue |  |  |  | BBB | black | 0-14 | 11 | 11
4 | DDD | 13 | 0-14 | yellow |  |  |  |  |  | 16-24 | 12 | 12
4 | DDD | 13 | 0-14 | green |  |  |  | CCC | blue | 0-14 | 12 | 12
4 | DDD | 13 | 0-14 | [NAME] |  |  |  | DDD | [NAME] | 0-14 | 13 | 13
4 | DDD | 17 | 16-24 | green |  |  |  |  |  | 16-24 | 17 | 17
4 | DDD | 17 | 16-24 | [NAME] |  |  |  |  | green | 0-14 | 13 | 13
 |  |  |  |  |  |  |  |  |  | 16-24 | 17 | 17
 |  |  |  |  |  |  |  |  | yellow | 0-14 | 13 | 13
 |  |  |  |  |  |  |  | Grand Total |  |  |  | 128
Spreadsheet: 210102d1359382027-data-validation-fromn-two-different-named-range-alternatives-dummy-for-help1
Sheet: Sheet 2

 | 2013 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | Total
 |  | II
 |  | JJ
 |  | KK
 |  | LL
 |  | MM
 |  | NN
 |  | OO
 |  | Total
Spreadsheet: 866500d1713432520-a-formula-to-select-the-highest-cell-in-a-column-that-then-shows-the-entire-row-walks
Sheet: Liam

 | # | Date | Name | Distance in        Miles | Total Elevation in Feet | Total Time HH:MM | Moving Time HH:MM | Stoped Time HH:MM | Avarage Speed MPH | Average Moving Speed MPH
 |  |  | 2017
 |  |  | 2018
 |  |  | 2019
 |  | 2019-02-17 00:00:00 | Chew Valley Lake - Blagdon Lake - Ubley - Compton Martin Circular | 8.4 | 1246 |  | 03:47:00 | 00:52:00
 |  | 2019-02-24 00:00:00 | Dolebury Warren - Mendip Lodge Woods | 6.1 | 1246 |  | 03:47:00 | 00:52:00
 |  | 2019-03-03 00:00:00 | Timsbury-Camerton-Circular | 11.3 | 1862 |  | 05:47:00 | 02:03:00
 |  | 2019-03-10 00:00:00 | Chepstow Castle Walk | 14.7 | 3340 |  | 07:41:00 | 01:30:00
 |  |  | 2020
 |  |  | 2021
 |  |  | 2022
Spreadsheet: 108327d1305346620-matrix-data-lookup-cost-matrix
Sheet: Sheet1

Qty | Same Day | 1-day | 2-day | 3-day | 4-day | 1-week | 2-week | 3-week | 4-week
10 | 138.26 | 124.93 | 71.61 | 58.27 | 50.28 | 47.61 | 42.28 | 36.94 | 20.029
50 | 33.28 | 30.05 | 17.13 | 13.9 | 11.97 | 11.32 | 10.03 | 8.74 | 7.45
100 | 25.07 | 22.61 | 12.78 | 10.32 | 8.85 | 8.36 | 7.38 | 6.39 | 5.41
200 | 16.93 | 15.26 | 8.59 | 6.92 | 5.92 | 5.59 | 4.92 | 4.25 | 3.58
Qty | Time | Cost
10 | 4-week
Spreadsheet: 806974d1669703659-distribution-of-data-base-on-dates-with-mutiple-duplicates-collection-vs-deposites-vladyexcelforum-file
Sheet: COLLECTION

POST DATE |  | DB LC
 |  | 10211.5
 |  | 23747
 |  | 10331.16
 |  | 19255
 |  | 5268.81
 |  | 30453
 |  | 9366.52
 |  | 32036.2
 |  | 4650
 |  | 14979
 |  | 5782.05
 |  | 13576
 |  | 5787
 |  | 9118
 |  | 5598.97
 |  | 18881
 |  | 12020
 |  | 5045.29
Spreadsheet: 96527d1295909791-time-window-parsing-assistance-testtimes
Sheet: Sheet1

Entry | Number | x | Start | End | Prime | x | x | Group | Entry2 | Start Date2 | Start Time2 | End Date2 | End Time2 | Entry | Start Date | Start Time | End Date | End Time
Test1 |  |  | 1101250600 | 1101260559 | 150 |  |  |  | Test1 | 110125 | 0600 | 110126 | 0559 | Test1
Test2 |  |  | 1101250600 | 1101250900 | 140 |  |  |  | Test2 | 110125 | 0600 | 110125 | 0900 | Test2
Test2 |  |  | 1101251100 | 1101260200 | 140 |  |  |  |  | 110125 | 1100 | 110126 | 0200
Test2 |  |  | 1101260300 | 1101260559 | 140 |  |  |  |  | 110126 | 0300 | 110126 | 0559
Test3 |  |  | 1101250600 | 1101251400 | 90 |  |  |  | Test3 | 110125 | 0600 | 110125 | 1400 | Test3
Test3 |  |  | 1101260000 | 1101260559 | 90 |  |  |  |  | 110126 | 0000 | 110126 | 0559
Test3 |  |  | 1101252300 | 1101260559 | 90 |  |  |  |  | 110125 | 2300 | 110126 | 0559
Original Data |  |  |  |  |  |  |  |  | This Section Splits the Date/Time from 1 cell format |  |  |  |  | Parsed Data
 |  |  | O2:S8 Expected Output
 |  |  | Test1 | 2011-01-25 00:00:00 | 06:00:00 | 2011-01-26 00:00:00 | 05:59:00
 |  |  | Test2 | 2011-01-25 00:00:00 | 06:00:00 | 2011-01-25 00:00:00 | 09:00:00
 |  |  |  | 2011-01-25 00:00:00 | 11:00:00 | 2011-01-26 00:00:00 | 02:00:00 |  | As you can see, data from row 7 is removed because the time window is during the time window in row 8.
 |  |  |  | 2011-01-26 00:00:00 | 03:00:00 | 2011-01-26 00:00:00 | 05:59:00
 |  |  | Test3 | 2011-01-25 00:00:00 | 06:00:00 | 2011-01-25 00:00:00 | 14:00:00
 |  |  |  | 2011-01-25 00:00:00 | 23:00:00 | 2011-01-26 00:00:00 | 05:59:00
 |  |  | Sum of Prime
 |  |  | Entry | Start Date2 | End Date2 | Total
 |  |  | Test1 | 110125 | 110126 | 150
 |  |  | Test2 | 110125 | 110125 | 140
 |  |  |  |  | 110126 | 140
 |  |  |  | 110126 | 110126 | 140
 |  |  | Test3 | 110125 | 110125 | 90
 |  |  |  |  | 110126 | 90
 |  |  |  | 110126 | 110126 | 90
 |  |  | Grand Total |  |  | 840