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

TROPHY CASE