tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: sally_beck__33712__Metrics 0623
Sheet: West

E N R O N   N O R T H   A M E R I C A - H O T  L I S T  M E T R I C S |  |  |  |  |  |  |  |  |  |  |  |  | Team: | West Midstream
Results based on Activity through June 23, 2000 |  |  |  |  |  |  |  |  |  |  |  |  | Week | 12
 |  | Weekly Summary - 2Q00 through 1Q01
 |  | # of Transactions
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13
 |  | 2000-04-07 00:00:00 | 2000-04-14 00:00:00 | 2000-04-21 00:00:00 | 2000-04-28 00:00:00 | 2000-05-05 00:00:00 | 2000-05-12 00:00:00 | 2000-05-19 00:00:00 | 2000-05-26 00:00:00 | 2000-06-02 00:00:00 | 2000-06-09 00:00:00 | 2000-06-16 00:00:00 | 2000-06-23 00:00:00 | 2000-06-30 00:00:00
Postings Rollforward:
Beginning |  | 0
+ Entrances |  | 1 | 17 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0
- Exits |  | 0 | 0 | 2 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 2 | 0
- Executions |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ending
 | Dollar Value of Transactions
 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 |  | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Average
Postings Rollforward:
Beginning |  | 100.5
+ Entrances |  | 0 | 14.3 | 1
- Exits |  | 0 | 0 | 0
+/- [NAME] |  | 0 | 0 | -13
- Executions |  | 0 | 0 | 0
Ending
Average Deal Size
 |  |  |  |  |  |  |  | Forward Quarters
 | Actual |  |  | Current Quarter |  | Per |  |  |  |  |  |  |  | Total Year
 | 1Q00 |  |  | 2Q00 |  | Hot List |  | 3Q00 |  |  | 4Q00 |  |  | 2000 |  |  | 1Q01
 | # | $ |  | # | $ |  |  | # | $ |  | # | $ |  | # | $ |  | # | $
Executions | 1 | 2.9 |  | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  | 0 | 0
DPR/MPR |  | 5.5 |  |  | 0.506 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0
Postings | 0 | 0 |  | 4 | 16.48 |  |  | 3 | 10 |  | 8 | 64 |  |  |  |  | 1 | 5
Identified Margin
Budget |  | 13.2
$ Coverage
$ millions
Spreadsheet: 696800d1600975640-how-to-exclude-a-value-from-index-match-small-if-results-based-on-criteria-example-excel
Sheet: Sheet1

Schedule
Machine | MO No. | Customer | Item Description | Due Date | Status
A | 1 | Billy | Apples | 2020-09-01 00:00:00 | Tentative
A | 2 | [NAME] | [NAME] | 2020-09-02 00:00:00 | Complete
B | 3 | [NAME] | Orange | 2020-09-03 00:00:00 | Pending
A | 4 | Samantha | Pear | 2020-09-04 00:00:00 | Complete
C | 5 | Jones | Pear | 2020-09-05 00:00:00 | In Progress
A | 6 | Filly | Apples | 2020-09-06 00:00:00 | In Progress
B | 7 | Samantha | Pear | 2020-09-07 00:00:00 | Tentative
Machine | A
Exlude Status | Complete
Schedule by Machine = A (exclude Status = [NAME])
MO No. | Customer | Item Description | Due Date | Status
1 | Billy | Apples | 2020-09-01 00:00:00 | Tentative
6 | Filly | Apples | 2020-09-06 00:00:00 | In Progress
Machine | B
Exlude Status | Complete
Schedule by Machine = A (exclude Status = [NAME])
MO No. | Customer | Item Description | Due Date | Status
3 | [NAME] | Orange | 2020-09-03 00:00:00 | Pending
7 | Samantha | Pear | 2020-09-07 00:00:00 | Tentative
Machine | C
Exlude Status | Complete
Schedule by Machine = A (exclude Status = [NAME])
MO No. | Customer | Item Description | Due Date | Status
5 | Jones | Pear | 2020-09-05 00:00:00 | In Progress
=IFERROR(INDEX(Table1[Item Description], SMALL(IF(($C$5=Table1[Machine]), MATCH(ROW(Table1[Machine]), ROW(Table1[Machine])), ""),ROWS($A$3:[NAME]))), "")
Spreadsheet: 730827d1619976326-find-the-percentage-a-cell-is-in-a-time-range-and-the-average-time-within-each-5x20-strategy-tms-v2
Sheet: RESULTS

 |  |  |  | TimeRange is a Named [NAME] defining cells B4:B9
 | TIME TRADED % |  | Using SPILL | =IFERROR(AVERAGEIFS(DATA!C:C,DATA!C:C,">="&TIMEVALUE(LEFT(TimeRange,FIND("-",TimeRange)-1)),DATA!C:C,"<"&TIMEVALUE(RIGHT(TimeRange,(LEN(TimeRange)-FIND("-",TimeRange))))),0) | (Total Time in range) | (entries in range) | Total rows:
 |  |  |  |  | SUMIFS | COUNTIFS | SUMIFS/COUNTIFS | %AGE
 | 6:00-8:59 |  |  | =IFERROR(AVERAGEIFS(DATA!C:C,DATA!C:[NAME]:C,"<"&TIMEVALUE(RIGHT(B4,(LEN(B4)-FIND("-",B4))))),0)
 | 9:00-9:29 |  | 09:18:34.286000
 | 9:30-9:49 |  | 09:35:14.483000
 | 9:50-10:29 |  | 10:06:17.143000
 | 10:30-11:29 |  | 10:57:05.455000 |  |  |  |  |  | TMS TEST 15:00
 | 11:30-14:59 |  | 12:22:45 |  |  |  |  |  | SUMIFS | COUNTIFS
 | 15:00-16:00 |  | 15:00:00 | Note: 15:00 entry added to test the formula for this range
 | GAIN/LOSS |  |  |  | =SUMIFS(DATA!C:C,DATA!C:[NAME]:C,"<"&TIMEVALUE(RIGHT(B4,(LEN(B4)-FIND("-",B4)))))
 |  |  |  |  |  | =COUNTIFS(DATA!C:[NAME]:C,"<"&TIMEVALUE(RIGHT(B4,(LEN(B4)-FIND("-",B4)))))
 | Trading Days Span | 53 |  |  |  |  | =F4/G4
 | Trading Days |  |  |  |  |  |  | =G4/(COUNT(DATA!C:C))
 | Trading Days %
 | Total Wins
 | Total Points /share
 | Average Points /share |  |  | Excluding top 2 and bottom 2
 | Win/Loss % |  |  | Note, this is Win % on days there was a 5x20 strategy win
 | ENTRY REASON %
 | PM CONSOLIDATION
 | R2G
 | MOMO
 | CONSOLIDATION
 | PMH
 | BO
 | HIGHS %
 | Entry-High Ave |  |  | Percentage High above Entry
 | High-Close Ave |  |  | Percentage High above Close
Spreadsheet: 328471d1403904474-formulas-with-and-removes-decimal-places-cs-and-ir-paperless-template-rev-c
Sheet: Sheet1

 |  | SAMPLE
LOT SIZE | AQL | SIZE
6 | 1.5 | ALL
12 | 1.5 | ALL
17 | 1.5 | ALL
18 | 1.5 | 17
33 | 1.5 | 17
44 | 1.5 | 18
68 | 1.5 | 19
101 | 1.5 | 20
183 | 1.5 | 21
949 | 1.5 | 22
950 | 1.5 | 23
6 | 4 | ALL
12 | 4 | 6
17 | 4 | 7
18 | 4 | 7
33 | 4 | 8
44 | 4 | 8
68 | 4 | 8
101 | 4 | 8
183 | 4 | 8
949 | 4 | 8
950 | 4 | 8
6 | 6.5 | ALL
12 | 6.5 | 5
17 | 6.5 | 6
18 | 6.5 | 6
33 | 6.5 | 6
44 | 6.5 | 6
68 | 6.5 | 6
101 | 6.5 | 6
183 | 6.5 | 6
949 | 6.5 | 7
950 | 6.5 | 7
Spreadsheet: chris_germany__1814__EOLfieldnames
Sheet: EOL

 | EOL Field Names
 |  |  |  |  |  |  |  |  |  |  | Gas Daily Refernce Prices
 | Pipeline |  | Points / Zone |  | Rate Schedule |  | [NAME] |  | Delivery Point |  | Receipt Location |  | Delivery Location
 | Columbia Gas Transmission Corporation | CGAS
 |  |  | Point to Zone |  | FTS |  | Leach |  | Market Area 28 |  | Columbia, [NAME]
 |  |  | Point to Zone |  | FTS |  | Leach |  | Market Atea 34 |  | Columbia, [NAME]
 | Columbia Gulf Transmission Corporation | CGLF | Point to Point |  | FTS-1 |  | Rayne |  | Leach |  |  |  | Columbia, [NAME]
 |  |  | Point to Point |  | FTS-1 |  | Leach |  | Rayne |  |  |  | Columbia, [NAME]
 |  |  | Zone to Zone |  | FTS-1 |  | Mainline |  | Mainline |  |  |  | Columbia, [NAME]
 | Dominion Transmission, Inc. | CNG | Zone to Zone |  | FT or FTNN |  | South |  | South |  | Dominion South Point
 |  |  | Zone to Zone |  | FT or FTNN |  | South |  | North |  | Dominion South Point
 |  |  | Zone to Zone |  | FT or FTNN |  | North |  | North
 |  |  | Zone to Zone |  | FT or FTNN |  | North |  | South
 |  |  | Zone to Zone |  | FT or FTNN |  | South |  | South PL-1 |  | Dominion South Point
 |  |  | Zone to Zone |  | FT or FTNN |  | North |  | South PL-1 |  | Dominion South Point
 | Note:  this will be the first time we have recognized South PL-1 in any of our trading systems
 | Texas Eastern Transmission Corporation | TETC | Zone to Zone |  | CDS or FT-1 |  | Ela |  | M3
 |  |  | Zone to Zone |  | CDS or FT-1 |  | [NAME] |  | M3
 |  |  | Zone to Zone |  | CDS or FT-1 |  | Ela |  | M2
 |  |  | Zone to Zone |  | CDS or FT-1 |  | [NAME] |  | M2
 | Transcontinental Gas Pipe Line Corporation | TRCO | Zone to Zone |  | FT-R |  | Zone 3 |  | Zone 6 Non NY
 |  |  | Zone to Zone |  | FT-R |  | Zone 2 |  | Zone 6 Non NY
 |  |  | Zone to Zone |  | FT-R |  | Zone 1 |  | Zone 6 Non NY
 |  |  | Zone to Zone |  | FT-R |  | Zone 3 |  | Zone 6 NY
 |  |  | Zone to Zone |  | FT-R |  | Zone 2 |  | Zone 6 NY
 |  |  | Zone to Zone |  | FT-R |  | Zone 1 |  | Zone 6 NY
Spreadsheet: 271017d1381784830-index-match-v-hlookup-chuge-challenge-up-for-it-need-help-seicasetemp-1-
Sheet: SFI PT

Row Labels | Count of Case Number
[NAME] | 6
Duplicate | 1
Open | 1
RF8 | 1
RFC | 3
[NAME] | 36
R4D | 2
RF8 | 1
RFC | 17
RFD | 14
R>8D | 2
[NAME] | 31
Duplicate | 5
Open | 4
R4D | 5
RF8 | 1
RFD | 15
R>8D | 1
Grand Total | 73
Spreadsheet: 14707a67-b34f-48b2-bfc8-0cf9a72612e8
Sheet: Agri

Exit Survey - Agriculture Education
Form Purpose - This survey is used to determine candidates' opinions of Burton College of Education programs as they relate to teacher preparedness.
 | n=2 |  | n=2 |  | n=2 |  | n=2
 | Fall 2011 |  | Sp 2013 |  | Fall 2013 |  | Sp 2014
[NAME] | Program | College | Program | College | Program | College | Program | College
PLANNING
Plan objectives and select supporting activities. | 5 | 4.8 | 5 | 4.8 | 5 | 4.7 | 5 | 4.5
Plan for individual differences, including cultural diversity and children with exceptionalities. | 5 | 4.8 | 5 | 4.7 | 5 | 4.6 | 5 | 4.5
Plan for short-term and long-term evaluation of student teaching (daily, weekly, yearly). | 5 | 4.7 | 5 | 4.5 | 5 | 4.5 | 5 | 4.6
Understand developmental characteristics of students a guide for planning. | 5 | 4.9 | 5 | 4.7 | 5 | 4.7 | 5 | 4.5
MANAGEMENT
Organize and maintain an effective classroom environment (space, materials, equipment, learning climate). | 5 | 4.8 | 5 | 4.8 | 5 | 4.6 | 5 | 4.5
Management of student behavior for effective learning. | 5 | 4.8 | 5 | 4.7 | 5 | 4.8 | 5 | 4.5
INSTRUCTION
Understand and convey knowledge of subject matter. | 5 | 4.9 | 5 | 4.8 | 5 | 4.7 | 5 | 4.6
Employ a variety of teaching strategies. | 5 | 4.8 | 5 | 4.9 | 5 | 4.5 | 5 | 4.6
Provide opportunities for student involvement in learning. | 5 | 4.8 | 5 | 4.7 | 5 | 4.6 | 5 | 4.5
Stimulate high-order thinking. | 5 | 4.8 | 5 | 4.5 | 5 | 4.8 | 5 | 4.5
Use materials, resources, and activities that are developmentally appropriate. | 5 | 4.9 | 5 | 4.8 | 5 | 4.5 | 5 | 4.4
Use technology to enhance learning. | 5 | 4.9 | 5 | 4.8 | 5 | 4.8 | 5 | 4.7
Provide effective on-going assessment, including performance-based assessment. | 5 | 4.8 | 5 | 4.9 | 5 | 4.6 | 5 | 4.5
TEACHER EDUCATION TRAINING
Rate the extent to which field experiences contributed to your teacher education training. | 5 | 4.6 | 5 | 4.6 | 5 | 4.7 | 5 | 4.2
Rate the extent to which student teaching contributed to your teacher education training. | 5 | 4.8 | 5 | 4.9 | 5 | 4.5 | 5 | 4.4
ADVISING
Rate your degree of satisfaction with the academic advising you received in the Burton College of Education. | 5 | 4.4 | 5 | 4.4 | 5 | 4.4 | 5 | 4.3
CURRICULUM MATERIALS CENTER
What was your overall impression regarding the usefulness of the Curriculum Materials Center? | 5 | 4.4 | 5 | 4.3 | 3 | 4.2 | 4.5 | 4.2
How would you rate the assistance you received while at the Curriculum Material Center? | 5 | 4.2 | 5 | 4.2 | 3 | 4.1 | 4.5 | 4
Spreadsheet: 739012d1625438430-how-to-calculate-sla-weekends-included-sample-workbook-v5-1-
Sheet: Sheet1

Classification | Date & Time Received | SLA Due
CASE 1 | 2021-07-01 11:56:13 |  |  |  |  |  |  |  |  |  |  |  |  | Holiday | Description |  | Types of Enquiries | SLA Hours |  | Working Hours Start | Working Hours End
CASE 1 | 2021-07-02 11:56:13 |  |  |  |  |  |  |  |  |  |  |  |  | 2021-06-10 00:00:00 | Queen's Birthday |  | CASE 1 | 16:00:00 |  | 09:00:00 | 17:00:00
CASE 3 | 2021-07-04 16:56:13 |  |  |  |  |  | Working Hours Start | Working Hours End |  | [NAME] | SLA Hours |  |  | 2021-10-04 00:00:00 | Labour Day |  | CASE 2 | 2:00:00 |  | 08:00:00 | 20:00:00
CASE 7 | 2021-06-09 16:00:00 |  |  |  |  | Mon-Fri | 08:00:00 | 20:00:00 |  | CASE 1 | 16:00:00 |  |  | 2021-12-27 00:00:00 | Christmas Day |  | CASE 3 | 16:00:00
CASE 4 | 2021-10-03 07:54:00 |  |  |  |  | Sat-Sun | 09:00:00 | 17:00:00 |  | CASE 2 | 2:00:00 |  |  | 2021-12-28 00:00:00 | Boxing Day |  | CASE 4 | 2:00:00
 |  |  |  |  |  |  |  |  |  | CASE 3 | 16:00:00 |  |  |  |  |  | CASE 5 | 2:00:00
 |  |  |  |  |  |  |  |  |  | CASE 4 | 2:00:00 |  |  |  |  |  | CASE 6 | 2:00:00
 |  |  |  |  |  |  |  |  |  | CASE 5 | 2:00:00 |  |  |  |  |  | CASE 7 | 2:00:00
 |  |  |  |  |  |  |  |  |  | CASE 6 | 2:00:00
 |  |  |  |  |  |  |  |  |  | CASE 7 | 2:00:00
 |  |  |  |  |  |  | Holiday | Description
 |  |  |  |  |  |  | 2021-06-10 00:00:00 | Queen's Birthday
 |  |  |  |  |  |  | 2021-10-04 00:00:00 | Labour Day
 |  |  |  |  |  |  | 2021-12-27 00:00:00 | Christmas Day
 |  |  |  |  |  |  | 2021-12-28 00:00:00 | Boxing Day
Spreadsheet: louise_kitchen__24046__East Power Consolidation
Sheet: Southeast Origination

 |  | 2001-09-01 00:00:00 |  | 2001-09-01 00:00:00 |  | %
 |  | YTD Actual |  | Annualized |  | of Total
ENACOMP | Compensation
 | Special Pays | 7500
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions
ENARENT | Rent
ENATECH | Technology
ENATRANS | Transportation
ENAOTHEX | Other Expenses
ENATAXES | Taxes Other than Income
ENATOTDR | Total Direct Expenses
 | Headcount |  |  | 6
 | Analyst & Associate Headcount |  |  | 5
 | Total Headcount
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses
ENADEPR | Depreciation & Amortization
 | Edgecomb W/O | 284961
Spreadsheet: 795251d1662575593-color-cells-of-one-sheet-based-on-contents-from-multiple-other-sheets-mconry-class-schedule
Sheet: Teacher 1

Teacher 1 | Monday | Tuesday | Wednesday | Thursday | Friday
08:00:00 | Busy | Free | Busy | Free | Busy
08:30:00 | Busy | Free | Busy | Free | Busy
09:00:00 | Free | Free | Free | Free | Free
09:30:00 | Free | Free | Free | Free | Free
10:00:00 | Busy | Free | Busy | Free | Busy
10:30:00 | Busy | Free | Busy | Free | Busy
11:00:00 | Busy | Free | Busy | Free | Busy
11:30:00 | Free | Free | Free | Free | Free
12:00:00 | Free | Busy | Free | Busy | Free
12:30:00 | Free | Free | Free | Free | Free
13:00:00 | Free | Free | Free | Free | Free
13:30:00 | Free | Free | Free | Free | Free
14:00:00 | Free | Free | Free | Free | Free
14:30:00 | Busy | Free | Busy | Free | Busy
15:00:00 | Busy | Free | Busy | Free | Busy
15:30:00 | Free | Free | Free | Free | Free
16:00:00 | Free | Free | Free | Free | Free
16:30:00 | Free | Free | Free | Free | Free
17:00:00 | Free | Free | Free | Free | Free
Spreadsheet: 707053d1607014804-index-match-vlookup-type-formula-off-of-drop-down-menu-named-range-retail-test-spreadsheet
Sheet: Handout

 | Twins |  | Somewhere use a drop-down to choose which spreadsheet tab to pull data from
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | {Other Logo here}
 | Pad | ASW# | Brand | Vtg | Product | Pk | Size | UPC | Type |  | Auth Note | Vdr Rpt $ | ED Cost | [NAME] | ED Margin | TPR Cost | [NAME] | TPR Margin | [NAME] | Plan Dates | Temp / Sale Cost | Temp / Sale Retail | Temp / Sale Margin | Temp / Sale Date | [NAME] | [NAME] | Var Date | Online Price | Ck Date | Notes | Plan | Cost Adj | Retail | Margin
 |  | 60629396
 |  | So I know I can input a VLOOKUP and then change the referenced Worksheet tab, but can I just do a drop down choosing the worksheet that would allow for the VLOOKUPs to update with information from that sheet?
Spreadsheet: 35019d1232486326-excel-2007-several-conditional-formatting-only-working-on-some-training-dates
Sheet: Tracking

NAME | Defense Awareness CBT (every 20 months) | Defense Class (w/in 60 Days of CBT) | SABC CBT (every [NAME]) | [NAME] Class (w/in 90 days of CBT)
[NAME] | 2009-01-14 00:00:00 | 2009-01-15 00:00:00 | 2007-06-15 00:00:00 | 2006-05-22 00:00:00
Joe1 |  | 2006-12-22 00:00:00 | 2006-05-30 00:00:00 | 2006-12-22 00:00:00
joe2 | 2009-01-14 00:00:00 | 2009-01-16 00:00:00 | 2007-11-28 00:00:00 | 2007-11-28 00:00:00
joe3 | 2009-01-14 00:00:00 | 2009-01-15 00:00:00 | 2007-05-29 00:00:00 | 2007-06-01 00:00:00
joe4 | 2009-01-14 00:00:00 | 2009-01-14 00:00:00 | 2007-05-01 00:00:00 | 2007-05-04 00:00:00
jo5 |  |  | 2008-10-22 00:00:00 | 2009-01-15 00:00:00
Spreadsheet: 789624d1659250567-vlookup-and-conditional-formatting-for-multiple-values-staff-attendance-holiday-planner-staff-leave-record-forum-help-
Sheet: Staff Database

 |  |  |  | Roster A / B
 |  |  |  | A : Mon to Sat
 |  | Staff ID | Shift Type | B : Sun to Fri | Supervisor
1 | [NAME] | 27102239 | D | A | [NAME]
2 | [NAME] | 27102275 | D | A | [NAME]
3 | Adrian | 27102639 | N | A | Ricky
4 | [NAME] | 27102649 | N | B | [NAME]
5 | [NAME] | 27104104 | D | A | Ricky
6 | Betty | 27106465 | D | A | [NAME]
7 | [NAME] | 27101775 | N | B | Ricky
8 | Mandy | 27100893 | D | B | [NAME]
9 | [NAME] | 27100565 | D | A | Ricky
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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
Spreadsheet: 163814d1340470356-pivot-table-formatting-dont-want-calculation-problemformatting
Sheet: problem automatic formatting

2012-01-01 00:00:00 | [NAME] | 1111
2012-01-01 00:00:00 | [NAME] | 2222 | How can I turn  this
2012-01-01 00:00:00 | [NAME] | 555
2012-01-01 00:00:00 | [NAME] | 999
2012-01-01 00:00:00 | [NAME] | 3333
2012-01-01 00:00:00 | [NAME] | 555 |  |  | into this, with a pivot table or any other means 'automatically"
2012-01-01 00:00:00 | [NAME] | 2222
2012-01-01 00:00:00 | [NAME] | 4444 |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME]
2012-01-02 00:00:00 | [NAME] | 666 |  | 2012-01-01 00:00:00 | 1111 |  |  |  | 2222 | 3333 | 2222 | 4444 | 555 | 555 |  |  | 999
2012-01-02 00:00:00 | [NAME] | 555 |  | 2012-01-02 00:00:00 |  |  |  |  |  |  |  |  | 555 | 5588 |  |  | 666
2012-01-02 00:00:00 | [NAME] | 5588 |  | 2012-01-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 6969
2012-01-03 00:00:00 | [NAME] | 6969
 |  |  |  | FYI, the numbers are job numbers, no calculations can be made on these
Spreadsheet: 272845d1382530238-referencing-values-above-the-last-cell-in-a-row-dates
Sheet: Sheet1

Accumulative Absences |  |  |  |  |  |  |  |  |  |  |  |  |  | Not required to attend          (all sessions on sheet) |  | Total Individual absences up to last date entered
Dates of Each Session
[NAME] | n | n |  |  | n | n |  |  | n | n |  |  |  |  |  | ? | < should be 4 as student only has 4 sessions not to attend up to last date on sheet
[NAME] | n | n |  |  |  |  |  |  | n | n |  |  |  |  |  | ? | < should be 2 as student has 2 sessions not to attend up to last date on sheet
[NAME] |  |  |  |  |  |  |  |  | n | n |  |  |  |  |  | ? | < should be 0 as student has 0 sessions not to attend up to last date on sheet
[NAME] | n | n |  |  |  |  |  |  | n | n |  |  |  |  |  | ? |  |  |  |  | <Todays Date
[NAME] | n | n |  |  | n | n |  |  | n | n |  |  |  |  |  | ? |  |  |  | 2013-10-18 00:00:00 | Dates of all sessions entered here. These then appear in each "Dates of Each Session" cells if they are =< today's date.
George | n | n |  |  | n | n |  |  | n | n |  |  |  |  |  | ? |  |  |  | 2013-10-19 00:00:00
[NAME] |  |  | n | n |  |  | n | n |  |  | n | n |  |  |  | ? |  |  |  | 2013-10-20 00:00:00
Harold |  |  | n | n |  |  | n | n |  |  | n | n |  |  |  | ? |  |  |  | 2013-10-21 00:00:00
Trevor |  |  | n | n |  |  | n | n |  |  | n | n |  |  |  | ? |  |  |  | 2013-10-22 00:00:00
[NAME] |  |  | n | n |  |  | n | n |  |  | n | n |  |  |  | ? |  |  |  | 2013-10-23 00:00:00
Mark |  |  | n | n |  |  | n | n |  |  | n | n |  |  |  | ? |  |  |  | 2013-10-24 00:00:00
[NAME] |  |  | n | n |  |  | n | n |  |  | n | n |  |  |  | ? |  |  |  | 2013-10-25 00:00:00
[NAME] |  |  | n | n |  |  | n | n |  |  | n | n |  |  |  | ? |  |  |  | 2013-10-26 00:00:00
 |  |  |  |  |  |  |  |  |  | Sum of all the "n" on the sheet > |  |  |  |  |  |  | <Total of all individual absences entered up to last date |  |  | 2013-10-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-28 00:00:00
Total Absences up to last date entered = |  |  |  | ? | < result of formula in this cell should be 13 by correctly referencing (H2) as that is the total of the accumulative absences up to the last date entered on the form (H3) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-30 00:00:00
Spreadsheet: 133096a0-6112-4613-a3e1-b46e9a9995ce
Sheet: SD_RTUNITASM

Real Time Unit Entitlement Report
SD_RTUNITASM_<customer id>_<settlement date>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
 | Unit |  |  |  |  |  |  | Customer Share
Trading Interval | Asset ID | Asset Name | Asset Sub-Type | Location Id | Location Name | Location Type | Generator [NAME] | Ownership Share | Customer Share of [NAME] | Settlement Only Flag | Subaccount ID | Subaccount Name
Hour End | Number | String | String | Number | String | String | MWh | % | MWh | String | String | String
Spreadsheet: 703458d1605009427-countif-range-of-cells-contains-text-from-column-a-countif-range-2-
Sheet: Hoja1

 | One way | Another way |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Javier |  |  |  |  | Alboraya 0 - 0 Alzira | [NAME]
Mario |  |  |  |  | 13 Javier (P) | 1 Chover (P)
Dídac |  |  |  |  | 2 Mario | 2 Mario
PEPE |  |  |  |  | 3 Dídac | 3 Dídac  75'
[NAME] |  |  |  |  | 4 PEPE | 4 PEPE | [NAME] fff
6 Victor |  |  |  |  | 5 Savall (C) | 5 Savall (C)
 |  |  |  |  | 6 Victor | 6 Victor | [NAME] | [NAME] | [NAME]
 |  |  |  |  | 7 Sergio  85' | 7 Sergio
 |  |  |  |  | 8 Israel  71' | 8 Israel  56' |  | 88 Mario
 |  |  |  |  | 9 [NAME]  71' | 9 [NAME]  67'
 |  |  |  |  | 10 Iker  75' | 10 Iker  75'
 |  |  |  |  | 11 Victor | 11 Victor
 |  |  |  |  | Suplentes | Suplentes
 |  |  |  |  |  | [NAME] "A"
 |  |  |  |  | 1 Chover | 12 Diego
 |  |  |  |  | 12 Diego | 13 Javier
 |  |  |  |  | 14 [NAME]75' | 14 Francesc
 |  |  |  |  | 15 Francesc | 15 Adrian  56'
 |  |  |  |  | 16 Adrian  71' | 16 Mario  67'
 |  |  |  |  | 17 Mario  85' | 17 [NAME]
 |  |  |  |  | 18 Miguel  71' | 18 [NAME]75'
 |  |  |  |  |  | 19 Sergio  75'
 |  |  |  |  |  | 20 Lucas
Spreadsheet: 456020d1460610026-help-compare-2-columns-different-sheets-if-value-match-copy-the-value-of-other-cell-test
Sheet: Sheet2

Ciocolata
4011100240216 | [NAME] 57GR | 2
8691707135052 | [NAME] CU LAPTE, CAREMEL SI NUGA 125 GR.
8691707077079 | CIOCOLATA CRAZY CU LAPTE SI OREZ EXPANDATA 30 GR.
8691707038933 | [NAME] ALUNE WINERGY 40 GR.
8691707038117 | [NAME] NUGA MAXBAR 40 GR.
8690997026521 | CIOCOLATA FIGOLA CREMA DE CASPSUNI 80 GR,
80177609 | [NAME] T4 50 GR.
40084701 | [NAME]
5900951138982 | [NAME] 47GR
5900951134937 | [NAME]
5900951025808 | [NAME] 21,5GR
5900951251863 | [NAME]  57.5GR
5000159461122 | [NAME] 50GR
5000159484923 | [NAME] CHOC 50 GR.
5000159472906 | [NAME] 75 GR
6422358541754 | CREMA DE ALUNE NUTELLA 400 GR.
5201911001000 | CREMA DE CIOCOLATA FINETTI 1 KG.
8000500023976 | FERRERO RAFFAELLO T15 150 GR.
 | KINDER BUENO, KINDER BUENO WHITE 43 GR.
40084176 | KINDER COUNTRY 23,5GR
8000500023624 | [NAME] HIPPO T5
40084077 | KINDER MAXI 21GR T1
54088191 | KINDER OUA SURPRIZE ROZ 20GR
40084107 | KINDER SUPRIZE
80310891 | OU DE CIOCOLATA CU SURPRIZE KINDER JOY 20 GR.
8699462604851 | OU DE CIOCOLATA CU SURPRIZE LITTLE FARM 25 GR.
8699462604004 | OU DE CIOCOLATA CU SURPRIZE TOY TOY 25 GR.
8600939354315 | PRALINE CIOCOLATA STARK CHERRY 204 GR.
4008400102528 | PRALINE DE CIOCOLATA CU CIRESE SI LICHIOR MON CHERI FERRERO 157.5 GR.