tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 49118d1248372021-excel-calendar-personal-calendar_1b
Sheet: Calendar

 |  |  | Personal |  |  |  |  |  |  |  |  |  |  |  | Start Month: | 1
 |  |  | Calendar |  |  |  |  |  |  |  |  |  |  |  | Start Year: | 2008
 | 2
 | 31 |  | 2008-01-01 00:00:00
 |  |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
3 |  |  | 2007-12-31 00:00:00 | Unassigned | 2008-01-01 00:00:00 | Event 1 Event 2 Event 3 | 2008-01-02 00:00:00 | 0 | 2008-01-03 00:00:00 | 0 | 2008-01-04 00:00:00 | 0 | 2008-01-05 00:00:00 | 0 | 2008-01-06 00:00:00 | 0
4 |  |  | 39447 |  | 39448 |  | 39449 |  | 39450 |  | 39451 |  | 39452 |  | 39453
3 |  |  | 2008-01-07 00:00:00 | 0 | 2008-01-08 00:00:00 | 0 | 2008-01-09 00:00:00 | 0 | 2008-01-10 00:00:00 | 0 | 2008-01-11 00:00:00 | 0 | 2008-01-12 00:00:00 | 0 | 2008-01-13 00:00:00 | 0
4 |  |  | 39454 |  | 39455 |  | 39456 |  | 39457 |  | 39458 |  | 39459 |  | 39460
3 |  |  | 2008-01-14 00:00:00 | 0 | 2008-01-15 00:00:00 | 0 | 2008-01-16 00:00:00 | 0 | 2008-01-17 00:00:00 | 0 | 2008-01-18 00:00:00 | 0 | 2008-01-19 00:00:00 | 0 | 2008-01-20 00:00:00 | 0
4 |  |  | 39461 |  | 39462 |  | 39463 |  | 39464 |  | 39465 |  | 39466 |  | 39467
3 |  |  | 2008-01-21 00:00:00 | 0 | 2008-01-22 00:00:00 | 0 | 2008-01-23 00:00:00 | 0 | 2008-01-24 00:00:00 | 0 | 2008-01-25 00:00:00 | 0 | 2008-01-26 00:00:00 | 0 | 2008-01-27 00:00:00 | 0
4 |  |  | 39468 |  | 39469 |  | 39470 |  | 39471 |  | 39472 |  | 39473 |  | 39474
3 |  |  | 2008-01-28 00:00:00 | 0 | 2008-01-29 00:00:00 | 0 | 2008-01-30 00:00:00 | 0 | 2008-01-31 00:00:00 | 0 | 2008-02-01 00:00:00 | 0 | 2008-02-02 00:00:00 | 0 | 2008-02-03 00:00:00 | 0
4 |  |  | 39475 |  | 39476 |  | 39477 |  | 39478 |  | 39479 |  | 39480 |  | 39481
3 |  |  | 2008-02-04 00:00:00 | 0 | 2008-02-05 00:00:00 | 0 | 2008-02-06 00:00:00 | 0 | 2008-02-07 00:00:00 | 0 | 2008-02-08 00:00:00 | 0 | 2008-02-09 00:00:00 | 0 | 2008-02-10 00:00:00 | 0
4 |  |  | 39482 |  | 39483 |  | 39484 |  | 39485 |  | 39486 |  | 39487 |  | 39488
3 | #N/A |  | 2008-02-11 00:00:00 | 0 | 2008-02-12 00:00:00 | 0 | 2008-02-13 00:00:00 | 0 | 2008-02-14 00:00:00 | 0 | 2008-02-15 00:00:00 | 0 | 2008-02-16 00:00:00 | 0 | 2008-02-17 00:00:00 | 0
4 | #N/A |  | 39489 |  | 39490 |  | 39491 |  | 39492 |  | 39493 |  | 39494 |  | 39495
Spreadsheet: 712924d1610477265-dynamic-calendar-fixing-vlookup-error-for-cells-without-information-pulling-dates-gk
Sheet: Predictor for future

Item | extra information | Last time Purchased | Date for next purchase | Cycle (days) | Estimated time | 2019-01-01 00:00:00 |  | 2019-02-01 00:00:00 |  | 2019-03-01 00:00:00 |  | 2019-04-01 00:00:00 |  | 2019-05-01 00:00:00 |  | 2019-06-01 00:00:00 |  | 2019-07-01 00:00:00 |  | 2019-08-01 00:00:00 |  | 2019-09-01 00:00:00 |  | 2019-10-01 00:00:00 |  | 2019-11-01 00:00:00 |  | 2019-12-01 00:00:00 |  | 2020-01-01 00:00:00 |  | 2020-02-01 00:00:00 |  | 2020-03-01 00:00:00 |  | 2020-04-01 00:00:00 |  | 2020-05-01 00:00:00 |  | 2020-06-01 00:00:00 |  | 2020-07-01 00:00:00 |  | 2020-08-01 00:00:00 |  | 2020-09-01 00:00:00 |  | 2020-10-01 00:00:00 |  | 2020-11-01 00:00:00 |  | 2020-12-01 00:00:00 |  | 2021-01-01 00:00:00 |  | 2021-02-01 00:00:00 |  | 2021-03-01 00:00:00 |  | 2021-04-01 00:00:00 |  | 2021-05-01 00:00:00 |  | 2021-06-01 00:00:00 |  | 2021-07-01 00:00:00 |  | 2021-08-01 00:00:00 |  | 2021-09-01 00:00:00 |  | 2021-10-01 00:00:00 |  | 2021-11-01 00:00:00 |  | 2021-12-01 00:00:00
 |  |  |  |  |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec
 |  |  |  |  |  |  | Hours
 |  |  |  |  |  |  | Items used
Spreadsheet: 6d089afe-b19e-4cf6-9a43-d28fe95a99fc
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-02-25 09:14:39.440000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.412 | 102.287 | 102.162 | 101.787
4.5 | 101.499 | 101.374 | 101.249 | 100.874 |  | Note: | Refer To Price [NAME]
4.375 | 100.534 | 100.409 | 100.284 | 99.909 |  |  | For all Price Adjs
4.25 | 99.923 | 99.798 | 99.673 | 99.048
4.125 | 99.104 | 98.979 | 98.854 | 98.229
4 | 98.089 | 97.964 | 97.839 | 97.214
3.875 | 97.04 | 96.915 | 96.79 | 96.165
3.75 | 96.165 | 96.04 | 95.915 | 95.29
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.875 | 102.75 | 102.625 | 102.25
3.875 | 102.579 | 102.454 | 102.329 | 101.954
3.75 | 102.419 | 102.294 | 102.169 | 101.794
3.625 | 102.018 | 101.893 | 101.768 | 101.393
3.5 | 101.442 | 101.317 | 101.192 | 100.567
3.375 | 100.692 | 100.567 | 100.442 | 99.817
3.25 | 99.903 | 99.778 | 99.653 | 99.028 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-03-11 09:14:39.440000
30 DAY | 2014-03-26 09:14:39.440000
45 DAY | 2014-04-10 09:14:39.440000
60 DAY | 2014-04-25 09:14:39.440000
90 DAY | 2014-05-25 09:14:39.440000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 0164c620-a570-46c6-8cb4-31266191bb3b
Sheet: Sheet1

Spend over £25,000 - Publication template | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  | Payment
Department family | Entity | Date | Expense type | Expense area | Supplier | Transaction number | Amount
DCMS | NMSI | 2011-01-06 00:00:00 | Professional Fees | ScM Major projects | ElectroSonic Ltd | 134184 | 34973.36
DCMS | NMSI | 2011-01-06 00:00:00 | Professional Fees | National MPG | Eduserv Technologies Ltd | 134315 | 39608
DCMS | NMSI | 2011-01-06 00:00:00 | Software Packages | National Information Communication Technicial | Ultima Business Solutions Limited | 134340 | 30008
DCMS | NMSI | 2011-01-06 00:00:00 | Design Costs | National MPG | Chocolate Grinder Limited | 134456 | 29760
DCMS | NMSI | 2011-01-20 00:00:00 | Consultancy | Health & Safety Consultancy | Natural History Museum | 134491 | 27562.5
DCMS | NMSI | 2011-01-20 00:00:00 | Consultancy | Maintenance | Honeywell Controls Ltd | 134542 | 126632.55
DCMS | NMSI | 2011-01-20 00:00:00 | Maintenance | National Estates | Honeywell Controls Ltd | 134555 | 56494.6
DCMS | NMSI | 2011-01-20 00:00:00 | Build Construction | Wroughton Major projects | MB Construction Services Ltd | 134602 | 44731.25
DCMS | NMSI | 2011-01-20 00:00:00 | General Marketing | ScM Major projects | Total Media Limited | 134737 | 70525.61
DCMS | NMSI | 2011-01-20 00:00:00 | Build Construction | National Media Museum Estates | Watershed (Roofing) Limited | 134822 | 36786.56
DCMS | NMSI | 2011-01-20 00:00:00 | Build Construction | National MPG | MB Construction Services Ltd | 134887 | 91821.98
DCMS | NMSI | 2011-01-20 00:00:00 | Build Construction | ScM Major projects | Parkeray Ltd | 134973 | 25511
DCMS | NMSI | 2011-01-20 00:00:00 | Build Construction | ScM Major projects | Fairhurst Ward Abbotts Ltd | 135108 | 35810.8
DCMS | NMSI | 2010-12-09 00:00:00 | Contract Cleaning | SCM Vistor Experience | Servest (Sherwood) Ltd | 94058 | 90786.68
DCMS | NMSI | 2010-12-09 00:00:00 | Contract Cleaning | SCM Vistor Experience | Servest (Sherwood) Ltd | 94330 | 90786.68
DCMS | NMSI | 2010-12-09 00:00:00 | Contract Cleaning | SCM Vistor Experience | Servest (Sherwood) Ltd | 94331 | 90786.68
Spreadsheet: phillip_m_love__30138__200007_OA
Sheet: BUG_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  BUG
 |  |  | Total |  | Reclasses |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  | 0 | 0 | 0 | 0
2 |  | Liquidations |  |  |  |  | 0 | 0 | 0 | 0
3 |  | Interdesk |  |  |  |  | 0 | 0 | 0 | 0
4 |  | Option Premiums |  |  |  |  | 0 | 0 | 0 | 0
5 |  | Dmd Reimbursements |  |  |  |  | 0 | 0 | 0 | 0
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  | 0 | 0 | 0 | 0
7 |  | Liquidations |  |  |  |  | 0 | 0 | 0 | 0
8 |  | Interdesk |  |  |  |  | 0 | 0 | 0 | 0
9 |  | Option Premiums |  |  |  |  | 0 | 0 | 0 | 0
10 |  | [NAME] |  |  |  |  | 0 | 0 | 0 | 0
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales |  |  |  |  | 0 | 0 | 0 | 0
12 |  | Purchases |  |  |  |  | 0 | 0 | 0 | 0
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind |  |  |  |  | 0 | 0 | 0 | 0
14 |  | Cash Out |  |  |  |  | 0 | 0 | 0 | 0
15 |  | Cash In |  |  |  |  | 0 | 0 | 0 | 0
16 |  | Synthetic Storage |  |  |  |  | 0 | 0 | 0 | 0
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg) |  |  |  |  | 0 | 0 | 0 | 0
18 |  | W/D (Purchase from Stg) |  |  |  |  | 0 | 0 | 0 | 0
19 |  | Inventory Profit |  |  |  |  | 0 | 0 | 0 | 0
 |  | Total W/D
 | Total Storage:
20 | Linepack: |  |  |  |  |  | 0 | 0 | 0 | 0
21 | Shrinkage: |  |  |  |  |  | 0 | 0 | 0 | 0
22 | UA4: |  |  |  |  |  | 0 | 0 | 0 | 0
23 | Fuel: |  |  |  |  |  | 0 | 0 | 0 | 0
 | Transport Expense:
24 |  | Commodity |  |  |  |  | 0 | 0 | 0 | 0
25 |  | Demand |  |  |  |  | 0 | 0 | 0 | 0
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate |  |  |  |  | 0 | 0 | 0 | 0
27 |  | Intrastate |  |  |  |  | 0 | 0 | 0 | 0
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense |  |  |  |  | 0 | 0 | 0 | 0
29 |  | Transport Revenue |  |  |  |  | 0 | 0 | 0 | 0
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance |  |  |  |  | 0 | 0 | 0 | 0
31 |  | Prior Month Book Balance |  |  |  |  | 0 | 0 | 0 | 0
 |  | Total MTM Income
32 |  | Prudency |  |  |  |  | 0 | 0 | 0 | 0
33 |  | Financial Liquidations |  |  |  |  | 0 | 0 | 0 | 0 |  | -223314
34 |  | Originations |  |  |  |  | 0 | 0 | 0 | 0
35 |  | Broker Fees |  |  |  |  | 0 | 0 | 0 | 0
36 |  | Asset Group Demand Charges |  |  |  |  | 0 | 0 | 0 | 0
37 |  | [NAME] |  |  |  |  | 0 | 0 | 0 | 0
38 |  | Interdesk Charges |  |  |  |  | 0 | 0 | 0 | 0
39 |  | Canada |  |  |  |  | 0 | 0 | 0 | 0
40 |  | Miscellaneous |  |  |  |  | 0 | 0 | 0 | 0
 |  | TOTAL
Spreadsheet: 847186d1698233967-counting-highest-type-value-for-a-given-name-example-excel
Sheet: Sheet1

Date | Name | Type |  | Number of names of each type (current system) |  |  |  |  |  | Number of names of each type (desired result)
2023-10-25 00:00:00 | 1 | 1 |  | type | 1 | 2 | 3 |  |  | type | 1 | 2 | 3
2023-10-26 00:00:00 | 1 | 1 |  | no of names |  |  |  |  |  | no of names | 1 | 2 | 2
2023-10-27 00:00:00 | 2 | 1
2023-10-28 00:00:00 | 2 | 2
2023-10-29 00:00:00 | 3 | 1
2023-10-30 00:00:00 | 3 | 1
2023-10-31 00:00:00 | 3 | 2
2023-11-01 00:00:00 | 3 | 3
2023-11-02 00:00:00 | 4 | 1
2023-11-03 00:00:00 | 4 | 2
2023-11-04 00:00:00 | 5 | 1
2023-11-05 00:00:00 | 5 | 3
2023-11-06 00:00:00 | 5 | 2
Spreadsheet: 804391d1668037293-formula-for-printing-all-sheets-xcvbtr10
Sheet: 30

 |  | [NAME])  YA MSHIRIKA T.A.G HERMON REVIVAL CHURCH |  |  |  |  |  |  |  |  | MWAKA
 |  | JINA KAMILI | WEEKS | JAN | FEB | [NAME] | APRIL | MAY | [NAME] | JULY | AUGU | SEPT | OKT | NOV | DEC | JUMLA
 |  | HT26 | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | JUMLA
Spreadsheet: 688376d1595758223-extract-list-with-formulas-data-label-list-by-month-with-space
Sheet: Sheet1

Launch Date | Brand | Item Name
2019-01-01 00:00:00 | Brand A | A0001
2019-01-01 00:00:00 | Brand A | A0002
2019-01-01 00:00:00 | Brand A | A0003
2019-01-01 00:00:00 | Brand C | C0001
2019-01-01 00:00:00 | Brand C | C0002
2019-05-01 00:00:00 | Brand C | C0003
2019-05-01 00:00:00 | Brand C | C0004
2019-05-01 00:00:00 | Brand D | D0001
2019-05-01 00:00:00 | Brand D | [NAME]
2019-05-01 00:00:00 | Brand D | D0003
2019-07-01 00:00:00 | Brand B | B0001
2019-07-01 00:00:00 | Brand B | B0002
2019-07-01 00:00:00 | Brand B | [NAME]
2019-07-01 00:00:00 | Brand B | B0004 |  |  | 2019-01-01 00:00:00
2019-08-01 00:00:00 | Brand A | A0004 |  | New SKUs
2019-08-01 00:00:00 | Brand A | A0005 |  | Cum. # SKUs
2019-08-01 00:00:00 | Brand A | A0006
2019-08-01 00:00:00 | Brand B | B0005
2019-09-01 00:00:00 | Brand A | A0007
2019-09-01 00:00:00 | Brand E | E0003
2019-09-01 00:00:00 | Brand E | E0004
2019-11-01 00:00:00 | Brand D | D0004
2019-11-01 00:00:00 | Brand E | E0001
2019-11-01 00:00:00 | Brand E | E0002
2019-12-01 00:00:00 | Brand D | D0005
 |  |  |  |  | Brand A |  |  |  | Brand C |  | Brand B | Brand A | Brand A |  | Brand D | Brand D
 |  |  |  |  | A0001 |  |  |  | C0003 |  | B0001 | A0004 | A0007 |  | D0004 | D0005
 |  |  |  |  | A0002 |  |  |  | C0004 |  | B0002 | A0005
 |  |  |  |  | A0003 |  |  |  |  |  | [NAME] | A0006 | Brand E |  | Brand E
 |  |  |  |  |  |  |  |  | Brand D |  | B0004 |  | E0003 |  | E0001
 |  |  |  |  | Brand C |  |  |  | D0001 |  |  | Brand B | E0004 |  | E0002
 |  |  |  |  | C0001 |  |  |  | [NAME] |  |  | B0005
 |  |  |  |  | C0002 |  |  |  | D0003
Spreadsheet: eric_saibi__9899__102501
Sheet: Centralia 01

Owner Name | TransAlta Corporation
Station Name | Centralia Power Station
Unit Name | [NAME] 01
NERC Region | WSCC
State | WA
Fuel Type | Coal
Capacity | 730 MW
Start Date | 2001-10-24 00:00:00
End Date | 2001-10-24 00:00:00
Comments | Back up from a tube leak, expecting to be at 100% on Friday.
SIC | 4911
Plant ID | 1000384
Unit ID | 1008608
Outage ID | 18724
Spreadsheet: 41908d1240451120-reading-from-a-particular-page-based-on-drop-list-option-fixexample
Sheet: 7Team

1 | 2
3 | 4
5 | 6
7 | Bye
2 | 4
1 | 6
3 | 7
5 | Bye
4 | 6
2 | 7
1 | 5
3 | Bye
6 | 7
4 | 5
2 | 3
1 | Bye
7 | 5
6 | 3
4 | 1
2 | Bye
5 | 3
7 | 1
6 | 2
4 | Bye
3 | 1
5 | 2
7 | 4
6 | Bye
1 | 2
3 | 4
5 | 6
7 | Bye
2 | 4
1 | 6
3 | 7
5 | Bye
4 | 6
2 | 7
1 | 5
3 | Bye
Spreadsheet: 110599d1307218175-look-up-one-value-and-return-multiple-values-and-sum-tableptexample
Sheet: Sheet1

 |  |  |  | June | 2011 |  |  |  | Sunday |  |  | Monday |  |  | Tuesday |  |  | Wednesday | 1 |  | Thursday | 2 |  | Friday | 3 |  | Saturday | 1900-01-04 00:00:00
 | Search |  |  | chocolate | 13 |  |  |  | product | amount |  | product | amount |  | product | amount |  | product | amount |  | product | amount |  | product | amount |  | product | amount
 |  |  | 1 | chocolate | 3 |  |  |  |  |  |  |  |  |  |  |  |  | chocolate | 3 |  | coffee | 5 |  |  |  |  | cheese | 50
 |  |  | 2 | chocolate | 8 |  |  |  |  |  |  |  |  |  |  |  |  | cake | 12 |  | cheese | 20 |  |  |  |  | cake | 6
 |  |  | 4 | chocolate | 2 |  |  |  |  |  |  |  |  |  |  |  |  | cheese | 10 |  | cake | 10 |  |  |  |  | chocolate | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | cake | 2 |  |  |  |  | coffee | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | chocolate | 8
 |  |  |  |  |  |  |  |  |  | 5 |  |  | 6 |  |  | 7 |  |  | 8 |  |  | 9 |  |  | 10 |  |  | 11
 |  |  |  |  |  |  |  |  | product | amount |  | product | amount |  | product | amount |  | product | amount |  | product | amount |  | product | amount |  | product | amount
 |  |  |  |  |  |  |  |  |  | 12 |  |  | 13 |  |  | 14 |  |  | 15
 |  |  |  |  |  |  |  |  | product | amount |  | product | amount |  | product | amount |  | product | amount |  | product | amount |  | product | amount |  | product | amount
Spreadsheet: f49a5e7c-f6f0-4e15-a53d-60144eb69235
Sheet: Sheet1

Financial Highlights - AmBev Consolidated | Unnamed: 1 | Unnamed: 2 | % As | % | Unnamed: 5 | Unnamed: 6 | % As.1 | %.1
R$ million | 2Q09 | 2Q10 | Reported | Organic | YTD 09 | YTD 10 | Reported | Organic
Total volumes | 34076.4899623038 | 36896.02477164332 | 0.08274135078051015 | 0.08274135078051033 | 71344.65651316995 | 77822.57951934478 | 0.09079759189784653 | 0.08651163671992
Beer | 24498.97368822967 | 26783.09189899207 | 0.09323322029035785 | 0.09323322029035787 | 50813.84523021514 | 56182.38009713071 | 0.1056510256720999 | 0.1052502293948703
CSD and NANC | 9577.516274074129 | 10112.93287265125 | 0.05590349139123529 | 0.05590349139123534 | 20530.81128295482 | 21640.19942221407 | 0.05403528014405778 | 0.04013354016571825
Net sales | 5348.134 | 5678.373000000001 | 0.06174845282485442 | 0.1154300986647615 | 11003.817 | 11799.795 | 0.07233653558578812 | 0.1402563047384998
Gross profit | 3623.749 | 3739.353000000001 | 0.03190176803084332 | 0.07304896254107647 | 7382.297 | 7861.75 | 0.06494631684420171 | 0.1229079129135541
Gross margin | 0.677572588869314 | 0.6585254262092328 | -190 | -260 | 0.67088511195706 | 0.6662615748832924 | -50 | -100
EBITDA | 2367.329 | 2408.36 | 0.01733219168100431 | 0.04674542387723833 | 5167.674 | 5182.31 | 0.002832222001620144 | 0.04715862275183932
EBITDA margin | 0.4426457901017438 | 0.4241285311831399 | -190 | -270 | 0.4696255853764198 | 0.439186443493298 | -300 | -380
Normalized EBITDA | 2383.124 | 2422.851 | 0.01667013550281071 | 0.04707643234831416 | 4966.045 | 5229.389 | 0.05302891939158827 | 0.1002104898649726
Normalized EBITDA margin | 0.4455991566404282 | 0.4266804945712442 | -190 | -270 | 0.4513020345576448 | 0.4431762585705938 | -80 | -160
Profit - AmBev holders | 1375.568 | 1510.241 | 0.09790355693066455 |  | 2964.224 | 3160.436999999999 | 0.0661937154547021
Normalized Profit - AmBev holders | 1391.363 | 1525.465 | 0.0963817494068766 |  | 2762.595 | 3242.08 | 0.1735632620778647
No. of share outstanding (millions) | 615.99401762 | 619.10030962 |  |  | 615.99401762 | 619.10030962
EPS (R$/shares) | 2.233086622033678 | 2.439412445015537 | 0.09239490351429236 |  | 4.812098681498231 | 5.104886802495473 | 0.0608441639243531
Normalized EPS | 2.258728104821168 | 2.464002967364564 | 0.0908807315520821 |  | 4.484775697455255 | 5.2367604241548 | 0.167674991444106
Spreadsheet: 809642d1671195623-how-to-change-all-data-in-new-page-when-copied-from-old-one-tst
Sheet: SOA MO 10

Verklaring van aktiwiteite
 | Cash Beginning of Period
 | Revenue:
 |  | Total Revenue:
 | Expenses:
 |  | Total Expenses:
 | Net : Income Gain / (Loss)
 | Cash End of Period
Spreadsheet: 761995d1641335592-unique-entries-keeping-only-one-with-a-labelled-word-unique-entries-keeping-only-one-with-a-labelled-word
Sheet: Dateset

Raw Data |  | Unique entries, keeping only one with a labelled word |  | Word labels
 |  | Example
I have a purple bottle |  | I have a purple bottle |  | Purple
She eats Orange |  | She eats Orange |  | Orange
She eats Orange |  | Blue is my favorite color |  | Blue
She eats Orange 12345 |  | The grass is green
She eats Orange 77777 |  | The grass is green 1234
She eats Orange 99999
Blue is my favorite color
The grass is green
The grass is green 1234
Spreadsheet: 834980d1688209476-rank-function-streamline-process-rank-function-ans
Sheet: Sheet1

 | Existing Data Set (Sample)
 | Q1 | Q2 | Q3 | Q4
2020 | -7156 | 9419 | 6490 | 5116
2021 | 4216 | 2137 | -8701 | 5217
2022 | -4731 | -8062 | 9946 | 1421
2023 | 5217 | 1396 |  |  |  | Cell B7 value changed for test purpose.
 | SIMPLE RANK Function (same structure)
 | What I would like instead is the following:
 | RANK * | AMOUNT ** | QTR/YEAR *** |  |  |  |  |  |  | RANK * | AMOUNT ** | QTR/YEAR ***
 | 1 |  |  |  |  |  |  |  |  | 1 | 9946 | 2022 - Q3
 | 2 |  |  |  |  |  |  |  |  | 2 | 9419 | 2020 - Q2
 | 3 |  |  |  |  |  |  |  |  | 3 | 6490 | 2020 - Q3
 | 4 |  |  |  | Cell B7 value changed for test purpose. |  |  |  |  | 4 | 5217 | 2021 - Q4
 | 5 |  |  |  |  |  |  |  |  | 5 | 5158 | 2023 - Q1
 | 6 |  |  |  |  |  |  |  |  | 6 | 5116 | 2020 - Q4
 | 7 |  |  |  |  |  |  |  |  | 7 | 4216 | 2021 - Q1
 | 8 |  |  |  | See comments in B38:B40 |  |  |  |  | 8 | 2137 | 2021 - Q2
 | 9 |  |  |  |  |  |  |  |  | 9 | 1421 | 2022 - Q4
 | 10 |  |  |  |  |  |  |  |  | 10 | 1396 | 2023 - Q2
 | 11 |  |  |  |  |  |  |  |  | 11 | -4731 | 2022 - Q1
 | 12 |  |  |  |  |  |  |  |  | 12 | -7156 | 2020 - Q1
 | 13 |  |  |  |  |  |  |  |  | 13 | -8062 | 2022 - Q2
 | 14 |  |  |  |  |  |  |  |  | 14 | -8701 | 2021 - Q3
 | 15 |  |  |  |  |  |  |  |  | 15 | -- | --
 | 16 |  |  |  |  |  |  |  |  | 16 | -- | --
 | * Needs to be a formula
 | ** Needs to be the RANK formula (top-down across 16 rows vs. top-down for 4 rows COL B; & 4 rows COL C, etc.)
 | *** Needs to be a lookup formula based on the ranked value