tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 467271d1466629708-range-formula-help-needed-copy-of-book6
Sheet: Count of Orders

Quantity of Orders (Vented Core) |  |  |  |  |  |  |  | Quantity of Orders (Solid Core)
Frame | Poles | Motor Type | Horsepower Range |  |  |  |  | Frame | Poles | Motor Type | Horsepower Range
 |  | Vented Core | 0>700 | 701>1250 | 1251>3000 | 3001>18,000 |  |  |  | [NAME] | 0>700 | 701>1250 | 1251>3000 | 3001>18,000
500 | 2-pole |  |  |  |  |  |  | 500 | 2-pole
 | 4-pole |  |  |  |  |  |  |  | 4-pole
 | 6-pole |  |  |  |  |  |  |  | 6-pole |  |  |  |  |  |  | ** Number of total orders from the VSM tab***
 | 8-pole |  |  |  |  |  |  |  | 8-pole
 | 10-pole |  |  |  |  |  |  |  | 10-pole
 | 12-pole |  |  |  |  |  |  |  | 12-pole
 | 16-pole |  |  |  |  |  |  |  | 16-pole
580 | 2-pole |  |  |  |  |  |  | 580 | 2-pole
 | 4-pole |  |  |  |  |  |  |  | 4-pole
 | 6-pole |  |  |  |  |  |  |  | 6-pole
 | 8-pole |  |  |  |  |  |  |  | 8-pole
 | 10-pole |  |  |  |  |  |  |  | 10-pole
 | 12-pole |  |  |  |  |  |  |  | 12-pole
 | 16-pole |  |  |  |  |  |  |  | 16-pole
680 | 2-pole |  |  |  |  |  |  | 680 | 2-pole
 | 4-pole |  |  |  |  |  |  |  | 4-pole
 | 6-pole |  |  |  |  |  |  |  | 6-pole
 | 8-pole |  |  |  |  |  |  |  | 8-pole
 | 10-pole |  |  |  |  |  |  |  | 10-pole
 | 12-pole |  |  |  |  |  |  |  | 12-pole
 | 16-pole |  |  |  |  |  |  |  | 16-pole
800 | 2-pole |  |  |  |  |  |  | 800 | 2-pole
 | 4-pole |  |  |  |  |  |  |  | 4-pole
 | 6-pole |  |  |  |  |  |  |  | 6-pole
 | 8-pole |  |  |  |  |  |  |  | 8-pole
 | 10-pole |  |  |  |  |  |  |  | 10-pole
 | 12-pole |  |  |  |  |  |  |  | 12-pole
 | 16-pole |  |  |  |  |  |  |  | 16-pole
630 | 2-pole |  |  |  |  |  |  | 630 | 2-pole
 | 4-pole |  |  |  |  |  |  |  | 4-pole
 | 6-pole |  |  |  |  |  |  |  | 6-pole
 | 8-pole |  |  |  |  |  |  |  | 8-pole
 | 10-pole |  |  |  |  |  |  |  | 10-pole
 | 12-pole |  |  |  |  |  |  |  | 12-pole
 | 16-pole |  |  |  |  |  |  |  | 16-pole
710 | 2-pole |  |  |  |  |  |  | 710 | 2-pole
 | 4-pole |  |  |  |  |  |  |  | 4-pole
 | 6-pole |  |  |  |  |  |  |  | 6-pole
 | 8-pole |  |  |  |  |  |  |  | 8-pole
 | 10-pole |  |  |  |  |  |  |  | 10-pole
 | 12-pole |  |  |  |  |  |  |  | 12-pole
 | 16-pole |  |  |  |  |  |  |  | 16-pole
Spreadsheet: 56168d1256250083-consolidating-data-in-one-pivot-table-pivot-problem
Sheet: Three

 |  |  | Class B |  |  | Class C |  |  | Class N |  |  | Class P |  |  | Class W
Customer | Accont | Months | Real | Budget | Difference | Real | Budget | Difference | Real | Budget | Difference | Real | Budget | Difference | Real | Budget | Difference
FIVE | 2 | Jan | 0 | 0 | 0 | 7 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FIVE | 2 | Feb | 0 | 0 | 0 | 26 | 10 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FIVE | 2 | Mar | 0 | 0 | 0 | 43 | 23 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FIVE | 2 | Apr | 0 | 0 | 0 | 12 | 23 | -11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FIVE | 2 | May | 0 | 0 | 0 | 60 | 10 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FIVE | 2 | Jun | 0 | 0 | 0 | 12 | 8 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FIVE | 2 | Jul | 0 | 0 | 0 | 67 | 9 | 58 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FIVE | 2 | Aug | 0 | 0 | 0 | 56 | 65 | -9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FIVE | 2 | Sep | 0 | 0 | 0 | 32 | 0 | 32 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FIVE | 2 | Oct | 0 | 0 | 0 | 12 | 0 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FIVE | 2 | Nov | 0 | 0 | 0 | 45 | 0 | 45 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FIVE | 2 | Dec | 0 | 0 | 0 | 62 | 14 | 48 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FIVE | 4 | Jan | 0 | 0 | 0 | 0 | 0 | 0 | 90 | 87 | 3 | 0 | 0 | 0 | 0 | 0 | 0
FIVE | 4 | Feb | 0 | 0 | 0 | 0 | 0 | 0 | 78 | 87 | -9 | 0 | 0 | 0 | 0 | 0 | 0
FIVE | 4 | Mar | 0 | 0 | 0 | 0 | 0 | 0 | 76 | 87 | -11 | 0 | 0 | 0 | 0 | 0 | 0
FIVE | 4 | Apr | 0 | 0 | 0 | 0 | 0 | 0 | 88 | 87 | 1 | 0 | 0 | 0 | 0 | 0 | 0
FIVE | 4 | May | 0 | 0 | 0 | 0 | 0 | 0 | 89 | 87 | 2 | 0 | 0 | 0 | 0 | 0 | 0
FIVE | 4 | Jun | 0 | 0 | 0 | 0 | 0 | 0 | 88 | 87 | 1 | 0 | 0 | 0 | 0 | 0 | 0
FIVE | 4 | Jul | 0 | 0 | 0 | 0 | 0 | 0 | 55 | 87 | -32 | 0 | 0 | 0 | 0 | 0 | 0
FIVE | 4 | Aug | 0 | 0 | 0 | 0 | 0 | 0 | 120 | 87 | 33 | 0 | 0 | 0 | 0 | 0 | 0
FIVE | 4 | Sep | 0 | 0 | 0 | 0 | 0 | 0 | 115 | 87 | 28 | 0 | 0 | 0 | 0 | 0 | 0
FIVE | 4 | Oct | 0 | 0 | 0 | 0 | 0 | 0 | 90 | 87 | 3 | 0 | 0 | 0 | 0 | 0 | 0
FIVE | 4 | Nov | 0 | 0 | 0 | 0 | 0 | 0 | 85 | 87 | -2 | 0 | 0 | 0 | 0 | 0 | 0
FIVE | 4 | Dec | 0 | 0 | 0 | 0 | 0 | 0 | 85 | 87 | -2 | 0 | 0 | 0 | 0 | 0 | 0
FIVE | 6 | Jan | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 1
FIVE | 6 | Feb | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 2 | 2
FIVE | 6 | Mar | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 3 | 3
FIVE | 6 | Apr | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 4 | 4
FIVE | 6 | May | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 5 | 5
FIVE | 6 | Jun | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 6 | 6
FIVE | 6 | Jul | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 5 | 9
FIVE | 6 | Aug | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 4 | 8
FIVE | 6 | Sep | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 3 | 7
FIVE | 6 | Oct | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 2 | 6
FIVE | 6 | Nov | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 5
FIVE | 6 | Dec | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4
Spreadsheet: 837137d1689873880-indirect-a1-a5-and-a1-to-spill-a1-from-other-sheets-doesnt-work-how-could-i-do-it-example-2
Sheet: ANALYSIS

Location: | London |  |  | This is not a problem, Its just to illustrate.
Path
 |  |  | Client
 | This Table is where I want to look at the end.
 | I want to see the total amount paid by each client in the BDD
 | I also want to see the total amount that would have been paid if ONE client did all the purchase
 | To do that I have in total:
 | 2 data base that I put at the end of the year and that stay forever in this excel file.
 | 6 pricing sheets that changes every year, Sometimes I add 1 or delete one.
 | A settings tab that connect the Pricing sheets with the Mapping
 | The analysis tab connect the DB with the Mapping
 | So now my mapping connects pricing sheets and DB
 | And my problem is in the MAPPING TAB
 | Also All the data I used are random.
Spreadsheet: 773988d1648144462-sumifs-from-2-dynamic-arrays-sumifs-from-2-dynamic-array
Sheet: Sheet1

Name | Exclude? | 2021 | 2022 | 2023 | 2024 | 2025 |  |  |  |  |  | 2022 | 2023 | 2024 | 2025
[NAME] | Yes | 45 | 44 | 83 | 2 | 95
[NAME] |  | 91 | 38 | 23 | 34 | 74 |  |  |  | [NAME]
Doe | Yes | 45 | 50 | 61 | 77 | 53 |  |  |  | Doe
Doe | Yes | 79 | 72 | 70 | 81 | 62 |  |  |  | [NAME]
[NAME] | Yes | 81 | 74 | 100 | 48 | 22 |  |  |  | [NAME]
[NAME] | Yes | 90 | 81 | 99 | 56 | 93
Doe |  | 65 | 59 | 67 | 47 | 49
[NAME] |  | 29 | 64 | 20 | 98 | 13 |  |  |  |  | 2021 | 2022 | 2023 | 2024 | 2025
Doe |  | 52 | 90 | 69 | 49 | 78 |  |  |  | [NAME] | 0 | 0 | 0 | 0 | 0
[NAME] | Yes | 19 | 15 | 17 | 77 | 81 |  |  |  | [NAME] | 91 | 38 | 23 | 34 | 74
[NAME] |  | 11 | 18 | 33 | 19 | 26 |  |  |  | Doe | 117 | 149 | 136 | 96 | 127
Doe | Yes | 26 | 22 | 2 | 10 | 73 |  |  |  | [NAME] | 47 | 133 | 40 | 120 | 40
[NAME] | Yes | 84 | 17 | 26 | 8 | 69 |  |  |  | [NAME] | 83 | 64 | 58 | 84 | 62
[NAME] |  | 72 | 46 | 25 | 65 | 36
[NAME] |  | 18 | 69 | 20 | 22 | 27
Spreadsheet: 728807d1618664542-sumproduct-formula-giving-an-error-simplepay-report-1-
Sheet: Formula Page

PERIOD | DATE | TYPE | ACCOUNT | REF | DECSRIPTION | AMOUNT |  |  |  |  | CONTRA |  |  |  |  |  | AMOUNT |  | Description
12 | 28/02/2018 | G | 1000000 | 2015YE | Bonus's Paid |  | 0 | 0 |  |  | 4500000 | 1 | 1 | 0 | 0 | 0
12 | 28/02/2018 | G | 1000000 | 2015YE | Basic Pay |  | 0 | 0 |  |  | 4500000 | 1 | 1 | 0 | 0 | 0
 |  |  |  |  |  | You will note that I first tried a sum if formula for mutiple columns but it did not work
 |  |  |  |  |  | I have then tried a Sumproduct PER G3 but its not correct
 |  |  |  |  |  | Thanks
Spreadsheet: 687590d1595300370-populate-a-spread-sheet-based-on-data-that-is-structured-differently-example-workbook-updated-1-
Sheet: Reject 3

FRESH PRODUCE ASSESSMENT FORM
Product:
APPLE
Vendor:
Grower:
NINE MI
Delivery Date:
Total Ordered:
2020-07-15 00:00:00
72
Type / Variety:
SELECT ODD BUNCH 1KG PP
P.O. Number:
1016
Total Received:
0
Class:
ONE
Packed On:
Use By:
2020-07-13 00:00:00
Harvest Date:
Best Before:
2020-07-27 00:00:00
Total Rejected:
Receival Temp:
72
6.9 °C
QUALITY CRITERIA
ACTION
DEFECT
[NAME]
DEFECT CRITERIA
MAJOR
MINOR
DEFECT
[NAME]
Unit of Measurement
PACK
Physical/Pest Damage
8
0
Bruising
With bruises that are distinctly darker than skin colour, have distinct edges/indentations and have affected the underlying flesh eg discolouration or softening and have distinct edges.
No. Products With Defects
Total Units Assessed
8
0
54
No Cartons used for Assessment
6
Total % Out of Spec
0.148
0
Quantity Rejected
72
Use X to Designate
Accept
Reject
X
Digital Image
Yes
X
No
Comments:
ASSESSED BY
[NAME]
ASSESSMENT DATE
2020-07-15 00:00:00
QCRF 006
Spreadsheet: 51272d1250799890-points-formatting-book1-1-1-
Sheet: Results

Player Name | WK 1 | WK2 | WK3 | WK4 | WK 5 | WK 6 | WK 7 | WK 8 | WK 9 | WK 10 | WK 11 | WK 12 | WK 13 | WK 14 | WK 15
[NAME] | 1 | 22 | 10 | 11
[NAME] | 2 | 21 | 9 | 12
[NAME] | 3 | 20 | 8 | 13
[NAME] | 4 | 19 | 7 | 14
Retief Goosen | 5 | 18 | 6 | 15
[NAME] | 6 | 17 | 5 | 16
[NAME] | 7 | 16 | 4 | 17
[NAME] | 8 | 15 | 3 | 18
[NAME] | 9 | 14 | 2 | 19
[NAME] | 10 | 13 | 1 | 20
[NAME] | 11 | 12 | 11 | 1
[NAME] Poulter | 12 | 11 | 12 | 2
[NAME] | 13 | 10 | 13 | 3
[NAME] | 14 | 9 | 14 | 4
[NAME] | 15 | 8 | 15 | 5
[NAME] | 16 | 7 | 16 | 6
[NAME] | 17 | 6 | 17 | 7
[NAME] | 18 | 5 | 18 | 8
[NAME] | 19 | 4 | 19 | 9
[NAME] | 20 | 3 | 20 | 10
[NAME] | 21 | 2 | 21 | 22
[NAME] | 22 | 1 | 22 | 21
Spreadsheet: 885244d1734686374-changing-multiplier-based-on-cell-value-points-form-jt-v2
Sheet: February

Date | Day | Attended | Points
2025-02-01 00:00:00
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
Total
 | Day | Attended | Points
 | Mon
 | Tue
 | Wed
 | Thu
 | Fri
 | Sat
 | Sun
 | Total
Spreadsheet: 764129d1642601290-formula-needed-to-aggregate-data-sumproduct-between-dates-aligw
Sheet: Sheet1

 | 21/22 |  |  |  |  |  |  |  |  |  |  |  | 22/23 |  |  |  |  |  |  |  |  |  |  |  | 23/24
 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00
Apples | 1 | 2 | 10 | 9 | 6 | 10 | 10 | 8 | 6 | 9 | 5 | 8 | 6 | 8 | 2 | 6 | 6 | 3 | 8 | 6 | 1 | 8 | 10 | 6 | 6 | 3 | 5 | 1 | 6 | 1 | 10 | 3 | 9 | 5 | 4 | 4
Oranges | 2 | 10 | 3 | 10 | 7 | 4 | 4 | 9 | 6 | 6 | 1 | 5 | 6 | 10 | 3 | 10 | 6 | 10 | 4 | 9 | 6 | 7 | 2 | 7 | 9 | 8 | 5 | 6 | 8 | 10 | 5 | 7 | 10 | 10 | 1 | 6
Bananas | 10 | 4 | 7 | 6 | 2 | 5 | 8 | 3 | 1 | 7 | 7 | 5 | 9 | 4 | 3 | 7 | 6 | 9 | 4 | 2 | 4 | 4 | 9 | 10 | 2 | 2 | 5 | 1 | 1 | 6 | 2 | 2 | 6 | 9 | 1 | 6
 | 21/22 | 22/23 | 23/24 |  |  | Expected values
Apples |  |  |  |  | 84 | 70 | 57
Oranges |  |  |  |  | 67 | 80 | 85
Bananas |  |  |  |  | 65 | 71 | 43
Spreadsheet: joe_quenet__15070__PJM
Sheet: DJ PJM Electricity Index

 | DATE |  |  |  | Firm On Peak |  | MW |  | [NAME]
 | 2001-10-29 00:00:00 |  |  |  | 32.27 |  | 1700 |  | 27200
 | 2001-10-28 00:00:00
 | 2001-10-27 00:00:00
 | 2001-10-26 00:00:00 |  |  |  | 30.13 |  | 2950 |  | 47200
 | 2001-10-25 00:00:00 |  |  |  | 26.75 |  | 2350 |  | 37600
 | 2001-10-24 00:00:00 |  |  |  | 26.31 |  | 1950 |  | 31200
 | 2001-10-23 00:00:00 |  |  |  | 24.48 |  | 2150 |  | 34400
 | 2001-10-22 00:00:00 |  |  |  | 25.31 |  | 1350 |  | 21600
 | 2001-10-21 00:00:00
 | 2001-10-20 00:00:00
 | 2001-10-19 00:00:00 |  |  |  | 25.5 |  | 1250 |  | 20000
 | 2001-10-18 00:00:00 |  |  |  | 26.93 |  | 2600 |  | 41600
 | 2001-10-17 00:00:00 |  |  |  | 25.28 |  | 2750 |  | 44000
 | 2001-10-16 00:00:00 |  |  |  | 26.48 |  | 900 |  | 14400
 | 2001-10-15 00:00:00 |  |  |  | 26.31 |  | 1050 |  | 16800
 | 2001-10-14 00:00:00
 | 2001-10-13 00:00:00
 | 2001-10-12 00:00:00 |  |  |  | 23.51 |  | 2100 |  | 33600
 | 2001-10-11 00:00:00 |  |  |  | 23.98 |  | 1350 |  | 21600
 | 2001-10-10 00:00:00 |  |  |  | 25.31 |  | 1800 |  | 28800
 | 2001-10-09 00:00:00 |  |  |  | 28.25 |  | 1800 |  | 28800
 | 2001-10-08 00:00:00 |  |  |  | 29.17 |  | 3850 |  | 61600
 | 2001-10-07 00:00:00
 | 2001-10-06 00:00:00
 | 2001-10-05 00:00:00 |  |  |  | 28.6 |  | 1950 |  | 31200
 | 2001-10-04 00:00:00 |  |  |  | 28.93 |  | 1350 |  | 21600
 | 2001-10-03 00:00:00 |  |  |  | 27.5 |  | 900 |  | 14400
 | 2001-10-02 00:00:00 |  |  |  | 26.01 |  | 1000 |  | 16000
 | 2001-10-01 00:00:00 |  |  |  | 24.71 |  | 2050 |  | 32800
 | 2001-09-30 00:00:00
 | 2001-09-29 00:00:00
Spreadsheet: 751093d1633870617-formula-to-calculate-amount-based-on-drop-list-budget-d
Sheet: March

 | March Transactions
 | Date: | Ref No.: | Payee | Description | Category | AMOUNT
 | 10/10/2021 | 1 | hhh200 | hhh200 | Insurance | 1200
 | 10/10/2021 | 10 | hhh201 | hhh201 | Salary | 1500
 | 10/10/2021 | 200 | [NAME] | [NAME] | Salary | 1500
 | 10/10/2021 | 300 | hhh203 | hhh203 | Salary | 1500
 | 10/10/2021 | 4 |  |  | Stationery | 98
 | 10/10/2022 | 1 |  |  | Advertisement | 250
 | 10/10/2023 |  | Rent |  | Rent | 5800
 | Totals
Spreadsheet: 681863d1591795365-index-and-match-to-pick-out-all-the-data-values-in-a-specified-column-of-data-example01
Sheet: Data

 | Rng_Matrix (B2:[NAME])
 | User Number | user020-001 | user020-002 | user020-003 | user020-004 | user020-005 | user020-006 | user020-007 | user020-008 | user020-009 | user020-010 | user020-011 | user020-012 | user020-013 | user020-014 | user020-015 | user020-016 | user020-017
 | [NAME] | 6 | 8 | 18 | 12 | 6 | 11 | 11 | 1 | 7 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 0
 | Item02 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Item03 | 5 | 8 | 15 | 11 | 5 | 10 | 9 | 1 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Item04 | 4 | 5 | 11 | 4 | 3 | 4 | 3 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Item05 | 14 | 6 | 23 | 3 | 5 | 2 | 13 | 0 | 0 | 5 | 5 | 6 | 1 | 0 | 18 | 10 | 1
 | Item06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Item07 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 2 | 0
 | Item08 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Item09 | 9 | 4 | 10 | 1 | 4 | 1 | 1 | 1 | 2 | 3 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | Item10 | 24 | 32 | 15 | 7 | 9 | 8 | 5 | 0 | 5 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Item11 | 3 | 3 | 11 | 3 | 1 | 5 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 0
 | Item12 | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 1 | 0 | 1 | 5 | 0
 | Item13 | 1 | 0 | 0 | 1 | 5 | 1 | 0 | 0 | 0 | 4 | 3 | 4 | 1 | 0 | 15 | 3 | 0
 | Item14 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 2 | 3 | 7 | 1 | 0 | 2 | 2 | 0
 | Item15 | 0 | 0 | 2 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0
 | Item16 | 4 | 0 | 21 | 2 | 0 | 5 | 0 | 1 | 1 | 3 | 0 | 1 | 0 | 0 | 1 | 1 | 0
 | Item17 | 6 | 0 | 9 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 3 | 0 | 1 | 0 | 4 | 4 | 0
 | Item18 | 17 | 0 | 15 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 27 | 0 | 0 | 0 | 9 | 2 | 0
 | Item19 | 7 | 0 | 19 | 0 | 0 | 0 | 7 | 0 | 0 | 0 | 18 | 0 | 0 | 0 | 9 | 0 | 0
 | Item20 | 152766 | 354349 | 13659 | 105 | 140 | 637854 | 84414 | 0 | 1769 | 647 | 574 | 58 | 42 | 78 | 4635 | 475 | 22
 | Item21 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Item22 | 5 | 0 | 3 | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 11 | 2 | 0 | 0 | 0 | 1 | 0
 | Item23 | 11 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 2 | 0 | 0 | 0 | 0 | 0
 | Item24 | 3 | 2 | 0 | 2 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Item25 | 5 | 5 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 768259d1644907177-remove-duplicate-and-sum-copy-of-book1
Sheet: Sheet1

Names | Sales |  |  | Names | Sales |  | Names | Sales
[NAME] | 1 |  |  | [NAME] | 2
[NAME] | 1 |  |  | [NAME] | 3
[NAME] | 1 |  |  | [NAME] | 1
[NAME] | 1 |  |  | [NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
 |  |  |  | Desired Result
Spreadsheet: 770970d1646360546-dynamically-generated-table-sorted-by-a-column-sorted-descending-order-disctinct-values-by-total-spend
Sheet: Sheet1

Source Data |  |  |  |  |  |  |  | Desired Result |  |  |  | Description of what I need: | I do not want to achieve the result by using [NAME] table, I need dynamically generated table instead
Supplier | Part Number | Spend |  |  |  |  |  | Supplier | Spend |  |  | Column | Description
A | 123 | 1000 |  |  |  |  |  | A | 1800 |  |  | Supplier | Dynamically generated distinct values of [NAME]
B | 456 | 100 |  |  |  |  |  | B | 400 |  |  | Spend | Total Spend per Supplier in descending order
A | 789 | 500 |  |  |  |  |  | C | 200
A | 963 | 300 |  |  |  |  |  | D | 200
C | 123 | 200 |  |  |  |  |  | E | 100
D | 456 | 50
B | 741 | 300
D | 123 | 120
E | 741 | 100
Spreadsheet: 726370d1617199219-transpose-column-against-repeated-cells-invoice-import-export
Sheet: Main

CONSIGNEE | AC# | WR# | [NAME] | LBS | SHIPPER | PHONE | [NAME] | ADDRESS | VALUE | % | FREIGHT | FUEL | CUSTOMS & DUTY | VAT | ONLINE PURCHASE TAX | INSURANCE FEE | BROKERAGE FEE | TOTAL
[NAME] | 15243 | 123508 | CLOTHING | 1 | waLMART | 369-9291 | [EMAIL] | c/o Digicel (Trinidad and Tobago) Limited 11c Maraval Road, Port of Spain, Trinidad, WEST. | 16.29 | 20 | 20.4 | 3.47 | 22.1544 | 17.585055 | 7.75404 | 13.6 | 5.1 | 84.963495
[NAME] | 19090 | 123309 | GAMING CONTROLLER | 1 | AMAZON | 746-9036 | [EMAIL] | LP#55 Dass Trace Enterprise Chaguanas, CEN. | 31.99 | 20 | 20.4 | 3.47 | 43.5064 | 34.533205 | 15.22724 | 13.6 | 5.1 | 130.736845
[NAME] | 14584 | 123327 | SUPPLEMENT | 1 | AmaZON | 310-3493 | [EMAIL] | #51 Bagna Trace Chase Village Chaguanas , | 28.69 | 20 | 20.4 | 3.47 | 39.01840000000001 | 30.970855 | 13.65644 | 13.6 | 5.1 | 121.115695
[NAME] | 13411 | 123430 | CLOTHING | 2 | UsPS | 304-4759 | [EMAIL] | #68 Sesame St Gonzales Village Guapo Point Fortin, SOW. | 40.67 | 20 | 40.8 | 6.94 | 55.3112 | 43.903265 | 19.35892 | 13.6 | 10.2 | 179.913385
Spreadsheet: 846008d1697301083-monthly-activity-tracking-table-tracking-test-desense
Sheet: Results Page

 |  | 2023-09-01 00:00:00 | 2023-09-02 00:00:00 | 2023-09-03 00:00:00 | … | … | … | … | … | … | … | … | … | … | … | … | …
 | P089 | 0 | 1 | 0
 | P132 | 1 | 1 | 0
 | P175 | 1 | 0 | 1
 | P205 | 1 | 1 | 0
 | P001 | 2 | 3 | 1
 | P002 | 0 | 1 | 1
 | P006 | 0 | 0 | 1
 | P019 | 1 | 1 | 0
 | P038 | 1 | 0 | 0
 | P041 | 0 | 1 | 0
 | P072 | 1 | 0 | 0
 | P082 | 0 | 1 | 0
 | P089 | 0 | 1 | 0
Parts Needing Report: |  |  | 2023-09-04 00:00:00 | Part # | Zone
 |  |  |  | P089 | Back Stamp Zone
 |  |  |  | P132 | Back Stamp Zone
 |  |  |  | P205 | Back Stamp Zone
 |  |  |  | P019 | Back Weld Zone
 |  |  |  | P038 | Front Weld Zone
 |  |  |  | P041 | Front Weld Zone
 |  |  |  | P072 | Back Weld Zone
 |  |  |  | P082 | Front Weld Zone
 |  |  |  | P089 | Back Stamp Zone
Spreadsheet: 808625d1670539027-nested-if-function-for-pivot-table-example-book
Sheet: Sheet6

Employee ID | Job Title | Cost Center | Direct/Indirect
0001 | Machine Operator I | 00180171 | Direct
0002 | Machine Operator II | 00180171 | Direct
0003 | Machine Operator III | 00180171 | Direct
0004 | Quality Tech I | 00180175 | Indirect
0005 | Painter I | 00180175 | Indirect
0006 | Painter II | 00180175 | Direct
0007 | Painter I | 00180175 | Direct
0008 | Painter I | 00180171 | Direct
0009 | Welder I | 00180171 | Direct
0010 | [NAME] | 00180198 | Direct
0011 | Welder I | 00180502 | Direct
0012 | [NAME] | 00180180 | Direct
Spreadsheet: 329861d1404432401-lookup-but-first-finding-a-unique-string-mockup
Sheet: grid

Times | TR1 | TR2 | TR3 | TR4 | TR5 | TR6 | TR7 | TR8 | <- Fields
FRI 6:15 | Tier 1 C1v2 | [NAME] | Tier 3 B1v2 | [NAME] | Tier 3 C1v2 | Tier 3 C3v4 | Tier 1 C3v4 | [NAME]
FRI 7:45 | Tier 3 A1v2 | [NAME] | Tier 1 A3v4 | Tier 1 A1v2 | [NAME] | [NAME]B1v5 | [NAME] | [NAME]
FRI 9:15 | Tier 1 B3v4 | Tier 1 B1v2
SAT 8:00 | [NAME]B1v2 | [NAME] | [NAME] C1v2 | [NAME] |  |  | [NAME] A1^v2
SAT 9:30 | Tier 1 C2v4 | Tier 3 A2v4 | Tier 3 A1v3 | Tier 3 B1v3 | Tier 3 B2v4 | Tier 3 C1v3 | Tier 3 C2v4 | Tier 1 C1v3
SAT 11:00 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] B2v4 | [NAME] | [NAME] A1^v3 | [NAME]
SAT 12:30 | Tier 1 A1v3 | [NAME] B2v4 | Tier 1 A2v4 | Tier 1 C1v4 | Tier 1 B1v3 | Tier 1 B2v4 | [NAME] C1v3 | [NAME]
SAT 2:00 | Tier 3 A1v4 | Tier 1 C2v3 | Tier 3 C1v4 | Tier 3 C2v3 | [NAME] | Tier 4 A1v5 | Tier 3 B1v4 | [NAME]
SAT 3:30 | [NAME] | [NAME] | [NAME]C1v4 | [NAME] | [NAME] A1v4 | [NAME] | Tier 1 B1v4 | Tier 1 B2v3
SAT 5:00 | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] | Tier 1 A1v4 | Tier 1 A2v3
Spreadsheet: mary_fischer__25617__37D
Sheet: E31.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 037D
COMPANY NAME     Artemis Fair Value
RECONCILIATION OF STOCKHOLDERS' EQUITY AND INVESTMENT IN SUBS
FOR THE PERIOD ENDING 6-30-2001
PREPARED BY: [NAME]
EXTENSION : 52580 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
 |  |  |  | 12-31-00 Balance |  |  |  | EQUITY IN |  | DIVIDENDS DECLARED |  |  |  | OTHER ACTIVITY
 |  |  |  | DR  (CR) |  | RECLASS 00 NI |  | EARNINGS |  |  |  |  |  |  |  |  |  | DR  (CR)
 |  | Hyp line |  | BEG BALANCE |  | TO BEG RE |  | /LOSSES |  | COMMON |  | PREFERRED |  | DR (CR) |  | (Describe) |  | END BALANCE
Shareholders Equity by Parent |  | Reverse signs from Hyperion
Common Stock |  | 0901
Paid in Capital |  | 0910
Contribution Received from Parent |  | 0915 |  | -64343830
RE - Beg Bal |  | 0920 |  | -4374991 |  | 130716
RE - Net Income |  | 0930 |  | 130717 |  |  |  | -867951
RE - Net Income (Fair Value Adjustment) |  | 0931 |  |  |  |  |  | 1037880
Dividends Decl - Preferred Stock |  | 0935
Dividends Decl - Common Stock |  | 0941
Invest in Subs Plug Account |  | 0942 |  |  |  |  |  | 1
Total Shareholders' Equity |  | TOT_SHARE_EQU
Net Income |  | NET_INCOME
PARENT'S CO #
Investment in Consol Sub (on Parent Books) |  |  |  | Same signs as Hyperion
Investment in CS |  | 0215
Investment in PIC (contrib by parent) |  | 0216
Investment in Equity earnings of sub |  | 0217
Total Investment in Consol Sub
Equity in Consol Sub |  | 1505
Difference between SE (on sub) and Invest (on parent)
Reasons for Differences
A schedule will need to be prepared for each subsidiary.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
Spreadsheet: 760306d1640133389-display-names-of-individuals-trained-copy-of-schedule-2022
Sheet: Sheet1

 | [NAME] By Nights January 10, 2022
[NAME]
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 |  |  |  |  |  | R
 |  |  |  |  |  | R
Supervisor 9-9
 |  |  |  |  |  | R
[NAME] 8-8
 |  |  |  |  |  | R
 |  |  |  |  |  | R
Sr Tech 9-9
 |  |  |  |  |  | R
 |  |  |  |  |  | R
 |  |  |  |  |  | R
Tech 2130-0800
Tech 2230-0900
BODY COUNT
Total MHRS