Video

Lake Wakatipu, Queenstown, New Zealand live stream at czcams.com/channels/GP7e3KMbM8fi70Te_wVJuA.htmllive

Hi, thanks for your comment. A few things to cover. My battery lithium battery is the older 20ahr version, they now come with 30ahr which give a bit of extra time/range. 30amp-hour is the storage capacity, not the current drain. My 20ahr says that the max continuous drain is 35amps! That would relate to what the motor is drawing, so the 30ahr is probably rated the same. My motor was listed as about 40~50min at full power so that seems about right. Since this video, I had two problems (not related to the Haswing) which have meant I don't have extra details or the follow up video I expected to make, yet. First the mooring chain broke, and I had to put the boat on the hard stuff, then I got a sciatic nerve problem which limited my mobility for a while. Anyway the boat is back on the mooring now, and I have done some rewiring, but I haven't tested it in earnest yet, actually will probably do so in the next couple of weeks for some autumn sailing. I have put two 80a marine batteries in parallel at the back cavity (160a storage) which I have now wired to my solar panel, the original engine battery is now the house battery for radio, chart, etc. My intention is to keep the lithium battery stored on board for back up and only really use the 12v batteries. The 12v are the easiest to recharge. I found my inverter battery voltage got drawn down a bit under load, so I need to tweak that as the motor beeped for undervoltage so I need to have a closer look at the current flow, I may need to add a second inverter in parallel to up my current to the motor if I want full power... What I thought at the outset was only doing small maneuvers with 12v (low power) and if I wanted extra because of the weather or something then I'd pull out the "real" battery... I have made a little wireless battery gauge that sends me the house and drive battery levels back to my house, so I can monitor the battery status. My previous videos were intended to test out the motor itself, now I need to make that follow-up trial of my inverter system. If you are going to make one yourself, I warn you that creating the plug to fit in the top of the motor is the hardest part. Good luck.

Unfortunately, I could never find a plug. I searched and asked Haswing. I had to create one. I got a couple of high current cylindrical lugs that fitted over the pins, and created a 3d printed housing for them. I soldered the wires onto each and fed back up into the housing, heat setting them into the position. Then I back filled the top with glue to create a seal over the top. The wires on the lugs are only short, I just fed them into a grunty terminal block so that I could connect to anything. best view is at 1.11

the connectors were xt150 6mm if I remember correctly

I can give you some brief information for the moment. Actually, yesterday afternoon my mooring chain broke and I have just moved the boat back onto its trailer. The 12v is from my old marine starter battery. It runs through the old starter cables to the after quarter and terminates with an Anderson plug. In the plastic box is an Anderson connector running into a 20a inverter. It is set for 12v --> 30v. I originally had it set at 29v but noticed the motor load pulled the voltage down a bit and I got an alarm warning from the motor. I am not sure if I have a current adjustment that I need to tweak on the inverter. I seem to get a warning from the motor if I am on full power on 1hp, or over 1/2 power on 3hp. I will try that tweak once I get the boat back on the water again. Mooring repair comes first... The connection to the motor is a home made (3D printed) plug with two high current terminals inserted in it. I suspect I may be able to get better results from the inverter with some tweaking. For the moment it is sufficient for minor use, and lets me keep the main battery for situation when I need a solid longer run. The advantage of the 12v is that it recharges on my solar system.

@@twictnet Thank you so much！

@@kenintko www.aliexpress.com/w/wholesale-1200w-dc-dc-boost-converter.html shows the inverter

@@twictnet Thank You !!

Hi Adam, I have done 20 of these. I had 2 that didn't work - I think they "bricked". I don't know why that may have happened. It could be the way the batteries first connected back up to the unit. I did manage to use the same battery pack and base with a different top and that was fine. So two definitely didn't like something. I had the luxury of enough working that I didn't really follow up to discover why. Even when on the cradle I could not link to them anymore as if the bluetooth had dropped. If you can link to it when it is on the cradle you may be in luck. Check the wiring that you didn't get one of the batteries incorrectly wired. Good luck.

Hi, glad you have had some use from the file. The link should still work, right click and do save as to download it. alternatively go to www.twict.net/excel-timestamping which has the full set of files that I loaded in another place. The version I have been using the most is described on this video czcams.com/video/vj6k4CdHv5s/video.html Any issues feel free to contact.

I am not sure what your problem actually is but I did get a good response from makeblock support: Makeblock Technical Support Team <service@makeblock.com>. Good luck

also try www.makeblock.com/mcreate-video they have changed focus to xtool so there is scant information available

@@twictnet thank you very much for your help,my issue is that I installed the last firmware from the makeblock official site and now the printer isn’t working well,while printing it says homing…wait and cant see progress or pause it or anything,also if the light goes or the filament finished it wont resume either

@@gabrielmozos I don't usually print from the mcreate panel (usb), instead I print using Octoprint on a raspberry pi, that way I can monitor temperature and issues from my living room :-) I presume you have tried reloading the firmware again. here is a link to their firmware page from a while ago www.makeblock.com/mcreate-2#software Version: 42.01.002.T11 Released: 2021.02.25

@@twictnet I will try and check out what you mentioned of.octoprint etc,I have tried reisntalling the firmware but since its the same version it wont let me

if you have a dc motor controller, there are forward and reverse pins for each motor. You can have 2 outputs from the arduino for each motor, one for forwards and one for backwards

Depends on where you live, I have seen them sold on Amazon, but not much help for me in NZ. They were sold here in a discount store, but I can't get them anymore. I recently replaced the batteries in 15 spheros using 3D printed shells with translucent PLA. The translucent PLA is sufficiently clear to enable aiming the sphero. There are some free shell designs on thingiverse. I had to increase the size to 102% perhaps because of inaccuracy with the tolerances of my 3D printer. The 3D shells are much stronger than the Xmas bauble version. As for glue I just used a brush on super glue. However for the 3D shell, I have also smeared a layer of epoxy glue along the seem to strengthen it more.

Michael's (the hobby store chain -- they have 3" diameter snap fit transparent shells) I paid less than $1 each, and picked up at one of their stores to save shipping.

Not sure what part you need information about. The Pictures that get dragged- create one, then duplicate it a number of times and place it over the top of the previous ones. The lock function requires that you turn on the developer menu from the options area.

At the end of the show you are asked if you want to keep the annotations. If you keep them then they become objects on the slide which you can delete after selecting them.

I have a set of 30 batteries on order, which I hope will make it through the delivery service. My supply of 'baubles' dried up, so I am currently 3D printing shells. My first one didn't let enough light through to adequately see the aim light, but having shifted to a translucent PLA it is looking promising. Just waiting to see if the batteries come in within the size tolerance, and more importantly whether they actually get delivered. Will do an update if all goes to plan.

@@twictnet oh very nice I just did a search on eBay for clear bauble and the exact same ones you used are there, I'm just doing one first before attempting the other 14, the school's getting a new set since ours are 5 years old the new ones have many more features, if I can get these working for roughly $20 aud it's far cheaper than $333 for one, I look after 5 schools in Victoria so I'll be able to help them out with their old spheros as well, really keen to see what acetone does to the glue holding the original shells together.

@@twictnet my batteries arrived today, I went out and got some first ingredient acetone nail polish remover and used a cotton wool tip to go lightly around the seam of the sphero and it got in and melted the glue holding it together after about a minute, they then just fell apart without any tools to pull them apart or damage the shell, absolutely amazed but glad I don't have to get baubles anymore :)

I'd be interested in finding out more about how you got the shell apart. I have tried with acetone but just end up scraping out a wide channel and never got them to separate. (Diggers Acetone from Bunnings). Tried a gentle approach first with cotton buds but never go anywhere. I am still waiting on my next shipment of batteries, hoping they comply to the size I specified (aliexpress order). In the meantime I am making translucent 3D printed shells, which seem to work pretty well. I ran out of my supply of the baubles and have opted for printing a stronger version in PLA. The baubles are okay but there is a high attrition rate ;-( I switched my school over to sphero minis rather that replacing the SPRK+. Will work on resurrecting the SPRK+ but it is not a priority. Still the sphero chariot lesson doesn't work properly with mini's!!! czcams.com/video/GmldVnCnQ44/video.html

702035 is the exact one used, you just need to get one the same physical size if can't get that. There was a shortage of batteries for a while so the Hubsan 107c was a substitute it had a lower maH. Depends where you live as to what will be available.

Thank you

I have just ordered some from here www.ebay.com/itm/304025704889?var=603178255237 - hoping they actually turn up...

@@twictnet those ones are very similar to the ones I got but were slightly too long(had to modify the internal case slightly) to get them to fit and fold the yellow part a bit, they still fit and last much longer though. So grateful to be able to get one of these going again for the school, I'll bring it into the school next Thursday when schools back and see if they want me to fix their others I'm just the specialist technician so it's completely out of my job description but I love tinkering haha 😂

@Caleb Webb The batteries I tried to order from eBay, got cancelled by the supplier. I order some others directly from AliExpress, and had to wait a short manufacturing time, then shipping. But got 30 successfully. However, I did insist that they worked to a specific size specification. Was happy with them.

Yeah, that video is pretty old, but just went into my Office365 Excel and it is still listed there in the All Commands menu. You should be able to see Speak Cells; Speak Cells - Stop Speaking; Speak Cells by Columns; Speak Cells by Rows; Speak Cell on Enter. Are you in the Customize Quick Access menu?

They are still going strong. The issue we had was our technician had put the cradles on a time switch to charge each night. That is a bad move as it tricks the units into clocking charge cycles, they need to be left on the cradle to idle, and powered down completely and taken off the cradle for long term storage. With a time switch they bleed off power then recharge, whereas if left on-charge they just top up.

the motors need a direct power supply to the motor controller, that power supply can also drive the arduino so you can have just one power supply. In tinkercad don't have a convenient motor control module to be able to show that wiring. you can see a picture of the motor controller in this other video on the channel czcams.com/video/hljoHpAlImk/video.html

Yes you must set iteration on to cope with circular references czcams.com/video/qubMSODRuXk/video.html

you can use and adapt as you see fit, see other videos for how to make your own. You will get an error if you haven't turned iteration on!

If you only need to do a one off try their free trial. You will probably get a watermark but that is a small price.

@@atqueenstown this is possible!? I thought they only publish 15 slides..I have 40 slides..but I have to check this out!😅😊🙏 Thank you and have a nice day! ❤️

risen from the dead - see my review czcams.com/video/Y4G1nG9cOrQ/video.html

Since MYO has been discontinued you are unlikely to get one other than as a second hand item. However, the MYO can communicate with some bluetooth LE dongles and indeed it can be connected to a phone. I have MYO EMG visualiser from the Android Playstore and it works with that on my Sony phone. Hope that helps.

yes you can change the text formatting from default to something else. Just show the text formatting menubar.

@@twictnet How to show that?

@@tttoan just right click on the toolbar space and make sure you have the comments toolbar ticked. then when you create a text - typewriter entry the font tools will show. pdf xchange viewer v2.5

No, not with this method, it is text based only and doesn't even allow control of size or font. Sorry.

Well it might be a bit of a mission, but you could create a separate spreadsheet that vlookup each scoresheet to then graph/chart. vlookup is a powerful tool for aggregating data.

​@@twictnet thanks for your tip, btw do you know which formula has a function as when I click on team1,2,..., the score of that team will be increased?

The formula is inside the commandbutton which is visual basic: Private Sub CommandButton1_Click() Sheets("sheet1").Range("b2").Value = Sheets("sheet1").Range("b2").Value + 1 End Sub You need to go into the Developer tab (ensure that is enabled in preferences) then go to Design mode, you should be able reverse engineer any of my postings.

yes there have been a few updates since that was made, but I still use on a regular basis as my preferred PDF software.

depending on the version of excel you have limited control of the action of comments determined by the overall setting (preferences - advanced - comment) but basically no, it is not a button that is clickable.

Hi Ivana, lots to answer here but not particularly good news. So, you should be able to download this file from the link in the comments, I checked and it is still working. However, it is an xlsm file which means that it is macro enabled, so you have to approve macros to open and use it. The macros are the key to why it doesn't just translate into a google sheet, and they are the basis of the buttons. Sheets is still a very stripped down alternative to excel and there are lots of things you won't be able to do with it. Looking at all you seem to want to do, you are probably better with a database rather than a spreadsheet. Also if you want to get it with different 'views' and open on a mobile, you really need to be making an App. You can get the timestamp and notes working on google sheets if you turn on iteration, and I have videos of that, and the timestamping feature which I use in an attendance system (see other videos on this channel or on the website www.twict.net). I think your overall goals might be a bit ambitious for a spreadsheet. Especially when you try to combine all the features you mention. Have you looked at premade solutions such as classdojo etc? The spreadsheet given here was designed for local use on the teacher's computer displayed on an electronic whiteboard, or display. You are welcome to customise it to suit but to really get what you are considering I think you will have to start from the beginning in a mobile App creation program. The good news is that if you make it, you could probably sell it too. : - )

@twictnet Hi, thank you so much for the feedback. It is nice to see that someone actually responds to their comments. I have done my „research“ before choosing this, and I wasn't pleased with my options either because they don't fit my needs completely, or because I am a perfectionist (or a little bit of both). Regarding the first question, that is good news. I managed to make a Google sheet that consists of the list of names (just written in cells, they aren't buttons so changing them is easy). I created a separate button for adding and subtracting for each student. It took a while, but it works great. I used these instructions: productivityspot.com/spin-button-google-sheets/ Furthermore, since I can duplicate it, I can simply make a new Google Sheet for each class without having to do everything from the scratch. I can easily change names, reset points for the next year as well. As for the students being able to see it, I created a separate sheet with a chart - it has names of each student, number of points and it is colourful. In order for students to see it, I just have to publish that single sheet as website and send them a link - it looks great on the computer and on the phone, and I don't have to republish it since it updates automatically every 5 minutes. As for the last part, I did it a bit differently - though I am not finished. If I figure it out, I will let you know. Apps and websites, I'm a beginner so that is a bit advanced for me: In a column next to the points, I added a drop down menu (items such as: +1 point for good behaviour, -1 point for being late etc.) Now, I created one sheet per student in the same Google Sheet. What I still have to do is the following: - I click on an item in the drop down menu for student A. - Automatically, that item gets a timestamp and it is saved in the sheet for the student A. And this happens every time I choose an item, every edit in a separate row with a timestamp. I will have to look up some of your other videos, I have found similar options, I just have to sort it all out. Thank you once again, Kind regards and have a nice day,

Hey, you have been busy. I like your website/chart publishing option, good move. The key to time stamping is to use iteration to stop a circular loop - try putting this in C3 =IF(A3<>"",IF(C3="",NOW(),C3),"") where A3 is the target cell. When it is empty nothing is put in C3 is left blank, but if any value is put in A3, a timestamp is put into C3, the cell with this formula. However, you can't change the value in C3 unless you delete the contents of A3 first... A3 is the trigger and the lock for the timestamping. Best of luck for your project. Make sure you turn iteration on - under formulas or you will just get a circular reference error.

@@twictnet Hi, thank you for this. Had it not been for your video, I would still have been looking for a way to make a scoreboard. This will be useful for the last part. Thank you!

clicking on a button adds the default (+1) to the tally for that group. to subtract you need to click on their tally score and type in the value you wish. if you wanted to regularly reduce the scores then you could create a duplicate set of buttons below the add which default to minus 1.

you can go through the file and delete what you don't want, or make one, it is basically just a table. I have two versions of just the 6 team table available on the website sites.google.com/a/twict.net/www/excel-timestamping go to the bottom of the to the file area

Yes, lining them up and modifying them is a tedious job, that is what prompted me to move to a sign-out scan system as an alternative in subsequent iterations. At one point I tried inserting a row with disastrous consequences for the alignment. I think working with a limited (small) number is fine but when you want to have lots as I tried, it becomes more trouble than its worth. Sorry doesn't help you much, your best bet is to try and set up a line on the screen to help as a guide.

You just use a barcode scanner to read into your target cell. Then vlookup your data based on the scanned information (unique id number). The scan can be done with a dedicated barcoder laser hand unit or from a webcam with software like Katanshi Barcode Reader.

generally this is trying to avoid people changing data and thereby altering the timestamp. The if statement is trying only run when it move from empty to full, but you can change to whatever variation you want, it all depends on your purpose.