A computer-implemented method for disaggregating data in a spreadsheet or other data structure hosted on a client computing device includes providing an analyzer module as a plug-in or add-in to a spreadsheet application on a client computing device. The analyzer module locally performs disaggregation and aggregation processes on data in the spreadsheet on the client computing device. The method includes parsing, by the analyzer module, content entered in a subject cell of the spreadsheet to determine if sets of special syntax characters corresponding to a disaggregation instruction or command precede an amount in the entered content, and accordingly disaggregating or aggregating data in the spreadsheet.