Name: Logic Sheet
Rating: 0.0 (0 reviews)

Hey hunters, I am the maker of Logic Sheet, the all-in-one data processing tool for Google Sheets. Logic Sheet is an add-on for Google Sheets, you can install it directly from your worksheet and start using it. I am a tech journalist and I use Google Sheets a lot to deal with data in my work. I learned Google Apps Script last year to facilitate my work, doing tasks like import stock price data into a spreadsheet and do statistical analysis. After realizing how people really like scripts I wrote, I published the add-on to the Google Workspace Marketplace in January. And now, I have accumulated more than 2,500 installs. What can you do with Logic Sheet? >> API Connector 🤖️ With Logic Sheet's API Connector function, it's now easy to make POST/GET requests to any JSON data source and import REST API data directly to your spreadsheet. This means you can import JSON from any URL. >> Data cleaning 🧹 - Remove duplicates: Remove all extra rows that have duplicate values in each cell to clean dataset. - Case Converter: Change text casing of all values of the selected range into upper case, lower case, pascal case, title case, proper case, camel case, snake case, sentence case, train case, or kebab case. - Unpivot data: Transform a pivot table into a regular tabular sheet. >> Calculate 🧮 Use Logic Sheet to insert a cumulative sum column or insert a growth rate column next to the selected column. >> Data Analysis Toolpak 🛠 - ANOVA, or Analysis of variance: Use Logic Sheet to do ANOVA analysis, calculate the sum of squares, variance, mean squares, P-value, and F crit value. Both ANOVA (ANOVA Single Factor) and two-way ANOVA (two-factor ANOVA) are supported. >> Finance 💵 Logic Sheet can help you import stock prices, financial statements, and foreign exchange rates into your spreadsheets and simplify your financial analysis workflow. I look forward to hearing your feedback, so please share your thoughts in the comments! Cheers, Wei