Excel Expert (Local to Castaic, CA) to Revise Budget Templates for Animal Training Production

---

---

Job Type: Fixed-price or hourly Budget: $250–$600 (fixed) or $35–$90/hour Timeline: 1–2 weeks Location: Castaic, CA (must be able to visit our office for in-person collaboration) Job Description We are a small business in Castaic, CA, specializing in animal training for commercial shoots, seeking an advanced Excel expert to revise our budget templates (e.g., "Budget - Union.xlsx"). The templates need simplification for usability, automation of calculations, and error reduction. They should handle trainer wages (e.g., $72.69/hr standard, $145.38/hr for 7th-day overtime), animal-related costs, and a 40% P&W markup, while supporting real-time collaboration via OneDrive for a team of 10. We want a professional, branded design reflecting Studio Animal Services. The candidate must be local to Castaic, CA, and able to visit our office for in-person meetings to review requirements and test templates. Responsibilities Simplify the layout of existing Excel budget templates for clarity and ease of use. Automate calculations for trainer wages (standard, 1.5x overtime for hours 8–12, 2x for hours over 12 or 7th day), animal costs, and production phases (e.g., travel, shoot days). Implement error-checking features (e.g., data validation, conditional formatting) to prevent input errors. Enable real-time collaboration via OneDrive, ensuring templates are shareable and editable by multiple users. Design a polished, branded template with our logo, color scheme (e.g., professional blues/greens), and clean formatting. Visit our Castaic, CA office for 1–2 in-person meetings to discuss requirements, review progress, and test templates. Provide a brief user guide or video walkthrough explaining how to use the revised templates. Requirements Advanced Excel skills (VLOOKUP, PivotTables, macros, VBA for automation). Experience creating financial or production budgets, preferably for entertainment or service-based businesses. Familiarity with OneDrive for real-time collaboration. Ability to design visually appealing templates (e.g., using Excel formatting or integrating with tools like Canva for branding). Must be located in or near Castaic, CA, and available for in-person meetings at our office. Strong communication skills to clarify requirements and provide updates during on-site and remote work. (Preferred) Experience with animal training, film production budgets, or similar industries. Deliverables Revised Excel budget template(s) with automated calculations, error-checking, and OneDrive compatibility. Professional design incorporating Studio Animal Services branding (logo and colors provided). User guide or short video walkthrough (2–5 minutes) for template usage. Test cases demonstrating accurate calculations (e.g., 10-hour and 16-hour shoot days). Participation in 1–2 in-person meetings at our Castaic, CA office to ensure templates meet our needs. Application Instructions Submit a brief cover letter explaining your experience with Excel budget templates and any relevant industry knowledge (e.g., entertainment or production). Confirm your location in or near Castaic, CA, and availability for in-person office visits. Include links to portfolio samples or screenshots of similar Excel projects. Specify your proposed approach to simplifying our templates, automating calculations, and collaborating in-person. Provide your hourly rate or fixed-price bid and estimated timeline. Additional Notes We will share a sample budget file for reference upon hiring. In-person meetings will involve reviewing the current template, discussing revisions, and testing the final product. Preference for candidates who can start within 3–5 days and complete within 1–2 weeks. Ongoing maintenance or additional template work may be available for high-performing candidates. Apply now to help us streamline our budgeting process and deliver professional, error-free estimates for our clients! Must be local to Castaic, CA, for in-person collaboration.

Keyword: Design layout

Price: $600.0

Microsoft Excel Accuracy Verification