tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 56210d1256302921-row-data-lookup-sort-query-book1-1-
Sheet: Sheet2

 | SHEET2 - what I'm after it looking like
 | [NAME]
 |  | Totals | 5 | 22 |  |  | 03:27:00
 | Name | CustID | Lines | Cases | Time Out | Time In | Time
 | [NAME] | ABC | 5 | 22 | 12:12:00 | 13:19:00 | 01:07:00
 | [NAME] | DEF | 7 | 59 | 12:25:00 | 14:45:00 | 02:20:00
Spreadsheet: 75499d1276074713-how-to-retrieve-information-from-multiple-sheets-sheet-relatives
Sheet: day 5

 | Product | Data 2 | Data 3 | Data 4 | Data 5 | Data 6 | Data 7
 | Product 1 |  |  |  | 15
 | Product 2 |  |  |  | 45
 | Product 3 |  |  |  | 98
 | Product 4 |  |  |  | 68
 | Product 5 |  |  |  | 35
 | Product 6 |  |  |  | 15
 | Product 7 |  |  |  | 48
 | Product 8 |  |  |  | 755
 | Product 9 |  |  |  | 65
 | Product 10 |  |  |  | 92
 | Product 11 |  |  |  | 45
 | Product 12 |  |  |  | 82
 | Product 13 |  |  |  | 35
 | Product 14 |  |  |  | 14
 | Product 15 |  |  |  | 45
Spreadsheet: 59660d1260244105-league-spreadsheet-709588-league-spreadsheet-v2
Sheet: Results

Week | 4 | results |  |  |  |  |  |  | data entry |  | enter week number in B1
number of pairings |  | 3
team # | team name | rank | team members | previous average | Score | Spot | adj. Score | X's | points won | VS | team # | team name | rank | team members | previous average | Score | Spot | adjusted Score | x's | points won
 | 1
3 | yellow | 1 | erin | 273 | 0 | 8.266666666666652 | 8.266666666666652 | 0 | 1 |  | 6 | orange | 1 | oliver | 283.3333333333333 | 0 | 0 | 0 | 0 | 0
 |  | 2 | [NAME] | 251.5 | 0 | 2 | 2 | 0 | 1 |  |  |  | 2 | bob | 254 | 0 | 0 | 0 | 0 | 0
 |  | 3 | elwood | 246 | 0 | 0 | 0 | 0 | 0 |  |  |  | 3 | [NAME] | 214 | 0 | 25.6 | 25.6 | 0 | 1
 | 2
4 | green | 1 | gary | 277.5 | 0 | 18 | 18 | 0 | 1 |  | 2 | red_team | 1 | ray | 300 | 0 | 0 | 0 | 0 | 0
 |  | 2 | grendel | 254.3333333333333 | 0 | 17.33333333333333 | 17.33333333333333 | 0 | 1 |  |  |  | 2 | [NAME] | 276 | 0 | 0 | 0 | 0 | 0
 |  | 3 | greg | 240 | 0 | 10 | 10 | 0 | 1 |  |  |  | 3 | ron | 252.5 | 0 | 0 | 0 | 0 | 0
 | 3
5 | purple | 1 | [NAME] | 289 | 0 | 0 | 0 | 0 | 0 |  | 3 | yellow | 1 | erin | 273 | 0 | 12.8 | 12.8 | 0 | 1
 |  | 2 | pete | 271 | 0 | 0 | 0 | 0 | 0 |  |  |  | 2 | [NAME] | 251.5 | 0 | 15.6 | 15.6 | 0 | 1
 |  | 3 | [NAME] | 260 | 0 | 0 | 0 | 0 | 0 |  |  |  | 3 | elwood | 246 | 0 | 11.2 | 11.2 | 0 | 1
 | This sheet compares the results entered on the Scores Sheet for the week selected above and calculates who gets points
 | The points then need to be entered manually for each player in the Scores sheet.
 | No data entry here! All scores and points are entered on the Scores sheet!!
Spreadsheet: 17deb806-f3ad-499f-99ef-8146d3fba92c
Sheet: Sheet1

Inventory Managemnet
Name
Date
 | PRODUCT PER CASE | COST | TOTAL CASES | RETURN CASES | TOTAL CONTAINERS | RETURN CONTAINERS | TOTAL SOLD | MONEY OWED
MILITARY | 0 | 50
MILITARY | 0 | 30
CHOCOLATE LOVERS (Tin) | 1 | 55
[NAME] AND SAVORY | 1 | 40
CHEESE LOVERS | 1 | 30
WHITE CHOCOLATEY PRETZELS | 8 | 25
CHOCOLATE DRIZZLE | 8 | 20
CARAMEL CORN WITH NUTS | 8 | 20
UNBELIEVABLE BUTTER | 6 | 20
BUTTER LIGHT | 6 | 20
BUFFALO CHEDDAR | 8 | 15
BACON RANCH | 8 | 15
PREPOPPED KETTLE CORN | 8 | 15
CARMEL CORN | 12 | 10
POPPING CORN | 12 | 10
 |  |  |  |  |  | TOTAL OWED
Kernel Signature |  |  |  |  |  | Funds Collected Previously |  | 0
 |  |  |  |  |  | PAID BY CHECK |  | 0
Parent Signature |  |  |  |  |  | PAID CASH |  | 0
 |  |  |  |  |  | TOTAL DUE
Spreadsheet: tracy_geaccone__40492__OM Schedule - IT 1
Sheet: Not Normalized for O&E

DIRECT  O & M COSTS
2002 - 2004 PLAN
INFORMATION TECHNOLOGY
( $ In Millions)
 |  |  |  | 2000 Actuals |  |  |  |  |  |  |  |  |  | Restated 2001 Plan (3) |  |  |  |  |  |  |  |  |  | 2001 2nd Current Estimate (2,3) |  |  |  |  |  |  |  |  |  | 2002 Plan
 |  |  |  |  |  | Project |  |  |  |  |  |  |  |  |  | Project |  |  |  |  |  |  |  |  |  | Project |  |  |  |  |  |  |  |  |  | Project
 |  |  |  |  |  | Specific |  | Overhead |  |  |  |  |  |  |  | Specific |  | Overhead |  |  |  |  |  |  |  | Specific |  | Overhead |  |  |  |  |  |  |  | Specific |  | Overhead |  |  |  |  |  | Gross O&M
 |  |  |  | Gross |  | Capital |  | Capital |  | Allocations |  | Net |  | Gross |  | Capital |  | Capital |  | Allocations |  | Net |  | Gross |  | Capital |  | Capital |  | Allocations |  | Net |  | Gross |  | Capital |  | Capital |  | Allocations |  | Net |  | % O(U)
Department |  |  |  | O & M |  | O & M |  | O & M |  | In/(Out) |  | O & M |  | O & M |  | O & M |  | O & M |  | In/(Out) |  | O & M |  | O & M |  | O & M |  | O & M |  | In/(Out) |  | O & M |  | O & M |  | O & M |  | O & M |  | In/(Out) |  | O & M |  | 2000 Plan
NNG |  |  |  | 12.7 |  | 1.3 |  |  |  |  |  |  |  |  |  | 0.4 |  |  |  | -0.1 |  | 12.5 |  |  |  | 0.4 |  |  |  | -0.1
TW |  |  |  | 4 |  | 0.4 |  |  |  |  |  |  |  |  |  | 0.1 |  |  |  | -0.1 |  | 3.5 |  |  |  | 0.1 |  |  |  | -0.1 |  |  |  |  |  | 0.1
Citrus |  |  |  | 6.3 |  | 0.2 |  |  |  |  |  |  |  |  |  | 0.4 |  |  |  | -0.1 |  | 5.8 |  |  |  | 0.4 |  |  |  | -0.1 |  |  |  |  |  | 0.1
Northern Border Partners (1) |  |  |  | 0.3
EOTT (Co 1195) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.3 |  | 1.2 |  |  |  |  |  |  |  | 0.3 |  | 1.2 |  |  |  |  |  |  |  |  |  | 1.5
[NAME]
Enron Construction Services
EAMR
ETS
Other * |  |  |  | 5.9 |  | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.3 |  |  |  |  |  |  |  |  |  | 2.3 |  |  |  |  |  |  |  |  |  | 1.2
Total Direct
(1)  Not included - NBP submits their own schedule.  (These costs are NPNG.)
(2)  $.6 increase in expense over 2001 Plan due to Data Center move to new building.  ($1.3MM Capital Expenditures savings)
(3)  2001 "Other" includes HPL.
* Companies outside of ETS
Spreadsheet: 139916d1328544629-sort-with-combobox-sample-excel-inventory-using-indirect-data-validation
Sheet: FlangeYoke

PartID | Description | Cost | Series
SP 1-2-111 | Flange Yoke | 111.11 | 1010
SP 2-2-222 | Flange Yoke | 222.22 | 1020
SP 3-2-333 | Flange Yoke | 333.33 | 1030
SP 4-2-444 | Flange Yoke | 444.44 | 1040
Spreadsheet: 773161d1647659028-return-the-five-consecutive-numbers-from-a-range-that-total-the-most-when-summed-book1
Sheet: Sheet1

4
3
2
9
10
8
11
12
1
Spreadsheet: 454748d1459960442-count-how-many-employees-were-termed-in-less-than-90-days-per-month-template
Sheet: Test

Start Date | Term Date | Days worked
2015-11-08 00:00:00 | 2016-04-05 00:00:00 |  |  | March | April | May | June | July | Aug
2015-11-10 00:00:00 |  |  | Total Termed | 3 | 6
2015-11-11 00:00:00 | 2016-04-01 00:00:00 |  | Termed in 90 or less | 2 | 2
2015-11-12 00:00:00 | 2016-03-22 00:00:00
2015-11-13 00:00:00
2015-11-17 00:00:00 | 2016-03-21 00:00:00
2015-11-18 00:00:00 | 2016-04-19 00:00:00
2015-11-20 00:00:00
2015-12-02 00:00:00 | 2016-04-16 00:00:00
2015-12-04 00:00:00 | 2016-03-07 00:00:00
2015-12-07 00:00:00 | 2016-04-01 00:00:00
2015-12-17 00:00:00 | 2016-04-03 00:00:00
2016-01-04 00:00:00
2016-01-13 00:00:00
2016-01-22 00:00:00
2016-02-01 00:00:00
2016-02-04 00:00:00
Spreadsheet: 714996d1611502575-formula-for-closing-balance-copie-de-forum-excel-24-jan-2021
Sheet: Projection

 | Last month | This month | [NAME] | février-2020 | mars-2020 | avril-2020 | mai-2020 | juin-2020 | juillet-2020 | août-2020 | septembre-2020 | octobre-2020 | novembre-2020 | décembre-2020 | janvier-2021 | février-2021 | mars-2021 | avril-2021 | mai-2021 | juin-2021 | juillet-2021 | août-2021 | septembre-2021 | octobre-2021 | novembre-2021 | décembre-2021 | janvier-2022 | [NAME] | mars-2022 | avril-2022 | mai-2022 | juin-2022 | juillet-2022 | août-2022 | septembre-2022 | octobre-2022 | novembre-2022 | décembre-2022
First date |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-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
Last date |  |  | 2020-01-31 00:00:00 | 2020-02-29 00:00:00 | 2020-03-31 00:00:00 | 2020-04-30 00:00:00 | 2020-05-31 00:00:00 | 2020-06-30 00:00:00 | 2020-07-31 00:00:00 | 2020-08-31 00:00:00 | 2020-09-30 00:00:00 | 2020-10-31 00:00:00 | 2020-11-30 00:00:00 | 2020-12-31 00:00:00 | 2021-01-31 00:00:00 | 2021-02-28 00:00:00 | 2021-03-31 00:00:00 | 2021-04-30 00:00:00 | 2021-05-31 00:00:00 | 2021-06-30 00:00:00 | 2021-07-31 00:00:00 | 2021-08-31 00:00:00 | 2021-09-30 00:00:00 | 2021-10-31 00:00:00 | 2021-11-30 00:00:00 | 2021-12-31 00:00:00 | 2022-01-31 00:00:00 | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00
Épargne et inv.  (défilé [NAME]) | Last month | This month | 2020-01-01 00:00:00
AR | [NAME]? | [NAME]? |  |  |  |  |  |  |  |  |  |  |  | 100
FT |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
PL
UR
 | Last month is now | This month is now
 | December 2020 | January 2021
 | but it will update | but it will update
 | as months go by | as months go by
Spreadsheet: 882561d1730956298-conditional-formatting-formula-based-on-two-criteria-time-or-space-sample-j-
Sheet: Input

 |  |  | Input
 |  |  | # | Time | Location | RSN # | Combined
 |  |  |  | 09:00:00 | 11 | 2568
 |  |  |  | 11:08:00 | 14 | 3254
 |  |  |  | 12:05:00 | 16 | 4225
 |  |  |  | 12:30:00 | 12 | 2587
 |  |  |  | 15:10:00 | 15 | 4524
 |  |  |  | 18:30:00 | 13 | 3225
 |  |  |  | 19:22:00 | 16 | 7452
 |  |  |  | 22:05:00 | 11 | 8547
 |  |  |  | 00:15:00 | 13 | 9655
 |  |  |  | 03:30:00 | 15 | 4565
 |  |  |  | 05:15:00 | 17 | 2554
 |  |  |  | 08:10:00 | 12 | 6541
Spreadsheet: 99166d1297890974-trigger-to-activate-appropriate-list-forum-sample-19d
Sheet: NUM SORT

 |  |  |  | 0
TOTAL | NUM | ACTIVITY
0 | 000 | 4
1 | 010 | 4
2 | 002 | 7
2 | 011 | 4
3 | 300 | 2
3 | 201 | 4
4 | 400 | 5
4 | 103 | 10
4 | 202 | 7
5 | 005 | 0
5 | 041 | 4
5 | 302 | 4
6 | 600 | 7
6 | 051 | 1
6 | 420 | 5
6 | 033 | 6
7 | 070 | 4
7 | 061 | 8
7 | 052 | 9
7 | 304 | 7
8 | 080 | 5
8 | 017 | 9
8 | 260 | 12
8 | 053 | 7
8 | 440 | 4
9 | 090 | 3
9 | 018 | 4
9 | 207 | 10
9 | 603 | 10
9 | 054 | 11
10 | 190 | 8
10 | 820 | 12
10 | 703 | 7
10 | 640 | 9
10 | 055 | 4
11 | 092 | 7
11 | 083 | 11
11 | 704 | 5
11 | 605 | 10
12 | 039 | 7
12 | 480 | 12
12 | 057 | 8
12 | 066 | 0
13 | 409 | 6
13 | 580 | 8
13 | 706 | 7
14 | 950 | 9
14 | 086 | 9
14 | 077 | 5
15 | 609 | 7
15 | 708 | 4
16 | 709 | 10
16 | 808 | 7
17 | 809 | 12
18 | 990 | 6
Spreadsheet: 145825d1331755310-fail-re-formatting-my-2d-table-for-use-with-a-pivot-table-crosstabtotablevbahelpsample
Sheet: Sheet1

 | All my calculations generated into this style table |  |  |  |  |  |  |  |  | How do I convert into this format for Pivot table use?!
 | Quarter | Category | Resource Name | Resource Type | Product A | Product B | Product C | Product D |  | Quarter | Category | Product | Resource Name | Resource Type | Cost
 | 1 | [NAME] | Design | Freelance | 10 | 20 | 30 | 0 |  | 1 | [NAME] | Product A | Design | Freelance | 10
 | 1 | [NAME] | Design | Perm | 20 | 30 | 40 | 2 |  | 1 | [NAME] | Product A | Design | Perm | 10
 | 2 | [NAME] | Design | Freelance | 3 | 34 | 4 | 3 |  | 1 | [NAME] | Product B | Design | Freelance | 20
 | 2 | [NAME] | Design | Perm | 2 | 2 | 2 | 3 |  | 1 | [NAME] | Product B | Design | Perm | 30
 | 3 | [NAME] | Design | Freelance | 1 | 3 | 44 | 3 |  | 1 | [NAME] | Product C | Design | Freelance | 30
 | 3 | [NAME] | Design | Perm | 2 | 3 | 3 | 4 |  | 1 | [NAME] | Product C | Design | Perm | 40
 | 4 | [NAME] | Design | Freelance | 4 | 2 | 3 | 3 |  | 1 | [NAME] | Product D | Design | Freelance | 0
 | 4 | [NAME] | Design | Perm | 1 | 5 | 2 | 66 |  | 1 | [NAME] | Product D | Design | Perm | 2
 | 1 | Metal | Polisher | Freelance | 55 | 3 | 2 | 2 |  | 2 | [NAME] | Product A | Design | Freelance | 3
 | 1 | Metal | Polisher | Perm | 2 | 3 | 4 | 5 |  | 2 | [NAME] | Product A | Design | Perm | 2
 | 2 | Metal | Polisher | Freelance | 5 | 3 | 2 | 1 |  | 2 | [NAME] | Product B | Design | Freelance | 34
 | 2 | Metal | Polisher | Perm | 3 | 4 |  | 4 |  | 2 | [NAME] | Product B | Design | Perm | 2
 | 3 | Metal | Polisher | Freelance | 4 | 6 | 66 | 6 |  | 2 | [NAME] | Product C | Design | Freelance | 4
 | 3 | Metal | Polisher | Perm | 45 | 6 | 6 | 6 |  | 2 | [NAME] | Product C | Design | Perm | 2
 | 4 | Metal | Polisher | Freelance | 44 | 663 | 33 | 6 |  | 2 | [NAME] | Product D | Design | Freelance | 3
 | 4 | Metal | Polisher | Perm | 3 | 4 | 6 | 6 |  | 2 | [NAME] | Product D | Design | Perm | 3
 |  |  |  |  |  |  |  |  |  | …… | …… | …… | …… | …… | ……
 |  |  |  |  |  |  |  |  |  | …… | …… | …… | …… | …… | ……
 |  |  |  |  |  |  |  |  |  | …… | …… | …… | …… | …… | ……
 |  |  |  |  |  |  |  |  |  | …… | …… | …… | …… | …… | ……
 |  |  |  |  |  |  |  |  |  | …… | …… | …… | …… | …… | ……
 |  |  |  |  |  |  |  |  |  | …… | …… | …… | …… | …… | ……
 |  |  |  |  |  |  |  |  |  | …… | …… | …… | …… | …… | ……
 |  |  |  |  |  |  |  |  |  | …… | …… | …… | …… | …… | ……
 |  |  |  |  |  |  |  |  |  | …… | …… | …… | …… | …… | ……
Spreadsheet: 695963d1600504235-display-text-using-a-number-format-when-a-cell-contains-a-minus-sign-examples-formatting-minus-to-not-available
Sheet: Sheet1

vlues | zero value format | text format | condtional format on minus as text
1 | 1 | 1 | 1
2 | 2 | 2 | 2
0 | 0 | 0 | 0
-4 | -4 | -4 | -4
abc | abc | abc | abc
- | - | - | -
 |  |  |  |  | -
Spreadsheet: 0d8d78fe-7758-4b0e-8f96-5101817824d2
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
HBC | Test | HBC | Hepatitis B Core Total Antibodies, Serum | HBc Total Ab, S | Chemiluminescence Immunoassay | Serum Gel Tube: SGT |  |  | 1 | mL | Collection Container/Tube: Serum gel Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: Spin down and remove serum from clot within 24 hours. Additional Information: Date of draw is required. | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | Negative Interpretation depends on clinical setting. See Viral Hepatitis Serologic Profiles in Special Instructions. | Monday through Sunday; Varies | 1 day | 2 days | 1 | 86704 |  |  |  |  | Rochester
HBC | [NAME] | SST | Serum SST |  |  |  | Frozen
HBC | Result | HBC | HBc Total Ab, S | HBc Total Ab, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22327-1
Spreadsheet: 824398d1680542029-comparing-two-lists-with-multiple-columns-lists
Sheet: Sheet1

 | 13 | Angers-Trottier | Anne-Marie |  | 783-0680
17 | 13 | Belvedere | Calista
17 | 13 | [NAME] | Alain
17 | 13 | Hudon | Sandra
17 | 13 | [NAME] | Sylvie
 | 13 | Charbonneau | [NAME] |  | 695-5731
17 | 13 | Lafleur | [NAME]
17 | 13 | Lafleur | [NAME] |  | 426-4176
 |  | Amal | Diabi
17 |  | Dupont | [NAME]
17 | 13 | Belvedere | [NAME] |  | 697-1957
17 | 13 | Laplante | [NAME]
Spreadsheet: 273592d1382771896-how-to-show-only-the-cell-that-met-formula-criteria-when-filtering-filter-file
Sheet: Sheet1

 | TERMINAL | TB | TM | STG | PR
 | TYPE OF REVENUE | PARKING | PARKING | PARKING | PARKING
 |  | TERMINAL PASS | TERMINAL PASS | TERMINAL PASS | TERMINAL PASS
 |  |  | INSURANCE | INSURANCE
 |  |  | WHARFAGE | WHARFAGE | WHARFAGE
 |  |  |  | RENT
 | TB
 | TYPE OF REVENUE | PARKING
 | TYPE OF REVENUE | TERMINAL PASS
 | TYPE OF REVENUE | 0
 | TYPE OF REVENUE | 0
 | TYPE OF REVENUE | 0
Spreadsheet: 59673747-45b4-4a20-bb5d-f258cd1f7507
Sheet: Sheet1

Table S1 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Primers used for validation of trans-spliced transcripts. In each PCR the forward primer was SL1 while the reverse primer was gene specific.
Positive control | SL1-Smp_024110.1_R
Negative control | SL1-Smp_045200.1_R
Test | SL1 | 5’-CCGTCACGGTTTTACTCTTG-3’
Test | Smp_102510_R | 5’-GCAAATGCTGTCCATAAAGC-3’
Test | Smp_024110_R, | 5’-CAGCCAAAGACACTCCCAAT-3’
Test | Smp_027360_R | 5’-TTTTACTATTAGGACTTTGTGGTGATG-3’
Test | Smp_016410_R | 5’-GACTACACGGCGGTACAGGA-3’
Test | Smp_141320_R | 5’-TGAATGATGAGGTGTTGGACA-3’
Test | Smp_136960_R | 5’-TTCACTTTCCCGCAGTTTT-3’
Test | Smp_124050_R | 5’-CATTGCATTTCCATATTGTTCA-3’
Test | Smp_176420_R | 5’-AAAACCTTCTGTCTTAATTGTGGTG-3’
Test | Smp_176590_R | 5’-AATGCGGGTACGTCTGATATG-3’
Test | Smp_030020_R | 5’-CAGCACCAAGTGGAACTGAA-3’
Test | Smp_048880_R | 5’-ATTCTTCTGCAGCCTCGTTG-3’
Test | Smp_045200_R | 5’- AACTACTTGCCATACACGACCA-3’
Test | Smp_045200_F | 5’- ATGGCAACCGAGACGAAAT-3’
Primers used for validation of polycistronic transcripts. Primer mixes for PCRs were performed as indicated below.
Positive control | enolase_poly_F | enolase_poly_R |  | polycistron
Test | Smp_006980-70_F | Smp_006980-70_R |  | polycistron
Test | SL1 |  |  | Smp_006980-70_R |  | trans-splicing
Test | Smp_084900-890_F | Smp_084900-890_R |  | polycistron
Test | SL1 |  |  | Smp_084890_R |  | trans-splicing
Test | Smp_079750-60_F | Smp_079750-60_R |  | polycistron
Test | SL1 |  |  | Smp_079760_R |  | trans-splicing
Test | Smp_023160-70_F | Smp_023160-70_R |  | polycistron
Test | SL1 |  |  | Smp_023170_R |  | trans-splicing
SL1 | 5’-CCGTCACGGTTTTACTCTTG-3’
enolase_poly_F | 5’- TGTTCGGATTCAACAATGCT-3’
enolase_poly_R | 5’- TCCACCTCAACTGTGGGATT-3’
Smp_006980-70_F | 5’-ATGAGGGGTGCACTTACGAC-3’
Smp_006980-70_R | 5’-ATTTCAAACTCGGGACATGC-3’
Smp_084900-890_F | 5’ GGCTGATGTTGAAGCACAAA-3’
Smp_084900-890_R | 5’ AGGAGTGAAACGCTGCAAAT-3’
Smp_084890_R | 5’-GATCGACTGGATGACGACCT-3’
Smp_079750-60_F | 5’-GCAGATTTGACGGAAAATTCA-3’
Smp_079750-60_R | 5’-CGTTAATACGAGCTCCACGA-3’
Smp_079760_R | 5’-TCATTTGCAGCATCCACATT-3’
Smp_023160-70_F | 5’-ACTCCCACAATGTTGCCATA-3’
Smp_023160-70_R | 5’-CCGAAATCCCAGACTGACTC-3’
Smp_023170_R | 5’-AGGCTCGCACATCCTTAAAA-3’
Spreadsheet: 615830e5-47a1-415e-a98f-ca41a4fbdd0b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Narrative: | Letting vendors know a bit about the venue characteristic can help the RFI process and get you more accurate information. Though many of these elements are not set in stone, understanding the size of the venues),  potential placement of your digital signs and the average amount of customer traffic will help those vendors selected to make recommendations including: screen size, the number of screens to use in each store, and even how big your pilot project should be. Likewise, the number of digital signs that you deploy and the places where you put them can both have a significant effect on the cost and complexity of your project.
Location Characteristics
 | In the following section, describe the venues that you will deploy the digital signs to, as well as which of the venue's internal teams the vendors will work with during the project (for example, the store merchandising team or the IT team).
 | Number of locations in the roll-out |  |  | must know
 | Projected time between start of project and the functioning pilot |  |  | should consider
 | Owned vs. leased
 | What is the total (average) square footage of each location
 | Estimated number of 'unique' channels per locations and define characteristics (store zone, product category, etc)
 | Projected number of displays per location
 | Percentage of locations featuring any given piece of content
 | Weekly guest traffic count (average) per location
 | Average length of time a guest spends at a location per visit? (Location dwell time)
 | Identify and define the retailer/vendor workflow/process as it relates to Marketing/Merchandising and Category Management
Spreadsheet: theresa_staab__39594__Kennedy e-mail without gathering
Sheet: S Kitty Detail

[NAME] | Contact: | [NAME] |  |  | Enron North America
 | PH: | [PHONE]
 | FAX: | [PHONE] |  |  | [NAME] | [PHONE]
Inside FERC NGPL Midcont.:
Inside FERC CIG:
First of Month Nomination: |  |  | MMBtu
Additional Purchases: |  |  | MMBtu
 | Wt. Avg. Btu: | Nom. | Pro rata Production | Transportation/MMBtu
[NAME] |  |  |  | 0
[NAME] |  |  |  | 0
S. Kitty Net Backs: |  | Index Discount/Premium | EMS Transport/MMBtu | [NAME] |  | [NAME] | [NAME] (0%*NGPLindex) | Total Receipts Fee Adjustment* |  | Total Net Back
[NAME]. | CIG GD | 0
[NAME]. | IF NGPL Midcont. | 0.01 |  |  |  | -0.1226 | 0
[NAME]. | IF CIG Rockies | 0
Add'l Purchases | CIG GD | See GD Pricing Sheet
Add'l Purchases | CIG GD | 0.1 |  | -0.25
 |  | SOUTH KITTY
 |  | Over 80% of FOM Nom. | FOM CIG GD Volume MMBtu | [NAME] (Less S. Kitty) 80% of FOM Nom. up to 12,000/Day | NGPL Volume MMBtu | 80% of FOM Nom. Less 12,000/Day | FOM CIG Volume MMBtu | Additional CIG GD +.10 Purchases | Add'l CIG GD + .10 Volume MMBtu | Additional CIG GD - Daily Discount | Add'l CIG GD - Daily Discount Volume MMBtu | Total South Kitty Allocated [NAME] | Total South Kitty Production MMBtu | Total Purchased Production MMBtu | Total South Kitty Payments by [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | (7% [NAME] to Maverick)
 | CIG GD Rockies | CIG GD less Netback |  | NGPL less Netback |  | CIG less Netback |  | CIG GD less Netback |  | CIG GD less Netback |  |  |  |  | $ FOM CIG GD | $ NGPL | $ FOM CIG | $ Add'l CIG GD + .10 | $ Add'l CIG GD - Daily Discount | Total Payment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Avg. $/Mmbtu:
*Total Receipts Fee Adjustment is calculated by applying the Field Services Fee to the fuel volume and then dividing that dollar amount(fee times fuel volume) by the volume purchased.
Spreadsheet: 197405d1354331901-if-a-cell-equals-x-then-format-that-many-cells-for-input-ppjn348-bracket-help
Sheet: Leaderboard

NAME | Total Points | RD 1 (32) | RD 2 (32) | [NAME] (24) | Elite 8 (16) | Final 4 (12) | Championship (10)
Spreadsheet: 702113d1604082439-sumifs-with-2-criteria-in-same-column-example1919
Sheet: Data

MFG | Tires | Parts | Labor | Total | Cost | GM$ | GM% | Tire Units | Part Units
0
3001 | 119.98 | 0 | 0 | 119.98 | 171.1 | -51.12 | -42.6071011835306 | 3 | 0
3019 | 815.93 | 0 | 0 | 815.93 | 653.91 | 162.02 | 19.85709558418 | 7 | 0
0 Totals: | 935.91 | 0 | 0 | 935.91 | 825.01 | 110.9 | 11.8494299665566 | 10 | 0
a
3118 | 447.96 | 0 | 0 | 447.96 | 342.12 | 105.84 | 23.6271095633539 | 4 | 0
a Totals: | 447.96 | 0 | 0 | 447.96 | 342.12 | 105.84 | 23.6271095633539 | 4 | 0
ABDG
3001 | 0 | -70.99 | 0 | -70.99 | -48.6 | -22.39 | -31.53965347232 | 1 | 0
3012 | 0 | -200.5 | 0 | -200.5 | -111.82 | -88.68 | -44.2294264339152 | 0 | 0
3016 | 0 | -110.99 | -19.99 | -130.98 | 0 | -130.98 | -100 | 0 | 0
4231 | 143.99 | 0 | 149 | 292.99 | 110.01 | 182.98 | 62.4526434349295 | 2 | 0
5003 | 959.94 | 0 | 0 | 959.94 | 756 | 203.94 | 21.2450778173636 | 6 | 0
5004 | 2347.72 | 0 | 0 | 2347.72 | 1889.48 | 458.24 | 19.5185115771898 | 12 | 0
ABDG Totals: | 3451.65 | -382.48 | 129.01 | 3198.18 | 2595.07 | 603.11 | 18.8579129379835 | 20 | 0
ACC
3001 | 579.96 | 0 | 0 | 579.96 | 451.72 | 128.24 | 22.111869784123 | 4 | 0
ACC Totals: | 579.96 | 0 | 0 | 579.96 | 451.72 | 128.24 | 22.111869784123 | 4 | 0
ACCE
2004 | 705.93 | 0 | 0 | 705.93 | 472.46 | 233.47 | 33.0726842604791 | 7 | 0
2005 | 320 | 0 | 0 | 320 | 221.12 | 98.88 | 30.9 | 4 | 0
2011 | 479.96 | 0 | 0 | 479.96 | 335.12 | 144.84 | 30.1775147928994 | 4 | 0
ACCE Totals: | 1505.89 | 0 | 0 | 1505.89 | 1028.7 | 477.19 | 31.6882375206688 | 15 | 0