tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: daren_farmer__5252__BMSPT051
Sheet: BMSPT066

BAMMEL STORAGE ACTIVITY
VOLUME SPLIT BY Counterparties
2001-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | SWING CONTRACT VOLUMES |  |  |  |  | ECT LONG/(SHORT) |  |  |  | LONG/(SHORT)
 |  | HPL INDEX |  |  | HPL FIXED PRICE |  |  |  |  | TOTAL | HL&P | CP&L | TUFCO | TOTAL |  | ECT FIRST OF THE MONTH | TUFCO/ HL&P/ CP&L SWING VOLUME | ECT LONG OR (SHORT) |  | ECT TOTAL | HPLC Excluding 3rd Party | Net LONG/ (SHORT)
 |  | MTD Adjustment | CURRENT DAY | Total | MTD Adjustment | CURRENT DAY | Total | 3rd Party | HPLC Total |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | Reinject Fees
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Injected Volume | Value
Beginning Balance
1 | Scheduled |  |  |  |  |  |  |  |  |  | 0 | 0
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Estimated
 | Estimated
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Index: | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuel: | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuel Rate:
Ending Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prod.[NAME]:
Variances:
Total Projected
April 28 thru May 4
May 5 thru May 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Previous Position: |  | 1381889
May 12 thru May 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]:
May 19 thru May 25
Spreadsheet: 683387d1592686707-time-card-calculation-time_card3c-revised
Sheet: Flex Employee

Employee: |  |  |  |  |  |  |  |  |  |  | Year | 2020 |  |  |  |  |  |  |  |  |  |  |  |  | OPTIONS |  | OVERTIME OPTIONS
Employee Number: |  |  |  |  |  |  |  |  |  |  | Month |  |  |  |  |  |  | Su | M | [NAME] | W | Th | F | Sa | YES | DAILY | YES
Cost Center: |  |  |  | DEPT. # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO | AFTER | 8 | HRS
SUPERVISOR: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BREAK TIME | WEEKLY | YES
WEEK STARTING: | 2020-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | AFTER | 40 | HRS
WEEK ENDING: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
Day of Week | Time In | Time In 2 | [NAME] (minutes) | Time Out | Time Out 2 | Total Hours hide | Total Hours | Regular Hours hide | Regular Hours | Overtime | Overtime | Sick Time Hrs | Sick Time Hrs. hide | Holiday Hrs. | Holiday Hrs. hide | Vacation Hrs. | Vacation Hrs. hide |  |  |  |  |  |  |  | 45
 |  | hidden |  |  | hidden |  |  |  |  | Hours hide | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
 | 0700 |  | 30 | 1530
 | 0700 |  | 30 | 1537
 | 0700 |  | 30 | 1555
 |  |  |  | Total  Hrs.
 |  |  |  | Total  Hrs.
TOTAL HOURS WORKED: |  |  |  | Biweekly Total  Hrs.
Grand Total Pay: |  |  |  |  |  |  | Rate / Hour: |  | 52
Grand Total Pay w/ Shift Differential: |  |  |  |  |  |  | Total Pay:
Spreadsheet: 88431d1288263798-vlookup-or-if-statement-needed-book1
Sheet: Sheet1

 | +
 | Item code | Quantity | Weight | Total weight | Sent via
 | bs | 1 | 66 | 66 | Large letter
 | bct | 1 | 2940 | 2940 | Packet
 | ch300 | 2 | 560 | 1120 | packet
 |  | Going out
 |  |  | Quantity | weight in grams
 |  | Large letters | 1 | 66
 |  | Packets | 2 | 1120
 |  | 1st | 1 | 2940
 |  | ok, don’t laugh there’s no formulas in this one at all could work out how to do it at all. What I’m trying to achieve is add the large letters up (just worked out how to do that now) then add up the packets up but only the ones that weigh less than 2000 and then have the first add up but only the ones that are over 2001. I’ve filled the table out how it should be just don’t know how to get the formula to do thanks in advance for any help/input it greatly appreciated
Spreadsheet: 95355d1294946886-compare-worksheets-and-return-data-test
Sheet: Sheet1

DCNum | old_id | id | Code | Status | last_nm | [NAME] | addr1 | addr2 | dnr_city | dnr_state | dnr_zip | dnr_hmephn | extra_phn | wrk_phn | lang_pref | email | wrk_email | descrip | recno
29 | 1165465 | 000013000 | 2 | Deleted | Smith | [NAME] | 1322 Test Ave |  | Test | MN | 99999 | [PHONE] |  | [PHONE] |  |  |  | NULL | 989898
81 | 6654654 | 000013001 | 2 | Deleted | [NAME] | [NAME] | 1321 Testing Ave |  | Testing | WI | 88888 | [PHONE] |  | [PHONE] |  |  |  | English | 4545
37 | 6456546 | 000013002 | 2 | Deleted | [NAME] | Barb | 1355 Testing Dr |  | Testing | MN | 99999 | [PHONE] |  | [PHONE] |  |  |  | English | 21333
66 | 7798799 | 000013004 | 7 | Available | Tester | Test | 1358 Testing Ct |  | Test | WI | 88888 | [PHONE] |  | [PHONE] |  |  |  | English | 11754
Spreadsheet: 703319d1604942868-index-match-reading-across-multiple-columns-is-it-possible-example1937
Sheet: Sheet1

 |  |  |  |  |  | DATA
Item number | Expected result |  |  |  |  | Item number | Red | Blue | Green | Yellow
1 | R |  |  |  |  | 1 | R
2 | B |  |  |  |  | 2 |  | B
3 | G |  |  |  |  | 3 |  |  | G
4 | Y |  |  |  |  | 4 |  |  |  | Y
5 | R |  |  |  |  | 5 | R
6 | R |  |  |  |  | 6 | R
7 | G |  |  |  |  | 7 |  |  | G
8 | B |  |  |  |  | 8 |  | B
9 | B |  |  |  |  | 9 |  | B
10 | Y |  |  |  |  | 10 |  |  |  | Y
Spreadsheet: 63691d1264578777-advanced-filter-advfilter1
Sheet: SUm

Country | Date | Data |  | Filter criteria |  |  |  | Country | Date | Data
Spain | 2010-01-09 00:00:00 | Data1 |  | Country | Date | Date |  | Spain | 2010-01-16 00:00:00 | Data7
Spain | 2010-01-16 00:00:00 | Data7 |  | Spain | >=16/01/2010 | <=[NAME]
Germany | 2010-01-25 00:00:00 | Data2
Germany | 2010-01-27 00:00:00 | Data10
Netherlands | 2010-01-31 00:00:00 | Data8
Belgium | 2010-02-07 00:00:00 | Data6
Belgium | 2010-02-09 00:00:00 | Data4
Portugal | 2010-02-10 00:00:00 | Data3
Germany | 2010-02-14 00:00:00 | Data5
Belgium | 2010-02-14 00:00:00 | Data9
Spreadsheet: john_griffith__16090__1_17_02GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HU G2 | 54 | 350 | 440 | 46.8 | 58.9 | 1.79 | 2002-01-17 14:45:00
 | [NAME] | 55 | 700 | 775 | 49 | 54.3 | 1.79 | 2002-01-17 14:45:00
 | [NAME] | 62 | 1030 | 1080 | 49 | 51.4 | 1.96 | 2002-01-17 14:45:00
 | [NAME] | 63 | 1170 | 1230 | 45.5 | 47.8 | 1.85 | 2002-01-17 14:45:00
 | [NAME] | 63 | 1300 | 1390 | 43.9 | 47 | 1.8 | 2002-01-17 14:45:00
 | HU N2 | 64 | 1350 | 1450 | 40.9 | 43.9 | 1.71 | 2002-01-17 14:45:00
 | [NAME] | 62 | 1400 | 1500 | 40.2 | 43.1 | 1.62 | 2002-01-17 14:45:00
 | HU U2 | 61 | 1410 | 1510 | 38.2 | 41 | 1.52 | 2002-01-17 14:45:00
 | [NAME] | 59 | 1400 | 1525 | 37 | 40.4 | 1.44 | 2002-01-17 14:45:00
 | [NAME] |  |  |  | 34 | 37.8 | 1.31 | 2002-01-15 14:58:00
 | [NAME] |  |  |  | 35.4 | 40.3 | 1.4 | 2001-11-29 15:00:00
 | HU F3 |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | HU H3
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | [NAME]
Spreadsheet: michelle_lokay__26570__imbalsumm0012
Sheet: Conoco

 | Maljamar |  | Zia
Day | Measured | Scheduled | Measured | Scheduled
1 | 29632 | 30000 | 22925 | 25000
2 | 19946 | 30000 | 25047 | 25000
3 | 24779 | 29992 | 18690 | 24993
4 | 22643 | 30000 | 17753 | 25000
5 | 25628 | 30000 | 17735 | 25000
6 | 26763 | 30000 | 32416 | 25000
7 | 27062 | 30300 | 36668 | 25000
8 | 28834 | 29390 | 37663 | 32222
9 | 29402 | 30000 | 34971 | 25000
10 | 29274 | 30000 | 33463 | 25000
11 | 27694 | 30000 | 33683 | 25000
12 | 24700 | 30000 | 27303 | 31000
13 | 28925 | 29989 | 30174 | 30989
14 | 29257 | 30000 | 31971 | 28000
15 | 30136 | 29981 | 34927 | 24984
16 | 29674 | 30000 | 34403 | 28000
17 | 29616 | 30000 | 33558 | 28000
18 | 29698 | 30000 | 31944 | 28000
19 | 29720 | 30000 | 34470 | 28000
20 | 31137 | 33916 | 34208 | 27931
21 | 23948 | 35000 | 34570 | 28000
22 | 18108 | 34989 | 35411 | 27992
23 | 30974 | 35133 | 35384 | 36000
24 | 25513 | 35133 | 32454 | 36000
25 | 20844 | 35133 | 17307 | 36000
26
27
28
29
30
31
2000-11-30 00:00:00 |  | 622338.78 |  | -1050867.92
2000-12-25 00:00:00
Spreadsheet: 164580d1340812679-calculating-time-with-vlookup-new-kitchen-schedule
Sheet: Range

Time
OFF
R-OFF
VAC
CL | 23
5:00 AM | 5 |  | 5:00 AM | 5
5:30 AM | 5.5 |  | 5:30 AM | 5.5
6:00 AM | 6 |  | 6:00 AM | 6
6:30 AM | 6.5 |  | 6:30 AM | 6.5
7:00 AM | 7 |  | 7:00 AM | 7
7:30 AM | 7.5 |  | 7:30 AM | 7.5
8:00 AM | 8 |  | 8:00 AM | 8
8:30 AM | 8.5 |  | 8:30 AM | 8.5
9:00 AM | 9 |  | 9:00 AM | 9
9:30 AM | 9.5 |  | 9:30 AM | 9.5
10:00 AM | 10 |  | 10:00 AM | 10
10:30 AM | 10.5 |  | 10:30 AM | 10.5
11:00 AM | 11 |  | 11:00 AM | 11
11:30 AM | 11.5 |  | 11:30 AM | 11.5
12:00 PM | 12 |  | 12:00 PM | 12
12:30 PM | 12.5 |  | 12:30 PM | 12.5
1:00 PM | 13 |  | 1:00 PM | 13
1:30 PM | 13.5 |  | 1:30 PM | 13.5
2:00 PM | 14 |  | 2:00 PM | 14
2:30 PM | 14.5 |  | 2:30 PM | 14.5
3:00 PM | 15 |  | 3:00 PM | 15
3:30 PM | 15.5 |  | 3:30 PM | 15.5
4:00 PM | 16 |  | 4:00 PM | 16
4:30 PM | 16.5 |  | 4:30 PM | 16.5
5:00 PM | 17 |  | 5:00 PM | 17
5:30 PM | 17.5 |  | 5:30 PM | 17.5
6:00 PM | 18 |  | 6:00 PM | 18
6:30 PM | 18.5 |  | 6:30 PM | 18.5
7:00 PM | 19 |  | 7:00 PM | 19
7:30 PM | 19.5 |  | 7:30 PM | 19.5
8:00 PM | 20 |  | 8:00 PM | 20
8:30 PM | 20.5 |  | 8:30 PM | 20.5
9:00 PM | 21 |  | 9:00 PM | 21
9:30 PM | 21.5 |  | 9:30 PM | 21.5
10:00 PM | 22 |  | 10:00 PM | 22
10:30 PM | 22.5 |  | 10:30 PM | 22.5
11:00 PM | 23 |  | 11:00 PM | 23
11:30 PM | 23.5 |  | 11:30 PM | 23.5
12:00 AM | 24 |  | 12:00 AM | 24
12:30 AM | 24.5 |  | 12:30 AM | 24.5
1:00 AM | 25 |  | 1:00 AM | 25
1:30 AM | 25.5 |  | 1:30 AM | 25.5
2:00 AM | 26 |  | 2:00 AM | 26
2:30 AM | 26.5 |  | 2:30 AM | 26.5
3:00 AM | 27 |  | 3:00 AM | 27
3:30 AM | 27.5 |  | 3:30 AM | 27.5
4:00 AM | 28 |  | 4:00 AM | 28
4:30 AM | 28.5 |  | 4:30 AM | 28.5
 |  |  | CL | 23
Spreadsheet: 268512d1380660147-creating-a-total-sum-for-each-month-sample-problem
Sheet: Sheet1

Date |  | Value 1 | Value 2 | Value 3
2013-08-09 00:00:00 |  | 2.5 | 4.5 |  |  |  | Would Like a formula to display this:
2013-08-11 00:00:00 |  | 5.4 | 2.3 | 1.1 |  |  | (Totals for the months)
2013-08-20 00:00:00 |  | 2.3 |  |  |  |  |  | Value 1 | Value 2+3
2013-08-26 00:00:00 |  | 8.9 |  | 2.3 |  |  | 2013-08-13 00:00:00
2013-09-10 00:00:00 |  | 9.1 | 2.1 |  |  |  | 2013-09-13 00:00:00
2013-09-12 00:00:00 |  | 1 |  | 4.3 |  |  | 2013-10-13 00:00:00
2013-09-20 00:00:00 |  | 2.5 |  | 0.2
2013-09-25 00:00:00 |  | 3.7 |  | 2.1
2013-10-01 00:00:00 |  | 2.6
Spreadsheet: 106461d1303751008-sumproduct-formula-2
Sheet: Sheet2

DATE | PITCHER | BATTER | INN | CATCHER |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | RESULT
2011-04-01 00:00:00 | LEWIS | SMITH | 1 | TORREALBA | PITCH | F | S | F | H | F | H | F | F | F | S | F | F | F | F | F | HIT
 |  |  |  |  | START | 1 | 3 | 1 | 2 | 1 | 1 | 1 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 1
 |  |  |  |  | FINISH | 11 | 2 | 11 | 12 | 11 | 11 | 11 | 11 | 2 | 3 | 12 | 1 | 12 | 11 | 11
2011-04-01 00:00:00 | LEWIS | DAVIS | 1 | TORREALBA | PITCH | F | S | F | H | F | H | F | F | F | S | F | F | F | F | F
 |  |  |  |  | START | 1 | 3 | 1 | 2 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 2 | 1 | 1
 |  |  |  |  | FINISH | 1 | 2 | 11 | 12 | 11 | 11 | 1 | 1 | 2 | 3 | 1 | 1 | 12 | 11 | 1
2011-04-01 00:00:00 | LEWIS | WELLS | 1 | TORREALBA | PITCH | F | S | F | H | F | H | F | F | F | S | F | F | F | F | F
 |  |  |  |  | START | 1 | 3 | 1 | 2 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 2 | 1 | 1
 |  |  |  |  | FINISH | 1 | 2 | 11 | 12 | 11 | 11 | 1 | 1 | 2 | 3 | 1 | 1 | 12 | 11 | 1
Spreadsheet: darrell_schoolcraft__7303__imball0201
Sheet: Oasis

POI  8516
 | Measured | Scheduled | Imbal
1 | -48871 | -49601
2 | -49187 | -48829
3 | -103126 | -102275
4 | -123391 | -123241
5 | -36313 | -35878
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
2001-12-31 00:00:00 |  |  | -33834
2002-01-05 00:00:00
CBS Volume
 |  |  | -18444
Spreadsheet: 255d1d53-7ccd-4a35-bf07-699b18e73cc7
Sheet: 9d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Fixed-Float | 1562655 | 130541 | 1770690 | 86039
OTHER* | 1336531 | 451894 | 205397 | 107232
TOTAL | 2899186 | 582435 | 1976087 | 193271
*OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, FRA, Fixed-Fixed, Inflation, OIS, and Swaption.
Spreadsheet: 824241d1680416890-quarterly-calculation-based-on-month-mmm-name-analysis
Sheet: Sheet1

Column1 | 2020 | 2021 | 2022 | 2023 |  |  | 2020 QTR | 2021 QTR | 2022 QTR | 2023 QTR
JAN | 33808.22 | 45899.79 | 47882.47 | 43974.02
FEB | 28782.19 | 48655.65 | 44840.05 | 36110.44
MAR | 28656.18 | 55951.2 | 47429.69 | 42889.6
APR | 30633.12 | 57380 | 54661.9
MAY | 42264.47 | 58088.78 | 57988.3
JUN | 49951.84 | 56486.72 | 53353.61
JUL | 49881.27 | 59376.81 | 55473.94
AUG | 46751.2 | 50590.72 | 53156.35
SEP | 45026.89 | 50810.5 | 47891.3
OCT | 47874.51 | 48179.81 | 45061.17
NOV | 47356.8 | 44790.29 | 46068.83
DEC | 44225.31 | 47264.2 | 42375.68 |  |  |  | =SUMPRODUCT((ROUNDUP(MONTH($A$2:$A$14)/3,0)=D2)*$B$2:$B$14)
 |  |  |  |  |  |  | =SUM(IF(MOD(ROW($B$1:$B$15),2)=0,$B$1:$B$15,0))
 |  |  |  |  |  | Q | 2020 QTR | 2021 QTR | 2022 QTR | 2023  QTR
 |  |  |  |  |  | Q1 | 91246.59 | 150506.64 | 140152.21 | 122974.06
 |  |  |  |  |  | Q2 | 122849.43 | 171955.5 | 166003.81
 |  |  |  |  |  | Q3 | 141659.36 | 160778.03 | 156521.59
 |  |  |  |  |  | Q4 | 139456.62 | 140234.3 | 133505.68
 |  |  |  |  |  | Total
Spreadsheet: 0ea72fb9-cb19-4a96-bc73-128a92ea36f2
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 44. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (QLD), Original (Number, $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
1. . . [NAME] ; |  |  | Original | A2413781A | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413782C | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413783F | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413784J | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413785K | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413786L | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413787R | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413788T | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413789V | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413790C | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413791F | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 679575d1590505029-value-error-excel-sumif-and-sumproduct-formulas-horizontal-and-vertical-criteria-template-
Sheet: Summary

 |  | Periods
 | Categories | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | TOTAL
 | OP1.1.1
 | OP1.1..2
 | OP1.1.3
 | TOTAL
Spreadsheet: 91286d1291055891-need-help-aggregating-data-furniture-ezfind
Sheet: Sheet4

D1
SKU | Removed/Added By | Date
949698
949698
949698
949698
949698
949698
D2
SKU | Removed/Added By | Date
642410
776610
776630
949698
949698
949698
D3
SKU | Removed/Added By | Date
100310
100310
444515
444515
444515
D4
SKU | Removed/Added By | Date
200692
200719
200746
421902
616125
616125
616125
616125
616125
616125
616125
891360
Spreadsheet: 738213d1624901326-tracking-computer-sn-in-billing-invoice-sample-sn-tracking
Sheet: Sheet1

PC1418NZ
PC1418P0
PC1418P1
PC1418P3
PC1418P5
PC1418P7
PC1418SY
PC1418SZ
PC1418T5
PC1418T8
PC1418TA
PC1418TC
PC1418TE
PC14195P
PC1418P2
PC1418P4
PC1418T0
PC1418T2
PC1418SX
PC1418T1
PF1DYHFX
PF1NY4DJ
PF1NYEYP
[NAME]
PF1NVG4Y
PF1NXALQ
PF1NVG51
PF1NVJED
[NAME]
PF1NX76E
PF1NVG40
PF1NX4YL
PF1NVEH5
PF1NXAQL
PF1NVG83
PF1NTTFW
PF1NVELX
PF1NYF15
PF1NYA5E
PF1NY60B
PF1NY223
PF1NX785
PF1NX790
PF1NVJEL
[NAME]
PF1NVJF4
PF1NX75B
PF1NX78S
Spreadsheet: 50465d1249923451-description-column-in-pivot-table-pivot-example
Sheet: original data

Data
PRODUCT NO | PRODUCT DESC | GROSS AMT
100002 | Product A | 56868.11
100002 | Product A | 42278.27
100021 | Product B | 7120
100021 | Product B | 1424
100021 | Product B | 3560
100225 | Product C | 55683.46
100225 | Product C | 45448.6
424227 | Product D | 31234
424227 | Product D | 6681.5
424227 | Product D | 3783.5
424509 | Product E | 152
424509 | Product E | 456
488040 | Product F | 6288
488040 | Product F | 5567.5
488040 | Product F | 3078.5
Pivot table #1
Row Labels | Sum of GROSS AMT
100002 | 99146.38
Product A | 99146.38
100021 | 12104
Product B | 12104
100225 | 101132.06
Product C | 101132.06
424227 | 41699
Product D | 41699
424509 | 608
Product E | 608
488040 | 14934
Product F | 14934
Grand Total | 269623.44
Pivot Table #2 - "classic Pivot table view"
Sum of GROSS AMT
PRODUCT NO | PRODUCT DESC | Total
100002 | Product A | 99146.38
100002 Total |  | 99146.38
100021 | Product B | 12104
100021 Total |  | 12104
100225 | Product C | 101132.06
100225 Total |  | 101132.06
424227 | Product D | 41699
424227 Total |  | 41699
424509 | Product E | 608
424509 Total |  | 608
488040 | Product F | 14934
488040 Total |  | 14934
Grand Total |  | 269623.44
Here is what I would like:
Pivot Table #2 - "classic Pivot table view"
Sum of GROSS AMT
PRODUCT NO | PRODUCT DESC | Total
100002 | Product A | 99146.38
100021 | Product B | 12104
100225 | Product C | 101132.06
424227 | Product D | 41699
424509 | Product E | 608
488040 | Product F | 14934
Grand Total |  | 269623.44
Spreadsheet: 812435d1673148259-dynamic-reference-to-worksheet-with-index-and-aggregate-functions-dynamic-worksheet-reference-question
Sheet: FEBRUARY

 | FEBRUARY SALES
 | Potter | [NAME] | Date Sold
 | [NAME] | ornament | 2022-02-02 00:00:00 | 10
 | [NAME] | ornament | 2022-02-07 00:00:00 | 10
 | [NAME] | ornament | 1900-04-19 00:00:00 | 12
 | [NAME] | [NAME] | 2022-02-12 00:00:00 | 22
 | [NAME] | [NAME] | 2022-02-13 00:00:00 | 20
 | [NAME] | vase | 2022-02-13 00:00:00 | 45
 | [NAME] | bowl | 2022-02-13 00:00:00 | 60
 | [NAME] | [NAME] | 2022-02-14 00:00:00 | 20
 | [NAME] | vase | 2022-02-20 00:00:00 | 30
 | [NAME] | [NAME] | 2022-02-22 00:00:00 | 20
Spreadsheet: tracy_geaccone__40633__1stQTRFore4qtrs
Sheet: All Pipes Contribution

Revised 2/22/01 | First Quarter |  |  | Second Quarter |  |  | Third Quarter |  |  | Fourth Quarter |  |  | TOTAL
Keiser (Ext. 33138) | Forecast | Plan | [NAME] | Forecast | Plan | [NAME] | Forecast | Plan | [NAME] | Forecast | Plan | [NAME] | Forecast | Plan | [NAME]
Northern Natural Gas
Net Margin | 168.3 | 165.8 |  | 68.8 | 69.1 |  | 73.8 |  |  | 131.9
Expenses | -11.4 | -11.7 |  | -10.8 |  |  | -10.2 | -10.2 |  | -12.6 | -12.4
Non-Recurring | 0 | 0 |  | 9.9 | 9.9 |  | 0 | 0 |  | 0 | 0
Total NNG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | done
Transwestern
Net Margin |  | 37.4 |  |  | 40.8 |  |  | 40.7 |  |  | 39.3
Expenses |  | 5.1 |  |  | 4.2 |  |  | 4.7 |  |  | 5.8
Non-Recurring | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
Total TW
Florida Gas
Net Margin | 77.5 | 75.9 |  |  | 80.9 |  |  | 81.2 |  |  | 98.4
Expenses |  | -1.2 |  |  | -1.2 |  |  | -1.2 |  |  | -1.4
Non-Recurring | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  | 0.5
Total FGT
TOTAL PIPES
Net Margin
Expenses
Non-Recurring
TOTAL PIPES
Spreadsheet: 873434d1719932941-weighting-different-filters-construction-test-v2
Sheet: Analytics

 |  |  |  | Category Weightings
Shop | Weighting |  | Date |  | Vegetable | Carbs | Drink | Dairy | Meat | Condiment | Fish | Other
 | 0.25
M&S | 0.25 |  | 2024-03-01 00:00:00
Tesco | 0.5 |  | 2024-12-01 00:00:00
 |  |  | In Data sheet, create a helper column "Weighted %" with the formula: =INDEX(Analytics!$B$3:$B$5;MATCH(B2;Analytics!$A$3#;0))*E2
 |  |  | In Analytics sheet, E3: =IFERROR(SUM(FILTER(Data!$F$2:$F$103;(Data!$A$2:$A$103=$D3)*(Data!$D$2:$D$103=E$2)));"")
Spreadsheet: 2dddc60a-6f3e-490a-a4bb-c8bfce38478d
Sheet: Sheet1

State of New Hampshire - General Election | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
State Representatives - CARROLL County
District No. 1 (1) | [NAME], r | [NAME], d | [NAME]
[NAME] | 1129 | 639
Hart's Location | 17 | 15
[NAME] | 379 | 266
Totals | 1525 | 920
District No. 2 (3) | [NAME], r | Recount | McClure, r | Recount | Umberger, r | Recount
Chatham | 99 | 99 | 90 | 90 | 107 | 107
Conway | 2036 | 2038 | 1609 | 1613 | 2164 | 2170
Eaton | 116 | 116 | 93 | 93 | 108 | 108
Hale's Location | 84 | 85 | 109 | 109 | 88 | 88
Totals | 2335 | 2338 | 1901 | 1905 | 2467 | 2473
 | Buco, d | Recount | Pollock, d | Recount | White, d | Recount
Chatham | 92 | 92 | 79 | 79 | 71 | 71
Conway | 2393 | 2388 | 2091 | 2085 | 2152 | 2148
Eaton | 147 | 147 | 133 | 133 | 141 | 141
Hale's Location | 18 | 18 | 17 | 17 | 15 | 15
Totals | 2650 | 2645 | 2320 | 2314 | 2379 | 2375
District No. 3 (2) | Thomson, r | McConkey, r | Ticehurst, d | [NAME]
Albany | 138 | 155 | 202
Freedom | 505 | 474 | 363 | 1
[NAME] | 511 | 559 | 693 | 1
Tamworth | 606 | 760 | 785 | 3
Totals | 1760 | 1948 | 2043 | 5
District No. 4 (2) | Crawford, r | [NAME], r | Albee, d | [NAME]
Moultonborough | 1722 | 1414 | 1117
Sandwich | 392 | 360 | 524
Tuftonboro | 697 | 759 | 777 | 1
Totals | 2811 | 2533 | 2418 | 1
District No. 5 (3) | Merrow, r | [NAME], r | Olimpio, r | Lavender, d | [NAME]
[NAME] | 171 | 235 | 168 | 186
[NAME] | 392 | 329 | 264 | 330 | 1
Ossipee | 1256 | 938 | 758 | 772 | 4
Wakefield | 1018 | 1192 | 1019 | 1065 | 11
Totals | 2837 | 2694 | 2209 | 2353 | 16
District No. 6 (2) | [NAME], r | Ahlgren, r | Woods, d | White, d | [NAME]
Wolfeboro | 2010 | 2087 | 1691 | 1506
District No. 7 (1) F | Tregenza, r | Butler, d | [NAME]
Albany | 151 | 226
[NAME] | 657 | 1050
Chatham | 91 | 100
Conway | 1764 | 2873 | 6
Eaton | 121 | 156
Freedom | 423 | 419 | 1
Hale's Location | 90 | 30
Hart's Location | 6 | 27
[NAME] | 203 | 423 | 1
[NAME] | 544 | 787 | 2
Tamworth | 612 | 835 | 1
Totals | 4662 | 6926 | 11
District No. 8 (1) F | [NAME], r | Wiley, d | [NAME]
[NAME] | 204 | 167
[NAME] | 246 | 375
Moultonborough | 1601 | 1119
Ossipee | 900 | 919 | 2
Sandwich | 329 | 626
Tuftonboro | 898 | 594
Wakefield | 1263 | 1038
Totals | 5441 | 4838 | 2