tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7816__imbalsumm0109
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 173305 | 172312
500232 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 | 139771 | 174091 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 | 92041 | 114487
500293 | 71191 | 102055
500302 |  | 1836
500303 | 37672 | 55719
500305 | 176670 | 221145
500307 | 7934 | 10978
500313 |  | 523
500314
500655 | 108090
500657 | 31594 | 9000
INDEX
2001-08-31 00:00:00 |  |  | -9731.44
2001-09-05 00:00:00
CBS Volume
 |  |  | -37683
Spreadsheet: 697290d1601300357-function-to-match-the-values-between-two-records-reconciliation
Sheet: Presentation

Bank |  |  |  |  |  | Sale Invoices |  |  |  |  |  |  | Sales to Bank Reconciliation
Date | Description | Amount In | Amount Out | Balance |  | Date | Inv | Client | Gross | VAT | Net |  | Bank Date | Bank Description | Amount | Outstanding Amount
2019-09-01 00:00:00 | Client: MNO 1213 | 1000 |  |  |  | 2019-08-02 00:00:00 | 100.1 | MNO 1213 | 1000 |  |  | E.G
2019-09-02 00:00:00 | Client: DEF 456 | 1515.16 |  |  |  | 2019-08-02 00:00:00 | 100.2 | DEF 456 | 1515.16
2019-09-03 00:00:00 | Sainsbury |  | 200 |  |  | 2019-08-15 00:00:00 | 100.3 | STU 1617 | 2000
2019-09-04 00:00:00 | Tesco |  | 3900.2 |  |  | 2019-08-31 00:00:00 | 100.4 | MNO 1213 | 1000
2019-09-05 00:00:00 | Client: MNO 1213 | 1000
2019-09-06 00:00:00 | Client: PQR 1415 | 161.13
2019-09-07 00:00:00 | Client: STU 1617 | 900
2019-09-08 00:00:00 | B & Q |  | 19.13
2019-09-09 00:00:00 | Boots |  | 29
2019-09-10 00:00:00 | Client: STU 1617 | 1100
Case 1: | All the sales invoices should be matched in terms of "Date" / "Description" / "Amount".
Case2: | If the client has same amount of sales of different dates in bank, than first dated payment
 | should be allocate to first invoice and next the same amount of sales should be
 | allocated to next dated payment from bank.
Case3: | Incase of any partial sales in bank matching the client. Able to get the first partial amount from bank.
Spreadsheet: 129916d1321974511-formula-to-input-a-fixed-value-based-on-a-fixed-threshold-over-a-variable-trend-fill-rate-example
Sheet: Sheet1

Example 1
 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5
Annual fill rate | 0.2 | 0.2 | 0.2 | 0.2 | 0
Cumulative fill rate
additional cost | 3000 | 3000 | 3000 | 3000 | 0
Example 2
 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5
Annual fill rate | 0.2 | 0.2 | 0.15 | 0.15 | 0.09999999999999998
Cumulative fill rate
additional cost | 3000 | 3000 | 0 | 3000 | 3000
Example 3
 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5
Annual fill rate | 0.4 | 0.1 | 0.05 | 0.1 | 0.2
Cumulative fill rate
additional cost |  | 0 | 0 | 3000 | 3000
Spreadsheet: 142048d1329602128-auto-populate-data-from-sheet-1-to-specific-places-in-multiple-other-worksheets-2012-fantasy-golf
Sheet: The PLAYERS

 |  | WEEK 6 The PLAYERS Championship
 |  | Total Earnings |  |  |  | Rankings Through Week 6 | Total
 | [NAME] | 0 |  | 1 |  | [NAME] | 0
 | [NAME] | 0 |  | 2 |  | [NAME] | 0
 | [NAME] | 0 |  | 3 |  | [NAME] | 0
 | Player 4 | 0 |  | 4 |  | Player 4 | 0
 | Player 5 | 0 |  | 5 |  | Player 5 | 0
 | Player 6 | 0 |  | 6 |  | Player 6 | 0
 | Player 7 | 0 |  | 7 |  | Player 7 | 0
 | Player 8 | 0 |  | 8 |  | Player 8 | 0
 | Player 9 | 0 |  | 9 |  | Player 9 | 0
 | Player 10 | 0 |  | 10 |  | Player 10 | 0
 | Player 11 | 0 |  | 11 |  | Player 11 | 0
 | Player 12 | 0 |  | 12 |  | Player 12 | 0
 | Player 13 | 0 |  | 13 |  | Player 13 | 0
[NAME] |  | The PLAYERS |  | YTD
Allenby, [NAME] |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
[NAME]
Allenby, [NAME] |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
[NAME]
Allenby, [NAME] |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 4
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 5
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 6
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 7
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 8
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 9
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 10
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 11
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 12
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 13
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Spreadsheet: 858382d1707105368-copying-data-from-daily-time-break-sheet-test
Sheet: Mon

 | 2024-01-01 00:00:00 | 2024-01-08 00:00:00 | 2024-01-15 00:00:00 | 2024-01-22 00:00:00 | 2024-01-29 00:00:00
TimeSlice | Monday | Monday | Monday | Monday | Monday
08:15:00
08:30:00
08:45:00
09:00:00
09:15:00
09:30:00
09:45:00
10:00:00
10:15:00
10:30:00
10:45:00
11:00:00
11:15:00
11:30:00
11:45:00
12:00:00
12:15:00
12:30:00
12:45:00
13:00:00
13:15:00
13:30:00
13:45:00
14:00:00
14:15:00
14:30:00
14:45:00
15:00:00
15:15:00
15:30:00
15:45:00
16:00:00
16:15:00
16:30:00
16:45:00
17:00:00
17:15:00
17:30:00
17:45:00
18:00:00
18:15:00
18:30:00
18:45:00
19:00:00
19:15:00
19:30:00
19:45:00
20:00:00
20:15:00
20:30:00
20:45:00
21:00:00
21:15:00
21:30:00
21:45:00
22:00:00
22:15:00
22:30:00
22:45:00
23:00:00
23:15:00
23:30:00
23:45:00
00:00:00
00:15:00
00:30:00
00:45:00
01:00:00
01:15:00
Spreadsheet: 02aa8e05-1e2f-4eb3-8d61-20f583913ccf
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
10/03/2014 | Women's Swimming & Diving | Gold-Blue Meet | 03:00 PM
10/10/2014 | Women's Swimming & Diving | West Virginia State Games (Huntington, W.Va.)
10/11/2014 | Women's Swimming & Diving | West Virginia State Games (Huntington, W.Va.) | 09:00 AM
10/23/2014 | Women's Swimming & Diving | Penn State | 05:00 PM
10/25/2014 | Women's Swimming & Diving | at Villanova | 01:00 PM
11/20/2014 | Women's Swimming & Diving | Mizzou Invite (Columbia, Mo.)
11/21/2014 | Women's Swimming & Diving | Mizzou Invite (Columbia, Mo.)
11/22/2014 | Women's Swimming & Diving | Mizzou Invite (Columbia, Mo.)
12/04/2014 | Women's Swimming & Diving | U.S. Winter Nationals (Greensboro, N.C.)
12/05/2014 | Women's Swimming & Diving | U.S. Winter Nationals (Greensboro, N.C.)
12/06/2014 | Women's Swimming & Diving | U.S. Winter Nationals (Greensboro, N.C.)
01/03/2015 | Women's Swimming & Diving | Orange Bowl Classic (Key Largo, Fla.)
01/10/2015 | Women's Swimming & Diving | at Pitt | 12:00 PM
01/16/2015 | Women's Swimming & Diving | TCU | 06:00 PM
01/24/2015 | Women's Swimming & Diving | at Iowa State | 02:00 PM
01/31/2015 | Women's Swimming & Diving | Ohio | 01:00 PM
02/25/2015 | Women's Swimming & Diving | Big 12 Championships (Austin, Texas)
02/26/2015 | Women's Swimming & Diving | Big 12 Championships (Austin, Texas)
02/27/2015 | Women's Swimming & Diving | Big 12 Championships (Austin, Texas)
02/28/2015 | Women's Swimming & Diving | Big 12 Championships (Austin, Texas)
03/12/2015 | Women's Swimming & Diving | NCAA Zone A Diving Championships (Piscataway, N.J.)
03/13/2015 | Women's Swimming & Diving | NCAA Zone A Diving Championships (Piscataway, N.J.)
03/14/2015 | Women's Swimming & Diving | NCAA Zone A Diving Championships (Piscataway, N.J.)
[NAME] | Women's Swimming & Diving | [NAME] (Greensboro, N.C.)
03/20/2015 | Women's Swimming & Diving | [NAME] (Greensboro, N.C.)
03/21/2015 | Women's Swimming & Diving | [NAME] (Greensboro, N.C.)
Spreadsheet: 551925d1513222662-vlookup-isnt-helping-me-with-zip-codes-microsoft-excel-2013-workbook-shell-part-a
Sheet: Avg Sales Tax

State | State Abbreviation | Combined Tax Rate
Alabama | AL | 0.0891
Alaska | AK | 0.0176
Arizona | AZ | 0.0817
Arkansas | AR | 0.0926
California | CA | 0.0844
Colorado | CO | 0.0744
Connecticut | CT | 0.0635
Delaware | DE | 0
Florida | FL | 0.0665
Georgia | GA | 0.0696
Hawaii | HI | 0.0435
Idaho | ID | 0.0601
Illinois | IL | 0.0819
Indiana | IN | 0.07
Iowa | IA | 0.0678
Kansas | KS | 0.082
Kentucky | KY | 0.06
Louisiana | LA | 0.0891
Maine | ME | 0.055
Maryland | MD | 0.06
Massachusetts | MA | 0.0625
Michigan | MI | 0.06
Minnesota | MN | 0.072
Mississippi | MS | 0.0707
Missouri | MO | 0.0781
Montana | MT | 0
Nebraska | NE | 0.068
Nevada | NV | 0.0794
New Hampshire | NH | 0
New Jersey | NJ | 0.0697
New Mexico | NM | 0.0735
New York | NY | 0.0848
North Carolina | NC | 0.069
North Dakota | ND | 0.0656
Ohio | OH | 0.071
Oklahoma | OK | 0.0877
Oregon | OR | 0
Pennsylvania | PA | 0.0634
Rhode Island | RI | 0.07
South Carolina | SC | 0.0713
South Dakota | SD | 0.0583
Tennessee | TN | 0.0945
Texas | TX | 0.0805
Utah | UT | 0.0668
Vermont | VT | 0.0614
Virginia | VA | 0.0563
Washington | WA | 0.0889
West Virginia | WV | 0.0607
Wisconsin | WI | 0.0543
Wyoming | WY | 0.0547
D.C. | DC | 0.0575
Spreadsheet: 17472e09-8832-4dad-a720-6c7ef92c1d1e
Sheet: # Professional Staff

[NAME] vs. [NAME]
Professional Staff (FTE)
 | FY 2007 | FY 2008 | FY 2009 | FY 2010 | FY 2011 | % Change
Peer Average
Peer Median
University of Rhode Island | 21.25 | 16.5 | 15.5 | 15.5 | 17.5
[NAME] University | 24 | 28 | 29 | 30 | 28
Montana State University - Bozeman | 18 | 21 | 21 | 21 | 21
North Dakota State University - Main Campus | 17 | 18 | 16 | U/A | U/A | U/A
University of Maine | 21 | 20.66 | 21 | 21 | 22
University of New Hampshire - Main Campus | 44.15 | 40.75 | 43.1 | 29 | 41
University of Vermont and State Ag. Coll. | 58 | 61.25 | 60 | 60 | 48
University of Wyoming | 55 | 55.19 | 55 | 52 | 51
Source: ACRLMetrics
Revised: May 30, 2012, ajr
Spreadsheet: mary_fischer__25605__926
Sheet: E2.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 0926
COMPANY NAME Artemis Associates
ANALYSIS OF OTHER CURRENT ASSETS
FOR THE PERIOD ENDING 6-30-2001
PREPARED BY: [NAME]
EXTENSION: 52580 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-2
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
Williard & Limbach Interest |  | -505612 |  | -411210
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Total Current Assets | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 195
Asset/Expense Accts:  DR/(CR)
Spreadsheet: 826873d1682348746-merging-data-for-match-cases-vlookup-merge-value-vlookup
Sheet: Preparation

Grid | Sample
A1 |  |  | * If column E of 'Source' worksheet has matched value get that value, if empty return 'Empty' on column B of this worksheet
A1
A1
A2 |  |  | * Would be great if it can be matched with column D instead of column K
A2 |  |  | * Column K is created using formula, contains formula
A2
A3
A3
A3
A4
A4
A4
A5
A5
A5
A6
A6
A6
A7
A7
A7
A8
A8
A8
A9
A9
A9
A10
A10
A10
A11
A11
A11
A12
A12
A12
B1
B1
B1
B2
B2
B2
B3 | 2375410
B3 | 2375410
B3 | 2375410
B4 | 2375369
B4 | 2375369
B4 | 2375369
B5 | 2375371
B5 | 2375371
B5 | 2375371
B6 | 2375409
B6 | 2375409
B6 | 2375409
B7 | 2375408
B7 | 2375408
B7 | 2375408
B8 | 2375408
B8 | 2375408
B8 | 2375408
B9 | 2375400
B9 | 2375400
B9 | 2375400
B10 | 2375389
B10 | 2375389
B10 | 2375389
B11 | 2375364
B11 | 2375364
B11 | 2375364
B12 | 2375362
B12 | 2375362
B12 | 2375362
C1 | 2375364
C1 | 2375364
C1 | 2375364
C2 | 2375364
C2 | 2375364
C2 | 2375364
[NAME] | 2375361
[NAME] | 2375361
[NAME] | 2375361
C4 | 2375361
C4 | 2375361
C4 | 2375361
C5
C5
C5
C6
C6
C6
C7
C7
C7
C8
C8
C8
C9
C9
C9
C10
C10
C10
C11
C11
C11
C12
C12
C12
D1
D1
D1
D2
D2
D2
D3
D3
D3
D4
D4
D4
D5
D5
D5
D6
D6
D6
D7
D7
D7
D8
D8
D8
D9
D9
D9
D10
D10
D10
D11
D11
D11
D12
D12
D12
E1
E1
E1
E2
E2
E2
E3
E3
E3
E4
E4
E4
E5
E5
E5
E6
E6
E6
E7
E7
E7
E8
E8
E8
E9
E9
E9
E10
E10
E10
E11
E11
E11
E12
E12
E12
F1
F1
F1
F2
F2
F2
F3
F3
F3
F4
F4
F4
F5
F5
F5
F6
F6
F6
F7
F7
F7
F8
F8
F8
F9
F9
F9
[NAME]
[NAME]
[NAME]
F11
F11
F11
F12
F12
F12
[NAME]
[NAME]
[NAME]
G2
G2
G2
G3
G3
G3
G4
G4
G4
G5
G5
G5
G6
G6
G6
G7
G7
G7
G8
G8
G8
G9
G9
G9
G10
G10
G10
G11
G11
G11
G12
G12
G12
H1
H1
H1
H2
H2
H2
H3
H3
H3
H4
H4
H4
H5
H5
H5
H6
H6
H6
H7
H7
H7
H8
H8
H8
H9
H9
H9
H10
H10
H10
H11
H11
H11
H12
H12
H12
Spreadsheet: 682753d1592316483-need-to-get-a-tick-mark-in-a-cell-attn
Sheet: Sheet1

Sl | Full name | Attendance
 |  | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Day 8 | Day 9 | Day 10
1 | SHAHANA SHERIN.K P
2 | THABSEERA JANNATH.K |  |  |  |  |  |  |  |  |  |  |  | if I click on any yellow coloured cell I need to get a tick or any such marking showing that the corresponding student is present on that day
3 | [NAME]
4 | THAHDILA THASNEEM.K
5 | SANJANA K
6 | DEVIKA P
7 | GOPIKA.P
8 | SHIBIKA.M
9 | NAFIYA FARSANA.P
10 | GOPIKA.K
11 | ATHUL.M
12 | [NAME]. T
13 | MANYA K M
14 | ROHITH M
15 | MUHAMMED FOUZAN.P
16 | ABHIRAJ.K P
17 | MUHAMMED SHAMIL.P T
18 | ADITHYAN M
19 | ATHUL RAJ K.P
20 | FATHIMA RIFHANA.K.P
21 | MUHAMMED ASHMIL DT
22 | RISHAD ALI
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Feb24-Mar2p

Pavilion
 | 2013-02-24 00:00:00 |  |  | Thru | 2013-03-02 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2013-02-24 00:00:00 | 2013-02-25 00:00:00 | 2013-02-26 00:00:00 | 2013-02-27 00:00:00 | 2013-02-28 00:00:00 | 2013-03-01 00:00:00 | 2013-03-02 00:00:00 |  |  |  | Blocks | Team | Hours
7:15AM |  |  |  |  |  |  |  | 7:15AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 04 Flags | 0
8:15AM |  |  |  |  |  |  |  | 8:15AM |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 02 Flags | 0
9:15AM |  |  |  |  |  |  |  | 9:15AM |  |  | 0 | 01 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 00 Flags | 0
10:15AM |  |  |  |  |  |  |  | 10:15AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 98 Flags | 0
11:15AM |  |  |  |  |  |  |  | 11:15AM |  |  | 0 | Midget A | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | Midget AA | 0
12:15PM |  |  |  |  |  |  |  | 12:15PM
1:15PM |  |  |  |  |  |  |  | 1:15PM
2:15PM |  |  |  |  |  |  |  | 2:15PM
3:15PM |  |  |  |  |  |  |  | 3:15PM
4:15PM |  |  |  |  |  |  |  | 4:15PM
5:15PM |  |  |  |  |  |  |  | 5:15PM
[NAME] |  |  |  |  |  |  |  | [NAME]
7:15PM |  |  |  |  |  |  |  | 7:15PM
8:15PM |  |  |  |  |  |  |  | 8:15PM
9:15PM |  |  |  |  |  |  |  | 9:15PM
10:15PM |  |  |  |  |  |  |  | 10:15PM
11:15PM |  |  |  |  |  |  |  | 11:15PM
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: 60873d1261465016-excel-2007-divide-by-zero-example-fuel
Sheet: Sheet1

DATE | REG | LITRES | OPEN ODO | END ODO | DRIVER | TRAFFIC | TOTAL KM | [NAME] | GALLONS | M.P.G | L/100KM
2009-12-22 00:00:00 | VTZ | 93 | 618974 | 619330 | SMITH | JJ
2009-12-23 00:00:00 | LDL | 96.92 | 884772 | 885142 | McJONES | LL
2009-12-24 00:00:00 | KXM | 94 | 526103 | 526525 | JONES | LC
2009-12-25 00:00:00 | LDJ | 125.01 | 428802 | 429224 | McSMITH | RH
Spreadsheet: 862942d1710508947-pair-wise-multiplication-with-reversed-array-dynamic-formula-without-helper-column-multiplication-with-reversed-array
Sheet: Sheet1

1 |  |  |  | total array
2 |  |  |  |  |  | 2
3 |  |  |  |  |  | 1
1 | 3 |  |  | row by row
2 | 2
3 | 1
Spreadsheet: 13c5e576-64cc-47b1-9bd2-e28ddac0db38
Sheet: Sheet1

 | Foeken | Pawitan | [NAME] | Massague | [NAME]
Best-fit values
Slope | -0.6137 ± 0.03736 | -0.3457 ± 0.08386 | -0.3673 ± 0.06948 | -0.2428 ± 0.1072 | -0.5285 ± 0.07828
Y-intercept when X=0.0 | 0.8062 ± 0.02063 | 0.6620 ± 0.04569 | 0.6786 ± 0.03776 | 0.6111 ± 0.05768 | 0.7182 ± 0.05015
X-intercept when Y=0.0 | 1.314 | 1.915 | 1.848 | 2.517 | 1.359
1/slope | -1.629 | -2.893 | -2.723 | -4.119 | -1.892
Is slope significantly non-zero?
F | 269.8 | 16.99 | 27.95 | 5.13 | 45.59
DFn, DFd | 1.000, 284.0 | 1.000, 157.0 | 1.000, 249.0 | 1.000, 97.00 | 1.000, 36.00
P value | < 0.0001 | < 0.0001 | < 0.0001 | 0.0257 | < 0.0001
Deviation from zero? | Significant | Significant | Significant | Significant | Significant
Data
Number of X values | 286 | 159 | 251 | 99 | 38
Maximum number of Y replicates | 1 | 1 | 1 | 1 | 1
Total number of values | 286 | 159 | 251 | 99 | 38
Number of missing values | 0 | 0 | 0 | 0 | 0
Spreadsheet: 154082d1336187483-using-array-in-find-function-hluk_string_extract_04may12_01
Sheet: Sheet1

code-woeijf98=2j3f2jfp09jf?f023jf0
code-f[wpofk-30fk-fefeiofje;foij;oij+foejfo
code-wefewfwefewfewfewf=fwefewfew
wefe  code-  wfwefewfewfewf=fwefewfew
code-woeijf9802j3f2jfp09jf?f023jf0
Spreadsheet: 823037d1679658748-index-match-book1
Sheet: Sheet1

First Name | Last Name | Product | Sales |  |  |  | Names | Sales | Product
[NAME] | Haynes | Medicine | 56 |  |  |  | [NAME]
Mark | Frost | Seafood | 12 |  |  |  | [NAME]
[NAME] | [NAME] | Eggs | 45 |  |  |  | [NAME]
[NAME] | Rubio | Sweets | 30 |  |  |  | [NAME]
[NAME] | Becker | Dishware | 20 |  |  |  | [NAME]
[NAME] | Lockard | Pasta | 79 |  |  |  | [NAME]
[NAME] | [NAME] | Bread | 54 |  |  |  | [NAME]
Spreadsheet: sara_shackleton__36434__PHONE LIST_APRIL-2000
Sheet: LDC'S NUMBERS

Enron South America
NORTH-EAST
LOCAL DISTRIBUTION COMPANIES
Name | Empresa | Phone | Fax | Mobile
[NAME] | BAHIAGÁS | 71-3409011 | 71-3409001 | 71-91319011
[NAME] | COPERGAS | 81-4632036 | 81-4632030 | 81-99754622
[NAME] | ALGAS | 82-2219407 | 82-3366447 | 82-93316312
Lauro Perdiz | EMSERGAS | 79-2115213 | 79-2115213 | 79-9788796
Claúdio Camargos | PBGAS | 83-2472244 | 83-2472244 | 83-9886711
[NAME] | COPERGAS | 81-4632013 | 81-4632020 | * * * * *
[NAME] | BAHIAGÁS | * * * * * | * * * * * | 71-91349020
Spreadsheet: 124476d1318435025-formula-auto-update-problem-report-log
Sheet: Summary of Log

 | Summary by Department
 | Sales | Outside Sales | Shop | Materials | Accounting | Executive | Building 5
Total Count | 64 | 1 | 10 | 5 | 9 | 2 | 1
Total Percentage | 0.7710843373493976 | 0.01204819277108434 | 0.1204819277108434 | 0.06024096385542169 | 0.108433734939759 | 0.02409638554216868 | 0.01204819277108434
 | Summary by Employee
 | Person | Total Count |  | Person | Total Count
 | Amber | 11 | 0 | [NAME] | 1 | 0
 | [NAME] | 10 | 0 | Lauren | 7 | 0
 | Annette | 6 | 0 | [NAME] | 6 | 0
 | [NAME] | 3 | 0 | [NAME] | 1 | 0
 | [NAME] | 1 | 0 | Nicole | 4 | 0
 | Carol | 1 | 0 | Nina | 1 | 0
 | Cassie | 2 | 0 | [NAME] | 3 | 0
 | [NAME] | 2 | 0 | [NAME] | 7 | 0
 | [NAME] | 1 | 0 | Scot | 2 | 0
 | [NAME] | 2 | 0 | Stacy E | 1 | 0
 | [NAME] | 2 | 0
 | Joy | 4 | 0
 | [NAME] | 1 | 0
 | [NAME] | 1 | 0
 | [NAME] | 1 | 0
Spreadsheet: fa1a7e1f-c558-45ed-ab76-b58f34532e02
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7473 | 57790 | Hitohiko | Sakajiri | JPN | 0 | 00:12:48 | 00:01:26 | 01:18:30 | 00:01:41 | 00:48:30 | 1 | 02:22:55
7473 | 51342 | Tsugimaru | Hamasaki | JPN | 0 | 00:13:53 | 00:01:00 | 01:14:53 | 00:01:16 | 00:55:16 | 2 | [NAME]
Spreadsheet: 694409d1599588420-lookup-first-match-corresponding-to-any-combination-of-values-from-multiple-criteria-lists-2020-09-08-oeldere-markbleking-694371d1599572831-lookup-first-match-corresponding-to-any-comb
Sheet: Sheet1

Table 1 |  |  |  |  |  | Table 2 |  | Table3 |  | Table 4 |  |  |  | Table 5
Data_1 | Data_2 | Data_3 | Date | Time |  | Criteria for Data_2 |  | Criteria for Data_3 |  | Criteria for Data_1 | Table_1[Date+Time] from first match with Table_4[Data_1]*Table_3[Data_3]*Table_2[Data_2] in Table_1 |  |  | Matched row | Matched Data_2 | Matched Data_3 | Matched Date | Matched Time
Red | Boat | No | 2020-06-11 00:00:00 | 14:10:34 |  | Boat |  | No |  | Red |  |  |  |  | Boat | No | 2020-06-11 00:00:00 | 14:10:34
White | Helicopter | No | 2020-06-11 00:00:00 | 14:11:53 |  | Car |  |  |  | White |  |  |  |  | Boat | No | 2020-06-19 00:00:00 | 16:20:17
Blue | Tanks | No | 2020-06-11 00:00:00 | 21:26:42 |  | Train |  |  |  | Blue |  |  |  |  | Car | No | 2020-06-19 00:00:00 | 16:20:21
Green | Bicycle | No | 2020-06-11 00:00:00 | 14:12:19 |  |  |  |  |  | Green |  |  |  |  | Car | No | 2020-06-11 00:00:00 | 21:26:24
Yellow | Space shuttle | No | 2020-06-11 00:00:00 | 16:55:54 |  |  |  |  |  | Yellow |  |  |  |  | Boat | No | 2020-06-11 00:00:00 | 14:10:25
Orange | Helicopter | No | 2020-06-11 00:00:00 | 21:26:54 |  |  |  |  |  | Orange |  |  |  |  | Boat | No | 2020-06-11 00:00:00 | 19:11:47
Purple | Tanks | Yes | 2020-06-19 00:00:00 | 11:37:12 |  |  |  |  |  | Purple |  |  |  |  | Car | No | 2020-06-11 00:00:00 | 14:09:11
[NAME] | Bicycle | No | 2020-06-30 00:00:00 | 07:32:38 |  |  |  |  |  | [NAME] |  |  |  |  | Train | No | 2020-06-11 00:00:00 | 19:11:53
Black | Space shuttle | No | 2020-06-19 00:00:00 | 16:20:09 |  |  |  |  |  | Black |  |  |  |  | Boat | No | 2020-06-11 00:00:00 | 14:10:30
Red | Car | No | 2020-06-19 00:00:00 | 16:20:13
White | Boat | No | 2020-06-19 00:00:00 | 16:20:17
Blue | Car | No | 2020-06-19 00:00:00 | 16:20:21
Green | Train | Yes | 2020-06-11 00:00:00 | 21:31:58
Yellow | Airplane | No | 2020-06-11 00:00:00 | 21:32:01
Orange | Boat | No | 2020-06-11 00:00:00 | 19:11:47
Purple | Car | No | 2020-06-11 00:00:00 | 14:09:11
[NAME] | Train | No | 2020-06-11 00:00:00 | 19:11:53
Black | Boat | Yes | 2020-06-11 00:00:00 | 14:09:13
Red | Helicopter | No | 2020-06-11 00:00:00 | 19:11:56
White | Tanks | No | 2020-06-11 00:00:00 | 19:12:59
Blue | Train | Yes | 2020-06-11 00:00:00 | 14:10:15
Green | Car | No | 2020-06-11 00:00:00 | 21:26:24
Yellow | Boat | No | 2020-06-11 00:00:00 | 14:10:25
Orange | Airplane | No | 2020-06-11 00:00:00 | 19:13:07
Purple | Bicycle | No | 2020-06-11 00:00:00 | 14:10:27
[NAME] | Airplane | No | 2020-06-11 00:00:00 | 19:13:09
Black | Boat | No | 2020-06-11 00:00:00 | 14:10:30
Spreadsheet: 867118d1713997220-changing-template-data-employee-absence-report-copy-
Sheet: July

 | Employee Absence Report
 | July
 | Absence type key | V | Vacation (10) |  |  | P | Paid (2) |  |  | S | Unpaid (1) |  |  | U | Unauthorized |  |  | O | Other
 |  | Dates of absence
 | Employee name | 1 | 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 | Total days
 | [NAME]. M  (PMO) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V |  |  | V | V | V | V | V
 | [NAME]. P  (PMO)
 | [NAME]. R  (GL)
 | [NAME]. M  (GL)
 | Teddy. M  (GL)
 | Krushna. J  (DLO)
 | [NAME]. W  (PFO)
 | Jaxon. B  (PMO)
 | Daman. S (PMO)
 | Alvin. C  (GL)
 | Baldomero. N  (GL)
 | Junner. B  (GL)
 | Heather. C  (PFO)
 | Jordan. B  (LO)
 | Santos. C  (GL)
 | Sunny. I  (GL)
 | Oliver. M  (PR)
 | [NAME]. C  (TL)
 | Justin. H  (YFO)
 | [NAME]. M  (YFO)
 | [NAME]. T  (YFO)
 | [NAME]. B  (SHC)
 | [NAME]. H  (IM)
 | [NAME]. A  (IM)
 | [NAME]. M  (IM)
 | Maryanne. B  (IMA)
 | Art. P  (MF)
 | Fabrice. M  (MF)
 | [NAME]. T (IE)
 | [NAME]. P  (IE)
 | Justin. N  (IEA)
 | Paige. B  (WMR)
 | Maryann. R  (PSC)