tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 658b24e6-60fc-48b9-b3a6-c881f0d04549
Sheet: Sheet1

Windstream Corporation | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
Reconciliations of Non-GAAP Financial Measures
Net Debt to OIBDA (net leverage ratio)
as of March 31, 2009
(Dollars in millions) |  |  |  |  |  | 2009
Long-term debt, including current maturities |  |  |  |  |  | 5379.3
Cash and cash equivalents |  |  |  |  |  | -312.2
Net debt |  |  |  |  | (A) | 5067.1
Operating Income
for the twelve months ended March 31, 2009
(Dollars in millions)
Operating income under GAAP |  |  |  |  |  | 1088.7
Pro forma adjustments:
Impairment loss on assets held for sale |  |  |  |  |  | 6.5
Merger and integration costs |  |  |  |  |  | 4.6
Depreciation and amortization |  |  |  |  |  | 503.1
Pro forma OIBDA from current businesses |  |  |  |  | (B) | 1602.9
Net debt to OIBDA from current businesses |  |  |  |  | (A)/(B) | 3.161207810842847
 |  |  |  |  |  | Three |  | Three
for the three months ended March 31, 2009 and 2008 |  |  |  |  |  | Months Ended |  | Months Ended
(Dollars in millions) |  |  |  |  |  | March 31, 2009 |  | March 31, 2008 |  | Change |  | %
Operating income under GAAP |  |  |  |  |  | 252.6 |  | 296.3
Pro forma adjustments:
Merger and integration costs |  |  |  |  |  | 0 |  | 1.6
Depreciation and amortization |  |  |  |  |  | 132 |  | 121.6
Pro forma OIBDA from current businesses |  |  |  |  |  | 384.6 |  | 419.5 |  | -34.9 |  | -8.319427890345645
Free Cash Flow |  |  |  |  |  | Three
(Dollars in millions) |  |  |  |  |  | Months Ended
for the three months ended March 31, 2009 |  |  |  |  |  | March 31, 2009
Net cash provided from operations |  |  |  |  |  | 215
Additions to property, plant and equipment |  |  |  |  |  | -62.8
Free cash flow |  |  |  |  |  | 152.2
Windstream Corporation
Reconciliations of Non-GAAP Financial Measures
Expected Dividend [NAME] |  |  |  |  |  |  |  | 2009
(Dollars in millions) |  |  |  |  |  |  |  | Guidance Range
Consolidated operating income under GAAP |  |  |  |  |  |  |  | 991 | - | 1056
Depreciation and amortization |  |  |  |  |  |  |  | 494 | - | 494
Pro forma OIBDA from current businesses |  |  |  |  |  |  |  | 1485 | - | 1550
Add:
 | Expected stock based compensation |  |  |  |  |  |  | 18 |  | 18
 | Incremental non-cash pension expense |  |  |  |  |  |  | 90 |  | 90
Pro forma OIBDA from current businesses adjusted for non-cash pension expense
 | and expected restricted stock compensation |  |  |  |  |  |  | 1593 | - | 1658
Subtract:
 | Expected cash paid for interest expense |  |  |  |  |  |  | 393 | - | 393
 | Expected cash taxes |  |  |  |  |  |  | 175 | - | 200
 | Expected capital expenditures |  |  |  |  |  |  | 320 | - | 290
Expected free cash flow |  |  |  |  |  | (C) |  | 705 | - | 775
Expected dividends paid on common shares |  |  |  |  |  | (D) |  | 441 |  | 441
Expected dividend payout ratio |  |  |  |  |  | (D)/(C) |  | 0.625531914893617 | - | 0.5690322580645162
Notes:
OIBDA is operating income before depreciation and amortization.
Spreadsheet: 537475d1505119581-get-content-or-numbers-from-a-list-according-date-book
Sheet: Φύλλο1

 |  |  |  | dates | number | name |  |  |  | here I insert a date from list dates.
 |  |  |  | 2017-01-01 00:00:00 | 345 | [NAME] |  |  |  | 2017-01-02 00:00:00
 |  |  |  | 2017-01-01 00:00:00 | 46 | george
 |  |  |  | 2017-01-01 00:00:00 | 235 | [NAME]
 |  |  |  | 2017-01-01 00:00:00 | 2345 | [NAME] |  |  |  | and here I need all content according K10 date
 |  |  |  | 2017-01-01 00:00:00 | 45 | mairy |  |  |  | number | name
 |  |  |  | 2017-01-02 00:00:00 | 345 | [NAME] |  |  |  | 345 | [NAME]
 |  |  |  | 2017-01-02 00:00:00 | 46 | george |  |  |  | 46 | george
 |  |  |  | 2017-01-02 00:00:00 | 235 | [NAME] |  |  |  | 235 | [NAME]
 |  |  |  | 2017-01-03 00:00:00 | 345 | [NAME]
 |  |  |  | 2017-01-03 00:00:00 | 46 | george
 |  |  |  | 2017-01-03 00:00:00 | 235 | [NAME]
 |  |  |  | 2017-01-03 00:00:00 | 2345 | [NAME] |  |  |  | if I was entering in K10 date 4/1/2017
 |  |  |  | 2017-01-03 00:00:00 | 45 | mairy |  |  |  | number | name
 |  |  |  | 2017-01-04 00:00:00 | 345 | [NAME] |  |  |  | 345 | [NAME]
 |  |  |  | 2017-01-04 00:00:00 | 46 | george |  |  |  | 46 | george
 |  |  |  | 2017-01-04 00:00:00 | 235 | [NAME] |  |  |  | 235 | [NAME]
 |  |  |  | 2017-01-04 00:00:00 | 2345 | [NAME] |  |  |  | 2345 | [NAME]
 |  |  |  | 2017-01-04 00:00:00 | 45 | mairy |  |  |  | 45 | mairy
 |  |  |  | 2017-01-05 00:00:00 | 345 | [NAME]
 |  |  |  | 2017-01-05 00:00:00 | 46 | george
 |  |  |  | 2017-01-05 00:00:00 | 235 | [NAME]
 |  |  |  | 2017-01-05 00:00:00 | 2345 | [NAME]
 |  |  |  | 2017-01-05 00:00:00 | 45 | mairy
Spreadsheet: 886009d1735943011-if-formula-with-blanks-and-variable-calculations-excel-example
Sheet: Sheet1

 |  | Constant
 | Growth | 0.02
 |  |  | This Yr | This Yr
Account | Result |  | Amount | Percent |  | Last Yr
1 |  |  | 390 |  |  | 380.25
2 |  |  |  | 0.18 |  | 0.17
3 |  |  |  |  |  | 390.5
4 |  |  |  |  |  | 400.15
5 |  |  |  | 0.15 |  | 400
Notes:
 | Data from last year in Column G can sometimes return as currency and others as a small decimal from a percentage
 | Results to calculate agaist in Columns D and E will be currency in Column D and a percentage in Column E
 | If "This Year" is a percentage and was currency last year in Column G, I just want to apply the constanst growth from $C$2 to the data in Column G
 | If there is nothing in either Column D or E I just want "" to return
 | I'll fix one part of the IF statement but then break another…
[NAME] currently being used
 | =IF(E6=0,IF(D6=0,"",IF(E6>0,(-E5/G5)+1+$C$2,D6/G6-1)))
Spreadsheet: 85671d1285741910-conditional-formatting-example-1-
Sheet: HOTEL

CURRENT CAP RATE: |  | 0.1 |  | LOAN INTEREST RATE: |  |  | 0.08
SUBJECT | CITY | STATE | UN. | PRICE |  | INC | EXP | NOI | CAP | ARV | REPAIR | MURPHY | PRICE+ REPAIR+MURPHY | TOTAL COST | TOTAL PROFIT | YEARS | YR 1 BALANCE | YR 2 BALANCE | YR 3 BALANCE | YR 4 BALANCE | YR 5 BALANCE | YR 6 BALANCE | YR 7 BALANCE | YR 8 BALANCE | YR 9 BALANCE | YR 10 BALANCE
1 | RALEIGH | NC |  | 2000000 |  | 1000000 | 600000 | 400000 | 0.1 | 4000000 |  | 100000 | 2100000 | 2100000 | 1900000 | 8 | 2100000 | 1868000 | 1617440 | 1346835.2 | 1054582.016 | 738948.5772799999 | 398064.4634623998 | 29909.62053939182 | -367697.6098174569 | -797113.4186028534 | 9153779.87728179
Spreadsheet: 796060d1663082753-counting-cells-with-specific-text-and-on-certain-date-example-2
Sheet: Sheet1

Month | 1 | Count | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2022-01-03 00:00:00 | 2022-01-04 00:00:00 | 2022-01-05 00:00:00 | 2022-01-06 00:00:00 | 2022-01-07 00:00:00 | 2022-01-08 00:00:00 | 2022-01-09 00:00:00 | 2022-01-10 00:00:00 | 2022-01-11 00:00:00 | 2022-01-12 00:00:00 | 2022-01-13 00:00:00 | 2022-01-14 00:00:00 | 2022-01-15 00:00:00 | 2022-01-16 00:00:00 | 2022-01-17 00:00:00 | 2022-01-18 00:00:00 | 2022-01-19 00:00:00 | 2022-01-20 00:00:00 | 2022-01-21 00:00:00 | 2022-01-22 00:00:00 | 2022-01-23 00:00:00 | 2022-01-24 00:00:00 | 2022-01-25 00:00:00 | 2022-01-26 00:00:00 | 2022-01-27 00:00:00 | 2022-01-28 00:00:00 | 2022-01-29 00:00:00 | 2022-01-30 00:00:00 | 2022-01-31 00:00:00 | 2022-02-01 00:00:00 | 2022-02-02 00:00:00 | 2022-02-03 00:00:00 | 2022-02-04 00:00:00 | 2022-02-05 00:00:00 | 2022-02-06 00:00:00 | 2022-02-07 00:00:00 | 2022-02-08 00:00:00 | 2022-02-09 00:00:00 | 2022-02-10 00:00:00 | 2022-02-11 00:00:00 | 2022-02-12 00:00:00
[NAME] |  |  | DI | D | D | DO PM |  |  |  | DI | D | DO AM |  | DI | D | D | FO AM |  |  |  | DI | D | FO YEG |  | DI | D | D | DO |  |  |  | DI | D | DO
Adam |  |  |  | DI | D | D | DO
Spreadsheet: 7fc43aa5-8978-42f3-844c-93f2cad255ea
Sheet: Sheet1

Campus | Last Name | First Name | [NAME] | Phone Number | Fax Number | Street | Street2 | City | State | Zip
Appalachian State University | Maxey | Maranda | [EMAIL] | [PHONE] | [PHONE] | Anne Belk Hall |  | Boone | NC | 28608
East Carolina University | Johnston | [NAME] | [EMAIL] | [PHONE] |  | East Fifth Street |  | Greenville | NC | 27858
Elizabeth City State University | [NAME] | Felecia | [EMAIL] | [PHONE] | [PHONE] | 1704 Weeksville Road |  | Elizabeth City | NC | 27909
Fayetteville State University |  |  |  |  |  | 1200 Murchison Road |  | Fayetteville | NC | 28301
NC Agricultural and Technical State University | Oliphant | Peggy | [EMAIL] | [PHONE]-2901 | [PHONE] | 1601 East Market Street |  | Greensboro | NC | 27411
North Carolina Central University | [NAME] | Kesha | [EMAIL] | [PHONE] | [PHONE] | 1801 Fayetteville Street |  | [NAME] | NC | 27707
NC State University | Vacant |  |  | [PHONE] |  | Student Health Services Center 1900 | Box 7509 | Raleigh | NC | 27695-7509
UNC Asheville | Kaufman | [NAME] | [EMAIL] | [PHONE] |  | 1 University Heights |  | Asheville | NC | 28804
UNC-Chapel Hill | [NAME] | [NAME] | [EMAIL] | [PHONE] |  | 2126 Student Academic Services Building  North | [NAME] | Chapel Hill | NC | 27514-1015
UNC Charlotte |  |  |  |  |  | 9201 University City Boulevard |  | Charlotte | NC | 28223
UNC Greensboro | Pomeroy | [NAME] | [EMAIL] | [PHONE] | [PHONE] | Post Office Box 26170 |  | Greensboro | NC | 27402
UNC Pembroke | Walker | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1 University Drive |  | Pembroke | NC | 28372
[NAME] | Turner | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 601 South College Road |  | [NAME] | NC | 28403
UNC School of the Arts | [NAME] | [NAME] | [EMAIL] | [PHONE] |  | 1533 S. Main Street |  | Winston-Salem | NC | 27127
Western Carolina University | Alexis | Lance | [NAME] | [PHONE] |  |  |  | Cullowhee | NC | 28723
Winston-Salem State University | Waddell | [NAME] | [EMAIL] | [PHONE] |  | 601 [NAME], Jr. Drive |  | Winston-Salem | NC | 27110
North Carolina School of Science and Mathematics |  |  |  |  |  | 1219 Broad Street |  | [NAME] | NC | 27705
Spreadsheet: 108855d1305810026-vlookup-my-appologies-sampledata
Sheet: Sheet2

command: Cscript "E\:\WrapperScript\JDA_WrapperScript.vbs" "tomxobitpldb" "0" "csg_sp_cluster_update" "@ix_sys_error" "adInteger" "adParamOutput" "4" "0"
command: Cscript "E\:\WrapperScript\JDA_WrapperScript.vbs" "tomxobitpldb" "0" "csg_sp_dummy_product_update"
command: Cscript "E\:\WrapperScript\JDA_WrapperScript.vbs" "tomxobitpldb" "0" "csg_sp_event_schedule_update" "@ix_sys_error" "adInteger" "adParamOutput" " 4" "0"
command: Cscript "E\:\WrapperScript\JDA_WrapperScript.vbs" "tomxobitpldb" "0" "csg_sp_event_based_planogram_creation"
command: Cscript "E\:\WrapperScript\JDA_WrapperScript.vbs" "tomxobitpldb" "0" "csg_sp_product_validation_dummy_creation"
command: Cscript "E\:\WrapperScript\CRDB_WrapperScript.vbs" "tomxobitcrdb" "0" "IFOUT_Range_Event_Type"
command: Cscript "E\:\WrapperScript\CRDB_WrapperScript.vbs" "tomxobitcrdb" "0" "IFOUT_Planning_Grp_Event"
command: Cscript "E\:\WrapperScript\CRDB_WrapperScript.vbs" "tomxobitcrdb" "0" "IFOUT_Range_Event"
command: Cscript "E\:\WrapperScript\CRDB_WrapperScript.vbs" "tomxobitcrdb" "0" "IFOUT_Display_Grp_in_Event"
command: Cscript "E\:\WrapperScript\CRDB_WrapperScript.vbs" "tomxobitcrdb" "0" "IFOUT_RngCls_Disp_Grp_Clstr"
command: Cscript "E\:\WrapperScript\RS_WrapperScript.vbs" "tomxobitsae" "0" "usp_RDS_PlanogramVersion_update"
command: Cscript "E\:\WrapperScript\RS_WrapperScript.vbs" "tomxobitsae" "0" "usp_RDS_PlanogramInStore_update"
command: Cscript "E\:\WrapperScript\RPP_WrapperScript.vbs" "tomxobitpmdb" "0" "USP_OUTBOUND_StoreProductOnPlanogram"
command: DTExec/DTS "\MSDB\SRD_RPPToRS_ActualandProposedDataExtract" /SERVER TOMXOBITSAE /CHECKPOINTING OFF /REPORTING V
command: Cscript "E\:\WrapperScript\RS_WrapperScript.vbs" "tomxobitsae" "0" "usp_RPP_ActualData"
command: Cscript "E\:\WrapperScript\RS_WrapperScript.vbs" "tomxobitsae" "0" "usp_Calculate_CapacityConformanceandMerchandisedInd"
command: Cscript "E\:\WrapperScript\RS_WrapperScript.vbs" "tomxobitsae" "0" "usp_Calculate_StoreProdConformParameters"
command: Cscript "E\:\WrapperScript\RS_WrapperScript.vbs" "tomxobitsae" "0" "usp_Insert_tbl_PlanogramVersion_out"
command: Cscript "E\:\WrapperScript\RS_WrapperScript.vbs" "tomxobitsae" "0" "usp_DeleteTempTables"
command: DTExec/DTS "\MSDB\SRD_SAEToRS_ActualSalesDetails" /SERVER TOMXOBITSAE /CHECKPOINTING OFF /REPORTING V
Spreadsheet: 107421d1304596209-conditional-formating-how-i-could-accomplish-that-a1_a99
Sheet: Sheet1

1 | 1 | 1 | <<<<<<< | same results for both | >>>>>>>> | 1 |  |  | so
 |  | 1 | <<<<<<< | same results for both | >>>>>>>> | 1
 | 2 | 0 | <<<<<<< | same results for both | >>>>>>>> | 0 |  |  | does not check all 99 rows at once
 |  | 1 | <<<<<<< | same results for both | >>>>>>>> | 1 |  |  | else you would get false in this example
3 | 9 | 0 | <<<<<<< | same results for both | >>>>>>>> | 0 |  |  | as evidently there are some that do not match
 |  | 1 | <<<<<<< | same results for both | >>>>>>>> | 1
 |  | 1 | <<<<<<< | same results for both | >>>>>>>> | 1
2 | 5 | 0 | <<<<<<< | same results for both | >>>>>>>> | 0
 |  | 1 | <<<<<<< | same results for both | >>>>>>>> | 1
6 | 7 | 0 | <<<<<<< | same results for both | >>>>>>>> | 0
Spreadsheet: 267884d1380265339-count-of-data-a-column-drop-down-0a221
Sheet: Sheet1

name | property | count of data
agnes | GHS
 | SHM
 | SHGB
[NAME] | SKGR
juan | AJB
 | HGU
[NAME] | AJB
Spreadsheet: 24134d1214251667-header-help-emptest
Sheet: Bob 2 Steve

[NAME] 06 2008 56466
To Emp | Amount | Date
[NAME] | 12 | 2008-06-03 00:00:00
[NAME] | 25.2 | 2008-06-05 00:00:00
[NAME] | 3 | 2008-06-06 00:00:00
[NAME] | 8 | 2008-06-06 00:00:00
[NAME] | 9 | 2008-06-10 00:00:00
[NAME] | 1.35 | 2008-06-12 00:00:00
[NAME] | 1 | 2008-06-15 00:00:00
[NAME] | 0.75 | 2008-06-15 00:00:00
[NAME] | 4.32 | 2008-06-20 00:00:00
[NAME] | 1 | 2008-06-20 00:00:00
Spreadsheet: 550737d1512514591-are-if-thens-possible-in-excel-if_then-test_part-2
Sheet: Test

Name | Eff Date | Action | Reason | Most Recent Merit
[NAME] | 2016-01-01 00:00:00 | PAY | MER
[NAME] | 2017-01-01 00:00:00 | PAY | MER
[NAME] | 2017-02-11 00:00:00 | PAY | MER
[NAME] | 2017-03-10 00:00:00 | PAY | MER
[NAME] | 2017-06-11 00:00:00 | PAY | Not MER
[NAME] | 2017-10-01 00:00:00 | HIRE | MER
Mr T | 2017-01-01 00:00:00 | PAY | MER
Spreadsheet: 0249fc88-c20f-4dc0-a0ac-952f9fe5b384
Sheet: Sheet1

102-13 國小學生平均身高體重--按年齡別及性別分 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
93學年度
 | [NAME]) |  | 平均體重(kg)
 | 男 | 女 | 男 | 女
6-12歲平均 | 133.49 | 133.49 | 33.35 | 31.6
6歲 | 117.06 | 116 | 22.73 | 21.55
7歲 | 122.58 | 121.53 | 25.57 | 24.04
8歲 | 128.17 | 127.21 | 29.07 | 27.11
9歲 | 133.33 | 133.23 | 32.93 | 30.92
10歲 | 138.87 | 139.81 | 37.24 | 35.43
11歲 | 144.44 | 146.17 | 41.56 | 40.25
12歲 | 149.97 | 151.06 | 45.55 | 43.67
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Apr7-Apr13m

Main Arena
 | 2013-04-07 00:00:00 |  |  | Thru | 2013-04-13 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2013-04-07 00:00:00 | 2013-04-08 00:00:00 | 2013-04-09 00:00:00 | 2013-04-10 00:00:00 | 2013-04-11 00:00:00 | 2013-04-12 00:00:00 | 2013-04-13 00:00:00 |  |  |  | Blocks | Team | Hours
7:00AM |  |  |  |  |  |  |  | 7:00AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 04 Flags | 0
[NAME] |  |  |  |  |  |  |  | [NAME] |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 02 Flags | 0
[NAME] |  |  |  |  |  |  |  | [NAME] |  |  | 0 | 01 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 00 Flags | 0
10:00AM |  |  |  |  |  |  |  | 10:00AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 98 Flags | 0
11:00AM |  |  |  |  |  |  |  | 11:00AM |  |  | 0 | Midget A | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | Midget AA | 0
12:00PM |  |  |  |  |  |  |  | 12:00PM
1:00PM |  |  |  |  |  |  |  | 1:00PM
2:00PM |  |  |  |  |  |  |  | 2:00PM
3:00PM |  |  |  |  |  |  |  | 3:00PM
4:00PM |  |  |  |  |  |  |  | 4:00PM
5:00PM |  |  |  |  |  |  |  | 5:00PM
6:00PM |  |  |  |  |  |  |  | 6:00PM
7:00PM |  |  |  |  |  |  |  | 7:00PM
8:00PM |  |  |  |  |  |  |  | 8:00PM
9:00PM |  |  |  |  |  |  |  | 9:00PM
10:00PM |  |  |  |  |  |  |  | 10:00PM
11:00PM |  |  |  |  |  |  |  | 11:00PM
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: 840876d1693092661-return-split-values-in-a-dynamic-range-and-include-blanks-split-text-example
Sheet: Sheet1

Name |  | Current Result |  |  |  |  |  | Expected Result
[NAME] |  |  | [NAME] |  |  |  |  | [NAME] | [NAME]
Hortensia Gaius Aurelia Valentina Maximilla |  | Hortensia | Gaius | Aurelia | Valentina | [NAME] |  | Hortensia | Gaius | Aurelia | Valentina | [NAME]
[NAME] |  | Olivia | [NAME] |  |  |  |  | Olivia | [NAME]
[NAME] |  | [NAME] | de | la | Cruz |  |  | [NAME] | de | la | Cruz
[NAME] |  | Juan | Martin | Hernandez |  |  |  | Juan | Martin | Hernandez
[NAME] |  | Ava | [NAME] |  |  |  |  | Ava | [NAME]
[NAME] |  | [NAME] | White |  |  |  |  | [NAME] | White
[NAME] |  | Charlotte | [NAME] |  |  |  |  | Charlotte | [NAME]
Spreadsheet: 113732d1309546511-complex-drop-down-advfilclasswitheventcode
Sheet: Sheet2

Class | Student | Age |  |  |  | Class List | Student List
English |  |  |  |  |  | Spanish | Student 1
 |  |  |  |  |  | Math | Student 2
 |  |  |  |  |  | English | Student 3
Class | Student | Age |  |  |  | Physics | Student 4
English | Student 16 | 19 |  |  |  |  | Student 5
English | Student 17 | 20 |  |  |  |  | Student 6
English | Student 18 | 19 |  |  |  |  | Student 7
English | Student 19 | 20 |  |  |  |  | Student 8
English | Student 1 | 19 |  |  |  |  | Student 9
English | Student 2 | 19 |  |  |  |  | Student 10
English | Student 3 | 19 |  |  |  |  | Student 11
English | Student 4 | 20 |  |  |  |  | Student 12
English | Student 5 | 19 |  |  |  |  | Student 13
English | Student 6 | 19 |  |  |  |  | Student 14
 |  |  |  |  |  |  | Student 15
 |  |  |  |  |  |  | Student 16
 |  |  |  |  |  |  | Student 17
 |  |  |  |  |  |  | Student 18
 |  |  |  |  |  |  | Student 19
 |  |  |  |  |  |  | [NAME]
Spreadsheet: 102766d1300726702-sum-numerous-row-entries-for-expense-accounts-copy-of-test-sort-and-sum
Sheet: Sheet1

Date | Amount | Description |  |  |  |  |  | Row Labels | Sum of Amount
2010-04-01 00:00:00 | 31 | Bank charges |  |  |  |  |  | Accounting | 4490
2010-04-01 00:00:00 | 637 | Insurance |  |  |  |  |  | Bank charges | 254
2010-04-01 00:00:00 | 225 | Legal |  |  |  |  |  | Insurance | 4459
2010-04-01 00:00:00 | 500 | Legal |  |  |  |  |  | Legal | 6573
2010-04-01 00:00:00 | 500 | Other |  |  |  |  |  | Other | 1095.06
2010-04-01 00:00:00 | 225 | Rent |  |  |  |  |  | Rent | 3150
2010-04-01 00:00:00 | 500 | Rent |  |  |  |  |  | Revenue | -43500
2010-04-01 00:00:00 | -4000 | Revenue |  |  |  |  |  | Grand Total | -23478.94
2010-05-01 00:00:00 | 38 | Bank charges
2010-05-01 00:00:00 | 637 | Insurance
2010-05-01 00:00:00 | 225 | Legal
2010-05-01 00:00:00 | 231 | Legal
2010-05-01 00:00:00 | 225 | Rent
2010-05-01 00:00:00 | 500 | Accounting
2010-05-01 00:00:00 | 500 | Accounting
2010-05-01 00:00:00 | -8000 | Revenue
2010-05-01 00:00:00 | -7000 | Revenue
2010-06-01 00:00:00 | 39 | Bank charges
2010-06-01 00:00:00 | 637 | Insurance
2010-06-01 00:00:00 | 300 | Legal
2010-06-01 00:00:00 | 350 | Legal
2010-06-01 00:00:00 | 500 | Legal
2010-06-01 00:00:00 | 546 | Legal
2010-06-01 00:00:00 | 500 | Legal
2010-06-01 00:00:00 | 595.06 | Other
2010-06-01 00:00:00 | 300 | Rent
2010-06-01 00:00:00 | 350 | Rent
2010-06-01 00:00:00 | 343 | Accounting
2010-06-01 00:00:00 | 987 | Accounting
2010-06-01 00:00:00 | -5000 | Revenue
2010-06-01 00:00:00 | -6000 | Revenue
2010-07-01 00:00:00 | 41 | Bank charges
2010-07-01 00:00:00 | 637 | Insurance
2010-07-01 00:00:00 | 465 | Legal
2010-07-01 00:00:00 | 350 | Legal
2010-07-01 00:00:00 | 500 | Legal
2010-07-01 00:00:00 | 300 | Rent
2010-07-01 00:00:00 | 350 | Rent
2010-07-01 00:00:00 | 500 | Accounting
2010-07-01 00:00:00 | 63 | Accounting
2010-07-01 00:00:00 | -4500 | Revenue
2010-08-01 00:00:00 | 32 | Bank charges
2010-08-01 00:00:00 | 637 | Insurance
2010-08-01 00:00:00 | 79 | Legal
2010-08-01 00:00:00 | 500 | Legal
2010-08-01 00:00:00 | 300 | Rent
2010-09-01 00:00:00 | 36 | Bank charges
2010-09-01 00:00:00 | 637 | Insurance
2010-09-01 00:00:00 | 13 | Legal
2010-09-01 00:00:00 | 300 | Rent
2010-09-01 00:00:00 | 1597 | Accounting
2010-10-01 00:00:00 | 37 | Bank charges
2010-10-01 00:00:00 | 637 | Insurance
2010-10-01 00:00:00 | 56 | Legal
2010-10-01 00:00:00 | 1233 | Legal
2010-10-01 00:00:00 | 300 | Rent
2010-10-01 00:00:00 | -9000 | Revenue
Spreadsheet: 94895d1294667604-formula-to-calculate-from-a-different-sheet-ipr
Sheet: Snap Shot

Input Date | 2011-01-02 00:00:00
Name of Agent | Vivek Nair
[NAME] | 40545Vivek Nair
AUX 0 | 2342
AUX 1 | 234
AUX 2 | 2342
AUX 3 | 567
AUX 4 | 67567
AUX 5 | 7
AUX 6 | 567575
AUX 7 | 567
AUX 8 | 67567
AUX 9 | 5678
Spreadsheet: 707997d1607580652-xirr-keeping-first-cell-blank-in-some-columns-xirr-sample
Sheet: PivotTableXIRR

Sum of Amount | Fund Name
Date | FUND 03 | FUND 06 | FUND 08 | FUND 07 | FUND 09 | FUND 10 | FUND 11 | FUND 04 | FUND 13 | FUND 12 | FUND 01 | FUND 05 | FUND 02
2018-12-03 00:00:00 | 4999.98963 | 5000.007532000001 | 4999.97028 | 4999.996118999999
2018-12-10 00:00:00 | 14999.9832 | 14999.983232 | 15000.02596 | 15000.011637 | 19999.99374
2019-01-10 00:00:00 | 19999.98525 | 20000.019886 | 20000.05537 | 19999.991322 | 20000.010054
2019-02-11 00:00:00 | 19999.98712 | 20000.016902 | 20000.05668 | 19999.997262 | 20000.0163
2019-03-11 00:00:00 | 20000.01446 | 19999.991936 | 19999.9332 | 19999.990215 | 19999.98672
2019-04-10 00:00:00 | 19999.99848 | 20000.003114 | 19999.98378 | 20000.00805 | 19999.974204
2019-05-10 00:00:00 | 20000.00817 | 19999.98756 | 19999.95492 | 20000 | 20000.003579
2019-06-10 00:00:00 | 20000 | 20000 | 20000 | 20000 | 20000
2019-07-10 00:00:00 | 20000 | 20000 | 20000 | 20000 | 20000
2019-08-13 00:00:00 | 20000 | 20000 | 20000 | 20000 | 20000
2019-09-11 00:00:00 | 20000 | 20000 | 20000 | 20000 | 20000
2019-10-10 00:00:00 | 20000 | 20000 | 20000 | 20000 | 20000
2019-11-11 00:00:00 | 20000 | 20000 | 20000 | 20000 | 20000
2019-12-10 00:00:00 |  |  |  |  | 20000 | 20000 | 20000 | 20000 | 20000
2020-01-10 00:00:00 |  |  |  |  | 20000 | 20000 | 20000 | 20000 | 20000
2020-02-10 00:00:00 |  |  |  |  | 20000 | 20000 | 20000 | 20000 | 20000
2020-03-11 00:00:00 |  |  |  |  | 20000 | 20000 | 20000 | 20000 | 20000
2020-04-13 00:00:00 |  |  |  |  | 20000 | 20000 | 20000 | 20000 | 20000
2020-04-28 00:00:00 |  |  |  |  |  |  |  |  |  | 500000
2020-04-30 00:00:00 |  |  |  |  |  |  |  |  |  |  | 500000
2020-05-11 00:00:00 |  |  |  |  | 20000 | 20000 | 20000 | 20000 | 20000
2020-06-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 1000000 | 1000000
2020-06-10 00:00:00 |  |  |  |  | 20000 | 20000 | 20000 | 20000 | 20000
2020-06-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 500000 | 500000
2020-07-10 00:00:00 |  |  |  |  | 19999 | 19999 | 19999 | 19999 | 19999
2020-07-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 499975
2020-08-10 00:00:00 |  |  |  |  | 19999 | 19999 | 19999 | 19999 | 19999
2020-09-10 00:00:00 |  |  |  |  | 19999 | 19999 | 19999 | 19999 | 19999
2020-10-12 00:00:00 |  |  |  |  | 19999 | 19999 | 19999 | 19999 | 19999
2020-11-10 00:00:00 |  |  |  |  | 19999 | 19999 | 19999 | 19999 | 19999
 | -539211.71112 | -1525556.687006 | -331500.83874 | -291834.80368 | -2048463.15527 | -266952.57888 | -268034.4284360001 | -296151.65472 | -633893.4513000001 | -294550.06595 | -317048.30352 | -530055.3022301999 | -324962.3431573999
XIRR