tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 112857d1308837433-vlooklup-problem-book4
Sheet: wkbk1

ISBN | Gross | Returns | Net | Stock
276421914 | 25 |  |  | 100 |  | Because this number is here three times I get the duplicate answers when I only want one.
276421914 |  | -1 |  | 100
276421914 |  |  | 26 | 100
276425030 |  |  |  | 200
276425030 |  |  |  | 200
276425049 |  |  |  | 300
276425049 |  |  |  | 300
276425057 |  |  |  | 400
276425057 |  |  |  | 400
276425065 |  |  |  | 700
276425065 |  |  |  | 700
276425073 |  |  |  | 800
276425634 |  |  |  | 1000
276425634 |  |  |  | 1000
276426207 |  |  |  | 1000
276426894 |  |  |  | 1000
Spreadsheet: louise_kitchen__24044__Natural Gas Consolidated
Sheet: Texas Origination

 |  | 2001-09-01 00:00:00 |  | 2001-09-01 00:00:00 |  | %
 |  | YTD Actual |  | Annualized |  | of Total
ENACOMP | Compensation
 | Special Pays
 | Analyst & Associate | 24000
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions
ENARENT | Rent
ENATECH | Technology
ENATRANS | Transportation
ENAOTHEX | Other Expenses
ENATAXES | Taxes Other than Income
ENATOTDR | Total Direct Expenses
 | Headcount |  |  | 1
 | Analyst & Associate Headcount |  |  | 1
 | Total Headcount
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses
ENADEPR | Depreciation & Amortization
Spreadsheet: 69939d1270592809-auto-filling-information-expense-report-02
Sheet: Dept Codes

CC | COST CENTER NAME | GL SERIES
098 | IT SAP | 8
099 | IT Applications | 8
102 | Presidents Office | 8
103 | Building/General | 8
104 | Accounts Payable | 8
105 | Billing | 8
106 | HR, Payroll, Insurance | 8
107 | Finance & Accounting | 8
108 | IT Infrastructure | 8
109 | Credit Collections, Cash Apps | 8
110 | Procurement | 8
112 | US Marketing | 8
113 | RM Sales | 8
120 | Aggregate Sales | 8
130 | General [NAME] | 8
130 | General [NAME] | 8
200 | Security | 6
201 | Safety | 6
202 | Quality Control | 6
202 | Quality Control | 6
203 | Environmental | 6
205 | Logistics | 6
300 | Fleet Maintenance | 6
301 | Fleet [NAME] | 6
302 | Fixed Delivery | 6
400 | Plant Maintenance | 6
401 | Plant [NAME] | 6
402 | Fixed Plant | 6
500 | [NAME] R&M | 5
501 | [NAME] Admin | 6
502 | Central Operations/Order Board | 6
504 | [NAME] | 6
520 | Agg Operations | 6
524 | Delivery | 6
525 | Agg Operation Admin | 6
525 | Yard Workers - HiLift -Bldg Material Admin | 6
526 | Dump Drivers - Misc. Drivers | 6
532 | Stripping | 6
Spreadsheet: 100679d1298974333-adding-up-cells-that-contain-specific-dates-pivot-example
Sheet: Example

 | Date | Value
 | 2011-01-01 00:00:00 | 10 |  |  | Sum of Value
 | 2011-01-08 00:00:00 | 12 |  |  | Years | Date | Total
 | 2011-01-15 00:00:00 | 14 |  |  | 2010 | Jan | 64
 | 2011-01-22 00:00:00 | 16 |  |  |  | Feb | 96
 | 2011-01-29 00:00:00 | 18 |  |  |  | Mar | 128
 | 2011-02-05 00:00:00 | 20 |  |  |  | Apr | 37
 | 2011-02-12 00:00:00 | 22 |  |  | 2011 | Jan | 70
 | 2011-02-19 00:00:00 | 24 |  |  |  | Feb | 92
 | 2011-02-26 00:00:00 | 26 |  |  |  | Mar | 124
 | 2011-03-05 00:00:00 | 28 |  |  | Grand Total |  | 611
 | 2011-03-12 00:00:00 | 30
 | 2011-03-19 00:00:00 | 32
 | 2011-03-26 00:00:00 | 34
 | 2010-01-08 00:00:00 | 13
 | 2010-01-15 00:00:00 | 15
 | 2010-01-22 00:00:00 | 17
 | 2010-01-29 00:00:00 | 19
 | 2010-02-05 00:00:00 | 21
 | 2010-02-12 00:00:00 | 23
 | 2010-02-19 00:00:00 | 25
 | 2010-02-26 00:00:00 | 27
 | 2010-03-05 00:00:00 | 29
 | 2010-03-12 00:00:00 | 31
 | 2010-03-19 00:00:00 | 33
 | 2010-03-26 00:00:00 | 35
 | 2010-04-02 00:00:00 | 37
Spreadsheet: 61820d1262732829-multiple-if-statements-sales-david-morin-01-2010
Sheet: conversion

3mb | 4
5mb | 8
10mb | 10
15mb | 12
20mb | 14
unlimited | 8
all maine | 6
standard | 5
basic | 4
[NAME] | 2
Spreadsheet: 882528d1730912728-sum-forumla-not-working-sum-cell-not-correct
Sheet: Sheet1

 | Small parcel pick up |  | Unit Qty | Items per  unit | Units Per Case | Total Cases Being Sent | Item Total | Shirts | Pants | Widget 3 | Widget 4 | Widget 5
 | 1 | Shirts | 48
 | 2 | Shirts 2 pack | 8
 | 3 | Shirts and pants | 9
 | 4 | Hat | 10
 | 9 | Pants | 5
 | 10 | pallet
 |  | Sub
Spreadsheet: 772159d1647025078-tallying-multiple-worksheets-sample
Sheet: Item 3

Part # | Part | Total required
56-146 | chassis a | 200
56-159 | front wall | 200
56-155 | back wall | 200
56-933 | header a | 200
56-346 | wheels locking | 800
56-778 | graphic panels | 1000
Spreadsheet: 153874d1336075804-excel-2007-countifs-using-variable-to-identify-column-referenced-countifs-from-rangev2
Sheet: Data OLD

 | Completion Day |  |  |  |  | system impacts
 | Mon | [NAME] | Wed | Thurs | Fri | system 1 | system 2 | system 3 | system 4 | system 5 | system 6 | system 7 | system 8 | system 9 | system 10
feature 1 | x |  |  |  |  | H |  | M
feature 2 |  |  | x |  |  |  |  | H
feature 3 |  | x |  |  |  |  |  | H | H
feature 4 |  |  |  |  | x |  | L
feature 5 |  |  |  | x |  |  |  |  |  | H |  | M
feature 6 |  | x |  |  |  | H | M | M |  |  | M | M
feature 7 |  |  | x |  |  |  | H | H |  |  | H | H
feature 8 |  | x |  |  |  |  | H | H | H |  | H | H
feature 9 | x |  |  |  |  |  | L
feature 10 | x |  |  |  |  |  |  |  |  | H |  | M
 |  |  | Working [NAME]
 |  |  |  | system 5 | system 3 | system 7 | << Data Validation list
 |  |  | Mon
 |  |  | [NAME] | * |  |  |  | *this cell should count if the there is a value in the column matching E19 and if there is a value in the [NAME] column
 |  |  | Wed
 |  |  | Thurs
 |  |  | Fri
 |  |  | total
Spreadsheet: 6427f158-5c54-484f-9afe-3bd8e4dfe47f
Sheet: Pembuka

 | Kepada seluruh PTK IPA di seluruh wilayah Indonesia
 | PPPPTK [NAME] menyediakan diklat online bagi PTK [NAME], SMP, dan SMA.   Daftar secara online [NAME] email ke [EMAIL] [NAME] [NAME] anda [NAME] program diklat online PPPPTK IPA.
 | Berikut [NAME] pengisian file data peserta.
 | 1. [NAME] sheet Tata-Tertib
 | 2. [NAME] anda [NAME], maka [NAME] sheet Data-Diri
 | 3. [NAME] anda ada dalam [NAME] (KKG/MGMP), maka isi sheet Data-Kelompok
 | 4. Isi sheet Pernyataan, Masukan Kode Diklat (Sesuaikan dengan sheet Daftar-Diklat)
 | 5. [NAME] berkelompok, pernyataan dibuat sebanyak peserta pada kelompok (copy sheet Pernyataan)
 | 6. [NAME] mengisi data peserta, Rename file data-peserta.xlsx ini dengan ketentuan:
 | [NAME] file : NamaJelas.xlsx
 | Contoh : YOKI ARIYANA, Maka nama file : yoki_ariyana.xlsx
 | Contoh : MGMP SEKAR WANGI I, Maka nama file : mgmp_sekarwangi1.xlsx
 | CATATAN PENTING
 | 1. Diklat Online angakatan I akan dilaksanakan awal Oktober 2013.
 | 2. Pendaftaran diterima Paling lambat Tanggal 30 September 2013.
 | 3. [NAME] pendaftaran terlambat, akan disertakan pada batch selanjutnya.
 | 4. Kirim data anda ke [EMAIL] secepatnya.
 |  | Bandung, 23 September 2013
 |  | Tertanda,
 |  | Administrator
 |  | Diklat Online PPPPTK IPA - Bandung
Spreadsheet: 05003781-c09e-40ff-afec-4ee51536c6e5
Sheet: Sheet1

CITY OF RIO RANCHO, NM INFRASTRUCTURE AND CAPITAL IMPROVEMENT PLAN (ICIP) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
TABLE OF CONTENTS
EXECUTIVE SUMMARY AND GOVERNING BODY RESOLUTION (TAB 1)
 | City Manager's Message |  |  |  | 1
 | ICIP Allocation Summary |  |  |  | 13
 | ICIP Financing Summary |  |  |  | 14
 | Resolution No. 55 , Enactment No. 11-054 |  |  |  | 15
GENERAL GOVERNMENT AND OTHER DEPARTMENTS (TAB 2)
 | ICIP Summary-Table |  |  |  | 37
 | Financing Summary-Graph |  |  |  | 38
 | Individual Project Worksheets |  |  |  | 39
 | Past Results and Accomplishments |  |  |  | 42
POLICE (TAB 3)
 | ICIP Summary-Table |  |  |  | 43
 | Financing Summary-Graph |  |  |  | 44
 | Individual Project Worksheets |  |  |  | 45
 | Past Results and Accomplishments |  |  |  | 52
FIRE AND RESCUE (TAB 4)
 | ICIP Summary-Table |  |  |  | 53
 | Financing Summary-Graph |  |  |  | 54
 | Individual Project Worksheets |  |  |  | 55
 | Past Results and Accomplishments |  |  |  | 67
PARKS, RECREATION, AND COMMUNITY SERVICES (TAB 5)
 | ICIP Summary-Table |  |  |  | 69
 | Financing Summary-Graph |  |  |  | 73
 | Individual Project Worksheets |  |  |  | 75
 | Past Results and Accomplishments |  |  |  | 89
DRAINAGE (TAB 6)
 | ICIP Summary-Table |  |  |  | 95
 | Financing Summary-Graph |  |  |  | 98
 | Individual Project Worksheets |  |  |  | 99
 | Past Results and Accomplishments |  |  |  | 109
TRANSPORTATION (TAB 7)
 | ICIP Summary-Table |  |  |  | 113
 | Financing Summary-Graph |  |  |  | 120
 | Individual Project Worksheets |  |  |  | 121
 | Past Results and Accomplishments |  |  |  | 137
UTILITY-WATER (TAB 8)
 | ICIP Summary-Table |  |  |  | 143
 | Financing Summary-Graph |  |  |  | 146
 | Individual Project Worksheets |  |  |  | 147
 | Past Results and Accomplishments |  |  |  | 167
UTILITY-WASTEWATER (TAB 9)
 | ICIP Summary-Table |  |  |  | 175
 | Financing Summary-Graph |  |  |  | 178
 | Individual Project Worksheets |  |  |  | 179
 | Past Results and Accomplishments |  |  |  | 203
ICIP POLICY ([NAME] 10)
 | City's ICIP Policy Document |  |  |  | 205
IFCIP POLICY AND PLAN FY2012-2017 (TAB 11)
 | City's IFCIP Policy Document |  |  |  | 211
 | IFCIP for FY2012-2017 |  |  |  | 217
Spreadsheet: 694123d1599374524-extract-unique-values-from-across-column-p2-r10-count_exact_now_unique
Sheet: Sheet2

 | Head-0 | [NAME] | Head2 | Head3 | Head4 | Head5 | Head6 | [NAME] | Head8 | Head9 | Head10 | Head11 | Head12 | Head13 | Unique-1 | Unique-2 | Unique-3 | Uni-1 | Uni-2 | Uni-3 | Uni-4 | Uni-5 | Total
1
2
3
4
5
6
7
8
9
Spreadsheet: 148899d1333609023-copy-to-next-sheet-test-3
Sheet: P

 |  |  |  | SEEB
 |  |  |  |  |  |  |  | 2009-08-30 00:00:00
Foreign Currency A/c
 |  |  | SEK
TND |  |  | KRW
TRY |  |  | ZAR |  |  | AED | 0 | 0
JOD |  |  | THB |  |  | USD | 0 | 0
MYR |  |  | BHD |  |  | INR
SYP |  |  | KWD |  |  | PRS
MAD |  |  | QAR |  |  | SAR
IDR |  |  | EGP |  |  | BDT
SGD |  |  | IRR |  |  | GBP
AUD |  |  | [NAME] |  |  | EUR
CHF |  |  | DKK |  |  | BND
CAD |  |  | LKR |  |  | NPR
NZD |  |  | HKD |  |  | TZS
PHP |  |  | YER |  |  | CNY
 |  |  |  |  |  |  |  | 0
 | Cash on Hand A/c
Spreadsheet: 168951d1342637796-vlookup-using-multiple-table_array-vlookup2
Sheet: Sheet3

plu | old plu | ean | Article Description | $ | Code | Descript | $
10000 | 3033 | 1203598722 | SHANDAR VANILLA CAKE MC-28855 | 1111 | 10000 | SHANDAR VANILLA CAKE MC-28855 | 1111
10001 | 1009 | 9300000000000 | KRAFT SINGLES CHEESE 12S 250G | 2222 | 3033 | #N/A | #N/A
10002 | 1010 | 1010203687 | KRAFT FREE SINGLES CHEESE 250 PKT | 3333 | 1203598722 | #N/A | #N/A
10003 | 10331 | 935555475211 | GOLDEN CHURN SALTED BUTTER 227G | 4444 |  |  | #N/A
10004 | 10774 | 88029361145 | AGORA FRUITS BASKET LARGE | 5555 |  |  | #N/A
10005 | 10785 | 172573214 | AGORA FRESH MANGO JUICE/GLASS | 6666 |  |  | #N/A
10006 | 10788 | 107889985 | AGORA FRESH FRUIT JUICE/GLASS | 7777
 | Cell F4 to F10 are where I'd enter any code (which are stored in cell A4:C10)
 | Using this VLOOKUP formula (=VLOOKUP(F4,$A$4:$D$10,4,FALSE) only match code from A4 to A10 cells but I need the formula to look and match in from A4:C10 cells.
 | If I enter any digits from A4 to A10 then this formula: =VLOOKUP(F4,$A$4:$D$10,4,FALSE)  works but wont look into B or C columns
Spreadsheet: 102268d1300228525-random-item-number-equals-correct-price-using2010
Sheet: Estimate Detail

ESTIMATE
 |  |  |  |  |  |  | Date:
Contractor: | LaMorinda Tile and Stone |  |  | Job Name:
Address: | 2261 Commerce Ave., Suite B |  |  | Address:
City: | Concord, CA 94520 |  |  | City:
Phone: | [PHONE] |  |  | Phone:
Fax : | [PHONE] |  |  | Fax:
[NAME]: | [EMAIL] |  |  | [NAME]:
Detail of Work
Item | Description of Job |  |  |  |  | Quantity | Price EA | Price
 | Templates, Fabrication, & Installation
 | Under Mount Sink Cut Out And Polished
 | Laminated Edge Detail:
 | Faucet Holes/ Air Switch Cut Outs
 | Application Of Sealer
 | Application of Caulking
 |  |  |  |  |  |  | Total:
LMTS offers a two year warranty on the seams of our countertops. This warranty covers seam separation for two years from the date of installation.
LMTS provides a one year warranty from the day of installation on staining. This is based upon normal use of the granite.
The customer is responsible for maintaining the sealer at least once per year, and for caulking maintenance.
Warranties will become void if proper maintenance is not performed by customer.
LMTS will not warranty against breakage after installation.
 | Accepted by:
 | Client |  |  |  |  | Date
Spreadsheet: 661c14ec-3fa2-45fa-b1df-bc6847cb385b
Sheet: Sheet1

>FTL226 | Unnamed: 1 | Unnamed: 2
GCAGUUCGGCGGUCCCGCGGGUCUGUCUCUUGCUUCAACAGUGUUUGGACGGAACAGAUCCGGGGACUCUCUUCCAGCCUCCGACCGCCCUCCGAUUUCCUCUCCGCUUGCAACCUCCGGGACCAUCUUCUCGGCCAUCUCCUGCUUCUGGGACCUGCCAGCACCGUUUUUGUGGUUAGCUCCUUCUUGCCAACCAACCAUGAGCUCCCAGAUUCGUCAGAAUUAU
G4A | eSDC | 0.726648614527217
C10U | eSDC | 0.549997636912758
C14G | eSDC | 0.681349652003068
G17C | eSDC | 1.13950210095934
U22G | eSDC | 2.28622774227542
U22G.G17C | eSDC | 0.948576568357745
U22G.A58C | eSDC | 1.27307789216927
U22G.A58U | eSDC | 0.591821466703581
U22G.A196G | eSDC | 2.69930409016344
A56U | eSDC | 0.727942284316162
A58C | eSDC | 1.1019819053859
A58U | eSDC | 1.32430371446884
C90U | eSDC | 0.663378406861088
A196G | eSDC | 0.537803004193684
Spreadsheet: 21875d1210015009-common-denominator-example
Sheet: Sheet1

Product | Territory | Lang | Start | End |  | Start | End
Product 1 | Scenerio 1 | Type 1 | 2008-06-01 00:00:00 | 2008-06-30 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 1 | Scenerio 1 | Type 2 | 2008-01-01 00:00:00 | 2008-12-31 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 1 | Scenerio 2 | Type 1 | 2008-01-01 00:00:00 | 2008-06-30 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 1 | Scenerio 2 | Type 2 | 2008-01-01 00:00:00 | 2008-12-31 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 1 | Scenerio 3 | Type 1 | 2008-01-01 00:00:00 | 2008-06-30 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 1 | Scenerio 3 | Type 2 | 2008-01-01 00:00:00 | 2008-12-31 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 1 | Scenerio 4 | Type 1 | 2008-01-01 00:00:00 | 2008-06-30 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 1 | Scenerio 4 | Type 2 | 2008-01-01 00:00:00 | 2008-12-31 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 1 | Scenerio 5 | Type 1 | 2008-01-01 00:00:00 | 2008-06-30 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 1 | Scenerio 5 | Type 2 | 2008-01-01 00:00:00 | 2008-12-31 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 1 | Scenerio 6 | Type 1 | 2008-01-01 00:00:00 | 2008-06-30 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 1 | Scenerio 6 | Type 2 | 2009-01-01 00:00:00 | 2009-12-31 00:00:00 |  | 2009-01-01 00:00:00 | 2008-06-30 00:00:00
Product 2 | Scenerio 1 | Type 1 | 2008-06-01 00:00:00 | 2008-06-30 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 2 | Scenerio 1 | Type 2 | 2008-01-01 00:00:00 | 2008-12-31 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 2 | Scenerio 2 | Type 1 | 2008-01-01 00:00:00 | 2008-06-30 00:00:00 |  | 2008-01-01 00:00:00 | 2008-06-30 00:00:00
Product 2 | Scenerio 2 | Type 2 | 2008-01-01 00:00:00 | 2008-12-31 00:00:00 |  | 2008-01-01 00:00:00 | 2008-06-30 00:00:00
Product 2 | Scenerio 3 | Type 1 | 2008-01-01 00:00:00 | 2008-06-30 00:00:00 |  | 2008-01-01 00:00:00 | 2008-06-30 00:00:00
Product 2 | Scenerio 3 | Type 2 | 2008-01-01 00:00:00 | 2008-12-31 00:00:00 |  | 2008-01-01 00:00:00 | 2008-06-30 00:00:00
Product 2 | Scenerio 4 | Type 1 | 2008-01-01 00:00:00 | 2008-06-30 00:00:00 |  | 2008-01-01 00:00:00 | 2008-06-30 00:00:00
Product 2 | Scenerio 4 | Type 2 | 2008-01-01 00:00:00 | 2008-12-31 00:00:00 |  | 2008-01-01 00:00:00 | 2008-06-30 00:00:00
Product 2 | Scenerio 5 | Type 1 | 2008-01-01 00:00:00 | 2008-06-30 00:00:00 |  | 2008-01-01 00:00:00 | 2008-06-30 00:00:00
Product 2 | Scenerio 5 | Type 2 | 2008-01-01 00:00:00 | 2008-12-31 00:00:00 |  | 2008-01-01 00:00:00 | 2008-06-30 00:00:00
Product 2 | Scenerio 6 | Type 1 | 2008-01-01 00:00:00 | 2008-06-30 00:00:00 |  | 2008-01-01 00:00:00 | 2008-06-30 00:00:00
Product 2 | Scenerio 6 | Type 2 | 2009-01-01 00:00:00 | 2009-12-31 00:00:00 |  | 2009-01-01 00:00:00 | 2008-06-30 00:00:00
Spreadsheet: 125398d1319014529-help-with-timesheet-calculation-time
Sheet: Sheet1

Time Tracking |  |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
In
Lunch Out
Lunch In
Out
 | Time Worked
Spreadsheet: 120146d1315010023-populate-multiple-cells-w-unique-data-from-one-identifier-emilytest_emc
Sheet: Goal Scoring Worksheet

 | WORK SPACE |  |  | REFERENCE
 | Employee Name | EE1 |  | Past Performance Ratings
 | Employee ID |  |  | 2H FY11 | 1H FY11 | Focal FY11
 | Grade
 | GOAL COUNT & NAME |  |  | Hire Date
 |  | Score |  | SCORE DEFINIFTIONS
 |  |  |  | 1 = | FAR EXCEED GOAL
 |  |  |  | 1.5 = | EXCEED GOAL
 |  |  |  | 2 = | MET GOAL
 |  |  |  | 2.5 = | MET GOAL W/ ISSUE
 |  |  |  | 3 = | DID NOT MEET GOAL
 | Average Score
Spreadsheet: 795618d1662802727-calculate-average-but-exclude-weekend-and-public-holiday-book1-hd-4-
Sheet: Cal

 | Feb | Day | Total
 | 2022-02-01 00:00:00 |  | 5 |  |  | Date | Day
 |  |  | 4 |  |  | 2022-01-01 00:00:00 | Saturday
 |  |  | 5 |  |  | 2022-02-01 00:00:00 | Tuesday
 |  |  | 4 |  |  | 2022-02-02 00:00:00 | Wednesday
 |  |  | 5 |  |  | 2022-04-15 00:00:00 | Friday
 |  |  | 6 |  |  | 2022-05-01 00:00:00 | Sunday
 |  |  | 7 |  |  | 2022-05-03 00:00:00 | Tuesday
 |  |  | 8 |  |  | 2022-05-15 00:00:00 | Sunday
 |  |  | 3 |  |  | 2022-07-10 00:00:00 | Sunday
 |  |  | 5 |  |  | 2022-10-24 00:00:00 | Monday
 |  |  | 6 |  |  | 2022-12-25 00:00:00 | Sunday
 |  |  | 7
 |  |  | 8
 |  |  | 9
 |  |  | 3
 |  |  | 6
 |  |  | 8
 |  |  | 3
 |  |  | 6
 |  |  | 9
 |  |  | 5
 |  |  | 1
 |  |  | 4
 |  |  | 6
 |  |  | 7
 |  |  | 4
 |  |  | 3
 |  |  | 2
 |  |  | 5
 |  |  | 7
 |  |  | 8
 | Ave/mth |  |  |  |  | Solution for Excel users 365/2021
 |  |  |  |  |  | Solution for all Excel users (confirm formula with CTRL+SHIFT+ENTER if necessarry)
 |  |  |  |  |  |  | \
Spreadsheet: 128774d1321273236-adjusting-an-if-formula-value-new-if-error
Sheet: Sheet1

Site | YYMM | Customer | Name | Item | Glass1 | Alcib1 | ProdGrp1 | Glass2 | Alcib2 | ProdGrp2 | Glass3 | Alcib3 | ProdGrp3 | Spacer1 | Spacer2 | Stp | Shp | Pro | Ld | Geo | Gas | Value | Qty | QM | Act_QM |  | Segment | Product Group | [NAME] | RESULT | Reason
111 | 2011.04 | 971 | Customer 1 | Insulight(TM) | 4mm Textured Contora | 111304 | 3B6000 |  | 0 |  |  | 0 |  | Silver Spacer |  | 0 | 0 | 0 | 0 | 0 | 1 | 40.09 | 1 | 0.33 | 0.32536 |  | Domestic IGU | Other | #N/A | Annealed | I2 is blank so I only need it to look in cell F2 to see if it contains a capital letter "T" as the last letter
111 | 2011.04 | 971 | Customer 2 | Insulight(TM) | 4mm Textured Contora | 111305 | 3B6001 | 4mm Textured Contora | 0 |  |  | 0 |  | Silver Spacer |  | 0 | 0 | 0 | 0 | 0 | 1 | 40.09 | 1 | 0.33 | 0.32536 |  | Domestic IGU | Other | Annealed | Annealed | F3 and I3 cell contents doesnt contain a capital T as the last letter
111 | 2011.04 | 971 | Customer 3 | Insulight(TM) | 4mm Textured Contora T | 111306 | 3B6002 | 4mm Textured Contora | 0 |  |  | 0 |  | Silver Spacer |  | 0 | 0 | 0 | 0 | 0 | 1 | 40.09 | 1 | 0.33 | 0.32536 |  | Domestic IGU | Other | Toughened | Toughened | F4 and I4 cell contents  contain a capital T (cell F4) as the last letter
Spreadsheet: 375968d1423426808-show-certain-detailed-data-from-other-sheet-ef683a_pulling-data-reporting-formula
Sheet: summary by state

 |  |  |  |  |  |  |  | State: | [NAME]
Customers | Location Of Plant | State | Channel | Products | Sales | Price List | Rebate | Trspt Rebate | match_row
Spreadsheet: 715795d1611866874-tiered-payments-with-multiple-variables-sample-workbook
Sheet: Sheet1

 |  |  |  |  | Payment calculation between start and end
Start | End
2020-05-28 00:00:00 | 2021-12-22 00:00:00 |  | Start | End | Status 1 | Status 2
 |  |  | 0 | 3 | H | nV | 317
 |  |  | 3 | 6 | H | nV | 208
 |  |  | 6 | 12 | H | nV | 202
 |  |  | 12 | 24 | H | nV | 141
 |  |  | 24 | 999999 | H | nV | 102
 |  |  | 0 | 3 | H | V | 327
 |  |  | 3 | 6 | H | V | 257
 |  |  | 6 | 12 | H | V | 229
 |  |  | 12 | 24 | H | V | 149
 |  |  | 24 | 999999 | H | V | 127
 |  |  | 0 | 3 | nH | nV | 339
 |  |  | 3 | 6 | nH | nV | 277
 |  |  | 6 | 12 | nH | nV | 246
 |  |  | 12 | 24 | nH | nV | 198
 |  |  | 24 | 999999 | nH | nV | 171
 |  |  | 0 | 3 | nH | V | 486
 |  |  | 3 | 6 | nH | V | 339
 |  |  | 6 | 12 | nH | V | 312
 |  |  | 12 | 24 | nH | V | 257
 |  |  | 24 | 999999 | nH | V | 211
Spreadsheet: 139ffaa9-ff50-4e6c-b4f4-69931ffad664
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-09-29 09:26:14.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
4.375 | 101.861 | 101.736 | 101.611 | 101.236 |  | and are added to price quote
4.25 | 101.059 | 100.934 | 100.809 | 100.434
4.125 | 100.497 | 100.372 | 100.247 | 99.872 |  | Note: | Refer To Price [NAME]
4 | 100.092 | 99.967 | 99.842 | 99.467 |  |  | For all Price Adjs
3.875 | 99.516 | 99.391 | 99.266 | 98.641
3.75 | 98.563 | 98.438 | 98.313 | 97.688
 |  |  |  |  |  | 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
3.875 | 101.875 | 101.75 | 101.625 | 101.25
3.75 | 101.518 | 101.393 | 101.268 | 100.893
3.625 | 100.956 | 100.831 | 100.706 | 100.331
3.5 | 100.618 | 100.493 | 100.368 | 99.993
3.375 | 100.245 | 100.12 | 99.995 | 99.37
3.25 | 99.709 | 99.584 | 99.459 | 98.834
 |  |  |  |  |  | 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-10-13 09:26:14.900000
30 DAY | 2011-10-28 09:26:14.900000
45 DAY | 2011-11-12 09:26:14.900000
60 DAY | 2011-11-27 09:26:14.900000
90 DAY | 2011-12-27 09:26:14.900000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 218775d1362576970-reorganize-data-sample-excel-forum-option-2
Sheet: Price

Name | VOLKSWAGEN PREF. | ENI | DAIMLER | SIEMENS
Code | DE0007664039(P) | IT0003132476(P) | DE0007100000(P) | DE0007236101(P)
2002 | 1 | 45 | 89 | 133
2003 | 2 | 46 | 90 | 134
2004 | 3 | 47 | 91 | 135
2005 | 4 | 48 | 92 | 136
2006 | 5 | 49 | 93 | 137
2007 | 6 | 50 | 94 | 138
2008 | 7 | 51 | 95 | 139
2009 | 8 | 52 | 96 | 140
2010 | 9 | 53 | 97 | 141
2011 | 10 | 54 | 98 | 142
2012 | 11 | 55 | 99 | 143