tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 210904d1359596162-search-engine-for-excel-do-not-display-results-initially-ef209b_search_engine
Sheet: DATA

seq |  |  |  |  | List | Description | Day | Site_PCode | Site_Name | Site_Addr1 | Site_Addr2 | Site_Addr3 | Site_Addr4
- |  |  |  |  | 280 | KX05UWF | Saturday | BA1 5TJ | HARE AND HOUNDS (LANSDOWN) | LANDSDOWN |  | bath
- |  |  |  |  | 280 | KX05UWF | Saturday | BA1 2LS | TOPLAND (ROYAL CRESCENT HOTEL) | 15-16 ROYAL CRESCENT HOTEL |  | BATH
- |  |  |  |  | 280 | KX05UWF | Saturday | BA1 2LS | TOPLAND (ROYAL CRESCENT HOTEL) | 15-16 ROYAL CRESCENT HOTEL |  | BATH
- |  |  |  |  | 284 | HX05KYB | Tuesday | BS16 6RX | SPAR STORE | 32 WESTBOURNE ROAD | DOWNEND | BRISTOL | AVON
- |  |  |  |  | 284 | HX05KYB | Tuesday | BA1 2LS | TOPLAND (ROYAL CRESCENT HOTEL) | 15-16 ROYAL CRESCENT HOTEL |  | BATH
- |  |  |  |  | 284 | HX05KYB | Tuesday | BA1 3JL | TOOLSTATION | UNIT 1 THE MALTINGS | BRASSMILL LANE | BATH | AVON
- |  |  |  |  | 284 | HX05KYB | Tuesday | BS16 3BA | BHUJON RESTAURANT LTD | 615 FISHPONDS ROAD | FISHPONDS | BRISTOL
- |  |  |  |  | 284 | HX05KYB | Tuesday | BS16 2NN | LLOYDS PHARMACY | 40 LANAWAY ROAD | OLDBURY COURT. FISHPONDS | [NAME]
- |  |  |  |  | 284 | HX05KYB | Tuesday | BS15 8JP | KINGSWOOD AUTOPART LTD | 2-6 REGENT STREET | KINGSWOOD | BRISTOL
- |  |  |  |  | 284 | HX05KYB | Tuesday | BS16 5PJ | PROVIDENT FINANCIAL | SOUTH VIEW BUSINESS PARK | 26 SOUTH VIEW | BRISTOL | AVON
- |  |  |  |  | 284 | HX05KYB | Tuesday | BS16 5FJ | LLOYDS PHARMACY | THE WILLOW SURGERY HILL HOUSE | ROAD DOWNEND | BRISTOL | AVON
- |  |  |  |  | 285 | HX05KYB | Wednesday | BA1 1LT | BATH & NORTH EAST SOMERSET COUNCIL | ABBEY CHAMBERS | [NAME], KINGSTON BUI | BATH | AVON
- |  |  |  |  | 285 | HX05KYB | Wednesday | BS15 9LA | WISHING WELL | WISHING WELL KINGSWOOD - BS15 9LA | KINGSWOOD ASPECTS LEISURE PARK | KINGSWOOD | BRISTOL
- |  |  |  |  | 285 | HX05KYB | Wednesday | BS16 3JB | MACPHERSON AND COLBURN LTD | 48-60 LODGECAUSEWAY | FISHPONDS | BRISTOL
- |  |  |  |  | 285 | HX05KYB | Wednesday | BA2 1DB | WILLIAM HILL - TWERTON | UNIT 2 109 HIGH STREET | TWERTON | BATH
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Spreadsheet: eric_saibi__9867__101701
Sheet: Jim Bridger 04

Owner Name |  | PacifiCorp
Station Name |  | [NAME]
Unit Name |  | [NAME] 04
NERC Region |  | WSCC
State |  | WY
Fuel Type |  | Coal
Capacity |  | 578 MW
Start Date |  | 2001-10-16 00:00:00
End Date |  | 2001-10-20 00:00:00
Comments |  | Lost part of a cell in their cooling tower
SIC |  | 4911
Plant ID |  | 1015362
Unit ID |  | 1007978
Outage ID |  | 18663
Spreadsheet: 270728d1381611159-index-match-one-step-away-multi-branch-dead-stock-look-up
Sheet: DATA

Branch | Item | Size | Description | Product Group | UOM | Cost | On Hand | Available | On Order | Backordered | 2013-09-13 00:00:00 | 2013-08-13 00:00:00 | 2013-07-13 00:00:00 | 2013-06-13 00:00:00 | 2013-05-13 00:00:00 | 2013-04-13 00:00:00 | 2013-03-13 00:00:00 | 2013-02-13 00:00:00 | 2013-01-13 00:00:00 | 2013-12-12 00:00:00 | 2013-11-12 00:00:00 | Total | Average | Months | Days On Hand | Weighted Average | Last 3 | Next 3 | Mid 5 |  |  |  | Location
BIR | CBS340810 | 3/4X8X10 | SEL QUALITY BEVEL CEDAR KD | 01 01LCD | EAC | 959.01 /MBF | 435 | 435 | 0 | 0 | 32 | 96 | 0 | 40 | 288 | 20 | 0 | 0 | 0 | 32 | 8 | 564 | 47 | 12
BIR | CBS340812 | 3/4X8X12 | SEL QUALITY BEVEL CEDAR KD | 01 01LCD | EAC | 963.99 /MBF | 64 | 64 | 0 | 0 | 8 | 184 | 80 | 0 | 0 | 0 | 0 | 40 | 0 | 32 | 24 | 400 | 33 | 12
Spreadsheet: 111085d1307563886-summing-certain-values-based-on-what-is-in-another-column-779158-summing-certain-values-example
Sheet: Sheet3

 |  |  |  |  |  |  |  |  |  |  |  | attributes |  |  | names
 |  |  |  |  |  |  |  |  |  |  |  | shoes |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | tie |  |  | Minnie
 |  |  |  |  |  |  |  |  |  |  |  | tie |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | belt |  |  | Goofy
 |  |  |  |  |  |  |  |  |  |  |  | tie |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | shoes |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | tie |  |  | Dumbo
 |  |  |  |  |  |  |  |  |  |  |  | shoes |  |  | Minnie
 |  |  |  |  |  |  |  |  |  |  |  | belt |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | tie |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | tie |  |  | Zippy
 |  |  |  |  |  |  |  |  |  |  |  | shoes |  |  | Minnie
 |  |  |  |  |  |  |  |  |  |  |  | belt |  |  | Goofy
 |  |  |  |  |  |  |  |  |  |  |  | tie |  |  | Minnie
 |  |  |  |  |  |  |  |  |  |  |  | shoes |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | belt |  |  | Dumbo
 |  |  |  |  |  |  |  |  |  |  |  | tie |  |  | Minnie
 |  |  |  |  |  |  |  |  |  |  |  | belt |  |  | Goofy
 |  |  |  |  |  |  |  |  |  |  |  | tie |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | belt |  |  | Minnie
Spreadsheet: a4aa8f6c-0696-4ac5-9b4c-09214a156ecd
Sheet: Sheet1

State Codes
State Code | State Name
AL | Alabama
AK | Alaska
AZ | Arizona
AR | Arkansas
CA | California
CO | Colorado
CT | Connecticut
DE | Delaware
DC | District of Columbia
FL | Florida
GA | Georgia
HI | Hawaii
ID | Idaho
IL | Illinois
IN | Indiana
IA | Iowa
KS | Kansas
KY | Kentucky
LA | Louisiana
ME | Maine
MD | Maryland
MA | Massachusetts
MI | Michigan
MN | Minnesota
MS | Mississippi
MO | Missouri
MT | Montana
NE | Nebraska
NV | Nevada
NH | New Hampshire
NJ | New Jersey
NM | New Mexico
NY | New York
NC | North Carolina
ND | North Dakota
OH | Ohio
OK | Oklahoma
OR | Oregon
PA | Pennsylvania
RI | Rhode Island
SC | South Carolina
SD | South Dakota
TN | Tennessee
TX | Texas
UT | Utah
VT | Vermont
VA | Virginia
WA | Washington
WV | West Virginia
WI | Wisconsin
WY | Wyoming
XX | Other Than United States
Spreadsheet: louise_kitchen__22583__ENA_Houston_oct26 home
Sheet: Sheet2

Count of Full Name
Region / State | State | Total
AB | AB | 122
 | ON | 3
Australia | TX | 1
CA | CA | 16
 | FL | 1
Chile | TX | 2
China | TX | 5
CO | CO | 5
IL | IL | 7
Japan | TX | 5
LO | TX | 27
MI | MI | 1
NL | TX | 2
NY | CT | 1
 | NJ | 1
 | NY | 5
 | TX | 1
OH | OH | 2
ON | ON | 18
 | QC | 1
 | (blank) | 1
OR | MA | 2
 | OR | 108
 | WA | 8
TX | CA | 1
 | FL | 2
 | IL | 1
 | NJ | 1
 | NY | 1
 | OH | 1
 | TX | 1145
 | (blank) | 8
Grand Total |  | 1505
Spreadsheet: 758875d1639137583-dynamic-array-difficulty-lookup-sumif-unique-filter-xlookup-based-on-multiple-criteria-sample-gk
Sheet: GP Import

Base Data |  |  |  |  |  |  | Desired Output, except sum each unique [Item]*[Lot] combination instead of each unique [Lot] (left) or [Item] (right)
STCKCNTID | Item | BIN | Qty | LOT | Item Type |  | STCKCNTID | Item | BIN | Qty | LOT | Item Type | FG Totals | ITEMNMBR | LOCNCODE | BINNMBR | COUNTEDQTY | COUNTDATE | COUNTTIME | Stock_Serial_Lot_Count | VERIFIED | RAW Totals | STCKCNTID | ITEMNMBR | LOCNCODE | BINNMBR | COUNTEDQTY | COUNTDATE | COUNTTIME | Stock_Serial_Lot_Count | VERIFIED
2021 MF RAW YE | RI-2342-MF | YECNT21 | 50 | 112921001D | FG |  |  | RI-2342-MF | YECNT21 |  |  | FG
2021 MF RAW YE | RI-2342-MF | YECNT21 | 50 | 112921002D | FG |  | 2021 MF RAW YE | RI-2342-MF | YECNT21 | 50 | 112921002D | FG |  | RI-2342-MF |  |  |  |  |  |  |  |  |  | RI-2342-MF |  |  |  |  |  |  |  |  | RAW STCKCNTID: | 2021 MF RAW YE
2021 MF RAW YE | RI-2342-MF | YECNT21 | 50 | 112921003D | FG |  | 2021 MF RAW YE | RI-2342-MF | YECNT21 | 50 | 112921003D | FG |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | FINISHED STCKCNTID: | 2021 MF FG YE
2021 MF RAW YE | RI-2342-MF | YECNT21 | 16 | 112921004D | FG |  | 2021 MF RAW YE | RI-2342-MF | YECNT21 | 16 | 112921004D | FG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LOCNCODE: | MF
2021 MF RAW YE | RI-2342-MF | YECNT21 | 40 | 102521 | FG |  | 2021 MF RAW YE | RI-2342-MF | YECNT21 | 40 | 102521 | FG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BINNMBR: | YECNT21
2021 MF RAW YE | RI-2342-MF | YECNT21 | 40 | 102521002B | FG |  | 2021 MF RAW YE | RI-2342-MF | YECNT21 | 64 | 102521002B | FG
2021 MF RAW YE | RI-2342-MF | YECNT21 | 36 | 102521003B | FG |  | 2021 MF RAW YE | RI-2342-MF | YECNT21 | 36 | 102521003B | FG
2021 MF RAW YE | RI-2342-MF | YECNT21 | 4 | 102521004B | FG |  | 2021 MF RAW YE | RI-2342-MF | YECNT21 | 4 | 102521004B | FG
2021 MF RAW YE | RI-2342-MF | YECNT21 | 24 | 102521002B | FG |  | 2021 MF RAW YE | RI-2342-MF | YECNT21 | 16 | 1D0098H | FG
2021 MF RAW YE | RI-2342-MF | YECNT21 | 16 | 1D0098H | FG |  | 2021 MF RAW YE | [NAME] | YECNT21 | 80 | 102521004B | FG
2021 MF RAW YE | [NAME] | YECNT21 | 40 | 102521004B | FG |  | 2021 MF RAW YE | RI-144-MF | YECNT21 | 28 | 102521005B | FG
2021 MF RAW YE | [NAME] | YECNT21 | 40 | 102521004B | FG |  | 2021 MF RAW YE | RI-144-MF | YECNT21 | 40 | 102621002B | FG
2021 MF RAW YE | RI-144-MF | YECNT21 | 28 | 102521005B | FG |  | 2021 MF RAW YE | RI-144-MF | YECNT21 | 40 | 102621001B | FG
2021 MF RAW YE | RI-144-MF | YECNT21 | 40 | 102621002B | FG
2021 MF RAW YE | RI-144-MF | YECNT21 | 40 | 102621001B | FG
Spreadsheet: louise_kitchen__22584__Bsoptval HPL
Sheet: BSOPTVAL

 | Black-Scholes Option Valuation Calculation
 | Enron Corp
 | . | Date of Grant
 | Assumptions | 1993-03-03 00:00:00 |  | 1994-05-02 00:00:00 |  | 1994-12-31 00:00:00 |  | 1995-05-01 00:00:00 |  | 1995-12-29 00:00:00 |  | 1996-01-23 00:00:00
 | Enron Volatility | 0.365
 | Enron Yield | 0.011
 | Interest Rate | 0.0589269
 | Market Price | 52.91
 | Strike Price | 14.25 | 14.25 | 14.6875 | 14.6875 | 15.25 | 15.25 | 17.125 | 17.125 | 19.0625 | 19.0625 | 18.375 | 18.375
 | Option Term | 1 | 3 | 1 | 3 | 1 | 3 | 1 | 3 | 1 | 3 | 1 | 3
 | Intermediate Terms
 | STERM
 | Vol*SqRt (Time)
 | Rate*Time
 | DTERM
 | [NAME] (DTERM)
 | [NAME] (DTERM-(Vol*SqRt(Time))
 | Black-Scholes Values
 | BSVAL
 | BLACK-SCHOLES RATIO VALUE
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | Number of Shares Outstanding | 3400 |  | 1360 |  | 149771 |  | 1320 |  | 5229 |  | 3920
 | Difference in Black-Scholes Value
 | NOTES:
 | The appropriate volatility and dividend yield are the expected future volatility and dividend yield over the term of the option
 | -   Expected future values can't be determined, but must be estimated from historical data.
 | -  A look at serveral historical values, based on different historical periods may provide a more complete of picture of estimates
 | for volatility and dividend yield
 | -  Changes in corporate dividend policy can override historical averages.
 | The appropriate risk-free interest rate is the zero-coupon government bond yield for the term of the option.
Spreadsheet: 124566d1318465970-displaying-dates-over-the-next-week-book1
Sheet: Sheet1

 |  |  | 1 | 2011-10-12 00:00:00 | 4 | Wednesday |  |  | 1 | Sunday
 |  |  | 2 | 2011-10-13 00:00:00 | 5 | Thursday |  |  | 2 | Monday
 |  |  | 3 | 2011-10-14 00:00:00 | 6 | Friday |  |  | 3 | Tuesday
 |  |  | 4 | 2011-10-15 00:00:00 | 7 | Saturday |  |  | 4 | Wednesday
 |  |  | 5 | 2011-10-16 00:00:00 | 1 | Sunday |  |  | 5 | Thursday
 |  |  | 6 | 2011-10-17 00:00:00 | 2 | Monday |  |  | 6 | Friday
 |  |  | 7 | 2011-10-18 00:00:00 | 3 | Tuesday |  |  | 7 | Saturday
Spreadsheet: 551309d1512840779-compare-2-lists-and-leave-unmatched-items-compare-2-lists-problemv1
Sheet: Sheet1

Original Data
 |  |  |  |  | List One | List Two
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: 133597d1324493210-listing-many-unique-values-based-on-an-if-statement-book1-1-
Sheet: OutputReport

How often do you visit this business?
Why choose this business?
 |  | Row Labels | Count of Participant #
 |  | Good as New | 1
 |  | [NAME]'s [NAME] | 16
 |  | World's Away | 4
 |  | Convenient and store owner rocks! | 1
 |  | One of my favourite stores | 1
 |  | Product/price | 1
 |  | Regular business/purchases/second home | 1
 |  | Grand Total | 21
Spreadsheet: chris_germany__2576__VNG Pipeline Setup-Oct-00
Sheet: 10-10

2000-10-10 00:00:00 |  |  | VNG Daily Setup
Flow Date |  |  |  | DTH
 |  |  | 2000-10-09 00:00:00 |  | 2000-10-10 00:00:00 |  | 2000-10-11 00:00:00 |  | 2000-10-12 00:00:00
 |  |  | Monday |  | Tuesday |  | Wednesday |  | Thursday
 |  |  | High | Low | High | Low | High | Low | High | Low
Richmond, VA Forecast |  |  | 55 | 50 | 61 | 43 | 68 | 41 | 67 | 44
Cooling / (Heating) Degree Days
Forecasted Demand
INTERRUPTIBLE STATUS |  |  | ON / ON |  | ON / ON |  | ON / ON |  | ON / ON
SUPPLY: | AVAILABLE
TRANSCO
FS  Swing | 15930 |  | 15930 |  | 15930 |  | 15930 |  | 15930
FT | 14400 |  | 20556 |  | 20556 |  | 20556 |  | 20556
WSS - W/D  (3,386) | 8524 |  | -3300 |  | -3300 |  | -3300 |  | -3300
GSS-INJ (575) | 2070 |  | -484 |  | -484 |  | -484 |  | -484
WSS  W/D Capacity | 0
TOTAL Emporia | 38000
TOTAL City Gate (.0268%) | 37620
FT-WSS-INJ (3,386)
COLUMBIA
+  SST - Spot | 0 |  |  |  | 0 |  | 1465
+  FTS - System Supply
=  Subtotal FT Sys. Supply | 57970 |  |  | * |  | * |  | * |  | *
SST - FSS         (9837) | 31827.5 |  |  |  | -5076 |  | -5076 |  | -5076
EndUser |  |  | 2000 |  | 2000 |  | 2000 |  | 2000
Cove Point LNG |  |  | 0 |  | 0 |  | 0 |  | 0
LNG (3,244) | 52090 |  | -6081 | * | -6081 | * | -6081 | * | -6081 | *
TOTAL | 141887.5
CNGT
FTNN | 46075 |  | 16558 |  | 16558 |  | 16558 |  | 16558
GSS            (16,599) | 53648 |  | -16599 |  | -16599 |  | -16599 |  | -16599
Subtotal Cannot exceed 46,075 Apr - Oct
EndUser |  |  | 17493
[NAME] | 9975
TOTAL Quantico | 93604
TOTAL City Gate(.0025%) | 93369.99
VNG
PROPANE
NORTHERN | 17275 |  | 0 |  | 0 |  | 0 |  | 0
SOUTHERN | 34450 |  | 0 |  | 0 |  | 0 |  | 0
TOTAL | 324602.49
Difference
 | Projected  Storage  Summary
 |  |  | [NAME]. |  | [NAME]
 | FSS | TCO | 9837 |  | 63655
 | GSS | TRCO | 484 |  | 2070
 | WSS | TRCO | 3386 |  | 8524
 | GSS | CNG | 16599 |  | 53648
 | LNG | TCO | 3244 |  | 52090
 | Propane |  | 12000 | gal day | 51825
High Burn Contingenies |  |  |  |  |  |  |  | Low Burn Contingenies
1) Reduce Columbia FSS Injection to 0 |  |  |  |  |  |  | 1) Increase Columbia FSS injection to 9,837
2) Reduce CNG GSS Injection to 0 |  |  |  |  |  |  | 2) Notify ENA  contact for instructions if there is excess supply
3) Notify ENA  contact for instructions if additional supply is needed
Spreadsheet: phillip_m_love__30139__200006_OA
Sheet: STG_FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ALL
REGION: STORAGE
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  | 0
2 |  | Liquidations |  | -1405797
3 |  | Interdesk |  | 0
4 |  | Option Premiums |  | 0
5 |  | Dmd Reimbursements |  | 0
 | Total Sales: |  | 0 | -1405797
 | Purchases:
6 |  | 3rd Party / Inter Enron |  | 0
7 |  | Liquidations |  | 0
8 |  | Interdesk |  | 0
9 |  | Option Premiums |  | 0
10 |  | [NAME] |  | 0
 | Total Purchases: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales |  | 0
12 |  | Purchases |  | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind |  | 0
14 |  | Cash Out |  | 0
15 |  | Cash In |  | 0
16 |  | Synthetic Storage |  | 0
 | Total Imbalances: |  | 0 | 0
 | Storage:
17 |  | Injection (Sales to Stg) |  | 0
18 |  | W/D (Purchase from Stg) |  | 0
19 |  | Inventory Profit |  | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
 |  |  |  | 0
20 | Linepack: |  |  | 0
 |  |  |  | 0
21 | Shrinkage: |  |  | 0
 |  |  |  | 0
22 | UA4: |  |  | 0
 |  |  |  | 0
23 | Fuel: |  |  | 0
 |  |  |  | 0
 | Transport Expense: |  |  | 0
24 |  | Commodity |  | 0
25 |  | Demand |  | 0
 | Total Transport Expense: |  | 0 | 0
 | Transport Revenue:
26 |  | Interstate |  | 0
27 |  | Intrastate |  | 2162
 | Total Transport Revenue: |  | 0 | 2162
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense |  | 0
29 |  | Transport Revenue |  | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance |  | 143257916
31 |  | Prior Month Book Balance |  | -143891613
 |  | Total MTM Income | 0 | -633697
32 |  | Fuel |  | -39048
33 |  | Financial Liquidations |  | 3467694
34 |  | Originations |  | -1778864
35 |  | Broker Fees |  | -5196
36 |  | Asset Group Demand Charges |  | -382427
37 |  | Tx. Desk Peaking Charge |  | 0
38 |  | Ad Valorem Taxes |  | -103709
39 |  | Production Taxes |  | 0
40 |  | Miscellaneous |  | 1119846
 |  | TOTAL INTRA-MTH
Spreadsheet: 866937d1713857290-lookup-issue-sample_test
Sheet: S1

Order | Created on | Serial Number | System status | User status | Equipment | Description
10287132 | 20210414 |  | CLSD MSPT PRC  SETC | APPR | 23593915 | Toyota [NAME],LX10Wagon-UKTF Donation
10287561 | 20210416 | 16973039 | CLSD GMPS MACM PRC  SETC | APPR | 16973039 | NISSAN,Civilian,Med Bus,Diesel,LHD,4x2
Spreadsheet: 809776d1671303765-how-to-change-all-data-in-new-page-when-copied-from-old-one-tst-hendrikbez-
Sheet: SOA MO 11

Statement of Activity
 | Cash Beginning of Period
 | Revenue:
 |  | Total Revenue:
 | Expenses:
 |  | Total Expenses:
 | Net : Income Gain / (Loss)
 | Cash End of Period
Spreadsheet: 05605ac5-f2da-4b94-84d4-6c06df51b144
Sheet: Table S2

Table S2. List of primers used.
Gene | Forward Primer | [NAME]
IL8 | 5'-CTCTTGGCAGCCTTCCTGATTT-3' | 5'-TGGGGTGGAAAGGTTTGGAGTA-3'
IL1B | 5'-GGATATGGAGCAACAAGTGG-3' | 5'-ATGTACCAGTTGGGGAACTG-3'
IL1A | 5'-ATCAGTACCTCACGGCTGCT-3' | 5'-TGGGTATCTCAGGCATCTCC-3'
TFRC | 5'-CTTTGGACATGCTCATCTGG-3' | 5'-TGTTTTCCAGTCAGAGGGACA-3'
ALOX5 | 5'-TACATCGAGTTCCCCTGCTAC-3' | 5'-GTTCTTTACGTCGGTGTTGCT-3'
CXCL6 | 5'-TGTTTACGCGTTACGCTGAG-3' | 5'-AACTTGCTTCCCGTTCTTCA -3'
JUN | 5'-AACGTGACAGATGAGCAGGA-3' | 5'-GTTGCTGAGGTTTGCGTAGA-3'
GAS1 | 5'-CGCTGAGCCGCTACCTGA -3' | 5'-CTTGGGCATAGCCAGCATGT -3'
CDKN1B | 5'-GAAGAGTTAACCCGGGACTTG -3' | 5'-AGTAGAACTCGGGCAAGCTG-3'
PHLDA1 | 5'-CCAGGACAGATGCTACTTGG -3' | 5'-GACTACATAACCTAGCAGT-3'
NFkBIZ | 5'-CATGGGAAATCCAATGAACAC-3' | 5'-GGCAACAGCAATATGAAGGAA-3'
ERBB3 | 5'-ATGGTGCATAGAAACCTGGC-3 ' | 5'-ACTCCCAAACTGTCACACCA-3 '
PTGS2 | 5'-TGAAACCCACTCCAAACACA-3' | 5'-GAGAAGGCTTCCCAGCTTTT-3'
IL6 | 5'-AGGAGACTTGCCTGGTGAAA-3 ' | 5'-CAGGGGTGGTTATTGCATCT-3 '
IL1R1 | 5'-AGAGGAAAACAAACCCACAAGG-3 | 5'-CTGGCCGGTGACATTACAGAT-3'
DEDD | 5'-CCAGCCCTCTAAAACAGTGC-3' | 5'-TCTCCTTGGGATCTGGTGTC-3'
NFKB1 | 5'-GCAGAGGAAACGTCAGAAGC-3' | 5'-CATGCTTCATCCCAGCATTA-3'
TBP | 5'-AGTGAAGAACAGTCCAGACTG-3' | 5'-CCAGGAAATAACTCTGGCTCAT-3'
Spreadsheet: 1ef50df9-fd95-4868-9812-e00d22eb4d07
Sheet: 13c

 | Swap Dealers/MSPs4 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Index Tranche | - | 1865221 | - | 229368
Europe | - | 844939 | - | 112289
North America/Asia | - | 1020282 | - | 117079
Index | 2946991 | 8277347 | 1435542 | 2559207
Asia | - | 207936 | - | 50885
Europe | 1416120 | 4084320 | 418621 | 1045412
North America | 1505263 | 3510914 | 1004944 | 1389558
Other | 25608 | 474177 | 11977 | 73352
Other | - | 871526 | - | 383388
Exotic/Total Return Swap | - | 73791 | - | 37667
Swaptions | - | 797735 | - | 345721
TOTAL | 2946991 | 11014094 | 1435542 | 3171963
Spreadsheet: 172ae265-a1b1-494a-b4af-3a60ad161c38
Sheet: Personnel Type contracts

SFY 2015 FEDERAL CODE SHEET
SFY 2015 FEDERAL EDRS-SERVS-UFARS codes crosswalk
UFARS Object Codes to EDRS Personnel Type Code
Contracted/Vendor Personnel Services - SERVICE CODE B, 5 & 6
UFARS OBJECT CODE | EDRS PTC | [NAME]
303 | 1 | Teacher  (Requires a Setting Code)
303 | 2 | Program Coordinator/Due Process Faciliator/Teacher on Special Education Assgnment (TOSA) (Non-Supervisory)
303 | 3 | Academic & Behavioral Strategist
371 | 4 | Physical Therapy Services
372 | 5 | Occupational Therapy Services
375 | 6 | School Nurse
373 | 7 | Educational Speech/Language Pathologist (Requires a Setting Code)
361 | 8 | Paraprofessional/Personal Care Assistant
303 | 9 | Director of Special Education
303 | 10 | Assistant Director/Supervisor
377 | 11 | School Social Worker
303 | 12 | Cultural Liaison (Requires a Setting Code)
378 | 13 | School Psychologist
374 | 14 | Audiologist
303 | 15 | Adaptive Physical Education Specialist
303 | 16 | Consultant (Prior Approval Required) (Requires Activity Code)
303 | 18 | Child Find Facilitator
303 | 22 | Secretary
303 | 23 | Substitute Teacher
303 | 25 | Other Licensed/Certified Therapist - e.g. Music Therapist (Prior Approval Required)
358 | 26 | Foreign Language Interpreter
303 | 27 | Vision Media Assistant
357 | 28 | Interpreter for the Deaf
303 | 29 | Certified Orientation/Mobility Specialist for Visually Impaired
303 | 33 | Regional Low Incidence Facilitator (RLIF)
303 | 34 | Assistative Technology Specialist
303 | 35 | School Counselor
303 | 37 | Certtified Orientation/Mobility Assistant for Visually Impaired
303 | 38 | Security Specialist (Prior Approval Required)
303 | 40 | Social Worker for Interagency Activities
303 | 42 | Physician (Evaluation Only)
376 | 44 | Licensed Nursing Services
303 | 45 | Teacher Clerical Support Aide (Due Process)
303 | 46 | Regional Low Incidence Consultant
303 | 47 | Technical Support Specialist
303 | 48 | Behavioral Specialist
379 | 49 | Qualified Mental Health Professional
363 | 50 | Mental Health Behavioral Aide
303 | 51 | Licensed Parent Educator
362 | 52 | Mental Health Practitioner
359 | 53 | One - to -  One Paraprofessional
303 | 55 | Mentors For Interpreters for the Deaf and Hard of Hearing
303 | 56 | IEIC Service Coordinator
303 | 57 | Contracted Therapeutic Recreational Services
303 | 58 | Substitute Para/PCA/One - to - One Para
373 | 59 | Speech/Language Pathology Assistant
303 | 60 | Special Transportation Nursing Services (IEP-MA reporting only)
303 | 61 | Specail Transportation PCA Services (IEP-MA reporting only)
303 | 62 | Extracurricular Activities (Staff only) (Requires Activity Code)
303 | 63 | Licensed Staff Extra Duty Time
303 | 64 | Non-Licensed Staff Extra Duty Time
303 | 65 | Teacher Assistant (para) (FSC Z CEIS or FSC z MCEIS only)
end of worksheet
Spreadsheet: 724847d1616418874-return-first-value-from-adjacent-column-in-a-variable-range-example
Sheet: Data

LoadDate | LoadRef | Count | Calculation | Desired result
2021-03-22 00:00:00 | 30859 | 1 | 101.0951532775335 | 101.0951532775335
2021-03-22 00:00:00 | 30860 | 1 | 101.0951532775335 | 101.0951532775335
2021-03-22 00:00:00 | 30861 | 2 | 77.92122827417751 | 77.92122827417751
2021-03-22 00:00:00 | 30861 | 2 | 176.9082776786835
2021-03-22 00:00:00 | 30863 | 2 | 123.3651532775335 | 123.3651532775335
2021-03-22 00:00:00 | 30863 | 2 | 73.39589434778
2021-03-22 00:00:00 | 30909 | 3 | 119.39869850814 | 119.39869850814
2021-03-22 00:00:00 | 30909 | 3 | 169.821398658576
2021-03-23 00:00:00 | 30909 | 3 | 155.821398658576
Spreadsheet: 58098d1258409607-pulling-from-table-book1_nov16
Sheet: Sheet1

Start at | Less than | 0 | 1 | 2 | 3
80 | 85 | 5 | 4 | 3 | 2
85 | 90 | 6 | 5 | 4 | 3
90 | 95 | 7 | 6 | 5 | 4
2 | Input
87 | Input
4 | Output
Spreadsheet: 858417d1707127930-check-if-cell-contains-then-copy-the-contents-of-first-previous-cell-plus-its-header-check-if-cell-empty-aligw
Sheet: Sheet1

Name | first level | second level | third level | fourth level | fifth level |  | Name | first level | second level | third level | fourth level | fifth level
[NAME] | - | - | - | Penelope Scott | -
[NAME] | - | [NAME] | - | [NAME] | -
[NAME] | [NAME] | [NAME] | - | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | - | [NAME] | [NAME]
[NAME] | Elijah Lee | - | - | Layla Rodriguez | [NAME]
[NAME] | - | [NAME] | - | [NAME] | [NAME]
[NAME] | - | [NAME] | - | [NAME] | Elijah Young
[NAME] | [NAME] | [NAME] | - | [NAME] | Elijah Young
[NAME] | [NAME] | [NAME] | - | [NAME] | [NAME]