Find Jobs
Hire Freelancers

Excel Tracker for Installer Jobs

$10-30 USD

Closed
Posted about 1 month ago

$10-30 USD

Paid on delivery
--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - Automatic calculation of the total payment owed to each installer based on the number of jobs completed. 3. **Customer Information:** - Columns for customer name, address, and account number. 4. **Summary:** - A summary section that provides totals for jobs completed and payments owed for easy reference. **Additional Features:** - The ability to filter and sort jobs by date, installer, or customer. - An input form for easily adding new job entries. **Skills Required:** - Proficiency in Microsoft Excel, including formulas and data validation. - Experience creating user-friendly and automated Excel sheets. **Deliverables:** - A fully functional Excel sheet as described. - Instructions for use and any necessary documentation. **
Project ID: 38123663

About the project

36 proposals
Remote project
Active 22 hours ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
36 freelancers are bidding on average $24 USD for this job
User Avatar
As an experienced data professional, I completely understand your need for a streamlined and automated excel sheet to track installer jobs and calculate payments. With several significant projects under my belt in fields like ecommerce and data analysis, I am particularly well-versed in Microsoft Excel and have a robust command over its features such as formulas and data validation to make your project come alive. Additionally, I am also skilled in creating user-friendly interfaces which will accentuate the easy entry and retrieval of job information. My expertise doesn't just lie in creating orderly data sheets, but extends to optimizing their functionality to benefit businesses like yours. Hence, incorporating sorting and filtering options by date, installer and customer is second nature to me. The same skill translates into the ability to generate insightful summaries that provide clear totals of jobs done and payments owing for swift reference.
$29 USD in 1 day
5.0 (125 reviews)
6.7
6.7
User Avatar
i can create totally dynamic sheet including all calculation that you mentioned above ,,,,,,,,,,,,,,,,,, About me ADVANCE EXCEL , more 7 years experience I am a CERTIFIED Excel VBA Programming , CERTIFIED Business Analytics and Professional Certificate in Excel Accountant i have a MASTER of BUSINESS ADMINISRATION
$20 USD in 1 day
5.0 (34 reviews)
5.1
5.1
User Avatar
Hi, can help to create script that do Excel Tracker for Installer Jobs This is Qandil I am developer,, I can start work on your script to make it work perfectly and improve the performance. For more discussion on the project , we can chat on inbox. I am waiting to grab this opportunity from you.
$30 USD in 1 day
5.0 (15 reviews)
4.1
4.1
User Avatar
Hi There, Hope you are doing well, Interested in your posting as I’m used to performing such projects (See Profile + https://www.freelancer.com/get/Leozida?f=givepc). I’m available and ready to have a look if you give me a chance. Please share more details/file/sample in order to assess the work expected and run a resolution/draft. I would like to assist you at a reasonable price along with high-quality work delivered on time. Looking to hearing from you soon, My experience does not always translate into more money but it definitely helps :) Thanks & Regards, Leo,
$40 USD in 2 days
4.9 (25 reviews)
3.9
3.9
User Avatar
Hi there, I am a Data Scientist with excellent knowledge and enthusiasm for Microsoft application development. I can do advanced Excel, Word, Access, Power BI, and Outlook and create VBA macros. Advanced Array Formulas, Charts, Pivot Tables, Pivot Charts, Mail Merge, Capabilities, and Spreadsheets. Email through Outlook and Gmail, Add-in, Customized Macros. My top priority is to provide high-quality work. I am willing to devote my time and energy to improving the service with timely, accurate, and professional results. Building trust and a long-term relationship with customers is my main objective. Improving https://www.freelancer.com/u/IcsfIT789 Let's discuss this further via chat, and I'll start your project right now. Thanks IcsfIT
$30 USD in 2 days
4.8 (6 reviews)
3.7
3.7
User Avatar
It will take me just hours to create the Job Tracking and Payment Calculation Excel Sheet. I will use an easy and simple form to handle inputs. I will fulfill all the requirements you mentioned. Message me so I can send you a roughy idea by creating such a sheet to get an idea of what you will get. Thanks.
$28 USD in 7 days
5.0 (3 reviews)
3.1
3.1
User Avatar
Greetings, Having carefully reviewed your project description, I am confident in my ability to execute this project to perfection. I possess a broad spectrum of skills, knowledge, and experience in this specific field, making me the ideal candidate to handle your project. My proficiency includesVisual Basic, .NET, C# Programming, Software Architecture and Excel, which positions me as the best choice for the successful completion of your project. While I am well-prepared to begin, I have a few clarifying questions. Kindly drop me a message in the chat so that we can engage in a discussion regarding the project's budget and deadline. Thank you, and I look forward to the opportunity to collaborate on your project.
$30 USD in 2 days
5.0 (2 reviews)
2.8
2.8
User Avatar
As your dedicated IT strategist, I have a wealth of experience in utilizing Microsoft Excel to create customized and automated solutions. Specifically, I have a strong proficiency in utilizing Excel's powerful formulas and data validation to create user-friendly, comprehensive spreadsheets. The requirement of your project to have an effective job tracking and payment calculation system is something I can accomplish with ease given my deep expertise in Excel. Moreover, with my web development background, I understand the importance of scalability and simplicity in digital tools. This means that, apart from addressing your specific requirements of filtering/sorting jobs and input forms for new entries, I will ensure that even an Excel novice can operate and get accurate results from the tracker. Furthermore, I am well-versed in creating efficient documentation, so you will receive detailed instructions on how to optimally use the sheet. In sum, my professional profile coupled with my skills in excel make me the ideal fit for this project. I look forward to exceeding your expectations as we bring this innovative software solution to life!
$20 USD in 7 days
5.0 (3 reviews)
2.7
2.7
User Avatar
As a seasoned Software Developer with over a decade of experience working with leading organizations like IBM, I have notched up incredible expertise in creating dynamic and automated solutions using Microsoft Excel, making this project right up my alley. I bring a unique blend of skills that align perfectly with your requirements: proficiency in Excel formulas, data validation, and a deep understanding of data management. What sets me apart is my ability to think beyond the obvious and create intelligent data systems that simplifies complex tasks. I envision your Excel tracker to not just be an efficient job tracking system but one that provides meaningful insights for easy decision making. My experience in creating similar trackers for sectors like Real Estate and Finance acts as further validation of my capabilities. To summarize, I am experienced in the full software development lifecycle and can leverage numerous programming languages (including .NET), which emphasizes my adaptability and resourcefulness. My commitment to delivering superior work on time is matched only by my dedication to maintaining constant communication. Working with me would ensure a glitch-free process and a quality-output that meets your exact specifications. Let's start this wonderful journey together today!
$20 USD in 7 days
5.0 (4 reviews)
2.5
2.5
User Avatar
I'll create for you the excel title and a python desktop app that will help you in CRUD operations within the excel. The script will be able to manipulate the data line by line, column by column
$20 USD in 7 days
3.8 (1 review)
2.7
2.7
User Avatar
Good day. Thank you for your proposal. I have been a Professional Remote – Accounts Manager/Bookkeeper/Admin Manager/Data Entry for 12 years with the same company. I managed all of these roles simultaneously and remotely. My Responsibilities as Bookkeeper, though not qualified, included Invoicing, Payment Processing, Account Reconciliations (all of which was processed on Kidsoft Software, Excel, Word), Income and Expense entries and Bank Reconciliations. I solely was responsible for all Data Entry, upkeep and maintaining of all data on all programs & databases, for the entire company. I am known in my professional career, as being extremely accurate, meticulous and detail orientated with all my work. I would like to send you my Comprehensive CV as well as Contactable and Written Work References, as a testament of my Experiences, Capabilities and Core values as an Employee. All work that I do for you is kept confidential and treated with utmost sensitivity. Guinnevere Michelle Cloete
$25 USD in 7 days
5.0 (2 reviews)
2.0
2.0
User Avatar
Hello there, I will help with project on Excel Tracker for Installer Jobs.I have read the instructions carefully and I clearly understand what is required of the project. I have handled several assignments on this field and I will be glad to offer my expertise and on this one too. With me, the quality and the deadline of your paper are my utmost priority. I have expertise needed to complete your project as i have skills in C# Programming, Visual Basic, .NET, Excel and Software Architecture. Feel free to contact me for more details.
$26 USD in 2 days
3.9 (2 reviews)
2.1
2.1
User Avatar
Hi Argeliz P. Good evening I am experienced Virtual Assistant Lead. I have read your project Excel Tracker for Installer Jobs . I have rich experience in similar type of projects and you can definitely consider me for this project. I can make quick delivery, give best of the price & quality to you. Waiting for a positive response from you. Please open PMB to discuss this further. Here are some of my skills: - Product Listing in Woo-commerce, Shopify, Magento, Ebay, Amazon and so on… - Image Collage Creation - Banner Design Creation - Remove Background from Images - Social Media Management - Backlink Creation - Influencer Partnerships - Data Entry & Typing - Excel / Google Spreadsheet Work - Google App Scripts Development - Powerpoint Presentation Creation - Google Form Creation - Internet Research & Create Reports - Job Hunting - Product Research - Provide Customer Service - Email & Newsletter Management - Respond to Customer Inquiries - Manage CRM Tools - Track Expenses & Invoices - Appointment Setting & Calendar Management - Travel Management & Ticket Booking - Employee Hiring/Pre-Screening - Any Miscellaneous Tasks Kind Regards Ritesh Jain
$20 USD in 6 days
5.0 (4 reviews)
1.1
1.1
User Avatar
Hi, I am Zaldy, As I'm new here, I don't expect you to trust me right away so I put lowest bid amount (I actually tried to put 0 AUD but the site didn't allow me). I don't expect anything in return but feel free to pay me base on your satisfactory rate after I finish the project and honest feedback would be enough. Bit background of my self. I based in the Philippines and currently employed in an Australian Company. I've been using VBA macro to automate Microsoft Excel and Word for the company for 8 years. Some of my projcects relating to VBA Macro includes: - Project Budgeting & Forecasting tool. This tool made from Excel Macro. It used by the company to forecast budget, managing cost and performance of the company projcets. - Word Wizard. Customizing Microsoft Word functionalities for Word Templates used by the company. - Data trackers Other Skills: - VB.NET - SQL - API handling
$20 USD in 7 days
5.0 (1 review)
0.4
0.4
User Avatar
I can make this in less than 10 hours I just want to know what information you want to add to the sheet
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
As a freelancer with a strong background in Microsoft Excel, I'm confident that I can create the custom Excel sheet you need to effectively track your installer jobs, manage payments and generate insightful summaries. I understand the importance of attention to detail in capturing essential information such as dates, customer details, and installer assignments. My previous work in similar projects involved creating sophisticated Excel systems, which allowed users to filter and sort jobs by date, installer or customer for easy reference. In terms of payment calculation, I can design intuitive formulas and data validation functions that automatically calculate the total number of jobs completed by each installer while giving you an accurate measure of their owed payments. Furthermore, I pride myself on my ability to make complex tasks user-friendly. Hence, I'll incorporate an input form for adding new job entries effortlessly. At its core, my approach to this project falls into two categories: efficiency and reliability. In addition to delivering a well-structured and fully functional Excel sheet tailored uniquely to your needs, I will also provide detailed instructions for usage and any necessary documentation. Choose me for this task and save yourself the headache associated with coordinating several parts of your processes manually - let's get your project on track!
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I am proficient in Microsoft Excel and experienced in creating user-friendly and automated Excel sheets. I can develop a custom Excel sheet tailored to your needs for tracking jobs, calculating payments, and organizing customer information. The sheet will include columns for job details, installer assignments, and payment rates, with automatic calculations for total jobs completed and payments owed. Additionally, I will incorporate features for filtering, sorting, and adding new job entries to enhance usability. You can expect a fully functional Excel sheet along with comprehensive instructions upon hiring. Let's have a quick call to discuss the project in more detail and share my relevant experience. Regards, noureen
$10 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can develop the application without problems but I would like to have the template you use for the excel sheets to give me an idea of ​​how I will develop it.
$15 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Just started freelancing but given my experience with building automated commission calculations and statistical forecasting, i am certain to provide you with an automated and dynamic excel spreadsheet to serve your needs.
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi Team, This is Suresh and i have rich experience in excel development. In my past experience, I have createdmany excel macros nad template for various accounting business. Looking fwd to hear back you. Thanks, Suresh
$20 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Randolph, United States
5.0
5
Payment method verified
Member since Feb 12, 2023

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.