tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: daren_farmer__6619__egmnom-Mar
Sheet: EGM 202

 | Nomination Change
 | ATTN: Transportation Specialist
HOUSTON PIPE LINE COMPANY
HPL Contract # |  | 012-27106-02-002
Shipper: | Entex Gas Marketing | Effective Dates:
Nominator: | Troy Benoit | Start:
Telephone: | (713)207-3376 | 2000-03-01 00:00:00
Fax: | (713)646-5799 | Stop:
 |  | 2000-03-31 00:00:00
RECEIPTS |  |  | MAR
METER # | [NAME] | SUPPLIER | 1
553 | TOMCAT
553 | TOMCAT
584 | VALERO - AGUA DULCE
3536 | BLESSING
3536 | BLESSING
4132 | EXXON KATY | TX ENERGY
5674 | MOPS
7038 | TRANS TX - AGUA DULCE
5674 | MOPS | SUPERIOR
7061 | MARKHAM
ZZZZ | IMBALANCE |  | 0
 |  | RECEIPT TOTAL
DELIVERIES
METER # | [NAME] | MARKET
713 | GEORGIA GULF
1008 | NEUCES BAY
1057 | CORPUS PLANT
1060 | SHELL DEER PARK
1168 | BAMMEL
1233 | TEXAS CITY
1244 | KOCH REFINERY
1258 | LUFKIN CHAMPION | DONAHOE
1319 | BAMMEL
1326 | ENTERPRISE
1373 | LYONDELL
1427 | GSU SABINE
1427 | GSU LEWIS CREEK
1431 | MARATHON TEXAS CITY
1563 | DESTECH
3551 | VALERO RED BLUFF
4132 | EXXON KATY HPL
4531 | NEEDVILLE
7285 | MOSS BLUFF
ZZZZ | IMBALANCE |  | 0
 |  | DELIVERY TOTAL
 |  | BALANCE
Spreadsheet: 147346d1332757711-sum-1st-col-under-col-2-if-the-cel-at-col-2-equals-a-cell-at-col-3-excelforumexample
Sheet: Sheet1

 | Column to be Summed | Info1 | Info2 | Info3 | [NAME]
 | 10 | 2 | 3 | 9 | 9
 | 66 | 9 | 5 | 6 | 9
 | 33 | 5 | 9 | 3 | 9
 | 22 | 5 | 2 | 3 | 5
 | 11 | 5 | 1 | 1 | 5
 | 22 | 6 | 9 | 3 | 9
 | SHOULD SHOW: | 99 | 42 | 10
Spreadsheet: tom_donohoe__39957__HIOS 05092001nom sheet
Sheet: Sheet1

Devon Energy Corporation
HIOS System
Effective: | 2001-05-09 00:00:00
Market:  Enron |  |  |  |  |  |  |  |  | Phone:  [PHONE]
Agent:  [NAME] |  |  |  | Phone:  [PHONE] |  |  |  |  | Email:  [EMAIL]
 |  |  |  | [NAME]:  [EMAIL] |  |  |  |  | [NAME]: [EMAIL]
 |  |  |  | [NAME]: [EMAIL] |  |  |  |  | Phone:  [PHONE]
[NAME]:  [NAME] |  |  |  |  |  |  |  |  | Phone:  [PHONE]
 |  |  |  | Phone:  [PHONE] |  |  |  |  | Email:  [EMAIL]
 |  |  |  | Email:  [EMAIL]
ENRON'S NOM INFORMATION |  |  |  |  |  |  |  | DEVON'S PVR NOM
Effective Date of Change | Property Name | Gross Vol (MMBTU) | Enron's Gross Volume | Enron's Available Volume @ WC 167 | DBQ | Excess |  | PVR% | PVR Volume | PVR Volume | Fuel on PVR (MMBtu/d) | Avail PVR After Fuel (MMBtu/d) |  |  |  | First of the Month  DBQ
2001-05-09 00:00:00 | HI 563/564 B | 1582 |  |  |  |  |  | 0.09 |  |  |  |  |  |  |  | 1392
2001-05-09 00:00:00 | HI 351/368 | 22115 |  |  |  |  |  |  |  |  |  |  |  |  |  | 16646
2001-05-09 00:00:00 | HI 325 | 1946 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1188
2001-05-09 00:00:00 | HI 339/340 | 9388 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9978
2001-05-01 00:00:00 | HI 582 | 2381 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1452
Total Nom
Spreadsheet: 81031d1281310575-copy-paste-from-a-website-to-excel-hawkstats
Sheet: Sheet1

Offense Stats
 |  |  | FG |  |  | 3PT |  |  | FT |  |  | Rebounds |  |  | [NAME].
Offense | G | Min | M | A | Pct | M | A | Pct | M | A | Pct | Off | Def | Tot | Ast | TO | Stl | Blk | PF | PPG
Totals |  |  | 3181 | 6801 | 46.8 | 524 | 1455 | 36 | 1452 | 1914 | 75.9 | 969 | 2451 | 3420 | 1789 | 941 | 592 | 413 | 1632 | 101.7
League Rank |  |  | 6 | 12 | T10 | 14 | 15 | 9 | T21 | 23 | 15 | 6 | 23 | T17 | 12 | 30 | 15 | 14 | 23 | T12
[NAME] | 76 | 2886 | 635 | 1386 | 45.8 | 129 | 350 | 36.9 | 220 | 269 | 81.8 | 74 | 279 | 353 | 369 | 145 | 82 | 5 | 145 | 21.3
Jamal Crawford | 79 | 2460 | 496 | 1105 | 44.9 | 163 | 427 | 38.2 | 270 | 315 | 85.7 | 34 | 167 | 201 | 238 | 137 | 61 | 12 | 132 | 18
[NAME] | 81 | 2871 | 504 | 999 | 50.5 | 0 | 7 | 0 | 261 | 422 | 61.9 | 223 | 482 | 705 | 342 | 198 | 130 | 173 | 240 | 15.7
[NAME] | 81 | 2845 | 467 | 847 | 55.1 | 1 | 1 | 100 | 213 | 270 | 78.9 | 236 | 563 | 799 | 189 | 122 | 59 | 91 | 225 | 14.2
[NAME] | 81 | 2468 | 302 | 664 | 45.5 | 40 | 132 | 30.3 | 176 | 215 | 81.9 | 106 | 310 | 416 | 93 | 72 | 66 | 46 | 160 | 10.1
[NAME] | 80 | 2195 | 268 | 644 | 41.6 | 126 | 324 | 38.9 | 68 | 79 | 86.1 | 20 | 164 | 184 | 310 | 90 | 67 | 3 | 157 | 9.1
[NAME] | 79 | 1317 | 175 | 393 | 44.5 | 57 | 169 | 33.7 | 46 | 61 | 75.4 | 59 | 95 | 154 | 48 | 20 | 34 | 17 | 125 | 5.7
Zaza Pachulia | 78 | 1089 | 120 | 246 | 48.8 | 0 | 4 | 0 | 93 | 143 | 65 | 117 | 176 | 293 | 42 | 58 | 37 | 30 | 186 | 4.3
[NAME] | 71 | 719 | 90 | 227 | 39.7 | 7 | 32 | 21.9 | 41 | 49 | 83.7 | 5 | 62 | 67 | 122 | 50 | 34 | 11 | 82 | 3.2
[NAME] | 64 | 592 | 77 | 193 | 39.9 | 1 | 7 | 14.3 | 39 | 48 | 81.3 | 66 | 91 | 157 | 21 | 22 | 6 | 19 | 95 | 3
[NAME] | 28 | 124 | 23 | 41 | 56.1 | 0 | 0 | 0 | 16 | 27 | 59.3 | 10 | 28 | 38 | 2 | 12 | 5 | 3 | 34 | 2.2
Othello Hunter | 7 | 33 | 4 | 12 | 33.3 | 0 | 0 | 0 | 3 | 4 | 75 | 6 | 6 | 12 | 0 | 3 | 0 | 1 | 5 | 1.6
[NAME] | 39 | 142 | 12 | 21 | 57.1 | 0 | 1 | 0 | 6 | 10 | 60 | 8 | 19 | 27 | 9 | 7 | 8 | 0 | 25 | 0.8
[NAME] | 24 | 115 | 8 | 23 | 34.8 | 0 | 1 | 0 | 0 | 2 | 0 | 5 | 9 | 14 | 4 | 5 | 3 | 2 | 21 | 0.7
Spreadsheet: daren_farmer__5495__hpl0926
Sheet: Sheet1

HPLN0926.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - September 26, 2000
 |  |  |  |  |  | ** Tuesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-09-26 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 30  0900hrs | 0 to 30  0900hrs
 |  |  |  |  | 30  to 0 2100hrs | 30  to 0 2100hrs
 |  | Firm Summary
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 873503d1720008196-how-to-combine-daily-sales-remaining-stock-into-one-table-how-to-combine-daily-sales-remaining-stock-into-one-table
Sheet: Stocks

Warehouse Stocks |  | <------------------ Stock in ------------------> |  |  | <-------------------- Stock Out --------------------> |  |  | <------------------------ Remaining Stock ------------------------>
Date | Particulars | Orange In | Banana In | Mango In | Orange Out | [NAME] Out | Mango Out | Orange Balance | [NAME] | Mango Balance | Month
2024-07-01 00:00:00 | Balance b/f | 51 | 51 | 51 |  |  |  |  |  |  |  |  | 1) "Stock Out" is formularised from Sales Table
2024-07-01 00:00:00 | Sales |  |  |  |  |  |  |  |  |  |  |  | 2) Insert row whenever Restocking takes place
 | Sales
2024-07-02 00:00:00 | Restocking | 80 | 80 | 80
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
 | Sales
Spreadsheet: 849286d1699819393-completion-streak-no-not-boasting-consecutive
Sheet: Sheet1

 |  |  | 2023-11-13 00:00:00 | 12
 |  |  | 2023-11-14 00:00:00 | 32
 |  |  | 2023-11-15 00:00:00 | 2
 |  |  | 2023-11-16 00:00:00 | 12
 |  |  | 2023-11-17 00:00:00 | 3
 |  |  | 2023-11-18 00:00:00
 |  |  | 2023-11-19 00:00:00 | 11
 |  |  | 2023-11-20 00:00:00 | 23
 |  |  | 2023-11-21 00:00:00
 |  |  | 2023-11-22 00:00:00 | 17
 |  |  | 2023-11-23 00:00:00 | 14
 |  |  | 2023-11-24 00:00:00 | 23
 |  |  | 2023-11-25 00:00:00 | 45
 |  |  | 2023-11-26 00:00:00 | 12
 |  |  | 2023-11-27 00:00:00 | 78
 |  |  | 2023-11-28 00:00:00
 |  |  | 2023-11-29 00:00:00 | 23
 |  |  | 2023-11-30 00:00:00 | 76
 |  |  | 2023-12-01 00:00:00 | 12
 |  |  | 2023-12-02 00:00:00 | 34
 |  |  | 2023-12-03 00:00:00 | 2
 |  |  | 2023-12-04 00:00:00
 |  |  | 2023-12-05 00:00:00 | 23
 |  |  | 2023-12-06 00:00:00 | 11
 |  |  | 2023-12-07 00:00:00 | 44
Spreadsheet: 600182d1543508811-vlookup-if-formula-help-to-report-summary-of-tasks-sample-task-list
Sheet: Master List

CLIENT | TASK | EMPLOYEE | DUE | PRIORITY
Acme Corp | Build desk | [NAME] | 2018-12-15 00:00:00 | HIGH
Acme Corp | Order material | [NAME] | 2018-12-30 00:00:00 | HIGH
Ace Inc | Build shelf | [NAME] | 2018-12-05 00:00:00 | LOW
Ace Inc | Order material | [NAME] | 2018-12-20 00:00:00 | LOW
AL LLC | Build cabinet | [NAME] | 2018-12-06 00:00:00 | HIGH
AL LLC | Order material | [NAME] | 2018-12-16 00:00:00 | LOW
ABC | Build table | Barb | 2018-12-08 00:00:00 | HIGH
ABC | Order material | Barb | 2018-12-18 00:00:00 | LOW
Spreadsheet: 1ca7a902-9274-4abb-84a6-7fa4f701ba50
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: Manufactured Homes Survey
 |  | Total Homes: U.S. Total
 |  | Not Seasonally Adjusted Total Placements [Thousands of Units]
 |  | Period: 2000 to 2012
 |  | Data Extracted on: September 1, 2014 (10:00 am)
Period | Value
Jan-2000 | 18.5
Feb-2000 | 23.6
Mar-2000 | 30.4
Apr-2000 | 25.3
May-2000 | 28.7
Jun-2000 | 27
Jul-2000 | 23.7
Aug-2000 | 25.9
Sep-2000 | 22.9
Oct-2000 | 22
Nov-2000 | 17.3
Dec-2000 | 15.5
Jan-2001 | 12.9
Feb-2001 | 14.1
Mar-2001 | 15.5
Apr-2001 | 15
May-2001 | 16.8
Jun-2001 | 18.4
Jul-2001 | 17.4
Aug-2001 | 19
Sep-2001 | 18.5
Oct-2001 | 18.6
Nov-2001 | 15.6
Dec-2001 | 14.4
Jan-2002 | 11.4
Feb-2002 | 12
Mar-2002 | 13.2
Apr-2002 | 14.8
May-2002 | 18.9
[NAME] | 16.4
Jul-2002 | 15.5
Aug-2002 | 16.9
Sep-2002 | 14.6
Oct-2002 | 15.9
Nov-2002 | 12.6
Dec-2002 | 12
[NAME] | 9.5
Feb-2003 | 7.5
Mar-2003 | 11.5
Apr-2003 | 11.9
May-2003 | 13
Jun-2003 | 12.3
Jul-2003 | 11.8
Aug-2003 | 12.8
Sep-2003 | 13
Oct-2003 | 14.6
Nov-2003 | 11.4
Dec-2003 | 10.5
Jan-2004 | 8.2
Feb-2004 | 7.4
Mar-2004 | 9.8
Apr-2004 | 11.4
May-2004 | 11.6
Jun-2004 | 12.7
Jul-2004 | 12.2
Aug-2004 | 10.7
Sep-2004 | 10.7
Oct-2004 | 10.9
Nov-2004 | 8.8
Dec-2004 | 9.9
Jan-2005 | 8.7
Feb-2005 | 8
Mar-2005 | 9.2
Apr-2005 | 9.6
May-2005 | 11.3
Jun-2005 | 12.3
Jul-2005 | 11.3
Aug-2005 | 11.9
Sep-2005 | 10.6
Oct-2005 | 11.5
Nov-2005 | 10
Dec-2005 | 8.6
Jan-2006 | 8.3
Feb-2006 | 7.6
Mar-2006 | 9.4
Apr-2006 | 9
May-2006 | 11
Jun-2006 | 11.8
Jul-2006 | 9.9
Aug-2006 | 10.5
Sep-2006 | 9.6
Oct-2006 | 8.8
Nov-2006 | 8.7
Dec-2006 | 7.8
[NAME] | 5.6
Feb-2007 | 5.3
Mar-2007 | 8.1
Apr-2007 | 7.2
May-2007 | 9.1
Jun-2007 | 10
Jul-2007 | 8.9
Aug-2007 | 9
Sep-2007 | 8.3
Oct-2007 | 8.7
Nov-2007 | 8.5
Dec-2007 | 6.1
Jan-2008 | 4.8
Feb-2008 | 5.9
Mar-2008 | 6.7
Apr-2008 | 7.1
May-2008 | 7.9
Jun-2008 | 7.9
Jul-2008 | 7.6
Aug-2008 | 7.6
Sep-2008 | 7.2
Oct-2008 | 7.2
Nov-2008 | 5.4
Dec-2008 | 5.3
Jan-2009 | 4
Feb-2009 | 3.2
Mar-2009 | 4.7
Apr-2009 | 4.8
May-2009 | 4.7
Jun-2009 | 4.7
Jul-2009 | 4.6
Aug-2009 | 4.2
Sep-2009 | 4.9
Oct-2009 | 5.2
Nov-2009 | 5.4
Dec-2009 | 4
[NAME] | 2.8
[NAME] | 2.8
Mar-2010 | 4
Apr-2010 | 5
[NAME] | 5.4
[NAME] | 5.9
[NAME] | 4.7
Aug-2010 | 4.8
Sep-2010 | 3.8
Oct-2010 | 4.4
Nov-2010 | 3.4
Dec-2010 | 3.6
Jan-2011 | 2.3
Feb-2011 | 2.8
Mar-2011 | 3.7
Apr-2011 | 4.2
May-2011 | 3.7
Jun-2011 | 5.1
Jul-2011 | 4
Aug-2011 | 4.7
Sep-2011 | 4
Oct-2011 | 4.3
Nov-2011 | 5.1
Dec-2011 | 3.9
Jan-2012 | 3.1
Feb-2012 | 3.4
Mar-2012 | 4.5
Apr-2012 | 4.4
May-2012 | 4.9
Jun-2012 | 4.8
Jul-2012 | 4.2
Aug-2012 | 5.4
Sep-2012 | 4.5
Oct-2012 | 4.7
Nov-2012 | 4.9
Dec-2012 | 4
Spreadsheet: 27cadfa4-721e-489f-b2fe-73fada9aadf5
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
MATTEL, INC. AND SUBSIDIARIES
RECONCILIATION OF GAAP TO NON-GAAP FINANCIAL MEASURE
 |  |  |  |  | Three Months Ended June 30, |  |  |  |  |  | Six Months Ended June 30,
(In millions, except percentage information) |  |  |  |  |  | 2009 |  |  | 2008 |  |  | 2009 |  |  | 2008
Gross Sales |  |  |  |  | $ | 975 |  | $ | 1214.4 |  | $ | 1832.2 |  | $ | 2221.1
[NAME] |  |  |  |  |  | -76.8 |  |  | -102 |  |  | -148.4 |  |  | -189.4
Net Sales |  |  |  |  | $ | 898.2 |  | $ | 1112.4 |  | $ | 1683.8 |  | $ | 2031.7
% Change |  |  |  |  |  | -0.1925566343042071 |  |  | 0.1095152603231598 |  |  | -0.1712359108136044 |  |  | 0.04570487415718769
Pos./(Neg.) Impact of Currency (in % pts) |  |  |  |  |  | -5 |  |  | 5 |  |  | -6 |  |  | 5
The financial information included herein should be read in conjunction with Mattel's consolidated financial statements and related notes in its Annual Reports
on Form 10-K and/or Quarterly Reports on Form 10-Q, as applicable.
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: R55

Ime artikla
Spreadsheet: 0f5a5c47-df75-48ae-beaf-639ac0763327
Sheet: Suspension Trends

Suspension
 | 2006FA | 2007SP | 2007FA | 2008SP | 2008FA | 2009SP | 2009FA | 2010SP | 2010FA | 2011SP | Fall to Fall Pct Change | Spr to Spr Pct Change
Freshman | 76 | 116 | 64 | 170 | 59 | 157 | 44 | 126 | 25 | 125
Sophomore | 18 | 16 | 17 | 20 | 12 | 13 | 19 | 19 | 3 | 16
Junior | 4 | 1 | 5 | 5 | 3 | 11 | 6 | 4 | 0 | 3
Senior | 0 | 3 | 2 | 3 | 1 | 2 | 4 | 4 | 2 | 3
Special | 3 | 7 | 5 | 5 | 5 | 5 | 0 | 1 | 1 | 2
Total
Term UG Census | 3733 | 3472 | 3618 | 3498 | 3684 | 3644 | 3769 | 3665 | 4015 | 3838
Prcnt of Census
Cohort Members | 5 |  | 1 |  | 1 | 91 | 2 | 74 | 2 | 76
Total Cohort | 528 | 644 | 528 | 528 | 538 | 538 | 545 | 545 | 713 | 713
Prcnt of Cohort
Spreadsheet: 330160d1404576002-extract-year-for-other-formula-extract-date-test
Sheet: Revenue

 | 2009 | 2010 | % Change from 2009 | 2011 | % Change from 2010 | 2012 | % Change from 2011 | 2013 | % Change from 2012 | 2014 | % Change from 2013 | 2015 | % Change from 2014 | 2016 | % Change from 2015 | 2017 | % Change from 2016
TotalBodyFitness | 1860 | 7755 |  | 12435 |  | 7260 |  | 8910
FitForLife | 4750 | 10566 |  | 13579 |  | 8605 |  | 11208
PilatesClass |  | 14714 |  | 13120 |  | 13240 |  | 15322
PilatesPrivate45min |  |  |  |  |  | 8908 |  | 10100
PilatesPrivate60min | 27042 | 20820 |  | 21600 |  | 1600 |  | 2000
PilatesDuet |  |  |  |  |  | 3840 |  | 4000
FitnessTrainingAssessment |  |  |  | 11095 |  | 1250 |  | 1000
FitnessTrainingFollowUp |  |  |  |  |  | 5995 |  | 9720
RunningEval | 6600 | 10525 |  | 8525 |  | 10325 |  | 7255
RunningFollowUp |  |  |  |  |  | 255 |  | 85
BikeFitOption1 | 1425 | 2450 |  | 1700 |  | 1635 |  | 875
BikeFitOption2 |  |  |  |  |  | 200 |  | 600
[NAME] |  |  |  |  |  | 1200 |  | 360
Message50min |  |  |  | 1135 |  | 1045 |  | 1805
GolfAssessment | 6000 | 3799 |  | 4045 |  | 1035 |  | 875
GolfFollowUp |  |  |  |  |  | 1150 |  | 85
AlterG |  |  |  |  |  | 400 |  | 130
Note: | Spreadsheet data for years 2009 - 2013 was found in several different worksheets and therefore not considered consistent/reliable. Katrina's original yearly totals found in a separate spreadsheet, all done by hand, and were used here. Data from 2014 - present reflectS all data that has been entered into our spreadsheet in the "Data Input" tab. All data found prior to 2014 can be found in the "Prior to '14" tab, but totals here do not match up with what P.T. Aide Katrina and EHR had agreed with.
Spreadsheet: 133611d1324499238-if-statement-help-excel-help
Sheet: Sheet1

Convenience Stores / Gas Stations | Lead Owner | Company | Store Locations | Annual Revenue
1
2
3
4
5
6
7
8
9
10
Restaurants - Full Serve / Casual Dining | Lead Owner | Company | Store Locations | Annual Revenue
1
2
3
4
5
6
7
8
9
10
Spreadsheet: 872473d1718845819-lookup-values-on-a-dataset-where-the-look-up-timestamp-is-within-1-minute-of-dataset-sample_dataset062024
Sheet: Calculations

Information I need to look up in Orders_Audit_dataset |  |  |  |  | Calculations |  |  |  | Expected
created_timestamp | customer_id | business_id | branch | order_date | order_submit_timestamp | [NAME] |  |  | order_submit_timestamp | [NAME]
2024-06-11 03:46:00 | 111 | 3001 | B001 | 2024-06-11 00:00:00 |  | 41127 |  |  | 2024-06-11 03:47:00 | 41112
2024-06-11 02:48:00 | 112 | 3002 | B002 | 2024-06-11 00:00:00 |  | 41165 |  |  | 2024-06-11 02:49:00 | 41148
2024-06-11 01:51:00 | 113 | 3003 | B003 | 2024-06-11 00:00:00 |  |  | Why is it spilling over? |  | 2024-06-11 01:52:00 | 41216
2024-06-12 01:50:59.995000 | 113 | 3003 | B004 | 2024-06-12 00:00:00 |  |  |  |  | Does Not exist
Spreadsheet: 698785d1602175648-add-if-specific-text-value-8-copy
Sheet: Accounts

a/a | date |  | reason | store | from | other | Ammount | plus-minus |  | atm | cash withdrawals
1 | 2020-09-25 00:00:00 | var | reason1 |  | 2020-09-25 00:00:00 |  | 0.24 | Χ |  | enter | credit
2 | 2020-09-25 00:00:00 | var | reason2 |  | 2020-09-25 00:00:00 |  | 1.01 | Χ |  | master | MasterCard Bonus
3 | 2020-09-24 00:00:00 | var | [NAME] |  | 2020-09-24 00:00:00 |  | 3.5 | Χ |  | visa | VISA
4 | 2020-09-22 00:00:00 | tra | reason4 |  | 2020-09-19 00:00:00 |  | 69.99 | Χ |  | tra | transfers
5 | 2020-09-22 00:00:00 | add | reason5 |  | 2020-09-19 00:00:00 |  | 69.99 | Π |  | var | various
6 | 2020-09-18 00:00:00 | var | reason6 |  | 2020-09-18 00:00:00 |  | 1 | Χ |  | ote | ΟΤΕ
7 | 2020-09-18 00:00:00 | tra | reason7 |  | 2020-09-18 00:00:00 |  | 120 | Χ |  | acdc | power
8 | 2020-09-16 00:00:00 | var | reason8 |  | 2020-09-16 00:00:00 |  | 3 | Χ |  | tax | taxes
9 | 2020-09-16 00:00:00 | add | [NAME] |  | 2020-09-16 00:00:00 |  | 1263.67 | Π |  | autos | auto
10 | 2020-09-16 00:00:00 | var | reason10 |  | 2020-09-15 00:00:00 |  | 0.3 | Χ |  | invest | Επενδύσεις
11 | 2020-09-15 00:00:00 | ote | reason11 |  | 2020-09-15 00:00:00 |  | 40 | Χ
12 | 2020-09-14 00:00:00 | var | reason12 |  | 2020-09-14 00:00:00 |  | 3 | Χ
13 | 2020-09-14 00:00:00 | add | reason13 |  | 2020-09-14 00:00:00 |  | 1000 | Π
14 | 2020-09-08 00:00:00 | var | reason14 |  | 2020-09-08 00:00:00 |  | 3 | Χ
15 | 2020-09-08 00:00:00 | tra | reason15 |  | 2020-09-08 00:00:00 |  | 500 | Χ
16 | 2020-09-03 00:00:00 | master | reason16 |  | 2020-09-03 00:00:00 |  | 333.18 | Χ
17 | 2020-09-03 00:00:00 | visa | reason17 |  | 2020-09-03 00:00:00 |  | 984.65 | Χ
18 | 2020-09-01 00:00:00 | var | reason18 |  | 2020-09-01 00:00:00 |  | 3 | Χ
19 | 2020-09-01 00:00:00 | add | reason19 |  | 2020-09-01 00:00:00 |  | 1461.29 | Π
20 | 2020-09-01 00:00:00 | var | reason20 |  | 2020-08-31 00:00:00 |  | 0.3 | Χ
Spreadsheet: 210561d1359489292-cant-separate-values-of-a-cell-book3-moo
Sheet: Sheet1

WHAT I'VE GOT:
PRT-BNS-SVR-01/p;2 PRT-BNS-EOC-01-5.5.04/-;1 PRT-BNS-SRD-01/t;4 PRT-BNS-SDD-03/f;1 PRT-BNS-SRD-03/g;1 PRT-BNS-SCI-01/bn;1 PRT-BNS-SAS-01/t;1 PRT-BNS-SDD-01/f;1 PRT-BNS-CIA-01/p;2 PRT-BNS-SVCP-01/r;2 |  | =SUBSTITUTE(A2,CHAR(13)," ") in cell D2 -->
 |  | Paste Special: Values in cell [NAME], then Text-to-Columns ---> | PRT-BNS-SVR-01/p;2 | PRT-BNS-EOC-01-5.5.04/-;1 | PRT-BNS-SRD-01/t;4 | PRT-BNS-SDD-03/f;1 | PRT-BNS-SRD-03/g;1 | PRT-BNS-SCI-01/bn;1 | PRT-BNS-SAS-01/t;1 | PRT-BNS-SDD-01/f;1 | PRT-BNS-CIA-01/p;2 | PRT-BNS-SVCP-01/r;2
WHAT I NEED: |  | Copied D3:M3, and used [NAME] Special: Transpose to start in cell D5 --> |  | Used formula 1 below | Used formula 2 below
PRT-BNS-SVR-01 | p |  | PRT-BNS-SVR-01/p;2
PRT-BNS-EOC-01-5.5.04 | - |  | PRT-BNS-EOC-01-5.5.04/-;1
PRT-BNS-SRD-01 | t |  | PRT-BNS-SRD-01/t;4
PRT-BNS-SDD-03 | f |  | PRT-BNS-SDD-03/f;1
PRT-BNS-SRD-03 | g |  | PRT-BNS-SRD-03/g;1
PRT-BNS-SCI-01 | bn |  | PRT-BNS-SCI-01/bn;1
PRT-BNS-SAS-01 | t |  | PRT-BNS-SAS-01/t;1
PRT-BNS-SDD-01 | f |  | PRT-BNS-SDD-01/f;1
PRT-BNS-CIA-01 | p |  | PRT-BNS-CIA-01/p;2
PRT-BNS-SVCP-01 | r |  | PRT-BNS-SVCP-01/r;2
Spreadsheet: 745596d1630042743-how-to-find-the-unit-number-by-date-and-month-book2_v1
Sheet: Sheet1

Date | Renewal | Customer | Week number | Month
2021-08-21 00:00:00 | Existing | Funnel Duo Media Sdn Bhd
2021-08-21 00:00:00 | Existing | Kinexure Sdn Bhd
2021-08-23 00:00:00 | New | Yeow & Salleh
2021-08-23 00:00:00 | Existing | Tyng & Co
2021-08-23 00:00:00 | Existing | APPLESEEDLERS CREATIVITY SDN BHD
2021-08-23 00:00:00 | New | [NAME]
2021-08-24 00:00:00 | Existing | GIFT SOUTH EAST ASIA SB
2021-08-24 00:00:00 | Existing | PERBADANAN PENGURUSAN C180
2021-08-24 00:00:00 | New | Myrimari Resources
2021-08-24 00:00:00 | Existing | RPG Commerce Sdn Bhd
2021-08-24 00:00:00 | Existing | [NAME] Bhd
2021-08-24 00:00:00 | Existing | Mediconnexions Consulting Sdn Bhd
2021-08-24 00:00:00 | Existing | Digital Penang
2021-08-25 00:00:00 | Existing | Duty Free Distribution Sdn Bhd
2021-08-25 00:00:00 | Existing | The Property Guys Sdn Bhd
2021-08-25 00:00:00 | Existing | The Makeover Guys Sdn Bhd
2021-08-25 00:00:00 | Existing | Team Fames Sdn Bhd
2021-08-25 00:00:00 | Existing | VISUAL EFX SDN BHD
2021-08-25 00:00:00 | Existing | UIE Solutions (M) Sdn Bhd
2021-08-25 00:00:00 | Existing | Stesyen Minyak Sri Pantai
2021-08-26 00:00:00 | Existing | EBL Pro Marketing
2021-08-26 00:00:00 | Existing | Amanjena Resources
2021-08-26 00:00:00 | Existing | MSLI RESOURCES SDN BHD
2021-08-26 00:00:00 | New | Untung Logistics Sdn Bhd
2021-08-26 00:00:00 | Existing | [NAME]. Bhd.
 |  | 2021-08-25 11:53:32 | [NAME] | Manual
 | New | Number of New Customer |  | 7
 | Existing | Number of Existing Customer |  | 0
 |  | Aug Sales Number
 | New | Number of New Customer |  | 4
 | Existing | Number of Existing Customer |  | 21
Spreadsheet: 841103d1693350805-average-for-different-scenarios-formula-toupdate
Sheet: Scenario3

Long (purchased |  |  |  |  | [NAME] left part (yellow) with explanation
Entry Date | Exit Date | # of  Contracts | Strike Purchased |  | Date | Long | Short | Margin | Calculation
2023-08-14 00:00:00 | 2023-08-17 00:00:00 | 1 | 100 |  | 2023-08-14 00:00:00 | 500 | 100 | 105 | (105-100)*1 (number of contracts) * 100 => 5 * 1 * 100 => 500 | (only one contract)
2023-08-15 00:00:00 | 2023-08-17 00:00:00 | 2 | 105 |  | 2023-08-15 00:00:00 | 1000 | 105 | 110 | (110-105)*2 (number of contracts) * 100 => 5 * 2 * 100 => 1000 | (moved to two contracts)
2023-08-17 00:00:00 | 2023-08-18 00:00:00 | 2 | 110 |  | 2023-08-16 00:00:00 | 1000 | 105 | 110 | (110-105)*2 (number of contracts) * 100 => 5 * 2 * 100 => 1000
 |  |  |  |  | 2023-08-17 00:00:00 | 1000 | 110 | 115 | (115-110) * 2 (number of contracts) * 100 => 5 * 2 * 100 => 1000
Short (sold) |  |  |  |  | 2023-08-18 00:00:00 | Closed
Entry  Date | Exit Date | # of  Contracts | Strike Sold |  |  | Average | Current
2023-08-14 00:00:00 | 2023-08-15 00:00:00 | 1 | 105 |  |  | 875 | 1000
2023-08-15 00:00:00 | 2023-08-17 00:00:00 | 2 | 110
2023-08-17 00:00:00 | 2023-08-18 00:00:00 | 2 | 115