...'dataset', and the layout of how I would like it to be transformed... I would like to accomplish the "End Result" with the use of a formula only - and NO helper columns. - Array formulas are also fine. ** I don't want to use macros ** ** I don't want to use pivot tables ** ** I don't want to use filters ** I just want a formula or array formula to...
Equipment involved in the solution: 1. Firewall: USG6370 (2) 2. Core Switches: S6720-54C-EI-48S-AC-85 (2) 3. eSight Networking It is very important to provides a high availability solution meaning double equipment and 10 GB connectivity between them. Attach file with request
1. Create an excel spreadsheet using formulas without macros 2. Spreadsheet for tracking of job status 3. Able to calculate lead time against current date 4. Able to change color automatically 5. Drop down selection 6. PLEASE READ THE MS WORD REQUIREMENT FIRST
you have to design a wireless power transfer simulation circuit using ADS, I will provide a research paper where the circuit design is given and your job will be simulating the given circuit and reproducing the same graph as the research paper graph.
I need some one expert in excel formulas to explain the meaning of equations similar to these =IF(OR(E47<0,E47>0),ABS(F47)*AVERAGE(C11,C23,C35),IF((D47*SUM(C43:C46)/4)>AVERAGE(C11,C23,C35),D47*SUM(C43:C46)/4,AVERAGE(C11,C23,C35))) He should have some knowledge about the forecasting and tell me if these equations are correct or not.
I need a 3D model of something. ❖ Expertise in Iso-Matric D...Expertise in Iso-Matric Drawing and General Arrangement Drawing (GAD) P & ID Drawing. ❖ 3D AutoCAD, Proe, Micro station, Navisworks software. ❖ Knowledge of MS Excel, familiar with formulas and shortcuts. ❖ Knowledge of Microsoft word and access. ❖ Familiar with internet operations.
Hi, I require a typeform building but each answer will start a new flow with there being nearly 100 diffrent variations at the end of each flow the form will then send them to a thankyou page and the button will send them to a product page on there results
your job is to find a solution to speed up the loading of the option templates that our magento 2 website is using. the site uses a MAGEWORX extension to allow to add custom product options See attachment [log ind for at se URL] [log ind for at se URL] [log ind for at se URL]
you must have advanced magento skillset you must deliver the project on time. SORT ORDER i need a skilled magento 2. no amateurs to do the following. The site uses a custom extension that allows to add multiple template custom options at the product level. [log ind for at se URL] [log ind for at se URL] [log ind for at se URL] i need to add
...automate tasks in Excel by writing so-called macros. This is for a project repeated every 3 months. Attached are the spreadsheets we have put together. I also attach the end result which gets fed through the excel information. We take the financial statements for ten banks in one given country. We then input all info on to the excel model. Only on the
KEYWORDS Fibre Optic installation Testing telecommunication Refraction Diffraction LANs CATV Parts of the optical fibre
I am looking for somebody with advanced Photoshop & Lightroom skills to make a vision a reality with a particular photograph that I have. I am looking to have the photo edited and enhanced beyond just the basics.
...to database quickly and easily - easy download to CSV or excel format post application of filters (or in entirety) - additional columns, or a seperate database, that applies excel formulas to the raw database. These are generally sumifs/averageifs or one field minus another field. These formulas can be provided, and essentially compare one competitor
Build Web Based or Google Sheet based Reporting Tool , data to be pulled from daily email in which excel report is an attachment. Reporting has to happen as per data in excel sheet and applying some more formulas. Reports should be historically available and on applying appropriate filters, weekly, monthly, yearly views can be presented. If it is a
...farmer of irrigated almonds, I use an excel spreadsheet I made to track the dozen different fertilizers I use , over different properties, and keep track of individual elements in fertilizer blends giving me a run kg per ha tally. I have used this for many years . I have limited expertise in excel and some formulas are glitchy and I need help tidying
Pulling advertising data and need someone with advanced level data extraction skills. Please read complete instructions from media extraction sheet and review inventory ingest excel sheet to see where you will be putting data into. Please only bid after reviewing complete instructions from sheet. Instructions: *Task*: You will need to convert
Related to canteen management. Create a worksheet using excel maintaining the monthly expenses of the canteen under various heads, for a year. it should contain: •Formulas that automatically calculate •You must find the average expenses per month •Automatically find the month when the minimum amount was spent. •Create a chart for head wise expenditure
...experiencia comprobada en el mundo financiero capas de hacer un Avaluo para determinar el precio de una empresa. Al mismo tiempo deberá explicarnos paso a paso los métodos y formulas que uso para obtener el valor correcto de venta de la empresa a fin de poder hacer un explicación a nuestro clientes. Si el trabo es satisfactorio esto abrirá la puerta a
...Review payroll reports and distribute paychecks • Distribute paychecks on a bi-weekly basis. Requirements: • Advanced knowledge of Microsoft Office Word and Excel • Excel - must be able to create and maintain spreadsheets with basic formulas • Word - must be able to create and maintain word documents • Able to work on confidential items ...
Please see our documentation attached. Please see our designs (shrunken for protection) attached. *3 PSDS are missing from the JPGS. Must be done by Nov 1st.
I need someone to develop a text analysis tool I can put on my web [log ind for at se URL] will need to: Calculate readability using Flesch, Flesch-Kincaid or similar formulas Identify and count parts of speech Identify and count a set of specific words and phases Run a mathematical formula using the results of the above functions
I have been working on this project to explore a valuable signal from the pulse measurement of high energy proton beam. And the current project that I would like to work on is to do with a wavelet and sptool function in matlab because I would want to see more detail by manipulating some filter. I can give you all of the results and raw data. Please let me know if you can work it quickly.
Formulas and making excel update from external sources
I have a Document converted from PDF To Word. There are many mistakes in the Word document especially in the Math formulas I need them to be rectified to be exactly identical to the PDF Document and this should be done manually. I need this to be done only from page 16 to 72 from the PDF document attached.
Three address types: (WANT EXCEL FORMULAS - NOT A MACRO) (1) if, ", APT - extract ", APT and everything to the right until the next comma including the next comma - output results in columns C & D per example in attached file. (2) if, " STE - extract " STE and everything to the right until the next comma including the next comma - output results in
I'm looking for a developer who can convert a spreadsheet based multi step calculator, into a WordPress plugin that I can embed on a clients website. The excel document is designed so that a business employee enters various energy use information for their business, and it then calculates the total energy savings that can be made through making changes
...to be coded in Excel using 'If' fuctions depending on what people choose to give them the appopriate discount level and costing. Please note the following: 1. The Calculator will need to spit out the total dollar cost of items, discount percentage reached (dependant on number of items) and savings in a dollar value. NOTE - Formulas only need to be
...in the templates. Required to alter cell formulas with new API cell names as given to you. • Reports (D) consisting of furnished formatted templates to include API data reported with one graph, two tables, a pie chart and a bar chart. Formatted BI templates furnished for all with API feed defined and API Excel files in one completed lot of a single commodity
I require a Freelancer to help me build economic models and provide me support with other economic research requirements. Freelancer must be experienced with economic mo...build economic models and provide me support with other economic research requirements. Freelancer must be experienced with economic models, global economy, and economic formulas.
...requires to build an R-Shiny app from underlying excel data and logic. The app will be interactive and dynamic which will use underlying excel data to allow user to play with different scenarios. The coder needs to understand the logic of the excel numbers and how they work. And then code the formulas in R and present the interface using Shiny app.
I have designed a calculator that calculates a total based on choices selected. The data v...numbers come out at the end. I have listed 11 steps that i need completed to make the project work. I would expect this to be an easy project for someone who knows google sheets/excel (I don't!). Please message if you would like the google sheets link to view.
Please add time zone list box. After changing time zone cookie will be saved on client side to remember choice when opened again. Calendar and chart data will be adjusted to changed time zone. Second task is to add new tab with big charts like these: [log ind for at se URL] On the tab there will be option to choose second chart from the list. Both charts should be synchronized. I created some b...
I've setup the rendering of the adverts to occur dynamically from jQuery, however the animation for one particular advert will occur regardless of whether the advert is loaded. To address this I've tried to add event listeners in the Google tag define slot JS, but I'm running into issues. So I need a patch that will be able to tell if the ad has loaded [log ind for at se URL]().ad...
We have to create a project that simulates balls collision. Basically we initially cre...collision. Basically we initially create an array that holds 1000 balls, then we break that array into 8 or 12 chunks and then use Thread pool to implement the ball collision formulas given in the [log ind for at se URL] the user presses space bar 1000 more balls are added.
Hallo Tomasz K., Could you also do stats with Excel? Visual Basic, Formulas? I got a statistic in Eviews. I'd rather have the whole thing in Excel, though. If it's even possible. That's for my masters thesis. I could send you the masters thesis so you can read yourself. Additionally I have an Excel file with data. It's about regression analysis, est...