tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 26107d1218017080-comparing-two-worksheet-data-test1
Sheet: Data2

Date | Position | URL | Profiles | [NAME]
2008-08-02 00:00:00 | Logout | logout_bengali_l_partner_comm_640x480 | 4 | 73120304
2008-08-02 00:00:00 | HP | hp_gujarati-1.2crore_640x480_may08 | 2 | 73100260
2008-08-02 00:00:00 | Logout | logout_bengali-1.2crore_640x480_may08 | 3 | 73120242
2008-08-02 00:00:00 | Logout | logout_City_640x480_june_08 | 131 | 73120281
2008-08-02 00:00:00 | HP | hp_hindi_l_partner_comm_640x480_june0 | 8 | 73100323
2008-08-02 00:00:00 | HP | hp_hindi-1.2crore_640x480_may08 | 18 | 73100261
2008-08-02 00:00:00 | Logout | logout_gujarati_l_partner_comm_640x48 | 2 | 73120305
2008-08-02 00:00:00 | HP | hp_kannada_l_partner_comm_640x480_jun | 2 | 73100324
2008-08-02 00:00:00 | Logout | logout_gujarati-1.2crore_640x480_may08 | 4 | 73120243
2008-08-02 00:00:00 | HP | hp_kannada-1.2crore_640x480_may08 | 7 | 73100262
2008-08-02 00:00:00 | Logout | logout_hindi_l_partner_comm_640x480_j | 25 | 73120306
2008-08-02 00:00:00 | Logout | logout_hindi-1.2crore_640x480_may08 | 39 | 73120244
2008-08-02 00:00:00 | HP | hp_kerala_l_partner_comm_640x480_june | 2 | 73100325
2008-08-02 00:00:00 | Logout | logout_kannada_l_partner_comm_640x480 | 2 | 73120307
2008-08-02 00:00:00 | HP | hp_l_partner_comm_640x480_june08 | 44 | 73100320
2008-08-02 00:00:00 | HP | hp_marathi_l_partner_comm_640x480_jun | 24 | 73100326
2008-08-02 00:00:00 | HP | hp_marathi-1.2crore_640x480_may08 | 27 | 73100264
2008-08-03 00:00:00 | Logout | logout_City_640x480_june_08 | 7 | 73120281
2008-08-02 00:00:00 | HP | hp_punjabi-1.2crore_640x480_may08 | 3 | 73100265
2008-08-02 00:00:00 | HP | hp_Sorry_Boss_640x480_July_08 | 29 | 73100410
2008-08-02 00:00:00 | Logout | logout_kannada-1.2crore_640x480_may08 | 9 | 73120245
2008-08-02 00:00:00 | Logout | logout_kerala_l_partner_comm_640x480_ | 1 | 73120308
2008-08-02 00:00:00 | Logout | logout_malayalam-1.2crore_640x480_may08 | 2 | 73120246
2008-08-02 00:00:00 | Logout | logout_marathi_l_partner_comm_640x480 | 24 | 73120309
2008-08-02 00:00:00 | HP | hp_tamil_l_partner_comm_640x480_june0 | 10 | 73100328
2008-08-02 00:00:00 | Logout | logout_marathi-1.2crore_640x480_may08 | 34 | 73120247
2008-08-02 00:00:00 | HP | hp_tamil-1.2crore_640x480_may08 | 8 | 73100266
2008-08-02 00:00:00 | HP | hp_telugu_l_partner_comm_640x480_june | 6 | 73100329
2008-08-02 00:00:00 | HP | hp_telugu-1.2crore_640x480_may08 | 5 | 73100267
2008-08-02 00:00:00 | Logout | logout_punjabi_l_partner_comm_640x480 | 1 | 73120310
2008-08-02 00:00:00 | Logout | logout_punjabi-1.2crore_640x480_may08 | 1 | 73120248
2008-08-02 00:00:00 | Logout | logout_tamil_l_partner_comm_640x480_j | 18 | 73120311
2008-08-02 00:00:00 | Logout | logout_tamil-1.2crore_640x480_may08 | 18 | 73120249
2008-08-02 00:00:00 | Logout | logout_telugu_l_partner_comm_640x480_ | 5 | 73120312
2008-08-02 00:00:00 | Logout | logout_telugu-1.2crore_640x480_may08 | 4 | 73120250
2008-08-03 00:00:00 | Logout | logout_hindi-1.2crore_640x480_may08 | 1 | 73120244
2008-08-03 00:00:00 | Logout | logout_marathi_l_partner_comm_640x480 | 1 | 73120309
Spreadsheet: 0f6c850d-1ebb-4629-b287-09ce38ef1c44
Sheet: SY 14-15 Price Calculator

 | SY 2014-15 Price Adjustment Calculator
 | Go to Instructions |  | SY 2014-15 Weighted Average Price Requirement
 |  |  | Requirement price to the nearest cent | Optional price requirement ROUNDED DOWN to nearest 5 cent
 |  |  | Note:  Above prices are based on adjusting  SY 2013-2014 price requirement by the 2% rate increase plus the Consumer Price Index (2.27%)
 | SY 2013-14 Weighted Average Price Calculator
 | Enter the paid prices and number of paid lunches sold at each price for  October 2013.
 | Monthly # of Paid Lunches | Paid Lunch Price | Monthly Revenue | SY 2013-14 Weighted Average Price
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
TOTAL
 | Note:  SY 2013-14 Weighted Average Price equal to or above $2.65 are compliant for SY 2014-15. $2.65 is the difference between the Free and Paid reimbursement rates for SY 2013-14.
 |  |  | Total Price Increase for SY 2014-15
 |  |  | Required price for SY 2014-15  (with 10 cent cap)
 |  |  | Remaining increase carried forward to SY 2015-16
 |  |  | Remaining credit carried forward to SY 2015-16
Go to SY2014-2015 Report
 | Step 3 (Optional)
Pricing Estimation Calculator
Below is a tool allowing users to manipulate prices to achieve the required new weighted average price.
 | Monthly # of Paid Lunches | Paid Lunch Price | Monthly Revenue | Weighted Average Price
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
TOTAL
Note:  This tool is created to allow the user to only enter the number of paid lunches and the related prices.  If any other parts of the tool are modified, the user runs the risk of calculating an incorrect new average price.  [NAME] should not modify the tool's current functionality.
Spreadsheet: 702305d1604263742-pivoting-data-into-one-line-from-a-long-list-of-data-help-sample-data
Sheet: Sheet1

SKU | Instructions | Parts Diagrams | Material Safety Data Sheet | Web Main Picture | Web Image 1 | Web Image 2 | Web Image 3
10000ES | [NAME] | [NAME] 20190726 (3)_DFC0242267.pdf | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
1000E | [NAME] | [NAME] Parts Diagram 20190806 (3)_DFC0246658.pdf | [NAME] | [NAME]
1000ETJ | [NAME] | [NAME] 20191009 (3)_DFC0279116.pdf | [NAME] | [NAME] | [NAME] | [NAME]
1000TR | [NAME] 20190801 (3)_DFC0244170.pdf | [NAME] (3)_DFC0281983.pdf | [NAME] | [NAME] | [NAME]
SKU | File Path | File Type | File Type
10000ES | [NAME] | Instructions | Instructions
10000ES | [NAME] | Web Image | Web Image 1
10000ES | [NAME] 20190726 (3)_DFC0242267.pdf | Parts Diagrams | Parts Diagrams
10000ES | [NAME] | Web Main Picture | Web Main Picture
10000ES | [NAME] | Material Safety Data Sheet | Material Safety Data Sheet
10000ES | [NAME] | Web Image | Web Image 2
10000ES | [NAME] | Web Image | Web Image 3
1000E | [NAME] | Web Main Picture | Web Main Picture
1000E | [NAME] Parts Diagram 20190806 (3)_DFC0246658.pdf | Parts Diagrams | Parts Diagrams
1000E | [NAME] | Instructions | Instructions
1000E | [NAME] | Material Safety Data Sheet | Material Safety Data Sheet
1000ETJ | [NAME] | Instructions | Instructions
1000ETJ | [NAME] | Web Main Picture | Web Main Picture
1000ETJ | [NAME] 20191009 (3)_DFC0279116.pdf | Parts Diagrams | Parts Diagrams
1000ETJ | [NAME] | Material Safety Data Sheet | Material Safety Data Sheet
1000ETJ | [NAME] | Web Image | Web Image 1
1000ETJ | [NAME] | Web Image | Web Image 2
1000TR | [NAME] | Material Safety Data Sheet | Material Safety Data Sheet
1000TR | [NAME] 20190801 (3)_DFC0244170.pdf | Instructions | Instructions
1000TR | [NAME] (3)_DFC0281983.pdf | Parts Diagrams | Parts Diagrams
1000TR | [NAME] | Web Main Picture | Web Main Picture
1000TR | [NAME] | Web Image | Web Image 1
Spreadsheet: 725568d1616752298-dynamic-drop-down-list-with-multiple-criteria-inventory
Sheet: Sale

[NAME] | Dato | Butik |  | Antal | Stk. [NAME] | Beløb til fakturering | Bogføringsdato
 | 2021-03-25 00:00:00
Spreadsheet: 42012d1240550869-creating-a-countdown-timer-on-excel-safe
Sheet: Sheet1

I Left Home | 2009-03-26 00:00:00 | 1
I Leave Here | 2010-03-26 00:00:00
Total Days | 365
Done
4.193240790344134 | Weeks
29.35268553240894 | Days
704.4644527778146 | Hours
42267.86716666888 | Minutes
2536072.030000133 | Seconds
0.08041831652714779 | Percent
To Go
47.94961635251301 | Weeks
335.6473144675911 | Days
8055.535547222185 | Hours
483332.1328333311 | Minutes
28999927.96999987 | Seconds
Spreadsheet: 155341d1336763356-populate-columns-in-one-sheet-based-off-of-a-few-lists-in-a-different-sheet-autopopulatecolumns-jd-5-11
Sheet: Setup

Metric | Included? |  |  |  |  |  |  |  |  | Metric | Countries | Question/Response Mapping |  |  |  |  | Questions | Countries | Sort | [NAME]
 | No |  |  |  |  |  |  |  |  |  | Brazil | Q1_4 | 2
 | No |  |  |  |  |  |  |  |  |  | India | Q1_4 | 3
 | No |  |  |  |  |  |  |  |  |  | Germany | Q1_4 | 4
 | No |  |  |  |  |  |  |  |  |  | China | Q1_4 | 5
 | No |  |  |  |  |  |  |  |  |  | France | Q1_4 | 6
 | No |  |  |  |  |  |  |  |  |  | Japan | Q1_4 | 7
 | No |  |  |  |  |  |  |  |  |  | USA | Q1_4 | 8
 | No |  |  |  |  |  |  |  |  |  | UK | Q1_4 | 9
 | No |  |  |  |  |  |  |  |  |  |  | Q1_4 | 10
 | Yes |  |  |  |  |  |  |  |  |  |  | Q1_4 | 12
 | Yes |  |  |  |  |  |  |  |  |  |  | Q1_3 | 1
 | Yes |  |  |  |  |  |  |  |  |  |  | Q1_3 | 2
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | No
Spreadsheet: 741871d1627392942-formula-to-count-and-return-a-certain-message-if-possible-fragmented-stock-dummy-doc
Sheet: Sheet1

SKU | Display Name | RRP | Stock | Stock Position
BLKWHT3 | Matrix Boots White | 55 | 4 | Fragmented Stock
BLKWHT4 | Matrix Boots White | 55 | 4
BLKWHT5 | Matrix Boots White | 55 | 0
BLKWHT6 | Matrix Boots White | 55 | 0
BLKWHT7 | Matrix Boots White | 55 | 9
BLKWHT8 | Matrix Boots White | 55 | 7
BLKYLW3 | Matrix Boots Yellow | 55 | 2 | Fragmented Stock
BLKYLW4 | Matrix Boots Yellow | 55 | 2
BLKYLW5 | Matrix Boots Yellow | 55 | 2
BLKYLW6 | Matrix Boots Yellow | 55 | 2
[NAME] | Matrix Boots Yellow | 55 | 0
BLKYLW8 | Matrix Boots Yellow | 55 | 0
WIN3 | [NAME] | 40 | 1 | Stocked
[NAME] | [NAME] | 40 | 4
WIN5 | [NAME] | 40 | 8
WIN6 | [NAME] | 40 | 9
WIN7 | [NAME] | 40 | 6
WIN8 | [NAME] | 40 | 8
BLKYLW3 | Griffin Boots Black | 40 | 0 | Fragmented Stock
BLKYLW4 | Griffin Boots Black | 40 | 0
BLKYLW5 | Griffin Boots Black | 40 | 9
BLKYLW6 | Griffin Boots Black | 40 | 1
[NAME] | Griffin Boots Black | 40 | 0
BLKYLW8 | Griffin Boots Black | 40 | 0
ALIGRN3 | Alien Boots Green | 55 | 0 | Fragmented Stock
ALIGRN4 | Alien Boots Green | 55 | 1
[NAME] | Alien Boots Green | 55 | 0
ALIGRN6 | Alien Boots Green | 55 | 9
ALIGRN7 | Alien Boots Green | 55 | 0
ALIGRN8 | Alien Boots Green | 55 | 1
RC3BLU3 | MAGE Trainers Blue | 30 | 2 | Stocked
RC3BLU4 | MAGE Trainers Blue | 30 | 3
RC3BLU5 | MAGE Trainers Blue | 30 | 9
RC3BLU6 | MAGE Trainers Blue | 30 | 8
RC3BLU7 | MAGE Trainers Blue | 30 | 7
RC3BLU8 | MAGE Trainers Blue | 30 | 1
ARCYLW3 | MAGE Trainers Yellow | 30 | 9 | Stocked
ARCYLW4 | MAGE Trainers Yellow | 30 | 8
ARCYLW5 | MAGE Trainers Yellow | 30 | 5
ARCYLW6 | MAGE Trainers Yellow | 30 | 6
ARCYLW7 | MAGE Trainers Yellow | 30 | 0
ARCYLW8 | MAGE Trainers Yellow | 30 | 1
BLKBLKMESH3 | KNIGHT Trainers Black | 40 | 6 | Stocked
BLKBLKMESH4 | KNIGHT Trainers Black | 40 | 8
BLKBLKMESH5 | KNIGHT Trainers Black | 40 | 9
BLKBLKMESH6 | KNIGHT Trainers Black | 40 | 0
BLKBLKMESH7 | KNIGHT Trainers Black | 40 | 1
BLKBLKMESH8 | KNIGHT Trainers Black | 40 | 4
[NAME] | KNIGHT Trainers Red | 40 | 0 | Fragmented Stock
BURGMFBURGMESH4 | KNIGHT Trainers Red | 40 | 0
BURGMFBURGMESH5 | KNIGHT Trainers Red | 40 | 0
BURGMFBURGMESH6 | KNIGHT Trainers Red | 40 | 0
BURGMFBURGMESH7 | KNIGHT Trainers Red | 40 | 1
BURGMFBURGMESH8 | KNIGHT Trainers Red | 40 | 0
8BLKPU-UK9 | Chunky Sandals | 35 | 3 | Stocked
8BLKPU-UK10 | Chunky Sandals | 35 | 5
8BLKPU-UK11 | Chunky Sandals | 35 | 6
8BLKPU-UK12 | Chunky Sandals | 35 | 9
8BLKPU-UK13 | Chunky Sandals | 35 | 8
8BLKPU-UK14 | Chunky Sandals | 35 | 7
8BLKPU-UK15 | Chunky Sandals | 35 | 5
Spreadsheet: 82286d1282287109-tracking-project-with-gantt-chart-copy-of-xl0000013
Sheet: Main Data

 |  | COMPLETED DATE OF EACH MILESTONE
PROJECT NAME | PROJECT PROBLEMS | MS1 | MS2 | MS3 | MS4 | [NAME] | MS6 | MS7 | MS8 | MS9 | MS10
PROJECT1 | NO | 2010-01-01 00:00:00 | 2010-02-02 00:00:00 | 2010-02-26 00:00:00 | 2010-05-07 00:00:00 | 2010-06-01 00:00:00 | 2010-06-10 00:00:00 | 2010-07-18 00:00:00 | 2010-07-30 00:00:00 | 2010-08-07 00:00:00 | 2010-08-17 00:00:00
PROJECT2 | YES | 2010-06-05 00:00:00 | 2010-07-06 00:00:00 | 2010-08-15 00:00:00
PROJECT3 | YES | 2010-05-04 00:00:00 | 2010-07-07 00:00:00 | 2010-08-15 00:00:00
PROJECT4 | NO | 2010-04-06 00:00:00 | 2010-05-05 00:00:00 | 2010-06-05 00:00:00 | 2010-08-05 00:00:00
PROJECT5 | NO | 2010-08-01 00:00:00 | 2010-08-18 00:00:00
Spreadsheet: 166716d1341752952-extracting-group-headings-book1-1-
Sheet: Sheet1

Before:
Birthdays
1944-12-06 00:00:00
1923-07-05 00:00:00
1994-09-08 00:00:00
Anniversaries
1984-12-01 00:00:00
1999-07-07 00:00:00
2004-04-03 00:00:00
2012-05-06 00:00:00
Red-letter days
1988-05-04 00:00:00
After
1944-12-06 00:00:00 | Birthdays |  |  | 1944-12-06 00:00:00 | Birthdays
1923-07-05 00:00:00 | Birthdays |  |  | 1923-07-05 00:00:00 | Birthdays
1994-09-08 00:00:00 | Birthdays |  |  | 1994-09-08 00:00:00 | Birthdays
1984-12-01 00:00:00 | Anniversaries |  |  | 1984-12-01 00:00:00 | Anniversaries
1999-07-07 00:00:00 | Anniversaries |  |  | 1999-07-07 00:00:00 | Anniversaries
04/03/20004 | Anniversaries |  |  | 2004-04-03 00:00:00 | Anniversaries
2012-05-06 00:00:00 | Anniversaries |  |  | 2012-05-06 00:00:00 | Anniversaries
1988-05-04 00:00:00 | Red-letter days |  |  | 1988-05-04 00:00:00 | Red-letter days
Spreadsheet: 157654d1337818226-combining-strings-of-data-then-displaying-them-data
Sheet: Raw Data

 |  | Name | Side | Role | [NAME] | Dx/Cx Dev. | S Dev. | Pickup DCS | [NAME] | Ranks | # Trials | Peer One | Peer Two
 | Round One | [NAME] | Δ | Attorney | Open | 0.6666666666666679 | -0.125 | 0 | 1 | 8 | 1 | [NAME] | [NAME] Simmons
 |  | [NAME] | Δ | Attorney | Swing | -1.083333333333332 |  |  | -2 | 0 | 1 | [NAME] | [NAME] Simmons
 |  | [NAME] Simmons | Δ | Attorney | Close | 0.4166666666666679 | 0.375 | -1 | -1 | 6 | 1 | [NAME] | [NAME]
 |  | [NAME] | Δ | Witness | [NAME] | 0.9583333333333321 |  | -1 | 1 | 9 | 1 | Chelsea Cramer | [NAME] Klara
 |  | Chelsea Cramer | Δ | Witness | [NAME] | 1.208333333333332 |  | 0 | 3 | 9 | 1 | [NAME] | [NAME] Klara
 |  | [NAME] Klara | Δ | Witness | [NAME] | 0.9583333333333321 |  | 1 | 2 | 4 | 1 | [NAME] | Chelsea Cramer
 | Round Two | Chelsea Cramer | Π | Attorney | Open | 0.2916666666666679 | -0.875 | -2 | 2 | 7 | 1 | [NAME] | [NAME] Simmons
 |  | [NAME] | Π | Attorney | Swing | -0.9583333333333321 |  |  | -4 | 0 | 1 | Chelsea Cramer | [NAME] Simmons
 |  | [NAME] Simmons | Π | Attorney | Close | 0.04166666666666785 | 0.125 | 0 | 2 | 4 | 1 | Chelsea Cramer | [NAME]
 |  | [NAME] | Π | Witness | [NAME] | 0.2916666666666661 |  | 1 | 3 | 6 | 1 | [NAME] | [NAME] Klara
 |  | [NAME] | Π | Witness | [NAME] | 1.041666666666666 |  | -2 | 1 | 9 | 1 | [NAME] | [NAME] Klara
 |  | [NAME] Klara | Π | Witness | Avery Smith | -0.2083333333333339 |  | -1 | -2 | 5 | 1 | [NAME] | [NAME]
 | Round Three | Chelsea Cramer | Π | Attorney | Open | 0.4166666666666661 | -0.625 | -2 | 4 | 6 | 1 | [NAME] | [NAME] Simmons
 |  | [NAME] | Π | Attorney | Swing | -0.08333333333333393 |  |  | 0 | 0 | 1 | Chelsea Cramer | [NAME] Simmons
 |  | [NAME] Simmons | Π | Attorney | Close | -0.3333333333333339 | -0.125 | 0 | -3 | 2 | 1 | Chelsea Cramer | [NAME]
 |  | [NAME] | Π | Witness | [NAME] | 0.75 |  | 0 | 1 | 6 | 1 | [NAME] | [NAME] Klara
 |  | [NAME] | Π | Witness | [NAME] | -0.75 |  | 0 | 0 | 9 | 1 | [NAME] | [NAME] Klara
 |  | [NAME] Klara | Π | Witness | Avery Smith | 1.25 |  | 0 | 4 | 2 | 1 | [NAME] | [NAME]
 | Round Four | [NAME] | Δ | Attorney | Open | 0.5416666666666661 | -0.25 | 2 | 0 | 0 | 1 | [NAME] | [NAME] Simmons
 |  | [NAME] | Δ | Attorney | Swing | 0.2916666666666661 |  |  | 0 | 0 | 1 | [NAME] | [NAME] Simmons
 |  | [NAME] Simmons | Δ | Attorney | Close | 1.291666666666666 | 0.75 | 1 | 1 | 9 | 1 | [NAME] | [NAME]
 |  | [NAME] | Δ | Witness | [NAME] | 0.08333333333333215 |  | 0 | 2 | 0 | 1 | Chelsea Cramer | [NAME] Klara
 |  | Chelsea Cramer | Δ | Witness | [NAME] | 0.3333333333333321 |  | -1 | 3 | 7 | 1 | [NAME] | [NAME] Klara
 |  | [NAME] Klara | Δ | Witness | [NAME] | 1.083333333333332 |  | 2 | 9 | 5 | 1 | [NAME] | Chelsea Cramer
Spreadsheet: 191531d1352140611-auto-sorting-4181-4181uc-forum
Sheet: 4181 Info

STATE ROUTE | LIMITED ACCESS | PRIVATE STATUS | TYPE OF OCCP. (1,2,OR 3) | STATION(S) OR SEG. & OFFSET |  |  | LT/RT | DISTANCE FROM |  | TYPE OF GUIDERAIL | DISTANCE BEHIND G-RAIL | DISTANCE BEHIND CURB OR EDGE OF PAVEMENT | POLE NO./PIPE SIZE ETC.
 |  |  |  |  |  |  |  | C/L TO FACILITY | FACILITY TO R/W LINE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This sheet is what I want to sort automatically.  It pulls information from the info tab and then I need it to sort automatically so I can hide it bacsue the information will be going somewhere else.  Its just for organization.  I don’t know how to use macros so i am kinda useless with this problem i think.  I just want to auto sort to get rid of all the empty spaces and move everything to the top and make the forms look professional.  they will be save in a pdf when they get filled out
Spreadsheet: 2afac790-48da-4f67-8e44-c7670effb4d3
Sheet: Sheet1

SAISD TRACK WEEKLY RESULTS FORM | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18
CAMPUS:
DATE OF MEET:
NAME OF MEET:
TEAM PLACE:
Athlete |  | Running Events |  |  |  |  |  |  |  |  |  |  | Field Events
Last Name | First  Name | 3200 | 400 M | 800 | 100/110 | 100 | 800 M | 400 | 300 | 200 | 1600 | 1600 M | Shot | Discus | Long | Triple | Pole | High
 |  | Run | Relay | Run | Hurdles | Dash | Relay | Dash | Hurdles | Dash | Run | Relay |  |  | Jump | Jump | Vault | Jump
TOTAL NUMBER OF PARTICIPANTS: |  |  |  | TOTAL NUMBER OF EVENTS PARTICIPATED IN: |  |  |  |  |  |  | OUT OF 17
Please send via e-mail to [NAME] in the Ahtletic Office by the end of the school day following the meet.
Spreadsheet: 56050d1256174992-vlookup-with-same-values-what-i-need-is-under-column-formula_help2
Sheet: 1901

 | 1901-01-01 00:00:00 | 1901-01-02 00:00:00 | 1901-01-03 00:00:00 | 1901-01-04 00:00:00 | 1901-01-05 00:00:00
Mercury
Venus
Mars
Jupiter
Saturn
Uranus
Neptune
Pluto
 |  |  |  | Date | Aspect
 |  |  |  | 1901-01-01 00:00:00 | 90 Mercury
 |  |  |  | 1901-01-02 00:00:00 | 45 Mars
 |  |  |  | 1901-01-05 00:00:00 | 30 Jupiter
 |  |  |  | 1901-01-05 00:00:00 | 180 Neptune
 |  |  |  | 1901-01-05 00:00:00 | 45 Saturn
Spreadsheet: 732209d1620824949-sumproduct-with-multiple-criteria-and-using-sign-function-sumproduct-with-multiple-criteria
Sheet: Sheet1

Release date | Category | JOB No. | Total |  |  |  | 1 | 2
2021-01-04 00:00:00 | Sheeting | HY-05840.01.25 | 0.172 |  |  | Job No. | Jan | Feb
2021-01-04 00:00:00 | Built-up | HY-05840.01.23 | 131.609 |  |  | HY-05840
2021-01-04 00:00:00 | Cold Form | HY-05840.01.24 | 86.56 |  |  | HY-05799
2021-01-04 00:00:00 | Others | HY-05840.01.25 | 91.65 |  |  |  | Need formula for the cells Highlighted in Yellow
2021-01-04 00:00:00 | Miscellaneous | HY-05840.01.23 | 0.011 |  |  |  | From the Table (A1:D23) the formula to sum "TOTAL" column by taking only month number from "Release Date" column and 8 characters from left of "JOB No." and only {Built-up, Cold Form & Sheeting} from "Category". Note: The data is in the Table form.
2021-01-05 00:00:00 | Built-up | HY-05840.01.24 | 0.725
2021-01-05 00:00:00 | Sheeting | HY-05840.01.25 | 0.17
2021-01-05 00:00:00 | Sheeting | HY-05840.01.23 | 5.587
2021-02-08 00:00:00 | Built-up | HY-05799.01.24 | 5.857
2021-02-08 00:00:00 | Cold Form | HY-05799.01.25 | 33.891
2021-02-08 00:00:00 | Others | HY-05799.01.23 | 0.603
2021-02-08 00:00:00 | Miscellaneous | HY-05799.01.24 | 11.327
2021-02-08 00:00:00 | Built-up | HY-05799.01.25 | 5.855
2021-02-08 00:00:00 | Sheeting | HY-05840.01.24 | 28.738
2021-02-08 00:00:00 | Miscellaneous | HY-05840.01.25 | 27.699
2021-02-08 00:00:00 | Built-up | HY-05840.01.24 | 5.857
2021-02-08 00:00:00 | Cold Form | HY-05840.01.25 | 33.891
2021-02-08 00:00:00 | Others | HY-05840.01.23 | 0.603
2021-02-08 00:00:00 | Miscellaneous | HY-05840.01.24 | 11.327
2021-02-08 00:00:00 | Built-up | HY-05840.01.25 | 5.855
2021-02-08 00:00:00 | Sheeting | HY-05840.01.24 | 28.738
2021-02-08 00:00:00 | Miscellaneous | HY-05840.01.25 | 27.699
Spreadsheet: 795528d1662736326-list-of-customers-with-dates-how-to-show-the-earliest-date-starting-after-this-month-how-to-set-earliest-date-based-on-next-month-as-minimum-date
Sheet: Sheet1

Account code | School name | Subject | Renewal date | Earliest renewal date | Earliest renewal date (min renewal date of next month)
1234 | [NAME] | Maths | 2022-09-20 00:00:00 |  | 2022-10-05 00:00:00
1234 | [NAME] | English | 2022-10-05 00:00:00 |  | 2022-10-05 00:00:00
1234 | [NAME] | History | 2022-11-15 00:00:00 |  | 2022-10-05 00:00:00
1234 | [NAME] | Geography | 2023-01-01 00:00:00 |  | 2022-10-05 00:00:00
2345 | London Free School | Maths | 2022-10-01 00:00:00 |  | 2022-10-01 00:00:00
2345 | London Free School | English | 2022-12-01 00:00:00 |  | 2022-10-01 00:00:00
3456 | [NAME] | French | 2022-09-25 00:00:00 |  | 2022-10-15 00:00:00
3456 | [NAME] | English | 2022-10-15 00:00:00 |  | 2022-10-15 00:00:00
3456 | [NAME] | Maths | 2022-10-21 00:00:00 |  | 2022-10-15 00:00:00
5678 | Bishop Academy | Music | 2022-10-01 00:00:00 |  | 2022-10-01 00:00:00
5678 | Bishop Academy | English | 2022-09-16 00:00:00 |  | 2022-10-01 00:00:00
Spreadsheet: louise_kitchen__24091__NEWCO HEADCOUNT NAMES
Sheet: Portland Fundies & Structuring

Portland Fundamentals & Structuring |  |  | ok
[NAME] | Kourtney | Fundies | Analyst | 1
Elafandi | Mo | Structuring | Associate | 1
Heizenrader | [NAME] | Fundies | Director | 1
Swain | [NAME] | Fundies | Manager
[NAME] | [NAME] | Structuring | Manager | 2
[NAME] | Julie | Fundies | Spec | 1
[NAME] | [NAME] | Fundies | Sr. Spec
Van Houten | Maria | Fundies | Sr. Spec | 2
 |  |  | TOTAL
Spreadsheet: 62215d1263211556-is-there-a-limit-to-how-many-if-statements-you-can-use-in-a-formula-example-of-paid-hours-calc
Sheet: Sheet1

 | Table is to explain the criteria ( I don’t actually have a table to use as part of calculation)
 |  | 2009-01-18 00:00:00 | 2009-01-19 00:00:00 | 2009-01-20 00:00:00 | 2009-01-21 00:00:00 | 2009-01-22 00:00:00 | 2009-01-23 00:00:00 | 2009-01-24 00:00:00 | 2009-01-25 00:00:00 | 2009-01-26 00:00:00 | 2009-01-27 00:00:00 | 2009-01-28 00:00:00 | 2009-01-29 00:00:00 | 2009-01-30 00:00:00 | 2009-01-31 00:00:00
 |  | Sun | Mon | [NAME] | Weds | Thurs | Fri | Sat | Sun | Mon | [NAME] | Weds | Thurs | Fri | Sat
 | A | 12 | 4 | 1
 | B |  |  |  |  |  | 4 | 12 | 12 | 1
 | C |  | 4 | 1
 | D |  |  |  |  |  |  |  | 12 | 4 | 1
 | E |  |  |  |  |  | 4 | 12
 | Aim: To calculate paid hours for a given task.
 | Arrival/Stay on a week day = 4 hours.  Arrival/Stay on a weekend = 12 hours.
 | Departure on a weekday = 1 hour.  Departure on a Weekend = 12 hours
 | Examples
 | A = Arrive on 18/1/09 leave on 20/1/09 would be 12 hours + 4 hours + 1 hour
 | B = Arrive on 23/1/09 leave on 26/1/09 would be 4 + 12 + 12 + 1
 | C = Arrive on 19/1/09 leave on 20/1/09 = 4+1
 | D = Arrive on 25/1/09 leave on 27/1/09 = 12 + 4 + 1
 | I have dates in lists as below, around 400.  I started by identifying the weekday and then wrote nested IF statements to do the various total hours calculations, however I haven't managed to cover all possibilities
 | Start Date | End Date |  | Arrive Day | Dep Day |  | Hours
 | 2009-01-02 00:00:00 | 2009-01-05 00:00:00 |  | 5 | 1
 | 2009-01-11 00:00:00 | 2009-01-14 00:00:00 |  | 7 | 3
 | 2009-01-21 00:00:00 | 2009-01-24 00:00:00 |  | 3 | 6
 | 2009-01-05 00:00:00 | 2009-01-07 00:00:00 |  | 1 | 3
 | 2009-01-16 00:00:00 | 2009-01-17 00:00:00 |  | 5 | 6
Spreadsheet: 700369d1603166412-need-help-to-have-formula-to-ignore-cells-with-no-dates-multiple-cells-in-a-row-playing-with-timeline
Sheet: VA Refi

Subject | Start Date | All day event | Reminder on/off | Meeting Organizer | Categories | Description | Location
Sign Disclosures |  | True | False | Team Rosa | Sign Disclosures
[NAME] |  | True | False | Team Rosa | [NAME]
[NAME] |  | True | False | Team Rosa | [NAME]
Processing Review |  | True | False | Team Rosa | Processing Review
[NAME] |  | True | False | Team Rosa | [NAME] | _x000D_
Submit to Underwriting |  | True | False | Team Rosa | Submit to Underwriting
Final Approval |  | True | False | Team Rosa | Final Approval
CD |  | True | False | Team Rosa | CD
[NAME] CD |  | True | False | Team Rosa | [NAME] CD
Docs Out |  | True | False | Team Rosa | Docs Out
Signing |  | True | False | Team Rosa | Signing
Close Date |  | True | False | Team Rosa | Close Date