Search results for query: *

Any insight as to the resolution of a status code of 401 using the R code below? Attempting to generate an oauth token. Thanks in advance. library(httr) base64_value <- "123456789=" response16 <- httr::POST (url = "https://api.precisely.com/oauth/token" ...

Appreciate some timely insight! Novice - first time attempting to extract data via an API. I obtained a API Key and the Secret. Converted to base64. Now perplexed as to the next step where the instructions that I have state that I should "Enter the generated base64value in the header and...

Just had a thought - It is maybe best to just use four cell references or four dynamic range names within each formula instead of the hardcoded dates...

Did create formulae similar to the following; Sum up prior 6 months in 2021 (not including the current month) =SUMIFS($H$7:$H$186,$G$7:$G$186,"="&$P$11,$B$7:$B$186,"="&$P$10,$L$7:$L$186,">="&DATE(2020,12,1),$L$7:$L$186,"<="&DATE(2021,5,31)) Sum up the same 6 month period in 2020...

Thanks for the insight. Initial response is that the sumproduct formula for the prior year will still include "DATE(YEAR(TODAY())-1", right? If the Sumifs prior year formula is not currently working by using "DATE(YEAR(TODAY())-1", maybe there is another method to specify the prior year -...

Thinking this through, using the EDATE function may be the way to go due to maybe limitations with using Year(Today) and Month(Today). Other option is to just input the actual dates and move forward.

Continuing to review and did determine that the last row of data is on row 31, not row 30. However, the formula to display the prior years' sum is still not displaying the correct nummber of 33, not 26 as originally stated. Note, the last number should be "7", not "4." So, by including the...

Thanks for the time and insight. The second formula should work and the sum should be 26 not 59. I intentionally did not include the current month. In essence, a lag is applied. At any time during the current month, I want to review the past 6 months and compare to the same period the prior...

Using Sumif to dynamically sum the values in column C for a 6 month prior period for the current year, 2021. Formula is correct - the sum for the desired months is displayed...

Timely insight needed! Have a HP Elite Book with Windows 7 Professional 64 Bit loaded and cannot log into windows for the past three days Ton of information on the laptop! Have attempted the following to no avail; Safe Mode Safe Mode with Command Prompt Enable Boot Logging Each time, I am...

Timely insight needed to create a formula to calculate the percent change between two estimates that also should consider the margin of error for each estimate. I am told that the estimates are for two non-overlapping time periods. The MS Excel 2016 worksheet include the following seven...

I misspoke. The data is delimited but it was not parsed. After some thought, I decided to resolve the immediate objective from a different angle. I just compared the number of commas within each record with the number of colons. If there is a difference, then I know that there is a field...

On a weekly basis, I receive over 2500 non-delimited records with the following format whereby all of the data is in column A. equip_type:"C","seller":"SampleSeller LLC","buyer":"SampleBuyerCorp","address":"1000 Main...

Timely insight needed! I have a MS Excel workbook with more than 40 worksheets. The worksheet names correspond to the account numbers in column C on Sheet 1 beginning at row 10. Note, column C contains the formula "=MID(Trim(D10),1,6) For Example, In column C at row 10 are the following...

I currently do not have any control on the design of the workbooks. Actually, there are over 25 worksheets! For this example, I indicated that there are 3 worksheets just to simplify. I will apply the logic accordingly to my actual case. Really think that this is a rather complex formula...

Have an MS Excel 2017 workbook with three worksheets; "Combined", "Widgets", and "Washers." Each worksheet has four columns; AccountNo ItemNo Estimate_Iter1 Estimate_Iter2 Worksheet "Widgets" has data such as this; AccountNo ItemNo Estimate 5002056 500010 $650,000 5002056 500060...

Have MS Excel worksheet with approximately 50,000 records that have a column (column AC) containing abbreviated numbers such as $100K. I would like to convert the data within this column to the long format such as 100000. Have tried several approaches including the following; Creating two...

Well review in detail. Meant to imply that designating a composite primary key ("Equip Code" , "Mth", and "Sales Price Level") for this "new aggregated table" would appear to be preferable instead of setting up a incrementing ID field. Particularly, since I will add data on a monthly basis...

Appreciate the insight. Vaguely familiar with CTEs. Will research further. It appears that then loading into a Sql Server table and using a composite primary key of "Equip Code" , "Mth", and "Sales Price Level" will enable the unique identification of each record rather than an arbitrary id...

dhookum, Due to the confidentiality and volume of the data, I provided a subset of the data. Per additional review, it really appears that I eventually need to create a cube using SSAS or possibly create a cube using MS Excel. For now, a SQL only solution would be sufficient. Considering the...