tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 148423d1333396619-creating-a-report-to-show-vehicle-tax-due-tax-disc-log-trial
Sheet: MJ61 TNF

 |  |  |  |  | MJ61 TNF
Registration number : | MJ61 TNF |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | MAN |  | 2011-12-13 00:00:00 | 12 Months | 2013-01-01 00:00:00 | £1255 (Includes £55 [NAME] fee)
Specification : | 6 x 2 A (3 Axle)
Type : | unkown
1st Registered : | unkown
Engine : | unkown
[NAME] : | 44,000kg
Back To Index
Spreadsheet: 486465e5-6c83-42da-8055-826b62a397cf
Sheet: Sheet1

Pre-requisites | CERTIFICATE | COURSE TITLE | NO | SECT | CREDS | PROFESSOR | DAY/TIME | ROOM | EXAM DATE | EXAM TIME
 |  | CONFLICTS | 700 | 1 | 3 | SEALING | MT 8:00 - 9:50 PM / TH 6:00 - 7:50 PM |  | 2014-07-21 00:00:00 | 6:00 - 9:00 PM
 |  | CRIMINAL PROCEDURE | 506 | 1 | 3 | DIMINO | MT 8:00 - 9:50 PM / TH 6:00 - 7:50 PM |  | TAKE HOME EXAM
 |  | PROFESSIONAL RESPONSIBILITY | 702 | 1 | 3 | ROBINETTE | MT 6:00 - 7:50 PM / TH 8:00 - 9:50 PM |  | 2014-07-17 00:00:00 | 6:00 - 9:00 PM
Property I and II | Business Advising Cert | REAL ESTATE TRANSACTIONS | 760 | 1 | 3 | BARROS | MT 6:00 - 7:50 PM / TH 8:00 - 9:50 PM |  | 2014-07-17 00:00:00 | 6:00 - 9:00 PM
 |  | SEMINAR: TAX POLICY@ | 950 | 1 | 2 | HUSSEY | MT 8:00 - 9:50 PM |  | NO EXAM
NON -CLASSROOM CREDITS
Coreq: Prof. [NAME]. Prereq:  Evidence |  | [NAME] | 803 | 1 | 2-4 | [NAME] | M 5:00 - 5:55 PM |  | NO EXAM
Coreq: Prof. [NAME]. Prereq:  Evidence |  | JUDICIAL EXTERNSHIP | 809 | 1 | 2-4 | [NAME] | M 5:00 - 5:55 PM |  | NO EXAM
Evidence | Trial Ad Cert | I.T.A.P.# | 779 | 1 | 3 | LOCKARD | MAY 16 - MAY 23 |  | NO EXAM
Pro. Resp. and Evidence |  | PA CIVIL CLINIC# | 925 | 1 | 4 | LOCKARD |  |  | NO EXAM
 |  | Textbook information (e.g., price, title, ISBN number, etc.) is available at www.widenerlawbookstore.com
 |  | # [NAME] SATISFY THE SKILLS REQUIREMENT             @ WILL SATISFY THE WRITING REQUIREMENT (Final grade will be based on either an exam or a research paper)
Spreadsheet: 664151d1582478638-how-to-loop-through-values-using-power-query-stockdownload
Sheet: MutualFunds

Symbol | Holder | Shares | Date Reported | % Out | Value
MSFT | Vanguard Total Stock Market Index Fund | 212126810 | 2019-06-29 00:00:00 | 0.0279 | 28416507467
MSFT | Vanguard 500 Index Fund | 150793803 | 2019-06-29 00:00:00 | 0.0198 | 20200337849
MSFT | SPDR S&P 500 ETF Trust | 83043990 | 2019-10-30 00:00:00 | 0.0109 | 11906016846
MSFT | Vanguard Institutional Index Fund-Institutional Index Fund | 71547981 | 2019-06-29 00:00:00 | 0.0094 | 9584567534
MSFT | Growth Fund Of America Inc | 67535100 | 2019-09-29 00:00:00 | 0.0089 | 9389404953
MSFT | Fidelity 500 Index Fund | 64812468 | 2019-10-30 00:00:00 | 0.0085 | 9292163537
MSFT | Invesco [NAME] QQQ Tr, Series 1 ETF | 61916795 | 2019-10-30 00:00:00 | 0.0081 | 8877010899
MSFT | iShares Core S&P 500 ETF | 57602890 | 2019-10-30 00:00:00 | 0.0076 | 8258526339
MSFT | Vanguard Growth Index Fund | 54746552 | 2019-06-29 00:00:00 | 0.0072 | 7333848105
MSFT | Washington Mutual Investors Fund | 51127100 | 2019-09-29 00:00:00 | 0.0067 | 7108200713
Spreadsheet: 1acbc5b5-eba7-43ce-aba6-394b78c6d600
Sheet: MARKET

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD DEFINED | # | ASSESSED  COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | Marketing Management Certificate | 1 | X | 1
 | TOTAL
 | PERCENTAGE
 | COURSE
5 | MARKET 100 | 1 | X | 1 | X | 1
5 | MARKET 105 | 1 | X | 1
5 | MARKET 106 | 1 | X | 1
5 | MARKET 110 | 1 | X | 1 | X | 1
4 | MARKET 198 | 1
 | TOTAL
 | PERCENTAGE
Spreadsheet: 722711d1615384140-highlight-every-nth-cell-if-previous-cells-are-populated-budget-planner-1-
Sheet: Calendar

Holiday
Special
x
Days | 2021-03-10 00:00:00 | 2021-03-11 00:00:00 | 2021-03-12 00:00:00 | 2021-03-13 00:00:00 | 2021-03-14 00:00:00 | 2021-03-15 00:00:00 | 2021-03-16 00:00:00 | 2021-03-17 00:00:00 | 2021-03-18 00:00:00 | 2021-03-19 00:00:00 | 2021-03-20 00:00:00 | 2021-03-21 00:00:00 | 2021-03-22 00:00:00 | 2021-03-23 00:00:00 | 2021-03-24 00:00:00 | 2021-03-25 00:00:00 | 2021-03-26 00:00:00 | 2021-03-27 00:00:00 | 2021-03-28 00:00:00 | 2021-03-29 00:00:00 | 2021-03-30 00:00:00 | 2021-03-31 00:00:00 | 2021-04-01 00:00:00 | 2021-04-02 00:00:00 | 2021-04-03 00:00:00
 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 40587d1238972019-find-average-of-rows-that-have-matching-arguments-7-average-using-arguments
Sheet: Sheet1

A | A | 1 | 1 | ?
B | L | 5
C | X | 6
D | P | 9
E | M | 3
F | K | 3
J | R | 4
K | S | 3
 | T | 5
 | B | 1 | 1
 | A | 1 | 1
 | D | 1 | 1
 | G | 5
 | L | 5
 | M | 7
 | K | 1 | 1
 | C | 1 | 1
 | F | 1 | 1
 | J | 1 | 1
 | R | 8
 | B | 1 | 1
 | K | 1 | 1
Spreadsheet: 00d28689-b0b1-4542-88de-6c32aa6273c8
Sheet: Operational Budget

Request for Proposals
CDBG Program Year 2012-2013 |  | Agency Name:
Worksheet # 2 - Operational Budget
Budget Category | Actual Budget for                   July 1, 2009 to June 30, 2010 | Actual Projected Budget for July 1, 2010 to June 30, 2011 | % Increase or Decrease | HUD Funds Request
Employee Services
Personnel
Supplies and Materials
Consumable Supplies
Non-Consumable Supplies
Outside Services
Telephone
Utilities
Maintenance
Contract/Consultant Services
Other Charges
Rent
Travel (Mileage)
Insurance
Capital Outlay
Equipment/Furniture
Other (specify, e.g. reserves, contingencies)
Total
Rev: 10/26/09 ga
Spreadsheet: darrell_schoolcraft__7309__imball0201
Sheet: Citizens-Griffith

 | Citizens-Griffith
 | POI 78069 - Citizens Griffith
Day | Measured | Scheduled
1
2
3
4
5 | -214
6 | -705
7 | -18575 | -34000
8 | -286 | -23996
9 | -25195 | -20832
10 | -33303 | -32500
11 | -25560 | -26902
12 | -90
13
14 | -67 | -6981
15 | -36
16 | -32
17
18 | -319
19 | -142
20 | -17917 | -11000
21 | -62000 | -53000
22 | -63289 | -58000
23 | -59443 | -55000
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | 67742.52
2002-01-23 00:00:00
CBS Volume
 |  |  | 36151
Spreadsheet: daren_farmer__5488__hpl0922
Sheet: Sheet1

HPLN0922.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - September 22, 2000
 |  |  |  |  |  | ** Friday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-09-22 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 30  0900hrs | 0 to 30  0900hrs
 |  |  |  |  | 30  to 0 2100hrs | 30  to 0 2100hrs
 |  | Firm Summary
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 56054d1256181435-summarize-info-from-line-item-cash-flow-worksheet-703947-summarize-info-from-line-item-cash-flow-worksheet2
Sheet: September

Date | Code | Description | Voucher # | I / E | $ Type | Amount | USD | Baht | [NAME] | Cash Flow (USD) | Income USD | Expense USD | USD
 |  |  |  | I, E | D B K |  | Totals | Totals | Totals |  | Total | Total |  |  | USD | Baht | [NAME] |  | USD | Baht | [NAME]
Total Balance
Total Income
Total Expense |  |  |  |  |  |  |  |  |  | [NAME] | Baht Run Balance | [NAME]
 |  |  |  |  |  |  | Daily Transactions
2009-08-31 00:00:00 | - | Balance Forward September | - | I | D | 0 | 379
2009-08-31 00:00:00 | - | Balance Forward September | - | I | B | 0 |  | 8363.5
2009-08-31 00:00:00 | - | Balance Forward September | - | I | K | 0 |  |  | 975000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cashflow | Currency Conversion
2009-08-31 00:00:00 | - | Adjustment to Books | - | I | D | 51 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Baht | [NAME]
2009-08-31 00:00:00 | - | Adjustment to Books | - | I | B | 126 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 | 8600
2009-08-31 00:00:00 | - | Adjustment to Books | - | e | K | 129000
 | 6-0510 | Postage | 8-3292 | e | k | 34000 | 1
 | 6-0330 | Driver's License - S Carlisle | 8-3293 | e | k | 50000 | 25 |  | 0
 | 6-0670 | Medicine for Ki Vang | 8-3294 | e | k | 39000 | 25 |  | 0
 | 6-0501 | Petrol | 8-3295 | e | k | 10000
 | 6-0520 | Unsure | 8-3296 | e | k | 60000
 | 6-0520 | Unsure | 8-3297 | e | k | 24000
 | 6-0500 | Parking fee | 8-3298 | e | k | 2000
 | 6-0500 | Parking fee | 8-3299 | e | k | 2000
 | 6-0670 | Medicine for Neng | 8-3300 | e | k | 37000
 | 6-0541 | Magazine cost | 8-3301 | e | k | 30000 |  | 50 | 0
 | 6-0500 | Parking fee | 8-3302 | e | k | 4000 |  | 50 | 0
 | 6-0501 | Petrol and oil | 8-3303 | e | k | 10000
 | 6-0510 | Postage fees | 8-3304 | e | k | 20000
 | 6-0510 | Postage fees | 8-3305 | e | k | 28000
 | 6-0501 | Petrol - DP for month of Sep | 8-3306 | e | k | 279000
 | 6-0671 | Drinking water | 8-3307 | e | k | 24000
 | 6-0720 | Cooking gas | 8-3308 | e | k | 149000
 | 6-0510 | Postage, freight to [NAME] | 8-3309 | e | k | 23000
Spreadsheet: 678319d1589818381-index-match-cos_excel-help-1-
Sheet: COS

Alive | NAABCode | Short Name | Overall Available | Global price | 001 | 501 | 601
N | 001JE00992 | CONTENDER {3} | 1368 | 20 | 1.395975267284584 | 12.26617807804737 | 15.76617807804737
 | 001HO13411 | RUNAWAY | 8548 | 25 | 1.74496908410573 | 12.26617807804737 | 15.76617807804737
 | 001HO14138 | ORDEAL | 1197 | 45 | 3.140944351390313 | 13.84363013007895 | 17.34363013007895
 | 001HO11953 | PYTHON | 17737 | 8.5 | 0.5932894885959481 | 10.84647123121895 | 14.34647123121895
Spreadsheet: 289008f1-1c29-4154-b00f-d815ba5e6ea8
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-09-16 09:25:47.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.875 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.75 | 102.034 | 101.909 | 101.784 | 101.409
4.625 | 101.316 | 101.191 | 101.066 | 100.691 |  | Note: | Refer To Price [NAME]
4.5 | 100.425 | 100.3 | 100.175 | 99.8 |  |  | For all Price Adjs
4.375 | 99.494 | 99.369 | 99.244 | 98.619
4.25 | 98.682 | 98.557 | 98.432 | 97.807
4.125 | 97.892 | 97.767 | 97.642 | 97.017
 |  |  |  |  |  | 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
4 | 102.125 | 102 | 101.875 | 101.5
3.875 | 101.924 | 101.799 | 101.674 | 101.299
3.75 | 101.226 | 101.101 | 100.976 | 100.601
3.625 | 100.733 | 100.608 | 100.483 | 100.108
3.5 | 100.187 | 100.062 | 99.937 | 99.312
3.375 | 99.465 | 99.34 | 99.215 | 98.59
3.25 | 98.692 | 98.567 | 98.442 | 97.817 |  | Minimum loan amount:
3.125 | 97.682 | 97.557 | 97.432 | 96.807 |  | 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-09-30 09:25:47.880000
30 DAY | 2013-10-15 09:25:47.880000
45 DAY | 2013-10-30 09:25:47.880000
60 DAY | 2013-11-14 09:25:47.880000
90 DAY | 2013-12-14 09:25:47.880000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 835553d1688654985-search-and-return-multiple-results-example-search
Sheet: Blad1

# | [NAME]
5.01 | Search for value A2 in 'column C' on 'sheet2' and return the corresponding value located in 'column A' on 'sheet2'. If multiple values are found, they will be concatenated together.
5.02
5.03
5.04
5.05
5.06
5.07
5.08
5.09
5.10
5.11 | Code of Conduct
5.12
5.13
6.01 | Code of Conduct
6.02 | Code of Conduct
6.03
6.04
6.05 | Code of Conduct,  Policy - Compliance
6.06
6.07
6.08
6.09
6.10
6.11
6.12
6.13
6.14
6.15
6.16
6.17
6.18
6.19
6.20
6.21
6.22
6.23
6.24
6.25
6.26
6.27
6.28
6.29
6.30
6.31
6.32
6.33
6.34
6.35
6.36
6.37
6.38
6.39
6.40
6.41 | Policy - Signatures and Approval Limits
6.42
6.43
6.44
7.01
7.02
7.03
7.04
7.05
7.06
7.07
7.08
7.10
8.01
8.02
8.03
8.04
8.05
8.06
8.07
9.01
9.02
9.03 | Code of Conduct
9.04
9.05
Spreadsheet: 934451aa-eaab-4693-b821-f663ee7c9b37
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-03-04 14:58:31.240000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5.25 | 101.75 | 101.75 | 101.625 | 101.125 |  | and are added to price quote
5.125 | 100.958 | 100.958 | 100.833 | 100.333
5 | 100.542 | 100.542 | 100.417 | 99.91699999999999 |  | Note: | Refer To Price [NAME]
4.875 | 100.087 | 100.087 | 99.96199999999999 | 99.46199999999999 |  |  | For all Price Adjs
4.75 | 99.12599999999999 | 99.12599999999999 | 99.00099999999999
4.625 | 97.845 | 97.845 | 97.72
 |  |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  |  | Please note availability of
 |  |  |  |  |  |  | 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
4.625 | 101.75 | 101.75 | 101.625 | 101.125
4.5 | 101.414 | 101.414 | 101.289 | 100.789
4.375 | 101.023 | 101.023 | 100.898 | 100.398
4.25 | 100.516 | 100.516 | 100.391 | 99.89099999999999
4.125 | 99.29299999999999 | 99.29299999999999 | 99.16799999999999
 |  |  |  |  |  | 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: |  |  | 2011-03-04 14:58:31.240000
 |  |  |  |  |  | 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-03-18 14:58:31.240000
30 DAY | 2011-04-02 14:58:31.240000
45 DAY | 2011-04-17 14:58:31.240000
60 DAY | 2011-05-02 14:58:31.240000
90 DAY | 2011-06-01 14:58:31.240000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 161462d1339524741-show-required-tasks-return-tasks
Sheet: Sheet1

Date | Weekday | Tasks |  |  |  |  | Weekday | Tasks
2012-06-01 00:00:00 |  |  |  |  |  |  | Monday | Presentation
2012-06-02 00:00:00 |  |  |  |  |  |  | Tuesday | Admin, Meeting
2012-06-03 00:00:00 |  |  |  |  |  |  | Wednesday | Training, Reviews
2012-06-04 00:00:00 |  |  |  |  |  |  | Thursday | Disaster Recovery Exercise
2012-06-05 00:00:00 |  |  |  |  |  |  | Friday | Client Visit
2012-06-06 00:00:00 |  |  |  |  |  |  | 1st of Month | Payroll
2012-06-07 00:00:00
2012-06-08 00:00:00
2012-06-09 00:00:00
2012-06-10 00:00:00
2012-06-11 00:00:00
2012-06-12 00:00:00
2012-06-13 00:00:00
2012-06-14 00:00:00
2012-06-15 00:00:00
2012-06-16 00:00:00
2012-06-17 00:00:00
2012-06-18 00:00:00
2012-06-19 00:00:00
2012-06-20 00:00:00
2012-06-21 00:00:00
2012-06-22 00:00:00
2012-06-23 00:00:00
2012-06-24 00:00:00
2012-06-25 00:00:00
2012-06-26 00:00:00
2012-06-27 00:00:00
2012-06-28 00:00:00
2012-06-29 00:00:00
2012-06-30 00:00:00
2012-05-01 00:00:00
Spreadsheet: 542508d1507899847-struggling-to-find-a-way-to-present-data-testdata-set
Sheet: Sheet1

Field / Event | Edit Date | Old Value | New Value | Company
Alias Company Name | 2011-03-08 00:43:00 |  | Testing [NAME] | Test
Company Currency | 2011-07-09 00:58:00 | USD | AUD | Test
Company Merged | 2/23/2017 11:22 AM | Testing [NAME] |  | Test
Country of Domicile | 9/24/2012 11:43 PM |  | Australia | Test
Created. | 2011-03-08 00:43:00 |  |  | Test
DB Assets | 2/23/2017 11:22 AM |  | USD 0.00 | Test
DC Assets (Brightscope) | 2/23/2017 11:22 AM |  | USD 0.00 | Test
DC Assets (MMD) | 2/23/2017 11:22 AM |  | USD 0.00 | Test
GL Business Segment | 2/23/2017 11:22 AM |  | Corporate | Test
Information Sharing Risk Rating | 2011-03-08 00:43:00 |  | 4 | Test
Information Sharing Risk Rating | 8/30/2011 2:24 AM | 4 | 2 | Test
Information Sharing Risk Rating | 2011-02-09 14:55:00 | 2 | 1 | Test
Information Sharing Risk Rating | 2011-02-11 11:28:00 | 1 | 2 | Test
Information Sharing Risk Rating Region | 2/23/2017 11:22 AM |  | Australia | Test
Information Sharing Risk Rating Region | 7/14/2017 11:25 AM | Australia |  | Test
Information Sharing Risk Rating Region | 2011-02-09 14:55:00 |  | Australia | Test
Information Sharing Risk Rating Region | 2011-02-11 11:28:00 | Australia |  | Test
Legal Classification | 9/24/2012 11:43 PM |  | Testing | Test
Mailing Address Line 1 | 9/25/2012 1:43 AM | Park Street | Level 1 | Test
Office Address Line 1 | 9/25/2012 1:43 AM | Park Street | Level 1 | Test
Total Plan Assets | 2015-08-10 13:30:00 |  | AUD 1,000,000,000.00 | Test
Spreadsheet: lisa_gang__22427__Hanson Scheduling Model_5_8
Sheet: Scheduling

 |  |  |  |  | HANSON PERMANENTE CEMENT
 |  |  |  |  |  | Power Usage Forecast
 | CALIFORNIA SCHEDULING COORDINATION AND
 | ENERGY PURCHASES AND SALES AGREEMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday: Tuesday Scheduling
 | Day of Scheduling |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday: Wednesday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday: Thursday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday: Friday & Saturday Scheduling
 | 2002-05-08 00:00:00 | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | Total |  |  |  |  |  |  |  |  | Friday: Sunday and Monday LLH Scheduling
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  |  |  |  |  |  |  |  |  | Friday: Monday HLH
 |  | 19.224 | 25.044 | 25.488 | 25.944 | 25.896 | 25.872 | 26.124 | 25.896 | 25.98 | 24.912 | 25.032 | 26.532 | 26.388 | 26.568 | 26.184 | 25.896 | 25.464 | 25.668 | 25.224 | 25.212 | 25.212 | 25.308 | 25.176 | 25.632 |  |  |  |  |  |  |  |  |  | Holiday
 |  | 27.51023590669259 | 27.51023590669259 | 27.51023590669259 | 27.51023590669259 | 28.26023590669259 | 28.26023590669259 | 28.46023590669258 | 28.46023590669258 | 28.46023590669258 | 28.46023590669258 | 28.46023590669258 | 28.46023590669258 | 13.885 | 13.885 | 14.635 | 13.755 | 13.755 | 13.755 | 31.48023590669258 | 31.48023590669258 | 32.36023590669259 | 32.36023590669259 | 31.61023590669259 | 31.61023590669259
 | Day Ahead Incremental Quantity (Hanson needs to purchase)
 | Day Ahead Decremental Quantity (Hanson needs to sell)
 | Contact Persons
 | EPMI | Telephone |  |  | E-Mail
 | [NAME] | 503/464-3829 |  |  | [EMAIL]
 | [NAME] | 503/464-5053 |  |  | [EMAIL]
 | [NAME] | 503/464-3822 |  |  | [EMAIL]
 | [NAME] | 503/464-3824 |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]
 | Hanson | Telephone |  |  | E-Mail
 | [NAME] Manager | [PHONE] |  |  | [EMAIL]
 | [NAME] Engineer | [PHONE] |  |  | [EMAIL]
 | [NAME]  - VP Operations | [PHONE] |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]
Spreadsheet: 121427d1316045519-v-look-search-or-if-then-statements-lookup-statements
Sheet: Sheet1

 | MOTOR | MTR | GEAR | VALVE | VLV | SUMMARY
 | Electrical | Electrical | Mechanical | Plumbing | Plumbing
GEAR BOX ALPHA LP 120-M01-005-1 N152910
GEARBOX ALPHA LP090-M01-010-1 N142810
GEAR,HELICAL,15,0.75,1.64,10,14.5
GEARMOTOR,CBN3122SB310MT143T-1,BRWNNG MF |  |  |  |  |  |  | <=== | Multiple Matches
MTR,AC,098016.00,LEESON ELECTRIC
MTRS,NON-ELEC,103-1614-012,EATON
[NAME], BRF200C-217
M7284C-1000 MODUTROL MOTOR
Z015243 CONTROL VALVE, SPF11000/1050-1599
VLV,[NAME] CHERRY BURRELL
Spreadsheet: 152309d1335338913-subtracting-dates-practice-sheet
Sheet: Sheet1

Jan | 100 | 1002.1
Feb | 53 | 1004
Mar | 55 | 1005.6
Apr | 55 | 1100.3
May | 67 | 999.6
Jun | 56 | 999.8
Jul | 23 | 1000
Aug | 67 | 1000.2
Sep | 58 | 1002.1
Oct | 45 | 1004
Nov | 44 | 1003
Dec | 50 | 1003
Spreadsheet: kate_symes__18258__Deal Correction 4-2
Sheet: 4-2

Date of Inquiry | Adjustment date | Date of applied calc | Deal Date | Desk Involved | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
 | 2001-04-02 00:00:00 | 2001-04-02 00:00:00 | 2001-03-14 00:00:00 | STCA | KS | EES | N/A | Price: from 133.23 to 133.53 |  | 550208 | ZP-26 | 2001-03-15 00:00:00 | [NAME] | 1s and 2s | 133.53 | EES
 |  |  |  | Grand Count
Spreadsheet: 757047d1637959145-how-to-count-the-number-of-occurrences-of-a-number-within-a-string-of-text-stock-short-term-comparison-16-1-2-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | 1 | 2 | 3
1 ext 3c 1 ext 3c 5pt(alm a6pt w/ 1 ext) 3c patt |  |  |  |  |  |  |  |  |  | 2 | 0 | 0
1 ext 3c t2s(a3s) 3c 1 ext 3c 1 ext(a2/[NAME]) 4c 1 ext cl 3pt cl t2s 4c t5-barely 6pt(s8pt???) 4c patt |  |  |  |  |  |  |  |  |  | 4 | 3 | 2
1 ext 4c 1 ext cl patt |  |  |  |  |  |  |  |  |  | 2 | 0 | 0
Spreadsheet: 782820d1654285790-using-aggregate-indexed-to-return-multiple-returns-but-multiple-criteria-sample-ws
Sheet: ARRIVALS

2022-06-04 00:00:00
Num In |  | <-  I can easily show the number that I actually expect to arrive |  |  |  |  | Num In |  |  |  |  |  |  | Num In
{CANCELED}
 | 16103233
 | 16113039
{EXCHANGED} | 16105410
 | 16142535
 | 16204575
 | 16192361
{CANCELED}
The 3 marked as cancelled or exchanged have no bearing here, but have taken the place of 3 Reservations that have not cancelled or exchanged.        I need to be able to weed them out.
Num In |  |  |  |  |  |  | Num In
 | The Reservation Number pulls from RS_RESERVATION, aggregated to allow multiple rturns for the date | These are simple Xlookups pulling from RS_PRIMARY_NAME besed on Reservation Number. |  |  | This is a simple formula to calculate length of stay.
Num In |  |  |  |  |  |  | Num In