tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 50736d1250192764-vlookup-for-two-columns-excel-lookup-twice
Sheet: Sheet1

PURCHASE ORDER LIST
PO # | LINE # | QTY | [NAME] | REC'D | CLOSED
1 | 1 | 8 | SOAP DISH | 2009-08-09 00:00:00 | 2009-08-10 00:00:00
1 | 2 | 9 | FOAM BRUSH | 2009-08-10 00:00:00 | 2009-08-11 00:00:00
1 | 3 | 8 | SOAP DISH | 2009-08-11 00:00:00 | 2009-08-12 00:00:00
1 | 4 | 7 | CHIPS | 2009-08-12 00:00:00 | 2009-08-13 00:00:00
1 | 5 | 6 | PART A | 2009-08-13 00:00:00 | 2009-08-14 00:00:00
1 | 6 | 7 | CHIPS | 2009-08-14 00:00:00 | 2009-08-15 00:00:00
2 | 1 | 8 | SOAP DISH | 2009-08-15 00:00:00 | 2009-08-16 00:00:00
2 | 2 | 4 | BEAN DIP | 2009-08-16 00:00:00 | 2009-08-17 00:00:00
2 | 3 | 5 | [NAME] | 2009-08-17 00:00:00 | 2009-08-18 00:00:00
2 | 4 | 6 | BON BONS | 2009-08-18 00:00:00 | 2009-08-19 00:00:00
2 | 5 | 7 | FUR BALL | 2009-08-19 00:00:00 | 2009-08-20 00:00:00
2 | 6 | 8 | BASEBALLS | 2009-08-20 00:00:00 | 2009-08-21 00:00:00
3 | 1 | 3 | BASKETBALLS | 2009-08-21 00:00:00 | 2009-08-22 00:00:00
3 | 2 | 5 | BARN NAILS | 2009-08-22 00:00:00 | 2009-08-23 00:00:00
3 | 3 | 7 | FURRY STUFF | 2009-08-23 00:00:00 | 2009-08-24 00:00:00
3 | 4 | 2 | SCRATCHY PARTS | 2009-08-24 00:00:00 | 2009-08-25 00:00:00
3 | 5 | 8 | [NAME] | 2009-08-25 00:00:00 | 2009-08-26 00:00:00
3 | 6 | 6 | PIN BALL | 2009-08-26 00:00:00 | 2009-08-27 00:00:00
3 | 7 | 9 | INK PENS | 2009-08-27 00:00:00 | 2009-08-28 00:00:00
4 | 1 | 4 | PAPER CLIPS | 2009-08-28 00:00:00 | 2009-08-29 00:00:00
4 | 2 | 6 | SODAS | 2009-08-29 00:00:00 | 2009-08-30 00:00:00
4 | 3 | 2 | COUCH | 2009-08-30 00:00:00 | 2009-08-31 00:00:00
4 | 4 | 8 | DESK | 2009-08-31 00:00:00 | 2009-09-01 00:00:00
4 | 5 | 9 | MARSHMELLOWS | 2009-09-01 00:00:00 | 2009-09-02 00:00:00
4 | 6 | 5 | PENCILS | 2009-09-02 00:00:00 | 2009-09-03 00:00:00
Spreadsheet: a984cf02-7510-4d84-b18e-4f9086984606
Sheet: TTM Recon Q4FY10

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations  - Trailing Twelve Months (TTM)
(in millions, except per share data)
 | Trailing Twelve Months Ended March 30, 2010
 | GAAP Results |  | Acquisition-related expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Loss on Lease Obligation (G&A) |  | Loss on licensed intellectual property commitment (COGS) |  | Loss on Strategic Investments |  | Restructuring Charges |  | Stock-Based Compensation |  | Income Tax Adjustments |  | Non-GAAP Results
Net revenue | 3654 |  | 0 |  | 505 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 4159
Cost of goods sold | 1866 |  | -10 |  | 0 |  | 0 |  | 3 |  | 0 |  | 0 |  | -2 |  | 0 |  | 1857
Gross profit | 1788 |  | 10 |  | 505 |  | 0 |  | -3 |  | 0 |  | 0 |  | 2 |  | 0 |  | 2302
Operating expenses:
Marketing and sales | 730 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -16 |  | 0 |  | 714
General and administrative | 320 |  | 0 |  | 0 |  | -14 |  | 0 |  | 0 |  | 0 |  | -33 |  | 0 |  | 273
Research and development | 1229 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -110 |  | 0 |  | 1119
Acquisition-related contingent consideration | 2 |  | -2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 53 |  | -53 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring charges | 140 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -140 |  | 0 |  | 0 |  | 0
Total operating expenses | 2474 |  | -55 |  | 0 |  | -14 |  | 0 |  | 0 |  | -140 |  | -159 |  | 0 |  | 2106
Operating income (loss) | -686 |  | 65 |  | 505 |  | 14 |  | -3 |  | 0 |  | 140 |  | 161 |  | 0 |  | 196
Loss on strategic investments | -26 |  | 0 |  | 0 |  | 0 |  | 0 |  | 26 |  | 0 |  | 0 |  | 0 |  | 0
Interest and other income, net | 6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 6
Income (loss) before provison for (benefit from) income taxes | -706 |  | 65 |  | 505 |  | 14 |  | -3 |  | 26 |  | 140 |  | 161 |  | 0 |  | 202
Provision for (benefit from) income taxes | -29 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 86 |  | 57
Net income (loss) | -677 |  | 65 |  | 505 |  | 14 |  | -3 |  | 26 |  | 140 |  | 161 |  | -86 |  | 145
Loss per share |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Earnings per share
Basic and diluted | -2.08 |  |  |  |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 0.44
Spreadsheet: 50121d1249510764-data-transfer-what-i-would-like-to-be-able-to-do-formletter
Sheet: Form

 |  |  |  |  |  |  |  |  |  |  | Record 2
 | Total No. Records: | 6 |  |  |  |  |  |  |  |  | [NAME]
 | Current Record: | 2 |  |  |  |  |  |  |  |  | [NAME]
 | First Record to Print: | 3 |  |  |  |  |  |  |  |  | Widmark Inc.
 | Last Record to Print: | 6 |  |  |  |  |  |  |  |  | 9800 W. Palm Blvd.
 |  |  |  |  |  |  |  |  |  |  | Los Angeles
 |  |  |  |  |  |  |  |  |  |  | CA
 |  |  |  |  |  |  |  |  |  |  | 93311
 |  |  |  |  |  |  |  | Elephants R Us
 |  |  |  |  |  |  |  | [NAME] 1211
 |  |  |  |  |  |  |  | San Diego, CA 92111
 | April 24, 2001
 | [NAME]Widmark Inc. 9800 W. Palm Blvd. Los Angeles CA 93311
 | Dear Jill,
 | Thanks for your interest in adopting an elephant. Demand currently exceeds supply, so each
 | request is being carefully evaluated. We will inform you of our decision in approximately six to
 | eight weeks.
 | Please be aware, [NAME], that caring for an elephant requires a significant investment in time.
 | Also, we've found that elephants usually don't adapt well in urban areas, and they positively
 | dislike living in high-rise apartments.
 | Sincerely,
 | [NAME]
 | Director
 | P.S. In anticipation of your new arrival, you might want to stock up on some peanuts and purchase
 | a large shovel.
Spreadsheet: 268513d1380660429-creating-a-total-sum-for-each-month-sample-problem-matthias1-oeldere-
Sheet: Sheet1

Date | text | Value 1 | Value 2 | Value 3 | month | year
2013-08-09 00:00:00 |  | 2.5 | 4.5 |  |  |  |  |  | Would Like a formula to display this:
2013-08-11 00:00:00 |  | 5.4 | 2.3 | 1.1 |  |  |  |  | (Totals for the months)
2013-08-20 00:00:00 |  | 2.3 |  |  |  |  |  |  |  | Value 1 | Value 2+3
2013-08-26 00:00:00 |  | 8.9 |  | 2.3 |  |  |  |  | 2013-08-13 00:00:00
2013-09-10 00:00:00 |  | 9.1 | 2.1 |  |  |  |  |  | 2013-09-13 00:00:00
2013-09-12 00:00:00 |  | 1 |  | 4.3 |  |  |  |  | 2013-10-13 00:00:00
2013-09-20 00:00:00 |  | 2.5 |  | 0.2
2013-09-25 00:00:00 |  | 3.7 |  | 2.1
2013-10-01 00:00:00 |  | 2.6
 |  |  |  |  |  |  |  |  | Waarden
 |  |  |  |  |  |  |  | Rijlabels | Som van Value 1 | Som van Value 2 | Som van Value 3
 |  |  |  |  |  |  |  | 2013 | 38.00000000000001 | 8.9 | 10
 |  |  |  |  |  |  |  | 8 | 19.1 | 6.8 | 3.4
 |  |  |  |  |  |  |  | 9 | 16.3 | 2.1 | 6.6
 |  |  |  |  |  |  |  | 10 | 2.6
 |  |  |  |  |  |  |  | Eindtotaal | 38.00000000000001 | 8.9 | 10
Spreadsheet: 45141d1243921486-if-statement-simplification-inventory
Sheet: eBay Fees

 |  |  | CODE | CATEGORY |  | LISTING FEE | CLOSING FEE | > $50.00 | > $1000.00 | > $3000.00
 |  |  | ELCTR | Consumer Electronics, Video Game Systems, Cameras & Photo |  | 0.35 | 0.08 | 0.045 | 0.01 | 0 |  |  |  | 12.85
 |  |  | COMP | Computers & Networking |  | 0.35 | 0.06 | 0.0375 | 0.01 | 0 |  |  |  | 10.1
 |  |  | CLOTH | Clothing, Shoes & Accessories |  | 0.35 | 0.12 | 0.09 | 0.02 | 0 |  |  |  | 21.35
 |  |  | MEDIA | Books, Music, DVDs & Movies, Video Games |  | 0.15 | 0.15 | 0.05 | 0.02 | 0 |  |  |  | 20.15
 |  |  | OTHER | All other categories |  | 0.35 | 0.12 | 0.06 | 0.02 | 0 |  |  |  | 18.35
 |  |  |  | PayPal |  | 0.3 | 0.029 | 0 | 0 | -0.004
 |  |  |  |  |  | 100
Spreadsheet: 873933d1720534294-3d-table-find-the-value-according-to-multiple-criteria-classeur2
Sheet: Feuil1

 |  |  | Fit-up | Fit-up | Fit-up | Fit-up | Fit-up | Fit-up | Solution mobilier | Solution mobilier | Solution mobilier | Solution mobilier | Solution mobilier | Solution mobilier | Solution mobilier | Solution mobilier | Sans travaux | Sans travaux | Sans travaux | Sans travaux | Sans travaux | Sans travaux | Sans travaux | Sans travaux
 |  |  | Tout | Initialisation | Conception | Travaux | Conception | Travaux | Tout | Initialisation | Conception | Conception | Travaux | Travaux | Travaux | Travaux | Tout | Initialisation | Conception | Conception | Travaux | Travaux | Travaux | Travaux
 |  |  | Taux | B175 | B143 | B143 | B141 | B141 | Taux | B175 | B123 | B143 | B123 | B143 | B141 | B141 | Taux | B175 | B123 | B143 | B123 | B143 | B141 | B141
Description | Fourchette | Superficie |  | 1 | 1 | 1 | 1 | 1 |  | 1 | 0.7 | 0.3 | 0.7 | 0.3 | 1 | 1 |  | 1 | 0.7 | 0.3 | 0.7 | 0.3 | 1 | 1
Aménagement | 0 À 899 | 0 |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0
Aménagement | 900 À 1499 | 900 |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0
Aménagement | 1500 À 2999 | 1500 |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0
Aménagement | 3000 et plus | 3000 |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0
Base-building | 0 À 899 | 0 |  |  | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0
Base-building | 900 À 1499 | 900 |  |  | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0
Base-building | 1500 À 2999 | 1500 |  |  | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0
Base-building | 3000 et plus | 3000 |  |  | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0
Critères : |  | Résultat : | ?
Base-building
1620
Fit-up
Initialisation
B175
Spreadsheet: 49082d1248353212-first-letter-of-the-last-name-dummy
Sheet: Sheet1

Team | If I input "Blue" the reference will be on blue
1st letter of Last name | "A" (sample only) | (since I input "A", and input "Blue" on the team , then the name will appear should be [NAME])
 | Referrence
 | Blue
 | name | last name belong to:
 | [NAME] | A-K, Pf-T
 | Isabel Lopez | L-O, Pe, U-Z
 | Red
 | name | last name belong to:
 | Grace Villar | A-K, Pf-T
 | [NAME] | L-O, Pe, U-Z
Spreadsheet: 684304d1593280003-formula-to-get-date-for-every-friday-for-the-year-date
Sheet: Sheet1

2020
2020-01-01 00:00:00
2020-01-03 00:00:00
2020-02-01 00:00:00
2020-03-01 00:00:00
Spreadsheet: 37777d1235780229-count-the-occurence-of-a-value-across-multiple-worksheets-example1-a
Sheet: 1705

RANK | NAME | WORK UNIT
1 | suspendisse condimentum | vivamus tortor
2 | felis condimentum | ut scelerisque
3 | vestibulum nisl | id velit
4 | vivamus ac | [NAME]
5 | euismod rutrum | [NAME]
6 | tortor vitae | [NAME]
7 | vestibulum nisl | in porta
8 | eget pretium | in purus
9 | [NAME] | [NAME]
Spreadsheet: 22047d1210434278-name-from-list-to-be-same-on-other-sheet-book1
Sheet: Sheet1

[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Francois Voltaire
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Mickel Spalding
[NAME]
Octavio Collazo
[NAME]
Porfirio Ortiz
[NAME]
Vital Beaunel
[NAME]
Spreadsheet: 834984d1688215881-excel-formula-for-merge-duplicate-data-and-sum-the-value-qmedical-supplies
Sheet: Stock In

Date | Stand No. | Item Name | Item Code No. | Quantity
 |  | Crepe Bandage 5cm | 131230010 | 15
 |  | Crepe Bandage 5cm | 131230010 | 21
 |  | Crepe Bandage 5cm | 131230010 | 22
 |  | Crepe Bandage 7.5cm | 131230012 | 1
 |  | [NAME] | 131230013 | 4
 |  | [NAME] 15cm | 131230014 | 34
 |  | Crepe Bandage 5cm | 131230010 | 5
 |  | Crepe Bandage 5cm | 131230010 | 5
 |  | Crepe Bandage 5cm | 131230010 | 12
 |  | Crepe Bandage 7.5cm | 131230012 | 6
 |  | [NAME] | 131230013 | 34
 |  | [NAME] 15cm | 131230014 | 13
Spreadsheet: 138619d1327768574-excel-2007-performing-calculations-in-cells-2012-income
Sheet: last feb

2011-02-28 00:00:00
0 |  | yes | Amount | Taxable Merch | Shipping Taxable | Sales Tax Payable | Non- taxable Merch | Shipping Non-Taxable | Income tax Income | MiscellaneousNon- Taxable | Owner Loan
Received From | Check No | Invoices Paid | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 219996d1363029867-formula-that-shows-date-the-quantiy-will-run-out-based-on-different-monthly-forecast-test
Sheet: Sheet1

 |  |  |  |  |  | Projected Monthly Forecast
Mat'l # | SAFETY STOCK | Stock | Date ORDER Entrty | Order  Qty. | When should I order | 2013-04-13 00:00:00 | 2013-05-01 00:00:00 | 2013-05-31 00:00:00 | 2013-06-30 00:00:00 | 2013-07-30 00:00:00 | 2013-08-29 00:00:00 | 2013-09-28 00:00:00 | 2013-10-28 00:00:00 | 2013-11-27 00:00:00 | 2013-12-27 00:00:00 | 2014-01-26 00:00:00 | 2014-02-25 00:00:00
Item 1 | 1290 | 0 | 2013-01-27 00:00:00 | 7700 |  | 3867 | 2320.5 | 2762.5 | 3315 | 3978 | 4176.900000000001 | 4696.25 | 4420 | 4143.75 | 3315 | 4143.75 | 3867.5
Item 2 | 250 | 0 | 2013-01-27 00:00:00 | 1400 |  | 682.5 | 409.5 | 487.5 | 585 | 702 | 737.1 | 828.75 | 780 | 731.25 | 585 | 731.25 | 682.5
Item 3 | 99 | 0 | 2013-01-27 00:00:00 | 700 |  | 297 | 178.5 | 212.5 | 255 | 306 | 321.3 | 361.25 | 340 | 318.75 | 255 | 318.75 | 297.5
Item 4 | 17 | 0 | 2013-01-27 00:00:00 | 300 |  | 52.5 | 31.5 | 37.5 | 45 | 54 | 56.7 | 63.75 | 60 | 56.25 | 45 | 56.25 | 52.5
Spreadsheet: 743361d1628441924-excel-formula-to-calculate-previous-depreciation-previous-dpn
Sheet: Sheet1

 | Kindly asking for the formula to calculate Previous depreciation (past 5 years) column K as shown in the desired solution
 | Asset Name | Acquision Date | Cost | Salvage Value | Useful Life | End of Useful | Years To Date | Depreciation Method | Current Deprecition | Previous Depreation
 | Land & Buildings | 2015-03-01 00:00:00 | 10000 | 1000 | 10 |  |  | SLN
 | Motor Vehicles | 2015-03-01 00:00:00 | 10000 | 1000 | 10 |  |  | SNY
 | Computers | 2015-03-01 00:00:00 | 10000 | 1000 | 10 |  |  | DB
 | Furniture & Fittings | 2015-03-01 00:00:00 | 10000 | 1000 | 10 |  |  | DDB
 | Books & Library | 2015-03-01 00:00:00 | 10000 | 1000 | 10 |  |  | VDB
 | Desired solution
 | Asset Name | Acquision Date | Cost | Salvage Value | Useful Life | End of Useful | Years To Date | Depreciation Method | Current Deprecition | Previous Depreation
 | Land & Buildings | 2015-03-01 00:00:00 | 10000 | 1000 | 10 |  |  | SLN |  | 4500
 | Motor Vehicles | 2015-03-01 00:00:00 | 10000 | 1000 | 10 |  |  | SNY |  | 6545.454545454546
 | Computers | 2015-03-01 00:00:00 | 10000 | 1000 | 10 |  |  | DB |  | 6844.25057223776
 | Furniture & Fittings | 2015-03-01 00:00:00 | 10000 | 1000 | 10 |  |  | DDB |  | 6723.200000000001
 | Books & Library | 2015-03-01 00:00:00 | 10000 | 1000 | 10 |  |  | VDB |  | 6723.2
Spreadsheet: 68529d1269037967-calculating-data-from-multiple-worksheets-722454-calculating-data-from-multiple-worksheets
Sheet: Recipes

Type of Cookie | Ingredients in [NAME]
 | [NAME] | Eggs | Baking Soda | Vanilla | Brown Sugar | White Sugar | Butter | [NAME] | Chocolate Chips | Cinnamon
Snicker-Doodles | 30 | 10 | 1 | 2 | 12 | 12 | 9 |  |  | 0.9
Chocolate Chip | 35 | 9 | 2 | 2 | 13 | 10 | 7 |  | 12
[NAME] | 28 | 7 | 1 | 1 | 10 | 13 | 4 | 6
Short Bread | 19 | 9 | 2 | 1 |  | 12 | 15
Sugar Cookies | 19 | 5 | 1 | 1 |  | 18 | 5
Spreadsheet: 853692d1703647968-excel-cross-tabulated-dynamic-arrays-in-one-cell-excel-cross-tabulated-dynamic-arrays-in-one-cell-1-
Sheet: TabDin

Data | Ano | Mês | Mês/Ano | [NAME] | [NAME] | [NAME] sem | [NAME] | [NAME] | Maria | João | Paulo | [NAME]
2023-12-04 00:00:00 |  |  |  |  |  |  | 2 |  | 2 | 6 | 1 | 2 |  |  |  |  |  | Just one formula in cell S9
2023-12-05 00:00:00 |  |  |  |  |  |  | 4 |  | 4 | 3 | 2 | 3
2023-12-06 00:00:00 |  |  |  |  |  |  | 5 |  | 1 | 1 | 3 | 6
2023-12-07 00:00:00 |  |  |  |  |  |  | 7 |  | 1 | 4 | 1 |  |  |  |  |  | 50 | [NAME] | [NAME] | Maria | João | Paulo | [NAME]
2023-12-09 00:00:00 |  |  |  |  |  |  | 1 |  |  |  | 3 |  |  |  |  |  |  | 0 | 1 | 0 | 5 | 2 | 2
2023-12-10 00:00:00 |  |  |  |  |  |  |  | 1 |  | 5 | 2 | 2 |  |  |  |  | Mon | 4 | 3 | 0 | 3 | 4 | 4
2023-12-11 00:00:00 |  |  |  |  |  |  | 4 | 3 |  | 3 | 4 | 4 |  |  |  |  | Tue | 4 | 5 | 3 | 6 | 5 | 1
2023-12-12 00:00:00 |  |  |  |  |  |  | 4 | 5 | 3 | 6 | 5 | 1 |  |  |  |  | Wed | 4 | 4 | 2 | 8 | 6 | 9
2023-12-13 00:00:00 |  |  |  |  |  |  | 4 | 4 | 2 | 8 | 6 | 9 |  |  |  |  | Thu | 7 | 13 | 1 | 1 | 7 | 0
2023-12-14 00:00:00 |  |  |  |  |  |  | 7 | 13 | 1 | 1 | 7 |  |  |  |  |  | Fri | 2 | 3 | 0 | 3 | 1 | 7
2023-12-15 00:00:00 |  |  |  |  |  |  | 2 | 3 |  | 3 | 1 | 7 |  |  |  |  | Sat | 2 | 1 | 1 | 0 | 8 | 0
2023-12-16 00:00:00 |  |  |  |  |  |  | 2 | 1 | 1 |  | 8
2023-12-18 00:00:00 |  |  |  |  |  |  | 4 | 1 | 3 |  | 2 | 3
2023-12-19 00:00:00 |  |  |  |  |  |  | 9 | 3 |  | 6 | 4 | 5
2023-12-20 00:00:00 |  |  |  |  |  |  | 4 | 2 | 1 |  | 6 | 2
2023-12-21 00:00:00 |  |  |  |  |  |  | 7 | 14 | 1 | 8
2023-12-26 00:00:00 |  |  |  |  |  |  |  | 1 |  | 9
Spreadsheet: 767873d1644685652-having-trouble-coming-up-with-combination-lookup-value-based-on-rank-result-2021-auto-update-test
Sheet: TOURNEY8

ANGLER | FISH CT. | WGTS. LBs | BIG BASS | PLACED
Spreadsheet: 69085d1269595641-find-weekly-average-based-on-dynamic-date-vlookup-weekly_averages_2
Sheet: Sheet1

 | 2010-03-24 00:00:00
 | Weekly Average | 4 Week Average
Registration
Events
Transactions
Conversion
I'm not sure I got right which columns you wanted calculated. I used these:
Events | Visits
Transactions | Transactions
Conversion | Ecommerce Conversion Rate
To adapt a formula to another column, just change the range right in front of the division symbol "/" in the formula
Spreadsheet: 107159d1304376264-help-with-excel-2010-grading-sheet
Sheet: Student List

High Plains School
Class List
 | Student_List | ID # | Average | Grade
 | Banks, [NAME] | 2692
 | [NAME], [NAME] | 2600
 | Biggerstaff, [NAME] | 2633
 | Biggs, [NAME] | 2638
 | [NAME], [NAME] | 2745
 | Brownlee, [NAME] | 2561
 | Eldred, Luz | 2668
 | Fields, Stephen | 2537
 | Forbes, [NAME] | 2667
 | [NAME], Willie | 2752
 | Jared, Lynn | 2788
 | [NAME], [NAME] | 2741
 | [NAME], [NAME] | 2759
 | [NAME], [NAME] | 2737
 | Singleton, [NAME] | 2350
 | Trout, [NAME] | 2711
 | Walton, [NAME] | 2589
 | Winstead, [NAME] | 2657
 | Wiseman, [NAME] | 2836
 | Yoder, [NAME] | 2644
Spreadsheet: 715580d1611769173-reference-data-table-and-return-closest-date-after-on-today-excel-forums-test-v2
Sheet: Summary

Seq | Area | PROJECTS | GMT member | SPOC | Week of review | OVERALL IMPACT LEVEL | TOTAL COMPLETED | TOTAL IN PROGRESS | TOTAL NOT STARTED | GO-LIVE date | GO-LIVE-today | GO-LIVE (<15 days, 15>30 days, +30 days)
1 | A | Project 1_week1 | Member 1 | SPOC 1 |  | H | 34 | 0 | 0 | [NAME] in here | #N/A | #N/A
2 | A | Project 1_week 2 | Member 2 | SPOC 2 |  | H | 34 | 0 | 0 | [NAME] in here | #N/A | #N/A
3 | A | Project 2_week1 | Member 3 | SPOC 3 |  | H | 0 | 0 | 0 | [NAME] in here | #N/A | #N/A
4 | A | Project 2_week 2 | Member 4 | SPOC 4 |  | 0 | 0 | 0 | 0 | [NAME] in here | #N/A | #N/A
5 | A | Project 3_week1 | Member 5 | SPOC 5 |  | 0 | 34 | 0 | 0 | [NAME] in here | #N/A | #N/A
6 | A | Project 3_week 2 | Member 6 | SPOC 6 |  | 0 | 34 | 0 | 0 | [NAME] in here | #N/A | #N/A
7 | A | Project 4_week 1 | Member 7 | SPOC 7 |  | 0 | 0 | 0 | 0 | [NAME] in here | #N/A | #N/A
8 | A | Project 4_week 2 | Member 8 | SPOC 8 |  | 0 | 0 | 0 | 0 | [NAME] in here | #N/A | #N/A
9 | A | Project 5_week 1 | Member 9 | SPOC 9 |  | 0 | 0 | 0 | 0 | [NAME] in here | #N/A | #N/A
10 | A | Project 5_week 2 | Member 10 | SPOC 10 |  | 0 | 0 | 0 | 0 | [NAME] in here | #N/A | #N/A
11 | A | Project 5_week 3 | Member 11 | SPOC 11 |  | 0 | 0 | 0 | 0 | [NAME] in here | #N/A | #N/A
12 | A | Project 6_week 1 | Member 12 | SPOC 12 |  | 0 | 0 | 0 | 0 | [NAME] in here | #N/A | #N/A
13 | A | Project 6_week 2 | Member 13 | SPOC 13 |  | 0 | 0 | 0 | 0 | [NAME] in here | #N/A | #N/A
14 | A | Project 6_week 3 | Member 14 | SPOC 14 |  | 0 | 0 | 0 | 0 | [NAME] in here | #N/A | #N/A
15 | A | Project 6_week 4 | Member 15 | SPOC 15 |  | 0 | 0 | 0 | 0 | [NAME] in here | #N/A | #N/A
Spreadsheet: 172909fb-bf08-42ea-9c8a-c275f0289967
Sheet: Ethnicity - Fall Other Asian

Return to Contents
Ethnicity - Other Asian
 |  |  |  | UH | UH COMMUNITY COLLEGES
 |  | UH | UH | WEST
 | TOTAL | MĀNOA | HILO | O‘AHU | SUBTOTAL | Hawaii | Honolulu | Kapi‘olani | Kaua‘i | Leeward | Maui | [NAME]
1977 | 372 | 174 | 12 | 0 | 186 | 11 | 74 | 41 | 1 | 40 | 9 | 10
1978 | 423 | 196 | 7 | 0 | 220 | 8 | 81 | 73 | 1 | 37 | 8 | 12
1979 | 425 | 208 | 7 | 0 | 210 | 9 | 81 | 64 | 1 | 34 | 6 | 15
1980 | 497 | 230 | 4 | 1 | 262 | 25 | 92 | 92 | 3 | 29 | 8 | 13
1981 | 617 | 271 | 5 | 1 | 340 | 21 | 151 | 117 | 1 | 29 | 10 | 11
1982 | 753 | 314 | 7 | 1 | 431 | 28 | 222 | 126 | 1 | 39 | 5 | 10
1983 | 820 | 374 | 8 | 4 | 434 | 19 | 220 | 129 | 1 | 44 | 15 | 6
1984 | 797 | 394 | 6 | 2 | 395 | 11 | 208 | 121 | 0 | 39 | 10 | 6
1985 | 803 | 392 | 6 | 2 | 403 | 15 | 208 | 116 | 0 | 43 | 11 | 10
1986 | 803 | 427 | 7 | 1 | 368 | 12 | 185 | 107 | 1 | 45 | 5 | 13
1987 | 778 | 434 | 5 | 1 | 338 | 10 | 169 | 101 | 0 | 42 | 5 | 11
1988 | 763 | 441 | 3 | 0 | 319 | 10 | 147 | 93 | 1 | 46 | 7 | 15
1989 | 764 | 464 | 5 | 3 | 292 | 7 | 126 | 94 | 2 | 53 | 4 | 6
1990 | 903 | 490 | 10 | 4 | 399 | 8 | 164 | 146 | 6 | 60 | 6 | 9
1991 | 933 | 497 | 6 | 4 | 426 | 8 | 169 | 156 | 7 | 63 | 10 | 13
1992 | 1031 | 484 | 11 | 4 | 532 | 14 | 212 | 218 | 8 | 51 | 10 | 19
1993 | 1081 | 515 | 15 | 3 | 548 | 16 | 223 | 213 | 6 | 67 | 3 | 20
1994 | 1118 | 507 | 15 | 3 | 593 | 15 | 226 | 246 | 6 | 73 | 11 | 16
1995 | 1144 | 499 | 12 | 9 | 624 | 12 | 231 | 279 | 7 | 67 | 12 | 16
Note: Data may not match [NAME] reports due to changes in enrollment counting methodology.
Spreadsheet: 269187d1381016835-help-with-an-special-weighted-average-formula-adjusted-ebitda-2
Sheet: Sheet1

EBITDA Entry |  | 100000
[NAME] |  | 200000
 | EBITDA Impact | Importance
Strategy 1 | 50000
Strategy 2 | 30000
Strategy 3 | 20000
Assesment Rank | Strategy 1 | Strategy 2 | Strategy 3 | Average |  | Ineffective | 1
Manager 1 | 3.5 | 2 | No influence |  |  | Baseline | 2
manager 2 | No influence | 4 | 2.5 |  |  | Effective | 3
Manager 3 | No influence | 3 | No influence |  |  | Highly Effective | 4
 |  |  |  |  |  | Exceptional | 5
Corrected Average considering EBITDA Impact Importance
Manager 1
Manager 2
manager 3
Spreadsheet: 116638d1311962037-multi-line-cell-spliting-sampleadlist
Sheet: Sheet1

Title | Name | Address | Postcode | [NAME] | [NAME] | [NAME] | [NAME]
Mr | [NAME] | Madeup House Imaginary Street Crazy Town Weird Area Silly County | BL4 8LA | [EMAIL] | 123456789 | 9876543210 | 5678901234
Mr | [NAME] | Madeup House Imaginary Street Crazy Town Weird Area Silly County | BL4 8LA | [EMAIL] | 123456789 | 9876543210 | 5678901234
Mr | [NAME] | Madeup House Imaginary Street Crazy Town Weird Area Silly County | BL4 8LA | [EMAIL] | 123456789 | 9876543210 | 5678901234
Spreadsheet: drew_fossum__8687__Fixed3_113000
Sheet: ENA_11

[NAME]
FUEL HEDGING BOOK
Enron North America_11
Prod. | Contract | Contract | Fixed |  | Fuel | Settled | futures_113000 | (Gains) and Losses
Date | Number | Name | Price |  | Dth | Price | Price | Total | Realized | Unrealized
 |  |  |  |  |  | El Paso Prmn |  | (4) | (4) | (4)
2001-01-01 00:00:00 |  | ENA | 3.74
2001-02-01 00:00:00 |  | ENA | 3.74
2001-03-01 00:00:00 |  | ENA | 3.74
2001-04-01 00:00:00 |  | ENA | 3.74
2001-05-01 00:00:00 |  | ENA | 3.74
2001-06-01 00:00:00 |  | ENA | 3.74
2001-07-01 00:00:00 |  | ENA | 3.74
2001-08-01 00:00:00 |  | ENA | 3.74
2001-09-01 00:00:00 |  | ENA | 3.74
2001-10-01 00:00:00 |  | ENA | 3.74
2001-11-01 00:00:00 |  | ENA | 3.74
2001-12-01 00:00:00 |  | ENA | 3.74
 |  |  |  |  |  | El Paso Prmn
2001-01-01 00:00:00 |  | Over-retention | 3.74
2001-02-01 00:00:00 |  | Over-retention | 3.74
2001-03-01 00:00:00 |  | Over-retention | 3.74
2001-04-01 00:00:00 |  | Over-retention | 3.74
2001-05-01 00:00:00 |  | Over-retention | 3.74
2001-06-01 00:00:00 |  | Over-retention | 3.74
2001-07-01 00:00:00 |  | Over-retention | 3.74
2001-08-01 00:00:00 |  | Over-retention | 3.74
2001-09-01 00:00:00 |  | Over-retention | 3.74
2001-10-01 00:00:00 |  | Over-retention | 3.74
2001-11-01 00:00:00 |  | Over-retention | 3.74
2001-12-01 00:00:00 |  | Over-retention | 3.74
(4)Gain and [NAME] are a measurement of the effectiveness of meeting the stated hedge objective.