tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 840960d1693230244-need-formula-to-calculate-cross-wizard-order-id-to-assisgnee-calculate_matrix-solution-
Sheet: FITA (2)

ORDER ID | Assignee | Count |  |  | YTD Acct | Total volume | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
A11999_117043 | [NAME] |  |  |  | A11999_117043
A11999_117071 | [NAME] |  |  |  | A11999_117071
A11999_117052 | [NAME],[NAME],[NAME],[NAME] |  |  |  | A11999_117052
A11999_117052 | [NAME],[NAME],[NAME],[NAME] |  |  |  | A13269_132600
A11999_117052 | [NAME],[NAME],[NAME],[NAME] |  |  |  | A13269_132610
A11999_117052 | [NAME],[NAME],[NAME],[NAME]
A11999_117052 | [NAME],[NAME]
A11999_117052 | [NAME],[NAME]
A11999_117052 | [NAME],[NAME] |  |  |  | Count_din | =[NAME] ([NAME] (2)'!G$1&"*";'FITA (2)'!$A$2:$A$44;'FITA (2)'!$F10)
A11999_117052 | [NAME]
A11999_117052 | [NAME]
A11999_117052 | [NAME]
A13269_132600 | [NAME],[NAME],[NAME],[NAME]
A13269_132600 | [NAME],[NAME],[NAME],[NAME]
A13269_132600 | [NAME],[NAME],[NAME],[NAME]
A13269_132600 | [NAME],[NAME],[NAME],[NAME]
A13269_132600 | [NAME],[NAME],[NAME],[NAME]
A13269_132600 | [NAME],[NAME],[NAME],[NAME]
A13269_132600 | [NAME],[NAME],[NAME],[NAME]
A13269_132600 | [NAME],[NAME],[NAME],[NAME]
A13269_132600 | [NAME],[NAME],[NAME],[NAME]
A13269_132600 | [NAME],[NAME]
A13269_132600 | [NAME],[NAME]
A13269_132600 | [NAME],[NAME]
A13269_132610 | [NAME]
A13269_132610 | [NAME]
A13269_132610 | [NAME]
A13269_132610 | [NAME]
A13269_132610 | [NAME]
A13269_132610 | [NAME]
A13269_132610 | [NAME],[NAME]
A13269_132610 | [NAME],[NAME]
A13269_132610 | [NAME],[NAME]
A13269_132610 | [NAME],[NAME]
A13269_132610 | [NAME],[NAME]
A13269_132610 | [NAME],[NAME],[NAME]
A13269_132610 | [NAME],[NAME],[NAME]
A13269_132610 | [NAME],[NAME],[NAME]
A13269_132610 | [NAME],[NAME],[NAME]
A13269_132610 | [NAME],[NAME],[NAME]
A13269_132610 | [NAME],[NAME],[NAME]
A13269_132610 | [NAME],[NAME],[NAME]
A13269_132610 | [NAME],[NAME],[NAME]
Spreadsheet: 45700d1244534657-lookup-nearest-value-example
Sheet: Sheet1

1 | A
1.5 | B
2 | C
2.5 | D |  | 4.3
3 | E
3.5 | F
4 | G
4.5 | H
5 | I
5.5 | J
6 | K
6.5 | L
7 | M
7.5 | N
8 | O
8.5 | P
9 | Q
9.5 | R
10 | S
10.5 | T
11 | U
11.5 | V
12 | W
12.5 | X
13 | Y
13.5 | Z
Spreadsheet: f3703712-1433-4375-b038-db805f51a3dd
Sheet: 12a

Product |  | Cleared** | Uncleared | TOTAL
Swap* | Basis
 | FRA
 | Exotic
 | Inflation
 | IRS- [NAME]
 | OIS
 | VNS
 | Zero Coupon
With Optionality | Callable Swap
 | Cap/Floor
 | Debt Option
 | Exotic Option
 | Swaption
Cross-Currency | Exotic
 | Swap
TOTAL |  | N/A*** | N/A | N/A
Estimated swap dollar volumes, week ending August 9, by product type and cleared status (value of all trades in millions of USD), all participant types and currencies. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 859957d1708181740-copy-formulas-to-different-cells-copy-formula
Sheet: Order-Bag

Bag No | Strip | Filing | Order No. | Grinding | pcs | Shape | Return
21 | Abc |  | A-Karen | Pending | 11 | Round
20 | DEF |  | 222 | Done | 22
26 | XYZ |  | 219Paresh | Done | 33 | Oval
Spreadsheet: 328876d1404124521-count-duplicates-by-date-countifs_sample
Sheet: Sheet1

Event Type | Job No | Event Date
COM | EO-HFJJMEB01 | 2014-05-27 00:00:00
COM | EO-HFJPWYB01 | 2014-05-27 00:00:00
COM | EO-HFJPWYB01 | 2014-05-28 00:00:00
COM | EO-HFJPWYB01 | 2014-05-30 00:00:00
COM | EO-HGGRCAB01 | 2014-05-30 00:00:00
COM | EO-HGGRCA002 | 2014-06-05 00:00:00
COM | EO-GLRMHCA07 | 2014-06-10 00:00:00
COM | EO-GLRMHCA06 | 2014-06-10 00:00:00
COM | EO-GLRMHCA01 | 2014-06-10 00:00:00
COM | EO-GLRMHCC07 | 2014-06-16 00:00:00
COM | EO-GLRMHCC06 | 2014-06-16 00:00:00
COM | EO-GLRMHCC01 | 2014-06-16 00:00:00
COM | EO-HV4JEL001 | 2014-06-18 00:00:00
COM | EO-GMENFJ001 | 2014-06-19 00:00:00
COM | EO-GTVMCVA03 | 2014-06-20 00:00:00
COM | EO-GTVMCVA01 | 2014-06-20 00:00:00
COM | EO-GTVMCVA03 | 2014-06-23 00:00:00
COM | EO-GTVMCVA01 | 2014-06-23 00:00:00
COM | EO-HW7HCUA01 | 2014-06-24 00:00:00
COM | EO-HVW5DNA01 | 2014-06-24 00:00:00
COM | EO-HVW2ADA01 | 2014-06-24 00:00:00
Spreadsheet: 230871d1366895950-conditional-formatting-cell-colour-all-cells-not-just-one-2010-sampleworkbookg17issue-rev1-
Sheet:  Summary

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 years
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 years
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 years
 | YEARS |  |  | 4 years
 |  | Please complete | Please complete | Please complete
 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Totals
 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Totals
Spreadsheet: 870571d1717066382-need-to-get-a-summary-of-excel-sheets-main-data-sheet
Sheet: 24015

 | [NAME] (PVT)LTD |  | GOOD RECEIPTS NOTE-STORES |  | PAYMENT VOUCHER COPY
 | VENDOR'S NAME -Jayantha Stores |  | COVERING SRN NO |  | GRN DATE | 15/3/2024
 |  |  |  |  | GRN DATE
 | INVOICE NO -25134 |  | GRN NO | 24015 | DATE OF INVOICE | 14/3/2024
 | S/NO: | [NAME] OF ITEM RECEIVED | RECEIVED QTY |  | Unit Price | Amount
 |  |  | Unit | Quantity
 | 1 | Lentils | Kg | 15 | 370
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | ABOVE ITEMS RESEIVED GOOD ,INSPECTED& PREPARED BY    …............................  (Store EXECUTIVE)                DATE:….................................
 | GOODS RECEIVED & TAKEN TO THE STOCKS                        …............................ (Store Manager)                          DATE:….......................................
 | GOODS RESIVED NOTE APPROVED                                      …............................ (Factory Manager)                       DATE:….......................................
Spreadsheet: d79bee57-41c4-4e76-83d7-bc9312e84759
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6509 | 18758 | Jip | Veelenturf | NED | 169 | [NAME] | 00:00:50 | 00:20:42 | [NAME] | 00:12:56 | 1 | 00:45:45
6509 | 50365 | [NAME] | Király | HUN | 168 | 00:10:09 | 00:00:57 | [NAME] | 00:00:40 | 00:11:56 | 2 | 00:46:32
6509 | 40364 | Sandra | [NAME] | EST | 164 | 00:09:54 | 00:01:23 | 00:23:20 | 00:00:41 | 00:12:59 | 3 | [NAME]
6509 | 25667 | [NAME] | Kaniscevova | CZE | 166 | [NAME] | 00:00:47 | 00:25:52 | 00:00:43 | 00:14:35 | 4 | 00:51:54
6509 | 40554 | Alena | Paliderova | CZE | 170 | 00:10:17 | 00:00:36 | 00:28:20 | 00:00:48 | 00:14:42 | 5 | 00:54:46
6509 | 49437 | Anna | Brychtova | CZE | 167 | 00:13:50 | 00:01:08 | 00:25:23 | [NAME] | 00:13:50 | 6 | 00:55:05
Spreadsheet: 851698d1701869762-sorting-like-items-in-2-columns-bowl-history
Sheet: Sheet1

Bowl name | Las Vegas Bowl
Air Force | Air Force
Akron | Arizona
Alabama | Arizona State
Appalachian State | Arkansas
Arizona | [NAME]
Arizona State | Boise State
Arkansas | Bowling Green
Arkansas A&M | BYU
Arkansas State | California
Army | Central Michigan
Auburn | Colorado State
[NAME] | Florida
Baylor | Fresno State
Boise State | Houston
Bolling AFB | Nevada
[NAME] | New Mexico
Boston College | North Carolina
Bowling Green | Oregon
BYU | Oregon State
[NAME] | San Diego State
Bucknell | Toledo
Buffalo | UCLA
Cal State [NAME] | UNLV
California | USC
Camp Breckinridge | Utah
Carnegie Tech | Utah State
Catawba | Washington
Catholic | Wisconsin
Centenary | Wyoming
Central Michigan
Centre
Charlotte
Cincinnati
Clemson
Coast Guard
Coastal Carolina
Colorado
Colorado A&M
Colorado State
Columbia
Connecticut
Cuban Athletic Club
[NAME]
Dayton
Denver
Drake
Duke
Duquesne
East Carolina
East Texas State
Eastern Kentucky
Eastern Michigan
Emory and [NAME]
FIU
Florida
Florida Atlantic
Florida State
[NAME]
[NAME]
Fort Sill
Fresno State
[NAME]
Georgetown
Georgia
Georgia Southern
Georgia State
Georgia Tech
Gonzaga
Great Lakes NTS
Hardin-Simmons
Harvard
Hawaii
Holy Cross
Houston
Idaho
Illinois
Illinois State Normal
[NAME]
Indiana
Indiana State
Iowa
Iowa State
[NAME]
Juniata
Kansas
Kansas State
[NAME]
Kentucky
[NAME]
Lewis
Liberty
Louisiana Tech
Louisiana-Lafayette
Louisiana–Monroe
Louisville
LSU
Luther
Maine
Marquette
[NAME]
Maryland
Maryville
[NAME]
McNeese State
Memphis
Miami (FL)
Miami (OH)
Michigan
Michigan State
Middle Tennessee
Minnesota
Mississippi A&M
[NAME]
Mississippi State
Missouri
Missouri Mines
Missouri Valley
Morgan State
[NAME]
[NAME]
NAS Pensacola
Navy
NC State
Nebraska
Nevada
New Mexico
New Mexico State
North Carolina
North Central
North Texas
North Texas State
Northern Illinois
Northwestern
Notre Dame
NTC San Diego
Occidental
Ohio
Ohio State
Oklahoma
Oklahoma A&M
Oklahoma State
Old Dominion
Ole Miss
Omaha
Oregon
Oregon State
Ouachita Baptist
Pacific
[NAME]
Penn State
Pittsburgh
Presbyterian
Purdue
Randolph Field
[NAME]
Richmond
Rutgers
[NAME] (CA)
Saint Vincent
San Diego NTC
San Diego State
San Jose State
Santa Clara
Second Air Force
[NAME]
SMU
South Alabama
South Carolina
South Florida
Southern Illinois
Southern Miss
Southwestern
Stanford
[NAME]
Sul Ross State
SW Louisiana
Syracuse
Tampa
TCU
Temple
Tennessee
Tennessee Tech
Tennessee–Martin
Texas
Texas A&M
Texas Tech
The Citadel
Toledo
Troy
Tulane
Tulsa
UAB
UCF
UCLA
UConn
UMass
UNAM
University of Havana
UNLV
USC
Utah
Utah State
UTEP
UTSA
[NAME]
Vedado Tennis Club
Villanova
Virginia
[NAME]
Wake Forest
Washington
Washington & Jefferson
Washington & Lee
Washington State
West Chester
West Texas State
West Virginia
West Virginia Wesleyan
Western Illinois
Western Kentucky
Western Michigan
Western Reserve
Wheaton
Wichita
William & Mary
[NAME]
Wisconsin
Wyoming
Xavier
 | Appalachian State
Spreadsheet: 30990d1226683167-automatic-sorting-sample
Sheet: SAMPLE

 | Jan | Feb | Mar | Apr | May |  | Totals
Materials | 100 | 110 | 120 | 130 | 140 |  | 600
Misc | 40 | 55 | 35 | 40 | 80 |  | 250
Phone | 60 | 70 | 65 | 62 | 55 |  | 312
Rent | 80 | 80 | 85 | 90 | 95 |  | 430
Materials | 600
Rent | 430
Phone | 312
Misc | 250
Spreadsheet: larry_campbell__21018__PCB Graphs
Sheet: 0.55B

Sample location |  |  | Date collected |  |  | PCB result (ppm) |  | Lab
PGE Mile pt. |  |  | 1999-11-03 00:00:00 |  |  | 14 |  | Sherwood
0.55 B side |  |  | 1999-11-18 00:00:00 |  |  | 26 |  | Sherwood
 |  |  | 1999-11-24 00:00:00 |  |  | 44 |  | Sherwood
 |  |  | 1999-12-01 00:00:00 |  |  | 47 |  | Sherwood
 |  |  | 1999-12-08 00:00:00 |  |  | 30 |  | Sherwood
 |  |  | 1999-12-14 00:00:00 |  |  | 21 |  | Sherwood
 |  |  | 1999-12-29 00:00:00 |  |  | 29 |  | Sherwood
 |  |  | 2000-01-05 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-01-19 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-02-09 00:00:00 |  |  | 29 |  | Sherwood
 |  |  | 2000-03-01 00:00:00 |  |  | 23 |  | Sherwood
 |  |  | 2000-03-22 00:00:00 |  |  | 10 |  | Sherwood
 |  |  | 2000-04-05 00:00:00 |  |  | 20 |  | Sherwood
 |  |  | 2000-04-19 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-05-03 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-05-17 00:00:00 |  |  | 11 |  | Sherwood
 |  |  | 2000-05-31 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-06-14 00:00:00 |  |  | 15 |  | Sherwood
 |  |  | 2000-06-21 00:00:00 |  |  | 18 |  | Sherwood
 |  |  | 2000-06-27 00:00:00 |  |  | 19 |  | Sherwood
 |  |  | 2000-07-05 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-08-09 00:00:00 |  |  | 13 |  | Sherwood
 |  |  | 2000-09-20 00:00:00 |  |  | 8 |  | Sherwood
 |  |  | 2000-10-04 00:00:00 |  |  | 5 |  | Sherwood
 |  |  | 2000-10-18 00:00:00 |  |  | 5 |  | Sherwood
 |  |  | 2000-12-13 00:00:00 |  |  | 4 |  | Sherwood
 |  |  | 2001-02-14 00:00:00 |  |  | 3 |  | Sherwood
 |  |  | 2001-04-18 00:00:00 |  |  | 2 |  | Sherwood
 |  |  | 2001-07-11 00:00:00 |  |  | 1 |  | Sherwood
0 data values = ND or  less than a detection limit of 1ppm
Spreadsheet: 853462d1703319428-array-multiplication-matrix
Sheet: Sheet2

 | Apple | [NAME] | Orange | Lemon | Fixed
A |  |  |  |  | 65
B |  |  |  |  | 20
C |  |  |  |  | 30
D |  |  |  |  | 40
 |  | 162.5 | 455 | 520
 | 20 | 40 | 160 | 0
 | 150 | 0 | 45 | 120
 | 160 | 120 | 360 | 80
 | [NAME] | Apple | Lemon | Orange
 |  | 130 | 520 | 455
 | 40 | 20 | 0 | 160
 | 0 | 150 | 120 | 45
 | 120 | 160 | 80 | 360
Spreadsheet: 630115d1561721475-help-with-a-string-of-if-statements-sample-book
Sheet: Sheet2

 |  |  |  |  |  |  | Year 1 |  |  |  | Year 2 |  |  |  | Year 3 |  |  |  | Year 4 |  |  |  | Year 5
 |  |  |  |  |  |  | 2019-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 00:00:00 | 2021-03-31 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2022-09-30 00:00:00 | 2022-12-31 00:00:00 | 2023-03-31 00:00:00 | 2023-06-30 00:00:00 | 2023-09-30 00:00:00 | 2023-12-31 00:00:00 | 2024-03-31 00:00:00 | 2024-06-30 00:00:00
Property Address | Tenant | Lease Start | Lease Break | Lease Expiry | Rent | VOID (# [NAME]) | Q3 2019 | Q4 2019 | Q1 2020 | Q2 2020 | Q3 2020 | Q4 2020 | Q1 2021 | Q2 2021 | Q3 2021 | Q4 2021 | Q1 2022 | Q2 2022 | Q3 2022 | [NAME] | Q1 2023 | Q2 2023 | Q3 2023 | Q4 2023 | Q1 2024 | Q2 2024
 |  | 2019-06-24 00:00:00 | 2022-06-30 00:00:00 | 2021-06-30 00:00:00 | 500000 | 2
 |  | 2019-06-25 00:00:00 | 2022-07-01 00:00:00 | 2022-06-30 00:00:00 | 600000 | 1
 |  | 2019-06-26 00:00:00 | 2022-07-02 00:00:00 | 2023-06-30 00:00:00 | 0 | 3
 |  | 2019-06-27 00:00:00 | 2022-07-31 00:00:00 | 2024-06-30 00:00:00 | 400000 | 0
Initial Loan Requirement |  |  |  | Opening Bal
Property Value |  |  |  | [NAME]
Annuity Loan Profile on |  |  |  | [NAME]
Term |  |  |  | Closing LTV
Gross Rent
Interest p.a.
Service Charges & Costs - lessee
Profit before tax
Tax Payable (estimated) @
Total Interest, Expenses & Tax
Cashflow available pre Principal Repayments p.a.
Net Cashflow Available per above
Add back interest
Cashflow available for Debt Servicing
Cashflow after Debt Servicing
Gross Interest Cover
DSCR Pre Tax
DSCR Post Tax
Surplus Cashflow Available p.a. - pre tax
Surplus Cashflow Available p.a. - post tax
Tax Calculation
Rent
Expenses
Interest
Interest Dissalowed |  |  | 0
Capital Allowance |  |  | 0
Taxable Surplus
Tax Payable @
Rent Reserve
Opening reserve |  |  |  |  |  |  | 0
Surplus Cashflow Available p.a. - post tax
Cumulative reserve
Spreadsheet: 678225d1589788664-formula-to-get-unique-data-excel-formula
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 500 | Expenses Airfare Aug-19 |  |  | 2019-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 2500 | Expenses Airfare Jul-19 |  |  | 2019-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 800 | Expenses Airfare Jun-19 |  |  | 2019-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 500 | Expenses Airfare May-19 |  |  | 2019-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 350 | Expenses Airfare May-19 |  |  | 2019-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 450 | Expenses Airfare May-19 |  |  | 2019-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 550 | Expenses Airfare Oct-19 |  |  | 2019-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 650 | Expenses Airfare Oct-19 |  |  | 2019-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 750 | Expenses Airfare Sep-19 |  |  | 2019-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 350 | Expenses Airfare Sep-19 |  |  | 2019-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30100 | 500
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30100 | 2500
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30100 | 800
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30100
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30100
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30100
Spreadsheet: 870654d1717130634-list-up-the-sheet1-to-sheet2-depend-on-condition-list-pump-use-2-4-
Sheet: WORKER 3

 | payee : | worker 3
no | location | customer | Status | quantity
Spreadsheet: 854527d1704372919-assist-in-vlookup-match-index-formula-budget
Sheet: Mannin

DEPARTMENT | DEPARTMENT | POSITION
 |  |  | Salary | Food Allowance | Housing  Allowance | Transportation | Phone Allowance | MISCL
F&B | F&B
 | F&B
 | F&B
 | F&B
 | F&B
 | F&B
 | F&B
 | F&B
 | F&B
 | F&B
 | F&B
 | F&B
 | F&B
 | F&B
 | F&B
 | F&B
 | F&B
 | F&B
 | F&B
 | F&B
 | F&B
 | F&B
 | F&B
 | F&B
 | F&B
 | F&B
 | F&B
Engineering | Engineering
 | Engineering
 | Engineering
 | Engineering
 | Engineering
 | Engineering
 | Engineering
 | Engineering
Spreadsheet: 713338d1610652250-bulding-a-schedule-index-aggregate-dexter2-
Sheet: Schedule

Route 1 Line
 |  | Vehicle | Depot | Terminal A | Stop 1 | Stop 2 | Stop 3 | Terminal B | Column1 | Vehicle | Terminal B2 | Stop 33 | Stop 24 | Stop 15 | Terminal A6 | Column7 | Depot8 | Vehicle9
 | 101 |  |  | 05:30:00 |  |  |  |  |  |  | 06:15:00 |  |  |  |  | 07:00:00
 | 104 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:15:00
 | 102 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:30:00
 | 103 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:45:00
 | 105 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:00:00
 | 106 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:00:00
 | 108 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:30:00
 | 107 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:15:00
Spreadsheet: 200484d1355571059-sumif-based-on-a-drop-down-meny-with-indirect-prices-2bu
Sheet: Gips

Gips | Dealer 1 | Dealer 2 | Dealer 3 | Dealer 4 | Dealer 5 | Dealer 6
Gips type 1
1x1 | 20 | 19 | 18 | 21 | 22 | 23
1x2
1x3
1x4
Gips type 2
2x1 | 33 | 32 | 31 | 34 | 35 | 36
2x2
2x3
2x4
Gips type 3
3x1 | 45 | 44 | 43 | 42 | 41 | 46
3x2
3x3
3x4
Gips type 4
4x1 | 55 | 54 | 53 | 52 | 51 | 56
[NAME]
4x3
4x4
Spreadsheet: 454655d1459935935-extract-date-based-data-from-single-rows-w-date-range-to-multiple-rows-w-single-dates-question
Sheet: Sheet1

Raw Data:
ID | Type | Days | From | To
1234 | MC | 1 | 2016-10-17 00:00:00 | 2016-10-17 00:00:00
1234 | AL | 2 | 2016-10-18 00:00:00 | 2016-10-19 00:00:00
1300 | HL | 1 | 2016-10-01 00:00:00 | 2016-10-01 00:00:00
1300 | AL | 1 | 2016-10-03 00:00:00 | 2016-10-03 00:00:00
1300 | MC | 2 | 2016-10-10 00:00:00 | 2016-10-11 00:00:00
1300 | MC | 1 | 2016-10-15 00:00:00 | 2016-10-15 00:00:00
1300 | AL | 3 | 2016-10-20 00:00:00 | 2016-10-22 00:00:00
Expected Results
ID | Type | Days | Date
1234 | MC | 1 | 2016-10-17 00:00:00
1234 | AL | 1 | 2016-10-18 00:00:00
1234 | AL | 1 | 2016-10-19 00:00:00
1300 | HL | 1 | 2016-10-01 00:00:00
1300 | AL | 1 | 2016-10-03 00:00:00
1300 | MC | 1 | 2016-10-10 00:00:00
1300 | MC | 1 | 2016-10-11 00:00:00
1300 | MC | 1 | 2016-10-15 00:00:00
1300 | AL | 1 | 2016-10-20 00:00:00
1300 | AL | 1 | 2016-10-21 00:00:00
1300 | AL | 1 | 2016-10-22 00:00:00
Spreadsheet: 50077d1249477158-pull-data-from-one-sheet-to-pop-another-need-new-eyes-please-last-reply-for-info-footballbetting
Sheet: Sheet1

Teams | Game 1 (stage) | Week # | Result | Game 2 (stage) | Week # | Result | Game 3 (stage) | Week # | Result | Game 4 (stage) | Week # | Result
Florida Gators | Troy | 2 | W | Tennessee | 3 |  | At Kentucky | 4 |  | Arkansas | 7
Texas Longhorns | At Wyoming | 2 | W | UTEP | 4 |  | Colorado | 6 |  | At Baylor | 11
USC Trojans | San Jose State | 1 | L | At Washington | 3 | W | Washington State | 4 |  | Stanford | 11
Oklahoma Sooners | Tulsa | 3 | L | Baylor | 6 | L | Kansas State | 9 | W | Texas A&M | 11 | N/A
LSU Tigers | At Washington | 1 | L | [NAME] | 2 | L | UL Lafayette | 3 | L | At Miss State | 4 | W
Ohio State Buckeyes | Navy | 1 | L | At Toledo | 3 | L | Illionois | 4 | L | At Indiana | 5 | W
Spreadsheet: 687429d1595207629-formula-to-help-with-payment-allocation-over-months-based-on-30-day-months-including-feb-file-1-1-
Sheet: Sheet1

 |  |  |  |  | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020
 |  |  |  |  | 2020-01-31 00:00:00 | 2020-02-29 00:00:00 | 2020-03-31 00:00:00 | 2020-04-30 00:00:00 | 2020-05-31 00:00:00 | 2020-06-30 00:00:00 | 2020-07-31 00:00:00 | 2020-08-31 00:00:00 | 2020-09-30 00:00:00 | 2020-10-31 00:00:00 | 2020-11-30 00:00:00 | 2020-12-31 00:00:00
Method | Billing From | Billing To | Billing Amount | Daily Amount | Jan Period | Feb Period | Mar Period | Apr Period | May Period | Jun Period | Jul Period | Aug Period | Sep Period | Oct Period | Nov Period | Dec Period
A | 2020-04-01 00:00:00 | 2020-07-01 00:00:00 | 865.23
A | 2020-04-15 00:00:00 | 2020-07-15 00:00:00 | 104.136
A | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 20531
A | 2020-01-01 00:00:00 | 2020-04-01 00:00:00 | 438
[NAME] on 30 Day months (including february) |  |  |  | Daily Amount
B | 2020-04-05 00:00:00 | 2020-07-01 00:00:00 | 865.23
B | 2020-04-15 00:00:00 | 2020-07-15 00:00:00 | 104.136
B | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 20531
B | 2020-01-01 00:00:00 | 2020-04-01 00:00:00 | 438
Spreadsheet: 68918d1269452410-fishing-weights-weights-template-2003-
Sheet: Sheet1

 |  |  |  |  | FISHING. WEIGHTS 2010
NAME | VENUE1 | VENUE 2 | VENUE 3 | VENUE 4 | VENUE 5 | VENUE 6 | VENUE 6 | VENUE 7 | VENUE 8 | VENUE 9 | GRAND TOTAL
A. OTHER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
E. OTHER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
E. OTHER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
G.OTHER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
K. OTHER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
VENUE TOTALS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0