Inverse Transform Sampling in Excel and Dataset Considered for Comparative Assessment of Inequity Indicators

The two files attached here are supporting materials for the study titled "Development and Application of a New Bounded Inequity Indicator for Water Distribution Systems." The word file provides the functions used to sample values from transformed beta and truncated normal distributions in Excel. The second file, which is an Excel file, contains 100 sheets, each containing the input data for a city with 100 water supply zones. Along with the input data for each city, each sheet also contains the calculations done to determine the inequity values produced by different indicators for a city.