tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: benjamin_rogers__1163__FPL
Sheet: Sheet2

Source: Figures for PSEG Power from PSEG 1999 10K, |  |  |  |  | Source: Figures for PSEG Power from PSEG 1999 10K,
figures for PSEG Global from estimates |  |  |  |  | figures for PSEG Global from estimates
 | [NAME] (By Net/Gross MW) |  |  |  |  | Technology Mix (By Net/Gross MW)
 | Gas |  |  |  |  | ST
 | Nuclear |  |  |  |  | Nuclear
 | Coal |  |  |  |  | CT
 | Oil |  |  |  |  | CCGT
 | Pumped Storage |  |  |  |  | Internal Combustion
 | Others |  |  |  |  | Others
[NAME] |  |  |  |  | [NAME]
Gas | 0.33 |  |  |  | ST | 0.35
Nuclear | 0.28 |  |  |  | Nuclear | 0.28
Coal | 0.2 |  |  |  | CT | 0.26
Oil | 0.17 |  |  |  | CCGT | 0.09
Pumped Storage | 0.02 |  |  |  | Internal Combustion | 0.02
Total |  |  |  |  | Total
Fuel |  | Net (MW) |  |  | Technology |  | Net (MW) | Technology
Gas | Gas | 112.5 |  |  | CCGT |  | 112.5 | Cogen
Oil | Oil | 88.2 |  |  | CCGT |  | 88.2 | CCGT
Others | Solar | 2.67 |  |  | Others |  | 2.67 | Solar
Others | Petroleum Coke | 13.5 |  |  | Others |  | 13.5
Others | Petroleum Coke | 10.4 |  |  | Others |  | 10.4
Others | Petroleum Coke | 10.4 |  |  | Others |  | 10.4
Others | Petroleum Coke | 10.4 |  |  | Others |  | 10.4
Others | Petroleum Coke | 10.4 |  |  | Others |  | 10.4
Others | Petroleum Coke | 10.4 |  |  | Others |  | 10.4
Others | Biomass | 7.245 |  |  | Others |  | 7.245
Others | Biomass | 6.4 |  |  | Others |  | 6.4
Others | Hydro | 7.5 |  |  | ST |  | 7.5 | ST
Others | Hydro | 2.34 |  |  | ST |  | 2.34 | ST
Gas | Gas | 500 |  |  | CCGT |  | 500 | CCGT
Gas | Gas | 500 |  |  | CCGT |  | 500 | CCGT
Gas | Gas | 500 |  |  | CCGT |  | 500 | CCGT
Gas | Gas | 186 |  |  | CT |  | 186 | CT
Gas | Gas | 164 |  |  | CT |  | 164 | CT
Nuclear | Nuclear | 163.8934022070909 |  |  | Nuclear |  | 163.8934022070909 | Nuclear
Nuclear | Nuclear | 163.8934022070909 |  |  | Nuclear |  | 163.8934022070909 | Nuclear
Nuclear | Nuclear | 82.18757354671688 |  |  | Nuclear |  | 82.18757354671688 | Nuclear
Nuclear | Nuclear | 82.18757354671688 |  |  | Nuclear |  | 82.18757354671688 | Nuclear
Nuclear | Nuclear | 51.52631578947369 |  |  | Nuclear |  | 51.52631578947369 | Nuclear
Others | Steam | 400 |  |  | CT |  | 400 | CT
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: StevePearce

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 816005d1675304823-lookup-function-trial
Sheet: Sheet2

 |  | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday
 |  | 16:30:00 | 6 | 6 | 16:30:00 | 6 | 6 | 16:30:00 | 7 | 7 | 16:30:00 | 7 | 7 | 16:30:00 | 6 | 6
 |  | 17:00:00 | 7 | 7 | 17:00:00 | 7 | 7 | 17:00:00 | 8 | 8 | 17:00:00 | 8 | 8 | 17:00:00 | -
 |  | 17:30:00 | - |  | 17:30:00 | - |  | 17:30:00 | 9 | 9 | 17:30:00 | - |  | 17:30:00 | -
 |  | 18:00:00 | 8 | 8 | 18:00:00 | 8 | 8 | 18:00:00 | - |  | 18:00:00 | 9 | 9 | 18:00:00 | 7 | 7
 |  | 18:30:00 | 9 | 9 | 18:30:00 | - |  | 18:30:00 | 10 | 10 | 18:30:00 | 10 | 10 | 18:30:00 | -
 |  | 19:00:00 | - |  | 19:00:00 | 9 | 9 | 19:00:00 | - |  | 19:00:00 | - |  | 19:00:00 | 8 | 8
 |  | 19:30:00 | - |  | 19:30:00 | - |  | 19:30:00 | 11 | 11 | 19:30:00 | - |  | 19:30:00 | -
 |  | 20:00:00 | 10 | 10 | 20:00:00 | 10 | 10 | 20:00:00 | - |  | 20:00:00 | - |  | 20:00:00 | -
 |  | 20:30:00 | - |  | 20:30:00 | - |  | 20:30:00 | - |  | 20:30:00 | 11 | 11 | 20:30:00 | 9 | 9
 |  | 21:00:00 | 11 | 11 | 21:00:00 | 11 | 11 | 21:00:00 | 12 | 12 | 21:00:00 | - |  | 21:00:00 | - | 10
 |  | 21:30:00 | - | 12 | 21:30:00 | - | 12 | 21:30:00 | 13 | 13 | 21:30:00 | 12 | 12 | 21:30:00 | 10 | 11
 |  | 22:00:00 | 12 | 13 | 22:00:00 | 12 | 13 | 22:00:00 | - | 14 | 22:00:00 | - | 13 | 22:00:00 | 11 | 12
 |  | 22:30:00 | - |  | 22:30:00 | 13 |  | 22:30:00 | 14 |  | 22:30:00 | 13 |  | 22:30:00
 |  | + | 13 |  | + |  |  | + |  |  | + |  |  | +
Spreadsheet: 39112d1237313497-populate-a-cell-from-data-matched-from-3-other-worksheets-stock-inventory-sheet
Sheet: Movement 2009

Stock Movement Sheet 2009
Date | [NAME] | Category | Description | Quantity Out | Unit Price | Total Value | Manager / OP's | Customer | Cost Code | Location \ Post Code | Asset No.
2009-01-03 00:00:00 | EBS\MF\99999 | Desktop | HP DX2300 AMD | 1 | 237 | 237 | [NAME] | [NAME] | EBS |  | ES-10001
2009-01-08 00:00:00 | EBS\MF\99999 | Desktop | HP DX2300 AMD | 1 | 237 | 237 | [NAME] | [NAME] | EBS |  | ES-10002
2009-01-13 00:00:00 | EBS\MF\99999 | Desktop | HP DX2300 AMD | 1 | 237 | 237 | [NAME] | [NAME] | EBS |  | ES-10003
2009-01-18 00:00:00 | EBS\MF\99999 | Desktop | HP DX2300 AMD | 1 | 237 | 237 | [NAME] | [NAME] | EBS |  | ES-10004
2009-01-23 00:00:00 | EBS\MF\99999 | Desktop | HP DX2300 AMD | 1 | 237 | 237 | [NAME] | [NAME] | EBS |  | ES-10005
2009-01-28 00:00:00 | EBS\MF\99999 | Laptop | HP 6735 AMD | 1 | 437 | 437 | [NAME] | [NAME] | EBS |  | ES-10006
2009-02-02 00:00:00 | EBS\MF\99999 | Cables | 3M Cat5 Cable | 3 | 4.33 | 12.99 | [NAME] | [NAME] | EBS |  | n/a
2009-02-07 00:00:00 | EBS\MF\99999 | Cables | 5M Cat5 Cable | 2 | 6.24 | 12.48 | [NAME] | [NAME] | EBS |  | n/a
2009-02-12 00:00:00 | EBS\MF\99999 | Cables | 10M Cat5 Cable | 1 | 8.88 | 8.88 | [NAME] | [NAME] | EBS |  | n/a
2009-02-17 00:00:00 | EBS\MF\99999 | Power Accessories | 4 Way Power Extension | 2 | 6.48 | 12.96 | [NAME] | [NAME] | EBS |  | n/a
2009-02-22 00:00:00 | EBS\MF\99999 | Power Accessories | 6 Way Power Extension | 3 | 9.88 | 29.64 | [NAME] | [NAME] | EBS |  | n/a
2009-02-27 00:00:00 | EBS\MF\99999 | Keyboard | KB PS2 105 UK | 2 | 4 | 8 | [NAME] | [NAME] | EBS |  | n/a
2009-03-04 00:00:00 | EBS\MF\99999 | Keyboard | KB USB 105 UK | 3 | 4.5 | 13.5 | [NAME] | [NAME] | EBS |  | n/a
2009-03-09 00:00:00 | EBS\MF\99999 | Laptop Peripherals | Targus Carry Case | 1 | 19.5 | 19.5 | [NAME] | [NAME] | EBS |  | n/a
2009-03-14 00:00:00 | EBS\MF\99999 | Laptop Peripherals | Kingston USB 1GB Stick | 1 | 33 | 33 | [NAME] | [NAME] | EBS |  | n/a
3 |  |  | 6 | 2009-03-01 00:00:00
Spreadsheet: 827439d1682694306-compare-two-dates-for-a-specific-value-the-same-value-in-2-sheets-sample
Sheet: Sheet1

Serial | Account Name | Status | Entitlement Name | Service Level Extension Name | Start Date | End Date | Start Date IGO | End Date IGO
10179FC | Apple Inc | Inactive | Apple Inc Ent | Pro | 8/11/2023 | 12/31/2023 | 8/11/2023 | 12/31/2023
 | Apple Inc | Inactive | Apple Inc Ent | Enhanced | 8/11/2023 | 12/31/2023 | 8/11/2023 | 12/31/2023
 | Apple Inc | Inactive | Apple Inc Ent | Custom | 8/11/2023 | 12/31/2023 | 8/11/2023 | 12/31/2023
 | Apple Inc | Active | Apple Inc Ent | Pro | 8/8/2021 | 8/10/2023 | 8/11/2023 | 12/31/2023
 | Apple Inc | Active | Apple Inc Ent | Enhanced | 8/8/2021 | 8/10/2023 | 8/11/2023 | 12/31/2023
 | Apple Inc | Active | Apple Inc Ent | Custom | 8/8/2021 | 8/10/2023 | 8/11/2023 | 12/31/2023
 | Apple Inc | Active | Apple Inc Ent |  | 8/8/2021 | 8/10/2023
 | Apple Inc | Active | Apple Inc Ent |  | 8/8/2021 | 8/10/2023
 | Apple Inc | Active | Apple Inc Ent |  | 8/8/2021 | 8/10/2023
 | Apple Inc | Active | Apple Inc Ent |  | 8/8/2021 | 8/10/2023
 | Apple Inc | Active | Apple Inc Ent |  | 8/8/2021 | 8/10/2023
 | Apple Inc | Active | Apple Inc Ent |  | 8/8/2021 | 8/10/2023
 | Apple Inc | Active | Apple Inc Ent |  | 8/8/2021 | 8/10/2023
 | Apple Inc | Active | Apple Inc Ent |  | 8/8/2021 | 8/10/2023
 | Apple Inc | Active | Apple Inc Ent |  | 8/8/2021 | 8/10/2023
Subtotal | 15
Serial | Account Name | Status | Entitlement Name | Service Level Extension Name | Start Date | End Date | Start Date IGO | End Date IGO
10179FA | Apple Inc | Inactive | Apple Inc Ent | Pro | 8/11/2023 | 12/31/2023 | 2021-01-01 00:00:00 | 2025-10-30 00:00:00
 | Apple Inc | Inactive | Apple Inc Ent | Enhanced | 8/11/2023 | 12/31/2023 | 2021-01-01 00:00:00 | 2025-10-30 00:00:00
 | Apple Inc | Inactive | Apple Inc Ent | Custom | 8/11/2023 | 12/31/2023 | 2021-01-01 00:00:00 | 2025-10-30 00:00:00
 | Apple Inc | Active | Apple Inc Ent | Pro | 8/8/2021 | 8/10/2023 | 2021-01-01 00:00:00 | 2025-10-30 00:00:00
 | Apple Inc | Active | Apple Inc Ent | Enhanced | 8/8/2021 | 8/10/2023 | 2021-01-01 00:00:00 | 2025-10-30 00:00:00
 | Apple Inc | Active | Apple Inc Ent | Custom | 8/8/2021 | 8/10/2023 | 2021-01-01 00:00:00 | 2025-10-30 00:00:00
 | Apple Inc | Active | Apple Inc Ent |  | 8/8/2021 | 8/10/2023
 | Apple Inc | Active | Apple Inc Ent |  | 8/8/2021 | 8/10/2023
 | Apple Inc | Active | Apple Inc Ent |  | 8/8/2021 | 8/10/2023
 | Apple Inc | Active | Apple Inc Ent |  | 8/8/2021 | 8/10/2023
 | Apple Inc | Active | Apple Inc Ent |  | 8/8/2021 | 8/10/2023
 | Apple Inc | Active | Apple Inc Ent |  | 8/8/2021 | 8/10/2023
 | Apple Inc | Active | Apple Inc Ent |  | 8/8/2021 | 8/10/2023
 | Apple Inc | Active | Apple Inc Ent |  | 8/8/2021 | 8/10/2023
 | Apple Inc | Active | Apple Inc Ent |  | 8/8/2021 | 8/10/2023
Subtotal | 15
Spreadsheet: 769827d1645704643-sumproduct-with-4-criteria-between-two-dates-excel-help-between-2-dates-3-criteria
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Criteria 1 | Date | 2022-01-01 00:00:00
 |  | Superhero | Team | Date | Rescue Mission | Duration (seconds) |  |  | [NAME] | Date | 2022-01-07 00:00:00
 |  | Batman | DC | 2022-01-01 00:00:00 | Burning Building | 5 |  |  | Criteria 3 | Activity | Burning Building
 |  | Spiderman | Marvel | 2022-01-02 00:00:00 | Cat in a tree | 3 |  |  | [NAME] | Activity | School bus
 |  | Wonderwoman | DC | 2022-01-03 00:00:00 | Burning Building | 5 |  |  |  | Duration
 |  | The Hulk | Marvel | 2022-01-04 00:00:00 | School bus | 20
 |  | Captain Marvel | Marvel | 2022-01-05 00:00:00 | Burning Building | 5 |  |  | Result |  | 60 | seconds
 |  | Supergirl | DC | 2022-01-06 00:00:00 | Burning Building | 5
 |  | Thor | Marvel | 2022-01-07 00:00:00 | School bus | 20
 |  | Captain America | Marvel | 2022-01-08 00:00:00 | Cat in a tree | 3
 |  | [NAME] | Marvel | 2022-01-09 00:00:00 | School bus | 20
 |  | Superman | DC | 2022-01-10 00:00:00 | Cat in a tree | 3
Spreadsheet: 123306d1317546375-budget-v-spend-pivot-table-can-this-be-automated-marketing-budgets-working-test-file-v4
Sheet: Lookups

Category | Sub-Category | Property
Advertising | Aerial Photo | Acorn Business Centre, Unit 9, Portsmouth
Boards | Artwork | Ameiva Point, Portsmouth
Brochure | Board - Std | Anchorage Park, Portsmouth
Emailing | Board - Spl | Apex House, Gosport
Internet | Business Magazine | Chancerygate Business Centre, Southampton
Mailing | Design | [NAME], Unit 5, Segensworth
Other | Direct Approach | Fusion, Solent Business Park
Photography | EACH | Griffin Industrial Estate, Totton
 | Echo | Griffin Industrial Estate, Totton
 | Estates [NAME] | H&CA Investment Disposal
 | [NAME] | [NAME], Unit C, Hedge End
 | IAS/OAS | Highgrove Industrial Estate, Portsmouth
 | In-House | Lower [NAME], Units 1&2, Southampton
 | Key Copying | Luxor Court, Unit 6, Havant
 | Local Agents | Manor Court, 8-12, Segensworth
 | Logistics Manager | Marchwood Industrial Estate, Unit 1A.2
 | [NAME] | Meon House, Segensworth
 | NovaLoca | [NAME], Unit 9, Nurlsing
 | Occupier | [NAME], Unit 13, Eastleigh
 | Property Week | Poole Trade Park, Poole
 | Reception | Portfield Trade Park, Portsmouth
 | SCPR Display | Southampton Trade Park, Southampton
 | SCPR Lineage | [NAME], Unit 3, Eastleigh
 | The News | Swanwick Business Centre, Unit 8, Swanwick
 | Trade Occupier | The Briars, Waterlooville
 |  | Vista Park, Unit 110, Nursling
 |  | Vista Park, Unit 210, Nursling
 |  | Wykeham Trade Park, Units 4 & C, Winchester
 |  | HBS House, Southampton
Spreadsheet: 122368d1316768634-ideas-to-generate-multiple-reports-from-data-table-excel-example
Sheet: Data

account # | Jan | Feb | Mar | Quarter | Type | Branch
1001 | 156 | 23 | 789 |  | Sales | A
1002 | 123 | 34 | 12 |  | Sales | A
1003 | 456 | 45 | 23 |  | Salary costs | A
1004 | 789 | 56 | 34 |  | Rent | A
1005 | 123 | 647 | 45 |  | Sundry costs | A
1006 | 456 | 78 | 56 |  | Sales | B
1007 | 789 | 89 | 78 |  | Sales | B
1008 | 12 | 90 | 89 |  | Salary costs | B
1009 | 23 | 12 | 91 |  | Rent | B
1010 | 34 | 23 | 12 |  | Sundry costs | B
1011 | 45 | 46 | 23 |  | Sales | A
1012 | 56 | 59 | 34 |  | Sales | A
1013 | 78 | 48 | 45 |  | Salary costs | A
1014 | 89 | 12 | 56 |  | Rent | A
1015 | 91 | 156 | 647 |  | Sundry costs | A
1016 | 12 | 123 | 78 |  | Sales | B
1017 | 23 | 456 | 89 |  | Sales | B
1018 | 34 | 789 | 90 |  | Salary costs | B
1019 | 45 | 123 | 12 |  | Rent | B
1020 | 56 | 456 | 23 |  | Sundry costs | B
1021 | 647 | 789 | 46 |  | Sales | A
1022 | 78 | 12 | 59 |  | Sales | A
1023 | 89 | 23 | 48 |  | Salary costs | A
1024 | 90 | 34 | 12 |  | Rent | A
1025 | 12 | 45 | 156 |  | Sundry costs | A
1026 | 23 | 56 | 123 |  | Sales | B
1027 | 46 | 78 | 456 |  | Sales | B
1028 | 59 | 89 | 789 |  | Salary costs | B
1029 | 48 | 91 | 123 |  | Rent | B
1030 | 12 | 12 | 456 |  | Sundry costs | B
Spreadsheet: 90734d1290500047-lookup-from-separate-sheet-ops-cards
Sheet: Inspection Directives

 |  |  |  |  | Master Information Record
 | Part No. |  |  |  |  | Tooling Ref. |  |  | Casting Weight |  | Kgs
 | Customer. |  |  |  |  | Drg/lss.No. |  |  | Gross Wt./Mld |  | Kgs
 | Material. |  |  |  |  |  |  |  | Yield |  | %
q | Cust. Spec |  |  |  |  |  |  |  | Castings/Mould
Inspection Directives
q | Quality Assurance Certification Required
q | Tensile - N/mm HOUNDS BAR
q | Wedge Penetration Test
q | HBW Range
q | HBW spread per casting
q | HBW check positions per casting
 | Number of castings for HBW spread check
 | General Casting defects check |  |  |  |  | 5 Per Hour
q | Magnetic Particle Detection
q | Micro Structure Check
 | Machine Trial
q | Stress Relieve
 | Overall Brake Plate Thickness
p | Cross joint not to exceed
q | Preparation of wedge penetration test sample |  |  |  |  | WI 10.27
q | Wedge penetration testing |  |  |  |  | WI 10.24
q | Routine tensile testing |  |  |  |  | WI 10.6
q | Hardness testing |  |  |  |  | WI 10.22
p | QA inspection levels |  |  |  |  | WI 10.5
p | Brake plate thickness and T.I.R |  |  |  |  | WI 10.2
p | Magnetic Particle Inspection |  |  |  |  | WI 10.3
INSPECTION NOTES
***InspectionNotes***
qDenotes Customer Significant Characteristic
(WHEN PRINTED) THIS IS AN UNCONTROLLED DOCUMENT
Spreadsheet: louise_kitchen__22532__2base329c
Sheet: Summary

 | Raptor II Daily Position Report & Summary
 | Inputs:
 | Trade Date |  | Prior Day
 | Summary:
 | Gains and Losses | Total | Realized | Unrealized
 | Previous Day's Cumulative
 | Today's Activity
 | Cumlative Ending
 | Notional Capacity
 | Credit Capacity
 | Remaining Governance Capacity
Spreadsheet: 877447d1724271855-dynamic-table-01-copia
Sheet: Planilha2

 | Ano
 | 2025
 |  | Feriados
 |  | 2025-04-20 00:00:00 | Pascoa
 |  | 2025-01-01 00:00:00 | Ano Novo
 |  | 2025-03-03 00:00:00 | Carnaval
 |  | 2025-03-04 00:00:00 | Carnaval
 |  | 2025-04-18 00:00:00 | Sexta-feira Santa
 |  | 2025-04-21 00:00:00 | Tiradentes
 |  | 2025-05-01 00:00:00 | [NAME] do Trabalho
 |  | 2025-06-19 00:00:00 | Corpus Christi
 |  | 2025-09-07 00:00:00 | Indepedencia
 |  | 2025-10-12 00:00:00 | [NAME] Aparecida
 |  | 2025-11-02 00:00:00 | Finados
 |  | 2025-11-15 00:00:00 | Proclamação da Republica
 |  | 2025-12-25 00:00:00 | Natal
 |  | 2025-07-09 00:00:00 | [NAME] do [NAME]
Spreadsheet: 84822d1284915266-a001-instead-of-p41_a001_2g-book2_sanlen
Sheet: Site Detail

NAME | ID | PHASE | REGION | [NAME] | DATA2 | DATA3
NAME1 | A39_BMY101_2G1i | 39 | North West II
NAME2 | A39_BTB148_2G1i | 39 | North West II
NAME3 | A39_KCM155_2G1i | 39 | North East
NAME4 | A39_KCM167_2G1i | 39 | North East
NAME5 | A39_KCN051_2G1i | 39 | North West II
NAME6 | A39_KCN052_2G1i | 39 | North West II
NAME7 | A39_KCN053_2G1i | 39 | North West II | Test1 | Test2 | Test3
NAME8 | A39_KCN054_2G1i | 39 | North West II
NAME9 | A39_KCN055_2G1i | 39 | North West II
NAME10 | A39_KTM055_2G1i | 39 | North West I
NAME11 | A39_KTM056_2G1i | 39 | North West I
NAME12 | A39_KTM057_2G1i | 39 | North West I
NAME13 | A39_KTM058_2G1i | 39 | North West I
NAME14 | A39_KDL077_2G1i | 39 | Central II
NAME15 | A39_KDL078_2G1i | 39 | Central II
NAME16 | A39_KDL079_2G1i | 39 | Central II
NAME17 | A39_KDL080_2G1i | 39 | Central II
NAME18 | A39_KDL081_2G1i | 39 | Central II
NAME19 | A41_PNH003_2G1i | 41 | Central I
NAME20 | A41_PST003_2G1i | 41 | North West II
NAME21 | A41_PVR004_2G1i | 41 | North West I
NAME22 | A41_PVR005_2G1i | 41 | North West I
NAME23 | A41_PVR006_2G1i | 41 | North West I
[NAME] | A41_PVR007_2G1i | 41 | North West I
NAME25 | A41_PVR008_2G1i | 41 | North West I
NAME26 | A41_PVR010_2G1i | 41 | North West I
NAME27 | A41_SRG001_2G1i | 41 | South East
NAME28 | A41_SRP001_2G1i | 41 | North West I
NAME29 | A41_SRP003_2G1i | 41 | North West I
NAME30 | A41_STG002_2G1i | 41 | North East
Spreadsheet: 781900d1653635797-formula-to-get-data-horizontal-with-collumn-name-example-v3
Sheet: Sheet1

INT | Command_macro | Command_INT | Column1 | Column2 | outcome
G1/0/1 | Other Cell data 1
G1/0/2 | Other Cell data 2
G1/0/3 | Other Cell data 3
G1/0/4 | Other Cell data 4
G1/0/5 | Other Cell data 5
G1/0/6 | Other Cell data 6
G1/0/7 | Other Cell data 7
G1/0/8 | Other Cell data 8
G1/0/9 | Other Cell data 9
G1/0/10 | Other Cell data 10
Spreadsheet: 817512d1676291101-all-data-pulled-from-different-sheet-to-main-consolidated-sheet-amit-agency-savings-task
Sheet: SMC

 | Sycamore Court
 | Name | Employee no. | Position | Contrated Hours | Softworks Start Date | Softworks Total worked hours | Approx. Savings rate | Worked weeks holiday pro-rated | Home
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | SMC
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | SMC
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | SMC | check if correct home
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | SMC
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | SMC
 | Paramveer Singh |  | Care Assistant | 44 |  |  | 3.75 |  | SMC
?? | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | SMC
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | SMC
?? | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | SMC
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | SMC
 | TOTAL
 |  |  |  |  |  | LESS Immigration cost
 |  |  |  |  |  | Total Savings
 | GMR | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours
 | Month | 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 | 2023-01-01 00:00:00
 | Agency Care - Regular | 1639.204081632653 | 1862.5 | 1809 | 1981.5 | 2405 | 2491 | 2116 | 1484 | 639.75 | 223
Spreadsheet: 797000d1663666870-combine-rows-in-a-table-to-merge-start-and-end-times-over-a-48-hour-period-excel-help-1-
Sheet: Sheet1

Problem Example |  |  |  |  |  | Desired outcome
 |  |  |  |  |  |  | v  Ordered by start date
Employee Name | Date | Start Time | End Time |  |  | Employee Name | Start Date | Start Time | End Date | End Time
Person 1 | 2022-09-19 00:00:00 | 23:00:00 | 00:00:00 | * |  | Person 7 | 2022-09-19 00:00:00 | 00:00:00 | 2022-09-19 00:00:00 | 08:00:00
Person 1 | 2022-09-20 00:00:00 | 00:00:00 | 07:00:00 | * eg. These two rows show the same shift but split over two different days |  | Person 8 | 2022-09-19 00:00:00 | 04:00:00 | 2022-09-19 00:00:00 | 06:00:00
Person 1 | 2022-09-20 00:00:00 | 23:00:00 | 00:00:00 | This row shows a second shift starting on the second day
Person 2 | 2022-09-19 00:00:00 | 23:00:00 | 00:00:00 |  |  | Person 8 | 2022-09-19 00:00:00 | 12:00:00 | 2022-09-19 00:00:00 | 13:00:00
Person 2 | 2022-09-20 00:00:00 | 23:00:00 | 00:00:00 |  |  | Person 8 | 2022-09-19 00:00:00 | 17:00:00 | 2022-09-19 00:00:00 | 20:00:00
Person 2 | 2022-09-20 00:00:00 | 00:00:00 | 07:00:00 |  |  | Person 4 | 2022-09-19 00:00:00 | 21:00:00 | 2022-09-19 00:00:00 | 00:00:00
Person 3 | 2022-09-19 00:00:00 | 23:00:00 | 00:00:00 |  | * | Person 1 | 2022-09-19 00:00:00 | 23:00:00 | 2022-09-20 00:00:00 | 07:00:00 | *
Person 3 | 2022-09-20 00:00:00 | 00:00:00 | 09:00:00 |  |  | Person 2 | 2022-09-19 00:00:00 | 23:00:00 | 2022-09-20 00:00:00 | 07:00:00
Person 3 | 2022-09-20 00:00:00 | 23:00:00 | 00:00:00 |  |  | Person 3 | 2022-09-19 00:00:00 | 23:00:00 | 2022-09-20 00:00:00 | 09:00:00
Person 4 | 2022-09-19 00:00:00 | 21:00:00 | 00:00:00 |  |  | Person 5 | 2022-09-19 00:00:00 | 23:00:00 | 2022-09-20 00:00:00 | 07:00:00
Person 4 | 2022-09-20 00:00:00 | 21:00:00 | 00:00:00 |  |  | Person 8 | 2022-09-20 00:00:00 | 04:00:00 | 2022-09-20 00:00:00 | 06:00:00
Person 5 | 2022-09-19 00:00:00 | 23:00:00 | 00:00:00 |  |  | Person 6 | 2022-09-20 00:00:00 | 10:00:00 | 2022-09-20 00:00:00 | 14:00:00
Person 5 | 2022-09-20 00:00:00 | 00:00:00 | 07:00:00 |  |  | Person 4 | 2022-09-20 00:00:00 | 21:00:00 | 2022-09-20 00:00:00 | 00:00:00
Person 6 | 2022-09-20 00:00:00 | 10:00:00 | 14:00:00 |  |  | Person 7 | 2022-09-20 00:00:00 | 22:00:00 | 2022-09-20 00:00:00 | 00:00:00
Person 7 | 2022-09-19 00:00:00 | 00:00:00 | 08:00:00 |  | * | Person 1 | 2022-09-20 00:00:00 | 23:00:00 | 2022-09-20 00:00:00 | 00:00:00
Person 7 | 2022-09-20 00:00:00 | 22:00:00 | 00:00:00 |  |  | Person 2 | 2022-09-20 00:00:00 | 23:00:00 | 2022-09-20 00:00:00 | 00:00:00
Person 8 | 2022-09-19 00:00:00 | 04:00:00 | 06:00:00 |  |  | Person 3 | 2022-09-20 00:00:00 | 23:00:00 | 2022-09-20 00:00:00 | 00:00:00
Person 8 | 2022-09-19 00:00:00 | 12:00:00 | 13:00:00
Person 8 | 2022-09-19 00:00:00 | 17:00:00 | 20:00:00
Person 8 | 2022-09-20 00:00:00 | 04:00:00 | 06:00:00
Spreadsheet: 760346d1640162635-match-cell-contents-in-any-order-sample
Sheet: Sheet1

 | 45 x 70
SIZE |  |  | M2
10 x 20 | 10 | 20
10 x 32 | 10 | 32
14 x 20 | 14 | 20
14 x 32 | 14 | 32
14 x 45 | 14 | 45
14 x 70 | 14 | 70
18 x 95 | 18 | 95
18 x 120 | 18 | 120
18 x 144 | 18 | 144
20 x 70 | 20 | 70
20 x 95 | 20 | 95
28 x 95 | 28 | 95
34 x 34 | 34 | 34
34 x 45 | 34 | 45
34 x 58 | 34 | 58
34 x 70 | 34 | 70
45 x 45 | 45 | 45
45 x 70 | 45 | 70
45 x 95 | 45 | 95
45 x 120 | 45 | 120
45 x 145 | 45 | 145
45 x 195 | 45 | 195
45 x 220 | 45 | 220
58 x 70 | 58 | 70
58 x 95 | 58 | 95
58 x 120 | 58 | 120
58 x 145 | 58 | 145
58 x 195 | 58 | 195
58 x 220 | 58 | 220
70 x 70 | 70 | 70
70 x 90 | 70 | 90
70 x 120 | 70 | 120
70 x 145 | 70 | 145
70 x 195 | 70 | 195
70 x 220 | 70 | 220
90 x 90 | 90 | 90
90 x 120 | 90 | 120
90 x 145 | 90 | 145
90 x 195 | 90 | 195
90 x 220 | 90 | 220
120 x 120 | 120 | 120
140 x 140 | 140 | 140
185 x 185 | 185 | 185