Required stack
필요 기술
ExcelVBAData AnalysisFinancial ModelingData ManagementReporting
Project brief
프로젝트 내용
I need a freelancer to calculate the effective labor rate in both dollar amounts and as a percentage of an advertised rate. This data should then be organized into an Excel lookup table sorted by date. 3 SHOPS WILL NEED INDIVIDUAL SCORE AND AVERAGE FOR ALL 3 FOR BOTH $ AND %.
CALCULATIONS SPREADSHEET LINKED TO TABLE AND UPDATED WEEKLY BY MANUAL ENTRY INTO CALC SHEET AND THEN INSERTED ON TOP OF TABLE BY DATE, OLDER CALCS DESCENDING. NEED MONTH,QUARTERLY AND YEARLY REPORTS AND ARCHIVE INFO.
Requirements:
- Calculate effective labor rate in $ and %.
- Organize results in an Excel lookup table by date.
- Use an Excel file with advertised labor rates provided.
Ideal Skills and Experience:
- Proficiency in Excel
- Strong mathematical and data organization skills
- Experience with data manipulation in Excel
CALCULATIONS SPREADSHEET LINKED TO TABLE AND UPDATED WEEKLY BY MANUAL ENTRY INTO CALC SHEET AND THEN INSERTED ON TOP OF TABLE BY DATE, OLDER CALCS DESCENDING. NEED MONTH,QUARTERLY AND YEARLY REPORTS AND ARCHIVE INFO.
Requirements:
- Calculate effective labor rate in $ and %.
- Organize results in an Excel lookup table by date.
- Use an Excel file with advertised labor rates provided.
Ideal Skills and Experience:
- Proficiency in Excel
- Strong mathematical and data organization skills
- Experience with data manipulation in Excel