tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 816133d1675390940-adjusting-formula-with-nested-if-and-or-functions-example-workbook
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | CrCl | Receipt of RRT | Modality of RRT received? (IHD, SLED, CRRT?) | Dose | Dose ordered appropriate for patients renal function?
 |  |  |  |  |  |  |  |  | 52 | NO |  | 3.375
 |  |  |  |  |  |  |  |  | 60 | NO | IHD | 3.375
 |  |  |  |  |  |  |  |  | 17 | YES | SLED | 3.375
 |  |  |  |  |  |  |  |  | 15 | YES | CRRT | 3.375
 |  |  |  |  |  |  |  |  | 30 | YES | CCRT | 2.25
Spreadsheet: 02e4b555-05a6-40f8-a00e-8401a50136eb
Sheet: 15b

 |  | Transactions
Product |  | HY** | IG | Other
Index Tranche* | Asia |  |  | <100
 | Europe |  |  | 462
 | North America | <100 | <100 | <100
Index | Asia |  | <100 | <100
 | Europe |  |  | 5865
 | North America | 1544 | 2576 | 366
TOTAL |  | 1544 | 2576 | 6693
Estimated swap transaction volumes, February 8 weekly snapshot, by product type and grade (millions of USD), all participant types, tenors and currencies, cleared and uncleared. This table will be expanded to reflect participant type as more complete data becomes available.
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 Data Dictionary for product descriptions.
**See Data Dictionary for product grade descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 0a379928-a7f3-47bb-908f-f8e3939b92db
Sheet: BBC (United Kingdom)

BBC (United Kingdom)
Date | Channel | Start (GMT) | End (GMT) | Notes
2010-11-21 00:00:00 | BBC2 | 14:00:00 | 17:00:00 | Round [NAME] (Singles)
2010-11-22 00:00:00 | BBC2 | 14:00:00 | 15:45:00 | Round [NAME] (Singles)
2010-11-23 00:00:00 | BBC2 | 14:00:00 | 15:45:00 | Round [NAME] (Singles)
2010-11-24 00:00:00 | BBC2 | 14:00:00 | 15:45:00 | Round [NAME] (Singles)
2010-11-25 00:00:00 | BBC2 | 14:00:00 | 15:45:00 | Round [NAME] (Singles)
2010-11-26 00:00:00 | BBC2 | 14:00:00 | 15:45:00 | Round [NAME] (Singles)
2010-11-27 00:00:00 | BBC1 | 14:00:00 | 16:30:00 | Semi-Final 1 - Live (Singles)
2010-11-28 00:00:00 | BBC2 | 17:15:00 | 20:00:00 | Singles Final - Live
Spreadsheet: 775435d1649098712-data-validation-list-not-working-using-dynamic-array-from-table-datavalidn-from-dynarray2
Sheet: Sheet1

 | Vendor | [NAME] |  |  |  |  |  |  | Selected Vendor
 | Acme | SRX 4100 support |  |  |  |  |  |  | Acme
 | Internal | Senior [NAME]
 | Internal | Logistics |  |  |  |  |  |  | Required validation list
 | Acme | EX 4300 support
 | [NAME] | [NAME] blah |  |  |  |  |  |  | EX 4300 support
 | Acme | Something else |  |  |  |  |  |  | Something else
 |  |  |  |  |  |  |  |  | Lst_Test
 |  |  |  | Dynamic lists |  |  |  |  | SRX 4100 support
 | Vendor | [NAME] |  | Acme | Internal | [NAME]
 | Acme | Something else
 | Internal | Logistics |  | EX 4300 support | Logistics
 | [NAME] | [NAME] blah |  | Something else
 | Internal | Senior [NAME]
 | Acme | EX 4300 support
Spreadsheet: 812351d1673088025-help-with-formulas-for-entilement-days-and-service-holiday-tracker-example
Sheet: Bank Holidays

 |  | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030
 |  | 2022-01-01 00:00:00 | 2023-01-02 00:00:00 | 2024-01-01 00:00:00
 |  | 2022-01-03 00:00:00 | 2023-04-07 00:00:00 | 2024-03-29 00:00:00
 |  | 2021-04-15 00:00:00 | 2023-04-10 00:00:00 | 2024-04-01 00:00:00
 |  | 2022-04-18 00:00:00 | 2023-05-01 00:00:00 | 2024-05-06 00:00:00
 |  | 2022-05-02 00:00:00 | 2023-05-08 00:00:00 | 2024-05-27 00:00:00
 |  | 2022-05-30 00:00:00 | 2023-05-29 00:00:00 | 2024-08-26 00:00:00
 |  | 2022-08-29 00:00:00 | 2023-08-28 00:00:00 | 2024-12-25 00:00:00
 |  | 2022-12-25 00:00:00 | 2023-12-25 00:00:00 | 2024-12-26 00:00:00
 |  | 2022-12-26 00:00:00 | 2023-12-26 00:00:00
 |  | 2022-12-27 00:00:00
Spreadsheet: 5c331dee-fcae-4be6-9936-72fe2762dcc2
Sheet: General Ledger Transmittal Form

 |  |  |  | General [NAME] Form
 |  |  |  | [NAME] your data in these cells
 |  |  |  | Formula Driven Cells - Formula will automatically calculate
 |  |  |  | See comment boxes for form instructions
TRANSMITTAL CODE: | TRANSMITTAL NUMBER: |  |  | FROM:
 |  |  |  | DATE:
 |  |  |  | BY:
Transmittal Amounts
Currency
Coin
Subtotal Cash
Checks
Total Transmittal:
CURRENCY |  |  |  | COIN
[NAME] | Number of Bills | Amount |  | Coin | Number of Coins | Amount
100 |  |  |  | DOLLARS
50 |  |  |  | [NAME]
20 |  |  |  | QUARTERS
10 |  |  |  | DIMES
5 |  |  |  | NICKELS
2 |  |  |  | PENNIES
1 |  |  |  | TOTAL:
TOTAL:
Funds
Fund | Org | Account | Program | Check Amount | Check Number | Cash Amount | Description/Student Name & ID
 |  |  |  | Total Check Amount |  | Total Cash Amount
Spreadsheet: 85285d1285320111-how-to-show-data-based-on-search-criteria-search2
Sheet: Sheet1

ID Number | Name | Address | Phone Number | Parent Name
111 | Edrick [NAME] | Jl. [NAME] 38, Sukajadi | 421991 | Edy Pratama (pdmk) | 0
121 | [NAME] | Villa Marina Blok B /3A | [PHONE]/431868/7077668 | [NAME] | 0
136 | [NAME] * | [NAME] | 423071 | [NAME] | 0
6514 | Edrick Purba | Komp. TOP 100 Blok B No. 8 | 450530 | [NAME] | 0
106 | [NAME] (pdmk) | Blok III Urashima | [PHONE]/457260 | Sherine (pdmk) | 0
16156 | Edrick | Nagoya Paradise Center Q / 25 | 425405 / 7027298/[PHONE] | Shelton * | 1
15616 | [NAME] | Komp.[NAME] 30 | 452785 / 455829/[PHONE] | Agnes Ashianti * | 1
321 | Derrick * | [NAME] Indah Blok A / 3 | 433119 | Sherwin * | 1
1658 | [NAME] | Blok III Nagasaki | 7041389/[PHONE] | [NAME] | 1
 | Choose: | Write:
Search by: | Phone Number | 42
ID Number | Name | Address | Phone Number | Parent Name
16156 | Edrick | Nagoya Paradise Center Q / 25 | 425405 / 7027298/[PHONE] | Shelton *
 |  |  |  |  | I want to type a Name, then all the table below (in Yellow) will show those matched, or show those match part of the name (Edrick for example)
Search by Name : |  | Edrick
ID Number | Name | Address | Phone Number | Parent Name
111 | Edrick [NAME] | Jl. [NAME] 38, Sukajadi | 421991 | Edy Pratama (pdmk)
6514 | Edrick Purba | Komp. TOP 100 Blok B No. 8 | 450530 | [NAME]
16156 | Edrick | Nagoya Paradise Center Q / 25 | 425405 / 7027298/[PHONE] | Shelton *
 |  |  |  |  | I want to type an address, then all the table below (in Yellow) will show those matched, or show those match part of it (Blok III for example)
Search by Address : |  | [NAME]
ID Number | Name | Address | Phone Number | Parent Name
106 | [NAME] (pdmk) | Blok III Urashima | [PHONE]/457260 | Sherine (pdmk)
1658 | [NAME] | Blok III Nagasaki | 7041389/[PHONE] | [NAME]
136 | [NAME] * | [NAME] | 423071 | [NAME]
 |  |  |  |  | I want to type a phone number, then all the table below (in Yellow) will show those matched, or show those match part of it (7027298 for example)
Search by Phone Number : |  | 7027298
ID Number | Name | Address | Phone Number | Parent Name
16156 | Edrick | Nagoya Paradise Center Q / 25 | 425405 / 7027298/[PHONE] | Shelton *
 |  |  |  |  | I want to type a Parent Name, then all the table below (in Yellow) will show those matched, or show those match part of the parent name ([NAME] for example)
Search by Parent Name : |  | [NAME]
ID Number | Name | Address | Phone Number | Parent Name
6514 | Edrick Purba | Komp. TOP 100 Blok B No. 8 | 450530 | [NAME]
121 | [NAME] | Villa Marina Blok B /3A | [PHONE]/431868/7077668 | [NAME]
Spreadsheet: 287411d1388779524-create-a-consolidated-list-ef559_sample-workbook
Sheet: Customer by Rep

Select Sales Rep |  |  |  |  |  |  |  |  | Reps
HOUS |  |  |  |  |  |  |  |  | AARO
 |  |  |  |  |  |  |  |  | BRAD
Customers |  |  |  |  |  |  |  |  | BREN
 |  |  |  |  |  |  |  |  | DENN
 |  |  |  |  |  |  |  |  | DON
 |  |  |  |  |  |  |  |  | DONN
 |  |  |  |  |  |  |  |  | FERN
 |  |  |  |  |  |  |  |  | HOUS
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | QUIN
 |  |  |  |  |  |  |  |  | MARK
Spreadsheet: 129517d1321645907-if-and-to-extact-item-from-table-or-not-solved-simpson_location
Sheet: Sheet2

location | load | truck | driver |  |  |  |  |  |  |  |  |  |  |  |  | term | supplier |  |  |  |  |  |  | mileage
big sky | 3 | T7 | B | 7500 |  |  |  | 1000 |  | 1500 |  |  |  |  |  | HLN | Sincl | 0.3
Lakeside | 4 | T7 | B | 2000 |  |  |  |  |  |  |  |  |  |  |  | HLN | Sincl | 0.3
I90 Truck Stop | 5 | T7 | B |  |  |  |  |  |  | 7500 | 4000 |  |  | 1000 |  | HLN | Fklr | 0.3 |  | stareon in all #2 products
Stromberg's | 6 | cc | DX | 9000 |  |  |  | 1000 |  | 1800 |  |  |  |  |  | GRF | Sincl | 0.3
GF Sinclair | 7 | T18 | K |  |  |  |  |  |  | 1999 |  |  |  |  |  | GRF | Sincl | 0.3
H&R #5 | 7 | T18 | K | 7000 |  |  |  | 2000 |  | 1400 |  |  |  |  |  | GRF | Fklr | 0.3
H&R #4 | 8 | T18 | K | 4000 |  |  |  | 1400 |  |  |  |  |  |  |  | GRF | Fklr | 0.3
H&R #1 | 8 | T18 | K | 5300 |  |  |  | 1500 |  |  |  |  |  |  |  | GRF | Sincl | 0.3
GF Sinclair | 8 | T18 | K |  |  |  |  | 1001 |  |  |  |  |  |  |  | GRF | Sincl | 0.3
Joyco #1 -stn | 9 | T18 | K | 4000 |  | 1400 |  |  |  |  |  |  |  |  |  | GRF | Sincl | 0.3
[NAME] (bulk) | 9 | T18 | K | 2650 |  |  |  |  |  | 2650 |  |  |  | 2500 |  | GRF | Sincl | 0.3 |  | [NAME]
Spreadsheet: 217037d1361973963-use-data-from-non-consecutive-rows-into-a-consecutive-rows-on-a-different-worksheet-example2
Sheet: Sheet1

Line | Data
1 | 0.7688849594143207
2 | 0.03573437344933239
3 | 0.823803113620778
4 | 0.5437173754563408
5 | 0.3553966329524073
6 | 0.8473049330449338
7 | 0.9934672425492607
8 | 0.6999762584647768
9 | 0.5709758785383477
10 | 10th Row
11 | 0.7813965563809949
12 | 0.2876958247343226
13 | 0.828612467248037
14 | 0.4267628038914644
15 | 0.6585688778288235
16 | 0.348795303071869
17 | 0.7407834878088799
18 | 0.6286933601168668
19 | 0.4821755851444018
20 | 20th Row
Spreadsheet: 79122d1279359341-from-range-2-calendar-copy-of-calendar
Sheet: Sheet1

 | 2010 | 2010-07-06 00:00:00 | 2010-07-07 00:00:00 | 2010-07-08 00:00:00 | 2010-07-09 00:00:00 | 2010-07-10 00:00:00 | 2010-07-11 00:00:00 | 2010-07-12 00:00:00 | 2010-07-13 00:00:00 | 2010-07-14 00:00:00 | 2010-07-15 00:00:00 | 2010-07-16 00:00:00 | 2010-07-17 00:00:00 | 2010-07-18 00:00:00 | 2010-07-19 00:00:00 | 2010-07-20 00:00:00 | 2010-07-21 00:00:00 | 2010-07-22 00:00:00 | 2010-07-23 00:00:00 | 2010-07-24 00:00:00 | 2010-07-25 00:00:00 | 2010-07-26 00:00:00 | 2010-07-27 00:00:00 | 2010-07-28 00:00:00 | 2010-07-29 00:00:00 | 2010-07-30 00:00:00 | 2010-07-31 00:00:00 | 2010-08-01 00:00:00 | 2010-08-02 00:00:00 | 2010-08-03 00:00:00 | 2010-08-04 00:00:00 | 2010-08-05 00:00:00
 | [NAME]
 | [NAME] | 17.5 |  |  |  |  | 22
 | [NAME] | 10 |  | 20 |  |  |  |  |  |  | 65 |  |  |  |  |  |  |  | 17
 | [NAME] |  |  |  |  |  | 10
 | [NAME] |  |  |  | 25
 | [NAME] |  |  |  |  |  |  | 120
 | Date | Name |  | Amount
 | 2010-07-06 00:00:00 | [NAME] |  | 10
 | 2010-07-06 00:00:00 | [NAME] |  | 17.5
 | 2010-07-08 00:00:00 | [NAME] |  | 20
 | 2010-07-09 00:00:00 | [NAME] |  | 25
 | 2010-07-11 00:00:00 | [NAME] |  | 10
 | 2010-07-11 00:00:00 | [NAME] |  | 13
 | 2010-07-11 00:00:00 | [NAME] |  | 9
 | 2010-07-12 00:00:00 | [NAME] |  | 120
 | 2010-07-15 00:00:00 | [NAME] |  | 65
 | 2010-07-23 00:00:00 | [NAME] |  | 17
Spreadsheet: 767763d1644608340-multi-criteria-list-and-vlookup-player-game-min-times
Sheet: Data

Name | Game | Score | Completion Time | [NAME] | Date | Trainer Session |  |  |  |  | NAME | GAME | First lowest score
[NAME] | Basics | 7000 | 00:10:00 | 60 | 2010-02-01 00:00:00 | [NAME] |  |  |  |  |  | Basics
[NAME] | Advanced | 5000 | 00:08:00 | 30 | 2010-02-01 00:00:00 | [NAME] |  |  |  |  | [NAME] | Advanced
Ruchir | Basics | 6200 | 00:07:00 | 55 | 2010-02-02 00:00:00 | [NAME] |  |  |  |  | Ruchir | Basics
[NAME] | Basics | 7100 | 00:09:50 | 62 | 2010-02-02 00:00:00 | [NAME] |  |  |  |  | Ruchir | Bonus
Ruchir | Bonus | 4000 | 00:02:00 | 80 | 2010-02-03 00:00:00 | [NAME] |  |  |  |  | Ruchir | Advanced
[NAME] | Basics | 8000 | 00:09:00 | 98 | 2010-02-04 00:00:00 | [NAME]
[NAME] | Advanced | 6000 | 00:08:30 | 70 | 2010-02-04 00:00:00 | [NAME]
Ruchir | Basics | 6300 | 00:07:00 | 58 | 2010-02-04 00:00:00 | [NAME]
[NAME] | Advanced | 8000 | 00:07:00 | 80 | 2010-02-05 00:00:00
Ruchir | Advanced | 8500 | 00:07:15 | 99 | 2010-02-05 00:00:00
[NAME] | Basics | 8600 | 00:08:22 | 100 | 2010-02-05 00:00:00
Spreadsheet: darrell_schoolcraft__7314__imball0202
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635
3531 |  | -36051
60667 | -4 | -111778
60749 |  | 13946
61206
61334
62960
INDEX
2002-01-31 00:00:00 |  |  | 10533
2002-02-03 00:00:00
CBS Volume
2001-12-31 00:00:00 |  |  | 3422
Spreadsheet: 90577093-d949-47d1-b4c2-be60d5709cd6
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
FCLOM | Test | FCLOM | [NAME]) and Desmethylclomipramine | [NAME]) | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | Plain, Red-Top Tube: Red |  |  | 2 |  | Submit only 1 of the following:   Serum Draw blood in a plain, red-top tube(s). (Serum gel tube is not acceptable.) Spin down and send 2 mL of serum refrigerate in plastic vial. Note:  1. Indicate serum on request form.           2. Label specimen appropriately (serum).           3. Trough levels are most reproducible.   [NAME] blood in a green-top (sodium heparin) tube(s). ([NAME] tube is not acceptable.) Spin down and send 2 mL of plasma refrigerate in plastic vial. Note:  1. Indicate plasma on request form.           2. Label specimen appropriately (plasma).           3. Trough levels are most reproducible. | 0.2 mL  Note: Submission of the | Specimens other than	Serum or [NAME] other than	Red-top, Sodium heparin Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icteric	NA | [NAME]  Desired clomipramine concentrations for the treatment of chronic pain:  20 - 85 ng/mL  Test Performed by: Medtox Laboratories, Inc.                               402 W. County Road D                               St. Paul, MN 55112 | Monday through Sunday | 3 days | 5 - 7 days | 1 | 82542 |  |  |  |  | Medtox Laboratories, Inc
FCLOM | Result | Z2573 | Clomipramine | Clomipramine | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
FCLOM | Result | Z2574 | Desmethylclomipramine | Desmethylclomipramine | Numeric |  |  |  |  | ng/ml |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 273766d1382902800-countif-with-variable-range-excel-countif-answer
Sheet: Log

 |  |  | Count | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00
 |  |  |  | Met | Missed | Missed | Met | Missed
 |  |  | Objective
 |  |  | Count the number of occurrences of the word "Missed" in the five months ended with the current month
 |  |  | The current month is a variable, and is listed on the worksheet named Month, cell D6
 |  |  | Place the result in cell D7
 |  |  | No VBA
 |  |  | Considerations
 |  |  | The dates in row 6 are currently entered as the first day of each month (e.g., 10-1-13).  However, they could actually be any date in that month (e.g., 10-16-13).
 |  |  | The Month specified on the worksheet named Month currently has a value of the first day of the month (i.e., 10-1-13).  However, the date could actually be entered as any day in that month (e.g., 10-28-13)
Spreadsheet: 09279f50-ca70-4529-a1b2-2d9bb8cc538b
Sheet: Detailed Construction Costs

 |  | Construction Cost Summary
 |  | Item | Units | Unit Cost | Quantity Phase I | Cost Phase I | Quantity Phase II | Cost Phase II | Total
 |  | Mobilization and Demobilization | LS |  |  | 12000 |  | 150000
 |  | Construction Area Signs | EA | 500 | 6 |  | 7
 |  | Traffic Control | LS |  |  | 45000 |  | 35000
 |  | Water Pollution Control | LS |  |  | 10000 |  | 40000
 |  | Sub grade Replacement | CY | 55 | 225 |  | 650
 |  | Control of Water | LS |  |  | 6000 |  | 18000
 |  | Clearing and Grubbing | LS |  |  | 24000 |  | 50000
 |  | Temporary Shoring and Trench Safety | LS |  |  | 20000 |  | 45000
 |  | Adjust Utility Cover to Grade | EA | 400 | 3 |  | 5
 |  | Adjust Existing Manhole Cover to Grade | EA | 1000 | 3 |  | 5
 |  | Type of GI Drainage Inlet | EA | 4000 | 3 |  | 5
 |  | 6'-24" storm drain pipe | LF | 102 | 120 |  | 96
 |  | Replace Asphalt Concrete Surfacing | LS |  |  | 4000 |  | 8600
 |  | Excavation and Grading | CY | 18 | 2317 |  | 6000
 |  | Embankment /Imported Borrow | CY | 30 | 488 |  | 2000
 |  | Grade Drainage Swale | LF | 5 | 1200 |  | 4700
 |  | Class II Aggregate Base | CY | 50 | 4200 |  | 9600
 |  | RSP (1/4 ton) | Ton | 100 | 50 |  | 250
 |  | Segmental Block Retaining Wall | SF | 50 | 285 |  | 0
 |  | Asphalt Concrete | Ton | 100 | 1500 |  | 2800
 |  | Concrete Curb / gutter | LS |  |  | 25200
 |  | Minor Concrete (sidewalk, ramps) | LS |  |  | 73000 |  | 25000
 |  | Cast in Concrete Footings | CY | 1800 | 40 |  | 116
 |  | Concrete Structures | EA | 13500 | 8 |  | 40
 |  | [NAME] | EA |  | 1 | 30000 | 3 | 860000
 |  | Concrete Bridge Decking | LS |  | 1 | 25000 | 2 | 67000
 |  | Wood Rail Fence | LF | 50 | 1500 |  | 9600
 |  | Chain Link Fence | LF | 55 | 140 |  | 0
 |  | Guard Rail Detectable Warning Systems (Truncated Doms) | LS |  |  | 5000 |  | 5000
 |  | Thermoplastic and signs (road, way finding, interpretative) | LS |  |  | 80000 |  | 47000
 |  | Relocate Street Lights | LS |  |  | 6000
 |  | Mitigation and avoidance measures | LS |  |  | 986689 |  | 668058
 |  | Total
Spreadsheet: 93179d1292784797-selecting-particular-text-from-sentence-selecting-particular-text
Sheet: Sheet1

TEAM | TEAM LEADER
[NAME] FERNANDES GOVINDAN MADHU SUB 0012 2152 2536 | ARRY
MUTHU MANU MADHAN JOSEPHIN DONI MUNIANAN 2356 [PHONE] | MANU
[NAME] JASMINE FERSTLY HUDSON PETERSON 4582 5852 7585 2548 | MEGAN
TEAM | TEAM LEADER
[NAME] FERNANDES GOVINDAN MADHU SUB 0012 2152 2536 | FERNANDES
MUTHU MANU MADHAN JOSEPHIN DONI MUNIANAN 2356 [PHONE] | MADHAN
[NAME] JASMINE FERSTLY HUDSON PETERSON 4582 5852 7585 2548 | JASMINE
TEAM | TEAM LEADER
[NAME] FERNANDES GOVINDAN MADHU SUB 0012 2152 2536 | GOVINDAN
MUTHU MANU MADHAN JOSEPHIN DONI MUNIANAN 2356 [PHONE] | JOSEPHIN
[NAME] JASMINE FERSTLY HUDSON PETERSON 4582 5852 7585 2548 | FERSTLY
Spreadsheet: 812378d1673110395-split-string-into-separate-columns-without-delimiter-s666-pq-example-split-string-to-columns
Sheet: Sheet1

Cmp | Div | [NAME] | Function | Sts | Option 1-9 | Function keys | Option 10-99
790 | AAA | BUDGET | BUS1 | 20 | 111111111 | 1,11111111111111E+23 | 1.11111111111111e+89
790 | AAA | BUDGET | BUS2 | 20
790 | AAA | BUDGET | BUS3 | 20
790 | AAA | BUDGET | BUS4 | 20
790 | AAA | BUDGET | BUS5 | 20
790 | AAA | BUDGET | BUS6 | 20
790 | AAA | BUDGET | BUS7 | 20
790 | AAA | BUDGET | [NAME] | 20
790 | AAA | BUDGET | BUS9 | 20
Spreadsheet: 113312d1309266938-which-formla-need-to-use-book1
Sheet: Sheet1

 | Approved
Ref No. | Status | Completed Request | Answer
254656 | Approved | 254656
254656 | Rejected | 254657
254657 | Approved | 254658
254658 | Submitted | 254656
254658 | Approved | 254658
Spreadsheet: 024b11b8-d3ef-4fe0-8d4e-70736d293274
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
 | 6302.0 Average Weekly Earnings, Australia
 | TABLE 11A. Average Weekly Earnings, New South Wales (Dollars) - Trend
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
Earnings; [NAME]; Full Time; Adult; Ordinary time earnings ;  New South Wales ; |  |  | Trend | A2799571W | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; [NAME]; Full Time; Adult; Total earnings ;  New South Wales ; |  |  | Trend | A2799574C | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; [NAME]; Total earnings ;  New South Wales ; |  |  | Trend | A2799580X | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Females; Full Time; Adult; Ordinary time earnings ;  New South Wales ; |  |  | Trend | A2799572X | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Females; Full Time; Adult; Total earnings ;  New South Wales ; |  |  | Trend | A2799575F | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Females; Total earnings ;  New South Wales ; |  |  | Trend | A2799581A | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Persons; Full Time; Adult; Ordinary time earnings ;  New South Wales ; |  |  | Trend | A2799573A | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Persons; Full Time; Adult; Total earnings ;  New South Wales ; |  |  | Trend | A2799576J | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Persons; Total earnings ;  New South Wales ; |  |  | Trend | A2799582C | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
© Commonwealth of Australia  2013
Spreadsheet: 783141d1654611291-filter-out-text-containing-a-period-using-forum_ex-solved
Sheet: data

job number | item | item as text | plant | customer | qty | description | dept | ship-date | job-pln | shp-pln | Price | mch-mat | [NAME] | mch-epl
[PHONE] | 30 |  | SAB | ZINC NACIONAL S.A. | 1 | RAM10 AIRLOCK | M/S | 2022-04-08 00:00:00 | 2022-04-01 00:00:00 |  | 19948 | 316SS | 316SS X | SP CP X
[PHONE] | 10 |  | SAB | JC CROSS COMPANY | 1 | RAM10 AIRLOCK JC CROSS COMPANY | M/S | 2022-05-27 00:00:00 | 2022-05-27 00:00:00 |  | 15507 | 316SS | RETURN=TEFLON | RETURN=TEFLON
[PHONE] | 10.1 |  | SAB | JC CROSS COMPANY | 1 | RAM10 AIRLOCK JC CROSS Food Grade Teflon Coating | M/S | 2022-06-03 00:00:00 | 2022-05-13 00:00:00 |  |  | 316SS | 316SS TEFLON X | SP HT TEFLON X
[PHONE] | 10 |  | SAB | AMERICAS STYRENICS DE COLOMBIA LTDA | 1 | RAM10 AIRLOCK | M/S | 2022-06-17 00:00:00 | 2022-06-10 00:00:00 |  | 15633 | SS | SS X | [NAME]
[PHONE] | 10 |  | SAB | CARGILL INC | 1 | RAM10 AIRLOCK | M/S | 2022-06-17 00:00:00 | 2022-06-10 00:00:00 |  | 15986 | SS | SS X | SP  X
[PHONE] | 20 |  | SAB | BUFFALO TRACE DISTILLERY | 1 | RAM10 AIRLOCK | M/S | 2022-06-17 00:00:00 | 2022-06-10 00:00:00 |  | 12173 | SS | SS | SP
[PHONE] | 10 |  | SAB | MCKEE FOODS CORP | 1 | RAM10 AIRLOCK | M/S | 2022-07-01 00:00:00 | 2022-06-24 00:00:00 |  | 15055 | SS | SS | SP TS4
[PHONE] | 901 |  | SAB | SOLVAY SPECIALTY POLYMERS USA LLC | 1 | RAM10 AIRLOCK | M/S | 2022-07-08 00:00:00 | 2022-07-01 00:00:00 |  | 18044 | SS | SS | SP TS4 HT
[PHONE] | 50.1 |  | SAB | K BIN INC | 1 | WEAR RESISTANT RAM10 AIRL - W.R. | M/S | 2022-07-15 00:00:00 | 2022-06-10 00:00:00 |  |  | SS | WR | SP CP W.R.
[PHONE] | 50 |  | SAB | K BIN INC | 1 | WEAR RESISTANT RAM10 AIRL | M/S | 2022-07-15 00:00:00 | 2022-07-08 00:00:00 |  | 22858 | SS | RETURN=WR | RETURN=WR
Spreadsheet: 765586d1643394822-select-different-formulas-if-within-multiple-value-ranges-thresholds-example
Sheet: Sheet1

Price | 76
Threshold | 65
Calculation
Range
Low | High | % | Deduct
65 | 70 | 0.2 | 0
70 | 75 | 0.25 | 0.25
75 | 80 | 0.3 | 0.75
80 | 85 | 0.35 | 1.5
85 |  | 0.4 | 2.5