tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 133687d1324545480-automatically-copy-an-entire-row-test
Sheet: Data

 | Main List | Sendto List | Drawing List | Sales List | Bills List | [NAME] | [NAME] | Bank List | China_Travel | Investment
 | Bills |  | [NAME] | Cash | Electricity | Office Equipments | Hosein | Cash | Visa China | [NAME]
 | Sendto |  | [NAME] | Check | Shop Rent | Bank Tax | Ayad | Check | Visa Dubai | Nabil
 | Misc |  | [NAME] | Visa | Motor | Loan | Samer | Visa | Hotel China
 | Salary |  | Samer Zein | Master card | Telephone | Waseet | Abed | Transfer | Hotel Dubai
 | Sales | Safe |  | American Express | Internet & Satellite | Taxi | [NAME] | Tax | Ne3me Office
 | Drawing |  |  | Transfer | Rents | Development | [NAME] | Master [NAME] | Purchase
 | Bank |  |  |  | Insurance | Kitchen & Toilets | Mirvate | American Express | Tickets
 | Travel |  |  |  | Yearly Water | Governmental | Mirvate Commission |  | Customs
 | Investment |  |  |  | Ogero | Updates | Saleh |  | Travel Expenses
 |  |  |  |  | Boecker | Fuel | Overtime
 |  |  |  |  | Orchid Cleaning | Water nestle
 |  |  |  |  |  | Repair
 |  |  |  |  |  | Nescafe & Others
 |  |  |  |  |  | Discharge
 |  |  |  |  |  | Tips
 |  |  |  |  |  | Electric Tools
 |  |  |  |  |  | Advertising
Spreadsheet: 794175d1661926226-search-in-cell-which-includes-specific-value-or-not-vlookup_match-etaf1
Sheet: Sheet1

 | Sales | Sales | Sales | Sales | Stk
Item | 2019 | 2020 | 2021 | 2022 | 2022
CLT-CT201-C101+100 |  |  | 2 | 1 |  |  |  |  |  |  | CLT-CT201 | CLT-CT201 | CLT-CT201 | CLT-CT201 | CLT-CT201
CLT-CT201-C101+125 |  |  | 2 |  |  |  |  |  |  |  | -C101 | -C701 | -C210 | [NAME] | -C504
CLT-CT201-C101+150 |  |  | 1 |  |  |  |  |  |  |  | Black | [NAME] | Transparent | Dark Red | [NAME]
CLT-CT201-C101+150-BC |  |  |  |  | 2 |  |  |  |  | Stk | C101 | C701 | C294 | C124 | C604
CLT-CT201-C101+175 |  | 1 |  | 1 |  |  |  |  |  | +100
CLT-CT201-C101+175-BC |  |  |  |  | 2 |  |  |  |  | +125
CLT-CT201-C101+200 |  | 1 |  |  |  |  |  |  |  | +150
CLT-CT201-C101+225 |  |  | 5 | 1 |  |  |  |  |  | +175
CLT-CT201-C101+250 | 1 | 1 | 3 | 1 |  |  |  |  |  | +200
CLT-CT201-C101+250-BC |  |  |  |  | 2 |  |  |  |  | +225
CLT-CT201-C101+275 |  | 1 |  |  | 1 |  |  |  |  | +250
CLT-CT201-C101+300 |  | 1 |  |  | 1 |  |  |  |  | +275
CLT-CT201-C109+175 |  | 1 |  |  |  |  |  |  |  | +300
CLT-CT201-C109+275 | 1 |  |  |  |  |  |  |  |  | +350
CLT-CT201-C109+300 | 1 |  |  |  |  |  |  |  |  | +400
CLT-CT201-C124+100-BC |  |  |  | 1 |  |  |  |  |  | Total
CLT-CT201-C124+150-BC |  |  |  |  | 1
CLT-CT201-C124+175-BC |  |  |  | 1
CLT-CT201-C124+200-BC |  |  |  |  | 1
CLT-CT201-C124+250-BC |  |  |  |  | 1
CLT-CT201-C124+300-BC |  |  |  |  | 1
CLT-CT201-C204+100 |  | 1 | 1
CLT-CT201-C204+125 | 1
CLT-CT201-C210+100 | 1 |  | 3
CLT-CT201-C210+125 |  | 3 |  | 1
CLT-CT201-C210+150 | 2 | 1 | 2
CLT-CT201-C210+175 | 1 | 1 | 2 | 3 | 1
CLT-CT201-C210+200 | 1 | 1 | 1 | 1
CLT-CT201-C210+225 |  | 4 |  | 1
CLT-CT201-C210+250 | 1 |  | 1 | 1
CLT-CT201-C210+275 |  | 1 | 1 |  | 2
CLT-CT201-C210+300 |  | 1 | 1 |  | 1
CLT-CT201-C294+100-BC |  |  |  |  | 1
CLT-CT201-C294+150-BC |  |  |  |  | 1
CLT-CT201-C294+175-BC |  |  |  |  | 1
CLT-CT201-C294+200-BC |  |  |  |  | 1
CLT-CT201-C294+250-BC |  |  |  |  | 1
CLT-CT201-C504+100 | 1
CLT-CT201-C504+225 |  | 1 | 1 | 3 | 1
CLT-CT201-C504+250 |  |  | 1 | 1 | 1
CLT-CT201-C504+275 |  |  | 1
CLT-CT201-C604+100-BC |  |  |  |  | 1
CLT-CT201-C604+150-BC |  |  |  |  | 1
CLT-CT201-C604+175-BC |  |  |  |  | 1
CLT-CT201-C604+200-BC |  |  |  |  | 1
CLT-CT201-C604+300-BC |  |  |  |  | 1
CLT-CT201-C701+125 | 1 |  | 1 |  | 1
CLT-CT201-C701+150 |  |  | 2
CLT-CT201-C701+150-BC |  |  |  |  | 2
CLT-CT201-C701+175 |  | 1 | 2 | 1
CLT-CT201-C701+175-BC |  |  |  |  | 1
CLT-CT201-C701+200 |  | 1 | 2
CLT-CT201-C701+225 |  | 2 | 2 | 2 | 1
CLT-CT201-C701+250 |  | 1 | 1 | 3 | 2
CLT-CT201-C701+275 |  |  | 1 | 2 | 1
CLT-CT201-C701+300 |  | 1
Grand Total | 12 | 26 | 39 | 25 | 36
Spreadsheet: 717833d1612874749-how-to-count-just-numbers-in-the-second-column-which-are-not-the-same-mysheet
Sheet: Hárok1

 | Val
 | Dátum | nákladové | Prod. | [NAME]
 | 2020-12-01 00:00:00 | 5034 | 2.5 | x
 | 2020-12-02 00:00:00 | 5019 | 2 | x
 | 2020-12-04 00:00:00 | 5021 | 2 | x
 | 2020-12-04 00:00:00 | 5034 | 2 | x
 | 2020-12-08 00:00:00 | 4338 | 4 | x
 | 2020-12-11 00:00:00 | 5028 | 1 | x
 | 2020-12-04 00:00:00 | 5021 | 1 | x
 | 2020-12-04 00:00:00 | 5029 | 3 | x
 | 2020-12-04 00:00:00 | 5090 | 1 | x
 | 2020-12-14 00:00:00 | 4339 | 2 | x
 | 2020-12-14 00:00:00 | 5034 | 1.5 | x
 | 2020-12-16 00:00:00 | 4329 | 3 | x
 | 2020-12-21 00:00:00 | 4332 | 2.5 | x
 | 2020-12-21 00:00:00 | 5101 | 1 | x
 | 2020-12-22 00:00:00 | 4346 | 1.5 | x
 | 2020-12-22 00:00:00 | 5090 | 1 | x
 | 2020-12-22 00:00:00 | 4319 | 1 | x
 | 2020-12-23 00:00:00 | 5020 | 4 | x
 | 2020-12-28 00:00:00 | 4326 | 7.5 | x
 | 2020-12-29 00:00:00 | 5301 | 1.5 | x
 | 2020-12-29 00:00:00 | 5102 | 2 | x
 | 2020-12-29 00:00:00 | 4326 | 3 | x
 | 2020-12-30 00:00:00 | 5019 | 1 | x
 | 2020-12-01 00:00:00 | 5034 | 2 | x
 | 2020-12-01 00:00:00 | 4011 | 3.5 | x
 | 2020-12-03 00:00:00 | 4340 | 0.5 | x
 | 2020-12-04 00:00:00 | 5021 | 2 | x
 | 2020-12-04 00:00:00 | 4314 | 1 | x
 | 2020-12-30 00:00:00 | 4106 | 1 | x
 | 2020-12-30 00:00:00 | 4346 | 1.5 | x
 | 2020-12-01 00:00:00 | 5029 | 1.5 | x
 | 2020-12-02 00:00:00 | 5090 | 1 | x
 | 2020-12-02 00:00:00 | 4103 | 0.5 | x
 | 2020-12-04 00:00:00 | 40 | 1 | x
 | 2020-12-07 00:00:00 | 4338 | 2 | x
 | 2020-12-09 00:00:00 | 5009 | 1 | x
 | 2020-12-10 00:00:00 | 4345 | 1 | x
 | 2020-12-10 00:00:00 | 4339 | 4 | x
 | 2020-12-10 00:00:00 | 5009 | 2 | x
 | 2020-12-11 00:00:00 | 4339 | 1 | x
 | 2020-12-16 00:00:00 | 4315 | 2 | x
 | 2020-12-16 00:00:00 | 4314 | 0.5 | x
 | 2020-12-16 00:00:00 | 4329 | 1 | x
 | 2020-12-18 00:00:00 | 4315 | 1 | x
 | 2020-12-18 00:00:00 | 40 | 0.5 | x
 | 2020-12-21 00:00:00 | 4339 | 5 | x
 | 2020-12-22 00:00:00 | 4339 | 4 | x
 | 2020-12-22 00:00:00 | 5020 | 1 | x
Spreadsheet: 116780d1312159648-inventory-spreadsheet-sales-decrease-values-example
Sheet: stock

SKU | Category | Type | Colour | Qty | Cost US | COST NZ |  | Starting Balance |  | Sold | Remaining
CR1616 | Battery | CR1616 |  | 5 |  |  |  | 5
XbxsRd | Game | [NAME] | Red |  | 1.74 | 1.91 |  | 5
XbxsWt | Game | [NAME] | White |  | 1.74 | 1.91 |  | 5
XbxsYw | Game | [NAME] | Yellow |  | 1.74 | 1.91 |  | 5
NK503hp | Phone | Nokia BH503 Headphones |  |  |  |  |  | 5
Spreadsheet: 708645d1607960857-multiply-one-cell-by-multiple-criteria-depending-on-the-value-book1-1-
Sheet: Sheet1

 |  |  |  |  |  |  | Band starts at
 |  |  |  |  |  |  | 1 | 75
 |  |  |  |  |  |  | 7 | 100
 |  |  |  |  |  |  | 13 | 150
 |  |  |  |  |  |  | 19 | 200
 |  |  |  |  |  |  |  |  |  |  |  | EITHER | OR
 |  |  |  |  |  |  |  |  | Date | Agent | Total Sales | Commission
 |  |  |  |  |  |  |  |  | 12/14/2020 | [NAME] | 7
 |  |  |  |  |  |  |  |  | 12/14/2020 | [NAME] | 10
 |  |  |  |  |  |  |  |  | 12/14/2020 | [NAME] | 13
 |  |  |  |  |  |  |  |  | 12/14/2020 | [NAME] | 20
Spreadsheet: 686064d1594337005-index-match-with-multiple-criteria-indexmatch
Sheet: Sheet1

Table: Results
Result | Order | Unit
A4 | 2 | 765446
Table: Criteria
Order | Category | Group
1 | AAA | 123
2 | AAA | 234
3 | BBB | 123
4 | BBB | 234
1 | TTT | 678
2 | RRR | 678
3 | TTT | 789
4 | RRR | 789
Table: Data
Unit | Category | Group | Result
345655 | BBB | 234 | A1
653234 | TTT | 678 | B2
653234 | TTT | 789 | A2
653234 | RRR | 789 | B3
543221 | AAA | 123 | A3
765446 | RRR | 789 | B4
765446 | RRR | 678 | A4
234323 | AAA | 234 | B5
765446 | TTT | 789 | A5
765432 | RRR | 789 | B6
567743 | BBB | 123 | A6
788766 | BBB | 234 | B7
345222 | TTT | 678 | A7
876578 | AAA | 123 | B8
876558 | AAA | 234 | A8
134432 | TTT | 789 | B9
245556 | RRR | 678 | A9
Spreadsheet: 839214d1691757039-sumifs-results-in-value-error-simple-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Projected Time | Projected Time
 | Summary Line --> |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gru |  |  |  | Party Overview
 |  |  |  | Gather Ingredients |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | Gru |  |  |  | Assigned To | Projected Hours
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | Gru
 |  |  |  |  | Water |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | Gru |  |  |  | [NAME]
 |  |  |  |  | Batter |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | Gru |  |  |  | Minion 1
 |  |  |  |  | Icing |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  | Gru |  |  |  | Minion 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Summary Line --> |  | Get Supplies |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Minion 1
 |  |  |  | Drive to Store |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | Minion 1
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  | Minion 2
 |  |  |  |  | Table cloth |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | [NAME]
 |  |  |  |  | Plasticware |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | Minion 1
Spreadsheet: 539022d1505926156-sort-by-month-into-two-separate-columns-sample-workbook
Sheet: After

Item Code | PO Date July | Po Date  August | Unit Cost | Qty Received
Spreadsheet: 58689d1258965313-create-a-popup-window-ocean_test
Sheet: locked_data

Users | yes_no | 1_2 | crimp_adj_style | crimp_type
[NAME] | Yes | 1 | S3A | F
Cathy | No | 2 | HD FINE ADJUST | O
Zach |  |  |  | None
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 271401d1381929903-excel-countif-with-drop-down-selection-form
Sheet: Form Responses

Date | Reason
2013-10-01 00:00:00 | Reason1
2013-10-01 00:00:00 | Reason2
2013-10-01 00:00:00 | Reason3
2013-10-01 00:00:00 | Reason4
2013-10-01 00:00:00 | Reason5
2013-10-02 00:00:00 | Reason1
2013-10-02 00:00:00 | Reason2
2013-10-02 00:00:00 | Reason3
2013-10-02 00:00:00 | Reason4
2013-10-02 00:00:00 | Reason5
2013-10-03 00:00:00 | Reason1
2013-10-03 00:00:00 | Reason2
2013-10-03 00:00:00 | Reason3
2013-10-03 00:00:00 | Reason4
2013-10-03 00:00:00 | Reason5
2013-10-04 00:00:00 | Reason1
2013-10-04 00:00:00 | Reason2
2013-10-04 00:00:00 | Reason3
2013-10-04 00:00:00 | Reason4
2013-10-04 00:00:00 | Reason5
2013-10-05 00:00:00 | Reason1
2013-10-05 00:00:00 | Reason2
2013-10-05 00:00:00 | Reason3
2013-10-05 00:00:00 | Reason4
2013-10-05 00:00:00 | Reason5
2013-10-06 00:00:00 | Reason1
2013-10-06 00:00:00 | Reason2
2013-10-06 00:00:00 | Reason3
2013-10-06 00:00:00 | Reason4
2013-10-06 00:00:00 | Reason5
2013-10-07 00:00:00 | Reason1
2013-10-07 00:00:00 | Reason2
2013-10-07 00:00:00 | Reason3
2013-10-07 00:00:00 | Reason4
2013-10-07 00:00:00 | Reason5
2013-10-08 00:00:00 | Reason1
2013-10-08 00:00:00 | Reason2
2013-10-08 00:00:00 | Reason3
2013-10-08 00:00:00 | Reason4
2013-10-08 00:00:00 | Reason5
2013-10-09 00:00:00 | Reason1
2013-10-09 00:00:00 | Reason2
2013-10-09 00:00:00 | Reason3
2013-10-09 00:00:00 | Reason4
2013-10-09 00:00:00 | Reason5
2013-10-10 00:00:00 | Reason1
2013-10-10 00:00:00 | Reason2
2013-10-10 00:00:00 | Reason3
2013-10-10 00:00:00 | Reason4
2013-10-10 00:00:00 | Reason5
Spreadsheet: 34247d1231408722-consolidate-data-from-multiple-worksheets-example_2
Sheet: OPRA Codes

OPRA Code | Category
A01 | Landfill
A02 | Landfill
A03 | Landfill
A04 | Landfill
A05 | Landfill
A06 | Landfill
A07 | Landfill
A08 | Landfill
A09 | Transfer
A10 | Transfer
A11 | Transfer
A12 | Transfer
A13 | Transfer
A14 | Transfer
A15 | Transfer
A16 | Recovery
A17 | Recovery
A18 | Incinerator
A19 | Recycling
A19a | Recycling
A20 | Recycling
A21 | Recovery
A22 | Composting
A23 | Recovery
A24 | Recovery
Spreadsheet: 738510d1625072548-help-building-if-formula-for-conditional-formatting-chart-presentation
Sheet: Sheet1

 |  | Column G | Column H | Column J
 |  | Type | Up or [NAME] | Time |  |  | Text Colour Presentation
 |  | Standard | Down | 01:32:00
 |  | Standard | Down | 01:27:26 |  |  | Condition ‘Standard and Condition ‘Up:
 |  | Standard | Down | 01:15:55 |  |  | If Column J is exactly 00:00:01 then colour should be Green (starting position)
 |  | Standard | Down | 01:14:53 |  |  | If Column J is less than 00:25:00 but greater than 00:00:01 then colour should be Red.
 |  | Standard | Down | 01:09:00 |  |  | If Column J is less than 00:29:59 but greater than 00:24:99 then colour should be Amber.
 |  | Standard | Up | 01:08:43 |  |  | If Column J is less than 00:59:59 but greater than 00:30:00 then colour should be Green
 |  | Standard | Up | 01:05:28
 |  | Standard | Down | 01:05:23 |  |  | Condition ‘Standard and Condition ‘Down’:
 |  | Standard | Down | 01:03:36 |  |  | If Column J is between [NAME] and 01:29:59 then Column J should be Green.
 |  | Standard | Up | 01:03:29 |  |  | If Column J is between 01:30:00 and 01:44:59 then Column J should be Amber.
 |  | Standard | Down | 01:03:01 |  |  | If Column J is greater than 01:45:00 then Column J should be Red.
 |  | Standard | Down | 01:01:39
 |  | Standard | Down | 00:59:22 |  |  | Condition ‘Reserved’ and Condition ‘Up:
 |  | Standard | Up | 00:58:50 |  |  | If Column J is less than 00:02:59 then Column J should be Red
 |  | Standard | Up | 00:58:09 |  |  | If Column J is between 00:03:00 and 00:04:59 then Column J should be Amber.
 |  | Standard | Up | 00:58:09 |  |  | If Column J is between 00:05:00 and [NAME] then Column J should be Green.
 |  | Standard | Down | 00:55:46 |  |  | If Column J is between 01:00:01 and 01:29:59 then Column J should be Amber.
 |  | Standard | Down | 00:55:13 |  |  | If Column J is greater than 01:30:00 then Column J should be Red.
 |  | Reserved | Up | 00:06:22
 |  | Reserved | Up | 00:04:45
 |  | Reserved | Up | 00:04:20
 |  | Reserved | Up | 00:04:15
 |  | Reserved | Up | 00:03:14
 |  | Reserved | Up | 00:02:49
 |  | Reserved | Up | 00:02:02
 |  | Reserved | Up | 00:00:28
 |  | Reserved | Up | 00:00:25
 |  | Reserved | Up | 00:00:24
 |  | Reserved | Up | 00:00:24
 |  | Reserved | Up | 00:00:23
 |  | Reserved | Up | 00:00:21
 |  | Reserved | Up | 00:00:17
 |  | Standard | Up | 00:00:01
 |  | Standard | Up | 00:00:01
Spreadsheet: 73581d1274218052-chart-based-on-conditions-copy-of-book1-2
Sheet: Sheet1

Car | Number Plate | Workscope | Cost | Sale | Margin
BMW | 42234 | A | 120 | 140 | 20
Mercedes | 12345 | B | 50 | 80 | 30
Ford | 54321 | A | 90 | 150 | 60
VW | 34322 | A | 80 | 140 | 60
Honda | 21343 | B | 80 | 90 | 10
Mercedes | 12312 | B | 40 | 70 | 30
BMW | 12322 | A | 130 | 150 | 20
 | I want to create a graph that will automatically pick out information showing BMW and Workscope A Sales and a separate graph showing Mercedes Workscope B costs
 |  | Car | Mercedes
 |  | Workscope | B
 |  |  | Data
 |  |  | Sum of Cost | Sum of Sale | Sum of Margin
 |  | Total | 90 | 150 | 60
Spreadsheet: 4dd879ea-0475-4c93-84ed-e56c56c3286e
Sheet: Sheet1

Asthma/Bronchitis Emergency Department Visits by Year, Maine, 2000-2009 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Year | Number | Crude Rate |  | Age-adjusted Rate
 |  | Rate | 95% CI | Rate | 95% CI
2000 | 13945 | 1091.8 | 1073.7 - 1110.0 | 1133 | 1114.1 - 1152.1
2001 | 15223 | 1185.2 | 1166.4 - 1204.1 | 1239.6 | 1219.8 - 1259.6
2002 | 14139 | 1092.3 | 1074.3 - 1110.4 | 1150.7 | 1131.6 - 1170.1
2003 | 15050 | 1152.6 | 1134.3 - 1171.2 | 1219.5 | 1199.8 - 1239.4
2004 | 13074 | 992.5 | 975.6 - 1009.7 | 1052.3 | 1034.1 - 1070.8
2005 | 14547 | 1100.8 | 1083.0 - 1118.8 | 1165.7 | 1146.5 - 1185.1
2006 | 13977 | 1057.6 | 1040.1 - 1075.3 | 1116.4 | 1097.7 - 1135.4
2007 | 13332 | 1012.1 | 995.0 - 1029.5 | 1078.6 | 1060.1 - 1097.4
2008 | 14068 | 1068.6 | 1051.0 - 1086.4 | 1137.9 | 1118.8 - 1157.2
2009 | 13674 | 1037.2 | 1019.9 - 1054.8 | 1104.6 | 1085.7 - 1123.6
Asthma/Bronchitis  ED Visits: ED Visits with [NAME] or Bronchitis (ICD9-CM codes: 493 or 466) as the principal diagnosis.
Crude rates are ED visits per 100,000 population
Age-adjusted rates are ED visits per 100,000 population age-adjusted to the U.S. 2000 standard population
95% CI: 95% confidence interval of the rate.
Data Source: Maine Hospital Inpatient and Outpatient Databases; Maine Health Data Organization
Spreadsheet: benjamin_rogers__1245__test model from Erin
Sheet: 144A DEBT

DELMARVA, VA
Debt Service Phase II
0
Year
Contract year
Months /year
Tranche 1:
Lender | Long Term |  | Check
Principal: |  | M
Interest Rate: |  | Annual
Term |  | Semiannual Periods
Amortization Method
Grace Period |  | Years
144A
Payment Principal
Debt
Principal
Interest
Payment
Ending Balance
Payment Principal |  | 0
Debt
Principal
Interest |  | 0
Payment
Ending Balance
Summary
Interest
Principal
Total Payment
DSRF Maintenance
Beginning Balance
(Addition)/release
LC Charge for DSRF
Term Outstanding |  | 0.5 | 1.5 | 2.5 | 3.5 | 4.5 | 5.5 | 6.5 | 7.5 | 8.5 | 9.5 | 10.5 | 11.5 | 12.5 | 13.5 | 14.5 | 15.5 | 16.5 | 17.5 | 18.5 | 19.5 | 20.5
Bond-Years
Term Outstanding |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
Bond-Years
Average Life
Spreadsheet: 713497d1610740503-indirect-formula-example-1-1-
Sheet: Sheet1

 |  |  |  |  | Prior | Prior | Prior | 2019 |  |  |  |  |  |  |  | To Comp | To Comp
 |  |  | 1100R | NEW EQUIPMENT | 1.5 | 1.2 | 1.6 | 1.8 | 1.4 | 2 | 2.1 | 2.2 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4
 |  |  | 1200R | SERVICE | 7.5 | 6 | 8 | 9 | 7 | 10 | 10.5 | 11 | 12 | 12 | 12 | 12 | 12
 |  |  | 1100R | UPGRADE | 3 | 2.4 | 3.2 | 3.6 | 2.8 | 4 | 4.2 | 4.4 | 4.8 | 4.8 | 4.8 | 4.8 | 4.8
 |  |  | 1100R | ARRIVE | 4.5 | 3.6 | 4.800000000000001 | 5.4 | 4.199999999999999 | 6 | 6.300000000000001 | 6.600000000000001 | 7.199999999999999 | 7.199999999999999 | 7.199999999999999 | 7.199999999999999 | 7.199999999999999
 |  |  | 1100A | NEW EQUIPMENT | 1.5 | 1.2 | 1.6 | 1.8 | 1.4 | 2 | 1.8 | 2 | 2 | 2 | 2 | 2 | 2
 |  |  | 1200A | SERVICE | 7.5 | 6 | 8 | 9 | 7 | 10 | 9 | 10 | 10 | 10 | 10 | 10 | 10
 |  |  | 1100A | UPGRADE | 3 | 2.4 | 3.2 | 3.6 | 2.8 | 4 | 3.6 | 4 | 4 | 4 | 4 | 4 | 4
 |  |  | 1100A | ARRIVE | 4.5 | 3.6 | 4.800000000000001 | 5.4 | 4.199999999999999 | 6 | 5.4 | 6 | 6 | 6 | 6 | 6 | 6
 |  |  |  | $M | Prior | FY20 | FY21 | FY22 | FY23 | FY24 | FY25 | FY26 | To Comp | Total
 |  |  | NEW EQUIPMENT | 1100A |  |  |  |  |  |  |  |  |  | 0
 |  |  | NEW EQUIPMENT | 1100R |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Change |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | $M | Prior | FY20 | FY21 | FY22 | FY23 | FY24 | FY25 | FY26 | To Comp | Total
 |  |  | SERVICE | 1200A |  |  |  |  |  |  |  |  | 0 | 0
 |  |  | SERVICE | 1200R |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Change | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | $M | Prior | FY20 | FY21 | FY22 | FY23 | FY24 | FY25 | FY26 | To Comp | Total
 |  |  | UPGRADE | 1100A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | UPGRADE | 1100R | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | Change | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | $M | Prior | FY20 | FY21 | FY22 | FY23 | FY24 | FY25 | FY26 | To Comp | Total
 |  |  | UPGRADE | 1100A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | UPGRADE | 1100R | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | Change | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 456549d1460939017-copy-items-from-dropdown-list-to-new-sheets-meal-choices-16-04-15-new-test-a
Sheet: TUE - HOSPITAL

DATE/DAY |  |  |  |  |  |  | DATE/DAY |  |  |  |  |  |  |  | Vegetables
TOTAL MEALS |  |  |  | Total |  | FROZENS | TOTAL MEALS |  |  |  |  |  | FROZENS |  | Mash/Baked Potato
BOTTOM |  |  |  |  |  |  | BOTTOM |  |  |  |  |  |  |  | Baked Pumpkin |  | Friel | Mash Potato
TOTAL MEALS |  |  |  |  |  | 7 | TOTAL MEALS |  |  |  |  |  | 7 |  | Peas
BEEF & VEGETABLE SOUP |  |  |  |  |  |  | BEEF & VEGETABLE SOUP |  |  |  |  |  |  |  |  |  | Dries | [NAME] to Megan @ Centrelink
PORK STEAK |  |  |  |  |  |  | PORK STEAK |  |  |  |  |  |  |  | Sweet
LASAGNE |  |  |  |  |  |  | LASAGNE |  |  |  |  |  |  |  | Apple, Peach & Custard |  | Cocking | Jelly - No Fruit or [NAME]
SWEETS | DIABETIC |  |  |  |  | 7 | SWEETS | DIABETIC |  |  |  |  | 7
YOGHURT | JELLY |  |  |  |  |  | YOGHURT | JELLY
APPLE JUICE | ORANGE JUICE |  |  |  |  | 7 | APPLE JUICE | ORANGE JUICE |  |  |  |  | 7 |  | Soup
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Beef & Vegetable
DRIES |  | 7 FROZ MEALS, SW, MXD JUICE
MIDDLE |  |  |  |  |  |  | MIDDLE
TOTAL MEALS |  |  |  |  |  | 4 | TOTAL MEALS
 | DIABETIC |  |  |  |  |  |  | DIABETIC
 | JELLY |  |  |  |  |  |  | JELLY
 | ORANGE JUICE |  |  |  |  | 4 |  | ORANGE JUICE
MUGIVEN |  | NO PINE OR CITRUS JELLY
KINGDOM |  | 4 FROZ, MXD JUICE
TOP |  |  |  |  |  |  | TOP
TOTAL MEALS |  |  |  |  |  |  | TOTAL MEALS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FISH
 |  |  |  |  |  |  |  |  |  |  |  |  |  | LAMB
 | DIABETIC |  |  |  |  |  |  | DIABETIC |  |  |  |  |  | [NAME]
 | JELLY |  |  |  |  |  |  | JELLY |  |  |  |  |  | YOGH
 | ORANGE JUICE |  |  |  |  |  |  | ORANGE JUICE
CHAFFEY |  | NO PEAS (FISH) |  |  |  |  | CHAFFEY
BARNIER |  | 1 PUREE MEAL (LAMB)
COCKING |  | NO CITRUS FLAVOUR JELLY
Spreadsheet: 687511d1595257248-stack-columns-that-are-not-next-to-each-other-2020-07-18-oeldere2-herbie000-687200d1595015283-stack-columns-that-are-not-next-to-each-othe
Sheet: Sheet1

New | New2 | New3 |  | Pur | Pur2 | Pur3 |  | Example of what I am looking for, this is A and E "stacked"
111 | 222 | 333 |  | 999 | 1010 | 1111 |  | 111
444 | 555 | 666 |  | 888 | 1212 | 1313 |  | 444
555 | 5656 | 5757 |  | 2020 | 2021 | 2021 |  | 555
 |  |  |  |  |  |  |  | 999
 |  |  |  |  |  |  |  | 888
 |  |  |  |  |  |  |  | 2020
Spreadsheet: 0fb4d8d7-901f-4e5b-98d9-15a0b5c76a43
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 5. PERSONAL FINANCE COMMITMENTS, Revolving Credit Stocks and Flows: Australia, Original ($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
New and increased credit limits - Secured ; |  |  | Original | A2413482A | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
New and increased credit limits - Unsecured ; |  |  | Original | A2413483C | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
New and increased credit limits - Total ; |  |  | Original | A2413484F | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Cancellations and reductions ; |  |  | Original | A2413485J | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Total credit limits at end of month ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Credit used at end of month ; |  |  | Original | A2413487L | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012