tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 690655d1597225639-index-match-sum-based-on-criteria-index-match-sum
Sheet: Sheet1

OFFSET VALUE |  | 2020-08-10 00:00:00 | 2020-08-11 00:00:00 | 2020-08-12 00:00:00 | 2020-08-13 00:00:00 | 2020-08-14 00:00:00 | 2020-08-17 00:00:00 | 2020-08-18 00:00:00 | 2020-08-19 00:00:00 | 2020-08-20 00:00:00 | 2020-08-21 00:00:00 | 2020-08-24 00:00:00 | 2020-08-25 00:00:00 | 2020-08-26 00:00:00 | 2020-08-27 00:00:00 | 2020-08-28 00:00:00
3 | Current Formula, Wrong answer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Product Criteria
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  | 2020-08-10 00:00:00 | 2020-08-11 00:00:00 | 2020-08-12 00:00:00 | 2020-08-13 00:00:00 | 2020-08-14 00:00:00 | 2020-08-17 00:00:00 | 2020-08-18 00:00:00 | 2020-08-19 00:00:00 | 2020-08-20 00:00:00 | 2020-08-21 00:00:00 | 2020-08-24 00:00:00 | 2020-08-25 00:00:00 | 2020-08-26 00:00:00 | 2020-08-27 00:00:00 | 2020-08-28 00:00:00 |  |  | 3
 | Answer should be | 21 | 121 | 37 | 37 | 57 | 37 | 37 | 32 | 42 | 32 | 32 | 41 | 0 | 0 | 0 |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  | 2020-08-10 00:00:00 | 2020-08-11 00:00:00 | 2020-08-12 00:00:00 | 2020-08-13 00:00:00 | 2020-08-14 00:00:00 | 2020-08-17 00:00:00 | 2020-08-18 00:00:00 | 2020-08-19 00:00:00 | 2020-08-20 00:00:00 | 2020-08-21 00:00:00 | 2020-08-24 00:00:00 | 2020-08-25 00:00:00 | 2020-08-26 00:00:00 | 2020-08-27 00:00:00 | 2020-08-28 00:00:00 | Bank Holiday |  | 7
Product Number |  | 41.4 | 41.4 | 41.4 | 41.4 | 41.4 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 0 |  | 8
1 |  | 20.4 | 20.4 | 20.4 | 20.4 | 20.4 | 19 | 19 | 19 | 19 | 19 | 24 | 24 | 24 | 24 | 24 | Bank Holiday |  | 9
2 |  | 1 | 1 | 1 | 1 | 1 | 5.2 | 5.2 | 5.2 | 5.2 | 5.2 | 7.6 | 7.6 | 7.6 | 7.6 | 7.6 | Bank Holiday |  | 12
3 |  | 11.6 | 11.6 | 11.6 | 11.6 | 11.6 | 23.2 | 23.2 | 23.2 | 23.2 | 23.2 | 24.4 | 24.4 | 24.4 | 24.4 | 24.4 | Bank Holiday |  | 13
4 |  | 0 | 0 | 0 | 0 | 0 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 0 | 0 | 0 | 0 | 0 | Bank Holiday |  | 14
5 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bank Holiday |  | 15
6 |  | 8.4 | 8.4 | 8.4 | 8.4 | 8.4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bank Holiday
7 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bank Holiday
8 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bank Holiday
9 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bank Holiday
10 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bank Holiday
11 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bank Holiday
12 |  | 0 | 0 | 0 | 0 | 0 | 5 | 5 | 5 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | Bank Holiday
13 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bank Holiday
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14 |  | 0 | 0 | 0 | 0 | 100 | 0 | 0 | 20 | 0 | 0 | 0 | 10 | 0 | 0 | 9 | Bank Holiday
15 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bank Holiday
16 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bank Holiday
Spreadsheet: kate_symes__19134__NP 15 pages
Sheet: DJ NP15

 |  |  | Firm | Volume | Firm | Volume | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-04-18 00:00:00 |  | 238.07 | 27808 | 156.7 | 11200
 | 2001-04-17 00:00:00 |  | 238.07 | 27808 | 156.7 | 11200
 | 2001-04-16 00:00:00 |  | 286.52 | 25008 | 213.36 | 10232
 | 2001-04-15 00:00:00 |  |  |  |  |  | 213.36 | 30696
 | 2001-04-14 00:00:00 |  | 268.4 | 18720 | 236.7 | 9400
 | 2001-04-13 00:00:00 |  | 268.4 | 18720 | 236.7 | 9400
 | 2001-04-12 00:00:00 |  | 341.1 | 29680 | 318.17 | 10400
 | 2001-04-11 00:00:00 |  | 348.15 | 35136 | 310.12 | 10400
 | 2001-04-10 00:00:00 |  | 326.44 | 32608 | 301.85 | 13000
 | 2001-04-09 00:00:00 |  | 268.28 | 26320 | 225.55 | 9800
 | 2001-04-08 00:00:00 |  |  |  |  |  | 225.55 | 29400
 | 2001-04-07 00:00:00 |  | 258.22 | 28320 | 196.69 | 9000
 | 2001-04-06 00:00:00 |  | 258.22 | 28320 | 196.69 | 9000
 | 2001-04-05 00:00:00 |  | 301.84 | 30864 | 235.95 | 8200
 | 2001-04-04 00:00:00 |  | 278.15 | 35376 | 204.75 | 9232
 | 2001-04-03 00:00:00 |  | 245.99 | 21936 | 136.34 | 7512
 | 2001-04-02 00:00:00 |  | 228.71 | 17360 | 140.68 | 5000
 | 2001-04-01 00:00:00 |  |  |  |  |  | 142.24 | 15000
 | 2001-03-31 00:00:00 |  | 181.02 | 24000 | 93.46 | 3640
 | 2001-03-30 00:00:00 |  | 181.94 | 20800 | 93.46 | 3640
 | 2001-03-29 00:00:00 |  | 178.38 | 28864 | 87.16 | 10496
 | 2001-03-28 00:00:00 |  | 142.39 | 35120 | 78.18 | 4400
 | 2001-03-27 00:00:00 |  | 140.58 | 29520 | 76.2 | 4000
 | 2001-03-26 00:00:00 |  | 266.09 | 24560 | 155.06 | 6160
 | 2001-03-25 00:00:00 |  |  |  |  |  | 153.65 | 16680
 | 2001-03-24 00:00:00 |  | 270.02 | 21120 | 152.5 | 5840
 | 2001-03-23 00:00:00 |  | 270.02 | 21120 | 152.5 | 5840
 | 2001-03-22 00:00:00 |  | 294.15 | 12720 | 177.94 | 7200
 | 2001-03-21 00:00:00 |  | 406.47 | 10320 | 234.87 | 5400
 | 2001-03-20 00:00:00 |  | 391.63 | 25920 | 261.33 | 9000
 | 2001-03-19 00:00:00 |  | 362.59 | 19760 | 274.08 | 10440
Spreadsheet: 0c853bbf-9a24-4f69-b05b-829dd918068e
Sheet: dep-PartConcept-depAgg

[NAME] elements which have a dep-partConcept-deprecatedAggregateConcept
CashAndCashEquivalentsDomain
CollaborativeArrangementIncomeStatementClassificationsAndAmounts
DefaultsOfShortTermAndLongTermDebtAbstract
DistributionMadeToMemberOrLimitedPartnerCashDistribution
DistributionMadeToMemberOrLimitedPartnerDate
[NAME]
EffectOnFutureEarningsAndCashFlowsAmount
ExplanationOfTheDifferenceQualitativeAndQuantitative
FairValueDisclosureOffBalanceSheetRisksAmount
FairValueDisclosureOffBalanceSheetRisksFaceAmount
FairValueLiabilitiesMeasuredOnRecurringBasisBorrowings
FairValueLiabilitiesMeasuredOnRecurringBasisBorrowingsValuationTechniques
FreshStartBalanceSheetFreshStartBalanceSheetDate
FreshStartBalanceSheetProFormaBalanceSheetDate
GeneralPartnersCapitalAccountValueNetOfOfferingCosts
ImpactOfRestatementOnOpeningPartnersCapital
IncreaseDecreaseInAirTrafficLiability
LimitedPartnersCapitalAccountValueNetOfOfferingCosts
NewAccountingPronouncementsOrChangeInAccountingPrincipleByTypeOfChangeAxis
PaymentsForProceedsFromDemandSideManagementProgram
PreferredStockDividendRatePercentageOrPerDollarAmount
PreferredUnitsValueNetOfOfferingCosts
ServicingAssetAtFairValueDescriptionOfChangesInValuationInputsOrChangesInAssumptions
ServicingAssetsAndServicingLiabilitiesAtFairValueValuationTechniques
ServicingLiabilityAtFairValueDescriptionOfChangesInValuationInputsOrChangesInAssumptions
ShareBasedCompensationArrangementByShareBasedPaymentAwardDiscountFromMarketPrice
SignificantCommitmentDescription
SignificantCommitmentRemainingMinimumAmountCommitted
SignificantPurchaseAndSupplyCommitmentExcludingLongtermCommitmentByTypeAxis
SignificantPurchaseAndSupplyCommitmentExcludingLongtermCommitmentLineItems
SignificantPurchaseAndSupplyCommitmentExcludingLongtermCommitmentTable
SignificantPurchaseAndSupplyCommitmentExcludingLongtermCommitmentTypeDomain
TypeOfChangeDomain
VariableInterestCarryingAmount
VariableInterestCarryingAmountAbstract
VariableInterestCarryingAmountAssets
VariableInterestCarryingAmountLiabilities
Spreadsheet: 186136d1349939338-delivery-scheduling-delivery-scheduling
Sheet: CurrentRoute

Current Route Pattern
Monday |  |  | Distance Travelled | Tuesday | Distance Travelled | Wednesday | Distance Travelled | Thursday | Distance Travelled | Friday | Distance Travelled
738 [NAME] |  |  |  | 738 [NAME] |  | 738 [NAME] |  | 738 [NAME] |  | 738 [NAME]
15 Benoi Rd 629888 |  |  |  | 202 Ang Mo Kio Ave 3 560202 |  | Tuas South Ave 8 637558 |  | 15 Benoi Rd 629888 |  | 1001 Yishun Industrial Park A 768743
50 Gul Rd 629351 |  |  |  | 347 Ang Mo Kio Ave 3 560347 |  | 50 Gul Rd 629351 |  | 50 Gul Rd 629351 |  | 51 [NAME] A 768726
139 Woodlands Industrial Park E5 757506 |  |  |  | 127 Toa Payoh Lor 1 310127 |  | 139 Woodlands Industrial Park E5 757506 |  | 2 Benoi Place 629924 |  | 738 [NAME]
21 Woodlands Industrial Park E1 757720 |  |  |  | 745 Geylang Rd 389653 |  | 21 Woodlands Industrial Park E1 757720 |  | 11 Senoko Way 758032
21 Marsiling Lane 730021 |  |  |  | 524 Hougang Ave 6 530524 |  | 10 Admiralty Street 757695 |  | 51 [NAME] A 768726
113 Marsiling Rise 730133 |  |  |  | 322 Hougang Ave 5 530322 |  | 16 Tagore Lane 787476 |  | 347 Sembawang Rd 758355
211 Marsiling Crescent 730211 |  |  |  | 51 [NAME] A 768726 |  | 22 Sin Ming Road 570022 |  | 33 Sembawang Rd 779084
51 [NAME] A 768726 |  |  |  | 807 [NAME] 760807 |  | 1 Clover Way 579077 |  | 202 Ang Mo Kio Ave 3 560202
11 Senoko Way 758032 |  |  |  | 51 [NAME] A 768726 |  | 51 [NAME] A 768726 |  | 347 Ang Mo Kio Ave 3 560347
20 Senoko Loop 758153 |  |  |  | 738 [NAME] |  | 738 [NAME] |  | 51 [NAME] A 768726
19 Woodlands Sector 1 738080 |  |  |  |  |  |  |  | 738 [NAME]
171 Yishun Ave 7 760171
51 [NAME] A 768726
738 [NAME]
Total Distance Travelled
Test Model |  |  |  |  |  |  |  | Goods Volume (%)
Destinations | Easting | Northing |  | Planned Route (From) | Planned Route (To) |  | 1 | 100
738 [NAME] |  |  |  | 738 [NAME] |  |  | 2
15 Benoi Rd 629888 |  |  |  |  |  | 1.9 | 3
50 Gul Rd 629351 |  |  |  |  |  | 2 | 4
139 Woodlands Industrial Park E5 757506 |  |  |  |  |  | 2.1 | 5
21 Woodlands Industrial Park E1 757720 |  |  |  |  |  | 2.3 | 6
21 Marsiling Lane 730021 |  |  |  |  |  | 2.7 | 7
113 Marsiling Rise 730133 |  |  |  |  |  | 3.6 | 8
211 Marsiling Crescent 730211 |  |  |  |  |  | 4 | 9
51 [NAME] A 768726 |  |  |  |  |  | 5.4 | 10
11 Senoko Way 758032 |  |  |  |  |  | 6.4 | 11
20 Senoko Loop 758153 |  |  |  |  |  | 9.9 | 12
19 Woodlands Sector 1 738080 |  |  |  |  |  | 29.1 | 13
171 Yishun Ave 7 760171 |  |  |  |  |  | 30.4 | 14
51 [NAME] A 768726 |  |  |  |  |  |  | 15
738 [NAME] |  |  |  |  |  |  | 16
Spreadsheet: mary_fischer__25615__32L
Sheet: E16.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032L
COMPANY NAME   Jovinole Associates
ANALYSIS OF (GAIN) LOSS ON SALES OF ASSETS
FOR THE 3 MONTHS ENDED 3-31-2001
**LIST ALL PROPERTY SALES INCLUDING SALES OF REGULATORY ASSETS
**REGULATED COMPANIES DO NOT SHOW (GAIN)/LOSS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  | (A) | + | (B) | + | (C) |  |  | + | (D) | + | (E) | + | (F) | + | (G) |  |  | =
 |  |  |  | GROSS SALE PROCEEDS |  |  |  | NET BOOK VALUE |  |  |  |  |  |  |  |  |  | OTHER (EXPLAIN) |  |  |  | (GAIN) LOSS
 |  | DATE |  |  |  | N/R OR OTHER |  | ASSET |  |  |  |  |  | ACCUM |  | EXP ASSOC |  | AMOUNT |  | HYPERION |  | DR / (CR)
[NAME] OF ASSET |  | OF SALE |  | CASH | + | (EXPLAIN BELOW) | + | AMOUNT |  | HYPERION ACCT | + | PP&E | + | [NAME] | + | WITH SALE | + | DR (CR) |  | ACCT | = | ENDING BAL |  | COMMENTS
PROCEEDS OR BOOK VALUE OF ASSETS
OF $1,000,000 OR MORE:
SALES OF PP&E
SALES OF OTHER ASSETS
 |  |  |  |  |  | (B)
OTHER (LESS THAN $1,000,000) :
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ACCT 1676
 |  | EXPLAIN: |  |  |  |  |  |  |  |  |  |  |  |  | Hyperion Income Accts :  DR/(CR)
 |  | Notes Receivable |  |  |  |  |  |  |  |  |  |  |  |  |  | Signs are reversed from Hyperion
 |  | (list amounts and terms):
 |  | Other:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  |  |  | (B)
Spreadsheet: 176df378-437b-4c40-9a9d-448a767303a3
Sheet: Suppl Table I

Supplementary Table S2 Pairwise Spearman's rank correlation between DM, tAI and 5'UTR structure for nonribosomal genes and partial correlations controlling for tAI, 5'UTR and TATA
Data type |  |  | YEPD medium |  |  | SD medium
X | Y | Z | Pairwise correlation cor(X,Y) or partial correlation pcor(X,Y|Z) | P-value | Number of genes | Pairwise correlation cor(X,Y) or partial correlation pcor(X,Y|Z) | P-value | Number of genes
DM | tAI | - | 0.15 | 7.81e-12 | 2051 | 0.144 | 2.64e-10 | 1906
DM | 5'UTR | - | -0.075 | 0.000642 | 2051 | -0.133 | 6.25e-09 | 1906
tAI | 5'UTR | - | -0.201 | 1.38e-22 | 2318 | -0.201 | 1.38e-22 | 2318
DM | tAI | 5'UTR | 0.138 | 2.67e-10 | 2051 | 0.119 | 1.53e-07 | 1906
DM | 5'UTR | tAI | -0.046 | 0.0366 | 2051 | -0.105 | 3.93e-06 | 1906
DM | tAI | TATA | 0.141 | 1.3e-10 | 2043 | 0.137 | 1.77e-09 | 1898
DM | 5'UTR | TATA | -0.055 | 0.0134 | 2043 | -0.115 | 5.16e-07 | 1898
Spreadsheet: 80344d1280507877-pivot-table-calcfield
Sheet: Sheet1

Project | Category | Costs | Sqft |  |  | Sum of Costs_Sqft | Column Labels
A | 1 | 1000 | 100 |  |  | Row Labels | A | B | Grand Total
A | 1 | 1000 | 200 |  |  | 1 | 6.666666666666667 | 20 | 10
A | 2 | 1000 | 100 |  |  | 2 | 10 | 7.5 | 8.333333333333334
A | 3 | 2000 | 50 |  |  | 3 | 40 | 0 | 40
A | 4 | 3000 | 30 |  |  | 4 | 100 | 0 | 100
B | 1 | 2000 | 100 |  |  | Grand Total | 16.66666666666667 | 11.66666666666667 | 14.74358974358974
B | 2 | 1500 | 200
Spreadsheet: 72859d1273581929-counting-consecutive-cells-example
Sheet: Sheet1

 | APRIL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 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 | 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 | 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
Person A
Person B
Person C
Person D
 | Total Days Home |  |  |  |  |  | Total Days Away
Person A
Person B
Person C
Person D
Days Away
Days Home
Spreadsheet: 154770d1336561123-summing-up-for-specific-criteria-papacheese_book1_08may12_02
Sheet: Sheet1

Before |  |  |  |  |  |  |  |  |  |  |  | After
A1 | 4 |  | A | 1 |  | A,B1,B,C |  |  |  |  |  | A1 | 4 |  | A | 1 |  | A,B1,B,C |  |  |  | a | b1 | b | c
A2 | 3 |  | B | 1 |  | D,E,F,A3,A1 |  |  |  |  |  | A2 | 3 |  | B | 1 |  | D,E,F,A3,A1 |  |  |  | d | e | f | a3 | a1
A3 | 5 |  | C | 2 |  | G,H,I,J |  |  |  |  |  | A3 | 5 |  | C | 2 |  | G,H,I,J |  |  |  | g | h | i | j
A4 | 6 |  | D | 2 |  |  |  |  |  |  |  | A4 | 6 |  | D | 2
B1 | 5 |  | E | 5 |  |  |  |  |  |  |  | B1 | 5 |  | E | 5
B2 | 5 |  | F | 4 |  |  |  |  |  |  |  | B2 | 5 |  | F | 4
B3 | 3 |  | G | 6 |  |  |  |  |  |  |  | B3 | 3 |  | G | 6
B4 | 4 |  | H | 6 |  |  |  |  |  |  |  | B4 | 4 |  | H | 6
C1 | 3 |  | I | 4 |  |  |  |  |  |  |  | C1 | 3 |  | I | 4
C2 | 3 |  | J | 2 |  |  |  |  |  |  |  | C2 | 3 |  | J | 2
[NAME] | 3 |  |  |  |  |  |  |  |  |  |  | [NAME] | 3
C4 | 3 |  |  |  |  |  |  |  |  |  |  | C4 | 3
Spreadsheet: 730324d1619638506-referencing-cells-example
Sheet: Names

Ruby
[NAME]
Clarence
[NAME]
[NAME]
[NAME]
Carol
[NAME]
[NAME]
[NAME]
Gunther
Theodore
[NAME]
Phillipe
[NAME]
[NAME]
Vicky
Jasmine
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Cuba
[NAME]
Timothy
[NAME]
[NAME]
etc.
Spreadsheet: ef55f344-c59c-471a-a48c-35d298c89e5f
Sheet: Sheet1

Beregning af restbeholdning af CO2-kvoter | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Emissions- og oxidationsfaktorer oplyses årligt af Energistyrelsen
Årstal:
Celler med blå tal skal erstattes med jeres egne tal
 |  |  |  | Årets
 | Forbrug af N-gas Nm³ | Brændvær-di GJ/m³ | Energifor-brug GJ | Emissions-faktor kg/GJ | Oxidations-faktor | Udledning i alt tons CO2 | Køb(+) salg(-) | Restbehold-ning i tons CO2
 |  |  |  |  |  |  | Tildelt kvote=> | 50000
Jan | 1138370 | 0.0396 | 45079.452 | 56.74 | 1 | 2557.80810648 | 0 | 47442.19189352
Feb | 1514915 | 0.0396 | 59990.63400000001 | 56.74 | 1 | 3403.868573160001 | -2000 | 42038.32332036
Mar | 1644713 | 0.0396 | 65130.63480000001 | 56.74 | 1 | 3695.512218552 | 3000 | 41342.811101808
Apr | 1071653 | 0.0396 | 42437.4588 | 56.74 | 1 | 2407.901412312 | 0 | 38934.909689496
Maj | 700000 | 0.0396 | 27720 | 56.74 | 1 | 1572.8328 | -10000 | 27362.076889496
Jun | 600000 | 0.0396 | 23760 | 56.74 | 1 | 1348.1424 | 0 | 26013.934489496
Jul | 500000 | 0.0396 | 19800 | 56.74 | 1 | 1123.452 | 0 | 24890.482489496
Aug | 500000 | 0.0396 | 19800 | 56.74 | 1 | 1123.452 | 0 | 23767.030489496
Sep | 660000 | 0.0396 | 26136 | 56.74 | 1 | 1482.95664 | 0 | 22284.073849496
Okt | 1100000 | 0.0396 | 43560 | 56.74 | 1 | 2471.5944 | 0 | 19812.47944949599
Nov | 1200000 | 0.0396 | 47520.00000000001 | 56.74 | 1 | 2696.2848 | 0 | 17116.19464949599
Dec | 1600000 | 0.0396 | 63360.00000000001 | 56.74 | 1 | 3595.0464 | -12000 | 1521.148249495993
 | 12229651
 |  |  |  |  | I alt udledning af CO2 fra naturgas: | 27478.851750504 | [NAME]
Spreadsheet: 889788d1740703882-unpivot-via-formula-with-multiple-header-rows-using-formula-and-return-as-dynamic-array-unpivot-via-dynamic-array-formula-with-multiple-rows
Sheet: Sheet1

 |  |  | Fiscal 2025 | Fiscal 2026 | Fiscal 2027
 |  |  | Jun | Jul | Aug |  | Return all records: |  |  |  |  |  |  | Remove blank records: |  |  |  |  |  |  | Desired Result as dynamic array
A | A-1 | A-2 | 9 | 9 |  |  |  | A-1 | A-2 | Fiscal 2025 | Jun | 9 |  |  | A-1 | A-2 | Fiscal 2025 | Jun | 9 |  | A | A-1 | A-2 | Fiscal 2025 | Jun | 9
B |  |  | 2 | 7 |  |  | B | B-1 | B-2 | Fiscal 2025 | Jun | 2 |  | B | B-1 | B-2 | Fiscal 2025 | Jun | 2 |  | B |  |  | Fiscal 2025 | Jun | 2
C |  |  | 10 | 9 |  |  | C | C-1 | C-2 | Fiscal 2025 | Jun | 10 |  | C | C-1 | C-2 | Fiscal 2025 | Jun | 10 |  | C |  |  | Fiscal 2025 | Jun | 10
D |  |  | 3 | 1 |  |  | D | D-1 | D-2 | Fiscal 2025 | Jun | 3 |  | D | D-1 | D-2 | Fiscal 2025 | Jun | 3 |  | D |  |  | Fiscal 2025 | Jun | 3
E |  |  | 8 | 1 |  |  | E | E-1 | E-2 | Fiscal 2025 | Jun | 8 |  | E | E-1 | E-2 | Fiscal 2025 | Jun | 8 |  | E |  |  | Fiscal 2025 | Jun | 8
F |  |  | 2 | 10 |  |  | F | F-1 | F-2 | Fiscal 2025 | Jun | 2 |  | F | F-1 | F-2 | Fiscal 2025 | Jun | 2 |  | F |  |  | Fiscal 2025 | Jun | 2
G |  |  | 2 | 10 |  |  | G | G-1 | G-2 | Fiscal 2025 | Jun | 2 |  | G | G-1 | G-2 | Fiscal 2025 | Jun | 2 |  | G |  |  | Fiscal 2025 | Jun | 2
H |  |  | 9 | 7 |  |  | H | H-1 | H-2 | Fiscal 2025 | Jun | 9 |  | H | H-1 | H-2 | Fiscal 2025 | Jun | 9 |  | H |  |  | Fiscal 2025 | Jun | 9
I |  |  | 5 | 7 |  |  | I | I-1 | I-2 | Fiscal 2025 | Jun | 5 |  | I | I-1 | I-2 | Fiscal 2025 | Jun | 5 |  | I |  |  | Fiscal 2025 | Jun | 5
 |  |  |  |  |  |  | A | A-1 | A-2 | Fiscal 2026 | Jul | 9 |  | A | A-1 | A-2 | Fiscal 2026 | Jul | 9 |  | A | A-1 | A-2 | Fiscal 2026 | Jul | 9
 |  |  |  |  |  |  | B | B-1 | B-2 | Fiscal 2026 | Jul | 7 |  | B | B-1 | B-2 | Fiscal 2026 | Jul | 7 |  | B |  |  | Fiscal 2026 | Jul | 7
 |  |  |  |  |  |  | C | C-1 | C-2 | Fiscal 2026 | Jul | 9 |  | C | C-1 | C-2 | Fiscal 2026 | Jul | 9 |  | C |  |  | Fiscal 2026 | Jul | 9
 |  |  |  |  |  |  | D | D-1 | D-2 | Fiscal 2026 | Jul | 1 |  | D | D-1 | D-2 | Fiscal 2026 | Jul | 1 |  | D |  |  | Fiscal 2026 | Jul | 1
 |  |  |  |  |  |  | E | E-1 | E-2 | Fiscal 2026 | Jul | 1 |  | E | E-1 | E-2 | Fiscal 2026 | Jul | 1 |  | E |  |  | Fiscal 2026 | Jul | 1
 |  |  |  |  |  |  | F | F-1 | F-2 | Fiscal 2026 | Jul | 10 |  | F | F-1 | F-2 | Fiscal 2026 | Jul | 10 |  | F |  |  | Fiscal 2026 | Jul | 10
 |  |  |  |  |  |  | G | G-1 | G-2 | Fiscal 2026 | Jul | 10 |  | G | G-1 | G-2 | Fiscal 2026 | Jul | 10 |  | G |  |  | Fiscal 2026 | Jul | 10
 |  |  |  |  |  |  | H | H-1 | H-2 | Fiscal 2026 | Jul | 7 |  | H | H-1 | H-2 | Fiscal 2026 | Jul | 7 |  | H |  |  | Fiscal 2026 | Jul | 7
 |  |  |  |  |  |  | I | I-1 | I-2 | Fiscal 2026 | Jul | 7 |  | I | I-1 | I-2 | Fiscal 2026 | Jul | 7 |  | I |  |  | Fiscal 2026 | Jul | 7
Spreadsheet: 818688d1677000298-multiply-a-cell-by-1-of-2-values-based-on-the-cells-value-and-add-others-for-a-total-travel-example
Sheet: Sheet2

KM | Meals | Hotel | Other | Total
4000 | 100 | 350 | 25 |  |  | I am looking for a formula to multiply the first 5000 KM by 0.68 and any KM exceeding 5000 by 0.62, then add Meals, Hotel and Other for a total.
4999 | 50 | 120 | 75
5001 | 95 | 299 | 110
5800 | 150 | 400 | 0
Spreadsheet: 675229d1588201077-pull-multiple-values-for-a-single-cell-with-vlookup-and-with-wildcard-excel-sample
Sheet: Sheet1

SEARCH VALUE |  |  |  |  |  | Vlookup table
123 |  |  |  |  |  | Search value
345 |  |  |  |  |  |  | ABC123 | AAA
456 |  |  |  |  |  |  | 123XYZ | BBB
789 |  |  |  |  |  |  | A123 | CCC
 |  |  |  |  |  |  | 345 | CCC
 |  |  |  |  |  |  | 456 | GGG
 |  |  |  |  |  |  | 456Z | BBB
 |  | NEED | RESULT |  |  | OR
 |  | 123 | ABC123 | AAA |  | 123 | ABC123 | 123XYZ | A123
 |  | 123 | 123XYZ | BBB |  | 345 | 345
 |  | 123 | A123 | CCC |  | 456 | 456 | 456Z
 |  | 345 | 345 | CCC |  | 789 | n/a
 |  | 456 | 456 | GGG
 |  | 456 | 456Z | BBB
 |  | 789 | N/A
Spreadsheet: 2e65b341-71bb-4055-9f7a-81236e333813
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
5093 | 33606 | [NAME] | Soto | ARG | 41 | 00:37:28 | 00:00:00 | 01:16:51 | 00:00:00 | 00:19:32 | 1 | 02:13:51
5093 | 30747 | [NAME] | [NAME] | ARG | 0 | [NAME] | 00:00:00 | 01:16:53 | 00:00:00 | 00:19:58 | 2 | 02:14:19
5093 | 21043 | [NAME] | Granobles | COL | 0 | 00:42:07 | 00:00:00 | 01:19:46 | 00:00:00 | 00:24:00 | 3 | 02:25:54
5093 | 15782 | Jessica | Coronado | COL | 0 | 00:39:22 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 873387d1719885224-add-rows-dynamically-based-on-value-example-add-rows
Sheet: Sheet1

Number of rows
7
Date | Total | Loss | Gain |  |  |  | Date | Amount
2024-06-17 00:00:00 |  |  |  |  |  |  | 2024-06-17 00:00:00 | 4
 |  |  |  |  |  |  | 2024-06-17 00:00:00 | 5.67
 |  |  |  |  |  |  | 2024-06-18 00:00:00 | 9.01
 |  |  |  |  |  |  | 2024-06-18 00:00:00 | -3.45
 |  |  |  |  |  |  | 2024-06-21 00:00:00 | 5.9
 |  |  |  |  |  |  | 2024-07-01 00:00:00 | 69
Spreadsheet: 118336d1313613587-weekly-total-transferred-to-other-workbook-2011-12-money-in-and-out-edited
Sheet: Weekly Winnings

Duddon Sports U16 Premier [NAME]
 | Total in | Winner | Club Funds | Comments | Paid In | Helper Text | Week #
Week 1 | 77 |  | 38.5 |  |  |  | 1
Week 2 | #N/A |  | #N/A |  |  |  | 2
Week 3 | #N/A |  | #N/A |  |  |  | 3
Week 4 | #N/A |  | #N/A |  |  |  | 4
Week 5 | #N/A |  | #N/A |  |  |  | 5
Week 6 | #N/A |  | #N/A |  |  |  | 6
Week 7 | #N/A |  | #N/A |  |  |  | 7
Week 8 | #N/A |  | #N/A |  |  |  | 8
Week 9 | #N/A |  | #N/A |  |  |  | 9
Week 10 | #N/A |  | #N/A |  |  |  | 10
Week 11 | #N/A |  | #N/A |  |  |  | 11
Week 12 | #N/A |  | #N/A |  |  |  | 12
Week 13 | #N/A |  | #N/A |  |  |  | 13
Week 14 | #N/A |  | #N/A |  |  |  | 14
Week 15 | #N/A |  | #N/A |  |  |  | 15
Week 16 | #N/A |  | #N/A |  |  |  | 16
Week 17 | #N/A |  | #N/A |  |  |  | 17
Week 18 | #N/A |  | #N/A |  |  |  | 18
Week 19 | #N/A |  | #N/A |  |  |  | 19
Week 20 | #N/A |  | #N/A |  |  |  | 20
Week 21 | #N/A |  | #N/A |  |  |  | 21
Week 22 | #N/A |  | #N/A |  |  |  | 22
Week 23 | #N/A |  | #N/A |  |  |  | 23
Week 24 | #N/A |  | #N/A |  |  |  | 24
Week 25 | #N/A |  | #N/A |  |  |  | 25
Week 26 | #N/A |  | #N/A |  |  |  | 26
Week 27 | #N/A |  | #N/A |  |  |  | 27
Week 28 | #N/A |  | #N/A |  |  |  | 28
Week 29 | #N/A |  | #N/A |  |  |  | 29
Week 30 | #N/A |  | #N/A |  |  |  | 30
Week 31 | #N/A |  | #N/A |  |  |  | 31
Week 32 | #N/A |  | #N/A |  |  |  | 32
 |  | Total | #N/A |  | 0 |  |  | 0
 |  | Total in House | #N/A
Spreadsheet: 42117d1240664571-bar-graph-problem-anyone-know-how-681123
Sheet: Sheet1

 | Data | a | b | c | d | e | f | g | h |  |  | Key
g | 9 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 9 | #N/A |  | a | 1
d | 6 | #N/A | #N/A | #N/A | 6 | #N/A | #N/A | #N/A | #N/A |  | b | 1
c | 5 | #N/A | #N/A | 5 | #N/A | #N/A | #N/A | #N/A | #N/A |  | c | 1
f | 3 | #N/A | #N/A | #N/A | #N/A | #N/A | 3 | #N/A | #N/A |  | d | 1
b | 3 | #N/A | 3 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | e | 1
a | 3 | 3 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | f | 1
e | 2 | #N/A | #N/A | #N/A | #N/A | 2 | #N/A | #N/A | #N/A |  | g | 1
h | 1 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 1 |  | h | 1