Content: Slate Blackcurrant Watermelon Strawberry Orange Banana Apple Emerald Chocolate Marble
Background: Slate Blackcurrant Watermelon Strawberry Orange Banana Apple Emerald Chocolate Marble
Pattern: Blank Waves Notes Sharp Wood Rockface Leather Honey Vertical Triangles
Welcome to TerraFirmaCraft Forums

Register now to gain access to all of our features. Once registered and logged in, you will be able to contribute to this site by submitting your own content or replying to existing content. You'll be able to customize your profile, receive reputation points as a reward for submitting content, while also communicating with other members via your own private inbox, plus much more! This message will be removed once you have signed in.

  • Announcements

    • Crysyn

      Only help if you can be helpful

      Hey All, A topic has come up of late in the IRC channel in regards to the general feel of the forums and the community that supports them. Things have progressed further than I would have liked with out this being addressed more publicly because I would much rather have snubbed this out sooner rather than later.. but I have been busy. Here is the general rule I would like people to follow: Wheaton's Law "Don't be a dick." Those of you from the IRC channel know that this is the only rule I ask people in there to follow and we generally have a good and lively time chatting about all manner of things. This is basic rule that just about everyone understands and I am going to expand it to the forums from here moving forward. If you can not help people in a helpful and polite manner then I simply ask you to stop. Now I generally take a back seat to moderating the forums as I like to participate in the suggestions forum fairly heavily at times and would rather do so as a forums user than a moderator. But I am also fairly well known for being the person who constantly puts their foot down and so I am stepping up and doing so on here. If you find yourself unable to respond to a message politely then I ask that you do not respond. This mostly focuses on the increasing level of hostility found within the Suggestion forum as well as the Server forum. I do not care if this is the 30th some odd time you have seen someone make the same suggestion. Or even if the new post on an older topic is one entry above the old one. I expect the members of this forum to respond politely to the user, new or old, and point to the older topic if it applies and even go the extra step to suggest they either add in new information or to summarize the outcome of the previous discussion based upon the new post's entry into it. That is what we are here for, that is why I close most topics instead of deleting them, so that they can be found and referenced down the road. The next topic is the slew of derailment attempts I have seen as of late. If you want to have fun and joke around that is what the off topic forum is for and pretty much anything goes there. I do not expect to read a suggestion thread and have to go through 3 pages of image memes people have shot back and forth. Quite simply this is a waste of my time to read and then have to clean up. Now for the summary. I am going to start taking a more active role, especially in policing the suggestion forum, and handing out warn levels to people whom I see doing this. These will be indiscriminate and applied not to just the first person who derails or is impolite on a topic or response, but to everyone whom follows the lead of that person. As I do not like doing things with out giving you all warning this post shall serve as that warning. If you have a desire to bring this topic up with me then I invite you to do so on the IRC channel. Lets raise the level of quality and grow the community. Let us not descend into the quality often found on the minecraft or league of legend forums. There is simply no need for that here. Be passionate about things, just do not be abusive.
    • Kittychanley

      Offline Servers

      Recently I've seen a few server listings showing up on the first page of the Servers forum that have been closed for an extended period of time, but have recently gotten a reply from a new member who didn't realize the server is offline. To help prevent this from happening in the future, it would be greatly appreciated if you could use the report function on the original post of any servers that have been confirmed as offline, so that the topic may be locked. If you are the admin of a server and plan on taking the server offline, please use the report function on the original post of your topic to let the TFC Staff know that the topic should be locked. If you are the admin of a server that has a locked topic, and would wish to bring the server back online, please use the report function on the original post of the topic to let the TFC Staff know that the topic should be unlocked. As always, please remember to follow rule #3 of the servers forum and update your topic title to contain the version of TFC that the server is currently running. You can do so by editing the OP, and then clicking on "Use Full Editor."
Bennneh

TFC (+Technofirmacraft) Alloy Smelting Calculation Helper [V1.2]

6 posts in this topic

Hi everyone,

 

I've created my own Google sheet alloy calculator/helper that I wanted to share with you all.

It was created for use between my group of friends whom I play Technofirmacraft with on a private server, and thought it could be useful for others.

 

*Quick note

I based my design off an older sheet made by vzertaman that he released back in September 2014 (forum post)

This is why the layout is similar and i used his colours too because they were great identifiers. The calculations and formula's are my own and the idea has been modified to my own liking, I have in no way directly ripped this off as the calculations he did are basic SUM, PRODUCT and DIVIDE

 

This sheet as a lot of linked cells for formula's, and updates with the changes you make

 

What is it?

It is a Google doc excel sheet made for a small group, but released for everyone to use.

The ingot calculator will help you discover how many units of each material you need, based on the ratios of required ore/metal. The ratio’s are defaulted to what I (on a whim) declared ideal, but can be changed on your own sheet by editing the values within the range.

 

The alloy calculator will help you work out how much of each ore piece you need to get to the ratio and amount of units you desire. This page can be altered using the “Game” drop-down box (default to TFC) which is automatically alter the values per ore for the respective game/mod selected. (currently only “vanilla” TFC and Technofirmacraft)

 

How do I use it?

Access the sheet here: https://docs.google.com/spreadsheets/d/18IKPCwMfqP2_Bxe06ygK057YAFLgBcWOdpOHZeN2TAU/edit?usp=sharing

1: Go to file, and select “make a copy.” This will make a copy of the sheet on your own Google drive for you to use, this version is read only so that everyone can take the same version I've uploaded, and nothing can be changed.

2: Access the sheet from your own Google drive (wherever it saved to, usually default root folder)

 

Ingot Calculator

You can only edit the green boxes on this page

1: Select the kind of metal you want to make, and how many ingots you want

2: Alter the ratio’s to your liking, depending on the resources you have available. I.e. If you want to make Rose Gold, but you want to use more gold than copper, alter the ratio’s on the right for Rose Gold to values within the required ranges (shown above them) and ensure they equal 100%

3: The values below the metal selection will update and tell you the total units created, and the required number of units per metal for the alloy you are creating.

 

Alloy Calculator

You can only edit the game drop down window, and the quantities column in this sheet

1: Alter the numbers in the quantities column to choose how much of each material you want to use in your alloy.

2: The calculator will put together all the statistics you need, to show you the total units per metal, total units overall, each metal’s ratio and how many ingots/remaining units left over

3: The “Alloys” grid on the right will give you real time updates to show you when you are within or not within the ranges you need for an alloy. The “In Vessel” rows will go green when your ratio matches the required levels. When all metals are within the required ranges, and they all turn green, the red/pink bar to the left of the alloy will also become green. This indicates to you that your alloy is correct, and this is the product you will receive.

4: The reset button at the top requires you to be signed into Google to use, this runs a basic script to reset all values in the “Quantity” column back to 0

 

Using these helpers, you can calculate what you need before you do it in game, meaning less wastage of materials, less wasted time and more time on the forge. You can go from looking up the units you need for a certain amount of ingots, to working out what exactly you need to melt to get your result.

 

 

Version History

V1.0 – Basic alloy calculator to show ratio’s on the left, inspired by vzertaman

Added visual helper for alloy ratio’s on the right

Scripted Reset button to clear quantities quickly

Added “How to use” on the sheet for quick overview

 

 

V1.1 – Added ingot calculator sheet for early steps for new players, on request of a friend who hadn't touched metal forming and wanted an extra step of help

Added “How to use” on the sheet for quick overview

 

 

V1.2 (24/01/16)– Added “Mod ore values” sheet, input ore values for TFC and Technofirmacraft

Added “Game:” option on alloy calculator

Re-functioned alloy calculator so units update with game selected

Re-functioned ore list so the titles also update values with game selected

 

Bug History:

None so far, first major release no bugs known

 

Rights to use:

This sheet can be used by anyone, anywhere in any space time dimension

You may use this in videos and/or streams

You may redistribute this to others

All I ask is you don’t take credit for making it, as I haven’t taken credit for the original design

 

Disclaimer:

I  am by no means in any way trained in using an excel sheet to this degree, this is the largest and most complicated sheet I have made in excel and there may be ways to improve the formulae and functionality, I created this to the best of my ability and it functions well when tested by me and 4 others. If you do have suggestions to improve the sheet, I am more than willing to look into it. The sheet may not be perfect, ore values may change or be incorrect, but during testing no incorrect values were found.

 

 

I am open to suggestions regarding changes, improvements and any other thoughts you have.

Please leave these notes in this thread for me so I can see them, I will respond and update this post as I go, any new versions of the sheet will require you to make a new copy to receive the up to date features.

0

Share this post


Link to post
Share on other sites

What I'd like to see in one of these calculators is the ability to put in a quantity of desired ingots of black, red, or blue steel, and then an output which tells me the quantities of all the *base* metals I'll need.  So not the alloys that go into the colored steels, but the base metals that go into the alloys that go into the steels.  I want to be able to say 'ok, how much copper, iron, nickel, silver, etc do I need for 14 blue steel ingots to make the anvil?  Then I can look at my stock of base metals and figure out where I need to fill in the gaps, and then spend a nice long session of smelting and smithing with the end result being a quantity of blue steel meeting or exceeding my goal.  Or, look at a cube of 64 copper ingots, and be able to figure out simply how many blue steel ingots I can get out of that.   I'd really love to see that kind of calculation.

2

Share this post


Link to post
Share on other sites

What I'd like to see in one of these calculators is the ability to put in a quantity of desired ingots of black, red, or blue steel, and then an output which tells me the quantities of all the *base* metals I'll need.  So not the alloys that go into the colored steels, but the base metals that go into the alloys that go into the steels.  I want to be able to say 'ok, how much copper, iron, nickel, silver, etc do I need for 14 blue steel ingots to make the anvil?  Then I can look at my stock of base metals and figure out where I need to fill in the gaps, and then spend a nice long session of smelting and smithing with the end result being a quantity of blue steel meeting or exceeding my goal.  Or, look at a cube of 64 copper ingots, and be able to figure out simply how many blue steel ingots I can get out of that.   I'd really love to see that kind of calculation.

 

That actually wouldnt be that hard, ive already got the calculator for ingots so i guess all i need to do is just drill it down, i've just reformatted my PC so once its all up and running again ill take a look and post an update for you :)

0

Share this post


Link to post
Share on other sites

The main problem with this would, of course, be the "between x% and y% of copper" bit for the alloys.
This would possibly mean that for your 100 ingots of blue steel you need between (for example) 20 and 50 ingots of copper, 10 to 30 ingots of tin etc... 
The problem then, of course, would be how much of that copper has been calculated in the bronze and how much into the brass, or sterling silver...

0

Share this post


Link to post
Share on other sites

His calculator allows you to specify the percentages of each alloy, so the user can control what percentages are being used for each.  I actually have my own spreadsheet similar to this for figuring out what 1 ingot of each colored steel costs.  But I've always wondered if I'm doing the root alloy calculations right.  For instance, I came up with one ingot of blue steel costing, in the end, 265 iron, 39.25 copper, 22.5 nickel, 9.75 silver, 7.5 gold, 3 bismuth, and 3 zinc (at my own preferred percentages of course - 50% BS, 15%BB, 25%Steel, and 10%SS, and the sub-alloys having their own of course).  350 total units go into that one ingot of blue steel - which confused me at first, as I expected 300, but it's that vanishing pig iron you weld onto the black steel that does it, in the weak blue steel stage which I have at 50% BS, which means you're having 1.5 pig irons vanish, not just 1 for the weld-on BS I was considering off the top of my head.  I made this after mining a ton of nickel, and wondering how long it would last me.  Discovered I should have spent a lot less time on the nickel and silver, and a LOT more time on the iron.  I calculated the bare minimum iron possible is 245 units, for 1 ingot of either red or blue, but you use more silver and nickel doing that.  I was basically maxing out the alloys not involving iron, nickel, or silver, and then decided to prioritize saving the rares, since the 20 point iron swing, in the scope of 350 total units, is kind of minor.

Edited by Darmo
0

Share this post


Link to post
Share on other sites

this does rather show how ridiculously expensive the coloured steeels are, doesn't it :)

0

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now