tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 41007d1239401050-formula-similar-to-vlookup-needed-copy-of-program
Sheet: Legs & Abs

 | Legs |  |  | Abs
 | Calfs |  |  | Lower Abs
 | Leg Press Machine Calf Press |  |  | [NAME]
 | Rocking Barbell Calf Raises |  | 1 | Decline Abdominal Crunches
 | Seated Calf Raises |  |  | Reverse Decline Crunches
 | Barbell Calf Raises |  |  | Exercise Ball Abdominal Pull Ins
1 | Hack Machine Calf Raises |  |  | Flat Bench Abdominal Leg Pull Ins
 | Dumbbell [NAME] |  |  | Flat Bench Abdominal Leg Raises
 | Barbell Seated Calf Raises |  |  | Hanging Knees To Chin Raises
 | Seated Single Leg Calf Raises |  | 2 | Hanging Abdominal Leg Raises
 | Single Leg Calf Raises |  |  | Hanging Knees To Head Raises
 | Dumbbell Single Leg Calf Raises |  |  | Parallel Bar Abdominal Knee Raises
 |  |  |  | Lying Reverse Abdominal Crunches
 | Hamstring |  |  | Reverse Abdominal Crunches
 | Barbell Lunges |  |  | Abdominal Flutter Kicks
 | Dumbbell Lunges |  |  | Medicine Ball Leg Raises
 | Lying [NAME] |  |  | Inverted Exercise Ball Leg Pull Ins
 | Barbell Deadlifts |  |  | Weighted Hand To Leg Ab Crunches
2 | Seated Leg Curls
 | Smith Machine Deadlifts
 | Standing Leg Curls |  |  | Middle & Upper Abs
 | Exercise Ball Curls |  |  | Abdominal Crunch Machine
 | Elastic Band Kickbacks |  | 3 | Abdominal Cable Crunches
 | One Legged Cable Kickbacks |  |  | Barbell Abdominal Rollouts
 | One Leg Lying Curls |  |  | [NAME]
 | One Leg Seated Curls |  |  | Overhead Abdominal Crunches
 |  |  |  | Legs On Exercise Ball Abdominal Crunches
 | Quads |  |  | Abdominal Crunches
3 | Barbell Deadlifts |  |  | Exercise Ball Abdominal Crunches
 | Barbell Squats |  |  | Fingers To Toes Abdominal Crunches
 | Barbell Hack Squats |  |  | Straight Arm Abdominal Crunches
 | Barbell Lunges |  |  | Raised Knee Barbell Crunches
 | Barbell Bench Squats |  |  | Abdominal Sit Ups
 | Barbell Step Ups |  |  | Abdominal Toe Touchers
 | Cable Inner Thighs Pulls |  |  | Abdominal Tuck Crunches
 | Dumbbell Lunges |  |  | [NAME] on Exercise Ball
 | Dumbbell Rear Lunges
 | Dumbbell Squats
 | Dumbbell [NAME] |  |  | Obliques
 | Dumbbell Step Ups |  |  | Flutter Kick Oblique Crunches
 | [NAME] |  |  | Fingers To Heel Oblique Touchers
 | Front Barbell Squats |  | 4 | Barbell Oblique Side Bends
 | Front Barbell Bench Squats |  |  | Oblique Crunches
4 | Hack Squats |  |  | Oblique Decline Crunches
 | Dumbbell Lateral Raise Squats |  |  | Dumbbell Oblique Side Bends
 | Leg Extensions |  |  | Hanging Oblique Knee Raises
 | Leg Presses |  |  | Elbow To Knee Oblique Crunches
 | Machine Squats |  |  | Lying Side Oblique Crunches
 | Power Cleans |  |  | Oblique Plate Twists
 | One [NAME] |  |  | Oblique Twists
 | Single Dumbbell Squats |  |  | Seated Oblique Barbell Twists
 | Smith Machine Squats |  |  | Lying Oblique Leg Raises
 | Thigh Abductors
 | Wide Barbell Squats
 | Dumbbell Side Lunges
 | One Leg Extensions
 | One Leg Presses
 | One Leg Machine Squats
Spreadsheet: 3f134af9-bd60-4a7e-8cbb-77f4a9cdc33b
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
FHSAB | Test | FHSAB | Herpes Simplex Virus 1/2 Antibody (IgM), IFA with [NAME] to [NAME], Serum | HSV 1/2 IgM Ab IFA Reflex to [NAME] | Immunofluorescence Assay | Plain, Red-Top Tube: Red |  |  |  |  | Draw blood in a plain, red-top tube(s). (Serum gel tube is acceptable.) Spin down and send 1 mL of serum refrigerated. | 0.3 mL | Hemolysis:	Mild reject; Gross reject Thawing:	NA Lipemia:	Mild reject; Gross reject Icterus:	NA Other:	[NAME] | Herpes Simplex Virus 1/2 Antibody (IgM), IFA with [NAME] to [NAME], Serum   Reference Range: Negative   The IFA procedure for measuring IgM antibodies to HSV 1 and HSV 2 detects both type-common and type-specific HSV antibodies. Thus, IgM reactivity to both HSV 1 and HSV 2 may represent crossreactive HSV antibodies rather than exposure to both HSV 1 and HSV 2.     HSV 1 IgM Titer  HSV 2 IgM Titer | Monday through Saturday | 1 - 3 days | 3 - 7 days |  | Profile |  |  |  |  | Focus Diagnositics, Inc.
FHSAB | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
FHSAB | Result | Z2902 | HSV 1 IgM Screen | HSV 1 IgM Screen | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FHSAB | Result | Z2903 | HSV 2 IgM Screen | HSV 2 IgM Screen | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FHSAB | Billing Component | FHSAB |  | HERPES SIMPLEX TYPE 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 86696
FHSAB | Billing Component | FHSAB |  | HERPES SIMPLEX TEST |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 86695
FHSAB | [NAME] | FHSI | HSV 1 IgM Titer | HSV 1 IgM Titer | Immunofluorescence Assay  Only orderable as a reflex from FHSAB |  |  |  |  |  | Only orderable as a reflex from FHSAB |  |  |  |  |  |  | 1 | 86695 |  |  | No | No
FHSI | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
FHSI | Result | Z2904 | HSV 1 IgM Titer | HSV 1 IgM Titer | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FHSAB | [NAME] | FHSII | HSV 2 IgM Titer | HSV 2 IgM Titer | Immunofluorescence Assay  Only orderable as a reflex from FHSAB |  |  |  |  |  | Only orderable as a reflex to FHSAB |  |  |  |  |  |  | 1 | 86696 |  |  | No | No
FHSII | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
FHSII | Result | Z2905 | HSV 2 IgM Titer | HSV 2 IgM Titer | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 142535d1329897536-displaying-totals-on-stacked-column-chart-stacked
Sheet: Source Data

Activity ID | Activity Name | Resource ID Name | Start | Finish | Spreadsheet Field | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00
 |  |  |  |  |  | 3.406896551724138 | 24.74516129032258 | 34.87333333333333 | 95.52903225806452 | 210.82 | 255.841935483871 | 194.6451612903226 | 88.52333333333334 | 13.05806451612903 | 4.2 | 12.08064516129032 | 10.5
 |  |  |  |  |  | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00
 |  |  |  |  |  | 33.6658064516129 | 114.8463333333333 | 205.961935483871 | 193.0846666666667 | 184.8558064516129 | 117.0754838709677 | 81.367 | 64.33322580645161 | 28.91633333333333
 |  |  |  |  |  | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35
Spreadsheet: 111325d1307709765-counting-items-using-criteria-from-3-columns-sample-worksheetpt
Sheet: Sheet1

Department | Country | Open Reqs | Future Reqs |  |  |  | Open Reqs | Future Reqs
Engineering | US | A86 |  |  |  | Engineering
Engineering | US | 105.037055431028 |  |  |  | Operations
Engineering | US | 157.232204169128 |  |  |  | HR
Engineering | US | 235.404678426319
Engineering | US |  | waiting
Operations | US | A8
Operations | US | 496.213287551663 |  |  |  | Row Labels | Count of Open Reqs | Count of Future Reqs
Operations | US | 337.342655411413 |  |  |  | Engineering | 6 | 2
Operations | US |  | waiting |  |  | HR | 6 | 2
HR | US | 233.890425576593 |  |  |  | Operations | 7 | 2
HR | US | 208.634574603139 |  |  |  | Grand Total | 19 | 6
HR | US |  | waiting
Operations | CAN | 438.729018716289
Operations | CAN | 184.82540102381
Operations | CAN |  | waiting
HR | CAN | 367.135884969108
HR | CAN | 338.039694210675
Engineering | CN | 478.861573313535
Engineering | CN | 197.966896630393
Engineering | CN |  | hold
Operations | CN | 191.721049436141
Operations | CN | 214.91768810977
HR | CN | 293.768804270039
HR | CN | 413.246892628152
HR | CN |  | hold
Spreadsheet: 490450d1479858385-need-to-make-a-nested-drop-down-menu-dql_dol
Sheet: Sheet2

Models | YN | Comm / SN | 201309112 | Description | 2014201173 | Description | 20150516
BMW | Yes | 201309112 |  |  | FFRT-0075/116121_VM | Pre-Mounted Drive Shaft
Kia | No | 2014201173 |  |  | FFRT-0036/103909_VM | Bearing Housing
GM |  | 2015201165 |  |  | EFRT-0192-0195/116999_SET | Roller/Wear rail, down left
Ford
Spreadsheet: 675090d1588158358-reverse-calculate-irr-sample-reverse-irr
Sheet: Sheet1

Month | Balance BF | Payment Flow | Commission/Platform Fee | Subsidy | Outflows | Cash Movement
0 |  | -1000000 | -12500 | 92500
1 | 1000000 | 83333.33333333333
2 | 916666.6666666666 | 83333.33333333333
3 | 833333.3333333333 | 83333.33333333333
4 | 749999.9999999999 | 83333.33333333333
5 | 666666.6666666665 | 83333.33333333333
6 | 583333.3333333331 | 83333.33333333333
7 | 499999.9999999998 | 83333.33333333333
8 | 416666.6666666665 | 83333.33333333333
9 | 333333.3333333332 | 83333.33333333333
10 | 249999.9999999999 | 83333.33333333333
11 | 166666.6666666666 | 83333.33333333333
12 | 83333.33333333324 | 83333.33333333333
Spreadsheet: 773594d1647951227-need-a-way-of-combining-headers-to-data-formulas
Sheet: Formulas 

 | 2022-03-21 00:00:00
Code | Name |  | Type | Date | Int. | Ref. | Invoice Number | Ext. Ref. | Credit Terms | Total (EUR) | Unallocated | Current | 30 Days | 60 Days | 90 Days | 120 Days ++ | Days since Invoice | Days Overdue/ CT | Description | Days | Overdue Months | Months | Batch Number | Batch | Chasing Days | Status
 |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  | 90 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  | 90 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  | 90 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  | 90 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
Spreadsheet: 264350d1378850368-associating-cells-so-that-sorting-them-maintains-relationship-on-another-worksheet-yankplayer87
Sheet: Master List

Employee number | First Name | Last name | Pay Rate | Pay Source
E001 | Cccccc | Ddddd | 10 | Dept
E002 | Eeeee | [NAME] | 11 | FG
E003 | Gggggg | Hhhhh | 11 | Dept
E004 | Kkkkk | Llllll | 12 | FG
E005 | Mmmmm | Nnnnn | 12 | Dept
E006 | Qqqqqq | Rrrrrr | 13 | FG
E007 | Iiiiii | Jjjjj | 13 | Dept
E008 | [NAME] | Ppppp | 11 | FG
E009 | Aaaaa | Bbbbb | 10 | Dept
Spreadsheet: 72461d1273148506-problems-with-if-sums-carriagechecker
Sheet: Input

Product Code | DD or Wisdom | Discription | Carriage Associated?
fu01037 | Direct Dispatch | Activity Table Town | Yes
fu01617 | Wisdom | Frog Book Store (no trays included) | Yes
 | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A
Spreadsheet: 59340d1259835968-macro-to-find-and-delete-re-inspection-tracker
Sheet: Add & Delete

 | Date Complaint Open |  |  |  |  |  |  |  | Date Complaint Came To Department |  |  |  |  |  |  |  | Date Re-Inspection Requested |  |  |  |  |  |  |  | Date Of Next Review
 | Day |  | Month |  |  |  | Year |  | Day |  | Month |  |  |  | Year |  | Day |  | Month |  |  |  | Year |  | Day |  | Month |  |  |  | Year
 |  |  |  | #N/A | #N/A |  | 2009 |  |  |  |  | #N/A | #N/A |  | 2009 |  |  |  |  | #N/A | #N/A |  | 2009 |  |  |  |  | #N/A | #N/A |  | 2009
 | Policy Number |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | Work Type
 | Running Average Days Re-Inspection Complaints Open: |  |  |  |  |  |  | 14.42857142857143 |  | 13.90909090909091 | Total Amount Of Complaints: |  |  |  |  |  | 14
 |  |  | Delete Policy Number |  |  |  |  |  |  |  | 2941213301
Spreadsheet: 732077d1620761075-help-a-journalist-with-an-excel-puzzle-excelforumproblem_05112021
Sheet: Sheet1

case_num | locn_descr | case type descr | filing_date | Judgment Entered | jdmt_date | bar_num | Date Writ is Issued | title
040402280 | Provo District | Debt Collection | 2004-07-09 00:00:00 | Yes | 2004-12-14 00:00:00 | 3640 | 2019-02-11 00:00:00 | Writ of Continuing Garnishment
040402280 | Provo District | Debt Collection | 2004-07-09 00:00:00 | Yes | 2004-12-14 00:00:00 | 14052 | 2019-02-11 00:00:00 | Writ of Continuing Garnishment
040402280 | Provo District | Debt Collection | 2004-07-09 00:00:00 | Yes | 2004-12-14 00:00:00 | 3640 | 2019-02-27 00:00:00 | Writ of Continuing Garnishment
040402280 | Provo District | Debt Collection | 2004-07-09 00:00:00 | Yes | 2004-12-14 00:00:00 | 14052 | 2019-02-27 00:00:00 | Writ of Continuing Garnishment
Spreadsheet: 8188ef13-f580-41f4-ba43-06dc10f0cd22
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-07-30 15:08:48.920000
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 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.806 | 101.681 | 101.556 | 101.181
3.75 | 101.602 | 101.477 | 101.352 | 100.977 |  | Note: | Refer To Price [NAME]
3.625 | 101.193 | 101.068 | 100.943 | 100.568 |  |  | For all Price Adjs
3.5 | 100.608 | 100.483 | 100.358 | 99.733
3.375 | 99.722 | 99.597 | 99.472 | 98.847
3.25 | 98.764 | 98.639 | 98.514 | 97.889
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 102.125 | 102 | 101.875 | 101.5
3.25 | 101.887 | 101.762 | 101.637 | 101.262
3.125 | 101.593 | 101.468 | 101.343 | 100.968
3 | 101.243 | 101.118 | 100.993 | 100.618
2.875 | 100.651 | 100.526 | 100.401 | 99.776
2.75 | 99.993 | 99.868 | 99.743 | 99.118
 |  |  |  |  |  | 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-08-13 15:08:48.920000
30 DAY | 2012-08-28 15:08:48.920000
45 DAY | 2012-09-12 15:08:48.920000
60 DAY | 2012-09-27 15:08:48.920000
90 DAY | 2012-10-27 15:08:48.920000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 797463d1663905335-help-with-referencing-timeframes-in-other-worksheets-upload-new-swing-test
Sheet: 4458

Refurb | Area | Full Day | Day Shift | Swing Shift |  | Raptor | Area | Current Quantity | Day Shift | Swing Shift |  |  | Area | Current Revenue | Prev Day Revenue | [NAME] | Fixed | HC | Labor | Total Exp | GM | GM % | Targest GM %
CMTX | CMTX |  |  |  |  | [NAME] | STB |  |  |  | HOURS WORKED |  | STB |  |  |  |  |  |  |  |  |  | 0.48
STB | STB |  |  |  |  | [NAME] | STB |  |  |  |  |  | CMTX
 |  |  |  |  |  | Legacy AStock | STB |  | 0 |  | Fixed Expense Amt
 | Check |  |  |  |  | Legacy B/CStock | STB |  | 0 |  |  |  | Swing Labor
XG2 Scratch Removal | STB |  |  |  |  |  |  |  |  |  |  |  | STB
 |  |  |  |  |  |  | Check |  | 0 |  |  |  | CMTX
Test | Area | Current Quantity | Day Shift | Swing Shift |  | Raptor Plus | Area | Current Quantity | Current Quantity | Qty Variance
BUSINESS WIRELESS GATEWAY | CMTX |  |  |  |  | AStock | CMTX
HD UDTA | STB |  |  |  |  | B/CStock | CMTX |  |  |  | Total  Sales |  |  | Day |  |  | 2022-09-22 07:00:00 | 2022-09-22 17:30:00
MOT HD | STB |  |  |  |  |  |  |  |  |  | Fixed Expense |  |  | Swing |  |  | 2022-09-22 17:31:00 | 2022-09-22 23:59:00
MOT HDDVR HYBRID XCAL | STB |  |  |  |  |  | Check |  | 0 |  | Actual labor
MOT HDDVR XCAL | STB |  |  |  |  | Packout | Area | Current Quantity | Current Quantity | Qty Variance | GM
MOTO HD XCAL | STB |  |  |  |  | STB AStock | STB |  |  |  | GM %
UDTA | STB |  |  |  |  | STB B/Cstock | STB |  |  |  | Goal | 0.4 | Day
[NAME] | CMTX |  |  |  |  | CMTX AStock | CMTX |  |  |  |  |  | Swing
XB6 | CMTX |  |  |  |  | CMTX B/CStock | CMTX
XB7 | CMTX
XB8 | CMTX |  |  |  |  |  | Check |  | 0
MODEM-D3 | CMTX |  |  |  |  | Kitting | Area | Current Quantity | Current Quantity | Qty Variance
XBCOM GATEWAY | CMTX |  |  |  |  | BAU STB Kitting | STB
XG1-M | STB |  |  |  |  | SIK STB Kitting | STB
[NAME] | STB |  |  |  |  | BAU CMTX Kitting | CMTX
XG2-M | STB |  |  |  |  | SIK CMTX Kitting | CMTX
XI5 | STB
XI6 | STB |  |  |  |  |  | Check |  | 0
[NAME] | STB
D3-EMTA-4LINE | CMTX
COM-ROUTER-D3 | CMTX
SA HD-DVR HYBRID XCAL | STB
XI3 | STB
SA-SD | STB
MOCA-DVR | STB
SA-MOCA-HD | STB
SA-HD | STB
EMTA-4LINE | CMTX
COMCAST BUSINESS ROUTER | CMTX
COMCAST BUSINESS ROUTER 2 | CMTX
STANDARD | STB
SA HD-DVR XCAL | STB
EMTA-D3 | CMTX
WALL MOUNT HD UDTA | STB
 | Check
TESTING SUMMARY |  | Current Quantity | Current Quantity | Qty Variance
STB |  |  | 1680
CMTX |  |  | 1108
 |  |  | 2788
Spreadsheet: 693138d1598794736-how-do-i-create-a-pivot-table-with-multiple-sourced-worksheets-sample-ckl34-
Sheet: Sheet2

ISSUING | Year & Month | Local Transaction Date | Processing Date | Invoice Country | [NAME] | PAN 8 digits | Card Number (PAN) (encrypted) | Merchant Number Search | Merchant DBA Name | MCC | Merchant Country | [NAME] | Transaction Currency | Transaction Amount | Transaction Amount USD | Transaction Amount JPY | 4field | [NAME] | PAN Entry Mode | Category
TRF | 201907 | 20190705 | 20190708 | IND | 133302 | 35623311 | 6.48308454355031e+16 | 117076159000182 | PRIME | 5812 | JPN | 100011 | 392 | 13109 | 120.69 | 13110 | [PHONE] | 342 | [PHONE]
TRF | 201907 | 20190704 | 20190705 | IND | 133302 | 35686733 | 3.8571380689485e+16 | 110006080002357 | TOWNMALL | 5412 | IND | 144222 | 608 | 2309.9 | 45.3 | 4891 | [PHONE] | 45343 | 000000C00000
TRF | 201907 | 20190705 | 20190708 | IND | 133302 | 35623343 | 8.40328656540455e+16 | 231110408188398 | *MH58T9JP2 | 5943 | USA | 125033 | 840 | 322.9 | 322.9 | 35076 | [PHONE] | 23235 | 000000S00000
TRF | 201907 | 20190703 | 20190704 | IND | 133302 | 35623231 | 3.45378261127072e+16 | 223234000109311 | PAYMENT CORP | 5813 | USA | 162144 | 840 | 0.57 | 0.57 | 61 | [PHONE] | 3435 | 000000S00000
TRF | 201907 | 20190705 | 20190708 | IND | 133302 | 35623264 | 3.25176242456872e+16 | 430001003352058 | DRUG | 5914 | IND | 144031 | 608 | 109.6 | 2.14 | 232 | [PHONE] | 65653 | 510ZZ1C15006
TRF | 201907 | 20190707 | 20190708 | IND | 133302 | 35623252 | 3.15075231660342e+16 | 533131000640687 | 160696693592 | 47224 | ESP | 166134 | 608 | 1057.65 | 20.66 | 2244 | [PHONE] | 54434 | 191090S04000
TRF | 201907 | 20190706 | 20190709 | IND | 133302 | 35623321 | 3.05974111502665e+16 | 231101646112845 | 1284 | 5654 | USA | 125055 | 840 | 97.35 | 97.35 | 10607 | [PHONE] | 2332 | [PHONE]
TRF | 201907 | 20190702 | 20190703 | IND | 133302 | 35623334 | 5.17095323909411e+16 | 533131000647625 | GROB | 4783 | SGP | 166155 | 608 | 500 | 9.78 | 1053 | [PHONE] | 5553 | [PHONE]
TRF | 201907 | 20190701 | 20190703 | IND | 133302 | 35623256 | 5.67590483422572e+16 | 431110409697041 | SUPERCELL | 5731 | USA | 125022 | 840 | 4.58 | 4.58 | 493 | [PHONE] | 2333 | 000000S00000
TRF | 201907 | 20190704 | 20190705 | IND | 133302 | 35623364 | 9.21136737240145e+16 | 430001003352172 | DRUG | 5914 | IND | 144031 | 608 | 1102.4 | 21.62 | 2334 | [PHONE] | 4445 | 510ZZ1C15006
Spreadsheet: 166087d1341467959-offset-function-that-i-cannot-get-to-work-properly-excel-example
Sheet: Sheet1

DATE | TIME | OPEN | HIGH | LOW | CLOSE
07/01/11 | 17:30:00 | 335.83 | 335.86 | 335.485 | 335.71
07/01/11 | 17:31:00 | 335.56 | 335.73 | 335.56 | 335.62 |  | 1. I need the formula to take the date, time, and open price for the range of cells
07/01/11 | 17:32:00 | 335.62 | 335.65 | 335.24 | 335.36 |  | 2. then calculate the high for the range of cells
07/01/11 | 17:33:00 | 335.27 | 335.32 | 335.1 | 335.1 |  | 3. then calculate the low for the range of cells
07/01/11 | 17:34:00 | 335.1 | 335.16 | 334.82 | 334.985 |  | 4. then take the close for the range of cells
07/01/11 | 17:35:00 | 334.97 | 334.97 | 334.84 | 334.94 |  | 5. then repeat it for 95,000 rows of the original data
07/01/11 | 17:36:00 | 334.87 | 334.87 | 334.52 | 334.54 |  | So I should end up with 19000 (95000/5) rows of new “compressed” data
07/01/11 | 17:37:00 | 334.52 | 334.64 | 334.2 | 334.6
07/01/11 | 17:38:00 | 334.51 | 334.58 | 334.43 | 334.47
07/01/11 | 17:39:00 | 334.54 | 334.56 | 334.34 | 334.44
07/01/11 | 17:40:00 | 334.4 | 334.79 | 334.4 | 334.79
07/01/11 | 17:41:00 | 334.8 | 334.93 | 334.71 | 334.89
07/01/11 | 17:42:00 | 334.94 | 335.23 | 334.94 | 335.17
07/01/11 | 17:43:00 | 335.23 | 335.37 | 335.2 | 335.29
07/01/11 | 17:44:00 | 335.32 | 335.36 | 335.22 | 335.305
THIS INPUT (ABOVE) SHOULD CREATE THIS OUTPUT (BELOW)
DATE | TIME | OPEN | HIGH(MAX) | LOW(MIN) | CLOSE
07/01/11 | 17:30:00 | 335.83 | 335.86 | 334.82 | 334.985
07/01/11 | 17:35:00 | 334.97 | 334.97 | 334.2 | 334.44
07/01/11 | 17:40:00 | 334.4 | 335.37 | 334.4 | 335.305
Spreadsheet: 816462d1675643111-how-to-get-table-b-from-table-a-st
Sheet: Sheet1

NAME | Good at subject A | Good at subject B | Good at subject C | Good at subject D | Good at subject E |  |  | language | math | English | history | geography
ABC | language | math | English | history | geography |  |  | ABC | ABC | ABC | ABC | ABC
CDE | math | geography |  |  |  |  |  | HIJ | CDE | EFG | EFG | CDE
EFG | English | math | history |  |  |  |  |  | EFG |  | HIJ | HIJ
HIJ | history | geography | language | math |  |  |  |  | HIJ |  | XYZ
XYZ | math | history |  |  |  |  |  |  | XYZ
TABLE A |  |  |  |  |  |  |  | TABLE B
Spreadsheet: 154165d1336264614-formula-based-on-region-and-less-than-certain-values-djblois1-lookup-into-multiple-tables
Sheet: Week 1

CDT DELIVERY
DATES: | April 2 to April 6, 2012
* ADD ON ORDER
B/L | Customer | Zone | Weight | Amount
 |  | NY | 1099
 |  | NY | 1999
 |  | NY | 4999
 |  | NJ | 1099
 |  | NJ | 1999
 |  | NJ | 4999
 |  | PA | 1249
 |  | PA | 1999
 |  | PA | 4999
 |  | NYC | 899
 |  | NYC | 1999
 |  | NYC | 4999
 |  |  | TOTAL :
Spreadsheet: 704546d1605619722-formula-which-runs-concurrent-numbers-across-two-lists-sample-1
Sheet: Sheet1

NAME | # | NAME | #
BOB |  | JOE
CAT |  | BLOGGS
Type Here |  | To Generate Number to right
asda |  | asdasdasd
asdasd |  | asdasdasd