tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 822315d1679262165-filter-function-nested-if-multi-better-simpler-expression-combobox-filter-sort-unique-az-srch-xl21-
Sheet: DATA

MAKE | MODEL | FUEL | TYPE | DESC | IG |  | UNIQUE MAKE |  | Formula SRCH Col A | Formula SRCH Col B | Formula SRCH Col C | Formula SRCH Col D |  | 1BOX |  | 2O6 | DIESEL | Hdi | [NAME] | 7 |  | 2BOX |  |  |  |  |  |  |  | 3BOX |  |  |  |  |  |  |  | 4BOX |  |  |  |  |  |  |  | BLANK
Peugeot | 2O7 | PETROL | Gti | OK | 15 |  |  |  |  |  |  |  |  |  | Peugeot | 2O6 | PETROL | GTI | Sporty | 10
Peugeot | 3O6 | DIESEL | TD | [NAME] | 13 |  |  |  |  | 2O7 |  |  |  |  | Peugeot | 2O6 | DIESEL | GT Hdi | [NAME] | 7
Honda | Civic | PETROL | Type R | [NAME] | 13 |  |  |  |  | 3O6 |  |  |  |  | Peugeot | 2O7 | PETROL | Gti | OK | 15
Fiat | Panda | PETROL | Dlux | Poor |  |  |  |  |  | 3O7 |  |  |  |  | Peugeot | 3O6 | DIESEL | TD | [NAME] | 13
Citreon | Ax | PETROL | Vibe | Poor |  |  |  |  |  |  |  |  |  |  | Peugeot | 3O7 | DIESEL | Hdi | [NAME] | 11
Vauxhall | Nova | PETROL | SRI | Dull | 8 |  |  |  |  |  |  |  |  |  | Peugeot | 3O7 | DIESEL | Hdi | Super | 11
Rover Metro | Metro | PETROL | Club | Dull
Peugeot | 3O7 | DIESEL | Hdi | [NAME] | 11
Peugeot | 2O6 | DIESEL | Hdi | [NAME] | 7
Bmw | 3 series | DIESEL | Tdi | Nice | 10
Bmw | Z4 | PETROL | Sport | Great | 15
Bmw | X4 | PETROL | 4WD | 4x4 | 16
Renault | Megane | DIESEL | Dci | Great | 8
Proton | Impian | PETROL | Sport | Dull | 8
Ford | Focus | DIESEL | TDCi | Great | 11
Honda | Civic | DIESEL | CDTi | Great | 10
Peugeot | 3O7 | DIESEL | Hdi | Super | 11
Fiat | Punto | PETROL | Sport | Tidy | 8
Vauxhall | Astra | PETROL | VXR | Great | 9
Peugeot | 2O6 | PETROL | GTI | Sporty | 10
Honda | Civic | DIESEL | CDTi | Excellent | 10
Peugeot | 2O6 | DIESEL | GT Hdi | [NAME] | 7
Bmw | 3 series | DIESEL | Tdi | Nice | 10
Bmw | 3 series | DIESEL | [NAME] | Nice | 10
Spreadsheet: 884642d1733882014-calculating-what-fiscal-years-expenses-will-hit-in-fy-expense
Sheet: Sheet2 (2)

 |  | Cur FY | 2024-07-01 00:00:00 | 2025-06-30 00:00:00
 |  | FY25
 |  |  |  |  |  | FYE | 2025-06-30 00:00:00
 | Start Date | End Date | Amount | Contract # of months | Cur Year Mos Left | Avg Cost | Cur Year Cost | FY26 Cost | FY27 Cost
Project A | 2024-07-01 00:00:00 | 2025-06-30 00:00:00 | 120000
Project B | 2025-01-01 00:00:00 | 2026-03-31 00:00:00 | 150000
Project C | 2024-07-01 00:00:00 | 2027-06-30 00:00:00 | 360000
Project D | 2023-08-01 00:00:00 | 2026-06-30 00:00:00 | 350000
 |  |  |  |  |  | With financial year end dates in H4:J4
 |  |  |  |  |  | In H6, copy across and down:
Spreadsheet: 143342d1330372249-vlookup-based-on-cell-content-plain-sales-sheet
Sheet: Summary

Summary
In Progress
Contract name | Consultant | Type | Turnover | Value
Spreadsheet: 881964d1730211501-would-an-if-statement-work-in-this-example-cash-tracker
Sheet: Sheet1

Cash App Tracker 2024 |  |  |  |  | Notes
App Used | Date | Name | Amount | Paid Back
Cash App | 2024-01-04 00:00:00 | [NAME] | 40 | N | [NAME]'s B/Day Gift
Cash APP | 2024-03-17 00:00:00 | [NAME] | 50 | N | Gas & Milk
Cash App | 2024-04-22 00:00:00 | [NAME] | 20 | Y | Gas
Cash App | 2024-04-27 00:00:00 | [NAME] | 100 | N | Clothes for kids
[NAME] | 2024-05-09 00:00:00 | [NAME] | 25 | N | Gas
[NAME] | 2024-05-21 00:00:00 | [NAME] | 25 | N | Gas
[NAME] | 2024-05-26 00:00:00 | [NAME] | 30 | N | Gas,Milk,laundry
[NAME] | 2024-06-18 00:00:00 | [NAME] | 50 | N | Gas
[NAME] | 2024-06-19 00:00:00 | [NAME] | 25 | N | Gas
[NAME] | 2024-06-20 00:00:00 | [NAME] | 25 | N | Pull ups
[NAME] | 2024-06-25 00:00:00 | [NAME] | 20 | N | Gas
[NAME] | 2024-07-07 00:00:00 | [NAME] | 20 | N | Gas
[NAME] | 2024-07-29 00:00:00 | [NAME] | 100 | N | Gas,Food
[NAME] | 2024-08-01 00:00:00 | [NAME] | 100 | N | Internet Bill
[NAME] | 2024-08-05 00:00:00 | [NAME] | 100 | N | Light [NAME]
[NAME] | 2024-08-25 00:00:00 | [NAME] | 25 | N | Gas
[NAME] | 2024-10-07 00:00:00 | [NAME] | 20 | N | Gas
[NAME] | 2024-10-11 00:00:00 | [NAME] | 150 | N | Money for expenses
[NAME] | 2024-10-17 00:00:00 | [NAME] | 150 | Y | Money for expenses
[NAME] | 2024-10-21 00:00:00 | [NAME] | 10 | N | food
[NAME] | 2024-10-29 00:00:00 | [NAME] | 25 | N | Gas
 |  | Total Borrowed
 |  | Paid Back
Spreadsheet: 271899d1382102236-formula-for-giving-people-experience-against-tools-they-used-not-working-competa
Sheet: Sheet3

codes | description |  |  | INI | ENG
CACR | Casing Circulator |  |  | IR | [NAME]
IILH | Internal Inflate Leak Hunting |  |  | SR | [NAME]
POFR | [NAME]
PRBP | Pull Release Bridge Plug
PRCR | Pull Release Cement Retainer/Squeeze Packer
PRKT | PR Kit
RRBP | Rotate Release Bridge Plug
RRCR | Rotate Release Cement Retainer/Squeeze Packer
SCC | Single CAP - Casing
SCH | Stage Cementing - Hatchpacker
SCL | Single CAP - Liner
SCRP | Stage Cementing - Rotational Port Collar
SCSS | Stage Cementing - Sliding Sleeve Port Collar
SCST | Stage Cementing - Stage Tool
SL | Scab Liner
SLPA | [NAME]
SPCS | Straddle Packer Coil Set
SPCT | Single Packer Coil Set
SPWS | Single Packer Workstring Set
SPWS | Straddle Packer Workstring Set
SSA | 7-1/2" Single Set Applications
Spreadsheet: 855f53e4-bcf9-4755-b014-2a94e8d317ac
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
FLUC | Test | FLUC | 5-Flucytosine, Serum | 5-Flucytosine, S | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | Plain, Red-Top Tube: Red OR |  |  | 1 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL Collection Instructions:  1. Serum for a peak level should be drawn 1 to 2 hours after oral dose or 30 minutes after intravenous infusion. Trough specimens should be drawn immediately prior to next scheduled dose.  2. Spin down within 2 hours of draw. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.3 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK - refreeze Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	[NAME] | Therapeutic concentration: Peak >25.0 mcg/mL (difficult infections may require higher concentrations) Toxic concentration: Peak >100.0 mcg/mL | Tuesday, Thursday, 9 a.m. | 2 days | 8 days | 1 | 80299 |  |  |  |  | Rochester
FLUC | [NAME] | SERUM | Serum |  |  |  | Frozen | 14 days
FLUC | Result | 82741 | 5-Flucytosine, S | 5-Flucytosine, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 3639-2
Spreadsheet: 158947d1338458221-create-dynamic-chart-in-excel-2003-test-example
Sheet: Sheet1

 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  | Name | [NAME] | [NAME] | [NAME] | [NAME] | Rnd 5 | Rnd 6 | [NAME] | [NAME] | [NAME] 9 | Rnd 10
 | 1 | [NAME] | 3 | 3 | 4
 | 2 | Jon | 4 | 6 | 5
 | 3 | Fred | 2 | 2 | 1
 | 4 | [NAME] | 2 | 3 | 4
 | 5 | [NAME] | 1 | 1 | 6
 | 6 | [NAME] | 6 | 4 | 3
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
Spreadsheet: 0dbe77f6-5b1b-422a-b755-d95d46b15e2e
Sheet: Sheet1

Table 5--Wheat: National average price received by farmers (dollars per bushel) 1/, 11/14/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Month | All wheat |  | Winter |  | Durum |  | Other spring
 | 2011/12 | 2012/13 | 2011/12 | 2012/13 | 2011/12 | 2012/13 | 2011/12 | 2012/13
June | 7.41 | 6.7 | 7.13 | 6.54 | 9.18 | 8.31 | 9.26 | 7.78
July | 7.1 | 7.93 | 6.77 | 7.79 | 10.2 | 8.6 | 8.45 | 8.53
August | 7.59 | 8.04 | 7.27 | 7.92 | 10.2 | 7.7 | 8.28 | 8.27
September | 7.54 | 8.27 | 7 | 8.25 | 10.8 | 7.74 | 8.09 | 8.38
October | 7.27 | 8.37 | 6.53 | 8.31 | 9.6 | 7.7 | 8.19 | 8.58
November | 7.3 |  | 6.44 |  | 10.3 |  | 8.43
December | 7.2 |  | 6.41 |  | 10.3 |  | 8.25
January | 7.05 |  | 6.57 |  | 8.84 |  | 8.09
February | 7.1 |  | 6.68 |  | 8.98 |  | 8.01
March | 7.2 |  | 6.7 |  | 8.39 |  | 8.04
April | 7.11 |  | 6.47 |  | 9.22 |  | 7.96
May | 6.67 |  | 6.42 |  | 8.95 |  | 7.93
1/ Preliminary mid-month, weighted-average price for current month. Source: USDA, National Agricultural Statistics Service, Agricultural Prices.
Date run: 11/9/2012
Spreadsheet: 865155d1712209846-too-many-if-and-statements-production_cost_calculator_test-aligw
Sheet: Envelopes

 | DL | C5 | C4
0 | 125 | 180 | 195
5000 | 85 | 170 | 175
10000 | 77 | 122.5 | 165
50000 | 49.5 | 75.5 | 136
100000 | 44 | 69 | 125
Spreadsheet: 35625d1233212080-returning-multiple-results-for-one-lookup-value-multivalue-return
Sheet: Data

Counter | STYLE | COO | Quantity | COLOR | CUTTING RATIO | 1ST COST
28711 | 2871 | USA | 352 | SILVERSTAR | XS-XL | 9.25
28791 | 2879 | USA | 350 | WHITE | XS-XL | 8.9
28961 | 2896 | USA | 502 | BLACK | XS-XL | 9.95
28561 | 2856 | USA | 600 | BLACK | XS-XL | 5.7
28641 | 2864 | USA | 300 | PINK | XS-XL | 6
28642 | 2864 | USA | 200 | GOLD | XS-XL | 6
28281 | 2828 | USA | 450 | YELLOW | XS-XL | 6.3
27841 | 2784 | USA | 300 | RED PEPPER | XS-XL | 5.5
27842 | 2784 | USA | 200 | AEGEAN SEA | XS-XL | 5.5
27501 | 2750 | USA | 250 | RED PEPPER | XS-XL | 5.71
27502 | 2750 | USA | 250 | CAVE | XS-XL | 5.6
Spreadsheet: 141796d1329456586-polynomial-equation-test
Sheet: Sheet1

 |  | Temperature
 |  | ·35 | -15 | -5 | 5 | 15 | 25 | 35 | 45 | 52
 | Length | 3085 | 3505 | 3716 | 3949 | 4192 | 4541 | 5181 | 5919 | 6493
Spreadsheet: 475743d1471445803-multiple-data-sets-to-graph-help-with-graphing
Sheet: # of Revisions

 |  | Jan | Jan % | Feb | Feb % | Mar | Mar % | Apr | Apr % | May | May % | June | June % | July | July % | Goal
 | Regional | 444 | 0.80032414910859 | 456 | 0.7818688981868899 | 666 | 0.65 | 566 | 0.44 | 555 | 0.66 | 461 | 0.7169517884914464 | 307 | 0.7223529411764706 | 0.9
 | FAS | 585 | 0.7961387434554974 | 567 | 0.7908840470823942 | 777 | 0.44 | 678 | 0.76 | 666 | 0.88 | 868 | 0.7463456577815993 | 815 | 0.7889641819941917 | 0.9
 | CIT/Canada | 999 | 0.7661691542288557 | 456 | 0.7169517884914464 | 888 | 0.89 | 876 | 0.92 | 777 | 0.29 | 163 | 0.8316326530612245 | 152 | 0.8837209302325582 | 0.9
 | National | 345 | 0.7807153965785381 | 982 | 0.7463456577815993 | 689 | 0.34 | 676 | 0.67 | 888 | 0.99 | 713 | 0.767491926803014 | 621 | 0.7657213316892725 | 0.9
Spreadsheet: a116eb45-63a7-442b-918d-b0f17fd1ec85
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
PMET | Test | PMET | Metanephrines, Fractionated, Free, Plasma | Metanephrines, Fract., Free, P | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | EDTA (lavender-top) tube: EDTA |  |  | 1 | mL | Collection Container/Tube: Lavender top (EDTA) Submission Container/Tube: Plastic vial [NAME]: 1 mL Additional Information: If plasma catecholamines will be performed on this specimen, see CATP/8532 [NAME], Plasma, Free for additional specimen requirements and restrictions. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.3 mL | Hemolysis	Mild OK; Moderate-reject if hemoglobin concentration is >250 mg/dL Thawing	Warm reject; Cold OK-refreeze Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | METANEPHRINE, FREE  <0.50 nmol/L  NORMETANEPHRINE, FREE <0.90 nmol/L | Monday through Saturday; 1 p.m.- Not Reported on Sunday | 2 days | 4 days | 1 | 83835 |  |  |  |  | Rochester
PMET | [NAME] | PLEDTA | [NAME] |  |  |  | Frozen | 14 days
PMET | Result | 10140 | Normetanephrine, Free | Normetanephrine, Free | Numeric |  |  |  |  | nmol/L |  |  |  |  |  |  |  |  |  | 40851-8
PMET | Result | 10139 | Metanephrine, Free | Metanephrine, Free | Numeric |  |  |  |  | nmol/L |  |  |  |  |  |  |  |  |  | 49700-8
Spreadsheet: 217422d1362065144-help-with-a-progressive-average-formula-ts1025436411
Sheet: Grading Criteria

 | Calculate Letter Grade
 | Enter in the percentage ranges for each letter grade in the table below to cutomize the template to your grading criteria.
 | GRADE & GPA Table (Used to calculate student grades on the [NAME] sheet)
 | Score | Letter Grade Achieved | GPA
 | 0 | F | 0
 | 0.6 | D- | 0.67
 | 0.63 | D | 1
 | 0.67 | [NAME] | 1.33
 | 0.7 | C- | 1.67
 | 0.73 | C | 2
 | 0.77 | C+ | 2.33
 | 0.8 | B- | 2.67
 | 0.83 | B | 3
 | 0.87 | [NAME] | 3.33
 | 0.9 | A- | 3.67
 | 0.93 | A | 4
 | 0.97 | A+ | 4
 | Score and GPA must be entered in Ascending order.
Spreadsheet: 216201d1361640215-filter-based-on-selected-range-filterforrange
Sheet: DATA

OrderDate | Region | Rep | Item | Units | Unit Cost | Total | Filter For
2010-01-06 00:00:00 | East | Jones | Pencil | 95 | 1.99
2010-01-23 00:00:00 | Central | Kivell | Binder | 50 | 19.99
2010-02-09 00:00:00 | Central | [NAME] | Pencil | 36 | 4.99
2010-02-26 00:00:00 | Central | [NAME] | Pen | 27 | 19.99
2010-03-15 00:00:00 | West | Sorvino | Pencil | 56 | 2.99
2010-04-01 00:00:00 | East | Jones | Binder | 60 | 4.99
2010-04-18 00:00:00 | Central | [NAME] | Pencil | 75 | 1.99
2010-05-05 00:00:00 | Central | [NAME] | Pencil | 90 | 4.99
2010-05-22 00:00:00 | West | Thompson | Pencil | 32 | 1.99
2010-06-08 00:00:00 | East | Jones | Binder | 60 | 8.99
2010-06-25 00:00:00 | Central | Morgan | Pencil | 90 | 4.99
2010-07-12 00:00:00 | East | [NAME] | Binder | 29 | 1.99
2010-07-29 00:00:00 | East | Parent | Binder | 81 | 19.99
2010-08-15 00:00:00 | East | Jones | Pencil | 35 | 4.99
2010-09-01 00:00:00 | Central | Smith | Desk | 2 | 125
2010-09-18 00:00:00 | East | Jones | Pen Set | 16 | 15.99
2010-10-05 00:00:00 | Central | Morgan | Binder | 28 | 8.99
2010-10-22 00:00:00 | East | Jones | Pen | 64 | 8.99
2010-11-08 00:00:00 | East | Parent | Pen | 15 | 19.99
2010-11-25 00:00:00 | Central | Kivell | Pen Set | 96 | 4.99
2010-12-12 00:00:00 | Central | Smith | Pencil | 67 | 1.29
2010-12-29 00:00:00 | East | Parent | Pen Set | 74 | 15.99
2011-01-15 00:00:00 | Central | [NAME] | Binder | 46 | 8.99
2011-02-01 00:00:00 | Central | Smith | Binder | 87 | 15
2011-02-18 00:00:00 | East | Jones | Binder | 4 | 4.99
2011-03-07 00:00:00 | West | Sorvino | Binder | 7 | 19.99
2011-03-24 00:00:00 | Central | [NAME] | Pen Set | 50 | 4.99
2011-04-10 00:00:00 | Central | [NAME] | Pencil | 66 | 1.99
2011-04-27 00:00:00 | East | [NAME] | Pen | 96 | 4.99
2011-05-14 00:00:00 | Central | [NAME] | Pencil | 53 | 1.29
2011-05-31 00:00:00 | Central | [NAME] | Binder | 80 | 8.99
2011-06-17 00:00:00 | Central | Kivell | Desk | 5 | 125
2011-07-04 00:00:00 | East | Jones | Pen Set | 62 | 4.99
2011-07-21 00:00:00 | Central | Morgan | Pen Set | 55 | 12.49
2011-08-07 00:00:00 | Central | Kivell | Pen Set | 42 | 23.95
2011-08-24 00:00:00 | West | Sorvino | Desk | 3 | 275
2011-09-10 00:00:00 | Central | [NAME] | Pencil | 7 | 1.29
2011-09-27 00:00:00 | West | Sorvino | Pen | 76 | 1.99
2011-10-14 00:00:00 | West | Thompson | Binder | 57 | 19.99
2011-10-31 00:00:00 | Central | [NAME] | Pencil | 14 | 1.29
2011-11-17 00:00:00 | Central | [NAME] | Binder | 11 | 4.99
2011-12-04 00:00:00 | Central | [NAME] | Binder | 94 | 19.99
2011-12-21 00:00:00 | Central | [NAME] | Binder | 28 | 4.99
Spreadsheet: 743301d1628381028-index-and-match-with-multiple-sheet-and-criteria-test-2
Sheet: Sheet2

ID | Name | Index & Match  Address ALL | INDEX & MATCH Naming field | Multiple critiera | Kendall GME KLO
RSI8927 | [NAME] |  |  |  | [NAME]
NSY8847 | [NAME]
[NAME] | [NAME]
TES1234 | [NAME] |  |  | Kendall GME KLO
HDU8906 | Anique
DUP1244 | Anique
TES1243 | Anique
 |  | Using the $x$4 aray
 |  | INDEX(DATA!$D$2:$D$8,MATCH(A2,DATA!$B$2:$B$8,0)) | INDEX(location,MATCH(A2,DATA!$B$2:$B$8,0))
Spreadsheet: 813022d1673513604-how-to-count-the-highest-possible-occurrence-in-multiple-tables-how-to-countif-highest-possible-occurrence-in-an-array-of-data-v2
Sheet: Sheet2

 | Probability | Severity |  |  | Risk Matrix (My attempt)
 | Probable | Critical |  |  |  | Catastrophic |  | Critical |  | Marginal |  | Negligible
Highest | Probable | Catastrophic |  |  | Frequent | A |  | A |  | A |  | B
 | Probable | Critical |  |  | Probable | A |  | A |  | B |  | C
 | Probable | Negligible |  |  | Occasional | A |  | B |  | C |  | D
 | Probable | Negligible |  |  | Remote | B |  | C |  | D |  | D
 | Probable | Critical |  |  | Improbable | C |  | D |  | D |  | D
Highest | Probable | Catastrophic |  |  | Incredible | D |  | D |  | D |  | D
 | Incredible | Critical
Highest | Incredible | Catastrophic |  |  | Risk Matrix (desired result)
Highest | Incredible | Critical |  |  |  | Catastrophic |  | Critical |  | Marginal |  | Negligible
 | Incredible | Negligible |  |  | Frequent | A |  | A |  | A |  | B
Highest | Improbable | Critical |  |  | Probable | A |  | A | 0 | B |  | C | 0
Highest | Improbable | Critical |  |  | Occasional | A |  | B |  | C |  | D
 | Improbable | Negligible |  |  | Remote | B |  | C |  | D |  | D
 | Improbable | Negligible |  |  | Improbable | C |  | D |  | D |  | D | 0
Highest | Improbable | Marginal |  |  | Incredible | D |  | D | 1 | D |  | D | 0
Highest | Improbable | Marginal
 |  |  |  |  | In the coloured tables, find the highest possible occurrence [NAME] being highest, Then Critical, then [NAME] then negligble.
 |  |  |  |  | Then count how may of the highest possible occurrence matching column B were found and input it into Risk classification table.
 |  |  |  |  | The Table with a purple border is the desired result
 | Severity | Probability
 | Catastrophic | Frequent |  |  | In my attempt (the Risk Matrix at the top highlighted with a red border) I have used a countifs formula which which matches two criteria and counts them all.
 | Critical | Probable |  |  | I want to, however, achieve only the highest possible severity ocurrence with highest possible meaning the greatest value number in Column D
 | Marginal | Occasional
 | Negligible | Remote
 |  | Improbable
 |  | Incredible
Spreadsheet: 851998d1702110024-need-help-converting-a-google-sheets-formula-to-excel-scheduling-test1
Sheet: Sheet1

 |  | 2024-01-15 00:00:00
 | Job # | Line # | Customer | QTY | H | W | Material | Sides to Print | [NAME] | Due_Date | Est. usage | PRESS | Notes
58.03203125 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | 4 Pass | 2024-01-15 00:00:00 | 0 | T1 | For production quote- [NAME]
0.21416015625 | 231235 | 1 | Fred | 1 | 45 | 58 | PAP-SO-0017 | 1 | 4 Pass | 2024-01-15 00:00:00 | 0 | T1 | 0
0.21953125 | 232445 | 2 | [NAME] | 4 | 30 | 30 | PAP-SO-1332 | 1 | 4 Pass | 2024-01-15 00:00:00 | 0 | T1 | 0
0.2895182291666667 | 243556 | 3 | Gregory | 25 | 33 | 20 | ART-4443 | 1 | 4 Pass | 2024-01-15 00:00:00 | 0 | T1 | 0
1.60625 | 243557 | 2 | Gregory | 300 | 24 | 36 | ART-3232 | 1 | 4 Pass | 2024-01-15 00:00:00 | 0 | T1 | 0
115.8640625 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | 8 Pass | 2024-01-15 00:00:00 | 0 | 0 | For production quote- [NAME]
105.3491477272727 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | 5-Pass | 2024-01-15 00:00:00 | 0 | HP | For production quote- [NAME]
0 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | 4 Pass | 2024-01-15 00:00:00 | 0 | INDIGO | For production quote- [NAME]
92.73125 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | Light Smoothing | 2024-01-15 00:00:00 | 0 | GS | For production quote- [NAME]
38.7546875 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | Light Smoothing | 2024-01-15 00:00:00 | 0 | HS | For production quote- [NAME]
105.3491477272727 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | 5-Pass | 2024-01-15 00:00:00 | 0 | VUTEK 3R's | For production quote- [NAME]
0 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | 4 Pass | 2024-01-15 00:00:00 | 0 | CUT ONLY | For production quote- [NAME]
Spreadsheet: 24be7a36-2758-4f2e-ade7-16085eaeebcd
Sheet: Year End

June 2014 |  |  |  |  |  | version 4/22/2014
Sun | Mon | Tue | Wed | Thu | Fri | Sat
 |  |  |  |  | Friday May 23
 |  |  |  |  | Inactivations/org change & new account codes due to ABS by noon
June 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  | 6:00 pm campus GL close for May
8 | 9 | 10 | 11 | 12 | 13 | 14
 |  |  |  |  | CUF manual transfer noon cutoff (>$500K)
15 | 16 | 17 | 18 | 19 | 20 | 21
 |  |  |  | 6:00 pm deadline to ensure payment in FY14 for PV, PA, NR, SSP forms and vendor invoices
22 | 23 | 24 | 25 | 26 | 27 | 28
 | 6:00 pm deadline to ensure payment in FY14 for approved employee travel/  reimbursement reports in Concur |  | 6:00 pm deadline to ensure posting in FY14 for approved procurement card expense reports | Fund 30/31/34 journals due for 1st preliminary June close
July 2014
Sun | Mon | Tue | Wed | Thu | Fri | Sat
June 29 | June 30 | July 1 | 2 | 3 | 4 | 5
 | Goods and services must be received by this date to be accounted for in FY14. FY15 auxiliary budgets due. |  |  | 1st preliminary campus June close Noon deadline to submit invoices, PA, NR, SSP forms to PSC | University holiday
6 | 7 | 8 | 9 | 10 | 11 | 12
 | No June journals. | 1st close reports available on demand by 8:00 am |  | PET deadline 6:00 pm | Fund 30/31/34 journals for 2nd close (by noon)
13 | 14 | 15 | 16 | 17 | 18 | 19
 | 2nd preliminary campus June close Concur & Mktplace accruals post | No June journals | 2nd close reports available on demand by 8:00 am | FINAL journal entry cutoff for campus depart- ments 6:00 pm | Depts start reporting errors >$10K to ABS
20 | 21 | 22 | 23 | 24 | 25 | 26
 | ABS/PBA final entry cutoff | No June or 998 journals  (period 998 opens) | 3rd (final) June close reports available on demand by 8:00 am. Moratoriums end.
27 | 28 | 29 | 30 | 31 | Aug 1 | Aug 2
 |  |  | Period 998 posts and closes @ noon |  | COFRS FY14 close
To check the status of the CIW (up/down & date of the data) go to: |  |  | https://www.cu.edu/irm/CUonly/dwhse/gl/gl_status.cgi
This calendar to be used along with the ABS Departmental Year End Memo and ABS daily email reminders.
Refer to the PSC 2014 Fiscal Year-End Infosheet for PSC procurement details.
Spreadsheet: 4c71e727-3787-48a6-85ba-b4675ed33ffc
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
6414 | 10491 | Co | Looijesteijn | NED | 140 | 00:14:33 | 00:00:00 | 00:30:43 | 00:00:00 | 00:24:00 | 1 | 01:09:17
6414 | 14373 | Sergey | [NAME] | RUS | 142 | 00:17:21 | 00:00:00 | 00:40:32 | 00:00:00 | 00:25:31 | 2 | 01:23:26
Spreadsheet: 117153d1312477555-calculate-commisson-with-referrals
Sheet: Jacqui

Jacqui Mims 1/17/2011
Date Closed | Property Address | Price | Commission % | Total Commission | Referral percentage | Referral Amount | [NAME] | Agent Commission | cap left | [NAME] | Agent Check | Office Commission
2011-07-25 00:00:00 | 123 Maple St | 200000 |  |  | 0.25
 |  | 200000 | 0.03 |  | 0 |  | 0.6
 |  | 200000 |  |  | 0.05 |  | 0.6
 |  | 200000 | 0.03 |  | 0 |  | 0.5
 |  | 200000 | 0.03 |  | 0 |  | 0.5
 |  | 200000 | 0.03 |  | 0 |  | 0.5
 |  | 200000 | 0.03 |  | 0.25 |  | 0.5
 |  | 200000 | 0.03 |  | 0 | 0 | 0.6
 |  | 200000 | 0.03 |  | 0 |  | 0.5
 |  | 100000 | 0.03 |  | 0 |  | 0.5
Totals
2011-07-05 00:00:00 | 4318 Blue Ridge Dr | Dorsey |  |  |  |  | 0 |  |  |  | Jacqui | 230000 | 6900 | 0.6
2011-09-01 00:00:00 | 1905 Mt. Lebanon Rd | Lord/Center |  |  |  |  | 0 |  |  |  | Jacqui | 72000 | 2160 | 0.5
8/15/111 | 110 Laurel View | Mensah/Biney |  |  |  |  | 0 |  |  |  | Jacqui | 55000 | 1650 | 0.5
2011-10-31 00:00:00 | 15 Suwannee Court | Goodman |  |  |  |  | 0 |  |  |  | Jacqui | 211175 | 6335.25 | 0.5
Spreadsheet: 132712d1323888089-automatic-leaderboard-2011-12-bowl-pool-summary
Sheet: Leaderboard

Leaderboard
Participants | Wins | Loses