tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 864431d1711597865-array-formula-but-with-different-formula-inbetween-column-a-v-b
Sheet: Report

 | Actual | Budget | [NAME] | Actual | Budget | [NAME] | Actual | Budget | [NAME] | Actual | Budget | [NAME] | Actual | Budget | [NAME] | Actual | Budget | [NAME] | Actual | Budget | [NAME] | Actual | Budget | [NAME] | Actual | Budget | [NAME] | Actual | Budget | [NAME] | Actual | Budget | [NAME] | Actual | Budget | [NAME]
 | 2023-04-30 00:00:00 | 2023-04-30 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-05-31 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-06-30 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-07-31 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-08-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-09-30 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-10-31 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-11-30 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2023-12-31 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-01-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-02-29 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-03-31 00:00:00 | 2024-03-31 00:00:00
 |  | 5000 | -901 |  | 5000 | -302 |  | 5000 | -509 |  | 5000 | -2 |  | 5000 | -760 |  | 5000 | -156 |  | 5000 | -659 |  | 5000 | 159 |  | 5400 | -1291 |  | 5400 | -1096 |  | 5400 | -164 |  | 5400 | 461
Sales-Food | 2042 | 2000 | 42 | 2102 | 2000 | 102 | 2143 | 2000 | 143 | 1910 | 2000 | -90 | 2109 | 2000 | 109 | 2053 | 2100 | -47 | 2132 | 2100 | 32 | 1972 | 2100 | -128 | 1902 | 2100 | -198 | 2164 | 2200 | -36 | 2076 | 2200 | -124 | 1921 | 2200 | -279
Sales-Furniture | 3885 | 3000 | 885 | 4246 | 3000 | 1246 | 3780 | 3000 | 780 | 4160 | 3000 | 1160 | 3628 | 3000 | 628 | 3235 | 3000 | 235 | 4198 | 3000 | 1198 | 3399 | 3000 | 399 | 2885 | 4300 | -1415 | 2553 | 4300 | -1747 | 3893 | 4300 | -407 | 4120 | 4300 | -180
Sales-Foreign | 150 | 0 | 150 | 0 | 0 | 0 | 750 | 0 | 750 | 1100 | 0 | 1100 | 600 | 0 | 600 | 0 | 0 | 0 | 600 | 0 | 600 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 0 | 500 | 1200 | 0 | 1200 | 0 | 0 | 0
Sales-Ad Hoc | 0 | 800 | -800 | 0 | 800 | -800 | 0 | 800 | -800 | 0 | 800 | -800 | 0 | 800 | -800 | 0 | 800 | -800 | 0 | 800 | -800 | 0 | 800 | -800 | 0 | 800 | -800 | 0 | 800 | -800 | 0 | 800 | -800 | 0 | 800 | -800
 |  | 10800 | -624 | 11046 | 10800 | 246 | 11164 | 10800 | 364 | 12168 | 10800 | 1368 | 10577 | 10800 | -223 | 10132 | 10900 | -768 | 11271 | 10900 | 371 | 10530 | 10900 | -370 | 8896 | 12600 | -3704 | 9521 | 12700 | -3179 | 12405 | 12700 | -295 | 11902 | 12700 | -798
* how to make Column A dynamtic? As in the listing will Auto Add on Base on the Column A in Actual and Budget tab?
* is there a way to write an Array formula to replace B3: Ak8?
Spreadsheet: 1ff97681-d37f-4e73-981f-7281577977e2
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  |  | [NAME]
 |  |  |  | اللجنة الاقتصادية والاجتماعية لغربي [NAME] (اسكوا)
 |  |  |  | وحدة التنسيق الاحصائي
استمارة احصاءات ومؤشرات [NAME]
2005
 |  |  |  |  |  | البلد:
 |  |  |  |  |  |  | [NAME] هذا الاستبيان بعد استيفائه الى العنوان التالي:
 |  |  |  |  |  | السيد احمد حسين
 |  |  |  |  |  | رئيس وحدة التنسيق الاحصائي
 |  |  |  |  |  | اللجنة الاقتصادية والاجتماعية لغربي آسيا
 |  |  |  |  |  | [NAME] والمؤشرات الاجتماعية
 |  |  |  |  |  | مبنى الامم المتحدة
 |  |  |  |  |  | ساحة رياض الصلح، ص. ب. 8575- 11
 |  |  |  |  |  | [NAME] اللبنانية
 |  |  |  |  |  |  | اذا كانت لديكم اي استفسارات حول هذا الاستبيان، يرجى الاتصال بالسيد احمد حسين [NAME] التالي:
 |  |  |  |  |  |  | بريد الكتروني:[EMAIL]، هاتف: 978408-1-961 ، فاكس: 981510-1-961
 |  |  |  |  |  |  | او بالسيدة زينة سنو:[EMAIL]، هاتف: 978428-1-961 ، فاكس: 981510-1-961
 |  |  |  |  |  |  | [NAME] المعلومات التالية عن الشخص المسؤول عن استيفاء هذا الاستبيان
 |  |  |  |  |  |  | الاسم:
 |  |  |  |  |  |  | الوظيفة:
 |  |  |  |  |  |  | الادارة او القسم:
 |  |  |  |  |  |  | [NAME]:
 |  |  |  |  |  |  | العنوان:
 |  |  |  | [NAME]: |  |  | الهاتف:
 |  |  |  |  |  |  | البريد الالكتروني:
Spreadsheet: 775057d1648803917-search-headers-to-retrieve-totals-example-2-
Sheet: Report

PE ID 0125 | PE ID 0128 | PE ID 0124 | PE ID 0001 | TOTAL | PE ID 0010 | PE ID 0030 | PE ID 5420 | PE ID 0135
Example 1 | Example 2 | Example 3 | Example 4 | Example 4.4 | Example 5 | Example 6 | Example 7 | Example 8 | Example 9 | Example 10 | 0 | 0
10000 | 0 | 0 | 29723.87 | 0 | 500 | 3406.940000000001 | 11846.89 | 0 | 0 | 447.67
HMRC Rec
Example 1 | #N/A
Example 2 | 0
Example 3 | 0
Example 4 | 29723.87
Example 5 | 0
Example 6 | 500
Example 7 | 3406.940000000001
Example 8 | 11846.89
Example 9 | 0
 | #N/A
Spreadsheet: joe_parks__15047__BridgeDPR0612
Sheet: Bridgeline DPR2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRIDGELINE GAS MARKETING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD |  | Yesterday's MTD | Yesterday's QTD | Yesterday's YTD
BRIDGELINE GAS MARKETING
GAS TRADING |  |  | 15 Bcf |  |  |  |  |  |  | 2000
1 Month |  |  |  |  |  | 9 Bcf 1 Month
2-12 Months |  |  |  |  |  | 25 Bcf 2-12 Months
13-18 Months |  |  |  |  |  | 5 Bcf 13-18 Months
TOTAL TRADING
Notes to File
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTD | QTD | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA | 1440.571990399999 | 6595.571990399999 | 11886.5719904
 |  |  |  |  |  |  |  |  |  |  |  |  | GAS TRADING | 1440.571990399999 | 6595.571990399999 | 11886.5719904
 | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | -2243.48
 |  |  |  |  |  |  |  |  |  | 998027.0603850778
Spreadsheet: 718643d1613247241-sine-wave-variable-0-point-sinwave-shift-
Sheet: Sheet1

Lead/Lag | Ø shift
-1 | 30
Deg | Reference | Shifted
0
10
20
30
Spreadsheet: 68509d1269029311-finding-the-sum-while-matching-criteria-excel-forum-teams
Sheet: Sheet1

Date | Gender | Sport | # Players |  | Total # of Players
2010-03-01 00:00:00 | Male | Soccer | 15 |  | Male | Soccer | 52
2010-03-02 00:00:00 | Male | Soccer | 10 |  | Female | Soccer | 57
2010-03-03 00:00:00 | Female | Soccer | 11 |  | Male | Football | 55
2010-03-04 00:00:00 | Female | Baseball | 18 |  | Female | Football | 0
2010-03-05 00:00:00 | Male | Football | 10 |  | Female | Baseball | 57
2010-03-06 00:00:00 | Female | Soccer | 14 |  | Male | Baseball | 25
2010-03-07 00:00:00 | Male | Football | 19
2010-03-08 00:00:00 | Male | Football | 16
2010-03-09 00:00:00 | Male | Baseball | 13
2010-03-10 00:00:00 | Female | Baseball | 9
2010-03-11 00:00:00 | Female | Soccer | 14
2010-03-12 00:00:00 | Female | Soccer | 18
2010-03-13 00:00:00 | Female | Baseball | 12
2010-03-14 00:00:00 | Male | Football | 10
2010-03-15 00:00:00 | Male | Baseball | 12
2010-03-16 00:00:00 | Female | Baseball | 18
2010-03-17 00:00:00 | Male | Soccer | 11
2010-03-18 00:00:00 | Male | Soccer | 16
Finding the Sum while Matching Criteria - Excel Help Forum
Spreadsheet: ada6062b-c14d-4ab1-88f0-05cd1919433f
Sheet: KMF

ATTACHMENT 9 PRICE SCHEDULE
KEARNY MESA FACILITY (KMF)
 | Service Address:
 | Traffic & Small Claims Court
 | 8950 Clairemont Mesa Blvd
 | San Diego, CA 92123
 | MODEL | SERIAL # | [NAME] ID# | OLD ID # | PRICE Base Year | PRICE Year 1 | PRICE Year 2 | PRICE Year 3 | PRICE Year 4
1 | RAPIDPRINT ARL-E | 470280 | 2266 | 93137
2 | RAPIDPRINT ARC-E | 307775 | 2042 | 10676
3 | AMANO 4746 | 150633DP | 2265 | 90222
4 | AMANO 4746 | 151754DP | 2295 | 91065
5 | RAPIDPRINT ARL-E | 507783 | 2296 | 10464
6 | RAPIDPRINT ARL-E | 468809 | 2291
7 | RAPIDPRINT ARL-E | 468810 | 2293 | 90368
8 | RAPIDPRINT ARL-E | 470281 | 2292
9 | [NAME] | 523882 | 3610 | 20697
10 | WIDMER T-3 | 156386 | 2692 | 76450
11 | WHITAKER ET | 866963HG | 2693 | 90215
12 | [NAME]. | 866954HG | 2235 | 90494
13 | WHITAKER ET | 855858BF | 2162 | 91223
 |  |  | TOTAL *
 |  |  | * transfer these totals to summary sheet
Spreadsheet: 09490c8e-b9d1-4d84-bb1b-eb0c670225fa
Sheet: Sheet1

 | Kid Zone Nutrition Education Resource Credit
 | Some websites you can order items from include, but are not limited to:
 | www.pbhcatalog.com |  |  | www.enasco.com/nutrition
 | www.neatsolutions.com |  |  | www.usgames.com
 | www.lakeshorelearning.com |  |  | www.pwap.com |  | www.discountschoolsupply.com
Name: |  |  |  |  | School:
Phone: |  |  |  |  | [NAME]:
Item # | Item Name |  |  | website |  | unit price | Quantity | Total
 |  |  |  |  |  | Grand Total
Briefly explain how the materials purchased will be used to incorporate nutrition into your classroom
curriculum.  Materials purchased must have a nutrition focus to be allowable under grant rules.
If you have any questions or concerns, please contact:
[NAME] |  |  |  | [NAME]
[PHONE] |  |  |  | [PHONE]
[EMAIL] |  |  |  | [EMAIL]
Spreadsheet: 69939d1270592809-auto-filling-information-expense-report-02
Sheet: Expense Report

 |  | Credit Card Expense Report |  |  | Name
 |  |  |  | [NAME] for the Month of
 |  |  |  | GL |  | Cost Center |  | Co
*Date | *Asset # | *Description of Expense |  | Account | *Amount | *Yard | Dept | Code
 |  |  | Subtotal |  | 0
 |  |  | Total Expenses from Additional Pages |  | 0
Total Expenses |  |  |  |  | 0
Credit Card Statement Balance
*Cardholder’s Signature |  |  | Manager[NAME]
Name |  | Date | Manager |  | Manager’s Signature |  |  | Date
Print, Sign & Submit for Approval . . .
Spreadsheet: 719273d1613581891-seach-for-specific-text-and-return-results-search-and-return-forum
Sheet: Sheet1

CPT® Codes | PR Code
PR FRAGMENT KIDNEY STONE/ ESWL [50590] CHG RADIOLOGIC EXAM ABDOMEN 1 VIEW [74018] ASSAY QUANTITATIVE,BLOOD GLUCOSE [82947]
PR INSERT,INFLATABLE PENILE PROSTHESIS [54405] ASSAY QUANTITATIVE,BLOOD GLUCOSE [82947] PR Cath, drainage [C1729] PR Prosthesis, penile, inflatab [C1813]
PR INSERT,INFLATABLE PENILE PROSTHESIS [54405] ASSAY OF CREATININE [82565] CHG ASSAY OF SERUM POTASSIUM [84132] CHG HEMATOCRIT [85014] CHG HEMOGLOBIN [85018] PR ELECTROCARDIOGRAM, TRACING [93005] PR Cath, drainage [C1729] PR Prosthesis, penile, inflatab [C1813]
PR COLLECTION VENOUS BLOOD,VENIPUNCTURE [36415] CHG CT SCAN,ABDOMENT AND PELVIS,W/O CONTRAST [74176] CHG BASIC METABOLIC PANEL CALCIUM TOTAL [80048] CHG METABOLIC PANEL,COMPREHENSIVE [80053] CHG URINALYSIS, AUTO, W/SCOPE [81001] ASSAY OF LIPASE [83690] ASSAY OF MAGNESIUM [83735] CHG COMPLETE CBC & AUTO DIFF WBC [85025] CHG PROTHROMBIN TIME [85610] CHG THROMBOPLAS TIME PARTIAL [85730] CHG URINE CULTURE, COLONY COUNT [87086] PR IV INFUSION, HYDRATION, EA ADD HOUR [96361] PR INJECTION,THERAP/PROPH/DIAGNOST, IV PUSH, INITIAL DRUG [96374] PR INJECTION,THERAP/PROPH/DIAGNOST, IV PUSH, EA ADD, SAME DRUG [96376] PR PHYSICAL THERAPY EVALUATION LOW COMPLEX 20 MINS [97161] PR OCCUPATIONAL THERAPY EVAL MOD COMPLEX 45 MINS [97166] PR EMERGENCY DEPT VISIT HIGH SEVERITY & THREAT TO FUNCTION [99285] PR Stent, non-cor, tem w/o del [C2617]
PR CYSTO/URETERO/PYELOSCOPY, CALCULUS TX [52352] CHG CALCULUS ASSAY,INFRARED SPECTR [82365] PR Guide wire [C1769]
PR TRANSURETHRAL ELEC-SURG PROSTATECTOM [52601] ASSAY OF CREATININE [82565] CHG ASSAY OF SERUM POTASSIUM [84132] CHG HEMATOCRIT [85014] CHG HEMOGLOBIN [85018] CHG RBC ANTIBODY SCREEN [86850] CHG BLOOD TYPING SEROLOGIC ABO [86900] CHG BLOOD TYPING SEROLOGIC RH (D) [86901] CHG SURG PATH,LEVEL IV [88305] PR ELECTROCARDIOGRAM, TRACING [93005]
PR INSERTION PICC W/O IMG GDN 5 YR/> [36569] PR US GUIDE, VASCULAR ACCESS [76937] CHG BASIC METABOLIC PANEL CALCIUM TOTAL [80048] ASSAY OF GENTAMICIN [80170] ASSAY OF LACTIC ACID [83605] CHG COMPLETE CBC & AUTO DIFF WBC [85025] CHG PROTHROMBIN TIME [85610] CHG BLOOD CULTURE FOR BACTERIA [87040] CHG BACTERIA IDENTIFICATION, AEROBIC ISOLATE [87077] CHG ANTIBIOTIC SENS,MIC,EACH [87186] CHG IAAD IA HIV-1 AG W/HIV-1 & HIV-2 ANTBDY SINGLE [87389] CHG SURG PATH,LEVEL IV [88305] CHG IMHISTOCHEM/CYTCHM EA MULTIPLEX ANTIBODY SLIDE [88344] PR CHEST WALL MANIPULATION,INITIAL [94667] PR CHEST WALL MANIPULATION,SUBSEQUENT [94668] PR [NAME], inf, per/cent/midline [C1751]
PR INSTILL ANTICANCER AGENT IN BLADDER [51720] PR CYSTOURETHROSCOPY,FULGUR 2-5CM LESN [52235] ASSAY OF CREATININE [82565] CHG ASSAY OF SERUM POTASSIUM [84132] CHG HEMATOCRIT [85014] CHG SURG PATH,LEVEL V [88307] PR ELECTROCARDIOGRAM, TRACING [93005] PR Cath, drainage [C1729]
HC PROSTHETIC IMPLANT, NOS [27800081]
Spreadsheet: 376b03e6-c9a5-4014-9adf-13fe3b4d7896
Sheet: 2x down

Locus Tag | Our data (>2x) | [NAME] (>1.5x)
[NAME] | 14.47838192120133 | 1.95054712846954
BSU02700 | 6.77367801800245 | 3.02053966975433
BSU02780 | 32.77618831308175 | 1.8748711026117
BSU07380 | 2.23319639780385 | 1.52884159672216
BSU09890 | 4.999868887152217 | 1.63536754885661
BSU10770 | 3.99511822872298 | 2.6054558244965
BSU12180 | 35.40521408597068 | 2.0664714999139
BSU12190 | 4.225089763176434 | 1.90677158147635
[NAME] | 5.152248471358235 | 1.6831805379445
BSU14340 | 2.652806112445259 | 1.95897898015554
BSU14350 | 3.512074632537794 | 2.30306845487137
BSU14890 | 2.024308011652256 | 2.3095755000231
BSU16660 | 2.280686638082949 | 1.5828044128587
BSU16960 | 50.00674803622476 | 13.1769666622743
BSU17610 | 2.397395930591188 | 39.6982929734021
BSU18840 | 3.095858191778017 | 1.57492715961887
BSU20420 | 2.44624006942272 | 1.52201596087404
BSU21460 | 7.277823706424269 | 3.15885902012193
BSU21470 | 10.87236233724016 | 3.01428772381086
[NAME] | 17.51453164606136 | 1.81325854649195
[NAME] | 6.186749509988719 | 1.65795320150763
BSU21620 | 4.556357328008096 | 1.61917972355205
BSU24620 | 2.713071014284175 | 3.55252406835056
BSU25050 | 7.609066210943406 | 1.53146392636721
[NAME] | 2.491326200752639 | 1.94405023425805
[NAME] | 3.254267869813235 | 2.04503159573815
[NAME] | 3.554119070588614 | 1.9388988347218
BSU30750 | 4.273980619011294 | 1.4552016181842
BSU31080 | 4.906757306189609 | 2.30581218391158
BSU31890 | 2.963363086769216 | 1.78600132164098
BSU33280 | 2.843652643965906 | 1.53435419032129
BSU34010 | 2.27063097614039 | 1.50855349833556
BSU34020 | 5.236007043132149 | 1.53590170229105
BSU34430 | 2.241093619612784 | 1.67302415846885
BSU37460 | 6.39614970272962 | 2.0726677306361
BSU37470 | 4.325990411555096 | 1.8153213118722
BSU38850 | 4.161186852672589 | 1.67749583421868
[NAME] | 2.991193679696061 | 1.67336944092727
BSU39610 | 7.616089953142668 | 1.80354577098576
BSU39940 | 2.447765079802967 | 2.08178645034592
BSU40590 | 2.716774462357919 | 2.00533418894259
[NAME] | 2.971315394177481 | 2.11429900416517
BSU40610 | 2.678712364373058 | 1.96163050727765
BSU40620 | 2.761239693204387 | 1.62241090260127
Spreadsheet: 809564d1671153870-replace-text-in-a-formula-with-a-text-from-another-column-book1
Sheet: Sheet1

Description | Title
 | Activity 1 - Work Task 1
 | Activity 2 - Work Task 1
 | Activity 3 - Work Task 1
 | Activity 4 - Work Task 1
 | Activity 5 - Work Task 1
 | Activity 6 - Work Task 1
 | Activity 7 - Work Task 1
 | Activity 8 - Work Task 1
 | Activity 9 - Work Task 1
 | Activity 10 - Work Task 1
 | Activity 11 - Work Task 1
 | Activity 12 - Work Task 1
How to replace text "XXX" in each formula in Column A with a corresponding text from Column B to extract cells D17 and [NAME] from different files
Spreadsheet: 773194d1647685166-extract-from-vertical-list-excluding-blank-and-duplicates-extract-from-vertical-list-excluding-blank-and-duplicates
Sheet: Sheet1

 |  |  | Parts |  |  |  | Parts added |  | Parts | Parts added
 |  |  |  |  |  |  |  |  |  |  |  | Hello
 |  |  | 1234-abcgd |  |  |  |  |  |  |  |  | From the Parts column cells (D6:D45) need to extract the by eliminating the blank cells and duplicates and need to plot in light yellow cells by formula.
 |  |  |  |  |  |  | abcd-123451234-56789
 |  |  |  |  |  |  | abcd-123451234-56789 |  |  |  |  | Similarly the Parts added column cells (K6:K45) need to extract the by eliminating the blank cells and duplicates and need to plot in light yellow cells by formula.
 |  |  |  |  |  |  | abcd-123451234-56789
 |  |  |  |  |  |  |  |  |  |  |  | Thanks in Advance
 |  |  | 1234-abcgd
 |  |  |  |  |  |  |  |  |  |  |  | Sekar
 |  |  |  |  |  |  | 1234-abcdeabcd-12345
 |  |  |  |  |  |  | xyza-123451234-12345
 |  |  | 2345-ABCDE
 |  |  | 2345-ABCDE
 |  |  |  |  |  |  | xyza-123451234-12345
 |  |  | 7231-ABCDR
 |  |  | 1219-12345
 |  |  |  |  |  |  | abcd-111231234-12345
 |  |  |  |  |  |  | abcd-111231234-12346
 |  |  |  |  |  |  | abcd-111231234-12348
 |  |  | 2345-ABCDE
 |  |  | 1219-12345
 |  |  | 1219-12345
 |  |  | 2345-XABCD
 |  |  |  |  |  |  | xyuz-12345abcd-1234
Spreadsheet: 853969d1703925295-stack-gradually-spilling-array-stack
Sheet: Feuil1

LIST |  | list |  |  |  | expected result
AB-100 |  |  |  |  |  | AB
AB-100-X |  | AB-100-X |  |  |  | AB-100 |  | AB-100
AB-100-Y |  | AB-100-Y |  |  |  | AB |  | AB
AB-100-Y-1 |  | AB-100-Y-1 |  |  |  | AB-100 |  | AB-100
AB-100-Y-2 |  | AB-100-Y-2 |  |  |  | AB-100-X |  | AB-100-X
 |  |  |  |  |  | AB |  | AB
 |  |  |  |  |  | AB-100 |  | AB-100
 |  |  |  |  |  | AB-100-Y |  | AB-100-Y
 |  |  |  |  |  | AB |  | AB
 |  |  |  |  |  | AB-100 |  | AB-100
 |  |  |  |  |  | AB-100-Y |  | AB-100-Y
 |  |  |  |  |  | AB-100-Y-1 |  | AB-100-Y-1
 |  |  |  |  |  | AB |  | AB
 |  |  |  |  |  | AB-100 |  | AB-100
 |  |  |  |  |  | AB-100-Y |  | AB-100-Y
 |  |  |  |  |  | AB-100-Y-2 |  | AB-100-Y-2
Spreadsheet: andy_zipper__173__DYNEGY-ICE VOL Apr19
Sheet: ICE-ENA

Enron North America
Activity on ICE
UOM | Deals | Volume
MMBtus
bbl
 |  |  |  |  |  |  | START | END
Enron North America Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-19-01 thru Apr-19-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Apr-19-01 | 856947017 |  | Sold | NG Fin BS, LD1 for IF | Perm | [NAME] | May-01-01 | Oct-31-01 |  |  |  | AEP Energy Services, Inc. | 0.085 | USD / MMBtu | 5000 | Daily | 920000 | MMBtus | [NAME], G
Apr-19-01 | 331238910 |  | Sold | NG Fin, FP for LD1 | [NAME] | Cal 03 | Jan-01-03 | Dec-31-03 |  |  |  | AEP Energy Services, Inc. | 4.305 | USD / MMBtu | 5000 | Daily | 1825000 | MMBtus | [NAME], J
Apr-19-01  Deals
Spreadsheet: 121030d1315777149-populating-a-new-grid-matrix-from-multiple-min-max-numbers-example
Sheet: Sheet1

Sample data entered below:
Date | Category | From | To | Total | Category | From | To | Total | Category | From | To | Total | Category | From | To | Total
2011-09-01 00:00:00 | A | 1001 | 1010 |  | A | 1020 | 1034 |  | B | 1005 | 1009
2011-09-02 00:00:00 | A | 1011 | 1018 |  | B | 1029 | 1010
Gride based from data above: |  |  |  |  | In real spreadsheet, above data is on separate worksheet to the grid due to amount of information.
 | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | …400
1001 | 1001
1002 | 1002
1003 | 1003
1004 | 1004
1005 | 1005 | 1005
1006 | 1006 | 1006
1007 | 1007 | 1007
1008 | 1008 | 1008
1009 | 1009 | 1009
1010 | 1010 | 1010
1011 | 1011 | 1011
1012 | 1012 | 1012
1013 | 1013 | 1013
1014 | 1014 | 1014
1015 | 1015 | 1015
1016 | 1016 | 1016
1017 | 1017 | 1017
1018 | 1018 | 1018
1019 |  | 1019
1020 | 1020 | 1020
1021 | 1021 | 1021
1022 | 1022 | 1022
1023 | 1023 | 1023
1024 | 1024 | 1024
1025 | 1025 | 1025
1026 | 1026 | 1026
1027 | 1027 | 1027
1028 | 1028 | 1028
1029 | 1029 | 1029
1030 | 1030
1031 | 1031
1032 | 1032
1033 | 1033
1034 | 1034
…6000+
Spreadsheet: 196074d1353836703-autofilter-filter-containing-values-based-on-entries-of-table-list-in-a-sheet-advfiltermacro
Sheet: sheet3

address
*grange*
*freemount*
*smith*
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
Spreadsheet: 136517d1326705365-separate-column-into-more-columns-dependant-on-adjacent-value-scoredemo
Sheet: Sheet1

name | score | age group
[NAME] | 42 | A |  |  | [NAME] | 42 |  | [NAME] | 40
[NAME] | 40 | B | sort to this--> |  | ringo | 34 |  | george | 37
george | 37 | B
ringo | 34 | A
Spreadsheet: 101548d1299660212-data-compilation-sales-calculator-2010
Sheet: Plan Units

Retail Sales Targets
 | Quarter 2 |  |  | Quarter 3 |  |  | Quarter 4 |  |  | Quarter 1
 | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Total
Column | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
New | 4 | 4 | 4 | 4 | 3 | 10 | 5 | 4 | 4 | 5 | 3 | 10 | 60
Used | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 72
Total | 10 | 10 | 10 | 10 | 9 | 16 | 11 | 10 | 10 | 11 | 9 | 16 | 132
0.8 | 8 | 8 | 8 | 8 | 7 | 13 | 9 | 8 | 8 | 9 | 7 | 13 | 106
1 | 10 | 10 | 10 | 10 | 9 | 16 | 11 | 10 | 10 | 11 | 9 | 16 | 132
1.2 | 12 | 12 | 12 | 12 | 11 | 19 | 13 | 12 | 12 | 13 | 11 | 19 | 158
Spreadsheet: b22b5aa5-2ecd-49fb-b9e5-cb8c9c60139b
Sheet: Sheet1

Unnamed: 0 | METEO E CLIMA: SERIE STORICA 1993-2005 NEL COMUNE DI VENEZIA | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Temperatura media (°C) | Pressione media (hPa) | Direzione media del vento (Gradi) | Velocità media del vento (m/s) | Irraggiamento medio (kJ/m2) | Pioggia media (mm/ora) | Umidità media(%) |  | Glossario
1993 | 13.71424155695479 | 1016.33774470521 | 121.020377790498 | 2.423251287922157 | 529.1832856325129 | [NAME] | n.p
1994 | 14.7555771206759 | 1015.969699737413 | 125.9917798835483 | 2.346866080602812 | 513.159835597671 | [NAME] | n.p
1995 | 14.03656156156152 | 1016.192379879884 | 114.6681681681682 | 2.1069069069069 | 561.4637137137137 | [NAME] | n.p
1996 | 13.46822632058289 | 1016.122768670307 | 110.8682832422587 | 2.248565573770493 | 627.0837887067395 | [NAME] | n.p
1997 | 14.15348784107776 | 1018.819602694371 | 121.5815732389542 | 2.154401187350147 | 560.9552460326521 | [NAME] | n.p
1998 | 14.03064976590155 | 1017.832819458724 | 119.2374100719424 | 2.100513874614596 | 638.3540696854282 | 0.01702637889688248 | n.p
1999 | 14.18052220538527 | 1014.248059360733 | 131.3441780821918 | 2.258378995433788 | 552.9 | 0.02735159817351596 | n.p
2000 | 14.76150956284147 | 1014.889902094716 | 134.5215163934426 | 2.307707194899814 | 526.9098360655738 | 0.07971652003910082 | n.p
2001 | 14.38844748858449 | 1012.13397260274 | 129.1 | 2.256198630136988 | 532.2722602739726 | 0.07203196347031973 | n.p
2002 | 14.65105022831054 | 1011.924965753428 | 124.3845890410959 | 2.345559360730594 | 619.6284246575342 | 0.1024885844748861 | 77.10356164383568
2003 | 14.80634703196345 | 1012.361084474883 | 119.8780821917808 | 2.45900684931506 | 569.5095890410959 | 0.06091324200913229 | 67.25728310502296
2004 | 13.96174605005193 | 1018.783048060198 | 139.9593949970913 | 2.339141967477801 | 515.7225507246377 | 0.09929650559335736 | 73.57527390151085
2005 | 13.29945328635646 | 1016.887422853845 | 167.656785323776 | 2.345389381606138 | 388.2294982383672 | 0.07481472482079941 | 65.59199368242002
Fonte: Istituto di Scienze Marine/Biologia del Mare, CNR, Venezia
Elaborazioni: Servizio Statistica e Ricerca - Comune di Venezia