tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 078119a2-a436-466a-bcbb-a4d66014aec8
Sheet: Table 3.2

Monthly Statistical Bulletin
3.2 Non-farm gross domestic product
Quarter | 2009–10 | 2010–11 | 2011–12 | 2012-13 | 2013-14
Current prices (a) – $ million
September | 306117 | 336490 | 360948 | 367983 | 381145
December | 313951 | 342158 | 362278 | 370819
March | 321267 | 345418 | 364665 | 374451
June | 332324 | 354005 | 368245 | 378866
Annual | 1271685 | 1378140 | 1456376 | 1492501
Chain volume measures (a) (b) – $ million
September | 340151 | 348194 | 359027 | 371353 | 379647
December | 342887 | 351683 | 362381 | 373351
March | 344955 | 350384 | 366538 | 374927
June | 346541 | 354487 | 368431 | 377312
Annual | 1374534 | 1404747 | 1456376 | 1496949
Quarterly change (a) (c) – per cent
September | 0.4800222139510701 | 0.4769998355173 | 1.280723975773435 | 0.7930928722067465 | 0.618851242473073
December | 0.8043486569200065 | 1.002027605300504 | 0.9341915789063293 | 0.538032545852607
March | 0.603114145476491 | -0.3693667308342974 | 1.147135197485527 | 0.4221228816850608
June | 0.4597701149425371 | 1.171000958947888 | 0.5164539556608005 | 0.6361238321059837
Annual change (a) (c)  –  per cent
September | 0.9086647996962238 | 2.36453810219579 | 3.111196631762758 | 3.433167979009943 | 2.233454422072789
December | 2.715519049074056 | 2.565276607162126 | 3.041944023452947 | 3.027200653455897
March | 2.102702078727003 | 1.57382847038019 | 4.610370336545055 | 2.288712220833866
June | 2.367617258349441 | 2.29294657774981 | 3.933571611934994 | 2.410492059571534
Annual | 2.022360491862529 | 2.198054031402652 | 3.675323741570535 | 2.785887710316559
(a) Quarterly figures are seasonally adjusted.
(b) Reference year for chain volume measures is 2011–12.
(c) In chain volume measures.
Source: ABS, Australian national accounts: national income, expenditure and product, | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5206.0&viewtitle=Australian%20National%20Accounts:%20National%20Income,%20Expenditure%20and%20Product~Dec%202007~Latest~5/03/2008&&tabname=Past%20Future%20Issues&prodno=5206.0&issue=Dec%202007 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5206.0&viewtitle=Australian%20National%20Accounts:%20National%20Income,%20Expenditure%20and%20Product~Dec%202007~Latest~5/03/2008&&tabname=Past%20Future%20Issues&prodno=5206.0&issue=Dec%202007
Cat. no. 5206.0 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5206.0&viewtitle=Australian%20National%20Accounts:%20National%20Income,%20Expenditure%20and%20Product~Dec%202007~Latest~5/03/2008&&tabname=Past%20Future%20Issues&prodno=5206.0&issue=Dec%202007 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5206.0&viewtitle=Australian%20National%20Accounts:%20National%20Income,%20Expenditure%20and%20Product~Dec%202007~Latest~5/03/2008&&tabname=Past%20Future%20Issues&prodno=5206.0&issue=Dec%202007 |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2014-03-05 00:00:00
Spreadsheet: 178366d1346773765-excel-game-american-states-fifty-states
Sheet: Sheet1

 |  |  |  |  |  |  |  | Louisiana | Kentucky | Maine | Iowa | North Carolina
 |  |  |  |  |  |  |  | New Jersey | Alaska | Indiana | West Virginia | Nebraska
 | #1 | Ohio |  | #26 |  |  |  | Idaho | Alabama | Wisconsin | Illinois | Georgia
 | #2 | Louisiana |  | #27 |  |  |  | Utah | Washington | Maryland | New York | Ohio
 | #3 | California |  | #28 |  |  |  | Hawaii | Arizona | Minnesota | Delaware | Wyoming
 | #4 | Washington |  | #29 |  |  |  | Arkansas | South Carolina | Connecticut | Michigan | Mississippi
 | #5 | Utah |  | #30 |  |  |  | Nevada | Kansas | California | Virginia | Oregon
 | #6 | Illinois |  | #31 |  |  |  | New Hampshire | Colorado | New Mexico | North Dakota | Montana
 | #7 | Vermont |  | #32 |  |  |  | Massachusetts | Rhode Island | Pennsylvania | Vermont | Tennessee
 | #8 | Idaho |  | #33 |  |  |  | Oklahoma | South Dakota | Texas | Florida | Missouri
 | #9 | North Dakota |  | #34
 | #10 | South Dakota |  | #35
 | #11 | North Carolina |  | #36
 | #12 | South Carolina |  | #37
 | #13 | Florida |  | #38
 | #14 | Texas |  | #39
 | #15 |  |  | #40
 | #16 |  |  | #41
 | #17 |  |  | #42
 | #18 |  |  | #43
 | #19 |  |  | #44
 | #20 |  |  | #45
 | #21 |  |  | #46
 | #22 |  |  | #47
 | #23 |  |  | #48
 | #24 |  |  | #49
 | #25 |  |  | #50
Spreadsheet: daren_farmer__5071__HPLN0522
Sheet: Sheet1

HPLN0522.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - May 22, 2001
 |  |  |  |  |  | **Tuesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-05-22 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | Sandhills |  | Enron | 8 | 8
 |  | 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: e31343ea-6a35-4194-9e82-f03c9dea31a7
Sheet: Sheet1

Texas Public Community, Technical, and State Colleges | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Average Budgeted Faculty Salary by Sector
FY 2013
 | Community Colleges | State Colleges | Technical Colleges | All Sectors
FY 2013
FTE Faculty | 8785 | 166 | 322 | 9257
Average Salary | 55024.22203215874 | 46461.57831325301 | 36315.28571428572 | 54219.89272982608
FY 2012
FTE Faculty | 8629 | 164 | 337 | 9130
Average Salary | 54669.34326109631 | 44264.16463414634 | 35487.33827893175 | 53774.40514786418
% Change
FTE Faculty | 0.018 | 0.012 | -0.045 | 0.014
Average Salary | 0.006 | 0.05 | 0.023 | 0.008
 |  |  |  | Last Updated August, 2013
Spreadsheet: 826923d1682371704-accumulating-monthly-data-into-annual-based-on-indicate-in-group-b-excel_help
Sheet: Sheet1

Group A
Date | A
2026 Jan | 3 |  |  |  |  | Group B
2026 Feb | 4 |  |  |  |  | Year | 2026 | 2027
2026 Mar | 5 |  |  |  |  | A
2026 Apr | 2
2026 May | 4
2026 Jun | 46
2026 Jul | 7
2026 Aug | 8
2026 Sep | 9
2026 Oct | 4 |  |  | I want to accumulate monthly data into annual based on indicate in group B
2026 Nov | 3
2026 Dec | 5
2027 Jan | 6
2027 Feb | 7
2027 Mar | 8
2027 Apr | 9
2027 May | 0
2027 Jun | 4
2027 Jul | 4
2027 Aug | 4
2027 Sep | 2
2027 Oct | 2
2027 Nov | 2
2027 Dec | 2
Spreadsheet: 710337d1608851861-help-pulling-data-from-a-range-attendance-template
Sheet: February

Employee Absence Schedule
February | Dates of Absence |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Employee Name | 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 | 302 | 31 | CL | T | NCNS | Total Points
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] |  |  |  |  |  | T | T
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Obed Attamah
[NAME]
[NAME]
Keath Grimes
[NAME]
[NAME]
[NAME]
[NAME]
 |  |  |  |  |  | Cl | Call-in |  |  | T |  |  |  | NCNS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No show
Spreadsheet: 101282d1299443471-excel-2007-alphabetize-4-letters-in-a-single-cell-formula-fourlettersalpha
Sheet: Sheet1

Problem 1 - Alphabetize a 3 letter word using a single cell formula
Start | Single Letters |  |  | Code of single letters |  |  | Small sort of codes |  |  | Alpha of Start
DRG |  |  |  |  |  |  |  |  |  |  | <<[NAME] Formula
 |  |  |  |  |  |  |  |  |  |  | <<Single Cell Alpha Formula - YEAH!
[NAME] a 4 letter word using a single cell formula
Start |  |  |  |  | Code of single letters |  |  |  | Small sort of codes |  |  |  | Alpha of Start
saab |  |  |  |  |  |  |  |  |  |  |  |  |  | <<[NAME] Formula
 |  |  |  |  |  |  |  |  |  |  |  |  |  | <<Here is where I'm going but stuck
 |  |  |  |  |  |  |  |  |  |  |  |  |  | <<[NAME] cell [NAME]
If Small({68,82,71),1) = 68  -- Why can't I do [NAME]) ???
Spreadsheet: 695827d1600419501-using-if-and-and-score-predictions-calcs_chris
Sheet: Sheet1

 |  |  |  |  |  |  | 2020-09-18 00:00:00
 |  |  |  |  |  |  | Milan | Inter | goal difference
 |  |  |  |  |  |  | 3 | 2
 |  | Milan | Inter | points
 | [NAME] | 3 | 2 | 3
 | [NAME] | 4 | 1 | 1
 | [NAME] | 2 | 1 | 2
 | Juan | 0 | 0 | 0
 | [NAME] | 1 | 2 | 0
 | Jumana | 4 | 3 | 2
 | Jasmine | 3 | 2 | 2
 | [NAME] | 1 | 1 | 0
Spreadsheet: 544395d1508877356-autopopulate-dates-from-table-to-monthly-calendar-calendar_test
Sheet: Assignments

 | MONTH VIEW | WEEK VIEW | MISC DUE
 | ASSIGNMENTS
 | Description | DUE DATE | DUE DATE
 | Job 1 | 2017-10-25 00:00:00
 | Job 2 | 2017-10-31 00:00:00
 | Job 3
 | Job 4
 | Job 5
 | Job 6
 | Job 7
 | Job 8
 | Job 9
 | Job 10
 | Job 11
 | Job 12
Spreadsheet: 769690d1645636849-would-like-to-create-an-intelligent-variable-list-capability-matrix-test
Sheet: Locations

ID | Country | City | Flight time | Drinks prices | Menu | Wild Animals | Police | Climate
 | USA | WDC | 7 | 1 | 3 | 0 | 2 | 2
 | USA | NYC | 7 | 1 | 2 | 0 | 2 | 2
 | USA | LA | 10 | 1 | 4 | 2 | 3 | 2
 | USA | Chicago | 8 | 3 | 0 | 1 | 1 | 3
 | UK | Tooting | 0 | 3 | 0 | 2 | 1 | 2
 | UK | Tring | 0 | 3 | 0 | 4 | 1 | 4
 | UK | Barnsley | 1 | 4 | 1 | 1 | 2 | 4
 | Germany | Dresden | 3 | 2 | 2 | 0 | 2 | 2
 | Germany | Bonn | 2 | 4 | 1 | 1 | 2 | 4
 | NorthKorea | KimsPalace | 15 | 2 | 1 | 1 | 2 | 3
 | PRC | TianamenSq | 18 | 2 | 1 | 2 | 5 | 2
 | PRC | HongKong | 18 | 3 | 1 | 2 | 5 | 4
 | PRC | GreatWall | 13 | 2 | 1 | 2 | 5 | 2
 | NZ | Hills | 24 | 2 | 1 | 3 | 5 | 2
 | NZ | Beach | 24 | 2 | 1 | 2 | 2 | 2
 | Cuba | Havana | 10 | 2 | 1 | 2 | 2 | 2
 | Cuba | Guantanamo | 10 | 3 | 3 | 3 | 2 | 3
 | Spain | El_Cafe | 2 | 0 | 2 | 2 | 2 | 2
 | Spain | El_Bar | 2 | 3 | 2 | 2 | 2 | 3
 | Spain | El_Disco | 2 | 3 | 2 | 2 | 2 | 3
Spreadsheet: 270999d1381779070-help-populating-a-proposal-sheet-from-a-data-row-in-same-workbook-master-sales-pipeline-demo
Sheet: Proposal

 |  |  |  |  |  | Date: | Today's Date auto fill
Customer: |  | Lead Name from Master Sales SHEET
Address: |  | Address from from Master Sales SHEET
Qty: | Item: | Treatment and Services |  |  |  |  | Unit Price: | Total Price:
0 | Treatment | Treatment Services |  |  |  |  | 0.5 |  |  | Clmn F  Potential Opportunity from Master Sales Sheet
 |  | NOTE:  [NAME] treatment based upon .50 cents per square foot
 |  | Quarterly Retreats on High traffic areas. ($ )
1 | Treatment | Hand Wipe Treatment-Electronics |  |  |  |  | 0
1 | Antimicrobial | Antimicrobial Solution |  |  |  |  | 0
1 | Preparation | Clean and Disinfect Surface Preparation for  Application |  |  |  |  | 0
1 | Materials | [NAME] |  |  |  |  | 0
 |  |  |  |  |  |  | Sub Total
 |  |  |  |  |  |  | sales tax | 0
 |  |  |  |  |  |  | Total
 |  |  |  |  |  |  | Deposit | 0 |  | Clmn K  Deposit received from Master Sales Sheet
 |  |  |  |  |  |  | Investment
 |  |  | Terms & Description of Services Provided:
Customer:
Spreadsheet: 754584d1636351548-countifs-and-indirect-formula-when-there-are-more-than-one-criteria-countifs-example
Sheet: Dental

Name | Staff ID | Staff type | Employed as/student type | Job description | Populated
Name 1 | ID 1 | Academic | Teaching & Research | Associate Professor | 0
Name 2 | ID 2 | Non-academic | Adjunct | Clinical Senior Lecturer
Name 3 | ID 3 | Non-academic | Adjunct | Clinical Associate Professor
Name 4 | ID 4 | Non-academic | Adjunct | Clinical Senior Lecturer
Name 5 | ID 5 | Non-academic | Adjunct | Clinical Professor
Name 6 | ID 6 | Non-academic | Adjunct | Clinical Senior Lecturer
Name 7 | ID 7 | Non-academic | Staff | Dental Specialist
Name 8 | ID 8 | Academic | Teaching & Research | Senior Lecturer | 0
Name 9 | ID 9 | Academic | Teaching | Clinical Dental Academic | 1
Name 10 | ID 10 | Academic | Teaching & Research | Senior Lecturer | 3
Name 11 | ID 11 | Non-academic | Adjunct | Adjunct Senior Lecturer
Name 12 | ID 12 | Non-academic | Adjunct | Adjunct Senior Lecturer
Name 13 | ID 13 | Academic | Teaching & Research | Head of Division | 3
Name 14 | ID 14 | Non-academic | Adjunct | Clinical Senior Lecturer
Name 15 | ID 15 | Non-academic | Adjunct | Adjunct Senior Lecturer
Name 16 | ID 16 | Academic | Teaching & Research | Senior Lecturer | 2
Name 17 | ID 17 | Academic | Teaching & Research | Senior Lecturer | 1
Name 18 | ID 18 | Academic | Teaching & Research | Senior Lecturer | 3
Name 19 | ID 19 | Non-academic | Adjunct | Adjunct Senior Lecturer
Name 20 | ID 20 | Non-academic | Adjunct | Clinical Senior Lecturer
Name 21 | ID 21 | Non-academic | Adjunct | Adjunct Senior Lecturer
Name 22 | ID 22 | Academic | Teaching & Research | Head of Division | 0
Name 23 | ID 23 | Academic | Teaching & Research | Senior Lecturer | 0
Name 24 | ID 24 | Non-academic | Adjunct | Adjunct Senior Lecturer
Name 25 | ID 25 | Non-academic | Adjunct | Clinical Associate Professor
Name 26 | ID 26 | Non-academic | Adjunct | Adjunct Senior Lecturer
Spreadsheet: 726977d1617631882-help-with-non-array-formula-alternative-for-index-match-sample
Sheet: Employer Docket

Account | ID | customer
1980001295 | 910357395 | 600360114 | [NAME] | S | DUCK
1980001296 | 910357396 | 600360115 | SPIDER |  | MAN | III
1980001297 | 910357397 | 600360116 | PETER | J | PARKER
1980001298 | 910357398 | 600360117 | IRON | D | MAN
Spreadsheet: 0a379928-a7f3-47bb-908f-f8e3939b92db
Sheet: Fox Sports (Australia)

Fox Sports (Australia)
Date | Start (Local) | End (Local) | Notes
2010-11-22 00:00:00 | 01:00:00 | 03:30:00 | Round [NAME] (Singles)
2010-11-22 00:00:00 | 07:00:00 | 09:30:00 | Round [NAME] (Singles)
2010-11-23 00:00:00 | 01:00:00 | 03:30:00 | Round [NAME] (Singles)
2010-11-23 00:00:00 | 07:00:00 | 09:30:00 | Round [NAME] (Singles)
2010-11-24 00:00:00 | 01:00:00 | 03:30:00 | Round [NAME] (Singles)
2010-11-24 00:00:00 | 07:00:00 | 09:30:00 | Round [NAME] (Singles)
2010-11-25 00:00:00 | 01:00:00 | 03:30:00 | Round [NAME] (Singles)
2010-11-25 00:00:00 | 07:00:00 | 09:30:00 | Round [NAME] (Singles)
2010-11-26 00:00:00 | 01:00:00 | 03:30:00 | Round [NAME] (Singles)
2010-11-26 00:00:00 | 07:00:00 | 09:30:00 | Round [NAME] (Singles)
2010-11-27 00:00:00 | 01:00:00 | 03:30:00 | Round [NAME] (Singles)
2010-11-27 00:00:00 | 07:00:00 | 09:30:00 | Round [NAME] (Singles)
2010-11-28 00:00:00 | 01:00:00 | 03:30:00 | Semi-Final 1 - Live (Singles)
2010-11-28 00:00:00 | 07:00:00 | 09:30:00 | Semi-Final 2 - Live (Singles)
2010-11-28 00:00:00 | 16:00:00 | 19:00:00 | Semi-Finals - Repeat (Singles)
2010-11-29 00:00:00 | 04:30:00 | 07:30:00 | Singles Final - Live
2010-11-29 00:00:00 | 12:00:00 | 14:30:00 | Singles Final - Repeat
2010-11-29 00:00:00 | 22:00:00 | 00:30 (30/11) | Singles Final - Repeat
Spreadsheet: 156286-vlookup-with-2-criteria-if-experiment-3-
Sheet: Sheet1

 |  |  |  |  | Customer Name | Particular | Type of Item |  |  |  |  |  |  |  |  | Clothings | Stationeries
 |  |  |  |  | [NAME] | Dress |  |  |  |  |  |  |  |  |  | Dress | Pencil
 |  |  |  |  | Nike | Eraser |  |  |  |  |  |  |  |  |  | Tee | Eraser
 |  |  |  |  | [NAME] | Dress |  |  |  |  |  |  |  |  |  | Shoes | Acrylic
 |  |  |  |  | [NAME] | Pencil
 |  |  |  |  | [NAME] | Dress
 |  |  |  |  | Hulk | Eraser
 |  |  |  |  | [NAME] | Tee
 |  |  |  |  | Greta | Acrylic
 |  |  |  |  | Sven | Dress
 |  |  |  |  | Using IF function labelled the type of item wrongly
Spreadsheet: 779198d1651618087-formula-to-sum-number-based-on-multiple-dynamic-drop-down-criteria-sample-11
Sheet: LY Actuals

 |  |  |  | January 2021 | February 2021 | March 2021 | April 2021 | May 2021 | June 2021 | July 2021 | August 2021 | September 2021 | October 2021 | November 2021 | December 2021
Level 5 | SUBREG | Leasing Director | EntityId - Name | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual
Revenue | East | [NAME] | 112-Building A | 126006.598386 | 133058.743821 | 133285.662861 | 135629.403354 | 133345.452531 | 133406.908152 | 126832.851798 | 133643.458623 | 133643.458623 | 133643.458623 | 133872.412746 | 140548.699236
Expenses | East | [NAME] | 112-Building A | 49163.50597200001 | 962.569974 | -10362.156936 | 28520.600277 | -93.045549 | -10453.944522 | 17087.761404 |  | -4702.469687999999 | 1444.81179 | -685.949253 | -4049.499464999999
Revenue | East | [NAME] | 114-Building C | 8873.083305000002 | 33229.67062800001 | 26490.889119 | 20930.357526 | 26111.91198 | 24693.64855200001 | 23446.040676 | 23426.78752800001 | 18897.586458 | 20284.67766 | 24811.40166 | 23294.259426
Expenses | East | [NAME] | 114-Building C | 14674.235535 | 14674.235535 | 14680.505922 | 11056.873074 | 15029.928216 | 14993.568714 | 14898.50751 | 14901.339141 | 14897.53611 | 14896.054725 | 15058.803081 | 19641.887709
Revenue | West | [NAME] | 116-Building E | 1474.5852 | 1009.2846 | 668.935182 | 1137.80082 | 607.125 | 607.125 | 1171.31412 | 607.125 | 607.125 | 1171.31412 | 607.125 | 607.125
Expenses | West | [NAME] | 116-Building E |  | -16.9995
Revenue | West | [NAME] | 118-Building G | -1684.227891 | -1684.252176 | -1869.129024 | -1776.6906 | -1776.6906 | -1776.6906 | -1776.6906 | -1776.6906 | -1776.6906 | -1776.6906 | -1776.6906 | -1776.6906
Expenses | West | [NAME] | 118-Building G | -2631.969444000001 | -22109.773122 | -19500.17502 | -14166.130194 | -17069.125095 | -23747.57295 | -18532.218633 | -22473.46528199999 | -10236.705483 | -14508.602121 | -7226.370882 | -19920.562941
Revenue | East | [NAME] | 113-Building B |  |  | -36363.975297 |  | -2919.872976 |  |  |  |  |  |  | -5333.102568
Expenses | East | [NAME] | 113-Building B |  |  | -36363.975297 |  | -2919.872976 |  |  |  |  |  |  | -5333.102568
Revenue | East | [NAME] | 115-Building D |  |  | -36363.975297 |  | -2919.872976 |  |  |  |  |  |  | -5333.102568
Expenses | East | [NAME] | 115-Building D |  |  | -36363.975297 |  | -2919.872976 |  |  |  |  |  |  | -5333.102568
Revenue | West | [NAME] | 117-Building F |  |  | -36363.975297 |  | -2919.872976 |  |  |  |  |  |  | -5333.102568
Expenses | West | [NAME] | 117-Building F |  |  | -36363.975297 |  | -2919.872976 |  |  |  |  |  |  | -5333.102568
Revenue | West | [NAME] | 119-Building H |  |  | -36363.975297 |  | -2919.872976 |  |  |  |  |  |  | -5333.102568
Expenses | West | [NAME] | 119-Building H | -2302.426851 | 820.701861 | -1536.876225 | -1640.456607 | 820.701861 | -2129.158233 | 820.701861 | -3113.880983999999 | 5192.001861000001 | -6361.50432 | 820.7018610000001 | 906.2482019999999
Spreadsheet: 083e7a6d-619a-4c7d-a75b-e1824c48ab13
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 27. LEASE FINANCE COMMITMENTS, Summary:Australia ($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
Total lease finance commitments ; |  |  | Original | A2414208C | 1975-10-01 00:00:00 | 2009-12-01 00:00:00 | 411 | $'000 | FLOW | Month | 1
Total lease finance commitments ; |  |  | Seasonally Adjusted | A2414207A | 1975-10-01 00:00:00 | 2009-12-01 00:00:00 | 411 | $'000 | FLOW | Month | 1
Total lease finance commitments ; |  |  | Trend | A2414206X | 1975-10-01 00:00:00 | 2009-12-01 00:00:00 | 411 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: john_hodge__16243__Tricia Roome
Sheet: Sheet1

curves as of:
2001-01-31 00:00:00
 |  | [NAME] |  |  | [NAME]
 |  | Basis | Index | EFP | Basis | Index | EFP |  |  | [NAME] | [NAME]
 | 2001-11-01 00:00:00 | 0.05 | 0.0125 |  | 1.35 | -0.22 |  |  | Winter 01
 |  | 0.05 | 0.01 |  | 1.55 | -0.38 |  |  | Winter 02
 |  | 0.05 | 0.01 |  | 1.75 | -0.35 |  |  | Winter 03
 |  | 0.05 | 0.01 |  | 1.75 | -0.38 |  |  | Winter 04
 |  | 0.05 | 0.01 |  | 1.6 | -0.32 |  |  | Winter 05
 |  | 0.0325 | 0.01 |  | 0.5 | -0.085
 |  | 0.0325 | 0.01 |  | 0.44 | -0.065
 |  | 0.0325 | 0.01 |  | 0.44 | -0.055 |  |  |  | [NAME] | [NAME]
 |  | 0.0325 | 0.01 |  | 0.5 | -0.02 |  |  | Summer 01
 |  | 0.0325 | 0.01 |  | 0.5 | -0.02 |  |  | Summer 02
 |  | 0.0325 | 0.01 |  | 0.46 | -0.04 |  |  | Summer 03
 |  | 0.0325 | 0.01 |  | 0.47 | -0.085 |  |  | Summer 04
 |  | 0.052 | 0.0125 |  | 0.505 | -0.17 |  |  | Summer 05
 |  | 0.052 | 0.01 |  | 1.26 | -0.13
 |  | 0.052 | 0.01 |  | 1.58 | -0.25
 |  | 0.052 | 0.01 |  | 1.54 | -0.28
 |  | 0.052 | 0.01 |  | 0.92 | -0.17
 |  | 0.0345 | 0.01 |  | 0.5 | -0.085
 |  | 0.0345 | 0.01 |  | 0.44 | -0.065
 |  | 0.0345 | 0.01 |  | 0.44 | -0.055
 |  | 0.0345 | 0.01 |  | 0.5 | -0.02
 |  | 0.0345 | 0.01 |  | 0.5 | -0.02
 |  | 0.0345 | 0.01 |  | 0.46 | -0.04
 |  | 0.0345 | 0.01 |  | 0.47 | -0.085
 |  | 0.054 | 0.0125 |  | 0.85 | -0.17
 |  | 0.054 | 0.01 |  | 1.26 | -0.13
 |  | 0.054 | 0.01 |  | 1.58 | -0.25
 |  | 0.054 | 0.01 |  | 1.54 | -0.28
 |  | 0.054 | 0.01 |  | 0.92 | -0.17
 |  | 0.0365 | 0.01 |  | 0.5 | -0.085
 |  | 0.0365 | 0.01 |  | 0.44 | -0.065
 |  | 0.0365 | 0.01 |  | 0.44 | -0.055
 |  | 0.0365 | 0.01 |  | 0.5 | -0.02
 |  | 0.0365 | 0.01 |  | 0.5 | -0.02
 |  | 0.0365 | 0.01 |  | 0.46 | -0.04
 |  | 0.0365 | 0.01 |  | 0.47 | -0.085
 |  | 0.056 | 0.0125 |  | 0.855 | -0.17
 |  | 0.056 | 0.01 |  | 1.27 | -0.13
 |  | 0.056 | 0.01 |  | 1.595 | -0.25
 |  | 0.056 | 0.01 |  | 1.555 | -0.28
 |  | 0.056 | 0.01 |  | 0.925 | -0.17
 |  | 0.0385 | 0.01 |  | 0.5 | -0.085
 |  | 0.0385 | 0.01 |  | 0.44 | -0.065
 |  | 0.0385 | 0.01 |  | 0.44 | -0.055
 |  | 0.0385 | 0.01 |  | 0.5 | -0.02
 |  | 0.0385 | 0.01 |  | 0.5 | -0.02
 |  | 0.0385 | 0.01 |  | 0.46 | -0.04
 |  | 0.0385 | 0.01 |  | 0.47 | -0.085
 |  | 0.058 | 0.0125 |  | 0.86 | -0.17
 |  | 0.058 | 0.01 |  | 1.28 | -0.13
 |  | 0.058 | 0.01 |  | 1.61 | -0.25
 |  | 0.058 | 0.01 |  | 1.57 | -0.28
 |  | 0.058 | 0.01 |  | 0.93 | -0.17
 |  | 0.0405 | 0.01 |  | 0.5 | -0.085
 |  | 0.0405 | 0.01 |  | 0.44 | -0.065
 |  | 0.0405 | 0.01 |  | 0.44 | -0.055
 |  | 0.0405 | 0.01 |  | 0.5 | -0.02
 |  | 0.0405 | 0.01 |  | 0.5 | -0.02
 |  | 0.0405 | 0.01 |  | 0.46 | -0.04
 |  | 0.0405 | 0.01 |  | 0.47 | -0.085
Spreadsheet: 54480d1254469930-3-way-table-lookup-example-workbook
Sheet: Sheet1

EXISTING DATA
Span (m) | Vehicle Type | Speed
3 |  | 20 | 30 | 40 | 50 | 60
 | A1 | 15 | 19.2 | 21.5 | 23.5 | 27.6
 | A2 | 27.5 | 28.9 | 32.2 | 34.5 | 36.7
 | A3 | 19.3 | 20.5 | 28 | 29 | 31
 | B1 | 22.9 | 24.5 | 25.8 | 27.2 | 28.6
 | B2 | 25.3 | 26.9 | 28.5 | 30.1 | 31.7
 | B3 | 30.1 | 32.1 | 32.9 | 33.2 | 35.6
 | C1 | 5.6 | 8.2 | 9 | 9.9 | 11
 | C2 | 7.5 | 8.1 | 9.5 | 10.5 | 13
 | Vehicle Type | Speed
4 |  | 20 | 30 | 40 | 50 | 60
 | A1 | 17 | 21.5 | 22.9 | 25.2 | 29.3
 | A2 | 26.5 | 29.5 | 30 | 44 | 38
 | A3 | 18 | 20.5 | 22.5 | 23 | 26
 | B1 | 24 | 26 | 26 | 28 | 29
 | B2 | 27 | 29 | 30.2 | 32 | 35
 | B3 | 19.5 | 32.5 | 38.5 | 40 | 44
 | C1 | 5.9 | 8.1 | 11.1 | 13.5 | 15.6
 | C2 | 4 | 8 | 9.3 | 11.7 | 15.4
etc. (there is data for twenty more spans)
DESIRED OUTPUT FORMAT
 |  | Span | Speed | Vehicle |  | Frequency |  | Equivalent Vehicle A (@ same speed & span)
 |  | 3 | 40 | B2
 |  | need formula so that correct frequency appears in this box (ie 28.5)
 |  |  |  |  |  | need formula so that the equivalent type 'A' vehicle label appears in this box
 |  |  |  |  |  | (ie. the closest type 'A' frequency at a speed of 40 is 28.0 so "A3" should appear in this box)
 | 3
 | 4
 | 5