9,541 reputation
31523
bio website
location Australia
age
visits member for 4 years, 4 months
seen 8 hours ago

1d
awarded  Caucus
Apr
15
comment Excel: deleting duplicate records based on an int value
Do you want to really want to delete the duplicates with the least field value or do you want to find the maximum field value? The latter is easily achieved using a pivot table.
Apr
15
comment Starting multiple video files on multiple computers simultaneously
Operating system? Playback software? Tolerances? What have you tried?
Apr
15
answered Macros to parse excel data
Apr
13
answered How to split video to 3 parts by ffmpeg?
Apr
10
answered How to split bulk video fast by using ffmpeg?
Mar
25
answered In Excel, how do you do custom number formatting so that it has leading blank spaces?
Mar
24
awarded  Nice Answer
Mar
23
comment How to calculate monthly sum from the entries for each date in Excel?
You should create a pivot table and group the dates by month.
Mar
16
answered VLOOKUP with string returning #REF
Mar
6
comment I want to stamp every single print, how can I do that?
Pre-printed stationery.
Mar
3
comment ZFS vs existing filesystem for SD-card
That might be feasible but RAIDZ will increase the amount of writing to the SD card which may reduce their lifespan. If the data won't change often this this might not be an issue. Personally I wouldn't go down this path. If I was going to use ZFS on SD cards then I'd use simple ZFS pools and use two cards, each an independent copy of the other (synced occasionally with rsync or zfs send). If any bit rot was detected with zpool scrub then I'd simply copy the offending file(s) from the other card.
Feb
25
comment ZFS vs existing filesystem for SD-card
Assuming that ZFS can operate on an SD card (I don't know) then it will be able to detect bit rot but it will only be able to repair it if your SD card is part of a redundant pool (multiple SD cards?) or you have set copies=2 on a non-redundant single-drive pool.
Feb
5
revised Running ZFS as MediaStorage with non ECC-Ram
removed redundant word
Feb
5
answered Running ZFS as MediaStorage with non ECC-Ram
Feb
4
answered Excel If Statement always shows false
Feb
3
answered How can I render 3D objects from a list of triangular coordinates?
Jan
22
comment FreeBSD 10 Hangs on CD Loader
I had no such issue with the amd64 version of the DVD. Maybe you could try the memstick image if your hardware supports booting from a USB flash drive.
Jan
22
answered sorting values within a cell in excel
Jan
6
comment Outlook overlay alignment
Yes, that's much clearer thanks - I've removed my downvote. Unfortunately I don't have an answer for you.