tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30655__9901_OA
Sheet: NE_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  NORTHEAST
 |  |  | 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 | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations |  |  |  |  |  |  |  |  |  | -127827.78
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
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 |  |  |  |  |  |  |  | 0 |  | -10759654
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-East
 |  | Current Month MTM |  |  |  |  | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Financial Liquidations |  |  |  |  | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Originations |  |  |  |  | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 875977d1722608957-return-multiple-match-values-in-columns-example
Sheet: Trache1

Foreame | Surname | DOB | Area Code | Reason1 | Reason2 | Reason3 | Reason4 | Reason5
[NAME] | Bloggs | 1950-01-01 00:00:00 | A1234 | Left on train | accident | no transport | car | N/A
Fred | Smith | 1967-02-02 00:00:00 | A0987 | Left in car
[NAME] | Doe | 1966-12-25 00:00:00 | A5678 | left on bus
[NAME] | Red | 1978-03-23 00:00:00 | A2345 | nothing found
[NAME] | Black | 1970-02-03 00:00:00 | A4567 | no transport
Spreadsheet: 34828d1232165033-compare-coloum-compare
Sheet: Sheet1

Child's CRN | Parent CRN
208724832B | 207133814L
207803923S | 207803923s
204710987X | 204710987X
207392985k | 206156381s
207807039x | 206156381s
207946428L | 206156381s
207654226V | 207272941H
207891892T | 207272941H
207685523A | 207685523A
208900517B | 208900517B
209051052x | 206156381s
208 691 749A | 208691746L
208 691 749A | 208691746L
209090951j | 202482374s
207765370C | 202103500T
405344910T | 405344910T
207669477C | 207667471C
208809602J | 207667471C
320336559t | 320336555K
to be supplied | 320336555k
207751637x | 201528599B
209027132X | 201528599B
203 880 460A | 208 880 460A
207795137B | 203412179x
209003190T | 208721459J
255666 | N/A
208807495x | 206415133c
208 975 442A | 208 975 438H
207687261C | 207687257K
208810209C | 207687257K
208959769V | 203505623X
208811558x | 208811558x
208994658T | 202447807J
207667070H | 204056723S
207708473A | 207708473A
207507769C | 207843321T
207929719A | 207843321T
20790651X | 202752913X
207716415V | 207413085A
100025264X | 206807984B
207819491K | 207819295C
209081105T | 207819295C
208792611A | 203239801K
207 912 716S | 202 725 644C
207850719C | 207850617H
208950596V | 207850617H
207838242c | 603969457v
208942062 | 603969457v
208739447L | 202897351K
208928207C | 202897351K
208721456X | 208721456X
208880318x | 207641267K
206063405J | 206063405J
206063405J | 206063405J
208 968 377H | 208 967 613K
208681480H | 202760346s
209101373L | 202760346s
207777165H | 405344910T
209075012t | 203192188x
209045638H | 320094316B
207879861C | 320094316B
208903016L | 205829948T
208994652V | 208994652V
207714341B | 205764765K
Spreadsheet: 29a27189-6583-4bab-a770-8409d745b4a9
Sheet: Sheet1

Table 5--USDA-calculated world market rice prices (rough basis) 1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | 2013/14 |  |  | 2012/13 |  |  | 2011/12
 |  | Medium/ |  |  | Medium/ |  |  | Medium/
Month | Long | short |  | Long | short |  | Long | short
 | $/cwt
August 2/ | 12.15 | 12.51 |  | 11.91 | 12.13 |  | 14.08 | 14.4
September |  |  |  | 12.57 | 12.81 |  | 15.09 | 15.44
October |  |  |  | 12.72 | 12.97 |  | 15.63 | 15.99
November |  |  |  | 12.92 | 13.17 |  | 14.93 | 15.28
December |  |  |  | 12.62 | 12.86 |  | 13.9 | 14.21
January |  |  |  | 12.35 | 12.59 |  | 12.61 | 12.88
February |  |  |  | 11.77 | 12.43 |  | 11.81 | 12.2
March |  |  |  | 12.16 | 12.84 |  | 11.52 | 11.92
April |  |  |  | 12.18 | 12.86 |  | 11.15 | 11.54
May |  |  |  | 12.08 | 12.75 |  | 11.42 | 11.82
June |  |  |  | 12.17 | 12.85 |  | 11.93 | 12.35
July |  |  |  | 12.01 | 12.86 |  | 11.97 | 12.4
Market-year
average 1/ | 12.15 | 12.51 |  | 12.28833333333333 | 12.76 |  | 13.00333333333334 | 13.36916666666666
1/ Simple average of the U.S. Department of Agriculture's weekly adjusted world market price.  2/  Preliminary.
Source: [NAME] and Rice Weekly Prices (ftp://ftp.fsa.usda.gov/public/cotton/default.htm), Farm Service Agency, USDA.
Last updated August 12, 2013.
Spreadsheet: 726b2ea6-8e06-4f8f-9375-9d64fb1be866
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42778128 | 2014-08-18 18:06:45 | ALLIES | 1 | 6 | 3 | 701256 | player701256 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42832376 | 2014-08-22 16:28:37 | AXIS | 1 | 4 | 0 | 1174565 | Capt [NAME] | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet
Spreadsheet: 694676d1599745567-6-nations-competition-matches-played-based-on-score-inputs-prediction-sheet-2021
Sheet: Sheet1

 |  |  |  |  |  | GUINNESS 6 NATIONS 2021
 |  |  |  |  |  |  | PREDICTION COMPETITION
 | MATCHES |  |  |  |  |  |  |  |  |  |  | 6 NATIONS STANDINGS
 | Match | Date |  | Time |  | MATCH SCORE |  |  | Venue |  |  | Country | P | W | D | L | PD | BP | Pts
 | Week 1 of Matches |  |  |  |  |  |  |  |  |  |  | Italy | 0 |  |  |  |  | 0
 | 1 | Sat, February 6th |  | 17:15:00 | Italy |  |  | France | [NAME]
 | 2 | Sat, February 6th |  | 18:45:00 | England |  |  | Scotland | [NAME] |  |  | France | 0 |  |  |  |  | 0
 | 3 | Sun, February 7th |  | 17:00:00 | Wales |  |  | Ireland | Principality Stadium
 | Week 2 of Matches |  |  |  |  |  |  |  |  |  |  | England | 0 |  |  |  |  | 0
 | 4 | Sat, February 13th |  | 16:15:00 | England |  |  | Italy | [NAME]
 | 5 | Sat, February 13th |  | 18:45:00 | Scotland |  |  | Wales | BT Murrayfield |  |  | Scotland | 0 |  |  |  |  | 0
 | 6 | Sun, February 14th |  | 17:00:00 | Ireland |  |  | France | Aviva Stadium
 | Week 3 of Matches |  |  |  |  |  |  |  |  |  |  | Wales | 0 |  |  |  |  | 0
 | 7 | Sat, February 27th |  | 17:15:00 | Italy |  |  | Ireland | [NAME]
 | 8 | Sat, February 27th |  | 18:45:00 | Wales |  |  | England | Principality Stadium |  |  | Ireland | 0 |  |  |  |  | 0
 | 9 | Sun, February 28th |  | 18:00:00 | France |  |  | Scotland | [NAME]
 | Week 4 of Matches
 | 10 | Sat, March 13th |  | 17:15:00 | Italy |  |  | Wales | [NAME] |  |  | ENTRY FEE IS £5
 | 11 | Sat, March 13th |  | 18:45:00 | England |  |  | France | [NAME]
 | 12 | Sun, March 14th |  | 17:00:00 | Scotland |  |  | Ireland | BT Murrayfield
 | Week 5 of Matches |  |  |  |  |  |  |  |  |  |  | ENTRANTS NAME :
 | 13 | Sat, March 20th |  | 16:15:00 | Scotland |  |  | Italy | BT Murrayfield
 | 14 | Sat, March 20th |  | 20:45:00 | Ireland |  |  | England | Aviva Stadium |  |  | ENTRANTS E-MAIL ADDRESS :
 | 15 | Sat, March 20th |  | 23:00:00 | France |  |  | Wales | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | SEND ENTRY TO : |  |  |  | [EMAIL]
 |  | Total Tries Scored =
Spreadsheet: 144166d1330737766-pivot-table-help-pivot-table-help
Sheet: PIVOT

 | Sheet 1 Compared to Sheet 2
 | a | b | c | d | e
1
2
3
4
5
6
7
8
9
Spreadsheet: 08b560bd-978c-4eeb-bb21-76ae6979cd25
Sheet: Sheet1

14-002
PRICING/PROPOSAL SCHEDULE
Variations from the aforementioned specifications may be acceptable provided such differences are noted on the bid and are deemed to be advantageous to the City.
Any substitutions from brand names mentioned must be proved to be equal and may be considered for award by the Purchasing Manager and requesting department if so proven.
Invoices will only be paid for per pound, as bid, on item numbers 1, 3, 4, 4B, 5, 6.  They will be paid per foot on item 2 and per piece for items 7, 8, 9, 10.
 |  |  |  |  | Vendor Comments | 3 months | 3 months | 6 months | 6 months | 12 months | 12 months
Quantity |  |  | Description |  |  | Unit Price | Total Price | Unit Price | Total Price | Unit Price | Total Price
1 | 69500 | lbs | 3/8” Rebar Steel in 20’ Lengths THE MINIMUM REINFORCING BAR SHALL BE #3 BARS AND SHALL CONFORM TO ASTM DESIGNATION A-615. | Price Per Lb.
2 | 1500 | feet | #3 (3/8”) Spiraled Rebar   At 30” Diameter Spirals With 6” Between Turns With Total Height Of 12’, One Extra Turn At Top And Bottom. | Price Per Foot
3 | 2980 | lbs | #9 (1-1/8”) Rebar Steel In 12’ Lengths | Price Per Lb.
4 | 6680 | lbs | #4 (1/2”) Rebar Steel (Deformed Bar) in 30” lengths 50 pieces per Bundle | Price Per Lb.
4B | 6680 | lbs | #4 (1/2”) Rebar Steel (Deformed Bar) in 36” lengths 50 pieces per Bundle | Price Per Lb.
5 | 3507 | lbs | #4 (1/2”) Rebar Steel (Deformed Bar) in 36” lengths [NAME] at 18” on a 90 Degree angle to create a 18” x 18” “L” Bar | Price Per Lb.
6 | 188 | lbs | #3 (3/8”) Rebar Steel (Deformed Bar) in 24” lengths, bent at 12” on a 90 degree angle to create a 12”x 12” “L” Bar | Price Per Lb.
7 | 57 | pieces | ½” x 24” Smooth Dowel Bar | Price Per piece
8 | 225 | pieces | [NAME]” Smooth Dowel Bar Caps | Price Per Piece
9 | 200 | pieces | ¾” x 30” Smooth Dowel Bar | Price Per Piece
10 | 200 | pieces | ¾” Smooth Dowel Bar Caps | Price per Piece
DELIVERY TIME:
Does your company allow any sort of discount for prompt payment; if so please list details/payment terms
The term of this price agreement shall be for a
Spreadsheet: 791932d1660662741-formula-for-counting-dates-as-one-with-multiple-entries-within-a-week-number-sameplebook
Sheet: Sheet2

Week number | Date | Hours worked
1 | 2022-08-16 00:00:00 | 4 |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  | Column A represents the week number. Column B is a list of daily entries, to be counted as 1 day though it might contain 3-20 entries. Column C to represent hours worked. Cell H1 is my existing formula that will count the number of days, but I need it to include the week number as a condition to check (cell M1).
1 | 2022-08-16 00:00:00 | 5
2 | 2022-08-16 00:00:00 | 6
2 | 2022-08-16 00:00:00 | 7
2 | 2022-08-19 00:00:00 | 8
3 | 2022-08-17 00:00:00 | 9
3 | 2022-08-18 00:00:00 | 8
3 | 2022-08-17 00:00:00 | 7
3 | 2022-08-20 00:00:00 | 6
4 | 2022-08-16 00:00:00 | 5
4 | 2022-08-17 00:00:00 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Example: By checking how many day-entries in week 2, the desired value should be 2 since there are 2 different dates within week 2. If we were to check for week 1, then the desired value would be 1 since the work hours recorded were on the same day.
Spreadsheet: 023ce056-7d2c-4144-836c-311d9da8fade
Sheet: SY2014-2015 REPORT

 |  |  |  |  | Go to instructions
 | SY2014-2015 Weighted Average Pricing Report
 | This report assists in tracking the pricing requirements and amounts carried forward for SY 2014-2015. Information on this report is used to determine the  SY 2014-2015 weighted average price requirements.  Please print and keep in records.
 | NOTE: If information is changed in the tool, the report contents will change.
 | Section 1: SY2014-2015 Weighted Average Paid Price Requirements
 | A.  SY 2014-15 Weighted Average Price Requirement*: *This price will be entered into the SY 2014-2015 tool to determine the SY2014-2015 weighted average price requirements
 | B.  Optional Price ROUNDED DOWN to nearest 5 cents:
 | Section 2: Amounts Carried Forward to SY 2015-2016 |  |  |  |  |  |  |  | Increase SY2014-2015 average weighted price
 | Select the SY 2014-2015 method used to ensure sufficient funds are provided for PAID Lunches |  |  |  |  |  |  |  | Contribute Non-Federal sources for SY2014-2015
 |  |  |  |  | 1 |  |  |  | Both
 |  |  |  |  |  |  |  |  | 1
Average Weighted Price Adjustments
 | A.  Remaining increase carried forward to SY 2015-16:
 | [NAME] credit carried forward to SY 2015-16:
Non-Federal Source Contributions
 | [NAME] carried forward to SY 2015-16:
 | D.  Remaining Credit carried forward to SY 2015-16:
 | [NAME]
 | [NAME] carried forward to SY 2015-16:
 | F.  Remaining Credit carried forward to SY 2015-16:
Spreadsheet: 746344d1630654500-count-distinct-multiple-criteria-distinct-count
Sheet: Sheet1

Student Number | Subject | Mark
1 | English | 0.89 |  |  | Student | Subject Count
1 | English | 0.79 |  |  | 1 | 4
1 | English | 0.72 |  |  | 2 | 4
1 | English | 0.8 |  |  | 3 | 2
1 | Math | 0.78
1 | Math | 0.9
1 | Science | 0.77
1 | Health | 0.81
2 | English | 0.79
2 | Math | 0.82
2 | Math | 0.9
2 | Science | 0.88
2 | Health | 0.81
3 | English | 0.81
3 | English | 0.76
3 | English | 0.78
3 | Math | 0.84
3 | Math | 0.7
3 | Math | 0.81
Spreadsheet: 767344d1644421001-populating-cells-with-data-from-another-sheet-using-dropdown-managementcoveragesample
Sheet: Overlap

Select Supervisor Below | List |  | Name | Schedule | Overlap |  | Monday1End | Monday2End | Tuesday1End | Tuesday2End | Wednesday1End | Wednesday2End | Thursday1End | Thursday2End | [NAME] | Friday2End
Guy, Supervisor | Guy, Supervisor
 | Gal, Supervisor
Spreadsheet: 858d94c6-5de4-4aa8-b1b2-3db240a8f365
Sheet: PAG 21

CONSOLIDATED BALANCE SHEET | March 2011 | December 2010
R$ million
Assets
Non-current assets
Property, plant and equipment | 7275.436 | 7032.298
Goodwill | 17433.172 | 17441.756
Intangible assets | 1807.216 | 1823.238
Investments in associates | 18.345 | 18.502
Investment securities | 205.267 | 208.742
Deferred tax assets | 1211.236 | 1089.771
Income tax receivable (non-current) | 69.105 | 0
Employee benefits | 20.941 | 20.923
Trade and other receivables | 1900.699 | 2132.121
 | 29941.417 | 29767.351
Current assets
Investment securities (CURRENT) | 1063.068 | 1069.276
Inventories | 2237.098 | 1905.229
Income tax receivable | 123.069 | 181.199
Trade and other receivables (current) | 3641.488 | 3794.072
Cash and cash equivalents | 4641.56 | 5909.34
Assets held for sale | 50.481 | 51.833
 | 11756.764 | 12910.949
Total assets | 41698.181 | 42678.3
Equity and liabilities
Equity
Issued capital | 7634.348 | 7613.78
Reserves | 14791.129 | 16748.083
Retained earnings | 1715.117 | 0
Equity attributable to equity holders of AmBev | 24140.594 | 24361.863
Non-controlling interests | 193.888 | 202.979
Total Equity | 24334.482 | 24564.842
Non-current liabilities
Interest-bearing loans and borrowings | 3561.184 | 4164.214
Employee benefits (non CURRENT) | 961.143 | 966.221
Deferred tax liabilities | 575.256 | 548.728
Trade and other payables (NON CURRENT) | 1237.106 | 1343.367
Provisions (non-CURRENT) | 481.216 | 536.073
 | 6815.905000000001 | 7558.603
Current liabilities
Bank overdrafts | 12.897 | 1.041
Interest-bearing loans and borrowings (current) | 3047.106 | 2606.228
Income tax and social contribution payable | 756.469 | 701.647
Trade and other payables | 6607.351 | 7142.942999999999
Provisions | 123.984 | 102.996
 | 10547.807 | 10554.855
Total liabilities | 17363.712 | 18113.458
Total equity and liabilities | 41698.194 | 42678.3
Spreadsheet: darrell_schoolcraft__7339__imball0203
Sheet: SoCal

 | 10487 |  | 56697
Day | Measured | Scheduled | Measured | Scheduled
1 | -582808 | -589587
2 | -491131 | -493683
3 | -483505 | -493167
4 | -445803 | -487144
5 | -518969 | -516271
6 | -574375 | -598988
7 | -558264 | -565744
8 | -579105 | -609898
9 | -573367 | -599107
10 | -609561 | -607106
11 | -611554 | -604165
12 | -604577 | -604385
13 | -615104 | -618594
14 | -658471 | -683443
15 | -629597 | -639441
16 | -630170 | -627876
17 | -626075 | -638228
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  |  |  | 78487
2002-03-17 00:00:00
CBS Dollars
 |  |  | 277487
Spreadsheet: 53158d1253093917-copying-conditional-formatting-ewrggoldthorpe-stock-levels
Sheet: EWRG Rotherham stock movements

EWRG - Goldthorpe stock transfers
Stock levels at Goldthorpe
Cages | Collapsible | Green steel | Non linear | Pipes | [NAME]
Stock Movements
Date | Vehicle | Driver | Product | Quantity | In/Out | Invoiced | Paid |  | In/Out | Invoiced | Paid
 |  |  |  |  |  |  |  |  | In | Yes | Yes
 |  |  |  |  |  |  |  |  | Out | No | No
Spreadsheet: gerald_nemec__11357__KernAssignmentInfo
Sheet: Sheet1

 |  | Package 1 Volume (Mcf/d) | Contract Number | Package 2 Volume (Mcf/d) | Contract Number
Old Shipper's Legal Name
Misako Resources, Inc. |  | N/A |  | 3000 | 1966
Petro-Canada Hydrocarbons, Inc. |  | N/A |  | 3000
Patina Oil & Gas Corporation |  | 700 | 1922 | 3000 | 1979
J.M. Huber Corporation |  | 700 |  | 3000
Cannon-Interests Houston |  | 700 | 1904 | 3000 | 1953
FM Weld LLC |  | 700 | 1911 | 3000 | 1965
Kennedy Oil Corporation |  | 700 | 1914 | 3000 | 1969
New Shipper's Legal Name
Enron North America Corp.
Spreadsheet: 115689d1311225765-lookup-according-to-current-month-and-lead-time-planner-1-
Sheet: SUMMARY

PARAMETERS | MONTHS STOCK | LEAD TIME (DAYS)
LESS THAN 300 | 14 | 90
BETWEEN 300 AND 1200 | 8
GREATER THAN 1200 | 6
SUMMARY
 |  |  |  | Suggested Order | Actual
STOCK_CODE | CBM | BOX QTY | QTY IN STOCK | 2011-07-01 00:00:00 | Order | CBM
Currently the July Suggested Order is showing requirements in October given a 90 day lead time.
I would like to change the calc in E8, E9, E10 & E11 to show the requirement in say November
by changing the LEAD TIME (DAYS) in cell C2.
Spreadsheet: 683376d1592674128-does-index-and-match-have-to-use-arrays-sorted-in-a-particular-order-match-error
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10000
# | Time | Type | Order | Size | Price | S / L | T / P | Profit | Balance | Raw Date | Raw Time | Use this Date/Time: |  | PL Pips
134 | 2020.06.07 22:00 | close | 66 | 40 | 0.93543 | 0.93142 | 0.93784 | 265.07 | 999819.25
135 | 2020.06.07 22:00 | close | 67 | 38.8 | 0.93546 | 0.93136 | 0.93778 | 514.25 | 1000333.5
136 | 2020.06.07 22:00 | close | 68 | 37.6 | 0.93566 | 0.93095 | 0.93737 | 2187.18 | 1002520.68
133 | 2020.06.07 21:26 | buy | 68 | 37.6 | 0.93487 | 0.93095 | 0.93737
132 | 2020.06.07 21:17 | buy | 67 | 38.8 | 0.93528 | 0.93136 | 0.93778
131 | 2020.06.07 21:15 | buy | 66 | 40 | 0.93534 | 0.93142 | 0.93784
130 | 2020.06.05 19:59 | close | 65 | 37.6 | 0.93642 | 0.93175 | 0.93817 | 2076.43 | 999554.18
129 | 2020.06.05 19:29 | close | 64 | 38.7 | 0.9361 | 0.93189 | 0.93831 | 826.36 | 997477.75
128 | 2020.06.05 19:25 | close | 63 | 39.8 | 0.93602 | 0.93193 | 0.93835 | 498.19 | 996651.39
127 | 2020.06.05 19:18 | buy | 65 | 37.6 | 0.93567 | 0.93175 | 0.93817
126 | 2020.06.05 19:06 | buy | 64 | 38.7 | 0.93581 | 0.93189 | 0.93831
125 | 2020.06.05 19:05 | buy | 63 | 39.8 | 0.93585 | 0.93193 | 0.93835
124 | 2020.06.04 22:03 | close | 62 | 37.5 | 0.93734 | 0.93266 | 0.93908 | 2098.53 | 996153.2
Spreadsheet: 815639d1675116524-compare-multiple-columns-and-rows-in-tables-for-matches-data-table-example
Sheet: Sheet1

Final Result Example
Acct # | Security | Net Trade Cash | Net Trade Units | Price |  | Acct # | Security | Amount | Quantity | Price
1 | Apple | 64 | 90 | 90 |  | 1 | Apple | 64 | 90 | 90
2 | Boats | 58 | 43 | 60 |  | 2 | Boats | 58 | 43 | 60
3 | Cars | 33 | 33 | 46 |  | 3 | Cars | 33 | 33 | 46
4 | Ducks | 59 | 4 | 91 |  | 4 | Ducks | 59 | 4 | 91
5 | Elephants | 20 | 64 | 82 |  | 5 | Elephants | 20 | 64 | 82
5 | Elephants | 90 | 10 | 89 |  | 5 | Elephants | 90 | 10 | 89
5 | Elephants | 52 | 30 | 46 |  | 5 | Elephants | 52 | 30 | 46
6 | Factory | 33 | 18 | 63 |  | 6 | Factory | 33 | 18 | 63
7 | Grapes | 72 | 75 | 48 |  | 7 | Grapes | 72 | 75 | 48
8 | House | 53 | 55 | 20 |  | 8 | House | 53 | 55 | 20
8 | House | 70 | 9 | 49 |  | 8 | House | 70 | 9 | 49
9 | Igloo | 79 | 96 | 75 |  | 9 | Igloo | 79 | 96 | 75
10 | Jam | 54 | 23 | 100 |  | 10 | Jam | 54 | 23 | 100
Acct # | Security | Net Trade Cash | Net Trade Units | Price |  | Acct # | Security | Amount | Quantity | Price
1 | Apple | 64 | 90 | 90 |  | 1 | Apple | 64 | 90 | 90
2 | Boats | 58 | 43 | 60 |  | 2 | Boats | 58 | 43 | 60
3 | Cars | 33 | 33 | 46 |  | 3 | Cars | 33 | 33 | 46
4 | Ducks | 59 | 5 | 91 |  | 4 | Ducks | 59 | 4 | 5
5 | Elephants | 20 | 64 | 82 |  | 5 | Elephants | 20 | 64 | 82
5 | Elephants | 90 | 10 | 89 |  | 5 | Elephants | 90 | 10 | 89
5 | Elephants | 52 | 30 | 46 |  | 5 | Elephants | 52 | 30 | 46
6 | Factory | 33 | 18 | 63 |  | 6 | Factory | 33 | 18 | 63
7 | Grapes | 72 | 75 | 48 |  | 7 | Grapes | 72 | 75 | 48
8 | House | 53 | 55 | 20 |  | 8 | House | 53 | 55 | 20
8 | House | 70 | 9 | 49 |  | 8 | House | 70 | 9 | 49
9 | Igloo | 79 | 96 | 75 |  | 9 | Igloo | 79 | 96 | 75
10 | Jam | 54 | 23 | 100 |  | 10 | Jam | 54 | 23 | 100
What I'm Trying To Do
Just want the "Yes" & "No" functions at the top of each example to be the primary and only cell that calculates the results. My goal is just to keep the formulas and sheets as tidy as possible without filling in tons of hidden columns and check cells. The cells and formulas above work and do what I want but I'm just trying to optimize my work as much as possible because this will be used on a larger scale for some data and I wanted to see if I can have a simple formula that does all the work for me and not have to potentially do a side check for a couple dozen columns and hundreds of rows