tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 494575d1482481646-sequencial-numbers-with-working-day-conditional-count-to-9-then-restart-ignoring-weekends-and-holidays
Sheet: Sheet1

 |  | Required |  | Result not counting holidays |  |  | Holidays
2017-01-01 00:00:00 |  | 0 |  | 0 |  |  | 2017-01-10 00:00:00
2017-01-02 00:00:00 |  | 1 |  |  |  |  | 2017-01-12 00:00:00
2017-01-03 00:00:00 |  | 2 |  |  |  |  | 2017-01-17 00:00:00
2017-01-04 00:00:00 |  | 3 |  |  |  |  | 2017-01-18 00:00:00
2017-01-05 00:00:00 |  | 4 |  |  |  |  | 2017-01-25 00:00:00
2017-01-06 00:00:00 |  | 5
2017-01-07 00:00:00 |  | 5
2017-01-08 00:00:00 |  | 5
2017-01-09 00:00:00 |  | 6
2017-01-10 00:00:00 |  | 7 | Holiday
2017-01-11 00:00:00 |  | 8
2017-01-12 00:00:00 |  | 9 | Holiday
2017-01-13 00:00:00 |  | 1
2017-01-14 00:00:00 |  | 1
2017-01-15 00:00:00 |  | 1
2017-01-16 00:00:00 |  | 2
2017-01-17 00:00:00 |  | 3 | Holiday
2017-01-18 00:00:00 |  | 4 | Holiday
2017-01-19 00:00:00 |  | 5
2017-01-20 00:00:00 |  | 6
2017-01-21 00:00:00 |  | 6
2017-01-22 00:00:00 |  | 6
2017-01-23 00:00:00 |  | 7
2017-01-24 00:00:00 |  | 8
2017-01-25 00:00:00 |  | 9 | Holiday
2017-01-26 00:00:00 |  | 1
2017-01-27 00:00:00 |  | 2
2017-01-28 00:00:00 |  | 2
2017-01-29 00:00:00 |  | 2
2017-01-30 00:00:00
2017-01-31 00:00:00
2017-02-01 00:00:00
2017-02-02 00:00:00
2017-02-03 00:00:00
2017-02-04 00:00:00
2017-02-05 00:00:00
2017-02-06 00:00:00
2017-02-07 00:00:00
2017-02-08 00:00:00
2017-02-09 00:00:00
2017-02-10 00:00:00
2017-02-11 00:00:00
2017-02-12 00:00:00
2017-02-13 00:00:00
2017-02-14 00:00:00
2017-02-15 00:00:00
2017-02-16 00:00:00
2017-02-17 00:00:00
2017-02-18 00:00:00
2017-02-19 00:00:00
2017-02-20 00:00:00
2017-02-21 00:00:00
2017-02-22 00:00:00
2017-02-23 00:00:00
2017-02-24 00:00:00
2017-02-25 00:00:00
2017-02-26 00:00:00
2017-02-27 00:00:00
2017-02-28 00:00:00
2017-03-01 00:00:00
2017-03-02 00:00:00
2017-03-03 00:00:00
2017-03-04 00:00:00
2017-03-05 00:00:00
2017-03-06 00:00:00
2017-03-07 00:00:00
2017-03-08 00:00:00
2017-03-09 00:00:00
2017-03-10 00:00:00
2017-03-11 00:00:00
2017-03-12 00:00:00
2017-03-13 00:00:00
2017-03-14 00:00:00
2017-03-15 00:00:00
2017-03-16 00:00:00
2017-03-17 00:00:00
2017-03-18 00:00:00
2017-03-19 00:00:00
2017-03-20 00:00:00
2017-03-21 00:00:00
2017-03-22 00:00:00
2017-03-23 00:00:00
2017-03-24 00:00:00
2017-03-25 00:00:00
2017-03-26 00:00:00
2017-03-27 00:00:00
2017-03-28 00:00:00
2017-03-29 00:00:00
2017-03-30 00:00:00
2017-03-31 00:00:00
2017-04-01 00:00:00
2017-04-02 00:00:00
2017-04-03 00:00:00
2017-04-04 00:00:00
2017-04-05 00:00:00
2017-04-06 00:00:00
2017-04-07 00:00:00
2017-04-08 00:00:00
2017-04-09 00:00:00
2017-04-10 00:00:00
2017-04-11 00:00:00
2017-04-12 00:00:00
2017-04-13 00:00:00
2017-04-14 00:00:00
Spreadsheet: 685746d1594170139-if-then-statement-to-output-tag-logic-update-to-account-for-dates-book1
Sheet: Sheet1

STATUS | DUE DATE | COMPLETE DATE | MAX | RECLASS | FORECAST | Result | expected value
B | 2017-12-22 00:00:00 |  |  | On Hold |  |  | N/A
A | 2017-12-01 00:00:00 |  |  | On Hold |  |  | N/A
B | 2020-01-10 00:00:00 |  | 2020-01-17 00:00:00 | On Hold |  |  | N/A
A | 2020-07-06 00:00:00 |  | 2020-06-01 00:00:00 | On Hold |  |  | N/A
B | 2020-06-06 00:00:00 |  | 2020-06-27 00:00:00 | On Hold |  |  | June-20
A | 2020-06-10 00:00:00 |  | 2020-06-25 00:00:00 | On Hold |  |  | June-20
B | 2020-07-06 00:00:00 |  | 2020-06-01 00:00:00 | On Hold |  |  | N/A
A | 2020-07-10 00:00:00 |  | 2020-07-10 00:00:00 | On Hold |  |  | N/A
In-Process | 2020-07-02 00:00:00 |  | 2020-07-02 00:00:00 | In Process |  |  | N/A
In-Process | 2020-06-26 00:00:00 |  | 2020-06-29 00:00:00 | In Process |  |  | June-20
Available | 2020-07-02 00:00:00 |  | 2020-07-02 00:00:00 | Available |  |  | N/A
Available | 2020-06-26 00:00:00 |  | 2020-06-29 00:00:00 | Available |  |  | June-20
In-Process | 2020-06-02 00:00:00 |  | 2020-06-29 00:00:00 | In Process |  |  | June-20
In-Process | 2020-06-02 00:00:00 |  | 2020-06-22 00:00:00 | In Process |  |  | N/A
Available | 2020-06-02 00:00:00 |  | 2020-06-22 00:00:00 | Available |  |  | N/A
Available | 2020-06-02 00:00:00 |  | 2020-06-29 00:00:00 | Available |  |  | June-20
Pending Assignment | 2020-07-11 00:00:00 |  |  | Pending Assignment |  |  | July-20
[NAME] | 2020-07-20 00:00:00 |  |  | [NAME] |  |  | July-20
[NAME] |  |  |  | [NAME] |  |  | N/A
Pending Assignment |  |  |  | Pending Assignment |  |  | N/A
[NAME] | 2020-07-01 00:00:00 |  |  | [NAME] |  |  | N/A
Pending Assignment | 2020-07-02 00:00:00 |  |  | Pending Assignment |  |  | N/A
[NAME] | 2020-06-01 00:00:00 |  |  | [NAME] |  |  | N/A
Pending Assignment | 2020-08-02 00:00:00 |  |  | Pending Assignment |  |  | N/A
Spreadsheet: 56594d1256754885-multiple-variables-count-sample1
Sheet: Sheet1

 |  | Data
 |  | Name | Balance | Disabled
 |  | [NAME] | -20 | No
 |  | [NAME] | 13 | No
 |  | Al | -12 | Yes
 |  | [NAME] | -1 | Yes
 |  | [NAME] | 45 | No
 |  | Summary
 |  | [NAME] | 0
 |  | [NAME] | 0
 |  | Al | 1
 |  | [NAME] | 1
 |  | [NAME] | 0
Spreadsheet: daren_farmer__6002__WC580reveff061700
Sheet: Sheet1

To:   [NAME]          (Enron)
From: [NAME] ([NAME])
Date:  6/16/00
Subject:  Revised Availabilities Effective 6/17/00
Effective Date | CTP NAME | Gross Vol. (MMBtu/d) | PVR % | PVR Volume | Avail. After PVR (MMBtu/d) | DBQ | Excess
2000-06-17 00:00:00 | WC 580 | 28517 | 0 |  |  | 20145
1st of month DBQ = 20145/d
**Intraday Change**
Increase due to [NAME] plant not being able to process gas.
Spreadsheet: 721273d1614619193-conditional-formatting-with-dates-formula-test2
Sheet: Sheet1

 |  | date | company | name | count | notes |  |  |  | Contacted?
 |  | 2021-01-01 00:00:00 | ABC | [NAME] | 6 | None
 |  | 2021-01-02 00:00:00
 |  | 2021-01-03 00:00:00
 |  | 2021-01-04 00:00:00
 |  | 2021-01-05 00:00:00
 |  | 2021-01-06 00:00:00
 |  | 2021-01-07 00:00:00
 |  | 2021-01-08 00:00:00
 |  | 2021-01-09 00:00:00
 |  | 2021-01-10 00:00:00
 |  | 2021-01-11 00:00:00
 |  | 2021-01-12 00:00:00
 |  | 2021-01-13 00:00:00
 |  | 2021-01-14 00:00:00
 |  | 2021-01-15 00:00:00
 |  | 2021-01-16 00:00:00
 |  | 2021-01-17 00:00:00
 |  | 2021-01-18 00:00:00
 |  | 2021-01-19 00:00:00
 |  | 2021-01-20 00:00:00
 |  | 2021-01-21 00:00:00
 |  | 2021-01-22 00:00:00
 |  | 2021-01-23 00:00:00
 |  | 2021-01-24 00:00:00
 |  | 2021-01-25 00:00:00
 |  | 2021-01-26 00:00:00
 |  | 2021-01-27 00:00:00
 |  | 2021-01-28 00:00:00
 |  | 2021-01-29 00:00:00
 |  | 2021-01-30 00:00:00
 |  | 2021-01-31 00:00:00
 |  | 2021-02-01 00:00:00
 |  | 2021-02-02 00:00:00
 |  | 2021-02-03 00:00:00
 |  | 2021-02-04 00:00:00
 |  | 2021-02-05 00:00:00
 |  | 2021-02-06 00:00:00
 |  | 2021-02-07 00:00:00
 |  | 2021-02-08 00:00:00
 |  | 2021-02-09 00:00:00
 |  | 2021-02-10 00:00:00
 |  | 2021-02-11 00:00:00
 |  | 2021-02-12 00:00:00
 |  | 2021-02-13 00:00:00
 |  | 2021-02-14 00:00:00
 |  | 2021-02-15 00:00:00
 |  | 2021-02-16 00:00:00
 |  | 2021-02-17 00:00:00
Spreadsheet: 808483d1670492340-combine-2-sheets-grade-6
Sheet: WANAFUNZI 5 BORA NA 5 DUNI

HALMASHAURI YA WILAYA [NAME]
MATOKEO YA MTIHANI WA KUMALIZA MUHULA WA PILI  DARASA LA V  NOVEMBA,2022
E. WANAFUNZI 5 BORA
NA | JINA | JINSI 1=MV 2= MS | SHULE | KATA | MASOMO |  |  |  |  |  |  |  |  |  |  |  |  |  | JUMLA | WASTANI | DARAJA
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
[NAME] DUNI
NA | JINA | JINSI 1=MV 2= MS | SHULE | KATA | MASOMO |  |  |  |  |  |  |  |  |  |  |  |  |  | JUMLA | WASTANI | DARAJA
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
Spreadsheet: 766015d1643724138-conditional-formatting-alternating-rows-by-group-and-id-cjohnsondbh
Sheet: Sheet1

Part ID | Column 1 | Column 2 | Column 3 |  |  |  |  |  | 0
1 | b2 | c2 | d2
1 | b3 | c3 | d3
2 | b4 | c4 | d4
2 | [NAME] | c5 | d5
2 | b6 | c6 | d6
2 | b7 | c7 | d7
2 | b8 | c8 | d8
2 | b9 | c9 | d9
3 | b10 | c10 | d10
3 | b11 | c11 | d11
3 | b12 | c12 | d12
Spreadsheet: 883703d1732355688-calculating-balance-unit-based-on-transaction-type-balance-units
Sheet: Sheet1

 |  |  |  |  | TXN DATE | TICKER | TYPE | UNITS | PRICE | Balance Units
 |  |  |  |  | 2023-07-13 00:00:00 | X1 | Buy | 120 | 167.4989166666666 | 0
 |  |  |  |  | 2023-07-13 00:00:00 | X1 | Buy | 179 | 167.543687150838 | 99
 |  |  |  |  | 2023-07-13 00:00:00 | X1 | Buy | 1 | 167.5 | 1
 |  |  |  |  | 2023-10-31 00:00:00 | X1 | Buy | 10 | 247.989 | 10
 |  |  |  |  | 2023-10-31 00:00:00 | X1 | Buy | 44 | 247.9888636363636 | 44
 |  |  |  |  | 2023-10-31 00:00:00 | X1 | Buy | 146 | 248.0868493150685 | 146
 |  |  |  |  | 2024-08-26 00:00:00 | X1 | Sell | 140 | 449.6101
 |  |  |  |  | 2024-10-07 00:00:00 | X1 | Buy | 75 | 362.8173333333334 | 75
 |  |  |  |  | 2024-10-22 00:00:00 | X1 | Buy | 65 | 394.5436923076923 | 65
 |  |  |  |  | 2024-10-31 00:00:00 | X1 | Sell | 60 | 409.4145
Spreadsheet: 05fe99ce-2e3e-4653-8480-92c54b45c2f3
Sheet: 20. Sustainability

 | FY 2012 Federal Real Property Charts
 | Sustainability Building by [NAME]*
 | Agency | Sustainable | Not Sustainable | Not Yet Evaluated | Not Applicable
 | Agriculture
 | Air Force**
 | Army**
 | Commerce
 | Corps of Engineers**
 | Defense/WHS**
 | Energy
 | Environmental Protection Agency
 | General Services Administration
 | Health and Human Services
 | Homeland Security
 | Interior
 | Justice
 | Labor
 | National Aeronautics And Space Administration
 | National Science Foundation
 | Navy**
 | Office of Personnel Management
 | State
 | State (USAID)
 | Transportation
 | Treasury
 | Veterans Affairs
 | Total
 | † All real property data from the CFO Act agencies required to submit data to the FRPP
 | * Sustainability is reported for all buildings above 5,000 GSF
 | **Department of Defense
Spreadsheet: 759924d1639819517-conditional-format-to-highlight-rows-if-cell-below-matches-pandagurlie-book1
Sheet: report1639761402752 (3)

Account Name | Store ID | Account Manager | Account Status | Routing Request Email | GTIN | Access Email
Account1 | 1468 | Adam | Active | TBD | TBD | [EMAIL]
Account2 | 1484 | [NAME] | Active | No | TBD | [EMAIL]
Account3 | 1483 | [NAME] | Active | No | TBD | [EMAIL]
Account4 | 451 | Adam | Active | Yes | No | [EMAIL]
Account5 | 163 | [NAME] | Active | No | No | [EMAIL]
Account6 | 941 | Quoc | Active | Yes | Yes | [EMAIL]
Account7 | 1036 | [NAME] | Active | Yes | Yes | [EMAIL]
Account8 | 931 | [NAME] | Active | Yes | Yes | [EMAIL]
Account9 | 1345 | Jacobe | Active | TBD | TBD | [EMAIL]
Account10 | 1025 | Kirstie | Active | Yes | TBD | [EMAIL]
Account11 | 1099 | Quoc | Active | TBD | TBD | [EMAIL]
[NAME] | 1141 | [NAME] | Active | Yes | TBD | [EMAIL]
Account13 | 1026 | Kirstie | Active | Yes | TBD | [EMAIL]
Account14 | 1171 | [NAME] | Active | TBD | TBD | [EMAIL]
Account15 | 1385 | [NAME] | Active | TBD | TBD | [EMAIL]
Account16 | 1155 | [NAME] | Active | No | TBD | [EMAIL]
Account17 | 1389 | [NAME] | Active | TBD | TBD | [EMAIL]
Account18 | 1583 | Kirstie | Active | TBD | TBD | [EMAIL]
Account19 | 1359 | Quoc | Active | TBD | TBD | [EMAIL]
Account20 | 1343 | Jacobe | Active | No | TBD | [EMAIL]
Account21 | 1070 | [NAME] | Active | Yes | TBD | [EMAIL]
Account22 | 1068 | [NAME] | Active | Yes | TBD | [EMAIL]
Spreadsheet: eric_saibi__9954__110701R
Sheet: El Dorado 01

Owner Name |  | El Dorado Energy LLC
Station Name |  | El Dorado Energy Merchant Power Station
Unit Name |  | Unit 01 GT/HRSG
NERC Region |  | WSCC
State |  | NV
Fuel Type |  | Natural Gas
Capacity |  | 160 MW
Start Date |  | 2001-11-05 00:00:00
End Date |  | 2001-11-18 00:00:00
Prv. Start Date |  | 2001-11-03 00:00:00
Prv. End Date |  | 2001-11-16 00:00:00
Comments |  | [NAME]
SIC |  | 4931
Plant ID |  | 1034719
Unit ID |  | 1012198
Outage ID |  | 17347
Spreadsheet: 174695d1345149445-similarity-matrix-on-binary-data-book2
Sheet: Sheet1

 |  | Condition 1 | Condition 2 | Condition 3
 | Individual A | 1 | 0 | 1
 | Individual B | 0 | 0 | 1
 | Individual C | 1 | 1 | 1
 |  | Individual A | Individual B | Individual C
 | Individual A
 | Individual B
 | Individual C
Spreadsheet: 38624d1236777051-cant-paste-formulas-through-cells-vlookup-check
Sheet: Sheet3

plnr | id
00 | TR126128
AA1 | 0
AA1 | 0
AA1 | 0
AA1 | 0
N03 | #N/A
N03 | #N/A
N03 | #N/A
N03 | #N/A
N03 | #N/A
N03 | #N/A
N03 | #N/A
N03 | #N/A
N03 | #N/A
N03 | #N/A
N03 | #N/A
N03 | #N/A
N03 | #N/A
N03 | #N/A
N03 | #N/A
N03 | #N/A
N28 | DM108529
N28 | DM108529
N28 | DM108529
N28 | DM108529
N28 | DM108529
N28 | DM108529
N28 | DM108529
N28 | DM108529
N28 | DM108529
N28 | DM108529
N28 | DM108529
N28 | DM108529
 | #N/A
 | #N/A
 | #N/A
 | #N/A
Spreadsheet: 545713d1509632649-conditional-formatting-if-cell-contains-then-format-column-test
Sheet: Sheet1

[NAME] | RDO | RDO | RDO | RDO | RDO | [NAME] | TNG
TNG | RDO | RDO | RDO | RDO | RDO | TNG | TNG
TNG | RDO | RDO | RDO | RDO | RDO | TNG | TNG
TNG | RDO | RDO | RDO | RDO | RDO | TNG | TNG
TNG | RDO | RDO | RDO | RDO | RDO | TNG | TNG
TNG | RDO | RDO | RDO | RDO | RDO | TNG | TNG
TNG | RDO | RDO | RDO | RDO | RDO | TNG | TNG
TNG | RDO | RDO | RDO | RDO | RDO | TNG | TNG
TNG | RDO | RDO | RDO | RDO | RDO | TNG | TNG
TNG | RDO | RDO | RDO | RDO | RDO | TNG | TNG
Spreadsheet: 678818d1590073102-8-hours-worktime-book1
Sheet: Sheet1

Personel | Hour | Date
[NAME] | 3 | 2020-05-21 00:00:00
[NAME] | 2 | 2020-05-21 00:00:00
[NAME] | 4 | 2020-05-21 00:00:00
[NAME] | 3 | 2020-05-21 00:00:00
[NAME] | 1 | 2020-05-21 00:00:00
[NAME] | 2 | 2020-05-21 00:00:00
Alexis | 3 | 2020-05-21 00:00:00
Alexis | 4 | 2020-05-28 00:00:00
Alexis | 3 | 2020-05-28 00:00:00
[NAME] | 2 | 2020-05-28 00:00:00
Alexis | 1 | 2020-05-25 00:00:00
[NAME] | 1 | 2020-05-25 00:00:00
[NAME] | 2 | 2020-05-25 00:00:00
Amanda | 3 | 2020-05-25 00:00:00
Amanda | 2 | 2020-05-25 00:00:00
Spreadsheet: jeffrey_a_shankman__13834__Global_Prod 1-26-01 EM
Sheet: New on 1-26-01 - LTD

New Global Products made available on
that were not available Life to Date
Global Product Short Desc.
For Curr Exch    Forward                 30Jan01         JPY/USDm
For Curr Exch    Forward                 30Jan01         USD/EURm
For Curr Exch    Forward                 30Jan01         USD/GBPm
For Curr Par Fwd Reuters BOFC            26Jan01         CAD/USDm
NOR Bkrptcy Swap Norsk Hydro             26Mar01-26Mar06 USD/bpa
SWE Bkrptcy Swap Birka                   26Mar01-26Mar06 USD/bpa
SWE Bkrptcy Swap Sydkraft                26Mar01-26Mar06 USD/bpa
UK Bkrptcy Swap  Centrica                26Mar01-26Mar06 USD/bpa
UK Bkrptcy Swap  NGC                     26Mar01-26Mar06 USD/bpa
UK Bkrptcy Swap  Norweb                  26Mar01-26Mar06 USD/bpa
UK Bkrptcy Swap  Powergen                26Mar01-26Mar06 USD/bpa
UK Bkrptcy Swap  S & S Engy              26Mar01-26Mar06 USD/bpa
UK Bkrptcy Swap  Scottish Pwr            26Mar01-26Mar06 USD/bpa
UK Bkrptcy Swap  Seeboard                26Mar01-26Mar06 USD/bpa
UK Bkrptcy Swap  Vodafone                26Mar01-26Mar06 USD/bpa
US Bkrptcy Swap  Lockheed Martin         26Mar01-26Mar06 USD/bpa
US Bkrptcy Swap  MCI WorldCom            26Mar01-26Mar06 USD/bpa
US Bkrptcy Swap  Raytheon                26Mar01-26Mar06 USD/bpa
US Bkrptcy Swap  Solectron               26Mar01-26Mar06 USD/bpa
Spreadsheet: 771969d1646934789-sort-function-id-like-as-data-changes-in-table-the-sort-automatically-updates-golf-workings
Sheet: Stats

 | Player | Round 1 Score | Round 2 Score | Round 3 Score | Round 4 Score | Total | Revised | Position | Score | Points | Number of holes in 1
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | Talor Gooch
[NAME] | [NAME] Im
[NAME] | Mackenzie Hughes
[NAME] | [NAME]
Campbell | Jon Rahm
Campbell | Shane Lowry
Campbell | [NAME]
Campbell | [NAME]
Campbell | [NAME]
Campbell | [NAME]
Pearce | [NAME]
Pearce | [NAME]
Pearce | [NAME]
Pearce | [NAME]
Pearce | [NAME]
Pearce | [NAME]
Spreadsheet: chris_germany__1715__on_call_sap 2
Sheet: on_call

Effective 7/5/00, please contact the appropriate functional area for SAP system
problems.  The list below has the contact person(s) extension and pager
number.
SAP Contact List
Updated 6/28/2000
Functional Area | Name | Extension | Pager | Mobile
Global | [NAME] | 39249
 | [NAME] | 56517
 | [NAME] | 33103
 | [NAME] | 34548
 | On-call |  |  | [PHONE]
Settlements | [NAME] | 37686 | [PHONE]
SAP | [NAME] | 39269 | [PHONE]
Treasury | Help Desk | 34727
Spreadsheet: 741139d1626860665-countifs-and-dates-countifs-and-dates-stats-wip
Sheet: josephteh

Current Open Tickets |  |  |  | https://www.excelforum.com/newreply.php?do=postreply&t=1354967
Closed Calls
Total Calls
Calls Per SVD for June | OPEN | CLOSED
HUBBLE BI TEAM
SEAS AP C & VEN
SEAS DEVELOPMENT
SEAS SYS SUPDEV
SEAS Helpdesk
SEAS Interfaces
SEAS SME Escalation
SEAS sys admin
SEAS T & B
Totals
Weekly totals Open | 2021-05-31 00:00:00
HUBBLE BI TEAM
SEAS AP C & VEN
SEAS DEVELOPMENT
SEAS SYS SUPDEV
SEAS Helpdesk
SEAS Interfaces
SEAS SME Escalation
SEAS sys admin
SEAS T & B
Weekly totals closed
HUBBLE BI TEAM
SEAS AP C & VEN
SEAS DEVELOPMENT
SEAS SYS SUPDEV
SEAS Helpdesk
SEAS Interfaces
SEAS SME Escalation
SEAS sys admin
SEAS T & B
Spreadsheet: 249689d1373582013-producing-secondary-table-based-on-drop-down-menu-value-ef500_excel-table
Sheet: July 2013

Completed
In Progress
Client Name | Column1 | Potential Value | Column2
[NAME] | Completed | 2000
[NAME] | Not Started | 2000
[NAME] | In Progress | 2000
[NAME] | Completed | 1500
[NAME] | Not Taken Up | 3000
[NAME] | Not Started | 2000
[NAME] | Completed | 3000
[NAME] | Not Started | 1000
Spreadsheet: 60267d1260832783-formula-to-combine-and-sort-two-tables-by-ascending-value-comparison-calculator-c
Sheet: Sheet1

 |  |  | Boat A |  |  |  |  | Boat B
 |  | RPM | MPH | GPH | MPG |  | RPM | MPH | GPH | MPG |  | RPM | MPH | MPH | GPH | GPH | MPG | MPG
 |  | (x100) |  |  |  |  | (x100) |  |  |  |  | (x100)
 |  | 5 |  |  |  |  | 5 | 2.8 | 0.18 | 15.8 |  | 5
 |  | 10 | 5.3 | 1.4 | 3.79 |  | 10 | 5.5 | 0.73 | 7.5 |  | 10
 |  | 15 | 6.9 | 2.1 | 3.29 |  | 15 | 7.2 | 1.74 | 4.2 |  | 15
 |  | 20 | 8.1 | 3.5 | 2.31 |  | 20 | 9.1 | 4.75 | 1.9 |  | 20
 |  | 25 | 8.7 | 4.5 | 1.93 |  | 25 | 18.8 | 6.03 | 3.1 |  | 25
 |  | 30 | 16.7 | 5.2 | 3.21 |  | 30 | 27.7 | 7.26 | 3.8 |  | 30
 |  | 35 | 27.2 | 6.1 | 4.46 |  | 35 | 34.4 | 9.09 | 3.8 |  | 35
 |  | 40 | 32.9 | 7.6 | 4.33 |  | 40 | 42 | 11.86 | 3.5 |  | 40
 |  | 45 | 39.9 | 10.2 | 3.91 |  | 45 | 47.9 | 14.98 | 3.2 |  | 45
 |  | 50 | 44.4 | 12.5 | 3.58 |  | 50 | 53.3 | 17.02 | 3.1 |  | 50
 |  | 55 | 54.5 | 15.9 | 3.43 |  | 55 |  |  |  |  | 55
 |  | WOT | 56.8 | 17.5 | 3.25 |  | WOT | 58.7 | 20.57 | 2.9 |  | WOT
Spreadsheet: 141996d1329565556-highlight-rows-based-on-corresponding-cell-value-highlight
Sheet: 1

 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Highlight
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Green
3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | Yellow
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | Blue
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | [NAME]
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 | Read
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
Spreadsheet: 101275d1299432647-lookup-for-numeric-values-example-quote
Sheet: Sheet1

 |  |  | [NAME]
 | QTY | SKU | Description | Unit Price | Extension
 | 2 | 4-130
 | 1 | 4-200
 | 4 | 4-150
 | 1 | 4-160
 | 2 | 4-140
 | 2 | 4-120
 |  |  |  | Total
 |  |  | Price List
 |  | SKU | Description | Unit Price
 |  | 4-120 | Description for Product  werg 4-120 | 9500
 |  | 4-130 | Description for Product dbgth 4-130 | 499
 |  | 4-140 | Description for Product ghjrth 4-140 | 2995
 |  | 4-150 | Description for Product trtyjrth | 599
 |  | 4-160 | Description for Product tyukyujk | 299
 |  | 4-200 | Description for Product hrtyh | 3999
Spreadsheet: 160795d1339193725-pull-data-from-multiple-workbooks-sales-tracker
Sheet: Sheet1

Date | User   ID | MSISDN /          Account No. | Product | Services | Items
2012-06-06 19:43:00 | C4563 | 1.221013456 | business monthly plan | blackberry national | 1
2012-06-06 19:43:00 | C4563 | 1.23312345 | micro sim | data prepaid | 1
2012-06-06 19:44:00 | C4563 | [PHONE] | iphone 4s | data plan 2gb | 3
2012-06-06 19:47:00 | C4563 | 5.46321 | dlink 1005 | WAN connection | 5
2012-06-06 19:48:00 | C4563 |  | 5 port switch | New Subscription | 1
2012-06-06 19:48:00 | C4563 |  | samsung [NAME] | New Subscription | 4
2012-06-06 19:49:00 | C4563 |  |  | New Subscription | 1
2012-06-06 19:50:00 | C4563 |  |  | New Subscription | 1
2012-06-06 20:15:00 | C4563 |  |  | New Subscription
2012-06-06 23:36:00 | C4563 |  |  | New Subscription | 1
2012-06-06 23:37:00 | C4563 |  |  | New Subscription | 1
Spreadsheet: 708348d1607741602-multiples-if-functions-report-weekly-calculation-by-finding-previous-wednesday-raypan-
Sheet: Sheet1

History Report |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | from start till now will get 90 days excemption
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sell | 2.01 | all positions opened on 1st october willl get 15 days excemptioin
Customer: |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | buy | -4.11
Period: |  |  | 2020.11.23-2020.12.13 |  |  |  |  |  |  |  |  |  |  |  |  | excemption | 90 | upto | 2020-09-30 00:00:00 | 2020-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | excemption | 15 | after | 2020-10-15 00:00:00
Date: |  |  | 2020.12.12 02:56 |  |  |  |  |  |  |  |  |  |  |  |  | start | 2020-10-16 00:00:00
Closed Accounts
Time | Account |  | Type | Volume |  |  |  | Time | Price | Commission | Charges |  |  |  | no of days | Charged days | Profit
2020.11.23 11:31:15 | 117320 |  | buy | 2 |  |  |  | 2020.12.08 21:58:48 | 1870.06 | -6 | 0
2020.11.24 [NAME] | 117484 |  | sell | 1 |  |  |  | 2020.12.02 15:49:31 | 1814.53 | -3 | 0
2020.12.02 15:49:44 | 118260 |  | buy | 1 |  |  |  | 2020.12.02 18:15:58 | 1826.94 | -3 | 0
2020.12.03 07:53:03 | 118506 |  | buy | 1 |  |  |  | 2020.12.04 04:59:15 | 1844.33 | -3 | 0
2020.12.07 07:22:50 | 119577 |  | sell | 1 |  |  |  | 2020.12.07 16:51:00 | 1852.76 | -3 | 0
2020.12.08 09:18:55 | 119884 |  | buy | 1 |  |  |  | 2020.12.08 17:56:05 | 1866.92 | -3 | 0
2020.12.09 20:17:21 | 120296 |  | sell | 1 |  |  |  | 2020.12.09 20:34:00 | 1835.65 | -3 | 0
2020.12.10 10:54:49 | 120577 |  | buy | 1 |  |  |  | 2020.12.10 15:35:55 | 1842.48 | -3 | 0
Open Acccounts
Time | Position |  | Type | Volume |  |  |  |  | Charges |  |  |  |  |  | no of days | Charged days | Profit |  |  |  | charges start date
2020.10.01 19:47:29 | 118210 |  | sell | 1 |  |  |  |  | 0
2020.12.09 13:54:08 | 120288 |  | buy | 1 |  |  |  |  | 0