Example one: I took 3 days to work building quotes into a spreadsheet to cross-compare on equal footing. The lowest price wasn't going to be the lowest all things considered.
Most of my spreadsheet activity involves text, so I use spreadsheets to lookup values in data sets or to calculate statistics such as character count or word count. I have spreadsheets for Index4INDEX @ LikeTu, #zapfic, and LeoGlossary 👉
Regarding LeoGlossary, the tricky part is extracting a sublist of relevant search results. Out of 2000+ entries, my results can still number near 100. I'm still trying to figure out how to display search results. ⏹️
Not sure a spreadsheet's basic search functions will help. But you could write some custom code to do that. There are various text relevancy algorithms you could try. Even something as basic as adding synonyms and then a count of matches might help.
Example two: Planning travel has an itinerary (time) and budget (money). Any major expense gets a line: e.g. flights, accommodation, insurance, daily allowance. I don't need to ask if I can afford X or time for X because I already know.
Example three: scenario planning for retirement. Am I going to have enough, and when? How does a recession affect me? All scenarios I can map out on a spreadsheet.
Example one: I took 3 days to work building quotes into a spreadsheet to cross-compare on equal footing. The lowest price wasn't going to be the lowest all things considered.
Most of my spreadsheet activity involves text, so I use spreadsheets to lookup values in data sets or to calculate statistics such as character count or word count. I have spreadsheets for Index4INDEX @ LikeTu, #zapfic, and LeoGlossary 👉
Absolutely. Very useful so those tasks too.
Regarding LeoGlossary, the tricky part is extracting a sublist of relevant search results. Out of 2000+ entries, my results can still number near 100. I'm still trying to figure out how to display search results. ⏹️
Not sure a spreadsheet's basic search functions will help. But you could write some custom code to do that. There are various text relevancy algorithms you could try. Even something as basic as adding synonyms and then a count of matches might help.
#pepe love spreadsheets!
#meme
Databases are great too. For tracking .... um.... things.
Example two: Planning travel has an itinerary (time) and budget (money). Any major expense gets a line: e.g. flights, accommodation, insurance, daily allowance. I don't need to ask if I can afford X or time for X because I already know.
Example three: scenario planning for retirement. Am I going to have enough, and when? How does a recession affect me? All scenarios I can map out on a spreadsheet.