**** BEGIN LOGGING AT Fri Jun 02 03:00:02 2017 Jun 02 05:25:55 KotCzarny: the guru of commandline. Is it possible to write simple shell script that checks certain cell from .gnumeric file. Multiplies that value and adjusts its functions based to get value. And after succesful ran writes results to same .gnumeric file? Jun 02 05:27:08 hmm i guess im asking if it is possible to get value from .gnumeric file and write values to it. By using shell script. Jun 02 05:34:06 yes, assuming .gnumeric uses text and not binary packed format Jun 02 05:34:21 otherwise you would have to write decoder/encoder Jun 02 05:34:55 if you can pastebin some example file it would be easier to say Jun 02 05:35:59 i don't know which file type it uses, but it is default maemo spread sheet program Jun 02 05:36:10 do you have some example file? Jun 02 05:36:32 it is just a thought now and i wanted to ask if it is even possible Jun 02 05:36:37 i don't Jun 02 05:38:14 https://rdrr.io/cran/gnumeric/man/read.gnumeric.sheet.html Jun 02 05:38:29 seems like there are scripts for that already Jun 02 05:40:06 but if you simply want to hackily change the data set, awk will probably do it, or python, or perl, or php-cli Jun 02 05:40:25 oh. I'll check them to see if they r understandable for me. I managed to make script that asks for user input and it works! Jun 02 05:40:25 and treat things like text with some predefined boundaries Jun 02 05:40:34 :) Jun 02 05:40:38 scripts are fun Jun 02 05:41:08 usually i write a script if i have to do something more than once (ie. data is repetitive) Jun 02 05:42:09 yes i like them too. I use them mostly to avoid writing wrong commands Jun 02 05:42:23 yup, that too Jun 02 05:42:27 extremely important ;) Jun 02 05:42:36 hmm meant long, but works that way too Jun 02 08:08:56 Is you data already have in a spreadsheet and that is why you need to read the spreadsheet? Jun 02 08:23:59 sixwheeledbeast: there would be just one value for script to read and then the script itself would input three different fields in file Jun 02 08:27:55 Maybe consider if doing the work in the spreadsheet is easier than doing the work in the script then. Jun 02 08:30:38 yes, that's where i do it now, but since i need the script for part of the work. I though that script could do all the heavy lifting while i just pick the cherries :) Jun 02 08:31:58 That ssconvert looks useful tho. What is the spreadsheet not doing at the moment? Jun 02 08:43:41 sleeping certain amount of time and using espeak to guide me Jun 02 08:47:53 to sum it up simply. Spreadsheet is my training log and script is my interwall timer. Jun 02 09:54:29 Ah yes, sorry espeak Jun 02 11:49:27 Saera : I can type text in, and receive text-and-speech responses. But Saera doesn't hear me. Even if I have General (not Silent) profile. Jun 02 11:58:26 During the last two or three day, N900 has tendency to shut down suddenly (without LED pattern) in the middle of phone call. Or just say "cellular network not available". Or indicate that SIM isn't inserted. Makes phonecalls a pain, sometimes. Not always, fortunately. Is it hardware problem or software one? Jun 02 12:02:12 dying modem? Jun 02 12:02:42 did it ever boot with yellow 'cellular functions not available' ? Jun 02 12:05:48 Wikiwide: sounds like your battery is dead Jun 02 12:06:02 that's also a possibility Jun 02 12:06:15 gsm voice calls are the biggest power hog if you don't compile gentoo on your n900 Jun 02 12:06:56 and voltage drops on an old liion cell with elevated internal resistance may be huge Jun 02 12:30:43 Boot with "cellular functions not available"? No, I think. Dying battery? Probably, would need to check which one out of three (or so) correlates with these problems (modem is power hungry, did hear about this long ago somewhere). Jun 02 12:32:14 And yes, I think that when I tire of such problems, I consistently switch to a different battery, and problems (however varied) go away. Jun 02 12:55:33 man, i'd love to trade a n900 with working modem for one with 100% dead modem :) Jun 02 12:55:41 as long as wifi etc is still working Jun 02 12:55:45 * buZz tinfoil levels Jun 02 12:55:58 hmm, i have one, want it? no display though Jun 02 12:56:42 hmm i could transfer display of one of mine i guess :) Jun 02 12:56:56 afair it was a donor for another n900 ;) Jun 02 12:57:25 poland eh? not too bad for shipping :) Jun 02 12:58:04 i think shipping something to south africa was ~5usd Jun 02 12:58:16 bubble envelope ;) Jun 02 13:00:21 received a parcel from china yesterday Jun 02 13:00:22 pm'd ;) Jun 02 13:00:40 a couple of wires, paid $1 for it including shipping Jun 02 13:01:01 i wonder if china tries to ddos the global mail system Jun 02 13:03:03 i ordered a ~250 usd electromotor from china with UPS Jun 02 13:03:14 tracking was completely nonfunctional until it was in netherlands Jun 02 13:03:29 makes me suspect they brought it as handluggage on a plane, and just ship it inside .nl Jun 02 13:03:36 to avoid customs :P (was quite effective) Jun 02 18:42:49 i have a dumb question. With tish command "echo "$response * 0.1" | bc" i get the result of multiplication of my set value, but im struggling to get that script to read and use that value Jun 02 18:43:12 this* Jun 02 18:44:14 $() Jun 02 18:44:22 i've tried > $result, but i just got complain of missing directory Jun 02 18:44:49 google about the posix shell syntax Jun 02 18:44:57 ok Jun 02 18:52:21 buZz: my n900 has the sim not found error Jun 02 18:52:33 otherwise i's working Jun 02 18:54:02 ret=`echo "$response * 0.1"|bc` Jun 02 18:54:06 echo $ret Jun 02 19:01:03 KotCzarny: sleep: invalid number '9.0' Jun 02 19:01:32 but at least it passes the number at the right place :) Jun 02 19:01:34 want good solution or hacky solution? Jun 02 19:02:00 well i would like to understand how this works Jun 02 19:02:02 some sleep versions accept floats Jun 02 19:02:50 if you have busybox you can try: busybox sleep 9.0 Jun 02 19:02:58 so it seems maemo's version doesn't Jun 02 19:03:04 buZz, I'd like to send you mine Jun 02 19:03:04 hmm lemme try bash Jun 02 19:03:53 same thing with bash Jun 02 19:04:41 got busybox? Jun 02 19:04:50 ok so float number is not supported Jun 02 19:05:05 busybox is default? Jun 02 19:05:38 it is 1.10 Jun 02 19:06:03 then try: busybox sleep 1.5 Jun 02 19:07:41 invalid number Jun 02 19:09:11 all the shells are notoriously bad at floating point math Jun 02 19:09:27 bc is the usual savior Jun 02 19:10:02 or dc if you're into rpn Jun 02 19:11:04 im reading about rounding the number in bc Jun 02 19:12:20 ret=`echo "$response * 0.1"|bc|sed -e 's/\..*$//'` Jun 02 19:12:22 ;) Jun 02 19:12:24 https://img.pr0gramm.com/2017/05/21/ae9903e0241449da.jpg Jun 02 19:12:27 that's hacky solution Jun 02 19:12:44 equivalent to floor() Jun 02 19:12:45 KotCzarny: i was about to suggest this but you need to add 0.5 to the result first Jun 02 19:13:00 yup Jun 02 19:13:16 ret=`echo "0.5+($response * 0.1)"|bc|sed -e 's/\..*$//'` Jun 02 19:16:02 why 0.5 needs to be added? Jun 02 19:16:07 rounding Jun 02 19:16:14 otherwise you get always floor() Jun 02 19:16:25 ie 0.1..0.9 -> 0 Jun 02 19:16:29 ah Jun 02 19:18:28 k now it works Jun 02 19:19:36 thanks Jun 02 19:19:53 i spent few hours trying to figure this out on my own Jun 02 19:20:13 that's good, you've learned much during that time Jun 02 19:20:18 even if you didnt solve it Jun 02 19:21:13 yeah i hope :D Jun 02 19:23:20 so, what ret is about? Jun 02 19:23:28 hmm? Jun 02 19:23:35 or it is just used as in my case? Jun 02 19:23:51 i mean does it have other funtions or use cases Jun 02 19:23:58 functions* Jun 02 19:24:00 it's just for showing how to populate a variable Jun 02 19:24:15 aha Jun 02 19:24:28 some_variable=$( echo "0.5+($response * 0.1)"|bc|sed -e 's/\..*$//' ) Jun 02 19:24:57 you can also use it directly ie: sleep $( ... ) Jun 02 19:25:59 oh, that's cool **** ENDING LOGGING AT Sat Jun 03 03:00:01 2017