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.
Server Move 09/13/2018I (Dries007) have recently taken over as main developer and server admin. This involved moving servers to reduce cost. It's likely there will be some more downtime in the future but most things should be sorted by now. This forum is in dire need of replacement as the software is quite old and can't be easily updated. If you wish to discuss or stay updated, join our discord: https://invite.gg/terrafirmacraft. The forum will remain available to read, but will be locked in the future, when a new system is setup. The forum and wiki are now ad free. If you'd like to contribute to keeping it that way, you can do so via paypal or patreon.
ATTENTION Forum Database Breach 03/04/2019There has been a breach of our database. Please make sure you change your password (use a password manager, like Lastpass).
If you used this password anywhere else, change that too! The passwords themselves are stored hashed, but may old accounts still had old, insecure (by today's standards) hashes from back when they where created. This means they can be "cracked" more easily. Other leaked information includes: email, IP, account name.
I'm trying my best to find out more and keep everyone up to date. Discord (http://invite.gg/TerraFirmaCraft) is the best option for up to date news and questions. I'm sorry for this, but the damage has been done. All I can do is try to make sure it doesn't happen again.
Search the Community: Showing results for tags 'helper'.
Found 1 result
Bennneh posted a topic in Addons & ApplicationsHi 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 byvzertaman that he released back inSeptember2014 (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 aGoogledoc 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-downbox(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 ownGoogledrive for you to use, this version is read only so that everyone can take the same versionI'veuploaded, and nothing can be changed. 2: Access the sheet from your ownGoogledrive (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 whohadn'ttouched 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-functionedalloy calculator so units update with game selected Re-functionedore 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.