tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 157174d1337641106-weekly-bill-caculator-bill-forcaster-v2
Sheet: Sheet1

 |  |  |  |  |  | 2010-11-28 00:00:00 | 2010-12-05 00:00:00 | 2010-12-12 00:00:00 | 2010-12-19 00:00:00 | 2010-12-26 00:00:00 | 2011-01-02 00:00:00 | 2011-01-09 00:00:00 | 2011-01-16 00:00:00 | 2011-01-23 00:00:00 | 2011-01-30 00:00:00 | 2011-02-06 00:00:00 | 2011-02-13 00:00:00 | 2011-02-20 00:00:00
 |  |  |  |  | Total Due
Due Day | [NAME] | Vendor
1 | 40 | Cell
2 | 30 | Rent
2 | 15 | Electricity
6 | 50 | Parking
9 | 80 | Mortgage
28 | 10 | Water
 |  |  |  |  |  | 2010-11-28 00:00:00 | 2010-12-05 00:00:00 | 2010-12-12 00:00:00 | 2010-12-19 00:00:00 | 2010-12-26 00:00:00 | 2011-01-02 00:00:00 | 2011-01-09 00:00:00 | 2011-01-16 00:00:00 | 2011-01-23 00:00:00 | 2011-01-30 00:00:00 | 2011-02-06 00:00:00 | 2011-02-13 00:00:00 | 2011-02-20 00:00:00
 |  |  |  |  | Total Due | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ?
Month | Due Day | [NAME] | Vendor
All | 1 | 40 | Cell
All | 2 | 30 | Rent
All | 2 | 15 | Electricity
6 | 1 | 300 | Car Insurance
12 | 1 | 300 | Car Insurance
2 | 1 | 50 | Subscription
Spreadsheet: darrell_schoolcraft__7334__imball0203
Sheet: Continental

 | Contintental
 | 500204 |  | 500205
Day | Measured | Scheduled | Measured | Scheduled
1 |  |  |  | 812
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  |  |  | 57421.18
2002-03-09 00:00:00
CBS Volume
 |  |  | 7844
Spreadsheet: 58045d1258366796-time-values-time-minute-splits
Sheet: Sheet1

Position | Player | Split 1 | Rank | [NAME] | Rank | Split 3 | Rank | [NAME] | Rank | Time/Mins
1 | [NAME] | 00:01:00 |  |  |  |  |  |  |  | 00:01:00
2 | Martin | 00:03:00 |  |  |  |  |  |  |  | 00:03:00
3 | Dominic | 00:05:00 |  |  |  |  |  |  |  | 00:05:00
4 | [NAME] | 00:09:00 |  |  |  |  |  |  |  | 00:09:00
5 | Billy | 01:09:00 |  |  |  |  |  |  |  | 01:09:00
5 | [NAME] | 01:09:00 |  |  |  |  |  |  |  | 01:09:00
5 | [NAME] | 01:09:00 |  |  |  |  |  |  |  | 01:09:00
8 | Scott | 01:10:00 |  |  |  |  |  |  |  | 01:10:00
Spreadsheet: 788921d1658802877-match-with-two-variables-excel-lookup-example
Sheet: Sheet1

[NAME]
 | Low Range |  | Hi Range |  |  | Origin | A | Lookup a | Origin | B | Lookup b | Origin | C | Lookup c
 | a | 8001 | 8004 | X |  | a | 8001 |  | b | 8001 |  | c | 8001
 | a | 8005 | 8008 | Y |  | a | 8002 |  | b | 8002 |  | c | 8002
 | b | 8001 | 8003 | P |  | a | 8003 |  | b | 8003 |  | c | 8003
 | b | 8004 | 8005 | D |  | a | 8004 |  | b | 8004 |  | c | 8004
 | b | 8006 | 8007 | Q |  | a | 8005 |  | b | 8005 |  | c | 8005
 | c | 8001 | 8001 | T |  | a | 8006 |  | b | 8006 |  | c | 8006
 | c | 8002 | 8002 | W
 | c | 8003 | 8003 | R
 | c | 8004 | 8099 | E
 |  |  |  |  |  | What the answers |  |  |  | hould be
 |  |  |  |  |  | Origin | A | Lookup a | B | Lookup b | C | Lookup c
 |  |  |  |  |  | a | 8001 |  | 8001 |  | 8001
 |  |  |  |  |  | a | 8002 |  | 8002 |  | 8002
 |  |  |  |  |  | a | 8003 |  | 8003 |  | 8003
 |  |  |  |  |  | a | 8004 |  | 8004 |  | 8004
 |  |  |  |  |  | a | 8005 |  | 8005 |  | 8005
 |  |  |  |  |  | a | 8006 |  | 8006 |  | 8006
Spreadsheet: 484919d1476567216-count-number-of-calls-between-dates-calls-bvj-
Sheet: count

WK-1 | 2016-07-03 00:00:00
WK-2
WK-3
WK-4
WK-5
WK-6
WK-7
WK-8
WK-9
WK-10
WK-11
WK-12
WK-13
WK-14
WK-15
[NAME]
WK-17
WK-18
WK-19
WK-20
WK-21
WK-22
WK-23
WK-24
WK-25
WK-26
[NAME]
WK-28
WK-29
WK-30
WK-31
WK-32
WK-33
WK-34
WK-35
WK-36
WK-37
WK-38
WK-39
WK-40
WK-41
WK-42
WK-43
WK-44
WK-45
WK-46
WK-47
WK-48
WK-49
WK-50
WK-51
WK-52
Spreadsheet: darrell_schoolcraft__7413__TW Jan02pnr
Sheet: USGT 500622

 | [NAME]
 | INVOICE DETAIL - JANUARY,  2002
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maximum Inventory Calculation
DAY | NAME | CONTRACT NUMBER | MONTH | POI # | type_poi | SCHEDULED INJECTION | SCHEDULED WITHDRAWAL | NET SCHEDULED QTY | Carryover GIP | NET GIP | DAILY INJECTION   PRICE                (Inj + MIC) | DAILY WITHDRAWAL  PRICE               (Wd + MIC) | INJECTION AMOUNT       (Inj + MIC) | WITHDRAWAL  AMOUNT          (Wd + MIC) | Positive Inventory | Negative Inventory | Positive Inventory Components | Negative Inventory Components | [NAME] | Ride Amount
 | USGT | 27268 | 2002-01-01 00:00:00 | 500622 | PnR
1 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.1
2 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.1
3 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.1
4 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.1
5 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.1
6 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.1
7 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.1
8 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.1
9 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.1
10 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.1
11 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.1
12 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.1
13 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.1
14 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.1
15 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.1
16 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.1
17 | Per TK rate is $0.04/ day up to [NAME] of |  |  |  |  |  | -15199 |  |  |  | 0.1 | 0.04
18 | $0.09 Total rate |  |  |  |  | 14871 |  |  |  |  | 0.1 | 0.05
19 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0
20 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0
21 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0
22 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0
23 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0
24 |  |  |  |  |  |  | -21563 |  |  |  | 0.1 | 0.05
25 |  |  |  |  |  | 21891 |  |  |  |  | 0.1 | 0
26 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0
27 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0
28 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0
29 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0
30 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0
31
 |  |  |  |  |  |  |  |  |  |  |  | Total Invoice Amount
 |  |  |  | Total Injection
 |  |  |  | Total W/D |  |  |  |  |  |  | SYSTEM GENERATED INVOICE
 |  |  |  |  |  |  |  |  |  |  |  |  | INVOICE AMOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  | Inj Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | Wd Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | MIC Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | Total Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | BILL AMOUNT
Spreadsheet: 8dc02e34-a909-4eca-a870-b51be9272411
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-12-19 09:22:15.930000
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.5 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.375 | 101.749 | 101.624 | 101.499 | 101.124
4.25 | 101.303 | 101.178 | 101.053 | 100.678 |  | Note: | Refer To Price [NAME]
4.125 | 100.951 | 100.826 | 100.701 | 100.326 |  |  | For all Price Adjs
4 | 100.51 | 100.385 | 100.26 | 99.635
3.875 | 99.95 | 99.825 | 99.7 | 99.075
3.75 | 99.101 | 98.976 | 98.851 | 98.226
 |  |  |  |  |  | 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.875 | 101.75 | 101.625 | 101.25
3.75 | 101.449 | 101.324 | 101.199 | 100.824
3.625 | 101.133 | 101.008 | 100.883 | 100.508
3.5 | 100.819 | 100.694 | 100.569 | 100.194
3.375 | 100.414 | 100.289 | 100.164 | 99.539
3.25 | 99.862 | 99.737 | 99.612 | 98.987
 |  |  |  |  |  | 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-01-02 09:22:15.930000
30 DAY | 2012-01-17 09:22:15.930000
45 DAY | 2012-02-01 09:22:15.930000
60 DAY | 2012-02-16 09:22:15.930000
90 DAY | 2012-03-17 09:22:15.930000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: gerald_nemec__11986__Nicor Risks  Mitigants
Sheet: Sheet1

Nicor Compression Transaction
Risks & Mitigants
Service | Responsible Party | Risk (s) | Mitigant(s)
Wholesale Power | Enron Power Marketing (EPM) | Non-delivery during 15-Yr Term due to an | - EPM's exposure to Liquidated Damages
 |  | Enron Corp. bankruptcy or merger with a | - Procure power from another company
 |  | company that plans to exit power business.
Retail Power | IL Power | - Construction delay (transmission line) | - Build in plenty of lead time (3-6 months)
 |  |  | - Active communication between E. & IL Power
 |  |  | - Signed contract between E. & IL Power
 |  | - Transmission line/system interruption | - Purchase of network service vs. point-to-point
 |  | and/or Substation failure | - IL Power's Contingency Plan (Back-up facility)
 |  |  | - Review historical outage reports
 |  |  | - Contractual remedies (E. & IL Power)
 |  | - Regulatory change (i.e. tariff changes) | - All tariff price changes would be directly
 |  |  | passed through to NICOR
Compression | NICOR | Default on Annual Charge Payment during | - Corporate Guarantee from NICOR
 |  | the 15-Yr Term.  Annual Charge needed to | - NICOR's L-T S&P credit rating is AA
 |  | pay capital financing and power option
 |  | premium payments.
Financing | Enron | - Enron defaults if NICOR defaults | - Corporate Guarantee from NICOR
 |  |  | - NICOR's L-T S&P credit rating is AA
 |  |  | - Purchase a credit derivative
 |  | - Enron Corp. goes into bankruptcy | - Power position disposition procedure (?)
Equipment | Enron | - Cost overrun | - Turnkey contract
 |  | - Late delivery | - Build in plenty of lead time (3-6 months)
 |  | - Equipment failure (major) | - 1 to 3 Yr Warranty + Insurance
 |  | - Equipment downtime (temporary) | - Maintenance Service Contract
 |  | - Equipment duration | - 25-Yr life expectancy
 |  | - Faulty maintenance | - Maintenance Service Contract
Storage | NICOR | - Facility downtime or blowout | - Contractually obligated to take firm power
 |  |  | from Enron and pay Annual Charge to Enron.
Spreadsheet: 5b7752f2-5ed7-4cb2-893d-da9f0d883d96
Sheet: 13d

 | Swap Dealers/MSPs4 |  |  | Others
Product1 | HY3 | IG | Other | HY | IG | Other
Index Tranche | 100369 | 931872 | 855683 | 27632 | 85604 | 118720
Europe | - | - | 848008 | - | - | 114461
North America/Asia | 100369 | 931872 | 7675 | 27632 | 85604 | 4259
Other | - | - | - | - | - | -
Index | 1024035 | 4155099 | 6430567 | 505928 | 1889731 | 1663975
Asia | - | - | 208275 | - | - | 50152
Europe | - | - | 5530947 | - | - | 1463078
North America | 1024035 | 4155099 | 181518 | 505928 | 1889731 | 62590
Other | - | - | 509827 | - | - | 88155
OTHER* | - | - | 779898 | - | - | 343100
TOTAL | 1124404 | 5086971 | 8066148 | 533560 | 1975335 | 2125795
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 03a07815-fdce-4cf1-ab7f-e8080221bd55
Sheet: CDS-D

D. TRANSFER ADMISSION
 | Fall Applicants
D1 |  |  |  | Yes | No
D1 | Does your institution enroll transfer students?  (If no, please skip to Section E) |  |  | X
D1 | If yes, may transfer students earn advanced standing credit by transferring credits earned from course work completed at other colleges/universities? |  |  | X
D2 | Provide the number of students who applied, were admitted, and enrolled as degree-seeking transfer students in Fall 2011.
D2 |  | Applicants | Admitted Applicants | Enrolled Applicants
D2 | Men | 49 | 32 | 12
D2 | Women | 63 | 40 | 15
D2 | Total
 | Application for Admission
D3 | Indicate terms for which transfers may enroll:
D3 | Fall | X
D3 | Winter
D3 | Spring | X
D3 | Summer
D4 |  |  |  | Yes | No
D4 | Must a transfer applicant have a minimum number of credits completed or else must apply as an entering freshman? |  |  |  | X
D4 | If yes, what is the minimum number of credits and the unit of measure?
D5 | Indicate all items required of transfer students to apply for admission:
D5 |  | Required of All | Recommended of All | Recommended of Some | Required of Some | Not Required
D5 | High school transcript | X
D5 | College transcript(s) | X
D5 | Essay or personal statement | X
D5 | Interview |  | X
D5 | Standardized test scores |  | X
D5 | Statement of good standing from prior institution(s) | X
D6 | If a minimum high school grade point average is required of transfer applicants, specify (on a 4.0 scale):
D7 | If a minimum college grade point average is required of transfer applicants, specify (on a 4.0 scale): |  |  | 2.33
D8 | List any other application requirements specific to transfer applicants:
D9 | List application priority, closing, notification, and candidate reply dates for transfer students. If applications are reviewed on a continuous or rolling basis, place a check mark in the “Rolling admission” column.
D9 |  | Priority Date | Closing Date | Notification Date | Reply Date | Rolling Admission
D9 | Fall | [NAME] |  |  |  | Yes
D9 | Winter
D9 | Spring | Dec 1 |  |  |  | Yes
D9 | Summer
D10 |  |  |  | Yes | No
D10 | Does an open admission policy, if reported, apply to transfer students?
D11 | Describe additional requirements for transfer admission, if applicable:
 | Transfer Credit Policies
D12 | Report the lowest grade earned for any course that may be transferred for credit: |  |  | 2
D13 |  |  |  | Number | Unit Type
D13 | Maximum number of credits or courses that may be transferred from a two-year institution: |  |  | 72 | Credit Hour
D14 |  |  |  | Number | Unit Type
D14 | Maximum number of credits or courses that may be transferred from a four-year institution: |  |  | 72 | Credit Hour
D15 | Minimum number of credits that transfers must complete at your institution to earn an associate degree:
D16 | Minimum number of credits that transfers must complete at your institution to earn a bachelor’s degree: |  |  | 56
D17 | Describe other transfer credit policies:
Spreadsheet: 761077d1640625009-13-digit-date-time-conversion-specific-to-time-zone-mrshorty_ms_timeformat
Sheet: Sheet1

1570529351871 | 2019-10-08 10:09:12
1441156966048 | 2015-09-02 01:22:46
937482792278 | 1999-09-16 11:53:12
1415386908542 | 2014-11-07 19:01:49
1713572215957 | 2024-04-20 00:16:56
8888190430 | 1970-04-13 20:56:30
1937438777537 | 2031-05-25 01:26:18
720243843272 | 1992-10-28 03:44:03
1143702025236 | 2006-03-30 07:00:25
1495033199066 | 2017-05-17 14:59:59
167505587944 | 1975-04-23 17:19:48
1596960070420 | 2020-08-09 08:01:10
272596915392 | 1978-08-22 01:21:55
1302907030131 | 2011-04-15 22:37:10
1948567381431 | 2031-09-30 20:43:01
1418951829079 | 2014-12-19 01:17:09
1658995651953 | 2022-07-28 08:07:32
1456596715371 | 2016-02-27 18:11:55
1275331834102 | 2010-05-31 18:50:34
Spreadsheet: eric_saibi__9709__010402
Sheet: Four Corners 04

Owner Name |  | Arizona Public Services
Station Name |  | Four Corners Power Station
Unit Name |  | Four Corners 04
NERC Region |  | WSCC
State |  | NM
Fuel Type |  | Coal
Capacity |  | 818 MW
Start Date |  | 2002-01-03 00:00:00
End Date |  | 2002-01-06 00:00:00
Comments |  | Tube leak.
SIC |  | 4911
Plant ID |  | 1523368
Unit ID |  | 1007554
Outage ID |  | 19375
Spreadsheet: 171864d1343895671-vlookup-query-lookup
Sheet: Sheet1

B | C | D | E | F | G | A
50 | 2000 | Tuesday | 500 | Tuesday | 2000 | Tuesday |  | #N/A | =VLOOKUP(G2,$A$2:$F$12,2,0)
2500 | 300 | 200 | 500 | 1000 | 150 | Wednesday
3520 | 150 | 150 | 500 | 150 | 150 | Sunday
3000 | 500 | 500 | 500 | 500 | 500 | Friday
200 | 2568 | 2568 | 500 | 2568 | 2568 | Sunday
50 | 2000 | 100 | 500 | Tuesday | 2000 | Tuesday
2500 | 300 | 200 | 500 | 1000 | 150 | Wednesday
3520 | 150 | 150 | 500 | 150 | 150 | Sunday
3000 | 500 | 500 | 500 | 500 | 500 | Friday
200 | 2568 | 2568 | 500 | 2568 | 2568 | Saturday
200 | 2568 | 2568 | 500 | 2568 | 2568 | Saturday
Spreadsheet: 043f0f6d-72e7-4953-943e-22748140139f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5609.0 Housing Finance, Australia
 | TABLE 9a. HOUSING FINANCE COMMITMENTS (Owner Occupation), By Type of Buyer and Loan: Australia, Original
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
First home buyers - Dwellings financed (no.) ; |  |  | Original | A2412824W | 1975-10-01 00:00:00 | 2012-01-01 00:00:00 | 436 | Number | FLOW | Month | 1
First home buyers - % of all dwellings financed ; |  |  | Original | A2412836F | 1975-10-01 00:00:00 | 2012-01-01 00:00:00 | 436 | Percent | DERIVED | Month | 1
First home buyers - Average loan size ($000) ; |  |  | Original | A2412825X | 1975-10-01 00:00:00 | 2012-01-01 00:00:00 | 436 | $'000 | DERIVED | Month | 1
Non-first home buyers - Dwellings financed (no.) ; |  |  | Original | A2412827C | 1975-10-01 00:00:00 | 2012-01-01 00:00:00 | 436 | Number | FLOW | Month | 1
Non-first home buyers - % of all dwellings financed ; |  |  | Original | A2416246C | 1975-10-01 00:00:00 | 2012-01-01 00:00:00 | 436 | Percent | DERIVED | Month | 1
Non-first home buyers - Average loan size ($000) ; |  |  | Original | A2412826A | 1975-10-01 00:00:00 | 2012-01-01 00:00:00 | 436 | $'000 | DERIVED | Month | 1
Fixed rate - Dwellings financed (no.) ; |  |  | Original | A2412828F | 1975-10-01 00:00:00 | 2012-01-01 00:00:00 | 436 | Number | FLOW | Month | 1
Fixed loans - % of all dwellings financed ; |  |  | Original | A2412837J | 1975-10-01 00:00:00 | 2012-01-01 00:00:00 | 436 | Percent | DERIVED | Month | 1
Fixed rate - Average loan size ($000) ; |  |  | Original | A2412829J | 1975-10-01 00:00:00 | 2012-01-01 00:00:00 | 436 | $'000 | DERIVED | Month | 1
Secured revolving loans - Dwellings financed (no.) ; |  |  | Original | A2412830T | 1975-10-01 00:00:00 | 2012-01-01 00:00:00 | 436 | Number | FLOW | Month | 1
Secured revolving loans - % of all dwellings financed ; |  |  | Original | A2412838K | 1975-10-01 00:00:00 | 2012-01-01 00:00:00 | 436 | Percent | DERIVED | Month | 1
Secured revolving loans - Average loan size ($000) ; |  |  | Original | A2412831V | 1975-10-01 00:00:00 | 2012-01-01 00:00:00 | 436 | $'000 | DERIVED | Month | 1
Other loans -  Dwellings financed (no.) ; |  |  | Original | A2412832W | 1975-10-01 00:00:00 | 2012-01-01 00:00:00 | 436 | Number | FLOW | Month | 1
Other loans - % of all dwellings financed ; |  |  | Original | A2412839L | 1975-10-01 00:00:00 | 2012-01-01 00:00:00 | 436 | Percent | DERIVED | Month | 1
Other loans - Average loan size ($000) ; |  |  | Original | A2412833X | 1975-10-01 00:00:00 | 2012-01-01 00:00:00 | 436 | $'000 | DERIVED | Month | 1
ALL FINANCE - Average loan size ($000) ; |  |  | Original | A2412834A | 1975-10-01 00:00:00 | 2012-01-01 00:00:00 | 436 | $'000 | DERIVED | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 860606d1708631867-formula-to-find-the-last-sales-price-for-a-particiular-unit-and-formula-to-find-last-sal-sample-etaf
Sheet: Sheet1

Lot | unit | sale date | agreement sales price |  |  | A | 2024-02-15 00:00:00 | 235000
1 | a | 2022-12-31 00:00:00 | 250000 |  |  | Unit | Last Sale | Last Price
2 | b | 2023-03-05 00:00:00 | 265000 |  |  | A
3 | c | 2023-07-15 00:00:00 | 285000 |  |  | B
4 | d | 2023-01-15 00:00:00 | 185000 |  |  | C
5 | a | 2024-02-15 00:00:00 | 235000 |  |  | D
6 | b | 2023-01-01 00:00:00 | 23200
7 | c | 2023-05-02 00:00:00 | 234000
8 | d | 2023-11-30 00:00:00 | 235000
9 | a | 2023-11-28 00:00:00 | 265999
10 | b | 2023-10-15 00:00:00 | 267000
11 | c | 2024-01-15 00:00:00 | 234999
12 | d | 2024-02-01 00:00:00 | 185000
13 | a | 2023-08-03 00:00:00 | 125000
14 | b | 2023-09-12 00:00:00 | 135000
15 | c | 2023-07-15 00:00:00 | 140000
16 | d | 2023-06-18 00:00:00 | 138000
17 | a | 2023-10-01 00:00:00 | 263000
18 | b | 2023-06-01 00:00:00 | 26200
19 | c | 2023-12-01 00:00:00 | 271000
20 | d | 2023-11-08 00:00:00 | 283000
Spreadsheet: 478569d1472862097-how-do-i-find-duplicates-between-worksheets-how-do-i-find-duplicates-between-worksheets
Sheet: Summary

 |  |  |  |  |  |  |  |  | Row #s | Column #s | Numbers |  | Row #s | Column #s | Numbers |  | Row #s | Column #s | Numbers |  | Row #s | Column #s | Numbers
 |  |  | Sheet1 | Sheet2 | Sheet3 | Sheet4 |  |  | Sheet1 |  |  |  | Sheet2 |  |  |  | Sheet3 |  |  |  | Sheet4
 |  | Sheet1 |  |  |  |  |  | Sheet1
 |  | Sheet2
 |  | Sheet3
 |  | Sheet4
 |  |  |  |  |  |  |  |  | Sheet1 |  |  |  | Sheet2 |  |  |  | Sheet3 |  |  |  | Sheet4
 |  |  |  |  |  |  |  | Sheet2
 |  |  |  |  |  |  |  |  | Sheet1 |  |  |  | Sheet2 |  |  |  | Sheet3 |  |  |  | Sheet4
 |  |  |  |  |  |  |  | Sheet3
 |  |  |  |  |  |  |  |  | Sheet1 |  |  |  | Sheet2 |  |  |  | Sheet3 |  |  |  | Sheet4
 |  |  |  |  |  |  |  | Sheet4
Spreadsheet: 886279d1736321114-formula-efficiency-pulling-multiple-cols-of-data-from-tbl-y-into-tbl-x-based-on-criteria-formula-efficiency-pulling-multiple-cols-of-data-from-tbl-y-into-tbl-x-based-on-crit
Sheet: Sheet1 (2)

 | Table 1 |  |  |  |  |  | Table 2
 | Col A | Col B | Col C | Col Y | Col Z |  | Col A | Col Y | Col Z |  | Col Y | Col Z | Stacking Col Y & Z |  | Combined Formula |  | Using LET
 | A55 | Native | More |  |  |  | [NAME] | Yes | 45
 | [NAME] | Native 2 | More |  |  |  | B22 | Yes |  |  | Yes | 45 | Yes | 45 | Yes | 45 | Yes | 45
 | B22 | Native | More 1 |  |  |  | C35 | No | 35 |  | Yes |  | Yes |  | Yes |  | Yes
 | C35 | Native 2 | More 2 |  |  |  | D11 | Maybe | 25 |  | No | 35 | No | 35 | No | 35 | No | 35
 | C54 | Native | More 1 |  |  |  | D44 | No | 15
 | D11 | Native | More |  |  |  | E65 | Yes | 55 |  | Maybe | 25 | Maybe | 25 | Maybe | 25 | Maybe | 25
 | D29 | Native 2 | More 2
 | D44 | Native | More 3 |  |  |  |  |  |  |  | No | 15 | No | 15 | No | 15 | No | 15
 | D80 | Native 2 | More 1
 | E65 | Native 2 | More |  |  |  |  |  |  |  | Yes | 55 | Yes | 55 | Yes | 55 | Yes | 55
 | F13 | Native 2 | More 3