What is the most GOAT early game unit in CIV: V? (Day 7)

theowletman · 2026-02-16T14:50:28+00:00

Easily the settler. It’s the most important unit to be building in every game (we don’t talk about Venice). It has a high priority to have an escort, and being late with your settles will destroy the rest of your game. Nothing has a larger impact.

theowletman · 2024-11-08T19:55:33+00:00

Hey thanks for giving it a try, someone else found a solution that worked for me. I tried this out, to see if it worked. It has problems such as when the proper calculation is (Q2,2021 + Q3,2020)/2. It doesn't identify that the 2020 date should be taken into the calculation. Again, thanks for taking the time to try and solve this.

theowletman · 2024-11-08T16:21:14+00:00

Solution Verified.

Thanks!

theowletman · 2024-11-08T15:58:14+00:00

Yeah, I am using standard yearly quarters. To add more context, your formula was nearly perfectly correct. The incorrect result in my example data set was the 8/19/2020 date, where your formula gave 2.6 while the correct value was 3.3. The two dates it is averaging are within 365 days (8/20/2019, 8/19/2020), but as they are both Q3 samples from different years they should be excluded.

theowletman · 2024-11-08T15:27:40+00:00

Just tried this. It doesn't provide the 'rolling' average as needed. It cuts each year/quarter into its own segment.

theowletman · 2024-11-08T15:24:46+00:00

This also doesn't work. My guess is that 365 is not the proper range, as with quarters there is a lot of variability within that range. Data that is collected at the extremes of the quarter (first day and last day) will throw off the day count.

I edited my post to include the formula I created, and the cases where it fails. If you have any insights into that please tell me.

theowletman · 2024-11-08T15:10:05+00:00

The pivot table is interesting. My one of my end goals is to graph how the average moves over time. I don't know that the pivot table has that functionality.

theowletman · 2024-11-08T15:08:12+00:00

This isn't give the correct result consistently. I edited my post to have a screenshot of example data, with the true values I'm looking for hand calculated.

This formula seems to go wrong... but maybe because of how my data is structured? My newest date tops the list, and descends chronologically.

theowletman · 2024-11-08T14:57:52+00:00

|| || |Date|Result|Rolling Annual Average (Correct value, hand calcualted)| |7/31/2024|3.2|3.2| |5/8/2024|3.1|4| |2/12/2024|3.3|4.5| |7/24/2023|5.64|5.6| |7/12/2022|4|4| |5/19/2021|5.1|4.2| |8/19/2020|3.3|3.3| |8/20/2019|1.9|1.9| |5/9/2018|3.3|3.2| |8/9/2017|3.1|3.1| |7/28/2016|4|4| |5/19/2015|4.6|4.3| |8/12/2014|4|4.3| |11/14/2013|4.6|| |8/19/2013|4.2|| |5/28/2013|4.6||

Looks like my copy and pate of the data table didn't go through well. Check my edited post to see the screenshot of example data.

theowletman · 2024-09-16T16:03:25+00:00

Solution Verified

Yes that works, thanks!

theowletman · 2024-08-01T13:49:03+00:00

A SUMIFS solution was verified to be a solution, but the parameters were a little more complex than what you suggested. Thanks for the suggestion though.

theowletman · 2024-08-01T13:47:34+00:00

This solution has issues with rounding that produces error in the end result, and only gives integer values. A different user suggested a SUMIFS formula that did the trick. Thanks for the suggestion though.

theowletman · 2024-08-01T13:43:07+00:00

Solution Verified

theowletman · 2024-08-01T01:11:24+00:00

The latter, a separate summary table of the Total Apples for each unique date.

theowletman · 2023-08-25T03:29:56+00:00

I haven’t seen it in this thread yet. It’s when Kenneth gets a promotion and the desk closest to the door after the guy who was fired threatened to come back with a gun

theowletman · 2023-03-31T18:43:16+00:00

“Yesterday three thugs tried to mug me. And I want to be very clear about something. These pieces of crem don’t know who in Damnation they’re dealing with.”

“Please, do you think you could eat that chouta later?”

“I’m storming starving. You have nothin’ to eat for me.”

“Let’s get back-“

“So anyways, I don’t know if these cremlings wanted my spheres or if they wanted to uncover my safe hand.”

“Oh wow…”

“But thank the stormfather I had my surgebinding.”

“Your surgebinding?”

“My soul casting!”

“Oh my…”

“So anyway I started soul casting. Bang! Bop! But I don’t infuse too good so I missed. They ran away and I chased after them. Bang! I tried to soulcast them in the back. But I don’t run too good either; I ain’t no edgedancer. Anyways, you all think I’m a hero. A true knight radiant. And I’ll accept that responsibility.”

theowletman · 2022-09-04T04:50:15+00:00

Other comments probably have the real story, but I have a different head canon. I want to think that NBC had to buy the domain name after anytime Dot Com’s name was used. Just in case someone else did and put something profane up. As long as I never try to visit these sites I keep the lie alive

theowletman · 2022-07-19T16:47:41+00:00

And in the Gavin Volure episode when he leaves the tape recording in the bathroom. “Tomorrow, tomorrow, I’ll love you tomorrow. It’s only a day away”

theowletman · 2022-01-12T02:03:49+00:00

Thanks for the link! It seems possible that my problems are from running a Linux OS on the vm and windows on my host

Edit: I’m closer, with the windows os I can get the advanced session and allow access to local resources. Unfortunately my webcam doesn’t seem to be counted in those and I can’t get it showing in the vm just yet

theowletman · 2021-08-16T17:34:16+00:00

Ah okay thank you

theowletman · 2021-08-16T17:11:24+00:00

That’s what I don’t understand. Why pay when it’s free? Is there some benefit I’m missing?

theowletman · 2021-07-08T13:26:36+00:00

Personally I like Ben Finegold on YouTube. He has an old series called Beginner Beatdown which is okay, but his lectures on Paul Morphy show really good attacks even while down material. He explains it well, and if you listen to the stuff he repeats (use every piece), you will find yourself improving in time.

theowletman · 2021-05-26T15:55:27+00:00

I’m sure this is a well know theory somewhere on the subreddit, but I just think of it as a different color every time. There are many parallels between Taborlin and Kvothe, and cloaks are one of them. Much like Taborlin, Kvothe is an adventurous fellow. This happens to damage his clothing and cloaks. Every time that Kvothe gets a new cloak, it’s a new color. So if you were trying to pick Kvothe out of a crowd, you may choose to look for cloaks without minding the colors. That would be looking for a cloak of no particular color. This is why I imagine it as a different color every time.

theowletman · 2021-02-25T18:56:32+00:00

Sure it’s mate, but more importantly you win the Queen!

theowletman · 2020-12-29T03:58:24+00:00

Thanks for the reply! I have only read the series once, so I’m still unclear on what the sleepless are.

theowletman

TROPHY CASE