tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 52b8c8a0-13e4-4553-a000-fa53c749c1ef
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
 | 8501.0 Retail Trade, Australia
 | TABLE 16. Retail Turnover, Completely Enumerated sector: Australia
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
Turnover ;  Total CE and [NAME] ; |  |  | Original | [NAME] | 1994-04-01 00:00:00 | 2011-05-01 00:00:00 | 206 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ; |  |  | Seasonally Adjusted | A3350334L | 1994-04-01 00:00:00 | 2011-05-01 00:00:00 | 206 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ; |  |  | Trend | A3350340J | 1994-04-01 00:00:00 | 2011-05-01 00:00:00 | 206 | $ Millions | FLOW | Month | 1
% change from preceding month ;  Total CE and [NAME] ; |  |  | Original | A3350329V | 1994-04-01 00:00:00 | 2011-05-01 00:00:00 | 206 | Percent | PERCENT | Month | 1
% change from preceding month ;  Total CE and [NAME] ; |  |  | Seasonally Adjusted | A3350335R | 1994-04-01 00:00:00 | 2011-05-01 00:00:00 | 206 | Percent | PERCENT | Month | 1
% change from preceding month ;  Total CE and [NAME] ; |  |  | Trend | A3350341K | 1994-04-01 00:00:00 | 2011-05-01 00:00:00 | 206 | Percent | PERCENT | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 033fa80f-46b4-42cb-a5a1-6ed0ed896245
Sheet: Sheet1

 | Credit  Headcount At Census
 | MSJC District Total by Gender
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12 |  |  | AY12-13 |  |  | AY13-14
Gender | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12 | SU12 | FA12 | SP13 | SU13 | [NAME] | SP14
Male | 2035 | 5463 | 5555 | 2475 | 6240 | 6646 | 1507 | 7180 | 7155 | 932 | 6521 | 6641 | 158 | 6286 | 6465 | 639 | 5938 | 5777 | 135 | 6047 | 6041
Female | 3578 | 8879 | 8755 | 4217 | 9686 | 10144 | 2466 | 10431 | 10189 | 1261 | 9256 | 9195 | 62 | 8604 | 8872 | 831 | 8212 | 7910 | 84 | 8095 | 8073
Undeclared | 39 | 114 | 138 | 84 | 246 | 242 | 57 | 217 | 199 | 31 | 172 | 185 | 2 | 135 | 147 | 9 | 119 | 106 | 1 | 105 | 94
Term Total | 5652 | 14456 | 14448 | 6776 | 16172 | 17032 | 4030 | 17828 | 17543 | 2224 | 15949 | 16021 | 222 | 15025 | 15484 |  |  |  |  |  | 14208
Academic Year | 21297 |  |  | 24409 |  |  | 24067 |  |  | 21012 |  |  | 19534 |  |  | 17946 |  |  | 18180
% of Total | Credit Headcount % of Total
 | MSJC District Total by Gender
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12 |  |  | AY12-13 |  |  | AY13-14
Gender | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12 | SU12 | FA12 | SP13 | SU13 | [NAME] | SP14
Male | 0.3600495399858457 | 0.3779053680132817 | 0.3844822812846069 | 0.3652597402597403 | 0.3858520900321543 | 0.3902066697980273 | 0.3739454094292804 | 0.4027372672201032 | 0.4078549848942598 | 0.4190647482014389 | 0.4088657596087529 | 0.4145184445415392 | 0.7117117117117117 | 0.418369384359401 | 0.4175277706019117 | 0.4327248140635565 | 0.4163168205989365 | 0.4185726693688477 | 0.56 | 0.42 | 0.4252
Female | 0.6330502476999292 | 0.6142086330935251 | 0.6059662236987818 | 0.6223435655253837 | 0.5989364333415781 | 0.5955847815875999 | 0.6119106699751861 | 0.5850908682970608 | 0.5808014592715043 | 0.5669964028776978 | 0.5803498651953101 | 0.5739342113476062 | 0.2792792792792793 | 0.5726455906821963 | 0.5729785585120124 | 0.5611899932386748 | 0.5752868737755388 | 0.5736103068905617 | 0.44 | 0.57 | 0.5682
Undeclared | 0.006900212314225053 | 0.007885998893193137 | 0.009551495016611296 | 0.01239669421487603 | 0.01521147662626762 | 0.01420854861437294 | 0.0141439205955335 | 0.01217186448283599 | 0.01134355583423588 | 0.01393884892086331 | 0.01078437519593705 | 0.0115473441108545 | 0.009009009009009009 | 0.008985024958402662 | 0.00949367088607595 | 0.006085192697768763 | 0.008396305625524769 | 0.00781702374059062 | 0.003 | 0.007 | 0.007
Spreadsheet: 77c61704-4b64-4756-be64-046b6c163ec4
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FBIOT | Test | FBIOT | [NAME], H (Biotin) | [NAME] ([NAME]) | Microbiological Assay | Plain, Red-Top or serum gel tube: Red |  |  | 2 | mL | Draw blood in a plain, no additive red-top tube(s) or serum gel tube(s). Spin down and send 2 mL serum frozen in amber vial (Supply T192) to protect from light. | 1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | Pediatric	<12 yrs:	57.0 - 2460.2 pg/mL  Adult		>or=12 yrs:	221.0 - 3004.0 pg/mL  Test Performed by:	Cambridge Biomedical Inc. 			1320 Soldiers Field Rd 			Boston, MA 02135 | Varies | 1 - 19 days | 3 - 23 days | 1 | 84591 |  |  |  |  | Cambridge Biomedical Inc.
FBIOT | [NAME] | SERUM | Serum |  |  |  | Frozen | 14 days
FBIOT | Result | Z2042 | [NAME] ([NAME]) | [NAME] ([NAME]) | Numeric |  |  |  |  | pg/mL |  |  |  |  |  |  |  |  |  | 34398-8
Spreadsheet: 228973d1366272719-how-to-find-a-cell-and-copy-the-below-one-example
Sheet: Sheet1

Management of items
Name | Item | Quantity | Data of order | Data of delivery | Price | PriceXQuantity | Remarks
[NAME]
 | Hat | 1 | 2013-02-04 00:00:00 | 2013-10-04 00:00:00
 | Jacket | 1 | 2013-05-04 00:00:00
 | Gloves | 3 | 2013-05-04 00:00:00
 | Jeans | 5
 | Socks | 3
 | Jacket | 5
 |  | 5
Ewelina
 | Hat | 1 | 2013-02-04 00:00:00 | 2013-10-04 00:00:00
 | Jacket | 1 | 2013-05-04 00:00:00
 | Gloves | 3 | 2013-05-04 00:00:00
 | Bla bla
List of the prices
Gloves | Hat | Jacket | Boots | Jeans | Pants | Wallet | T-Shirt
5 | 4.5 | 25 | 50 | 25 | 15 | 25 | 15
Bla bla | Bla bla | Socks
20 | 10 | 40
Resume
Total amount | Hat | Chaqueta | [NAME]
 | Total quantity | Total quantity | Total quantity
 | Total amount | Total amount | Total amount
Spreadsheet: 03113223-47e5-4817-83e2-bf23f14917a6
Sheet: Moisture

moisture content
 | [NAME] dish | dry wt +dish | dish |  | dry [NAME] | [NAME] | solids | % solids | %moisture
batch 1 |  | 51 | 49.9
batch 1 |  | 51.2 | 50.1
batch 2 |  | 51.1 | 49.9
batch 2 |  | 51.1 | 49.9
batch 3 |  | 51.2 | 49.9
batch 4 | 73.9 | 48.8 | 47.7
batch 5 |  | 49.1 | 47.7
2014-06-12 00:00:00
batch 6 |  | 52.5619 | 50.82
starch test |  |  |  |  | 0.6 | 10 |  |  |  |  | mon
 | 59.4 | 43 | 42 |  |  |  |  |  |  |  | fri
 | 73.9 | 48.8 | 47.7
 |  | 1.6 | 1.3
Confirmation of moisture content for Starch
DAY 6 results
wet samples
 |  | 1.31 | 1.29
 |  | 1.32 | 1.29
 |  | 1.33 | 1.29
dry samples
 |  | 1.48 | 1.29
 |  | 1.48 | 1.29
 |  | 1.47 | 1.29
DDW | 2.4 | 2.3 | 1.3
starch dry
 |  | 1.3897 | 1.2878 |  |  | 0.2
 |  | 1.3899 | 1.2878 |  |  | 0.2
 |  | 1.3891 | 1.2878 |  |  | 0.2
wet starch
 | 1.4042 | 1.3062 | 1.2878
 | 1.3857 | 1.3316 | 1.2878
 | 1.3795 | 1.3003 | 1.2878
2014-05-11 00:00:00
Duckweed | 1.759 | 1.4036 | 1.28315
 | 2.912 | 1.497 | 1.28315
starch
1 |  | 1.377 | 1.2812
2 |  | 1.3823 | 1.2851
2014-05-15 00:00:00
starch
1 | 1.4196 | 1.3455 | 1.3186
2 | 1.4492 | 1.3482 | 1.3166
duckweed
1 | 31.2349 | 20.9794 | 20.3961
2 | 41.8223 | 30.819 | 30.1873
2014-06-19 00:00:00
duckweed (day 1) | 402.17 | 220.43 | 212.34
duckweed(day 5) | 326.57 | 262.89 | 260.25
2014-06-24 00:00:00
duckweed (day 1) | 534.29 | 268.54 | 257.92
duckweed (day 8) | 290.78 | 214.98 | 212.45
day 8 after grinding | 16.8 | 1.9163 | 1.3292
2014-06-27 00:00:00
duckweed (day 1) | 440.1 | 264.18 | 258.23
starch
1 | 1.4427 | 1.362 | 1.3333
2 | 1.4338 | 1.3554 | 1.3246
3 | 1.4386 | 1.3554 | 1.3299
cooked duckweed solids
1 | 1.7852 | 1.3254 | 1.3174
2014-07-24 00:00:00
 | [NAME] dish | dry wt +dish | dish |  | dry [NAME] | [NAME] | solids | % solids | %moisture
woffia 1 | 1.5831 | 1.3263 | 1.3168
woffia 2 | 1.9258 | 1.3491 | 1.3278
[NAME] 1 | 5.1385 | 1.4759 | 1.3176
[NAME] 2 | 6.06 | 1.5149 | 1.3266
2014-08-01 00:00:00
starch | 1.4351 | 1.3512 | 1.3227
2 | 1.4381 | 1.3522 | 1.3218
old starch | 1.4359 | 1.3487 | 1.3243
wet DW | 6.1719 | 1.5178 | 1.3214
2 | 5.7536 | 1.505 | 1.3254
3 | 4.2648 | 1.4418 | 1.3231
2014-08-08 00:00:00
air dried DW | 1.7251 | 1.6893 | 1.3213
2 | 1.8021 | 1.7619 | 1.3263
3 | 1.9016 | 1.8473 | 1.3219
starch(dry 100mg) | 1.4315 | 1.4191 | 1.322
 | 1.3942 | 1.3866 | 1.32
2014-09-02 00:00:00
oven dried | 1.5888 | 1.5694 | 1.3289
 | 1.5886 | 1.568 | 1.3303
air dried
 | 1.4804 | 1.4665 | 1.3216
 | 1.3895 | 1.3835 | 1.3207
starch
 | 1.384 | 1.3757 | 1.3195
 | 1.5064 | 1.4845 | 1.3316
wet Duckweed
 | 129.51 | 53.16 | 49.71 |  |  |  |  |  |  | 95.68
2014-09-14 00:00:00
W1 | 11.7016 | 2.5917 | 2.1646
[NAME] | 7.558 | 2.4492 | 2.2193
2014-10-17 00:00:00
starch
1 | 2.1907 | 2.1855 | 2.1398
2 | 2.279 | 2.2734 | 2.2291
3 | 2.2324 | 2.227 | 2.1806
Wet DW
1 | 3.7505 | 2.2441 | 2.177
2 | 3.9619 | 2.2808 | 2.2013
3 | 3.5149 | 2.2377 | 2.1815
Air Dry  DW
1 | 2.1871 | 2.1777 | 2.1117
2 | 2.2634 | 2.2549 | 2.1908
3 | 2.203 | 2.1986 | 2.1587
Oven dry DW
1 | 2.3072 | 2.2992 | 2.1581
2 | 2.2327 | 2.227 | 2.1254
3 | 2.2881 | 2.2777 | 2.1225
Spreadsheet: 449b6cc8-2cd6-42f2-8ea0-9b8300894c15
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
9862 | Test | 9862 | [NAME] Stain for Calcium | [NAME] ST for Calcium | Includes pathology consultation charged separately. | Formalin-fixed, paraffin-embedded tumor tissue block. Include 1 H & E slide: FFPTHE |  |  |  | Varies | Container/Tube:  Preferred: Formalin-fixed, paraffin-embedded tissue block Acceptable: Tissue in formalin Collection Instructions: Include 1 hematoxylin-and-eosin stained slide. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | The laboratory will provide a pathology consultation and stained slide. | Monday through Friday 7 a.m. | 2 days | 5 days | 1 | 88313 |  |  |  |  | Rochester
9862 | [NAME] | MIXED | Mixed |  |  |  | Ambient
9862 | Result | 9862 | [NAME] ST for Calcium | [NAME] ST for Calcium |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10746-6
Spreadsheet: 838593d1691157645-maximum-drawdown-in-percentage-max-dd
Sheet: Sheet1

Total R2 | [NAME] DD%
-0.005
-0.01
0
0.01
0.005
0.015
0.025
0.035
0.04500000000000001
0.02
0.01
Spreadsheet: 267834d1380226256-detect-what-comes-after-two-identical-cells-with-a-couple-of-conditions-twoidenticalcells-solved-2-
Sheet: Sheet3

 | 15 | partner
 | 26 | partner
 | 7 | Apple
 | 4 | Partner
 | 25 | Partner
 | 31 | Apple
 | 6 | partner
 | 22 | partner
 | 24 | Sale
 | 16 | partner
 | 35 | partner
Spreadsheet: 106678d1303904460-dates-account-30-60-days-over-due-sample-workbook
Sheet: New 

Today | Today + 30 Days | Today + 60 Days | Today + 90 Days | Today + 120 Days
Date | Invoice Details | Your Ref | Debit | Date of Receipt | Credit | Balance
2010-12-01 00:00:00 | xyzxxx | abcdefg | 25 |  | 25
2011-01-01 00:00:00 | xyzxxx | abcdefg | 25
2011-02-01 00:00:00 | xyzxxx | abcdefg | 25
2011-03-27 00:00:00 | xyzxxx | abcdefg | 25 |  | 0
Total
Total Amount Due
Aging | 30 Days | 60 days | 90 days | 120+
Spreadsheet: 771618d1646759137-conditional-formatting-compare-2-cells-on-diff-tabs-conditional-formatting_working-copy
Sheet: 2022

 | ACCOUNT | IT | [NAME] | ENG | [NAME] | TECH | [NAME]
 | Test Account 1 | 5 | 6 | 200 | 415 | 10 | 13
 | Test Account 2 | 5 | 4 | 4 | 368 | 6 | 1
 | Test Account 3 | 2 | 4 | 6 | 46 | 46 | 0
 | Test Account 4 | 2 | 8 | 51 | 174 | 5 | 25
 | Test Account 5 | 3 | 5 | 50 | 46 | 142 | 218
Spreadsheet: 854410d1704295902-get-row-number-from-maxifs-for-index-and-match-example
Sheet: Sheet1

Dato | Sted | Vindretning | Vindhastighet
2020-06-30 00:00:00 | Kjevik | 205 | 8.8 | 2020-06-30 00:00:00
2020-06-30 00:00:00 | Kjevik | 214 | 8.6 | kjevik
2020-06-30 00:00:00 | Kjevik | 207 | 5.4
2020-06-30 00:00:00 | Kjevik | 53 | 4.2 | another option |  | 11.6
2020-06-30 00:00:00 | Kjevik | #NULL! | 4.3
2020-06-30 00:00:00 | Kjevik | 199 | 6.5
2020-06-30 00:00:00 | Kjevik | #NULL! | 5.8
2020-06-30 00:00:00 | Kjevik | 119 | 2.9
2020-06-30 00:00:00 | Kjevik | 44 | 2.2
2020-06-30 00:00:00 | Kjevik | 303 | 2.4
2020-06-30 00:00:00 | Kjevik | 39 | 2.9
2020-06-30 00:00:00 | Kjevik | 55 | 3.2
2020-06-30 00:00:00 | Kjevik | 190 | 4.3
2020-06-30 00:00:00 | Kjevik | 219 | 7.5
2020-06-30 00:00:00 | Kjevik | 178 | 8.5
2020-06-30 00:00:00 | Kjevik | 188 | 7.4
2020-06-30 00:00:00 | Kjevik | 202 | 6.2
2020-06-30 00:00:00 | Kjevik | 247 | 7.4
2020-06-30 00:00:00 | Kjevik | #NULL! | 8.5
2020-06-30 00:00:00 | Kjevik | 274 | 9.5
2020-06-30 00:00:00 | Kjevik | 268 | 11.6
2020-06-30 00:00:00 | Kjevik | 266 | 8
2020-06-30 00:00:00 | Kjevik | 262 | 6.8
2020-06-30 00:00:00 | Kjevik | #NULL! | 5
2020-07-01 00:00:00 | Kjevik | 274 | 5
2020-07-01 00:00:00 | Kjevik | 315 | 4.4
2020-07-01 00:00:00 | Kjevik | 251 | 7.4
2020-07-01 00:00:00 | Kjevik | #NULL! | 6.6
2020-07-01 00:00:00 | Kjevik | 307 | 5.8
2020-07-01 00:00:00 | Kjevik | 257 | 5
2020-07-01 00:00:00 | Kjevik | 273 | 5.5
2020-07-01 00:00:00 | Kjevik | 264 | 9.3
2020-07-01 00:00:00 | Kjevik | 270 | 9.7
2020-07-01 00:00:00 | Kjevik | 272 | 10.2
2020-07-01 00:00:00 | Kjevik | 240 | 8.5
2020-07-01 00:00:00 | Kjevik | 250 | 8
2020-07-01 00:00:00 | Kjevik | 233 | 8.6
2020-07-01 00:00:00 | Kjevik | 267 | 9.5
Spreadsheet: 694272d1599494602-how-to-use-vlookup-with-changing-table-array-sample-1-
Sheet: Sheet1

Last year | 2 | 1
Code | A | B
BE
BG
CZ
DK
DE
EE
Spreadsheet: 781181d1653048503-formula-that-check-and-give-me-results-like-green-ok-red-not-ok-book1
Sheet: users

username | name | surname | groups | check
123456 | [NAME] | doe | dell | OK [NAME]
123456 | [NAME] | doe | hp
123456 | [NAME] | doe | lenovo
123456 | [NAME] | doe | ios
123456 | [NAME] | doe | think
123456 | [NAME] | doe | nike
123456 | [NAME] | doe | adidas
123456 | [NAME] | doe | primark
2494144 | mila | [NAME] | ios | OK KING
2494144 | mila | [NAME] | monitor
2494144 | mila | [NAME] | mac
2494144 | mila | [NAME] | dell
2494144 | mila | [NAME] | bus
44895 | [NAME] | russell | boat | NOT OKAY QUEEN
44895 | [NAME] | russell | ios
44895 | [NAME] | russell | lenovo
44895 | [NAME] | russell | dell
44895 | [NAME] | russell | keyboard
44895 | [NAME] | russell | pad
44895 | [NAME] | russell | ice
44895 | [NAME] | russell | country
44895 | [NAME] | russell | mac
Spreadsheet: 160292d1339030738-range-lookup-for-x-and-y-sumproduct-index-work-question
Sheet: Sheet1

 |  |  |  |  |  | (0,2) |  | (1,2) |  | (2,2)
 |  |  |  |  |  | (0,1) |  | (1,1)
 |  |  |  |  |  | (0,0) |  |  |  | (2,0)
 |  |  |  | Limits |  |  |  | (1,0)
 |  | Square | x min | x [NAME] | y min | y [NAME]
 |  | 1 | 0 | 1 | 1 | 2
 |  | 2 | 1 | 2 | 1 | 2
 |  | 3 | 0 | 1 | 0 | 1
 |  | 4 | 1 | 2 | 0 | 1
 |  | Point : | (1.5,1.5) is in quadrant 2. How can we get excel to write this?
 |  |  | I have a set of say, these points:
 |  |  | x | y |  | Square?
 |  |  | 1.3 | 1.8 |  | ? | <---- what formula or macro can we use?
 |  |  | 0.5 | 1.4 |  | ?
 |  |  | 1.7 | 0.3 |  | ?
Spreadsheet: a4128ab7-dec5-44f4-a296-8c79991ab431
Sheet: APRIL3-15

RGE Water Quality April 3- 15, 2014
Date Time | Temp | Sal | pH | [NAME]
M/D/Y HH:MM:SS | F | ppt |  | mg/L
2014-04-03 01:00:33 | 59.63 | 0.09 | 7.08 | 9.29
2014-04-03 07:00:33 | 59.23 | 0.09 | 7.38 | 9.3
2014-04-03 13:00:33 | 59.05 | 0.09 | 7.66 | 10.05
2014-04-03 19:00:33 | 59.87 | 0.09 | 7.08 | 9.33
2014-04-04 01:00:33 | 59.82 | 0.09 | 7.05 | 8.99
2014-04-04 07:00:33 | 59.27 | 0.09 | 7.38 | 9.22
2014-04-04 13:00:33 | 58.65 | 0.09 | 7.65 | 9.27
2014-04-04 19:00:33 | 58.61 | 0.09 | 7.08 | 9
2014-04-05 01:00:33 | 59.14 | 0.09 | 7.33 | 8.87
2014-04-05 07:00:33 | 58.56 | 0.09 | 7.38 | 9
2014-04-05 13:00:00 | 59.57 | 0.09 | 7.67 | 9.24
2014-04-06 13:00:33 | 60.05 | 0.09 | 7.79 | 9.9
2014-04-07 13:00:33 | 59.66 | 0.09 | 7.78 | 9.07
2014-04-07 19:00:33 | 60.17 | 0.09 | 7.07 | 8.67
2014-04-08 01:00:33 | 58.21 | 0.08 | 7.3 | 8.78
2014-04-08 07:00:33 | 57.39 | 0.07 | 7.23 | 8.58
2014-04-08 13:00:33 | 58.81 | 0.07 | 7.84 | 9.83
2014-04-09 13:00:33 | 61.06 | 0.09 | 7.81 | 9.57
2014-04-10 13:00:33 | 61.01 | 0.09 | 7.86 | 9.67
2014-04-11 13:00:33 | 61.41 | 0.09 | 7.76 | 9.42
2014-04-11 19:00:33 | 61.66 | 0.09 | 7.27 | 9.36
2014-04-12 01:00:33 | 61.87 | 0.1 | 7.43 | 8.92
2014-04-12 07:00:33 | 61.38 | 0.1 | 7.4 | 8.66
2014-04-12 13:00:33 | 62.06 | 0.09 | 7.6 | 9.18
2014-04-12 19:00:33 | 63.17 | 0.1 | 7.25 | 8.9
2014-04-13 01:00:33 | 62.19 | 0.1 | 7.43 | 9.01
2014-04-13 07:00:33 | 61.86 | 0.1 | 7.38 | 8.65
2014-04-13 13:00:33 | 61.71 | 0.09 | 7.6 | 9.06
2014-04-13 19:00:33 | 63.15 | 0.1 | 7.64 | 8.82
2014-04-14 01:00:33 | 61.59 | 0.09 | 7.62 | 8.64
2014-04-14 07:00:33 | 61.7 | 0.1 | 7.6 | 8.46
2014-04-14 13:00:33 | 61.83 | 0.09 | 7.56 | 8.29
2014-04-14 19:00:33 | 62.83 | 0.09 | 7.21 | 8.69
2014-04-15 01:00:33 | 62.64 | 0.09 | 7.18 | 8.58
2014-04-15 07:00:33 | 61.84 | 0.09 | 7.41 | 8.44
2014-04-15 13:00:00 | 60.49 | 0.09 | 7.65 | 8.89
Average Temp: | 60.58722222222222
Maximum Temp: | 63.17
Minimum Temp: | 57.39
Average pH: | 7.455833333333334
Maximum pH: | 7.86
Minimum pH: | 7.05
Average [NAME] (mg/L) | 9.044444444444443
Spreadsheet: 682483d1592137782-find-date-of-which-employee-satisfies-two-conditions-sample-2-3-
Sheet: BONOUS

CODE | NET LIVES | NET FP |  | DATE(YYYYMMDD) |  | EXPECTED |  |  |  | CHANGE DATE
 |  |  | Sum of 6 unique orders | Date that meeting 2 conditions | sum of orders meeting 2 criteria |  |  |  |  | AS REQUIRED
192 |  |  |  |  |  | 20190829 |  |  |  | 20190401 | 20200331
727 |  |  |  |  |  | 20200128
888 |  |  |  |  |  | 20200528
 |  |  |  |  |  |  |  |  |  | PROJECT : IF AN EMPLOYEE (SHOWN IN SHEET NBD COLUMN "EM-CODE) COMPLETES SIX UNIQUE ORDERS(UNIQUE ORDER MEANS: ' ORDER-NO' WITH UNIQUE' DOB')
 |  |  |  |  |  |  |  |  |  | AND SUM OF ALL ORDER PREM IS >=50000 IN GIVEN DATE RANGE .EMPLOYEE IS ELIGIBLW FOR BONUS FROM DATE ON WHICH HE SATISFIES TWO CONDITIONS.
 |  |  |  |  |  |  |  |  |  | SOLUTION REQUIRED : I WANT TO DISPLAY DATE IN COL. [NAME] YYYYMMDD FORMAT(AS SHOWN IN COL. 'C' OF 'NBD' SHEET) ON WHICH EMPLOYEE SATISFY ABOVE MENTIONED
 |  |  |  |  |  |  |  |  |  | TWO CONDITIONS. SO THAT I CAN CALCULATE BONOUS FROM THAT DATE.
 |  |  |  |  |  |  |  |  |  | EXPECTED RESULT IS GIVEN IN COL. E
 |  |  |  |  |  |  |  |  |  | WE HAVE TO FIND  DATE ON WHICH EMPLOYEE SATISFY BOTH CONDITIONS.
 |  |  |  |  |  |  |  |  |  | CONDITION  1)     6 ORDERS WITH UNIQUE DOB AND
 |  |  |  |  |  |  |  |  |  | CONDITION 2 )  SUM OF PREM. >=50000(INCLUDES DUPLICATE DOB RECORD)
Spreadsheet: 211928d1359992347-pull-data-based-on-day-of-week-from-another-workbook-for-previous-three-weeks-salesreport2013
Sheet: 0111

 | Date: | 2013-01-11 00:00:00
 | Day
 | Time | Trans. | Total Sales | Avg. Sales
 | 09:00:00 | 0 | 0
 | 10:00:00 | 7 | 56.06
 | 11:00:00 | 69 | 419.32
 | 12:00:00 | 103 | 623.27
 | 13:00:00 | 67 | 358.25
 | 14:00:00 | 39 | 177.12
 | 15:00:00 | 46 | 257.65
 | 16:00:00 | 28 | 178.33
 | 17:00:00 | 50 | 379.73
 | 18:00:00 | 56 | 414.74
 | 19:00:00 | 49 | 366.27
 | 20:00:00 | 31 | 257.33
 | 21:00:00 | 31 | 181.01
 | 22:00:00 | 39 | 228.63
 | 23:00:00 | 23 | 178.92
 | 1900-01-01 00:00:00 | 18 | 128.08
 | 1900-01-01 01:00:00 | 10 | 61.59
 | 1900-01-01 02:00:00 | 12 | 126.9
 | 1900-01-01 03:00:00 | 5 | 41.06
 | 04:00:00 | 0 | 0
 | Total
Spreadsheet: 875078d1721650165-compile-accumulated-survey-results-survey-data-bsb-
Sheet: Sheet1

 | Year |  |  | Very Satisfied | Satisfied | Uncertain | Dissatisfied | Very Dissatisfied
 | 2024 |  | Question 1
 |  |  | Question 2
 | Gender |  | Question 3
 | All |  | Question 4
 |  |  | Question 5
 | Departments |  | Question 6
 | All
 | Desingation
 | All
 | Experience
 | All
 | Qualification
 | All |  | Final Outcome
 |  |  |  | Very Satisfied | Satisfied | Uncertain | Dissatisfied | Very Dissatisfied
 |  |  | Question 1
 |  |  | Question 2
 |  |  | Question 3
 |  |  | Question 4
 |  |  | Question 5
 |  |  | Question 6
Spreadsheet: 156545d1337343154-excel-2007-triplicate-values-to-pick-up-book1
Sheet: Sheet1

SA1 | SA2 | SA3 | Result
1 | 2 | 12 | 1
2 | 10 | 2 | 2
3 | 8 | 4 | 4
4 | 10 | 11 | 11
5 | 4 | 1
6 | 1
7 | 11
8
9
10
11
Spreadsheet: 00b1ceb6-866d-43a5-9f36-4fbf8b127fe4
Sheet: 22

 |  | Net Notional Outstanding
Product Type |  | Cleared** | Uncleared
Total Metals* | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Energy | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Agricultural | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Index | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Other*** | Exotic
 | Option
 | Spot/Forward
 | Swap
TOTAL |  | N/A**** | N/A
Estimated net notional amount outstanding, December 7 weekly snapshot, by product type and cleared status (millions of USD), all participant types, tenors, and currencies.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***Environment, Freight, Multi-Commodity Exotic
****N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 225769d1365103672-creating-a-contact-list-with-dropdowns-lookups-for-multiple-offices-contact-module2
Sheet: Contact List

Lookup | Market Area | Department | Name | Position | Phone | E-Mail | Notes
 | 1 | Customer Service | [NAME] | CDR | [PHONE] | 123@.com
 | 1 | Customer Service | Lindsey | ICR | [PHONE] | 123@.com
 | 1 | Customer Service | Danna | CSM | [PHONE] | 123@.com
 | 1 | Customer Service | [NAME] | CEM | [PHONE] | 123@.com
Spreadsheet: 721135d1614517787-find-last-and-first-non-zero-value-for-particular-lookup-criteria-book3
Sheet: Sheet1

Date | Product | Value
2020-01-01 00:00:00 | Ship | 0
2020-01-01 00:00:00 | Car | 50
2020-01-01 00:00:00 | Train | 0
2020-01-01 00:00:00 | Boat | 0
2020-01-01 00:00:00 | Van | 0
2020-01-01 00:00:00 | Trailer | 0
2020-01-01 00:00:00 | Motocycle | 30
2020-01-01 00:00:00 | Plain | 40
2020-02-01 00:00:00 | Ship | 0
2020-02-01 00:00:00 | Car | 20
2020-02-01 00:00:00 | Train | 30
2020-02-01 00:00:00 | Boat | 0
2020-02-01 00:00:00 | Van | 0
2020-02-01 00:00:00 | Trailer | 20
2020-02-01 00:00:00 | Plain | 0
2020-03-01 00:00:00 | Ship | 30
2020-03-01 00:00:00 | Car | 0
2020-03-01 00:00:00 | Train | 0
2020-03-01 00:00:00 | Boat | 0
2020-03-01 00:00:00 | Van | 10
2020-03-01 00:00:00 | Trailer | 40
2020-03-01 00:00:00 | Motocycle | 0
2020-03-01 00:00:00 | Plain | 10
2020-04-01 00:00:00 | Ship | 20
2020-04-01 00:00:00 | Car | 0
2020-04-01 00:00:00 | Train | 0
2020-04-01 00:00:00 | Boat | 0
2020-04-01 00:00:00 | Van | 0
2020-04-01 00:00:00 | Trailer | 0
2020-04-01 00:00:00 | Motocycle | 20
2020-04-01 00:00:00 | Plain | 0
 |  |  |  | Date of last non zero value
LAST non zero value | Ship
 | Car
 | Train
 | Boat
 | Van
 | Trailer
 | Motocycle
 | Plain
 |  |  |  | Date of first non zero value
FIRST non zero value | Ship
 | Car
 | Train
 | Boat
 | Van
 | Trailer
 | Motocycle
 | Plain
 |  | INDEX(A$2:A32;MATCH(TRUE;INDEX((A2:A32<>0);0);0))