avatar image

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

Login with username, password and session length
  • October 17, 2019, 11:56 PM
  • 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.

Topics - kalos [ switch to compact view ]

Pages: [1] 2 3 4 5 6 ... 20next
Living Room / Android annoyances
« on: October 10, 2019, 08:07 AM »

Do you know any solutions to the below Android annoyances please?

1) I very often accidentally switch on the Google Assistant, how do I completely disable or uninstall it? I don't find any value in using it and it has some very basic shortcuts that interfere too often.
2) How can I set the phone not to dim the screen when a specific app is running?
3) How do I set the phone to always mute a specific app? There is an app that has annoying ads that have sound and I want to stop this.


Living Room / Windows 10 Versions: Education, Education N, 1809, 1903
« on: October 02, 2019, 03:48 PM »

I can download Windows 10 from the university and I am offered the following versions:

Education 1809
Education N 1809
Windows 10 1809
Windows 10 (consumer editions) 1903 - DVD

Which one should I choose? What are the differences? Which is the most 'advanced'?

Also, do I download it and run it as installer to update my Windows 8.1? I do not want to erase anything.

Will it say if my laptop is not compatible?


Living Room / Free call recorder for Android
« on: September 12, 2019, 02:02 PM »

Is there any free reliable call recorder for Android to automatically record and store the audio of all calls?



I like the idea of the whole mobile phone screen to be a fingerprint sensor.

However, I read somewhere that you need to click on specific area of the screen and you need to wait for a percentage to go to 100% before you lift your finger.

Is that the case for every such phone?

I want it to work really fast.



The left button goes back and the right button opens the task manager.
Is it possible to switch them?


Living Room / Any good free android scientific calculator?
« on: June 27, 2019, 01:43 PM »
I used to have PowerCalc but it seems is no longer available.
I would like it to be fully scientific and to show parentheses.

Any idea?


When I click to make a voice call in Whatsapp, it displays an annoying message 'do you want to start a voice call?'.

How can I disable this?


Living Room / Monitor Web Usage
« on: June 06, 2019, 09:47 AM »

A department at work has several employees and they work on processing files on a sharepoint website.

I want to track how long they take viewing/working on a specific webpage to measure productivity.

Do you know an easy IE plugin to log webpages/urls and time spent on them?

Or could I do that at the network level e.g. with a sniffer or something (I do not have such access though)?



Which screen spec is the most important for less eye tiring viewing?

A phone has high contrast but low pixel density and I wonder which is more important given that I read alot on the screen and my eyes get tired. Or anything else I should look for?


Living Room / Anyone knows Tableau?
« on: March 29, 2019, 07:07 AM »

Anyone knows why the below calculated field in Tableau does not work?

IF [A]='4'
AND ([X]='F'
OR [X]='D'
OR [X]='G'
OR [X]='B'
OR [X]='D'
OR [X]='R')

Any idea please?

Living Room / Is there a way to ping a remote desktop?
« on: March 21, 2019, 06:21 AM »

I log in to a remote desktop via Citrix and after some inactivity it locks itself.

Is there a way to auto-ping regularly it so that it stays active?



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?



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 / 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 / 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 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.


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 / 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.



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.



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 / 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?


Living Room / Problem for very strong brains
« on: October 05, 2018, 05:26 PM »

I have a problem that seems so common yet so tricky to manage. I wonder if there are any process tools or other methodologies to approach it. I would also like to generally discuss it and brainstorm.

I have 1000 files. I have a waterfall process of five steps that each file needs to go through one after the other.
Each of the five stages has its own speed (eg 5h per file, 10h per file etc), based on the average time of processing per file and the number of people available to process files in that stage.
You have a number of files to be processed (through all the stages) by a specific deadline.

How can you allocate the resources (people) to complete the files in the shortest time?
The tricky bit is that a specific number of people can do stage 1 and 3 only, and the rest can do stages 2, 4, 5 only.

To add to the complexity, you have additional bunches for files with different deadlines, let's say 2000 files to be completed three months after the first deadline and 5000 five months after the first deadline.

Any opinions?
I have some ideas but would like some input first.


Living Room / Any maths genius?
« on: October 01, 2018, 02:00 PM »

I have 1000 files. Each day, 250 files are processed. Out of the processed files, 20% get completed. Out of the processed files, 80% files need reprocessing and they restart from the beginning, but after second processing, they get completed.

How can I model this in excel to show the decline of files to be processed per day? In a function, that I can drag to generate the sequence?


Pages: [1] 2 3 4 5 6 ... 20next