Okay, some findings.
All equation have the same result, when I answer
I have a driver license, a car and a bike.
In the last row there are 32 columns - mostly not displayed.
But in my opinion they are taken into account when you insert the radios.
This is what I get when I hard code the columns 1, 5,10,15.
And this with 29,30,31,32
Please check.
If so, you have to revise the equations.
Some more general remarks:
Please, read the manual about the implemented functions, especially "countif, countifop, sumifop"
You can shorten a lot of your equations.
And revise your equations. Only two eamples.
What for is this?
tariffcar1:
{if(order=="1",'1',if(order=="2",'1',if(order=="3",'1',if(order=="4",'1',if(order=="5",'1',if(order=="6",'1',if(order=="7",'1',if(order=="8",'1',if(order=="9",'1',if(order=="10",'1',if(order=="11",'1',if(order=="12",'1',if(order=="13",'1',if(order=="14",'1',if(order=="15",'1','1')))))))))))))))}
order has values 1-16 --> so the result is always "1"
tariffhail6:
{if(order=="1",'3',if(order=="2",'3',if(order=="3",'3',if(order=="4",'3',if(order=="5",'4',if(order=="6",'4',if(order=="7",'4',if(order=="8",'4',if(order=="9",'1',if(order=="10",'1',if(order=="11",'1',if(order=="12",'1',if(order=="13",'2',if(order=="14",'2',if(order=="15",'2','2')))))))))))))))}
Shorter:
{if(order<5,3,if(order<9,4,if(order<13,1,2)))}
And please: If you want to use numbers, write it as numbers - without quotes. Quotes mean "This is a text".
So you could
not write this last equation with quotes
{if(order<"5","3",if(order<"9",4,if(order<"13","1","2")))}
Because "14" is less than "5", it is compared alphabetically.
You should not use "{rand(1,2)}", but "{if(is_empty(random1),rand(1,2),random1)}
And what for do you assign this random number "random1" to another variable "rand1"?
There is really a lot to improve and to shorten.
Joffm