Understanding the Results of an Array Formula

I am trying to mend / understand a workbook an old employee made. I have used the Evaluate Formula feature but am still really struggling to understand the formula. The formula is – =IF(INDEX(Grp2.Customer.Table,Grp2.Cust.Numb,1)IF(Year.Numb=1,Laun.Yr.Start,INDEX(Year,1,Year.Numb-1)),1,0),0) E65 = 1, E66 = 0. But what I am seeing when I am evaluating the formula, suggests to me that…

Details

Bootstrap – float right and float left error

I am trying to position this user response to right and a friend to the left (“isFriendOrSender(mesChild.sender)”). The problem is, when i try to use pull or float, elements on the page affect on each others width. <div class=”container padding “> <div class=”row”> <div class=”col-lg-8 col-md-8 col-sm-8 heightUL”> <div #scrollMe class=”card w-100 h-100 overflow-auto” [scrollTop]…

Details

Characters incorrectly translated from Morse Code to English

I started to translate Morse code to English and there is an issue. Here is my code: morse_dict = { ‘a’: ‘.-‘, ‘b’: ‘-…’, ‘c’: ‘-.-.’, ‘d’: ‘-..’, ‘e’: ‘.’, ‘f’: ‘..-.’, ‘g’: ‘–.’, ‘h’: ‘….’, ‘i’: ‘..’, ‘j’: ‘.—‘, ‘k’: ‘-.-‘, ‘l’: ‘.-..’, ‘m’: ‘–‘, ‘n’: ‘-.’, ‘o’: ‘—‘, ‘p’: ‘.–.’, ‘q’: ‘–.-‘, ‘r’:…

Details

“Plugin/Preset files are not allowed to export objects, only functions” with Webpack & Babel

Here is the error I am getting. This is different from other similar questions because every bloody project is different and there isn’t a cure-all solution just because some lousy algorithm says my question is similar to another question, Just because the questions are similar does not mean the solutions are identical!!! ERROR in ./client/index.js…

Details

How to get App service environment ID to use in App service plan in terraform

Can someone help in deploying App service environment using ARM template. { “apiVersion”: “2019-02-01”, “type”: “Microsoft.Web/hostingEnvironments”, “name”: “[parameters(‘aseName’)]”, “kind”: “ASEV2”, “location”: “[parameters(‘location’)]”, “properties”: { “name”: “[parameters(‘aseName’)]”, “location”: “[parameters(‘location’)]”, “InternalLoadBalancingMode”: “[parameters(‘ilbMode’)]”, “virtualNetwork”: { “Id”: “[parameters(‘subnetId’)]” } }, “tags”: {}, “dependsOn”: [ “[‘existingVnetTemplate’]” ] }, How do i get the ID of App service environment(Hostingenvironment) in this…

Details

Get array of all words (splitted sentences) inlcuded in another array

i have this array: this.places = [{“full_name”:”joe”,”title1″:”teacher”,”description”:”the best teacher”}, {“full_name”:”mary”,”title1″:”student”,”description”:”great student”}]; i need to get this: this.items = [{“word”:”joe”},{“word”:”teacher”},{“word”:”the”},{“word”:”best”},{“word”:”teacher”}, {“word”:”mary”},{“word”:”student”},{“word”:”great”},{“word”:”student”} ]; i have this now: this.places.forEach(item => { this.items = results.concat(item.full_name.toLocaleLowerCase().split(” “)) .concat(item.title1.toLocaleLowerCase().split(” “)) .concat(item.description.toLocaleLowerCase().split(” “)); }); result: [“joe”,”teacher”,”the”,”best”,”teacher”,”mary”,”student”,”great”,”student”]; can you help me to get the complete final desired array?

Details