IF any one wants to make 1UPT work (which I regard as spending all your effort to build the perfect Buggy Whip) this is one place to do it.
To reiterate: Ranged troops pre-gunpowder, had virtually no Melee factor. That's because being a really good archer was a nearly Full Time Job - you didn't have time to also become a decent swordsman, and hauling a spear and shield around simply loaded you down when you needed to carry more arrows. Consequently, armies that relied on Massed Ranged Troops also had to protect those troops, or the enemy would simply charge, and no matter how slow they lumbered up, even men on foot would reach the Ranged Troops in a few seconds, perhaps with arrows sticking out of their shields, and proceed to massacre the ranged troops. Give the ranged troops armor and melee weapons, and unless they were full time 24/7 warriors like the early Samurai, they would be inept swordsmen/spearmen in armor and just get massacred a little more slowly. The end result was the same.
The armies that did successfully use Massed Ranged Troops either protected them - as the early Indian and Burmese armies that put their archers behind or on top of Elephants - or increased their effectiveness by using drill (as invent ed in China) so that multiple ranks of archers/crossbowmen could keep up a continuous, massed fire (the same drill of fire-by-ranks that was independently invented in Europe for the earliest muskets close to 1000 years later) - or put the archers on horses so they could ride away when the enemy got too close.
The consequence was that Massed Ranged Fire was never important in European Ancient/Classical/pre-gunpowder warfare: whether your opponent was Greeks, Romans, Germans, Gauls - they all charged, and so the ranged troops got in a few shots and then ran for it or died. - And before you ask, the English Longbow was a system, not a weapon: men who practiced constantly so they could fire fast and accurately, organized into groups under their Shire Reeves (sheriffs) who were their officers in the field so they could present massed fire On Order, and protected behind an array of stakes in the ground, or dismounted knights (as at Agincourt) or mounted knights (at Poitiers) or other really good melee troops to keep the enemy from simply trotting up and mopping up the archers. And, by the way, where they didn't have time to set out the stakes or didn't have knights and other melee troops with them, the longbowmen got ridden down like dry grass, just like every other type of pre-gunpowder ranged weapons-carriers.
The earliest gunpowder weapons, the 'hackbusses' were designed to be fired while rested on walls - they were defensive weapons to be used from fortifications, so the enemy could not charge and drive the gunners off. When they evntured onto the battlefield as arquebussiers, they, like their archery predecessors, also had virtually no Melee Factor - no bayonets, a clumsy 15 pound musket for a club, and usually no armor and no decent sidearm or training in how to use one. They had to be combined with melee troops in Pike and Shot units (or, earlier, Shot and Halberd and pike and sword units like the earliest Tercios and Colunelas) to give them a chance of surviving.
All of which makes the flintlock musket with socket bayonet such a Game Changing weapons system. Without a lighted match hanging about him, the musket-wielders could be shoulder to shoulder and close enough behind that barrels went over shoulders and 2 or 3 ranks could fire at once, and reload fast enough to fire 1 - 3 more times within a minute. If the enemy did make it through the fire to close, a 60 inch long musket with a 17 inch bayonet on the end made a very effective melee weapon against either infantry or cavalry, so the Fusilier with his musket and bayonet could, for the first time in history, have effective Fire/ranged effect and melee effect.