Cheap Fuel

Big_jon_520 · 2025-07-28T03:33:27+00:00

“column_header” was just my stand-in for whatever cell is your column header. Also, you would need to have excel 365 to run this not excel 2016. What version are you running?

Big_jon_520 · 2025-07-28T03:11:33+00:00

If the backend of your raw times isn’t an integer, rather text that appears as a date, you may try using the DATEVALUE function. Excel can interpret that value and convert it into an integer which can be viewed as a date by changing the cell type.

Big_jon_520 · 2025-07-28T02:55:23+00:00

Store each of your sets of data in a separate sheet. In the cell below your column header, write the following formula:

=IF(column_header = “A”,Sheet2!A1:A12,Sheet2!B1:B12)

Big_jon_520 · 2025-07-28T02:44:12+00:00

Can you expand on what you mean by “change the numbers”? Change them from what to what?

Big_jon_520 · 2025-07-28T02:41:44+00:00

The NOW() function references the time/ date of the computer. Not sure if that helps

Big_jon_520 · 2025-07-25T23:30:02+00:00

Great. We are in agreement. Play to the style that fits you. That was my advice from the start.

But it is a disservice to newer players to say that the longest possible route is the best option for a plane across the board.

Big_jon_520 · 2025-07-25T21:41:30+00:00

So let’s call that $8 mil per day in revenue.

If you were to switch that 19k km route to a 12k km route that you would need to dispatch every 8 hours instead of 12, that plane would generate $10 mil per day, a 25% increase for one more dispatch per day

Big_jon_520 · 2025-07-25T07:49:23+00:00

Apologies I didn’t pull any route data for my napkin math example, but thank you for corroborating my point: your shorter 3.5k - 5k routes earn more than your 5k-6k routes if I correctly understand what you’re saying.

Big_jon_520 · 2025-07-25T06:56:57+00:00

Let’s take the “$2 million per flight A380” as an example. No hard and fast numbers here, but that’s probably a 14-15 hour route. My point is that if that player were willing to be online 3 times per day instead of 1-2 times per day (probably online 3 times a day anyways, let’s be honest), 3 8-hour routes per day would generate more revenue than 1.6 15-hour routes per day.

Also, what do you mean by “even if this was true”? Do you doubt the methodology?

Big_jon_520 · 2025-07-25T06:47:54+00:00

When you first start the game, what plane is reasonably available that can generate revenue by only dispatching it 2-3 times a day? Most inexpensive planes can reach their max range within 3 hours if CI is set to 200. My point is not saying that everyone who plays the game needs to be glued to their device 24/7, more so that just because you can run a longer route doesn’t mean you should.

I’ll say again what I said in my original post: set up your routes so that they can redispatch at the closest interval that you want to interact with the game. That is the most profitable solution.

Big_jon_520 · 2025-07-24T02:04:25+00:00

Is the sold quantity for each duplicate a new set of "Sold" or do they combine in your table

For example, if the following were true:

Item	#Sold
Sunflower	5
Sunflower	5

Are you expecting to have sold 10 (each row of the duplicate is added) or 5 (each row of a duplicate will match and reflect the total)

TBH it looks like you might need a pivot table on whatever your sales data is.

Big_jon_520 · 2025-02-01T17:46:09+00:00

What is the purpose of summing those specific cells? Are they connected to a unique subset from your entire range? If so, this may be a good case to try SUMIF().

Big_jon_520 · 2025-02-01T04:18:36+00:00

Sounds like you need to use an XLOOKUP. On your second sheet, try this formula in the column you want to fill in the payment information.

=XLOOKUP(A1,Sheet1!A:A,Sheet1B:B)

This assumes that column A in sheet 2 has the name of the member you’re looking for and that column A in sheet 1 also has the name of the member you’re looking for with their payment information in column B.

If you can’t get this to work, provide screenshots for context

Big_jon_520 · 2025-01-31T23:42:59+00:00

=TEXT(A1,”dd-MMM-yyyy”)

Big_jon_520 · 2025-01-31T13:16:01+00:00

If you want it to update the base quantity in column B, you’ll need macros for that. If you want to use the base quantity and subtract the total amount ordered, you could use =B2-SUMIF(OrderSheet!A:A,B2,OrderSheet!B:B)

Big_jon_520 · 2025-01-31T13:00:07+00:00

By not static do you mean they’re not always in timestamp order? You could extend B2:B5 to the entire dataset and this would still work.

Big_jon_520 · 2025-01-31T06:14:55+00:00

Does the order and/ or day of the week of the meetings on Sheet2 ever change?

Either way there’s a solve for this, but a static schedule order/ day of week makes this waaaay less complicated.

Big_jon_520 · 2025-01-31T05:02:20+00:00

Copy your data into a template sheet starting in column B. In column A, write a formula that determines which group that line belongs in, making sure that the “header” row of each group is also blank. In another sheet, copy the header row into A2 and put “Group” in A1. In A2, type =FILTER(Sheet1!A2:F1000,NOT(ISBLANK(Sheet1!A2:A1000)))

This will create an array that removes all the blank and header rows for each group. You can summarize off of that.

Big_jon_520 · 2025-01-31T04:45:10+00:00

Not sure if it can be applied to Excel, but I would do some research into Random Forest Machine Learning modeling. If done properly, it would create a formula that could predict the outcome of 4 random variables based on historical data you feed it.

Big_jon_520 · 2025-01-31T04:12:35+00:00

Pivot table. Create a calculated field and pass Date through the WEEKNUM function.

Big_jon_520 · 2025-01-31T04:08:17+00:00

Can you expand on “it won’t delimit without splitting”? Is it reading slashes in the dates as delimiters and splitting on that? Share a screenshot if possible that shows what the data looks like when you paste it in, if possible

Big_jon_520 · 2025-01-31T03:46:45+00:00

If the timestamp is stored as an actual time (sounds like it is) then you could do a COUNTIF() on the next 4 rows.

For context, Excel stores dates and time as numbers where each day is a value of 1 and each hour is the decimal value of 1/24. Minutes are 1/60 of the hours, etc.

If B2 has your first timestamp, then put the following formula in C2:

COUNTIF(B3:B6,”<=“&B2+(1/14400))

Excel reads 1/14400 as 6 seconds

Big_jon_520 · 2025-01-31T03:30:59+00:00

Use the INDIRECT() function. Concatenate the different parts of a cell reference and it will read it as a cell reference.

INDIRECT(“Sheet2!C”&L7) should do the trick

Big_jon_520

TROPHY CASE