tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 58615d1258850799-creating-refreshable-cheat-sheets-lookupclients
Sheet: Sheet2

client name 1 | client 1 ref | client 1 address | client 1 country
client name 2 | client 2 ref | client 2 address | client 2 country
client name 3 | client 3 ref | client 3 address | client 3 country
client name 4
client name 5
client name 6
client name 7
client name 8
client name 9
client name 10
client name 11
client name 12
client name 13
client name 14
client name 15
client name 16
client name 17
client name 18
client name 19
client name 20
client name 21
client name 22
client name 23
client name 24
client name 25
client name 26
client name 27
client name 28
client name 29
client name 30
client name 31
client name 32
client name 33
client name 34
client name 35
client name 36
client name 37
client name 38
client name 39
client name 40
client name 41
client name 42
client name 43
client name 44
client name 45
client name 46
client name 47
client name 48
client name 49
client name 50
client name 51
client name 52
client name 53
client name 54
client name 55
client name 56
client name 57
client name 58
client name 59
client name 60
client name 61
client name 62
client name 63
client name 64
client name 65
client name 66
client name 67
client name 68
client name 69
client name 70
client name 71
client name 72
client name 73
client name 74
client name 75
client name 76
client name 77
client name 78
client name 79
client name 80
client name 81
client name 82
client name 83
client name 84
client name 85
client name 86
client name 87
client name 88
client name 89
client name 90
client name 91
client name 92
client name 93
client name 94
client name 95
client name 96
client name 97
client name 98
client name 99
client name 100
client name 101
client name 102
client name 103
client name 104
client name 105
client name 106
client name 107
client name 108
client name 109
client name 110
client name 111
client name 112
client name 113
client name 114
client name 115
client name 116
client name 117
client name 118
client name 119
client name 120
client name 121
client name 122
client name 123
client name 124
client name 125
client name 126
client name 127
client name 128
client name 129
client name 130
client name 131
client name 132
client name 133
client name 134
client name 135
client name 136
client name 137
client name 138
client name 139
client name 140
client name 141
client name 142
client name 143
client name 144
client name 145
client name 146
client name 147
client name 148
client name 149
client name 150
Spreadsheet: 01a92309-b87a-4be2-9b28-03cb974be662
Sheet: Sheet1

Season Schedule | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Date | Game Number | Visiting Team | Visiting Score | Home Team | Home Score | Game Time/Status | Venue
2013-04-27 | 1 | W-B/Scranton | 3 | [NAME] | 2 | Final OT | Broome County Veterans Memorial Arena Binghamton, NY
2013-04-28 | 2 | W-B/Scranton | 3 | [NAME] | 2 | Final | Broome County Veterans Memorial Arena Binghamton, NY
2013-05-02 | 3 | [NAME] | 2 | W-B/Scranton | 3 | Final | [NAME] Arena at Casey Plaza Wilkes-Barre, PA
2013-05-10 | 1 | W-B/Scranton | 5 | Providence | 8 | Final | Dunkin' Donuts Center Providence, RI
2013-05-11 | 2 | W-B/Scranton | 2 | Providence | 4 | Final | Dunkin' Donuts Center Providence, RI
2013-05-15 | 3 | Providence | 2 | W-B/Scranton | 1 | Final OT | [NAME] Arena at Casey Plaza Wilkes-Barre, PA
2013-05-17 | 4 | Providence | 1 | W-B/Scranton | 3 | Final | [NAME] Arena at Casey Plaza Wilkes-Barre, PA
2013-05-18 | 5 | Providence | 0 | W-B/Scranton | 4 | Final | [NAME] Arena at Casey Plaza Wilkes-Barre, PA
2013-05-20 | 6 | W-B/Scranton | 2 | Providence | 1 | Final OT | Dunkin' Donuts Center Providence, RI
2013-05-22 | 7 | W-B/Scranton | 5 | Providence | 0 | Final | Dunkin' Donuts Center Providence, RI
2013-05-25 | 1 | W-B/Scranton | 4 | Syracuse | 2 | Final | Onondaga County War Memorial Arena Syracuse, NY
2013-05-26 | 2 | W-B/Scranton | 2 | Syracuse | 3 | Final | Onondaga County War Memorial Arena Syracuse, NY
2013-05-29 | 3 | Syracuse | 2 | W-B/Scranton | 0 | Final | [NAME] Arena at Casey Plaza Wilkes-Barre, PA
2013-05-31 | 4 | Syracuse | 4 | W-B/Scranton | 2 | Final | [NAME] Arena at Casey Plaza Wilkes-Barre, PA
2013-06-01 | 5 | W-B/Scranton | 0 | Syracuse | 7 | Final | Onondaga County War Memorial Arena Syracuse, NY
Spreadsheet: benjamin_rogers__1198__Calpine version 3
Sheet: Returns Analysis

RETURNS ANALYSIS
 | 0
('000 $) | Close
EBITDA | 0
Less Interest Payments | 0
Pre-Tax Cashflow
Less Cash Taxes | 0
Less Principal Payments | 0
Less Capex | 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
Cashflow to Equity
Distribution to Equity | 1
Equity RROR | 0.14
Beginning Balance
RROR Target Coupon | 0
Actual Cash Flow
Equity Paydown | 0
Ending Balance
ENRON'S RETURNS ANALYSIS
Zero Residual Value
Equity Return
Actual Cash Flow
Total Cash Flow
 | IRR
Equity Return
Actual Cash Flow
Residual Value | 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
Total Cash Flow
 | IRR
Equity Return
Actual Cash Flow
Residual Value | 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
Total Cash Flow
 | IRR
Equity Return
Actual Cash Flow
Residual Value | 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
Total Cash Flow
 | IRR
Spreadsheet: 43815d1242407939-searching-for-data-from-two-sources-upload-test1
Sheet: upload 1

vendor number | doc number | clearing doc | date posted | amount
[PHONE] | 0450358 | 84003411 | 2008-01-17 00:00:00 | -350
[PHONE] | 0451477 | 84004866 | 2008-01-24 00:00:00 | -130
[PHONE] | 0448470 | 84000782 | 2008-01-07 00:00:00 | -72.86
[PHONE] | 0447933 | 84000231 | 2008-01-03 00:00:00 | -2501.38
[PHONE] | 0447934 | 84000232 | 2008-01-03 00:00:00 | -3501.93
[PHONE] | 0450890 | 84003939 | 2008-01-21 00:00:00 | -600
[PHONE] | 0451535 | 84004924 | 2008-01-24 00:00:00 | -34862.98
[PHONE] | 0447994 | 84000289 | 2008-01-03 00:00:00 | -825
[PHONE] | 0448001 | 84000296 | 2008-01-03 00:00:00 | -844.38
[PHONE] | 0448316 | 84000629 | 2008-01-07 00:00:00 | -1200
[PHONE] | 0451265 | 84004657 | 2008-01-24 00:00:00 | -1200
[PHONE] | 0450176 | 84003231 | 2008-01-17 00:00:00 | -600
[PHONE] | 0450181 | 84003236 | 2008-01-17 00:00:00 | -50
[PHONE] | 0448513 | 84000825 | 2008-01-07 00:00:00 | -500
 | 0450730 | 84003782 | 2008-01-17 00:00:00 | -24.2
 | 0452162 | 84005964 | 2008-01-31 00:00:00 | -128.2
 | 0448868 | 84001543 | 2008-01-10 00:00:00 | -505
 | 0451882 | 84005485 | 2008-01-29 00:00:00 | -968
Spreadsheet: 714636d1611316201-can-not-use-array-formulas-need-to-pull-a-list-and-cross-check-on-multiple-criteria-example-4-ans
Sheet: Main Street

Activity | Sub-object |  |  |  | NOTE the changes in header. It should exactly match with the header in Expences Detail Sheet.
1000 | 195
FY 2020 |  |  |  | Cross Check
Document date | VENDOR_NAME | Invoice # | GL Amount | Posted Amount
 |  |  |  |  | Manually entered
 |  |  |  |  | Continue to pull data so it is not manually entered
Spreadsheet: 48648d1247853303-conditional-formatting-with-colour-cf-examples
Sheet: Sheet2

thingy 1 | 12 | 20
thingy 2 | 1 | 20
thingy 3 | 25 | 50
thingy 4 | 10 | 100
thingy 5 | 11 | 100
thingy 6 | 2 | 20
thingy 7 | 3 | 20
or
thingy 1 | 12 | 20
thingy 2 | 1 | 20
thingy 3 | 25 | 50
thingy 4 | 10 | 100
thingy 5 | 11 | 100
thingy 6 | 2 | 20
thingy 7 | 3 | 20
or
thingy 1 | 12 | 20
thingy 2 | 1 | 20
thingy 3 | 25 | 50
thingy 4 | 10 | 100
thingy 5 | 11 | 100
thingy 6 | 2 | 20
thingy 7 | 3 | 20
Spreadsheet: 841776d1693934121-smoothly-create-an-exponential-graph-in-which-the-relation-between-the-accuracy-and-evasio-accuracyevasionanalysismrshorty-copy
Sheet: post18and19

 |  |  | f1 | 1.165 |  |  | 1.165 |  |  | target points given throughout the thread
 |  |  | f2 | not used
row# | [NAME] | Evasion | Chance to Hit | a(post 18) | b(post 18) |  | a(19) | b(19) |  | row# | x | y | a
1 | 3 | -0.5 | 6 |  |  |  |  |  |  | 30 | 0.1 | -0.4 | 0.25
2 | 2.9 | -0.4 | 4.83 |  |  |  |  |  |  | 31 | 0 | -0.5 | 0.375
3 | 2.8 | -0.3 | 4 |  |  |  |  |  |  | 32 | -0.1 | -0.4 | >0
4 | 2.7 | -0.2 | 3.38 |  |  |  |  |  |  | 31 | 0 | -0.5 | 0.25
5 | 2.6 | -0.1 | 2.89 |  |  |  |  |  |  |  | 0.1 | -0.5 | 0.35
6 | 2.5 | 0 | 2.5 |  |  |  |  |  |  | 25 | 0.6 | 0.1 | 0.55
7 | 2.4 | 0.1 | 2.18
8 | 2.3 | 0.2 | 1.92
9 | 2.2 | 0.3 | 1.69
10 | 2.1 | 0.4 | 1.5
11 | 2 | 0.5 | 1.33
12 | 1.9 | 0.6 | 1.19
13 | 1.8 | 0.7 | 1.06
14 | 1.7 | 0.8 | 0.94
15 | 1.6 | 0.9 | 0.84
16 | 1.5 | 1 | 0.75
17 | 1.4 | 0.9 | 0.74
18 | 1.3 | 0.8 | 0.72
19 | 1.2 | 0.7 | 0.71
20 | 1.1 | 0.6 | 0.69
21 | 1 | 0.5 | 0.67
22 | 0.9 | 0.4 | 0.64
23 | 0.8 | 0.3 | 0.62
24 | 0.7 | 0.2 | 0.58
25 | 0.6 | 0.1 | 0.55
26 | 0.5 | 0 | 0.5
27 | 0.4 | -0.1 | 0.44
28 | 0.3 | -0.2 | 0.38
29 | 0.2 | -0.3 | 0.29
30 | 0.1 | -0.4 | 0.17
31 | 0 | -0.5 | 0
32 | -0.1 | -0.4 | -0.06
33 | -0.2 | -0.3 | -0.14
34 | -0.3 | -0.2 | -0.24
35 | -0.4 | -0.1 | -0.36
36 | -0.5 | 0 | -0.5
37 | -0.6 | 0.1 | -0.66
38 | -0.7 | 0.2 | -0.84
39 | -0.8 | 0.3 | -1.04
40 | -0.9 | 0.4 | -1.26
41 | -1 | 0.5 | -1.5
42 | -1.1 | 0.6 | -1.76
43 | -1.2 | 0.7 | -2.04
44 | -1.3 | 0.8 | -2.34
45 | -1.4 | 0.9 | -2.66
46 | -1.5 | 1 | -3
47 | -1.6 | 0.9 | -3.04
48 | -1.7 | 0.8 | -3.06
49 | -1.8 | 0.7 | -3.06
50 | -1.9 | 0.6 | -3.04
51 | -2 | 0.5 | -3
52 | -2.1 | 0.4 | -2.94
53 | -2.2 | 0.3 | -2.86
54 | -2.3 | 0.2 | -2.76
55 | -2.4 | 0.1 | -2.64
56 | -2.5 | 0 | -2.5
57 | -2.6 | -0.1 | -2.34
58 | -2.7 | -0.2 | -2.16
59 | -2.8 | -0.3 | -1.96
60 | -2.9 | -0.4 | -1.74
61 | -3 | -0.5 | -1.5
Spreadsheet: 2a86f1f4-632a-4dde-a74f-4e2e98ebbb57
Sheet: Sheet1

Title | Creator/Author | Publication Date | OSTI Identifier | Report Number(s) | DOE Contract Number | Other Number(s) | Resource Type | Specific Type | Resource Relation | Research Org. | Sponsoring Org. | Subject | Related Subject | Description/Abstract | Contributor Organizations | Host Website | Format | Availability | DOI | Full Text
[NAME] (PACIFic ocean Interior CArbon) Database:  A Data Synthesis Resource (NDP-92, ORNL/CDIAC-159) | Suzuki, T.; Ishii, M.; Aoyama, M. R; Christian, [NAME]; [NAME], K.; Kawano, T.; Key, R. M.; Kosugi, N.; Kozyr, A.; [NAME], [NAME]; Murata, A.; Nakano, T.; Ono, T.; Saino, T.; Sasaki, K.; Sasano, D; Takatani, [NAME]; Wakita, M.; Sabine, C. |  | 1091305 |  |  |  | Collection |  |  |  | USDOE SC Office of Biological and Environmental Research; North Pacific Marine Science Organization (PICES) Section of Carbon and Climate (S-CC) |  | PACIFICA; dissolved inorganic carbon; total alkalinity; nutrients; dissolved oxygen; WOCE; GLODAP; CLIVAR; Pacific Ocean | [NAME] (PACIFic ocean Interior CArbon) was an international collaborative project for synthesis of data on ocean interior carbon and its related parameters in the Pacific Ocean. The North Pacific Marine Science Organization (PICES), Section on Carbon and Climate (S-CC) supported the project. [NAME]/hydrochemical datasets have been merged from a total of 272 cruises, including those from cruises conducted between the late 1980s and 2000 but not included in GLODAP, as well as CLIVAR/CO2 Repeat Hydrography datasets from the 2000s. Adjustments were calculated to account for analytical offsets in dissolved inorganic carbon, total alkalinity, salinity, oxygen, and nutrients (nitrate and nitrite, phosphate, and silicic acid) for each cruise as a result of the secondary quality control procedure, based on crossover analysis using data from deep layers (Tanhua et al., 2010). A total of 59 adjusted datasets from Line P off the west coast of Canada were also merged. Finally, the authors have produced the adjusted PACIFICA database that consists of datasets from a total of 306 cruises that also includes 34 datasets from WOCE Hydrographic Program cruises in the Pacific Ocean conducted in the 1990s. The PACIFICA database is available free of charge as a numeric data package (NDP-92) from the Carbon Dioxide Information Analysis Center (CDIAC) and the primary PACIFICA data site at pacifica.pices.jp. The NDP consists of the original cruise data files, adjusted data product, and the documentation. |  | Carbon Dioxide Information Analysis Center (CDIAC) |  |  |  | http://www.osti.gov/dataexplorer/servlets/purl/1091305
Spreadsheet: 471978d1469374722-lookup-values-from-two-columns-and-calculate-accordingly-copy-of-datamodelprogressdummy-ndm
Sheet: Pivot Table

Month | (All)
District | Crop | Min | [NAME] | Average Progress
Ditrict1 | [NAME] | 10 | 500 | 89
 | Crop2 | 100 | 500 | 33.83333333333334
Ditrict2 | [NAME] | 10 | 500 | 42
 | Crop2 |  |  | 0
[NAME] | [NAME] |  |  | 0
 | Crop2 |  |  | 0
Ditrict4 | [NAME] |  |  | 0
 | Crop2 |  |  | 0
Ditrict5 | [NAME] |  |  | 0
 | Crop2 |  |  | 0
Spreadsheet: 765408d1643305356-count-if-formula-date-issue-count-if-by-date-example
Sheet: Sheet1

Name | Date | Completed |  | Wanted Output |  |  | [NAME]
[NAME] | 2022-01-08 01:07:08 | Yes |  | Date | Count of Completed by Date |  | Date | Count of Completed by Date
[NAME] | 2022-01-08 07:13:57 | Yes |  | 2022-01-08 00:00:00 | 2
[NAME] | 2022-01-08 02:17:21.450000 | No |  | 2022-01-09 00:00:00 | 1 |  | 2022-01-09 00:00:00
[NAME] | 2022-01-09 15:51:47 | Yes |  | 2022-01-10 00:00:00 | 0 |  | 2022-01-10 00:00:00
Sal | 2022-01-10 16:10:59 | No
Spreadsheet: 149361d1333879840-help-with-pivot-tables-multiple-chart-from-one-pivot-table_jpr73
Sheet: PT_PC

 | Values
City | Supp | App | %
Leeds | 20 | 163 | 0.1226993865030675
Liverpool | 19 | 189 | 0.1005291005291005
London | 32 | 250 | 0.128
[NAME] | 15 | 176 | 0.08522727272727272
Total général | 86 | 778 | 0.4364557597594407
Spreadsheet: 104026d1301650143-balance-calculation-sample_shaj
Sheet: Search Criteria

Executive Wise |  | Status Wise |  | Date Format |  | AGM |  | Pymnt |  | Customer
[NAME] |  | Cleared |  | MM/DD/YY |  | [NAME] |  | January |  | Mr. [NAME]
[NAME] |  | Due |  |  |  | - |  | February |  | Mrs. [NAME]
 |  | Processing |  |  |  | - |  | March |  | Dr. [NAME]
 |  |  |  |  |  | - |  | April |  | Mr. [NAME]
 |  |  |  |  |  | - |  | May |  | Mrs. [NAME]
 |  |  |  |  |  | - |  | June |  | Dr. [NAME]
 |  |  |  |  |  | - |  | July |  | Dr. [NAME]
 |  |  |  |  |  | - |  | August |  | Dr. [NAME]
 |  |  |  |  |  |  |  |  |  | Dr. [NAME]
Spreadsheet: 47c47a18-1b57-4997-b1fb-c167e49f8009
Sheet: Sheet1

Campus | Last Name | First Name | [NAME] | Phone Number | Fax Number | Street | Street2 | City | State | Zip
Appalachian State University | Everts | [NAME] | [EMAIL] | [PHONE] | [PHONE] | Academy Drive |  | Boone | NC | 28608
East Carolina University | Ballard | Dr. [NAME] | [EMAIL] | [PHONE] |  | East Fifth Street |  | Greenville | NC | 27858
Elizabeth City State University | Becton | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1704 Weeksville Road |  | Elizabeth City | NC | 27909
Fayetteville State University | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1200 Murchison Road |  | Fayetteville | NC | 28301
NC Agricultural and Technical State University | Martin | Harold | [EMAIL] | [PHONE] | [PHONE] | 1601 East Market Street |  | Greensboro | NC | 27411
North Carolina Central University | Saunders-White | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1801 Fayetteville Street |  | [NAME] | NC | 27707
NC State University | Woodson | [NAME] | [EMAIL] | [PHONE] | [PHONE] |  |  | Raleigh | NC | 27695
UNC Asheville | Ponder | Anne | [EMAIL] | [PHONE] | [PHONE] | 1 University Heights |  | Asheville | NC | 28804
UNC-Chapel Hill | Folt | Carol | [EMAIL] | [PHONE] | [PHONE] |  |  | Chapel Hill | NC | 27599
UNC Charlotte | Dubois | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 9201 University City Boulevard |  | Charlotte | NC | 28223
UNC Greensboro | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | Post Office Box 26170 |  | Greensboro | NC | 27402
UNC Pembroke | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1 University Drive |  | Pembroke | NC | 28372
[NAME] | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 601 South College Road |  | [NAME] | NC | 28403
UNC School of the Arts | Moeser | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1533 South Main St. |  | Winston-Salem | NC | 27127
Western Carolina University | Belcher | [NAME] | [EMAIL] | [PHONE] | [PHONE] |  |  | Cullowhee | NC | 28723
Winston-Salem State University | Reaves | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 601 [NAME], Jr. Drive |  | Winston-Salem | NC | 27110
North Carolina School of Science and Mathematics | [NAME] | J. | [EMAIL] | [PHONE] | [PHONE] | 1219 Broad Street |  | [NAME] | NC | 27705
Spreadsheet: 90246d1290002838-excel-2007-trying-to-extract-data-from-an-excel-data-only-file-serv-tm-invd-a-
Sheet: Sheet1

N Alabama Team | Page -1 of 1
DC1A | NDC Team | DC Service | #WOs | #Seg | Invoiced Hours | Dock/Gain | Actual Hours | Labor $$ | Parts $$ | Misc $$ | Total $$ | 250 | 466 | 852.9 | 18.6 | 1098.4 | 65219.0832 | 60737.4214 | 53.54 | 126010.0446 | N Alabama Team | $$ Per Hour | 59.37644136926438 | P to Lbr % | 93.12829684180534 | PP/Lbr Hr | 55.29626857246905
External | 1 | #WOs | #Seg | Inv Hours | Dock/Gain | Actual Hours | % Total | Labor $$ | $$ Per Hour | Misc $$ | Parts $$ | P to Lbr % | PP/Lbr Hr | Total $$ | 127 | 231 | 458.6 | 16.3 | 446.8 | 40.67734887108522 | 41783.3434 | 93.51688316920323 | 53.54 | 49811.91189999999 | 119.2147584340989 | 111.4859263652641 | 91648.7953
The # of rows between the external and interanal data varies with each team and can change from month to month.
Internal | 2 | #WOs | #Seg | Inv Hours | Dock/Gain | Actual Hours | % Total | Labor $$ | $$ Per Hour | Misc $$ | Parts $$ | P to Lbr % | PP/Lbr Hr | Total $$ | 118 | 194 | 386.9 | 7.4 | 386.9 | 35.22396212672979 | 22827.0998 | 58.99999948307056 | 0 | 7148.2095 | 31.31457593224348 | 18.47559963814939 | 29975.3093
[NAME] | Total Invoice Days: | 18 | Avg Labor $ P/Day: | 1066.261111111111 | [NAME] $ P/Day: | 258.4183166666667 | Avg Labor Hours P/Day: | 18.07222222222222 | #WOs | #Seg | Inv Hours | Dock/Gain | Actual Hours | % Total | Labor $$ | $$ Per Hour | Misc $$ | Parts $$ | P to lbr % | P P/Lbr Hr | Total $$ | 103 | 168 | 325.3 | 7.4 | 325.3 | 29.61580480699199 | 19192.7 | 59 | 0 | 4651.5297 | 24.23593189077097 | 14.29919981555487 | 23844.2297
Spreadsheet: 743869d1628788076-calculating-xirr-while-ignoring-zeros-xirr
Sheet: XIRR

 | Date | 1
 | 2021-01-28 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | -9250 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2021-02-17 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -10169.98 | 0 | 0 | 0 | 0 | 0
 | 2021-03-04 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -8367 | 0 | 0 | 0 | 0 | 0
 | 2021-03-05 00:00:00 | 0 | 0 | -10000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2021-03-05 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -10500 | 0 | 0 | 0 | 0
 | 2021-03-05 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -13500 | 0 | 0 | 0 | 0 | 0 | 0
 | 2021-03-19 00:00:00 | -11700 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2021-03-24 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -14700 | 0
 | 2021-03-25 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -9420 | 0 | 0 | 0
 | 2021-04-20 00:00:00 | 0 | 0 | 0 | -13000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2021-05-04 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -13875 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2021-06-25 00:00:00 | 0 | 0 | 0 | 0 | -17500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2021-07-06 00:00:00 | 0 | 0 | -10000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2021-07-08 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -11250 | 0 | 0
 | 2021-07-13 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -12000 | 0 | 0 | 0
 | 2021-07-14 00:00:00 | 0 | 0 | 0 | 0 | 0 | -11250 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2021-07-15 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -13500 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2021-07-16 00:00:00 | 0 | -11986.48 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2021-07-19 00:00:00 | 0 | 0 | -17500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2021-08-09 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -5200
 | 2021-08-09 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -12000 | 0 | 0 | 0 | 0
 | 2021-08-11 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -12623.04
 | 2021-08-11 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1840.72
 |  | 15958.5 | 11216 | 41400 | 12302 | 19288.25 | 13362.425 | 12915 | 28904.25 | 20392.5 | 23736 | 23774 | 23226.75 | 10642 | 23642.5 | 19634.25
Spreadsheet: 117112d1312457646-matching-data-form-multiple-columns-multiple-match-3-
Sheet: eg3

Model | Capacity | Fuel | Conversion | Helper
RXA | 10 | Husk | 15 | RXA||10||Husk
SGI | 15 | Coal | 12 | SGI||15||Coal
HPBB | 20 | Wood | 11 | HPBB||20||Wood
IFB | 10 | Coal | 10.5 | IFB||10||Coal
CPD | 15 | LDO | 14.5 | CPD||15||LDO
CPFD | 30 | HSD | 13 | CPFD||30||HSD
SMDH | 40 | FO | 16 | SMDH||40||FO
TPD | 20 | Gas | 18 | TPD||20||Gas
VTB | 20 | Briquette | 11 | VTB||20||Briquette
Example 3:
RXA | 10 | Husk | 15
Spreadsheet: 488590d1478723748-counting-of-dates-mini-macro-tracker
Sheet: Remaining Data

Remaining | Task 60 |  | Task 325 | Task 327 | Task 329 |  | Task 398 | Task 500 EC | Task 619 2500 | Task 627 800
 | Candidate selection | RFDS | Permit | CLLI Submitted | CLLI Complete | CIQ Complete | AZP | Construction Estimation | 2500 OA | 800 OA
Central Illinois | 65
Central Iowa | 34
Chicago | 705 | 21 |  |  |  | 17
Cincinnati | 202 | 4 |  |  |  | 3
Cleveland | 238 | 12 |  |  |  | 11
Columbus | 193
Dakotas | 13
East Iowa | 47
East Kentucky | 19
East Michigan | 357 | 1
Ft. Wayne / South Bend | 72 | 3 |  |  |  | 2
Indianapolis | 210 | 37 |  |  |  | 22
Kansas | 277 | 9 |  |  |  | 2
Milwaukee | 194 | 5 |  |  |  | 3
Minnesota | 276 | 29 |  |  |  | 29
Missouri | 191 | 2 |  |  |  | 1
North Wisconsin | 94 | 4
Pittsburgh | 148 | 4
Toledo | 35
West Iowa / Nebraska | 152
West Kentucky | 70 | 1
West Michigan | 100 | 1
Western Pennsylvania
Grand Total
Row Labels | Count of SR_T60_PCAND_APPV_AC | Count of TASK_325_PERMITS_APPROVED_AC | Count of TASK_398_AZP_COMPLETE_AC | Count of TASK_500_3G_CNSTRCTN_CMPLT_EC | Count of TASK_619_2500MHZ_OA_COM_SVC_AC | Count of TASK_627_4G_800_ON_AIR_AC
Central Illinois | 34 |  |  | 34
Central Iowa | 24 |  |  | 22
Chicago | 386 | 113 | 9 | 380 | 7
Cincinnati | 153 | 11 |  | 150
Cleveland | 147 | 25 | 6 | 147 | 1
Columbus | 152 | 5 |  | 152
Dakotas | 5 |  |  | 5
East Kentucky | 1 |  |  | 1
East Michigan | 114 | 5 |  | 110
Ft. Wayne / South Bend | 49 | 6 |  | 49
Indianapolis | 171 | 71 | 5 | 171 | 3
Kansas | 166 | 43 |  | 166
Milwaukee | 99 | 6 |  | 94
Minnesota | 172 | 35 | 29 | 170 | 22
Missouri | 68 | 3 |  | 68
North Wisconsin | 52 | 7 |  | 47
Pittsburgh | 120 | 6 |  | 117
Toledo | 25 | 1 |  | 25
West Iowa / Nebraska | 97 |  |  | 97
West Kentucky | 43 | 2 |  | 43
West Michigan | 47 | 1 |  | 47
(blank)
Grand Total | 2125 | 340 | 49 | 2095 | 33
Spreadsheet: 845116d1696647108-need-to-adapt-sum-product-to-measure-calendar-and-work-days-each-week-between-dates-ochimus-gannts-by-week-number-and-month-root_
Sheet: Calendar Days

ACTIVITY | Category | Start date | End Date | Checksum
Activity 01 | Planned | 2023-01-03 00:00:00 | 2023-01-10 00:00:00
 | Actual | 2023-02-14 00:00:00 | 2023-06-28 00:00:00
Activity 02 | Planned | 2023-02-23 00:00:00 | 2023-07-06 00:00:00
 | Actual | 2023-03-19 00:00:00 | 2023-05-12 00:00:00
Activity 03 | Planned | 2023-03-11 00:00:00 | 2023-05-24 00:00:00
 | Actual | 2023-03-16 00:00:00 | 2023-06-25 00:00:00
Activity 04 | Planned | 2023-04-09 00:00:00 | 2023-09-23 00:00:00
 | Actual | 2023-05-11 00:00:00 | 2023-10-05 00:00:00
 |  |  | TOTAL:
(A) GANTT BY WEEK NUMBERS:
ACTIVITY | WEEK: | 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
Activity 01 | Planned
 | Actual
Activity 02 | Planned
 | Actual
Activity 03 | Planned
 | Actual
Activity 04 | Planned
 | Actual
 | Worked
 | Cum
(B) GANTT BY MONTHS:
ACTIVITY | MONTH: |  |  |  |  |  |  |  |  |  |  |  |  | Checksum
Activity 01 | Planned
 | Actual
Activity 02 | Planned
 | Actual
Activity 03 | Planned
 | Actual
Activity 04 | Planned
 | Actual
 | Worked
 | Cum