Auction Macro Help!

Hi, Really hoping that someone can help me, as I've trying to working this out for days and can't get it to work. My pathfinder party are heading to an auction and I have found a system for running auction which I have tested with dice and it works.  I know want to make it a macro to speed things up. I need the macro to generate the number of NPC's interested in an item (2d6) then roll, for each NPC d100+d20 and then report the number of those rolls that are over 70. The second round of the auction is then the same but with a fixed number of NPC's (the ones left from round 1) but the success rage is over 75. I can get the success over 70 thing to work, but can't get that to work with the combined dice rolls.  I need a macro for each round but I can modify that on the fly. Please help me, my head is about to explode. Thank you

I guess I would sort of "brute force" this sort of thing by just rolling all the dice and visually/manually filtering out rolls I don't need.  However, instead of needing to look at the exact rolls, you can use "floor" while dividing by your break point.  Any 0 result didn't stay in the bidding, and any with 1 did.  The initial round of bidding might look like this: /w gm &{template:default} {{name=Auction Round 1 (70+ Stays)}} {{Participants=[[2d6]]}} {{Bidder 1=[[floor([[1d100+1d20]]/70)]]}} {{Bidder 2=[[floor([[1d100+1d20]]/70)]]}} {{Bidder 3=[[floor([[1d100+1d20]]/70)]]}} {{Bidder 4=[[floor([[1d100+1d20]]/70)]]}} {{Bidder 5=[[floor([[1d100+1d20]]/70)]]}} {{Bidder 6=[[floor([[1d100+1d20]]/70)]]}} {{Bidder 7=[[floor([[1d100+1d20]]/70)]]}} {{Bidder 8=[[floor([[1d100+1d20]]/70)]]}} {{Bidder 9=[[floor([[1d100+1d20]]/70)]]}} {{Bidder 10=[[floor([[1d100+1d20]]/70)]]}} {{Bidder 11=[[floor([[1d100+1d20]]/70)]]}} {{Bidder 12=[[floor([[1d100+1d20]]/70)]]}} Since you don't need the number of participants after that, you could drop the 1st line of the previous macro and just roll for all potential bidders.  You only need to pay attention to however many bidders remained from the first round.  You could set this up with a query for your break point, in case you want to make that 75 a variable. /w gm &{template:default} {{name=Auction Round 2 (75+ Stays)}} {{Bidder 1=[[floor([[1d100+1d20]]/75)]]}} {{Bidder 2=[[floor([[1d100+1d20]]/75)]]}} {{Bidder 3=[[floor([[1d100+1d20]]/75)]]}} {{Bidder 4=[[floor([[1d100+1d20]]/75)]]}} {{Bidder 5=[[floor([[1d100+1d20]]/75)]]}} {{Bidder 6=[[floor([[1d100+1d20]]/75)]]}} {{Bidder 7=[[floor([[1d100+1d20]]/75)]]}} {{Bidder 8=[[floor([[1d100+1d20]]/75)]]}} {{Bidder 9=[[floor([[1d100+1d20]]/75)]]}} {{Bidder 10=[[floor([[1d100+1d20]]/75)]]}} {{Bidder 11=[[floor([[1d100+1d20]]/75)]]}} {{Bidder 12=[[floor([[1d100+1d20]]/75)]]}} Maybe that will give you some inspiration at least.

Fantastic.  Thank you so much.