tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 92323d1291915104-calculate-pro-rata-share-of-two-variables-wealthistime-allocate-profits-to-investors-challenge
Sheet: HowMuch

HOW MUCH SHOULD EACH INVESTOR GET?
Assume disbursements are only made once per year, after the year has ended
(All user input fields (variables) are in pink)
STEP 1: Capital Share |  |  |  | STEP 2: Time of Capital Invested |  |  |  |  | STEP 3: How much should each Investor Get?
 | Capital Contribution | % of Total Capital Contributed by Each Member |  |  | Date of Capital Contribution | # Days Capital Contribution Vested | % of Of the Year Contribution Vested |  |  | [NAME] of Year Total Payout | Total End of Year Earnings
[NAME] | 75000 |  |  | [NAME] | 2011-01-01 00:00:00 |  |  |  | [NAME] |  | 20000
[NAME] | 25000 |  |  | [NAME] | 2011-07-01 00:00:00 |  |  |  | [NAME]
Total Contributions |  |  |  | Total Days of Vested Contributions |  | 365
MY INITIAL TRAIN OF THOUGHT: This is what I started with, but it is not correct. If you set the [NAME] all equal, and the Capital Contribution as I have done below, you will see that Investor A gets 8.3k. But he contributed 50% of the total capital...so he should be getting 10k (assuming they all invested at the same time). Clearly I lack the math skills to do this computation properly.
 | Capital Contribution | % of Total Capital Contributed by Each Member | Capital Payout Factor |  | Date of Capital Contribution | # Days Capital Contribution Vested | % of Total Days Vested by Each Member | Time Payout Factor |  | End of Year Total Payout | Total End of Year Earnings
Investor A | 100000 |  |  |  | 2011-01-01 00:00:00 |  |  |  |  |  | 20000
Investor B | 50000 |  |  |  | 2011-01-01 00:00:00
Investor C | 50000 |  |  |  | 2011-01-01 00:00:00
Total Contributions |  |  |  |  | Total Days of Vested Contributions
Spreadsheet: 47254d1246249427-list-displaying-data-in-multiple-cells-based-on-list-selection-multiple-array
Sheet: Ranges & Labes Names

Labes/Ranges Names
_350_BBS
_750_Grenade_Launchers
_1_Billion_in_Cash
_350_Grenade_Launchers
_350_EXO_Suits
_750_Speed_Round_tokens
_7500_Punk_Cards
_750_Recruits
_1500_Recruits
_2000_Ghetto_Lotto_Tickets
_150_Arch_Angel_Liquid_Metal_Prototypes
_150_RPG's
_2000_Flash_Bombs
_1500_Multi-Head_Pipe_Bombs
_Increase_Hustla_Limit_for_All_Blocks
_Increase_Bookie_Limit_for_All_Blocks
_Increase_Pimp_Limit_for_All_Blocks
_Increase_Balla_Limit_for_All_Blocks
_4500_Recruits
_Level_Up_Ballas_To_the_Next_Level
_Level_Up_Pimp_To_the_Next_Level
_Level_Up_Bookie_To_the_Next_Level
_Level_Up_Hustla_To_the_Next_Level
_Level_Up_Sentinel_To_the_Next_Level
_Level_Up_Killa_To_the_Next_Level
_Level_Up_Stick-Up_Kids_To_the_Next_Level
_Increase_Worker_Count_on_All_Blocks_(x2)
Spreadsheet: 708507d1607883393-buy-sold-in-formula-s-portfolio
Sheet: Portfolio

 | Currency | Token | Future price |  | Quantity |  | Ratio |  | Buying price | Paid |  | Market value | ROI |  | Profit/Loss | Margin |  | Hold
 | Bitcoin | BTC | 50000 |  |  |  |  | 0.2 | 3000 |  |  |  |  |  |  |  |  | Few/Several years
 | Ripple | XRP | 4 |  |  |  |  | 0.3 | 0.08 |  |  |  |  |  |  |  |  | Long time. How long?
 | Ethereum | ETH | 2600 |  |  |  |  | 0.2 | 185 |  |  |  |  |  |  |  |  | Long time. How long?
 | Chainlink | LINK | 30 |  |  |  |  | 0.1 | 3 |  |  |  |  |  |  |  |  | ? |  |  | Based on Ethereum. Bridge between IoT devices and [NAME]. [NAME].
 | Cardano | ADA | 1.5 |  |  |  |  | 0.04 | 0.04 |  |  |  |  |  |  |  |  | ? |  |  | Co-fouder [NAME]. Evolved from scientific and research driven. Own blockchain. De nieuwe Etherium?
 | VeChain | VET | 0.03 |  |  |  |  | 0.04 | 0.007 |  |  |  |  |  |  |  |  | ? |  |  | Business focust. Bridge between real world and blockchain. Economy, Government model. IoT integration. Tracking products.
 | Reserve Rights | RSR | 0.035 |  |  |  |  | 0.03 | 0.002 |  |  |  |  |  |  |  |  | ? |  |  | Stablecoin. Cryptocurrency takover over fiat money. Immortality compared to alternatives.
 | Stellar | XLM | 0.6 |  |  |  |  | 0.03 | 0.007 |  |  |  |  |  |  |  |  | ? |  |  | Co-founder [NAME]. IBM partnership. Kind of a digital bank.
 | SingularityNET | AGI | 2 |  |  |  |  | 0.03 | 0.01 |  |  |  |  |  |  |  |  | Very long. How long?
 | Algorand | ALGO | 2.25 |  |  |  |  | 0.03 | 0.09 |  |  |  |  |  |  |  |  | Very long. How long?
 |  |  |  |  |  |  |  | ***
 |  |  |  |  |  |  |  | 100% total |  |  |  | Equity | ROI |  | Net Profit | Margin |  | Withdrawn |  | Margin
 | Profit chart |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | ROI chart
Spreadsheet: 29563d1224619639-vlookup-formula-only-returns-ref-or-n-a-test-inventory-tool
Sheet: syn

Account: Account Name | Account: Billing City | Product | Serial Number | Warranty Expiration Date
Pure Med Spa - - St. Catherines | St. Catherines | Comet System | 1336 | 2010-11-04 00:00:00
 |  | DSL Applicator | LS0015858 | (blank)
Pure Med Spa - Alderwood | Lynwood | VelaShape System | U08121078 | 2011-05-12 00:00:00
 |  | Vshape small applicator (Contour) | U08100331 | 2009-06-16 00:00:00
 |  | [NAME] large applicator (Vsmooth) | U05531271 | 2011-05-12 00:00:00
Pure Med Spa - Alpharetta | Alpharetta | VelaShape System | U08100154 | 2009-05-12 00:00:00
 |  | [NAME] large applicator (Vsmooth) | U05531334 | 2009-06-04 00:00:00
Pure Med Spa - Beverly Center | Los Angeles | eLight System | L00012655 | 2011-05-19 00:00:00
 |  | eLaser System | R01005286 | 2011-05-19 00:00:00
 |  | ReFirme ST applicator | U00004308 | (blank)
 |  | SRA applicator | [NAME] | 2010-09-10 00:00:00
 |  | SR applicator | F00009502 | 2010-12-16 00:00:00
 |  |  | F00009507 | (blank)
 |  | DSL Applicator | LD0015088 | (blank)
 |  | LVA applicator | FD0004635 | 2010-06-25 00:00:00
 |  | LV applicator | FD0004495 | 2010-08-08 00:00:00
 |  | VelaShape System | U08121077 | 2011-05-12 00:00:00
 |  | Vshape small applicator (Contour) | U02510768 | 2011-05-12 00:00:00
 |  |  | U08100332 | 2009-06-16 00:00:00
 |  |  | U08165570 | 2011-05-09 00:00:00
Pure Med Spa - Boulevard Mall LLC | Las Vegas | eMax system | 1216 | 2010-05-29 00:00:00
 |  | ReFirme ST applicator | U00004284 | 2010-05-29 00:00:00
 |  | SRA applicator | FAC7144 | 2010-05-29 00:00:00
 |  | AC applicator | FA2069 | 2010-05-29 00:00:00
 |  | DS applicator | 1593 | 2010-05-29 00:00:00
Spreadsheet: 775742d1649281920-sumifs-formula-with-variable-column-linefcsts22plan-example-test
Sheet: Data-a

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S/B 1309
CTL | DEPT | Current State Detail | Future State Detail | [NAME] | CM LINE | CM SUBTOTAL ROW | LOC | 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 | Blank | HG:HG | 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 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | Total
62 | F103 | 622 | 622 | HOURLY OVERTIME PREMIUM | OVERTIME | Wages and Benefits | F1 | 2.06 | 1143.84 | 2723.94 | 1357.76 | 340.96 | 943.61 | 485.02 | 243.87 | 2184.18 | 1083.42 |  |  |  |  |  | 1371.1104 | 1308.7872 | 1308.7872 | 1246.464 | 1184.1408 | 1661.952 | 1661.952 | 1911.2448 | 1745.0496 | 1745.0496 | 1828.1472 | 18281.472
Spreadsheet: 145485d1331612452-need-help-on-if-then-and-vlookup-excel-help-4
Sheet: Malbec

Malbec |  | Argentina
item ID | Description | Size | Pk | Varietal | Region | App | Sub App
Malbec |  | USA
item ID | Description | Size | Pk | Varietal | Region | App | Sub App
Spreadsheet: 151090d1334777279-complex-match-return-array-of-values-match-return-array-of-values
Sheet: Sheet1

[NAME] | RCS | Week | Date_of_Walk
7391 | 1 | 1 | 2012-04-10 00:00:00
6501 | 1 | 1 | 2012-04-10 00:00:00
7751 | 1 | 1 | 2012-04-11 00:00:00
2111 | 1 | 1 | 2012-04-11 00:00:00
4531 | 1 | 1 | 2012-04-12 00:00:00
7231 | 1 | 1 | 2012-04-12 00:00:00
7524 | 2 | 1 | 2012-04-10 00:00:00
6634 | 2 | 1 | 2012-04-10 00:00:00
7884 | 2 | 1 | 2012-04-11 00:00:00
2244 | 2 | 1 | 2012-04-11 00:00:00
4664 | 2 | 1 | 2012-04-12 00:00:00
7364 | 2 | 1 | 2012-04-12 00:00:00
7657 | 3 | 1 | 2012-04-10 00:00:00
6767 | 3 | 1 | 2012-04-10 00:00:00
8017 | 3 | 1 | 2012-04-11 00:00:00
2377 | 3 | 1 | 2012-04-11 00:00:00
4797 | 3 | 1 | 2012-04-12 00:00:00
Spreadsheet: 95388d1294966676-nested-if-gives-name-error-chart
Sheet: Sheet1

PART DEFINITION DATA
Date: | 40556.78389259259
Part Data: |  |  |  |  |  |  |  |  | x | y
 | Blank to [NAME]? (y or n) | n | (No Perimeter Cutting) |  |  |  | Best [NAME] |  | 120 | 60
 | MTL Code | S14CR |  |  |  |  | Code | 7
 | MTL Thickness | 0.075
 |  |  |  |  |  |  |  |  |  | Spacing
 |  |  |  |  |  |  |  |  |  | Min | [NAME]
 | Blank "X" Dimension | 8.26 | in | 0.25 | spacing if no common edge cutting |  |  |  |  | 0.25 | 0.75
 | Blank "Y" Dimension | 3.23 | in | 0.25 | spacing if no common edge cutting |  |  |  |  | 0.25 | 0.75
 | Parts per Blank | 1 |  | 0.2056583333333333 | [NAME]
 | [NAME] |  |  |  | 0.99 | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  |  |  | y | 12 | 48 | 48 | 48 | 48 | 60 | 48 | 60
 |  |  |  | x | 12 | 48 | 60 | 72 | 96 | 60 | 120 | 120
 |  | Sheet Size Code |  | 0 | 0.99 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | Optimum
 |  | [NAME] |  | PART | 99 | 4 x 4 | 4 x 5 | 4 x 6 | 4 x 8 | 5 x 5 | 4 x 10 | 5 x 10
 |  | [NAME] |  | 0 | 0.87890625 | 15.50390625 | 19.44140625 | 23.37890625 | 31.25390625 | 24.37890625 | 39.12890625 | 49.06640625
 |  | Available Sheet  X |  | 1 | 11.25 | 47.25 | 59.25 | 71.25 | 95.25 | 59.25 | 119.25 | 119.25
 |  | Available Sheet Y |  | 1 | 11.25 | 47.25 | 47.25 | 47.25 | 47.25 | 59.25 | 47.25 | 59.25
 |  | Scrap-to-Part Ratio |  | 0 | 1 | 0.1645130208333333 | 0.1259520833333333 | 0.1088138888888889 | 0.08096432291666666 | 0.1609140000000001 | 0.06425458333333334 | 0.0210663333333333 | 0.0210663333333333
 |  | Parts per Sheet -( x-x) |  | 1 | #N/A | 65 | 78 | 104 | 143 | 102 | 182 | 238
 |  | Parts per Sheet -( x-y) |  | 1 | 3 | 65 | 85 | 100 | 135 | 102 | 170 | 204
 |  | Optimimum Sht Prts Count |  | 1 | #N/A | 65 | 85 | 104 | 143 | 102 | 182 | 238
 |  | Rows "x" |  |  | #N/A | 5 | 5 | 8 | 11 | 6 | 14 | 14
 |  | Columns "y" |  |  | #N/A | 13 | 17 | 13 | 13 | 17 | 13 | 17
 |  | [NAME] |  |  | 3.125 | 50 | 62.5 | 75 | 100 | 78.125 | 125 | 156.25
 |  | x |  | y
 | Special Sht Size (in.) | 12 | x | 12
 | Special Sht Square Feet | 1
 | Preferred [NAME]
 | Manual Parts per sheet =>
 | Groups of nests=>
Spreadsheet: 114971d1310630962-automatically-updating-data-from-one-sheet-to-another-june1
Sheet: 469

Date | Trip Details | Amount | Toll | Other | Party | Payment Yes/N0 | [NAME]
2011-06-01 00:00:00 | [NAME]
2011-06-02 00:00:00 | [NAME]
2011-06-03 00:00:00 | [NAME]
2011-06-04 00:00:00 | [NAME]
2011-06-05 00:00:00 | [NAME]
2011-06-06 00:00:00 | [NAME]
2011-06-07 00:00:00 | [NAME]
2011-06-08 00:00:00
2011-06-09 00:00:00 | [NAME] | Yes
2011-06-10 00:00:00 | Burlington | Yes
2011-06-11 00:00:00 | Burlington | Yes
2011-06-12 00:00:00 | Burlington | Yes
2011-06-13 00:00:00
2011-06-14 00:00:00
2011-06-15 00:00:00
2011-06-16 00:00:00
2011-06-17 00:00:00
2011-06-18 00:00:00
2011-06-19 00:00:00 | Skyarch
2011-06-20 00:00:00 | Skyarch
2011-06-21 00:00:00 | Skyarch
2011-06-22 00:00:00 | Skyarch
2011-06-23 00:00:00 | Skyarch
2011-06-24 00:00:00 | Skyarch
2011-06-25 00:00:00 | Skyarch
2011-06-26 00:00:00 | Ramada | Yes
2011-06-27 00:00:00
2011-06-28 00:00:00
2011-06-29 00:00:00
2011-06-30 00:00:00
2011-07-01 00:00:00
2011-07-02 00:00:00
2011-07-03 00:00:00
2011-07-04 00:00:00
2011-07-05 00:00:00
2011-07-06 00:00:00
2011-07-07 00:00:00
2011-07-08 00:00:00
2011-07-09 00:00:00
2011-07-10 00:00:00 | [NAME]
2011-07-11 00:00:00
2011-07-12 00:00:00
2011-07-13 00:00:00
2011-07-14 00:00:00
2011-07-15 00:00:00
2011-07-16 00:00:00
2011-07-17 00:00:00
2011-07-18 00:00:00
2011-07-19 00:00:00
2011-07-20 00:00:00
2011-07-21 00:00:00
2011-07-22 00:00:00
2011-07-23 00:00:00
2011-07-24 00:00:00
2011-07-25 00:00:00
2011-07-26 00:00:00
2011-07-27 00:00:00
2011-07-28 00:00:00
2011-07-29 00:00:00
2011-07-30 00:00:00
2011-07-31 00:00:00
Spreadsheet: 862437d1710169439-extract-moving-average-for-the-last-n-th-values-in-a-dynamic-row-in-excel-excluiding-zeros-new-microsoft-excel-worksheet
Sheet: Sheet2

 | xxxx | Monday
 | x1 | x1 | 320 | 540 | 620 | 320 | 540 | 620
 |  | x2
 |  | xe
Spreadsheet: 136236d1326486134-using-a-formula-to-find-a-total-from-three-rows-test2
Sheet: Sheet1

Code | EmpID | Fname | Mname | Lname | Dept | [NAME]
1 | 22094 | Mark |  | [NAME] | AUI | 64
4 | 22094 | Mark |  | [NAME] | AUI | 8
7 | 22094 | Mark |  | [NAME] | AUI | 8
1 | 22244 | [NAME] | C | [NAME] | AUI | 66.67
4 | 22244 | [NAME] | C | [NAME] | AUI | 8
7 | 22244 | [NAME] | C | [NAME] | AUI | 8
1 | 22909 | [NAME] |  | Smith | ISG | 63.12
4 | 22909 | [NAME] |  | Smith | ISG | 16
7 | 22909 | [NAME] |  | Smith | ISG | 8
1 | 24721 | Anne |  | Heath | AIC | 51.25
4 | 24721 | Anne |  | Heath | AIC | 24
7 | 24721 | Anne |  | Heath | AIC | 8
1 | 24749 | Mark |  | Palmer | ISG | 72.78
4 | 24749 | Mark |  | Palmer | ISG | 8
7 | 24749 | Mark |  | Palmer | ISG | 8
1 | 28189 | [NAME] |  | [NAME] | AUI | 78
7 | 28189 | [NAME] |  | [NAME] | AUI | 8
1 | 47744 | Kathy |  | Bailey | AIC | 81
7 | 47744 | Kathy |  | Bailey | AIC | 8
1 | 48071 | Penny |  | Childress | AUI | 69.25
4 | 48071 | Penny |  | Childress | AUI | 8
7 | 48071 | Penny |  | Childress | AUI | 8
1 | 49667 | [NAME] |  | Camp | Jr | USA   72.6
7 | 49667 | [NAME] |  | Camp | Jr | USA  8
1 | 62976 | Scott |  | Moody | AUI | 68.02
4 | 62976 | Scott |  | Moody | AUI | 4.07
7 | 62976 | Scott |  | Moody | AUI | 8
1 | 66289 | Scott | N | [NAME] | AIC | 72
7 | 66289 | Scott | N | [NAME] | AIC | 8
1 | 66376 | Peggy |  | Ford | ISG | 43.7
4 | 66376 | Peggy |  | Ford | ISG | 33.72
7 | 66376 | Peggy |  | Ford | ISG | 8
1 | 80459 | Becki |  | Gardner | MIG SC | 71.13
4 | 80459 | Becki |  | Gardner | MIG SC | 8
7 | 80459 | Becki |  | Gardner | MIG SC | 8
1 | 85330 | Sandra | H | Major | AUI | 73.38
7 | 85330 | Sandra | H | Major | AUI | 8
1 | 118071 | [NAME] | [NAME] | Morrison | ITP | 61.77
4 | 118071 | [NAME] | [NAME] | Morrison | ITP | 16
7 | 118071 | [NAME] | [NAME] | Morrison | ITP | 8
1 | 132861 | [NAME] |  | Byrd | AUI | 53.97
4 | 132861 | [NAME] |  | Byrd | AUI | 24
7 | 132861 | [NAME] |  | Byrd | AUI | 8
1 | 133126 | [NAME] | D | Compton | ISG | 69.58
4 | 133126 | [NAME] | D | Compton | ISG | 11.68
7 | 133126 | [NAME] | D | Compton | ISG | 8
1 | 137752 | [NAME] |  | Neel | AUI | 80.88
7 | 137752 | [NAME] |  | Neel | AUI | 8
1 | 138422 | [NAME] | B | Crownover | AUI | 39.57
4 | 138422 | [NAME] | B | Crownover | AUI | 32
7 | 138422 | [NAME] | B | Crownover | AUI | 8
1 | 150264 | Joel | C | Ammons | ISG | 81
7 | 150264 | Joel | C | Ammons | ISG | 8
1 | 155841 | [NAME] |  | Parraga | AIC | 75.83
7 | 155841 | [NAME] |  | Parraga | AIC | 8
1 | 157510 | Fred |  | [NAME] | AUI | 87.07
4 | 157510 | Fred |  | [NAME] | AUI | 3.5
7 | 157510 | Fred |  | [NAME] | AUI | 8
1 | 165945 | [NAME] |  | [NAME] | AIC | 63
4 | 165945 | [NAME] |  | [NAME] | AIC | 16
7 | 165945 | [NAME] |  | [NAME] | AIC | 8
1 | 170775 | Yolanda |  | Smith | USA | 64
4 | 170775 | Yolanda |  | Smith | USA | 8
7 | 170775 | Yolanda |  | Smith | USA | 8
1 | 174142 | Rex | A | Lynch | MRA | 74.48
7 | 174142 | Rex | A | Lynch | MRA | 8
1 | 178972 | [NAME] | K | Seagroves | USA | 82.03
7 | 178972 | [NAME] | K | Seagroves | USA | 8
Spreadsheet: 220189-pivot-table-grand-total-percentage-error-grand-total-
Sheet: Sheet1

Activities | Income | Expense | % | Type
A | 50 | 20 | 1.5 | Drama
B | 150 | 100 | 0.5 | Drama
C | 100 | 80 | 0.25 | Drama
X | 1000 | 900 | 0.1111111111111111 | Arts
Y | 900 | 800 | 0.125 | Arts
D | 90 | 180 | -0.5 | Music
E | 100 | 150 | -0.3333333333333333 | Tennis
Type | Drama
 | Data
Activities | Sum of Income | Sum of Expense | [NAME]
A | 50 | 20 | 1.5
B | 150 | 100 | 0.5
C | 100 | 80 | 0.25
Grand Total | 300 | 200 | 0.5
Spreadsheet: benjamin_rogers__1069__Consolidated 2000 Peaker
Sheet: Gleason

INCOME STATEMENT - GLEASON
('000 $) | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
Revenue
Merchant Period: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Demand Payment
Variable Revenue
Interest Income
Total Revenue
Expense
Fixed O&M
Variable O&M
Major [NAME]
Owner's Expense
Property Taxes Liability | 174.46 | 348.92 | 436.15 | 436.15 | 436.15 | 523.38 | 523.38 | 523.38 | 523.38 | 523.38 | 523.38 | 523.38 | 872.3 | 872.3 | 1308.45 | 743.9310449999999 | 758.8096658999999 | 773.985859218 | 789.4655764023599 | 805.2548879304072
Franchise Tax
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
EBT
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
After Tax Book Income
CASH FLOW - GLEASON
('000 $) | 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check
EBITDA
Plus Property Tax Liability
Less Property Tax Expense | -92.2251014
Debt Service
Pre Tax Cash Flow
State Cash Taxes Benefit (Expense)
Federal Cash Taxes Benefit (Expense)
After Tax Cash Flow
STATE TAX & FRANCHISE TAX - GLEASON
 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
('000 $) | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
FRANCHISE TAX
Book Value of Assets
Paid-In-Capital
[NAME]
Outstanding Debt
Total Capitalization
Greater of Book Value and Capitalization
State Franchise Tax Rate
State Franchise Tax Liability | 608.9882902589542 | 590.1536008695019 | 571.3189114800498 | 552.4842220905977 | 533.6495327011454 | 514.8148433116933 | 495.9801539222411 | 477.1454645327889 | 458.3107751433367 | 439.4760857538845 | 420.6413963644324 | 401.8067069749802 | 382.972017585528 | 364.1373281960758 | 345.3026388066236 | 326.4679494171715 | 307.6332600277193 | 288.7985706382671 | 269.963881248815 | 251.1291918593628
STATE TAXES
Pretax Book Income
Plus Book Depreciation & Amortization
Less Tax Depreciation
State Taxable Income
State Income Tax Rate
Current State Income Tax Expense (Benefit)
Beginning NOL's | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
New NOL's
Expired NOL's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NOL Utilization
Ending NOL's
Total State Taxes Utilizing NOLs
Spreadsheet: 537926d1505324503-index-match-function-with-multiple-arrays-testfunction
Sheet: Sheet1

 |  | input | one |  |  |  |  |  |  | test1 |  |  |  | test2
 |  |  |  |  |  |  |  |  |  | NAME | CODE | PRICE |  | NAME | CODE | PRICE
 |  |  |  |  |  |  |  |  |  | ONE | 1 | 2 |  | SIX | 6 | 7
 |  |  |  |  |  |  |  |  |  | TWO | 2 | 3 |  | SEVEN | 7 | 8
 |  |  |  |  |  |  |  |  |  | THREE | 3 | 4 |  | EIGHT | 8 | 9
 |  |  |  |  |  |  |  |  |  | FOUR | 4 | 5 |  | NINE | 9 | 10
 |  |  |  |  |  |  |  |  |  | FIVE | 5 | 6 |  | TEN | 10 | 11
 |  |  | I want the function in cell D4, to search through both test1 and test2 (in first column, then return what is in the others)
 |  |  | I think I need to index the match function, as said on the forum but am unsure how to do this for multiple arrays
 |  |  | I know I could just add an extra two defined ranges (test1_col1 and test2_col1) and manually input… however I am using this on a spreadsheet with 50+ tables so was looking for a shortcut
Spreadsheet: 219342d1362727289-help-with-a-formula-function-if-its-possible-admit-dc-2013
Sheet: 4

Admission and Discharges
2013
Date: | 2013-01-04 00:00:00
ADMISSIONS |  |  |  |  |  |  | DISCHARGES
Room # | Name | Time | From | Status | Telemetry Box # |  | Room # | Name | Time | To
306 | z | 01:46:00 | ED |  |  |  | 335 | a | 14:40:00 | Home
205 | x | 03:01:00 | ED |  |  |  | 318 | s | 13:50:00 | Home
307 | y | 23:35:00 | ED |  |  |  | 206 | d | 12:50:00 | Home
316 | b | 01:55:00 | ED |  |  |  | 202 | f | 13:30:00 | Home
314 | a | 10:20:00 | ED |  |  |  | 218 | g | 13:45:00 | Home
318 | c | 14:10:00 | ASU |  |  |  | 217 | h | 14:30:00 | Home
303 | d | 14:00:00 | ASU |  |  |  | 320 | j | 14:35:00 | Home
IC03 | t | 15:40:00 | ASU |  |  |  | 302 | k | 14:55:00 | Home
217 | y | 16:00:00 | ED |  |  |  | 201 | l | 14:35:00 | Home
IC08 | u | 19:00:00 | ED |  |  |  | IC09 | q | 16:48:00 | Home
336 | i | 19:35:00 | ED |  |  |  | IC01 | e | 17:00:00 | Home
IC02 | o | 22:15:00 | ED |  |  |  | 336 | r | 18:22:00 | Home
 |  |  |  |  |  |  | 214 | t | 19:01:00 | Home
 | How many admits: 0001-0200: | 2 | How many  From ED | How many inpt | Total # Admits |  |  | How many admits: 0001-0200: | 0 | Total #  Discharges
 | How many admits: 0201-0400: | 1 | 9 | 0 | 12 |  |  | How many admits: 0201-0400: | 0 | 13
 | How many admits: 0401-0600: | 0 | How many  From CDU | How many obs |  |  |  | How many admits: 0401-0600: | 0
 | How many admits: 0601-0800: | 0 | 0 | 0 |  |  |  | How many admits: 0601-0800: | 0
 | How many admits: 0801-1000: | 0 | How many from ASU |  |  |  |  | How many admits: 0801-1000: | 0
 | How many admits: 1001-1200: | 1 | 3 |  |  |  |  | How many admits: 1001-1200: | 0
 | How many admits: 1201-1400: | 1 | How many from OR |  |  |  |  | How many admits: 1201-1400: | 4
 | How many admits: 1401-1600: | 3 | 0 |  |  |  |  | How many admits: 1401-1600: | 5
 | How many admits: 1601-1800: | 0 | How many from CV |  |  |  |  | How many admits: 1601-1800: | 2
 | How many admits: 1801-2000: | 2 | 0 |  |  |  |  | How many admits: 1801-2000: | 2
 | How many admits: 2001-2200: | 0 | How many DA |  |  |  |  | How many admits: 2001-2200: | 0
 | How many admits: 2201-2400: | 2 | 0 |  |  |  |  | How many admits: 2201-2400: | 0
ROOM TRANSFERS |  |  |  |  |  |  | TELEMETRY - ON / OFF
Room # | Name | To Room # |  |  |  |  | Room# | Name | On/Off | Box #