tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0081c4ff-12f8-4e46-a763-93e84f382ce3
Sheet: Level of Instruction

LEVEL OF INSTRUCTION CODES
This classification permits expenditures to be segregated by instructional level.  Many state departments of education differentiate elementary, secondary, and postsecondary costs so they can calculate interdistrict tuition rates, compute general state aid, or both.
NCES Brief code descriptions (see bottom section for subcategories and detail descriptions):
10 | K-Elementary
20 | Middle
30 | Secondary
40 | Postsecondary/Adult
50 | Other Combination.
Code | Description
LEVEL OF INSTRUCTION
10 | [NAME].  A school organization classified as elementary by state and local practice and composed of any span of grades from preprimary through eighth grade.
11 | Pre-Kindergarten.  A school organization composed entirely of any span of ages below kindergarten.  This category is normally used for students identified as needing special services.
12 | [NAME],  A school organization for children for the year immediately preceding the first grade.
19 | Other Elementary,  A school organization composed of any span of grades not above grade eight except pre-kindergarten and kindergarten.
20 | Middle.  A school organization composed of at least three grades, usually beginning with grade 5 or grade 6 or the equivalent.  Most middle school organizations presume that a four year high school will follow the middle school.
30 | Secondary.  A school organization comprising any span of grades beginning with the next grade following an elementary or middle school and ending with or below grade 12.
31 | Junior High.  A secondary school organization intermediate between the elementary and senior high school, usually including grades 7, 8, and 9 (in a 6-3-3 plan) or grades 7 and 8 (in a 6-2-4 plan).
32 | Senior High.  A school organization offering the final years of high school work necessary for graduation and invariably preceded by a junior high or middle school.
39 | Other Secondary.  For Example, a grades 7-12 high school.
40 | Postsecondary/Adult.  A school organization for adults who have completed, interrupted, or not begun their formal education or for students attending an institution of higher learning.
41 | Programs for Adult/Continuing.  A program for adults who have interrupted, not completed, or not begun their formal education and are pursuing skills or knowledge in programs that have as their purpose the upgrading or training of occupational skills, the pursuit of special interests, GED Certification, Adult High School Diploma Program, or enrichment.  (Non-Completers)
42 | Programs for Adult/Postsecondary.  A program for adults and students who have completed secondary education and are attending an institution of higher learning.  (Completers)
50 | Other Combination.  A school organization composed of at least two (or more) levels of instruction not included in Level of Instruction codes 19 or 39.  An example would be the school organization in a remote rural area which might encompass grades K-12.
Spreadsheet: 97e6b554-64bb-48d2-9bba-d06fd1ca5c26
Sheet: Budget Adjustment

BUDGET ADJUSTMENT
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
Brief Title |  | Approval Deadline |  |  | Reason
Details |  |  |  |  | Department, Program, or Accounts Affected
Reason for Adjustment |  |  |  |  | Sponsor
 |  |  |  |  | From/Transferor(s) or Fund Title(s)
 |  |  |  |  | To/Transferee(s) or [NAME])
 |  |  |  |  | Policy / Program Impact
 |  |  |  |  | Policy or Program | No | Yes
 |  |  |  |  | Emphasis Change
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Council Committee Actions
 |  |  |  |  | Do Pass |  | Hold
 |  |  |  |  | Do Pass (as amended) |  | w/o Recommendation
 |  |  |  |  | Committee Sub. |  | Do Not Pass
Is It Good For The Children?
 |  |  |  |  | Fact Sheet prepared by: |  | Date
How will this contribute to a sustainable Kansas City? |  |  |  |  | Fact Sheet reviewed by: |  | Date
 |  |  |  |  | Reference Numbers
Spreadsheet: chris_germany__1681__FSS-cheetsheet
Sheet: Jan 2000 

FSS Cheat Sheet
INJECTIONS: STORAGE GAS LOSS RETAINAGE APPLIES
MMIQ (Maximum Monthly Injections Quantity) |  |  |  |  | SCQ = | 7503838
 |  | % of SCQ | MMIQ | 1.05
April |  | 0.15
May - Aug |  | 0.2
Sept |  | 0.13
Oct |  | 0.07
Nov |  | 0.05
Dec - Mar |  | 0.1
If 105% MMIQ is exceded a penatly of $5.00/dkt for all quantitiels injected in excess of 105% of its
MMIQ will be assessed.
MDIQ (MAXIMUM DAILY INJECTION QUANTITY)
MMIQ/30 | For November & December
MMIQ/25 | For Rest of the Months
 | April | May-Aug | Sept | Oct | Nov | Dec | Jan-Mar
MDIQ
110%MDIQ
If 110% of MDIQ is exceeded a penalty of $5.00 per dth for all quantities injected in excess of 110%
of its MDIQ will be assessed.
WITHDRAWALS: MDWQ BASED UPON AND LIMITED BY SCQ INVENTORY
REMAINING IN STORAGE.
% of SCQ in Inventory |  |  |  | MDWQ as % of MDSQ |  |  | MDSQ = | 134743
100% to 30% |  |  |  | 1
less than 30% to 20% |  |  |  | 0.8
less than 20% to 10% |  |  |  | 0.65
less than 10% to 0% |  |  |  | 0.5
If 103% of MDWQ is exceeded a penalty of $10.00 per dkt for all quantitites withdrawn in excess
of 103% of its MDWQ will be assessed.
Minimum and [NAME] net withdrawal for November thru March
 |  | Min % |  |  | [NAME]
Month |  | of SCQ |  |  | of SCQ
November |  | none |  |  | 0.4
December |  | none |  |  | 0.4
January |  | none |  |  | 0.4
February |  | 0.1 |  |  | 0.3
March |  | 0.1 |  |  | 0.2
If monthly net withdrawal exceeds applicable limits a penalty of $5.00 per dkt for all quantities
withdrawn in excess of such limits will be assessed.
INVENTORY: |  | no more than x% in SCQ in storage
April 1st |  | 0.25
February 1st |  | 0.65
June 30th |  | 0.6
August 31st |  | 0.85
Spreadsheet: 758671d1638993854-is-there-any-possiblity-to-do-several-plots-out-of-a-column-in-one-diagram-excel_plot
Sheet: Tabelle1

 | Date | Timestamp | Boolean | elapsed time [h] | Value | serie | 0 | 1 | 2
 | 2021-12-07 00:00:00 | 14:00:00 | False | 0 | 1e-06
 | 2021-12-08 00:00:00 | 15:00:00 | False | 25 | 8e-07
 | 2021-12-09 00:00:00 | 15:30:00 | False | 49.5 | 5e-07
 | 2021-12-09 00:00:00 | 17:12:00 | True | 1.699999999999999 | 5e-07
 | 2021-12-10 00:00:00 | 15:54:00 | False | 24.4 | 4e-07
 | 2021-12-10 00:00:00 | 17:00:00 | False | 25.5 | 3.8e-07
 | 2021-12-11 00:00:00 | 02:00:00 | False | 34.5 | 3.8e-07
 | 2021-12-12 00:00:00 | 15:34:00 | False | 72.06666666666666 | 3.5e-07
 | 2021-12-12 00:00:00 | 16:00:00 | False | 72.5 | 2.1e-07
 | 2021-12-14 00:00:00 | 13:00:00 | False | 117.5 | 1e-07
 | 2021-12-14 00:00:00 | 15:00:00 | True | 2.000000000000001 | 9e-08
 | 2021-12-15 00:00:00 | 09:00:00 | False | 20 | 8.5e-08
 | 2021-12-15 00:00:00 | 13:00:00 | False | 24 | 8.4e-08
 | 2021-12-16 00:00:00 | 01:20:00 | False | 36.33333333333334 | 8.3e-08
Spreadsheet: 757725d1638433368-how-to-show-data-based-on-a-date-ae-isr-planner-gk-1-
Sheet: InsideSales

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4
 | User Goals by Quarter |  |  |  |  |  |  |  |  |  | AE Name | Start Date | Attainment | 2022-01-01 00:00:00 |  | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
 |  | Q1 | 750 | Q2 | 750 |  |  |  |  |  | B | 2021-01-01 00:00:00 | 1 |  | ---
 |  |  |  |  |  |  |  |  |  |  | H | 2021-05-01 00:00:00 | 1 |  | ---
 |  | Q3 | 1000 | Q4 | 1500 |  |  |  |  |  | S | 2021-03-01 00:00:00 | 1 |  | ---
 |  |  |  |  |  |  |  |  |  |  | S | 2021-07-01 00:00:00 | 1 |  | ---
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | ---
 |  | Ramp Up Time (in days) |  |  | 29 |  |  |  |  |  |  |  | 0 |  | ---
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | ---
 |  | 2023 Quota Increase |  |  | 0 |  |  |  |  |  |  |  | 0 |  | ---
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | ---
 |  | Attainment % |  |  | 1 |  |  |  |  |  |  |  | 0 |  | ---
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | ---
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | ---
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | ---
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | ---
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | ---
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | ---
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | ---
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | ---
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | ---
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | ---
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | ---
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | ---
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | ---
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | ---
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | ---
 |  |  |  |  |  |  |  |  |  |  |  |  | Total by Month
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If Quota Increases
Spreadsheet: 785037d1656093034-overlap-of-date-and-time-test2
Sheet: Details

Day | [NAME] | Start Time | Leave Time |  |  |  | [NAME] | Total Time | Total Minutes
Day 1 | Snowwhite111 | 2022-06-08 08:57:50 | 2022-06-08 10:39:10 |  |  |  | Snowwhite111 |  |  | This is used for calculating point for attendancy.  Points are awarded by amount of minutes attending the event.  In this multi day scenerio you will see records of individuals attending and leaving and coming back and then leaving again.  These calculations are easy to calculate, see Snowwhite111.  But as we see [NAME], he joined on multiple devices and we are duplicating his minutes in this calculation.  I need a calculation that will calculate all time in and out unless it overlaps time already being calculated.  [NAME] should calculate row 9 only for day 1 since rows 10 and 11 overlap row 9, it should then add in row 12 since this is a new day.
Day 1 | Snowwhite111 | 2022-06-08 08:02:13 | 2022-06-08 08:51:09 |  |  |  | Sleepyabc
Day 1 | Snowwhite111 | 2022-06-08 08:52:00 | 2022-06-08 08:57:56 |  |  |  | Docnyc
Day 2 | Snowwhite111 | 2022-06-09 08:57:50 | 2022-06-09 10:39:10 |  |  |  | Grumpy367
Day 1 | Grumpy367 | 2022-06-08 08:51:06 | 2022-06-08 10:39:41 |  |  |  |  |  |  | Note, if I need to calculate each day seperately I can do that and then piece them together.
Day 1 | Grumpy367 | 2022-06-08 08:02:45 | 2022-06-08 08:51:11
Day 2 | Grumpy367 | 2022-06-09 08:02:45 | 2022-06-09 09:51:11
Day 1 | Docnyc | 2022-06-08 08:02:04 | 2022-06-08 10:39:56
Day 1 | Docnyc | 2022-06-08 08:05:10 | 2022-06-08 10:04:56
Day 1 | Docnyc | 2022-06-08 10:04:41 | 2022-06-08 10:39:18
Day 2 | Docnyc | 2022-06-09 08:04:41 | 2022-06-09 10:39:18
Day 1 | Sleepyabc
Day 2 | Sleepyabc
Spreadsheet: 881695d1729840139-return-value-based-on-date-and-time-in-separate-columns-calendar
Sheet: Sheet1

DATE | 00:00 | 05:00 | 07:00 | 08:00 | 09:00 | 10:00 | 14:00 | 16:00 | 17:00 | 18:00 | 19:00 | 21:00 | 22:00 | 1
2024-10-24 00:00:00 |  |  |  |  |  |  |  |  |  | Employee #01
2024-10-25 00:00:00 |  | Employee #02
2024-10-26 00:00:00 |  |  |  | Employee #03
2024-10-27 00:00:00 |  |  | Employee #04
2024-10-28 00:00:00 |  | Employee #05
2024-10-29 00:00:00 |  |  |  |  | Employee #06
2024-10-30 00:00:00 |  |  |  |  |  | Employee #07
2024-10-31 00:00:00 |  |  |  |  |  | Employee #08
2024-11-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Employee #09
2024-11-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Employee #10
2024-11-03 00:00:00 |  |  |  |  |  |  |  |  | Employee #11
2024-11-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | Employee #12
2024-11-05 00:00:00 |  |  |  |  |  |  | Employee #13
2024-11-06 00:00:00 |  |  |  |  |  |  |  | Employee #14
2024-11-07 00:00:00 |  |  |  |  | Employee #15
2024-11-08 00:00:00 | Employee #16
Spreadsheet: 2230d87e-90cb-4bda-919f-99ad4c4feadc
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Records | 80688421021 | Imperials | Best Of Imperials | 1981-09-01 | Compact Disc | Ac | 9.99 | Y | Available
Word Distribution Rec | 80688445522 | Imperials | Imperials Legacy-Boxed St | 1996-04-23 | Compact Disc | Ac | 19.99 | N | To Be Retired
Daywind Rec | 614187141922 | Stamps Quartet & Imperials | Gospel Side Of Elvis, The | 2004-10-26 | Compact Disc | [NAME] | 16.99 | N | To Be Retired
Special Markets Product Rec | 80688889029 | Imperials | Ultimate Collection, The | 2014-06-03 | Compact Disc | Ac | 9.99 | Y | Available
Spreadsheet: 37972d1236082720-dropdown-menu-data-no-longer-visible-trailer-sheet
Sheet: Sheet1

Trailer Log Sheet
[NAME]
Film Company
Rating
Picture Format
Sound Formats
O.C Discs
Trailers |  | 1.)
 |  | 2.)
 |  | 3.)
 |  | 4.)
 |  | 5.)
 |  | 6.)
 |  | 7.)
Comments
NR
G
PG
PG-13
R
Spreadsheet: 839881d1692277776-count-on-match-formula-excel-help-v1
Sheet: Help

NAME | LEVEL |  | NAME | High | Meduim | Low |  | Question
[NAME] | High |  | [NAME] |  |  |  | < | Need formula to populate how many of each level for each person
[NAME] | Medium |  | [NAME]
[NAME] | Low |  | [NAME]
[NAME] | High |  | [NAME]
Elizah | Medim |  | Elizah
Fred | Low |  | Fred
[NAME] | High |  | [NAME]
[NAME] | Medim |  | [NAME]
[NAME] | Low |  | [NAME]
[NAME] | High |  | [NAME]
Jenifer | Medim |  | Jenifer
[NAME] | High
[NAME] | Medium
[NAME] | Low
[NAME] | High
Elizah | Medim
Fred | Low
[NAME] | High
[NAME] | Medim
[NAME] | Low
[NAME] | High
Jenifer | Medim
[NAME] | High
[NAME] | Medium
[NAME] | Low
[NAME] | High
Elizah | Medim
Fred | Low
[NAME] | High
[NAME] | Medim
[NAME] | Low
[NAME] | High
Jenifer | Medim
Spreadsheet: 775288d1648985693-combine-like-rows-based-on-if-2-or-3-columns-are-identical-and-adding-columns-that-arent-test1a
Sheet: Sheet1

TCN | name | DOB | PHONE | account
1212323 | [NAME] | 3 | 5 | 7
1212323 | [NAME] | 3 | 6 | 8
1212323 | [NAME] | 3 | 8 | 9
 | to
TCN | name | DOB | PHONE 1 | PHONE 2 | PHONE 3 | account 1 | account 2 | account 3
1212323 | [NAME] | 3 | 5 | 6 | 8 | 7 | 8 | 9
Spreadsheet: darrell_schoolcraft__7321__imball0202
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 75695 | 78800
2 | 94691 | 93799
3 | 94498 | 93799
4 | 94115 | 93799
5 | 111473 | 110461
6 | 94006 | 93799
7 | 94007 | 93799
8 | 96300 | 96299
9 | 94782 | 93799
10 | 95002 | 93799
11 | 93951 | 93799
12 | 90782 | 90776
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 28675
2002-02-12 00:00:00
CBS Volume
 |  |  | -42160
Spreadsheet: 833315d1686902073-transform-discreet-data-set-into-multiple-columns-test-file
Sheet: Sheet1

header | Helper
1
2
0
3
4
5
0
0
6
7
8
0
9
0
0
0 |  |  |  |  |  |  |  |  | imported data that needs manipulation
10 |  |  |  |  |  |  |  |  | expected output
11
12
0
0
0
0
13
14
15
16
17
18
Spreadsheet: 52471d1252240623-a-way-to-get-the-cell-references-in-a-formula-change-book1
Sheet: Sheet1

 |  |  |  |  | Start Month | Jan |  | ["January" is manually changed to: February, March, april,…Dec ]
 |  |  |  |  |  |  | Is there a way of making this change [in Cell G4] lead
Item | Value 1 | Value 2 | Value 3 |  | Item | Sum | to a change in the cell references (of the start of each range) in the formula
A | 20 |  | 17 | Jan | A | 76 | from $A$8 & $B$8 to, say, $A$13 & $B$13 [for Feb], or $A$17 &$B$17 [for March], and so on ??
B | 15 | 10 |  |  | B | 73
 |  |  |  |  | C | 102
A | 8 | 6 |  |  | D | 75
 |  |  |  |  |  | 0
C | 13 | 11 | 24 | Feb |  | 0
B | 9 |  |  |  |  | 0
D | 5 |  | 16
D | 23 | 19 |  | Mar
A |  | 25
C |  |  | 14
B | 16 |  |  | Apr
D |  | 12
C | 27 |  | 13 | May
B |  | 5 | 18
 |  |  |  | Jun
 |  |  |  | Jul
 |  |  |  | Aug
 |  |  |  | Sep
 |  |  |  | Oct
 |  |  |  | Nov
 |  |  |  | Dec
Spreadsheet: 549280d1511550296-excel-help-excell-boards
Sheet: Sheet1

Customer Rewards Program
Name | Years Purchasing | Last Years Spend | Customer Reward
Customer 1 | 6 | 1500
Customer 2 | 1 | 1200
Customer 3 | 8 | 200
Customer 4 | 0.5 | 0
Customer 5 | 2 | 350
Customer 6 | 12 | 1800
Customer 7 | 0.25 | 0
Customer 8 | 1 | 125
Customer 9 | 3.5 | 1575
Customer 10 | 8 | 450
Customer 11 | 20 | 200
Customer 12 | 14 | 0
Customer 13 | 12 | 1100
Customer 14 | 3 | 275
Customer 15 | 6 | 0
Spreadsheet: 768773d1645116141-keeping-a-formula-constant-after-adding-columns-to-the-right-excel-test
Sheet: Sheet1

Check | ID | SUM |  | ID | SUM
 | AAPL | 129.53 |  | AAPL | 146.32
 | ABBV | 114.38 |  | ABBV | 115.5
 | ABUS | 7 |  | ABUS | 7
 | ACB | 9.7 |  | ACB | 10.37
 | AMZN | 3737.88 |  | ALEC | 34.83
 | [NAME] | 10.17 |  | AMZN | 4016.71
 | ARE | 184.33 |  | [NAME] | 10.17
 | BA | 235.47 |  | ARE | 184.33
 | BGS | 30.25 |  | AVGO | 454.5
 | BIP | 53.75 |  | BA | 230.5
 | BIPC | 76 |  | BFT | -
 | BMY | 72.82 |  | BIP | 54.75
 | BP | 26 |  | BMY | 73.09
 | C | 75.93 |  | BP | 26.13
 | CAG | 38 |  | C | 75.83
 | CCI | 181.67 |  | CAG | 38
 | CDTAF | - |  | CCI | 180.58
 | CGC | 23.46 |  | CDTAF | -
Spreadsheet: diana_scholtes__8613__Deals
Sheet: Sheet1

CounterParty | P.O.D. | MW | Delivery Pattern | Term | $ | Tariff | Currently Delivering?
CRC | Palo Verde | 50 | HLH | thru 12/31/01 | 58 |  | No
CRC | Mead | 50 | 0100 - 0600 | thru 12/31/01 | 19.5 |  | No
Burbank | Palo Verde | 25 | HLH | thru 12/31/01 | 155 |  | No
Nevada | Mead | 150 | RTC | thru 12/31/01 | 82 | WSPP | No
Sierra Pacific | Palo Verde | 125 | HLH | thru 12/31/01 | 121 | WSPP | No
Sierra Pacific | Palo Verde | 125 | LLH | thru 12/31/01 | 86 | WSPP | No
[NAME] | Mead | 100 | LLH | thru 12/31/01 | 67.5 |  | No
VEA | Mead | 40 | RTC | thru 12/31/01 | 39.33 |  | No
WAPA | Pinnacle Peak | 25 | RTC | thru 04/06/02 | 45 |  | No
San Diego | Palo Verde | 25 | LLH | thru 12/31/01 | 19.25 | Swap Contract | No
Redding | NP15 | 25 | RTC | thru 12/31/01 | 200 |  | No
NCPA | NP15 | 45 | LLH | thru 12/31/01 | 134.2 |  | No
NCPA | NP15 | 85 | HLH | thru 12/31/01 | 172.05 |  | No
Oakland Muni | NP15 | 7 | RTC | thru 12/31/01 | 187.5 |  | No
City of Roseville | NP15 | 50 | RTC | thru 4/6/02 | 49 |  | No
Waum | NP15 | 50 | LLH | thru 12/31/01 | 33.75 |  | No
Dympi | NP15 | 40 | LLH | thru 12/31/01 | 28.15 |  | No
Dympi | NP15 | 60 | HLH | thru 12/31/01 | 34.13 |  | No
Dympi | SP15 | 93 | LLH | thru 12/31/01 | 23.06 |  | No
City of Riverside | SP15 | 25 | HLH | thru 12/31/01 | 180 |  | No
[NAME] | Mid-C | 25 | HLH | thru 2/28/02 | 37.15 |  | No
McMinnville | Mid-C | 5 | RTC | thru 9/30/04 | 23.7 |  | No
Gray's Harbor | Mid-C | 10 | HLH | thru 2/28/02 | 64 |  | No
Air Products | Mid-C | 6 | RTC | thru 8/31/04 | 44.2 |  | No
Powerex | COB N/S | 176 | RTC | thru 12/31/14 | 24.73 |  | No
BPA | COB N/S | 25 | LLH | thru 12/31/01 | 42.75 |  | No
BPA | COB N/S | 25 | LLH | thru 12/31/01 | 27.25 |  | No
BPA | COB N/S | 25 | LLH | thru 12/31/01 | 43 |  | No
BPA | COB N/S | 25 | LLH | thru 12/31/01 | 43 |  | No
Santa Clara | COB N/S | 50 | HLH | thru 12/31/09 | 47.15 |  | No
Sierra Pacific | COB N/S | 25 | HLH | thru 12/31/01 | 311 |  | No
Spreadsheet: 299483d1393202303-dynamic-ranges-from-different-sheets-question-dynamic_ranges_and_sheets_question-tms
Sheet: Control

 | Symbol | All Time Max Price | 1Y Max Price |  |  | [NAME] each of the Symbol sheets to Tables
 | LYG |  |  |  |  | Rename the Table as "tab" & Symbol
 | MTU |  |  |  |  | For example: tabLYG, tabMTU, etc
 | SAN
 | BAC |  |  |  |  | =MAX( INDIRECT("tab" & Tabla1[[#This Row],[Symbol]]  & "[Close]"))
 | GE
 |  |  |  |  |  | =MAX(INDEX(INDIRECT("tab" &  Tabla1[[#This Row],[Symbol]] & "[Close]"),               MATCH(MAX(INDIRECT("tab"& Tabla1[[#This Row],[Symbol]]& "[Date]")),INDIRECT("tab" & Tabla1[[#This Row],[Symbol]] & "[[NAME]):               INDEX(INDIRECT("tab" &  Tabla1[[#This Row],[Symbol]] & "[Close]"),               MATCH(MAX(INDIRECT("tab" & Tabla1[[#This Row],[Symbol]] & "[Date]")),INDIRECT("tab" & Tabla1[[#This Row],[Symbol]] & "[Date]"),0)))
 | Note 1: Each symbol has its own sheet, and are updated daily (meaning that new rows are added on a daily basis).
 | Note 2: The formulas should get the info from the sheet named as the symbol in column B in the table above.
 | Columns:
 | 1) All Time Max Price: This is the Max Historical Close price (range from the beginning to today).
 | 2) 1Y Max Price: The Max of the range of today minus 252 days.
Spreadsheet: louise_kitchen__22573__R EWS Performance Management Dashboard 8_21
Sheet: EWS-Reviews

Business Unit | Company | Total Count | Total | Reviews Received | % of [NAME]          Received by HR
ENRON WHOLESALE SERVICES
 | ECM Treasury | 98 | 0 | 28
 | Enron Americas | 1078 |  | 432
 | Enron Broadband Services, Inc | 822 | 73 | 180
 | Enron Canada Corp | 107 |  | 38
 | Enron Engineering & Operational Services | 968 |  | 161
 | Enron Global Markets | 363 | 4 | 124
 | Enron Industrial Markets | 192 | 9 | 72
 | Enron Net Works | 1560 | 0 | 680
 | Enron Wholesale Services | 13 |  | 1
 | Wholesale EES | 35 | 0 | 29
 | EWS - Consolidated |  | 130
Spreadsheet: 544637d1508968913-trying-to-consolidate-a-number-of-sheets-into-1-example-for-excel-forum
Sheet: Sheet3

Name | Job Number | start date | Due date
name | 11115555 | 2017-05-05 00:00:00 | 2017-05-15 00:00:00
name | 11115555 | 2017-05-06 00:00:00 | 2017-05-16 00:00:00
name | 11115555 | 2017-05-07 00:00:00 | 2017-05-17 00:00:00
name | 11115555 | 2017-05-08 00:00:00 | 2017-05-18 00:00:00
name | 11115555 | 2017-05-09 00:00:00 | 2017-05-19 00:00:00
name | 11115555 | 2017-05-10 00:00:00 | 2017-05-20 00:00:00
name | 11115555 | 2017-05-11 00:00:00 | 2017-05-21 00:00:00
name | 11115555 | 2017-05-12 00:00:00 | 2017-05-22 00:00:00
name | 11115555 | 2017-05-13 00:00:00 | 2017-05-23 00:00:00
name | 11115555 | 2017-05-14 00:00:00 | 2017-05-24 00:00:00
name | 11115555 | 2017-05-15 00:00:00 | 2017-05-25 00:00:00
name | 11115555 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115556 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115557 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115558 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115559 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115560 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115561 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115562 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115563 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115564 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115565 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115566 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115567 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115568 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115569 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115570 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115571 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115572 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115573 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115574 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115575 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115576 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115577 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115578 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115579 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
Spreadsheet: 545089d1509256141-automatic-filtering-counta
Sheet: Sheet1

 | Emp01 | Emp02 | Emp03 | [NAME] | Emp05 | Emp06 | Emp07 | Emp08 | Emp09 | Emp10 | Emp11 | Emp12 | Emp13 | Emp14 | Emp15 | CountA
[NAME]
Job02
[NAME]
[NAME]
[NAME]
Job06
Job07
Job08
Job09
Job10
Job11
[NAME]
Job13
[NAME]