Geometric formula jobs
Hello, Using Google sheets with french version. I need to solve the following issue : This formula is working but by increment. =SI(OU(ESTVIDE(C2);C2=0);"";SI(ET(C2>0;C2<=INDEX(avg_domain_authority!J:J;EQUIV(B2;avg_domain_authority!A:A;0)));5;SI(ET(C2>INDEX(avg_domain_authority!J:J;EQUIV(B2;avg_domain_authority!A:A;0));C2<=INDEX(avg_domain_authority!K:K;EQUIV(B2;avg_domain_authority!A:A;0)));10;SI(ET(C2>INDEX(avg_domain_authority!K:K;EQUIV(B2;avg_domain_authority!A:A;0));C2<=INDEX(avg_domain_authority!L:L;EQUIV(B2;avg_domain_authority!A:A;0)));15;SI(ET(C2>INDEX(avg_domain_authority!L:L;EQUIV(B2;avg_domain_authority!A:A;0));C2<=INDEX(avg_domain_authority!M:M;EQUIV(B2;avg_domain_authority!A:A;0)));20;SI(ET(C2>INDEX(avg_domain_authority!M:M;EQUIV...
Hello All, I need an application/ or stored procedure in MSSQL, that create a excel file, with data provided by a view from a mssql , daily or when is requested. Excel will have a Logo and an antet, which can be changed when needed. will have 5 ditable cell Two column will be formula column, based on formula depending of editable cell. I attached excel file that I use in this moment, the final result will be something about the same.
...Configure Excel so that you can edit content using Albanian as the editing language. Do not make Alnanian the default editing language. If you are prompted to restart Office, dismiss the prompt but do not restart Excel. 10. Require that users enter the password "123" before they can make structural changes to the workbook. 11. On the "Cities" worksheet, use error-checking features to locate the formula that is inconsistent with those around it. Correct the error. 12. Use the data from the "Pop Growth" sheet to create a PivotTable on a new sheet. Name the sheet "Population Change" 13. In your new PivotTable, apply the "City" field as your rows and "Present" & "2030" data as your value fields so we can compa...
I need to replicate the excel (attachment 1) so that it can be easily used and all of the cells/inputs can be easily changed/edited including the scores if required. Some of the cells are formula based and I cannot change them. I tried to make changes as you will see but could not. I would like the changes and inputs shown in the excel (attachment 2) to be used. I have also shared the original excel (attachment 3) which I am trying to replicate. This is a locked excel and I do not have the password.
Build an app that connects people internationally for the purpose of tutoring. It is an app that contains a similar formula to Uber, in the same way that tutors can be rated. This allows for the best tutors to be available for students across the world. There has to be a video call feature within the app to allow for call monitoring and moderation.
...is clean and free of any contamination. They will send the samples to Purity Check to test them and report the results. Tests: * Tap, bottled and pool water for microbial contamination and/or heavy metals * Cosmetics for heavy metals * Fruits and vegetables for pesticides, mycotoxins, and heavy metals * Coffee and other drinks for caffeine * Food for mycotoxins and allergens * Baby food and formula for melamine and heavy metals * Toys and paint for lead Target market: Health-conscious people, relatively affluent families, families with kids, people with food allergies. The customers of his business are people, not companies. Relevant concepts: * Laboratory * Test * Health * Wellness * Safe * Pure * Clean * Science Design: A symbol + a logotype is preferred. Colour: ...
I have no experience with Excel. I need a Annual Sales Journal that provides running total. My spreadsheet will have 11 columns of which 6 columns will require to running totals as the days/months progress to Year End The spreadsheet will also require to calculate a a tax amount using a formula, post the tax amount on one of the columns and total the sale amount with the tax on another column that along the horizontal lines.
setting up sales comm formula using excell so my reps can enter information
Open Simulink and create a new model. Add the CAN bus block from the Simulink Library Browser to the model. This block represents the physical layer of the CAN bus and provides access to the CAN bus signals. Add the CAN Transmit and CAN Receive blocks to the model. These blocks represent the application layer of the CAN bus and provide the ability to send and receive CAN messages. Connect the CAN bus block to the CAN Transmit and CAN Receive blocks. Define the CAN message format by specifying the message identifier and the data length in the CAN Transmit and CAN Receive blocks. Add the necessary blocks to model the electric vehicle, such as battery, motor, and controller. Connect the electric vehicle model to the CAN Transmit and CAN Receive blocks to send and receive CAN messages. ...
The formula that you will create will assist staff in the “estimatics department” determine what the total negotiation with the insurance carrier and or out-of-pocket pricing must be using the total cost of the job so as to remain at total job cost of 65-67 % gross profit. Please see the attached file with full description. We are hoping to set up a form or dashboard where we would be able to calculate these numbers on the fly just by plugging them into the form. We are hoping this tool will act almost like a calculator.
i need a googlesheet expert to help with formula, script to make my current process flow smoother and fixing some existing bug. don't think it is a complicated project, require some enhancement and tweaking. 1) Google sheet with 8 column A:H 2) Date, Customer, Outlet, Product, Cutting Method, QTY, UOM, Remark 3) Customer will be base on validation data range from raw data sheet within the same worksheet. 4) Product will be based on validation data range from raw data that belongs to the individual customer. Example: We have 100 product. Customer A: Product 1, 2 5 Customer B: Product 1,2,3,4,5 Customer C: Product 2,3,4 Current method is more complicated, would like to know if there is a better way to do it. (in the raw data sheet) I) ='sheet1'!$b2 (1 column at D) ha...
Have the formula close but just can’t get it to copy over
Open a new Excel spreadsheet. Create the following headers in cells A1 through E1: "Investment amount," "Monthly income," "Term," "Investor % of monthly income," and "IRR." Input the relevant data in...amount," "Monthly income," "Term," "Investor % of monthly income," and "IRR." Input the relevant data into the appropriate cells. For example, in cell A2, input the total investment amount, in cell B2, input the monthly income, in cell C2, input the term in years, in cell D2, input the investor's percentage of monthly income, and in cell E2, leave it blank for now. In cell E2, enter the following formula to calculate the net cash flows of the investment: =-A212(1-D2/100)+B212D2/100/(1+(...
Needing a formula for a pdf. Unsure how to do it on adobe.
I would like an expert to create a formula for some simple tasks and sorting of numbers and values etc
I am trying to format a spreadsheet that would assign a cohort group name example: if the Region column equals "BC Region" and the Shift column equals "7x7*12/R1a/DO-T" assign "BC Region - A" I attached a photo of all the different groupings.
We are looking to create a calculation tool for our services that would be embeded on our website but as well run as an mobile app if possible. Our customer should use this calculator and introduce the projectrelated datas themselves. In the back the formula we will provide you should calculate our fee´s.
Need to create a spreadsheet which has formulas containing the below: - Categorising data into 2 groups - Categorising data into date it was received - Categorising the date data was received into how long it took to complete that line item - Being able to programme a formula that calculates the time (in days) between two dates, but takes weekend and public holidays into consideration so only calculates the number of working days.
I need the following completed 1) Make time on gantt table go read 8am-2am //rather than 8am-5pm 2) Change the times formula so they can input start & and finish time themselves rather than inputting start time & hours. The function needs to be able to log Start & Finish time then the hours calculated from that input adds the ours. 3) Create 7 of these for a 7 day week It is used to create a rostering Gant Chart
I am looking for a Shopify expert who has experience with Itoris Dynamic Product Options and can integrate this (and transfer formula from Wordpress site). Would prefer Shopify, but open to Wordpress or Magento. I need the almost identical configuration to Curtains-2go.co.uk. I need to be able to create a custom product page and upload products via CSV format
You would need to build a Protein Calculator. It’s pretty straightforward. It’s just a gm/kg x multiplier for activity level calculation. Pls visit quiz for the kind of UI UX that I'm looking at. The ecommerce website is hosted on Shopify How the formula works:
I am seeking a digital artist to help me design a beautiful chakra/metaphysical/ sacred geometric themed banner for my business events. I would like to have a relatively large image printed on vinyl and need something that will be high enough resolution to be blown up & not become blurry when it’s printed..
Hola Buen dia! Mi nombre es Julian. Necesito desarrollar una formula para slime para niños, soy fabricante de ese juguete, ya lo he fabricado con éxito, pero he tenido problemas últimamente con el producto, por ejemplo se me hace agua con el tiempo, o deja muy mojada la mano. Quería consultar si realiza formulaciones para este producto. En el caso de que si, puedo darle la formulacion que venia usando y que ha tenido problemas, para poder mejorarla. Saludos desde Argentina!! SLIME Ingredientes: -Agua (130 lts) - Goma Guar (2,2kg). - Disuelto en 3 litros de Glicerina vegetal. - Sorbato de Potasio (260gramos) Benzoato de sodio (130 gramos) .- disuelto en agua caliente - Glyocide/fungicida (500 ml) - Colorante alimenticio - Dolomita brillante 325 (2kg) - Bo...
I need assistance creating a spreadsheet with all the functions I require. If you can do it within 3 hours then bid.
I need help with a formula in excel. I have rows with contain data although I would like the data to have the same difference from highest to lowest. I images below shows the rows and difference from highest to lowest. You can see the differences in average at bottom of each row. I would like each row to have a high/low difference of 43%.
I need a working Script in Python. I will run it on Sublime text. The Script need to connect to a API. Get Crypto stock data. From 50 crypto projects. Take the data. Run the RSI formula on it. And print the Result from the Formula. The printing of the results must be just like the 2 attachments. 1 in a chart and 1 point text. The calculations will be. Every 15 minuntes. Every 1 hour. Every 4 hour. Every 24 hour. And the calculations will be send to our discord maps. There we will make a. 15 min map. 1 hour map. 4 hour map. 24 hour map. Only people who has Python knowledge. This will be step 1. When completed correctly. We gonna build more on it. Payment only 25% beginning. 25% during. 50% when finished and working script.
I need to create a formula that will allow excel to determine the left over profit from deposits still on hand list list as a seperate total.
help create inventory allocation formula/macro/solve on excel based on my existing tables and dataset. there is 2 existing tables. 1. shipment table that shows the goods arriving by arrival port and date. 2. the customer list that shows the allocation ratio. and distribution port. this is the information that would need to be compiled to give the required result in the final table.
I have this staking contract on top my token im looking for someone who could help me update to these function 1. User will be able to stake for 100 token minimum. 2. Stake token will earn interest after 24 hours on the initial time a user stakes 3. the formula for earning is (token stake / 365 ) * 0.08. approximately 8% APR 4. each earning from staking will vary depending on the time the user stake. basically every stake will earn after 24 hours. 5. stake token will have an unlocked period of 3 days. meaning you can only un-stake after 3 days time 6. Only staked tokens that passed 3 days will be un-stake once a user un-stake his token. Meaning tokens will remain un-stake if they dont pass the 3 days period. unstake tokens before the time it reach 24 hours will not get reward. use...
ON THE SHEET STOCK PROJECTION. ALL THESE VALUES ARE INPUT FROM CONNECTING SHEETS. ONCE A WEEK THIS SHEET IS LOOKED AT TO DETERMINE IF WE ARE ORDERING TOO MUCH/TOO LITTLE. We determine this based on the calculations in excel of sales, stock on hand and what stock is on its way. WHAT I WANT, IS A WAY FOR THIS TO BE FLAGGED AUTOMATICALLY, RATHER THAN SPENDING A WHOLE WORKING DAY GOING THROUGH THIS. SO IF WE DON'T HAVE ORDERS COMING IN, IN LINE WITH THE CALCULATION OF STANDARD PRODUCTION/WEEKLY SALES, WE CAN SEE IMMEDIATELY AS EXCEL WILL FLAG THIS. I will share the file after talking with you and deciding to work with you. You can create a new sheet or configure the sheet in question. Up to you, you’re the excel expert. English is a must for this, as this could take some expl...
I'm needing assistance to write the formula to highlight a date cell that occurs in the past.
... ---- I can run this by simulating each archer and each target one at a time in a loop. The problem is that the number of "archers" and "targets" can be arbitrarily high (in the trillions), the hitChance can be arbitrarily low, and I need the program to run quickly. Looping is therefore not an option. Essentially what I need is someone who knows how to figure out a probability distribution formula describing the results of the function, and can convert this probability distribution into a NON-looping function (that is, a function with O(1) complexity) that, when run, will produce a random result (how many targets were hit), such that when run multiple times, the distribution of final results will be indistinguishable from the distribution of final results p...
We keep a private master inventory data sheet internally. We want to pull certain info from that sheet and have it write to a sheet we can share with a group of invitees. Mostly just 6 columns of data with one "if then" formula to send specific rows to another viewable sheet. If we can do this all on one sheet using tabs thats what we would prefer.
About chicony design: chicony Desing is a 3d printing page, that print the perfect 3D print Project Description: a geometric design with the letters C.D. in gold with a lot of lighting but with very good shadow and 3d print design
Hi. This would be for part of a sleeve tattoo with a sacred geometry theme. I want a sunflower with geometric lines/symmetry or someone’s take on it which could fit in with the theme, it would be on the shoulder area.
I want to create a dropdown menu on a new sheet in my Google Sheets Workbook which has all of the dropwdown menu options that are available in columns C3:C11, D3:D11, and E3:E11 across 6 sheets in my workbook. The titles of the 6 sheets in my workbook are: 1. Poczucie sprawczości 2. Odpowiedzialność 3. Elastyczność 4. Wiara w siebie 5. Change Maker / Problem Solver 6. Persistence The available dropdown menu item options in columns C3:C11, D3:D11, and E3:E11 across the 6 sheets are: Ankieta - Uczeń Ankieta - EduLeader Ankieta - Inny Obserwacja - uczeń Obserwacja - Lekcji Produkt dostarczarny/dostawczy Wywiad Ewaluacja Self-Regulation Sheets Lista obecności Oceny Samoocena śledzenie zadań When I select an option from this new dropdown menu, I want to see all the rows in those 6 sheets ...
I need a quick excel formula to be written. Need to be pull the corresponding hour and date that the max or peak occurs. For instance, I need to pull what hour and date the result in C1 occurs. The formulas need to be written in c5 and c6 and be able to be applied across all columns.
1 - convert IFC data to CityGML with using semantic 2 - parse Ifc file and save as an RDF triple 3 - map these IFC/RDF data and citygml semantically and do a geometric conversion for georeferencing 4 - write the mapped data as an citygml file format 5 - visualize the exported citygml data IF YOU CAN DO IT START YOUR PROPOSAL BY IFC CityGML
1 - convert IFC data to CityGML with using semantic 2 - parse Ifc file and save as an RDF triple 3 - map these IFC/RDF data and citygml semantically and do a geometric conversion for georeferencing 4 - write the mapped data as an citygml file format 5 - visualize the exported citygml data IF YOU CAN DO IT START YOUR PROPOSAL BY IFC CityGML
I have a xlsm file which has multiple spreadsheets. I need a macro to protect all the cells that has formulas in it so that users do not edit the formula and lock all the spreadsheets.
need someone to give me the formula to convert a line to a mirror image not from origin
ON THE SHEET STOCK PROJECTION. ALL THESE VALUES ARE INPUT FROM CONNECTING SHEETS. ONCE A WEEK THIS SHEET IS LOOKED AT TO DETERMINE IF WE ARE ORDERING TOO MUCH/TOO LITTLE. We determine this based on the calculations in excel of sales, stock on hand and what stock is on its way. WHAT I WANT, IS A WAY FOR THIS TO BE FLAGGED AUTOMATICALLY, RATHER THAN SPENDING A WHOLE WORKING DAY GOING THROUGH THIS. SO IF WE DON'T HAVE ORDERS COMING IN, IN LINE WITH THE CALCULATION OF STANDARD PRODUCTION/WEEKLY SALES, WE CAN SEE IMMEDIATELY AS EXCEL WILL FLAG THIS. I will share the file after talking with you and deciding to work with you. You can create a new sheet or configure the sheet in question. Up to you, you’re the excel expert. English is a must for this, as this could take some expl...
Hi I'm Christian, 25 years old, actually my job isn't in music industry, but I'm trying to produce my own trap beat, workin' with Logic Pro. I'm a fast lerner, I've met some teacher and had some lesson; they thought me some professionale tips, but now I see I'm not reaching my goal: how to make the right formula to have a professional sound. How could I choose the right sound to have a professional impact? My drum is 'muffled'...Could you help me? Many thanks, Christian
I need an excel vba script that will do the following: hide rows 8:11 if the value of cell d8 (formula) = 0. hide rows 12:15 if the value of cell d12 (formula) = 0. continue through row 735. Script must run automatically when value in d8, d12, d16, etc. changes. Should automatically hide each set of 4 rows when value is 0, and reveal those rows when value is >0. I am using Excel 365.
I have an excel spreadsheet which has been created and we use it for our pricing for supplying screed in the construction industry. We need to increase our prices and therefore the formulars need amending. This is a pretty straightforward job as the spreadsheet has alrea...have an excel spreadsheet which has been created and we use it for our pricing for supplying screed in the construction industry. We need to increase our prices and therefore the formulars need amending. This is a pretty straightforward job as the spreadsheet has already been created but you will need to have patience with me as I will need to keep checking the prices once you have amended the formula to make sure they fit with us. The spreadsheet links to peoples post codes so we can include distance into th...
1 - convert IFC data to CityGML with using semantic 2 - parse Ifc file and save as an RDF triple 3 - map these IFC/RDF data and citygml semantically and do a geometric conversion for georeferencing 4 - write the mapped data as an citygml file format 5 - visualize the exported citygml data IF YOU CAN DO IT START YOUR PROPOSAL BY IFC CityGML
I actually want to integrate the IFC and CityGML data. For that I need to convert IFC data to CityGML with using semantic web technologies. For that I need the parse Ifc file and save as an RDF triple. After that I need to map these IFC/RDF data and citygml semantically and do a geometric conversion for georeferencing. And after all these I need to write the mapped data as an citygml file format And I need to visualize the exported citygml data too I can provide you the websites of these data formats for IFC: for CityGML: both are uses schema mapping so you need to map the data for each other like this: citygml_mapping