tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 842834d1694808835-easy-count-colored-cells-book1
Sheet: Master Contents (2)

 | Storage/Shredding
 | Dest | Dept |  |  | CF | Contents
 | 2028 | ACTG | ACTG 21-026 | Box 1 | 1.2 | 2018 AP Vendors “B-H”
 | 2028 | ACTG | ACTG 21-027 | [NAME] | 1.2 | 2018 AP Vendors “I-Si”
 | 2028 | ACTG | ACTG 21-028 | Box 3 | 1.2 | 2018 AP Vendors “St-Z”
 | 2028 | ACTG | ACTG 21-029 | [NAME] | 1.2 | 2018 AP Quarterly Accrual; 2 |  |  | Boxes for inventory check
 | 2028 | ACTG | ACTG 21-030 | Box 5 | 1.2 | 2018 AP Batch Review
 | ? | DEVP | DEVP 02-001 | Box 6 | 7.2 | Blueprints:
 | ? | DEVP | DEVP 02-002 | Box 7 | 1.2 | Closed Commitment Letters Volumes I, II, and III
 | ? | DEVP | DEVP 02-004 | Box 8 | 1.2 | Plans & Specs:
 | ? | DEVP | DEVP 02-007 | Box 9 | 1.2 | Carriage House:
 | ? | DEVP | DEVP 03-003 | Box 10 | 2 | BLUE PRINTS
 | ? | DEVP | DEVP 03-004 | Box 11 | 2 | BLUE PRINTS
 | 2020 | DEVP | DEVP 10-001 | Box 12 | 2.8 | WORKING FILES, SITE INSPECTIONS
 | 2020 | DEVP | DEVP 10-002 | Box 13 | 2.8 | WORKING FILES, SITE INSPECTIONS
 | 2020 | DEVP | DEVP 10-003 | Box 14 | 2.8 | WORKING FILES, SITE INSPECTIONS
 | 2020 | DEVP | DEVP 10-004 | Box 15 | 2.8 | WORKING FILES, SITE INSPECTIONS
 | 2037.06683295179 | FIN | FIN 13-001 | Box 16 | 1.2 | 2010-2011 Board
 | PERM | FIN | FIN 13-002 | Box 17 | 1.2 | Shareholder/Analyst calls
 | 2023 | FIN | FIN 15-002 | Box 18 | 1.2 | Shareholder/Analyst calls
Spreadsheet: 670183d1585774484-configuration-options-on-each-tab-that-flow-to-a-master-configuration-tab-sample-grosnd31-
Sheet: Loan Listing

Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8
FR | 585720 | 50 | 12 | 4 | First Mortgage | 7
FR | 1168510 | 1500 | 2 | 3 | Direct Auto | 6
FR | 1168700 | 15000 | 10 | 4 | Credit Card | 7
Spreadsheet: 50895d1250486547-is-there-a-way-to-use-a-referenced-formula-for-different-data-functionproblem
Sheet: Sheet1

1 | 10 |  |  | subtract |  | add
2 | 20 |  |  |  |  | multiply
3 | 30 |  |  |  |  | subtract
4 | 40 |  |  |  |  | divide
5 | 50
Spreadsheet: 47071d1245964558-sumif-multiple-worksheets-add-all-cells-adjacent-to-cell-w-value-matching-query-kor-cart-quotas
Sheet: RAH - CS-SPD GOWNS (2)

K-BRO LINEN SYSTEMS - EDMONTON  PLANT
CS/SPD CS GOWNS (2)
FACILITY: | ROYAL ALEXANDRA HOSPITAL
Date:
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | STATS
DELIVERY DAYS: | X | X | X | X | X | X |  | X
** If more/less linen required please fax in this order by 7:30 a.m. (FAX # (780) 451-5125)
[NAME] |  |  |  | PACK # |  | QUOTA | SHELF | REC | +/-/HOLD
1-GOWN STD XL |  |  |  | GP0002 |  | 180
1-GOWN GORE XL |  |  |  | GP0010 |  | 60
1-GOWN GORE XXL |  |  |  | GP0011 |  | 10
UPDATED:
June 17th 2009
Spreadsheet: 55007d1255073481-automated-ref-number-generation-indexnumberupdate2
Sheet: Sheet1

 | Index number |  |  | Index number
 | 0 |  |  | 0
No |  |  | No
No |  |  | No
Yes | 1 |  | Yes | 1
Yes | 2 |  | Yes | 2
Yes | 3 |  | Yes | 3
Yes | 4 |  | Yes | 4
Yes | 5 |  | Yes | 5
Yes | 6 |  | Yes | 6
No |  |  | Yes | 7
yes | 7 |  | yes | 8
Yes | 8 |  | Yes | 9
Spreadsheet: 329782d1404403180-lookup-formula-to-match-against-two-columns-matchtwocolumns
Sheet: Lists

CENTER | PROJECT | ACCOUNT
Syracuse | Enhancement | 144-144-
Syracuse | Demolition | 144-144-
Tampa | Enhancement | [PHONE]-
Tampa | Expansion | 158-158-
Tampa | Renovation | 158-158-
Memphis | Offices | [PHONE]-
Memphis | Enhancement | 197-197-
Apple | Parking Lot | [PHONE]-
Apple | Signage | [PHONE]-
Apple | Enhancement | [PHONE]-
[NAME] | Storage | [PHONE]-
[NAME] | Enhancement | 114-114-
 |  |  |  |  |  | NUMBER | CENTERS LIST
 |  |  |  |  |  | 144 | Syracuse
 |  |  |  |  |  | 158 | Tampa
 |  |  |  |  |  | 152 | Watertown
 |  |  |  |  |  | 106 | Orlando
 |  |  |  |  |  | 197 | Memphis
 |  |  |  |  |  | 129 | Philadelphia
 |  |  |  |  |  | 175 | San Diego
 |  |  |  |  |  | 114 | [NAME]
 |  |  |  |  |  | 125 | Sacramento
 |  |  |  |  |  | 168 | London
 |  |  |  |  |  | 169 | Tokyo
 |  |  |  |  |  | 181 | Apple
 |  |  |  |  |  | 104
 |  |  |  |  |  | 177
 |  |  |  |  |  | 101
 |  |  |  |  |  | 195
 |  |  |  |  |  | 170
 |  |  |  |  |  | 194
 |  |  |  |  |  | 190
 |  |  |  |  |  | 201
 |  |  |  |  |  | 188
 |  |  |  |  |  | 186
 |  |  |  |  |  | 128
 |  |  |  |  |  | 146
 |  |  |  |  |  | 121
Spreadsheet: 742206d1627580111-multi-criteria-table-lookup-invoice-template
Sheet: Invoice

COMPANY NAME Company Address
BILL TO: |  |  | INVOICE
ACME Widgets |  |  | INVOICE No.:
 |  |  | DATE:
 |  |  | P.O. Number:
 |  |  | TERMS:
QTY | [NAME] |  | UNIT | TOTAL
250 | Product 1
100 | Product 2
 |  |  | TOTAL
Spreadsheet: 767782d1644619758-i-need-a-more-robust-way-to-link-excel-form-data-to-a-word-document-excel-question-dcoument1
Sheet: DYNAMIC FIELD ENTRY

 | DYNAMIC FIELD |  | FIELD ENTRY | ¨
 | PROPOSAL DATE: |  | 2022-05-12 00:00:00 |  |  |  |  |  |  | To enter the PROPSAL DATE:  [NAME] on cell D.  Then click on the desired calendar date.  The specified date will then appear in Cell D3
 | PROPOSAL NUMBER: |  | [NAME]
 | REVISED PROPOSAL? |  | Yes
 | REVISION #: |  | Rev3
 | PROJECT NAME: |  | BioReactor #3 Upgrade
 | [NAME]: |  | ABCD CORP3
 | CUSTOMER COMMON-USE NAME:
 | [NAME]: |  | XYZ, Inc.
 | SUPPLIER COMMON-USE NAME:
 | CUSTOMER SENDEE - FIRST NAME: |  | [NAME]
 | CUSTOMER SENDEE - LAST NAME: |  | Devlin
 | CUSTOMER SENDEE GENDER: |  | Female
 | PROPOSAL-LETTER SUBJECT: |  | Quote 13
 | PROPOSAL-LETTER REFERENCE: |  | Quote 03
 | COVER LETTER SIGNEE: |  | [NAME]
 | COVER LETTER SIGNEE TITLE: |  | Vice President of Sales
 | PROPOSAL DEVELOPMENT LEAD PERSON: |  | [NAME]
 | DRAFT COPIES GO FOR REVIEW TO
 | REVIEWER #1:
 | REVIEWER #2:
 | REVIEWER #3:
 | REVIEWER #4:
 | CC: FOR PROPOSAL REVIEW
 | CC: #1:
 | CC: #2:
 | CC: #3:
 | CC: #4:
Spreadsheet: 017e0787-b653-42fc-aa5b-29ca5e9ac6c3
Sheet: Sheet1

Business University Students Survey 2-16-12 | Business University Students Survey 2-16-12.1 | Business University Students Survey 2-16-12.2 | Business University Students Survey 2-16-12.3
I am a current four-year college/university student. | I am a current four-year college/university student. | I am a current four-year college/university student. | I am a current four-year college/university student.
Answer Options | Answer Options | Response Percent | Response Count
Yes | Yes | 0.93 | 66
No | No | 0.085 | 6
answered question | answered question | 71 | 71
skipped question | skipped question | 0 | 0
Spreadsheet: 132200d1323596097-how-to-transfer-specific-product-content-from-one-row-of-a-worksheet-to-another-using-auto-filter
Sheet: Master Agreement List

Master Agreement Sheet
 |  |  |  |  | 100500
Contract Number | Title | Distributor | Territory Summary | Rights | Contract Amount | Currency | Contract Executed | NOD Issued | Fully Paid | Amount Collect to Date | All Titles if Muli-Picture | Comments
11-004-002 | ANFDT | Eagle | Middle East | All | 15000 | USD | Yes | Yes | Yes | 0
11-004-006 | ANFDT | Hawk | Canada | All | 80000 | CDN | Yes | Yes | No | 0
11-006-002 | Beware | Bluejay | Germany | DVD | 6600 | USD | Yes | Yes | Yes | 0
11-009-001 | DDN | Cardinal | USA | All | 500000 | USD | Yes | Yes | No | 0
11-002-006 | DW | Sparrow | Pan Asia | Pay TV | 3500 | USD | No | No | No | 0
11-004-009 | ANFDT | Raven | India | All | 5500 | USD | No | No | No | 0
11-006-001 | Beware | Eagle | Middle East | All | 25000 | USD | Yes | Yes | Yes | 0
Spreadsheet: 840253d1692613453-training-log-possible-if-formulas-required-training-tracker-sample
Sheet: Training

 | Table 1: Site/Service Details |  |  | Table 2: Training Summary | Total Number | % Compliance
 | Training/Policy Year: |  |  | No. of employees |  | N/A
 | Name of site / service: |  |  | No. of employees on Extended Leave |  | N/A
 | Department/ ward/ unit: |  |  | No. of active employees for whom a TNA has been completed
 | Responsible Person: |  |  | No. of Training Programmes Identified |  | N/A
 | Completed By: |  |  | No. of Training Programmes Up To Date
 | Date (today): |  |  | No. of training programmes due for refresher/ completion
 | Date log last reviewed:
 |  |  |  | Name of Training or Policy | Biological Agents | Repeat not less than 3 yearly | Chemical | Repeat not less than 3 yearly | Chemical Safety | Repeat not less than 3 yearly | COVID-19 | First Aid Responder
 | Employee (name) | Title | Personnel Number | Staff Category | Last completed | Due | Last completed | Due | Last completed | Due | Last completed | Last completed
 | Employee 1 |  |  |  | 2022-06-21 00:00:00 |  | 2020-06-21 00:00:00 |  | 2023-07-31 00:00:00 |  | 2023-01-18 00:00:00 | NA
 | Employee 2 |  |  |  | NA |  | 2021-08-12 00:00:00 |  | 2021-08-12 00:00:00 |  | NA | 2021-04-01 00:00:00
 | Employee 3 |  |  |  | NA |  | NA |  | NA |  | 2020-05-14 00:00:00 | NA
 | Employee 4 |  |  |  | 2019-11-11 00:00:00 |  | 2022-04-24 00:00:00 |  | 2023-08-20 00:00:00 |  | 2022-10-10 00:00:00 | 2022-02-07 00:00:00
Spreadsheet: 169336d1342788595-vlookup-formula-to-look-up-two-criteria-look-up-two-data-fields
Sheet: Sheet1

[NAME] | our ref | qty |  | Stock or Price Code | Order No. | Dr £
AAAAA | 48224 | -59 |  | AAAAA | 48223 | 8.7
AAAAA | 48227 | 1 |  | AAAAA | 48224 | 30.45
BBBBB | 48227 | 4 |  | AAAAA | 48225 | 21.75
BBBBB | 48223 | 5 |  | AAAAA | 48226 | 652.5
AAAAA | 48229 | 10 |  | AAAAA | 48227 | 0
AAAAA | 48430 | 10 |  | AAAAA | 48229 | 139.2
BBBBB | 48224 | 10 |  | AAAAA | 48430 | 139.2
BBBBB | 48225 | 10 |  | BBBBB | 48223 | 2175
CCCCC | 48223 | 10 |  | BBBBB | 48224 | 870
CCCCC | 48224 | 10 |  | BBBBB | 48225 | 2175
CCCCC | 48226 | 15 |  | BBBBB | 48226 | 1305
AAAAA | 48223 | 20 |  | BBBBB | 48227 | 2175
AAAAA | 48225 | 25 |  | BBBBB | 48229 | 435
CCCCC | 48227 | 29 |  | CCCCC | 48223 | 1070.1
AAAAA | 48226 | 30 |  | CCCCC | 48224 | 1344.15
CCCCC | 48225 | 31 |  | CCCCC | 48225 | 217.5
BBBBB | 48226 | 61 |  | CCCCC | 48226 | 870
BBBBB | 48229 | 152 |  | CCCCC | 48227 | 2218.5
Spreadsheet: 32375d1228488780-linking-cells-and-conditional-updates-copy-of-sample-resource-model
Sheet: Sheet1

SAMPLE RESOURCE MODEL |  |  |  |  |  |  |  | DPM | 13.83 | 18.83 | 18.83 | 18.83 | 18.83 | 18.83 | 18.83
Workstream | Team | Perm | Name | Rate | Allocation | Start Date | End Date | Month | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00
[NAME] | [NAME] | [NAME] | AK | 100 | 0.8 | 2008-12-01 00:00:00 | 2009-06-30 00:00:00 |  | 1106.4 | 1106.4 | 1106.4 | 1106.4 | 1106.4 | 1106.4 | 1106.4
[NAME] | [NAME] | [NAME] | AB | 150 | 1 | 2008-12-01 00:00:00 | 2009-02-27 00:00:00 |  | 2074.5 | 2074.5 | 2074.5 | 0 | 0 | 0 | 0
[NAME] | [NAME] | [NAME] | JH | 200 | 1 | 2008-12-01 00:00:00 | 2009-06-30 00:00:00 |  | 2766 | 2766 | 2766 | 2766 | 2766 | 2766 | 2766
[NAME] | [NAME] | [NAME] | AM | 250 | 1 | 2008-12-01 00:00:00 | 2009-03-31 00:00:00 |  | 3457.5 | 3457.5 | 3457.5 | 3457.5 | 0 | 0 | 0
[NAME] | [NAME] | [NAME] | HG | 300 | 1 | 2008-12-01 00:00:00 | 2009-06-30 00:00:00 |  | 4149 | 4149 | 4149 | 4149 | 4149 | 4149 | 4149
DPM = Days per month
Spreadsheet: 4b0b322c-2e02-4ae9-bbf5-4e9c61baa018
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
260218 | 18758 | Jip | Veelenturf | NED | 72 | 00:13:05 | 00:01:20 | 01:42:04 | [NAME] | 01:02:57 | 1 | [NAME]
Spreadsheet: 278165d1384589367-formula-to-calculate-user-fees-based-on-variable-rate-table-a-variable-fee-schedule
Sheet: Sheet1

 |  |  |  | Month
Min Users in Tier | [NAME] | [NAME] | Users
0 | 1000000 | 0.4 | 1000000
1000001 |  | 0.3 | 3000000
 |  | 0.2 | 5000000
 | None | 0.1
 |  |  | Formula -> |  | Actual result
 |  |  | ([NAME] should calculate to 2,100,000
 |  |  |  |  | sktneers' formula result
Spreadsheet: efcd3b65-cd8c-492d-bf53-3e0af828b814
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
TPMT | Test | TPMT | Thiopurine Methyltransferase (TPMT), [NAME] | Thiopurine Methyltransferase, RBC | Enzymatic End point/Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | [NAME]: NaHp |  |  | 5 | mL | Container/Tube:  Preferred: Green top (sodium heparin) Acceptable: EDTA or lithium heparin [NAME]: 5 mL Forms: 1.   1. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 2.   2. If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | 3 mL | Hemolysis	Mild OK; Gross reject Thawing	NA Lipemia	NA Icterus	NA Other	NA | > or =15.0 U/mL RBC (normal) 10.1-14.9 U/mL RBC (low normal) 6.0-10.0 U/mL RBC (carrier) 0.0-5.9 U/mL RBC (deficient) Reference values apply to all ages. | Monday, Wednesday through Friday; Varies | 4 days (not reported on Saturday or Sunday) | 6 days | 1 | 83789 |  |  |  |  | Rochester
TPMT | [NAME] | BLOOD | Whole blood |  |  |  | Refrigerated | 6 days
TPMT | Result | 80291 | Thiopurine Methyltransferase, RBC | Thiopurine Methyltransferase, RBC | Numeric |  |  |  |  | U/mL RBC |  |  |  |  |  |  |  |  |  | 21563-2
TPMT | Result | 35024 | Reviewed By | Reviewed By | Numeric
Spreadsheet: 775226d1648913106-day-fixed-fetch-current-month-fetch-current-year-formula-help-expenses-home
Sheet: 2022-05

Home Budget - May 2022
 |  |  |  |  |  |  |  |  |  |  | Amount | Merchant | Date
 |  |  |  |  |  |  |  |  |  |  | -6.5 | Amazon Store Card
 |  |  |  |  |  |  |  |  |  |  | 100 | Discover
 |  |  |  |  |  |  |  |  |  |  | 125 | [NAME]'s
 |  |  |  |  |  |  |  |  |  |  |  | eBay MC
 |  |  |  |  |  |  |  |  |  |  |  | Ollocard MC
 |  |  |  |  |  |  |  |  |  |  |  | Mercury MC
 |  |  |  |  |  |  |  |  |  |  |  | PenFed VISA
 |  |  |  |  |  |  |  |  |  |  | 600 | Shell MC
 |  |  |  |  |  |  |  |  |  |  |  | TD Bank VISA
 |  |  |  |  |  |  |  |  |  |  |  | Wawa
 |  |  |  |  |  |  |  |  |  |  | 25 | Wells Fargo VISA
Total |  |  |  |  |  | Total |  |  | Total |  |  | Total
Spreadsheet: 65548d1266273456-find-a-value-across-multiple-sheets-in-another-workbook-sales-orders_2010
Sheet: SalesJan

Expected Sales Proceeds For JANUARY 2010
 |  |  |  |  |  |  | FX | 0.9135
 | INVOICE | INVOICE DATE | CUSTOMER | PRODUCT | Quantity | PRICE        USD / MT | AMOUNT (USD) | AMOUNT (AUD)
EXPORT
 | 100106 | 2010-01-12 00:00:00 | Customer1 | Product1 | 10000 | 2 | 20000 | 21893.81499726327
 | 100107 | 2010-01-12 00:00:00 | Customer2 | Product2 | 20000 | 2 | 40000 | 43787.62999452655
 | 100108 | 2010-01-12 00:00:00 | Customer3 | Product3 | 30000 | 2 | 60000 | 65681.44499178982
 | 100109 | 2010-01-12 00:00:00 | Customer4 | Product4 | 40000 | 2 | 80000 | 87575.2599890531
 | 100110 | 2010-01-12 00:00:00 | Customer5 | Product5 | 50000 | 2 | 100000 | 109469.0749863164
 | 100111 | 2010-01-12 00:00:00 | Customer6 | Product6 | 60000 | 2 | 120000 | 131362.8899835796
 | 100112 | 2010-01-12 00:00:00 | Customer7 | Product7 | 70000 | 2 | 140000 | 153256.7049808429
 | 100113 | 2010-01-12 00:00:00 | Customer8 | Product8 | 80000 | 2 | 160000 | 175150.5199781062
 | 100114 | 2010-01-12 00:00:00 | Customer9 | Product9 | 90000 | 2 | 180000 | 197044.3349753694
DOMESTIC
Spreadsheet: 49506d1248867010-excel-2003-pivot-table-show-the-content-of-the-cell-non-calculation-679963_niconatu_v3
Sheet: Sheet2

 |  | Store
Model |  | HH | OO | PP | QQ
1 | Version | a
 | Colour | zz
 | Dimension | 5x8
2 | Version | d |  | d | b
 | Colour | OO |  | xx | xx
 | Dimension | 54x36 |  | 70x20 | 8x24
3 | Version | b | c
 | Colour | xx | OO
 | Dimension | 55x40 | 18x4
4 | Version | c |  | d | b
 | Colour | ww |  | ww | xx
 | Dimension | 36x16 |  | 28x20 | 8x24
5 | Version
 | Colour
 | Dimension
6 | Version
 | Colour
 | Dimension
7 | Version
 | Colour
 | Dimension
8 | Version
 | Colour
 | Dimension
Spreadsheet: 835371d1688543978-to-find-cells-heading-name-index_july_
Sheet: SML

 |  |  |  |  |  |  | SMALL | MEDIUM | LARGE | COMM
 |  |  |  |  |  |  | S | M | L | C
 |  |  |  |  |  |  | KUV300 | BOLERO | [NAME] | JEETO
 |  |  |  |  |  |  | ZEN | BOLERO P | NEW SCORPIO | IMPERIO
 |  |  |  |  |  |  | VIBE | MARAZZO | REXTON | MAXI TRUCK
 |  |  |  |  |  |  | LOGAN | NUVOSPORT | SCORPIO | PICK UP
 |  |  |  |  |  |  | KUV100 | THAR | SCORPIO 1.99 | ACE
 | THAR | M |  |  |  |  | QUANTO | TUV300 | XUV 500 | TATA
 | REVA | S |  |  |  |  | XUV300 | TUV300 PLUS | XUV500 | MAXXIMO LOAD
 | SCORPIO 1.99 | L |  |  |  |  | E2O | Bolero Neo | XYLO | MXMO [NAME]
 | XYLO | L |  |  |  |  | E2O Plus | NEW THAR | XUV700 | SUPRO Load
 | TATA | C |  |  |  |  | REVA | MEDIUM1 | SCORPIO-N | SUPRO Passenger
 | NEW THAR | M |  |  |  |  | SMALL1 | MEDIUM2 | SCORPIO CLASSIC | SUPRO-CV
 | COMM7 | C |  |  |  |  | SMALL2 | MEDIUM3 | LARGE1 | SUPRO-MT
 | BOLERO P | M |  |  |  |  | SMALL3 | MEDIUM4 | LARGE2 | HARD TOP
 |  |  |  |  |  |  | SMALL4 | MEDIUM5 | [NAME] | SOFT TOP
 |  |  |  |  |  |  | SMALL5 | MEDIUM6 | LARGE4 | COMM1
 |  |  |  |  |  |  | [NAME] | MEDIUM7 | LARGE5 | COMM2
 |  |  |  |  |  |  | SMALL7 | MEDIUM8 | LARGE6 | COMM3
 |  |  |  |  |  |  | SMALL8 | MEDIUM9 | LARGE7 | COMM4
 |  |  |  |  |  |  | SMALL9 | MEDIUM10 | LARGE8 | [NAME]
 |  |  |  |  |  |  | SMALL10 | [NAME] | LARGE9 | COMM6
 |  |  |  |  |  |  | SMALL11 | MEDIUM12 | [NAME] | COMM7
 |  |  |  |  |  |  | SMALL12 | MEDIUM13 | LARGE11 | COMM8
 |  |  |  |  |  |  | SMALL13 | MEDIUM14 | LARGE12 | COMM9
Spreadsheet: 685985d1594304286-look-up-postcode-and-allocate-region-example
Sheet: UK Postcode

Postcode | In Use? | County | District | Region
AB1 |  | Aberdeen | Aberdeen | [NAME]
AB10 |  | Aberdeen | Aberdeen city centre, Bridge of Dee, Mannofield | [NAME]
AB11 |  | Aberdeen | Aberdeen city centre, [NAME] | [NAME]
AB12 |  | Aberdeen | Aberdeen, Altens, Ardoe, [NAME], Blairs, Bridge of Dee, [NAME], Maryculter, Nigg, Portlethen | [NAME]
AB13 |  | Aberdeen | [NAME] | [NAME]
AB14 |  | Aberdeen | Peterculter, [NAME] | [NAME]
AB15 |  | Aberdeen | Aberdeen, Bieldside, Craigiebuckler, Cults, Hazlehead, Kingswells, Mannofield, [NAME] | [NAME]
AB16 |  | Aberdeen | Aberdeen, Mastrick, Northfield, Middlefield, Cornhill | [NAME]
AB2 |  | Aberdeen | Aberdeen | [NAME]
AB21 |  | Aberdeen | Aberdeen, [NAME], [NAME], [NAME], [NAME], Kinellar, Newmachar, Whiterashes | [NAME]
AB22 |  | Aberdeen | Aberdeen, Bridge of Don, Danestone, [NAME], [NAME] | [NAME]
[NAME] |  | Aberdeen | Aberdeen, Balmedie, Belhelvie, Bridge of Don, Potterton, Whitecairns | [NAME]
AB24 |  | Aberdeen | Aberdeen, Old Aberdeen, Woodside, [NAME], Seaton, Bedford | [NAME]
AB25 |  | Aberdeen | Aberdeen city centre, [NAME], Foresterhill, Rosemount, [NAME] | [NAME]
AB3 |  | Aberdeen | Aberdeen | [NAME]
AB30 |  | Aberdeenshire | Laurencekirk | [NAME]
IP12 |  | [NAME] | Woodbridge, Orford | Scott
IP13 |  | [NAME] | Woodbridge, Easton, Framlingham, Little Bealings, Laxfield | Scott
IP14 |  | Mid Suffolk | Stowmarket, Stowupland | Scott
IP15 |  | [NAME] | Aldeburgh | Scott
IP16 |  | [NAME] | Leiston, [NAME], Eastbridge, Sizewell, Theberton, Thorpeness | Scott
IP17 |  | [NAME] | [NAME] | Scott
IP18 |  | Waveney | Southwold, Easton Bavents, Reydon, [NAME] | Scott
IP19 |  | Waveney | Halesworth | Scott
IP2 |  | Ipswich | South West Ipswich, Belstead, Wherstead, Stoke Park | Scott
IP20 |  | Waveney | Harleston | Scott
IP21 |  | Mid Suffolk | [NAME] | Scott
IP22 |  | South Norfolk | Diss | Scott
IP23 |  | Mid Suffolk | Eye | Scott
Spreadsheet: 219683d1362875954-formula-for-total-entries-in-a-column-and-for-percentage-of-certain-value-arrests-and-sfsts-with-content
Sheet: SFST

Date | Last | First | DOB | HGN | WAT | OLS | [NAME] | Finger-Nose | Convergence? | Arrest? | +/- BAC | BAC Results | Remarks
2013-01-02 00:00:00 | White | [NAME] | 1967-01-04 00:00:00 |  |  |  |  |  |  | yes | +
2013-01-03 00:00:00 | [NAME] | [NAME] | 1976-01-04 00:00:00 |  |  |  |  |  |  | yes | +
2013-01-04 00:00:00 | Black | [NAME] | 1956-01-04 00:00:00 |  |  |  |  |  |  | no | -
2013-01-06 00:00:00 | Blue | Stephen | 1944-01-03 00:00:00 |  |  |  |  |  |  | no | +
2013-01-07 00:00:00 | Red | Sara | 1978-04-06 00:00:00 |  |  |  |  |  |  | yes | -
Spreadsheet: 56176d1256257967-too-many-arguments-jacko311
Sheet: DataEntry

TRADE# | Entry Date | Trade Type | Pip Value | PIP Multiplier | Entry Time (24hr-hhmm) | Account | Symbol | Total Contracts | Entry Price | S/L | Setup Name | Time Frame | Exit Time (24hr-hhmm) | Exit Date | Exit Price 1 | EP1 Lot Sz | Exit Price 2 | EP2 Lot Sz | Exit Price 3 | EP3 Lot Sz | MAE | MFE | Trade Grade | DOW | Profit/Loss 1 | Profit/Loss 2 | Profit/Loss 3 | Duration (hh:[NAME]) | Comm. | Gross Profit/Loss | Net Profit/Loss | Win/Loss | Wins | Loss streak | Wins | Loses | Short Wins | Long Wins | BE | Short BE | Long BE | Losses | Consec. Wins | Consec.Losses | Short Losses | Long Losses | Hour conversion | [NAME] | Trades | Shorts | Longs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mon Win | Mon BE | Mon TED | [NAME] | Tues BE | [NAME] TED | Wed Win | Wed BE | Wed TED | Thurs Win | Thurs BE | Thurs [NAME] | Fri Win | Fri BE | Fri TED
1 | 2009-09-28 00:00:00 | Futures |  |  | 07:48:00 | Mirus | EC | 2 | 1.4662 | S | [NAME] | 450t | 08:02:00 | 2009-09-28 00:00:00 | 1.4655 | 1 | 1.4649 | 1 |  |  | 12.5 | 237.5 | 4
 | 2009-10-15 00:00:00 | Forex | 1 | 100000 | 09:05:00 | Mirus | AUDUSD | 1 | 0.9162 | L | Trend Trade | 15m | 13:25:00 | 2009-10-15 00:00:00 | 0.9163 | 1
 | 2009-10-16 00:00:00 | Stock_ETF |  |  | 10:00:00 | Mirus | TYTY08 | 1 | 100 | L | Trend Trade | 15m | 10:05:00 | 2009-10-16 00:00:00 | 90 | 1
 | 2009-10-19 00:00:00 | Forex | 1 |  | 09:15:00 | Mirus | EURJPY | 1 | 135.43 | S | Trend Trade | 15m | 09:20:00 | 2009-10-19 00:00:00 | 135.33 | 1
 | 2009-10-19 00:00:00 | Forex | 1 |  | 09:30:00 | Mirus | AUDUSD | 1 | 0.9155 | S | Trend Trade | 15m | 09:40:00 | 2009-10-19 00:00:00 | 0.9153 | 1
 | 2009-10-19 00:00:00 | Forex | 1 |  | 10:00:00 | Mirus | AUDUSD | 1 | 0.91551 | s | Trend Trade | 15m | 10:01:00 | 2009-10-19 00:00:00 | 0.91552 | 1
 | 2009-10-20 00:00:00 | Options |  |  | 12:00:00 | Mirus | CUCM0909 | 5 | 35 | L | [NAME] | 60m | 14:00:00 | 2009-10-20 00:00:00 | 40 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total of each trade type
Spreadsheet: 77216d1277736828-does-this-require-vlookup-service-dispatch-w-tabs
Sheet: data

HELPER
0-1
0.25-1
0.25-2
0.3-1
0.5-1
0.5-2
0.5-3
0.5-4
0.5-5
0.5-6
0.5-7
0.5-8
0.5-9
0.5-10
0.5-11
0.5-12
0.5-13
0.5-14
0.5-15
0.7-1
0.7-2
0.75-1
0.75-2
0.79-1
0.8-1
0.8-2
0.9-1
1-1
1-2
1-3
1-4
1-5
1-6
1-7
1-8
1-9
1-10
1-11
1-12
1-13
1-14
1-15
1-16
1-17
1-18
1-19
1-20
1-21
1-22
1-23
1-24
1-25
1-26
1.1-1 |  | RANK
1.25-1 |  | 3
1.3-1 |  | 8
1.5-1 |  | 9
1.5-2 |  | 4
1.5-3 |  | 7
1.5-4 |  | 6
1.5-5 |  | 2
1.5-6 |  | 5
1.5-7 |  | 1
1.6-1
1.7-1
1.8-1
1.8-2
1.8-3
1.8-4
1.8-5
1.8-6
1.8-7
1.85-1
1.9-1
2-1
2-2
2-3
2-4
2-5
2-6
2-7
2-8
2-9
2-10
2.05-1
2.1-1
2.1-2
2.1-3
2.1-4
2.1-5
2.3-1
2.3-2
2.3-3
2.3-4
2.5-1
2.5-2
2.5-3
2.5-4
2.5-5
2.5-6
2.5-7
2.5-8
2.65-1
2.7-1
2.7-2
2.8-1
2.8-2
2.8-3
2.8-4
2.8-5
2.8-6
2.9-1
2.9-2
3-1
3-2
3-3
3-4
3-5
3.1-1
3.1-2
3.2-1
3.2-2
3.2-3
3.21-1
3.3-1
3.3-2
3.3-3
3.3-4
3.65-1
3.76-1
4-1
4-2
4-3
4-4
4.2-1
4.5-1
4.6-1
4.7-1
5.5-1
5.6-1
5.8-1
5.9-1
6-1
6.5-1
7-1
8.2-1
8.7-1
9-1
9-2
9.8-1
10-1
10.25-1
13.75-1
20.5-1
RS-1
RS-2
RS-3
RS-4
WARR-1
WARR-2
WARR-3
WARR-4
WARR-5
WARR-6
WARR-7
WARR-8
WARR-9
WARR-10
WARR-11
WARR-12
WARR-13
WARR-14
WARR-15
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1