맞춤제작 전문가 답변 검색결과 4,685건
-
PJT 입력 및 성과분석 엑셀
pan style="font-size: 11pt;">pan style="font-size:11.0pt;font-family:돋움;mso-bidi-font-family: 굴림;color:#333333;mso-font-kernpan>pan class='search_bold'>ingpan>:0pt">저희는 화학 원재료를 무역하는 업체입니다pan lang="EN-US">.pan>pan lang="EN-US" style="font-size:11.0pt;font-family:돋움; mso-bidi-font-family:굴림;color:#333333;mso-font-kernpan>pan class='search_bold'>ingpan>:0pt">pan style="font-size:11.0pt;font-family:돋움;mso-bidi-font-family: 굴림;color:#333333;mso-font-kernpan>pan class='search_bold'>ingpan>:0pt">현재 영업pan lang="EN-US">,pan>구매pan lang="EN-US">,pan>물류pan lang="EN-US">,pan>재무부서가 함께 일하고 있지만 각각의 업무내용을 한 장표가 아닌 각각의 부서에서 엑셀로 관리하고 있어서 이것을 하나의 프로그램으로 통합하려고 합니다pan lang="EN-US">.pan>pan lang="EN-US" style="font-size:11.0pt;font-family:돋움; mso-bidi-font-family:굴림;color:#333333;mso-font-kernpan>pan class='search_bold'>ingpan>:0pt">pan style="font-size:11.0pt;font-family:돋움;mso-bidi-font-family: 굴림;color:#333333;mso-font-kernpan>pan class='search_bold'>ingpan>:0pt">영업팀이 고객확보를 하면 구매팀이 이를 바탕으로 구매하며 물류팀이 배송관리 및 유통관리 등을 실시합니다pan lang="EN-US">.pan>pan lang="EN-US" style="font-size:11.0pt;font-family:돋움; mso-bidi-font-family:굴림;color:#333333;mso-font-kernpan>pan class='search_bold'>ingpan>:0pt">pan style="font-size:11.0pt;font-family:돋움;mso-bidi-font-family: 굴림;color:#333333;mso-font-kernpan>pan class='search_bold'>ingpan>:0pt">영업pan lang="EN-US">,pan>구매pan lang="EN-US">,pan>물류pan lang="EN-US">,pan>재무부서에서 각각의 정보를 입력하면 종합성과 및 차트분석이 자동으로 완성되는 시스템을 구축하길 희망합니다pan lang="EN-US">.pan>pan lang="EN-US" style="font-size:11.0pt;font-family:돋움; mso-bidi-font-family:굴림;color:#333333;mso-font-kernpan>pan class='search_bold'>ingpan>:0pt">pan style="font-size:11.0pt;font-family:돋움;mso-bidi-font-family: 굴림;color:#333333;mso-font-kernpan>pan class='search_bold'>ingpan>:0pt">관련 엑셀파일 첨부합니다pan lang="EN-US">.pan>pan lang="EN-US" style="font-size:11.0pt;font-family:돋움; mso-bidi-font-family:굴림;color:#333333;mso-font-kernpan>pan class='search_bold'>ingpan>:0pt">pan style="font-size:11.0pt;font-family:돋움; mso-bidi-font-family:굴림;color:#333333;mso-font-kernpan>pan class='search_bold'>ingpan>:0pt">자동화하고 싶은 업무pan lang="EN-US" style="font-size:11.0pt;font-family:돋움;mso-bidi-font-family:굴림; color:#333333;mso-font-kernpan>pan class='search_bold'>ingpan>:0pt">
*pan style="font-size:11.0pt;font-family:돋움;mso-bidi-font-family:굴림; color:#333333;mso-font-kernpan>pan class='search_bold'>ingpan>:0pt">각 부서에서 업무내용 입력시 종합성과 및 차트분석이 자동으로 되길 희망pan lang="EN-US">pan>열람 권한부여가 가능했으면 좋겠습니다
*pan lang="EN-US">. (pan>영업은 영업만pan lang="EN-US"> /pan>구매는 영업pan lang="EN-US">,pan>구매만pan lang="EN-US"> /pan>물류는 영업pan lang="EN-US">,pan>구매pan lang="EN-US">,pan>물류만pan lang="EN-US"> /pan>재무는 영업pan lang="EN-US">,pan>구매pan lang="EN-US">,pan>물류pan lang="EN-US">,pan>재무 모두 열람 가능 등과 같이pan lang="EN-US">)pan>정해진 기간안에 구매
*pan lang="EN-US">,pan>오더pan lang="EN-US">,pan>수금 등이 됐는지 자동으로 파악된다면 좋겠습니다pan lang="EN-US">.pan>pan style="font-size:11.0pt;font-family:돋움;mso-bidi-font-family:굴림; color:#333333;mso-font-kernpan>pan class='search_bold'>ingpan>:0pt">pan lang="EN-US">pan>ace="돋움">위 내용을 프로그램이 아닌 엑셀 파일에 함수 등을 설정하여 제작이 가능한지 궁금합니다. 가능하다면 견적단가도 알려주시면 감사하겠습니다. 또한 일전에 위 내용과 동일하게 엑셀이 아닌 프로그램 제작을 의뢰했었는데 그때 요청사항과 유사한 데모 프로그램을 받아보고 싶습니다.
pan>
-
[이벤트신청]상가빌딩전용 관리비청구 프로그램개발
상가빌딩 관리사무소 세부내역 대장입니다ng=EN-US style="mso-fareast-font-family: 굴림">
ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">.ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">
ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">
관리비청구 프로그램을 쓰고있는데ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">. 너무 복잡하고 일이 많아서ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">. 엑셀폼으로 개발하고싶습니다ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">.
ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">
ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">
본내용이 보편적 상가빌딩의 항목이며ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">, 내용을 토대로 호실별ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">, 또는 상가ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">(그룹ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">)별로 고지서 출력까지 연동하고 싶습니다ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">.
ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">
ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">
고지서에서 전체 전기료ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">, 수도세ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">, 보험비가 나오며 상가별로 사용내역이 표기되면 좋을 것 같습니다ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">.
ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">
ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">
회사로고도 삽입되면 좋구요ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">.
ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">
ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">
본고지서는 납기후금액을 나타낼 수 있는 란도 있음 좋을 것 같습니다ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">.(이자율ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">5%)
ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">
ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">
추가로 본고지서는 문자이미지 파일 및 출력 청구가 되며ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">, 대표계좌 또는 가상계좌번호란도 들어가야 할 것 같습니다ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">.
ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">
ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">
자동이체 ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">cmsng=EN-US style="mso-fareast-font-family: 함초롬바탕"> 신청란과 전월 수납확인서도 삽입되면 좋을 것 같구ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">, 자체적으로 수납확인을 체크할 수 있는 란도 있어서 통합월별 종합납부현황페이도 있으면 좋을 것 같습니다ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">.
pan class='search_bold'>pacpan>e prefix = "o" />