New Lifter

Generic PL Scoresheet Instructions

You will need a copy of the scoresheet program for each lifting platform/session. Before you start practicing, save a copy of the program to a safe location!!

I’ve tried to make this program flexible enough to handle most powerlifting contests. It can be configured for single-lift, ironman or 3-lift contests, pounds or kilos at weigh-in and on theplatform, 30 kg/55 lb squat bars, Schwartz, Wilks, or Glossbrenner coefficients, and scoring by weight class or coefficients.

Note: Some of the pictures may have come from a different version of the program and may not look exactly the same as the version you are working with.

If you have problems or something isn’t working, please let me know so I can fix it. (It really helps if you e-mail acopy of the program you were using when it didn’t work correctly)

There is no charge for using the program and I may be freely copied and shared. It is copyrighted because I wouldn't want somebody else to sell it. All I ask is if you use the program and you like it, that you consider a contribution in my daughter's name to the Silver Lining Foundation/Little Star Foundation. You can find themon the web at:

http://www.littlestar.org/

In January 2002 we lost our 16-year-old daughter - Liz Marksteiner - after a 16-month fight with cancer. She grew up around our Powerlifting family. While Liz never had any desire to lift, she was so proud of my wife and me when we were competing.

When she was old enough she almost always found a way to help out at the competitions - if shewere here she'd be running this program. The summer before her death she spent a magical week at the foundation’s Silver Lining Ranch in the Colorado mountains she loved. The ranch is a retreat for kids with cancer and it meant so much to her and us.

Best of luck with the program.
Sincerely,

Joe Marksteiner
5575 Raven Valley Drive
Liberty Township, Ohio 45011

e-mail
home:steinmark@aol.com
work: joe.Marksteiner@ge.com

phone
home: 513-755-6878
cell: 513-477-0775
work: 513-552-2122
Getting started
• Open Excel (the program works in Excel 2000 and later versions)
• If you have more than one lifting session, you will need a copy of the program for each session.
• Change the security level in Excel (if you are running the program in Excel 2007,see the information on the last page)



• Click on Tools at the top of the screen
• In the drop down Tools menu select Macro
• In the Macro dropdown menu select Security
• When the Security window pops up, choose Medium


• Open the Excel file and then save it to your hard drive (Saving to a USB device can be very slow). Then find the tab for the Setup pageand click on it.

[pic]

Excel 2007 Compatibility.
Immediately after you open the .xls version of the file in Excel 2007 do a “Save As” an “Excel Macro-Enabled Workbook”. This will save the program in the Excel 2007 xlm format and preserve your original program file in the 2003 and earlier format. Obviously the 2007 xlm file now only works in Excel 2007. If the file gets corrupted it may notwork correctly in any version of Excel.



Contest Setup
Go to the Setup sheet
[pic]

Type in the Contest Name. It is automatically loaded onto the printout sheets and the title on the Awards page. Select Lb or Kg from the dropdown list in the black block in the upper right corner depending on the platform weight set – it will hi-light the area for you to provide the data. The programcan provide your results in both Pound and Kilos - click yes or no in the pulldown




Type in the Date. It is automatically loaded onto the printout sheets.

Use the drop down menu to select the number of plates available at each weight on the platform. Select the Weight of the bar used for Squat and Bench & Deadlift from the dropdown menus.
[pic]

Select BWt (Lb) or BWt (Kg) from...