tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 5c27b215-e4c3-4866-91f2-bd3ea55ae109
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | EcoCheck Data: Patuxent River for all available years | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26
Indicator | 1986 | 1987 | 1988 | 1989 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011
Chlorophyll a | 28.74 | 28.75 | 20.08 | 37.78 | 19.31 | 34.79 | 26.86 | 26.99 | 15.63 | 17.26 | 21.48 | 31.32 | 14.91 | 19.05 | 12.58 | 15.85 | 39.42 | 12.89 | 45.43 | 22.55 | 19.49 | 9.42 | 19 | 14.744 | 5.866 | 10.811
Aquatic Grasses | 2.19 | 5.27 | ND | 0.43 | 0 | 0 | 0 | 1.24 | 9.7 | 9.5 | 12.64 | 11.92 | 13.22 | 0.49 | 10.63 | 16.97 | 17.01 | 17.84 | 18.04 | 16.41 | 14.11 | 9.25 | 12 | 15.1 | 11.87 | 12.1
[NAME] | 66.65 | 41.31 | 58.05 | 52.52 | 62.75 | 55.11 | 73.63 | 58.32 | 58.13 | 72.48 | 64.41 | 64.98 | 58.51 | 69.7 | 58.28 | 56.67 | 71.42 | 58.55 | 65.78 | 52.3 | 61.52 | 65.55 | 66 | 75.37 | 67.444 | 52.9
[NAME] | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | 52 | 72 | 52 | 68 | 32 | 28 | 36 | 24 | 36 | 28 | 20 | 28 | 28 | 16 | 24 | 32
Water Clarity | 17.46 | 21.23 | 23.75 | 17.03 | 8.51 | 17.44 | 18.24 | 6.08 | 4.99 | 13.38 | 3.95 | 3.74 | 3.93 | 20.05 | 1.22 | 10.39 | 7.46 | 4.41 | 2.63 | 7.91 | 3.92 | 5.06 | 3 | 10.227 | 4.87 | 0
Phytoplankton Index | 16.52 | 24.9 | 18.92 | 40.66 | 33.36 | 18.57 | 47.44 | 10.43 | 0.64 | 9.09 | 2.96 | 12.26 | 2.29 | 18.17 | 4.51 | 8.87 | 18.17 | 7.82 | 4.2 | 2.26 | 20 | 2.69 | 11 | 9.650630654 | 28.41 | 3
Water Quality Index | 46.68 | 30.39 | 33.93 | 35.74 | 30.15 | 35.76 | 39.56 | 30.43 | 26.21 | 34.35 | 29.91 | 33.32 | 25.75 | 36.24 | 23.99 | 27.6 | 39.42 | 25.24 | 37.92 | 27.55 | 28.28 | 26.68 | 29 | 33.447 | 26.06 | 21.237
Biotic Index | 9.36 | 15.09 | Insufficient Data | 20.54 | 16.68 | 9.29 | 23.72 | 5.84 | 5.17 | 9.3 | 22.53 | 32.06 | 22.51 | 28.89 | 15.71 | 17.95 | 23.73 | 16.55 | 19.41 | 15.56 | 18.23 | 13.31 | 17 | 13.58354355 | 21.42666667 | 15.7
Bay Health Index | 28.02 | 22.74 | Insufficient Data | 28.14 | 23.42 | 22.52 | 31.64 | 18.13 | 15.69 | 21.82 | 26.22 | 32.69 | 24.13 | 32.57 | 19.85 | 22.78 | 31.57 | 20.9 | 28.67 | 21.55 | 23.25 | 20 | 23.18 | 23.51527178 | 23.74333333 | 18.5
Spreadsheet: 785533d1656480017-index-match-for-multiple-values-in-array-sample-raehan
Sheet: Desired Report Example

EmplID | Name | Effdt | EffSeq | Status | [NAME] | Position Title | Manager [NAME] | Manager [NAME]
28331 | [NAME] | 2015-05-01 00:00:00 | 0 | On Leave | Academic | Associate Librarian | Director | [NAME]
10293
11111 |  |  | 0 |  | SCI
12345 |  |  | 0 |  | HIR
29781
Spreadsheet: 112106d1308251139-dynamic-chart-not-updating-automatically-example_charting3_fix
Sheet: Summary_Indexing

Month | Numbe pages | Target | TAT%
2010-04-01 00:00:00 | 29897 | 0.95
2010-05-01 00:00:00 | 35192 | 0.95 | 0.9721546961325966 |  |  |  |  |  |  |  |  |  |  | chrtindex |  | INDEX(Summary_Indexing!$A:$A, MATCH(9E+307, Summary_Indexing!$A:$A)):INDEX(Summary_Indexing!$D:$D, [NAME], [NAME])
2010-06-01 00:00:00 | 35365 | 0.95 | 0.98
2010-07-01 00:00:00 | 28803 | 0.95 | 0.98 |  |  |  |  |  |  |  |  |  |  | [NAME] |  | INDEX(Summary_Indexing!chrtindex,0,2)
2010-08-01 00:00:00 | 28013 | 0.95 | 0.98
2010-09-01 00:00:00 | 27343 | 0.95 | 0.97 |  |  |  |  |  |  |  |  |  |  | tblindex3 |  | INDEX(Summary_Indexing!chrtindex, 0, 3)
2010-10-01 00:00:00 | 30088 | 0.95 | 0.97
2010-11-01 00:00:00 | 28295 | 0.95 | 0.97 |  |  |  |  |  |  |  |  |  |  | tblindex4 |  | INDEX(Summary_Indexing!chrtindex,0,4)
2010-12-01 00:00:00 | 32194 | 0.95 | 0.95
2011-01-01 00:00:00 | 31690 | 0.95 | 0.98 |  |  |  |  |  |  |  |  |  |  | tblindexMonth |  | INDEX(Summary_Indexing!chrtindex,0,1)
2011-02-01 00:00:00 | 28039 | 0.95 | 0.98
2011-03-01 00:00:00 | 33277 | 0.95 | 0.92
2011-04-01 00:00:00 | 31114 | 0.95 | 0.9788198238734974
2011-04-01 00:00:00 | 30455 | 0.95 | 0.9788198238734974
2011-05-01 00:00:00 | 15 | 0.15 | 0.84
2011-06-01 00:00:00 | 30455 | 0.15 | 0.84
2011-07-01 00:00:00 | 30455 | 0.15 | 0.84
2011-05-01 00:00:00 | 30455 | 0.15 | 0.84
2011-09-01 00:00:00 | 30455 | 0.15 | 0.84
 |  |  |  |  | 1 | SERIES(Summary_Indexing!$B$1,Summary_Indexing!tblindexMonth,Summary_Indexing!tblindex2,1)
 |  |  |  |  | 2 | SERIES(Summary_Indexing!$c$1,Summary_Indexing!tblindexMonth,Summary_Indexing!tblindex3,2)
 |  |  |  |  | 3 | SERIES(Summary_Indexing!$c$1,Summary_Indexing!tblindexMonth,Summary_Indexing!tblindex4,3)
Spreadsheet: 748107d1631890297-converting-extracted-report-in-different-format-sample-12345
Sheet: Sheet1

 |  | Extracted Report |  |  | Required in below Format
 |  | Wednesday, September 1, 2021
 |  | Japan
 |  | Russia
 |  | Colombia
 |  | UAE
 |  | US
 |  | UK
 |  | Thursday, September 2, 2021
 |  | Myanmar
 |  | Spain
 |  | Uganda
 |  | Kenya
 |  | Brazil
Spreadsheet: 114818d1310526485-sum-if-for-an-array-helpforumexample
Sheet: Hand Hygiene Data

Dept/Unit | Date | Yes MD | No MD | Yes RN | No RN | Yes Clinical Tech | No Clinical Tech | Yes Other | No Other | No Total | Yes Total | Total | MD compliance | RN compliance | Clinical Tech Compliance | Other Staff compliance | Total Compliance
1W PACU | 2011-06-01 00:00:00
1W PRE-OP | 2011-06-01 00:00:00
1E Endoscopy | 2011-06-01 00:00:00
1E OR | 2011-06-01 00:00:00
2S | 2011-06-01 00:00:00
2S Birthing Center | 2011-06-01 00:00:00
3E | 2011-06-01 00:00:00
3S | 2011-06-01 00:00:00
4E | 2011-06-01 00:00:00
4S | 2011-06-01 00:00:00
4W | 2011-06-01 00:00:00
5W Acute | 2011-06-01 00:00:00
ARU | 2011-06-01 00:00:00
Cardiac Center | 2011-06-01 00:00:00
Critical Care | 2011-06-01 00:00:00
Emergency Center GS | 2011-06-01 00:00:00
ICU | 2011-06-01 00:00:00
Memorial | 2011-06-01 00:00:00
Radiology/X-Ray GE | 2011-06-01 00:00:00
Unknown | 2011-06-01 00:00:00
Housewide | 2011-06-01 00:00:00
1W PACU | 2011-07-01 00:00:00
1W PRE-OP | 2011-07-01 00:00:00
1E Endoscopy | 2011-07-01 00:00:00
1E OR | 2011-07-01 00:00:00
2S | 2011-07-01 00:00:00
2S Birthing Center | 2011-07-01 00:00:00
3E | 2011-07-01 00:00:00
3S | 2011-07-01 00:00:00
4E | 2011-07-01 00:00:00
4S | 2011-07-01 00:00:00
4W | 2011-07-01 00:00:00
5W Acute | 2011-07-01 00:00:00
ARU | 2011-07-01 00:00:00
Cardiac Center | 2011-07-01 00:00:00
Critical Care | 2011-07-01 00:00:00
Emergency Center GS | 2011-07-01 00:00:00
ICU | 2011-07-01 00:00:00
Memorial | 2011-07-01 00:00:00
Radiology/X-Ray GE | 2011-07-01 00:00:00
Unknown | 2011-07-01 00:00:00
Housewide | 2011-07-01 00:00:00
Spreadsheet: 119818d1314772515-set-up-table-lab-1-bar-graph
Sheet: Sheet2

Male | Female
16.33 | 16.66
5.88 | 16.66
0.0125 | 18.33
28.66 | 20
25.33 | 12
20.33 | 24.66
21.4 | 26.66
13.5 | 21.66
17.9 | 20.33
9.66 | 16.4
 | 9.66
 | 14.66
 | 12
Spreadsheet: 70592d1271321506-vlookup-with-another-condition-sample
Sheet: Sheet1

Customer | Sor No. | Narration | Shade | Count | Length | Quality | Qty | Full Cartons | Balance
Ambattur Clot | DLC:43801 | PI:27339 S/TALB 03016012/117 DT01-04-20 | SF-886 | TEX-27[60/3] | 5000 MTRS | SPUN POLYESTER | 326
Ambattur Clot | DLC:43801 | PI:27339 S/TALB 03016012/117 DT01-04-20 | SF-544 | TEX-27[60/3] | 3000 MTRS | SPUN POLYESTER | 478
Ambattur Clot | DLC:43801 | PI:27339 S/TALB 03016012/117 DT01-04-20 | SF-713 | TEX-30 | 5000 MTRS | POLY POLY CORE | 476
Spreadsheet: andy_zipper__169__DYNEGY-ICE VOL Apr13
Sheet: ICE-ENA

Enron North America
Activity on ICE
UOM | Deals | Volume
MMBtus
bbl
 |  |  |  |  |  |  | START | END
Enron North America Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-13-01 thru Apr-13-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
 |  |  |  | No Activity
Spreadsheet: 758282d1638796898-remove-specific-text-from-a-list-excel-forum-6-12-2021
Sheet: Sheet1

Original list | preferred display
Garments manufactured For Winnerforce  MEN-MATRIXT-JACKET(COYOTE) WOMEN-WREN-JACKET(COYOTE)
Garments manufactured For Winnerforce  WOMEN-ESCAPE-LEGGING(Black-Dark Grey)
Garments manufactured For Winnerforce
Garments manufactured For Winnerforce  WOMEN-COCO-HAIRBOW-SCRUNCHIE(PINK)-3 PIECES WOMEN-SAHARA-BRA(PINK-BUBBLEGUM) WOMEN-SAHARA-LEGGING(PINK-BUBBLEGUM PINK)
Garments manufactured For Winnerforce
Garments manufactured For Winnerforce  WOMEN-COCO-HAIRBOW-SCRUNCHIE(MAUVE)-3 PIECES
Garments manufactured For Winnerforce  WOMEN-YASSMA-BRA(CADET-BLUE)
Garments manufactured For Winnerforce
Garments manufactured For Winnerforce
Garments manufactured For Winnerforce
Garments manufactured For Winnerforce
Spreadsheet: 843871d1695692849-formula-required-to-determine-what-a-figure-has-to-be-to-return-a-figure-between-1-and-5-calc-forum
Sheet: Sheet1

KNOWN | KNOWN |  |  | KNOWN
A | B | C | D | E | F | G | H
2.1 | 2.8 | 49 |  |  |  |  | 2.9
 |  | WHAT DOES THIS FORMULA HAVE TO BE TO RETURN A FIGURE BETWEEN 1 AND 5 IN COLUMN H | =100-C | =C+D | =[NAME] | =BxD | WHAT DOES THIS FORMULA HAVE TO BE TO PRESENT A FIGURE OF BETWEEN 1 AND 5
Spreadsheet: 836947d1689754128-if-cell-contains-x-and-cell-above-a-specific-text-then-write-x-example-2-
Sheet: Sheet1

 | Fruit | Fruit | Fruit | Vegetable | Vegetable | Vegetable | Vegetable
 | Apple | Grape | [NAME] | Avocado | [NAME] | [NAME] | Peppers |  |  | Fruit | Vegetable
Client #1 | x |  | x | x | x
Client #2 |  | x | x
Client ….
Client …
 |  |  |  |  |  |  |  |  |  | K3 = if the client #1 has ticked at least one fruit, write "x". If no fruit, write "".  In this example "x" should appear. | L3 = if the client #1 has ticked at least one vegetable, write "x". If no vegetable ticked at all, write "".  In this example, "x" should appear.
 |  |  |  |  |  |  |  |  |  | K4 = if the client #2 has ticked at least one fruit, write "x". If no fruit, write "". In this example, "x" should appear. | [NAME] = if the client #2 has ticked at least one vegetable, write "x". If no vegetable ticked at all, write "". In this example, "" should appear.
 |  |  |  |  |  |  |  |  |  | This is an example. In my real case I have way more columns (hundreds) and more categories than 2 (fruit, vegetable, snack, … etc).
Spreadsheet: 196860d1354127923-webimport-daily-updated-table-with-variable-number-of-objects-fota1
Sheet: IMPUT29-11

AAA | 0.55
0.55
AAB | 0.6
0.60
Army of the Damned | 2.4
2.40
[NAME] | 1.45
1.45
Champion of the Parish | 1.1
1.10
Clifftop Retreat | 2.55
2.55
Essence of the Wild | 1.1
1.10
[NAME] | 19.2
19.20
Gavony Township | 1.1
1.10
Geist of Saint Traft | 24.75
24.75
Grimgrin Corpse-Born | 1.45
1.45
Grimoire of the Dead | 1.4
1.40
Hinterland Harbor | 3.1
3.10
Isolated Chapel | 3.3
3.30
[NAME] of the Veil | 22.5
22.50
Mikaeus the Lunarch | 3.6
3.60
Mirror-Mad Phantasm | 1
1.00
[NAME] | 11
11.00
Past in Flames | 5.5
5.50
Reaper from the [NAME] | 1.3
1.30
Runechanter's Pike | 0.78
0.78
Sever the Bloodline | 0.62
0.62
Skaab Ruinator | 1.15
1.15
[NAME] | 6.95
6.95
Stromkirk Noble | 1.5
1.50
[NAME] | 3.1
3.10
Tree of Redemption | 2.15
2.15
Woodland Cemetery | 2.85
2.85
Spreadsheet: 768493d1644999702-trying-to-look-up-and-filter-data-example
Sheet: RED C

Id numeric | Product | Component name | Result text
Spreadsheet: benjamin_rogers__1032__Coal presentation Backup
Sheet: Development

 |  | Operator | Plant | State | MW | Online Date
 |  | AES Puerto Rico, L.P. | AES Total Energy Project (Phillips Petroleum) |  | 500 | 2003
 |  | Anker Coal Group, Inc. | Upshur County | WV | 225 | Unavailable
 |  | Black Hills Corp. | Wygen No. 1 | WY | 80 | 2003
 |  | Composite Power Corp. | [NAME] | MT | 500 | 2004
 |  | Composite Power Corp. | [NAME] | MT | 500 | 2006
 |  | Composite Power Corp. | [NAME] | MT | 1000 | 2008
 |  | Composite Power Corp. | Merchant Power Park |  | Unavailable | Unavailable
 |  | Florida Power Corp. | Crystal River | FL | 100 | 2001
 |  | Global Energy, Ltd. | Kentucky Pioneer Energy Project | KY | 400 | 2003
 |  | Jacksonville Electric Authority | Jacksonville | FL | Unavailable | 2002
 |  | Kansas City Power & Light Co. | Hawthorn | MO | 540 | 2001
 |  | Kentucky Mountain Power | [NAME] (Kmp) | KY | 500 | 2003
 |  | Kentucky Power Cooperative | Unavailable | KY | Unavailable | Unavailable
 |  | Lakeland Electric | Lakeland | FL | Unavailable | 2005
 |  | Marlow Power & Steam, Inc. | Seward Cogenearation Facility | AK | 3 | 2002
 |  | [NAME], L.L.C. | Delaware City Refinery | DE | 224 | Unavailable
 |  | Northern States Power | Black Dog | MN | 290 | 2002
 |  | Ohio Edison Co. | Burger | OH | 172 | Unavailable
 |  | PG&E | Salem | MA | Unavailable | Unavailable
 |  | Reliant Energy Power Generation, Inc. | Seward | PA | 400 | Unavailable
 |  | Southern Illinois Power Cooerative | Marion | IL | 120 | 2003
 |  | Tractebel Power, Inc. | Red Hills Generation Facility | MS | 440 | 2000
 |  | Two Elk Power | Two Elks Plant | WY | 250 | 2002
 |  | University of Illinois | Abbot Power Plant - University | IL | 6 | Unavailable
 |  | Westmoreland Energy Company | [NAME] Reserve | MT | 260 | 2002
 |  | Wisconsin Energy Corp | Unavailable | WI | 600 | Unavailable
 |  | Wisconsin Energy Corp | Unavailable | WI | 600 | Unavailable
Spreadsheet: 590196d1536903079-how-to-get-top-10-in-excel-from-an-unsorted-list-practice_top_10
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Top 5 by Quantity
 | Employee | Department | Item Dispensed | Quantity | Prices Per Unit | Total |  | 1 |  |  |  | Row Labels | Sum of Quantity
 | Cesar | Engineering | [NAME] | 2 | 0.5 |  |  | 2 |  |  |  | Paperclips | 10
 | [NAME] | Accounting | Blue Pen | 1 | 0.5 |  |  | 3 |  |  |  | [NAME] | 10
 | Cesar | Engineering | Flashlight | 1 | 9.99 |  |  | 4 |  |  |  | Blue Pen | 3
 | Cesar | Engineering | Switch | 2 | 3.99 |  |  | 5 |  |  |  | Flashlight | 3
 | Julia | Human Resources | Paperclips | 10 | 0.25 |  |  | 6 |  |  |  | Switch | 2
 | [NAME] | Security | Flashlight | 1 | 9.99 |  |  | 7 |  |  |  | Grand Total | 28
 | [NAME] | Accounting | Blue Pen | 1 | 0.5 |  |  | 8
 | [NAME] | Accounting | [NAME] | 4 | 0.5 |  |  | 9
 | [NAME] | Security | Gloves | 1 | 5.99 |  |  | 10
 | Julia | Human Resources | Flashlight | 1 | 9.99
 | Julia | Human Resources | Wrench | 1 | 5.99
 | Julia | Human Resources | Blue Pen | 1 | 0.5
 | Cesar | Engineering | [NAME] | 4 | 0.5
Spreadsheet: darrell_schoolcraft__7585__imball0112
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 | -116054 | -52276
9238 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 | -2606188 | -3093743
58710 | -122483 | -85443
60921 | -1544787 | -1131806
78026
500084 | -65762 | -87000
500085 | -54387
500097 | -83940 | -56000
INDEX
2001-11-30 00:00:00 |  |  | 504796.07
2001-12-29 00:00:00
CBS Volume
 |  |  | 190825
Spreadsheet: kate_symes__18808__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-03-07 00:00:00 |  | 271.07 | 448 | 177.36 | 1664
 | 2001-03-06 00:00:00 |  | 302.29 | 944 | 166.83 | 1072 | 202.39 | 2764 | 134.22 | 1696
 | 2001-03-05 00:00:00 |  | 280 | 800 | 172.5 | 800 | 189.65 | 2226 | 131.16 | 1376
 | 2001-03-04 00:00:00 |  | 230 | 0 | 170 | 400 | 171.88 | 2765 | 131.78 | 1320
 | 2001-03-03 00:00:00 |  | 230.28 | 464 | 153.46 | 1040 | 170.84 | 1909 | 147.7 | 685
 | 2001-03-02 00:00:00 |  | 230.28 | 464 | 153.46 | 1040 | 204.08 | 1930 | 128.66 | 1229
 | 2001-03-01 00:00:00 |  | 267.19 | 512 | 141.82 | 880 | 233.33 | 777 | 144.63 | 726
 | 2001-02-28 00:00:00 |  | 170 | 320 | 112.22 | 1800 | 230.04 | 274 | 158.91 | 659
 | 2001-02-27 00:00:00 |  | 171 | 64 | 113.75 | 1600 | 176.51 | 603 | 108.24 | 1877
 | 2001-02-26 00:00:00 |  | 177.86 | 224 | 133.56 | 1392 | 157.54 | 2280 | 111.96 | 1798
 | 2001-02-25 00:00:00 |  | 147.5 | 0 | 135 | 280 | 131.22 | 2999 | 108.91 | 2383
 | 2001-02-24 00:00:00 |  | 174.29 | 224 | 115.26 | 1560 | 148.66 | 1535 | 132.09 | 1146
 | 2001-02-23 00:00:00 |  | 174.29 | 224 | 115.54 | 1480 | 166.64 | 2128 | 118.23 | 893
 | 2001-02-22 00:00:00 |  | 201.14 | 224 | 118.5 | 1312 | 160.02 | 656 | 90.98 | 787
 | 2001-02-21 00:00:00 |  | 210 | 224 | 148.86 | 560 | 161.32 | 1192 | 89.98 | 1296
 | 2001-02-20 00:00:00 |  | 232.14 | 224 | 137.14 | 112 | 130.89 | 1348 | 114.12 | 758
 | 2001-02-19 00:00:00 |  | 232.14 | 224 | 145 | 160 | 156.82 | 1839 | 154.53 | 1668
 | 2001-02-18 00:00:00 |  | 287.5 | 320 | 240.5 | 0 | 197.15 | 771 | 166.45 | 1129
 | 2001-02-17 00:00:00 |  | 282.14 | 224 | 221.43 | 112 | 230.67 | 1640 | 205.12 | 1180
 | 2001-02-16 00:00:00 |  | 387.5 | 384 | 198.75 | 192 | 251.75 | 3017 | 181.8 | 1576
 | 2001-02-15 00:00:00 |  | 387.5 | 384 | 198.75 | 192 | 391.66 | 5037 | 207.21 | 1058
 | 2001-02-14 00:00:00 |  | 275.24 | 1312 | 150.92 | 392 | 304.68 | 695 | 197.1 | 1165
 | 2001-02-13 00:00:00 |  | 185 | 160 | 151.57 | 1400 | 194.42 | 1165 | 136.79 | 587
 | 2001-02-12 00:00:00 |  | 207.14 | 560 | 138.91 | 880 | 140.84 | 1676 | 158.45 | 785
 | 2001-02-11 00:00:00 |  | 150 | 160 | 140 | 600 | 141.19 | 3174 | 132.09 | 2803
 | 2001-02-10 00:00:00 |  | 153.75 | 320 | 115.46 | 1720 | 150.05 | 2068 | 161.43 | 828
 | 2001-02-09 00:00:00 |  | 153.75 | 320 | 116.25 | 1760 | 168.64 | 1070 | 117.98 | 945
 | 2001-02-08 00:00:00 |  | 176.25 | 960 | 148.1 | 2000 | 174.99 | 844 | 91.4 | 1905
 | 2001-02-07 00:00:00 |  | 169.28 | 4224 | 131.32 | 3628 | 190.46 | 1300 | 95.76 | 1283
 | 2001-02-06 00:00:00 |  | 149.44 | 720 | 146.14 | 1400 | 153.56 | 520 | 88.67 | 917
 | 2001-02-05 00:00:00 |  | 160.19 | 1864 | 143.63 | 1772 | 142.39 | 1579 | 82.26 | 1310
Spreadsheet: 801942d1666502723-sumif-between-two-dates-returning-total-based-on-a-cell-value-example
Sheet: KPIRAW

2022-10-26 00:00:00 | 2022-10-29 00:00:00 |  | RAW |  |  |  | Report
 |  |  | Date | Product | Units
 |  |  | 2022-10-22 00:00:00 | Carrie | 2 |  | Need total units between 26/10 - 29/10
 |  |  | 2022-10-23 00:00:00 | Carrie | 3 |  |  | Units Sold
 |  |  | 2022-10-24 00:00:00 | Carrie | 4 |  | Carrie
 |  |  | 2022-10-25 00:00:00 | [NAME] | 5 |  | [NAME]
 |  |  | 2022-10-26 00:00:00 | Carrie | 6
 |  |  | 2022-10-27 00:00:00 | Carrie | 7
 |  |  | 2022-10-28 00:00:00 | [NAME] | 8
 |  |  | 2022-10-29 00:00:00 | Carrie | 9
 |  |  | 2022-10-30 00:00:00 | Carrie | 10
Spreadsheet: 356091d1414975826-if-statement-help-356083d1414969374-if-statement-help-discount-ndm
Sheet: Sheet1

Distribution Costs |  |  |  |  |  |  | Discounted Distribution Costs |  |  |  |  | Another table
 |  | Spruce | [NAME] | Duchesne |  |  |  | Spruce | [NAME] | Duchesne |  |  | Spruce | [NAME] | Duchesne
 | Seattle |  | 46.68 | 52.8 |  |  | Seattle |  |  |  |  | Seattle
 | Chicago | 89.77 | 128.82 | 97.17 |  |  | Chicago |  |  |  |  | Chicago
 | Dallas | 162.24 | 204.13 | 210.42 |  |  | Dallas |  |  |  |  | Dallas
 | New Orleans | 166.18 | 195.08 | 200.62 |  |  | New Orleans |  |  |  |  | New Orleans
 | Denver | 151.77 | 162.83 | 142.82 |  |  | Denver |  |  |  |  | Denver
 | LA | 0 | 147.46 | 150.14 |  |  | LA |  |  |  |  | LA
 | SF | 151.11 | 115.49 | 124.83 |  |  | SF |  |  |  |  | SF
 | Vancouver |  | 72.42 | 42.17 |  |  | Vancouver |  |  |  |  | Vancouver
 | Calgary |  | 77.5 | 87.94 |  |  | Calgary |  |  |  |  | Calgary
 |  | Spruce | [NAME] | Duchesne
 | Seattle | 0 | 40727 | 0
 | Chicago | 0 | 0 | 55608
 | Dallas | 0 | 92680 | 0
 | New Orleans | 0 | 38922.28571428571 | 53757.71428571429
 | Denver | 0 | 0 | 23832
 | LA | 150410.8571428572 | 0 | 61430.14285714284
 | SF | 0 | 52960 | 0
 | Vancouver | 0 | 0 | 32581
 | Calgary | 0 | 8145 | 0
 | Distribution Cost
Spreadsheet: 773835d1648060529-place-summed-data-on-separate-sheet-based-on-date-mock-workbook
Sheet: 2022

 | January | February | March | April | May | June | July | August | September | October | November | December | Total
 | FARM INCOME / EXPENSE WORKSHEET
 | January | February | March | April | May | June | July | August | September | October | November | December | Total
Income
Chickens
Turkeys
Guineas
Goats
Total
Expenses
Poultry
Live Birds
Feed
Total
Goats
Feed
Supplies
Total
Spreadsheet: 453764d1459436881-index-match-that-skips-null-rows-rearraignment
Sheet: Sheet1

Unique ID | Name | Qualification | Pass date
11111112 | Smith J | Qual A | 2015-04-01 00:00:00
11111112 | Smith J | Qual B | 2015-04-01 00:00:00
11111112 | Smith J | Qual D | 2015-04-02 00:00:00
11111113 | Jones A | Qual A | 2015-06-04 00:00:00
11111113 | Jones A | Qual C | 2015-09-05 00:00:00
11111113 | Jones A | Qual D | 2015-12-01 00:00:00
Spreadsheet: 298677d1392864206-a-quicker-way-collate-from-multiple-tables-family-portrait-summaries
Sheet: Sheet1

 | Family Portrait Summaries
 |  |  |  |  |  |  |  |  |  |  |  | Quick Reference Summary
 | Total Turnover |  | Average Turnover |  |  |  |  | Total Profit |  |  |  | Centre Name | Turnover | Profit
 | Total Printing |  | Average Printing
 | Canvas Costs |  | Average Profit/Shoot
 | Print Costs |  | Average Spend/Family
 |  |  | Average Profit/Family
 | Number of shoots | 1 | Average % Families
 | Total Families | 1 | Average Profit/Family @ Centre
 | Total Bookings
 | Centre Name |  |  |  |  | Total Turnover
 | # Families @ Centre |  | # Booked families |  | 1 | Total Printing
 |  |  |  |  |  | Centre Profit
 | Sitting Turnover | 10x13 P | 10x13 C | Poses | 16x20 C | 20x24 C | 20x30 C | 20x40 C | Other
 | TOTALS |  |  |  |  |  |  |  |  | NOTES
 |  |  |  |  |  |  |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  |  | .
Spreadsheet: 838457d1691029476-need-help-to-make-formula-based-vba-help-for-make-a-report-from-none-indexed-data-report-john555-
Sheet: Balance

ITEM | Opening  Balance |  | Invoice No. | INWARD | OUTWARD | BALANCE
36W FITTINGS
ADORE LED 3W DEEP SPOT 3K
ADORE LED 3W DEEP SPOT 6K
ASTRAL SPOT LIGHT 2W 3000K
CENTURA PLUS LED FLOOD LIGHT 30W 6K IP65
COMET SURFACE PANEL 6W 6K RD
CRYSTA COB SWIVEL SPOTLIGHT 3W 6500K
ELEC BALLAST EL STAR SLIM-36W
E-LITELED CURVE 20W 6K
FAN  VENTIL AIR DX 250MM HAVELLS
FAZER LED PANEL 18W 6K ROUND
INNOVA NEO LED SPOT LIGHT 6W 6K RD
KETTLE TRAVEL LITE 0.5L MAROON 1000W
LED 18W GREEN FITTINGS
LED 18W NEO FITTINGS
LED ADORE 0.5W LAMP BLUE
LED ADORE 0.5W LAMP GREEN
LED ADORE 0.5W LAMP RED
LED ADORE 0.5W LAMP WHITE
LED ADORE 0.5W LAMP YELLOW
LED ADORE 10W B22 CDL 3 STAR LAMP PRPK
LED ADORE 13W B22 CDL 4 STAR BALL LAMP
LED ADORE 15W B22 CDL BALL LAMP
LED ADORE 17W B22 CDL 4 STAR LAMP
LED ADORE 2.8W B22 CDL BALL LAMP
LED ADORE 2.8W E27 CDL BALL LAMP
LED ADORE 2.8W E27 CDL CANDLE LAMP
LED ADORE 2.8W E27 WW CANDLE LAMP
LED ADORE 20W B22 CDL 3 STAR LAMP PRPK
LED ADORE 26W 865 B22 LAMP
LED ADORE 3W B22 CDL BALL LAMP
LED ADORE 3W B22 WW BALL LAMP
LED ADORE 3W B22 WW CANDLE LAMP
LED ADORE 3W E14 CDL BALL LAMP
LED ADORE 3W E14 CDL CANDLE LAMP
LED ADORE 3W E14 WW BALL LAMP
LED ADORE 3W E27 CDL BALL LAMP
LED ADORE 5W B22 CDL 3 STAR LAMP PRPK
LED ADORE 5W B22 CDL 4 STAR LAMP
LED ADORE 5W B22 WW 3 STAR LAMP PRPK
LED ADORE 5W E27 WW 3 STAR LAMP PRPK
LED ADORE 7W B22 CDL 3 STAR LAMP PRPK
LED ADORE 7W B22 CDL 4 STAR LAMP
LED ADORE 7W B22 WW 3 STAR LAMP PRPK
LED ADORE 9W B22 CDL 3 STAR LAMP PRPK
LED ADORE 9W B22 CDL 4 STAR LAMP
LED ADORE 9W E27 CDL 4 STAR LAMP
LED ADORE LAMP 3W B22 CDL CANDLE
LED ADORE LAMP 3W E14 CANDLE LAMP WW
LED ADORE NIGHT LAMP 0.5W 6500K BEAR
LED ADORE NIGHT LAMP 0.5W 6500K PANDA
LED ADORE NIGHT LAMP 0.5W 6500K PENGUIN
LED ADORE NIGHT LAMP 0.5W 6500K RABBIT
LED ADORE NIGHT LAMP 0.5W 6500K RHINO
LED ADORE NIGHT LAMP 0.5W 6500K TENNIS
LED ADORE NIGHT LAMP 0.5W 6500K TIGER
LED ASTRAL 2W BLUE
LED CRYSTA COB 10W 3000K