tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 50109d1249495939-excel-2007-count-blank-cells-in-one-column-that-also-meet-a-date-condition-in-another-column-illustrative-worksheet2
Sheet: Sheet1

Date recvd | Acct Balance | Transfer Date
2009-01-02 00:00:00 | 100 | 2009-02-02 00:00:00
2009-02-02 00:00:00 | 200 | 2009-02-02 00:00:00 |  | See Sheet two for analytical resultings needed!!
2009-03-03 00:00:00 | 300 | 2009-03-03 00:00:00
2009-04-04 00:00:00 | 400
2009-05-05 00:00:00 | 500
2009-06-06 00:00:00 | 600 | 2009-04-04 00:00:00
2009-07-07 00:00:00 | 700
2009-08-01 00:00:00 | 800 | 2009-05-05 00:00:00
2009-08-05 00:00:00 | 900
 | 10
 | 20 | 2009-06-26 00:00:00
Spreadsheet: 34477d1231781219-follow-up-to-using-count-but-now-with-interupted-cells-wbprototype
Sheet: Fresh &Ancilliary

 | Period 5 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  | Total |  | [NAME] | [NAME]
 | week 4 | Plan | Actual | Plan | Actual | Plan | Actual | Plan | Actual | Plan | Actual | Plan | Actual | Plan | Actual | Plan | Actual | Lw Pl Prod | Lw Act Prod
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 625 | 595
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 108 | 117
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 152 | 131
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 44 | 66
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 71 | 89
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 67 | 57
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 42 | 67
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 177 | 177
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Spreadsheet: 866233d1713196976-how-to-copy-and-paste-information-if-contents-of-another-cell-match-book1
Sheet: Emails

FIRM | CNAME | TNAME | ADDRESS1 | ADDRESS2 | ADDRESS3 | CITY | PROVST | COUNTRY | PCODE | APHONE | AFAX | NICCODE | GROUPEDYN | Firm                Number | Cont                Num | Contact            Last Name | Contact            First Name | Contact             E-Mail | Contact              Type
310880 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Smith | [NAME] | [EMAIL] | Web
311079 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [EMAIL] | Web
311198 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [EMAIL] | Web
311245 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Ringo | [EMAIL] | [NAME]
311318 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | George | [EMAIL] | Web
311648 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sutcliffe | Stuart | [EMAIL] | [NAME]
311666 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Best | [NAME] | [EMAIL] | Web
311687 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chapman | [NAME] | [EMAIL] | [NAME]
320267 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nicol | [NAME] | [EMAIL] | Web
Spreadsheet: 840424d1692719275-conutifs-row-and-column-data-1-
Sheet: summary

 | DEBBIE
 | HEO Learning Needs Analysis
 |  |  |  |  |  | COUNT & % (count/heo)
 | Learning Area | Courses | Reference | Media | Access From | 1 | 2 | 3 | 4
 |  | NAME
 | Induction &  Onboarding | DWP Induction | N/A | Various | Intranet
 |  | ODP Induction Learning (2020) | N/A | E Learning | Civil Service Learning
 |  | Diversity and inclusion - I Can Be Me campaign | N/A | Open Learning | Intranet
 |  | [NAME] | N/A | Open Learning | Intranet
Spreadsheet: 629525d1561393917-help-with-a-string-of-if-statements-sample
Sheet: Base Case Cashflow

 |  |  |  |  |  |  | Year 1 |  |  |  | Year 2 |  |  |  | Year 3 |  |  |  | Year 4 |  |  |  | Year 5
Property Address | Tenant | Lease Start | Lease Break | Lease Expiry | Rent | VOID (# [NAME]) | Q3 2019 | Q4 2019 | Q1 2020 | Q2 2020 | Q3 2020 | Q4 2020 | Q1 2021 | Q2 2021 | Q3 2021 | Q4 2021 | Q1 2022 | Q2 2022 | Q3 2022 | [NAME] | Q1 2023 | Q2 2023 | Q3 2023 | Q4 2023 | Q1 2024 | Q2 2024
 |  | 2019-06-24 00:00:00 | 2022-06-30 00:00:00 | 2021-06-30 00:00:00 | 500000 | 2
Initial Loan Requirement |  |  |  | Opening Bal
Property Value |  |  |  | [NAME]
Annuity Loan Profile on |  |  |  | [NAME]
Term |  |  |  | Closing LTV
Gross Rent
Interest p.a.
Service Charges & Costs - lessee
Profit before tax
Tax Payable (estimated) @
Total Interest, Expenses & Tax
Cashflow available pre Principal Repayments p.a.
Net Cashflow Available per above
Add back interest
Cashflow available for Debt Servicing
Cashflow after Debt Servicing
Gross Interest Cover
DSCR Pre Tax
DSCR Post Tax
Surplus Cashflow Available p.a. - pre tax
Surplus Cashflow Available p.a. - post tax
Tax Calculation
Rent
Expenses
Interest
Interest Dissalowed |  |  | 0
Capital Allowance |  |  | 0
Taxable Surplus
Tax Payable @
Rent Reserve
Opening reserve |  |  |  |  |  |  | 0
Surplus Cashflow Available p.a. - post tax
Cumulative reserve
Spreadsheet: e42e9268-823a-4a43-8449-5d58ddb713a8
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
SURM | Test | SURM | Trimipramine (Surmontilr) | Trimipramine (Surmontil) | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp OR Plain, Red-Top Tube: Red OR |  |  | 2 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top (sodium heparin) tube(s).  ([NAME] is not acceptable.)   Spin down and send 2 mL of sodium heparin plasma refrigerated. Note:	1.	Indicate plasma on request form. 	2.	[NAME] specimen appropriately (plasma). 	3. Trough levels are most reproducible   Serum Draw blood in a plain red-top tube(s).  (Serum gel tube is not acceptable.)  Spin down and send 2 mL of serum refrigerated. Note:	1.	Indicate serum on request form. 	2.	[NAME] specimen appropriately (serum). 	3. Trough levels are most reproducible | 0.4 mL NOTE: Submission of the m | Specimens other than	Plasma, serum Anticoagulants other than	Sodium heparin, EDTA, plain red-top Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | [NAME]: 50-300 ng/mL   Test Performed By: Medtox Laboratories, Inc. 402 W. County Road D St. Paul, MN  55112 | Monday through Sunday | 3 days | 5-7 days | 1 | 82542 |  |  |  |  | Medtox Laboratories, Inc
SURM | [NAME] | VARIES | Varies |  |  |  | Refrigerated
SURM | Result | Z1126 | Trimipramine (Surmontil) | Trimipramine (Surmontil) | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 631403d1562662236-distance-between-coordinates-shown-in-a-sorted-list-distance_between_locations_dummy
Sheet: Data

Location ID | Coordinate X | Coordinate Y
PG343 | 646860 | 248249
PL122 | 646860 | 248249
[NAME] | 647150 | 249980
KO420 | 665069 | 259111
OL942 | 656550 | 256150
PY492 | 643443 | 237911
PT940 | 643443 | 237911
HY675 | 655820 | 257720
[NAME] | 656260 | 249240
KH387 | 648322 | 246675
UB482 | 655642 | 247923
HF029 | 653510 | 246900
RH392 | 653510 | 246900
LN392 | 671310 | 243990
ES492 | 650560 | 236088
NJ111 | 656622 | 232628
LK392 | 656622 | 232628
KL329 | 635070 | 236500
GF329 | 635070 | 236500
DF392 | 633251 | 239845
DR029 | 638611 | 263271
SD932 | 637023 | 261981
WE942 | 637023 | 261981
DE902 | 668849 | 245006
[NAME] | 665580 | 258800
RH992 | 665580 | 258800
LR012 | 645850 | 249150
[NAME] | 665470 | 258450
OR654 | 668855 | 245017
ZH257 ??
Spreadsheet: 158507d1338286249-sumif-s-with-changeable-conditions-knjiga1
Sheet: List1

Date | W.O. | Shift | Engineer I | Engineer II | Job description | ROLES | m
2012-01-03 00:00:00 | 1 | I | [NAME] | [NAME] | Lakiranje | 1 | 10326.71714071346
2012-01-03 00:00:00 | 1 | II | [NAME] | Kević Antonio | Lakiranje | 1 | 804.8564217993315
2012-01-03 00:00:00 | 1 | II | [NAME] | Kević Antonio | Lakiranje | 2 | 2578.268876611418
2012-01-03 00:00:00 | 1 | II | [NAME] | Kević Antonio | Lakiranje | 3 | 11213.4233681195
2012-01-03 00:00:00 | 1 | II | [NAME] | Kević Antonio | Lakiranje | 4 | 10613.19146033695
2012-01-03 00:00:00 | 1 | II | [NAME] | Kević Antonio | Lakiranje | 5 | 11568.10585908192
2012-01-03 00:00:00 | 1 | II | [NAME] | Kević Antonio | Lakiranje | 6 | 11049.72375690608
2012-01-03 00:00:00 | 2 | III | [NAME] | Živković Krunoslav | Lakiranje | 7 | 10162.08952716889
2012-01-03 00:00:00 | 2 | III | [NAME] | Živković Krunoslav | Lakiranje | 8 | 11001.93163685227
2012-01-03 00:00:00 | 2 | III | [NAME] | Živković Krunoslav | Lakiranje | 9 | 11141.9053217995
2012-01-03 00:00:00 | 2 | III | [NAME] | Živković Krunoslav | Lakiranje | 10 | 9532.207944906357
2012-01-04 00:00:00 | 2 | I | [NAME] | [NAME] | Lakiranje | 10 | 1917.63948377705
2012-01-04 00:00:00 | 2 | I | [NAME] | [NAME] | Lakiranje | 11 | 10973.93689986283
2012-01-04 00:00:00 | 2 | I | [NAME] | [NAME] | Lakiranje | 12 | 11505.8369026623
2012-01-04 00:00:00 | 2 | I | [NAME] | [NAME] | Lakiranje | 13 | 11589.82111363064
2012-01-04 00:00:00 | 2 | I | [NAME] | [NAME] | Lakiranje | 14 | 11169.90005878895
2012-01-04 00:00:00 | 2 | I | [NAME] | [NAME] | Lakiranje | 15 | 2421.544749587078
2012-01-04 00:00:00 | 2 | II | [NAME] | Kević Antonio | Lakiranje | 15 | 9084.292153075221
2012-01-04 00:00:00 | 2 | II | [NAME] | Kević Antonio | Lakiranje | 16 | 11449.84742868341
2012-01-04 00:00:00 | 2 | II | [NAME] | Kević Antonio | Lakiranje | 17 | 11617.81585062008
2012-01-04 00:00:00 | 2 | II | [NAME] | Kević Antonio | Lakiranje | 18 | 11141.9053217995
2012-01-04 00:00:00 | 2 | II | [NAME] | Kević Antonio | Lakiranje | 19 | 7026.678984350941
2012-01-04 00:00:00 | 2 | III | [NAME] | Živković Krunoslav | Lakiranje | 19 | 3919.263178522438
2012-01-04 00:00:00 | 2 | III | [NAME] | Živković Krunoslav | Lakiranje | 20 | 10162.08952716889
2012-01-04 00:00:00 | 2 | III | [NAME] | Živković Krunoslav | Lakiranje | 21 | 11169.90005878895
2012-01-04 00:00:00 | 2 | III | [NAME] | Živković Krunoslav | Lakiranje | 22 | 11169.90005878895
2012-01-05 00:00:00 | 2 | I | Mihaljević Milenko | [NAME] | Lakiranje | 23 | 10945.94216287338
2012-01-05 00:00:00 | 2 | I | Mihaljević Milenko | [NAME] | Lakiranje | 24 | 11169.90005878895
Spreadsheet: 129270d1321530587-sketching-using-simple-dimensions-graph
Sheet: Graph

 | EDGE OUTLINES
 | 200 | 14200 |  | 200 | 14200 |  | 200 | 200 |  | 14200 | 14200
 | 4200 | 4200 |  | 200 | 200 |  | 200 | 4200 |  | 200 | 4200
 | INNER OUTLINES
 | 345 | 14045 |  | 345 | 14045 |  | 345 | 345 |  | 14045 | 14045
 | 4040 | 4040 |  | 360 | 360 |  | 360 | 4040 |  | 345 | 4040
 | PLANKS |  | 345
 |  |  | 360
 | Plank 1 |  |  |  |  |  |  | Plank 2 |  |  |  |  |  |  | Plank 3 |  |  |  |  |  |  | Plank 4 |  |  |  |  |  |  | Plank 5 |  |  |  |  |  |  | Plank 6
 | Height |  |  | [NAME] |  |  |  | Height |  |  | [NAME] |  |  |  | Height |  |  | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  | Height |  |  | [NAME] |  |  |  | Height |  |  | [NAME]
 | A | B |  | C | D |  |  | G | H |  | I | J |  |  | G | H |  | I | J |  |  | G | H |  | I | J |  |  | G | H |  | I | J |  |  | G | H |  | I | J
X ---
Y ---
 | A | C |  | B | D |  |  | G | I |  | H | J |  |  | G | I |  | H | J |  |  | G | I |  | H | J |  |  | G | I |  | H | J |  |  | G | I |  | H | J
X
Y
 | Shutters
 | Shutter 1 |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | Shutter 3 |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | Shutter 5 |  |  |  |  |  |  | Shutter 6
 | [NAME] |  |  | Height | 3680 |  |  | [NAME] |  |  | Height | 3680 |  |  | [NAME] |  |  | Height | 3680 |  |  | [NAME] |  |  | Height | 3680 |  |  | [NAME] |  |  | Height | 3680 |  |  | [NAME] |  |  | Height | 3680
 | B | E |  | G | F |  |  | B | E |  | G | F |  |  | B | E |  | G | F |  |  | B | E |  | G | F |  |  | B | E |  | G | F |  |  | B | E |  | G | F
Spreadsheet: 00308bfc-d90d-4389-b4f5-e2c4867e4ee2
Sheet: Sheet1

[NAME], FY 2004 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | Students | Students | Total
 | Given | Who Worked | Dollar Value
 | Fee | in Lieu of a | of Fees
District | Waivers | [NAME] | Waived
Alpine | 3504 | 0 | 381803
Beaver | 0 | 0 | 0
[NAME] | 843 | 34 | 90111
Cache | 816 | 0 | 89443
Carbon | 542 | 23 | 26804
Daggett | 0 | 0 | 0
[NAME] | 2431 | 4 | 184866
Duchesne | 423 | 5 | 23581
Emery | 240 | 0 | 14646
[NAME] | 58 | 17 | 3513
Grand | 153 | 0 | 18601
Granite | 10346 | 5 | 785307
Iron | 761 | 0 | 52297
Jordan | 4629 | 0 | 269664
[NAME] | 138 | 0 | 5450
[NAME] | 137 | 0 | 7842
Millard | 128 | 24 | 7805
Morgan | 55 | 0 | 4411
Nebo | 1256 | 17 | 70675
No. Sanpete | 342 | 0 | 11930
No. Summit | 20 | 0 | 453
Park City | 223 | 0 | 22741
Piute | 17 | 0 | 604
Rich | 17 | 0 | 840
San Juan | 919 | 0 | 39440
Sevier | 475 | 0 | 28455
So. Sanpete | 124 | 0 | 12846
So. Summit | 9 | 0 | 1894
Tintic | 0 | 0 | 0
Tooele | 930 | 3 | 76481
Uintah | 328 | 0 | 34021
Wasatch | 283 | 0 | 15996
Washington | 2096 | 6 | 112676
Wayne | 31 | 0 | 2195
Weber | 1404 | 0 | 102056
[NAME] | 4563 | 55 | 309875
Ogden | 3121 | 0 | 211738
Provo | 4578 | 0 | 242150
Logan | 699 | 89 | 57191
[NAME] | 449 | 135 | 17361
Subtotal | 47088 | 417 | 3337762
CBA Center | 18 | 0 | 470
Center City | 55 | 0 | 1375
Tuacahn HS for Perf. Arts | 12 | 0 | 1740
Total Charter | 85 | 0 | 3585
TOTAL | 47173 | 417 | 3341347
Spreadsheet: 781563d1653416853-averageif-across-multiple-sheets-q1-agents-metrics-copy
Sheet: Agent Budget

CSR Entry Level Pay |  |  | Today |  |  |  |  |  |  | Shift Differentials |  |  | # Of CSRS | [NAME] | Management
1st Shift - |  | 9 | 8.5 |  |  |  |  |  |  |  |  |  | 1 | 72 | 4 | [NAME]
Mid Shift - |  |  |  | MUST always maintain availability up to 8:00pm |  |  |  |  |  | 0 |  |  | 4 | 134 |  | Nichelle
2nd Shift - |  |  |  | MUST always maintain availability up to 11:00pm |  |  |  |  |  | 0.25 |  |  | 4 | 113 |  | Lesia
[NAME] |  |  |  | MUST always maintain availability at 6:00am |  |  |  |  |  | 0.5 |  |  | 4 | 115 |  | Pam
Switchover - |  |  |  | MUST always maintain availability between 4:00p-8:30p |  |  |  |  |  | 0.5 |  |  | 4 | 145
[NAME] |  |  |  | MUST always maintain open availability |  |  |  |  |  | 0
Every Saturday/Weekenders - |  |  |  | MUST always maintain open availability on Saturdays and/or Sundays |  |  |  |  |  | 0 |  |  | 3 | 39
Qualify for IPP after 30 days
 | Level 1 - | 1.25 | 1.25
 | Level 2 - | 0.75 | 0.75
 | Total Bonus -
Raise fter 90 days of employment - |  |  |  | 0.25
Assistant Leads/Trainers
1st Shift - |  | 10.75 | 9.75 |  |  |  |  |  |  |  |  | Bev | 1 | 40
2nd Shift - |  | 11.25 |  |  |  |  |  |  |  |  | Sha'Nee | [NAME] | 2 | 72
Leads
1st Shift - |  | 12 | 11 |  |  |  |  |  |  |  | [NAME] | Anne | 2 | 80
2nd Shift - |  | 12.5 |  |  |  |  |  |  |  | [NAME] | [NAME] | ? | 3 | 60
Overnight Shift - |  | 11 | 10 |  |  |  |  |  |  |  |  |  | 2 | 80
PERMANENT EMPLOYEE RATES |  |  |  |  |  |  | AVERAGE PAYOUTS PER WEEK |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  | (bonus amt * hrs) * 0.5)
CSR |  |  | Base | Level 1 | Level 2 |  | Base | Level 1 | Level 2
1st Shift -
Mid Shift -
2nd Shift -
[NAME]
Switchover -
[NAME]
Every Saturday -
 |  |  |  |  |  | TOTAL
Assistant Leads/Trainers
1st Shift -
2nd Shift -
 |  |  |  |  |  | TOTAL
Leads
1st Shift -
2nd Shift -
 |  |  |  |  |  | TOTAL
Overnight Shift - |  |  |  |  |  | TOTAL
AVERAGE WEEKLY AGENT BUDGET
Average Agent Payroll Hours - |  |  |  |  |  | TOTAL
Average Agent Payroll Budet -
 |  |  |  |  |  |  | Base | Level 1 | Level 2
 | NEW  WEEKLY BUDGET
 | CURRENT WKLY BUDGET |  | 9564.5 |  |  |  | 8628.5 | 585 | 351
 | DIFFERENCE
 | NEW ANNUAL
 | CURRENT ANNUAL
 | DIFFERENCE
Spreadsheet: debra_perlingiere__8471__Empire District MP II
Sheet: AMASTPSA 

MASTER FIRM PURCHASE/SALE AGREEMENT INFORMATION SHEET
ENA Entity: | ENA | ATTORNEY:
DATE: | 2001-06-06 00:00:00 | ENA | [NAME]
COUNTERPARTY: | Empire District Electric Company | CONTACT: | [NAME]
ADDRESS: | 602 Joplin Street | TITLE: | Energy Trader.
 |  | PHONE: | [PHONE]
 | [NAME], 64801 | FAX: | [PHONE]
INCORPORATION STATE: |  | S&P RATING: | A-
STRUCTURE | COUNTERPARTY | ECT Entity.
COLLATERAL | $7.00MM | $10.00MM
THRESHOLD in $[NAME]
COMMITTED VOLUMES
THRESHOLD in $[NAME] | N/A | N/A
COLLATERAL REQUIRED FOR:
ALL TRADES
OTHER | N/A | N/A
COLLATERAL TYPE
Letter of Credit | OK | OK
COLLATERAL  MULTIPLE | 250000 | 250000
GUARANTOR (RATING) |  | Enron Corp. (BBB+)
LIMIT in $[NAME] |  | $10.00MM
Incorporation State: |  | OR
MATERIAL ADVERSE CHANGE TRIGGERS  APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change | X | X
-Below = | BBB- | BBB- | S&P
Financial Covenants
-Funded Debt/Net Worth
-Minimum Net worth
-Cash Flow/CMLTD
-Current Ratio
Non-Specific
-Unilateral
Ownership Change
-Less than 51% owned by:
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
EVENTS OF DEFAULT
3rd party debt
-Counterparty | $15MM
-Guarantor ($[NAME]) |  | $[NAME]
FIN'L STATEMENTS
-Standard | X | X | Upon request
CREDIT DECISION: | APPROVED:  X | DECLINED:
OUTSTANDING PHYSICAL TRADES: |  | NO: | NO:
ALL TRADES TO ROLL UP UNDER NEW MASTER: |  | NO: | NO:
OTHER COMMENTS
CREDIT REVIEW  PREPARED BY: |  | [NAME] | X5-3596
Spreadsheet: 800569d1665744419-lookup-with-multiple-criteria-example5-2-
Sheet: Sheet1

Position | Player | Daily H'cap | GA Handicap | Gross | Nett | Gender |  | Daily H'cap |  | Male
1 | Carol | 26 | 23.1 | 93 | 67 | Female | A Grade (M) | 0 | 12
2 | Garry | 30 | 29.2 | 98 | 68 | Male | B Grade (M) | 13 | 18
3 | Trevor | 14 | 14.5 | 83 | 69 | Male | C Grade (M) | 19 | 36
4 | [NAME] | 5 | 3.6 | 76 | 71 | Male
5 | [NAME] | 3 | 1.7 | 74 | 71 | Male |  | Daily H'cap |  | Female
6 | [NAME] | 13 | 10.7 | 84 | 71 | Male | A Grade (F) | 0 | 20
7 | [NAME] | 18 | 18.0 | 89 | 71 | Male | B Grade (F) | 20 | 54
8 | Billy | 14 | 11.5 | 86^^ | 72^^ | Male
9 | Martina | 16 | 14.1 | 88 | 72 | Female
10 | [NAME] | 5 | 3.2 | 77 | 72 | Male
11 | [NAME] | 13 | 13.6 | 86 | 73 | Male
12 | [NAME] | 9 | 7.6 | 82 | 73 | Male
13 | [NAME] | 12 | 9.6 | 85 | 73 | Male
14 | [NAME] | 13 | 11.0 | 86 | 73 | Male
15 | [NAME] | 18 | 18.2 | 91 | 73 | Male
16 | Ian | 3 |  |  | 74 | Male
 | Ian | 4 |  |  | 75
PAR COMP
Position | Player | Daily H'cap | GA Handicap | Gross | Nett | Gender
1 | [NAME] | 15 | 11.8 | 58 | +3 | Male | A Grade (M) | 0 | 12
2 | [NAME] | 23 | 21.7 | 77 | +3 | Male | B Grade (M) | 13 | 18
3 | [NAME] | 15 | 14.1 | 66 | +2 | Male | C Grade (M) | 19 | 36
4 | Nathan | 6 | 4.4 | 76 | +2 | Male
5 | [NAME] | 10 | 8.0 | 61 | +2 | Male |  | Daily H'cap |  | Female
6 | [NAME] | 14 | 11.6 | 78 | +2 | Male | A Grade (F) | 0 | 20
7 | [NAME] | 9 | 6.8 | 51 | +1 | Male | B Grade (F) | 20 | 54
8 | [NAME] | 15 | 14.0 | 50 | +1 | Male
9 | Jeanne | 23 | 19.2 | 73 | +1 | Female
10 | [NAME] | 14 | 11.1 | 84 | +1 | Male
11 | [NAME] | 16 | 15.4 | 73 | +1 | Male
12 | [NAME] | 17 | 16.7 | 68 | +1 | Male
13 | [NAME] | 26 | 21.3 | 60 | 0 | Male
14 | Mark | 16 | 13.3 | 76 | 0 | Male
15 | [NAME] | 34 | 29.5 | 61 | 0 | Female
STABLEFORD COMP
Position | Player | Daily Handicap | GA Handicap | Gross | Nett
1 | [NAME] | 15 | 15.2 | 81 | 42 | Male | A Grade (M) | 0 | 12
2 | [NAME] | 23 | 22.7 | 74 | 41 | Male | B Grade (M) | 13 | 18
3 | Mark | 7 | 5.8 | 78 | 37 | Male | C Grade (M) | 19 | 36
4 | [NAME] | 22 | 18.8 | 86 | 37 | Female
5 | Martina | 18 | 15.2 | 89 | 37 | Female |  | Daily H'cap |  | Female
6 | [NAME] | 12 | 10.2 | 70 | 37 | Male | A Grade (F) | 0 | 20
7 | Ian | 20 | 20.0 | 86 | 36 | Male | B Grade (F) | 20 | 54
8 | [NAME] | 6 | 4.9 | 79 | 35 | Female
9 | [NAME] | 14 | 14.1 | 73 | 35 | Male
10 | [NAME] | 14 | 11.5 | 87 | 35 | Female
11 | [NAME] | 12 | 9.4 | 78 | 35 | Male
12 | [NAME] | 11 | 9.1 | 85 | 34 | Male
13 | [NAME] | 19 | 16.1 | 77 | 34 | Female
14 | [NAME] | 24 | 23.9 | 83 | 34 | Male
15 | [NAME] | 17 | 17.2 | 76 | 34 | Male
Spreadsheet: 793501d1661513100-reduce-time-needed-to-complete-expanding-an-array-formula-excel-forum
Sheet: Sheet1

Order number | Line-item number |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
1 | 1 |  | 1
2 | 1 |  | 2
2 | 2 |  | 3
3 | 4 |  | 4
3 | 3
4 | 2
4 | 1
Spreadsheet: 679940d1590694848-modifying-formula-sumproduct-and-count-test_couchwitcher
Sheet: Feuil1

Number | Color | Employee | EmployeeCard
20 | Orange | [NAME] | Yellow |  | Good count should be 2: | 2
20 | Red | [NAME] | Yellow |  | Bad count (current formula):
20 | Orange | Syl | Orange
22 | Green | [NAME] | Green
21 | Yellow | Fred | Orange |  | the 3 number 20 have the word Orange. They are duplicate numbers and should be counted as 1
22 | Green | Syl | Green |  | The 1 number 21 has the word. Not a duplicate, so count as one
20 | Orange | Stacy | Orange
Spreadsheet: 151734d1335095757-error-message-the-pivottable-field-is-not-valid-3ak
Sheet: MC AI

 | MARSHELLING CABINET  AI - F
 | B |  |  |  | C |  |  |  | D
 | CABLE NO. | CABLE SIZE |  |  | CABLE NO. | CABLE SIZE |  |  | CABLE NO. | CABLE SIZE
MLS-01 | 1071-218-LIT  -202 | 1P X 1.5 MM2 | #N/A | MLS-03 | 1071-218-SA-337 | 12P X 1.0 MM2 | #N/A | MRS-01 | 1071-218-SA-111 | 12P X 1.0 MM2 | #N/A
MLS-01 | 1071-218-SA-131 | 12P X 1.0 MM2 | #N/A | MLS-03 | 1071-218-SA-347 | 12P X 1.0 MM2 | #N/A | MRS-01 | 1071-218-SA-112 | 12P X 1.0 MM2 | #N/A
MLS-01 | 1071-218-SA-132 | 12P X 1.0 MM2 | #N/A | MLS-03 | 1071-218-SA-357 | 12P X 1.0 MM2 | #N/A | MRS-01 | 1071-218-SA-447 | 12P X 1.0 MM2 | #N/A
MLS-02 | 1071-218-PIT  -419A | 1P X 1.5 MM2 | #N/A | MLS-04 | 1071-218-PIT  -419C | 1P X 1.5 MM2 | #N/A | MRS-02 | 1071-218-SA-152 | 12P X 1.0 MM2 | #N/A
MLS-02 | 1071-218-PIT  -932 | 1P X 1.5 MM2 | #N/A | MLS-04 | 1071-218-SA-181 | 12P X 1.0 MM2 | #N/A | MRS-02 | 1071-218-SA-155 | 24P X 1.0 MM2 | #N/A
MLS-02 | 1071-218-SA-133 | 12P X 1.0 MM2 | #N/A | MLS-04 | 1071-218-SA-182 | 12P X 1.0 MM2 | #N/A | MRS-03 | 1071-218-SA-153 | 24P X 1.0 MM2 | #N/A
MLS-02 | 1071-218-SA-151 | 12P X 1.0 MM2 | #N/A
MLS-03 | 1071-218-PIT  -419B | 1P X 1.5 MM2 | #N/A
MLS-03 | 1071-218-SA-327 | 12P X 1.0 MM2 | #N/A
 |  | 4x1p |  |  |  | 5x12p |  |  |  | 4x12p
 |  | 5x12p |  |  |  | 1x1p |  |  |  | 2x24p
 | MARSHELLING CABINET  AI - R
 | B |  |  |  | C |  |  |  | D
 | CABLE NO. | CABLE SIZE |  |  | CABLE NO. | CABLE SIZE |  |  | CABLE NO. | CABLE SIZE
MLS-16 | 1071-218-SA-154 | 24P X 1.0 MM2 | #N/A | MLS-19 | 1071-218-SA-184 | 24P X 1.0 MM2 |  | MLS-21 | 1071-218-SA-397 | 12P X 1.0 MM2
MLS-17 | 1071-218-SA-156 | 24P X 1.0 MM2 | #N/A | MLS-20 | 1071-218-SA-185 | 12P X 1.0 MM2 |  | MLS-22 | 1071-218-SA-407 | 12P X 1.0 MM2
MLS-17 | 1071-218-SA-221 | 12P X 1.0 MM2 | #N/A | MLS-20 | 1071-218-SA-186 | 12P X 1.0 MM2 |  | MLS-22 | 1071-218-SA-417 | 12P X 1.0 MM2
MLS-18 | 1071-218-SA-183 | 24P X 1.0 MM2 | #N/A | MLS-21 | 1071-218-SA-367 | 12P X 1.0 MM2 |  | MLS-22 | 1071-218-SA-427 | 12P X 1.0 MM2
 |  |  |  | MLS-21 | 1071-218-SA-377 | 12P X 1.0 MM2 |  | MLS-22 | 1071-218-SA-437 | 12P X 1.0 MM2
 |  |  |  | MLS-21 | 1071-218-SA-387 | 12P X 1.0 MM2
 |  | 3X24P |  |  |  | 5X12P |  |  |  | 5X12P
 |  | 1X12P |  |  |  | 1X24P