tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 731148d1620210417-getting-rounded-numbers-to-add-up-test-1-
Sheet: Sheet2

Contract End Date | Contract [NAME] | Term Lock-In Date | Result
 |  | 2022-08-31 00:00:00
 |  | 2021-12-09 00:00:00
 |  | 2022-02-19 00:00:00
 |  | 2022-01-28 00:00:00
 |  | 2022-03-28 00:00:00
 |  | 2021-05-24 00:00:00
 |  | 2022-05-25 00:00:00
 |  | 2022-05-22 00:00:00
 |  | 2022-05-25 00:00:00
 |  | 2022-05-25 00:00:00
 |  | 2022-05-22 00:00:00
 |  | 2022-09-11 00:00:00
 |  | 2022-06-15 00:00:00
 |  | 2022-05-12 00:00:00
 |  | 2021-11-18 00:00:00
 |  | 2021-12-14 00:00:00
 |  | 2021-11-16 00:00:00
 |  | 2022-05-20 00:00:00
 |  | 2022-05-20 00:00:00
 |  | 2022-05-23 00:00:00
 |  | 2022-05-25 00:00:00
 |  | 2022-05-21 00:00:00
 |  | 2021-05-20 00:00:00
 |  | 2023-04-10 00:00:00
 |  | 2022-04-12 00:00:00
 |  | 2022-04-16 00:00:00
 |  | 2022-05-31 00:00:00
 |  | 2021-05-31 00:00:00
 |  | 2021-06-04 00:00:00
 |  | 2022-10-15 00:00:00
 |  | 2021-05-27 00:00:00
 |  | 2021-10-29 00:00:00
 |  | 2022-01-04 00:00:00
 |  | 2022-03-10 00:00:00
 |  | 2021-05-16 00:00:00
 |  | 2022-04-16 00:00:00
 |  | 2021-05-07 00:00:00
 |  | 2022-04-12 00:00:00
 |  | 2022-10-28 00:00:00
 |  | 2021-11-30 00:00:00
 |  | 2021-05-09 00:00:00
 |  | 2022-01-05 00:00:00
 |  | 2020-08-02 00:00:00
 |  | 2021-09-13 00:00:00
 |  | 2022-08-02 00:00:00
 |  | 2022-08-05 00:00:00
 |  | 2022-08-01 00:00:00
 |  | 2021-06-03 00:00:00
 |  | 2020-05-07 00:00:00
 |  | 2021-05-07 00:00:00
 |  | 2021-06-07 00:00:00
 |  | 2021-06-07 00:00:00
 |  | 2021-06-02 00:00:00
 | 2021-07-07 00:00:00 | 2021-06-09 00:00:00
 |  | 2022-04-15 00:00:00
 |  | 2022-04-15 00:00:00
 | 2022-06-30 00:00:00 | 2022-06-02 00:00:00
 |  | 2022-10-16 00:00:00
 |  | 2020-04-16 00:00:00
 |  | 2022-04-24 00:00:00
 |  | 2022-04-16 00:00:00
 |  | 2022-05-06 00:00:00
 |  | 2022-05-06 00:00:00
 |  | 2022-05-03 00:00:00
 |  | 2021-05-31 00:00:00
 |  | 2022-11-26 00:00:00
 |  | 2022-06-17 00:00:00
 |  | 2022-01-10 00:00:00
 |  | 2022-04-09 00:00:00
 |  | 2022-07-03 00:00:00
 |  | 2018-12-15 00:00:00
 |  | 2022-12-09 00:00:00
 |  | 2023-01-01 00:00:00
 |  | 2021-11-30 00:00:00
 |  | 2022-01-15 00:00:00
 |  | 2021-08-28 00:00:00
 |  | 2022-06-30 00:00:00
 |  | 2022-06-20 00:00:00
 |  | 2022-03-16 00:00:00
 |  | 2021-07-13 00:00:00
 |  | 2021-07-29 00:00:00
 |  | 2022-12-09 00:00:00
 |  | 2021-10-03 00:00:00
 |  | 2022-10-04 00:00:00
 |  | 2020-10-01 00:00:00
 |  | 2020-10-03 00:00:00
 |  | 2022-10-07 00:00:00
 |  | 2022-10-04 00:00:00
 |  | 2022-04-30 00:00:00
 |  | 2022-04-30 00:00:00
 |  | 2022-04-29 00:00:00
 |  | 2021-04-29 00:00:00
 |  | 2022-04-24 00:00:00
 |  | 2022-04-11 00:00:00
 |  | 2020-05-20 00:00:00
 |  | 2020-05-26 00:00:00
 |  | 2021-05-20 00:00:00
 |  | 2020-05-30 00:00:00
 |  | 2020-05-20 00:00:00
 |  | 2021-05-21 00:00:00
 |  | 2023-03-05 00:00:00
 |  | 2022-10-31 00:00:00
 |  | 2022-07-31 00:00:00
 |  | 2022-12-31 00:00:00
 |  | 2021-12-31 00:00:00
 | 2021-11-30 00:00:00 | 2021-11-19 00:00:00
 |  | 2022-05-24 00:00:00
 |  | 2021-05-25 00:00:00
 |  | 2022-05-24 00:00:00
 |  | 2022-05-25 00:00:00
 |  | 2022-05-23 00:00:00
Spreadsheet: 98335d1297278563-conditional-adding-function
Sheet: Pivot

 | Data |  |  | Results Should Be:
A | Sum of B | Sum of C
apple | 0 | 9 |  | apple | 0 | 9
banana | 5 | 7 |  | banana | 5 | 7
carrot | 6 | 0 |  | blank | blank | blank
grape | 6 | 0 |  | blank | blank | blank
Grand Total | 17 | 16 |  | Total | 5 | 16
Data Set
A | B | C
apple | 0 | 5
apple | 0 | 1
apple | 0 | 3
banana | 3 | 0
banana | 0 | 1
banana | 2 | 6
carrot | 4 | 0
carrot | 2 | 0
grape | 5 | 0
grape | 1 | 0
Totals
 |  |  |  |  |  |  | Like to group column A handling apples together, and bananas together etc.  The number or row of apples and bananas etc. is variable as is the selection of what is in column A.  Can have any number or type of each.  If there is a value in column C then want to total column C  for apples and B for apples.  So in the example apples would be B=0 and C=1.  Totals for bananas would be B=2 and C=1.  Since there is nothing in column C for carrots they would be ignored, or [NAME] and C=0.
 |  |  |  |  |  |  | How can I write the formula that only totals things if there is an amount in C for each group of what is in A?
Spreadsheet: 146812d1332358513-vlookup-and-choose-excel-forum-test
Sheet: Sheet1

2
 |  | In January I want to vlookup a14 on this sheet
 |  | against a14:a29 on Sheet2
 |  | =VLOOKUP(A14,Sheet2!A14:M29,2,FALSE)
 |  | But in February
 |  | I want to vlookup a14 on this sheet |  |  |  | But I also want to choose |  |  | =CHOOSE(Sheet1!A1,SUM(Sheet2!B14),SUM(Sheet2!B14:C14,SUM(Sheet2!B7:D14),SUM(Sheet2!B7:E14),SUM(Sheet2!B7:F14),SUM(Sheet2!B7:G14),SUM(Sheet2!B7:H14),SUM(Sheet2!B7:I14),SUM(Sheet2!B7:J14),SUM(Sheet2!B7:[NAME]:L14),SUM(Sheet2!B7:M14)))
 |  | =VLOOKUP(A14,Sheet2!A14:M29,2,FALSE) |  |  |  |  |  |  | =
 |  | YTD
 |  | JAN
1234567891011
1234567891012
1234567891013
1234567891014
1234567891015
1234567891016
1234567891017
1234567891018
1234567891019
1234567891020
1234567891021
1234567891022
1234567891023
1234567891024
1234567891025
1234567891026
Spreadsheet: 541567d1507380884-possible-bug-sorted-referenced-cells-in-second-sheet-are-classed-as-erroneous-errors
Sheet: Full Table

Product Name | Year | Creator | Product Type | Condition | Score A | Score B | Score C | Score D | Score E | Score F | Score G | Prelim. Total | Prelim. Score | Pos. A | Score H | Percentage A | Value A | Ratio A | Value B | Percentage B | Ratio B | Points | Score | Pos. B | Vs. A
A | 1999 | User A | Conventional | Used | 61 | 58 | 34 | 8 | 38 | 52 | 24 |  |  |  | 31 | 3 | 97 |  | 152 | 10
B | 2005 | User B | Modern | Used | 57 | 52 | 37 | 30 | 58 | 49 | 40 |  |  |  | 36 | 5 | 101 |  | 28 | 2
C | 2002 | User C | Conventional | Used | 75 | 70 | 81 | 90 | 75 | 73 | 84 |  |  |  | 100 | 2 | 78 |  | 2281 | 462
D | 2011 | User C | Modern | Used | 66 | 64 | 60 | 71 | 62 | 63 | 64 |  |  |  | 33 | 3 | 85 |  | 890 | 119
E | 2013 | User D | Modern | New | 50 | 49 | 28 | 39 | 53 | 51 | 36 |  |  |  | 16 | 0 | 80 |  | 5137 | 554
F | 2015 | User C | Modern | New | 54 | 52 | 34 | 78 | 60 | 49 | 44 |  |  |  | 9 | 1 | 96 |  | 2659 | 231
G | 1989 | User E | Conventional | Used | 64 | 63 | 67 | 44 | 50 | 65 | 58 |  |  |  | 16 | 21 | 104 |  | 11061 | 1625
H | 2012 | User A | Modern | New | 24 | 38 | 7 | 20 | 26 | 29 | 14 |  |  |  | 18 | 18 | 89 |  | 81 | 7
I | 1975 | User E | Conventional | Used | 89 | 82 | 97 | 100 | 90 | 90 | 98 |  |  |  | 72 | 23 | 96 |  | 50185 | 17743
J | 2010 | User F | Modern | New | 76 | 69 | 85 | 93 | 83 | 72 | 80 |  |  |  | 34 | 19 | 94 |  | 49622 | 8272
Spreadsheet: 684359d1593332885-how-to-automatically-get-next-destinations-sample-data
Sheet: Sheet1

Monthly Target |  | Current Cost | 1ST Target | 2nd Target | 3rd Target | 4th Target | 5th Target | 6th Target
300000 | A | 95637 |  |  |  |  |  |  |  |  |  | Destinations
300000 | B |  |  |  |  |  |  |  |  |  |  | Locations | Cost
300000 | C |  |  |  |  |  |  |  |  |  |  | City M | 32567
300000 | D |  |  |  |  |  |  |  |  |  |  | City N | 54238
 |  |  |  |  |  |  |  |  |  |  |  | City O | 95637
 |  |  |  |  |  |  |  |  |  |  |  | City X | 56734
 |  |  |  |  |  |  |  |  |  |  |  | City Y | 25678
 |  |  |  |  |  |  |  |  |  |  |  | City Z | 60800
Spreadsheet: 682776d1592327509-engineer-project-allocation-app-sanitised-tracker
Sheet: Resource

 |  |  |  | Weekdays per month
Requestor | TimeXCode | Project | Work Package | Engineer | Apr-20 | May-20 | Jun-20 | [NAME] | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 | Jan-21 | Feb-21 | Mar-21
Generic |  |  | Tesco Holiday & Absence | Network Engineer 8 |  |  | 5
PM1 |  |  | New Switches | Network Engineer 8 |  |  | 5
DataTransform |  |  | Define network for DC1 | Network Engineer 9 |  |  | 5
PM1 |  |  | New Array | Network Engineer 9 |  |  | 2
DataTransform |  |  | Define network for DC1 | Network Engineer 11 |  |  | 6
PM2 |  |  | Configure firewall | Network Engineer 11 |  |  | 8
PM1 |  |  | New Array | Storage Engineer 15 |  |  | 7
Generic |  |  | Holiday & Absence | Storage Engineer 15 |  |  | 14
Spreadsheet: e3c14cb5-ec4b-4905-abe2-f229305326ca
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44481232 | 2014-12-17 10:45:28 | AXIS | 0 | 0 | 6 | 1266695 | Robben1 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
44481313 | 2014-12-17 11:07:32 | ALLIES | 0 | 4 | 6 | 1266695 | Robben1 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
Spreadsheet: john_zufferli__16804__marks
Sheet: Sheet1

 |  |  |  |  |  |  | Jan 2, 2002
 |  | *2001 actual published PP
 |  |  | flat | on | off |  | 2002 | BID | OFFER | MID
 |  | JAN* | 131.23 | 145.5 | 113.1 |  | JAN | 33.5 | 34.5
 |  | FEB* | 116.75 | 134.4 | 93.16 |  | FEB | 32 | 34.5
 |  | MAR* | 97.23 | 114.6 | 73.12 |  | MAR | 32 | 34.5
 |  | APR* | 114.82 | 138.4 | 85.25 |  | APR | 31 | 32.5
 |  | MAY* | 88.34 | 107.4 | 61.85 |  | MAY | 31 | 32.5
 |  | JUN* | 63.59 | 79.85 | 41.34 |  | JUN | 31 | 32.5
 |  | JUL* | 53.47 | 64.64 | 40.48 |  | JUL | 37 | 39
 |  | AUG* | 52.37 | 63.54 | 36.91 |  | AUG | 37 | 39
 |  | SEP* | 29.84 | 35.9 | 23.11 |  | SEP | 37 | 39
 |  | OCT* | 43.92 | 54.2 | 29.73 |  | OCT | 39 | 41
 |  | NOV* | 33.31 | 42.28 | 22.09 |  | NOV | 39 | 41
 |  | DEC | 33.3 |  |  |  | DEC | 39 | 41
 |  |  |  |  |  |  | Cal 2002
Spreadsheet: 15e24365-0062-4210-87f9-bdd935b8f434
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
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 30. LEASE FINANCE COMMITMENTS, By Industry: Australia ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Agriculture, forestry and fishing ; |  |  | Original | A2420286X | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Mining ; |  |  | Original | A2420287A | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Manufacturing ; |  |  | Original | A2420288C | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Construction ; |  |  | Original | A2420289F | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Wholesale trade ; |  |  | Original | A2420290R | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Retail trade ; |  |  | Original | A2420291T | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Transport and storage ; |  |  | Original | A2420292V | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Finance and insurance ; |  |  | Original | A2420293W | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Property and business services ; |  |  | Original | A2420294X | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Cultural, recreational, personal and other services ; |  |  | Original | A2420295A | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Public Administration ; |  |  | Original | A2420296C | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Health and community services ; |  |  | Original | A2420297F | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Other industries ; |  |  | Original | A2420298J | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2420299K | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: sally_beck__33929__Weekly Operating Report 2-1
Sheet: Data

New Deals |  |  |  | Contracts
Physical Gas | 6500 |  |  |  | Gas On-System | Gas Off-System | Power
Financial Gas | 7500 |  |  | Buy | 2 | 6 | 3
Physical Power | 4000 |  |  | Sell | 3 | 10 | 2
Financial Power | 55 |  |  | Transport | 4 | 2 | 0
Physical Lumber | 3 |  |  | Storage | 0 | 0 | 0
Financial Lumber | 5
Physical Newsprint | 10
Financial Newsprint | 20
 |  |  |  | New Deals
Financial Liquids | 50 |  |  |  | 12/29 - 1/4 | 1/5 - 1/11 | 1/12 - 1/18 | 1/19 - 1/25 | 1/26 - 2/2
IR/FX | 175 |  |  | Gas |  |  |  |  |  |  | MMBTU
Weather | 2 |  |  | Power |  |  |  |  |  |  | MHtz
Physical Pulp | 20 |  |  |  | 12/29 - 1/4 | 1/5 - 1/11 | 1/12 - 1/18 | 1/19 - 1/25 | 1/26 - 2/2
Financial Pulp | 30 |  |  | IR/FX |  |  |  |  |  |  | BBL
Physical Steel | 1 |  |  | Liquids |  |  |  |  |  |  | TONNE
Financial Steel | 3 |  |  | Coal |  |  |  |  |  |  | HDD/CDD
Coal | 2 |  |  | Weather |  |  |  |  |  |  | USD
Physical Liquids | 65 |  |  | Emissions |  |  |  |  |  |  | CONTRACTS
Emissions | 10 |  |  |  | 12/29 - 1/4 | 1/5 - 1/11 | 1/12 - 1/18 | 1/19 - 1/25 | 1/26 - 2/2
 |  |  |  | Newsprint |  |  |  |  |  |  | TONNE
M&A | 0 |  |  | Pulp |  |  |  |  |  |  | TONNE
Legal | 0 |  |  | Lumber |  |  |  |  |  |  | TONNE
Lease | 0 |  |  | Steel |  | 0 | 0 | 0 |  |  | TONNE
Auction | 1
Gas | 1300 |  |  | [NAME]
Power | 250 |  |  |  | 12/29 - 1/4 | 1/5 - 1/11 | 1/12 - 1/18 | 1/19 - 1/25 | 1/26 - 2/2
Others | 50 |  |  | MMBTU
Lumber | 0 |  |  | MHtz
Power | 250 |  |  |  | 12/29 - 1/4 | 1/5 - 1/11 | 1/12 - 1/18 | 1/19 - 1/25 | 1/26 - 2/2
 |  |  |  | Total EIM
Newsprint | 0 |  |  | Newsprint
Pulp | 5 |  |  | Pulp
Steel | 0 |  |  | Lumber
 |  |  |  | Steel
Power | 250 |  |  |  | 12/29 - 1/4 | 1/5 - 1/11 | 1/12 - 1/18 | 1/19 - 1/25 | 1/26 - 2/2
 |  |  |  | Liquids
EGM |  |  |  | Coal
Liquids | 45 | 40 | 55 | Emissions | 5 | 5
IR/FX | 150 | 120 | 125 | Weather | 49250 | 45350 | 120900 | 115500
 |  |  |  | IR/FX | 6275000 | 6398750 | 3718000 | 6618000
Weather | 2 | 5 | 2
Emissions | 2 | 1 | 10
ENA
Gas | 11000 | 12500 | 12000
Power | 5500 | 5000 | 4055
EIM
Newsprint | 25 | 52 | 30
Pulp | 10 | 42 | 50
Lumber | 8 | 8 | 8
Steel | 3 | 1 | 4
Date | Unit Type | Commodity | Units | New Deals
Wk 1 | MMBTU | Gas | 1350
Wk 1 | MHtz | Power | 180 | 5500
Wk 1 | Loads | Lumber | 8 | 8
Wk 1 | Bails | Newsprint | 15 | 25
Wk 1 | Bars | Steel | 5 | 3
Wk 1 | Buckets | Pulp | 10 | 10
Wk 1 | [NAME] | Liquid | 45 | 45
Wk 1 | Lumps | Coal | 2 | 2
Wk 2 | MMBTU | Gas | 1505
Wk 2 | MHtz | Power | 175 | 5000
Wk 2 | Loads | Lumber | 10 | 8
Wk 2 | Bails | Newsprint | 25 | 52
Wk 2 | Bars | Steel | 7 | 1
Wk 2 | Buckets | Pulp | 30 | 42
Wk 2 | [NAME] | Liquid | 32 | 40
Wk 2 | Lumps | Coal | 2 | 1
Wk 3 | MMBTU | Gas | 1600
Wk 3 | MHtz | Power | 190 | 4055
Wk 3 | Loads | Lumber | 10 | 8
Wk 3 | Bails | Newsprint | 25 | 30
Wk 3 | Bars | Steel | 8 | 4
Wk 3 | Buckets | Pulp | 40 | 50
Wk 3 | [NAME] | Liquid | 37 | 55
Wk 3 | Lumps | Coal | 2 | 2
Spreadsheet: 781790d1653551692-need-formula-to-count-table-range-depending-on-conditions-in-selected-table-columns-hit-miss-alig-extra-fighters-3-
Sheet: Fighter1

 |  |  |  | Hit points:
Date | Result | Style | Attack Defense | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
May 14, 2022 2:00am | Lost | Aggressive | Attack | 140 | 100 | 113 | 81 | 99 | 106 | MISS | 146
 |  |  | Defence | -144 | -180 | MISS | -116 | -185 | -151 | -181 | -147
May 13, 2022 10:30pm | Lost | Defensive | Attack | 177 | 85 | 141 | 137 | 138 | 47 | 182
 |  |  | Defence | -66 | -293 | -89 | -286 | MISS | MISS | -110
May 13, 2022 6:30pm | Lost | Accurate | Attack | 118 | 88 | MISS | 143 | 83 | 178 | 127 | MISS | 90 | 60 | 107
 |  |  | Defence | -124 | -99 | -142 | -58 | -110 | -106 | -85 | -11 | -187 | MISS | -107
May 13, 2022 6:30pm | Won | Aggressive | Attack | 121 | 144 | 198 | 85 | 114 | 107 | 31 | 182 | 98
 |  |  | Defence | -71 | MISS | -99 | -129 | -100 | -73 | MISS | -230
Spreadsheet: 148255d1333302817-how-can-i-format-to-change-cell-color-lottery-numbers
Sheet: Sheet1

WH | WH | WH | WH | WH | PB
18 | 22 | 26 | 28 | 40 | 10
18 | 22 | 26 | 28 | 40 | 10
19 | 45 | 47 | 51 | 55 | 44
6 | 9 | 25 | 45 | 49 | 39
19 | 33 | 37 | 49 | 54 | 17
9 | 27 | 40 | 42 | 56 | 8
12 | 22 | 35 | 41 | 49 | 27
2 | 26 | 30 | 50 | 51 | 8
15 | 18 | 19 | 27 | 53 | 23 | 2
14 | 17 | 21 | 35 | 36 | 14
5 | 6 | 7 | 43 | 46 | 31
11 | 26 | 31 | 39 | 45 | 21
18 | 23 | 26 | 49 | 52 | 14
31 | 33 | 34 | 41 | 42 | 38
22 | 27 | 32 | 38 | 52 | 24
21 | 27 | 40 | 42 | 51 | 19
7 | 18 | 31 | 47 | 48 | 24
2 | 9 | 32 | 34 | 50 | 38
6 | 25 | 35 | 41 | 46 | 37
17 | 21 | 35 | 41 | 52 | 29
6 | 13 | 33 | 45 | 49 | 42
2 | 4 | 23 | 38 | 46 | 23 |  | Drawing 30-3-2012
Spreadsheet: 167984d1342178862-create-different-formulas-based-off-of-yes-or-no-example
Sheet: Sheet1

Week | 1 |  |  |  |  |  |  |  |  | >35
Amount | 1
Multiplier | 2
 | Season 1 |  | Winnings |  | 1 | Odds | Win |  | Odds | Win |  | Odds | Win
 | Team 1 |  |  |  |  | 8 | No |  | 7 | No | 5.5 | 8 | Yes
 | Team 2 |  |  |  |  | 8 | No |  | 7 | Yes
 |  |  |  | Cost
 |  |  |  | Winning
 |  |  |  | Balance
 |  |  |  | So for example in the yellow box I want it to search for a Yes so week 3 will mean cell L12*M12 and would stop searching as there would only be one Yes,
 |  |  |  | and team 2 has a yes in its second week so  I want D13 to times I13*J13.
Spreadsheet: 150946d1334745366-lookup-match-for-the-last-365-days-when-on-seperate-worksheets-examples
Sheet: Summary

 |  |  | Driver Holiday Summary
Driver | year | Sheet Name | Entitlement | Remaining | Sick | 6th Shift | Unpaid
 |  |  | R7 | R9 | R4 | R5 | R6
Name 1 | 2012 |  |  |  |  |  |  |  |  |  |  | S
Name 2 | 2012 |  |  |  |  |  |  |  |  |  |  | 6
Name 3 | 2012 |  |  |  |  |  |  |  |  |  |  | U
Name 4 | 2012 |  |  |  |  |  |  |  |  |  |  | H
Name 5 | 2012 |  |  |  |  |  |  |  |  |  |  | H.5
Driver | year | Sheet Name | Entitlement | Remaining | Sick | 6th Shift | Unpaid
 |  |  | R7 | R9 | R4 | R5 | R6
Name 1 | 2013
Name 2 | 2013
Name 3 | 2013
Name 4 | 2013
Name 5 | 2013
Driver | year | Sheet Name | Entitlement | Remaining | Sick | 6th Shift | Unpaid
 |  |  | R7 | R9 | R4 | R5 | R6
Name 1 | 2014
Name 2 | 2014
Name 3 | 2014
Name 4 | 2014
Name 5 | 2014
Spreadsheet: 477402d1472274938-how-to-count-the-datas-from-multiple-range-procurement-initiatives_pmo-tracker_260816
Sheet: Sheet2

 | RM |  |  | Closed |  |  | Closed |  |  | Closed |  |  | Closed
 | Month |  | 1st week |  |  | 2nd week |  |  | 3rd week |  |  | 4th week
 |  |  | Target | Actual |  | Target | Actual |  | Target | Actual |  | Target | Actual
 | APR
 | MAY
 | JUN
 | JULY
 | AUG
 | SEP
 | OCT
 | NOV
 | DEC
 | JAN
 | FEB
 | MAR
 | PM |  |  | Closed |  |  | Closed |  |  | Closed |  |  | Closed
 | Month |  | 1st week |  |  | 2nd week |  |  | 3rd week |  |  | 4th week
 |  |  | Target | Actual |  | Target | Actual |  | Target | Actual |  | Target | Actual
 | APR
 | MAY
 | JUN
 | JULY
 | AUG
 | SEP
 | OCT
 | NOV
 | DEC
 | JAN
 | FEB
 | MAR
Spreadsheet: 674375d1587806146-summations-between-a-date-range-2020-04-24-oeldere5-pt-674330d1587759212-summations-between-a-date-range-old-feedlot-head-day
Sheet: Sheet1

Month Beginning | 2020-04-01 00:00:00
Period Ending | 2020-04-24 00:00:00
Lot | HR7496 | Harris1
Total Head Days
Correct Summation should be | 294 | 2808
[NAME] (5)
Sumproduct (4)
[NAME] (3)
Subtotal (2)
Date | Harris1 | HR7496 | Harris3 | criteria |  |  | Oeldere Pivot Table (1)
2020-04-01 00:00:00 | 145 | 0 | 0 |  |  |  | criteria | yes
2020-04-02 00:00:00 | 143 | 0 | 0
2020-04-03 00:00:00 | 143 | 0 | 0 |  |  |  | Som van Harris1 | Som van HR7496
2020-04-04 00:00:00 | 143 | 0 | 0 |  |  |  | 2808 | 294
2020-04-05 00:00:00 | 143 | 0 | 0
2020-04-06 00:00:00 | 143 | 0 | 0
2020-04-07 00:00:00 | 143 | 0 | 0
2020-04-08 00:00:00 | 143 | 0 | 0
2020-04-09 00:00:00 | 143 | 0 | 0
2020-04-10 00:00:00 | 143 | 0 | 0
2020-04-11 00:00:00 | 143 | 0 | 0
2020-04-12 00:00:00 | 143 | 0 | 0
2020-04-13 00:00:00 | 143 | 0 | 0
2020-04-14 00:00:00 | 143 | 0 | 0
2020-04-15 00:00:00 | 134 | 0 | 0
2020-04-16 00:00:00 | 134 | 0 | 0
2020-04-17 00:00:00 | 134 | 0 | 0
2020-04-18 00:00:00 | 134 | 0 | 0
2020-04-19 00:00:00 | 134 | 0 | 0
2020-04-20 00:00:00 | 134 | 0 | 0
2020-04-21 00:00:00 | 0 | 0 | 0
2020-04-22 00:00:00 | 0 | 0 | 0
2020-04-23 00:00:00 | 0 | 147 | 0
2020-04-24 00:00:00 | 0 | 147 | 0
2020-04-25 00:00:00 | 0 | 147 | 0
2020-04-26 00:00:00 | 0 | 147 | 0
2020-04-27 00:00:00 | 0 | 147 | 0
2020-04-28 00:00:00 | 0 | 147 | 0
2020-04-29 00:00:00 | 0 | 147 | 0
2020-04-30 00:00:00 | 0 | 147 | 0
 | 0 | 0 | 0
Spreadsheet: 863136d1710710987-rearranging-data-based-on-dates-data-rearrange-version-3-excelforum
Sheet: Sheet1

 | ID | Month | Plan | Actual |  |  | Plan | Actual |  | ID | Plan | Actual
 | A01 | 2024-01-01 00:00:00 | 5 | 4 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00
 | A02 | 2024-02-01 00:00:00 | 4 | 6 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00
 | A03 | 2024-03-01 00:00:00 | 4 | 0 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00
 | A04 | 2024-04-01 00:00:00 | 0 | 3 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00
 |  |  |  |  |  | A01 | 2024-01-01 00:00:00 | No Actual |  | A01 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00
 |  |  |  |  |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00
 |  |  |  |  |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00
 |  |  |  |  |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00
 |  |  |  |  |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00
 |  |  |  |  |  | A02 | No Plan | 2024-02-01 00:00:00 |  | A02 | No Plan | 2024-02-01 00:00:00
 |  |  |  |  |  | A02 | No Plan | 2024-02-01 00:00:00 |  | A03 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00
 |  |  |  |  |  | A03 | 2024-03-01 00:00:00 | No Actual |  | A03 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00
 |  |  |  |  |  | A03 | 2024-03-01 00:00:00 | No Actual |  | A03 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00
 |  |  |  |  |  | A03 | 2024-03-01 00:00:00 | No Actual |  | A03 | 2024-03-01 00:00:00 | No Actual
 |  |  |  |  |  | A03 | 2024-03-01 00:00:00 | No Actual |  | A04 | No Plan | No Actual
 |  |  |  |  |  | A04 | No Plan | 2024-04-01 00:00:00 |  | A04 | No Plan | No Actual
 |  |  |  |  |  | A04 | No Plan | 2024-04-01 00:00:00 |  | A04 | No Plan | No Actual
 |  |  |  |  |  | A04 | No Plan | 2024-04-01 00:00:00
Spreadsheet: 3acd49a4-fc30-4698-85de-ff7dd0c856c1
Sheet: EMBASE

EMBASE
2010-2011
COUNTER-Compliant?: | No
 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | #[NAME]! | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 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 | Total | 2010-2011 Price | Price per unit
EMBASE.com
Sessions | 172 | 65 | 207 | 220 | 191 | 79 | 67 | 405 | 578 | 331 | 154 | 160
Searches | 517 | 143 | 640 | 647 | 598 | 184 | 326 | 2139 | 2191 | 1047 | 499 | 550 |  | 11528
Spreadsheet: 155251d1336743409-excel-2007-line-referenced-drop-downs-hyperlinktotals
Sheet: 1770

 | Rec break 1 |  |  | Rec break 2 |  |  | Rec break 3 |  |  | Rec break 4 |  |  | Rec break 5 |  |  | Rec break 6 |  |  | Rec break 7 |  |  | Rec break 8
 | Value | Description | Date | Value | Description | Date | Value | Description | Date | Value | Description | Date | Value | Description | Date | Value | Description | Date | Value | Description | Date | Value | Description | Date
AUD
CAD
CHF
EUR | 2517.48 | Due from DLS | 2010-10-05 00:00:00 | 16.65 | Due from KMK | 2010-10-05 00:00:00 | 428.4 | Difference on ESP | 2012-05-10 00:00:00 | 20 | Due from DLS | 2010-10-05 00:00:00
GBP | 645.98 | Interest for TNT | 2012-04-12 00:00:00 | 2760 | Interest for TNT2 | 2012-04-12 00:00:00
USD
Spreadsheet: 875516d1722085966-calculating-accounts-receivables-excel-forum-sample
Sheet: Working capital

Working Capital
Sanad Credit Financial Model |  |  |  |  |  |  |  |  |  | Index!A1
Financial Model Currency: JOD
 |  |  | Financial Month End
 |  |  | Financial Year
 | Working capital
 |  |  | Change in Receivables
 |  |  | OPEX
 |  |  | Payables (30days)
 |  |  | Change in Payables
 |  |  | Total change in Working Capital