this is an operation research problem. we want to maximize this function

max Z = [(final temperature- initial temperature)*0.7/initial temperature]* current energy consumption* occupation factor

it is a stochastic optimization problem. solve it using genetic algorithm (meta heuristic) solve it by Excel if possible

you can generate random numbers that follow uniform distribution as the following:

(final temperature- initial temperature) = Randbetween(0,3), randbetween is a function that generate random numbers in excel

final temperature = randbetween (23,26)

initial temperature = randbetween (23,26)

current energy consumption = randbetween(123336,200000)

occupation factor = electricity consumption per one person * number of occupants

electricity consumption per one person = randbetween(0.2-1)

number of occupants = randbetween (30, 200)

find the optimal solution by this metaheurisitc

please make the solution detailed

thanks