tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 102637d1300614871-gantt-style-schedule-schedule
Sheet: Data

Name | Location | Assignment # | Start Date | End Date
[NAME] | LON | 1111 | 2011-02-01 00:00:00 | 2011-02-03 00:00:00
[NAME] | SYD | 2222 | 2011-02-02 00:00:00 | 2011-02-05 00:00:00
[NAME] | NYC | 3333 | 2011-02-03 00:00:00 | 2011-02-05 00:00:00
[NAME] | NYC | 4444 | 2011-02-06 00:00:00 | 2011-02-10 00:00:00
[NAME] | LA | 5555 | 2011-02-08 00:00:00 | 2011-02-09 00:00:00
[NAME] | SYD | 6666 | 2011-02-08 00:00:00 | 2011-02-11 00:00:00
Spreadsheet: 715199d1611599070-sum-dollar-amounts-if-values-in-another-column-match-sheet-excerpt
Sheet: Sheet1

Dept | Course | CRN | Author | Title | ISBN | New $ |  |  | Total Per Section
9-000 | 3-0070R | 34495 | SILVERSTEIN | SPANISH NOW! LEVEL 1: W/ MP3 CD | 978-1-4380-7523-5 | 24.99 |  |  | Dept | Course | CRN | Total Text Cost
9-000 | 3-0071R | 34496 | SILVERSTEIN | SPANISH NOW! LEVEL 1: W/ MP3 CD | 978-1-4380-7523-5 | 24.99
AA | 156 | 34310 | AGAINST THE CLOCK | Adobe InDesign 2020: The Professional Portfolio Spiral-bound – November 23, 2019 | 978-1-946396-36-5 | 59.99
AA | 156 | 34310 | AGAINST THE CLOCK | ADOBE INDESIGN 2019 | 978-1-946396-20-4 | 59.99
AA | 156 | 34310 | PIPES | PRODUCTION FOR GRAPHIC DESIGNERS | 978-0-205-68479-3 | 52.5
AA | 161 | 32498 | LBCC | NO TEXT REQUIRED  10613993 |  | 0
AA | 222 | 33912 | DRUCKER | GRAPHIC DESIGN HISTORY | 978-0-205-21946-9 | 98.54
AA | 222 | 33912 |  |  |  | 7.49
AA | 225 | 33916 |  |  |  | 3.99
AA | 225 | 33916 | LBCC | NO TEXT REQUIRED  10613993 |  | 0
AA | 237 | 33913 | LBCC | NO TEXT REQUIRED  10613993 |  | 0
ANS | 211 | 31365 | WEBER, CLAYTON | ANS 211 COURSE PACKET-18/19 |  | 4.63
ANS | 211 | 31365 | JURGENS | ANIMAL FEEDING & NUTRITION | 978-0-7575-9113-6 | 138.89
ANS | 223 | 30282 | MCDONALD | E-BOOK: STARTING AND RUNNING YOUR OWN HORSE BUSINESS | 978-1-60342-668-8 | 13.3
ANS | 223 | 30282 | MCDONALD | STARTING & RUNNING YOUR OWN HORSE BUSINESS | 978-1-60342-483-7 | 19.95
ANS | 278 | 30312 | LBCC | ANS 278 PKT |  | 6.89
ANS | 278 | 30312 | BOURDON | UNDERSTANDING ANIMAL BREEDING | 978-0-13-096449-6 | 131.93
ANS | 216B | 33432 | WEBER,CLAYTON | ANS 216B COURSE PACKET |  | 3.47
ANTH | 101 | 34261 | ENGELKE | HOW TO THINK LIKE AN ANTHROPOLOGIST | 978-0-691-17878-3 | 29.95
ANTH | 101 | 34261 | LAVENDA | ANTHROPOLOGY | 978-0-19-084068-6 | 99.94
ANTH | 101 | 34261 | LAVENDA | EBOOK: ANTHROPOLOGY | 978-0-19-084069-3 | 49.98
ANTH | 101 | 34261 | ENGELKE | EBOOK: HOW TO THINK LIKE AN ANTHROPOLOGIST | 978-1-4008-8952-5 | 15.82
ANTH | 101 | 34783 | ENGELKE | HOW TO THINK LIKE AN ANTHROPOLOGIST | 978-0-691-17878-3 | 29.95
ANTH | 101 | 34783 | LAVENDA | ANTHROPOLOGY | 978-0-19-084068-6 | 99.94
ANTH | 101 | 34783 | LAVENDA | EBOOK: ANTHROPOLOGY | 978-0-19-084069-3 | 49.98
ANTH | 101 | 34783 | ENGELKE | EBOOK: HOW TO THINK LIKE AN ANTHROPOLOGIST | 978-1-4008-8952-5 | 15.82
ANTH | 110 | 34262 | GUEST | CULTURAL ANTHROPOLOGY: A READER FOR A GLOBAL AGE | 978-1-324-00077-8 | 62.5
ANTH | 110 | 34263 | HAVILAND | CULTURAL ANTHROPOLOGY | 978-1-305-63379-7 | 149.95
ANTH | 210 | 31384 | BOLIN | GROWING UP IN A CULTURE OF RESPECT | 978-0-292-71298-0 | 22.95
APR | 121 | 31446 | HOLT | [NAME] ILLUS GDE TO BASIC ELECTRICAL THEORY | 978-1-932685-39-8 | 70
Spreadsheet: 877470d1724302693-yahtzee-bonus-formula-yahtzee-scorecard
Sheet: Sheet2

Yahtzee
Upper Section |  | How to Score |  | Rae |  |  | Cassia |  |  | [NAME] |  |  | Greg
Ones |  | Sum of All Ones |  |  |  |  | 1 |  |  |  |  |  | 3
Twos |  | Sum of All Twos |  | 8 |  |  |  |  |  | 8
Threes |  | Sum of All Threes |  | 12
Fours |  | Sum of All Fours
Fives |  | Sum of All Fives
Sixes |  | Sum of All Sixes
Sub Total
Bonus if >= 63 |  | Add 35
Total |  | Sum of All Total
Lower Section
3 of a Kind |  | Sum of All Dice |  |  |  |  |  |  |  |  |  |  | 28
4 of a Kind |  | Sum of All Dice |  |  |  |  | 23 |  |  | 27
Full House |  | Score 25
Sm Straight |  | Score 30 |  |  |  |  | 30 |  |  | 30 |  |  | 30
Lg Straight |  | Score 40 |  | 40 |  |  |  |  |  | 40 |  |  | 40
Yahtzee |  | Score 50
Chance |  | Sum of All Dice
 |  | X for Each Bonus
 |  | Score 100 Per X
Total of Lower
Total of Upper
Grand Total
Spreadsheet: 137600d1327249678-extracting-data-from-a-pivot-table-into-rows-copy-of-drop-seq
Sheet: Drop Seq

 |  |  |  |  | [NAME]
Driver | Town | [NAME] |  | Driver | 1 | 2 | 3 | 4 | 5
1 | LETCHWORTH | 1 |  | 1 | LETCHWORTH
2 | GUILDFORD | 1 |  | 2 | GUILDFORD | ALDERSHOT | WOKINGHAM
2 | ALDERSHOT | 2 |  | 3 | LETCHWORTH
2 | WOKINGHAM | 3 |  | 4 | LETCHWORTH
3 | LETCHWORTH | 1 |  | 5 | PENRITH
4 | LETCHWORTH | 1 |  | 6 | WAKEFIELD | YORK
5 | PENRITH | 1 |  | 7 | WINCHESTER | WINCHESTER
6 | WAKEFIELD | 1 |  | 8 | MILTON COMMON | LETCHWORTH
6 | YORK | 2 |  | 9 | BIRMINGHAM
7 | WINCHESTER | 1 |  | 10 | WORCESTER
7 | WINCHESTER | 2
8 | MILTON COMMON | 1
8 | LETCHWORTH | 2
9 | BIRMINGHAM | 1
10 | WORCESTER | 1
Spreadsheet: 13513796-2ae9-4034-9a16-01edbdb4815f
Sheet: Sheet1

Index Investment Data | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
In U.S. Dollars and Futures Equivalent Contracts
 | 2013-12-31 00:00:00 | 2013-12-31 00:00:00 | 2013-12-31 00:00:00 | 2013-12-31 00:00:00 | 2013-12-31 00:00:00 | 2013-12-31 00:00:00
U.S. Futures Market1 | Notional Value (Billions US$) |  |  | Futures Equivalent Contracts3 (Thousands)
(Notional Value > 0.5 billion US$)2 | Long | Short | Net L (S) | Long | Short | Net L (S)
Cocoa | 1.3 | -0.4 | 0.9 | 49 | -16 | 34
Coffee | 3.1 | -1 | 2.1 | 75 | -24 | 51
Copper | 9.3 | -2.1 | 7.2 | 109 | -25 | 84
Corn | 10.1 | -2.8 | 7.3 | 475 | -131 | 344
Cotton | 4.5 | -1.5 | 3 | 107 | -36 | 71
[NAME] | 0.9 | -0.3 | 0.6 | 10 | -3 | 7
Gold | 15.5 | -2.6 | 12.9 | 129 | -22 | 107
Heating Oil | 10.2 | -2.1 | 8.1 | 80 | -17 | 63
[NAME] | 4.1 | -1.2 | 2.9 | 115 | -34 | 80
Live Cattle | 7.9 | -2.3 | 5.6 | 148 | -42 | 106
Natural Gas | 21.9 | -6.9 | 15.1 | 521 | -164 | 358
Platinum | 0.9 | -0.3 | 0.6 | 14 | -4 | 9
RBOB Unleaded Gas | 11.2 | -1.8 | 9.4 | 96 | -15 | 80
Silver | 4.7 | -0.9 | 3.8 | 48 | -9 | 39
Soybean Meal | 4.7 | -1.3 | 3.4 | 111 | -30 | 82
Soybean Oil | 2.8 | -0.8 | 2 | 117 | -33 | 84
Soybeans | 14.9 | -5.2 | 9.7 | 234 | -80 | 155
Sugar | 7.8 | -2.2 | 5.6 | 421 | -117 | 305
Wheat (CBOT) | 6.8 | -2.7 | 4 | 226 | -90 | 135
Wheat (KCBT) | 2.4 | -0.6 | 1.7 | 74 | -20 | 54
WTI Crude Oil | 44.1 | -11.5 | 32.5 | 454 | -118 | 335
Subtotal (>0.5 billion US$) | 189 | -50.4 | 138.6
Subtotal (<0.5 billion US$) | 0.9 | -0.1 | 0.8
Total Notional US Mkts | 189.9 | -50.5 | 139.3
Total Not'l Non-US Mkts | 58.1 | -11.9 | 46.2
Total All Markets | 248 | -62.4 | 185.5
1 Each listed U.S. futures market includes index investment for all futures and OTC markets related to or referenced to that U.S. futures market.  For example, the U.S. market listed as “WTI Crude Oil” includes (with the NYMEX’s Light “Sweet” crude oil futures market) investments held in the NYMEX “Crude Oil Financial” market and the ICE Futures-Europe WTI Light Sweet crude oil market, because both of those contracts’ settlement prices are determined by reference to the NYMEX Light “Sweet” crude oil futures contract.
2 US Futures Markets with 0.5 billion US dollars or more in reported net index investment notional value on the report date.
3Futures Equivalent Contracts: Futures plus delta-adjusted options, estimating what [NAME] would have been established absent offsets.
(See the Explanatory Notes for more details about this data)
Spreadsheet: 722415d1615241978-help-multi-worksheet-if-cell-not-equal-move-to-next-row-excel-help
Sheet: Master

Brand | Status | Vendor | Gender
Low | New | [NAME] | Male
High | New | [NAME] | Male
Low | Carry over | [NAME] | Female
High | Carry over | [NAME] | Female
Spreadsheet: 784407d1655723578-rank-eq-adjust-the-formula-so-that-i-do-not-need-to-refresh-each-time-i-add-or-delete-row-fact-board-testing-version-3
Sheet: Patch Summary

 | Requests Today --------> |  |  |  |  | Requests Today
 | Name | Number | Option | Bed Required |  | Day | Month | Year | Date |  |  | Change? Refresh!
 | ac | [PHONE] | C | 2022-06-24 00:00:00 |  |  |  |  |  |  |  | 1 | ac | [PHONE] | C | 2022-06-24 00:00:00
 | ad | [PHONE] | B | 2022-06-25 00:00:00 |  |  |  |  |  |  |  | 3 | ad | [PHONE] | B | 2022-06-25 00:00:00
 | ae | [PHONE] | C | 2022-06-24 00:00:00 |  |  |  |  |  |  |  | 2 | ae | [PHONE] | C | 2022-06-24 00:00:00
 | af | [PHONE] | A | 2022-06-25 00:00:00 |  |  |  |  |  |  |  | 5 | af | [PHONE] | A | 2022-06-25 00:00:00
Spreadsheet: 90903d1290603271-how-to-insert-a-drop-down-country-list-for-ziva2
Sheet: 21-11-2010

[NAME] | Name | url | Business Area | location
 |  |  | Diamonds & Jewelry | New Forest
 |  |  | Diamonds & Jewelry | New Forest
 | [NAME] |  | Diamonds & Jewelry | [NAME]
 | [NAME] |  | Diamonds & Jewelry | New Forest
 | Rich
 | [NAME]
 | Yehuda
 | Harold
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 92392d1291952162-match-and-countif-match-and-countif-help
Sheet: W13

Player1 |  |  | X |  | X | X | X
Player2 |  | X | X | X
Player3 | X |  | X |  |  |  | X
Player4 |  |  |  |  | X | X | X
Player1 | X | X | X
Player2 |  | X |  | X
Player3 | X |  |  |  | X |  | X
Player4 | X | X |  |  |  | X
Player1
Player2
Player3 | X |  |  |  |  |  | X
Player4 |  |  | X
Spreadsheet: 883432d1732054807-if-and-and-in-the-same-function-if-and-and-formula
Sheet: Invoices (Sales)

Area | [NAME] | Sales Group
 | [NAME] | C34
 | Brent K | U67
 | Brent K | U67
 | [NAME] Q | U67
 | [NAME] Q | U67
 | Naveen W | U00 | I have this IF formula in Column A
 | [NAME] | U00 | IF(@C:C="U67","West 1",IF(@C:C="C34","Mexico",IF(@C:C="U00","Foreign Country","")))
 | Brent K | U00
 |  |  | and I would like the formula to show
 |  |  | IF it is U00 in Column C AND Naveen W in B - I would like column A to show Foreign Country - Naveen W
 |  |  | and all the other U00 in column C to show just Foreign Country
Spreadsheet: 130895d1322648670-comparison-chart-803592
Sheet: Sheet1

Vendor's: A,B,C,D
Prices: 5,10,15,20
what I would like to see is:
A/B/C/D
A 1/2/3/4
B .5/1/1.5/2
C .33/.66/1/1.33
D .25/.5/.75/1
 |  | Vendor | Price |  |  |  | A | B | C | D
 |  | A | 5 |  |  | A
 |  | B | 10 |  |  | B
 |  | C | 15 |  |  | C
 |  | D | 20 |  |  | D
Spreadsheet: phillip_m_love__30649__9907_OA
Sheet: WE-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  WEST
 |  |  | Total |  | Reclasses |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  | 8060
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 149803d1334149075-calculate-time-between-2-dates-and-if-within-time-frame-test
Sheet: Data

Phase | MS | Category | Sent | Received (Date on Letter) | Response Time | Within Time Frame
1 | 1 | Letter | 2011-09-28 00:00:00 | 2011-10-10 00:00:00
1 | 5 | Letter | 2011-09-26 00:00:00 | 2011-10-10 00:00:00
1 | 1 | [NAME]
1 | 2 | [NAME] | 2011-09-26 10:48:00 | 2011-09-28 11:58:00
1 | 3 | [NAME]
1 | 4 | [NAME] | 2011-09-29 12:00:00 | 2011-10-03 15:35:00
1 | 5 | [NAME] | 2011-09-26 11:45:00 | 2011-09-27 15:50:00
1 | 6 | [NAME]
1 | 1 | Ind Email
1 | 2 | Ind Email | 2011-09-29 11:33:00 | 2011-09-29 12:03:00
1 | 3 | Ind Email | 2011-09-26 11:59:00 | 2011-09-26 12:52:00
1 | 4 | Ind Email | 2011-09-29 15:48:00 | 2011-10-05 09:48:00
1 | 5 | Ind Email | 2011-09-26 12:07:00 | 2011-09-26 12:21:00
1 | 6 | Ind Email | 2011-09-27 10:39:00 | 2011-09-27 15:26:00
Spreadsheet: 888455d1738941378-please-help-with-results-table-vlookup-match-index-functions-or-a-table-gymnastics-results-forum
Sheet: team

1 | TEAM 1 | BENCH |  | FLOOR |  | TOP 5 V+F
1 | Gymnast 1 | 7 |  | 6.5 |  |  |  | POINTS
2 | Gymnast 2 | 8 |  | 9 |  |  |  | POSITION
3 | Gymnast 3 | 9 |  | 8.7
4 | Gymnast 4 | 9.1 |  | 4.5 |  |  |  |  |  | = non scoring
5 | Gymnast 5 | 5 |  | 6 |  |  |  |  | TOP 5 GYMNASTS SCORES COUNT
6 | Gymnast 6 | 6.6 |  | 8 |  |  |  |  | TOP 3 INDIVIDUAL BENCH RESULT
 | TOTAL |  |  |  |  |  |  |  | TOP 3 INDIVIDUAL FLOOR RESULT
 |  |  |  |  |  |  |  |  | TOP 3 TEAMS FLOOR AND BENCH COMBINED SCORE
2 | TEAM 2 | BENCH |  | FLOOR |  | TOP 5 V+F |  |  | TOP INDIVIDUAL IN EACH TEAM VAULT "BEST IN TEAM"
7 | Gymnast 7 | 5.5 |  | 4 |  |  |  |  | TOP INDIVIDUAL IN EACH TEAM FLOOR "BEST I TEAM"
8 | Gymnast 8 | 6.8 |  | 6.5
9 | Gymnast 9 | 9.7 |  | 7 |  |  |  |  | BENCH |  | # duplicates | FLOOR |  | # duplicates
10 | Gymnast 10 | 4.5 |  | 9.8 |  |  |  |  | 1st |  |  | 1st
11 | Gymnast 11 | 6 |  | 6.9 |  |  |  |  | 2nd |  |  | 2nd
12 | Gymnast 12 | 7.5 |  | 8.8 |  |  |  |  | 3rd |  |  | 3rd
 | TOTAL
3 | TEAM 3 | BENCH |  | FLOOR |  | TOP 5 V+F |  |  | TEAM SCORES BY SCHOOL |  |  | SCORE
13 | Gymnast 13 | 8 |  | 4.5 |  |  |  | 1st |  |  |  |  | this needs to be in order highest to smallest, if posible?
14 | Gymnast 14 | 9 |  | 6 |  |  |  | 2nd
15 | Gymnast 15 | 7.5 |  | 9.8 |  |  |  | 3rd
16 | Gymnast 16 | 9.9 |  | 6 |  |  |  | 4th
17 | Gymnast 17 | 8 |  | 7.4
18 | Gymnast 18 | 6.5 |  | 8.9
 | TOTAL |  |  |  |  |  |  |  | INDIVIDUAL BENCH |  |  | SCORE | INDIVIDUAL FLOOR |  |  | SCORE
 |  |  |  |  |  |  |  |  | 1st | here should be gymnast names that have 9.9 scire on bench | and here the team name |  | 1st
4 | TEAM 4 | BENCH |  | FLOOR |  | TOP 5 V+F
19 | Gymnast 19 | 5.5 |  | 8
20 | Gymnast 20 | 6.5 |  | 9
21 | Gymnast 21 | 4.9 |  | 8 |  |  |  |  | 2nd | same with9.7 and so on |  |  | 2nd
22 | Gymnast 22 | 8 |  | 8.5
23 | Gymnast 23 | 9 |  | 8.9
24 | Gymnast 24 | 6 |  | 7
 | TOTAL |  |  |  |  |  |  |  | 3rd |  |  |  | 3rd
 |  |  |  |  |  |  |  |  | BEST IN TEAM
 |  |  |  |  |  |  |  |  | TEAM NAME | GYMNAST NAME  BENCH |  | GYMNAST NAME FLOOR
 |  |  |  |  |  |  |  |  |  | here the top scorer bench routine, gymnast name |  | here the top scorer floor routine, gymnast name
Spreadsheet: eric_saibi__9713__010702R
Sheet: Four Corners 03

Owner Name |  | Arizona Public Service Company
Station Name |  | Four Corners Power Station
Unit Name |  | Four Corners 03
NERC Region |  | WSCC
State |  | NM
Fuel Type |  | Coal
Capacity |  | 253 MW
Start Date |  | 2002-01-04 00:00:00
End Date |  | 2002-01-11 00:00:00
Prv. Start Date |  | 2002-01-04 00:00:00
Prv. End Date |  | 2002-01-13 00:00:00
Comments |  | Reliability Work
SIC |  | 4911
Plant ID |  | 1523368
Unit ID |  | 1007554
Outage ID |  | 19374
Spreadsheet: joe_parks__14541__MARGAS
Sheet: feb

sold gas to txu at the prices below
2002-02-01 00:00:00 | 13000 | 2.05
2002-02-02 00:00:00 | 13000 | 2.11
2002-02-03 00:00:00 | 13000 | 2.11
2002-02-04 00:00:00 | 13000 | 2.11
2002-02-05 00:00:00 | 13000 | 2.05
2002-02-05 00:00:00 | 22000 | 2.03
2002-02-06 00:00:00 | 45000 | 2.05
2002-02-07 00:00:00 | 13000 | 2.01
2002-02-08 00:00:00 | 45000 | 2.04
2002-02-09 00:00:00 | 13715 | 2.07
2002-02-09 00:00:00 | 31285 | 2.05
2002-02-10 00:00:00 | 13715 | 2.07
2002-02-10 00:00:00 | 31285 | 2.05
2002-02-11 00:00:00 | 13715 | 2.07
2002-02-11 00:00:00 | 31285 | 2.05
2002-02-12 00:00:00 | 45000 | 2.08
2002-02-13 00:00:00 | 45000 | 2.24
2002-02-14 00:00:00 | 45000 | 2.21
2002-02-15 00:00:00 | 45000 | 2.1
2002-02-16 00:00:00 | 45000 | 2
2002-02-17 00:00:00 | 45000 | 2
2002-02-18 00:00:00 | 45000 | 2
2002-02-19 00:00:00 | 45000 | 2
2002-02-20 00:00:00 | 45000 | 2.08
2002-02-21 00:00:00 | 45000 | 2.27
2002-02-22 00:00:00 | 45000 | 2.19
2002-02-23 00:00:00 | 45000 | 2.16
2002-02-24 00:00:00 | 45000 | 2.16
2002-02-25 00:00:00 | 45000 | 2.16
2002-02-26 00:00:00 | 45000 | 2.32
2002-02-27 00:00:00 | 45000 | 2.32
2002-02-28 00:00:00 | 45000 | 2.3
Spreadsheet: 705764d1606299884-average-last-n-rows-based-on-conditions-example1960_1
Sheet: Sheet1

Player | Desc | Total | Workings | Divisor | Result
Player A |  | 61
Player A |  | 31
Player A |  | 6
Player A | NB | 74
Player A |  | 2 | 2+74+6+31+61 | Divide by 4
Player A |  | 5 | 5+2+74+6+31 | Divide by 4
Player A | NB | 45 | 45+5+2+74+6 | Divide by 3
Player A |  | 87 | 87+45+5+2+74 | Divide by 3
Player B |  | 6
Player B |  | 44
Player B |  | 9
Player B | DNQ | 0
Player B |  | 17 | 17+9+44+6 | Divide by 5
Player B |  | 3 | 3+17+9+44+6 | Divide by 5
Player B | DNQ | 0 | 3+17+9+44+6 | Divide by 5
Player B | DNQ | 0 | 3+17+9+44+6 | Divide by 5
Player B | NB | 1 | 1+3+17+9+44 | Divide by 4
Player B |  | 2 | 2+1+3+17+9 | Divide by 4
Spreadsheet: 741250d1626936592-vlookup-i-want-to-pull-over-pack-sizes-and-costs-to-my-recipe-builder-blank-recipe-builder-test
Sheet: Recipe

 | Menu Item
Base Recipe |  |  |  | 100 | PORTIONS
Ordered Volume |  |  |  | 500 | PORTIONS
 | ITEM | UNIT SIZE | BASE QUANTITY | QUANTITY REQUIRED | UNIT COST | TOTAL COST
 | Column1 | Column3 | Column4 | Column5 | Column6 | Column7
 | PRISONER MoJ CORNED BEEF CRISPBAKE |  | 2
 | ONE WATER 500ML STILL PET |  | 3
 | MoJ SPICED DATE & HONEY CAKE |  | 4
 | SFS SAUSAGE BEANS & CHIPS MEAL |  | 4
 | PRISONER ,Freshways [NAME] Milk |  | 2
 | PRISONER ,3663 Reduced Sugar & Salt Baked Beans In Tomato Sauce |  | 1
 | 80% Minted Lamb Burgers Halal (Tier 2) |  | 0
 | PRISONER ,Freshways [NAME] Milk |  | 0
 | NON PRISONER ,Coca Cola 330Ml Can |  | 0
 | NON PRISONER ,Coca Cola 330Ml Can |  | 0
 | TOTAL COST FOR RECIPE
 | COST PER PORTION
1 | METHOD STATEMENT
2
3
4
5
6
7
 | ALLERGEN INFORMATION |  | NUTRITIONAL INFORMATION
 | GLUTEN |  | Portion [NAME] in [NAME]
 | EGGS |  | CALORIES
 | MILK |  | CARBOHYDRATE
 | CELERY |  | PROTEIN
 | NUTS |  | TOTAL FAT
 | PEANUTS |  | SATURATED FAT
 | SOYA |  | FIBRE
 | FISH
 | CRUSTACEANS
 | SULPHUR DIOXIDE
 | MUSTARD
 | SESAME SEEDS
 | [NAME]
Spreadsheet: 845625d1697051085-subtotal-while-excluding-specific-text-examplespreadsheet
Sheet: Sheet1

 | STORE COUNT | 14 | 15 | 8 |  |  |  | When filtering by Distributor, I need this row to subtotal while excluding "NOT IN POG".
 | VOID COUNT
 | VOID %
Store | Distributor | 3869 | 3869 | 1112 | 471 | 807 | 161
2 | Arctic Dist | 5 | 8 | 8 | NOT IN POG | VOID | NOT IN POG
3 | Arctic Dist | 3 | 3 | NOT IN POG | NOT IN POG | VOID | NOT IN POG
4 | Arctic Dist | NOT IN POG | 4 | 4 | NOT IN POG | VOID | NOT IN POG
5 | Arctic Dist | VOID | VOID | NOT IN POG | NOT IN POG | VOID | NOT IN POG
6 | Arctic Dist | VOID | NOT IN POG | VOID | VOID | VOID | NOT IN POG
8 | Arctic Dist | 3 | 5 | 4 | NOT IN POG | VOID | NOT IN POG
10 | Arctic Dist | 4 | 4 | NOT IN POG | NOT IN POG | VOID | NOT IN POG
11 | Arctic Dist | 1 | 4 | 3 | NOT IN POG | VOID | NOT IN POG
13 | Arctic Dist | 1 | 4 | NOT IN POG | NOT IN POG | VOID | NOT IN POG
14 | Arctic Dist | 3 | 4 | NOT IN POG | NOT IN POG | VOID | NOT IN POG
15 | Arctic Dist | 6 | 11 | NOT IN POG | 5 | VOID | NOT IN POG
16 | Arctic Dist | VOID | VOID | NOT IN POG | 6 | VOID | NOT IN POG
1 | ABC Dist | 3 | 4 | NOT IN POG | NOT IN POG | VOID | NOT IN POG
7 | ABC Dist | 5 | 5 | 5 | NOT IN POG | VOID | NOT IN POG
9 | ABC Dist | NOT IN POG | 3 | 4 | NOT IN POG | VOID | NOT IN POG
12 | ABC Dist | 2 | 1 | VOID | VOID | VOID | NOT IN POG
Spreadsheet: 787838d1658082336-cbbox-that-will-dynamically-show-current-year-month-and-year-2022-07-17-oeldere-pb21uk-payments_to_qi-copy
Sheet: Dashboard

 |  |  |  |  |  |  |  |  |  | Months |  | use |  |  | Months
 |  |  |  |  |  |  |  |  |  | [NAME] |  | Current Month Year |  |  | Jan
 |  |  |  |  |  |  |  |  |  | Feb-2022 |  | Current year |  |  | Feb
 |  |  |  |  |  |  |  | 7 |  | Mar-2022 |  | Current Month |  |  | Mar
 |  |  |  |  |  |  |  |  |  | Apr-2022 |  |  |  |  | Apr
 |  |  |  |  |  |  |  |  |  | May-2022 |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  | Jun-2022 |  |  |  |  | Jun
 |  |  |  |  |  |  |  |  |  | Jul-2022 |  |  |  |  | Jul
 |  |  |  |  |  |  |  |  |  | Aug-2022 |  |  |  |  | Aug
 |  |  |  |  |  |  |  |  |  | Sep-2022 |  |  |  |  | Sep
 |  |  |  |  |  |  |  |  |  | Oct-2022 |  |  |  |  | Oct
 |  |  |  |  |  |  |  |  |  | Nov-2022 |  |  |  |  | Nov
 |  |  |  |  |  |  |  |  |  | Dec-2022 |  |  |  |  | Dec
Spreadsheet: 59823d1260370237-excel-powerpoint-linkage-issue-color_arrows
Sheet: MS v Market

 |  |  |  |  |  |  |  |  |  |  |  |  | p
 |  |  |  |  |  |  |  |  |  |  |  |  | q
 |  | Market Volumes |  | MS   [NAME] |  |  | MS Change Better (p) Worse (q) than Market
 |  |  | 0.01 |  |  | 0 | q
 |  |  | 0.01 |  |  | -0.01 | q
 |  |  | 0.01 |  |  | 0.02 | p
 |  |  | 0.01 |  |  | 0.05 | p
 |  |  | 0 |  |  | 0 | 1
 |  |  | 0.04 |  |  | 0.05 | p
Spreadsheet: 789484d1659113952-count-the-number-of-results-in-a-table-2022-07-29-oeldere-slock92-last-man-standing-1-
Sheet: Week 2

 | Week 2
 | NAME | TEAM
Spreadsheet: 53617-multiple-criterias-in-spreadsheet-example-20of-20what-20is-20required-1-
Sheet: Sheet1

MASTER LIST |  |  |  |  |  |  |  |  | CLIENT LIST
ID | Acct # | Amount |  |  |  |  |  | ID | Acct # | Amount
11111 | AAA | 500 | OK | 1 | 1 | 1 |  | 11111 | AAA | 1000
11111 | AAA | 1000 | OK | 1 | 1 | 1 |  | 11111 | AAA | 500
22222 | BBB | 5000 | OK | 1 | 1 | 1 |  | 22222 | BBB | 5000
22222 | ZZZ | 2500 | OK | 1 | 1 | 1 |  | 22222 | ZZZ | 2500
33333 | CCC | 500 | OK | 1 | 1 | 1 |  | 33333 | CCC | 500
44444 | DDD | 2500 | Check Acct # | 1 | 1 | 2 |  | 44444 | DDD | 2500
44444 | DDD | 1500 | Check Amount | 0 | 1 | 2 |  | 44444 | EEE | 1500
55555 | GGG | 1500 | Check Amount | 0 | #N/A | #N/A |  | 66666 | FFF | 200
55555 | GGG | 1500 | Check Amount | 0 | #N/A | #N/A |  | 66666 | FFF | 200
Summary Totals |  | 16500 |  |  |  |  |  |  |  | 13900 |  | 2600
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] should explain what is the difference and why.
Basically, at the end of the day, I need a summary and details spreadsheet providing me with the following issues:  Master List Amt Total vs. Client List Amt Total -- The difference broken down in a detail spreadsheet(s) --- Could be something like [Perfect Match Spreadsheet] and [Amounts don't match] [ID and amounts match but Acct # is different][Remaining members from Master List] and [Remaining members from Client List]
As an added note, I've tried a VLOOKUP function, but doesn't seem to be the right way of doing this… see example of what happens on the next sheet.  Please help.  I've been working on this for 5 days now..
Spreadsheet: 45167d1243949265-counting-by-2-or-more-criteria-example
Sheet: Sheet1

Count of Job No. | Column Labels
 | Cathy |  | [NAME] |  | Dawn |  | [NAME] |  | [NAME]
Row Labels | S | W | S | W | S | W | S | W | S | W
2009-01-01 00:00:00 |  |  |  | 1
2009-05-01 00:00:00 | 2 |  | 1 |  | 1 |  |  | 2 | 2
2009-05-02 00:00:00 |  |  | 1 | 1 | 2 | 1 |  | 1
2009-05-03 00:00:00 |  | 2 |  | 1 |  |  |  |  | 1 | 2
2009-05-04 00:00:00 | 1 |  | 1 |  |  | 1 |  | 1
2009-05-05 00:00:00 |  | 1 |  |  | 1 |  | 2 |  | 1
Spreadsheet: 70392d1271165025-trim-function-for-special-characters-trim-help
Sheet: Sheet1

FIRST | len | Need formula to remove characters after last letter
HUIQING | 27
DEREK | 27
YANHONG | 27
ART | 27
CHUNGHO | 27
FRANK | 27
PAK-TUNG | 27
WAN | 27
TING | 27
SIMON | 27
MING | 27
SHUHUA | 27
FANG | 27
MAOHONG | 27
PEI | 27
HERMANN | 27
INHO | 27