tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 756087d1637266929-count-based-by-a-list-of-conditions-and-skip-empty-cells-count_restarrt_skip
Sheet: Sheet1

conditions list |  |  | data cells |  | expected results
cond1 |  | cond5 | [NAME]
[NAME] |  |  | data2
cond3 |  | cond3 | data3
cond4 |  |  | data4
cond5 |  |  | data5
 |  | cond1 | [NAME]
 |  |  | data7
 |  |  | data8
 |  |  | data9
 |  | cond5 | data10
 |  |  | data11
 |  |  | data12
 |  | [NAME] | data 13
 |  |  | data14
 |  |  | data15
 |  |  | data16
 |  |  | data17
 |  |  | data18
Spreadsheet: 171604d1343786508-how-can-i-move-certain-bits-of-text-from-a-cell-to-a-different-column-extract
Sheet: Sheet2

amazon.com
products.amazon.co.uk.org
amazon.co.uk
ebay.co.uk
wikipedia.org
wikipedia.fr
wikipedia.fr
Spreadsheet: 456567d1460954429-add-employee-name-to-schedule-based-on-shift-and-date-schedule24
Sheet: Employee List

Employee Name | Dept
[NAME] | 13700
Fred | 13000
Damon | 14000
[NAME] | 12000
Marcelo | 13700
A | 1
B | 2
C | 3
D | 4
E | 5
Spreadsheet: 275223d1383403832-extract-unique-values-from-a-table-and-list-along-a-row-example-data
Sheet: Sheet1

Date | Advertiser | Product | Cost |  | Advertisers
2013-10-01 00:00:00 | [NAME] | cereal1 | 22.271696 |  | [NAME]
2013-10-01 00:00:00 | [NAME] | cereal2 | 261.504502 |  | Nike
2013-10-01 00:00:00 | [NAME] | cereal4 | 0.291496 |  | Ford
2013-10-01 00:00:00 | Nike | trainer1 | 3.506025
2013-10-01 00:00:00 | Nike | trainer1 | 22.820761 |  | Advertiser drop-down | [NAME]
2013-10-01 00:00:00 | Ford | car3 | 2.69254
2013-10-02 00:00:00 | [NAME] | cereal 1 | 5.966141 |  | Cost output table
2013-10-02 00:00:00 | [NAME] | cereal 5 | 104.278315 |  |  |  |  |  |  |  | .....
2013-10-02 00:00:00 | Nike | trainer1 | 0.142326
2013-10-02 00:00:00 | Nike | trainer2 | 26.325024
2013-10-02 00:00:00 | Nike | trainer3 | 122.196729
2013-10-02 00:00:00 | Ford | car3 | 3.190125
2013-10-02 00:00:00 | Ford | car7 | 0 |  | Advertiser | [NAME]
2013-10-03 00:00:00 | [NAME] | cereal4 | 3.190125
2013-10-03 00:00:00 | Nike | trainer3 | 26.325024 |  |  | Product
 |  |  |  |  | Date | cereal 1 | cereal 5 | cereal1 | cereal2 | cereal4
 |  |  |  |  | 2013-10-01 00:00:00
 |  |  |  |  | 2013-10-02 00:00:00
 |  |  |  |  | 2013-10-03 00:00:00
 |  |  |  |  | Grand Total
Spreadsheet: 882663d1731065086-how-to-remove-contra-entries-from-data-sample
Sheet: MOVEMENT

DATE | NAME | Case no | DR | CR
2024-06-30 00:00:00 | a | 11697 | 20000 | 0
2024-06-30 00:00:00 | a | 11697 | 0 | 20000
2024-06-30 00:00:00 | b | 52766 |  | 65000
2024-01-12 00:00:00 | c | 56644 | 4500 | 0
2024-06-28 00:00:00 | c | 56644 | 0 | 4500
2024-06-30 00:00:00 | c | 56644 |  | 4500
2023-07-15 00:00:00 | d | 56677 | 1250000 | 0
2023-10-05 00:00:00 | d | 56677 | 1250000 | 0
2023-10-05 00:00:00 | d | 56677 | 1250000 | 0
2023-10-05 00:00:00 | d | 56677 | 0 | 1250000
2023-10-05 00:00:00 | d | 56677 | 0 | 1250000
2023-10-06 00:00:00 | d | 56677 | 0 | 1250000
2023-10-18 00:00:00 | d | 56677 | 1250000 | 0
2023-10-24 00:00:00 | d | 56677 | 0 | 1250000
2023-11-06 00:00:00 | d | 56677 | 0 | 1250000
2023-11-06 00:00:00 | d | 56677 | 1250000 | 0
2024-04-05 00:00:00 | e | 57910 | 10000 | 0
2024-04-24 00:00:00 | e | 57910 | 0 | 10000
2024-04-16 00:00:00 | f | 58559 | 108000 | 0
2024-05-24 00:00:00 | f | 58559 | 0 | 108000
2023-10-31 00:00:00 | g | 59427 | 97000 | 0
2023-10-31 00:00:00 | g | 59427 | 0 | 97000
2023-10-31 00:00:00 | g | 59427 | 0 | 97000
Spreadsheet: 696407d1600796237-formula-for-monthly-cash-flow-reserve-sweeps-sample-for-reserves-2
Sheet: Sheet1

Table 1
 | Month 1 | Month 2 | Month 3 | Month 4
Cash Flow | 85002.81425097081 | 116062.7574509708 | 147122.7006509709 | 131794.2786509708
Reserved
Cash Flow After Reserve
Reserve Amount | 200000
I am looking for a formula that calculates how much Reserve is taken out of cash flow each month to get to the Reserve Amount.
In this examlpe I have done the calculation myself, but if you change the Resreve Amount to $500,000, the example doesn't work anymore, because it shows a negative Distributable Cash Flow amount.
I'd like to have one formula in Row 7 extending across all months that take Cash Flow until it reaches the Reserve Amount.
Table 2
 | Month 1 | Month 2 | Month 3 | Month 4
Cash Flow | 85002.81425097081 | 116062.7574509708 | 147122.7006509709 | 131794.2786509708
Reserved |  |  |  | 0
Cash Flow After Reserve
Reserve Amount | 300000
I need an formula for row 7 (in table 1) and/ or row 24 (in table 2) that automatically calculates the Resreved amount to take Cash Flow until the reserve it met.
Right now I'm doing the calculaiton myself, but I change the reserve amount, row 24 doesn’t change b/c I don't know how to get it to calculate
Spreadsheet: 767376d1644431771-auto-populate-cells-dependant-on-multiple-inputs-tracker1
Sheet: Training

 | Date of Training | Type of Training | Training provided by | Employee | Division | Valid for (Years) | [NAME] | Cost (CAD)
 | 2022-02-16 00:00:00 | [NAME] | AIP Safety | [NAME] | PreFrab | 3 |  | 125 |  | Compare Type of Training and training provided by to give valid years, expirery date, and cost
 | 2022-02-16 00:00:00 | [NAME] | AIP Safety | [NAME] | PreFrab | 3 |  | 125
 | 2022-02-22 00:00:00 | Forklift Initial Training | AIP Safety | [NAME] | PreFrab | 3 |  | 160
 | 2022-02-22 00:00:00 | Forklift Initial Training | AIP Safety | [NAME] | PreFrab | 3 |  | 160
 |  |  |  |  |  | ^                             ^                               ^  To populate depending on Type of Training and Training provided by
Spreadsheet: 709109d1608164178-matching-different-dates-with-same-item-sample-example-multi-match-same-id-5-
Sheet: Outcomes

ID # | Name | Outcome Dates | Intake Date + Per Prior Formula | Length of Stay | Intake Date - Standard Index and Match |  |  | Desired Intake Date
A825492 | Luna | 2020-12-31 12:40:00 |  |  |  | Same Date
A826166 | *Ophelia | 2020-12-28 16:49:00 |  |  |  | Same Date
A825492 | Luna | 2020-12-20 10:55:00 |  |  |  | Same Date
A825863 | *Poppet | 2020-12-16 19:15:00 |  |  |  | Same Date
A825700 |  | 2020-12-14 19:15:00 |  |  |  | Same Date
A826166 | *Ophelia | 2020-12-12 14:48:00 |  |  |  | Same Date
A825863 | *Poppet | 2020-12-12 08:36:00 |  |  |  | Same Date
A825653 | [NAME] | 2020-12-10 13:38:00 |  |  |  | Same Date
A826771 |  | 2020-12-04 16:13:00
[NAME] | [NAME] | 2020-12-03 16:37:00
A826774 |  | 2020-12-03 16:30:00
A826773 |  | 2020-12-03 16:21:00
A825653 | [NAME] | 2020-12-02 14:28:00 |  |  |  | Same Date
A826777 |  | 2020-12-01 17:38:00
A826772 |  | 2020-12-01 16:18:00
A825700 |  | 2020-12-01 15:32:00 |  |  |  | Same Date
A825700 |  | 2020-10-01 12:52:00 |  |  |  | Same Date
Spreadsheet: 886872d1736970963-compare-and-highlight-data-from-two-reports-test2
Sheet: Sheet1

Employee Identifier | First Name | Last Name | Position | Location | Job | Manager | Legal Entity
200 | Test1 | Test | Project Delivery - Senior Platform Engineer | Remote - Project Delivery | Senior Platform Engineer | Test 20 | Test Co
201 | Test2 | Test | Project Delivery - Senior Platform Engineer | Remote - Project Delivery | Senior Platform Engineer | Test 21 | Test Co
203 | Test3 | Test | Facility Operations - Director, Operations North America | Remote - Facility Operations | Director, Operations North America | Test 22 | Test Co
213 | Test10 | Test | Project Delivery - Senior Platform Engineer | Remote - Project Delivery | Senior Platform Engineer | Test 22 | Test Co
204.333333333333 | Test4 | Test | Facility Operations - Physical Security Program Manager | Remote - Facility Operations | Physical Security Program Manager | Test 23 | Test Co
205.833333333333 | Test5 | Test | Project Delivery - Project Manager | Remote - Project Delivery | Project Manager | Test 24 | Test Co
207.333333333333 | Test6 | Test | Investment and Capital Mkts - Director of Investments | Remote - Investment and Capital Mkts | Director of Investments | Test 25 | Test Co
208.833333333333 | [NAME] | Test | Executive - Chief Investment Officer | Remote - Executive | Chief Investment Officer | Test 26 | Test Co
210.333333333333 | Test8 | Test | Project Delivery - Project Manager | Remote - Project Delivery | Project Manager | Test 27 | Test Co
211.833333333333 | Test9 | Test | Investment and Capital Mkts - Associate of Investments | Location 1 | Associate of Investments | Test 28 | Test Co
Spreadsheet: monique_sanchez__28309__curves
Sheet: Sheet4

CurveGrp-> | IF-ELPO/PERMIAN | IF-ELPO/SJ | IF-HEHUB | IF-NWPL_ROCKY_M | IF-WAHA-TX | NG | NGI-MALIN | NGI-SOCAL | GDP-CAL BORDER | GDP-ELPO/PERM2 | GDP-ELPO/SANJUA | GDP-HEHUB | GDP-MALIN-CTYGA
Curve->
Risk-> | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | PRC | [NAME] | [NAME] | IM | IM | IM | IM | IM
PubCode->
DealType->
2001-05-01 00:00:00 | 0.019 | -0.661 | -0.021 | -0.791 | -0.071 | 4.348 | 5.049 | 10.049 | 0 | 0 | 0 | 0 | 0
2001-05-26 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12.01 | 3.86 | 3.04 | 4.01 | 4.91
2001-05-27 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12.01 | 3.86 | 3.04 | 4.01 | 4.91
2001-05-28 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12.01 | 3.86 | 3.04 | 4.01 | 4.91
2001-05-29 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12.01 | 3.86 | 3.04 | 4.01 | 4.91
2001-05-30 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12.01 | 3.86 | 3.04 | 4.01 | 4.91
2001-05-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12.01 | 3.86 | 3.04 | 4.01 | 4.91
Jun, 2001 | -0.06 | -0.74 | 0.005 | -1.29 | -0.05 | 3.99 | 2.35 | 7.85 | 0 | 0 | 0 | 0 | 0
Jul, 2001 | 0.03 | -0.675 | 0 | -1.35 | 0.015 | 4.03 | 3.37 | 7.5 | 0 | 0 | 0 | 0 | 0
Aug, 2001 | 0.045 | -0.675 | 0 | -1.34 | 0.03 | 4.125 | 3.2 | 7.53 | 0 | 0 | 0 | 0 | 0
Sep, 2001 | 0.035 | -0.685 | 0 | -1.33 | 0.025 | 4.18 | 2.88 | 6.91 | 0 | 0 | 0 | 0 | 0
Oct, 2001 | -0.015 | -0.445 | 0 | -0.91 | -0.025 | 4.215 | 3.33 | 5.57 | 0 | 0 | 0 | 0 | 0
Nov, 2001 | 0.02 | -0.265 | 0 | -0.37 | 0 | 0 | 3.17 | 5.3 | 0 | 0 | 0 | 0 | 0
Dec, 2001 | 0.02 | -0.265 | 0 | -0.37 | 0 | 0 | 4.42 | 5.3 | 0 | 0 | 0 | 0 | 0
Jan, 2002 | 0.02 | -0.265 | 0 | -0.37 | 0 | 0 | 4.69 | 5.26 | 0 | 0 | 0 | 0 | 0
Feb, 2002 | 0.02 | -0.265 | 0 | -0.37 | 0 | 0 | 1.25 | 3.91 | 0 | 0 | 0 | 0 | 0
Mar, 2002 | 0.02 | -0.265 | 0 | -0.37 | 0 | 0 | 0.95 | 2.41 | 0 | 0 | 0 | 0 | 0
Apr, 2002 | 0 | 0 | 0 | -0.82 | 0 | 0 | 0 | 1.725 | 0 | 0 | 0 | 0 | 0
May, 2002 | 0 | 0 | 0 | -0.82 | 0 | 0 | 0 | 1.125 | 0 | 0 | 0 | 0 | 0
Jun, 2002 | 0 | 0 | 0 | -0.82 | 0 | 0 | 0 | 1.225 | 0 | 0 | 0 | 0 | 0
Jul, 2002 | 0 | 0 | 0 | -0.82 | 0 | 0 | 0 | 1.695 | 0 | 0 | 0 | 0 | 0
Aug, 2002 | 0 | 0 | 0 | -0.82 | 0 | 0 | 0 | 1.695 | 0 | 0 | 0 | 0 | 0
Sep, 2002 | 0 | 0 | 0 | -0.82 | 0 | 0 | 0 | 1.695 | 0 | 0 | 0 | 0 | 0
Oct, 2002 | 0 | 0 | 0 | -0.82 | 0 | 0 | 0 | 0.845 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 6b337a5f-0689-4ef1-a827-e02223952054
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FSCMS | Test | FSCMS | Synthetic Cannabinoid Metabolites Screen - Expanded, [NAME] | Synthetic Cannab Metab Scr, [NAME], U | Enzyme-Linked Immunosorbent Assay (ELISA) High Performance Liquid Chromatography/Tandem Mass Spectrometry (LC-MS/MS) | Preservative-free plastic urine container |  |  |  |  | Collect 10 mL random urine. Send urine refrigerated in a preservative-free plastic urine container. | 4.8 mL | Hemolysis:	NA Thawing:	Warm OK; Cold OK Lipemia:	NA Icterus:	NA Other:	NA | Test					Reference Range		Units   NMS Labs SynCann Screen 1		None Detected			ng/mL  NMS Labs SynCann Screen 3		None Detected			ng/mL  PB-22 3-Carboxyindole metabolite	None Detected			ng/mL  Synonym(s):	1-pentylindole-3-carboxylic acid  MAM-2201 Pentanoic acid metabolite	None Detected			ng/mL  Synonym(s):	5-[3-(4-methylnaphthalene-1carbonyl)indol-1-yl]pentanoic acid; JWH-122 Pentanoic acid metabolite  F-PB-22 Carboxyindole Metabolite	None Detected			ng/mL  Synonym(s):	1-(5-fluropentyl)indole-3-carboxylic acid   If Positive: Testing is complete. Report has been attached in Mayo Access.   Test Performed by:	NMS Labs 			3701 Welsh Road 			P.O. Box 433A 			Willow Grove, PA 19090-0437 | Monday, Wednesday, Friday | 3 days | 5 - 7 days | 2 | 80101 |  |  |  |  | NMS Labs
FSCMS | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 14 days
FSCMS | Result | FSCMS | Synthetic Cannab Metab Scr, [NAME], U | Synthetic Cannab Metab Scr, [NAME], U | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: eric_saibi__9884__102301R
Sheet: Ellwood 04

Owner Name |  | Ellwood Energy LLC
Station Name |  | Ellwood Merchant Generation
Unit Name |  | CT 04
NERC Region |  | MAIN
State |  | IL
Fuel Type |  | Nat. gas/Fuel Oil
Capacity |  | 150 MW
Start Date |  | 2001-10-06 00:00:00
End Date |  | 2001-10-10 00:00:00
Prv. Start Date |  | 2001-10-21 00:00:00
Prv. End Date |  | 2001-10-25 00:00:00
Comments |  | Boroscope.
SIC |  | 4911
Plant ID |  | 1035845
Unit ID |  | 1012558
Outage ID |  | 18028
Spreadsheet: 146893d1332406101-vlookup-and-hlookup-homework-tutor-requested-vlookup
Sheet: Sheet1

Activity 28: VLOOKUP FUNCTION
1. Refer to the lookup table below, demonstrate the use of vlookup function in determining
the price of the entered code.
 | Lookup Table
 | Code | Product | Price | Enter Product code here:
 | A23 | Paper | 5 |  |  | Price:
 | B14 | Lamp | 15
 | A27 | Desk | 75
 | C45 | Pencil | 0.5
2. With the given transmutation table below, determine the grades of the students by using Vlookup function
Tip: Modify the table so that you can perform the [NAME] function.
Transmutation Table |  |  |  |  | STUDENTS | RAW SCORES | EQUIVALENT  GRADE
RAW SCORE | GRADE |  |  |  | Student 1 | 78
0-8 | 5 |  |  |  | Student 2 | 95
8.5 - 14 | 4.75 |  |  |  | Student 3 | 88
14.5 - 20 | 4.5 |  |  |  | Student 4 | 74
20.5 - 26 | 4.25 |  |  |  | Student 5 | 75
26.5 - 32 | 4 |  |  |  | Student 6 | 85
32.5 - 38 | 3.75 |  |  |  | Student 7 | 88
38.5 - 44 | 3.5 |  |  |  | Student 8 | 90
44.5 - 49 | 3.25 |  |  |  | Student 9 | 97
49.5 - 57 | 3 |  |  |  | Student 10 | 50
57.5 - 64 | 2.75
64.5 - 70 | 2.5
70.5 - 76 | 2.25
76.5 - 82 | 2
82.5 - 87 | 1.75
87.5 - 92 | 1.5
92.5 - 96 | 1.25
96.5 - 100 | 1
Spreadsheet: 829338d1684151327-excel-table-look-up-help-test-tracker2
Sheet: Payments-Freight Summary

 | LLSZ
 | Select MO No. or Total below
 | [NAME]
 | Financials | Oct-22 | Nov-22 | Dec-22 | Jan-23 | Feb-23 | Mar-23 | Arp 23 | May-23 | Jun-23 | Jul-23 | Aug-23 | Sep-23 | Oct-23 | Nov-23 | Dec-23 | Jan-24 | Feb-24 | Mar-24 | Arp 24 | May-24 | Jun-24 | Jul-24 | Aug-24 | Sep-24 | Oct-24 | Nov-24 | Dec-24 | Jan-25 | Feb-25 | Mar-25 | Arp 25 | May-25 | Jun-25 | Jul-25 | Aug-25 | Sep-25 | Oct-25 | Nov-25 | Dec-25
 | Income (Invoice payments received)
 | Total Income (Total Invoice payments received - CFWD)
 | Assets Freighted (Value of models handed over to project
 | Total Assets Freighted (Total value of models handed over to project - CFWD
 | Balance
Spreadsheet: 08cecb6b-9aad-45e0-8682-d4b33a31253f
Sheet: Keyword-Pivot

Row Labels
ACCESS CONTROL
AIR COMPRESSOR
AIR CONDITIONING UNIT
AIR DRYER
AIR HANDLING UNIT
AUTOCLAVE
BACKFLOW PREVENTER
BATTERY
BLEACHERS
BLINDS
BOILER
BURNER
CASCADE SYSTEM
CHILLED BEAM
CHILLER
CHIMNEY
CLOCKS, BELLS AND TIMERS
COIL
CONTROLS
CONVEYANCE
[NAME]
DAMPER
DEFIBRILLATOR
DEHUMIDIFIER
DOCK EQUIPMENT
DOOR
DRAIN
DUST COLLECTOR WOOD, WELDING
ELECTRICAL SYSTEM
ELECTRICAL, CARBON MONOXIDE SYSTEM
EMERGENCY GENERATOR
EMERGENCY PHONE
EMERGENCY WASH STATION
ENERGY RECOVERY UNIT
ENVIRONMENTAL CHAMBER
FAN
FIELD
FILTRATION
FIRE ALARM
FIRE EXTINGUISHER
FIRE HYDRANT PRIVATE
FIRE SUPPRESSION SYSTEM
FIREESCAPE
FIREPLACE
FUME HOOD
FURNACE
GAS SYSTEM, MEDICAL, LAB, ETC.
[NAME]
HEAT EXCHANGER
HEAT RECOVERY UNIT
HEAT RECOVERY WHEEL
HEATER
HEPA UNIT
HOT WATER HEATER
HUMIDIFIER
[NAME]
ICEMAKER
IRRIGATION
KEY CONTROL BOX
LIGHTING
LIGHTNING PROTECTION
LOUVERS
MANHOLE
MASONRY SYSTEMS
METER
MONITORING SYSTEM
MOTORS
PH NEUTRALIZATION SYSTEM
PRESSURE VESSEL
PUMP
RAINWATER RECLAMATION SYSTEM
REFRIGERATION
REVERSE OSMOSIS DISTILLED WATER
ROOF
SCREEN
SOLAR SYSTEM
SOOT BLOWER
STEAM GENERATOR
STEAM TRAP
STRAINERS AND SEPARATORS
TANK
TERMINAL UNITS
TRANSFORMER
TREE
VALVE
VARIABLE FREQUENCY DRIVE
VEHICLE
WASHER
WATER SAMPLE COOLER
WATER SOFTNER
WATER SOURCE HEAT PUMP
WATER TREATMENT
(blank)
Spreadsheet: 887793d1738120112-pool-league-players-stats-spreadsheet-players_stats_-start-25
Sheet: Sheet1

 | KAMPOT SUNDAY POOL LEAGUE
 | PLAYERS SCORING TABLE
 | Player Name | Team | Wins | Losses | Total Games | Winning Percentage | Score | Rank
 | Sery | Roxy 1 | 10 | 10 | 0 | 100 | 1 | 1
 | Van |  | 10 | 9 | 1 | 90 | 4 | 4
 | Soven |  | 10 | 6 | 4 | 60 | 9 | 9
 | Ano | Fat Cats | 5 | 2 | 3 | 40 | 13 | 13
 | [NAME] |  | 5 | 4 | 1 | 80 | 7 | 7
 | Thea |  | 5 | 5 | 0 | 100 | 1 | 1
 | Picasso | Blue Moon 2 | 5 | 1 | 4 | 20 | 17 | 17
 | [NAME] |  | 5 | 1 | 4 | 20 | 17 | 17
 | [NAME] |  | 5 | 0 | 5 | 0 | 24 | 24
 | [NAME] | [NAME] | 10 | 9 | 1 | 90 | 4 | 4
 | Savy |  | 10 | 9 | 1 | 90 | 4 | 4
 | Lim |  | 10 | 6 | 4 | 60 | 9 | 9
 | [NAME] | Blue Moon 1 | 5 | 3 | 2 | 60 | 9 | 9
 | Cliff |  | 5 | 3 | 2 | 60 | 9 | 9
 | [NAME] |  | 5 | 2 | 3 | 40 | 13 | 13
 | Dennis | Roxy 2 | 5 | 2 | 3 | 40 | 13 | 13
 | [NAME] |  | 5 | 1 | 4 | 20 | 17 | 17
 | Rit |  | 5 | 1 | 4 | 20 | 17 | 17
 | [NAME] | [NAME] | 5 | 4 | 1 | 80 | 7 | 7
 | [NAME] |  | 5 | 1 | 4 | 20 | 17 | 17
 | Mark |  | 5 | 1 | 4 | 20 | 17 | 17
 | [NAME]
 | Steffen
 |  | Cool Girl Bar |  |  |  |  | 24 | 24
 |  |  |  |  |  |  | 24 | 24
 |  |  |  |  |  |  | 24 | 24
 |  |  |  |  |  |  | 24 | 24
 |  |  |  |  |  |  | 24 | 24
 | [NAME] | [NAME] 44 | 5 | 5 | 0 | 100 | 1 | 1
 | [NAME] |  | 5 | 1 | 4 | 20 | 17 | 17
 | Julie |  | 5 | 2 | 3 | 40 | 13 | 13
Spreadsheet: joe_parks__14978__BridgeDPR0515
Sheet: Bridgeline DPR2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRIDGELINE GAS MARKETING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD |  | Yesterday's MTD | Yesterday's QTD | Yesterday's YTD
BRIDGELINE GAS MARKETING
GAS TRADING |  |  | 15 Bcf |  |  |  |  |  |  | 2000
1 Month |  |  |  |  |  | 9 Bcf 1 Month
2-12 Months |  |  |  |  |  | 25 Bcf 2-12 Months
13-18 Months |  |  |  |  |  | 5 Bcf 13-18 Months
TOTAL TRADING
Notes to File
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTD | QTD | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA | 1504.839517000001 | 3507.839517000001 | 8798.839517
 |  |  |  |  |  |  |  |  |  |  |  |  | GAS TRADING | 1504.839517000001 | 3507.839517000001 | 8798.839517
 | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | -2243.48
 |  |  |  |  |  |  |  |  |  | 998027.0603850778
Spreadsheet: f12c3293-c4e3-4e93-bbe4-bd3fb1148155
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: |  |  | 2012-08-15 09:41:47.260000
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 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.074 | 100.949 | 100.824 | 100.449
3.75 | 101.008 | 100.883 | 100.758 | 100.383 |  | Note: | Refer To Price [NAME]
3.625 | 100.584 | 100.459 | 100.334 | 99.959 |  |  | For all Price Adjs
3.5 | 99.918 | 99.793 | 99.668 | 99.043
3.375 | 99.002 | 98.877 | 98.752 | 98.127
3.25 | 98.003 | 97.878 | 97.753 | 97.128
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 101.841 | 101.716 | 101.591 | 101.216
3.25 | 101.452 | 101.327 | 101.202 | 100.827
3.125 | 101.112 | 100.987 | 100.862 | 100.487
3 | 100.784 | 100.659 | 100.534 | 100.159
2.875 | 100.153 | 100.028 | 99.903 | 99.278
2.75 | 99.453 | 99.328 | 99.203 | 98.578
 |  |  |  |  |  | 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 | 2012-08-29 09:41:47.260000
30 DAY | 2012-09-13 09:41:47.260000
45 DAY | 2012-09-28 09:41:47.260000
60 DAY | 2012-10-13 09:41:47.260000
90 DAY | 2012-11-12 09:41:47.260000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 772908d1647523678-formula-for-time-difference-planner
Sheet: Sheet1

US Daylight Saving | Yes
Resource Name | Leader | Country State for US | Local Start Time | Local End Time | Start Time (EST) | End Time (EST)
[NAME] | Shivani | India | 15:30:00 | 23:00:00
[NAME] | Shivani | India | 1900-01-01 08:30:00 | 17:00:00
[NAME] | Shivani | India | 14:30:00 | 23:00:00
Annedore Hopf | Amanda | India | 10:00:00 | 18:00:00
Anshul Kumar | Shivani | India | 10:30:00 | 19:30:00
[NAME] | [NAME] | Malaysia | 08:00:00 | 17:00:00
Antonia Bronic | Amanda | Mexico | 10:00:00 | 18:00:00
Azreen binti [NAME] | Amanda | Netherlands | 17:00:00 | 1900-01-01 01:30:00
Carmen [NAME] | Victor | Phillipines | 07:00:00 | 15:00:00
[NAME] | Victor | India | 08:00:00 | 16:30:00
CinthyaEsmeralda GarciaMunguia | Victor | India | 09:00:00 | 17:00:00
[NAME] | Victor | India | 09:00:00 | 17:00:00
[NAME] | [NAME] | Japan | 1900-01-01 00:00:00 | 1900-01-01 09:00:00
[NAME] | [NAME] | US | 23:00:00 | 1900-01-01 08:00:00
Spreadsheet: 63554d1264452475-payroll-taxes-missyreiber3
Sheet: PENSION17

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Current | LIMIT
 | 2009-01-09 00:00:00 | 2009-02-09 00:00:00 | 2009-03-09 00:00:00 | 2009-04-09 00:00:00 | 2009-05-09 00:00:00 | 2009-06-09 00:00:00 | 2009-07-09 00:00:00 | 2009-08-09 00:00:00 | 2009-09-09 00:00:00 | 2009-10-09 00:00:00 | 2009-11-09 00:00:00 | 2009-12-09 00:00:00 | YTD TOTAL | Payroll | 41137
SMITH |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 3482.740626554648 | 41137 | 37654.25937344535
Spreadsheet: 141336d1329223695-copy-rows-to-new-sheet-summary-when-criteria-met-sample-data
Sheet: Sheet1

Item # | Status | Comments | Date | Hours
1 | c | [NAME] | 2012-02-07 00:00:00 | 40
 |  |  | 2012-02-08 00:00:00 | 20
2 | nc | tom | 2012-02-08 00:00:00 | 60
3 | pc | [NAME] | 2012-02-09 00:00:00 | 80
 |  |  | 2012-02-15 00:00:00 | 20
4 | c | [NAME] | 2012-02-10 00:00:00 | 100
5 | nc | [NAME] | 2012-02-11 00:00:00 | 120
Spreadsheet: 473937d1470511202-sort-formula-multiple-criteria-sort-formula-multiple-criteria
Sheet: Data

Group↓, Severance → | a | b | c | d | e |  | Owner | Acres
a | a |  |  |  |  |  | [NAME] | 55
c |  |  | c |  |  |  | [NAME] | 20.5
g |  | b
d | a |  |  |  |  |  | [NAME] | 160
a |  |  |  | d
g |  |  |  | d |  |  | [NAME] | 3.3333
a |  |  |  |  | e |  | Zach | 96
w |  |  | c
w |  | b |  |  |  |  | [NAME] | 10.45