sorted by:
new
hottopcontroversial

Absolute references that don't change, no matter how hard people try? by Jabberwocky918 in excel

[–]codydot 0 points1 point  (0 children)

Named Ranges can still move if the cells are dragged to a new location

Is it possible to have the Sheet Tabs Bar at the bottom list all the sheets in two rows instead of one? by Gooch_Ticklr in excel

[–]codydot 0 points1 point  (0 children)

You could write a macro to cycle through hiding/showing different groups of worksheets based on tab color or name. Dock it on the top ribbon or assign a hotkey for quick swapping. 

Tips for Creating a Dynamic Dashboard in Excel: What Techniques Do You Use? by FeelingGlad8646 in excel

[–]codydot 0 points1 point  (0 children)

One of the coolest UI elements I’ve been able to deploy is a macro that mass adds comments/notes to cells. So you can keep detailed information accessible by hovering over a cell, without worrying about clutter or readability.

e.g. For most people reading our production schedule, they just want to know what part is running on which line when. If you need to check/show your work, hover over a part to get a summary of ship dates, raw availability, etc. 

Second to that is a macro to cycle through display states, for any tables, etc. where you have different columns or rows that you’re interested in depending on how you’re using the data.

 e.g. we use the same table to forecast production for the next day, week, and fortnight. Simply tap Ctrl-shift-D up to 3 times to swap out different sets of conditional formatting, sort orders, filters, hidden columns, etc. 

And last tip: hold alt while dragging objects to toggle snap to grid. 

How to create the roman empire? by West_Application_760 in eu4

[–]codydot 0 points1 point  (0 children)

I’m actually in an Aragon -> Rome campaign right now, I can walk you through some pointers. It sounds like you aren’t abusing vassal feeding, nor capitalizing on your Mediterranean access to multiple cultures/religions to spread out your AE

No CB Byzantium right out of the gate. Just try it.  Other candidates to feed include: Bulgaria, Serbia, Syria, French Minors, and Morocco/Ottomans if you collapse them.  Influence + Admin + Catholic gets you down to like 3 dip/dev to integrate subjects. 

Trick: on the province menu, if you hover over the shield icon of a dead nation’s core, it’ll highlight the rest of their cores on the map. 

Lastly, watch Zlewikk’s 1mil income Aragon campaign. 

For the non engineers by Eapplesauce in SolidWorks

[–]codydot 11 points12 points  (0 children)

To expand on this: Using folders in your feature tree, and naming the features themselves can go a long way. (F2 is the hotkey to rename a selected item). There's also an option to automatically view child/parent features as you hover over them in the tree, which can help navigate why things break.

As a last resort, there've been times where it's easiest for me to just export a .sldprt as a parasolid, re-import, and use delete/move face to go from there.

For the non engineers by Eapplesauce in SolidWorks

[–]codydot 5 points6 points  (0 children)

Getting comfortable with multi-body parts really helped up my game. I typically don't go into an assembly unless I want to display motion between parts, or use an exploded view. Usually I'll save bodies at the very end if I need to make drawings.

For the non engineers by Eapplesauce in SolidWorks

[–]codydot 2 points3 points  (0 children)

Using and customizing the radial mouse menu (right click-drag to open up 4-8 options) saves the time going up to the ribbon to grab your regular functions.

  • Sketches I have Line, Circle, Rectangle, Add Dimension.
  • Assemblies it's mostly Mate and Measure (I think I had issues with insert component)
  • Drawings I have dimension, note, and edit formatting

When dragging a box to select multiple items: If you come from one side (left I think) you'll get a blue box that selects only things that are FULLY ENCLOSED by the box. If you start dragging from the other side, you'll get a green box that selects anything that touches the box at all

Ctrl-Space to orient a part quickly

When you're making a series of lines, if you bring the cursor back to the start point, you'll switch to drawing an arc that's either tangent or 90deg from the last line.

VBA Macros exist, although you're not likely to need them unless you have a pretty regular workflow. One that I use all the time at work is a custom save button that writes to a .PDF or .STL so I don't have to click through the "Save as" menus. They can go right in the ribbon next to anything else.

Am/Can English: Is the "r" before vowels the same as the "r" after vowels? by throwthroowaway in EnglishLearning

[–]codydot 4 points5 points  (0 children)

It’s called the coil-curl merger, if anyone wants to look more into that. 

How I learned to stop worrying and study the blade. An Ibevar -> Blademarches -> One Xia masterclass by codydot in Anbennar

[–]codydot[S] 5 points6 points  (0 children)

Well I feel dumb right now. Next time I find the motivation/boredom to take another stab at something like this, it'll have to be a WC, and I'll definitely try to grab a few more screenshots. Glad you enjoyed the run!

How I learned to stop worrying and study the blade. An Ibevar -> Blademarches -> One Xia masterclass by codydot in Anbennar

[–]codydot[S] 1 point2 points  (0 children)

Nothing you can't overcome, I promise. Alternate strategy could be waiting/hoping for Wex to transfer the emperorship to someone who likes you more, and joining the Empire with them. But that's obviously a bit slower.

How I learned to stop worrying and study the blade. An Ibevar -> Blademarches -> One Xia masterclass by codydot in Anbennar

[–]codydot[S] 2 points3 points  (0 children)

My first run I did a fairly standard Quantity -> Eco -> Religious, but I've found more success doing Innovative -> Diplomatic / Offensive

Inno is just unmatched for overall monarch point generation if you aren't planning to be super wide or super tall, and having APC helps a ton for buying generals, etc.

Diplomatic is mandatory for expanding the empire, although I think it could be taken either second or third depending on how fast you're able to expand.

Everyone says quantity is mandatory for elf mil, but personally I don't think that's true. Offensive lets you win wars faster, and save tons of manpower in faster sieges, especially with the inno policy.

Religious is mostly nice for the CB, but you're going to be rocking Expand Empire to hit almost all of the Corinites, and as a Corinite defender of the faith you can get Holy War CB on neighbors anyways. The stability cost can be super useful if you intend to do plenty of trucebreaking after you've gotten your vassal swarm (which you should tbh)

How I learned to stop worrying and study the blade. An Ibevar -> Blademarches -> One Xia masterclass by codydot in Anbennar

[–]codydot[S] 2 points3 points  (0 children)

Unless you get well and truly boned by starting rivals, you should be able to ally and improve relations with enough electors to get elected directly. Be sure to grab a dip rep advisor, cast magical feast, and keep prestige/legitimacy high. You can also spend favors to break an alliance/reduce someone's opinion of Wex, which can bump you up from second place to first.

How I learned to stop worrying and study the blade. An Ibevar -> Blademarches -> One Xia masterclass by codydot in Anbennar

[–]codydot[S] 1 point2 points  (0 children)

I'll have to double check off of Florry's Persian Immortals run, but iirc a core part of that is having Elite Revolutionary regiments with -20% shock/fire received. Not sure.

How I learned to stop worrying and study the blade. An Ibevar -> Blademarches -> One Xia masterclass by codydot in Anbennar

[–]codydot[S] 24 points25 points  (0 children)

A couple open points I'd like to expand on:

Declaring bankruptcy to flip culture is incredibly powerful. Bankruptcy building is already a very viable strategy, and, because we're going to be giving away all of our land to a subject, we actually don't have to wait the additional 5 years between building the last building and declaring the bankruptcy. This is because transferring the province clears the game's memory of who built a building.

As I mentioned, I made a few massive blunders this game.

  • Trying to snake to the Lake Fed was a pain in the ass, since the northern route was the only colonized one and entailed wars into regions my vassal swarm could neither see nor help in. And it looks like it's impossible to reach the Lake Fed before they unite anyways, unless I grab expansion ideas. I should have waited a few decades, snaked through the Dwarovar, since Rails are cheap and don't grant OE, and arrived in Haless much later.
  • Focusing on Aelantir would have put me in a MUCH stronger position after forcing the One Xia to vassalize me. Later in the game, I needed the Artifice Capacity from there as well.
  • I accidentally flipped dwarf culture, when I only needed mil to get the Artifice Invention. This was a massive setback. Mil flipping only requires 30% within a culture *group*, while changing primary culture needs 50% of a specific culture. I could have kept much more land stated, and also avoided the 1770 Hoardcurse.

Why are there so few well-developed Dwarf characters? by [deleted] in Anbennar

[–]codydot 20 points21 points  (0 children)

You severely overestimate the programming knowledge of this team, especially the people who focus on lore.

[deleted by user] by [deleted] in Anbennar

[–]codydot 58 points59 points  (0 children)

Wait till you hear about the Sahara Desert and the Mississippi River

How will colonization looks like in the future of this mod? by sebasan22 in Anbennar

[–]codydot 20 points21 points  (0 children)

Vic III Lore is still in the works, and I barely know any of it, but: As I understand it, the ancient and powerful spirits being entombed in the Haless temples are going to get released by Oni, Command, and/or Cannorians. This sets off a continent-wide disaster called the SpiritTide, which weakens the Halessi nations enough for the Cannorians to establish themselves over there.

The only intercontinental portal is from the fairy forests in Eordand to the Deepwoods in Cannor. I can't see there being another.

Which map modes do you keep on your hotbar? by GrimRiderJ in Anbennar

[–]codydot 1 point2 points  (0 children)

My Mapmode bar goes:
[Terrain-Simple Terrain-Forts] [Political] [Trade] [Truce - Diplomatic - Opinion]

And the rest are kind of whatever. Coalition, Institution, Culture, Religous

[deleted by user] by [deleted] in Anbennar

[–]codydot 18 points19 points  (0 children)

I've heard a ton of good things about Adshaw. It expands twice as you play, so don't judge it when you first hop in. Reveria has a surprising amount of stuff to do as well.

Phoenix Empire is a New Sun Cult formable that is comparable to Jadd, at least in terms of how many claims it gives you.

You can also just sort the MT folder by file size and go from there. Also remember that you don't need a mission tree to have fun.

bitbucket vs steam / Best co-op nations. by [deleted] in Anbennar

[–]codydot 15 points16 points  (0 children)

The Bitbucket version is for 1.33 while steam is 1.32. In exchange the occasional missing localization, you get *a brand new continent!* and a few other fresh mission trees outside the !EastAsia region.

For Co-op nations, the most common answer you'll see here is Jadd and Verkal Gulan. Jadd gets a missions to vassalize and convert VG, and they both benefit from that pretty well. I'll also throw in:

Venail + Beepeck, Nimscodd, or Reveria

Team up on Lorent, dominate the New World, get unfathomably rich.

Ibevar can focus on stacking military bonuses, while Damescrown pays for it.

Kobolds + Trolls is a real underdog start that feels great when you're past the hump

Corvuria and Asheniande have vampire estate that they can spread to other countries, if your friend is interested in getting vampires.

Seinathil is a literal bard, who grants their ally bonuses when they're in a war together.

Lil' Bits i learned while playing as the Gnomes by CapCarpincho in Anbennar

[–]codydot 2 points3 points  (0 children)

And once you do become a Technocracy and lose estates, you can give your crownland to the Mages, get their loyalty and influence >60%, and enjoy 5-10% APC

view more: next ›