Upload Spectrum file(s)
This app accepts .PJNZ files from Spectrum, but in the case where your .PJNZ file is very large, uploads may be very slow. In this case you can instead upload pairs of .DP and .PJN files extracted from the .PJNZ.
Uploaded Spectrum files
data
Upload survey data
Please provide survey data on the proportion of people ever tested by sex and age group, and HIV serostatus (if available). Where available please provide the following:
- Country or region: Must exactly match country or region in top left panel.
- Survey Id: Provide a unique identifier for your survey (each survey must have a unique name).
- Year: Year in which survey was conducted; year of survey fieldwork midpoint if survey spanned multiple years.
- Age Group: 15-24, 25-34, 35-49, 50+, 15-49 or 15+.
- Sex "male", "female" or "both".
- HIV Status: "positive", "negative" or "all".
- Estimate: Estimate for proportion ever tested for HIV; as a percentage (e.g. 87.6 rather than proportion 0.876).
- Standard Error: Standard Error of the estimate (as a percentage). Should take into account survey design effects.
- Lower Confidence Interval: Lower limit of the 95% confidence interval of the survey estimate (as a percentage).
- Upper Confidence Interval: Upper limit of the 95% confidence interval of the survey estimate (as a percentage).
- Counts: Unweighted counts of the number of survey respondents included in the stratification group.
You can copy and paste from Excel or upload a new CSV file.
All columns are required. Where values are unknown, please just leave blank. The app will not accept an uploaded CSV with the wrong headers. It may be useful to download the headers as a template:
Download CSV templateUpload new data
Or edit data in place
Upload programmatic data
Please provide programmatic data sourced from national testing programs. For each year please provide either sex aggregated data (1 row with sex = "both") or sex disaggregated data (2 rows with sex="male" and sex="female" respectively). Where values are unknown, please just leave blank. Where available please provide the following:
- Country or region: Must exactly match country or region in top left panel.
- Year: Calendar year in which the HIV tests were performed.
- Total Tests: This is the annual number of tests performed at the national level among the population aged 15+ years of age. This number should be equal to the total number of tests administered as part of HIV Testing and Counseling (HTC) and during antenatal care (ANC), and for which the clients received the results.
- Total Positive Tests: Out of the total annual number of tests, how many were found to be HIV positive. This number should be equal to the number of positive tests found during HTC (in non-pregnant population) and during ANC among pregnant women.
- Total HTC Tests: Total annual number of tests performed in the population aged 15+ years outside of ANC services, and for which clients received the results.
- Total Positive HTC Tests: Annual number of tests that were found to be positive for HIV outside of ANC services.
- Total ANC Tests: Annual number of pregnant women tested for HIV (and that received their results) as part of ANC services.
- Total Positive ANC Tests: Annual number of pregnant women found to be HIV positive during ANC services.
- Sex: Male, female or both.
*A person should only be counted as testing once even if up to three different assays are performed to confirm an HIV-positive diagnosis according to the national testing algorithm. A person who is tested twice during the year should be counted as contributing two tests.
You can copy and paste data from Excel into the table below or upload a CSV file.
All columns are required. Where values are unknown, please just leave blank. The app will not accept an uploaded CSV with the wrong headers. It may be useful to download the headers as a template:
Download CSV template