tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 751371d1634062674-highlight-or-list-volunteers-who-having-been-assigned-volunteer-schedule
Sheet: Volunteers

Master List |  |  |  | Who's available on Monday | Who's available on Tuesday | Who's available on Wednesday | Who's available on Thursday | Who's available on Friday
Volunteer 1 |  |  |  | Volunteer 2 | Volunteer 10 | Volunteer 1 | Volunteer 16 | Volunteer 7
Volunteer 2 |  |  |  | Volunteer 5 | Volunteer 7 | Volunteer 3 | Volunteer 4 | Volunteer 9
Volunteer 3 |  |  |  | Volunteer 7 | Volunteer 16 | Volunteer 16 | Volunteer 9 | Volunteer 1
Volunteer 4 |  |  |  | Volunteer 10 |  | Volunteer 4 |  | Volunteer 8
Volunteer 5 |  |  |  | Volunteer 12 |  | Volunteer 9 |  | Volunteer 13
Volunteer 6 |  |  |  | Volunteer 16
Volunteer 7
Volunteer 8
Volunteer 9
Volunteer 10
Volunteer 11
Volunteer 12
Volunteer 13
Volunteer 14
Volunteer 15
Volunteer 16
Spreadsheet: 22920d1212098965-search-for-a-file-and-bring-back-data-to-master-spreadsheet-job-cost-summary
Sheet: Job Cost Summary

 |  |  | Materials-Steel & Misc |  |  |  | Materials-Joist & Deck |  |  |  | Fabrication Labor |  |  |  | Erection Labor |  |  |  | Subcontractors |  | Equipment Rental |  | Detailing |  |  |  | Detailing - Outside Contract
 | Latest | Project | Bid |  | Actual |  | Bid |  | Actual |  | Bid |  | Actual |  | Bid |  | Actual |  | Bid | Actual | Bid | Actual | Bid |  | Actual |  | Bid | Actual
Job # | Date | Name | Weight | Cost | Weight | Cost | Weight | Cost | Weight | Cost | Man Hrs | Cost | Man Hrs | Cost | Man Hrs | Cost | Man Hrs | Cost | Cost | Cost | Cost | Cost | Man Hrs | Cost | Man Hrs | Cost | Cost | Cost
4754 | 05/14/2008 07:56:32 AM | 4754  - Leander Elem School #19 |  |  | 145116 | 93393 |  |  | 0 | 52140 |  |  | 624.75 | 11672 |  |  | 2733.75 | 59868 |  | 11850 |  | 26333 |  |  | 153.5 | 3900 |  | 1800
4844 |  | 4844  - Pflugerville First Bapt Church
4875
4884
4890
4900
Spreadsheet: 817641d1676376732-lookup-value-with-multiple-criteria-example
Sheet: Sheet1

Number | 1 |  | using these drop downs, it should reference the below table, and then input results into the form below.
Price | 20
Colour | Red
 |  |  |  |  |  |  |  |  | Price
 |  |  |  |  |  |  |  |  | Colour
Number | Price | Colour | Material | shade |  |  |  |  | Material |  |  | Using the IF function it trys to apply to the same range of cells rather than lock it to a single cell…
1 | 10 | blue | plastic | dull |  |  |  |  | Shade
2 | 20 | black | metal | bright
3 | 30 | Red | glass | [NAME]
4 | 40 | green | wood
5 | 50
6 | 60
Spreadsheet: marie_heard__24505__IspatISDA071101
Sheet: ANEWSWP2

ISDA SWAP AGREEMENT INFORMATION SHEET
 |  | ATTORNEY:
DATE: |  | DEAL MAKER: | [NAME]
COUNTERPARTY: | Ispat Inland Inc | CONTACT:
ADDRESS: |  | TITLE:
 |  | PHONE:
 |  | FAX:
Incorporation State |  | S&P Rating
STRUCTURE | COUNTERPARTY | ENA
GUARANTOR (RATING) |  | Enron Corp.
LIMIT $ MILLIONS |  | 15
Incorporation State |  | OR
ELEGIBLE SWAP PARTICIPANT
Counterparty | X
Guarantor |  | X
COLLATERAL  THRESHOLD MATRIX in $ MILLIONS
based on S & P and
Moody's ratings | BB-
 | 5 | 10
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | X | X
Cash | X | X
Treasuries/Maturity limit
MINIMUM TRANSFER $ | 0 | 0
COLLATERAL ROUNDING
Delivery Amount | 250000 | 50000
Return Amount | 250000 | 50000
HOLDING and USE OF COLLATERAL
Permitted |  | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change |  | X
-Below = S&P/Moody's | BB- | BBB-
Financial Covenants
-Funded Debt to Worth | 04:00:00
-Minimum Net Worth | 350
-EBITDA/Interest Expense | 2.5x
-Funded Debt / EBITDA
Non-Specific
-Unilateral | X
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME]) | 50
-Guarantor ($[NAME]) |  | 100
Change in ownership
SPECIFIED ENTITY
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:
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] | x54842
Spreadsheet: 1474a546-1e41-494a-abb4-8eb36a6d89c0
Sheet: 1992

TYPE OF PERMIT | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | YR TOTAL
-------------- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --------
SINGLE FAMILY DET. | 37 | 46 | 66 | 55 | 45 | 27 | 52 | 42 | 46 | 44 | 25 | 27
$ [NAME] | 4116425 | 4793235 | 7064750 | 5754147 | 4742026 | 3255698 | 5799705 | 4112580 | 5551781 | 4889239 | 2808605 | 2740740
SINGLE FAMILY ATT. | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
$ [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DUPLEX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
$ [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
MULTI FAMILY UNITS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
$ [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
RESIDENTIAL ADD. | 1 | 1 | 2 | 0 | 0 | 0 | 10 | 13 | 6 | 8 | 3 | 8
$ [NAME] | 18000 | 15000 | 9300 | 0 | 0 | 0 | 9425 | 26638 | 13306 | 41070 | 25500 | 31100
COMMERCIAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0
$ [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50000 | 0
COMMERCIAL ADD/F.O. | 2 | 1 | 1 | 2 | 2 | 4 | 2 | 4 | 2 | 3 | 6 | 4
$ [NAME] | 56500 | 22000 | 20000 | 81000 | 76000 | 999000 | 21500 | 60000 | 42000 | 87750 | 286795 | 78200
INDUSTRIAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
$ [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PUBLIC BUILDINGS | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
$ [NAME] | 737720 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PUBLIC BLDG. ADD. | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 3 | 0 | 0 | 0 | 0
$ [NAME] | 0 | 0 | 0 | 0 | 0 | 9754 | 0 | 3100 | 0 | 0 | 0 | 0
TEMPORARY OFFICE | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 2 | 1 | 1 | 0 | 2
$ [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 0 | 9000
ACCESSORY BLDG. | 3 | 2 | 3 | 5 | 6 | 3 | 7 | 3 | 3 | 3 | 5 | 0
$ [NAME] | 3650 | 2340 | 1900 | 3800 | 6750 | 2434 | 5959 | 1650 | 3390 | 5900 | 9693 | 0
POOLS | 1 | 5 | 5 | 6 | 4 | 6 | 6 | 4 | 3 | 3 | 5 | 1
$ [NAME] | 11000 | 82284 | 82506 | 97825 | 63800 | 88075 | 84500 | 73058 | 66500 | 50500 | 93791 | 22000
SPAS | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 1 | 0
$ [NAME] | 0 | 0 | 0 | 0 | 2500 | 17000 | 0 | 0 | 0 | 0 | 1000 | 0
FENCES | 25 | 42 | 42 | 57 | 41 | 39 | 64 | 47 | 54 | 37 | 30 | 25
$ [NAME] | 19798 | 31166 | 37938 | 43748 | 34305 | 34890 | 53361 | 154379 | 51840 | 32640 | 22900 | 18154
SPRINKLER | 7 | 10 | 9 | 6 | 12 | 15 | 15 | 17 | 11 | 11 | 13 | 17
$ [NAME] | 8175 | 11425 | 16645 | 6149 | 14515 | 17175 | 24000 | 24500 | 14900 | 17750 | 16400 | 19600
SIGNS | 9 | 5 | 10 | 11 | 16 | 10 | 15 | 4 | 5 | 14 | 11 | 14
$ [NAME] | 4200 | 2500 | 15529 | 6330 | 30870 | 3485 | 11750 | 450 | 1400 | 2165 | 6250 | 12981
MOVING | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
$ [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DEMOLITION | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
$ [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL PERMITS
TOTAL DOLLAR VALUE
Spreadsheet: 875719d1722334364-summarise-date-from-three-sheets-based-on-conditions-excel-task
Sheet: Dropdowns

Ցածր | Ներկայացվում է | Այո | Այո | 1 | Այո, եղել է տարանջատված և ուսուցման նյութերը տարբերվել են կախված աշխատակիցների գործառույթներից: | Խորհուրդ
Միջին | Բացակայում է | Ոչ | Ոչ | 2 | Ոչ, բոլորին տրամադրվել է միևնույն ուսուցումը և օգտագործվել են միևնույն ուսուցման նյութերը: | Գործադիր մարմին | Ներկայացվել է էլեկտրոնային տարբերակով՝ առանց խորհրդին հանդիպելու: |  | Իրական ժամանակում ավտոմատացված համակարգերի միջոցով | Ներկայացվում է կանոնների ամբողջական ցանկը և նկարագրությունը | Ներկայացվում են համապատասխան ապացույցներ, որ ավտոմատացված համակարգում կարգաբերված են կանոններ | օրական | [NAME] նոր հաճախորդ ստեղծելիս կամ երբ հաճախորդը կատարում է գործարք
Բարձր |  |  | Մասնակի | 3 |  | Գործադրի մարմնի ղեկավար | Ներկայացվել է էլեկտրոնային տարբերակով, որին հաջորդել է խորհրդի հետ հանդիպում մանրամասները քննարկելու նպատակով: |  | Ձեռքով (օրինակ` excel) | Բացակայում է կանոնների ամբողջական ցանկը և նկարագրությունը | Չեն ներկայացվում համապատասխան ապացույցներ | շաբաթական | Շարունակական ([NAME] հաճախորդների բազան անմիջապես ստուգվում է, երբ ցանկում [NAME] է ունենում որևէ փոփոխություն)
Արգելված |  |  |  | 4 |  |  |  |  | [NAME] միասին Ձեռքով և իրական ժամանակում ավտոմատացված համակարգերի միջոցով: |  |  | ամսական | Շաբաթական  ([NAME] հաճախորդների բազան շաբաթական կտրվածքով ստուգվում է ցանկերի թարմացումների նկատմամբ)
 |  |  |  |  |  |  |  |  |  |  |  | այլ (խնդրում ենք նշել) | Ամսական ([NAME] հաճախորդների բազան ամսական կտրվածքով ստուգվում է ցանկերի թարմացումների նկատմամբ)
 |  |  |  |  |  |  |  |  |  |  |  |  | Տարեկան ([NAME] հաճախորդների բազան տարեկան կտրվածքով ստուգվում է ցանկերի թարմացումների նկատմամբ)
 |  |  |  |  |  |  |  |  |  |  |  |  | Այլ (խնդրում ենք նշել)
1
2
3
4
Spreadsheet: 787950d1658167898-cbbox-that-will-dynamically-show-current-year-month-and-year-2022-07-18-oeldere2-pb21uk-payments_to_qi-copy-1-
Sheet: Dashboard

 |  |  |  |  |  |  |  |  |  | Months |  | use |  |  | Months
 |  |  |  |  |  |  |  |  |  |  |  | Current Month Year |  |  | Jan
 |  |  |  |  |  |  |  |  |  |  |  | Current year |  |  | Feb
 |  |  |  |  |  |  |  | 7 |  |  |  | Current Month |  |  | Mar
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jun
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jul
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aug
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sep
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oct
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nov
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dec
Spreadsheet: darrell_schoolcraft__7321__imball0202
Sheet: Conoco

 | Maljamar |  | Zia |  |  |  |  |  |  |  |  | Avg
Day | Measured | Scheduled | Measured | Scheduled |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
1 | 63150 | 59999
2 | 64643 | 60000 |  |  |  |  | 2001-03-01 00:00:00 |  |  |  | 4.98
3 | 65489 | 60000 |  |  |  |  | 2001-04-01 00:00:00 |  |  |  | 4.87
4 | 61296 | 60000 | 1 |  |  |  | 2001-05-01 00:00:00 |  |  |  | 3.82
5 | 57384 | 60300 | 2 |  |  |  | 2001-06-01 00:00:00 |  |  |  | 3.2
6 | 38477 | 36000 | 25769 | 24300 |  |  | 2001-07-01 00:00:00 |  |  |  | 2.77
7 | 37958 | 42000 | 25600 | 30000
8 | 39372 | 37811 | 25610 | 29173
9 | 38862 | 38855 | 26702 | 30000
10 | 37175 | 38855 | 29335 | 30000
11 | 38725 | 38614 | 32471 | 29809
12 | 34768 | 37555 | 31798 | 28000
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  |  |  | 451518.05
2002-02-12 00:00:00
CBS Volume
 |  |  | 13684
Spreadsheet: 468193d1467172140-how-to-look-up-column-and-row-headings-that-match-table-value-how-to-look-up-column-and-row-headings-that-match-table-value-v2
Sheet: Football

16:45 - 17:00
 |  | Points | Ranking | Final points
 | 1 team
 | 2 team
 | 3 team
 | 4 team
17:00 - 17:15
 |  | Points | Ranking | Final points
 | 17 team
 | 18 team
 | 19 team
 | 20 team
17:15 - 17:30
 |  | Points | Ranking | Final points
 | 5 team
 | 8 team
 | 9 team
 | 14 team
17:30 - 17:45
 |  | Points | Ranking | Final points
 | 21 team
 | 24 team
 | 25 team
 | 30 team
17:45 - 18:00
 |  | Points | Ranking | Final points
 | 6 team
 | 11 team
 | 12 team
 | 15 team
18:00 - 18:15
 |  | Points | Ranking | Final points
 | 22 team
 | 27 team
 | 28 team
 | 31 team
18:15 - 18:30
 |  | Points | Ranking | Final points
 | 7 team
 | 10 team
 | 13 team
 | 16 team
18:30 - 18:45
 |  | Points | Ranking | Final points
 | 23 team
 | 26 team
 | 29 team
 | 32 team
Spreadsheet: 701236d1603642152-sum-frequency-if-blank-errors-sample
Sheet: Sheet1

USERNAME | DATE | #number |  |  | 2020-10-25 00:00:00
NAME1 | 2020-10-25 00:00:00
NAME2 | 2020-10-19 00:00:00
NAME3 | 2020-10-25 00:00:00 | 45221547
NAME3 | 2020-10-25 00:00:00
NAME2 | 2020-10-19 00:00:00 | 45221546
NAME1 | 2020-10-25 00:00:00 | 45221550
NAME1 | 2020-10-25 00:00:00 | 45221549
Spreadsheet: 484670d1476379436-case-when-testfile-1-
Sheet: MasterSheetFR

 |  | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 |  | 90 |  | 93 | 90 | 90 | 90 |  | 1.st
 |  | 88 | 88 | 88 | 88 | 88 | 88 | 88 | 88 |  | 88 |  | 90 | 88 | 88 | 88 |  | 2.nd
 |  | 85 | 85 | 85 | 85 | 85 | 85 | 85 | 85 |  | 85 |  | 88 | 85 | 85 | 85 |  | 3.rd
1
2
3
4
5
6
7
 |  |  |  |  | Your Formula
Spreadsheet: 787682d1657961017-calculate-average-from-irregular-matrix-table-sample-data
Sheet: Sheet4

 |  | 9 | 10 | 11
 | 9 |  |  |  |  |  |  | 9 | 9 | 9 | 9 | 10 | 10 | 11 | 11 | 11 | 11 | 11 | 11
 | 10 |  |  |  |  |  | 9 | 2 | 4 | 0 | 6 | 32 | 2 | 2 | 7 | 2 | 3 | 32 | 2
 | 11 |  |  |  |  |  | 9 | 5 | 4 | 2 | 36 | 2 | 3 | 5 | 8 | 6 | 4 | 22 | 3
 |  |  |  |  |  |  | 9 | 2 | 6 | 1 | 7 | 7 | 7 | 6 | 43 | 3 | 34 | 4 | 4
 |  |  |  |  |  |  | 9 | 7 | 8 | 6 | 2 | 5 | 52 | 7 | 6 | 6 | 3 | 56 | 6
 |  |  |  |  |  |  | 10 | 8 | 3 | 5 | 3 | 5 | 7 | 3 | 27 | 7 | 4 | 56 | 6
 |  |  |  |  |  |  | 10 | 2 | 8 | 37 | 3 | 6 | 8 | 4 | 8 | 2 | 3 | 3 | 4
 |  |  |  |  |  |  | 10 | 9 | 2 | 9 | 4 | 99 | 66 | 7 | 5 | 7 | 34 | 2 | 3
 |  |  |  |  |  |  | 10 | 6 | 1 | 0 | 5 | 2 | 4 | 8 | 4 | 8 | 2 | 12 | 2
 |  |  |  |  |  |  | 11 | 4 | 7 | 53 | 7 | 3 | 3 | 4 | 3 | 76 | 2 | 3 | 1
 |  |  |  |  |  |  | 11 | 6 | 4 | 3 | 22 | 6 | 7 | 2 | 5 | 5 | 4 | 5 | 2
 |  |  |  |  |  |  |  | 9 | 10 | 11
 |  |  |  |  |  |  | 9
 |  |  |  |  |  |  | 10
 |  |  |  |  |  |  | 11
Spreadsheet: 8a6eea8c-8d9b-43d5-91d2-8a36b884c0e9
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-02-15 09:19:38.880000
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.25 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.125 | 101.933 | 101.808 | 101.683 | 101.308
4 | 101.485 | 101.36 | 101.235 | 100.86 |  | Note: | Refer To Price [NAME]
3.875 | 100.579 | 100.454 | 100.329 | 99.954 |  |  | For all Price Adjs
3.75 | 99.874 | 99.749 | 99.624 | 98.999
3.625 | 99.421 | 99.296 | 99.171 | 98.546
3.5 | 98.915 | 98.79 | 98.665 | 98.04
 |  |  |  |  |  | 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.625 | 101.985 | 101.86 | 101.735 | 101.36
3.5 | 101.645 | 101.52 | 101.395 | 101.02
3.375 | 101.104 | 100.979 | 100.854 | 100.479
3.25 | 100.458 | 100.333 | 100.208 | 99.833
3.125 | 99.843 | 99.718 | 99.593 | 98.968
3 | 99.499 | 99.374 | 99.249 | 98.624
2.875 | 98.926 | 98.801 | 98.676 | 98.051 |  | 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-02-29 09:19:38.880000
30 DAY | 2012-03-15 09:19:38.880000
45 DAY | 2012-03-30 09:19:38.880000
60 DAY | 2012-04-14 09:19:38.880000
90 DAY | 2012-05-14 09:19:38.880000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 849838d1700220145-xlookup-advanced-test
Sheet: Options Tracking

OPENED | SYMBOL | [NAME] | STRIKE | ACTION | QTY | COST BASIS | EXIT | CLOSED | COLLATERAL | P/L | MAX ROC | ACTUAL ROC | ANNUAL ROC | ASSGND STRK | NOTES
 | XOM | 2023-11-10 00:00:00 | 105 | ASSIGNED | 2 | 21000
 | LLY | 2023-12-15 00:00:00 | 550 | STO PUT | 1 | 5.8 | 3.42
 | SOFI | 2023-12-08 00:00:00 | 6.5 | STO PUT | 3 | 0.19
 | XOM | 2023-11-24 00:00:00 | 103 | STO PUT | 1 | 1.1
 | TSLA | 2023-11-17 00:00:00 | 220 | STO PUT | 2 | 1.01 | 0.36
 | TSLA | 2023-12-15 00:00:00 | 200 | STO PUT | 1 | 1.79
 | XOM | 2023-11-17 00:00:00 | 106 | STO CALL | 2 | 0.29 | 0.02 |  |  |  |  |  |  | 105
 | CVX | 2023-11-24 00:00:00 | 142 | STO PUT | 1 | 0.87
 | CVX | 2023-11-24 00:00:00 | 143 | STO PUT | 1 | 0.92
 | WMT | 2023-11-17 00:00:00 | 160 | STO PUT | 2 | 0.31 |  |  |  |  |  |  |  |  | ER PLAY
 | XOM | 2023-12-01 00:00:00 | 106 | STO CALL | 2 | 0.61 |  |  |  |  |  |  |  | 105
Spreadsheet: darrell_schoolcraft__7802__imbalsumm0108
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 87555 | 87075
2 | 98252 | 97649
3 | 78608 | 77218
4 | 101009 | 100503
5 | 90729 | 89600
6 | 91681 | 90563
7 | 105225 | 103990
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | 24378
2001-08-07 00:00:00
CBS Volume
 |  |  | -42473
Spreadsheet: tracy_geaccone__40213__EGA fcst
Sheet: August 29

(Millions of Dollars)
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Revised |  | Prior |  | From Prior
 |  |  |  |  |  | Forecast |  | Forecast |  | Forecast |  | Plan
Income Before Int. Expense & Income Taxes * |  |  |  |  |  | -12.6
Interest Expense
 | 3rd Party interest expense |  |  |  |  | 9.4
 | Intercompany capital charge expense (income) |  |  |  |  | 15.1
 | Other intercompany interest expense (income) |  |  |  |  | 16.7
 | Other - including capitalized interest |  |  |  |  | 0
Minority Interest |  |  |  |  |  | 1.4
Pre-tax income
Income Tax |  |  |  |  |  | -14.4
Net Income before Financing Costs
[NAME] (items greater than $1.0) |  |  |  |  |  |  |  |  |  | Interest |  |  |  | Net
 |  |  |  |  |  |  |  | IBIT |  | Expense |  | Taxes |  | Income
Prior Forecast
 | [NAME] |  |  |  |  |  |  | 0 |  | 0 |  | 0
 | [NAME] |  |  |  |  |  |  | 0 |  | 0 |  | 0
 | Other |  |  |  |  |  |  | 0 |  | 0 |  | 0
Current Forecast
*    INCOME BEFORE INTEREST EXPENSE AND INCOME TAXES INCLUDES OUTSIDE (NOT INTERCOMPANY)
INTEREST INCOME.
Spreadsheet: 91918d1291615294-trying-to-pull-only-certian-data-from-a-list-to-a-summary-sheet-sample
Sheet: Summary

The PivotTables can be copied and
then have their source changed by
right clicking on them, choosing
PivotWizard, hitting back, and putting
in the new source (ie. Month3!Data)
 | Period 1 |  | Period 2
 | Part # | Qty | Part # | Qty
These 4 rows should probably be
hidden as they're technically part of
the PivotTables. | Qty |  | Qty
 | Part | Total | Part | Total
 | 1 | 7 | 1 | 2
 | 2 | 1 | 5 | 12
 | 3 | 8 | 6 | 1
 | 4 | 3 | 7 | 4
 | 5 | 11 | AB | 5
 | 6 | 2 | 8 | 6
 | 7 | 1 | 9 | 1
 | AB | 3 | CD | 3
 | Grand Total | 36 | R1 | 1
 |  |  | Grand Total | 35
Spreadsheet: john_griffith__16112__1_22_02OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO G2 | 51 | 270 | 340 | 51.7 | 65.2 | 1.87 | 2002-01-22 12:10:00
 | [NAME] | 52 | 640 | 700 | 50.7 | 55.5 | 1.74 | 2002-01-22 12:10:00
 | HO J2 | 52 | 825 | 900 | 48.6 | 53.1 | 1.66 | 2002-01-22 12:10:00
 | HO K2 | 52 | 950 | 1050 | 45.9 | 50.8 | 1.58 | 2002-01-22 12:10:00
 | HO M2 | 53 | 1100 | 1200 | 45 | 49.1 | 1.57 | 2002-01-22 12:10:00
 | HO N2 | 53 | 1150 | 1250 | 42.7 | 46.5 | 1.49 | 2002-01-22 12:10:00
 | HO Q2 | 54 | 1200 | 1325 | 40.1 | 44.3 | 1.43 | 2002-01-22 12:10:00
 | HO U2 | 55 | 1300 | 1400 | 39.5 | 42.6 | 1.42 | 2002-01-22 12:10:00
 | [NAME] | 56 | 1300 | 1450 | 36.6 | 40.8 | 1.36 | 2002-01-22 12:10:00
 | HO X2 | 57 | 1350 | 1500 | 35.2 | 39.2 | 1.33 | 2002-01-22 12:10:00
 | [NAME] | 58 | 1375 | 1525 | 33.7 | 37.5 | 1.3 | 2002-01-22 12:10:00
 | HO F3 | 58 | 1400 | 1600 | 33 | 37.7 | 1.29 | 2002-01-22 12:10:00
 | [NAME] |  |  |  | 33.2 | 36.5 | 1.31 | 2001-12-31 13:18:00
 | HO H3
 | HO J3 |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | [NAME]
Spreadsheet: 30ea38f2-31ad-4492-bc34-6108625f03c7
Sheet: Sheet1

Offenders | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Sex
by Offense Category, 2011
Offense Category | Total Offenders1 | Sex
 |  | Male | Female | Unknown
Total | 4483142 | 2852538 | 1068154 | 562450
Crimes Against Persons | 1302160 | 928937 | 350869 | 22354
[NAME] | 1207239 | 843193 | 343799 | 20247
Homicide Offenses | 4482 | 3608 | 540 | 334
Kidnapping/Abduction | 16156 | 13513 | 2410 | 233
Sex Offenses, Forcible | 67550 | 62546 | 3575 | 1429
Sex Offenses, Nonforcible | 6733 | 6077 | 545 | 111
Crimes Against Property | 2351209 | 1285649 | 532806 | 532754
[NAME] | 10736 | 6775 | 1306 | 2655
Bribery | 358 | 255 | 102 | 1
Burglary/Breaking & Entering | 330730 | 186904 | 33836 | 109990
Counterfeiting/Forgery | 68336 | 36268 | 25821 | 6247
Destruction/Damage/Vandalism | 445632 | 254342 | 74913 | 116377
Embezzlement | 18184 | 9292 | 8588 | 304
Extortion/Blackmail | 1277 | 925 | 301 | 51
Fraud Offenses | 167875 | 83307 | 54288 | 30280
Larceny/Theft Offenses | 1074312 | 535074 | 304878 | 234360
Motor Vehicle Theft | 84215 | 46314 | 11206 | 26695
Robbery | 107763 | 94045 | 8859 | 4859
[NAME] Offenses | 41791 | 32148 | 8708 | 935
Crimes Against Society | 829773 | 637952 | 184479 | 7342
Drug/Narcotic Offenses | 727131 | 555958 | 166256 | 4917
Gambling Offenses | 2286 | 1793 | 462 | 31
Pornography/Obscene Material | 5623 | 4515 | 866 | 242
Prostitution Offenses | 12832 | 4921 | 7878 | 33
Weapon Law Violations | 81901 | 70765 | 9017 | 2119
1Does not include 1,710,479 incidents with Unknown Offenders. Offenders are counted once for each offense type to which they are connected.
Spreadsheet: 863730d1711118399-converting-model-data-table-simulation-dj
Sheet: Sheet10

Table 1 |  |  |  |  |  |  |  |  | Solution Excel 365 |  |  |  | Answer Expected |  |  |  | Solution Excel 2021
Name | Item 1 | Item 2 | Item 3 | Item 4 | Total items due date on march 2024 | answer |  |  | Name | Item Type | Due date |  | Name | Item Type | Due date |  | Name | Item Type | Due date
a | 2024-03-19 00:00:00 |  |  |  |  | 1 |  |  |  | Item 1 | 2024-03-19 00:00:00 |  | a | Item 1 | 2024-03-19 00:00:00
b |  | 2024-03-19 00:00:00 | 2024-03-30 00:00:00 |  |  | 2 |  |  | b | Item 2 | 2024-03-19 00:00:00 |  | b | Item 2 | 2024-03-19 00:00:00 |  | b | Item 2 | 2024-03-19 00:00:00
c | 2024-01-30 00:00:00 | 2024-03-12 00:00:00 |  |  |  | 1 |  |  | b | Item 3 | 2024-03-30 00:00:00 |  | b | Item 3 | 2024-03-30 00:00:00 |  | b | Item 3 | 2024-03-30 00:00:00
d |  |  |  |  |  | 0 |  |  | c | Item 1 | 2024-01-30 00:00:00 |  | c | Item 1 | 2024-01-30 00:00:00 |  | c | Item 1 | 2024-01-30 00:00:00
e |  |  | 2024-06-30 00:00:00 |  |  | 0 |  |  | c | Item 2 | 2024-03-12 00:00:00 |  | c | Item 2 | 2024-03-12 00:00:00 |  | c | Item 2 | 2024-03-12 00:00:00
f |  | 2024-06-30 00:00:00 | 2024-07-12 00:00:00 |  |  | 0 |  |  | e | Item 3 | 2024-06-30 00:00:00 |  | e | Item 3 | 2024-06-30 00:00:00 |  | e | Item 3 | 2024-06-30 00:00:00
 |  |  |  |  |  |  |  |  | f | Item 2 | 2024-06-30 00:00:00 |  | f | Item 2 | 2024-06-30 00:00:00 |  | f | Item 2 | 2024-06-30 00:00:00
Notes |  |  |  |  |  |  |  |  | f | Item 3 | 2024-07-12 00:00:00 |  | f | Item 3 | 2024-07-12 00:00:00 |  | f | Item 3 | 2024-07-12 00:00:00
every name has 4 items
every items has its own due date
count items that has due date on march 2024
convert table type from table 1 to table 2