tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: e8f336a7-c66e-4489-8667-64d3f5cb671d
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
FPHET | Test | FPHET | Anti-Phosphatidylethanolamine Panel | Anti-Phosphatidylethanolamine Panel | Enzyme-Linked Immunosorbent Assay (ELISA) | Plain, Red-Top Tube: Red |  |  | 3 | mL | Draw blood in a plain, red-top tube(s). (Serum gel tube is not  acceptable.) Spin down and send 3.0 mL serum. Immediately freeze and ship frozen in plastic vial(s). Required:        1.  Collection date | 0.25 mL | Specimens other than	Serum Anticoagulants other than	Plain red-top Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	Mild OK; Gross reject Icteric	NA | Reference Range:  0.0 - 10.0 EU   Anti-Phosphatidylethanolamine IgA      Normal            	            0.0 - 10.0      Equivocal                  10.1 - 20.0      Elevated                      > 20.0   Anti-Phosphatidylethanolamine IgG      Normal            	           0.0 - 10.0      Equivocal                 10.1 - 20.0      Elevated                      > 20.0    Anti-Phosphatidylethanolamine IgM      Normal            	           0.0 - 10.0      Equivocal                 10.1 - 20.0      Elevated                       > 20.0    Test Performed by: Cambridge Biomedical Inc. 1320 Soldiers Field Road Boston, MA 02135 | Wednesday | 1 - 14 days | 9 - 16 days | 3 | 83520 |  |  |  |  | Cambridge Biomedical Inc.
FPHET | [NAME] | SRED | Serum Red |  |  |  | Frozen | 30 days
FPHET | Result | Z0150 | Anti-Phosphatidylethanolamine IgG | Anti-Phosphatidylethanolamine IgG | Numeric |  |  |  |  | EU |  |  |  |  |  |  |  |  |  | 13076-5
FPHET | Result | Z0142 | Anti-Phosphatidylethanolamine IgM | Anti-Phosphatidylethanolamine IgM | Numeric |  |  |  |  | EU |  |  |  |  |  |  |  |  |  | 13077-3
FPHET | Result | Z0143 | Anti-Phosphatidylethanolamine IgA | Anti-Phosphatidylethanolamine IgA | Numeric |  |  |  |  | EU |  |  |  |  |  |  |  |  |  | 13078-1
Spreadsheet: 683400d1592706903-return-cells-in-column-that-match-criteria-cells-in-column-that-match-criteria_chris
Sheet: Sheet1

0 | Pixel URL |  | GOALS
Type | Pixel URL |  | 1st Column: Only want cells that are "Click" or "Impression"
SELECT |  |  | 2nd Column: Only want cells that are URLs
Impression | https://acmecorp.net/event?d_event=impression&d_src=hideway
 |  |  |  |  |  |  |  | Bad formula
 |  |  |  |  |  |  |  | {=IFERROR(INDEX(b1:b1000,SMALL(IF(LEFT(b1,5)="https",b1,"")),ROW(b1:b1000),""),ROW(b1))),"")}
 |  |  |  |  |  |  | Type | URL
 | Pixel URL |  |  |  | FINAL RESULT |  | Impression | https://acmecorp.net/event?d_event=impression&d_src=hideway
Type | Pixel URL |  |  |  |  |  | Click | https://acmecorp.net/event?d_event=click&d_src=indoors
SELECT |  |  |  |  |  |  | Impression | https://acmecorp.net/event?d_event=impression&d_src=outside
Click | https://acmecorp.net/event?d_event=click&d_src=indoors
 |  |  |  |  |  |  | Impression
 |  |  |  |  |  |  | Impression
 | Pixel URL |  |  |  |  |  | Click
Type | Pixel URL
SELECT
Impression | https://acmecorp.net/event?d_event=impression&d_src=outside
Spreadsheet: kevin_presto__19988__netco trading
Sheet: East Master List

Name | Position | Reports_To
[NAME] | [NAME] | [NAME]
[NAME] | Physical | [NAME]
[NAME] | Fundamentals | [NAME]
[NAME] | Physical | [NAME]
[NAME] | Structuring | [NAME]
[NAME] | Origination | [NAME]
[NAME] | Fundamentals | [NAME]
[NAME] | Physical | [NAME]
[NAME] | Physical | [NAME]
[NAME] | Fundamentals | [NAME]
[NAME] | Physical | [NAME]
Claudia Guerra | Assistant | [NAME]
[NAME] | Scheduling | [NAME]
[NAME] | Origination | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | M.D. East Origination
[NAME] | Fundamentals | [NAME]
[NAME] | Physical | [NAME]
[NAME] | Projects | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | Physical | [NAME]
[NAME] | [NAME] | [NAME]
Edith Cross | Origination | [NAME]
[NAME] | Structuring | [NAME]
[NAME] | Cash | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | Cash | [NAME]
[NAME] | Physical | [NAME]
[NAME] | Origination | [NAME]
[NAME] | Scheduling | [NAME]
Gulay [NAME] | Fundamentals | [NAME]
[NAME] | Fundamentals | [NAME]
[NAME] | Options | [NAME]
[NAME] | V.P. Options | [NAME]
[NAME] | Physical | [NAME]
[NAME] | Options | [NAME]
[NAME] | Scheduling | [NAME]
[NAME] | Cash | [NAME]
[NAME] | Term | [NAME]
[NAME] | Physical | [NAME]
[NAME] | Origination | [NAME]
[NAME] | Physical | [NAME]
[NAME] | Physical | [NAME]
[NAME] | Cash | [NAME]
[NAME] | Physical | [NAME]
[NAME] | Origination | [NAME]
[NAME] | Term | [NAME]
[NAME] | Physical | [NAME]
[NAME] | Physical | [NAME]
[NAME] | Fundamentals | [NAME]
[NAME] | V.P. East Trading | [NAME]
[NAME] | Projects | [NAME]
[NAME] | Origination | [NAME]
[NAME] | Origination | [NAME]
[NAME] | Scheduling | [NAME]
[NAME] | Origination | [NAME]
[NAME] | Dir. Fundamentals & Projects | [NAME]
[NAME] | Structuring | [NAME]
[NAME] | Scheduling | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | Fundamentals | [NAME]
[NAME] Seely | Physical | [NAME]
[NAME] | Physical | [NAME]
[NAME] | Cash | [NAME]
[NAME] | Origination | [NAME]
[NAME] | Origination | [NAME]
[NAME] | Fundamentals | [NAME]
Narsima Misra | Cash | [NAME]
[NAME] | Origination | [NAME]
[NAME] | Scheduling | [NAME]
[NAME] | Term | [NAME]
[NAME] | Cash | [NAME]
[NAME] | Physical | [NAME]
[NAME] | Physical | [NAME]
Punit Rawal | Physical | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | Origination | [NAME]
[NAME] | Fundamentals | [NAME]
[NAME] | Term | [NAME]
[NAME] | Options | [NAME]
[NAME] | V.P. South East | [NAME]
[NAME] | Term | [NAME]
[NAME] | Fundamentals | [NAME]
[NAME] | Physical | [NAME]
Smith Day | Scheduling | [NAME]
[NAME] | Options | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | Origination | [NAME]
[NAME] | Origination | [NAME]
TJ Black | Co-ordinator | [NAME]
[NAME] | Physical | [NAME]
[NAME] | Physical | [NAME]
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: R46

Ime artikla
Spreadsheet: 743677d1628672698-help-pls-hard-excel-countif-for-multiple-criteria-countif-for-multiple-criteria
Sheet: ROLLBOOK

 |  |  |  |  |  |  | AUGUST
NO. | RANK | NAME | ELEMENT | PL | HOTEL | TYPE | 2021-08-10 00:00:00
810 | CAPT | BOB | E1 | 1PL | Hotel Budgeter | RESERVE
812 | FLTLT | [NAME] | E1 | 1PL | Plaza | REGULAR
814 | SBLT | BLOGGS | E1 | 1PL | Airport Plaza | REGULAR
816 | LT | HORIZON | HQ | 1PL | Grand Hotel 1 | RESERVE
818 | FLGOFF | EAST | E2 | 2PL | Hotel Budget | RESERVE
820 | ASLT | SOUTH | E2 | 2PL | Plaza | REGULAR
822 | 2LT | WEST | E2 | 2PL | Airport Plaza | REGULAR
824 | PLTOFF | CAP | E2 | 2PL | Grand Hotel 2 | REGULAR
816 | LT | [NAME] | HQ | 2PL | Hotel Budget | REGULAR
 |  |  | Each member has personal data that is prefilled to where their working and what type they are (RESERVE/REGULAR). They then get daily rollbook entrys to where they're working and if their staying at the hotel (LI- LIVE IN) or going home (LO -LIVE OUT)
 |  |  | This data then needs to be refelcted in a summary (STAT - See tab) to if they are a reserve or regular, if they are on task (HOTEL) and who is not on task (REST) this needs to be broken down to their corresponding hotel and Element
Spreadsheet: 76581d1277137997-populate-worksheet-based-on-information-in-another-sheet-sample-2
Sheet: JSSP

Invoice | Date | Delivery | POP | Amount | Aged | 1-30 | 30-60 | 61-90 | 90+ | Status/Resolution Plans/Resubmission Date | JSSP
Resubmit without F/S
In Eval
Fuel and Security
Heart Hero
G&A
TOTAL JSSP INVOICES
Outstanding Invoices
Outstanding at AQM
Oustanding at INL
Spreadsheet: 779864d1652156499-populate-calendars-based-on-office-location-daf-office-scheduling-draft-aligw
Sheet: AP

Month: | April
Year: | 2022
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | -3 | -2 | -1 | 0 | 1 | 2
Spreadsheet: 3e9b38b4-a60d-4989-b313-e6a1d4968db0
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
CDAS | Test | CDAS | Drug Screen, Prescription/OTC, Serum | Drug Screen, Prescription/OTC, S | Gas Chromatography-Mass Spectrometry (GC-MS) | Plain, Red-Top Tube: Red |  |  | 4 | mL | Container/Tube: Red top [NAME]: 4 mL Additional Information: Not intended for use in employment-related testing. | 2.1 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	Serum gel tube | None detected | Monday through Friday, Sunday; STAT availability 24/7 | 1 day | 2 days | 1 | 80100 |  |  |  |  | New England
CDAS | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
CDAS | Result | 209034 | Drugs detected: | Drugs detected: | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20785-2 | Drugs identified:Prid:Pt:Ser/Plas:Nom:Screen
Spreadsheet: 132048d1323451291-countifs-not-counting-returns-value-example-maintenance-log
Sheet: November

 |  | November | Hours: |  | Complete: |  | Incomplete: |  |  | Total:
[NAME] Tracking |  |  |  |  |  |  |  |  |  |  | Status No | Status Yes | On Hold | Remarks | Personnel
Req Date | Bldg | Deficiencies | ISR | Parts Ordered | Parts Received | Comp. Date | Start | End | Hrs. | E/R/S |  |  |  |  | Frodo | [NAME] | Pippen | [NAME] | Bilbo
Spreadsheet: 75706d1276260725-excel-2007-freezing-result-copy-of-progressiveentry-1
Sheet: What I want

Save & Reset
Ordered quntities | Came from order | Remains from order
10000 | 5000 | 5000
1000 |  | 1000
5000 |  | 5000
2500 |  | 2500
First case
Save & Reset
Ordered quntities | Came from order | Remains from order
10000 | 2500 | 2500
1000 |  | 1000
5000 |  | 5000
2500 |  | 2500
Secound case
Save & Reset
Ordered quntities | Came from order | Remains from order
10000 | 1500 | 1000
1000 |  | 1000
5000 |  | 5000
2500 |  | 2500
Third case
Spreadsheet: 128504d1321014287-countif-between-dates-help-800901-countif-between-dates-testforip2
Sheet: Report

NAME |  | PERIOD | wk1 W/E | wk2 W/E | wk3 W/E | wk4 W/E | Total
 |  | 8 | 2011-10-22 00:00:00 | 2011-10-29 00:00:00 | 2011-11-05 00:00:00 | 2011-11-12 00:00:00
[NAME] | [NAME] |  | 3 | 1 | 3 | 0 | 7
Fred | Fred |  | 1 | 1 | 1 | 1 | 4
[NAME] | [NAME] |  | 1 | 1 | 1 | 1 | 4
[NAME] | [NAME] |  | 3 | 2 | 1 | 1 | 7
[NAME] | [NAME] |  | 1 | 0 | 1 | 0 | 2
Klaus | Klaus |  | 0 | 1 | 0 | 0 | 1
[NAME] | [NAME] |  | 1 | 0 | 0 | 0 | 1
Sid | Sid |  | 1 | 0 | 0 | 0 | 1
[NAME] | [NAME] |  | 1 | 1 | 1 | 1 | 4
 | 0
 | 0
 | 0
 |  |  | 12 | 7 | 8 | 4 | 31
Spreadsheet: 273599d1382777204-help-with-an-aggregate-rank-formula-excel-question-2-
Sheet: Summary

 | Most recent date:
 |  | Aggregate | Aggregate | Rank | Aggregate | Rank | Aggregate | Rank
 |  | Date | Sales | Sales | Units | Units | Palettes | Palettes
Spreadsheet: 126552d1319743346-pivot-table-help-needed-ptofstatespie
Sheet: Sheet1

Amt | State
100 | CA
247 | NV |  | Row Labels | Sum of Amt | Sum of Amt2 |  |  | Row Labels | Sum of Amt | Sum of Amt2
195 | AR |  | AR | 3966 | 0.1995973829894313 |  |  | AR | 3966 | 0.1995973829894313
90 | WA |  | AZ | 3303 | 0.1662304982385506 |  |  | AZ | 3303 | 0.1662304982385506
295 | AZ |  | CA | 4370 | 0.2199295420231505 |  |  | CA | 4370 | 0.2199295420231505
240 | CA |  | NV | 4187 | 0.2107196779063915 |  |  | NV | 4187 | 0.2107196779063915
140 | NV |  | WA | 4044 | 0.2035228988424761 |  |  | WA | 4044 | 0.2035228988424761
262 | AR |  | Grand Total | 19870 | 1 |  |  | Grand Total | 19870 | 1
247 | WA
263 | AZ
296 | CA
47 | NV
144 | AR
275 | WA
236 | AZ
225 | CA
125 | NV
293 | AR
256 | WA
325 | AZ
341 | CA
72 | NV
331 | AR
73 | WA
260 | AZ
247 | CA
298 | NV
88 | AR
171 | WA
210 | AZ
215 | CA
78 | NV
138 | AR
41 | WA
46 | AZ
196 | CA
284 | NV
105 | AR
346 | WA
81 | AZ
103 | CA
232 | NV
91 | AR
250 | WA
164 | AZ
275 | CA
337 | NV
277 | AR
79 | WA
247 | AZ
53 | CA
267 | NV
331 | AR
178 | WA
191 | AZ
304 | CA
289 | NV
311 | AR
323 | WA
33 | AZ
27 | CA
108 | NV
320 | AR
313 | WA
266 | AZ
343 | CA
142 | NV
92 | AR
128 | WA
142 | AZ
129 | CA
165 | NV
292 | AR
176 | WA
265 | AZ
330 | CA
288 | NV
288 | AR
313 | WA
279 | AZ
302 | CA
179 | NV
264 | AR
113 | WA
116 | AZ
210 | CA
272 | NV
253 | AR
163 | WA
49 | AZ
76 | CA
59 | NV
43 | AR
176 | WA
110 | AZ
303 | CA
77 | NV
337 | AR
291 | WA
81 | AZ
Spreadsheet: 771191d1646494281-unique-count-of-of-column-a-where-column-b-contains-word-test
Sheet: Dashboard

Active Users Sheet | Manual Count | Formula Total
Unique count of IDs where Match = Yes | 593
Unique count of IDs where Match = Yes and Team = Green | 26
Unique count of IDs where Match = Yes and Team contains "Green" | 86
Unique count of IDs where Match = Yes and Team contains "Blue" and Dept contains "Pears" | 20
Logins Sheet | Manual Count | Formula Total
Unique count of IDs where status = active and login is in last 6 months | 300
Unique count of IDs where status = active and Match = Yes and login is in last 6 months | 66
Spreadsheet: darrell_schoolcraft__7802__imbalsumm0108
Sheet: PG&E

56698
Day | Measured | Scheduled
1 | -151076 | -150326
2 | -186416 | -184781
3 | -210011 | -208808
4 | -245094 | -241726
5 | -236194 | -235157
6 | -172231 | -181280
7 | -117605 | -116400
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | 24925
2001-08-07 00:00:00
CBS Dollars
 |  |  | -156014
Spreadsheet: 718675d1613293741-extract-values-into-column-a-to-column-k-of-sheet-named-here_1-ignoring-blanks-extract-values-ignoring-blanks-1-
Sheet: Sheet1

Name_1 | Name_2 | Middle | Area | Area Time | Local Time | GPS | Letter | District Name | Distance | Status
Spreadsheet: kim_ward__20823__DWP Gas Assets
Sheet: Kern River Capacity

City of Los Angeles
Department of Water & Power
Kern River Pipeline (KRPL) Transport
Effective Date: |  | 1993-07-01 00:00:00
Term: |  | 15 Years
Capacity: |  | 50900 | MMBtu/d
 | A | B | C=(A+B)*12/365 | D | E | F=C+D+E | G
Rate | Demand | Surcharge | Demand | Commodity | AGA + | Total | Fuel
 | Charge | $/Dth/Mth | Charge | Charge | GRI | Cost
 | $/Dth/Mth |  | Commoditized | $/MMBtu | $/MMBtu | @ 100%
 |  |  | @ 100% LF |  |  | LF
 |  |  | $/MMBtu |  |  | $/MMBtu
KRF-1 | 19.98 | 0.1623 |  | 0.0021
Spreadsheet: 784814d1655967247-conditional-format-with-multiple-condition-cf-based-on-column-header-aligw
Sheet: Sheet1

 |  |  | Store-1 |  |  | Store-2 |  |  | Store-3 |  |  | Store-4 |  |  | Store-5
ARTICLE NO | COLOR | Size | Actual | MBQ | Diff | Actual | MBQ | Diff | Actual | MBQ | Diff | Actual | MBQ | Diff | Actual | MBQ | Diff
Arti-1 | Black | 40 | 2 | 2 |  | 1 | 2 |  | 2 | 2 |  | 2 | 2 |  | 2 | 2
Arti-1 | Black | 41 | 3 | 2 |  | 2 | 2 |  | 3 | 5 |  | 3 | 2 |  | 2 | 2
Arti-1 | Black | 42 | 1 | 2 | -1 | 3 | 2 | -1 | 1 | 7 | -1 | 1 | 6 | -1 | 1 | 2 | -1
Arti-1 | Black | 43 | 5 | 1 |  | 5 | 1 |  | 5 | 1 |  | 5 | 0 |  | 1 | 1
Arti-1 | Black | 44 | 2 | 3 |  | 2 | 3 |  | 2 | 3 |  | 2 | 3 |  | 2 | 3
Arti-1 | Black | 45 | 0 | 2 |  | 0 | 2 |  | 0 | 2 |  | 0 | 2 |  | 0 | 2
Query: | Need to put conditional formatting in "Diff" Column only, i.e. if greater then 0 then it should be one color or if its less than zero then it should be different color
Spreadsheet: 32058d1228174101-how-to-automatically-reference-cells-in-another-worksheet-roast-compilation-new-2
Sheet: OT

PCDG SUNDAY ROAST GP TRACKER
PUB NAME | DATE |  | 2008-11-16 00:00:00 | PERIOD | 2 | WEEK | 3
ot
ITEM | INVOICE PURCHASE PRICE |  | NUMBER SOLD | TOTAL COST | SALES PRICE | £ GP | GP % | COST PER PLATE | MEAT COST PER PLATE
PORK | 12 |  | 4 |  | 14
BEEF | 87.44 |  | 43 |  | 12.95
LAMB | 65.34 |  | 23 |  | 10.5
TOTAL
Spreadsheet: 821197d1678494673-rank-from-current-table-to-desired-table-what-formula-do-i-use-rank-formula
Sheet: Sheet1

 | Current table |  |  | desired table
 |  |  |  |  |  |  | Rank(unique)
 | potatoes | 12 |  | peas | 15
 | carrots | 8 |  | potatoes | 12
 | peas | 15 |  | carrots | 8
 | cabbage | 3 |  | swede | 7
 | swede | 7 |  | beans | 5
 | beans | 5 |  | cabbage | 3
 | formula to produce the desired table from the current table please
Spreadsheet: 672248d1586805086-need-a-formula-that-will-sum-the-value-of-dollars-within-a-given-date-range-forumhelp1
Sheet: Sheet1

ID | 2020-03-20 00:00:00 | 2020-03-21 00:00:00 | 2020-03-22 00:00:00 | 2020-03-23 00:00:00 | 2020-03-24 00:00:00 | 2020-03-25 00:00:00 | First Day of Range | Last Day of Range | Sum of Range
A1 | 156 | 153.25 | 78 | 55 | 150.5 | 10 | 2020-03-21 00:00:00 | 2020-03-22 00:00:00
A2 | 200 | 75 | 50 | 300 | 1200 | 50 | 2020-03-20 00:00:00 | 2020-03-25 00:00:00
A3 | 100 | 85 | 60 | 700 | 605.5 | 55.5 | 2020-03-23 00:00:00 | 2020-03-24 00:00:00
A4 | 150 | 90.25 | 45.5 | 500 | 1000 | 100.75 | 2020-03-20 00:00:00 | 2020-03-25 00:00:00
A5 | 300 | 10.25 | 35 | 450.75 | 750 | 900 | 2020-03-21 00:00:00 | 2020-03-23 00:00:00
Spreadsheet: louise_kitchen__24093__NEWCO HEADCOUNT NAMES
Sheet: Canada Support

Canada Support
Dawes | Accounting | Director
Hanslip | Accounting | Manager
[NAME] | Accounting | Spec.
Donlevy-Lee | Accounting | Sr. Spec.
Quon | Accounting | Sr. Spec.
Scott | Accounting | VP
[NAME] | [NAME] | Admin Coordinator
O'Neil | [NAME] | Sr. Admin
McCullough | [NAME] | Sr. Admin
Liknes | Documentation | [NAME]
Moscoso | Documentation | Spec
Seib | Documentation | Sr. Spec
[NAME] | Documentation | Sr. Spec
Vacancy | HR | Sr. Spec.
Martin | IT | Spec
[NAME] | Legal | Sr. Counsel
Keohane | Legal | Sr. Counsel
[NAME] | Logistics | VP
Ripley | Logistics | Spec.
Prior | Logistics | Sr. Spec
Tackney | Logistics | Staff
[NAME] | Risk | Manager
Reeves | Risk | Manager
[NAME] | Risk | Spec
Unger | Risk | Spec
Luc | Risk | Staff
Marryott | Toronto | Director
[NAME] | Toronto | Manager
Punja | Volume Management | Staff
Johnston | Legal | Sr. Counsel
Rondeau | IT
[NAME] | IT
Crawford | Admins
 |  | Total | 33
Spreadsheet: phillip_m_love__30149__9908_OA
Sheet: BUG_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  BUG
 |  |  | Total |  | Reclasses |  | August |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  | -9875 |  |  |  | -125 | -416 |  | 7382922
2 |  | Liquidations |  |  |  |  |  |  |  | 0
3 |  | Interdesk |  |  |  |  | 13806202 | 41403278 | 0 | 0 | 2638549 | 7493983 | 2638549 | 7493983 | -5277098 | -14987966
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  |  |  | 0 |  | 11298555 |  |  |  |  |  | -7463860
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  |  |  | 9571 | -2812670 |  | -430 | 100
7 |  | Liquidations
8 |  | Interdesk |  |  |  |  | -16760365 | -49165941 |  |  | -2638549 | -7493983 | -2638549 | -7493983 | 5277098 | 14987966
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind |  |  |  |  | 590706 | 1545878 | -590706 | -1545878
14 |  | Cash Out
15 |  | Cash In |  |  |  |  |  |  | 0 | 0
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg) |  |  |  |  | 1691119 | 4919117 | -34955 | -101669 | -18204 | -52952 | -5022 | -14609
18 |  | W/D (Purchase from Stg) |  |  |  |  |  |  |  |  |  |  |  |  | -58508 | -155261
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  | 625965 | 1638150 | 18204 | 47640 | 5047 | 13208 | 58508 | 153115
23 | Fuel: |  |  |  |  |  | 0 | 0 | 0 | 0
 | Transport Expense: |  |  |  |  |  |  |  | 0
24 |  | Commodity
25 |  | Demand |  |  |  |  | 0 | 0 |  | -190252 |  | -1942310 |  | 29233
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate |  |  |  |  |  | 0 |  | 0
27 |  | Intrastate |  |  |  |  |  | 56514
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense |  |  |  |  |  |  |  |  |  |  | 0 | 0
29 |  | Transport Revenue |  |  |  |  |  |  |  |  |  |  |  | 0
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance |  |  |  |  |  |  |  | 0
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  |  |  | -56514
 |  | TOTAL
Spreadsheet: 889170d1739890542-return-a-cell-for-a-certain-condition-based-on-the-sequence-of-numbers-in-a-row-datecheck
Sheet: Sheet1

 | Current fomula | Date | Required Date | New Formula | 2020-01-01 00:00:00 | 2020-01-02 00:00:00 | 2020-01-03 00:00:00 | 2020-01-04 00:00:00 | 2020-01-05 00:00:00 | 2020-01-06 00:00:00 | 2020-01-07 00:00:00 | 2020-01-08 00:00:00 | 2020-01-09 00:00:00 | 2020-01-10 00:00:00 | 2020-01-11 00:00:00 | 2020-01-12 00:00:00 | 2021-01-01 00:00:00 | 2021-01-02 00:00:00 | 2021-01-03 00:00:00
Product A |  |  | 2020-01-08 00:00:00 |  | 4 | 9 | 4 | 1 | 0 | 0 | 0 | 2 | 2 | 6 | 1 | 8 | 65 | 3 | 0
Product B |  |  | 2020-01-01 00:00:00 |  | 3 | 12 | 12 | 12 | 45 | 87 | 32 | 45 | 3 | 0 | 2 | 7 | 0 | 0 | 0
Product C |  |  | 2020-01-01 00:00:00 |  | 0 | 0 | 2 | 6 | 99 | 3 | 6 | 5 | 5 | 1 | 0 | 1 | 0 | 1 | 5
Product D |  |  | 2020-01-01 00:00:00 |  | 1 | 45 | 32 | 11 | 6 | 77 | 23 | 456 | 1 | 9 | 8 | 5 | 3 | 4 | 1
Product E |  |  | 2020-01-04 00:00:00 |  | 0 | 0 | 0 | 1 | 2 | 3 | 0 | 2 | 66 | 7 | 4 | 5 | 6 | 9 | 1
Product F |  |  | 2020-01-01 00:00:00 |  | 2 | 2 | 2 | 3 | 9 | 9 | 9 | 5 | 8 | 3 | 7 | 5 | 1 | 0 | 0
Product G |  |  | 2020-01-07 00:00:00 |  | 1 | 0 | 0 | 0 | 0 | 0 | 4 | 6 | 9 | 5 | 5 | 6 | 5 | 5 | 0
Product H |  |  | 2020-01-06 00:00:00 |  | 2 | 0 | 0 | 0 | 0 | 3 | 4 | 5 | 6 | 7 | 5 | 0 | 0 | 0 | 0
Spreadsheet: 90787d1290528647-user-data-form-stock-sheet-goods-movement
Sheet: Sheet1

Period / WK | Date | Order No./Rec No. | Tech Itnl. | Technician Name | Product No. | Item Description | Issued Stock | Deliveries & Returns | Running Stock | Qty To Order
Period 1 Wk 1 | 2010-11-23 00:00:00 | 1002 | km | [NAME] miller | 001 | 16watt gls energy saver ES lamp | 20 |  | 310 | 0
Spreadsheet: 480179d1473806687-converting-to-units-labor-hours-tracking
Sheet: Labor Factor

Blending | 2
Encapsulation | 1
Go Packer | 2
Liquid Blending | 1
Liquid Fill | 4
Bottling | 4
[NAME] | 2
Softgel | 3
Powder Pouching | 1
[NAME] | 4