Microsoft Windows and related products
---
row number =MATCH(B1;sheet1!A:A;0) 48
cell address =ADDRESS((MATCH(B1;sheet1!B:B;0));1;1;TRUE;"sheet1") sheet1!$A$48
value of address =INDIRECT(ADDRESS((MATCH(B1;"sheet1"!A:A;0));1;1;TRUE;"sheet1")) hostname1
Trim a string
=LEFT(sheet1!G2; 7)
VirtualBox 4.2.28 OSE
- Enable I/O APIC (to avoid Error 0xc0000225)
- RAM: 2GB
- CPU: 1
- Cap: 50% (only for me)
- PAE/NX: no
- VTx, nested paging: yes (auto)
- Disk: 30GB, dynamic, VDI
- USB: yes
- Sound: yes
- Video RAM: 64MB
- Network: NAT, cable connected, Intel Gigabit desktop
- Shared folders (appear under \\vboxsvr\ in Windows after the Guest Additions are installed)
- Windows 7 SP1 Enterprise
- Total install time about 40 min
http://windows.microsoft.com/en-us/windows7/products/system-requirements
VirtualBox Guest Additions ISO
Download for your version
http://download.virtualbox.org/virtualbox/4.2.28/
+Microsoft Toolkit activator
http://free.appnee.com/microsoft-toolkit/
Enter your license key
The tool lets you set a lot of other parameters that I'm not going to detail here.
Note: "activator cannot be run from a shared folder"
+updates ("60 updates, 440.7MB") as of Feb 2015
Download: in about 30 min
Install: in about one hour+ (including reboots)
VDI size: 11GB after install, 18GB after updates
Saved state: .sav file: 820MB
+disable Windows Update service (~550MB RAM)
---
TODO
http://windows.microsoft.com/en-us/windows/security-essentials-download