tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 43903d1242561595-top5-bottom5-from-a-column-of-values-top5bottom5-daddy
Sheet: Sheet1

Security Name | ROC | Rank
Australian Dollar / Japanese Yen | -0.3378
Australian Dollar / NewZealand Dollar | 0.1348
British Pound / Australian Dollar | 0.1255 |  |  |  |  | Top 5 | Security Name | ROC |  | Bottom 5 | Security Name | ROC
British Pound / Canadian Dollar | 0.6065 |  |  |  |  | 1 |  |  |  | 1
British Pound / Danish Krone | 0.457 |  |  |  |  | 2 |  |  |  | 2
British Pound / Euro | 0.4851 |  |  |  |  | 3 |  |  |  | 3
British Pound / Hong Kong Dollar | 1.0859 |  |  |  |  | 4 |  |  |  | 4
British Pound / Indian Rupee | 0.6922 |  |  |  |  | 5 |  |  |  | 5
British Pound / Japanese Yen | -0.1966
British Pound / New Zealand Dollar | 0.3104
British Pound / Singapore Dollar | 0.7359 |  |  |  | Note: | The number of rows will vary.
British Pound / Swedish Krona | 0.482
British Pound / Swiss Franc | 0.7398
British Pound / US Dollar | 1.0388
Canadian Dollar / Japanese Yen | -0.8491
Euro / Australian Dollar | -0.3409
Euro / Canadian Dollar | 0.1579
Euro / Hong Kong Dollar | 0.5086
Euro / Indian Rupee | 0.1983
Euro / Japanese Yen | -0.5819
Euro / New Zealand Dollar | -0.1463
Euro / Norwegian Krone | 0.2613
Euro / South African Rand | 0.0861
Euro / Swedish Krona | 0.0424
Euro / Swiss Franc | 0.1261
Euro / US Dollar | 0.5083
Gold | 1.0136
Hong Kong Dollar / Japanese Yen | -1.1803
Hong Kong Dollar / Singpore Dollar | -0.3173
[NAME] | -0.8571
New Taiwan Dollar / Japanese Yen | -1.2738
New Zealand Dollar / Japanese Yen | -0.9545
Palladium | -0.4283
Platinum | 1.3908
Silver | 1.9411
Singapore Dollar / Japanese Yen | -0.9055
Swiss Franc / Australian Dollar | -0.5137
Swiss Franc / Japanese Yen | -0.8194
Swiss Franc / Singapore Dollar | 0.0682
Thai Baht / Japanese Yen | -1.0536
US Dollar / Australian Dollar | 0.8571
US Dollar / Canadian Dollar | -0.4198
US Dollar / Chinese Yuan Renminbi | -0.0293
US Dollar / Danish Krone | -0.525
US Dollar / Hong Kong Dollar | 0.0026
US Dollar / Iceland Krona | -0.446
US Dollar / Indian Rupee | -0.3238
US Dollar / Isreali Shekel | 0.2205
US Dollar / Japanese Yen | -1.1484
US Dollar / New Zealand Dollar | 0.6153
US Dollar / Norwegian Krone | -0.2526
US Dollar / Russian Ruble | -0.7274
US Dollar / Singapore Dollar | -0.307
US Dollar / South African Rand | -0.431
US Dollar / Swedish Krona | -0.4667
US Dollar / Swiss Franc | -0.3605
US Dollar / Turkish Lira | -0.262
Spreadsheet: 828232d1683306945-complex-look-up-formula-having-both-vertical-and-horizontal-lookup-areas-sample-1-
Sheet: RawData

SYMBOL |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
 | [NAME] | [NAME]
DATE |  | 2023-05-04 00:00:00 | 2023-05-03 00:00:00 | 2023-05-02 00:00:00 | 2023-04-28 00:00:00 | 2023-04-27 00:00:00 | 2023-04-26 00:00:00 | 2023-04-25 00:00:00 | 2023-04-24 00:00:00 | 2023-04-21 00:00:00 | 2023-04-20 00:00:00 | 2023-04-19 00:00:00 | 2023-04-18 00:00:00 | 2023-04-17 00:00:00 | 2023-04-13 00:00:00 | 2023-04-12 00:00:00 | 2023-04-11 00:00:00 | 2023-04-10 00:00:00 | 2023-04-06 00:00:00 | 2023-04-05 00:00:00 | 2023-04-03 00:00:00 | 2023-03-31 00:00:00 | 2023-03-29 00:00:00
APPLE |  | 84.95 | 84.45 | 83.55 | 82.75 | 80.05 | 83.7 | 84.4 | 83.8 | 83.8 | 82.25 | 82.5 | 82 | 82.85 | 83 | 83.9 | 80.85 | 79.65 | 78.2 | 78.6 | 74.3 | 65.85 | 64.7
BANANA |  | 868.35 | 868.35 | 902.4 | 876.25 | 883.9 | 808.3 | 824.25 | 843.1 | 835.5 | 840.45 | 769.1 | 773.45 | 768.65 | 756.3 | 752.5 | 754 | 759.7 | 760.25 | 764.8 | 753.1 | 756.1 | 737.35
CAT |  | 0.45 | 0.45 | 0.4 | 0.45 | 0.4 | 0.4 | 0.45 | 0.4 | 0.4 | 0.45 | 0.4 | 0.45 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.45 | 0.4 | 0.4 | 0.4 | 0.4
DOG |  | 908.1 | 908.1 | 899.85 | 878.75 | 877 | 876.4 | 877.9 | 877.1 | 876.95 | 883.3 | 864.6 | 866.65 | 899.1 | 874.7 | 889.5 | 902.55 | 891.3 | 849.5 | 867.3 | 852 | 795.05 | 798.75
HAT |  | 192.85 | 192.85 | 192.65 | 195.85 | 194.1 | 192.25 | 190.95 | 188.4 | 187.8 | 188.05 | 188.1 | 186.9 | 188.1 | 185.4 | 185.3 | 184.95 | 181.45 | 181.05 | 180.7 | 180.3 | 177.95 | 177.05
MAT |  | 1319.8 | 1319.8 | 1318.25 | 1328.25 | 1322.65 | 1289.25 | 1278.65 | 1255.25 | 1246.25 | 1267.65 | 1250.45 | 1271.9 | 1299.3 | 1332.3 | 1381.35 | 1350.85 | 1312.5 | 1272.8 | 1254.65 | 1236.5 | 1228.85 | 1219.9
RAT |  | 121.6 | 121.6 | 125.7 | 116.5 | 114.45 | 113.9 | 114.05 | 114.95 | 116.7 | 117.25 | 119.95 | 119.15 | 114.2 | 114.5 | 115.4 | 116.3 | 117.7 | 119.15 | 116.1 | 114.75 | 100.85 | 102.45
CAT |  | 348.5 | 348.5 | 350.45 | 343.1 | 341.4 | 351.55 | 346.45 | 330.7 | 331.75 | 325 | 328.95 | 330.55 | 334.1 | 320.8 | 285.4 | 237.85 | 231 | 220.2 | 226.4 | 215.65 | 205.4 | 206.9
HEAT |  | 1242.95 | 1242.95 | 1242.3 | 1258.05 | 1275.4 | 1292.35 | 1289.1 | 1198 | 1133.1 | 1143.25 | 1144.65 | 1163.7 | 1119.2 | 1070.65 | 1078.65 | 1082.8 | 1038.4 | 1032.1 | 1025.15 | 1014.75 | 913.15 | 909.25
FEET |  | 363.7 | 363.7 | 369.75 | 365.85 | 349.85 | 349.4 | 357.15 | 369.3 | 359.15 | 363.35 | 364.65 | 355.45 | 337.5 | 336.65 | 321.65 | 319.65 | 325.8 | 329.35 | 326.05 | 329.4 | 316.35 | 313.15
Spreadsheet: 865180d1712232368-table-transpose-complex-cartel1
Sheet: output

 | TEST OUTPUT
 |  |  | [NAME]:
 |  |  | Dimensione:
 | [NAME] le variabili |  |  | [NAME] | Probabilmente no | Probabilmente sì | [NAME] sì
 | Dimensione: |  | xxx | 0 | 0.1028572798120412 | 0.6084575719867181 | 0.2886851482012407
Not needed | [NAME]? |  | yyy | 0 | 0.06655075571755996 | 0.5784923364904289 | 0.3549569077920112
 |  |  | zzz | 0 | 0 | 0.8065127718279329 | 0.193487228172067
 | KPI:
??????? | input
 | Rielaborazione:
 | Vettore0
 | [NAME]:
 | 3 Area 3
Spreadsheet: 52676d1252515035-email-to-as-an-attachment-dailyprice
Sheet: Sheet1

 |  |  |  | RENNER PETROLEUM
 |  |  |  | PO Box 4868
 |  |  |  | 1100 W. 14th Street
 |  |  |  | [NAME], CA 95502
[EMAIL] |  |  |  | Phone: (707) 443-1645
 |  |  |  | FAX: (707) 443-0175
Trucking |  |  | FAX: |  |  | Phone:
Attn: Debbie
[NAME].  Acct. # |  | 5393641 |  | DATE |  | SOURCE 1 |  | SRC. 2 |  | SRC. 3
Month of | September 09 |  |  | 1 |  | 3.18586 |  | 3.0794 |  | 3.145
 |  |  |  | 2 |  | 3.18586 |  | 3.0598 |  | 3.095
Clear Diesel #2 |  |  |  | 3 |  | 3.18586 |  | 3.0714 |  | 3.105
Ultra Low Sulfur |  |  |  | 4 |  | 3.18586 |  | 3.0559 |  | 3.085
Renner Acct. # 11056 |  |  |  | 5 |  | 3.18586
 |  |  |  | 6 |  | 3.18586
 |  |  |  | 7
[NAME] |  |  |  | 8 |  | 3.08646 |  | 3.0314 |  | 3.075
 | Required |  |  | 9 |  | 3.08646 |  | 3.1034 |  | 3.115
 | Not Required |  |  | 10 |  | 3.08646
 |  |  |  | 11 |  | 3.08646
 |  |  |  | 12 |  | 3.08646
 |  |  |  | 13 |  | 3.08646
 |  |  |  | 14
Terms: |  |  |  | 15
 |  |  |  | 16
 |  |  |  | 17
 |  |  |  | 18
 |  |  |  | 19
 |  |  |  | 20
 |  |  |  | 21
 |  |  |  | 22
 |  |  |  | 23
 |  |  |  | 24
 |  |  |  | 25
 |  |  |  | 26
 |  |  |  | 27
Prices subject to change |  |  |  | 28
on emergency basis |  |  |  | 29
and may be without notice. |  |  |  | 30
 |  |  |  | 31
 |  |  |  |  |  |  |  | ***CONOCO PHILLIPS IF AVAILABLE
Spreadsheet: d36860e9-0c24-464b-ba64-a235292c5498
Sheet: Sheet1

Release: Housing Units Authorized By Building Permits (Seasonally Adjusted) | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=246
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-07-22 3:03 PM CDT
 | Real-Time | Period
Name: | Start | End
Housing Units Authorized By Building Permits (Seasonally Adjusted) | 2011-12-23 00:00:00 | Current
Link:
http://www.census.gov/construction/bps/ | 2011-12-23 00:00:00 | Current
Source:
Federal Reserve Bank of St. Louis | 2011-12-23 00:00:00 | Current
Notes:
Census data seasonally adjusted by the Federal Reserve Bank of Saint | 2011-12-23 00:00:00 | Current
Louis.
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2011-12-23 00:00:00
2012-01-27 00:00:00
2012-02-27 00:00:00
2012-03-26 00:00:00
2012-04-25 00:00:00
2012-05-24 00:00:00
2012-06-26 00:00:00
2012-07-26 00:00:00
2012-08-24 00:00:00
2012-09-27 00:00:00
2012-10-25 00:00:00
2012-11-29 00:00:00
2012-12-28 00:00:00
2013-01-28 00:00:00
2013-02-27 00:00:00
2013-03-26 00:00:00
2013-04-24 00:00:00
2013-05-24 00:00:00
2013-06-26 00:00:00
2013-07-25 00:00:00
2013-08-26 00:00:00
2013-09-26 00:00:00
2013-11-27 00:00:00
2013-12-24 00:00:00
2014-01-28 00:00:00
2014-02-27 00:00:00
2014-03-26 00:00:00
2014-04-24 00:00:00
2014-05-27 00:00:00
2014-06-25 00:00:00
Spreadsheet: michelle_lokay__26625__sharris0201wk2
Sheet: Estimate Vs. Plan

Transwestern Pipeline Company
($[NAME])
Feb Week 2  02-16-01 |  |  |  |  |  | 2001-02-15 15:38:08.680000
 |  | February, 2001
 |  | Plan | Estimate | [NAME] |  | Comments
West Demand Revenues |  | 9.257 | 11.67807635 | 2.421076350000002 |  | Sempra & Richardson Short Term Firm Contracts; Tenaska K @ Max Rates
West Commodity Revenues |  | 0.766 | 0.7512252796000001 | -0.01477472039999994
East Demand Revenues |  | 1.0529 | 1.0842376216 | 0.03133762159999987
East Commodity Revenues |  | 0.1434 | 0.1757134483 | 0.03231344830000005 |  | Higher Rates
[NAME] |  | 0.5642999999999999 | 0.62570172 | 0.0614017200000001 |  | Higher Rates
[NAME] Revenues |  | 0.06229999999999999 | 0.1938274861 | 0.1315274861 |  | Higher IT volumes than in plan
 |  | ------------- | ------------- | -------------
Revenue Variance |  | 11.8449 | 14.5087819056 | 2.6638819056
Fuel Price [NAME] |  |  |  | 0.3062281311596191 | (1.95*157) | MTD index price of $5.70 vs. Plan index price of $3.75
 |  |  |  |  |  | Unhedged Plan volume (717-560)  157
Fuel Volume Variance-Unhedged |  |  |  | 0.2395805405235794 | (5.70*42) | Higher retained volumes than Plan volumes(759-717=42) @ MTD index price of $5.70
Sales Margin Variance on Unhedged |  |  |  | 0.554
Hedging Adjustment |  |  |  | 0.007 |  | Add'l price on physical sales of HEDGED volumes
 |  |  |  |  |  | ($.005 on 10,000/day, $.02 on 10,000/day)
Unaccounted for Variance |  |  |  | 0
 |  |  |  | -------------
Fuel Variance |  |  |  | 1.106808671683198
 |  |  |  | -------------
MONTH-TO-DATE VARIANCE |  |  |  | 3.770690577283199
 |  |  |  | ========
2001 Stretch |  | 0.85 | 0 | -0.85
 |  |  |  | -------------
ADJUSTED MONTH-TO-DATE VARIANCE |  |  |  | 2.920690577283199
 |  |  |  | ========
[NAME]
 | Year-to-Date
 | Margin | Fuel | Stretch | Total
Plan (through February) | 25.086 | 5.404 | 1.7 | 32.19
Estimate | 28.2797819056 | 8.065577867440847 | 0 | 36.34535977304085
 | ------------- | ------------- | ------------- | -------------
Variance from Plan | 3.193781905600005 | 2.661577867440847 | -1.7 | 4.155359773040852
 | ------------- | ------------- | ------------- | -------------
Spreadsheet: 824945d1680969520-identify-cells-in-a-range-of-200-miles-that-fall-within-30-and-40-miles-sample-list-of-towns-and-miles
Sheet: ROUTE STAGES (2)

A | B | C
Home - Virginia | 0
Leon / Casa Botines | 3.34
Mansilla de Las Mulas | 11.1 |  |  |  | This are the results (Actual sum value that is between >=30 and <=40 that I would like the formula to identify in the list
El Burgo Ranero | 22.9
Bercianos Del Camino Real | 27.4
Sahagun | 33.7 |  |  |  | 33.7 |  | 33.7 >=30 and <=40
Terradillos de Los Templarios | 41.3
Ledigos | 43.2
[NAME] | 47
Carrion de los Condes | 57.6
[NAME] | 61.2
[NAME] | 69.6 |  |  |  | 35.9 |  | B12   69.6 -  B6  33.7 = 35.9
Boadilla Del Camino | 73.1
Itero de la Vega | 78.1
Castrojeriz | 85.1
[NAME] | 97.1
[NAME] | 102 |  |  |  | 32.4 |  | B17  102 -  B12  69.6 = 32.4
Tardajos | 103
Burgos | 110
Ibea de Juarros | 119
[NAME] | 132
[NAME] | 136
Villalomez | 137 |  |  |  | 35 |  | B23  132 -  B17  102 = 35
Tosantos | 142
Belorado | 145
Leiva | 155
Herramelluri | 156
Santo Domingo de la Cueza | 162 |  |  |  | 27 |  | B28  162 -  B23  137 = 27 |  |  | In this case, the formula would not place any value…. Unless the formula range criteria is modified to only <=40, the formula will not function from this point down the list because it has no point of reference to sum the next 30 / 40 miles.
[NAME] | 178 |  |  |  | 41 |  | B29  178 -  B23  137 = 41
[NAME] | 200
Los Arcos | 217
Estella-Lizarra | 229
Puente La Reina | 241 |  |  |  |  |  |  |  |  | Can the formula be design to place the sum value closes to 30 or 40?               Or                                                                                                                                            if neither meets the parameter criteria; be design to place the 2nd sum value over >=40?
Obanos | 243
Pamplona | 258
Irurtzun | 272
[NAME] | 279
Jauntsarats | 282
Ola | 286
Saldias | 293
Labaien | 296
Doneztebe/Santesban | 304
Spreadsheet: 270195d1381412865-trying-to-get-an-if-formula-to-show-more-than-one-answer-0a1help
Sheet: Sheet1

Project Code | Class | Order Value | Recognised | To Recognise
PM08H | SA | 8500 | 8500 | 0
PM38H | A | 8500 | 0 | 8500
PM41H | C | 1170 | 0 | 1170
PM40H | C | 150 | 150 | 0
PM39H | C | 850 | 850 | 0
PM35H | C | 3750 | 3750 | 0
PM37H | C | 6375 | 6375 | 0
PM36H | C | 475 | 475 | 0
PM33H | C | 475 | 0 | 475
PM34H | C | 150 | 150 | 0
PM32H | C | 1700 | 0 | 1700
PM31H | C | 850 | 850 | 0
PM30H | B | 11250 | 5625 | 5625
PM27H | SA | 8500 | 8500 | 0
PM28H | C | 850 | 850 | 0
PM24H | B | 15750 | 15750 | 0
PM20H | SA | 21250 | 0 | 21250
PM19H | SA | 21240.44 | 21240.44 | 0
PM18H | SA | 21240.44 | 21240.44 | 0
PM17H | SA | 21240.44 | 21240.44 | 0
PM22H | C | 480 | 0 | 480
PM23H | C | 4250 | 4250 | 0
PM15H | C | 1049.7 | 1049.7 | 0
PM13H | B | 21250 | 21250 | 0
PM10H | C | 850 | 0 | 850
PM89G | SA | 4666.5 | 0 | 4666.5
PM67G | B | 22672 | 22672 | 0
PM92G | A | 49016 | 49016 | 0
PM74G | A | 85000 | 85000 | 0
PM90G | B | 19823 | 0 | 19823
PM87G | A | 113250 | 113250 | 0
PM96F-2 | A | 14662.5 | 14662.5 | 0
PM78G | B | 0 | 0 | 0
PM04G | A | 52763 | 36985.98 | 15777.02
[NAME] | A | 51421.43 | 39835.57 | 11585.86
PM44G | A | 126225 | 82876 | 43349
PM99F | A | 273700 | 267750 | 5950
PM96F-1 | A | 14662.5 | 14662.5 | 0
PM71F | B | 16150 | 16150 | 0
PM99E | B | 8500 | 8500 | 0
PM43E | B | 23075 | 6922 | 16153
Spreadsheet: 165814-dynamic-cells-2-example
Sheet: Sheet1

 | TYPE | PRODUCTS | OWNERSHIP
 | TYPE1 | PW1 | 20
 |  | PW2 | 5
 |  | PW3 | 20
 |  | PW4 | 20
 |  | PW5 | 20
 |  | PW6 | 10
 |  | PW7 | 5
 |  | PW8 | 0
 | TYPE2 | PB1 | 9
 |  | PB2 | 81
 |  | PB3 | 10
 | [NAME] | PS1 | 100
 |  | PS1 | 0
 |  | PS3 | 0
 |  | PS4 | 0
 |  | PS5 | 0
 | TYPE4 | PWB1 | 100
 |  | PWB2 | 0
 |  | PWB3 | 0
 | TYPE 5 | PKS1 | 40
 |  | PKS2 | 50
 |  | PKS3 | 10
 |  | P0T | 100
 | TYPE 6 | PWM1 | 65
 |  | PWM2 | 10
 |  | PWM3 | 25
 | TYPE 7 | PDW1 | 95
 |  | PDW2 | 5
 |  | TOTAL | 0
Spreadsheet: 749547d1632868459-count-formula-that-will-use-multiple-criteria-to-sum-how-many-targets-have-meet-met-count_problem_gw
Sheet: Sheet1

 | Month
Client | 1 | 2 | 3 | 6 | 12 | Target Calls | Target Months
[NAME] | 0 | 0 | 0 | 0 | 0 | 1 | 12
Alfred | 2 | 2 | 2 | 11 | 15 | 1 | 3
[NAME] | 1 | 3 | 3 | 5 | 10 | 2 | 1
[NAME] | 3 | 9 | 16 | 25 | 56 | 1 | 3
[NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 3
[NAME] | 1 | 2 | 4 | 5 | 10 | 2 | 3
[NAME] | 0 | 3 | 3 | 5 | 6 | 1 | 2
 |  |  |  |  |  | # Targets Met
 |  |  |  |  |  | # Targets Under
Spreadsheet: 677288d1589290052-lookup-find-multiple-occurrences-in-column-of-single-criteria-return-value-from-other-c-singlecriteriamultiplematches
Sheet: Sheet1

Dog |  | Cat | Siamese
 |  | Cat | Persian
 |  | Dog | Doberman
 |  | Dog | [NAME]
 |  | Dog | [NAME]
 |  | Horse | Arabian
 |  | Horse | Appaloosa
 |  | Horse | Clydesdale
 |  | Horse | Friesian
 |  | Horse | Andalusian
 |  | Bird | Crow
Spreadsheet: 036538b4-d05c-427e-9ae4-1776ba364069
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
 | 8731.0 Building Approvals, Australia
 | TABLE 35. Value of Building Approved - Tasmania
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
Value of Approval ;  Tasmania ;  Total residential building ;  New ; |  |  | Original | A420335T | 1970-07-01 00:00:00 | 2012-03-01 00:00:00 | 501 | $'000 | FLOW | Month | 1
Value of Approval ;  Tasmania ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A420344V | 1973-07-01 00:00:00 | 2012-03-01 00:00:00 | 465 | $'000 | FLOW | Month | 1
Value of Approval ;  Tasmania ;  Total residential building ;  Total (Type of work) ; |  |  | Original | A420356C | 1973-07-01 00:00:00 | 2012-03-01 00:00:00 | 465 | $'000 | FLOW | Month | 1
Value of Approval ;  Tasmania ;  Total non-residential building ;  Total (Type of work) ; |  |  | Original | A421038R | 1970-07-01 00:00:00 | 2012-03-01 00:00:00 | 501 | $'000 | FLOW | Month | 1
Value of Approval ;  Tasmania ;  Total building ;  Total (Type of work) ; |  |  | Original | A422668A | 1973-07-01 00:00:00 | 2012-03-01 00:00:00 | 465 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 843541d1695321673-need-help-with-formulas-re-month-and-years-and-averages-1990-cooking-and-heating-calculations
Sheet: Sheet1

SELECT A MONTH |  |  | Cost of Heating & Cooking Fuel                Year  -> |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00 |  | MONTHS | YEARS
January |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January | 2022-01-01 00:00:00
 |  | COST OF COOKING W/ PROPANE FOR YEAR SELECTED |  |  |  | PROPANE COST FOR CURRENT YR |  |  | AVG GALLONS USED PER MONTH |  |  | AVG YRLY COST PER MONTH |  |  | February | 2023-01-01 00:00:00
SELECT A YEAR BELOW |  |  |  |  |  |  |  |  |  |  |  |  |  |  | March | 2024-01-01 00:00:00
 |  | COST TO HEAT WITH PELLETS FOR YEAR SELECTED |  |  |  | PELLET COST FOR CURRENT YR |  |  | AVG COST PER TON PELLETS |  |  | AVG COST OF BAG PELLETS |  |  | April | 2025-01-01 00:00:00
2023-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May | 2026-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June | 2027-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July | 2028-01-01 00:00:00
 |  |  |  | PROPANE FUEL |  |  |  | PELLET FUEL |  |  |  |  |  |  | September | 2029-01-01 00:00:00
 |  | DATE | PURCHASED FROM | PURPOSE | GALLONS USED | PRICE PER GALLON | TOTAL COST OF PROPANE | PRICE PER TON FUEL | [NAME] PURCHASED | TOTAL COST OF PELLETS BY TON | PRICE PER BAG FUEL | [NAME] PURCHASED | TOTAL COST OF BAGGED PELLETS |  | October | 2030-01-01 00:00:00
 |  | 2023-01-01 00:00:00 | Delta Appliance | Cooking | 50.1 | 3.05 | 152.81 |  |  |  |  |  |  |  | November | 2031-01-01 00:00:00
 |  | 2023-01-11 00:00:00 | Tractor Supply | Heating |  |  |  |  |  |  | 6.19 | 25 |  |  | December | 2032-01-01 00:00:00
 |  | 2023-02-01 00:00:00 | Delta Appliance | Cooking | 25.1 | 3.08 | 77.31 |  |  |  |  |  |  |  |  | 2033-01-01 00:00:00
 |  | 2023-02-08 00:00:00 | Tractor Supply | Heating |  |  |  |  |  |  | 6.29 | 6 |  |  |  | 2034-01-01 00:00:00
 |  | 2023-02-15 00:00:00 | Tractor Supply | Heating |  |  |  |  |  |  | 6.19 | 6 |  |  |  | 2035-01-01 00:00:00
 |  | 2023-02-19 00:00:00 | Tractor Supply | Heating |  |  |  |  |  |  | 6.19 | 6 |  |  |  | 2036-01-01 00:00:00
 |  | 2023-02-28 00:00:00 | Tractor Supply | Heating |  |  |  |  |  |  | 6.19 | 6 |  |  |  | 2037-01-01 00:00:00
 |  | 2023-03-01 00:00:00 | Delta Appliance | Cooking | 40 | 3 | 120 |  |  |  |  |  |  |  |  | 2038-01-01 00:00:00
 |  | 2023-03-05 00:00:00 | Tractor Supply | Heating |  |  |  |  |  |  | 6.19 | 6 |  |  |  | 2039-01-01 00:00:00
 |  | 2023-03-09 00:00:00 | Tractor Supply | Heating |  |  |  |  |  |  | 6.19 | 10 |  |  |  | 2040-01-01 00:00:00
 |  | 2023-09-19 00:00:00 | The [NAME] | Heating |  |  | 200 | 299 | 2 |  |  |  |  |  |  | 2041-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2042-01-01 00:00:00
Spreadsheet: 540523d1506727479-percentage-savings-formula-ivr-contain-savings-002-
Sheet: Sheet1

Total IVR Calls
22000000
IVR Contain Rate | 0.9 | 0.91 | 0.92 | 0.93 | 0.94
Contain Rate Incr | 0.01 | 0.02 | 0.03 | 0.04 | 0.05
Contained Calls
Savings
Spreadsheet: 53494d1253378219-static-multiple-criteria-lookup-staticlookupsample
Sheet: Tyre Purchase Report

Supplier | [NAME] | [NAME] | Date of Purchase | Issue Date | Vehicle Issued | [NAME] | Removal Date | Purpose for Removal
MRF | 9*18 | 251000 | 2009-09-01 00:00:00 | 2009-09-05 00:00:00 | 1815H/HR38 | Rear-Left-Inner |  | [NAME]
MRF | 9*18 | 261000 | 2009-09-02 00:00:00 | 2009-09-06 00:00:00 | 1515H/HR38 | Front-Left |  | Remoulding
MRF | 9*18 | 450000 | 2009-11-09 00:00:00 | 2009-11-11 00:00:00 | 1815H/HR38 | Rear-Left-Inner |  | Scrap
JK | 10*18 | 524000 | 2009-09-03 00:00:00 | 2009-09-05 00:00:00 | 1815H/HR38 | Front-Right
BRIDGESTONE | 10*18 | 452642 | 2009-12-12 00:00:00 | 2009-12-19 00:00:00 | 1815H/HR38 | Rear-Left-Inner
 |  |  |  |  |  |  | [NAME] "1815H/HR38" in F6 and the value at Tyre Maintenance Report!E2 changes from 450000 to 452642
 |  |  |  |  |  |  | 452642
 |  |  |  |  |  |  | But since it’s a serial no. I want it to remain the same as it was was inspected to be. I see a possible solution…
 |  |  |  |  |  |  | …by adding another criteria which checks the inspection date i.e. [NAME] Report!A2 and looks up for…
 |  |  |  |  |  |  | …the greatest date lesser than A2, which would always be 05-Sep in this database…
 |  |  |  |  |  |  | Also please let me know if theres any other way to keep the Serial in the TMR sheet Static
Spreadsheet: 746531d1630816133-find-2-largest-values-in-2-arrays-i-think-twooptions
Sheet: Sheet1

dog | cat | dog | cat | dog | cat | dog | cat | ☞ 2 row dataset |  | dog1 = largest # dog
1 | 7 | 9 | 2 | 3 | 8 | 4 | 6 |  |  | dog2 = 2nd largest # dog
 |  |  |  |  |  |  |  |  |  | cat1 = largest # cat
 |  |  |  |  |  |  |  | ☞ Expected Results |  | cat2 = 2nd largest # cat
 |  |  |  |  |  |  |  | Second option
Spreadsheet: 525514d1498752731-drop-down-list-based-on-the-given-file-how-to-create-such-helpful-and-neat-list-excel_forum_qus
Sheet: Accounts

Account List
You can track any number of real or virtual accounts. These accounts will show up in the Accounts
column in the Transactions worksheet.
Account |  | Goal | % | Cleared | Balance
Checking |  | 2000
Savings |  | 10000
BobsCard
JanesCard
 |  |  |  |  |  |  | ◄ [NAME] new rows above this one to add accounts
 |  |  |  | Total:
Spreadsheet: 840934d1693205239-sum-variable-periods-and-variable-dates-offset-sumifs-book1
Sheet: Monthly Three Way

Profit & Loss (A$000)
Month Ended: | 2022-07-01 00:00:00
Type A Sales | 368 | 375 | 422 | 456 | 524 | 784 | 540 | 357 | 435 | 499 | 423 | 325
Type B Sales | 299 | 345 | 412 | 534 | 641 | 311 | 148 | 278 | 368 | 590 | 412 | 604
Total Revenue
Cost of Goods Sold | -528 | -540 | -625.5 | -742.5 | -873.75 | -821.25 | -516 | -476.25 | -602.25 | -816.75 | -626.25 | -696.75
Gross Profit
Other Income
Overhead Expenses | -155.66962 | -162.5200510997818 | -164.1224724354036 | -163.4002264405237 | -162.4265274634182 | -188.8609310805818 | -175.9274510433455 | -204.9003787873455 | -177.6911575137455 | -183.0672103009455 | -166.3562152545455 | -315.2818555300364
EBITDA
 | Period |  | YTD
 | 3
BOARD REPORT | Mos Ending |  | Mos Ending
 | 2022-12-01 00:00:00
Type A Sales
Type B Sales
Total Revenue
Cost of Goods Sold
Gross Profit
Other Income
Overhead Expenses
EBITDA
Spreadsheet: 703815d1605186219-use-formulas-to-show-visibility-of-employees-shift-visibility-test-my-solution
Sheet: Final Table Manual

Data Entry | Sales | After Sales Care
 |  |  |  |  |  |  |  | Available