tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 79954d1280218136-search-and-delete-rows-if-it-meets-my-criteria-howtofilter
Sheet: Sheet1

net or com
martin.com
martin.com
fred.net
martin.com
martin.com
martin.com
pete.net
fred.net
fred.net
martin.com
fred.net
martin.com
martin.com
pete.net
pete.net
pete.net
fred.net
pete.net
fred.net
fred.net
martin.com
martin.com
martin.com
martin.com
martin.com
pete.net
above is filtered on contains .net
now simply select all the rows so it looks like image |  |  |  |  | >>>>>>>>>>>>>>>>>>
right click ,delete then un filter all the .net will have gone
Spreadsheet: 55032d1255102837-calculating-totals-for-monthly-incentives-iincentive-program
Sheet: Sheet1

Name
2009-11-01 00:00:00 | Incentive | 15 | <--------- | this would add the total amount (5.00 increments)per each order.
2009-12-01 00:00:00 | Incentive | 30
2010-01-01 00:00:00 | Incentive | 0
2010-02-01 00:00:00 | Incentive | 15
Total Incentive Paid |  | 60
Date | PO# | Total Cost
2009-11-11 00:00:00 | 86759309KA | 358 | 10 |  |  |  |  |  |  |  |  |  |  |  | 10
2009-11-29 00:00:00 | 43278907 | 222 | 5
2009-12-01 00:00:00 | 542798 | 999 | 30
2009-12-25 00:00:00 | [NAME] | 120 | 0
2010-01-20 00:00:00 | 570943jde | 99 | 0
2010-02-02 00:00:00 | fnjdsa3837 | 530 | 15
Spreadsheet: james_steffes__12808__Geoergetowntemplatefall2001b
Sheet: basic info

Georgetown University
The McDonough School of Business
Address | 207 Old North |  |  |  | 2001 Business School Ranking |  | 26
 | 37th and O Streets, N.W. |  |  |  | 2001 Financial Times Ranking |  | 29
 | Washington, DC 20057 |  |  |  | 2001 US News Ranking |  | 22
Contact Person | [NAME]
 | (202) 687-3871 |  |  |  | Target Acquisition |  | 8
 |  |  |  |  | Target Cost Per Hire |  | $16,444
Recruiting Team
Team Members Who Were Active
[NAME] | VP | 3-7673 |  |  | [NAME] | Associate | 5-3564
[NAME]* | VP | 5-8812 |  |  | [NAME] | Associate | 5-3242
[NAME] | VP | 3-7237 |  |  | [NAME] | Associate | 5-5101
[NAME] | Sr. Dir | [PHONE] |  |  | Ahmet [NAME] | Associate | 5-3665
[NAME] | Sr. Dir | 3-0349 |  |  | [NAME] | Associate | 3-5181
Heather Mitchell | Dir | 3-7671
[NAME]** | Manager | 3-9258
[NAME] | Manager | 3-9029
[NAME]** | Manager | 5-8319
[NAME] | Manager | 3-4896
[NAME] | Manager | 5-8854
[NAME] | Manager | 3-7928
[NAME] | Manager | 5-7965
[NAME] | Associate | 3-9942
People Who Signed Up At Recruiting Expo
[NAME] | Sr. Dir | 5-8882
Annette Glod | Manager | 5-5638
[NAME] | Manager | 3-6078
[NAME] | Dir | 3-4312
Diane De Benedicts | Manager | 56802
[NAME] | Manager | 53592
Spreadsheet: 217488-sum-totals-purchase
Sheet: L10-0007-000

L10-0007-000
Part # | Description | QTY | [NAME]
20831-01 | GSKT STACK 8 A369 | 2
30020-01 | ANODE MAG ALLOY 1-5/16X24+1-1/4 NPT | 2
30081-01 | [NAME] VINYL 1 | 1
30081-05 | [NAME] VINYL 2 | 2
30125-01 | CHOKE POSITIVE 2 | 1
30127-07 | [NAME] WLLMRK ST4UP | 3
30228-03 | [NAME] WLLMRK 3 X 5 | 3
30334-01 | GAUGE 200 PSI DRY 2-1/2X1/4 BM | 2
30338-01 | GAUGE 30 PSI DRY 2-1/2X1/4 BM | 5
30345-01 | GAUGE 600 PSI DRY 2-1/2X1/4 BM | 2
30402-01 | HEAD RPTR 1 | 1
30405-01 | PSSR PILOT HI 500# 4660-XF | 1
30565-02 | REG 1PR-3P25S 35-80 1/4ORI 1 | 1
30570-01 | REG WATTS R125-04A 0-25 1/2 | 1
30585-02 | [NAME] WLLMRK 1/4 X 10 | 3
30590-26 | RPTR DISC 1 V500 M550 | 1
30624-02 | SIGHT GLASS 2 | 1
30745-01 | THERMOMETER 3X1/2 NPT X 6L 0250 | 2
30747-02 | THERMOSTAT KMRY T12 HAA | 2
30749-01 | THERMOWELL KMRY 4M 1 X 12 HCC | 2
30749-03 | THERMOWELL KMRY 4M 1 X 6 HCB | 2
30777-02 | GAUGE COCK SET BRASS 1/2 300# | 2
30785-03 | VLV MTR KMRY 112 SMT DAB EMB3 | 1
30787-09 | VLV MTR [NAME] 2200 SMA PO ECM | 1
30787-11 | VLV MTR KMRY 2400 SMA PO ECU | 1
30790-12 | VLV PR 1 X 1 500 MERCER D | 1
30793-01 | VLV PR 2 X 2 125 MERCER F | 1
30795-01 | VLV QUICK EXHAUST 544 SILVER PLTD | 2
30829-02 | VLV BALL BALON 2R-S42 SE 1000 | 2
30829-04 | VLV BALL BALON 2F-S32-SE 750 | 2
30887-01 | VLV MTR KMRY 212 SMA DB P0 [NAME] | 2
30893-01 | VLV BCK PSSR KMRY AAATF6 212SGT | 1
31006-01 | GLASS SIGHT REDLINE 5/8 X 14-3/4 300# | 1
Spreadsheet: 453861d1459491811-unique-list-of-data-sample-v1
Sheet: Sheet1

 |  |  |  |  |  |  | Condition 1 | AA
 |  |  |  |  |  |  | Condition 2 | 1
 |  |  | Client Name | Name | Amount | Type |  | Name | Amount
 |  |  | ABC | AA | 10 | 1
 |  |  | ABC | AA | 20 | 1
 |  |  | PQR | AA | 20 | 1
 |  |  | LMO | BBB | 10 | 2
 |  |  | FACE | BBB | 40 | 1
 |  |  | KEEP | DD | 40 | 2
 |  |  | SMOOTH | DD | 50 | 1
 |  |  | LIKE | EEE | 60 | 1
 |  |  | DEM | FFF | 100 | 1
Spreadsheet: 34294d1231453425-vlookup-problem-108b
Sheet: 108-2

905-1716-001 | 2009-01-05 06:07:00 | 12 |  |  |  |  |  | IEC108-2
905-1716-001 | 2009-01-05 06:14:00 | 12
905-1716-001 | 2009-01-05 06:21:00 | 12
905-1716-001 | 2009-01-05 06:28:00 | 12
905-1716-001 | 2009-01-05 06:35:00 | 12
905-1716-001 | 2009-01-05 06:42:00 | 12
905-1717-001 | 2009-01-05 06:49:00 | 12
905-2261-001 | 2009-01-05 15:00:51 | 2
Spreadsheet: ce5bf371-d502-496d-88e1-5879697e8386
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
[NAME] | Test | [NAME] | Chestnut, [NAME], IgE | Chestnut, [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. -8 p.m., Saturday; 8 a.m. -3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
[NAME] | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
[NAME] | Result | [NAME] | Chestnut, [NAME], IgE | Chestnut, [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6259-6
Spreadsheet: 746969d1631142895-count-the-number-of-books-i-need-based-on-all-the-classes-that-need-this-book-sum-multiple-items-per-row-wimgyssels-
Sheet: Sheet1

3Aec 3Antw 3Amt 3Alat 3Antwsp 3Kabv 3Kdans
3Aec 3Tmawe 3Tet
4a 4t 4k
5/6K+5/6TEI+5losp+5stw+ 5/6A behalve [NAME] lawe + 5/6 sport wet
6losp 6stw
6stw 6losp 6Tet
3Tsport | 17
3Tmawe | 10
3Tet | 2
TOTAAL=
3Aec | 15
3Antw | 13
3Amt | 5
3Alat | 2
3Antwsp | 0
TOTAAL=
Spreadsheet: 714602d1611306004-help-computing-a-running-total-between-2-sheets-gk2-22-jan-09-00
Sheet: 01.25

 |  |  |  |  |  |  |  |  | Starting Liquid |  | 200000
 |  |  |  |  |  |  |  |  | Set date here | 2021-01-25 00:00:00
 |  |  |  |  |  |  |  |  |  | A | B | A | B | A | B | A | B | C | D | C | D | C | D
 |  |  |  |  |  |  |  | Job 1 |  | 4
 |  |  |  |  |  |  |  | Job 2 |  | 8 | 4
 |  |  |  |  |  |  |  | Job 3 |  |  | 8 | 12
 |  |  |  |  |  |  |  | Job 4 |  |  |  | 2 | 3 | 14
 |  |  |  |  |  |  |  | Job 5 |  |  |  |  |  |  | 13 | 13
 |  |  |  |  |  |  |  | Job 6 |  |  |  |  |  |  |  |  | 14 | 14 | 4
 |  |  |  |  |  |  |  | Job 7 |  |  |  |  |  |  |  |  |  |  | 9 | 13 | 13 | 13 | 13
 |  |  |  |  |  |  |  |  |  | 18210 | 14056 | 24566 | 5223 | 24373 | 12768 | 12768 | 17267 | 17267 | 18780 | 20000 | 20000 | 20000 | 20000
 |  |  |  |  |  |  |  |  |  | A | B | A | B | A | B | A | B | C | D | C | D | C | D
 |  |  |  |  |  |  |  | Job 1 |  | 14 | 14 | 14 | 14 | 14 | 4
 |  |  |  |  |  |  |  | Job 2 |  |  |  |  |  |  | 10 | 14 | 14 | 14 | 14 | 14 | 11
 |  |  |  |  |  |  |  | Job 3 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 11
 |  |  |  |  |  |  |  | Job 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | Job 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  | 25969 | 25969 | 25969 | 25969 | 25969 | 22804 | 21539 | 21539 | 21539 | 21539 | 21539 | 20805 | 25187 | 25364
Rows 9-19 represent production line 1
Rows 21-29 represent production line 2
Row 19 is the total amount of liquid used for that day - example, 32,266 used on production line 1 on Monday
Row 29 is the same, but for production line 2
Row 7 represents the running total of where we will be at the end of each day - based off of the usages in rows 19+29
Cell C5 will be manually entered on Monday morning
My goal is to have a running count that incorporates incoming loads of liquid, based off of the schedule on the next sheet
Cell L1 (the old [NAME]) should be MONDAY'S starting point. Cell K3 should equal (Cell L1) + ([NAME] on 1/25) - (usage in K15+K25)
Then, cell M3 should equal (cell K3)+(incoming loads on 1/26) - (usage in M15+M25)
Spreadsheet: 161724d1339607483-use-today-date-calculation-in-pivot-table-example
Sheet: Pivot

Row Labels | [NAME].
SO12-00001 | 2012-01-10 00:00:00
SO12-00002 | 2011-12-25 00:00:00
SO12-00003 | 2012-01-14 00:00:00
SO12-00004 | 2012-01-15 00:00:00
SO12-00005 | 2012-01-01 00:00:00
SO12-00006 | 2011-12-25 00:00:00
SO12-00007 | 2011-12-24 00:00:00
SO12-00008 | 2011-12-24 00:00:00
Grand Total | #[NAME]!
Spreadsheet: 0081d828-c492-47db-b46b-f407d6393c89
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  |  | GEAR RATIO MPH FORMULA
 |  | 72 |  | 50
 |  | Voltage |  | RPM per Volt
 |  | 14 |  | 60
 |  | Drive sprocket |  | Driven sprocket
 |  | 3600 | 0.2333333333333333 | 840
 |  | Motor RPM | sprocket ratio | Rear Wheel RPM
 |  | 74
 |  | Rear Wheel Cir. (inch)
 |  |  | 58.86363636363637
 |  |  | MPH
Spreadsheet: 07b2fe31-0e87-4d6e-ad11-a90abf4f7abd
Sheet: Computing

COMPUTING CAR
Course color corresponds with term of offering.  BLUE for Spring semester, PURPLE for J-term, GREEN for both Spring and J-term.
Biology | BIOL 350
Business | BUSN 336
Chemistry | CHEM 325
 | CHEM 340
Computer Science | CSCI 106
 | CSCI 107
 | CSCI 111
 | CSCI 112
 | CSCI 181
 | CSCI 481 |  | Fall 2013 Building Mobile [NAME]
Drama | DRAM 331
Economics | ECON 312
Education | EDUC 346
Honors Program | HONR 249
 | HONR 254
 | HONR 258
 | HONR 292
Mathematics | MATH 107
 | MATH 113
 | MATH 141
 | MATH 142
 | MATH 203
Music | MUSC 322
 | MUSC 371
Physics | PHYS 350
Political Science | PSCI 301
Psychology | PSYC 201
Sociology | SOCI 300
Spreadsheet: 273875d1382952974-auto-copy-the-row-matter-by-understanding-presiding-cell-location-book1
Sheet: Sheet1

1 | A
1 | B
1 | C
1 | D
1 | E
1 | F
1 | G
1 | H
1 | I
1 | J
2 | K
3 | L
4 | M
5 | N
6 | O
7 | P
8 | Q
9 | R
10 | S
11 | T
11 | U
11 | V
Spreadsheet: 844840d1696500972-match-input-with-pool-of-texts-or-word-bank-and-return-correspoding-value-excelforum
Sheet: Sheet1

 |  |  | List | Word Bank
 |  |  | [NAME] | Qadeer | Ahmed | [NAME] | [NAME] | Qadeer [NAME] | [NAME]
Input | [NAME] |  | Jawad | Jawad | Asad | Bengan | Alo | Tamatar | Bhindi
Required Output: | [NAME] |  | [NAME] | Dil | Gurda | Jigar | Damagh | Pagal | Falaj
 |  |  | Victor | Langra | [NAME] | Half | Full | Medium | Strong
Spreadsheet: 58823d1259083472-excel-2007-how-to-add-items-to-a-dropdown-list-dynamically-by-typing-in-the-dropdown-list-cell-tanf_-_requirement_gathering_template_-final-
Sheet: Add Program-Person

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Case Management (Undercare)
Activity Name | Add Program/Person
Activity Description / Purpose | Process of adding a new program or person to an existing case.
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Determine whether further verification is required
Make arrangements to get verification
Record information in case notes
Update information in WMS
Redetermine eligibility
Accounting | Case Closure
Add Program/Person | Case Management (Undercare)
AFIS | Caseload Management
Agency Conference | Client Services/Benefits Delivery
Application Registration | Eligibility Determination
Authorization | Fair-Hearings & Appeals
[NAME] | Intake
Budget | Referrals
Case Assignment | Screening
Case Closure | Verification
Case Review
[NAME]
CBIC
Change
Clearance
Data Entry
DV-D-A Screen
Emergency Benefits
Expedited
Hearings
Interview
Investigation
Managed Care
Mass Changes
Monitor Activities
Notice
[NAME]
Plan Review
Pre-Screening
Reactivation
Reception
Records Management
Recoupment-Supplemental
Re-Determination-Renewal-Recert
Referral
Sanctions
Service Plan
Verify
Vouchers
Withdraw Application
Other
Spreadsheet: 858d94c6-5de4-4aa8-b1b2-3db240a8f365
Sheet: PAG 17

 | Income tax and social contribution |  | 1Q10 | 1Q11
 | R$ million
 | Profit before tax |  | 2212.486 | 2707.906
 | Adjustment on taxable basis
 |  | Non-taxable net financial and other income | -87.323 | -119.423
 |  | Goverment grants (VAT) | -83.113 | -99.1
 |  | Share of results of associates | -0.013 | -0.086
 |  | Hedging results | 8.191 | -2.717
 |  | Expenses not deductible for tax purposes | 26.997 | 77.082
 |  |  | 2077.225 | 2563.662
 |  | Aggregated weighted nominal tax rate | 0.3316 | 0.329
 |  | Taxes – nominal rate | -688.808 | -843.445
 | Adjustment on tax expense
 |  | Incentives related to income taxes | 43.053 | 77.627
 |  | Tax benefit - interest on shareholders' equity | 109.659 | 126.579
 |  | Tax benefit - amortization on tax books | 32.167 | 30.188
 |  | Withholding tax and other income | -25.913 | -27.72
 |  | Non-deductible losses - foreign operations | -16.861 | -8.784
 |  | Income tax provision reversal | -7.629 | -0.006
 |  | Other tax adjustments | -7.26 | 43.695
 |  | Income tax and social contribution expense | -561.592 | -601.866
 |  | Effective tax rate | 0.2538 | 0.2223
Spreadsheet: 119834d1314784432-condense-rows-based-on-alphabetic-value-display-max-and-min-values-in-other-columns-fahall_test
Sheet: Sheet2

 | Sunday |  |  | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday |  |  | Saturday
 | 2011-08-28 00:00:00 |  |  | 2011-08-29 00:00:00 |  |  | 2011-08-30 00:00:00 |  |  | 2011-08-31 00:00:00 |  |  | 2011-09-01 00:00:00 |  |  | 2011-09-02 00:00:00 |  |  | 2011-09-03 00:00:00
 | Start | Finish |  | Start | Finish |  | Start | Finish |  | Start | Finish |  | Start | Finish |  | Start | Finish |  | Start | Finish
[NAME] |  |  |  |  |  |  | 15:00:00 | 23:00:00 |  | 15:00:00 | 23:00:00 |  | 15:00:00 | 23:00:00 |  | 15:00:00 | 23:00:00 |  | 12:00:00 | 20:00:00
[NAME] | 12:00:00 | 20:00:00 |  |  |  |  | 16:00:00 | 23:00:00 |  | 16:00:00 | 23:00:00
[NAME] | 12:00:00 | 21:00:00 |  |  |  |  | 07:45:00 | 15:30:00 |  | 14:00:00 | 22:30:00 |  | 07:45:00 | 15:00:00 |  | 15:00:00 | 23:30:00
[NAME] |  |  |  | 14:30:00 | 22:00:00 |  |  |  |  | 15:00:00 | 18:30:00 |  | 15:00:00 | 23:00:00 |  | 15:00:00 | 23:00:00 |  | 12:30:00 | 20:30:00
Elvis |  |  |  |  |  |  | 18:00:00 | 23:00:00 |  | 17:00:00 | 23:00:00 |  | 18:00:00 | 23:00:00 |  | 15:00:00 | 23:00:00 |  | 12:00:00 | 21:00:00
[NAME] |  |  |  | 15:00:00 | 23:30:00 |  | 15:00:00 | 23:30:00 |  | 15:00:00 | 23:30:00 |  | 15:00:00 | 23:30:00 |  | 15:00:00 | 23:30:00
Spreadsheet: 714366d1611191980-extracting-data-from-multiple-worksheets-power-query-append-all-tables-in-current-workbook-speedychaz94-
Sheet: Featherweight_edit_

Rank | Fighter | Record | M | Last fight | Next fight
C | [NAME] | 22–1 | Steady | [NAME] | vs. [NAME] (UFC 260)
1 | [NAME] | 22–6 | Steady | [NAME] | TBD
2 | [NAME] | 15–1 (1 NC) | Steady | [NAME] | vs. [NAME] (UFC 260)
3 | [NAME] | 18–1 | Steady | [NAME] | TBD
4 | Yair Rodríguez | 13–2 (1 NC) | Steady | [NAME] Jeremy [NAME] | TBD
5 | [NAME] | 16–6 | Steady | Lost to [NAME] | TBD
6 | [NAME] | 22–5 | Steady | Lost to [NAME] | TBD
7 | [NAME] | 15–2 | Steady | [NAME] | TBD
8 | [NAME] | 28–18 (1 NC) | Steady | Lost to [NAME] | TBD
9 | [NAME] | 16–1 | Steady | [NAME] | TBD
10 | [NAME] | 11–1 | Steady | [NAME] | TBD
11 | [NAME] | 14–3 | Steady | Lost to [NAME] | vs. [NAME] (UFC Fight Night 187)
12 | Shane Burgos | 13–2 | Steady | Lost to [NAME] | TBD
13 | [NAME] | 8–1 | Steady | [NAME] | vs. [NAME] (UFC Fight Night 187)
14 | [NAME] | 14–0 | Steady | [NAME] | TBD
15 | [NAME] | 21–9 | Steady | [NAME] | TBD
Spreadsheet: michelle_lokay__26617__imbalsumm0102
Sheet: PGETX

 |  |  |  |  | 12283
 | [NAME] |  | Pecos Del |  | Gunpoint #2
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 40390 | 23187 |  | 16764
2 | 24435 | 3436 |  | 10000
3 |  | -10190 |  | 10000
4 |  | -10190 |  | 10000
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
 |  |  |  | 2001-01-31 00:00:00 |  |  | 125225
 |  |  |  | 2001-02-04 00:00:00
Spreadsheet: 55880d1256050375-cumulative-totals-exceltipexample2
Sheet: Comp1

Requirement
Ref | Other ID | ISIN | Name | Code | Declaration | Nominal | Total Nominal | Pay Amount
123456789 | DOO102034556 | GB1 | The Big Red Fun Bus | APPLE1 | 650000 | 200000 | 800000 | 200000
148568478 | DOO102034556 | GB1 | The Big Red Fun Bus | APPLE1 | 650000 | 300000 | 800000 | 300000
138499345 | DOO102034556 | GB1 | The Big Red Fun Bus | APPLE1 | 650000 | 300000 | 800000 | 150000
235688974 | DOO102034556 | GB2 | The Green Helicopter | SAUCE2 | 200000 | 300000 | 452000 | 200000
265478899 | DOO102034556 | GB2 | The Green Helicopter | SAUCE2 | 200000 | 152000 | 452000 | 0
Solution
Ref | Other ID | ISIN | Name | Code | Declaration | Nominal | Total Nominal | Pay Amount
123456789 | DOO102034556 | GB1 | The Big Red Fun Bus | APPLE1 | 650000 | 200000
148568478 | DOO102034556 | GB1 | The Big Red Fun Bus | APPLE1 | 650000 | 300000
138499345 | DOO102034556 | GB1 | The Big Red Fun Bus | APPLE1 | 650000 | 300000
235688974 | DOO102034556 | GB2 | The Green Helicopter | SAUCE2 | 200000 | 300000
265478899 | DOO102034556 | GB2 | The Green Helicopter | SAUCE2 | 200000 | 152000
Spreadsheet: 123475d1317673017-if-formula-test
Sheet: Work Sheet

Grade | Name | Mid-Term |  | Priority 1 -High 2 - Norm 3 - Below | Section Manager | End of Year |  |  | Current Salary | Current Compa Ratio | New / Recommended Grade | Recommended Increase | Percentage of Increase | New Salary | New Grade | New Compa Ratio
 |  | Mid-Term PPA Rating (O,D,S,M,B) | Possible Change |  |  | Proposed PPA Rating (O,D,S,M,B) | Possible Change | Combined
28 | [NAME] | S |  |  | Cathy | S |  | S | 39345 | 1.054825737265416 | 29 | 1967.25 | 0.05 | 41312.25 | 29 | 1.107567024128686 | Changed
Spreadsheet: 40958d1239364990-copy-cell-based-on-data-in-another-cell-scorekeepingwhatiwant
Sheet: LVBandit

LVBandit | Points | EK's | Deaths | TK | Assists | Shot/K | Purple H | Medic | Primary Weapon | 2nd Weapon | Extra Weapons | Drive | Fly | Boat | Parachuting | Extra Awards | Totals
2009-01-27 00:00:00
Frostbite | 525 | 59 |  |  |  | 2 |  | 1 | PSG1SD | RPG-7 | MP5 |  |  |  | 1 |  | Points | With TK's
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4305 | 4305
Headhunter | 295 | 40 |  |  |  | 3 |  |  | PSG1SD | RPG-7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EK's
Insurrection | 300 | 33 |  |  |  | 2 |  |  | PSG1SD | AT4 | MP5 |  |  |  |  |  | 755
Exodus | 75 | 73 | 1 |  |  | 2 |  |  | PSG1SD | M224 Mortar |  |  |  |  |  |  | TK's
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | 280 | 53 |  |  |  | 7 | 1 | 1 | M4/M203 | Javelin | [NAME], [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Deaths
Whirlwind | 310 | 48 |  |  |  | 1 |  | 1 | PSG1SD | RPG-7 |  |  |  |  |  |  | 3
2009-01-27 00:00:00
Bunker Takedown | 430 | 72 |  |  |  | 21 | 1 |  | RPK-74 | Javelin | 50 Cal |  |  |  |  |  | Assists
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Airstrike | 60 | 59 | 1 |  |  | 34 |  |  | PSG1SD | Stinger
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shots/Kill
Fields of Fire | 860 | 176 | 1 |  |  | 5 |  |  | RPK-74 | Javelin |  |  |  |  |  |  | 6.307692307692307
2009-02-08 00:00:00
Full Stop | 290 | 36 |  |  |  | 2 |  | 1 | PSG1SD | RPG-7 |  |  |  |  |  |  | Purple H
2009-02-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
Metal Hammer |  |  |  |  |  |  |  |  | Therm PSG1SD | RPG-7
punted bonus | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Medic
Insurrection | 210 | 29 |  |  |  | 1 |  |  | PSG1SD | RPG-7 |  |  |  |  |  |  | 5
Snow [NAME] |  |  |  |  |  |  |  |  | PSG1SD | RPG-7 |  |  |  |  |  |  | Drive
punted |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2009-03-10 00:00:00
Exodus | 290 | 40 |  |  |  | 1 | 1 | 1 | PSG1SD | M224 Mortar |  |  |  |  |  |  | Fly
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | 280 | 37 |  |  |  | 1 |  |  | PSG1SD | RPG-7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Boat
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Parachuting
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 703843d1605192004-cell-to-generate-the-sum-of-the-quantity-of-items-from-multiple-cells-that-have-formulas-contractor-materials-purchases_
Sheet: Balance

Operators | Balance |  | MONTH | Total
[NAME] |  |  | 2020-11-01 00:00:00
[NAME]
[NAME]
Spreadsheet: 120248d1315126113-circular-reference-causing-formula-issue-book1-14-
Sheet: Sheet1

Measured Depth | Mean Deviation (%) | Mean Deviation (%) | Mean Deviation Set Point (mm)
77
87 |  |  | Total No. of Slots Filled | 24
99
76
89
99
89
99
5
56
47
68
72
65
34
72
87
99
102
89
47
85
68
55
0
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: chris_germany__2064__marketing info
Sheet: Sheet1

 | Juniper Marketing Information
 |  |  |  | Gas | Condensate/Oil
 | WI | Property | Operated by | Marketed by: | Marketed by: | Sales Pt.
 | 0.5 | West Cameron 310/313 | Juniper | Petrocom - MTM - auto payment | Plains Mktg - MTM - auto payment | Forest Oil - WC 313 Pltfm
 |  | [HIOS to ANR] | Goes thru Forest Oil platform | [NAME] [PHONE] | [NAME] [PHONE]
 |  |  | elda [??] [PHONE] | [PHONE] fax | [cherry or sherry in acctg]
 |  |  | [NAME] [PHONE] | [EMAIL]  OR
 |  |  |  | [EMAIL]
 |  |  |  | Each month we decide % IF vs GDA
 | 0.31667 | Eugene Island 57 | Samedan | Petrocom - see above | [NAME] | Samedan - EI 57 'A' Pltfm
 |  | [[NAME] st 65] | [NAME] |  | Termed up thru May 02
 |  |  |  |  | auto payment
 |  |  |  |  | [NAME] [PHONE]
 |  |  |  |  | [EMAIL]
 | 0.7 | Eugene Island 28 | Juniper | Petrocom - see above | [NAME] - see above | Juniper - EI 28 'A' Pltfm
 |  | [Gath line of Enbridge/Quivera thru plant to Tenn 800]
 |  | [$0.1523/MMBtu deducted from Petro Com $, thru 4/30/05]
 |  | Enbridge Gath contract in process of being executed
 |  | Gas gets processed at Marathon's Burns Plant. Contract in process of being executed.  Gas MUST be processed per Tenn. [Start 5/01/02 thru 4/30/05]
 |  | Petro Com GISB in process of being executed
 |  | NEED TO DO -  get fractionation contract with Enterprise or "other"
 |  | NEED TO DO -  Work on selling liquids
 |  | [NAME] counsel - Andrews & Kirth x53990
 | 0.5 | High Island 232 /244 | Samedan | Petrocom - see above | N/A | Samedan - HI 244 Pltfm
 |  | [HIOS to ANR] | [NAME]
 | 0.11875 | S. Marsh Island 253 | Houston Expl | Houston Expl. [JOA] | Houston Expl.  [JOA] | Houston Expl. -SMI 253 'A' Pltfm
 | 0.5 | High Island 72 | Hall-Houston | [NAME]  [JOA] | [NAME]  [JOA] | Bellweather - HI 71 'A' Pltfm
 | 0.3 | West Cameron 431 | Hall-Houston | [NAME]  [JOA] | [NAME]  [JOA] | Hall - WC 431 'A' Pltfm
 | 0.17946 | Bay Marchand 4&5 | [NAME] d'Arc | Adams Resources | [NAME] d"Arc  [JOA] | BDO - Bay Marchand 4&5
 |  | [NAME]
 |  | Celeste - outsource acctg | [EMAIL]
 |  | [NAME] counsel - x53990