tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 474625d1470837661-count-value-in-geometric-mean-if-value-in-adjacent-column-1-example-geomean
Sheet: Feuil1

 |  |  |  |  |  |  | Old Way--Arithmetic Mean |  |  |  | New Way--Geometric Mean
 |  |  | Type | Population 1 | Population 2 |  | Type | Pop 1 | Pop 2 |  | Type | Pop 1 | Pop 2
 |  |  | 1 | 750 | 55000 |  | 1 |  |  |  | 1
 |  |  | 2 | 280 | 6000 |  | 2 |  |  |  | 2
 |  |  | 3 | 1030 | 25000 |  | 3 |  |  |  | 3
 |  |  | 2 | 390 | 37000 |  | 4 |  |  |  | 4
 |  |  | 3 | 640 | 48000
 |  |  | 4 | 150 | 9800
 |  |  | 4 | 470 | 14000
 |  |  | 4 | 1100 | 40000
 |  |  | 4 | 860 | 49000
Spreadsheet: 132573d1323821321-pdf-text-to-excel-spreadsheet-travelleisure
Sheet: Page_8

 |  |  |  | Media Outlet Results
Outlet Name | Outlet City | Outlet State | Outlet Type  Outlet Website |  |  | Outlet E-mail |  | Outlet Phone Number Outlet Circulation Keyword Outlet Source  AudienceRelevance
Asian Hospitality | Norcross | GA | [NAME] |  | [NAME] |  |  | (770) 263-7728 | 10,000 | 38 | S
 |  |  | zine, |  | sianhospitali
 |  |  | trade/ |  | ty.com/
 |  |  | indust
 |  |  | ry
Canadian | Mississauga | ON | [NAME] |  | http://www.c | mandrews |  | (905) 206-0150 | 10,000 | 45 | S
Lodging News |  |  | zine, |  | an- | @can-
 |  |  | trade/ |  | lodgingnew | lodgingnew
 |  |  | indust |  | s.com/ | s.com
 |  |  | ry
[NAME] | [NAME] | ON | [NAME] |  | http://www.f |  |  | (416) 447-0888 | 10,000 | 27 | S
 |  |  | zine, |  | oodservice
 |  |  | trade/ |  | world.com
 |  |  | indust
 |  |  | ry
Southern | Tallahassee | FL | [NAME] |  | http://www.s | editor@sout |  | (850) 386-7401 | 10,000 | 47 | S
Hospitality |  |  | zine, |  | outhernhosp | hernhospital
Magazine - |  |  | trade/ |  | italitymagazi | itymagazine
Traveler |  |  | indust |  | [NAME] | .com
 |  |  | ry |  | eler/index.p
 |  |  |  |  | hp
Four Seasons | Greensboro | NC | [NAME] |  | http://magaz | info@fourse |  | (336) 378-6065 | 9,500 | 32 | S
 |  |  | zine, |  | ine.fourseas | asonsmaga
 |  |  | consu |  | ons.com/ma | zine.com
 |  |  | [NAME] |  | gazine/
On-Campus | Westbury | NY | [NAME] |  | http://www.e |  |  | (516) 334-3030 | 9,330 | 21 | S
Hospitality |  |  | zine, |  | bmpubs.co
 |  |  | trade/ |  | m/OCH/inde
 |  |  | indust |  | x.asp
 |  |  | ry
Military Club & | Westbury | NY | [NAME] |  | http://www.e |  |  | (516) 334-3030 | 9,028 | 21 | S
Hospitality |  |  | zine, |  | bmpubs.co
 |  |  | trade/ |  | m
 |  |  | indust
 |  |  | ry
Page: 8 |  |  |  |  |  |  |  |  |  |  | 12/13/2011
Spreadsheet: 61540d1262435919-totaling-down-time-of-phone-by-use-of-agent-log-in-off-timings-book2
Sheet: Sheet2

 |  | 1st |  | 2nd |  | 3rd |  | 4th |  | 5th |  | 6th |  | 7th
phone 1 | Logged On | 07:09:00 | 19:09:00 | 07:06:00 | 19:09:00 | 07:08:00 | 19:12:00 | 07:16:00 | 18:59:00 | 07:05:00 | 19:08:00 | 07:02:00 | 19:06:00 | 06:59:00 | 19:06:00 | 07:03:00
 | Logged Off | 19:00:00 | 07:03:00 | 19:01:00 | 07:00:00 | 19:02:00 | 07:06:00 | 18:50:00 | 07:02:00 | 18:49:00 | 06:51:00 | 12:50:00 | 06:46:00 | 18:57:00 | 06:55:00 | 19:18:00
 | Down Time AM |  | 00:03:00 |  | 00:08:00 |  | 00:10:00 |  | 00:03:00 |  | 00:11:00 |  | 00:13:00 |  | 00:08:00
 | Down Time PM | 00:09:00 |  | 00:08:00 |  | 00:10:00 |  | 00:09:00 |  | 00:19:00 |  | 06:16:00 |  | 00:09:00
phone 2 | Logged On | 07:27:00 | 20:07:00 | 07:08:00 | 19:10:00 | 07:37:00 | 19:05:00 | 07:05:00 | 19:10:00 | 07:23:00 | 19:08:00 | 07:09:00 | 19:01:00 | 06:57:00 | 19:27:00 | 06:57:00
 | Logged Off | 18:53:00 | 07:04:00 | 19:01:00 | 07:01:00 | 18:57:00 | 07:00:00 | 18:53:00 | 06:55:00 | 18:46:00 | 07:00:00 | 18:57:00 | 06:53:00 | 18:50:00 | 06:46:00 | 18:59:00
 | Down Time AM |  | 00:04:00 |  | 00:36:00 |  | 00:05:00 |  | 00:28:00 |  | 00:09:00 |  | 00:04:00 |  | 00:11:00
 | Down Time PM | 01:14:00 |  | 00:09:00 |  | 00:08:00 |  | 00:17:00 |  | 00:22:00 |  | 00:04:00 |  | 00:37:00
 | Down Time AM |  | 00:02:00 |  | 00:07:00 |  | 1900-01-01 00:00:00 |  | 00:03:00 |  | 00:02:00 |  | 00:04:00 |  | 00:02:00
 | Down Time PM | 00:09:00 |  | 00:08:00 |  | 00:03:00 |  | 00:06:00 |  | 00:19:00 |  | 00:04:00 |  | 00:09:00
 | Desired output:  iwould like excel to calculate how long the phone werent logged in during handover.  The 1st one above is simple and clear 9 mins that no phones were logged in. but if we look at the 5th; phone 1 logged out at 0651 and back in again at 0702, phone 2 on the other hand logged out at 0700 and back in at 0709.  so between the 2 phones there was a period of 2min where neither phone was logged in.  This is the output i want to achieve 2mins
Spreadsheet: 54aec397-ea00-4d53-a8b1-57b4c519c9eb
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
11/13/2009 | Women's Basketball | TOWSON | 12:00 AM | W, 79-42
11/16/2009 | Women's Basketball | MARIST | 12:00 AM | W, 55-50
11/19/2009 | Women's Basketball | at Ohio State | 12:00 AM | L, 69-92
11/24/2009 | Women's Basketball | at Duquesne | 12:00 AM | W, 73-52
11/27/2009 | Women's Basketball | vs. Iowa (Reno, Nev.) | 12:00 AM | W, 69-66
11/28/2009 | Women's Basketball | at Nevada | 12:00 AM | W, 66-41
12/02/2009 | Women's Basketball | RADFORD | 12:00 AM | W, 64-28
12/05/2009 | Women's Basketball | MAINE | 12:00 AM | W, 88-32
12/08/2009 | Women's Basketball | EASTERN KENTUCKY | 12:00 AM | W, 60-40
12/12/2009 | Women's Basketball | LONGWOOD | 12:00 AM | W, 74-43
12/19/2009 | Women's Basketball | FRESNO STATE | 12:00 AM | W, 72-52
12/22/2009 | Women's Basketball | UMBC | 12:00 AM | W, 79-45
12/30/2009 | Women's Basketball | SANTA CLARA | 12:00 AM | W, 78-55
01/02/2010 | Women's Basketball | at St. John's | 12:00 AM | W, 54-50
01/05/2010 | Women's Basketball | PITT | 12:00 AM | W, 63-59
01/09/2010 | Women's Basketball | DEPAUL | 12:00 AM | W, 64-57 (OT)
[NAME] | Women's Basketball | VILLANOVA | 12:00 AM | W, 45-41
01/17/2010 | Women's Basketball | at Pitt | 12:00 AM | W, 69-54
[NAME] | Women's Basketball | vs. [NAME] (Charleston, W.Va.) | 12:00 AM | W, 74-42
01/24/2010 | Women's Basketball | at Notre Dame | 12:00 AM | L, 66-74
[NAME] | Women's Basketball | SETON HALL | 12:00 AM | W, 55-31
01/30/2010 | Women's Basketball | LOUISVILLE | 12:00 AM | W,72-66
[NAME] | Women's Basketball | at Connecticut | 12:00 AM | L, 47-80
02/06/2010 | Women's Basketball | at Providence | 12:00 AM | W, 75-59
02/14/2010 | Women's Basketball | GEORGETOWN | 12:00 AM | W, 55-46
02/16/2010 | Women's Basketball | RUTGERS | 12:00 AM | W, 55-51
02/20/2010 | Women's Basketball | at USF | 12:00 AM | W, 54-45
02/23/2010 | Women's Basketball | at Cincinnati | 12:00 AM | W, 64-43
02/27/2010 | Women's Basketball | MARQUETTE | 12:00 AM | W, 69-56
03/01/2010 | Women's Basketball | at Syracuse | 12:00 AM | L, 48-67
[NAME] | Women's Basketball | vs. [NAME] | 12:00 AM | W, 47-41
03/08/2010 | Women's Basketball | vs. Rutgers | 12:00 AM | W, 56-49
03/09/2010 | Women's Basketball | vs. Connecticut | 12:00 AM | L, 62-30
03/21/2010 | Women's Basketball | vs. [NAME] | 12:00 AM | W, 58-43
03/23/2010 | Women's Basketball | vs. San Diego State | 12:00 AM | L, 55-64
Spreadsheet: f6a496ec-3af8-49b3-bcaf-61087b627587
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
B6PRO | Test | B6PRO | [NAME] (PLP and PA), Plasma | [NAME] (PLP and PA), P | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  | 1 | mL | Collection Container/Tube: Green top (heparin) Submission Container/Tube: Amber vial (Supply T192) [NAME]: 1 mL 	 Collection Instructions:  1. Fasting-overnight (12-14 hour) (infants-draw prior to next feeding).  2. Patient must not ingest vitamin supplements for 24 hours before the specimen is drawn.  3. Centrifuge at 4 degrees C, then aliquot all plasma into amber vial to protect from light. | 0.75 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	Plasma gel tube | PYRIDOXAL 5-PHOSPHATE 5-50 mcg/L   PYRIDOXIC ACID 3-30 mcg/L | Two times per week; Days vary |  | 5 days |  | Profile |  |  |  |  | New England
B6PRO | [NAME] | PLHEP | [NAME] |  |  |  | Refrigerated | 7 days
B6PRO | Component | PLP | Pyridoxal 5-Phosphate (PLP), Plasma | Pyridoxal 5-Phosphate (PLP), P | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) |  |  |  | 1 | mL | Collection Container/Tube: Green top (heparin) Submission Container/Tube: Amber vial (Supply T192) [NAME]: 1 mL  Collection Instructions:  1. Fasting-overnight (12-14 hours) (infants-draw prior to next feeding).  2. Patient must not ingest vitamin supplements for 24 hours before the specimen is drawn. 3. Centrifuge at 4 degrees C, then aliquot all plasma into amber vial to protect from light. | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	Plasma gel tube | 5-50 mcg/L | Monday through Friday | 1 day | 4 days | 1 | 84207 |  |  | Yes | Yes
PLP | [NAME] | PLHEP | [NAME] |  |  |  | Refrigerated | 7 days
PLP | Result | 4047 | Pyridoxal 5-Phosphate (PLP), P | Pyridoxal 5-Phosphate (PLP), P | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 30552-4
B6PRO | Component | B6PA | Pyridoxic Acid (PA), Plasma | Pyridoxic Acid (PA), P | Only orderable as part of a profile. For further information see #61064 Vitamin B6 Profile (PLP and PA), P. |  |  |  |  |  | Only orderable as part of a profile. For further information see #61064 Vitamin B6 Profile (PLP and PA), P. | 0.25mL |  | Only orderable as part of a profile. For further information see #61064 Vitamin B6 Profile (PLP and PA), P. |  |  |  | 1 | 83789 |  |  | Yes | No
B6PA | [NAME] | PLHEP | [NAME] |  |  |  | Refrigerated | 7 days
B6PA | Result | 61065 | Pyridoxic Acid (PA), P | Pyridoxic Acid (PA), P | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 1688-1
Spreadsheet: 762260d1641476204-modify-existing-if-and-iferror-formula-permit-register-example-6-1-22
Sheet: To Approve

ABC Job Number | Address | Description | Client | Permit  Number | BP | OP | Inspection Status | Job Notes
 | Address 4 | Description 4 | Client 4 | 001/001/004 | 2021-05-04 00:00:00 | APPROVE | 18/1/21 - Waterproofing | 0
ABC-21009 | Address 9 | Description 9 | Client 9 | 001/001/009 | - | APPROVE | 18/1/21 - Final | 0
ABC-21022 | Address 22 | Description 22 | Client 22 | 001/001/022 | APPROVE | 0 | #N/A | 0
ABC-21026 | Address 26 | Description 26 | Client 26 | 001/001/026 | APPROVE | 0 | #N/A | 0
Spreadsheet: 728451d1618472859-changing-chart-range-book1
Sheet: Sheet

YTD
MTD
Date | Copper1 | Copper2
2021-04-14 00:00:00 | 2142 | 8330
2021-04-13 00:00:00 | 2062.5 | 8129.5
2021-04-12 00:00:00 | 2027.5 | 7914
2021-04-09 00:00:00 | 2013.5 | 7918.5
2021-04-08 00:00:00 | 1978 | 7741.5
2021-04-07 00:00:00 | 1995.5 | 7803.5
2021-04-06 00:00:00 | 2000 | 7840
2021-04-01 00:00:00 | 2022 | 7793
2021-03-31 00:00:00 | 1999 | 7764.5
2021-03-30 00:00:00 | 1993 | 7753
Spreadsheet: 745818d1630251382-compare-two-columns-in-two-sheets-to-remove-duplicates-and-return-one-copy-only-book1
Sheet: Sheet3

Column3, Master |  |  | Final Output
2021 - Cor T ( 1.4-Sty-Cloth ) |  |  | 2021 - Cor T ( 1.4-Sty-Cloth )
2021 - NTOR ( 3.0 -AM-PLUS ) |  |  | 2021 - NTOR ( 3.0 -AM-PLUS )
2021 - TERA ( 3.6 - CL ) |  |  | 2021 - TERA ( 3.6 - CL )
2021 - GIT ( 2.0 -R Line ) |  |  | 2021 - GIT ( 2.0 -R Line )
2021 - GIT ( 2.0 -Eleg ) |  |  | 2021 - GIT ( 2.0 -Eleg )
2021 - TERA ( 3.6 - HL ) |  |  | 2021 - TERA ( 3.6 - HL )
2021 - GIT ( 1.4 -Life ) |  |  | 2021 - GIT ( 1.4 -Life )
2021 - ITG - P2 ( Leather ) |  |  | 2021 - ITG - P2 ( Leather )
2021 - SSAP ( 2.5 -TL ) |  |  | 2021 - SSAP ( 2.5 -TL )
2021 - Cor T ( 1.4-TL ) |  |  | 2021 - Cor T ( 1.4-TL )
2021 - Cor T ( 1.4-Sty-Leather ) |  |  | 2021 - Cor T ( 1.4-Sty-Leather )
 |  |  | 2021 - ITG - P1 ( Cloth )
2021 - ITG - P2 ( Leather ) |  |  | 2021 - SSAP ( 2.5 -CL )
2021 - NTOR ( 3.0 -AM ) |  |  | 2021 - SSAP ( 2.5 -HL )
2021 - NTOR ( 3.0 -AM-PLUS ) |  |  | 2021 - Cor T (1.4-Sty-R Line )
2021 - SSAP ( 2.5 -CL ) |  |  | 2021 - ARET ( 3.6 - CL )
2021 - SSAP ( 2.5 -HL ) |  |  | 2021 - ARET ( 3.6 - HL )
2021 - SSAP ( 2.5 -TL )
2021 - Cor T ( 1.4-Sty-Cloth )
2021 - Cor T ( 1.4-Sty-Leather )
2021 - Cor T (1.4-Sty-R Line )
2021 - ARET ( 3.6 - CL )
2021 - ARET ( 3.6 - HL )
2021 - GIT ( 1.4 -Life )
2021 - GIT ( 2.0 -Eleg )
2021 - GIT ( 2.0 -R Line )
Spreadsheet: 287431d1388785174-looking-up-clients-sample-3
Sheet: Sheet1

Date | Employee | Client | Activity | Hours | Department
2013-03-25 08:00:00 | Ruby | Macy's | Shorts | 1.25 | PMI
2013-03-26 08:00:00 | TJ | Macy's | Shorts | 1 | FA
2013-03-27 08:00:00 | Ruby | Macy's | shits | 0.25 | FC
2013-10-04 08:00:00 | Yuri | Macy's | skirts | 1.5 | FA
2013-04-19 13:30:00 | [NAME] | [NAME]'s | skirts | 1 | M
2013-05-07 11:00:00 | [NAME] | Kohls | pants | 1 | M
2013-10-07 10:30:00 | Greg | Kohls | skirts | 0.5 | PMI
2013-11-22 08:00:00 | Ruby | H&M | shirts | 1.5 | M
2013-11-22 09:30:00 | TJ | H&M | skirts | 0.5 | M
2013-01-21 00:00:00 | [NAME] | Tiffany's | skirts | 1.5 | FA
2013-02-01 00:00:00 | [NAME] | Tiffany's | pants | 0.5 | PMI
2013-02-05 00:00:00 | [NAME] | H&M | skirts | 0.5 | M
2013-01-21 00:00:00 | Emily | H&M | shirts | 0.5 | M
Mock up of the Table |  |  | The Other Table
Ruby |  |  | tj
Clients | Hours |  | Clients | FA | FC | PMI | M | Hours
Macy's | 3.5 |  | Macy's | 1 | 0 | 0 | 0 | 1
H&M | 1.5 |  | H&M | 0 | 0 | 0 | 0.5 | 0.5
 |  |  | Total | 1 | 0 | 0 | 0.5 | 1.5
 |  |  | Employee | TJ
 |  |  | Sum of Hours | Department
 |  |  | Client | M | FA | Grand Total
 |  |  | H&M | 0.5 |  | 0.5
 |  |  | Macy's |  | 1 | 1
 |  |  | Grand Total | 0.5 | 1 | 1.5
Spreadsheet: 390716d1429734239-alternative-formula-needed-alternative
Sheet: Sayfa1

AA | BB | CC | DD | EE | FF | GG | HH | II | JJ |  | AVI
 |  |  |  |  |  |  |  |  |  |  | PER
DG |  |  |  | PER |  |  |  |  | DG
 |  |  |  |  |  |  |  |  |  |  | DG
A1 | B1 | C1 | D1 | E1 | F1 | [NAME] | H1 | I1 | J1
PER |  |  | PER | AVI |  | DG
AR | BR | CR | DR | ER | FR | GR | HR | IR | JR
 | PER |  |  |  |  |  | DG |  | DG
AL | BL | CL | DL | EL | FL | GL | HL | IL | JL
DG |  |  | DG |  | PER
P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10
 |  | PER
K1 | K2 | K3 | K4 | K5 | K6 | K7 | K8 | K9 | K10
 | AVI |  | AVI |  | PER | PER |  | DG
Spreadsheet: 074a5032-1a76-419f-9bee-dafd2434913a
Sheet: Sheet1

USERNAME | MODEL | BUILD DATE MTH | BUILD DATE YEAR | WORKING | NOT WORKING | WHEELS/TIRES CHANGES | AIR/NITRO/OTHER
[NAME] | 550 | JUL | 2011 | X |  | YES | AIR
shawnsheridan | 535 | OCT | 2010 | X |  | YES | AIR
[NAME] | 550 | JUN | 2011 | X
wdimagineer | 550 | JAN | 2012 | X |  | YES | AIR
alextremo | 550 | DEC | 2010 | X |  | YES | AIR
[NAME] | 535 | NOV | 2011 | X |  | YES | AIR
nicewonky | 535 | NOC | 2011 | X |  | NO | AIR
clutchlee | 535 | MAR | 2011 | X |  | YES | AIR
DreamCar | 535 |  |  | X |  | NO | AIR
alex_c | 535 | AUG | 2011 |  | X | NO | NITROGEN
Stealth.Pilot | 550 | SEP | 2011 |  | X | YES | AIR
ImSW1 | 528 | JUN | 2010 |  | X | YES | AIR
dmunz | 535GT | DEC | 2011 |  | X | NO | NITROGEN
Griffin 27 | 535 | MAR | 2012 |  | X | YES | AIR
grilodan | 535 | AUG | 2010 |  | X | NO | AIR
Spreadsheet: 756731d1637743329-move-data-from-one-sheet-to-another-which-matches-two-criteria-example-spreadsheet-4-
Sheet: Google

 | Site 1 | Site 2 | Site 3 | Site 4 | Site 5
2021-11-01 00:00:00 |  | Partial, Access Issue |  | Full, Access Issue | Full
2021-11-01 00:00:00 | Full, Access Issue |  | Full
2021-11-02 00:00:00 | Full | Full, Access Issue | Full | None | None
2021-11-03 00:00:00 | Partial, Access Issue | Full | None | Partial, Access Issue | Full
2021-11-04 00:00:00 | Full |  |  | Full
2021-11-04 00:00:00 |  | None |  |  | Partial, Access Issue
2021-11-04 00:00:00 |  |  | Full, Access Issue
2021-11-05 00:00:00 | None | Full | Partial, Access Issue | Full | Full, Access Issue
ALL of the information above is pasted into this sheet from a Google form response. The amount of data will potentially increase an unknown amount of times (both the date as well as the name and number of sites) and the site names may change position  due to their location on the google sheet being moved as new columns are added over time.
The highlighted information then needs to be moved to a master sheet which has other information on it and "matched" to the correct site name and the correct date.
The new problem
Different sites may be serviced on the same day, however, by a different team. This means that there may be more than one date entry, however, there would only be one entry for each site on each date.
Spreadsheet: 167294d1341945649-monthly-pull-down-of-cell-into-corresponding-month-column-accounts-example
Sheet: Sheet1

 | YTD PO VALUE: | 150000
Variable |  | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00
A | PO Value | 100000 | 100000 | 100000 | 100000 | 100000 | 100000
B | Forecast Out-turn | 100000 | 100000 | 100000 | 150000 | 150000 | 150000
C | ACWP (Actual Cost of Work Performed) | 10000 | 20000 | 30000 | 40000 | 50000 | 60000
D | Progress (%) | 0.1 | 0.2 | 0.3 | 0.2666666666666667 | 0.3333333333333333 | 0.4 | - | - | - | - | - | -
E | Invoice Amount (%) | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | - | - | - | - | - | -
F | Value Invoiced | 10000 | 20000 | 30000 | 40000 | 50000 | 60000 | - | - | - | - | - | -
 | Value of work at risk. | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | - | -
Parameter Derivation:
D = C/B
E = C/A
F = A * E
A = PO Value
B = Forecast Out-Turn
C = ACWP
D = Progress (%)
E = Invoice Amount (%)
F = Value Invoiced
Spreadsheet: 837727d1690381008-sum-up-order-total-if-id-matches-and-if-shipping-date-matches-order-date-or-5-days-ci-invoices-stuff
Sheet: CI export

Posting Date | Document No. | Line No. | Sell-to Customer No. | No. | Order No. | Customer Reference No | Order Date | Shipment Date | Description | Quantity | Unit Price | VAT % | Amount | VAT | Amount Including VAT | [NAME]-to Customer No. | Sell-to Customer Name | Forename | Surname | Order total | Orders sheet total | Difference |  | Test formula |  | Order date | Order date plus 5 | Amount
2023-06-30 00:00:00 | test | 1880000 | 001770110H | LM3_QUESTION_PACK |  |  | 2023-06-30 00:00:00 | 2023-06-06 00:00:00 | test | 1 | 29.17 | 20 | 21.6 | 4.32 | 25.92 | COLQQL | test | test name | test name | 222.3
2023-06-30 00:00:00 | test | 1930000 | 001775028D | M80_EKEY_FACTS |  |  | 2023-06-30 00:00:00 | 2023-06-06 00:00:00 | test | 1 | 30 | 0 | 27 | 0 | 27 | COLQQL | test | test name | test name | 438.3
2023-06-30 00:00:00 | test | 2060000 | 001819431L | M85_EKEY_FACTS |  |  | 2023-06-30 00:00:00 | 2023-06-06 00:00:00 | test | 1 | 30 | 0 | 27 | 0 | 27 | COLQQL | test | test name | test name | 438.3
2023-06-30 00:00:00 | test | 2150000 | 001835987F | 13420 |  |  | 2023-06-30 00:00:00 | 2023-06-16 00:00:00 | test | 1 | 8 | 0 | 8 | 0 | 8 | COLQQL | test | test name | test name | 250.1
Spreadsheet: 862654d1710319727-attendance-downloaded-data-time-format-issue-time-format-2-aligw
Sheet: Sheet1

SAP No. | [NAME] | Name | AttendanceDate | FirstIn | LastOut | WorkHour | Department |  | FirstIn (Time Format | LastOut (Time Format)
33653 | 33653 | K NARENDER REDDY | 12 Mar 2024 | 05:38:00 | 14:00:00 | 0:00 | CLEARING
33655 | 33655 | MANORANJAN ROUT | 12 Mar 2024 | 05:38 | 14:00 | 8:00 | WAREHOUSE
33657 | 33657 | [NAME] | 12 Mar 2024 | 05:38 | 14:05 | 8:00 | COLDFORM
57238 | 57238 | M RAJU | 12 Mar 2024 | 05:40:00 | 14:02 | 0:00 | COLDFORM
80002649 | 80002649 | [NAME] | 12 Mar 2024 | 08:45 |  | 0:00 | IR
80002657 | 80002657 | SAYED TAJUDDIN | 12 Mar 2024 | 05:40 | 14:04 | 8:00 | IR
80002761 | 80002761 | ABSHEK KUMAR | 12 Mar 2024 | 21:40 | 06:02 | 8:00 | WELDING
80002782 | 80002782 | SUSHANTH KUMAR | 12 Mar 2024 |  |  | 0:00 | FABRICATION
80002787 | 80002787 | BIMLESH KUMAR | 12 Mar 2024 | 05:39 | 14:02 | 8:00 | WELDING
80002788 | 80002788 | SIKANDHAR KUMAR | 12 Mar 2024 | 05:39 | 14:05 | 8:00 | WELDING
80002792 | 80002792 | B ADHI REDDT | 12 Mar 2024 |  |  | 0:00 | WELDING
80002821 | 80002821 | RAJESHWARA SAHOO | 12 Mar 2024 | 21:39 | 06:00 | 8:00 | WELDING
The data shown above is the attendance of employees, downloaded from an Attendance Software.
Col. E & F shows IN and OUT punches.  Since the data is downloaded, it doesn't come in TIME FORMAT.
Col.E & F data converted to Time Format (In Col.J & K) and is working fine.
Due to technical reasons / unrecognised face or finger print, sometimes punch time will be blank.
Time Office executive will force change the data with appropriate timings.
When we enter Time in BLANK cell, the data is showing in Time format, but data in Col. J & K is not showing the time.
Need Col. J & K to display overall timings (Downloaded and manually changed)
Secondly I would be grateful, if the Cells are highlighted in Yellow Colour whenever someone changes the data manually in the sheet (I highlighted now manually in Yellow for your better understanding of the issue)
Kindly help.
Spreadsheet: 149263d1333787419-generating-reports-automatically-generate-report-automatically_pt_jpr73
Sheet: Math

Roll | Name | CT | IA | GA | OR | EX | AVG | GR
1 | a |  | 9 | 6 |  |  |  | B1
2 | b | 10 | 9 | 9 | 9 | 9 |  | A1
3 | c | 9 | 6 | 10 | 4 | 7 |  | B1
4 | d
5 | e | 8 | 9 | 10 | 10 | 9 |  | A1
6 | f
7 | g
8 | h
9 | i
10 | j
Spreadsheet: 146594d1332264900-combining-tables-into-one-pivot-table-book2test
Sheet: Percent

Date | Name | Code | Percentage
2012-03-11 00:00:00 | Hull, [NAME] | MA | 100
2012-03-11 00:00:00 | Hull, [NAME] | BS | 97.06
2012-03-11 00:00:00 | [NAME], Curtis | MA | 100
2012-03-11 00:00:00 | [NAME], Curtis | BS | 96.43
2012-03-11 00:00:00 | Smith, Ozzie | MA | 100
2012-03-11 00:00:00 | Smith, Ozzie | BS | 0
2012-03-11 00:00:00 | Smith, Ozzie | MA | 100
Spreadsheet: 765043d1643132564-sum-sumifs-with-multiple-criteria-sum-sumifs
Sheet: Sheet1

Code | Region | Name | Amount |  |  | Code | ABC | XYZ
ABC | North | [NAME] | 5 |  |  | Region | North | South
ABC | North | [NAME] | 9 |  |  | Name | [NAME]
ABC | North | [NAME] | 22
ABC | South | [NAME] | 36
ABC | South | [NAME] | 14
ABC | South | [NAME] | 48
XYZ | North | [NAME] | 34
XYZ | North | [NAME] | 46
XYZ | North | [NAME] | 4
XYZ | South | [NAME] | 21
XYZ | South | [NAME] | 17
XYZ | South | [NAME] | 39
A1A | North | [NAME] | 1
A1A | North | [NAME] | 49
A1A | North | [NAME] | 10
XYZ | South | 0 | 9
XYZ | South | 0 | 26
XYZ | South | 0 | 3