tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 739996d1626120740-formula-for-running-balance-based-on-i-d-number-running-balance
Sheet: Sheet1

I'm kindly asking for excel formula for running balance based on I.D number as shown on the desired outcome: column H
Desired outcome
I.D Number | Name | Date | Reference | Invoice | Deposit | Withdrawal | Balance
A 004 | ANDILE B NCUBE | 2021-01-01 00:00:00 | 1 | AA |  | 0 | 0
A 004 | ANDILE B NCUBE | 2021-03-22 00:00:00 | 2 | AA | 23375 |  | 23375
A 004 | ANDILE B NCUBE | 2021-03-22 00:00:00 | 3 | AA |  | 21000 | 2375
A 004 | ANDILE B NCUBE | 2021-03-23 00:00:00 | 4 | AA |  | 2375 | 0
A 008 | ASHER TAMIREPI | 2021-01-01 00:00:00 | 5 | AA | 17807.5 |  | 17807.5
A 008 | ASHER TAMIREPI | 2021-03-22 00:00:00 | 6 | AA | 23375 |  | 41182.5
A 008 | ASHER TAMIREPI | 2021-03-23 00:00:00 | 7 | AA |  | 4250 | 36932.5
A 008 | ASHER TAMIREPI | 2021-04-13 00:00:00 | 8 | AA |  | 5950 | 30982.5
A 008 | ASHER TAMIREPI | 2021-04-21 00:00:00 | 9 | AA |  | 1700 | 29282.5
A 008 | ASHER TAMIREPI | 2021-04-28 00:00:00 | 10 | AA |  | 5000 | 24282.5
A 008 | ASHER TAMIREPI | 2021-05-31 00:00:00 | 11 | AA |  | 1360 | 22922.5
A 008 | ASHER TAMIREPI | 2021-05-10 00:00:00 | 12 | AA |  | 2550 | 20372.5
A 009 | [NAME] | 2021-01-01 00:00:00 | 13 | AA |  | 0 | 0
A 009 | [NAME] | 2021-03-22 00:00:00 | 14 | AA | 23375 |  | 23375
A 009 | [NAME] | 2021-03-25 00:00:00 | 15 | AA |  | 23375 | 0
Spreadsheet: 36058d1233819767-random-selection-of-a-data-located-in-a-column-by-text-color-randomnumgeneratorfromlist
Sheet: Sheet3

Black | Red
11 | 55
12 | 56
13 | 57
14 | 58
15 | 59
16 | 60
17 | 61
18 | 62
19 | 63
20 | 64
21 | 65
22 | 66
23 | 67
24 | 68
25 | 69
26 | 70
27 | 71
28 | 72
29 | 73
30 | 74
31 | 75
32 | 76
33 | 77
34 | 78
35 | 79
36 | 80
37 | 81
38 | 82
39 | 83
40 | 84
32 | 70 |  | Press F9 to randomly select one number from each column
Spreadsheet: 58274d1258555325-if-and-vlookup-new-microsoft-excel-worksheet
Sheet: Sheet2

FRUITS | APPLE |  | FRUITS
FRUITS | MANGO |  | VEGETABLES
FRUITS | BANANA |  | ITEMS
VEGETABLES | CARROT
VEGETABLES | RADISH
VEGETABLES | PUMPKIN
ITEMS | BOOKS
ITEMS | TABLES
ITEMS | CHAIRS
Spreadsheet: 60014d1260534941-sending-data-from-input-sheet-to-other-sheets-in-a-workbook-new-budget-planner1
Sheet: Next Catalogue

Next Catalogue
Month | Year | Paymet
January | 2008
February | 2008
March | 2008
April | 2008
May | 2008
June | 2008
July | 2008
August | 2008
September | 2008
October | 2008
November | 2008
December | 2008 | 14
January | 2009 | 14
February | 2009
March | 2009 | 50
April | 2009 | 50
May | 2009 | 50
June | 2009 | 50
July | 2009 | 50
August | 2009 | 50
September | 2009 | 50
October | 2009 | 50
November | 2009
December | 2009
January | 2010
February | 2010
March | 2010
April | 2010
May | 2010
June | 2010
July | 2010
August | 2010
September | 2010
October | 2010
November | 2010
December | 2010
Spreadsheet: 142803d1330014179-changing-a-date-format-to-mmm-yy-and-then-created-a-pivot-chart-for-monthly-stats-copy-of-month-chart
Sheet: Sheet1

 |  |  |  |  |  |  |  | Count of Name
 |  | CONTACTS |  |  |  |  |  | Date | Total
 |  | Date | Name | Town |  |  |  | Jan | 4
 |  | 2011-01-01 00:00:00 | [NAME] | Bristol |  |  |  | Feb | 1
 |  | 2011-01-02 00:00:00 | [NAME] | Exeter |  |  |  | Mar | 5
 |  | 2011-01-05 00:00:00 | [NAME] | Torquay |  |  |  | Apr | 1
 |  | 2011-01-22 00:00:00 | [NAME] | Swansea |  |  |  | May | 3
 |  | 2011-02-04 00:00:00 | [NAME] | Merthyr |  |  |  | Jun | 1
 |  | 2011-03-04 00:00:00 | Remi | Cardiff |  |  |  | Grand Total | 15
 |  | 2011-03-17 00:00:00 | [NAME] | Truro
 |  | 2011-03-18 00:00:00 | [NAME] | Penzance
 |  | 2011-03-19 00:00:00 | [NAME] | Paignton
 |  | 2011-03-20 00:00:00 | [NAME] | Brixham
 |  | 2011-04-01 00:00:00 | Mark | Taunton
 |  | 2011-05-17 00:00:00 | [NAME] | Newport
 |  | 2011-05-18 00:00:00 | [NAME] | Caerphilly
 |  | 2011-05-19 00:00:00 | [NAME] | Bridgewater
 |  | 2011-06-01 00:00:00 | [NAME] | Tiverton
Spreadsheet: 104567d1302118752-is-it-sumifs-can-work-here-if-yes-how-demand
Sheet: total

item no | item name | total
1220 | sgr
2020 | cc.5
1520 | sg05
2023 | cc1.5
4523 | sp1.5
4520 | sgr
6113 | cc.6
6626 | sg06
6820 | cc1.6
6920 | sp1.6
8620 | .5 ust
8800 | epal
Spreadsheet: 0172cd82-9ac9-4fae-b848-39986bf60887
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | 报表 N
国际民航组织
航空运输报表
航空人员的执照与培训
联系人： |  |  |  | 国家名称：
单位：
电话： |  |  |  | 年度：
传真：
电子邮件：
航空人员资格证明
国际民航组织代码 | 资格证明类别 |  | 颁发的资格证明（年） | 有效资格证明合计 | 年度核验/换发 | 核验/换发合计 | 退休年龄
 | a |  | b | c | d | e | f
 | 1 | ATPL
 | 2 | CPL
 | 3 | MPL
 | 4 | PPL
 | 5 | 飞行教员等级
 | 6 | 特殊批准
 | 7 | 航空器维修执照
 | 8 | 空中交通管制执照
航空人员今后的培训能力
国际民航组织代码 | 执照类别 |  | 培训机构（现有） | [NAME]） | [NAME]）
 | g |  | h | i | j
 | 9 | 驾驶员 (PPL/CPL/ATPL)
 | 10 | 驾驶员(MPL)
 | 11 | 航空器维修执照
 | 12 | 空中交通管制执照
Spreadsheet: 99233d1297943683-index-and-match-a-list-excel-example
Sheet: Sheet1

A | B | C | D | E | F
 |  |  |  |  | Top 3
[NAME] | Region | Value |  | Scotland | 12.5
A | Scotland | 10.1 |  |  | 11.9
b | England | 8.2 |  |  | 11
c | Wales | 6.3
d | Ireland | 5.4
e | Scotland | 10.3
f | England | 9
g | Wales | 8
h | Ireland | 7.2
i | Scotland | 4
j | England | 3
k | Wales | 2
l | Ireland | 1
m | Scotland | 12.5
n | England | 11.9
o | Wales | 3
p | Ireland | 6.2
q | Scotland | 2
r | England | 10
s | Wales | 11
t | Ireland | 10.4
Spreadsheet: 798356d1664443119-create-summary-sheet-on-multiple-values-and-criteria-29092022-sample-file-for-excel-forum
Sheet: Branch 4

 | Opening | Dep | closing
Computer | 1500 | 300
furniture | 2000 | 200
Computer
furniture
Computer
Computer
Computer
Spreadsheet: 375995d1423442694-how-do-i-hide-worksheets-based-on-data-in-a-cell-how-do-i-hide-worksheets
Sheet: ClassList

2
[NAME] | A
[NAME] | A
[NAME] | A
[NAME] | A
[NAME] | A
[NAME] | A
[NAME] | B
[NAME] | B
[NAME] | B
[NAME] | B
[NAME] | B
[NAME] | B
[NAME] | B
Spreadsheet: 743964d1628843479-quarterly-sum-the-values-with-interest-rate-test-39-ans
Sheet: 검증

0.03 | CODE | AMOUNT | QUARTER | before_A | after_A | before_B | after_B |  | after_A
 | 3_2020 | 100 | 1 |  |  | 10549.3715441747
 | 3_2020 | 150 | 1 |  |  | 10762.8526904999
 | 3_2020 | 200 | 1 |  |  | 10931.2382712149
 | 3_2020 | 250 | 2 |  |  | 11053.1754193513
 | 3_2020 | 300 | 2 |  |  | 11127.27068193188
 | 3_2020 | 350 | 2 |  |  | 11152.08880238983
 | 3_2020 | 400 | 3 |  |  | 11126.15146646153
 | 3_2020 | 450 | 3 |  |  | 11047.93601045537
 | 3_2020 | 500 | 3 |  |  | 10915.87409076904
 | 3_2020 | 550 | 4 |  |  | 10728.35031349211
 | 3_2020 | 600 | 4 |  |  | 10483.70082289687
 | 3_2020 | 650 | 4 |  |  | 10180.21184758378
 | 3_2020 | 700 | 1 |  |  | 9816.118203011289
 | 3_2020 | 750 | 1 |  |  | 9389.601749101626
 | 3_2020 | 800 | 1 |  |  | 8898.789801574676
 | 3_2020 | 850 | 2 |  |  | 8341.753495621917
 | 3_2020 | 900 | 2 |  |  | 7716.506100490575
 | 3_2020 | 950 | 2 |  |  | 7021.001283505292
 | 3_2020 | 1000 | 3 |  |  | 6253.131322010451
 | 3_2020 | 1050 | 3 |  |  | 5410.725261670765
 | 3_2020 | 1100 | 3 |  |  | 4491.547019520887
 | 3_2020 | 1150 | 4 |  |  | 3493.293430106513
 | 3_2020 | 1200 | 4 |  |  | 2413.592233009709
 | 3_2020 | 1250 | 4 |  |  | 1250
 | 3_2021 | 120 | 1 |  |  | 12659.24585300958
 | 3_2021 | 180 | 1 |  |  | 12915.42322859987
 | 3_2021 | 240 | 1 |  |  | 13117.48592545787
 | 3_2021 | 300 | 2 |  |  | 13263.8105032216
 | 3_2021 | 360 | 2 |  |  | 13352.72481831825
 | 3_2021 | 420 | 2 |  |  | 13382.5065628678
 | 3_2021 | 480 | 3 |  |  | 13351.38175975383
 | 3_2021 | 540 | 3 |  |  | 13257.52321254645
 | 3_2021 | 600 | 3 |  |  | 13099.04890892284
 | 3_2021 | 660 | 4 |  |  | 12874.02037619053
 | 3_2021 | 720 | 4 |  |  | 12580.44098747624
 | 3_2021 | 780 | 4 |  |  | 12216.25421710053
 | 3_2021 | 840 | 1 |  |  | 11779.34184361355
 | 3_2021 | 900 | 1 |  |  | 11267.52209892195
 | 3_2021 | 960 | 1 |  |  | 10678.54776188961
 | 3_2021 | 1020 | 2 |  |  | 10010.1041947463
 | 3_2021 | 1080 | 2 |  |  | 9259.80732058869
 | 3_2021 | 1140 | 2 |  |  | 8425.20154020635
 | 3_2021 | 1200 | 3 |  |  | 7503.75758641254
 | 3_2021 | 1260 | 3 |  |  | 6492.870314004917
 | 3_2021 | 1320 | 3 |  |  | 5389.856423425064
 | 3_2021 | 1380 | 4 |  |  | 4191.952116127816
 | 3_2021 | 1440 | 4 |  |  | 2896.310679611651
 | 3_2021 | 1500 | 4 |  |  | 1500
Spreadsheet: 850726d1701113797-add-data-from-multiple-sheets-sample-workbook
Sheet: SHEET4

 | Company Logo |  | Company Name Address City, State Zip (123) 456-7890 https://website.com
 | Name |  | Period |  | Vehicle |  |  | License Plate# |  |  | Reimbursement Rate
 | XXXXXX |  | 8/15/2023-9/20/2023 |  | XXXXXXXXXXXX |  |  | XXXXXX |  |  | 0.655
 | Date | Business Purpose |  | From |  | To |  | Odometer ([NAME]) |  | Mileage |  | Remarks
 |  |  |  |  |  |  |  | Start | End
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Period Reimbursement Total |  |  |  |  |  |  | Total Miles
Spreadsheet: chris_germany__2343__contacts
Sheet:  Bulletin Boards

Bulletin Board
Pipeline/LDC | EBB | Internet/ProComm | Script/Phone #/Internet | ID | Password | Purpose
Algonquin | Link | ProComm | script 0:\common\prowin3\wax\nt\central\linkwin.wax | lnk5803 | chris9 | capacity release, notices, rate info
CNG (pipeline) | E-Script | ???? |  | es0527$ | florida | capacity release, notices, rate info
Columbia Gas | Navigator | ??? |  | nav0409 | bovine
National Fuel |  | www.nfg.natfuel.com |  | GERMANYC | tp303mar
Tennessee Pipeline | Passkey | ??? |  | 000357D | prices | capacity release, notices, rate info
Texas Eastern Transmission | Link | ProComm | script 0:\common\prowin3\wax\nt\central\linkwin.wax | lnk6449 | chris1 | ECT Access - capacity release, notices, rate info
Transco | Transit | Internet | www.transit.twc.com | upnr010 | [NAME] | capacity release, notices, rate info
Transco | Transit | Internet | www.transit.twc.com | upnr140 | [NAME] | capacity release, notices, rate info | [NAME] Password
Texas Gas Transmission | Gasquest | Internet |  | $Germany_c | tempwork     was bossjudy
Network |  |  |  |  | tp303mar
[NAME] |  |  |  | jtownse | jgt04apr
[NAME] |  |  |  | [NAME] | [NAME]
[NAME] | Internal contact [NAME] |  | x54540 | cger | cger | trade.altra.com   enron company number 56987
[NAME] |  |  |  | jtownse | jgt02feb
Dow Jones Telerate |  |  |  |  | texas1
cpr |  |  |  |  | clg07july
Synergi |  |  |  | cgerman | pipercub | Old password = columbus
Synergi 2nd password |  |  |  | cgerman | 453333235 | <== never changes
Unify |  |  |  | cgerman | clg09sep
Performance Management |  |  |  | 90011682 | nov11clg
E Greetings |  |  | http://www.egreetings.com/e-products/m_main/cgi/homepage |  | duffy
Dynegydirect |  |  | www.dynegydirect.com | ENECGERMANY | tp303mar | [NAME] germany01
Dynegydirect |  |  | www.dynegydirect.com | ENEJUNEK | drj01jan | [NAME] germany01
Enron Online |  |  |  | ADM81300 | tp303mar
Enron Online Judy |  |  |  | [NAME] | [NAME]
HR GIS |  |  | http://gis.enron.com | 453333235 | clg03mar
SAP |  |  |  | P00503219 | 19610710 | personnel number is 00503219
HR Benefits |  |  |  | 453333235 | 1474
CES Passwords
Algonquin | Link | ProComm |  | [NAME] | pontiac1
CNG (pipeline) | E-Script | ???? |  | es0554$ | camper1 | capacity release, notices, rate info
CNG (pipeline) | E-Script | ???? |  | es0221$ | morgan7 | capacity release, notices, rate info
Columbia Gas | Navigator | ??? |  | col0779 | start2
Columbia Gulf | Altra | ???
Tennessee Pipeline | Passkey | ??? |  | 000042d | raider1 | capacity release, notices, rate info
Texas Eastern Transmission | Link | ProComm | script 0:\common\prowin3\wax\nt\central\linkwin.wax | [NAME] | pontiac1 | ECT Access - capacity release, notices, rate info
Transco | Transit | Internet | www.transit.twc.com | uppm000 | scottg | capacity release, notices, rate info
Texas Gas Transmission | Gasquest | Internet |  | $east_d | password
Spreadsheet: 704551d1605620502-if-isnumber-search-and-or-with-extra-criteria-erf-log-projects-web-post
Sheet: CRI Tracker and Schedule

ERF # | SN | Project Name | [NAME] | Site Due Date | Activity Plan | Part Number IN Generic: If comp bladed we could use RTRBLDFCRFBCU If un bladed we could use RTRUNBFCRFBCU ([NAME]) | Part Number OUT (Brown & Brown Refurb) | Serial Number | Note(s)
Spreadsheet: 19f771e9-7a95-4dd9-b461-3b97d6d97c05
Sheet: 20

 |  | Broker** |  | Non-Broker |  | TOTAL
Product |  | Cleared*** | Uncleared | Cleared | Uncleared | Cleared | Uncleared
Swap* | CFD
 | Dividend
 | Equity Swap
 | Portfolio
 | [NAME]
Option | Accumulator/Decumulator
 | Vanilla (put/call)
 | [NAME]
Forward | Vanilla
Exotic
Structured Products
TOTAL |  | N/A**** | N/A | N/A | N/A | N/A | N/A
Estimated swap dollar volumes, month ending November 30, by product, participant type, and cleared status (value of all trades in millions of USD).
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for participant type descriptions.
***See Explanatory Notes for cleared and uncleared descriptions.
****N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 68532d1269043520-formula-disappears-generic-version
Sheet: Rpt Expense

test
 | EXPENSE TOTALS | AMOUNT
 |  | 0
 |  | 0
 |  | 0
 |  | #N/A
 |  |  | PERCENT
 |  | #N/A | #N/A
 |  | 0 | #N/A
 |  | 0 | #N/A
 |  | 0 | #N/A
 |  | 0 | #N/A
 |  | 0 | #N/A
 |  | 0 | #N/A
 |  | 0 | #N/A
 |  | #N/A
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 |  | Annual Cost
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 |  | Annual Cost
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | Annual Cost
 | 0 | 0
 | 0 | 0
 | 0
 | 0
 | 0
 |  | Annual Cost
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
2 |  | Annual Cost
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 |  | 0
Spreadsheet: 587902d1535381513-non-volatile-alternative-to-sumifs-indirect-formulas-dummy-workbook
Sheet: DataSheet3

 | 2014-06-30 00:00:00 | 100
 | 2014-07-07 00:00:00
 | 2014-07-14 00:00:00
 | 2014-07-21 00:00:00
 | 2014-07-28 00:00:00
 | 2014-08-04 00:00:00
 | 2014-08-11 00:00:00
 | 2014-08-18 00:00:00
 | 2014-08-25 00:00:00
 | 2014-09-01 00:00:00
 | 2014-09-08 00:00:00
 | 2014-09-15 00:00:00
 | 2014-09-22 00:00:00
 | 2014-09-29 00:00:00
 | 2014-10-06 00:00:00
 | 2014-10-13 00:00:00
 | 2014-10-20 00:00:00
 | 2014-10-27 00:00:00
 | 2014-11-03 00:00:00
 | 2014-11-10 00:00:00
 | 2014-11-17 00:00:00
 | 2014-11-24 00:00:00
 | 2014-12-01 00:00:00
 | 2014-12-08 00:00:00
 | 2014-12-15 00:00:00
 | 2014-12-22 00:00:00
 | 2014-12-29 00:00:00
 | 2015-01-05 00:00:00
 | 2015-01-12 00:00:00
 | 2015-01-19 00:00:00
 | 2015-01-26 00:00:00
 | 2015-02-02 00:00:00
 | 2015-02-09 00:00:00
 | 2015-02-16 00:00:00
 | 2015-02-23 00:00:00
 | 2015-03-02 00:00:00
 | 2015-03-09 00:00:00
 | 2015-03-16 00:00:00
 | 2015-03-23 00:00:00
 | 2015-03-30 00:00:00
 | 2015-04-06 00:00:00
 | 2015-04-13 00:00:00
 | 2015-04-20 00:00:00
 | 2015-04-27 00:00:00
 | 2015-05-04 00:00:00
 | 2015-05-11 00:00:00
 | 2015-05-18 00:00:00
 | 2015-05-25 00:00:00
 | 2015-06-01 00:00:00
 | 2015-06-08 00:00:00
 | 2015-06-15 00:00:00
 | 2015-06-22 00:00:00
 | 2015-06-29 00:00:00
 | 2015-07-06 00:00:00
 | 2015-07-13 00:00:00
 | 2015-07-20 00:00:00
 | 2015-07-27 00:00:00
Spreadsheet: 41296d1239792899-vlookup-from-multiple-sheets-shift-schedule
Sheet: ELECTRICAL

ELECTRICAL
[NAME]. | SAP NO. | NAME | SECTION
 | 231 |  |  | A
 | 172 |  |  | A
 | 165 |  |  | A
 | 158 |  |  | B
 | 416 |  |  | B
 | 1231 |  |  | B
 | 261 |  |  | C
 | 1542 |  |  | C
 | 505 |  |  | C
 | 1254 |  |  | G
 | 1637 |  |  | G
 | 1775 |  |  | G
 | 1213 |  |  | G
 | 1438 |  |  | G
 | 1377 |  |  | G
 | 2085 |  |  | G
 |  | 'A' SHIFT
 |  | 'B' SHIFT
 |  | 'C' SHIFT
 |  | 'G' SHIFT
 |  | TOTAL:
Spreadsheet: 06e4d155-c764-45ff-b9c9-47451425a0b2
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: |  |  | 2013-08-12 09:32:55.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
4.625 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.5 | 101.442 | 101.317 | 101.192 | 100.817
4.375 | 100.597 | 100.472 | 100.347 | 99.972 |  | Note: | Refer To Price [NAME]
4.25 | 100.04 | 99.915 | 99.79 | 99.415 |  |  | For all Price Adjs
4.125 | 99.324 | 99.199 | 99.074 | 98.449
4 | 98.433 | 98.308 | 98.183 | 97.558
3.875 | 97.504 | 97.379 | 97.254 | 96.629
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.125 | 102 | 101.875 | 101.5
3.75 | 101.908 | 101.783 | 101.658 | 101.283
3.625 | 101.555 | 101.43 | 101.305 | 100.93
3.5 | 101.084 | 100.959 | 100.834 | 100.459
3.375 | 100.393 | 100.268 | 100.143 | 99.518
3.25 | 99.627 | 99.502 | 99.377 | 98.752
3.125 | 98.74 | 98.615 | 98.49 | 97.865 |  | Minimum loan amount:
3 | 98.185 | 98.06 | 97.935 | 97.31 |  | 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 | 2013-08-26 09:32:55.040000
30 DAY | 2013-09-10 09:32:55.040000
45 DAY | 2013-09-25 09:32:55.040000
60 DAY | 2013-10-10 09:32:55.040000
90 DAY | 2013-11-09 09:32:55.040000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 853502d1703352273-bond-portfolio-automation-bondportfolio_automated3
Sheet: Example2

 | Transactions
 | Side | Date | Type | ISIN | Ticker | Ccy | Maturity | Cpn% | CpnFqcy | Notional ($) | Date | PRICE
 | B | 2019-03-22 00:00:00 | Bond | US900123CT57 | TURKEY 7.625 2029 | USD | 2029-04-26 00:00:00 | 7.625 | 2 | 300000 | 2019-03-24 00:00:00 | 85 |  | 43616 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 54483 | 8.7 | 2 | 300000 | 43618 | 100
 | B | 2019-05-31 00:00:00 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 2049-03-01 00:00:00 | 8.7 | 2 | 300000 | 2019-06-02 00:00:00 | 100 | S | 43714 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 54483 | 8.7 | 2 | -300000 | 43716 | 111
 | S | 2019-09-06 00:00:00 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 2049-03-01 00:00:00 | 8.7 | 2 | -300000 | 2019-09-08 00:00:00 | 111 | B | 43899 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 54483 | 8.7 | 2 | 400000 | 43901 | 108
 | S | 2019-10-18 00:00:00 | Bond | US900123CT57 | TURKEY 7.625 2029 | USD | 2029-04-26 00:00:00 | 7.625 | 2 | -300000 | 2019-10-20 00:00:00 | 92 | S | 43902 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 54483 | 8.7 | 2 | -300000 | 43904 | 95
 | B | 2020-03-01 00:00:00 | Bond | US900123AY60 | TURKEY 6.875 2036 | USD | 2036-03-17 00:00:00 | 6.875 | 2 | 200000 | 2020-03-03 00:00:00 | 89 | S | 43924 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 54483 | 8.7 | 2 | -200000 | 43926 | 94
 | B | 2020-03-09 00:00:00 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 2049-03-01 00:00:00 | 8.7 | 2 | 400000 | 2020-03-11 00:00:00 | 108
 | B | 2020-03-09 00:00:00 | Bond | XS1910828182 | NIGERIA 9.248 2049 | USD | 2049-01-21 00:00:00 | 9.248 | 2 | 400000 | 2020-03-11 00:00:00 | 85
 | B | 2020-03-09 00:00:00 | Bond | XS1750114396 | OMAN 6.75 2048 | USD | 2048-01-17 00:00:00 | 6.75 | 2 | 500000 | 2020-03-11 00:00:00 | 92
 | S | 2020-03-12 00:00:00 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 2049-03-01 00:00:00 | 8.7 | 2 | -300000 | 2020-03-14 00:00:00 | 95
 | S | 2020-03-12 00:00:00 | Bond | XS1910828182 | NIGERIA 9.248 2049 | USD | 2049-01-21 00:00:00 | 9.248 | 2 | -200000 | 2020-03-14 00:00:00 | 93
 | B | 2020-03-31 00:00:00 | Bond | XS1750114396 | OMAN 6.75 2048 | USD | 2048-01-17 00:00:00 | 6.75 | 2 | 300000 | 2020-04-02 00:00:00 | 88
 | S | 2020-04-03 00:00:00 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 2049-03-01 00:00:00 | 8.7 | 2 | -200000 | 2020-04-05 00:00:00 | 94
 | Portfolio
 | X | Date | Type | ISIN | Ticker | Ccy | Maturity | Cpn% | CpnFqcy | Notional ($) | Date | PRICE
 |  |  | Bond | US900123AY60 | TURKEY 6.875 2036 | USD | 2036-03-17 00:00:00 | 6.875 | 2 | 200000 | 2020-03-03 00:00:00 | 89
 |  | 2020-03-09 00:00:00 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 2049-03-01 00:00:00 | 8.7 | 2 | 100000 | 2020-03-11 00:00:00 | 108
 |  | 2020-03-09 00:00:00 | Bond | XS1910828182 | NIGERIA 9.248 2049 | USD | 2049-01-21 00:00:00 | 9.248 | 2 | 200000 | 2020-03-11 00:00:00 | 85
 |  | 2020-03-09 00:00:00 | Bond | XS1750114396 | OMAN 6.75 2048 | USD | 2048-01-17 00:00:00 | 6.75 | 2 | 800000 | 2020-03-11 00:00:00 | 92
Spreadsheet: 85231d1285263349-auto-fill-based-on-other-sheet-autofill
Sheet: Sheet2

ID Number | Name | Invoice | Level | Course | Comp | Books | Program | Include
1111 | [NAME] | 18907 | Basic | 920000 | 80000 | 40000 | [NAME]
1111 | [NAME] | 19823 | Basic 1 | 920000 | 80000 | 40000 | Oct - Jan 2011
1111 | [NAME] | 20034 | Basic 2 | 920000 | 80000 | 40000 | Feb - May 2011
1122 | [NAME] | 18941 | Intermediate 1 | 920000 | 80000 | 40000 | Feb - May 2010 | 5
1122 | [NAME] | 48941 | Intermediate 2 | 920000 | 80000 | 40000 | [NAME] | 6
1122 | [NAME] | 12312 | Intermediate 3 | 920000 | 80000 | 40000 | Oct - Jan 2011 | 7
1122 | [NAME] | 36546 | Intermediate 4 | 920000 | 80000 | 40000 | Feb - May 2011 | 8
1122 | [NAME] | 61253 | Intermediate 5 | 920000 | 80000 | 40000 | [NAME] | 9
1122 | [NAME] | 32123 | Intermediate 6 | 920000 | 80000 | 40000 | Oct - Jan 2012 | 10
1122 | [NAME] | 23111 | Intermediate 7 | 920000 | 80000 | 40000 | Feb - May 2012 | 11
1122 | [NAME] | 56466 | Intermediate 8 | 920000 | 80000 | 40000 | [NAME] | 12
1122 | [NAME] | 23116 | Intermediate 9 | 920000 | 80000 | 40000 | Oct - Jan 2013 | 13