Answered

Percentage calculator, how much money you could save?

1 year ago
June 29, 2023
14 replies
502 views

papurilla
Explorer
9 replies

Hi everyone,

I reeeeally need your help, please, to set up a calculator that shows prospects how much they would save (in percentile) using our fulfilment service.

This is what I have set up already, clearly, I’m missing some fundamental rules and variables to be put in place because the math ain’t mathing.

Here are all the details if someone is feeling challengy today.

Thank you and have a great day!

_________________________________________________________________________________

Logistics Inhouse v. 3PL

First “variable” to take into consideration is the amount of orders (“pedidos”) they receive a day. Ideally, it could be any number (ranging from 1 to 5,000) and have that answer multiplied by 252 (which refers to the working days through the year: 12*21).

I wasn’t able to do so, so, I programmed 50 possibilities.

Ok, before heading to question number 3, I was hoping the calculation between ‘the number of orders a day’ multiplied by ‘252’ should be established as the “score” of question 2.

Question number three intends to multiply the size/volume of their orders with the total “score” from question 2.

So, for example: I have 30 orders a day which means question number 2 should multiply 30*252 and have that result (7,560) multiplied by the selected option of weights offered in question number 3.

These weight options have a specific shipping price assigned to them. So I created weight variables for this question. In my head the logic process would be: have the selected weight option (with a variable already assigned to it) be multiplied by the total score from Q2.

So, up to this point we should have: ‘number or orders variable’*252= resultQ2*weight list option variable=newresultQ3

Question 4 -is where I kinda get lost because there are so many conditions to be put in place for each answer and I can’t seem to connect the dots.
Preferably, we would now want the total score of Q3 be taken into account for this question. The warehousing options we offer have a specific value (hence: the almacenaje variable). The logic being: newresultQ3+50(this an extra fee for software)+the selected warehouse location variable.

Leaving us with a computed newresultQ4.

For Q5 we follow the same pattern. Use the newresultQ4 and have that score be the base for this new calculation. Which is personnel.

Logic being: newresultQ4+(extras variable(95,5)+4,000(employees expenses))*12

I’m aware the logic setup is incorrect. It could be 4,095 as a variable altogether multiplied by 12 instead.

The desired goal to obtain the percentages result is: newresultQ3 - (minus) newresultQ5/newresultQ3

Any suggestions on how that may be achievable/obtainable are very much appreciated.

Thank you in advance!

Best answer by john.desborough

@papurilla - sometimes i get busy with paid client work.. apologies..

my thoughts go like this related to logic rules

q1:

if q1 greater than 0 then add q1 to v_sub_1
if q1 greater than 0 then multiply v_sub_1 by 252
des: now you have the annual volume

q2:

if q2 = A then multiply v_sub_1 by 250
if q2 = B then multiply v_sub_2 by 300
etc.
des: one logic rule per weight category .. if you want the user to enter the weight then just use the answer to the question instead of fixed values.

q3 - select the warehouse location

if q3 = A then add 100 to v_sub_1
if q3 = B then add 200 to v_sub_1
etc
If q3 = A or q3 = B or q3 = C…. or q3 = ?? then add 50 to v_sub_1
des: select the warehouse from the options list and assign the specific value for that warehouse. i added the ‘software cost’ logic rule as well - edit it as necessary

q4: create the personnel variable - assuming that you have a value in ‘extras’ already as i don’t see it in your screens

if q4 greater than 0 multiply @extras by q4
to create the percent:
- if v_sub_1 greater than 0 then add v_sub_1 to v_final
- if extras greater than 0 then subtract extras from v_final
- if v_sub_1 greater than 0 then divide v_final by v_sub_1

that should give you the result that you need - even if my question numbers don’t match yours, the logic flow should be ok

recommendations:

write it all out on paper
break it down into simple algebraic formulas on paper
walk backwards from the last calculation towards the first in order to create your logic rules.

these are the same type of solutions that i build for my clients. happy to share the basic logic when i have the time to do so..

des

View original

Liz
Tech Community Advocate
14904 replies
1 year ago
June 29, 2023

@john.desborough is definitely your person for calculation/logic questions!

Life is a series of awkward moments separated by snacks.

papurilla
Author
Explorer
9 replies
1 year ago
June 30, 2023

Hola Liz,

He’s offered helped before but haven’t heard from him since almost a month ago, that’s why I’m reaching out to the community again.

john.desborough
Certified Partner & Champion
5271 replies
Answer
1 year ago
June 30, 2023

@papurilla - sometimes i get busy with paid client work.. apologies..

my thoughts go like this related to logic rules

q1:

if q1 greater than 0 then add q1 to v_sub_1
if q1 greater than 0 then multiply v_sub_1 by 252
des: now you have the annual volume

q2:

if q2 = A then multiply v_sub_1 by 250
if q2 = B then multiply v_sub_2 by 300
etc.
des: one logic rule per weight category .. if you want the user to enter the weight then just use the answer to the question instead of fixed values.

q3 - select the warehouse location

if q3 = A then add 100 to v_sub_1
if q3 = B then add 200 to v_sub_1
etc
If q3 = A or q3 = B or q3 = C…. or q3 = ?? then add 50 to v_sub_1
des: select the warehouse from the options list and assign the specific value for that warehouse. i added the ‘software cost’ logic rule as well - edit it as necessary

q4: create the personnel variable - assuming that you have a value in ‘extras’ already as i don’t see it in your screens

if q4 greater than 0 multiply @extras by q4
to create the percent:
- if v_sub_1 greater than 0 then add v_sub_1 to v_final
- if extras greater than 0 then subtract extras from v_final
- if v_sub_1 greater than 0 then divide v_final by v_sub_1

that should give you the result that you need - even if my question numbers don’t match yours, the logic flow should be ok

recommendations:

write it all out on paper
break it down into simple algebraic formulas on paper
walk backwards from the last calculation towards the first in order to create your logic rules.

these are the same type of solutions that i build for my clients. happy to share the basic logic when i have the time to do so..

des

If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...

papurilla
Author
Explorer
9 replies
1 year ago
July 3, 2023

Hi @john.desborough thank you for getting back to me with such busy agenda. No apology needed.

Uff this is great, truly. Thank you. I think I’ve made substantial progress, but I don’t see any percentage calculation showing as a result😭. What am I missing? Do I need to use a specific question format for the results to show or is it simply because the logic is still faulty?

john.desborough
Certified Partner & Champion
5271 replies
1 year ago
July 3, 2023

papurilla wrote:

Hi @john.desborough thank you for getting back to me with such busy agenda. No apology needed.

@papurilla - what do you get when you get down to this point??

to create the percent:
- if v_sub_1 greater than 0 then add v_sub_1 to v_final
- if extras greater than 0 then subtract extras from v_final
- if v_sub_1 greater than 0 then divide v_final by v_sub_1

the v_final should be the ‘result’ … if you are seeing something like “0.98” then you would simply have to multiply that result by 100 to get and show your percentage using the @recall statement and hard coding in the % sign.

to try and troubleshoot where you are and what you ‘have’ in terms of calculations at any given stage of the typeform, i will create a copy of the form and then put in statement pages after each set of calculations - on the statement page i will then output the answers and show the current state of values, etc… since there is no ‘debug’ function or process in Typeform, this allows me to mimic that process one step at a time..

just a thought

des

If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...

papurilla
Author
Explorer
9 replies
1 year ago
July 3, 2023

Hi @john.desborough - surprisingly nothing. No results are showing. I’ve made some changes (following your logic) that might have contributed the outcome. I want everything to branch from the v_sub_1 variable as the quiz moves forward. So up until q2 I used the path you suggested.

Now, for q3 (size of products) I did the following:

if q3 is 250gr then multiply v_sub_1 -annual volume of orders calculated in q2- by 3,03 (which is the shipping price for that specific weight)
if q3 is 500gr then multiply v_sub_1 by 3,27
if q3 is 1kg then multiply v_sub_1 by 3,59
and so on till 30kg (all which have a specific pricing value)
I didn’t create a new variable for each weight because it wouldn’t make sense having those variables be independent from the initial calculation (annual volume of orders).

For q4 (which is warehousing):

if q4 is A then add 55.5 (utilities and warehouse location fee) to v_sub_1
if q4 is B then add 54.5 (utilities and warehouse location fee) to v_sub_1
if q4 is C then add 53 (utilities and warehouse location fee) to v_sub_1

For q5 (which is personnel) I created personnel variable and followed the same principal as q2:

if q5 is greater than 0 then add q5 to “personnel”
if q5 is greater than 0 then multiply “extras” by “personnel”
“extras” has a customed value of 2,000
“personnel” variable should now be the result of “personnel” times “2000”

Lastly I wrote these conditions on a Statement slide but I’m not sure if that’s were the mistake lies. Should I add these to q5 instead? Or how can I make the percentage show on the last question.

if v_sub_1 greater than 0 then add v_sub_1 to v_final
if extras greater than 0 then subtract extras from v_final
if v_sub_1 greater than 0 then divide v_final by v_sub_1

Anything that you think could help sort this out will be greatly appreciated.

Thank you for your time!

Liz
Tech Community Advocate
14904 replies
1 year ago
July 7, 2023

Hi @papurilla Hope you’re doing well! How did the setup above go for you?

Life is a series of awkward moments separated by snacks.

papurilla
Author
Explorer
9 replies
1 year ago
July 7, 2023

Hola @Liz thanks for getting in touch.

Not quite there. I implemented some of the changes @john.desborough suggested but it’s not working as of yet. I hope he sees the above message and is able to help me -once again.

Hope you have a great weekend,

Liz
Tech Community Advocate
14904 replies
1 year ago
July 7, 2023

Hi @papurilla Oh gosh sorry! I totally missed your message there. Let us know if you run into any other struggles!

Life is a series of awkward moments separated by snacks.

papurilla
Author
Explorer
9 replies
1 year ago
July 20, 2023

Hola @john.desborough hope you’re doing ok. This is the last stretch so I can stop bothering you.

Could you revise my latest update and share the troubleshoot copy you initially suggested?

Thank you, have a good day.