tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: craig_dean__4369__1-24act
Sheet: EPEData

 | 37376.47013888889
 | NEWMAN 1 ,UNAV, -0  , 75  , 39  , 83  ,  0  ,1
 | NEWMAN 2 ,ECON, 37  , 70  , 34  , 83  , 30  ,1
 | NEWMAN 3 ,ECON, 99  ,100  , 35  ,103  ,  0  ,1
 | NEWMN/GT1,MANL, 20  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,MANL, 20  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,UNAV,  0  ,215  , 86  ,214  ,  0  ,1
 | NEWMAN   ,, 176 ,  290,  105, 306 ,  30 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,AVAL,  0  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,AVAL,  0  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,UNAV,  0  ,121  , 36  ,151  ,  0  ,1
 | RIOGRANDE,,   0 ,    0,    0,   0 ,   0 ,
 | PALOVERDE,MANL,605  ,600  ,600  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 52  , 52  , 52  ,104  ,  0  ,1
 | LAMBDA, 40.71,  679,  678,  115,    5,    0,11664,0
 | APS     ,FIRM    ,FC,  ,  25,  25
 | IID     ,FIRM    ,PV,  ,  59,  59
 | PGT     ,LOSS    ,LC,  ,  -1,  -2
 | PNM     ,LOSS    ,WM,  ,   3,   3
 | SRP     ,LOSS    ,PV,  ,   4,   4
 | TNP     ,FIRM    ,HI,  ,  60,  60
 | TNP     ,LOSS    ,AM,  ,  -2,  -2
 | SRP     ,LOSS    ,PV,  ,   4,   4
 | TNP     ,LOSS    ,AM,  ,  -2,  -2
 | CISO    ,FIRM    ,PV,  ,  78,   0
 | TNP     ,LOSS    ,AM,  ,  -2,  -2
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
 | 37300.62986111111
 | NEWMAN 1 ,UNAV, -0  , 75  , 39  , 83  ,  0  ,1
 | NEWMAN 2 ,MANL, 39  , 75  , 34  , 83  ,  0  ,1
 | NEWMAN 3 ,ECON, 38  ,100  , 35  ,103  , 40  ,1
 | NEWMN/GT1,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,ECON,174  ,215  , 86  ,214  , 41  ,1
 | NEWMAN   ,, 251 ,  390,  155, 400 ,  81 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,AVAL,  0  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,AVAL,  0  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,UNAV,  0  ,121  , 36  ,151  ,  0  ,1
 | RIOGRANDE,,   0 ,    0,    0,   0 ,   0 ,
 | PALOVERDE,MANL,603  ,600  ,600  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 51  , 51  , 51  ,104  ,  0  ,1
 | LAMBDA, 23.51,  798,  796,   80,   -3,    0,11060,21
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
Spreadsheet: 50787d1250263376-running-figures-in-pivot-tables-example-data-view
Sheet: Sheet1

Sum of entry
Data set 1 | Data set 2 | Total
A | Item a1 | 63
 | Item b1 | 22
 | Item c1 | 21
 | Item d1 | 20
 | Item e1 | 15
A total |  | 141
A average |  | 28.2
A median |  | 21
A count |  | 5
B | Item a2 | 217
 | Item b2 | 152
 | Item c2 | 135
 | Item d2 | 89
 | Item e2 | 83
 | Item f2 | 64
 | Item g2 | 60
 | Item h2 | 55
 | Item i2 | 50
 | [NAME] | 48
 | Item k2 | 46
 | Item l2 | 42
 | Item m2 | 36
 | Item n2 | 35
 | Item o2 | 34
 | Item p2 | 26
 | Item q2 | 26
 | Item r2 | 25
 | Item s2 | 24
 | Item t2 | 19
 | Item u2 | 15
 | Item v2 | 7
 | Item x2 | 7
B Total |  | 1295
B average |  | 56.3
B median |  | 42
B count |  | 23
Grand Total |  | 1436
Grand average |  | 51.28
Grand median |  | 35.5
Grand count |  | 28
Spreadsheet: 868583d1715274491-need-help-creating-a-formula-to-calculate-unit-goals-novice-yearly-review
Sheet: Tech Efficiency

Technician Yearly Review | Employee Name: | Technician Level : Apprentice/C | Location: | Hire Date: 6.23.23 | Review Date:
Efficiency Summary:
Year 23/24 | Worked Hrs | [NAME] (Target 160) | [NAME] -/+ | Actual Billable Labor $ | [NAME] @ $125 hr based on 160 hour target
Jan (24) | 165 | 91 | -69 | 5500 | -14300
Feb (24) | 165 | 128 | -32 | 7900 | -12100
March (24) | 162 | 135 | -25 | 10650 | -9350
April (24) | 169 | 130 | -30 | 10050 | -9950
May
June
July | 122 | 60 | -100 | 2800
Aug | 184 | 123 | -37 | 9300
Sept (23) | 157 | 117 | -43 | 8500 | -11500
Oct (23) | 163 | 131 | -29 | 9980 | -10020
Nov (23) | 162 | 124 | -36 | 9227 | -10573
Dec (23) | 154 | 134 | -26 | 10500 | -10700
Comeback Summary:
Year 23/24 | MTD Comback Total | MTD Loss Total $
Jan (24)
Feb (24)
March (24)
April (24)
May
June
July
Aug
Sept (23)
Oct (23)
Nov (23)
Dec (23)
Attendence Summary:
Year 23/24 | Unexcused Absence | Tardy | No Call No Show
Jan (24)
Feb (24)
March (24)
April (24)
May
June
July
Aug
Sept (23)
Oct (23)
Nov (23)
Dec (23)
Spreadsheet: 07d2a0fc-e390-490b-a0cb-90f0e6aff532
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
 | Data Area |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 73 | 21 | 20 | 37 | 13 | 80 | 6 | 70 | 10 | 55 |  | 10
 | 19 |  | 46 | 13 | 1 |  | 3 | 23 | 3 | 47
 | 65 | 65 | 13 | 37 | 47 | 23 | 97 | 23 | 13 | 95
 | 57 | 42 | 8 | 100 | 6 | 12 | 3 | 82 | 16 | 69
 | 37 |  | 51 | 33 | 49 | 90 | 75 | 92 |  | 6
 | 91 | 53 | 17 | 90 | 35 | 19 | 95 | 17 | 30
 | 70 | 20 | 20 | 30 | 10 | 80 | 0 | 70 | 10 | 50
 | 10 |  | 40 | 10 | 0 |  | 0 | 20 | 0 | 40
 | 60 | 60 | 10 | 30 | 40 | 20 | 90 | 20 | 10 | 90
 | 50 | 40 | 0 | 100 | 0 | 10 | 0 | 80 | 10 | 60
 | 30 |  | 50 | 30 | 40 | 90 | 70 | 90 |  | 0
 | 90 | 50 | 10 | 90 | 30 | 10 | 90 | 10 | 30
 | 100 | X
 | 90 | X | X | X | X | X | X | X
 | 80 | X | X
 | 70 | X | X | X
 | 60 | X | X | X
 | 50 | X | X | X | X
 | 40 | X | X | X | X | X
 | 30 | X | X | X | X | X | X
 | 20 | X | X | X | X | X
 | 10 | X | X | X | X | X | X | X | X | X | X | X
 | 0 | X | X | X | X | X | X | X | X
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
 | Stem | Leaf
Spreadsheet: 884276d1733356089-three-dimensional-lookup-table-formula-for-excelforum
Sheet: DataSource

Emp ID | Start Date | End Date | UNOPAY | OVTPAY | REGPAY
1 | 2024-09-29 00:00:00 | 2024-10-12 00:00:00 | 100 | 200 | 300
1 | 2024-10-13 00:00:00 | 2024-10-26 00:00:00 | 400 | 500 | 600
1 | 2024-10-27 00:00:00 | 2024-11-09 00:00:00 | 700 | 800 | 900
2 | 2024-09-29 00:00:00 | 2024-10-12 00:00:00 | 1000 | 1100 | 1200
2 | 2024-10-13 00:00:00 | 2024-10-26 00:00:00 | 1300 | 1400 | 1500
2 | 2024-10-27 00:00:00 | 2024-11-09 00:00:00 | 1600 | 1700 | 1800
Spreadsheet: 755588d1636980648-trouble-with-indexing-test-upload-file
Sheet: Values Sheet

Product Name | [NAME] | Lower | Upper
Product 1 | 0 | 1 | 6 |  |  |  |  |  |  | Product 1
Product 1 | 45 | 2 | 7 |  |  |  |  |  |  | Product 2
Product 1 | 75 | 3 | 8 |  |  |  |  |  |  | Product 4
Product 1 | 95 | 4 | 9
Product 2 | 0 | 5 | 10
Product 2 | 45 | 6 | 11
Product 2 | 75 | 7 | 12
Product 2 | 95 | 8 | 13
Product 3 | 0 | 9 | 14
Product 3 | 45 | 10 | 15
Product 3 | 75 | 11 | 16
Product 3 | 95 | 12 | 17
Product 4 | 0 | 13 | 18
Product 4 | 45 | 14 | 19
Product 4 | 75 | 15 | 20
Product 4 | 95 | 16 | 21
Product 5 | 0 | 17 | 22
Product 5 | 45 | 18 | 23
Product 5 | 75 | 19 | 24
Product 5 | 95 | 20 | 25
Product 6 | 0 | 21 | 26
Product 6 | 45 | 22 | 27
Product 6 | 75 | 23 | 28
Product 6 | 95 | 24 | 29
Spreadsheet: 737803d1624614546-sql-conversion-rown-into-colums-matching-same-first-value-sql-example
Sheet: Sheet1

What it looks like |  |  |  |  |  | How it should look
Name | Attr ID | Attr Name | Value |  |  | Name | Age | Height | BMI | Modified BY | Created By
[NAME] | 1 | Age | 25
[NAME] | 2 | Height | 5'10" |  |  | [NAME]
[NAME] | 3 | BMI | 27 |  |  | [NAME]
[NAME] | 4 | Modified By | System
[NAME] | 1 | Age | 26
[NAME] | 2 | Height | 5'9"
[NAME] | 3 | BMI | 25
[NAME] | 5 | Created By | User1
[NAME] | 1 | Age | 29
[NAME] | 2 | Height | 6'2"
[NAME] | 4 | Modified By | User2
Spreadsheet: 693517d1599003221-need-a-sum-or-other-count-formula-6-30-2020-test-version-1-
Sheet: Sheet3

Receiver | Lines | Pieces | Time | LPH | Goal | Goal %
SJ073819
JR059209
CP031059
AZ060726 |  |  | 6.75 |  | 23
MF048911 |  |  | 7 |  | 8
CG032686
WC075660 |  |  | 5.5 |  | 18
JE082086 |  |  | 7 |  | 23
JM059984 |  |  | 7 |  | 8
DM063300 |  |  | 6 |  | 8
SA075689
BL076548 |  |  | 3 |  | 18
AW079933
0
Total
Complexity
Spreadsheet: 62800d1263812049-sumif-reference-to-date-attendancesummary
Sheet: DailyAttendance

[NAME] |  |  |  |  | Training Totals:
 |  |  |  |  | [NAME]: |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
Total Training Sessions: 2 Days;   Trainee per Class: 6 |  |  |  |  | Training Dates: |  |  |  | 2010-01-18 00:00:00 |  |  |  | 2010-01-19 00:00:00 |  |  |  |  | 2010-01-20 00:00:00 |  |  |  | 2010-01-21 00:00:00 |  |  |  |  | 2010-01-22 00:00:00 |  |  |  | 2010-01-23 00:00:00 |  |  |  |  | 2010-01-25 00:00:00 |  |  |  | 2010-01-26 00:00:00 |  |  |  |  | 2010-01-27 00:00:00 |  |  |  | 2010-01-28 00:00:00
PROVIDER | AREA ID | AREA | Early Start Training Date | Early End Training Date | Scheduled Trainee | [NAME] | Total Trainee Variance | Certified  Total | Expected | Actual | [NAME] | Attd Pect | Expected | Actual | [NAME] | Attd Pect | Certified | Expected | Actual | [NAME] | Attd Pect | Expected | Actual | [NAME] | Attd Pect | Certified | Expected | Actual | [NAME] | Attd Pect | Expected | Actual | [NAME] | Attd Pect | Certified | Expected | Actual | [NAME] | Attd Pect | Expected | Actual | [NAME] | Attd Pect | Certified | Expected | Actual | [NAME] | Attd Pect | Expected | Actual | [NAME] | Attd Pect | Certified
ProviderA | 1 | AMBER | 2010-01-18 00:00:00 | 2010-02-04 00:00:00 |  |  |  |  | 6 |  |  |  | 6 |  |  |  |  | 6 |  |  |  | 6 |  |  |  |  | 6 |  |  |  | 6 |  |  |  |  | 6 |  |  |  | 6 |  |  |  |  | 6 |  |  |  | 6
ProviderC | 2 | BASIL | 2010-01-18 00:00:00 | 2010-01-26 00:00:00 |  |  |  |  | 6 |  |  |  | 6 |  |  |  |  | 6 |  |  |  | 6 |  |  |  |  | 6 |  |  |  | 6 |  |  |  |  | 5 |  |  |  | 5
ProviderB | 3 | BATER | 2010-01-18 00:00:00 | 2010-01-28 00:00:00 |  |  |  |  | 6 |  |  |  | 6 |  |  |  |  | 6 |  |  |  | 6 |  |  |  |  | 5 |  |  |  | 5 |  |  |  |  | 5 |  |  |  | 5 |  |  |  |  | 2 |  |  |  | 2
ProviderC | 4 | BABEL | 2010-01-18 00:00:00 | 2010-01-28 00:00:00 |  |  |  |  | 6 |  |  |  | 6 |  |  |  |  | 6 |  |  |  | 6 |  |  |  |  | 4 |  |  |  | 4 |  |  |  |  | 4 |  |  |  | 4 |  |  |  |  | 4 |  |  |  | 4
ProviderB | 5 | BARREL | 2010-01-18 00:00:00 | 2010-01-30 00:00:00 |  |  |  |  | 6 |  |  |  | 6 |  |  |  |  | 6 |  |  |  | 6 |  |  |  |  | 6 |  |  |  | 6 |  |  |  |  | 6 |  |  |  | 6 |  |  |  |  | 6 |  |  |  | 6
ProviderC | 6 | TOWER | 2010-01-18 00:00:00 | 2010-01-30 00:00:00 |  |  |  |  | 6 |  |  |  | 6 |  |  |  |  | 6 |  |  |  | 6 |  |  |  |  | 6 |  |  |  | 6 |  |  |  |  | 6 |  |  |  | 6 |  |  |  |  | 6 |  |  |  | 6
ProviderB | 7 | DUMMY | 2010-01-18 00:00:00 | 2010-01-26 00:00:00 |  |  |  |  | 6 |  |  |  | 6 |  |  |  |  | 6 |  |  |  | 6 |  |  |  |  | 6 |  |  |  | 6 |  |  |  |  | 3 |  |  |  | 3
Spreadsheet: 114340d1310090974-nested-ifs-or-array-logic_example
Sheet: 2005

YEAR 2005 CODES/RATES
List 1 | P | T | Global |  | List 2 | P | T | Global
100 | 4.15 | 12.3 |  |  | 200 | 11.11 | 333
101 | 3.21 | 44.65 |  |  | 201 | 21.22 | 323
102 | 44.32 | 4.4 |  |  | 202 | 221.1 | 435
103 | 6.43 | 3.22 |  |  | 203 | 332 | 543
104 | 8.08 | 654.44 |  |  | 204 | 2 | 3
105 | 9.43 | 323.33 |  |  | 205 | 22.23 | 6.35
106 | 2.21 | 35.77 |  |  | 206 | 215.2 | 9.6
107 | 32.11 | 8.7 |  |  | 207 | 54.65 | 66.65
108 | 24.76 | 6.48 |  |  | 208 | 95.5 | 54
109 | 543.4 | 9.09 |  |  | 209 | 9.48 | 102.5
110 | 65.65 | 99.98 |  |  | 210 | 12.21 | 2
111 | 88.67 | 126 |  |  | 211 | 11.23 | 55.8
Spreadsheet: 51282d1250808636-show-info-in-column-c-if-a-and-b-match-criteria-psp-outreach-report-template-draft-08-04-09-fs
Sheet: December

 |  | Week of 11/3 | Week of 11/10 | Week of 11/17 | Week of 11/24
[NAME] |  | She sounds really good.  She gave me the rundown in all of her classes, and seems to have at least a "C" in all of them.  Usually when I talk to her at about this point in a semester she is sounding pretty discouraged so it was good to hear her more spirited!  she is having some problems with a roommate but she said that if it continues to be bad she'll just switch at the end of the semester.  She also said that she thinks she is on track to graduate on time (fall 2010) which is great!
School:
Previous Units:
Previous GPA:
GPA Trend:
[NAME]. GPA:
Class Standing:
Previously Full-Time:
Currently Full-Time:
Outreach:
Independence:
Program Standing:
Spreadsheet: kate_symes__18515__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-01-26 00:00:00 |  | 295.64 | 17424 | 254.65 | 3832
 | 2001-01-25 00:00:00 |  | 319.38 | 15024 | 295.88 | 1272 | 296.66 | 437 | 234.61 | 965
 | 2001-01-24 00:00:00 |  | 307.59 | 18224 | 261.91 | 2872 | 290.03 | 291 | 291.18 | 807
 | 2001-01-23 00:00:00 |  | 329.11 | 18624 | 254.24 | 4712 | 309.54 | 1107 | 305 | 200
 | 2001-01-22 00:00:00 |  | 393.64 | 26784 | 333.06 | 3312 | 351.61 | 465 | 314.65 | 1500
 | 2001-01-21 00:00:00 |  | 300 | 800 | 337.5 | 0 | 367 | 625 | 318.16 | 435 |  | 335.88 | 8736
 | 2001-01-20 00:00:00 |  | 559.4 | 25088 | 411.6 | 8344 | 362.89 | 291 | 286.58 | 300
 | 2001-01-19 00:00:00 |  | 559.4 | 25088 | 411.6 | 8344 | 376.11 | 836 | 283.47 | 546
 | 2001-01-18 00:00:00 |  | 481.44 | 21424 | 392.14 | 5112 | 454.07 | 393 | 294.21 | 380
 | 2001-01-17 00:00:00 |  | 272.66 | 29824 | 248.16 | 6312 | 428.17 | 196 | 285.3 | 495
 | 2001-01-16 00:00:00 |  | 179.29 | 23760 | 158.21 | 3800 | 422.32 | 6337 | 190 | 50
 | 2001-01-15 00:00:00 |  | 179.29 | 23760 | 158.21 | 3800 | 205.96 | 83 | 210 | 22
 | 2001-01-14 00:00:00 |  | 158.5 | 0 | 152.5 | 0 | 175.38 | 920 | 157.2 | 820 |  | 152.44 | 15000
 | 2001-01-13 00:00:00 |  | 158.65 | 17648 | 151.85 | 6600 | 180.04 | 1330 | 158.51 | 865
 | 2001-01-12 00:00:00 |  | 171.71 | 16368 | 147.69 | 5432 | 181.08 | 185 | 149.35 | 575
 | 2001-01-11 00:00:00 |  | 171.43 | 15360 | 147.59 | 5936 | 157.64 | 254 | 119.48 | 1146
 | 2001-01-10 00:00:00 |  | 157.57 | 15328 | 144.37 | 5680 | 149.25 | 499 | 120.6 | 712
 | 2001-01-09 00:00:00 |  | 152.13 | 22160 | 145.73 | 6400 | 148.76 | 1729 | 123.36 | 640
 | 2001-01-08 00:00:00 |  | 147.54 | 22800 | 130.49 | 6480 | 115.32 | 470 | 102.22 | 1125
 | 2001-01-07 00:00:00 |  | 140 | 0 | 130 | 0 | 119.61 | 888 | 82.66 | 800 |  | 130.49 | 19440
 | 2001-01-06 00:00:00 |  | 146.05 | 22800 | 135.85 | 3616 | 103.18 | 1305 | 98.34 | 1325
 | 2001-01-05 00:00:00 |  | 146.05 | 22800 | 135.85 | 3616 | 134.44 | 1345 | 120.8 | 1155
 | 2001-01-04 00:00:00 |  | 152.95 | 20280 | 139.1 | 5544 | 143.03 | 190 | 127.53 | 415
 | 2001-01-03 00:00:00 |  | 175.7 | 14400 | 163.68 | 3800 | 156.14 | 485 | 127.71 | 648
 | 2001-01-02 00:00:00 |  | 185.67 | 14400 | 176.33 | 3000 | 142.46 | 2097 | 126.6 | 1453
 | 2001-01-01 00:00:00 |  | 187.5 | 0 | 175 | 0 | 111.05 | 95 | 110 | 300 |  | 176.33 | 9000
 | 2000-12-31 00:00:00 |  | 167.5 | 0 | 157.5 | 0 | 150.12 | 2630 | 110 | 450 |  | 164.5 | 19440
 | 2000-12-30 00:00:00 |  | 171.7 | 19408 | 160.7 | 5608 | 146.38 | 705 | 145.32 | 1175
 | 2000-12-29 00:00:00 |  | 217.65 | 10992 | 169.05 | 3208 | 214.02 | 1107 | 166.68 | 674
 | 2000-12-28 00:00:00 |  | 217.65 | 10992 | 169.05 | 3208 | 190.98 | 1381 | 158.36 | 802
 | 2000-12-27 00:00:00 |  | 394.68 | 12400 | 267.17 | 3320 | 165.54 | 2855 | 159.35 | 1123
 |  |  |  |  |  | ..
Spreadsheet: 462923d1464249720-multiple-criteria-vlookup-with-index-and-match-of-idxmatch
Sheet: Sheet1

 |  |  |  |  | ID |  | Postal | Lookup |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Postal | ID | Bag |  |  | aggregate
 |  |  |  |  | 1572 |  | 760175 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 670236 | 1711 | 16 |  |  |  |  | ,=IFERROR(LOOKUP(2,1/(Y$2:Y$555=H2)/(Z$2:Z$555=F2),AA$2:AA$555),"")
 |  |  |  |  | 1680 |  | 760175 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 640458 | 1913 | 18 |  |  |  |  | ,=IFERROR(AGGREGATE(15,6,AA$2:AA$555/(Y$2:Y$555=H2)/(Z$2:Z$555=F2),1),"")
 |  |  |  |  | 1562 |  | 750469 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 640518 | 1750 | 16
 |  |  |  |  | xxx |  | 750422 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 649848 | 1801 | 15
 |  |  |  |  | 1908 |  | 791440 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 640977 | 1813 | 20
 |  |  |  |  | yyy |  | 568402 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 641989 | 1977 | 16
 |  |  |  |  | 1843 |  | 550529 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 120118 | 1587 | 6
 |  |  |  |  | 1812 |  | 530101 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 228192 | 1875 | 11
 |  |  |  |  | 1950 |  | 530952 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 180008 | 1751 | 32
 |  |  |  |  | zz |  | 543180 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 289850 | 1854 | 23
 |  |  |  |  | 1775 |  | 824617 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 760175 | 1572 | 14
 |  |  |  |  | 1737 |  | 510637 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 750469 | 1562 | 22
 |  |  |  |  | 1717 |  | 524498 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 760125 | 1680 | 14
 |  |  |  |  | 1919 |  | 522524 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 791440 | 1908 | 27
 |  |  |  |  | 1876 |  | 521160 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 824617 | 1775 | 13
 |  |  |  |  | 1874 |  | 460412 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 330022 | 1558 | 24
 |  |  |  |  | new |  | 460412 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 310470 | 1871 | 20
 |  |  |  |  | what if |  | 460412 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 530101 | 1812 | 23
Spreadsheet: 690567d1597168274-conditional-formatting-finding-duplicates-across-multple-sheets-asset-management-and-location-information
Sheet: 2020 Refresh List

 |  | Notes | Ordered? | Received | New CI | New CI S/N | New CI Model | Tag Number | CRQ | Old CI Name | Old CI S/N | Tag Number | Old [NAME] | Status | Status Reason / Last Connected | [NAME] | Product Categorization Tier 1 | Product Categorization Tier 2 | Product Categorization Tier 3 | System Role | System Environment | Company | Site | Room | Inventory Name | Managed By | Used By | Owner Name | Owner Contact | Submitter | Audit Date | Purchase Date | Received Date | Create Date | Confirmed Date | Last Scan Date | Disposal Date | [NAME]
 | 1 | So this would be a dupe from [NAME] | 7/9/2020 | 8/11/2020 | [NAME] | CNDABC123 | HP 650 i7 G5 | 301100 | 12345 | [NAME] | CNDABC123 | 3011010 | HP 650 i7 G2
 | 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
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 61
 | 62
 | 63
 | 64
 | 65
 | 67
 | 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: 0fd24d53-6001-4ae7-a1a1-4fd93bc842f1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | ФОРМА H
МЕЖДУНАРОДНАЯ ОРГАНИЗАЦИЯ ГРАЖДАНСКОЙ АВИАЦИИ
ФОРМА ОТЧЕТНОСТИ ПО ВОЗДУШНОМУ ТРАНСПОРТУ
РЕЕСТРОВЫЙ ПАРК ГРАЖДАНСКИХ ВОЗДУШНЫХ СУДОВ
[NAME]
для связи: |  |  | Государство:
Организация:
[NAME].: |  |  |  | на 31 декабря:
Факс:
E-mail:
ЧАСТЬ I. СВОДКА О РЕЕСТРОВОМ ПАРКЕ ВСЕХ ВОЗДУШНЫХ СУДОВ
КАТЕГОРИЯ ВОЗДУШНЫХ СУДОВ |  |  |  | ОБЩЕЕ КОЛИЧЕСТВО
 |  |  |  | ВОЗДУШНЫХ СУДОВ
 |  |  |  | 9 000 кг                   (20 000 фунтов)        и более | 9 000 кг                 (20 000 фунтов)        и менее
a |  |  |  | b | c
ВОЗДУШНЫЕ СУДА С ФИКСИРОВАННЫМ КРЫЛОМ
Турбореактивные
с 6 двигателями
с 4 двигателями
с 3 двигателями
с 2 двигателями
с 1 двигателем
[NAME]
с 4 двигателями
с 3 двигателями
с 2 двигателями
с 1 двигателем
Винтовые (поршневые)
с 4 двигателями
с 3 двигателями
с 2 двигателями
с 1 двигателем
ВИНТОКРЫЛЫЕ ЛЕТАТЕЛЬНЫЕ АППАРАТЫ
С турбинным двигателем
с 2 двигателями
с 1 двигателем
С винтовым двигателем
с 2 двигателями
с 1 двигателем
ЧАСТЬ II. КОЛИЧЕСТВО КРУПНЫХ ВОЗДУШНЫХ СУДОВ ПО ТИПАМ
ТИП ВОЗДУШНЫХ СУДОВ |  |  |  |  | ОБЩЕЕ КОЛ-ВО ВОЗДУШНЫХ СУДОВ
Перечислить все воздушные суда, имеющие [NAME] 9 000 кг (20 000 фунтов) и более, и включенные в цифровые данные, [NAME] в графе b [NAME]
a |  |  |  |  | b
Примечания (включая информацию о любых неизбежных отклонениях от инструкции по заполнению):
Spreadsheet: 71352630-3043-479a-a7bc-a7690b9a82ad
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
COHBB | Test | COHBB | [NAME], Blood | [NAME], B | Carboxyhemoglobin-Co-oximetry | EDTA (lavender-top) tube: EDTA |  |  | 1 | mL | Container/Tube: Lavender top (EDTA) [NAME]: 1 mL Collection Instructions: Avoid exposure of specimen to atmosphere. | 0.1 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | Normal: <7% 1% (lower limit of detectability) <15% (heavy smoker) Toxic concentration: > or =20% | Monday through Friday; 12 a.m. | Same day/1 day | 2 days | 1 | 82375 |  |  |  |  | Rochester
COHBB | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient | 14 days
COHBB | Result | 8649 | [NAME], B | [NAME], B | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 20563-3
Spreadsheet: 219f7b4e-71ad-45fe-8742-3eac7858d06e
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
11/02/2014 | Wrestling | Michigan State Open | 10:00 AM | NTS
11/13/2014 | Wrestling | Arizona State | 08:00 PM | L, 13-19
11/22/2014 | Wrestling | Navy Classic (Annapolis, Md.) | 10:00 AM | 5th
11/29/2014 | Wrestling | vs. Northern Illinois (Journeymen/Asics Northeast Duals - Troy, N.Y.) | 09:30 AM
11/29/2014 | Wrestling | vs. Rutgers (Journeymen/Asics Northeast Duals - Troy, N.Y.) | 02:35 PM
11/29/2014 | Wrestling | vs. Cornell (Journeymen/Asics Northeast Duals - Troy, N.Y.) | 11:30 AM
12/05/2014 | Wrestling | Cliff [NAME] Invitational | 12:00 PM
12/06/2014 | Wrestling | Cliff [NAME] Invitational | 12:00 PM
12/19/2014 | Wrestling | at Lock Haven | 07:00 PM
01/03/2015 | Wrestling | at Grand Canyon | 07:00 PM
01/04/2015 | Wrestling | at Arizona State | 06:00 PM
01/09/2015 | Wrestling | Virginia Duals (Hampton, Va.)
01/10/2015 | Wrestling | Virginia Duals (Hampton, Va.)
01/16/2015 | Wrestling | at Oklahoma State | 07:00 PM
01/18/2015 | Wrestling | at Oklahoma | 07:00 PM
02/06/2015 | Wrestling | at Clarion | 06:00 PM
02/07/2015 | Wrestling | Iowa State | 06:00 PM
02/15/2015 | Wrestling | Ohio | 01:00 PM
02/20/2015 | Wrestling | Edinboro | 08:00 PM
02/22/2015 | Wrestling | at Pittsburgh | 02:00 PM
03/07/2015 | Wrestling | Big 12 Championships (Ames, Iowa)
[NAME] | Wrestling | [NAME] (St. Louis, Mo.)
03/20/2015 | Wrestling | [NAME] (St. Louis, Mo.)
03/21/2015 | Wrestling | [NAME] (St. Louis, Mo.)