We will now take our initial model and add a horizontal component. The key to this is recognising that the there is no acceleration in the horizontal plane and if we ignore air resistance, then the velocity will remain constant (Newton's 1st Law). Thus we are just using v = d/t, re arranged d = v*t. In excel we put =$E$6*B11
You now have a working spread sheet that will enable you to predict the landing position of an object knowing its initial horizontal velocity.
Your task now is to use this to place a plastic cup in the correct position so that a horizontally launched marble falls into the cup on your first try!
You will have determine the initial velocity using energy considerations and a ramp.
Remember assuming total energy is conserved and minimal friction, Potential energy at the top of the ramp will equal the kinetic energy at the bottom. This can be used to determine the initial velocity.
Can you change your spreadsheet to include an angled launch?