Welcome to the Sheepulator download site. Click on the link below to download the sheepulator (it is the Excel file).
E-mail sheepulator@gmail.com with any questions.
INSTRUCTIONS:
Here are the instructions. It looks kind of complicated, but I suggest
you run through it once with the sample data and you will see how it
works, it's not hard.
-------------------------
You must know how to run a macro in whatever version of Excel you
have. If it's Excel 2007, it's the Developer tab in the upper right
followed by Macro button in upper left. If you don't have the
Developer tab, you must enable macros, how to do this is easily found
on the internet. If you have Excel 2003, I believe it's under Tools >
Macros > Macro.
The workbook is set up for 3 basic phases. Set up for scoring, score,
and reveal.
SETUP
Place your data the way that I have it in the sample data on Sheet1.
You must use Sheet1. Player names first row, responses to first
question in second row, responses to second question in third row,
etc. This should be easy to do by copying and pasting PM's from 2+2
into the appropriate cell in the second row.
Run the macro Mastersheepulator. This will create a sheet for each
question, called "Question x", where all players' answers will be
sorted in alphabetical order. This is so that responses that already
match will be adjacent to each other so you don't have to do as much
manual editing.
SCORE
Go through all the "Question x" sheets, make all like answers match
each other EXACTLY, and place a 1 in column D next to incorrect
answers.
Now run the macro DoScoring. Now on each question sheet, in column E,
you will see the score for each CORRECT answer. For each INCORRECT
answer, you will see the value "FALSE". This is SUPPOSED to be there.
In column G, you will see various things relating to the question,
including the score of the sheepiest answer, and the score for an
incorrect answer for that question.
If you change things on the Question sheet after you have already run
DoScoring you may see numbers in column E change. This does not do
anything permanent until you run DoScoring and Revealthisquestion. In
other words, if you want the macro to be able to do Standings for you
automatically, do NOT copy and paste stuff from the question sheet
into 2+2 and try to do the reveal that way. The Standings macro
DEPENDS on the existence of appropriate "Reveal Question x" sheets.
REVEAL EACH QUESTION AND DO STANDINGS AFTER THAT QUESTION
Now go to sheet "Question 1". Run the macro Revealthisquestion. This
will create a new sheet called "Reveal Question 1". This is the sheet
that you will copy and paste into 2+2 or whatever text editor you
want. Answers are grouped and ordered, incorrects will be at the top
(because they have the highest score) and aces will be at the bottom.
You can copy columns B through E and paste them into 2+2. Then
manually insert line breaks if you want.
Option for making a better looking reveal:
There is a macro called MakePrettyRevealSheet. If you run this macro
while on a reveal sheet, column J will then become something you can
copy and paste directly into 2+2 with nice headings and bold text.
Now go to sheet "Standings Worksheet". Put the number of questions to
run standings through in cell G2 and run the Standings macro. You MUST
have revealed the first x questions with the Revealthisquestion macro
in order to correctly do standings through the first x questions. The
standings will appear on the left side of the Standings worksheet. You
can copy this into 2+2 box for posting.
Repeat the process of going to sheet "Question x", running
Revealthisquestion macro, going to appropriate reveal sheet, copying
and pasting to 2+2, going to standings worksheet, putting appropriate
number in cell G2, running Standings macro, and copying and pasting
standings to 2+2 for each question.
When you have run standings through the last question of your game, you're done!
-----------------------------------------------------------------
NOTES
You can go back and forth between sheets with the keyboard with
Ctrl-PgUp and Ctrl-PgDn.
You can either go through all your questions, clean up the data, mark
incorrects, and then score all questions at once (this method is
explained above) or you can go through each question one by one and
run DoScoring after it. DoScoring will always score all questions,
even ones you haven't touched. Ones you have not gone through will
obviously not have the correct scores because you haven't marked any
answers for that question as being wrong yet. However, this does not
matter, when you come to that question and do clean up the data / mark
incorrects, simply run DoScoring again.
This is probably obvious, but if you're running a straight sheep game
and not reverse sheep, just don't mark anything incorrect and the
scores will be appropriate.
A common problem is forgetting to run DoScoring after doing something
that will change the scoring such as marking a different answer wrong
or making answers match that didn't match before.
-----------------------------------------------------------------
I've explained this as well as I know how. If you do not understand
the explanation, please tell me. If the workbook does not work for
you, please let me know, and please tell me how it is failing. I know
that the program does not contain logical errors, as I've used it for
multiple games now. However if the workbook is not used exactly as it
was intended, it may not work.
Looking forward to feedback.
Fleebrog