tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 85178ac3-8246-4be7-a00e-5cbe373acbb8
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Records | 80688892821 | Family Force 5 | Time Stands Still | 2014-08-05 | Compact Disc | Ac | 13.99 | Y | NYP
Word Records | 80688878627 | About A Mile | About A Mile | 2014-07-15 | Compact Disc | Ac | 7.99 | Y | NYP
Special Markets Product Rec | 80688889128 | [NAME] | Ultimate Collection, The | 2014-06-03 | Compact Disc | Ac | 9.99 | Y | NYP
Special Markets Product Rec | 80688889029 | Imperials | Ultimate Collection, The | 2014-06-03 | Compact Disc | Ac | 9.99 | Y | NYP
Curb Records | 715187934122 | [NAME] | Glory All Around | 2014-06-03 | Compact Disc | Ac | 13.99 | Y | NYP
Curb Records | 715187934023 | [NAME] | Work Of Love | 2014-06-03 | Compact Disc | Ac | 13.99 | Y | NYP
Special Markets Product Rec | 80688893828 | [NAME] | Ultimate Collection, The | 2014-07-15 | Compact Disc | Ac | 9.99 | Y | NYP
Special Markets Product Rec | 80688893729 | [NAME] | Ultimate Collection, The | 2014-07-15 | Compact Disc | Ac | 9.99 | Y | NYP
Special Markets Product Rec | 80688893927 | [NAME] | Beginnings | 2014-06-17 | Compact Disc | Ac | 7.99 | Y | NYP
Fervent Records | 80688876821 | [NAME] | If [NAME] | 2014-04-22 | Compact Disc | Ac | 13.99 | Y | Available
Special Markets Product Rec | 80688888121 | [NAME] | Beginnings | 2014-01-28 | Compact Disc | Ac | 9.99 | Y | Available
Atlantic-Elektra | 75678676925 | Needtobreathe | Rivers In The Wasteland | 2014-04-15 | Compact Disc | Ac | 13.99 | Y | Available
Special Markets Product Rec | 80688889623 | Various | New & #1 Radio Hits Of 2014 | 2014-04-22 | Compact Disc | Ac | 9.99 | Y | Available
Special Markets Product Rec | 80688889524 | [NAME] | Ultimate Collection: Volume 2, The | 2014-04-22 | Compact Disc | Ac | 11.99 | Y | Available
Fervent Records | 80688891220 | Big Daddy Weave | Love Come To Life: The Redeemed Edition | 2014-03-11 | Compact Disc | Ac | 13.99 | Y | Available
Special Markets Product Rec | 80688891428 | [NAME] | Hymns: 17 Timeless Songs Of Faith | 2014-03-11 | Compact Disc | Ac | 11.99 | Y | Available
Special Markets Product Rec | 80688891527 | Various | Glorious Morning: 10 Stirring Anthems Of The Risen Christ | 2014-03-11 | Compact Disc | Ac | 7.99 | Y | Available
Taseis | 893848002721 | [NAME] | You Alone | 2014-05-06 | Compact Disc | Black Gospel | 13.99 | Y | Available
Taseis | 14998420696 | Various | [NAME] Lxw (League Of Xtraordinary Worshippers) Music Dvd | 2014-04-22 | Music DVD | Na | 13.99 | Y | Available
Taseis | 14998420627 | Various | [NAME] Lxw (League Of Xtraordinary Worshippers) | 2014-04-22 | Compact Disc | Na | 13.99 | Y | Available
Fervent Records | 80688889821 | [NAME] | If We'Re Honest Deluxe Edition | 2014-04-22 | Compact Disc | Ac | 15.99 | Y | Available
Third Party Entity Merch | 602537735099 | Various | Son Of God: Original Motion Picture Soundtrack | 2014-03-19 | Compact Disc | Soundtrack | 12.99 | Y | Available
Spreadsheet: 182604d1348549404-sum-up-based-on-colour-conditions-help
Sheet: 1

Date | IN | OUT | Hours Worked | ADJUSTMENT
1 | 08:00:00 | 12:00:00
2 | 08:21:00 | 17:00:00 |  | -3.65
3 | UNPAID LEAVE |  |  | -58.33
4 | SUNDAY
5 | 08:00:00 | 22:00:00
6 | UNPAID LEAVE |  |  | -58.33
7 | 08:00:00 | 22:00:00
8 | 08:00:00 | 17:00:00
9 | 13:30:00 | 00:30:00 |  | -32.1
10 | 08:00:00 | 17:00:00 |  | 87.5
11 | SUNDAY
12 | 08:00:00 | 22:00:00
13 | 08:00:00 | 01:00:00
14 | 22:30:00 | 08:00:00 |  | -58.33
Spreadsheet: 870536d1717045086-list-up-the-sheet1-to-sheet2-depend-on-condition-list-pump-use-2-3-
Sheet: WORKER 2

 | payee : | worker 2
no | location | customer | Status | quantity
1 | JOHOR | GAN | CONTINUE USE
2 | JOHOR | CHEW | CONTINUE USE | 7
3 | MELAKA | [NAME] | CONTINUE USE | 8
5 | MELAKA | [NAME] | CONTINUE USE | 5
6 | MELAKA | TAI | DIRECT SELL
7 | MELAKA | YAU | CONTINUE USE | 3
Spreadsheet: 0b0e3664-3dd3-4453-b103-3c8292262b94
Sheet: Sheet1

Category 2 Centre Focal Point list
Name | Country | Institute | [NAME]
(Ms) [NAME] | China | World Heritage Institute for Training and Research in Asia and the Pacific (WHITR-AP) | [EMAIL]
(Ms) [NAME] | Norway | Nordic World Heritage Foundation (NWHF) | [EMAIL]
(Mr) [NAME] | South Africa | African World Heritage Fund (AWHF) | [EMAIL]
(Mr) [NAME] | Bahrain | Arab Regional Centre for World Heritage (ARC-WH) | [EMAIL]
(Mr) [NAME] | Mexico | Regional World Heritage Institute in Zacatecas | [EMAIL]
(Ms) [NAME] | Mexico | Regional World Heritage Institute in Zacatecas | [EMAIL]
(Mr) [NAME] | Italy | International Research Centre on the Economics of Culture and World Heritage Studies | [EMAIL]
(Mr) [NAME] | Brazil | Regional Heritage Management Training Centre "Lucio Costa" (IPHAN) | [EMAIL]
(Ms) [NAME] | Spain | International Centre for Rock Art and the World Heritage Convention | [EMAIL]
(Ms) [NAME] | Spain | International Centre for Rock Art and the World Heritage Convention | [EMAIL]
[NAME] | N/A | ICCROM | [EMAIL]
[NAME] | N/A | ICCROM | [EMAIL]
Regina Durighello | N/A | ICOMOS | [EMAIL]
[NAME] | N/A | IUCN | [EMAIL]
[NAME] | N/A | IUCN | [EMAIL]
Spreadsheet: 177346d1346269247-index-match-formula-copy-of-danafilms_actual_purchase_prices_july_2012
Sheet: Raw material prices

Danafilms: Raw material prices Budget 2013
Key | Material Number | Materialdescription | Price 2013 | July | June | May
 | 0 | M6010SBX03
 | 300000 | A B
 | 300004 | A B 50% ONLY
 | 300008 | AFC-1001
 | 300012 | BAOC-1000
 | 300013 | BASELL PB8640
 | 300015 | BI-113
 | 300017 | BLACK
 | 300020 | BUTENE
 | 300021 | 118-C ONLY
 | 300029 | BUTENE BRASKEM
 | 300030 | DC3203F
 | 300031 | DFLP REPRO
 | 300032 | D350
 | 300034 | ECM6.0701
 | 300035 | EF403AQ
 | 300037 | ET3803
 | 300038 | FL RETARDENT
 | 300040 | F171B
 | 300042 | H S WHITE REPRO
 | 300045 | HS BLACK REPRO
 | 300047 | H171B
 | 300049 | LD124 MS
 | 300054 | MAC-5000
 | 300057 | MLLDPE
 | 300061 | MT-5000
 | 300062 | NSC-0508
 | 300063 | NSC-0508P
 | 300064 | NX20
 | 300065 | OCTENE
 | 300072 | P A
 | 300073 | PB1600M
 | 300077 | PF1140G
 | 300078 | 3132 ONLY
 | 300081 | PL1840G
 | 300085 | PM2761E4 YELLOW
 | 300086 | PX3236
 | 300091 | SLIP SSC-0100
 | 300092 | SSC-0500LAM
 | 300096 | UE624000
 | 300098 | 4201
 | 300100 | BI-612 ONLY
 | 300103 | WHITE
 | 300110 | 1000
 | 300117 | 100977
 | 300118 | 1012CA
 | 300119 | 1012HA
 | 300122 | 12127 SILVER
 | 300123 | 12425 SILVER
 | 300124 | 13134 YELLOW
 | 300126 | 1400 REPRO
 | 300127 | 1400K REPRO
 | 300128 | 14052 ORANGE
 | 300131 | 15250A RED
 | 300132 | 1601-2 SURLYN
 | 300133 | 16180 BLUE
 | 300134 | 1652 SURLYN
 | 300135 | 1705 SURLYN
 | 300138 | 171322 GREEN
 | 300140 | 1800
 | 300145 | 19421 BLACK
 | 300149 | 20D752 APPEEL
 | 300150 | 20D828 APPEEL
 | 300151 | 2000
 | 300154 | 20082 GREEN
 | 300155 | 2010CE
 | 300158 | 2010HE
 | 300159 | 2042N
 | 300161 | 2400
 | 300162 | LD129.24
 | 300168 | 3G46
 | 300174 | 30E753
 | 300176 | 30705
 | 300177 | 3132
 | 300178 | 32258 RED
 | 300179 | 3371
 | 300181 | 34686 YELLOW
 | 300182 | 34726 BLUE
 | 300183 | 3600
 | 300192 | 41E710
 | 300193 | 41E755
 | 300194 | 4104
 | 300195 | 45D747
 | 300199 | 5L181 OLIVE
 | 300202 | 5033B
 | 300206 | 6420
 | 300212 | 7194
 | 300213 | 7194.3
 | 300215 | 7416XCP
 | 300216 | 7577587 BURGU
 | 300218 | 7740753 OD
 | 300219 | 7746253 GREEN
 | 300220 | 77467 BLUE
 | 300221 | 77593 GREY
 | 300222 | 77933 ORANGE
 | 300227 | 7860708 TAN
 | 300228 | 78912 PINK
 | 300229 | 79456 OLIVE
 | 300232 | 9000
 | 300234 | 9200
 | 300237 | 9400
 | 300239 | 9400KP
 | 300240 | 9400LL REPRO
 | 300241 | 9659
 | 300248 | UVC-0001LL-20
 | 300251 | ANTISTAT
 | 300254 | PF1140 OR 3132
 | 300256 | PM1346 FR ONLY
 | 300258 | SLIP
 | 300263 | 118-C NOVACOR
 | 300264 | 17009 TEAL
 | 300266 | 68244 WHT ONLY
 | 300267 | 141837 ORANGE
 | 300269 | 7860599 BROWN
 | 300270 | NA952000
 | 300271 | HPS167-AB
 | 300274 | HS8350
 | 300288 | ULTRA LOW
 | 300289 | UVI
Spreadsheet: 86209d1286236141-still-stuck-value-of-a-cell-in-a-different-location-best-date-to-sell
Sheet: Sheet1

date | bought price | my sell price | best date to sell
100701 | 2086 | 2190 | 100708
100702 | 2070 | 0 | 0
100703 | 2085 | 2189 | 100708
100704 | 2064 | 2167 | 100705
100705 | 2130 | 2236 | 100713
100706 | 2114 | 0 | 0
100707 | 2190 | 2300 | 100726
100708 | 2198 | 0 | 0
Spreadsheet: 389851d1429300606-count-issue-shifts18-4
Sheet: Data

Date | 2014 | Part Number | Budgeted Production Line |  |  |  |  |  | 0 | Shift 1 |  |  |  |  | 0 | Shift 2 |  |  |  |  | 1 | Shift 3
 |  |  |  |  |  |  |  |  | 0 | Pieces | Sched | Uptime |  | PPRM | 0 | Pieces | Sched | Uptime |  | PPRM | 0 | Pieces | Sched | Uptime |  | PPRM
 |  |  |  |  |  |  |  |  | 0 | Produced | Hours | Hours | Minute |  | 0 | Produced | Hours | Hours | Minute |  | 0 | Produced | Hours | Hours | Minute
Data | Week | Part Number | Line | Pieces produced | Same | Same2 | End date |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
2014-10-19 00:00:00 | 42 | 161 | 1 | 3537 |  | 3537 | 2014-10-19 00:00:00 |  | 1 | 3537 | 5 | 2 | 38 | 22.38607594936709 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2014-06-21 00:00:00 | 25 | 167 | 1 | 2565 |  | 2565 | 2014-06-22 00:00:00 | 1 | 1 | 1000 | 3 | 0 | 36 | 27.77777777777778 | 2 | 1565 | 3 | 0 | 54 | 28.98148148148148 | 0 | 0 | 0 | 0 | 0 | 0
2014-07-05 00:00:00 | 27 | 167 | 1 | 6276 |  | 6276 | 2014-07-06 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 6276 | 8 | 4 | 54 | 21.3469387755102 | 0 | 0 | 0 | 0 | 0 | 0
2014-07-09 00:00:00 | 28 | 167 | 1 | 3000 |  | 3000 | 2014-07-13 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3000 | 4 | 1 | 18 | 38.46153846153846
2014-07-10 00:00:00 | 28 | 167 | 1 | 3961 | A | 3961 | 2014-07-13 00:00:00 |  | 1 | 3961 | 3 | 2 | 24 | 27.50694444444444 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2014-07-12 00:00:00 | 28 | 167 | 1 | 3478 | A |  | 2014-07-13 00:00:00 | 1 | 1 | 2000 | 2.75 | 1 | 20 | 25 | 2 | 1478 | 2 | 0 | 42 | 35.19047619047619 | 0 | 0 | 0 | 0 | 0 | 0
2014-07-21 00:00:00 | 30 | 208 | 1 | 3058 |  | 3058 | 2014-07-27 00:00:00 | 1 | 1 | 3058 | 3.5 | 1 | 12 | 42.47222222222222 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2014-07-23 00:00:00 | 30 | 208 | 1 | 6623 | A | 6623 | 2014-07-27 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 6623 | 7.5 | 2 | 24 | 45.99305555555556
2014-07-24 00:00:00 | 30 | 208 | 1 | 1915 | A | 1915 | 2014-07-27 00:00:00 |  | 1 | 1915 | 2 | 0 | 48 | 39.89583333333334 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 25037d1216116378-formula-to-populate-cell-with-winning-team-name-book2-july14
Sheet: Sheet1

Team1 | Team2 | Team3 |  |  | High Scores | Teams
 |  |  |  |  | 10 | Team1
 |  |  |  |  | 10 | Team3
 |  |  |  |  | 5 | Team2
10 | 5 | 10
 | Draw
Team1 | Team2 | Team3
10 | 8 | 7
 | Team1
Spreadsheet: 271588d1381993355-an-award-wage-timesheet-calculator-wages-template-new-w-hours
Sheet: WAGES TEMPLATE

Week Ending: | #N/A
 | ENTER MON DATE |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A |  | #N/A |  |  | TIME PERIOD PAY RATE
 | 0 | 700 | 1900 | 2400 | 0 | 700 | 1900 | 2400 | 0 | 700 | 1900 | 2400 | 0 | 700 | 1900 | 2400 | 0 | 700 | 1900 | 0 | 0 | 2400 | 0 | 2400 |  | 0 | 700 | 1900 | 2400 | 0 | 700 | 1900 | 2400 | 0 | 2400 | 0 | 2400
 | 700 | 1900 | 2400 | 3100 | 700 | 1900 | 2400 | 3100 | 700 | 1900 | 2400 | 3100 | 700 | 1900 | 2400 | 3100 | 700 | 1900 | 2400 | 2400 | 2400 | 3100 | 2400 | 3100 |  | 700 | 1900 | 2400 | 3100 | 700 | 1900 | 2400 | 3100 | 2400 | 3100 | 2400 | 3100
 | 24.16 | 21.87 | 23.39 | 24.16 | 24.16 | 21.87 | 23.39 | 24.16 | 24.16 | 21.87 | 23.39 | 24.16 | 24.16 | 21.87 | 23.39 | 24.16 | 24.16 | 21.87 | 23.39 | 25.38 | 25.38 | 28.87 | 28.87 | 24.16 |  | 24.16 | 21.87 | 23.39 | 24.16 | 24.16 | 21.87 | 23.39 | 25.38 | 25.38 | 28.87 | 28.87 | 24.16
 | ENTER MON DATE |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A |  | #N/A |  |  | MONDAY TO THURSDAY |  |  |  | FRIDAY |  |  |  | SATURDAY |  | SUNDAY
NAME | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | SUNDAY | TOTAL |  | BREAKS
 |  |  |  |  |  |  |  |  |  | 0 | 700 |  | 30
 |  |  |  |  |  |  |  |  |  |  |  | N 1HR | 100
 |  |  |  |  |  |  |  |  |  | 700 | 1900 | D 30 | 30
 |  |  |  |  |  |  |  |  |  |  |  | D 1HR | 100
 |  |  |  |  |  |  |  |  |  | 1900 | 2400 | T 30 | 30
 |  |  |  |  |  |  |  |  |  |  |  | T 1HR | 100
 |  |  |  |  |  |  |  |  |  | 2400 | 3100 | NS 30 | 30
 |  |  |  |  |  |  |  |  |  |  |  | NS 1HR | 100
Spreadsheet: 825308d1681234532-fetch-sales-data-with-id-and-month-fetch-sales-data-with-id-and-month
Sheet: Sheet1

Sales Data |  |  |  |  | ID | 2022-01-01 00:00:00 | 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
ID | Sales | Month |  |  | 1001
1001 | 1963 | 2022-01-01 00:00:00 |  |  | 1002
1002 | 6656 | 2022-02-01 00:00:00 |  |  | 1003
1003 | 7669 | 2022-02-01 00:00:00 |  |  | 1005
1001 | 7950 | 2022-03-01 00:00:00 |  |  | 1006
1005 | 7942 | 2022-06-01 00:00:00 |  |  | 1007
1001 | 4808 | 2022-08-01 00:00:00 |  |  | 1008
1002 | 1269 | 2022-09-01 00:00:00
1005 | 9314 | 2022-10-01 00:00:00
1006 | 6417 | 2022-11-01 00:00:00
1002 | 4899 | 2022-12-01 00:00:00
1003 | 4718 | 2022-12-01 00:00:00
Spreadsheet: 513659d1492636952-regular-ot-and-doubletime-another-copy-sample-timesheet
Sheet: Portrait

Month: | 2017-03-01 00:00:00
Name: |  |  |  |  | OT starts after | 40 | Hours worked in the week |  |  | Weekly | Reg Hours | Over Hours | Double OT Hrs | Total Hrs worked | TOTAL  PAY
 | Rate | $ |  |  | Double OT starts after | 50 | Hours DON’T KNOW WHAT
[NAME] | 1 | 20 |  |  |  |  | THIS MEANS OR IF IT IS CORRECT |  |  | Week of 3/1/17 Should be this Accodring to CA Labor Dept.
Overtime rate | 1.5
Double OT Rate | 2
 |  |  |  |  |  |  |  |  |  | TOTAL
Week of  03/01/17 | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
Log In | 08:00:00 | 10:15:00 | 11:15:00 | 07:30:00 | 08:15:00 | 11:15:00
[NAME] |  |  |  |  |  | 14:00:00
Lunch Ends |  |  |  |  |  | 15:00:00 |  |  |  | So the Yellow highlight should be the correct hours work as opposed to the Orange highlights
Log Out | 18:00:00 | 20:15:00 | 23:15:00 | 23:00:00 | 23:15:00 | 21:15:00 |  |  |  | that are calculated according to California Labor Relations Office I don’t agree but oh well :)
Hours Worked
[NAME]
OT
Double OT
Reg. Hrs. |  | OT. Hrs. |  | Double OT Hrs |  | Total Hrs.
[NAME]. Pay |  | OT. Pay: |  | Double OT Pay |  | Total Pay
Week of  03/06/17 | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
Log In | 08:00:00 | 10:15:00 | 11:15:00 | 07:30:00 | 08:15:00 | 11:15:00
[NAME] |  |  |  |  |  | 14:00:00
Lunch Ends |  |  |  |  |  | 15:00:00
Log Out | 18:00:00 | 20:15:00 | 23:15:00 | 23:00:00 | 23:15:00 | 21:15:00
Hours Worked | 10 | 10 | 12 | 15.5 | 15
[NAME] | 8 | 8 | 8 | 8
OT | 2 | 2 | 4 | 4 | 12 | 8
Double OT |  |  |  | 3.5 | 3 | 1
Reg. Hrs. |  | OT. Hrs. |  | Double OT Hrs |  | Total Hrs.
[NAME]. Pay |  | OT. Pay: |  | Double OT Pay |  | Total Pay
Week of  03/13/17 | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
Log In | 09:00:00 | 09:30:00 | 09:45:00 |  | 12:00:00
[NAME]
Lunch Ends
Log Out | 14:45:00 | 14:30:00 | 14:30:00 |  | 15:15:00
Hours Worked
[NAME]
OT
Double OT
Reg. Hrs. |  | OT. Hrs. |  | Double OT Hrs |  | Total Hrs.
[NAME]. Pay |  | OT. Pay: |  | Double OT Pay |  | Total Pay
Week of  03/20/17 | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
Log In | 10:00:00 |  | 09:15:00
[NAME]
Lunch Ends
Log Out | 15:00:00 |  | 14:15:00
Hours Worked
[NAME]
OT
Double OT
Reg. Hrs. |  | OT. Hrs. |  | Double OT Hrs |  | Total Hrs.
[NAME]. Pay |  | OT. Pay: |  | Double OT Pay |  | Total Pay
Week of  03/27/17 | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
Log In
[NAME]
Lunch Ends
Log Out
Hours Worked
[NAME]
OT
Double OT
Reg. Hrs. |  | OT. Hrs. |  | Double OT Hrs |  | Total Hrs.
[NAME]. Pay |  | OT. Pay: |  | Double OT Pay |  | Total Pay
Spreadsheet: 116742d1312100825-countif-and-vlookup-question
Sheet: Sheet1

 | Types | Name | Amount |  |  |  |  | Name | Amount | Date | Remarks(Type) | String
 | NB | Siti |  | - should be appear 100 |  |  |  | Siti | 100 | 01.07.2011 | NB | SitiNB
 |  |  |  |  |  |  |  |  |  |  | NB
 | * if separte it, countif = 1, vlookup = 100
 |  | countif | 1
 |  | [NAME] | 100
 | Why combine together become blank?
Spreadsheet: 731901d1620664867-calculate-the-number-of-days-in-a-column-of-dates-trades-102b
Sheet: TIMES

 |  | (Total Time in range) | (entries in range) | Total rows:
START | END | SUMIFS | COUNTIFS | SUMIFS/COUNTIFS | %AGE v2
04:00:00 | 08:59:00
09:00:00 | 09:29:00
09:30:00 | 09:49:00
09:50:00 | 10:29:00
10:30:00 | 11:29:00
11:30:00 | 14:59:00
Spreadsheet: 851494d1701715813-sum-up-all-sheets-by-range-coding-and-date-range-sum-all-sheets-1-
Sheet: Garage 3

 |  |  | 2023-12-31 00:00:00 | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 | 2024-01-05 00:00:00 | 2024-01-06 00:00:00 | 2024-01-07 00:00:00 | 2024-01-08 00:00:00 | 2024-01-09 00:00:00 | 2024-01-10 00:00:00 | 2024-01-11 00:00:00 | 2024-01-12 00:00:00 | 2024-01-13 00:00:00 | 2024-01-14 00:00:00 | 2024-01-15 00:00:00 | 2024-01-16 00:00:00 | 2024-01-17 00:00:00 | 2024-01-18 00:00:00 | 2024-01-19 00:00:00 | 2024-01-20 00:00:00 | 2024-01-21 00:00:00 | 2024-01-22 00:00:00 | 2024-01-23 00:00:00 | 2024-01-24 00:00:00 | 2024-01-25 00:00:00 | 2024-01-26 00:00:00 | 2024-01-27 00:00:00
1000 | 1999 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 32 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 |  | PU | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | PP | 0 | 0 | 0 | 2 | 1 | 1 | 0 | 0 | 1 | 0 | 2 | 1 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 3 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 1
 |  | EV | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | OD | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3000 | 3999 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 32 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 |  | PU | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | PP | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 0 | 0 | 0 | 2 | 0 | 1 | 1 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 2 | 3 | 0 | 0
 |  | EV | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0
 |  | OD | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 165467d1341241468-formatting-changes-after-running-macro-wd-working2
Sheet: Start

50023842000000 |  | 1 | AMS-1 | GTC116-PC/EL | 36 | 20 | 0 | Rectangle | Insertion | 2 | 3 |  | 15 | Airflow/Temp Meas. Device
50023842000000 |  | 2 | AMS-2 | GTC116-PC/EL | 26 | 26 | 1 | Rectangle | Insertion | 2 | 3 |  | 10 | Airflow/Temp Meas. Device
50023842000000 |  | 3 | AMS-3 | GTC116-PC/EL | 14 | 14 | 0 | Rectangle | Insertion | 2 | 2 |  | 10 | Airflow/Temp Meas. Device
50023842000000 |  | 4 | AMS-4 | GTC116-PC/EL | 20 | 20 | 1 | Rectangle | Insertion | 2 | 2 |  | 10 | Airflow/Temp Meas. Device
50023842000000 |  | 5 | AMS-5 | GTC116-PC/EL | 20 | 20 | 1 | Rectangle | Insertion | 2 | 2 |  | 10 | Airflow/Temp Meas. Device
50023842000000 |  | 6 | AMS-6 | GTC116-PC/EL | 18 | 18 | 1 | Rectangle | Insertion | 2 | 2 |  | 10 | Airflow/Temp Meas. Device
50023842000000 |  | 7 | AMS-7 | GTC116-PC/EL | 22 | 22 | 1 | Rectangle | Insertion | 2 | 3 |  | 10 | Airflow/Temp Meas. Device
50023842000000 |  | 8 | AMS-8 | GTC116-PC/EL | 16 | 16 | 0 | Rectangle | Insertion | 2 | 2 |  | 10 | Airflow/Temp Meas. Device
50023842000000 |  | 9 | AMS-9 | GTC116-PD/EL | 16 | 16 | 1 | Rectangle | Insertion | 2 | 3 |  | 10 | Airflow/Temp Meas. Device
50023842000000 |  | 10 | AMS-10 | GTC116-PC/EL | 20 | 20 | 0 | Rectangle | Insertion | 2 | 3 |  | 10 | Airflow/Temp Meas. Device
50023842000000 |  | 11 | AMS-11 | GTC116-PC/EL | 20 | 20 | 1 | Rectangle | Insertion | 2 | 2 |  | 10 | Airflow/Temp Meas. Device
50023842000000 |  | 12 | AMS-12 | GTC116-PC/EL | 20 | 20 | 1 | Rectangle | Insertion | 2 | 2 |  | 10 | Airflow/Temp Meas. Device
50023842000000 |  | 13 | AMS-13 | GTC116-PC/EL | 20 | 20 | 1 | Rectangle | Insertion | 2 | 2 |  | 10 | Airflow/Temp Meas. Device
50023842000000 |  | 14 | [NAME] | GTC116-PC/EL | 20 | 16 | 1 | Rectangle | Insertion | 2 | 2 |  | 15 | Airflow/Temp Meas. Device
50023842000000 |  | 15 | AMS-15 | GTC116-PC/EL | 20 | 20 | 1 | Rectangle | Insertion | 2 | 2 |  | 10 | Airflow/Temp Meas. Device
50023842000000 |  | 16 | AMS-16 | GTC116-PC/EL | 16 | 16 | 1 | Rectangle | Insertion | 2 | 2 |  | 10 | Airflow/Temp Meas. Device
50023842000000 |  | 17 | AMS-17 | GTC116-PC/EL | 20 | 20 | 1 | Rectangle | Insertion | 2 | 2 |  | 10 | Airflow/Temp Meas. Device
Spreadsheet: 762901d1641896209-compact-cell-by-row-deleting-empty-cells-compact-by-row
Sheet: Foglio1

a |  | b | c |  | d |  |  | e
 | f |  | g | h |  | j |  |  |  | k | l
 |  | i need to obtain
a | b | c | d | e
f | g | h | j | k | l
Spreadsheet: 116324d1311753591-excel-claim-sorting-claims-sorting-tracker-cst-1-1-1-
Sheet: Total

 |  |  | Claims Summery
Renewal Date Period |  | Starting Year | Five Years Period |  |  |  |  | Paid No of  Claims | Paid Total  Amount | Outstanding  No of Claims | Outstanding  Total Amount | Total Number of Claims | Total Amount
2011-08-01 00:00:00 | #N/A | 2011 | 2011-08-01 00:00:00 | 2011 | To | #N/A | 2012 | 1 | 15 | 0 | 0 | 1 | 15 |  |  |  |  | 2011-08-01 00:00:00 | 2012-07-31 00:00:00
 |  |  | 2011-08-01 00:00:00 | 2010 | To | #N/A | 2011 | 2 | 6356 | 0 | 0 | 1 | 6356 |  |  |  |  | 2010-08-01 00:00:00 | 2011-07-31 00:00:00
 |  |  | 2011-08-01 00:00:00 | 2009 | To | #N/A | 2010 | 1 | 15 | 1 | 500 | 2 | 515 |  |  |  |  | 2009-08-01 00:00:00 | 2010-07-31 00:00:00
 |  |  | 2011-08-01 00:00:00 | 2008 | To | #N/A | 2009 | 0 | 0 | 0 | 0 | 2 | 0 |  |  |  |  | 2008-08-01 00:00:00 | 2009-07-31 00:00:00
 |  |  | 2011-08-01 00:00:00 | 2007 | To | #N/A | 2008 | 1 | 200 | 1 | 100 | 0 | 300 |  |  |  |  | 2007-08-01 00:00:00 | 2008-07-31 00:00:00
 |  |  | 2011-08-01 00:00:00 | 2006 | To | #N/A | 2007 | 3 | 5200 | 1 | 50 | 2 | 5250 |  |  |  |  | 2006-08-01 00:00:00 | 2007-07-31 00:00:00
 |  |  | Total Summary |  |  |  |  | 8 | 11786 | 3 | 650 | 8 | 12436
 |  |  |  |  |  |  |  | Note: column D&E have similar formula
 |  |  |  |  |  |  |  | Note: column F&G have similar formula
 |  |  |  |  |  |  |  | Note: Range can be changed by replacing 43 in the formula with 100 or onward