tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7828__Mops Operators
Sheet: Sheet1

 |  |  | MATAGORDA  OFFSHORE PIPELINE  SYSTEM (MOPS)
 |  |  |  | OPERATOR PHONE  LISTING
 | POI |  | POI |  | OPERATOR |  | CONTACT |  | PHONE
 | NAME |  |  |  |  |  | NAME
 | MATAGORDA  631 |  | 62309 |  | FOREST OIL |  | RAY  LAILHENGUE |  | [PHONE]
 | MATAGORDA  632 |  | 25035 |  | EXXON |  | MADALYN  SIGMUND |  | [PHONE]
 | MATAGORDA  696/665 |  | 25321 | AMERADA  HESS | AMERADA HESS |  | STACY CHENG
 | MATAGORDA  665 |  | 896 |  | [NAME]  Energy |  | [NAME]  [NAME] |  | [PHONE]
 | MATAGORDA  685/686 |  | 452 |  | OXY |  | [NAME]  CARSTEN |  | [PHONE]
 | MATAGORDA  669 |  | 8104 |  | BP-Amoco |  | [NAME]  CARSTEN |  | [PHONE]
 | MATAGORDA  668 |  | 9897 |  | BP-Amoco |  | ERON ROBINSON |  | [PHONE]
 | MATAGORDA  681 |  | 17925 |  | Cinergy |  | LISA  HUGHES |  | [PHONE]
 | MATAGORDA  688/687 |  | 9898 |  | Energy Reso. Tech. |  | [NAME] |  | [PHONE]
 | MATAGORDA  703/704 |  | 17926 |  | BP-Amoco |  | ERON ROBINSON |  | [PHONE]
 | MATAGORDA  713 |  | 327 |  | Enron North Amer. |  | [NAME] |  | [PHONE]
 | [NAME] |  | 3364 |  | SONAT |  | JANELLE  WALTER |  | [PHONE]
 | [NAME] |  | 25322 |  | Enron North Amer. |  | MADELINE  BABLIN |  | [PHONE]
 | MUSTANG  738 |  | 62311 |  | Houston Expl. Co. |  | LESTER  LIPPERT |  | [PHONE]
 | MUSTANG  782 |  | 61449 |  | Superior Nat. Gas |  | RENEE WOHLFART |  | [PHONE]
 | MUSTANG  789/787 | 789/787/805 | 60550 |  | BP-Amoco |  | [NAME] |  | [PHONE]
 | MUSTANG  759 |  | 62310 |  | Enron North Amer. |  | [NAME] |  | [PHONE]
 | MUSTANG  758 |  | 1226 |  | Enron North Amer. |  | [NAME] |  | [PHONE]
 | MUSTANG  762 |  | 2410 |  | BP-Amoco |  | ERON ROBINSON |  | [PHONE]
 | MUSTANG  785 |  | 58129 |  | Houston Expl. Co. |  | LESTER  LIPPERT |  | [PHONE]
 | MUSTANG  803 |  | 63076 |  | [NAME] |  | PAUL SEDITA |  | [PHONE]
 | MUSTANG  831 |  | 840 |  | [NAME]. Svs. |  | [NAME] |  | [PHONE]
 | [NAME] |  | 37388 |  | Cinergy |  | LISA  HUGHES |  | [PHONE]
 | SEADRIFT |  | 49581 |  | [NAME] |  | CHARLIE  [NAME] |  | [PHONE]
 | HPL |  | 287 |  | EOG  RESOURCES |  | ROSA  BROWN |  | [PHONE]
 | FGT |  | 611 |  | [NAME]. |  | LYNDA  LAFERLA |  | [PHONE]
 | TEJAS |  | 1644 |  | Tejas  Gas Mktg. |  | [NAME]TRACHTA |  | [PHONE]
 | [NAME] |  | 346 |  | [NAME] |  | NATASHA  WHITTEN |  | [PHONE]
Spreadsheet: 57802d1258023353-how-to-manage-new-year-file-name-change-when-linked-to-external-workbooks-summary-sheet
Sheet: Sheet1

Name | Party ID | Rate | Nights | TOTALS
[NAME] | 2 | 10 | 3 | 30
[NAME] | 3 | 12 | 4 | 48
[NAME] | 5 | 3 | 5 | 15
[NAME] | 1 | 25 | 1 | 25
 |  |  | Subtotal | 118
Spreadsheet: 192395d1352395107-help-with-some-sort-of-vlookup-vlookup-copy-value
Sheet: Sheet1

customer part no. | product no. | formula |  |  | 77921381A | ID found
011 786.3 | 77921381A |  |  |  | 77932541A | ID found
CV CUTTING GENERAL | 11001
[NAME] TUBE CUT | 11022 |  |  | from here to hear I also want to say ID found
CV CRIMPING AREA | 11033
CV PRE-ASSEMBLY AREA | 11051
[NAME] CLAAS | 21005
CV PACKING AREA | 99001
Standard Time
013 113.0 | 77902531A |  | <- here is not found so it's ok as N/A
CV CUTTING GENERAL | 11001
CLOSED CONVOLUTE TUB | 11023
[NAME] CLAAS | 21005
CV TEST AREA | 90001
CV PACKING AREA | 99001
Standard Time
013 224.2 | 77932541A
CV CUTTING GENERAL | 11001 |  |  | from here to hear I also want to say ID found
CV TUBE CUT TO 6,5 M | 11020
[NAME] CLAAS | 21005
CV TEST AREA | 90001
CV PACKING AREA | 99001
Standard Time
Spreadsheet: 163582-help-with-moving-multiple-columns-and-checking-alignment-sheet4
Sheet: Sheet4

Number | Name | Score
22648 | student 1 | 1 | 1 | 1 | 0
22955 | student 2 | 3 | 3 | 2 | 2
22966 | student 3 | 1 | 1 | 1 | 2
22969 | student 4 | 1 | 1 | 1 | 1
23343 | student 5 | 1 | 1 | 1
23500 | student 6 | 1 | 2 | 2 | 3
23502 | student 7 |  |  | 2
23503 | student 8 |  | 2 | 1
25320 | student 9 | 2 | 1 | 1 | 1
Spreadsheet: john_griffith__15604__Mesa Model 1_10_01
Sheet: Index Quote

Trader |  | Originator |  | Structurer |  | Customer
 |  | [NAME] |  | [NAME] x. 36247 |  | City of Mesa
Start | Stop |  | Monthly |  |  |  |  | Index
Date | Date | Term | MMbtu |  | Delivery Points |  |  | Offer
 |  |  | see below |  | IF-ELPO/SJ
 | Month | Volume/month
 | 2001-08-01 00:00:00 | 177000
 | 2001-09-01 00:00:00 | 178000
 | 2001-10-01 00:00:00 | 217000
 | 2001-11-01 00:00:00 | 268000
 | 2001-12-01 00:00:00 | 446000
 | 2002-01-01 00:00:00 | 421000
 | 2002-02-01 00:00:00 | 336000
 | 2002-03-01 00:00:00 | 317000
 | 2002-04-01 00:00:00 | 225000
 | 2002-05-01 00:00:00 | 190000
 | 2002-06-01 00:00:00 | 167000
 | 2002-07-01 00:00:00 | 166000
 | Total
Spreadsheet: 124897d1318697757-excel-2007-sumif-cost
Sheet: Main

 | Type | Error | Cost | Total
1 | PC | Harddrive
2 | MAC | Harddrive
3 | PC | Monitor
4 | MAC | Monitor
5 | PC | Keyboard
6 | PC | Touchpad
7 | PC | Sound
Spreadsheet: darrell_schoolcraft__7762__imbalsumm0106
Sheet: Conoco

 | Maljamar |  | Zia
Day | Measured | Scheduled | Measured | Scheduled
1 | 40803 | 40714 | 37694 | 35000
2 | 41335 | 40714 | 42690 | 35000
3 | 39966 | 40714 | 41584 | 40000
4 | 41167 | 40714 | 39857 | 40000
5 | 44360 | 43714 | 39563 | 40000
6 | 41924 | 43713 | 36834 | 39999
7 | 41447 | 43714 | 35036 | 38000
8 | 36290 | 40000 | 32619 | 34000
9 | 39937 | 38777 | 32705 | 31047
10 | 39338 | 38777 | 31137 | 31047
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-05-31 00:00:00 |  | 2444005.89 |  | -2072427.18
2001-06-10 00:00:00
Spreadsheet: 60394d1260935611-excel-2007-formula-hours-worked-past-midnight-work-rosters
Sheet: Test Formulas

 | Time On | Time Off | [NAME]
 | 06:00:00 | 18:00:00
 | 06:00:00 | 14:00:00
 | 06:00:00 | 18:00:00
 | 13:30:00 | 01:30:00 |  | <-- Problem with going past midnight!
 | 18:00:00 | 02:00:00 |  | <-- Problem with going past midnight!
 | Total Hrs |  |  | <-- Would like this in format HHH:MM
Spreadsheet: 120354d1315232517-unique-running-total-criteria-conditonal-conditional_sum_example
Sheet: Sheet1

Day | Daily Total | 7 Day Total | 8 Day Total
1 | 10.25 | 10.25 | 10.25 |  | Column A: Day of the month
2 | 5 | 15.25 | 15.25 |  | Column B: A daily total, changes per day
3 | 10 | 25.25 | 25.25 |  | Column C: A running total of the sum of the last 7 day's daily totals if no reset within last 7 days
4 | 7.25 | 32.5 | 32.5 |  | Column D: A running total of the sum of the last 8 day's daily totals if no reset within last 8 days
5 | RESET | 0 | 0
6 | 7 | 7 | 7 |  | Reset: A complete reset of running totals that restarts the sum for 7 and 8 day totals
7 | 10.5 | 17.5 | 17.5
8 | 10.5 | 28 | 28
9 | 5 | 33 | 33 |  | Only column B will be manipulated by hand; columns C and D will be dynamically calculated per entry.
10 | 11 | 44 | 44 |  | Column A represents the day of the month and is always static.
11 | 9 | 53 | 53
12 | 14 | 67 | 67
13 | 0 | 60 | 67
14 | 12.75 | 62.25 | 72.75
Spreadsheet: a8394ab9-7449-4b19-816e-8c82d3e9a874
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
FGCU | Test | FGCU | Guanidinoacetic acid + creatine, [NAME] | Guanidinoacetate and Creatine, U | Gas Chromatography-Mass Spectrometry | [NAME]: Urine |  |  | 2 | mL | Collect 2 mL urine from fasting patient. [NAME] should be collected without preservative. Ship frozen. | 2 mL | Hemolysis:	NA Thawing:	Warm reject; Cold OK Lipemia:	NA Icterus:	NA Other:	NA | Creatine/Creatinine ratio Normal Range:                              <4y: 0.01 - 1.19 (SD), [NAME]: 0.01 - 1.51 (SD), N=41              >12y: 0.01 - 0.40 (SD), N=43                Affected Range:      X-linked creatine transporter deficiency:        range = 2.0 - 4.8, n=6                  Guanidinoacetate   Normal Range:                                 <4y:     9 - 200 mmol/mol creatinine, N = 51      4-12y:    12 - 127 mmol/mol creatinine, N = 41       >12y:     8 -   68 mmol/mol creatinine, N = 43                   Affected Range:      guanidinoacetate methyltransferase deficiency: 458 - 777, n = 3      arginine: glycine amidinotransferase deficiency: <1, n = 2   Test Performed by: Kennedy Krieger Institute                              707 North Broadway                              Baltimore, MD 21205 | Monday and Wednesday | 5 - 7 days | 7 - 11 days | 1 | 82544 |  |  |  |  | Kennedy Krieger Institute
FGCU | [NAME] | URINE | [NAME] |  |  |  | Frozen
FGCU | Result | Z2990 | Creatine/Creatinine ratio | Creatine/Creatinine ratio | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FGCU | Result | Z2991 | Guanidinoacetate | Guanidinoacetate | Alphanumeric |  |  |  |  | mmol/mol Cr |  |  |  |  |  |  |  |  |  | In Process
FGCU | Result | Z2992 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 1c13668e-cbd8-44b2-8bfa-55e3f8967a85
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | YELLOW SECTION TO BE FILLED IN BY NCH | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
School Name: ------>
First Name | Middle Initial | Last Name | Start Date (Date Account Required) | Last Clinical Day (Account will expire following day) | Date Given | Badge Number | Date Return |  |  |  |  | Comments
Total IDs |  | 0
Total FPd |  |  |  |  |  |  | 0
Spreadsheet: 801204d1666112577-formula-to-sift-all-rows-containing-a-certain-number-into-a-table-on-another-sheet-sample
Sheet: Sheet2

 | Floor | Bare floorboards, non-insulated, poor condition with gaps but complete | WW | [NAME] | 2 | N
Living Room | Floor | Bare floorboards, non-insulated, poor condition with gaps but complete | EE | [NAME] | 2 | N
Other room | Floor | Bare floorboards, non-insulated, poor condition with gaps but complete | Any joist repairs undertaken | [NAME] | 2 | N
Other room | Floor | Bare floorboards, non-insulated, poor condition with gaps but complete | Temporary chipboard sheets laid to enable further works | [NAME] | 2 | N
Spreadsheet: 454506d1459868727-split-the-data-based-on-cell-value-copy-of-impo
Sheet: AIR

Sl.No | DOC Rec | Supplier | Invoice No | Date | FC | Material | Inv_Value | Mode of Transit | TERM | FCL/LCL | Farwarder | Bl/AWB | Date | Sailled on | Transit Days | Insured Date | ETA | CFS Entry | CHA | BOE No | Date | Steamer Agent | D.O | Duty | CFS Free End | Cleared On
Spreadsheet: 98981d1297782730-graph-help-multiple-days-data-into-one-graph-dowloginnotready
Sheet: Sheet1

Name | Login | Not Ready | DOW
Name1 |  |  |  |  |  | Name | (All)
[NAME]
Name3 |  |  |  |  |  | Row Labels | Count of Login | Count of Not Ready
Name4 |  |  |  |  |  | 1/27/2011 - 2/2/2011 | 21 | 18
Name5 |  |  |  |  |  | 1 | 6 | 6
Name1 |  |  |  |  |  | 2 | 7 | 5
[NAME] |  |  |  |  |  | 3 | 1 | 1
Name3 |  |  |  |  |  | 4 | 2 | 2
Name4 |  |  |  |  |  | 5 | 2 | 2
Name5 |  |  |  |  |  | 6 | 1 | 1
Name1 |  |  |  |  |  | 7 | 2 | 1
[NAME] |  |  |  |  |  | 2/3/2011 - 2/9/2011 | 15 | 11
Name3 |  |  |  |  |  | 1 | 5 | 4
Name4 |  |  |  |  |  | 2 | 2 | 2
Name5 |  |  |  |  |  | 3 | 1
Name1 |  |  |  |  |  | 4 | 2 | 2
[NAME] |  |  |  |  |  | 6 | 2 | 2
Name3 |  |  |  |  |  | 7 | 3 | 1
Name4 |  |  |  |  |  | 2/10/2011 - 2/14/2011 | 14 | 12
Name5 |  |  |  |  |  | 1 | 2 | 2
Name1 |  |  |  |  |  | 2 | 1
[NAME] |  |  |  |  |  | 5 | 3 | 3
Name3 |  |  |  |  |  | 6 | 6 | 5
Name4 |  |  |  |  |  | 7 | 2 | 2
Name5 |  |  |  |  |  | Grand Total | 50 | 41
Name1
[NAME]
Name3
Name4
Name5
Name1
[NAME]
Name3
Name4
Name5
Name1
[NAME]
Name3
Name4
Name5
Name1
[NAME]
Name3
Name4
Name5
Name1
[NAME]
Name3
Name4
Name5
Spreadsheet: 910b29e0-d61c-42ee-aaec-69495478985b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | 2009-06-22 00:00:00
 |  |  |  |  | SELECTION | [NAME] | PACK | MIN.
 |  |  |  |  |  | 6" HIBISCUS | 8 | 96
 |  |  |  |  |  | 8" HIBISCUS | 4 | 1 CASE
Finished TradeWinds Flowering Hibiscus 2009/2010 |  |  |  |  |  | 10"HIBISCUS | 2 | 1 CASE
 |  |  |  |  | CHECK FOR HOLIDAY CROP                                                           (one holiday per order form)
 |  |  |  |  | MOTHER'S DAY |  | VALENTINES DAY |  | EASTER
DISTRIB  #               & NAME |  |  |  |  |  | SHIP TO #            & NAME
SOLD TO #             & NAME |  |  |  |  |  | STREET, CITY, STATE & ZIP
STREET, CITY, STATE & ZIP
 |  |  |  |  |  | PHONE #
PHONE # |  |  |  |  |  | VISA / MC / DISC |  | CARDHOLDER NAME
SLSM. NAME |  |  | SLSM. #
 |  |  |  |  |  | CREDIT CARD NUMBER / CCV# |  |  | EXP DATE
Assorted Colors Only
 |  |  |  |  |  | 4 DATES PER ORDER
P.O.# |  | DELIVERY DATE |  | SHIP VIA |  | ORDER QTY |  | LOAD DATE | ORDER #
Order Information / Special Instructions:
P.O.# |  | DELIVERY DATE |  | SHIP VIA |  | ORDER QTY |  | LOAD DATE | ORDER #
Order Information / Special Instructions:
P.O.# |  | DELIVERY DATE |  | SHIP VIA |  | ORDER QTY |  | LOAD DATE | ORDER #
Order Information / Special Instructions:
P.O.# |  | DELIVERY DATE |  | SHIP VIA |  | ORDER QTY |  | LOAD DATE | ORDER #
Order Information / Special Instructions:
PLACED BY: | CUSTOMER |  |  | SLSM |  | DISTRIBUTOR |  | YODER
TAKEN BY: |  |  |  | DATE TAKEN: |  |  | KEYED BY/DATE:
Spreadsheet: 234515d1368116710-remove-hidden-characters-in-excel-http
Sheet: www-cyclonemobility-com_2013050

URL
http://www.cyclonemobility.com/wheelchairs%20-%20everyday%20-%20tailwind.html | 108 |  |  | l
http://www.cyclonemobility.com/fitnessequipment%20-%20equalizer.html | 108 |  |  | l
http://www.cyclonemobility.com/wheelchairs%20-%20everyday%20-%20ti%20mirage.html | 108 |  |  | l
http://www.cyclonemobility.com/fitnessequipment%20-%20uppertone.html | 108 |  |  | l
http://www.cyclonemobility.com/site/pages.php?mid=36&fid=0,2,10,36 | 54 |  |  | 6
http://www.cyclonemobility.com/contact%20us.html | 108 |  |  | l
http://www.cyclonemobility.com/wheelchairs%20-%20all%20terrain%20-%20Tracker%20Wheel.html | 108 |  |  | l
http://www.cyclonemobility.com/category_products.php?hdnMainCategoryID=31 | 49 |  |  | 1
http://www.cyclonemobility.com/manufacturer_products.php?hdnManufacturerID=33 | 51 |  |  | 3
http://www.cyclonemobility.com/manufacturer_products.php?hdnManufacturerID=33 | 51 |  |  | 3
http://www.cyclonemobility.com/functional-electrical-stimulation/people-with-ms/ | 47 |  |  | /
 | last character seen is the code number and this translates back to the correct character
Spreadsheet: 73402d1274075581-to-sum-up-the-total-of-one-group-having-2-and-more-than-2-columns-and-g-l-account-book1
Sheet: Sheet1

 | Group | 1 | 2 | 3 | 4 | 5
G/L Account | Description | Total of | Total of | Total of | Total of | Total of
 |  | Engine Assy | Alu Ph - Case/Cover | Steel Phase | Gear Section | Heat Treatment
SA70100130 | CANTEEN EXPENSES-Actual except PGA
SA70100130 | CANTEEN EXPENSES
SA10101525 | CASUAL INDIRECT  WORKER  - ALLOW
SA70100130 | CANTEEN EXPENSES-PGA's Share
SA10101405 | CASUAL DIRECT WORKER  - WAGES
SA10102110 | STAFF PROD - ALLOWANCES
SA10102115 | STAFF PROD - PRODUCTION INCENTIVE
TA10101210 | MAINT - MACHINERY SPARES - IMPORTED
TA10101110 | MAINT - MACHINERY SPARES - LOCAL
SA10102105 | STAFF PROD - SALARY
RA10301110 | CONS- CONSUMABLE STORES - LOCAL
SA10101705 | CONTRACTOR DIRECT WORKER - WAGES
SA10101110 | DIRECT WORKER - ALLOWANCES
SA10101105 | DIRECT WORKER - WAGES
RA10302110 | CONS- CUTTIGN TOOLS - LOCAL
SA10101115 | DIRECT WORKER - PRODUCTION INCENTIVE
TM10101200 | DEPRECIATION A/C (P & M)
 | Grand Total
Spreadsheet: c2a1e801-b725-41f7-91f1-69c1dd4ca40e
Sheet: Sheet1

# | [NAME] | [NAME] | min. | sec. | 2b s. | 2b ú. | 3b s. | 3b ú. | TH s. | TH ú. | DU | DO | DC | Bl | As | M+ | M- | F+ | F- | Val | b.
4 | Moučková | Eva | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | Pospíšilová | Šárka | 17 | 2 | 1 | 0 | 3 | 0 | 2 | 2 | 0 | 1 | 1 | 0 | 1 | 0 | 4 | 3 | 1 | -2 | 2
6 | Novocká | [NAME] | 30 | 33 | 3 | 1 | 4 | 1 | 2 | 2 | 1 | 3 | 4 | 0 | 0 | 1 | 0 | 2 | 3 | 6 | 7
7 | Zdeňková | Kristýna | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8 | [NAME] | [NAME] | 19 | 0 | 3 | 0 | 2 | 0 | 3 | 2 | 2 | 0 | 2 | 0 | 2 | 1 | 2 | 1 | 4 | -4 | 2
9 | [NAME] | [NAME] | 26 | 24 | 2 | 0 | 2 | 0 | 4 | 4 | 0 | 4 | 4 | 0 | 3 | 1 | 2 | 4 | 1 | 9 | 4
11 | Kučerová | Šárka | 36 | 18 | 13 | 10 | 1 | 0 | 6 | 5 | 2 | 7 | 9 | 2 | 4 | 3 | 0 | 4 | 2 | 40 | 25
13 | Krč-Turbova | [NAME] | 30 | 40 | 14 | 5 | 0 | 0 | 2 | 2 | 3 | 5 | 8 | 0 | 2 | 1 | 3 | 3 | 2 | 12 | 12
14 | Letková | Martina | 6 | 57 | 2 | 1 | 1 | 1 | 0 | 0 | 1 | 2 | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 8 | 5
16 | [NAME] | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
21 | Houdková | [NAME] | 31 | 4 | 9 | 4 | 1 | 0 | 4 | 3 | 2 | 2 | 4 | 0 | 0 | 3 | 6 | 3 | 3 | 5 | 11
32 | [NAME] | [NAME] | 1 | 58 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0
 |  |  | 40 | 0 | 47 | 21 | 14 | 2 | 23 | 20 | 11 | 25 | 36 | 2 | 12 | 11 | 18 | 21 | 17 | 74 | 68
 |  |  |  |  | 45% |  | 14% |  | 87%
Spreadsheet: 147674d1332924379-linking-sheet-1-and-sheet-2-sample3
Sheet: Sheet2

data | data | data | data | Timestamp | data | data | flag as either stable neutral or unstable
 |  |  |  | 2010-11-10 15:00:00
 |  |  |  | 2010-11-10 15:00:00
 |  |  |  | 2010-11-10 15:00:00
 |  |  |  | 2010-11-10 15:00:00
 |  |  |  | 2010-11-10 15:00:00
 |  |  |  | 2010-11-10 15:00:00
 |  |  |  | 2010-11-10 15:00:00
 |  |  |  | 2010-11-10 15:30:00
 |  |  |  | 2010-11-10 15:30:00
 |  |  |  | 2010-11-10 15:30:00
 |  |  |  | 2010-11-10 15:30:00
 |  |  |  | 2010-11-10 15:30:00
 |  |  |  | 2010-11-10 15:30:00
 |  |  |  | 2010-11-10 15:30:00
 |  |  |  | 2010-11-11 00:40:00
 |  |  |  | 2010-11-11 00:40:00
 |  |  |  | 2010-11-11 00:40:00
 |  |  |  | 2010-11-11 00:40:00
 |  |  |  | 2010-11-11 00:40:00
 |  |  |  | 2010-11-11 00:40:00
 |  |  |  | 2010-11-11 00:40:00
 |  |  |  | 2010-11-11 01:20:00
 |  |  |  | 2010-11-11 01:20:00
 |  |  |  | 2010-11-11 01:20:00
 |  |  |  | 2010-11-11 01:20:00
 |  |  |  | 2010-11-11 01:20:00
 |  |  |  | 2010-11-11 01:20:00
 |  |  |  | 2010-11-11 01:20:00
 |  |  |  | 2010-11-11 02:40:00
 |  |  |  | 2010-11-11 02:40:00
 |  |  |  | 2010-11-11 02:40:00
 |  |  |  | 2010-11-11 02:40:00
 |  |  |  | 2010-11-11 02:40:00
 |  |  |  | 2010-11-11 02:39:59.995000
 |  |  |  | 2010-11-11 02:39:59.995000
Spreadsheet: 455549d1460394268-plotting-maximum-and-miminum-values-per-conditions-max-and-min-as-per-conditions-110416
Sheet: max and min

1 | 2010-01-01 00:00:00 | 9.383333333333333 |  |  | [NAME]. | Min |  |  | Plotting maximum and miminum values per conditions
2 |  | 9.4
3 |  | 9.563333333333333 | -1 |  |  |  |  |  | Hello Friends
4 |  | 9.536666666666667
5 |  | 9.65 |  |  |  |  |  |  | Please find the attached file ([NAME] and min as per conditions 110416.xlsx)
6 |  | 9.7333333333333
7 |  |  |  |  |  |  |  |  | If in Column D `0' is present then the first 3 values from 0 should be omitted in Column C and for remaining values upto next -1 or +1 (highlighted in light green) I need to find the [NAME]. and min. value.
8 |  | 9.7333333333333
9 |  | 9.633333333333333 |  |  |  |  |  |  | The 0 in column D is bolded and the dates and Sl. No. is for reference.
10 |  | 9.520000000000001
11 |  | 9.543333333333333 | 0 |  |  |  |  |  | thanks in advance
12 |  | 9.486666666666668
13
14
15 |  | 9.5666666666667
16 |  | 9.6333333333333
17 |  | 9.629999999999999
18 |  | 9.57 | 1
19 |  | 9.666666666666666
20 |  | 9.653333333333334
21
22 |  | 9.763333333333332
23 |  | 9.756666666666666
24 |  | 9.866666666666667
25
26 |  | 1.2 | 0
27 |  | 1
28
29 |  | 1.1
30 |  | 1.1933333333333
31 |  | 1.23
32 |  | 1.2266666666667
33 |  | 1.2 | -1
34 |  | 1.2
35
36 |  | 1.1566666666667
37 |  | 1.466666666667
38 |  | 1.15
39 |  | 1.1566666666667
40 |  | 1.2666666666667
41 |  | 1.3233333333333 | 0
42
43
44 |  | 1.533333333333
45 |  | 1.2866666666667
46 |  | 1.31
47 |  | 1.333333333333 | 1
48 |  | 1.38
49
50 |  | 1.433333333333
51 |  | 1.4133333333333
52 |  | 1.466666666667
53 |  | 1.3766666666667
54 |  | 1.566666666667
55 |  | 1.48 | 0
56
57 |  | 1.4733333333333
58 |  | 1.66
59 |  | 1.53
60 |  | 1.64
61 |  | 1.7666666666667
62 |  | 1.76 | -1
63
64 |  | 1.7833333333333
65 |  | 1.7333333333333
66 |  | 1.6466666666667
67 |  | 1.4733333333333
68 |  | 1.3333333333333
69 |  | 1.39
70 |  |  | 0
71 |  | 1.56
72 |  | 1.4866666666667
73 |  | 1.4233333333333
74 |  | 1.37
75 |  | 1.29
76 |  | 1.31
77 |  |  | 1
78 |  | 1.6466666666667
79 |  | 1.6933333333333
80 |  | 1.9233333333333
81 |  | 1.9933333333333
82 |  | 1.9866666666667
83 |  | 1.9733333333333
84
85 |  | 11.12333333333333 | 0
86 |  | 11.13666666666667
87 |  | 11.27
88 |  | 11.22666666666667
89 |  | 11.14
90 |  | 11.14333333333333
91
92 |  | 11.33 | -1
93 |  | 11.39666666666667
94 |  | 11.55666666666667
95 |  | 11.54
96 |  | 11.69333333333333
97 |  | 11.75666666666667
98
99 |  | 11.76333333333333
100 |  | 11.92333333333333 | 0
Spreadsheet: 754446d1636203973-sorting-from-a-lst-file-use-power-query-function-add-column-from-example-to-parse-text-string-celxicfetlon-
Sheet: Sheet1

Details
136 000 07.00.0333000 000000 Clif farm Ltd 3,587.77- 3,587.77- 3,587.77- 3,587.77- |  | Text Before Delimiter | Text Between Delimiters | Text Between Delimiters.1 | Text Between Delimiters.2 | Text Between Delimiters.3 | Text Between Delimiters.4 | Text Between Delimiters.4 - Copy | Text Between Delimiters.4 - Copy - Copy | Text Between Delimiters.4 - Copy - Copy - Copy
136 000 80.00.0444000 000001 Star wars S c c 346,914.92- 346,914.92- 346,914.92- 346,914.92- |  | 136 | 000 | 07.00.0333000 | 000000 | Clif farm Ltd | -3587.77 | -3587.77 | -3587.77 | -3587.77
 |  | 136 | 000 | 80.00.0444000 | 000001 | Star wars S c c | -346914.92 | -346914.92 | -346914.92 | -346914.92
Spreadsheet: 738187d1624889826-formula-for-total-and-entries-excel-question-2806
Sheet: Sheet1

A
Name | Amount
[NAME] | 10
Mark | 20
[NAME] | 30
[NAME] | 10
[NAME] | 20
Mark | 30
[NAME] | 40
[NAME] | 50
[NAME] | 60
Mark | 70
[NAME] | 80
[NAME] | 90
[NAME] | 100
Mark | 110
[NAME] | 120
[NAME] | 130
[NAME] | 140
Mark | 150
[NAME] | 160
[NAME] | 170
B
Name | Total | Entries |  | Name | Sum of Amount | Count of Amount
 |  | 5 |  | [NAME] | 330 | 5
 |  | 5 |  | Mark | 380 | 5
 |  | 5 |  | [NAME] | 450 | 5
 |  | 5 |  | [NAME] | 430 | 5
 |  |  |  | Grand Total | 1590 | 20