Craig, it's much, much simpler, at least for spreadsheet purposes, if you just include the number of grams or ml of component X and enough water to dissolve the components, and finish with "water to make 1 liter". Then for 500 ml, you use X/2 and water to make 500 ml.

And for a concentrate, if you're making it yourself, you'd decide if you want 50 ml concentrate and water to make 500 ml (what I think of as 1:9, but by Ole's nomenclature would correctly be 1+9), or if you'd find it easier to use 45.5 ml concentrate and water to make 500 ml (1+10). For my money, if working in metric, 1+9 is about the simplest dilution you can possibly use.
Of course, different systems give advantages different places. Back around 1967, Kodak picked 1+31 (or 1:31, as they call it) for HC-110 Dilution B because it was one ounce concentrate per quart of working solution (and then they complicated the whole situation by recommending you mix the whole bottle of concentrate into stock solution, 1+3, and then use the stock solution at 1+7 -- it's tricky to get into the right mental viewing angle for that combination to add up the same as 1+31).
Now, just to bollix the works a bit, if you're mixing your own chemisty, the simple way is to make up packets of dry chemicals containing the premeasured amount of each ingredient to make 500 ml of working solution, and if you need a liter, use two packets. The only time there's a significant disadvantage to doing this is if a) you have a formula that is difficult to dissolve (has a lot of borax or sodium sulfite, for instance), or b) you have an ingredient that doesn't keep well in dry form, such as glycin. If you routinely use several different size batches, however, and have a concentrate that keeps well (say, dissolved in TEA or glycol, so the alkali isn't ionized and thus the phenidone doesn't deteriorate), then a concentrate will be easier than using the correct number of small-batch packets or keeping several packet sizes on hand; this is also the case if your formula is difficult to fully dissolve at room temperature.