tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: john_griffith__15738__10_16_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL X1 | 22 | 60 | 80 | 65.3 | 87 | 1.05 | 2001-10-16 10:11:00
 | CL Z1 | 22.5 | 270 | 285 | 53.5 | 56.5 | 0.78 | 2001-10-16 10:11:00
 | CL F2 | 22.5 | 350 | 370 | 48.9 | 51.7 | 0.71 | 2001-10-16 10:11:00
 | CL G2 | 22.5 | 420 | 435 | 47.2 | 48.9 | 0.68 | 2001-10-16 10:11:00
 | CL H2 | 23 | 450 | 470 | 43.3 | 45.2 | 0.64 | 2001-10-16 10:11:00
 | CL J2 | 23 | 470 | 490 | 40.7 | 42.5 | 0.6 | 2001-10-16 10:11:00
 | CL K2 | 22.5 | 490 | 510 | 39.5 | 41.1 | 0.57 | 2001-10-16 10:11:00
 | CL M2 | 22.5 | 500 | 520 | 37.6 | 39.1 | 0.54 | 2001-10-16 10:11:00
 | CL N2 | 22.5 | 515 | 535 | 36.2 | 37.6 | 0.52 | 2001-10-16 10:11:00
 | CL Q2 | 22.5 | 520 | 540 | 34.7 | 36 | 0.5 | 2001-10-16 10:11:00
 | CL U2 | 22.5 | 520 | 540 | 33.1 | 34.4 | 0.48 | 2001-10-16 10:11:00
 | [NAME] | 22.5 | 525 | 545 | 31.8 | 33.1 | 0.46 | 2001-10-16 10:11:00
 | [NAME] | 22 | 530 | 550 | 30.6 | 31.8 | 0.43 | 2001-10-16 10:11:00
 | CL M3 | 21.5 | 530 | 570 | 26.6 | 28.7 | 0.37 | 2001-10-16 10:11:00
 | CL Z3 | 21.5 | 530 | 570 | 23.8 | 25.6 | 0.33 | 2001-10-16 10:11:00
Spreadsheet: 668999d1585156865-move-rows-to-separate-sheets-new-budget-test
Sheet: Sheet1

Date | Vendor | Item | P.O.# | Amount | Acct Code
2020-02-25 00:00:00 |  | Envelopes | 5001900090 | 52.21 | 2100217550
2020-08-28 00:00:00 |  | Medicaid Billing | 8301900006 |  | 2100217310
2019-08-29 00:00:00 |  | Office Supplies | 8301900009 | 33.58 | 2100215610
2019-09-06 00:00:00 |  | WASWUG Fall Conference (BK) | 8301900015 | 375 | 2100217580
2019-09-06 00:00:00 |  | Office Supplies | 8301900017 | 95.53 | 2100215610
2019-09-13 00:00:00 |  | SPED Programs Targeted Review | 8301900027 | 4500 | 2100217340
2019-09-13 00:00:00 |  | SPED Programs Targeted Review | 8301900027 | 682.08 | 2100218580
2019-10-15 00:00:00 |  | Hotel for WASWUG (BK) | 8301900045 | 401.44 | 2100218580
2019-10-22 00:00:00 |  | CPI [NAME] | 8301900052 | 2494.04 | 2100215610
2019-11-07 00:00:00 |  | CPI Snacks | 8301900057 | 48.94 | 2100215610
2019-11-07 00:00:00 |  | 19/20 Membership Dues (HB) | 8301900058 | 934.6 | 2100217810
2019-11-14 00:00:00 |  | Office Supplies | 8301900062 | 429.9 | 2100215610
2018-12-04 00:00:00 |  | Office Supplies | 8301900067 | 21.61 | 2100215610
2019-12-05 00:00:00 |  | CPI Snacks | 8301900069 | 85.33 | 2100215610
2019-12-09 00:00:00 |  | Safety Net Consulting | 8301900074 | 350 | 2100217340
2019-12-09 00:00:00 |  | Safety Net Consulting | 8301900074 | 98.6 | 2100218580
2019-12-11 00:00:00 |  | Reimbursement for Fingerprinting | 8301900075 | 85.75 | 2100217340
2020-01-14 00:00:00 |  | Safety Net Consulting | 8301900085 | 525 | 2100217340
2020-01-14 00:00:00 |  | Safety Net Consulting | 8301900085 | 49.3 | 2100218580
2020-02-03 00:00:00 |  | Safety Net Consulting | 8301900099 | 1250 | 2100217340
2020-02-03 00:00:00 |  | Safety Net Consulting | 8301900099 | 146.63 | 2100218580
2020-02-25 00:00:00 |  | Address Labels | 8301900101 | 24.65 | 2100215610
2020-03-12 00:00:00 |  | Office Supplies | 8301900105 | 116.72 | 2100215610
2020-03-17 00:00:00 |  | Safety Net Consulting | 8301900107 | 1450 | 2100217340
2020-03-12 00:00:00 |  | Safety Net Consulting | 8301900107 | 195.5 | 2100218580
Spreadsheet: 82868d1282866514-grouping-results-using-multisheet-consolidation-testing2-2
Sheet: US(Need)

 | Country | State | Company1 | Company2 | SP | Pilot | Probability | Value | Month | CriteriaA | CriteriaB | [NAME] | CriteriaD | CriteriaE | CriteriaF | CriteriaG | CriteriaH
 | USA | New York | Becks |  | Scott | Yes | 0.9 | 10 | June | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
 | USA | Florida | Gillette |  | [NAME] | No | 0.1 | 15 | June | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
 | USA | Missouri | Budweiser |  | Mark | Yes | 0.2 | 100 | May | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30
 | USA | Texas | Holston |  | [NAME] | No | 0.3 | 25 | August | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40
 | USA | California | Black Sheep |  | [NAME] | Yes | 0.6 | 55 | April | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50
 |  |  |  |  |  | Total |  | 205
Spreadsheet: 748576d1632222991-top-three-data-with-xlookup-fb-sheet
Sheet: Sheet1

Product | Cust | QTY
urea | A1 | 0
urea | B1 | 10 |  |  |  |  |  |  |  | Row Labels | [NAME] of QTY
urea | A2 | 5 |  | DAP |  |  |  |  |  | DAP | 110
urea | A3 | 100 |  | TOP1 |  |  |  |  |  | A1 | 85
urea | A1 | 55 |  | TOP2 |  |  |  |  |  | A2 | 20
urea | B2 | 1 |  | TOP3 |  |  |  |  |  | A4 | 10
urea | A4 | 99 |  |  |  |  |  |  |  | A5 | 80
DAP | A5 | 80 |  |  |  |  |  |  |  | A6 | 74
DAP | A6 | 74 |  | Urea |  |  |  |  |  | B1 | 65
DAP | C1 | 108 |  | TOP1 |  |  |  |  |  | C1 | 108
DAP | C2 | 110 |  | TOP2 |  |  |  |  |  | C2 | 110
DAP | [NAME] | 13 |  | TOP3 |  |  |  |  |  | [NAME] | 13
urea | A4 | 17 |  |  |  |  |  |  |  | urea | 100
DAP | A4 | 10 |  |  |  |  |  |  |  | A1 | 55
urea | C2 | 15 |  |  |  |  |  |  |  | A2 | 79
DAP | A2 | 20 |  |  |  |  |  |  |  | A3 | 100
urea | A2 | 79 |  |  |  |  |  |  |  | A4 | 99
DAP | A1 | 85 |  |  |  |  |  |  |  | B1 | 10
DAP | B1 | 65 |  |  |  |  |  |  |  | B2 | 1
urea | A1 | 5 |  |  |  |  |  |  |  | C2 | 15
DAP | d | 2 |  |  |  |  |  |  |  | (blank)
DAP | f | 23 |  |  |  |  |  |  |  | Grand Total | 110
DAP | h | 65
DAP | kr | 3
DAP | s | 31
DAP | j | 4
DAP | v | 314
Spreadsheet: 27e1dbf7-f1c1-411a-b889-7c91ea7ccb53
Sheet: 8b

Product1 | EUR3 | GBP | [NAME] | USD | AUD | CAD | OTHER | TOTAL
Basis | 10 | 33 | - | 31 | - | 1 | - | 75
Cap/Floor | 1 | 7 | - | 201 | - | 2 | - | 211
Debt Option |  |  |  |  |  |  |  | -
Exotic |  |  |  |  |  |  |  | -
Fixed-Fixed | - | 4 | 1 | 1 | - | - | 25 | 31
Fixed-Float | 1499 | 811 | 1007 | 5609 | 204 | 130 | 1206 | 10466
FRA | 22 | 12 | - | 15 | 87 | 8 | 73 | 217
Inflation | 37 | 39 | - | 30 | 1 | - | - | 107
OIS | 19 | 9 | 3 | 27 | 11 | 10 | 127 | 206
Swaption | 191 | 30 | 79 | 482 | 47 | 2 | 49 | 880
TOTAL | 1779 | 945 | 1090 | 6396 | 350 | 153 | 1480 | 12193
Spreadsheet: 677555d1589395567-how-to-make-a-section-scrollable-original
Sheet: Settings

 | SETTINGS
 | Project
 |  | Name of the Project | My Project Name
 | Team
 |  | Project Manager | [NAME]
 |  | NAME | E-MAIL | PHONE
 |  | Nick | [EMAIL] | [PHONE]
 |  | [NAME] | [EMAIL] | [PHONE]
 |  | [NAME] | [EMAIL] | [PHONE]
 |  | [NAME] | [EMAIL] | [PHONE]
 |  | Caroline | [EMAIL] | [PHONE]
 |  |  | [NAME] new row above this line
Spreadsheet: 33259d1229555854-excel-w-word-drawings-to-pdf-graphical-noise-glitch-graph_example
Sheet: PAGE 2 (3)

A1 | 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 | AA | BB | AC | AD | AE | AF
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32
 | FORMAT |  |  | Set all rows to a height of 14. Set all columns to a width of 2
 |  |  |  | Print area = Cell B2 to Cell AF 53
 |  |  |  | Print area = Cell B2 to Cell AF 51
Spreadsheet: 882564d1730958293-the-formula-to-retrieve-the-name-of-the-replacement-product-tim-ma-thay-the
Sheet: result

CODE | CODE REPLACE |  | CODE | CODE REPLACE
APX M-8720 | APX M-8060
AG-7130R | AG-7070
AG-2065-S | APX-2065-N
AG-7070-T | APX-7070-3
Spreadsheet: 33c08b57-c9fe-4df7-b65a-e2ae843efc7d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Name | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  | Learner ID
 |  |  |  | School/College/University
Arts, Audio/Video Technology and Communications: Visual Arts
Career Pathway Plan of Study for ►Learners ►Parents ►Counselors ►Teachers/Faculty
This Career Pathway Plan of Study (based on the Visual Arts Pathway of the Arts, Audio/Video Technology and Communications [NAME]) can serve as a guide, along with other career planning materials, as learners continue on a career path. Courses listed within this plan are only recommended coursework and should be individualized to meet each learner’s educational and career goals. *This Plan of Study, used for learners at an educational institution, should be customized with course titles and appropriate high school graduation requirements as well as college entrance requirements.
EDUCATION | LEVELS | GRADE | [NAME] | Math | Science | Social Studies/ Sciences | Other Required Courses Other Electives Recommended       Electives                         Learner Activities | *Career and Technical Courses                    and/ or Degree Major Courses for                 Visual Arts Pathway | SAMPLE                                   Occupations Relating                            to This Pathway
 |  | Interest Inventory Administered and Plan of Study Initiated for all Learners
[NAME] |  | 9 |  |  |  |  |  |  | ►Art Director ►Artist ►Commercial Artist ►Commercial Photographer:      Digital, Still, Video, Film ►Commercial/Residential and             .    Home Furnishing Coordinator ►Computer Animator ►Curator and Gallery Manager ►Fashion Designer ►Fashion Illustrator ►Graphic Designer ►Illustrator ►Interior Designer ►Textile Designer
 |  | 10
 |  | 11
 |  | College Placement Assessments-Academic/Career Advisement Provided
 |  | 12
 |  | Articulation/Dual Credit Transcripted-Postsecondary courses may be taken/moved to the secondary level for articulation/dual credit purposes.
POSTSECONDARY |  | Year 13
 |  | Year14
 |  | Year 15
 |  | Year 16
 |  |  |  |  |  | Project funded by the U.S. Department of Education (VO51B020001)
Spreadsheet: 736901d1623937533-hi-all-how-can-i-use-multiple-arguments-in-the-if-formula-new-customer-setup-request-responses-1-
Sheet: DO NOT DELETE - AutoCrat Job Se

Job ID | Job Name | Template ID | Data Sheet ID | [NAME] | First Data Row | File Name | File Type | Share As | Folders | Dynamic Folder Reference | Conditionals | Mode | Append Breaks | Tags | Run On Time Trigger | Time [NAME] | Run On Form Trigger | Send [NAME] And Share | Email To | [NAME] | [NAME] | [NAME] To | [NAME] | [NAME] | [NAME] | Prevent Resharing | Time [NAME] | Form [NAME]
Spreadsheet: 132755d1323903813-automatic-leaderboard-2011-12-bowl-pool-summary-dfd0001
Sheet: Leaderboard

 | Leaderboard
 | Participants | Wins | Loses
1900-01-01 00:00:00
Spreadsheet: 57044d1257216123-late-fees-from-aged-receivable-late-fee-calculation
Sheet: Sheet1

 |  |  |  |  |  | Days to | Interest Charge
Customer ID | Customer | Invoice/CM # | Amount Due | Inv Date | Due Date | 2009-11-01 00:00:00 | 0.08
211 | Jones | 14562 | 490 | 2008-07-01 00:00:00
211 | Jones | LF-8533 | 21 | 2009-02-02 00:00:00
211 | Jones | Misc | 18.5 | 2009-02-02 00:00:00
211 | Jones
212 | Smith | 14563 | 490 | 2008-07-01 00:00:00
212 | Smith | LF-8534 | 21 | 2009-02-02 00:00:00
212 | Smith | Misc | 18.5 | 2009-02-02 00:00:00
212 | Smith
Spreadsheet: 293552d1391019437-need-a-way-to-find-ip-addresses-from-a-spreadsheet-that-contains-hostnames-in-column-a-excelforumfindipaddresseswithtracertorping-2014-01-29-13-15
Sheet: SheetN

 | www.google.com |  |  | 74.125.228.113 |  |  | 74.125.228.112 |  |  | 74.125.228.80
 | www.mygoogle.com |  |  | No IP Address |  |  | No IP Address |  |  | No IP Address
 | www.yahoo.com |  |  | 98.139.183.24 |  |  | 98.139.180.149 |  |  | 98.139.180.149
 | www.verizon.com |  |  | 23.209.42.120 |  |  | 23.209.42.120 |  |  | 23.76.218.120
 | www.verizon.net |  |  | 23.45.39.139 |  |  | 23.45.39.139 |  |  | 23.11.135.139
 | www.google.com |  |  | 74.125.228.113 |  |  | 74.125.228.112 |  |  | 74.125.228.80
 | www.mygoogle.com |  |  | No IP Address |  |  | No IP Address |  |  | No IP Address
 | www.yahoo.com |  |  | 98.139.183.24 |  |  | 98.139.180.149 |  |  | 98.139.180.149
 | www.google.com |  |  | 74.125.228.113 |  |  | 74.125.228.112 |  |  | 74.125.228.80
 | excelforum.com |  |  | 69.167.155.134 |  |  | 69.167.155.134 |  |  | 69.167.155.134
Spreadsheet: 215576d1361417326-conditional-formating-budget
Sheet: Bills 

 |  |  |  | Semi-Monthly Home Budget | Dashboard!A1 | Dashboard!A1 | Dashboard!A1 |  |  | Expenditures & Income | 'Expenditures & Income'!A1 | 'Expenditures & Income'!A1 | 'Expenditures & Income'!A1
 |  |  |  | Bills
 |  |  |  | 1ST OF THE MONTH |  |  |  | 15TH OF THE MONTH |  |  |  | ***Do NOT Modify***
 |  |  |  | WHO/WHAT | AMOUNT |  |  | WHO/WHAT | AMOUNT |  |  | WHO/WHAT | AMOUNT
 |  |  |  | Direct TV | 78 |  |  | Cox | 166 |  |  | Ally
 |  |  |  | Gieco | 105 |  |  | Gas | 100 |  |  | Honda | 623.95
 |  |  |  | [NAME] | 9.99 |  |  | USAA | 50 |  |  | Rent
 |  |  |  | Lowes | 60 |  |  | Water | 27 |  |  | Gieco
 |  |  |  | NV Energy | 159 |  |  | Allstate | 37 |  |  | USAA
 |  |  |  | Sprint | 200 |  |  |  |  |  |  | Cox
 |  |  |  | AAFES - Star Card | 100 |  |  |  |  |  |  | Allstate
 |  |  |  | Gas | 100 |  |  |  |  |  |  | Sprint
 |  |  |  |  |  |  |  |  |  |  |  | Star Card
 |  |  |  | Total |  |  |  | Total |  |  |  | [NAME]
 |  |  |  | Car / Rent Allotment |  |  |  |  |  |  |  | Lowes | 60
 |  |  |  | WHO/WHAT | AMOUNT
 |  |  |  | Rent | 1100
 |  |  |  | Honda
 |  |  |  | Ally | 636.54
 |  |  |  | Additional Payment | 78.46
 |  |  |  | Total
Spreadsheet: 858358d1707078206-harvey-balls-not-showing-color-in-drop-down-list-student-attendance-1
Sheet: 1st Period

Attendance
2nd Semester | February
Period 1 | 7:30-8:27 / 7:30-8:00 |  |  |  | Key: |  |  |  | Select one
 |  |  | Week 1 |  |  |  |  | Week 2 |  |  |  |  | Week 3 |  |  |  |  | Week 4 |  |  |  |  | Week 5
 |  |  |  | M | T | W | Th | F | M | T | W | Th | F | M | T | W | Th | F | M | T | W | Th | F | M | T | W | Th
 |  |  |  |  |  |  | 1 | 2 | 5 | 6 | 7 | 8 | 9 | 12 | 13 | 14 | 15 | 16 | 19 | 20 | 21 | 22 | 23 | 26 | 27 | 28 | 29 |  |  | Student Totals
 | # | First Name | Last Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Math | English | Other Subject | Lunch | Afterschool | TOTAL
 | ATND-001 | Aiden | Reid  Sianquita |  |  |  |  |  |  |  | ⬤  Math |  |  | ⬤  English |  | ⬤  English |  | ⬤  Other Subject |  | ⬤  Lunch |  | ⬤  Afterschool
 | ATND-002 | Angelina "[NAME]" | [NAME]
 | ATND-003 | [NAME] | [NAME]
 | ATND-004 | [NAME] | Salas
 | ATND-005 | [NAME] | [NAME]
 | ATND-006 | Antoneo | [NAME]
 | ATND-007 | Brinna | Codio-Ahearn |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ⬤  Math
 | ATND-008 | Calvin | [NAME]
 | ATND-009 | Cecilia | Sandoval
 | ATND-010 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ⬤  English
 | ATND-011 | [NAME] | Curley
 | ATND-012 | Curtis | Lucks |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ⬤  Other Subject
 | ATND-013 | [NAME] | [NAME]
 | ATND-014 | [NAME] | Rhea
 | ATND-015 | Elvin | [NAME]
 | ATND-016 | Gabrielle | Kealoha
 | ATND-017 | Gregory | Quidachay
 | ATND-018 | Hoapili | Kealoha
 | ATND-019 | Irianne | Gom-Os
 | ATND-020 | Jahmil | Green
 | ATND-021 | Jaquel-Jacquan | [NAME]
 | ATND-022 | Jayden | Panganoren
 | ATND-023 | Jaythan | Trinidad
 | ATND-024 | Jaython | Quidachay
 | ATND-025 | Jeremy | Naeole
 | ATND-029 | [NAME] | Panganoren
 | ATND-030 | [NAME] | [NAME]
 | ATND-031 | [NAME] | Smith-Solomus
 | ATND-032 | [NAME] | [NAME]
 | ATND-033 | Kaykay | [NAME]
 | ATND-034 | Keion | [NAME]
 | ATND-035 | [NAME] | [NAME]
 | ATND-036 | Kristina | Vazquez
 | ATND-037 | [NAME] | Lozier
 | ATND-038 | Lagituaiva | Fa'asau
 | ATND-039 | [NAME] | Larue
 | ATND-040 | Malia | Beller
 | ATND-041 | [NAME] | Arceo
 | ATND-042 | [NAME] | Sianquita
 | ATND-043 | Nathanial | Bentley
 | ATND-044 | Navaeh E. | Bios
 | ATND-045 | Paige | Ashcraft
 | ATND-046 | Rebecca | Smith
 | ATND-047 | Rhe'Anna | Trinidad
 | ATND-048 | Ricky | Camacho
 | ATND-049 | Riley | Gardner
 | ATND-050 | Sahera | Alonzo
 | ATND-051 | Si-Cilya | Santos
 | ATND-052 | Taluasa | Enoka
 | ATND-053 | [NAME] | Cupp |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ⬤  Lunch
 | ATND-054 | Tienne | [NAME]
 | ATND-055 | Yomolina | [NAME]
 |  | Math Total
 |  | English Total
 |  | Other Subjects Total
 |  | Lunch Total
 |  | Afterschool Total
 |  | Total Students This Period
 | Column1
 | ⬤  Math
 | ⬤  English
 | ⬤  Other Subject
 | ⬤  Lunch
 | ⬤  Afterschool
Spreadsheet: 842396d1694492042-lookup-and-match-two-cells-to-columns-return-third-value-from-third-column-example
Sheet: Sheet1

 | Name |  | [NAME]
 | Period
 | DATE | STATUS | START TIME | BREAK START | BREAK FINISH | FINISH TIME | HOURS WORKED
 |  |  |  |  |  | Total Hours
Spreadsheet: 707591d1607357975-separating-data-and-counting-the-data-on-a-different-spreadsheet-lesia-test
Sheet: Agents

Operator | Total Valid Between 1/1/20 and 6/30/20 | Total Valid Between 7/1/20 and 12/1/20 | Net Total | Bonus Total
[NAME] | 1 | 1
Spreadsheet: 679379d1590379976-deferred-revenue-various-billing-cycle-test-ml
Sheet: Sheet1

Customer | Invoice Date | Start Date | End Date | Amount | [NAME] | Frequency Value | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | total payment
A | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2020-07-30 00:00:00 | 10000 | 1
B | 2019-02-01 00:00:00 | 2019-02-01 00:00:00 | 2020-05-30 00:00:00 | 15000 | 3
C | 2019-05-01 00:00:00 | 2019-05-01 00:00:00 | 2020-06-30 00:00:00 | 350000 | 6
D | 2019-05-01 00:00:00 | 2019-05-01 00:00:00 | 2020-12-31 00:00:00 | 50000 | 12
Spreadsheet: 288044d1389076001-penalty-shoot-out-spread-sheet-penalty-shootout
Sheet: Data - Goalies

[NAME] |  |  |  |  |  |  |  |  |  | http://www.youtube.com/watch?v=rCeTG2k2T6I
Team | Player Name | Age | Saves | Total Shots | Save % | Age Group Rank | Overall Rank
Team1 | [NAME] | 9 | 196 | 320
Team2 | [NAME] | 16 | 105 | 320
Team3 | Priscilla | 9 | 147 | 320
Team4 | Danna | 12 | 122 | 320
Team5 | Angie | 15 | 131 | 320
Team6 | [NAME] | 11 | 207 | 320
Team7 | [NAME] | 15 | 156 | 320
Team8 | Sage | 8 | 164 | 320
Team9 | [NAME] | 11 | 150 | 320
Team10 | Brinley | 9 | 118 | 320
Team11 | [NAME] | 13 | 91 | 320
[NAME] | Joy | 16 | 124 | 320
Team13 | Kenley | 12 | 193 | 320
Team14 | Vera | 10 | 117 | 320
Team15 | [NAME] | 10 | 178 | 320
Team16 | Amira | 7 | 196 | 320
Team17 | Aileen | 12 | 147 | 320
Team18 | Aspen | 16 | 206 | 320
Team19 | Emmalyn | 8 | 110 | 320
Team20 | [NAME] | 14 | 110 | 320
Team21 | [NAME] | 7 | 90 | 320
Team22 | Kennedi | 8 | 124 | 320
Team23 | Skyla | 7 | 96 | 320
Team24 | Annalise | 7 | 163 | 320
[NAME] | [NAME] | 7 | 167 | 320
Team26 | [NAME] | 9 | 144 | 320
Team27 | Kiley | 12 | 185 | 320
Team28 | [NAME] | 11 | 171 | 320
[NAME] | Jasmin | 8 | 165 | 320
Team30 | Lauryn | 9 | 195 | 320
Team31 | Aleena | 13 | 202 | 320
Team32 | Justice | 11 | 101 | 320
Team33 | Annabel | 12 | 155 | 320
Team34 | Tenley | 16 | 173 | 320
Team35 | Dahlia | 11 | 178 | 320
Team36 | Gloria | 16 | 183 | 320
[NAME] | Lexie | 15 | 208 | 320
Team38 | Lindsey | 9 | 155 | 320
Team39 | [NAME] | 9 | 203 | 320
[NAME] | [NAME] | 13 | 103 | 320
Team41 | Elyse | 10 | 144 | 320
Team42 | Annika | 16 | 142 | 320
Team43 | Maeve | 11 | 125 | 320
Team44 | Marlee | 13 | 147 | 320
Team45 | [NAME] | 11 | 134 | 320
Team46 | Kenya | 14 | 110 | 320
Team47 | Lorelei | 14 | 142 | 320
Team48 | [NAME] | 8 | 124 | 320
Team49 | Kaliyah | 14 | 203 | 320
Team50 | Adele | 15 | 193 | 320
Team51 | Natasha | 16 | 148 | 320
Team52 | [NAME] | 15 | 119 | 320
Team53 | Erika | 9 | 114 | 320
Team54 | Alyson | 9 | 133 | 320
Team55 | [NAME] | 10 | 198 | 320
Team56 | Emilee | 13 | 181 | 320
Team57 | Raven | 12 | 159 | 320
Team58 | Ariella | 12 | 151 | 320
Team59 | Blakely | 16 | 110 | 320
Team60 | [NAME] | 15 | 184 | 320
Team61 | Jaycee | 15 | 123 | 320
Team62 | Sawyer | 13 | 137 | 320
Team63 | Anahi | 12 | 94 | 320
[NAME] | Jaelynn | 14 | 121 | 320
Team65 | [NAME] | 9 | 184 | 320
Team66 | [NAME] | 11 | 139 | 320
Team67 | Cameron | 7 | 139 | 320
Team68 | [NAME] | 15 | 109 | 320
Team69 | Luciana | 7 | 205 | 320
Team70 | [NAME] | 15 | 103 | 320
Spreadsheet: 854882d1704635031-excluding-vacation-dates-for-calculating-turn-around-time-tat
Sheet: Sheet2

Name | Order Date | Dictation date | Completion Date | TAT excluding weekends) | Vacation dates
A | 2023-12-21 00:00:00 | 2023-12-22 00:00:00 | 2023-12-31 00:00:00 |  |  | Column E is calculated
B | 2023-12-14 00:00:00 | 2023-12-17 00:00:00 | 2024-01-02 00:00:00 |  | December 12 to December 22
C | 2023-12-20 00:00:00 | 2023-12-28 00:00:00 | 2024-01-05 00:00:00 |  | December 15 to December 25
D | 2023-12-11 00:00:00 | 2023-12-14 00:00:00 | 2023-12-26 00:00:00 |  | November 15 to December 9
E | 2023-11-15 00:00:00 | 2023-12-10 00:00:00 | 2023-12-14 00:00:00
F | 2023-09-11 00:00:00 | 2023-11-30 00:00:00 | 2023-12-10 00:00:00 |  | September 11 to November 29
G | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2024-01-06 00:00:00
H | 2023-10-30 00:00:00 | 2023-11-30 00:00:00 | 2023-12-18 00:00:00 |  | November 30 to December 16
I | 2023-11-08 00:00:00 | 2023-12-21 00:00:00 | 2023-12-30 00:00:00 |  | Novemer 21 to December 15 and December 25 to December 27
The database has a running data from January to December. TAT is computed with networkdays.intl - column B is start date and column D is end date
I am able to exclude weekends which are Saturday and Sunday and public holidays for computation of the TAT
How can I exclude vacation dates for each staff (column A) from the TAT to make the data accurate
Column G gives the vacation dates
Spreadsheet: 787864d1658099836-average-data-for-each-month-in-each-year-dates-not-specified-example-average
Sheet: Sheet1

Date | Produced (kwh) |  |  | Sum of Product |  |  |  |  | Average per month
2014-05-16 00:00:00 | 8.41 |  |  | Month | 2014 | 2015 | 2016 |  | Month | 2014 | 2015 | 2016
 | 18.15 |  |  | 1 |  |  |  |  | 1 |  |  |  |  | I wish to calculate the avrage per month into this table
 | 16.97 |  |  | 2 |  |  |  |  | 2 |  |  |  |  | Its similar to the first table which provides me with the total number of readings per month per year (to the left)
 | 14.16 |  |  | 3 |  |  |  |  | 3
 | 17.48 |  |  | 4 |  |  |  |  | 4
 | 17.64 |  |  | 5 |  |  |  |  | 5
 | 17.57 |  |  | 6 |  |  |  |  | 6
 | 17.52 |  |  | 7 |  |  |  |  | 7
 | 18.39 |  |  | 8 |  |  |  |  | 8
 | 17.96 |  |  | 9 |  |  |  |  | 9
 | 17.54 |  |  | 10 |  |  |  |  | 10
 | 12.61 |  |  | 11 |  |  |  |  | 11
 | 18.75 |  |  | 12 |  |  |  |  | 12
 | 16.79
 | 17.36 | Average | Min | [NAME]
 | 14.22
 | 14.82
 | 16.48
 | 17.49
 | 16.04
 | 17.11
 | 16.97
 | 16.7
 | 17.5
 | 17.69
 | 17.59
 | 17.27
 | 16.8
 | 16.3
 | 13.07
 | 16.67
 | 17.32
 | 15.41
 | 17.08
 | 9.84
 | 16.3
 | 16.61
 | 16.58
 | 17.36
 | 16.95
 | 17.62
 | 16.99
 | 16.72
 | 16.26
 | 16.96 | Average | Min | [NAME]
 | 17.31
 | 17.23
 | 16.3
 | 16.49
 | 15.76
 | 17.2
 | 17.36
 | 17.16
 | 16.98
 | 16.51
 | 16.7
 | 17.68
 | 16.74
 | 16.72
 | 16.73
 | 16.71
 | 17.02
 | 17.11
 | 17.89
 | 17.35
 | 17.32
 | 17.68
 | 17.96
 | 17.55
 | 17.31
 | 17.92
 | 17.63
 | 17.56
 | 17.96
 | 17.84
 | 17.71
 | 17.63
 | 17.51
 | 18.09
 | 18.41
 | 19.06
 | 19.34
 | 19.35
 | 17.56
 | 19.19
 | 19.5
 | 19.84
 | 19.94
 | 19.73
 | 20.72
 | 20.33
 | 20.28
 | 20.15
 | 20.86
 | 20.5
 | 20.08
 | 19.87
 | 20.56
 | 21.24
 | 20.91
 | 20.28
 | 20.38
 | 21.1
 | 20.81
 | 21.1
 | 20.93
 | 21.25
 | 21.49
 | 19.72
 | 20.7
 | 19.78
 | 21.29