tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 694052d1599317674-how-to-apply-filter-formula-for-multiple-conditions-copy-of-processing-efficiency-akshay6s-
Sheet: WEEKLY DATA

 |  |  | SS LOOMTEX |  |  |  |  |  |  |  |  |  |  |  |  | SINGHANIA FINISHERS |  |  |  |  |  |  | SINGHANIA FINISHERS
 |  | PARTY NAME | PROCESS | [NAME] | KGS SENT |  |  |  | PARTY NAME | PROCESS | METER RECEIVED | KGS RECEIVED |  |  |  | PARTY NAME | PROCESS | [NAME] | KGS SENT |  |  |  | PARTY NAME | PROCESS | METER RECEIVED | KGS RECEIVED
2020-06-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-06-19 00:00:00 |  |  |  |  |  |  | 2020-06-19 00:00:00
2020-06-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-06-26 00:00:00 |  |  |  |  |  |  | 2020-06-26 00:00:00
2020-06-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-06-27 00:00:00 |  |  |  |  |  |  | 2020-06-27 00:00:00
2020-07-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-07-04 00:00:00 |  |  |  |  |  |  | 2020-07-04 00:00:00
2020-07-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-07-05 00:00:00 |  |  |  |  |  |  | 2020-07-05 00:00:00
2020-07-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-07-12 00:00:00 |  |  |  |  |  |  | 2020-07-12 00:00:00
2020-07-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-07-13 00:00:00 |  |  |  |  |  |  | 2020-07-13 00:00:00
2020-07-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-07-20 00:00:00 |  |  |  |  |  |  | 2020-07-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-07-21 00:00:00 |  |  |  |  |  |  | 2020-07-21 00:00:00
2020-07-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-07-28 00:00:00 |  |  |  |  |  |  | 2020-07-28 00:00:00
2020-07-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-07-29 00:00:00 |  |  |  |  |  |  | 2020-07-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-08-05 00:00:00 |  |  |  |  |  |  | 2020-08-05 00:00:00
2020-07-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-08-06 00:00:00 |  |  |  |  |  |  | 2020-08-06 00:00:00
2020-08-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-08-13 00:00:00 |  |  |  |  |  |  | 2020-08-13 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-08-14 00:00:00 |  |  |  |  |  |  | 2020-08-14 00:00:00
2020-08-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-08-21 00:00:00 |  |  |  |  |  |  | 2020-08-21 00:00:00
2020-08-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-08-22 00:00:00 |  |  |  |  |  |  | 2020-08-22 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-08-29 00:00:00 |  |  |  |  |  |  | 2020-08-29 00:00:00
2020-08-14 00:00:00
2020-08-21 00:00:00
2020-08-22 00:00:00
2020-08-29 00:00:00
Spreadsheet: 15bc531d-03be-46c2-abc5-b99437f1500a
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0000485 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Rose Hill Processing Facility | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Duplin | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050
Day | ORC Arrival Time | ORC Time On Site | Flow
 | 24-hr | hrs | GPD
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder
Monthly Limit: |  |  | 300000
Daily Limit:
Sample Frequency: |  |  | [NAME]
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: 42812d1241463930-vlookup-and-lookup-1-
Sheet: Sheet1

 | Hole | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
Mark |  | 5 |  |  |  |  |  |  |  |  |  |  |  | Key2 | Key1 | A Player | Hole | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Par
 |  |  |  |  |  |  |  |  |  |  |  |  |  | MarkGross | Mark | Mark | Gross | 4 | 5 | 6 | 4 | 5 | 6 | 4 | 5 | 6 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  | MarkNet | Mark |  | Net | 4 | 5 | 6 | 4 | 5 | 6 | 4 | 5 | 6 | 36
 | Need to enter the NET score using from O5 - Y5 |  |  |  |  |  |  |  |  |  |  |  |  | PaulGross | [NAME] | [NAME] | Gross | 7 | 8 | 9 | 7 | 8 | 9 | 7 | 8 | 9 | 39
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PaulNet | [NAME] |  | Net | 6 | 7 | 8 | 6 | 7 | 8 | 6 | 7 | 8 | 38
Spreadsheet: 74692d1275218863-transfering-data-between-workbooks-transferring-data-example2
Sheet: Sheet 1

 |  |  |  | Monthly Volume
 | Customer Part Number | Location | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | 123AAA | SanMex | 2342 | 1234 | 678 | 732 | 786 | 840 | 894 | 948 | 1002 | 1056 | 1110 | 1164
 | 123BBB | Findlay | 2578 | 1456 | 2156 | 2856 | 3556 | 4256 | 4956 | 5656 | 6356 | 7056 | 7756 | 8456
 | 123CCC | MtVernon | 3451 | 2321 | 678 | 763 | 848 | 933 | 1018 | 1103 | 1188 | 1273 | 1358 | 1443
 | 123AA1 | SanMex | 12000000
 | 123AA2 | SanMex
 | 123AA3 | SanMex
 | 123AA4 | SanMex
 | 123AA5 | SanMex
 | 123AA6 | SanMex
 | 123AA7 | SanMex
 | 123AA8 | SanMex
 | 123AA9 | SanMex
 | 123AA10 | SanMex
 | 123AA11 | SanMex
 | 123AA12 | SanMex
 | 123AA13 | SanMex
 | 123AA14 | SanMex
 | 123AA15 | SanMex
 | 123AA16 | SanMex
 | 123AA17 | SanMex
 | 123AA18 | SanMex
 | 123AA19 | SanMex
 | 123AA20 | SanMex
 | 123AA21 | SanMex
 | 123AA22 | SanMex
 | 123AA23 | SanMex
 | 123AA24 | SanMex
 | 123AA25 | SanMex
Spreadsheet: f03a1940-8f6e-49c9-91c2-09de5931df54
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Energiforsyning
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Alta Kraftlag SA |  | 9550 | Øksfjord | 78 45 09 00 | 78 45 09 10
Alta Kraftlag SA |  | 9161 | Burfjord | 78 45 09 00 | 77 76 83 36
Andmyran Vindpark AS |  | 8484 | Risøyhamn
Arctic Wind AS |  | 9690 | Havøysund | 950 75 568
[NAME] |  | 8110 | Moldjord | 75 56 82 73
[NAME] |  | 8264 | Engan | 971 73 968
BE Kraftsalg AS | Jernbaneveien 85 | 8006 | Bodø | 75 54 51 50
[NAME] | [NAME] 8 | 8226 | Straumen
[NAME] | Bjørkåsveien 69 | 8540 | Ballangen
Barents Naturgass AS | Sjøgata 6 | 9600 | Hammerfest | 78 40 62 00
Be Nett AS |  | 8110 | Moldjord
Be Nett AS |  | 8120 | Nygårdsjøen
Be Nett AS |  | 8135 | Sørarnøy
Be Nett AS |  | 8140 | Inndyr
Beiarkraft AS | Os | 8110 | Moldjord | 901 66 254
Bindal [NAME] |  | 7980 | Terråk | 75 03 19 00 | 75 03 19 10
Bodø Energi AS |  | 8100 | Misvær
Bordvedåga Kraft AS | [NAME] 70 | 8626 | Mo i Rana
[NAME] | Lodve Langesgate 2 | 8514 | Narvik
Brattland Kraft AS | Skjerperveien 6 | 8630 | [NAME] | 75 16 01 49
Brattland Øyvind | Skjerperveien 6 | 8630 | [NAME] | 990 07 668
Burfjord montørstasjon |  | 9161 | Burfjord | 77 76 82 56
Censu Trading AS | Strandgata 22 | 8656 | Mosjøen | 75 17 55 11
Durmålskraft AS | Korgen | 8646 | Korgen
Engan Minikraft DA | Sjonhagenveien 115 | 8725 | Utskarpen | 957 26 622
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 455727d1460475157-storage-tank-formula-issues-new-gallons_-barrels-strapping-chart-test-2-
Sheet: S1

 |  |  |  |  |  |  |  | STRAPPING TABLE |  |  |  |  |  |  |  | JOB REFERENCE #
 |  |  |  |  |  |  | FRACTIONS 1/16 (INCHES)
 |  |  | 1/16 |  | 3/16 |  | 5/16 |  | 7/16 |  | 9/16 |  | 11/16 |  | 13/16 |  | 15/16
 |  |  | 1/8 |  | 1/4 |  | 3/8 |  | 1/2 |  | 5/8 |  | 3/4 |  | 7/8 |  | 1
 | NAME PLATE INFORMATION |  |  |  |  | [NAME] |  |  |  | FT. |  | IN. |  | DECIMAL |  | NOMINAL/GALLONS |  |  |  | VOLUME
 | YEAR TANK BUILT |  |  |  |  | TANK SHELL HEIGHT |  |  |  |  |  |  |  |  |  | BOTTOM TO SHELL
 | MANUFACTER |  |  |  |  | DIAMTER OF TANK |  |  |  |  |  |  |  |  |  | CONE DEPTH BELOW 0'-0"
 | YEAR MODIFIED |  |  |  |  | HIGH LIQUID LEVEL
 | CLASSIFICATION |  |  |  |  | CONE DEPTH BELOW 0'-0" |  |  |  |  |  |  |  |  |  | SUMP RESIVOR/GALLONS
 | EDITION |  |  |  |  | CENTER COLUMN DIA. Φ |  |  |  |  |  |  |  |  |  |  |  | DEPTH
 | APPENDIX |  |  |  |  | INTERMEDIATE COLUMN Φ |  |  |  |  |  |  |  |  |  |  | FT. |  | FT.
 | MATERIAL (SHELL) |  |  |  |  | NUMBER OF COLUMNS |  |  |  |  |  |  |  |  |  |  | IN. |  | IN.
 | FT |  | FT |  | FT |  | FT |  | FT |  | FT |  | FT |  | FT |  | FT |  | FT
 | IN |  | IN |  | IN |  | IN |  | IN |  | IN |  | IN |  | IN |  | IN |  | IN
 | 0 |  | 2 |  | 4 |  | 6 |  | 8 |  | 10 |  | 12 |  | 14 |  | 16 |  | 18
 | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1
 | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2
 | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3
 | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
 | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5
 | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6
 | 7 |  | 7 |  | 7 |  | 7 |  | 7 |  | 7 |  | 7 |  | 7 |  | 7 |  | 7
 | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8
 | 9 |  | 9 |  | 9 |  | 9 |  | 9 |  | 9 |  | 9 |  | 9 |  | 9 |  | 9
 | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10
 | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11
 | 1 |  | 3 |  | 5 |  | 7 |  | 9 |  | 11 |  | 13 |  | 15 |  | 17 |  | 19
 | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1
 | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2
 | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3
 | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
 | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5
 | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6
 | 7 |  | 7 |  | 7 |  | 7 |  | 7 |  | 7 |  | 7 |  | 7 |  | 7 |  | 7
 | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8
 | 9 |  | 9 |  | 9 |  | 9 |  | 9 |  | 9 |  | 9 |  | 9 |  | 9 |  | 9
 | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10
 | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11
Spreadsheet: darrell_schoolcraft__7445__imball0202
Sheet: crosstex

Crosstexx Energy Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
 | contr 21571 - poi 56935 |  | contr 23994 - poi 58444
 | Integrated Services DP |  | I.S.I. Farm Tap- [NAME]
 | Measured | Scheduled | Measured | Scheduled
1 | -2410 | -3699 | -2210 | -2000
2 | -2402 | -3699 | -18 | -2000
3 | -877 | -3699 | -674 | -2000
4 | -2234 | -3699 | -2562 | -2000
5 | -2475 | -3699 | -2615 | -2000
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
index
2002-01-31 00:00:00 |  |  |  |  | -117510.28 |  | 713.49
2002-02-05 00:00:00
CBS Volume |  |  |  |  |  |  | 2808
 |  |  | -35775
Spreadsheet: 167847d1342118684-payroll-calculations-using-a-sortable-table-sample_payroll
Sheet: Sheet1

Employee | Rate | Date | Start Time | End Time | Payouts | Hours | Grand Total
[NAME] | 10 | 2012-06-29 00:00:00 | 09:00:00 | 17:00:00 | 0 |  |  |  |  | Row Labels | Sum of Hours
[NAME] | 10 | 2012-06-30 00:00:00 | 09:00:00 | 13:00:00 | 0 |  |  |  |  | Sophia R | 48
[NAME] | 10 | 2012-07-01 00:00:00 | 00:00:00 | 00:00:00 | 0 |  |  |  |  | Jun | 16
[NAME] | 10 | 2012-07-01 00:00:00 | 16:00:00 | 20:00:00 | 0 |  |  |  |  | Jul | 32
[NAME] | 10 | 2012-07-02 00:00:00 | 09:00:00 | 17:00:00 | 0 |  |  |  |  | [NAME] | 48
[NAME] | 10 | 2012-07-03 00:00:00 | 09:00:00 | 17:00:00 | 0 |  |  |  |  | Jun | 12
[NAME] | 10 | 2012-07-04 00:00:00 | 09:00:00 | 17:00:00 | 0 |  |  |  |  | Jul | 36
[NAME] | 10 | 2012-07-05 00:00:00 | 09:00:00 | 17:00:00 | 0 |  |  |  |  | Grand Total | 96
Sophia R | 9.5 | 2012-06-29 00:00:00 | 09:00:00 | 17:00:00 | 0
Sophia R | 9.5 | 2012-06-30 00:00:00 | 09:00:00 | 17:00:00 | 0
Sophia R | 9.5 | 2012-07-01 00:00:00 | 09:00:00 | 17:00:00 | 0
Sophia R | 9.5 | 2012-07-02 00:00:00 | 09:00:00 | 17:00:00 | 0
Sophia R | 9.5 | 2012-07-03 00:00:00 | 09:00:00 | 17:00:00 | 0
Sophia R | 9.5 | 2012-07-04 00:00:00 | 00:00:00 | 00:00:00 | 0
Sophia R | 9.5 | 2012-07-05 00:00:00 | 09:00:00 | 17:00:00 | 0
Spreadsheet: 08549b2d-fe76-4a40-9a32-046cb6ed58b8
Sheet: Sheet1

Commercial Construction Permits | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 | Entries made in the last 7 day(s)
Permit |  | Permit Type |  |  | Date Recorded | [NAME] | Job Address | Project |  | Contractor |  | Est Value
13-2293 |  | Commercial Building Shell |  |  | 2014-09-08 00:00:00 |  | 611 LOVELL RD KNOXVILLE 37932 | SPEEDWAY CONVENIENCE STORE |  | Shaub Construction Company, Inc. |  | 475000
14-2470 |  | Commercial Interior |  |  | 2014-09-08 00:00:00 | 014 | 7436 CORRYTON RD CORRYTON TN 37721 | TINY TOTS DAYCARE |  | [NAME] |  | 500
14-2525 |  | Church |  |  | 2014-09-09 00:00:00 | 062 | 8310 ASHEVILLE HWY KNOXVILLE TN 37924 | DELIVERANCE MINISTRIES WORSHIP CENTER |  | [NAME], Deliverance Ministries |  | 500
14-2523 |  | Commercial Interior |  |  | 2014-09-09 00:00:00 | 089 | 8909 OAK RIDGE HWY KNOXVILLE TN 37931 | D &B HOT DOGS & ICE CREAM |  | [NAME] |  | 500
14-2241 |  | Commercial Interior |  |  | 2014-09-10 00:00:00 | 103 | 2043 CASTAIC LN KNOXVILLE TN 37932 | EDWARD JONES FINANCIAL |  | Tillman Companies, Llc |  | 45000
13-1766 |  | Public Works |  |  | 2014-09-10 00:00:00 |  | 527 #C LOVELL RD KNOXVILLE 37932 | US CELLULAR TURKEY CREEK SITE COLOCATION |  | Capital Tower & Communications, Inc. |  | 25000
13-1769 |  | Public Works |  |  | 2014-09-10 00:00:00 |  | 1336 #A AMBURN LN [NAME] 37923 | US CELLULAR EAGLES POINT SITE COLOCATION |  | Capital Tower & Communications, Inc. |  | 25000
14-2533 |  | Commercial Addition |  |  | 2014-09-11 00:00:00 | 067 | 6609 BRONCO LN [NAME] 37921 | [NAME], INC LEAN-TO ADDITION |  | [NAME] |  | 4000
14-2404 |  | Commercial Accessory Structure |  |  | 2014-09-11 00:00:00 | 026 | 908 E RACCOON VALLEY DR HEISKELL TN 37754 | RACCOON VALLEY RV PARK PERGOLA |  | Escapees Inc., Dba Raccoon Valley Rv Park |  | 1500
14-2445 |  | Commercial Interior |  |  | 2014-09-11 00:00:00 | 103 | 10629 HARDIN VALLEY RD KNOXVILLE 37932 | THE UPS STORE |  | [NAME], Inc. |  | 10000
 | Total |  | 10 |  |  |  |  |  |  | Sum | 587000
Spreadsheet: 850797d1701159156-time-difference-incorrect-values-timestamp_capture_wrong
Sheet: Sheet1

Alm. Time | Ack. Time | Res. Time | Ack Time (in Mins) | Res. Time (in Mins) | Intended Values in Alm Time - Field
2023-10-01 10:00:00 | 2023-10-01 10:05:00 | 2023-10-01 10:45:00 |  |  | No Changes
2023-10-01 00:54:00 | 2023-10-01 00:56:00 | Open |  |  | No Changes
2023-09-30 23:27:00 | 2023-09-30 23:29:00 | 2023-09-30 23:38:00 |  |  | No Changes
2023-10-01 12:54:00 | 2023-10-01 12:55:00 | 2023-10-01 13:30:00 |  |  | No Changes
2023-10-01 05:00:00 | 2023-10-01 05:06:00 | 2023-10-01 05:27:00 |  |  | 6
2023-10-01 07:31:00 | 2023-10-01 07:35:00 | 2023-10-01 07:50:00 |  |  | No Changes
2023-10-01 09:14:00 | 2023-10-01 09:15:00 | 2023-10-01 09:24:00 |  |  | No Changes
2023-10-01 12:45:00 | 2023-10-01 12:48:00 | 2023-10-01 13:40:00 |  |  | 3
2023-10-01 11:48:00 | 2023-10-01 11:48:00 | Open |  |  | No Changes
2023-10-01 12:12:00 | 2023-10-01 12:12:00 | Open |  |  | No Changes
2023-11-26 20:25:00 | 2023-11-26 20:30:00 | 2023-11-26 20:38:00 |  |  | 5
2023-11-26 18:25:00 | 2023-11-26 18:29:00 | 2023-11-26 18:35:00 |  |  | No Changes
2023-11-27 00:28:00 | 2023-11-27 00:32:00 | Open |  |  | No Changes
2023-11-26 22:03:00 | 2023-11-26 22:05:00 | Open |  |  | No Changes
2023-11-27 00:30:00 | 2023-11-27 00:35:00 | 2023-11-27 02:00:00 |  |  | 5
2023-11-27 02:53:00 | 2023-11-27 02:55:00 | Open |  |  | No Changes
2023-11-26 23:56:00 | 2023-11-27 00:00:00 | Open |  |  | No Changes
2023-11-27 19:51:00 | 2023-11-27 19:55:00 | Open |  |  | No Changes
2023-11-27 03:45:00 | 2023-11-27 03:48:00 | Open |  |  | 3
2023-11-27 04:25:00 | 2023-11-27 04:27:00 | 2023-11-27 04:40:00 |  |  | 2
NA | NA | NA |  |  | No Changes
2023-11-27 19:21:00 | 2023-11-27 19:23:00 | 2023-11-27 20:29:00 |  |  | 2
Spreadsheet: 116709d1312039781-sumproduct-match-index-absence-2-
Sheet: Sheet1

Absence Data |  |  |  |  |  | Current Employees
Employee Number | Duration | Start date | End Date | Occurence |  | Employee | Monitor Start Date | Monitor End Date | 2 Occurences trigger end date | 4 or more days trigger end date
7776 | 1 | 2011-02-01 00:00:00 | 2011-02-01 00:00:00 | 1 |  | 7776 | 2011-01-01 00:00:00 | 2011-03-31 00:00:00 | 2011-02-01 00:00:00 | #N/A
7776 | 2 | 2011-02-07 00:00:00 | 2011-02-08 00:00:00 | 2 |  | 7777 | 2011-03-01 00:00:00 | 2011-05-31 00:00:00 | #N/A | 2011-05-09 00:00:00
7777 | 5 | 2011-05-03 00:00:00 | 2011-05-09 00:00:00 | 1 |  | 7778 |  |  | #N/A | #N/A
7778 | 2 | 2011-05-03 00:00:00 | 2011-05-04 00:00:00 | 1 |  | 7779 |  |  | #N/A | #N/A
7779 | 2 | 2011-02-01 00:00:00 | 2011-02-02 00:00:00 | 1 |  | 7780 | 2011-04-01 00:00:00 | 2011-06-30 00:00:00 | #N/A | #N/A
7779 | 2 | 2011-02-03 00:00:00 | 2011-02-04 00:00:00 | 2 |  | 7781 |  |  | #N/A | #N/A
7779 | 3 | 2011-02-05 00:00:00 | 2011-02-09 00:00:00 | 3 |  | 7782 |  |  | #N/A | #N/A
7780 | 2 | 2011-05-03 00:00:00 | 2011-05-04 00:00:00 | 1 |  | 7784 |  |  | #N/A | #N/A
7781 | 5 | 2011-06-06 00:00:00 | 2011-06-12 00:00:00 | 1 |  | 7785 | 2011-01-01 00:00:00 | 2011-03-01 00:00:00 | 2011-02-04 00:00:00 | #N/A
7781 | 14 | 2011-06-13 00:00:00 | 2011-06-30 00:00:00 | 2 |  | 7786 | 2011-01-01 00:00:00 | 2011-05-30 00:00:00 | 2011-02-07 00:00:00 | #N/A
7782 | 2 | 2011-05-03 00:00:00 | 2011-05-04 00:00:00 | 1
7783 | 2 | 2011-05-03 00:00:00 | 2011-05-04 00:00:00 | 1
7784 | 7 | 2011-06-02 00:00:00 | 2011-06-10 00:00:00 | 1
7784 | 4 | 2011-06-11 00:00:00 | 2011-06-16 00:00:00 | 2
7784 | 9 | 2011-06-20 00:00:00 | 2011-06-30 00:00:00 | 3
7785 | 2 | 2011-02-01 00:00:00 | 2011-02-02 00:00:00 | 1 |  |  |  |  | Note:
7785 | 2 | 2011-02-03 00:00:00 | 2011-02-04 00:00:00 | 2 |  |  |  |  | Array formula is used and should be confirmed through Ctrl+Shift+Enter
7785 | 1 | 2011-02-06 00:00:00 | 2011-02-07 00:00:00 | 3 |  |  |  |  | Use a formula to display blank if there is error above i.e. #[NAME]!
7786 | 2 | 2010-12-12 00:00:00 | 2010-12-14 00:00:00 | 1
7786 | 1 | 2011-02-06 00:00:00 | 2011-02-07 00:00:00 | 2
7786 | 2 | 2011-05-06 00:00:00 | 2011-05-09 00:00:00 | 3
Spreadsheet: 45735d1244553282-nesting-vlookup-in-if-vice-versa-and-pivot-table-copy-of-sample3
Sheet: Feb Summary

 | Amount-Cat1 | Amount-Cat2
500 | -174.29 | 245.7489
750 | -2467.829620000004 | 3545.287138440006
900 | -2669.357555600005 | 4615.853085143529
AB | -1443.1102088 | 2284.12306358496
AG | -63.58996399999999 | 109.9597657488
AN | -1797.5294 | 3108.28783848
AD | -53.8898 | 75.984618
AL | -1523.33 | 2147.8953
BX | -8842.635900000001 | 13995.92940228
BZ | -7039.132799999999 | 11141.38440576
CA | -4014.1539 | 6353.51440788
CB | -877.04125 | 1388.1615795
DE | -1471.4364
DV | -4460.2879
DX | -3484.0798
DF |  | 1143.86391
DS |  | 910.56672
FA |  | 519.2621099999999
GL | -2868.781915198807 | 4044.982500430317
GM | -221.0269653693443 | 311.6480211707755
MF | -1646.582489341475 | 2606.174509102399
MR | -20226.46215053684 | 32013.99893857465
OA | -715.5376707607675 | 1132.537270322255
OB | -268.7207781562057 | 425.3253308778663
OR | -337.5699915762351 | 534.2983499331054
RA | -565.1764208362113 | 977.3030669099766
RF | -10622.17550350159 | 18367.86588065495
TM | -61.21638142096588 | 105.8553667531342
ZP | -591.955380684333 | 936.9339426672207
Spreadsheet: 869481d1716039985-auto-populate-crop-logs-template
Sheet: Data

Cultivars | Pinch | 1st Touch | 1st Touch | 1st Touch | 1st Touch | 2nd Touch | 2nd Touch | 2nd Touch | 2nd Touch | 3rd Touch | 3rd Touch | 3rd Touch | 4th Touch | 4th Touch | 4th Touch | 4th Touch | 4th Touch | 4th Touch | 5th Touch | 5th Touch | 5th Touch | 5th Touch | Final Defol | Final Defol | Final Defol | Final Defol | Final Defol | Final Defol
Black Jelly |  | 7 | 8 |  |  | 14 | 15 |  |  | 24 | 25 |  |  |  |  |  |  |  |  |  |  |  | 40 | 41
Cosmic Cream |  | 7 | 8 |  |  | 14 | 15 |  |  | 24 | 25 |  |  |  |  |  |  |  |  |  |  |  | 39 | 40
[NAME] |  | 7 | 8 |  |  | 14 | 15 |  |  | 24 | 25 |  |  |  |  |  |  |  |  |  |  |  | 37 | 38
[NAME] |  | 7 | 8 |  |  | 14 | 15 |  |  | 24 | 25 |  |  |  |  |  |  |  |  |  |  |  | 40 | 41
Equiposa | 6 | 7 | 8 |  |  | 14 | 15 |  |  | 24 | 25 |  |  |  |  |  |  |  |  |  |  |  | 41 | 42
Farm Gas | 6 | 11 | 12 | 13 | 14 | 16 | 17 | 18 | 19 | 24 | 25 | 26 | 29 | 30 | 31 | 32 | 33 | 34 | 39 | 40 | 41 | 42 | 46 | 47 | 48 | 49 | 50 | 51
Luminarium |  | 10 | 11 |  |  | 17 | 18 |  |  | 27 | 28 |  |  |  |  |  |  |  |  |  |  |  | 41 | 42
[NAME] |  | 7 | 8 |  |  | 14 | 15 |  |  | 24 | 25 |  |  |  |  |  |  |  |  |  |  |  | 40 | 41
OC23T382
OC23T418 | 6 | 11 | 12 | 13 | 14 | 16 | 17 | 18 | 19 | 24 | 25 | 26 | 29 | 30 | 31 | 32 | 33 | 34 | 39 | 40 | 41 | 42 | 46 | 47 | 48 | 49 | 50 | 51
OC23T549 | 6 | 11 | 12 | 13 | 14 | 16 | 17 | 18 | 19 | 24 | 25 | 26 | 29 | 30 | 31 | 32 | 33 | 34 | 39 | 40 | 41 | 42 | 46 | 47 | 48 | 49 | 50 | 51
Pink Diesel '71 |  | 7 | 8 |  |  | 14 | 15 |  |  | 24 | 25 |  |  |  |  |  |  |  |  |  |  |  | 41 | 42
Ponderosa Pine |  | 7 | 8 |  |  | 14 | 15 |  |  | 24 | 25 |  |  |  |  |  |  |  |  |  |  |  | 37 | 38
Rex |  | 7 | 8 |  |  | 14 | 15 |  |  | 24 | 25 |  |  |  |  |  |  |  |  |  |  |  | 34 | 35
Sedamen |  | 10 | 11 |  |  | 17 | 18 |  |  | 27 | 28 |  |  |  |  |  |  |  |  |  |  |  | 41 | 42
Sourdough | 6 | 11 | 12 | 13 | 14 | 16 | 17 | 18 | 19 | 24 | 25 | 26 | 29 | 30 | 31 | 32 | 33 | 34 | 39 | 40 | 41 | 42 | 46 | 47 | 48 | 49 | 50 | 51
Valour |  | 7 | 8 |  |  | 14 | 15 |  |  | 24 | 25 |  |  |  |  |  |  |  |  |  |  |  | 33 | 34
[NAME] |  | 7 | 8 |  |  | 14 | 15 |  |  | 24 | 25 |  |  |  |  |  |  |  |  |  |  |  | 31 | 32
Trials |  | 7 | 8 |  |  | 14 | 15 |  |  | 24 | 25 |  |  |  |  |  |  |  |  |  |  |  | 37 | 38 | 39 | 40 | 41 | 42
Placeholder #1 |  | 7 | 8 |  |  | 14 | 15 |  |  | 24 | 25 |  |  |  |  |  |  |  |  |  |  |  | 37 | 38 | 39 | 40 | 41 | 42
Placeholder #2 |  | 11 | 12 | 13 | 14 | 16 | 17 | 18 | 19 | 24 | 25 | 26 | 29 | 30 | 31 | 32 | 33 | 34 | 39 | 40 | 41 | 42 | 46 | 47 | 48 | 49 | 50 | 51
Placeholder #3 |  | 10 | 11 |  |  | 17 | 18 |  |  | 27 | 28 |  |  |  |  |  |  |  |  |  |  |  | 41 | 42
Spreadsheet: 775126d1648828469-formula-within-conditional-formatting-cf-for-gt-for-drewat
Sheet: Sheet1

 | Rate | Weekly | Raise | New Rate | New Weekly | Increase
Leeroy | 10 |  | 1
Jenkins | 11
bob | 5 |  |  | 7
[NAME] | 22 |  |  | 23
Spreadsheet: 668396d1584801737-ascending-order-first-column-contains-blank-cells-and-second-column-does-not-ascending-order
Sheet: Sheet1

Fruits | Apple |  |  |  | Car | Toyota
 | Mango |  |  |  |  | Nissan
 | [NAME] |  | Accending order> |  |  | Ford
Cars | Toyota |  |  |  | Car | Honda
 | Nissan |  | I want like this |  | Fruits | Apple
 | Ford |  | in red colour |  |  | Mango
Fruits | Pinapple |  | Without loosing |  |  | [NAME]
 | Grapes |  | blank cells |  | Fruits | Pinapple
 | Pear |  |  |  |  | Grapes
Cars | Honda |  |  |  |  | Pear
Spreadsheet: 134362d1325250908-lookup-one-value-in-a-range-and-then-lookup-another-value-beneath-it-extract-to-pivot
Sheet: Sheet2

[NAME] | Car Type | Number Sold | Unit Price | Total Sales
Barnhill | Sedan | 5 | 2200
 | Coupe | 4 | 1800 | 7200
Ingle | Sedan | 6 | 2300 | 13800
 | Coupe | 8 | 1700 | 13600
Jordan | Sedan | 3 | 2000 | 6000
 | Coupe | 1 | 1600 | 1600
Pica | Sedan | 9 | 2150 | 19350
 | Coupe | 5 | 1950 | 9750
Sanchez | Sedan | 6 | 2250 | 13500
 | Coupe | 8 | 2000 | 16000
 |  |  |  | #N/A