tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 875895d1722518426-help-with-overtime-formula-overtime-example-2
Sheet: Mon-Tues. Thurs-Fri 8hr-day  

You must use the format HH:[NAME] (ie 09:00 or 17:00) when entering your time. It reformats the cell if you use any other way (ie 9 or 17 or 9.00 ect) this will change the calculations and the sheet won't be correct.
 |  | Enter start time: 24hr clock | Enter time work over lunch. ie 00:30 minuets worked | Enter finish time: 24hr clock | Hours in work | Overtime. | Enter time taken back as hours:minutes | Final running total of overtime
Date | Day | Start | Lunch | Finish | Hours | Overtime | Time taken back | Total
2024-09-16 00:00:00 | Monday
2024-09-17 00:00:00 | Tuesday
2024-09-18 00:00:00 | Wednesday |  |  |  |  |  |  |  |  | [NAME]. Thurs-Fri 8hr-day  28 hours per Wk
2024-09-19 00:00:00 | Thursday
2024-09-20 00:00:00 | Friday
2024-09-21 00:00:00 | Saturday
2024-09-22 00:00:00 | Sunday
2024-09-23 00:00:00 | Monday
2024-09-24 00:00:00 | Tuesday
2024-09-25 00:00:00 | Wednesday
2024-09-26 00:00:00 | Thursday
2024-09-27 00:00:00 | Friday
2024-09-28 00:00:00 | Saturday
2024-09-29 00:00:00 | Sunday
2024-09-30 00:00:00 | Monday
2024-10-01 00:00:00 | Tuesday
2024-10-02 00:00:00 | Wednesday
2024-10-03 00:00:00 | Thursday
2024-10-04 00:00:00 | Friday
2024-10-05 00:00:00 | Saturday
2024-10-06 00:00:00 | Sunday
Spreadsheet: 692605d1598460634-formular-for-ranking-rank
Sheet: Sheet1

 |  |  |  | 4 | 1.5
 |  |  |  |  | 4.5
 |  |  |  |  | 7.5
 |  |  |  |  | 10.5
 |  |  |  | 4 | 1.5
 |  |  |  |  | 4.5
 |  |  |  |  | 7.5
 |  |  |  |  | 10.5
 |  |  |  | 4 | 1.5
 |  |  |  |  | 4.5
 |  |  |  |  | 7.5
 |  |  |  |  | 10.5
Spreadsheet: 119767d1314728637-find-a-value-using-multiple-conditions-dummy-workbook
Sheet: Sheet1

 |  | Week #
Customer Name | Item Description | 27 | 28 | 29
FEDERATED CO-OPERATIVES LTD | [NAME] | 10 | 20 | 30
FEDERATED CO-OPERATIVES LTD | TAPIOCA 6PACK F/E 8X6/4 | 20 | 40 | 60
FEDERATED CO-OPERATIVES LTD | CHOC NSA 4PACK 12X4/4OZ F/E | 30 | 60 | 90
FEDERATED CO-OPERATIVES LTD | RICE NSA 4PACK 12X4/4OZ F/E | 40 | 80 | 120
FEDERATED CO-OPERATIVES LTD | [NAME] 22OZ F/E 6X22 | 50 | 100 | 150
FEDERATED CO-OPERATIVES LTD | CINN RAISIN RICE F/E 6X22 | 60 | 120 | 180
FEDERATED CO-OPERATIVES LTD | TAPIOCA 22OZ F/E 6X22 | 70 | 140 | 210
0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
BUY LOW FOODS LTD. | [NAME] | 100 | 200 | 300
BUY LOW FOODS LTD. | TAPIOCA 6PACK F/E 8X6/4 | 110 | 220 | 330
BUY LOW FOODS LTD. | CHOCOLATE LOW FAT 8X6/4 | 120 | 240 | 360
BUY LOW FOODS LTD. | RICE NSA 4PACK 12X4/4OZ F/E | 130 | 260 | 390
BUY LOW FOODS LTD. | TAPIOCA NSA 4PACK 12X4/4OZ F/E | 140 | 280 | 420
Spreadsheet: 845874d1697195497-adding-a-1-25-to-an-iferror-formula-result-leavedata-1-_edited-13-oct-2023
Sheet: Sheet1

Name and Surname | Type of Leave |  | Number of Days Approved | New Leave Balance | Start Date | End Date
User 1 |  |  |  | 15 | 2022-12-21 00:00:00
User 2 |  |  |  | 18.75 | 2022-12-08 00:00:00
User 3 |  |  |  | 16.25 | 2023-02-02 00:00:00
User 4 |  |  |  | 15.25 | 2023-03-28 00:00:00
User 5 |  |  |  | 15 | 2023-01-03 00:00:00
User 1 | Annual Leave |  | 1 |  | 2022-12-22 00:00:00 | 2022-12-22 00:00:00
User 1 | Annual Leave |  | 1 |  | 2023-01-05 00:00:00 | 2023-01-05 00:00:00
User 2 | Annual Leave |  | 3 |  | 2023-01-07 00:00:00 | 2023-01-09 00:00:00
User 3 | Annual Leave |  | 5 |  | 2023-02-03 00:00:00 | 2023-02-07 00:00:00
User 4 | Annual Leave |  | 5 |  | 2023-04-01 00:00:00 | 2023-04-05 00:00:00
User 5 | Annual Leave |  | 2 |  | 2023-01-08 00:00:00 | 2023-01-10 00:00:00
User 1 | Annual Leave |  | 3 |  | 2023-02-07 00:00:00 | 2023-02-09 00:00:00
User 4 | Annual Leave |  | 5 |  | 2023-06-06 00:00:00 | 2023-06-10 00:00:00
User 2 | Annual Leave |  | 4 |  | 2023-01-11 00:00:00 | 2023-01-14 00:00:00
User 3 | Annual Leave |  | 6 |  | 2023-03-08 00:00:00 | 2023-03-13 00:00:00
User 5 | Annual Leave |  | 3 |  | 2023-09-19 00:00:00 | 2023-09-21 00:00:00
User 5 | Annual Leave |  | 8 |  | 2023-10-01 00:00:00 | 2023-10-08 00:00:00
User 1 | Annual Leave |  | 1 |  | 2023-04-02 00:00:00 | 2023-04-02 00:00:00
User 3 | Annual Leave |  | 2 |  | 2023-05-18 00:00:00 | 2023-05-20 00:00:00
User 2 | Annual Leave |  | 4 |  | 2023-11-01 00:00:00 | 2023-11-04 00:00:00
User 4 | Annual Leave |  | 4 |  | 2023-07-08 00:00:00 | 2023-07-11 00:00:00
Spreadsheet: 201614d1356038825-work-schedule-10hr-shifts-4-on-3-off-rotating-weekends-off-work-schedule-solution
Sheet: Sheet1

 |  | Week #1 |  |  |  |  |  |  | Week #2
 |  | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | SUNDAY
 | E1 | AM | AM | AM | AM | AM | AM | AM | AM | AM | AM | AM | AM
 | E2 | AM | AM | AM | AM | AM | AM | AM | AM | AM | AM | AM | AM
 | E3 | AM | AM | AM | AM | AM |  |  | AM | AM | AM | AM | AM | AM | AM
 | E4 | AM | AM | AM | AM | AM |  |  | AM | AM | AM | AM | AM | AM | AM
 | E5 | PM | PM | PM | PM | PM | PM | PM | PM | PM | PM | PM | PM
 | E6 | PM | PM | PM | PM | PM | PM | PM | PM | PM | PM | PM | PM
 | E7 | PM | PM | PM | PM | PM |  |  | PM | PM | PM | PM | PM | PM | PM
 | E8 | PM | PM | PM | PM | PM |  |  | PM | PM | PM | PM | PM | PM | PM
Spreadsheet: 884416d1733548033-extract-maximum-formula-in-range-formula-to-extract-maximum-date-in-range
Sheet: Statement

 | Transaction Date
 | 02-NOV-2024
 | 04-NOV-2024
 | 04-NOV-2024
 | 04-NOV-2024
 | 04-NOV-2024
 | 04-NOV-2024
 | 04-NOV-2024
 | 05-N0V-2024
 | 05-N0V-2024
 | 05-N0V-2024
 | 05-NOV-2024
 | 05-NOV-2024
 | 05-NOV-2024
 | 05-NOV-2024
 | 05-NOV-2024
 | 06-NOV-2024
 | 06-NOV-2024
 | 07-NOV-2024
 | 07-NOV-2024
 | 07-NOV-2024
 | 07-NOV-2024
 | 07-NOV-2024
 | 07-NOV-2024
 | 07-NOV-2024
 | 08-NOV-2024
 | 08-NOV-2024
 | 08-NOV-2024
 | 08-NOV-2024
 | 08-NOV-2024
 | 08-NOV-2024
 | 08-NOV-2024
 | 08-NOV-2024
 | 08-NOV-2024
 | 08-NOV-2024
 | 08-NOV-2024
 | 08-NOV-2024
 | 11-NOV-2024
 | 11-NOV-2024
 | 11-NOV-2024
 | 11-NOV-2024
 | 11-NOV-2024
 | 11-NOV-2024
 | 11-NOV-2024
 | 11-NOV-2024
 | 12-NOV-2024
 | 12-NOV-2024
 | 13-NOV-2024
 | 13-NOV-2024
 | 13-NOV-2024
 | 13-NOV-2024
 | 13-NOV-2024
 | 13-NOV-2024
 | 14-NOV-2024
 | 14-NOV-2024
 | 14-NOV-2024
 | 14-NOV-2024
 | 15-NOV-2024
 | 15-NOV-2024
 | 15-NOV-2024
 | 15-NOV-2024
 | 18-NOV-2024
 | 18-NOV-2024
 | 18-NOV-2024
 | 18-NOV-2024
 | 18-NOV-2024
 | 19-NOV-2024
 | 19-NOV-2024
 | 19-NOV-2024
 | 19-NOV-2024
 | 19-NOV-2024
 | 19-NOV-2024
 | 19-NOV-2024
 | 19-NOV-2024
 | 19-NOV-2024
 | 19-NOV-2024
 | 19-NOV-2024
 | 19-NOV-2024
 | 19-NOV-2024
 | 19-NOV-2024
 | 19-NOV-2024
 | 20-NOV-2024
 | 20-NOV-2024
 | 21-NOV-2024
 | 21-NOV-2024
 | 21-NOV-2024
 | 21-NOV-2024
 | 21-NOV-2024
 | 21-NOV-2024
 | 22-NOV-2024
 | 22-NOV-2024
 | 22-NOV-2024
 | 22-NOV-2024
 | 25-NOV-2024
 | 25-NOV-2024
 | 25-NOV-2024
 | 25-NOV-2024
 | 26-NOV-2024
 | 26-NOV-2024
 | 26-NOV-2024
 | 26-NOV-2024
 | 26-NOV-2024
 | 27-NOV-2024
 | 27-NOV-2024
 | 27-NOV-2024
 | 27-NOV-2024
 | 27-NOV-2024
 | 27-NOV-2024
 | 27-NOV-2024
 | 27-NOV-2024
 | 28-NOV-2024
 | 28-NOV-2024
 | 28-NOV-2024
 | 28-NOV-2024
 | 28-NOV-2024
 | 29-NOV-2024
 | 29-NOV-2024
 | 29-NOV-2024
 | 29-NOV-2024
 | 29-NOV-2024
 | 29-NOV-2024
 | 30-NOV-2024
 | 30-NOV-2024
 | 30-NOV-2024
 | 30-NOV-2024
 | 30-NOV-2024
 | 30-NOV-2024
 | 30-NOV-2024
 | 30-NOV-2024
Spreadsheet: 27606d1220986666-calculating-total-exams-sat-and-average-mark-per-student-by-tutor-book1
Sheet: Sheet1

DATE | PLACE | TUTOR | STUDENT | MARKER | GRADE
2008-01-01 00:00:00 | AREA 1 | T8001 | S0001 | LR | 1
2008-01-02 00:00:00 | AREA 3 | T8003 | S0202 | GH | 0
2008-01-03 00:00:00 | AREA 6 | T8001 | S0200 | GH | 5
2008-01-04 00:00:00 | AREA 8 | T8001 | S0001 | GH | 4
2008-01-05 00:00:00 | AREA 7 | T8002 | S0526 | GH | 4
2008-01-06 00:00:00 | AREA 15 | T8004 | S0445 | LR | 6
2008-01-07 00:00:00 | AREA 2 | T8001 | S0200 | LR | 6
2008-01-08 00:00:00 | AREA 9 | T8002 | S0526 | BC | 0
2008-01-09 00:00:00 | AREA 14 | T8003 | S0202 | BC | 2
2008-01-10 00:00:00 | AREA 20 | T8005 | S0865 | BC | 2
2008-01-11 00:00:00 | AREA H | T8006 | S0660 | BC | 3
2008-01-12 00:00:00 | AREA 7 | T8003 | S0202 | BC | 5
2008-01-13 00:00:00 | AREA 1 | T8001 | S0001 | LR | 2
2008-01-14 00:00:00 | AREA 3 | T8004 | S0445 | GH | 2
2008-01-15 00:00:00 | AREA 8 | T8001 | S0200 | GH | 4
2008-01-16 00:00:00 | AREA 2 | T8006 | S0660 | GH | 6
2008-01-17 00:00:00 | AREA 7 | T8005 | S0865 | GH | 3
2008-01-18 00:00:00 | AREA 8 | T8002 | S0526 | LR | 1
2008-01-19 00:00:00 | AREA 9 | T8001 | S0001 | BC | 0
2008-01-20 00:00:00 | AREA 13 | T8006 | S0660 | BC | 5
Spreadsheet: 130677d1322512005-formating-for-leap-year-leap-year
Sheet: Sheet1

 | Day | Date
 | Tue | 2011-12-20 00:00:00
 | Thu | 2011-12-22 00:00:00
 | Wed | 2011-12-28 00:00:00
 | Sat | 2011-12-31 00:00:00
 | Tue | 2012-01-03 00:00:00
 | Sat | 2012-01-07 00:00:00
 | Tue | 2012-01-10 00:00:00
 | Sun | 2012-01-15 00:00:00
 | Sat | 2012-01-21 00:00:00
 | Wed | 2012-01-25 00:00:00
 | Sun | 2012-01-29 00:00:00
 | Sat | 2012-02-04 00:00:00
 | Tue | 2012-02-07 00:00:00
 | Sat | 2012-02-11 00:00:00
 | Tue | 2012-02-14 00:00:00
 | Sat | 2012-02-18 00:00:00
 | Tue | 2012-02-21 00:00:00
 | Sat | 2012-02-25 00:00:00
 | 2/29/2029 | 2/29/2029
 | Sun | 2012-03-04 00:00:00
Spreadsheet: 718090d1612979934-extract-from-tables-from-multiple-tabs-one-workbook-excel-help
Sheet: ABC II 2019

 |  |  |  |  |  |  |  | Title 2019
 | Date Range |  | 2019-01-01 00:00:00 | to | 2019-12-31 00:00:00
Account | Description |  | Period 1 - 2019 | Period 2 - 2019 | Period 3 - 2019 | Period 4 - 2019 | Period 5 - 2019 | Period 6 - 2019 | Period 7 - 2019 | Period 8 - 2019 | Period 9 - 2019 | Period 10 - 2019 | Period 11 - 2019 | Period 12 - 2019 | Total
01-777-12345 | First Row |  | 26077 | 58101 | 13509 | 60356 | 51503 | 22832 | 62325 | 11190 | 64599 | 3284 | 39776 | 15250 | 428802
01-777-11223 | Second Row |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
01-777-99883 | [NAME] |  | 3849 | 4305 | 241 | 3324 | 4851 | 3469 | 1148 | 3471 | 3475 | 2373 | 466 | 188 | 31160
01-777-77443 | Middle Row |  | 1113 | 1673 | 3997 | 3079 | 2804 | 1688 | 376 | 3134 | 2217 | 4794 | 2 | 2413 | 27290
01-666-12345 | First Row |  | 14362 | 39473 | 16721 | 16196 | 51059 | 49488 | 39346 | 34522 | 41377 | 29988 | 35909 | 34704 | 403145
01-666-11223 | Second Row |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
01-666-99883 | [NAME] |  | 1118 | 243 | 3541 | 4587 | 3733 | 1672 | 3730 | 777 | 280 | 4262 | 4520 | 3383 | 31846
01-666-77443 | Middle Row |  | 1506 | 3525 | 3757 | 869 | 2260 | 2256 | 4073 | 682 | 4125 | 2627 | 164 | 3014 | 28858
Spreadsheet: 853235d1703130865-formula-to-mimic-nested-for-loops-to-loop-through-two-dynamic-arrays-sample-array-calculation-1-
Sheet: Sheet1

 | Total Sales by Employee per Year |  |  |  |  |  | Filtered Data |  |  |  |  | Raw Data
 |  |  | 2022 | 2021 |  |  | Employee | Year | Sale Amount | Eligible? |  | Employee | Year | Sale Amount | Eligible?
 |  |  | 0 | 4654 |  |  |  | 2023 | 1000 | Y |  | A | 2023 | 1000 | Y
 | B | 345 | 5675 | 234 |  |  | B | 2023 | 345 | Y |  | B | 2023 | 345 | Y
 | C | 2342 | 345 | 23 |  |  | C | 2023 | 2342 | Y |  | C | 2023 | 2342 | Y
 | D | 146 | 369 | 98 |  |  | D | 2023 | 12 | Y |  | D | 2023 | 12 | Y
 | F | 515 | 243 | 643 |  |  | A | 2023 | 4234 | Y |  | A | 2023 | 4234 | Y
 | G | 325 | 53 | 42 |  |  | D | 2023 | 134 | Y |  | D | 2023 | 134 | Y
 | E | 453 | 54 | 123 |  |  | F | 2023 | 515 | Y |  | F | 2023 | 515 | Y
 |  |  |  |  |  |  | G | 2023 | 325 | Y |  | G | 2023 | 325 | Y
 |  |  |  |  |  |  | E | 2023 | 453 | Y |  | E | 2023 | 453 | Y
 |  |  |  |  |  |  | B | 2022 | 5675 | Y |  | A | 2022 | 6 | N
 |  |  |  |  |  |  | C | 2022 | 345 | Y |  | B | 2022 | 5675 | Y
 |  |  |  |  |  |  | D | 2022 | 24 | Y |  | C | 2022 | 345 | Y
 |  |  |  |  |  |  | D | 2022 | 345 | Y |  | D | 2022 | 24 | Y
 |  |  |  |  |  |  | F | 2022 | 243 | Y |  | A | 2022 | 35 | N
 | When only one array is passed: |  |  |  |  |  | G | 2022 | 53 | Y |  | D | 2022 | 345 | Y
 |  |  | 2022 | 2021 |  |  | E | 2022 | 54 | Y |  | F | 2022 | 243 | Y
 |  |  |  |  |  |  | A | 2021 | 4654 | Y |  | G | 2022 | 53 | Y
 | B | 345 |  |  |  |  | B | 2021 | 234 | Y |  | E | 2022 | 54 | Y
 | C | 2342 |  |  |  |  | C | 2021 | 23 | Y |  | A | 2021 | 4654 | Y
 | D | 146 |  |  |  |  | D | 2021 | 64 | Y |  | B | 2021 | 234 | Y
 | F | 515 |  |  |  |  | D | 2021 | 34 | Y |  | C | 2021 | 23 | Y
 | G | 325 |  |  |  |  | F | 2021 | 643 | Y |  | D | 2021 | 64 | Y
 | E | 453 |  |  |  |  | G | 2021 | 42 | Y |  | A | 2021 | 75 | N
 |  |  |  |  |  |  | E | 2021 | 123 | Y |  | D | 2021 | 34 | Y
 |  |  |  |  |  |  |  |  |  |  |  | F | 2021 | 643 | Y
 |  |  |  |  |  |  |  |  |  |  |  | G | 2021 | 42 | Y
 |  |  |  |  |  |  |  |  |  |  |  | E | 2021 | 123 | Y
Spreadsheet: 82079d1282135073-data-changes-with-different-number-book-example
Sheet: Totals

sales person | Q | P | S | M | N |  | sales person | Q | P | S | M | N
[NAME] | sale 39 | sale 2 | sale 11 | sale 22 | SALE 14 | <<<<<<     Examples | jonas
 | sale 6 | sale 8 | sale31 | sale32 | sale31 | <<<<<<     Examples
 | sale 6 | sale 4 | sale 4 | sale 13 | sale 9 | <<<<<<     Examples
 | sale 2 | sale 5 | sale 20 | sale 8 | sale 8 | <<<<<<     Examples
 | sale 8 | sale 11 | sale 13 | sale 1 | SALE 34 | <<<<<<     Examples
 | sale 9 | sale31 | sale 24 | sale 11 | sale 2 | <<<<<<     Examples
 | sale 1 | sale 4 | sale 90 | SALE 40 | sale 24 | <<<<<<     Examples
 | SALE 4 | sale 9 | sale 8 | sale 33 | sale 13 | <<<<<<     Examples
 | SALE 88 | sale 1 | sale 9 | sale77 | SALE 2 | <<<<<<     Examples
 | SALE 10 | sale 11 | sale 1 | sale 65 | sale 8 | <<<<<<     Examples
sales person | Q | P | S | M | N |  | sales person | Q | P | S | M | N
[NAME] |  |  |  |  |  |  | oliver
sales person | Q | P | S | M | N |  | sales person | Q | P | S | M | N
padear |  |  |  |  |  |  | fran
Spreadsheet: louise_kitchen__22773__kevin
Sheet: Leave

Trading | Marketing
Majajan, Ashish | [NAME], [NAME]
Rawal, Punit | Blair, Greg
[NAME], Dustin | Quinn, [NAME]
Campbell, [NAME] | Gurrola, [NAME]
[NAME], Cory | Gonzales, [NAME]
Aggawal, Anabhau | Wang, ChuChu
Maskell, [NAME] | Moore, [NAME]
Pan, [NAME] | Marks, [NAME]
Mack, [NAME] | [NAME], [NAME]
Gulmeden, Utku | Clifford, Doug
[NAME], Clint | [NAME], [NAME]
Rbroussard, [NAME] | Ratliff, [NAME]
Ha, Amie | Carroll, Lex
[NAME], [NAME] | [NAME], [NAME]
Clynes, [NAME] | [NAME], Nick
[NAME], Gretchen | [NAME], [NAME]
Olinde, [NAME] | Letzerich, Palmer
Jenkins, [NAME] | Sell, Maxmillion
Benjellom, [NAME] | Heintzelman, [NAME]
[NAME], [NAME] | Yosovitz, [NAME]
Pace, [NAME] | [NAME], Terrell
DeCook, Todd | Duffy, [NAME]
Woulfe, [NAME] | Piazze, [NAME]
Laverell, Justin | [NAME], [NAME]
Pan, [NAME] | Emmons, [NAME]
Vargas, [NAME] | Day, Amanda
[NAME], [NAME] | [NAME], [NAME]
Emisih, [NAME] | [NAME], [NAME]
Kumar, Madup | Churbock, Scott
[NAME], [NAME] | Grube, Raimond
Capasso, [NAME] | Krause, Greg
Shupe, [NAME] | Hernandez, [NAME]
 | Krimskey, [NAME]
 | Hausinger, [NAME]
 | Inman, [NAME]
 | Reyes, [NAME]
 | Lewis, [NAME]
 | Cavasos, Brandon
 | Compean, [NAME]
 | Seksaria, Rahul
 | Marks, [NAME]
 | [NAME], [NAME]
 | Laudry, Chad
 | Gimble, [NAME]
 | Tricoli, [NAME]
Spreadsheet: 179431d1347262520-two-dimensional-vlook-up-find-team-reporting-to-shift-sample_workbook_w_reporting_team
Sheet: Shift Roaster

Reporting Team | Team 1 Member 1 | Team 1 Member 2 | Team 2 Member 1 | Team 2 Member 2 | Team 3 Member 1 | Team 3 Member 2 | Team 4 Member 1 | Team 4 Member 2 | Team 5 Member 1 | Team 5 Member 2
2012-09-01 00:00:00 | OFF | OFF | B | B | C | C | A | A | OFF | OFF
2012-09-02 00:00:00 | OFF | OFF | B | B | C | C | A | A | OFF | OFF
2012-09-03 00:00:00 | A | A | B | B | OFF | OFF | A | A | C | C
2012-09-04 00:00:00 | A | A | B | B | OFF | OFF | OFF | OFF | C | C
2012-09-05 00:00:00 | A | A | B | B | B | B | OFF | OFF | C | C
2012-09-06 00:00:00 | A | A | OFF | OFF | B | B | C | C | C | C
Timing | Shift
06:00 - 14:00 | A
14:01 - 22:00 | B
22:01 - 05:59 | C
Start Shift | End Shift
 |  | C
 |  | A
 |  | B
 |  | C
Spreadsheet: 136559d1326723789-how-do-i-calculate-the-value-in-a-column-within-a-particular-month-book5
Sheet: Sheet1

Date | Total
2012-01-02 00:00:00 | 10
2012-01-30 00:00:00 | 10
2012-02-02 00:00:00 | 10
2012-01-01 00:00:00 | 10
2012-01-24 00:00:00 | 10
2012-03-05 00:00:00 | 10
2012-03-30 00:00:00 | 40
Summary for Jan | #N/A
Summary for Feb | #N/A
Spreadsheet: 777462d1650392824-counting-distinct-values-within-a-date-range-feeod-sample
Sheet: Revisits&Visits per region

Region | (All)
Row Labels | Sum of Actual revisits
BX0004Z | 0
BX0022WA | 0
CH0077WA
DC1067Z | 8
DC1097Z | 3
DN0063WA | 0
HNYJ401A | 0
HNYL801A | 0
IEY5007A | 1
NJ0045Z
NJ0048Z | 2
NY0091WA | 0
NY0091Z | 0
PH0113Z | 0
PH0114Z | 0
PH0124Z | 2
PXY8201A | 3
[NAME] | 2
SEY6701A | 0
SFY5042A | 5
SFY5060A | 2
SFYL101A | 3
SFYL601A | 3
Site ID | -1
SL0215WA
SL0221WA
SL0607WA | 2
SVY5014A | 6
SVY5024A
[NAME] | 4
TU1624WA | 4
VA1066Z
VGY6601A | 1
WI1625WA | 1
(blank)
Grand Total | 51
Spreadsheet: 6a034750-e141-4cd1-a6bf-68881f5273a9
Sheet: GL Summary

Row Labels | Sum of Device Total Click Charge
Academic Advising | 22.9
Administrative | 655.2242
Admissions Office | 642.5596999999999
AOF - Academic Advising | 168.8538
Auxiliary Administration | 49.2897
AUX-Laundry & Pressing | 36.3147
AUX-Military Store | 173.8256
AUX-Student Health | 155.5503
AUX-Tailor Shop | 31.702
Business Executive | 31.9954
Cameron Physics & Astronomy | 209.4708
Career Services and Placement | 51.5878
Carroll Biology Fund | 213.8079
Center for Leadership & Ethics | 165.669
Chemistry | 344.6245
Civil Engineering | 245.0545
Communications & Marketing | 18.5103
Comptroller's Office | 247.9725
[NAME] of the Faculty | 101.3413
Duplicating | 2196.0409
Economics | 761.4982
Electrical Engineering | 45.24700000000001
English | 385.5756
Football | 254.5612
History | 92.08940000000001
Honor Court | 18.2628
Institute Planning | 370.0399
Institute Writing Program | 29.2568
Institutional Analysis | 4.1487
International Programs | 37.1116
International Studies Depart | 231.1683
IST | 159.2947
Learning Programs | 76.5826
Libraries | 725.3218999999999
Mathematics | 454.2988
Mechanical Engineering | 314.9486
Modern Languages | 94.0842
Museum | 300.6713999999999
Office of Construction | 222.8963
Personnel Administration | 162.7875
Philosophy & Psychology | 230.488
Physical Education | 116.2542
Physical Plant Administration | 222.1832
Post Mail | 36.2871
Printer Services | 2600.5203
Protocol Office | 10.0824
Purchasing Office | 55.8279
Registration & Records | 221.3486
ROTC-Air Force | 0
ROTC-Army | 451.1999
ROTC-Navy | 5.633
Soccer | 7.807600000000001
Soccer - Women | 6.2094
Sports Information | 18.2781
Student Union | 9.1791
Superintendents Office | 498.3220999999999
Track & Cross Country | 12.4712
Treasurers Office | 46.4526
UMA-Band | 13.869
UMA-Commandant's Office | 324.6954
UMA-Counselors Office | 53.9028
Undergraduate Research | 22.4105
(blank)
Biology | 7.467000000000001
Drug & Alcohol Abuse | 34.6753
Financial Aid Administration | 110.9046
Post Security | 140.1919
Stone [NAME] House | 64.3735
Math Education Resource Center | 14.0835
Grand Total | 15837.2586
Spreadsheet: 69828d1270501475-virtual-array-in-a-formula-book21
Sheet: Sheet1

Source: | Difference: | Accumulative:
2 | 2 | 2
4 | 2 | 6
8 | 4 | 14
9 | 1 | 23
13 | 4 | 36
14 | 1 | 50
12 | -2 | 62
17 | 5 | 79
2 |  | I'm looking for some [NAME] of that type
{2;2;4;1;4;1;-2;5} |  | I want it to hold all the Accumulatives like range C3:C10
Array of all Diffs |  | {2;6;14;23;36;50;62;79}
Spreadsheet: 220484d1363179873-group-up-same-values-and-provide-total-sample-data1
Sheet: PROJECT PRICES

FRAME | PARTCODE |  | QTY
A
 | PFBLT
 | NUTLM10ZP
B
 | PFBLT
 | NUTLM10ZP
C
 | PFBLT
 | NUTLM10ZP
D
 | PFBLT
 | NUTLM10ZP
E
 | PFBLT
 | NUTLM10ZP
SHIMS & FLOOR FIXINGS
 | PLP2UN
 | PLP3UN
 | [NAME]
 | PNALP3UN
 | BLTBFF1240ZP
ROW SPACERS
RUN 1
RUN 2
RUN 3
RUN 4
RUN 5
 | PJBLTZP
 | NUTLM8ZP
 | BLTM10120ZP
 | NUTLM10ZP
BEAM TYPES
A1
A2
B1
B2
C1
C2
D1
D2
E1
E2
 | PBL
Spreadsheet: 537821d1505287463-need-formula-assistance-formula-vlookup
Sheet: Sheet1

Head | [NAME] | Loc2 | Loc3 | Loc4 | Loc5 | Loc6 | Loc7 | Loc8 | Loc9 | Loc10 | Loc11 | Loc12 | Loc13 | Loc14
AXA | KARACHI  [I] | KARACHI  [E] | MUNDRA  [E] | SOHAR  [E] | JEBEL ALI  [E] | BAHRAIN  [E] | SHUAIBA  [E] | UMM QASR  [E] | UMM QASR  [I] | BAHRAIN  [I] | ABU DHABI  [I] | [NAME]  [I] | JEBEL ALI  [I] | SOHAR  [I]
AXA
 | Export | Import
??? | Data should be in continuous order. Need to avoid the gap in between the data
Spreadsheet: 147930d1333039358-data-validation-and-vlookup-counts
Sheet: Medical Director-69

Medical Director: | 69
Job Title | Count |  | Employed Type | Count
MD | 1 |  | Independent - Retail | 0
[NAME] | 1 |  | Chain - Retail | 0
aygpzc | 1 |  | Hospital | 0
CMA, CCRC | 1 |  | Consultant | 0
CNA | 1 |  | Institutional - Other | 0
CPMSM CPCS | 1 |  | Retired | 0
[NAME] | 1 |  | Unemployed | 0
DO | 1
Dr | 1
Dr. | 1
Etc | 1
Instructor | 1
M.D. | 3
MA | 2
mayhlobtmb | 1
MD | 22
MD FACR | 1
MD, DPH | 1
MD, PharmD | 1
MD, RPh | 1
Medical Assistant | 1
MFJUYgbmhvayvFHLmnm | 1
ND | 1
NMD, PhD | 1
Pharm.D. | 2
PharmD | 7
PhD | 1
PMP Director | 1
RMA | 1
RN | 3
RPh | 2
RPh, MD | 1
RPh, PhD | 1
tgvorhvvsa | 1
viagra sale b | 1
Spreadsheet: ffb1c8a7-1c5c-4a8e-be56-27c26de4caad
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
PBGD_ | Test | PBGD_ | [NAME] (PBGD), [NAME] | PBG Deaminase, WB | Enzymatic End point/Spectrofluorometric |  |  |  | 4 | mL | All porphyrin tests on whole blood can be performed on 1 draw tube.    Container/Tube:  Preferred: Green top (sodium heparin) Acceptable: Lavender top (EDTA) or green top (lithium heparin) [NAME]: Full tube Collection Instructions: 1. Patient should abstain from alcohol for 24 hours. 2. Immediately place specimen on wet ice. Additional Information: Include a list of medications the patient is currently taking. Forms: If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | 3 mL | Hemolysis	Mild reject; Gross reject Thawing	NA Lipemia	NA Icterus	NA Other	NA | Reference ranges have not been established for patients who are <16 years of age.   > or =7.0 nmol/L/sec 6.0-6.9 nmol/L/sec (indeterminate) <6.0 nmol/L/sec (diminished) | Monday through Friday; 8 a.m. | 2 days (not reported on Saturday or Sunday) | 3 days | 1 | 82657 |  |  |  |  | Rochester
PBGD_ | [NAME] | BLOOD | Whole blood |  |  |  | Refrigerated | 7 days
PBGD_ | Result | 4022 | PBG Deaminase, WB | PBG Deaminase, WB | Numeric |  |  |  |  | nmol/L/sec |  |  |  |  |  |  |  |  |  | 2812-6 | Porphobilinogen deaminase:CCnc:Pt:RBC:Qn:
PBGD_ | Result | 28400 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59462-2
Spreadsheet: 856795d1705983711-trim-function-is-not-working-to-remove-leading-trailing-space-find-replace-also-trim-space
Sheet: Sheet1

 | Model | Cost SheetCash Price | Field Cash Price | Cost Sheet Credit | Cash Back | Field Cash Back | Minimum Appvd. DP | DP for Field by PP
 | TATA ACE EX2 | 905000 | 955000 | 1130000 | 125000 | 100000 | 100000 | 150000
 | trim() function =>
 | replace space (Ctrl+H) is not working also
Spreadsheet: 807696d1670000055-incremental-increase-based-on-cell-value-incremtn-increase-based-on-cell-value
Sheet: Sheet1

Month Offset | 5
Price | 2
Sq.Ft | 800
Vacancy Chart | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12
Leased Sq.Ft
Price
 |  |  |  |  |  |  |  |  |  | why is this 0 | why is this 0 | why is this 0
 |  |  |  |  |  | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 1
 |  |  |  |  | Here are some percentage ideas - the last cell wont always be 100%,  the number in B3 has to be at least 6 for Month 12 to be 100%, but if the offset is less than 5 there should be more 100%'s due to total estimated time to 100% being 6 months