Selesai

Google Apps Script Sheets looping function

I have a formula that runs a relatively simple calculation to determine the chance of a small list of items being picked out of a larger list. These lists are based on a video game, and are comprised of the names of monsters that the player can be told to go kill for experience points.

The smaller list are monsters that the spreadsheet user is willing to kill, while the larger list is every monster they could be assigned to kill. The chance of each monster being assigned is based on a value and an "Action", and the calculation uses this value and action to ascertain and sum the chances of the small list. This sum must be greater than or equal to 48.4%.

Then the monster with the lowest Experience Points per hour is removed from the small list, and the calculation is run again. This monster is chosen from a third list with experience point information for each task from the small list.

I need a custom function that loops through this process until the calculation returns a number lower than 48.4%, and then return the previous result that was greater than or equal to 48.4%.

Keahlian: Javascript

Lihat lebih lanjut: google apps script email verification, google apps script smtp, email validation google apps script, google sheets for loop, google sheet loop formula, google sheets script, google sheets script editor, google spreadsheet script loop through rows, google script array, google script if statement, google script for loop array, google apps script validation, google apps script api, google apps script attachments forward, google apps script for sheets, google apps script, i am looking for someone to write a google apps script in google sheets, make repairs to google apps script, outsource programming google apps script, google apps script tutorial

Tentang Pemberi kerja:
( 1 ulasan ) Pine Grove, United States

ID Proyek: #18871920

Diberikan kepada:

polarjin2017

Hello? How are you? I have seen the project - "Google Apps Script Sheets looping function." I have been working in these fields((Javascript)) for 7 yrs as a freelancer. I can work full time as you need. I will ne Lebih banyak

$155 USD dalam 3 hari
(31 Ulasan)
5.8

4 freelancer menawar dengan rata-rata $161 untuk pekerjaan ini

sumeet3885

My motto is to provide high quality work and client satisfaction delivered before your deadline. Android | iPad | iPhone | Laraval I React Native I Hybrid app I Bitcoin | E-Commerce | Cryptocurrencies I PHP5 | Magento Lebih banyak

$155 USD dalam 3 hari
(13 Ulasan)
5.2
pindianwebhub

The dear hiring manager, I'm very interested in your job As you can see my profile, I am a expert of web development My Profile : https://www.freelancer.com/u/pindianwebhub I have experience with google app sc Lebih banyak

$184 USD dalam 3 hari
(29 Ulasan)
5.2
WebExpert555

Hi, I have read your description and very interested. Through 8 years, i have rich experiences in web and software development with JavaScript. With my JavaScript skill and experience, your requirement is not pro Lebih banyak

$150 USD dalam 2 hari
(4 Ulasan)
3.3