excel vba - How to sum all the digits in a paragraph (text in a cell)? -


I have an Excel sheet (see image below)

To do this, add all the values ​​of the cells in column 'C' and the value in the respective cell in column 'B' (in my example - 1 + 0.25 + 0.25 + 1 = 2.5). Depending on the input given by the team, the value of column 'C' can change dynamically. As a change in the cell of 'C' column, there is a need to get the requirement to automatically update the value in 'B'.

I tried to ask the producer to change the spreadsheet format

Any help would be greatly appreciated.

Regards, - Ashish

Using this macro, the text in the cell Can be obtained without changing. I have to admit that the implementation will be slightly dim because you need to do some things.

1 - Bring the contents of the entire cell to the token, and store the tokens in the string array.

A problem already exists in the text inside the cell is very inconsistent. You have -250 ms, - 250 ms, - 1 sec, - 1 second due to this, you will need to check for each example. Therefore, you can not just check that the value is a number, you need to check all the permutations that have been provided to you members of your team.

The best way to do this is to have regular expressions. Therefore, should be # 2:

2 - Check each value to see if it matches one of the many 4 regular expressions.

3 - Depending on reggae, numeric value.

a) If just a value (i.e.> 250), check whether MS or sec comes out of value if MS divides by 1000. If the seconds is the same as leaving the number. Add the total number. B) If any number is first (-) dash, delete the dash, and repeat steps a)
c) If after a number letters, remove the letters and repeat steps a)
d) if any duration If after a period, do not do anything. This is a bullet point.


Comments

Post a Comment

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

I'm having trouble overriding a ModelForm save method. I get this error I'm: Exception type: TypeErier Exception Value: Save () found an unexpected keyword argument 'committed' My intentions include a form 3 fields Submit several values ​​for, then create an object for each combination of those areas, and to save each object file models.py class collarsult type (models.Model): id = model. AutoField (db_column = 'icontact_result_code_type_id', primary_key = true) callResult = models.ForeignKey ( 'CallResult', db_column = 'icontact_result_code_id') campaign = models.ForeignKey ( 'campaign', db_column = 'icampaign_id') CALLTYPE = models.ForeignKey ( 'CALLTYPE', db_column = 'icall_type_id') agent = models.BooleanField (db_column = 'bagent', default = true) teamLeader = models.BooleanField (db_column = 'bTeamLeader', default = true) active = models.BooleanField (db_column = Django.form...
Read more

html - CSS autoheight, but fit content to height of div -

I have a div in which there are three children- div in the left and middle div: float: left while true: float: true because it is my layout Actually will spoil, I've used ClearFix Hack: .cf {zoom: 1; }. Cf: First,. Cf: {content: ""; Display: Table; }. Cf: After {clear: both; } It still works, but I want to be the right div an indicator. So it should fill 100% of the parent unit of height. How can I complete this? PS is the full code: & Lt; / Div & gt; & Lt; Div class = "mobile_content" & gt; & Lt; H5 & gt; {{Data.titel}} & lt; / H5> & Lt; Table & gt; & Lt; TR & gt; & Lt; Th & gt; Komponist: & lt; / Th & gt; & Lt; TD & gt; {{Data.komponist}} & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Th & gt; Instrument: & lt; / Th & gt; & Lt; TD & gt; {{Data.instrumente}} & lt; / TD & gt; & Lt; / TR & gt;...
Read more

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -

I have been trying to use Qt5 multimedia to record audio with QAudioInput, however, when I see If QAudioInput is started, it increases the master volume of my sound device to 100%. How can I prevent QAudioInput from changing the master volume? My current development platform is Linux with PalsAdio (with flat audio disabled). How can I use QAudioInput : QAudioDeviceInfo device_info = QAudioDeviceInfo :: defaultInputDevice (); QAudio format format; Format.setSampleRate (44100); Format.setChannelCount (1); Format.setSampleSize (16); Format.setCodec ("Audio / PCM"); Format.setSampleType (QAudioFormat :: SignedInt); Format.setByteOrder (QAudioFormat :: LittleEndian); Std :: cout & lt; & Lt; Device_info.deviceName (). ToUtf8 (). ConstData () & lt; & Lt; Std :: endl; QAudioInput * default_device = new QAudioInput (device_info, format); QIODevice * default_io_device = default_device-> Start (); a QAudioInput.setVolume () method is not you I ...
Read more