Need formula jobs
Need to add latitude and longitude to excel sheet containing addresses and make new column Excel sheet contains Company name, address , category with latitude and longitude columns. 1. Only some latitude and longitude of addresses available. Some rows which doesnt have latitude and longitude, needs to be added. Looking for geocode or similar software to add latitude and longitude to excel sheet with addresses. No restrictions on number of addresses 2. Add a new Column description which will add data of 2 to 3 columns which will be useful for making description of the Company. Sample Column Company Name ( Variable ) is located in Column Address ( Variable ) dealing in Category ( Variable ) This may keep on changing , you just need to teach me how to add formu...
I need help entering my Painting estimating formula into an excel sheet that will calculate the formula criteria.
...calculation/dashboard where we can input order information (for example) headcount of people ordering, protein selections and it will calculate according to our formulas a combined number of proteins, starches:( rice, breads, etc...), drinks etc.. according to the portions we have set. Ideal there should be three sheets: - Housespread calculation sheet - Lunchboxes calculation sheet ( need to come up with random distribution formula) - Combined dashboard (a better version of the gameplan that is built by hand) reports it will yield: - Kitchen prep list - Combined assembly table - Individual order driver-checklist This is specifically for the restaurant industry so prior industry knowledge will be helpful. The links below are for the calculator we currently use and ...
I need someone to make a formula for google sheets that will take my main tab and filter into other tabs based on a conditional format of "total bases" home runs" "strikeouts". Tab1: Consist of all raw data TAB Total Bases: will need a formula to take all the Total bases in Main Raw DAta tab and placed iinto total bases tab must be done for all tabs "prop names"
...professional bio, a possible framework that has been shared across the internet as a winning formula is: [First name] [Last name] [knows/believes] [what you know/believe about the work you do]. [First name] has [landed/secured/garnered/worked at/supported] [insert your most compelling experiences and wins]. [First name] is a [trained/certified/awarded] [insert relevant trainings, awards, honours, etc]. [First name] holds a [insert degree] in [insert area of study] from [insert university]. This framework helps you to refine your bio, highlight the most compelling and relevant information and leave the reader with a clear and confident picture of who you are and why you do what you do. What don’t you need? A list of all you work experience or a bio that simply tel...
5 slides with some pic and text content.
When cell X3=OK, record or take snapshot of the data value in Cell U3 to Cell Y3 same for x4, u4, y4 upto 84nos Cell X3 contains formula Cell U3 has values which changes constantly Cell Y3 is blank
We need a custom metric formula created that targets a specific event (s). Basically acting as a filter (without using a filter) that we will use in data center We would use this to create a series of steps to use in tools like supemetric funnel and Sum this to create scorecards. you will need to be available to assist with the formula and general data studio questions
Hi Arman K.. Would you be willing to do another quick calc on blocks of rows for me please ? Per the attached sample file, I am looking for a formula in columns DQ and DR that I can edit fill down and it populates the area shaded in yellow. Blocks of data are always separated by one or more rows of data. Cells DR2 to DR10 have currently been filled manually for the purposes of illustration / example.
I would like to know if anyone can write me a formula to identify swing failure price action. The alert or signal should be generated after the bar fails to close above the parallel swing point. kindly let me know the pricing if you are able to write a formula for this. Attached is an illustration of what I am looking for. I would like to see this price action in the daily charts. Scan for the HIGH WITHIN the last 6 months (not the high 6 months ago) Then, the price drops more than 2 times ATR (daily) from the above 'HIGH'. Then, the price goes back up after dropping more than 2 times ATR (it doesn't matter how long it takes to go back up). And finally, the price takes out 'condition 1' (goes above that price) but closes&nbs...
physical scanned stock vs system stock in excel first formula split qty w.r.t barcode Sheet 1 contain stock on hand Sheet 2 will be scanned barcode Sheet 3 contains result of match sheet 1 with 2 Show plus ,minus,extra or barcode not belong to store.
Hi, I'm looking to create an animation of a Formula 1 race, in a similar style to this. I am creating a brief/storyboard now to share shortly. But the cars will start and race around, with cars stopping at the pit stop. I will try and help to create some of the design/visuals. Only reply with 'F1' Thanks Dan
Assume we have X number of salaried drivers working on X different projects, please suggest a formula to calculate the average cost, per shipment, per driver, and average delivery cost per project.
I have a digital marketing agency called Crystal E-Com Media and we help E-Commerce Brands get more sales online using Facebook ads and Tiktok Ads and our proven formula of messaging, funnel building, testing etc. This gives us a competitive edge and our clients love it. About the Job: I'm looking for a appointment setter / VA to work with us to fill my calendar with qualified meeting with ecommerce brand owners or decision makers. Compensation - 30% of total revenue per close deal. Location: Virtual/anywhere How to Apply: To apply for this job please send over a brief 1-2 sentence description about why you believe this job is for you. AND if you have read till now add "CASH" in our proposal.
Images and content should not be copied from amazon and other e coomerece website specially with indian domain.
So I have different spreadsheets. And the cells includes a formula which includes pivot table tab . We need to retain the data in the cells without having the pivot formula in them. Like we need to get the data of a huge pivot table without using the formula of pivot, ANY IDEAS?
Hello, *I'd like someone who is speak French. I have a start up business. We sell and built frameless glass fence for surrounding pools and balcony. ** You gonna have to make the formula from mathematic. There's no need for an outstanding design. We would like to develop a tool to facilitate the creation of our quotes and for customers to be able to determine the material required and especially the length of the panels. For example, if we indicate a section of 287'' and another of 132'' in the shape of 'L' the APP will say 3 panels of X, 2 panels of Y, a clamp 90 degrees, three clamps 180 degrees, 10 spigots. There would be fixed values and variables that the client would have to enter (using tooltips). Website will...
The attached excel file includes the "CRC" (first column) which is made up of Data1 to Data7. We need to find the math formula/algorithm to create the CRC value from available Data, to make the receiver peripheral to be happy with the "CRC". All data are in hex. Code sample in C.
Hello, I am beginner in Power BI and i have an issue doing what i would like. Table 1 (main table) Data 1 , Data2, Data3 Data5 Table 2 (equivalent table) Data 1, Data 4 So i have my...values to look up (data 4), i succeded using DAX to get the right Data 4 in table 1 so i can create the following url for each line: What i would like to do is to add another collumn with the text output from this URL. I tried opening the query and using the formula but i think i cant because my URL collumn was made by DAX? So i would need your help to build in power query the same functions i made in DAX or import those collumn in power query. Then i would need your help to test if is really the good function for my needs. Thank you,
I would like to have combat simulations of a video game. For that, I have some data from the different units (melee, weapon damage etc) and the formula that would lead to the combat result. It is not a big project and it is for personal use. I have translated json data into excel and created a table that I attach. I believe a series of v look ups would do the job but I am stuck in this last step. The method is: choose two different random units and make them fight. However I am not sure how to add the element of time in that formula since things change combat wise depending on the time.
No one is understood the assignment so will try to explain my self better. I need a label for a bottle design. I have my own logo and company name "MAMATONIC". I NEED THE LOGO I ALREADY HAVE, and the description of the product. I need a design with all of that in mind. Attached you will find my logo, an example of the design of another similar product, and an example of label design format that i need you to do Necesito una etiqueta con el logo y la descripción de como usar el fertilizante, luego esta etiqueta de imprimira como sticker y se pegara a una botella plastica para luego venderla etiqueta debe incluir el logo y frases como " formula mejorada", "fertilizante premium" " para interior o exterior" &qu...
...three kinds of passage: 1. Ranks Passage: A large share of the UNs expenditure addresses its core mission of peace and security, and this budget is assessed separately from the main organizational budget. The peacekeeping budget for the 2015-16 fiscal year was $8.27 billion, supporting 82,318 troops deployed in 15 missions around the world. UN peace operations are funded by assessments, using a formula derived from the regular funding scale that includes a weighted surcharge for the five permanent Security Council members, who must approve all peacekeeping operations. This surcharge serves to offset discounted peacekeeping assessment rates for less developed countries. In 2017, the top 8 providers of assessed financial contributions to Peacekeeping operations were the United S...
I need help w/ formatting dates periods pls dys excel formula asap
I want formula in excel for eg if i put price in excel sheet he has to give me net rate with gst without gst
The product is based on solvents such as acetic acid and THF. The formula should be applied using an aerosol can. It is important that the product meets US and European standards
I need a super excel formula/function expert. I will pay $2/formula (negotiable). There will be so many formula functions request from our side for you. How much do you want for each formula functions ? Please answer one of the formula in the forum perfectly, hence, I know you are qualified. Here's are the list of the formula request : Ask Formula - Vlookup, sort, different sheet 1.) https://docs.google.com/spreadsheets/d/10gL36ClzOjz1FCSGXwnFIR2yN_BMnEDVY4s9zdffIOo/edit#gid=0 Thread -> 1a). [B][/B] 1b).
We need a website on WP where a user gets posted 10 multiple choice questions and is then led to a page with posts that are filtered by a formula that depends on the answers the visitor chose. Sometimes the question asked depends on the answer the user gave on the previous question. If you are a developer that can can convince us of your competences and can do this in a fast and efficient way we are prepared to give a very good hourly rate. The design is already made and the WP already working, all we need is the mechanism to do the filtering based on a formula. The code must be clearly written and explained so in case of emergency another developer is able to intervene if you would not be available at a certain moment. More information is available upon request...
I need my mission statement rewritten. It is one paragraph. I need it to be specific, not generic, exciting, sincere, and authentic. I need this done within the next couple of hours. I need it sent back to me today. Mission Statement Draft: Our mission as a company is to serve full-time traders who strive for freedom and who have been struggling to make money consistently by taking them by the hands each step of the way and providing an exact step-by-step formula, to edge them forward and start making 5, 6 and 7 figures a year trading from the comfort of their home or anywhere in the world, using our powerful and proven methods. We help our clients develop an unshakable mindset, giving them the courage and skills to avoid repeating the bad habits 90% o...
...they will tally up and make a complete order form. This will need to link with the office who will have the items but also the prices attached in order to price up a quote for the customer. it must be able to convert area or length into the amount of material required, (once the equation is imputed) example roof is 300 sqm I wanted to use monier shingle. i would click Monier shingle and have the option of adding a square meter figure and the software would calculate the tiles required - or the number of tiles and it would calculate the square meter. same with Ridge caps etc for Lm add the amount of ridge caps and it will provide the Lm - or the Lm and it will provide the amount of caps required - this will be based off a formula I will be able to input through the backen...
I need to create formula based on criteria table based on two variables
We are seeking an experienced grant writer for NEVI Formula funds for multiple EV Charger installation investments in Pennsylvania.
MAKE SMALL CHANGE TO EXISTING EXCEL FILE BY PUTTING A FORMULA TO FETCH A VALUE FROM A CELL
...stream WITS WITSML and more. 3. DISPLAYS & MONITORS Displays and monitors including digital displays, radial gauges, level gauges, grids, dynamic grids, process diagrams and trends. 4. PLOTS & TRENDS Fast performance trend supports millions of data with multiple axes sets (up to 6-8 axes, high performance vector technology). 5. CUSTOM FUNCTIONS Custom defined formulas can be setup from a simple formula eg (Gas oil Ratio = [ gas rate/oil rate ] ) to a complex one. 6. DATA LOGGER Fast configurable data logger built with high performance. fast and efficient backup system 7. ALARMS Visual and audio alarms can be configured to any channel with four levels (Very low, low, high and very high) 8. EVENTS a. All user changes configurations and inputs are logged as well as faults a...
This file works in excel however when i uplload it to google sheets it does not work. On the sheet week one you can choose the category however you cannot choose the exercise. When you click on the exercise then the data tab then data validation its complaining about "indirect" formula
Project asset and liability scenarios using Monte Carlo simulation including : 1) Generate stochastic asset and liability return scenarios (using correlation matrix for a portfolio of assets and liabilities) 2) Generate various discounting curves and funded status ratios (assets divided by liabi...1) Generate stochastic asset and liability return scenarios (using correlation matrix for a portfolio of assets and liabilities) 2) Generate various discounting curves and funded status ratios (assets divided by liabilities) 3) Dynamically rebalance the asset portfolio and liability hedge if triggers are reached 4) At annual intervals (i) test for funding requirements, incorporating complex formula based funding rules and (ii) produce pro-forma GAAP disclosures 5) Produce outputs includ...
just need some help figuring out how to make a formula do what i need it to, the formula that i need takes one page in the sheet and moves over all of the values within a specific range on that sheet to a list on another sheet, the problem i am having is that the formula looks like this =textjoin(char(10),true,LOADS!A2:A14) but when i pull it down to copy the value it turns into this =textjoin(char(10),true,LOADS!A3:A15) what i need is to know how to make the next formula start at where the last formula ended
I NEED DATA FROM ONE COLUMN MATCHED AGAINST DATA IN A DIFFERENT WORKBOOK AND THE INFORMATION WITHIN THAT DATA TO BE TRANSFERRED TO THE INITIAL SEARCH VALUE. VALUE 1 PAIRED WITH MATCH OF VALUE B IN DIFFERENT WORKBOOK, VALUE C THEN POPULATES VALUE 2
- We need a Website für our startup Renovation Company. - A Logo has been already developed. - The website should have about 4 or 5 subpages: 1. Home (nice picture and an interesting text or motto about our philosophy or our work) 2. Our Work / our Services - before and after pictures - description of steps: 1. first contact, 2. appointment, 3. calculaton and offer, 4. realization, 5. final inspection and handing over 3. Contact formula 4. Impress and conditions - We need a link to Facebook and Instagram and the possibility for our customers to press on a button and automatically contact us via WhatApp. - The Website should be professional, beautiful and an eye catcher. - I can provide the texts and the pict...
...الشغل. بيقدر يحلل الـ Business بشكل كامل ومعتمد في تحليلاته على الـ SWOT Analysis بيقدر يفهم الـ Buyer Persona بشكل كويس ويحللها كمان علشان يعرف يطلع الـ Problems اللى بتواجههم وكذلك الـ objections ويشتغل عليها في الـ Campaign ويقدمها في شكل Need بتلمس الـ Persona اللي رايحلها . بيكون عارف ازاي الـ Online Business بيتم إدارته وبيكون عارف ان تكاليف التسويق ليها معدل معين مينفعش تتخطاه لان في تكاليف منتج وتكاليف شحن وتكاليف عماله لسه بتنضاف عليه فالـ ROI اللى موجود فى الـ Dashboard مش دا مقياس نجاح البيزنس . بيكون فاهم ان في حاجه اسمها الـ Largest Market Formula ودا اللى معناه انك كـ ماركتير لازم يكون شغلك مبني فيه Selling System عبارة عن Sales Funnel وكل مرحلة من الـ Funnel دي بتقدر تقدم فيها العرض المناسب ليه على حسب هو فين دلوقتي في الـ Funnel . وان الماركتير العادي بيشت...
...Strength & Power - [ ] When they last tested - [ ] A photo with their basic details - [ ] What week they are in on the program - [ ] Next Testing date 4 Week traning plan - [ ] I will for weekly plan to be more clear modern and sleek looking easy to read - [ ] I would like a formula built-in to account for the total time spent each week - [ ] I would like a formula built for the total number of repetitions for each week - [ ] A drop down menu next to each exercise as seen in the plan - [ ] I would like a formula built-in to account for the amount of time spent in a specific zone. I would like the movement profile the 5D profile and strength and power profile to be cleaned up mid modern sleek and easy to read. Annual training profile I would like a gr...
I want to code my bank transactions by running formulae over ...lists I have created. I want to do this via excel, so I can do it on the computer. 1) I manually download data from a bank account into Excel; ]. 2) I run a formula over the description column that says: (if the description column (C) contains the keyword "blah" from the Keyword List, then assign it "category" from the Category List. I want to be able to update the Keyword and Category List. I want to be able to have more than one key-work for each category. Not...
Just a SIMPLE work for those who know how to use excel formula or VBA . Just need 1 formula and use the same formula to populate the 7 excels for me To be awarded , you need to show me sample data that your formula works to acheive the above Need to assist to populate 7 files - 5 shopee files and 2 lazada file 5 shopee files column K SKU 2 lazada file column J Seller SKU WHAT TO DO : POPULATE the new SKU IN COLUMN N AND COLUMN P 1)SKU has to be unique for each Excel File (Process the formula on excel 1 by 1 , there is not relationship between the 7 excels) Example MnfUpBriefRandom - if 1 found in the excel - output MnfUpBriefRandom^ MnfUpBriefRandom - if 2 found in the excel - output MnfUpBriefRandom^ and MnfUpBrief...
...Strength & Power - [ ] When they last tested - [ ] A photo with their basic details - [ ] What week they are in on the program - [ ] Next Testing date 4 Week traning plan - [ ] I will for weekly plan to be more clear modern and sleek looking easy to read - [ ] I would like a formula built-in to account for the total time spent each week - [ ] I would like a formula built for the total number of repetitions for each week - [ ] A drop down menu next to each exercise as seen in the plan - [ ] I would like a formula built-in to account for the amount of time spent in a specific zone. I would like the movement profile the 5D profile and strength and power profile to be cleaned up mid modern sleek and easy to read. Annual training profile I would like a grap...
