Vendor Mastersheet - Revision history

Guido.gastaldi at 17:52, 16 October 2024

2024-10-16T17:52:42Z

Mmoura: /* Vendor Mastersheet */

2024-10-16T17:39:54Z

Vendor Mastersheet

Sam: /* Vendor Mastersheet */

2024-02-06T15:23:58Z

Vendor Mastersheet

Sam at 16:45, 2 February 2024

2024-02-02T16:45:32Z

Sam: /* Vendor Mastersheet */

2024-02-02T16:44:37Z

Vendor Mastersheet

Sam: Created page with "== Vendor Mastersheet== When field employees run out of materials or face equipment issues, they can call the Operations team to find the nearest mechanic, service center or..."

2024-02-02T16:44:06Z

Created page with "== Vendor Mastersheet== When field employees run out of materials or face equipment issues, they can call the Operations team to find the nearest mechanic, service center or..."

New page

== Vendor Mastersheet==

When field employees run out of materials or face equipment issues, they can call the Operations team to find the nearest mechanic, service center or store to replenish or repair items and continue with the job at hand. Operations team can use the [https://docs.google.com/spreadsheets/d/1My0rRHUK1MacQNmwR2e2Qxjonjpq815-0wrOpsGp2Io/edit#gid=1866346512 Vendor Mastersheet] to find the most optimum vendor by location and service provided. The Vendor mastersheet workbook has three sheets:

Dashboard- Depending the location of the crew and the service they are looking for, Operations will select the nearest location (yard) and the service from the dropdowns in cell C2 and C3. The list below will auto-populate depending on the selections the user makes. Operations should choose a "preferred" partner over "secondary" and "road based".

Vendor Mastersheet- Contains a list of all existing vendors that Pothole Repair works with. Operations will use this tab to add new vendors or update existing vendor details by adding required vendor information.

Dropdowns- Contains a list of dropdowns that are used within the workbook. This tab can be ignored.

@@ Line 4: / Line 4: @@
 == Vendor Mastersheet==
-When field employees run out of materials or face equipment issues, they can call the Operations team to find the nearest mechanic, service center or store to replenish or repair items and continue with the job at hand. Operations team can use the '''[https://docs.google.com/spreadsheets/d/1My0rRHUK1MacQNmwR2e2Qxjonjpq815-0wrOpsGp2Io/edit#gid=1866346512 Vendor Mastersheet]''' to find the most optimum vendor by location and service provided. The Vendor mastersheet workbook has three sheets:
+When field employees run out of materials or face equipment issues, they can call the Operations team to find the nearest mechanic, service center or store to replenish or repair items and continue with the job at hand. Operations team can use the '''[https://docs.google.com/spreadsheets/d/1aVKvBv1ftsTiGkGkROB942tJJda4wmAtJNY-fVox7RM/edit?usp=sharing Vendor Mastersheet]''' to find the most optimum vendor by location and service provided. The Vendor mastersheet workbook has three sheets:
 '''Dashboard'''- Depending the location of the crew and the service they are looking for, Operations will select the nearest location (yard) and the service from the dropdowns in cell C2 and C3. The list below will auto-populate depending on the selections the user makes. Operations should choose a "preferred" partner over "secondary" and "road based".

← Older revision		Revision as of 17:39, 16 October 2024
Line 11:		Line 11:

	'''Dropdowns'''- Contains a list of dropdowns that are used within the workbook. This tab can be ignored.		'''Dropdowns'''- Contains a list of dropdowns that are used within the workbook. This tab can be ignored.
		+
		+	Template used:
		+	'''[https://docs.google.com/spreadsheets/d/1My0rRHUK1MacQNmwR2e2Qxjonjpq815-0wrOpsGp2Io/edit#gid=1866346512 Vendor Mastersheet]'''

@@ Line 8: / Line 8: @@
 '''Dashboard'''- Depending the location of the crew and the service they are looking for, Operations will select the nearest location (yard) and the service from the dropdowns in cell C2 and C3. The list below will auto-populate depending on the selections the user makes. Operations should choose a "preferred" partner over "secondary" and "road based".
-'''Vendor Mastersheet'''- Contains a list of all existing vendors that Pothole Repair works with. Operations will use this tab to add new vendors or update existing vendor details by adding required vendor information.
+'''Vendor Mastersheet'''- Contains a list of all existing vendors that Pothole Repair works with. Operations will use this tab to add new vendors or update existing vendor details by adding required vendor information. For the "Priority" dropdown, choose "Preferred" for preferred vendors who are the company's first choice and close to the yard, "Secondary" for secondary vendors close to the yard and "Road based" for vendors who offer services away from the yard.
 '''Dropdowns'''- Contains a list of dropdowns that are used within the workbook. This tab can be ignored.

← Older revision		Revision as of 16:45, 2 February 2024
Line 1:		Line 1:
		+	Use [http://18.207.158.143:8080/index.php/Operations Operations] to go back to the Main Operations Page
		+
		+
	== Vendor Mastersheet==		== Vendor Mastersheet==