GROUP WEIGHT TRACKER TEMPLATE FOR EXCEL PROFESSIONAL
GROUP WEIGHT TRACKER TEMPLATE FOR EXCEL FREE

What I would like to happen: is every time we enter a completed line on the sheet, to have Excel, or a script, create a new Sheet (basically, create the BOL for that truck from a template that I have not made yet), auto-number it based on the 'BOL number', populate it with the Truck number, gross, tare and net weights, and have it auto-print multiple copies (for the driver, for our accountants, etc). Since we are already entering this data into a spreadsheet, and the BOL’s we use are sequential, and only used for the barge, I figure there has to be a way to cut-out the preprinted carbon-less copies, cut-out using the typewriter, and speed everything up overall.įor example, our spreadsheet is setup like this:Īs I said, I do not know if Excel is what I should use, but it is what we are currently using. Currently, we use Excel for this it keeps a running tally of our weights, and calculates average weights, an estimate of how many loads remain based on the target weight, etc. We also have to keep a spreadsheet of the weights so that we have an idea of how far along we are with loading. Then, once we have a stack of BOL’s printed for that barge (about 90% of how many we think we need, because we cannot print extras) and we begin loading, we still have additional information to add to each BOL when the truck is finished loading the truck number (we always use the same carrier), and the gross, tare and net weights.

GROUP WEIGHT TRACKER TEMPLATE FOR EXCEL FREE

This process is time consuming (even running a macro on the typewriter, it still takes over a minute per BOL) so it needs to be done ahead of time, we usually start a day or two early, when we have a free minute or two in between our other shipments and deliveries.

onto a preprinted 6 page carbonless BOL (preprinted with the shipping disclaimers, signature lines, etc).

Since each truck is going over the road, it needs to be loaded legally, and have the appropriate paperwork necessary (a Bill of Lading).Ĭurrently, when we ship a barge, we have to type via a typewriter, all of the consignment information, addresses, sale orders, etc. Anyways… we ship barge loads of metal, but due to our location, we cannot load directly into the barge, so we have to ship, by truck, about a mile down the road to our dock. I work for a metal recycling company, currently we are using paperwork that is so outdated, saying that it is stone-aged may be putting it mildly… (just switched away from carbon-paper, to carbon-less paper about a year ago).

GROUP WEIGHT TRACKER TEMPLATE FOR EXCEL PROFESSIONAL

It can also be used in the clinical or professional setting, where physicians or dieticians, to name a few, can record information on each of their patients or clients.I have no idea if Excel is even the correct program to be using, but it is what we are currently using at my company, and I figure baby-steps are the best way to get anything accomplished. The design and format of the table and charts are aesthetically pleasing and professional enough to be used for presentations and reports. It shows the morning and evening systolic and diastolic heart rates and from here, you can automatically see the trend to see if you are doing well and are maintaining a healthy blood pressure throughout the given time period. Once you have typed in the needed data, the chart automatically updates to show the tracked progress of the blood pressure and heart rate records. This way, you can easily spot the days and times when you have high blood pressure and therefore avoid any food or activity that may have contributed to it. The template’s built in formatting automatically recognizes if the blood pressure record is abnormal and highlights that specific record in red. This template allows you to record daily blood pressure and indicate the time of recording. The physician’s number is also listed for emergency situations.Īutomatically Track Abnormalities in Blood Pressure There is also a reminder that allows you to create an alert if the systolic and diastolic rates reach a certain abnormal level. The blood pressure and heart rate tracker template contains a header where you can type in your name and set your target blood pressure in terms of systolic and diastolic rates. Then, by typing in the required information over a period of time, the template also automatically generates graphs and charts for visual representation of data. This health themed template allows users to create a profile about an individual, a patient, or a client’s blood pressure and other health data into one profile. This template is professionally and specially designed for tracking blood pressure, comprehensively measuring data over a period of time.Ĭreate Your Blood Pressure Profile and Monitor Trends

For anyone wanting to track blood pressure for personal, group diet or nutrition, or even for professional reasons, you can use the Blood Pressure and Heart Rate Tracker Template for Excel, which is specially designed for medical, health and nutritional purposes.

Group weight tracker template for excel