tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: robin_rodrigue__33364__IMPositions_070700
Sheet: IMPositions

Sum of Delta | ref_dt
Location | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00
GDP-HEHUB | 315000 | 0 | 0 | 0 | 0 | 0
IF-NTHWST/CANBR | -719628 | -310000 | 0 | 0 | 0 | 0
IF-NWPL-ROCK/CA | 0 | 155000 | 0 | 0 | 0 | 0
NG | 0 | 597900 | -1023000 | -1647100 | 0 | 0
NGI-MALIN/FP | 0 | 0 | 0 | 0 | 0 | 0
NGMR-AECO/C | -4995765.494820384 | 2923083.829345305 | 1434159.996776075 | 2649722.924005442 | 0 | 0
STATION2/US$ | -102753.7874766837 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
GDP-NTHWST/CANB | 0 | 0 | 0 | 0 | 0 | 0
GDP-NWPL-ROCKYM | 840000 | 0 | 0 | 0 | 0 | 0
GDP-MALIN-CTYGA | 0 | 0 | 0 | 0 | 0 | 0
GDP-CHI.GATE | 0 | 0 | 0 | 0 | 0 | 0
GDP-ELPO/SANJUA | 0 | 0 | 0 | 0 | 0 | 0
NGI/CHI.GATE | 0 | 0 | 0 | 0 | 0 | 0
 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00
CGPR-AECO/BASIS | -0.2 | -0.2 | -0.2 | -0.2 | -0.2
GDP-HEHUB | 1 | 1 | 1 | 1 | 1
IF-NTHWST/CANBR | 0.9 | 0.9 | 0.9 | 0.9 | 0.9
IF-NWPL-ROCK/CA | 0.9 | 0.9 | 0.9 | 0.9 | 0.9
NG | 1 | 1 | 1 | 1 | 1
NGMR-AECO/C | 0.8 | 0.8 | 0.8 | 0.8 | 0.8
STATION2/US$ | 0.8 | 0.8 | 0.8 | 0.8 | 0.8
[NAME] | 0.8 | 0.8 | 0.8 | 0.8 | 0.8
GDP-NTHWST/CANB | 0.9 | 0.9 | 0.9 | 0.9 | 0.9
GDP-NWPL_ROCKYM | 0.9 | 0.9 | 0.9 | 0.9 | 0.9
GDP-CITYGATE | 1 | 1 | 1 | 1 | 1
 | 1 | 1 | 1 | 1 | 1
Nymex Equiv - contracts |  |  |  |  |  |  |  | Yesterday's
 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 | Total | Total | Change
GDP-HEHUB
IF-NTHWST/CANBR
IF-NWPL-ROCK/CA
NG
NGI-MALIN/FP
NGMR-AECO/C
STATION2/US$
[NAME]
GDP-NTHWST/CANB
GDP-NWPL_ROCKYM
GDP-CHI.GATE
Physical |  |  | 0 | 0 | 0 |  | -320.3737395183012
Gas Daily |  |  |  |  |  |  | 30.94947000000001
Basis - Notional |  |  |  |  |  |  | 0
Basis - Equivalent
Price |  |  |  |  |  |  | 265.1483882175011
CHECK |  |  |  |  | TOTAL |  | -24.27588130080011
Spreadsheet: 132631d1323868029-nested-if-and-countif-problem-test
Sheet: Sheet2

 |  |  | up to 20k in assets |  |  | 20001 to 99999 in assets |  |  | 100k + in assets
 |  |  | >45 | 45-50 | <50 | >60 | 60-66 | <66 | >70 | 70-75 | <75
 | mr a
 | mr b
 | mr c
 | mr d
 |  |  | A2:A7,"<6",A2:A7,">1")
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: R62

Ime artikla
Spreadsheet: 492420d1481084385-nonlinear-interpolation-trise3p
Sheet: Sheet1

Time (min) | TC | IR |  | Worst Case1 | Worst Case2 |  |  | Tinit1 | 23.4 |  | Time | Exp_Fit_WC1 | Exp_Fit_WC2 |  | Tau1 | Tau2 | [NAME] | Avg Tau2
0 | 20 | 25 |  | 23.4 | 23.6 |  |  | Tfinal1 | 30.5 |  | 0
10 | 27 | 32 |  | 28.5 | 33.6 |  |  | tau1 |  |  | 10
20 | 31 | 34.8 |  | 29.1 | 35.5 |  |  | Tinit2 | 23.6 |  | 20
30 | 32 | 36.3 |  | 29.4 | 35.9 |  |  | Tfinal2 | 36.1 |  | 30
40 | 33 | 37 |  | 30 | 36 |  |  | tau2 |  |  | 40
50 | 33 | 37.1 |  | 30.5 | 36.4 |  |  |  |  |  | 50
60 | 34 | 35.6 |  | 30.5 | 36.1 |  |  |  |  |  | 60
 |  |  |  |  | Delta_Max |  |  |  | Tau_Diff %
Spreadsheet: 2fd3f4ed-aab4-4fe1-acfb-27485aa0e498
Sheet: Title

 | Financial Allocations Committee (FAC) Campus Clubs & Student Programs Budget Proposal Form 2013-2014
 | Directions for completing:  Enter information into the cells that are shaded pale yellow (be sure to complete all of the yellow cells in the Title Tab; utilize those appropriate to your specific budget needs for the General Costs and Travel tabs).  Provide as much detail as possible so that the committee has a clear understanding of why you are participating in events and how the money your club receives directly relates to your group achieving its mission and objectives/goals.  The budget request amounts will tally for you as you enter information.  If there is a cell that is not open to enter information into, that is because the cell is locked.  These cells are locked for specific functions, and should not be tampered with.  If you have any questions about completing the form, contact [NAME] in the ASOIT office at [PHONE] or email [EMAIL].
 | NOTE THAT THERE ARE TABS AT THE BOTTOM OF THE SPREADSHEET.                             Once your form is complete, send it as an email attachment to [EMAIL].
 | [NAME] are able to request funding between $300 - $1,500 total per academic year.
 |  |  | Name of organization:
 |  |  | SAC #:
 |  |  | Contact person(s):
 |  |  | [NAME]:
 |  |  | Name of Advisor:
 |  |  | Are you a currently active/registered club or program?
 |  |  | Number of ACTIVE student members:
 |  |  | Number of members particiapting in community service:
 |  |  | Does your club collect dues? If so, how much?
 |  |  |  | Proposed Budget
 |  |  |  | Printing & Mailing |  | Speaker/Performers
 |  |  |  | Student Leader Wages |  | Capital Expenditures
 |  |  |  | Supplies |  | Miscellaneous
 |  |  |  | Food |  | Travel
 |  |  |  | Grand Total Requested:
 |  |  |  | Grand Total Allocated:
Spreadsheet: 138494d1327683204-how-to-create-backwards-profite-margins-cartel4
Sheet: Foglio1

Selling | 100 | 200 | 2000
Profit margin | 20 | 10 | 5
[NAME] | 80 | 180 | 1900 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 868151d1714909722-the-result-of-the-formulas-only-appers-when-i-save-the-file-pagamento-almo-os
Sheet: Folha1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ü
 |  |  |  |  | LETRA | VALOR UNITÁRIO | IDADE | Nº | VALOR  TOTAL | - | VALOR LIQUIDADO |  | A LIQUIDAR
 |  |  |  |  | A | 0 | Até 3 anos
 |  |  |  |  | B | 26.5 | De 4 a 12 anos
 |  |  |  |  | C | 53 | A partir de 13 anos
 |  |  |  |  | GRUPO | NOME |  |  |  |  | VALOR |  | PGTO
 |  |  |  |  | A
 |  |  |  |  | B |  |  |  |  |  |  |  | ü
 |  |  |  |  | B
 |  |  |  |  | C |  |  |  |  |  |  |  | ü
 |  |  |  |  | A
 |  |  |  |  | B |  |  |  |  |  |  |  | ü
 |  |  |  |  | B |  |  |  |  |  |  |  | ü
 |  |  |  |  | C |  |  |  |  |  |  |  | ü
 |  |  |  |  | A
 |  |  |  |  | B |  |  |  |  |  |  |  | ü
 |  |  |  |  | C
 |  |  |  |  | C
 |  |  |  |  | C |  |  |  |  |  |  |  | ü
 |  |  |  |  | C
 |  |  |  |  | A
 |  |  |  |  | C
 |  |  |  |  | C
 |  |  |  |  | B
 |  |  |  |  | C
 |  |  |  |  | C
Spreadsheet: 686490d1594653089-annal-leave-timesheet-hours-to-work-days-7-5hr-annual-leave-test-2
Sheet: Sheet1

Base: |  | Annual Leave Entitlement: |  | Hours:mins
 |  |  |  | 12 days, 19:30:00
 |  |  |  |  |  |  |  |  |  |  | Office Use Only
Annual Leave |  | Number of hours taken. |  | Balance left. HH:MM |  | [NAME] in Days | [NAME] if Taken as a whole day or half day |  | Signature | Supervisors Signature | Initials when entered on [NAME]. | [NAME]
From | To | HH:MM |  |  |  |  | Date | Amount
(First Day) | (Last Day)
2020-04-13 00:00:00 |  | 07:30:00 |  |  |  |  |  |  |  |  | NHB | P
2020-05-08 00:00:00 |  | 07:30:00 |  |  |  |  |  |  |  |  | NHB | P
2020-05-25 00:00:00 |  | 07:30:00 |  |  |  |  |  |  |  |  | NHB | P
2020-08-31 00:00:00 |  | 07:30:00 |  |  |  |  |  |  |  |  | NHB | P
2020-12-25 00:00:00 |  | 07:30:00 |  |  |  |  |  |  |  |  | NHB | P
2021-01-01 00:00:00 |  | 07:30:00 |  |  |  |  |  |  |  |  | NHB | P
2020-05-26 00:00:00 | 2020-05-28 00:00:00 | 22:30:00 |  |  |  |  |  |  |  |  | NHB | P
2020-08-03 00:00:00 | 2020-08-18 00:00:00 | 3 days, 3:00:00 |  |  |  |  |  |  |  |  | NHB | P
2020-07-27 00:00:00 |  | 07:30:00 |  |  |  |  |  |  |  |  | NHB | P
2020-08-24 00:00:00 |  | 07:30:00 |  |  |  |  |  |  |  |  | NHB | P
2020-08-28 00:00:00 |  | 07:30:00 |  |  |  |  |  |  |  |  | NHB | P
2020-05-29 00:00:00 |  | 07:30:00 |  |  |  |  |  |  |  |  | NHB | P
2020-06-24 00:00:00 |  | 07:30:00 |  |  |  |  |  |  |  |  | NHB | P
Spreadsheet: 191965d1352265318-merging-combining-data-combinedata
Sheet: Summary

Activities | Description
a | aa
b | bb
c | cc
d | dd
e | ee
f | ff
g | gg
h | hh
i | ii
j | jj
Spreadsheet: 181483d1348056832-trying-to-allocate-values-in-a-cell-up-to-a-specified-ceiling-then-move-to-next-ceiling-allocate-values
Sheet: Sheet4

Value | Allocated value (formula needed) | Amt Needed from next ceiling (formula needed) |  |  | Ceiling | Remaining | Remaining | Remaining | Remaining | Remaining
20000 | 20000 |  |  |  | 450000
200000 | 200000 |  |  |  | 125000
12500 | 12500
189000 | 189000
145000 | 28500
8500 |  | 8500
Spreadsheet: john_griffith__15718__griffith monthly quotes
Sheet: Sheet3

 | Climetrix
 | Mean Result | [NAME] |  | Bid | Offer |  | Bid | Offer
2001-07-13 00:00:00 | 75573 | 11548 |  | 74500 | 79500
2001-07-12 00:00:00 | 76754 | 11751 |  | 73000 | 78900
2001-07-11 00:00:00 | 76754 | 11751 |  | 73000 | 78900
2001-07-10 00:00:00 | 74697 | 11602 |  | 73500 | 78500
Spreadsheet: 17fd8c8c-e34c-49b1-84d4-e5f588b4863e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | TAP CHART | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
[NAME] |  | is = 100.00 | set at
Pump tank elev. |  |  | 100 | Pump elev. | 95 |  | Manifold elev. |  | 101
line | color | rod read | Elevation | length | hole size | flow/tap | gal/day | trench area | LINE LTAR
1 |  |  | 100 |  |  |  |  | 0
2 |  |  | 100 |  |  |  |  | 0
3 |  |  | 100 |  |  |  |  | 0
4 |  |  | 100 |  |  |  |  | 0
5 |  |  | 100 |  |  |  |  | 0
6 |  |  | 100 |  |  |  |  | 0
7 |  |  | 100 |  |  |  |  | 0
8 |  |  | 100 |  |  |  |  | 0
9 |  |  | 100 |  |  |  |  | 0
10 |  |  | 100 |  |  |  |  | 0
11 |  |  | 100 |  |  |  |  | 0
 |  | total | feet  = | 0 | gal/min = | 0 |  | LTAR =
% of [NAME]. |  |  |  | Des. Flow |  |  |  | (ltar W/ INOV) | 0
Dose Volume |  | 0 |  | Pump Run= |  |  |  | (ltar + 5%) | 0
Dose Pump Time |  |  |  | Tank Gal/IN
Drawdown in Inches |  |  |  | Elevation Head | 6
 |  |  |  | TAP CHART
[NAME] |  | is = 100.00 | set at
Pump tank elev. |  |  | 100 | Pump elev. | 95 |  | Manifold elev. |  | 101
line | color | rod read | Elevation | length | hole size | flow/tap | gal/day | trench area | LINE LTAR
1 |  |  | 100 |  |  |  |  | 0
2 |  |  | 100 |  |  |  |  | 0
3 |  |  | 100 |  |  |  |  | 0
4 |  |  | 100 |  |  |  |  | 0
5 |  |  | 100 |  |  |  |  | 0
6 |  |  | 100 |  |  |  |  | 0
7 |  |  | 100 |  |  |  |  | 0
8 |  |  | 100 |  |  |  |  | 0
 |  | total | feet  = | 0 | gal/min = | 0 |  | LTAR =
% of [NAME]. |  |  |  | Des. Flow | 0 |  |  | (ltar W/ INOV) | 0
Dose Volume |  | 0 |  | Pump Run= |  |  |  | (ltar + 5%) | 0
Dose Pump Time |  |  |  | Tank Gal/IN | 0
Drawdown in Inches |  |  |  | Elevation Head | 6
Spreadsheet: jeff_dasovich__14112__FIN group project
Sheet: Sheet1

Facts:
20 year lease
min 90% home games
3-yrs to build
est cost: | 363.5
County pd |  | (384 - 45) |  | Assumes project goes over, as most do.
Mariners | 45
 | + >$384
 | + maintenance
 | 10% profits | (not likely)
 |  | Mar/Aug 1st lease
Discount Rate: |  | 0.05 | 0.04 | 0.045 | 0.055 | 0.06 | 0.065
Value 1/1/2019 |  | 250 | 250 | 250 | 250 | 250 | 250
Cost of Building (Expense)
 | $339M over 2.67 years
assumes 1/2 down, 1/2 apon completion | PV 7/1/96
Lease Payments (Revenue)
 | 40 payments of $350,000
 | PV 3/1/99
 | PV 7/1/96
Residual value of stadium 1/1/19
 | PV 7/1/96
NPV of Investments
[NAME]
How long does a baseball stadium last?
At end of 20 stadium will be in new condition, because of maintenance covered by team.
Population | 1990 | 2000 | 1996
 | 1507319 | 1686234
 | 2.4 | 2.34
Cost per Capita
people per hh
Cost per Household
Spreadsheet: 109278d1306184391-conditional-formatting-highlight-criteria-book2
Sheet: Sheet1

 |  | Original | Result
 |  | -16481.8615470002 | -16481.8615470002
 |  | -10917.40196700084 | -10917.40196700084
 |  | 2337.589794999979 | 2337.589794999979
 |  | -187.0387589999903 | -187.0387589999903
 |  | 2150.55103599982 | 2150.55103599982
 |  | -1679.964811 | -1679.964811
 |  | 171.62214 | 171.62214
 |  | -1563.304900000006 | -1563.304900000006
 |  | -1860.532739000004 | -1860.532739000004
 |  | -28.60908999999985 | -28.60908999999985
 |  | -79.33436999999999 | -79.33436999999999
Spreadsheet: 20e745c7-4564-4838-b2a5-4631102bd585
Sheet: Sheet1

History | Unnamed: 1
2011-09-30 00:00:00 | 12
2011-10-31 00:00:00 | 23
2011-11-30 00:00:00 | 30
2011-12-31 00:00:00 | 41
2012-01-31 00:00:00 | 76
2012-02-29 00:00:00 | 98
2012-03-31 00:00:00 | 99
2012-04-30 00:00:00 | 101
2012-05-31 00:00:00 | 100
2012-06-30 00:00:00 | 80
2012-07-31 00:00:00 | 84
2012-08-31 00:00:00 | 80
2012-09-30 00:00:00 | 99
2012-10-31 00:00:00 | 103
2012-11-30 00:00:00 | 125
2012-12-31 00:00:00 | 201
2013-01-31 00:00:00 | 242
2013-02-28 00:00:00 | 259
2013-03-31 00:00:00 | 274
2013-04-30 00:00:00 | 273
2013-05-31 00:00:00 | 258
Spreadsheet: 328153d1403797633-continue-the-series-in-owners-if-a1-owners-assigning-owners
Sheet: Task

Task1
[NAME]
Task3
Task4
Task5
Task6
Task7
Task8
Task9
Task10
Task11
Task12
Task13
Task14
Task15
Task16
Task17
Task18
Task19
Task20
Task21
Task22
Task23
Task24
Task25
Task26
Task27
Task28
Task29
Task30
Task31
Task32
Task33
Task34
Task35
Task36
Task37
Task38
Task39
Task40
Task41
Task42
Task43
[NAME]
Task45
Task46
Task47
Task48
Task49
Task50
Task51
Task52
Task53
Task54
Task55
Task56
Task57
Task58
Task59
Task60
Task61
Task62
Task63
Task64
Task65
Task66
Task67
Task68
Task69
Task70
Spreadsheet: 708554d1607929373-create-an-advanced-report-to-show-average-price-per-brand-sorted-by-country-cat-of-item-dashboard
Sheet: AUSTRALIA

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: 831018d1685359322-need-formula-same-booking-with-multiple-payment-and-remittance-booking-details-1-
Sheet: Sheet1

Booking ID | Remittance# | Amt |  | Result should be
2100 | 55 | 100
1000 | 4 | 5 | For Booking# 1000 paid $ 5 via remittance# 4 | For Booking# 1000 paid $ 5 via remittance# 4
999 | 44 | 10 | For Booking# 999 paid $ 10 via remittance# 44 | For Booking# 999 paid $ 10 via remittance# 44
2100 | 56 | 10 | For Booking# 2100 paid $ 100 via remittance# 55, paid $ 10 via remittance# 56
Spreadsheet: 71defdf8-3e45-4e0e-9d4d-ae7d5ec1e339
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-01-26 15:39:07.790000
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.442 | 101.442 | 101.317 | 100.817 |  | and are added to price quote
5.125 | 100.779 | 100.779 | 100.654 | 100.154
5 | 99.995 | 99.995 | 99.87 | 99.37 |  | Note: | Refer To Price [NAME]
4.875 | 99.889 | 99.889 | 99.764 | 99.264 |  |  | For all Price Adjs
4.75 | 98.963 | 98.963 | 98.838
4.625 | 97.916 | 97.916 | 97.791
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.625 | 101.196 | 101.196 | 101.071 | 100.571
4.5 | 101.006 | 101.006 | 100.881 | 100.381
4.375 | 100.722 | 100.722 | 100.597 | 100.097
4.25 | 100.237 | 100.237 | 100.112 | 99.612
4.125 | 98.814 | 98.814 | 98.689
 |  |  |  |  |  | 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-01-26 15:39:07.790000
 |  |  |  |  |  | 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-02-09 15:39:07.790000
30 DAY | 2011-02-24 15:39:07.790000
45 DAY | 2011-03-11 15:39:07.790000
60 DAY | 2011-03-26 15:39:07.790000
90 DAY | 2011-04-25 15:39:07.790000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 179e53e9-e932-49a6-be8e-f7ae25fa124c
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
 | 5671.0 Lending Finance, Australia
 | TABLE 38. LEASE FINANCE COMMITMENTS, By Purpose: State (ACT), Original (Number, $000)
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
1 . . . [NAME] ; |  |  | Original | A2413863F | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413864J | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413865K | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413866L | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413868T | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413869V | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413870C | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413871F | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413872J | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | A2413873K | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413874L | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413875R | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413876T | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413877V | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413878W | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 101006d1299179208-if-and-if-and-formula-formula-problem-1-
Sheet: Sheet1

 |  | [NAME] | This Column is how it should look
 |  |  |  |  |  | LM Coordinated Audiences | This range named STG Led
Industry Leadership | NEE-UKI |  |  |  |  | Workload Optimized Infrastructure
Industry Leadership | NEE-UKI |  |  |  |  | Workload Optimized Systems
Industry Leadership | SWE-BeNeLux |  |  |  |  | STG - Competitive & Install
Industry Leadership | SWE-France | STG Led | STG Led |  |  | LM Targeted Need-States
Industry Leadership | SWE-Italy | STG Led | STG Led
Industry Leadership | SWE-Italy | STG Led | STG Led |  |  | GMU-ASEAN | This range named country codes
Industry Leadership | SWE-Italy | STG Led | STG Led |  |  | GMU-CEE
LM Coordinated Audiences | GMU-ASEAN | STG Led | STG Led |  |  | GMU-GCG
LM Coordinated Audiences | GMU-ASEAN | STG Led | STG Led |  |  | GMU-India-South Asia
LM Coordinated Audiences | GMU-ASEAN | STG Led | STG Led |  |  | GMU-Korea
LM Coordinated Audiences | GMU-ASEAN | STG Led | STG Led |  |  | GMU-LA-Brazil
LM Coordinated Audiences | GMU-ASEAN | STG Led | STG Led |  |  | GMU-LA-Mexico
LM Coordinated Audiences | GMU-ASEAN | STG Led | STG Led |  |  | GMU-LA-SSA
LM Coordinated Audiences | GMU-CEE | STG Led | STG Led |  |  | GMU-MEA
LM Coordinated Audiences | GMU-CEE | STG Led | STG Led |  |  | NEE-Alps
LM Coordinated Audiences | GMU-GCG | STG Led | STG Led |  |  | NEE-Nordic
LM Coordinated Audiences | GMU-GCG | STG Led | STG Led |  |  | SWE-France
LM Coordinated Audiences | GMU-GCG | STG Led | STG Led |  |  | SWE-Italy
LM Coordinated Audiences | GMU-India-South Asia | STG Led | STG Led
LM Coordinated Audiences | GMU-India-South Asia | STG Led | STG Led
Industry Leadership | GMU-ASEAN | STG Led | STG Led
Industry Leadership | GMU-ASEAN | STG Led | STG Led
Industry Leadership | GMU-ASEAN | STG Led | STG Led
Industry Leadership | GMU-ASEAN | STG Led | STG Led
Industry Leadership | GMU-A/NZ
Industry Leadership | GMU-A/NZ
Industry Leadership | GMU-A/NZ
Industry Leadership | GMU-CEE | STG Led | STG Led
Industry Leadership | GMU-CEE | STG Led | STG Led
Industry Leadership | GMU-CEE | STG Led | STG Led
Industry Leadership | GMU-CEE | STG Led | STG Led
Industry Leadership | GMU-GCG | STG Led | STG Led
Industry Leadership | GMU-India-South Asia | STG Led | STG Led
Industry Leadership | GMU-Korea | STG Led | STG Led
Industry Leadership | GMU-Korea | STG Led | STG Led
Industry Leadership | GMU-MEA | STG Led | STG Led
Industry Leadership | GMU-MEA | STG Led | STG Led
Industry Leadership | GMU-MEA | STG Led | STG Led
Industry Leadership | GMU-MEA | STG Led | STG Led
BAO | GMU-India-South Asia
OIT | GMU-A/NZ
Workload Optimized Systems | NEE-UKI |  | STG Led
Workload Optimized Systems | NA-United States |  | STG Led
Workload Optimized Systems | NA-Canada |  | STG Led