Unfortunately this spreadsheet is long gone. If you to join the discord I’d be glad to chat with you and help!
@denesch4 ай бұрын
@@andtechie5210 please share DS with me as that under video doesnt work
@andtechie52104 ай бұрын
@@denesch discord.gg/tkJxmGVE
@paulharris69774 ай бұрын
@@andtechie5210 discord link expired, could you send me one please? :)
@andtechie52104 ай бұрын
discord.gg/4YxnEmY9
@mgvikings14844 ай бұрын
I think i am late to the party^^ but did i miss part 3, i cannot find it. most follow up videos came out 3 years later....
@andtechie52104 ай бұрын
Hey 👋🏼, I’m glad you’re excited for part three. I hope these have somewhat helpful. Part three will not be coming out any time soon. 🥲. But feel free to join the discord we can chat further and I’d be glad to help
@MysticalDragon738 ай бұрын
1:44 You mean BLOCKADE runner NOT DST. You can cloak a dst yes. but you cannot warp cloaked.
@andtechie52108 ай бұрын
Yes.
@timtomlins15489 ай бұрын
This is pretty much exactly how I have been doing it. Nice to have confirmation I'm not missing anything or over complicating something.
@andtechie52109 ай бұрын
I’m sure there are fancier ways but this is how I usually do it. And I just build up my library of things I know are decent.
@shantvincent78210 ай бұрын
You could probably teach excel classes on the side... thanks for the content.
@andtechie521010 ай бұрын
I’m glad these are still inspiring people! 🎉
@jogaleidm3858 Жыл бұрын
So... where can I find this Spreadsheet?
@andtechie5210 Жыл бұрын
It’s currently a work in progress. You wouldn’t want it as it is right now trust me. But we do have a community of people that could help you make one or improve on yours.
@Quickbookish Жыл бұрын
Saw your back to producing, the eve reaction videos are great! Thanks again
@andtechie5210 Жыл бұрын
More to come!
@GDPanda69 Жыл бұрын
Glad to see you're back and what a choice to come back with!!!
@andtechie5210 Жыл бұрын
Thanks! Appreciate you sticking around.
@MrJackTowers Жыл бұрын
Bro woke up and decided to make a banging factorio video
@andtechie5210 Жыл бұрын
Hope you enjoyed it!
@frechesferkel2749 Жыл бұрын
Industry for new player is total dead. Nearly all blueprints have higher build costs than the endproduct sells and that with a large difference.
@andtechie5210 Жыл бұрын
Yes it’s very hard to get into as more experienced players have invested into all the structures and bonuses to produce things cheaply. But with a good eye it’s possible to find things!
@joeevan6265 Жыл бұрын
Shit video
@andtechie5210 Жыл бұрын
@14:30 start
@dadillegaming1563 Жыл бұрын
Thnx man, you saved me a lot of headaches. Lol I would like to see the pricing part though but I think i can figure it out from here
@andtechie5210 Жыл бұрын
Glad it helped!!!
@andtechie5210 Жыл бұрын
Start @7:50
@zaron86142 жыл бұрын
I have done my own sheet but I will like to know what colors are you using on your sheet 😅
@kliderskope36622 жыл бұрын
WOW…… So I just moved to null and want to begin doing reactions as a complete newb to sell the refined moon products in Jita. I have a particular ice field close by and several available moons. I thought (in terms of PI, I would refine down to convenient transportable size with a reasonable resale value.) I began your guide series and this video and as it started I thought OMG what’s going on how complicated is this! But buy the end of this video I honestly felt, with your Excel explanations, that I can actually do this. So thanks 🙏 One question though, is this still relevant in today’s game? As a returning player I know there has been a lot of changes to mining all round.
@andtechie52102 жыл бұрын
That’s awesome!! Find our discord link in the latest stream, tons of help in our discord! This is definitely still relevant! Even though moons have changed resources or whatnot. The ingredients for the components are the same!
@kliderskope36622 жыл бұрын
@@andtechie5210 thank. I will check the discord.
@christianreyes79312 жыл бұрын
This method doesn't work anymore. Theres no way to split columbs to separate buy and sell.
@andtechie52102 жыл бұрын
It still works !
@NerdishNature2 жыл бұрын
ive never really done industry in eve in nearly 19 years but now that i see your neat spreadsheet, i'm interested :D
@andtechie52102 жыл бұрын
Join the discord! We’ve got good people
@zaron86142 жыл бұрын
Are the prices update automatic? Or i have to do the page query every time?
@andtechie52102 жыл бұрын
Do search every time, but the process of splitting things is already done you just need the new url
@Thunder_Yoda2 жыл бұрын
Awesome, thanks.
@nomad_nz81792 жыл бұрын
Very nice tutorial man.. I wasnt looking to do reactions due to the sheer amount of items/values you need but after watching your vid I'm excited to try it out :). Thank you
@m1k3y482 жыл бұрын
Thanks for this, not only was it the top search result, but it worked first try. Much appreciated!
@andtechie52102 жыл бұрын
Glad to hear!!!!
@FawinkGaming2 жыл бұрын
followed this to see if I can pull it off to build myself a T2 ship from scratch
@andtechie52102 жыл бұрын
Did it work?
@FawinkGaming2 жыл бұрын
@@andtechie5210 It did, I managed to get it done :), thx
@tr33br062 жыл бұрын
Lol, you are a mind reader. I came to nerd out with stats to improve my own!
@sethikablip86072 жыл бұрын
this is the reason why this game should be called spreadsheet online
@andtechie52102 жыл бұрын
It’s pure bliss
@typhon18613 жыл бұрын
I followed your steps but I keep getting an authorization error. It takes to a screen to log into my eve account, i select my character and then pressing "authorize" just gives me an error :/
@andtechie52103 жыл бұрын
Hmm idk join our discord! We’ve got some people that may be able to help
@LokleyTheo3 жыл бұрын
Can't say you're doing it optimal, but it does explain the idea well! Thank you)
@andtechie52103 жыл бұрын
This was my first rendition for tackling reactions. I’m glad it was of some use my current setup works much better!
@Brazabrad3 жыл бұрын
I'm using google sheets, I can't seem to just copy and paste the sumif like you can. And suggestions?
@andtechie52103 жыл бұрын
I would go back and try to make sure I understand the formula. Boa Sorte
@woollygoat89213 жыл бұрын
Am I the only one who needs an Excel tutorial to follow along?
@andtechie52103 жыл бұрын
Probably not, I have to do some double takes to understand it sometimes.
@butter16493 жыл бұрын
Hey, is it possible from the large item list that you have there try to filter items like t2, factions or BP in the excel?
@andtechie52103 жыл бұрын
Join the discord I have a mega list of every bp in the game with their materials and qty, based off the SDE from fuzzworks
@NebakinezaOG3 жыл бұрын
Learn to use EVE Isk Per Hour. It will save you hundreds of hours of your time
@andtechie52103 жыл бұрын
I enjoy the journey as much as the destination.
@Abezy7123 жыл бұрын
Love eve and all the aspects but damm my brain is hurting between hauling market abyssal lol
@andtechie52103 жыл бұрын
Oh you’re doing all 3?
@Abezy7123 жыл бұрын
@@andtechie5210 yup thats the problem. Got toons for all types of stuff but still seem to be spending more isk then making or braking even... 😕 still love the game tho
@andtechie52103 жыл бұрын
@@Abezy712 probably good to master one thing at a time
@Abezy7123 жыл бұрын
@@andtechie5210 Your right. Sad part everytime I see a video i want to try that but will focus on abyssal and small scale manufacturing. Then plex with that income. Thanks again for your videos
@andtechie52103 жыл бұрын
@@Abezy712 👍🏼 see you around!!!
@stevo65723 жыл бұрын
very confusing video...U give no reasoning for anything U did...I will figure it out on my own
@andtechie52103 жыл бұрын
Hi 👋 sorry this one was a confusing one. I hope that it at least did something for you. Have a good day!
@RogerChessell3 жыл бұрын
This a great insight into your processes and helps me a lot. I am building my own spreadsheet and i have got stuck a couple of times on how todo something. You have unblocked my thoughts and i thank you very much. I am a member of your discord and look forward to more useful insights when i wake up in the UK
@andtechie52103 жыл бұрын
See you around !
@isthisnew16273 жыл бұрын
very helpful, thank you for this, my esi keeps braking in my sheets, this seems to keep working. ty sir
@andtechie52103 жыл бұрын
Awesome! Glad to know that.
@stevo65723 жыл бұрын
Yawns...just another useless video
@andtechie52103 жыл бұрын
Sorry that it didn’t do anything for you. It’s a simple way of pulling prices for people. Hopefully you’ll find what you’re looking for.
@IanVaughanMe3 жыл бұрын
Great video, many thanks! Only feedback would be to zoom in a lot as its hard to see.
@IanVaughanMe3 жыл бұрын
Can you share the sheet you have created?
@pablosanhueza14543 жыл бұрын
Amazing, thanks you
@bveenhuizen78763 жыл бұрын
Hi,is there a way to avoid that the items change positions once you have added an item to the list? Exampl Item A is at position 134 but after adding a item it is at 135.So wen i wanna use the attached pice at that position in other sheets i get a wrong price
@andtechie52103 жыл бұрын
I think what would solve your problem is a vlookup, that formula will find what you need and bring the price back.
@crynfish56053 жыл бұрын
Add-on is gone, but look here: github.com/evepraisal/evepraisal-google-sheets
@IanVaughanMe3 жыл бұрын
but it looks like it doesnt support lookup by name now, only by ID
@IanVaughanMe3 жыл бұрын
ah, I missed the extra brackets!! all good now cheers
@jamesshields53023 жыл бұрын
Would ?live=true solve the issue of needing new urls each time? not sure how that would work if you need ?full=true.
@andtechie52103 жыл бұрын
The ?Full=true removes the limit of how many prices you get back. With that the site will only return a limited amount of items. I haven’t found that the live?=true gave back updated prices let me knowing it does! But then it would return only a limited amount lines. This is obviously a very over simplified way of pulling live prices without having to go through the api it itself! Feel free to join the discord!
@zaron86142 жыл бұрын
@@andtechie5210 can I have the discord link pls
@andtechie52102 жыл бұрын
@@zaron8614 discord.gg/5T8JeeFs
@Dyhrrr2 жыл бұрын
@@andtechie5210 me too pls, that one is expired :(
@andtechie52102 жыл бұрын
@@Dyhrrr discord.gg/qHFG2dWb
@thomasreed24273 жыл бұрын
Thank God for python and openpyxl. I cannot imagine doing stuff manually like this, when a nice script does it automatically for all T2 items in a few minutes, while calculating profitability at current market prices.
@andtechie52103 жыл бұрын
Yes 👍🏼, this takes a bit of work. I really like my tracking system
@roelofversluis66803 жыл бұрын
Thank you for this. Not only did I see that reactions are not that hard to comprehend, I learned quite a few things of Excel as well. Hehe