Spreadsheet: 727496d1617909001-sumif-with-date-range-and-vlookup-for-user-id-pco-tax-deduction-certification-2020
Sheet: OLEDB

Specific Investor ID | ILIB Folder ID | Investor Type | GL Date | Contributions and Distributions | Trans Type | End Date
37377 |  | General Partner (GP) | 2020-10-21 00:00:00 | 500000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
26284 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 250000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
26294 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 125000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37317 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 125000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37318 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 507236.84 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
26285 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 250000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37319 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 125000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37320 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 500000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37321 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 250000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37322 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 175000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37473 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 250000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
26286 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 125000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
26287 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 375000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37367 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 183750 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37323 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 250000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37324 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 553750 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37325 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 125000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37368 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 125000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37326 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 150000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
26288 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 50000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37327 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 250000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
26289 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 250000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
27872 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 125000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37369 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 187500 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37370 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 62500 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37371 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 125000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37372 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 150000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37373 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 125000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37328 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 50000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37329 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 125000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
27874 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 250000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37432 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 62500 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37474 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 125000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37374 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 125000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
27875 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 250000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37475 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 125000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
26290 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 75000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37433 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 250000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
26291 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 200000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37330 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 250000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37331 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 250000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
27876 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 250000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37332 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 1750000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
26292 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 175000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37476 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 125000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37409 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 125000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
26293 |  | Limited Partner (LP) | 2020-10-21 00:00:00 | 250000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
37318 |  | Limited Partner (LP) | 2021-02-26 00:00:00 | 118421.05 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
38855 |  | Limited Partner (LP) | 2021-02-26 00:00:00 | 125000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
38856 |  | Limited Partner (LP) | 2021-02-26 00:00:00 | 750000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
38857 |  | Limited Partner (LP) | 2021-02-26 00:00:00 | 312500 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00
38858 |  | Limited Partner (LP) | 2021-02-26 00:00:00 | 125000 | Partners' Capital - Contributions - Investments | 2021-04-06 00:00:00