tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 78829d1279129212-sum-several-worksheets-in-same-workbook-tech-attendance
Sheet: ATTENDANCE May thru July

Last Name | First Name | Tech ID | Vacation | Personal | Sick | 2010-05-01 00:00:00 | 2010-05-02 00:00:00 | 2010-05-03 00:00:00 | 2010-05-04 00:00:00 | 2010-05-05 00:00:00 | 2010-05-06 00:00:00 | 2010-05-07 00:00:00 | 2010-05-08 00:00:00 | 2010-05-09 00:00:00 | 2010-05-10 00:00:00 | 2010-05-11 00:00:00 | 2010-05-12 00:00:00 | 2010-05-13 00:00:00 | 2010-05-14 00:00:00 | 2010-05-15 00:00:00 | 2010-05-16 00:00:00 | 2010-05-17 00:00:00 | 2010-05-18 00:00:00 | 2010-05-19 00:00:00 | 2010-05-20 00:00:00 | 2010-05-21 00:00:00 | 2010-05-22 00:00:00 | 2010-05-23 00:00:00 | 2010-05-24 00:00:00 | 2010-05-25 00:00:00 | 2010-05-26 00:00:00 | 2010-05-27 00:00:00 | 2010-05-28 00:00:00 | 2010-05-29 00:00:00 | 2010-05-30 00:00:00 | 2010-05-31 00:00:00 | 2010-06-01 00:00:00 | 2010-06-02 00:00:00 | 2010-06-03 00:00:00 | 2010-06-04 00:00:00 | 2010-06-05 00:00:00 | 2010-06-06 00:00:00 | 2010-06-07 00:00:00 | 2010-06-08 00:00:00 | 2010-06-09 00:00:00 | 2010-06-10 00:00:00 | 2010-06-11 00:00:00 | 2010-06-12 00:00:00 | 2010-06-13 00:00:00 | 2010-06-14 00:00:00 | 2010-06-15 00:00:00 | 2010-06-16 00:00:00 | 2010-06-17 00:00:00 | 2010-06-18 00:00:00 | 2010-06-19 00:00:00 | 2010-06-20 00:00:00 | 2010-06-21 00:00:00 | 2010-06-22 00:00:00 | 2010-06-23 00:00:00 | 2010-06-24 00:00:00 | 2010-06-25 00:00:00 | 2010-06-26 00:00:00 | 2010-06-27 00:00:00 | 2010-06-28 00:00:00 | 2010-06-29 00:00:00 | 2010-06-30 00:00:00 | 2010-07-01 00:00:00 | 2010-07-02 00:00:00 | 2010-07-03 00:00:00 | 2010-07-04 00:00:00 | 2010-07-05 00:00:00 | 2010-07-06 00:00:00 | 2010-07-07 00:00:00 | 2010-07-08 00:00:00 | 2010-07-09 00:00:00 | 2010-07-10 00:00:00 | 2010-07-11 00:00:00 | 2010-07-12 00:00:00 | 2010-07-13 00:00:00 | 2010-07-14 00:00:00 | 2010-07-15 00:00:00 | 2010-07-16 00:00:00 | 2010-07-17 00:00:00 | 2010-07-18 00:00:00 | 2010-07-19 00:00:00 | 2010-07-20 00:00:00 | 2010-07-21 00:00:00 | 2010-07-22 00:00:00 | 2010-07-23 00:00:00 | 2010-07-24 00:00:00 | 2010-07-25 00:00:00 | 2010-07-26 00:00:00 | 2010-07-27 00:00:00 | 2010-07-28 00:00:00 | 2010-07-29 00:00:00 | 2010-07-30 00:00:00 | 2010-07-31 00:00:00
Badreddine | Yabi | 897884 | 0 | 0 | 0
Berrospe | [NAME] | 717553 | 0 | 0 | 0
[NAME] | [NAME] | 670844 | 0 | 0 | 0
Ciran | [NAME] | 897124 | 0 | 0 | 0
Cory | [NAME] | 574517 | 0 | 0 | 0
Ditore | [NAME] | 823088 | 0 | 0 | 0
Garvey | [NAME] | 3897 | 0 | 0 | 0
Guzman | Saul | 918615 | 0 | 0 | 0
Heineman | Russ | 737502 | 0 | 0 | 0
Holland | Scott | 801597 | 0 | 0 | 0
Lopez | Javier | 498139 | 0 | 0 | 0
Mendez | Hector | 10538 | 0 | 0 | 0
Mendez | Hector | 10538 | 0 | 0 | 0
Pula | Elvis | 684779 | 0 | 0 | 0
[NAME] | [NAME] | 449397 | 0 | 0 | 0
Valle | [NAME] | 706481 | 5 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V | V | V | V
[NAME] | [NAME] | 506097 | 0 | 0 | 0
Waitekus | [NAME] | 613091 | 0 | 0 | 0
Spreadsheet: 1899c19c-1800-486c-b711-8b0c2d9d8313
Sheet: Sheet1

 | Higher Education Support per $1000 of Personal Income - Scenarios and National Comparison
 |  | Scenario
 |  | A- 760M in GF Support | B  660M in GF Support | 2008
 | Personal Income | 207742661000 | 207742661000 | 212320185000
 | Potential State Support |  |  | 794718033
 | Higher Ed Support per $1000 of personal income
 |  | State [NAME] | A | B
 |  | Estimated GF | 760000000 | 660000000
 |  | Tobacco | 16004485 | 16004485
 |  | DOLA Mineral Grants
 |  | Local Appropriations | 51188917 | 51188917
 |  | Total
 | 2008 Higher Ed Support per $1000 of Personal Income from SHEEO SHEF Study
 | State | State and Local Support for Higher Education | Personal Income (in 1,000s) | Higher Education Support1 Per $1000 of Personal Income   (FY 08)
 | New Hampshire | 133093000 | 57399130
 | Colorado | 794718033 | 212320185
 | Vermont | 90801444.33999634 | 24034394
 | Massachusetts | 1335981876 | 333046494
 | Rhode Island | 191329662 | 43468678
 | Pennsylvania | 2304414847 | 499669401
 | New Jersey | 2255163000 | 445928224
 | Connecticut | 1034480989 | 197023620
 | Missouri | 1154709224 | 216546820
 | Virginia | 1902952314 | 343580294
 | New York | 5386383480 | 950209504
 | Maine | 275867961 | 47994130
 | Nevada | 620032581 | 107079263
 | Ohio | 2425206616 | 413732085
 | Montana | 200738808 | 33515577
 | Oregon | 849601772 | 137569686
 | Florida | 4448930438 | 719707709
 | Washington | 1767760000 | 280677561
 | South Dakota | 196133172 | 31090547
 | Illinois | 3699066751 | 546344259
 | Maryland | 1867267820 | 272542169
 | Delaware | 243130000 | 35376923
 | Indiana | 1528494000 | 220670002
 | Minnesota | 1574499000 | 224670738
 | Tennessee | 1598765500 | 217372834
 | Michigan | 2583709000 | 349612178
 | Wisconsin | 1647134242 | 212553339
 | Texas | 7406399559 | 918921246
 | Iowa | 921007211 | 112302300
 | Idaho | 423002400 | 50398859
 | California | 13795924000 | 1604112764
 | South Carolina | 1267030856 | 146334933
 | Oklahoma | 1134926352 | 131070218
 | Georgia | 2953507623 | 337960830
 | Arizona | 1950753200 | 223184451
 | Kansas | 1010691886 | 108778736
 | Utah | 812337500 | 87411357
 | Arkansas | 899171445.7299957 | 92505191
 | Kentucky | 1334959500 | 136939777
 | West Virginia | 562253000 | 57410905
 | Alaska | 299944731 | 30223608
 | North Dakota | 253901000 | 25575905
 | Hawaii | 554292000 | 54175210
 | Nebraska | 740054153 | 69820901
 | Louisiana | 1707668337 | 160658930
 | Mississippi | 1095346981 | 89331219
 | North Carolina | 4023228520 | 325953820
 | Alabama | 1964218104 | 157421997
 | Wyoming | 327448738 | 25892041
 | New Mexico | 1153348068 | 66336940
 | US Total | 88701780695.06999
Spreadsheet: e9841aea-f295-4724-b263-ee1c1b51fd26
Sheet: Sheet1

Unnamed: 0 | Match No | Name | Comments
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
Spreadsheet: 824814d1680864255-substitute-formula-against-filter-function-in-older-version-of-excel-matching-and-extracting_v2g
Sheet: Main Data

 |  |  |  |  | Required Result
 | ID | Movies /Free Movies | Ticket In Price |  | Shows | Ticket In Price | Difference
 | 125 | Tomorrow Never Dies | 99
 | 145 | Avatar | 109
 | 115 | Bahubali | 144
 | 196 | Rambo | 44
 | 188 | Rambo | 25
 | 101 | Brahmastra | 84
 | 151 | Bhola | 211
 | 199 | A AA 2 | 65
 | 121 | Oh Baby | 120
Spreadsheet: 159974d1338916641-creating-a-summary-page-from-multiple-worksheets-ordertest
Sheet: Boxes

Size | Description | Part # | Quantity |  |  | Supplier | Cobra # | Notes
 |  |  | In Stock | Level | Order
4 sq. | 1 1/2" Deep Box | 52151  1/2 & 3/4 |  | 400 |  | Wesco
4 11/16 | 2 1/8" Deep Box | EGS4SJDEK |  | 400 |  | Wesco
1 1/2" | Switch - Gangable - Metal Box | ORBUM GESB1 |  | 15 |  | AP
2" | Switch - Gangable - Metal Box | ORBUM GMB1 |  | 15 |  | AP
2 3/4" | Switch - Gangable - Metal Box | ORBUM GSB1 |  | 10 |  | AP
3  1/2 Deep | Switch - Gangable - Metal wo pigtail [NAME] | EGS333D |  | 400 |  | AP
 | Handy  Box | 58361-1/2 |  | 10 |  | Wesco
 | Ceiling Fan &Lt.Fix.[NAME] | 54151-CFB |  | 10 |  | Wesco
1/2" | Bell Box  5-Hole |  |  | 100 |  | Wesco
3/4" | Bell Box  5-Hole |  |  | 50 |  | Wesco
1/2" | Bell Box Ext. Red Dot Only | 1HEF-1 |  | 100 |  | Wesco
3/4" | Bell Box Ext. Red Dot Only | 1HEF-2-2 |  | 10 |  | Wesco
4 sq. | [NAME] | 53151  1/2 & 3/4 |  | 20 |  | Wesco
4 11/16 | [NAME] | 73151  1/2 & 3/4 |  | 20 |  | Wesco
 | Round Cut-In Bake Light Box | 3080-9 |  | 50 |  | Wesco
1 Gang | Cut-In Bake Light Box | 7010-8 |  | 50 |  | Wesco
1 Gang | Nail On Bake Light Box | 1099-N |  | 100 |  | Wesco
2 Gang | Nail On Bake Light Box | 2302NK |  | 50 |  | Wesco
3 Gang | Nail On Bake Light Box | 2303NK |  | 10 |  | Wesco
4 Gang | Nail On Bake Light Box | 4300NK |  | 10 |  | Wesco
 | Round Nail On Bake Light Box | 9351-NK |  | 50 |  | Wesco
4 Sq. | Nail On Bake Light Box | 4000 #2 |  | 50 |  | Wesco
 | 4x4x4 PVC Box | 4x4x4-JCT |  | 10 |  | Wesco
 | 8x7x7 PVC Box | 8x8x7-JCT |  | 10 |  | Wesco
 | 12x12x6 PVC Box | E989R |  | 10 |  | Wesco
Metal | 4x4x4 Screw [NAME] |  |  | 10 |  | Graybar
Metal | 6x6x4 Screw [NAME] |  |  | 6 |  | Graybar
Metal | 12x12x4 Screw [NAME] | SC12124 |  | 6 |  | Wesco
Metal | 12x12x6 Screw Cover Box | SC12126 |  | 6 |  | Wesco
Metal | 10x10x6 Screw [NAME] | SC10106 |  | 4 |  | Wesco
Metal | 6x6x4 W.P. Hinged [NAME] | B060604CH |  | 4 |  | Wesco
 | [NAME] 1542 | TM 1542 |  | 4 |  | Wesco
 | Extendable Fan Box | 55501 |  | 4 |  | Wesco
 | 6 x 6 x 4 PVC Box |  |  | 5 |  | Wesco
Spreadsheet: 709951d1608639098-generate-list-of-unique-emails-and-sum-data-in-columns-example-data-workbook-tickets
Sheet: Sheet1

From | From [NAME] | Thread Count |  |  |  |  |  |  |  |  |  |  | Unique User Emails | Total Thread Count
Person 1 | [EMAIL] | 1
Person 3 | [EMAIL] | 4 |  |  |  |  |  |  |  |  |  |  | [EMAIL]
Person 4 | [EMAIL] | 6 |  |  |  |  |  |  |  |  |  |  | [EMAIL]
Person 5 | [EMAIL] | 1 |  |  |  |  |  |  |  |  |  |  | [EMAIL]
Person 2 | [EMAIL] | 2 |  |  |  |  |  |  |  |  |  |  | [EMAIL]
Person 1 | [EMAIL] | 1
Person 1 | [EMAIL] | 5
Person 5 | [EMAIL] | 6
Person 4 | [EMAIL] | 13
Person 4 | [EMAIL] | 9
Person 5 | [EMAIL] | 1
Person 1 | [EMAIL] | 8
Person 4 | [EMAIL] | 2
Person 3 | [EMAIL] | 3
Person 3 | [EMAIL] | 5
Person 4 | [EMAIL] | 10
Person 1 | [EMAIL] | 1
Person 5 | [EMAIL] | 4
Person 3 | [EMAIL] | 2
Person 3 | [EMAIL] | 6
Spreadsheet: drew_fossum__8992__Fixed3
Sheet: ENA_12

[NAME]
FUEL HEDGING BOOK
Enron North America_12
Prod. | Contract | Contract | Fixed |  | Fuel | Settled | Futures | (Gains) and Losses
Date | Number | Name | Price |  | Dth | Price | Price | Total | Realized | Unrealized
 |  |  |  |  |  | El Paso Prmn |  | (4) | (4) | (4)
2001-01-01 00:00:00 |  | ENA | 3.63
2001-02-01 00:00:00 |  | ENA | 3.63
2001-03-01 00:00:00 |  | ENA | 3.63
2001-04-01 00:00:00 |  | ENA | 3.63
2001-05-01 00:00:00 |  | ENA | 3.63
2001-06-01 00:00:00 |  | ENA | 3.63
2001-07-01 00:00:00 |  | ENA | 3.63
2001-08-01 00:00:00 |  | ENA | 3.63
2001-09-01 00:00:00 |  | ENA | 3.63
2001-10-01 00:00:00 |  | ENA | 3.63
2001-11-01 00:00:00 |  | ENA | 3.63
2001-12-01 00:00:00 |  | ENA | 3.63
 |  |  |  |  |  | TW Index
2001-01-01 00:00:00 |  | Over-retention | 3.63
2001-02-01 00:00:00 |  | Over-retention | 3.63
2001-03-01 00:00:00 |  | Over-retention | 3.63
2001-04-01 00:00:00 |  | Over-retention | 3.63
2001-05-01 00:00:00 |  | Over-retention | 3.63
2001-06-01 00:00:00 |  | Over-retention | 3.63
2001-07-01 00:00:00 |  | Over-retention | 3.63
2001-08-01 00:00:00 |  | Over-retention | 3.63
2001-09-01 00:00:00 |  | Over-retention | 3.63
2001-10-01 00:00:00 |  | Over-retention | 3.63
2001-11-01 00:00:00 |  | Over-retention | 3.63
2001-12-01 00:00:00 |  | Over-retention | 3.63
(4)Gain and [NAME] are a measurement of the effectiveness of meeting the stated hedge objective.
Spreadsheet: 34950d1232403973-lock-cell-value-once-calculated-budget-spreadsheet
Sheet: DetailSheet

 |  | Debit Types
 |  | Giving | Savings | Mortgage | Rent | Heat | Internet | Food | Gas | Car misc | Insurance | Clothes | Entertainment | Extra
 |  | 0.1 | 300 | 0 | 500 | 80 | 60 | 200 | 200 | 300 | 61 | 100 | 200 | Leftover |  | Credit Types
 |  | 330 | 300 | 0 | 500 | 80 | 60 | 200 | 200 | 300 | 61 | 100 | 200 | 969
 |  | 330 | 300 | 0 | 500 | 80 | 60 | 200 | 175 | 300 | 61 | 100 | 200 | 969 |  | Paycheck
 |  | 330 | 300 | 0 | 500 | 80 | 60 | 160 | 175 | 300 | 61 | 100 | 200 | 969 |  | Other
 |  | 330 | 300 | 0 | 500 | 80 | 60 | 130 | 175 | 300 | 61 | 100 | 200 | 969
 |  | 660 | 600 | 0 | 1000 | 160 | 120 | 330 | 375 | 600 | 122 | 200 | 400 | 1938
 |  | 660 | 600 | 0 | 500 | 160 | 120 | 330 | 375 | 600 | 122 | 200 | 400 | 1938
 |  | 990 | 900 | 0 | 1000 | 240 | 180 | 530 | 575 | 900 | 183 | 300 | 600 | 2907
 |  | 990 | 900 | 0 | 1000 | 240 | 180 | 530 | 575 | 900 | 183 | 300 | 600 | 2907
 |  | 490 | 900 | 0 | 1000 | 240 | 180 | 530 | 575 | 900 | 183 | 300 | 600 | 2907
 |  | 490 | 900 | 0 | 1000 | 240 | 180 | 530 | 575 | 900 | 183 | 300 | 565 | 2107
 |  | 490 | 900 | 0 | 1000 | 240 | 180 | 530 | 575 | 900 | 183 | 300 | 565 | 607
 |  | 490 | 900 | 0 | 1000 | 240 | 180 | 530 | 575 | 900 | 183 | 300 | 565 | 582
 |  | 490 | 900 | 0 | 1000 | 240 | 180 | 530 | 575 | 900 | 183 | 300 | 565 | 582
Spreadsheet: 39295d1237470221-how-to-programmatically-do-what-a-pivot-table-could-do-snippetofdata
Sheet: Sheet1

Current "snippet" of data
LOAN | [NAME] | XREF | AMT
5555555 | 102 WAMAKER LLC 5555555 |  | 50000
6666666 | 10 SOUTH ALAMEDA S 6666666 |  | 58222
7777777 | 55 EAST NORTH 7777777 |  | 62154
8787878 | 1000 LEXINGTON 8787878 | X000455 | 150666
7587584 | 1000 LEXINGTON 7587584 | X000455 | 150666
On a different spreadsheet I want to have the results look like NOTE there eventually will be a whole lot of other data where a Pivot Table will not be condusive for the solution. |  |  |  |  | This from the original post
LOAN | LOAN NAME | [NAME] | AMT
5555555 | 102 WAMAKER LLC | 5555555 | 50000
6666666 | 10 SOUTH ALAMEDA S | 6666666 | 58222
7777777 | 55 EAST NORTH | 7777777 | 62154
7587584 8787878 | 1000 LEXINGTON | X000455 | 150666
I am getting closer to what I want
Step 1 - add a column that includes loan and xref Step 2 - copy paste special values for step 1 result because next step was not working while it was in formula form Step 3 - Use Autofilter on range c24:e29 (I added a row for additional testing)
LOAN | [NAME] | XREF | AMT | [NAME]
5555555 | 102 WAMAKER LLC 5555555 |  | 50000 | 5555555
6666666 | 10 SOUTH ALAMEDA S 6666666 |  | 58222 | 6666666
7777777 | 55 EAST NORTH 7777777 |  | 62154 | 7777777
8787878 | 1000 LEXINGTON 8787878 | X000455 | 150666 | X000455
7587584 | 1000 LEXINGTON 7587584 | X000455 | 150666 | X000455
4444444 | 100 MADISON 4444444 |  | 50000 | 4444444
Results of autofilter
LOAN | [NAME] | XREF | AMT | [NAME]
5555555 | 102 WAMAKER LLC 5555555 |  | 50000 | 5555555
6666666 | 10 SOUTH ALAMEDA S 6666666 |  | 58222 | 6666666
7777777 | 55 EAST NORTH 7777777 |  | 62154 | 7777777
8787878 | 1000 LEXINGTON 8787878 | X000455 | 150666 | X000455 | 7587584 8787878 | <-- example I want
4444444 | 100 MADISON 4444444 |  | 50000 | 4444444
Spreadsheet: 768072d1644828054-counting-in-between-dates-with-conditions-summary-report-february-2022
Sheet: summary

 |  | Number of hired per month
Recruitment Agency | Client | November 2021 | December 2021 | January 2022 | February 2022
Dynamic | Construction | 2 | 2 | 3 | 1
 | Mall | 3 | 3 | 3 | 4
 | Restaurant | 4 | 1 | 2 | 2
Staffhouse | Construction | 2 | 5 | 3 | 2
 | Mall | 3 | 3 | 9 | 0
 | Restaurant | 5 | 5 | 2 | 0
TransGulf | Construction | 3 | 4 | 2 | 2
 | Mall | 4 | 3 | 1 | 0
 | Restaurant | 1 | 5 | 4 | 2
Spreadsheet: 38249d1236352874-pull-info-from-1-worksheet-into-another-not-a-one-to-one-relationship-samplespreadsheet
Sheet: Sheet1

SPR | Hours | Description | Code | Category | OverallProj
7497 | 1 | Maint - Daily Maintenance | S
7499 | 6 | Maint - IP Daily Maintenance | S
7777 | 132.25 | ADM | A
9999 | 48 | PTO | P
11373 | 9 | CCM Coach Productivity Report | S
12487 | 14 | Maint - Discoverer Datamart | S
13545 | 12 | CCM -  Reach and Engage Report | S
13604 | 152.5 | RFP - BH Support-ASD | S
14901 | 6.5 | Support of AE -- T S | S
14905 | 3.75 | Support of AE -- NN | S
14906 | 2 | Support of AE -- DR | S
14909 | 34 | Support of AE - GB | S
14913 | 2 | Support of AE -- SR | S
16211 | 6 | Maint - Reporting & Support | S
16402 | 48.5 | Application Development-Ver. 2.0 | S
16467 | 0.5 | New Business  Impl | S
16817 | 9 | Rads- to EDI | S
16820 | 8.5 | [NAME] | S
16821 | 9.5 | Rads - Payment | S
16883 | 1 | [NAME] | S
16915 | 17.25 | Train - Technical Training | S
17005 | 2 | Rad Summary Report | S
17006 | 1.5 | [NAME] | S
Spreadsheet: 8b7224d1-561b-4235-936e-867c0811aff0
Sheet: Table 5.1

Monthly Statistical Bulletin
5.1 Business interest rates
Month | 2008–09 | 2009–10 | 2010–11 | 2011–12 | 2012–13
Large business interest rate (a) (b) – per cent
September
December
March
June
Annual average
Small business interest rate (a) (c) – per cent
September
December
March
June
Annual average
(a) The data are weighted average rates, which are calculated from outstanding credit
facilities held by businesses at different interest rates with different maturities.
(b) A large business loan is defined as being $2 million or more.
(c) A small business loan is defined as being less than $2 million.
Source: RBA website statistical table F5 | http://www.rba.gov.au/PublicationsAndResearch/Bulletin/2008/index.html
 |  |  |  |  |  |  |  | Update
Spreadsheet: 129586d1321719226-help-with-2-functions-template-2012-correction
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | VALUE | VALUE | VALUE
(1) - Both Rejected - All values = 0 |  |  |  |  |  |  |  |  |  |  |  | SHOULD BE | SHOULD BE | SHOULD BE
User Id | Account | Customer Name | EName | Estatus | Reason | GName | Gstatus | Reason | Evol | Gvol | Date | enrollment 1 | enrollment 2 | Total # Apps
 |  |  |  | Rejected |  |  | Duplicate |  |  |  |  |  | 0 | 0
(2) - Enrollement 1 & 2 Values = $15.00 (1st enrollment), $11.00 (2nd enrollment) & Total apps = 1
User Id | Account | Customer Name | EName | Estatus | Reason | GName | Gstatus | Reason | Evol | Gvol | Date | enrollment 1 | enrollment 2 | Total # Apps
 |  |  |  | enrolled |  |  | Inprocess |  |  |  |  |  | 11 | 1
(3) - Enrollement 1 & 2 Values = $0.00 (1st enrollment), $15.00 (2nd enrollment) & Total apps = 1
User Id | Account | Customer Name | EName | Estatus | Reason | GName | Gstatus | Reason | Evol | Gvol | Date | enrollment 1 | enrollment 2 | Total # Apps
 |  |  |  | Rejected |  |  | Inprocess |  |  |  |  |  | 15 | 1
(4) - Enrollement 1 & 2 Values = $15.00 (1st enrollment), $11.00 (2nd enrollment) & Total apps = 1
User Id | Account | Customer Name | EName | Estatus | Reason | GName | Gstatus | Reason | Evol | Gvol | Date | enrollment 1 | enrollment 2 | Total # Apps
 |  |  |  | enrolled |  |  | Duplicate |  |  |  |  |  | 0 | 1
(1a) Also would it be possible to add in the following if the count of all estatus & gstatus is great then 20 change enrollment 1 & enrollment 2 = $20.00 each
User Id | Account | Customer Name | EName | Estatus | Reason | GName | Gstatus | Reason | Evol | Gvol | Date | enrollment 1 | enrollment 2 | Total # Apps
 |  |  |  | enrolled |  |  | Duplicate |  |  |  |  | 20 | 0 | 1
 |  |  |  | enrolled |  |  | Inprocess |  |  |  |  | 20 | 20 | 1
 |  |  |  | Inprocess |  |  | Inprocess |  |  |  |  | 20 | 20 | 1
 |  |  |  | enrolled |  |  | enrolled |  |  |  |  | 20 | 20 | 1
 |  |  |  | Rejected |  |  | Duplicate |  |  |  |  |  | 0 | 0 | TOTAL # OF APPS CORRECTION
 |  |  |  | enrolled |  |  | Inprocess |  |  |  |  | 20 | 20 | 1
 |  |  |  | enrolled |  |  | Inprocess |  |  |  |  | 20 | 20 | 1
 |  |  |  | enrolled |  |  | Inprocess |  |  |  |  | 20 | 20 | 1
 |  |  |  | enrolled |  |  | Inprocess |  |  |  |  | 20 | 20 | 1
 |  |  |  | enrolled |  |  | Inprocess |  |  |  |  | 20 | 20 | 1
 |  |  |  | enrolled |  |  | Inprocess |  |  |  |  | 20 | 20 | 1
 |  |  |  | enrolled |  |  | Inprocess |  |  |  |  | 20 | 20 | 1
 |  |  |  | count=11 |  |  | count=10
 |  |  |  | TOTAL COUNT = 21
Spreadsheet: 40925d1239307307-conditional-formatting-objects-conditional-formatting-shapes
Sheet: Conditional Formatting

 | Data per Week |  |  |  |  |  |  |  | Data Graphed Week over Week
 |  | Day - (Date) |  | Visitors |  | % Chg.
 |  | Sun - (Mar 29, 2009) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MOCK DATA
 |  | Last Week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WUVs | Other WUVs |  | WUVs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 3115610 | 194403 |  | 2009-02-22 00:00:00 | 5106277
 |  | Mon - (Mar 30, 2009) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar 23, 2009 | 649197 | 75454 |  | 2009-03-01 00:00:00 | 5201879
 |  | Last Week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 372063 | 53319 |  | 2009-03-08 00:00:00 | 5032144
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 264106 | 41998 |  | 2009-03-15 00:00:00 | 4897536
 |  | [NAME] - (Mar 31, 2009) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 26, 2009 | 221354 | 36518 |  | 2009-03-22 00:00:00 | 5141244
 |  | Last Week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar 27, 2009 | 257226 | 44351 |  | 2009-03-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar 28, 2009 | 261688 | 54389
 |  | Wed - (Apr 1, 2009) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar 29, 2009 | 3162575 | 206184 |  | Other WUVs
 |  | Last Week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar 30, 2009 | 627092 | 70540 |  | 2009-02-22 00:00:00 | 489756
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar 31, 2009 | 357121 | 51944 |  | 2009-03-01 00:00:00 | 500013
 |  | Thurs - (Apr 2, 2009) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr 1, 2009 | 255969 | 40599 |  | 2009-03-08 00:00:00 | 497562
 |  | Last Week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr 2, 2009 | 205363 | 37962 |  | 2009-03-15 00:00:00 | 492518
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr 3, 2009 | 240867 | 42835 |  | 2009-03-22 00:00:00 | 500432
 |  | Fri - (Apr 3, 2009) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr 4, 2009 | 233269 | 46997 |  | 2009-03-29 00:00:00 | 497061
 |  | Last Week
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prior Week | 5141244 | 500432
 |  | Sat - (Apr 4, 2009) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last Week | 5082256 | 497061
 |  | Last Week
 |  |  |  |  |  |  |  |  |  | I need for the arrows above to only display if the number next to it is ≥ 0.0% ([NAME]) or < 0.0% (Red Arrow)
Spreadsheet: 875314d1721908109-need-sum-data-vertically-te
Sheet: Summary

Emp No | Name | V | PH | S | U | A
00001 | [NAME]
00002 | Demian
00005 | [NAME]
00015 | MOHAMMAD
00018 | MEGZARI
 | Name | [NAME]
 | Leave Type | PH
 | 2023-01-01 00:00:00
 | 2023-02-01 00:00:00 |  |  |  |  |  |  | v | Vacation
 | 2023-03-01 00:00:00 |  |  |  |  |  |  | PH | Public Holdiday
 |  |  |  |  |  |  |  | S | [NAME]
 |  |  |  |  |  |  |  | U | Unpaid
 |  |  |  |  |  |  |  | A | Absent
Spreadsheet: 179109d1347030505-problem-with-formula-that-displays-contents-from-some-cells-but-not-others-pilotlog-and-techlogtest
Sheet: Rick

 | Today is
Today is: |  |  | Calculator
 | Date | Rate (hr) | Time | Cost |  | Landing fee
 |  |  |  |  |  | Running Total (outstanding)
 |  |  |  |  |  | Expenses
 |  |  |  |  |  | Date | Cost | Description
 |  |  |  |  |  | Total
 |  |  |  |  |  |  |  | Payment Record
 |  |  |  |  |  | Landing Fee
 | Total Hours Flown
 |  | Total flying costs
 | Total minus expenses
 | Total after deducting payments
Spreadsheet: mary_fischer__25740__E-20R
Sheet: E5.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #
COMPANY NAME
ANALYSIS OF GOODWILL
FOR THE 12 MONTHS ENDED 12-31-2000
PREPARED BY:
EXTENSION: |  |  |  |  |  |  |  |  |  |  |  |  |  | E-5
 |  |  |  | 12-31-99 Balance
 |  |  |  | BEGINNING |  |  |  |  |  |  |  |  |  | 12-31-2000
[NAME] OR ENTITY |  | AMORTIZATION |  | BALANCE |  |  |  |  |  | OTHER |  |  |  | BALANCE
 |  | PERIOD (Yrs.) |  | DR. (CR.) |  | ADDITIONS |  | AMORTIZATION** |  | AMOUNT |  | (DESCRIBE) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Goodwill* |  |  |  |  |  |  |  |  | ** |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 0344 | Same signs as Hyperion
**MUST TIE TO HYPERION ACCOUNT 1418 | Reverse signs from Hyperion
Spreadsheet: 217015d1361968819-add-up-if-its-a-certain-month-example
Sheet: Sheet1

jan | 200 |  |  | the month is march |  | total | 600 | b2+b3+b4
feb | 200
march | 200 |  |  | if it was april it would be |  |  | 800 | b2+b3+b4+b5
april | 200
may | 200 |  |  | so even if there were values in may and jone the total would ignore that as it not that month or past it yet
june | 200