tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: errol_mclaughlin_jr__10106__Financial Scripts
Sheet: Fin Exchange

Test Type: Estate Integration Test
Script Name:  Gas Financial Exchange - TAGG
Product Line: | Financial
Description:  Verify that deal entry data can be entered, processed internally, and exported to downstream.
Prepared by:  [NAME] |  | Date:  1/8/2002
Executed by: |  | Date: | Application Version:
Prerequisites: Global Data
Test Scenario:  Deal traded, invoice created in Unify, booked in SAP and paid by Treasury WS
Step # | Required Action | Data Parameters | Expected Results | Actual Results | Comments | Pass/Fail
1 | TAGG - Deal Entry - Errol McLaughlin | Exchange : Nymex
 |  | Commodity : NG
 |  | Buy/Sell : Buy
 |  | Flag : F (Future)
 |  | Quantity : 100
 |  | Month : G02
 |  | Price : $3
 |  | Book : NG-PRICE
 |  | Trader : [NAME]
 |  | Broker : Man
2 - 13 | Refer to Gas Financial Master Test Script
Spreadsheet: 140785d1328889619-vlookup-function-incorrect-__invoice2
Sheet: Invoice

 |  |  | Invoice to:
 | Invoice No
 | Date
 | QTY | Decription | Unit Price | NET | VAT |  | TOTAL
 | 1 | 5" x 4" Print | 0.1 | 0.08333333333333334 | 0.01666666666666666 |  | 0.1
 | 10 | 12" x 10" Print | 0.65 | 5.416666666666667 | 1.083333333333333 |  | 6.5
1
 | Delivery | 1st Class | 2.49 | 2.075 | 0.415 |  | 2.49
 |  |  |  |  | Subtotal |  | 7.575
 |  |  |  |  | VAT |  | 1.515
 |  |  |  |  | TOTAL |  | 9.09
Spreadsheet: 146677d1332304363-scanning-criteria-of-one-worksheet-against-another-and-if-met-return-certain-data-tony_excel-match-problem
Sheet: Sheet2

tenant name | premises
A | 5
B | 7
Q | 5
S | 3
A | 2
N | 1
S | 4
Q | 4
A | 3
E | 1
J | 1
B | 1
N | 0
D | 2
Spreadsheet: 816539d1675690722-sort-unique-value-over-multiple-sheets-ignoring-zeros-book2
Sheet: Sheet3

 | 74500150
 | 74500140
 | 74500160
 | 74500100
 | 15707262
 | 67402894
 | 60034963
 | 67401552
 | 74110109
 | 74110111
 | 74110105
 | 74110107
 | 74110106
 | 74110108
 | 66001547
 | 66001504
 | 66001209
 | 66001213
 | 15268301
 | 74110109
 | 74110111
 | 74110105
 | 74110106
 | 74110107
 | 74110108
 | 74110112
 | 74110113
 | GSM LETTERS
Spreadsheet: daren_farmer__5337__hplc_prior_to_0500production
Sheet: finaled

HPLC
FINALED INVOICES
Gaither Petroleum Corp. | -709.8 | TEMP_20976 | Apr-00 | tvalade |  |  | -182 | NO | 0 | 0
ICC Energy Corporation | -28447.17 | TEMP_21075 | May-00 | tvalade |  |  | -9147 | NO | 0 | 0
ICC Energy Corporation | -13025 | TEMP_19523 | Aug-99 | tvalade |  |  | -5000 | NO | 0 | 0
ICC Energy Corporation | -99.48999999999978 | TEMP_19358 | Apr-00 | tvalade |  |  | -33 | NO | 0 | 0
Shell Oil Company | 68608.37 | TEMP_21233 | May-00 | klilly |  |  | 15234 | Yes | 68608.37 |  | Vol Mgt - A. Luong | Calc sheet given to [NAME] for revision-meter 1581 volume changed - Corrected 6/26/2000
Shell Oil Company | -36125.95 | TEMP_21232 | May-00 | klilly | hpl | 1060/1061/1581 | -11777 | NO | 0 | 0 | Vol Mgt - A. Luong | This invoice to be netted with [NAME]. payable with $35 difference - to be written off
El Paso Merchant Energy - Gas, L.P. | 1993.42 | TEMP_17131 | Feb-00 | tvalade |  |  | 748
Haldor Topsoe Inc. | -2079.74 | TEMP_19164 | Mar-00 | tvalade | HPL | 988025 | 0 |  | 0 |  | Risk/D.Baumbach | need to change price back to 125% | done
Haldor Topsoe Inc. | -1517.27 | [NAME] | Nov-99 | tvalade | HPL | 988026 | 0 |  | 0 |  | Risk/D.Baumbach | need to change price back to 125% | done
Haldor Topsoe Inc. | -1385.68 | TEMP_19159 | Jul-99 | tvalade | HPL | 988027 | 0 |  | 0 |  | Risk/D.Baumbach | need to change price back to 125% | done
Haldor Topsoe Inc. | -1349.12 | TEMP_19162 | Jan-00 | tvalade | HPL | 988028 | 0 |  | 0 |  | Risk/D.Baumbach | need to change price back to 125% | done
Haldor Topsoe Inc. | -1345.73 | TEMP_19161 | Sep-99 | tvalade | HPL | 988029 | 0 |  | 0 |  | Risk/D.Baumbach | need to change price back to 125% | done
Haldor Topsoe Inc. | -1306.2 | TEMP_19158 | Dec-99 | tvalade | HPL | 988030 | 0 |  | 0 |  | Risk/D.Baumbach | need to change price back to 125% | done
Haldor Topsoe Inc. | -1011.68 | TEMP_19156 | Oct-99 | tvalade | HPL | 988031 | 0 |  | 0 |  | Risk/D.Baumbach | need to change price back to 125% | done
Haldor Topsoe Inc. | -820.8500000000022 | TEMP_19160 | Aug-99 | tvalade | HPL | 988032 | 0 |  | 0 |  | Risk/D.Baumbach | need to change price back to 125% | done
Haldor Topsoe Inc. | -1770.65 | TEMP_19163 | Feb-00 | tvalade | HPL | 988033 | 0 |  | 0 |  | Risk/D.Baumbach | need to change price back to 125%
Spreadsheet: 847204d1698244294-transpose-with-formulas-a-table-efh_test
Sheet: Sheet1

 | Staff ID | Fruit | Status
 | 21-0550 | Apple | 1
 | 21-1000 | [NAME] | 0
 | 21-4550 | Peach | 1
 | 22-1400 | [NAME] | 1
 | 22-7000 | [NAME] | 1
 | 22-7000 | Apple | 0
 | 22-7890 | Mango | 0
 | 23-1220 | Pineapple | 1
 | 23-2100 | Pineapple | 1
 | 23-2100 | [NAME] | 1
 | 23-3450 | [NAME] | 0
Spreadsheet: 117393d1312768995-linking-cells-draft
Sheet: SoS

 | Fantasy weeks 1-14
 | TEAM | QB | RB | WR | TE | K | DEF
 | ARI | 7 | 31 | 3 | 32 | 11 | 6 |  | Strength of schedule is important tool in the arsenal of serious fantasy football drafters. By knowing what players have easier schedules you'll be able to make the hard decisions between two players.  Our Strength of Schedule rankings are based on fantasy points (performance scoring) allowed by position. #1 is the best/easiest/most favorable schedule for that position and #32 is the hardest/least favorable schedule. #1 means that the opponents that the team faces during the selected period allow the most fantasy points. Click the table headers to sort.  For example, the team listed as #1 for QBs has the best/easiest/most favorable schedule for the selected time frame because those opponents surrendered the most fantasy points to QBs over the last 16 weeks.  We are currently using 2010 data, but will update regularly during the 2011 season to use the last 16 weeks of data.
 | ATL | 20 | 4 | 28 | 3 | 15 | 4
 | BAL | 13 | 26 | 10 | 23 | 1 | 21
 | BUF | 6 | 29 | 12 | 20 | 26 | 22
 | CAR | 23 | 17 | 22 | 22 | 21 | 16
 | CHI | 27 | 3 | 32 | 9 | 32 | 17
 | CIN | 8 | 15 | 14 | 7 | 6 | 31
 | CLE | 15 | 23 | 7 | 26 | 3 | 15
 | DAL | 2 | 10 | 8 | 25 | 10 | 13
 | DEN | 30 | 28 | 29 | 21 | 31 | 9
 | DET | 31 | 27 | 18 | 29 | 28 | 2
 | GB | 29 | 16 | 27 | 27 | 29 | 1
 | HOU | 28 | 22 | 21 | 16 | 17 | 24
 | IND | 24 | 21 | 16 | 18 | 24 | 32
 | JAX | 25 | 25 | 25 | 10 | 14 | 25
 | KC | 22 | 19 | 31 | 14 | 30 | 14
 | MIA | 1 | 8 | 11 | 2 | 20 | 26
 | MIN | 32 | 2 | 30 | 12 | 27 | 18
 | NE | 11 | 30 | 20 | 11 | 25 | 19
 | NO | 19 | 14 | 17 | 13 | 19 | 27
 | NYG | 9 | 11 | 15 | 8 | 8 | 10
 | NYJ | 5 | 1 | 13 | 5 | 16 | 28
 | OAK | 17 | 12 | 24 | 1 | 22 | 23
 | PHI | 4 | 24 | 1 | 30 | 12 | 8
 | PIT | 16 | 9 | 4 | 19 | 4 | 30
 | SD | 14 | 7 | 19 | 4 | 23 | 29
 | SEA | 18 | 32 | 2 | 31 | 9 | 12
 | SF | 12 | 5 | 6 | 28 | 2 | 5
 | STL | 10 | 13 | 9 | 24 | 5 | 3
 | TB | 21 | 20 | 26 | 15 | 18 | 11
 | TEN | 26 | 6 | 23 | 6 | 13 | 20
Spreadsheet: 695420d1600196397-need-help-to-loop-a-statement-to-shorten-code-test
Sheet: Table2

Number | 0 | 3 | 6 | 9 | 12 | 15
101010405120W300 | 429 | 432 | 435 | 438 | 441 | 444
101021105020W300 | 414 | 417 | 420 | 423 | 426 | 429
Spreadsheet: 713809d1610954926-how-to-data-from-four-colums-but-list-two-of-them-under-each-other-example
Sheet: Example

date | Test | Test2 | Test3 |  | How I want data to be converted
2021-01-01 00:00:00 | 50 | 1900 | 3000
2021-01-05 00:00:00 | 500 | 1900 | 3000
etc
Spreadsheet: 142517d1329882731-excel-2007-consolidating-different-values-under-different-names-indifferent-tabs-to-master-sheet-varification-doc
Sheet: OKHLA II

OKHLA II |  |  |  |  |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA |  |  |  | OKHLA
SNO | Part Code | Description | Qty | Qty (As on Date 16th Jan-2012)
Section-V,  Part A, SNO-3, 5 | PE-SV Router, PE-SDN Router |  | 1
Existing Material Redeployment
A | Power System
 | 200 AH Battery |  | 2
Spreadsheet: 328169d1403802232-vlookup-with-rows-with-identical-numbers-formula-help-for-yes-1
Sheet: Sheet1

0 | Loc # | MP # | MP Name | [NAME] | MP with multiple Instrument numbers? | Device # |  | Status | District: North or South | Tech | Inspect semi-annually
1 | 2 | 00002MP01 |  |  |  |  |  |  | North
 | 2 | 00002MP01 |  |  |  |  |  |  | North
2 | 4 | 00004MP02 |  |  |  |  |  |  | North
 | 4 | 00004MP02 |  |  |  |  |  |  | North
3 | 5 | 00005MP01 |  |  |  |  |  |  | North
 | 5 | 00005MP01 |  |  |  |  |  |  | North
4 | 5 | 00005MP02 |  |  |  |  |  |  | North
 | 5 | 00005MP02 |  |  |  |  |  |  | North
5 | 6 | 00006MP01 |  |  |  |  |  |  | North
 | 6 | 00006MP01 |  |  |  |  |  |  | North
6 | 9 | 00009MP01 |  |  |  |  |  |  | North
 | 9 | 00009MP01 |  |  |  |  |  |  | North
7 | 31 | 00031MP01 |  |  |  |  |  |  | North
 | 31 | 00031MP01 |  |  |  |  |  |  | North
8 | 33 | 00033MP01 |  |  |  |  |  |  | North
 | 33 | 00033MP01 |  |  |  |  |  |  | North
9 | 35 | 00035MP01 |  |  |  |  |  |  | North
 | 35 | 00035MP01 |  |  |  |  |  |  | North
10 | 43 | 00043MP02 |  |  |  |  |  |  | North
 | 43 | 00043MP02 |  |  |  |  |  |  | North
11 | 44 | 00044MP01 |  |  |  |  |  |  | North
 | 44 | 00044MP01 |  |  |  |  |  |  | North
12 | 44 | 00044MP02 |  |  |  |  |  |  | North
13 | 51 | 00051MP01 |  |  |  |  |  |  | North
 | 51 | 00051MP01 |  |  |  |  |  |  | North
14 | 70 | 00070MP01 |  |  |  |  |  |  | North |  | Yes
 | 70 | 00070MP01 |  |  |  |  |  |  | North
15 | 70 | 00081MP01 |  |  |  |  |  |  | North |  | Yes
 | 70 | 00081MP01 |  |  |  |  |  |  | North
16 | 70 | 00114MP01 |  |  |  |  |  |  | North
 | 114 | 00114MP01 |  |  |  |  |  |  | North
17 | 123 | 00123MP01 |  |  |  |  |  |  | North |  | Yes
 | 123 | 00123MP01 |  |  |  |  |  |  | North
18 | 125 | 00125MP01 |  |  |  |  |  |  | North |  | Yes
 | 125 | 00125MP01 |  |  |  |  |  |  | North
19 | 125 | 00125MP02 |  |  |  |  |  |  | North
20 | 126 | 00126MP01 |  |  |  |  |  |  | North |  | Yes
 | 126 | 00126MP01 |  |  |  |  |  |  | North
Spreadsheet: 758864d1639133210-split-cell-value-based-on-number-after-every-number-appereance-in-cell-example
Sheet: Sheet1

text | formula to extract text based on number position  in array (as a word) | formula to extract number position in array (as a word) | formula to extract text based on last number |  | desired output
1614 Împrumuturi externe din emisiuni de obligaţiuni garantate de stat 1615 Împrumuturi externe din emisiuni de obligaţiuni garantate de bănci |  |  |  |  | 1614 Împrumuturi externe din emisiuni de obligaţiuni garantate de stat | 1615 Împrumuturi externe din emisiuni de obligaţiuni garantate de bănci
1614 Împrumuturi externe din emisiuni de obligaţiuni garantate de stat 1615 Împrumuturi externe din emisiuni de obligaţiuni garantate de bănci 1616 Împrumuturi interne din emisiuni de obligaţiuni garantate de stat |  |  |  |  | 1614 Împrumuturi externe din emisiuni de obligaţiuni garantate de stat | 1615 Împrumuturi externe din emisiuni de obligaţiuni garantate de bănci | 1616 Împrumuturi interne din emisiuni de obligaţiuni garantate de stat
1614 Împrumuturi externe din emisiuni de obligaţiuni garantate de stat 1615 Împrumuturi externe din emisiuni de obligaţiuni garantate de bănci 1616 Împrumuturi interne din emisiuni de obligaţiuni garantate de stat 1617 [NAME] din emisiuni de obligaţiuni |  |  |  |  | 1614 Împrumuturi externe din emisiuni de obligaţiuni garantate de stat | 1615 Împrumuturi externe din emisiuni de obligaţiuni garantate de bănci | 1616 Împrumuturi interne din emisiuni de obligaţiuni garantate de stat | 1617 [NAME] din emisiuni de obligaţiuni
 | 1615 | 11
 | 1616 | 21
Spreadsheet: 42186d1240763711-determin-x-value-from-a-y-681229-interpolation
Sheet: Infomation Sheet

 | Lactate vx. Power Profile - Cycling
 | Power  [W] | RPE | Heartrate  [bpm] | Lactate  [mMol/L]
 | 100 | 0.5 | 130 | 0.9
 | 130 | 1 | 133 | 1.1
 | 160 | 2 | 142 | 1.2
 | 190 | 3 | 153 | 2.4
 | 220 | 4 | 160 | 4.3
 | 250 | 5.5 | 168 | 7.2
 | 280 | 7.5 | 173 | 9.1
Interpolations
Name | Power  [W] | RPE | Heartrate  [bpm] | Lactate  [mMol/L]
LT | ??? | ??? | ??? | ???
L2 | 180 | 2.666666666666667 | 149.3333333333333 | 2
L3 | 199.4736842105263 | 3.315789473684211 | 155.2105263157895 | 3
[NAME] | 215.2631578947368 | 3.842105263157895 | 158.8947368421053 | 4
OBLA | ??? | ??? | ??? | ???
Added plots
L2 | 180 |  | 149.3333333333333
 | 180 |  | 0
L3 | 199.4736842105263 |  | 155.2105263157895
 | 199.4736842105263 |  | 0
[NAME] | 215.2631578947368 |  | 158.8947368421053
 | 215.2631578947368 |  | 0
Spreadsheet: 858979d1707460930-formula-to-get-shifts-from-a-difrent-tab-where-to-look-at-name-and-date-sheet-1-ans2
Sheet: Rota

 |  |  |  | 2024-01-15 00:00:00
 |  |  | Scot |  | 0900-1700 | 1200-2000 | 0800-1600 | 0900-1700 | 0730-1400 | 0 | 0900-1700
 |  |  | [NAME] | 0800-1600 | 0800-1600 | 0800-1600 | 0800-1600 | 0800-1600 | 0 | 0 | 0800-1600
 |  |  | [NAME] | 0800-1600 | 0 | 0 | 0 | 0 | 0 | 0 | 0800-1600
 |  |  | [NAME] | 0800-1600 | 0800-1600 | 0800-1600 | 1200-2000 | 0800-1600 | 0 | 0800-1600 | 0800-1600
 |  |  | Eve | 0800-1600 | 1200-2000 | 0900-1700 | 0900-1700 | 0900-1700 | 0 | 0 | 0900-1700
 |  |  | [NAME] | 1200-2000 | 0800-1600 | 0800-1600 | 0800-1600 | 0800-1600 | 0 | 0800-1600 | 1200-2000
 |  |  | [NAME] | 0900-1700 | 0900-1700 | 0900-1700 | 0900-1700 | 0900-1700 | 0 | 0 | 0900-1700
Spreadsheet: 827892d1683107928-distribute-automatically-and-equitly-on-excel-in-a-certain-number-of-cells-the-result-o-distribute-automatically-and-equitly-on-excel-in-a-certain-number-of-cells-the-result-0
Sheet: josephteh 1

Products | Cost | Shipping Cost | TOTAL | Remark
Product A | 19.99 |  |  | Any difference goes to the 1st product with the highest Cost
Product B | 19.99
Product C | 160.99
Product D | 160.99
Product E | 12.95
Product F | 12.95
Total of shipping cost | Quantity of product | Shipping cost for each product
14.6 | 6
Spreadsheet: rick_buy__32729__Daily Treas By BU Q3
Sheet: Q3 to Date

 | Net Cash Source / (Use)
 | Current Day and Month to Date
 | 3rd Quarter 2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001-08-20 00:00:00
 |  |  |  |  | Total |  |  |  | MTD |  |  |  |  | Most
 |  |  |  |  | Q3 to Date |  | Sept | August | July |  |  |  |  | Current Day
 | Enron Transportation Services
 | Portland General Electric
 | Total Distribution
 | Enron North America
 | Enron South America
 | Total Americas
 | Europe
 | Global Markets
 | Industrial Markets
 | Networks
 | Other
 | Total Traditional Wholesale
 | Global Assets
 | EGEP
 | Other Wholesale (EE&CC)
 | Total Wholesale
 | Enron Energy Services
 | Enron Broadband Services
 | Corp
 | Other
 | Total Enron*
 | ONLY includes cash movement monitored from Houston.
 | Does NOT include Canada, London or any other banking center.
 | Certain items such as payroll that is paid by Corp on behalf of a business unit has NOT been allocated to the business units
Spreadsheet: michelle_lokay__26569__imbalsumm0012
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1 | 6271 |  |  | 5000
2 | 12463 |  |  | 10000
3 | 10327 |  |  | 10000
4 | 9612 |  |  | 10000
5 | 5169 |  |  | 5000
6 |  |  |  | 5000
7 |  |  |  | 5000
8 |  |  | 5474 | 5000
9 |  |  | 6224 | 5000
10 |  |  | 5258 | 5000
11 | 15176 |  |  | 15000
12 | 27288 |  |  | 27053
13 | 16236 |  |  | 16666
14 |  |  |  | 5000
15 |  |  |  | 5000
16 |  |  |  | 5000
17 |  |  |  | 5000
18 |  |  | 15424 | 15000
19 |  |  | 28570 | 28166
20
21
22
23
24
25
26
27
28
29
30
31
 | 2000-11-30 00:00:00 |  |  |  | 28281
 | 2000-12-19 00:00:00
Spreadsheet: 863583d1711016377-merging-bill-of-materials-power-query-forum
Sheet: Blad1

[NAME] of material 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] of material 2
Level | Description | Type |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Level | Description | Type
1 | A | Assy |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | P | Assy
1.1 | B | SubAssy |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.1 | B | SubAssy
1.1.1 | C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.1.1 | Q
1.1.2 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.1.2 | R
1.1.3 | E | SubAssy |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.1.3 | S
1.1.3.1 | F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.1.4 | T
1.1.3.2 | G |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.1.5 | E | SubAssy
1.2 | H | SubAssy |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.1.5.1 | U
1.2.1 | I |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.1.5.2 | V
1.3 | J | SubAssy |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.2 | J | SubAssy
1.3.1 | K |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.2.1 | W
1.3.2 | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.2.2 | X
1.3.3 | M | SubAssy |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.2.3 | Y
1.3.3.1 | N |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.2.4 | M | SubAssy
1.3.3.2 | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.2.4.1 | Z
[NAME] of material merged
Level | Description | Type
1 | A | Assy
1.1 | B | SubAssy
1.1.1 | C
1.1.2 | D
1.1.3 | B | SubAssy
1.1.3.1 | Q
1.1.3.2 | R
1.1.3.3 | S
1.1.3.4 | T
1.1.4 | E | SubAssy
1.1.4.1 | F
1.1.4.2 | G
1.1.4.3 | E | SubAssy
1.1.4.3.1 | U
1.1.4.3.2 | V
1.2 | H | SubAssy
1.2.1 | I
1.3 | J | SubAssy
1.3.1 | K
1.3.2 | L
1.3.3 | J | SubAssy
1.3.3.1 | W
1.3.3.2 | X
1.3.3.3 | Y
1.3.4 | M | SubAssy
1.3.4.1 | N
1.3.4.2 | O
1.3.4.3 | M | SubAssy
1.3.4.3.1 | Z
Spreadsheet: 48067d1247239373-drop-list-with-large-database-estimating_test
Sheet: Interior

GLASS |  | [NAME] (Inches) |  | Per Pc. |  |  | Polish
Description | Quantity | [NAME] | Height | Sq.Ft. | Total Sq.Ft. | Unit$ | $ per inch |  | Price | Notches/holes $
10mm Cl Temp
10mm Cl Temp
 |  |  |  | TOTAL |  |  |  | $
Spreadsheet: 789903d1659434257-text-in-cell-value-as-a-range-reference-text-as-a-reference-for-range-hd
Sheet: Sheet1

 |  |  |  | >
 |  |  | Criteria | 4 |  |  | filter result
 |  |  |  | aa | cc
 |  |  |  | a | 1 |  | c
 |  |  |  | b | 5 |  | f
 |  |  |  | c | 6
 |  |  |  | f | 8
 |  |  |  | g | 4
 |  |  |  | Operand | Value
 | > |  | Criteria | > | 5 |  | filter result
 | < |  |  | aa | cc
 | = |  |  | a | 1 |  | f
 | <> |  |  | b | 5
 | <= |  |  | c | 6
 | >= |  |  | f | 8
 |  |  |  | g | 4
Spreadsheet: 128504d1321014287-countif-between-dates-help-800901-countif-between-dates-testforip2
Sheet: Report (2)

 |  |  | wk1 Tot | wk2 Tot | wk3 Tot | wk4 Tot
 |  | [NAME] | 3 | 1 | 3 | 0
 |  | Fred | 1 | 1 | 1 | 1
 |  | [NAME] | 1 | 1 | 1 | 1
 |  | [NAME] | 3 | 2 | 1 | 1
 |  | [NAME] | 1 | 0 | 1 | 0
 |  | Klaus | 0 | 1 | 0 | 0
 |  | [NAME] | 1 | 0 | 0 | 0
 |  | Sid | 1 | 0 | 0 | 0
 |  | [NAME] | 1 | 1 | 1 | 1
Spreadsheet: 169420d1342816249-formula-for-counting-conditional-on-unique-values-uploaded-excel-formula
Sheet: Report

Total Number of Events by Location and Type | USA | India | Ireland | Spain | Total
Inside
Outside
Exhibit
International
Skills
Video
Two Day
Three Day
Sales
Total
Spreadsheet: 838971d1691573950-find-several-values-separated-by-a-comma-and-return-a-value-with-no-duplicates-search-dataset-save-file-mve-1-
Sheet: Blad3

Art 1 | RS | #
27001:2022 4
27001:2022 4.1 | 6.48 | 147
27001:2022 4.2 | 6.01, 6.02, 6.09, 6.10, 6.11, 6.49, 6.50
27001:2022 4.3 | 6.51
27001:2022 4.4 | 6.45, 6.46, 6.47, 6.48, 6.49, 6.50, 6.51
27001:2022 5
27001:2022 5.1 | 6.33, 6.45 | 1, 52, 56, 57, 58, 99
27001:2022 5.2 | 6.46
27001:2022 5.3 | 6.41, 6.47 | 1, 54, 55
27001:2022 6
27001:2022 6.1
27001:2022 6.1.1 | 6.52 | 134, 145
27001:2022 6.1.2 | 6.38 | 4, 5, 135, 136
27001:2022 6.1.3 | 6.52 | 93, 137, 138
27001:2022 6.2 | 6.48 | 52, 145
27001:2022 6.3 | 6.38, 6.41 | 20
27001:2022 7
27001:2022 7.1 | 6.33 | 145
27001:2022 7.2 | 6.34 | 43, 55, 112
27001:2022 7.3 | 6.14, 6.15, 6.17, 6.18, 6.19, 6.20, 6.21, 6.22, 6.23, 6.24, 6.25, 6.41, 6.42 | 56. 57, 58
27001:2022 7.4 | 6.53 | 12
27001:2022 7.5
27001:2022 7.5.1 | 6.38 | 20, 57, 99
27001:2022 7.5.2 | 6.46, 6.54
27001:2022 7.5.3 | 6.55 | 57, 99
27001:2022 8
27001:2022 8.1 | 6.56 | 139
27001:2022 8.2 | 6.57 | 136
27001:2022 8.3 | 6.58 | 93
27001:2022 9
27001:2022 9.1 | 6.58, 6.59 | 2, 52, 94, 145
27001:2022 9.2
27001:2022 9.2.1 | 6.60 | 140
27001:2022 9.2.2 | 6.60 | 141
27001:2022 9.3
27001:2022 9.3.1 | 6.61 | 52
27001:2022 9.3.2 | 6.61 | 93, 136, 140, 145
27001:2022 9.3.3 | 6.61 | 134, 145
27001:2022 10
27001:2022 10.1 | 6.62 | 139
27001:2022 10.2 | 6.63 | 8, 29, 50, 62
Spreadsheet: 713462d1610726602-is-there-a-function-for-adding-text-from-latest-update-cells-to-historic-actions-cell-example-spreadsheet
Sheet: Sheet1

COMPANY NAME | PHONE NUMBER | EMAIL ADDRESS | LATEST ACTION | HISTORIC ACTIONS
abc clothing | 73737373 | [EMAIL] | phoned MD and sent email brochure | phoned MD and sent email brochure |email sent to stephanie receptionist chasing MD phone number | called and spoke to stephanie receptionist
crazy clothing ltd | 47453737 | [EMAIL] | email sent to [NAME] asking to arrange a call | email sent to [NAME] asking to arrange a call | phoned and left a message for steve
bad clothes r us | 47382829 | [EMAIL] | chased email with a link to website | chased email with a link to website | phoned MD and sent through email brochure | called and spoke to receptionist who gave me number for MD
Spreadsheet: 53729d1253642709-general-ledger-template-general-ledger-wilverley
Sheet: Charitables & Sponsorships

G/L Code | Date Check Request Initiated | Requested by | Check Amount | Previous Year Contribution | Payee | Used For | Signed Off by | Category | Method of Distribution | File Date | [NAME]
12000 | 2005-01-20 00:00:00 | [NAME] | 1000 | 0 | School of Fine Art | Scholarships | [NAME] | Arts | Check | 2005-01-30 00:00:00
11000 | 2005-02-15 00:00:00 | [NAME] | 2500 | 0 | [NAME] | Community | [NAME] | Community | Check | 2005-03-01 00:00:00
Spreadsheet: john_griffith__16204__1_31_02LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL H2 | 19 | 150 | 165 | 50.6 | 55.6 | 0.63 | 2002-01-31 10:08:00
 | CL J2 | 19.5 | 258 | 268 | 48.6 | 50.4 | 0.61 | 2002-01-31 10:08:00
 | CL K2 | 19.5 | 335 | 345 | 47.6 | 49.1 | 0.59 | 2002-01-31 10:08:00
 | CL M2 | 20 | 385 | 400 | 45.6 | 47.4 | 0.58 | 2002-01-31 10:08:00
 | CL N2 | 20 | 425 | 440 | 44.3 | 45.8 | 0.57 | 2002-01-31 10:08:00
 | CL Q2 | 20 | 455 | 470 | 43.1 | 44.5 | 0.55 | 2002-01-31 10:08:00
 | CL U2 | 20 | 475 | 495 | 41.7 | 43.5 | 0.54 | 2002-01-31 10:08:00
 | [NAME] | 20 | 485 | 505 | 39.5 | 41.2 | 0.51 | 2002-01-31 10:08:00
 | CL X2 | 20 | 490 | 510 | 37.7 | 39.2 | 0.48 | 2002-01-31 10:08:00
 | [NAME] | 20 | 495 | 515 | 36.3 | 37.8 | 0.47 | 2002-01-31 10:08:00
 | CL F3 | 20 | 500 | 520 | 35 | 36.4 | 0.45 | 2002-01-31 10:08:00
 | CL G3 | 20 | 505 | 530 | 33.9 | 35.6 | 0.44 | 2002-01-31 10:08:00
 | CL M3 | 20.5 | 520 | 550 | 29.9 | 31.6 | 0.4 | 2002-01-31 10:08:00
 | CL Z3 | 20.5 | 530 | 560 | 26.5 | 28.1 | 0.35 | 2002-01-31 10:08:00
 | CL M4 |  |  |  | 21.8 | 24.4 | 0.31 | 2002-01-04 13:39:00
 |  |  |  |  |  |  |  | ,