Topics

76

Living Room / How to automatically generate reports based on xls files?

« on: February 18, 2019, 10:17 AM »

Hello!

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.

Thanks!

77

Living Room / Whatsapp functionality from PC

« on: November 26, 2018, 01:06 PM »

Hello!

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?

78

Living Room / How to find the file of a saved Snapchat video?

« on: November 22, 2018, 06:15 AM »

Hello!

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.

Thanks!

79

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

« on: November 21, 2018, 05:01 AM »

Hi

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

80

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

« on: November 13, 2018, 02:56 PM »

Hello!

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.

Thanks!

81

Living Room / How to find the math relationship/graph between one or more variables...

« on: November 01, 2018, 04:55 AM »

Hello!


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.

Thanks!

82

Living Room / My first excel macro

« on: October 09, 2018, 09:48 AM »

Hello!

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?

Thanks!

83

Living Room / Problem for very strong brains

« on: October 05, 2018, 05:26 PM »

Hello!

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.

Thanks!

84

Living Room / Any maths genius?

« on: October 01, 2018, 02:00 PM »

Hello!

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?

thanks!

85

General Software Discussion / Trickiest EXCEL formula problem ever!

« on: September 28, 2018, 10:53 AM »

Hello!

I have a row with dates that are start of weeks ongoing. Below that, I have one row with numbers. Below that, I have a row that I want to fill in with a formula.

In an independent cell, I input a date. Then the formula I want to fill in, checks if the date is future/past of the date at the top row in the same column. If future, it fills the cell with zero.
The problem is what I want it to do if the date is past.

I want to display the ratio of the number above in the middle row and the same column, with respect to the sum of the middle row numbers. The tricky bit is what exact sum I want it to consider.
I want the sum of the first cell in the column that the bottom line cell is not zero, up to the end of the row.

I need somehow to reference and store in a variable that. Or somehow calculate that ratio, considering the right sum, which is fixed once defined, but it is defined by the first cell that gets a non zero value.

I don't want to do this with a macro as I don't know anything about macros. Any help?

Thanks!

86

General Software Discussion / Is it possible to group names by fuzzy logic?

« on: September 26, 2018, 11:07 AM »

Hello!

My data has several client names. It is very often that there are several names of the group of one client.

For example, Batavia Insurance, Batavia Fund, etc probably belong to the Batavia group.

It would mostly work if I match the first word, so how could I write an Excel function to group/count entries that their cell has the same first word?

But it is not 100% safe, eg when you have PT Batavia Company and a prefix kills your algo.

I know it will never be 100% accurate, but do you have any idea how to approach this?

Thanks!

87

Living Room / How to model this?

« on: September 24, 2018, 04:56 PM »

Hello,

I want to model the processing of some cases, so I know the process time of each case and the number of employees, so I can find the end date.

However, depending on the deadline, the cases may need to be reprocessed every a fixed number of months, so that the total number of cases may increase depending on the end date.

How can I model this? I find difficulty because the number of cases to be reprocessed affects the end date, but also the end date affects the number of cases to be reprocessed!

Any idea?

Thanks

88

General Software Discussion / Big Data tools

« on: September 14, 2018, 09:47 AM »

Hello!
Is there a 'free for commercial use' software that opens and processes with regex large text files of 20GB?
Thanks!

89

Living Room / Label printer

« on: September 05, 2018, 04:37 PM »

Hi!

I want a very cheap and very compact solution to print return labels when I am returning goods bought online.

Is there anything like that?

A normal printer can be cheap but it is too big. Some portable printers are more compact but very expensive for the use I want.

It doesn't have to be A4, it can much smaller!

Any idea?

Thanks!

90

General Software Discussion / REST API

« on: August 09, 2018, 02:43 PM »

Hello!

At work, they have a difficult to send a curl command to server via Rest API in order to download some data.

Having used before wget, I thought that this curl command would be something easy so upon saying that, now everyone expects me to do it.

Is there any tutorial that can enable me to do that? I have no clue.

Thanks!

91

General Software Discussion / Extract REGEX matches from multiple text files

« on: August 03, 2018, 04:14 AM »

Hello!

Which tool/scripting language can I use to match REGEX strings and extract them to a new file or to just delete the non matching strings from multiple text files?

It would help to be easy to write as I cannot learn complicated syntax!

Also, ideally it should work via command line as I am talking about many many files which can be huge.

Thanks!

92

General Software Discussion / How to extract tree hierarchy in xml?

« on: July 25, 2018, 08:09 AM »

Hello!

You know that xml files are hierarchical, ie there is a top level attribute, then sub-attributes are indented and so on.

How can I copy the hierarchy, ie the upper level attributes of a selected attribute/line?

For example:

<a>
     <1>
     <2>
           <x1>
           <x2>

I want to select x2 and copy the hierarchy of it, ie the upper level attributes that x2 belongs to:
<a>
     <2>


Any idea?

Thanks!

93

General Software Discussion / How can I find approximate matches of numbers?

« on: July 12, 2018, 10:45 AM »

Hello!

I have two lists with numbers. How can I find how many pairs there are between those two lists (ie similarity), where each pair is the number from second list that matches +/-5% to a number in the first list?

Thanks!

94

Living Room / Current technological and social challenges

« on: July 01, 2018, 11:39 AM »

Hello!

Can you list please current technological or social challenges that need addressing?

I want to submit to an innovation competition, but I cannot pinpoint specific problems to focus on.

Thanks!

95

Living Room / Fix screen orientation

« on: June 22, 2018, 11:41 AM »

Hello!

How can I disable or permanently fix my touchscreen rotation of my Lenovo Yoga 13 please?

There seems to be a hardware (or software) problem that makes my laptop start with disoriented screen.

Thanks!

96

Living Room / How to move forward with an idea?

« on: June 09, 2018, 05:07 PM »

Hello!

I have a revolutionary idea for a medical device. I have researched its components and how it would work, although it is in very early stages as an idea.

How can I get help to develop it further and maybe commercialise it?

I don't have any money to invest, but I am willing to give percentage of my rights to have it researched further.

Any idea?

Thanks!

97

Living Room / Basic banking issues

« on: May 15, 2018, 10:00 AM »

Hello!

I have some banking interviews and I would like some resources. Unfortunately while there are tons of info on the web, I find them either too basic or too technical. Some forums or banking recruitment are hideous (probably people feel competitive and they don't support).

Can you tell me please where I can find comprehensive information about issues like:
1) What factors affect risk of mortgages?
2) What would you check before giving a loan to a corporation?
3) How would you value a corporation?

Thanks!

98

Living Room / Help with laptop

« on: May 11, 2018, 04:55 PM »

hello guys!

I have a serious problem with my Lenovo Yoga 13 (first model) and I would really be grateful if you can help me solve it so that I won't have to waste £500 for a new laptop.

Basically, it's a convertible with touchscreen, and now I that restarted it, the screen shows as an A4, ie the screen is rotated 90 degrees!

I am worried that it is damaged because it fell few days ago, but it didn't behave like that immediately after.

Any idea??
Can I just completely disable screen rotation or something?
Thanks!

99

Living Room / Data connection through audio jack

« on: May 01, 2018, 04:24 PM »

Hello!

I bought a watch with MP3 player. It came with a cable that in its one side it has a male usb plug and in its other side it has a male 3.5mm audio jack.

Are you supposed to use this cable to connect it to your laptop and 'download' the audio files of the watch to your laptop?

I have never done something like this and I wonder if it is possible with such cable.

There is no other port on the watch.

Any idea?

thanks!

EDIT: to prevent questions, obviously I tried and nothing is recognised from my Win8.1, should I expect a 'new usb drive found' balloon? or anything else?

100

Post New Requests Here / Can AutoIT work like http://rammichael.com/7-taskbar-tweaker

« on: April 25, 2018, 12:56 PM »

Hello!

I like http://rammichael.com/7-taskbar-tweaker but they found out at work that I use it and they blocked it.
However, we are allowed to use AutoIT!

Is there a chance to use AutoIt to close taskbar buttons with right click, show desktop with single click on empty taskbar and open Task Manager with double click on empty taskbar?

Last time I tried to make it work, it didn't.

thanks!