Bestfredy
Member
- Jan 4, 2016
- 93
- 33
Mkuu wetu naomba umsaidie huyu mtu utakua umetusaidia weng mno
Mkuu wetu naomba umsaidie huyu mtu utakua umetusaidia weng mnoMkuu mi nataka kutengeza page ya excel ntayoweka total number ya items...na kila nikitoa item moja mfano ziko jumla 20 basi nikitoa moja ibaki 19 automatically...nikitoa ingine zibaki 18 ivo ivo mpaka ziishe. Na zikiisha inipe alert kwamba zimeisha au zinakaribia kuisha!!! Nipe mwongozo hapo
Moderator wana wivu. Hawatakia watu waweze ku-access kirahisi Uzi ili wajifunze vitu adimu.Mod hawaja u sticky huu uzi? Why
Total number ya items za aina moja au total number ya items za aina tofauti?Mkuu mi nataka kutengeza page ya excel ntayoweka total number ya items...na kila nikitoa item moja mfano ziko jumla 20 basi nikitoa moja ibaki 19 automatically...nikitoa ingine zibaki 18 ivo ivo mpaka ziishe. Na zikiisha inipe alert kwamba zimeisha au zinakaribia kuisha!!! Nipe mwongozo hapo
Kuna madini kibaoModerator wana wivu. Hawatakia watu waweze ku-access kirahisi Uzi ili wajifunze vitu adimu.
Tofauti tofautiTotal number ya items za aina moja au total number ya items za aina tofauti?
Tuelekeze hii mkuuVLOOKUP
Tufundishe hii mkuuOkay,
Vlookup naifahamu vizuri,
Nahisi index+ match inaweza saidia.
Ungetumia kiswahili kaka ingekua poa sanaHow to draw/ plot Microsoft excell data (surveyor data) into AutoCAD.
1} PLOTING
surveyor data from the GPS devise (in UTM or other format ) or total station can be saved in excell and later ploted in AutoCAD. Those data represent coordinates of a point on earth's surface and they include Horizontal distance (in meters ) East/west (X) Noth /south(Y) , and elevations (Z) and with these data you can plot a profile or alignment in AutoCAD.
~PROCEDURES;
From the excel data will be contained in four columns horizontal distance, elevation,Nothing & easting. Join data from the column Nothing & easting into a single column with a commer in between them by using concatenate function eg 891, 351 where 891 is northing and 351 being easting.
- drag the formula through the range of data available.
-within the same column (at the upper most cell which should be empty) type the following AutoCAD command SPLINE
- Now copy the whole column data including the CAD command
-minimize the excel window and open the AutoCAD application software
- click the command line in AutoCAD, rightclick and paste data copied from excel ...click ENTER !!
-now what you see is the alignment of the surveyed area with respect to the surveyor data from the excel sheet.
Advantage of this is that you can work with large volume of data in a short time to create drawings for road alignment and profiles , water distribution network , site layouts for buildings as well as producing drawings for surveyed land properties.
Any question so far.
Nguzo1
Select vitu vyote huku ukiwa umehold Ctrl button then right click then chagua GroupWakuu naomba msaada wa namna ya kufungia vitu kwenye mfano ume-create kitambulisho kwenye publisher
, sasa ukitaka kuki-copy ki-copy kizimakizima bila kuacha kitu.
Shukrani Mkuu.Select vitu vyote huku ukiwa umehold Ctrl button then right click then chagua Group
Boss sorry again, nifanyaje niweze kuzibadilisha tarehe zote za siku ya j2 ziwe na rangi nyekundu?Select vitu vyote huku ukiwa umehold Ctrl button then right click then chagua Group
Select column ya Sunday then nenda kwenye font weka redBoss sorry again, nifanyaje niweze kuzibadilisha tarehe zote za siku ya j2 ziwe na rangi nyekundu?
Kama ipo kwa mtindo huu ungebadili vipi?Select column ya Sunday then nenda kwenye font weka red
Hapo hakuna jinsi maana templates za ms publisher ni muunganiko wa objects mbali mbali ambazo baadae zinakuwa combined kutengeneza object moja,hazitengenezwi kama ms word doc type. Ile yenye muundo wa one month per each page unaweza ukaformat by column ama row tofauti na hiyo ya one year months per page.Kama ipo kwa mtindo huu ungebadili vipi?
Ok sasa nikiwa nimefanya kwa mwezi mmoja to mwingine na nikahitaji miezi yote zionekane kwa page 1 nafanyaje?Hapo hakuna jinsi maana templates za ms publisher ni muunganiko wa objects mbali mbali ambazo baadae zinakuwa combined kutengeneza object moja,hazitengenezwi kama ms word doc type. Ile yenye muundo wa one month per each page unaweza ukaformat by column ama row tofauti na hiyo ya one year months per page.
Labda kama kuna njia nyingine ambayo siifahamu