tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 268375d1380609475-if-a2-blank-then-copy-information-to-another-sheet-example
Sheet: Gasifier

CRAFT | ONSITE | EMPLOYEE NAMES | CRAFT | TIMESHEET | DATE
PIPEFITTERS (A-C) | 1 | ADAMS, [NAME] | MECH FMAN | ADAMS, DARRON LEVON
PIPEFITTERS (A-C) |  | BOURGEOIS, JARED M. | MECH JOURNYMN A | ADAMS, DARRON LEVON
PIPEFITTERS (A-C) | 1 | BROOKS, [NAME] | MECH JOURNYMN A | ADAMS, DARRON LEVON
SUPPORT | 1 | BURNSIDE, DARRELL | LABR JOURNEYMAN | ADAMS, DARRON LEVON
PIPE WELDERS | 1 | GEORGE, ANTONY | BM 657B | ADAMS, DARRON LEVON
PIPEFITTERS (A-C) |  | HAMNER, [NAME] | MW GFMAN A | ADAMS, DARRON LEVON
PIPEFITTERS (A-C) | 1 | LONGORIA, EDGAR | MECH JOURNYMN A | ADAMS, DARRON LEVON
PIPEFITTERS (A-C) | 1 | MORALES, ORLANDO | MECH JOURNYMN A | ADAMS, DARRON LEVON
PIPEFITTERS (A-C) | 1 | SANTOS CRUZ, [NAME] | MECH JOURNYMN A | ADAMS, DARRON LEVON
PIPEFITTERS (A-C) |  | STEELE, HOUSTON KENNETH | MECH JOURNYMN A | ADAMS, DARRON LEVON
PIPE SUPPORT FITTER (A-C) | 1 | ALVAREZ, EMANUEL | MECH FMAN | ALVAREZ, EMANUEL
PIPE SUPPORT WELDERS | 1 | APONTE, CARLOS A DIAZ | BM WELDER | ALVAREZ, EMANUEL
PIPE SUPPORT FITTER (A-C) | 1 | DEANDA, RAYMOND | MECH JOURNYMN A | ALVAREZ, EMANUEL
PIPE SUPPORT WELDERS | 1 | DELGADO, JULIO BERRIOS | BM WELDER | ALVAREZ, EMANUEL
PIPE SUPPORT FITTER (A-C) | 1 | MARTINEZ, GILBERTO | MECH JOURNYMN A | ALVAREZ, EMANUEL
PIPE SUPPORT FITTER (A-C) | 1 | MELENDEZ, [NAME] | MECH JOURNYMN A | ALVAREZ, EMANUEL
PIPE SUPPORT FITTER (A-C) |  | [NAME], ALEXANDER | MECH JOURNYMN A | ALVAREZ, EMANUEL
PIPE SUPPORT FITTER (A-C) | 1 | MUNOZ, RICHARD | MW GFMAN A | ALVAREZ, EMANUEL
PIPE SUPPORT WELDERS | 1 | RIVERA, SAMUEL | BM WELDER | ALVAREZ, EMANUEL
PIPE SUPPORT FITTER (A-C) | 1 | RODRIGUEZ, CARLOS A. | MECH JOURNYMN A | ALVAREZ, EMANUEL
PIPE SUPPORT FITTER (A-C) | 1 | SAUCEDO, [NAME] | MECH JOURNYMN A | ALVAREZ, EMANUEL
PIPEFITTERS (A-C) | 1 | ANDREWS, MILTON | MECH FMAN | ANDREWS, MILTON
PIPEFITTERS (A-C) | 1 | DANIEL, WILL | MECH [NAME] | ANDREWS, MILTON
Spreadsheet: 679100d1590187886-what-is-wrong-with-my-formula-headcounts-per-month-v2
Sheet: Test

Last name, First name | Contract Start Date ([NAME]:dd:yyyy) | Contract End Date | [NAME] | Annual Salary | Monthly Salary | HC Jun 2020 | HC Jul 2020 | HC Aug 2020 | HC Sep 2020 | HC Oct 2020 | HC Nov 2020 | HC Dec 2020 | [NAME] | [NAME] | [NAME] 2020 | [NAME] | [NAME] | [NAME] | [NAME]
Apple | 2019-11-01 00:00:00 | 2021-11-22 00:00:00 | 2020-05-22 00:00:00 | 46800
Orange | 2020-03-15 00:00:00 | 2020-11-22 00:00:00 |  | 80400
[NAME] | 2019-11-01 00:00:00 | 2020-07-22 00:00:00 |  | 46800
Plum | 2020-07-23 00:00:00 | 2021-11-22 00:00:00 |  | 69600
Candy | 2019-11-23 00:00:00 | 2021-09-22 00:00:00 |  | 80400
[NAME] | 2020-11-23 00:00:00 | 2021-10-22 00:00:00 |  | 69600
[NAME] | 2019-11-23 00:00:00 |  |  | 150000
Spreadsheet: 155450d1336847090-how-to-make-a-table-that-count-by-the-names-solloman
Sheet: Sheet1

CODE | NAME OF PRODUCT | PRICE | CANT. | TOTAL
A1J | MILK CLEANSER | 80
A2-NJ | SKIN TONER(NORMAL) | 50
A2J-DJ | SKIN TONER(DRY) | 20
A2J-OJ | SKIN TONER(OILY) | 90
A7J | EXFOLIANTE FACIAL MASK | 60
[NAME] | MOISTURIZING CREAM | 40
A12J | EYE GEL | 50
A12JP | JP EYE&NECK GEL | 10
A14JP | NIGHT CREAM COMPLEX | 60
A15 | CELLULITE CONTROL | 60
A17J | AROMATIC BODY MUD TREATMENT | 90
A33J | HAND CREAM | 90
A43J | FOOT CREAM | 90
A40 PH JP | [NAME]PEACH& HONEY | 90
A40 LM JP | [NAME]LITCHI & MELON | 90
A40 KM JP | [NAME]  MANGO | 90
A40 LG JP | [NAME]  [NAME] | 90
A45 JP | [NAME] | 90
A48,49JP | FACIAL COLLAGEN MASK | 90
A56J | MINERAL SERUM | 90
56JP | LIFTING SERUM | 90
A66J | DEAD SEA AROMATIC SALT CRYSTALS-ENERGY | 90
A69J | FOAMING FACIAL SCRUB | 90
A6-PH-J | ENERG SALT SCRUB PEACH&HONEY | 90
A6-LM-J | ENERG SALT SCRUB LITCHI&MELON | 90
A6-KM-J | ENERG SALT SCRUB KIWI&MANGO | 90
A6-LG-J | ENERG SALT SCRUB LEMONGRASS | 90
A87J | MOIST BOOSTER BODY BUTTER | 90
[NAME] | BODY LOTION MILK AND HONEY | 90
A88 | [NAME] | 90
A89 | [NAME] | 90
A80JP | FACIAL SAUNA MASK | 90
[NAME] | LUXURIOUS SKIN CARE SET BLACK | 90
L1 JP | RESTORING DAY CREAM | 90
L2JP | MAINE COLLAGEN BOOSTER JP | 90
B3 JP | FACIAL PEARL MASK | 90
A93J | CONDITIONAR FOR ALL HAIR TYPES | 90
B10J | BLACK MUD SHAMPOO | 90
B13J | MINERAL HAIR MASK FOR ALL HAIR KIND | 90
B11J | SHAMPOO FOR ALL HAIR KIND | 90
G104JP | ACTIVE SERUM | 90
A10S | BLACK PEARL PRESTIGE G  MASK | 90
A53S | BLACK PEARL PEELING  MASK | 90
[NAME] | BLAK PEARL - RELAXING BEAUTY MASK | 90
G2 S | TIME CONTROL ACTIVE DAY CREAM  SENSITIVE DRY & VERY DRY SKIN | 90
G3 S | BLAK PEARL - FACE & EYE CREAM SERUM | 90
S2J | ACNE  SOAP | 90
S7J | SEAWEED SOAP | 90
N11 | NAIL KIT-MILK&HONEY | 90
N12 | [NAME] | 90
N13 | [NAME] | 90
P3J | PLASTIC BAG | 90
99NJ | NYLON BAGS | 90
 |  | DELTA |  | INSURGENTES |  | COAPA |  | TEZONTLE |  | LINDAVISTA |  | SATELITE
 |  | CODIGO | CANT. | CODIGO | CANT. | CODIGO | CANT. | CODIGO | CANT. | CODIGO | CANT. | CODIGO | CANT.
 |  | A14JP | 2 | A1J | 1 | A11J | 2 | A1J | 1 | A7J | 3 | A11J | 3
 |  | S2J | 15 | A12J | 2 | A12J | 2 | A7J | 2 | A12J | 2 | A12J | 2
 |  |  |  | A14JP | 2 | A14JP | 2 | A12J | 2 | A14JP | 2 | A14JP | 2
 |  |  |  | A56J | 4 | A56J | 2 | A14JP | 2 | A56J | 2 | A87J | 5
 |  |  |  | A69J | 6 | A69J | 2 | A56J | 2 | A69J | 2 | B3JP | 2
 |  |  |  | A6JLG | 3 | A6JLM | 3 | A87J | 3 | A87J | 2 | S2J | 15
 |  |  |  | A6JPH | 3 | A87J | 5 | A1JP | 2 | B3JP | 5
 |  |  |  | A87J | 5 | L1JP | 3 | B3JP | 3 | A53S | 2
 |  |  |  | [NAME] | 20 | G2S | 3 | A53S | 2 | S2J | 10
 |  |  |  |  |  | S2J | 15 | S2J | 10
 |  | TOTAL CANT. :
Spreadsheet: 880500d1728303132-filter-functions-with-combobox-example-2-1-
Sheet: Raw

Company | Month | Level | Partcipant | Training Topic | Department | Training hours | Amount | Result
A | Jan | Manager | [NAME] | Excel | GA | 6 | 50 | Passed |  |  |  |  |  |  |  | Topics | Dept | Company
A | Jan | Staff | [NAME] | Excel | HR | 6 | 50 | Passed |  |  |  |  |  |  |  | Excel | GA | A
A | Feb | Staff | Marlyn | Excel | HR | 6 | 50 | Passed |  | Cell link Topics | 4 |  |  |  |  | Powerpoint | HR | B
B | Feb | Manager | [NAME] | Excel | Sales | 6 | 55 | Passed |  | Cell link Dept | 6 |  |  |  |  | Power BI | Sales | C
B | Mar | Manager | [NAME] | Powerpoint | Sales | 5 | 30 | Not Passed |  | Cell link Company | 4 |  |  |  |  | ALL | Finance | ALL
B | Mar | Staff | Cathy | Powerpoint | Finance | 5 | 30 | Passed |  |  |  |  |  |  |  |  | Logistics
C | Mar | Staff | [NAME] | Power BI | Finance | 7 | 60 | Not Passed |  |  | Topics |  |  |  |  |  | ALL
C | Mar | Staff | Michelle | Powerpoint | Logistics | 5 | 50 | Passed
C | Apr | Staff | Michelle | Excel | Logistics | 6 | 60 | Not Passed
 | Total training hour by Topic |  |  | if choose topic=ALL, dept = ALL, company = ALL then hours = 18 |  |  |  |  |  |  | Dept
 |  |  |  | if choose topic=ALL,dept =sales, company =B then hours =11
 | Dept | Amount |  |  | Amount
 | GA |  |  | GA | 50 |  |  |  |  |  | Company
 | HR |  |  | HR | 100
 | Sales |  |  | Sales | 85
 | Finance |  |  | Finance | 90
 | Logistics |  |  | Logistics | 110
 | Dept | Total Participant passed |  |  | Total Participant passed
 | GA |  |  | GA | 1
 | HR |  |  | HR | 2
 | Sales |  |  | Sales | 1
 | Finance |  |  | Finance | 1
 | Logistics |  |  | Logistics | 1
 | Level | Total Participant passed |  |  | Total Participant passed
 | Staff |  |  | Manager | 2
 | Manager |  |  | Staff | 4
Spreadsheet: 829845d1684485522-numbering-weeks-example-week-numbering
Sheet: Sheet1

 |  |  |  | Sample date 1: |  | 2023-08-14 00:00:00 |  | Sample date 2: |  | 2024-08-14 00:00:00
In column A,  I want the column to list all the weeks just by one day, and the week number for that given time frame. It should work for any set of dates I plug in above
 |  |  |  |  |  | Date | Week
2023-08-14 00:00:00 | Week 1
2023-08-21 00:00:00 | Week 2 |  |  |  |  | 2023-08-21 00:00:00 | 2
2023-08-28 00:00:00 | Week 3 |  |  |  |  | 2023-08-28 00:00:00 | 3
… |  |  |  |  |  | 2023-09-04 00:00:00 | 4
2024-08-05 00:00:00 | Week 52 |  |  |  |  | 2023-09-11 00:00:00 | 5
 |  |  |  |  |  | 2023-09-18 00:00:00 | 6
 |  |  |  |  |  | 2023-09-25 00:00:00 | 7
 |  |  |  |  |  | 2023-10-02 00:00:00 | 8
 |  |  |  |  |  | 2023-10-09 00:00:00 | 9
 |  |  |  |  |  | 2023-10-16 00:00:00 | 10
 |  |  |  |  |  | 2023-10-23 00:00:00 | 11
 |  |  |  |  |  | 2023-10-30 00:00:00 | 12
 |  |  |  |  |  | 2023-11-06 00:00:00 | 13
 |  |  |  |  |  | 2023-11-13 00:00:00 | 14
 |  |  |  |  |  | 2023-11-20 00:00:00 | 15
 |  |  |  |  |  | 2023-11-27 00:00:00 | 16
 |  |  |  |  |  | 2023-12-04 00:00:00 | 17
 |  |  |  |  |  | 2023-12-11 00:00:00 | 18
 |  |  |  |  |  | 2023-12-18 00:00:00 | 19
 |  |  |  |  |  | 2023-12-25 00:00:00 | 20
 |  |  |  |  |  | 2024-01-01 00:00:00 | 21
 |  |  |  |  |  | 2024-01-08 00:00:00 | 22
 |  |  |  |  |  | 2024-01-15 00:00:00 | 23
 |  |  |  |  |  | 2024-01-22 00:00:00 | 24
 |  |  |  |  |  | 2024-01-29 00:00:00 | 25
 |  |  |  |  |  | 2024-02-05 00:00:00 | 26
 |  |  |  |  |  | 2024-02-12 00:00:00 | 27
 |  |  |  |  |  | 2024-02-19 00:00:00 | 28
 |  |  |  |  |  | 2024-02-26 00:00:00 | 29
 |  |  |  |  |  | 2024-03-04 00:00:00 | 30
 |  |  |  |  |  | 2024-03-11 00:00:00 | 31
 |  |  |  |  |  | 2024-03-18 00:00:00 | 32
 |  |  |  |  |  | 2024-03-25 00:00:00 | 33
 |  |  |  |  |  | 2024-04-01 00:00:00 | 34
 |  |  |  |  |  | 2024-04-08 00:00:00 | 35
 |  |  |  |  |  | 2024-04-15 00:00:00 | 36
 |  |  |  |  |  | 2024-04-22 00:00:00 | 37
 |  |  |  |  |  | 2024-04-29 00:00:00 | 38
 |  |  |  |  |  | 2024-05-06 00:00:00 | 39
 |  |  |  |  |  | 2024-05-13 00:00:00 | 40
 |  |  |  |  |  | 2024-05-20 00:00:00 | 41
 |  |  |  |  |  | 2024-05-27 00:00:00 | 42
 |  |  |  |  |  | 2024-06-03 00:00:00 | 43
 |  |  |  |  |  | 2024-06-10 00:00:00 | 44
 |  |  |  |  |  | 2024-06-17 00:00:00 | 45
 |  |  |  |  |  | 2024-06-24 00:00:00 | 46
 |  |  |  |  |  | 2024-07-01 00:00:00 | 47
 |  |  |  |  |  | 2024-07-08 00:00:00 | 48
 |  |  |  |  |  | 2024-07-15 00:00:00 | 49
 |  |  |  |  |  | 2024-07-22 00:00:00 | 50
 |  |  |  |  |  | 2024-07-29 00:00:00 | 51
 |  |  |  |  |  | 2024-08-05 00:00:00 | 52
 |  |  |  |  |  | 2024-08-12 00:00:00 | 53
Spreadsheet: 50a435ec-4609-4b19-b6a1-f0ee3c30fc51
Sheet: Spreadsheet Contents

This file contains the following datasheets
Sheet | Contents | Paper Figure
Complete_Newman_Reg_Reactions | Detailed Reactions contained in each module for Newman partition of complete hepatocyte network | 5A
Complete_Newman_Reg_Report | Table of quantitative factors for Newman partition of complete hepatocyte network | 5A
Complete_Shred_Reg_Reactions | Detailed Reactions contained in each module for ShReD-partition of complete hepatocyte network | 5B
Complete_Shred_Reg_Report | Table of quantitative factors for ShReD partition of complete hepatocyte network | 5B
Complete_Shred_Noreg_Reactions | Detailed Reactions contained in each module for ShReD partition of complete hepatocyte network with no regulatory edges | 7A
Complete_Shred_Noreg_Report | Table of quantitative factors for ShReD partition of complete hepatocyte network with no regulatory edges | 7A
Nocof_Shred_Reg_Reactions | Detailed Reactions contained in each module for ShReD partition of partial hepatocyte network, no cofactors with regulation | 7B
Nocof_Shred_Reg_Report | Table of quantitative factors for ShReD partition of partial hepatocyte network, no cofactors, with regulation | 7B
Hepatocyte_Model | Detailed annotation of each reaction - references to KEGG and Delta Gs of reactions
Hepatocyte_Model_Stoichiometry | [NAME] in S-matrix format
Hepatocyte_Model_Regulation | [NAME] as described in Methods
Spreadsheet: 213582d1360585052-return-a-1st-2nd-or-3rd-from-row-of-numbers-society-scoring-system-template
Sheet: handicaps

 | Date Confirmed | Club H/Cap |  | Society H/Cap
 | Name | H/cap | Date | H/cap | Revised Date
1 | Allpress [NAME] | 22 | 2011-04-08 00:00:00 | 19 | 2013-09-01 00:00:00
2 | Ancell [NAME] | 22 | 2010-03-18 00:00:00 | 18 | 2012-11-01 00:00:00
3 | [NAME] | 11 | 2010-03-18 00:00:00 | 7 | 2013-08-01 00:00:00
4 | [NAME] | 21 | 2010-03-18 00:00:00 | 21
5 | [NAME] | 12 | 2010-03-18 00:00:00 | 9 | 2012-10-01 00:00:00
6 | Cooper [NAME] | 11 | 2010-03-18 00:00:00 | 9 | 2013-10-01 00:00:00
7 | [NAME] | 15 | 1900-01-12 00:00:00 | 8 | 2012-11-01 00:00:00
8 | East [NAME] | 8 | 2010-03-18 00:00:00 | 10 | 2013-06-01 00:00:00
9 | [NAME] | 8 | 2010-03-18 00:00:00 | 8
10 | [NAME] | 24 | 2010-03-18 00:00:00 | 24 | 2011-07-01 00:00:00
11 | Goss Keven | 24 | 2010-03-18 00:00:00 | 18 | 2012-11-01 00:00:00
12 | [NAME] | 14 | 2009-06-09 00:00:00 | 12 | 2013-06-01 00:00:00
13 | Hargreaves Pete | 12 | 2010-03-18 00:00:00 | 10 | 2013-09-01 00:00:00 | 18 | 2005-03-14 00:00:00 | 18
14 | Hawkins Adam | 5 | 2009-04-14 00:00:00 | 5
15 | [NAME] | 14 | 2009-04-14 00:00:00 | 14
16 | Smith Angus | 24 | 2012-05-19 00:00:00 | 21 | 2013-06-01 00:00:00
17 | [NAME] | 17 | 2009-04-14 00:00:00 | 17
18 | L Moran | 17 |  | 14 | 2013-05-01 00:00:00
19 | [NAME] | 21 | 2010-03-18 00:00:00 | 24
20 | [NAME] | 14 | 2009-04-14 00:00:00 | 14 | 2012-09-01 00:00:00
21 | Landells [NAME] | 15 | 2009-06-09 00:00:00 | 20 | March 1,2011
22 | Maciejewski Jan | 16 | 2010-03-18 00:00:00 | 12 | 2013-07-01 00:00:00
23 | [NAME] | 14 | 2009-06-09 00:00:00 | 14
24 | [NAME] | 12 | 2010-10-01 00:00:00 | 12
25 | [NAME] | 23 | 2010-03-18 00:00:00 | 21 | 2011-06-01 00:00:00
26 | [NAME] | 15 | 2009-04-14 00:00:00 | 15
27 | N Northeast | 24 | 2011-06-18 00:00:00 | 24
28 | Rowlands David | 17 | 2010-10-01 00:00:00 | 17
29 | Staines [NAME] | 21 | 2010-03-18 00:00:00 | 21 | 2011-06-01 00:00:00
30 | [NAME] | 22 | 2009-07-15 00:00:00 | 16 | 2013-10-01 00:00:00
31 | [NAME] | 10 | 2010-03-18 00:00:00 | 8 | 2013-10-01 00:00:00
32 | [NAME] | 13 | 2009-04-14 00:00:00 | 10 | 2013-07-01 00:00:00
33 | [NAME] | 11 | 2009-04-14 00:00:00 | 8 | 2013-10-01 00:00:00
34 | [NAME] | 22 | 2009-07-15 00:00:00 | 13 | 2013-10-01 00:00:00
35 | Veil Charlie | 24 | 2009-07-15 00:00:00 | 19 | 2013-05-01 00:00:00
36 | [NAME] | 8 | 2010-03-18 00:00:00 | 7 | 2012-07-01 00:00:00
37 | [NAME] | 14 | 2009-06-09 00:00:00 | 9 | 2012-10-01 00:00:00
38 | [NAME] | 26 |  | 26
39
40 | Society average handicap
 | Golf Club Handicap | Date Confirmed |  | Official Handicap
 | Awarded Handicap | Date Confirmed |  | As Awarded by Society
 | Society Handicap | As per 321 System |  | Actual Playing
 | Renewal Date | As per 321 System |  | After 1 Year Review
 | It is your responsibility to check your handicap and
 | advise the handicap secretary of any changes.
Spreadsheet: 771613d1646756978-how-will-index-match-work-with-name-range-over-12-sheets-or-with-a-vba-test-greatinfoteam-
Sheet: Style Detail

 |  | [NAME] type 1 | [NAME] type 2 | [NAME] type 3
Inv # | Style No. | Unit Price
1 | WTB181693
2 | WTB371652
3 | WTC181281
4 | WTC181275
5 | WTC181304
6 | [NAME]
7 | WTB371647
8 | WTC181313
9 | WTC181260
10 | WTC181297
11 | WTE181121
12 | WTB181678
Spreadsheet: 374283d1422763824-export-data-from-a-fill-able-pdf-to-excel-best-way-import_data
Sheet: Sheet1

1) Broker/Agent Name | Broker/Agent Address | 2) Importer/Consignee | Importer/Consignee Address | 3) Shipper | Shipper Address | 4) EPA Reg. No. | 5) EPA Prod. Estab. | 6) Brand Name | 7) Major [NAME] with percentages | 8) Unit [NAME] | 9) Quantity | 10) Total Net Wt. | 11) Origin | 12) Port of Entry | 13) Carrier | 14) Entry No. | 15) Entry Date | 16) CBI cert | 17) Goods Location for Exam | 18) Remarks - submitting agency | 19) Importer Name or Agent | Phone No. of Importer or Agent | FAX No. of Importer or Agent | Date Signed by [NAME] or Agent | Action - US Customs Service | Remarks - EPA | Signature/Title of EPA Official | Date Signed
UPS Canada | P.O. Box #6157 Moncton, NB E1C 9W9 Canada | Jacobson Companies Attn: [NAME] | 3060 Southpark Blvd Ellenwood, GA 30294 | [NAME] | 11-6782 Saanichton, BC v8M 2C2 Canada | 67702-15 | 67702-CAN-001 | Sulfur/Pyrethrins Fungicide/Insecticide RTU | Sulfur .2%, Pyrethrins .01% | 34 fl. Oz. | 1 | 2.2 lbs | Canada | Blaine | Federal Express Canada Ltd. |  |  |  | Ellenwood, GA |  | [NAME] | [PHONE] |  | 2014-12-05 00:00:00 |  |  | Gianpaolo Boccato | 2014-12-08 00:00:00
*Please note this data applies only to the first row of data in the csv file*
Spreadsheet: 814619d1674508880-fix-conditional-format-and-formula-clean-up-rates-help2fix3
Sheet: Rates

 | Year of Service: | 5 | EQUIP: | F | POS: | FO | HRS: |  | MTHS: | 1 | PAY YEAR: | 2023
CA | A | B | C | D | E | F | G | H | I | J | K | L | M
12
11
10
9
8
7
6
5
4
3
2
1
FO | A | B | C | D | E | F | G | H | I | J | K | L
12
11
10
9
8
7
6
5
4
3
2
1
F0 | A | B | C | D | E | F | G | H | I | J | K | L
 |  |  |  |  | HRS | MINS | CUT | INC
 |  |  |  |  | 1 | 0 | 0 | 0
Spreadsheet: phillip_m_love__30650__9906_OA
Sheet: ONT_GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
REGION:  ONTARIO
REGION:  ONTARIO
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | 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 |  |  |  |  |  |  | 0 | 0 |  |  |  |  | 0 | -21300
2 |  | Liquidations
3 |  | Interdesk |  |  |  |  |  |  | 0 | 0 | -2635696 | -6074833 |  |  |  |  | 403106 | 938574 | 2232590 | 5136259
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk |  |  |  |  | -1162000 | -2684960 |  |  | 1050000 | 2419980 |  |  |  |  | -403106 | -938574 | -646894 | -1481406
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 |  |  |  |  | -1755803 | -4003231 | 1755803 | 4003231 | 0 | 0
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage |  |  |  |  |  |  |  |  | 562918 | 72417
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  | 0 | -1789565 | -4080208 | 2573418 | 5867393 | 0 | 0 | 0 | 0 | 0 | 0 | -1585696 | -3615387 |  |  |  |  |  |  |  |  | 0 | 0
23 | Fuel: |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 0 | 0
 | Transport Expense:
24 |  | Commodity
25 |  | Demand |  |  |  |  |  | 0
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1300000
34 |  | Originations
35 |  | Broker Fees |  |  |  |  |  |  |  |  |  |  |  | -284
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  | 0 |  | 0
 |  | TOTAL
FT-Ontario
 |  | Current Month MTM |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 109335 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Financial Liquidations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Originations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -14945 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 40751d1239139039-conditional-copying-april-question
Sheet: Hoja1

 |  | current column | what i would need
Country | year | variable 1 | variable 1 modified
Aruba | 1970 |  | .
Aruba | 1971 |  | .
Aruba | 1972 |  | .
Aruba | 1973 |  | .
Aruba | 1974 |  | .
Aruba | 1975 |  | .
Aruba | 1976 |  | .
Aruba | 1977 |  | .
Aruba | 1978 |  | .
Aruba | 1979 |  | .
Aruba | 1980 |  | .
Aruba | 1981 | a | a
Aruba | 1982 |  | a
Aruba | 1983 |  | a
Aruba | 1984 |  | a
Aruba | 1985 |  | a
Aruba | 1986 |  | a
Aruba | 1987 |  | a
Aruba | 1988 |  | a
Aruba | 1989 |  | a
Aruba | 1990 |  | a
Aruba | 1991 |  | a
Aruba | 1992 | d | d
Aruba | 1993 |  | d
Aruba | 1994 |  | d
Aruba | 1995 |  | d
Aruba | 1996 |  | d
Aruba | 1997 |  | d
Aruba | 1998 |  | d
Aruba | 1999 |  | d
Aruba | 2000 |  | d
Aruba | 2001 |  | d
Aruba | 2002 |  | d
Aruba | 2003 |  | d
Aruba | 2004 |  | d
Aruba | 2005 |  | d
Aruba | 2006 |  | d
Aruba | 2007 |  | d
Aruba | 2008 |  | d
Afghanistan, I.R. of | 1970 |  | .
Afghanistan, I.R. of | 1971 |  | .
Afghanistan, I.R. of | 1972 | g | g
Afghanistan, I.R. of | 1973 |  | g
Afghanistan, I.R. of | 1974 |  | g
Afghanistan, I.R. of | 1975 |  | g
Afghanistan, I.R. of | 1976 |  | g
Afghanistan, I.R. of | 1977 |  | g
Afghanistan, I.R. of | 1978 |  | g
Afghanistan, I.R. of | 1979 |  | g
Afghanistan, I.R. of | 1980 |  | g
Afghanistan, I.R. of | 1981 |  | g
Afghanistan, I.R. of | 1982 |  | g
Afghanistan, I.R. of | 1983 |  | g
Afghanistan, I.R. of | 1984 |  | g
Afghanistan, I.R. of | 1985 |  | g
Afghanistan, I.R. of | 1986 |  | g
Afghanistan, I.R. of | 1987 |  | g
Afghanistan, I.R. of | 1988 |  | g
Afghanistan, I.R. of | 1989 |  | g
Afghanistan, I.R. of | 1990 |  | g
Afghanistan, I.R. of | 1991 |  | g
Afghanistan, I.R. of | 1992 |  | g
Afghanistan, I.R. of | 1993 |  | g
Afghanistan, I.R. of | 1994 |  | g
Afghanistan, I.R. of | 1995 |  | g
Afghanistan, I.R. of | 1996 |  | g
Afghanistan, I.R. of | 1997 |  | g
Afghanistan, I.R. of | 1998 | i | i
Afghanistan, I.R. of | 1999 |  | i
Afghanistan, I.R. of | 2000 |  | i
Afghanistan, I.R. of | 2001 |  | i
Afghanistan, I.R. of | 2002 |  | i
Afghanistan, I.R. of | 2003 |  | i
Afghanistan, I.R. of | 2004 |  | i
Afghanistan, I.R. of | 2005 |  | i
Afghanistan, I.R. of | 2006 |  | i
Afghanistan, I.R. of | 2007 |  | i
Afghanistan, I.R. of | 2008 |  | i
Spreadsheet: 858847d1707367854-count-numbers-greater-than-zero-in-both-cells-new-microsoft-excel-worksheet
Sheet: Sheet1

Retailer Name | PCNO 100ML | PCNO 200ML | Manual Result
Dulal Store | 2 | 1 | 1
[NAME] | 3 | 0 | 0
Alaur Store | 12 | 6 | 1
[NAME] | 0 | 0 | 0
[NAME] | 0 | 0 | 0
Bipul [NAME] | 0 | 0 | 0
[NAME] | 0 | 0 | 0
[NAME] | 0 | 0 | 0
[NAME] | 0 | 0 | 0
[NAME] | 0 | 0 | 0
Jan store | 0 | 0 | 0
[NAME] | 2 | 12 | 1
Ongon Cosmatic | 0 | 0 | 0
Modina supar store | 1 | 6 | 1
[NAME] | 0 | 3 | 0
Nasim Brathers | 0 | 0 | 0
[NAME] | 0 | 0 | 0
[NAME] | 0 | 0 | 0
[NAME] | 0 | 0 | 0
[NAME] | 0 | 0 | 0