Tasirin sufuri shine aiki na gano mafi kyawun hanya don daukar nauyin kaya iri iri daga mai sayarwa ga mai siye. Manufarsa ita ce samfurin da ake amfani dashi a wasu fannoni na ilmin lissafi da tattalin arziki. A cikin Microsoft Excel, akwai kayan aikin da zasu taimaka wajen warware matsalolin matsalar sufuri. Nemo yadda za a yi amfani da su a cikin aiki.
Janar bayanin yanayin matsalar sufuri
Babban manufar aikin sufuri shi ne neman kyakkyawan tsarin sufuri daga mai sayarwa ga mai siyarwa a farashin kuɗi. Yanayin irin wannan aiki an rubuta shi a cikin hanyar makirci ko matrix. Don Excel, ana amfani da nau'in matrix.
Idan yawan adadin kaya a cikin kamfanoni na mai sayarwa daidai yake da nauyin buƙatar, ana kira aikin sufuri rufe. Idan waɗannan alamun ba su daidaita ba, to ana kira wannan aikin sufuri bude. Don magance shi, dole ne a rage yanayin zuwa nau'in rufe. Don yin wannan, ƙara mai sayarwa ko cin hanci da rashawa tare da hannun jari ko bukatun daidai da bambancin tsakanin samarwa da buƙata a cikin ainihin halin da ake ciki. A lokaci guda, an ƙara ƙarin shafi ko jere tare da lambobi marasa daraja a tebur kudin.
Kayan aiki don magance matsalolin sufuri a Excel
Don warware matsalar matsala a Excel, ana amfani da aikin "Bincika don bayani". Matsalar ita ce ta hanyar tsoho an kashe shi. Don taimaka wannan kayan aiki, kana buƙatar yin wasu ayyuka.
- Matsa zuwa shafin "Fayil".
- Danna kan sashe "Zabuka".
- A cikin sabon taga, je zuwa rubutun Ƙara-kan.
- A cikin toshe "Gudanarwa"wanda yake a kasan taga wanda ya buɗe, a jerin jeri, dakatar da zaɓi a kan abu Ƙara Add-ins. Danna maballin. "Ku tafi ...".
- Ƙarar kunnawa kunnawa ta fara. Duba akwatin kusa da abu "Gano bayani". Danna maballin "Ok".
- Saboda wadannan ayyukan a cikin shafin "Bayanan" a cikin akwatin saitunan "Analysis" wani maɓalli yana bayyana akan rubutun "Gano bayani". Za mu buƙace shi lokacin da muke nema don warware matsalar matsalar sufuri.
Darasi: Binciken Maɓallin Magani a Excel
Misali na warware matsalar matsala a Excel
Yanzu bari mu dubi wani misali na warware matsalar matsalar sufuri.
Yanayin matsalar
Muna da masu sayarwa 5 da masu sayarwa 6. Sakamakon samar da kayayyaki masu yawa shine 48, 65, 51, 61, 53 raka'a. Masu saye suna bukatar: 43, 47, 42, 46, 41, 59 raka'a. Saboda haka, yawan kuɗi na samarwa daidai yake da yawan da ake buƙata, wato, muna aiki ne da tashar sufuri na rufe.
Bugu da ƙari, an ba da yanayin a matakan sufuri na sufuri daga wata aya zuwa wani, wanda aka nuna a kore a cikin zane a kasa.
Matsalolin matsala
Mun fuskanci aikin, a ƙarƙashin yanayin da aka ambata a sama, don rage yawan farashin sufuri zuwa ƙananan.
- Don magance matsalar, mun gina tebur tare da daidai yawan adadin kwayoyin kamar yadda matakan kudin da aka bayyana.
- Zaɓi kowane komai marar ciki a kan takardar. Danna kan gunkin "Saka aiki"zuwa hagu na dabarun tsari.
- "Wizard aiki" ya buɗe. A jerin da ya bayar, ya kamata mu sami aikin SUMPRODUCT. Zaɓi shi kuma danna maballin. "Ok".
- Ƙungiyar shigarwar shigarwar aiki ta buɗe. SUMPRODUCT. A matsayin hujja ta farko, shigar da kewayon sel a cikin matakan kudin. Don yin wannan, kawai zaɓi bayanan tantanin halitta tare da siginan kwamfuta. Shawara ta biyu ita ce kewayon Kwayoyin a cikin tebur wanda aka shirya don lissafi. Sa'an nan, danna maballin "Ok".
- Danna kan tantanin salula wanda yake a hagu na hagu na hagu na teburin don lissafi. Kamar yadda muka rigaya, mun kira Master of Functions, bude aikin muhawara a ciki. SUM. Danna kan filin jayayyar farko, zaɓi dukan jeri na saman sel a cikin tebur don lissafi. Bayan an shigar da su a cikin filin da aka dace, danna maballin "Ok".
- Muna zama a cikin kusurwar dama na tantanin halitta tare da aikin SUM. Alamar cika alama ta bayyana. Danna maballin hagu na hagu kuma jawo ƙoshin da aka cika har zuwa ƙarshen tebur don lissafi. Don haka muka koyi irin wannan.
- Danna kan tantanin halitta wanda yake a saman saman hagu na hagu na tebur don lissafi. Kamar yadda muka rigaya, muna kira aikin. SUM, amma wannan lokacin a matsayin wata hujja muna amfani da shafi na farko na teburin don lissafi. Muna danna maɓallin "Ok".
- Kwafi alamar alama ta cika wannan tsari don dukan layin.
- Jeka shafin "Bayanan". Akwai matakan kayan aiki "Analysis" danna maballin "Gano bayani".
- Zaɓin zaɓin bayani ya bude. A cikin filin "Sanya Ayyukan Target" saka tantanin halitta dauke da aikin SUMPRODUCT. A cikin toshe "Har sai" saita darajar "Ƙananan". A cikin filin "Canji sel na masu canji" muna nuna dukkan kewayon tebur don lissafi. A cikin akwatin saitunan "Daidai da ƙuntatawa" danna maballin "Ƙara"don ƙara wasu ƙuntataccen mahimmanci.
- Ƙarin ƙuntatawa yana farawa. Da farko, muna buƙatar ƙara yanayin cewa jimlar bayanai a layuka na tebur don lissafi dole ne ku daidaita da jimlar bayanan a layuka na tebur tare da yanayin. A cikin filin Bayanan salula saka adadin lamuni a cikin layuka na lissafi. Sa'an nan kuma saita daidai alamar (=). A cikin filin "Ƙuntatawa" saka adadin kuɗi a layuka na tebur tare da yanayin. Bayan haka, danna maballin "Ok".
- Hakazalika, mun ƙara yanayin cewa ginshiƙai na teburin biyu su zama daidai da juna. Ƙara ƙuntatawa cewa jimlar adadin dukan kwayoyin halitta a cikin tebur don lissafi dole ne ya fi girma ko kuma daidai da 0, da kuma yanayin cewa dole ne ya kasance mahaɗi. Ƙarin ra'ayi na ƙuntatawa ya zama daidai kamar yadda aka nuna a cikin hoton da ke ƙasa. Tabbatar tabbatar da cewa kusa da aya "Yi canje-canje ba tare da iyakancewa maras kyau ba" akwai wani kaska, kuma an zabi hanyar warwarewa "Bincike don magance matsalolin da ba a layi ba ta hanyar hanyar OPG". Bayan duk an saita saitunan, danna kan maballin. "Nemo bayani".
- Bayan haka, lissafi yana faruwa. Ana nuna bayanai a cikin sel na tebur don lissafi. Maɓallin binciken bincike ya buɗe. Idan sakamakon ya gamsar da ku, danna kan maballin. "Ok".
Kamar yadda kake gani, maganin matsala na sufuri a cikin Excel ya sauko don daidaitawar bayanan shigarwa. Shirin na kanta yana yin lissafin maimakon mai amfani.
