INTL
Freelancer
보통
외주
원격 가능
Labor Rate Calculation and Lookup Table
예상 기간
2~4주
난이도
보통
기술 스택
Excel
VBA
Data Analysis
Financial Modeling
Data Management
Reporting
AI 분석 요약
이 프로젝트는 3개 상점의 실질 노동률을 달러 금액과 백분율로 계산하고, 이 데이터를 날짜별로 정렬된 Excel 조회 테이블로 구성하는 것입니다. 주간 수동 업데이트와 월별, 분기별, 연간 보고서 작성이 필요하며, Excel 숙련도와 데이터 정리 및 계산 능력이 중요합니다.
프로젝트 원문 설명
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
Freelancer에서 원본 확인
원본 보기