tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2e82bdac-5064-4c20-947c-aecd1ea26619
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-08-23 09:35:20.730000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.375 | 101.632 | 101.507 | 101.382 | 101.007 |  | and are added to price quote
4.25 | 100.673 | 100.548 | 100.423 | 100.048
4.125 | 99.901 | 99.776 | 99.651 | 99.276 |  | Note: | Refer To Price [NAME]
4 | 99.411 | 99.286 | 99.161 | 98.786 |  |  | For all Price Adjs
3.875 | 98.839 | 98.714 | 98.589
3.75 | 97.732 | 97.607 | 97.482
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 101.529 | 101.404 | 101.279 | 100.904
3.625 | 100.927 | 100.802 | 100.677 | 100.302
3.5 | 100.591 | 100.466 | 100.341 | 99.966
3.375 | 100.204 | 100.079 | 99.954 | 99.579
3.25 | 99.66 | 99.535 | 99.41
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-09-06 09:35:20.730000
30 DAY | 2011-09-21 09:35:20.730000
45 DAY | 2011-10-06 09:35:20.730000
60 DAY | 2011-10-21 09:35:20.730000
90 DAY | 2011-11-20 09:35:20.730000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 133186d1324249594-match-index-missing-values-book1
Sheet: Sheet2

ticket | id | online
111101 | 101 | yes
111101 | 102 | no
111101 | 103 | no
111102 | 104 | yes
111102 | 105 | no
111103 | 103 | yes
111103 | 102 | no
111104 | 101 | no
111104 | 102 | no
Spreadsheet: 796825d1663584662-help-regarding-automatically-updating-data-in-source-sheet-sheet-1
Sheet: master sheet

235 | 2022-08-31 00:00:00 | mamagoto |  | 03:25:00 | 03:55:00 |  | Purchase manager | 8580512825 | QSR | New | veeba | 25 | No
236 | 2022-08-31 00:00:00 | guru nanak sweets |  | 04:25:00 | 04:55:00 |  | Purchase manager | 9779775788 | Restaurant | New | Veeba | 10 | No
237 | 2022-08-31 00:00:00 | [NAME] |  | 05:10:00 | 05:25:00 |  | Owner | 8289006442 | Qsr | Existing | Fun Foods | 25 | No
238 | 2022-08-31 00:00:00 | night food street |  | 05:40:00 | 05:55:00 |  | Owner | 8146246796 | Qsr | New | veeba | 96 | Yes
239 | 2022-08-31 00:00:00 | pgi canteen |  | 06:05:00 | 06:30:00 |  | Purchase manager | 977977773 | Canteen | New | food coast | 30 | yes
175 | 2022-04-21 00:00:00 | Cold fusion | Sector-68 | 12:10:00 | 12:50:00 | Indeerjeet | owner | 9888801265 | QSR | Existing | fun foods | 6 | no
176 | 2022-04-21 00:00:00 | Coffee full Day | Sector-34C | 01:00:00 | 02:00:00 | Shankar | Owner | 9417133209 | QSR | New | Veeba | 20 | No
177 | 2022-04-21 00:00:00 | Pizza house 34 | Sector-34C | 03:00:00 | 03:45:00 | kamal | Owner | 8699174282 | QSR | New | Veeba | 15 | No
178 | 2022-04-21 00:00:00 | Master [NAME] | Sector-34C | 04:00:00 | 04:45:00 | Ritesh | Owner | 7719675199 | QSR | New | Veeba | 15 | No
179 | 2022-04-21 00:00:00 | Hunger hackers | Sector37-D | 05:10:00 | 05:30:00 | Manish sharma | Owner | 7710500995 | QSR | New | veeba | 5 | NO
 |  |  | any changes made here I want to be automatically updated in the source sheets.
Spreadsheet: john_griffith__16041__2_6_02GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 59 | 480 | 550 | 44.8 | 51.3 | 1.78 | 2002-02-06 11:19:00
 | [NAME] | 66 | 825 | 925 | 43.9 | 49.2 | 1.93 | 2002-02-06 11:19:00
 | [NAME] | 66 | 1040 | 1140 | 43.1 | 47.3 | 1.88 | 2002-02-06 11:19:00
 | [NAME] | 66 | 1200 | 1300 | 41.9 | 45.4 | 1.81 | 2002-02-06 11:19:00
 | HU N2 | 66 | 1275 | 1375 | 39.9 | 43.1 | 1.72 | 2002-02-06 11:19:00
 | [NAME] | 65 | 1300 | 1400 | 37.5 | 40.4 | 1.59 | 2002-02-06 11:19:00
 | HU U2 | 63 | 1325 | 1475 | 36.4 | 40.5 | 1.52 | 2002-02-06 11:19:00
 | [NAME] | 60 | 1300 | 1400 | 35.2 | 37.9 | 1.38 | 2002-02-06 11:19:00
 | [NAME] | 59 | 1300 | 1450 | 33.6 | 37.5 | 1.32 | 2002-02-06 11:19:00
 | [NAME] | 59 | 1300 | 1450 | 32.1 | 35.8 | 1.26 | 2002-02-06 11:19:00
 | HU F3 | 59 | 1300 | 1450 | 30.7 | 34.3 | 1.21 | 2002-02-06 11:19:00
 | [NAME] |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | HU H3
 | [NAME]
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | HU M3
Spreadsheet: 751178d1633953894-search-value-match-and-add-it-to-corresponding-value-in-different-sheet-test1
Sheet: tem

W21 | XS | 101 |  | XSD101C
W21 | XS | 101 |  | XSD101C
W21 | XS | 102 |  | XSD102L
W21 | XS | 102 |  | XSD102L
W21 | XS | 153
W21 | XS | 154
W21 | XS | 167
W21 | XS | 167
W21 | XS | 167
W21 | XS | 168
W21 | XS | 168
W21 | XS | 168
Spreadsheet: 0cca5cbd-5411-461e-a7ca-2dfdbd171ea6
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-10-24 09:30:06.730000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.5 | 101.492 | 101.367 | 101.242 | 100.867 |  | and are added to price quote
4.375 | 101.009 | 100.884 | 100.759 | 100.384
4.25 | 100.282 | 100.157 | 100.032 | 99.657 |  | Note: | Refer To Price [NAME]
4.125 | 99.846 | 99.721 | 99.596 | 99.221 |  |  | For all Price Adjs
4 | 99.378 | 99.253 | 99.128 | 98.503
3.875 | 98.828 | 98.703 | 98.578 | 97.953
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 101.467 | 101.342 | 101.217 | 100.842
3.75 | 100.972 | 100.847 | 100.722 | 100.347
3.625 | 100.376 | 100.251 | 100.126 | 99.751
3.5 | 100.041 | 99.916 | 99.791 | 99.416
3.375 | 99.592 | 99.467 | 99.342 | 98.717
3.25 | 99.088 | 98.963 | 98.838 | 98.213
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-11-07 09:30:06.730000
30 DAY | 2011-11-22 09:30:06.730000
45 DAY | 2011-12-07 09:30:06.730000
60 DAY | 2011-12-22 09:30:06.730000
90 DAY | 2012-01-21 09:30:06.730000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 38105d1236215042-excel-2007-averaging-s-only-when-data-is-placed-not-counting-blank-cells-monthly-gas-report
Sheet: 9-14 thru 9-20

 |  |  |  |  |  | Corp:
 |  |  | 2009-09-14 00:00:00 |  | Thru
 |  | Mon | Tue | Wed | Thur | Fri | Sat | Sun
Technician |  | 2009-09-14 00:00:00 |  |  |  |  |  |  | Total
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
 |  |  |  |  |  |  | Total:
Spreadsheet: 121472d1316089113-assign-an-id-to-a-name-or-date-of-birth-create_id
Sheet: Foglio1

Surname Name | Date of Birth | ID
[NAME] | 1931-12-08 00:00:00 | 1
[NAME] | 1931-12-08 00:00:00 | 1
[NAME] | 1931-12-08 00:00:00 | 1
[NAME] | 1931-12-08 00:00:00 | 1
[NAME] | 1931-12-08 00:00:00 | 1
[NAME] | 1931-12-08 00:00:00 | 1
[NAME] | 1931-12-08 00:00:00 | 1
[NAME] | 1931-12-08 00:00:00 | 1
[NAME] | 1931-12-08 00:00:00 | 1
[NAME] | 1931-12-08 00:00:00 | 1
[NAME] | 1931-12-08 00:00:00 | 1
[NAME] | 1931-12-08 00:00:00 | 1
[NAME] | 1931-12-08 00:00:00 | 1
[NAME] | 1931-12-08 00:00:00 | 1
[NAME] | 1931-12-08 00:00:00 | 1
[NAME] | 1931-12-08 00:00:00 | 1
[NAME] | 1925-03-27 00:00:00 | 2
[NAME] | 1925-03-27 00:00:00 | 2
[NAME] | 1926-05-18 00:00:00 | 3
[NAME] | 1926-05-18 00:00:00 | 3
[NAME] | 1933-02-04 00:00:00 | 3
Spreadsheet: 188159d1350710679-retrieve-player-names-from-another-sheet-having-a-database-of-duplicate-team-names-excelforum-_solution_2
Sheet: Pivot1

Count of Name
Team | Name | Total
Team 1 | Ally | 1
 | Kerry | 1
 | Mark | 1
Team 2 | [NAME] | 1
Team 3 | [NAME] | 1
 | [NAME] | 1
 | [NAME] | 1
Team 4 | [NAME] | 1
 | [NAME] | 1
Team 5 | [NAME] | 1
 | Hank | 1
 | [NAME] | 1
Grand Total |  | 12
Spreadsheet: 883137d1731616755-automated-chronological-date-sorting-for-completed-bucket-list-goals-sample-11-segments
Sheet: Bucket List

 |  |  |  | BUCKET LIST |  |  | BUCKET LIST |  |  | BUCKET LIST |  |  | BUCKET LIST |  |  | BUCKET LIST |  |  | BUCKET LIST |  |  | BUCKET LIST |  |  | BUCKET LIST |  |  | BUCKET LIST |  |  | BUCKET LIST |  |  | BUCKET LIST
 |  |  |  | Segment 1 |  |  | Segment 2 |  |  | Segment 3 |  |  | Segment 4 |  |  | Segment 5 |  |  | Segment 6 |  |  | Segment 7 |  |  | Segment 8 |  |  | Segment 9 |  |  | Segment 10 |  |  | Segment 11
 |  |  |  | Goal | Completed | Date | Goal | Completed | Date | Goal | Completed | Date | Goal | Completed | Date | Goal | Completed | Date | Goal | Completed | Date | Goal | Completed | Date | Goal | Completed | Date | Goal | Completed | Date | Goal | Completed | Date | Goal | Completed | Date
 |  |  |  | Goal 1 | √ | 2024-01-01 00:00:00 | Goal 1 | √ | 2024-01-01 00:00:00 | Goal 1 | √ | 2024-01-01 00:00:00 | Goal 1 | √ | 2024-01-01 00:00:00 | Goal 1 | √ | 2024-01-01 00:00:00 | Goal 1 | √ | 2024-01-01 00:00:00 | Goal 1 | √ | 2024-01-01 00:00:00 | Goal 1 | √ | 2024-01-01 00:00:00 | Goal 1 | √ | 2024-01-01 00:00:00 | Goal 1 | √ | 2024-01-01 00:00:00 | Goal 1 | √ | 2024-01-01 00:00:00
 |  |  |  | Goal 2 | √ | 2024-03-01 00:00:00 | Goal 2 | √ | 2024-03-01 00:00:00 | Goal 2 | √ | 2024-03-01 00:00:00 | Goal 2 | √ | 2024-03-01 00:00:00 | Goal 2 | √ | 2024-03-01 00:00:00 | Goal 2 | √ | 2024-03-01 00:00:00 | Goal 2 | √ | 2024-03-01 00:00:00 | Goal 2 | √ | 2024-03-01 00:00:00 | Goal 2 | √ | 2024-03-01 00:00:00 | Goal 2 | √ | 2024-03-01 00:00:00 | Goal 2 | √ | 2024-03-01 00:00:00
 |  |  |  | Goal 3 | √ | 2024-12-01 00:00:00 | Goal 3 | √ | 2024-12-01 00:00:00 | Goal 3 | √ | 2024-12-01 00:00:00 | Goal 3 | √ | 2024-12-01 00:00:00 | Goal 3 | √ | 2024-12-01 00:00:00 | Goal 3 | √ | 2024-12-01 00:00:00 | Goal 3 | √ | 2024-12-01 00:00:00 | Goal 3 | √ | 2024-12-01 00:00:00 | Goal 3 | √ | 2024-12-01 00:00:00 | Goal 3 | √ | 2024-12-01 00:00:00 | Goal 3 | √ | 2024-12-01 00:00:00
 |  |  |  | Goal 4 | √ | 2025-01-01 00:00:00 | Goal 4 | √ | 2025-01-01 00:00:00 | Goal 4 | √ | 2025-01-01 00:00:00 | Goal 4 | √ | 2025-01-01 00:00:00 | Goal 4 | √ | 2025-01-01 00:00:00 | Goal 4 | √ | 2025-01-01 00:00:00 | Goal 4 | √ | 2025-01-01 00:00:00 | Goal 4 | √ | 2025-01-01 00:00:00 | Goal 4 | √ | 2025-01-01 00:00:00 | Goal 4 | √ | 2025-01-01 00:00:00 | Goal 4 | √ | 2025-01-01 00:00:00
 |  |  |  | Goal 5 | √ | 2024-05-01 00:00:00 | Goal 5 | √ | 2024-05-01 00:00:00 | Goal 5 | √ | 2024-05-01 00:00:00 | Goal 5 | √ | 2024-05-01 00:00:00 | Goal 5 | √ | 2024-05-01 00:00:00 | Goal 5 | √ | 2024-05-01 00:00:00 | Goal 5 | √ | 2024-05-01 00:00:00 | Goal 5 | √ | 2024-05-01 00:00:00 | Goal 5 | √ | 2024-05-01 00:00:00 | Goal 5 | √ | 2024-05-01 00:00:00 | Goal 5 | √ | 2024-05-01 00:00:00
Spreadsheet: 123919d1317926118-grouping-multi-year-values-by-category-in-a-chart-excel-help-graph
Sheet: Sheet1

 |  | Revenue | Profit
Product A | 2010 | 50 | 25
 | 2011 | 65 | 32.5
 | 2012 | 84.5 | 42.25
Product B | 2010 | 25 | 12
 | 2011 | 32.5 | 15.6
 | 2012 | 42.25 | 20.28
Spreadsheet: 40062cf7-8d93-42d1-9f2f-d5e5f8ce2871
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33 | Unnamed: 34 | Unnamed: 35 | Unnamed: 36 | Unnamed: 37 | Unnamed: 38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | z
Spreadsheet: 876445d1723126112-copy-and-paste-data-if-today-is-within-x-days-of-y-date-gw_sample-file
Sheet: Sheet1

Company | Investment | Amount repaid to date |  |  | Data check date | 2024-07-31 00:00:00 | 2024-10-31 00:00:00 | 2025-01-31 00:00:00 | 2025-04-30 00:00:00 | 2025-07-31 00:00:00 | 2025-10-31 00:00:00 | 2026-01-31 00:00:00
AAA | A1 | 10 |  |  | Quarter Start Date | 2024-04-01 00:00:00 | 2024-07-01 00:00:00 | 2024-10-01 00:00:00 | 2025-01-01 00:00:00 | 2025-04-01 00:00:00 | 2025-07-01 00:00:00 | 2025-10-01 00:00:00
AAA | A2 | 20 |  |  | Quarter End Date | 2024-06-30 00:00:00 | 2024-09-30 00:00:00 | 2024-12-31 00:00:00 | 2025-03-31 00:00:00 | 2025-06-30 00:00:00 | 2025-09-30 00:00:00 | 2025-12-31 00:00:00
BBB | B1 | 5 |  | Total repaid per company | AAA
BBB | B2 | 0 |  |  | BBB
BBB | B3 | 0 |  |  | CCC
CCC | C1 | 40 |  |  | DDD
CCC | C2 | 40
CCC | C | 40
DDD | D1 | 12
DDD | D2 | 15
Spreadsheet: 779749d1652082824-index-match-with-multiple-criteria-blanks-and-drop-down-lists-with-formula-index-match-multiple-criteria
Sheet: Sheet3

Person: | Person A | ß [NAME]-down list
Time Between: | Column 7 & Column 9 | ß [NAME]-down list
Total | Total | Total | Total | Total | Total | Total
Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 |  | ß Header changes based on cell B2
Spreadsheet: 230f0fd7-04de-439b-9e5c-21cf073e8990
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6637 | 47273 | Helena | Candel Muñoz | ESP | 264 | 00:16:05 | 00:01:26 | 01:42:34 | 00:00:43 | 00:31:45 | 1 | 02:32:33
Spreadsheet: 879090d1726544723-average-of-range-base-on-drop-down-average
Sheet: Sheet1

 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00
A | 6528 | 6365 | 5837
B | 6245 | 1791 | 1879 | 575 | 2718
C | 1453 | 6006 | 5296 | 3861 | 3921 | 7389 | 7214 | 6604 | 6674 | 2412 | 7850
D | 5097 | 1565 | 5170 | 3795 | 815
E | 3576 | 5352 | 7492 | 1713 | 3030 | 0 | 0
F | 5025 | 4611 | 4440 | 5853 | 2809 | 2158
G | 2423 | 4965 | 1130 | 4607 | 1114 | 3994 | 3117 | 4806 | 2741 | 1904 | 700 | 5889
 |  |  |  | *How do I make the formula dynamtic, Average of B:M base on D18.
 |  |  |  | *However, [NAME], Error and 0???
 |  |  | C |  | <--- Sample
 |  |  | E |  | <---- Result should ignore 0 value
Spreadsheet: 716085d1612016787-how-can-i-find-max-value-of-per-consecutive-data-sample
Sheet: Sheet4

PCode | Sales Number |  | PCode | Sales Number
A4 | 728
A4 | 197
A4 | 604
A4 | 328
A10 | 81
A4 | 89
A10 | 534
A10 | 270
A4 | 70
Spreadsheet: c08a861b-6323-41b9-bc2d-cb9ea777e794
Sheet: Recycling & Events

 |  | 1. Recycling & Events |  |  |  |  | Comments |  | Click here to return to Summary page
 |  | Green Actions
 |  | ACTION | Credit | Points Eearned | Total Possible Points
 |  | A) Recycling procedures were discussed at staff meeting | 2 Pts, Enter "YES" or "NO" in cell below this one. |  | 3
 |  |  | NO
 |  | B) Recycling signs/posters are posted | 2 Pts, Enter "YES" or "NO" in cell below this one. |  | 2 |  |  |  | FILL IN THE GREEN CELLS ONLY
 |  |  | NO |  |  |  |  |  | CALCULATIONS ARE DONE AUTOMATICALLY
 |  | C)  [NAME] in all common areas where trash bins are present | 6 Pts, Enter "YES", "NO", or "N/A" in cell below this one.
 |  | Deskside-next to all trash bins | NO |  | 2
 |  | Kitchen/lounge | NO
 |  | Mail room/copy room | NO
 |  | D) [NAME] and Printer Toners are recyled | 2 Pts, Enter "YES"  "NO" or "N/A" in cell below this one.
 |  |  | NO
 |  | E) Special materials are collected            -Disks, transparencies, tyvek | 2 Pts, Enter "YES"  "NO" or "N/A" in cell below this one.
 |  |  | NO
 |  | F) Contact Property Services to dispose of big office equipment to see if they can be salvaged | 2 Pts, Enter "YES", "NO", or "N/A" in cell below this one.
 |  |  | NO
 |  | G) Do you ever have and/or plan events? | 2 Pts, Enter "YES", "NO", or N/A in cell below this one.
 |  | If yes...Are they Zero Waste events? | NO
 |  | Total Events & Waste Points
Spreadsheet: 102878d1300798765-why-does-conditional-formatting-stop-autofit-working-conditional-formats
Sheet: Sheet1

Total | 13924 | 13924
Year | 2011/12 | 2011/12
Year No | Year1 | Year1
1 | 15738 | 15738 | 1
2 | 1385 | 1385 | 1
3 | 2470 | 2470 | 1
4 | 42 | 42 | 1
5 | 220 | 220 | 1
6 | 5518 | 5518 | 1
7 | 2296 | 2296 | 1
8 | -140 | -140 | 1
9 | -14 | -14 | 1
10 | -23514 | -23514 | 1
11 | 38741 | 38741 | 1
12 | 3765 | 3765 | 1
13 | 2934 | 2934 | 1
14 | 407 | 407 | 1
15 | 21 | 21 | 1
16 | 2802 | 2802 | 1
17 | 1857 | 1857 | 1
18 | 1 | 1 | 1
19 | 2 | 2 | 1
20 | 0 | 0 | 1
21 | -137 | -137 | 1
22 | -9 | -9 | 1
23 | -50384 | -50384 | 1
24 | 80084 | 80084 | 1
25 | 16468 | 16468 | 1
26 | 4725 | 4725 | 1
27 | 632 | 632 | 1
28 | 470 | 470 | 1
29 | 4720 | 4720 | 1
30 | 6503 | 6503 | 1
31 | 451 | 451 | 1
32 | 5 | 5 | 1
33 | 0 | 0 | 1
34 | 1628 | 1628 | 1
35 | -4721 | -4721 | 1
36 | -310 | -310 | 1
37 | -110656 | -110656 | 1
38 | 9924 | 9924 | 1
Spreadsheet: 25404d1216712005-need-help-weights-n-prices
Sheet: Sheet1

Sr. | part numbers | weights | prices
1 | 5234 | 1 | 25
2 | 4254 | 0.5 | 5
3 | 903 | 1 | 4
4 | 3444 | 0.2 | 3
5 | 8889 | 2 | 10
Spreadsheet: phillip_m_love__30141__200001_OA
Sheet: TX-HPLR-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  HPLR
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 115828 | 268689.8400000036
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 0 | 0.4100000001490116
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 115828 | 268690.2500000037
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | 0 | -5.939999997615814
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | 0 | -1
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 0 | -1.819999999999709
 | Total Purchases: |  | 0 | -8.759999997615523
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 0 | 0.2800000011920929
12 |  | Purchases | -232540 | -538353.0099999905
 | Total Intra CTS Sales / Purchases |  | -232540 | -538352.7299999893
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 0 | 0
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0.4499999992549419
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0.4499999992549419
 | Total Storage: |  | 0 | 0.4499999992549419
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | 116712 | 265303.2270877734
 |  |  | 0 | 0
23 | Fuel: |  | 14 | 0
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | 0
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | 0
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 0
31 |  | Prior Month Book Balance | 0 | 0
 |  | Total MTM Income | 0 | 0
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 0
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 0
 |  | TOTAL INTRA-MTH
Spreadsheet: 90558d1290292161-search-for-match-across-selected-tabs-financeguy57-ef753961-sdg13
Sheet: Current Day Sales

Sales | Salesperson | Price
yellow bike
red bike
green bike
 |  |  |  |  |  |  |  |  |  |  |  | how can I search tabs 2-4 ([NAME]) NOT the first tab and have the tab name generate in column B?
 |  |  |  |  |  | Today, 04:29 PM
 |  |  |  |  |  | financeguy57 - EF753961 - SDG13.xls
 |  |  |  |  |  | Registered User   Join Date: 19 Oct 2010
 |  |  |  |  |  | Location: New York
 |  |  |  |  |  | MS Office Version:Excel 2003
 |  |  |  |  |  | Posts: 5
 |  |  |  |  |  | Search for match across selected tabs
 |  |  |  |  |  | http://www.excelforum.com/excel-miscellaneous/753961-search-for-match-across-selected-tabs.html
 |  |  |  |  |  | I have a column of data that I would like to find an equal match across selected tabs and generate the name of the tab as a result.
 |  |  |  |  |  | I cannot search ALL tabs because this will corrupt the results unless more than one tab name can populate in the results.
 |  |  |  |  |  | I have attached a spreadsheet as an example.
 |  |  |  |  |  | Any direction you could provide would be greatly appreciated.
 |  |  |  |  |  | Many Thanks,
 |  |  |  |  |  | ALH