tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 825001d1681027037-how-to-add-sum-formula-for-various-sheets-expenses
Sheet: 2021

Personal Expenses
Month | Date | Category | Sub-Category | Description | Credit | Debit | Balance
 | 2021-06-21 00:00:00 | Donation | Zakath |  |  | 5000
 | 2021-06-23 00:00:00 | Donation | Sadqa |  |  | 500
 | 2021-06-28 00:00:00 | Donation | Zakath |  |  | 1500
 | 2021-07-11 00:00:00 | Donation | Sadqa |  |  | 100
 | 2021-07-12 00:00:00 | Donation | Sadqa |  |  | 100
 | 2021-07-14 00:00:00 | Donation | Sadqa |  |  | 500
 | 2021-07-17 00:00:00 | Donation | Sadqa |  |  | 20
 | 2021-07-17 00:00:00 | Donation | Sadqa |  |  | 10
 | 2021-07-19 00:00:00 | Donation | Sadqa |  |  | 1500
 | 2021-07-20 00:00:00 | Donation | Sadqa |  |  | 500
 | 2021-07-21 00:00:00 | Donation | Sadqa |  |  | 500
 | 2021-07-21 00:00:00 | Donation | Sadqa |  |  | 500
 | 2021-07-25 00:00:00 | Donation | Sadqa |  |  | 10
 | 2021-07-29 00:00:00 | Donation | Zakath |  |  | 2000
 | 2021-07-30 00:00:00 | Donation | Sadqa |  |  | 10
 | 2021-07-31 00:00:00 | Donation | Sadqa |  |  | 10
 | 2021-08-06 00:00:00 | Donation | Sadqa |  |  | 100
 | 2021-08-08 00:00:00 | Donation | Sadqa |  |  | 100
 | 2021-08-11 00:00:00 | Donation | Sadqa |  |  | 100
 | 2021-08-14 00:00:00 | Donation | Sadqa |  |  | 100
 | 2021-08-14 00:00:00 | Donation | Sadqa |  |  | 500
 | 2021-08-24 00:00:00 | Donation | Sadqa |  |  | 100
 | 2021-09-10 00:00:00 | Donation | Sadqa |  |  | 500
 | 2021-09-12 00:00:00 | Donation | Sadqa |  |  | 1000
 | 2021-10-08 00:00:00 | Donation | Zakath |  |  | 5000
 | 2021-10-09 00:00:00 | Donation | Sadqa |  |  | 2000
 | 2021-10-15 00:00:00 | Donation | Zakath |  |  | 100
 | 2021-10-19 00:00:00 | Donation | Zakath |  |  | 2000
 | 2021-11-07 00:00:00 | Donation | Sadqa |  |  | 20
 | 2021-11-07 00:00:00 | Donation | Sadqa |  |  | 20
 | 2021-11-07 00:00:00 | Donation | Sadqa |  |  | 2000
 | 2021-11-08 00:00:00 | Donation | Sadqa |  |  | 20
 | 2021-11-09 00:00:00 | Donation | Sadqa |  |  | 10
 | 2021-11-18 00:00:00 | Donation | Sadqa |  |  | 20
 | 2021-11-27 00:00:00 | Donation | Sadqa |  |  | 20
 | 2021-11-27 00:00:00 | Donation | Sadqa |  |  | 10
 | 2021-12-01 00:00:00 | Donation | Sadqa |  |  | 50
 | 2021-12-04 00:00:00 | Donation | Sadqa |  |  | 10
 | 2021-12-30 00:00:00 | Donation | Sadqa |  |  | 500
 | 2021-12-30 00:00:00 | Donation | Sadqa |  |  | 100
 | 2021-12-30 00:00:00 | Donation | Sadqa |  |  | 150
 | 2021-12-30 00:00:00 | Donation | Sadqa |  |  | 100
 | 2021-02-09 00:00:00 | Income |  |  | 75000
Total
Spreadsheet: 752924d1635101576-move-data-from-one-sheet-to-another-which-matches-two-criteria-example-spreadsheet-1
Sheet: Master sheet (no load)

Site details |  |  |  |  |  |  |  | 2021-11-01 00:00:00 |  |  |  | 2021-11-02 00:00:00 |  |  |  | 2021-11-03 00:00:00 |  |  |  | 2021-11-04 00:00:00 |  |  |  | 2021-11-05 00:00:00
Route | Route order | Status | Company | Code | Site | Address | Postcode | Level of completion | To charge | Cost | Profit | Level of completion | To charge | Cost | Profit | Level of completion | To charge | Cost | Profit | Level of completion | To charge | Cost | Profit | Level of completion | To charge | Cost | Profit
Text | Text | Text | Text | Text | Site 1 | Text | Text
Text | Text | Text | Text | Text | Site 2 | Text | Text
Text | Text | Text | Text | Text | Site 3 | Text | Text
Text | Text | Text | Text | Text | Site 4 | Text | Text
Text | Text | Text | Text | Text | Site 5 | Text | Text
 |  | This is an example of the master sheet with some of the pre excisitng columns in place. Note that the site order is not the same.
Spreadsheet: 6e1d3b49-39a3-4dc7-a72c-344bd42408da
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | mitotic phase | Wolb distribution |  | "n"
 |  | even | asymm
 | prophase | - | 6 | 6
 | prometaphase | 2 | 13 | 15
 | metaphase | 4 | 8 | 12
 | anaphase | - | 4 | 4
 | telophase | 4 | 15 | 19
 | total | 10 | 46 | 56
Spreadsheet: 827808d1683038606-calculate-sales-price-to-achieve-margin-margin-calculation
Sheet: Sheet1

Current |  |  |  |  |  |  |  | Desired Outcome: sales price altered to give 20% margin
Purchase £ | Sales £ | Target Margin % | Actual Margin % |  |  |  |  | Purchase £ | Sales £ | Target Margin % | Actual Margin %
19 | 22 | 20 |  |  |  |  |  | 19 | 24.99999613976683 | 20
10 | 12 | 20 |  |  |  |  |  | 10 | 13.1578447273484 | 20
100 | 120 | 20 |  |  |  |  |  | 100 | 131.578447273484 | 20
Spreadsheet: 213582d1360585052-return-a-1st-2nd-or-3rd-from-row-of-numbers-society-scoring-system-template
Sheet: stats

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Order of Merit points | Society Average points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | average | Highest | Lowest | Total
Names        H/caps |  |  | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | ↓ | ↓ | ↓ | ↓ | ↓ | ↓
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Highest individual score
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ↓
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lowest individual score
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ↓
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Highest average score
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ↓
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AM scores |  |  | →
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total PM scores |  |  | →
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average society handicap
Spreadsheet: 150800d1334683252-combining-an-and-and-if-function-how-to-my-doc
Sheet: Sheet1

 |  |  |  | state | euro | 12345
Transaction From |  |  |  | state | rupees | 11111
 | Bank | state |  | state | rands | 33333
 | Currency | euro |  | state | dollars | 12564
 | account number |  |  | mcb | yen | 12432
 |  |  |  | bank one | suisse francs | 67898
 |  |  |  | afrasia | canadian dollars | 89999
 |  |  |  | mcb | usd | 88888
 |  |  |  | bank one | rands | 55555
 |  |  |  | afrasia | rupees | 66666
 |  |  |  | bank one | euro | 12333
 |  |  |  | afrasia | usd | 77665
 |  |  |  | afrasia | euro | 99881
Spreadsheet: 648166d1572904585-finding-the-first-appearance-of-the-latest-item-sample_file_latest_job
Sheet: Sheet1

ID | JOB CODE | EFFECTIVE DATE | FULL NAME | STATUS
12345 | 995900 | 2018-07-01 00:00:00 | [NAME], [NAME] | Active
12345 | 995900 | 2018-07-01 00:00:00 | [NAME], [NAME] | Active
12345 | 995900 | 2018-02-11 00:00:00 | [NAME], [NAME] | Active
12345 | 995900 | 2018-02-11 00:00:00 | [NAME], [NAME] | Active
12345 | 995900 | 2016-07-03 00:00:00 | [NAME], [NAME] | Active
12345 | 995900 | 2014-09-28 00:00:00 | [NAME], [NAME] | Active
12345 | 995900 | 2014-09-28 00:00:00 | [NAME], [NAME] | Active
12345 | 995900 | 2014-07-06 00:00:00 | [NAME], [NAME] | Active
12345 | 995900 | 2013-01-06 00:00:00 | [NAME], [NAME] | Active
12345 | 995900 | 2012-01-03 00:00:00 | [NAME], [NAME] | Active
12345 | 995900 | 2011-06-27 00:00:00 | [NAME], [NAME] | Active
12345 | 995900 | 2011-04-17 00:00:00 | [NAME], [NAME] | Active
12345 | 991800 | 2008-06-30 00:00:00 | [NAME], [NAME] | Active
12345 | 995900 | 2007-07-15 00:00:00 | [NAME], [NAME] | Active
12345 | 991800 | 2007-07-09 00:00:00 | [NAME], [NAME] | Active
12345 | 995900 | 2005-05-01 00:00:00 | [NAME], [NAME] | Active
12345 | 991800 | 2005-01-02 00:00:00 | [NAME], [NAME] | Active
12345 | 995900 | 2005-01-02 00:00:00 | [NAME], [NAME] | Active
12345 | 991800 | 2001-01-01 00:00:00 | [NAME], [NAME] | Active
12345 | 995900 | 2001-01-01 00:00:00 | [NAME], [NAME] | Active
54321 | 385056 | 2019-09-08 00:00:00 | Mermaid, Little | Active
54321 | 385056 | 2018-07-05 00:00:00 | Mermaid, Little | Active
23541 | 385055 | 2019-03-10 00:00:00 | Face, [NAME] | Active
23541 | 385055 | 2018-08-26 00:00:00 | Face, [NAME] | Active
23541 | 385056 | 2018-03-11 00:00:00 | Face, [NAME] | Active
23541 | 385056 | 2017-05-02 00:00:00 | Face, [NAME] | Active
23541 | 385056 | 2017-03-12 00:00:00 | Face, [NAME] | Active
23541 | 385056 | 2016-03-13 00:00:00 | Face, [NAME] | Active
23541 | 385056 | 2015-03-15 00:00:00 | Face, [NAME] | Active
23541 | 385056 | 2014-03-16 00:00:00 | Face, [NAME] | Active
23541 | 385056 | 2013-03-17 00:00:00 | Face, [NAME] | Active
23541 | 385056 | 2012-03-18 00:00:00 | Face, [NAME] | Active
23541 | 385056 | 2012-01-03 00:00:00 | Face, [NAME] | Active
23541 | 385056 | 2011-03-20 00:00:00 | Face, [NAME] | Active
23541 | 385056 | 2010-07-25 00:00:00 | Face, [NAME] | Active
23541 | 385056 | 2010-03-21 00:00:00 | Face, [NAME] | Active
23541 | 385056 | 2009-03-22 00:00:00 | Face, [NAME] | Active
23541 | 385056 | 2008-03-23 00:00:00 | Face, [NAME] | Active
23541 | 385056 | 2007-07-09 00:00:00 | Face, [NAME] | Active
23541 | 385056 | 2007-03-25 00:00:00 | Face, [NAME] | Active
23541 | 385056 | 2006-03-26 00:00:00 | Face, [NAME] | Active
23541 | 385056 | 2005-10-23 00:00:00 | Face, [NAME] | Active
23541 | 385056 | 2005-03-27 00:00:00 | Face, [NAME] | Active
23541 | 385056 | 2004-09-12 00:00:00 | Face, [NAME] | Active
23541 | 385000 | 2004-03-28 00:00:00 | Face, [NAME] | Active
23541 | 385000 | 2002-03-31 00:00:00 | Face, [NAME] | Active
23541 | 385000 | 2001-01-01 00:00:00 | Face, [NAME] | Active
Spreadsheet: 24845b11-ddfc-4a28-8d5c-baa1a52e88c3
Sheet: Sheet1

 |  |  |  |  |  | Genneral mortality
 | Table 5.3 International comparison of crude death rates and 　　         age standardized death rates (per 100,000 population),2004
 | Country | population | Death rates | Age-standardized death rates World standard population | Proportion of age-standardized death rates index  (Japan=100)
 | Japan | 127798000 | 792.8 | 361.8 | 100
 | Canada | 31955000 | 704.3 | 429.5
 | United States of America | 296844000 | 831.3 | 536.7
 | Austria | 8253000 | 904.1 | 464.4
 | Czech Republic | 10195000 | 1045.3 | 632.3
 | Denmark | 5403000 | 1050.2 | 554.6
 | France | 60624000 | 901.4 | 457.6
 | Germany | 82628000 | 998.7 | 480
 | Hungary | 10113000 | 1289.8 | 775.5
 | Italy | 58475000 | 946.4 | 417.8
 | Netherlands | 16264000 | 842.7 | 479.4
 | Norway | 4609000 | 898.3 | 455.3
 | Poland | 38247000 | 964.6 | 663.3
 | Sweden | 8998000 | 978.2 | 426
 | Switzerland | 7392000 | 820.5 | 412.7
 | United Kingdom | 59965000 | 993.7 | 504
 | Australia | 20081000 | 668.5 | 407.6
 | New Zealand | 4050000 | 684.1 | 450.8
 | Source： WHO 「Global burden of disease ： 2004 update[NAME]
 |  | World standard population
 |  | Age group |  | World
 |  | 0　　　　Years |  | 1800
 |  | 1～4 |  | 7000
 |  | 5～9 |  | 8700
 |  | 10～14 |  | 8600
 |  | 15～19 |  | 8500
 |  | 20～24 |  | 8200
 |  | 25～29 |  | 7900
 |  | 30～34 |  | 7600
 |  | 35～39 |  | 7200
 |  | 40～44 |  | 6600
 |  | 45～49 |  | 6000
 |  | 50～54 |  | 5400
 |  | 55～59 |  | 4600
 |  | 60～64 |  | 3700
 |  | 65～69 |  | 3000
 |  | 70～74 |  | 2200
 |  | 75～79 |  | 1500
 |  | 80～84 |  | 900
 |  | 85+ |  | 600
 |  | Total |  | 100 000
Spreadsheet: 185007d1349451153-build-lists-based-on-criteria-ef207_sample
Sheet: Sheet1

 | Criteria for this sheet: |  |  |  |  |  |  |  | TYPE
 |  | Type | EC |  |  |  |  |  | AT
 |  | Year |  |  |  |  |  |  | EC
 |  | Month |  |  |  |  |  |  | OT
 |  | Week |  |  |  |  |  |  | PAI
 |  |  |  |  |  |  |  |  | PAT
 |  |  |  |  |  |  |  |  | T
 |  |  |  |  |  |  |  |  | TA
match | LAT | LON | TYPE | DATE |  |  |  |  | V
Spreadsheet: 0e03fbda-fc0f-4969-be8f-2ad8f82d7c86
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19
 |  | NAHB Economic and Housing Executive-Level Forecast
 | 2013-04-03 00:00:00
 |  |  |  | Annual Data * |  |  |  |  |  | 2012** |  |  |  | 2013** |  |  |  | 2014**
 |  | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | I | II | III | IV | I | II | III | IV | I | II | III | IV
Economic Activity
Real GDP    Bil. 2005$ |  | 12757.9499999999
% Chge AR |  | -0.03069269882634962
Resid. Fixed Inv. 2005$*** |  | 344.8
% Chge AR |  | -0.2241660572650054
Single Family |  | 105.45
Multifamily |  | 23.6
Other |  | 215.5
Payroll Employment - Mil. |  | 130.85925
% Chge AR |  | -0.04376904471351628
Unemployment Rate - Civilian |  | 0.0928333333333333
Prices - Percent Change Annual Rate
GDP - Chain type |  | 0.008907126852868874
PPI - Finished Goods |  | -0.02529261507101743 |  | SAMPLE
CPI - Urban Consumers |  | -0.003195062750192212
Core PCE |  | 0.01416791253971228
Case-Shiller National HPI (SA) |  | -0.1149372419871573
Interest Rates
Federal Funds Rate |  | 0.00125
90 day T [NAME] |  | 0.00150833333333333
Treasury Yields:
One Year Maturity |  | 0.00470833333333333
Ten Year Maturity |  | 0.0325666665833333
Freddie Mac Commitment Rates:
30-Year Fixed Rate Mortgages |  | 0.0504225007499999
1-Year ARMs |  | 0.04709375075
Prime Rate |  | 0.0325
Housing Activity (000)
Total Housing Starts |  | 553.9999999999993
% Chge AR |  | -0.3844444444444447
Single Family |  | 442.416666666666
% Chge AR |  | -0.282179556517037
Multifamily |  | 111.5833333333333
% Chge AR |  | -0.6066392479435954
2 to 4 Family |  | 12
5 plus Family |  | 99.5833333333333
New Single Family Sales |  | 374.25
% Chge AR |  | -0.2238161078465251
Existing Single-Family Home Sales |  | 3868.33333333333
% Chge AR |  | 0.05836753305973463
Manufactured Home Shipments |  | 49.8333333333333
Total New Housing Units:
Total Starts + Man. Home Shipments |  | 603.8333333333326
* Annual totals are averages of seasonally adjusted quarterly data and may not match reported annuals from other sources.
** All quarterly data are at annual rates, and all data except interest rates are seasonally adjusted.
***  Includes the dollar volume of construction put-in-place for new single-family and multifamily structures, manufactured home shipments,
brokerage commissions on home sales, and improvements to existing structures (additions, alterations, and major replacements).
Spreadsheet: 861270d1709198693-taking-weekly-data-and-converting-to-monthly-formula-query-2
Sheet: Weekly Forecast

 | Opening Cash |  | Cash Flow Summary - Weekly
 | 3573315.55
 | Minimum Cash Balance
 | 100000
 | Week ending |  | 2023-09-03 00:00:00 | 2023-09-10 00:00:00 | 2023-09-17 00:00:00 | 2023-09-24 00:00:00 | 2023-10-01 00:00:00 | 2023-10-08 00:00:00 | 2023-10-15 00:00:00 | 2023-10-22 00:00:00 | 2023-10-29 00:00:00 | 2023-11-05 00:00:00 | 2023-11-12 00:00:00 | 2023-11-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | Cash balance at beginning of week
 | Helper
 | Cash Receipts
 | Deposit
 | Reg Fees
 | Advanced Fees
 | Sales Ledger
 | Donation
 | Commercial Activities
 | Trips
 | Commem
 | Investment Income
 | Childcare
 | Intercompany
 | Total Cash Receipts
 | Cash paid out
 | Council Tax
 | Bank Charges
 | Travel
 | TV
 | Management Fees
 | IT
 | Phone
 | Lease
 | Marketing
 | Subscription
 | Adhoc
 | VAT
 | Cleaning Contract
 | Purchase Ledger
 | Insurance
 | Credit Card
 | Loan
 | Water Rates
 | Energy
 | Gas
 | Pension
 | Payroll
 | INLAND
 | Capital Projects
 | Catering
 | Total Cash Paid Out
 | Cash balance at end of week
Spreadsheet: 2765f5d5-a65f-4638-adab-14456376f5a4
Sheet: Sheet1

Health Care Property Investors, Inc. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
1099 Dividend Information for the Year 2002
To the Common Shareholders of Health Care Property Investors, Inc.
The following table summarizes, for income tax purposes, the nature of cash distributions paid by Health Care
Property Investors, Inc. (the "Company") to its common shareholders during the calendar year ended
December 31, 2002:
 | Record |  | Payment |  | Cash Dividends |  | Ordinary |  | [NAME] |  | Return of
 | Date |  | Date |  | Paid Per Share |  | Income |  | Income |  | Capital
 | 2002-02-04 00:00:00 |  | 2002-02-20 00:00:00 |  | 0.8 |  | 0.56 |  | 0 |  | 0.24
 | 2002-05-06 00:00:00 |  | 2002-05-18 00:00:00 |  | 0.81 |  | 0.57 |  | 0 |  | 0.24
 | 2002-08-05 00:00:00 |  | 2002-08-20 00:00:00 |  | 0.82 |  | 0.58 |  | 0 |  | 0.24
 | 2002-11-08 00:00:00 |  | 2002-11-20 00:00:00 |  | 0.83 |  | 0.58 |  | 0 |  | 0.25
 |  |  |  |  | 3.26 |  | 2.29 |  | 0 |  | 0.97
The foregoing information is subject to adjustment following audit of the tax returns by the Internal Revenue Service.
Because the Company has elected to be taxed as a real estate investment trust, the dividends do not qualify for the
dividend received deduction for corporate shareholders.
To the Preferred Shareholders of Health Care Property Investors, Inc.
The following table summarizes, for income tax purposes, the nature of cash dividends paid by Health Care
Property Investors, Inc. (the "Company") to its preferred shareholders, by series, during the calendar year
ended December 31, 2002.
Series | Coupon |  | Total Cash Dividend Paid |  | Ordinary Income
A | 0.07875 |  | 1.9688 |  | 1.9688
B | 0.087 |  | 2.175 |  | 2.175
C | 0.086 |  | 2.15 |  | 2.15
Dividends representing 1/4 of the amounts indicated for each Series of Preferred Stock were paid on
each of March 29, June 28, September 30 and December 31, 2002.
Spreadsheet: 33b2cc9f-b76f-490b-a1cd-c9c322fd5be9
Sheet: Delhi Center

[NAME]
505 E. Central Ave.
Santa Ana, CA 92707
Main Phone Line: (714) 481-9600
Main Fax: (714) 481-9698
Name and Title | Role | Contact Email | Contact Phone Number | Fax Number
[NAME], Director of Education and Health | HIV Program Supervisor | [EMAIL] | [PHONE] | [PHONE]
[NAME], Senior Case Manager | Senior Case Manager | [EMAIL] | 7144819600 | [PHONE]
[NAME], Case Manager | Case Manager | [EMAIL] | [PHONE] | [PHONE]
Spreadsheet: 0e7cd4e4-5f5e-4a40-81f3-bfa25fafb4f7
Sheet: Sheet1

Table 2--World cotton supply and use estimates | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  |  |  | 2011/12
Item | 2010/11 |  | Aug. |  | Sep. |  | Oct.
 | Million 480-lb. [NAME]
Supply:
Beginning stocks--
World | 43.99 |  | 44.99 |  | 43.97 |  | 44.87
Foreign | 41.05 |  | 42.14 |  | 41.37 |  | 42.27
Production--
World | 115.08 |  | 122.71 |  | 122.96 |  | 124.19
Foreign | 96.97 |  | 106.16 |  | 106.41 |  | 107.58
Imports--
World | 35.6 |  | 37.58 |  | 37.31 |  | 36.53
Foreign | 35.59 |  | 37.58 |  | 37.3 |  | 36.52
Use:
[NAME] use--
World | 114.32 |  | 115.18 |  | 115.22 |  | 114.38
Foreign | 110.42 |  | 111.38 |  | 111.42 |  | 110.58
Exports--
World | 35.44 |  | 37.59 |  | 37.3 |  | 36.51
Foreign | 21.07 |  | 25.29 |  | 25.3 |  | 25.01
Ending stocks--
World | 44.87 |  | 52.66 |  | 51.91 |  | 54.83
Foreign | 42.27 |  | 49.36 |  | 48.51 |  | 50.93
 | Percent
Stocks-to-use ratio:
World | 39.2 |  | 45.7 |  | 45.1 |  | 47.9
Foreign | 38.3 |  | 44.3 |  | 43.5 |  | 46.1
 | 3
Last update: 10/13/11.
Source: USDA, World Agricultural Outlook Board.
Spreadsheet: 710500d1609054976-multiple-criteria-if-condition-identify-highest-number-based-upon-preceding-criteria-active-offset-account-tracker
Sheet: Sheet1

Home #1 | Home #2 | Home #3 | Home #4 | Home #1 | Home #2 | Home #3 | Home #4 |  | Home #1 | Home #2 | Home #3 | Home #4
Home Loan #1 | Home Loan #2 | Home Loan #3 | Home Loan #4 | Interest Rate Account #1 | Interest Rate Account #2 | Interest Rate Account #3 | Interest Rate Account #4 |  | Offset Account #1 | Offset Account #2 | Offset Account #3 | Offset Account #4
100000 | 75000 | 50000 | 25000 | 0.045 | 0.045 | 0.045 | 0.045
100000 | 75000 | 50000 | 25000 | 0.045 | 0.045 | 0.045 | 0.045
100000 | 75000 | 50000 | 25000 | 0.045 | 0.045 | 0.045 | 0.045
100000 | 75000 | 50000 | 25000 | 0.045 | 0.045 | 0.06 | 0.045
100000 | 75000 | 50000 | 25000 | 0.045 | 0.045 | 0.06 | 0.045
100000 | 75000 | 50000 | 25000 | 0.045 | 0.045 | 0.06 | 0.06
100000 | 75000 | 50000 | 25000 | 0.045 | 0.045 | 0.06 | 0.06
100000 | 75000 | 50000 | 25000 | 0.045 | 0.045 | 0.06 | 0.06
100000 | 75000 | 50000 | 25000 | 0.06 | 0.06 | 0.06 | 0.06
100000 | 75000 | 50000 | 25000 | 0.06 | 0.06 | 0.06 | 0.06
100000 | 75000 | 50000 | 25000 | 0.06 | 0.06 | 0.06 | 0.06
100000 | 75000 | 50000 | 25000 | 0.06 | 0.06 | 0.06 | 0.06
100000 | 75000 | 50000 | 25000 | 0.06 | 0.06 | 0.06 | 0.06
Spreadsheet: 751540d1634160034-index-match-difficulties-sample-workbook
Sheet: Sheet1

[NAME] | Customer Name | 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 | Total
1 | Customer A
2 | Customer B
3 | Customer C
4 | Customer D
5 | Customer E
6 | Customer F
Spreadsheet: 75284d1275879103-pivottables-showing-percent-instead-of-values-excelforum-example2
Sheet: PivotTable

Row Labels | Sum of Revenue Act |  |  |  |  |  |  |  | Agent Chain | Agency Alias | Airline | Contracted Type | R2
EU DFDS | 60743.7450429848 |  |  |  |  |  |  |  | EU DFDS
DFDS Madrid | 60743.7450429848 |  |  |  |  |  |  |  |  | DFDS Madrid
AA | 43503.95519847074 |  | 1 | The task is to replace the amount for contracted |  |  |  |  |  |  | AA
Contracted Volume | 35316.09411847073 |  | 0.81 | and non-contracted volues with percentage. |  |  |  |  |  |  |  | Contracted Volume | 0.8117904212928247
Non Contracted Volume | 8187.86108 |  | 0.19 | Like this |  |  |  |  |  |  |  | Non Contracted Volume | 0.1882095787071751
CA | 334.12554 |  | 1 |  |  |  |  |  |  |  | AA Total |  | 1
Contracted Volume | 134.78818 |  | 0.4 |  |  |  |  |  |  |  | CA
Non Contracted Volume | 199.33736 |  | 0.6 |  |  |  |  |  |  |  |  | Contracted Volume | 0.4034057977130392
KK | 1766.313795016155 |  | 1 |  |  |  |  |  |  |  |  | Non Contracted Volume | 0.5965942022869607
Contracted Volume | 1392.776025016155 |  | 0.79 |  |  |  |  |  |  |  | CA Total |  | 1
Non Contracted Volume | 373.53777 |  | 0.21 |  |  |  |  |  |  |  | KK
LL | 10756.6501 |  | 1 |  |  |  |  |  |  |  |  | Contracted Volume | 0.7885212859379929
Contracted Volume | 9241.76357 |  | 0.86 |  |  |  |  |  |  |  |  | Non Contracted Volume | 0.211478714062007
Non Contracted Volume | 1514.88653 |  | 0.14 |  |  |  |  |  |  |  | KK Total |  | 1
XL | 658.09454 |  |  |  |  |  |  |  |  |  | LL
Contracted Volume | 464.18896 |  |  |  |  |  |  |  |  |  |  | Contracted Volume | 0.8591674437750838
Non Contracted Volume | 193.90558 |  |  |  |  |  |  |  |  |  |  | Non Contracted Volume | 0.1408325562249162
OO | 713.08962 |  |  |  |  |  |  |  |  |  | LL Total |  | 1
Contracted Volume | 573.23779 |  |  |  |  |  |  |  |  |  | OO
Non Contracted Volume | 139.85183 |  |  |  |  |  |  |  |  |  |  | Contracted Volume | 0.8038790271551002
UU | 353.27072 |  |  |  |  |  |  |  |  |  |  | Non Contracted Volume | 0.1961209728448999
Contracted Volume | 242.67385 |  |  |  |  |  |  |  |  |  | OO Total |  | 1
Non Contracted Volume | 110.59687 |  |  |  |  |  |  |  |  |  | UU
WW | 2658.245529497908 |  |  |  |  |  |  |  |  |  |  | Contracted Volume | 0.6869345129989828
Contracted Volume | 2289.746659497908 |  |  |  |  |  |  |  |  |  |  | Non Contracted Volume | 0.3130654870010172
Non Contracted Volume | 368.49887 |  |  |  |  |  |  |  |  |  | UU Total |  | 1
Grand Total | 60743.7450429848 |  |  |  |  |  |  |  |  |  | WW
 |  |  |  |  |  |  |  |  |  |  |  | Contracted Volume | 0.8613751566923157
 |  |  |  |  |  |  |  |  |  |  |  | Non Contracted Volume | 0.1386248433076844
 |  |  |  |  |  |  |  |  |  |  | WW Total |  | 1
 |  |  |  |  |  |  |  |  |  |  | XL
 |  |  |  |  |  |  |  |  |  |  |  | Contracted Volume | 0.705353002928728
 |  |  |  |  |  |  |  |  |  |  |  | Non Contracted Volume | 0.2946469970712718
 |  |  |  |  |  |  |  |  |  |  | XL Total |  | 1
 |  |  |  |  |  |  |  |  |  | DFDS Madrid Total |  |  | 8
 |  |  |  |  |  |  |  |  | EU DFDS Total |  |  |  | 8
 |  |  |  |  |  |  |  |  | Grand Total |  |  |  | 8