tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 703751d1605151982-assistant-required-on-index-and-match-formula-formula-check
Sheet: Risk Matrix

 | Insignificant | Minor | Moderate | Major | Catastrophic
Likelihood: | 1 | 2 | 3 | 4 | 5
A (almost certain) | High | High | Extreme | Extreme | Extreme
B (likely) | Moderate | High | High | Extreme | Extreme
C (possible) | Low | Moderate | High | Extreme | Extreme
D (unlikely) | Low | Low | Moderate | High | Extreme
E (rare) | Low | Low | Moderate | High | High
Almost Certain | 5 | High | High | Extreme | Extreme | Extreme
Likely | 4 | Moderate | High | High | Extreme | Extreme
Possible | 3 | Low | Moderate | High | Extreme | Extreme
Unlikely | 2 | Low | Low | Moderate | High | Extreme
Rare | 1 | Low | Low | Moderate | High | High
 |  | 1 | 2 | 3 | 4 | 5
Spreadsheet: 859075d1707516177-excel-formula-2
Sheet: Sheet1

From | To | Break | Hours | If the start time is after 06:00 till 18:00 | 18:00 to 20:00 | 20:00 to 24:00 | Time spend after 24:00 till the end time even if the end time is after 06:00 | Total | Check
12:00:00 | 18:00:00 | 00:30:00
18:00:00 | 20:00:00 | 00:30:00
20:00:00 | 1900-01-01 00:00:00 | 00:30:00
20:01:00 | 1900-01-01 00:00:00 | 00:30:00
19:59:00 | 1900-01-01 00:00:00 | 00:30:00
12:00:00 | 18:01:00 | 00:30:00
1900-01-01 00:00:00 | 07:30:00 | 00:30:00
06:00:00 | 18:01:00 | 00:30:00 |  | 12:00:00 | 00:01:00 | 00:00:00 | 00:00:00
05:59:00 | 18:01:00 | 00:30:00 |  | 00:00:00 | 00:00:00 | 00:00:00 | 12:02:00
18:00:00 | 1900-01-01 00:00:00 | 00:30:00 |  | 00:00:00 | 02:00:00 | 04:00:00 | 00:00:00
18:00:00 | 00:02:00 | 00:30:00 |  | 00:00:00 | 02:00:00 | 04:00:00 | 00:02:00
23:00:00 | 05:30:00 | 00:30:00 |  | 00:00:00 | 00:00:00 | 01:00:00 | 05:30:00
23:00:00 | 07:30:00 | 00:30:00 |  | 00:00:00 | 00:00:00 | 01:00:00 | 07:30:00
00:00:00 | 02:30:00 | 00:30:00 |  | 00:00:00 | 00:00:00 | 00:00:00 | 02:30:00
Spreadsheet: 31066d1226785715-autofill-from-column-on-another-worksheet-dispatch-master-copy
Sheet: Mike

 | Jump To: |  | [NAME] | Weekly Totals
 | Nunes!A64 |  |  | Total Paid Hours | Plumbing Hours | HVAC Hours | Appliance Hours | Shop Hours | Travel Time | Unpaid Hours
 | Nunes!A109
 | Nunes!A154 |  | to
 | Nunes!A199
 | Monday |  |  | Plumbing Hours: |  |  | Shop Hours: |  |  | Total Paid Hours
 |  |  |  | HVAC Hours: |  |  | Travel Hours:
 |  |  |  | Appliance Hours: |  |  | Unpaid Time:
 | Status | Invoice | Customer | Class | In | Out | Travel Time | Total | Billed | Comments
Top | Tuesday |  |  | Plumbing Hours: |  |  | Shop Hours: |  |  | Total Paid Hours
 |  |  |  | HVAC Hours: |  |  | Travel Hours:
 |  |  |  | Appliance Hours: |  |  | Unpaid Time:
 | C,R,P | Invoice | Customer | Class | In | Out | Travel Time | Total | Billed | Comments
Top | Wednesday |  |  | Plumbing Hours: |  |  | Shop Hours: |  |  | Total Paid Hours
 |  |  |  | HVAC Hours: |  |  | Travel Hours:
 |  |  |  | Appliance Hours: |  |  | Unpaid Time:
 | C,R,P | Invoice | Customer | Class | In | Out | Travel Time | Total | Billed | Comments
Top | Thursday |  |  | Plumbing Hours: |  |  | Shop Hours: |  |  | Total Paid Hours
 |  |  |  | HVAC Hours: |  |  | Travel Hours:
 |  |  |  | Appliance Hours: |  |  | Unpaid Time:
 | C,R,P | Invoice | Customer | Class | In | Out | Travel Time | Total | Billed | Comments
Top | Friday |  |  | Plumbing Hours: |  |  | Shop Hours: |  |  | Total Paid Hours
 |  |  |  | HVAC Hours: |  |  | Travel Hours:
 |  |  |  | Appliance Hours: |  |  | Unpaid Time:
 | C,R,P | Invoice | Customer | Class | In | Out | Travel Time | Total | Billed | Comments
Spreadsheet: d74e55d1-4b18-467f-b0d2-1273b1337d19
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
4978 | 8033 | Arnott | [NAME] | GBR | 382 | 00:51:18 | 00:01:46 | 01:18:19 | 00:01:49 | 00:26:19 | 1 | 02:39:32
4978 | 12442 | [NAME] | Peck | GBR | 383 | 00:53:05 | 00:01:47 | 01:24:23 | 00:02:41 | 00:32:37 | 2 | 02:54:36
4978 | 17896 | [NAME] | Martinez | FRA | 381 | 01:09:00 | 00:02:24 | 01:34:22 | 00:03:37 | 00:46:33 | 3 | [NAME]
Spreadsheet: edcfab89-e9ba-4051-a106-a46b99594a97
Sheet: Sheet1

Sultan Qaboos University College of Engineering Department of Mechanical & Industrial Engineering | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Final Year Project Selection Form (ME) Academic Year 2011-2012
Project team member(s): [NAME] in the name, student ID #, and cumulative GPA of each member of the project team.
Serial No. | Student Name | Student ID# | Cumulative GPA
1 | [NAME] … | 12345 | 2.1
2 | [NAME] …. | 54321 | 3.1
3 | [NAME] … | 12534 | 2.2
4 | [NAME]… | 53421 | 2.7
5
6
 | Average
Project Selection: From the list of available projects in the attached excel sheet, write down five projects in the order of your preference.
Serial No. | Project Allocation Number from the FYP List
1 | 15
2 | 12
3 | 4
4 | 3
5 | 6
For Department Use Only
 | Project Allolcated
 | Supervisors
 | Signature
 | Date
Spreadsheet: 155816d1337065814-conditional-formating-ves_msps_time_management-copy
Sheet: TimeSheet- 2nd - 6th Apr FINAL

 | % Distribution by Resource | INSERT THE % TIME MANUALLY IN THE BELOW TABLE
 | Resource name | Newco - Incident Mgmt | Newco - VES TechSupport | VES - Incident Mgmt | VES - Chordiant OR CRM Support | Chordiant_BAU | Online_Programme | Vendor_Integration_Prog | Vodafone_eShop_L3 | Chordiant_BAU | EG_NewCo_eShop | N_Portfolio_Project | MTS_RoamingData_Rfsh | APP_SKYWALKER | LT_UK_MTS_PAS_Capacity_for_USS | Total
 | [NAME] |  |  |  |  | 0.5
 | Banpreet Singh
 | [NAME]
 | [NAME]
 | [NAME]
 | Ajay  Ashtikar
 | Amber [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Total
 | Hrs allocated by project per week |  |  |  |  | 22.5 | 50 | 11.25 |  |  |  |  | 22.5 | 22.5 | 18 | MANUAL |  |  |  | Hrs per head per week |  |  | 45
 | [NAME] of Hrs that can be allocated to 1 resource |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FORMULA
 | No. of working days in a week | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | MANUAL
 |  |  |  |  |  |  | NON VATS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Vacation/ Holiday Day
SAP Id | Resource Name | Team |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL HOURS | [NAME] | Chargeable Hours | Non-Chargeable | Vacation | Public Holiday
10722721 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10731386 | Banpreet Singh | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10391107 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10628998 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10628911 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10556485 | Ajay  Ashtikar | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10727324 | Amber [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10381737 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10614473 | [NAME] | Tech supp |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10556831 | [NAME] | Tech supp |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10716330 | [NAME] | Tech supp |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10724809 | [NAME] | Tech supp |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | Daily Total
 | Weekly Total
Spreadsheet: 866830d1713761568-increment-number-based-on-location-increment-number
Sheet: Sheet1

Location | Sequential Number
AA |  |  | Start number | 1001
AA
AA |  |  |  |  |  | Increment number based on Location
AA |  |  |  |  |  | How do I increase a sequential number based on locations?
AA |  |  |  |  |  | [NAME] required for Excel 2010 or earlier.
AA
AB |  |  |  |  |  | Thank you.
AB
AB
AB
AC
AD
AD
AD
AD
AD
AF
Spreadsheet: 44126d1242769024-validation-example
Sheet: Sheet1

 |  | Frequency | Amount | Monthly | Yearly
 |  | Monthly | 200
 |  | Monthly | 500
 |  | Monthly | 500 |  | 2400
 |  | Bi-weekly | 0 |  | 1200
 |  | Annually | 2202 |  | 200
 |  | Semi-Annually | 500 |  | 840
 |  | Weekly | 100 |  | 360
 |  | Yearly | 40 |  | 120
Spreadsheet: darrell_schoolcraft__7824__imbalsumm0110
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 17647 | 18199 | 8769 | 9000
2
3
4
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-09-30 00:00:00 |  |  |  |  |  |  |  |  | 57662
2001-10-01 00:00:00
CBS Volume
 |  |  | -98440
Spreadsheet: 785617d1656514906-index-randarray-and-ignore-blank-cells-team-builder-demo-workbook
Sheet: Sheet1

 |  | Enter the name of each participant | Each time the # of entrants is entered then it will re-select teams |  | Number of Teams
 |  | Entrants | Enter # of Entrants
 | 1 | [NAME] | 16 | Team 1
 | 2 | [NAME]
 | 3 | [NAME] |  | Team 2
 | 4 | [NAME]
 | 5 | [NAME] |  | Team 3
 | 6 | [NAME]
 | 7 | [NAME] |  | Team 4
 | 8 | [NAME]
 | 9 | [NAME] |  | Team 5
 | 10 | [NAME]
 | 11 | [NAME] |  | Team 6
 | 12 | [NAME]
 | 13 | [NAME] |  | Team 7
 | 14 | [NAME]
 | 15 | [NAME] |  | Team 8
 | 16 | [NAME]
 | 17 |  |  | Team 9
 | 18
 | 19 |  |  | Team 10
 | 20
 | 21 |  |  | Team 11
 | 22
 | 23 |  |  | Team 12
 | 24
 | 25 |  |  | Team 13
 | 26
 | 27 |  |  | Team 14
 | 28
 | 29 |  |  | Team 15
 | 30
Spreadsheet: 835965d1689001698-how-many-employees-were-there-in-that-month-last-year-book2
Sheet: Sheet1

 |  | START DATE | LEAVING DATE |  |  |  | Number of people employed at the end of this month | <<<<< | This column needs to consider the start date (col C) and potential leaving date (col D) of the employee, but also consider which month it is that we are wanting to report for (Col H)
 |  | 2016-11-01 00:00:00 |  |  |  | 2021-01-01 00:00:00
 |  | 2017-11-01 00:00:00 |  |  |  | 2021-02-01 00:00:00
 |  | 2021-08-26 00:00:00 |  |  |  | 2021-03-01 00:00:00
 |  | 2018-05-01 00:00:00 | 2022-03-03 00:00:00 |  |  | 2021-04-01 00:00:00
 |  | 2020-12-01 00:00:00 |  |  |  | 2021-05-01 00:00:00
 |  | 2021-01-01 00:00:00 |  |  |  | 2021-06-01 00:00:00
 |  | 2021-11-16 00:00:00 |  |  |  | 2021-07-01 00:00:00
 |  | 2019-04-15 00:00:00 |  |  |  | 2021-08-01 00:00:00
 |  | 2018-03-02 00:00:00 |  |  |  | 2021-09-01 00:00:00
 |  | 2018-10-12 00:00:00 |  |  |  | 2021-10-01 00:00:00
 |  | 2017-06-01 00:00:00 |  |  |  | 2021-11-01 00:00:00
 |  | 2021-09-01 00:00:00 | 2022-11-30 00:00:00 |  |  | 2021-12-01 00:00:00
 |  | 2021-09-01 00:00:00 |  |  |  | 2022-01-01 00:00:00
 |  | 2021-09-01 00:00:00 |  |  |  | 2022-02-01 00:00:00
 |  | 2020-03-01 00:00:00 |  |  |  | 2022-03-01 00:00:00
 |  | 2021-02-11 00:00:00 |  |  |  | 2022-04-01 00:00:00
 |  | 2022-09-01 00:00:00 |  |  |  | 2022-05-01 00:00:00
 |  | 2021-01-01 00:00:00 | 2022-04-01 00:00:00 |  |  | 2022-06-01 00:00:00
 |  | 2022-05-04 00:00:00 |  |  |  | 2022-07-01 00:00:00
 |  | 2023-05-01 00:00:00 |  |  |  | 2022-08-01 00:00:00
 |  | 2017-01-01 00:00:00 |  |  |  | 2022-09-01 00:00:00
 |  | 2020-07-01 00:00:00 |  |  |  | 2022-10-01 00:00:00
 |  | 2022-04-01 00:00:00 |  |  |  | 2022-11-01 00:00:00
 |  | 2022-04-01 00:00:00 |  |  |  | 2022-12-01 00:00:00
 |  | 2022-06-28 00:00:00 |  |  |  | 2023-01-01 00:00:00
 |  | 2020-05-14 00:00:00 |  |  |  | 2023-02-01 00:00:00
 |  | 2022-02-16 00:00:00 |  |  |  | 2023-03-01 00:00:00
 |  | 2020-12-14 00:00:00 |  |  |  | 2023-04-01 00:00:00
 |  | 2021-09-10 00:00:00 |  |  |  | 2023-05-01 00:00:00
 |  | 2022-02-04 00:00:00 |  |  |  | 2023-06-01 00:00:00
 |  | 2023-01-17 00:00:00
 |  | 2021-07-02 00:00:00
 |  | 2023-05-05 00:00:00
 |  | 2022-07-25 00:00:00
 |  | 2021-07-21 00:00:00 | 2022-04-01 00:00:00
 |  | 2021-08-23 00:00:00 | 2022-03-14 00:00:00
 |  | 2020-09-01 00:00:00 | 2021-07-31 00:00:00
 |  | 2017-06-01 00:00:00
 |  | 2013-11-29 00:00:00
 |  | 2019-04-08 00:00:00 | 2022-03-03 00:00:00
 |  | 2021-08-21 00:00:00
 |  | 2019-12-01 00:00:00 | 2023-12-01 00:00:00
Spreadsheet: 37cab6f0-5f87-48d3-9f0c-0cc60c70c8de
Sheet: disperindagkop

RENCANA UMUM PENGADAAN BARANG / JASA PEMERINTAH
PA/KPA |  | : H.NOORYAKIN,SE.MM
K/L/D/I |  | : PEMERINTAH KAB.TANAH BUMBU
SATKER/SKPD |  | : DISPERINDAGKOP [NAME]
TAHUN ANGGARAN |  | : 2013
NO | KEGIATAN | SUB KEGIATAN/ | NAMA PAKET | VOLUME | LOKASI PEKERJAAN | RENCANA PENGANGGARAN |  |  | CARA PENGADAAN | PERKIRAAN WAKTU | WAKTU | KET
 |  |  |  |  |  |  |  |  |  | MULAI PELAKSANAAN | PELAKSANAAN
 |  | PEKERJAAN | PEKERJAAN |  | (PROV/KAB) | PEKERJAAN | [NAME] | RENCANA |  | PENGADAAN | (BULAN)
 |  |  |  |  |  | BIAYA (Rp) | (APBN/APBD) | PEMBIAYAAN
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
1 | PENYEDIAAN PERALATAN | BELANJA MODAL LAPTOP | PEMBELIAN LAPTOP | 2 UNIT | [NAME] | 17000000 | APBD | DISPERINDAGKOP | PENUNJUKKAN | JANUARI 2012 | JANUARI
 | & PERLENGKAPAN KANTOR | MODAL |  |  |  |  |  | DAN UKM | LANGSUNG
2 | SDA | BELANJA MODAL PRINTER | PEMBELIAN PRINTER | 4 UNIT | [NAME] | 4800000 | APBD | DISPERINDAGKOP | PENUNJUKKAN | JANUARI 2012 | JANUARI
 |  |  |  |  |  |  |  | DAN UKM | LANGSUNG
3 | SDA | BELANJA MODAL  MEBEULAIR | PEMBELIAN KURSI KERJA | 4 UNIT | [NAME] | 6000000 | APBD | DISPERINDAGKOP | PENUNJUKKAN | JANUARI 2012 | JANUARI
 |  |  |  |  |  |  |  | DAN UKM | LANGSUNG
4 | SDA | BELANJA MODAL MESIN TIK | PEMBELIAN [NAME] | 2 UNIT | [NAME] | 2200000 | APBD | DISPERINDAGKOP | PENUNJUKKAN | JANUARI 2012 | JANUARI
 |  |  |  |  |  |  |  | DAN UKM | LANGSUNG
5 | SDA | BELANJA MODAL KIPAS | PEMBELIAN KIPAS ANGIN | 2 UNIT | [NAME] | 900000 | APBD | DISPERINDAGKOP | PENUNJUKKAN | JANUARI 2012 | JANUARI
 |  | ANGIN |  |  |  |  |  | DAN UKM | LANGSUNG
6 | SDA | BELANJA MODAL LEMARI | PEMBELIAN LEMARI KAYU/ | 3 UNIT | [NAME] | 8100000 | APBD | DISPERINDAGKOP | PENUNJUKKAN | JANUARI 2012 | JANUARI
 |  | KAYU/LOKER | LOKER |  |  |  |  | DAN UKM | LANGSUNG
7 | PENYEDIAAN KOMPONEN | BELANJA MODAL PENGADAAN | PEMASANGAN INSTALASI | 1 PAKET | [NAME] | 20000000 | APBD | DISPERINDAGKOP | PENUNJUKKAN | JANUARI 2012 | JANUARI
 | INSTALASI LISTRIK/PENERANG | INSTALASI LISTRIK & TELEPON | [NAME] (PENAMBAHAN DAYA |  |  |  |  | DAN UKM | LANGSUNG
 | AN BANGUNAN KANTOR |  | [NAME])
8 | PENGADAAN PERLENGKAPAN | BELANJA MODAL PERLENGKAP | [NAME] | 1 PAKET | [NAME] | 25000000 | APBD | DISPERINDAGKOP | PENUNJUKKAN | JANUARI 2012 | JANUARI
 | [NAME] | AN GEDUNG KANTOR |  |  |  |  |  | DAN UKM | LANGSUNG
9 | SDA | BELANJA MODAL PERLENGKAP | PEMBUATAN TEMPAT PARKIR | 1 PAKET | [NAME] | 10000000 | APBD | DISPERINDAGKOP | PENUNJUKKAN | JANUARI 2012 | JANUARI
 |  | AN GEDUNG KANTOR |  |  |  |  |  | DAN UKM | LANGSUNG
 |  |  |  |  |  |  |  |  |  | BATULICIN,   28 DESEMBER 2012
 |  |  |  |  |  |  |  |  |  | PENGGUNA ANGGARAN
 |  |  |  |  |  |  |  |  |  | H.NOORYAKIN,SE.MM
 |  |  |  |  |  |  |  |  |  | PEMBINA UTAMA MUDA
 |  |  |  |  |  |  |  |  |  | NIP.19581010 198503 1 042
Spreadsheet: 98131d1297174656-excel-2007-sumif-criteria-sumifpvt
Sheet: FTE Count

# [NAME] to be achieved per Hr |  |  |  | MTD FTE
Calls
# [NAME] to be achieved per Hr |  | MTD FTE
Emails
 |  | <<See [NAME] |  |  |  |  |  |  |  |  | Enter Dates Below
 |  |  |  |  |  |  |  |  |  |  | 2011-02-01 00:00:00 | 2011-02-07 00:00:00
 |  |  |  |  |  |  |  |  |  | Staffing |  | Total Agents
 |  |  |  |  |  |  |  |  |  |  |  | # [NAME] | FTE
 |  |  |  |  |  |  |  |  |  | Subtotal
 |  |  |  |  |  |  |  |  |  | Available FTE
 |  |  |  |  |  |  |  |  |  | Productivity
 |  |  |  |  |  |  |  |  |  | Planned Leave
 |  |  |  |  |  |  |  |  |  | Unplanned Leave
 |  |  |  |  |  |  |  |  |  | Total FTE
 |  | Team Name | (All)
 |  | Row Labels | Sum of Base Rostered Hours | Sum of Rostered Hours (Annual Leave adjusted) | Sum of Overtime hours | Sum of Actual Work Hours
 |  | 2011-02-01 00:00:00 | 21 | 21 |  | 14
 |  | 2011-02-02 00:00:00 | 16.5 | 16.5 |  | 16.5
 |  | 2011-02-03 00:00:00 | 28 | 28 | 0.5 | 28.5
 |  | 2011-02-04 00:00:00 | 26.5 | 26.5 |  | 26.5
 |  | 2011-02-05 00:00:00 | 4 | 4 |  | 4
 |  | 2011-02-07 00:00:00 | 36 | 36 | 2 | 38
 |  | Grand Total | 132 | 132 | 2.5 | 127.5
Spreadsheet: 864840d1711983589-auto-populate-a-range-with-selected-rows-from-a-second-range-but-the-nightmarish-way-stone-inventory
Sheet: DATA

CODE | MATERIAL NAME | MATERIAL | COST | check_1 | Check_2
LCC | Light Concrete | Ceramic
ALG | [NAME] | Granite
BTB | [NAME] | Granite
BTR | Baltic Red | Granite
PCM | [NAME] | Granite |  |  |  |  | NOTES:
BFH | Black Forest Honed | Granite
BFL | Black Forest Leather | Granite |  |  |  |  | --  Keep this list up to date, the rest of the workbook depends on it being accurate. Duplicates will automatically be flagged.
BFP | Black Forest Polished | Granite |  |  |  |  | --  To organise the table on this page: click anywhere in the table; on the 'Data' tab, click '[NAME]' ; sort by 'MATERIAL' first, then by 'MATERIAL NAME'.
BKP | Black Pearl | Granite |  |  |  |  | --  If filtering by material is desired, click anywhere in the table and use the Filter tool on the same tab as above, then use arrows on headers to apply filter.
BLP | Blue Pearl | Granite |  |  |  |  | --  After creating a new material and individual code here, add it to the appropriate Summary pages so it can be accounted for.
CRV | Colonial River | Granite |  |  |  |  | --  If cost is specified against a material, it will auto-fill by default on the STOCK CONTROL page. Changing it on this table at any time will cause any auto-filled  values in
CLW | Colonial White | Granite |  |  |  |  | the STOCK CONTROL page to change with it; if this is not desired, please re-type the Cost as soon as the record is created in the STOCK CONTROL page.
CMB | Cosmic Black | Granite | 45
EMP | [NAME] | Granite
FTB | [NAME] | Granite
GVZ | Giallo Veneziano | Granite
HCR | Harvest Cream | Granite
KSM | Kashmir White | Granite
RVW | River Valley White | Granite
STG | Star Galaxy | Granite
SFG | Surf Green | Granite
VGD | [NAME] | Granite
ABL | Angola Black Leather | Hearth | 28
NH | Nero Honed | Hearth | 20
NP | Nero Polished | Hearth | 23
SGL | Steel Gray Leather | Hearth | 22
SGP | Steel Gray Polished | Hearth | 24
SGH | Steel Grey Honed | Hearth | 22
CMF | [NAME] | Limestone | 38
JRG | [NAME] | Limestone
ABC | Arabescato | Marble
CAM | Carrara Marble | Marble
MIM | Marron Imperial | Marble
RFR | Rain Forest | Marble
AMZ | [NAME] | Quartz
BRN | Borini | Quartz
CCD | [NAME] | Quartz
CCG | [NAME] | Quartz
GM | Grey Mirror | Quartz
LG | Light Gray | Quartz
MSN | [NAME] | Quartz | 33
NC | New Carrara | Quartz | 32
PTG | Platinum Gray | Quartz
PLW | Polar White | Quartz | 25
PW | [NAME] | Quartz | 20
SH | Shimmer | Quartz
SNW | [NAME] | Quartz
SGR | [NAME] | Quartz
VCZ | [NAME] | Quartz
WF | White Frost | Quartz
WM | White Mirror | Quartz
WSP | White Sparkle | Quartz
WMG | Westmorland Green | Slate
Spreadsheet: 874756d1721283649-error-in-ranking-formula-navin_ranking_error
Sheet: Sheet1

Stock | Points | Rank |  |  |  |  | Stock | Points | Rank
ACC | 43.40000000000001 |  |  | 1 |  |  | ACC | 30.4 |  |  | 1
AMBUJACEM | 32.05 |  |  |  |  |  | AMBUJACEM | 39.75
ASIANPAINT | 34.75 |  |  |  |  |  | ASIANPAINT | 35
AXISBANK | 17.6 |  |  |  |  |  | AXISBANK | 9.15
BHARTIARTL | 36.15 |  |  |  |  |  | BHARTIARTL | 46.35
BHEL | 21.75 |  |  |  |  |  | BHEL | 13.3
BAJAJ-AUTO | 38.85 |  |  |  |  |  | BAJAJ-AUTO | 31.5
BANKBARODA | 15.7 |  |  |  |  |  | BANKBARODA | 31.5
BPCL | 27.6 |  |  |  |  |  | BPCL | 13.5
CAIRN | 24.85 |  |  |  |  |  | CAIRN | 23.75
CIPLA | 38.4 |  |  |  |  |  | CIPLA | 37.90000000000001
COALINDIA | 37.2 |  |  |  |  |  | COALINDIA | 35.45
DLF | 23.3 |  |  |  |  |  | DLF | 32.8
DRREDDY | 23.35 |  |  |  |  |  | DRREDDY | 8.15
[NAME] | 23.1 |  |  |  |  |  | [NAME] | 12.45
GRASIM | 35.95 |  |  |  |  |  | GRASIM | 37.5
HCLTECH | 8.55 |  |  |  |  |  | HCLTECH | 1
HDFC | 39.45 |  |  |  |  |  | HDFC | 25.4
HDFCBANK | 26.6 |  |  |  |  |  | HDFCBANK | 19.95
HEROMOTOCO | 22.35 |  |  |  |  |  | HEROMOTOCO | 31.4
HINDALCO | 14.25 |  |  |  |  |  | HINDALCO | 37.95
HINDUNILVR | 44.5 |  |  |  |  |  | HINDUNILVR | 44.5
ICICIBANK | 17.8 |  |  |  |  |  | ICICIBANK | 19.75
IDFC | 32.75 |  |  |  |  |  | IDFC | 37.8
INDUSINDBK | 30.15 |  |  |  |  |  | INDUSINDBK | 29.3
INFY | 13.25 |  |  |  |  |  | INFY | 4.95
ITC | 44.3 |  |  |  |  |  | ITC | 31.4
JPASSOCIAT | 14.7 |  |  |  |  |  | JPASSOCIAT | 26.4
JINDALSTEL | 21 |  |  |  |  |  | JINDALSTEL | 29.85
KOTAKBANK | 28.1 |  |  |  |  |  | KOTAKBANK | 34.65
[NAME] | 26 |  |  |  |  |  | [NAME] | 12.45
LT | 9.9 |  |  |  |  |  | LT | 6.749999999999999
M&M | 26.3 |  |  |  |  |  | M&M | 17
MARUTI | 10.5 |  |  |  |  |  | MARUTI | 21.55
NMDC | 7.65 |  |  |  |  |  | NMDC | 16.4
NTPC | 39.3 |  |  |  |  |  | NTPC | 48.65
ONGC | 34.7 |  |  |  |  |  | ONGC | 25.45
PNB | 23.55 |  |  |  |  |  | PNB | 17.95
POWERGRID | 41.8 |  |  |  |  |  | POWERGRID | 33.7
RANBAXY | 5.5 |  |  |  |  |  | RANBAXY | 26.8
RELIANCE | 28.45 |  |  |  |  |  | RELIANCE | 38.8
SBIN | 34.95 |  |  |  |  |  | SBIN | 45.75
SUNPHARMA | 36.7 |  |  |  |  |  | SUNPHARMA | 17.7
TATASTEEL | 1.5 |  |  |  |  |  | TATASTEEL | 18.95
TCS | 14 |  |  |  |  |  | TCS | 9.9
TATAPOWER | 26.65 |  |  |  |  |  | TATAPOWER | 36
TATAMOTORS | 13.65 |  |  |  |  |  | TATAMOTORS | 8.1
ULTRACEMCO | 42.3 |  |  |  |  |  | ULTRACEMCO | 31.15
VEDL | 9.9 |  |  |  |  |  | VEDL | 25.4
WIPRO | 9.95 |  |  |  |  |  | WIPRO | 3.8
Spreadsheet: 875919d1722530590-quote-template-help-paul_t-hole-template-9_57am-365-aligw
Sheet: Sheet1

(COMPLEXITY LEVEL →) |  | LEVEL 1 | LEVEL 2 | LEVEL 3
(BAND DESCRIPTION) | BAND | HOURS | HOURS | HOURS
1 TO 6 HOLES | A | 2.75 | 3 | 3.25
6 TO 12 HOLES | B | 2.25 | 2.5 | 2.75
12 TO 20 HOLES | C | 1.75 | 2 | 2.25
20 TO 30 HOLES | D | 1.25 | 1.5 | 1.75
30 TO 50 HOLES | E | 1 | 1.25 | 1.5
50 TO 100 HOLES | F | 0.75 | 1 | 1.25
HOURLY RATE | £20 PER HOUR
 |  |  |  |  | TOOL NUMBER | NUMBER OF HOLES | COMPLEXITY | TOTAL COST
 |  |  |  |  | ABC1234 | 27 | LEVEL 2 |  | SHOULD BE 27(NO OF HOLES)  x 1.5 (LEVEL FACTOR) x 20 (HOURLY RATE)
 |  |  |  |  | DEF5678 | 5 | LEVEL 3 | 325
 |  |  |  |  | HIJ91011 | 72 | LEVEL 1 | 1080
 |  |  |  |  | b | h | l | FILTER(C3:E8,C1:E1=l) (varies by row) | XLOOKUP(h,b,FILTER(C3:E8,C1:E1=l),0,-1)*20) (varies by row)
 |  |  |  |  | 6 | 5 | LEVEL 3 | 2.5
 |  |  |  |  | 12 | 72 | LEVEL 1 | 2
 |  |  |  |  | 20 |  |  | 1.5
 |  |  |  |  | 30 |  |  | 1.25
 |  |  |  |  | 50 |  |  | 1
Spreadsheet: 71484d1272247189-combine-lists-selfmergingvalidationlist
Sheet: MergingList

List1 | List2 | MergedList
Item1 | Item2 | Item1
Item3 | Item4 | Item3 |  | Choose | Item3
Item5 | Item6 | Item5
Item7 | Item 8 | Item7
Item9 | Item10 | Item9
Item11 |  | Item11
Item12 |  | Item12
Item13 |  | Item13
 |  | Item2
 |  | Item4
 |  | Item6
 |  | Item 8
 |  | Item10
Spreadsheet: 99503d1298117163-finding-data-from-other-sheets-main
Sheet: wc 30-8-10

 | Claims sent from: |  | BELLE VALE |  |  |  |  |  |  | Date:
 | Exporting office |  |  |  |  |  |  | Importing Office |  |  |  |  | CCG section
 | Surname | First Name | NINO | Date Sent | App NO | Bundle No | Bag No | Date recd by exprting office | date of decision | Name of DM | [NAME] to Belle Vale | Bag No | Date rec by [NAME] | Date cleared on S/F tracker
1
2
3
4
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
Spreadsheet: 269908d1381323902-creating-a-list-without-duplicates-from-data-on-another-sheet-behavior-data-entry-sheet
Sheet: Sheet1

[NAME]
Monday | Tuesday | Wednesday | Thursday | Friday