这是老师要求我们答题的格式Formula Variables Calculation Result Answer(words) 其他的要求主要还是看那个要求表吧~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
...on the Shopify platform. Key Features: The calculator should give price estimates based on the pickup and delivery locations. It should calculate pricing based on the distance between the locations. Price Quote Calculation Formula: Price Quote Parameters: Base Delivery Fee: $40 (This is the starting cost for the delivery, no matter how far it is). Base Miles: 5 miles (These are the miles included in the Base Fee with no extra charge). Additional Fee per Mile: $1.95 (For any distance beyond the base miles, there’s an extra charge per mile). Price Calculation Formula: If the distance is less than or equal to the base miles (5 miles), the price stays at the Base Fee. If the distance is more than the base miles, we calculate the extra cost for the additional miles:...
...SuperTrend. The AFL will list out all stocks as BUY when Supertrend is GREEN and the price has closed below the rounded price as explained below. The AFL will list out all stocks as SELL when Supertrend is RED and the price has closed above the rounded price as explained below. Inputs Required: - SuperTrend inputs required. Default is 14 and 3. - Time Frame - Current chart time frame. - Rounding Factor input required. A factor of 1 means, For BUY the AFL will add 1 to the current supertrend value and will round off to the next higher round figure. If supertrend value is 279.13+1=280.13 which will be rounded off to 281. The AFL Exploration will list out all the stocks as BUY when supertrend is Green and the recent bar has closed below the rounded figure. Fo...
Excel Data Cleaning: Removing duplicates, errors, and inconsistencies for accurate analysis. Excel Data Formatting: Organizing data into a clear and professional layout. Excel Dashboards: Creating interactive and visually appealing dashboards for data visualization. Excel VBA: Automating repetitive tasks and creating custom macros to save time. Pivot Tabl...forecasting, and performance tracking. Excel Templates: Designing reusable templates for recurring tasks. Data Consolidation: Combining data from multiple sheets or workbooks. Excel Integration: Connecting Excel with other tools or databases for seamless workflows. What-If Analysis: Using tools like Scenario Manager and Goal Seek for scenario planning. Error Troubleshooting: Identifying and fixing formula errors or inconsistencie...
...linked by employee ID. - The summary and allocation detailed report should be in Excel format. - Total earnings is calculated as: Gross Benefit + Worker Compensation + Net Salary. Gross Benefit is the total of all benefits in the salary master file from columns R to AV, excluding Federal Income tax, California Amount, and California SDI. Option to add inclusion or exclusion without changing formula. - The bi-monthly payroll needs to be consolidated from two lines per employee to one line summary report. - Class allocation percentages should be sourced from the class columns E to VU in the class allocation sheet, and must total 100%. Ideal skills and experience for this job include: - Proficiency in Excel, especially in data analysis and manipulation. - Experience with payroll ...
I'm in the animal care industry and need a comprehensive Excel calculator to help me evaluate labor costs against revenue. Specifics: - The calculator should focus on tasks related to daycare and boarding. - It needs to track labor hours, the number of animals cared for, and the cost per employee. Ideal Skills: - Proficiency in Excel with advanced formula knowledge. - Experience in the animal care industry is a plus. - Ability to create user-friendly, intuitive spreadsheets. The goal is to have a tool that helps me make informed decisions about staffing and pricing based on labor costs and revenue from these services. It needs to be easy to use. Daycare pricing is set at $42/day and 35/half day and boarding at 65/night and labor is $20/hr. I would like to only have to ent...
I'm a 17-year-old aspiring game developer seeking guidance and collaboration on creating a 3D racing game using Unreal Engine. The game will be inspired primarily by Mario Kart, with elements from various popular racing franchises. Key Aspects: - **Game Design**: The core design will be reminiscent of Mario Kart, but with creativity to incorporate elements from Formula 1, Need for Speed, Grand Theft Auto, and F-Zero. - **Track Development**: You'll help me design and create various tracks based on iconic designs from the aforementioned games. - **Modeling**: We'll need to develop and implement character models and kart designs inspired by Mario Kart. - **C++ Guidance**: As a beginner in C++, I'll need your expertise and mentorship to help me improve my skills wh...
...If cannot produce 10, search in a larger area in increments of 50 miles. For example, 50 miles, then 100 miles, then 150 miles from area code, etc. This can be achieved by online searching utilizing our most popular car listing websites. For example, , , craigslist, Autotrader, etc. This is a key step in my application and is a required feature for my vision. This alone makes my formula different from other auto appraisal applications. 5. A vehicle conditions report. This can be achieved by a section of the customer's fill-out form asking about their car's condition in the following: interior 1-10, ten being perfect, one being destroyed. Paint, mechanical, glass, tires, headliner, seats, carpet, and dash panel. All required fields for the appraisal. 6. Appraisal Repor...
...tailored to our business needs. You will be responsible for designing, implementing, and testing applications, ensuring they integrate smoothly with our existing systems. Collaboration with our team is essential to deliver valuable solutions. If you have a passion for problem-solving and a track record of successful Power Apps projects, we want to hear from you! You will be taking an existing Excel formula spreadsheet and converting it into a portal for external access. Consideration of the following is essential: Features of Power Apps Portals External User Access: Power Apps Portals are specifically built to provide external users access to select data and capabilities within a custom application, without requiring them to have a full user license for Dynamics 365 or Pow...
I'm seeking a proficient Excel specialist to consolidate multiple spreadsheets into a comprehensive master template. The current spreadsheets contain real estate tracking data and your task will i...task will involve: - Merging data on property values, insurance replacement costs, and financial statement information. - Implementing key formulas to facilitate future analysis. This includes: - Sum totals for each category - Average values across properties - Percentage changes over time The ideal freelancer for this project should have advanced Excel skills, particularly with formula implementation and spreadsheet consolidation. Experience with real estate data would be a significant advantage. Please ensure that the master template retains all necessary formulas f...
...Selection: The user can choose between three fixed hook options. Each hook option will have a fixed price. Summary Box: A summary box should display all the selected options, showing a breakdown of the customized frame and the associated prices. Dynamic Price Calculation: The price should be dynamically updated based on the user’s selections (support, frame, passepartout, hooks, etc.). The pricing formula should include: Support + Outer Frame + First Passepartout + Second Passepartout + Second Frame + Front Part + Back Part + Hanging Hooks. Image Generation: The final product preview image (including all selected components) should be generated dynamically. The uploaded image should be cropped and adjusted according to the selected dimensions. A schematic with the produ...
Excel Data Cleaning: Removing duplicates, errors, and inconsistencies for accurate analysis. Excel Data Formatting: Organizing data into a clear and professional layout. Excel Dashboards: Creating interactive and visually appealing dashboards for data visualization. Excel VBA: Automating repetitive tasks and creating custom macros to save time. Pivot Tabl...forecasting, and performance tracking. Excel Templates: Designing reusable templates for recurring tasks. Data Consolidation: Combining data from multiple sheets or workbooks. Excel Integration: Connecting Excel with other tools or databases for seamless workflows. What-If Analysis: Using tools like Scenario Manager and Goal Seek for scenario planning. Error Troubleshooting: Identifying and fixing formula errors or inconsistencie...
I'm experiencing logical errors in my AFL code, specifically with indicator calculations. The code involves Moving Averages. I need an expert to help me debug it. Ideal Skills and Experience: - Proficient in AFL (Amibroker Formula Language) - Strong understanding of Moving Averages - Excellent debugging skills - Experience with trading strategy implementation and signal generation
...chemist to help calculate the vibrational characteristics of various compounds, such as OSR (Emeramide, NBMI). This research project will delve into different regions of the spectrum, including visible light, Raman, and potential low-frequency vibrations. Key Tasks: - Select appropriate software for the task. - Develop a suitable process (potentially a script) for analyzing any substance given its formula and structure. To be considered for this project, you must demonstrate: - Your expertise in computational chemistry. - Your proficiency with the software you're planning to use. Fields of Interest: While there are no specific compounds or spectrum types set in stone, a focus on organic compounds and the Raman spectrum could be beneficial. The key outcomes of this analy...
I'm seeking assistance with comprehensive data analysis in Excel, as well as generating reports and creating formulas. The job also involves sending multiple email attachments via Gmail. Ideal skills and experience for the job: - Expert level proficiency in Excel, particularly in data analysis, formula creation, and report generation. - Experience in managing and sending multiple email attachments through Gmail. - Strong attention to detail and ability to work efficiently.
I'm looking for a skilled PHP developer with Android expertise who can integrate a specific formula for calculating pathology test result value based on another test value into my existing custom-built system. This project involves both a PHP portal and an Android mobile app. Key Requirements: - PHP development for the portal - Android app development - Integration with a custom-built system - Understanding of mobile app development principles - Experience with backend system integration
I'm seeking an Excel specialist to help me create a sophisticated dashboard and tracking tool for compliance data. Key Resp...tool for compliance data. Key Responsibilities: - Automating processes with macros to streamline compliance tracking - Assisting in the design and development of a user-friendly dashboard - Automated email system which track the due dates and triggers the email to the respective email addresses. Ideal Skills: - Proficiency in Excel with a strong focus on automation - Experienced in complex formula creation and data analysis - Prior experience in designing dashboards and tracking tools - Familiarity with compliance tracking is a plus Please provide examples of previous Excel projects you've completed, particularly those involving dashboard crea...
I'm looking for a meticulous QA tester to evaluate my website. Areas for Testing: - User interface: The design and layout should be checked for consistency and usability. - Functionality: All features and functions need to be tested to ensure they work as intended. Device ...computers, mobile phones, and tablets. Browser Compatibility: - The website should be tested on the following browsers: Google Chrome, Mozilla Firefox, Safari, and Edge. Ideal skills would include experience in comprehensive web QA testing, attention to detail, and familiarity with cross-platform and cross-browser testing. Test all the formula conversions, to make sure this is checked in depth, I have intentionally left a conversion working inaccurate formula which I will expect you to detect ...
I need an experienced Excel expert to correct errors on my existing timesheet salary calculator. Skills and experience required: Strong proficiency in Excel, experience in financial modelling, and familiarity with creating interactive and automated Excel sheets.
I'm seeking an expert in Apple Numbers to assist in constructing some formulas on a spreadsheet. The primary focus will be on sales calculations, specifically profit margin assessments. Ideal freelancer should have: - Extensive experience with Apple Numbers - Proven track record in formula creation - Strong understanding of sales calculations - Excellent analytical skills to ensure accurate profit margin calculations.
I'm looking for a meticulous QA tester to evaluate my website. Areas for Testing: - User interface: The design and layout should be checked for consistency and usability. - Functionality: All features and functions need to be tested to ensure they work as intended. Device ...computers, mobile phones, and tablets. Browser Compatibility: - The website should be tested on the following browsers: Google Chrome, Mozilla Firefox, Safari, and Edge. Ideal skills would include experience in comprehensive web QA testing, attention to detail, and familiarity with cross-platform and cross-browser testing. Test all the formula conversions, to make sure this is checked in depth, I have intentionally left a conversion working inaccurate formula which I will expect you to detect ...
Fetching token prices of token lists and displaying arbitrage opportunity based on Arbitrage profitability formula
I'm looking for a skilled Excel professional to help automate my spreadsheet, which I've been manually updating with annual measurement data (3D coordinates). The spreadsheet involves regression analysis and generating charts. Key tasks that need automation: - Updating formulas: Currently, I have to re-input the formula to accommodate the new data each year. - Data input: I want it to be as simple as entering the new data and the spreadsheet updates itself. - Chart generation: The spreadsheet produces various charts from the data, which currently requires manual intervention. - Running regression analysis: The spreadsheet includes regression analysis which needs to be automated as well. Ideal skills for this project include: - Proficiency in Excel, especially with comple...
I need assistance with an Excel formula that's getting an error. I'm trying to get a cell to populate with the next date, but I need it to ignore certain instances. I am unsure which specific lookup function I am using. - Ideal Skills: Proficient in Excel, experienced in complex formula creation and troubleshooting. - Experience: Prior experience with date manipulation in Excel is preferred.
I'm seeking an Excel expert to assist with my spreadsheet. I need help with creating and modifying formulas, writing VBA scripts, and troubleshooting existing issues. The spreadsheet has some minor discrepancies that need to be corrected to enhance data accuracy and improve the user interface. Ideal Skills: - Advanced Excel skills - Proficiency in writing and modifying VBA scripts - Strong troubleshooting skills - Experience with data accuracy improvements - User interface design skills in Excel The goal is to tighten up the spreadsheet, improve its performance and make it more user-friendly.
...expert to update my Excel dashboard. This dashboard is currently used for reporting the daily status of equipment. The update should streamline the process, making it faster and more convenient. Key Tasks: - Revamp the Excel dashboard to improve its efficiency - Incorporate equipment status and availability as primary data points - Ensure the new setup accommodates future needs - Due to much formula, the sheet is slow to navigate Currently, I manually input the status and availability of equipment into the dashboard. The updated dashboard should ideally reduce the manual workload and make the reporting process more efficient. Skills and Experience Required: - Proficiency in Excel, with a strong understanding of dashboard creation and management - Experience in designing Excel...
I have a set of 69 KPIs in an Excel sheet, spanning across 10 projects. I need a performance formula that will automatically provide the KPIs/projects status based on specific thresholds. It's important to note that some of the KPIs are negative metrics. In addition, I require an interactive dashboard for these KPIs. The entire project is in Arabic. Key requirements: - Devise a performance formula that can assess the KPIs/projects status based on predetermined thresholds - Create an interactive dashboard in Microsoft Excel - Understand and cater for negative metrics within the KPIs - Project is in Arabic, hence understanding or capability to work in Arabic is a plus Ideal skills and experience: - Proficient in Microsoft Excel - Experience in creating interactive dashb...
Designing and building the formula visualization for a scientific calculator. The calculator should be able to take input in the form of a free text formula and then visualize & modify the formula.
I'm looking for a talented designer who can create a modern and minimalist vector-based design for the packaging of my premium teeth-whitening charcoal toothpaste powder, "My Dream Smile". Key Elements to Highlight: - The product is 100% natural: This aspect needs to be visually communicated to resonate with health-conscious consumers. - The coconut-infused formula: This unique selling point should be emphasized in a creative and appealing way. Color Scheme: The packaging should incorporate a sleek and sophisticated color palette of Blue, Black, and White. Ideal Skills: - Proficiency in vector-based design software. - Experience in packaging design, particularly for health and beauty products. - Strong understanding of modern and minimalist design principles.
We are seeking an experienced Excel expert to assist in developing a dynamic and user-friendly Excel dashboard or summary tab f...seeking an experienced Excel expert to assist in developing a dynamic and user-friendly Excel dashboard or summary tab for our HR team. The project will involve leveraging pivot tables and other advanced Excel functionalities to create an interactive and automated reporting tool that provides clear insights into key HR metrics. The ideal candidate will have a strong background in data visualization, formula optimization, and dashboard design to ensure efficiency, accuracy, and ease of use. Our goal is to enhance data analysis and reporting capabilities, allowing the HR team to make informed decisions effectively. Delivery flexible but ideally within 2 ...
...Mileage: Allowance, Actual Mileage, Excess Mileage Charge Payment: Deposit, Payment Amount, Card Fee Outputs: Total Cost, Refund/Outstanding Amount Step 2: Excel Layout Design an Excel sheet with the following structure: Description Input Formula/Explanation Check-Out Date 01/10/2025 User input Check-In Date 01/25/2025 User input Rental Duration (Days) =B3-B2 Rental Type Daily/Weekly/Monthly/3-Month Dropdown using Data Validation Daily Rate $50 User input Weekly Rate $300 User input Monthly Rate $1,000 User input 3-Month Rate $2,800 User input Rental Cost Formula depends on rental type (see Step 3 below) Fuel Surcharge $30 User input Damages $100 User input (if applicable) Mileage Allowance (miles) 500 User input Actual Miles Driven 600 User input Excess Mileage Charge ...
I'm seeking an expert to help with my spreadsheet. The project involves formula adjustments and formatting changes, specifically applying conditional formatting. The ideal freelancer should be adept at adding new formulas and fixing existing ones.
Formula will be provided, salary must count according the formula provided. Work with ftp only.
...Woodlands Hospital DIMITRIJEVIC, EEE Love PharmD, Kim 3 The Woodlands Hospital HOFFMAN, FFF Taylor, Hong 1 The Woodlands Hospital HOFFMAN, FFF Bold RPhT, Jeany 12 Sugar Land Hospital DIAZ, GGG Taylor, Hong 1 Sugar Land Hospital DIAZ, GGG Baby RPh, Mary 7 I need a formula that is going to look at column B (normally will have two names that are the same), reference column C for that patient and sum column D for that Team. For example, column C contains a Team that worked on a patient, first patient Diaz, GGG, with a team of Taylor, Hong & Baby RPH, Mary and the second patient is Hoffman, FFF, with team of Taylor, Hong & Bold RPhT, Jeany. ...
I'm in need of an Excel specialist. The main task involves creating an advanced Excel formula to assist with financial calculations, specifically focusing on data lookup. Key Tasks: - Design and implement an advanced Excel formula to perform financial calculations - Focus on data lookup aspects - Potential use of VLOOKUP, INDEX and MATCH, XLOOKUP or other relevant functions Ideal Skills: - Strong proficiency in Excel, especially with advanced formulas - Experience with financial calculations - Ability to translate complex data into understandable results - Familiarity with data lookup functions If you can help me navigate this task, please make a bid.
I'm looking for a developer to create a modern and trendy intake form. The project is divided into two main steps: Step 1: - Create a web or PDF intake form that includes: - Client's contact information - Property details - Loan specifics - Implement a formula to calculate the %/downpayment amount of the sales price/loan amount. Step 2: - Integrate a Zapier API that pulls in associated fees for the inputted property address. - Add a button that converts the completed form into a color PDF. This PDF should include a headshot, company logo, and all loan small print. Ideal skills for this job include: - Proficiency in web form or PDF form development. - Experience with API integration, particularly with Zapier. - Ability to create a modern and trendy design. Plea...
I'm looking for an Excel expert to assist with formatting my pilot logbook spread...I need help with both cell formatting and calculations. Key Requirements: - Expert level knowledge in Microsoft Excel - Experience in spreadsheet formatting, including cell formatting (e.g., colors, borders) and data organization (e.g., sorting, filtering) Specific Tasks: - Help with Formulas and calculations - Help calculating total flight hours and flight time by aircraft type - Create a formula for inputting an aircraft registration and having the corresponding aircraft type appear in the next cell. Ideal freelancer should have: - Strong attention to detail - Prior experience with pilot logbooks or similar flight tracking spreadsheets is a plus. - Ability to meet deadlines and deliver hig...
Just calculate simple commission formula and add to users only. Work with ftp only.
I need assistance with configuring a custom array in Amibroker AFL. The custom array is intended to store specific price data points, however I've run into issues with the setup. Key Issues: - The way to set up the custom array has been problematic and needs expert guidance. - The custom array needs to effectively store price data. Ideal Skills: - Proficiency in Amibroker AFL. - Experience with setting up custom arrays. - Understanding of price data storage and manipulation.
I'm conducting academic research and need help analyzing survey responses. I need a statistitan that can help me identify and give the correct sample size calculation for the bellow Total population 118 Stratum A) 70 Stratum B) 48 Z-score (default: 1.96) For 95% confidence level) 1.96 Proportion (default: 0.5) 0.5 Margin of Error (e.g., 5%) 0...and need help analyzing survey responses. I need a statistitan that can help me identify and give the correct sample size calculation for the bellow Total population 118 Stratum A) 70 Stratum B) 48 Z-score (default: 1.96) For 95% confidence level) 1.96 Proportion (default: 0.5) 0.5 Margin of Error (e.g., 5%) 0.05 is Finite Population Adjusted Sample Size needed? I need an excel with the formula and the steps broken down to a...
Hi there! I'm often working in Google Sheet and Microsoft Excel and need a formula or some random tips and advice on how to make my sheet better, make my formulas cleaner, or macros written. It's not a full time job, or even consistent work. I'm looking for something like a co-pilot, preferable on Slack that I message any time. There might be weeks or even months where I don't need the help, but I know there is someone to help on hand when needed.
...adjusts for inflation. The script needs to be able to adjust for inflation on a specified date, rather than the current date. Key Modifications: - Allow manual input for the date used for inflation adjustment. - Add two new columns to the dataset: 1. A column for the inflation ratio (%), calculated based on the market value and the adjusted value. 2. A column that calculates the result of the formula R=ax+by+cz, with a, b, c being arbitrary constants and x, y, z being data pulled from the current row. I've attached the current script and my attempts at modification. The script will be validated and tested in Jupyter Notebook. Ideal skills for this job include: - Proficiency in Python, particularly with data manipulation libraries. - Previous experience with Jupyter ...
I have a data sheet ready for a Monte Carlo Simulation assignment. An Excel expert is needed to input the formulas into the sheet and complete the assignment. A formula sheet and instructions will be provided. Key Requirements: - Intermediate level complexity for the Monte Carlo Simulation - Use of Random Sampling technique - Results presentation in both tables and charts Ideal Skills/Experience: - Proficient in Excel - Experience with Monte Carlo Simulations - Able to present data in a clear and concise manner
I'm seeking an expert in Google Sheets who can create a formula for me. The formula needs to: - Add a margin to the product price, calculated as a percentage of the cost. - Include the credit card surcharge, which is a percentage of the total. - Calculate HST (Harmonized Sales Tax) for a final grand total. Ideal candidates should have a deep understanding of Google Sheets and experience with financial calculations. Please provide previous examples of similar projects you've completed. I've attached a screen shot of what I've created so far (which isn't much) I'm having trouble with material margin, credit card surcharge which won't be applicable every time and HST to give me a total of all 3 based off the subtotal price when appropriate q...
...Knowledge: Familiarity with F1 visuals and the ability to integrate them creatively into fashion design. • Attention to Detail: Precision in creating a design that looks flawless both as a standalone piece and in repetition on fabric. Deliverables: • A seamless, repeating pattern design. • High-resolution digital file suitable for fabric printing. The design concept blends the adrenaline of Formula 1 with the elegance of silk, creating a seamless pattern that exudes both speed and sophistication. Inspired by the dynamic curves of F1 tracks, the pattern incorporates abstract elements like racing lines and streamlined motifs, creating a sense of motion and energy. To enhance the exclusivity, a single gazelle is subtly integrated into the design, symbolizing gra...
...synchronized on the secondary account(s) in real time. Position Size Calculation: The position size on the secondary account should be calculated based on a proportional rule relative to the main account. Example: Main Account Portfolio: Available funds in futures: $1,000 Position size: $100 Percentage used: (100/1,000)×100=10% Secondary Account Portfolio: Available funds in futures: $100 Apply the formula: 100USD×(10%of the account)=10USD Average Position: If a second position is opened on the main account, the bot should open it on the secondary account(s) proportionally. Manual Closures: If a position is manually closed, either fully or partially, on the main account, it must also be closed identically on the secondary account(s). We’re lookin...
I have a matrix where it computes the sum over some zip codes and regions and a time filter and the values are correct but also I have a second sheet where I have a bar plot but you can select a month and a region using bookmark and the sum is not correct. There might be some something small or formula to fix IN the second sheet I created some measure and the issue might be there. To work in this task it is required to use any desk.
I need a Python-based program that integrates with the...retrieve the relevant totals (e.g., player_assist_totals_L5, player_points_totals_L5) from Airtable. Calculate Hit Percentages: For each retrieved total, calculate the hit percentage for the respective last 5, 10, 20, and 30 games: Count how many times the total meets or exceeds the line value. Calculate the percentage of success. Calculate Weighted Average: Calculate the weighted average using the formula: Last 5 games: 15% Last 10 games: 40% Last 20 games: 20% Last 30 games: 25% Update Airtable with Results: Update Airtable with the calculated hit percentages for each respective period and the weighted average. Final Deliverable: Provide the program as a standalone executable .exe for Windows that I can run locally on my...
...Google Sheets project. The task involves pulling mixed data (both text and numerical) from an existing worksheet and setting it up so the data is automatically pulled and sorted into a new one within the same workbook. The original date is in worksheet as an example, and I need it automatically pulled and sorted in the same format as New worksheet. I need this to be a formula so New Sheet automatically populates and sorts based on the data in worksheet. The specific requirements are: - Extracting both text and numerical data - Cleaning the data by eliminating unnecessary spaces - Listing the dates in a specified format (MM/DD/YYYY) Ideal candidates for this project should have: - Proficient knowledge and experience with Google Sheets - Strong data organization
