avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • October 20, 2019, 12:43 AM
  • Proudly celebrating 13 years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - kalos [ switch to compact view ]

Pages: prev1 [2] 3 4 5 6 7 ... 70next

Got new phone, is there an easy way to transfer my settings/apps/data?


Living Room / How to calculate the area of a graph?
« on: March 05, 2019, 05:51 PM »

I have this graph and I want to calculate the amount in grams of glucose that is above the straight line of 100mg/dl for the whole period of about 5h.


I think I need to calculate the area of the triangle, but this will give me a unit of mg/dL x hours which does not make sense.

Can anyone advise me please?


Living Room / Re: Is there any compact portable browser?
« on: March 02, 2019, 03:38 PM »
QtWeb was a good option but it is not updated any more


Shall I assume that Powershell is the best tool to do the above?

I want to copy specific cells from specific sheet in a specific excel document, into a word document, format it properly and email the formatted text to a specific email address at specific time every day.

Is it going to be huge coding to do that?

Can I do all these within MS Office?

Any hints?

Living Room / Re: Looking for smartphone
« on: February 26, 2019, 03:21 PM »
What are the top 3-5 cheapest mobiles with NFC and >5000mah?
Any idea?

Any suggestion for the best phone with longest battery and NFC?

Any updates on the above?

Living Room / Is there any compact portable browser?
« on: February 25, 2019, 07:59 AM »

Is there a compact portable browser?

I use Palemoon and its 160MB are too many for my space allowance.


Living Room / Re: Any VBA experts?
« on: February 24, 2019, 10:45 AM »
I have a sheet with lots of formulas and text called TEMPLATESHEET. This sheet is stored in a TEMPLATEWORKBOOK.

When I open any xls file, I want a macro that will insert to the active workbook, the TEMPLATESHEET.

However, the TEMPLATESHEET, has some formulas that refer to a sheet called REFERENCESHEET.

So, when the xls file I open has a sheet with the same name, REFERENCESHEET, I want the formulas for the TEMPLATESHEET to link to the REFERENCESHEET.

Would that be possible? I may have to search-and-replace the #REF of the TEMPLATESHEET to match the REFERENCESHEET, unless the TEMPLATESHEET will preserve the references and have them working.

I don't think there is more info than that available.

Living Room / Any VBA experts?
« on: February 22, 2019, 01:25 PM »

I have an Excel sheet with formulas and text in hundreds of cells.

Is there a way to click a button and add this sheet to the active workbook, in any xls file I have opened?

Some formulas refer to a sheet with a specific name, so when this sheet is present in the workbook, the formulas must work.


I cannot find how to do this:

Range("A1").Formula = "This is some text ",TEXT((COUNTIFS(UDE!$AC:$AC,"Low",UDE!$G:$G,"High")+COUNTIFS(UDE!$AC:$AC,"MLD",UDE!$G:$G,"High"))/COUNTIF(UDE!$G:$G,"High"),"00%"))"
Range("A1").Formula = "=CONCATENATE("This is some text ",TEXT((COUNTIFS(UDE!$AC:$AC,"Low",UDE!$G:$G,"High")+COUNTIFS(UDE!$AC:$AC,"MLD",UDE!$G:$G,"High"))/COUNTIF(UDE!$G:$G,"High"),"00%"))"

Neither works, any idea?

So far I plan to write a macro in excel that will create a new sheet and populate some cells with the formulas that calculate the numbers I want.
Then, I suppose I can use Mail Merge to grab the numbers from these cells and populate the report.

Would that be the best approach?

Or is it possible to do easily everything with Powershell or Word or Excel only?

I don't want you to do the job, I want to learn.

Ideally, I would like to make use of Excel Functions, e.g. use the COUNTIF, INDEX/MATCH etc to find the numbers I need.


I have an MS Word document that I want some fields to be pulled from an xls file stored in a server.

For example:

1) a field would be the total number of lines of the xls apart from the header
2) a field would be the number of lines that the field under a specific header is the same as one or two values
3) a field would be the percentage of the above number of lines to the total number of lines

Do you know how to implement these? Is there an easy way?
I can do it in other tools if more easy, but they have to be part of MS OS, like Powershell, MS Office, etc.


Fwiw, K-9 Mail for the app.

Absolutely seconded.  I've used K-9 mail since getting my first Android phone about nine years ago.  Love it.

Thanks will try it.
Do you get interruptions or asking for password when Ymail messes up with updates?

Living Room / Whatsapp functionality from PC
« on: November 26, 2018, 01:06 PM »

I want to send text messages to numbers from my PC via Whatsapp.

The problem is that you need to create a contact first in your phone to be able to send a whatsapp message.

I want to ideally paste the number, type the message and click send. I am sending several messages as I am doing room hunting at the moment. Sending text messages is not as reliable and I want to be able to see when the recipient views the message etc.

Is there any solution?

Living Room / Re: How to find the file of a saved Snapchat video?
« on: November 22, 2018, 12:23 PM »
It was accidentally in a folder, got it thanks!

Living Room / How to find the file of a saved Snapchat video?
« on: November 22, 2018, 06:15 AM »

How to find the file of a saved Snapchat video?
Search results only show how to save a video someone sent you on Snapchat.

Also, how do I start camera in RedMi Pro 3 since the icon has been deleted? Also how do I restore the icon?
Search results only show camera tricks.


Living Room / Android and web app for unified inbox?
« on: November 21, 2018, 08:17 AM »

Is there a good Android app that has also web interface/app to access email accounts mainly Ymail, Gmail, Microsoft Exchange?

I am looking for one that is not blocked by my admin and it also has reliable and fast updated Android app, as ymail for example implement changes all the time and they interrupt their email function.

Ymail app does not accept MS Exchange mails and it is also blocked by my admin.
MS Outlook web app is not blocked but it is very slow using PaleMoon.
Gmail web is also blocked.

Any other proposals?



Is it possible to have Microsoft Exchange account to Ymail Android app?

Living Room / Is there a way to easily carry earphones for my mobile?
« on: November 13, 2018, 02:56 PM »

Is there a way to easily carry earphones for my mobile?

I have bought some in a case but I would be interested in the minimal volume possible.


Yes, MiniZinc.

Here is a tutorial for using it to solve a LP problem:

And two courses to dig deeper:
- Basic Modeling for Discrete Optimization
- Advanced Modeling for Discrete Optimization

Thanks that looks very interesting!
Does it work within excel or can I copy/paste my excel model? Or is there anything similar that will work within Excel? I tried Solver but it doesn't seem to work :(
If I have to build it from scratch using that language it will be a nightmare!

To understand which variable has the highest impact you can use regression analysis and ANOVA.

Assuming it is a linear process you can use linear programming for optimization. If not, you can look at other mathematical optimization models.

If I remember correctly, Excel has built-in solver for linear programming but it has to be activated.

Yes, I used Solver but it is very limited.
Is there a better tool?


I have a complex model in excel. Among other parameters which I want to keep constant, I want to find the effect of each of four cells that contain variables (with some constrains) to a cell that is the result cell.

I want to find the optimum (minimum) four values to achieve the result I want and also find which of these four variables has the most significant effect on the result cell.

To give you some context, there are four teams that work in a very complex way and the four input cells are their employee number. The output cell has the end date of the project that is calculated with very complex way. How can I find which team is more worth to hire and how many?

Any idea? I am open to any freeware tool, etc.


Living Room / Re: My first excel macro
« on: October 09, 2018, 04:22 PM »
What I am asking is not a google search and I don't have the time now to read a whole tutorial

Living Room / My first excel macro
« on: October 09, 2018, 09:48 AM »

I want to write a macro in Excel that will use the 'Goal Seek' analysis.

The code is something like that:

Range("Q27").GoalSeek Goal:=0, ChangingCell:=Range("B10")

As for input cell (ChangingCell), when the macro button is pressed, I want to consider the active cell. How can I do that?
As for the goal seek cell, I want to a formula to calculate it based on other cells values.

Any hint?


Pages: prev1 [2] 3 4 5 6 7 ... 70next