Jobs for Dumb Arse

  1. There are 21 square Perroplas crates that need homes (all roof slots occupied)
    • We regularly access maybe 8-10 of these (Screws, Brackets, Nails, USB Cables, Ethernet cables, Extension cords, Multiboxes and so on)
    • Could probably get it down to 14 for use in workshop, others can go to garage/garage sheds
  2. Those bunnings yellow multi drawer sets, the bottom lot are too low and are really awkward to get too (mainly to read the labels etc), so we will move those to the upper half of the opposite side of that bay
  3. New lundia bench that I put in 26/4/2019, center upright is upside done so shelves are slanting 15mm DONE
  4. Behind main lundia add 150mm deep shelves so we can store icecream & mayo containers, like what we had behind the old lundia
  5. Move Gun Safe to be between first & second white cabinets DONE
  6. The 3 White cabinets were just chucked in and are not level etc

Big job to nibble at over next couple years, the workshop has that nice recycled rimu? wallboards but there is no insulation behind it

Todo

20190317

  • Large TVs against Gge door (temporary)
  • Middle window:
    • 6 x FCabs inline workbench
      • Cabs in place, rough wooden bench top
      • Needs power run, shelving, on left after determine:
        • where PCs live
        • where soldering/rework station lives
    • Box shelving above:
      • partially done, pending decision on what tops 100 drawer cab
    • 100 Drawer cab:
      • Wall off left side
      • 42″ HD TV mounted on side of cab
      • Leave room for 55″ Tv to slide out?
  • Soldering / rework station:
    • Consider removable self contained tray: could sit above 100 drawer can when not in use
  • Lundia:
    • Isle 3 middle:
      • Bottom shelf rubber mats height
      • Next shelf Steel cutoff saw, Arc welder / Plasma cutter
      • Top shelf: linear rails, acme leadscrews etc
      • Remaining: TDB
    • Simexperience:
      • Tidy, sell?
    • RC4: rotate 100 degrees


  • 3030 / 3060
  • Construct Bench to go under
  • Cutting bench:
    • Level left side
    • Make fence & Fit digital readout
    • Sort right side
  • Boxes to keep:
    • Shelf on top of tilt door
    • Shelf above window
  • Loose iCreme containers etc below corrugated cardboard rolls:
    • empty some into new 100 drawer cabinet
    • Rear wall of toilet workbench? does that leave enough room for 3d printers?
  • New Mill parts:
    • Construct bench opposite existing mill
    • Construct Mill (mount head to compound table
  • Pinballs (Prioritised):
    • Remove broken platics from IJ
    • Fix & LED CFTBL & sell
    • Fix STTNG ball sensors
    • Fix JD
    • LED TFTC
  • Bikes:
    • Sell Ego
    • Sell C600
    • Fix PGO
    • Sell ZX?
    • Buy H2?

$$$ 20190218

WhatBefore GST/PAYENetTot
BNZ -$26,927.00  
BNZ -$8,698.00  
Kbank -$3,000.00  
Coop -$1,000.00  
   -$39,625.00
    
Sell Kymco-1500-$1,304.35  
BMW-7500-$6,521.74  
Sell van-7500-$6,521.74  
Sell ZX14-12000-$10,434.78  
   -$24,782.61
    
    
    
Sell CFTBL -$6,000.00 -$6,000.00
    
Coop Jan -$6,650.00  
 65%-$4,322.50 -$4,322.50
Coop Dec -$5,000.00  
 65%-$3,250.00 -$3,250.00
    
Total realised  -$77,980.11
    
Buy H229995 $26,082.61 $26,082.61
Left realised  -$51,897.50

Measure/Cutting fence (Mitre Station)

https://www.carbatec.co.nz/product/10069-kreg-precision-trak-stop-system-metric-tapes-

I also ruled out an automatically positioned stop, like the previously mentioned Tiger StopAccu-Cut Gold, or ProScale. I passed by these options because of the price

Maya Positioning Equipment makes some beautiful fences and stops and I was introduced to the company when I met the owner at IWF in Atlanta last year. I was very impressed with his company’s products and saved his brochure for this very occasion. I was also able to find several other candidates, Glide StopScotchman, and SawHelper,via a Google web search.

http://www.mayaposi-stop.com/saw_stops.htm

https://www.axminster.co.uk/ujk-technology-track-stop-kit-101500

http://www.proscale.com/products/woodworking_related/prostop2.htm

https://scotchman.com/measuring-systems/advanced-measuring-system/quick-loc/

Kreg Tool Precision Trak & Stop 8′ System KMS8000

biesemeyer 78-806

MFM Purchases

Initial versions 20181117

Keep track of purchases

' Snapshot in case ever lost

CREATE TABLE `m4m_wpProducts`
	(`wp_post_id` INT
	,`wp_post_title` TEXT
	,`wp_sku` TEXT
	,
KEY `iPostID` (`wp_post_id`) USING BTREE
);

insert into m4m_wpProducts (`wp_post_id`, `wp_post_title`, `wp_sku`)
select ID, post_title, pm_sku from vProductMetaData;

Purchases

CREATE TABLE `m4m_purchases`
	(id INT NOT NULL AUTO_INCREMENT PRIMARY KEY
    ,`wp_post_id` INT NOT NULL
	,`site` TEXT
	,`who` TEXT
	,`placed` DATETIME
	,`received` DATETIME
	,`qty_ordered` INT
	,`qty_received` INT
	,`qty_into_stock` INT
	,`issues` TEXT
	,`cost_total` DECIMAL(10,2)
	,`cost_unit_as_received` DECIMAL(10,4)
	,`cost_unit_as_into_stock` DECIMAL(10,4)
	,`cost_replacement` DECIMAL(10,2)
    ,KEY `iPostID` (`wp_post_id`) USING BTREE
);

xx

alter view vPurchasesSummary as
-- 20181118 LSR
-- Initial
-- 20181207 LSR
-- Added firstorders & orders
select wp_post_id,
    round( sum(cost_total) / sum(qty_received), 4) as cost_wavg,
    min(placed) as firstorder,
    count(*) as orders
from  m4m_purchases
where qty_received <> 0
group by wp_post_id;

alter view vPurchases
-- 20181117 LSR
-- Initial version for stock purchases CRUD
as
select 
	concat('<a href="productbuy.php?wp_post_id=',wp_post_id,'&id=',id,'">OL',wp_post_id,'/',ID, '</a>') as edit_href,
	id,
    wp_post_id,
    site,
    who,
    placed,
    received,
    qty_ordered,
    qty_received,
    qty_into_stock,
    issues,
    cost_total,
    cost_unit_as_received,
    cost_unit_as_into_stock,
    cost_replacement
from m4m_purchases pu;

xx
ProductListInitial

alter view vProductSimple
-- 20181117 LSR
-- Initial version for stock management entry point
-- 20181229 LSR
-- Added 'left' to join on vPurchasesSummary
as
select pm.ID as wp_post_id, pm_sku, post_title, pm_stock,
	concat('<a href="productbuy.php?wp_post_id=',pm.ID,'" >OL',pm.ID, '</a>') as productbuy_href,
	pm_m4m_cost,
    pm_m4m_ok,
    pm_m4m_pnp_cost,
    pm_m4m_purchase_note,
    pm_m4m_qty_bought,
    pm_m4m_qty_inv,
    pm_m4m_repl_cost,
    pm_m4m_shrinkage,
    pm_m4m_stocktake20180331,
    ps.cost_wavg
from vProductMetaData pm
join vProductType pt on pt.ID = pm.ID
left join vPurchasesSummary ps on pm.ID = ps.wp_post_id
where product_type = 'simple';

xx

Alum 2018

ORDER NET WEIGHT SHIPPED/RECEIVED

I expect to receive:

2020V profile: 1417pcs x 2.52m x 0.56kg/m = 1999.67kg
2040V profile:  404pcs x 2.52m x 0.98kg/m = 997.72kg
2060 profile: 132pcs x 2.52m x 1.5kg/m = 498.96kg
2080 profile: 107pcs x 2.52m x 1.85kg/m = 498.83kg

Received pieces:

  • 2020V:
  • 2040V:
  • 2060:
  • 2080:



20180901 checking space

Onhand:

2020:

  • 10 sticks x 2.5m x (12 in each packet) = 300m = 120 lengths @ 20x20mm = 135kg @ 0.45 kg/m
  • Each packet 90mm x 60mm

2040

  • 40 sticks x 2.5m x (6 in each packet) = 600m = 240 lengths @ 20x40mm = 570kg @ 0.95kg/m
  • Each packet 90mm x 60mm

On Order:

2020

  • 2000kg @ 2.52m, approx 3600m = approx 1400 lengths @ 20×20
  • Assuming same packets = 120 packets
  • Between ceiling rafter = 6 packets across (6 x 60mm)
  • So 6 packets by 20 packets along (90mm dimension) = 1.8m along

2040

  • 1000kg @ 2.52m, approx 1000m = approx 400 lengths

2060

  • 500kg

2080

  • 500kg

What about 3030 series?

How much can we store under a 1m high workbench?

How much space does 3030 take:

  • Assuming 0.95kg/m
  • Assuming 4000kg
  • Assuming 3.65m lengths
  • = approx 1150 lengths 3030
  • How many can you fit 900mm high? (Assumes losing 100mm of our 1m to top/bottom etc)
    • = 900mm / 30mm = 30
    • so how many across = 1150/30 =  approx 38 = 1150mm wide
  • Conclusion: 4000kg 3030 at 3.65m lengths = 1150 lengths fits end on into 900x1150mm

So can we turn this into a usable workbench?

Bench width 950 1000 1100 1200 1300 1400
Lose either side 50 100 100 100 100 100 100
Storage width 850 900 1000 1100 1200 1300
Lengths high 30 30 30 30 30 30
Lengths wide 28 30 33 36 40 43
Lengths 840 900 990 1080 1200 1290
KG 0.95 3.65 2912.7 3120.75 3432.825 3744.9 4161 4473.075

1400mm wide option looks useful:

  • So we would have  alum stacked in a rack 3.65m long by 1.4m wide to a height of 1m
  • Longways:
    • Allow 100mm space between outside wall and end of alum to keep dry
    • 3750 to other end of alum from side wall
    • Side wall needs room for cutting so can’t use first 500mm
    • From sidewall to edge of regular door = just under 3.6m
    • So maybe bench top = 3.2m x 1.4m
  • Will allow Pick & Place on 1 side & cnc machine on the other (700mm deep each one), or in a row with plenty of space on the other side

 

MFM GST Return Procedures

Prepare paper folders

  • 1 x monthy foolscape pocket folder
  • Pre Nov 18 return:
    • 5 x Manilla folders:
      • Receivables
      • KB Payables
      • Trademe
      • Paypal
      • Personal CC Txns
  • Per Nov 18 return:
    • 2 x Manilla folders:
      • Kiwibank payables in one folder
      • Trademe / paypal / Personal CC Trans in second folder
      • Sales invoices at bottom of foolscape folder
      • Then above 2 x manilla folders
      • Then Bank statements, GST declarations, Cashbook hardcopy

Prepare new period in cashbook:

  • Copy cashbook to backup and name per last edit date
  • Open cashbook
  • Copy / Paste previous periods rows to a new space below leaving 2 clear rows between and previous and new
  • In new period remove all keyed txns, copy down calculated columns from top row to bottom to repair formulas
  • Enter previous period closing as new period opening for KB, TM, PP balance columns

MFM KB Bank txns

  • Get/Print bank statement for target period
  • Check Worksheet KB Opening Bal = Statement Opening Bal
  • Get KB Bank acct Txns into Cash book
    • Log into IB
    • Export all txns from first to last day of return period (Basic export = a csv file)
    • Open export in Excel (is the default for .csv) and check first / last txns are per bank statements
    • Take first 6 column column headings (‘Date’ to ‘Total Amount’) from cashbook and paste as first row into export
    • Calculate txn amounts as the inverse and paste as values into the ‘Total Amount’ column
      • This is only until we fix the credits / vs debits reversed issue in the cashbook
    • Set ‘Acct’ column to ‘KB’ for all rows
    • Columns ‘Cheque/refer’ & ‘Code’ should be empty
    • Copy -> Paste as values the exported txn rows (not headings) from the csv into the top of the the cashbook period
  • Code txns
    • For each payable check and file invoice in KB Payables manilla folder
    • File receivables in ‘Receivables’ manilla folder
    • No GST on:
      • GST payment
      • Imports
      • Youshop payment
      • Interaccount transfers
      • Drawings
      • Bank fees
  • Check Calculated KB Closing Bal = Statement Closing Bal

PayPal Txns

  • Get PPal txns into Cashbook
    • Export txns
      • Login
      • Go to Activity then to Activity (Including balance & fees)
      • Do custom date range, a few days either side of the target GST period
        • Ensure returned txns shows at least 1 txn outside the GST period both before & after
      • Scroll down to ensure all txns loaded (lazy loading screen)
      • Print the txns (as this is effectively our statement)
        • Mark the opening & closing balance txns as such
        • Check Worksheet PP Opening Bal = PPal printed Opening Bal
      • Select & copy all txns, then paste into a new workbook
        • We don’t use export as this way we get the date formatted for us (d/m/y)
      • Cleanup:
        • Delete txns outside our period
        • Delete Fee Reversal txns else we will get double ups
        • Delete page break / lazy loading non txn rows
      • Take first 6 column column headings (‘Date’ to ‘Total Amount’) from cashbook and paste in PPal worksheet out to the right
      • We need to get 2 lots of txns for pasting into our cashbook::
        1. All txns
          • Populate the columns:
            • Date = Date
            • Name = Name
            • Cheque/ref = empty
            • Code = 210 for sales leave empty for anything else (transfers, purchases)
            • ACCT = PP
            • Total Amount = (-1) * Gross
              • 20190507 GROSS is now suffixed with NZD so used formula to get $:
              • =LEFT(H2,(LEN(H2)-4))
          • Copy / Paste as values into Cashbook (This is all TXNS)
          • Code remaining transactions
            • No GST on Interacct transfers
            • Check no GST on import payments
        2. Fees
          • Back in Paypal worksheet copy the rows we prepped above below themselves (so we can go back in the previous step if we don’t balance)
          • In our new copy, remove any rows where there are no PPal fees (Fees = $0.00)
            • Date = Date
            • Name = Name
            • Cheque/ref = empty
            • Code = 307
            • ACCT = PP
            • Total Amount:
              • Where a refund = Fee
              • Where a sale = (-1) * Fee
              • Formula example: =
              • =IF(ISNUMBER(SEARCH("Refund", B2)),D2,(-1)*D2)
          • Copy / Paste as values into Cashbook (This is FEES)
          • Check Calculated PP Closing Bal = PPal Printed Closing Bal
          • Finish coding fees:
            • No GST as IRD won’t tell us if PPal is GST registered

Trademe Txns

  • Login to each TM account and in My Account:
    • Print GST receipt for each month in the target GST period
    • Print txn listing, sufficient pages to cover the target GST period
      • label opening and closing balances
      • Total opening & closing balance across all TM accounts
      • Check opening is correct per previous period
    • Manually enter txns into Cashbook
      • 1 per each Paypal topup txn (890 = Interacct transfer, no GST)
      • 1 per monthly GST receipt printed above
      • Check closing balance reconciles

Cash / Personal Txns

  • Any cash sales or purchases key manually, Acct = LSR
  • Visa purchases
    • Login into bank & search for target period txns, print hardcopy
    • Mark on hardcopy MfM txns
    • In Aliexpress search for all orders in GST Period and print a record of purchases (just for filing)
    • Open Stock workbook:
      • Reconcile payments against Stock workbook
      • Enter payments manually from Visa txn print in Cashbook
        • Acct = LSR
        • Usually no GST
    • Enter a final Txn ‘Owner Contributions’ Code = 501 (no GST) to bring LSR column down to 0.00

Final checks:

  • Check closing balances are correct per each of:
    • KB
    • TM
    • PPal
    • LSR (must be $0.00)
  • Check txns with no GST by code:
    • 890 = Interact tfr
    • GST remittances
    • Bank fees
    • Imports / payments made to foreign entities

Fixed Asset sales/purchases:

  • Enter into Assets worksheet

Setting up Mill for 2020/2040 stock milling

20180216

Goal: Setup mill to consistently/repeatedly mill 10mm in from end of 2020 profiles along the centerline

  1. Bolt Vice in making sure is at right angle to x axis
  2. Put custom alignment tool into 12mm Collet & mount into mill (push as far as possible into collet)
  3. Pack rear of vice with 2020 Length and align alignment tool to this 2020
  4. Put custom alignment piece of 2020 on rigght side and align to inside of this

That’s it

Milling Machine RF20 (Bemato BMT30J)

Arrived is a 1995 vintage Bomato BMT30J

Looks exactly like a Rong Fu RF30.. Uncanny!  RF-30_manual

Mods for RF30 (larger but very similar)

  • https://www.youtube.com/watch?v=hRwu9plKfO4

Roughly measured:

  • X Travel = 550mm
  • Y Travel = 180mm
  • Z Travel = 110mm

 

20170814

 

 


Factory info (2017):

 


SPECIFICATION
:


MODEL


BMT 30S


BMT 30J

DRILLING CAPACITY

32mm

32mm

FACE MILL CAPACITY

19mm

19mm

TAPPING CAPACITY

76mm

76mm

SWING

405mm

430mm

SPINDLE TAPER

MT3 or R8 , NT30

MT3 or R8

SPINDLE TRAVEL

130mm

110mm

QUILL DIAMETER

75mm

62mm

COLUMN DIAMETER

115mm

95mm

SPINDLE NOSE TO TABLE

480mm

395mm

X AXIS TRAVEL

430mm

350mm

Y AXIS TRAVEL

190mm

180mm

TABLE SIZE

730 x 210mm

660 x 190mm

TABLE SLOT

16mm

16mm

BASE SIZE

610 x 400mm

560 x 340mm

SPINDLE SPEED

12 Speed, 50HZ: 4P: 90~2150RPM , 8P: 50~1040RPM
60HZ: 4P: 110~2580RPM , 8P: 60~1250RPM

MOTOR

1-1/2HP (2HP)

1HP (1-1/2HP)

COOLANT MOTOR

1/8HP, 3ph

MACHINE SIZE

1080 x 1100 x 1100mm

950 x 1030 x 980mm

STAND SIZE

750 x 560 x 790mm

N.W. / G.W.

270 / 300 kgs

180/ 200 kgs

PACKING SIZE (L x W x H)

MACHINE

915 x 760 x 1140

760 x 760 x 1140mm

STAND

840 x 580 x 200mm

*The above specitications are subject to change without
prior notice.

20180216 Is Missing the Machine key to use the ‘Drill’ feed (and spring as well)

  • Machine key is 6mm wide by 20mm long round end

MForM Upgrade Woocommerce from 2.6.14 to latest V3

WIP

WC3V = Woocommerce V3.nn below for brevity

Note to self: Woocommerce 3.0 was original going to be 2.7 so some docs where we see 2.7 = 3.0

Preparation: 20170810

Step 0: Starting point = Live WordPress site with installed theme / plugins:

  • BackupBuddy – 7.2.2.5
  • Google Analytics Dashboard – latest
  • Quttera Web Malware Scanner – latest
  • Woocommerce 2.6.14
    • Storefront theme 2.1.8 + Child theme for customisations
    • Storefront Designer 1.8.3
    • Storefront Woocommerce customiser V1.9.0
    • Theme Authenticity Checker
  • Woo Out Of Stock Products
  • Woocommerce Flat Rate Box Shipping V2.0.0
  • Woocommerce Google Analytics Integration V1.4.2
  • Woocommerce Helper V1.7.2
  • Woocommerce Payment Gateway Based Fees V2.2.18
  • Woocommerce Product Addons V2.7.17
  • Wordfence Security (Free version) – latest

Step 1: Check all Woocommerce related Theme/plugins have WCV3 updates..(Current as at 20170810)

And while we are at it lets look at any mention of backward compatibility and also when the last WCV3 bug was fixed as an indication that any WCV3 issues are mostly found/resolved by now

Colour coding below: Green = looks good, Orange = maybe questions, Red = STOP

  • Woocommerce 2.6.14
    • Storefront theme 2.1.8 + Child theme for customisations -> V2.2.4 = WCV3 / released 20170628
    • Storefront Designer 1.8.3 -> V1.8.4 = WCV3 / released 20160825
    • Storefront Woocommerce customiser V1.9.0 -> V1.9.2 = WCV3 / released 20160905
  • Woo Out Of Stock Products V2.1 -> ***V2.1 maybe ok***
  • Woocommerce Flat Rate Box Shipping V2.0.0 -> V2.0.2 = WCV3 / released 20170614
  • Woocommerce Google Analytics Integration V1.4.2 -> V1.4.3 = WCV3 / released 20170615
  • Woocommerce Helper V1.7.2 -> No change
  • Woocommerce Payment Gateway Based Fees V2.2.18 -> V3.0.5 = WCV3 / released 20170607
  • Woocommerce Product Addons V2.7.17 -> V2.9.0 / released 20170713

So no red flags = Good.

Step 2: Get Updated Plugins for use on test site 20170810:

  • Storefront Designer 1.8.4
  • Storefront Woocommerce customiser V1.9.2
  • Woocommerce Flat Rate Box Shipping V2.0.2
  • Woocommerce Payment Gateway Based Fees V3.0.5
  • Woocommerce Product Addons V2.9.0

Step 3: backup and restore site into test location 20170810

  • BackupBuddy Full Backup taken
  • Restored into test site
  • Paypal set to Sandbox mode: Woocommerce->Settings->Checkout->Paypal

Test Update process 20170810

Step 10: On Test Site: Put Site Into Maintenance mode 20170810

Step 11: On Test Site: Apply updates 20170810

I have searched and found minimal information on the order to apply updates, however there is a hint of a consensus that themes/plugins are backwards compatible even if Woocommerce itself is not so the process will be:

  1. Stop the site with an HTTACCESS redirect to static page

 

  • Update Theme + Theme plugins
  • Update Woocommerce functional plugins
  • Update Google Analytics Integration
  • Update Woocommerce