tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1b640b8c-e4d5-4d90-8e10-615c2f5dacfe
Sheet: Sheet1

State of New Hampshire - Primary Election | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Executive Council - District No. 4            Republican
2012-09-11 00:00:00 | [NAME], r | [NAME], r | [NAME], r | [NAME], d | [NAME]
Allenstown | 115 | 81 | 60 | 1
Auburn | 164 | 123 | 330
[NAME] | 280 | 197 | 80 |  | 4
Bedford | 812 | 678 | 1214 | 1
Bow | 318 | 202 | 315
Candia | 126 | 122 | 248
Chichester | 143 | 111 | 57
[NAME] | 163 | 103 | 159 |  | 3
[NAME] | 222 | 171 | 70 | 3
Goffstown | 613 | 518 | 433 | 2
[NAME] | 348 | 562 | 389 | 4
[NAME] | 71 | 85 | 44 |  | 1
[NAME] | 684 | 445 | 750 |  | 1
Loudon | 277 | 111 | 160 | 7
[NAME] | 279 | 357 | 413 | 7
[NAME] | 198 | 304 | 197 | 4
[NAME] 3 | 99 | 103 | 125 | 3
[NAME]* | 122 | 201 | 87 | 2
[NAME] | 77 | 127 | 69
[NAME] 6 | 245 | 340 | 145 | 4
[NAME] | 154 | 269 | 101 | 1
[NAME] 8 | 216 | 396 | 192
[NAME] 9 | 163 | 273 | 98
[NAME] 10 | 201 | 255 | 135 | 3
[NAME] 11 | 167 | 191 | 70
[NAME] 12 | 205 | 205 | 129 | 3
Northwood | 161 | 111 | 89 | 1
[NAME] | 165 | 104 | 109
Pembroke | 194 | 164 | 149 | 1
Pittsfield | 141 | 110 | 81
Totals | 7123 | 7019 | 6498 | 47
*corrections received from ward clerk
Spreadsheet: lynn_blair__24464__packstat01
Sheet: Jan01

COMMENTS | Plan Status Code | packet # | CUST | REGION | POI | CONTRACT # | TRANS TYPE | DEAL TYPE | ACCT MGR | DEAL MONTH | DEAL DATE | INJ/WD | PROD MTH | PROJ MTH TOTAL | PACKET BALANCE AS OF 1/26/01 | Days Remaining | Approx Daily Volume Required to Balance Contract (may require rounding adj)
 | MTM | 106548 | Tenaska Marketing Ventures |  | 62389 | 21229 | SEAS |  | Neville | 2000-04-01 00:00:00 | 2000-04-13 00:00:00 | i | 2000-12-01 00:00:00 | 229499 | 229499
 | MTM | 106548 | Tenaska Marketing Ventures |  | 62389 | 21229 | SEAS |  | Neville | 2000-04-01 00:00:00 | 2000-04-13 00:00:00 | w | 2001-01-01 00:00:00 | -229499 | -229499
 |  | 106548 Total
 | MTM | 106549 | Tenaska Marketing Ventures |  | 62389 | 21229 | BACK |  | Neville | 2000-04-01 00:00:00 | 2000-04-13 00:00:00 | w | 2000-12-01 00:00:00 | -229499 | -229499
 | MTM | 106549 | Tenaska Marketing Ventures |  | 62389 | 21229 | BACK |  | Neville | 2000-04-01 00:00:00 | 2000-04-13 00:00:00 | i | 2001-01-01 00:00:00 | 229499 | 229499
 |  | 106549 Total
 | Traditional | 106662 | Cibola Energy Services |  | 71460 | 21228 | SEAS |  | Neville | 2000-05-01 00:00:00 | 2000-05-16 00:00:00 | i | 2000-07-01 00:00:00 | 500000 | 500000
 | MTM | 106662 | Cibola Energy Services |  | 71460 | 21228 | SEAS |  | Neville | 2000-05-01 00:00:00 | 2000-05-16 00:00:00 | w | 2001-01-01 00:00:00 | -500000 | -500000
 |  | 106662 Total
 | MTM | 106676 | Williams Energy Marketing & Trading Co. |  | 71460 | 100648 | SEAS |  | Gottsponer | 2000-05-01 00:00:00 | 2000-05-22 00:00:00 | i | 2000-10-01 00:00:00 | 620000 | 620000
 | MTM | 106676 | Williams Energy Marketing & Trading Co. |  | 71460 | 100648 | SEAS |  | Gottsponer | 2000-05-01 00:00:00 | 2000-05-22 00:00:00 | w | 2001-01-01 00:00:00 | -620000 | -620000
 |  | 106676 Total
 | MTM
 | MTM
 | MTM
 | MTM
 | MTM
 | Traditional
 | Traditional
 | Traditional
 | Traditional
Customer has option to change withdrawal month from dec to nov 2000 if they notify us no later than 10/27/00 | Traditional
Customer has option to change withdrawal month from dec to nov 2000 if they notify us no later than 10/27/03 | Traditional
 | Traditional
 | Traditional
 | MTM
 | MTM
 | MTM
 | MTM
 | MTM
 | MTM
 | MTM
 | MTM
 | MTM
 | MTM
 | Incremental Seasonal Pkg
 | Incremental Seasonal Pkg
 | Incremental Seasonal Pkg
 | Traditional
 |  | Grand Total
Spreadsheet: 806342d1669240298-return-text-from-a-cell-if-it-contains-one-of-many-texts-s666-pq-return-text-from-a-cell-if-it-contains-one-of-many-texts
Sheet: Sheet1

Campaign |  | Criteria |  | Campaign | Criteria
brand category Vegetable intent exact |  | Vegetable, Fruit, Dairy, Grain, Cheese, Corn |  | brand Vegetable category intent exact | Vegetable
brand  Fruit intent exact |  |  |  | brand Fruit intent exact | Fruit
brand category Dairy intent exact |  |  |  | brand category Dairy intent exact | Dairy
brand option Grain affinity exact |  |  |  | brand option Grain affinity exact | Grain
brand category Cheese intent exact |  |  |  | brand category Cheese intent exact | Cheese
brand option 2 Corn custom exact |  |  |  | brand option 2 Corn custom exact | Corn
Spreadsheet: 126155d1319549756-excel-2007-complicated-sumifs-formula-forumexample
Sheet: Sheet1

 | Part # | Kit Indicator | Structure | Price |  | One Kit (in Green) total price = $10.00
Parent Part | 555C | V | 4 | 0 |  | V denotes this is a kit I want to sum until the structure value is less than the parent kit indicator "4" in this case.
 | 777D |  | 5 | 1.5
 | 888E |  | 5 | 1.75
 | 999F |  | 5 | 2
 | 444Q |  | 6 | 2.25
 | 333C |  | 6 | 2.5
Parent Part | 555G | T | 3 | 0
 | 555D |  | 4 | 3.5
 | 444X |  | 5 | 3.75
Parent Part | 555Y | V | 2 | 0
 | 333T |  | 3 | 6.25 |  | One Kit in orange total price = 12.75
 | 444R |  | 4 | 6.5 |  | V denotes this is a kit I want to sum until the structure value is less than the parent kit indicator "2" in this case
Parent Part | 333P | G | 1 | 0
 | 222M |  | 4 | 7.5
 | 111F |  | 4 | 7.75
 |  | I want to find the parts where the kit indicator = V, and then sum up the price column until the structure value is lower
 |  | than the Kit Indicator's original structure value.
 |  | Once the structure number is lower than the original it indicates the start of a new kit.
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: Unofficial

 |  | h'cap | off H'cap | adj | SCORES | POST | Cut | Increase | TOTAL
 | Number of Players
 | top two-thirds
Spreadsheet: eric_saibi__9825__092701R
Sheet: Blenheim 03

Owner Name | New York Power Authority
Station Name | Blenheim-Gilboa Pumped Storage Power Station
Unit Name | Hydro 03
NERC Region | NPCC
State | NY
Fuel Type | Hydro
Capacity | 250 MW
Start Date | 2001-11-04 00:00:00
End Date | 2001-11-24 00:00:00
Prv. Start Date | 2001-10-26 00:00:00
Prv. End Date | 2001-11-15 00:00:00
Comments | Cavitation repairs
SIC | 4911
Plant ID | 1501795
Unit ID | 1004754
Outage ID | 14117
Spreadsheet: 84713d1284720751-find-out-the-grand-total-from-different-sheets-on-a-summary-sheet-book1
Sheet: Sheet4

OIL ENGINE 10 W 30 - SJ GRADE | 1100661 | 58
COVER CYLINDER HEAD | 12301-GB6-9000 | 59
COVER R CYLINDER HEAD SIDE | 12331-GB0-9100 | 60
COVER L CYLINDER HEAD SIDE | 12341-GB6-9100 | 61
HOLE CAP TAPPET ADJUSTING | [PHONE] | 62
GASKET CYLINDER HD R SIDE COVER | 12395-GW8-6810 | 65
SPARK PLUG | 98056-57718-01 | 66
NUT CAP 7MM | 90201-GF6-0000 | 67
WASHER SEALING 7 MM | 90442-GF6-0000 | 68
Spreadsheet: 733643d1621679040-index-match-with-multiple-column-criterion-example
Sheet: Output

 | 2021 | 2022 | 2023
Direct Labor
Labor Category 1
Labor Category 2
Labor Category 3
Fringe
Labor Category 1
Labor Category 2
Labor Category 3
Facility
Labor Category 1
Labor Category 2
Labor Category 3
Overhead
Labor Category 1
Labor Category 2
Labor Category 3
Spreadsheet: 816670d1675773871-sick-time-accrual-with-previous-year-carry-over-sick-time-calculator
Sheet: Beth Czeladyn

Sick Time Calculated
Employee Name |  |  |  |  | Date of Hire | 2023 Used Sick Time | Previous Year Carry Over
[NAME] |  |  |  |  |  |  | 6
Payroll Week | Sunday-Saturday | Vacation | Holiday | Hours Worked | Weekly Total | [NAME] | Total Accrued Sick | Sick Used | Sick Available
Week Ending | 2023-01-07 00:00:00 |  | 8 | 35.26
Week Ending | 2023-01-14 00:00:00 |  | 8 | 33.53
Week Ending | 2023-01-21 00:00:00 |  |  | 41.57
Week Ending | 2023-01-28 00:00:00 |  |  | 29.35 |  |  |  | 7
Week Ending | 2023-02-04 00:00:00 |  |  | 39.47
Week Ending | 2023-02-11 00:00:00
Week Ending | 2023-02-18 00:00:00
Week Ending | 2023-02-25 00:00:00
Week Ending | 2023-03-04 00:00:00
Week Ending | 2023-03-11 00:00:00
Week Ending | 2023-03-18 00:00:00
Week Ending | 2023-03-25 00:00:00
Week Ending | 2023-04-01 00:00:00
Week Ending | 2023-04-08 00:00:00
Week Ending | 2023-04-15 00:00:00
Week Ending | 2023-04-22 00:00:00
Week Ending | 2023-04-29 00:00:00
Week Ending | 2023-05-06 00:00:00
Week Ending | 2023-05-13 00:00:00
Week Ending | 2023-05-20 00:00:00
Week Ending | 2023-05-27 00:00:00
Week Ending | 2023-06-03 00:00:00
Week Ending | 2023-06-10 00:00:00
Week Ending | 2023-06-17 00:00:00
Week Ending | 2023-06-24 00:00:00
Week Ending | 2023-07-01 00:00:00
Week Ending | 2023-07-08 00:00:00
Week Ending | 2023-07-15 00:00:00
Week Ending | 2023-07-22 00:00:00
Week Ending | 2023-07-29 00:00:00
Week Ending | 2023-08-05 00:00:00
Week Ending | 2023-08-12 00:00:00
Week Ending | 2023-08-19 00:00:00
Week Ending | 2023-08-26 00:00:00
Week Ending | 2023-09-02 00:00:00
Week Ending | 2023-09-09 00:00:00
Week Ending | 2023-09-16 00:00:00
Week Ending | 2023-09-23 00:00:00
Week Ending | 2023-09-30 00:00:00
Week Ending | 2023-10-07 00:00:00
Week Ending | 2023-10-14 00:00:00
Week Ending | 2023-10-21 00:00:00
Week Ending | 2023-10-28 00:00:00
Week Ending | 2023-11-04 00:00:00
Week Ending | 2023-11-11 00:00:00
Week Ending | 2023-11-18 00:00:00
Week Ending | 2023-11-25 00:00:00
Week Ending | 2023-12-02 00:00:00
Week Ending | 2023-12-09 00:00:00
Week Ending | 2023-12-16 00:00:00
Week Ending | 2023-12-23 00:00:00
Week Ending | 2023-12-30 00:00:00
Spreadsheet: 272815d1382521400-list-all-products-based-on-entered-value-in-cell-sample
Sheet: Sheet1

TEST FILE
ID | product |  |  |  | ENTER ID
2222 | test1
2222 | test2 |  |  |  | Products
2222 | test3
2222 | test4
2222 | test5
3333 | test6
3333 | [NAME]
3333 | test8
3333 | test9
3333 | test10
3333 | test11
3333 | test12
4444 | test13
4444 | test14
4444 | test15
4444 | test16
4444 | test17
4444 | test18
Spreadsheet: 840209d1692557591-transforming-database-with-formulas-transforming-database-with-formula-1-
Sheet: Starting Base

 | This is the original database, I need to transform this with formula or power query or somethong to result like: [NAME]
 | in [NAME] | some information is simplified..
 | Date | Account | General ledger account | Mapped | Creditor number | SO/PO | Our ref. | VAT code | Transaction:Subtype | Your reference | Description | Cost unit | Currency code | Debit | Credit | Amount | Amount in DC | Project | Cost centre | Fulfilment date | General ledger transactions: free field 2 | Doc. date | Item group | Entry number | Selection code | Item | Description:Item | Type | General ledger transactions: free field 1 | General ledger transactions: free field 3 | General ledger transactions: free field 4 | General ledger transactions: free field 5 | Quantity | Sales order debtor | Classification | Created by | Modified by | Package of origin of transaction | Search code statistical system | Search code transaction A | Transport method search code | Search code city of loading/unloading | Unique posting number | Debtor number
1 Transaction | 2022-03-01 00:00:00 | ალექსანდრე Aleksandr კოსილოვ [NAME] | 122001 | Cash and cash equivalents | 3089 |  |  | 0 | Payment | 01/31/2022(6) | [NAME] FOR JANUARY KOSILOV ALEKSANDR_x000D_ ACCORDING TO CONTRACT |  | USD | 0 | 1080.54
1 Transaction | 2022-03-01 00:00:00 | ალექსანდრე Aleksandr კოსილოვ [NAME] | 313100 | Trade and other payables | 3089 |  |  | 0 | Payment | 01/31/2022(6) | [NAME] FOR JANUARY KOSILOV ALEKSANDR_x000D_ ACCORDING TO CONTRACT |  | USD | 1080.54 | 0
 | 2022-03-01 00:00:00 | შპს ვესტა | 311000 | Trade and other payables | 4328 |  | 20004774 | 0 | Other | ა/ფ ეა-74 5611772,ელ0651246103 | Reallocate: Crd.4328 => Crd.3006 |  | GEL | 40 | 0
 | 2022-03-01 00:00:00 | [NAME] | 143000 | Trade and other receivables | 3006 |  | 20004774 | 0 | Other | ა/ფ ეა-74 5611772,ელ0651246103 | Reallocate: Crd.4328 => Crd.3006 |  | GEL | 0 | 40
 | 2022-03-02 00:00:00 | ამხანაგობა პისიარ დიაგნოსტიკური და კვლევითი ლაბორა | 721026 | Cost of sales | 4379 |  | 20004767 | 0 | Purchase invoice | ინვ.#008 | COVID 19-ის PCR ტესტირება |  | GEL | 400 | 0
 | 2022-03-02 00:00:00 | ამხანაგობა პისიარ დიაგნოსტიკური და კვლევითი ლაბორა | 311000 | Trade and other payables | 4379 |  | 20004767 | 0 | Purchase invoice | ინვ.#008 | COVID 19-ის PCR ტესტირება |  | GEL | 0 | 400
 | 2022-03-02 00:00:00 | შპს ჰელიქსირ | 165000 | Inventories |  | 611 | 10012775 | 0 | Fulfilment | ეა-74 5968634. [PHONE] | მარტი 2022 |  | GEL | 0 | 4319.9
 | 2022-03-02 00:00:00 | შპს ჰელიქსირ | 721001 | Cost of sales |  | 611 | 10012775 | 0 | Fulfilment | ეა-74 5968634. [PHONE] | მარტი 2022 |  | GEL | 4319.9 | 0
Spreadsheet: 366176d1419146007-how-to-distribute-equally-among-individuals-id-distribute
Sheet: Sheet1

ID | Allocation
M7957002
M7723005
M1004004 |  |  |  |  | Table-Employees
M1004004 |  |  |  |  | Sl No | Name
E7957002 |  |  |  |  | 1 | [NAME]
M1004004 |  |  |  |  | 2 | Anna
[NAME] |  |  |  |  | 3 | Maria
M1004004 |  |  |  |  | 4 | Ria
M7941001
[NAME]
M7941001
M7723005
M7941001
M7941001
M1004004
M7836004
M7836005
M2627002
M5723004
M5723004
Spreadsheet: 886079d1736073398-formula-to-extract-code-book1pr
Sheet: Sheet1

Date | Reference | Procedure | Procedure
30/11/2024 | INV24072915 | Consultation 1(PR3611) | PR3611
30/11/2024 | INV24072914 | Consultation 1(PR3611) | PR3611
30/11/2024 | INV24072913 | Complex Procedure 10(PR2318) | PR2318
30/11/2024 | INV24072913 | Complex Procedure 6 C24(PR2314) | PR2314
30/11/2024 | INV24072913 | Package 1 - Lipo 360(PR2558) | PR2558
30/11/2024 | INV24072912 | In Office [NAME]) | PR0328
30/11/2024 | INV24072911 | Panoramic X ray ( OPG ) (Tooth#:36)(PR2448) | PR2448
30/11/2024 | INV24072911 | Scaling Polishing B (Tooth#:35)(PR0911) | PR0911
30/11/2024 | INV24072910 | Scaling Polishing B (Tooth#:33)(PR0911) | PR0911
30/11/2024 | INV24072909 | Free consultation(PR0017) | PR0017
30/11/2024 | INV24072908 | Botox  1(PR1747) | PR1747
30/11/2024 | INV24072908 | Plasma (PRP) Scalp/ Face              2(PR1798) | [NAME]
30/11/2024 | INV24072907 | Scaling Polishing C (Tooth#:27)(PR0912) | PR0912
30/11/2024 | INV24072906 | M Re RCT ONE (Tooth#:45)(PR0049) | PR0049
30/11/2024 | INV24072905 | Free consultation(PR0017) | PR0017
30/11/2024 | INV24072904 | Retouch(PR1062) | PR1062
30/11/2024 | INV24072903 | Retouch(PR1062) | PR1062
30/11/2024 | INV24072902 | Composite Filling with fiber Post (Tooth#:45)(PR0021) | PR0021
30/11/2024 | INV24072902 | Unspecified Dental Procedure XII (Tooth#:46)(PR0663) | PR0663
30/11/2024 | INV24072901 | M RCT ONE (Tooth#:45)(PR0045) | PR0045
30/11/2024 | INV24072901 | M RCT ONE (Tooth#:46)(PR0045) | PR0045
30/11/2024 | INV24072900 | Free consultation(PR0017) | PR0017
30/11/2024 | INV24072899 | Laser Full Body(PR1031) | PR1031
Spreadsheet: 7a2d0dbd-b0e0-467e-a936-042ad90d5fd8
Sheet: Sheet1

Title | Upload Date | Module | Authors | Print Publication Date | DOI | ISBN | Sub-discipline | LINK | Site Module Name
The EAE Textbook of Echocardiography | Mar-11 | The European Society of Cardiology Textbooks | Galiuto, [NAME], Fox, [NAME], [NAME] | 2011 | 10.1093/med/[PHONE].001.0001 | 9780199599639 | Clinical Medicine, Cardiology, Radiology, Doctor, Qualified, specialist, The European Society of Cardiology Textbooks | http://oxfordmedicine.com/view/10.1093/med/[PHONE].001.0001/med-[PHONE] | OXMEDO_SERIES:the_european_society_of_cardiology_textbooks
The ESC Textbook of Cardiovascular Medicine | Aug-09 | The European Society of Cardiology Textbooks | Camm, Lüscher, Serruys | 2009 | 10.1093/med/[PHONE].001.0001 | 9780199566990 | Clinical Medicine, Cardiology, Radiology, Nuclear Medicine, Clinical Pharmacology and Therapeutics, Endocrinology and Diabetes, Neurology, Renal Medicine, Surgery, Urology, Infectious Diseases, Sports and Exercise Medicine, Obstetrics and Gynaecology, Obstetrics, Doctor, Qualified, late specialism training, [NAME], specialist, The European Society of Cardiology Textbooks | http://oxfordmedicine.com/view/10.1093/med/[PHONE].001.0001/med-[PHONE] | OXMEDO_SERIES:the_european_society_of_cardiology_textbooks
The ESC Textbook of Intensive and Acute Cardiac Care | Jan-11 | The European Society of Cardiology Textbooks | Tubaro, Danchin, Filippatos, Goldstein, Vranckx, [NAME] | 2011 | 10.1093/med/[PHONE].001.0001 | 9780199584314 | Clinical Medicine, Cardiology, Doctor, Qualified, late specialism training, [NAME], specialist, The European Society of Cardiology Textbooks | http://oxfordmedicine.com/view/10.1093/med/[PHONE].001.0001/med-[PHONE] | OXMEDO_SERIES:the_european_society_of_cardiology_textbooks
Spreadsheet: 1b20855f-18a9-402a-b7b2-34d1fd2e9e75
Sheet: Sheet1

_____________________ | 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 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
([NAME] pavadinimas)
____________________
([NAME] kodas)
BUHALTERINĖ PAŽYMA
Klaidingiems įrašams taisyti
____ m. ________ mėn. __ [NAME]. _____
______________________
(Sudarymo vieta)
Eil. Nr. | Taisoma operacija |  |  |  |  |  |  | Taisytinas įrašas |  |  |  | Įrašas, taisantis sąskaitų koresp. |  |  |  | Suma (Lt)
 | registravi- mo vieta ir Nr. |  | data | trumpas turinys |  |  |  | [NAME]. Nr. |  | [NAME] sąsk.  Nr. |  | [NAME]. Nr. |  | [NAME] sąsk.  Nr.
1 | 2 |  | 3 | 4 |  |  |  | 5 |  | 6 |  | 7 |  | 8 |  | 9
Parengė
 |  |  |  |  | (Pareigos) |  |  |  |  | (Parašas) |  |  |  |  | ([NAME], pavardė)
Patikrino
 |  |  |  |  | (Pareigos) |  |  |  |  | (Parašas) |  |  |  |  | ([NAME], pavardė)
Spreadsheet: 126828d1319985990-number-in-a-range-book1_chloe88
Sheet: Sheet1

Numbers |  | 80-100 |  | 170-190 |  | Combined
103.6809
125.3855
146.654
135.6578
146.8365
134.2396
98.007
46.511
136.905
167.7231
131.4672
95.449
179.207959
67.458
128.0432
88.7454
152.9375
132.1276
49.812
87.3532
136.472
89.1676
67.607
165.8708
94.6578
67.156
103.7492
98.1941
123.6853
176.62867
120.8584
169.9319
169.9319
Spreadsheet: 808542d1670511240-2-formulas-subtract-from-specific-columns-formulatest
Sheet: Pivot

 |  | Values
Department | Name | Sum of Target | Sum of Jun-22 | Sum of Jul-22 | Sum of Aug-22 | Sum of Sep-22 | Sum of Oct-22 | Sum of Nov-22 | Sum of Dec-22 | Sum of Field2 | Sum of Dec-Nov | Sum of Dec-Target
DepC | Person19 | 68 | 1515 | 2351 | 2303 | 2224 | 2033 | 2026 | 2175 | 660 | 149 | 2107
 | Person21 | 9 | 1854 | 2324 | 1614 | 2223 | 2319 | 1766 | 2047 | 193 | 281 | 2038
 | Person23 | 4987 | 2069 | 1812 | 2400 | 1712 | 2312 | 2335 | 1818 | -251 | -517 | -3169
 | Person25 | 9848 | 1952 | 1549 | 1793 | 2343 | 1512 | 2067 | 1763 | -189 | -304 | -8085
 | Person27 | 18 | 2126 | 2012 | 1851 | 2415 | 2045 | 2395 | 1988 | -138 | -407 | 1970
DepC Total |  | 14930 | 9516 | 10048 | 9961 | 10917 | 10221 | 10589 | 9791 | 275 | -798 | -5139
[NAME] | [NAME] | 897 | 1522 | 2197 | 1628 | 2211 | 2276 | 2118 | 2359 | 837 | 241 | 1462
 | Person22 | 598 | 1807 | 1754 | 2188 | 2036 | 1795 | 1529 | 2072 | 265 | 543 | 1474
 | Person24 | 98 | 2406 | 1649 | 1761 | 2191 | 1688 | 1983 | 1530 | -876 | -453 | 1432
 | Person26 | 99 | 2484 | 2399 | 1784 | 1517 | 2353 | 2365 | 1886 | -598 | -479 | 1787
 | Person28 | 9 | 1726 | 2330 | 1500 | 2244 | 2455 | 2199 | 2091 | 365 | -108 | 2082
[NAME] |  | 1701 | 9945 | 10329 | 8861 | 10199 | 10567 | 10194 | 9938 | -7 | -256 | 8237
DeptA | Person1 | 5250 | 5879 | 6917 | 5795 | 5472 | 5871 | 5545 | 5494 | -385 | -51 | 244
 | Person11 | 1255 | 2091 | 1849 | 1586 | 2076 | 1638 | 2297 | 1943 | -148 | -354 | 688
 | [NAME] | 654 | 2335 | 2472 | 2031 | 1855 | 2421 | 1684 | 1655 | -680 | -29 | 1001
 | Person15 | 651 | 1850 | 2114 | 2374 | 2423 | 2123 | 2160 | 2252 | 402 | 92 | 1601
 | Person17 | 651 | 1953 | 1551 | 1674 | 1525 | 1812 | 1794 | 1954 | 1 | 160 | 1303
 | Person7 | 2485 | 2115 | 1539 | 2495 | 2059 | 1569 | 2387 | 1647 | -468 | -740 | -838
 | Person9 | 251 | 2077 | 2245 | 2361 | 2313 | 1512 | 2399 | 1640 | -437 | -759 | 1389
DeptA Total |  | 11197 | 18300 | 18687 | 18316 | 17723 | 16946 | 18266 | 16585 | -1715 | -1681 | 5388
DeptB | Person1 | 1750 | 2499 | 2433 | 2196 | 2047 | 2128 | 2500 | 2498 | -1 | -2 | 748
 | Person10 | 25455 | 1890 | 2344 | 2241 | 2349 | 1543 | 2059 | 1966 | 76 | -93 | -23489
 | Person12 | 255 | 2335 | 2093 | 1857 | 1922 | 2437 | 2215 | 1611 | -724 | -604 | 1356
 | Person14 | 654 | 2015 | 1980 | 2418 | 1507 | 1582 | 1988 | 2391 | 376 | 403 | 1737
 | Person16 | 651 | 1927 | 2137 | 2495 | 1540 | 2298 | 2314 | 2293 | 366 | -21 | 1642
 | Person18 | 651 | 1871 | 2455 | 2449 | 2224 | 1987 | 1561 | 2195 | 324 | 634 | 1544
 | Person2 | 1300 | 2322 | 2073 | 1579 | 1974 | 2115 | 1637 | 1520 | -802 | -117 | 220
 | Person6 | 1250 | 1720 | 1622 | 1611 | 1787 | 2445 | 2345 | 1865 | 145 | -480 | 615
 | Person8 | 2552 | 1749 | 1679 | 2371 | 1628 | 1935 | 1633 | 2359 | 610 | 726 | -193
DeptB Total |  | 34518 | 18328 | 18816 | 19217 | 16978 | 18470 | 18252 | 18698 | 370 | 446 | -15820
Grand Total |  | 62346 | 56089 | 57880 | 56355 | 55817 | 56204 | 57301 | 55012 | -1077 | -2289 | -7334
Spreadsheet: 47043d1245946409-excel-2007-retrieving-price-based-on-date-or-period-it-falls-in-sample1
Sheet: Sheet1

 | 2009
Low | 525 |  | [NAME] used
Mid | 550 |  | =($B$4/7)*B11
High | 575
Peak | 649
 | Low | Mid | High | Peak | Total Days
No. Days | 0 | 7 | 7 | 0
 | Low | Mid | High | Peak | Total Cost
2009
[NAME] |  |  |  | Departure Date |  |  |  |  | Nights
2009-07-01 00:00:00 |  |  |  | 2009-07-15 00:00:00
Spreadsheet: 732055d1620754709-multiply-cells-only-if-a-cell-is-nonblank-trades-102b
Sheet: DATA

TICKER | DATE | TIME | SIZE | ENTRY | HIGH | PT SIZE | PT | EXIT | G/L | G/L $ | TRADE TYPE | SETUP | EXIT REASON | Comments
IBIO | 2021-05-07 00:00:00 | 09:09:00 | 2000 | 1.92 | 2.01 |  |  | 1.89 |  |  | BO | Pivot | Failed | much overhead res
PLTR | 2021-05-07 00:00:00 | 09:30:00 | 500 | 20.52 | 20.66 |  |  | 20.45 |  |  | BO | PMH | Failed
LMFA | 2021-05-07 00:00:00 | 09:34:00 | 2000 | 4.09 | 5.1 | 1000 | 4.73 | 4.72 |  |  | Parabolic | PM Consolidation | Profit | 5x20 below my exit
PLTR | 2021-05-07 00:00:00 | 09:36:00 | 500 | 20.57 | 20.67 |  |  | 20.55 |  |  | Momo | R2G | Failed | poor trade
PLTR | 2021-05-07 00:00:00 | 09:36:00 | 500 | 20.66 | 20.67 |  |  | 20.51 |  |  | Momo | R2G | Failed | poor trade
IHT | 2021-05-07 00:00:00 | 09:56:00 | 2000 | 4.79 | 5 |  |  | 4.87 |  |  | Parabolic | Consolidation | Profit | 5x20 below my exit
LMFA | 2021-05-07 00:00:00 | 10:02:00 | 2000 | 5.84 | 6.4 |  |  | 6.05 |  |  | Parabolic | R2G | Failed | 5x20 below my exit
IPOE | 2021-05-10 00:00:00 | 09:02:00 | 1000 | 17.39 | 17.46 |  |  | 17.25 |  |  | BO | PMH | Profit
[NAME] | 2021-05-10 00:00:00 | 09:03:00 | 1000 | 9.75 | 10.08 | 500 | 9.99 | 9.97 |  |  | BO | Pivot | Profit
[NAME] | 2021-05-10 00:00:00 | 09:28:00 | 1000 | 10.37 | 11.31 | 500 | 11 | 10.93 |  |  | BO | Pivot | Profit | late entry. 5x20 below my exit
AMC | 2021-05-10 00:00:00 | 09:30:00 | 1000 | 9.97 | 10.15 | 500 | 10.13 | 10.1 |  |  | BO | PMH | Profit
PTIX | 2021-05-10 00:00:00 | 09:51:00 | 2000 | 4.09 | 4.42 | 1000 | 4.64 | 4.78 |  |  | Parabolic | HR | Profit
[NAME] | 2021-05-10 00:00:00 | 09:55:00 | 1000 | 11.76 | 12.36 | 500 | 12.08 | 12.14 |  |  | BO | PMH | Profit
[NAME] | 2021-05-10 00:00:00 | 09:59:00 | 1000 | 12.18 | 12.36 |  |  | 11.92 |  |  | Momo |  | Failed | poor trade
PTE | 2021-05-10 00:00:00 | 10:42:00 | 2000 | 1.29 | 1.34 |  |  | 1.25 |  |  | BO | Pivot | Failed | 3rd FBO on the morning
PTIX | 2021-05-11 00:00:00 | 09:30:00 | 2000 | 4.07 | 4.2 |  |  | 4.04 |  |  | BO | PMH | Failed
PTIX | 2021-05-11 00:00:00 | 09:32:00 | 2000 | 4.12 | 4.14 |  |  | 4.04 |  |  | BO | PMH | Failed
FOE | 2021-05-11 00:00:00 | 09:33:00 | 500 | 21.79 | 21.9 |  |  | 21.61 |  |  | BO | PM Consolidation | Failed
CERC | 2021-05-11 00:00:00 | 09:36:00 | 2000 | 2.99 | 3.3 | 1000 | 3.16 | 2.96 |  |  | BO | Pivot | Profit/Failed
JMIA | 2021-05-11 00:00:00 | 09:38:00 | 750 | 20.75 | 21.57 | 400 | 21.23 | 20.9 |  |  | Momo |  | Profit | reversal continuation trade
SPCE | 2021-05-11 00:00:00 | 09:41:00 | 1000 | 15.86 | 16.77 | 500 | 16.39 | 16.34 |  |  | Parabolic | HR | Profit
JMIA | 2021-05-11 00:00:00 | 09:48:00 | 500 | 21.85 | 22.39 |  |  | 21.99 |  |  | BO | Consolidation | Profit
NTEC | 2021-05-11 00:00:00 | 09:51:00 | 2000 | 5.19 | 5.34 | 1000 | 5.31 | 5.12 |  |  | Parabolic | HR | Profit | I added and should not have