tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30154__9903_OA
Sheet: RECLASS

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - RECLASSES
COMPANY:  ALL
REGION: ALL
 |  |  | Total |  | Central |  | Northeast |  | Southeast-LRC |  | Southeast-EGM |  | West |  | Texas-HPL |  | Texas-EGM |  | Storage |  | Ontario |  | BUG
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  | -1866200 |  |  |  |  |  |  |  |  |  |  |  | 1866200
2 |  | Liquidations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1866200
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  |  |  | -7926
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit |  |  |  |  |  | 89462 |  |  |  |  |  |  |  |  |  | -443620
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity |  |  |  | 25573 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -25573
25 |  | Demand |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -9114
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense |  |  |  |  |  | 27083 |  |  |  |  |  |  |  |  |  | 93300
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  |  |  |  |  |  |  | 1506398
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  | 111021 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -111021
 |  | TOTAL
Spreadsheet: 78335d1278695859-getting-drop-box-cells-to-display-info-on-next-cell-book1
Sheet: Sheet1

Selling Store
Slidell | 380
Covington | 612
Hammond | 1388
Slidell | 380
 |  |  |  |  |  |  |  |  |  |  |  | blank
 |  |  |  |  |  |  |  |  |  |  |  | 380 | Slidell
 |  |  |  |  |  |  |  |  |  |  |  | 612 | Covington
 |  |  |  |  |  |  |  |  |  |  |  | 1388 | Hammond
 |  |  |  |  |  |  |  |  |  |  |  | 1157 | Millerville
 |  |  |  |  |  |  |  |  |  |  |  | 495 | Baton Rouge
 |  |  |  |  |  |  |  |  |  |  |  | 572 | Veterens
 |  |  |  |  |  |  |  |  |  |  |  | 1456 | Harrahan
Spreadsheet: jane_tholt__13115__July2001pricinggriffithprelim2_jc
Sheet: July 17 Supply Price

Line | Supply Pricing For: | 2001-06-19 00:00:00 | Normal | Deal | Settlement | Difference
(A) | (B) | (C) | (D) | (E) | (F) | (D)
1 | Delivered Quantity | Input | 1068
 | Thoreau Quantity | Input
 | PPL Sale Price | Input | 2.53 |  |  | (Ln3D)
 | PG&E Index | Input | 3.04
 | Discount | Input | 0.1
 | San Juan Index | Input | 2.465 |  |  | (Ln11F-Ln10F-Ln9F-Ln8F)
 | Delivered Cost
 | SJ Fuel | MainSheet |  |  |  | ((Ln11F-Ln10F-Ln9F)-((Ln11F-Ln10F-Ln9F)*(1-SJFuel))
 | SJ Lateral Demand | MainSheet |  |  |  | (Ln9D)
 | SJ Commodity | MainSheet |  |  |  | (Ln10D)
 | Thoreau Del. Cost |  |  |  |  | (Ln14F-Ln13F-Ln12F)
 | Mainline Fuel | MainSheet |  |  |  | ((Ln14F-Ln13F)-((Ln14F-Ln13F)*(1-MLFuel))
 | Mainline Commodity | MainSheet |  |  |  | (Ln13D)
 | Total |  |  |  |  | (Ln14D+Ln32E)
 | PPL Price | (Ln4-Ln5)
 | Delivered Cost | ([NAME])
 | Spread | (LN17-Ln18)
 | Enron Margin/Brokering | (Ln19*.085)
 | Citizens Margin | (Ln19-Ln20)
 | Enron Margin/Brokering ($) | (Ln1-Ln20)
 | Citizens Margin ($) | (Ln1*Ln21)
 | Total Margin | ([NAME])
 | Delivered Cost | (Ln1*Ln18)
 | Revenue | (Ln24+Ln25)
 | Revenue Check | MainSheet
 | Negotiated Deal Value | (Ln26E-Ln26D)
 | 50/50 Sharing | (Ln30E*.50)
 | Gas Cost Adjusted Rate | (Ln31E/Ln1D)-((Ln31E*.085)/Ln1D)
 | Desired Sharing
 | Enron | (Ln22D+Ln31E)
 | Citizens | (Ln23D+Ln31E)
 |  | Check To (Ln24E)
Spreadsheet: 54477d1254466375-text-together-with-auto-numbering-revas-template12
Sheet: Template

 |  | SEMESTRAL STUDENT PROJECT SUBMISSION
 | Project  'x' | Go to Main page contents
 | Supervisor:
 | Title:
 | Objective:
 | No. of Students: |  |  |  |  |  | 1
 | Budget: |  |  |  |  |  | 2
 | Abstract : |  |  |  |  |  | 3
 | Catergory: MB/PS/FS |  |  |  |  |  | 4 | MB
 | Special Requirement: |  |  |  |  |  | 5 | PS
 |  |  |  |  |  |  | 6 | FS
 | Component/Material Requirement:
 | S/N | Description | Estimated Unit Price | Quantity | Total Price ($)
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 |  |  |  | Grand Total:
 | Endorsed by: | _______________________________ | _____________________
 |  |  | Name and signature of MC
 |  |  | Date:
Spreadsheet: 39a4ce46-aff1-4eb4-b5cd-cb9f5041ead0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-04-08 09:26:51.900000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5.25 | 101.57 | 101.32 | 101.195 | 100.82 |  | and are added to price quote
5.125 | 100.55 | 100.3 | 100.175 | 99.8
5 | 100.112 | 99.862 | 99.737 | 99.362 |  | Note: | Refer To Price [NAME]
4.875 | 99.619 | 99.369 | 99.244 | 98.869 |  |  | For all Price Adjs
4.75 | 98.599 | 98.349 | 98.224
4.625 | 97.273 | 97.023 | 96.898
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.5 | 101.282 | 101.032 | 100.907 | 100.532
4.375 | 100.892 | 100.642 | 100.517 | 100.142
4.25 | 100.318 | 100.068 | 99.943 | 99.568
4.125 | 99.006 | 98.756 | 98.631 | 98.256
4 | 98.661 | 98.411 | 98.286
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-04-22 09:26:51.900000
30 DAY | 2011-05-07 09:26:51.900000
45 DAY | 2011-05-22 09:26:51.900000
60 DAY | 2011-06-06 09:26:51.900000
90 DAY | 2011-07-06 09:26:51.900000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 112275d1308389311-excel-2007-help-with-prices-of-ingredients-used-recipe-calculator-spreadsheet-copy
Sheet: Recipe Calculator - Recipe Calc

INGREDIENT | RECIPE |  | COST PER UNIT |  | COST FOR RECIPE
Baking Butter |  | [NAME] | 0.26 | [NAME] | 0
S/R Flour |  | Kg | 0.01 | Kg | 0
Plain Flour |  | Kg | 0.01625 | Kg | 0
[NAME] |  | Kg | 0.3513043478260869 | Kg | 0
Castor Sugar |  | Kg | 0.1628571428571428 | Kg | 0
Sugar |  | [NAME] | 0 | [NAME] | 0
Icing Sugar |  | [NAME] | 0.00099 | [NAME] | 0
Butter |  | [NAME] | 0.05789473684210527 | [NAME] | 0
Vanilla Extract |  | ml | 0.03894736842105263 | ml | 0
SugarPaste |  | Kg | 0.1052631578947368 | Kg | 0
Jam |  | [NAME] | 0.01526315789473684 | [NAME] | 0
 |  | [NAME] | 0.1425 | [NAME] | 0
 |  | [NAME] | 0.0374375 | [NAME] | 0
 |  | [NAME] | 0.186875 | [NAME] | 0
 |  | [NAME] | 0.02072916666666667 | [NAME] | 0
 |  | [NAME] | 0.007458333333333333 | [NAME] | 0
 |  | [NAME] | 0.5418181818181819 | [NAME] | 0
 |  | [NAME] | 0.07631578947368421 | [NAME] | 0
 |  | [NAME] | 0.01 | [NAME] | 0
 |  | [NAME] | 0.01 | [NAME] | 0
 |  | [NAME] | 0.01 | [NAME] | 0
 |  | [NAME] | 0.005682819383259912 | [NAME] | 0
 |  | [NAME] | 0.4425 | [NAME] | 0
 |  | [NAME] | 0.1257894736842105 | [NAME] | 0
 |  | [NAME] | 0.1658333333333333 | [NAME] | 0
 |  | [NAME] | 0.04983333333333333 | [NAME] | 0
 |  | [NAME] | 0.1466666666666667 | [NAME] | 0
TOTAL |  |  |  |  | 0
Spreadsheet: 47989d1247165235-row-column-matrix-data-to-row-only-for-database-import-690866_redwood_2007
Sheet: PT

Count of Value | Column
Row | [NAME] | Loc 3 | [NAME] | [NAME] 6 | Loc 7 | [NAME] 8 | [NAME] | Loc5 | Grand Total
8903134103103 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 8
8903134129103 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 | 7
8903134130109 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 8
8903134134107 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 8
8903134223108 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 8
8903134514008 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 7
8903134522102 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 | 7
8903134525004 | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | 7
8903134601104 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 8
8903134604136 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 8
8903134608134 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 8
8903134703006 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 8
8903134704003 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 8
8903134801009 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 8
Grand Total | 14 | 13 | 13 | 14 | 14 | 14 | 13 | 13 | 108
Spreadsheet: 4f4bcf5c-d563-46c1-9e4f-a5c44cd9c816
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Actual Enrollments for 1996-1997 through 2005-2006 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
 |  |  |  |  |  |  |  | Estimates for 2006-2007 through 2010-2011
 |  |  |  |  |  |  |  | NONPUBLIC SCHOOL ENROLLMENTS-STATE
 | Year | K | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Total
 | 1996-1997 | 4096 | 4091 | 4106 | 4019 | 3799 | 3992 | 3907 | 3268 | 3187 | 2564 | 2500 | 2470 | 2303 | 44302
 | 1997-1998 | 3943 | 4122 | 4053 | 4030 | 3872 | 3726 | 3834 | 3199 | 3087 | 2408 | 2445 | 2345 | 2353 | 43417
 | 1998-1999 | 3935 | 3976 | 4027 | 3916 | 3988 | 3733 | 3593 | 3139 | 3084 | 2327 | 2339 | 2400 | 2301 | 42758
 | 1999-2000 | 3888 | 3901 | 3873 | 3904 | 3833 | 3812 | 3599 | 3064 | 3110 | 2349 | 2279 | 2310 | 2358 | 42280
 | 2000-2001 | 3870 | 3852 | 3824 | 3728 | 3782 | 3674 | 3620 | 2955 | 2862 | 2213 | 2257 | 2197 | 2230 | 41064
 | 2001-2002 | 3705 | 3724 | 3747 | 3683 | 3579 | 3639 | 3449 | 2920 | 2849 | 2168 | 2131 | 2143 | 2144 | 39881
 | 2002-2003 | 3585 | 3637 | 3614 | 3595 | 3518 | 3419 | 3452 | 2811 | 2861 | 2169 | 2100 | 2100 | 2137 | 38998
 | 2003-2004 | 3298 | 3417 | 3501 | 3453 | 3462 | 3381 | 3227 | 2755 | 2679 | 1986 | 2059 | 1987 | 2038 | 37243
 | 2004-2005 | 3251 | 3261 | 3319 | 3374 | 3325 | 3348 | 3205 | 2571 | 2629 | 1984 | 1934 | 2000 | 1960 | 36161
 | 2005-2006 | 3231 | 3159 | 3193 | 3187 | 3246 | 3230 | 3087 | 2579 | 2496 | 2013 | 1947 | 1902 | 1980 | 35250
 |  |  |  |  |  |  |  | PROJECTED ENROLLMENTS
 | 2006-2007 | 3325 | 3257 | 3071 | 3066 | 3064 | 3134 | 3030 | 2478 | 2485 | 1856 | 1953 | 1890 | 1874 | 34483
 | 2007-2008 | 3358 | 3236 | 3166 | 2949 | 2948 | 2958 | 2940 | 2432 | 2388 | 1848 | 1800 | 1896 | 1862 | 33781
 | 2008-2009 | 3389 | 3268 | 3146 | 3040 | 2835 | 2846 | 2775 | 2360 | 2343 | 1776 | 1793 | 1747 | 1868 | 33186
 | 2009-2010 | 3376 | 3298 | 3177 | 3021 | 2923 | 2737 | 2669 | 2228 | 2274 | 1742 | 1723 | 1741 | 1721 | 32630
 | 2010-2011 | 3361 | 3286 | 3206 | 3051 | 2904 | 2822 | 2567 | 2143 | 2147 | 1691 | 1690 | 1673 | 1715 | 32256
 | All enrollments are as of the third Friday in September.  The nonpublic school enrollment projections are based upon trends observed in the
 | number of students moving from grade to grade.  The trend, calculated as an average cohort survival ratio, was used to estimate enrollments
 | for first through twelfth grade.  [NAME] enrollments were estimated from an average ratio of kindergarten enrollments to the cohort
 | born five years prior.
Spreadsheet: 95427d1295017990-duplicate-checking-of-two-big-tables-example
Sheet: Sheet1

Campaign | number 1 | number 2 | number 3
Neptune
Oceania
Ambella Home
Mitrani
Forms and Fixtures
[NAME]
Hoesch
[NAME]
[NAME]
Victoria & Albert
Hydro Systems
WET
High Point
Toto
Altmans
Adagio
Dornbracht
Aquabrass
[NAME]
Grohe
Hastings
Watermark
Hitchcock-Butterfield
French Reflection
Century
Americh
Alcove
St. Thomas
[NAME]
Wave
DVontz
Newport Brass
Vola
Italbrass
Mountain Plumbing
WS Bath Collection
Terra Acqua
Linkasink
Bissonnet
[NAME]
Suneli
Native Trails
The Allstone Group
Aviana
[NAME]
[NAME]
VitaBath
Scarabeo
Kindred
Vigo
Baci By Remcraft
Jado
Insinkerator
Cool Lines
Eago
ShowHouse by Moen
[NAME]
Thompson Traders
Deca
[NAME] and Boch
Kalco Lighting
Neo-Metro
[NAME]
[NAME]
Norwell Lighting
[NAME]
Triarch International
Westbrass
Amerec
Barber Wilsons
Danze
Alno
Bathroom_nextag
Brondell
ELK Lighting
Sonoma Forge
Steamist
[NAME]
Wesaunard
Linnea
Palmer Industries
ProSun
[NAME]
AstraCast
[NAME]
Black Country Heritage
Flos
Hamat
[NAME]
Roma
Satinjet
Vipp
Artistic Lighting
[NAME]
Webert
Zucchetti
Clearwater
Cropusa
Remcraft
Fairmont
Wilshire
Aqua Health
[NAME]
MGS Designs
Rachiele
[NAME]
World Imports
(not set)
Anne At Home
JVJ Hardware
Livex Lighting
Moda
Schaub & Company
[NAME]
Vibia
Classic Hardware
First Impressions
Horus
Richelieu
MTI
[NAME]
Maax
Duravit
[NAME]
Arteriors
Aquatic
Elite Bath
Indocraft
Xylem
Rubinet
Empire
Jacuzzi
[NAME]
Barclay
Fairmont Designs
[NAME]
[NAME]
Sonia
GS North America
Santec
Hansgrohe
Latoscana
Elkay
Sierra Copper
Graff
Julien
Quality Bath
Jaclo
Cole & Co.
DreamLine
Robern
Runtal Radiators
Windisch
Herbeau
Artos
Valsan
Nameeks
Blanco
American Standard
Oceana
Cifial
Sigma
Whitehaus
AF Lighting
Afina
Dainolite
Ginger
[NAME]
Cantrio
Saniflo
Rohl
California Faucets
Golden Lighting
Mr Steam
Kimball & Young
[NAME]
Smedbo
Amba
KWC
Lenova
ThermaSol
Cascade
Waterstone
Bates
[NAME]
Trend
Fluid
Decotec
Strasser????
StrasserŠz(K
Trend
Spreadsheet: 847941d1698776987-formula-to-capture-attendance-login-shift-adherence
Sheet: Login Logout Data

Agent Name | Agent ID | Split/Skill | Date | [NAME] | Logout Time | Off Hours (Calculated)
A | 1234 | 1981 | 2023-09-27 00:00:00 | 10:20:00 | 17:34:00
A | 1234 | 1981 | 2023-09-27 00:00:00 | 17:59:00 | 18:32:00
A | 1234 | 1981 | 2023-09-27 00:00:00 | 18:32:00 | 20:32:00
B | 4567 | 2015 | 2023-09-27 00:00:00 | 12:07:00 | 15:25:00
B | 4567 | 1986 | 2023-09-27 00:00:00 | 16:35:00 | 18:42:00
B | 4567 | 2015 | 2023-09-27 00:00:00 | 19:09:00 | 19:11:00
C | 2345 | 1982 | 2023-09-27 00:00:00 | 17:41:00 | 19:39:00
C | 2345 | 1982 | 2023-09-27 00:00:00 | 19:41:00 | 21:55:54
C | 2345 | 1983 | 2023-09-27 00:00:00 | 22:41:58 | 02:30:00
D | 6789 | 1984 | 2023-09-27 00:00:00 | 10:24:00 | 14:01:58
D | 6789 | 1985 | 2023-09-27 00:00:00 | 15:35:32 | 17:45:00
D | 6789 | 1981 | 2023-09-27 00:00:00 | 18:53:28 | 20:42:00
E | 1000 | 1982 | 2023-09-27 00:00:00 | 10:28:00 | 11:42:18
E | 1000 | 1982 | 2023-09-27 00:00:00 | 13:35:00 | 17:50:00
E | 1000 | 1982 | 2023-09-27 00:00:00 | 18:23:00 | 22:44:00
Spreadsheet: 90693d1290466949-comparing-2-columns-and-then-moving-a-third-data-point-if-2-other-data-points-match-get-id
Sheet: Sheet1

Customer First Name | Customer Last Name | Unique ID#
FName26 | [NAME] | 26
FName20 | LName20 | 20
FName7 | LName7 | 7
FName17 | LName17 | 17
FName30 | LName30 | 30
FName27 | LName27 | 27
FName9 | LName9 | 9
FName3 | LName3 | 3
FName29 | LName29 | 29
FName22 | LName22 | 22
FName2 | LName2 | 2
FName11 | [NAME] | 11
FName10 | [NAME] | 10
FName24 | LName24 | 24
FName19 | LName19 | 19
FName6 | LName6 | 6
FName23 | LName23 | 23
FName21 | [NAME] | 21
FName16 | LName16 | 16
FName28 | LName28 | 28
FName12 | LName12 | 12
FName5 | LName5 | 5
FName1 | LName1 | 1
FName13 | LName13 | 13
FName15 | LName15 | 15
FName14 | [NAME] | 14
FName8 | [NAME] | 8
FName4 | LName4 | 4
FName25 | LName25 | 25
FName18 | [NAME] | 18
Spreadsheet: 688724d1595928306-index-match-error-july-2019-salary-bureau-x
Sheet: Month

Employee | Timesheet Hours | Holiday Hours
[NAME]
Julia Wood
[NAME]
[NAME]
Cornel Petran
[NAME]
[NAME]
Rafal Krzak
[NAME]
[NAME]
Agatha Caesley
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Olivia Whiting
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Adam Parkinson
[NAME]
[NAME]
[NAME]
[NAME]
Heather James
[NAME]
[NAME]
Spreadsheet: 0d80c19d-1331-48f2-bc2d-6ef996626c3a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-01-19 09:49:33.040000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5.25 | 101.5 | 101.5 | 101.375 | 100.875 |  | and are added to price quote
5.125 | 100.962 | 100.962 | 100.837 | 100.337
5 | 100.611 | 100.611 | 100.486 | 99.98599999999999 |  | Note: | Refer To Price [NAME]
4.875 | 99.774 | 99.774 | 99.649 | 99.149 |  |  | For all Price Adjs
4.75 | 99.223 | 99.223 | 99.098
4.625 | 98.10799999999999 | 98.10799999999999 | 97.98299999999999
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.625 | 101.457 | 101.457 | 101.332 | 100.832
4.5 | 101.266 | 101.266 | 101.141 | 100.641
4.375 | 100.983 | 100.983 | 100.858 | 100.358
4.25 | 100.498 | 100.498 | 100.373 | 99.87299999999999
4.125 | 99.012 | 99.012 | 98.887
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-01-19 09:49:33.040000
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-02-02 09:49:33.040000
30 DAY | 2011-02-17 09:49:33.040000
45 DAY | 2011-03-04 09:49:33.040000
60 DAY | 2011-03-19 09:49:33.040000
90 DAY | 2011-04-18 09:49:33.040000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 866183d1713162290-finding-partial-match-in-databse-with-filter-and-xloopup-testsheet-database-v3-aligw
Sheet: Sheet1

 | Explanation
 | In Range B7:B9 you can select a filter (list) you want to use as filter. In this case either Hobbies or Interests.
 | In range C7:C9 you can type in which hobby or interest you are looking for. |  |  |  |  | FILTER(Database!N2:CW2;(XLOOKUP(B$5;Database!M1:CW1;Database!M2:CW2)=C5)
 | Filter (list) | Criteria (freefill) |  | Name | Hobby_1 | Hobby_2 | Hobby_List | Interest_List |  | All_Hobbies | All_Interests
 | Hobby_List | Bowling |  | [NAME] | Tennis | Hockey |  | Reading |  | Tennis | Reading
 | Interest_List | Walking |  | [NAME] | Bowling | n/a |  | Bowling |  | Bowling | Bowling
 |  |  |  | [NAME] | n/a | n/a |  | Traveling |  | Baseball | Traveling
 |  |  |  | Rachel | Baseball | Bowling |  | Walking |  | Hockey | Walking
 |  |  |  |  |  |  |  |  |  | Darts
 | In the table below the people that meet all the requirement you are filtering for will pop-up. |  |  |  |  |  |  |  |  | n/a
 | Matches |  |  |  |  |  | '(XLOOKUP(B$5;Database!M1:CW1;Database!M2:CW2)=C5)
 | Name | Hobby_1 | Hobby_2 | Hobby_List | Interest_List
 |  | Bowling | n/a | Bowling n/a | Bowling |  |  | Bowling | n/a | Bowling n/a | Bowling
 | Rachel | Baseball | Bowling | Baseball Bowling | Walking |  | Rachel | Baseball | Bowling | Baseball Bowling | Walking
 |  |  |  |  |  |  | False
 |  |  |  |  |  |  | False
 | ISSUE: |  |  |  |  |  | False
 | The freefill values in C7:C9 need to be an EXACT (undesired) match with [NAME]:H9 instead of a PARTIAL (desired) match to have the people show up in the above table. Typing in 'Bowling n/a' in C7 will show [NAME].
 | GOAL:
 | Desired result when typing in 'Bowling; in C6: |  |  |  |  |  | =IF(AND(B5="";C5="");"Please use at least one filter.";IF(AND(B5<>"";C5="");"Please select a criteria for your filter.";FILTER(Database!N2:CW2;(XLOOKUP(B$5;Database!M1:CW1;Database!M2:CW2)=C5)*(XLOOKUP(B$6;Database!M1:CW1;Database!M2:CW2)=C6)*(XLOOKUP(B$7;Database!M1:CW1;Database!M2:CW2)=C7)*(XLOOKUP(B$8;Database!M1:CW1;Database!M2:CW2)=C8)*(XLOOKUP(B$9;Database!M1:CW1;Database!M2:CW2)=C9)*(XLOOKUP(B$10;Database!M1:CW1;Database!M2:CW2)=C10)*(XLOOKUP(B$11;Database!M1:CW1;Database!M2:CW2)=C11)*(XLOOKUP(B$12;Database!M1:CW1;Database!M2:CW2)=C12)*(XLOOKUP(B$13;Database!M1:CW1;Database!M2:CW2)=C13)*(XLOOKUP(B$14;Database!M1:CW1;Database!M2:CW2)=C14)*(XLOOKUP(B$15;Database!M1:CW1;Database!M2:CW2)=C15)*(XLOOKUP(B$16;Database!M1:CW1;Database!M2:CW2)=C16)*(XLOOKUP(B$17;Database!M1:CW1;Database!M2:CW2)=C17)*(XLOOKUP(B$18;Database!M1:CW1;Database!M2:CW2)=C18)*(XLOOKUP(B$19;Database!M1:CW1;Database!M2:CW2)=C19)*(XLOOKUP(B$20;Database!M1:CW1;Database!M2:CW2)=C20)*(XLOOKUP(B$21;Database!M1:CW1;Database!M2:CW2)=C21)*(XLOOKUP(B$22;Database!M1:CW1;Database!M2:CW2)=C22)*(XLOOKUP(B$23;Database!M1:CW1;Database!M2:CW2)=C23);"No Influencers have been found that meet your criteria. Consider widening your filter selection.")))
 | Matches
 | Name | Hobby_1 | Hobby_2 | Hobby_List | Interest_List
 | [NAME] | Bowling | n/a | Bowling n/a | Bowling
 | Rachel | Bowling | Baseball |  | Walking
Spreadsheet: 680182d1590842832-index-match-for-less-than-match-type-index-match_match-type
Sheet: Sheet1

 |  | 2020-05-31 00:00:00 | 2020-04-30 00:00:00 | 2020-03-31 00:00:00 | 2020-02-29 00:00:00 | 2020-01-31 00:00:00
 | haha | 12 | 34 | 56 | 98 | 85
 | hehe | 78 | 89 | 910 | 54 | 52
 | hoho | 1112 | 1314 | 1516 | 321 | 63
Greather than
criteria 1 | haha
criteria 2 | 2020-04-01 00:00:00
Exact
criteria 1 | haha
criteria 2 | 2020-03-31 00:00:00
Less than
criteria 1 | haha
criteria 2 | 2020-03-30 00:00:00
Spreadsheet: 177c94e8-813a-4549-abe0-6aecbef97de9
Sheet: Sheet1

HASIL UJIAN ULANG 1 s.d 12, [NAME] s.d 3 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
No | [NAME] | Nama | Instansi | [NAME] | Propinsi | Bidang Studi | Status PLPG
1 | 11031622710546 | SRI SUMARNI | SMP N 1 KUNDURAN | Kab. Blora | JAWA TENGAH | Keterampilan | LULUS
2 | 11031622710522 | DIAH MINTANINGRUM | SMP N 1 RANDUBLATUNG | Kab. Blora | JAWA TENGAH | Keterampilan | LULUS
3 | 11031622710530 | NINUK EKWIYATI NOOR | SMP N 1 JIKEN | Kab. Blora | JAWA TENGAH | Keterampilan | LULUS
4 | 11031622710558 | PRANTININGSIH | SMP MUHAMMADIYAH 2 KEDUNGTUBAN | Kab. Blora | JAWA TENGAH | Keterampilan | TIDAK LULUS
5 | 11031622710560 | SRI NURHAYATI | SMP MUHAMMADIYAH 1 KRADENAN | Kab. Blora | JAWA TENGAH | Keterampilan | TIDAK LULUS