tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 721693d1614819593-look-up-dates-and-quanities-from-a-table-inventory-multiple-rec-dates
Sheet: Availability

 | RRD COB: |  |  |  |  |  |  |  |  |  |  |  | HIDE
 | Model # | Available | Next Arriving Qty | Next 'Arriving Qty' Date | -New Order- Next AVAILABLE Date | 2nd Arriving Qty | 2nd 'Arriving Qty' Date | 3rd Arriving Qty | 3rd 'Arriving Qty' Date |  |  |  | Next 'Arriving Qty' Date (System Date) | -New Order- Next AVAILABLE Date (System Date)
 | LD-DXL10 | 84 |  |  |  | 78 | 5/20/2021 | 50 | 7/20/2021
 | LD-DXL10QS | 92 |  |  |  | 120 | 3/18/2021 | 30 | 2021-04-08 00:00:00
 | LD-DXL10-KR19 | 16 |  |  |  |  | Date Not Available |  | Date Not Available
 | LD-DXL12QS | -109 |  |  |  | 20 | 2021-03-18 00:00:00 | 6 | 2021-04-08 00:00:00
 | LD-DXL14 | 32 |  |  |  | 32 | 2021-04-08 00:00:00 | 10 | 2021-05-20 00:00:00
 | LD-DXL14-KR19 | 4 |  |  |  | 29 | 2021-06-20 00:00:00 | 20 | 2021-07-20 00:00:00
 | LD-DXL16QS | 41 |  |  |  | 20 | 2021-05-20 00:00:00 |  | Date Not Available
 | LD-DXL18 | -14 |  |  |  | 5 | 2021-04-08 00:00:00 | 10 | 2021-04-20 00:00:00
 | LD-DXL18-KR19 | -50 |  |  |  | 4 | 2021-03-18 00:00:00 | 12 | 2021-04-20 00:00:00
 | LD-DXL22QS | 31 |  |  |  | 26 | 2021-06-20 00:00:00 | 12 | 2021-07-20 00:00:00
 | LD-DXL24 | 9 |  |  |  | 10 | 2021-05-20 00:00:00 | 40 | 2021-06-20 00:00:00
 | LD-DXL420 | -1 |  |  |  | 1 | 2021-07-20 00:00:00 |  | Date Not Available
 | LD-DXL428 | 4 |  |  |  | 12 | 2021-06-20 00:00:00 | 4 | 2021-07-20 00:00:00
 | LD-DXL436 | 0 |  |  |  |  | Date Not Available |  | Date Not Available
 | LD-DXL6 | -62 |  |  |  | 18 | 2021-03-17 00:00:00 | 90 | 2021-03-18 00:00:00
 | LD-DXL60-10QS | 57 |  |  |  | 12 | 2021-04-08 00:00:00 | 6 | 2021-04-14 00:00:00
 | LD-DXL60-10QS-KR19 | 8 |  |  |  |  | Date Not Available |  | Date Not Available
 | LD-DXL60-14QS | -43 |  |  |  | 60 | 2021-03-18 00:00:00 | 4 | 2021-04-08 00:00:00
 | LD-DXL60-14QS-KR19 | 9 |  |  |  | 10 | 2021-07-20 00:00:00 |  | Date Not Available
 | LD-DXL6QS | -116 |  |  |  | 48 | 2021-03-17 00:00:00 | 60 | 2021-03-08 00:00:00
 | LD-DXLI10 | 280 |  |  |  |  | Date Not Available |  | Date Not Available
 | LD-DXLI10QS | 84 |  |  |  | 2 | 2021-03-17 00:00:00 | 6 | 2021-03-18 00:00:00
 | LD-DXLI8 | 71 |  |  |  | 120 | 2021-04-20 00:00:00 | 90 | 2021-05-20 00:00:00
Spreadsheet: 0dba874b-c63f-48cf-9ffc-73da54a4b38d
Sheet: 3.1

Table 3.1: female headed households by country, residence and census year  (percentage of total housing units)
Country | Census/Survey | Year | Urban | Rural | Total
Egypt
 | Survey
Iraq
 | Census | 2009 | 8.9 | 4.5 | 7.7
 | Survey | 2007 | 3.8 | 1.8 | 3.3
 | Survey | 2011 | 3.4 | 2.3 | 2.9
Jordan
 | Survey | 2009 | 11.4 | 11.5 | 11.4
Lebanon
 | Survey | 2007 | … | … | 4.2
Libya
Morocco
 | Census | 2004 | 18.6 | 12.5 | 16.1
 | Projection | 2009 | 19.1 | 13.4 | 17
 | Projection | 2010 | 20.8 | 16.1 | 19.1
 | Survey | 2012 | 19.6 | 14.1 | 17.7
Oman
 | Census | 2010 | 6.78 | 6.86 | 6.8
 | Survey
Palestine
 | Survey | 1995 | 8.1 | 7 | 7.7
 | Survey | 2004 | 9.2 | 9.2 | 8.9
 | Census | 2007 | … | … | 8.8
 | Survey | 2010 | 9.6 | 9 | 9.6
 | Survey | 2012 |  |  | 9.4
Sudan
 | Survey | 1999 | … | … | 12
 | Survey | 2006 | … | … | 28
Syrian Arab Republic
 | Survey | 2001 | … | … | 9
 | Survey | 2005 | … | … | 8.3
 | Survey | 2009 | … | … | 10
United Arab Emirates
 | Census | 2005 | … | … | 11.8
Yemen
 | Census | 1994 | 6.8 | 6.7 | 6.7
 | Census | 2004 | … | … | 7.1
 | Survey | 2005-06 | 7.2 | 7.7 | 7.5
Spreadsheet: 143458d1330431183-subtotaling-based-on-product-descrption-sample
Sheet: 01 jan

Bin | Empty | Article | EAN | Description | Qty
71AU3515 |  | 90014349 | 17804421542800 | Agustinos Merlot Reserve 75cl | 13
71AU5241 |  | 90014350 | 17804421542817 | [NAME] | 6
71AU5251 | X | 90014411 | 17804421000379 | Agustinos Sauvignon Blanc Reserve | 8
71AU4635 |  | 90014412 | 17804421542794 | Agustinos Chardonnay Reserve | 1
71AU2615 | X | 90056523 | 16004786007131 | [NAME] The Shore Red
71AU5237 | X | 90056524 | 16004786007124 | [NAME] The Shore White
71AU6071 |  | 90063044 | 10892931000344 | A to Z Oregon Pinot Noir
71AU5235 |  | 90077237 | 8410702012317 | Analivia Sauvignon Blanc Verdejo Rueda
70AT4715 |  | 90079135 | 3479842075106 | [NAME] Low Alcohol Merlot
70AT5011 |  | 90079136 | 3479842074109 | [NAME] Low Alcohol Chard
Spreadsheet: 729464d1619103111-subtracting-extracted-numbers-from-a-string-test
Sheet: Sheet1

Data Type
[NAME] | String | [NAME]
Starting Gate | Removed Starting Gate | New Starting Gate | Comment
4 | 1,2,3 | 1 | All three gates are subtracted
4 | 3,7,8 | 3 | only 1 gate is subtracted
4 | 7,8,9 | 4 | 0 gates are subtracted
Spreadsheet: 869528d1716124205-empty-row-after-every-group-of-data-book1-gk-v2
Sheet: Sheet1

 |  | User Enter three columns
 |  | Region | Employee | Product |  |  |  | Employee | Pro-1 | Pro-2 | Pro-3 | Pro-4
 |  | REG-1 | Emp-1 | Pro-1 |  |  | REG-1 | Emp-1 | x
 |  | REG-1 | Emp-2 | Pro-2 |  |  | REG-1 | Emp-2 |  | x
 |  | REG-1 | Emp-3 | Pro-4 |  |  | REG-1 | Emp-3 |  |  |  | x
 |  | REG-1 | Emp-4 | Pro-2 |  |  | REG-1 | Emp-4 |  | x
 |  | REG-1 | Emp-5 | Pro-1 |  |  | REG-1 | Emp-5 | x
 |  | REG-1 | Emp-6 | Pro-2 |  |  | REG-1 | Emp-6 |  | x
 |  | [NAME] | Emp-1 | Pro-3 |  |  | REG-1 Total |  | 0.3333333333333333 | 0.5 | 0 | 0.1666666666666667
 |  | [NAME] | Emp-2 | Pro-2 |  |  | [NAME] | Emp-1 |  |  | x
 |  | [NAME] | Emp-3 | Pro-3 |  |  | [NAME] | Emp-2 |  | x
 |  | [NAME] | Emp-4 | Pro-2 |  |  | [NAME] | Emp-3 |  |  | x
 |  | REG-3 | Emp-1 | Pro-3 |  |  | [NAME] | Emp-4 |  | x
 |  | REG-3 | Emp-2 | Pro-2 |  |  | REG-3 | Emp-1 |  |  | x
 |  | REG-3 | Emp-3 | Pro-3 |  |  | REG-2 Total |  | 0 | 0.5 | 0.5 | 0
 |  | REG-3 | Emp-4 | Pro-2 |  |  | REG-3 | Emp-2 |  | x
 |  | REG-4 | Emp-1 | Pro-3 |  |  | REG-3 | Emp-3 |  |  | x
 |  | REG-4 | Emp-2 | Pro-1 |  |  | REG-3 | Emp-4 |  | x
 |  | REG-4 | Emp-3 | Pro-3 |  |  | REG-4 | Emp-1 |  |  | x
 |  | REG-4 | Emp-4 | Pro-2 |  |  | REG-3 Total |  | 0 | 0.5 | 0.5 | 0
 |  | REG-4 | Emp-5 | Pro-1 |  |  | REG-4 | Emp-2 | x
 |  | REG-4 | Emp-6 | Pro-3 |  |  | REG-4 | Emp-3 |  |  | x
 |  |  |  |  |  |  | REG-4 | Emp-4 |  | x
 |  |  |  |  |  |  | REG-4 | Emp-5 | x
 |  |  |  |  |  |  | REG-4 | Emp-6 |  |  | x
 |  |  |  |  |  |  | REG-4 Total |  | 0.3333333333333333 | 0.1666666666666667 | 0.5 | 0
 |  |  |  |  |  |  | Grand Total |  | 0.2 | 0.4 | 0.35 | 0.05
Spreadsheet: 7e07cc5b-cf1c-4396-ad65-6a3e1e7090ba
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
08/29/2014 | Women's Cross Country | Lehigh Invitational | 05:30 PM | First Place
09/13/2014 | Women's Cross Country | PSU Spiked Shoe Invitational | 10:00 AM | Fifth Place
10/04/2014 | Women's Cross Country | Greater Louisville Classic | 10:15 AM | Second Place
10/17/2014 | Women's Cross Country | Wisconsin Adidas Invitational | 12:00 PM | Fifth Place
11/01/2014 | Women's Cross Country | Big 12 Championships | 11:00 AM
11/14/2014 | Women's Cross Country | NCAA Mid-Atlantic Regional
11/22/2014 | Women's Cross Country | NCAA Cross Country Championships
Spreadsheet: 37070d1235024719-shifts-employees-timesheet-timesheet
Sheet: Sheet1

[NAME] Treatment Plant |  |  |  |  |  |  |  |  |  |  |  |  | No: 1
Name: Clive Appegaddo |  |  |  |  |  |  |  | For Office Use Only
DAY | DATE | In | Out | Initial | In | Out | Initial | Monday to Friday  @ 1 | Weekdays After 8hrs @1.5 | Saturday @1.5 | Saturday After 8hrs @ 2 | Sunday & Pulic Holidays @ 2 | Sunday & Pulic Holidays After 8hrs@ 3
Saturday | 2009-02-21 00:00:00
Sunday | 2009-02-22 00:00:00
Monday | 2009-02-23 00:00:00
Tuesday | 2009-02-24 00:00:00
Wednesday | 2009-02-25 00:00:00
Thursday | 2009-02-26 00:00:00
Friday | 2009-02-27 00:00:00
Saturday | 2009-02-28 00:00:00
Sunday | 2009-03-01 00:00:00
Monday | 2009-03-02 00:00:00
Tuesday | 2009-03-03 00:00:00
Wednesday | 2009-03-04 00:00:00
Thursday | 2009-03-05 00:00:00
Friday | 2009-03-06 00:00:00
Saturday | 2009-03-07 00:00:00
Sunday | 2009-03-08 00:00:00
Monday | 2009-03-09 00:00:00
Tuesday | 2009-03-10 00:00:00
Wednesday | 2009-03-11 00:00:00
Thursday | 2009-03-12 00:00:00
Friday | 2009-03-13 00:00:00
Saturday | 2009-03-14 00:00:00
Sunday | 2009-03-15 00:00:00
Monday | 2009-03-16 00:00:00
Tuesday | 2009-03-17 00:00:00
Wednesday | 2009-03-18 00:00:00
Thursday | 2009-03-19 00:00:00
Friday | 2009-03-20 00:00:00
Spreadsheet: 134692d1325589291-conditional-formatting-for-a-row-expense-record
Sheet: January

January
 |  | Purchase Types |  |  |  | Amex Ultimate Cards
 |  |  |  |  |  | Citibank Cards
 |  |  |  |  |  | WOW Cards
 |  |  |  |  |  | ANZ Cards
*Do not add more than 10 rows - affects SUMPRODUCT!
Date | Gross Amt | Surcharge | Final Amt | Purchase Type | From Account | Retailer/Receipient | Location | Share Amount | Office | Account | Description
2012-01-01 00:00:00 | 7 |  |  | WOW MasterCard |  | 7-Eleven | [NAME] |  | SYD | FG
2012-01-02 00:00:00 | 231.43 |  |  | Amex Ultimate |  | [NAME] | Online | 231.43 | ADL
2012-01-02 00:00:00 | 160.81 |  |  | Amex Ultimate |  | Telstra Mobile | Online | 160.81 | ADL
2012-01-02 00:00:00 | 93.62 |  |  | Amex Ultimate |  | Woolworths | Melbourne | 93.62 | PER
2012-01-03 00:00:00 | 88.61 |  |  | Amex Ultimate |  | Optus | Phone |  | SYD | CM
 |  |  |  | Monthly Summary
 |  |  |  | Purchase Accounts | Spend | Expense Accounts | Spend | Net Position | Value
 |  |  |  | Credit Provided |  | Total Monthly Expenses |  | Current Position
 |  |  |  |  |  |  |  | Starting Balance
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
Spreadsheet: 826384d1681980525-sumifs-in-a-2-dimensional-array-with-2-column-conditions-mini-sample-sheet
Sheet: Project 2

Name / Week: | 1 |  |  |  |  | 2
user | aa | bb | cc | dd | ee | aa | bb | cc | dd | ee
task 1 | 3 | 9 | 7 | 8 | 4 | 3 | 9 | 3 | 9 | 7
task 2 | 3 | 67 | 9 | 5 | 9 | 8 | 36 | 4 | 8 | 8
sum
Spreadsheet: 87632d1287512884-generating-combinations-of-text-enumerate-all-combinations
Sheet: Enumeration

Values in each category:
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
3 | 4 | 2 | 5 | 2 | 3 | 4 | 3
Total combinations: |  | 8640
Combinations:
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 2
1 | 1 | 1 | 1 | 1 | 1 | 1 | 3 | <--- Copy this row and fill down to row 8,647!!
Spreadsheet: fe8c32e5-b563-4ffb-a3b2-4c32843bdb6f
Sheet: Sheet1

Campus | Last Name | First Name | [NAME] | Phone Number | Fax Number | Street | Street2 | City | State | Zip
Appalachian State University | Bates | Cathy | [EMAIL] | [PHONE] |  | Information Technology Services | Raley Hall | Boone | NC | 28608
East Carolina University | Sweet | [NAME] | [EMAIL] | [PHONE] | [PHONE] | East Fifth Street |  | Greenville | NC | 27858
Elizabeth City State University | Adade | [NAME] | [EMAIL] | [PHONE] | [PHONE] | Office of Information Technology | 227 Information Technology Center | Elizabeth City | NC | 27909
Fayetteville State University | Ganesan | Nick | [EMAIL] | [PHONE] | [PHONE] | 1200 Murchison Road |  | Fayetteville | NC | 28301
NC Agricultural and Technical State University | Ellis | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1601 East Market Street |  | Greensboro | NC | 27411
North Carolina Central University | Smith | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1801 Fayetteville Street |  | [NAME] | NC | 27707
NC State University | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | For Information Technology | Holladay Hall 9, Box 7015 | Raleigh | NC | 27695-7109
UNC Asheville | [NAME] | [NAME] | [EMAIL] | [PHONE] |  | 1 University Heights |  | Asheville | NC | 28804
UNC-Chapel Hill | Kielt | [NAME] | [EMAIL] | [PHONE] | [PHONE] |  |  | Chapel Hill | NC | 27599
UNC Charlotte | Cato | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 9201 University City Boulevard |  | Charlotte | NC | 28223
UNC Greensboro | Clotfelter | [NAME] | [EMAIL] | [PHONE] | [PHONE] | POB 26170 |  | Greensboro | NC | 27402-6170
UNC Pembroke | [NAME] | [NAME] | [EMAIL] | [PHONE] |  | 1 University Drive |  | Pembroke | NC | 28372
[NAME] | Kraus | Leah | [EMAIL] | [PHONE] |  | 601 South College Road |  | [NAME] | NC | 28403
UNC School of the Arts | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1533 South Main Street |  | Winston-Salem | NC | 27127
Western Carolina University | Fowler | [NAME] | [EMAIL] | [PHONE] | [PHONE] |  |  | Cullowhee | NC | 28723
Winston-Salem State University | McKenzie | Justin | [EMAIL] | [PHONE] | [PHONE] |  |  | Winston-Salem | NC | 27110
North Carolina School of Science and Mathematics | Alston | [NAME] | [EMAIL] | [PHONE] |  | 1219 Broad Street |  | [NAME] | NC | 27705
Spreadsheet: 72415d1273091103-isblank-statement-returning-multiple-strings-body_index_calc
Sheet: data

4 | 0.25
5 | 0.5
6 | 0.75
7 | 1
 | 1.25
 | 1.5
 | 1.75
 | 2
 | 2.25
 | 2.5
 | 2.75
 | 3
 | 3.25
 | 3.5
 | 3.75
 | 4
 | 4.25
 | 4.5
 | 4.75
 | 5
 | 5.25
 | 5.5
 | 5.75
 | 6
 | 6.25
 | 6.5
 | 6.75
 | 7
 | 7.25
 | 7.5
 | 7.75
 | 8
 | 8.25
 | 8.5
 | 8.75
 | 9
 | 9.25
 | 9.5
 | 9.75
 | 10
 | 10.25
 | 10.5
 | 10.75
 | 11
 | 11.25
 | 11.5
 | 11.75
Spreadsheet: 689377d1596357997-capped-discount-formula-help-eat-out-to-help-out-records-and-sales
Sheet: Sheet1

 |  |  |  |  |  | 0.5
 |  |  |  | 3rd August 20
 | Item No. | Description | Price | [NAME] | Total | Claim
 | 1 | [NAME] | 25 | 1
 | 2 | Assort. Sandwiches, [NAME], [NAME] | 8.95
 | 3 | Olives, Sundried Toms & Sourdough | 6.95
 | 4 | [NAME] and [NAME] | 8.95
 | 5 | Pate, [NAME] and Sourdough | 8.95
 | 6 | Soup of the day | 6.95
 | 7 | Pizza: Mozz & Tom | 13.95
 | 8 | Pizza: [NAME] | 14.95
 | 9 | Pizza: Four Cheese | 13.95
 | 10 | Cheese Board | 13
 | 11 | Caesar Salad | 9.95
 | 12 | Caesar Salad (chick or salmon) | 16.9
 | 13 | Prawn / Quorn & Mango Salad | 11.95
 | 14 | [NAME] and Feta Salad | 10.95
 | 15 | Lamb Shank | 14.95
 | 16 | Featherblade | 16.95
 | 17 | Salmon | 14.95
 | 18 | [NAME] | 12.95
 | 19 | Conwy Burger | 11.95
 | 20 | Aromatic Burger | 10.95
 | 21 | [NAME] | 7.95
 | 22 | [NAME] | 11.95
 | 23 | [NAME] | 3.95
 | 24 | [NAME] | 4.95
 | 25 | Vegetables | 6.95
 | 26 | Fries | 3.95
 | 27 | Onion Rings | 3.95
 | 28 | Halloumi Fries | 7.95
 | 29 | Garden Salad | 4.95
 | 30 | Chock [NAME] | 7.95
 | 31 | [NAME] | 6.95
 | 32 | Apple Crumble | 6.95
 | 33 | Ice Cream | 6.95
 | 34 | [NAME] | 2.7
 | 35 | Frobishers juice; Apple, Orange. | 3.5
 | 36 | Coca Cola/Diet Coke | 2.5
 | 37 | Lemonade | 2.5
 | 38 | Fever Tree Tonic | 2.75
 | 39 | Tea / Coffee | 3
Spreadsheet: 20edd15b-427e-4887-87ac-d527ff52b0da
Sheet: Exhibit XV, Page 1

Owners Forms
USAA Group
Pennsylvania
Rate Change History
Effective Date | Percent Effect | Dollar Effect (nearest thousand) |  | Description of Changes
2007-02-01 00:00:00 | -0.04 | -2047000 |  | Expand the Homeowners Pricing Program from 5 levels
 |  |  |  | to 7 levels, implement new territory boundaries and
 |  |  |  | relativities, revise endorsment costs and unity premiums.
2008-03-01 00:00:00 | -0.097 | -4921000 |  | Revise Price Level Factors for Owners and Unit-Owners
 |  |  |  | forms, New Home Discount credits & caps for Owners
 |  |  |  | forms, and Base Rates for Owners & Unit-Owners forms.
NB*: November 30, 2009 | 0.091 | 4467000 |  | Introduce HO2008 program for Owners and Unit-Owners,
RB**: January 30, 2010 |  |  |  | Introduce Renewal Rate Capping.
NB*: August 14, 2010 | -0.001 | -77000 |  | Introduce the use of Military Status in Pricing Level calculation
RB**: November 1, 2010 |  |  |  | for USAA-GIC.
2011-01-30 00:00:00 | 0 | 0 |  | Introduce new limit options for Coverage B.
2011-08-15 00:00:00 | 0.073 | 4514000 |  | Introduce additionally rated catastrophic perils.
 |  |  |  | Introduce a new rating structure for the Earthquake Endorsement.
2012-08-15 00:00:00 | 0.162 | 11064000 |  | Introduce new territory boundaries.
* "NB" = "New Business"
** "RB" = "Renewal Business"
Spreadsheet: 753789d1635762683-count-days-upto-7-start-again-and-add-week-forum
Sheet: Sheet1

Date | Data | Days | Weeks
2021-05-08 00:00:00 | BF0120 | 1 | 1
2021-05-09 00:00:00 | BF0120 | 2 | 1
2021-05-10 00:00:00 | BF0120 | 3 | 1
2021-05-11 00:00:00 | BF0120 | 4 | 1
2021-05-12 00:00:00 | BF0120 | 5 | 1
2021-05-13 00:00:00 | BF0120 | 6 | 1
2021-05-14 00:00:00 | BF0120 | 7 | 1
2021-05-15 00:00:00 | BF0120 | 1 | 2
2021-05-16 00:00:00 | BF0120 | 2 | 2
2021-05-17 00:00:00 | BF0120 | 3 | 2
2021-05-18 00:00:00 | BF0120 | 4 | 2
2021-06-01 00:00:00 | BF0120 | 5 | 2
2021-06-02 00:00:00 | BF0120 | 6 | 2
2021-06-03 00:00:00 | BF0120 | 7 | 2
2021-06-04 00:00:00 | BF0120 | 1 | 3
2021-06-05 00:00:00 | BF0120 | 2 | 3
2021-06-06 00:00:00 | BF0120 | 3 | 3
2021-06-07 00:00:00 | BF0120 | 4 | 3
2021-06-08 00:00:00 | BF0120 | 5 | 3
2021-06-09 00:00:00 | BF0120 | 6 | 3
2021-06-10 00:00:00 | BF0120 | 7 | 3
2021-06-11 00:00:00 | BF0120 | 1 | 4
2021-06-12 00:00:00 | BF0120 | 2 | 4
2021-06-13 00:00:00 | BF0120 | 3 | 4
Spreadsheet: 833929d1687346992-count-data-in-different-columns-hazards-raised-by-aligw
Sheet: Sheet1

Shift | Name | [NAME] |  |  | [NAME] | People Raising
B | [NAME] |  |  | A
B | [NAME] | 8 |  | B
Eng | [NAME] |  |  | C
A | [NAME] | 1 |  | Eng
Eng | Pav | 6 |  | WE
Eng | [NAME]
B | [NAME] | 3
A | [NAME] | 2 |  |  | =SUMIF(A2:A16,E2,C2:C16) | ???
A | [NAME] |  |  |  |  | This is a manual input, can a formual do it for me?
WE | [NAME] | 1
Eng | [NAME] | 3
A | [NAME]
B | [NAME] | 5
C | [NAME] | 4
C | Jake
Spreadsheet: 99832ae9-4251-4822-887c-4396e3dd77e4
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
AMT | Test | AMT | Amitriptyline and [NAME], Serum | Amitriptyline and Nortriptyline, S | High-Performance Liquid Chromatography (HPLC) | Plain, Red-Top Tube: Red |  |  | 3 | mL | Container/Tube: Red top [NAME]: 3 mL Collection Instructions: 1. Draw specimen immediately before next scheduled dose (minimum 12 hours after last dose). 2. Serum must be separated from cells within 2 hours of draw. | 1.1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK  Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | AMITRIPTYLINE AND NORTRIPTYLINE Total therapeutic concentration: 80-200 ng/mL Total toxic concentration: > or =300 ng/mL   NORTRIPTYLINE ONLY Therapeutic concentration: 70-170 ng/mL Toxic concentration: > or =300 ng/mL Note: Therapeutic ranges are for specimens drawn at trough (ie, immediately before next scheduled dose). Levels may be elevated in non-trough specimens. | Monday through Friday; Varies | 2 days | 4 days |  | Profile |  |  |  |  | Rochester
AMT | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
AMT | Result | 8125 | Amitriptyline | Amitriptyline | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 3333-2
AMT | Result | 2450 | Nortriptyline | Nortriptyline | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 3872-9
AMT | Result | 2451 | Amitriptyline and Nortriptyline | Amitriptyline and Nortriptyline | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 3335-7
AMT | Billing Component | AMT |  | Nortriptyline |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 80182
AMT | Billing Component | AMT |  | Amitriptyline |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 80152
Spreadsheet: 674925d1588080511-sort-table-with-smallest-to-largest-value-with-small-and-duplicate-sorting-values-fp_sortwithformula-copy
Sheet: Sheet1

What I have |  |  | What I want |  |  | What Excel gives me
Name | Height |  | Order by Height | Names |  | Order by Height | Names
[NAME] | 187 |  |  | [NAME]
[NAME] | 180 |  |  | [NAME]
[NAME] | 180 |  |  | [NAME]
[NAME] | 185 |  |  | [NAME]
Spreadsheet: 829408d1684202976-power-query-custom-column-populating-using-worksheet-names-pq-append
Sheet: OHIO

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
OHIO
Customer # | Time & Purchase Date | Name | Gender | DOB | Units | Price per Unit ($) | Total Price ($)
1 | 1945|25 Aug 2021 | [NAME] | Male | 32275 | 50 | 1 | 50
2 | 2135|27 July 2012 | [NAME] | Male | 36293 | 79.0357142857143 | 1.05 | 30.08
3 | 1318|4 May 2001 | Coren Malibi | Female | 33743 | 78.7857142857143 | 1.02 | 35.839
4 | 2336|22 Mar 2003 | [NAME] | Male | 32275 | 78.5357142857143 | 1.07 | 41.598
5 | 1707|27 Nov 2012 | [NAME] | Male | 36293 | 78.2857142857143 | 0.95 | 47.357
6 | 1923|2 Oct 2017 | [NAME] | Male | 23876 | 103 | 0.98 | 53.116
7 | 2152|10 Sep 2016 | [NAME] | Male | 36661 | 61 | 0.951 | 58.875
8 | 1532|12 Oct 2004 | Jackson Reed | Female | 33743 | 66 | 0.93 | 59.4
9 | 2256|15 Jan 2014 | [NAME] | Male | 32275 | 71 | 1.11 | 78.81
10 | 1951|11 Feb 2009 | [NAME] | Male | 36293 | 75 | 1.01 | 75.75
11 | 1504|18 Feb 2016 | Jackson Reed | Male | 23876 | 80 | 0.98 | 78.4
12 | 1330|24 Oct 2019 | [NAME] | Male | 36661 | 85 | 1.04 | 88.4
13 | 1137|6 Nov 2013 | [NAME] | Male | 32644 | 90 | 1.02 | 91.8
Spreadsheet: 137106d1326963059-conditional-formatting-not-working-after-adding-new-formulas-within-the-worksheet-example
Sheet: JAN 2

Code/Key
F
H
T
S
C
Number
 |  | [NAME] By | ALL "F" Taken | All "S" Taken | All "T" Taken | All "c" Taken | 2012-01-30 00:00:00
 |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 |  | Days | 4 | 2 | 1 | 2 |  | S
 |  | Days | 6 | 0 | 0 | 0 |  |  |  |  |  |  |  | F | F
 |  | Days | 2 | 0 | 3 | 2 |  | T |  | F |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F
 |  | Days | 6 | 0 | 0 | 1 |  |  |  | F |  |  |  |  |  |  |  |  | F |  |  |  |  |  |  |  |  |  |  |  |  |  | F
 |  | Days | 4 | 0 | 0 | 0 |  |  |  | F |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  | F
 |  | Days | 10 | 0 | 0 | 0 |  |  |  | F | F | F |  |  |  | H
 |  | Days | 3 | 1 | 0 | 0 |  |  |  | F | F |  |  |  |  |  |  |  |  |  |  | F
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F | F | F |  |  |  | H
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F
Spreadsheet: 148979d1333637830-how-can-i-pull-data-from-one-tab-to-another-if-a-date-is-entered-into-a-certain-field-candidate-tracker
Sheet: Concessions-Non Conformance

Candidate | Job Title | Date [NAME] | Sent to | Status | Int. Requested | Int. Date | Offer Date | Start date | Notes |  |  |  |  |  |  |  | CV sent week | Interview Week | Offer Week | Start Week
Candidate D | Stress Engineer | 2012-04-05 00:00:00 | Mark A | OfferAccept | Yes | 2012-04-06 00:00:00 | 2012-04-07 00:00:00 | 2012-04-10 00:00:00
Spreadsheet: 8dfbd712-76eb-4cb4-840a-eaab8ba4755b
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44028024 | 2014-11-15 06:53:53 | AXIS | 1 | 7 | 4 | 270299 | 3FingerJimbo | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
44028260 | 2014-11-15 07:27:28 | ALLIES | 1 | 7 | 6 | 270299 | 3FingerJimbo | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
44028602 | 2014-11-15 08:03:38 | AXIS | 0 | 4 | 5 | 1007284 | Temple58 | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
44028766 | 2014-11-15 08:26:42 | AXIS | 0 | 5 | 6 | 1351059 | [NAME] | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
44142827 | 2014-11-23 06:18:11 | AXIS | 0 | 6 | 10 | 1168783 | domphocas | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44155866 | 2014-11-24 01:16:17 | ALLIES | 1 | 6 | 4 | 1085732 | player1085732 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]