tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 752506d1634810163-add-a-cell-value-to-populate-columns-ex1
Sheet: PRINT SUB

 |  |  |  |  |  |  |  | Form PUR 100
 |  | Purchase Requisition Form
 | ORIGINATOR |  |  |  | DATE | 2021-08-17 00:00:00
 | BUDGET HOLDER NAME______________________________________________
 | BUDGET HOLDER SIGNATURE_________________________________________ |  |  |  | DATE________________________________
 | PURCHASING MANAGER______________________________________________ |  |  |  | DATE________________________________
 | H&S APPROVAL (IF APPLICABLE)_____________________________________ |  |  |  | DATE________________________________
 | [NAME] TO:
 | NAME: | Siôn Davies
 | DEPARTMENT: | Print Shop
 |  |  |  |  | PRINT SHOP REF:
 | PHONE: |  |  |  | BUDGET CODE:
 | SUPPLIER NAME: | SET - Complete Business Solutions
 | PRODUCT CODE | STOCK ITEM/DETAILS |  | SIZE | COLOUR | QTY | PRICE | TOTAL
 | 2RBA4BK | Black Ring Binders (10 Pack) |  | A4 |  | 4 | 5.5
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 | REASON FOR REQUEST: |  |  |  |  |  | SUB TOTAL
 | REQUIRED FOR STOCK REPLENISHMENT AND ONGOING CUSTOMER ORDERS |  |  |  |  |  | P&P | 0
 |  |  |  |  |  |  | VAT
 |  |  |  |  |  |  | TOTAL
 | Instructions for use (Please read before completeing)
 | 1.    Do NOT use this requisition for hire cars, travel, hotels or temporary staff requisitions.
 | 2.    A separate form MUST be used for each supplier.
 | 3.    Requisitions will not be processed until signed by a Manager.
 | 4.    For larger orders a continuation sheet may be attached (Available in Approved Forms/Purchasing).
 | 5.    If you are unsure about a particular product please visit the Purchasing Department where advice and a large number of catalogues are available.
 | 6.    Only approved suppliers may be used (Register available from Purchasing Department). Exceptionally this restriction may be waived with the
 | authority of the Commercial Manager.
 | 7.    Health & Safety / Security / authorisation where required. Refer to Policy 12.11 A & B Para 7 under H & S consideration.
 | PLEASE NOTE: - ALL SECTIONS MUST BE COMPLETED, OR THE PURCHASE REQ WILL BE RETURNED TO SENDER.
Spreadsheet: 199198d1355142493-index-match-excel-formula-assistance-required-occupancy-template
Sheet: Data

 |  |  | Property
 | ABC | DEF | GHJ | JKH | POR
2012-04-01 00:00:00 |  | Jones |  | Simpson | Wilson
2012-04-02 00:00:00 |  | Jones |  | Simpson | Wilson
2012-04-03 00:00:00 | Smith | Jones |  | Simpson | Wilson
2012-04-04 00:00:00 | Smith | Jones | [NAME] | Simpson | Wilson
2012-04-05 00:00:00 | Smith | Jones | [NAME] | Simpson | Wilson
2012-04-06 00:00:00 | Smith | Jones | [NAME] | Simpson | Wilson
2012-04-07 00:00:00 | Smith | Jones | [NAME] | Simpson | Wilson
2012-04-08 00:00:00 | Smith | Jones | [NAME] |  | Wilson
2012-04-09 00:00:00 |  | Jones | [NAME] |  | Wilson
2012-04-10 00:00:00 |  | Jones | [NAME] | Cole | Smith
2012-04-11 00:00:00 |  | Jones | [NAME] | Cole | Smith
2012-04-12 00:00:00 | Wilson | Jones | [NAME] | Cole | Smith
2012-04-13 00:00:00 | Wilson | Jones | [NAME] | Cole | Smith
2012-04-14 00:00:00 | Wilson | Jones |  | Cole | Smith
2012-04-15 00:00:00 | Wilson | Jones |  | Cole | Smith
2012-04-16 00:00:00 | Wilson | Jones |  | Cole | Smith
2012-04-17 00:00:00 | Wilson | Jones |  | Cole
Spreadsheet: 840237d1692602125-extract-data-using-vlookup-sample
Sheet: Sheet2

S/N | PLATE NO | Serial number | VEHICLE MODEL | CARLOG | ODOMETER | PHONE NUMBER | GSM
1 | 00111 | 8921101009177941794 | Ford Transit 00111 | F1 2G/3G (G) | 189 | NA | 358538073039841
2 | 00112 | 8921101009165367531 | Ford Transit 00112 | F1 2G/3G (G) | 3961 | NA | 358538072614461
3 | 00114 | 8921101009176968095 | Ford Transit Panel Van 00114 | F1 2G/3G (G) | 49 | NA | 358538072798876
4 | 00131 | 8921101009176179776 | Ford Transit Mini Bus 00131 | F1 2G/3G (G) | 89406 | NA | 358538072867879
5 | 00143 | 8921101009176968103 | Ford Transit Mini Bus 00143 | F1 2G/3G (G) | 82711 | NA | 358538073053214
6 | 00151 | 8921101009176968095 | Ford Transit Mini Bus 00151 | F1 2G/3G (G) | NA | NA | 358538072798876
7 | 00154 | 8921101009184017216 | Ford Transit 00154 | F1 2G/3G (G) | 35230 | NA | 358538072594309
8 | 00195 | 8921101009173801919 | Ford Transit 00195 | F1 2G/3G (G) | 15631 | NA | 358538072883256
9 | 00212 | 8921101009184017349 | Ford Transit 00212 | F1 2G/3G (G) | 44332 | NA | 358538072607648
10 | 00220 | 8921101009184017356 | Ford Transit 00220 | F1 2G/3G (G) | 35476 | NA | 358538072448191
11 | 00551 | 8921101009184017141 | Renault Duster 00551 | F1 2G/3G (G) | 5533.9 | NA | 358538072857441
12 | 00968 | 8921101009177936018 | Nissan Patrol 00968 | F1 2G/3G (G) | 28139.2 | NA | 358538072602227
13 | 00969 | 8921101009177936000 | Nissan Patrol 00969 | F1 2G/3G (G) | 30249.3 | NA | 358538072606152
14 | 00981 | 8921101009177941679 | Nissan Patrol 00981 | F1 2G/3G (G) | 22018.1 | NA | 358538072925404
15 | 01556 | 8921101009184017638 | Fork Lift Daewoo 01556 | F1 2G/3G (G) | 4980.8 | NA | 358538073939081
16 | 01573 | 8921101009184017588 | Renault Kerax 01573 | F1 2G/3G (G) | 38045.4 | NA | 358538072606202
17 | 01582 | 8921101009184017273 | Fork Lift Daewoo 01582 | F1 2G/3G (G) | 162.1 | NA | 358538072810234
18 | 01625 | 8921101009184017505 | Forklift Manitou 01625 | F1 2G/3G (G) | 1426 | NA | 358538074085181
19 | 01848 | 8921101009177941125 | Renault Kerax 01848 | F1 2G/3G (G) | NA | NA | 358538072916940
20 | 01865 | 8921101009177941810 | Renault Midlum 01865 | F1 2G/3G (G) | NA | NA | 358538072867887
21 | 01905 | 8921101009184017554 | Toyota [NAME] | F1 2G/3G (G) | 4469.9 | NA | 358538073983923
22 | 02224 | 8921101009184017463 | Backhoe Loader CAT 02224 | F1 2G/3G (G) | 2135.6 | NA | 358538073908474
23 | 02234 | 8921101009177941760 | Renault Kerax 02234 | F1 2G/3G (G) | NA | NA | 358538072879411
24 | 02268 | 8921101009184017372 | Renault Kerax 02268 | F1 2G/3G (G) | 35877.5 | NA | 358538072596908
Spreadsheet: 845892d1697204635-pulling-specific-customer-data-froma-lookup-sheet-into-another-sheet-how-to-excel-book_jt
Sheet: DATA SHEET

Security  Code | Maturity Date | Customer Name | CUSTOMER A/C # | CCY | Issue Date | Face Value of Investment | Tenor | TOTAL PROFIT | Rate % | No. of | PROFIT JUN 23 | Rate % | No. of | PROFIT JUL 23 | Rate % | No. of | PROFIT AUG 23 | Rate % | No. of | PROFIT Sep 23 | Rate % | No. of Days | PROFIT Oct 23 | Rate% | No. of Days
 |  |  |  |  |  |  |  |  |  |  | 2023-06-01 00:00:00 |  |  | 2023-07-01 00:00:00 |  |  | 2023-08-01 00:00:00 |  |  | 2023-09-01 00:00:00 |  |  | 2023-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  | Days | 2023-06-30 00:00:00 |  | Days | 2023-07-31 00:00:00 |  | Days | 2023-08-31 00:00:00 |  | Days | 2023-09-30 00:00:00 |  |  | 2023-10-31 00:00:00
 |  |  |  |  |  |  |  | To Date | 2023-06-01 00:00:00 | 2023-06-01 00:00:00 |  | 2023-07-01 00:00:00 | 2023-07-01 00:00:00 |  | 2023-08-01 00:00:00 | 2023-08-01 00:00:00 |  | 2023-09-01 00:00:00 | 2023-09-01 00:00:00 | 30 | 2023-10-01 00:00:00 |  | 31
371200-865 | 2023-10-06 00:00:00 | [NAME] | 3901413000004587 | USD | 2022-10-06 00:00:00 | 5000 | 1-Year |  | 0.0651 | 0 |  | 0.0651 | 0 |  | 0.0649 | 0 |  | 0.065 | 0 |  | 0.065 | 31
371200-857 | 2023-10-25 00:00:00 | [NAME] | 3902413000000140 | USD | 2023-07-25 00:00:00 | 300000 | 3-Months |  | 0.1051 | 0 |  | 0.1051 | 7 |  | 0.1051 | 31 |  | 0.155 | 31 |  | 0.155 | 24
371200-857 | 2024-02-16 00:00:00 | [NAME] | 3903415000009094 | USD | 2023-08-16 00:00:00 | 5000 | 6-Months |  | 0.0651 | 0 |  | 0.0651 | 0 |  | 0.0649 | 16 |  | 0.065 | 31 |  | 0.065 | 31
372200-767 | 2026-02-11 00:00:00 | [NAME] | 3903415000001799 | USD | 2023-02-11 00:00:00 | 9000 | 3-Year |  | 0.0651 | 30 |  | 0.0651 | 31 |  | 0.0649 | 31 |  | 0.065 | 31 |  | 0.065 | 31
373100-582 | 2028-01-06 00:00:00 | Natasha | 3098413000003823 | USD | 2023-01-06 00:00:00 | 5000 | 5-Year |  | 0.0651 | 30 |  | 0.0651 | 31 |  | 0.0649 | 31 |  | 0.065 | 31 |  | 0.065 | 31
Spreadsheet: d03cb983-38d5-4e78-8ca1-8457bf43f621
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
[NAME] | Test | [NAME] | Mumps Virus Antibody, IgG, Serum | Mumps IgG Screen, S | Enzyme Immunoassay (EIA) | Serum Gel Tube: SGT |  |  | 1 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | Negative (reported as positive, equivocal, or negative) Index value 0.00-0.89=negative | Monday through Friday; 9 a.m. | Same day/1 day | 3 days | 1 | 86735 |  |  |  |  | Rochester
[NAME] | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
[NAME] | Result | MUMPG | Mumps IgG Screen, S | Mumps IgG Screen, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6476-6
[NAME] | Result | DEXG | Index Value | Index Value | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25418-5
Spreadsheet: 124175d1318212917-index-and-match-two-workbooks-wednesday-recap-summary-test
Sheet: 3rd Qtr

 | 3rd Quarter Payouts -- Wednesday Play Days
 |  | 2012-07-04 00:00:00 |  | 2012-07-11 00:00:00 |  | 2012-07-18 00:00:00 |  | 2012-07-25 00:00:00 |  |  |  | Total |  | Combined
 |  | Event | B&C's | Event | B&C's | Event | B&C's | Event | B&C's | Event | B&C's | Event | B&C's | Total
 | Player's Name
 | Alworth, [NAME]
 | Bates, Janice
 | [NAME], [NAME]
 | Cates, [NAME]
 | Harp, Eileen
 | [NAME], [NAME]
 | [NAME], [NAME]
 | Smith, [NAME]
 | [NAME], [NAME]
 | TOTALS
Spreadsheet: 52725d1252561963-excel-2007-calculate-via-list-box-options-excel-list-box
Sheet: Sheet1

[NAME] 500 Orange |  |  |  |  | B/Front | S/Side | Border | Quantity | Cost: | Seats | Backs | 0.92 | 1 | Select Filling
 |  |  |  |  | 20 | 20 | 1 | 1 | #N/A |  |  | 1.15 | 2 | [NAME] 500 Orange
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | [NAME] 340 White
 |  |  |  |  |  |  |  |  |  |  |  |  | 4 | [NAME] 300 White
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | Fibre (Corovin Case)
 |  |  |  |  |  |  |  |  |  |  |  |  | 6 | Fibre (Calico Case)
 |  |  |  |  |  |  |  |  |  |  |  |  | 7 | Feather/Foam
 |  |  |  |  |  |  |  |  |  |  |  |  | 8 | Feather (Curled Duck)
 |  |  |  |  |  |  |  |  |  |  |  |  | 9 | Feather ([NAME])
 |  |  |  |  |  |  |  |  |  |  |  |  | 10 | Feather (White Duck)
Spreadsheet: 765729d1643555403-how-to-sort-number-of-days-booked-into-month-bookings-ans
Sheet: Sheet1

Checkin | Checkout | Total Nights
 |  |  |  |  |  | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00
2021-12-24 00:00:00 | 2021-12-26 00:00:00 | 2 |  |  | Nights
2021-12-27 00:00:00 | 2021-12-30 00:00:00 | 3
2021-12-27 00:00:00 | 2022-01-04 00:00:00 | 8
2022-01-01 00:00:00 | 2022-01-08 00:00:00 | 7
2022-01-02 00:00:00 | 2022-01-09 00:00:00 | 7
2022-01-02 00:00:00 | 2022-01-04 00:00:00 | 2
2022-01-03 00:00:00 | 2022-01-08 00:00:00 | 5
2022-01-04 00:00:00 | 2022-01-09 00:00:00 | 5
2022-01-04 00:00:00 | 2022-01-08 00:00:00 | 4
2022-01-05 00:00:00 | 2022-01-12 00:00:00 | 7
2022-01-12 00:00:00 | 2022-01-17 00:00:00 | 5
2022-01-12 00:00:00 | 2022-01-17 00:00:00 | 5
2022-01-14 00:00:00 | 2022-01-17 00:00:00 | 3
2022-01-17 00:00:00 | 2022-01-18 00:00:00 | 1
2022-01-23 00:00:00 | 2022-01-28 00:00:00 | 5
2022-01-28 00:00:00 | 2022-01-31 00:00:00 | 3
2022-01-31 00:00:00 | 2022-02-01 00:00:00 | 1
2022-02-04 00:00:00 | 2022-02-11 00:00:00 | 7
2022-02-06 00:00:00 | 2022-02-12 00:00:00 | 6
2022-02-12 00:00:00 | 2022-02-19 00:00:00 | 7
2022-02-12 00:00:00 | 2022-02-19 00:00:00 | 7
2022-02-20 00:00:00 | 2022-02-26 00:00:00 | 6
2022-02-21 00:00:00 | 2022-02-27 00:00:00 | 6
2022-03-03 00:00:00 | 2022-03-08 00:00:00 | 5
2022-03-03 00:00:00 | 2022-03-07 00:00:00 | 4
2022-03-03 00:00:00 | 2022-03-08 00:00:00 | 5
2022-03-26 00:00:00 | 2022-04-01 00:00:00 | 6
2022-03-26 00:00:00 | 2022-04-01 00:00:00 | 6
2022-03-26 00:00:00 | 2022-04-01 00:00:00 | 6
Spreadsheet: 845584d1697034884-problem-incrementing-or-decrementing-a-cells-value-based-on-a-filters-value-golfscoresmultiplayerliveck76bak-aligw
Sheet: Summary

 | Golf Scores - Team Summary |  |  |  |  |  |  |  |  |  | Team: | Team2
 | Rounds Played |  |  |  | High Score |  |  |  |  |  |  |  |  | Data Entry |  |  | Below Par
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | Par |  |  | Most frequent
 |  | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | Front | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | Back | Total
 | Course Par | 4 | 4 | 3 | 5 | 4 | 4 | 4 | 3 | 4 |  | 4 | 4 | 3 | 4 | 5 | 3 | 4 | 4 | 5
 | HighScore
 | AvScore
 | <= -3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -3
 | Eagles |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -2
 | Birdies |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1
 | Pars |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Bogeys |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Double Bogeys |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 | >= +3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | Total
Spreadsheet: mike_swerzbin__28026__EMR Prices
Sheet: Sheet1

 |  | Peak |  | Off-Peak
Region | Delivery Date | Low | High | Low | High
Red numbers indicate flat, 24-hour products.
NW/N. Rockies | 2001-12-18 00:00:00 | 27.25 | 29.5 | 17 | 24.25
Mid-Columbia | 2001-12-18 00:00:00 | 27.25 | 29.5 | 17 | 24.25
COB | 2001-12-18 00:00:00 | 30 | 32 | 23 | 24
N. California | 2001-12-18 00:00:00 | 32 | 35.25 | 25.75 | 28.4
Midway/Sylmar | 2001-12-18 00:00:00 | NA | NA | NA | NA
S. California | 2001-12-18 00:00:00 | 32 | 35.25 | 24.5 | 28.4
Mead | 2001-12-18 00:00:00 | 31.75 | 33.5 | 22.5 | 26.5
Palo Verde | 2001-12-18 00:00:00 | 29 | 33.75 | 22.75 | 27
Inland SW | 2001-12-18 00:00:00 | 29 | 33.75 | 22.5 | 27
4-Corners | 2001-12-18 00:00:00 | 30 | 32 | 23.75 | 26.5
Central Rockies | 2001-12-18 00:00:00 | 27.75 | 31 | 20 | 23
Spreadsheet: michelle_lokay__26621__imbalsumm0102
Sheet: NGPL

 | 52862 |  | 6828
 | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 36840 | 37236
2 | 44709 | 44762
3 | 42744 | 42762 |  | 15000
4 | 42732 | 42762 |  | 15000
5 | 42708 | 42762 | 38 | 15000
6 | 48175 | 48262
7 | 33784 | 33736
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-01-31 00:00:00 |  |  |  |  | 136733
2001-02-07 00:00:00
Spreadsheet: 854657d1704454872-eomonth-return-error-in-array-formula-eomonth
Sheet: Sheet1

 |  | 2023-12-31 00:00:00
 | Name | Start | End |  |  |  | Name | Start | End | EOMONTH
 | A | 2023-01-05 00:00:00 |  |  |  |  |  | 2023-01-05 00:00:00 | 00:00:00 | 2023-12-31 00:00:00
 | B | 2023-01-30 00:00:00 |  |  |  |  | B | 2023-01-30 00:00:00 | 00:00:00 | 2023-12-31 00:00:00
 | C | 2023-08-15 00:00:00 | 2023-12-12 00:00:00 |  |  |  | C | 2023-08-15 00:00:00 | 2023-12-12 00:00:00 | #[NAME]!
 | D | 2023-09-15 00:00:00 | 2024-01-15 00:00:00 |  |  |  | D | 2023-09-15 00:00:00 | 2024-01-15 00:00:00 | #[NAME]!
 | E | 2024-01-08 00:00:00 |  |  |  |  | E | 2024-01-08 00:00:00 | 00:00:00 | 2023-12-31 00:00:00
 | F | 2024-01-05 00:00:00 |  |  |  |  | F | 2024-01-05 00:00:00 | 00:00:00 | 2023-12-31 00:00:00
 |  |  |  |  | *if Column D is 0, then take C1, Else eomonth for Column D
Spreadsheet: 121554d1316147907-how-do-i-automatically-attach-data-to-terms-i-copy-into-excel-excel-dummy-sheet-baseball-example
Sheet: Sheet1

TEAMS |  | BATTING A% | RUNS PER GM |  | Ssheet #2-> | SCHEDULE | SCHEDULE |  | BATTING A% | RUNS PER GM
Boston | RED SOX | 4 | 5.5 |  |  | FRI OCT 7, 2011 | ANGELS | YANKEES | 3.9 | 3.9
New York Yankees | YANKEES | 3.9 | 5.6 |  |  | 19:00:00 | RDS(HD), FS-D | TICKETS
Tampa Bay |  | 3.95 | 5.4 |  |  | SAT OCT 8, 2011 | ANGELS | YANKEES | 3.9 | 3.9
Baltimore |  | 2.95 | 5.3 |  |  | 21:00:00 | FS-D
Detroit |  | 2.96 | 5.2 |  |  | THU OCT 13, 2011 | RED SOX | ANGELS | 4 | 4
Chicago White Sox |  | 2.3 | 5.1 |  |  | 19:30:00 | FS-D | TICKETS
Cleveland |  | 4.02 | 5 |  |  | SAT OCT 15, 2011 | ANGELS | TEXAS
Kansas City |  | 3.3 | 6 |  |  | 20:00:00 | FS-D
Minnesota |  | 4.02 | 4.3 |  |  | FRI OCT 21, 2011 | CLEVELAND | ANGELS
Texas |  | 4.03 | 4.6 |  |  | 19:30:00 | FS-D | TICKETS
LA Angels | ANGELS | 3.98 | 3.5 |  |  | SAT OCT 22, 2011 | ANGELS | BALTIMORE
Oakland |  | 3.88 | 3.6 |  |  | 19:00:00 | NHLN-US, FS-D
Seattle |  | 3.87 | 3.7 |  |  | TUE OCT 25, 2011 | ANGELS | ATLANTA | 4.05 | 4.05
Philadelphia |  | 3.83 | 3.9 |  |  | 19:00:00 | FS-D
Atlanta | Atlanta | 4.05 | 3.4 |  |  | FRI OCT 28, 2011 | HOUSTON | ANGELS | 2.86 | 2.86
NY Mets |  | 3.02 | 3.3 |  |  | 19:30:00 | NHLN-US, FS-D | TICKETS
Washington |  | 3.03 | 3.8 |  |  | SAT OCT 29, 2011 | ANGELS | ARIZONA
Florida |  | 4.02 | 4.2 |  |  | 20:00:00 | FS-D
Milwaukee |  | 3.03 | 4.3 |  |  | 2011-11-01 00:00:00
St. Louis |  | 3.05 | 4.4 |  |  | DATE | VISITOR | HOME
Cincinnati |  | 3.06 | 4.5 |  |  | TUE NOV 1, 2011 | FLORIDA | ANGELS
Pittsburgh |  | 2.94 | 4.5 |  |  | 19:30:00 | FS-D | TICKETS
[NAME] |  | 3.33 | 6.1 |  |  | THU NOV 3, 2011 | OAKLAND | ANGELS
Houston | Houston | 2.86 | 4.2 |  |  | 19:30:00 | FS-D | TICKETS
Arizona |  | 3 | 4.7 |  |  | SAT NOV 5, 2011 | KANSAS CITY | ANGELS
San Francisco |  | 1e-05 | 0.1 |  |  | 19:00:00 | FS-D | TICKETS
LA Dodgers |  | 3.03 | 4 |  |  | TUE NOV 8, 2011 | SAN DIEGO | ANGELS
Colorado |  | 3.06 | 8 |  |  | 19:30:00 | FS-D | TICKETS
San Diego |  | 3.1 | 4.8
Spreadsheet: 44897d1243620249-if-statement-logic-between-adjacent-cells-exacmple
Sheet: Sheet1

 |  | Order Date | Clearing Date | Profit |  | Entry Date | Missed Profit
 |  | 2008-01-01 00:00:00 | 2008-01-22 00:00:00 | 55 |  | 2008-01-28 00:00:00 | -10 |  | To get the value I have in H3, you can see that the dates in C4 and D4 are the only dates that meet my criteria, so the value in E4 is placed in H3
 |  | 2008-01-01 00:00:00 | 2008-05-18 00:00:00 | 10 |  | 2008-03-25 00:00:00 | 0 |  | To get the value I have in H4, you can see that none of the dates in row 3, 4, 5, 6, 7, 8 or 9 meet my criteria so a value of zero is placed in H4
 |  | 2008-04-05 00:00:00 | 2008-04-05 00:00:00 | 356 |  | 2008-06-20 00:00:00 | -130 |  | To get the value I have in H5, you can see that the dates in C6 and D6, C7 and [NAME], and C9 and D9 are dates that meet my criteria, so the value in E6, E7 and E9 are placed in H5
 |  | 2008-05-01 00:00:00 | 2008-08-12 00:00:00 | 65 |  | 2008-06-25 00:00:00 | -30 |  | etc
 |  | 2008-06-08 00:00:00 | 2008-08-25 00:00:00 | 100 |  | 2008-06-11 00:00:00 | -145 |  | etc
 |  | 2008-06-10 00:00:00 | 2008-06-13 00:00:00 | 15 |  | 2008-06-30 00:00:00 | -130 |  | etc
 |  | 2008-06-10 00:00:00 | 2008-07-15 00:00:00 | 30 |  | 2008-07-05 00:00:00 | -130 |  | etc
 |  | Summary: The Order Date column is the date a product was ordered by a customer. The Clearing Date is the date the money was received for the order and profit booked on a revenue curve. The Profit  column is the amount earned for the order. The Entry Date  column is the date my business offered to sell the product. The Missed Profit  column is the total amount of profit I missed out on by not continuosly offering my product (every day) but only offering it on the Entry Dates. Therefore, by only offering my product on a certain number of days, I wasn't available at the times that customers were buying and thus missing out on potential profit.  I need to calculate the Missed Profit so I can go back and correctly adjust my revenue curve. Currently the revenue curve shows all profits booked from purchases. However, because I didn't offer my product everyday I wouldn't have always made the profit that is reflected in column E.
Spreadsheet: 871427d1717815148-find-point-if-inside-a-polygon-and-shade-the-area-temp-and-alt
Sheet: Sheet1

 | ALT | TEMP F |  |  | A |  | B |  | C |  | D |  | E |  | F
 | yp | xp |  |  | y | x | y | x | y | x | y | x | y | x | y | x
 | 3 | 50 |  |  | 0 | 40 | 2 | 40 | 4.7 | 40 | 6.79 | 40 | 8.64 | 40 | 9 | 90
 |  |  |  |  | 2 | 40 | 4.7 | 40 | 6.79 | 40 | 8.64 | 40 | 9 | 40 | 9 | 128
 |  |  |  |  | 2 | 79 | 4.7 | 69 | 6.79 | 62 | 8.64 | 54.2 | 9 | 90 | 0.55 | 160
 |  |  |  |  | 0 | 98 | 0 | 110 | 6.2 | 70 | 6 | 86 | 8 | 102 | 0 | 160
 |  |  |  |  |  |  | 0 | 98 | 5.13 | 80 | 3 | 109 | 0 | 144 | 0 | 144
 |  |  |  |  |  |  | 2 | 79 | 3 | 98 | 0 | 128.3 | 0 | 128.3 | 8 | 102
 |  |  |  |  |  |  | 2 | 40 | 0 | 119.2 | 0 | 119.2 | 3 | 109 | 9 | 90
 |  |  |  |  |  |  |  |  | 0 | 110 | 3 | 98 | 6 | 86
 |  |  |  |  |  |  |  |  | 4.7 | 69 | 5.13 | 80 | 8.64 | 54.2
 |  |  |  |  |  |  |  |  | 4.7 | 40 | 6.2 | 70 | 8.64 | 40
 |  |  |  |  |  |  |  |  |  |  | 6.79 | 62
 |  |  |  |  |  |  |  |  |  |  | 6.79 | 40
 | P= (x2-xp) * (y1-yp) - (x1-xp) * (y2-yp)
 | D = (x2 - x1) * (yp - y1) - (xp - x1) * (y2 - y1)
 | A = -(y2 - y1)
 | B = x2 - x1
 | C = -(A * x1 + B * y1)
 | D = A * xp + B * yp + C
Spreadsheet: 718454d1613144271-dynamic-cell-references-when-adding-new-data-sample
Sheet: Sheet1

 | Delta latest month | 2020-07-31 00:00:00 | 2020-08-31 00:00:00 | 2020-09-30 00:00:00 | 2020-10-31 00:00:00 | 2020-11-30 00:00:00 | 2020-12-31 00:00:00 | 2021-01-31 00:00:00
A |  | 1.3 | 1.2 | 1.5 | 1.1 | 0.8 | 1.6 | 1.2
B |  | 0.3 | 0.3 | 0.5 | 0.2 | 0.6 | 0.7 | 0.8
C |  | 1.4 | 1.3 | 1.2 | 0.9 | 1.6 | 1.5 | 1.7
D |  | 2 | 2.3 | 2.4 | 2.6 | 1.9 | 1.7 | 1.6
Spreadsheet: 704679d1605695761-how-to-match-multiple-criteria-to-get-value-job-work-production-tracking-drop-down-2
Sheet: pkv test

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TO
 |  | FABRIC | DAILY PRODUCTION REPORT |  |  |  |  |  |  |  |  | NOVEMBER |  |  |  |  |  |  |  |  |  | TO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ORDER | ORDER DATE | LEAD TIME | TOTAL | DIFFERENCE | DAILY EXPECTED | EXPECTED COMPLETION DATE | EXTENDED DATE | EXTENDED DAYS
BHARTI UDYOG | 4090 | CELTIC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
SHAKTI EXPORT | 4163 | GEO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
 | 4089 | GEO
BHARTI UDYOG | 4163 | GEO
SHAKTI EXPORT | 4089 | BASKET |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
BHARTI UDYOG | 4163/4164 | FLEUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35
SHIV EXPORT | 4164 | FLEUR
SHAKTI EXPORT | 4163/4164 | PAISLEY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100
BHARTI UDYOG
SHAKTI EXPORT
Spreadsheet: 547687d1510678377-how-to-match-a-column-to-another-column-sample
Sheet: ورقة1

lastname | firstname | id2 (sort goal) | id1 (sort ref.)
عسيري | ابراهيم | 134372416 | 170372208
فقيه | احمد | 134372441 | 134363517
الشمراني | احمد | 134372426 | 134372402
عابد | احمد | 134372412 | 134371440
الجهني | اسامه | 134372403 | 134372416
فلاته | انس | 134372432 | 134372424
فدا | أسامه | 134372449 | 134372401
السيد | تركي | 134372414 | 134372417
الزبيدي | جواد | 134372429 | 134372423
أبو عيسى | حسام | 134371418 | 134372449
النزاوى | خالد | 170372209 | 134362129
مزين | خالد | 134362244 | 134372436
الصبحي | سامر | 134372421 | 134372428
السيد | سلطان | 134372504 | 134372440
الحربي | صالح | 134372423 | 134371418
الهوساوي | صفوان | 134372431 | 134372442
الجهني | عبد العزيز | 134372417 | 134372412
الجهني | عبدالعزيز | 134372440 | 134372426
الحارثي | عبدالعزيز | 134372402 | 134372429
الرشيدي | عبدالله | 134372428 | 134372421
الصومالي | عبدالوهاب | 134372443 | 134372422
الحربي | عبدالوهاب | 134372422 | 134362244
العمري | علي | 134372818 | 134372818
الجهني | عمار | 134362129 | 134372441
الهندي | عوده | 134372404 | 134372404
العامري | محمد | 134372442 | 134372443
الحربي | محمد | 134371440 | 170372209
[NAME] | موسي | 170372208 | 134372504
الجهني | نادر | 134372401 | 134372403
الجهني | ناصر | 134363517 | 134372432
الجهني | نزار | 134372424 | 134372414
مدني | ياسر | 134372406 | 134372406
[NAME] | يزيد | 134372436 | 134372431