tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 707207d1607097085-how-to-return-results-of-a-top-5-lowest-price-top-5-highest-price-and-price-difference-clean-data
Sheet: SPAIN

Country | SPAIN
End user price in EUR after VAT | (Multiple Items)
Average of End user price in EUR after VAT | Column Labels
Row Labels | MedEL | OM
[NAME] |  | 85
Antenna cable |  | 63.75
Drying kit | 74.68 | 69.2
Full swim kit | 69.48
Country | SPAIN
End user price in EUR after VAT | (Multiple Items)
Average of End user price in EUR after VAT | Column Labels
Row Labels | MedEL | OM
[NAME] | 603.14
Charger |  | 538
Recheargable battery | 392.73
Streamer (outside sound processor) | 657.09
Country | SPAIN
End user price in EUR after VAT | (Multiple Items)
Average of End user price in EUR after VAT | Column Labels
Row Labels | AB | Cochlear | MedEL | OM
Antenna cable | -71.58 |  | 15.94999999999999 | -59.25
Full swim kit | 0 |  | 69.48 | 363
Spreadsheet: 0e7ce6ab-e5d2-4b10-8ef1-6b3562ae904a
Sheet: Lexi-Comp

[NAME]
2009-2010
COUNTER-Compliant?: | No
 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | Total | 2009-2010 Price | Price per unit
Lexi-Comp Online
Logins | 119 | 291 | 427 | 574 | 463 | 426 | 476 | 1107 | 950 | 626 | 524 | 707 |  | 0 | N/A
Searches | 492 | 630 | 802 | 1458 | 946 | 691 | 775 | 2043 | 2030 | 1552 | 1219 | 1759 |  | 0 | N/A
Documents Retrieved | 614 | 758 | 1131 | 2193 | 1491 | 954 | 1145 | 2319 | 2425 | 1658 | 1684 | 2319 |  | 0 | N/A
Spreadsheet: 81180d1281443935-copy-text-from-one-sheet-to-another-using-macro-request-form-template2
Sheet: November

 |  |  |  | Date | 2010-08-10 12:26:51 |  | November Total Hours
 |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | Percentage
 | Year | Month | Date | Hours | Total Hours |  |  | Total Hours |  |  | 240 | 100
 | 2010 | November | 2010-11-01 00:00:00 | 0 | 0 |  |  | Total Hours Requested |  |  | 0 | 0
 |  |  | 2010-11-02 00:00:00 | 0 |  |  |  | Hours Not Requested |  |  | 240 | 100
 |  |  | 2010-11-03 00:00:00 | 0 |  |  |  |  |  |  |  |  |  | Key
 |  |  | 2010-11-04 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  | Hours Requested
 |  |  | 2010-11-05 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  | Left Over Hours
 |  |  | 2010-11-06 00:00:00 | 0
 |  |  | 2010-11-07 00:00:00 | 0
 |  |  | 2010-11-08 00:00:00 | 0
 |  |  | 2010-11-09 00:00:00 | 0
 |  |  | 2010-11-10 00:00:00 | 0
 |  |  | 2010-11-11 00:00:00 | 0
 |  |  | 2010-11-12 00:00:00 | 0
 |  |  | 2010-11-13 00:00:00 | 0
 |  |  | 2010-11-14 00:00:00 | 0
 |  |  | 2010-11-15 00:00:00 | 0
 |  |  | 2010-11-16 00:00:00 | 0
 |  |  | 2010-11-17 00:00:00 | 0
 |  |  | 2010-11-18 00:00:00 | 0
 |  |  | 2010-11-19 00:00:00 | 0
 |  |  | 2010-11-20 00:00:00 | 0
 |  |  | 2010-11-21 00:00:00 | 0
 |  |  | 2010-11-22 00:00:00 | 0
 |  |  | 2010-11-23 00:00:00 | 0
 |  |  | 2010-11-24 00:00:00 | 0
 |  |  | 2010-11-25 00:00:00 | 0
 |  |  | 2010-11-26 00:00:00 | 0
 |  |  | 2010-11-27 00:00:00 | 0
 |  |  | 2010-11-28 00:00:00 | 0
 |  |  | 2010-11-29 00:00:00 | 0
 |  |  | 2010-11-30 00:00:00 | 0
Spreadsheet: 773465d1647874097-only-show-value-once-if-value-appears-more-than-once-in-list-example
Sheet: Sheet1

Example |  |  |  |  |  |  |  |  | How I want it to look
Ref | Only show value once |  |  |  |  |  |  |  | Ref | Only show value once
APP-1009 |  |  |  |  |  |  |  |  | APP-1009 | APP-1009
APP-1009 |  |  |  |  |  |  |  |  | APP-1009
APP-1003 |  |  |  |  |  |  |  |  | APP-1003 | APP-1003
APP-1002 |  |  |  |  |  |  |  |  | APP-1002 | APP-1002
APP-1016 |  |  |  |  |  |  |  |  | APP-1016 | APP-1016
APP-1004 |  |  |  |  |  |  |  |  | APP-1004 | APP-1004
APP-1004 |  |  |  |  |  |  |  |  | APP-1004
APP-1007 |  |  |  |  |  |  |  |  | APP-1007 | APP-1007
APP-1006 |  |  |  |  |  |  |  |  | APP-1006 | APP-1006
APP-1001 |  |  |  |  |  |  |  |  | APP-1001 | APP-1001
APP-1001 |  |  |  |  |  |  |  |  | APP-1001
APP-1008 |  |  |  |  |  |  |  |  | APP-1008 | APP-1008
APP-1008 |  |  |  |  |  |  |  |  | APP-1008
APP-1015 |  |  |  |  |  |  |  |  | APP-1015 | APP-1015
[NAME] |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  |  |  |  |  | [NAME]
APP-1000 |  |  |  |  |  |  |  |  | APP-1000 | APP-1000
APP-1000 |  |  |  |  |  |  |  |  | APP-1000
APP-1000 |  |  |  |  |  |  |  |  | APP-1000
APP-1000 |  |  |  |  |  |  |  |  | APP-1000
APP-1120
APP-1126 |  |  |  |  |  |  |  |  | And so on…
APP-1244
APP-1247
[NAME]
APP-1038
APP-1162
APP-1183
APP-1044
APP-1052
APP-1062
APP-1064
APP-1070
APP-1057
APP-1061
APP-1067
APP-1069
APP-1071
APP-1068
APP-1050
APP-1054
APP-1082
APP-1136
APP-1142
APP-1144
APP-1135
APP-1141
APP-1399
APP-1371
APP-1148
APP-1036
APP-1380
APP-1370
APP-1370
APP-1370
APP-1397
APP-1577
APP-1828
APP-1400
APP-1114
APP-1114
APP-1114
[NAME]
APP-1232
APP-1398
APP-1140
APP-1165
Spreadsheet: 141120d1329115378-rank-4-columns-of-data-with-formula-row-of-low-number
Sheet: Ordering

Low Rows |  |  |  |  |  |  | Low Row Numbers
 |  |  |  | 1 |  |  |  |  |  |  | <<Your Answer is here.
 |  |  |  | 1
[1] | [2] | [3] | [4] |  |  |  | [1] | [2] | [3] | [4]
Spreadsheet: 57287d1257398314-help-on-formula-multiple-worksheets-706059-help-on-formula-multiple-worksheets
Sheet: 0832 Waterproofing & Tanking

Project: |  |  |  |  |  |  |  |  |  | Claim No.: | 1
Building: |  |  |  |  |  |  |  |  |  | Proj No.:
Trade No / Trade Name | TP 0832 | Waterproofing & Tanking |  |  |  |  |  |  |  | Date Issued: | 2009-10-30 00:00:00
[NAME]
TP No:- | Subcontract / Supply No | Description |  | Subcontractor / Supplier | Original Contract Sum | Adjustment | Adjusted Contract Sum | Approved Commitment | Completed to date | Previous Approved Value | Value this Claim
 |  |  |  |  | 4500 | 0 | 4500 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  | Contract Works Sub-Total | 4500 | 0 | 4500 | 0 | 0 | 0 | 0
Variation / Claims
SCVO | Status | Description | Notification / Instruction # | Subcontractor / Supplier | Budget | Adjustment | Adjusted Budget | Approved Commitment | Completed to date | Previous Approved Value | Value this Claim
 |  |  |  |  | 0 | 0 | 0 |  |  |  | 0
 |  |  |  |  | 0 | 0 | 0 |  |  |  | 0
 |  |  |  |  | 0 | 0 | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | Contract Works Sub-Total | 0 | 0 | 0 | 0 | 0 | 0 | 0
TP 0832 | Waterproofing & Tanking |  |  | NET TOTAL | 4500 | 0 | 4500 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | Status
 |  |  |  |  |  |  | A | Approved
 |  |  |  |  |  |  | P | Submitted / Pending Approval
 |  |  |  |  |  |  | D | Disputed
 |  |  |  |  |  |  | R | Rejected
Spreadsheet: 0b405207-99c7-4a3a-bc47-07e0b78c73c5
Sheet: 13b

Product1 | HY3 | IG | Other | TOTAL
Index Tranche
Europe | . | . | 543338
North America/Asia | 64972 | 531843 | 5971
Other | . | . | 0
Index
Asia | . | . | 121380
Europe | . | . | 3970240
North America | 571492 | 2306979 | 108005
Other | . | . | 272017
OTHER* | 0 | 0 | 556124
TOTAL
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 90189d1289945453-excel-2007-vlookup-in-multiple-sheets-vlookupproblem
Sheet: B

PRODUCTS | QTY | NUMER | PRICE | SELECTED QTY | FINAL NUMER
B1 | 1 | 30.25
B2 | 1 | 26.25
B3 | 2 | 17
B4 | 1 | 11
B5 | 2 | 1
B6 | 2 | 7
B7 | 1 | 10
B8 | 1 | 12
B9 | 2 | 35.25
B10 | 3 | 16
Spreadsheet: 137691d1327326930-total-of-each-operation-test-total-of-item
Sheet: Sheet1

Operation | Time
Threading | 6
Threading | 6
Attach | 6
Threading | 6
Attach | 6
Threading | 6
Threading | 6
Attach | 6
Attach | 6
Threading | 6
Attach | 6
Attach | 6
Attach | 6
Slope | 6
Attach | 6
Attach | 6
Slope | 6
Slope | 6
Slope | 6
Total Threading
Total Attach
Total Slope
Spreadsheet: 706242d1606559928-powerquery-data-extraction-from-website-question-pq-parameter-industry-screener
Sheet: Sheet1

Industry |  |  | No. | Ticker | Market [NAME] | P/E | Fwd P/E | PEG | P/S | P/B | P/C | P/FCF | EPS this Y | EPS next Y | EPS past 5Y | EPS next 5Y | Sales past 5Y | Price | Change | Volume
gambling |  |  | 1 | ACEL | 1.03B | - | 18.26 | - | 1.93 | 13.16 | 6.19 | - | -1.777 | 1.3 |  | 21.68% | - | 10.92 | 0.0046 | 213072
 |  |  | 2 | AGS | 183.20M | - |  | - | 0.92 | 2.79 | 1.62 | 8.60 | 0.436 | 0.509 | 0.17 | - | 33.40% | 5 | -0.0119 | 185362
 |  |  | 3 | CHDN | 7.33B | 800.87 | 35.92 | 66.74 | 6.94 | 19.64 | 11.79 | 64.03 | -0.168 | 3.187 | 0.331 | 12.00% | 10.40% | 185 | -0.0012 | 85070
 |  |  | 4 | CPHC | 58.83M | 38.79 |  | - | 1.49 | 1.13 | - | - | -0.517 |  | 0.005 | - | 4.10% | 12.18 | 0.0851 | 1884
 |  |  | 5 | ELYS | 33.46M | - |  | - | 0.92 | 2.86 | 5.77 | 23.90 | -1.371 |  | -0.16 | - | 82.80% | 2.09 | -0.0711 | 1361336
 |  |  | 6 | EVRI | 943.96M | - | 43.22 | - | 2.31 |  | 3.94 | - | 0.367 | 1.271 | 0.028 | 20.00% | -2.10% | 11.15 | 0.0276 | 1359290
 |  |  | 7 | GAN | 475.37M | - | 785.71 | - | 12.87 | 7.82 | 8.27 | - | 1.195 | 1.062 | 0.295 | - | 31.80% | 16.5 | 0.0173 | 438371
 |  |  | 8 | GMBL | 57.60M | - |  | - | 259.02 | 3.33 | 6.47 | - | -0.365 | 0.808 |  | - | - | 4.59 | 0.1278 | 745386
 |  |  | 9 | IGT | 2.67B | - | 12.65 | - | 0.70 | 1.51 | 1.98 | 4.77 | 0.41 | 16 | -0.17 | 30.18% | 4.70% | 13.23 | 0.0288 | 3134927
 |  |  | 10 | SGMS | 3.81B | - | 336.58 | - | 1.35 |  | 3.64 | 16.20 | 0.639 | 1.022 | 0.128 | - | 13.70% | 39.38 | 0.0142 | 439280
 |  |  | 11 | WBAI | 124.66M | - |  | - | 32.80 | 1.23 | 2.37 | - | -0.341 |  | -0.4 | 15.75% | -41.50% | 2.75 | -0.0214 | 17985
Spreadsheet: 6f79ffe3-6795-4d20-8923-e79cfd8b69ab
Sheet: Sheet1

Unnamed: 0 | Residue | β (%) | ppII (%) | α (%) | Frust. Α (%) | Other (%) | Entropy
Before mutation | E235 | 12 | 7 | 69 | 11 | 1 | 0.985
 | H236 | 47 | 17 | 11 | 12 | 13 | 1.419
 | V237 | 28 | 6 | 45 | 12 | 9 | 1.356
 | T238 | 34 | 16 | 38 | 4 | 8 | 1.359
 | E239 | 28 | 18 | 24 | 2 | 28 | 1.442
 | V240 | 16 | 46 | 14 | 16 | 8 | 1.421
 | V241 | 36 | 29 | 25 | 0 | 10 | 1.304
 | K242 | 68 | 27 | 0 | 0 | 5 | 0.766
 | R243 | 22 | 34 | 15 | 4 | 25 | 1.46
After mutation | E235 | 6 | 4 | 89 | 0 | 1 | 0.447
 | H236 | 9 | 1 | 88 | 1 | 1 | 0.467
 | V237 | 7 | 3 | 89 | 1 | 0 | 0.441
 | T238 | 9 | 5 | 81 | 1 | 4 | 0.712
 | E239 | 10 | 4 | 76 | 4 | 6 | 0.865
 | V240 | 4 | 21 | 69 | 0 | 6 | 0.881
 | V241 | 21 | 13 | 51 | 0 | 15 | 1.221
 | K242 | 36 | 3 | 30 | 10 | 21 | 1.392
 | W243 | 49 | 15 | 30 | 0 | 6 | 1.164
Difference | E235 | -6 | -3 | 20 | -11 | 0 | -0.538
 | H236 | -38 | -16 | 77 | -11 | -12 | -0.951
 | V237 | -21 | -3 | 44 | -11 | -9 | -0.915
 | T238 | -25 | -11 | 43 | -3 | -4 | -0.647
 | E239 | -18 | -14 | 52 | 2 | -22 | -0.577
 | V240 | -12 | -25 | 55 | -16 | -2 | -0.54
 | V241 | -15 | -16 | 26 | 0 | 5 | -0.083
 | K242 | -32 | -24 | 30 | 10 | 16 | 0.627
 | R243W | 27 | -19 | 15 | -4 | -19 | -0.296
Spreadsheet: 181438d1348044846-adding-a-number-value-to-a-symbol-so-that-it-can-be-inputed-in-an-equation-sessions-register
Sheet: Room 2 Name

 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Payment
Name | AM | PM | AM2 | PM2 | AM3 | PM3 | AM4 | PM4 | AM5 | PM5 | Method 1 | Method 2 | Voucher Amount | Voucher Company | Comments
Spreadsheet: 847033d1698140735-linking-independent-and-dependent-drop-down-costs-to-master-budgets-to-upload
Sheet: Action Plan Specs

Marketing Ideas | 1000
Alumni Story | 40000
Retention | 3000
Working in the community | 7500
Better understand and support minority groups | 1000
Working with Strategic Partnerships | 1000
Working with Health and Wellbeing and Student Disability | 1000
Workshop series | 1000
Opportunity for new courses | 1000
Opportunity to publish resources | 1000
Cost effectiveness of curriculum | 3
Opportunity to collaborate within school and with other schools | 1000
Culture of collaborative teaching – supporting new staff | 1000
International Recruitment | 2222
Following Up With Applicants | 1000
Developing More Collaborative Opportunities for Students | 1000
Developing Our Profiles | 6000
Opportunities for Staff/Student Collaboration | 1000
L/Futures Scheme | 1000
Auditions at schools/hubs | 1000
Creating more public opportunities for students | 1000
Work with L | 1000
Link with L | 2
Marketing Ideas | 1000
Alumni Story | 1000
Retention | 1000
Working in the community | 1000
Better understand and support minority groups | 1000
Spreadsheet: 35448d1233055142-copying-hyperlinks-december-2008-excel-forum-daily-accts
Sheet: 2

 |  |  |  |  |  | 2 | 1
Money on bank accts
beginning of | 2 | december 2008
[NAME] компании | Без Нал. | Нал. | Сумма
[NAME] | 985.4199999999983 | 0 | 985.4199999999983 |  |  | B17 | B134 | B16 |  | C17 | C134 | C16
Вагриус книги | 1238.7 | 0 | 1238.7 |  |  | B18 | B150 | B32 |  | C18 | C150 | C32
Вагриус правда | 67683.88 | 0 | 67683.88 |  |  | B19 | B166 | B48 |  | C19 | C166 | C48
Вагриус минус | 628.08 | 0 | 628.08 |  |  | [NAME] | B182 | B64 |  | C20 | C182 | C64
Плюс-минус | 2982.36 | 0 | 2982.36 |  |  | B21 | B198 | B80 |  | C21 | C198 | C80
Издательство Вагриус | 444.69 | 0 | 444.69 |  |  | B22 | B114 | [NAME] |  | C22 | C114 | C96
Вагриус плюс-минус | 0 | 0 | 0 |  |  | B23 | B230 | B112 |  | C23 | C230 | C112
Общий итог: | 73963.13 | 0 | 73963.13
Spreadsheet: 46803d1245748592-populate-data-in-sheet-lookupsheet
Sheet: Form

FORM
DEPARTMENT | ADMIN
NAME | [NAME]
EMP-NO | 2
GRADE | 1
DESIGNATION | SUPERVISOR
SR. NO. | Activity | Description | MARKS
POINT
 |  | A | 2 |  | G
 |  | B | 2.5 |  | H
 |  | C | 2 |  | I
 |  | D | 2.5 |  | J
 |  | E | 2.25 |  | K
 |  | F | 2 |  | L
 |  | G | 2.5 |  | M
 | General Average Point |  | 2.25 |  | N
 |  | SYED MUHAMMAD WASIM | 0515
 |  | TAHIR FAROOQ | 0517
 |  | [NAME] | 5138
 |  | MUHAMMAD AKMAL | 0528
 |  | KHALID MAHMOOD | 0529
 |  | RAJA RIZWAN AHMAD [NAME] | 0533
 |  | [NAME] | 0693
 |  | ATIR RASHID | 0532
 |  | MAHFOOZ ALI | 0565
 |  | NASIR RIAZ | 0657
 |  | [NAME] | 0684
 |  | ADIL NASEER KHAWAJA | 0733
 |  | ABRAR SHARIF | 0749
 |  | ABDUS SALAM | 838
 |  | NAJMA MUSTAFA | 890
 |  | MOHAMAD NAEEM YOUNIS | 0728
 |  | [NAME] | 0730
 |  | SAIMA IMRAN | 0741
 |  | HANAN AZEEM | 0789
 |  | KASHIF HAMEED MIRZA | 0790
 |  | YASIR IQBAL GHUMMAN | 0791
 |  | IMRAN  RASHEED | 0802
 |  | HAROON RASHEED | 700
 |  | MUHAMMAD UMAR MALIK | 724
 |  | KHURRAM NAZIR | 814
 |  | SAEED AHMAD | 963
 |  | MUHAMMAD ADEEL | 964
 |  | SH. MUHAMMAD IMRAN | 804
 |  | ARIF NAEEM KHAN | 907
 |  | HASSAN ASIF | 908
 |  | MIAN FAHAD ASHRAF | 913
 |  | MUHAMMAD ABBAS | 919
Spreadsheet: 748010d1631826143-using-transpose-function-with-indirect-and-row-function-excel-transpose-formula-example
Sheet: Parts Sold Table

 |  | Number of Parts Sold
Categories | Description | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12
Hex | Hex 1/2" x 1/2" [NAME]
Hex | Hex 3/4" x 1/2" [NAME]
Spreadsheet: 329636d1404373639-date-in-text-format-average-to-be-plotted-0a1_a1
Sheet: average

22-02-14 | 10 |  | 2014-02-01 00:00:00 | 40 |  | Average in Yellow cells to be plotted by formula
23-02-14 |  |  | 2014-03-01 00:00:00 | 100
24-02-14 |  |  | 2014-04-01 00:00:00 | 145
25-02-14
26-02-14 |  |  | Date is in Text Format, Average to be plotted
27-02-14
27-02-14
01-03-14
02-03-14
07-03-14
08-03-14
09-03-14
01-04-14
03-04-14
25-04-14
27-04-14
Spreadsheet: 0ac01079-404f-4960-b16e-e9c511cefa2f
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
 | 6345.0 Labour Price Index, Australia
 | Ordinary Hourly Rates of Pay Excluding Bonuses: All Sectors by State, Original (Quarterly Index Numbers)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Quarterly Index ;  Ordinary time hourly rates of pay excluding bonuses ;  New South Wales ;  Private and Public ;  All industries ; |  |  | Original | A2635529C | 1997-09-01 00:00:00 | 2010-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Victoria ;  Private and Public ;  All industries ; |  |  | Original | A2644839C | 1997-09-01 00:00:00 | 2010-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Queensland ;  Private and Public ;  All industries ; |  |  | Original | A2636859L | 1997-09-01 00:00:00 | 2010-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Ordinary time hourly rates of pay excluding bonuses ;  South Australia ;  Private and Public ;  All industries ; |  |  | Original | A2646169R | 1997-09-01 00:00:00 | 2010-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Western Australia ;  Private and Public ;  All industries ; |  |  | Original | A2643509V | 1997-09-01 00:00:00 | 2010-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Tasmania ;  Private and Public ;  All industries ; |  |  | Original | A2638189X | 1997-09-01 00:00:00 | 2010-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Northern Territory ;  Private and Public ;  All industries ; |  |  | Original | A2642179W | 1997-09-01 00:00:00 | 2010-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Australian Capital Territory ;  Private and Public ;  All industries ; |  |  | Original | A2640849K | 1997-09-01 00:00:00 | 2010-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Australia ;  Private and Public ;  All industries ; |  |  | Original | A2639519W | 1997-09-01 00:00:00 | 2010-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2010
Spreadsheet: 63568d1264457453-payroll-taxes-example-payroll-01-10
Sheet: Pension11.3

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1017
 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
Pay# | Name | Eligible? | Elig Date | 2010-01-09 00:00:00 | 2010-02-09 00:00:00 | 2010-03-09 00:00:00 | 2010-04-09 00:00:00 | 2010-05-09 00:00:00 | 2010-06-09 00:00:00 | 2010-07-09 00:00:00 | 2010-08-09 00:00:00 | 2010-09-09 00:00:00 | 2010-10-09 00:00:00 | 2010-11-09 00:00:00 | 2010-12-09 00:00:00 | YTD TOTAL |  | Left to [NAME]
4 | SMITH | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 1017
Spreadsheet: 291817d1390413182-printing-multiple-pages-per-sheet-81-01-finishes-schedule-new-template-a4-web
Sheet: Sheet1

 | Logo |  |  |  | Project: |  |  | Drawing No.: |  | [NAME] by: | Checked by: | Print Date: |  | Job No.:
 |  |  |  |  |  |  |  | Drawing Title: |  | Description: |  |  |  | Rev. No.:
 | Clients logo
 |  |  |  |  |  |  |  | File Location:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TBC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TBC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TBC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TBC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TBC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TBC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TBC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TBC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TBC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TBC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TBC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TBC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TBC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TBC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TBC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TBC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TBC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TBC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TBC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TBC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TBC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TBC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TBC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TBC
Spreadsheet: 49135d1248384783-copy-row-from-multiple-worksheets-based-on-column-value-in-to-summary-tab-sales-unpaid-solver
Sheet: March

Date | Company | Details | Invoice No. | Net Amount | VAT | Total | Paper Reference | Date Invoice Sent | Date Papment Received
2009-01-01 00:00:00 | SOI | Web Site Work | 8 | 200 | 43 | 243 | J1 | 2009-05-03 00:00:00 | 2009-05-17 00:00:00
2009-01-01 00:00:00 | KPMG | Accounting Work | 9 | 50 | 10.75 | 60.75 | J2 | D | Unpaid
2009-01-01 00:00:00 | SOI | Web Site Work | 10 | 200 | 43 | 243 | J1 | 2009-05-03 00:00:00 | 2009-05-17 00:00:00
2009-01-01 00:00:00 | SOI | Accounting Work | 11 | 50 | 10.75 | 60.75 | J2 | E | Unpaid
Spreadsheet: 101360dd-bb5a-491e-a3cc-2cfebdb3d148
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 4. PERSONAL FINANCE COMMITMENTS By Purpose (Fixed Loans): 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 motor cars and station wagons ; |  |  | Original | A2413473X | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Used motor cars and station wagons ; |  |  | Original | A2413474A | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Total motor vehicles ; |  |  | Original | A2413475C | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Individual residential blocks of land ; |  |  | Original | A2413476F | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Unsecured finance for owner occupation ; |  |  | Original | A2413477J | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Debt consolidation ; |  |  | Original | A2413478K | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Refinancing ; |  |  | Original | A2413479L | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Other ; |  |  | Original | A2413480W | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | DERIVED | Month | 1
TOTAL ; |  |  | Original | A2413481X | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 772449d1647278300-assistance-with-if-statement-if-statement-example
Sheet: Sheet1

Usage | Goal | Test Round up calc .8
3.67359777199074 | 3.67
1.486096417462384 | 1.49
3.99 | 4
5.078304036458333 | 5.08
3.049219232253086 | 3.049219232253086
3.502278645833333 | 3.502278645833333
2.094320671875 | 2.094320671875
0.621685474537037 | 0.621685474537037
0.9766883680555556 | 1
0.5410806082589285 | 0.5410806082589285
2.176109784915123 | 2.176109784915123
0.8736474609375 | 1
0.5285027850115741 | 0.5285027850115741
0.4098593026620371 | 0.4098593026620371
2.802734375 | 3