tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 787096d1657632541-sum-the-expenses-by-month-groups-of-contractors-2022-07-12-oeldere2-ymmies-samplesheet
Sheet: Received invoices

Number | Name of the contractor | Date of the payment | Price | Currency | Code | month | year | Group |  |  |  |  | Vlookup table
1 | [NAME] | 2019-01-01 00:00:00 | 456 | USD | wgQZSnj7mG ext000 part000 backend000 |  |  |  |  |  |  |  | [NAME] | Backend
2 | [NAME] | 2019-01-02 00:00:00 | 126 | USD | HJbA3ebAxb apps000 otherapp000 |  |  |  |  |  |  |  | [NAME] | Backend
3 | [NAME] | 2019-05-05 00:00:00 | 897 | USD | 4kZps56gHs apps000 [NAME] |  |  |  |  |  |  |  | [NAME] | Support
4 | Morgan Freeman | 2019-01-02 00:00:00 | 456 | USD | 7EyAAAQhQQ int000 full000 support000 |  |  |  |  |  |  |  | [NAME] | Support
5 | [NAME] | 2019-02-08 00:00:00 | 745 | USD | wgQZSnj7mG ext000 part000 backend000 |  |  |  |  |  |  |  | [NAME] | Other
6 | [NAME] | 2019-01-07 00:00:00 | 559 | USD | 7Sfsfe894ds apps000 [NAME]
7 | [NAME] | 2019-01-09 00:00:00 | 426 | USD | 4kZps56gHs apps000 [NAME]
8 | [NAME] | 2019-01-09 00:00:00 | 477 | USD
9 | Morgan Freeman | 2019-03-05 00:00:00 | 456 | USD | 7EyAAAQhQQ int000 full000 support000
10 | [NAME] | 2019-01-04 00:00:00 | 87 | USD | wgQZSnj7mG ext000 part000 backend000
11 | [NAME] | 2019-06-12 00:00:00 | 998 | USD | HJbA3ebAxb apps000 otherapp000
12 | [NAME] | 2019-01-02 00:00:00 | 4265 | USD | 4kZps56gHs apps000 [NAME]
13 | Morgan Freeman | 2019-01-02 00:00:00 | 452 | USD | 7EyAAAQhQQ int000 full000 support000
14 | [NAME] | 2019-05-02 00:00:00 | 42 | USD | wgQZSnj7mG ext000 part000 backend000
15 | [NAME] | 2019-01-02 00:00:00 | 899 | USD | wr89ssEfd45E ext000 part000 backend000
Spreadsheet: 642095d1568890403-help-with-a-string-of-if-statements-cashflow-template-online-example
Sheet: Base Case Cashflow

 |  |  |  |  |  |  |  |  |  | Year 1 |  |  |  | Year 2 |  |  |  | Year 3 |  |  |  | Year 4 |  |  |  | Year 5
 |  |  |  |  |  |  |  |  |  | 2019-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 00:00:00 | 2021-03-31 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2022-09-30 00:00:00 | 2022-12-31 00:00:00 | 2023-03-31 00:00:00 | 2023-06-30 00:00:00 | 2023-09-30 00:00:00 | 2023-12-31 00:00:00 | 2024-03-31 00:00:00 | 2024-06-30 00:00:00
Property Address | Tenant | Lease Start | Lease Break Exercised? | Lease Break Date | Lease Expiry | Rent | Rent Post Void | Post Void Lease Expiry | VOID (# [NAME]) | Q3 2019 | Q4 2019 | Q1 2020 | Q2 2020 | Q3 2020 | Q4 2020 | Q1 2021 | Q2 2021 | Q3 2021 | Q4 2021 | Q1 2022 | Q2 2022 | Q3 2022 | [NAME] | Q1 2023 | Q2 2023 | Q3 2023 | Q4 2023 | Q1 2024 | Q2 2024
 |  | 2019-01-01 00:00:00 |  | 2020-03-01 00:00:00 | 2024-06-28 00:00:00 | 42000
 |  | 2019-09-30 00:00:00 |  | 2020-06-30 00:00:00 |  | 68000
 |  |  | Yes
 |  |  | No
Initial Loan Requirement |  |  |  |  | Opening Bal
Property Value |  |  |  |  | [NAME]
Annuity Loan Profile on |  |  |  |  | [NAME]
Term |  |  |  |  | Closing LTV
Gross Rent
Interest p.a.
Service Charges & Costs - lessee
Profit before tax
Tax Payable (estimated) @
Total Interest, Expenses & Tax
Cashflow available pre Principal Repayments p.a.
Net Cashflow Available per above
Add back interest
Cashflow available for Debt Servicing
Cashflow after Debt Servicing
Gross Interest Cover
DSCR Pre Tax
DSCR Post Tax
Surplus Cashflow Available p.a. - pre tax
Surplus Cashflow Available p.a. - post tax
Tax Calculation
Rent
Expenses
Interest
Interest Dissalowed |  |  |  | 0
Capital Allowance |  |  |  | 0
Taxable Surplus
Tax Payable @
Rent Reserve
Opening reserve |  |  |  |  |  |  |  |  |  | 0
Surplus Cashflow Available p.a. - post tax
Cumulative reserve
Spreadsheet: f6c6050b-38e7-4099-bebc-7f6f3ab12124
Sheet: Sheet1

COURT OF CHANCERY COURTROOM CALENDAR FOR THE WEEK OF AUGUST 25, 2014 THROUGH AUGUST 29, 2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
TIME | CASE # | JUDGE | PROCEEDING | CASE CAPTION | SITE
Monday, August 25, 2014
10:00:00 | CA#1006-VCG | Vice Chancellor Glasscock | PI Hearing | [NAME] d/b/a M & D Bird World v. [NAME] | Georgetown
01:30:00 | CA#6611-VCG | Vice Chancellor Glasscock | Oral Argument | [NAME] [NAME] | Georgetown
Tuesday, August 26, 2014
09:30:00 | CA#9631-VCN | Vice Chancellor [NAME] | Default Judgment | Nationstar Mortgage LLC v. Adams | Dover
10:00:00 | CA#9597-MA | Master [NAME] | Hearing | Federal Home Loan v. [NAME]. | Dover
01:00:00 | CA#8972-VCG | Vice Chancellor Glasscock | Oral Argument | Horsey v. Horsey & Sons, Inc. | Georgetown
02:00:00 | CA#9766-VCL | Vice Chancellor [NAME] | Oral Argument | Cheniere Energy, Inc. | [NAME]
Wednesday, August 27, 2014
10:00:00 | CA#9355-VCL | Vice Chancellor [NAME] | Oral Argument | [NAME], et [NAME] Schlecht | [NAME]
02:00:00 | CA#7937-VCP | Vice Chancellor Parsons | Oral Argument | Kan-di-ki v. Suer | [NAME]
02:00:00 | CA#7480-VCL | Vice Chancellor [NAME] | Oral Argument | [NAME], L.L.C., et [NAME] Dowdy | [NAME]
Thursday, August 28, 2014
 | NO COURT HEARINGS SCHEDULED
Friday, August 29, 2014
10:00:00 | CA#9991-VCG | Vice Chancellor Glasscock | PI Hearing | Kahuku Holdings, LLC, et [NAME], v. MNA Kahuku, LLC | [NAME]
Spreadsheet: 854716d1704481443-formula-to-calculate-provisional-tax-correct-tax-file-sunboy-
Sheet: Sheet1

 | Kindly asking for excel formula to calculate estimated quartly using information on the profit and loss account
 | Please not that the 4th quarter is actual not estimated.
 | Profit and loss ACCOUNT
 |  | Estimated |  |  | Actual
 | Details | 1st QPD | 2nd QPD | 3rd QPD | 4th QPD
 | Sales | 10216 | 15796 | 21380.7 | 63981.39999999998
 | Expenses | 12607 | 19379.04 | 44457.78 | 71461.39333333334
 | Profit / (Loss)
 | Tax rate | 0.2472 | 0.2472 | 0.2472 | 0.2472
 | Tax payable
 | Estimated Annual Tax |  |  |  | -1849.054352000007
 | Desired solution
 |  |  |  | By [NAME] |  | Original amounts
 | QPD | Due (on or before) | Installment Due (as a % of the annual tax payable) | Amount
 | 1st QPD | 25th March | 0.1 |  |  | -236.42208
 | 2nd QPD | 25th June | 0.25 |  |  | -442.8637440000001
 |  | Shortfall or refund 1st Quarter |  |  |  | 59.27658239999997
 |  | Total Tax payable
 | 3rd QPD | 25th September | 0.3 |  |  | -2281.8616704
 |  | Shortfall or refund 2nd Quarter |  |  |  | -1281.5421504
 |  | Shortfall or refund 2nd Quarter
 | 4th QPD | 20th December | 0.35 |  |  | -647.1690232000024
 |  | Shortfall or refund 3rd Quarter |  |  |  | 2981.527733599996
 | Total Estimated Tax payable
 | Actual Tax for the year |  | 1
 | Check
Spreadsheet: mary_fischer__25625__1290
Sheet: E3.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 1290
ANALYSIS OF INVESTMENT IN UNCONSOLIDATED AFFILIATES, PARTNERSHIPS & JOINT VENTURES
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:  [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-3
 |  | CURRENT |  | BEGINNING BALANCE |  | EQUITY EARNINGS |  | CASH ACTIVITY - PAID / (RECEIVED) |  |  |  |  |  | NON-CASH ACTIVITY |  |  |  | ENDING BALANCE
NAME OF PARTNERSHIP , |  | % |  | @ 12/31/2000 |  | IN |  |  |  |  |  |  |  |  |  |  |  | @ 12/31/2001
SUBSIDIARY OR JOINT VENTURE |  | OWNED |  | DR / (CR) |  | UNCONSOL. SUB |  | ADVANCES |  | DISTRIBUTIONS |  | RETIREMENTS |  | AMOUNT |  | [NAME] |  | DR / (CR) |  | COMMENTS
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
 |  |  |  | * |  | ** |  |  |  |  |  |  |  |  |  |  |  | *
Total Investment
*  MUST TIE TO HYPERION TOT_INVEST_SUBS |  |  | Asset/Expense Accts:  DR/(CR)
** MUST TIE TO HYPERION TOT_EQEARN_OTH |  |  | Income Accts:  (DR)/CR |  |  | Reverse signs from Hyperion
 |  |  |  |  |  | Credit Positive Liability
 |  |  |  |  |  | Debit Negative Liability
Spreadsheet: 263577d1378542034-excel-2003-display-results-of-inventory-overall_inventory
Sheet: Switchboard

 | 1
1 | 2 | 3 | 4 | 7 | <<< the column numbers in the table on data
Item | Size | New | Used/worn | In Stock
Trousers | 30 / Short
Trousers | 30 / Short | <<< want this to show the next size down
Trousers | 30 / Short | <<< want this to show the next size down
Trousers | 30 / Short | <<< want this to show the next size down
Trousers | 30 / Short | etc.
Trousers | 30 / Short
Trousers | 30 / Short
Trousers | 30 / Short
Trousers | 30 / Short
Trousers | 30 / Short
Trousers | 30 / Short
Trousers | 30 / Short
Trousers | 30 / Short
Trousers | 30 / Short
Trousers | 30 / Short
Trousers | 30 / Short
Trousers | 30 / Short
Trousers | 30 / Short
Trousers | 30 / Short
Trousers | 30 / Short
Trousers | 30 / Short
Trousers | 30 / Short
Trousers | 30 / Short
Spreadsheet: 867592d1714422181-failed-if-function-pasta1-1-
Sheet: Planilha1 (2)

 |  |  |  |  |  |  | 15000 | 15000 | 15000
 |  | 10000 | 0 | 0 | 0 | 0
 |  | 15000 | 0 | 0 | 0 | 0 |  |  |  |  |  | How can I solve the SE formula when I don't
 |  | 10000 | 0 | 0 | 0 | 0 |  |  |  |  |  | there is no value in columns C and D the condition fails, the account is not realized correctly, it does not continue with the balance.
 |  | 0 | 30000 | 0 | 0 | 0 |  |  |  |  |  | Can you solve this problem?
 |  | 0 | 0 | 0 | 0 | 0 | 20000 | 20000
 |  | 0 | 5000 | 0 | 0 | 0
 |  | 50000 | 0 | 0 | 0 | 0 |  |  |  |  | Previous day's balance
 |  | 0 | 0 | 0 | 0 | 0 | 80000 | 80000 |  |  | On days when there are no transactions, I would like the balance to appear like this (without the formula)
 |  | 0 | 0 | 0 | 0 | 0 | 80000 | 80000
 |  | 15000 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | And when there's no movement, this is how it is, with zero
Spreadsheet: 454166d1459691581-can-we-merge-the-different-formula-into-one-book1example-3-
Sheet: Sales

 |  |  |  |  |  |  |  |  | Running Total
 |  |  |  |  |  |  |  |  | After Sales | Stock Bought
 | Sale orders |  |  |  |  | Opening Cost |  |  | Stock on Hand | Running Total
Order Number | [NAME] | Total Sold | Cost of Order |  |  |  |  |  |  | 40
1 | 200 |  | =40 x £1.12 plus 160 x £1 |  |  |  |  |  |  |  |  | Cost | Total Qty | Running Total
2 | 320 |  | =320 x £1 |  |  |  |  |  |  |  |  | 1.12 | 40
3 | 30 |  | =30 x £1 |  |  |  |  |  |  |  |  | 1 | 1000
4 | 400 |  | =400 x £1 |  |  |  |  |  |  |  |  | 2 | 1000
5 | 250 |  | =90 x £1 plus 160 x £2 |  |  |  |  |  |  |  |  | 2.2 | 1000
6 | 100 |  | =100 x £2 |  |  |  |  |  |  |  |  | 1 | 2000
7 | 400 |  | =400 x £2
8 | 240 |  | =240 x £2
9 | 240 |  | =100 x £2 plus 140 x £2.20
10 | 300 |  | =300 x £2.20
11 | 400 |  | =400 x £2.20
12 | 50 |  | =50 x £2.20
13 | 150 |  | =110 x £2.20 plus 40 x £1
Spreadsheet: 219683d1362875954-formula-for-total-entries-in-a-column-and-for-percentage-of-certain-value-arrests-and-sfsts-with-content
Sheet: Arrests

Date | Last | First | Race | Sex | DOB | Charge | Disposition Charge | Disposition | Report Number | Misd. Cite?
2013-01-02 00:00:00 | White | [NAME] | W | M | 1967-01-04 00:00:00 | DUI 1st |  | Conviction
2013-01-03 00:00:00 | [NAME] | [NAME] | W | M | 1976-01-04 00:00:00 | DUI 2nd |  | Conviction
2013-01-04 00:00:00 | Misfit | Tera | A | F | 2008-05-07 00:00:00 | Driving on Suspended |  | Conviction
2013-01-04 00:00:00 | Black | [NAME] | A | M | 1956-01-04 00:00:00 | DUI 3rd |  | Conviction
2013-01-06 00:00:00 | Blue | Stephen | B | M | 1944-01-03 00:00:00 | DUI 4th |  | Conviction
2013-01-07 00:00:00 | Red | Sara | I | F | 1978-04-06 00:00:00 | DUI 1st |  | Nolle prossed
Spreadsheet: 55967d1256126167-copy-of-invoice-using-macro-test
Sheet: .

1 | xyz shipping co | 45 street blgd 56 | ccccc | jjjj
2 | mnp shipping co | ddddd
3 | brb shipping co | hhhhh
4
5
6
7
8
9
10
11
12
13
14
15
16
Spreadsheet: 696268d1600736923-collating-multiple-tab-info-into-one-rj-projections_chrispq
Sheet: Supplier 3

Forecast Month | [NAME] (Product) | [NAME] (Number) | Container Number | Time to arrive (M) | Order Date | [NAME] | Container Cost (£) | Jan-20 | Feb-20 | Mar-20 | Apr-20 | May-20 | Jun-20 | [NAME] | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 | Jan-21 | Feb-21 | Mar-21 | Apr-21 | May-21 | [NAME] | [NAME] | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21
2021-02-01 00:00:00 | Product C | 2000 | 1 | -3 |  |  | 10000
2021-02-01 00:00:00 | Product C | 2000 | 1 | -3 |  |  | 20000
2021-05-01 00:00:00 | Product C | 2000 | 1 | -3 |  |  | 50000
2021-06-01 00:00:00 | Product C | 2000 | 1 | -3 |  |  | 40000
Spreadsheet: 721022d1614431136-need-help-to-remove-false-and-shorten-the-formula-sample-workbook-2-
Sheet: Costs

 |  | Supplies Cost | Facility Cost | Other Cost
Specialist Outpatient Clinic | Standard subsidised clinic (per attendance) | 33 | 10 | 20
Specialist Outpatient Clinic | High volume subsidised clinic (per attendance) | 1 | 1 | 1
Specialist Outpatient Clinic | Private clinic (per attendance) | 66 | 1 | 1
Inpatient Ward | Acute ward (per patient day) | 1 | 1 | 1
Inpatient Ward | Subacute ward (per patient day) | 1 | 1 | 1
Inpatient Ward | ICU/HD ward (per patient day) | 1 | 1 | 1
Operating Theatre | per procedure | 1 | 1 | 1
Operating Theatre | per session (4 hours) | 1 | 1 | 1
Endoscopy Room | per procedure | 1 | 1 | 1
Endoscopy Room | per session (4 hours) | 1 | 1 | 1
Spreadsheet: 817998d1676547256-formula-for-calculating-exact-days-coverage-for-montly-forecast-data-in-ms-excel-coverage-case
Sheet: Sheet1

 |  |  |  | Forecasts for Each Point
SKU | Stock in Had | Approximate Cover | Average Cover | 2023-02-12 00:00:00 | 2023-03-05 00:00:00 | 2023-04-02 00:00:00 | 2023-05-07 00:00:00 | 2023-06-04 00:00:00 | 2023-07-02 00:00:00 | 2023-08-06 00:00:00 | 2023-09-03 00:00:00 | 2023-10-01 00:00:00 | 2023-11-05 00:00:00 | 2023-12-03 00:00:00 | 2023-12-31 00:00:00 | 2024-02-04 00:00:00 | 2024-03-03 00:00:00 | 2024-03-31 00:00:00 | 2024-05-05 00:00:00 | 2024-06-02 00:00:00 | 2024-06-30 00:00:00 | 2024-08-04 00:00:00 | 2024-09-01 00:00:00
SKU 1 | 48093 |  |  | 4074.098 | 3262.677 | 3262.25 | 4078.773 | 3262.677 | 3262.25 | 4089.895 | 3639.709 | 4803.432 | 2753.933 | 2260.371 | 2014.599 | 2447.166 | 2456.396 | 2464.82 | 2472.524 | 2479.654 | 2486.354 | 1782.759 | 2942.677
SKU 2 | 20072 |  |  | 2291.502 | 2035.154 | 1911.948 | 2480.56 | 1672.656 | 1810.343 | 2668.165 | 1625.799 | 2533.281 | 1150.204 | 1438.263 | 2293.094 | 1686.441 | 1087.383 | 1952.485 | 2045.6 | 1642.771 | 1430.306 | 1776.085 | 1911.445
SKU 3 | 17980 |  |  | 2784.104 | 1645.942 | 1540.417 | 1763.786 | 1356.963 | 1441.89 | 1910.793 | 1334.334 | 2023.975 | 1682.922 | 1425.484 | 1992.951 | 1687.275 | 967.311 | 1449.595 | 1667.17 | 1443.11 | 1559.077 | 1784.515 | 1567.066
SKU 4 | 342 |  |  | 1926.978 | 1250.998 | 1354.789 | 1733.053 | 1485.242 | 1229.434 | 1668.052 | 1417.638 | 1538.683 | 1429.8 | 1566.6 | 1729.1 | 1885.1 | 1375.4 | 1452.5 | 2083.1 | 1489.5 | 1398.2 | 1942.2 | 1880
 |  |  | Days in incoming period
 | 1000 |  |  | 400 | 400 | 400
 |  |  | from 12/2 to 5/3 use 400.  600 left
 |  |  | from 5/3 to 2/4 use 400.  200 left
 |  |  | from 2/4/to 7/5 plan to use 400.
 |  |  | Cant.  Only have 200.
 |  |  | time period 2/4 to 7/5 = 35 days
 |  |  | 35*200/400 = 17.5
 |  |  | answer 2/4/23 + 17.5 d
Spreadsheet: 876805d1723532932-add-two-columns-for-all-combinations-add-for-combinations
Sheet: V1

 | Raw Data |  |  |  | Step 1 |  |  |  | Step 2 |  |  |  |  |  |  |  |  |  |  |  | Step 3
 | Here we have two sets of raw data (Column B ,Column D)  in ascending order |  |  |  | We extract the raw data that fulfill these conditions: |  |  |  | We add up the numbers in Column F and H for all possible combinations |  |  |  |  |  |  |  |  |  |  |  | We match all possible combinations from step 2 against specific numbers.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The formula in Column W returns the number if a match is found.
 |  |  |  |  | 1. Number < the maximum limit in the respective yellow cells
 |  |  |  |  | 2. Difference of (Succeeding Number - Number) >1
 |  |  |  |  | [NAME] for Column B |  | [NAME] for Column D
 |  |  |  |  | 30 |  | 50
 | 1 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No. to match | Return if exist in result per step 2
 | 3 |  | 6 |  | 3
 | 5 |  | 7 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 | 9 |  | 8 |  | 9 |  | 8 |  | 9 | 11 | 13 | 17 | 19 |  | 22 | 26 | 30 | 32 | 37 |  | 17
 | 11 |  | 10 |  | 11 |  | 10 |  | 11 | 13 | 15 | 19 | 21 |  | 24 | 28 | 32 | 34 | 39 |  | 23
 | 13 |  | 13 |  |  |  | 13 |  | 14 | 16 | 18 | 22 | 24 |  | 27 | 31 | 35 | 37 | 42 |  | 46
 | 14 |  | 17 |  | 14 |  | 17 |  | 18 | 20 | 22 | 26 | 28 |  | 31 | 35 | 39 | 41 | 46 |  | 54
 | 18 |  | 19 |  | 18 |  | 19 |  | 20 | 22 | 24 | 28 | 30 |  | 33 | 37 | 41 | 43 | 48 |  | 63
 | 22 |  | 21 |  | 22 |  | 21 |  | 22 | 24 | 26 | 30 | 32 |  | 35 | 39 | 43 | 45 | 50
 | 24 |  | 26 |  | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Final Result
 | 27 |  | 27 |  | 27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Is it possible to do it in one single formula?
 | 32 |  | 28 |  |  |  | 28 |  | 29 | 31 | 33 | 37 | 39 |  | 42 | 46 | 50 | 52 | 57
 | 33 |  | 32
 | 45 |  | 33 |  |  |  | 33 |  | 34 | 36 | 38 | 42 | 44 |  | 47 | 51 | 55 | 57 | 62
 | 48 |  | 37 |  |  |  | 37 |  | 38 | 40 | 42 | 46 | 48 |  | 51 | 55 | 59 | 61 | 66
 | 55 |  | 41 |  |  |  | 41 |  | 42 | 44 | 46 | 50 | 52 |  | 55 | 59 | 63 | 65 | 70
 | 56 |  | 43
 | 57 |  | 44 |  |  |  | 44 |  | 45 | 47 | 49 | 53 | 55 |  | 58 | 62 | 66 | 68 | 73
 | 61 |  | 52
Spreadsheet: 468122d1467132569-how-to-create-stacked-chart-from-a-pivot-table-book1
Sheet: Sheet3

Row Labels | Sum of Dollars
2015
Trade 1
Trade 2
Trade 3
Trade 4
Trade 5
2016 | -1272
Trade 1 | -1162
Trade 2 | 55
Trade 3 | -466
Trade 4 | -285
Trade 5 | 586
Grand Total
Spreadsheet: 271707d1382025177-if-function-for-a-wrap-time-sheet-wrap-time-sheet
Sheet: Rankings

WRAP TIME RANK
Agents | Rank | Points | TB | HEALTH | Increase/Decrease | January | PTS | Rank | February | PTS | Rank | March | PTS | Rank | April | PTS | Rank | May | PTS | Rank | June | PTS | Rank | NOVEMBER | PTS | Rank | NOVEMBER | PTS | Rank | NOVEMBER | PTS | Rank | NOVEMBER | PTS | Rank | NOVEMBER | PTS | Rank | NOVEMBER | PTS | Rank
[NAME]
Daine
Sheldon
Prass
[NAME]
Spreadsheet: 84355d1284403205-pivot-tables-for-multi-column-range-pivottableexample
Sheet: RoleList

[NAME]
Capture Manager
Color Team Reviewer
(blank)
(blank)
(blank)
Proposal Manager
(blank)
(blank)
(blank)
Proposal Writer
Color Team Reviewer
(blank)
(blank)
Senior Proposal Manager
Proposal Writer
Color Team Reviewer
(blank)
IMP/IMS SME
(blank)
(blank)
(blank)
(blank)
(blank)
(blank)
(blank)
(blank)
Deputy Capture Manager
Senior Proposal Manager
Proposal Writer
(blank)
(blank)
Senior Proposal Writer
IMP/IMS SME
Color Team Leader
Proposal Manager
(blank)
(blank)
(blank)
(blank)
Senior Proposal Manager
Proposal Writer
Color Team Leader
(blank)
(blank)
Color Team Reviewer
(blank)
(blank)
(blank)
(blank)
(blank)
Senior Proposal Writer
(blank)
(blank)
(blank)
(blank)
(blank)
(blank)
(blank)
(blank)
(blank)
(blank)
(blank)
(blank)
Spreadsheet: 818015d1676553485-vlookup-with-conditions-example
Sheet: Distribution

[NAME] | Validuntil | Key | House 1 | House 2 | House 3 | House 4 | House 5 | House 6 | House 1 % | House 2 % | House 3 % | House 4 % | House 5 % | House 6 %
2022-01-01 00:00:00 | 2022-06-01 00:00:00 | Person | 3 | 3 | 1 | 1 | 2 | 3
2022-01-01 00:00:00 | 2023-01-01 00:00:00 | Area | 100 | 150 | 80 | 80 | 200 | 170
2022-06-01 00:00:00 | 2022-12-01 00:00:00 | Person | 3 | 1 | 1 | 1 | 2 | 3
2022-12-01 00:00:00 |  | Person | 3 | 2 | 1 | 1 | 1 | 3
2023-01-01 00:00:00 |  | Area | 150 | 150 | 80 | 80 | 200 | 170
Spreadsheet: 87160d1287023610-sort-from-one-matrix-then-lookup-and-assign-corresponding-value-matrix-q
Sheet: Sheet1

3 month | 6 month | 9 month | 1 year |  |  |  |  |  | 3 month | 6 month | 9 month | 1 year
177 | 177 | 181 | 179 |  |  |  |  |  | 0.05 | 0.05 | 0.05007 | 0.05004
181 | 251 | 263 | 221 |  |  |  |  |  | 0.06 | 0.06002 | 0.0601 | 0.0595
290 | 296 | 296 | 289 |  |  |  |  |  | 0.07 | 0.0705 | 0.0705 | 0.0699
Remove row duplicates
3 month | 6 month | 9 month | 1 year
177 |  | 181 | 179
181 | 251 | 263 | 221
290 | 296 |  | 289
 |  |  |  |  | Days | Rate | Dup's Col Heading | Rate
 |  |  |  |  | 177 | 0.05 |  | 0.05
 |  |  |  |  | 179 | 0.05004 |  | 0.05004
 |  |  |  |  | 181 | 0.06 | 3 month | 0.05007
 |  |  |  |  | 181 | 0.05007 | 9 month | 0.05007
 |  |  |  |  | 221 | 0.0595 |  | 0.0595
 |  |  |  |  | 251 | 0.06002 |  | 0.06002
 |  |  |  |  | 263 | 0.0601 |  | 0.0601
 |  |  |  |  | 289 | 0.0699 |  | 0.0699
 |  |  |  |  | 290 | 0.07 |  | 0.07
 |  |  |  |  | 296 | 0.0705 |  | 0.0705
Spreadsheet: darrell_schoolcraft__7321__imball0202
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635
3531 | -336606 | -132491
60667 | -17 | -402073
60749 | 48196 | -22463
61206
61334 | -280092
62960
INDEX
2002-01-31 00:00:00 |  |  | 10496.07
2002-02-11 00:00:00
CBS Volume
2001-12-31 00:00:00 |  |  | 4346
Spreadsheet: 776959d1650023365-unwanted-gap-between-y-axis-and-line-of-data-new
Sheet: Blad1

 |  | Test
 | 0 | 0 |  |  |  |  |  |  | problem |  |  |  |  |  |  |  |  |  |  | solution
 | 1 | 0.5 |  |  |  |  |  |  | line chart |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 2 | 1 |  |  |  |  |  |  | axis lines meet in (-1, 0) creating a gap, |  |  |  |  |  |  |  |  |  |  | axis lines meet in (0, 0)
 | 3 | 1.5 |  |  |  |  |  |  | I thought the data line itself was at (1, 0) since axis values were not displayed. |  |  |  |  |  |  |  |  |  |  | used a type of scatter chart that makes it look like a line chart
 | 4 | 2
 | 5 | 2.5
 | 6 | 3
 | 7 | 3.5
 | 8 | 4
 | 9 | 4.5
 | 10 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | another solution
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | line chart, using data from only one column
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I set the "axis lines" to at "axis lines" instead of between, I displayed "axis lines" inwards on this chart so you know what I am referring to.
Spreadsheet: 61577d1262489374-changing-horizontal-to-vertical-references-workbook
Sheet: Monthly Summary

 | COSTCODE 44 STRUCTURES - NSS: CONCOURSE, F/BRIDGE, STAIRS
 |  |  |  | Monthly | Monthly | Monthly
 | Cost Code | Description | Budget | Actual accum. cost $ | Actual accum. concrete volume (m^3) | Overall production rate ($/m^3) |  |  | Daily cost table |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Accumulative cost table |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Accumulative concrete volume (m^3)
 | 44-100 | WPC94 Piling |  | 0 | 0 | 0 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Sum |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | 44-120 | WPC94 Concrete |  | 0 | 0 | 0 |  |  | 5 | 5 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 | 44-140 | WPC94 Structural Steel |  | 0 | 0 | 0 |  |  | 10 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 | 44-160 | WPC94 Pre Cast Concrete |  | 0 | 0 | 0 |  |  | 5 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 | 44-180 | WPC94 Foundation, Excavation and Backfill |  | 0 | 0 | 0 |  |  | 5 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 | 44-200 | WPC94 Metal Work |  | 0 | 0 | 0 |  |  | 5 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 | 44-220 | WPC94 Glazing |  | 0 | 0 | 0 |  |  | 5 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 | 44-240 | WPC94 Finishes |  | 0 | 0 | 0 |  |  | 5 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 | 44-260 | [NAME] and [NAME] |  | 0 | 0 | 0 |  |  | 5 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  | 5 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 | SUM |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | http://www.contextures.com/xlFunctions05.html