tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 31335d1227134923-option-buttons-selecting-and-using-rows-optionbuttonscontrollingrows
Sheet: Sheet1

 |  |  |  |  | Option button link cell
 | Master Product Category | (result from row to go here) | Master Product range opt. 1 | (result from row to go here) | 5 |  | Spinner controlling option
 | Master [NAME] | (result from row to go here) | Master Product range opt. 2 | (result from row to go here) |  |  | button selection
 |  | Product Category | Product Range | Product range option #1 | Product range option #2
option row 1 |  | Drop Down List | [NAME] Down 2 | [NAME] down 3 | Dependant drop down 4
option row 2 |  | Drop Down List | [NAME] Down 2 | [NAME] down 3 | Dependant drop down 4
option row 3 |  | Drop Down List | [NAME] Down 2 | [NAME] down 3 | Dependant drop down 4
option row 4 |  | Drop Down List | [NAME] Down 2 | [NAME] down 3 | Dependant drop down 4
option row 5 |  | Drop Down List | [NAME] Down 2 | [NAME] down 3 | Dependant drop down 4
option row 6 |  | Drop Down List | [NAME] Down 2 | [NAME] down 3 | Dependant drop down 4
option row 7 |  | Drop Down List | [NAME] Down 2 | [NAME] down 3 | Dependant drop down 4
option row 8 |  | Drop Down List | [NAME] Down 2 | [NAME] down 3 | Dependant drop down 4
option row 9 |  | Drop Down List | [NAME] Down 2 | [NAME] down 3 | Dependant drop down 4
option row 10 |  | Drop Down List | [NAME] Down 2 | [NAME] down 3 | Dependant drop down 4
 |  |  | Quick entry section for site environment if required
 |  |  | 10 rows of identical drop downs
Spreadsheet: 04e52890-e2d8-4956-9f12-b8a9ed4d77ac
Sheet: Sheet1

Parameters or Test Packages                                      (See Table A - Constituent List, Methods, [NAME], etc.) | Annual Quantity (Estimated) | Price ($) |  | Turn Around Multipliers |  |  | Sub- Contract Lab | Comments
 |  | Each | Extended | 24-hour | 48-hour | 5-day
1. Metals Individual Analytes
EPA 200.8 - Total | 24
EPA 200.8 - Dissolved | 24
EPA 200.7 - Total | 24
EPA 200.7 [NAME] | 24
EPA 218.6 - Hexavalent Chromium | 4
2. Metals Sample Preparation per Sample
Digestion | as applicable
Filtering | as applicable
3. Mercury and [NAME]
EPA 245.1 - Total Mercury, Low Level | 24
EPA 1631 - Total mercury, Trace Level | 24
EPA 1630 - Methyl Mercury, Trace Level | 24
4. General [NAME]
TKN as N | 16*
Nitrate as N | 24
Nitrite as N | 24
Chloride | 24
Fluoride | 24
Sulfate | 16*
Surfactants (MBAS) | 16*
Hardness by Calculation | 16*
Oil and Grease, EPA 1664 | 16*
Total Phophorus, as P | 16*
Cyanide, Total | 24
Total Dissolved Solids | 16*
Total organic Carbon (TOC) | 16*
6. General Chemistry Packages
a. General Mineral Package - includes total anion,  total cation and ion-balance. Please submit supplemental sheet for parameters that are included in this package. | 24
b. Nutrient Package - Ammonia as N, TKN, total organic nitrogen (TON), nitrate as N, nitrite as N and Total Phosphorus. | 24
c. General Anion - flouride, chloride, sulfate, nitrate as N, nitrite as N, orthophosphate. Please provide list of method(s) for each anion. | 24
7.  Organics
EPA 515.4 Chlorophenoxy Herbicieds | 16*
EPA 525.2 Semivolatiles by GCMS | 16*
EPA 531.2 Aldicarbs | 16*
EPA 547 Glyphosate | 16*
EPA 549.2 Diquat and Paraquat | 16*
EPA 551.1 EDB/DBCP/HAN | 16*
EPA 608 - OC Pesticides with PCBs | 2
EPA 614 Porganophaophorous Pesticides | 16*
EPA 624 - VOCs (full list) | 2
PA 624, THM - (Trihalomethanes only), includes Bromodichlormethane, bromoform, chloroform and dibromochloromethane. | 24
EPA 625 - SVOs (full list) with PAHs | 2
EPA 610 - PAHs only | 16*
EPA 625 - SOVs (full list, without PAHs) | 16*
8. Miscellaneous Tests
Tributyltin | 16*
Asbestos | 16*
9. Biosolids
CAM 17 Metals TTLC | 8
Cam 17 Metals STLC | 8
EPA 7471A - Mercury, Total | 8
EPA 8081 | 8
EPA 8082 | 8
EPA 8260B | 8
EPA 8270 | 8
EPA 9012A - Cyanide | 8
 | Extended Grand Total:
 |  |  | Transfer Extended Grand Total amount to Invitation For Bid and Award (Formal) document
* = Tests performed in third year of NPDES permit
Spreadsheet: 274173d1383041263-complex-autofill-patterns-id-contract-file-tracker-sample-2
Sheet: Purchase Tracker

 |  |  | Master [NAME]
Contract Work Tracker |  |  |  |  |  |  |  |  |  | Monthly Contract Overview
Date | Supplier | Type | Reference | Notes | Net Value (no VAT) | VAT | Total |  |  | Month | Supplies | Office | Wages | Fuel | IT | Vehicles | Training | Memberships | Tools | Workwear | Entertaining | Travel | Total
 |  |  |  |  |  |  |  |  |  | 2013-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2013-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2013-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2013-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2013-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2013-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2013-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2013-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2013-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2013-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2013-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2013-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2014-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2014-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2014-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2014-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2014-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2014-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2014-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2014-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2014-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2014-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2014-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2014-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2015-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2015-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2015-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2015-04-01 00:00:00
Spreadsheet: 847781d1698657584-single-dynamic-function-for-sumproduct-sumpro
Sheet: test

Name |  |  | DataX
Boll
Apple
Orange
Guava
Pasta
Lolliop
[NAME]
Zone
Litichi
[NAME]
Wole
Rispary
Data | MX |  | Boll | Apple | Orange | Guava | Pasta | Lolliop | [NAME] | Zone | Litichi | [NAME] | Wole | Rispary
Amazon | 21.202158938466 |  |  |  | 12 |  |  |  | 2.1
Filipkart | 21.6 |  |  |  | 14.5
On the bay | 63.44 |  |  |  | 63.6 |  |  |  | 3.2
Google | 63 |  |  | 0.26 | 99 | 2.5 |  |  | 44 |  | 6.6 | 1.48
Github | 24 |  |  |  | 45 | 3.6 | 6.6 | 2.6 |  | 98 | 1.23 | 7.26
Hotmail | 66 |  |  |  |  |  | 3.25
Yahoo | 0
Tesla | 34 |  |  | 0.94 | 8.46 | 2.8 |  |  |  |  | 64 | 3.11
Gokul | 11.1 |  |  |  | 12.45 |  |  |  |  |  |  |  | 4.7
Mahalabr | 63 |  |  |  | 1.98
Spreadsheet: 863113d1710675336-extracting-unique-data-from-repeating-parameters-in-excel-dynamic-approach-needed-extracting-unique-data_nil
Sheet: Sheet1

a1 | b1 | 10
a1 | b1 | 15 |  |  |  |  |  | AVERAGE | Median | SD
a1 | b2 | 20 |  | b1 | 10 | 15 | 0 | 12.5 | 12.5 | 3.535533905932738
a2 | b1 | 25 | a1 | b2 | 20 | 0 | 0 | 20 | 20 | 0
a2 | b1 | 30 | a2 | b1 | 25 | 30 | 35 | 30 | 30 | 5
a2 | b1 | 35 | a2 | b2 | 40 | 45 | 0 | 42.5 | 42.5 | 3.535533905932738
a2 | b2 | 40 | a2 | b3 | 50 | 55 | 60 | 55 | 55 | 5
a2 | b2 | 45
a2 | b3 | 50 | Code -1 for |  |  | Code -2 for |  |  |  | Code -3 for calculating
a2 | b3 | 55 | Unique values |  |  | extracting data |  |  |  | AVERAGE | Median | SD
a2 | b3 | 60 | a1 | b1 |  | 10 | 15 | 0 |  | 12.5 | 12.5 | 3.535533905932738
 |  |  | a1 | b2 |  | 20 | 0 | 0 |  | 20 | 20 | 0
 |  |  | a2 | b1 |  | 25 | 30 | 35 |  | 30 | 30 | 5
 |  |  | a2 | b2 |  | 40 | 45 | 0 |  | 42.5 | 42.5 | 3.535533905932738
 |  |  | a2 | b3 |  | 50 | 55 | 60 |  | 55 | 55 | 5
Spreadsheet: 768264d1644911562-trying-to-look-up-and-filter-data-book2
Sheet: Sheet2

KROK050
Thing 1 | Thing 2 | Thing 3 | Thing 4 | Thing 5 | Thing 6 | Thing 7
Spreadsheet: 812052d1672930963-formula-to-choose-other-formulas-to-use-based-on-condition-sample
Sheet: Sheet1

sample descriptions | formula outcome |  | list of fill levels
Skin Essentials Advanced Action Plumping Lip Cream 15ml | 15 ml |  | 15
Skin Essentials Advanced Action Plumping Lip Cream 15 mililiters | 15 ml |  | 50
Pre cleanse & make up remover 500ml | 500 ml |  | 30
Skin Protector SPF30 Age Aware Primer 30ml (Uncartoned) | 30 ml |  | 150
Hydrating beauty mist 50ml | 50 ml |  | 200
Hydrating Beauty Mist 50g (Carton & Cello Wrap) | 50 g |  | …
Hydrating [NAME] 150g | 150 g
Eye Cream 15ml Cello Wrap | 15 ml
Age Protect Skin Clear Cleanser 200ml | 200 ml
Age Defend Conditioning Cleanser 1000ml | 1 l
Age Protect Skin Clear Cleanser 200ml | 200 ml
Anti-Redness Serum 30ml | 30 ml
Anti-Redness Serum 3000g | 3 kg
Spreadsheet: 784579d1655833429-need-to-apply-discount-to-a-product-selected-from-drop-down-list-testquote21
Sheet: 3Design Quote

 |  |  |  |  |  | QUOTE # |  | 20220620-TB
[NAME] to |  |  |  |  |  | Ship to
Company
Name
Address
City/State
Quote Date |  |  |  | Purchase Order # |  |  | Order Confirmation (if no P.O provided)
 |  |  |  |  |  |  | By signing, I approve payment terms, amount
 |  |  |  |  |  |  | and agree to purchase products as described below
Terms | At time of order |  |  | All Prices are in US $ |  |  | Signature:
 |  |  | All Software Sales are Final - NonRefundable
Quantity | Product ID | Product Description |  |  |  |  |  | Unit Price | Discount | Total
1 |  | Training Group Online 2 Hours |  |  |  |  |  |  | 0.05
SALES QUOTE VALID FOR 30 DAYS ONLY |  |  |  |  |  |  |  | Subtotal
Quote prepared by: |  | [NAME] |  |  | $0.00 shipping |  |  | Sales Tax | 0.03
For questions, please call me at  or email |  |  |  |  |  |  |  | Shipping & Handling
We accept check, wire transfer and major credit cards as methods of payment |  |  |  |  |  |  |  | Total in USD
Spreadsheet: 750390d1633434134-match-month-and-year-and-return-collumn-to-right-excel-help-forum
Sheet: Revenue

2022 | January | February | March | April | May | June | July | August | September | October | November | December
Branch 1
Branch 2
Branch 3
Branch 4
Branch 5
Branch 6
Branch 7
Branch 8
Branch 9
Revenue - Monthly
Criteria: | Each line is treated separately (Branch 1, Branch 2, etc.)
 | For branch 1, for example, I want a formula is cell B2 that looks for a date on the whole of Revenue!Row2, which matches the month (B$1/January) and year ($A$1/2022)
 | This example for Branch 1 (row 2) would match January and 2022 to cell Revenue!B2. I want the value one column to the right returned (259,200)
 | If month/year match doesn't exist, return blank.
 | Thank you <3
Spreadsheet: 376699d1423684244-req-race-score-race-winners
Sheet: Sheet1

# | Position |  | Driver | Team | Points | Wins | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 |  |  |  |  |  |  | 25 | 15 | 15 | 15
 |  |  |  |  |  |  | 18 | 25 | 18 | 25
 |  |  |  |  |  |  | 12 | 18 | 1 | 25
 |  |  |  |  |  |  | 15 | 12 | 2 | 10
Spreadsheet: 23576d1213133909-comparing-two-tables-sku2sample
Sheet: prc.xls

[NAME] | level | price
9101 | 1 | 9.49
9101 | 3 | 33.99
9103 | 1 | 9.49
9103 | 3 | 33.99
3700 | 1 | 7.49
3700 | 3 | 27.49
2628 | 1 | 7.49
2628 | 3 | 25.99
9121 | 1 | 8.49
9121 | 3 | 29.99
9122 | 1 | 8.49
9122 | 3 | 29.99
331 | 1 | 7.49
331 | 3 | 25.99
9124 | 1 | 5.99
9124 | 3 | 23.99
9125 | 1 | 4.99
9126 | 1 | 2.99
9126 | 3 | 10.99
9123 | 1 | 8.99
9123 | 3 | 16.99
2821 | 1 | 18.99
2138 | 1 | 4.99
2138 | 3 | 17.99
9132 | 1 | 8.99
9132 | 3 | 17.99
1972 | 1 | 18.99
317 | 1 | 4.99
317 | 3 | 17.99
3661 | 1 | 5.49
9128 | 1 | 5.99
9128 | 3 | 21.49
9127 | 1 | 2.89
9127 | 3 | 30.99
2092 | 1 | 8.99
2092 | 3 | 16.99
9137 | 1 | 4.99
9137 | 3 | 17.99
9138 | 1 | 2.99
9138 | 3 | 9.99
9140 | 1 | 3.99
9141 | 1 | 5.99
9141 | 3 | 11.49
4569 | 1 | 13.99
199 | 1 | 3.99
199 | 3 | 13.99
9142 | 1 | 5.99
9142 | 3 | 11.49
4023 | 1 | 13.99
9152 | 1 | 2.79
9152 | 3 | 28.99
9155 | 1 | 4.99
9155 | 3 | 16.99
9158 | 1 | 8.49
9158 | 3 | 16.49
5812 | 1 | 18.99
686 | 1 | 13.99
6000 | 1 | 1.99
6000 | 3 | 15.99
298 | 1 | 5.49
298 | 3 | 20.99
9163 | 1 | 4.99
4411 | 1 | 4.49
4411 | 3 | 11.49
9162 | 1 | 8.99
9162 | 3 | 16.49
21 | 1 | 18.99
2547 | 1 | 2.89
2547 | 3 | 29.99
2036 | 1 | 8.99
2036 | 3 | 16.99
4143 | 1 | 4.99
4143 | 3 | 17.99
942 | 1 | 3.49
942 | 3 | 11.99
9157 | 1 | 4.99
9157 | 3 | 17.99
1377 | 1 | 4.29
1377 | 3 | 14.59
9167 | 1 | 7.49
9167 | 3 | 26.49
5715 | 1 | 8.49
5715 | 3 | 29.99
5743 | 1 | 8.49
5743 | 3 | 29.99
436 | 1 | 7.99
436 | 3 | 27.99
2795 | 1 | 7.99
2795 | 3 | 27.99
2794 | 1 | 7.99
2794 | 3 | 26.99
9171 | 1 | 13.99
211 | 1 | 5.49
211 | 3 | 0
4601 | 3 | 17.99
3777 | 1 | 5.99
3777 | 3 | 20.99
1808 | 1 | 9.99
1808 | 3 | 18.99
Spreadsheet: 255d1d53-7ccd-4a35-bf07-699b18e73cc7
Sheet: 16

Product* | February 7 | February 14 | February 21 | February 28 | March 7
Total Equity**
Equity Swaps | N/A | N/A | N/A | N/A | N/A
Portfolio Swaps | N/A | N/A | N/A | N/A | N/A
Forwards | N/A | N/A | N/A | N/A | N/A
Swaptions | N/A | N/A | N/A | N/A | N/A
[NAME] | N/A | N/A | N/A | N/A | N/A
TOTAL
Gross notional amount outstanding, March 7 weekly snapshot, by product type, all tenors and currencies.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**These numbers are estimates.
***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: 19f771e9-7a95-4dd9-b461-3b97d6d97c05
Sheet: 19

 |  | Broker** |  | Non-Broker |  | TOTAL
Product |  | Cleared*** | Uncleared | Cleared | Uncleared | Cleared | Uncleared
Swap* | CFD
 | Dividend
 | Equity Swap
 | Portfolio
 | [NAME]
Option | Accumulator/Decumulator
 | Vanilla (put/call)
 | [NAME]
Forward | Vanilla
Exotic
Structured Products
TOTAL |  | N/A**** | N/A | N/A | N/A | N/A | N/A
Estimated swap transaction volumes, month ending November 30, by product, participant type, and cleared status (in number of transactions).
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 participant type descriptions.
***See Explanatory Notes for cleared and uncleared descriptions.
****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: 823914d1680193468-excel-cell-colour-change-based-on-date-range-excel-cell-colour-change-etaf
Sheet: Sheet1

Priority | AJ Number | Job Name | Templater | Template Date | Fabrication Date | Install Date | TBC's & Issues | T&I Action | Office Action | Fabrication Action | Photos Received | Correct Standard
RED -2 |  |  |  |  | 2023-03-28 00:00:00 |  |  |  |  |  |  |  |  |  |  | Green - Date is today
AMBER -1 |  |  |  |  | 2023-03-29 00:00:00 |  |  |  |  |  |  |  |  |  |  | Amber - Todays date Minus 1
GREEN |  |  |  |  | 2023-03-30 00:00:00 |  |  |  |  |  |  |  |  |  |  | Red - Todays date minus 2
Spreadsheet: 673876d1587574088-monthly-interest-amount-per-with-dynamic-rates-forumexcel
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Today |  |  | Interest Rate: | 0.0525 | 0.05 | 0.0475 | 0.06 | 0.03 | 0.055 | 0.045 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475
Description | Serial No. | Amount Owed | Days in Inventory | Final Due Date | Status | Customer Name | Location | Collateral Value | [NAME] | Stock No. | Total Interest | Interest/Day | 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 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2020-01-31 00:00:00 | 2020-02-29 00:00:00 | 2020-03-31 00:00:00 | 2020-04-30 00:00:00 | 2020-05-31 00:00:00 | 2020-06-30 00:00:00 | 2020-07-31 00:00:00 | 2020-08-31 00:00:00 | 2020-09-30 00:00:00 | 2020-10-31 00:00:00 | 2020-11-30 00:00:00 | 2020-12-31 00:00:00 | 2021-01-31 00:00:00
S780 STS F | 1H0S780STLT810617
 |  | 488370.89 | 40 | 2020-04-01 00:00:00
 |  | 488370.89
Spreadsheet: 873118d1719543994-hh-mm-to-decimal-days-book1
Sheet: Daily Log

Daily Log
 | Date | From | To | Status | Duration | Decimal Day |  | Result should be:
 | 2024-05-21 00:00:00 | 0:00:00 | 1 day, 0:00:00 | Mobilisation |  |  |  | 1
 | 2024-05-22 00:00:00 | 0:00:00 | 12:00:00 | Mobilisation |  |  |  | 0.5
 | 2024-05-22 00:00:00 | 12:00:00 | 1 day, 0:00:00 | Transit |  |  |  | 0.5
Spreadsheet: 81687d1281810431-vlookup-shortage-presentation-template-1-
Sheet: Today Shortages

DJ | System | Item | Description | QTY | NBD | Suggest Start DT | Start DT | Commit DT | State | Comments
1234 | A | 1234-RB | VACCUM | 1 |  | 2010-08-05 00:00:00 | 2010-08-16 00:00:00 | 2010-08-15 00:00:00 |  | 7-28 LH Please TAKE demand down and add 0246-02635
23132 | B | 15783-FI | TUBE | 1 |  | 2010-08-06 00:00:00 |  | 2010-08-08 00:00:00 |  | 7/28 JW [x2 B45]
13213 | C | 476578CMP | HEATER | 3 |  | 2010-08-06 00:00:00 | 2010-08-09 00:00:00 | 2010-08-09 00:00:00 |  | 7/28 JW [x5 8/2] fedex8691324
21321 | D | 23876TDK | VACUUM BOLT | 1 |  | 2010-08-09 00:00:00 |  | 2010-09-01 00:00:00 |  | 7/27 GW [requested pull in]
1231 | G | 2387980RB | HEATER BOLT | 2 |  | 2010-08-09 00:00:00 |  | 2010-08-11 00:00:00 |  | 7/28 GW [pending FAI]
21321 | A | 7986875CMP | HT COVER | 1 |  | 2010-08-10 00:00:00 | 2010-08-12 00:00:00 | 2010-08-12 00:00:00 |  | 7/26CY - Req'd x8 from AGS Louisville for Next-day.  LT in Oracle was wrong-corrected.
213 | M | 23478FI | PROC | 1 |  | 2010-08-10 00:00:00 |  | 2010-09-01 00:00:00 |  | 7/27-RA-{x2 in stock Austin depot -CR}
131331 | B | 8645CPI | SWITCH | 1 |  | 2010-08-10 00:00:00 |  | 2010-09-01 00:00:00
13213 | C | 28672RB | FILM | 2 |  | 2010-08-13 00:00:00 |  | 2010-08-31 00:00:00
1323 | M | 0040-1234 | TEMP | 1 |  | 2010-08-17 00:00:00 |  | 2010-09-05 00:00:00
1323 | D | 0040-1235 | COOLER SYS | 1 |  | 2010-08-17 00:00:00 |  | 2010-08-26 00:00:00 |  | 7/27-RA-{x2 in stock Austin depot -CR}
Spreadsheet: 6dbcec6f-6518-4d34-8602-8f8efeb46338
Sheet: Sheet1

Down-regulated genes: | Unnamed: 1 | Unnamed: 2
[NAME] | ILMN_GENE | DEFINITION
-110.98 | C730007P19RIK | [NAME] cDNA C730007P19 gene (C730007P19Rik), mRNA.
-41.532 | EG624219 | Mus musculus predicted gene, EG624219 (EG624219), mRNA.
-34.642 | CYP2B13 | Mus musculus cytochrome P450, family 2, subfamily b, polypeptide 13 (Cyp2b13), mRNA.
-29.606 | HAMP2 | Mus musculus hepcidin antimicrobial peptide 2 (Hamp2), mRNA.
-25.311 | LIMA1 | Mus musculus LIM domain and actin binding 1 (Lima1), mRNA.
-25.311 | SOCS2 | Mus musculus suppressor of cytokine signaling 2 (Socs2), mRNA.
-24.886 | LOC668047 | PREDICTED: Mus musculus similar to ring finger protein 170 (LOC668047), mRNA.
-24.886 | SLCO1A4 | Mus musculus solute carrier organic anion transporter family, member 1a4 (Slco1a4), mRNA.
-24.258 | VLDLR | Mus musculus very low density lipoprotein receptor (Vldlr), mRNA.
-21.776 | SULT2A1 | Mus musculus sulfotransferase family 2A, dehydroepiandrosterone (DHEA)-preferring, member 1, mRNA
-17.214 | CABLES1 | Mus musculus CDK5 and Abl enzyme substrate 1 (Cables1), mRNA.
-13.587 | CYP17A1 | Mus musculus cytochrome P450, family 17, subfamily a, polypeptide 1 (Cyp17a1), mRNA.
Up-regulated genes:
[NAME] | ILMN_GENE | DEFINITION
38.055 | D14ERTD449E | Mus musculus DNA segment, Chr 14, ERATO Doi 449, expressed (D14Ertd449e), mRNA.
24.886 | LY6E | Mus musculus lymphocyte antigen 6 complex, locus E (Ly6e), mRNA.
18.71 | LY6E
13.587 | RRM2 | Mus musculus ribonucleotide reductase ([NAME]), mRNA
Spreadsheet: 843693d1695484148-create-a-dependent-drop-down-for-3-levels-dropdown
Sheet: Sheet1

Master Data |  |  |  |  |  | DropDown
OFFICE | DEPARTMENT | STAFF |  |  |  | OFFICE | DEPARTMENT | STAFF
KUL | SALES | JESS |  |  |  | JPN
KUL | SALES | MIKE
JPN | ADMIN | KEVIN
JPN | SALES | SUKI
JPN | HR | SAM
KOR | HR | JOY
KOR | HR | [NAME]
KOR | ACC | JAKE
IND | ACC | MAY
PHP | ADMIN | SUKI
Spreadsheet: 266255d1379550618-sum-based-on-1-column-header-name-and-2-value-of-a-different-column-sumbasedoncolumnheaderandrowvalue
Sheet: Sheet1

Employee | Product A | Product B | Product C
Walter | 65 | 85 | 95
[NAME] | 75 | 54 | 65
Skyler | 65 | 98 | 65
Hank | 65 | 65 | 68
Gustavo | 65 | 85 | 95
Walter | 75 | 54 | 65
[NAME] | 65 | 98 | 65
Skyler | 65 | 65 | 68
Hank | 65 | 85 | 95
Gustavo | 75 | 54 | 65
Walter | 65 | 98 | 65
[NAME] | 65 | 65 | 68
Spreadsheet: 800521d1665697757-how-to-use-conditional-formatting-between-2-cells-sample
Sheet: Sheet1

 | Option 1 Dataset |  |  |  | Result (Avg)
 | 5 |  |  | Option 1 |  | <--- how to make E3 and F3 cell turn green since it's closer to its target 10?
 | 10 |  |  | Option 2
 | 15
 | 20 |  |  |  | %CV
 | Option 2 Dataset |  |  | Option 1
 | 5 |  |  | Option 2 |  | <-- how to make E8 and F8 cell turn green since it’s a lower number?
 | 6
 | 7 |  |  |  | Random criteria looking at the higher number
 | 8 |  |  | Option 1 | 6
 |  |  |  | Option 2 | 7 | <-- how to make E12 and F12 turn green since it’s the higher number?
 |  |  |  | Best option: | <--- how to count whether Option 1 or Option 2 has more green and show Option 2i is the winner?
Spreadsheet: 875202d1721783737-lookup-data-based-on-calendar-leave-tracker-leave-planner
Sheet: Summary

Name | [NAME] | AL |  |  | OIL |  |  | MC |  |  | HP |  |  |  |  |  |  | Legend
 |  | Earned | Used | Balance | Earned | Used | Balance | Earned | Used | Balance | Earned | Used | Balance |  |  |  |  | AL | Annual Leave
Agent 1 | 2024-01-01 00:00:00 |  | 5.5 |  | 9 | 1.5 |  | 18 | 2 |  | 60 | 4 |  |  |  |  |  | AL0.5 | Half Day Annual Leave
Agent 2 | 2023-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EL | Emergency Leave
Agent 3 | 2023-10-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OIL | Replacement Leave
Agent 4 | 2024-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OIL0.5 | Half Day Replacement Leave
Agent 5 | 2024-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MC | Medical/Sick Leave
Agent 6 | 2024-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HP | Hospital Leave
Agent 7 | 2023-12-01 00:00:00
Agent 8 | 2023-10-01 00:00:00
Agent 9 | 2023-10-01 00:00:00
Agent 10 | 2023-12-01 00:00:00
* Above table populates based on input from "Leave Planner" sheet
* AL earned are to be populated base on the current month and joined date
* Annual Leave are earned, which means agent earn 1.33 every month. This to give visibility how many leaves they had earned till current month.
* EL are deducted from from AL earned
* Other leaves are earned and given of the beginning of year
Spreadsheet: 90364d1290100071-formula-to-count-weekdays-only-excluding-holidays-too-calendartesting9
Sheet: 2011

 |  | Year | Month | Date | Day of Week | [NAME]
2011-01-01 00:00:00
Spreadsheet: 210073d1359377765-status-value-dependant-upon-data-in-certain-cells-excel-query
Sheet: Sheet1

Status | Date Account Created | Date Documents Submitted | Date Documents Received | Documents are completed | Provisional Date | [NAME] | File Complete
Account Created | 2013-01-01 00:00:00
Documents Submitted | 2013-01-01 00:00:00 | 2013-01-02 00:00:00
Documents Received | 2013-01-01 00:00:00 | 2013-01-02 00:00:00 | 2013-01-03 00:00:00
Documents Completed | 2013-01-01 00:00:00 | 2013-01-02 00:00:00 | 2013-01-03 00:00:00 | Yes
Provisional Date | 2013-01-01 00:00:00 | 2013-01-02 00:00:00 | 2013-01-03 00:00:00 | Yes | 2013-01-05 00:00:00
[NAME] | 2013-01-01 00:00:00 | 2013-01-02 00:00:00 | 2013-01-03 00:00:00 | Yes | 2013-01-05 00:00:00 | Yes
File Complete | 2013-01-01 00:00:00 | 2013-01-02 00:00:00 | 2013-01-03 00:00:00 | Yes | 2013-01-05 00:00:00 | Yes | Yes