UPDATE: This post has been made largely irrelevant with this: https://github.com/thags15/LiveSplit.TheoryComparisonGenerator

If you don't care about changing values, I 100% recommend using this instead.

Original post:

Hello! This is my guide on how to create a true balanced comparison for LiveSplit. If you prefer a video walk through, one will be linked at the bottom. What is a true balanced comparison? A true balanced comparison (which will be referred to as TBC from now on) is a comparison that evenly distributes time save across the run based on the percent difference from your sum of best and either your PB or a goal time. Why would you want to use this if there already is a balanced comparison in LiveSplit? LiveSplit’s balanced comparison is weighted, taking into account past runs instead of being a simple % calculation. This can be good for splits that you are super consistent with, as it will try to move that time save elsewhere. However, the time save for each split can vary greatly from run to run as you feed it more information, and in my experience, doesn’t balance timesave enough. This is where TBC comes into play. This comparison has a more consistent amount of time save per split, and has the benefit of allowing you to create a goal time. This used to be a manual process, and if you are someone like me with a ton of splits (104!), this takes a long time and isn’t easy to update. I talked to Amitheous, a member in the SM64 community, and they believed they could automate the most tedious part by using Google Sheets. A couple hours later, they messaged me a sheet, so let me explain how it works.

First, open up the sheet, which can be found here: https://docs.google.com/spreadsheets/d/1C74b-OSHcgHPdxge1D4xqt7a4Wy5eYHsmBZ2FHgdqrY/edit#gid=0 Go to File, and click “Make a Copy” Name it whatever you want. Next, go to LiveSplit and edit splits. Click and drag from the first split name, down to the bottom right so you have the final best time highlighted. Control+C to copy, and go back to the spreadsheet. Click on Column A, Row 2 and Control+V to paste. Now, go to Tools, Macros, and click “Calculate Ideal PB” You may need to do this a few times. Most people get an error on the first attempt, the second attempt asks you to accept permissions (accept them), and the third attempt is what works. You now have the column “Ideal Segment” filled in along with an “Ideal Run”. By default this is 5% off your gold splits. You can click on the percent column and change it to whatever you like, as long as you keep the % sign. Decimals work too, but the sheet shows them as a rounded number. To apply this to each row, click and drag the blue box on the top box downwards to the bottom. To calculate a specific time, go to https://rechneronline.de/add-time/time-percentage.php and in time 1 put your goal time and in time 2 put your sum of best. You will get a number above 100%, drop the first two digits and that is the number you want to punch in the sheet. For example, if the number I got back is 104.66%, I would put in 4.66%. In order to create a comparison, go back to LiveSplit and click “Save Splits As” and name it whatever you want. You now have two identical splits files, but this one we will make our comparison. Edit splits, click “Other” in the bottom right, and select “Clear Times.” Go back to your sheet, and highlight the “Ideal Segment” column, starting from the second row. (You do not want “Ideal Segment” highlighted.) Control+C to copy, go back to LiveSplit, click the first box for “Segment Time” and Control+V to paste. Click “OK” and save the file. Open up your normal splits file, and edit splits. In the bottom left, click “Import Comparison” then click “From File.” Name the comparison whatever you want, and click “OK”. You now can compare against these splits. If you want to always have a comparison, edit your layout and add a Delta. Change the comparison to your new comparison, and you are finished! This guide was pretty rushed, so I’m sorry if it didn’t make much sense. If you are lost, I recommend watching this video I quickly made where I walk through everything: If you still are confused, leave a message and I’ll try to help, but please watch the video first!