Ugh, ramps
(and stairs). Difficult to illustrate. I'll let someone else more experienced handle that, I'll pass. Alternatively, go look up the
wiki. Do you have a picture of the unusable ramp in question?
As for efficient designating of pumpstack, that depends on the layout of your pumpstack.
Here's how I do mine for a straight down pumpstack. Let's see if I can make a gif for easy illustration.
This is the layout for a straight down design. The sideways T shape is where the pump is located. The bottom of the sideways T is the input tile that draws from the magma on the z-level below it. The top of the sideways T is the output tile. The X's are up/down stairs. I'm going down the z-levels so you can see how they are placed.This is how to designate it. You can cut down the number of keystrokes if you don't want to utilize the 3 tile output that allow heat conduction and saves some FPS lag from heat calculations. In that case, you can just make the access tunnel one tile and ignore designating the 3 tile output all together. Do note that I did not designate the channeling on the input tile. Usually I do it after digging out the pumpstack, but there you can go about it in whichever order you want. Also not shown here is the channeling of 1 tile where the pump stack is placed to allow for the power to travel across the different z-levels. I use this design to easily connect a power generator to the pump so it can pump automatically without manual dorfpower.Here's how it looks like in operation. Apologies for the wonkiness at the end there. As for glass, it goes straight from sand
(sand bag) to green glass tube. Raw glass is itself a finished product that's used for decorating purposes. You'll want to make glass parts using sand instead of raw glass.
(in your case, glass blocks, glass tubes and glass enormous corkscrews are all magma safe components for making pumpstacks)Green glass is made from just sand.
Clear glass is made from sand and pearlash.
Crystal glass is made from rock crystal and pearlash.
You can process a bar of pearlash from a kiln, but you'll need a bar of potash
(potash is made from either ash or lye at an ashery)Functionally, all the different glass types are the same. However, some dwarves may have a preference for certain types of glass to use in moods and such. So having those on hand (in their raw form) might save a mood from failing. Dwarves that prefer a certain type of glass might also enjoy good thoughts from having furniture made from that kind of glass.
Not sure why you are getting cancellations for bituminous coal. A magma glass furnace is already powered by magma, so you don't need any fuel
(coal, charcoal) at all. A glass furnace on the other hand, requires fuel to power it.