Development of a template in Google Sheets for calculating economics
Development of a template for calculating economics for a business. Data is automatically collected from several separate Google Sheets (Timesheet, Materials Used, Accounting, etc.) and in the main file, the cost and profit for each completed order are calculated. The main types of formulas used for data collection and calculations: IMPORTRANGE, VLOOKUP, ARRAYFORMULA, COUNTA, SUMIFS, CONCATENATE, FILTER, IF, UNIQUE, FLATTEN, CHOOSE, VALUE, SUBSTITUTE.
#report #GoogleSheets
#report #GoogleSheets