tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 98403d1297311738-setting-expiry-date-with-conditional-formatting-records-for-data-input
Sheet: PLANT OPERATOR

PLANT OPERATORS
 | FIRST AID | BLUE CARD | HIGH RISK | [NAME] | SUBSTATION | TRAFFIC | FORK LIFT | [NAME] | [NAME] | EDD | PTR | INDUCTION | NWORK
 |  |  | WP, DG |  | ENTRY (2YR) | MGMNT (3YR) | (5YR) | OPERATION (5YR) | OPERATION (5YR) |  |  |  | ACCESS
[NAME] | 2012-01-24 00:00:00 | 163342 | 2013-01-11 00:00:00 | 2011-09-26 00:00:00 | NO | NO |  |  |  | 2012-01-24 00:00:00 | 2012-01-24 00:00:00 | 2008-04-23 00:00:00 | Received
Spreadsheet: 847433d1698355388-determine-of-visitors-per-month-based-on-quarter-indicated-hd180-visitors-per-year
Sheet: Sheet1

 |  |  |  |  | WHEN ARE THE GROUPS GOING TO VISIT? |  |  |  |  | HOW MANY VISITORS PER MONTH (EST)
 |  |  |  |  |  |  |  |  |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4
 | SIMPLE | discount | regular |  | Q1 | Q2 | Q3 | Q4 |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
 | Group A | 50 | 50 |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | no visits in Dec
 | Group B | 32 | 80 |  | X | X
 | Group C | 18 | 25 |  |  | X
 | Group D | 64 | 8 |  |  | X | X
 | Group E | 123 | 31 |  |  |  | X
 | Group F | 0 | 12 |  |  |  | X | X
 | Group G | 81 | 29 |  | X | X | X | X
 |  |  |  |  | WHEN ARE THE GROUPS GOING TO VISIT? |  |  |  |  | HOW MANY VISITORS PER MONTH (EST)
 |  |  |  |  |  |  |  |  |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4
 | COMPLEX | discount | regular |  | Q1 | Q2 | Q3 | Q4 |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
 | Group A | 50 | 50 |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | no visits in Dec
 | Group B | 32 | 80 |  | X | X
 | Group C | 18 | 25 |  | X |  | X
 | Group D | 64 | 8 |  | X |  |  | X
 | Group E | 123 | 31 |  |  | X
 | Group F | 0 | 12 |  |  | X | X
 | Group G | 57 | 18 |  |  | X |  | X
 | Group H | 143 | 39 |  |  |  | X
 | Group I | 6 | 0 |  |  |  | X | X
 | Group J | 0 | 62 |  |  |  |  | X
 | Group K | 81 | 29 |  | X | X | X | X
Spreadsheet: 843993d1695804249-lookup-if-an-value-repeats-and-mark-as-paid-test-lookup-paid-items-01
Sheet: Sheet1

DATE | PATRON | DOC # | ISSUES | PAID | OUTSTANDING
2023-01-01 00:00:00 | 12345 | 1111 | 500 |  | NO
2023-01-10 00:00:00 | 23456 | 2222 | 350 |  | YES |  | Yes
2023-01-20 00:00:00 | 98765 | 3333 | 800 |  | NO |  | No
2023-01-30 00:00:00 | 43210 | 4444 | 200 |  | YES |  | Yes
2023-02-10 00:00:00 | 12345 | 1111 |  | 500 | NO |  | No
2023-02-20 00:00:00 | 98765 | 3333 |  | 800 | NO |  | No
Spreadsheet: 263610d1378557477-auto-fill-dates-twrtleduck-calendar-autofill-dates
Sheet: Sheet1

 | 2 | 3 | 4 | 5 | 6 | 2 | 3 | 4 | 5 | 6 | 2 | 3 | 4 | 5 | 6 | 2 | 3 | 4 | 5 | 6 | 2 | 3 | 4 | 5 | 6
 |  |  |  |  |  |  |  |  |  |  |  | 2013-08-01 00:00:00
 | Week 1 |  |  |  |  | Week 2 |  |  |  |  | Week 3 |  |  |  |  | Week 4 |  |  |  |  | Week 5
 | week one, I want to be able to put in the first day in any of the 5 cells leaving the cells before it blank and auto filling the cell after up through week 5
 |  |  |  |  |  |  |  |  |  |  |  | 2013-09-01 00:00:00
 | Week 1 |  |  |  |  | Week 2 |  |  |  |  | Week 3 |  |  |  |  | Week 4 |  |  |  |  | Week 5
 | week five, I want it to leave the cells blank after 31
 | If week one is all blanks then I want all cell to be blank
Spreadsheet: 407103d2-fbc5-4330-bd35-27b5c763ae5a
Sheet: Sheet1

analytica 2012 - Aussteller Liste | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Suche über Produkt- und Dienstleistungsverzeichnis (6 [NAME]):
 | 7 Biotechnologie 7.5 Antikörper 7.5.2 Polyklonale Antikörper
Nr. | Firma | Land | Ort | PLZ | Halle/Stand
1 | [NAME] MorphoSys AbD GmbH | Deutschland | [NAME] | 40470 | A3.121
2 | metabion international AG metabion GmbH | Deutschland | [NAME] | 82152 | A3.400
3 | New England Biolabs GmbH | Deutschland | Frankfurt | 65926 | A3.351
4 | PeproTech GmbH | Deutschland | Hamburg | 22081 | A3.143
5 | Phoenix Europe GmbH | Deutschland | Karlsruhe | 76133 | A3.152
6 | Thermo Scientific | Deutschland | Dreieich | 63303 | B1.101/202
Spreadsheet: andy_zipper__747__Global_Prod 10-26-01 EM
Sheet: New - 24 Hr

New Global Products made available on
that were not available on
Global Product Short Desc.
DTD Brent vs.    IPE Frontline           Mar02           USD/bbl
For Curr Exch    Forward                 30Oct01         JPY/USD
For Curr Exch    Forward                 30Oct01         USD/EUR
For Curr Exch    Forward                 30Oct01         USD/GBP
For Curr LME     LME (Spot)              30Oct01         JPY/USD
For Curr LME     LME (Spot)              30Oct01         USD/EUR
For Curr LME     LME (Spot)              30Oct01         USD/GBP
Foreign Currency Reuters BOFC            26Oct01         CAD/USD
NOR Wthr Swap    SPI 5000/25K            05-11Nov01      NOK/SPI
NOR Wthr Swap    SPI 5000/25K            29Oct-04Nov     NOK/SPI
NOR Wthr Swap    STB 4000/1200K          01Oct01-30Apr02 NOK/STB
NOR Wthr Swap    STB 500/150K            01Oct01-30Apr02 EUR/STB
US Coal Phy      Nymex Spec              Jan02-Dec03     USD/ST-b
US Coal Phy      PRB8800                 Jan-Dec03       USD/ST-t
US Coal Phy      PRB8800                 Jan-Dec04       USD/ST-t
US [NAME]Dec01           c/Gl-b
US [NAME]Nov01           c/Gl-b
Spreadsheet: 840180d1692537633-text-to-column-delimited-with-multiple-dash-sample-1-
Sheet: Sheet1

Brake Line Braided 2-3 Inch 50-75mm Front Each - GQBRBRL3F
Brake Line Braided 2-3 Inch 50-75mm Rear Each - GQBRBRL3R
[NAME] 4-5 Inch 100-125mm Front Each - GQBRBRL5F
[NAME] 4-5 Inch 100-125mm Rear Each - GQBRBRL5R
[NAME] 6 Inch 150mm Front Each - GQBRBRL6F
[NAME] 6 Inch 150mm Rear Each - GQBRBRL6R
[NAME] Each - GQBRBRLSF
[NAME] Each - GQBRBRLSR
[NAME] Rubber 2-3 Inch 50-75mm Front Each - GQRBRL3F
[NAME] Rubber 2-3 Inch 50-75mm Rear Each - GQRBRL3R
[NAME] Rubber 4-5 Inch 100-125mm Front Each - GQRBRL5F
[NAME] Rubber 4-5 Inch 100-125mm Rear Each - GQRBRL5R
[NAME] Rubber 6 Inch 150mm Front Each - GQRBRL6F
[NAME] Rubber 6 Inch 150mm Rear Each - GQRBRL6R
Caliper Lines Braided Front Coil Pair - GQBRCLLFC
Caliper Lines Braided Front Leaf Pair - GQBRCLLFL
Caliper Lines Braided Rear Coil Pair - GQBRCLLRC
Caliper Lines Braided Rear Leaf Pair - GQBRCLLRL
Caliper Lines Rubber Front Pair - GQCRBRLF
Caliper Lines Rubber Rear Pair - GQCRBRLR
Spreadsheet: 0ca5217a-34b1-4185-816f-1092f1cdae84
Sheet: Reference Changes

Standard Label | Element Name
Allowance for Doubtful Accounts Receivable, Write-offs | AllowanceForDoubtfulAccountsReceivableWriteOffs
Net Assets | AssetsNet
Available-for-sale Debt Securities, Amortized Cost Basis | AvailableForSaleDebtSecuritiesAmortizedCostBasis
Deferred Policy Acquisition Costs | DeferredPolicyAcquisitionCosts
Deferred Policy Acquisition Costs and Value of Business Acquired | DeferredPolicyAcquisitionCostsAndValueOfBusinessAcquired
Deferred Tax Liability Not Recognized, Amount of Unrecognized Deferred Tax Liability, Undistributed Earnings of Domestic Subsidiaries | DeferredTaxLiabilityNotRecognizedAmountOfUnrecognizedDeferredTaxLiabilityUndistributedEarningsOfDomesticSubsidiaries
Derivative Asset, Collateral, Obligation to Return Cash, Offset | DerivativeAssetCollateralObligationToReturnCashOffset
Derivative Asset, Fair Value, Amount Not Offset Against Collateral | DerivativeFairValueOfDerivativeAssetAmountNotOffsetAgainstCollateral
Derivative Liability, Fair Value, Amount Not Offset Against Collateral | DerivativeFairValueOfDerivativeLiabilityAmountNotOffsetAgainstCollateral
Derivative Liability, Collateral, Right to Reclaim Cash, Offset | DerivativeLiabilityCollateralRightToReclaimCashOffset
Liquidation Date, Expected to [NAME] | LiquidationDate1
Temporary Equity, Carrying Amount, Including Portion Attributable to Noncontrolling Interests | TemporaryEquityCarryingAmountIncludingPortionAttributableToNoncontrollingInterests
Trading Gain (Loss) | TradingGainsLosses
Trading Securities, Equity | TradingSecuritiesEquity
US Treasury and Government [Member] | USTreasuryAndGovernmentMember
Spreadsheet: 70334d1271116435-if-formula-config-sheet-budget-2011
Sheet: Dec

1st |  |  |  | 8th |  |  |  | 15th |  |  |  | 22nd |  |  |  |  |  |  |  |  |  |  |  | Income
Income |  |  |  | Income |  |  |  | Income |  |  |  | Income |  |  |  | Income |  |  |  | Income |  |  |  | Transfer
Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Birthday
Savings Balance |  | 0 |  | Savings Balance |  |  |  | Savings Balance |  |  |  | Savings Balance |  |  |  | Savings Balance |  |  |  | Savings Balance |  |  |  | Clothing
Subtract from Savings |  | 0 |  | Subtract from Savings |  | 0 |  | Subtract from Savings |  | 0 |  | Subtract from Savings |  | 0 |  | Subtract from Savings |  | 0 |  | Subtract from Savings |  | 0 |  | Entertainment
Previous |  |  |  | Previous |  |  |  | Previous |  |  |  | Previous |  |  |  | Previous |  |  |  | Previous |  |  |  | Fast Food
 |  |  |  |  |  |  |  |  |  | 100 |  |  |  | 100 |  |  |  | 100 |  |  |  | 100 |  | Fee
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Food
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gas
Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Insurance
Expenses |  |  |  | Expenses |  |  |  | Expenses |  |  |  | Expenses |  |  |  | Expenses |  |  |  | Expenses |  |  |  | Loan
Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Misc
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Smokes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Utilities
Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total
Left Over |  |  |  | Left Over |  |  |  | Left Over |  |  |  | Left Over |  |  |  | Left Over |  |  |  | Left Over
Savings |  |  |  | Savings |  |  |  | Savings |  |  |  | Savings |  |  |  | Savings |  |  |  | Savings
Spreadsheet: 145567d1331651198-listing-and-counting-values-in-a-table-animals
Sheet: Sheet1

Pig | Cow | Pig | Pig
Pig | Horse | Elephant | Sheep
Goat | Sheep | Goat | Sheep
Dog | Dog | Horse | Elephant
Dog | Goat | Elephant | Cow
Spreadsheet: 74214d1274789951-tables-references-calculations-components-v2
Sheet: worksheet

 | Order Sheet
 | Customer | [NAME]
 | Location | Wisconsin
 | Components Ordered
 |  |  | Components Needed
 | Units | Type | Blood | Sweat | Tears | Money
 | 32 | Flashlight | 932 | 582 | 1430 | 167
 | 16 | Moped | 468 | 310 | 726 | 87
 | 11 | Typewriter | 323 | 225 | 506 | 62
 | TOTALS |  | 1723 | 1117 | 2662 | 316
Spreadsheet: louise_kitchen__22823__SSMB Benefit Estimates For NETCO
Sheet: Adjusted Maximum Est. (2)

Below is the overall # of EEs by $ [NAME] and the avg salary in that range for Netco EEs.
[NAME] (USD) | # of EEs in $ [NAME] | [NAME] in $ [NAME] | Total | Employee Only Adjusted Rate |  | SSMB Adjusted Range Dollars | Difference To Make Whole
< $25,000 |  | 22033
$25,000 - $39,999 |  | 33318
$40,000 - $59,999 |  | 48312
$60,000 - $79,999 |  | 69487
$80,000 - $99,999 |  | 87026
Totals
[NAME] (USD) | # of EEs in $ [NAME] | [NAME] in $ [NAME] | Total | Employee Spouse Adjusted Rate |  | SSMB Adjusted Range Dollars | Difference To Make Whole
< $25,000 | 0 | 22033
$25,000 - $39,999 |  | 33318
$40,000 - $59,999 |  | 48312
$60,000 - $79,999 |  | 69487
$80,000 - $99,999 |  | 87026
Totals
[NAME] (USD) | # of EEs in $ [NAME] | [NAME] in $ [NAME] | Total | Employee & Children Adjusted Rate |  | SSMB Adjusted Range Dollars | Difference To Make Whole
< $25,000 | 0 | 22033
$25,000 - $39,999 |  | 33318
$40,000 - $59,999 |  | 48312
$60,000 - $79,999 |  | 69487
$80,000 - $99,999 |  | 87026
Totals
[NAME] (USD) | # of EEs in $ [NAME] | [NAME] in $ [NAME] | Total | Employee & Family Adjusted Rate |  | SSMB Adjusted Range Dollars | Difference To Make Whole
< $25,000 |  | 22033
$25,000 - $39,999 |  | 33318
$40,000 - $59,999 |  | 48312
$60,000 - $79,999 |  | 69487
$80,000 - $99,999 |  | 87026
Totals
Grand Total US
Average
< $25,000
$25,000 - $39,999
$40,000 - $59,999
$60,000 - $79,999
$80,000 - $99,999
Spreadsheet: 99315d1297977761-excel-2007-need-to-create-one-chart-with-mutiple-axes-data
Sheet: Sheet2

plot | 1650 | 1660 | 1670 | 1680 | 1690 | 1700 | 1710 | 1720 | 1730 | 1740 | 1750 | 1760 | 1770 | 1780 | 1790 | 1800 | 1810 | 1820 | 1830 | 1840 | 1850 | 1860 | 1870 | 1880 | 1890 | 1900 | 1910 | 1920 | 1930 | 1940 | 1950 | 1960 | 1970
ACRU
BELE
CAGL
FAGR |  |  |  |  |  |  |  |  |  |  |  |  | 1
JUNI
LITU |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
MAMA
MATR
OXAR
TSCA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 2 | 1 |  | 1 |  |  |  | 1
Spreadsheet: 783690d1655078844-extract-values-into-column-h2-h300-based-on-selection-in-column-f1-first-or-last-from-dropdown
Sheet: Here

First, Middle and Last Name | Pull by First Name | Last Name, First Name, Middle | Pull by Last Name |  | First Name |  | Desired Outcome
Ahm, Son | First Name | Aki, [NAME] | Last Name
Ang, Van | First Name | Alc, [NAME] | Last Name
[NAME], One | First Name | All, Tia | Last Name
Bow, [NAME] | First Name | Ban, Aja | Last Name
Cal, Ore | First Name | Blu, Nie | Last Name
Chr, Nka | First Name | Boh, [NAME] | Last Name
Chr, Art | First Name | Bur, Cia | Last Name
Chr, Son | First Name | Bur, Ika | Last Name
Cou, [NAME] | First Name | Cam, Ria | Last Name
Ela, [NAME] | First Name | [NAME], [NAME] | Last Name
Eri, [NAME] | First Name | [NAME], Ica | Last Name
Fra, [NAME] | First Name | Dya, Ine | Last Name
Han, Umo | First Name | Ebo,  L. | Last Name
Jam, [NAME] | First Name | Gra, Rea | Last Name
Joy, Son | First Name | Har, Ine | Last Name
Lis, One | First Name | Joh, Med | Last Name
Luc, Ack | First Name | Kaz, Qat | Last Name
Mil, Ugh | First Name | Lav,  M. | Last Name
Olu, [NAME] | First Name | Law, Sky | Last Name
Pat, Den | First Name | Mar, Ers | Last Name
[NAME], Eem | First Name | Mat, Ine | Last Name
Riu, Dos | First Name | Mch, Les | Last Name
Sat, [NAME] | First Name | [NAME], [NAME] | Last Name
Sha, Rth | First Name | Obr, Nah | Last Name
Sin, Ell | First Name | Rei, Nie | Last Name
Sky, Wal | First Name | Sta, Non | Last Name
Ste, [NAME] | First Name | Ton, Oyo | Last Name
Ste, Eid | First Name | Tyr, Ins | Last Name
[NAME], Ead | First Name | [NAME], [NAME] | Last Name
Ter, Son | First Name | Wat, [NAME] | Last Name
Tuo, Nwe | First Name | Wil, Asa | Last Name
Spreadsheet: 35775d1233420898-interpolate-non-integer-values-in-a-look-up-table-scratch
Sheet: Sheet1

 | y (rpm)
x | 12200 | 13000 | 15010
34 | 54 | 34 | 35.54
35 | 56 | 32.43 | 65.543
76.9976 | 76.6798 | 43.43 | 43.432
85.78 | 83.653 | 42.432 | 67.543
99.7897 | 78.678 | 482.4323 | 43.432
Interpolate:
x | rpm | y
86.44 | 14543 | 65.65281225861737
86.44 | 14543 | 65.65281225861739 | <-- function used here
Helper Values: (do not delete them)
 | 83.41862667294804 | 63.16050938992248 | 66.40712557014072
85.78 | 83.653 | 42.432 | 67.543
99.7897 | 78.678 | 482.4323 | 43.432
 | 13000 | 15010
 | 63.16050938992248 | 66.40712557014072
Spreadsheet: 843289d1695185628-sum-up-dynamic-range-sumup-dynamic-range
Sheet: Blad1

apples
 | 5
 | 7
 | 2
 | 6
bananas
 | 8
 | 7
 | 2
 | 3
 | 1
lemons
 | 5
 | 7
 | 8
cherries
 | 9
 | 9
 | 3
 | 1
 | 4
 | 7
Spreadsheet: eric_saibi__9975__111501
Sheet: Crockett 01 ST

Owner Name |  | NRG Energy Incorporated
Station Name |  | Crockett Cogeneration
Unit Name |  | Unit 01 ST
NERC Region |  | WSCC
State |  | CA
Fuel Type |  | Natural Gas
Capacity |  | 85 MW
Start Date |  | 2001-11-14 00:00:00
End Date |  | 2001-11-18 00:00:00
Comments |  | Combustion Turbine Failure
SIC |  | 4931
Plant ID |  | 1014756
Unit ID |  | 1010464
Outage ID |  | 18914
Spreadsheet: 273517d1382733606-conditional-formatting-with-formulas-and-ranges-for-excel-forum-question
Sheet: Up to Date Prices

Part # | Updated Price | Unit | Price Per Unit
1000 |  | E
2000 |  | C
3000 |  | M
4000 |  | E
5000 |  | E
Spreadsheet: 78783d1279105794-advanced-lookup-retrieving-multiple-data-from-a-single-cell-example-123456-
Sheet: Main

Components of mixture |  | Mixture used
 |  |  |  | Density
 |  | Example 1 |  | 1.059
0.25 | Methane
0.75 | Nitrogen
0 | 0 |  |  |  |  | I want to be able to make the bits in grey be automatically found from the 'Data' tab
 |  | Example 2 |  | 1.203
0.1 | Methane
0.1 | Propane
0.8 | Nitrogen
Spreadsheet: 847282d1698292784-attendance-report-calculations-attendance-report
Sheet: Sheet1

 |  | 2023-09-08 00:00:00 |  |  | [NAME] |  |  |  | Result
 |  | Total Hours | Idle Time | Actual Worked | Total Hours (Full Day) | Total Hours (Half Day) | Actual (Full Day) | Actual (Half Day) |  |  |  |  |  | Result Output:
 |  | 08:07:00 | 00:12:00 |  | 08:00:00 | 04:00:00 | 05:00:00 | 03:30:00 |  |  |  |  |  | P | Full day Present
 |  |  |  |  |  |  |  |  |  |  |  |  |  | H | Half day Present
 |  |  |  | Conditions for Calculations & Examples: |  |  |  |  |  |  |  |  |  | A | Absent
 |  | 1 | If the candidate works 8 and above total hours & 5 and above actual hours - the result will be " P "
 |  | 2023-09-08 00:00:00 |  |  | [NAME] |  |  |  | Result
 |  | Total Hours | Idle Time | Actual Worked | Total Hours (Full Day) | Total Hours (Half Day) | Actual (Full Day) | Actual (Half Day)
 |  | 08:07:00 | 00:12:00 |  | 08:00:00 | 04:00:00 | 05:00:00 | 03:30:00 | P
 |  | 2 | If the candidate works 8 and above total hours but actual hours is below 5 and above 3:30 actual hours - the result will be " H "
 |  | 2023-09-08 00:00:00 |  |  | [NAME] |  |  |  | Result
 |  | Total Hours | Idle Time | Actual Worked | Total Hours (Full Day) | Total Hours (Half Day) | Actual (Full Day) | Actual (Half Day)
 |  | 08:07:00 | 03:12:00 |  | 08:00:00 | 04:00:00 | 05:00:00 | 03:30:00 | H
 |  | 3 | If the candidate works 8 and above total hours but actual hours is below 3:30 - the result will be " A "
 |  | 2023-09-08 00:00:00 |  |  | [NAME] |  |  |  | Result
 |  | Total Hours | Idle Time | Actual Worked | Total Hours (Full Day) | Total Hours (Half Day) | Actual (Full Day) | Actual (Half Day)
 |  | 08:07:00 | 05:12:00 |  | 08:00:00 | 04:00:00 | 05:00:00 | 03:30:00 | A
 |  | 4 | If the candidate works 4 and below 8 total hours & 3.30 and below 5 actual hours - the result will be " H "
 |  | 2023-09-08 00:00:00 |  |  | [NAME] |  |  |  | Result
 |  | Total Hours | Idle Time | Actual Worked | Total Hours (Full Day) | Total Hours (Half Day) | Actual (Full Day) | Actual (Half Day)
 |  | 04:07:00 | 00:12:00 |  | 08:00:00 | 04:00:00 | 05:00:00 | 03:30:00 | H
 |  | 5 | if the candidate works less than 4 total hours - the result will be " A "
 |  | 2023-09-08 00:00:00 |  |  | [NAME] |  |  |  | Result
 |  | Total Hours | Idle Time | Actual Worked | Total Hours (Full Day) | Total Hours (Half Day) | Actual (Full Day) | Actual (Half Day)
 |  | 03:07:00 | 00:12:00 |  | 08:00:00 | 04:00:00 | 05:00:00 | 03:30:00 | A
Spreadsheet: 677616d1589433043-how-to-use-multiple-index-and-match-in-the-multiple-conditions-sample-1
Sheet: Data

INCIDENT_NUMBER | PART_NUMBER | SEGMENT1 | SEGMENT2 | RESOLUTION_CODE | PARTNUMBER_REPLACED
4526577 | P190 | SYS | IVI | REPLACE - MAIN PCBA
4526570 | P0885 | SYS | M | REPLACE - POWER SUPPLY PCBA
4526580 | P269 | SYS | M TURB | REPLACE - MAIN PCBA | P19087-02
4526588 | P082 | SYS | EDG | REPLACE - BATTERY | P15051-20
4526579 | P076 | TRAN | REMAN | REPLACED END ITEM | P076
4526599 | P1932 | SYS | M | SCRAP
Fomula for: | First, find the part number replacement in the repair tab column F
 | Second, If the matching part number replaced is not found in the repair tab go to the PN tab to match it using column E and D
 | as long as column C is "SYS"
 | If the column C is 'TRAN" the return value will be the data in column B
Spreadsheet: 9e95fdcc-b8a9-416b-951d-66e04f733e71
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
FCP12 | Test | FCP12 | Cytokine Panel 12 by MAFD | Cytokine Panel 12 by MAFD | Quantitative Multiplex Bead Assay |  |  |  |  |  | Submit only 1 of the following:   Serum Draw blood in a plain, red-top tube(s). (Serum gel tube is acceptable.) Send 1 mL of serum frozen in a plastic vial.  [NAME] blood in a green-top (heparin) tube(s). Send 1 mL of plasma frozen in a plastic vial.    Note: Critical frozen. Additional specimens must be submitted when multiple tests are ordered. | 0.3 mL | Hemolysis:	NA Thawing:	Warm Reject; Cold Reject Lipemia:	NA Icterus:	NA Other:	Heat-inactivated, refrigerated or contaminated specimens are unacceptable. | Interleukin 2 by MAFD				0 - 12 pg/mL Interleukin 2 Receptor (Soluble) by MAFD	0 - 1033 pg/mL Interleukin 12 by MAFD				0 - 6 pg/mL Interferon gamma by MAFD			0 - 5 pg/mL Interleukin 4 by MAFD				0 - 5 pg/mL Interleukin 5 by MAFD				0 - 5 pg/mL Interleukin 10 by MAFD				0 - 18 pg/mL Interleukin 13 by MAFD				0 - 5 pg/mL Interleukin 1 beta by MAFD			0 - 36 pg/mL Interleukin 6 by MAFD				0 - 5 pg/mL Interleukin 8 by MAFD				0 - 5 pg/mL Tumor Necrosis Factor - alpha			0 - 22 pg/mL  Results are to be used for research purposes or in attempts to understand the pathophysiology of immune, infectious, or inflammatory disorders.   Test Performed by: ARUP Laboratories                             500 [NAME]St. Lake City, UT 84108 | Monday, Wednesday, Friday | 1 - 4 days | 3 - 8 days | 12 | 83520 |  |  |  |  | ARUP Laboratories
FCP12 | [NAME] | VARIES | Varies |  |  |  | Frozen | 365 days
FCP12 | Result | Z2732 | Interleukin 2 by MAFD | Interleukin 2 by MAFD | Alphanumeric
FCP12 | Result | Z2721 | Interleukin 2 Receptor by MAFD | Interleukin 2 Receptor by MAFD | Alphanumeric
FCP12 | Result | Z2722 | Interleukin 12 by MAFD | Interleukin 12 by MAFD | Alphanumeric
FCP12 | Result | [NAME] | Interferon gamma by MAFD | Interferon gamma by MAFD | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FCP12 | Result | Z2724 | Interleukin 4 by MAFD | Interleukin 4 by MAFD | Alphanumeric
FCP12 | Result | Z2725 | Interleukin 5 by MAFD | Interleukin 5 by MAFD | Alphanumeric
FCP12 | Result | Z2726 | Interleukin 10 by MAFD | Interleukin 10 by MAFD | Alphanumeric
FCP12 | Result | Z2727 | Interleukin 13 by MAFD | Interleukin 13 by MAFD | Alphanumeric
FCP12 | Result | Z2728 | Interleukin 1 beta by MAFD | Interleukin 1 beta by MAFD | Alphanumeric
FCP12 | Result | Z2729 | Interleukin 6 by MAFD | Interleukin 6 by MAFD | Alphanumeric
FCP12 | Result | [NAME] | Interleukin 8 by MAFD | Interleukin 8 by MAFD | Alphanumeric
FCP12 | Result | Z2731 | Tumor Necrosis Factor - alpha | Tumor Necrosis Factor - alpha | Alphanumeric