tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 801568d1666259211-get-another-result-directly-from-two-tables-without-auxiliary-columns-help10-20
Sheet: Sheet2

 | TABLE A |  |  |  |  |  | TABLE B | nation | Asia | Americas | Europe | Japan | Korea
 | salesman |  | nation |  | Amount | Helper column |  | discount factor | 0.1 | 0.06 | 0.08 | 0.03 | 0.12
 | A |  | Asia |  | 100
 | B |  | Americas |  | 200
 | C |  | Japan |  | 300 |  |  | salesman | Amount after discount
 | D |  | Europe |  | 400 |  |  | A
 | E |  | Korea |  | 500 |  |  | B
 | F |  | Asia |  | 600 |  |  | C
 | G |  | Japan |  | 700 |  |  | D
 | H |  | Asia |  | 800 |  |  | E
 | A |  | Americas |  | 900 |  |  | F
 | B |  | Japan |  | 1000 |  |  | G
 | C |  | Europe |  | 1100 |  |  | H
 | D |  | Korea |  | 1200
 | E |  | Asia |  | 1300
 | F |  | Japan |  | 1400
 | G |  | Asia |  | 1500
 | H |  | Americas |  | 1600
 | A |  | Japan |  | 1700
 | B |  | Europe |  | 1800
 | C |  | Korea |  | 1900
 | D |  | Asia |  | 2000
 | E |  | Japan |  | 2100
 | F |  | Asia |  | 2200
 | G |  | Americas |  | 2300
 | H |  | Japan |  | 2400
 | A |  | Europe |  | 2500
 | B |  | Korea |  | 2600
 | C |  | Asia |  | 2700
 | D |  | Japan |  | 2800
 | E |  | Asia |  | 2900
 | F |  | Americas |  | 3000
 | G |  | Japan |  | 3100
 | H |  | Europe |  | 3200
 | A |  | Korea |  | 3300
 | B |  | Asia |  | 3400
 | C |  | Japan |  | 3500
 | D |  | Asia |  | 3600
 | E |  | Americas |  | 3700
 | F |  | Japan |  | 3800
 | G |  | Europe |  | 3900
 | H |  | Korea |  | 4000
Spreadsheet: f2b87ffa-6947-433f-9db3-9a3c733a47af
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME | PROGRAM
263460 | 72678 | Zsófia | Lengyel | HUN |  | 00:21:09 |  | 00:50:25 |  | 00:34:04 | 1 | 1:45:38 | Paratriathlon Female TRI-6b
263457 | 43853 | Otto | Katona | HUN |  | 00:17:26 |  | 00:55:16 |  | 00:22:43 | 1 | 1:35:25 | [NAME]
263458 | 56625 | Zoltán | Balogh | HUN |  | 00:12:08 |  | 00:35:11 |  | 00:22:10 | 1 | 1:09:29 | [NAME]
263458 | 16966 | [NAME] | [NAME] | HUN |  | 00:12:10 |  | 00:35:35 |  | 00:22:21 | 2 | 1:10:06 | [NAME]
263459 | 74784 | Laszlo | Bok | HUN |  | 00:22:07 |  | 01:14:24 |  | [NAME] | 2 | 1:55:59 | [NAME] TRI-6b
263459 | 42294 | Róbert | Ocelka | HUN |  | 00:13:22 |  | 00:37:08 |  | 00:27:30 | 1 | 1:18:00 | [NAME] TRI-6b
Spreadsheet: 73267d1273880143-counting-in-different-ranges-in-same-worksheet-increment-func
Sheet: Sheet1

1-5 | 6-10 | 11-15 | 16-20
3 | 2 | 1 | 2 | 0
1 | 6 | 5 | 10 | 4 | 16 | 15 | 20
1-5 | 3
6-10 | 2
11-15 | 1
16-20 | 2
 | 0
 | 0
 | 0
Spreadsheet: 322662d1401813848-sales-forecasting-help-with-autofil-using-dates-forecast-6-3-14-excel-question
Sheet: Forecast

2014-01-01 00:00:00
Contract data |  |  |  |  |  |  |  |  |  |  |  |  | Subsequent pricing policy |  |  |  |  |  |  | Sales per year
# | Customer | Platform | Component | LTA Terms | SOP | EOP | Year Fraction (SOP) | Contract Years | Year Fraction (EOP) | Pieces per unit sales | Quoted Volume | Piece Price [NAME] | Price per contracted year |  |  |  |  |  |  | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021
 |  |  | Component | Component |  |  |  |  |  |  | Volume |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  | Program A | [NAME]/LH | 1% x 3 | 2014-08-04 00:00:00 | 2020-08-04 00:00:00 | 0.4083333333333333 | 6 | 0.5916666666666668 | 2 | 130000 | 0.702 | 0.6949799999999999 | 0.6880301999999999 | 0.6811498979999999 | 0.6811498979999999 | 0.6811498979999999 | 0.6811498979999999 | 0.6811498979999999 | 182520 | 181440.09 | 179625.6891 | 177829.432209 | 177098.97348 | 72315.414171
 |  |  | [NAME] (carry over) |  | 2014-08-04 00:00:00 | 2020-08-04 00:00:00 | 0.4083333333333333 | 6 | 0.5916666666666668 | 1 | 510000 | 0.661 | 0.65439 | 0.6478461 | 0.6413676389999999 | 0.6413676389999999 | 0.6413676389999999 | 0.6413676389999999 | 0.6413676389999999 | 337110.0000000001 | 335115.4325000001 | 331764.278175 | 328446.63539325 | 327097.49589 | 133564.81082175
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 519630.0000000001 | 516555.5225000001 | 511389.9672750001 | 506276.06760225 | 504196.4693700001 | 205880.22499275 | 0 | 0
 |  | Program B | Overhead Lens | None | 2010-01-18 00:00:00 | 2014-08-04 00:00:00 | -2.952777777777778 | 6 | -5.408333333333333 | 1 | 114800 | 1.7404 | 1.7056
 |  |  | [NAME] |  | 2010-01-18 00:00:00 | 2014-08-04 00:00:00 | -2.952777777777778 | 6 | -5.408333333333333 | 1 | 600000 | 0.6745 | 0.661
 |  | Objective: Use Start of Production (SOP) and End of Production (EOP) to autofill Sales, considering year-to-year price changes and partial year sales
 |  | Questions:
 |  | 1.  Autofill EOP column:  I would like EOP (End of Production) date to autofill considering SOP (Start of Production) and Contract Years
 |  | 2.  Date Calculation:   'Year Fraction SOP', 'Year Fraction EOP' and the input in cell 'A1' was created from Excel Forum feedback in order to calculate partial sales per year during SOP years and EOP years; However, as
 |  | you can see from cells H11, H12 and J11, J12, this formula is not working for the Project B example; can we create a better formula that will work with both examples?
 |  | 3. [NAME]   Column U formula is wrong - can you fix? Are columns V - AB correct?
 |  | 4.  Other suggestions to better this forecast document?
Spreadsheet: 219276d1362696303-need-to-copy-formulas-150-times-xlf-rd
Sheet: Defines

LABOUR RATE | 26.24
TOE_2 ---LIST BOX (TYPE OF EXPENSE)
***
SHIPPING CHARGES ONLY!
SUB-CONTRACTS
SUB-CONTRACTS + SHIPPING CHARGES
ELECTRONIC PARTS
ELECTRONIC PARTS +  SHIPPING CHARGES
DEV. KITS
DEV. KITS + SHIIPING CHARGES
IT SYSTEMS
IT SYSTEMS +  SHIPPING CHARGES
SOFTWARE
SOFTWARE + SHIPPING CHARGES
R&D OFFICE UTILS
R&D OFFICE UTILS + SHIPPING CHARGES
CURE_PC_2   ---CURRENT EXPENDITURES PAY CODES | <<< to do dropdown list boxes, go to >>> DATA menu and then DATA VALIDATION menu item
***
CURE_BV
CURE_BC
CURE_PV
CURE_PC
CURE_P$
CAPE_PC_1   ---CAPITAL EXPENDITURES PAY CODES
***
CAPE_BV
CAPE_BC
CAPE_PV
CAPE_PC
CAPE_P$
OB_1  ---- ORDERED BY
N/A
xxxxx
yyyyy
zzzzz
CLMS_1  ... CLAIM #
O
1
2
3
4
5
6
7
8
9
#
CLMS_2 .... CLAIM # X
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
#
Spreadsheet: 775952d1649410902-summary-of-appointments-in-date-and-time-order-sample-workbook
Sheet: Desired OutputName

Appointments
Date | Time | Name | Column1
2022-04-19 00:00:00 | 12:30:00 | [NAME] | Jones
2022-04-19 00:00:00 | 13:30:00 | [NAME] | [NAME]
2022-04-19 00:00:00 | 14:30:00 | [NAME] | Smith
2022-04-20 00:00:00 | 12:30:00 | Connor | Bloggs
2022-04-20 00:00:00 | 13:30:00 | Kristy | Edwards
2022-04-20 00:00:00 | 14:30:00 | [NAME] | [NAME]
2022-04-21 00:00:00 | 12:30:00 | Martin | [NAME]
2022-04-21 00:00:00 | 13:30:00 | [NAME] | Jones
2022-04-21 00:00:00 | 14:30:00 | Lewis | Smith
2022-04-22 00:00:00 | 09:00:00 | [NAME] | [NAME]
2022-04-22 00:00:00 | 10:00:00 | [NAME] | Fritz
Spreadsheet: 736312d1623493961-calculating-running-average-cost-example_avg_cost
Sheet: Sheet1

Limits:
Trade Symbol | Transaction | Date | [NAME] | Quantity | Price | Total Cost | Buy Fees | Sell Fees |  | [NAME] | Current Balance (FIFO) | Sales Only -  Separated for RAW data |  | Gain (Loss) P & L
 | Buy | 2021-02-22 00:00:00 |  | 3.514923 | 14.21 |  | 0 | 0
 |  |  |  | 1.95554 | 12.8 |  | 0 | 0
 | Buy | 2021-02-23 00:00:00 |  | 2.121327 | 11.78 |  | 0 | 0
 | Buy | 2021-03-24 00:00:00 |  | 374.242645 | 13.45 |  | 0 | 0
 | Sell | 2021-03-29 00:00:00 | Short | -381.834442 | 13.34 |  | 0 | 0
 | Buy | 2021-04-17 00:00:00 |  | 13.380624 | 37.72 |  | 0 | 0
 |  |  |  | 12.706329 | 39.39 |  | 0 | 0
 | Buy | 2021-04-27 00:00:00 |  | 28.600846 | 35.18 |  | 0 | 0
 | Buy | 2021-05-04 00:00:00 |  | 74.626678 | 67.52 |  | 0 | 0
 |  |  |  | 270.208195 | 74.56 |  | 0 | 0
 | Sell | 2021-05-04 00:00:00 | Short | -399.522672 | 78.52 |  | 0 | 0
 | Buy | 2021-05-04 00:00:00 |  | 179.734944 | 84.04 |  | 0 | 0
 |  | 2021-05-05 00:00:00 |  | 49.622456 | 101.4 |  | 0 | 0
 |  |  |  | 246.20782 | 102.55 |  | 0 | 0
 |  |  |  | 165.37101 | 103.4 |  | 0 | 0
 | Sell | 2021-05-05 00:00:00 | Short | -640.93623 | 104.18 |  | 0 | 0
 | Buy | 2021-05-05 00:00:00 |  | 30.301633 | 99.03 |  | 0 | 0
 |  | 2021-05-06 00:00:00 |  | 276.819944 | 145.41 |  | 0 | 0
 | Sell | 2021-05-06 00:00:00 | Short | -307.121577 | 168.49 |  | 0 | 0
 | Buy | 2021-05-06 00:00:00 |  | 277.1079 | 182.23 |  | 0 | 0
 |  |  |  | 138.149505 | 182.77 |  | 0 | 0
 | Sell | 2021-05-08 00:00:00 | Short | -107.381606 | 127.43 |  | 0 | 0
Totals:
Average Price:
Spreadsheet: 126601d1319766485-converting-text-to-currency-tournamenttest
Sheet: Cash Flow

Grand Total: |  |  |  |  |  |  |  | [NAME] in Charge:
Cash:
Sponsorship of Hole
Double Eagle
Eagle
[NAME]
Par
Other
Cash Donation
Participant
Total Cash
Non-Cash:
Silent Auction Item
Services
Door Prize
[NAME]
Other
Total Non-Cash
Spreadsheet: 01b456aa-1237-4ef5-87bc-87fe788b1b77
Sheet: Figure 5

Figure 5: School Characteristics
 |  | Statewide District | Statewide Charter
Percentage of stuents eligible for free or reduced price lunch |  | 0.374 | 0.603
Percentage of schools eligible for Title 1 |  | 0.4 | 0.649
Percent of students by school type
 | Primary (K-5) | 0.473 | 0.59
 | Middle (6-8) | 0.201 | 0.033
 | High (9-12) | 0.305 | 0.075
 | Other (K-12,K-8, etc.) | 0.022 | 0.302
Spreadsheet: 127447d1320349179-pivot-table-report-help-test-7-ccm-reporting-sumproduct
Sheet: C Data Entry

ID | Reporting Quarter | Reporting Period | Target | Site
984 | Q 1 | P 1 | Yes | C
654 | Q 1 | P 1 | Yes | C
7546 | Q 1 | P 1 | NO | C
5324 | Q 2 | P 1 | Yes | C
35234 | Q 2 | P 2 | Yes | C
523423 | Q 2 | P 3 | Yes | C
235 | Q 3 | P 1 | Yes | C
3424 | Q 3 | P 1 | Yes | C
343 | Q 1 | P 4 | Yes | C
23534 | Q 1 | P 5 | Yes | C
Spreadsheet: 80849d1281024291-linking-data-from-one-sheet-to-another-client-invoice-blank
Sheet: Data

Date | Surname | First Name | Company | Address | City, Province | Postal Code | Telephone | Method Of Payment | Supplier | [NAME] | Wig Number | Wig Color | Cost Of Wig | Shipping | HST | Total | Balance Due
2010-08-05 00:00:00 | Test | Customer | [NAME]'s Cosmetic Eyewear | 123 Sesame St | NY, NY | 12345-6789 | 123-456-789 | Credit Card | Widgets+ | Wig Ultra 9000 | 1231a | Teal | 99.97 | 25 | 999 | 999 | 9999
Spreadsheet: 9b981f67-86cd-4410-820f-e6009e03a490
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0011928 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | Olde Sycamore WWTP | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Union | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 1 |  | Field Name: |  | 2 |  | Field Name: |  | 3 |  | Field Name: |  | 4
 |  |  |  |  |  | Area (acres): |  | 18.11 |  | Area (acres): |  | 18.11 |  | Area (acres): |  | 18.11 |  | Area (acres): |  | 13.88
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | 31 |  | Annual Rate (in): |  | 31 |  | Annual Rate (in): |  | 31 |  | Annual Rate (in): |  | 31
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 144592d1331052287-excluding-data-from-a-formula-if-they-have-already-been-used-2012-regional-scores-example
Sheet: Statistics

Overall
 |  | Points | %
1
2
3
4
Job Specific - Mill
 |  | Points | %
1
2
3
4
Job Specific - Lathe
 |  | Points | %
1
2
3
4
Job Specific - Bench & Grind
 |  | Points | %
1
2
3
4
Spreadsheet: eeda1fd1-1bce-4a96-b683-9b847eeab0ee
Sheet: Sheet1

Day | Date | Opponent | Course | Time
Monday | 2011-08-15 00:00:00 | [NAME] | [NAME] | 4:30PM
Monday | 2011-08-22 00:00:00 | Seneca | [NAME] | 4:30PM
Tuesday | 2011-08-23 00:00:00 | [NAME] | MGC | 4:30PM
Thursday | 2011-08-25 00:00:00 | Wilmington w/Peotone | [NAME] | 4:30PM
Tuesday | 2011-08-30 00:00:00 | [NAME] | MGC | 4:30PM
Wednesday | 2011-08-31 00:00:00 | BBCHS w/Bloom | MGC | 4:30PM
Thursday | 2011-09-01 00:00:00 | [NAME] | [NAME]. | 4:30PM
Tuesday | 2011-09-06 00:00:00 | Peotone w/Plano | Green Garden | 4:30PM
Wednesday | 2011-09-07 00:00:00 | [NAME] | Minne Monesse | 4:30PM
Thursday | 2011-09-08 00:00:00 | [NAME] w/ R.C. | [NAME] | 4:30PM
Tuesday | 2011-09-13 00:00:00 | Coal City w/Momence | MGC | 4:30PM
Monday | 2011-09-19 00:00:00 | [NAME] w/Beecher | [NAME] | 4:30PM
Thursday | 2011-09-22 00:00:00 | [NAME] | [NAME] | 1:00PM
Friday | 2011-09-23 00:00:00 | Watseka Invite | [NAME] | 4:00PM
Monday | 2011-09-26 00:00:00 | [NAME]. Tournament | [NAME] | 12:00PM
Tuesday | 2011-09-27 00:00:00 | Momence | MGC | 4:30PM
Thursday | 2011-09-29 00:00:00 | [NAME] | [NAME] | 4:00PM
Friday | 2011-09-30 00:00:00 | Grant Park Invite | Minne Monesse | 1:00PM
Tuesday | 2011-10-04 00:00:00 | REGIONALS | TBA
Spreadsheet: 117053d1312411662-formula-to-calculate-tolerance-negative-and-postive-pl-threshold
Sheet: EXAMPLE

 | PO | PI | PO-P1 | WITHIN TOLERANCE
EXAMPLE: 1 | 145 | 222 |  |  | =IF((B3-C3)<B3*IF(B3<=950,1%,IF(B3>951<1950,0.5%,IF(B3>1951,0.4,""))),"YES ","NO")
EXAMPLE: 2 | 2133 | 2100
EXAMPLE: 3 | 2000 | 1899
Spreadsheet: 870080d1716587273-pulling-information-across-sheets-dummy-backhaul-tracker
Sheet: Backhaul Tracker

PO # | Original Promise Date | Current Promise Date | Appointment Date | Out of Route Miles | Route Number | Notes | Vendor
123456789 | 2024-05-01 00:00:00 | 2024-05-01 00:00:00 | 2024-05-01 00:00:00 | 11 | 129 |  | Ventura
321498237 | 2024-05-07 00:00:00 | 2024-05-07 00:00:00 | 2024-05-07 00:00:00 | 12 | 126 |  | Resers
923814232 | 2024-05-08 00:00:00 | 2024-05-08 00:00:00 | 2024-05-08 00:00:00 | 10 | 122 |  | SSI
Spreadsheet: 453732d1459430988-compare-multiple-columns-for-match-then-give-min-find_min_price
Sheet: Sheet2

NEW ISSUE | UDAC | PRICE | MIN PRICE
AACGA 01/2017 | HP | 100 | False
AACGA 01/2017 | HP | 50 | True
ADAOK 03/2017 | DQC | 200 | False
ADAOK 03/2017 | DQC | 100 | True
ADAOK 03/2017 | HP | 500 | True
AIOMI 08/2016 | HP | 300 | True
AIOMI 08/2016 | THC | 200 | True
AIOMI 08/2016 | [NAME] | 100 | True
Spreadsheet: 865616d1712662682-how-to-automatically-match-cell-info-from-one-sheet-to-another-if-it-matches-a-cell-in-she-complete-list-mt
Sheet: All_Clients_INCL_Contacts

Living / Deceased | Mota Vehicle Type | MMO | Full Name | Surname | Forename |  | Make & Model | Vehicle Reg | MOT                           Expires | Service |  | Agreement Number | Contract                                End Date | N?A | NINO | DOB | N?A | Address1 | Address2 | Address3 | Address4 | Postcode | Contact | Contact e-mail | Tel: | Contact | Contact e-mail | Tel: | Contact | Contact e-mail | Tel: | Drivers Name 1 | Driving Licence 1 | [NAME] | Endorsements 1 | [NAME] | Drivers Name 2 | Driving Licence 2 | [NAME] | Endorsements 2 | [NAME] | Drivers Name 3 | Driving Licence 3 | [NAME] 3 | Endorsements 3 | [NAME] | Drivers Name 4 | Driving Licence 4 | [NAME] | Endorsements 4 | [NAME] | Drivers Name 5 | Driving Licence 5 | [NAME] 5 | Endorsements 5 | [NAME] | Drivers Name 6 | Driving Licence 6 | [NAME] 6 | Endorsements 6 | [NAME] | Drivers Name 7 | Driving Licence 7 | [NAME] | Endorsements 7 | [NAME] | Drivers Name 8 | Driving Licence 8 | [NAME] 8 | Endorsements 8 | [NAME] | Drivers Name 9 | Driving Licence 9 | DVLA Check9 | Endorsements 9 | [NAME] | Drivers Name 10 | Driving Licence 10 | [NAME] 10 | Endorsements 10 | [NAME] | Drivers Name 11 | Driving Licence 11 | [NAME] 11 | Endorsements 11 | [NAME] | Drivers Name 12 | Driving Licence 12 | [NAME] 12 | Endorsements 12 | [NAME] | Drivers Name 13 | Driving Licence 13 | [NAME] 13 | Endorsements 13 | [NAME] | Drivers Name 14 | Driving Licence 14 | [NAME] 14 | Endorsements 14 | [NAME] | Drivers Name 15 | Driving Licence 15 | [NAME] 15 | Endorsements 15 | [NAME] | Drivers Name 16 | Driving Licence 16 | [NAME] 16 | Endorsements 16 | [NAME] | Drivers Name 17 | Driving Licence 17 | [NAME] 17 | Endorsements 17 | [NAME] | Drivers Name 18 | Driving Licence 18 | [NAME] 18 | Endorsements 18 | [NAME] | Drivers Name 19 | Driving Licence 19 | [NAME] 19 | Endorsements 19 | [NAME] | Drivers Name 20 | [NAME]  20 | [NAME]20 | Endorsements  20 | [NAME] | Drivers Name 21 | Driving Licence 21 | [NAME] 21 | Endorsements 21 | [NAME] | Drivers Name 22 | Driving Licence 22 | [NAME] 22 | Endorsements 22 | [NAME] | Drivers Name 23 | Driving Licence 23 | [NAME] 23 | Endorsements 23 | [NAME] | Drivers Name 24 | Driving Licence 24 | [NAME] 24 | Endorsements 24 | [NAME] | Drivers Name 25 | Driving Licence 25 | [NAME] 25 | Endorsements 25 | [NAME] | Drivers Name 26 | Driving Licence 26 | [NAME] 26 | Endorsements 26 | [NAME] | Drivers Name 27 | Driving Licence 27 | [NAME] 27 | Endorsements 27 | [NAME] | Drivers Name 28 | Driving Licence28 | [NAME] 28 | Endorsements 28 | [NAME]
 |  |  |  | Winds | Summer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | test 1 | 12345dcvt3 | 2024-04-08 00:00:00 | zero | 2027-01-01 00:00:00 | Flowers | daffodil | 2024-03-03 00:00:00 | Zero | 2029-07-16 00:00:00
 |  |  |  | colours | autumn |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | summer | winter | autumn | spring | sunny | [NAME] | windy | raining | snowing | hailstones
Spreadsheet: 06f4ae0f-a41b-4461-a077-18f0ebbd0d1e
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 12. HOUSING LOAN OUTSTANDINGS TO HOUSEHOLDS (OWNER OCCUPATION AND INVESTMENT HOUSING)
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
Owner-occupied housing ;  [NAME] ; |  |  | Original | A2435226X | 2002-03-01 00:00:00 | 2010-01-01 00:00:00 | 95 | $ Millions | STOCK | Month | 1
Owner-occupied housing ;  Permanent Building Societies ; |  |  | Original | A2435228C | 2002-03-01 00:00:00 | 2010-01-01 00:00:00 | 95 | $ Millions | STOCK | Month | 1
Owner-occupied housing ;  Credit Co-operatives ; |  |  | Original | A2435230R | 2002-03-01 00:00:00 | 2010-01-01 00:00:00 | 95 | $ Millions | STOCK | Month | 1
Owner-occupied housing ;  Total Authorised Deposit-taking Institutions (ADIs) ; |  |  | Original | A2435232V | 2002-03-01 00:00:00 | 2010-01-01 00:00:00 | 95 | $ Millions | STOCK | Month | 1
Investment housing ;  [NAME] ; |  |  | Original | A2435227A | 2002-03-01 00:00:00 | 2010-01-01 00:00:00 | 95 | $ Millions | STOCK | Month | 1
Investment housing ;  Permanent Building Societies ; |  |  | Original | A2435229F | 2002-03-01 00:00:00 | 2010-01-01 00:00:00 | 95 | $ Millions | STOCK | Month | 1
Investment housing ;  Credit Co-operatives ; |  |  | Original | A2435231T | 2002-03-01 00:00:00 | 2010-01-01 00:00:00 | 95 | $ Millions | STOCK | Month | 1
Investment housing ;  Total Authorised Deposit-taking Institutions (ADIs) ; |  |  | Original | A2435233W | 2002-03-01 00:00:00 | 2010-01-01 00:00:00 | 95 | $ Millions | STOCK | Month | 1
All residential housing ;  [NAME] ; |  |  | Original | A2435234X | 2002-03-01 00:00:00 | 2010-01-01 00:00:00 | 95 | $ Millions | STOCK | Month | 1
All residential housing ;  Permanent Building Societies ; |  |  | Original | A2435235A | 2002-03-01 00:00:00 | 2010-01-01 00:00:00 | 95 | $ Millions | STOCK | Month | 1
All residential housing ;  Credit Co-operatives ; |  |  | Original | A2435245F | 2002-03-01 00:00:00 | 2010-01-01 00:00:00 | 95 | $ Millions | STOCK | Month | 1
All residential housing ;  Total Authorised Deposit-taking Institutions (ADIs) ; |  |  | Original | A2435246J | 2002-03-01 00:00:00 | 2010-01-01 00:00:00 | 95 | $ Millions | STOCK | Month | 1
All residential housing ;  Securitisation Vehicles ; |  |  | Original | A2435238J | 2002-03-01 00:00:00 | 2010-01-01 00:00:00 | 95 | $ Millions | STOCK | Month | 1
All residential housing ;  Other Lenders ; |  |  | Original | A2435241W | 2002-03-01 00:00:00 | 2010-01-01 00:00:00 | 95 | $ Millions | STOCK | Month | 1
All residential housing ;  Total (Lender Housing) ; |  |  | Original | A2435244C | 2002-03-01 00:00:00 | 2010-01-01 00:00:00 | 95 | $ Millions | STOCK | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 327887d1403709972-help-with-vlookup-and-data-validation-book1
Sheet: Sheet1

Sequence of Ops for selected part number (dynamic form for operator)
Part numbers
156 |  | ABC inc.
 |  |  |  |  |  |  |  |  |  |  |  | All possible sequences
1 | Weld |  |  |  |  |  |  |  |  |  | Weld | Fold | Laser | Hang | Prime | Mask | [NAME] | Assemble | Crate
2 | Laser
3 | Hang |  |  |  |  |  |  |  |  |  |  |  | Database spreadsheet
4 | Mask |  |  |  |  |  |  |  |  | List for DV | Fabrication |  |  | Painting |  |  | Finishing
5 | [NAME] |  |  |  |  |  |  |  |  | 123 | Weld |  | Laser | Hang | Prime |  | [NAME] | Assemble | Crate
6 |  |  |  |  |  |  |  |  |  | 132 |  | Fold | Laser | Hang | Prime | Mask | [NAME] | Assemble
7 |  |  |  |  |  |  |  |  |  | 156 | Weld |  | Laser | Hang |  | Mask | [NAME]
8
9
 |  |  |  |  |  |  |  |  |  | List for Vlookup | Fabrication |  |  | Painting |  |  | Finishing
 |  |  |  |  |  |  |  |  |  | 123 | Weld | Laser | Hang | Prime | [NAME] | Assemble | Crate
 |  |  |  |  |  |  |  |  |  | 132 | Fold | Laser | Hang | Prime | Mask | [NAME] | Assemble
 |  |  |  |  |  |  |  |  |  | 156 | Weld | Laser | Hang | Mask | [NAME]