tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: richard_shapiro__32174__jan01
Sheet: jan01.xls

COST CENTER | MONTHLY ACTUALS | MONTHLY BUDGET | MONTHLY [NAME] | YEAR TO DATE AVAILABLE | COMMENTS
100042 - Robertson | 61253.78 | 161756 |  | 1880926.22 | there are some coding issues to be resolved; some charges need to be moved to your cost center; a copy of the memo to move monies will be provided to you for review and approval
100062 - Shapiro | 1492086.06 | 1999928 |  | 19945494.94 | there were numerous charges to your cost center that should have been coded to individual cost centers; the actuals for computer expense exceeded the monthly budget by $68,929.27; [NAME] is reviewing the charges and will advise of her findings; a copy of the memo to move monies will be provided to you for review and approval
100072 - Ryall | 14296.03 | 31839 |  | 367798.97 | outside service charges were coded to this cost center and should have been coded to your cost center; a copy of the memo to move monies will be provided to you for review and comment
100085 - Kaufman | 50250.64 | 72000 |  | 715749.36 | outside service charges were coded to this cost center and should have been coded to your cost center; a copy of the memo to move monies will be provided to you for review and comment
100086 - Dadson | 0 | 69671.67 |  | 816758
100087 - Montovano | 65287.38 | 63333 |  | 694712.62
100088 - Migden | 27989.9 | 12915 |  | 607002.1 | these numbers do not match the cost center report; a credit applied to the cost center should have been applied to your cost center; in addition, there are some charges that should be coded to your cost center; a copy of the memo to move monies will be provided to you for review and approval
100100 - Charvel | 0 | 46878 |  | 506215
100108 - Steffes | 9220.35 | 27750 |  | 320969.65 | there are some charges that need to be moved to your cost center; a copy of the memo to move monies will be provided to you for review and approval
103885 - Kingerski | 7779.91 | 39583 |  | 467216.09 | there are some charges that need to be moved to your cost center; a copy of the memo to move monies will be provided to you for review and approval
103886 - Yoho | 56.83 | 10000 |  | 119943.17 | there are some charges that need to be moved to your cost center; a copy of the memo to move monies will be provided to you for review and approval
103887 - Nord | 6336.16 | 27500 |  | 323663.87
TOTAL
Spreadsheet: 134732d1325604443-vlookup-several-columns-then-total-a-different-column-dropships-1
Sheet: 2011 Data

 | 2011 Drop Ships
Month | Customer | Part Number | Number of Parts | Customers Cost |  | Cust A
Jan | Cust A | 17 | 13 |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Feb | Cust A | 16 | 129 |  |  | Total Number of Parts
Mar | Cust A | 19 | 68 |  |  | Total Cost
Apr | Cust A | 15 | 32
May | Cust A | 15 | 141 |  |  | Cust B
Jun | Cust A | 18 | 51 |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Jul | Cust A | 15 | 55 |  |  | Total Number of Parts
Aug | Cust A | 14 | 35 |  |  | Total Cost
Sep | Cust A | 16 | 22
Oct | Cust A | 11 | 81 |  |  | Cust C
Nov | Cust A | 15 | 77 |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Dec | Cust A | 18 | 62 |  |  | Total Number of Parts
Jan | Cust B | 14 | 84 |  |  | Total Cost
Feb | Cust B | 10 | 129
Mar | Cust B | 21 | 51 |  |  | Cust D
Apr | Cust B | 20 | 16 |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
May | Cust B | 17 | 88 |  |  | Total Number of Parts
Jun | Cust B | 13 | 125 |  |  | Total Cost
Jul | Cust B | 16 | 132
Aug | Cust B | 18 | 53
Sep | Cust B | 10 | 96
Oct | Cust B | 23 | 14
Nov | Cust B | 22 | 47
Dec | Cust B | 24 | 58
Jan | Cust C | 23 | 146
Feb | Cust C | 19 | 119
Mar | Cust C | 11 | 98
Apr | Cust C | 11 | 50
May | Cust C | 21 | 102
Jun | Cust C | 12 | 104
Jul | Cust C | 15 | 121
Aug | Cust C | 16 | 82
Sep | Cust C | 18 | 80
Oct | Cust C | 22 | 131
Nov | Cust C | 11 | 118
Dec | Cust C | 13 | 11
Jan | Cust D | 14 | 134
Feb | Cust D | 16 | 51
Mar | Cust D | 13 | 127
Apr | Cust D | 16 | 105
May | Cust D | 22 | 107
Jun | Cust D | 15 | 147
Jul | Cust D | 21 | 32
Aug | Cust D | 19 | 122
Sep | Cust D | 20 | 123
Oct | Cust D | 15 | 13
Nov | Cust D | 12 | 112
Dec | Cust D | 10 | 42
Jan | Cust A | 20 | 38
Feb | Cust A | 23 | 110
Mar | Cust A | 22 | 71
Apr | Cust A | 10 | 132
May | Cust A | 10 | 17
Jun | Cust A | 23 | 25
Jul | Cust A | 22 | 124
Aug | Cust A | 18 | 119
Sep | Cust A | 21 | 106
Oct | Cust A | 24 | 82
Nov | Cust A | 21 | 28
Dec | Cust A | 17 | 145
Jan | Cust B | 21 | 125
Feb | Cust B | 12 | 20
Mar | Cust B | 22 | 138
Apr | Cust B | 14 | 25
May | Cust B | 23 | 139
Jun | Cust B | 18 | 22
Jul | Cust B | 12 | 123
Aug | Cust B | 19 | 112
Sep | Cust B | 12 | 94
Oct | Cust B | 22 | 66
Nov | Cust B | 20 | 23
Dec | Cust B | 24 | 124
Jan | Cust C | 12 | 13
Feb | Cust C | 11 | 107
Mar | Cust C | 14 | 86
Apr | Cust C | 18 | 83
May | Cust C | 23 | 67
Jun | Cust C | 18 | 95
Jul | Cust C | 14 | 61
Aug | Cust C | 25 | 100
Sep | Cust C | 18 | 104
Oct | Cust C | 23 | 141
Nov | Cust C | 15 | 25
Dec | Cust C | 18 | 65
Jan | Cust D | 17 | 54
Feb | Cust D | 11 | 113
Mar | Cust D | 14 | 72
Apr | Cust D | 24 | 77
May | Cust D | 14 | 30
Jun | Cust D | 19 | 23
Jul | Cust D | 10 | 89
Aug | Cust D | 18 | 94
Sep | Cust D | 18 | 143
Oct | Cust D | 20 | 70
Nov | Cust D | 19 | 25
Dec | Cust D | 12 | 10
Spreadsheet: 798562d1664552986-how-do-i-achieve-this-type-of-table-jpeg_list
Sheet: Sheet1

[NAME] | /Folder/Jpg A.jpg | 5 | 1
[NAME] | /Folder/[NAME] | 0
[NAME] | /Folder/Jpg C.jpg | 10
[NAME] | /Folder/[NAME] | 0
[NAME] | /Folder/Jpg E jpg | 0
[NAME] | /Folder/Jpg F.jpg | 15
Spreadsheet: 680393d1591004605-allocating-costs-dependant-on-date-input-excel-forum-sample
Sheet: Sheet2

 | Allocation | Cost Code Description | Date On | Date Off | Rate | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00
 | Temporary Works | Signs Cones & Equipment | 2020-01-04 00:00:00 | 2020-05-20 00:00:00 | 20
 | Attendances | Storeman | 2020-01-04 00:00:00 | 2020-04-06 00:00:00 | 450
 | Waste Management | Materials to Recycling Facility | 2020-05-05 00:00:00 | 2020-05-05 00:00:00 | 250
 | Attendances | BGC General [NAME] | 2020-01-04 00:00:00 | 2020-06-30 00:00:00 | 620
 | Plant | Demolition Equipment | 2020-01-20 00:00:00 | 2020-03-18 00:00:00 | 800
 | Plant | Commercial Vehicles | 2020-01-04 00:00:00 | 2020-06-30 00:00:00 | 400
 | Plant | Generators | 2020-01-04 00:00:00 | 2020-06-30 00:00:00 | 550
 | Employers Requirements | PPE | 2020-02-05 00:00:00 | 2020-02-05 00:00:00 | 500
 | Scaffolding | Scaffolding | 2020-04-05 00:00:00 | 2020-06-20 00:00:00 | 1200
 | Temporary Works | Barriers | 2020-01-04 00:00:00 | 2020-05-08 00:00:00 | 60
 | Site Set Up | Furniture | 2020-01-04 00:00:00 | 2020-06-30 00:00:00 | 55
Spreadsheet: e33db9ca-6d79-4007-a21e-e403a0e26225
Sheet: Cash Forecast Detail Top Down

 |  |  |  |  |  | Disbursement Forecast
Amount as originally budgeted: | 500000 | forecasted amount: |  | 1600000 | Q6
Amount as originally budgeted: | 600000 | forecasted amount: |  | 600000 | Q7 |  |  | Forecasted expenditures/cash needs in the PU/DR
FORECAST REVIEW
LESS
as of last reporting period | Savings from late staff recruitment |  |  |  |  | -100000 |  | See Section 3A
as of last reporting period | Technical assistance for labs - to be funded by another donor |  |  |  |  | -50000 |  | See Section 3A
Q5 | Unused SR cash balance not offset by commitments/due payments |  |  | Less |  | -80000 |  | See Section 4C from Background information
Q7 | Advance pmt for test systems |  |  | Less |  | -100000 |  | See Section 4C from Background information
 |  |  |  | TOTAL | (a) |  |  | Subtotal of cash declared as "needed" but unjustified
 | Adjusted Forecasted Cash Needs |  |  |  | (b) |  |  | Adjusted Forecast
 | Cash Balance: End of period covered by Progress Update: |  |  |  | (c ) |  |  | Available Funds
 |  |  |  |  | (b-c) |  |  | Disbursement Amount
Spreadsheet: 128716d1321230114-vlookup-in-different-coumns-hooves-world-racing-syndicate-1
Sheet: Sheet13

MEMBERS | #
[NAME]
[NAME]
[NAME]
Anne-Rita le Riche
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Carola Larsson
[NAME]
Chezza Goodgirl
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Dante Love Dancel Lara
[NAME]
[NAME]
Deb Mclean
[NAME]
Doreen Laws Hart
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
J T Patryck Voie
[NAME]
[NAME]
Jane-Marie Nash
[NAME]
[NAME]
[NAME]
Jen Rayoso
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] [NAME]
[NAME]
[NAME]
[NAME]
[NAME] Condely
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Jestoneil Poblete
[NAME]
Spreadsheet: e3ba312a-7009-4494-8913-96b88259e35a
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
2748 | 15598 | Germaine | Roullet | ITA | 72 | 00:30:23 | 00:00:00 | 00:47:48 | 00:00:00 | 00:34:35 | 1 | 01:52:47
2748 | 15487 | Yuliya | Barabash | RUS | 71 | 00:28:59 | 00:00:00 | 00:50:36 | 00:00:00 | 00:36:05 | 2 | 01:55:42
2748 | 6522 | Radka | [NAME] | CZE | 73 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNS | 00:00:00
Spreadsheet: 19676e84-6de9-4b1c-9c6b-e4817a50ed1b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7682 | 57706 | [NAME] | Confait | RSA | 0 | 00:20:56 | 00:00:00 | 01:26:09 | 00:00:00 | 00:30:57 | 1 | 02:18:04
Spreadsheet: 837601d1690284636-matching-two-lists-of-postcodes-postcode
Sheet: Sheet1

 | Addresses |  |  | Town Centre
 | M27 6AS |  |  | M27 9RS
 | M30 0NB |  |  | M27 9RZ
 | M6  6JZ |  |  | M27 9SH
 | M27 9TT |  |  | M27 9TD
 | M27 5WY |  |  | M27 9TL
 | M38 9PH |  |  | M27 9TT
 | M27 5WY |  |  | M27 9UA
 | M44 6FE |  |  | M27 9UH
 |  |  |  | M27 9US
 |  |  |  | M27 9UZ
 |  |  |  | M27 9XG
 |  |  |  | M27 9XR
Spreadsheet: 160347d1339061760-excel-2007-averaging-variable-length-strings-forum-query-1
Sheet: Sheet1

Data Example
Wind speed | Output
(KPH) | (KW)
1 | 12.1 |  | Notes:
1 | 13.2
1 | 12.8 |  | The number of results for each wind speed is variable.
1 | 13.4
1 | 12.9 |  | Results received are always sorted on Col A.
1 | 13.3
1 | 9.8 |  | Require average output for each wind speed
2 | 15.4
2 | 16
2 | 15.5
2 | 12.6
3 | 18.4
3 | 20.1
Expected results
1 | 12.5 |  | Sum 87.5 | Count 7 | Average 12.50
2 | 14.88 |  | Sum 59.5 | Count 4 | Average 14.88
3 | 19.25 |  | Sum 38.5 | Count 2 | Average 19.25
Spreadsheet: 218719d1362554691-excel-magic-regression-with-intercept-specified-excel-regression-non-zero-intercept
Sheet: Sheet1

 |  | y = 0.5 + x - 0.05x^2
 |  | x | y |  | x^0 | x^1 | x^2 | x^3 | x^4 | y*x | y*x^2
 |  | 1
 |  | 2
 |  | 3
 |  |  |  |  |  |  |  |  |  |  |  | sums
 |  |  | Augmented matrix for quadratic |  |  |  |  | Augmented matrix through origin
 |  |  | x^0 | x^1 | x^2 | y |  |  | x^1 | x^2 | y
 |  | x^0 | 3 | 6 | 14 | 2 |  | x^1 | 14 | 36 | 4.4
 |  | x^1 | 6 | 14 | 36 | 4.4 |  | x^2 | 36 | 98 | 10.9
 |  | x^2 | 14 | 36 | 98 | 10.9
 | r1 / 3 | x^0
 | r2 / 6 | x^1 |  |  |  |  |  | x^1
 | r3 / 14 | x^2 |  |  |  |  |  | x^2
 |  | x^0 | 1 | 2 | 4.666666666666667 | 0.6666666666666666
 | [NAME] | x^1 |  |  |  |  |  | x^1 | 1 | 2.571428571428572 | 0.3142857142857143
 | r3 - r1 | x^2 |  |  |  |  |  | x^2
 |  | x^0 | 1 | 2 | 4.666666666666667 | 0.6666666666666666
 | r2 / leading | x^1 | 0 |  |  |  |  | x^1 | 1 | 2.571428571428572 | 0.3142857142857143
 | r3 / leading | x^2 | 0 |  |  |  |  | x^2 | 0
 |  | x^0 | 1 | 2 | 4.666666666666667 | 0.6666666666666666
 |  | x^1 | 0 | 1 | 3.999999999999997 | 0.2000000000000002 |  | x^1 |  |  |  | Coefficient x^1
 | r3 - r2 | x^2 | 0 |  |  |  |  | x^2 | 0 | 1 | -0.07631578947368435 | Coefficient x^2
 |  | x^0 | 1 | 2 | 4.666666666666667 | 0.6666666666666666
 |  | x^1 | 0 | 1 | 3.999999999999997 | 0.2000000000000002
 | r3 / leading | x^2 | 0 | 0
 | r1 - x^2 * r3 | x^0
 | [NAME] | x^1
 |  | x^2 | 0 | 0 | 1 | -0.0500000000000018
 | r1 - x^1 * r2 | x^0 |  |  |  |  | Coefficient x^0
 |  | x^1 | 0 | 1 | 0 | 0.4000000000000072 | Coefficient x^1
 |  | x^2 | 0 | 0 | 1 | -0.0500000000000018 | Coefficient x^2
Spreadsheet: michelle_lokay__26556__imbalsumm0012
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635
3531 | -63632 | -53122
60667
60749 |  | -5926
61206
61334 | -49762
62960
INDEX
2000-11-30 00:00:00 |  |  | 67709.97
2000-12-02 00:00:00
Spreadsheet: 72ce5b77-1978-4b8d-b495-59f6d94023c8
Sheet: Sheet1

Name | Curric | Goals | SDI | Planning | Para | AT | FBA/BIP | Student Total | Unnamed: 9
 |  |  |  |  |  |  |  | 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
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | Caseload
 |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  | 0
Spreadsheet: 58080d1258392834-changing-numbers-with-errors-errors
Sheet: Sheet1

 | Average of Response Time Mins
 | Area | Total
 | 09-A | 32.22222222222222
 | 10-A | 62.1304347826087
 | 10-B | #N/A
 | 11-B | #N/A
 | 11-T | #N/A
 | 12-A | #N/A
 | 12-B | #N/A
 | 13-A | #N/A
 | 13-C | #N/A
 | 13-S | #N/A
 | 14-A | #N/A
 | 14-B | #N/A
 | 15-A | #N/A
 | 15-B | #N/A
 | 20-A | #N/A
 | 20-B | #N/A
 | 20-C | #N/A
 | 20-E | #N/A
 | 21-A | #N/A
 | 21-B | #N/A
 | 21-S1 | #N/A
 | 22-A | #N/A
 | 22-B | #N/A
 | 22-C | #N/A
 | 23-A | #N/A
 | 23-B | #N/A
 | 24-D | #N/A
 | 25-A | #N/A
 | 25-B | #N/A
 | 25-D | #N/A
 | 25-E | #N/A
 | 26-A | #N/A
 | 26-B | #N/A
 | 26-C | #N/A
 | 38-A | #N/A
 | 38-B | #N/A
 | 39-A | 30
 | 39-C | 24.86666666666667
 | 39-R | 138.6363636363636
 | 40-A | 50.8
 | 40-B | 33.04651162790697
 | 40-C | 42.21052631578947
 | 40-D | 103
 | 41-A | 77.71428571428571
 | 41-B | 38.84615384615385
 | 41-R | 80.55555555555556
 | 42-C | 60.57894736842105
 | 42-D | 49.98076923076923
 | 42-E | 44.72
 | 42-O | 62.6304347826087
 | 42-W | 58.83333333333334
 | 43-A | 33.76923076923077
 | 43-B | 39.16666666666666
 | 44-A | 82.1086956521739
 | 44-B | 48.25581395348837
 | 44-S | 27.16666666666667
 | 45-A | 46.87096774193548
 | 45-C | 54.0327868852459
 | 51-A | 93.32
 | 51-C | 77.39669421487604
 | 51-D | 81.79661016949153
 | 52-A | 85.1
 | 52-B | 61
 | 52-C | 55.05
 | 52-S | 38.51020408163265
 | 53-A | 77.51724137931035
 | 53-B | 57.91139240506329
 | 56-A | 45.46551724137931
 | 56-B | 52.02325581395349
 | 56-C | 68.12222222222222
 | 70-A | 43.42957746478874
 | 70-B | 50.2
 | 70-D | 67.01666666666667
 | 70-G | 54.68
 | 70-H | 49.890625
 | 70-S | 1.6
 | 71-A | 38.83333333333334
 | 71-C | 78.96296296296296
 | 73-A | 51.62264150943396
 | 74-A | 45
 | 74-B | 74.44186046511628
 | Grand Total | 56.93793959453868
Spreadsheet: 888455d1738941378-please-help-with-results-table-vlookup-match-index-functions-or-a-table-gymnastics-results-forum
Sheet: Sheet1

No. | TEAM | TEAM 1 | BENCH | FLOOR | Rank Bench | Rank Floor |  | Team | Bench | Floor | TOP 5 V+F | Position |  | INDIVIDUAL BENCH | Name | TEAM | SCORE | INDIVIDUAL FLOOR | Name | TEAM | SCORE |  | TEAM NAME | GYMNAST NAME  BENCH | GYMNAST NAME FLOOR
1 | 1 | Gymnast 1 | 7 | 6.5 |  |  |  | 1 |  |  |  |  |  | 1st |  |  |  | 1st |  |  |  |  | Team 1
2 | 1 | Gymnast 2 | 8 | 9 |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team 2
3 | 1 | Gymnast 3 | 9 | 8.7 |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team 3
4 | 1 | Gymnast 4 | 9.1 | 4.5 |  |  |  | 4 |  |  |  |  |  | 2nd |  |  |  | 2nd |  |  |  |  | Team 4
5 | 1 | Gymnast 5 | 5 | 6
6 | 1 | Gymnast 6 | 6.6 | 8 |  |  |  | TEAM SCORES BY SCHOOL |  |  | SCORE
7 | 2 | Gymnast 7 | 5.5 | 4 |  |  |  |  |  |  |  |  |  | 3rd |  |  |  | 3rd
8 | 2 | Gymnast 8 | 6.8 | 6.5
9 | 2 | Gymnast 9 | 9.7 | 7
10 | 2 | Gymnast 10 | 4.5 | 9.8
11 | 2 | Gymnast 11 | 6 | 6.9
12 | 2 | Gymnast 12 | 7.5 | 8.8
13 | 3 | Gymnast 13 | 8 | 4.5
14 | 3 | Gymnast 14 | 9 | 6
15 | 3 | Gymnast 15 | 7.5 | 9.8
16 | 3 | Gymnast 16 | 9.9 | 6
17 | 3 | Gymnast 17 | 8 | 7.4
18 | 3 | Gymnast 18 | 6.5 | 8.9
19 | 4 | Gymnast 19 | 5.5 | 8
20 | 4 | Gymnast 20 | 6.5 | 9
21 | 4 | Gymnast 21 | 4.9 | 8
22 | 4 | Gymnast 22 | 8 | 8.5
23 | 4 | Gymnast 23 | 9 | 8.9
24 | 4 | Gymnast 24 | 6 | 7
Spreadsheet: 328721d1404044245-self-populating-columns-with-information-fromother-cells-sra-template-temp-format
Sheet: Sheet1

Risk ([NAME] (O)* | Status (Open/Closed) | Date Entered (dd/mm/yyyy) | Risk Category | Risk Owner | Risk Description | Risk Name | Consequences | Management Controls | Management Control Owner | Current Likelihood Rating | Current Consequence Rating | Current Risk Rating | Action | Action Owner | Residual Risk Rating |  |  |  | Target Likelihood Rating % | Target Consquence Rating
 |  |  |  |  |  |  |  |  |  | Unlikely 6% | Minor  No loss of service capability.
 |  |  |  |  |  |  |  |  |  | Unlikely 6% | Minor  No loss of service capability.
 |  |  |  |  |  |  |  |  |  | Possible 46% | Minor  No loss of service capability.
 |  |  |  |  |  |  |  |  |  | Almost Certain 90%+ | Catastrophic Death/s
Spreadsheet: 703571d1605058188-formula-help-a-specific-part-number-sum-its-quantities-and-multiply-by-25-example1
Sheet: Sheet1

Customer | Part Number | Quantitiy | Output -->
Whiskey | 366102 | 1
Whiskey | 551256 | 1
Whiskey | 366102 | 5
Whiskey | 366102 | 10
Whiskey | 41268 | 1
Tango | 366102 | 1
Tango | 36875 | 1
Tango | 366102 | 5
Tango | 366102 | 10
Tango | 32586 | 1
Foxtrot | 366102 | 1
Foxtrot | 212565 | 1
Foxtrot | 366102 | 5
Foxtrot | 366102 | 10
Foxtrot | 986253 | 1
Spreadsheet: 235441d1368493565-complicated-data-selection-data-selection
Sheet: Sheet1

Product | Customer | Sales | Units | ReportFilter
Orange | Thomas & Co | 200 | 12 |  | Ignore
Apple | Harry & Co | 300 | 13 |  | Ignore
Pear | Peter & Co | 400 | 156 |  | OK
Orange | Peter & Co | 500 | 14 |  | OK
Apple | Peter & Co | 600 | 12 |  | OK |  | Which CUSTOMERS ordered "Orange" along with other products ? Then label in column "E" as OK
Pear | Machan Corporate | 700 | 13 |  | Ignore |  | If Customers ordered only "Orange", label "ignore"
[NAME] | Kuttans House | 800 | 18 |  | Ignore |  | If Customers did not order Orange at all, label " ignore"
Orange | [NAME] | 900 | 15 |  | Ignore
Apple | Sinlaf Conrporate | 521 | 22
Apple | Freelance Corporate | 456 | 25
Pear | Freelance Corporate | 654 | 1
Orange | Machan Corporate | 456 | 235 |  | Ignore
[NAME] | Ruth & Co | 423 | 21 |  | OK
Orange | Ruth & Co | 52 | 2 |  | OK
Orange | James & Co | 321 | 23 |  | Ignore
BC | Freelance Corporate | 42 | 22 |  | Ignore
 |  |  |  |  |  |  | In this example
 |  |  |  |  |  |  | "Peter & Co" ordered Orange along with Pear and Apple. He got selected. So label "OK"
 | [NAME] |  |  |  |  |  | "Ruth & Co" ordered Orange along with [NAME]. He got Selected.So label "OK"
 |  |  |  |  |  |  | "Thomas & Co" ordered only Orange. So he is ignored. So label "ignore"
 |  |  |  |  |  |  | "Harry & Co" did not order any Orange. So he is ignored. So label "ignore"
Spreadsheet: 1a65b925-4726-425d-93f9-3eaab44044c7
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
 | 5625.0 Private New Capital Expenditure and Expected Expenditure, Australia
 | TABLE 9A. Actual and Expected Capital Expenditure by Asset - South Australia:Current Prices $m
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
Actual Expenditure ;  South Australia ;  Total (Industry) ;  [NAME] and [NAME] ;  Current Price ; |  |  | Original | A3516301A | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Actual Expenditure ;  South Australia ;  Total (Industry) ;  Equipment, Plant and Machinery ;  Current Price ; |  |  | Original | A3516343X | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Actual Expenditure ;  South Australia ;  Total (Industry) ;  Total (Type of Asset - Detailed Level) ;  Current Price ; |  |  | Original | A3516385W | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Long Term Expected Expenditure ;  South Australia ;  Total (Industry) ;  [NAME] and [NAME] ;  Current Price ; |  |  | Original | A3516303F | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Long Term Expected Expenditure ;  South Australia ;  Total (Industry) ;  Equipment, Plant and Machinery ;  Current Price ; |  |  | Original | A3516345C | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Long Term Expected Expenditure ;  South Australia ;  Total (Industry) ;  Total (Type of Asset - Detailed Level) ;  Current Price ; |  |  | Original | A3516387A | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Short Term Expected Expenditure ;  South Australia ;  Total (Industry) ;  [NAME] and [NAME] ;  Current Price ; |  |  | Original | A3516302C | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Short Term Expected Expenditure ;  South Australia ;  Total (Industry) ;  Equipment, Plant and Machinery ;  Current Price ; |  |  | Original | A3516344A | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Short Term Expected Expenditure ;  South Australia ;  Total (Industry) ;  Total (Type of Asset - Detailed Level) ;  Current Price ; |  |  | Original | A3516386X | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: 49232d1248459016-minimum-distance-between-points-mininumdistance
Sheet: Sheet2

 | [NAME] | CUST_02 | CUST_03 | CUST_04 | CUST_05 | MINIMUM DISTANCE
Day 1 | 1 | 0 | 1 | 0 | 0 |  | should be | 21.7
Day 2 | 1 | 0 | 0 | 1 | 0 |  | should be | 18.9
Day 3 | 1 | 0 | 1 | 0 | 1 |  | should be | 3.1
Day 4 | 0 | 1 | 0 | 1 | 1 |  | should be | 0.3
Day 5 | 1 | 1 | 0 | 1 | 1 |  | should be | 0.3
Spreadsheet: 183305d1348773107-changing-cell-color-from-an-if-statement-etl-comparison
Sheet: Sheet1

 | January | February | March | April | May | June | July | August | September | October | November | December
Monthly ETL | 2.97 | 3.67 | 5.97 | 8.03 | 9.9 | 10.54 | 9.13 | 7.99 | 7.26 | 5.77 | 3.6 | 2.6
Spreadsheet: 789719d1659327063-ratio-to-staff-calculator-ratio-calc-copy
Sheet: Sheet1

 |  |  |  | [NAME]'s ratio to staff calcuator
 |  |  |  | Ratio
 |  |  |  | 1 | 2 | 3 | 4
 |  |  |  | 1:1 | 1:2 | 1:3 | 1:4
 |  |  |  | 3 | 5 | 11 | 7
 |  |  | Total | 3 | 3 | 4 | 2
 |  |  | Residual | 0 | 0 | 1 | 2
 |  |  | Total staff | 12
 |  |  | Total + IC | 13
 |  |  | Nursing hours (8hrs) |  | 104
 |  |  | Nursing night (10hrs) |  | 130
 |  |  | Total no of pt |  | 26
Spreadsheet: louise_kitchen__22746__Turbine Position Report 051801
Sheet: Summary by Region

Turbine Position Report |  |  |  |  |  |  |  | CONFIDENTIAL
Summary by Controlling Region
($ MMs)
 |  |  |  |  |  |  | Financial Data as of
UNITS | MODEL | CONTROLLED BY | STATUS | DASH APPROVAL DATE / STATUS | PROJECT(S) | CONTRACT COST | SCHEDULED CONTRACT PYMTS TO DATE | CANCELLATION
EWS
 |  |  |  |  | TOTAL EECC
EA
 |  |  |  |  | TOTAL EA
EGM
 | UNITS - TOTAL |  |  |  | GRAND TOTALS
 |  |  |  |  | per Summary By [NAME] report
 |  |  |  |  | Difference
Spreadsheet: darrell_schoolcraft__7816__imbalsumm0109
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -129797
3531 | -130453 | -62752
60667 | -42521 | -13597
60749 | 210546 | 763
61206
61334
62960
INDEX
2001-08-31 00:00:00 |  |  | 371897
2001-09-05 00:00:00
CBS Volume
 |  |  | -39871