tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 752539d1634822549-compare-text-in-2-workbooks-and-copy-paste-corresponding-values-file1
Sheet: Sheet1

 |  |  |  |  |  | Name | [NAME]
1 |  |  |  |  |  | Bally 2018 | 1 |  | Column H…Manually inserted results
2 |  |  |  |  |  | [NAME] | 7
3 |  |  |  |  |  | Ashok 124203 | 4
4 |  |  |  |  |  | Dr Aju | 3
5 |  |  |  |  |  | Dr [NAME] | 11
6 |  |  |  |  |  | [NAME] | 6
7 |  |  |  |  |  | [NAME] | 3
8 |  |  |  |  |  | [NAME] | 7
9 |  |  |  |  |  | [NAME] | 4
10 |  |  |  |  |  | Kamal | 1
11 |  |  |  |  |  | [NAME] | 1
12 |  |  |  |  |  | [NAME] | 4
13
14
15
16
17
18
19
20
Spreadsheet: 235783d1368605026-team-standings-ad-softball-league-schedule-and-results-may-2fjuly-2013
Sheet: Results

Abu Dhabi Softball League
- Schedule - Results - Standings -
May 14 - July 2, 2013 // 7:00-11:00PM
SCHEDULE |  |  |  | RESULTS |  |  |  |  | Standings |  | Points
Tuesday, May 14 |  | Umps |  | Score |  | Won | Lost |  | 1st | [NAME] | 2
19:00:00 | 1 v 2 | 3 |  | 22 | 4 | 1 | 2 |  | 2nd | Ballbarians | 2
20:00:00 | 3 v 4 | 1 |  | 2 | 9 | 3 | 4 |  | 3rd | Mother Falcons | 2
21:00:00 | 5 v 6 | 8 |  | 9 | 7 | 5 | 6 |  | 4th | Blue Jays | 2
10:00 PM | 7 v 8 | 5 |  | 14 | 13 | 7 | 8 |  | 5th | Millennium Falcons | 0
 |  |  |  |  |  |  |  |  | 6th | [NAME] | 0
Tuesday, May 21 |  | Umps |  | Score |  | Won | Lost |  | 7th | Abu Dhabi Mudcrabs | 0
19:00:00 | 4 v 7 | 6 |  |  |  |  |  |  | 8th | Benchwarmers | 0
20:00:00 | 6 v 8 | 4
21:00:00 | 2 v 5 | 7 |  |  |  |  |  |  |  | Team | W | L | T | Pts | Runs For | Runs Against | (+)/(-)
10:00 PM | 1 v 3 | 2 |  |  |  |  |  |  |  | [NAME] | 1 | 0 | 0 | 2
 |  |  |  |  |  |  |  |  |  | Millennium Falcons | 0 | 1 | 0 | 0
Tuesday, May 28 |  | Umps |  | Score |  | Won | Lost |  |  | Ballbarians | 1 | 0 | 0 | 2
19:00:00 | 2 v 4 | 3 |  |  |  |  |  |  |  | [NAME] | 0 | 1 | 0 | 0
20:00:00 | 3 v 7 | 1 |  |  |  |  |  |  |  | Mother Falcons | 1 | 0 | 0 | 2
21:00:00 | 1 v 6 | 7 |  |  |  |  |  |  |  | Abu Dhabi Mudcrabs | 0 | 1 | 0 | 0
10:00 PM | 5 v 8 | 6 |  |  |  |  |  |  |  | Blue Jays | 1 | 0 | 0 | 2
 |  |  |  |  |  |  |  |  |  | Benchwarmers | 0 | 1 | 0 | 0
Tuesday, June 4 |  | Umps |  | Score |  | Won | Lost
19:00:00 | 3 v 6 | 5
20:00:00 | 1 v 5 | 4
21:00:00 | 4 v 8 | 1
10:00 PM | 2 v 7 | 8
Tuesday, June 11 |  | Umps |  | Score |  | Won | Lost
19:00:00 | 1 v 4 | 7
20:00:00 | 5 v 7 | 4
21:00:00 | 2 v 6 | 3
10:00 PM | 3 v 8 | 2
Tuesday, June 18 |  | Umps |  | Score |  | Won | Lost
19:00:00 | 4 v 6 | 2
20:00:00 | 2 v 8 | 6
21:00:00 | 3 v 5 | 8
10:00 PM | 1 v 7 | 5
Tuesday, June 25 |  | Umps |  | Score |  | Won | Lost
19:00:00 | 4 v 5 | 1
20:00:00 | 1 v 8 | 4
21:00:00 | 6 v 7 | 3
10:00 PM | 2 v 3 | 7
Tuesday, July 2 |  | Umps |  | Score |  | Won | Lost
19:00:00 | NA
20:00:00 | NA
21:00:00 | NA
10:00 PM | NA
Spreadsheet: 177681d1346395315-auto-fill-with-conditions-using-if-vlookup-excel-forum
Sheet: Sheet3

 |  |  |  | (Given info)
 | (outcome) |  |  | PO# | Ctns |  |  |  |  | Expected Result
Ctn. 1 | IV661445 |  |  | IV661445 | 1 | - | 1 |  |  | Ctn. 1 | IV661445
Ctn. 2 | IV661446 |  |  | IV661446 | 2 | - | 2 |  |  | Ctn. 2 | IV661446
Ctn. 3 | IV661448 |  |  | IV661448 | 3 | - | 3 |  |  | Ctn. 3 | IV661448
Ctn. 4 | IV661447 |  |  | IV661447 | 4 | - | 8 |  |  | Ctn. 4 | IV661447
Ctn. 5 | IV661449 |  |  | IV661449 | 9 | - | 9 |  |  | Ctn. 5 | IV661447
Ctn. 6 | 0 |  |  |  |  |  |  |  |  | Ctn. 6 | IV661447
Ctn. 7 | 0 |  |  |  |  |  |  |  |  | Ctn. 7 | IV661447
Ctn. 8 | 0 |  |  |  |  |  |  |  |  | Ctn. 8 | IV661447
Ctn. 9 | 0 |  |  |  |  |  |  |  |  | Ctn. 9 | IV661449
Spreadsheet: 249bfce0-99f9-4114-9391-07f2d6d4ef86
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 47. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (TAS), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | A2413748X | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413749A | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413750K | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413751L | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413752R | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413753T | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413754V | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413755W | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413756X | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413757A | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413758C | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 2eb0bfe9-6ae5-4acc-a546-43ab20aa973a
Sheet: IDG

Revised 7/1/2013 |  |  |  | Journal Number
Type in the shaded areas only.       Please do not change the format of this Excel file.
 | CAMPUS MAIL CENTER |  | CHARGE & CREDIT
 |  | PO BOX 442282 MOSCOW ID 83844-2282                885-7011
 |  |  | E-mail:
Budget number | Department: |  | [NAME]: | Contact: | Phone number:
(and Activity code):
 | Approved in Department by: |  |  | Date In:
CREDIT
 | Department |  | Zip Code | Contact | Phone
 | Campus Mail Center |  | 2282       * | [NAME] | 885-7011
INDEX | FUND | DESCRIP | ACCT | ACTV | AMOUNT
RAY050 |  | LABOR | R3573E
RAY050 |  | NCOA |  | NCOARA
RAY050 |  | PRINTING | R3572E
RAY050 |  | TABBING | R3572E | TABBQC
RAY050 |  | FOLDER/INSERTER | R3572E | FOLDRA
 | CMS Approval Signature |  | DROP DATE: | Date Processed | TOTAL
[NAME] | PIECES | AMOUNT EACH | TOTAL | NOTES:
Address Printing |  | 0.07 |  | Class of Mail: (Nonprofit, STD or presort first class)
Indicia Printing |  | 0.01
Return Add. Printing |  | 0.01 |  | Address layout:
Sealing |  | 0.01 |  | (which fields get printed in the address)
Tabbing KT2 |  | 0.02
Tabbing TA25 |  | 0.03
Manual Labeling |  | 41
Manual Inserting |  | 41
Bundle/Sack/Tray |  | 41 |  | Description of mailpiece:
Fold/Insert-DS100 |  | 41 |  | (ex: size of env or piece, contents)
Fold/Insert-M3000 |  | 41
[NAME] |  | 0.015
Foreign processing |  | 0.15
Merge/Purge |  | 41 |  | Mailing list file name:
CASS/PAVE |  | 41
Extended Services |  | 0.005
Process List |  | 41 |  | Special request:
Permit Postage
Metered  Postage
Outsourced paperwork |  | 41
Total Pieces
Mailing Date
10=
TH=
SZ= |  |  | FULL SERVICE
Database name: |  |  | LD JOB ID:
Spreadsheet: 86679d1286633811-combo-box-lookup-only-projectdatadb
Sheet: SubContractor

Date | Name | HourlyRate | Hours | Total | Superannuation | Workers Comp | Payroll Tax | PLSL | LAFHA
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 780374d1652429391-formula-for-sequential-id-with-letters-and-numbers-number-sequencing-for-id-aligw
Sheet: Sheet1

ID (as number) | ID (as text)
Spreadsheet: 839872d1692274552-drop-down-list-with-multiple-levels-grouped-by-category-test-multilevel-drop-down-list
Sheet: Sheet1

Vegetables | Carrots |  |  | Shipments
Vegetables | [NAME] |  |  | Carrots
Vegetables | Eggplant
Vegetables | Bell pepper
Fruits | Apple
Fruits | Pear
Fruits | [NAME]
Fruits | Lemon
Fruits | Orange
Fruits | [NAME]
Fruits | Lychee
Cans | Tomato
Cans | Green beans
Cans | [NAME]
Cans | Lentils
Cans | Corn
Cans | Raviolis
Drink | Coca-cola
Drink | Orange juice
Drink | Sprite
Drink | Water
Spreadsheet: 102584d1300510006-simple-iterations-itterations
Sheet: Sheet1

Itt
0.2 |  | <<Click on this cell and grab the bottom right handle and drag.
Spreadsheet: 673240d1587280453-please-check-where-is-the-problem-so-that-not-getting-result-in-column-d-file-1
Sheet: Sheet1

 | S.No. | Year |  | Entry | Batch | Sample
Entry | 1 | 1980 |  |  | 3000
 | 2 | 1985 |  |  | 3200
 | 3 | 1984 | Entry 1 | 3000,3200,8000 | 8000
 | 4 | 1982 |  |  | 4000
 | 5 | 1981 |  |  | 2000
 | 6 | 1986 | Entry 2 | 4000,2000,3000 | 3000
 | 7 | 1987 |  |  | 8000
 | 8 | 1988 | Entry 3 | 3000,8000,4000 | 4000
 | 9 | 1999 |  |  | 6000
 | 10 | 2000 | Entry 4 | 4000,6000,3000 | 3000
 | 11 | 2001 |  |  | 5000
 | 12 | 2002 |  |  | 6000
Spreadsheet: benjamin_rogers__1044__Peaker Valuation 060500
Sheet: Wilton

INCOME STATEMENT - WILTON CENTER
('000 $) | 2000-01-01 00:00:00 | 2000-12-31 00:00:00 | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 |  | Check
Capacity Prices ($/kW-mo)
Capacity Revenue from Desk (Real $)
Capacity Revenue from Desk (Nominal $)
Expense
Mobilization |  |  | 0 | 0
Fixed Operation & Maintenance
Variable Operation & Maintenance
Major Maintenance & Ongoing Capex
O&M Management Fee
Owner's Expense
Property Taxes
Total Expense
EBITDA
Salvage Value |  | 0 | 0
Without Salvage Value
Net Equity Cashflow | 0
Weighted Average Cost of Capital
Enterprise Value
With Salvage Value
Net Equity Cashflow | 0
Weighted Average Cost of Capital
Enterprise Value
Spreadsheet: 701204d1603620065-how-to-divide-some-value-specific-number-of-times-in-different-number-of-cells-excel
Sheet: Sheet1

COMPANY |  |  |  |  |  |  |  |  |  |  |  |  | BUYER
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 | total kupovina | 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 | rate
 |  |  |  |  |  |  | 400 |  |  |  |  |  | 100 |  |  |  |  |  |  |  |  | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 200 |  |  |  | 50 | 50 | 50 |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  | 100 |  |  | 25 | 25 | 25 | 25
 |  |  |  |  |  |  |  |  | 100 |  |  |  | 25 | 25 | 25 |  |  |  |  |  |  |  |  | 25
200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 50 | 50 | 50
 |  |  |  |  |  |  |  |  | 300 |  |  |  | 75 | 75 | 75 |  |  |  |  |  |  |  |  | 75
Spreadsheet: 693714d1599110369-worksheet-to-another-worksheet-and-data-sheet-sorting-and-totaling-forum-sample09-02-1-newsumproduct
Sheet: Sheet1

 |  | last month | 2020-08-01 00:00:00 | 2020-08-02 00:00:00 | 2020-08-03 00:00:00 | 2020-08-04 00:00:00 | 2020-08-05 00:00:00 | 2020-08-06 00:00:00 | 2020-08-07 00:00:00 | 2020-08-08 00:00:00 | 2020-08-09 00:00:00 | 2020-08-10 00:00:00 | 2020-08-11 00:00:00 | 2020-08-12 00:00:00 | 2020-08-13 00:00:00 | 2020-08-14 00:00:00 | 2020-08-15 00:00:00 | 2020-08-16 00:00:00 | 2020-08-17 00:00:00 | 2020-08-18 00:00:00 | 2020-08-19 00:00:00 | 2020-08-20 00:00:00 | 2020-08-21 00:00:00 | 2020-08-22 00:00:00 | 2020-08-23 00:00:00 | 2020-08-24 00:00:00
 | Number of plans |  | 100 | 80 | 53 | 66 | 77 | 88 | 92 | 55 | 36 | 64 | 26 | 112
TV | VSL |  | 56 |  | 61
TV | AIR |  | 36 | 86
TV | balance | 300 | 292 | 298 | 306 | 240 | 163 | 75 | -17 | -72 | -108 | -172 | -198 | -310
 | Number of plans
AA | VSL |  | 1
AA | AIR |  | 2
AA | balance
 | Number of plans
SS | VSL
SS | AIR
SS | balance
 | Number of plans
QQ | VSL
QQ | AIR
QQ | balance
 | Number of plans
RR | VSL |  |  |  |  |  |  |  |  |  |  | 100
RR | AIR |  |  |  |  |  |  |  |  |  |  | 600
RR | balance
Spreadsheet: 95029d1294747299-automatically-update-a-couple-of-columns-from-master-worksheet-in-other-sheets-masterhelp
Sheet: Comms

 | Comm. Type | [NAME] | Txt | Phone | [NAME] | Letter
 | Comm. Date | 2009-02-01 00:00:00 | 2009-05-02 00:00:00 | 2010-05-02 00:00:00 | 2010-06-02 00:00:00 | 2010-08-02 00:00:00
 | Comm. Sub. | aaa | bbb | [NAME] | ddd | eee
Name | Comm. Ref. | xxxxxx | xxxxxx | xxxxxx | xxxxxx | xxxxxx
[NAME] |  | y | y | n | n | n
[NAME] |  | y | n | y | y | y
[NAME] |  | y | n | y | y | y
[NAME] |  | y | n | y | y | n
[NAME] |  | y | n | y | y | n
Spreadsheet: 840396d1692708457-conutifs-row-and-column-data
Sheet: summary

 | ACTON
 | HEO Learning Needs Analysis
 |  |  |  |  |  | COUNT & % (count/heo)
 | Learning Area | Courses | Reference | Media | Access From | 1 | 2 | 3 | 4
 |  | NAME
 | Induction &  Onboarding | DWP Induction | N/A | Various | Intranet
 |  | ODP Induction Learning (2020) | N/A | E Learning | Civil Service Learning
 |  | Diversity and inclusion - I Can Be Me campaign | N/A | Open Learning | Intranet
 |  | [NAME] | N/A | Open Learning | Intranet
Spreadsheet: 726079d1617034678-how-can-i-use-2-criteria-in-one-cell-sample
Sheet: Sheet1

TEAM SCORES
SCORES | DPA | TOTAL | OUCH | MTM | SPOT ON | WOW | AVG score
1
0.8
0.75
0.5
1 | fail
0.25
0.6
Spreadsheet: 840310d1692639092-populate-data-into-field-based-on-numbers-example-sheet-2-
Sheet: Sheet2

Reference | LeadGroup | Status | Telephone1 | Total Dials | Total Duration Talking | Last call time
196219131 | PPC Leads | [NAME] | 7302089232
196235552 | Web Leads | No Answer | 7469193999 |  |  | 19:11:00
196215613 | Web Leads | IVA Prospect | 7470082888 |  |  | 19:29:00
196240648 | PPC Leads | DNQ - Other Reason | 7488303232
196180071 | Web Leads | [NAME] | 7512672111
196181054 | PPC Leads | Call Back - Initial stage | 7534562232
196217750 | PPC Leads | Sold PBS | 7547264232
196221053 | PPC Leads | No Answer | 7725126232
196229828 | Web Leads | DNQ - Affordability Issue | 7776755222
196225583 | Web Leads | Not Interested | 7908358232
Spreadsheet: 110546d1307152182-extracting-summed-numerical-values-into-individual-cells-possibleoutcome-copy
Sheet: Sheet1

 | Dendritic spine length |  |  |  |  |  | From B4 or B5 |  | grouping
 |  |  |  |  |  |  | Ungrouped
 | Total Amounts in each cells ► | 5 | 5 | 5 | 7 |  |  |  | Branch 1
 | 3.89 | 0.57 | 0.57 | 0.57 | 0.25 |  | 0.57 |  | 0.57
 | 3.89 | 1.15 | 1.15 | 1.15 | 0.365 |  | 1.15 |  | 1.15
 | 3.93 | 0.69 | 0.69 | 0.73 | 1.25 |  | 0.69 |  | 0.69
 | 44657.09 | 0.9 | 0.9 | 0.9 | 44.365 |  | 0.9 |  | Branch 2
 |  | 0.58 | 0.58 | 0.58 | 33.25 |  | 0.58 |  | 0.9
 |  |  |  |  | 32563.25 |  |  |  | 0.58
 |  |  |  |  | 12014.36
Spreadsheet: 54111d1254143790-find-duplicates-by-name-and-date-help
Sheet: Sheet3

Date | FirstInitial | LastInitial | Gender | DateOfBirth | Unique ID
2009-08-17 00:00:00 | N | W | Male | 1981-03-24 00:00:00 | N-W-24/03/1981-M
2009-07-10 00:00:00 | I | M | Male | 1977-09-11 00:00:00 | I-M-11/09/1977-M
2009-07-23 00:00:00 | I | M | Male | 1977-09-11 00:00:00 | I-M-11/09/1977-M
2009-08-27 00:00:00 | I | M | Male | 1977-09-11 00:00:00 | I-M-11/09/1977-M
2009-08-17 00:00:00 | J | M | Male | 1973-02-11 00:00:00 | J-M-11/02/1973-M
2009-08-18 00:00:00 | D | J | Male | 1976-11-07 00:00:00 | D-J-07/11/1976-M
2009-07-21 00:00:00 | P | D | Male | 1972-08-21 00:00:00 | P-D-21/08/1972-M
2009-07-26 00:00:00 | C | T | Female | 1989-06-23 00:00:00 | C-T-23/06/1989-F
2009-08-26 00:00:00 | C | T | Female | 1989-06-23 00:00:00 | C-T-23/06/1989-F
2009-07-27 00:00:00 | R | B | Male | 1982-01-19 00:00:00 | R-B-19/01/1982-M
2009-07-28 00:00:00 | J | P | Male | 1976-05-13 00:00:00 | J-P-13/05/1976-M
2009-08-04 00:00:00 | J | P | Male | 1976-05-13 00:00:00 | J-P-13/05/1976-M
2009-08-23 00:00:00 | J | P | Male | 1976-05-13 00:00:00 | J-P-13/05/1976-M
2009-07-15 00:00:00 | S | R | Male | 1990-06-30 00:00:00 | S-R-30/06/1990-M
2009-07-26 00:00:00 | M | D | Male | 1975-08-15 00:00:00 | M-D-15/08/1975-M
Spreadsheet: 128196d1320849411-how-to-calculate-time-from-decimal-numbers-salary-calculation
Sheet: Sheet1

Name of Employee | Date | In | Out | In | Out | Absent | Total Daily Hours
[NAME] | 2011-01-01 00:00:00 | 8.05 | 13.05 | 15 | 18.2
[NAME] | 2011-01-01 00:00:00 | 8.06 | 13 | 15 | 18.3
[NAME] | 2011-01-01 00:00:00 | 8 | 13 | 15 | 18.2
[NAME] | 2011-01-02 00:00:00 |  |  |  |  | A
[NAME] | 2011-01-02 00:00:00 | 8 | 13 | 15 | 18.06
[NAME] | 2011-01-02 00:00:00 | 8 | 13 | 15 | 18.04
[NAME] | 2011-01-03 00:00:00 | 8.1 | 13 | 15 | 18.07
[NAME] | 2011-01-03 00:00:00 | 8.15 | 13 | 15 | 18.06
[NAME] | 2011-01-03 00:00:00 | 8 | 13 | 15 | 18.07
[NAME] | 2011-01-04 00:00:00 | 8.2 | 13 | 15 | 18.07
[NAME] | 2011-01-04 00:00:00 | 8 | 13 | 15 | 18.08
[NAME] | 2011-01-04 00:00:00 |  |  |  |  | A
[NAME] | 2011-01-05 00:00:00 | 8.02 | 13.2 | 15 | 18.09
[NAME] | 2011-01-05 00:00:00 | 8 | 13.1 | 15 | 18.09
[NAME] | 2011-01-05 00:00:00 | 8 | 13.02 | 15 | 18.1
[NAME] | 2011-01-06 00:00:00 | 8 | 13.2 | 15 | 18.1
[NAME] | 2011-01-06 00:00:00 | 8 | 13.02 | 15 | 18.11
[NAME] | 2011-01-06 00:00:00 | 8 | 13.05 | 15 | 18.11
[NAME] | 2011-01-07 00:00:00 | 8.05 | 13.06 | 15 | 18.12
[NAME] | 2011-01-07 00:00:00 | 8 | 13.04 | 15 | 18.06
[NAME] | 2011-01-07 00:00:00 | 8 | 13 | 15 | 18.04
[NAME] | 2011-01-08 00:00:00 | 8.03 | 13 | 15 | 18.3
[NAME] | 2011-01-08 00:00:00 | 8 | 13 | 15 | 18.3
[NAME] | 2011-01-08 00:00:00 |  |  |  |  | A
[NAME] | 2011-01-09 00:00:00 | 8.1 | 12.5 | 15 | 17.56
[NAME] | 2011-01-09 00:00:00 | 8.2 | 12.4 | 15 | 17.53
[NAME] | 2011-01-09 00:00:00 | 8.2 | 12.4 | 15 | 17.5
[NAME] | 2011-01-10 00:00:00 | 8.1 | 13.04 | 15 | 17.47
[NAME] | 2011-01-10 00:00:00 | 8.12 | 13.06 | 15 | 17.45
[NAME] | 2011-01-10 00:00:00 | 8.1 | 13.3 | 15 | 17.42
 |  |  |  |  |  |  |  | Total Hours for the month | Hourly rate | salary for the month
 |  |  |  |  |  |  | [NAME] |  | 10
 |  |  |  |  |  |  | [NAME] |  | 12.5
 |  |  |  |  |  |  | [NAME] |  | 12
Spreadsheet: 268639d1380722017-function-to-flag-non-alphanumeric-characters-in-a-text-string-958682
Sheet: Sheet1

Test é
Test ü |  |  |  |  |  |  |  |  | _x0002__x0003__x0004__x0005__x0006__x0007__x0008__x000B__x000C__x000E__x000F__x0010__x0011__x0012__x0013__x0014__x0015__x0016__x0017__x0018__x0019__x001A__x001B_!"#$%'()*+,-./:;<=>?@[\]^`{|}~€‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ¡¢£¤¥[NAME]©ª«¬­®¯°±²³´µ¶·¸¹º»¼½¾¿ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõö÷øùúûüýþÿ
Test etc a
characters like a,
test <>/|;:'.,
clean text
Spreadsheet: aa01caa2-46ce-41da-bbaa-ef39819e762d
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
RPTL | Test | RPTL | Reptilase Time, Plasma | Reptilase Time, P | Clot-Based Assay Measures conversion of fibrinogen to fibrin clot after addition of reptilase. | Light blue-top (citrate) tube: LgtBlu |  |  | 1 | Varies | See Coagulation Studies in Special Instructions.   Specimen Type: Platelet-poor plasma Collection Container/Tube: Light-blue top (citrate) Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: 1. Spin down, remove plasma, and spin plasma again.  2. Freeze specimen immediately at < or =-40 degrees C, if possible. Additional Information: 1. Double-centrifuged specimen is critical for accurate results as platelet contamination may cause spurious results. 2. Each coagulation assay requested should have its own vial. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK - refreeze - note to lab Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | 14-23 seconds | Monday through Friday | 1 hour | 4 days | 1 | 85635 |  |  |  |  | Rochester
RPTL | [NAME] | NACIT | [NAME] |  |  |  | Frozen | 14 days
RPTL | Result | RPTL | Reptilase Time, P | Reptilase Time, P | Numeric |  |  |  |  | sec |  |  |  |  |  |  |  |  |  | 6683-7 | Coagulation reptilase induced:Time:Pt:PPP:Qn:Coag
Spreadsheet: 217169d1361997229-help-with-stock-take-multiple-listings-of-part-numbers-that-need-to-be-accumulated-help-required-variance-report
Sheet: Sheet1

Part Number | On Hand |  | Part Number | Counted |  | Part Number | On Hand | Counted | [NAME]
00771-00240 | 50 |  | 00771-00240 | 29
00771-00320 | 50 |  | 00771-00320 | 32
00771-00480 | 50 |  | 00771-00480 | 12
0124072 | 5 |  | 00890-1087 | 1
0124074 | 6 |  | 0124072 | 6
0134072 | 4 |  | 0124074 | 5
0134074 | 4 |  | 0134072 | 2
0144072 | 2 |  | 0134074 | 4
0183-9005 | 2 |  | 0144072 | 3
0276062 | 1 |  | 0144074 | 9
0286062 | 2 |  | 0183-9005 | 0
0296062 | 0 |  | 0276062 | 0
0371472 | 2 |  | 0286062 | 1
0381472 | 3 |  | 0296062 | 3
0391472 | 0 |  | 0371472 | 0
11021 | 1 |  | 0381472 | 0
20132 | 0 |  | 0391472 | 0
20133 | 0 |  | 11021 | 1
20183 | 0 |  | 20132 | 2
20196 | 10 |  | 20133 | 2
20197 | 41 |  | 20144 | 3
 |  |  | 20183 | 0
 |  |  | 20196 | 10
 |  |  | 20197 | 40