tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 544174d1508785697-conditionally-summing-across-a-varying-number-of-worksheets-example-book
Sheet: Summary

 | Totals From Below
Year = | Check |  |  |  |  |  |  | [NAME] where sumrange is sheets A:Z column E, criteria 1 is sheets A:Z column C where it equals Sell, criteria 2 is sheets A:Z column J equals cell $a$3 on the current worksheet | Same as previous except sumrange is sheets A:Z column G | These use unmentioned columns but I think once I have an example
2016 | Difference |  |  |  |  |  |  |  |  | I should be able to figure them out by substituing in the appropriate
 |  |  |  |  |  |  |  |  |  | colomuns as it is all done using sumifs
Tab# | Stock Name | Units Sold | Proceeds | Basis | Gain/Loss | Ending Units |  | So it would take the values 3256,3256,2845,2844 and add them
1 | Stock 1 | 0 | 0 | 0 |  | 2500 |  | As those are units sold in 2016 across the 3 numbered sheets
2 | Stock 2 | -6512 | 22562 | 18962 |  | 4506
3 | Stock 3 | -5689 | 20496 | 20685 |  | 652
4 | #[NAME]
5 | #[NAME]
6 | #[NAME]
7 | #[NAME]
8 | #[NAME]
9 | #[NAME]
10 | #[NAME]
11 | #[NAME]
12 | #[NAME]
13 | #[NAME]
14 | #[NAME]
15 | #[NAME]
16 | #[NAME]
17 | #[NAME]
18 | #[NAME]
19 | #[NAME]
20 | #[NAME]
21 | #[NAME]
22 | #[NAME]
etc going down as far as needed. | Only shows a name when the tab # exists between A and Z | Uses a formula to calc using multiple indirects shows 0 when no name in stock name | Uses a formula to calc using multiple indirects shows 0 when no name in stock name | Uses a formula to calc using multiple indirects shows 0 when no name in stock name | Shows as 0 when no name in stock name | Uses a formula to calc using multiple indirects shows 0 when no name in stock name
Spreadsheet: 695096d1600050485-need-help-to-insert-a-value-after-multiple-occurrences-of-a-value-sample
Sheet: Sheet1

 |  |  |  |  |  |  | Tq
 |  |  |  |  |  |  | DA
 |  |  |  |  |  |  | WA
 |  |  |  |  |  |  | CH
 |  |  |  |  |  |  | CH
 |  |  |  |  |  |  | KA
 |  |  |  |  |  |  | BA
 |  |  |  |  |  |  | ST
 |  |  |  |  |  |  | NW
 |  |  |  |  |  |  | NY
 |  |  |  |  |  |  | NY
 |  |  |  |  |  |  | NY
 |  |  |  |  |  |  | CA
 |  |  |  |  |  |  | NO
 |  |  |  |  |  |  | GN
 |  |  |  |  |  |  | OA
 |  |  |  |  |  |  | BU
 |  |  |  |  |  |  | IN
 |  |  |  |  |  | 2009.4.14 | CI
 |  |  |  |  |  | 2009.5.1 | CI
 |  |  |  |  |  | 2009.5.1 | CI
 |  |  |  |  |  | 2017.3.3 | CA
 |  |  |  |  |  | 2017.3.3 | CA
 |  |  |  |  |  | 2017.3.3 | NO |  | <--- should also be a number 1 here
 |  |  |  |  |  | 2017.3.4 | BU
 |  |  |  |  |  | 2017.3.4 | DE
 |  |  |  |  |  |  | MI
 |  |  |  |  |  |  | NY
 |  |  |  |  |  |  | TA
 |  |  |  |  |  |  | TA
 |  |  |  |  |  |  | DE
 |  |  |  |  |  |  | SE
 |  |  |  |  |  |  | JA
 |  |  |  |  |  |  | JA
 |  |  |  |  |  |  | SF
 |  |  |  |  |  |  | SF
 |  |  |  |  |  |  | CL
 |  |  |  |  |  |  | CL
 |  |  |  |  |  |  | PI
 |  |  |  |  |  |  | PI
 |  |  |  |  |  |  | PI
Spreadsheet: darrell_schoolcraft__7585__imball0112
Sheet: Conoco

 | Maljamar |  | Zia |  |  |  |  |  |  |  |  | Avg
Day | Measured | Scheduled | Measured | Scheduled |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
1 | 34725 | 33702 | 34933 | 32000
2 | 34843 | 33589 | 35369 | 32000 |  |  | 2001-03-01 00:00:00 |  |  |  | 4.98
3 | 34085 | 33702 | 37069 | 32000 |  |  | 2001-04-01 00:00:00 |  |  |  | 4.87
4 | 36422 | 35544 | 34771 | 29872 |  |  | 2001-05-01 00:00:00 |  |  |  | 3.82
5 | 36277 | 33702 | 30329 | 32000 |  |  | 2001-06-01 00:00:00 |  |  |  | 3.2
6 | 40078 | 36144 | 21788 | 34000 |  |  | 2001-07-01 00:00:00 |  |  |  | 2.77
7 | 34452 | 35502 | 34276 | 33385
8 | 35161 | 36050 | 35128 | 32613
9 | 33439 | 36143 | 34652 | 32699
10 | 33854 | 36144 | 33814 | 32699
11 | 33642 | 36144 | 33797 | 32700
12 | 38965 | 36144 | 32552 | 32700
13 | 39118 | 34699 | 35264 | 33145
14 | 38237 | 35299 | 34519 | 33145
15 | 38132 | 38491 | 34192 | 32953
16 | 36417 | 38712 | 34079 | 33145
17 | 36836 | 38113 | 32200 | 32622
18 | 35248 | 38712 | 31265 | 33145
19 | 34378 | 38711 | 33089 | 33145
20 | 37388 | 36712 | 31473 | 33145
21 | 38372 | 36712 | 30439 | 33145
22 | 37555 | 38698 | 30323 | 33133
23 | 38049 | 38698 | 30125 | 33133
24 | 33702 | 38698 | 30325 | 33133
25 | 35848 | 38698 | 31480 | 33133
26 | 34672 | 38698 | 31964 | 33133
27 | 34722 | 39012 | 33432 | 33145
28 | 35760 | 39012 | 30109 | 33145
29 | 35083 | 38012 | 31673 | 32145
30
31
2001-11-30 00:00:00 |  |  |  |  | 377734.69
2001-12-29 00:00:00
CBS Volume
Spreadsheet: 734426d1622147975-conditional-formatting-and-color-cells-with-formula-kopieplanning
Sheet: Hours

Project | Datum | Firma | Nummer | Vertrek | Tijd | Aankomst | Naam | Telefoon | Tropco's | [NAME] | [NAME] | Wie D | Inkoop NL | Inkoop D | [NAME] | Verkoop D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Uren inkoop |  | 5259 | Km inkoop
5258 |  |  |  |  |  |  |  |  | 1 | 2 | [NAME] | nl |  |  |  |  |  | Uren verkoop |  |  | Km verkoop
5259 |  |  |  |  |  |  |  |  | 2 | 2 | [NAME] | nl |  |  |  |  |  | Verschil uren |  |  | [NAME] km
5259 |  |  |  |  |  |  |  |  | 2 | 2 |  | nl |  |  |  |  |  | Inkoop NL | 42.5 |  | Inkoop D | 1.15
5259 |  |  |  |  |  |  |  |  | 2 | 2 |  | nl |  |  |  |  |  | Inkoop NL |  |  | Inkoop D
5259 |  |  |  |  |  |  |  |  | 1 | 2 |  | nl |  |  |  |  |  | [NAME] |  |  | Verkoop D
5260 |  |  |  |  |  |  |  |  | 2 | 2 | [NAME] | nl |  |  |  |  |  | [NAME] |  |  | Verschil D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 43 |  | Verkoop D | 1.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj NL ink |  |  | Totaal inkoop
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ver |  |  | Totaal verkoop
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj KM ink |  |  | Totaal verschil
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ver
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project verschil NL |  |  |  | Project verschil D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totaal uren NL |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totaal Verkoop NL |  |  | Totaal verkoop D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Per begeleider
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Zoek project | Aantal beg | Inkoop NL | Inkoop D | [NAME] | Verkoop D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5235
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Klant | aantal beg
Spreadsheet: 55395d1255518702-excel-for-generating-class-exercises-means
Sheet: Sheet1

 | Student 1 | Student 2 | Student 3 | Student 4
 | 98 | 32 | 89 | 80
 | 87 | 56 | 20 | 73
 | 84 | 73 | 88 | 7
 | 25 | 45 | 80 | 33
 | 36 | 41 | 30 | 3
 | 63 | 5 | 50 | 24
 | 14 | 0 | 11 | 51
 | 48 | 70 | 23 | 79
Means | 56.875 | 40.25 | 48.875 | 43.75
Spreadsheet: 102645d1300622517-automated-worksheet-for-accounting-filter-problem-automated-worksheets
Sheet: Header General

 |  |  | Batch Number:
 |  |  | DATE:
 | SUPPLIER NAME | INVOICE # | INVOICE DATE | AMOUNT
 | Acme | 12305
 | Acme | 12305 | 1900-01-01 00:00:00
 | Acme | 12305 | 1900-01-01 00:00:00
 | Albrite Lighting | 22817
 | Albrite Lighting) | 22817
 | Cintas | A-20811
 | Cintas | A-20811
 | Cintas | A-20811
 | [NAME] | 6563300
 | [NAME] | 6563300
 | TOTAL |  |  | 0
 | GM Signature: |  | DATE:
 | [NAME] By: |  | DATE:
Spreadsheet: mary_fischer__25622__87P
Sheet: E3.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 087P
COMPANY NAME  EFS Water Treatment Services
ANALYSIS OF INVESTMENT IN UNCONSOLIDATED AFFILIATES, PARTNERSHIPS & JOINT VENTURES
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:[NAME]
EXTENSION:[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-3
 |  | CURRENT |  | BEGINNING BALANCE |  | EQUITY EARNINGS |  | CASH ACTIVITY - PAID / (RECEIVED) |  |  |  |  |  | NON-CASH ACTIVITY |  |  |  | ENDING BALANCE
NAME OF PARTNERSHIP , |  | % |  | @ 12/31/2000 |  | IN |  |  |  |  |  |  |  |  |  |  |  | @ 12/31/2001
SUBSIDIARY OR JOINT VENTURE |  | OWNED |  | DR / (CR) |  | UNCONSOL. SUB |  | ADVANCES |  | DISTRIBUTIONS |  | RETIREMENTS |  | AMOUNT |  | [NAME] |  | DR / (CR) |  | COMMENTS
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
 |  |  |  | * |  | ** |  |  |  |  |  |  |  |  |  |  |  | *
Total Investment
*  MUST TIE TO HYPERION TOT_INVEST_SUBS |  |  | Asset/Expense Accts:  DR/(CR)
** MUST TIE TO HYPERION TOT_EQEARN_OTH |  |  | Income Accts:  (DR)/CR |  |  | Reverse signs from Hyperion
 |  |  |  |  |  | Credit Positive Liability
 |  |  |  |  |  | Debit Negative Liability
Spreadsheet: tracy_geaccone__40260__C0366-112458
Sheet: Dept_100159

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
MAIL CENTER - Dept. 100159
June, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Service Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 112458
2001-06-21 00:00:00 | MCI2001/06-0366/112458 |  | Work Place | Work Place Count | 2 | 14.34 | /MNTH | 28.68
 |  |  |  |  |  |  | Ticket Total |  | 28.68
 |  |  |  |  |  |  | Total for R/C: 112458 |  | 28.68
 |  |  |  |  |  |  | Total for Dept_100159 |  | 28.68
Spreadsheet: 31819d31-2abc-4cfe-9698-7691c19339d7
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
10/12/2012 | Women's Swimming | West Virginia State Games (Huntington, W.Va.) | 1st place
10/13/2012 | Women's Swimming | West Virginia State Games (Huntington, W.Va.) | 1st place
10/19/2012 | Women's Swimming | Penn State | L, 146-97
10/27/2012 | Women's Swimming | at Villanova | W, 171-128
10/27/2012 | Women's Swimming | vs. [NAME] (Villanova, Pa.) | W, 163-137
11/02/2012 | Women's Swimming | at Cincinnati | W, 163-137
11/16/2012 | Women's Swimming | Pitt Invitational (Pittsburgh, Pa.) | 2nd place
11/17/2012 | Women's Swimming | Pitt Invitational (Pittsburgh, Pa.) | 2nd place
11/18/2012 | Women's Swimming | Pitt Invitational (Pittsburgh, Pa.) | 2nd place
11/29/2012 | Women's Swimming | U.S. Winter Nationals (Austin, Texas) | 5th place
11/30/2012 | Women's Swimming | U.S. Winter Nationals (Austin, Texas) | 7th place
11/30/2012 | Women's Swimming | Miami Diving Invitational (Miami, Ohio) | Results
12/01/2012 | Women's Swimming | Miami Diving Invitational (Miami, Ohio) | Results
12/01/2012 | Women's Swimming | U.S. Winter Nationals (Austin, Texas) | 7th place
01/03/2013 | Women's Swimming | Orange Bowl Classic (Key Largo, Fla.) | 3rd place
01/12/2013 | Women's Swimming | at Pitt | L, 182-118
01/18/2013 | Women's Swimming | TCU | L, 160-140
01/26/2013 | Women's Swimming | Ohio | L, 165-135
02/09/2013 | Women's Swimming | [NAME] (Diving) | Results
02/27/2013 | Women's Swimming | Big 12 Championships (Austin, Texas) | 2nd place
02/28/2013 | Women's Swimming | Big 12 Championships (Austin, Texas) | 2nd place
03/01/2013 | Women's Swimming | Big 12 Championships (Austin, Texas) | 2nd place
03/02/2013 | Women's Swimming | Big 12 Championships (Austin, Texas) | 2nd place
03/15/2013 | Women's Swimming | NCAA Zone Diving (Blacksburg, Va.) | Results
03/16/2013 | Women's Swimming | NCAA Zone Diving (Blacksburg, Va.) | Results
03/21/2013 | Women's Swimming | NCAA Women's Championships (Indianapolis, Ind.) | 34th place
[NAME] | Women's Swimming | NCAA Women's Championships (Indianapolis, Ind.) | 38th place
03/23/2013 | Women's Swimming | NCAA Women's Championships (Indianapolis, Ind.) | 31st place
Spreadsheet: 71496d1272273383-if-array-lookup1
Sheet: Sheet1

 | Today | 2010-04-26 00:00:00
 |  |  | AC | Status | In | Out | Date opened
 |  |  | 1 |  | 200 | 0 | 2010-02-21 00:00:00
 |  |  | 2 |  | 100 | 0 | 1999-12-20 00:00:00
 |  |  | 3 |  | 0 | 100 | 2008-10-05 00:00:00
 |  |  | 4 |  | 0 | 100 | 2010-01-12 00:00:00
 |  |  | 5 |  | 300 | 0 | 2009-12-25 00:00:00
Spreadsheet: 687296d1595089083-spread-sum-by-month-spread-sum-by-month
Sheet: Foglio1 (2)

 |  |  |  |  | Importo | Data inizio | Data fine | 2019-12-01 00:00:00
 |  |  |  |  | 1500 | 2020-01-05 00:00:00 | 2020-06-30 00:00:00
 |  |  |  |  | 6000 | 2020-01-07 00:00:00 | 2020-06-30 00:00:00
 |  |  |  |  | 3000 | 2020-02-08 00:00:00 | 2020-10-30 00:00:00
 |  |  |  |  | 7000 | 2020-03-12 00:00:00 | 2020-12-15 00:00:00
 |  |  |  |  | 8000 | 2019-12-30 00:00:00 | 2020-07-04 00:00:00
 |  |  |  |  | 12000 | 2019-12-28 00:00:00 | 2020-01-31 00:00:00
Spreadsheet: james_steffes__12853__CA rate exposure final 8-28 rev1
Sheet: Legacy

LEGACY CUSTOMERS (DA as of 9/01/01 - but had switched back and forth)
PG&E | Utility Undercollection |  |  |  |  | Bonds |  |  |  |  | Above Market Contract Cost |  |  |  |  | Weighted Avg. Total
 | Scenario | A | B | C |  | Scenario | A | B | C |  | Scenario | A | B | C
 | % Collected |  |  |  | Weighted | % Collected |  |  |  | Weighted | % Collected |  |  |  | Weighted
 | Probability |  |  |  | Avg | Probability |  |  |  | Avg | Probability |  |  |  | Avg
 | Factor | 1 |  | 0 |  | Factor | 1 |  | 0 |  | Factor | 1 |  | 0
Amortization (years)
5
7
10
12
15
Edison | Utility Undercollection |  |  |  |  | Bonds |  |  |  |  | Above Market Contract Cost
 | Scenario | A | B | C |  | Scenario | A | B | C |  | Scenario | A | B | C
 | % Collected |  |  |  | Weighted | % Collected |  |  |  | Weighted | % Collected |  |  |  | Weighted
 | Probability |  |  |  | Average | Probability |  |  |  | Average | Probability |  |  |  | Average
 | Factor | 1 |  | 0 |  | Factor | 1 |  | 0 |  | Factor | 1 |  | 0
Amortization (years)
5
7
10
12
15
SDG&E | Utility Undercollection |  |  |  |  |  |  |  |  |  | Above Market Contract Cost
 | Scenario | A | B | C |  | Scenario | A | B | C |  | Scenario | A | B | C
 | % Collected |  |  |  | Weighted | % Collected |  |  |  | Weighted | % Collected |  |  |  | Weighted
 | Probability |  |  |  | Average | Probability |  |  |  | Average | Probability |  |  |  | Average
 | Factor | 1 |  | 0 |  | Factor | 1 |  | 0 |  | Factor | 1 |  | 0
Amortization (years)
5
7
10
12
15
Spreadsheet: 144060d1-6bac-4302-abd7-61b8cd2b5b9c
Sheet: Sheet1

TABLE 1 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
CONTINUING EDUCATION ENROLLMENT
UNIVERSITY OF HAWAI‘I, BY CAMPUS
FALL 2011
 | CAMPUS |  |  |  | TOTAL
 |  |  |  |  | No. | V%
 |  | TOTAL 1/ ......................................................................................... |  |  | 17679 | 100
 |  | UH Mānoa ................................................................................. |  |  | 5797 | 32.79
 |  |  | Outreach College………………… |  | 2388 | 13.51
 |  |  | Community Service ................................ |  | 2716 | 15.36
 |  |  | Public Events ................................................................................ |  | 693 | 3.92
 |  | UH Hilo ....................................................................................... |  |  | 1546 | 8.74
 |  |  | Conference Center ............................. |  | 757 | 4.28
 |  |  | Continuing Education .................................. |  | 789 | 4.46
 |  | UH Community Colleges .................................................. |  |  | 10336 | 58.46999999999999
 |  |  | Hawai‘i ............................................................................... |  | 958 | 5.42
 |  |  | Honolulu ....................................................................... |  | 2471 | 13.98
 |  |  | Kapi‘olani ......................................................................... |  | 2167 | 12.26
 |  |  | Kaua‘i .................................................................................... |  | 484 | 2.74
 |  |  | Leeward ....................................................................................... |  | 1132 | 6.4
 |  |  | Maui ........................................................................................... |  | 2459 | 13.91
 |  |  | [NAME] .................................................................................. |  | 665 | 3.76
 |  | 1/  Counts are registration counts, and may include multiple
 |  |  | counting of individuals.
Spreadsheet: 6bee8c28-b4a2-427d-9f3b-a6f8979d772c
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
HIV2 | Test | HIV2 | HIV-2 Antibody Evaluation, Serum | HIV-2 Ab Eval, S | Enzyme Immunoassay (EIA) | Serum Gel Tube: SGT |  |  | 1.2 | mL | Collection Container/Tube: Serum gel	 Submission Container/Tube: Plastic vial [NAME]: 1.2 mL | 0.2 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | Negative See HIV Serologic Interpretive Guide in Special Instructions for further interpretive information. | Monday through Friday; Varies | One day. Approximately 1 week for the reflex confirmation result to be returned. | 3 days | 1 | 86702 |  |  |  |  | Rochester
HIV2 | [NAME] | SST | Serum SST |  |  |  | Frozen
HIV2 | Result | 86702 | HIV-2 Ab Eval, S | HIV-2 Ab Eval, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30361-0
HIV2 | [NAME] | HIV2L | HIV-2 Antibody Confirmation, Serum | HIV-2 Ab Confirmation, S | Line Immunoassay (LIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Collection Container/Tube: Serum gel	 Submission Container/Tube: Plastic vial [NAME]: 0.5 mL | 0.2 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Negative  This confirmatory assay should be ordered only on specimens that are reactive by an anti-HIV-2 screening immunoassay. | Monday; 3 p.m. | 5 Days | 9 Days | 1 | 86689 |  |  | No | Yes
HIV2L | [NAME] | SST | Serum SST |  |  |  | Frozen
HIV2L | Result | 61785 | HIV-2 Ab Confirmation, S | HIV-2 Ab Confirmation, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 794166d1661911086-index-aggrregate-multiple-values-different-column-criteria-idp-0831
Sheet: Sheet1

Training History for Employees
 | Training Name | MS WORD | MS EXCEL | MS PPT
 | Training Code | 12345678 | 56789012 | 90123456 |  |  |  | SELECT DEPARTMENT |  |  | Logistics
Name | Department |  |  |  |  |  |  | SELECT TRAINING CODE |  |  | 90123456
[NAME] | Finance | 2022-10-09 00:00:00 | 2022-11-25 00:00:00 |  |  |  |  |  |  |  | <<<< list the red fonts and empty cell for the selected filter above
[NAME] | Logistics | 2022-11-25 00:00:00 | 2022-08-20 00:00:00 | 2022-11-28 00:00:00
Adel | Marketing | 2022-10-20 00:00:00 | 2022-08-21 00:00:00 | 2022-08-17 00:00:00
Naomi | Human Resource | 2022-10-02 00:00:00 | 2022-11-14 00:00:00 | 2022-11-29 00:00:00
Sama | Prodcution |  | 2022-10-24 00:00:00 | 2022-12-28 00:00:00
[NAME] | Finance | 2022-11-08 00:00:00 | 2022-10-20 00:00:00 | 2022-10-20 00:00:00
Turki | Logistics | 2022-11-02 00:00:00 |  | 2022-12-13 00:00:00
Mimosa | Marketing | 2022-10-14 00:00:00 | 2022-11-24 00:00:00 | 2022-12-03 00:00:00
[NAME] | Human Resource | 2022-12-19 00:00:00 | 2022-10-03 00:00:00 | 2022-12-17 00:00:00
Winston | Prodcution | 2022-10-03 00:00:00 |  | 2022-10-24 00:00:00
[NAME] | Finance | 2022-12-22 00:00:00 | 2022-12-20 00:00:00 | 2022-12-11 00:00:00
Zoey | Logistics | 2022-12-30 00:00:00 | 2022-11-06 00:00:00 | 2022-10-19 00:00:00
[NAME] | Marketing | 2022-08-28 00:00:00 | 2022-09-25 00:00:00 | 2022-12-09 00:00:00
[NAME] | Human Resource | 2022-10-29 00:00:00 | 2022-12-16 00:00:00
[NAME] | Prodcution | 2022-11-05 00:00:00 | 2022-12-31 00:00:00 | 2022-08-07 00:00:00
Houston | Finance |  | 2022-09-08 00:00:00 | 2022-11-09 00:00:00
Cookie | Logistics | 2022-12-31 00:00:00 | 2022-10-08 00:00:00 | 2022-07-31 00:00:00
Fhad | Marketing | 2022-10-19 00:00:00 | 2022-09-17 00:00:00 | 2022-08-08 00:00:00
Nickita | Human Resource | 2022-08-02 00:00:00 | 2022-08-24 00:00:00 | 2022-11-28 00:00:00
Yassir | Prodcution | 2022-10-14 00:00:00 | 2022-09-20 00:00:00 | 2022-12-16 00:00:00
Giglie | Finance | 2022-08-19 00:00:00 | 2022-11-26 00:00:00 | 2022-11-07 00:00:00
Selena | Logistics | 2022-12-31 00:00:00 | 2022-12-02 00:00:00 | 2022-09-07 00:00:00
[NAME] | Marketing | 2022-09-13 00:00:00 | 2022-08-26 00:00:00 | 2022-09-27 00:00:00
Zeki | Human Resource | 2022-12-26 00:00:00 | 2022-12-30 00:00:00 | 2022-12-16 00:00:00
Hammy | Prodcution | 2022-10-28 00:00:00 | 2022-12-26 00:00:00 | 2022-12-22 00:00:00
Spreadsheet: 700293d1603118638-totals-from-two-different-tabs-into-a-third-tab-of-the-same-workbook-ledger-example
Sheet: Annual Ledger

Activity | Ref # | Jan Total | Feb Total | March Total | April Total
Mortgage | 1 |  |  |  |  |  |  | Need the total for each ref # for both the Checking Account and the Credit Card tabs  to enter in the Annual ledger spreadsheet as shown in the example for Jan Total
Electric | 2
Gas | 3
Phone | 4
Cable | 5
Dining Out | 6
Groceries | 7
[NAME] | 8
Expected Results
Mortgage | 1 | -1000 | -1200 | -600 | -600
Electric | 2 | -200 | -180 | -150 | -150
Gas | 3 | -75 | -75 | -72 | -72
Phone | 4 | -50 | -50 | -45 | -45
Cable | 5 | -100 | -100 | -9 | -96
Dining Out | 6 | -103 | -98 | -96 | -109
Groceries | 7 | -14 | -13 | -109 | -12
[NAME] | 8 | -20 | -11 | -17 | -17
Spreadsheet: 183594d1348884757-getting-the-sum-of-all-the-cell-and-placed-it-in-another-worksheet-excel_file_123
Sheet: Data

Customer Name | Likely to Recommend | Date | Incentives in Dollar
Adam | 10-- Extremely likely | 2011-09-11 00:00:00 | 2
[NAME] | 10-- Extremely likely | 2012-08-23 00:00:00 | 3
Edmond | 0-- Not likely at all | 2010-01-13 00:00:00 | 4
[NAME] | 10-- Extremely likely | 2010-01-13 00:00:00 | 5
[NAME] | 5 | 2010-01-13 00:00:00 | 5
Adam | 8 | 2012-09-07 00:00:00 | 7
[NAME] | 10-- Extremely likely | 2011-04-08 00:00:00 | 6
Edmond | 5 | 2011-04-09 00:00:00 | 8
[NAME] | 7 | 2012-05-18 00:00:00 | 9
[NAME] | 10-- Extremely likely | 2011-04-11 00:00:00 | 7
Adam | 9 | 2011-05-18 00:00:00 | 6
[NAME] | 10-- Extremely likely | 2012-04-13 00:00:00 | 7
Edmond | 8 | 2011-04-14 00:00:00 | 5
[NAME] | 7 | 2011-05-15 00:00:00 | 2
[NAME] | 0-- Not likely at all | 2011-04-16 00:00:00 | 3
Adam | 0-- Not likely at all | 2010-02-01 00:00:00 | 4
[NAME] | 10-- Extremely likely | 2011-03-03 00:00:00 | 5
Edmond | 10-- Extremely likely | 2010-06-06 00:00:00 | 6
[NAME] | 5 | 2012-05-02 00:00:00 | 7
[NAME] | 5 | 2012-07-08 00:00:00 | 5
Spreadsheet: vkaminski__40901__CASH_EPE_0400MyCopy
Sheet: Plant Operations

APPENDIX I - PLANT OPERATIONS
 |  | Plant Operations
 |  | Plant | Days | Days | Hours | Plant | Guarant | Monthly | Annual | Plant | Guarant | Monthly | Annual | Monthly | Monthly | Annual | Monthly | Annual | Monthly | Annual
 |  | MW | Per | Per | Per | Dispatch | Avail | Diesel | Diesel | Dispatch | Avail | Gas | Gas | Heat Rate | MMBTU's | MMBTU's | MMBTU's | MMBTU's | MMBTU's | MMBTU's
Date |  | Capacity | Month | Year | Day | Diesel | Diesel | Mwh | Mwh | Gas | Gas | Mwh | Mwh | Gas Only | Consumed | Consumed | TOP | TOP | Purchased | Purchased
 |  |  |  |  | 24
1
Spreadsheet: 17302824-88d1-4c0d-b46e-d1fa7ac25f68
Sheet: Sheet1

BANK RECONCILIATION STATEMENT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
As at ___/___/20___
Opening Cash Book Balance | 1500
add receipts | 60
less payments | 200
Closing Cash Book Balance | 1360
add direct credits not yet written | 250
less direct debits into cash book | 40
Add adjusted cash book balance | 1570
Bank Statement Balance at End of Period | 1570
add receipts not yet banked | 235
less cheques not yet presented | 400
True Cash book balance | 1405
List of cheques not yet presented:
Date Written Cheque No:
12 Jun 000123 Brand T-Shirts | 240
14 Jun 000124 Logo Designs Ltd | 160
Total unpresented cheques | 400