tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 540742d1506941909-check-count-between-two-cells-interval-count-check
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Answer
 | 1 | 2 | 3 | 4 | 5 | 6 | 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 | INTERVAL
 | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | 5-5-5-5
 | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | 5-5-5-5
 | - | - | - | - | OFF | OFF | - | - | - | - | - | - | OFF | OFF | - | - | - | - | - | - | OFF | OFF | - | - | - | - | - | - | OFF | OFF | - | 6-6-6
 | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | 5-5-5
 | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | - | - | - | - | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | -
 | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | -
 | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | - | - | - | - | - | - | -
 | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | -
 | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | OFF | OFF | -
 | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | -
 | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | -
 |  |  |  |  |  |  |  | Note:
 |  |  |  |  |  |  |  | Start from the OFF in each row
 |  |  |  |  |  |  |  | In the First Row, Off is column E3 & F3, So next there are 5 Hyphens so the output should be 5-5-5-5
 |  |  |  |  |  |  |  | [NAME] and should consider only the hyphen repeats between Off
Spreadsheet: 221048d1363356557-using-solver-with-constraints-solver_investment_mod
Sheet: Solver_investment

 | Stock
 |  |  | % yield |  | Constraints
 | A | 50000 | 0.11 |  | 50000 |  | Min investment for A
 | B | 50000 | 0.18 |  | 100000 |  | Sum investment A, B and C max 100 000
 | C | 0 | 0.11 |  | 500000 |  | [NAME] investment
 | D | 159999.9999999999 | 0.17 |  |  |  | D must be greater than C + 50 000
 | E | 239999.9999999999 | 0.18 |  |  |  | E must be 1,5 times D
 | Total |  |  |  | 250000 |  | No investment must be more than half the portofolio.
 | Object func |  | [NAME] profit
Spreadsheet: daren_farmer__5099__Hot Loads May 00-01
Sheet: May 2000

 | 2000 | 2000 | 2000
 | 5 | 5 | 5
 | 16 | 17 | 18
 | 3 | 4 | 5
Hour 1 | 28296 | 30153 | 30328
Hour 2 | 26998 | 28423 | 28779
Hour 3 | 25783 | 27292 | 27868
Hour 4 | 25200 | 26529 | 27327
Hour 5 | 25243 | 26352 | 27309
Hour 6 | 26710 | 27646 | 28620
Hour 7 | 29762 | 30498 | 31438
Hour 8 | 31232 | 31709 | 32935
Hour 9 | 32378 | 32811 | 34185
Hour 10 | 33929 | 34433 | 36064
Hour 11 | 35648 | 36208 | 38071
Hour 12 | 37335 | 37863 | 39517
Hour 13 | 39145 | 39399 | 40661
Hour 14 | 40722 | 41028 | 41458
Hour 15 | 42436 | 42273 | 42485
Hour 16 | 43719 | 43413 | 43161
Hour 17 | 44574 | 43738 | 43709
Hour 18 | 44488 | 43253 | 43413
Hour 19 | 43508 | 41955 | 42410
Hour 20 | 41647 | 40455 | 41611
Hour 21 | 40985 | 39952 | 40542
Hour 22 | 39960 | 39184 | 39513
Hour 23 | 36768 | 36209 | 36316
Hour 24 | 33001 | 32852 | 32536
[NAME] | 92 | 89 | 88
 | 73 | 73 | 75
Dallas | 88 | 90 | 89
 | 74 | 72 | 66
Houston | 89 | 89 | 87
 | 70 | 73 | 75
Weighted | 89 | 89.45 | 88.05
Average | 72.25 | 72.55 | 70.95
Spreadsheet: 102192d1300200614-count-number-of-patients-present-during-an-hour-episode-recovery-20room-20project-1-
Sheet: Sheet1

Recovery Room Time |  |  |  |  |  | Time
Date | 2011-01-03 00:00:00 |  |  |  |  | Range |  | Patients
Patient | Start Time | End Time |  |  |  | 08:00:00 | 08:59:00
1 | 08:57:00 | 10:28:00 |  |  |  | 09:00:00 | 09:59:00
2 |  |  |  |  |  | 10:00:00 | 10:59:00
3 |  |  |  |  |  | 11:00:00 | 11:59:00
4 |  |  |  |  |  | 12:00:00 | 12:59:00
5 |  |  |  |  |  | 13:00:00 | 13:59:00
6 |  |  |  |  |  | 14:00:00 | 14:59:00
7 |  |  |  |  |  | 15:00:00 | 15:59:00
8 |  |  |  |  |  | 16:00:00 | 16:59:00
9 |  |  |  |  |  | 17:00:00 | 17:59:00
10
11
12
13
14
15
16
17
18
19
20
21
22
Spreadsheet: 675273d1588228991-extract-data-from-multiple-columns-and-rows-to-make-a-single-list-revision-ward-list
Sheet: Meal Register - Catering

CATERING REQUIREMENTS FOR:
WARD | Room No. | Bed  No. | Dietary RequirementS | Breakfast | Lunch | Dinner | Delivered By | Comments |  | Block_row
Spreadsheet: 98403d1297311738-setting-expiry-date-with-conditional-formatting-records-for-data-input
Sheet: DISTR

[NAME]
 |  |  | FIRST | BLUE | HIGH RISK |  |  |  |  |  | SUBSTATION | CONFINED | RIC | TRAFFIC | EARTH | WOOD | SPRAY | INDUCT | PESTICIDE | CUSTOMER | PEST | N/W
 | CERT III | TRADE | AID | CARD | WP, DG | PTR | [NAME] | Metral | EDD | [NAME] | ENTRY | SPACE | (2YR) | MNGT | BORER | POLE INSP | WASH |  |  | O/H | TECH | ACCESS
 | Nil | Nil | (1YR) | Nil |  | (1YR) | (1YR) | ((6 mnths) | (1YR) |  | (2YR) |  |  | (3YR) | (5YR) | Nil | Nil | Nil | Nil | (1YR) |  | AUTH
[NAME] | NO | YES | 2012-01-17 00:00:00 | 153431 | 2013-11-04 00:00:00 | 2012-01-17 00:00:00 | NO | 31/03/2011 C04/03/2011 | 2012-01-17 00:00:00 | 25/07/2013 | 14/05/2011 | 2011-07-02 00:00:00 | 23/03/2011 C 17/02/2011 | 2013-08-23 00:00:00 | 2014-02-08 00:00:00 | 2010-06-29 00:00:00 | Complete | 2007-06-29 00:00:00 | 2007-06-30 00:00:00 |  | 2011-06-30 00:00:00 | YES
[NAME] UNSTEAD | NO | NO | 2012-01-17 00:00:00 | 232078 | 2014-01-09 00:00:00 | 2012-01-17 00:00:00 | NO | NO | 2012-01-17 00:00:00 | 19/06/2014 | 2013-07-03 00:00:00 | NO | 23/02/2011 | NO | NO | 2011-01-14 00:00:00 | Complete |  | NO |  |  | YES
DEON LOWIS | NO | NO | 2012-01-17 00:00:00 | 256249 | 2014-03-10 00:00:00 | 2012-01-17 00:00:00 | 28/06/2011 | 31/03/2011 C04/03/2011 | 2012-01-17 00:00:00 | 30/05/2013 SA LIC | 2/06/2011 | 2011-08-21 00:00:00 | NO | 2012-11-05 00:00:00 | 2014-08-12 00:00:00 | 2011-01-14 00:00:00 | Complete | 2009-03-05 00:00:00 | 2010-12-03 00:00:00 |  | 2011-06-30 00:00:00 | YES
DEREK DE KONING | NO | YES | 2012-01-24 00:00:00 | 153432 | 2013-10-10 00:00:00 | 2012-01-24 00:00:00 | NO | 31/03/2011 C04/03/2011 | 2012-01-24 00:00:00 | 24/06/2012 | 14/05/2011 | 2011-07-02 00:00:00 | 23/03/2011 C 17/02/2011 | 2013-06-30 00:00:00 | 2014-08-12 00:00:00 | 2010-06-01 00:00:00 | Complete | 2007-06-29 00:00:00 | 2007-06-30 00:00:00 |  | 2011-06-30 00:00:00 | YES
GARRY JONES | NO | NO | 2012-01-17 00:00:00 | 289053 | 2014-11-12 00:00:00 | 2012-01-17 00:00:00 | NO | NO | 2012-01-17 00:00:00 | 01/11/2013 SA ONLY | 13/08/2011 | 19/08/2011 | NO | NO | NO | 2010-06-01 00:00:00 | NO | 2009-09-17 00:00:00 | 2010-12-03 00:00:00 |  | 2011-06-30 00:00:00 | YES
GAVIN BOHNEN | YES | YES | 2011-03-10 00:00:00 | 055875 |  |  |  |  |  | 2013-10-16 00:00:00 |  |  |  |  |  |  | Complete | 2006-09-08 00:00:00 |  |  |  | Applied 07/02/2011
JAN V DEVENTER | NO | YES | 2012-01-17 00:00:00 | 247535 | 2014-01-09 00:00:00 | 2012-01-17 00:00:00 | NO | Course 14-15/04/2011 | 2012-01-17 00:00:00 | 2014-10-12 00:00:00 | 2013-01-25 00:00:00 | 2011-07-03 00:00:00 | NO | 2012-12-09 00:00:00 | 14/08/2014 | 2010-09-24 00:00:00 | Complete | 2008-09-25 00:00:00 | NO |  |  | YES - Applied for Sub on 01/02
[NAME] | NO | YES | 2012-01-17 00:00:00 | 283969 | 12/11/2014 | 2012-01-17 00:00:00 | NO | Course 14-15/04/2011 | 2012-01-17 00:00:00 | 17/01/2013 SA ONLY | 13/08/2011 | 19/08/2011 | NO | 2012-11-05 00:00:00 | NO | NO | NO | 2009-09-17 00:00:00 | NO | Applied |  | YES
Spreadsheet: larry_campbell__21310__LFC0700V1
Sheet: PSE E 

Pipeline | Status | ProdYear | ProdMonth | LDCMeter | ReadDate | ReadUnit | Quantity | BillFrom | BillTo | BTU |  | CustomerName
PSE | E | 2000 |  | 2100396056 |  | dth | 800 |  |  |  |  | ABD INC.
PSE | E | 2000 |  | 1100298215 |  | dth | 3000 |  |  |  |  | BENNETT HEAT TREATING CO
PSE | E | 2000 |  | 3100299043 |  | dth | 0 |  |  |  |  | DUROTEST CORPORATION
PSE | E | 2000 |  | 6200296154 |  | dth | 42000 |  |  |  |  | HOMASOTE CO
PSE | E | 2000 |  | 5200295688 |  | dth | 11000 |  |  |  |  | ORTHO PHARMACEUTICAL
PSE | E | 2000 |  | 5200295580 |  | dth | 12000 |  |  |  |  | ORTHO DIAGNOSTIC INC
PSE | E | 2000 |  | 6200695768 |  | dth | 1000 |  |  |  |  | J & J PRODUCTS
PSE | E | 2000 |  | 6200695652 |  | dth | 900 |  |  |  |  | J & J CONSUMER PRODS INC
PSE | E | 2000 |  | 6200697450 |  | dth | 9200 |  |  |  |  | JOHNSON & JOHNSON C P I
PSE | E | 2000 |  | 6200698058 |  | dth |  |  |  |  |  | JOHNSON & JOHNSON
PSE | E | 2000 |  | 5204895280 |  | dth | 6200 |  |  |  |  | ETHICON INC
PSE | E | 2000 |  | 6200695954 |  | dth | 10000 |  |  |  |  | OCEAN SPRAY CRANBERRIES
PSE | E | 2000 |  | 1200495438 |  | dth | 6700 |  |  |  |  | REHEIS CO (NON-FIRM)
PSE | E | 2000 |  | 1200396723 |  | dth | 4300 |  |  |  |  | REHEIS CO (FIRM)
PSE | E | 2000 |  | 4104995568 |  | dth | 700 |  |  |  |  | RIVER RIDGE CONDO ASSOC
PSE | E | 2000 |  | 5101095370 |  | dth | 2500 |  |  |  |  | FRIGIDAIRE CO
PSE | E | 2000 |  | 5200495482 |  | dth | 3200 |  |  |  |  | ANGELICA HEALTH CARE
PSE | E | 2000 |  | 5101195073 |  | dth | 7700 |  |  |  |  | FRIGIDAIRE CO
PSE | E | 2000 |  | 6200698058 |  | dth | 0 |  |  |  |  | JOHNSON & JOHNSON
PSE | E | 2000 |  | 5200195187 |  | dth | 7000 |  |  |  |  | VETERANS HOSPITAL
PSE | E | 2000 |  | 6400696210 |  | dth | 14500 |  |  |  |  | MC GUIRE AIR FORCE BASE
PSE | E | 2000 |  | 6200696268 |  | dth | 1500 |  |  |  |  | PRINCETON PLASMA PHY LAB
PSE | E | 2000 |  | 1200495926 |  | dth | 3400 |  |  |  |  | ORANGE MEMORIAL HOSPITAL
PSE | E | 2000 |  | 2105495338 |  | dth | 4000 |  |  |  |  | BAYONNE HOSPITAL
PSE | E | 2000 |  | TSGCOMM |  | dth |  |  |  |  |  | MARRIOTT,ST JAMES,ST MICHAEL
PSE | E | 2000 |  | FTSCOMM |  | dth |  |  |  |  |  | FTSCOMM-CONOPCOLIPTON-FT.DIX
PSE | E | 2000 |  | 4126098860 |  | dth | 1705 |  |  |  |  | CONOPCO LIPTION
PSE | E | 2000 |  | 6424103686 |  | dth | 11000 |  |  |  |  | FT. DIX
Spreadsheet: 56072d1256203276-average-over-a-text-range-using-a-vlookup-average_over_vlookup
Sheet: Sheet1

a | g | r | a | g | 3.6 |  | g | 5
a | g | r | a | g | AVERAGE(VLOOKUP(A2;H1:I3;2;FALSE);VLOOKUP(E2;H1:I3;2;FALSE)) |  | a | 4
 |  |  |  |  |  |  | r | 0
4 | 5 | 0 | 4 | 5 | 3.6
Spreadsheet: andy_zipper__244__DYNEGY-ICE VOL Jun4
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:
ICE CRUDE PRODUCTS VOLUME: |  | ENRON PERCENTAGE: |  |  |  |  |  |  | Data
 |  |  | Data |  |  | Trader | Product | Qty Units | Transactions | Volume
Trader | Product | Qty Units | Transactions | Volume |  | Carson, M | Firm-LD Peak | MWhs | 6 | 19200
Pimenov, V | NG [NAME], ID, GDD | MMBtus | 1 | 10000 |  |  | Firm-LD Peak Total |  | 6 | 19200
White, B | Crude | bbl | 1 | 180000 |  | Dorland, C | Firm-LD Peak | MWhs | 5 | 10400
Grand Total |  |  | 2 | 190000 |  |  | Firm-LD Peak Total |  | 5 | 10400
 |  |  |  |  |  | Stalford, R | Firm-LD Peak | MWhs | 1 | 14400
 |  |  |  |  |  |  | Firm-LD Peak Total |  | 1 | 14400
 |  |  |  |  |  | Fischer, M | Firm-LD Off-Peak | MWhs | 1 | 6200
 |  |  |  |  |  |  | Firm-LD Off-Peak Total |  | 1 | 6200
 |  |  |  |  |  | Grand Total |  |  | 13 | 50200
Spreadsheet: 42696d1241240166-filtering-for-unique-entries-based-on-one-column-sample
Sheet: WorkSheet2

Issue# | Test Cycle | Test Site | Create Date | Severity
101 | System | Site 1 | 2009-04-01 00:00:00 | 1
102 | System | Site 1 | 2009-04-01 00:00:00 | 1
103 | System | Site 1 | 2009-04-01 00:00:00 | 2
104 | System | Site 1 | 2009-04-05 00:00:00 | 2
105 | Regression | Site 1 | 2009-04-07 00:00:00 | 2
106 | User Acceptance | Site 3 | 2009-04-09 00:00:00 | 1
107 | Regression | Site 2 | 2009-04-23 00:00:00 | 3
108 | System | Site 4 | 2009-04-24 00:00:00 | 1
602 | User Acceptance | Site 4 | 2009-04-29 00:00:00 | 4
Spreadsheet: jeffrey_a_shankman__13928__JCC Swap Model-DPR (JH)
Sheet: Position Report

 | Daily Position Report
 | Date | JCC Position (kL) | JCC Position (bbl) | Brent Equiv JCC Position (bbl) | Enron Brent Hedge Position (bbl) | D Brent Position (bbl)
 | Book Positions (bbl)
 | JCC Book
 | JCC - Brent Equivalent
 | Brent hedge Book
 | Delta
Spreadsheet: drew_fossum__8677__Fixed3
Sheet: Elpaso_6

NORTHERN NATURAL GAS COMPANY
FUEL HEDGING BOOK
EL PASO ENERGY MARKETING COMPANY_6
Prod. | Contract | Contract | Fixed |  | Fuel | Settled | Futures | (Gains) and Losses
Date | Number | Name | Price |  | Dth | Price | Price | Total | Realized | Unrealized
 |  |  |  |  |  | IF-DEMARC |  | (4) | (4) | (4)
2002-06-01 00:00:00 |  | ENA | 3.3 |  | -2000000
2002-07-01 00:00:00 |  | ENA | 3.3 |  | -3000000
2002-08-01 00:00:00 |  | ENA | 3.3 |  | -3000000
2002-09-01 00:00:00 |  | ENA | 3.3 |  | -3000000
2002-10-01 00:00:00 |  | ENA | 3.3 |  | -4000000
2002-06-01 00:00:00 |  | EL PASO | 2.32 |  | -2000000
2002-07-01 00:00:00 |  | EL PASO | 2.32 |  | -3000000
2002-08-01 00:00:00 |  | EL PASO | 2.32 |  | -3000000
2002-09-01 00:00:00 |  | EL PASO | 2.32 |  | -3000000
2002-10-01 00:00:00 |  | EL PASO | 2.32 |  | -4000000
(4)Gain and [NAME] are a measurement of the effectiveness of meeting the stated hedge objective.
Spreadsheet: 836164d1689147857-power-query-conditional-column-calculate-the-multiplier-at-project-level-power-query-condiitonal-column-aligw
Sheet: Sheet1

Month | Project | Sub-Project | Revenue | Cost | Multiplier | Expected Result |  |  |  | Month | Project | Revenue | Cost | Multiplier
202301 | 70049143 | 70049143-102 | 2912 | 516 |  |  |  |  |  | 202301 | 70049143 | 11256 | 2533 | 4.4
202301 | 70049143 | 70049143-103 | 1355 | 516 |  |  |  |  |  | 202301 | 70049164 | 9019 | 3100 | 2.9
202301 | 70049143 | 70049143-108 | 4209 | 703 |  |  |  |  |  | 202302 | 70049164 | 12382 | 3817 | 3.2
202301 | 70049143 | 70049143-109 | 2780 | 798 |  |  |  |  |  | 202302 | 70049143 | 11622 | 2237 | 5.2
202301 | 70049164 | 70049164-203 | 2699 | 774 |  |  |  |  |  | 202303 | 70049143 | 11669 | 3457 | 3.4
202301 | 70049164 | 70049164-204 | 2376 | 852 |  |  |  |  |  | 202303 | 70049164 | 15300 | 3355 | 4.6
202301 | 70049164 | 70049164-206 | 2851 | 553 |  |  |  |  |  | 202304 | 70049143 | 19973 | 5233 | 3.8
202301 | 70049164 | 70049164-207 | 1093 | 921 |  |  |  |  |  | 202304 | 70049164 | 12541 | 3029 | 4.1
202302 | 70049164 | 70049164-203 | 1008 | 860
202302 | 70049164 | 70049164-204 | 4345 | 530
202302 | 70049164 | 70049164-206 | 1032 | 993
202302 | 70049164 | 70049164-207 | 1358 | 682
202302 | 70049164 | 70049164-209 | 4639 | 752
202302 | 70049143 | 70049143-102 | 3854 | 627
202302 | 70049143 | 70049143-103 | 3718 | 653
202302 | 70049143 | 70049143-108 | 4050 | 957
202303 | 70049143 | 70049143-102 | 2732 | 812
202303 | 70049143 | 70049143-103 | 3599 | 834
202303 | 70049143 | 70049143-108 | 1787 | 895
202303 | 70049143 | 70049143-109 | 3551 | 916
202303 | 70049164 | 70049164-203 | 3789 | 663
202303 | 70049164 | 70049164-204 | 3796 | 884
202303 | 70049164 | 70049164-206 | 4920 | 847
202303 | 70049164 | 70049164-207 | 2795 | 961
202304 | 70049143 | 70049143-102 | 3154 | 663
202304 | 70049143 | 70049143-103 | 1290 | 730
202304 | 70049143 | 70049143-108 | 3753 | 828
202304 | 70049143 | 70049143-110 | 3616 | 589
202304 | 70049143 | 70049143-113 | 2854 | 810
202304 | 70049143 | 70049143-118 | 1464 | 909
202304 | 70049143 | 70049143-119 | 3842 | 704
202304 | 70049164 | 70049164-203 | 3608 | 723
202304 | 70049164 | 70049164-204 | 2545 | 814
202304 | 70049164 | 70049164-206 | 4102 | 792
202304 | 70049164 | 70049164-207 | 2286 | 700
Spreadsheet: 687954d1595505689-fill-range-of-cell-rows-based-on-search-criteria-job-search-and-return
Sheet: Entry Log

Time In Date and Time | Time Out Date and Time | Project ID | Group | Processed By | Created By | Tool | Working By | Department | Created | Priority
2020-01-01 00:00:00 | 2020-01-01 01:00:00 | 191231_Capture 123 | RED | [NAME], [NAME] | Hoss, Boss | THIS | Visitor | HERE | 2019-12-31 23:50:33 | (4)Low
2020-01-01 02:15:00 | 2020-01-01 05:35:00 | 191231_Dynamo_D94LPA-112_O | RED | Smith, Bradley | Smith, Bradley | THIS | Technician | HERE | 2020-01-01 01:39:40 | (2)Urgent (Manager's Approval is Required)
2020-01-01 07:15:00 | 2020-01-01 08:45:00 | TUFF 18JGH; YNG71-72 | BLUE | Smith, Bradley | Direction, One | THIS | Technician | THERE | 2019-12-31 16:24:06 | (2)Urgent (Manager's Approval is Required)
2020-01-01 07:20:00 | 2020-01-01 09:45:00 | 191230_BGR_Center | RED | Banes, [NAME] | Yamashirogumi, Tadashi | THIS | Technician | OVER THERE | 2019-12-30 13:22:12 | (1)Task
2020-01-01 09:20:00 | 2020-01-01 11:20:00 | 191231_18EHS_R18-23_Z | BLUE | Price, [NAME] | Direction, One | THIS | Technician | THERE | 2019-12-31 18:36:10 | (2)Urgent (Manager's Approval is Required)
2020-01-01 10:00:00 | 2020-01-01 12:15:00 | 191230_BGR_Edge | RED | Banes, [NAME] | Yamashirogumi, Tadashi | THIS | Technician | OVER THERE | 2019-12-30 13:22:40 | (1)Task
2020-01-01 12:50:00 | 2020-01-01 14:30:00 | 191231_18EHS_R15-17_Z | BLUE | Price, [NAME] | Direction, One | THIS | Technician | THERE | 2019-12-31 18:37:15 | (2)Urgent (Manager's Approval is Required)
2020-01-01 13:00:00 | 2020-01-01 14:35:00 | 191231_Dynamo_D95LPA-112_O | RED | Muyoka, Misses | Smith, Bradley | THIS | Technician | HERE | 2020-01-01 05:44:07 | (2)Urgent (Manager's Approval is Required)
2020-01-01 14:00:00 | 2020-01-01 16:45:00 | 191230_BGR_Edge_2 | RED | Banes, [NAME] | Yamashirogumi, Tadashi | THIS | Technician | OVER THERE | 2019-12-30 13:22:29 | (1)Task
2020-01-01 15:00:00 | 2020-01-01 16:20:00 | TUFF 18AH; YNG03-08 | BLUE | Price, [NAME] | Direction, One | THIS | Technician | THERE | 2019-12-31 18:39:01 | (2)Urgent (Manager's Approval is Required)
2020-01-01 15:00:00 | 2020-01-01 16:10:00 | 190101_1-2_Z | BLUE | King, [NAME] | King, [NAME] | THAT | Technician | OVER THERE | 2020-01-01 14:40:48 | (2)Urgent (Manager's Approval is Required)
2020-01-01 15:15:00 | 2020-01-01 18:45:00 | 191230-RED1-HEREV2 01-09 | RED | TEA PSG Leers, Brennan | [NAME], [NAME] | THIS | Technician | OVER THERE | 2019-12-31 18:52:33 | (2)Urgent (Manager's Approval is Required)
2020-01-01 15:20:00 | 2020-01-01 17:10:00 | TUFF 191231_JOG1-22,23 _Z | RED | Muyoka, Misses | [NAME], [NAME] | THIS | Technician | HERE | 2020-01-01 11:27:40 | (2)Urgent (Manager's Approval is Required)
2020-01-01 16:40:00 | 2020-01-01 18:00:00 | 18TILE: HAH07-08; Z | BLUE | Price, [NAME] | Borjas, [NAME] | THIS | Technician | THERE | 2019-12-31 19:01:10 | (2)Urgent (Manager's Approval is Required)
Spreadsheet: 119198d1314263942-collecting-values-using-different-conditions-test-problem
Sheet: Sheet1

 | ACB 1 |  | ACB 2 |  | ACB 3 |  | ACB 4 |  | ACB 5 |  | ACB 6 |  | ACB 7
DATA FACTURA | QUANT. | VALUE | QUANT. | VALUE | QUANT. | VALUE | QUANT. | VALUE | QUANT. | VALUE | QUANT. | VALUE | QUANT. | VALUE
2011-01-02 00:00:00 | 10 | 100 | 8 | 80 | 152 | 224 | 296 | 368 | 440 | 512
2011-01-09 00:00:00 |  |  | 7 | 70 | 133 | 196 | 259 | 322 |  |  | 511 | 574
2011-01-22 00:00:00 | 15 | 150
2011-02-02 00:00:00 |  |  | 5 | 50 | 95 | 140 | 185 | 230 | 275 | 320 | 365 | 410 | 455 | 500
2011-02-20 00:00:00 | 20 | 200
2011-02-28 00:00:00
2011-03-03 00:00:00 |  |  |  |  |  |  | 100 | 1000
2011-03-20 00:00:00 |  |  | 30 | 300 |  |  |  |  |  |  | 20 | 200
2011-07-27 00:00:00 | 35 | 350
2011-04-25 00:00:00 |  |  |  |  | 250 | 2500 |  |  | 300 | 3000 |  |  | 25 | 250
2011-05-03 00:00:00
2011-05-08 00:00:00 | 25 | 250
2011-05-20 00:00:00 |  |  | 4 | 40 | 76 | 112 | 148 | 184 |  |  |  |  | 364 | 400
2011-06-20 00:00:00 | 40 | 400 | 2 | 20 | 38 | 56 |  |  | 110 | 128 | 146 | 164
 | 2011-01-01 00:00:00 |  | 2011-02-01 00:00:00 |  | 2011-03-01 00:00:00 |  | 2011-04-01 00:00:00 |  | 2011-05-01 00:00:00 |  | 2011-06-01 00:00:00 |  | 2011-07-01 00:00:00
 | Quant. | Value | Quant. | Value | Quant. | Value | Quant. | Value | Quant. | Value | Quant. | Value | Quant. | Value
ACB 1
ACB 2
ACB 3
ACB 4
ACB 5
ACB 6
ACB 7
My result should be the one that appear calculated manually. I would like to get a formula without macros that calculate this result
Spreadsheet: 42841d1241478868-macros-and-assigning-buttons-urgent-help-required-excel-homework
Sheet: Data for charts

 | Anna | [NAME] | [NAME] | Derek | Edna | [NAME]
Monthly salary | 1700 | 1350 | 1440 | 1660 | 1100 | 550
 | Anna | [NAME] | [NAME] | Derek | Edna | [NAME]
Total annual salaries Year 1 | 22440 | 17820 | 19008 | 21912 | 14520 | 7260
Total annual salaries Year 2 | 35175 | 16200 | 23250 | 27000 | 24000 | 37500
Spreadsheet: 854856d1704616252-formula-for-increasing-value-after-no-of-intervals-sample-234-aligw
Sheet: Sheet1

 | Rent Amount | 500
 | Model Period End Date - Annual |  |  | 2024-12-31 00:00:00 | 2025-12-31 00:00:00 | 2026-12-31 00:00:00 | 2027-12-31 00:00:00 | 2028-12-31 00:00:00 | 2029-12-31 00:00:00 | 2030-12-31 00:00:00 | 2031-12-31 00:00:00 | 2032-12-31 00:00:00 | 2033-12-31 00:00:00 | 2034-12-31 00:00:00 | 2035-12-31 00:00:00
 | No. of Days in a Financial year |  |  | 366 | 365 | 365 | 365 | 366 | 365 | 365 | 365 | 366 | 365 | 365 | 365
 | Financial Year Ending |  |  | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035
 | Model Period |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | Incremental Rate | 0.05
 | Interval (Years) | 2
 | Rent
 | The numbers in the factor row are manually written
 | I need to automate them in a manner such that after I change number of intervals (C11) the values in the factor rows change to adjsut for that
Spreadsheet: 162800d1340071701-two-charts-from-one-single-pivot-table-two-charts-from-one-pivot-table
Sheet: Sheet1

 | Carrier | PO | CBM | TEU | FEU
 | APLU | 320 | 2747.829999999999 | 111.5 | 55.75
 | MAEU | 3613 | 15424.356 | 532.75 | 266.375
 | OOLU | 1364 | 11160.274 | 383.75 | 191.875
 | Total
 | I have created two charts using same table. I did it by switching Row/Column.
 |  | Values
 | Carrier | Sum of PO | Sum of CBM | Sum of TEU | Sum of FEU
 | APLU | 320 | 2747.829999999999 | 111.5 | 55.75
 | MAEU | 3613 | 15424.356 | 532.75 | 266.375
 | OOLU | 1364 | 11160.274 | 383.75 | 191.875
 | Grand Total | 5297 | 29332.46 | 1028 | 514
 | Now I want to do the same, i.e want two similar charts, but using
 | pivot table. But while I m trying to switch row/column
 | the pivot table automatically get changed like below!
 |  | Carrier
 | Values | APLU | MAEU | OOLU | Grand Total
 | Sum of PO | 320 | 3613 | 1364 | 5297
 | Sum of CBM | 2747.829999999999 | 15424.356 | 11160.274 | 29332.46
 | Sum of TEU | 111.5 | 532.75 | 383.75 | 1028
 | Sum of FEU | 55.75 | 266.375 | 191.875 | 514
 | I want two charts from on [NAME] table. i.e do not want pivot table
 | changed.