# Set formula of ALLOC_1
merged_df['ALLOC_1'] = MIN((merged_df['Eligible Tokens Held'] * 3000), 12000) + (merged_df['SPAD_Bonus'] * 9000)
# Set formula of ALLOC_2
merged_df['ALLOC_2'] = IF(AND(merged['BOOK OF STAMPS']>0, merged['BOOK OF STAMPS']<=10), 5000, IF(AND(merged['BOOK OF STAMPS']>10, merged['BOOK OF STAMPS']<=20), 10000, IF(AND(merged['BOOK OF STAMPS']>20, merged['BOOK OF STAMPS']<=30), 20000, IF(merged['BOOK OF STAMPS']>30, 30000, "0"))))
# Set formula of ALLOC_3
merged_df['ALLOC_3'] = MIN(merged_df['stamp_count_unique']*5000, 20000)
# Set formula of TOTAL ALLOC
merged_df['TOTAL ALLOC'] = SUM(merged_df['ALLOC_1'], merged_df['ALLOC_2'], merged_df['ALLOC_3'])