tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 780654d1652648937-infill-blank-rows-in-a-list-title-sample-2
Sheet: Sheet1

What I have | Results I am looking for
Title 1 | 22 |  | 22
 | 22
 | 22
 | 22
Title 2
Title 3 | 19 |  | 19
Title 4
Title 5 | 17 |  | 17
 | 17
 | 17
 | 17
Title 6
Spreadsheet: 218448d1362466594-find-duplicates-in-column-and-increment-it-incremental-strings
Sheet: Sheet1

comptypeno |  | compname |  |  |  |  | TS-1
700021 |  | Air Reservoir |  |  |  |  | TS-1
700021 |  | Air Reservoir |  |  |  |  | TS-1
700021 |  | Air Reservoir |  |  |  |  | TS-2
800025 |  | Motor Electric, Low |  | 700021 |  |  | TS-2
800025 |  | Motor Electric, Low |  | 700021 |  |  | TS-3
800027 |  | Motor Electric, Low |  | 700021 |  |  | TS-3
900023 |  | Motor Electric, Low |  | 800025 |  |  | TS-3
6500055 |  | Main engine |  | 800025 |  |  | TS-3
6500055 |  | Main engine |  | 800027
6500055 |  | Main engine |  | 900023
6500056 |  | Main engine |  | 6500055
6500056 |  | Main engine |  | 6500055
 |  |  |  | 6500055
 |  |  |  | 6500056
 |  |  |  | 6500056
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Jill Krowinski

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
No response
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
No response
Health Care: Continuing System Reform
Agree
Explain your health care reform position, if you choose
No response
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
I believe retaining new teachers is a critical issue and applaud you for making this a priority.  I have family and friends who are teachers
and have seen them experience the challenges of starting a career in teaching.  We can do better in Vermont and it's time we invest in
our new teachers.  You can count on me.
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
No response
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | 27 Spring Street, Burlington, VT 05401 | State Representative | Yes |  | Chittenden
Spreadsheet: 272692d1382464646-need-an-array-formula-to-find-unique-records-but-dont-know-how-to-do-it-formula-for-finding-unique-values
Sheet: Sheet1

 | SALESPERSONS | MONTH | VISITED COUNTRIES
 | AGENT 1 | 2012-01-01 00:00:00 | USA
 | AGENT 2 | 2012-02-01 00:00:00 | CR
 | AGENT 3 | 2012-03-01 00:00:00 | INDIA
 | AGENT 4 | 2012-04-01 00:00:00 | USA
 | AGENT 5 | 2012-05-01 00:00:00 | ITALY
 | AGENT 6 | 2012-06-01 00:00:00 | POLAND
 | AGENT 7 | 2012-07-01 00:00:00 | CANADA
 | AGENT 8 | 2012-08-01 00:00:00 | CR
 | AGENT 9 | 2012-09-01 00:00:00 | USA
 | AGENT 10 | 2012-10-01 00:00:00 | INDIA
 | AGENT 11 | 2012-11-01 00:00:00 | CANADA
 | AGENT 12 | 2012-12-01 00:00:00 | USA
 | AGENT 1 | 2013-01-01 00:00:00 | USA
 | AGENT 2 | 2013-02-01 00:00:00 | USA
 | AGENT 3 | 2013-03-01 00:00:00 | POLAND
 | AGENT 4 | 2013-04-01 00:00:00 | ITALY
 | AGENT 5 | 2013-05-01 00:00:00 | INDIA
 | AGENT 6 | 2013-06-01 00:00:00 | INDIA
 | AGENT 7 | 2013-07-01 00:00:00 | CR
 | AGENT 8 | 2013-08-01 00:00:00 | CR
 | AGENT 9 | 2013-09-01 00:00:00 | CANADA
 | AGENT 10 | 2012-01-01 00:00:00 | CANADA
 | AGENT 11 | 2012-02-01 00:00:00 | USA
 | AGENT 12 | 2012-03-01 00:00:00 | CR
 | AGENT 1 | 2012-04-01 00:00:00 | INDIA
 | AGENT 2 | 2012-05-01 00:00:00 | USA
 | AGENT 3 | 2012-06-01 00:00:00 | ITALY
 | AGENT 4 | 2012-07-01 00:00:00 | POLAND
 | AGENT 5 | 2012-08-01 00:00:00 | CANADA
 | AGENT 6 | 2012-09-01 00:00:00 | CR
 | AGENT 7 | 2012-10-01 00:00:00 | USA
 | AGENT 8 | 2012-11-01 00:00:00 | INDIA
 | AGENT 9 | 2012-12-01 00:00:00 | CANADA
 | AGENT 10 | 2013-01-01 00:00:00 | USA
 | AGENT 11 | 2013-02-01 00:00:00 | USA
 | AGENT 12 | 2013-03-01 00:00:00 | USA
 | AGENT 1 | 2013-04-01 00:00:00 | POLAND
 | AGENT 2 | 2013-05-01 00:00:00 | ITALY
 | AGENT 3 | 2013-06-01 00:00:00 | INDIA
 | AGENT 4 | 2013-07-01 00:00:00 | INDIA
 | AGENT 5 | 2013-08-01 00:00:00 | CR
 | AGENT 6 | 2013-09-01 00:00:00 | CR
 | AGENT 7 | 2012-01-01 00:00:00 | CANADA
 | AGENT 8 | 2012-02-01 00:00:00 | CANADA
 | AGENT 9 | 2012-03-01 00:00:00 | USA
 | AGENT 10 | 2012-04-01 00:00:00 | CR
 | AGENT 11 | 2012-05-01 00:00:00 | INDIA
 | AGENT 12 | 2012-06-01 00:00:00 | USA
 | AGENT 1 | 2012-07-01 00:00:00 | ITALY
 | AGENT 2 | 2012-08-01 00:00:00 | POLAND
 | AGENT 3 | 2012-09-01 00:00:00 | CANADA
 | AGENT 4 | 2012-10-01 00:00:00 | CR
 | AGENT 5 | 2012-11-01 00:00:00 | USA
 | AGENT 6 | 2012-12-01 00:00:00 | INDIA
 | AGENT 7 | 2013-01-01 00:00:00 | CANADA
 | AGENT 8 | 2013-02-01 00:00:00 | USA
 | AGENT 9 | 2013-03-01 00:00:00 | USA
 | AGENT 10 | 2013-04-01 00:00:00 | USA
 | AGENT 11 | 2013-05-01 00:00:00 | POLAND
 | AGENT 12 | 2013-06-01 00:00:00 | ITALY
Spreadsheet: 271102d1381825241-shift-pattern-help-2014-shifts
Sheet: Shifts

 |  | Week1 | D | THU,FRI,SAT | 1 | N | WED,THU,FRI | 1 | D | MON,TUE,WED | 1 | N | SUN,MON,TUE
 |  | Week2 | N | WED,THU.FRI | 2 | D | THU,FRI,SAT | 2 | N | SUN,MON,TUE | 2 | D | MON,TUE,WED
 |  | Week3 | D | THU,FRI,SAT | 3 | N | WED,THU,FRI | 3 | D | MON,TUE,WED | 3 | N | SUN,MON,TUE
 |  | Week4 | N | WED,THU,FRI | 4 | D | THU,FRI,SAT | 4 | N | SUN,MON,TUE | 4 | D | MON,TUE,WED
 |  | Week5 | N | SUN,MON,TUE | 5 | D | WED,THU,FRI | 5 | N | WED,THU,FRI | 5 | D | THU,FRI,SAT
 |  | Week6 | D | MON,TUE,WED | 6 | N | SUN,MON,TUE | 6 | D | THU,FRI,SAT | 6 | N | WED,THU,FRI
 |  | Week7 | N | SUN,MON,TUE | 7 | D | WED,THU,FRI | 7 | N | WED,THU,FRI | 7 | D | THU,FRI,SAT
 |  | Week8 | D | MON,TUE,WED | 8 | N | SUN,MON,TUE | 8 | D | THU,FRI,SAT | 8 | N | WED,THU,FRI
 |  | D = | DAYS
 |  | N = | NIGHTS
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  | MONDAY DAY | C | D | C | D | B | A | B | A
 |  | MONDAY NIGHT | D | C | D | C | A | B | A | B
 |  | TUESDAY DAY | C | D | C | D | B | A | B | A
 |  | TUESDAY NIGHT | D | C | D | C | A | B | A | B
 |  | WEDNESDAY DAY | C | D | C | D | B | A | B | A
 |  | WEDNESDAY NIGHT | B | A | B | A | C | D | C | D
 |  | THURSDAY DAY | A | B | A | B | D | C | D | C
 |  | THURSDAY NIGHT | B | A | B | A | C | D | C | D
 |  | FRIDAY DAY | A | B | A | B | D | C | D | C
 |  | FRIDAY NIGHT | B | A | B | A | C | D | C | D
 |  | SATURDAY DAY | A | B | A | B | D | C | D | C
 |  | SUNDAY DAY
 |  | SUNDAY NIGHT | D | C | D | C | A | B | A | B
Spreadsheet: 117867d1313172184-trouble-concatenating-an-if-and-if-and-statement-sample-attached-combining-2-if-formulas
Sheet: Sheet1

Hire Date Cutoff | Non Eligible Start Date | Non Eligible End Date
2011-07-03 00:00:00 | 2011-03-01 00:00:00 | 2011-04-07 00:00:00
DATE | CORRECT | FORMULA 1 | FORMULA 2
2011-05-01 00:00:00 | ELIGIBLE |  |  | Note:  eligible because hired before 7/3/2011 and not between 3/1 and 4/7
2011-04-08 00:00:00 | ELIGIBLE |  |  | Note:  eligible because hired before 7/3/2011 and not between 3/1 and 4/7
2011-03-05 00:00:00 | NON-ELIGIBLE |  |  | Note:  Not eligible because hired between 3/1 and 4/7
2011-08-01 00:00:00 | NON-ELIGIBLE |  |  | Note:  Not eliglible because hired after 8/1
Spreadsheet: 44e2f466-aabc-44c8-9292-94256e737459
Sheet: Sheet1

BUCS Squash 2010/11 | 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
Women's Results Card
 | Home Team |  |  |  |  |  |  |  |  |  |  |  |  | Away Team
 | [NAME] 3rd | Match Date: |  |  | 27th Oct 2010 |  |  |  |  |  |  |  |  | [NAME] 2nd
 |  | Games | Individual Game Scores |  |  |  |  |  |  |  |  |  | Games
 |  |  | H | A | H | A | H | A | H | A | H | A
 | [NAME] | 0 | 6 | 11 | 4 | 11 | 4 | 11 |  |  |  |  | 3 | Charlotte
 | Amanda Wigram | 3 | 12 | 10 | 11 | 8 | 11 | 4 |  |  |  |  | 0 | Christiane
 | [NAME] | 0 | 2 | 11 | 1 | 11 | 9 | 11 |  |  |  |  | 3 | Rachel
 | [NAME] | 3 | 11 | 8 | 11 | 6 | 10 | 12 | 11 | 4 |  |  | 1 | [NAME]
 | MATCH RESULT
 | [NAME] 3rd |  |  |  |  | 2 | - | 2 | [NAME] 2nd
 |  |  |  |  | GAMES
 |  |  |  |  |  | 6 | - | 7
 |  |  |  |  |  | POINTS
 |  |  |  |  | 103 |  | - | 118
THIS RESULTS CARD MUST BE EMAILED TO [EMAIL] WITHIN 5 WORKING DAYS OF THE MATCH
 | MATCH RESULT |  | H | A
 | Match 1 |  | 0 | 1
 | Match 2 |  | 1 | 0
 | Match 3 |  | 0 | 1
 | Match 4 |  | 1 | 0
 | GAMES
 |  | Game | 1 | 2 | 3 | 4 | 5 | Total Games
 | Match 1
 | H |  | 0 | 0 | 0 | 0 | 0 | 0
 | A |  | 1 | 1 | 1 | 0 | 0 | 3
 | Match 2
 | H |  | 1 | 1 | 1 | 0 | 0 | 3
 | A |  | 0 | 0 | 0 | 0 | 0 | 0
 | Match 3
 | H |  | 0 | 0 | 0 | 0 | 0 | 0
 | A |  | 1 | 1 | 1 | 0 | 0 | 3
 | Match 4
 | H |  | 1 | 1 | 0 | 1 | 0 | 3
 | A |  | 0 | 0 | 1 | 0 | 0 | 1
Spreadsheet: 766491d1643905683-calculate-total-raw-material-qty-required-by-one-formula-calculateraws
Sheet: Sheet1

Finished Goods | Raw Materials | Qty of Raw Material Required |  |  | Finished Goods | FG Name |  |  | Raw Materials | RM Name
FG-W | RM-1 | 4 |  |  | FG-W | Warkanas |  |  | RM-1 | Almatorin
FG-W | RM-2 | 7 |  |  | FG-X | Xferenec |  |  | RM-2 | [NAME]
FG-W | RM-3 | 3 |  |  | FG-Y | [NAME] |  |  | RM-3 | Charmengenlo
FG-X | RM-1 | 8 |  |  | FG-Z | Zirkoman |  |  | RM-4 | Derthyvolo
FG-X | RM-2 | 11
FG-X | RM-3 | 12
FG-X | RM-4 | 14
FG-Y | RM-2 | 2
FG-Y | RM-4 | 3
FG-Z | RM-1 | 40
FG-Z | RM-2 | 12
FG-Z | RM-3 | 14
FG-Z | RM-4 | 15
Above table lists qty required to make one unit of ech FG.
Now if we want to make
Finished Goods | FG Name | FG to be produced
FG-W | Warkanas | 7000
FG-X | Xferenec | 8000
FG-Y | [NAME] | 9000
FG-Z | Zirkoman | 10000
How much of following Raw Materials required |  |  |  |  |  |  |  |  | Answer is  for verification
Raw Materials | RM Name | Qty Required |  |  |  |  |  |  | Raw Materials | RM Name | Qty Required
RM-1 | Almatorin | ?? | What formula can be used here to replace ?? |  |  |  |  |  | RM-1 | Almatorin
RM-2 | [NAME] | ?? | What formula can be used here to replace ?? |  |  |  |  |  | RM-2 | [NAME]
RM-3 | Charmengenlo | ?? | What formula can be used here to replace ?? |  |  |  |  |  | RM-3 | Charmengenlo
RM-4 | Derthyvolo | ?? | What formula can be used here to replace ?? |  |  |  |  |  | RM-4 | Derthyvolo
Spreadsheet: 155640d1337000083-excel-2007-copying-selected-values-to-another-excel-sheet-purchase-order-template
Sheet: Purchase Order

 | [NAME]
Safenet Ireland Limited |  |  |  |  | Date:
14 Oak Hill, [NAME], [NAME], Ireland |  |  |  |  | Order Number | 0101
Tel: +353 906 448811 Fax: +353 906 448811
Supplier |  |  | Ship to
 |  |  | (no priced
 |  |  | documents)
Shipping Method |  | Shipping Terms |  |  | Delivery Date
Qty | Item No. | Description |  |  | Unit Price | Line Total
 |  |  |  |  | Subtotal
 |  |  |  |  | VAT
 |  |  |  |  | Total
 |  |  |  | [NAME]
 |  |  |  | Authorized by |  | Date
Spreadsheet: 816529d1675686989-vlookup-with-multiple-criteria-without-a-helper-column-test-vlookup-1-ans
Sheet: Sheet1

 |  |  |  | Included columns |  | 1 | 2 | 3 | 4 | 5 |  | 7 | 8 | 9 | 10 |  |  | 13 | 14 | 15 | 16 |  |  |  | 20
helper | Desc | Val | st |  | line | a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z | Status | FORMULA
 | a | 18 | 1 |  | 1 | 18 | 2 | 2 | 3 | 0 | 2 | 1 | 2 | 1 | 3 | 1 | 2 | 1 | 3 | 26 | 2 | 0 | 22 | 0 | 22 | 2 | 32 | 2 | 4 | 2 | 2 |  |  | Result in AG are not correct because 0 not included in VLOOKUP functions.
 | a | 20 | 1 |  | 2 | 20 | 2 | 2 | 2 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 2 | 1 | 4 | 24 | 0 | 0 | 2 | 0 | 2 | 1 | 3 | 2 | 5 | 0 | 0
 | a | 10 | 1 |  | 3 | 10 | 2 | 2 | 222 | 0 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 24 | 0 | 2 | 2 | 0 | 2 | 1 | 3 | 1 | 5 | 0 | 2
 | a | 12 | 1 |  | 4 | 12 | 2 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 0 | 0 | 0 | 0 | 22 | 1 | 4 | 2 | 0
 | a | 15 | 0 |  | 5 | 15 | 2 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 2 | 0 | 2 | 1 | 22 | 1 | 4 | 2 | 0
 | a | 8 | 1 |  | 6 | 20 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | 0 | 1 | 4 | 20 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 2 | 4 | 2 | 0
 | a | 14 | 1 |  | 7 | 15 | 2 | 2 | 22 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 1 | 2 | 21 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 2 | 4 | 2 | 0
 | a | 24 | 0 |  | 8 | 18 | 2 | 2 | 22 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 1 | 4 | 2 | 0
 | a | 22 | 0 |  | 9 | 8 | 2 | 0 | 22 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 24 | 0 | 0 | 2 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 2
 | b | 2 | 1 |  | 10 | 14 | 2 | 2 | 3 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 12 | 0 | 2 | 22 | 0 | 2 | 1 | 22 | 2 | 3 | 0 | 2
 | c | 2 | 1 |  | 11 | 14 | 2 | 0 | 22 | 0 | 22 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 4 | 0 | 22
 | c | 0 | 1 |  | 12 | 18 | 2 | 0 | 22 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 28 | 2 | 0 | 2 | 0 | 2 | 1 | 32 | 2 | 5 | 2 | 2
 | d | 3 | 0 |  | 13 | 20 | 2 | 0 | 22 | 0 | 22 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 25 | 0 | 0 | 22 | 0 | 2 | 1 | 2 | 1 | 4 | 0 | 22
 | d | 2 | 1 |  | 14 | 24 | 2 | 2 | 222 | 0 | 22 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 15 | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 22
 | d | 222 | 0 |  | 15 | 8 | 2 | 0 | 3 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 22 | 0 | 0 | 2 | 0 | 2 | 1 | 2 | 1 | 4 | 0 | 2
 | d | 22 | 0 |  | 16 | 18 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | 0 | 1 | 4 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 0
 | d | 0 | 1 |  | 17 | 22 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 0 | 2 | 2 | 4 | 20 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | 0 | 0
 | e | 0 | 1 |  | 18 | 24 | 2 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 3 | 2 | 5 | 21 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 0
 | f | 2 | 1 |  | 19 | 22 | 2 | 2 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 0 | 2 | 2 | 4 | 16 | 2 | 2 | 22 | 0 | 0 | 0 | 22 | 1 | 3 | 2 | 0
 | f | 0 | 0
 | f | 22 | 1
 | g | 1 | 1
 | g | 0 | 0
 | g | 2 | 0
 | h | 2 | 1
 | h | 0 | 1
 | h | 3 | 1
 | i | 1 | 0
 | i | 2 | 1
 | j | 3 | 0
 | j | 4 | 0
 | j | 2 | 1
 | j | 5 | 1
Spreadsheet: d8dc2261-1604-403f-a6e6-e38a968f0266
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Schönheide - Variante 2
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 20 | 675 | 665 | 627 | 560
20 - 60 | 2371 | 2035 | 1770 | 1559
60 und mehr | 1872 | 1936 | 1907 | 1855
Insgesamt | 4918 | 4636 | 4304 | 3974
%
unter 20 | 13.72509150061 | 14.34426229508197 | 14.567843866171 | 14.09159536990438
20 - 60 | 48.21065473769825 | 43.89559965487489 | 41.12453531598513 | 39.22999496728737
60 und mehr | 38.06425376169175 | 41.76013805004314 | 44.30762081784387 | 46.67840966280825
Insgesamt | 100 | 100 | 100 | 100
Abhängigkeitsquotient
Jugendquotient | 28.46900042176297 | 32.67813267813268 | 35.42372881355932 | 35.9204618345093
Altenquotient | 78.95402783635596 | 95.13513513513514 | 107.7401129943503 | 118.9865298268121
Gesamtquotient | 107.4230282581189 | 127.8132678132678 | 143.1638418079096 | 154.9069916613214
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 105213d1302638701-how-to-work-out-a-time-formula-to-ignore-certain-information-register
Sheet: Sheet1

DAILY REGISTER
MONTH: |  | 2011-04-01 00:00:00
DATE |  | NAME | START1 | FINISH1 | START2 | FINISH2 | HRS PER CHILD
FRI | 1 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00
 |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00
 |  | C.PERSON | 08:00:00 | 12:00:00
 |  | D.PERSON | 09:00:00 | 10:00:00
Spreadsheet: 101487d1299602945-restrict-randbetween-formula-to-use-as-per-my-requirement-book1
Sheet: Sheet1

Employee No | Ratings |  | A | B | C | D | Total | Remarks
10277 | B |  | 15 | 20 | 25 | 40 | 100 | Requirement 1
6245 | A |  | 20 | 25 | 40 | 15 | 100 | Requirement 2
2293 | B
5686 | A
1739 | B
6081 | A
15580 | D
17551 | D
11523 | D
10527 | A
10636 | D
6068 | A
9343 | B
11369 | B
8717 | D
14719 | D
16118 | B
2016 | A
3117 | A
4141 | A
5096 | B
9802 | A
7563 | C
11315 | D
12489 | D
8326 | D
3916 | C
5225 | D
14013 | D
15724 | C
7538 | A
10678 | D
8093 | B
7832 | B
3056 | D
2734 | D
5049 | D
9477 | B
5936 | B
9998 | B
12171 | D
7261 | B
4428 | A
4683 | B
2064 | A
7772 | D
11260 | B
6859 | D
3030 | D
4582 | C
14290 | A
10631 | D
1762 | A
2497 | A
3692 | C
4047 | D
14265 | D
5676 | A
11368 | A
10934 | A
3259 | D
3733 | D
4221 | D
3487 | D
11968 | D
10685 | D
12131 | B
10881 | A
7035 | C
16495 | D
3286 | B
10397 | C
6321 | D
2076 | A
11447 | D
3202 | B
2211 | D
9003 | D
7522 | D
11239 | C
13047 | A
8169 | D
16332 | A
1339 | A
9321 | D
2137 | D
10863 | D
11563 | A
14461 | D
12045 | D
17159 | A
5901 | D
9155 | D
2274 | C
8901 | D
8827 | D
4150 | A
11995 | B
12046 | A
12046 | B
Spreadsheet: 743790d1628721787-dynamic-return-shortage-date-and-time-shortage-date-and-time
Sheet: Sheet1

Item Number | Total Inventory | Date | Shortage Shipment | Shortage Date | Shortage Time |  | Shipment Number | Item Number | Secondary Qty | Scheduled Ship Date | Scheduled Ship Time |  | 6036412
6036412 | 150 | 2021-08-10 00:00:00 |  |  |  |  | 6808934 | 6017693 | 22 | 2021-08-11 00:00:00 | 190000
6023837 | 50 | 2021-08-10 00:00:00 |  |  |  |  | 6808924 | 6017693 | 22 | 2021-08-11 00:00:00 | 193000
6035329 | 0 | 2021-08-10 00:00:00 |  |  |  |  | 6814467 | 6022741 | 11 | 2021-08-11 00:00:00 | 50000
 |  |  |  |  |  |  | 6804860 | 6023837 | 25 | 2021-08-10 00:00:00 | 80000
 |  |  |  |  |  |  | 6805055 | 6023837 | 25 | 2021-08-10 00:00:00 | 80000
 |  |  |  |  |  |  | 6805057 | 6023837 | 25 | 2021-08-11 00:00:00 | 60000
 |  |  |  |  |  |  | 6805058 | 6023837 | 25 | 2021-08-11 00:00:00 | 70000
 |  |  |  |  |  |  | 6805059 | 6023837 | 25 | 2021-08-11 00:00:00 | 80000
 |  |  |  |  |  |  | 6805060 | 6023837 | 25 | 2021-08-11 00:00:00 | 90000
 |  |  |  |  |  |  | 6814467 | 6026033 | 11 | 2021-08-11 00:00:00 | 50000
 |  |  |  |  |  |  | 6805163 | 6031797 | 9 | 2021-08-11 00:00:00 | 130000
 |  |  |  |  |  |  | 6814468 | 6032283 | 1 | 2021-08-11 00:00:00 | 60000
 |  |  |  |  |  |  | 6814469 | 6032285 | 4 | 2021-08-11 00:00:00 | 70000
 |  |  |  |  |  |  | 6814469 | 6033729 | 12 | 2021-08-11 00:00:00 | 70000
 |  |  |  |  |  |  | 6814470 | 6033729 | 11 | 2021-08-11 00:00:00 | 80000
 |  |  |  |  |  |  | 6814470 | 6033809 | 11 | 2021-08-11 00:00:00 | 80000
 |  |  |  |  |  |  | 6805160 | 6035323 | 22 | 2021-08-11 00:00:00 | 90000
 |  |  |  |  |  |  | 6805162 | 6035323 | 22 | 2021-08-11 00:00:00 | 110000
 |  |  |  |  |  |  | 6805163 | 6035323 | 13 | 2021-08-11 00:00:00 | 130000
 |  |  |  |  |  |  | 6814468 | 6035329 | 7 | 2021-08-11 00:00:00 | 60000
 |  |  |  |  |  |  | 6814469 | 6035329 | 6 | 2021-08-11 00:00:00 | 70000
 |  |  |  |  |  |  | 6814468 | 6035330 | 14 | 2021-08-11 00:00:00 | 60000
 |  |  |  |  |  |  | 6808958 | 6036412 | 22 | 2021-08-10 00:00:00 | 173000
 |  |  |  |  |  |  | 6808956 | 6036412 | 22 | 2021-08-10 00:00:00 | 180000
 |  |  |  |  |  |  | 6808954 | 6036412 | 22 | 2021-08-10 00:00:00 | 183000
 |  |  |  |  |  |  | 6808951 | 6036412 | 22 | 2021-08-10 00:00:00 | 190000
 |  |  |  |  |  |  | 6808948 | 6036412 | 22 | 2021-08-11 00:00:00 | 150000
 |  |  |  |  |  |  | 6808946 | 6036412 | 22 | 2021-08-11 00:00:00 | 153000
 |  |  |  |  |  |  | 6808942 | 6036412 | 22 | 2021-08-11 00:00:00 | 160000
 |  |  |  |  |  |  | 6808939 | 6036412 | 22 | 2021-08-11 00:00:00 | 163000
 |  |  |  |  |  |  | 6808932 | 6036412 | 22 | 2021-08-11 00:00:00 | 170000
 |  |  |  |  |  |  | 6808937 | 6036412 | 22 | 2021-08-11 00:00:00 | 173000
 |  |  |  |  |  |  | 6808936 | 6036412 | 22 | 2021-08-11 00:00:00 | 180000
 |  |  |  |  |  |  | 6808935 | 6036412 | 22 | 2021-08-11 00:00:00 | 183000
 |  |  |  |  |  |  | 6805218 | 6036775 | 22 | 2021-08-11 00:00:00 | 110000
 |  |  |  |  |  |  | 6805220 | 6036775 | 22 | 2021-08-11 00:00:00 | 130000
 |  |  |  |  |  |  | 6805223 | 6036775 | 22 | 2021-08-11 00:00:00 | 150000
Spreadsheet: 81065d1281346155-due-date-dateprog
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Hello friends…I have a problem here I hope u can help me to solve this problem thanks…
# | Job To Be Done |  |  | Date | Duration | Next date | Reminder
1 | water the plant |  |  | 2009-08-09 00:00:00 | 1 year | 2010-08-10 00:00:00
2 | Give cat eat |  |  | 2010-02-09 00:00:00 | 6 month | 2010-08-09 00:00:00
3 | give the fertilizer |  |  | 2005-08-09 00:00:00 | 5 years | 2010-08-09 00:00:00
 | I plan to make a system. Which is like schedule system. I want a reminder come out like in column H. if date at column G is reached.
Spreadsheet: 851923d1702044093-need-help-converting-a-google-sheets-formula-to-excel-scheduling-test1
Sheet: PressOpJobSubmit

ID | Start time | Completion time | [NAME] | Name | Last modified time | Employee Name: | Client: | Job #: | Letter Code/ Part #: | Question | Start Time: | End Time: | Sheets/ Rolls Printed | Material (GSP Part #): | [NAME] of print | Height of print: | # Up | Total Pieces Printed: | Is the job complete? | Next Step: | Special Notes:
1 | 2023-12-05 13:12:48 | 2023-12-05 13:14:03 | ******@gspretail.com | [NAME] |  | [NAME] | Fred | 231235 | 1 |  | 4:00pm | 4:15pm | 1 | PAP-SO-0017 | 45 | 58 | 1 | 1 | Yes | iCut
2 | 2023-12-05 13:14:17 | 2023-12-05 13:15:19 | ******@gspretail.com | [NAME] |  | [NAME] | [NAME] | 232445 | 2 |  | 3:00pm | 3:30pm | 2 | PAP-SO-1332 | 30 | 30 | 2 | 4 | Yes | Finishing
3 | 2023-12-05 13:15:22 | 2023-12-05 13:16:23 | ******@gspretail.com | [NAME] |  | Crystal [NAME] | Gregory | 243556 | 3 |  | 2:00pm | 2:30pm | 4 | ART-4443 | 33 | 20 | 4 | 25 | Yes | Guillotine
4 | 2023-12-05 13:16:26 | 2023-12-05 13:17:33 | ******@gspretail.com | [NAME] |  | [NAME] | Gregory | 243557 | 2 |  | 3:00pm | 3:15pm | 3 | ART-3232 | 24 | 36 | 4 | 300 | Yes | Finishing
Spreadsheet: 876547d1723255378-assign-dates-as-late-as-possible-without-duplicates-dfer43-latest-production-date
Sheet: Earliest to latest

Production Run # | Latest Production Date | Actual Production Date ? |  | Potential Production Dates
1 | 2025-06-10 00:00:00 |  |  | 2025-03-26 00:00:00
2 | 2025-06-17 00:00:00 |  |  | 2025-04-09 00:00:00
3 | 2025-06-23 00:00:00 |  |  | 2025-05-03 00:00:00
4 | 2025-07-05 00:00:00 |  |  | 2025-05-07 00:00:00
5 | 2025-07-05 00:00:00 |  |  | 2025-05-11 00:00:00
6 | 2025-07-08 00:00:00 |  |  | 2025-05-25 00:00:00
7 | 2025-07-08 00:00:00 |  |  | 2025-06-08 00:00:00
8 | 2025-07-14 00:00:00 |  |  | 2025-06-12 00:00:00
9 | 2025-07-17 00:00:00 |  |  | 2025-06-16 00:00:00
10 | 2025-07-25 00:00:00 |  |  | 2025-06-20 00:00:00
11 | 2025-08-14 00:00:00 |  |  | 2025-06-22 00:00:00
12 | 2025-08-22 00:00:00 |  |  | 2025-07-06 00:00:00
 |  |  |  | 2025-07-10 00:00:00
 |  |  |  | 2025-07-14 00:00:00
 |  |  |  | 2025-07-18 00:00:00
 |  |  |  | 2025-08-01 00:00:00
 |  |  |  | 2025-08-15 00:00:00
 |  |  |  | 2025-08-19 00:00:00
Spreadsheet: 95281d1294910125-multiple-criteria-with-a-date-range-month-excel-help
Sheet: Sheet2

 | October | November | December | January | Febuary
Opened | 17 | 85 | 46 | 16 | 0
Internal | #N/A
External | #N/A
Closed | #N/A | #N/A | #N/A | #N/A | #N/A
Internal
External