tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 777984d1650746613-sluggish-worksheet-when-adding-new-rows-index-match-overuse-datatableexample
Sheet: OutgoingsData

 |  |  | April |  |  |  | May |  |  |  | June |  |  |  |  | July |  |  |  | August |  |  |  | September |  |  |  |  | October |  |  |  | November |  |  |  | December |  |  |  |  | January |  |  |  | February |  |  |  | March
Category | Budget | 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 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | April | May | June | July | August | September | October | November | December | January | February | March | Total YTD | Budget YTD | First Week | Lowest Active Week | Last Week | Highest Active Week | Active Weeks | Average
Expense 1 | 30
Expense 2 | 30
Expense 3 | 30
Expense 4 | 30
Expense 5 | 30
Expense 6 | 30
Expense 7 | 30
Expense 8 | 30
Expense 9 | 30
Expense 10 | 30
Expense 11 | 30
Expense 12 | 30
Expense 13 | 30
Expense 14 | 30
Expense 15 | 30
Expense 16 | 30
Expense 17 | 30
Expense 18 | 30
Expense 19 | 30
Expense 20 | 30
Expense 21 | 30
Expense 22 | 30
Expense 23 | 30
Transaction ID | Tax Year | Month | Week | Date | In/Out | Description | Category | Gross Income | Tax Paid | Net Income | Debits | Balance |  | Tax Year Start Date
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-01 00:00:00
 |  |  |  | 2021-04-01 00:00:00 | Income | Starting Balance | Starting Balance |  |  | 5000
 |  |  |  | 2021-04-07 00:00:00 | Outgoings | Expense 2 | Expense 2 |  |  |  | 300
 |  |  |  | 2021-04-13 00:00:00 | Outgoings | Expense 3 | Expense 3 |  |  |  | 150 |  |  | Cashflow
 |  |  |  | 2021-04-14 00:00:00 | Outgoings | Expense 4 | Expense 4 |  |  |  | 100
 |  |  |  | 2021-04-21 00:00:00 | Outgoings | Expense 5 | Expense 5 |  |  |  | 50
 |  |  |  | 2021-04-27 00:00:00 | Outgoings | Expense 6 | Expense 6 |  |  |  | 100
 |  |  |  | 2021-04-28 00:00:00 | Outgoings | Expense 7 | Expense 7 |  |  |  | 80
 |  |  |  | 2021-05-05 00:00:00 | Outgoings | Expense 8 | Expense 8 |  |  |  | 120
 |  |  |  | 2021-05-11 00:00:00 | Outgoings | Expense 9 | Expense 9 |  |  |  | 50
Spreadsheet: 225478d1365012677-three-2-color-grade-scale-in-ms-2007-three-2-color-grade-scale-in-ms-2007
Sheet: Sheet1

1.489 | 1.7236 | 1.6711 | 1.6024 | 1.632 | 1.2393 | 1.1177 | 1.1854
0.9387 | 0.939 | 1.0483 | 1.0422 | 0.9641 | 1.0956 | 1.3012 | 1.1856
1.0435 | 0.9864 | 0.9849 | 0.8822 | 0.8973 | 0.9587 | 0.9983 | 1.1975
1.3186 | 1.2861 | 1.2215 | 1.1814 | 1.2468 | 1.2132 | 1.1452 | 1.1994
1.8542 | 1.7325 | 1.8424 | 1.6781 | 1.6454 | 1.6775 | 1.406 | 1.2884
1.3308 | 1.2868 | 1.1944 | 1.1966 | 1.1153 | 1.1661 | 1.2713 | 1.2907
1.888 | 1.8495 | 1.8163 | 1.7068 | 1.6032 | 1.4593 | 1.399 | 1.3167
1.5521 | 1.5077 | 1.4951 | 1.4627 | 1.3981 | 1.3764 | 1.3496 | 1.3582
1.3259 | 1.2639 | 1.5869 | 1.8237 | 1.9164 | 2.8841 | 1.8146 | 1.3589
1.5767 | 1.5827 | 1.6798 | 1.687 | 1.5732 | 1.4394 | 1.4198 | 1.3625
1.4939 | 1.4048 | 1.5334 | 1.425 | 1.3859 | 1.5246 | 1.3424 | 1.3697
1.1634 | 1.1554 | 1.0192 | 1.0402 | 1.1388 | 1.1143 | 1.3758 | 1.4015
1.4039 | 1.4327 | 1.4447 | 1.4604 | 1.5062 | 1.4933 | 1.4472 | 1.4265
1.4454 | 1.3748 | 1.4071 | 1.4264 | 1.5456 | 1.6555 | 1.4375 | 1.4267
1.6067 | 1.5843 | 1.6015 | 1.8087 | 1.8061 | 1.5701 | 1.4863 | 1.4276
1.2432 | 1.2728 | 1.2755 | 1.2721 | 1.3449 | 1.3448 | 1.3534 | 1.4358
1.0503 | 1.092 | 1.1776 | 1.2172 | 1.3508 | 1.4719 | 1.4495 | 1.4385
2.1667 | 1.8679 | 1.7504 | 1.699 | 1.5222 | 1.5565 | 1.5502 | 1.4407
2.0239 | 2.4752 | 3.067 | 2.6757 | 2.2447 | 1.7331 | 1.5674 | 1.455
Spreadsheet: 854170d1704142449-closest-date-with-criteria-with-maxifs-formula-closestdate2
Sheet: Sheet1

Date | Symbol | Closest RS Date |  |  |  | Date | Symbol | [NAME]
2023-12-04 00:00:00 | MULN |  |  |  |  | 2023-05-04 00:00:00 | MULN | 1 for 10
2023-12-05 00:00:00 | ABC |  |  |  |  | 2023-08-11 00:00:00 | MULN | 1 for 20
2023-12-06 00:00:00 | ABC |  |  |  |  | 2023-12-04 00:00:00 | SYTA | 1 for 10
2023-12-07 00:00:00 | ABC |  |  |  | Desired date in cell C2-> | 2023-12-21 00:00:00 | MULN | 1 for 50
2023-12-30 00:00:00 | MULN |  |  |  | Desired date in cell C6 -> | 2023-12-30 00:00:00 | MULN | 1 for 10
Spreadsheet: 71858d1272552897-how-to-move-sort-data-from-one-sheet-to-the-next-so-close
Sheet: goes

PublisherId | ParentId | Tier | CSR | [NAME] | [NAME] | Phone | FirstName | LastName | CompanyName | ISORep | SRMRep | Note | Tags
 |  |  |  | column L | column AG | column AH |  |  | column AE |  |  | column AC | columns AV - BA; if the cell says NULL please ignore; if it says "On" then paste the header. For example, if columns AV and AW are "On" and the rest say "Null" then the cell should say "Opportunity_AFC, Opportunity_AFS"
 |  |  |  |  |  |  |  |  |  |  |  |  | on
Spreadsheet: 140033d1328601498-utility-calculator-utilities
Sheet: Sheet1

Total | 59.92 |  | Roommate | Days Absent | Days Present | Total Owed
Begin Date | 2012-01-05 00:00:00 |  | 1 | 2
End Date | 2012-02-03 00:00:00 |  | 2 | 0
# of Days |  |  | 3 | 0
Per day $
Per day $ per person (3)
Per day $ per person (2)
Per day $ per person (1)
Spreadsheet: 788974d1658828676-tools-book-out-and-returned-summary-sheet-for-stores-stock_balance
Sheet: Sheet1

Part | Opening Stock | Out Date | Return date | Qty | Stock Balance
ABC | 20
DEF |  | 2022-07-01 00:00:00 | 2022-07-10 00:00:00 | 3
ABC |  | 2022-07-05 00:00:00 | 2022-07-13 00:00:00 | 5
ABC |  | 2022-07-17 00:00:00 | 2022-07-28 00:00:00 | 7
ABC |  | 2022-07-22 00:00:00 | 2022-07-25 00:00:00 | 3
ABC |  | 2022-07-24 00:00:00 | 2022-07-30 00:00:00 | 8
Spreadsheet: 41943d1240489259-sustaining-information-engineering-projects-1-jan-2009
Sheet: Cost-Productivity Chart

Average Hours per Project | 23.8 | 68.77 | 14.33 | 17.39 | 16.95 | 16.28 | 15.34 | 16.39 | 17.29 | 14.43 | 9.68 | 11.9 | 12.75393081761006
 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4055.75 | Hour of Projects
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 318 | Projects
Spreadsheet: rick_buy__32887__Turbine Position Report 111601
Sheet: Summary by Status

Turbine Position Report |  |  |  |  |  |  |  |  | CONFIDENTIAL
Summary by Status
($ MMs)
 |  |  |  |  |  |  |  | Financial Data as of
UNITS | MODEL | CONTROLLED BY | PHYSICAL LOCATION | FINANCING VEHICLE | PROJECT(S) | DASH APPROVAL DATE / STATUS | CONTRACT COST | SCHEDULED CONTRACT PYMTS TO DATE | CANCELLATION COST TO DATE | STATUS
COMMITTED - turbines committed to deals which have been DASHed and financing is in process.
 |  |  |  |  | Total Committed
TENTATIVE - turbines tentatively committed to ONE deal which has not yet been DASHed, but is likely to be.
1 | 7FA |  |  |  |  |  |  |  |  | Tentative
 |  |  |  |  | Total Tentative
AVAILABLE - turbines which may be potential matches with SEVERAL deals, none of which have been approved to date.
1 | 501D5A simple cycle |  |  |  |  |  |  |  |  | Available
1 | 9FA STAG power islands |  |  |  |  |  |  |  |  | Available
2 | 9FA STAG power islands |  |  |  |  |  |  |  |  | Available
2 | 11N1 |  |  |  |  |  |  |  |  | Available
2 | MHI 501F simple cycle |  |  |  |  |  |  |  |  | Available
2 | MHI 501F simple cycle |  |  |  |  |  |  |  |  | Available
2 | Fr 6B 60hz power barges (BV=0) |  |  |  |  |  |  |  |  | Available
1 | LM6000 |  |  |  |  |  |  |  |  | Available
 |  |  |  |  | Total Available
NEGOTIATING - turbines for which the purchase is currently being negotiated, but Enron does not yet have control of these turbines.
 |  |  |  |  | Total Negotiating
 | UNITS - TOTAL |  |  |  | GRAND TOTALS
SCHEDULED VS CANCELLATION PAYMENTS
($ MMs)
*  Total Cancellation Payments = Total Enron Exposure
Spreadsheet: d43938cd-10f0-4e85-9c3f-d580841a9e9b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Table S2. Differential Enrichment of iHS Outliers
Cytological Position | Physical Position | Locus | Dataset | Number of SNPs in Region | Number of SNPs with |iHS| > 4.0 | p-Value
2q21.3-q22.1 | 134,800,000 - 142,400,000 | LCT | [NAME] | 897 | 13 | -
 |  |  | CHM | 917 | 0 | 0.0001085381
 |  |  | fastPHASEd-piCHM | 914 | 0 | 0.0001109334
 |  |  | PHASEd-JPT | 908 | 0 | 0.0001158967
6p22.1-p21.32 | 26,100,000 - 33,600,000 | MHC | [NAME] | 1238 | 36 | -
 |  |  | CHM | 1115 | 40 | 0.3535201274
 |  |  | fastPHASEd-piCHM | 1104 | 6 | 1.23156e-05
 |  |  | PHASEd-JPT | 1115 | 0 | 1e-10
LCT, lactase; MHC, Major Histocompatibility Complex. All p-values are based on two-tailed Fisher's exact test.
Spreadsheet: eric_saibi__9874__102201R
Sheet: Collins 03

Owner Name |  | Midwest Generating LLC
Station Name |  | Collins Power Station
Unit Name |  | Unit 03
NERC Region |  | MAIN
State |  | IL
Fuel Type |  | Nat. gas/Fuel Oil
Capacity |  | 519 MW
Start Date |  | 2001-10-08 00:00:00
End Date |  | 2001-10-24 00:00:00
Prv. Start Date |  | 2001-10-08 00:00:00
Prv. End Date |  | 2001-10-21 00:00:00
Comments |  | Minor insp.
SIC |  | 4911
Plant ID |  | 1014082
Unit ID |  | 1005615
Outage ID |  | 16283
Spreadsheet: c2d8c9af-9ec4-42d9-ac5f-eac4cc5d08b7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | 2012 CIA JURORS LIST | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
SENIOR LEVEL [NAME] | BX | INTERMEDIATE LEVEL [NAME] | BX | ENTRY LEVEL [NAME] | BX | ENTRY LEVEL [NAME] | BX
[NAME]USA) |  | [NAME]FRA) |  | [NAME]  (AUS) |  | [NAME]  (USA)
[NAME](GBR) | X | [NAME]) |  | [NAME]  (USA) |  | Igor LOBASHOV  (UKR)
[NAME]  (SUI) | X | [NAME] (GER) |  | [NAME]  (USA) |  | [NAME]  (RUS)
Risto JALAVA   (FIN) | X | [NAME]AUT) |  | [NAME]  (BEL) |  | [NAME] MIKLOUSIC (CRO)
[NAME]  (CAN) | X | [NAME]  (AUS) |  | [NAME] (BEL) | X | [NAME](GBR)
[NAME]CAN) | X | [NAME](SWE) |  | [NAME](USA) |  | [NAME](GBR)
Les PURFIELD  (GBR) | X | Dominik HAGGENEY  (GER) | X | [NAME]  (CAN) |  | [NAME]USA)
[NAME]USA) | X | [NAME](BRA) |  | [NAME]AUT) |  | Ferenc NÁDHÁZI  (HUN)
Arno SIEGER  (GER) | X | [NAME]BEL) | X | [NAME]  (GER) |  | [NAME] NOGUERA  (ESP) | X
[NAME]  (GBR) | X | Cees van HELDEN  (NED) |  | Torben HANSEN (DEN) |  | [NAME]JPN)
[NAME]USA) | X | Sandor HIDAS  (HUN) | X | [NAME] (GER) |  | Dávid PAÁL  (HUN)
[NAME]) |  | [NAME]  (BEL) |  | [NAME](GBR) | X | Deividas PINKEVICIUS  (LTU)
[NAME] WEBER  (LUX) | X | Sabu ICHIYOSHI  (JPN) |  | [NAME]USA) |  | Gren PUTLAND  (AUS)
[NAME]  (SWE) | X | [NAME] (UKR) |  | [NAME]  (CAN) |  | [NAME]) | X
 |  | Helmut KOCAR  (AUT) | X | Eugenijus [NAME]  (LTU) | X | [NAME] (FRA)
 |  | [NAME](GBR) | X | [NAME]LTU) |  | [NAME](AUS)
 |  | [NAME]  (JPN) |  | Tomasz KUCHCINSKI   (POL) |  | [NAME])
 |  | [NAME] PAENEN  (BEL) | X
 |  | [NAME]  (HUN) | X
 |  | Brita PETERSEN  (GER) | X
 |  | [NAME]USA)
 |  | [NAME](SWE)
 |  | [NAME](CAN) | X
 |  | Moniek VANDE VELDE  (BEL)
 |  | [NAME]  (LUX)
14 | 12 | 25 | 9 |  | 3 | 34 | 5
The above are qualified to serve as Jury President or Member at any type of event |  | The above are qualified to serve as Jury President at any type of event except World Championships, and as Jury Member at any type of event |  | The above are qualified to serve as Jury Member at any type of event except World Championships
Total Jurors | 73 |  |  |  |  | CIA JURY BOARD 2012-04-12       [NAME]
Total Jurors BX | 26
Spreadsheet: 684374d1593335091-rank-in-order-and-shade-using-conditional-formatting-rankandshade-khanaran-1-
Sheet: Sheet1

BP | [NAME] | Last Race | BioV | JT | JH | WT | SR | DOB | SIRE |  | CON | OR | TOT | OB | CB | MERIT | TIME | Raj | Book | Diff | OR | PRB | BioV | SR | CON | PRB
 |  |  | 17 |  |  |  |  |  |  |  | 70 | 114.5 | 25.4 | 10 | 66 | - | 63
 |  |  | 32 |  |  |  |  |  |  |  | 35 | 100 | 22.1 | 16 | 35 | - | 63.2
 |  |  | 42 |  |  |  |  |  |  |  | 27 | 242.5 | 48.5 | 1.5 | 2.8 | - | 64.5
 |  |  | 25 |  |  |  |  |  |  |  | 29 | 91.5 | 21.5 | 4.5 | 35 | - | 65
 |  |  | 27 |  |  |  |  |  |  |  | 32 | 159 | 24.2 | 8 | 66 | - | 67.9
 |  |  | 27.3 |  |  |  |  |  |  |  |  | 74 | 20.6 | 12 | 6 | - | 999.8
 |  |  |  |  |  |  |  |  |  |  |  | 56.5 | 15.3 | 33 | 35 | - | 999.8
 |  |  |  |  | Col S need to rank column  N from highest to lowest
 |  |  |  |  | Col T need to rank column  P from LOWEST TO HIGHEST
 |  |  |  |  | Col V need to rank column  M from highest to lowest
 |  |  |  |  | Col S need to rank column  N from highest to lowest
 |  |  |  |  |  |  |  | Ranking to be 1 ,2,3,4 and shaded green orange blue red |  |  |  |  |  |  |  |  | Need help with trying to add iferror or iserro if the columns has #N/A
Spreadsheet: 17676ade-9a4a-48e6-bf39-02622e02fb85
Sheet: Sheet1

Summary of tumors used for modeling distribution of sizes at diagnosis in a closely-monitored population. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Citation: [NAME], et [NAME]. (2007) Ovarian cancer screening with annual transvaginal sonography: findings of 25,000 women screened. Cancer 109: 1887-1896.
Study Description: 25000 women screened by TVUS, average of 4.8 screens each. Population not well defined vis a vis risk.  Rescreening of women with abnormal scans but this number is not provided (so bias toward multiple scans of women with abnormal earlier scan).
Summary of Putative Serous Cancers Detected*
 | Total | Stage distribution
Prevalence screen | 8 | 3 stage I, 2 stage II, 3 stage III
Incidence screen | 10 | 2 stage I, 5 stage II, 1 stage III (+ 2 "primary peritoneal"- Stage III)
Interval clinical cancers | 9 | 2 stage II, 7 stage III
Total | 27 | 5 stage I, 9 stage II, 11 stage III  (+2 peritoneal stage III)
*Tumor histology was not consistently defined. We assumed that HG adenocarcinoma, papillary adenocarcinoma and serous cystadenocarcinoma should be called serous.
Nominal Histology | Stage | Volume (cm3) | Equivalent Sphere Diameter (cm)
Prevalence Screen - Putative Serous Cancers
adenocarcinoma, Gr1 | 1 | 164 | 6.791229523398108
adenocarcinoma, Gr3 | 1 | 51 | 4.601052455660458
papillary serous adenocarcinoma, Gr 1 | 1 | 27 | 3.7221029453964
adenocarcinoma, Gr3 | 2 | 16 | 3.126370567187088
adenocarcinoma, Gr3 | 2 | 326 | 8.538986479839007
adenocarcinoma, Gr3 | 3 | 154 | 6.650291768032731
papillary serous carcinoma, Gr 2 | 3 | 87 | 5.497605134632529
adenocarcinoma, Gr3 | 3 | 313 | 8.42393948619934
Incidence screen - Putative Serous Cancers
serous cystadenocarcinoma Gr3 | 1 | 27 | 3.7221029453964
adenocarcinoma, Gr3 | 1 | 35 | 4.058415182579961
papillary serous carcinoma, Gr 2 | 2 | 90 | 5.560083268891277
serous cystadenocarcinoma Gr3 | 2 | 129 | 6.268982093389452
adenocarcinoma, Gr3 | 2 | 20 | 3.367780601921259
adenocarcinoma, Gr3 | 2 | 28 | 3.767498918725543
adenocarcinoma, Gr3 | 2 | 279 | 8.10715594554489
adenocarcinoma, Gr3 | 3 | 335 | 8.616853875390477
primary peritoneal | 3 | NS | NS
primary peritoneal | 3 | NS | NS
Interval screen - Cancers diagnosed within 12 months of negative screen
Not specified | 2 | NS | NS
Not specified | 3 | NS | NS
Not specified | 3 | NS | NS
Not specified | 2 | NS | NS
Not specified | 3 | NS | NS
Not specified | 3 | NS | NS
Not specified | 3 | NS | NS
Not specified | 3 | NS | NS
Not specified | 3 | NS | NS
Note:  7 patients had poorly differentiated tumors and 2 had moderately differentiated tumors
NS=Not specified
Spreadsheet: mary_fischer__25638__31U
Sheet: E36.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031U
COMPANY NAME   Limbach Mgmt Company
EQUITY INVESTEE'S SUMMARIZED INFORMATION
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  | E-36
NAME OF INVESTEE:
% OF OWNERSHIP:
THIS E-SCHEDULE IS REQUIRED FOR ALL OWNED EQUITY INVESTEES.
Please note the relationship and the differences between the E-3 (Analysis of Investment in Unconsolidated Equity Subsidiaries) and the E-36 (Equity
Investee's Summarized Information).  The E-3 seeks details of the Enron consolidating subsidiaries' (i.e. the investor) investment account.  The E-36
seeks summarized income statement and balance sheet information of the unconsolidated subsidiary (i.e. the investee).
If an E-3 has been prepared for an equity investment, then an E-36 for the related in investee needs to be completed.
Include all investees, regardless of Enron's ownership interest.
PLEASE PROVIDE THE FOLLOWING SUMMARIZED FINANCIAL INFORMATION AS IT
WOULD APPEAR IN THE INVESTEE'S FINANCIAL STATEMENTS (100%).
 |  |  |  | BALANCE AT
BALANCE SHEET (100%) |  |  |  | END OF QUARTER
CURRENT ASSETS |  |  |  | 0
PROPERTY, PLANT AND EQUIPMENT, NET. |  |  |  | 0
OTHER NONCURRENT ASSETS |  |  |  | 0
CURRENT LIABILITIES |  |  |  | 0
LONG-TERM DEBT |  |  |  | 0
ADVANCES FROM ENRON COMPANIES |  |  |  | 0
OTHER NON-CURRENT LIABILITIES |  |  |  | 0
OWNERS' EQUITY |  |  |  | 0
Memo:
AMOUNT RECEIVABLE FROM ENRON (included above) |  |  |  | 0
AMOUNT PAYABLE TO ENRON (included above) |  |  |  | 0
INVESTMENT IN UNCONSOLIDATED
EQUITY INVESTEE
(must tie to Hyperion acct TOT_INVEST_SUBS & E-3) |  | 0
Asset/Expense Accts:  DR/(CR)
INCOME STATEMENT (100%) |  |  |  | YEAR-TO-DATE
OPERATING REVENUES |  |  |  | 0
OPERATING EXPENSES |  |  |  | 0
GROSS INTEREST EXPENSE (3rd Party Only) |  |  |  | 0
OTHER INCOME & DEDUCTIONS |  |  |  | 0
INCOME TAXES |  |  |  | 0
NET INCOME
INVESTMENT IN NET INCOME
(must tie to Hyperion acct TOT_EQEARN_OTH & E-3) |  | 0
Income Accts:  DR/(CR)
Memo:
CAPITALIZED INTEREST |  |  |  | 0
RENTAL EXPENSE |  |  |  | 0
 |  |  |  | E-36
Spreadsheet: 586364d1534342362-need-and-or-added-to-an-index-small-if-statement-excel-training-index-small-if-need-to-add-or-1-
Sheet: Raw Data

This is what the main page looks like:
 |  |  |  |  | PREFERRED WHOLESALER IN ORDER
Business Partner | Address | City | State | Zip | WS Pref 1 | WS Pref 2
Titos Inc. | 123 Main Street | Indy | IN | 11111 | ABC | DEF
Absolute Inc. | 456 Maple Drive | Chicago | IL | 22222 |  | DEF |  | <--- Coworker types in the various wholesalers our partner buys from in the blue area.
Smirnoff Inc. | 789 State Street | Seattle | WA | 33333
Titos2 Inc. | 123 Main Street | Indy | IN | 11111 | [NAME]
Titos3 Inc. | 123 Main Street | Indy | IN | 11111 | def | ABC3
Spreadsheet: 526356d1499276722-if-hyperlink-none-or-link-url-formula
Sheet: Running List

Date |  | Property Address | Property Name | Crew | Invoice # | Amount | Paid (Y/N) | Date Paid | Check # | Link to Invoice
2017-01-01 00:00:00 |  | 123 Main | Main St Shops |  |  |  |  |  |  | https://drive.google.com/open?id=18iYz75T12_AIHWoFZIU0oGcxjUda_FicxY7nL1fRRmU
2017-01-01 00:00:00 |  | 123 Main | Main St Shops
2017-01-25 00:00:00 |  | 123 Main | Main St Shops |  |  |  |  |  |  | https://drive.google.com/open?id=18iYz75T12_AIHWoFZIU0oGcxjUda_FicxY7nL1fRRmU
Spreadsheet: 89d88509-532b-40ce-928f-4a358ca37327
Sheet: ETFs

Exchange | Issuer | Market Maker | Round Lot | Trading Currency | Listing Date | Issuer Code | Market Maker Code
Maximum 100 rows per listing
 |  |  |  |  |  |  | Optional - FESE Dimensions |  |  |  |  | Optional - Other Reference Data
Symbol (Trading Code [NAME] 16 char) | Name ([NAME] 30 char) | Long Name ([NAME] 40 char) | ISIN | Number of Issued Instruments | Instrument Currency | Active ETF | Asset Class | Region or Exposure | [NAME] or Sector | Leverage | Style | Leverage Ratio | Income Treatment | [NAME] | Replication method | SWAP Counter Party | TER in % | Management Fee in % | Management Company | Fund Manager | Custodian Bank | Link Prospect | Link Underlying
Spreadsheet: 1088be21-4d92-43cd-9a15-1429b7e7ce42
Sheet: Grouping Logistics

SCHOOL NAME: |  |  | Sleeping Groups
Bruneau/1 - A | Bruneau/1 - B | Clearwater/2 - A | Clearwater/2 - B
RAMP ACCESS IF NEEDED | RAMP ACCESS IF NEEDED
 |  | CHAP: | CHAP:
CHAP: | CHAP:
Lochsa/3 - A | Lochsa/3 - B | Middle Fork/4 - A | Middle Fork/4 - B
CHAP: | CHAP: | CHAP: | CHAP:
Payette/5 -  A | Payette/5 - B | Snake/6 - A | Snake/6 - B
CHAP: | CHAP: | CHAP: | CHAP:
Secesh/7 - A | Secesh/7 - B
CHAP: | CHAP:
SCHOOL NAME: |  |  | Field Groups
GROUP ONE | GROUP TWO | GROUP THREE | GROUP FOUR
CHAPERONE (S): | CHAPERONE (S): | CHAPERONE (S): | CHAPERONE (S):
GROUP FIVE | GROUP SIX | GROUP SEVEN | GROUP EIGHT
CHAPERONE (S): | CHAPERONE (S): | CHAPERONE (S): | CHAPERONE (S):
Place the following symbols next to the group number to indicate a special need within the field group.
 | * = someone in group needs to carry an epi pen or other medication in the field
 | % = someone in group has academic, emtotional or mental challenges
 | # [NAME] someone in group has physical challenges
Spreadsheet: 884404d1733535179-best-to-the-left-array-lambda-map-sortby-recursive-besttotheleft-question
Sheet: Sheet1

Name | Quota | No |  | The Problem - BestToTheLeft
Jacobs | 16.2 | 1 |  |  | Arrange each row of players, left to right, higher quota to left.
Hennessey | 18.8 | 2 |  |  | I want an array that I can paste Values over the first array.
Wasson | 20.4 | 3 |  |  | So the better Quota Players on the Left, in Player A column
Dieruf | 18 | 4
Morehead | 19.8 | 5 |  |  | Player A | Player B | Player C | Player D
Yaden | 26.4 | 6 |  |  | Jacobs | Hennessey | Wasson | Open
[NAME] | 22.4 | 7 |  |  | Dieruf | Morehead | Yaden | [NAME]
[NAME] | 14 | 8 |  |  | [NAME] | Nalley | Garrett | [NAME]
Nalley | 19.8 | 9 |  |  | Dietz | Wachtel | Abell | Barnes
Garrett | 28.8 | 10 |  |  | Ruffra | O'Neil | [NAME] | Clem
[NAME] | 25.4 | 11 |  |  | Walsh | Pribble | Blandford | [NAME]
Dietz | 20.2 | 12
Wachtel | 32.4 | 13 |  |  | I'm first using a [NAME] funtion in F15 to get an array of Quotas
Abell | 24.6 | 14 |  |  |  | 18.8 | 20.4 | 0
Barnes | 17.6 | 15 |  |  | 18 | 19.8 | 26.4 | 22.4
Ruffra | 24.6 | 16 |  |  | 14 | 19.8 | 28.8 | 25.4
O'Neil | 21 | 17 |  |  | 20.2 | 32.4 | 24.6 | 17.6
[NAME] | 20.4 | 18 |  |  | 24.6 | 21 | 20.4 | 30.4
Clem | 30.4 | 19 |  |  | 26.8 | 26.8 | 27 | 10.6
Walsh | 26.8 | 20
Pribble | 26.8 | 21 |  |  | Then I use a SortBy to arrange the names based on Quota - Highest to Lowest
Blandford | 27 | 22 |  |  | But I need to do this for each individual ROW.
[NAME] | 10.6 | 23 |  |  |  | Hennessey | Jacobs | Open
 |  |  |  |  |  | [NAME] | Morehead | Dieruf
 |  |  |  |  |  | [NAME] | Nalley | [NAME]
 |  |  |  |  |  | Abell | Dietz | Barnes
 |  |  |  |  |  | Ruffra | O'Neil | [NAME]
 |  |  |  |  |  | Walsh | Pribble | [NAME]
 |  |  |  |  | Now I copy the last array and Paste Values over the first array.  Done.
 |  |  |  |  | How can I create the last array  using a ByRow Function???
 |  |  |  |  | Better would be to not need intermediate arrays to do all the work?
 |  |  |  |  |  | Not sure this is possible without a Recursive Lambda.
 |  |  |  |  |  | I need a spill function in F24??
Spreadsheet: 672210d1586793391-ranking-without-duplicates-without-skipping-numbers-racing-sheet-ranks-no-skipping
Sheet: Runners

Date | Meeting | Time | H/Cap | Class | Age | Code | Dist | Run | Type1 | Type2 | [NAME] | No | Horse | Form | Grade | Distance | Going | Speed | Rating | RTD | Won | Odds | Returns | Draw | Trainer | [NAME] | Distance |  | Going | Top5 | Speed | Top5 | CD | Prize | BHA | WT | DSLR | Age | Cr | Cl | Lm | To | Draw% | RS | [NAME] | Rank | LTO | Rank | Days | Ave | MA | Rank | Diff | Cse | Dist | Abiliy | Form | F/C | HForm | Prize | BHA | [NAME] 3 | Trainer 4/5 | [NAME] | Jocks 4/5 | T14 | J14
Spreadsheet: 653800d1576242419-looking-for-one-value-in-two-columns-problem1
Sheet: Before

Col1 | Col2
A | E
B | A
C | A
D | B
E | C
A | D
B | E
C | A
D | B
E | C
D | D
E | E