tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: stephanie_panus__39305__Ontario Energy Savings Corp ISDA CW
Sheet: ANEWSWP2

ISDA AGREEMENT
 |  | ATTORNEY: | [NAME] Pinto Leite
DATE: |  | DEAL MAKER: | Paul DeVries
COUNTERPARTY: | Ontario Energy Savings Corp | CONTACT:
ADDRESS: |  | TITLE:
 |  | PHONE:
 |  | FAX:
 |  | Moody's | NR
Incorporation State |  | S&P | NR
STRUCTURE | COUNTERPARTY | ECC
GUARANTOR (RATING) |  | Enron Corp. (BBB-)
LIMIT $ MILLIONS |  | 10000000
Incorporation State
ELEGIBLE SWAP PARTICIPANT
Counterparty | X
Guarantor |  | X
COLLATERAL  THRESHOLD MATRIX in $ ACTUALS
 | 0 | NA | USD
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | X | X
Cash
Treasuries/Maturity limit
MINIMUM TRANSFER $ | 1 | NA | USD
COLLATERAL ROUNDING
Delivery Amount | 250000 | NA | USD
Return Amount | 250000 | NA | USD
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty
-Guarantor |  | X
Debt Ratings Change |  | X
-Below = S&P/Moody's |  | BB+
 |  | Sr. Unsecured
Financial Covenants
-Funded Debt to Worth
-Minimum Net Worth
-EBIT/Interest Expense
-Funded Debt / EBITDA
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME]) | TBD
-Guarantor ($[NAME]) |  | $150 USD
Change in ownership
SPECIFIED ENTITY
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on: |  | Enron Corp.
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: | NO:
OTHER COMMENTS:
ALL DEALS NEED TO BE DONE ON A FULLY SECURED BASIS.
GLOBAL CREDIT:  Please complete the attached form below if the following conditions exist:
A)  No previous guidance limit exists or .....
B)  The proposed contractual limits exceed the existing guidance limits.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x30699
Spreadsheet: 233854e3-b100-4e4d-83f8-4c4645d04a1b
Sheet: Sheet1

PRESIDENTIAL PRIMARY | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
1992-02-18 00:00:00
 | Names on Checklist
Summary By Counties | Republican | Democratic | Libertarian | Undeclared | Totals
Belknap | 13301 | 7640 | 78 | 5617 | 26636
Carroll | 13060 | 4731 | 94 | 6479 | 24364
Cheshire | 13933 | 12945 | 109 | 7842 | 34829
Coos | 6786 | 7261 | 28 | 3981 | 18056
[NAME] | 17199 | 11114 | 87 | 11226 | 39626
Hillsborough | 68608 | 66776 | 965 | 30217 | 166566
Merrimack | 28094 | 19293 | 277 | 15151 | 62815
Rockingham | 53887 | 43151 | 808 | 31506 | 129352
[NAME] | 17013 | 20694 | 275 | 11364 | 49346
[NAME] | 7765 | 7026 | 18 | 4583 | 19392
Totals | 239646 | 200631 | 2739 | 127966 | 570982
 | [NAME]
 | Republican |  |  | Democratic |  |  | Libertarian
 | Regular | Absentee | Total | Regular | Absentee | Total | Regular | Absentee | Total
Belknap | 9179 | 615 | 9794 | 6061 | 331 | 6392 | 102 | 3 | 105
Carroll | 8208 | 855 | 9063 | 3842 | 330 | 4172 | 144 | 3 | 147
Cheshire | 9980 | 505 | 10485 | 10333 | 398 | 10731 | 116 | 2 | 118
Coos | 4348 | 270 | 4618 | 5207 | 218 | 5425 | 28 | 1 | 29
[NAME] | 11455 | 759 | 12214 | 9167 | 573 | 9740 | 93 | 3 | 96
Hillsborough | 48682 | 2368 | 51050 | 52627 | 2230 | 54857 | 1118 | 25 | 1143
Merrimack | 20873 | 1232 | 22105 | 18336 | 676 | 19012 | 394 | 4 | 398
Rockingham | 38012 | 2110 | 40122 | 35297 | 1314 | 36611 | 1142 | 9 | 1151
[NAME] | 11873 | 837 | 12710 | 16581 | 908 | 17489 | 313 | 1 | 314
[NAME] | 5458 | 351 | 5809 | 5654 | 250 | 5904 | 43 | 0 | 43
Totals | 168068 | 9902 | 177970 | 163105 | 7228 | 170333 | 3493 | 51 | 3544
*These numbers are as of April 14, 1992
Spreadsheet: 218176d1362386531-countif-a-range-of-cells-is-max-in-their-row-array-formula-maxcount
Sheet: Sheet1

 | week | Monday | Tuesday | Wednesday | Thursday | Friday
 | 19 | 72 | 61 | 57 | 57 | 59
 | 20 | 84.93885841966281 | 66.39325614462727 | 70.84420069063579 | 68.98964046313223 | 74.0340442819419
 | 21 | 71 | 53 | 60 | 49 | 37
 | 22 | 41 | 40 | 38 | 52 | 38
 | # is [NAME] (in its row)
Spreadsheet: diana_scholtes__8540__STNW PMA 083101
Sheet: STNW

Prior month adjustments for STNW to be entered on 8/31/01 P&L:
Initial | Type | Del. Period | Desk | Counterparty | Reg | Vol | $ |  | Explanation
EL | T | 2000-11-01 00:00:00 | EPMI-ST-NW | BPA | R9 | 1 | 10993.37 | VT | trasmission deal 589819.1 STNW selling to BPA; demand charge added to true up BPA transmission purchases in Nov. 2000; deal entered on 4/23/01 for flow date of 11/30/00
EL | T | 2000-12-01 00:00:00 | EPMI-ST-NW | BPA | R9 | 1 | 7667.75 | VT | trasmission deal 589842.1 STNW selling to BPA; demand charge added to true up BPA transmission purchases in Dec. 2000; deal entered on 4/23/01 for flow date of 12/31/00
EL | DP | 2001-07-01 00:00:00 | EPMI-ST-NW | BPA | R9 | 0 | -198387 | ok | 555367.1 capacity demand charge liquidated at -$33,064.52 daily, while it should have been -$41,000 daily.  (-41,000+33,064.52)* 25 peak days in July = -$198,387
GW | DP | 2001-05-01 00:00:00 | EPMI-ST-NW | MODESTOIRR | R8 | 0 | -31134.28 | VT | annuity deal #651899.2 STNW buying from Modesto; entered on 7/17/01 for flow date of 5/31/01
GW | DP | 2001-04-01 00:00:00 | EPMI-ST-NW | MODESTOIRR | R8 | 0 | -155797.9 | VT | annuity deal #651899.1 STNW buying from Modesto; entered on 6/18/01 and changed on 7/17/01 for flow date of 4/30/01
GW | DP | 2001-06-01 00:00:00 | EPMI-ST-NW | MODESTOIRR | R8 | 0 |  | VT | annuity deal #693176.1 STNW buying from Modesto entered on 7/19/01 for flow date of 6/30/01
 |  |  |  |  | Desk Total
Spreadsheet: 679422d1590412281-how-to-create-dropdown-list-combined-from-2-ranges-dropdown
Sheet: Sheet1

RANGE1 (A3:A12) | RANGE2(B3:B12) |  |  |  | RANGE3
 |  |  | MEAL1 |  | MEAL1
MEAL1 | MEAL5 |  |  |  | MEAL2
MEAL2 | MEAL6 |  |  |  | MEAL3
MEAL3 | MEAL7 |  |  |  | MEAL4
MEAL4 | MEAL8 |  |  |  | MEAL5
 |  |  |  |  | MEAL6
 |  |  |  |  | MEAL7
 |  |  |  |  | MEAL8
Spreadsheet: 718076d1612974946-using-a-cell-to-choose-a-column-in-index-match-type-lookup-column-choice
Sheet: Data

 | 13.1 | Each instruction, certificate, submission, proposal, record, acceptance, notification, reply and other communication which this subcontract requires is communicated in a form which can be read, copied and recorded. Writing is in the language of this subcontract |  | Early Warning | Risk Red Mtg | Risk Reg | 20.8(2) | Compens Event | Design | Instruction | Certificate | Submission | Proposal | record | acceptance | notification | reply | other communications
 |  | Subcontractor replies |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13.3 |  |  |  | 13.3
 |  | contractor replies |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13.4
 |  | extention of perod for reply |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13.5
 |  | Contractor issues certificates |  |  |  |  |  |  |  |  | 13.6
 |  | Must be separate from other communications |  |  |  |  |  |  |  |  |  |  |  |  |  | 13.7
 |  | Must be clearly noted as such |  |  |  |  |  |  |  |  |  |  |  |  |  | 13.8
 |  | Witholding is a CE |  |  |  |  |  | 13.9 |  |  |  |  |  |  | 13.9
 |  | Does not alter Subcontract Liability |  |  |  |  |  |  |  |  |  |  |  |  | 14.1
 |  | Delegation of actions |  |  |  |  |  |  |  |  |  |  |  |  |  | 14.2
 |  | Contractor ccan change [NAME] or Key Date |  |  |  |  |  |  |  | 14.3
 |  | Sub may submit to extend works area/reasons for non-acceptance |  |  |  |  |  |  |  |  |  |  | 15.1 |  | 15.1
 |  | Each party may give to the other and reasons for giving |  | 16.1 |  |  |  |  |  |  |  |  |  |  |  | 16.1
 |  | Instruction to attend EWM |  |  | 16.2 |  |  |  |  | 16.2
 |  | Actions at EWM |  |  |  | 16.3 |  |  |  |  |  |  | 16.3
 |  | Record of Risk Red Mtg on Risk Register |  |  | 16.4 | 16.4 |  |  |  | 16.4
 |  | Ambiguities - sub and MC |  |  |  |  |  |  |  | 17.1 |  |  |  |  |  | 17.1
 |  | Illegalities |  |  |  |  |  |  |  |  |  |  |  |  | 18.1
 |  | Events not reasonably foreseable |  |  |  |  |  |  |  | 19.1
 |  | Request to provide proofs re plant and materials |  |  |  |  |  |  |  |  |  |  |  |  |  | 20.2(2)
 |  | Consent required to substitute |  |  |  |  |  |  |  |  |  |  |  |  | 20.5
 |  | MC reasonble requests re progress and sequence |  |  |  |  |  |  | 20.6 |  |  |  |  |  |  | 20.6
 |  | List in this column could be 500-750 ;ines
Spreadsheet: 604017d1546258703-need-help-with-separating-data-on-a-pivot-report-book1
Sheet: Data

Category | Type | Month | Unit | Cost | Quantity | Total Cost | Tariff Basis | Tariff Amount | Tariff Rate | Total Tariff | A1 | A2 | A3 | A4 | A5 | A6 | A7 | A8
Beef | Calves | 2019-04-01 00:00:00 | Head | 10 | 2000 |  | Weight (kg) | 5 kg | 12 | 5000 | 1 | 2 | 3
Beef | Calves | 2019-05-01 00:00:00 | Head | 11 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | 1 | 2 | 4
Beef | Calves | 2019-06-01 00:00:00 | Head | 12 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | 3 | 5 | 7
Beef | Calves | 2019-07-01 00:00:00 | Head | 13 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | 1 | 2
Beef | Calves | 2019-08-01 00:00:00 | Head | 14 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | 4 | 5 | 7 | 9 | 12
Beef | Calves | 2019-09-01 00:00:00 | Head | 15 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | 4 | 5 | 6
Beef | Calves | 2019-10-01 00:00:00 | Head | 16 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | 7 | 11 | 16
Beef | Calves | 2019-11-01 00:00:00 | Head | 17 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | 1 | 2 | 4
Beef | Calves | 2019-12-01 00:00:00 | Head | 16 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | 13 | 17 | 4
Beef | Calves | 2020-01-01 00:00:00 | Head | 14 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | 1 | 3
Beef | Calves | 2020-02-01 00:00:00 | Head | 12 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | 2 | 3 | 7
Beef | Calves | 2020-03-01 00:00:00 | Head | 11 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | 4 | 5 | 8
Dairy | Milk | 2019-04-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | 1 | 9 | 10
Dairy | Milk | 2019-05-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | 1 | 4 | 8
Dairy | Milk | 2019-06-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | 8 | 14 | 15 | 16 | 18
Dairy | Milk | 2019-07-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | 16 | 9 | 12 | 6 | 2
Dairy | Milk | 2019-08-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | 14 | 12 | 13 | 4 | 9
Dairy | Milk | 2019-09-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | 9 | 10 | 13 | 2 | 1
Dairy | Milk | 2019-10-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | 3 | 12 | 18 | 16 | 11
Dairy | Milk | 2019-11-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | 2 | 18 | 12 | 3 | 7
Dairy | Milk | 2019-12-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | 2 | 3 | 6 | 9 | 10
Dairy | Milk | 2020-01-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | 11 | 15 | 18 | 8 | 12
Dairy | Milk | 2020-02-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | 9 | 7 | 2 | 11 | 5
Dairy | Milk | 2020-03-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | 13 | 11 | 16 | 9 | 2 | 14 | 15
Spreadsheet: 43074d1241674320-inserting-and-removing-select-rows-pivot
Sheet: Sheet1

Sum of Weight (g)
Category | Item | Total
Backpacks - Accessories | Arc'Teryx Accessory Pocket
 | Arc'Teryx Axe Keeper
 | [NAME] with Dongle | 158.7
 | Arc'Teryx Pack Cover | 150.25
 | Osprey Airporter LZ Pack Duffel (x2) | 368.54
 | Osprey Packs Backpack Raincover - Large | 200
Backpacks - Accessories Total |  | 877.49
Backpacks - Frameless | Arc'Teryx Arro 22L | 1110.16
 | [NAME] 21L | 1140.21
 | [NAME] | 1000.17
 | Dynafit RC20 Race | 430.06
Backpacks - Frameless Total |  | 3680.6
Backpacks - Internal Frame | Arc'Teryx Bora 80L | 3231.84
 | [NAME] | 2239.61
 | Arc'Teryx Naos 55L | 2126.21
 | [NAME] 75 + 20L | 2749.9
 | Osprey Crescent 110L | 3401.94
Backpacks - Internal Frame Total |  | 13749.5
[NAME] Sacks | MSR Packshower | 581.6
 | Sea to Summit Ultra-Sil - 13L - 8.5 x 21 - Green | 40
 | Sea to Summit Ultra-Sil - 1L - 6 x 9 - Green | 20
 | Sea to Summit Ultra-Sil - 20L - 10 x 24 - Blue | 50
 | Sea to Summit Ultra-Sil - 8L - 6.5 x 18 - Blue | 30
[NAME] |  | 721.6
[NAME] Sacks | Cactus Creek ProLite 3 - Short | 22.1126218622191
 | REI [NAME] x 16.5
 | Therm-a-Rest ProLite 3 - Short | 21.26213640597991
 | Therm-a-Rest ProLite 4 - Reg | 25.51456368717588
[NAME] |  | 68.88932195537488
Batteries | INSERT NEW ITEM HERE
Batteries    Total
Bear Protection | Ursack S29 Bear Resistant Food Bag | 167.2621397270419
Bear Protection Total |  | 167.2621397270419
Grand Total |  | 19265.34146168242
Spreadsheet: 36873d1234847038-excel-2007-how-do-i-reference-a-min-value-in-another-spreadsheet-discrete-measures
Sheet: KJ@C

Level | 25PE | 25CS | 5PE | 5CS | 75PE | 75CS | 10PE | 10CS | 15PE | 15CS
Spreadsheet: 551305d1512836333-compare-2-lists-and-leave-unmatched-items-compare-2-lists-problemv1
Sheet: Sheet1

Original Data
List 1 |  | List 2
apples |  | apples
apples |  | apples
apples |  | pears
grapes
I need the end result to be
List 1 |  | List 2
apples |  | pears
grapes
Hence, I need to:
1. Compare 2 lists
2. Remove any identical items
3. l Leave only the unmatched items.
Can anyone help?
Spreadsheet: 154074d1336178587-somewhat-complex-document-problems-extracting-and-organizing-data-from-cells-6maxhyper
Sheet: Sheet1

 | Players | [NAME] | Seat 1 | Seat 2 | Seat 3 | Seat 4 | Seat 5 | Seat 6 |  | Seat 1 | Seat 2 | Seat 3 | Seat 4 | Seat 5 | Seat 6 |  | If there are 6 players and seat #1 has button, seat #2 will have SB, seat #3 BB, #4 UTG, #5 MP and #6 will have CO.
 | 6 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If #2 has button then #3 has SB, #4 BB, #5 UTG, #6 MP and #1 CO and so on. If there are 5 players then there is no MP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | and if there are 4 players there is no MP and no UTG. If there are only 3 players (the minimum) then there is only
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BU, SB and BB.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | BU | SB | BB | UTG | MP | CO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | BU | SB | BB | UTG | CO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | BU | SB | BB | CO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | BU | SB | BB
 |  |  |  |  |  |  |  |  |  | UTG | MP | CO | BU | SB | BB
Spreadsheet: 808625d1670539027-nested-if-function-for-pivot-table-example-book
Sheet: Sheet1

 | Machine Operator | Welders | Assemblers | Painters | Paint Preppers | Trainers | Asst Group Lead | [NAME] | Group Leaders | Total Direct | Material Handlers | Quality [NAME] | Cycle Counters | Maintenance | Supervisors | Total Indirect | Total HC
00180171
00180172
00180177
00180198
00180201
00180202
00180203
00180503
00180501
00180502
00180175
00180179
00180182
00180180
00184202
00184205
00180197
00180211
00180212
00180213
Spreadsheet: be1bab98-b111-455f-a0a5-8b5ad1bc391b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3932 | 27096 | [NAME] | Woestenenk | NED | 0 | 00:41:18 | 00:00:00 | [NAME] | 00:00:00 | 00:50:49 | 1 | 02:53:46
3932 | 27094 | Hans | Veldkamp | NED | 0 | 00:44:16 | 00:00:00 | 01:27:08 | 00:00:00 | 00:55:32 | 2 | 03:06:57
3932 | 27092 | Lex | Kiewied | NED | 0 | 00:47:03 | 00:00:00 | 01:29:17 | 00:00:00 | 00:53:37 | 3 | 03:09:58
3932 | 27093 | Rogier | [NAME] | NED | 0 | 00:49:54 | 00:00:00 | [NAME] | 00:00:00 | 01:01:45 | 4 | 03:15:40
3932 | 27095 | [NAME] | Venema | NED | 0 | 00:56:25 | 00:00:00 | 01:35:43 | 00:00:00 | 01:03:25 | 5 | 03:35:34
3932 | 27091 | [NAME] | Brinkman | NED | 0 | 00:41:12 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: daren_farmer__5324__Enron Nom Change
Sheet: Sheet1

To:   [NAME]          (Enron) |  |  |  |  |  | Phone: | (713) 853-6357
From:  Jan Svajian      ([NAME]) |  |  |  |  |  | FAX: | (713) 646-2391
Date:  6/22/00 |  |  |  |  |  | E-Mail: | [EMAIL]
Subject:  Nomination Change Effective June 23nd
Effective Date | CTP NAME | Gross Vol. (MMBtu/d) | DBQ Available | Excess Available | First of the month original nomination |  | Change of Nom on June 16th. |  | Pipeline affected
2000-06-23 00:00:00 | Garza Plant | 7747 | 7127 | 626 | 4694 |  | 4694 |  | Tejas
The increased production is from a new well that went on line June 16th.
Spreadsheet: 859781d1708023727-productif-formula-with-multiple-criteria-productif-formula-with-multiple-criteria
Sheet: Sheet1

 |  |  |  |  |  |  | Classes for scores
 |  | Return | Score |  |  |  | Bottom limit | Upper limit |  | Wrong answer |  |  | Asnwer should be (calculated "by hand")
 |  | 0.05 | -0.35 |  |  |  | -0.34 | -0.29
 |  | -0.02 | -0.34 |  |  |  | -0.29 | -0.24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Return in % if criteria are dropped
 |  | 0.03 | -0.33 |  |  |  | -0.24 | -0.1900000000000001 |  |  |  | 1 |  | Class is outside of range. Instead, the wrong formula calulates the result as if no restriction applied
 |  | -0.0025 | -0.32
 |  | 0.02 | -0.31
 |  | 0.01 |  |  |  |  | The aim is to calulate the return if the score falls into the range given by the class boundaries
 |  | 0.0057
 |  | -0.02 |  |  |  |  |  |  |  |  | [NAME] with SUMPRODUCT |  | [NAME] with PRODUCT
 |  | 0.0072
 |  | -0.0092
Spreadsheet: 48108d1247262647-conditional-formatting-add-duplicates-add-matching
Sheet: Add matching

Customer Name | P/N | Amount
[NAME] | OPA2277U | 103 |  | = if customer name match and P/N match, add all amounts together
[NAME] | OPA2277U | 1881 | Red
[NAME] | PTH12010WAH | 3032 |  | = if customer name match and P/N match, add all amounts together
[NAME] | PTH12010WAH | 44243 | Red
[NAME] | PTH12010WAH | 192389 | Red
[NAME] | PTH12050WAH | 3088 |  | = if customer name match and P/N match, add all amounts together
[NAME] | PTH12050WAH | 48416 | Red
[NAME] | PTH12050WAH | 200447 | Red
[NAME] | PTN78000AAH | 1882 |  | = if customer name match and P/N match, add all amounts together
[NAME] | PTN78000AAH | 15655 | Red
[NAME] | PTN78000AAH | 53165 | Red
[NAME] | PTN78000HAH | 1852 |  | = if customer name match and P/N match, add all amounts together
[NAME] | PTN78000HAH | 15423 | Red
[NAME] | PTN78000HAH | 52367 | Red
[NAME] | PTN78060WAH | 3492 |  | = if customer name match and P/N match, add all amounts together
[NAME] | PTN78060WAH | 50840 | Red
[NAME] | PTN78060WAH | 204375 | Red
[NAME] | SN5404J | 21 |  | = if customer name match and P/N match, add all amounts together
[NAME] | SN5406J | 36 |  | = if customer name match and P/N match, add all amounts together
[NAME] | SN65LBC176D | 45 |  | = if customer name match and P/N match, add all amounts together
[NAME] | SN74LVC07ADR | 425 |  | = if customer name match and P/N match, add all amounts together
[NAME] | SN74LVC07ADR | 1063 | Red
[NAME] | [NAME] | 405 |  | = if customer name match and P/N match, add all amounts together
[NAME] | [NAME] | 660 | Red
[NAME] | SN74LVCC3245APWR | 6720 |  | = if customer name match and P/N match, add all amounts together
Spreadsheet: 684939d1593622934-sumproduct-returning-value-error-supervisortest
Sheet: Srap

Week # |  | 1
Beginning Date
Activity Code | 1
Spreadsheet: 77830d1278330941-trying-to-select-a-random-string-from-a-range-trial-comment-bank-10sc4-july-2010
Sheet: names with number codes

name | Participation | Motivation | Organisation | Concentration | Understanding | Overall | Target for improvement | Mark from B1a | Grade from B1a | Mark from B1b | Grade from B1b | Current grade from 4 modules | Target grade
[NAME] | 5 | 1 | 1 | 5 | 4 | 5 | 2 | 22 | D | 0 | u | E | D
[NAME] | 4 | 2 | 4 | 2 | 5 | 3 | 4 | 23 | D | 23 | D | D | C
Eliza | 3 | 1 | 2 | 2 | 3 | 3 | 1 | 16 | E | 16 | E | E | C
Jemma | 2 | 1 | 1 | 2 | 2 | 2 | 1 | 19 | E | 21 | D | D | D
Chun | 2 | 2 | 1 | 1 | 2 | 2 | 1 | 12 | F | 20 | D | E | C
[NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 23 | D | 24 | C | D | C
[NAME] | 2 | 2 | 2 | 2 | 3 | 2 | 1 | 19 | E | 23 | D | D | C
[NAME] | 3 | 4 | 2 | 2 | 3 | 2 | 4 | 17 | E | 16 | E | E | D
Shannon | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 24 | C | 21 | D | D | C
Louis | 1 | 3 | 4 | 2 | 5 | 4 | 3 | 19 | E | 18 | E | E | C
[NAME] | 5 | 3 | 2 | 4 | 4 | 4 | 2 | 8 | G | 16 | E | F | E
[NAME] | 1 | 3 | 5 | 2 | 4 | 3 | 4 | 18 | E | 18 | E | F | D
[NAME] | 3 | 4 | 5 | 3 | 4 | 5 | 2 | 12 | F | 16 | E | F | C
Jessica | 2 | 2 | 1 | 2 | 1 | 2 | 1 | 28 | B | 26 | C | C | C
[NAME] | 3 | 5 | 2 | 2 | 3 | 3 | 1 | 23 | D | 20 | D | E | D
Kiddie | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 20 | D | 21 | D | D | C
Toni | 3 | 2 | 1 | 2 | 2 | 1 | 4 | 20 | D | 18 | E | E | D
[NAME] | 1 | 1 | 3 | 2 | 5 | 2 | 3 | 20 | D | 16 | E | E | D
Grant | 2 | 5 | 3 | 3 | 3 | 2 | 2 | 20 | D | 16 | E | E | C
[NAME] | 4 | 4 | 5 | 3 | 5 | 5 | 3 | 26 | C | 28 | B | C | E
Jasmine | 1 | 3 | 3 | 4 | 2 | 2 | 2 | 19 | E | 0 | u | F | E
Spreadsheet: 796254d1663172273-paste-value-function-affecting-isblank-formula-forumexample
Sheet: Sheet1

 |  |  |  | CONCATENATE | A | B | C | D | E |  | [NAME] TO COPY FROM |  |  |  |  | DATA FROM (Q7:R8) IS REFERENCED INTO (O7:P8) VIA IF FORMULA
VALUES IN (F4:J5) ARE MANUALLY ENTERED |  |  |  |  | Z | X | Z | 5R
 |  |  |  |  | F | G | H |  | 1L
DATA FROM (L7:P8) IS COPIED AND VALUES PASTED INTO (F7:J8) |  |  |  |  | E | R | T | 5R |  |  | E | R | T |  |  | 5R
 |  |  |  |  | H | J | K |  | 5L |  | H | J | K |  |  |  | 5L
 |  |  |  | CELL (E7) DOES NOT CONTAIN "5R" DUE TO (E7) CONTAINING A "NULL" STRING BECAUSE ITS REFERENCE DATA IS FORMULA DERIVED
 |  |  |  |  |  |  | IN MY ORIGINAL WORKBOOK, I COPY AND PAST VALUES INTO ANOTHER WORKBOOK THAT I CANNOT EDIT. I AM LOOKING FOR A SOLUTION ON MY END THAT DOESN'T REQUIRE ME TO FORCE CHANGES INTO THE WORKBOOK I DO NOT HAVE RIGHTS TO.
 |  |  |  | IDEALLY I WOULD LIKE MY COPIED INFORMATION NOT CREATE A "NULL" STRING. IS THIS POSSIBLE USING THE "PASTE VALUE" FUNCTION?
 |  |  |  |  |  |  | IF THERE IS NOT THE MEANS TO PREVENT THIS FROM HAPPENING FROM MY WORK BOOK, IS THERE A MEANS TO POPULATE THE TAILING TEXT IN THIS EXAMPLE WHEN A NULL STRING IS POPULATED?
 |  |  |  | ADDITIONALLY, I AM TRYING TO AVOID MACROS
Spreadsheet: 793268d1661370581-value-error-financial-report-2-etaf
Sheet: Financial Report

FY23 CWSP Formula Grant Report |  |  |  |  |  |  |  | AWARD INFO |  | STATE REMAINING GRANT $ |  | EXPEDITURES
Quarter ending: [date] |  |  |  |  |  |  |  | Total Award Amount: | 1000000 | Amount Available at Grant Start |  | Total Disbursed
[CWSP Name] |  |  |  |  |  |  |  | Administrative Costs (AC): 15% | 150000 | Total Requested |  | Total Spent
[Grant ID] |  |  |  |  |  |  |  | Project Completion Costs (PCC): 85% | 850000 | Total Remaining |  | Remaining Cash on Hand
 | .
 |  | Ex: Draw only | Ex: Draw+ Adv | Ex: Draw+ Reimb
 |  | Quarter 1 | Quarter2 | Quarter 3 | Quarter 4 | Quarter 5 | Quarter 6 | Quarter 7 | Quarter 8 | Cumulative Totals | % Remaining
Administrative Costs (AC) | Total Expenditures this Quarter- AC | 20000 | 30000 | 37500 | 37500 | 0 | 0 | 0 | 0 |  |  | admin pacing
 | Quarter to Date Cash Reimbursements- AC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | New Advance Request | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Cash Balance at Quarter Start- AC |  |  |  |  |  |  |  |  |  |  | HIDE | 0
 | Quarter End Remaining Cash Balance- AC |  |  |  |  |  |  |  |  |  |  | HIDE
 | Cumulative expenses |  |  |  |  |  |  |  |  |  |  | HIDE
 | Available State AC |  |  |  |  |  |  |  |  |  |  | HIDE
 | Quarter End Draw Request
 | Total Amount AC Currently Requested
Project Completion Costs (PCC) | Total Expenditures this Quarter- PCC | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | pcc pacing
 | Quarter to Date Cash Reimbursements- PCC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | New Advance Request | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Cash Balance at Quarter Start- PCC |  |  |  |  |  |  |  |  |  |  | HIDE
 | Quarter End Remaining Cash Balance- PCC |  |  |  |  |  |  |  |  |  |  | HIDE
 | Quarter End Draw Request
 | Total PCC Currently Requested
 | Total Draw Requested
 | Total Advance Requested
 | Quarter Total Requested |  |  |  |  |  |  |  |  |  |  | remaining state funds
 | PCC Non- Match Eligible | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | PCC- Match Eligible
 | Interest Earned | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | goes the other way- talks to TPM tab