Office Equipment

Xls Employee

6 Easy Steps For Smart Managing Equipment Maintenance Management Software

We all know that having an equipment maintenance management software is a must inside our company for reducing costs, saving,for availability of assets and even for the cars we own. You will learn how to apply effectively maintenance with or without the power of an equipment maintenance management software. You will need Microsoft Excel and Microsoft Word. To begin create a folder in your pc for storing the files we suggest in this tutorial.Name it "My Company Maintenance"

Step1: Organize your environment

One of the most important steps before using an equipment maintenance management software and getting the most from your company is to know your goals about maintenance. So what are your main goals: is it availability, or reduce repairing?

Write down you goal, and lets begin!

Step 2: List and group the assets

You need to group those assets by different or specifics needs for example: all the cars, all the truck of specific year, make,etc. this is in order to define the maintenance tasks and common maintenance routines recommended by the supplier for each group.

One of the benefits that an equipment maintenance management software should give you is grouping your equipment for easy managing and scheduling.

Open Excel and create a note book inside the folder and name it "Assets List.xls". Add one row per asset.Include the columns: Asset Id, Description, Group, Location

Step 3: Define the tasks

Create a note book inside the folder and name it "Task List.xls".Add one row per task.For this book include the columns: Task id, Description, Frequency, File name.

Step 4: Define the task content

Open Microsoft Word and create a new document for each task, for each document write a title task, task number, time needed, men needed,tools needed, materials needed, task steps and the special and security considerations. You can name this document "Task Number.doc"

Now in the workbook "Task List.xls" make a link from each row to the corresponding task content file(in the cell just right click and select "Hyperlink..." from the menu)

Step 5: Scheduling

Now you have your asset group list and maintenance tasks written down.
Scheduling maintenance is where an equipment maintenance management software will be most useful. Before setting the scheduling you need to answer some questions:

-Annual budget for maintenance.
-Which assets or equipment you will need available and when?
-Which ones will be working while the others are stopped by maintenance.
-Where will be applied the maintenance, a contractor or internal employee.
-How much time will be needed for this maintenance?

After that, create a new excel book and name it "Scheduling.xls".It should contain at least the columns:  asset id, asset name, task assigned, task name, scheduled value.
Select the provider manual to help you begin to write down the scheduling values.

Step 6: Typing the data  into an equipment maintenance management software

Finally open your equipment maintenance management software and look where you can add assets, add task, schedule task for typing in the data already recollected by you.

If you want to  try an easy to use equipment maintenance management software and how to control scheduling faster than ever, just click in the link below

About the Author

Ramon Elias Rodriguez is an expert in scheduling and maintenance assets, he
is the owner of readyAsset at http://www.readyasset.com, visit us to download
a free trial

How can I use VB / Macros to fill out a certain form from information in an Excel document?

Here are the details: I have to set up accounts at work, and we have this webpage we log into, and I have to manually type information like First name, Last name, Employee ID, etc..with a list of 20-40 users at a time. I want to be able to autofill the fields on the webpage form, from data in an excel document. For example, the first time it would autofill the form, it would use the data from the 1st user, then submit I want to be able to submit the form, then hit a macro or something to automatically use row 2 for the information the next time I run the macro. Can someone help me? By the way, the excel document would be set up as Row 1 displaying the type of data or course i.e. SSN, first name, last name, etc.., and each row underneath represents a different empoyee. I can show a sample .xls file if needed. Thank you!.

About the easiest way to go about this is to automate the web browser. I'm going to assume some competence with VBA. Let me know if I'm glossing over too much.

Add a UserForm. In the "Toolbox" toolbar, right click in the gray area, hit "Additional Controls", and checkmark "Microsoft Web Browser". Add one of those to your form. Open the Object Browser (F2), right-click in a gray bit, hit "References..." and checkmark "Microsoft HTML Library".

I'm going to assume you know how to loop through the rows on your spreadsheet, how to get information from those rows, and how to store which row you sent last (there are an easy dozen ways of doing each).

And now for the quick code example to give you at least a rough idea:

' ------------------------------
Dim htmlDoc As HTMLDocument
Dim htmlForm As HTMLFormElement
Dim htmlInput As HTMLInputElement

WebBrowser1.Navigate "http://www.google.com"
Do While WebBrowser1.Busy
DoEvents
Loop

Set htmlDoc = WebBrowser1.Document

Set htmlForm = htmlDoc.forms("f")

' Quick sanity check to make sure we got the result we were asking for
If htmlForm Is Nothing Then
MsgBox "Form not found. Cancelling do to unexpected result."
Exit Sub
End If

Set htmlInput = htmlForm.namedItem("q")
htmlInput.Value = "answer"

' If you want it to submit:
htmlForm.submit
' ------------------------------

Your Object Browser and msdn.com should help fill out any other questions you have regarding the forms.