tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 456487d1460905911-if-function-referencing-table-test1
Sheet: Data

Order number | Item ordered | Date ordered | Customer number
1 | Apple | 2016-01-01 00:00:00 | 59
2 | Carrot | 2016-01-01 00:00:00 | 60
3 | Orange | 2016-01-01 00:00:00 | 61
4 | Sweetcorn | 2016-01-01 00:00:00 | 62
5 | Apple | 2016-01-02 00:00:00 | 63
6 | Carrot | 2016-01-03 00:00:00 | 64
7 | Orange | 2016-01-04 00:00:00 | 65
8 | Apple | 2016-01-05 00:00:00 | 66
9 | Carrot | 2016-01-05 00:00:00 | 67
10 | Sweetcorn | 2016-01-05 00:00:00 | 68
11 | Apple | 2016-01-05 00:00:00 | 69
12 | Apple | 2016-01-05 00:00:00 | 70
13 | Carrot | 2016-01-05 00:00:00 | 71
14 | Sweetcorn | 2016-01-05 00:00:00 | 72
15 | Orange | 2016-01-06 00:00:00 | 73
16 | Apple | 2016-01-06 00:00:00 | 74
17 | Sweetcorn | 2016-01-07 00:00:00 | 75
18 | Carrot | 2016-01-07 00:00:00 | 76
19 | Apple | 2016-01-07 00:00:00 | 77
20 | Sweetcorn | 2016-01-07 00:00:00 | 78
Spreadsheet: 82765d1282781623-extract-data-to-different-workbook-example-workbook
Sheet: 8

 |  |  | 2008-01-08 00:00:00
Location | Trips | Liters | Gallons
[NAME] | 1 | 378.5 | 100
Centurion | 2 | 757 | 200
Dragon | 3 | 1135.5 | 300
Bldg 0039 | 4 | 1514 | 400
Fac 1 | 5 | 1892.5 | 500
Man | 6 | 2271 | 600
Dog Pen | 7 | 2649.5 | 700
Canal | 8 | 3028 | 800
Hot | 9 | 3406.5 | 900
Fac2 | 10 | 3785 | 1000
 | 55 | 20817.5 | 5500
 | 440 | 166540 | 44000
Spreadsheet: 131efe8f-ac98-4618-ad14-c003daf70f09
Sheet: Sheet1

Ref # | Part # | Description | Notes
AG2 | 026769-Z | HANDLEBAR ASSEMBLY | Includes Heart rate contacts
AT1 | 013878-B | SAFETY KEY ASSEMBLY
COS | 066990-ZUP | OVERLAY CONSOLE ASSEMBLY T98007 HRT | Only overlay and touch pads Has programs marking
COS | 066991-ZUP | OVERLAY CONSOLE ASSEMBLY T98007S | Only overlay and touch pads No program marking
D01 | 026768-Z | GRIP HEART RATE
D02 | 007806-D | PLATE CONTACT HR
D03 | 1000200414 | BOARD HRT CONTACT
D04 | 004610-00 | [NAME] BH [NAME]
D05 | 004880-00 | NUT M3
JY01 | 067875-AAX | BOARD UPPER
N01 | 014996-AA | COVER CONSOLE UPPER
N02 | 014997-AA | COVER CONSOLE LOWER
N04 | 000801-CA | HOLDER BOTTLE
N05 | 015181-AA | COVER PORT DATE CONSOLE | Part discontinued
N09 | 009661-H | FRAME CONSOLE SIDE
N10 | [PHONE] | FRAME CONSOLE MIDDLE
N13 | 000892-AA | RACK READING
N34 | 000808-B | BOTTLE WATER
N35 | 013880-D | EMERGENCY STOP BUTTON  800 SERIES
N51 | 004706-A | [NAME]
N54 | 004321-00 | SCREW BH M4x0.7Px10
[NAME] | 004350-Z | BOLT BH M3X6
N61 | 005157-A | WASHER FT 4X12X1
N62 | 004348-A | [NAME] M4X35
N63 | 004321-00 | SCREW BH M4x0.7Px10
N65 | 055204-A | SCREW BH M4x15 TAPPED
N66 | 004366-Z | SCREW BH M5X8
N80 | 004394-00 | BOLT BH M6X15
P05 | 002596-B | WIRE HAND PULSE
P06 | 002597-B | WIRE HRT TO CONVERTER
P11 | 002598-C | WIRE HR TO MAIN
P17 | 002600-D | WIRE GROUND HRT
T06 | 001964-C | REED SWITCH
V22 | 005998-00 | DECAL VF LARGE METAL
NOT SHOWN | 038118-A | MOTOR GROUND WIRE | "MUST BE SENT and INSTALLED FOR E7 ERRORS"
NOT SHOWN | 066332-A | MANUAL OWNERS T9800 | Available on line only
NOT SHOWN | 066331-A | MANUAL ASSEMBLY T9800
NOT SHOWN | 002076-C | CABLE DATA
Spreadsheet: 703880d1605205470-how-to-reference-a-certain-sheet-in-an-dynamic-averageifs-function-sampleworkbook
Sheet: 3

Depth (ft) | Column A | Column B | Column C
0 | 151 | 176 | 201
5 | 152 | 177 | 202
10 | 153 | 178 | 203
15 | 154 | 179 | 204
20 | 155 | 180 | 205
25 | 156 | 181 | 206
30 | 157 | 182 | 207
35 | 158 | 183 | 208
40 | 159 | 184 | 209
45 | 160 | 185 | 210
50 | 161 | 186 | 211
55 | 162 | 187 | 212
60 | 163 | 188 | 213
65 | 164 | 189 | 214
70 | 165 | 190 | 215
75 | 166 | 191 | 216
80 | 167 | 192 | 217
85 | 168 | 193 | 218
90 | 169 | 194 | 219
95 | 170 | 195 | 220
100 | 171 | 196 | 221
105 | 172 | 197 | 222
110 | 173 | 198 | 223
115 | 174 | 199 | 224
120 | 175 | 200 | 225
Spreadsheet: 135932d1326310534-maximum-consecutive-drawndown-formula-max-drawdown
Sheet: Sheet1

Data | Helper | [NAME]
100
2
-4
-6
-3
45
-5
-6
89
90
-5
-67
-33
-2
45
Spreadsheet: 680920d1591255893-find-max-value-from-a-range-of-time-intervals-displayed-as-days-hrs-mins-sampling-interval_
Sheet: Sheet1

Sampling date/time (START) | Sampling Date/time (END) |  | Duration (d, hrs, mins) | Duration (value)
2019-10-03 11:00:00 | 2019-10-11 11:50:00 |  |  |  | [NAME]
2019-10-08 00:00:00 | 2019-10-24 15:40:00 |  |  |  | Min
2019-11-13 00:00:00 | 2019-11-26 14:00:00 |  |  |  | Avge
2019-11-25 00:00:00 | 2019-11-28 14:30:00
2020-03-19 00:00:00 | 2020-03-23 15:00:00
2020-03-23 13:00:00 | 2020-03-23 15:30:10
 |  |  | [NAME]
 |  |  | Min
 |  |  | Average
Spreadsheet: 805031d1668497253-googlesheets-summary-of-multiple-text-fields-with-criterion-multiple-cell-summary
Sheet: Sheet1

Day | Project Name (From List) | Work Summary
Monday | Project A | First Meeting with client, analysis of work
Monday | Project B | Zoom meeting with project manager
Tuesday | Project C | Meeting with developers, QA meeting
Wednesday | Project A | Work schedule finished, transferring work to teams
Thursday | Project B | Finished presentation of Project B demands
Friday | Project C | Sent work to head of project
 | Weekly Summary: |  | Project List
 | Project A: | Summary goes here | Project A
 | Project B: | Summary goes here | Project B
 | Project C: | Summary goes here | Project C
Spreadsheet: 636392d1565281763-help-automatic-an-excel-calculation-example2-hydr-
Sheet: Sales Price

Distributor Product Price | Selling Platform Fee | Tax on Sale | Profit | Profit % | Tax on Purchase | Net Sale | Selling Price |  | Fee | Tax | Profit | Const | Calculated Selling Price
100 |  |  |  |  |  |  | 140.8642716449678 |  | 0.15 | 0.21 | 0.1
150 |  |  |  |  |  |  | 210.449868398598 |  | 0.15 | 0.21 | 0.1
200 |  |  |  |  |  |  | 280.0413372581235 |  | 0.15 | 0.21 | 0.1
77.38 |  |  |  |  |  |  | 109.3811913532152 |  | 0.15 | 0.21 | 0.1
23.4 |  |  |  |  |  |  | 34.25191839074581 |  | 0.15 | 0.21 | 0.1
Spreadsheet: 815896d1675256623-lookup-matching-partial-match-in-row-lookukp-matching-partial-match-in-row
Sheet: Sheet3

Name | Nos | Qty |  | BW | HG | CL | 3L | AP
3LBW5_02 | 1 | 104.8 |  | 104.8
3LBW5_01_M | 1 | 110.3 |  | 110.3
3LBW6_01 | 1 | 104.8 |  | 104.8
3L-AP-01 | 1 | 62.5 |  |  |  |  |  | 62.5
3L_02 | 1 | 91.5 |  |  |  |  | 91.5
3LBW6_02_M | 1 | 110.3 |  |  |  |  | 110.3
3L_01 | 1 | 91.5 |  |  |  |  | 91.5
HG3L_02 | 1 | 92.8 |  |  | 92.8
Spreadsheet: 65143d1265872602-if-else-question-if-else_question
Sheet: Main

Circle | Energy | Network | Opex
JK | 1776 | 1699 | 1572
HP | 124 | 124 | 124
BH | 1194 | 1216 | 1224
OR | 647 | 585 | 591
MP | 3320 | 2837 | 2830
AS | 1296 | 1296 | 1284
NE | 333 | 329 | 331
UPE | 2204 | 2135 | 2129
UPW | 2276 | 2160 | 2188
RAJ | 3859 | 3799 | 3593
HAR | 1633 | 1735 | 1518
INFRA | 15000
 | If data for INFRA is available in data tab, pick the values else do the sum of all circles. Answer for Network Infra is 17915.
 | Therefore, for network and [NAME] field, it would be sum of all circles and for energy it would be 15000 from data tab.
Spreadsheet: 738493d1625066287-count-cell-by-color-back-group-pr-tl
Sheet: Sheet1

 |  | Manual
No. | Desciption | Day | 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
 | PR received | 1
 | [NAME] | 7
 | [NAME]. to requester | 3
 | Spec confirm & RFQ | 1
 | Price comparison | 7
 | PO approval | 3
 | Confirm PO to supplier | 1
Spreadsheet: 693174d1598827360-sales-projections-using-a-monthly-growth-rate-modelexample-engineeradam-
Sheet: Sheet1

 | Month
 | 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
New Client Model |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 0 | 3 |  |  |  |  |  | 2
# of New Clients |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 3 | 3 | 3 | 4 | 4 | 4 | 5 | 5 | 5
Client 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 0 | 3 |  |  |  |  |  | 2
Client 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 0 | 3 |  |  |  |  |  | 2
Client 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 0 | 3 |  |  |  |  |  | 2
Client 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 0 | 3 |  |  |  |  |  | 2
Client 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 0 | 3 |  |  |  |  |  | 2
Client 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 0 | 3 |  |  |  |  |  | 2
Client 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 0 | 3 |  |  |  |  |  | 2
Client 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 0 | 3 |  |  |  |  |  | 2
Client 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 0 | 3 |  |  |  |  |  | 2
Client 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 0 | 3 |  |  |  |  |  | 2
Client 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 0 | 3 |  |  |  |  |  | 2
Client 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 0 | 3 |  |  |  |  |  | 2
Client 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 0 | 3 |  |  |  |  |  | 2
Client 14
Client 15
Total
Spreadsheet: 685739d1594163835-cell-formts-in-a-pivot-table-kitting-tracking-r2
Sheet: Report

Production Report - Finishing |  |  |  |  |  |  |  | Printed
Job No. |  | Date | [NAME] | SUPERVISOR TOTAL HRS. | TOTAL TEMP HOURS | TOTAL   HOURS | Sum of Qty. Produced | Sum of Qty. | Average of 1st Pass Yield
123456 | Smith Co | 2020-06-05 00:00:00 | Evie | 5 | 20 | 25 | 5000 | 4995 | 0.999
 |  | 2020-06-06 00:00:00 | Evie | 9 | 32.5 | 41.5 | 3000 | 2999 | 0.9996666666666667
 |  | 2020-06-07 00:00:00 | Evie |  | 12 | 12 | 3000 | 2950 | 0.9833333333333333
 |  | 2020-06-16 00:00:00 | Evie | 10.5 | 31.5 | 42 | 3500 | 3490 | 0.9971428571428571
 |  | 2020-06-17 00:00:00 | Evie | 10.5 | 42 | 52.5 | 500 | 500 | 1
 |  | 2020-06-17 00:00:00 | [NAME] | 10.5 | 52.5 | 63 | 1200 | 1198 | 0.9983333333333333
 |  | 2020-06-18 00:00:00 | [NAME] | 10.5 | 42 | 52.5 | 1500 | 1495 | 0.9966666666666667
 |  | 2020-06-19 00:00:00 | [NAME] | 10.5 | 42 | 52.5 | 2000 | 1995 | 0.9975
 |  | 2020-06-20 00:00:00 | [NAME] | 10.5 | 31.5 | 42 | 1500 | 1499 | 0.9993333333333333
 |  | 2020-06-21 00:00:00 | Evie | 9.5 | 47.5 | 57 | 1200 | 1198 | 0.9983333333333333
 |  | 2020-06-22 00:00:00 | [NAME] | 10.5 | 63 | 73.5 | 1100 | 1100 | 1
 |  | 2020-06-23 00:00:00 | [NAME] | 8.499999999999998 | 33.99999999999999 | 42.49999999999999 | 1300 | 1300 | 1
 |  | 2020-06-24 00:00:00 | Evie | 10.5 | 52.5 | 63 | 900 | 880 | 0.9777777777777777
 |  | 2020-06-25 00:00:00 | [NAME] | 10.5 | 42 | 52.5 | 1600 | 1598 | 0.99875
123456 Total |  |  |  |  |  | 671.5 | 27300 | 27197 | 0.9961312358276643
456789 | Bobs Co | 2020-06-05 00:00:00 | [NAME] | 7.5 | 1.000000000000002 | 8.500000000000002 | 2500 | 2500 | 1
 |  | 2020-06-06 00:00:00 | [NAME] | 8.499999999999998 | 55.24999999999999 | 63.74999999999999 | 2400 | 2400 | 1
456789 Total |  |  |  |  |  | 72.24999999999999 | 4900 | 4900 | 1
987654 | [NAME] | 2020-06-10 00:00:00 | Evie | 10 | 50 | 60 | 3000 | 3000 | 1
 |  | 2020-06-11 00:00:00 | Evie | 4.000000000000002 | 32.00000000000001 | 36.00000000000001 | 10000 | 7500 | 0.75
 |  | 2020-06-12 00:00:00 | [NAME] | 9 | 76.5 | 85.5 | 5000 | 4500 | 0.9
 |  | 2020-06-13 00:00:00 | [NAME] | 8.75 | 65.625 | 74.375 | 6000 | 5600 | 0.9333333333333333
 |  | 2020-06-14 00:00:00 | Evie | 10 | 95 | 105 | 2500 | 2450 | 0.98
 |  | 2020-06-15 00:00:00 | Evie | 10.5 | 78.75 | 89.25 | 2500 | 2500 | 1
987654 Total |  |  |  |  |  | 450.125 | 29000 | 25550 | 0.9272222222222221
Grand Total |  |  |  |  |  | 1193.875 | 61200 | 57647 | 0.9776895743145743
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: R58

Ime artikla
Spreadsheet: 567f13df-1c47-4ddf-94ad-0e3b17d2ba34
Sheet: Neutral

Percent of Rates to Maintain Funding Total
This calculation is completed to indicate the relative change in financing assuming the legislature were to fund the institutions at the same total as the previous biennium. The percent funded used against the current rates is adjusted so that the total funded for all institutions is equal to the previous biennium's percent funded.
Institution |  |  | Difference | Percent Change
Percent of Rates Funded | 0.6400103120664804 | 0.6244231875780042
Alamo Community College District
Alvin Community College
Amarillo College
Angelina College
Austin Community College
Blinn College
Brazosport College
Central Texas College
Cisco Junior College
[NAME]
Coastal Bend College
College of the Mainland Community College District
Collin County Community College District
Dallas County Community College District
Del Mar College
El Paso Community College
[NAME]
Galveston College
Grayson County College
Hill College
Houston Community College System
Howard College
Kilgore College
Laredo Community College
[NAME]
Lone Star College System District
McLennan Community College
Midland College
Navarro College
North Central Texas College
Northeast Texas Community College
Odessa College
Panola College
Paris Junior College
Ranger College
San Jacinto College District
South Plains College
South Texas College
Southwest Texas Junior College
Tarrant County College District
Temple College
Texarkana College
Texas Southmost College
Trinity Valley Community College
Tyler Junior College
Vernon College
Victoria College, The
Weatherford College
Western Texas College
Wharton County Junior College
Texas State Technical Collage-Marshall
Texas State Technical College-Harlingen
Texas State Technical College-Waco
Texas State Technical College-West Texas
Lamar Institute of Technology
Lamar State College-Orange
Lamar State College-Port Arthur
Total
Spreadsheet: 852203d1702306614-need-help-converting-a-google-sheets-formula-to-excel-ks-schedule-12112023
Sheet: HS

HS |  | Total hours
Time to Print | Job # | Line # | Customer | QTY | H | W | Material | Sides to Print | [NAME] | Due_Date | Est. usage | PRESS | Notes
 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | Light Smoothing | 2024-01-15 00:00:00 |  | HS | For production quote- [NAME]
Spreadsheet: 0e25619d-5db6-4a40-a840-aff12582b226
Sheet: Sheet1

CÓDIGO | Unnamed: 1 | Unnamed: 2 | FORMATO | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | VERSIÓN | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
FO-AI-048 |  |  | ACTA DE RECIBO DE OBRAS AUTORIZADAS POR LICENCIA DE EXCAVACIÓN |  |  |  |  | 4.0
 | En [NAME] a los |  |  | del mes de |  | del año |  | se reunieron los abajo firmantes,
 | delegado [NAME] ESP |  |  |  | y el Titular de la Licencia de Excavación
 | con el objeto de efectuar el recibo de las obras,  autorizadas  por la [NAME] |  |  |  |  |  |  |  | del día
 |  |  | del mes |  |  | del año |  | a nombre de
 |  |  |  |  | y con destino a la Dirección Técnica de Administración de Infraestructura del IDU.
 | No. | CIV | ZONA DE EXCAVACIÓN | VÍA | DESDE (PLACA) | HASTA (PLACA) | TIPO DE INTERVENCIÓN | BARRIO | LOCALIDAD
 | El acta se firma con destino [NAME], en |  |  |  | folios numerados, que  contienen |  |  | frentes de ejecución de obra.
 | Por la ESP |  |  |  |  |  | Por el Titular
 | Nombre: |  |  |  |  |  | Nombre:
 | Cargo:
 |  |  |  |  |  |  |  |  |  |  |  | ZONA A EXCAVAR |  | TIPO DE INTERVENCIÓN
 |  |  |  |  |  |  |  |  |  |  |  | CALZADA PAVIMENTO FLEXIBLE |  | REDES
 |  |  |  |  |  |  |  |  |  |  |  | CALZADA PAVIMENTO RÍGIDO |  | ACOMETIDAS O DOMICILIARIAS
 |  |  |  |  |  |  |  |  |  |  |  | CALZADA PAV. ARTICULADO (Adoquín) |  | CÁMARAS O CAJAS DE INSPECCIÓN
 |  |  |  |  |  |  |  |  |  |  |  | VÍAS SIN PAVIMENTO
 |  |  |  |  |  |  |  |  |  |  |  | ANDENES EN LOSAS DE CONCRETO
 |  |  |  |  |  |  |  |  |  |  |  | ANDEN EN ADOQUINES O LOSETAS
 |  |  |  |  |  |  |  |  |  |  |  | CICLORUTA
 |  |  |  |  |  |  |  |  |  |  |  | ZONAS VERDES
Spreadsheet: 7a173204-1ce0-4b1b-9a1b-313aafb9b632
Sheet: 2015-2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Criminal Justice and Forensic Science
Spring 2016
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: vkaminski__40835__McK2
Sheet: Total

ENE Price |  | 48.55 | 50 | 50.55 | 51.55 | 52.55 | 53.55 | 54.55 | 55.55 | 56.55 | 57.55
Shares delivered |  |  |  | 16034351 | 15102794 | 14206691 | 13344056 | 12513049 | 11711960 | 10939204 | 10193303
Value
ENE Price | 58.55 | 59.55 | 60.55 | 61.55 | 62.55 | 63.55 | 64.55 | 65.55 | 66.55 | 67.55 | 68.55
Shares delivered | 9472881 | 8776654 | 8103425 | 7452071 | 6821543 | 6210860 | 5619097 | 5045390 | 4488924 | 3948934 | 3424698
Value
ENE Price | 69.55 | 70.55 | 71.55 | 72.55 | 73.55 | 74.55 | 75.55 | 75.89 | 77.55 | 78.55 | 79.55
Shares delivered | 2915538 | 2420812 | 1939914 | 1472273 | 1017349 | 574629 | 143630 | 0 | 0 | 0 | 0
Value
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Restriction Valuation
 | ENE Price | Shares | Value
 | 48.55 |  |  |  | Terminal Price |  | Value |  |  | Value |  | Shares |  | Forward Price
 |  |  |  |  | Bottom | Top | Bottom | Top | Slope | Delivered |  | Delivered |  | Strike Price on Fwd
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Put Premium
 |  |  |  |  |  |  |  |  |  |  | TopT |  |  | % Put Premium
 |  |  |  |  | 0 | 50 | 0 |  |  |  | BottomT |  |  | Volatility
 |  |  |  |  | 50 |  |  |  |  |  | MT |  |  | IR |  | 0.05
 |  |  |  |  |  |  |  |  |  |  | TT |  |  | Div. Yield
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Div. US$ |  | 0.5
 |  |  |  |  |  |  |  | Total Shares Delivered |  |  |  |  |  | Years of restrict
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Days to [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Call Flag (Put = 0) |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0=put | Premium |  | Ret Type (Premium = 0) |  | 0
 |  |  |  |  | Position |  |  |  |  |  | OptType | per unit | Total
 |  |  |  |  |  | Long Euro put @ |  | 50.55 | Shares |  | 0
 |  |  |  |  |  | Long Euro Put @ |  | 75.89 | Shares |  | 0
 |  |  |  |  |  | Short Euro Put @ |  | 50 | Shares |  | 0
 |  |  |  |  |  | Short Euro Put @ |  | 50.55 | Shares |  | 0
 |  |  |  |  |  | Short Euro Put @ |  | 50 | Shares |  | 0
 |  |  |  |  |  | Price | 61.48 | 61
 |  |  |  |  |  | IR | 0.06 | 0.05127
 |  |  |  |  |  | Maturity |  | 0.0065
 |  |  |  |  |  | Volatility | 0.4 | 0.42
 |  |  |  |  |  | Yield | 0.0065
Spreadsheet: 105579d1302884312-counting-against-multiple-criteria-excel-forum-help-4-15-11-
Sheet: Sheet1

 | This is the example Source Data table |  |  |  |  |  |  |  |  |  |  |  | This is the desired Results Data table
 |  |  | Type |  |  |  |  | Tonality |  |  |  |  |  |  | Tonality
 |  | Firm | Trade Press | Blogs | Local | Business | Wire | Negative | Neutral | Positive |  |  |  | Type | Negative | Neutral | Positive
 |  | A |  | 1 |  |  |  |  | 1 |  |  |  |  | Trade Press | 1 | 1 | 3
 |  | A | 1 |  |  |  |  |  |  | 1 |  |  |  | Blogs | 0 | 3 | 1
 |  | A | 1 |  |  |  |  |  |  | 1 |  |  |  | Local | 1 | 1 | 1
 |  | B |  |  |  | 1 |  |  | 1 |  |  |  |  | Business | 1 | 1 | 3
 |  | B | 1 |  |  |  |  | 1 |  |  |  |  |  | Wire | 0 | 2 | 0
 |  | B |  |  |  | 1 |  | 1
 |  | C |  |  |  |  | 1 |  | 1
 |  | C |  |  | 1 |  |  |  |  | 1 |  |  | Eventually, do by a third criteria …
 |  | C | 1 |  |  |  |  |  |  | 1
 |  | C |  |  |  | 1 |  |  |  | 1
 |  | C |  |  |  |  | 1 |  | 1 |  |  |  |  | Firm = C | Tonality
 |  | C |  | 1 |  |  |  |  | 1 |  |  |  |  | Type | Negative | Neutral | Positive
 |  | C |  | 1 |  |  |  |  |  | 1 |  |  |  | Trade Press | 0 | 0 | 1
 |  | C |  |  | 1 |  |  | 1 |  |  |  |  |  | Blogs | 0 | 1 | 1
 |  | D | 1 |  |  |  |  |  | 1 |  |  |  |  | Local | 1 | 0 | 1
 |  | E |  |  |  | 1 |  |  |  | 1 |  |  |  | Business | 0 | 1 | 0
 |  | F |  |  |  | 1 |  |  |  | 1 |  |  |  | Wire | 0 | 2 | 0
 |  | G |  | 1 |  |  |  |  | 1
 |  | H |  |  | 1 |  |  |  | 1
Spreadsheet: 08c9639b-c4fc-46c8-9dbc-e38113bf580d
Sheet: Associate

Paramedic Technology
Associate of Applied Science Degree
 |  |  |  |  |  |  |  | Revised 8/12
Name |  |  | Student ID Number |  |  |  | Date Entered:
Address |  |  | Phone: |  |  |  | Proposed Graduation Date:
 |  |  | [NAME]:
 |  |  | Student Signature: |  |  |  |  | Date:
 |  |  | Advisor Signature: |  |  |  |  | Date:
 |  |  | Authorizing Signature: |  |  |  |  | Date:
Remedial Courses As Needed |  |  |  | Credit Hours | [NAME] | Degree |  | Notes
101 ENG Writing 1 |  |  |  | 3 |  | X
110 PSY General Psychology |  |  |  | 3 |  | X
135 BIO Basic Anatomy and Physiology with Lab |  |  |  | 4 |  | X | BIO 137 & BIO 139 may be substituted for BIO 135
Quantitative Reasoning |  |  |  | 3 |  | X | Math: MAT 105, 110, 116, 126
Oral Communications |  |  |  | 3 |  | X
Heritage/Humanities |  |  |  | 3 |  | X
115 AHS Medical Terminology  OR |  |  |  | 3
131 CLA Medical Terminology from Greek & Latin OR |  |  |  | (3) |  | X
Computer/Digital Literacy |  |  |  | 0-3 |  | X
Program Courses |  |  |  | Credit Hours | [NAME] | Degree |  | Notes
200 EMS Introduction to Paramedicine |  |  |  | 4 |  | X
210 EMS Emergency Pharmacology |  |  |  | 3 |  | X
211 EMS Fundamentals Lab |  |  |  | 2 |  | X
215 EMS Clinical Experience I |  |  |  | 1 |  | X
220 EMC Cardiovascular Emergencies |  |  |  | 3 |  | X
221 EMC Cardiac and [NAME] |  |  |  | 1 |  | X
225 EMC Clinical Experience II |  |  |  | 1 |  | X
230 EMS Traumatic Emergencies |  |  |  | 4 |  | X
231 EMS Medical Lab |  |  |  | 1 |  | X
235 EMS Iclinical Experience III |  |  |  | 2 |  | X
240 EMS Medical Emergencies I |  |  |  | 3 |  | X
250 EMS Medical Emergencies II |  |  |  | 3 |  | X
260 EMS Special Populations |  |  |  | 3 |  | X
270 EMS EMS Operations |  |  |  | 1 |  | X
275 EMS Seminar in Advanced Life Support (ALS) |  |  |  | 1 |  | X
285 EMS Field Internship & Summation |  |  |  | 5-6 |  | X
201 AHS Management Principles for Health Care Providers |  |  |  | 3 |  | X
Total Credit Hours |  |  |  | 63-67
*Note:  Students are required to be a certified EMT upon acceptance into the program.
Spreadsheet: 835808d1688839013-compare-dynamic-arrays-return-missing-values-compare_dynamic_arrays-4-
Sheet: Feuil1

 |  |  |  |  | COMPARE TABLE A |  |  |  |  | WITH TABLE B |  |  |  |  | EXPECTED RESULTS: VALUES FROM A, PER COLUMNS, NOT EXISTING IN B, EXCEPT FOR EMPTY COLUMNS
1 | 2 | 3 | 4 |  |  | 2 | 3 | 4 |  |  | 2 | 3 | 4 |  | 1: v,c // 2: g // 4: a,x,c
a |  |  | a |  |  |  |  | a |  |  | d |  | z
b |  |  |  |  | b |  |  |  |  | b | v |  | h
v | d |  | x |  | v | d |  | x |  |  |  |  | u
c |  |  | c |  | c |  |  | c
 |  | f |  |  |  |  | f
 | d |  |  |  |  | d
a | d |  |  |  | a | d
 | g |  | z |  |  | g |  | z
 |  |  | h |  |  |  |  | h
1 | 2 | 3 | 4
a | d |  | z
b | v |  | h
 |  |  | u