tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 848345d1699057018-exclude-negative-number-from-date-difference-test
Sheet: MASTER

 | 2023 |  | % Case Aide Usage |  |  | % DME Usage |  |  | [NAME] (Transferred) |  |  | Cases Sent Back for Correction |  |  | Avg Days Asgn to Opened | Avg Days Open to Current | Avg Days Move Current to [NAME] | Avg Days Intake Assigned to Transfer Out |  | 2024 |  | % Case Aide Usage |  |  |  |  | % DME Usage |  |  | [NAME] (Transferred) |  |  | Cases Sent Back for Correction |  |  | Cases Sent Back for Correction |  |  | Avg Days Asgn to Opened | Avg Days Open to Current | Avg Days Move Current to [NAME] | Avg Days Intake Assigned to Transfer Out
 | ALI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALI
 | BALL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BALL
 | DENNY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DENNY
 | KLEE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KLEE
 | MARSH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MARSH
 | RIDOLFI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RIDOLFI
 | RULE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RULE
 | SMITH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SMITH
 | VANDENBURGH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VANDENBURGH
 |  |  |  |  |  |  |  | case aids - total transferred
Spreadsheet: 107927d1305059908-excel-2007-headcount-based-on-date-and-start-stop-times-copy-of-manpower-2
Sheet: Data

Entry Date | First Name | Last Name | St amrt Time | End Time
2011-05-09 00:00:00 | APRIL | [NAME] | 06:30:00 | 15:00:00
2011-05-09 00:00:00 | MONTY | ADAMS | 07:00:00 | 15:30:00
2011-05-09 00:00:00 | THOMAS | BARNES | 09:00:00 | 12:00:00
2011-05-09 00:00:00 | PETER | PIPER | 10:00:00 | 18:30:00
2011-05-10 00:00:00 | APRIL | [NAME] | 06:30:00 | 15:00:00
2011-05-10 00:00:00 | MONTY | ADAMS | 07:00:00 | 15:30:00
2011-05-10 00:00:00 | PETER | PIPER | 10:00:00 | 18:30:00
2011-05-11 00:00:00 | APRIL | [NAME] | 06:00:00 | 14:30:00
2011-05-11 00:00:00 | MONTY | ADAMS | 07:00:00 | 15:30:00
2011-05-11 00:00:00 | THOMAS | BARNES | 09:00:00 | 12:00:00
2011-05-11 00:00:00 | PETER | PIPER | 10:00:00 | 18:30:00
2011-05-12 00:00:00 | APRIL | [NAME] | 06:30:00 | 15:00:00
2011-05-12 00:00:00 | MONTY | ADAMS | 07:00:00 | 15:30:00
2011-05-12 00:00:00 | THOMAS | BARNES | 09:00:00 | 12:00:00
2011-05-12 00:00:00 | PETER | PIPER | 11:00:00 | 19:30:00
2011-05-13 00:00:00 | APRIL | [NAME] | 06:30:00 | 15:00:00
2011-05-13 00:00:00 | MONTY | ADAMS | 07:00:00 | 15:30:00
2011-05-13 00:00:00 | THOMAS | BARNES | 09:00:00 | 12:00:00
2011-05-13 00:00:00 | PETER | PIPER | 10:00:00 | 18:30:00
Spreadsheet: 62829d1263836345-is-this-type-of-copy-even-possible-test4-1-
Sheet: REC

Sub | SOP Name | Identifier | Responsible | Due Date | Authored | Approved | Submitted
DATA311 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA312 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA313 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA314 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA315 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA316 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA317 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA318 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA319 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA320 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA321 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
[NAME] | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA323 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA324 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA325 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA326 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA327 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA328 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA329 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA330 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA331 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA332 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA333 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA334 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA335 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA336 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA337 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
[NAME] | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA339 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA340 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA341 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA342 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA343 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA344 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA345 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
Spreadsheet: 140026d1328597544-parameter-of-specific-formulas-automatically-into-excel-sheet-book1
Sheet: Sheet1

text 1 |  | text 2
IF(AND(A2>=0,A2<=17), -2.42113 *(A2)^5 + 118.86272 *(A2)^4 - 2123.97608 *(A2)^3 + 16475.45073 *(A2)^2 - 42279.29719 *(A2) + 33369.98344,IF(AND(A2>=18,A2<=32),1.0271296 *(A2)^5 - 131.997141 *(A2)^4 + [PHONE] *(A2)^3 - 170542.560289 *(A2)^2 + 2144134.3847458*(A2) - 10420910.9560574,IF(AND(A2>=33,A2<=50),-[PHONE] *(A2)^6 + [PHONE] *(A2)^5 - [PHONE] *(A2)^4 + 50585.[PHONE] *(A2)^3 - 1463750.08508272 *(A2)^2 + 22414736.0176103 *(A2) - 141550785.040264,328286))) |  | 123*AA100
Helper column | Result | Helper column | Result
32 | -2.42113 | 4 | 123
52 | 118.86272
73 | -2123.97608
95 | 16475.45073
117 | -42279.29719
169 | 1.0271296
190 | -131.997141
213 | 6734.9126986
237 | -170542.560289
262 | 2144134.3847458
323 | -0.0421471269
346 | 9.9702044355
371 | -975.9603106615
398 | 50585.0367640155
425 | -1463750.08508272
452 | 22414736.0176103
Spreadsheet: 715542d1611761027-rounding-numbers-based-on-if-function-excel
Sheet: Sheet1

Actual number | What I want
1.4 | 1.4
1.45 | 1.5
2.32 | 2.3
5.25 | 5.25
1.88 | 1.9
1.9 | 1.9
1.64 | 1.6
38.33 | 38
45.75 | 46
23.64 | 24
Spreadsheet: 668698d1584982272-re-formatting-data-listed-within-columns-to-rows-format-file-03232020
Sheet: Current Format

NAME | Pattern 1 | Pattern 2 | Pattern 3 | Pattern 4 | Pattern 5
5746REG100-911 CallbackHG | 8510887 | 9742333 | 9220907 | 8634041 | 9255794
5746REG100-Main-HG | 8710350 | 9801311 | 9551395 | 8173389 | 9891337
5746REG100-Night-HG | 9128378 | 9649330 | 8287195 | 8943926
5746REG101-911 CallbackHG | 9853564 | 8445840 | 8140671 | 9579221
Spreadsheet: 536786d1504687653-summary-report-from-data-sheet-summary-1-
Sheet: DATA

Date | Code | Particulars | Qty | a | b | c | d | e | Total | Helper Colum
 | KPS25 | SLB 335 mm
2058-02-02 00:00:00 | 25 | Ram | 200.000 KGS | 10 | 120 | 9600 | 0 | 25 | 9745
 | JSP29 | KLP 9 mm
2058-08-08 00:00:00 | 33 | TSMP | 40.000 KGS | 5 | 125 | 256 | 0 | 12 | 393
2058-08-08 00:00:00 | 41 | KSM | 70.000 KGS | 4 | 65 | 65 | 0 | 12 | 77
 |  | Hum Total : | 110 |  | 190 | 321 | 0 | 24 | 470
 | MS06 | JSP 11 mm
2058-02-04 00:00:00 | 22 | Johny | 8.500 KGS | 65 | 42 | 2 | 0 | 2 | 46
2058-01-06 00:00:00 | 64 | Ram | 200.000 KGS | 26 | 25 | 4 | 0 | 40 | 69
2058-01-07 00:00:00 | 32 | Jasmine | 100.000 KGS | 75 | 11 | 2 | 0 | 35 | 48
2058-01-26 00:00:00 | 42 | Johny | 500.000 KGS | 6 | 25 | 1 | 0 | 12 | 38
2058-02-04 00:00:00 | 36 | Johny | 200.000 KGS | 3 | 63 | 5 | 0 | 12 | 80
2059-03-04 00:00:00 | 77 | Karim | 650.000 KGS | 2 | 7 | 6 | 0 | 10 | 23
 |  | Hum Total : | 1658.5 |  | 173 | 20 | 0 | 111 | 304
Spreadsheet: 812741d1673354821-production-shortages-excel-test-
Sheet: Day 4 Question

Q1. The Iist has employee names and badge#s of XYZ Inc. |  |  |  |  |  |  | Q2. The Table below has a density chart for a perticular chemical compound. Write a formula to obtain the closest temperature based on any given Density
Their Manager name in found in the other table, you will need to use the employee badge to lookup their manager in the manager table
Employee Table |  |  |  |  |  |  | Density | Viscosity | Temperature
Name | Badge# | Manager |  |  |  |  | 0.457 | 3.55 | 500
Prashanth, [NAME] | 87423 |  |  |  |  |  | 0.525 | 3.25 | 400
Tank, Ashwini | 78312 |  |  |  |  |  | 0.606 | 2.93 | 300
Suri, Aviral | 98722 |  |  |  |  |  | 0.675 | 2.75 | 250
Kumar, [NAME] | 12235 |  |  |  |  |  | 0.746 | 2.57 | 200
Tendulkar, Sachin | 23972 |  |  |  |  |  | 0.835 | 2.38 | 150
Maradonna, Diego | 56431 |  |  |  |  |  | 0.946 | 2.17 | 100
Singh, [NAME] | 98362 |  |  |  |  |  | 1.09 | 1.95 | 50
Kumar, Deepak | 18739 |  |  |  |  |  | 1.29 | 1.71 | 0
 |  |  |  |  |  |  |  | Density | Temperature
 |  |  |  |  |  |  |  | 0.45
 |  |  |  |  |  |  |  | 0.55
 |  |  |  |  |  |  |  | 0.65
 |  |  |  |  |  |  |  | 0.7
 |  |  |  |  |  |  |  | 0.999
Spreadsheet: louise_kitchen__22810__NETCO gas pipeline contracts
Sheet: Central

NETCO Contracts Needed to Establish for Day 1
Central Desk
Pipeline | Rate Schedule |  | Service Description | Timing Estimate
ANR Pipeline Company | IPLS |  | IPLS (PARK/LEND) | 2 weeks
ANR Pipeline Company | PTS-1 |  | POOLING
ANR Pipeline Company | ITS |  | IT TRANSPORT
ANR Pipeline Company |  |  | EDI process
CONSUMERS (LDC) | I |  | TITLE TRANSFER | 2 weeks
Great Lakes Transmission LP | IT |  | IT TRANSPORT | 2 weeks
Great Lakes Transmission LP | MC |  | PARK & LOAN (STORAGE)
MICHCON (LDC) | I |  | IT TRANSPORT | 2 weeks
Natural Gas Pipeline Co. | TT |  | TITLE TRANSFER | 2 weeks
Natural Gas Pipeline Co. | ITS |  | IT TRANSPORT
Natural Gas Pipeline Co. | NSS |  | NSS STORAGE
Northern Border Pipeline Co. | IT-1 |  | Interruptible Transportation | 2 weeks
Northern Border Pipeline Co. | I |  | [NAME]
Northern Natural Gas Co. | TI |  | Interruptible Transportation | 2 weeks
Northern Natural Gas Co. | MPS |  | Pooling
Northern Natural Gas Co. | IDD |  | Storage
Northern Natural Gas Co. | TT |  | [NAME]
NIGAS (LDC) |  |  | POOLING | 2 weeks
NIPSCO (LDC) | no title transfer |  |  | 2 weeks
OneokNG | I |  | Pooling & Transport | 2 weeks
PEPL | EIT, I, GPS |  | it, pooling, park/lend | 2 weeks
RELIANT  (LDC) | PS, IT, FT |  | pooling, transport | 2 weeks
PEOPLES (LDC)
Trunkline Gas Company | TABS |  | TABS POOLING | 2 Weeks
Trunkline Gas Company | IT |  | IT TRANSPORT
Trunkline Gas Company | I |  | IT
Transcanada Gas Pipeline | I |  | IT | 2 weeks
Union Gas | IT |  | IT Transport | 2 weeks
Union Gas | I |  | Park/Loan
Spreadsheet: 86577d1286525343-inventory-stock1
Sheet: SCREENS

S.No | [NAME] | SICREEN SIZE | SERIAL NO | QTY
 | DA-LITE |  |  |  | BACK
1 | DA-LITE COSMO-TNST Fixed frame screen |  |  | 1
2 | DA-LITE DR-SNAP Fixed frame screen | 65 X 113 |  | 1
3 | DA-LITE DR-SNAP Fixed frame screen | 65 X 116 |  | 1
4 | DA-LITE DR-SNAP  [NAME] screen | 54 X 96"(110 Dig) | 94322V | 1
 | LIBERTY
1 | Liberty matt white wall screen | 64 X 84" |  | 1
2 | Liberty matt white wall screen | 70 X 70" |  | 1
3 | Liberty wall instalock screen | 6 X 8 |  | 20
4 | Liberty Wall instalock [NAME] white screen | 10 X 8 |  | 1
5 | wall screen | 60 X 87" | 0 3724344/ 4380 | 2
 | Indian Type
1 | [NAME] gain screen | 6 X 4(52 X 70") |  | 7
2 | [NAME] |  |  | 8
3 | Wall high gain screen | 6 X 4 (52 X 70") |  | 2
4 | Wall high gain screen | 8 X 6 |  | 1
5 | Tripod high gain screen | 8 X 6 |  | 1
6 | Tipod high gain with 2 stnds | 6 X 8 |  | 1
7 | wall instalock screen | 5 X 7 |  | 1
8 | map type economy | 6 X 4 |  | 3
9 | wall instalock high gain | 6 X 4 |  | 11
10 | wall economy | 6 X 4 |  | 1
11 | map type high gain | 6 X 8 |  | 1
12 | map type high gain | 6 X 4 |  | 3
13 | wall [NAME] white instalock screen | 50 X 50" |  | 1
14 | Manhole projector screen [NAME] | 120" |  | 1
15 | Wall Projection Screens (Indian Type) | 6 X 8 |  | 8
16 | Wall Projection Screens (Indian Type) | 72 X 90 |  | 1
17 | MAP Type | 6 X 8 |  | 41
18 | [NAME] high gain wall screen | 10 X 8 |  | 3
19 | Map high gain rental | 10 X 8 |  | 1
20 | Map type economy screen | 10 X 8 |  | 2
21 | Map type wall economy | 10 X 8 |  | 1
22 | Back projection economy | 10 X 8 |  | 1
23 | Back projection economy | 8 X 6 |  | 1
24 | map type high gain wall screen | 5 X 5 |  | 2
25 | map type economy | 6 X 4 |  | 1
 | BRAUN |  |  |  | BACK
1 | tripod screen | 6 X 6 |  | 1
2 | wall [NAME] white | 6 X 4 ( 180X135cm) | YM698062/74 | 2
4 | wall projection screen [NAME] | 5 X 7 (200X150 cm) |  | 2
5 | motorised screen | 8 X 6  ( 240X180 cm) | YM700740/ 731 | 2
7 | [NAME] beaded screen | 1.53X1.53mt |  | 1
 | tripod screen mat white(183x244) | 6x8 | 699581 | 1
 | GALA fixed frame screens
1 | 6X4 fixed frame screen | 6 X 4 |  | 2
2 | 5X7 fixed frame screen | 5 X 7 |  | 3
3 | white area + border extra | 54 X 96" |  | 1
4 | white area + border extra | 53 X 93" |  | 1
5 | With border | 1549X 2890cm |  | 1
 | Not useful
1 | 8X6 Wall mount economy | 8 X 6 |  | 3
2 | wall high gain | 6 X 4 |  | 1
3 | wall high gain | 6 X 4 |  | 2
4 | wall economy | 6 X 4 |  | 1
 | [NAME]
1 | Grand view Projector screen | 120" |  | 1
 | BACK
Spreadsheet: 875875d1722504437-quote-template-help-paul_t-hole-template-9_57am-365-aligw
Sheet: Sheet1

(COMPLEXITY LEVEL →) |  | LEVEL 1 | LEVEL 2 | LEVEL 3
(BAND DESCRIPTION) | BAND | HOURS | HOURS | HOURS
1 TO 6 HOLES | A | 2.75 | 3 | 3.25
6 TO 12 HOLES | B | 2.25 | 2.5 | 2.75
12 TO 20 HOLES | C | 1.75 | 2 | 2.25
20 TO 30 HOLES | D | 1.25 | 1.5 | 1.75
30 TO 50 HOLES | E | 1 | 1.25 | 1.5
50 TO 100 HOLES | F | 0.75 | 1 | 1.25
HOURLY RATE | £20 PER HOUR
 |  |  |  |  | TOOL NUMBER | NUMBER OF HOLES | COMPLEXITY | TOTAL COST
 |  |  |  |  | ABC1234 | 27 | LEVEL 2 |  | SHOULD BE 27(NO OF HOLES)  x 1.5 (LEVEL FACTOR) x 20 (HOURLY RATE)
 |  |  |  |  | DEF5678 | 5 | LEVEL 3 | 325
 |  |  |  |  | HIJ91011 | 72 | LEVEL 1 | 1080
Spreadsheet: 870037d1716545155-sumifs-criteria-not-working-v3
Sheet: AVERAGE

 | WEEKKLY TOTAL
 |  | 2024-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | job of offers
 | SITE | Total number of employers | Health & Adult Social Care | Construction | Hospitality | Manufacturing | Haulage & Logistics | Other | Total number of vacancies [E] | Number of Interview's available [F] | Number of interviews Attended [G] | Health & Adult Social Care [2] | Construction [3] | Hospitality [4] | Manufacturing [5] | Haulage & Logistics [6] | Other [7] | Total Job Offers [H] | Number of Jobs Fairs [I] | Number of employers at Jobs Fair [J] | Number of vacancies at Jobs Fair [K] | Number of customers attending Jobs Fair [L] | Number of job offers from Jobs Fair [M] | Number of Employers Participating in Campaign [N] | New Employers Participating in Campaign [O] | Health & Adult Social Care [3] | Construction [4] | Hospitality [5] | Manufacturing [6] | Haulage & Logistics [7] | Other [8] | Number of Vacancies [S] | Number of Jobs Fairs [T] | Number of Job Offers [U] |  | MJ&O updated TRUE | MJ&O updated FALSE
 | [NAME]
 | Ealing
 | Fulham
 | Harlesden
 | [NAME]
 | [NAME]
 | Hounslow
 | Kingston
 | Queens Park
 | [NAME]
 | [NAME]
 | Uxbridge
 | Wandsworth
 | Wembley
 | OTHERS
 | District Office
 | [NAME]
 | TOTAL
 |  |  |  |  |  |  | Offers Vs Vacancies |  |  | Attended Vs Available slots |  | Offers Vs Attended
 | MONTH: WEEK COMMENCING AVERAGE
 | SITE | Total number of employers | Health & Adult Social Care | Construction | Hospitality | Manufacturing | Haulage & Logistics | Other | Total number of vacancies [E] | Number of interviews available [F] | Number of interviews Attended [G] | Health & Adult Social Care [2] | Construction [3] | Hospitality [4] | Manufacturing [5] | Haulage & Logistics [6] | Other [7] | Total Job Offers [H] | Number of Jobs Fairs [I] | Number of employers at Jobs Fair [J] | Number of vacancies at Jobs Fair [K] | Number of customers attending Jobs Fair [L] | Number of job offers from Jobs Fair [M] | Number of Employers Participating in Campaign [N] | New Employers Participating in Campaign [O] | Health & Adult Social Care [3] | Construction [4] | Hospitality [5] | Manufacturing [6] | Haulage & Logistics [7] | Other [8] | Number of Vacancies [S] | Number of Jobs Fairs [T] | Number of Job Offers [U] |  | MJ&O updated TRUE | MJ&O updated FALSE
 | [NAME]
 | Ealing
 | Fulham
 | Harlesden
 | [NAME]
 | [NAME]
 | Hounslow
 | Kingston
 | Queens Park
 | [NAME]
 | [NAME]
 | Uxbridge
 | Wandsworth
 | Wembley
 | District Office
 | [NAME]
 | TOTAL
 |  |  |  |  |  |  | Offers Vs Vacancies |  |  | Attended Vs Available slots |  | Offers Vs Attended
Spreadsheet: sara_shackleton__36367__Isdaswap
Sheet: ANEWSWP2

ISDA SWAP AGREEMENT INFORMATION SHEET
 |  | ATTORNEY: | [NAME]
DATE: |  | DEAL MAKER: | [NAME]
COUNTERPARTY: | PacifiCorp | CONTACT:
ADDRESS: | 9951 SE Ankeny | TITLE:
 | Portland, Oregon 97216 | PHONE:
 |  | FAX:
Incorporation State | Oregon | S&P Rating | A
STRUCTURE | COUNTERPARTY | ECT
GUARANTOR (RATING)
LIMIT $ MILLIONS
Incorporation State
COLLATERAL  THRESHOLD MATRIX in $ MILLIONS
based on S & P and
Moody's ratings
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | X | X
Cash | X | X
Treasuries/Maturity limit
MINIMUM TRANSFER $ | 1 | 1
COLLATERAL ROUNDING
Delivery Amount | 250000 | 250000
Return Amount | 250000 | 250000
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty
-Guarantor
Debt Ratings Change |  | X | Tied to EnronCorp
-Below = S&P/Moody's | BBB- | BBB-
Financial Covenants
-Funded Debt to Worth
-Minimum Net Worth
-EBITDA/Interest Expense
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME])
-Guarantor ($[NAME]) |  | 50
Change in ownership
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: | NO:
OTHER COMMENTS:
Please contact [NAME] with any questions.
GLOBAL CREDIT:  Please complete the attached form below if the following conditions exist:
A)  No previous guidance limit exists or .....
B)  The proposed contractual limits exceed the existing guidance limits.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | X3-3565
Spreadsheet: 783982d1655321632-tracking-inventory-production-sales-feeding-and-purchases-example
Sheet: Crop & Feed Inventory

[NAME]:
Purchased Crop/Feeds: | IFNA(IF(LOOKUP(B1,'Feed & Livestock Purchases'!$B$4:$P$4)=B1,B1,IF(LOOKUP(B1,'Feed & Livestock Purchases'!$B$4:$P$4)<>B1,??????????????????????????
Beginning Inventory | 500 |  |  | 15000 |  | 10000 | 20000 | 700 |  | 500 | 8000 |  | 8000 | 2500 | 5000
Produced | 500 | 12000 | 7000 | 15000 | 2000 | 4000 |  | 1500 | 1000 | 2000 | 9000 | 5000 | 35000 | 7500 | 30000
PURCHASED
January
February
March
April
May
June
July
August
September
October
November
December
Total Purchased
SOLD
January
February
March
April
May
June
July
August
September
October
November
December
Total Sold
FED
January | 100
February | 100
March | 100
April | 125
May
June
July
August
September
October
November | 100
December | 125
Total Fed
Crop/Feedstuff:
Ending Inventory
Value per Unit ($) | 200 | 7 | 50 | 7 | 6 | 12 | 23 | 150 | 150 | 150 | 6 | 5 | 15 | 100 | 11
Total Value
 | Crop & Feed List
 | [NAME]
 | [NAME]
 | Alfalfa, Baleage
 | Barley, Feed
 | Barley, Forage
 | Barley, Malting
 | Barley, Silage
 | Beans, Black
 | Beans, Dry
 | Beans, Edible
 | Beans, Faba
 | Beans, Garbonzo
 | Beans, [NAME]
 | Beans, Pinto
 | Beans, Red
 | Beet Tailings
 | [NAME]
 | Buckwheat
 | Canola
 | Canola Meal
 | Corn Silage
 | Corn, Ear
 | Corn, Flint
 | Corn, Grain
 | Cover Crop Mix
 | CRP
 | DDGS, dry
 | DDGS, modified
 | DDGS, wet
 | Einkorn
 | [NAME]
 | Field Peas
 | Flax
 | Flax, [NAME]
 | Flax, [NAME]
 | Hay
 | Hay, Baleage
 | Hay, Clover
 | Hay, Grass
 | Hay, Green Chop
 | Hay, Mixed
 | Hay, Small Grain
 | Hay, Small Grain/Legume Mix
 | Hay, Sudangrass
 | Haylage, [NAME]
 | Haylage, Clover
 | Haylage, [NAME]
 | Haylage, Mixed
 | Haylage, Small Grain
 | Haylage, Sudangrass
 | Midds
 | Millet, Grain
 | Mineral & Salt
 | Oatlage
 | Oats
 | Oats, Hulless
 | Pasture
 | Pelleted Feed
 | Pellets
 | Pellets, ______
 | Potatoes
 | Prevented Planting
 | Radishes
 | Rapeseed
 | Rented Out
 | Rye
 | Rye, Cover Crop
 | Rye, Silage
 | Screenings
 | Screenings, ______
 | Small Grain Silage
 | Sorghum
 | Sorghum Silage
 | Soybean Meal
 | Soybeans
 | Soybeans, Food
 | Soybeans, [NAME]
 | Spelt
 | Stover
 | Straw
 | Sunflower Meal
 | Sunflower, Confectionary
 | Sunflower, Oil
 | Triticale
 | Triticale, Silage
 | Vegetables
 | Vetch
 | Wheat, Durum
 | Wheat, Spring
 | Wheat, White
 | Wheat, Winter
Spreadsheet: 3c35d3b0-d82f-40f7-b3b4-1cb4dad6da32
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-10-04 15:05:22.410000
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.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.25 | 101.432 | 101.307 | 101.182 | 100.807
4.125 | 101.062 | 100.937 | 100.812 | 100.437 |  | Note: | Refer To Price [NAME]
4 | 100.667 | 100.542 | 100.417 | 100.042 |  |  | For all Price Adjs
3.875 | 100.14 | 100.015 | 99.89 | 99.265
3.75 | 99.247 | 99.122 | 98.997 | 98.372
 |  |  |  |  |  | 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.714 | 101.589 | 101.464 | 101.089
3.75 | 101.237 | 101.112 | 100.987 | 100.612
3.625 | 100.874 | 100.749 | 100.624 | 100.249
3.5 | 100.521 | 100.396 | 100.271 | 99.896
3.375 | 100.121 | 99.996 | 99.871 | 99.246
3.25 | 99.584 | 99.459 | 99.334 | 98.709
 |  |  |  |  |  | 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-18 15:05:22.410000
30 DAY | 2011-11-02 15:05:22.410000
45 DAY | 2011-11-17 15:05:22.410000
60 DAY | 2011-12-02 15:05:22.410000
90 DAY | 2012-01-01 15:05:22.410000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 1acbc5b5-eba7-43ce-aba6-394b78c6d600
Sheet: MICRO

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD DEFINED | # | ASSESSED COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | Program | 1 | X | 1 | X | 1 | X | 1 | X | 1
 | TOTAL
 | PERCENTAGE
 | COURSE
1 | MICRO 102 | 1 | X | 1 | X | 1 | 5 | 1 | 2 | 1
1 | MICRO 150 | 1 | X | 1 | X | 1 | 5 | 1 | 2 | 1
5 | MICRO 247X4 | 1 | X | 1
5 | MICRO 248X4 | 1 | X | 1
 | TOTAL
 | PERCENTAGE