tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 528408d1500363287-return-unique-list-based-on-multiple-criteria-book1-recovered-
Sheet: Act. Report

Department | Expense Type | Service
DEP1 | Maintenance | [NAME]
DEP2 | Improvement | Building Improvement
[NAME] | Improvement | Internet maintenance |  |  |  |  |  |  |  |  |  | DEP1
[NAME] | Improvement | Internet maintenance |  |  |  |  |  |  |  |  |  | DEP2
DEP5 | Improvement | Generator support |  |  |  |  |  |  |  |  |  | [NAME]
DEP6 | Improvement | Internet maintenance |  |  |  |  |  |  |  |  |  | [NAME]
DEP1 | Improvement | Internet maintenance |  |  |  |  |  |  |  |  |  | DEP5
DEP2 | Improvement | Internet maintenance |  |  |  |  |  |  |  |  |  | DEP6
[NAME] | Maintenance | Internet maintenance
[NAME] | Maintenance | Internet maintenance
DEP5 | Maintenance | Generator support
DEP6 | Maintenance | Internet maintenance
DEP1 | Improvement | Generator support
DEP2 | Improvement | Internet maintenance
[NAME] | Improvement | Internet maintenance
[NAME] | Improvement | Internet maintenance
DEP5 | Improvement | Internet maintenance
DEP6 | Improvement | Internet maintenance
DEP1 | Improvement | Internet maintenance
DEP2 | Improvement | Generator support
[NAME] | Improvement | Internet maintenance
[NAME] | Improvement | Internet maintenance
DEP5 | Improvement | [NAME] support
DEP6 | Improvement | Generator support
DEP1 | Improvement | Internet maintenance
DEP2 | Improvement | RBS Salary
[NAME] | Improvement | RBS Salary
[NAME] | Improvement | RBS Salary
DEP5 | Improvement | Generator support
DEP6 | Improvement | Generator support
DEP1 | Improvement | Generator support
DEP2 | Improvement | Generator support
[NAME] | Improvement | Generator support
[NAME] | Improvement | Generator support
DEP5 | Maintenance | Generator support
DEP6 | Maintenance | Generator support
DEP1 | Maintenance | Generator support
DEP2 | Improvement | Generator support
[NAME] | Improvement | Internet maintenance
[NAME] | Improvement | Internet maintenance
DEP5 | Improvement | Internet maintenance
DEP6 | Improvement | Internet maintenance
DEP1 | Improvement | Internet maintenance
DEP2 | Maintenance | Internet maintenance
[NAME] | Maintenance | Internet maintenance
[NAME] | Maintenance | Internet maintenance
DEP5 | Maintenance | Internet maintenance
DEP6 | Maintenance | Internet maintenance
DEP1 | Maintenance | Internet maintenance
DEP2 | Maintenance | Internet maintenance
[NAME] | Maintenance | Internet maintenance
[NAME] | Improvement | Internet maintenance
DEP5 | Improvement | Internet maintenance
DEP6 | Improvement | Internet maintenance
Spreadsheet: 813375d1673704054-formula-to-grouping-data-grouping-data-1-
Sheet: Sheet1

 |  | abc | xyz | Amount
 |  | 1 a | aa | 3000 |  |  | 3000 |  |  |  |  | abc | Amount |  |  | 3000
 |  | 1 a | bb | 2000 |  |  | 2000 |  |  |  |  | 1 a | 3000 |  |  | 2000
 |  | 2 a | cc | 4000 |  | Sub Total | 5000 |  |  |  |  | 1 a | 2000 |  | Sub Total | 5000
 |  | 2 a | cc | 5000 |  |  | 5000 |  |  |  |  | 2 a | 4000 |  | 1b | 5000
 |  | 2 a | cc | 6000 |  | 1b | 2500 |  |  |  |  | 2 a | 5000 |  | Sub Total | 5000
 |  | 3 a | dd | 7000 |  | Sub Total | 2500 |  |  |  |  | 2 a | 6000 |  | 2 a | 4000
 |  | 3 a | dd | 8000 |  | 2 a | 4000 |  |  |  |  | 3 a | 7000 |  |  | 5000
 |  | 3 a | dd | 9000 |  |  | 5000 |  |  |  |  | 3 a | 8000 |  |  | 6000
 |  | 3 a | dd | 10000 |  |  | 6000 |  |  |  |  | 3 a | 9000 |  | Sub Total | 15000
 |  | 3 a | dd | 9000 |  | Sub Total | 15000 |  |  |  |  | 3 a | 10000 |  | 3 a | 7000
 |  | 1b | ee | 2500 |  | 3 a | 7000 |  |  |  |  | 3 a | 9000 |  |  | 8000
 |  |  |  |  |  |  | 8000 |  |  |  |  | 1b | 5000 |  |  | 9000
 |  |  |  |  |  |  | 9000 |  |  |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | 10000 |  |  |  |  |  |  |  |  | 9000
 |  |  |  |  |  |  | 9000 |  |  |  |  |  |  |  | Sub Total | 43000
 |  |  |  |  |  | Sub Total | 43000 |  |  |  |  |  |  |  | Grand Total | 68000
 |  |  |  |  |  | Grand Total | #N/A
Spreadsheet: 191126d1351925016-comparative-calculations-in-pivot-book2
Sheet: Sheet1

Item Code | [NAME] | Quantity | Rate | Value
ABC | 1 | 5 | 2
ABC | 2 | 4 | 2.5
XYZ | 3 | 10 | 5
PQR | 4 | 15 | 8
ABC | 5 | 3 | 4
PQR | 6 | 8 | 4
PQR | 7 | 25 | 4
PQR | 8 | 20 | 3.5
XYZ | 9 | 10 | 5.5
ABC | 10 | 5 | 3.5
XYZ | 11 | 10 | 7.5
XYZ | 12 | 8 | 6
XYZ | 13 | 10 | 6
PQR | 14 | 10 | 4.5
PQR | 15 | 15 | 4.5
PQR | 16 | 10 | 4.5
Spreadsheet: 848250d1699008274-require-a-formula-to-extract-2-dates-from-a-string-and-place-them-into-2-separate-cells-example-of-date-formula-results-and-errors-aligw
Sheet: Sheet1

 | Date Type | Transpose [NAME] |  |  |  |  |  |  | Current Status using this formula
 | 11/03/2022 - 12/04/2022 |  | 2022-04-12 00:00:00 |  |  |  |  |  | [NAME] |  |  |  |  |  | 44663
 | 11/10/2022 : 15/10/2022 : 27/03/2023 |  | 2022-10-15 00:00:00 | 2023-03-27 00:00:00 |  |  |  |  | [NAME] |  | 15/10/2022 | 27/03/2023 |  |  | 44849 | 45012
 | 11/10/2023, 12/10/2023 |  | 2023-10-12 00:00:00 |  |  |  |  |  | [NAME] |  | 12/10/2023 |  |  |  | 45211
 | 10-10-2023, 12-10-2023, 13/10/2023, 15/10/23 |  | 2023-10-12 00:00:00 | 2023-10-13 00:00:00 | 2023-10-15 00:00:00 |  |  |  | [NAME] |  | 12-10-2023 | 13/10/2023 | 15/10/23 |  | 45211 | 45212 | 45214
 | 11/10/2023 to 15/10/2023 |  | 2023-10-12 00:00:00 | 2023-10-13 00:00:00 | 2023-10-14 00:00:00 | 2023-10-15 00:00:00 |  |  | [NAME] Cant Handle data |  |  |  |  |  | 45211 | 45212 | 45213 | 45214
 | 2023-10-10 00:00:00 |  |  |  |  |  |  |  | [NAME] Cant Handle data
 | 11.10.2023 to 12.10.2023 |  | 2023-10-12 00:00:00 |  |  |  |  |  | [NAME] Cant Handle data |  |  |  |  |  | 45211
Spreadsheet: 4c512b42-bed5-4d78-9793-1f032dfc5c55
Sheet: Sheet1

 | Complete the information in the yellow areas to calculate the pass rates.
 | Year | All Students Taking Exam | First-Time Passes | Annual Pass Rate | Running 5-Year Average Pass Rate |  |  | High School GPA
Past 5 Years | 2001 | 14 | 10 |  |  |  |  | 3.6
 |  | 16 | 11 |  |  |  |  | 2.9
 |  | 13 | 11 |  |  |  |  | 3.7
 |  | 14 | 12 |  |  |  |  | 3.8
 |  | 15 | 14 |  |  |  |  | 3.9
Current 5 Years |  | 17 | 17 |  |  |  |  | 3.6
 |  | 12 | 11 |  |  |  |  | 3.7
 |  | 13 | 11 |  |  |  |  | 3.8
 |  | 13 | 10 |  |  |  |  | 3.5
 |  | 14 | 6 |  |  |  |  | 2.4
 | Year | All Students Taking Exam | First-Time Passes | Annual Pass Rate
 | Correlation of # of Examinees with Annual Pass Rate (to determine if "class size" affects pass rate.)
 | Correlation of High School GPA with Annual Pass Rate (to determine if "GPA" affects pass rate.)
Spreadsheet: 757495d1638292424-get-results-from-large-data-in-excel-o365-tracking
Sheet: Tickets Created -O365

Tickets created for Office 365
 | Total | Unknown O365 tickets | Assistance/Questions | [NAME]
MFA
Sharepoint
Teams
OneDrive
Outlook
InfoPath
OneNote
Powerpoint
Excel
Word
General O365
Incidents assigned to | A.TEC.BNL.CPI.WORKPLACE-MGT.BE
Incidents assigned to | A.TEC.BNL.CPI.WORKPLACE-MGT.NL
Workplace incidents NL |  |  |  |  | Workplace incidents NL
Short description | Number | Created By |  |  | Short description | Number | Created By
Spreadsheet: 63249d1264166950-another-nascar-pool-with-pts-and-rankings-nascar-pool
Sheet: race results

 | RACE RESULTS
FINISH POS | RACE 1 | RACE 2 | RACE 3 | RACE 4 | RACE 5
1 | 5 | 1
2 | 7 | 9
3 | 8 | 55
4 | 10 | 2
5 | 1 | 6
6 | 3 | 10
7 | 15 | 3
8 | 60 | 5
9 | 2 | 4
10 | 6 | 7
 |  |  | RACE RESULTS LISTED IN ORDER OF FINISH WITH DRIVER NUMBER
Spreadsheet: mary_fischer__25627__1292
Sheet: E2.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  1292
COMPANY NAME    Marlin Fair Value Co.
ANALYSIS OF OTHER CURRENT ASSETS
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-2
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
Hyperion Line 0189 - Fair Value Investment (current)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Total Current Assets | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 195
Asset/Expense Accts:  DR/(CR)
Spreadsheet: 177601d1346355656-how-to-populate-workbook-pages-from-microsoft-query-copy-of-total-misses-for-period-6
Sheet: 9-398

 |  |  |  |  |  |  |  | 9-398
 |  |  |  |  |  |  |  | TOTAL MISSES FOR THIS PAY PERIOD
CHPUB | CHACT# | CHDIST | CHRTE | CHTIME | CHTTYP | CHTRCD | UNNBR | PREDIR | STREET | SUFFIX | PSTDIR | SUNTYP | SUNNBR | POZIP5 | CHSTAT | CHSMM | CHSDD | CHSYY
Spreadsheet: 76e059f6-4811-44ec-a2d0-ac746d716d43
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
BAYL | Test | BAYL | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
BAYL | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
BAYL | Result | BAYL | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7125-8 | Laurus nobilis Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 117df557-de35-4beb-a9bb-ee3cafe57b6e
Sheet: Tabla 16

DIAGNÓSTICO SITUACIONAL
6. Resumen del análisis integrado del diagnóstico situacional
Tabla 16. Superposición de intervenciones específicas en implementación actual desde otros sectores para las EID (Adicionalmente identifique por cada actividad si hay programas en desarrollo para estas actividades específicas: suministro de filtros de agua, mejoramiento de vivienda, etc. También mencione las instituciones que las están ejecutando)
Actividad | Educación | Desarrollo y vivienda | Obras públicas | Agricultura | Medio ambiente | Cultura y deportes | Transporte | Comunicaciones
Acceso a agua apta para consumo humano
Servicios mejorados de saneamiento
Mejoramiento de vivienda y su entorno
[NAME] [NAME] pobreza
Desarrollo de actividades productivas
Educación en salud y [NAME] saludables
Mejoramiento de infraestructura y [NAME]
[NAME] y participación comunitaria
Spreadsheet: 881454d1729525932-help-to-check-2-columns-against-2-columns-in-a-separate-tab-excel-help
Sheet: Table1

Column1 | Column2 | Column1.1 | Column2.1
a | 1 | a | 1
b | 1 | b | 1
c | 2 | c | 2
d | 2 | d | 2
e | 3 | e | 3
f | 4 | f | 4
g | 5 | g | 5
h | 6 | h | 6
 |  | i | 7
i | 6
Spreadsheet: 751618d1634210920-need-a-formula-for-the-column-letter-to-use-in-indirect-ytd-formula-v2
Sheet: COPY

 | 5
 |  | 2020-07-31 00:00:00 | 0.01
 |  | 2020-08-31 00:00:00 | 0.01
 |  | 2020-09-30 00:00:00 | 0.01
 |  | 2020-10-31 00:00:00 | 0.01
 |  | 2020-11-30 00:00:00 | 0.01
 |  | 2020-12-31 00:00:00 | 0.01
 |  | 2021-01-31 00:00:00 | 0.01 |  | 0.01
 |  | 2021-02-28 00:00:00 | 0.01 |  | 0.01
 |  | 2021-03-31 00:00:00 | 0.01 |  | 0.01
 |  | 2021-04-30 00:00:00
 |  | 2021-05-31 00:00:00
 |  | 2021-06-30 00:00:00
 |  | 2021-07-31 00:00:00
 |  | 2021-08-31 00:00:00
 |  | 2021-09-30 00:00:00
 |  | 2021-10-31 00:00:00
 |  | 2021-11-30 00:00:00
 |  | 2021-12-31 00:00:00
 |  | 2022-01-31 00:00:00
 |  | 2022-02-28 00:00:00
 |  | 2022-03-31 00:00:00
 |  |  |  |  |  | replaces match row
 |  |  |  | use vADDr directly |  | replaces range number for product formula
 |  |  |  | use vADDr in a cell reference |  | replaces the column letter (to count how many months)
 |  |  |  | vADDr formula ------>
 |  |  | beg of year date | 2021-01-31 00:00:00 |  | range needs to start at A1
Spreadsheet: 871624d1718047747-how-to-copy-paste-all-rows-and-columns-of-data-from-one-sheet-to-another-sheet-2024_commissions_dale-inc-commission-report
Sheet: Sheet13

 | COMMISSION FORECAST (2024)
 |  |  |  |  |  | AMOUNT PAID TO DATE
1 | JANUARY | no commission | $10k draw
2 | FEBRUARY | no commission | $10k draw |  | Q1
3 | [NAME]
4 | APRIL
5 | MAY |  |  |  | Q2
6 | [NAME]
7 | JULY
8 | AUGUST |  |  |  | Q3
9 | SEPTEMBER
10 | OCTOBER
11 | NOVEMBER |  |  |  | Q4
12 | DECEMBER
 | TOTAL
Spreadsheet: 881053d1728980573-combine-arrays-into-1-array-to-make-to-1-array
Sheet: Sheet2

Department | Code | Sales | Cost |  |  | Department | Sales | Cost | no of code
Sales | A | 500 | 52 |  |  |  | 1500
Sales | B | 1000 | 36 |  |  | Finance | 1000 | 47 | 2
Finance | C | 300 | 17 |  |  | Marketing | 1100 | 48 | 2
Marketing | D | 500 | 33
Marketing | E | 600 | 15
Finance | F | 700 | 30
 |  |  |  |  |  | from Green
 |  |  |  |  |  |  | 1500 | 88 | 2
 |  |  |  |  |  | Finance | 1000 | 47 | 2
 |  |  |  |  |  | Marketing | 1100 | 48 | 2
 |  |  |  |  |  | Is there a way to make G2:J4 a Array without using [NAME] like the yellow???
Spreadsheet: 26859d1219424886-need-formula-sum-based-on-boxes-marked-c-and-g-form
Sheet: PACK SHEET

SETUP |  |  |  |  |  |  |  | Breakdown
(PRICE INCLUDES $300.00 PAK AND ESCORT FEES) |  |  |  |  |  |  |  |  | Stock Units Additional |  |  | 350
 |  |  |  |  |  |  |  |  | Triple Units Additional |  |  | 450
Single Wides
 | 12 & 14 Wides |  |  | 2980 |  |  |  | Furniture |  |  |  |  | Credit
 | 16 Wides |  |  | 3230 |  |  |  |  | Funiture / Décor |  |  | 3300 | 2050
 |  |  |  |  |  |  |  |  | Furniture / Décor |  |  | 2500 | 1450
Double Wides
 |  | 24& 28 Wides |  |  |  |  |  | Washer & Dryer
 | 0-52 Length |  |  | 5585 |  |  |  |  | All deals |  |  | 750
 | 53-64 Length |  |  | 5785
 | 65-80 Length |  |  | 5985 |  |  |  | Tag & Title
 |  | 32 Wides |  |  |  |  |  |  | Single Units |  |  | 250
 | 0-64 Length |  |  | 6135 |  |  |  |  | Double Wides |  |  | 450
 | 65-80 Length |  |  | 6385
 |  |  |  |  |  |  |  | Water Test     (Unless we have bill prior to month end)
 |  | Tag Units |  |  |  |  |  |  | In House |  |  | 225
 | Additional to Above |  |  | 1900 |  |  |  |  | Other |  |  | 400
 | Transport / per mile over 70 mile radius |  |  |  |  |  |  | [NAME]  (Unless we have bill prior to month end)
 |  |  |  | 5 | 0 |  |  |  | Charge Deal |  |  | 400
 | Oversize Permit |  |  | 50
 | Over Heighth Permit |  |  | 0 |  |  |  | Eng. Certification  (Unless charged on settlement stmt)
 | Perimeter Stands / each |  |  | 22 | 0 |  |  |  | Charge actual amount |  |  | 0
 | [NAME] |  |  | 0
 | Removal of axels on used home at lot / each house |  |  | 50 |  |  |  | Heatpump Package - 13 Seer
 |  |  |  |  | 0 |  |  |  | 2 ton with 10kw heat strips
 | If required |  |  |  |  |  |  |  |  |  |  | 2200
 | Install Ridge Vent |  |  | 75 |  |  |  |  | 2.5 ton with 10kx heat strips
 | Vapor Barrior |  |  | 150 |  |  |  |  |  |  |  | 2225
[NAME] |  | (Use attach price sheet for unit cost) |  |  |  |  |  |  | 3 ton with 10kw heat strips |  |  | 2350
 | All units / Additional to actual cost |  |  | 200 |  |  |  |  | 3.5 ton with 15kw heat strips |  |  | 2450
 | ReHooks |  |  | 750 |  |  |  |  | 4 ton with 15kw heat strips
 | [NAME] |  |  | 0 |  |  |  |  |  |  |  | 2750
Skirting |  |  |  |  |  |  |  |  | 5 ton with 15kw heat strips
 |  |  |  |  |  |  |  |  |  |  |  | 2950
 | STD. [NAME] (all units up to 66') |  |  | 750
 | STD. [NAME] (all units up to 66'& over) |  |  | 850 |  |  |  |  | Sub TOTAL
 | Lap to ground |  |  | 1550 |  |  |  |  | Minus Credits
 | Rock Skirting |  |  | 1950 |  |  |  |  | Base Price
 | Rock Skirting - 48" Panels |  |  | 2050 |  |  |  |  | TOTAL |  |  | 0
 | FHA Skirting |  |  | 1050
Steps      ***IF FLOOR PLAN HAS 3 DOORS IT IS MANDATORY TO ORDER 3 STEPS REGARDLESS OF COUNTY CODES****
 | 2 Code (All Deals) |  |  | 600
 | 3 Code |  |  | 900
Spreadsheet: 818380d1676788722-automatically-copy-multiple-sheets-into-one-sheet-sample-file-1-
Sheet: Team 2

Department | Sub Dept | Area Owner | Supervisor | Reportees | Month | Completion Date | Completion Status
Department 2 | Sub 2 | Area Owner 2 | Supervisor 3 | Reportee 13 | 2023-02-01 00:00:00 | 2023-02-01 00:00:00
Department 2 | Sub 2 | Area Owner 2 | Supervisor 3 | Reportee 14 | 2023-02-01 00:00:00
Department 2 | Sub 2 | Area Owner 2 | Supervisor 3 | Reportee 15 | 2023-02-01 00:00:00 | 2023-02-20 00:00:00
Department 2 | Sub 2 | Area Owner 2 | Supervisor 3 | Reportee 16 | 2023-02-01 00:00:00 | 2023-02-12 00:00:00
Department 2 | Sub 2 | Area Owner 2 | Supervisor 3 | Reportee 17 | 2023-02-01 00:00:00 | 2023-02-12 00:00:00
Department 2 | Sub 2 | Area Owner 2 | Supervisor 3 | Reportee 18 | 2023-02-01 00:00:00
Department 2 | Sub 2 | Area Owner 2 | [NAME] | Reportee 19 | 2023-02-01 00:00:00 | 2023-02-18 00:00:00
Department 2 | Sub 2 | Area Owner 2 | [NAME] | Reportee 20 | 2023-02-01 00:00:00 | 2023-02-11 00:00:00
Department 2 | Sub 2 | Area Owner 2 | [NAME] | Reportee 21 | 2023-02-01 00:00:00 | 2023-02-18 00:00:00
Department 2 | Sub 2 | Area Owner 2 | [NAME] | Reportee 22 | 2023-02-01 00:00:00 | 2023-02-02 00:00:00
Department 2 | Sub 2 | Area Owner 2 | [NAME] | Reportee 23 | 2023-02-01 00:00:00 | 2023-02-05 00:00:00
Department 2 | Sub 2 | Area Owner 2 | [NAME] | Reportee 24 | 2023-02-01 00:00:00 | 2023-02-18 00:00:00
Department 2 | Sub 2 | Area Owner 2 | [NAME] | Reportee 25 | 2023-02-01 00:00:00 | 2023-02-02 00:00:00
Department 2 | Sub 2 | Area Owner 2 | [NAME] | Reportee 26 | 2023-02-01 00:00:00
Spreadsheet: 166788d1341810490-comparing-and-marking-data-from-two-different-workbooks-agentreport1
Sheet: AgentStatusReport

Server | Domain | Is Unix | Config Group | MS | Version | Last heartbeat | Agent [NAME] | Previous Action
Server1 |  |  | QDB1 |  |  |  | Running
Server2 |  |  | QDB1 |  |  |  | Running
Server3 |  |  | QDB1 |  |  |  | Running
Server4 |  |  | QDB1 |  |  |  | Running
Server5 |  |  | QDB1 |  |  |  | Running
Server6 |  |  | QDB1 |  |  |  | Running
Server7 |  |  | QDB1 |  |  |  | Running
Server8 |  |  | QDB1 |  |  |  | Running
Server9 |  |  | QDB1 |  |  |  | Running
Server10 |  |  | QDB1 |  |  |  | Running
Server11 |  |  | QDB1 |  |  |  | Running
Server12 |  |  | QDB1 |  |  |  | Running
Server13 |  |  | QDB1 |  |  |  | Running
Server14 |  |  | QDB1 |  |  |  | Unknown | Troubleshooted
Server15 |  |  | QDB1 |  |  |  | Running
Server16 |  |  | QDB1 |  |  |  | Unknown | Troubleshooted
Server17 |  |  | QDB1 |  |  |  | Running
Server18 |  |  | QDB1 |  |  |  | Running
Server19 |  |  | QDB1 |  |  |  | Running
Server20 |  |  | QDB1 |  |  |  | Running
Server21 |  |  | QDB1 |  |  |  | Running
Server22 |  |  | QDB1 |  |  |  | Running
Server23 |  |  | QDB1 |  |  |  | Running
Server24 |  |  | QDB1 |  |  |  | Unknown
Server25 |  |  | QDB1 |  |  |  | Running
Server26 |  |  | QDB1 |  |  |  | Running
Server27 |  |  | QDB1 |  |  |  | Running
Server28 |  |  | QDB2 |  |  |  | Running
Server29 |  |  | QDB2 |  |  |  | Running
Server30 |  |  | QDB2 |  |  |  | Running
Server31 |  |  | QDB2 |  |  |  | Maintenance mode
Server32 |  |  | QDB2 |  |  |  | Maintenance mode
Server33 |  |  | QDB2 |  |  |  | Maintenance mode
Server34 |  |  | QDB2 |  |  |  | Maintenance mode
Server35 |  |  | QDB2 |  |  |  | Maintenance mode
Server36 |  |  | QDB2 |  |  |  | Maintenance mode
Server37 |  |  | QDB2 |  |  |  | Maintenance mode
Server38 |  |  | QDB2 |  |  |  | Maintenance mode
Server39 |  |  | QDB2 |  |  |  | Maintenance mode
Server40 |  |  | QDB2 |  |  |  | Maintenance mode
Server41 |  |  | QDB2 |  |  |  | Running
Server42 |  |  | QDB2 |  |  |  | Running
Spreadsheet: 762149d1641410064-is-there-a-built-in-formula-timclarke
Sheet: Worksheet B

 | GBP PRICE |  |  |  |  |  | TMS |  |  |  |  |  | [NAME] |  |  |  |  |  |  | Fluff
N027420851 | 0 | 8.03 | 7.56 | 6.61 | 6.05 | 6.05 |  | 11.64 | 10.96 | 9.59 | 8.77 | 8.77 |  | 11.64 | 10.96 | 9.59 | 8.77 | 8.77 |  |  | 11.64 | 10.96 | 9.59 | 8.77 | 8.77
W027382818 | 0 | 7.15 | 6.74 | 5.91 | 5.42 | 5.42 |  | 10.36 | 9.77 | 8.58 | 7.86 | 7.86 |  | 10.36 | 9.77 | 8.58 | 7.86 | 7.86 |  |  | 10.36 | 9.77 | 8.58 | 7.86 | 7.86
W027384001 | 0 | 25.71 | 20.87 | 16.43 | 16.43 | 16.43 |  | 37.27 | 30.27 | 23.82 | 23.82 | 23.82 |  | 37.27 | 30.27 | 23.82 | 23.82 | 23.82 |  |  | 37.27 | 30.27 | 23.82 | 23.82 | 23.82
W027421467 | 0 | 6.98 | 6.57 | 5.75 | 5.26 | 5.26 |  | 10.12 | 9.53 | 8.34 | 7.62 | 7.62 |  | 10.12 | 9.53 | 8.34 | 7.62 | 7.62 |  |  | 10.12 | 9.53 | 8.34 | 7.62 | 7.62
W027422820 | 0 | 7.15 | 6.74 | 5.91 | 5.42 | 5.42 |  | 10.36 | 9.77 | 8.58 | 7.86 | 7.86 |  | 10.36 | 9.77 | 8.58 | 7.86 | 7.86 |  |  | 10.36 | 9.77 | 8.58 | 7.86 | 7.86
W027463956 | 0 | 25.71 | 20.87 | 16.43 | 16.43 | 16.43 |  | 37.27 | 30.27 | 23.82 | 23.82 | 23.82 |  | 37.27 | 30.27 | 23.82 | 23.82 | 23.82 |  |  | 37.27 | 30.27 | 23.82 | 23.82 | 23.82
W02746N441 | 0 | 7.31 | 6.98 | 6.08 | 5.59 | 5.59 |  | 10.6 | 10.12 | 8.81 | 8.1 | 8.1 |  | 10.6 | 10.12 | 8.81 | 8.1 | 8.1 |  |  | 10.6 | 10.12 | 8.81 | 8.1 | 8.1
W027544326 | 0 | 38.27 | 30.92 | 24.55 | 24.55 | 24.55 |  | 55.49 | 44.84 | 35.59 | 35.59 | 35.59 |  | 55.49 | 44.84 | 35.59 | 35.59 | 35.59 |  |  | 55.49 | 44.84 | 35.59 | 35.59 | 35.59
N027623744 | 0 | 8.41 | 8.03 | 6.99 | 6.43 | 6.43 |  | 12.19 | 11.64 | 10.14 | 9.31 | 9.31 |  | 12.19 | 11.64 | 10.14 | 9.31 | 9.31 |  |  | 12.19 | 11.64 | 10.14 | 9.31 | 9.31
Spreadsheet: 697670d1601471717-how-to-dynamically-update-the-range-for-an-excel-chart-dynamic-range-update-for-excel-chart-redjohn89-
Sheet: Pivot

Row Labels | Count of Serial Number | Country | Quantity
Chair | 2
Jar | 1
Pen | 2
Sofa | 1
Table | 2
TV | 1
Spreadsheet: 36174d1233941927-help-with-index-match-confirming-matches-on-a-list-excel_help
Sheet: Tab B

Activity | Analysis | Design | Build | Test
1.2.1.1 | Yes | No | No | No
1.2.1.2 | No | No | Yes | No
1.2.1.3 | Yes | No | No | No
1.2.1.4 | No | Yes | No | No
1.2.1.5 | No | Yes | No | No
1.2.2.1 | No | Yes | No | No
1.2.2.2 | No | Yes | No | No
1.2.2.3 | No | Yes | No | No
1.2.3.1 | No | Yes | No | No
1.2.3.2 | No | Yes | No | No
1.2.4.1 | No | Yes | No | No
1.2.4.2 | Yes | No | No | No
1.2.4.3 | No | Yes | No | No
1.3.1.1 | Yes | No | No | No
1.3.1.2 | No | Yes | No | No
Spreadsheet: 108580d1305624157-fining-the-first-2-digits-of-a-6-digit-number-example
Sheet: TIME SPENT BY DEPARTMENT

 | 01 - DEVELOPMENT |  |  | 02 - ENGINEERING |  |  | 03 - PRODUCTION
 | HOURS | COST (£) |  | HOURS | COST (£) |  | HOURS | COST (£)
JAN |  | 0 |  |  | 0 |  |  | 0
FEB |  | 0 |  |  | 0 |  |  | 0
MAR |  | 0 |  |  | 0 |  |  | 0