Formula calculating morgage jobs

I'm seeking a skilled data analyst to evaluate head count turnover within my company on a weekly...analysis using multiple measures - by percentage, number of employees, and over various time periods. As the ideal candidate, you'll have: - Proficiency in data analytics - Experience with employee data and turnover metrics - Ability to offer insights based on complex data - Capabilities to deliver weekly reports and insights Your task will include: - Parsing sales, customer, and financial data - Calculating turnover rates in terms of percentages, numbers, and durations - Producing a report every week with a detailed analysis of findings. Your ultimate goal will be to use data to help understand and reduce our turnover rate. Solid experience in workforce analytics is a mu...

I am in need of a skilled professional who can perform a wobble broaching analysis for a specific rectangular object. The primary purpose of this task is to calculate the change in area and volume for this object. Key Requirements: - Expertise in wobble broaching analysis - Proficiency in calculating changes in area and volume - Experience with analyzing rectangular objects Your main task will be to assess the rectangular object and provide a detailed report on the changes in its area and volume. The analysis should be accurate and precise, providing insights that can inform our manufacturing processes and product quality going forward.

...comprehensive manner. - Proficiency in working with survey data: You will be dealing with survey data, so experience in this particular field is highly preferred. - Familiarity with spreadsheet software: The data is in a spreadsheet format, so proficiency in software like Excel or Google Sheets is a must. Your primary objective will be to provide a detailed description of the data which includes calculating the central tendencies, measures of dispersion, and other relevant statistical indicators. You will also need to present this information in a visually appealing format that is easy to understand and digest. I am looking for a freelancer who is not only skilled in statistical analysis but also has a good eye for detail and can communicate complex information in a simple an...

I'm in need of a professional writer, ideally with a solid underst...has been commenced in the business and property courts. - The primary focus of this proposal will be for negotiating a settlement with the opposing party involved in the dispute. - The ideal candidate will have previous experience in drafting similar legal documents and have a good grasp of legal jargon associated with contract disputes. - the ideal candidate should be good with numbers and calculating interest as I will be providing base numbers for them to work with and formulate a proposal with. - Your skills should extend to being persuasive, concise and informative for the opposing party to clearly understand my perspective. - Your end goal must be to posit my arguments favorably in order to facilitat...

We are seeking a skilled developer to create a comprehensive estimator tool for commercial construction projects. The tool should be capable of accurately calculating costs related to materials, labor, and profit margins. **Key Features:** 1. **Material Cost Estimation:** - Database of construction materials with current pricing. - Ability to input custom material costs. - Calculation of total material costs based on project specifications. 2. **Labor Cost Estimation:** - Standard labor rates for various construction tasks. - Option to customize labor rates. - Calculation of total labor costs based on project duration and complexity. 3. **Profit Margin Calculation:** - Input desired profit margin percentage. - Automatic calculation of profit based on mat...

I have an existing Excel VBA project that interfaces with AutoCAD 2020. I'm looking for an experienced VBA developer to up...advantage. Your bid should include: - Your relevant experience with VBA and AutoCAD - Any specific features you've implemented in similar projects - How you plan to approach this update and any additional functionalities you intend to add - The estimated time to complete this project About the Projects: The existing CODE to be updated, for the formula 128 the Pline drawn CCW (counterclockwise) to be shown with a negative sign before like -0.853 The Formula 900 the existing CODE to be updated so that all Pline under the same property to be calculated / added in the sum (Pline1= 2.35 Pline2=1.25 …. Pline6=3.25 so SUM = XXX) Any Quest...

Project: Bring Member, Make Money System What do we do? : We are the Official Partner of TikTok LIVE Turkey. We provide free support to the streamers working with us. This system will allow people who bring us publishers with their own referral link...that the system is mobile compatible. Poppins will be used as font. With the member in the admin role, we will be able to add members if we want, and we will check the information of the publishers added by the members and give approval / rejection. We will also write a reason when rejected. The member will be able to see this reason from their own panel. The system will calculate with a simple formula and show the earnings of that member on that publisher. Experienced people who can make this system can contact us and give us a pr...

I have a Microsoft Excel assignme...have a Microsoft Excel assignment that needs expert handling. My needs include: - Data analysis: I want to make sense of my data, and uncover any hidden trends or correlations. - Formula creation: I require the creation of Excel formulas to automate data processing tasks. - Graphs and charts: I need insightful visuals to represent my data. This will aid me in understanding and communicating it more effectively. While it's unfortunate I could not provide more detailed information, it's vital that the freelancer can work with a certain degree of ambiguity. Expertise in Excel-based data analysis, formula creation, and chart and graph creation are essential. An ability to uncover data insights, no matter how small the dataset,...

I'm looking for a professional who can help me design a custom formula for a car shampoo. The shampoo is intended for everyday consumer use, so it should be both effective and safe for regular application. Key specifics include: - Formulation for high foaming: The shampoo should produce a rich, dense lather that enhances cleaning efficiency and user experience. - Gentle on paint: Even with its foaming capabilities, the final product must be safe and gentle on car paint to avoid any damage and ensure a long product lifespan. - Eco-friendly: The car shampoo should be completely biodegradable to align with sustainability goals and cater to environmentally-conscious consumers. The ideal candidate for this project should have a strong background in chemical formulation, particu...

I've noticed some key issues with my ecommerce website that I hope can be swiftly addressed. Primarily, it's not correctly calculating and providing a shipping calculator at checkout. This malfunction is proving problematic and needs prompt resolution. Key Task: - Create a new shipping calculator which calculates shipping costs based on the weight of items in the customer's cart. Shipping Providers Integration: - The shipping calculator should be integrated with both FedEx and UPS. Ideal Candidate: - Proven experience working with ecommerce platforms - Knowledgeable about integrating FedEx and UPS services - Excellent problem-solving skills in web development.

I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.

I need create calculator like on page : and implement to my page : It must be only for product in category a-typ. Formula: Width formula: Base price (always for the dimension 90x200) / 90 = value x desired width = price with VAT. Length formula: Calculated width price / 200 = value x desired length = price with VAT. here is JS for this from page dreambed. <script> function calculateCustomPrice(element) { const customPriceInput = ('js-custom-input'); let productId = , location = String() + '?productId=' + productId + '&do=calculateCustomPrice'; for (let input of customPriceInput)

I need help with my Microsoft Excel project! Specifically, I require assistance with the following: - **Formulas and Functions:** - Basic arithmetic operations. I don't need anything too complex, just fundamental formula structures. - **Automation:** - No macros for repetitive tasks are required, but I need guidance on setting up conditional formatting rules within the document. I'm looking for a Freelancer who is experienced in Excel and is comfortable with basic arithmetic operations and conditional formatting. You should be able to provide clear, concise, and easy-to-follow guidance. A strong attention to detail and excellent communication skills are a must. If you're proficient in these areas, I'd love to hear from you!

I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation

I need a cu...customized formula in an Excel spreadsheet to calculate different rates based on the day of the week. Here are my specific requirements: - The formula should apply different rates for weekdays, Saturdays, Sundays, and Public Holidays. These rates are as follows: - Weekdays: $30.10 - Saturdays: $36.12 - Sundays: $42.14 - Public Holidays: $60.20 - This calculation must be flexible and able to automatically adjust to the specific day in the date field. We will also add another box that adds11% to the total figures. Ideal Skills and Experience: - Proficiency in Microsoft Excel and its formula creation. - Experience in creating custom Excel formulas to calculate based on specific conditions. - Attention to detail to ensure the accuracy and funct...

Being familiar with grocery industry finances, I need an expert to conduct a detailed analysis regarding a store's annual profitability. This involves but is not confined to: - Breaking down costs and expenses - Calculating and understanding profit margins The ideal professional must have experience in financial data analysis with exquisite accuracy. Favorably, knowledge or background within the grocery retail sector is advantageous. The final analysis report should be delivered in a well-structured PowerPoint presentation that encompasses all key findings. It's important for the report to be clear, and easy to understand for non-finance personnel. I am open for any approaches or suggestions, as long as they fulfill the core objective of this project: gaining relevant insi...

I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.

I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This s...GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient solution, as the generated GUIDs will be essential for...

...profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% However, instead of getting 19.88%, the result I am seeing is 1987.95%. This suggests there might be an error with the data, cell formatting, or an unnoticed issue in the spreadsheet. Specific Tasks: Review the Spreadsheet: Analyze the provided Excel file to ensure all values, formulas, and cell references are correct. Identify the Issue: Determine why the formula results in 1987.95% instead of the expected 19.88%. Correct the Calculation: Fix the formula or any underlying issues to dis...

I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Pagamento ordine" and "Rimborso". Make the sum using the formula in column J "totale ordine" of the attached “esempio output” file 2- Filter the rows of input file 2 (attached), column D "Dettagli prodotto" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "dettagli prodotto”of input file column 2 are listed. (example VAT file attached) 3- The app must check th...

I'm currently working on an Excel sheet for performance analysis and I need assistance with writing the SUMIF formula. Key Requirements: - Assist with writing the SUMIF formula for my Excel sheet (vlookup, countif, and other formulas are not needed for this project) - Ensure the formula fits within the context of performance analysis Ideal Freelancer: - Experienced in Excel and in particular, writing SUMIF functions - Knowledge of performance analysis or related fields is a plus

I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me resolve these issues promptly.

I'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free work in a timely manner.

We are looking for a skilled construction estimator to provide accurate cost estimates for a 3 dwelling construction site. The estimator will be responsible for analyzing project plans, performing quantity take-offs, and calculating material, labor, and equipment costs. The ideal candidate should have a strong understanding of construction industry standards and be proficient in using estimating software. Attention to detail, strong analytical skills, and the ability to work independently are essential. This is a great opportunity to join a dynamic team and contribute to the success of a high-profile construction project. Skills required: - Construction estimating - Project planning - Quantity take-offs - Estimating software - Analytical skills

I have a substantial Excel table and I am in need of a skilled data analyst to help with correlation analysis between Column 1 to 9 of my dataset, which contains more than 4200 rows and 9 columns. Need the source file of xls with formula too Key Responsibilities: - Perform accurate correlation analysis on specified columns - Generate line graphs to visualize the correlation Ideal Skills and Experience: - Proficiency in Excel and correlation analysis - Solid understanding and experience with line graph creation - Excellent problem-solving abilities - High attention to detail I'm looking for accurate and efficient work so I can understand the relationship between my data points and act accordingly. Your experience could be the key to enhancing my project. Looking forward to se...

I have a complex Excel file with more than 10 worksheets that I need help with. The project involves three main tasks: data entry, formul...analysis. Key Responsibilities: - Data Entry: - Ensure accurate entry of information across various tabs - Formulas and Calculations: - Implement necessary formulas and calculations to make sure that the data is accurately processed - Data Analysis: - Utilize Excel functions for data analysis Skills and Experience Required: - Proficient in Excel, including strong skills in data entry and formula creation - Experience in data analysis and visualization would be a plus - Attention to detail and accuracy are crucial as the data is spread across multiple tabs This is an urgent project and I would prefer someone who can dedicate their t...

I'm in need of an intricate financial model designed for a residential property that focuses on calculating equity investments. Specifically, I want: - Informative analytics on 'Return on Equity', to evaluate potential profits over time. - An illustration of 'Cash Flow Distribution', to comprehend the income dispersions. - Analysis on 'Equity Multiple', to understand the total cash received against the total equity invested. Ideal freelancers will have a strong background in financial modelling, specifically pertaining to property investments. Understanding of debt financing, equity investments and capability in generating these specific outputs is critical.

I'm looking for a data entry specialist to assist me with entering a mix of numeric, textual and formula-based data into a spreadsheet. The data will be provided in digital format, typically in CSV or Excel files. Key Responsibilities: - Accurately transcribing a mix of text, numbers, and formulas into a spreadsheet - Ensuring that the data is organized and categorized correctly - Delivering the completed spreadsheet on time, following provided guidelines Ideal Candidate: - Proficient in data entry with experience in handling diverse types of data - Familiarity with Excel and basic formulas - Detail-oriented and capable of consistently delivering accurate work - Able to work independently with minimal oversight If you have the required skills and are committed to high-quali...

I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation

...me automate a complex process. As of now, I manually gather numerical data from a variety of unstructured sources like images, text, and PDFs. This data includes formulas and is stored both on my local computer and the web. At present, I get ChatGPT to convert this data into a table which I then paste into excel. I do calculations in excel to find out what percent each ingredient is of a total formula. Then I create a new entry into a table in Airtable and paste this data into a different table in Airtable which references the first table. I need someone to automate this data extraction process, calculations and entry into two separate Airtable tables so I can do it repeatedly myself. I work in a standardised operating environment for work so ideally I need a web based solution r...

I am looking for a professional who can build a web application that automates the creation of Google Sheets formulas. Requirements: - Build a web application that all...automates the creation of Google Sheets formulas. Requirements: - Build a web application that allows me to input a plain text command in a Google Sheets cell (i.e., I type "= find the mean of the data above". - Translate the plain text command into a Google Sheets formula using the ChatGPT API. - Authenticate and send the formula to Google Sheets for execution. Ideal candidate: - Proficient in web application development. - Experience with integrating APIs, particularly ChatGPT. - Familiarity with Google Sheets automation and formula creation. - Strong understanding of user interface desi...

As a new hotel owner, I need an Excel spreadsheet capable of calculating the optimum number of staff I need based on the number of available rooms, which in my case is 438 rooms. My current hotel staffing level is in its initial stages. The spreadsheet should effectively track staff allocation costs and other related expenses to assist in budgeting. The key tasks it will need to perform include: - Calculating the optimum number of staff - Staff allocation - Expense tracking The ideal freelancer will have experience in human resources, budgeting and have advanced Excel skills. They should understand how staffing impacts hotel operations and costs, with a keen understanding of allocation of resources. Their experience should also include creating Excel spreadsheets for comp...

I'm in need of a talented financial analyst to create a robust underwriting model for a multi-family property. Key Requirements: - Develop a comprehensive underwriting model for a multi-family property that will assist in calculating the internal rate of return (IRR) and equity multiple. - This model should also include waterfall projections that cover profit splits, with and without preferred returns. Additionally, I require a clear, user-friendly format that is easy to understand for someone without an extensive financial background. The ideal candidate for this project should have a strong background in finance, specifically in multi-family real estate. In summary, the main deliverables for this project are: - Underwriting model for a multi-family property - Multipl...

I'm having a tough time with my powerapp project and need an expert to step in....project and need an expert to step in. There are some crucial issues that need to be fixed quickly. These include: - Data not saving properly - Difficulty in integrating external APIs - Improving formula optimization I've attempted to save multiple screens to PDF and email it, as well as search for employees in my organization but am currently failing. This work needs completion ASAP. Therefore, I am seeking a freelancer who understands powerapp projects and their workings, down to the smallest detail. Your expertise in correcting data saving issues, integration of APIs and mastery of formula optimization will be crucial to get this project completed successfully. If this is your ...

I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the valu...incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the ...

I'm seeking a proficient individual in descriptive statistics. The primary tasks include: Data Types: - The data I'm working with is a mix of numerical and categorical data. Requested Descriptive Statistics: - I specifically need help with calculating the Mean and Median. Purpose: - These statistics are crucial for a research paper I'm working on. Ideal Candidate: - Proficient in descriptive statistics - Experienced with both numerical and categorical data - Previous experience in data analysis for research papers is a plus. Please let me know about your experience with these kinds of tasks. Thank you.

...adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dosage guidelines to the successful bidder for reference. The ideal candidate needs to have a keen ey...

I need assistance with calculating the correct motor size and torque requirements for an industrial application. Key Job Details: - Use your expertise to analyze the load the motor will need to move. - The ideal motor should be able to handle the load efficiently and effectively. - I'll need detailed calculations (with reference) to be shared at the end of the project. Preferable Skills: - Experience in industrial machinery - Expertise in motor sizing and torque calculation. The motor will operate in a standard factory environment, moving a load that is constant and predictable. I would appreciate it if you could provide examples of similar projects you've worked on in the past. Attached is a similar project example.

...Python - Proficiency in Python libraries such as Pandas, NumPy, and Matplotlib If you have a solid background in data analysis and Python, and are able to create efficient, clean, and well-documented code, I'd like to hear from you. Here are details- I have to create a simulation that will find the optimal solution to go around a circuit using the least amount of power in a given time, by calculating the forces acting on the vehicle at any point. The forces have been identified to be: Drag, Rolling resistance, Incline, Wind & Motor thrust. Rolling resistance, wind (set to 0 in data should be okay to plug values in later) and incline forces have been resolved in an excel file for every data point (every metre). Drag and motor thrust which depend on the current velocit...

I am looking for an experienced accountant to assist with our monthly bill amount. We want experience accountant to help with calculating and dividing up our yearly invoice into 12 months. The yearly amount is there but we want a skilled accountant who can divide the amount up to 12 months with each month amount figure being different from the other. For example, dividing $100,000 by 12 months but each month has a different amount but the the total of 100k is still the same. Ideal Skills: - Proven experience in accounting - Knowledge of relevant accounting software - Strong attention to detail - Effective communication and reporting skills

I'm seeking an Airtable expert to assist me with a number of tasks, including data entry and organization, building custom workflows, and creating advanced formulas. Ideal candidates should have: - Previous experience working with Airtable, including data entry and organization, workflow creation, and complex formula design - A strong understanding of how to make the most of the tool, including its integrations and automations Please note that while my exact requirements in terms of the number of tables and views in my Airtable base, as well as specific integrations I need, have not been stated, I expect the freelancer to be able to adapt to my needs and work in an agile manner.

...right excel Guru can probably figure this out in less than an hour. Easy money. The first formula is related to searching a cell for one of four words and populating an adjacent column with a correlating value, based on the word found. The four words to be searched for are "Low", "Medium", "High", and "Not currently a priority". The adjacent cells are to be populated with correlating values 1, 2, 3, and 0 (to generate a Score). The cells are currently blank, and users of the spreadsheet will fill these cells by selecting from a drop-down list (of these 4 words). The objective is to create a formula that converts their answer (in one cell) to a score (in an adjacent, hidden, cell). The second formula involves summing (adding)...

Experienced Programmer for TradingView We are seeking an experienced programmer to assist us in the further development of our very complex TradingView programming. Your primary goal will be to refine the displayed trading signals by calculating the points (profits or losses) and graphically displaying them in the chart (e.g., "this signal would have yielded 45 points") based on the closing price of the respective signals.

I'm encountering issues converting Excel formulas to Google Sheets, particularly with the VLOOKUP function. The problematic formula in question is central to my data analysis processes. I need a professional who can troubleshoot and effectively convert these formulas to be compatible with Google Sheets. Key Tasks: - Identify the source of the "IFERROR" error in the VLOOKUP formula as it functions in Google Sheets. - Modify the formula for accurate results in Google Sheets, ensuring it retains its original functionality post-conversion. Ideal Skills and Experience: - Proficient in both Excel and Google Sheets formulas and functions. - Strong experience with VLOOKUP and IFERROR. - Ability to troubleshoot and adapt formulas across different spreadsheet pl...

I need a mathematician to solve a number sequence and provide a formula so I can generate the next iteration of numbers as high as I can go.

I need assistance with performing formulas, calculations and descriptive analysis in Ms Excel. I am specifically focused on analyzing data using measures of central tendency - mean, median and mode. - **Tasks** - Insert and calculate f...descriptive analysis in Ms Excel. I am specifically focused on analyzing data using measures of central tendency - mean, median and mode. - **Tasks** - Insert and calculate formulas regarding the mean, median, and mode in the data. - Conduct descriptive analysis on the dataset. Ideal freelancers for this project should have strong analytical skills and extensive experience with Excel's formula and calculation functionalities as well as knowledge of statistical analysis. An understanding of central tendency measures (mean, median, mo...

Seeking a proficient individual who is knowledgeable in Excel for data entry and calculation formula tasks. The project involves: - Manual data entry - Creating complex formulas - Maintaining a spreadsheet with 10-50 columns and rows Ideal skills and qualifications: - A high degree of precision and accuracy in data entry - Strong knowledge of, and experience with, Excel and its formulas. I would like my 24 month forecast converted to an excel spreadsheet so i can adjust inputs and project further.

...validation and verification tasks in Microsoft Excel and help with managing payroll. Key Responsibilities: - Data Validation and Verification: This involves assessing the data's accuracy, completeness, timeliness, and consistency. Proper validation ensures that our records are reliable and correct. - Payroll Management: This task involves ensuring that all employees are paid correctly and on time, calculating wages, tracking work hours, and making necessary deductions. Experience in payroll systems or software is a plus. Ideal Skills: - Proficiency in Microsoft Excel - Experience with data validation and verification - Previous payroll processing experience - Attention to detail and accuracy in data entry - Strong organizational and time management skills The successful c...

I'm looking for an experienced professional to create a user form macro in MS Project Professional. The macro should have t...functionality that the macro should have is the ability to filter the project based on selected criteria in the user form, including: - Project Phase: This is a custom field, or Text1 - (And) Work Phase: This is a custom field, or Text6 - (And) Custom Look-Ahead Formula's for 15, 30, & 60 day look-aheads. See attachment but the end user will select one of the three look-ahead options. For the Look-Ahead formula, it should be defined as: IIf(([Start]<([Status Date]+15, 30, or 60) And ([% Work Complete]<100))). It's extremely critical that the candidate has strong proficiency and understanding of MS Project macros, logical formulas,...

I have a real estate development company, and I'm looking for a dedicated Excel expert to help me streamline my expense tracking process. Key Requirements: - I already have a template set up and in one of the tabs I have a CSV statement import. Your primary task will be to create a formula that can automatically pull data from a statement import into the relevant property tab. - The data should be ordered by date to ensure clarity and easy reference. - I have created a macro to change the debit figures to negative amounts in the spreadsheet. - I am open to changes/ideas on if it requires a different setup. Ideal Skills and Experience: - Advanced Excel skills are a must. You need to be comfortable working with complex formulas to manipulate data. - Experience with real est...