Overview

Hi,

This spreadsheet is consisted of the following 11 (eleven) worksheets:

1 - Cover

2 - Chart

3 - Rates

4 - Assumptions

5 - Set_Up_Process

6 - Suppliers

7 - Products

8 - Customers

9 - Transactions

10 - Cash

11 - Reports

 

  • Chart sheet gives you brief information about Sausage Casings Types.

 

  • Rates worksheet gets daily rates using Power Query. Depending on National Bank of Azerbaijan's web site, user must manually enter date in source step of Power Query to refresh the rates.  Please look at attached photo.
    You may find assumptions in the assumptions worksheet
  • Chart of Setup Process step by step can be found in the form of Organizational Chart in Set_Up_Process worksheet
  • Casings Suppliers with their contact information in Suppliers Worksheet
  • Products information in Products Worksheet
  • Customers in Azerbaijan in Customers Worksheet
  • Import, Sale, Return Transactions are done in Transactions Worksheet.
  • Cash based transactions can be found in Cash Worksheet
  • Three reports (Suppliers Based, Customers Based and Products Based) are shown in Reports Worksheet.

    Unique drop-down lists like Investors, Customers, Suppliers gathered using Power Query.  Some excel functions including Sumifs, Xlookup, If, etc. used in this spreadsheet.
    Wish you good luck in your business.

Reviews Add a review
No reviews yet

More From Excel World

Browse our top rated business templates. See All
Sausage Casings' Transactions Spreadsheet
448
16
Hi, This spreadsheet is consisted of the following 11 (eleven) worksheets: 1 - Cover 2 - Chart 3 - Rates…
Credit/Investment Calculation Excel Template
959
100
Hi there, With this Excel Template, you will be able to easily calculate the interest amounts you will pay or…
5-Year Plan Projection (Franchisee Store Opening)
999
164
With this template, when you get the sales representation rights of any company abroad in your own country, you can…
Moving Average and Linear Forcast Charts based on Şişecam Group of Companies' Sales Numbers
749
47
Source: https://www.sisecam.com.tr/en/investor-relations/presentations-and-bulletins/annual-reports   In statistics, a moving average (rolling average or running average) is a calculation to analyze data points by creating a…
Migration Tornado Chart by Gender & Age Group
811
35
Attached Excel Migration Tornado Chart (by Gender & Age Group in Azerbaijan, 2018) is like a four-sided (the first 2…
Dynamic Diagram...
889
51
Dynamic Diagram based upon the data (import from geographic regions) of the State Statistical Committee of the Republic of Azerbaijan...One…
See All