Sign in
 
HomeLibraryWikiLearnGalleryDownloadsSupportForumsBlogs

TechNet Gallery - resources for IT professionals

Download resources and applications for Windows 7, Windows Server 2008 R2, Windows Server 2008, SharePoint, System Center, Office, and other products. Find resources written in VB Script, PowerShell, SQL, JavaScript, or other script languages. New resources are added frequently so check often and see what's new.

Each contribution is licensed to you under a License Agreement by its owner, not Microsoft. Microsoft does not guarantee the contribution or purport to grant rights to it.
Sort by: rss
5 results in Somkiat Foongkiat - Bangkok, Thailand [Clear]
FIFO calculation with Excel Data Table
Somkiat Foongkiat - Bangkok, Thailand
FIFO calculation with Excel Data Table(Inventory ID is selectable in this sample) Table C6:E15 keeps inventory inward data for all inventory id ordered by its occurrance.Cell H2 is total unit sold of inventory id that selected in cell H3.Table F6:F15 calculates number of unit sol
(3)
Updated 9/15/2012
Released 9/15/2012
2,690 Downloads
VLookup data from multiple sheets
Somkiat Foongkiat - Bangkok, Thailand
This sample shows how to use Choose within VLookup function to select data range from multiple sheets. Then use Data Table to generate answers from all sheets.Concept : any formula or function that return data will return the data's reference when use it inside another funtion. C
(1)
Updated 8/2/2012
Released 8/2/2012
322 Downloads
FIFO Costing with Excel Data Table using inward and outward table
Somkiat Foongkiat - Bangkok, Thailand
Calculate inventory balance in cell H6 :

=SUMIF($D$6:D6,D6,$E$6:E6)-SUMIF($D$6:D6,D6,$G$6:G6)


Input your ID in cell S3 and beginning date in cell O3.
Calculate number of units outward that deducted from units  inward in cell J6 :
=IF( AND(Id=IdKey,Date>=From,E6>0), MIN(
(0)
Updated 10/18/2012
Released 10/18/2012
417 Downloads
Spelling number to English word Add-in
Somkiat Foongkiat - Bangkok, Thailand
Money Add-in spells number to English word with any unit name you like. After load this add-in to your Excel (2003 and later), you may use new function in this form:=Money(YourNumber,"Dollar","Cent")=Money(YourNumber,"Baht","Satang")=Money(YourNumber,"Metre","Centimetre")Such as
(1)
Updated 8/2/2012
Released 8/2/2012
249 Downloads
Calculate FIFO Cost of Goods Sold with simple formula
Somkiat Foongkiat - Bangkok, Thailand
Left table C4:F11 keeps received inventory.Cell H2 is the Total Unit Sold with 120,000 units input.Table H4:H11 calculates cost of good sold of 120,000 units equal to 1,270,000 Thai baht.Right table J4:N10 calculates cost of good sold of each sold lot.Key of this calculation is u
(2)
Updated 9/15/2012
Released 8/5/2012
310 Downloads