tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 727627d1617985797-summarizing-expenses-by-committee-data-sample-sumproduct
Sheet: Desired Output

Column from raw data worksheet: |  |  |  | (Column AB) | (Column AC) | (Column AD) | (Column AE) | (Column AF) | (Column AJ) | (Column AM)
 |  |  |  | Gate Contract | Security Patrols | Decals | Telephone | Security Cameras | R&M -  Guard House | R&M - Gates
Date | Payee | Invoice |  | 8012-000 | 8012-001 | 8013-001 | 8013-003 | 8013-004 | 8110-002 | 8110-011
2021-01-01 00:00:00 | Work Orders | 7
2021-01-01 00:00:00 | Good Enough Electronics | 10
2021-01-02 00:00:00 | Water Service | 11
2021-01-01 00:00:00 | Cleaning & Supply | 12
2021-01-06 00:00:00 | Good Enough Electronics | 16
2021-01-11 00:00:00 | Pest Elimination | 19
2021-01-11 00:00:00 | Phones | 20
2021-01-13 00:00:00 | Good Enough Electronics | 22
2021-01-14 00:00:00 | Good Enough Electronics | 24
2021-01-22 00:00:00 | Good Enough Electronics | 39
2021-01-22 00:00:00 | Good Enough Electronics | 40
2021-01-22 00:00:00 | Good Enough Electronics | 42
2021-01-26 00:00:00 | ABC Electronics Inc | 47
2021-01-26 00:00:00 | Recovery Services | 48
2021-01-27 00:00:00 | Good Enough Electronics | 54
2021-01-28 00:00:00 | Good Enough Electronics | 55
2021-01-28 00:00:00 | Allied | 57
2021-01-31 00:00:00 | Water Service | 59
2021-02-01 00:00:00 | Good Enough Electronics | 73
2021-02-02 00:00:00 | Allied | 78
2021-02-04 00:00:00 | Good Enough Electronics | 80
2021-02-08 00:00:00 | Security Patrols | 81
2021-02-08 00:00:00 | Credit card | 82
2021-02-10 00:00:00 | Good Enough Electronics | 86
2021-02-10 00:00:00 | Security Systems | 87
2021-02-11 00:00:00 | A/C Contractor | 89
2021-02-11 00:00:00 | Phones | 90
2021-02-12 00:00:00 | Good Enough Electronics | 92
2021-02-12 00:00:00 | PCLTD - refund | 93
2021-02-16 00:00:00 | Cleaning & Supply | 99
2021-02-16 00:00:00 | Pest Elimination | 100
2021-02-17 00:00:00 | Cleaning & Supply | 102
2021-02-22 00:00:00 | Water Service | 106
2021-02-23 00:00:00 | Good Enough Electronics | 107
2021-02-25 00:00:00 | Fire Master Chief | 118
2021-02-25 00:00:00 | Allied | 119
2021-02-25 00:00:00 | Allied | 120
2021-03-01 00:00:00 | Good Enough Electronics | 127
2021-03-02 00:00:00 | ABC Electronics Inc | 138
2021-03-04 00:00:00 | Security Patrols | 139
2021-03-11 00:00:00 | Phones | 145
2021-03-19 00:00:00 | Doors Inc | 152
2021-03-22 00:00:00 | Water Service | 158
2021-03-23 00:00:00 | Pest Elimination | 159
2021-03-25 00:00:00 | Allied | 160
2021-03-25 00:00:00 | Allied | 161
2021-03-25 00:00:00 | Good Enough Electronics | 163
2021-03-31 00:00:00 | Water Service | 181
2021-04-01 00:00:00 | Cleaning Services, Inc | 184
2021-04-01 00:00:00 | Good Enough Electronics | 185
2021-04-06 00:00:00 | Security Patrols | 188
Spreadsheet: 848982d1699559052-vlook-up-from-pivot-sheet-on-two-condition-sample-file
Sheet: Pivot

Sum of Qua A | Column Labels
Row Labels | P1 | S1 | S2 | Grand Total
Apple | 133 | 143 | 133 | 409
Kiwi | 1279 | 214 |  | 1493
Orange | 132 |  | 414 | 546
Grand Total | 1544 | 357 | 547 | 2448
Spreadsheet: 112656d1308707402-cash-flow-pivot-table-cash-flow-example
Sheet: TransactionTable

Account | Date | Amount | Description | Class | AccountInfo | RefDate
2002 | 2011-01-12 00:00:00 | -8048 | Description 17 | SX
2007 | 2011-01-19 00:00:00 | -2988 | Description 5 | CC
2016 | 2011-01-21 00:00:00 | -7900 | Description 6 | OS
Balance Adjustment | 2011-02-11 00:00:00 | 200000
2007 | 2011-03-10 00:00:00 | -2306 | Description 10 | JP
1005 | 2011-03-25 00:00:00 | 13605 | Description 12 | WA
2010 | 2011-04-09 00:00:00 | -9337 | Description 8 | OS
2016 | 2011-06-11 00:00:00 | -4496 | Description 9 | WA
2015 | 2011-06-14 00:00:00 | -1381 | Description 4 | EQ
2015 | 2011-06-15 00:00:00 | -7614 | Description 1 | IC
2001 | 2011-07-18 00:00:00 | -9257 | Description 2 | SC
2006 | 2011-07-26 00:00:00 | -3042 | Description 19 | SX
1018 | 2011-08-04 00:00:00 | 19947 | Description 3 | SX
2005 | 2011-08-22 00:00:00 | -9425 | Description 13 | CC
1013 | 2011-09-19 00:00:00 | 16068 | Description 11 | IC
2005 | 2011-09-23 00:00:00 | -7832 | Description 14 | WA
1019 | 2011-09-26 00:00:00 | 12309 | Description 7 | OS
2019 | 2011-09-30 00:00:00 | -4538 | Description 15 | EQ
1004 | 2011-10-14 00:00:00 | 15650 | Description 16 | JP
2010 | 2011-12-20 00:00:00 | -2341 | Description 18 | SC
Spreadsheet: 884244d1733327108-work-out-fee-if-showing-card-test
Sheet: Sheet1

 |  |  |  | List Price | QTY | Total Sales | Card or Cash | Fee |  | To Pay
 |  |  |  | 20 | 1 |  | Card
 |  |  |  | 9 | 1 |  | Cash
 |  |  |  | 9 | 1 |  | card
 |  |  |  | 20 | 1 |  | card | 0.4
 |  |  |  | 9 | 1 |  | cash
 |  |  |  | 9 | 1 |  | card | 0.23
Spreadsheet: 844567d1696343479-hi-i-need-a-few-things-adding-or-changing-on-this-fishing-results-workbook-please-golborne-results-2024
Sheet: Interim

Rank | Points |  | Events |  | Last Meeting | Previous meeting |  | Members | Interim weight results | Interim total points | Rank [NAME]
1 | 13 |  | 1 |  |  |  |  | [NAME]
2 | 12 |  | 2 |  |  |  |  | [NAME]
3 | 11 |  | 3 |  |  |  |  | Martyn Mawer
4 | 10 |  | 4 |  |  |  |  | [NAME]
5 | 9 |  |  |  |  |  |  | [NAME]
6 | 8 |  |  |  |  |  |  | [NAME]
7 | 7 |  |  |  |  |  |  | [NAME]
8 | 6 |  |  |  |  |  |  | [NAME]
9 | 5 |  |  |  |  |  |  | [NAME]
10 | 4 |  |  |  |  |  |  | [NAME]
11 | 3 |  |  |  |  |  |  | [NAME]
12 | 2 |  |  |  |  |  |  | [NAME]
13 | 1 |  |  |  |  |  |  | [NAME]
14 | 0
Spreadsheet: 60020d1260538134-sending-data-from-input-sheet-to-other-sheets-in-a-workbook-copy-of-poss-new-budget-planner
Sheet: EDF Energy

EDF Energy | (Gas & Electric)
MONTH | Year | Paymet
2008-01-01 00:00:00 | 2008
2008-02-01 00:00:00 | 2008
2008-03-01 00:00:00 | 2008
2008-04-01 00:00:00 | 2008
2008-05-01 00:00:00 | 2008
2008-06-01 00:00:00 | 2008
2008-07-01 00:00:00 | 2008
2008-08-01 00:00:00 | 2008
2008-09-01 00:00:00 | 2008
2008-10-01 00:00:00 | 2008
2008-11-01 00:00:00 | 2008
2008-12-01 00:00:00 | 2008
2009-01-01 00:00:00 | 2009
2009-02-01 00:00:00 | 2009
2009-03-01 00:00:00 | 2009 | 130
2009-04-01 00:00:00 | 2009 | 108
2009-05-01 00:00:00 | 2009 | 108
2009-06-01 00:00:00 | 2009 | 108
2009-07-01 00:00:00 | 2009 | 108
2009-08-01 00:00:00 | 2009 | 108
2009-09-01 00:00:00 | 2009 | 108
2009-10-01 00:00:00 | 2009
2009-11-01 00:00:00 | 2009
2009-12-01 00:00:00 | 2009
2010-01-01 00:00:00 | 2010
2010-02-01 00:00:00 | 2010
2010-03-01 00:00:00 | 2010
2010-04-01 00:00:00 | 2010
2010-05-01 00:00:00 | 2010
2010-06-01 00:00:00 | 2010
2010-07-01 00:00:00 | 2010
2010-08-01 00:00:00 | 2010
2010-09-01 00:00:00 | 2010
2010-10-01 00:00:00 | 2010
2010-11-01 00:00:00 | 2010
2010-12-01 00:00:00 | 2010
Spreadsheet: 137654d1327301675-displaying-results-based-on-combo-box-value-excel-2010-excel-combobox
Sheet: Sheet1

Name | Occupation | Salary | Gender
[NAME] | Manager | 4650 | M
[NAME] | Staff | 3400 | M
George | [NAME] | 3000 | M
Dennis | [NAME] | 3010 | M
Mandy | Staff | 3030 | F |  |  |  | If let's say I choose Gender "F"  and "Staff", it should give me two list of the results.
Demi | Staff | 3300 | F |  |  |  | how do I do this?
Display Outputs:
Name | Occupation | Salary | Gender
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | F
Spreadsheet: 824328d1680508244-calculating-an-amount-to-withhold-from-paycheck-deduction-calculator-ans2-1-
Sheet: Sheet1

The rates of Shortages applicable are as follows:
RATES OF NORMAL SHORTAGES FOR INDIVIDUALS
Exceeds | Does not exceed |  |  |  |  |  |  | 450
Shortages |  | Fixed Deduction | Rate on Excess | Rates
 |  |  |  |  |  |  | Verify
0 | 200 | 200 | 0 | E200 + 0% of the excess of 0 |  |  | 0
201 | 250 |  | 0.09 | E200 + 0% of the excess of 200
 | 300 |  | 0.08 | E200 + 0% of the excess of 250
 | 350 |  | 0.07 | E200 + 0% of the excess of 300
 | 400 |  | 0.06 | E200 + 0% of the excess of 350
 | 450 |  | 0.05 | E200 + 0% of the excess of 400
 | 500 |  | 0.04 | E200 + 0% of the excess of 450
 | 550 |  | 0.03 | E200 + 0% of the excess of 500
 |  |  | 0.02 | E200 + 0% of the excess of 550
Examples
Shortage | Deduction Calculator
 | Fixed Deduction per Table | Excess | Rate on excess |  | Expected Deduction
200 |  |  | 0 |  | 200
250 | 220 |  | 0.09
350 | 240 |  | 0.06
450 | 260 |  | 0.04
550 | 280 |  | 0.02
Spreadsheet: 183386d1348813720-re-transfering-data-from-one-page-to-another-in-a-particular-format-easily-drawing-budget-quote-2012-example
Sheet: Sheet1

 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | `
Production Use Only |  | Tax Invoice No. |  |  | Completed Inv. Date
Invoice Details
Job Number: |  | 0
Dealer ID
 |  | Client Information.
Job Description
Date: |  |  |  |  |  |  |  | 0
Proposal / Quote No:
Client / Organisation: |  |  |  |  |  |  |  |  | Please ensure this is the exact and accurate spelling of Client Organisation.
Client ABN.
Project name:
Contact:
Postal Address:
City:
State & Post Code:
Phone:
Mobile:
FAX:
E-mail address:
Site Location:
Site Address:
Site Contact:
Site Contact Mobile:
Playscape Designer
Project Type |  | White |  |  |  |  | White
Project Status
NOTES:
Spreadsheet: 1fe98130-b1a4-471d-85f9-88d59326acaf
Sheet: 8c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Basis | 6 | 3 | 7 | 29 | 41 | 49 | 71 | 10 | 216
Cap/Floor | 22 | 2 | 11 | 22 | 80 | 22 | 2 | 0 | 161
Debt Option | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Exotic | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fixed-Fixed | 8 | 0 | 0 | 0 | 3 | 1 | 2 | 0 | 14
Fixed-Float | 323 | 100 | 378 | 1706 | 7242 | 14191 | 11278 | 4432 | 39650
FRA | 112 | 371 | 798 | 449 | 11 | 0 | 0 | 0 | 1741
Inflation | 7 | 0 | 10 | 10 | 88 | 53 | 47 | 4 | 219
OIS | 40 | 51 | 62 | 45 | 74 | 30 | 4 | 1 | 307
Swaption | 0 | 0 | 7 | 73 | 265 | 198 | 443 | 78 | 1064
TOTAL
Spreadsheet: 220151d1363084935-if-if-greater-not-working-staff-requirements
Sheet: Staff

Tool | Staff
Spreadsheet: 756644d1637681199-modifying-an-if-formula-to-exclude-fields-with-a-certain-criteria-book1
Sheet: Sheet1

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 | TOTAL
 | 6 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 6 |  | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6
 | 1 | 1 | 2 | 2 |  |  | 2 | 1 | A | 2 | A |  |  | A | A | 2 | 1 |  | 1 |  |  | B | B | B | B | B |  |  | 1
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 | TOTAL
 | 6 | 8 | 4 | 8 |  |  | 4 | 8 | 4 | 8 | 4 |  |  | 4 | 4 | 8 | 6 |  | 4 |  |  | 6 | 6 | 4 | 6 | 4 |  |  | 4
 | 1 | 1 | 2 | 2 |  |  | 2 | 1 | A | 2 | A |  |  | A | A | 2 | 1 |  | 1 |  |  | B | B | B | B | B |  |  | 1
Spreadsheet: 220329d1363121293-how-to-display-string-in-different-ways-according-to-conditions-book1-v2
Sheet: Sheet1

 |  |  |  |  |  |  | The Summary Table |  |  |  |  | original formula
The Pivot Table |  |  |  |  |  |  | Base Field No | Base Sum | VAT Field No | [NAME] |  | adjusted for credit check rules
Tax code Name correct if Credit Note | VAT Return Form Base Field Number | [NAME] Number | Sum of Net | Sum of VAT | Sum of Gross
BE|AP| Bank Charge VAT (21%) | 82 | 59 | 82.64 | 17.35 | 99.99 |  | 81 |  | 55
BE|AP| Various goods/services CoContract Reverse Charge - 21% | 82,87 | 56,59 | 468.02 | 0 | 468.02 |  | 82 |  | 59
BE|AP|Investments - 21% - 75% ded | 83 | 59 | 0 | 144.38 | 144.38 |  | 83 |  | 61
BE|AP|Trade goods - 6% | 81 | 59 | 82.64 | 4.96 | 87.6 |  | 84 |  | 62
BE|AP|Trade goods - EU Acq. - 21% | 81,86 | 55,59 | 100 | 0 | 100 |  | 85 |  | 63
BE|AP|Various goods/services - 21% - 100% ded | 82 | 59 | 82.64 | 17.36 | 100 |  | 86 |  | 82
BE|AP|Various goods/services - 21% - 35% ded | 82 | 59 | 93.15 | 6.85 | 100 |  | 87 |  | 84
BE|AP|Various services  by a EU established service provider - 21% - 100% ded - credit note | -82,84,-88 | 61,62* | 82.64 | -17.35 | -99.99 |  | 88 |  | 86
BE|AP|Various services by a EU established service provider - 21% - 100% ded | 82,88 | 55,59 | 82.64 | 17.36 | 100
BE|AP|Various goods/services - 21% - 100% ded - credit note | -82,85 | 63 | 413.22 | -86.78 | -500
BE|AP|Capitalised services by a non-EU established service provider - 21% - 100% ded - credit note | -83,85,-87 | 61,62* | -82.64 | -17.36 | -100
BE|AP|Various goods - EU Acq. - 21% - 0% ded - credit note | -82, 84, -86 | 59 | 330.59 | 0 | -330.59
BE|AP|Various goods/services - 6% - 0% ded - credit note | -82,85 | n/a | 0 | -69.41 | -69.41
Grand Total |  |  | 82.63999999999993 | 17.36000000000003 | 100 |  |  |  |  |  |  |  |  |  | aa | aa,bb | -100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | aa | aa | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c | c | -100
 |  |  |  |  |  |  |  |  |  |  | check - this should be the sum total for box 82 = -17.36 |  |  |  | d | d | -100
 |  |  |  |  |  |  |  |  |  |  | -330.59 |  |  |  | e | e
 |  |  |  |  |  |  |  |  |  |  | -413.22
 |  |  |  |  |  |  |  |  |  |  | 82.64
 |  |  |  |  |  |  |  |  |  |  | 468.02
 |  |  |  |  |  |  |  |  |  |  | 82.64
 |  |  |  |  |  |  |  |  |  |  | 93.15
 |  |  |  |  |  |  |  |  |  |  | -82.64
 |  |  |  |  |  |  |  |  |  |  | 82.64
Spreadsheet: 858065d1706836053-totaling-a-row-if-a-number-doesnt-apply-hours-tally
Sheet: Sheet1

2024-01-01 00:00:00
freelancer | hourly rate | hours worked | total billed | upwork fee % | Total | total with Upwork fee
Jeremy
[NAME] | 40 | 3
[NAME] | 35 | 7 |  | 1.2
Adan | 10 | 2 |  | 1.2
[NAME]
Julia |  |  |  | 1.2
Exur | 14.1 | 10 |  | 1.2
Spreadsheet: mary_fischer__25624__31X
Sheet: E2.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031X
COMPANY NAME     Harper Investment Company
ANALYSIS OF OTHER CURRENT ASSETS
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:
EXTENSION: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-2
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
Hyperion Line 0189 - Fair Value Investment (current)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Total Current Assets | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 195
Asset/Expense Accts:  DR/(CR)
Spreadsheet: 794148d1661897924-fix-formula-to-get-unique-op-from-multiple-rows-unique-row-op
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Unique |  | Correct OP |  |  |  | All unique OP's
A1 | B1 | C1 | A2 | B2 | C2 | A3 | B3 | [NAME] | A4 |  |  | A1 |  |  |  |  | <<----
B2 | [NAME] | A1 | B3 | C4 | A2 | B4 | C5 | A3 | B5 |  |  | B2 |  |  |  | B1
A2 | B2 | B3 | A3 | B4 | B5 | A4 | B6 | B7 | A5 |  |  | A2 |  |  |  | C1
A3 | B4 | C5 | A4 | B5 | C6 | A5 | B6 | C7 | A6 |  |  | A3 |  |  |  | A2
A1 | B3 | C4 | A2 | B4 | C5 | A3 | B5 | C6 | A4 |  |  | B3 | B3 is correct because [NAME] is already above |  |  | B2
B1 | C2 | A2 | B2 | [NAME] | A3 | B3 | C4 | A4 | B4 |  |  | B1 |  |  |  | C2
C1 | B2 | A3 | C2 | B3 | A4 | [NAME] | B4 | A5 | C4 |  |  | C2 | C2 is correct because B2 is already above |  |  | A3
B2 | C2 | D2 | B3 | [NAME] | D3 | B4 | C4 | D4 | B5 |  |  | D2 |  |  |  | B3
A1 | D1 | B2 | A2 | D2 | B3 | A3 | D3 | B4 | AC1 |  |  | D1 |  |  |  | [NAME]
D1 | B1 | C2 | D2 | B2 | [NAME] | D3 | B3 | C4 | D4 |  |  | D2 |  |  |  | A4
A3 | B2 | D2 | A4 | B3 | D3 | A5 | B4 | D4 | A6 |  |  | A4 |  |  |  | C4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C5
 |  |  |  |  |  |  |  |  |  |  |  |  | Why is C1 not correect here? |  |  | B5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AC1
Spreadsheet: db5dbb34-76ac-4e86-8969-88bb397a91a1
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8547 | 23989 | Chantal | [NAME] | CAN | 24 | 00:15:27 | 00:06:41 | 00:31:55 | [NAME] | [NAME] | 1 | [NAME]
8547 | 42906 | [NAME] | [NAME] | CAN | 22 | 00:15:24 | 00:06:31 | 00:30:57 | 00:01:08 | 00:22:25 | 2 | 01:16:29
8547 | 61511 | Ngan | Oickle | CAN | 23 | 00:19:11 | 00:07:33 | 00:35:58 | 00:00:41 | 00:26:11 | 3 | 01:29:36
8547 | 60948 | [NAME] | Cawthon | USA | 21 | 00:18:57 | 00:04:40 | 00:37:49 | 00:01:18 | [NAME] | 4 | 01:30:38
Spreadsheet: 290192d1389809195-updating-a-value-to-alter-all-other-values-used-in-a-fix-sum-cpex_winon
Sheet: Sheet1

Wk1 | Wk2 | Wk3 | Wk4 | Total |  | Target
25 | 25 | 25 | 25 | 100 |  | 100
40 | 20 | 20 | 20 | 100
20 | 26.66666666666667 | 26.66666666666667 | 26.66666666666667 | 100
30 | 23.33333333333333 | 23.33333333333333 | 23.33333333333333 | 99.99999999999999
35 | 21.66666666666667 | 21.66666666666667 | 21.66666666666667 | 100
25 | 25 | 25 | 25 | 100
45 | 18.33333333333333 | 18.33333333333333 | 18.33333333333333 | 99.99999999999999
Spreadsheet: 833146d1686816684-power-query-how-to-get-prev-months-value-how-to-get-prev-months-value-pq-example-spreadsheet
Sheet: Sheet1

 | Row Labels | Stock Level | Stock Change
 | Mar
 | Bag | 137 | 137
 | Barrel | 8 | 8
 | Bottle | 22 | 22
 | Box | 152 | 152
 | Crate | 54 | 54
 | Grand Total | 373 | 373
Spreadsheet: 215548d1361404726-order-form-worksheet-populated-sequentially-with-items-selected-from-other-worksheets-ef360_sample
Sheet: Order Form

SKU | CAT # | [NAME] | PRICE |  |  |  |  | Sheet | row |  |  | 0 | <-- Must be zero
 |  |  |  |  | <-- Auto adjusts - click/ |  |  |  |  |  | Fluorescent
 |  |  |  |  | [NAME] on |  |  |  |  |  | LED
 |  |  |  |  | other sheets |  |  |  |  |  |  |  | <-- Add more sheet names
 |  |  |  |  |  |  |  |  |  |  |  |  | if needed - copy formula
 |  |  |  |  |  |  |  |  |  |  |  |  | down column M
 |  |  |  |  |  |  |  |  |  | <-- Formulae copied
 |  |  |  |  |  |  |  |  |  | down to row 15 - copy
 |  |  |  |  |  |  |  |  |  | further if needed
 |  |  |  |  |  |  |  | ^ | ^
 |  |  |  |  |  |  |  | Helper columns - can
 |  |  |  |  |  |  |  | be hidden if needed
Spreadsheet: 779483d1651809070-xirr-function-with-relative-references-irr-test
Sheet: Blind Pool Curve

 | Assumptions
 | Final Period | 30
x | Period |  |  |  |  |  |  |  | 0
 | Date |  |  |  |  |  |  |  | 2022-12-31 00:00:00
 | Years |  |  |  |  |  |  |  | 0
 | Year Frac
 | Net Cash Flows |  |  |  |  |  |  |  |  | -7.412150591485839 | -8.204502799683903 | -8.940760256713833 | -9.592035564759794 | -10.13120865413664 | -10.53479012607987 | -7.310086585075592 | -7.045716359151937 | -6.593533625595561 | -5.958679068181678 | -5.154175813034191 | -4.200059020887041 | -3.122019354989543 | -1.9497005827237 | -0.7148208666152085 | 0.5507051393050526 | 1.81648013252328 | 3.055042527225306 | 4.24290195454883 | 5.361153735738736 | 6.395681607995442 | 7.336997777629609 | 8.17979754266153 | 8.922320518425654 | 9.565612318955468 | 10.11277152623927 | 10.56825014382912 | 10.93725510250409 | 11.22527716068272 | 11.43775443954246 | 11.57986264897581 | 11.65641363094198 | 11.67183816757109 | 11.63022745135588 | 11.53540921339485 | 11.39103815391896 | 11.2006849883641 | 10.96791327411473 | 10.7023024271624 | 10.39330681443477 | 10.05388270225672 | 9.687627185591907 | 9.29832148539706 | 8.88986641899917 | 8.466218055896613 | 8.031325022931732 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | IRR |  |  |  | << this calculates the IRR over the entire forecast period
 | IRR over specific period |  |  |  | << would like this to calculate the irr from the beginning to a specified period, such as T-0 to T-25
 | Period Start | 15 |  |  | Note: if possible, it would be really cool to be able to specify both a starting period and an ending period, ie not necessarily starting at T-0
 | Period End
 |  |  |  | Here are some things I tried
 |  |  |  | =+XIRR(CELL("address",K10)&":"&CELL("address",SUBSTITUTE(ADDRESS(1,COLUMN(K10)+C3,4),"1","")&ROW(K10)),CQ45,P26:CQ26)
Spreadsheet: 5e68cce7-413c-4937-be1b-7858332c4adb
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FDIRU | Test | FDIRU | Diuretic Screen, [NAME] | Diuretic Screen, [NAME] | High Performance Liquid Chromatography with Ultraviolet Detection; (HPLC-UV) | Plastic, 10 mL urine tube |  |  |  |  | 10 mL aliquot of random or spot urine collected without preservative in a plastic container. Send specimen refrigerated. | 1.2 mL | Hemolysis	NA Thawing	Cold OK; Warm OK Lipemia	NA Icteric	NA Other	NA | Qualitative diuretic screen includes: benzthiazide, bumetanide, chlorothiazide, chlorthalidone, furosemide, hydrochlorothiazide, hydroflumethiazide, and metolazone.   Test Performed By:  Medtox Laboratories                                402 W. County Road D                                St. Paul, MN  55112 |  | 5 days | 7 - 9 days | 1 | 82486 |  |  |  |  | Medtox Laboratories, Inc.
FDIRU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 14 days
FDIRU | Result | Z2593 | Diuretic Screen | Diuretic Screen | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FDIRU | Result | Z2594 | Benzthiazide | Benzthiazide | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FDIRU | Result | Z2595 | Bumetanide | Bumetanide | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FDIRU | Result | Z2596 | Chlorothiazide | Chlorothiazide | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FDIRU | Result | Z2597 | Chlorthalidone | Chlorthalidone | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FDIRU | Result | Z2598 | Furosemide | Furosemide | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FDIRU | Result | Z2599 | Hydrochlorothiazide | Hydrochlorothiazide | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FDIRU | Result | Z2600 | Hydroflumethiazide | Hydroflumethiazide | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FDIRU | Result | Z2601 | Metolazone | Metolazone | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 761210d1640722400-gantt-chart-scheduling-assist-scheduling-assist
Sheet: Sheet1

 | 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
September
October
November
December
January
February
March
April
May
June
July
August
 |  | Reminder Checkbox
 |  | Event |  |  | Start Date |  |  |  |  | End Date
 |  | Event 1
 |  | Event 2
 |  | Event 3
 |  | Event 4
 |  | Event 5
 |  | Event 6
 |  | Event 7
 |  | Event 8
 |  | Event 9
 |  | Event 10
 |  | Event 11
Spreadsheet: 127279d1320267701-excel-2007-how-to-extract-items-from-spreadsheet-book2
Sheet: Sheet1

From | To | Info1 | Info2
[PHONE] | [PHONE] | a | aa
[PHONE] | [PHONE] | b | bb
[PHONE] | [PHONE] | c | cc
[PHONE] | [PHONE] | d | dd
[PHONE] | [PHONE] | e | ee
[PHONE] | [PHONE] | f | ff
[PHONE] | [PHONE] | g | gg
[PHONE] | [PHONE] | h | hh
[PHONE] | [PHONE] | i | ii
[PHONE] | [PHONE] | j | jj
[PHONE] | [PHONE] | k | kk
[PHONE] | [PHONE] | l | ll
[PHONE] | [PHONE] | m | [NAME]
[PHONE] | [PHONE] | n | nn