Macro calculations jobs

I'm in need of a professional who has mastered the Excel 2016 with a strong focus on VBA scripting. The individual should have: - Proficiency in financial modelling using VBA. -Option Future calculations P&L of portfolio.

I'm looking for an experienced licensed residential architect to help me with an addition and rehab to my home. The specific scope of the project consists of a garage expansion and rework roof, master bathroom addition, and a l...rework roof, master bathroom addition, and a lanai addition. I'm looking for someone who has knowledge of local building codes and is experienced in producing drawings (we have an ACAD floor plan drawing of what we want) for permit application submission. The successful candidate will need to be able to accurately estimate the cost of materials and labor, and have familiarity with structural calculations. Service provided in a timely manner is appreciated. If you believe that you have the necessary qualifications and experience for the job, I'...

I require structural engineering services for a steel framed, modular, four-stall horse barn. The project includes the development of WCS lateral and vertical load calculations, foundation recommendations, and creation of CAAD drawings for submission to the county permitting office. This project should include: - Calculation and design package considering the barn's purpose for horses. - Detailed measurements based on given length, width, and height. - Include provisions for electrical lighting, outlets and a water tap. Ideal freelancers should have: - Extensive experience in structural engineering specifically for agricultural buildings. - Proficiency in the development of CAAD drawings. - Knowledge of permit application processes and building codes. - Capability to accommod...

I am looking for an experienced Qlik Sense freelancer with an eye for detail to assist in the data modeling and visualization of my project - Support needed Key Responsibilities: - Perform advanced analysis using Qlik Sense expressions and calculations - Generate visualizations based on the specific formats I have in mind Ideal Skills and Experience: - Proven track record in Qlik Sense data modeling and visualization - Experience with complex Qlik Sense projects and the ability to produce advanced analysis with expressions and calculations is a must - Flexibility and creativity to work with specific designs and also provide suggestions. Your ability to balance following my vision with offering your own unique suggestions will make you a successful candidate for this proj...

I'm searching for a developer who can help create a web-based certified payroll system. The main objective is to generate payroll reports for auditing purposes. The following features are essential to this project: • Employee Time Tracking: You'll need to design a system that accurately records and stores employee working hours. • Tax Calculations: You should be able to code a feature that efficiently handles tax calculations based on logged hours. • Automated Report Generation: You'll be responsible for creating a fully automated report generation feature for ease of auditing. As an ideal candidate, you should have experience in HR software development, and specifically, creating payroll systems. Your understanding of tax regulation and abilit...

...chargeable amount. Options to save, edit, and duplicate forms for efficiency. Subscription Service Integration: Implementation of a subscription model with login functionality and access to various features based on the subscription level. Export Functionality: Ability to export bids and calculator summaries to PDF and other formats. Technical Requirements: Robust back-end logic to support complex calculations and data management. Responsive and intuitive front-end design for an excellent user experience. Secure user authentication and data encryption to protect client information. Application should be scalable and capable of handling multiple users simultaneously. Your Responsibilities: Collaborate with our team to understand our requirements and workflows. Design and devel...

...gov/ArchiveCenter/ViewFile/Item/4571) . Existing conditions description (undeveloped - limited to topography). Drainage calculations. Description of stormwater BMPs. Vegetation establishment and management plan (recently logged - stumps remain, replanted saplings). Utilities description (none). Covenants, dedications, and easements (10' easement for hwy expansion - a designated stream bisects the lot has a buffer each side) . Operation and maintenance information. Property owners' association articles of incorporation (not applicable - residential). Other permits or conditions. Calculations for all facilities including current and proposed hard surfaces, new and replaced pollution generat...

I'm seeking help from a proficient Excel user who can create two essential templates for me: An invoice template and an expense tracker. For the invoice template, I require the following fields and calculations to be included: - Item description and quantity - Unit price and subtotal - Tax calculations - Grand total I'd appreciate it if macros could be incorporated where needed for automation purposes. For the expense tracker, it needs to categorize various business expenses including, but not limited to: - Food and drinks - Transportation - Office Supplies - Site local purchase expenses The ideal freelancer for this project would have significant experience in Excel, specifically in creating detailed, user-friendly templates for professional purposes. Pro...

I am looking for a Modelica expert to help me optimize the pressure drop calculations for a liquid system. Requirements: - Strong experience in working with Modelica - Proven track record in optimizing pressure drop calculations for liquid systems - Ability to work with input parameters such as flow rate, temperature, and viscosity - Understanding of fluid dynamics and thermodynamics The aim of this project is to create the calculations in a way that will optimize the pressure drop in our liquid system. Your role will be crucial in identifying inefficiencies and suggesting improvements. Please only apply if you have the mentioned skillset and experience.

More details: Do you want the calculator to be embedded within a specific page on your WordPress website or as a separate standalone application? No preference What functionality do you want the calculator to have? you can calculate financing and fill in your details when you're ready What specific financing calculations would you like the calculator to perform? car leasing

...Excel file with over 10 sheets. The tasks include: - Data Analysis: I need someone who can help me analyze the data in the file, looking for trends, patterns, and key insights. - Chart and Graph Creation: I also need charts and graphs to be created based on the data. These should be visually appealing and easy to interpret. - Formulas and Functions: The data file includes a lot of mathematical calculations. I need an expert in Excel formulas and functions to help me with this. Specifically, the type of data analysis needed includes statistical analysis, trend analysis, and comparative analysis. The ideal freelancer for this project would have: - Proficiency in Excel, including advanced knowledge of formulas and functions - Experience in data analysis and visualization - A back...

More details: We already have a excel workbook but need to improvise it and make it automated for calculations of XIRR, Investment Holdings, etc with monthly update of transactions User-friendly interface Intermediate to Advanced Skills required

More details: What specific data or information do you want to analyze in Excel? Financial data How do you prefer to receive the analysis results? Formulas What specific calculations or formulas do you need to perform in Excel? advanced & basic

I am looking for a proficient Excel VBA developer to create a macro that can automate sending payslips to employees on a monthly basis. Key Requirements: - The VBA code should be able to extract the pay information from an Excel spreadsheet and generate a PDF file with the payslip. - The generated PDF file should then be attached to an email that is sent to the corresponding employee. Ideal Skills: - Proficiency in Excel VBA, including the ability to work with PDF files - Experience with automating email sending processes - Strong communication skills to ensure the solution meets our needs. Please note that this project is specifically for creating the VBA code for the payslip emailing system - the design and content of the payslips themselves are already established. Looki...

...STRUCTURAL CALCULATIONS, and have STEEPLY SLOPE EXPERIENCE + REVIEW +++ PLEASE READ ENTIRE POST BEFORE SUBMITTING A QUOTE +++ !!!! FOUNDATION STRUCTURAL CALCULATIONS WILL BE NEEDED FOR BOTH BUILDINGS !!!! If you submit a fee, then increase it after we discuss, I will say goodbye to you!!!! **** ALL TASKS ARE STATED HERE ***** VIEW ALL ATTACHMENTS BEFORE YOU BID!!! +++ DELIVER DWG and PDF files in ARCH D 24" x 36" format, Scale is 1/4 inch = 1 foot +++ 1. CREATE TWO (2) NEW Foundation Plan with STRUCTURAL CALCULATIONS plus Elevations (in relation to land contour/slope), Section and Roof Plan with STRUCTURAL CALCULATIONS for 2(TWO) Buildings :: EACH drawing should have a Comprehensive Details Page, for example Foundation Plan shoul...

I am currently encountering an issue with a Python macro that is not performing as expected. I'm uncertain of the actual problem, but I believe it's a simple one. Despite no recent alterations made to the macro, it is not running properly and it's impacting the overall function of my program. - The Task: The primary task is to diagnose the specific issue troubling the proper functioning of this Python macro, and subsequently implement the necessary corrections. - Macro Function: Though I am uncertain of the exact problem, the macro's primary function is to perform data manipulation operations, which aren't being successfully executed now. Ideal Skills: - Proficiency in Python - Prior experience in diagnosing and fixing issues relate...

Calculate the total cost for each client using a fix rate and a waterfall method, from a large data set of clients. Explain each step of the process (the applicability of each formula) so anyone can replicate the calculations. All the detailed requirements are provided in the first tab. More details: What are the specific data points for each client that need to be considered in the calculation? Revenue What format is the client data currently in? Excel spreadsheet Do you require a step-by-step guide included within the same Excel file, or should it be provided in a separate document? Within the same Excel file

...experienced professional to provide data entry, copy pasting, excel work, typing, and processing of word documents. While the main focus is text data handling, a variety of other computer-related tasks may also be assigned. I Need: - Data entry: Inputting text data into a preferred system - Copy paste: Replicating and transferring data from various sources - Excel: Managing data and performing calculations or analysis if needed - Typing: Creating or editing text documents - Word document: Crafting and managing Word files effectively - Other: Additional tasks relating to computer skills Ideal Candidate: - Experienced in data handling tasks - Proficient in using Microsoft Excel and Word - Strong typing skills Freelancers should highlight their relevant past experiences and the...

I'm seeking a proficient and detail-oriented freelancer to execute a critical cleanup process on my Excel spreadsheet encompassing 1000 lines of data. This role requires the incumbent to perform the following tasks: - Sorting and filtering Name, Date, Number, Price, and Uber data fields - Identifying and executing operations on specific calculations – particularly focusing on sums The ideal freelancer should possess outstanding Excel literacy and a keen attention to detail. Proficiency in data management with an ability to identify trends, anomalies or data discrepancies is also crucial. Prior experience with similar tasks will give candidates a competitive edge.

I have a complex data set that includes sales, financial, and social media data, and I need a Power BI expert to create a series of visualizations for me. Your primary task will be to translate this data into easy-to-understand visual representations. I'd like to be able to filter the data by date, drill down into specific categories, and create custom calculations on the fly. You should aim to create a mix of different types of visualizations, including bar charts, pie charts, and line charts. Your final deliverable should be a comprehensive Power BI project that seamlessly presents and interacts with the data. Ideal skills and experience for this job include: - Proficiency in Power BI - Strong understanding of sales, financial, and social media data - Experience with cr...

I have a need for a skilled Pine script developer to develop an automated script for my TradingView platform. The script must be capable of advanced operations like multi-timeframe strategies and complex calculations. Desired Skills & Experience: - Proficiency in Pine programming language, with a specific focus on automation scripts. - Comprehensive understanding of TradingView's functionality and how Pine scripts interact with it. - Extensive experience in developing advanced operations such as multi-timeframe strategies and complex calculations. - Excellent analytical skills, with the ability to understand and outline trading strategies. - Diligence in testing and debugging to ensure the effectiveness and reliability of the script. I use trading view and use 2 i...

Please Sign Up or Login to see details.

The project is an excel test. The attached file contains the test. It requires medium level skills. All the details are in the file More details: What specific calculations do you need to perform in Excel? Formulas to consider using - IF, VLOOKUP, SUMIF, SUMIFS, INDEX How familiar are you with using Excel formulas? Intermediate (comfortable with commonly used formulas) Which Excel features beyond basic formulas are you interested in incorporating? Pivot Tables, Conditional Formatting

...boiler venting, fire suppression hoods, and more. Responsibilities: - Conduct takeoffs from blueprints and HVAC drawings to accurately estimate costs. - Generate detailed submittals for review and approval by clients and regulatory authorities. - Produce sketches and technical drawings for mechanical systems, including boiler venting, fire suppression hoods, ductwork layouts, etc. - Perform calculations and analysis to ensure mechanical systems meet performance standards and safety regulations. - Stay updated on industry trends, codes, and standards to ensure compliance and innovation in design. Requirements: - Bachelor's degree in HVAC Mechanical Engineering or related field. - Proven experience in performing takeoffs from blueprints and HVAC drawings. - Proficiency in CA...

I'm looking to build an ecommerce website specialized in electronics featuring a range of modern functionalities. Key needs include: - A robust product search and filter system, enabling customers to navigate my inventory easily. - A seamless shopping cart and checkout system, creating an effortless buying process. -...guidelines, I am open to suggestions that will make my site user-friendly and appealing. The ideal candidate for this project should have extensive experience in ecommerce website development, preferably with a portfolio of previous electronics or similar sites. Skills in UI/UX design and familiarity with different payment gateways would be highly advantageous. A clear understanding of shipping calculations and the ability to integrate this mechanism into the ...

I am seeking a knowledgeable expert in Azure files, AVD and Azure Active Directory to help me overcome specific challenges. These obstacles include accurate licensing cost calculations and guiding in configuring this service to work effectively within my project. As the ideal consultant for this task, you should: - Have significant experience with Azure Active Directory configurations. Evidence of previous projects in this area will bolster your application considerably. - Demonstrate a keen understanding of software licensing costs and pricing structures related to Azure services. - Be an experienced troubleshooter, capable of identifying and rectifying issues promptly and efficiently. In your application, please focus primarily on your past work - particularly projects involvi...

I have a excel of Maharashtra PT it has all macros and all i am able to use it but its outcome from excel the text file am not unable to find

Hello my friend, How are you? I saw that you did some work on helping a few people create stories/books! you are a multi talented person! I have a couple of questions I and things I am working on and would like to know if it may be something you are familiar with? What is the best way to share this info and documents with you? The website wouldn't let me direct message you so I have...have a couple of questions I and things I am working on and would like to know if it may be something you are familiar with? What is the best way to share this info and documents with you? The website wouldn't let me direct message you so I have to do it this way. Ignore the budget amount that I had to enter. The project would have a time deadline and will require some research and potential ...

...- Product catalog: I need a user-friendly interface where I can display and categorize my window products. - Pricing: It needs to be set up to make sure the calculations for individual items work within the background of the website from pricing files that I can provide. And has a portal or something where we can update prices later on - Shopping cart: I want customers to be able to easily add items to their cart and complete the checkout process. - Payment gateway integration: The site should be able to accept payments through various methods. * It’s critical to find someone that will be able to set it up to make sure the calculations for individual items work within the background of the website from pricing files that I can provide Ideal skills and experience fo...

I'm looking for a proficient Excel expert to input specific data related to vehicle usage. I require: - Entry of different variables such as text, numbers, dates and importantly, vehicle...I require: - Entry of different variables such as text, numbers, dates and importantly, vehicle numbers. - Compilation of extensive reports on vehicle usage, specifically focusing on the weight each vehicle carries. The perfect candidate for this job should have: - Strong Excel data entry skills. - Excellent attention to detail. - Capability to handle large datasets and ascertain precise calculations. - Prior experience in logistics or transport sectors will be an added advantage. If you have these qualifications and can deliver precise, error-free work, you are just the expert I need fo...

As the client, I'm seeking a skilled developer to build a replica or use similar template to this online tombstone configurator (). Key Features: - The tool must be entirely customizable, with capabilities for pricing calculations and visual rendering. - It must allow users to select customizable options, render them visually and generate an accurate final request Design and Branding: - The design must incorporate pre-existing branding, including our logo, colors, typography, font styles, images, and visual assets. A high level of attention to visual detail is therefore essential. Potential Integrations: - Please note, the tool might require integration with external APIs or systems. Hence, proficiency in both possibilities

I am looking for an Excel expert who can set up automation for specific tasks and create custom formulas based on my requirements. Key Requirements: - Automation of specific tasks: I need to reduce manual work and save time by automating repetitive tasks. - Custom formulas: I need new formulas developed to perform calculations and analysis that are not covered by Excel's standard functionality. Autocalculation Trigger: - I want the autocalculation to be triggered every time the Row is highlighted with sold green color. I have ten different columns with hundred of rows with specific beginning text "spect". When user fills a background color assume its solid green on a cell of a particular column the function should autocalculate the complete column and report the ...

1 - Preparation of accurate and complete Order of Cos...including dimension checks and professionally handling of issues, gaps and inconsistencies in information ---- 4 Accuracy and professionalism in the presentation of coloured drawings/ diagrams and related annotations to support the waste calculations 5 A complete and accurate setting down of dimensions (quantities) and descriptions of relevant building works using standard dimension paper. This should include proper use of traditional measurement conventions, accuracy and completeness of quantities and item description supported with appropriate waste calculations in accordanceto NRM2 and industry practice. 6 Overall presentation of the Measurement exercise - The structure, clarity andprofessionalism in the presenta...

...in need of an experienced drafter to create engineered deck plans for my large, over 200 sq ft lake cabin in Idaho. The deck lies on a slope of about 30 degrees. I don't need fancy "eye candy" drawings. Just buildable plans that will satisfy the building departments requirement for this deck to be engineered. Here's what I need from you: - Create a detailed drawing that includes load calculations, connection details, and footings and posts details. These should be detailed enough to satisfy my local building department. The building department wants "engineered" plans so I'm guessing that requires an engineers stamp on the plans. - Demonstrate expertise in deck construction, particularly on sloping terrain. - Knowledge and experience wo...

I am urgently in need of a freelancer to help with my personal tax return. I would like you to take care of all the necessary calculations, paperwork and ensure that I am compliant with all relevant tax laws. In order to apply for this project, you should have: - Proven experience in personal tax return filing - Good knowledge of tax laws and regulations - Ability to work efficiently and meet strict deadlines Given that I need this completed ASAP, please only apply if you are able to start working on this project immediately. Thank you. Here's the video: I want to make it clear that pay hinges on your ability to get me a refund using the process described in the video so do not expect any pay until the expected refund is processed. If you're

I require a software designed specifically for Windows that contains a betting calculator functionality. The primary need of this project is to calculate multiple bets as per the updated statistics. This software will be designed for cricket betting which makes it critical to have a focus on accuracy and speed in real time calculations. Ideal Skills and Experience: • Expert in Windows software development. • Familiarity with the betting industry, particularly multiple bets. • Experience with sports statistics, especially cricket. • Strong focus on detail ensuring up-to-the-second accurate results. • Swift delivery without sacrificing software quality.

...time-sensitive task, requiring both speed and accuracy. Please, only serious and dedicated freelancers should consider this project. Job Description: There are 2 sets of tables, Soccer and Basketball for my analysis during my free time. 1. The links are in the spreadsheet highlighted in yellow. The script must also be easy to understand and allow me to add new tables in the future. 2. Create a macro that will extract the table from each of the links and into Excel. Because the table statistics change every day, currently, I copy and paste manually, so I want to automate it. 3. The details start from the R - Team row. 4. Compulsory for basketball to extract data in Columns B to J, and for Soccer Columns B to I 5. Only programmers with successful scraping demos will be consi...

Comparing 3 files and performing calculations on it and getting CSV output

I'm in need of an expert in Excel to create a spreadsheet that will automate data entry, perform calculations, and generate reports. The complexity isn't clear yet, as I'm unsure how many different tasks will need to be automated. The suitable candidate should have: - Proficiency in Excel, including advanced features - Experience with automation within Excel - A good understanding of data entry, calculations, and report generation I'm open to a dialogue to specify the details further. On the first tab in Excel, I'd like to have all the individual contributors. Then have a tab after that for each individual to show their trends over the months. Anything over 95 is considered good and below 95 would be not good. There are 15 contributors at this mom...

Develop macro to generate Word docs

I am looking for an experienced freelance to convert my past year's Profit and Loss statement into a fully itemised budget for th...projection data on the historical records from the P&L statement - Breakdown of expenditure must be category-wise - Incorporation of a pie chart visualising the budget details Considering the urgency of this project, I require the final product within the next 12 hours. Ideal Skills: - Excellent understanding of financial document analysis - Proficiency in using Excel including complex formulas, calculations and data visualisation - Proven ability in formulating budget plans - Exceptional attention to detail - Ability to work under tight deadlines Please present evidence of previous similar projects you've completed. Looking forward ...

...construction planning purposes. This project will involve using your technical knowledge and expertise of steel lintels to provide accurate and reliable calculations that would guide our construction efforts. Suitable candidates should possess: - A strong background in structural engineering - Proven experience with steel lintel calculations - Knowledge of construction planning and procedures - An ability to provide accurate, dependable results in a timely manner. Your responsibility will be to perform and deliver precise structural calculations to ensure our plan follows correct engineering principles and standards. Your insights and calculations will play a crucial role in the planning and executing phase of our construction process. Please only app...

I'm in need of a professional proficient in Excel macros to assist with creating custom formulas specifically for data manipulation. The primary task would be to formulate macros that can effectively merge and separate data. Demonstrable experience in managing large datasets and solid knowledge in automated data manipulation will be essential for successful completion of the project. A background in eliminating duplications or inconsistencies would also be advantageous. I look forward to a hassle-free process and accurate results.

I'm in need of a seasoned spreadsheet data designer who can handle advanced formulas and calculations for a drug pricing file. The data will be sourced automatically from an external database, so experience with data integration is crucial. Key Requirements: - Setting up complex formulas and calculations - Expertise in working with automatically sourced data - Understanding of dynamic pricing models and complex algorithms The ideal candidate for this project should be able to create a dynamic and user-friendly spreadsheet that can handle complex data sets from external sources. The end goal is to have a pricing tool that can adapt and update based on real-time data. Experience in the pharmaceutical industry or similar fields would be a plus, but not required.

...what I need: - Development of a reliable Excel macro that can accurately identify and extract the necessary data from .dl files. - The macro should be robust enough to handle any inconsistencies or errors within the .dl files. In the event of an issue, rather than stopping entirely or skipping the file, the macro should create a log file noting the inconsistency or error for later review. Ideal skills: - Experience in Excel macro development - Familiarity with .dl file structure - Attention to detail - Problem-solving skills, particularly regarding file inconsistencies or errors - A background in data extraction would be highly advantageous If you think you can handle this kind of task, I would be interested to hear from you. The macro does not...

I'm in search for a professional well-versed in Google Sheets, specifically with the capability to execute and manipulate custom complex functions. You will be dealing with a medium sized dataset of 100-1000 rows. Key tasks include: - Implementing advanced formulas and calculations to an existing google sheet - Analyzing and providing visual representation of data in real time The ideal candidate should be proficient in data analysis, has excellent skills working with sizable datasets, and is a master of working with custom functions within Google Sheets. Your ability to interpret data and present in a user-friendly format will be essential.

...Pinescript and TD Ameritrade's Thinkscript would be beneficial. - In-depth understanding of technical analysis is required, as the scripts involve custom functionalities. Being able to correctly interpret and implement these concepts is vital. - Knowledge in dealing with trading indicators and creating custom functions/indicators within these scripting languages. Strong understanding of mathematical calculations and algorithms is an added advantage. - Excellent problem-solving skills for handling any complexities that might emerge during code conversion. - Fluent English to ensure clear and efficient communication throughout the project. The job will be considered successful when the converted scripts in Pinescript perform identically to the original Thinkscipt versions, an...

...and street address for each client. - Sort the listing according to proximity, with only latitude and longitude coordinates information. - Design the spreadsheet to be intuitive, easy to use, and update. The ideal freelancer for this job should have: - Proven experience in data organization - Excellent knowledge in geographic systems - At least basic understanding of latitude and longitude calculations. The end goal is to have a clear, concise, and accurate spreadsheet of all our clients organized by location. This is to help improve both internal operations, and our ability to serve our clients. We do not have the latitude and longitude coordinates in the spreadsheet. Our business requires our clients to use our service once a year in the same month as the previous year. So...

...to help complete the structural engineering on a 3000 square foot commercial building that will be used as office space. I am a building designer and the design is complete and ready to engineer. My usual engineer is booked and then going on vacation and I need to get this project done on a fast timeline. Key responsibilities will include but are not limited to: - providing structural calculations, sizing structural components, assigning fasteners and connection hardware.... - providing certified stamp for permitting Skills and experience needed: - Proven experience in commercial office building projects - Expertise in architectural principles and technology - Proficiency in engineering software Please note, immediate availability is a must given the urgent nature of t...