tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 951164d7-979c-4fa2-a5b0-c611b7659412
Sheet: Table 10

Table 10
[NAME] (1,000 tons)
Week ending 3/01/2014 | Corn | Wheat | Soybeans | Other | Total
Mississippi River
Rock Island, IL (L15) | 0 | 0 | 0 | 0
Winfield, MO (L25) | 0 | 0 | 0 | 0
Alton, IL (L26) |  |  |  | 0
Granite City, IL (L27)
Illinois River (L8) |  |  |  | 0
Ohio River (L52) |  |  |  |  |  | n/a
Arkansas River (L1)
Weekly total - 2014
Weekly total - 2013
2014 YTD1
2013 YTD
2014 as % of 2013 YTD
Last 4 weeks as % of 20132
Total 2013
1 Weekly total, YTD (year-to-date) and calendar year total includes Miss/27, [NAME], and Ark/1; "Other" refers to oats, barley, sorghum, and rye.
2 As a percent of same period in 2013.
Note:  Total may not add exactly, due to rounding
Source:  U.S. Army Corps of Engineers
Spreadsheet: benjamin_rogers__1171__Gleason - 501F & 501FD
Sheet: Interest During Construction

IDC Calculations
CARRYING COST OF TURBINES, TRANSFORMERS AND CIRCUIT BREAKERS
Total Cost Drawdown |  | 138356
Base Rate
Term (Months) |  | 19
Monthly Rate
Financing Fee (Annual) |  | 0.0035
Drawdown Schedule |  | 1
0=Straightline, 1=Custom
Calculated IDC
Month | Percent [NAME] | Principal | Cummulative [NAME] ([NAME]. Int.) | Monthly Interest | Cumulative Interest
0 |  | 29376.55 |  | 704.264
1 |  | 43750.4 |  | 320.324
 |  | 3115.05 |  | 477.324
 |  | 0
 |  | 3159.99
 |  | 3502.908
 |  | 3523.68
 |  | 119.75
 |  | 5299.682
 |  | 3449.683
 |  | 1489.683
 |  | 3043.308
 |  | 4369.573
 |  | 5571.35
 |  | 5231.349
 |  | 4840.511
 |  | 4429.762
 |  | 4129.762
 |  | 4164.997
 |  | 9920.817
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
Spreadsheet: 334b52db-02d2-451b-8038-abe7cbbc3d08
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
 | 6345.0 Labour Price Index, Australia
 | Hourly Rates of Pay Including Bonuses: Sector, Original (Financial Year Index Numbers for year ended June quarter)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Financial Year Index ;  Ordinary time hourly rates of pay including bonuses ;  Australia ;  All industries ;  Private ;  All occupations ; |  |  | Original | A2247506V | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Ordinary time hourly rates of pay including bonuses ;  Australia ;  All industries ;  Public ;  All occupations ; |  |  | Original | A2247516X | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Ordinary time hourly rates of pay including bonuses ;  Australia ;  All industries ;  Private and Public ;  All occupations ; |  |  | Original | A2247527F | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay including bonuses ;  Australia ;  All industries ;  Private ;  All occupations ; |  |  | Original | A2248874T | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay including bonuses ;  Australia ;  All industries ;  Public ;  All occupations ; |  |  | Original | A2248884W | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay including bonuses ;  Australia ;  All industries ;  Private and Public ;  All occupations ; |  |  | Original | A2248895C | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
© Commonwealth of Australia  2009
Spreadsheet: 777935d1650685056-how-to-change-cell-name-based-on-another-cell-and-place-data-on-correct-row-sample-workbook-kittybat-
Sheet: DUMMY

Input Dept Code | dept | code | lookup |  |  | Epic Department | code | lookup
CLINIC1 [10402254] |  |  |  |  |  | CLINIC 1 OP | 10402254
CLINIC2 [10402304] |  |  |  |  |  | CLINIC 3 OP | 10402165
CLINIC3 [10402165] |  |  |  |  |  | CLINIC 2 OP | 10402304
CLINIC4 [10402522] |  |  |  |  |  | CLINIC 4 OP | 10402522
CLINIC5 [10402274] |  |  |  |  |  | CLINIC 7 OP | 10402498
CLINIC6 [10402305] |  |  |  |  |  | CLINIC 5 OP | 10402274
Spreadsheet: 862965d1710517678-calendar-formulas-and-conditional-formatting-annual-calendar
Sheet: October

 |  |  |  |  |  |  |  |  | OCT
 | NOTES
 | Blackout dates
Spreadsheet: 775634d1649237439-how-to-delete-multiple-entries-to-leave-unique-values-only-sample1
Sheet: Sheet1

VIN | MODEL | NewUsed | Volume | Occurrences
LSJA24U98MN215907 | HS | 0 | -1
LSJA24U92MN167630 | HS | 0 | -1
LSJA24U93MN162954 | HS | 0 | -1
LSJA24U9XMN137369 | HS | 0 | -1
LSJA24U92MN220908 | HS | 0 | -1
LSJA24U91MN201833 | HS | 0 | -1
LSJA24U95MN218361 | HS | 0 | -1
LSJA24U9XMN168007 | HS | 0 | -1
LSJA24U94MN224068 | HS | 0 | -1
[NAME] | HS | 0 | -1
LSJA24U93MN164493 | HS | 0 | -1
LSJA24U98MN162559 | HS | 0 | -1
LSJA24U95MN162065 | HS | 0 | -1
LSJA24U91MN198920 | HS | 0 | -1
LSJA24U93MN220027 | HS | 0 | -1
LSJA24U90MN224245 | HS | 0 | -1
LSJA24U9XMN162577 | HS | 0 | -1
LSJA24U97MN213386 | HS | 0 | -1
LSJA24U9XMN166497 | HS | 0 | -1
LSJA24U90MN220471 | HS | 0 | -1
LSJA24U97MN161189 | HS | 0 | -1
LSJA24U90MN161406 | HS | 0 | -1
LSJA24U98MN215907 | HS | 0 | 1
LSJA24U92MN167630 | HS | 0 | 1
LSJA24U98MN215907 | HS | 0 | 1
LSJA24U92MN167630 | HS | 0 | 1
LSJA24U9XMN168007 | HS | 0 | 1
LSJA24U94MN224068 | HS | 0 | 1
[NAME] | HS | 0 | 1
LSJA24U93MN164493 | HS | 0 | 1
LSJA24U98MN162559 | HS | 0 | 1
LSJA24U95MN162065 | HS | 0 | 1
Spreadsheet: 712733d1610387000-bulding-a-schedule-trolleyscheduleforef
Sheet: Details

Timepoints | Travel Time | [NAME] | Column1 | Frequency
Eastbound
Terminal A | - | - |  | 0:15:00
Stop 1 | 0:06:00 | 1 |  | 0:30:00
Stop 2 | 0:05:00 | 0.75 |  | 0:45:00
Stop 3 | 0:20:00 | 2 |  | 1:00:00
Terminal B | 0:11:00 | 1.25
Total
Westbound
Terminal B | - | -
Stop 3 | 0:11:00 | 1.25
Stop 2 | 0:20:00 | 2
Stop 1 | 0:05:00 | 0.75
Terminal A | 0:06:00 | 1
Total
Round-trip
Depot to A/Reverse | 0:05:00 | 0.75
Depot to B/Reverse | 0:15:00 | 1.5
Spreadsheet: 689525d1596478926-offset-troubles-cash-forecast-sample
Sheet: Cons Weekly F'Cast

 | Week begins | 2020-08-03 00:00:00
 | year.month
 | year.week
 | AR
 | [NAME]
 | APT
 | APNT Vendor
 | APNT Expenses
 | [NAME]
 | [NAME]
 | [NAME]
 | IP Net Pay
 | IP Tax
 | IP Social
 | IP Other
 | Tax VAT
 | Tax CT
 | Tax Other
 | CoSec/Legal
 | [NAME]
 | Other
Spreadsheet: 730457d1619706839-formula-to-use-named-ranges-my-excel-nested-and-date-functions
Sheet: Salaries

Name | Position | Hire Date | Salary | Days | Years | Tenure
Blair Rieves | Administrator | 2017-02-12 00:00:00 | 112658
Corazon Fluker | Administrator | 2002-03-02 00:00:00 | 175252
Cristal Dople | Administrator | 2015-05-19 00:00:00 | 150254
[NAME] | Administrator | 2016-05-01 00:00:00 | 90852
Bea Joly | Staff | 2015-05-19 00:00:00 | 28658
[NAME] | Staff | 1992-04-11 00:00:00 | 30225
[NAME] | Staff | 2016-08-01 00:00:00 | 22665
[NAME] | Staff | 1992-06-11 00:00:00 | 22956
[NAME] | Staff | 2014-05-18 00:00:00 | 24865
[NAME] | Staff | 2017-05-12 00:00:00 | 19453
[NAME] | Teacher | 2014-05-18 00:00:00 | 73932
[NAME] | Teacher | 1997-02-22 00:00:00 | 54430
[NAME] | Teacher | 1992-03-01 00:00:00 | 70893
[NAME] | Teacher | 1996-03-22 00:00:00 | 53767
[NAME] | Teacher | 2008-05-16 00:00:00 | 47688
Ferne Ewert | Teacher | 2015-05-19 00:00:00 | 54761
[NAME] | Teacher | 2017-05-12 00:00:00 | 33159
[NAME] | Teacher | 2016-05-01 00:00:00 | 33822
[NAME] | Teacher | 1992-04-11 00:00:00 | 54872
[NAME] | Teacher | 1994-03-01 00:00:00 | 53214
[NAME] | Teacher | 2001-12-16 00:00:00 | 50672
[NAME] | Teacher | 2000-05-01 00:00:00 | 54761
Spreadsheet: john_arnold__15152__Enron Wholesale UNIX - Storage
Sheet: Enron ecom

 |  |  |  |  |  |  | Product Order Form:  Open System Products |  |  |  |  | Product Order Form #
6
 |  |  |  |  | SUPPORT |  | DESIGNATED CPU |  | PRODUCT | LICENSE FEE
 | SLA # | ITEM# | QUANTITY | PRODUCT DESCRIPTION | B=BASE | TIER | MACHINE TYPE & | MANUFACTURE | EFFECTIVE | UNIT COST | TOTAL COST | INSTALLATION LOCATION
 |  |  |  |  | E=EXTENDED |  | MODEL | # | DATE
 | 5839 | 1 | 99 | Patrol Storage Resource Manager for Unix | E | Ent 1 |  | Sun | 2001-03-30 00:00:00 | 8550
 |  | 2 | 201 | Patrol Storage Resource Manager for Unix | E | Dept |  | Sun | 2001-03-30 00:00:00 | 3375
 |  | 3 | 1 | Patrol SRM Console ( 1-5 seats) | E | N/A |  |  | 2001-03-30 00:00:00 | 5100
 |  | 4 | 5 | Patrol for Symmetrix | E | N/A |  |  | 2001-03-30 00:00:00 | 8575
 |  |  |  |  |  |  |  |  |  | Total | 1572800
 |  |  |  |  |  |  |  |  |  | Discount
 |  |  |  |  |  |  |  |  |  | Maintenance
 |  |  | 20 | Profressional Services |  |  |  |  | estimate | 2000
 |  | ACCEPTED BY LICENSOR: BMC Software Distribution, Inc.
 |  |  |  |  |  |  | ACCEPTED BY [NAME]: Company Name
 |  | By: |  |  |  |  | By:
 |  | Name: |  |  |  |  | Name:
 |  | Title: |  |  |  |  | Title:
 |  | Date: |  |  |  |  | Date:
Spreadsheet: 06b7426d-b82d-44fe-9135-8b2e7fb21ace
Sheet:  Alternating Block Worksheet

 | Return to Index Page
 | Period | Minutes
 | 1A
 | 1B
 | 2A
 | 2B
 | 3A
 | 3B
 | 4A
 | 4B
 | OJT | 60
 | Seminar
 | Course | Number | Period | Class
Approved Class Name | Code | Teacher | Period | Enrolled | Minutes | Total | Notes
 |  |  |  |  | TOTAL MINUTES
 |  |  |  |  | TOTAL HOURS
 | Return to Top
Spreadsheet: 135634d1326145520-index-match-vlookup-automatic-example-of-index-match-vlookup
Sheet: Transfer

 |  | Cumulative for Early
 | November
 |  | Gross Revenue |  |  | ???automatic linking?Index?Match?Vlookup
 |  | Service Revenue |  |  | ???
 |  | SRM |  |  | ???
 |  | EBIT |  |  | ?????
 | YTD
 |  | Gross Revenue |  |  | ??
 |  | Service Revenue |  |  | ??
 |  | SRM |  |  | ??
 |  | EBIT |  |  | ??
Spreadsheet: 159626d1338789201-how-to-look-up-two-values-then-display-an-output-independent_datavalidation_vlookup
Sheet: Lists

Brand | Model | Color | Price |  | Samsung |  |  | Sony
Samsung | SamsungModel | SamsungColor | SamsungPrice |  | Model | Price | Color | Model | Price | Color
Sony | SonyModel | SonyColor | SonyPrice |  | [NAME] | 450 | White | Xperia S | 400 | White
 |  |  |  |  | Galaxy S3 | 500 | [NAME] | Xperia P | 380 | Black
 |  |  |  |  |  |  | Black |  |  | Pink
 |  |  |  |  |  |  |  |  |  | Green
 |  |  |  |  | Remarks:
 |  |  |  |  | The price of [NAME] is $450, [NAME] is $500.
 |  |  |  |  | The price of Xperia S is $400, Xperia P is $380.
 |  |  |  |  | The colors can be chosen for [NAME] and Galaxy S3 are White, Dark Blue and Black.
 |  |  |  |  | The colors can be chosen for Xperia S and Xperia P are White, Black, Pink, Green.
Spreadsheet: 769833d1645705903-planned-vs-actual-weeks-behind-or-ahead-calculation-planned-vs-actual-week-status_-final-formula
Sheet: Sheet2

Date | Planned Week | Actual Week | [NAME]. | Actual Cum. | Position (week)
2022-01-02 00:00:00 | 0 | 0
2022-01-09 00:00:00 | 14 | 7
2022-01-16 00:00:00 | 14 | 14
2022-01-23 00:00:00 | 14 | 7
2022-01-30 00:00:00 | 21 | 7
2022-02-06 00:00:00 | 21 | 21
2022-02-13 00:00:00 | 14 | 21
2022-02-20 00:00:00 | 14 | 21
2022-02-27 00:00:00 | 7 | 21
2022-03-06 00:00:00 | 7 | 21
2022-03-13 00:00:00 | 14 | 21
2022-03-20 00:00:00 | 14 | 7
2022-03-27 00:00:00 | 14 | 7
2022-04-03 00:00:00 | 14 | 7
2022-04-10 00:00:00 | 14 | 7
2022-04-17 00:00:00 | 21 | 7
2022-04-24 00:00:00 | 21 | 7
2022-05-01 00:00:00 | 7 | 7
2022-05-08 00:00:00 | 7 | 7
2022-05-15 00:00:00 | 14 | 7
2022-05-22 00:00:00 | 14 | 7
Spreadsheet: 748289d1632043526-find-a-value-in-a-table-and-return-a-value-from-the-left-column-form
Sheet: form

№ | First name, Surname, Family |  |  | Age groups | Result /sec./ |  | Evaluation | Male or female | male=0 female=1
1 |  |  |  |  | 17.1 |  | <= 17,4 Excellent
2 |  |  |  |  | 17.5 |  | >17,5 or =17,9 Average
3 |  |  |  |  | 19.1 |  | >=18,8 Poor
Spreadsheet: 845264d1696797184-find-and-extract-text-from-a-longer-text-in-cell-to-the-left-atrades
Sheet: Sheet1

This is the raw data | this is what I want:
Live WD 2closedGLD Iron Condorfor$26win. | 26
12:56pm
Live WD 2closedDIA Iron Condorfor-$546loss. | -546
11:38am
Live WDclosedV Iron Condorfor-$352loss. | -352
11:34am
Live WD 2closedHD Iron Condorfor$756win. | 756
11:12am | etc
Live WD 2closedIWM Iron Condorfor$301win.
10:11am
Live WD 2closedHD Iron Condorfor-$370loss.
10:10am
Live WDclosedJPM Short Put Spreadfor$342win.
9:58am
Live WD 2closedROKU Iron Condorfor$374win.
9:55am
THURSDAY
Live WD 2openedGLD Iron Condorfor$34credit.
3:14pm
Live WD 2openedSQ Short Put Spreadfor$418credit.
Spreadsheet: 86419d1286395930-drop-down-list-starting-from-middle-subdvlistfromlargerdvlist
Sheet: Example

 |  |  |  |  |  | Category | Items |  | Categories | Select Category First
 | Category | Type |  |  |  | Fruits | Apples |  | Fruits
 |  | Select Category First |  |  |  | Fruits | Bananas |  | Office.Supplies
 |  |  |  |  |  | Fruits | Oranges |  | Vegetables
 |  |  |  |  |  | Fruits | Pears
 |  |  |  |  |  | Office.Supplies | Paper
 |  |  |  |  |  | Office.Supplies | Pens
 |  |  |  |  |  | Office.Supplies | Pencils
 |  |  |  |  |  | Office.Supplies | Notebooks
 |  |  |  |  |  | Vegetables | Onions
 |  |  |  |  |  | Vegetables | Potatoes
 |  |  |  |  |  | Vegetables | Lettuce
 |  |  |  |  |  | Vegetables | Spinace
Spreadsheet: 725026d1616505028-autosum-drag-down-column-at-fixed-intervals-in-data-example
Sheet: SUMMARY

S.NO. | TOWER/SHOP/FLAT | MONTHLY RENT | TOTAL RENT RECEIVABLE | RENT PAID | LAST MONTH |  | MONTH DUE | AMOUNT
1 | Tenant 1 | 40000
2 | [NAME] | 35000
3 | Tenant 3
4 | [NAME]
5 | Tenant 5
6 | Tenant 6
Spreadsheet: 56423d1256630670-re-arrange-data-moving-rows-at-once-questn
Sheet: Output

3099 | 905 | AUST 4WD CUST ACT | NO.14 | Full Copies | 6.7839 | 2
3200 | 906 | AUST HOUSE & GARDEN | 2009-06-09 00:00:00 | Covers Only | 4.7385 | 1
3167 | 906 | AUST PERSONAL COMPUTER | 2009-06-09 00:00:00 | Covers Only | 6.7839 | 3
2929 | 924 | AUTO ACTION | #1344 | Covers Only | 3.8181 | 3
5356 | 901 | BEAUT BEADED BAGS | # 1 | Full Copies | 10.1929 | 3
5950 | 901 | BETTER PHOTOGRAPHY | #55 | Full Copies | 8.8293 | 3
60009 | 905 | BLISS | 2009-04-09 00:00:00 | Covers Only | 4.0567 | 1
6454 | 911 | CARRY ON DVD NAT | NO 32 | Full Copies | 13.6019 | 1
7127 | 911 | CL WAR MOVIES NAT | NO 30 | Full Copies | 13.6019 | 1
5210 | 902 | COSMOPOLITAN PREGNANCY | WINT09 | Full Copies | 9.2043 | 3
5714 | 905 | CRDMKNG STMPNG&PPRCRFT | V14#11 | Full Copies | 6.7839 | 3
7663 | 911 | DORA DOLL NAT | NO 24 | Full Copies | 5.4203 | 1
1876 | 924 | ECONOMIST THE | 2009-06-13 00:00:00 | Covers Only | 7.1589 | 4
1942 | 923 | ENG WOMANS WEEKLY | 2009-06-16 00:00:00 | Covers Only | 2.2499 | 1
5919 | 906 | FAST FOURS | 2009-06-09 00:00:00 | Full Copies | 6.7839 | 2
Spreadsheet: 149180d1333733505-excel-2003-how-do-i-copy-contents-of-cells-identified-by-sumproduct-sample
Sheet: Sheet1

[NAME] | 206 | 4270535 | E | Shop 3 | Actor | M
Morgan Freeman | 848 | 6340846 | D | Shop 3 | Actor | M
[NAME] | 524 | 3360104 | C | Shop 4 | Actor | M
[NAME] | 495 | 1360174 | E | Shop 18 | Actress | F
[NAME] | 393 | 6290718 | A | Shop 17 | Actor | M
[NAME] | 7 | 9310900 | C | Shop 15 | Actor | M
[NAME] | 292 | 3300847 | E | Shop 12 | Actor | M
[NAME] | 785 | 1340585 | D | Shop 9 | Actor | M
[NAME] | 141 | 5330821 | D | Shop 9 | Actress | F
[NAME] | 882 | 8370261 | N | Shop 4 | Actor | M
[NAME] | 925 | 5340473 | N | Shop 20 | Actor | M
[NAME] | 80 | 6280709 | D | Shop 17 | Actor | M
[NAME] | 44 | 1260972 | N | Shop 7 | Actress | F
[NAME] | 888 | 7320988 | D | Shop 6 | Actor | M
[NAME] | 130 | 7360936 | N | Shop 20 | Actor | M
[NAME] | 563 | 3350079 | N | Shop 3 | Actor | M
[NAME] | 638 | 1350374 | N | Shop 19 | Actor | M
[NAME] | 275 | 8270387 | A | Shop 2 | Actress | F
[NAME] | 231 | 5320752 | A | Shop 7 | Actor | M
[NAME] | 377 | 4330832 | C | Shop 1 | Actor | M
Spreadsheet: 113880d1309773909-allocate-values-to-specific-rows-excel_forum_example
Sheet: Sheet1

species | sample 1 | sample2 |  |  |  |  |  |  |  |  | sample 1 raw
Acetivibrio | #N/A |  |  |  |  |  |  |  |  |  | Acinetobacter | 10
Acetobacter | #N/A |  |  |  |  |  |  |  |  |  | Altererythrobacter | 1
Acetobacterium | #N/A |  |  |  |  |  |  |  |  |  | Amaricoccus | 1
Achromobacter | #N/A |  |  |  |  |  |  |  |  |  | Aquabacterium | 1
Acidisphaera | #N/A |  |  |  |  |  |  |  |  |  | Arcobacter | 1
Acidocella | #N/A |  |  |  |  |  |  |  |  |  | Bacteriovorax | 1
Acidomonas | #N/A |  |  |  |  |  |  |  |  |  | Bacteroides | 1
Acidothermus | #N/A |  |  |  |  |  |  |  |  |  | Balneola | 1
Acidovorax | #N/A |  |  |  |  |  |  |  |  |  | Bizionia | 2
Acinetobacter | 10 |  |  |  |  |  |  |  |  |  | [NAME] | 1
Actinomadura | 10 |  |  |  |  |  |  |  |  |  | Bordetella | 1
Actinoplanes | 10 |  |  |  |  |  |  |  |  |  | Brumimicrobium | 40
Actinospica | 10 |  |  |  |  |  |  |  |  |  | Campylobacter | 4
Actinotalea | 10 |  |  |  |  |  |  |  |  |  | Cellulophaga | 1
[NAME] | 10 |  |  |  |  |  |  |  |  |  | Chitinophaga | 1
Aequorivita | 10 |  |  |  |  |  |  |  |  |  | Chryseobacterium | 1
Aeromicrobium | 10 |  |  |  |  |  |  |  |  |  | Crocinitomix | 1
Aeromonas | 10 |  |  |  |  |  |  |  |  |  | Cryomorpha | 1
Afipia | 10 |  |  |  |  |  |  |  |  |  | Cupriavidus | 1
Agreia | 10 |  |  |  |  |  |  |  |  |  | Cyclobacterium | 3
[NAME] | 10 |  |  |  |  |  |  |  |  |  | Donghicola | 1
Ahrensia | 10 |  |  |  |  |  |  |  |  |  | Enterobacter | 1
[NAME] | 10 |  |  |  |  |  |  |  |  |  | Flavobacterium | 8
Albimonas | 10 |  |  |  |  |  |  |  |  |  | Flexibacter | 20
Algoriphagus | 10 |  |  |  |  |  |  |  |  |  | Gemella | 1
Alkalibacterium | 10 |  |  |  |  |  |  |  |  |  | Gemmatimonas | 1
Alkaliflexus | 10 |  |  |  |  |  |  |  |  |  | Geobacter | 40
Alkalilimnicola | 10 |  |  |  |  |  |  |  |  |  | Gillisia | 323
Altererythrobacter | 1 |  |  |  |  |  |  |  |  |  | Glaciecola | 1
Alteromonas | 1 |  |  |  |  |  |  |  |  |  | GpI | 1
Amaricoccus | 1 |  |  |  |  |  |  |  |  |  | Gracilimonas | 559
Aminobacter | 1 |  |  |  |  |  |  |  |  |  | Gramella | 333
Anaerobacter | 1 |  |  |  |  |  |  |  |  |  | Haliea | 1
Anaerophaga | 1 |  |  |  |  |  |  |  |  |  | Haliscomenobacter | 68
Anaerovorax | 1 |  |  |  |  |  |  |  |  |  | [NAME] | 1
etc.
Spreadsheet: 102386d1300325875-vlookup-problem-for-employees-with-same-shift-example-of-pull-from-schedule
Sheet: goal sheet

2011-01-02 00:00:00 | <-enter date
[NAME] | 10-5
angie | 10-3
mark | 12-8
[NAME] | 12-8
robby | 3-8
 | [NAME] | filtered | sort order | Rank | no blanks |  | sorted times
[NAME]
[NAME]
[NAME]
Mark
[NAME]
robby
angie
becky
micky
[NAME]
 |  | shift | sort order |  |  |  |  | 1 | 10-7 |  | =VLOOKUP(ROW()-ROW($E$5),$B$6:$C$15,2,FALSE)
 |  | 9-11 | 1 |  |  |  |  | 2 | 10-4 |  | 10-6
 |  | 9-6 | 2 |  |  |  |  | 3 | 10-3
 |  | 9-5 | 3 |  |  |  |  | 4 | 11-7
 |  | 9-4 | 4 |  |  |  |  | 5 | Paris Hilton |  | 1030-630
 |  | 9-11/2-8 | 5 |  |  |  |  | 6 | Ratan Tata |  | 1030-330
 |  | 9-11/3-8 | 6 |  |  |  |  | 7 | [NAME]
 |  | 10-7 | 7 |  |  |  |  | 8 | [NAME]
 |  | 10-6 | 8 |  |  |  |  | 9 | [NAME]
 |  | 10-5 | 9 |  |  |  |  | 10 | [NAME]
 |  | 10-4 | 10
 |  | 10-3 | 11
 |  | 1030-630 | 12
 |  | 1030-530 | 13
 |  | 1030-430 | 14
 |  | 1030-330 | 15
 |  | 11-7 | 16
 |  | 11-6 | 17
 |  | 11-5 | 18
 |  | 11-4 | 19
 |  | 11-3 | 20
 |  | 12-8 | 21
 |  | 12-7 | 22
 |  | 12-6 | 23
 |  | 12-5 | 24
 |  | 12-4 | 25
 |  | 1-8 | 26
 |  | 1-7 | 27
 |  | 1-6 | 28
 |  | 1-5 | 29
 |  | 1-10 | 30
 |  | 2-8 | 31
 |  | 2-7 | 32
 |  | 2-6 | 33
 |  | 2-11 | 34
 |  | 3-8 | 35
 |  | 3-9 | 36
 |  | 3-10 | 37
 |  | 3-11 | 38
 |  | 3-12 | 39
Spreadsheet: 50469d1249925740-excel-2007-dependant-lists-and-lookups-fnalgpicker
Sheet: CB

Name | Club | Price
J [NAME] | ARS | 4.4
[NAME] | ARS | 4.5
M Silvestre | ARS | 4.5
T Vermaelen | ARS | 4.6
C Cuellar | AV | 3.7
C Davies | AV | 3.8
S Dann | BIR | 3.3
G Espinoza | BIR | 3.3
R [NAME] | BIR | 3.4
L Ridgewell | BIR | 3.5
M Taylor | BIR | 3.2
Z Khizanishvili | BLA | 3.4
R Nelsen | BLA | 3.6
C Samba | BLA | 3.8
G Cahill | BOL | 3.7
Z Knight | BOL | 3.6
A [NAME] | BOL | 3.5
D Shittu | BOL | 3.5
S Caldwell | BUR | 3.3
C Carlisle | BUR | 3.3
D Edgar | BUR | 3.3
[NAME] | CHE | 5.2
R Carvalho | CHE | 5.1
B [NAME] | CHE | 5
M Mancienne | CHE | 4.7
J Terry | CHE | 5.5
P Jagielka | EVE | 4.3
J Lescott | EVE | 4.6
J [NAME] | EVE | 4.2
C [NAME] | FUL | 3.6
B [NAME] | FUL | 3.9
A Hughes | FUL | 3.8
A Gardner | HUL | 3.3
S Mouyokolo | HUL | 3.3
M Turner | HUL | 3.4
[NAME] | HUL | 3.4
D Agger | LIV | 5.1
J Carragher | LIV | 5.4
M Skrtel | LIV | 5.1
T [NAME] | MC | 3.7
[NAME] | MC | 3.9
N Onuoha | MC | 3.8
K Toure | MC | 4.6
J Evans | MU | 5
R Ferdinand | MU | 5.3
N Vidic | MU | 5.7
S Campbell | POR | 3.6
S [NAME] | POR | 3.7
Y Kaboul | POR | 3.6
L Cort | STO | 3.3
A Faye | STO | 3.4
R Shawcross | STO | 3.5
I Sonko | STO | 3.3
R Anderson | SUN | 3.3
[NAME] | SUN | 3.4
A Ferdinand | SUN | 3.5
P McShane | SUN | 3.4
[NAME] | TOT | 3.8
M Dawson | TOT | 3.8
L King | TOT | 3.8
J Woodgate | TOT | 3.9
J [NAME] | WH | 3.6
C Davenport | WH | 3.5
D Gabbidon | WH | 3.5
J Tomkins | WH | 3.7
M Upson | WH | 3.8
E Boyce | WIG | 3.7
T Bramble | WIG | 3.8
P Scharner | WIG | 3.7
C [NAME] | WOL | 3.3
N Collins | WOL | 3.2
J Craddock | WOL | 3.2
D Ward | WOL | 3.2
R Zubar | WOL | 3.4
Spreadsheet: 774738d1648642200-date-contional-formating-date-format
Sheet: Sheet1

 |  |  |  |  |  |  |  | What I need |  |  | Use of conditional format
 |  |  |  |  |  |  |  | Delivery Date | Required by Date |  | Delivery Date | Required by Date
 |  |  |  |  |  |  |  | 2020-03-10 00:00:00 | 2020-03-06 00:00:00 |  | 2020-03-10 00:00:00 | 2020-03-06 00:00:00
 |  |  |  |  |  |  |  | 2020-03-05 00:00:00 | 2020-03-06 00:00:00 |  | 2020-03-05 00:00:00 | 2020-03-06 00:00:00
 |  |  |  |  |  |  |  | 2022-08-25 00:00:00 | 2022-10-26 00:00:00 |  | 2022-08-25 00:00:00 | 2022-10-26 00:00:00
 |  |  |  |  |  |  |  | 2023-05-16 00:00:00 | 2022-05-15 00:00:00 |  | 2023-05-16 00:00:00 | 2022-05-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  | What I want
 |  |  |  |  |  |  |  |  |  |  | Delivery Date | Required by Date
 |  |  |  |  |  |  |  |  |  |  | 2020-03-10 00:00:00 | 2020-03-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2020-03-05 00:00:00 | 2020-03-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2022-08-25 00:00:00 | 2022-10-26 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2023-05-16 00:00:00 | 2022-05-15 00:00:00
Spreadsheet: 699588d1602673789-automatically-update-one-sheet-from-multiple-sheets-direct-lead-tracker
Sheet: Sheet1

DV |  | Limited |  | Organic | Whitegates
Gemma |  | Medium |  | Web | Ewemove
Mark |  | High |  | Inbound telephone | Ellis & Co
Will |  |  |  | Marketing | Parkers
 |  |  |  | EA Masters | Martin & Co
 |  |  |  | Partner Network
 |  |  |  | Guild
 |  |  |  | Fine & Country
 |  |  |  | Jackson Stops
 |  |  |  | TPFG
 |  |  |  | ICG
 |  |  |  | IAMP Cross Sell