tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 163669d1340390455-vlookup-question-sample-cshadwick07-oeldere-
Sheet: Sheet2

supplier_part_no | item_desc | future_cost | effective_date
ABF TC8100 | ODR BK, 3-PRT CARBONLESS,8-3/8X10-11/16,50 ST/ | 6.8 | 2012-06-15 00:00:00
ACE 12408 | C-FIRST AID BAYER ASPIR2/PK 50PK/BX | 14.2 | 2012-06-15 00:00:00
ACE 13367 | C-MOTRIN IB 50/2-PACK | 10.7 | 2012-06-15 00:00:00
ACE 15000 | C-REFILL ADVIL 50-2/PK | 22.1 | 2012-06-15 00:00:00
ACE 19016 | C-SCISSORS,OFFICE,6",STEL STRAIGHT TRIMMERS | 4.8 | 2012-06-15 00:00:00
ACE 25001 | FIRST AID KIT 70PCSF/10 PEOPLE | 23.6 | 2012-06-15 00:00:00
ACE 40001 | C-FIRST AID KIT REFILL94PCS | 19.3 | 2012-06-15 00:00:00
ACE 41418 | C-KLEAN EARTH SCISSORS | 6.5 | 2012-06-15 00:00:00
ACE 50000 | FIRST AID KIT 613PCS FOROVER 50 PEOPLE,MTL CS | 253 | 2012-06-15 00:00:00
ACE 60002 | FIRST AID KIT 119 PCSF/15 PEOPLE | 35.4 | 2012-06-15 00:00:00
ACE 6060 | WEATHERPROOF PLASTIC BASIX #10 FIRST AID KIT | 111.96 | 2012-06-15 00:00:00
ACE 6155 | STANDARD INDUSTRIAL 3 SHELF FIRST AID STATION | 95.37 | 2012-06-15 00:00:00
ACE 6410 | 10 PERSON PLASTIC FIRST-AID KIT W/EYEWASH | 160.2 | 2012-06-15 00:00:00
ACE 6430 | WEATHERPROOF PLASTIC 25PERSON IND. FIRST AID K | 181.92 | 2012-06-15 00:00:00
ACE 90010 | ALEVE PAIN RELIEVER 1/PK50 PK/BOX | 19.3 | 2012-06-15 00:00:00
ACE 90015 | PHYSICIANSCARE PAIN RELIEVERS 50/2PKS | 12.7 | 2012-06-15 00:00:00
ACE 90016 | PHYSICIANSCARE NON ASPIRIN 50/2PK | 11.1 | 2012-06-15 00:00:00
Spreadsheet: 849080d1699630306-combine-3-sheets-data-into-1-final-sheet-book1
Sheet: Sheet4

 | Score 1 | Score 2 | Score 3 | Total
a | 10 | 0 | 4 | 14
b | 5 | 0 | 0 | 5
c | 5 | 3 | 0 | 8
D | 0 | 5 | 0 | 5
E | 0 | 0 | 6 | 6
L | 0 | 3 | 3 | 6
Spreadsheet: 187123d1350343928-need-to-return-a-value-that-might-be-in-the-row-above-or-the-row-below-help-sample-stats
Sheet: Scores

 | Team 1 |  | Team 2 |  | Team 3 |  | Team 4 |  | Team 5 |  | Team 6 |  | Team 7 |  | Team 8 |  | Team 9 |  | Team 10 |  | Team 11 |  | Team 12
Points | FOR | AGAINST | FOR | AGAINST | FOR | AGAINST | FOR | AGAINST | FOR | AGAINST | FOR | AGAINST | FOR | AGAINST | FOR | AGAINST | FOR | AGAINST | FOR | AGAINST | FOR | AGAINST | FOR | AGAINST
WEEK 1
WEEK 2
WEEK 3
WEEK 4
WEEK 5
WEEK 6 | 64.56 |  | 82.58 |  | 113.72 |  | 93.28 |  | 83.22 |  | 98.42 |  | 66.3 |  | 63.56 |  | 107.9 |  | 78.94 |  | 69.84 |  | 94.42
WEEK 7
WEEK 8
WEEK 9
WEEK 10
WEEK 11
Spreadsheet: 738304d1624963187-transposing-data-book1-51-ans2
Sheet: Raw data

Date | Year | Quarter | AUDCAD Curncy | AUDCLP Curncy | AUDCZK Curncy | AUDDKK Curncy | AUDHUF Curncy | AUDILS Curncy | AUDJPY Curncy | AUDKRW Curncy | AUDMXN Curncy | AUDNZD Curncy | AUDNOK Curncy | AUDPLN Curncy | AUDSEK Curncy | AUDCHF Curncy | AUDTRY Curncy | AUDGBP Curncy | AUDUSD Curncy | AUDEUR Curncy
2016-01-01 00:00:00 |  | a | 1.0117 | 515.673 | 18.1714 | 5.013 | 211.757 | 2.8311 | 88.085 | 855.6085 | 12.6062 | 1.0615 | 6.47467 | 2.8803 | 6.1776 | 0.7307 | 2.1262 | 0.4952 | 0.7303 | 0.6726
2017-01-02 00:00:00 | 2017 | A1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
Spreadsheet: 133496d1324421681-copy-and-transpose-problem-copy-and-transpose-problem
Sheet: Sheet1

SKU ID | Image ID #1 | Image ID #2 | Image ID #3 | Image ID #4 | Image ID #5 | Image ID #6 | Image ID #7 | Image ID #8 | Image ID #9 | Image ID #10 | Image ID #11 | Image ID #12 | Image ID #13 | Image ID #14 | Image ID #15 | Image ID #16 | Image ID #17 | Image ID #18
00154 | 43638
00152 | 43639 | 43652 | 43657 | 43719
08534 | 45885 | 45896 | 45899 | 45900 | 45902 | 45905 | 45906 | 45927 | 45929 | 45932 | 45934 | 45937 | 45938 | 45939 | 45941 | 45944 | 45947 | 45949
Spreadsheet: sally_beck__33996__MgmtSum-Q201-Global-0420
Sheet: Expense Weekly Change

ENRON GLOBAL MARKETS
2nd QUARTER 2001 EXPENSES - WEEKLY CHANGE
 |  | Direct Expenses
Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
Crude & Products
Coal
Vessel Trading
Emissions
Weather
Global Risk Markets
Financial Trading
Freight
LNG
Middle East
Puerto Rico
Finance and Structuring |  |  |  |  |  | Donation to Wharton School of Business
Office of the Chairman
Subtotal Commercial
Group
Other Interest Related Charges
Total
 |  | Operating Expenses
Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
Spreadsheet: 93854d1293632763-want-a-running-function-to-avoid-using-countif-multilookup-sort
Sheet: Trial

Sr.No | Dates | Months | Sorted Months | Sorted Months |  |  | Sorted Months Compressed | Count-If
1 | 2003-01-14 00:00:00 | 1 | 1 | 2003-01-14 00:00:00 |  | 1 | 2003-01-14 00:00:00 | 1 |  | 1 | 1 |  | 1 | 1 | 2
2 | 2004-06-28 00:00:00 | 6 | 2 | 2005-02-15 00:00:00 |  | 2 | 2005-02-15 00:00:00 | 1 |  | 2 | 1 |  | 1 | 0 | 2
3 | 2004-06-28 00:00:00 | 6 | 2 | 2005-02-15 00:00:00 |  | 2 | 2005-02-15 00:00:00 | 2 |  | 2 | 2 |  | 2 | 0 | 2
4 | 2004-06-28 00:00:00 | 6 | 3 | 2005-03-15 00:00:00 |  | 3 | 2005-03-15 00:00:00 | 1 |  | 3 | 1 |  | 1 | 0 | 2
5 | 2005-03-15 00:00:00 | 3 | 4 | 2005-04-15 00:00:00 |  | 4 | 2005-04-15 00:00:00 | 1 |  | 4 | 1 |  | 1 | 0 | 2
6 | 2005-04-15 00:00:00 | 4 | 6 | 2004-06-28 00:00:00 |  | 6 | 2004-06-28 00:00:00 | 1 |  | 6 | 1 |  | 1 | 3 | 2
7 | 2005-02-15 00:00:00 | 2 | 6 | 2004-06-28 00:00:00 |  | 6 | 2004-06-28 00:00:00 | 2 |  | 6 | 2 |  | 2 | 3 | 2
8 | 2005-02-15 00:00:00 | 2 | 6 | 2004-06-28 00:00:00 |  | 6 | 2004-06-28 00:00:00 | 3 |  | 6 | 3 |  | 3 | 3 | 2
9 | 2005-07-20 00:00:00 | 7 | 6 | 2006-06-21 00:00:00 |  | 6 | 2006-06-21 00:00:00 | 4 |  | 6 | 4 |  | 4 | 3 | 2
10 | 2005-07-20 00:00:00 | 7 | 6 | 2006-06-21 00:00:00 |  | 6 | 2006-06-21 00:00:00 | 5 |  | 6 | 5 |  | 5 | 3 | 2
11 | 2006-06-21 00:00:00 | 6 | 6 | 2008-06-27 00:00:00 |  | 6 | 2008-06-27 00:00:00 | 6 |  | 6 | 6 |  | 6 | 4 | 2
12 | 2006-06-21 00:00:00 | 6 | 7 | 2005-07-20 00:00:00 |  | 7 | 2005-07-20 00:00:00 | 1 |  | 7 | 1 |  | 1 | 2 | 2
13 | 2006-08-21 00:00:00 | 8 | 7 | 2005-07-20 00:00:00 |  | 7 | 2005-07-20 00:00:00 | 2 |  | 7 | 2 |  | 2 | 2 | 2
14 | 2008-06-27 00:00:00 | 6 | 8 | 2006-08-21 00:00:00 |  | 8 | 2006-08-21 00:00:00 | 1 |  | 8 | 1 |  | 1 | 1 | 2
Spreadsheet: 36302d1234190477-count-with-countif-sumif-sumproduct-countciscostuff
Sheet: Summary-What I Want

 |  |  |  |  | site 1 |  | put all sheet names in col f and then name the range mysheets |  |  | 4
 |  |  |  |  | site 2 |  | use the mysheets named range in the format
Type of switches | Count of Switches | IOS Type | Count |  |  |  | [NAME]:AZ1"),B1))
WS-C4503 | 4 | 12.2(25)EWA11 | 4
WS-C6506 | 4 | 12.3(14)T7 | 4 |  |  |  | change range to match largest sheet
Cisco 7206VXR (NPE-G1) | 4 | 12.2(31)SGA4 | 2 |  |  |  | also assumes all rows the same place on each sheet
WS-C3560-48PS | 2 | 12.2(35)SE5 | 22
WS-C3750-48TS | 8 | 6.4(21) | 2
WS-C4948 | 2
WS-C2950G-48 | 36
WS-C3560G-48PS | 16
WS-C2948 | 2
Spreadsheet: 120739d1315491829-autopopulate-changing-info-in-one-sheet-to-a-new-one-copy-of-combined-working-w_matpremix
Sheet: Sheet1

LOT JO# | J1222
Description | BOTTLE
Part # | 918872201
Material # | -
Colorant # | -
Machine # | 52
Mold # | BLOWMOLD
Total Quantity | 6500
U/M | EA
Quantity PER box | 200
Sample size | 32
Drawing # | 91062-0016
Additive # | 899999999
Spreadsheet: 163607d1340378280-search-for-missing-matches-copy-of-highlight-unused-numbers-problem
Sheet: Leadsheet

 |  | Actual YTD
 |  | ok |  | ok |  | ok |  | ok |  | ok |  | ok |  | 2009 |  | ok |  | ok |  | ok |  | ok |  | ok
Account | Description | July |  | August |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | TOTALS
503101 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
509323 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
509401 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
509402 |  | 130770 |  | 130770 |  | 130770 |  | 130770 |  | 130770 |  | 130770 |  | 130770 |  | 130770 |  | 130770 |  | 130770 |  | 130770 |  | 130770 |  | 1569240
509404 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
509405 |  | 4941803 |  | 4941803 |  | 4941803 |  | 4941803 |  | 4941803 |  | 4941803 |  | 4941803 |  | 4941803 |  | 4941803 |  | 4941803 |  | 4941803 |  | 4941803 |  | 59301636
509406 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
509408 |  | 5360 |  | 5360 |  | 5360 |  | 5360 |  | 5360 |  | 5360 |  | 5360 |  | 5360 |  | 5360 |  | 5360 |  | 5360 |  | 5360 |  | 64320
509409 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
509410 |  | 72095 |  | 72095 |  | 72095 |  | 72095 |  | 72095 |  | 72095 |  | 72095 |  | 72095 |  | 72095 |  | 72095 |  | 72095 |  | 72095 |  | 865140
Spreadsheet: e21e0455-3b36-478f-a7af-b27c8b6c9a48
Sheet: miR-451

miR-451 Targets
 |  | GSEA (+H+D/-H-D) | GSEA (+H-D/-H-D)
 |  | NOM p-val=0.056 | NOM p-val=0.307
Predicted | Probed | DOWN-regulated | DOWN-regulated
1110002B05RIK | 2810012G03RIK | 5730446C15RIK | 5730446C15RIK
2810012G03RIK | 5730446C15RIK | CDCA7 | AACS
2810407C02RIK | AACS | CLOCK | ACTR3
5730446C15RIK | ACTR3 | FLI1 | CDCA7
AACS | ASH1L | HERPUD1 | CLOCK
AC135108.3 | ATP11C | MLF1IP | FLI1
AC144621.3-201 | CAB39 | MYC | HERPUD1
ACTR3 | CDCA7 | TNFSF11 | [NAME]
AFF4 | CDKN2D | YTHDF2 | [NAME]
AGXT2L1 | CHN1 |  | MYC
AKTIP | CLOCK |  | TNFSF11
ANKRD46 | COTL1
ANO6 | CPEB3
ASH1L | DACH1
ATMIN | DAPK1
ATP11C | DOCK4
ATP11C | DPYS
BAZ2B | EFHD1
BCL6B | ELAVL2
[NAME] | EPB4.1L4A
BTBD3 | FLI1
CAB39 | GOPC
CDCA7 | HERPUD1
CDKN2D | HP1BP3
CHN1 | IGF2BP3
CLOCK | ITPK1
COL4A4 | LEF1
COTL1 | [NAME]
CPEB3 | [NAME]
DACH1 | MLF1IP
DAPK1 | MMD
DAPK1 | MME
DNAJC18 | MRPS27
DOCK4 | MYC
DPYS | NT5M
EDAR | PARG
EFHD1 | PELI2
EGLN3 | PMP22
ELAVL2 | PRKG2
ELOVL7 | PSEN1
EN1 | PTPN21
EPB4.1L4A | PUM1
ERG | RAC1
FBLN7 | RASGRP1
FBXW11 | SLC16A2
FGF5 | SLCO2A1
FIGN | SYNGR2
FKBP14 | TBX19
FLI1 | TIMP2
FRMD6 | TLR4
G430022H21RIK | TNFSF11
GDF6 | TUBE1
GOPC | ULK2
GYK | WNT7B
HERPUD1 | YTHDF2
HP1BP3 | YWHAZ
IGF2BP3 | ZZZ3
ITPK1
KLK7
[NAME]
LEF1
[NAME]
[NAME]
[NAME]
MLF1IP
MMD
MME
MRPS27
MTAP1B
MTAP9
MYC
NT5M
OBFC2A
ODZ2
ONECUT2
PARG
PECAM1
PELI2
PLOD2
PMP22
PPARGC1A
PRKG2
PSD2
PSEN1
PTPN21
PUM1
RAC1
RASGRP1
RAVER1
RBJ
RER1
RFT1
RP23-283N14.16
RTKN2
SAMD4B
SETD5
SLC16A2
SLC38A9
SLC43A2
SLCO2A1
[NAME]
SRXN1
STK39
SURF4
SYNGR2
TBC1D23
TBCC
TBX19
TCTEX1D4
TIMP2
TLR4
TMEM209
TMEM26
TMEM51
TMEM85
TNFSF11
TSEN15
TUBE1
ULK2
WASF1
WIF1
WNT7B
WWTR1
YBX1
YTHDF2
YWHAZ
ZFAND3
[NAME]
ZFP142
ZFP644
ZIC3
ZZZ3
Spreadsheet: 752338d1634722596-check-for-duplicates-horizontally-in-excel-extract-duplicated-values-in-line
Sheet: example to solve

index | med1 | type1 | med2 | [NAME] | med3 | [NAME] | [NAME] | type4 | med5 | type5 | med6 | type6 | [NAME] | type7 | med8 | [NAME] | duplicate1 | type9 | med10 | type10 | med11 | type11 | med12 | type12 | med13 | type13
1 |  |  | clonex | 6 | clopixol-depot | 1 |  |  | dekinet | 5 |  |  |  |  |  |  |  |  |  |  | solian | 1
3 | clopixol-ddepot | 1 | clopixol-depot | 1
7 |  |  |  |  |  |  | miro | 3 | prothiazine | 1 | seroquel | 2 |  |  | trazodil | 3 | vaben | 6
8 |  |  |  |  | dekinet | 5 | [NAME] | 3 | lorivan | 6 |  |  | seroquel | 2 | trazodil | 3
42 |  |  | clonex | 6 |  |  |  |  |  |  | nocturno | 6 |  |  | seroquel | 2
50 |  |  | clopixol | 1 | clopixol-acuphase | 1 | depalept | 7 | entumin | 1 | [NAME] | 7 |  |  |  |  |  |  | vaben | 6
60 | clopixol | 1 | quetiapine | 2 | seroquel | 2
72 | [NAME] | 4 |  |  |  |  | brotizolam | 6 | [NAME] |  | clonex | 6 | ezetimibe
94 | ariply | 2 | seroquel | 2
95 | ariply | 2 | seroquel | 2
163 | prothiazine | 1 | ronexine | 1
Spreadsheet: 66949d1267619063-investment-calculator-elite_pension
Sheet: Sheet1

 | Elite Pension II
 | Enter [NAME] |  |  | Mr.[NAME]
 | Enter Year of Birth for the Applicant |  |  | 1960 | Current Age
 | Enter Annual Premium |  |  | 1700000 | Enter Vesting Age |  | 56
 | Enter  Premium to be paid for (years) |  |  | 1 | Years in Hand
 | Minimum Coverage Term (Years) |  |  |  | Enter Pension Corpus
 | Enter [NAME] (Life Cover) |  |  | 0 | Yearly Pension Amount
 | Enter The  Expected Growth : |  |  | 0.08 | Monthly Pension
 | Fund Value Illustration for
 | Policy Year | Age | Premium | [NAME] | Charges | Net Fund added every year | As Per Expected Growth | Withdrawal  @ year end
 | 1 |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
Spreadsheet: 711466d1609738846-subtotal-not-working-in-array-extracted-database-export-performance-reg-2021
Sheet: CLIENT'S NAME

 | SL NO. | CLIENT'S NAME REFERENCE
 | 1 | TASNIAH FABRICS LTD
 | 2 | PRETTY SWEATERS LTD
 | 3 | COAST TO COAST PVT LTD
 | 4 | DICA TEX LTD
 | 5 | AHSIAR FASHIONS LTD
 | 6 | S&P BANGLA LTD
 | 7 | SF SWEATERS LTD
 | 8 | ASR SWEATER LTD
 | 9 | DANISH FOODS LTD
 | 10 | DH GLOBAL LTD
 | 11 | MMS WASTE TRADE CO
 | 12 | GOLDEN TIMES SWEATER & DYEING LTD
 | 13 | B B INTERNATIONAL
 | 14 | MASCO PRINTING & EMBROIDERY LTD
 | 15 | MASCO PICASSO LTD
 | 16 | ATM ACCESSORIES
 | 17 | EURO BANGLA ASSOCIATES
 | 18 | DIVINE TRADE INTERNATIONAL
 | 19 | YOUNGEN CORPORATION BANGLADESH
 | 20 | MR FABRICS LTD
Spreadsheet: 114218d1310020465-if-formula-sample-1x
Sheet: AAA

Subcontractor Or Staff | Purpose of Work | Period Of Performance | Task Assignment Amount | Date Invoice Paid | Date Approved | Date Submitted to F&A | Date Filed as Hard Copy | Rates | Total T&E | Hours
Staff | AAA | 3/1/10-4/2/10 | 1000 |  |  |  |  | 135 | ? | 10
Staff | BBB | 3/1/10-4/2/10 | 2000 |  |  |  |  | 125 | ? | 20
Subcontractors | CCC | 09/15/09-12/31/09 | 8000 |  |  |  |  |  | ?
Spreadsheet: 28182de3-5020-41de-9659-dc1c167d6daa
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
HIF2A | Test | HIF2A | Hypoxia-inducible Factor [NAME] (EPAS1/HIF2A) Gene, Exon 12 Sequencing | HIF2A Gene, Mutation Analysis, B | Polymerase Chain Reaction (PCR) Amplification/Sanger Sequence Analysis |  |  |  |  |  | Only orderable as part of a profile. For further information see HEMP/61337 Hereditary Erythrocytosis Mutations. | 0.5 mL |  | Only orderable as part of a profile. For further information see HEMP/61337 Hereditary Erythrocytosis Mutations. |  |  |  |  |  |  |  |  |  | Rochester
HIF2A | [NAME] | BLOOD | Whole blood |  |  |  | Refrigerated | 30 days
HIF2A | Result | 34647 | HIF2A Gene Sequencing Result | HIF2A Gene Sequencing Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 0a8791de-84e4-4eb4-bfac-22483612972b
Sheet: Criminal Justice 1

CRIMINAL JUSTICE
Associate in Applied Science
Student Name:  _________________________________________
Student ID:  ___________________________
General Education | Semester | Grade
___ ENG 101 (3) Writing I
___ ENG 102 (3) Writing II
___ COM 191 (3) Basic Public Speaking
OR COM 252 (3) Introduction to Interpersonal Communication
___ POL 101 (3) American Government
OR POL 235 (3) State Government
___ PSY 110 (3) General Psychology
___ SOC 101 (3) Introduction to Sociology
___ [NAME] (3)
___ Heritage/Humanities (3)
___ Natural Science (3-4)
___ CIT 105 (3) Introduction to Computers OR IC3 Computer Literacy Exam
___ Elective (3)
___ Elective (3)
Technical Core
___ CRJ 100 (3) Introduction to Criminla Justice
___ CRJ 216 (3) Criminal Law
___ CRJ 217 (3) Criminal Procedures
___ CRJ 204 (3) Criminal Investigations
___ CRJ 202 (3) Issues and Ethics in Criminal Justice
Corrections Option
Required
___ CRJ 102 (3) Introduction to Corrections
Electives - Choose 6 hours from the following:
___ CRJ 203 (3) Community Corrections/Probation & Patrol
___ CRJ 208 (3) Delinquency and the Juvenile Justice System
___ CRJ 220 (3) Introduction to Computer Forensics
___ CRJ 222 (3) Prison and Jail Administration
___ CRJ 231 (3) Legal Aspects of Corrections
___ CRJ 277 (3) Introduction to Criminology
___ CRJ 290 (3) Internship in Criminal Justice
___ CRJ 299 (1-3) Selected Topics in Criminal Justice
Technical Elective
___  Approved by Program Coordinator (0-3)
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 126669d1319814923-simple-vlookup-example1
Sheet: Sheet1

Name | Value
A
B
C
D
E
F
G | Yes
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
Spreadsheet: 761677d1641147681-dynamic-dropdown-in-excel-dnamic-dropdown-1-
Sheet: CoCo

 |  |  |  |  |  |  |  |  | CoCo | Acct
YEAR | MONTH | PARTNAME | SRCCoCo | TARGCoCo | ERP
 | Oct | IF1222_FM | 620662_2025 | LB_017F | BH
2021 | Oct | IF1222_FM | 370251_9001 | LB_9008 | BH
2021 | Oct | IF1222_FM | CHIADJ_9001 | LB_9008 | BH
2021 | Oct | [NAME] | CL044 | [NAME] | [NAME]
2021 | Oct | [NAME] | HSR02 | LB_T005 | [NAME]
2021 | Oct | 1C_LB_U005_FM | PR_OG00000153 | LB_U654 | 1C
2021 | Oct | 1C_LB_U125_FM | T810 | LB_T810 | 1C
2021 | Oct | 1C_LB_U005_FM | FSB_1 | LB_U317 | 1C
2021 | Oct | MC_SAP_FM | 6211 | LB_6210 | DS
2021 | Oct | [NAME] | 5500 | LB_5500 | DS
2021 | Oct | MC_SAP_FM | 6210 | LB_6210 | DS
2021 | Oct | [NAME] | 3000 | LB_3000 | DS
Spreadsheet: michelle_cash__26483__analysis revision 3
Sheet: Sheet1

CRUDE
 | Female | 40+ | 50+ | Black | Hispanic | API | AmInd
Overall | -297.9 |  |  | -55 |  | -74.7
 | >10.0 |  |  | 5.1 |  | 7
Corp | -23.2 |  |  | -15.4
 | 3 |  |  | 3.1
EA | -15.5 | -16.1 | -7 | -11.2
 | 2.4 | 2.7 | 2.1 | 3.2
EBS
EEL
EEOS | -31.5 | -50.5 | -47.2 |  |  | -6.6
 | 6.5 | 7.8 | 8.3 |  |  | 2.9
EES | -18.8 |  |  |  |  | -7.4
 | 2.8 |  |  |  |  | 2.1
EGA
EGM |  |  |  |  |  | -6.5
 |  |  |  |  |  | 2.1
EIM | -20.6 |  |  |  |  | -6.1
 | 4.4 |  |  |  |  | 2.8
ENW | -17 |  |  |  |  | -14
 | 2 |  |  |  |  | 2.1
ETS |  |  |  |  |  | -1.9
 |  |  |  |  |  | 2.5
Global EP
By JOB GROUP
 | Female | 40+ | 50+ | Black | Hispanic | API | AmInd
Overall | -139.9 |  |  | -74.5 | -40 | -28.6
 | 8.3 |  |  | 7.9 | 3.6 | 2.5
Corp
EA |  | -16.8 | -6.9 | -7.1
 |  | 3.1 | 2.1 | 2
EBS |  | -10.5
 |  | 2.4
EEL
EEOS |  |  |  | -5.7 | -13.4
 |  |  |  | 3.3 | 5
EES
EGA
EGM
EIM |  | -8.6
 |  | 2.4
ENW
ETS
Global EP
Spreadsheet: 848726d1699378603-combine-aggregated-lists-in-to-a-separate-combined-list-aggregated-lists
Sheet: Source Data

Ref NO | Vehicle | Colour
ABC030 | Ship | RED
ABC029 | Ship | GREEN
ABC023 | Plane | BLUE
ABC033 | Ship | YELLOW
ABC008 | Car | YELLOW
ABC010 | Car | BLUE
ABC036 | Ship | RED
ABC028 | Plane | BLUE
ABC022 | Plane | YELLOW
ABC034 | Ship | RED
ABC009 | Car | YELLOW
ABC003 | Train | BLUE
ABC032 | Ship | GREEN
ABC020 | Plane | RED
ABC037 | Ship | RED
ABC005 | Train | RED
ABC021 | Plane | BLUE
ABC019 | Plane | BLUE
ABC004 | Train | YELLOW
ABC035 | Ship | RED
ABC001 | Train | BLUE
ABC014 | Car | GREEN
ABC024 | Plane | RED
[NAME] | Car | BLUE
ABC007 | Car | YELLOW
ABC002 | Train | GREEN
ABC006 | Train | YELLOW
ABC027 | Plane | YELLOW
ABC011 | Car | BLUE
ABC031 | Ship | RED
ABC025 | Plane | YELLOW
ABC018 | Plane | YELLOW
ABC017 | Plane | GREEN
ABC016 | Plane | YELLOW
ABC012 | Car | GREEN
ABC026 | Plane | GREEN
ABC013 | Car | YELLOW
Spreadsheet: ae72a6cd-0e62-4cd0-b1a7-bc0f9f3ae6f5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5893 | 41159 | Charlotte | Ellis | GBR | 1025 | [NAME] | 00:02:24 | 00:32:52 | 00:02:05 | [NAME] | 1 | [NAME]
5893 | 25148 | [NAME] | Mosquera | USA | 1023 | 00:26:40 | 00:02:47 | 00:38:01 | [NAME] | 00:24:15 | 2 | 01:34:25
5893 | 30795 | Sara | Butler | GBR | 1024 | 00:12:40 | 00:01:53 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 769157d1645356094-iferror-index-and-match-return-0-xlsx-test-1-
Sheet: Sheet2

 | [NAME]
Product | ATR 1 | ATR 1 Value
Product1 | Component1
Product2 | Component2
Product3 | Component3
Product4 | Component4
Product5 | Component5
Product1 | Component1
Product7 | Component7
Product8 | Component8
Product2 | Component2
Product10 | Component10
Product11 | Component11
Product1 | Component1
Product13 | Component13
Product2 | Component2
Product2 | Component2
Spreadsheet: 888937d1739559326-calendar-conditional-formatting-and-between-date-range-highlights-building-calendar
Sheet: Events

 | Events
 | Start Date | End Date | Group1 | Group2 | Group3 | Group4 | Group5
 | 2025-02-04 00:00:00 | 2025-02-06 00:00:00 | test | WOW
 | 2025-02-15 00:00:00 | 2025-02-18 00:00:00 |  | OKAY
 | 2025-02-20 00:00:00 | 2025-02-21 00:00:00 | One
 | 2025-02-05 00:00:00 | 2025-02-05 00:00:00 | 100
 | 2025-02-21 00:00:00 | 2025-02-22 00:00:00 |  |  | Test
Spreadsheet: 266458d1379617782-formula-for-each-month-and-number-count-for-exceptions-setup-exception-tracking-by-ae-example
Sheet: Roger

Date | Company | Broker | Processor | [NAME]. Last | Loan # (Last 5) | Exception reason | Exceptions | Submissions | Exception %
2013-03-31 00:00:00 |  |  |  |  |  |  | 0 | 12
2013-04-05 00:00:00 | Metropolitan Acceptance | [NAME] | [NAME] | Gruemmer | 37409 | asset statement missing pgs
2013-04-23 00:00:00 | Mortgage Grader | [NAME] | [NAME] | [NAME] | 37762 | signed 4506T | 2 | 20
2013-05-21 00:00:00 | Metropolitan Acceptance | [NAME] | [NAME] | Dennison | 39046 | missing 2012 W2 | 1 | 26
2013-06-26 00:00:00 | Mortgage Grader | [NAME] | [NAME] | Pierce | 39649 |  | 1 | 13
2013-07-19 00:00:00 | Metropolitan Acceptance | [NAME] | [NAME] | Spendlove | 40304 | asset statement missing pgs | 1 | 26
2013-08-27 00:00:00 | Metropolitan Acceptance | [NAME] | [NAME] | Marcu | 41006 | asset >45 | 1 | 13
Spreadsheet: 542059d1507702210-help-with-dropdown-list-question
Sheet: PAGE 2

FOOD
APPLE
AVOCADO
TUNA
APPLE
AVOCADO
TUNA
APPLE
AVOCADO
TUNA
APPLE
AVOCADO
TUNA
APPLE
AVOCADO
TUNA
APPLE
AVOCADO
TUNA
APPLE
AVOCADO
TUNA
APPLE
AVOCADO
TUNA
APPLE
AVOCADO
TUNA
APPLE
AVOCADO
TUNA
APPLE
AVOCADO
TUNA
APPLE
AVOCADO
TUNA
APPLE
AVOCADO
TUNA
APPLE
AVOCADO
TUNA
APPLE
AVOCADO
TUNA
APPLE
AVOCADO
TUNA
APPLE
AVOCADO
TUNA
APPLE
AVOCADO
Spreadsheet: 830276d1684840765-excel-fomular_index-match-and-min-max-fomular
Sheet: Sheet7

 |  |  |  |  |  |  |  |  |  | RESULT WITH FOMULAR HERE
Month | Printer Type | Brand | Model No. | AAA | Source | BBB | Source | CCC | Source | Best Price Offering | [NAME] | Minimum Price
 |  |  |  | 4690 |  | 4390 |  | 3750 |  |  |  |  | if have price > 0 in 3 column this fomular will work
 |  |  |  | 5690 |  | 0 |  | 0 |  |  |  |  | if have min = 0 for 2 value, this formular will work
 |  |  |  | 0 |  | 7890 |  | 7790 |  |  |  |  | if have min = 0 only 1 value.it is false. i need to show CCC (7790 best price)
 |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  | if have min = 0 for all column. This fomular will work
 |  |  |  | 5955 |  | 5695 |  | 5695 |  |  |  |  | if have duplicate price >2 column.formular match first column to found BBB but actual, I need to show BBB&CCC
 |  |  |  | 0 |  | 5695 |  | 5695 |  |  |  |  | if have duplicate price >2 column and found 0.formular match first column to found BBB but actual, I need to show BBB&CCC
 |  |  |  |  |  |  |  |  | if use Min function will be count 0 .please suggest the best one fomular to cover all result?