tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 168934d1342633492-creating-a-macro-to-move-data-samplebook2
Sheet: After

Year | Month | Item | Type | Supplier | Price
2012 | January | Item 1 | Type A | Supplier X | 61
2013 | January | Item 1 | Type A | Supplier X | 27
2014 | January | Item 1 | Type A | Supplier X | 88
2015 | January | Item 1 | Type A | Supplier X | 73
2016 | January | Item 1 | Type A | Supplier X | 27
2017 | January | Item 1 | Type A | Supplier X | 51
2018 | January | Item 1 | Type A | Supplier X | 77
2012 | February | Item 1 | Type A | Supplier X | 46
2013 | February | Item 1 | Type A | Supplier X | 96
2014 | February | Item 1 | Type A | Supplier X | 90
2015 | February | Item 1 | Type A | Supplier X | 53
2016 | February | Item 1 | Type A | Supplier X | 66
2017 | February | Item 1 | Type A | Supplier X | 35
2018 | February | Item 1 | Type A | Supplier X | 52
2012 | March | Item 1 | Type A | Supplier X | 2
2013 | March | Item 1 | Type A | Supplier X | 53
2014 | March | Item 1 | Type A | Supplier X | 11
2015 | March | Item 1 | Type A | Supplier X | 93
2016 | March | Item 1 | Type A | Supplier X | 90
2017 | March | Item 1 | Type A | Supplier X | 24
2018 | March | Item 1 | Type A | Supplier X | 15
Spreadsheet: 600097d1543463487-enter-data-based-on-2-different-cells-2-columns-different-sheets-grading-excel-form
Sheet: T1 AD

First name | Surname | ID number | Institution | Department | Email address | Attendance: Attendance | Assignment: Professionalism | Quiz: Assistant Directing Quiz #1 | Quiz: Assistant Directing Quiz #2 | Assignment: AD Lesson 3: Assignment (5 Concepts) | Assignment: AD Lesson 4: Assignment (5 Concepts) | Assignment: AD Lesson 5: Assignment (5 Concepts) | Assignment: Call Sheets for Term 1 Character Shoot | Course total
[NAME] ([NAME]) | [NAME] |  |  |  | [EMAIL] | 10 | 18 | 8 | 0 | 9 | 9 | 9 | 17 | 80
Qiran ([NAME]) | [NAME] |  |  |  | [EMAIL] | 8.33 | 15 | 8 | 10 | 0 | 0 | 0 | 16 | 57.33
Muxin | [NAME] |  |  |  | [EMAIL] | 9 | 18 | 6 | 0 | 8 | 8 | 9 | 17 | 75
[NAME] ([NAME]) | [NAME] |  |  |  | [EMAIL] | 10 | 19 | 10 | 10 | 9 | 9 | 9 | 18 | 94
Yiming ([NAME]) | [NAME] |  |  |  | [EMAIL] | 8.33 | 16 | 2 | 0 | 7 | 0 | 0 | 17 | 50.33
[NAME] ([NAME]) | Fang |  |  |  | [EMAIL] | 10 | 18 | 10 | 8 | 7 | 7 | 7 | 17 | 84
Qianyun (Fay) | Fang |  |  |  | [EMAIL] | 10 | 18 | 10 | 10 | 9 | 9 | 9 | 18 | 93
Yichao | Fu |  |  |  | [EMAIL] | - | - | - | - | - | - | - | - | -
Junjie (Riol) | He |  |  |  | [EMAIL] | 10 | 18 | 8 | 6 | 9 | 9 | 9 | 17 | 86
Jiaqing (Agnes) | Kang |  |  |  | [EMAIL] | 9.17 | 18 | 10 | 10 | 8 | 8 | 8 | 18 | 89.17
Yuetong (Isabel) | [NAME] |  |  |  | [EMAIL] | 10 | 18 | 10 | 10 | 8 | 8 | 9 | 17 | 90
[NAME]) | [NAME] |  |  |  | [NAME] | 8.33 | 17 | 8 | 0 | 9 | 0 | 8 | 18 | 68.33
[NAME] (Klader) | [NAME] |  |  |  | [EMAIL] | 9.17 | 19 | 10 | 10 | 9 | 9 | 10 | 18 | 94.17
Ruimin (Vic) | [NAME] |  |  |  | [EMAIL] | 9.17 | 18 | 10 | 10 | 8 | 0 | 0 | 18 | 73.17
[NAME]) | [NAME] |  |  |  | [EMAIL] | 5.83 | 14 | 0 | 0 | 0 | 0 | 0 | 18 | 37.83
[NAME]Seven ） | Qi |  |  |  | [EMAIL] | 8.33 | 17 | 10 | 6 | 7 | 0 | 0 | 18 | 66.33
Junqi (Voang) | [NAME] |  |  |  | [EMAIL] | 10 | 18 | 0 | 0 | 8 | 8 | 7 | 17 | 68
[NAME]） | Xiao |  |  |  | [EMAIL] | 10 | 18 | 8 | 10 | 0 | 8 | 8 | 17 | 79
[NAME] (Leo) | [NAME] |  |  |  | [EMAIL] | 9.17 | 14 | 10 | 8 | 6 | 6 | 7 | 17 | 77.17
Chenyi (Freddie) | Zhang |  |  |  | [EMAIL] | 8.75 | 17 | 0 | 0 | 8 | 7 | 8 | 18 | 66.75
Linfeng (Wayne) | Zhang |  |  |  | [EMAIL] | 10 | 18 | 6 | 6 | 9 | 7 | 8 | 17 | 81
[NAME] (Vlad) | [NAME] |  |  |  | [EMAIL] | 10 | 18 | 10 | 10 | 8 | 8 | 8 | 18 | 90
Xinwei (Will) | [NAME] |  |  |  | [EMAIL] | 10 | 18 | 10 | 10 | 9 | 8 | 8 | 18 | 91
Hui ([NAME]) | Zhu |  |  |  | [EMAIL] | 8.33 | 15 | 8 | 8 | 8 | 8 | 8 | 17 | 80.33
Spreadsheet: 60107d1260631279-percentage-change-assignment-nearly-there
Sheet: Sheet1

 | Student Surname | Student Name | Date Of birth | Student ID | Part A Mark | A % | Part B Mark | B % | Submission Dead Line | Total marks | Total Percentage | Total perentages after deductions | Grade
 | Barnes | [NAME] | 1946-10-03 00:00:00 | 51242 | 10 |  | 6 |  | 2009-05-05 00:00:00 |  |  |  |  |  |  | late submission date
 | [NAME] | [NAME] | 1943-02-12 00:00:00 | 51073 | 5 |  | 7 |  | 2009-05-04 00:00:00 |  |  |  |  |  |  | On Time 5/5/09 | 2009-05-06 00:00:00 | 6
 | dodd | [NAME] | 1939-05-19 00:00:00 | 51451 | 2 |  | 3 |  | 2009-05-03 00:00:00 |  |  |  |  |  |  | 1 week late 12/05/09 | 2009-05-12 00:00:00 | 12
 | gray | [NAME] | 1941-02-24 00:00:00 | 51104 | 5 |  | 4 |  | 2009-05-05 00:00:00 |  |  |  |  |  |  | 2 weeks late 19/05/09 | 2009-05-19 00:00:00 | 19
 | gray | [NAME] | 1949-02-11 00:00:00 | 51407 | 5 |  | 4 |  | 2009-05-07 00:00:00 |  |  |  |  |  |  | 3 weeks late 26/05/09 | 2009-05-26 00:00:00 | 26
 | hoyle | [NAME] | 1941-06-10 00:00:00 | 51289 | 9 |  | 9 |  | 2009-05-05 00:00:00 |  |  |  |  |  |  | after 3 weeks
 | jacobs | [NAME] | 1942-02-18 00:00:00 | 52862 | 7 |  | 6 |  | 2009-06-08 00:00:00
 | [NAME] | Angus | 1940-10-18 00:00:00 | 51986 | 5 |  | 4 |  | 2009-05-03 00:00:00
 | [NAME] | Kirsty | 1943-03-12 00:00:00 | 51932 | 4 |  | 4 |  | 2009-05-03 00:00:00
 | rudkin | [NAME] | 1947-07-08 00:00:00 | 51182 | 4 |  | 6 |  | 2009-05-04 00:00:00
 | [NAME] | Edwina | 1946-10-10 00:00:00 | 51066 | 8 |  | 7 |  | 2009-05-05 00:00:00
 | [NAME] | Mark |  | Average Mark A |  | Average Mark B |  |  | Average mark A\B
 | Fail | <39.5
 | Pass | >39.5 >59.5
 | Merit | >59.5 >79.5
 | Distinction | >79.5
 | late submission date | 2009-05-05 00:00:00 |  |  | 2009-05-06 00:00:00
 | On Time 5/5/09 | 2009-05-06 00:00:00 | 6
 | 1 week late 12/05/09 | 2009-05-12 00:00:00 | 12 |  | 2009-05-05 00:00:00
 | 2 weeks late 19/05/09 | 2009-05-19 00:00:00 | 19 |  | 2009-05-12 00:00:00
 | 3 weeks late 26/05/09 | 2009-05-26 00:00:00 | 26 |  | 2009-05-19 00:00:00
 | after 3 weeks | 2009-06-02 00:00:00 |  |  | 2009-05-26 00:00:00
Spreadsheet: michelle_cash__26506__Mariner Action Items
Sheet: Sheet1

 | Mariner Action Items
Compensation Items:
 | Review employment contracts | Enron Comp
 | Calculate amounts due for each terminated officer. | Enron Comp
 | Review and advise on Severance Plan and Retention Plan | Enron Comp
Mariner Information:
 | Company policies and procedures | [NAME]
 | List of all employees and job titles | [NAME]
 | Organization (Pre- and Post- terminations) | [NAME]
 | Copies of all employment or consulting agreements for affected employees. (AA) | Done
 | Plat of office layout of each floor. | [NAME]
 | Computer hardware, software, network equipment,operating systems | [NAME]
 | Signature authority and line of credit cancellation; | [NAME]?
 | Significant business relationships | [NAME]
 | Retention plan for key personnel | [NAME]
Contacts Required:
 | Reserve 1 conference room at Double Tree for Board Meeting | [NAME]
 | Reserve 4 rooms for individual conferences at Double Tree | [NAME]
 | Reserve 1 conference room at Westlake Club for all employee meeting | [NAME]
 | Arrange for Security personnel at Double Tree, Office, and [NAME](?) | [NAME]
Contacts Required:
(con't)
 | Notify Cab service of need for availability for transportation from Double Tree to individual homes | [NAME]
 | Contract Locksmiths for changing office locks and file locks at office. | [NAME]
 | Contract consultant to secure IT | Seleznov
 | Badge code lock out | [NAME]
 | Arrange for someone to box up personal belongings and courier | [NAME]
 | Ensure Benefits/COBRA preparation. | [NAME]
 | Review Memberships at Country Clubs, Petroleum Clubs, etc. | [NAME]
Spreadsheet: 562733d1519415948-prorate-real-real-estate-taxes-invgrp2-prorate-re-taxes
Sheet: Sheet1

 |  | Period Covered
Payment Amount | Payment Made | From | To |  | [NAME] |  | Settlement Date: | 2018-06-30 00:00:00
2400 | 2017-12-10 00:00:00 | 2018-01-01 00:00:00 | 2018-06-30 00:00:00
2400 | 2018-04-10 00:00:00 | 2018-07-01 00:00:00 | 2018-12-30 00:00:00
2400 | 2018-12-10 00:00:00 | 2019-01-01 00:00:00 | 2019-06-30 00:00:00
Spreadsheet: larry_campbell__21442__AssociateAnalystAirhockeyWithThreeTables
Sheet: Game Chart

 | Associate/Analyst Air Hocky Tournament
 | Players |  | Round One Winners |  | Round Two Winners |  | Round Three Winners |  | Round Four Winners |  | Final Round
 | Hector Alviar |  | Game 1
 | Game 1
 | [NAME] |  |  |  | Game 14
 | [NAME] |  | Game 2
 | Game 2
 | [NAME] |  |  |  |  |  | Game 21
 | [NAME] |  | Game 3
 | Game 3
 | [NAME] |  |  |  | Game 15
 | [NAME] |  | Game 4
 | Game 4
 | Leah Stephens |  |  |  |  |  |  |  | Game 24
 | [NAME] |  | Game 5
 | Game 5
 | [NAME] |  |  |  | Game 16
 | [NAME] |  | Game 6
 | Game 6
 | [NAME] |  |  |  |  |  | Game 22
 | [NAME] |  | Game 7
 | Game 7 |  |  |  |  |  |  |  |  |  | Winner:
 | [NAME] |  |  |  | Game 17
 | [NAME] |  | Game 8 |  |  |  |  |  |  |  | Game 26
 | Game 8
 | [NAME]
 | [NAME] |  | Game 9
 | Game 9
 | [NAME] |  |  |  | Game 18
 | Adrian Woolcock |  | Game 10
 | Game 10 |  |  |  |  |  | Game 23
 | Kendell Sprott
 | [NAME] |  | Game 11
 | Game 11
 | [NAME] |  |  |  | Game 19
 |  |  |  |  |  |  |  |  | Game 25
 | [NAME] |  | Game 12
 | Game 12
 | [NAME]
 | [NAME] |  | Game 13
 | Game 13
 | Sebastien Bouvier |  |  |  | Game 20
 | [NAME]
 | Table One: |  | Monday, November 6th |  | Tuesday, November 7th |  | Wednesday, November 8th
 |  |  | 11:30 - 12:00 - Game 1 |  | 11:30 - 12:00 - Game 13 |  | 11:30 - 12:00 - Game 24
 |  |  | 12:00 - 12:30 - Game 2 |  | 12:00 - 12:30 - Game 14
 |  |  | 12:30 - 1:00 - Game 3 |  | 12:30 - 1:00 - Game 15
 |  |  | 1:00 - 1:30 - Game 4 |  | 1:00 - 1:30 - Game 21
 | Table Two: |  | Monday, November 6th |  | Tuesday, November 7th |  | Wednesday, November 8th
 |  |  | 11:30 - 12:00 - Game 5 |  | 11:30 - 12:00 - Game 16 |  | 11:30 - 12:00 - Game 25
 |  |  | 12:00 - 12:30 - Game 6 |  | 12:00 - 12:30 - Game 17 |  | 12:00 - 12:30 - Game 26
 |  |  | 12:30 - 1:00 - Game 7 |  | 12:30 - 1:00 - Game 22
 |  |  | 1:00 - 1:30 - Game 8
 | Table Three: |  | Monday, November 6th |  | Tuesday, November 7th
 |  |  | 11:30 - 12:00 - Game 9 |  | 11:30 - 12:00 - Game 18
 |  |  | 12:00 - 12:30 - Game 10 |  | 12:00 - 12:30 - Game 19
 |  |  | 12:30 - 1:00 - Game 11 |  | 12:30 - 1:00 - Game 23
 |  |  | 1:00 - 1:30 - Game 12 |  | 1:00 - 1:30 - Game 20
Spreadsheet: 021d0098-1321-4b78-8a1b-c828c73e0d16
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
10/03/2014 | Men's Swimming & Diving | Gold-Blue Meet | 03:00 PM | Gold, 288-277
10/10/2014 | Men's Swimming & Diving | West Virginia State Games (Huntington, W.Va.) | 04:00 PM | First Place
10/11/2014 | Men's Swimming & Diving | West Virginia State Games (Huntington, W.Va.) | 09:00 AM | First Place
10/23/2014 | Men's Swimming & Diving | Penn State | 05:00 PM | L, 98-145
10/25/2014 | Men's Swimming & Diving | at Villanova | 12:00 PM | W, 174-85
11/20/2014 | Men's Swimming & Diving | Mizzou Invite (Columbia, Mo.) | 11:00 AM | Third Place
11/21/2014 | Men's Swimming & Diving | Mizzou Invite (Columbia, Mo.) | 09:00 AM | Third Place
11/22/2014 | Men's Swimming & Diving | Mizzou Invite (Columbia, Mo.) | 09:00 AM | Third Place
12/04/2014 | Men's Swimming & Diving | U.S. Winter Nationals (Greensboro, N.C.)
12/05/2014 | Men's Swimming & Diving | U.S. Winter Nationals (Greensboro, N.C.)
12/06/2014 | Men's Swimming & Diving | U.S. Winter Nationals (Greensboro, N.C.)
01/03/2015 | Men's Swimming & Diving | Orange Bowl Classic (Key Largo, Fla.)
01/10/2015 | Men's Swimming & Diving | at Pitt | 12:00 PM
01/16/2015 | Men's Swimming & Diving | TCU | 06:00 PM
01/30/2015 | Men's Swimming & Diving | at Ohio State | 05:00 PM
02/25/2015 | Men's Swimming & Diving | Big 12 Championships (Austin, Texas)
02/26/2015 | Men's Swimming & Diving | Big 12 Championships (Austin, Texas)
02/27/2015 | Men's Swimming & Diving | Big 12 Championships (Austin, Texas)
02/28/2015 | Men's Swimming & Diving | Big 12 Championships (Austin, Texas)
03/12/2015 | Men's Swimming & Diving | NCAA Zone A Diving Championships (Piscataway, N.J.)
03/13/2015 | Men's Swimming & Diving | NCAA Zone A Diving Championships (Piscataway, N.J.)
03/14/2015 | Men's Swimming & Diving | NCAA Zone A Diving Championships (Piscataway, N.J.)
03/26/2015 | Men's Swimming & Diving | [NAME] (Iowa City, Iowa)
03/27/2015 | Men's Swimming & Diving | [NAME] (Iowa City, Iowa)
03/28/2015 | Men's Swimming & Diving | [NAME] (Iowa City, Iowa)
04/15/2015 | Men's Swimming & Diving | [NAME] at Mesa  Skyline Aquatic Center
Spreadsheet: 13488081-5cc8-4ee2-9192-8e3d05a81a3d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-03-16 09:37:33.810000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.5 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.375 | 101.52 | 101.395 | 101.27 | 100.895
4.25 | 100.945 | 100.82 | 100.695 | 100.32 |  | Note: | Refer To Price [NAME]
4.125 | 100.506 | 100.381 | 100.256 | 99.881 |  |  | For all Price Adjs
4 | 100.012 | 99.887 | 99.762 | 99.137
3.875 | 99.066 | 98.941 | 98.816 | 98.191
3.75 | 98.084 | 97.959 | 97.834 | 97.209
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 101.841 | 101.716 | 101.591 | 101.216
3.75 | 101.527 | 101.402 | 101.277 | 100.902
3.625 | 101.227 | 101.102 | 100.977 | 100.602
3.5 | 100.9 | 100.775 | 100.65 | 100.275
3.375 | 100.316 | 100.191 | 100.066 | 99.441
3.25 | 99.657 | 99.532 | 99.407 | 98.782
3.125 | 99.241 | 99.116 | 98.991 | 98.366 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-03-30 09:37:33.810000
30 DAY | 2012-04-14 09:37:33.810000
45 DAY | 2012-04-29 09:37:33.810000
60 DAY | 2012-05-14 09:37:33.810000
90 DAY | 2012-06-13 09:37:33.810000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 57287d1257398314-help-on-formula-multiple-worksheets-706059-help-on-formula-multiple-worksheets
Sheet: Trade Summary 

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TRADE PACKAGES
 | ABN: 97 000 098 162
 | ACT Level 3 13 London Circuit Canberra ACT 2061 |  |  | NSW 30 The Bond 30 Hickson Road Millers Point Sydney NSW 2000 |  |  | QLD Level 18 240 Queen Street GPO Box 2479 [NAME] |  |  |  |  | SA Delfin House 155 Brebner Drive West Lakes SA 5021 |  |  | VIC Level 32 140 [NAME] Melbourne VIC 3000 |  |  | WA Level 2 Durack Centre 263 Adelaide Terrace Perth WA 6000
 | To: | Coordinator General |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Claim No.: |  |  | 1
 |  | Project Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj No.:
 | Address: | [NAME], Brisbane, Queensland, 4000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date Issued: |  |  | 2009-10-30 00:00:00
 | ABN: | 82 533 440 171 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | For works completed to: | For works completed to:
 | Attention: | Mr [NAME] Representative
Trade Summary | Qty | Description |  |  |  |  |  |  | Original Contract Sum |  | Adjusted Contract Sum |  | Committed Value |  | Completed to Date |  | Previously Claimed |  | This Claim |  | Cost to [NAME]
0330 Piling | TP 0330 | Piling |  |  |  |  |  |  | 1500 | Piling | 1500 | Piling
0420.02 Conc Substructure | TP 0420-1 | Concrete Substructure |  |  |  |  |  |  | 5000 | Concrete Substructure | 5000 | Concrete Substructure
0410 [NAME] | TP 0410 | Concrete Supply |  |  |  |  |  |  | 4000 | Concrete Supply | 4000 | Concrete Supply
0420 Conc Placing | TP 0420 | Concrete Place |  |  |  |  |  |  | 6000 | Concrete Place | 6000 | Concrete Place
0422 Conc Pumping | TP 0422 | Concrete Pumping
0530-1 Formwork | TP 0530-1 | Formwork
0530-2 Formwork | TP 0530-2 | Formwork
0610 Reo Supply | TP 0610 | Reo Supply |  |  |  |  |  |  | 1500 |  | 1500 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
0620 Reo Fixing | TP 0620 | [NAME] |  |  |  |  |  |  | 5000 |  | 5000 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
0631 Post Tensioning | TP 0631 | Post Tensioning |  |  |  |  |  |  | 4000 |  | 4000 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
0830 Blockwork | TP 0830 | Blockwork |  |  |  |  |  |  | 6000 |  | 6000 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
0832 Waterproofing & Tanking | TP 0832 | Waterproofing & Tanking |  |  |  |  |  |  | 5500 |  | 5500 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
1030 Structural Steel | TP 1030 | Structural Steel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
#N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
#N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
#N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
#N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
#N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
#N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | NET TOTAL |  |  | 38500 |  | 38500 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Spreadsheet: 692622d1598465537-sort-data-from-one-tab-to-another-removing-duplicates-load-sheet-mock-up
Sheet: Load sheet Lookup

 |  |  |  |  |  | A1
 |  |  |  |  |  | AA1 |  | #N/A
 |  |  |  |  |  | AAA1 |  | #N/A
 |  |  |  |  |  | CCC |  | #N/A
 |  |  |  |  |  | BBB |  | #N/A
 |  |  |  |  |  | AA1 |  | #N/A
 |  |  |  |  |  | B |  | #N/A
 |  |  |  |  |  | Grip |  | 2
 |  |  |  |  |  | BBB |  | #N/A
 |  |  |  |  |  | C |  | #N/A
 |  |  |  |  |  | CC |  | #N/A
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  | AA1 |  | #N/A
 |  |  |  |  |  | BB |  | #N/A
 |  |  |  |  |  | BBB |  | #N/A
 |  |  |  |  |  | AA1 |  | #N/A
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  | CCC |  | #N/A
 |  |  |  |  |  | Grip |  | 2
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
Spreadsheet: 738534d1625092968-calculating-running-average-cost-example_avg_cost-warehouse-approach-v1-
Sheet: Version7

Limits: |  |  |  |  | TRANSACTION
 |  |  |  |  |  |  |  |  | OUTBOUND |  |  | OUTSTANDING |  |  | P/L
Trade Symbol | Transaction | Date | Sale Portion | [NAME] | Quantity | Price | Fees | Amount | Quantity | Price | Amount | Quantity | Price | Amount | Gain(+) /     Loss(-) | Gain(+) /     Loss(-) per Sales Only |  |  |  | Total Cost | Needed for correct cumulative average cost value |  | Cumulative Units | Cumulative Average Cost | Current Balance (FIFO) | Sales Only -  Separated for RAW data |  | Gain (Loss) P & L | Notes
 | Purchase | 2021-02-22 00:00:00 |  |  | 3.514923 | 14.21 | 0
 | Purchase |  |  |  | 1.95554 | 12.8 | 0
 | Purchase | 2021-02-23 00:00:00 |  |  | 2.121327 | 11.78 | 0
 | Purchase | 2021-03-24 00:00:00 |  |  | 374.242645 | 13.45 | 0
 | Sale | 2021-03-29 00:00:00 | All | Short | -381.834442 | 13.34 | 0
 | Purchase | 2021-04-17 00:00:00 |  |  | 13.380624 | 37.72 | 0
 | Purchase |  |  |  | 12.706329 | 39.39 | 0
 | Purchase | 2021-04-27 00:00:00 |  |  | 28.600846 | 35.18 | 0
 | Purchase | 2021-05-04 00:00:00 |  |  | 74.626678 | 67.52 | 0
 | Purchase |  |  |  | 270.208195 | 74.56 | 0
 | Sale | 2021-05-04 00:00:00 | All | Short | -399.522672 | 78.52 | 0
 | Purchase | 2021-05-04 00:00:00 |  |  | 179.734944 | 84.04 | 0
 | Purchase | 2021-05-05 00:00:00 |  |  | 49.622456 | 101.4 | 0
 | Purchase |  |  |  | 246.20782 | 102.55 | 0
 | Purchase |  |  |  | 165.37101 | 103.4 | 0
 | Sale | 2021-05-05 00:00:00 | All | Short | -640.93623 | 104.18 | 0
 | Purchase | 2021-05-05 00:00:00 |  |  | 30.301633 | 99.03 | 0
 | Purchase | 2021-05-06 00:00:00 |  |  | 276.819944 | 145.41 | 0
 | Sale | 2021-05-06 00:00:00 | All | Short | -307.121577 | 168.49 | 0
 | Purchase | 2021-05-06 00:00:00 |  |  | 277.1079 | 182.23 | 0
 | Purchase |  |  |  | 138.149505 | 182.77 | 0
 | Sale | 2021-05-08 00:00:00 | Partial | Short | -107.381606 | 127.43 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Should be a negative number … here is where things get complicated…
 | Sale | 2021-06-30 00:00:00 | Partial | Short | -100 | 50 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | How do we get Q26 to show a value that represents a portion of the loss based on the fact that this partial sale was done to minimize some of the losses when the price dropped $55 per share? That value should equate to somewhere around $5000.00
Totals: |  |  |  | Purchase
 |  |  |  | Sale
Spreadsheet: 886130d1736167942-sorting-data-from-a-dynamic-list-sorting-data-from-a-dynamic-list
Sheet: Sheet1

Number of Stops | Road Name | Stops effected | Closure Type |  | [NAME] by column |  |  |  |  | [NAME] by column |  |  |  |  | Combined formula
 | EDGWARE WAY | 15758, 16105, 14702 | Publicity Only, Publicity & Hood, Publicity Only |  |  |  |  |  |  |  |  |  |  |  |  | EDGWARE WAY | 15758, 16105, 14702 | Publicity Only, Publicity & Hood, Publicity Only
1 | EDGWAREBURY LANE (N AND S OF A41) | 15760 | Publicity Only |  | 1 | EDGWAREBURY LANE (N AND S OF A41) | 15760 | Publicity Only |  | 1 | EDGWAREBURY LANE (N AND S OF A41) | 15760 | Publicity Only |  | 1 | EDGWAREBURY LANE (N AND S OF A41) | 15760 | Publicity Only
1 | GLOUCESTER PLACE | 29797 | Publicity & Hood |  | 1 | GLOUCESTER PLACE | 29797 | Publicity & Hood |  | 1 | GLOUCESTER PLACE | 29797 | Publicity & Hood |  | 1 | GLOUCESTER PLACE | 29797 | Publicity & Hood
1 | STATION ROAD | 25118 | Publicity Only |  | 3 | EDGWARE WAY | 15758, 16105, 14702 | Publicity Only, Publicity & Hood, Publicity Only |  | 3 | EDGWARE WAY | 15758, 16105, 14702 | Publicity Only, Publicity & Hood, Publicity Only |  | 1 | STATION ROAD | 25118 | Publicity Only
EXAMPLE OF OUTCOME
Number of Stops | Road Name | Stops effected | Closure Type
1 | station road | 25118 | Publicity only
1 | edgwarebury lane | 15760 | Publicity only
1 | gloucester place | 29797 | publicity & hood
2 | [NAME] | 15758, 14702 | Publicity only
1 | [NAME] | 16105 | publicity & hood