tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 025ba753-377d-44cc-b462-db100f888ee1
Sheet: Sheet1

Calamity Waiver Request Form
District Name
County
District IRN
Contact Person Name
Contact Person Phone
Contact Person E-mail
THIS REQUEST:
Date of Calamity
Calamity Scope: (All Bldgs or Some Bldgs)
If NOT all bldgs: Enter building IRNs
Calamity Type  (A-E; see notes below)
Calamity Specific Description
SUMMARY:
Number of Districtwide  Calamity Days Used
Number of Districtwide  Calamity Days Remaining
Contingency Days:  Number to be used for make-up
Contingency Days:  Dates to be used
In ADDITION to Districtwide days:
Building IRN
Number of calamity days used for building
Number of calamity days remaining for building
Building Contingency Days:  Number to be used for make-up
Building Contingency Days: Dates to be used
Notes:
Calamity Day Types/descriptions:
A:  Disease epidemic -- description should indicate type of epidemic such as flu, meningitis, staph, etc.
B:  Hazardous Weather Conditions -- description should indicate type of condition such as excessive heat, fog, flooding, snow, ice, etc.
C:  Inoperability of school buses or other equipment -- description should indicate type of equipment damage such as damage to buses, furnace failure, etc.
D:  Damage to a school building -- description should include nature of damage such as toxic chemical spill, broken windows, collapsed wall/roof, etc.
E:  Other circumstances due to utility failure -- description should include nature of utility failure such as power outage, water shutoff, water main break, gas shutoff, gas line break, sewer backup, etc.
Spreadsheet: 99061d1297832105-help-using-lookup-for-multiple-positions-in-fantasy-baseball-draft-bb-dft2
Sheet: SS

Column1 | First name | Last Name | Team | Owner
1 | Hanley | [NAME], | FLA
2 | Troy | Tulowitzki, | COL
3 | Derek | Jeter, | NY-A
4 | [NAME] | Reyes, | NY-N
5 | Stephen | Drew, | AZ
6 | Alexei | [NAME], | CHI-A
7 | [NAME] | Rollins, | PHI
8 | Starlin | [NAME], | CHI-N
9 | Elvis | Andrus, | TEX
10 | Ian | [NAME], | WAS
11 | Yunel | Escobar, | TOR
12 | Cristian | Guzman,
13 | Orlando | Cabrera,
14 | [NAME] | Scutaro, | BOS
15 | Rafael | Furcal, | LA
16 | Asdrubal | Cabrera, | CLE
17 | Erick | Aybar, | ANA
18 | [NAME] | [NAME], | SD
19 | Cliff | Pennington, | OAK
20 | Miguel | Tejada, | SF
21 | [NAME] | Hardy, | BAL
22 | [NAME] | Peralta, | DET
23 | [NAME] | Theriot, | STL
24 | [NAME] | Brignac, | TB
25 | Yuniesky | Betancourt, | MIL
26 | Jed | [NAME], | BOS
27 | [NAME] | [NAME], | ATL
28 | [NAME] | [NAME], | CLE
29 | Ronny | Cedeno, | PIT
30 | Alcides | Escobar, | KC
31 | [NAME] | [NAME], | WAS
32 | Alexi | Casilla, | MIN
33 | Everth | Cabrera, | SD
34 | [NAME] | Ryan, | SEA
35 | Edgar | Renteria, | CIN
36 | [NAME] | Wilson, | SEA
37 | [NAME] | Janish, | CIN
38 | Cesar | Izturis, | BAL
39 | Adrian | Cardenas, | OAK
40 | [NAME] | [NAME], | COL
41 | Eduardo | Nunez, | NY-A
42 | Tyler | Greene, | STL
43 | Ruben | Tejada, | NY-N
44 | Adeiny | Hechavarria, | TOR
45 | [NAME] | Gordon, | LA
46 | Grant | Green, | OAK
47 | [NAME] | Iglesias, | BOS
Spreadsheet: 599842d1543332255-need-to-calculate-different-pay-periods-for-different-pay-rates-copy-of-nannies-time-ans-tfuller423-
Sheet: Ingrid Theron

[NAME]
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |  |  |  | Day Hours | 07:00:00 | 21:00:00
Time In | 07:30:00 | 07:30:00 | 07:30:00 | 07:30:00 | 22:00:00 |  |  |  |  |  | Night Hours | 21:00:00 | 07:00:00
Time Out | 09:00:00 | 11:30:00 | 09:00:00 | 09:00:00 | 01:00:00
Time In | 11:30:00 | 15:30:00 | 11:30:00 | 15:30:00 | 00:00:00 |  |  |  |  |  | Cleaning hours are subtracted from the period that has the most hours. Daily
Time Out | 20:15:00 | 20:15:00 | 20:15:00 | 20:30:00 | 03:00:00
Time In |  |  |  |  | 04:00:00
Time Out |  |  |  |  | 06:00:00
Total Hours
Cleaning Hours | 2 | 2 | 2 | 2 | 2
Nanny Day
Nanny Night
Cleaning Day
Cleaning Night
Spreadsheet: 537021d1504793904-how-to-setup-a-record-in-a-table-that-may-have-multiple-rows-of-data-in-a-certain-field-how-to-setup-a-record-in-a-table-that-may-have-multiple-rows-of-data-in-a-certain-fiel
Sheet: Sheet1

[NAME] | Customer | Item | Quantity |  | [NAME] | Customer | Item | Quantity
1 | AAAA | Product1 | 2
1 | AAAA | Product2 | 1
2 | BBBB | Product3 | 4
2 | BBBB | Product1 | 2
2 | BBBB | Product4 | 1
3 | CCCC | Product1 | 3
4 | DDDD | Product3 | 5
5 | DDDD | Product1 | 2
3 | CCCC | Product2 | 3
Spreadsheet: 329340d1404280152-index-match-smallest-return-sample
Sheet: Sheet1

Amount | Reason for Movement | 2250
-183.25 | 2150 | first smallest return
-366.61 | 2150 | second smallest return
-61.1 | 2154 | third smallest return
-91.65 | 2150
-4.34 | 2450
-12.7 | 2250
-2.98 | 2250
-2.98 | 2250
-69.37 | 2452
-0.6 | 2451
-4.49 | 2250
-4.49 | 2250
-4.14 | 2250
-4.7 | 2250
-4.55 | 2250
-4.85 | 2250
-1.41 | 2250
-14.11 | 2250
-8.47 | 2250
Spreadsheet: errol_mclaughlin_jr__10716__Rpt PMA Log Errol 1001
Sheet: Sheet1

As of October 2001 Accounting
Resp | Adjustment Requested By | Bookcode | Month | Description | Risk
[NAME] | [NAME] | FPL Hedge (G&) | 2000 | One Liquidation came through for Aug NT4811; Not in DPR | -159803
[NAME] | [NAME] | FPL Hedge (G&) | 2000 | MTM | 117313
[NAME] | [NAME] | FPL Hedge (G&) | 2000 | Rounding | 1100
[NAME] | [NAME] | NG PRICE ( PG ) | Jan | Citibank; deal NN6788.1 killed in TAGG (03/01); however value liquidated for 12/00-02/01 and was captured in DPR. | -1513150
 |  |  |  | From what I have discovered, yes, DPR should delete deal NN6788.1 from its records what it shows is: Dec. 296,205; Jan. 910,625 and Feb. 306,320. These amounts total our difference of 1,513,150. The amount was paid back to Citibank on 4/12/01 due to a dispute
[NAME] | [NAME] | NG PRICE ( PG ) | Aug | Rounding | -2060.85
[NAME] | [NAME] | NG PRICE ( PG ) | Feb | Tauber Oil; deal NP3253.3 settled at correct float of 9.788 (NX3); liquidated at 9.98 (NX1); See Deal Clearing for contract revision in float pricing | -577920
[NAME] | [NAME] | NG PRICE ( PG ) | Jan | Roll 4 Post ID Variance; EOL Gas Daily | -7123598
[NAME] | [NAME] | NG PRICE ( PG ) | Jan | [NAME]; add Premiums QF8905.3 <624,750> & QF8905.1 <416,500> Settlements inv 01011272; did not liquidate with value. Zero premium price in TAGG | -1041250
[NAME] | [NAME] | NG PRICE ( PG ) | Oct | 1001 Broker Fees | -838514
[NAME] | [NAME] | NG PRICE ( PG ) | Oct | Roll 4 Post ID Variance; EOL Gas Daily | -3307891
[NAME] | [NAME] | NG Price Options (ZH) | Aug | Rounding | -163.74
[NAME] | [NAME] | NG Price Options (ZH) | Oct | 1001 Broker Fees | -125777
[NAME] | [NAME] | NG Price Options (ZH) | Sep | VU2448.2 value difference with inner book (PG Swap) | 27000
[NAME] | [NAME] | NG Price Options (ZH) | Sep | VU2448.1 not in DPR (PG Swap) | -88020
[NAME] | [NAME] | NG-X-OPT-NG ( )B) | Aug | Deals not in DPR;Y00809.1; Y00809.2 Inner book swap with Options book; Premium | 372000
[NAME] | [NAME] | NG-X-OPT-NG ( )B) | Aug | Rounding | -56.58
[NAME] | [NAME] | NG-X-OPT-NG ( )B) | Oct | Y46749.1 & Y62152.2; Difference in value; Inner Book Swaps | 3650
[NAME] | [NAME] | NG-X-OPT-NG ( )B) | Sep | Gas Daily Variances | 3035.58
[NAME] | [NAME] | NG-X-OPT-WTI ( )C) | Oct | Current Month Rho & Drift not included in WTI roll in current month LTD value | 710
Spreadsheet: 94872d1294646968-dynamically-finding-the-capacity-shortage-test_shortage
Sheet: Ark1

ACHIEVED |  |  |  |  |  |  |  |  |  |  | EXPECTED
Demand | Total Demand | Capacity | Shortage |  |  | [NAME] | 20 |  |  |  | Demand | Total Demand | Capacity | Shortage |  |  | [NAME] | 20
2 |  | 20 | #N/A |  |  | Max2 | 18 |  |  |  | 2 |  | 20 |  |  |  | Max2 | 18
4 | 14 | 20 | #N/A |  |  |  |  |  |  |  | 4 | 14 | 20
8 |  | 20 | #N/A |  |  |  |  |  |  |  | 8 |  | 20
4 |  | 20 | #N/A |  |  |  |  |  |  |  | 4 |  | 20
3 | 13 |  | 16 |  |  |  |  |  |  |  | 3 | 13 |  | 3
6 |  |  | #N/A |  |  |  |  |  |  |  | 6 |  |  | 6
6 |  | 5 | #N/A |  |  |  |  |  |  |  | 6 |  | 5 | 6
6 | 20 | 10 | #N/A |  |  |  |  |  |  |  | 6 | 20 | 10 | 10
8 |  | 15 | #N/A |  |  |  |  |  |  |  | 8 |  | 12
8 |  | 18 | #N/A |  |  |  |  |  |  |  | 8 |  | 14
4 | 18 | 20 | #N/A |  |  |  |  |  |  |  | 4 | 18 | 16 | 2
6 |  | 20 | #N/A |  |  |  |  |  |  |  | 6 |  | 18
6 |  | 18 | #N/A |  |  |  |  |  |  |  | 6 |  | 20
3 | 14 | 16 | #N/A |  |  |  |  |  |  |  | 3 | 14 | 20
5 |  | 20 | #N/A | =SUM(IF(C18="";A18;"");IF(OR(C18=$H$3;C18>0,8*$H$4;B18="");"";B18-C18)) |  |  |  |  |  |  | 5 |  | 16
Spreadsheet: 737480d1624438914-calculating-4threads-my-excel-sheet-is-not-calculating-correctly-working-excel-example
Sheet: Eikon Transformed

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38
CIK | CUSIP | Name | IPO Status | Dependent Variable | IPO Date (from Code) | Month | Day | Year | IPO Month | IPO Year | IPO Date | Start Date Hot Market | End Date Hot Market | 90 days average | Hot Market Dummy | Year [NAME] | Month | Day | Year | [NAME] | [NAME] | SIC | Financial Service | Education | High-Tech Dummy | [NAME] | [NAME] Dummy | [NAME] EIKON | [NAME] EIKON [NAME] | PE Backing Eikon | PE Backing Eikon Dummy | [NAME]Ritter/Eikon) | [NAME] (Eikon/Eikon) | MonthYear | Benchmark Index | Volatility | Spread | Interest Rates
1451809
1729427
1673772
1706431
1734517
1703647
1781983
1650648
1639825
1561550
1274737
1757073
1758021
1775625
Spreadsheet: 846467d1697647958-populate-worksheet-based-on-checkboxes-example-workbook
Sheet: OUTPUT

Requested Courses
Internal Code | Product | Course type | Price (£)
P1-OP | P1 | Operation | 50
P1-DI | P1 | Diagnostics | 25
P3-AD | P3 | Administration | 30
Total Cost
No. Courses required |  |  | 3
Spreadsheet: 122739d1317124678-excel-2007-lookup-find-next-need-help-help
Sheet: Rest of Asia 

projects/cost centers |  |  | land | region | employee | sales project hours
1401058 - Malabo airport | 1401058 | ID | Indonesia | Rest of Asia | 3713 - Visser- Jans, K. | 2.25
1401058 - Malabo airport | 1401058 | ID | Indonesia | Rest of Asia | 3835 - Donsbach- Rijt, [NAME] | 14
1401058 - Malabo airport | 1401058 | ID | Indonesia | Rest of Asia | 4246 - Cappendijk, E. | 7
1401083 - Bangkok International Airport | 1401083 | TH | Thailand | Rest of Asia | 917 - Aben, S. | 8
1471026 - Hambantota Airport | 1471026 | LK | [NAME] | Rest of Asia | 3713 - Visser- Jans, K. | 0.5
1471026 - Hambantota Airport | 1471026 | LK | [NAME] | Rest of Asia | [NAME], [NAME] | 8
1471029 - Bandaranaike AP check in-ext. | 1471029 | LK | [NAME] | Rest of Asia | 2029 - Geurts HJM | 8
1471029 - Bandaranaike AP check in-ext. | 1471029 | LK | [NAME] | Rest of Asia | 3713 - Visser- Jans, K. | 0.25
1471029 - Bandaranaike AP check in-ext. | 1471029 | LK | [NAME] | Rest of Asia | 6445 - Reineke, [NAME] | 2
1471030 - Bandaranaike AP Self check in | 1471030 | LK | [NAME] | Rest of Asia | 6445 - Reineke, [NAME] | 2
Spreadsheet: 0f943d1e-590c-4b2c-8d51-192e54557b3b
Sheet: Sheet1

COLLEGE FOR ALL TEXANS FOUNDATION
ITEMIZATION OF TRAVEL EXPENSES FOR REIMBURSEMENT
[NAME]'s Name: |  |  |  |  | Dates of Travel:
[NAME] (Person or Institution):
Address to send reimbursement*: |  |  |  |  |  |  |  |  |  | YES
City: |  |  |  | State: |  | Zip Code: |  |  |  | NO
Phone: |  |  |  | [NAME]:
Destination: |  |  |  | Purpose: |  |  |  |  |  | HOME
TRANSPORTATION (Receipts Required) |  |  |  |  |  |  |  |  |  | WORK
DD = Drop Down Menu |  |  |  |  |  | Subtotal by Category: |  |  |  | AIRPORT
Rental Car (Receipts Required): |  |  |  | Amount: |  |  |  |  |  | HOTEL
Airline (Receipts Required): |  |  |  | Amount: |  |  |  |  |  | MTG SITE
Personal Car: (Please include Mapquest documentation, only one airport round trip mileage allowed)
From: |  | To: |  | [NAME]: |  | x $0.555/mi
From: |  | To: |  | [NAME]: |  | x $0.555/mi
From: |  | To: |  | [NAME]: |  | x $0.555/mi
From: |  | To: |  | [NAME]: |  | x $0.555/mi
Taxi/Shuttle: ([NAME] do not reimburse when free hotel shuttle is available)
From: |  | To: |  | Amount:
From: |  | To: |  | Amount:
From: |  | To: |  | Amount:
From: |  | To: |  | Amount:
Meals: (Receipts Required; Maximum $36 per day; alcoholic beverages exluded from reimbursement)
Date: |  |  | Claiming:
Date: |  |  | Claiming:
Date: |  |  | Claiming:
Date: |  |  | Claiming:
Date: |  |  | Claiming:
Lodging:  (Receipts Required; Maximum $129 per night, including City/State taxes)
Date: |  |  | Claiming:
Date: |  |  | Claiming:
[NAME] TRAVEL EXPENSES (Receipts Required for all Claimed Expenses)
Parking:  (Receipts Required)
Location: |  |  |  | Claiming:
Location: |  |  |  | Claiming:
Baggage Fees:  (One per flight allowed) |  |  |  | Claiming:
Telephone Calls:  (Business Only) |  |  |  | Claiming:
Gasoline for Rental Car:  (Receipts Required) |  |  |  | Claiming:
Toll Charges:  (Receipts Required) |  |  |  | Claiming:
 |  |  |  |  | Total Amount Claimed:
*Reimbursement will be issued from the College for All Texans Foundation
For reimbursement, please return completed form and receipts within 10 business days of travel to:
[NAME]
Academic Planning and Policy |  |  |  | I CERTIFY THIS REIMBURSEMENT IS CORRECT:
Texas Higher Education Coordinating Board
P.O. Box 12788, [NAME], TX  78711 |  |  |  | SIGNATURE:
[NAME]:  [EMAIL]
Spreadsheet: 141545d1329323951-wrapping-a-max-function-around-an-if-statement-example-max
Sheet: Matrix

Vehicle Registration Number | Branch Code | Area | Regional Trading Director | Area Trading Manager | Network Manager | Idling Time | Driving Time | GVW | Idling Cost | % Of Idle Time
 |  |  |  |  |  |  |  |  |  |  | 76
Spreadsheet: darrell_schoolcraft__7816__imbalsumm0109
Sheet: burlington

56423
Day | Measured | Scheduled | Imbal
1 | 138938 | 139223
2 | 155682 | 154223
3 | 147918 | 148033
4 | 149887 | 152957
5 | 124579 | 124223
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-08-31 00:00:00 |  |  | 6256
2001-09-05 00:00:00
CBS Volume
 |  |  | 1478
Spreadsheet: 536784d1504684941-summary-report-from-data-sheet-summary
Sheet: REQUIRED

REQUIRED REPORT- IN SUMMARY
Particulars | Qty | b | c | d | e | Total
SLB 335 mm | 200
KLP 9 mm
JSP 11 mm
Spreadsheet: 4e8f1d64-d5ff-4f0d-ad3a-5b4505c01c9f
Sheet: Sheet1

FICHE DE CANDIDATURE | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
I - CANDIDAT
NOMS ET PRENOMS |  |  |  |  |  |  | e-mail:
ADRESSE |  |  |  |  |  |  | [NAME] actuel:
AGE
DIPLÔME EXIGE POUR LE POSTE
TELEPHONE
DATE DE NAISSANCE |  |  | LIEU DE NAISSANCE | NATIONALITE ACTUELLE | [NAME] |  | [NAME]
Jour | Mois | Année |  |  | M | F | Célibataire |  |  | Marié(e)
 |  |  |  |  |  |  |  |  |  | Date
PERSONNES A CHARGE |  |  | (CONJOINT ET ENFANT LEGITIME OU ADOPTES LEGALEMENT)
NOMS |  |  |  | DATE DE NAISSANCE |  |  | LIEN DE PARENTE
II -ETUDES
NIVEAU D'ETUDE |  | ANNEE D'OBTENTION |  | [NAME] DIPLÔME OU CERTIFICAT |  |  | ETABLISSEMENT DE DELIVRANCE
LANGUE |  |  | LECTURE |  |  | ECRIS |  |  | PARLER
 |  |  | [NAME] | [NAME] | Passable | [NAME] | [NAME] | Passable | [NAME] | [NAME] | Passable
II - EXPERIENCES PROFESSIONNELLES
NBRE | POSTE(S) OCCUPE(S) |  |  | EMPLOYEUR(S) |  | SALAIRE | Durée |  |  |  | Total (année / mois)
 |  |  |  |  |  |  | De |  | A
 |  |  |  |  |  |  | Mois / Année |  | Mois / Année
1
2
3
4
5
6
7
SOMME ANNEE D'EXPERIENCE (ANNEE / MOIS) |  |  |  |  |  |  |  |  |  |  |  | 12
II-STAGE(S) LE(S) PLUS IMPORTANT(S)
ENTREPRISES / ORGANISMES |  |  |  | CONTENUS |  |  |  |  | DUREE (MOIS) |  | DATE
Spreadsheet: 162531d1339950327-sum-of-multiple-match-formula-requirement
Sheet: Sheet1

Type | Code | Amount
A | Z001 | 100 |  | Requirement: Sum of Column "C" where Column "B" equals a particular code and Column "A" cells contain values in any one of the cells in Range "K4:K6".
B | Z001 | 125
C | Z001 | 110
D | Z001 | 135 |  |  |  |  |  |  | Match
E | Z001 | 150 |  | e.g. | Result |  |  |  | B
F | Z001 | 105 |  | Z001 | 365 |  |  |  | D
G | Z001 | 100 |  |  |  |  |  |  | F
A | Z002 | 102
B | Z002 | 109 |  | - How to get this result via a single formula ??? Important point is: "Sumproduct" & "Sumifs" formulas should not be used as this will consume lot of time in large databases.
C | Z002 | 111
D | Z002 | 145
E | Z002 | 137
F | Z002 | 100
G | Z002 | 125
A | Z003 | 110
B | Z003 | 135
C | Z003 | 150
D | Z003 | 105
E | Z003 | 100
F | Z003 | 102
G | Z003 | 109
A | Z004 | 111
B | Z004 | 145
C | Z004 | 137
D | Z004 | 100
E | Z004 | 125
F | Z004 | 110
G | Z004 | 135
A | Z005 | 150
B | Z005 | 105
C | Z005 | 100
D | Z005 | 102
E | Z005 | 109
F | Z005 | 111
G | Z005 | 145
Spreadsheet: 793303d1661407477-using-iferror-to-sort-data-into-groups-not-working-grouping-test-non-365-aligw
Sheet: Grouping

Group | Invoice |  |  | Group
Y | INV-110635 |  |  | A | X | Y | Z
A | INV-110881
A | INV-110878
A | INV-110874
A | INV-110883
A | INV-110882
A | INV-110865
A | INV-110863
A | INV-110876 | wrong group
Y | INV-110879 | wrong group
A | INV-110875
A | INV-110886
A | INV-110861
A | INV-110941 | missing
X | INV-110934
A | INV-110937
A | INV-110930
A | INV-110923
A | INV-110933
A | INV-110940
A | INV-110915
A | INV-110942 | missing
Z | #N/A
A | INV-110943
A | INV-110939 | missing
#N/A | #N/A
A | INV-110938
A | INV-110947
A | INV-110927
A | INV-110924 | missing
X | INV-110993 | missing
#N/A | #N/A
A | INV-110999
A | INV-110983 | wrong group
X | INV-110991 | wrong group
A | INV-110982
A | INV-110995
A | INV-111000
A | INV-110996
A | INV-110985
A | INV-110988
A | INV-110997 | wrong group
X | INV-111049
X | INV-111033 | wrong group
A | INV-111055
A | INV-111052
A | INV-111038
A | INV-111035
A | INV-111032 | wrong group
X | INV-111054 | wrong group
A | INV-111056
A | INV-111059 | wrong group
Z | #N/A
#N/A | #N/A
A | INV-111099
A | INV-111108
A | INV-111135
A | INV-111118
A | INV-111098
A | INV-111094
A | INV-111112
A | INV-111130
A | INV-111120
A | INV-111111
A | INV-111119
A | INV-111104
A | INV-111114
A | INV-111113
A | INV-111096
A | INV-111208
A | INV-111177
A | INV-111169
A | INV-111198
A | INV-111188
A | INV-111165
A | INV-111182
A | INV-111181
A | INV-111246
A | INV-111238
A | INV-111247
A | INV-111252
A | INV-111242
A | INV-111254
A | INV-111251
A | INV-111233
A | INV-111248
A | INV-111236
A | INV-111259
A | INV-111229
A | INV-111234
A | INV-111241
A | INV-111298
A | INV-111303
A | INV-111289
A | INV-111293
A | INV-111297
A | INV-111302
A | INV-111294
A | INV-111312
A | INV-111355
A | INV-111363
A | INV-111382
A | INV-111350
A | INV-111351
A | INV-111352
Y | INV-111373
A | INV-111346
A | INV-111358
A | INV-111407
A | INV-111426
A | INV-111413
A | INV-111422
A | INV-111403
A | INV-111415
A | INV-111410
A | INV-111404
A | INV-111367
A | INV-111432
Spreadsheet: 756494d1637598610-index-match-formula-doesnt-work-example
Sheet: Data

 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | >48
 | BM | 5 | 10 | 15 | 20 | 20 | 25 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72
 | DM | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81
Spreadsheet: 0a8791de-84e4-4eb4-bfac-22483612972b
Sheet: Criminal Justice 2

CRIMINAL JUSTICE
Student Name:
ID #
Law Enforcement Option
Required | Semester | Grade
___ CRJ 215 (3) Introduction to Law Enforcement
Electives - Choose 6 hours from the following:
___ CRJ 201 (3) Introduction to Criminalistics
___ CRJ 208 (3) Delinquency and the Juvenile Justice System
___ CRJ 218 (3) Police Supervision
___ CRJ 220 (3) Introduction to Computer Forensics
___ CRJ 230 (3) Criminal Justice Courtroom Procedures
___ CRJ 277 (3) Introduction to Criminology
___ CRJ 279 (3) Terrorism and Poolitical Violence
___ CRJ 290 (3) Internship in Criminal Justice
___ CRJ 299 (1-3) Selected Topics in Criminal Justice
___ Technical Elective (0-3) Approved by Program Coordinator
Criminal Justice Option
Electives - Choose 9 hours from the following:
___ CRJ 102 (3) Introduction to Corrections
___ CRJ 110 (3) Principles of Asset Protection
___ CRJ 201 (3) Introduction to Criminalistics
___ CRJ 203 (3) Community Corrections/Probation & Parole
___ CRJ 208 (3) Delinquency and the Juvenile Justice System
___ CRJ 210 (3) Physical Security Technology and Systems
___ CRJ 211 (3) Liability and Legal Issues
___ CRJ 215 (3) Introduction to Law Enforcement
___ CRJ 218 (3) Police Supervision
___ CRJ 220 (3) Introduction to Computer Forensics
___ CRJ 230 (3) Criminal Justice Courtroom Procedures
___ CRJ 231 (3) Legal Aspects of Corrections
___ CRJ 240 (3) Introduction to Corporate & Industrial Security
___ CRJ 245 (3) Introduction to Corporate & Financial Fraud
___ CRJ 277 (3) Introduction to Criminology
___ CRJ 279 (3) Terrorism and Poolitical Violence
___ CRJ 290 (3) Internship in Criminal Justice
___ CRJ 299 (1-3) Selected Topics in Criminal Justice
___ Technical Elective (0-3) Approved by Program Coordinator
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 131877d1323364172-match-one-cell-to-another-cell-copy-of-ask-excel2
Sheet: Sheet1

Column A | Column B | New Column
A225522 | A225522 | A225522
A225523 | A225620
A225599 | A225628
A225620 | A225533 | A225620
A225625 | A225538
[NAME]
A225628 |  | A225628
A225629
A225533 |  | A225533
A225534
A225538 |  | A225538
A225539
Spreadsheet: 33081d1229365775-list-without-repetitions-duplicate-list
Sheet: Sheet1

 |  |  | Item | Summary
 |  | manual input column-> | 1 | 1 | <- expected output column
 |  |  | 3 | 3 | only lists each duplicate item once
 |  |  | 2 | 2
 |  |  | 8 | 5
 |  |  | 5 | 4
 |  |  | 6
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | 3
 |  |  | 7
 |  |  | 1
 |  |  | 3
 |  |  | 4
 |  |  | 2
 |  |  | 9
Spreadsheet: 737901d1624646451-function-for-permutation-and-combination-example
Sheet: Sheet1

Few example of permutation and combination |  |  |  |  |  | Given
A | B | C | D | TOTAL |  | Total of | A+B+C+D=7 | is always 7
1 | 2 | 1 | 3 |  |  | Possible numbers are only:
2 | 0 | 3 | 2 |  |  |  | 0,1,2,3,4,5,6,7
1 | 1 | 2 | 3 |  |  | Objectives
0 | 3 | 2 | 2 |  |  | all permutation  & combination of  0 to 7
2 | 2 | 2 | 1
0 | 0 | 6 | 1
2 | 1 | 4 | 0
3 | 3 | 0 | 1
7 | 0 | 0 | 0
1 | 1 | 1 | 4
 |  |  |  |  |  | Thanks