Calculating drone bore lengths

[Philipp]

Hi folks,
I have a set of German bagpipes in G that have a tenor and a bass drone in G. Now would like to add an additional drone in D to have a fifth when playing in G major. Or maybe a C bass drone... Anyway, my question is if there is a way to calculate the lengths and diameters of drone sections required to obtain a certain pitch. Any ideas?

Cheers,
Philipp