tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 41250d1239739584-updating-dates-on-separate-tabs-based-on-date-in-first-tab-form-booking-sheets-all-1
Sheet: T15

Boeing Tour - AM |  |  |  |  | 2009-05-22 00:00:00
 | Driver: |  |  |  | Vehicle: |  |  |  |  |  | Prepaid
P/U Time | Booked by |  | Hotel |  | Party | A | C | CT | MF | Amt | CC | Ck | Collect | [NAME]
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
Daily Total:
Pricing
Retail: | Adult | 55 | Child | 45 | Reseller: | Adult |  | 44 | Child |  | 36
Resellers: Alcatraz Media, [NAME], Look Tours, Sightseeing World, TourCorp
Driver Pickup Summary
Spreadsheet: 66da7325-d53c-41d1-bda2-c8ed4d9d4b2e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4366 | 10165 | Isabelle | [NAME] | FRA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 00:00:00
4366 | 15260 | Bianca | [NAME] | AUS | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 00:00:00
4366 | 15248 | [NAME] | Hubbard | CAN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 00:00:00
Spreadsheet: 707310d1607172937-drop-down-list-selection-based-on-column-title-selection-template
Sheet: Passive Fire

Status |  |  | Service | Type | Description |  |  | Structure |  | Sticker | Passive Fire Treatment |  |  | Picture 1 | Picture 2
Inspected | Compliance | Non-Compliance |  |  | Level | Area | ID | Wall/ Slab | Type |  | Manufacturer | Product | Aplication
YES | NOT COMPLIANT | Not A Tested System | Mechanical | Heating Water Pipes < 100mm | Basement | Garbage Room | FDB.1 | Slab | Speedpanel | Not Compliant | BOSS Fire
Spreadsheet: 41189d1239711170-linking-and-finding-information-678358b
Sheet: Sheet1

Name | a` pris | Unit | Eur | Purchase price | Price
A | 1 | st | 5 | 12
B | 2 | st | 6 | 32 | 32
C | 3 | st | 7 | 54 | 33
D | 4 | st | 32 | 21 | 221
Q | 2 | st | 231 | 321 | 3221
E | 31 | m | 23 | 3232 | 33
D | 21 | m | 3 | 12 | 231
Spreadsheet: 57244d1257361511-interpolation-on-a-connected-scatter-plot-series_60
Sheet: 25.00ft

Station |  | SM | Function of Ordinates | Arm | Functions of Longitudinal Moment | Arm | Fuctions of Longitudinal Moment of Inertia | Cubes of Half-Ordinates | SM | Function of Half-Cubes
 | WL
 |  | 0.5
 |  | 2
 |  | 0.5
 |  | 2
 |  | 1.5
 |  | 4
 |  | 2
 |  | 4
 |  | 2
 |  | 4
 |  | 2
 |  | 4
 |  | 2
 |  | 4
 |  | 2
 |  | 4
 |  | 2
 |  | 4
 |  | 2
 |  | 4
 |  | 1.5
 |  | 2
 |  | 0.5
 |  | 2
 |  | 0.5
 |  | f(A) = |  |  |  | [f(M)]^2 = |  |  | f(I) =
 |  |  |  | f(M) = |  | f(A)
 |  |  |  |  |  | f(IL) =
Total Area = (M) x AWL =
Center of Gravity of waterplane from ordinate 5 = f(M)/f(A) x s =
Moment of waterplane about ordinate 5 = f(M) x 2/3 s^2 =
Longitudinal I of WP about axis through its center of gravity = f(IL) x 2/3 x s^3 =
Transverse I of WP about centerline = f(I) x 2/9 s =
Spreadsheet: 781855d1653583063-converting-text-weights-to-ounces-pounds-n-ounces
Sheet: Sheet1

 | Standard: | 10lbs 6oz
 |  | Difference in Ounces
 | 9lbs 11oz
 | 9lbs 5oz
 | 10lbs
 | 9lbs 7oz
 | 9lbs 3oz
 | 10lbs 8oz
 | 10lbs 4oz
 | 9lbs
 | 10lbs 7oz
Spreadsheet: 768898d1645193423-giving-my-cell-a-color-cel-kleuren
Sheet: Totaal

 |  | H4-T08 |  | H5-T15
 | 2022-05-09 00:00:00
Spreadsheet: 812727d1673351269-formula-returning-zero-when-using-formulas-in-the-referenced-cells-rather-than-numbers-forum-example
Sheet: Sheet1

 | Column1 | Column2 | Column3 | Column4 | Column5
 | Y | 36 | 15 | 2 | 1
 | Y | 27 | 7 | 0 | 2
 | Y | 34 | 25 | 3 | 6
 | Y | 26 | 7 | 1 | 2
 | Y | 30 | 13 | 3 | 1
 | Y | 25 | 16 | 0 | 2
 | N
 | Y | 37 | 32 | 4 | 1
 | Y | 21 | 18 | 3 | 4
 | Y | 29 | 18 | 5 | 4
 | Y | 32 | 16 | 1 | 4
 | Y | 30 | 24 | 3 | 2
 | Y | 34 | 17 | 4 | 2
 | Y | 33 | 22 | 5 | 5
 | Y | 36 | 17 | 4 | 4
 | Y | 34 | 12 | 6 | 3
 | Y | 33 | 23 | 5 | 4
 | Y | 29 | 25 | 2 | 4
 | Y | 32 | 14 | 5 | 5
 | Y | 34 | 31 | 5 | 4
 | Y | 36 | 16 | 3 | 6
 | Y | 37 | 19 | 2 | 1
 | Y | 28 | 19 | 4 | 2
 | Y | 33 | 21 | 4 | 0
 | Y | 36 | 13 | 5 | 3
 | Y | 32 | 13 | 7 | 5
 | Y | 30 | 9 | 5 | 1
 | Y | 22 | 23 | 4 | 4
 | Y | 30 | 9 | 2 | 0
 | Y | 30 | 19 | 4 | 1
 | Y | 29 | 30 | 2 | 4
 | Y | 26 | 11 | 2 | 2
 | Y | 24 | 4 | 0 | 1
 | N
 | N
 | N
 | 1 | 32 | 49 | 4 | 8
 | 1 | 38 | 34 | 4 | 9
5 | AVGS
10 | AVGS
20 | AVGS
 |  |  | column 3 | colunn 4 | column 5
 |  | number of times exceeding 5
Spreadsheet: 843217d1695134440-error-in-the-formula-order-file-aligw
Sheet: Output

Acct No | Qty | Price
M1 | 2 | 2 |  |  | 2 | 2
M4 | 3 | 1 |  | M4 | 3 | 1
M5 | 2 | 3 |  | M5 | 2 | 3
M2 | 5 | 1 |  | M1 | 2 | 2
M3 | 2 | 6 |  | M1 | 2 | 2
M1 | 3 | 3 |  | M4 | 3 | 1
M2 | 2 | 1 |  | M5 | 2 | 3
M3 | 3 | 1 |  | M1 | 2 | 2
M4 | 1 | 1 |  | M1 | 2 | 2
 |  |  |  | M4 | 3 | 1
 |  |  |  | M5 | 2 | 3
 |  |  |  | M1 | 2 | 2
 |  |  |  | M1 | 2 | 2
 |  |  |  | M4 | 3 | 1
 |  |  |  | M5 | 2 | 3
 |  |  |  | M1 | 2 | 2
Spreadsheet: 369668d1420918425-numerology-chart1-numbers
Sheet: Sheet1

letter | letter Type | No. | Name | Total | vowels | Constant
a | v | 1 | [NAME]
b | c | 2 | Bowle
c | c | 3 | Vowels
d | c | 4
e | v | 5
f | c | 6
g | c | 7
h | c | 8
i | v | 9
j | c | 1
k | c | 2
l | c | 3
m | c | 4
n | c | 5
o | v | 6
p | c | 7
q | c | 8
r | c | 9
s | c | 1
t | c | 2
u | v | 3
v | c | 4
w | c | 5
x | c | 6
y | c | 7
z | c | 8
Spreadsheet: 57924d1258136773-compile-staggered-data-into-a-single-row-compile
Sheet: Sheet5

image | itemNumber | itemNumberQualifier | descriptionValue | itemDescriptionQualifier | itemDescriptionClassification | unitOfMeasure | value | packageUnitDescription | unitOfMeasure2 | value3 | unitOfMeasure4 | value5 | weightQualifier | unitOfMeasure6 | [NAME] | unitOfMeasure8 | value9 | unitOfMeasure10 | [NAME] | unitOfMeasure12 | value13 | itemUnitDescription | unitOfMeasure14 | value15 | unitOfMeasure16 | value17 | unitOfMeasure18 | value19
B492-31-36-39-57-54-96-93-SD_BIG.jpg | B492-93 | SellerAssigned
B492-31-36-39-57-54-96-93-SD_BIG.jpg | B492-93 | BuyerAssigned
B492-31-36-39-57-54-96-93-SD_BIG.jpg | [PHONE] | UPC
B492-31-36-39-57-54-96-93-SD_BIG.jpg |  |  | NIGHTSTAND LT BRN FNSH | SellerAssigned | Product
B492-31-36-39-57-54-96-93-SD_BIG.jpg |  |  |  |  |  | Each | 1 | NIGHTSTAND LT BRN FNSH | CubicFeet | 9.41 | Pounds | 62.7 | GrossWeight | Inches | 21 | Inches | 27.25 | Inches | 27.75
B492-31-36-39-57-54-96-93-SD_BIG.jpg |  |  |  |  |  | Each | 1 | NIGHTSTAND LT BRN FNSH |  |  |  |  |  | Centimeters | 53.34 | Centimeters | 69.215 | Centimeters | 70.485
B492-31-36-39-57-54-96-93-SD_BIG.jpg |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Each | 1 | NIGHTSTAND LT BRN FNSH | Inches | 18 | Inches | 29 | Inches | 26
B492-31-36-39-57-54-96-93-SD_BIG.jpg |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Each | 1 | NIGHTSTAND LT BRN FNSH | Centimeters | 45.72 | Centimeters | 73.66 | Centimeters | 66.04
Spreadsheet: 137817d1327399963-question-about-filling-a-column-if-cell-values-matches-a-specific-value-excelhelpsample1
Sheet: Sheet2

Pt Number | Injury date | [NAME] | [NAME] | CT Other Axial | [NAME] | [NAME] | CT Total | Reduction Open | Reduction Closed | Reduc total
1
2
3
4
5
 |  | [NAME], NEC=11.11
 |  | CT Other Axial=11.13
 |  | CT Thorax=11.14
 |  | CT Abdominal=11.15
 |  | Reduction Open=11.16
 |  | Reduction Closed=11.17
 |  | CT Head=11.18
Spreadsheet: 160535d1339099894-graphing-standard-deviation-percentages-chart-making-stuff-for-dmbatcofc
Sheet: Sheet1

 | INDEX | DATA
 | 1 |  |  | mean
 | 2 |  |  | stdev
 | 3 |  |  |  |  |  | lower | upper | inside | outside | make sense?
 | 4 |  |  | Inside | 1st SD | 1
 | 5 |  |  |  | 2nd SD | 2
 | 6 |  |  |  | 3rd SD | 3
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17 |  |  |  | Distribution
 | 18 |  |  |  | value | count
 | 19 |  |  |  | 0
 | 20 |  |  |  | 1
 | 21 |  |  |  | 2
 | 22 |  |  |  | 3
 | 23 |  |  |  | 4
 | 24 |  |  |  | 5
 | 25 |  |  |  | 6
 | 26 |  |  |  | 7
 | 27 |  |  |  | 8
 | 28 |  |  |  | 9
 | 29
 | 30 |  |  |  | make sense?
 | 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
 | 73
 | 74
 | 75
 | 76
 | 77
 | 78
 | 79
 | 80
 | 81
 | 82
 | 83
 | 84
 | 85
 | 86
 | 87
 | 88
 | 89
 | 90
 | 91
 | 92
 | 93
 | 94
 | 95
 | 96
 | 97
 | 98
 | 99
 | 100
Spreadsheet: 120949d1315667763-separating-numbers-from-text-numbers-from-string-2
Sheet: Sheet1

ABC bbb ggg 14 (44-33 A) | ABC bbb ggg | 14 | 44 | 33
ABC bbb 14 (4-33 A) | ABC bbb | 14 | 4 | 33
ABC bbb ggg 14 (44-3 A) | ABC bbb ggg | 14 | 44 | 3
ABC bbb ggg 1 (4-3 A) | ABC bbb ggg | 1 | 4 | 3
ABC 1 (44-3 A) | ABC | 1 | 44 | 3
ABC 1 (4-33 A) | ABC | 1 | 4 | 33
Spreadsheet: 704199d1605432495-formula-to-fill-down-values-in-column-d-fill_data
Sheet: Sheet1

Sales ID | Sales YR | Sales ($) | Desired Results
1177 | 1999 |  | 18
1177 | 2000 |  | 19
1177 | 2002 | 21 | 21
1177 | 2003 | 22 | 22
1177 | 2004 | 23 | 23
1177 | 2005 | 24 | 24
1177 | 2006 | 25 | 25
1177 | 2007 | 26 | 26
1177 | 2008 | 27 | 27
1177 | 2009 | 28 | 28
1033 | 2002 | 28 | 28
1033 | 2003 | 29 | 29
1033 | 2006 | 32 | 32
1033 | 2007 | 33 | 33
1033 | 2008 | 34 | 34
1033 | 2009 | 35 | 35
1033 | 2010 |  | 36
1055 | 1999 | 49 | 49
1055 | 2000 | 50 | 50
1055 | 2001 | 51 | 51
1055 | 2002 | 52 | 52
1055 | 2003 |  | 53
1055 | 2004 |  | 54
1055 | 2005 |  | 55
1055 | 2006 |  | 56
1055 | 2007 |  | 57
1055 | 2008 |  | 58
1055 | 2009 |  | 59
1055 | 2010 |  | 60
1190 | 2000 | 50 | 50
1300 | 1999
1220 | 1999 |  | 30
1220 | 2000 |  | 31
1220 | 2001 |  | 32
1220 | 2002 |  | 33
1220 | 2003 |  | 34
1220 | 2004 |  | 35
1220 | 2005 |  | 36
1220 | 2006 | 37 | 37
1220 | 2007 | 38 | 38
1220 | 2008 | 39 | 39
1220 | 2009 | 40 | 40
1220 | 2010 | 41 | 41
1220 | 2012 |  | 43
Spreadsheet: eric_saibi__9758__012102R
Sheet: Shasta 01

Owner Name |  | US Bureau
Station Name |  | Shasta Lake Hydro Power Station
Unit Name |  | Hydro 01
NERC Region |  | WSCC
State |  | CA
Fuel Type |  | Hydro
Capacity |  | 125 MW
Start Date |  | 2002-01-07 00:00:00
End Date |  | 2002-01-27 00:00:00
Prv. Start Date |  | 2002-01-07 00:00:00
Prv. End Date |  | 2002-01-20 00:00:00
Comments |  | Maintenance
SIC |  | 4911
Plant ID |  | 1027529
Unit ID |  | 1007159
Outage ID |  | 19409
Spreadsheet: 288333d1389161967-how-to-repeat-same-values-latha-mani
Sheet: Sheet1

item | cost
1001 | 5
1002 | 10
1003 | 48
1004 | 25
1005 | 35
1006 | 5
1007 | 8
1008 | 9
1009 | 7
1010 | 6
1011 | 7
1012 | 74
1013 | 4
1014 | 4
1015 | 4
1016 | 5
1017 | 4
1018 | 4
1019 | 4
1020 | 5
1021 | 8
Spreadsheet: 210812d1359567469-really-need-help-please-automation-across-sheets-sample-excel
Sheet: DATA VALIDATION-2

 | c
Spreadsheet: 771037d1646394596-count-specific-workdays-in-a-week-excluding-holidays-based-off-date-range-and-schedule-formula-help-fte-calculator-betwen-dates
Sheet: Month Table

Month | Start of Month | End of Month
January | 2022-01-01 00:00:00
February | 2022-02-01 00:00:00
March | 2022-03-01 00:00:00
April | 2022-04-01 00:00:00
May | 2022-05-01 00:00:00
June | 2022-06-01 00:00:00
July | 2022-07-01 00:00:00
August | 2022-08-01 00:00:00
September | 2022-09-01 00:00:00
October | 2022-10-01 00:00:00
November | 2022-11-01 00:00:00
December | 2022-12-01 00:00:00
Spreadsheet: diana_scholtes__8541__trani_1999_2000
Sheet: Rev.2-2000

Counterparty |  |  | 2000
 |  |  | Network ST | Network LT | Intertie  ST | [NAME] | Path
Benton County PUD |  |  | 201074.75
[NAME] |  |  | 264834.48 |  | 754.5 | 1281644 | NOB N/S
 |  |  |  |  | 743595.24 |  | NOB S/N
 |  |  |  |  | 255407.78 |  | COB N/S
 |  |  |  |  | 63369.44 |  | COB S/N
Richland PUD |  |  | 4070
Franklin PUD |  |  | 7266.25
Montana |  |  | 34365.92
Pacificorp |  |  | 136765.09 |  | 2994.5 |  | COB
 |  |  |  |  | 49657.96 |  | Cascade
Puget Sound Energy |  |  | 0
Gray Harbor PUD |  |  | 96390.75
Snohomish PUD |  |  | 59551.1
Seattle City Light |  |  | 6654
Sub Total
Portland General |  |  | 0 |  |  | 1525355.1 | COB
Grand Total
* | 1 year or longer in duration = LT
Spreadsheet: 330f2b16-c2cf-4277-9573-746cc5e91241
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
CPR | Test | CPR | C-Peptide, Serum | C-Peptide, S | Electrochemiluminescence Immunoassay | Plain, Red-Top Tube: Red Serum Gel Tube: SGT |  |  | 0.5 | mL | Collection Container/Tube:  Preferred: Red top Acceptable: Serum gel Submission Container/Tube: Plastic vial [NAME]: 0.5 mL Collection Instructions: Fasting | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	Autopsy specimen | 1.1-4.4 ng/mL  Reference intervals have not been formally verified in-house for pediatric patients. The published literature indicates that reference intervals for adult and pediatric patients are comparable. | Monday through Friday; 5 a.m.-12 a.m., Saturday; 6 a.m.-6 p.m. | Same day/1 day | 3 days | 1 | 84681 |  |  |  |  | Rochester
CPR | [NAME] | SERUM | Serum |  |  |  | Frozen | 30 days
CPR | Result | CRPN | C-Peptide, S | C-Peptide, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 1986-9 | C peptide:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: darrell_schoolcraft__7364__imball0201
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 |  | -46940
9238 | -9933 | -22000 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 |  | -2156562
58710 | -143515 | -141004
60921 |  | -1006754
78026
500084 |  | -66000
500085 | -3408
500097 | -75539 | -88000
INDEX
2001-12-31 00:00:00 |  |  | 766914.32
2002-01-22 00:00:00
CBS Volume
 |  |  | 307322
Spreadsheet: 679797d1590633681-using-other-template-my-raw-transpose-using-multi-criteria-lookup-please-help-transpose-multi-criteria-look-up
Sheet: My Template

 |  | PARK |  |  |  |  |  |  |  |  |  | HOSPITAL
 |  | 2020-05-26 00:00:00 |  |  | 2020-05-27 00:00:00 |  |  | 2020-05-28 00:00:00 |  |  |  |  | 2020-05-26 00:00:00 |  |  | 2020-05-27 00:00:00 |  |  | 2020-05-28 00:00:00
 | 1 | Park 1 | Park 2 | Park 3 | Park 1 | Park 2 | Park 3 | Park 1 | Park 2 | Park 3 |  | 1 | Park 1 | Park 2 | Park 3 | Park 1 | Park 2 | Park 3 | Park 1 | Park 2 | Park 3
 | 2 |  |  |  |  |  |  |  |  |  |  | 2
 | 3 |  |  |  |  |  |  |  |  |  |  | 3
 | 4 |  |  |  |  |  |  |  |  |  |  | 4
 | 5 |  |  |  |  |  |  |  |  |  |  | 5
 | 6 |  |  |  |  |  |  |  |  |  |  | 6
 | 7 |  |  |  |  |  |  |  |  |  |  | 7
 | 8 |  |  |  |  |  |  |  |  |  |  | 8
 | 9 |  |  |  |  |  |  |  |  |  |  | 9
 | 10 |  |  |  |  |  |  |  |  |  |  | 10
 | 11 |  |  |  |  |  |  |  |  |  |  | 11
 | 12 |  |  |  |  |  |  |  |  |  |  | 12
 | 13 |  |  |  |  |  |  |  |  |  |  | 13
 | 14 |  |  |  |  |  |  |  |  |  |  | 14
 | 15 |  |  |  |  |  |  |  |  |  |  | 15
 | 16 |  |  |  |  |  |  |  |  |  |  | 16
 | 17 |  |  |  |  |  |  |  |  |  |  | 17
 | 18 |  |  |  |  |  |  |  |  |  |  | 18
 | 19 |  |  |  |  |  |  |  |  |  |  | 19
 | 20 |  |  |  |  |  |  |  |  |  |  | 20
 | 21 |  |  |  |  |  |  |  |  |  |  | 21
 | 22 |  |  |  |  |  |  |  |  |  |  | 22
 | 23 |  |  |  |  |  |  |  |  |  |  | 23
 | 24 |  |  |  |  |  |  |  |  |  |  | 24
Spreadsheet: kate_symes__18186__EOL 2-26
Sheet: EOL Deals

EOL Deals | From: 2/1/2001   To: 2/26/2001 |  |  | EnPower Deals | From: 2/1/2001   To: 2/26/2001
Desk | Total MWH | Total Deals |  | Desk | Total MWH | Total Deals
EPMI Long Term California | 978800 | 42 |  | EPMI Long Term California | 2849125 | 49
EPMI Long Term Northwest | 1045000 | 63 |  | EPMI Long Term Northwest | 10295692 | 261
EPMI Long Term Southwest | 2238800 | 56 |  | EPMI Long Term Southwest | 13889525 | 122
EPMI Short Term California | 746200 | 647 |  | EPMI Short Term California | 1401050 | 361
EPMI Short Term Northwest | 149000 | 244 |  | EPMI Short Term Northwest | 477137 | 186
EPMI Short Term Southwest | 972800 | 419 |  | EPMI Short Term Southwest | 1973175 | 354
Grand Total | 6130600 | 1471 |  | Grand Total | 30885704 | 1333
EOL Deals | From: 2/26/2001   To: 2/26/2001 |  |  | EnPower Deals | From: 2/26/2001   To: 2/26/2001
Desk | Total MWH | Total Deals |  | Desk | Total MWH | Total Deals
EPMI Long Term California | 61600 | 2 |  | EPMI Long Term California | 334400 | 14
EPMI Long Term Northwest | 94800 | 7 |  | EPMI Long Term Northwest | 835200 | 11
EPMI Long Term Southwest | 10000 | 1 |  | EPMI Long Term Southwest | 221800 | 9
EPMI Short Term California | 60800 | 32 |  | EPMI Short Term California | 34800 | 19
EPMI Short Term Northwest | 8400 | 23 |  | EPMI Short Term Northwest | 1464 | 5
EPMI Short Term Southwest | 42800 | 31 |  | EPMI Short Term Southwest | 106000 | 20
Grand Total | 278400 | 96 |  | Grand Total | 1533664 | 78
EOL Deals | From: 1/1/2001   To: 2/26/2001 |  |  | EnPower Deals | From: 1/1/2001   To: 2/26/2001
Desk | Total MWH | Total Deals |  | Desk | Total MWH | Total Deals
EPMI Long Term California | 1730400 | 109 |  | EPMI Long Term California | 6553190 | 194
EPMI Long Term Northwest | 2501825 | 149 |  | EPMI Long Term Northwest | 33441987 | 607
EPMI Long Term Southwest | 4614400 | 128 |  | EPMI Long Term Southwest | 24464114 | 338
EPMI Short Term California | 1235800 | 1411 |  | EPMI Short Term California | 2437120 | 868
EPMI Short Term Northwest | 269200 | 463 |  | EPMI Short Term Northwest | 924057 | 405
EPMI Short Term Southwest | 1970400 | 891 |  | EPMI Short Term Southwest | 3671015 | 731
Grand Total | 12322025 | 3151 |  | Grand Total | 71491483 | 3143
Spreadsheet: 761671d1641145987-dynamic-dropdown-in-excel-dnamic-dropdown
Sheet: CoCo

YEAR | MONTH | PARTNAME | SRCCoCo | TARGCoCo | ERP |  |  |  | CoCo | Acct
 | 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: 39926d1238166687-looking-up-a-range-of-cells-with-criterias-attached-forum-example
Sheet: Information

 |  |  |  |  |  |  | Results
Euro | ROI PI | FARM | UK NB | IRL NB | PEN | All-In-One | 0
0.36 | 0.21 | 0.15 | 0.11 | 0.1 | 0.12 | 0.19 | 0.8
0.41 | 0.25 | 0.19 | 0.17 | 0.14 | 0.16 | 0.23 | 1
0.51 | 0.31 | 0.25 | 0.23 | 0.2 | 0.22 | 0.29 | 1.2
0.55 | 0.37 | 0.31 | 0.29 | 0.26 | 0.28 | 0.35 | 1.4
Spreadsheet: 167076d1341892515-giving-letters-a-number-value-sum-of-vlookups
Sheet: Sheet1

Name | Hours1 | Hours2 | Hours3 | Hours4 | Hours5 | Value1 | Value2 | Value3 | Value4 | Value5 | Total
[NAME] | a | c | c | a | f
 |  |  |  |  | Letter | Value
 |  |  |  |  | a | 8
 |  |  |  |  | b | 7
 |  |  |  |  | c | 6
 |  |  |  |  | d | 8
 |  |  |  |  | e | 4
 |  |  |  |  | f | 3
 |  |  |  |  | g | 2
 |  |  |  |  | h | 1
Spreadsheet: 9e6912a4-1ec1-4d9c-bc68-8f49b88aa570
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  |  | 1.0 litre petrol engine |  | 1.6 litre petrol engine | 2.0 litre petrol engine | 1.5 litre turbo-diesel engine | 2.0 litre turbo-diesel engine
MODEL
 | Body type |  | 3 door hatchback | 5 door hatchback | 5 door hatchback | 5 door hatchback | 5 door hatchback | 5 door hatchback
 | Seating capacity | persons | 5 |  | 5 | 5 | 5 | 5
ENGINE
 | Engine code |  | [NAME] |  | HR16DE | [NAME] | [NAME] | M1D
 | No. of cylinders, configuration |  | 4, in line |  | 4, in line | 4, in line | 4, in line | 4, in line
 | Valves per cylinder |  | 4 |  | 4 | 4 | 2 | 4
 | Engine capacity | cm3 | 998 |  | 1598 | 1997 | 1461 | 1995
 | Bore x stroke | [NAME] | 71.0 x 63.0 |  | 78.0 x 83.6 | 84 x 90.1 | 76.0 x 80.5 | 84 x 90
 | [NAME]. engine power | [NAME] | 48(65)/5600 |  | 84(115)/6000 | 103(140)/6000 | 78(106)/4000 | 110(150)/4000
 | [NAME]. torque | Nm/min-1 | 90/3600 |  | 160/4400 | 193/4800 | 240/2000 | 320/2000
 | Fuel type |  | Unleaded [NAME] 95 |  | Unleaded [NAME] 95 | Unleaded [NAME] 95 | Diesel | Diesel
 | Fuel supply |  | Multi point injection |  | Multi point injection | Multi point injection | Common Rail Direct Injection | Common Rail Direct Injection
 | Emission control system |  | 3-way catalyst |  | 3-way catalyst | 3-way catalyst | Oxidation catalyst | Oxidation catalyst with Diesel Particulate Filter
 | Emissions Level |  | EU3 |  | EU4 | EU4 | EU4 | EU4
CHASSIS
 | Suspension  front |  | Independent Mac Pherson strut, coil springs |  | Independent MacPherson strut, rebound springs | Independent MacPherson strut, rebound springs | Independent MacPherson strut, rebound springs | Independent MacPherson strut, rebound springs
 | rear |  | Torsion beam axle, coil springs |  | Independant Multilink, rebound springs | Independant Multilink, rebound springs | Independant Multilink, rebound springs | Independant Multilink, rebound springs
 | Steering |  | Electric Power assisted rack & pinion |  | Electric Power assisted rack & pinion | Electric Power assisted rack & pinion | Electric Power assisted rack & pinion | Electric Power assisted rack & pinion
 | Braking system |  | Disc front, drum rear, diagonal circuit, power assisted |  | Front and Rear Discs, power assisted | Front and Rear Discs, power assisted | Front and Rear Discs, power assisted | Front and Rear Discs, power assisted
 |  |  | with ABS, EBD and brake assist |  | with ABS, EBD and brake assist | with ABS, EBD and brake assist | with ABS, EBD and brake assist | with ABS, EBD and brake assist
WEIGHTS & DIMENSIONS
 | Overall length | [NAME] | 3715 |  | 4310 | 4310 | 4310 | 4310
 | Overall width | [NAME] | 1660 |  | 1780 | 1780 | 1780 | 1780
 | Overall height | [NAME] | 1540 |  | 1610 | 1610 | 1610 | 1610
 | Wheelbase | [NAME] | 2430 |  | 2630 | 2630 | 2630 | 2630
Spreadsheet: 111755d1308066524-create-pivot-table-agent-summary1
Sheet: desired display

 |  | Agent1 | Agent2 | Agent3 | Agent4 | Agent5 | Agent6
Jan | Calls Handled | 157 | 340 | 236 | 178 | 532 | 1443
 | Calls Presented | 181 | 352 | 275 | 242 | 552 | 1602
 | Handle Ratio | 0.8674 | 0.9659 | 0.8582 | 0.7355 | 0.9638 | 0.9007
Feb | Calls Handled | 117 | 280 | 288 | 129 | 530 | 1344
 | Calls Presented | 130 | 289 | 319 | 155 | 547 | 1440
 | Handle Ratio | 0.9 | 0.9689 | 0.9028 | 0.8323 | 0.9689 | 0.9333