tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 131159d1322765094-three-sided-lookup-samples-02
Sheet: Report-02

ABC & CO
Warehouse | Category | Products | Pack Size | Opening | New Production | Re-Work | Received | Transferred | Samples Issued | Closing
All | Total | Aerosol | 150-Mls. | 225 | 1505 | 125 | 3325 | 125 | 525 | 4405
All | Total | Copper | 25-Gms. | 75 | 1773 | 75 | 1575 | 975 | 75 | 2373
All | Total | [NAME] | 25-Gms. | 275 | 1211 | 125 | 125 | 875 | 125 | 611
All | Total | Oracle | 50-Mls. | 164 | 893 | 125 | 125 | 425 | 125 | 632
All | Total | Star | 50-Mls. | 257 | 1545 | 125 | 125 | 1125 | 125 | 677
All | Total | Star-01 | 50-Mls. | 205 | 2465 | 125 | 125 | 125 | 125 | 2545
All | Total | Star-02 | 1-Kg. | 125 | 925 | 125 | 925 | 525 | 125 | 1325
All | Total | Star-02 | 250-Gms. | 341 | 1069 | 125 | 4125 | 1325 | 125 | 4085
All | Total
All | Total
Spreadsheet: kim_ward__20743__Price_quotes
Sheet: Sheet3

City of Palo Alto - Indicative Price Quotes
 | 2001-04-16 00:00:00
 | Malin | PG&E
2001-07-01 00:00:00 | 10.99 | 13.643
2001-08-01 00:00:00 | 11.32 | 13.78
2001-09-01 00:00:00 | 11.03 | 13.668
2001-10-01 00:00:00 | 10.28 | 12.58
2001-11-01 00:00:00 | 11.36 | 12.86
2001-12-01 00:00:00 | 11.48 | 13.03
2002-01-01 00:00:00 | 11.53 | 13
2002-02-01 00:00:00 | 11.34 | 12.75
2002-03-01 00:00:00 | 11.01 | 12.5
2002-04-01 00:00:00 | 7.16 | 7.54
2002-05-01 00:00:00 | 6.99 | 7.4
2002-06-01 00:00:00 | 7.03 | 7.41
2002-07-01 00:00:00 | 7.1 | 7.89
2002-08-01 00:00:00 | 7.11 | 7.9
2002-09-01 00:00:00 | 6.99 | 7.88
2002-10-01 00:00:00 | 6.99 | 7.55
2002-11-01 00:00:00 | 7.55 | 7.37
2002-12-01 00:00:00 | 7.66 | 7.47
2003-01-01 00:00:00 | 7.6 | 7.42
2003-02-01 00:00:00 | 7.43 | 7.24
2003-03-01 00:00:00 | 7.19 | 7
2003-04-01 00:00:00 | 5.35 | 5.5
2003-05-01 00:00:00 | 5.22 | 5.43
2003-06-01 00:00:00 | 5.23 | 5.44
2003-07-01 00:00:00 | 5.24 | 5.46
2003-08-01 00:00:00 | 5.27 | 5.49
2003-09-01 00:00:00 | 5.27 | 5.48
2003-10-01 00:00:00 | 5.27 | 5.48
2003-11-01 00:00:00 | 5.33 | 5.2
2003-12-01 00:00:00 | 5.45 | 5.35
2004-01-01 00:00:00 | 5.49 | 5.35
2004-02-01 00:00:00 | 5.37 | 5.25
2004-03-01 00:00:00 | 5.23 | 5.1
2004-04-01 00:00:00 | 4.46 | 4.79
2004-05-01 00:00:00 | 4.49 | 4.83
2004-06-01 00:00:00 | 4.53 | 4.86
Spreadsheet: 17b61207-b9ef-4d6a-b100-3c12df70d5dd
Sheet: Egypt

Export Sales | Unshipped Balance |  | Accumulated Exports |  | Total Commitments
Egypt | this year | last year | this year | last year | this year | last year
Spreadsheet: e3bcc62f-aa2f-463b-a991-840feecb1f8f
Sheet: JAN

SEATTLE UNIVERSITY
NON-EXEMPT EMPLOYEE TIME REPORT
NAME: |  |  |  |  | DEPT: |  |  | (Use 4 letter-code as shown on paystub under DEPT)
Datatel ID Number or SSN:
PE: |  | 2015-01-01 00:00:00 | TO | 2015-01-31 00:00:00 |  | MO. NO.: |  | 1
Holiday Pay |  |  |  | HP | 8
Sick Pay |  |  |  | SP
Vacation Pay |  |  |  | VP
[NAME] |  |  |  | BR |  | (up to 5 days of paid leave)
Jury Duty Leave |  |  |  | JL
[NAME] |  |  |  | DP
 |  |  |  |  |  |  |  |  | Employee Signature |  |  |  | Date
Regular Pay |  |  |  | RP
SUB-TOTAL |  |  |  |  | 88 |  |  |  | Supervisor Signature |  |  |  | Date
Overtime (1.0 rate) |  |  |  |  |  | (If total hours worked (Sunday-Saturday) is between 37.50 and 40)
Overtime (1.5 rate) |  |  |  |  |  | (If total hours worked (Sunday-Saturday) is above 40)
TOTAL
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  |  |  |  |  |  |  | HP | 4 |  | 4
 |  |  |  |  |  |  |  |  | 1 |  | 2 |  | 3
 |  |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
 | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10
 |  |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
 | 11 |  | 12 |  | 13 |  | 14 |  | 15 | Time sheets due | 16 |  | 17
 |  | HP | 4 |  | 4 |  | 4 |  | 4 |  | 4
 | 18 |  | MLK 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24
 |  |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
 | 25 |  | 26 |  | 27 |  | 28 |  | 29 | Payday | 30 |  | 31
REMEMBER: Adjustment from Prior Month!! INCLUDE PRIOR MONTH ADJ HOURS IN THE ABOVE CALCULATION!
Spreadsheet: 717154d1612515346-functions-to-cleanse-data-to-a-specific-format-bazlurgan-dummy-workbook
Sheet: Sheet1

Reference mixed | reference cleansed
12A    00001234/D | A1234
1 A  1234 | A1234
A0001234 | A1234
2C0001234/E | C1234
C    0001234/E | C1234
Spreadsheet: 1aaeeb5e-a1fc-4546-9e7e-2aa0e427d1c1
Sheet: D

Course color corresponds with term of offering.  BLUE for Spring semester, PURPLE for J-term, GREEN for both Spring and J-term.
 | AOK Designation | CAR Designation | Comment
Drama
DRAM 111 | Arts & Literature-Arts
DRAM 211 | Arts & Literature-Arts
DRAM 212 | Arts & Literature-Arts
DRAM 215 | Arts & Literature-Arts
DRAM 310 | Arts & Literature-Arts (3 times at 1 hour)
DRAM 320 | Arts & Literature-Arts
 | OR Arts & Literature-Literature
DRAM 330 | Arts & Literature-Arts
DRAM 331 | Arts & Literature-Arts | Computing
DRAM 332 | Arts & Literature-Arts
DRAM 333 | Arts & Literature-Arts
DRAM 334 | Arts & Literature-Arts
DRAM 341 | Arts & Literature-Arts
DRAM 342 | Arts & Literature-Arts
DRAM 381 |  | Experiential-Research
DRAM 381 | Arts & Literature-Arts |  | J-term 2013 (Black American Theater)
DRAM 381 | Arts & Literature-Arts |  | J-term 2013 (Playmaking: The Playwright's Process)
DRAM 382 |  | Experiential-Research
DRAM 422 |  | Experiential-Research; Capstone
Spreadsheet: 776455d1649747561-index-formula-looking-up-dynamic-columns-order-list-sample
Sheet: Orders

Truck Number | Booking ID | Timeslot | Delivery Number | Shipment Number | [NAME] | Destination Name | Pallet Count | Pallet Module | Pallet Space | Dead Weight (Tonne) | Pickup Date | Pickup Time | Destination State | PO Number | Customer Notes
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 | 06:00:00 |  | [PHONE] | 06:00:00
 | 06:00:00 |  | [PHONE] | 06:00:00
 | 06:00:00 |  | [PHONE] | 06:00:00
 | 06:00:00 |  | [PHONE] | 06:00:00
 | 06:00:00 |  | [PHONE] | 06:00:00
 | 06:00:00 |  | [PHONE] | 06:00:00
 | 09:00:00 |  | [PHONE] | 09:00:00
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 | 13:00:00 |  | [PHONE] | 13:00:00
 | 13:00:00 |  | [PHONE] | 13:00:00
 | 13:00:00 |  | [PHONE] | 13:00:00
 | 13:00:00 |  | [PHONE] | 13:00:00
 | 10:00:00 |  | [PHONE] | 10:00:00
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 | 10:00:00 |  | [PHONE] | 10:00:00
 | 14:30:00 |  | [PHONE] | 14:30:00
Spreadsheet: 291422d1390291516-filling-down-formulas-simple-example
Sheet: Calculations

 |  |  | Pay
Spreadsheet: theresa_staab__39600__Independent email
Sheet: Detail

Independent | Contact: | [NAME] |  |  | Enron North America
 | PH: | [PHONE]
 | FAX: | [PHONE] |  |  | [NAME] | [PHONE]
Btu factor:
Transportation |  | per Mcf
 |  | Index Discount/Premium | Crestone Transport /Mmbtu | [NAME] |  | [NAME] | [NAME] (0%*NGPL index) | Total Receipts Fee Adjustment* | Total Net Back
Net Backs: | CIG GD | -0.02 |  | 0 | 0 | 0 | 0
 | IF NGPL Midcont. | 0.01 |  |  |  | -0.1226 | 0
 | IF CIG Rockies | 0.125
 |  | Over 80% of Production | CIG GD Volume MMBtu | 80% of Production up to 10,000/Day | NGPL Volume MMBtu | 80% of Production Less 10,000/Day | CIG Volume MMBtu |  | Allocated Fuel MMBtu (max 6.5%) | Total Production MMBtu | $ CIG GD | $ NGPL | $ [NAME] | Total Payment
 | CIG GD Rockies | CIG GD les Netback |  | NGPL less Netback |  | CIG less Netback
 |  |  |  |  |  |  |  | actual fuel
 |  |  |  |  |  |  |  |  |  | avg. $/Mmbtu
*Total Receipts Fee Adjustment is calculated by applying the Field Services Fee to the fuel volume and then dividing that dollar amount(fee times fuel volume) by the volume purchased.
Spreadsheet: 78f816a7-0c57-450d-bf83-0347aa5fb87f
Sheet: Table 2.3

2.3 Wage price index
Quarter | 2010-11 | 2011–12 | 2012–13 | 2013-14 | 2014-15
Wage price index (a) (b) – index
September | 105.5 | 109.4 | 113.4 | 116.5 | 119.4
December | 106.6 | 110.4 | 114.2 | 117.2
March | 107.5 | 111.5 | 115 | 118
June | 108.5 | 112.4 | 115.7 | 118.7
Annual average | 107.025 | 110.925 | 114.575 | 117.6
Quarterly change (b) – per cent
September | 0.9569377990430672 | 0.8294930875575979 | 0.8896797153024938 | 0.6914433880726101 | 0.5897219882055715
December | 1.042654028436019 | 0.9140767824497242 | 0.7054673721340388 | 0.6008583690987113
March | 0.8442776735459789 | 0.9963768115941907 | 0.7005253940455258 | 0.682593856655278
June | 0.9302325581395321 | 0.8071748878923923 | 0.6086956521739184 | 0.5932203389830581
Annual change (b) – per cent
September | 3.63457760314343 | 3.696682464454981 | 3.656307129798897 | 2.733686067019403 | 2.489270386266096
December | 3.898635477582846 | 3.564727954971869 | 3.442028985507251 | 2.626970227670755
March | 3.864734299516903 | 3.720930232558151 | 3.139013452914807 | 2.60869565217392
June | 3.827751196172247 | 3.594470046082954 | 2.935943060498225 | 2.592912705272266
Annual average | 3.806424644103856 | 3.644202674516989 | 3.293323157179795 | 2.640566163034086
(a) Total hourly rate of pay excluding bonuses, all sectors. Index base: 2008–09 = 100.0.
(b) Quarterly figures are seasonally adjusted.
Note: Prior to September quarter 2012, this publication was known as Labour Price Index. The catalogue number (6345.0) remains unchanged.
Source: ABS, Wage Price Index, Australia, Cat. no. 6345.0 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6345.0&viewtitle=Labour%20Price%20Index,%20Australia~Dec%202007~Latest~20/02/2008&&tabname=Past%20Future%20Issues&prodno=6345.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6345.0&viewtitle=Labour%20Price%20Index,%20Australia~Dec%202007~Latest~20/02/2008&&tabname=Past%20Future%20Issues&prodno=6345.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6345.0&viewtitle=Labour%20Price%20Index,%20Australia~Dec%202007~Latest~20/02/2008&&tabname=Past%20Future%20Issues&prodno=6345.0&issue=Dec%202007&num=&view=&
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2015-02-25 00:00:00
Spreadsheet: 100934d1299149008-matching-off-figures-in-different-cells-uncleslinky_test-1-
Sheet: Sheet4

Store Name | Loaned To Store/Borrowed From Store | Borrowed | Loaned
Store 1 | Store 6 | 4
Store 2 | Store 8 |  | 27
Store 2 | Store 9 |  | 10
Store 3 | Store 7 | 37
Store 3 | Store 5 | 10
Store 4 | Store 12 | 5
Store 5 | Store 8 | 14
Store 5 | Store 3 |  | 10
Store 6 | Store 1 |  | 4
Store 6 | Store 11 | 15 |  |  | Does Not Match Row19
Store 6 | Store 10 | 16
Store 7 | Store 3 |  | 37
Store 8 | Store 5 |  | 14
Store 8 | Store 2 | 27
Store 9 | Store 2 | 10
Store 10 | Store 6 |  | 16
Store 10 | Store 13 | 10
Store 11 | Store 13 | 5 |  |  | No Match
Store 11 | Store 6 |  | 14 |  | Does Not Match Row10
Store 12 | Store 4 |  | 5
Store 13 | Store 10 |  | 10
Spreadsheet: jason_wolfe__13476__loaddata_June&July_2001
Sheet: Jun 01

 |  |  |  |  |  |  |  |  | @CG | @MALIN
 |  |  |  |  |  |  |  | MCF | MMBTU | MMBTU
 | 5403 | 5401 | 5402 | 5404 | 5405 | 5406 | D416 | TOTAL | TOTAL | TOTAL
1999-06-01 00:00:00 | 2102 | 670 | 663 | 816 | 1151 | 9 | 8
1999-06-02 00:00:00 | 2308 | 719 | 717 | 862 | 1238 | 13 | 4
1999-06-03 00:00:00 | 2382 | 782 | 781 | 878 | 1259 | 13 | 1
1999-06-04 00:00:00 | 2395 | 832 | 833 | 925 | 1321 | 28 | 28
1999-06-05 00:00:00 | 2332 | 818 | 817 | 911 | 1300 | 29 | 13
1999-06-06 00:00:00 | 2158 | 723 | 722 | 873 | 1230 | 19 | 13
1999-06-07 00:00:00 | 1941 | 659 | 658 | 825 | 1156 | 11 | 22
1999-06-08 00:00:00 | 2067 | 673 | 673 | 838 | 1193 | 9 | 13
1999-06-09 00:00:00 | 2080 | 658 | 658 | 810 | 1160 | 6 | 3
1999-06-10 00:00:00 | 2167 | 683 | 681 | 830 | 1194 | 6 | 0
1999-06-11 00:00:00 | 2380 | 759 | 759 | 898 | 1286 | 18 | 27
1999-06-12 00:00:00 | 2314 | 743 | 742 | 884 | 1265 | 17 | 17
1999-06-13 00:00:00 | 2252 | 768 | 768 | 892 | 1272 | 20 | 22
1999-06-14 00:00:00 | 1999 | 725 | 716 | 813 | 1137 | 10 | 11
1999-06-15 00:00:00 | 2125 | 716 | 713 | 831 | 1182 | 8 | 7
1999-06-16 00:00:00 | 1977 | 635 | 634 | 800 | 1129 | 0 | 2
1999-06-17 00:00:00 | 1948 | 624 | 623 | 792 | 1121 | 0 | 4
1999-06-18 00:00:00 | 1981 | 651 | 649 | 819 | 1147 | 4 | 17
1999-06-19 00:00:00 | 1898 | 630 | 628 | 800 | 1118 | 2 | 7
1999-06-20 00:00:00 | 1824 | 605 | 604 | 779 | 1081 | 1 | 16
1999-06-21 00:00:00 | 1849 | 596 | 590 | 784 | 1091 | 1 | 13
1999-06-22 00:00:00 | 1994 | 630 | 628 | 808 | 1136 | 1 | 7
1999-06-23 00:00:00 | 2068 | 638 | 637 | 811 | 1159 | 0 | 1
1999-06-24 00:00:00 | 2160 | 681 | 679 | 824 | 1183 | 0 | 5
1999-06-25 00:00:00 | 2414 | 733 | 732 | 901 | 1295 | 10 | 22
1999-06-26 00:00:00 | 2309 | 703 | 700 | 876 | 1247 | 11 | 20
1999-06-27 00:00:00 | 2264 | 703 | 702 | 850 | 1211 | 10 | 17
1999-06-28 00:00:00 | 2245 | 680 | 678 | 859 | 1225 | 9 | 17
1999-06-29 00:00:00 | 2160 | 689 | 687 | 850 | 1206 | 10 | 14
1999-06-30 00:00:00 | 1948 | 631 | 630 | 774 | 1084 | 0 | 2
TOTAL
Spreadsheet: 4bd4765f-0018-4afc-986f-85d7cdd84022
Sheet: Sheet1

GO term | Description | Fold change | P-value
GO:0048311 | mitochondrion distribution | 15.6 | 2e-05
GO:0031261 | DNA replication prioritization complex | 6.5 | 0.001
GO:0016125 | [NAME] process | 5 | 0.001
GO:0008202 | steroid metabolic process | 4.3 | 0.002
GO:0005506 | iron ion binding | 5.2 | 0.002
GO:0000724 | double-strand break repair via homologous recombination | 5 | 0.003
GO:0016126 | sterol biosynthetic process | 4.5 | 0.004
GO:0000725 | recombinational repair | 4.3 | 0.005
GO:0030133 | transport vesicle | 4.3 | 0.005
GO:0031570 | DNA integrity checkpoint | 3.5 | 0.005
GO:0006694 | steroid biosynthetic process | 4.1 | 0.006
GO:0000077 | DNA damage checkpoint | 3.8 | 0.008
GO:0042770 | signal transduction in response to DNA damage | 3.6 | 0.009
GO:0015935 | small ribosomal subunit | 2.8 | 0.009
GO:0006302 | double-strand break repair | 3.6 | 0.01
GO:0016023 | [NAME] vesicle | 2.8 | 0.013
GO:0031410 | cytoplasmic vesicle | 2.8 | 0.013
GO:0007051 | spindle organization | 3.2 | 0.014
GO:0006310 | DNA recombination | 2.4 | 0.017
GO:0016879 | ligase activity, forming carbon-nitrogen bonds | 2.2 | 0.02
GO:0004842 | ubiquitin-protein ligase activity | 2.5 | 0.021
GO:0006270 | DNA-dependent DNA replication initiation | 2.7 | 0.025
GO:0006623 | protein targeting to vacuole | 2.7 | 0.025
GO:0006066 | alcohol metabolic process | 2.1 | 0.025
GO:0000151 | ubiquitin ligase complex | 2.6 | 0.028
GO:0016567 | protein ubiquitination | 2.1 | 0.034
GO:0005657 | replication fork | 2.4 | 0.034
GO:0000075 | cell cycle checkpoint | 2 | 0.046
 | P-value <0.05, ≥3 selected genes, enrichment ≥2.0
Spreadsheet: 198719d1354877518-compare-2-worksheets-show-differences-cmpare-jsts
Sheet: Jsts2

203 Auburn [NAME]
SKU | LABEL | MATERIAL | LENGTH | QTY REQ'D
[NAME] | Text | JSI 2000 2.5" X 14" | 2-0-0 | 1
J21405 | Text | JSI 2000 2.5" X 14" | 5-0-0 | 1
J21405 | Text | JSI 2000 2.5" X 14" | 5-0-0 | 1
J21406 | Text | JSI 2000 2.5" X 14" | 6-0-0 | 1
J21406 | Text | JSI 2000 2.5" X 14" | 6-0-0 | 2
J21409 | Text | JSI 2000 2.5" X 14" | 9-0-0 | 1
J21410 | Text | JSI 2000 2.5" X 14" | 10-0-0 | 2 |  | <=This is not in Jsts1
J21416 | Text | JSI 2000 2.5" X 14" | 16-0-0 | 1
J21405 | Text | JSI 2000 2.5" X 14" | 5-0-0 | 1
J21406 | Text | JSI 2000 2.5" X 14" | 6-0-0 | 3
J21407 | Text | JSI 2000 2.5" X 14" | 7-0-0 | 7 |  | <=Jst1 is 6
J21409 | Text | JSI 2000 2.5" X 14" | 9-0-0 | 6
J21413 | Text | JSI 2000 2.5" X 14" | 13-0-0 | 5
J21415 | Text | JSI 2000 2.5" X 14" | 15-0-0 | 3
J21416 | Text | JSI 2000 2.5" X 14" | 16-0-0 | 5
J21417 | Text | JSI 2000 2.5" X 14" | 17-0-0 | 7
[NAME] |  | JSI 2000 2.5" X 14" | 2008-01-02 00:00:00 | 4 |  | These Total 15 on [NAME]
[NAME] |  | JSI 2000 2.5" X 14" | 2000-01-03 00:00:00 | 1
[NAME] |  | JSI 2000 2.5" X 14" | 2004-01-07 00:00:00 | 7 |  | These have no text in column B
[NAME] |  | JSI 2000 2.5" X 14" | 2004-01-08 00:00:00 | 1
[NAME] |  | JSI 2000 2.5" X 14" | 2009-01-09 00:00:00 | 1
J21403 |  | JSI 2000 2.5" X 14" | 2004-02-03 00:00:00 | 1 |  | <=these total 1 in Jsts1
J21403 |  | JSI 2000 2.5" X 14" | 2004-02-04 00:00:00 | 2
J21403 |  | JSI 2000 2.5" X 14" | 2004-02-05 00:00:00 | 3
Spreadsheet: 773658d1647980326-auotfill-a-calendar-of-sorts-with-the-number-of-days-per-month-based-on-a-specific-range-test-book
Sheet: Sheet1

 |  |  |  |  |  | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00
 |  |  |  |  |  | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00 | 2023-01-31 00:00:00 | 2023-02-28 00:00:00
Periods OOS | Period 1 Start Date | Period 1 End | Period 2 Start | Period 2 end |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sum
0
1 | 2022-07-11 17:47:00.816000 | 2022-07-18 00:00:00
0
1 | 2022-04-17 13:32:45.644000 | 2022-05-30 00:00:00
2 | 2022-03-10 01:49:05.226000 | 2022-05-09 00:00:00 | 2022-09-07 00:00:00 | 2022-11-17 00:00:00 |  |  | 21 | 30 | 9 |  |  |  | 23 | 31 | 17
0 |  |  |  |  |  |  | 15
1 | 2022-07-30 08:48:23.025000 | 2022-08-11 00:00:00 |  |  |  |  |  |  |  |  | 1 | 11
Spreadsheet: 726735d1617390874-convert-text-days-hours-minutes-to-total-hours-019-get-day-hour-minute-second-from-text
Sheet: Get HMS (1)

1. Find position of Days, Hours, Minutes, Seconds with Search |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | i |  |  | ard
1. หาตำแหน่งของคำ Days, Hours, Minutes, Seconds ด้วย Search
Data | Day | Hour | Minute | Second | D | H | M | Se | D | H | M | Se
2 Days 2 Hours 3 Minutes 40 Seconds
1 Day 20 Hours 5 Minutes
1 Hour 5 Minutes
10 hours 1 seconds
25 Minutes 50 seconds
2 Days 5 seconds
10 Days
 | B5 =SEARCH(B$4,$A5)
 | Number are position of each word, #[NAME]! are no word in data
 | ตัวเลขคือตำแหน่งของคำในข้อความ #[NAME]! คือไม่มีคำนั้นๆในข้อความ
 |  | F5 =SEARCH(F$4,$A5)
 |  | Use each initial of each words that are unique except for [NAME] for Second
 |  | Instead for full word to shorten the formula
 |  | [NAME]
 |  | แทนทั้งคำเพื่อให้สูตรสั้นลง
 |  |  |  |  |  |  | [NAME]")
 |  |  |  |  |  |  | Add "dhmse" to data to avoid error when no word from data
 |  |  |  |  |  |  | เติม "dhmse" ท้ายคำเพื่อไม่ให้เกิด Error เมื่อหาคำไม่เจอ
Spreadsheet: 151663d1335048925-how-can-i-find-the-equation-of-the-linear-trend-using-excel-not-graph-classeur1
Sheet: Feuil1

Month | Value
1 | 250
2 | 450
3 | 576
4 | 678
5 | 763 |  |  |  |  |  |  | How can I find y = 151.13x + 64.9 using excel formula?
6 | 809
7 | 945
8 | 1200
9 | 1456
10 | 1676
11 | 1879
12 | 1982
13 | 2040
14 | 2180
15 | 2243
16 | 2465
Spreadsheet: 875667d1722276219-complex-let-vstack-filter-sort-choosecols-formula-example-001
Sheet: HybridDays

Period
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P
Bhama, [NAME] | NP | Active | 3 | 6 | 20 | Yes | WA | Yes |  | 2024-02-29 00:00:00 |  | HybridDays | 187.5 | 233.9800000000003 | 697.2
Alphonse, [NAME] | PA | Active | 1 | 3 | 20 | Yes | WA | Yes |  | 2023-02-27 00:00:00 |  | HybridDays | 93.75 | 85.78000000000016 | 0
Spreadsheet: kevin_presto__19967__power
Sheet: Original List

 |  | East Power
 |  | [NAME] | [NAME]
 | Hourly | Scheduling | Fundamentals | Fundamentals IT | Clerical | Genco | EES | Gen Investment | Origination
 | [NAME] | [NAME] | [NAME] | Madhup Kumar | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | [NAME] | Ashish Mahajan | [NAME] | [NAME] | TJ Black | [NAME] | Berney Aucion | [NAME] | [NAME]
 | [NAME] | [NAME] | [NAME] | [NAME] | Claudia Guerra | [NAME] | Edith Cross | [NAME] | [NAME]
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Punit Rawal | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Lex Carroll
 | Brant Reeves | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Narsima Misra | [NAME] | [NAME]
 |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Amie Ha | [NAME] | [NAME] | [NAME]
 | [NAME] | [NAME] | [NAME] | [NAME] | Pauletta Olvera |  | Clarisa Cooper | [NAME] | [NAME]
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] | [NAME] | [NAME]
 | [NAME] |  | [NAME] | [NAME] | [NAME] |  | [NAME] | [NAME] | [NAME]
 | [NAME] |  | [NAME] | [NAME] |  |  | [NAME] | [NAME] | [NAME]
 | [NAME] |  | [NAME] | [NAME] |  |  | [NAME] | [NAME] | [NAME]
 | [NAME] |  | [NAME] |  | Projects |  | [NAME] | [NAME] | [NAME]
 |  |  | [NAME] |  |  |  | [NAME] | [NAME] | Maximillion Sell
 | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] | [NAME] | [NAME]
 | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] | [NAME] | [NAME]
 | [NAME] |  |  |  |  |  | [NAME] | [NAME] | [NAME]
 | [NAME] |  | [NAME] |  |  |  | [NAME] | [NAME] | [NAME]
 | [NAME] Seely |  | [NAME] |  |  |  | [NAME] | [NAME] | [NAME]
 | [NAME] |  | [NAME] |  |  |  |  | [NAME] | Regan Rorshach
 | [NAME] |  |  |  |  |  |  | [NAME] | [NAME]
 | [NAME] |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  |  | [NAME] | [NAME]
 | [NAME] |  |  |  |  |  |  | [NAME] | [NAME]
 | [NAME] |  |  |  |  |  |  | [NAME] | [NAME]
 | [NAME] |  |  |  |  |  |  | [NAME] | Suzette Emmons
 | [NAME] |  |  |  |  |  |  | [NAME] | Amanda Day
 | [NAME] |  |  |  |  |  |  | [NAME] | [NAME]
 | [NAME] |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  | Terrell Berkes
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
 | Midwest | North East | Southeast | [NAME] | Options | Services | [NAME] | Structuring
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | [NAME] | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  | [NAME] |  |  | [NAME] | Smith Day | [NAME] | [NAME]
 |  | [NAME] |  |  | [NAME] | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  | [NAME] | [NAME] | Nick Hiemstra
 |  |  |  |  |  | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  | Utku Gulmeden | [NAME] | [NAME]
 |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]