tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 719248d1613575042-use-check-boxes-to-create-a-new-list-transfer-tora-v1-
Sheet: Sheet1

MR# | Patient Name | Location of Death | Date of Inactive | Inactive Type | Add to Audit List
15063 | [NAME], [NAME] | RC | 8/15/2020 | D | x
18945 | Beasley, Pam | RC | 10/19/2020 | DC
13526 | Scott, [NAME] | F | 10/20/2020 | D | x
17789 | Schrute, [NAME] | RC | 2020-09-11 00:00:00 | D | x
14854 | Malone, [NAME] | RC | 11/16/2020 | DC
14325 | Bratton, Creed | F | 11/20/2020 | D
15694 | Hudson, [NAME] | F | 11/20/2020 | D | x
15984 | Flenderson, Toby | F | 11/21/2020 | D
Spreadsheet: 59696d1260281017-max-and-min-summary-functions-in-excel-07-pivot-tables-pivotmax
Sheet: Sheet1

Day | Amount |  | Row Labels | [NAME] of Amount
Sunday | 1 |  | Monday | 99999
Monday | 99999 |  | Tuesday | 3
Tuesday | 3 |  | Wednesday
Wednesday |  |  | Thursday | 4
Thursday | 4 |  | Friday | 5
Friday | 5 |  | Saturday
Saturday |  |  | Sunday | 1
 |  |  | Grand Total | 99999
Spreadsheet: andy_zipper__184__DYNEGY-ICE VOL May17
Sheet: Enron Activity-ICE

ICE
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Enron North America - ICE |  |  |  |  |  | Enron Power Marketing - ICE |  |  |  |  |  | Enron Canada Corp - ICE
ICE GAS VOLUME: |  | ENRON PERCENTAGE: |  |  |  | ICE POWER VOLUME: |  |  | ENRON PERCENTAGE:
ICE CRUDE PRODUCTS VOLUME: |  | ENRON PERCENTAGE:
 |  |  | Data |  |  |  |  |  | Data |  |  | No Activity
Trader | Product | Qty Units | Transactions | Volume |  | Trader | Product | Qty Units | Transactions | Volume
[NAME], G | NG Fin BS, LD1 for GDM | MMBtus | 1 | 1510000 |  | Fischer, M | Firm-LD Peak | MWhs | 2 | 20800
 | NG Fin BS, LD1 for IF | MMBtus | 1 | 1510000 |  | [NAME], R | Firm-LD Peak | MWhs | 1 | 17600
Grand Total |  |  | 2 | 3020000 |  | Crandall, S | Firm-LD Peak | MWhs | 1 | 800
 |  |  |  |  |  | Dorland, C | Firm-LD Peak | MWhs | 7 | 76000
 |  |  |  |  |  | Carson, M | Firm-LD Peak | MWhs | 10 | 14400
 |  |  |  |  |  | Grand Total |  |  | 21 | 129600
Spreadsheet: 70384d1271163734-calculating-average-duration-employee-turnover
Sheet: Stats

 |  |  |  | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008
Average no. employed
No. of leavers during this time
Separation rate (%)
No. of employees > 1 years service
Stability index (%)
Spreadsheet: 705411d1606115623-make-a-regular-database-with-irregular-data-book1
Sheet: Sheet1

Task Name | StartDate | EndDate | Hours |  | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00
Task 1 | 2020-07-30 00:00:00 | 2020-08-31 00:00:00 | 13.8
Task 2 | 2020-07-30 00:00:00 | 2021-01-05 00:00:00 | 136.8
Task 3 | 2020-08-18 00:00:00 | 2020-08-24 00:00:00 | 72
Task 4 | 2020-08-25 00:00:00 | 2020-08-31 00:00:00 | 48
Task 5 | 2020-09-01 00:00:00 | 2020-10-15 00:00:00 | 326.6999984741211
Task 6 | 2020-10-16 00:00:00 | 2020-11-16 00:00:00 | 26.4
Task 7 | 2020-10-16 00:00:00 | 2020-12-13 00:00:00 | 147.6
Task 8 | 2020-10-16 00:00:00 | 2021-01-05 00:00:00 | 278.4
Task 9 | 2020-11-16 00:00:00 | 2020-11-29 00:00:00 | 60
Task 10 | 2020-12-14 00:00:00 | 2021-01-05 00:00:00 | 10.2
Grand Total |  |  | 1119.899998474121
Spreadsheet: 32339d1228441007-how-to-choose-the-highest-5-numbers-from-4-different-worksheets-4accendo
Sheet: Marvel #2

 | Name | Height (CM) | Intelligence | Strength | Speed | Agility | Fighting Skills
 | Colossus | 222 | 5 | 42 | 4 | 14 | 69
 | Cyclops | 183 | 4.5 | 30 | 6 | 16 | 80
 | Gambit | 178 | 4 | 27 | 6 | 18 | 70
 | Archangel | 180 | 4 | 28 | 5 | 15 | 77
 | [NAME] | 165 | 5 | 26 | 4 | 16 | 75
 | Psylocke | 178 | 3 | 29 | 6 | 18 | 85
 | Rogue | 170 | 4 | 40 | 11 | 23 | 72
 | Wolverine | 158 | 5 | 35 | 6 | 20 | 95
 | Bishop | 195 | 3.5 | 29 | 6.5 | 16 | 78
 | Sabretooth | 195 | 4 | 34 | 7 | 19 | 74
 | Sentinels | 190 | 2 | 37 | 12 | 20 | 81
 | [NAME] | 240 | 3 | 41 | 1 | 11 | 60
 | Mystique | 175 | 6 | 25 | 6 | 18 | 76
 | Toad | 170 | 2.5 | 35 | 9 | 20 | 82
 | Galactus | 862 | 10 | 50 | 20 | 30 | 55
 | The Incredible Hulk | 210 | 2 | 50 | 6 | 16 | 73
 | Abomination | 200 | 3 | 49 | 9 | 20 | 61
 | She Hulk | 198 | 4 | 48 | 3 | 17 | 72
 | Daredevil | 180 | 5 | 23 | 3 | 19 | 88
 | Agent X | 180 | 4 | 37 | 7 | 20 | 94
 | Captain Marvel | 185 | 3 | 35 | 20 | 21 | 62
 | Punisher | 180 | 4 | 30 | 3 | 17 | 92
 | Shadowcat | 165 | 6 | 26 | 6 | 29 | 86
 | Nightcrawler | 165 | 5 | 27 | 10 | 30 | 72
 | [NAME] | 175 | 4 | 41 | 6 | 15 | 73
 | Quicksilver | 180 | 3 | 35 | 14 | 21 | 71
 | Warbird | 177 | 4.5 | 36 | 14 | 27 | 75
 | War Machine | 180 | 4 | 30 | 5 | 20 | 85
 | Black Cat | 175 | 3 | 29 | 7 | 20 | 71
 | [NAME] | 200 | 4 | 35 | 6 | 19 | 93
Spreadsheet: 122612d1317029427-lookup-value-across-a-row-and-then-countif-book1_joesmalls-
Sheet: Sheet1

Employee | Department | Active
Employee 1 | Department 1
Employee 2 | Department 2 | Yes
Employee 3 | Department 3
Employee 4 | Department 4 | No
Employee 5 | Department 5
Employee 6 | Department 1 | Yes
Employee 7 | Department 2
Employee 8 | Department 3 | Yes
Employee 9 | Department 4
Employee 10 | Department 1
Employee 11 | Department 2 | Yes
Employee 12 | Department 3
Employee 13 | Department 4
Employee 14 | Department 5
Employee 15 | Department 1 | Yes
Employee 16 | Department 2
Employee 17 | Department 3
Employee 18 | Department 2
Employee 19 | Department 3
Employee 20 | Department 4
Spreadsheet: 723161d1615548045-count-duplicate-values-in-the-same-cell-and-in-a-range-example-1-2-
Sheet: Sheet1

 | INVOICE DATE | SITE | INVOICE AMOUNT | CHARGABLE | PLOT(S)
 | 2021-02-26 00:00:00 | Gipping [NAME] | 20 | YES | 123, 124, 125, 126
 | 2021-03-04 00:00:00 | Gipping [NAME] | 20 | YES | 108, 110
 | 2021-03-05 00:00:00 | Gipping [NAME] | 20 | NO | 108, 987
 | 2021-03-02 00:00:00 | Gipping [NAME] | 20 | NO | 108
 | 2021-02-03 00:00:00 | Gipping [NAME] | 20 | YES | 109
 | 2021-02-01 00:00:00 | Gipping [NAME] | 20 | NO | 123, 124
 | 2021-02-26 00:00:00 | Gipping [NAME] | 20 | YES | 82, 83
 | 2021-02-25 00:00:00 | Colne Meadows | 20 | NO | 2
 | 2021-02-24 00:00:00 | Colne Meadows | 20 | NO | 1
 | 2021-02-20 00:00:00 | Colne Meadows | 20 | NO | 1, 2
 | 2021-02-19 00:00:00 | Colne Meadows | 20 | NO | 3
 | 2021-02-18 00:00:00 | Colne Meadows | 20 | NO | 3, 4
 | 2021-02-17 00:00:00 | Colne Meadows | 20 | NO | 4
 | 2021-02-15 00:00:00 | Colne Meadows | 20 | NO | 4
 | 2021-02-16 00:00:00 | Gipping [NAME] | 20 | YES | 127
Spreadsheet: 878147d1725158794-sumifs-and-sumproduct-dynamic-range-sumif-and-sumproduct-multiple-columns-with-several-criteria
Sheet: Result

 |  |  |  | Expected Result Quanity |  |  | Expected Result Cost rate
 |  |  |  | Forecast Till Period |  |  | Forecast Till Period |  |  | Quantity |  |  | Cost |  |  | Revenue
 |  |  |  |  |  |  |  |  |  | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00
Task Order Number | Task Name | WBS Task Ref | Cost Centre | match column C with Lookup Sheet Column C & match column D with Lookup Sheet Column A , check the current period which is Sep-24 in Lookup range from column F to BC, sum all the values till period Sep-24 |  |  | match column C with Lookup Sheet Column C & match column D with Lookup Sheet Column A , check the current period which is Sep-24 in Lookup range from column F to BC, sum all the values till period Sep-24 |  |  |  |  |  | Current Month | Second Month | Third Month | Current Month | Second Month | Third Month
BM-70096062-100 | 40 VOI - Page 4 | BM-90096062-100 - IND - Void 4 | BM121217-UK-BSV-Srv Perth |  | 175 | 210
BM-70096062-200 | 40 VOI - Page 5 | BM-90096062-200 - IND - Void 5 | BM121217-UK-BSV-Srv Perth |  |  |  |  |  |  |  |  |  |  |  |  | Sumproduct of Aug-24 month and WBS task ref (quantity x revnue rate)
BM-70096062-300 | 40 VOI - Page 6 | BM-90096062-300 - IND - Void 6 | UK010117-UK-BSV-Srv Perth |  |  |  |  |  |  |  |  |  |  |  |  | Sumproduct of Aug-24 month and WBS task ref (quantity x revnue rate)
BM-70096062-MAN | 40 VOI - Management | BM-90096062-MAN - IND - Management | UK010117-UK-BSV-Srv Perth |  |  |  |  |  |  |  |  |  |  |  |  | Sumproduct of Aug-24 month and WBS task ref (quantity x revnue rate)
BM-70096062-CON | 40 VOI - Contingency | BM-90096062-CON - IND - Contingency | UK010117-UK-BSV-Srv Perth |  |  |  |  |  |  |  |  |  |  |  |  | Sumproduct of Aug-24 month and WBS task ref (quantity x revnue rate)
Spreadsheet: 688040d1595536218-function-to-search-3-exact-variables-from-3-columns-in-a-matrix-excelforum1
Sheet: Blad1

 |  |  | D
 |  |  | F
 |  |  | ?
 |  |  | ?
 |  |  |  |  |  |  | 1 | 1 | 1 | A
 |  |  |  |  |  |  | 1 | 1 | 2 | B
 |  |  |  |  |  |  | 1 | 2 | 1 | C
 |  |  |  |  |  |  | 1 | 2 | 2 | D
 |  |  |  |  |  |  | 2 | 1 | 1 | E
 |  |  |  |  |  |  | 2 | 1 | 2 | F
 |  |  |  |  |  |  | 2 | 2 | 1 | G
 |  |  |  |  |  |  | 2 | 2 | 2 | H
Spreadsheet: 139971d1328564454-how-to-have-other-formulas-be-based-on-the-rounded-value-and-not-inputed-value-example-2-6-12
Sheet: Sheet1

75.56 | 0.56
82.21 | 0.21
28.75 | 0.75
45.96 | 0.94
 | Total
DESIRED
A minus B = Column C |  |  | NOT
75.56 | 0.56 | 74.96
82.21 | 0.21 | 82.01
28.75 | 0.75 | 27.95
45.96 | 0.94 | 44.96
 | Total
Spreadsheet: 85634d1285705144-match-value-in-one-column-to-adjacent-value-use-vlookup-or-index-match-sample
Sheet: Sheet1

CLIENT | FIRM | CLIENT UNIQUE | THEIR FIRM
PETER ISAAC | BROWN UDELL POMERANTZ | [NAME] D | ?
PETER ISAAC | BROWN UDELL POMERANTZ | [NAME]
PETER ISAAC | BROWN UDELL POMERANTZ | [NAME]
PETER ISAAC | BROWN UDELL POMERANTZ | BACCASH    MICHAEL  F
PETER ISAAC | BROWN UDELL POMERANTZ | BARTELL    KERRY    T
PETER ISAAC | BROWN UDELL POMERANTZ | BERKSHIRE  ELLEN G
PETER ISAAC | BROWN UDELL POMERANTZ | …
PETER ISAAC | BROWN UDELL POMERANTZ
PETER ISAAC | BROWN UDELL POMERANTZ
PETER ISAAC | BROWN UDELL POMERANTZ
PETER ISAAC | BROWN UDELL POMERANTZ
PETER ISAAC | BROWN UDELL POMERANTZ
PETER ISAAC | BROWN UDELL POMERANTZ
A NOFAL    MOHAMMED | LANGHENRY GILLEN LUNDQ
A NOFAL    MOHAMMED | LANGHENRY GILLEN LUNDQ
ABDERHOLDENEDWARD C | ABDERHOLDEN LAW OFFICE
ABDERHOLDENEDWARD C | ABDERHOLDEN LAW OFFICE
… | …
Spreadsheet: 217176d1361998383-find-add-and-return-values-from-multiple-worksheets-time-spent-on-course
Sheet: Sheet3

Name | Course A | Time spent | Course B | Time spent | Course C | Time spent | Course D | Time spent | Course E | Time spent | Course F | Time spent
Adam | Science | 2 | Maths | 1 | English | 1
Eve | History | 2 | French | 1 | Maths | 2
[NAME] | Maths | 2 | Science | 1 | Geography | 3
Spreadsheet: 185523d1349746823-want-to-find-common-keywords-in-a-larger-column-using-another-column-cje1111_865820_08oct12_01
Sheet: Main Keyword List

List | Does this keyword exist on [NAME]?
chewable prenatal
chewables prenatal
[NAME]
dha prenatal
[NAME]
dha supplements
diet prenatal
elite prenatal
maternity vitamins
multivitamin pregnancy
multivitamin prenatal
multivitamins pregnancy
multivitamins prenatal
pill prenatal
pills prenatal
plus prenatal
preconception vitamins
[NAME]
pregnancy multivitamin
pregnancy multivitamins
pregnancy supplements
pregnancy vitamin
pregnancy vitamins
pregnant vitamin
pregnant vitamins
prenatal chewable
prenatal chewables
prenatal dha
prenatal diet
prenatal elite
prenatal multivitamin
prenatal multivitamins
prenatal pill
prenatal pills
prenatal plus
prenatal supplement
prenatal supplements
prenatal vitamens
prenatal vitamin
prenatal vitamina
prenatal vitamines
prenatal vitamins
prenatal vitamis
prenatal vitiams
prenatal vitimans
prenatal vitimins
prenatal vitmains
prenatals vitamins
supplement dha
supplement prenatal
supplements dha
supplements pregnancy
supplements prenatal
prenatal vitamins
Spreadsheet: benjamin_rogers__1044__Peaker Valuation 060500
Sheet: Spark-Spread

SPARK-SPREAD VALUE FROM TRADING
MONTHLY VALUES
 |  |  |  |  |  | Valuation Date
 | 2000-01-31 00:00:00 | 2000-02-29 00:00:00 | 2000-03-31 00:00:00 | 2000-04-30 00:00:00 | 2000-05-31 00:00:00 | 2000-06-01 00:00:00 | 2000-06-30 00:00:00 | 2000-07-31 00:00:00 | 2000-08-31 00:00:00 | 2000-09-30 00:00:00 | 2000-10-31 00:00:00 | 2000-11-30 00:00:00 | 2000-12-31 00:00:00 | 2001-01-31 00:00:00 | 2001-02-28 00:00:00 | 2001-03-31 00:00:00 | 2001-04-30 00:00:00 | 2001-05-31 00:00:00 | 2001-06-30 00:00:00 | 2001-07-31 00:00:00 | 2001-08-31 00:00:00 | 2001-09-30 00:00:00 | 2001-10-31 00:00:00 | 2001-11-30 00:00:00 | 2001-12-31 00:00:00 | 2002-01-31 00:00:00 | 2002-02-28 00:00:00 | 2002-03-31 00:00:00 | 2002-04-30 00:00:00 | 2002-05-31 00:00:00 | 2002-06-30 00:00:00 | 2002-07-31 00:00:00 | 2002-08-31 00:00:00 | 2002-09-30 00:00:00 | 2002-10-31 00:00:00 | 2002-11-30 00:00:00 | 2002-12-31 00:00:00
USD Libor Forward Curve (http://home.ect.enron.com/dept/irfx/curves/)
Revenue from Desk (Real) (Source: [NAME])
Brownsville
Caledonia
New Albany
Sub-Total: 1999 Peakers
[NAME]
Wheatland
[NAME]
Sub-Total: 2000 Peakers
Total Revenue, Real
Revenue from Desk (Nominal)
Brownsville
MW
Implied Capacity Price
Caledonia
MW
Implied Capacity Price
New Albany
MW
Implied Capacity Price
Sub-Total: 1999 Peakers
[NAME] | 0 | 0 | 0
MW |  |  |  |  | 0 | 0
Implied Capacity Price |  |  |  |  | 0 | 0
Wheatland | 0 | 0 | 0
MW
Implied Capacity Price
[NAME] | 0 | 0 | 0
MW
Implied Capacity Price
Sub-Total: 2000 Peakers
Total Revenue, Nominal
Total MW
ANNUAL VALUES
 |  |  |  | Jenny's Numbers
 | 2000 | 2001 | 2002 | 2000 | 2001 | 2002
Capacity Revenue from Desk (Real $)
Brownsville
Caledonia
New Albany
[NAME]
Wheatland
Wilton Center
Total Capacity Revenue (Real $)
Capacity Revenue from Desk (Nominal $)
Brownsville
Caledonia
New Albany
[NAME]
Wheatland
Wilton Center
Total Capacity Revenue (Nominal $)
Capacity Prices (Net Capacity, $/kW-mo) | 2000 | 2001 | 2002
Brownsville
Caledonia
New Albany
[NAME]
Wheatland
Wilton Center
Average Capacity Price (Nominal $)
Spreadsheet: b876e504-718b-4b1b-9d5e-76f385871e44
Sheet: QTD Recon Q2FY11

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations
(in millions, except per share data)
 | Three Months Ended September 30, 2010
 | GAAP Results |  | Acquisition-related expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Loss on licensed intellectual property commitment (COGS) |  | Gain on strategic investments |  | Restructuring and other |  | Stock-based compensation |  | Income tax adjustments |  | Non-GAAP Results
Net revenue | 631 |  | 0 |  | 253 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 884
Cost of revenue | 363 |  | -3 |  | 0 |  | 1 |  | 0 |  | 0 |  | 0 |  | 0 |  | 361
Gross profit | 268 |  | 3 |  | 253 |  | -1 |  | 0 |  | 0 |  | 0 |  | 0 |  | 523
Operating expenses:
Marketing and sales | 173 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -6 |  | 0 |  | 167
General and administrative | 77 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -10 |  | 0 |  | 67
Research and development | 277 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -27 |  | 0 |  | 250
Acquisition-related contingent consideration | -28 |  | 28 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 15 |  | -15 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring and other | 6 |  | 0 |  | 0 |  | 0 |  | 0 |  | -6 |  | 0 |  | 0 |  | 0
Total operating expenses | 520 |  | 13 |  | 0 |  | 0 |  | 0 |  | -6 |  | -43 |  | 0 |  | 484
Operating income (loss) | -252 |  | -10 |  | 253 |  | -1 |  | 0 |  | 6 |  | 43 |  | 0 |  | 39
Gain on strategic investments | 28 |  | 0 |  | 0 |  | 0 |  | -28 |  | 0 |  | 0 |  | 0 |  | 0
Interest and other income (expense), net | 6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 6
Income (loss) before provision for (benefit from) income taxes | -218 |  | -10 |  | 253 |  | -1 |  | -28 |  | 6 |  | 43 |  | 0 |  | 45
Provision for (benefit from) income taxes | -17 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 |  | 13
Net income (loss) | -201 |  | -10 |  | 253 |  | -1 |  | -28 |  | 6 |  | 43 |  | -30 |  | 32
Loss per share |  |  |  |  |  |  |  |  |  |  |  |  | Earnings per share
Basic and diluted | -0.61 |  |  |  |  |  |  |  |  |  |  |  | Basic |  |  |  | 0.1
 |  |  |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 0.1
Number of shares used in computation |  |  |  |  |  |  |  |  |  |  |  |  | Number of shares used in computation
Basic and diluted | 329 |  |  |  |  |  |  |  |  |  |  |  | Basic |  |  |  | 329
 |  |  |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 333
Spreadsheet: 0dd70c0b-0342-4e9d-a413-a307dfc46740
Sheet: GPA

 | GPA Calculator
 | Course | Credits | Value | Grade | Points |  |  | Instructions |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | 1.  Under "Course" input the course name. |  |  |  |  |  |  |  |  | Main Menu
 |  |  |  |  |  |  |  | Example:  HIS 104 |  |  |  |  |  |  |  |  | Return To AA
 |  |  |  |  |  |  |  | Note:  If a course has been repeated, only record the course with the highest |  |  |  |  |  |  |  |  | Return To AS
 |  |  |  |  |  |  |  | grade.
 |  |  |  |  |  |  |  | 2.  Under "Credits" enter a credit value or select one from the dropdown box.
 |  |  |  |  |  |  |  | Example:  HIS 104 is 3 credits.
 |  |  |  |  |  |  |  | Example: |  | Course | Credits | Grade
 |  |  |  |  |  |  |  |  |  | HIS 104 | 3 | A
 |  |  |  |  |  |  |  | 3.  Under "Grade" select a grade from the dropdown box.
 |  |  |  |  |  |  |  | Note:  Transfer & Developmental courses do not count towards GPA.
 |  |  |  |  |  |  |  | 4.  GPA will be automatically calculated.
 |  |  |  |  |  |  |  | 5.  If you would like to see what the GPA would be if repeated a course is repeated,
 |  |  |  |  |  |  |  | simply change the grade to see how it affects the GPA.
 |  |  |  |  |  |  |  | Example:  You got a D in HIS 104 but would like to retake it.  Change your grade
 |  |  |  |  |  |  |  | in HIS 104 to something else to see how much it would affect your GPA.
 |  |  |  |  |  |  |  | GPA Calculation |  |  |  | Common Courses That Do Not Affect GPA
 |  |  |  |  |  |  |  | Total Grade Points: |  |  |  | ENC Courses |  |  | MAT 55
 |  |  |  |  |  |  |  | Total Credits: |  |  |  | ESL Courses |  |  | MAT 65
 |  |  |  |  |  |  |  |  |  |  |  | RDG Courses |  |  | MA 108R
 |  |  |  |  |  |  |  | GPA: |  |  |  | [NAME]
Spreadsheet: 118687d1313892558-find-the-exact-p-n-in-a-multi-p-n-range-of-cells-messy3
Sheet: Sheet2

helper 1 | helper 2
0 | a
0 | a,
0 | , a
0 | , a,
0
0
0
1
1
0
0
0
1
0
0
1
0
0
0
Spreadsheet: 743043d1628178268-calculate-tiered-pricing-based-on-2-points-calculate-tiered-pricing-based-on-2-points
Sheet: Sheet1

[NAME] | Price | price/unit |  | Limit | [NAME] | Price | price/unit
20000 |  |  |  | Lower | 20000 |  | 0.75
50000 |  |  |  | Upper | 10000000 |  | 0.09
100000
200000 |  |  |  | Cell B4 = Total Price for 50,000 [NAME] using Algebra
400000 |  |  |  | (20,000-50,000)/(10,000,000-50,000)=(15000-x)/(900000-x)
600000 |  |  |  | (20,000-50,000)*(900000-x)=(10,000,000-50,000)*(15000-x)
800000 |  |  |  | (20,000-50,000)*900000-(20,000-50,000)*x=(10,000,000-50,000)*15000-(10,000,000-50,000)*x
1000000 |  |  |  | (10,000,000-50,000)*x-(20,000-50,000)*x=(10,000,000-50,000)*15000-(20,000-50,000)*900000
1500000 |  |  |  | x*[(10,000,000-50,000)-(20,000-50,000)]=(10,000,000-50,000)*15000-(20,000-50,000)*900000
2000000 |  |  |  | x=[(10,000,000-50,000)*15000-(20,000-50,000)*900000] / [(10,000,000-50,000)-(20,000-50,000)]
2500000
3000000
3500000 |  |  |  | https://www.excelforum.com/excel-formulas-and-functions/1356173-calculate-tiered-pricing-based-on-2-points.html
4000000
4500000
5000000
6000000
7000000
8000000
9000000
10000000
15000000
20000000
25000000
30000000
35000000
40000000
45000000
50000000
55000000
60000000
65000000
70000000
75000000
80000000
85000000
90000000
95000000
100000000
105000000
110000000
115000000
120000000
Spreadsheet: 598920d1542794162-combining-rows-and-data-example1
Sheet: Sheet2

[NAME] | Vendor & GL Text | PO No | EXT.SERVICES | Total Cost | # Materials Used | Actual PO Cost | Maintenance Cost
Spreadsheet: 866119d1713065969-in-spec-out-of-spec-formula-blank-grade-form
Sheet: Site Trending

 |  |  | Target |  |  | 0.85
 |  | Total Products | Good | Satisfactory | Unacceptable | Good (%) | Satisfactory (%) | Unacceptable (%) | Target
 | 2021 (Total)
 | Jan
 | Feb
 | Mar
 | Apr
 | May
 | Jun
 | Jul
 | Aug
 | Sep
 | Oct
 | Nov
 | Dec
 |  |  | Total
 |  | Total Products | Good | Satisfactory | Unacceptable | Good (%) | Satisfactory (%) | Unacceptable (%) | Target
 | Target | 100 | 85 | 15 |  | 0.85 | 0.15 | 0
 | 2022 (Total)
 | Jan
 | Feb
 | Mar
 | Apr
 | May
 | Jun
 | Jul
 | Aug
 | Sep
 | Oct
 | Nov
 | Dec
 |  | Total Products | Good | Satisfactory | Unacceptable | Good (%) | Satisfactory (%) | Unacceptable (%) | Target
 | Target | 100 |  | 85 | 15 | 0 | 0.85 | 0.15
 | 2023 (Total)
1 | Jan
2 | Feb
3 | Mar
4 | Apr
5 | May
6 | Jun
7 | Jul
8 | Aug
9 | Sep
10 | Oct
11 | Nov
12 | Dec
 |  | Length | Diameter | Density | [NAME] | Dust | Coating | Cross Contamination | Appearance | Odour
2023-01-01 00:00:00 | Good
2023-01-01 00:00:00 | Satisfactory
2023-01-01 00:00:00 | Unacceptable
 | Total
2023-02-01 00:00:00 | Good
2023-02-01 00:00:00 | Satisfactory
2023-02-01 00:00:00 | Unacceptable
 | Total
2023-01-01 00:00:00 | Good
2023-01-01 00:00:00 | Satisfactory
2023-01-01 00:00:00 | Unacceptable
2023-02-01 00:00:00 | Good
2023-02-01 00:00:00 | Satisfactory
2023-02-01 00:00:00 | Unacceptable
Spreadsheet: 152b9aa3-75ae-4220-92df-d28c590d8287
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
MAC | Test | MAC | C5b-9 Complement Membrane Attach Complex (MAC) | MAC (C5b9), Immunop ST |  | Varies: Var |  |  |  | Varies |  |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | This request will be processed as a consultation. An interpretation will be provided. |  |  |  | 1 | 88342 |  |  |  |  | Rochester
MAC | Result | MAC | MAC (C5b9), Immunop ST | MAC (C5b9), Immunop ST | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10435-6 | C5B-9 Ag:ACnc:Pt:Tiss:[NAME]:Immune stain
Spreadsheet: 767737d1644598218-return-the-results-of-a-formula-after-looking-up-a-string-of-text-excel-target-price-test
Sheet: SR Consensus Price

Ticker | 1.25.21 |  | 2.17.20 | [NAME]. Target Price
AAPL | 129.53 |  | AAPL | 146.32 |  | Look up cell D3 in Column A
ABBV | 114.38 |  | ABBV | 115.5 |  | Return the DIFFERENCE of E3 (this week's target price) and the target price listed next to the stock symbol from column a
ABUS | 7 |  | ABUS | 7
ACB | 9.7 |  | ACB | 10.37
AMZN | 3737.88 |  | ALEC | 34.83 |  | Example:  Look up AMZN (D8) in Column A
[NAME] | 10.17 |  | AMZN | 4016.71 |  | Return the following:   E8-B7
ARE | 184.33 |  | [NAME] | 10.17 |  | 4016.71 | 3737.88
BA | 235.47 |  | ARE | 184.33
BGS | 30.25 |  | AVGO | 454.5 |  | It will look like this: |  | AMZN | 278.83
BIP | 53.75 |  | BA | 230.5
BIPC | 76 |  | BFT | -
BMY | 72.82 |  | BIP | 54.75
BP | 26 |  | BMY | 73.09
C | 75.93 |  | BP | 26.13
CAG | 38 |  | C | 75.83
CCI | 181.67 |  | CAG | 38
CDTAF | - |  | CCI | 180.58
CGC | 23.46 |  | CDTAF | -
Spreadsheet: 828855d1683775158-if-b6-no-input-complete-reason-in-b7-then-if-c7-has-text-make-b7-blank-proposed-new-checklist-for-disclosures-under-the-utaa
Sheet: Sheet3

CLIENT CARE | ACM's |  | Data and Names are being populated from the Operations Manager [NAME], will therefore automatically update new Team Members
Pauline
 | Aileen
[NAME] | Alana
Annalise | [NAME]
[NAME] | Alistair
Hiroko | [NAME]
Jan | Anna
[NAME] | Ashneeta
[NAME] | Babette
[NAME] | [NAME]
[NAME] | Daniella
Leaidy | [NAME]
Penelope | Elle
[NAME] | Evania
Rupal | Hacel
[NAME] | [NAME]
Siena | [NAME]
Spare | Jerahmeel
Sree | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Neetu
 | New Business
 | Nicole
 | Omair
 | Raveena
 | [NAME]
 | Shuling
 | Spare
 | [NAME]
 | Sue
 | Sumeet
 | Terence
 | Terina
 | [NAME]