tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 845449d1696961251-calculating-total-sum-of-item-within-a-date-range-gites
Sheet: Reservations

Client | Reservation ID | Direct ou Booking | Date d'arriver | Date de départ | Gite No. | Duration | Prix par jour | Prix de Séjour | No. Adultes | No. D'enfants | Ménage | Serviettes | Taux de Taxe | Totale Tax | Total Prix | Acompte 1 | Méthod | Acompte 2 | Méthod | [NAME] | A Payé | Payé? |  |  |  |  |  |  |  |  | SPILL Zone for available rooms
1 [NAME] | 1 | Direct | 2024-01-01 00:00:00 | 2024-03-30 00:00:00 | 10 |  |  |  | 2 | 3 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 11
2 Bruce Springsteen | 1 | Direct | 2024-01-01 00:00:00 | 2024-03-30 00:00:00 | 12 |  |  |  | 2 | 3 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 11
3 Mick Jagger | 1 | Direct | 2024-04-26 00:00:00 | 2024-05-02 00:00:00 | 10 |  |  |  | 2 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
3 Mick Jagger | 2 | Direct | 2024-04-26 00:00:00 | 2024-05-02 00:00:00 | 11 |  |  |  | 2 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
3 Mick Jagger | 3 | Direct | 2024-04-26 00:00:00 | 2024-05-02 00:00:00 | 12 |  |  |  | 2 | 1 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
4 [NAME] | 1 | Direct | 2024-05-16 00:00:00 | 2024-05-20 00:00:00 | 12 |  |  |  | 2 |  | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
5 [NAME] | 1 | Direct | 2024-05-03 00:00:00 | 2024-05-11 00:00:00 | 2 |  |  |  | 2 | 3 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
7 [NAME] | 1 | Direct | 2024-05-03 00:00:00 | 2024-05-11 00:00:00 | 12 |  |  |  | 2 | 3 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
Spreadsheet: 843017d1694992887-sort-text-strings-based-on-two-criteria-sort-strings-by-two-criteria-3-
Sheet: Sheet2

 | Data |  | Desired result
 | 2r 37m2 |  | 2r 37m2 |  |  | 9m2
 | 2r 9m2 |  | 2r 49m2 |  | 2r | 37m2
 | 2r 50m2 |  | 2r 50m2 |  | 2r | 50m2
 | 12r 51m2 |  | 2r 51m2 |  | 2r | 58m2
 | 2r 58m2 |  | 2r 58m2 |  | 3r | 81m2
 | 3r 81m2 |  | 3r 81m2 |  | 4r | 89m2 | https://www.excelforum.com/excel-formulas-and-functions/1412168-using-textsplit-with-map-and-lambda-is-not-working.html
 | 4r 101m2 |  | 4r 89m2 |  | 4r | 94m2
 | 4r 89m2 |  | 4r 94m2 |  | 4r | 96m2
 | 4r 94m2 |  | 4r 96m2 |  | 4r | 97m2
 | 4r 96m2 |  | 4r 97m2 |  | 4r | 101m2
 | 4r 97m2 |  | 4r 101m2 |  | 5r | 98m2
 | 5r 104m2 |  | 5r 98m2 |  | 5r | 104m2
 | 5r 98m2 |  | 5r 104m2 |  | 12r | 51m2
Spreadsheet: scott_neal__38598__NEWENGTRADES
Sheet: Sheet1

EOL New England Trades
Since first offered Apr/May 2001
(as of 5/18/01)
 |  | April |  | May |  | Jun
 |  | Fixed | EFP | Fixed | EFP | Fixed | EFP
[NAME] |  | n/a | n/a | 0 | 5 | 12 | 8
Tennessee Dracut |  | 1 | 5 | 1 | 3 | 0 | 1
[NAME] |  | n/a | n/a | 1 | 2 | 4 | 3
Total volume traded since April 2001 = 3.55 Bcf
Algonquin - ENA controls no assets or transport.
[NAME] controls no assets and owns 2,000 Mcf/d of transport.
Tennessee Z6 - ENA controls no assets and owns 35,000 Mcf/d of transport within a restrictive subset of Zone 6.
* These numbers only include EOL trades, several direct baseload trades have been made as well.  In addition,
for May 2001 we have begun taking a position into the daily market and have been successful operating in
that environment.
Spreadsheet: 67260d1267837766-excel-2007-cluster-stacked-column-chart-excel-2007-excel-forum
Sheet: Sheet2

 | Lifetime Alcohol Use | Lifetime [NAME] | Lifetime Other Drug Use | Two Substances | Three Substances
 | 0 | 0 | 0 | 0 | 0
 | Female | Male | 9th | 10th | 11th | 12th | White | Asian | Hawaiian | Multiple
Alcohol | 68.3 | 61.5
 |  |  | 55 | 59.9 | 72.9 | 75
 |  |  |  |  |  |  | 71.7 | 57.5 | 72.3 | 73.6
[NAME] | 35.1 | 34.1
 |  |  | 24.3 | 31.8 | 38.6 | 49.4
 |  |  |  |  |  |  | 49.5 | 22.2 | 48.8 | 39.4
Other | 19.2 | 17.6
 |  |  | 23.7 | 24.4 | 32.7 | 34.1
 |  |  |  |  |  |  | 20.1 | 13.9 | 24.8 | 19.5
Two Sub | 29 | 27.2
 |  |  | 8.5 | 10.5 | 10.3 | 16
 |  |  |  |  |  |  | 33.9 | 22.5 | 33.2 | 29.9
Three Sub | 12.1 | 10.1
 |  |  | 8.5 | 10.5 | 10.3 | 16
 |  |  |  |  |  |  | 17.7 | 5.7 | 18.4 | 14.2
Spreadsheet: 782507d1654089119-data-validation-alternate-formula-for-filter-function-shareez-saleem-test
Sheet: Sheet1

 | 1 | A | 1 |  | <- I need this in data validation (drop down) |  |  |  |  |  | A
 | 2 | C | 2 | V
 | 1 | V |  | D
 | 2 | C
 | 1 | D
Spreadsheet: 1f7df3c1-ca37-4456-b394-b5b43ffa6166
Sheet: IPEDS1

NCES (IPEDS) Academic Libraries Survey. Library expenditures, FY 2010
Question | Measure | Total FY10 | Notes
Line 300 | One time purchases of books, serial backfiles, and other materials | 531481 | Includes all branches, endowments, serial back files purchased.
Line 301 | Electronic | 187076 | Serial and electronic one-time back files purchased plus one e-book.
Line 302 | Audiovisual | 7193.04 | Kingston only
Line 303 | Ongoing commitments to serial subscriptions | 2529948.3 | All branches. Includes endowment. Does not include back files.
Line 304 | Electronic serials | 2229014.33 | All branches. Includes endowment. Does not include one-time back files or software.
Line 309 | Bibliographic utilities, networks, and consortia | 179064 | HELIN + NELINET + MARCIVE fees.
Spreadsheet: 712752d1610390685-conditional-formatting-for-formula-that-checks-date-and-returns-holiday-name-timesheet-template-sample-
Sheet: June - July 

 | Name: |  |  |  |  |  |  | Supervisor:
 |  |  | Start | End | (Position) | (Position) | TOTAL HOURS | Comments | Substitute | [NAME] | Personal Leave | Other | Holiday
 | Total Hours
 |  |  |  |  |  | Check
 |  |  |  |  |  |  |  | OVERTIME |  | SL | PL | Other | Holiday
 | LAST week/LAST Month
 | Week 1
 | Week 2
 | Week 3
 | Week 4
 | Week 5
 | TOTALS
 | Check
Spreadsheet: 102705d1300687012-how-to-find-the-top-3-amount-per-customer-filter
Sheet: Sheet1

customer # | mobile # | useage amount
sbn555 | 23125 | 986.32
rbt1152 | 20101 | 986.2
sbn555 | 25200 | 986.2
rbt1152 | 23542 | 985.32
rbt1152 | 98745 | 852.2
sbn555 | 56233 | 556.32
rbt1152 | 20258 | 200.32
sbn555 | 85212 | 98.98
rbt1152 | 22250 | 98.66
sbn555 | 87520 | 98.25
sbn555 | 59852 | 98.24
cba111 | 18907 | 90.21
abc123 | 12346 | 89.78
rbt1152 | 12501 | 88.25
rbt1152 | 32568 | 77.25
abc123 | 12345 | 65.89
cba111 | 9876 | 56.2
rbt1152 | 52589 | 55.32
cba111 | 78912 | 44.23
abc123 | 18903 | 33.67
sbn555 | 87954 | 22.23
abc123 | 12458 | 12.8
cba111 | 20585 | 11.95
cba111 | 67854 | 10.45
sbn555 | 20125 | 9.999
rbt1152 | 21025 | 6.33
Spreadsheet: 856817d1706006056-string-of-four-to-five-characters-that-need-to-be-seperated-into-four-to-five-columns-text-to-columns-aligw
Sheet: Sheet1

Raw Data | [NAME] | Dept | First Name | Last Name | Emp ID
Tesla Operations [NAME] | Tesla | Operations | [NAME] | Smith | [NAME] |  |  | Operations | [NAME] | Smith | [NAME]
Tesla DevOps [NAME] |  |  |  |  |  |  |  | DevOps | [NAME] | Iqbal | D4114
Tesla Devops Ramesh Singh-D665566 |  |  |  |  |  |  |  | Devops | Ramesh | Singh | D665566
Tesla Eng [NAME] |  |  |  |  |  |  |  | Eng | [NAME] | Wilde | En9813
[NAME] |  |  |  |  |  |  |  | Mar | Adam | Greens | M6544
[NAME] |  |  |  |  |  |  |  | Mar | [NAME] | [NAME] | M05112
Tesla Eng [NAME] |  |  |  |  |  |  |  | Eng | [NAME] | Rich | En8554
Google Mar [NAME] |  |  |  |  |  |  |  | Mar | Vinay | [NAME] | G35489
Tesla Fac Heather Stones-Fac5114 |  |  |  |  |  |  |  | Fac | Heather | Stones | Fac5114
Meta Fac Gary Fins-Fac3119 |  |  |  |  |  |  |  | Fac | [NAME] | [NAME] | Fac3119
Spreadsheet: 736526d1623696804-replace-cell-info-based-on-cell-address-criteria-password-sample
Sheet: Sheet1

 |  | Vendor1 |  | Vendor | School | Username | Password | Pin | Column1 | Website | Rep | [NAME] | Phone
 |  | School2 |  | Vendor1 | School1 | Username1 | Password1
 |  |  |  | Vendor1 | School2 | Username2 | Password2
 |  |  |  | Vendor2 | School1 | Username3 | Password3
 |  |  |  | Vendor2 | School2 | Username4 | Password4
 |  |  |  | Vendor3 | School1 | Username5 | Password5
 |  |  |  | Vendor3 | School2 | Username6 | Password6
 |  |  |  | Vendor4 | School1 | Username7 | Password7
 |  |  |  | Vendor4 | School2 | Username8 | Password8
 |  |  |  | Vendor5 | School1 | Username9 | Password9
 | PASSWORD CHANGE |  |  | Vendor5 | School2 | Username10 | Password10
 |  | Vendor5
 |  | [NAME]
 | Old Password
 | New Password | NewPas1
 | Replace | =find address of C15 & replace it with info in C16
 |  | End result will change value in H12 to value in C16
 |  | H12=NewPas1
Spreadsheet: 815655d1675130061-avoid-index-small-row-array-formula-to-include-blank-cells-example
Sheet: Sheet3

Full Name | Position | Line Manager | Start Date | :D
Oktyabrina [NAME] |  |  | 2004-07-27 00:00:00
[NAME] |  |  | 2012-12-21 00:00:00
Cunobelinos Caren |  |  | 2016-07-12 00:00:00
Fariha Kumari |  |  | 2023-01-15 00:00:00
Rio Kiki
Alojz [NAME] |  |  | 2023-01-10 00:00:00
Love Nehuén |  |  | 2009-12-24 00:00:00
[NAME] |  |  | 2004-03-05 00:00:00
Thaddeus Wâpanacâhkos |  |  | 2021-05-17 00:00:00
Ottaviano Opaline |  |  | 2006-09-25 00:00:00
Spreadsheet: 175294d1345480852-conbditional-formatting-in-excel-2007-sample-action-log
Sheet: Sheet1

Number | Category | Description of action | Party | Owner | Type | Priority | Update | Date raised | Date due | Dependencies | Date closed | Status | Closure comments
1 | xxx | xxx | xxx | xxx | External | High | xxx | 2012-08-01 00:00:00 | 2012-08-17 00:00:00 | None known |  | Open |  | Manually formatted to demonstrate
2 | xxx | xxx | xxx | xxx | External | Medium | xxx | 2012-08-01 00:00:00 | 2012-08-31 00:00:00 | None known |  | Open |  | Manually formatted to demonstrate
3 | xxx | xxx | xxx | xxx | External | High | xxx | 2012-08-01 00:00:00 | 2012-08-01 00:00:00 | None known |  | Open |  | Manually formatted to demonstrate
10 | xxx | xxx | xxx | xxx | External | Medium | xxx | 2012-08-01 00:00:00 | 2012-08-24 00:00:00 | None known |  | Closed |  | Manually formatted to demonstrate
13 | xxx | xxx | xxx | xxx | External | High | xxx | 2012-08-01 00:00:00 | 2012-08-16 00:00:00 | Unknown |  | Open
14 | xxx | xxx | xxx | xxx | External | High | xxx | 2012-08-01 00:00:00 | 2012-08-16 00:00:00 | Unknown |  | Open
18 | xxx | xxx | xxx | xxx | External | High | xxx | 2012-08-01 00:00:00 | 2012-08-02 00:00:00 | None known | 2012-08-01 00:00:00 | Closed
19 | xxx | xxx | xxx | xxx | External | High | xxx | 2012-08-01 00:00:00 | 2012-08-16 00:00:00 | Unknown |  | Open
20 | xxx | xxx | xxx | xxx | External | High | xxx | 2012-08-01 00:00:00 | 2012-08-20 00:00:00 | Unknown |  | Open
21 | xxx | xxx | xxx | xxx | External | High | xxx | 2012-08-01 00:00:00 | 2012-08-20 00:00:00 | Unknown |  | Open
22 | xxx | xxx | xxx | xxx | External | High | xxx | 2012-08-01 00:00:00 | 2012-08-16 00:00:00 | Unknown |  | Open
24 | xxx | xxx | xxx | xxx | External | High | xxx | 2012-08-01 00:00:00 | 2012-08-16 00:00:00 | Unknown | 2012-08-10 00:00:00 | Closed
25 | xxx | xxx | xxx | xxx | External | High | xxx | 2012-08-01 00:00:00 | 2012-08-16 00:00:00 | Unknown |  | Open
49 | xxx | xxx | xxx | xxx | External | High | xxx | 2012-08-10 00:00:00 | 2012-08-17 00:00:00 | None known |  | Open
50 | xxx | xxx | xxx | xxx | External | High | xxx | 2012-08-13 00:00:00 | 2012-08-16 00:00:00 | None known | 2012-08-14 00:00:00 | Closed
51 | xxx | xxx | xxx | xxx | External | High | xxx | 2012-08-02 00:00:00 | 2012-08-16 00:00:00 | None known | 2012-08-14 00:00:00 | Closed
27 | xxx | xxx | xxx | xxx | External | High | xxx | 2012-08-01 00:00:00 | 2012-08-31 00:00:00 | None known |  | Open
28 | xxx | xxx | xxx | xxx | External | High | xxx | 2012-08-01 00:00:00 | 2012-08-22 00:00:00 | None known |  | Closed
52 | xxx | xxx | xxx | xxx | External | High | xxx | 2012-08-14 00:00:00 | 2012-08-22 00:00:00 | None known |  | Open
Spreadsheet: 1acbc5b5-eba7-43ce-aba6-394b78c6d600
Sheet: HIST

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD DEFINED | # | ASSESSED  COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | [NAME] | 1 | X | 1 | X | 1 | X | 1 | X | 1
 | TOTAL |  |  | 1
 | PERCENTAGE
 | COURSE
1 | HIST 100 | 1 | X | 1 | X | 1 | 4 | 1 | 4 | 1
3 | HIST 100H | 1 | X | 1 | X | 1
1 | HIST 101 | 1 | X | 1 | X | 1 | 5 | 1 | 5 | 1
3 | HIST 101H | 1 | X | 1 | X | 1
5 | HIST 107 | 1
3 | HIST 135 | 1 | X | 1 | X | 1 | 1 | 1 | 1 | 1
5 | HIST 145 | 1 | X | 1
5 | HIST 160 | 1
5 | HIST 161 | 1
5 | HIST 164 | 1
5 | HIST 170 | 1
5 | HIST 170H | 1
5 | HIST 171 | 1
5 | HIST 171H | 1
 | TOTAL
 | PERCENTAGE
Spreadsheet: 773681d1647995668-help-with-vlookup-with-dates-sample
Sheet: Sheet30

 | Team 1 | Team 2 | Score
2022-01-10 00:00:00 | Vasileios | Xristina | 5 | 1
2022-01-10 00:00:00 | Ntina | Giorgos | 3 | 0
2022-01-15 00:00:00 | Giorgos | Xristina | 5 | 0
2022-01-15 00:00:00 | Ntina | Vasileios | 2 | 4
2022-01-20 00:00:00 | Vasileios | Giorgos | 1 | 3
2022-01-20 00:00:00 | Xristina | Ntina | 2 | 2
2022-01-22 00:00:00 | Vasileios | Xristina
 |  |  |  |  | So if our score is like this (D home score - E away score) and the yellow is the last match (1) before date, green the last match before the last match (2) and the blue the 3d last match in 15 days (3), how I would apply the formula to take the scores. So if Vasileios vs Xristina playing i want to see their last three scores for the previous match they played (not between them)
Spreadsheet: 93090d1292592990-using-vlookupnth-between-2-workbooks-closed
Sheet: Sheet1

Sr. No | Name | Designation | Salary | Status
1 | prem | CEO | 10 Million | Yet to join
2 | [NAME] | CFO | 6 Million | Joined
3 | [NAME] | CTO | 7 Million | Yet to join
4 | [NAME] | COO | 6 Million | Yet to join
5 | [NAME] | Manager | 1 Million | Joined
6 | Sandra | Director | 5 million | Joined
Spreadsheet: 005b6801-8580-4d96-b866-5fd00c9c0c81
Sheet: Table of Contents

CFTC Swaps Report
2012-11-09 00:00:00
Table of Contents
All Swaps
1. Gross Notional Outstanding by Cleared Status
2. Gross Notional Outstanding by Participant Type
3. Net Notional Outstanding by Cleared Status
4. Net Notional Outstanding by Participant Type
5. Transaction Ticket Volume by Cleared Status
6. Transaction Ticket Volume by Participant Type
7. Transaction Dollar Volume by Cleared Status
8. Transaction Dollar Volume by Participant Type
Swaps by Asset Class
Interest Rate Swaps
9a. Gross Notional Outstanding -  Product Type and Cleared Status
9b. Gross Notional Outstanding - Cleared - Supermajor Currency
9c. Gross Notional Outstanding - Cleared - Major Currency
9d. Gross Notional Outstanding - Cleared - Tenor
10a. Net Notional Outstanding - Product Type and Cleared Status
10b. Net Notional Outstanding - Cleared - Supermajor Currency
10c. Net Notional Outstanding - Cleared - Major Currency
10d. Net Notional Outstanding - Cleared - Tenor
11a. Transaction Ticket Volume - Product Type and Cleared Status
11b. Transaction Ticket Volume - Cleared - Supermajor Currency
11c. Transaction Ticket Volume - Cleared - Major Currency
11d. Transaction Ticket Volume - Cleared - Tenor
12a. Transaction Dollar Volume - Product Type and Cleared Status
12b. Transaction Dollar Volume - Cleared - Supermajor Currency
12c. Transaction Dollar Volume - Cleared - Major Currency
12d. Transaction Dollar Volume - Cleared - Tenor
Credit Default Swaps
13a. Gross Notional Outstanding - Product and Participant Type
13b. Gross Notional Outstanding - Product Type and Grade
14a. Net Notional Outstanding - Product and Participant Type
14b. Net Notional Outstanding - Product Type and Grade
15a. Transaction Ticket Volume - Product and Participant Type
15b. Transaction Ticket Volume - Product Type and Grade
16a. Transaction Dollar Volume - Product and Participant Type
16b. Transaction Dollar Volume - Product Type and Grade
Equity Swaps
17. Gross Notional Outstanding
18. Net Notional Outstanding
19. Transaction Ticket Volume
20. Transaction Dollar Volume
Other Commodity Swaps
21. Gross Notional Outstanding
22. Net Notional Outstanding
23. Transaction Ticket Volume
24. Transaction Dollar Volume
Spreadsheet: 594101d1539572751-extremely-complicated-searching-sheet-1
Sheet: Sheet2

50 percent More Perk Points-1137- | 50 More Perk Points.bsa | 50 More Perk Points.bsa
50 percent More Perk Points-1137- | 50 More Perk Points.esp | 50 More Perk Points.esp
50 More Perk Points.bsa | [NAME] | enai_perkbonus_script.pex
AbsorbDragonSoulsTALENT | AbsorbDragonSoulsTALENT.bsa | AbsorbDragonSoulsTALENT.bsa
AbsorbDragonSoulsTALENT | AbsorbDragonSoulsTALENT.esp | AbsorbDragonSoulsTALENT.esp
AbsorbDragonSoulsTALENT.bsa | scripts\qf_02squest_010012c6.pex | qf_02squest_010012c6.pex
AbsorbDragonSoulsTALENT.bsa | scripts\s_02scr01.pex | [NAME]
Spreadsheet: 118422d1313677729-count-games-played-2011-mls-standings-and-bracket
Sheet: Sheet1

 |  |  |  |  | W1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E1
WC1 | Wildcard 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WC2
 |  |  |  |  | WC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WC
WC4 | Wildcard 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | West Conference |  |  |  | East Conference |  |  |  |  |  |  |  |  |  |  |  |  |  | WC3
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E2
 |  |  |  |  | W3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E3
Spreadsheet: 525987d1499073452-copy-paste-diagonal-to-row-in-excel-excel
Sheet: Sheet1

Diff Level | (2) | (3) | (4) | (5) | (6) | (7) | (8) |  | What I want:
VARIABLES | [NAME] | acc | aeavol | age | agr | baspread | beta |  | VARIABLES | [NAME] | acc | aeavol | age | agr | baspread | beta
[NAME] | -0.149 |  |  |  |  |  |  |  | [NAME] | -0.149 | -0.418** | -0.418** | 0.426 | 2.851** | 2.851** | 2.851**
 | (-0.375) |  |  |  |  |  |  |  |  | (-0.375) | (-1.727) | (-1.727) | (0.900) | (1.809) | (1.809) | (1.809)
[NAME] | -0.566 |  |  |  |  |  |  |  | [NAME] | -0.566 | -0.445** | -0.445** | 0.143 | -0.609 | -0.609 | -0.609
 | (-1.085) |  |  |  |  |  |  |  |  | (-1.085) | (-1.683) | (-1.683) | (0.220) | (-0.573) | (-0.573) | (-0.573)
D_acc_L1_D_noise_w = o, |  | -0.418**
 |  | (-1.727)
D_acc = o, |  | -0.445**
 |  | (-1.683)
D_aeavol_L1_D_noise_w |  |  | -0.418**
 |  |  | (-1.727)
D_aeavol |  |  | -0.445**
 |  |  | (-1.683)
D_age_L1_D_noise_w |  |  |  | 0.426
 |  |  |  | (0.900)
D_age |  |  |  | 0.143
 |  |  |  | (0.220)
D_agr_L1_D_noise_w = o, |  |  |  |  | 2.851**
 |  |  |  |  | (1.809)
D_agr = o, |  |  |  |  | -0.609
 |  |  |  |  | (-0.573)
[NAME] o, |  |  |  |  |  | 2.851**
 |  |  |  |  |  | (1.809)
D_baspread = o, |  |  |  |  |  | -0.609
 |  |  |  |  |  | (-0.573)
[NAME] |  |  |  |  |  |  | 2.851**
 |  |  |  |  |  |  | (1.809)
D_beta |  |  |  |  |  |  | -0.609
 |  |  |  |  |  |  | (-0.573)
Spreadsheet: 696458d1600833983-index-match-to-text-match-between-numbers-book1
Sheet: Sheet1

TRANSPORTATIONRATEBASECODE | FIRSTFIELD | THIRDFIELD | FOURTHFIELD | FIFTHFIELD
Wick_CHLD_Bri_Bri | STD | QNAT | 4000 | 4355 |  | Calculation |  | Input - Text | Input - Number
Wick_CHLD_Bri_Pit | STD | QNAT | 4356 | 4357 |  |  |  | QPIT | 4100
Wick_CHLD_Bri_Syd | STD | QNAT | 2000 | 2914
Wick_CHLD_Mil_Ade | STD | QMIL | 5000 | 5950
Wick_CHLD_Mil_Bri | STD | QMIL | 4000 | 4500 |  | Desired Outcome
Wick_CHLD_Mil_Mel | STD | QMIL | 3000 | 3996 |  | Wick_CHLD_Pit_Bri
Wick_CHLD_Mil_Syd | STD | QMIL | 2000 | 2914
Wick_CHLD_Mil_Tow | STD | QMIL | 4806 | 4850
Wick_CHLD_Pit_Ade | STD | QPIT | 5000 | 5950
Wick_CHLD_Pit_Bri | STD | QPIT | 4000 | 4350
Wick_CHLD_Pit_Mel | STD | QPIT | 3000 | 3996
Wick_CHLD_Pit_Syd | STD | QPIT | 2000 | 2914
Wick_CHLD_Pit_Tow | STD | QPIT | 4806 | 4850
Wick_CHLD_Syd_Bri | STD | NNAT | 4000 | 4357
[NAME] | STD | NNAT | 3000 | 3996
Wick_CHLD_Syd3PL_Bri | STD | NNAT | 4000 | 4357
Spreadsheet: 845149d1696671388-filter-between-two-365-workbooks-on-onedrive-etc-template-blank
Sheet: 08.01.23

 |  |  | 2023-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-08-01 00:00:00
Appt Time | Priority | Customer | Pickup # | Shipment | ETC | Status | Qty Picked | Left to Pick | Pick | Check | 1st Confirmation | 2ND CONFIRMATION | Load | SAP Stage | Actual Stage | Carrier | Trailer | Dock Door | SEAL | Trailer Arrival Time | Drive Arrival Time | TRAILER DEPARTURE | Date | Notes | Shipment # | Customer2 | Load First City | PTS | PCS | Bins | Drops | Carrier2 | Pickup #2 | Load Time | SAP Door
 |  |  | Shipments | Pcs | Bins | Pcs Picked | Pcs Left
 |  | HD
 |  | LOWES
 |  | MENARDS
 |  | WS
 |  | YOW
 |  | GRAINGER
 |  | AMAZON
 |  | LTL
Billed
Not Picked
Picking
Picked
Confirming
Confirmed
Loading
Loaded
Ready to Load
Spreadsheet: 685725d1594157743-conditional-formatting-using-a-moving-range-book1-babyschmoo-
Sheet: Sheet1

 |  |  | Values | row: |  | Min: |  | [NAME]:
 |  |  | 8
 |  |  | 1
 |  |  | 7
 |  |  | 4
 |  |  | 7
 |  |  | 1
 |  |  | 10
 |  |  | 6
 |  |  | 2
 |  |  | 2
 |  |  | 8
 |  |  | 5
 |  |  | 9
 |  |  | 6
 |  |  | 6
 |  |  | 2
 |  |  | 1
 |  |  | 7
 |  |  | 9
 |  |  | 7
 |  |  | 6
 |  |  | 5
 |  |  | 6
 |  |  | 5
 |  |  | 10
 |  |  | 9
 |  |  | 9
 |  |  | 2
Spreadsheet: mike_carson__27574__KOCH
Sheet: Sheet1

 | Power for delivery 1/8/02
 | On-Peak
 |  | EPMI | [NAME]'s
 |  | MW | AVG |  | Credit | EPMI | Total
 |  | Postion | Price |  | Fee | COST | Dollars
 | Entergy | 100 | 19.25 |  | 1
 | TVA | 0 |  |  | 1
 | Cinergy | -700 | 22 |  | 1
 | Comed | -100 | 20.9 |  | 1
 | Off-Peak
 |  | EPMI | [NAME]'s
 |  | MW | AVG |  | Credit |  | Total
 |  | Postion | Price |  | Fee |  | Dollars
 | Entergy | 0 |  |  | 1
 | TVA | 0 |  |  | 1
 | Cinergy | -50 | 15.5 |  | 1
 | Comed | 0 |  |  | 1
 |  |  |  |  | Grand |  | Wire Amount
 |  |  |  |  | Total | >>>>>>
Spreadsheet: 852019d1702117741-need-formula-to-automatically-sum-all-values-within-a-year-excel-workbook
Sheet: Ark

Column1 | Column2
0.2 | 2018-10-19 00:00:00
0.2 | 2018-12-27 00:00:00
0.2 | 2019-03-28 00:00:00
0.2 | 2019-06-19 00:00:00
0.21 | 2019-09-20 00:00:00
0.21 | 2020-01-01 00:00:00
0.22 | 2020-03-23 00:00:00
0.22 | 2020-06-17 00:00:00
0.22 | 2020-09-22 00:00:00
0.07 | 2020-10-22 00:00:00
0.07 | 2020-11-20 00:00:00
0.08 | 2020-12-18 00:00:00
0.07 | 2021-01-21 00:00:00
0.08 | 2021-02-18 00:00:00
0.08 | 2021-03-23 00:00:00
0.07 | 2021-04-22 00:00:00
0.08 | 2021-05-24 00:00:00
0.08 | 2021-06-22 00:00:00
0.07 | 2021-07-22 00:00:00
0.08 | 2021-08-23 00:00:00
0.08 | 2021-09-22 00:00:00
0.08 | 2021-10-21 00:00:00
0.08 | 2021-11-22 00:00:00
0.08 | 2021-12-21 00:00:00
0.08 | 2022-01-21 00:00:00
0.08 | 2022-02-18 00:00:00
0.08 | 2022-03-23 00:00:00
0.06 | 2022-04-21 00:00:00
0.04 | 2022-04-21 00:00:00
0.04 | 2022-05-12 00:00:00
0.06 | 2022-05-12 00:00:00
0.06 | 2022-06-21 00:00:00
0.02 | 2022-06-21 00:00:00
0.02 | 2022-07-21 00:00:00
0.06 | 2022-07-21 00:00:00
0.06 | 2022-08-23 00:00:00
0.02 | 2022-08-23 00:00:00
0.02 | 2022-09-22 00:00:00
0.07 | 2022-09-22 00:00:00
0.06 | 2022-10-21 00:00:00
0.02 | 2022-10-21 00:00:00
0.02 | 2022-11-22 00:00:00
0.06 | 2022-11-22 00:00:00
0.07 | 2022-12-21 00:00:00
0.02 | 2022-12-21 00:00:00
0.02 | 2023-01-23 00:00:00
0.06 | 2023-01-23 00:00:00
0.06 | 2023-02-20 00:00:00
0.02 | 2023-02-20 00:00:00
0.02 | 2023-03-23 00:00:00
0.07 | 2023-03-23 00:00:00
0.07 | 2023-04-21 00:00:00
0.07 | 2023-05-23 00:00:00
0.08 | 2023-06-21 00:00:00
0.07 | 2023-07-21 00:00:00
0.07 | 2023-08-23 00:00:00
0.08 | 2023-09-29 00:00:00
0.07 | 2023-10-23 00:00:00
0.08 | 2023-11-22 00:00:00
0.08 | 2023-12-29 00:00:00 |  |  | Row Labels | Sum of Column1
0.07 | 2024-01-23 00:00:00 |  |  | 2018 | 0.4
0.08 | 2024-02-21 00:00:00 |  |  | 2019 | 0.61
0.08 | 2024-03-20 00:00:00 |  |  | 2020 | 1.09
 |  |  |  | 2021 | 0.9299999999999998
 |  |  |  | 2022 | 1.02
 |  |  |  | 2023 | 0.9199999999999999
 |  |  |  | 2024 | 0.23
 |  |  |  | Grand Total | 5.2