tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: michelle_lokay__26617__imbalsumm0102
Sheet: summary

Index is high - payback should be done on Dollar Valued payables
- payback should be done on Volumetric receivable
- payback should not be done on Dollar valued receivables
- payback should not be done on Volumetric payables
Positive = due [NAME]
Negative = due operator |  |  |  |  |  |  |  |  |  |  |  |  |  | index
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SJ
Operator | Dollars | Volume | As of Date | Imbal Type | MS rep | Comments |  |  |  |  |  |  |  | AVG
PNM |  |  |  | Dollar Valued | [NAME] |  |  |  |  |  |  |  |  | NTXPH
Amoco Abo |  |  |  | Dollar Valued | [NAME]
El Paso |  |  |  | Volumetric | [NAME] | Blanco and Window Rock
NGPL |  |  |  | Volumetric | [NAME]
Mewborne |  |  |  | Dollar Valued | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME]
CIG |  |  |  | Dollar Valued | [NAME]
Mojave Pipeline |  |  |  | Volumetric | [NAME]
Red Cedar |  |  |  | Dollar Valued | [NAME]
PG&E Topock |  |  |  | Volumetric | [NAME]
TransColorado |  |  |  | Dollar Valued | [NAME]
Conoco |  |  |  | Dollar Valued | [NAME]
NNG |  |  |  | Dollar Valued | [NAME]
PG&E TX |  |  |  | Dollar Valued | [NAME]
Agave |  |  |  | Dollar Valued | [NAME]
Lonestar |  |  |  | Volumetric | [NAME]
Receivable imbalances
Operator | Dollars | Volume | As of Date | Imbal Type | MS rep | Comments
Continental |  |  |  | Dollar Valued | [NAME]
Northwest |  |  |  | Volumetric | [NAME]
Burlington |  |  |  | Dollar Valued | [NAME]
EOG |  |  |  | Dollar Valued | [NAME]
Amoco |  |  |  | Volumetric | [NAME]
[NAME] |  |  |  | Volumetric | [NAME]
Duke |  |  |  | Dollar Valued | [NAME] | Crawford, Pecos Diamond, [NAME], Linam Ranch, Artesia
Oasis |  |  |  | Volumetric | [NAME]
SoCal |  |  |  | Volumetric | [NAME]
Payable imbalances
Net imbals
Note -  This report does not represent the total population of imbalances on Transwestern.
Spreadsheet: andy_zipper__181__DYNEGY-ICE VOL May11
Sheet: Enron Activity-ICE

ICE
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Enron North America - ICE |  |  |  |  |  | Enron Power Marketing - ICE |  |  |  |  |  | Enron Canada Corp - ICE
ICE GAS VOLUME: |  | ENRON PERCENTAGE: |  |  |  | ICE POWER VOLUME: |  |  | ENRON PERCENTAGE:
ICE CRUDE PRODUCTS VOLUME: |  | ENRON PERCENTAGE:
 |  |  | Data |  |  |  |  |  | Data |  |  | No Activity
Trader | Product | Qty Units | Transactions | Volume |  | Trader | Product | Qty Units | Transactions | Volume
[NAME], J | NG Fin, FP for LD1 | MMBtus | 7 | 16277500 |  | Carson , M | Firm-LD Peak | MWhs | 13 | 81600
Pimenov, V | NG [NAME], ID, GDD | MMBtus | 3 | 155000 |  | Dorland , C | Firm-LD Peak | MWhs | 7 | 31200
 | NG [NAME], FP | MMBtus | 1 | 15000 |  | Stalford, R | Firm-LD Peak | MWhs | 4 | 8800
[NAME] , | NG Fin BS, LD1 for IF | MMBtus | 1 | 460000 |  | Grand Total |  |  | 24 | 121600
Grand Total |  |  | 12 | 16907500
Spreadsheet: 141240d1329164085-excel-2007-how-to-grab-information-from-other-sheets-and-place-it-in-the-main-sheet-fulllist2
Sheet: Triathlon

Event & Age Category (use dropdown list) | Team Name (if applicable) | Level of Play | First Name | Last Name | Concatenate | Capt(*) | Sex | Address | Suburb | State(abbr) | Postcode | Phone # | [NAME] | [NAME] | Golf Club | Squash Grade | Tenpin Average | Bowling Centre | Preferred Day | Time | Rego/Soc | Business Unit | Employee# | T-Shirt Size | Cheque | Cash | Direct Deb | Total |  | Notes
 |  |  | Test1 | Test1 | Test1 Test1 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test2 | Test2 | Test2 Test2 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test3 | Test3 | Test3 Test3 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test4 | Test4 | Test4 Test4 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xl
 |  |  | Test5 | Test5 | Test5 Test5 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test6 | Test6 | Test6 Test6 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | [NAME] | [NAME] | [NAME] |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test8 | Test8 | Test8 Test8 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | Test9 | Test9 | Test9 Test9 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | Test10 | Test10 | Test10 Test10 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test11 | Test11 | Test11 Test11 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test12 | Test12 | [NAME] |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test13 | Test13 | Test13 Test13 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test14 | Test14 | Test14 Test14 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xl
 |  |  | Test15 | Test15 | Test15 Test15 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test16 | Test16 | Test16 Test16 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test17 | Test17 | [NAME] |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test18 | Test18 | Test18 Test18 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test19 | Test19 | Test19 Test19 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test20 | Test20 | Test20 Test20 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xl
 |  |  | Test21 | Test21 | Test21 Test21 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test22 | Test22 | [NAME] |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test23 | Test23 | Test23 Test23 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test24 | Test24 | Test24 Test24 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | [NAME] | [NAME] | [NAME] |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: darrell_schoolcraft__7819__imbalsumm0109
Sheet: EPFS

 | El Paso/TW Eddy Rec
 | 78093
Day | Measured | Scheduled
1 | 35974 | 36623
2 | 35392 | 33797
3 | 33223 | 35432
4 | 31492 | 36700
5 | 35052 | 36700
6 | 36108 | 36700
7 | 35863 | 32076
8 | 36319 | 36700
9 | 35937 | 36700
10 | 35688 | 36700
11 | 29460 | 36700
12 | 41778 | 36700
13 | 41979 | 33000
14 | 28295 | 32700
15 | 36955 | 33000
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-08-31 00:00:00 |  |  | -36026
2001-09-15 00:00:00
CBS Volume
 |  |  | -1369
Spreadsheet: 6cf866e1-11cc-469f-b020-ad85354ae821
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | FRS GLOBAL SUBCODE EDIT REQUEST FORM | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
Part I.  Type of Subcode Edit |  |  |  |  | (check all that apply)
 |  | Add a NEW Subcode Description |  |  |  |  |  | Modify Global Subcode Edit Table
 |  | Modify an EXISTING Subcode |  |  |  |  |  | Delete a Subcode Description
 |  | Description
Part II.  Requestor Information
 | Requestor Name : |  |  |  |  |  |  | Phone:
 |  |  | [NAME]:
 |  | Approved By: |  |  |  |  |  | Date:
 |  |  |  | (Associate Controller or above)
Part III.  Subcode Additions(A) / Edits(E) / Deletions(D)
 |  |  |  | Action |  | Type |  |  |  | [NAME]
 |  | Subcode |  | (A,E,D) |  | GL/SL |  | Category* |  | (20 characters maximum)
 | *Categories:
 |  | GLs:  Assets, Liabilities, Fund Addition, Fund Deduction, Summary Control
 |  | SLs:  Income,  Expense
Part IV. Global Subcode Edit Table Changes
 |  |  |  |  |  | Through |  |  | Valid
 |  | Account |  | Subcode |  | Subcode |  |  | Y/N |  | Reason for Subcode Edit
Part V.  Completed Form
 |  | Send, email or fax the completed form to: |  |  |  |  | [NAME], Financial Systems, Unit 2112
 |  |  |  |  |  |  |  | Fax:    [PHONE]
 |  |  | AND |  |  |  |  | [NAME]:   [EMAIL]
 |  | also please send a copy to:
 |  | BUDGET, attention [NAME], Fax 486-1055, [NAME] [EMAIL]
 |  | OFFICE OF COST ANALYSIS, attention [NAME], Fax 486-0536, [NAME] [EMAIL]
 |  | FINANCIAL REPORTING, attention [NAME], Fax 486-0536, [NAME] [EMAIL]
Spreadsheet: 107610d1304720884-vlookup-function-grocery
Sheet: Grocery

Product | SKU | Sales | Category | Average | Minimum | Units
[NAME] | 74411 | 9184
Black beans | 44546 | 36427
Brown rice | 14392 | 8139
Bulgar wheat | 73547 | 40225
Chickpeas | 47026 | 6817
Couscous | 60252 | 43696
Kidney beans | 61779 | 23052
Lentils | 32533 | 31055
Oatmeal | 55118 | 43810
Pasta | 92866 | 8962
Quinoa | 57939 | 33382
Raisins | 65364 | 48860
Raw nuts | 61597 | 14338
Raw seeds | 52417 | 17822
Butter | 15368 | 22982
Cheese | 10954 | 27312
Cottage Cheese | 39387 | 33335
Cream Cheese | 53933 | 2501
Creamer | 85907 | 3139
Eggs | 78776 | 39822
Margarine | 16100 | 41421
Milk | 98625 | 2349
Parmesan cheese | 72979 | 6415
Sour Cream | 80500 | 4821
Yogurt | 49328 | 7829
Beer | 56848 | 3911
Coffee | 12771 | 36827
Cola | 67330 | 3594
Tea | 66878 | 32422
Water | 87073 | 47230
Wine | 79849 | 32742
Apples | 32906 | 15466
Avocado | 90781 | 39764
Bananas | 81828 | 29714
Berries | 87740 | 24163
Grapefruit | 65898 | 4346
Grapes | 23913 | 32675
Kiwi Fruit | 79853 | 31819
Lemons | 27661 | 41379
Limes | 91502 | 15391
Melon | 74769 | 12257
Oranges | 71084 | 45200
Peaches | 54595 | 18489
Pears | 95971 | 8178
Plums | 87004 | 46499
[NAME] | 67127 | 9805
[NAME] | 58572 | 15261
[NAME] | 33380 | 40183
[NAME] | 44841 | 7350
[NAME] | 53459 | 47160
[NAME] | 71363 | 33175
[NAME] | 31542 | 12577
[NAME] | 44258 | 31723
Body wash | 24273 | 22801
Conditioner | 81654 | 22761
Condoms | 66074 | 15871
Deoderant | 10635 | 7564
Facial cleanser | 91837 | 15875
Facial tissue | 47698 | 23652
Floss | 95530 | 36615
Hand soap | 99093 | 37461
Lotion | 53767 | 15832
Q-Tips | 90946 | 11268
Razors | 74587 | 49142
Shampoo | 83789 | 17265
Shaving cream | 76754 | 32476
Soap | 61869 | 42519
Toilet paper | 32599 | 45042
Toothpaste | 73943 | 23010
Baking powder | 89908 | 27077
Baking soda | 51437 | 30025
Balsamic vinegar | 14236 | 3167
Bread flour | 57310 | 49305
Honey | 21982 | 19511
Maple syrup | 66537 | 39821
Mustard | 78407 | 24676
Olive Oil | 24814 | 36100
Peanut butter | 64147 | 10155
Yeast | 19595 | 8440
Asparagus | 38765 | 2387
Broccoli | 14002 | 40477
Carrots | 75682 | 35537
Cauliflower | 75932 | 27971
[NAME] | 99248 | 12533
Cilantro | 52157 | 35795
Corn | 32307 | 32994
[NAME] | 37856 | 10628
[NAME] | 24156 | 39557
Ginger | 56894 | 49703
Greens | 13909 | 14466
Lettuce | 73834 | 7403
Mushrooms | 99015 | 34204
Onions | 38396 | 25203
Parsley | 34619 | 35299
Peppers | 71511 | 31640
Potatoes | 22995 | 20045
Spinach | 90148 | 7435
Squash | 91619 | 36535
Tomatoes | 65472 | 7347
[NAME] | 44765 | 15607
Spreadsheet: 739796d1625937857-non-array-formula-to-sort-values-alphabetically-into-b2-b61-non-array-to-extract-unique-values_sort
Sheet: Here

Letter | Letter
 | Den, Lend
 | Den, Lentus
 | Desh, Vintona
 | [NAME], Christinado
 | [NAME], Makia
 | Hayer, Doncast
 | Hot, Rossen
 | Kat, Son
 | Mananu, [NAME]
 | Mananu, songs
 | Morgan, [NAME]
 | Pop, Icon
 | Smith, Sabana
 | Strong, [NAME]
 | Strong, Sea
 | Whatzt, Tense
 | Worth, Coral
Spreadsheet: 273097d1382613011-gets-wrong-data-kontrahenci
Sheet: dane

sk | NAZWA | Osoba | ADRES | adres2 | NR TEL. | MAIL
 | [NAME] | osoba1 firma a | adres 1 firma a | adres 2 firma a | 123456789 | [NAME]
 | [NAME] | osoba1 firma d | adres 1 firma d | adres 2 firma d | 123321123 | [EMAIL]
 | firma b | osoba1 firma b | adres 1 firma b | adres 2 firma b | 12345123 | [EMAIL]
 | [NAME] | osoba2 firma a | adres 1 firma a os2 | adres 2 firma a os2 | 123987234 | [EMAIL]
 | firma c | osoba1 firma c | ares 1 firma c os1 | adres 2 firma c os1 | 123123123 | [EMAIL]
 | firma c | c2
 | ac | ac1
 | [NAME] | a5
 | [NAME] | d5
 | [NAME] | a6
 | [NAME] | d6
 | [NAME] | a
 | [NAME] | a
 | [NAME] | a
 | firma b | b
 | firma b | b
 | firma b | b
 | firma c | c2
 | firma b | b
 | [NAME] | a
Spreadsheet: 599947d1543385803-index-match-with-find-text-please-help-indexmatchhi-k
Sheet: Sheet2

Time | P/N | Average | Date |  |  | Finding Value | Average
100 | HKTRWA16000-1-500-BO | 46 | 2018-10-12 00:00:00 |  |  | 16000-1 | 50 |  | input values
123 | HKRWA16000-1-500-B1 | 47 | 2018-11-10 00:00:00
111 | HKRWA16000-6 | 52.47 | 2018-09-10 00:00:00
234 | HKRWA16000-6-101-B1 | 53.37333333333333 | 2018-09-11 00:00:00
276 | HKRWA16000-6-500 | 44.01000000000001 | 2018-09-12 00:00:00 |  | Details and condition
276 | HKRWA18000-14-500-B0 | 43.75333333333333 | 2018-09-13 00:00:00 |  | 1. Output is time
372 | HKRWA20000-6-500 | 40.39000000000001 | 2018-09-14 00:00:00 |  | 2. Find the value of time in:
372 | HKTRWA16000-1-250 | 50 | 2018-11-05 00:00:00 |  |  | a. matching G2 from B2:[NAME] (find formula)
270 | [NAME] | 56.88 | 2018-09-16 00:00:00 |  |  | [NAME] should be latest date < 30 from current date
450 | [NAME] | 36.0966666666667 | 2018-09-17 00:00:00 |  |  | [NAME] is ± 5 of H2
324 | [NAME] | 50 | 2018-11-11 00:00:00
Spreadsheet: 221467d1363566109-conditional-formatting-colorize-the-cells-match-two-columns-conditionalformatting_color
Sheet: List

LIST 1 |  | LIST 2 |  |  | EXPLANATION
1401057401052 |  | 2010276710044 |  |  | Item | List 1 | List 2
1401057401052 |  | 1401057401052 |  |  | 1401057401052 | 2 | 2 | List 1 & List 2 colored
181400902412 |  | 1401057401052 |  |  | 181400902412 | 2 | 3 | List 1 (2) & List 2 first (2) colored
181400902412 |  | 181400902412 |  |  | 181400902443 | 1 | 0 | NOT colored
181400902443 |  | 181400902412 |  |  | 2010276710044 | 1 | 6 | List 1 (1) List 2first (1) colored
2010276710044 |  | 181400902412 |  |  | 2010276710051 | 1 | 0 | NOT colored
2010276710051 |  | 2010276710044
 |  | 2010276710044
 |  | 2010276710044 |  |  | Note:List1 & List2 cells manually colored.
 |  | 2010276710044
 |  | 2010276710044 |  |  | Request:
 |  |  |  |  | Need a Conditional Formatting FORMULA to colorize the List1 and List2 cells
Spreadsheet: 4b6fe9d2-d1d7-473a-9b5e-f94ba13b5324
Sheet: Sheet1

Release: Non-Manufacturing ISM Report on Business | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=147
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2013-12-12 3:39 AM CST
 | Real-Time | Period
Name: | Start | End
Non-Manufacturing ISM Report on Business | 2007-12-05 00:00:00 | Current
Link:
http://www.ism.ws/ISMReport/ | 2007-12-05 00:00:00 | Current
Source:
Institute for Supply Management | 2007-12-05 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2007-12-05 00:00:00
2008-01-04 00:00:00
2008-01-29 00:00:00
2008-02-05 00:00:00
2008-03-05 00:00:00
2008-04-03 00:00:00
2008-05-05 00:00:00
2008-06-04 00:00:00
2008-07-03 00:00:00
2008-08-05 00:00:00
2008-09-04 00:00:00
2008-10-03 00:00:00
2008-11-03 00:00:00
2008-11-04 00:00:00
2008-11-05 00:00:00
2008-12-03 00:00:00
2009-01-06 00:00:00
2009-01-21 00:00:00
2009-02-04 00:00:00
2009-03-04 00:00:00
2009-04-03 00:00:00
2009-05-05 00:00:00
2009-06-03 00:00:00
2009-07-06 00:00:00
2009-08-05 00:00:00
2009-09-03 00:00:00
2009-10-05 00:00:00
2009-11-04 00:00:00
2009-12-03 00:00:00
2010-01-06 00:00:00
2010-01-27 00:00:00
2010-02-03 00:00:00
2010-03-03 00:00:00
2010-04-05 00:00:00
2010-05-05 00:00:00
2010-06-03 00:00:00
2010-07-06 00:00:00
2010-08-04 00:00:00
2010-09-03 00:00:00
2010-10-05 00:00:00
2010-11-03 00:00:00
2010-12-03 00:00:00
2011-01-05 00:00:00
2011-02-03 00:00:00
2011-03-03 00:00:00
2011-04-05 00:00:00
2011-05-04 00:00:00
2011-06-03 00:00:00
2011-07-06 00:00:00
2011-08-03 00:00:00
2011-09-06 00:00:00
2011-10-05 00:00:00
2011-11-03 00:00:00
2011-12-05 00:00:00
2012-01-05 00:00:00
2012-01-31 00:00:00
2012-02-03 00:00:00
2012-03-05 00:00:00
2012-04-04 00:00:00
2012-05-03 00:00:00
2012-06-05 00:00:00
2012-07-05 00:00:00
2012-08-03 00:00:00
2012-09-06 00:00:00
2012-10-03 00:00:00
2012-11-05 00:00:00
2012-12-05 00:00:00
2013-01-04 00:00:00
2013-02-05 00:00:00
2013-03-05 00:00:00
2013-04-03 00:00:00
2013-05-03 00:00:00
2013-06-05 00:00:00
2013-07-03 00:00:00
2013-08-05 00:00:00
2013-09-05 00:00:00
2013-10-03 00:00:00
2013-11-05 00:00:00
2013-12-04 00:00:00
Spreadsheet: 833596d1687118959-complex-subtract-complex-subtract-aligw
Sheet: Sheet1

 | strike price | price |  | ANSWER |  | AliGW
 | 17500 | 27.75
 | 17550 | 26.95
 | 17600 | 25.7
 | 17500 | -27.78 |  | 0.03
 | 17550 | 26.88
 | 17600 | 25.85
 | 17500 | 27.56
 | 17550 | 26.67
 | 17600 | 25.53
 | 17500 | 0 |  | 0
 | 17550 | 26.55
 | 17600 | 25.53
 | 17500 | 27.43
 | 17550 | 26.52
 | 17600 | 25.38
 | 17500 | 27.22
 | 17550 | 26.31
 | 17600 | 25.17
 | 17500 | 27.06
 | 17550 | 26.25
 | 17600 | 25.01
 | 17500 | 27.02
 | 17550 | 26.21
 | 17600 | 25.07
 | 17500 | 0 |  | 0
 | 17550 | 26.2
 | 17600 | 25.06
 | 17500 | 27.37
 | 17550 | 26.45
 | 17600 | 25.2
 | 17500 | 27.42
 | 17550 | 26.61
 | 17600 | 25.36
 | 17500 | 27.73
 | 17550 | 26.92
 | 17600 | 25.78
 | 17500 | 27.51
 | 17550 | 26.81
 | 17600 | 25.67
 | 17500 | 27.6
 | 17550 | 26.91
 | 17600 | 25.66
 | 17500 | 27.63
 | 17550 | 26.83
 | 17600 | 25.79
Spreadsheet: 738296d1624959643-transposing-data-book1
Sheet: Transposed

Date | Year | Quarter | Conversion Currency | Currency Value
Spreadsheet: 851094d1701346081-how-to-vlook-up-one-cell-from-a-sheet-to-show-the-whole-row-on-another-sheet-113023
Sheet: MASTERFILE

Biometrics | FIRST NAME | MIDDLE NAME | LAST NAME | FULL NAME | COMPANY | AREA | POSITION | SSS | PAG-IBIG | PHILHEALTH | TIN | RATE
 | Aldrin | [NAME] | Alipis
 | [NAME] | Dayday | Aniel
 | Jesmer | [NAME] | Arancana
 | Angelita | Morales | Bago
 | [NAME] | Mahinay | [NAME]
 | [NAME] | Dagoyo | Banlas
 | [NAME] | Panilaga | [NAME]
 | Flordemie | Jamero | Borromeo | [NAME]
 | [NAME] | [NAME] | Cabañez | [NAME]
 | Jonny | Joring | Cabil
 | [NAME] | Caipo | Cainoy
 | [NAME] | Onyot | Cambarihan
 | [NAME] |  | Cañedo
 | [NAME] | [NAME] | Canete
 | [NAME] | Molina | [NAME]
 | Peizer | Panuncialman | Dalida
 | Maricyl | Paculba | Datu
 | Rene | Imbor | Dumaboc
 | Vincent | Endrina | Flores
 | Josefa | Cabanlit | [NAME]
 | Dianna Fe | Destinado | Hermogenes
 | Nerie | [NAME] | Imbor
 | Delmar | Veloz | Laniton
 | [NAME] | Ramos | Lavador
 | Rogelio | Malisod | [NAME]
 | Charie | Batingal | [NAME]
 | [NAME] | Brahim | Martinez
 | [NAME] | Balbuena | Mingo
 | Alejandro Jr. | [NAME] | Orañola
 | [NAME] | Mantalaba | Poblete
 | Rosmell | Aboc | Sajonia
 | [NAME] | Valmorida | Salmo
 | Realyn | Talundata | Siarot
 | [NAME] | Rizon | Sinogaya
 | Emelyn | Pelandas | Sujetado
 | [NAME] | Sabanal | [NAME]
 | Julie | Zulita | Tabid2 | [NAME] Tabid
 | Eva Maria | Valmorida | Tagaro
 | Ma. [NAME] | [NAME] | [NAME]
 | Marlon | Mabayla | Unson
 | [NAME] | Tadena | Valledor
 | [NAME] | Cortez | [NAME]
 | Jemboy | Ababa | [NAME]
 | Annabel | Generana | Yamut
 | Amie | Mediana | Sereno
 | Anecita | Acorda | Alasagas
 | Angelito | Tinaja | Omac
 | [NAME] | Verson | Galdo
 | [NAME] | [NAME] | Baloc
 | [NAME] | Kionisala | Rementizo
 | [NAME] | Horguera | Acabal
 | [NAME] | Villoso | [NAME]
 | [NAME] | Malubay | Bulontad
 | Delmar | Veloz | Laniton
 | [NAME] | [NAME] | Imbor
 | Doroteo | Matarong | de la Fuente
 | Eloisa | Navales | Quitor
 | [NAME] | Bauzon | Bangcong
 | Ernesto | Legaria | Salmo
 | [NAME] | Polinar | [NAME]
 | Eva Maria | Valmorida | Tagaro
 | Friolo | Ordiano | [NAME]
 | [NAME] | Zulita | Tabid1 | [NAME] Tabid
 | Jessica | [NAME] | Imbor
 | [NAME] | Dorado | Salmo
 | [NAME] | [NAME] | [NAME]
 | [NAME] | Joring | Cabil Jr.
 | [NAME] | Rizon | Sinogaya
 | Loime | Onyot | Cambarihan
 | [NAME] | Abocayon | [NAME]
 | [NAME] | Valmorida | Salmo
 | [NAME] | [NAME] | Imbor
 | [NAME] |  | Cañedo
 | Marlon | Mabayla | Unson
 | Mischellyn | Villacorte | Egan
 | [NAME] | Mambalaya | Barce
 | Racelle | Alpanta | Dayas
 | Realyn | Talundata | Siarot
 | Reman | Rizon | Maandig
 | [NAME] | [NAME] | Baloc
 | Romer | Aballe | [NAME]
 | [NAME] | Acosta | Marianas
 | [NAME] | Barcobero | Mabao
 | [NAME] | Lluch | Salmo
 | [NAME] | [NAME] | Arenilla2
 | [NAME] | Valmorida | Salmo
 | [NAME] | Valmorida | Salmo
 | Wilfredo | Caballes | Salmo
 | Felix | Orilla | Mosqueda
Spreadsheet: 850713d1701102280-return-values-text-under-certain-conditions-in-separate-lists-data-retrieval-under-conditions-version-2
Sheet: Target

 |  |  | Geschäftsfeld | Geschäftsfeld-einheit/ WSS | Kennzahl/Werttreiber | Einheit​ | VJ​ | FC 24​ | Plan 25​ | Plan 26​ | Plan 27​ | FC vs. Plan 25​ | Plan 25 vs. 26​ | Plan 26 vs. 27​ | Kommentierung​
 |  |  | Geschäftsfeld | Geschäftsfeld-einheit/ WSS | Kennzahl/Werttreiber | Einheit​ | VJ​ | FC 24​ | Plan 25​ | Plan 26​ | Plan 27​ | FC vs. Plan 25​ | Plan 25 vs. 26​ | Plan 26 vs. 27​ | Kommentierung​
 |  |  | [NAME] | Gas | A | Mio. Euro​ | 32 | 32 | 32 | 37 | 42 |  |  | ​ | ​
 |  |  | [NAME] | Gas | B | MW | 34 | 34 | 34 | 39 | 44 |  |  | ​ | ​
 |  |  | [NAME] | [NAME] | C | Mio. Euro​ | 36 | 36 | 36 | 41 | 46 |  |  | ​ | ​
 |  |  | [NAME] | [NAME] | D | MW | 38 | 38 | 38 | 43 | 48 |  |  | ​ | ​
 |  |  | [NAME] | [NAME] | E | Mio. Euro​ | 40 | 40 | 40 | 45 | 50 |  |  | ​ | ​
 |  |  | [NAME] | [NAME] | F | MW | 42 | 42 | 42 | 47 | 52 |  |  | ​ | ​
Spreadsheet: 533ea3dd-75dc-48c8-9467-94589b10f547
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: |  |  | 2014-03-14 09:42:52.060000
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.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.828 | 102.703 | 102.578 | 102.203
4.5 | 101.915 | 101.79 | 101.665 | 101.29 |  | Note: | Refer To Price [NAME]
4.375 | 101.058 | 100.933 | 100.808 | 100.433 |  |  | For all Price Adjs
4.25 | 100.496 | 100.371 | 100.246 | 99.621
4.125 | 99.677 | 99.552 | 99.427 | 98.802
4 | 98.662 | 98.537 | 98.412 | 97.787
3.875 | 97.613 | 97.488 | 97.363 | 96.738
3.75 | 96.738 | 96.613 | 96.488 | 95.863
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.875 | 102.75 | 102.625 | 102.25
3.875 | 102.875 | 102.75 | 102.625 | 102.25
3.75 | 102.779 | 102.654 | 102.529 | 102.154
3.625 | 102.384 | 102.259 | 102.134 | 101.759
3.5 | 101.847 | 101.722 | 101.597 | 100.972
3.375 | 101.067 | 100.942 | 100.817 | 100.192
3.25 | 100.313 | 100.188 | 100.063 | 99.438 |  | 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 | 2014-03-28 09:42:52.060000
30 DAY | 2014-04-12 09:42:52.060000
45 DAY | 2014-04-27 09:42:52.060000
60 DAY | 2014-05-12 09:42:52.060000
90 DAY | 2014-06-11 09:42:52.060000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.