tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 77487d1277941235-calculating-time-between-2-events-that-cross-midnight-sys_outage_duration_calc_example
Sheet: Sheet1

Start Date | Start Time | End Date | End Time | Duration
2010-06-27 00:00:00 | 01:00:00 | 2010-06-27 00:00:00 | 03:00:00 | 120 | mins
2010-06-28 00:00:00 | 16:30:00 | 2010-06-28 00:00:00 | 17:15:00 | 45 | Mins
2010-06-28 00:00:00 | 8:00pm | 2010-06-29 00:00:00 | 02:20:00
This is potentially 1000's of entries so need to be able to calculate it.
I am looking for a calculation or VBA coding that will allow me to calculate the duration between start time and end time in minutes when the time could span across multiple hours or days.
Spreadsheet: 142402d1329824728-processing-data-from-multiple-sheets-and-making-report-sample-file
Sheet: Sheet3

Quantity | Product/Item Code. | Description. | Unit Price. | Extended. | Remarks.
25 | MH-A0800 | Guantlets. Size: 9 . | 55
10 | MH-A0800B | Guantlets. Size: 9 . | 57
5 | MH-H0854 | Helmet . | 20
 |  | Freight: |  | 340
 |  | G.Total:
CTNS # | Item # | Packing List
 |  | Description
1 | MH-A0800 | 2 Pair. Guantlets. [NAME]: 9 .
 | MH-A0800B | 10 Pair. Guantlets. [NAME]: 9 .
2 | MH-A0800 | 12 Pair. Guantlets. [NAME]: 9 .
3 | MH-A0800 | 9 Pair. Guantlets. [NAME]: 9 .
4 | MH-A0800 | 2 Pair. Guantlets. [NAME]: 9 .
 | MH-H0854 | 5 Pcs. Helmet.
Spreadsheet: 1879cdb1-22f2-4152-8034-77f5a044e763
Sheet: Sheet1

American Youth Soccer Organization - AYSO | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Region 144 - South Irvine
Youth Referee Participation Form
Youth Referee:
Date | Division Game | Field | Hours | Comment
Total Hours |  |  | 0
I verified that the Youth Referee named above completed the Community Service hours indicated above during his/her participation in AYSO Region 144 sponsored soccer games.
The time spent by this Youth Referee officiating children's soccer games is greatly appreciated.
Eduardo Mier y [NAME] |  |  | Date:
Regional Referee Administrator
Region 144 - South Irvine
[EMAIL]
Spreadsheet: 73098d1273754814-xy-scatter-chart-non-continuous-date-ranges-weekly-data
Sheet: Data

2009-08-03 00:00:00 | 27.83581601020345 | 40028
2009-08-10 00:00:00 | 27.54884883484053 | 40035
2009-08-17 00:00:00 | 27.40536524715906 | 40042
2009-08-24 00:00:00 | 26.97491448411468 | 40049
2009-08-31 00:00:00 | 27.40536524715906 | 40056
2009-09-07 00:00:00 | 26.97491448411468 | 40063
2009-09-14 00:00:00 | 26.83143089643322 | 40070
2009-09-21 00:00:00 | 27.2618816594776 | 40077
2009-09-28 00:00:00 | 26.97491448411468 | 40084
2009-10-05 00:00:00 | 26.68794730875176 | 40091
2009-10-12 00:00:00 | 26.68794730875176 | 40098
2009-10-19 00:00:00 | 26.5444637210703 | 40105
2009-10-26 00:00:00 | 26.68794730875176 | 40112
2010-03-01 00:00:00 | 27.97929959788491 | 40238
2010-03-08 00:00:00 | 27.83581601020345 | 40252
2010-03-15 00:00:00 | 27.83581601020345 | 40280
2010-04-12 00:00:00 | 27.83581601020345 | 40287
2010-04-19 00:00:00 | 27.83581601020345 | 40294
2010-04-26 00:00:00 | 27.83581601020345 | 40301
2010-05-03 00:00:00 | 27.54884883484053 | 40308
2010-05-10 00:00:00 | 27.40536524715906 | 40315
2010-05-17 00:00:00 |  | 40322
2010-05-24 00:00:00 |  | 40329
2010-05-31 00:00:00 |  | 40336
2010-06-07 00:00:00 |  | 40343
2010-06-14 00:00:00 |  | 40350
2010-06-21 00:00:00 |  | 40357
2010-06-28 00:00:00 |  | 40364
2010-07-05 00:00:00 |  | 40371
2010-07-12 00:00:00 |  | 40378
2010-07-19 00:00:00 |  | 40385
2010-07-26 00:00:00 |  | 40392
2010-08-02 00:00:00 |  | 40399
2010-08-09 00:00:00 |  | 40406
2010-08-16 00:00:00 |  | 40413
2010-08-23 00:00:00 |  | 40420
2010-08-30 00:00:00 |  | 40427
2010-09-06 00:00:00 |  | 40434
2010-09-13 00:00:00
Spreadsheet: chris_germany__2124__DecCohCHOICE-ENA
Sheet: Dec 22

 | COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2000-12-22 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 2381 |  | 2381 |  | 67694 |  |  |  |  |  | 8 | 1 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 2 | 4
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 10619 |  | 12552 |  | 67694 |  |  |  |  |  | 8 | 3 | 3 |  |  | 15
 |  |  |  |  |  |  |  |  | 5000 |  | 5000 |  | 68918 | 0 |  |  |  |  | 9 | 4 | 3 |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 5 | 5 |  |  | 15
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 4186 |  | 4956 |  | 67694 |  |  |  |  |  | 7 | 6 | 3 |  |  | 22
 |  |  |  |  |  |  |  |  | 1535 |  | 1535 |  | 68915 | 0 |  |  |  |  | 9 | 7 | 3 |  |  | 15
 |  |  |  |  |  |  |  |  | 1540 |  | 1540 |  | 69693 | 0 |  |  |  |  | 8 | 8 | 6 |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 9 | 4 |  |  | 20
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 26844 |  | 30761 |  | 67694 |  |  |  |  |  | 9 | 15 | 9 |  |  | 16
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69149 | 0 |  |  |  |  | 8 | 35 | 5 |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  | 68915 | 0 |  |  |  |  | 9 | 39 | 3 |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  | 68918 | 0 |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 3354 |  | 3856 |  | 67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1864 |  | 2330 |  | 67694 |  |  |  |  |  | Storage
 |  |  |  |  |  |  |  |  | 673 |  | 673 |  | 69149 | 0 |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  | 1915 |  | 1915 |  | 68916 | 0 |  |  |  |  | 0.6
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 25387 |  | 27885 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 4129 |  | 4549 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 6563 |  | 6793 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 8213 |  | 8791 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 2384 |  | 2618 |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 65 |  | 71 |  | 67694 | 1
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: kevin_hyatt__19629__TWexpSta14O&M
Sheet: Station 1

Station 1 - Selgman
Asset 0022
2000 O&M Costs
 | Jan-June | July-Dec | Annual
Payroll |  | 138421
Benefits |  | 19003
Employee Expense |  | 4087
Company Equipment Use |  | 9938
Supplies & Expenses
Environmental |  | 12040
Utilities |  | 20264
Other G&A |  | 0
Outside Services |  | 26395
Total Cost Jan-June | 268092
Grand Total
Payroll Taxes |  | 7182
These are actual costs for the year 2000 and are
NOT Avoidable O&M Costs.  Depending on the status
of personnel, payroll and employee associated expenses
may not be avoidable to Enron.
In addition, depending on the status of the asset, lubricants and
other supplies may be necessary.
Spreadsheet: 769990d1645773002-formula-for-percentage-value
Sheet: Sheet1

 | Value | % | Tax1 | Tax2 | Tax3
 | 98397.59 | [NAME] to find Percentage | 0 | 0 | 17711.57
 | 34536.5 | [NAME] to find Percentage | 3108 | 3108 | 0
 | 77028.41 | [NAME] to find Percentage | 0 | 0 | 13865.11
 | 9674.2 | [NAME] to find Percentage | 871 | 871 | 0
Spreadsheet: 99500d1298112613-time-sheet-conversion-timesheet_conversion
Sheet: Sheet2

Date | Project | Hours
1 | Project B | 3
1 | Project C | 5
2 | Project A | 6
2 | Project B | 2
5 | Project A | 4
5 | Project B | 4
5 | Project C | 2
6 | Project A | 5
6 | Project B | 2
6 | Project C | 1
7 | Project A | 6
7 | Project C | 2
Spreadsheet: 804282d1667985619-dynamic-array-horizontal-lookup-across-2d-range-index_match_of_dynamic_2d_array-1-
Sheet: Sheet1

Phase1 |  | Phase2 |  | Phase3 |  | Phase4 |  | Phase5 |  | Phase6 |  | Phase with most recent date/time |  | Dynamic array: Phase with most recent date/time
2020-02-13 10:48:40 |  | 2020-02-14 10:48:40 |  | 2020-02-10 00:00:00 |  | 2020-02-11 00:00:00 |  | 2020-02-19 00:00:00 |  | 2020-02-17 00:00:00
2020-02-26 11:39:33 |  | 2020-02-27 11:39:33 |  | 2020-02-14 00:00:00 |  | 2020-02-21 00:00:00 |  |  |  | 2020-02-24 00:00:00 |  | Phase2
2020-02-26 11:39:33 |  |  |  | 2020-02-14 00:00:00 |  | 2020-02-21 00:00:00 |  | 2020-02-25 00:00:00 |  | 2020-02-24 00:00:00 |  | Phase1
2020-02-29 07:50:18 |  | 2020-02-28 07:50:18 |  | 2020-02-14 00:00:00 |  | 2020-02-21 00:00:00 |  | 2020-02-25 00:00:00 |  | 2020-02-24 00:00:00 |  | Phase1
2020-02-26 12:24:40 |  | 2020-02-27 11:24:40 |  |  |  | 2020-02-21 00:00:00 |  | 2020-02-25 00:00:00 |  | 2020-02-28 00:00:00 |  | Phase6
2020-02-26 12:00:21 |  | 2020-02-27 12:00:21 |  | 2020-02-27 00:00:00 |  | 2020-02-24 00:00:00 |  | 2020-03-04 00:00:00 |  | 2020-03-02 00:00:00 |  | Phase5
 |  |  |  |  |  |  |  |  |  |  |  | Phase1
2020-03-04 12:27:31 |  | 2020-03-05 12:27:31 |  | 2020-02-27 00:00:00 |  |  |  | 2020-03-04 00:00:00 |  | 2020-03-03 00:00:00 |  | Phase2
 |  | 2020-03-06 09:31:49 |  | 2020-02-27 00:00:00 |  | 2020-03-03 00:00:00 |  | 2020-03-04 00:00:00 |  |  |  | Phase2
2020-03-05 09:31:49 |  | 2020-03-06 09:31:49 |  | 2020-02-27 00:00:00 |  | 2020-03-03 00:00:00 |  | 2020-03-04 00:00:00 |  | 2020-03-17 00:00:00 |  | Phase6
2020-03-03 08:03:58 |  | 2020-03-04 08:03:58 |  | 2020-02-27 00:00:00 |  | 2020-03-03 00:00:00 |  | 2020-03-04 00:00:00 |  | 2020-03-05 00:00:00 |  | Phase6
Spreadsheet: 770911d1646330079-ledger-transfering-to-monthly-calendar-book2
Sheet: Reference Lists

Business Meals | 764
Employee Benefit Meals | 250
Floor Stock/Pantry Supplies | 494
[NAME] | 414
Medical Staff Meals | 971
Non-Food Supplies | 437
Volunteer Meals | 414
Credit Card
In House
Hospital Standard
Med Staff
Business Meals
Employee Benefit Meals
Medical Staff Meals
Volunteer Meals
Spreadsheet: 683326d1592640090-transpose-from-columns-to-rows-with-power-query-pq-transform-rows-to-columns-aligw
Sheet: from

DATE | PART 1 | PART 2 | PART 3 | PART 4 | PART 5 | PART 6 | PART 7 | PART 8 | PART 9 | PART 10 | PART 11 | PART 12 | PART 13 | PART 14
2020-01-01 00:00:00 | 1 | 23 | 34 | 45 | 47 | 49 | 51 | 53 | 55 | 57 | 59 | 61 | 63 | 65
2020-01-02 00:00:00 | 2 | 23 | 34 | 89 | 91 | 93 | 95 | 97 | 99 | 101 | 103 | 105 | 107 | 109
2020-01-03 00:00:00 | 3 | 23 | 34 | 133 | 135 | 137 | 139 | 141 | 143 | 145 | 147 | 149 | 151 | 153
2020-01-04 00:00:00 | 4 | 23 | 34 | 177 | 179 | 181 | 183 | 185 | 187 | 189 | 191 | 193 | 195 | 197
2020-01-05 00:00:00 | 5 | 23 | 34 | 221 | 223 | 225 | 227 | 229 | 231 | 233 | 235 | 237 | 239 | 241
2020-01-06 00:00:00 | 6 | 23 | 34 | 265 | 267 | 269 | 271 | 273 | 275 | 277 | 279 | 281 | 283 | 285
2020-01-07 00:00:00 | 7 | 23 | 34 | 309 | 311 | 313 | 315 | 317 | 319 | 321 | 323 | 325 | 327 | 329
2020-01-08 00:00:00 | 8 | 23 | 34 | 353 | 355 | 357 | 359 | 361 | 363 | 365 | 367 | 369 | 371 | 373
2020-01-09 00:00:00 | 9 | 23 | 34 | 397 | 399 | 401 | 403 | 405 | 407 | 409 | 411 | 413 | 415 | 417
2020-01-10 00:00:00 | 10 | 23 | 34 | 441 | 443 | 445 | 447 | 449 | 451 | 453 | 455 | 457 | 459 | 461
2020-01-11 00:00:00 | 11 | 23 | 34 | 485 | 487 | 489 | 491 | 493 | 495 | 497 | 499 | 501 | 503 | 505
2020-01-12 00:00:00 | 12 | 23 | 34 | 529 | 531 | 533 | 535 | 537 | 539 | 541 | 543 | 545 | 547 | 549
2020-01-13 00:00:00 | 13 | 23 | 34 | 573 | 575 | 577 | 579 | 581 | 583 | 585 | 587 | 589 | 591 | 593
2020-01-14 00:00:00 | 14 | 23 | 34 | 617 | 619 | 621 | 623 | 625 | 627 | 629 | 631 | 633 | 635 | 637
2020-01-15 00:00:00 | 15 | 23 | 34 | 661 | 663 | 665 | 667 | 669 | 671 | 673 | 675 | 677 | 679 | 681
2020-01-16 00:00:00 | 16 | 23 | 34 | 705 | 707 | 709 | 711 | 713 | 715 | 717 | 719 | 721 | 723 | 725
2020-01-17 00:00:00 | 17 | 23 | 34 | 749 | 751 | 753 | 755 | 757 | 759 | 761 | 763 | 765 | 767 | 769
2020-01-18 00:00:00 | 18 | 23 | 34 | 793 | 795 | 797 | 799 | 801 | 803 | 805 | 807 | 809 | 811 | 813
2020-01-19 00:00:00 | 19 | 23 | 34 | 837 | 839 | 841 | 843 | 845 | 847 | 849 | 851 | 853 | 855 | 857
2020-01-20 00:00:00 | 20 | 23 | 34 | 881 | 883 | 885 | 887 | 889 | 891 | 893 | 895 | 897 | 899 | 901
2020-01-21 00:00:00 | 21 | 23 | 34 | 925 | 927 | 929 | 931 | 933 | 935 | 937 | 939 | 941 | 943 | 945
2020-01-22 00:00:00 | 22 | 23 | 34 | 969 | 971 | 973 | 975 | 977 | 979 | 981 | 983 | 985 | 987 | 989
2020-01-23 00:00:00 | 23 | 23 | 34 | 1013 | 1015 | 1017 | 1019 | 1021 | 1023 | 1025 | 1027 | 1029 | 1031 | 1033
2020-01-24 00:00:00 | 24 | 23 | 34 | 1057 | 1059 | 1061 | 1063 | 1065 | 1067 | 1069 | 1071 | 1073 | 1075 | 1077
2020-01-25 00:00:00 | 25 | 23 | 34 | 1101 | 1103 | 1105 | 1107 | 1109 | 1111 | 1113 | 1115 | 1117 | 1119 | 1121
Spreadsheet: 20edd15b-427e-4887-87ac-d527ff52b0da
Sheet: Exhibit XV, Page 4

Owners Forms
USAA-GIC
Pennsylvania
Rate Change History
Effective Date | Percent Effect | Dollar Effect (nearest thousand) |  | Description of Changes
2007-02-01 00:00:00 | -0.04 | 0 |  | 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 | 0 |  | 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.084 | 13000 |  | Introduce HO2008 program for Owners and Unit-Owners,
RB**: January 30, 2010 |  |  |  | Introduce Renewal Rate Capping.
NB*: August 14, 2010 | -0.203 | -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 | 65000 |  | Introduce additionally rated catastrophic perils.
 |  |  |  | Introduce a new rating structure for the Earthquake Endorsement.
2012-08-15 00:00:00 | 0.152 | 371000 |  | Introduce new territory boundaries.
* "NB" = "New Business"
** "RB" = "Renewal Business"
Spreadsheet: 42874d1241516836-lookup-date-in-range-depending-on-a-number-master-dummy-journey1
Sheet: WEEK 2

 | PERIOD NUMBER: |  |  | 1 |  |  |  | PERIOD NUMBER: |  |  | 1 |  |  |  | PERIOD NUMBER: |  |  | 1 |  |  |  | PERIOD NUMBER: |  |  | 1 |  |  |  | PERIOD NUMBER: |  |  | 1 |  |  |  | PERIOD NUMBER: |  |  | 1 |  |  |  | PERIOD NUMBER: |  |  | 1
 |  | SUNDAY |  |  |  |  |  |  | MONDAY |  |  |  |  |  |  | TUESDAY |  |  |  |  |  |  | WEDNESDAY |  |  |  |  |  |  | THURSDAY |  |  |  |  |  |  | FRIDAY |  |  |  |  |  |  | SATURDAY
 |  | DATE: |  |  |  |  |  |  | DATE: |  |  |  |  |  |  | DATE: |  |  |  |  |  |  | DATE: |  |  |  |  |  |  | DATE: |  |  |  |  |  |  | DATE: |  |  |  |  |  |  | DATE:
 | DUMMY JOURNEY | WWD | STORE NAME | STORE NUMBER | NAME | TIME |  | DUMMY JOURNEY | WWD | STORE NAME | STORE NUMBER | NAME | TIME |  | DUMMY JOURNEY | WWD | STORE NAME | STORE NUMBER | NAME | TIME |  | DUMMY JOURNEY | WWD | STORE NAME | STORE NUMBER | NAME | TIME |  | DUMMY JOURNEY | WWD | STORE NAME | STORE NUMBER | NAME | TIME |  | DUMMY JOURNEY | WWD | STORE NAME | STORE NUMBER | NAME | TIME |  | DUMMY JOURNEY | WWD | STORE NAME | STORE NUMBER | NAME | TIME
Spreadsheet: 72a40ac2-35a5-4a30-a2f3-a7b387fa0be5
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
FMUSK | Test | FMUSK | [NAME] | MuSK Quantitative Titers Antibody | Radioimmunoassay (RIA) | Plain, Red-Top Tube: Red |  |  | 2 | mL | Draw blood in a plain red-top tube(s), serum gel tube is acceptable. Spin down and send 2 mL of serum refrigerated in a plastic vial. | 1 mL | Specimens other than	Serum Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Negative:	<10 Borderline:	10 Positive:	> or = 20   Test Performed by:	Athena Diagnostics 377 Plantation Street Four Biotech Park Worcester, MA 01605 | Varies | 7 - 14 days | 9 - 16 days | 1 | 83519 |  |  |  |  | Athena Diagnostics
FMUSK | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
FMUSK | Result | Z0082 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 0a41bc10-32fa-4393-ba30-d57d55c908b5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4364 | 15364 | [NAME] | Mantak | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 00:00:00
4364 | 15300 | [NAME] | Smith | CAN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 00:00:00
4364 | 15211 | [NAME] | [NAME] | CAN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 00:00:00
Spreadsheet: 57931d1258141764-excel-2007-time-calculations-conditional-formatting-time_calc3
Sheet: Sheet1

Start "y" | Start Time | Hidden1 | Required Run Time | Hidden2 | Hidden3 | Refresh Time | Hidden4 | OK to Restart
y |  |  | 01:10:00 | 0.0486111111111111
y |  |  | 00:17:00 | 0.01180555555555556
y | 2009-11-13 02:21:56 |  | 01:20:00 | 0.05555555555555555
Spreadsheet: 886233d1736264621-leave-entitlement-calculation-leave-entitlement-calculation
Sheet: Off day (2)

Entitlement | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  | FT | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
 | 2025-12-31 00:00:00 |  |  |  | FT-M | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 |  |  | # Leave Days by Month | Start Month | End Month | # Leave Days in |  |  | # Calendar Days in |  | # [NAME] in |  | Pro-rate Leave in |  |  | Total # Leave Days Entitled | Combined Formula | Using LET
Emp Code | Entity | Join Date | Entitle 2025 | Off days as of 31/12 | Terminated | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total Off |  |  |  |  | Start Month | End Month | Months Between | Start Month | End Month | Start Month | End Month | Start Month | End Month | Months Between
T-124 | FT-M | 2018-12-11 00:00:00 |  |  | 2025-01-08 00:00:00
T-148 | FT | 2022-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
[NAME] | FT-M | 2022-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
[NAME] | FT-M | 2023-12-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
T-154 | FT-M | 2023-12-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
T-166 | FT-M | 2025-07-08 00:00:00 |  |  | 2025-11-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
T-168 | FT | 2024-07-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
T-169 | FT-M | 2024-08-01 00:00:00 |  |  | 2025-06-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
T-171 | FT-M | 2024-08-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
T-175 | FT-M | 2024-08-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
T-176 | FT-M | 2024-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
T-177 | FT | 2024-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
T-178 | FT-M | 2024-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
T-179 | FT-M | 2024-09-01 00:00:00 |  |  | 2025-11-18 00:00:00
T-180 | FT | 2024-09-01 00:00:00
T-181 | FT | 2024-09-01 00:00:00
T-182 | FT | 2024-09-01 00:00:00
T-183 | FT-M | 2025-09-01 00:00:00 |  |  | 2025-11-18 00:00:00
T-184 | FT-M | 2024-09-01 00:00:00
T-185 | FT-M | 2024-09-01 00:00:00
Spreadsheet: 271962d1382119065-isnumber-false-how-do-i-convert-to-number-testproductivty
Sheet: DMS.Productivity

 |  | ACD Call Stats |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SF Cases Logged/Updated |  | Availability and Productivity
 | USER | Inbound | Outbound | offered | Answered | % of Ans | % of ABR | [NAME] | % of flow outs | Total Talk Time | AVG Talk Time | Total Hold Time | AVG Hold Time | Total ACW | AVG ACW | Handle Time | AHT | Count | % to call | Logged at | Logged in | Total Available | Lunch | Logged in/Availability Minus Lunch |  |  | AVG Interactions Per Hour | Utilization
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
Spreadsheet: 57834d1258042955-vlookup-with-multiple-rows-test-data
Sheet: Address

ARCSLST | The Nat Nast Com | pany            11/12/09
10:47:50 | Customer Master | List            Page# | 1
*********************** | ***************************** | *************************** | *
Account# | Store# | Phone1
[NAME] to name | Ship to name | ShipVia
[NAME] to address | Ship to address | Buyer
[NAME] to address | Ship to address | SalesRep
[NAME] to <City/State/Zip | >     Ship to <City/State/Zi | p >      Comm
*********************** | ***************************** | *************************** | *
[NAME] | *MAIN* | [PHONE]
[NAME] | [NAME] | [NAME]
99 Lexington Street | 99 Lexington Street
 |  | 27  House
Waltham, MA, 02452 | Waltham, MA, 02452 | 0
----------------------- | ----------------------------- | --------------------------- | -
ABULL | *MAIN* | -   -
[NAME] | [NAME] | [NAME]
[NAME]. | [NAME].
 |  | 27  House
Lake Geneva, WI, 53147 | Lake Geneva, WI, 53147 | 8
----------------------- | ----------------------------- | --------------------------- | -
ACEDG | *MAIN* | [PHONE]
Ace Dry Goods | Ace Dry Goods | [NAME]
78 South Broadway | 78 South Broadway
 |  | 41  [NAME]
Denver, CO, 80209 | Denver, CO, 80209 | 2
----------------------- | ----------------------------- | --------------------------- | -
ADESS | *MAIN* | [PHONE]
[NAME] | [NAME] | [NAME]
19071 Old Detroit Road | 19071 Old Detroit Road
ALDOS | *MAIN* | [PHONE]
Aldo's Uomo | Aldo's Uomo | [NAME]
4224 Maple Road | 4224 Maple Road | [NAME]
 |  | 33  [NAME]
Amherst, NY, 14226 | Amherst, NY, 14226 | 8
----------------------- | ----------------------------- | --------------------------- | -
ALNDL | *MAIN* | [PHONE]
Alandales | Alandales | [NAME]
9715 Washington Blvd. | 9715 Washington Blvd. | [NAME]
 |  | 21  Ralph & Mary J | o
Culver City, CA, 90232 | Culver City, CA, 90232 | 8
----------------------- | ----------------------------- | --------------------------- | -