Jさんのご要望に基づき、Lと同様AとBとの関連をまとめた表です。
まずシートCのセルDをご覧下さい。赤枠内がAの集約結果であり、青枠内の値がBの値です。
Cの左側の列にRからのリンクを貼っていますのでここをたどれば各々の値の出所が分かると思います。
Rは各シートに番号を振り、各部署の回答データをそのまま記載しています。
またEの結果は注意事項があります。Fの合計値は記載の通りですが、Gで部署毎の集約が間に合わなかったためHで調整しています。
なおご依頼頂いたZは、Kさんから表を送ります
Rating
44
Translation / English
- Posted at 02 Aug 2018 at 17:30
Based on Mr. J's request, I have made a table summarizing the relationship between A and B just as L.
First, look at Cell D of Sheet C. The inside of the red frame is the aggregation result of A, and the value within the blue frame is the value of B.
Since I'm putting a link from R on the left column of C, I think that you can know the source of each value by tracing here.
R assigns numbers to each sheet and describes the answer data of each department as it is.
There are also notes on the result of E. The total value of F is as described, but it is adjusted by H because aggregation by department in G was not in time.
As for the Z you have requested will be sent as a table from Mr. K
tgvicektx likes this translation
First, look at Cell D of Sheet C. The inside of the red frame is the aggregation result of A, and the value within the blue frame is the value of B.
Since I'm putting a link from R on the left column of C, I think that you can know the source of each value by tracing here.
R assigns numbers to each sheet and describes the answer data of each department as it is.
There are also notes on the result of E. The total value of F is as described, but it is adjusted by H because aggregation by department in G was not in time.
As for the Z you have requested will be sent as a table from Mr. K
Translation / English
- Posted at 02 Aug 2018 at 17:28
In accordance with J-san's wishes, here is the summary table of the relationship between A and B done in the same manner as for L.
First of all, please look at cell D of sheet C. The red cell contains the aggregated results of A while the green cell contains the value for B.
In the column to the left of C, there is a link to R. You will be able to see the sources of the various values from here.
R has numbers indicated in every sheet which lists the response data from various departments accordingly.
In addition, there is something to take note for E's results. The total value of F is as shown but for G, the consolidation from the departments was not completed in time so this is adjusted in H.
As requested, table Z will be sent by K-san.
tgvicektx likes this translation
First of all, please look at cell D of sheet C. The red cell contains the aggregated results of A while the green cell contains the value for B.
In the column to the left of C, there is a link to R. You will be able to see the sources of the various values from here.
R has numbers indicated in every sheet which lists the response data from various departments accordingly.
In addition, there is something to take note for E's results. The total value of F is as shown but for G, the consolidation from the departments was not completed in time so this is adjusted in H.
As requested, table Z will be sent by K-san.
Translation / English
- Posted at 02 Aug 2018 at 17:38
This is a table summarizing the relationship between A and B just like L, based on Mr. J's request, .
First, please look at Cell D of Sheet C. The aggregation result of A is shown inside the red frame, and the value of B is inside the blue frame.
The link from R is on the left column of C, therefore I think that you can get to the source of each value by tracing.
As for R, numbers are assigned to each sheet and describes the original answer data of each department.
Also, there are some points that must be kept in mind about the result of E. The total value of F is as described, but it is adjusted by H because we didn't make it on time to aggregate for each department for G.
The requested Z will be sent as a table from Mr. K.
tgvicektx likes this translation
First, please look at Cell D of Sheet C. The aggregation result of A is shown inside the red frame, and the value of B is inside the blue frame.
The link from R is on the left column of C, therefore I think that you can get to the source of each value by tracing.
As for R, numbers are assigned to each sheet and describes the original answer data of each department.
Also, there are some points that must be kept in mind about the result of E. The total value of F is as described, but it is adjusted by H because we didn't make it on time to aggregate for each department for G.
The requested Z will be sent as a table from Mr. K.