tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: andy_zipper__171__DYNEGY-ICE VOL Apr18
Sheet: Enron Activity-ICE

ICE
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Enron North America - ICE |  |  |  |  |  | Enron Power Marketing - ICE |  |  |  |  |  | Enron Canada Corp - ICE
ICE GAS VOLUME: |  | ENRON PERCENTAGE: |  |  |  | ICE POWER VOLUME: |  |  | ENRON PERCENTAGE:
 |  |  | Data |  |  |  |  |  | Data |  |  | No Activity
Trader | Product | Qty Units | Transactions | Volume |  | Trader | Product | Qty Units | Transactions | Volume
[NAME], G | NG Fin BS, LD1 for IF | MMBtus | 2 | 620000 |  | Dorland , C | Firm-LD Peak | MWhs | 4 | 20000
Grand Total |  |  | 2 | 620000 |  | [NAME], R | Firm-LD Peak | MWhs | 7 | 224800
 |  |  |  |  |  | Grand Total |  |  | 11 | 244800
Spreadsheet: 164513d1340802173-hide-zero-values-plotted-on-a-line-graph-graph
Sheet: Sheet1

 |  | 2012 - Q2 | WW
 |  | Week | Mktg | Sales |  | Mktg | Sales
 | 1 | -13 | 0 | 0
 | 2 | -12 | 0 | 0
 | 3 | -11 | 0 | 0
 | 4 | -10 | 0 | 0
 | 5 | -9 | 0 | 0
 | 6 | -8 | 0 | 0
 | 7 | -7 | 0 | 0
 | 8 | -6 | 0 | 0
 | 9 | -5 | 0 | 0
 | 10 | -4 | 0 | 0
 | 11 | -3 | 0 | 0
 | 12 | -2 | 0 | 0
 | 13 | -1 | 0 | 80.68364000000008
 | 14 | 1 | 0 | 84.40166000000006
 | 15 | 2 | 0 | 86.00338000000004
 | 16 | 3 | 0 | 101.28982
 | 17 | 4 | 0 | 126.3341700000001
 | 18 | 5 | 0 | 151.29609
 | 19 | 6 | 0 | 213.7045399999995
 | 20 | 7 | 0 | 221.9793199999999
 | 21 | 8 | 77.35959 | 231.8595399999996
 | 22 | 9 | 89.03011 | 217.0986999999997
 | 23 | 10 | 84.45731999999997 | 199.0752499999996
 | 24 | 11 | 74.38253999999999 | 156.0254999999999
 | 25 | 12 | 55.95049999999997 | 96.92682000000008
 | 26 | 13 | 0 | 0
Spreadsheet: 96230d1295631882-how-to-create-simple-graphic-my-file-1-
Sheet: Sheet1

 | Date | Bank | Daily Points | Cumulative Points
 | 2011-01-03 00:00:00 |  | 7.35 |  | 45
 | 2011-01-04 00:00:00 | 100 | -0.02
 | 2011-01-04 00:00:00 | 100 | 0.5
 | 2011-01-04 00:00:00 | 100 | 4 |  | 25
 | 2011-01-05 00:00:00 | 100 | -10.32
 | 2011-01-05 00:00:00 | 100 | -7.5
 | 2011-01-05 00:00:00 | 100 | 0.96
 | 2011-01-05 00:00:00 | 100 | 1.14 |  | 8
 | 2011-01-05 00:00:00 | 100 | 2.2
 | 2011-01-05 00:00:00 | 100 | 3.61 |  | 30
 | 2011-01-05 00:00:00 | 100 | 3.74 |  | 30
 | 2011-01-05 00:00:00 | 100 | 5.87
 | 2011-01-05 00:00:00 | 100 | 6
 | 2011-01-06 00:00:00 | 100 | 3.9
 | 2011-01-06 00:00:00 | 100 | 6
 | 2011-01-06 00:00:00 | 100 | 6.87
 | 2011-01-08 00:00:00 | 100 | 1.76
 | 2011-01-08 00:00:00 | 100 | 2.2
 | 2011-01-08 00:00:00 | 100 | 2.5
 | 2011-01-08 00:00:00 | 100 | 4.4
 | 2011-01-08 00:00:00 | 100 | 4.7
 | 2011-01-10 00:00:00 | 100 | 3.79
 | 2011-01-10 00:00:00 | 100 | 4.78
 | 2011-01-10 00:00:00 | 100 | 10.44
 | 2011-01-11 00:00:00 | 100 | -0.58
 | 2011-01-11 00:00:00 | 100 | 0.47
 | 2011-01-11 00:00:00 | 100 | 0.76
 | 2011-01-11 00:00:00 | 100 | 6.8
 | 2011-01-11 00:00:00 | 100 | 9.92
 | 2011-01-11 00:00:00 | 100 | 9.99
 | 2011-01-13 00:00:00 | 100 | 4.03
 | 2011-01-13 00:00:00 | 100 | 6.43
 | 2011-01-13 00:00:00 | 100 | 7
Spreadsheet: 769465d1645548907-increment-with-exclude-array-list-criteria-for-every-nth-duplicate-increment-with-exclude-criteria-for-every-nth-duplicate
Sheet: Sheet1

[NAME] | Year | Year to Use (Desired Result) | Project Code |  | # of duplicate before increment |  |  |  | DB Code | [NAME] |  | Unique Value
CLA1Dummy | 2022 | #N/A | CLA |  | 2 |  |  |  | CLA1FOXB | CLA1Dummy
CLA1Dummy | 2022 | #N/A | CLA |  |  |  |  |  | CLA1FOXB | CLA1Dummy |  | CLA2Dummy
CLA1Dummy | 2022 | #N/A | CLA |  |  |  |  |  | CLASITE
CLA2Dummy | 2023 | #N/A | CLA |  |  |  |  |  | CLASITE
CLA2Dummy | 2023 | #N/A | CLA |  |  |  |  |  | CLASITE
CLA2Dummy | 2023 | #N/A | CLA |  |  |  |  |  | CLAPHASE2 | CLA2Dummy
CLA3Dummy | 2024 | 2024 | CLA |  |  |  |  |  | CLAPHASE2 | CLA2Dummy
CLA3Dummy | 2024 | 2024 | CLA |  |  |  |  |  | CLAPHASE2 | CLA2Dummy
CLA3Dummy | 2024 | 2025 | CLA
CLA4Dummy | 2025 | 2025 | CLA
CLA4Dummy | 2025 | 2026 | CLA
CLA4Dummy | 2025 | 2026 | CLA
Spreadsheet: 141420d1329253816-counting-unique-values-with-multiple-criteria-book2
Sheet: Sheet4

Status | Data Entered | OEM Name | Teams | Company ID
PO | PRE | 1 | LOB | 55
NS | POST | 5 | Tournoux | 66 |  | Team  by OEM | PRE | post
RTN | PRE | 6 | Balsdeasari | 55 |  | LOB | Unique Company IDS | Unique Company IDS
NS | POST | 9 | LOB | 88 |  | 1
PO | PRE | 8 | Tournoux | 99 |  | 2
NS | POST | 7 | Balsdeasari | 2 |  | 7
RTN | POST | 4 | LOB | 8 |  | 9
NS | PRE | 1 | Tournoux | 4 |  | 8
PO | POST | 3 | Balsdeasari | 9 |  | 11
NS | PRE | 10 | LOB | 17 |  | 3
RTN | POST | 11 | Tournoux | 1458 |  | Tournoux | Unique Company IDS | Unique Company IDS
NS | POST | 2 | Balsdeasari | 9 |  | 1
PO | PRE | 6 | Balsdeasari | 407.69696969697 |  | 2
NS | POST | 6.46153846153846 | LOB | 446.445221445222 |  | 7
RTN | PRE | 6.58241758241758 | Tournoux | 485.193473193474 |  | 9
NS | POST | 6.70329670329671 | Balsdeasari | 523.941724941725 |  | 8
PO | POST | 6.82417582417583 | LOB | 562.689976689977 |  | 11
NS | PRE | 6.94505494505495 | Tournoux | 601.438228438229 |  | 3
RTN | POST | 7.06593406593407 | Balsdeasari | 640.186480186481 |  | Balsdeasari
NS | PRE | 7.18681318681319 | Balsdeasari | 678.934731934732 |  | 1
PO | POST | 7.30769230769231 | LOB | 717.682983682984 |  | 2
NS | POST | 7.42857142857143 | Tournoux | 756.431235431236 |  | 7
RTN | PRE | 7.54945054945055 | Balsdeasari | 795.179487179488 |  | 9
NS | POST | 7.67032967032967 | LOB | 833.927738927739 |  | 8
PO | PRE | 7.7912087912088 | Tournoux | 872.675990675991 |  | 11
NS | POST | 7.91208791208792 | Balsdeasari | 911.424242424243 |  | 3
RTN | POST | 8.03296703296704 | Balsdeasari | 950.172494172499
NS | PRE | 8.15384615384616 | LOB | 988.920745920749
PO | POST | 8.27472527472528 | Tournoux | 1027.668997669
NS | PRE | 8.3956043956044 | Balsdeasari | 1066.41724941725
RTN | POST | 8.51648351648352 | LOB | 1105.1655011655
NS | POST | 8.63736263736264 | Tournoux | 1143.91375291375
PO | PRE | 8.75824175824176 | Balsdeasari | 1182.66200466201 |  | * only if the status is in PO do I want to capture it
NS | POST | 8.87912087912088 | Balsdeasari | 1221.41025641026
RTN | PRE | 9.00000000000001 | LOB | 1260.15850815851
NS | POST | 9.12087912087913 | Tournoux | 1298.90675990676
PO | POST | 9.24175824175825 | Balsdeasari | 1337.65501165501
NS | PRE | 9.36263736263737 | LOB | 1376.40326340326
Spreadsheet: hunter_shively__12722__Fundamentals_Netco
Sheet: East Power Origination

 | East Power Origination
 | 2002 Plan
 |  |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  | % |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast | Plan |  | of Total |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  |  | Compensation | 0
 | Special Pays
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  |  | [NAME] | 33600 | 0
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  | [NAME] | 52800 | 0
ENARENT | Rent |  |  |  |  |  |  |  | Staff | 54000 | 0
ENATECH | Technology |  |  |  |  |  |  |  | Specialist | 63000 | 0
ENATRANS | Transportation |  |  |  |  |  |  |  | Sr. Specialist | 78000 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Analyst | 66000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  | Associate | 97200 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  | Manager | 120000 | 4
 |  |  |  |  |  |  |  |  | Director | 156000 | 7
 | Headcount |  |  |  |  |  |  |  | Sr. Director | 180000 | 0
 |  |  |  |  |  |  |  |  | VP | 216000 | 1
 | Analyst & Associate Headcount |  |  |  |  |  |  |  | MD | 240000
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 524067
 |  |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 01eccefb-8fbe-4f66-9450-c37e26ac28bd
Sheet: Sheet1

'[NAME] pajzsa' - levelező-pályázat | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Jelentkezési lap*
Az iskola neve:
Címe:
Telefonszáma: |  |  |  |  | Faxszáma:
A benevezett osztály száma és betűjele, vagy a szakkör/csoport megnevezése:
Létszáma:
A munkát irányító tanár neve:
E-mail címe:
Telefonszáma (otthoni vagy mobil):
Honnan értesültek a pályázatunkról?
Dátum: |  |  |  |  | Aláírás:
*Egy jelentkezési lapon több osztály jelentkezését csak akkor tudjuk elfogadni, ha a munkájukat ugyanaz a tanár irányítja. Ellenkező esetben kérjük, osztályonként külön jelentkezési lapot küldjenek be.
Spreadsheet: john_lavorato__16491__eesbid2
Sheet: OFF PEAK

OFF PEAK
 |  | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00
LT [NAME] | NP |  |  |  | 27 | 7 |  | 6 | 6 | 41
 | SP |  |  |  | 25 | 25 | 25 | 25 | 25 | 25 | 75 | 75 | 75
LT NW | NP |  |  |  |  |  |  | 75
 | SP |  |  |  |  | 50 | 50 | 100 | 100 | 100 | 50 | 50 | 50
LT SW | NP |  |  |  | 25 | 25 | 25
 | SP |  | 25 |  | 50 | 50 |  | 100 | 100 | 100 | 25 | 25 | 25
LT West Mgt | NP
 | SP
ST [NAME] | NP |  | 25
 | SP
ST NW | NP
 | SP
ST SW | NP
 | SP
WEST TOTAL | NP
 | SP
1/22 Curve | NP |  | 170 | 160 | 115 | 120 | 122 | 123 | 131 | 121 | 112 | 109 | 108
Offer | NP |  | 150 |  | 145 | 140 | 150 | 155 | 160 | 150
1/22 Curve | SP |  | 115 | 105 | 110 | 105 | 115 | 122 | 123 | 117 | 101 | 100 | 100
Offer | SP |  | 150 |  | 140 | 135 | 145 | 145 | 155 | 145 | 115 | 100 | 105
 | SP | -4051.89905355145 | 8300.3632934846 | 3308.95927065334 | 55069.9463356654 | 55415.1399381534 | 51977.6384131337 | 41938.9461579254 | 40565.6934011016 | 40989.3374497527 | 66001.2405011884 | 65163.3250162603 | 69656.9490271947
 | NP | 13519.1059278796 | -7772.69045453304 | -981.642844331407 | 13376.497620186 | 7271.5425111627 | 2333.90104654432 | 17309.6513078462 | 4785.78867606164 | 13150.1881582175 | -4773.50475392345 | -920.049182221941 | 3527.87469876165
 |  |  | 288 | 312 | 319 | 328 | 304 | 344 | 312 | 336 | 313 | 320 | 344
Current Pos. | SP
 | NP
new nw | SP |  |  |  |  |  |  | 75 | 75 | 75
 | NP
new sw | SP |  |  |  |  |  |  | 75 | 75 | 75
 | NP
Spreadsheet: 298158d1392726365-highlight-cells-on-sheet-1-if-the-text-is-also-on-sheet-2-examples
Sheet: Sheet1

Elegant Moments Hosiery Catalogue | [NAME]
Elegant Moments Hosiery Catalogue | [NAME]
Elegant Moments 2013 Costume | 2013EMCost
Elegant Moments 2013 Costume | 2013EMCost
70 Denier Opaque Tights | 70Den
70 Denier Opaque Tights | 70Den
70 Denier Opaque Tights | 70Den
70 Denier Opaque Tights | 70Den
Lace Open Back Panty | A-Abbigail
Lace Open Back Panty | A-Abbigail
Lace Open Back Panty | A-Abbigail
Lace Open Back Panty | A-Abbigail
Lace Open Back Panty | A-Abbigail
Lace Open Back Panty | A-Abbigail
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
Floral Lace French Knickers | A-Agnes
Floral Lace French Knickers | A-Agnes
Floral Lace French Knickers | A-Agnes
Floral Lace French Knickers | A-Agnes
Floral Lace French Knickers | A-Agnes
Floral Lace French Knickers | A-Agnes
Spreadsheet: cbdb9100-9dd3-4bb2-bcd2-384c66cb9e62
Sheet: Sheet1

Park Board Member - NON (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Downloaded at 5/24/2013 8:29:43 AM
Precincts Reporting: 505/505 - Total Ballots Cast: 102066
2010 Primary Election - OFFICIAL RESULTS
County | [NAME] | [NAME] | write-in | TOTALS
Griggs | 21 | 25 | 0 | 46
TOTAL | 21 | 25 | 0 | 46
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 826473d1682028074-pull-data-from-one-sheet-to-another-from-last-data-entered-in-a-column-and-the-12-24-above-ak-sample3
Sheet: COVER-12

 | ANIMAL KINGDOM |  |  |  |  |  | unlock 1111 |  |  |  |  |  |  | combo | Cover
Well No. | 12H | 13H | 14H | 15H | Total |  |  |  |  |  |  |  |  | combo
Start Date: |  |  |  |  |  |  |  |  |  |  |  |  |  | combo
Online/Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  | combo
Choke |  |  |  |  |  |  |  |  |  |  |  |  |  | lt f
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | lt p
Casing PSI |  |  |  |  |  |  | Copy and paste table into email body |  |  |  |  |  |  | fork
Surface Csg |  |  |  |  |  |  |  |  |  |  |  |  |  | lift
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | trash
Water / Day |  |  |  |  |  | Clear | enter water totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | ft
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | ft
Oil / Day |  |  |  |  |  |  | enter oil totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | plug C
[NAME] to sales |  |  |  |  |  |  |  |  |  |  |  |  |  | plug C
Gas / Day |  |  |  |  |  |  | enter gas totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | plug C
Inj / Day | off | off | off |  |  |  |  |  |  |  |  |  |  | st
 |  |  |  |  |  |  |  |  |  |  |  |  |  | st
Yesterday Lact |  |  |  |  |  |  |  |  |  |  |  |  |  | st
Notes: | Hello how are you? Oh Im doing ok. XXXX OPEN WELL XX/128  S/I XXXX psi. Going to the store, |  |  |  |  |  | gfhghcghghgvhvgvgvhgvhvghvgvgh
 | PM
 | 12H | 13H | 14H | 15H
GAS
WATER
OIL
 | AM |  |  |  |  |  | lact total
 | 12H | 13H | 14H | 15H |  |  | 0430 | 24 b4 |  |  |  |  | IF(g28-h28<0,0,g28-h28)
GAS |  |  |  |  |  | 750 |  | 118029
WATER |  |  |  |  |  | 760
OIL |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | 0
Spreadsheet: 61689d1262626889-excel-2007-time-calculation-tidrapport
Sheet: Jan2010

Närvaro och övertidsrapport
 |  | Månad: |  |  | År:
Namn: |  |  |  | Personnr:
Funktion: |  |  |  | Anst. Nummer:
Datum | [NAME] | [NAME] | [NAME] | Totala Timmar | OB | mertid | enkel        ö-tid | [NAME]
2010-01-01 00:00:00 | 23:30:00 | 08:00:00 | 00:30:00
 | 01:30:00 | 09:00:00 | 00:30:00
Total
Jag vill har min övertid i: |  |  |  | [NAME] |  | X | [NAME]
Signatur: _______________________________   Datum:_______________
[NAME]:________________________________________________
Enkel ö-tid: vardag fram till kl 20:00
Kval ö-tid: vardag från kl 20:00 till 06:00 och från fredag kl 20:00 till måndag kl 06:00
Spreadsheet: 87958d5a-0fa2-49b1-b349-ad772ed1af1c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Manutenzione delle strade nazionali
 |  |  |  |  |  |  |  |  |  | [NAME] d'imputazione/Modif. d'imputation |  |  |  |  |  |  |  |  |  |  |  | Entretien des routes nationales
 |  |  |  |  |  |  |  |  |  | *Segnare quello che conv./Cocher ce qui convient
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]No d'ordonnance |  |  | Pezza giust. [NAME] justif. no |  | Anno / Année
 |  | Canton/e: | …..
Annullazione d'imputazione erronea / Annulation de l'imputation antérieure |  |  |  |  |  |  |  |  |  |  |  |  |  | Imputazione corretta / Nouvelle imputation
Cantone             Canton | Strada naz.               Route Nat. | Misura no                         Mesure no | N. di manut. |  |  |  |  | Settore            Section | Centro di costi         Centre de              charges | [NAME] d'imputazione      Unité d'imputation | Montante / Montant (Fr. / Rp.) |  |  | Cantone             Canton | Strada naz.               Route Nat. | Misura no                         Mesure no | N. di manut. |  |  |  |  | Settore            Section | Centro di costi         Centre de              charges | [NAME] d'imputazione      Unité d'imputation | Montante / Montant (Fr. / Rp.)
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Distribuzione / Distribution: |  |  |  | Motivo / Motif du transfert: |  |  |  |  |  |  |  |  |  |  |  | Data / Date: |  |  |  |  |  | Timbro e firma Cantone / Timbre et signature du canton:
1 copia USTRA
1 copia Ct.
 |  |  |  | Aggiungere una fotocopia della pezza giust. alla base della modifica d'imputazione!
 |  |  |  | [NAME] une [NAME] pièce justificative ayant fait l'objet d'une modification d'imputation!
Spreadsheet: 683650d1592865941-for-each-code-i-want-to-rank-the-outlet-by-qty-sold-largest-to-smallest-excel-forum-help
Sheet: Sheet1

FOR EACH CODE, I WANT TO RANK THE OUTLET BY QTY SOLD (LARGEST TO SMALLEST)
CODE | [NAME] | COLOUR | OUTLET | QTY SOLD |  | 1 | 2 | 3 | 4 | 5
DP0003AA000 | BAG | BLACK | A | 3 |  | ? | ? | ? | ? | ?
DP0003AA000 | BAG | BLACK | B | 4
DP0003AA000 | BAG | BLACK | C | 5
DP0004AA000 | WALLET | CORAL | A | 2
DP0004AA000 | WALLET | CORAL | B | 2
DP0004AA000 | WALLET | CORAL | C | 6
DP0004AA000 | WALLET | CORAL | D | 7
DP0008BA000 | BAG | WHITE | A | 12
DP0008BA000 | BAG | WHITE | B | 5
DP0008BA000 | BAG | WHITE | C | 3
DP0008BA000 | BAG | WHITE | D | 4
DP0008BA000 | BAG | WHITE | E | 8
DP0008BA000 | BAG | WHITE | F | 2
DP0008BA000 | BAG | WHITE | G | 1
DP0009AA000 | BAG | SILVER | A | 18
DP0009AA000 | BAG | SILVER | B | 22
DP0009AA000 | BAG | SILVER | C | 15
DP0009AA000 | BAG | SILVER | D | 13
DP0009AA000 | BAG | SILVER | E | 8
DP0009AA000 | BAG | SILVER | F | 9
DP0014BA000 | SCARF | RED | A | 12
DP0014CA000 | WALLET | YELLOW | A | 1
DP0014CA000 | WALLET | YELLOW | B | 3
DP0014CA000 | WALLET | YELLOW | C | 6
DP0014CA000 | WALLET | YELLOW | D | 4
DP0016BA000 | BAG | BLUE | A | 9
DP0016BA000 | BAG | BLUE | B | 15
DP0016BA000 | BAG | BLUE | C | 6
DP0016BA000 | BAG | BLUE | D | 18
DP0016BA000 | BAG | BLUE | E | 4
DP0016BA000 | BAG | BLUE | F | 1
DP0016BA000 | BAG | BLUE | G | 0
DP0017AA000 | SCARF | BLACK | A | 5
DP0017AA000 | SCARF | BLACK | B | 25
DP0017AA000 | SCARF | BLACK | C | 28
DP0017AA000 | SCARF | BLACK | D | 3
DP0017AA000 | SCARF | BLACK | E | 15
DP0018AA000 | BAG | GOLD | A | 7
DP0018AA000 | BAG | GOLD | B | 9
DP0018AA000 | BAG | GOLD | C | 14
DP0018AA000 | BAG | GOLD | D | 13
DP0018AA000 | BAG | GOLD | E | 17
DP0018AA000 | BAG | GOLD | F | 3
DP0018AA000 | BAG | GOLD | G | 2
Spreadsheet: 176599d1345963351-tidy-up-printed-invoice-factuur_excel-forum
Sheet: Factuur

Factuur nummer | Klantnummer | Datum | Omschrijving | BTW | Bedrag | Stuk nummer | Datum nummer | [NAME] | Verval datum | Factuur bedrag | BTW bedrag | Totaal bedrag
 | 246 | 2012-07-02 00:00:00 | [NAME] | 0.19 | 150 | 2
Spreadsheet: 848370d1699091188-separation-digits-mappe2
Sheet: Tabelle2 (2)

7.1.2 Helferstunden
2.2.89 Zulage Geotextilunterlage
3.1.10
3.1.7
3.1.8
3.1.9
4.1.1
4.1.10 Leerrohre DN 100
4.1.13 Leerrohrgraben (Maschinenaushub)
4.1.11 Leerrohre DN 150
4937FXLEI0 TDo 4.1.1
4937FXLEI0 TDo 4.1.8 Schotter für Ausbes
4937FXLEI0 TDo 7.1.2 Helferstunden
Spreadsheet: 679460d1590430255-updating-report-example
Sheet: New Data for week 3

Order | Country | Manager | Value
100 | USA | [NAME] | 500
101 | CHINA | [NAME] | 30
102 | CHINA | [NAME] | 400
104 | USA | [NAME] | 50
105 | CHINA | [NAME] | 200
Spreadsheet: 717366d1612613457-extract-values-into-column-a-to-column-i-of-sheet-named-here-ignoring-blanks-schedule_sample_extractvalues_2
Sheet: Sheet1

Name | Area | Area Time | Local Time | GPS | Letter | District Name | Distance | Status
Spreadsheet: 819667d1677624273-countif-mm-yy-with-conditions-workload-wip-test-02282023
Sheet: PM WorkLoad

 |  |  |  |  | Formula 1 | Formula 2
 |  |  |  | 2023 TMD Completions |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024 TMD Completions
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 |  |  | 0 | 1 | 3 | 0 | 1 | 4 | 2 | 0 | 0 | 0 | 0 | 3
 |  | Program Managers | [blank] | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 |  | [blank] | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00
 |  | Test, Test1 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] should return | 1 | 0 | 0 | 6 | 4 | 2 | 2 | 0 | 0 | 2 | 2 | 3 | 1 |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 678421d1589885219-if-formular-with-multiple-conditions-test
Sheet: test

Type | [NAME] | Category | Avr cost (category)
None | 250
Standard | 500 | Standard
Type A | 550 | Category 1
Type B | 555 | Category 1
Type C | 560 | Category 1
Type D | 565 | Category 1
Type E | 566 | Category 1
Type F | 567 | Category 1
Type G | 570 | Category 1
Type H | 575 | Category 2
Type I | 580 | Category 2
Type J | 585 | Category 2
Type K | 590 | Category 2
Type L | 595 | Category 2
Type M | 600 | Category 2
Type N | 605 | Category 2
Type O | 610 | Category 2
Type P | 615 | Category 3
Type Q | 620 | Category 3
Type R | 625 | Category 3
Type S | 630 | Category 3
Type T | 635 | Category 3
Type U | 640 | Category 4
Type V | 645 | Category 4
Type W | 650 | Category 4
Type X | 655 | Category 5
Type Y | 660 | Category 5
Type Z | 665 | Category 5
Spreadsheet: 73833d1274386534-lookup-criteria-matching-in-rows-and-columns-example
Sheet: Sheet1

Item # | Qty | Available?
99508 | 30
68982 | 91
34562 | 42
77003 | 45
26874 | 53
13472 | 31
11181 | 29
34035 | 32
74949 | 62
95391 | 46
85860 | 66
73913 | 98
16015 | 15
89443 | 29
53705 | 60
42441 | 30
69008 | 84
38704 | 19
45250 | 31
Spreadsheet: 221232d1363436412-diff-between-vlookup-and-match-index-vlkp
Sheet: Sheet1

[NAME] ( solution)
 | Pi = Probability of Success
# of Successes | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7
0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 0.531441 | 0.2621440000000001 | 0.1176489999999999 | 0.04665599999999999 | 0.01562500000000001 | 0.004096000000000002 | 0.0007290000000000004
2 | 0.3542940000000001 | 0.3932160000000002 | 0.3025259999999999 | 0.186624 | 0.09375 | 0.03686400000000002 | 0.010206
3 | 0.09841500000000003 | 0.2457600000000001 | 0.3241349999999998 | 0.31104 | 0.234375 | 0.13824 | 0.05953500000000001
4 | 0.01458 | 0.08192000000000006 | 0.1852199999999998 | 0.27648 | 0.3125000000000001 | 0.27648 | 0.18522
5 | 0.001215000000000001 | 0.01536000000000001 | 0.05953499999999996 | 0.13824 | 0.234375 | 0.31104 | 0.324135
# of Successes |  |  | 2 |  | 3 | MATCH |  | VLOOKUP
Pi = Probability of Success |  |  | 0.5 |  | 5 | MATCH |  | VLOOKUP
n = Fixed # Trials |  |  | 6 |  | 0.09375 | INDEX
NOW I WANT THE SAME RESULT THROUGH VLOOKUP()
Spreadsheet: 145280d1331485711-how-can-i-show-the-cell-values-in-one-cell-instead-of-summ-listing-matching-values-in-one-cell
Sheet: Sheet1

 |  |  |  | with =SUMIF($B$2:$B$23;D2;$A$2:$A$23) I am getting this result |  | I need to get the show cloumb a
1 | G29 | G29-1 | F64 | 65 |  | 13,16,17,19
2 | 820 | 820-1 | G29 | 58 |  | 1,8,11,18,20
3 | 830 | 830-1 | m05 | 41 |  | 12,14,15
4 | 820 | 820-2 | 820 | 42 |  | 2,4,6,9,21
5 | 830 | 830-2 | 830 | 47 |  | 3,5,7,10,22
6 | 820 | 820-3
7 | 830 | 830-3
8 | G29 | G29-2
9 | 820 | 820-4
10 | 830 | 830-4
11 | G29 | G29-3
12 | m05 | m05-1 | F64 | 13,16,17,19 |  |  |  |  |  |  |  |  | 13 | 16 | 17 | 19
13 | F64 | F64-1 | G29 | 1,8,11,18,20 |  |  |  |  |  |  |  |  | 1 | 8 | 11 | 18 | 20
14 | m05 | m05-2 | m05 | 12,14,15 |  |  |  |  |  |  |  |  | 12 | 14 | 15
15 | m05 | m05-3 | 820 | 2,4,6,9,21 |  |  |  |  |  |  |  |  | 2 | 4 | 6 | 9 | 21
16 | F64 | F64-2 | 830 | 3,5,7,10,22 |  |  |  |  |  |  |  |  | 3 | 5 | 7 | 10 | 22
17 | F64 | F64-3
18 | G29 | G29-4
19 | F64 | F64-4
20 | G29 | G29-5
21 | 820 | 820-5
22 | 830 | 830-5