tutorial: how to relinez using excel Aug 22, 2018 15:58:26 GMT Stormie, Budgie, and 6 more like this
Post by Ꮭilibet 🔮 on Aug 22, 2018 15:58:26 GMT
hi, meet toriel!
so. i told 𝓡iley 🧁 i would write out how i relinez things in excel literally months ago. and then i didn't. i am finally doing it today. i am going to assume anyone reading this knows how to hex most things and only explain how i renumber. i'm going to use riley's released codes for this since riley hexes by attaching subsequent 'strand' ballz to the ones before it in the strand, which means there is more renumbering to do. so - let's give toriel some hair!
uhhh lili please don't fall in love with your tutorial baby jfc what's wrong with you. anyway! so far, so good. but now we want to add riley's cat ears and tail to her. both codes are based on the first ball being #138 oh no! not to worry. paste all the codes into the .baby file in lnz pro and then reformat the lines so that when we paste into excel, each number will be in a new column.
reformatting the lines of code will make them look like this >
now! first of all we need to find out how many ballz are in the first code. we could count them, but i am not about that life. copy the hair code from lnzpro into excel, starting at row #138.
then highlight all the rows with text and no numbers by clicking on the row numbers & delete those rows.
now we know the last ball number in this hairstyle is #198, so our next code is going to start at #199!
take 138 (the starting addball number) away from 199 (the starting number of the next code) to find out how many ballz are in the code. now. sometimes. you will end up with a really easy number like 238. and you're like, i'll just do this in my head it's fine i am smart enough for this. 99% of the time, you are. 1% of the time.. you will do the whole rest of the process using the wrong number and want death. double check even the easiest numbers with a calculator, trust me.
now we are ready to renumber! if you are adding in a riley code as your second step, you will need to renumber ballz as well as linez. start by pasting the addballz section of the second code you're using into excel. there will be commas because we reformatted. we don't want commas. hit ctrl+h or replace under find & select. put a comma in the 'find what' box and leave the 'replace with' box blank. yes! you can replace with nothing thereby just deleting all of what you are replacing!! i, too, was zazzed to discover this!
now. remember the number we got for the number of ballz in the first code? in this case, it was 61. type that into an empty cell somewhere and copy it.
select all the ball numbers except for the first one of each strand...
...right click & hit 'paste special'...
... move the selection under 'operation' from 'none' to 'add', then press ok.
this will add the value in your clipboard (61 for this example) to all the data you had highlighted! remember how the second ball was attached to ball #138? now it's attached to ball #199, which we know is the first ball in our second code! copy the code, paste it all back into lnzpro, and reformat the lines again.
now we want to do the same thing in the linez section! paste all the linez part of the second code into excel, remove the commas again, grab your number difference (e.g. 61) in your clipboard again, and paste special over all the ball number values again. then copy back to lnzpro!
oh hi kitten!
obviously you can use this to remove parts of code too, or combine different hairstyles together, or add multiple parts of released codes together... goodbye manual addition and time-consuming really simple single number mistakes.
when i pasted back into excel, there was a bunch of random punctuation in the formatting!
copy the code into notepad instead of excel and use the replace with nothing trick to delete them.
the past special addition part isn't working on the second column!
there are probably tabs instead of spaces in front of the numbers. copy it back into notepad and delete the tabs.
everything has pasted into one column!
make sure you have reformatted in lnzpro before copying the data over to excel or under the data tab in excel hit 'text to columns'. select 'delimited' > 'space' > 'finish'. fun fact that is also how i do the bcrs tally.