tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 693492d1598990138-count-the-number-of-days-a-job-has-been-excuted-with-pivot-summary-daily-production-sheet
Sheet: 03072020

 |  |  | JO/20/178 HRS | JO/20/178 OT | JO/20/144 HRS | JO/20/144 OT | [NAME] | [NAME] | jo/20/120-B HRS | jo/20/120-B OT | [NAME] | [NAME] | JO/20/186 HRS | JO/20/186 OT | [NAME] | [NAME] | JO/20/149 HRS | JO/20/149 OT | [NAME] | [NAME] | JO/20/162 HRS | [NAME] | [NAME]HRS | [NAME]OT | Maintainance / Other works  HRS | Maintainance / Other works  OT
1 | 1 | MATHEW |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 3 | 3.3
2 | 2 | GEORGE
3 | 3 | SIVA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 3.3
4 | 4 | CHRISTOPHER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
5 | 5 | SAMUEL | 8
6 | 6 | BOMMANNA |  |  | 8
7 | 7 | SATIYAR |  |  |  |  |  |  |  |  | 8
8 | 8 | KUMAR RAM
9 | 9 | MARTIN
22 | 10 | [NAME] |  |  |  |  | 4 |  |  |  |  |  |  |  | 4
10 | 11 | FELIX |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  | 1 | 2.3
11 | 12 | DIPAK |  |  | 4 |  |  |  | 4
12 | 13 | SATHYAPALAN
13 | 14 | RAJEEV |  |  |  |  |  |  |  |  | 8
16 | 15 | [NAME]
17 | 16 | FLORENCIO |  |  | 8
14 | 17 | VINOTH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  | 1 | 2.3
 | 18 | SHAM |  |  |  |  |  |  | 8
15 | 19 | RAJASEKAR |  |  |  |  |  |  |  |  |  |  | 8
19 | 20 | FRANCIS JOSEPH |  |  |  |  | 8 |  |  |  |  |  |  |  |  | 2.5
24 | 21 | SONU  CHAUHAN |  |  |  |  |  |  | 8
25 | 22 | MALIK
18 | 23 | SIVA |  |  | 3 |  | 4 |  |  |  |  |  | 1 |  |  | 2.5
20 | 24 | SURENDRA |  |  |  |  |  |  |  |  |  |  | 8 |  |  | 2.5
21 | 25 | RAVI |  |  |  |  |  |  | 8
23 | 26 | HEMRAJ |  |  |  |  | 8
 | 27 | AJMER SINGH
26 | 28 | RASHID
27 | 29 | BALJIT | 2 |  | 2 |  | 4
28 | 30
34 | 31
35
COMMENTS :
Prepared by: |  |  |  |  |  |  |  |  | Approved by:
Name: |  |  |  |  |  |  |  |  | Name:
Sign: |  |  |  |  |  |  |  |  | Sign:
Date: |  |  |  |  |  |  |  |  | Date:
Iss.No./Date: 02/01.06.2013
Rev.No/Rev.Date:02/23.06.2020
Spreadsheet: ed92dab9-11f8-474a-a279-a883df0e5251
Sheet: ADMIN

 |  | APPROPRIATION TRANSACTION
 |  | CITY  OF  KANSAS  CITY,  MISSOURI
 |  |  | DEPARTMENT: |  |  | Public Works
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  |  |  | JOURNAL ID:
LEDGER GROUP: |  |  |  |  | ADMIN
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
 |  | 3090 |  | 898101 |  | 611060 |  | 89020070 |  | 411039.87 |  | inc
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL
[NAME]:
 |  | Estimating revenue and appropriating funds to the Barry Rd Project
APPROVED BY: |  |  |  |  |  | DATE |  | APPROVED BY:  DEPARTMENT HEAD |  |  |  |  |  | DATE
Spreadsheet: 23c4befb-6a7f-4b5a-8a01-15d4c849db91
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
FRDIG | Test | FRDIG | Digoxin, Free, Serum | Digoxin, Free, S | Ultrafiltration Followed by Electrochemiluminescent Immunoassay | Serum Gel Tube: SGT |  |  | 1 | mL | Container/Tube:  Preferred: Serum gel Acceptable: Red top [NAME]: 1 mL Collection Instructions: Draw blood 6 to 8 hours after last dose of digoxin. | 0.5 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | Therapeutic concentration: 0.4-1.5 ng/mL Toxic concentration: > or =3.0 ng/mL Pediatric toxic concentrations may be higher. | Monday through Sunday; Continuously | Same day/1 day | 1 day | 1 | 80162 |  |  |  |  | Rochester
FRDIG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
FRDIG | Result | FRDIG | Digoxin, Free, S | Digoxin, Free, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 3562-6
Spreadsheet: 705659d1606240267-looping-through-data-outputting-a-specific-value-when-id-is-same-samp2
Sheet: Sheet8

ID: | FIELD1 | FIELD2 | [NAME] | FIELD4 | FIELD5 | FIELD6 | FIELD7 | Expected Result:
1140 | Yes | No | No | Yes | No | No | No | SS
1140 | Yes | No | No | Yes | No | No | No | SS
1140 | Yes | No | No | Yes | No | No | No | SS
1140 | Yes | No | No | Yes | No | No | No | SS
1133 | No | No | No | Yes | No | No | No | SS
1146 | Yes | No | No | N | N | N | N | SS
1143 | No | No | Yes | No | No | Yes | No | NO SS
1143 | No | No | Yes | No | No | Yes | No | NO SS
1143 | No | No | Yes | No | No | Yes | No | NO SS
1143 | No | No | Yes | No | No | Yes | No | NO SS
1143 | No | No | Yes | No | No | Yes | No | NO SS
1143 | No | No | Yes | No | No | Yes | No | NO SS
1143 | No | No | Yes | No | No | Yes | No | NO SS
1141 | No | Yes | No | N | N | N | N | NO SS
1139 | No | No | No | No | No | No | Yes | NO SS
1137 | Yes | No | No | No | No | Yes | No | Hybrid
1137 | Yes | No | No | No | No | Yes | No | Hybrid
1137 | Yes | No | No | No | No | Yes | No | Hybrid
1137 | Yes | No | No | No | No | Yes | No | Hybrid
1137 | Yes | No | No | No | No | Yes | No | Hybrid
1137 | Yes | No | No | No | No | Yes | No | Hybrid
1137 | Yes | No | No | No | No | Yes | No | Hybrid
1137 | Yes | No | No | No | No | Yes | No | Hybrid
1137 | Yes | No | No | No | No | Yes | No | Hybrid
1137 | Yes | No | No | No | No | Yes | No | Hybrid
1137 | Yes | No | No | No | No | Yes | No | Hybrid
1198 | Yes | No | No | No | No | Yes | No | Hybrid
1164 | Yes | No | No | No | No | No | Yes | Hybrid
11343 | N | N | N | N | N | N | N | None
113435 | No | No | No | N | N | N | N | None
Spreadsheet: 675593d1588360047-refine-sumif-to-include-items-within-a-date-range-001-april-sample-data
Sheet: Ian

 |  | Overall Total
 |  | Filter Totals
Renewal Book Comparison 2019/2020
 |  |  | 2019 |  |  | 2020 |  |  |  | Income Variance
Client | Renewal Date | New / Renewal | Premium Exc IPT | Commission | Fee | Premium Exc IPT | Commission | Fee | Total Commission & Fee | Income Variance (Commision & Fee) | Comments
ABC | 2020-04-01 00:00:00 | Renewal | 102231 | 699 | 3800 | 102895 | 0 | 5000
DEF | 2020-04-04 00:00:00 | Renewal | 330 | 82.5 | 0 | 0 | 0 | 0
EFGT | 2020-04-05 00:00:00 | Renewal | 114820 | 1355 | 5250 | 114870 | 1398 | 5500
EGTF | 2020-04-07 00:00:00 | Renewal | 10601 | 1556 | 1500 | 11674.56 | 1646 | 1500
HSGSJ | 2020-04-09 00:00:00 | Renewal | 106028 | 0 | 5500 | 112049 | 1260 | 5750
HSYSG | 2020-04-16 00:00:00 | Renewal | 18920 | 0 | 3000 | 14306 | 0 | 1800
JHSYGD | 2020-04-20 00:00:00 | Renewal | 870 | 261 | 0 | 872 | 261 | 0
HSYDV | 2020-04-30 00:00:00 | Renewal | 10068 | 1955 | 0 | 15861 | 2760 | 0
[NAME] | 2020-04-15 00:00:00 | New | 0 | 0 | 0 | 1000 | 150 | 500
JDBKDB>KJBV | 2020-04-05 00:00:00 | New | 0 | 0 | 0 | 5000 | 500 | 1500
KJBDKDBVCK | 2020-04-16 00:00:00 | New | 0 | 0 | 0 | 6000 | 500 | 3000
DLKNNKJCB | 2020-04-09 00:00:00 | New | 0 | 0 | 0 | 2000 | 890 | 120
Spreadsheet: 50219d1249590710-vlookup-on-2-values-hot-water-tank-selection
Sheet: HOT WATER TANK SELECTION

Hot Water Tank Selection
Application | HOTEL
PRIVATE LAV | #N/A
PUBLIC LAV
BATHTUBS
DISHWASHERS
FOOT BASINS
KITCHEN SINK
LAUNDRY SINK
PANTRY SINK
SHOWERS
SERVICE SINK
HYDROTHERAPEUTIC SHOWERS
HUBBARD BATHS
LEG BATHS
ARM BATHS
SITZ BATHS
[NAME] FLOW BATHS
CIRCULAR WASH SINKS
SEMICIRCULAR WASH SINKS
DEMAND FACTOR
STORAGE CAPACITY FACTOR
Spreadsheet: 113595d1309446124-macro-to-find-rows-with-duplicates-compare-cells-between-them-and-delete-rows-upload-30jul11_examples-
Sheet: Sheet1

 | 12345 |  |  |  | DLM |  |  |  |  |  |  |  |  | 622e76l0000v
 | 12345 |  |  |  | DLM |  |  |  |  |  |  |  |  | 622e76m0000j
 | 123 |  |  |  | FRA |  |  |  |  |  |  |  |  | 621e76l0000c
 | 1234567890 |  |  |  | FRA |  |  |  |  |  |  |  |  | 621e76l0000c
 | 123456 |  |  |  | HOR |  |  |  |  |  |  |  |  | 623e76n000gw
 | 1234 |  |  |  | JOHNS |  |  |  |  |  |  |  |  | 622e76m000ma
 | 987654321 |  |  |  | MA |  |  |  |  |  |  |  |  | 622e76d0000b
 | 987654321 |  |  |  | MA |  |  |  |  |  |  |  |  | 622e76d0000h
 | 987654321 |  |  |  | MA |  |  |  |  |  |  |  |  | 622e76d00010
 | 1234567890 |  |  |  | MCV |  |  |  |  |  |  |  |  | 622e76l0000v
 | 1234567890 |  |  |  | MCV |  |  |  |  |  |  |  |  | 622e76m0000j
 | 12333 |  |  |  | RG |  |  |  |  |  |  |  |  | 622e76m00007
 | 12334455 |  |  |  | RG |  |  |  |  |  |  |  |  | 622e76m00007
 | WHEN I RUN MACRO THE RESULT IS:
 | 12345 |  |  |  | DLM |  |  |  |  |  |  |  |  | 622e76l0000v
 | 12345 |  |  |  | DLM |  |  |  |  |  |  |  |  | 622e76m0000j
 | 1234567890 |  |  |  | FRA |  |  |  |  |  |  |  |  | 621e76l0000c
 | 1234567890 |  |  |  | MCV |  |  |  |  |  |  |  |  | 622e76l0000v
 | 1234567890 |  |  |  | MCV |  |  |  |  |  |  |  |  | 622e76m0000j
 | I AM TRYING TO PRODUCE THIS RESULT:
 | 12345 |  |  |  | DLM |  |  |  |  |  |  |  |  | 622e76l0000v
 | 12345 |  |  |  | DLM |  |  |  |  |  |  |  |  | 622e76m0000j
 | 1234567890 |  |  |  | FRA |  |  |  |  |  |  |  |  | 621e76l0000c
 | 123456 |  |  |  | HOR |  |  |  |  |  |  |  |  | 623e76n000gw
 | 1234 |  |  |  | JOHNS |  |  |  |  |  |  |  |  | 622e76m000ma
 | 1234567890 |  |  |  | MCV |  |  |  |  |  |  |  |  | 622e76l0000v
 | 1234567890 |  |  |  | MCV |  |  |  |  |  |  |  |  | 622e76m0000j
 | 987654321 |  |  |  | MA |  |  |  |  |  |  |  |  | 622e76d0000b
 | 987654321 |  |  |  | MA |  |  |  |  |  |  |  |  | 622e76d0000h
 | 987654321 |  |  |  | MA |  |  |  |  |  |  |  |  | 622e76d00010
 | 12334455 |  |  |  | RG |  |  |  |  |  |  |  |  | 622e76m00007
Spreadsheet: 234879d1368208826-updating-table-sampledata
Sheet: Jan 13

Date | Customer | Company | Sales | Delivery | Tax | Total | Status
2013-01-01 00:00:00 | [NAME] | RoboCorp | 345.21 | 15 |  |  | 1
2013-01-04 00:00:00 | Jess V | Cheers | 219.91 | 15 |  |  | 1
2013-01-06 00:00:00 | [NAME] | RoboCorp | 100.01 | 0 |  |  | 2
2013-01-06 00:00:00 | [NAME] | EPA | 578.44 | 25 |  |  | 2
2013-01-10 00:00:00 | [NAME] | Business | 47.12 | 0 |  |  | 3
2013-01-15 00:00:00 | [NAME] | HausenKausen | 919.23 | 15 |  |  | 1
2013-01-16 00:00:00 | [NAME] | Duntz | 87.79 | 0 |  |  | 1
2013-01-16 00:00:00 | Suzy Q | LaLaLa | 102.47 | 25 |  |  | 3
2013-01-18 00:00:00 | [NAME] | Business | 99.84 | 0 |  |  | 1
2013-01-20 00:00:00 | Amanda K | HausenKausen | 327.65 | 20 |  |  | 1
2013-01-20 00:00:00 | [NAME] | [NAME] | 156.35 | 15 |  |  | 1
2013-01-25 00:00:00 | [NAME] | RoboCorp | 74.12 | 0 |  |  | 1
2013-01-25 00:00:00 | [NAME] | RoboCorp | 147.03 | 15 |  |  | 2
2013-01-26 00:00:00 | Jess V | Cheers | 94.15 | 25 |  |  | 1
2013-01-30 00:00:00 | [NAME] | Landrover | 156.5 | 20 |  |  | 3
2013-01-30 00:00:00 | [NAME] | Private | 574.18 | 0 |  |  | 1
Spreadsheet: mike_carson__27541__grda
Sheet: Sheet1

 |  |  | Risk |  | #
 | ENT | CIN | Premium | Associated | Days
[NAME] | 34.75 | 38.5 | 2 |  | 320 | fld
JULY | 44.75 | 50.25 | 2 |  | 352 | fld
AUG | 44.75 | 50.25 | 2 |  | 352 | fld
SEP | 23.25 | 26 | 2 |  | 320 | fld
 | July/Aug |  | fld
 | July/Aug/Sep |  | fld
 | * Inputs are in the BLUE Fields.  Update Daily and you should be OK.
Spreadsheet: 119956d1314886742-help-matching-specific-cells-with-a-hierarchy-find-macro-excel-help
Sheet: New

EP# | Material | Description
0002 | 107283 | BOX, ELECTRICAL, 3/4 IN, FS-FD, APPLETON ELECTRIC CO P/N FDC-1-75-A
0002 | 106625 | BUMPER, FOR DOCK, P/N RH412-14 12X14X4 PROJECTION
0002 | 108014 | CLAMP, BEAM, STRUT TO BEAM, ZINC PLATED, 13/16 - 1-5/8 IN STRUT, B-LINE SYSTEMS INC P/N B441-22
0002 | 106613 | CONTROLLER, RAMP, ASSEMBLY, WITH BAR, FOR RITE-HITE DOCK LOK, RITE-HITE CORP P/N 503
0002 | 107206 | COVER, BOX, ALUMINUM, FOR FS-FD BOX, APPLETON ELECTRIC CO P/N FSK-1B-CA
0002 | 108126 | GRIP, CORD, 3/4 IN, [NAME], 0.450 - 0.500 DIAMETER, STRAIGHT, WATER/OIL TIGHT, APPLETON ELECTRIC CO P/N CG-3775
0002 | 108005 | KIT, HEAT TRACE, SPLICE AND TEE, SR TRACE P/N SRST
0002 | 111027 | SPRING, DOCKPLATE, FOR RITE-HITE DOCK HANDLE RETURN, P/N 52111
0004 | 112090 | BODY, COUPLER, BRASS, 1/2" FPT, FOR COATER AIR PUMPS, DIXON P/N STFC4
0004 | 102859 | CONNECTOR, QUICK CONNECT, 2 IN, 316 STAINLESS STEEL, FNPT, P/N 733A
0004 | 102867 | CONNECTOR, QUICK CONNECT, 2 IN, FEMALE, 316 STAINLESS STEEL, OPW, HOSE SHANK
0004 | 102928 | GASKET, 2 IN, 200G NEOPRENE GSKT., FOR QUICK CONNECT COUPLER P/N H1893M
0004 | 102929 | HANDLE, REPAIR, FOR COUPLER, DIXON P/N 200-HRR-SP
0004 | 109748 | KIT, REPAIR, FOR ARO AIR MOTOR, ARO P/N 637302
0004 | 109749 | KIT, REPAIR, FOR ARO PUMP, ARO P/N 637309-AA
0004 | 112089 | PLUG, COUPLER, BRASS, 1/2" MPT, FOR COATER AIR PUMPS, DIXON P/N STMP4B
0004 | 111224 | SEAT, ITEM 21, FOR ARO PUMP, P/N 94328-A
0004 | 102332 | VALVE, BALL, 1/2 IN, BRASS, NELES-JAMESBURY P/N 1/2 451T
0006 | 107183 | CONNECTOR, CONDUIT, SEALTITE, 1/2 IN, 45 DEGREE, APPLETON ELECTRIC CO P/N ST-4550
0006 | 108417 | CONNECTOR, CONDUIT, SEALTITE, 3/8 IN, STRAIGHT, APPLETON ELECTRIC CO P/N ST-38
0006 | 109757 | PUMP, VACUUM, WITH MOTOR, FOR LAB BUILDING
0007 | 106290 | GUN, SPRAY, SPRAYING SYSTEMS CO P/N 36533-60
Spreadsheet: 48446d1247663029-averages-and-counts-on-volumes-daily-trade
Sheet: Sheet1

B/S | Volume | Product | Price | AvgFillPrice | ResVolume | ExecVolume | Status | UpdateTimestamp | ID | Timestamp
Sell | 1 | FESX-AEX | 150 | 149.7 | 0 | 1 | Filled | 2009-07-14 12:57:47 | 84240741 | 2009-07-14 12:56:21 |  |  | FESX-AEX | FESX-CAC | FESX-DAX | FESX-CAC-AEX | FESX-DAX-AEX | FESX-CAC-DAX | 4way | CAC-DAX
Sell | 1 | FESX-AEX | 150 | 149.4 | 0 | 1 | Filled | 2009-07-14 12:57:49 | 84240743 | 2009-07-14 12:56:21 |  | Count
Sell | 2 | FESX-AEX | 149.5 | 148.8 | 0 | 2 | Filled | 2009-07-14 12:48:03 | 84240711 | 2009-07-14 12:45:35 |  | Buy
Sell | 2 | FESX-AEX | 147.5 | 147.2 | 0 | 2 | Filled | 2009-07-14 12:45:26 | 84240671 | 2009-07-14 12:35:07 |  | Sell
Buy | 1 | FESX-DAX | -259.5 | -258.7 | 0 | 1 | Filled | 2009-07-14 08:38:16 | 84220794 | 2009-07-14 08:37:03 |  | Buy Average
Buy | 1 | FESX-DAX | -259.5 | -258.7 | 0 | 1 | Filled | 2009-07-14 08:38:16 | 84220796 | 2009-07-14 08:37:03 |  | Sell Average
Sell | 2 | FESX-AEX | 145.5 | 146 | 1 | 1 | Deleted | 2009-07-14 07:00:19 | 84200169 | 2009-07-14 07:00:12
Sell | 2 | FESX-CAC | 47 | 48.5 | 1 | 1 | Deleted | 2009-07-14 07:00:46 | 84200122 | 2009-07-14 07:00:11
 |  |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  |  | Average
Spreadsheet: 855406d1704981404-look-up-and-return-not-a-normal-criterira-aqu-1-12-ans
Sheet: Shipping form

Ship To: |  | 31001501
Despatch Date: |  | 2023-12-01 00:00:00
Day: |  | Friday
Delivery Note #: |  | 5506 - 5512
MFG | OGL | Cust # | Description | P/O | Qty on P/O | QOH | [NAME] | [NAME]Number
74210182 | MC2115 | 655301 | AQU02 | 7015887 | 137 | 0 | 137 | 5506
74210182 | MC2115 | 655301 | AQU02 | 7016005 | 343 | 0 | 343 | 5507
72210519 | AQU032S | AQU032S | AQU03 | 7016047 | 187 | 0 | 192 | 5508
74210125 | MC2108 | 448803 | AQU02 | 7016047 | 240 | 0 | 410 | 5508
72210517 | AQU006S | AQU006S | AQU03 | 7016100 | 608 | 0 | 407 | 5509
74210171 | MC2057 | 239803 | AQU02 | 7016100 | 301 | 0 | 346 | 5509
72210522 | AQU036S | AQU036S | AQU03 | 7016100 | 908 | 0 | 954 | 5509
72210535 | AQU037S | 247013 | AQU03 | 7016100 | 1000 | 0 | 1858 | 5509
72210587 | AQU138 | 407101 | AQU05 | 7016100 | 6000 | 0 | 6000 | 5509
74210123 | MC2107 | 449003 | AQU02 | 7016100 | 528 | 0 | 512 | 5509
74210100 | AQU068 | 483003 | AQU04 | 7016100 | 800 | 0 | 400 | 5509
74210110 | AQU069 | 483103 | AQU04 | 7016100 | 1104 | 0 | 704 | 5509
74210133 | AQU105PR | 703944 | AQU03 | 7016100 | 1000 | 0 | 1000 | 5509
74210143 | AQU112PR | 704836 | AQU03 | 7016100 | 600 | 0 | 600 | 5509
74210182 | MC2115 | 655301 | AQU02 | 7016213 | 800 | 0 | 36 | 5510
74210185 | MC2058 | 193703 | TEMO LVR CVR RING CR | 7016245 | 106 | 0 | 106 | 5511
74210185 | MC2058 | 193703 | TEMO LVR CVR RING CR | 7016245 | 1200 | 0 | 127 | 5511
74210181 | MC2104 | 655501 | AQU02 | 7016270 | 1536 | 0 | 1107 | 5512
Number of Pallets |  | x2 pallets |  | Total Qty Shipped |  |  | 15239
Total Carriage £ Charge |  | £120 (on 5506) |  | Number of Parts |  |  | 18
Sent By: |  |  |  | Total Boxes |  |  | 35
Confirmation that this shipment is correct in terms of quantity and quality:
[NAME] (print name):…………………… |  |  |  | Transport Name:……………………...
Sign:……………………....................... |  |  |  | Date:……………………………………
Spreadsheet: 107609d1304720446-copying-multiple-columns-into-single-row-excel-issue
Sheet: output

 | Return on assets |  |  |  |  | Return on equity |  |  |  |  | Current ratio
company "A" | -0.1355283944458302 | -0.004214359596857609 | 0.07733865496699563 | 0.07356177583212391 | 0.09791454655831264 | 0.4449094713856792 | -0.03646719431910644 | 0.1261204515722661 | 0.1606001973820902 | 0.1594770554995629 | 0.2319686411149826 | 0.4087801217376803 | 0.9403198172472872 | 1.789343965204784 | 0.8489134295585908
company "B" | 0.009146393272688532 | -0.04653300040291228 | -0.05481229460043081 | 0.007620341029123284 | 0.02548828431246775 | 0.05321640985077805 | -0.3165285620004399 | -0.4175902244955954 | 0.06668576838748255 | 0.1539064046616917 | 2.38419855552452 | 2.016933261901117 | 2.073707270042349 | 2.093521972294437 | 1.925402536603454
company "C" | 0.1018091299470296 | -0.148623009749071 | -0.6903166076784354 | -0.2754837091159961 | -0.2716170656576682 | 0.2364745416244514 | -0.4720763614927674 | 4.603205736242183 | 0.6061519778650236 | 0.2844232039147294 | 0.7643643382944335 | 0.9270019362423069 | 1.429731914320356 | 1.143366867406969 | 0.8649672338123009
Spreadsheet: 151418d1334910690-to-extract-data-from-sheet1-to-sheet2-test-data
Sheet: Sheet1

Sl. No. | Dept | Names
1 | [NAME] | Name-01
 | [NAME] | Name-02
 | [NAME] | Name-03
 | Civil | Name-04
 | Civil | Name-05
 | Civil | Name-06
 | Civil | Name-07
 | [NAME] | Name-08
 | [NAME] | Name-09
 | [NAME] | Name-10
 | Consul | Name-11
 | Consul | Name-12
 | Consul | Name-13
 | Consul | Name-14
 | Consul | Name-15
 | Consul | Name-16
 | Consul | Name-17
 | HR | Name-18
 | HR | Name-19
 | HR | Name-20
 | HR | [NAME]
 | HR | Name-22
 |  | FINISHED FILES ARE THE RESULT OF YEARS OF SCIENTIFIC STUDY COMBINEDWITH THE EXPERIENCE OF YEARS
Spreadsheet: kimberly_watson__20556__imbalsumm0109
Sheet: EPFS

 | El Paso/TW Eddy Rec
 | 78093
Day | Measured | Scheduled
1 | 35974 | 36623
2 | 35392 | 33797
3 | 33223 | 35432
4 | 31492 | 36700
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
2001-08-31 00:00:00 |  |  | -36026
2001-09-04 00:00:00
CBS Volume
 |  |  | -1369
Spreadsheet: 162695d1340034637-average-of-last-5-in-a-table-spreadsheet
Sheet: Sheet1

[NAME] | [NAME] | [NAME] 3 | WEEK 1     (30/4 - 6/5) | WEEK 2     (7/5 - 13/5) | WEEK 3     (14/5 - 20/5) | WEEK 4     (21/5 - 27/5) | WEEK 5     (28/5 - 3/6) | WEEK 6     (4/6 - 10/6) | WEEK 7     (11/6 - 17/6) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AVERAGE
 |  |  | RATE 1-9 | RATE 1-9 | RATE 1-9 | RATE 1-9 | RATE 1-9 | RATE 1-9 | RATE 1-9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RATE 1-9
HEAVY DUTY WANEY | PANELS | 2ft Flat | 1.25 | 1.25 | 1.25 | 1 | 1 | 1 | 1
HEAVY DUTY WANEY | PANELS | 3ft Flat | 1.3 | 1.3 | 1.3 | 1.15 | 1.15 | 1.15 | 1.15
HEAVY DUTY WANEY | PANELS | 4ft Flat | 1.35 | 1.35 | 1.35 | 1.3 | 1.21 | 1.3 | 1.3
HEAVY DUTY WANEY | PANELS | 5ft Flat | 1.4 | 1.4 | 1.4 | 1.4 | 1.35 | 1.4 | 1.4
HEAVY DUTY WANEY | PANELS | 6ft Flat | 1.45 | 1.45 | 1.45 | 1.45 | 1.45 | 1.45 | 1.45
HEAVY DUTY WANEY | PANELS | 7ft Flat
HEAVY DUTY WANEY | CUT DOWNS WIDTH | 2ft Flat |  |  |  | 1.11 | 1.11 | 1.11 | 1.35
HEAVY DUTY WANEY | CUT DOWNS WIDTH | 3ft Flat |  | 1.29 | 1.29 | 1.33 | 1.2 | 1.33 | 1.33
HEAVY DUTY WANEY | CUT DOWNS WIDTH | 4ft Flat | 1.75 | 2 | 1.55 | 1.5 | 1.5 | 1.5 | 1.67
HEAVY DUTY WANEY | CUT DOWNS WIDTH | 5ft Flat | 1.75 | 2 | 1.55 | 1.82 | 1.6 | 1.6 | 1.74
HEAVY DUTY WANEY | CUT DOWNS WIDTH | 6ft Flat | 1.75 | 1.75 | 1.75 | 1.5 | 1.5 | 1.5 | 1.5
HEAVY DUTY WANEY | CUT DOWNS WIDTH | 7ft Flat | 1.75 | 1.75 | 1.75 | 1.75 | 1.75 | 1.75 | 1.75
HEAVY DUTY WANEY | CUT DOWNS HEIGHT | 2ft Flat | 1.75 | 1.75 | 1.75 | 1.75 | 1.75 | 1.75 | 1.75
HEAVY DUTY WANEY | CUT DOWNS HEIGHT | 3ft Flat | 1.75 | 1.75 | 1.75 | 1.75 | 1.75 | 1.75 | 1.5
HEAVY DUTY WANEY | CUT DOWNS HEIGHT | 4ft Flat | 1.75 | 1.75 | 1.75 | 1.75 | 1.75 | 1.75 | 1.75
HEAVY DUTY WANEY | CUT DOWNS HEIGHT | 5ft Flat | 2 | 2 | 2 | 2 | 1.8 | 2 | 2
HEAVY DUTY WANEY | CUT DOWNS HEIGHT | 6ft Flat | 2 | 2 | 2 | 2 | 2 | 2 | 2
HEAVY DUTY WANEY | CUT DOWNS HEIGHT | 7ft Flat | 2 | 2 | 2 | 2 | 2 | 2 | 2
Spreadsheet: 808796d1670663743-2-formulas-subtract-from-specific-columns-formulatest-gk-
Sheet: Data

Department | Name | Target | 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
DepC | Person19 | 68 | 1613 | 1749 | 2006 | 2234 | 1532 | 2023 | 1910
DepC | Person21 | 9 | 2045 | 1794 | 2409 | 2253 | 1669 | 1758 | 1901
DepC | Person23 | 4987 | 2322 | 2347 | 2450 | 2365 | 2078 | 1867 | 2098
DepC | Person25 | 9848 | 1828 | 1866 | 1880 | 1956 | 2172 | 2394 | 1566
DepC | Person27 | 18 | 1965 | 1785 | 2453 | 2469 | 1927 | 2096 | 1681
[NAME] | [NAME] | 897 | 2151 | 2410 | 1845 | 2154 | 2283 | 1952 | 2426
[NAME] | Person22 | 598 | 1591 | 1825 | 2033 | 2380 | 1649 | 1510 | 1596
[NAME] | Person24 | 98 | 1514 | 2380 | 1576 | 1877 | 2481 | 2485 | 1515
[NAME] | Person26 | 99 | 1597 | 2164 | 2342 | 2489 | 2176 | 1915 | 1805
[NAME] | Person28 | 9 | 1746 | 2164 | 1581 | 1829 | 1520 | 1781 | 1608
DeptA | Person1 | 1750 | 1929 | 2361 | 2391 | 2304 | 2127 | 1746 | 2071
DeptA | Person1 | 1750 | 1911 | 1960 | 2050 | 2054 | 2279 | 1866 | 2159
DeptA | Person1 | 1750 | 1619 | 1734 | 1611 | 1908 | 1962 | 1628 | 2163
DeptA | Person11 | 1255 | 1669 | 1815 | 2430 | 2463 | 2172 | 2405 | 1825
DeptA | [NAME] | 654 | 2411 | 1641 | 1634 | 1800 | 1905 | 1843 | 2183
DeptA | Person15 | 651 | 2394 | 2393 | 2147 | 2230 | 1634 | 2005 | 2431
DeptA | Person17 | 651 | 2470 | 1663 | 2390 | 2030 | 2363 | 1938 | 1571
DeptA | Person7 | 2485 | 1830 | 2233 | 1596 | 2359 | 2034 | 2116 | 1545
DeptA | Person9 | 251 | 2311 | 2082 | 1657 | 1662 | 1737 | 1931 | 2210
DeptB | Person1 | 1750 | 2083 | 1607 | 1691 | 1947 | 1655 | 1916 | 1677
DeptB | Person10 | 25455 | 2473 | 1547 | 1624 | 2322 | 1707 | 1756 | 1742
DeptB | Person12 | 255 | 2270 | 1878 | 2402 | 2152 | 1791 | 2335 | 2069
DeptB | Person14 | 654 | 2323 | 2482 | 2404 | 2103 | 2337 | 1577 | 2391
DeptB | Person16 | 651 | 1666 | 1924 | 1625 | 2150 | 2227 | 1807 | 1986
DeptB | Person18 | 651 | 2485 | 2002 | 2114 | 1991 | 1510 | 1852 | 2416
DeptB | Person2 | 1300 | 2048 | 2017 | 1805 | 1865 | 2202 | 2101 | 2280
DeptB | Person6 | 1250 | 2094 | 1538 | 1885 | 1848 | 2190 | 2276 | 1856
DeptB | Person8 | 2552 | 1851 | 1670 | 1750 | 1612 | 2158 | 2018 | 2234