tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 221085d1363362556-same-formula-works-in-1-spreadsheet-but-no-another-not-working-tracking-sheet-template-new
Sheet: Tracking Sheet

Project Details: | Title |  | Narrator(s) | Producers Book | Narrators Book
 |  |  |  | Select | Select
 | Last Studio Date: |  |  |  | Select
 | Proof Audio Required By: |  |  |  | Select
 | Corrections Due By: |  |  |  | Select
 | Final Audio Required By:
Formats Required: |  |  | Co-Production |  | Number of Pages in Book | Average Pages Per Session | Pages Left to Record
 |  |  | No |  | 320 | 47.5 | 130
Downloads ISBN
Library CD ISBN |  |  |  |  |  | Average Minutes Per Session | Pages To Record Per Remaining Sessions
Cassette ISBN
Trade CD ISBN |  |  | No. Sessions Booked | Sessions Used | [NAME]
MP3 CD ISBN |  |  | 8 | 4 | 4 | 101.75 | 32.5
 |  | Producer | Date | AM/PM/Eve | Recorded Up to Page | Time on Time Line | Minutes Recorded | Pages Recorded
[NAME]: | Session 1 |  |  | AM | 50 | 01:47:00 | 107 | 50
 | Session 2 |  |  | Select | 105 | 03:13:00 | 86 | 55
 | Session 3 |  |  | Select | 140 | 04:50:00 | 97 | 35
 | Session 4 |  |  | Select | 190 | 06:47:00 | 117 | 50
 | Session 5 |  |  | Select
 | Session 6 |  |  | Select
 | Session 7 |  |  | Select
 | Session 8 |  |  | Select
 | Session 9 |  |  | Select
 | Session 10 |  |  | Select
 | Session 11 |  |  | Select
 | Session 12 |  |  | Select
 | Session 13 |  |  | Select
 |  | Based on the average minutes recorded the narrator is not achieving close to 100 minutes. Please let [NAME] know. |  |  |  |  | Date Finished In Studio
 |  | Based on the average pages per session recorded it looks like more sessions need to be booked
Announcements
Side Announcements Required For |  | 6 CD's | 12 [NAME] | 67.8 mins Average Running Time Per CD
Producer Notes:
Post Production: |  |  |  |  |  |  |  | MP3 CD
 |  | Proof Audio |  | Final Downloads Masters |  | Library CD
 |  | Bounced |  | Bounced |  | Must Be Split Over | 6 CD's | Must Be Split Over
 |  | Converted to Flac |  | Data DVD Burnt |  | Side Splits Done
 |  | FTP'd |  | Masters FTP'd |  | PQ'd
 |  | MP3 L/P Created |  | DVD Posted |  | CD's Burnt
 |  | MP3 E-Mailed |  | Cassettes |  | CD's Posted
 |  | Running Time & No of CD's E-Mailed |  | Must Be Split Over | 12 [NAME] | Trade CD (2 copies required)
 |  | Final Editing |  | Side Splits Done |  | Must Be Split Over | 6 CD's
 |  | Corrections Received |  | PQ'd With 3 Tracks |  | Side Splits Done
 |  | Corrections Progress | Select | CD's Burnt |  | PQ'd
 |  |  |  | CD's Posted |  | CD's Burnt
 |  |  |  |  |  | CD's Posted
 |  | Random House Co-Productions Require 3 copies of all CD Masters & 2 Copies of Download Masters
Spreadsheet: 406195fa-c86b-463a-abf5-051374d47aa2
Sheet: Sheet1

Yeast ORF | Family | Human
name |  | homologue
Ras2 | [NAME] family - Ras superfamily | [NAME]
[NAME] | [NAME] family - Ras superfamily | Rap1b
Ypt52 | Rab family - Ras superfamily | hRab
Arf1 | Sar1/Arf family - Ras superfamily | Arf1
Cin4 | Sar1/Arf family - Ras superfamily | Unknown
Tem1 | [NAME] superfamily | Unknown
Cns1 | Cyclophilin | Unknown
Cpr6 | Cyclophilin | CyclophilinA
Cpr7 | Cyclophilin | Unknown
Cpr8 | Cyclophilin | Unknown
 | Table S3
Spreadsheet: 167949d1342166767-lookup-values-accross-several-sheets-to-create-summary-sheet-example-workbook
Sheet: Season1

 | Division | Standing | Cup | Playoffs | Goals | Cup goals | [NAME] |  | Sarjataso | Sijoitus | Cup | Playoffs | Goals | Cup goals | [NAME] |  | Sarjataso | Sijoitus | Cup | Playoffs | Goals | Cup goals | [NAME] |  | Sarjataso | Sijoitus | Cup | Playoffs | Goals | Cup goals | [NAME]
Team 1 |  | 15 | 4 | 0 |  |  |  | Team 5 |  | 14 | 2 | 0 |  |  |  | Team 9 |  | 8 | 3 | 0 |  |  |  | Team 13 |  | 11 | 1 | 0
Player1 |  |  |  |  | 3 |  |  | Player10 |  |  |  |  | 1 |  |  | Player13 |  |  |  |  |  |  |  | Player25 |  |  |  |  | 2
Player2 |  |  |  |  |  | 2 |  | Player11 |  |  |  |  |  |  |  | Player14 |  |  |  |  |  |  |  | Player26
Player3 |  |  |  |  | 1 |  |  | Player12 |  |  |  |  |  |  |  | Player15 |  |  |  |  | 1 | 1 |  | Player27 |  |  |  |  | 1
Team 2 |  | 3 | 1 | 2 |  |  |  | Team 6 |  | 6 | 1 | 2 |  |  |  | Team 10 |  | 1 | 1 | 3 |  |  |  | Team 14 |  | 10 | 2 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Radiscal
Player4 |  |  |  |  |  | 1 |  | Player10 |  |  |  |  | 1 | 1 |  | Player16 |  |  |  |  | 3 |  |  | Player28 |  |  |  |  |  | 1
Player5 |  |  |  |  | 1 |  |  | Player11 |  |  |  |  | 1 |  |  | Player17 |  |  |  |  | 2 |  |  | Player29 |  |  |  |  | 1
Player6 |  |  |  |  | 1 |  |  | Player12 |  |  |  |  |  |  |  | Player18 |  |  |  |  | 1 |  |  | Player30 |  |  |  |  | 1
Team 3 |  | 11 | 2 | 0 |  |  |  | Team 7 |  | 5 | 5 | 1 |  |  |  | Team 11 |  | 2 | 1 | 4 |  |  |  | Team 15 |  | 16 | 1 | 0
Player7 |  |  |  |  |  |  |  | Player10 |  |  |  |  |  |  |  | Player19 |  |  |  |  | 1 |  |  | Player31
Player8 |  |  |  |  |  |  |  | Player11 |  |  |  |  | 1 |  |  | Player20 |  |  |  |  |  |  |  | Player32 |  |  |  |  | 2
Player9 |  |  |  |  | 1 |  |  | Player12 |  |  |  |  | 2 |  |  | Player21 |  |  |  |  |  |  |  | Player33
Team 4 |  | 7 | 1 | 0 |  |  |  | Team 8 |  | 4 | 3 | 5 |  |  |  | Team 12 |  | 13 | 2 | 2 |  |  |  | Team 16 |  | 9 | 1 | 0
Player10 |  |  |  |  | 1 |  |  | Player10 |  |  |  |  | 1 |  | 1 | Player22 |  |  |  |  | 1 |  |  | Player34
Player11 |  |  |  |  |  |  |  | Player11 |  |  |  |  | 1 | 1 | 2 | Player23 |  |  |  |  |  |  |  | Player35
Player12 |  |  |  |  |  |  |  | Player12 |  |  |  |  | 2 |  |  | Player24 |  |  |  |  |  |  |  | Player36
Spreadsheet: 192447d1352408926-checking-duplicates-in-one-column-while-other-column-is-different-dummy2-bb-
Sheet: Sheet1

Webinar | FirstName | LastName | [NAME] | Attendance Duration | Attendance Duration |  |  | Email list | [NAME] attended
Example 1 | Bethany | Evans | [EMAIL] | 56.0 mins | 56
Example 1 | Beverly | Kleeman | [EMAIL] | 13.0 mins | 13
Example 1 | Beverly | Kleeman | [EMAIL] | 56.0 mins | 56
Example 1 | Beverly | Kleeman | [EMAIL] | 14.0 mins | 14
Example 1 | [NAME] | Cooper | [EMAIL] | 66.0 mins | 66
Example 1 | Constance | Peterson-Miller | [EMAIL] | 79.0 mins | 79
Example 1 | Constance | Peterson-Miller | [EMAIL] | 80.0 mins | 80
End Result
Example 1 | Constance | Peterson-Miller | [EMAIL] | 79.0 mins | 79
Example 1 | Constance | Peterson-Miller | [EMAIL] | 80.0 mins | 80
Example 1 | Beverly | Kleeman | [EMAIL] | 13.0 mins | 13
Example 1 | Beverly | Kleeman | [EMAIL] | 56.0 mins | 56
Example 1 | Beverly | Kleeman | [EMAIL] | 14.0 mins | 14
OR
Example 1 | Constance | Peterson-Miller | [EMAIL] | 159 mins | 159
Example 1 | Beverly | Kleeman | [EMAIL] | 83 mins | 83
Spreadsheet: 06f44090-0528-4b44-86b1-f7cac388def8
Sheet: Sheet1

2012 - 2013 Timelines: Personnel and [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Annual Faculty Evaluations/Post Tenure Review
 | 2nd Year Faculty | 1st Year Faculty | Annual Faculty Evaluations | Post Tenure Review
Dept Chair to Dean | 2012-10-05 00:00:00 | 2013-01-25 00:00:00 | 2012-11-09 00:00:00 | 2013-03-04 00:00:00
[NAME] to Provost | 2012-10-26 00:00:00 | 2013-02-08 00:00:00 | 2012-12-07 00:00:00 | 2013-03-20 00:00:00
Provost to President | 2012-11-19 00:00:00 | 2013-02-15 00:00:00 | 2012-12-21 00:00:00 | 2013-04-05 00:00:00
Tenure and Promotion
 | Tenure | Promotion
Dept Chair to Dean | 2012-10-12 00:00:00 | 2012-10-12 00:00:00
Dean to College Committee on T&P | 2012-11-02 00:00:00 | 2012-11-02 00:00:00
Committee to Provost and VPAA | 2012-12-07 00:00:00 | 2012-12-07 00:00:00
Provost to President | 2013-01-04 00:00:00 | 2013-01-04 00:00:00
Curriculum Changes
 | October 12 | December 13-14 | Feb 28-Mar 1 | May 16-17 | August 8-9 | TBA | December 12-13
 | Board Meeting* | Board Meeting | Board Meeting | Board Meeting | Board Meeting | Board Meeting* | Board Meeting
Dept Chair to Dean |  | 2012-09-21 00:00:00 | 2012-11-02 00:00:00 | 2013-02-08 00:00:00 | 2013-04-05 00:00:00 |  | 2013-09-13 00:00:00
[NAME] to College Curriculum Committee |  | 2012-09-28 00:00:00 | 2012-11-09 00:00:00 | 2013-02-15 00:00:00 | 2013-04-12 00:00:00 |  | 2013-09-20 00:00:00
College Curriculum Committee / Registrar to University Curriculum Committee |  | 2012-10-05 00:00:00 | 2012-11-16 00:00:00 | 2013-02-22 00:00:00 | 2013-04-19 00:00:00 |  | 2013-09-27 00:00:00
University Curriculum Committee / Provost |  | 2012-10-12 00:00:00 | 2012-11-30 00:00:00 | 2013-03-01 00:00:00 | 2013-04-26 00:00:00 |  | 2013-10-04 00:00:00
Provost to President |  | 2012-10-19 00:00:00 | 2012-12-07 00:00:00 | 2013-03-08 00:00:00 | 2013-05-03 00:00:00 |  | 2013-10-11 00:00:00
Board of Regents Meeting | 2012-10-12 00:00:00 | 12/13-14/2012 | 2/28-3/1/2013 | 5/16-17/2013 | 8/8-9/2013 | TBA | 12/12-13/2013
* For special curriculum items only
Spreadsheet: 749221d1632603476-need-formula-to-transpose-non-zero-data-test
Sheet: Sheet1

Data Array: |  |  |  |  |  |  |  | Desired Look:
Counter | Alpha | Beta | Gamma | Delta | Epsilon | Zeta |  |  | 1 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 5
1 | 0 | 0 | 10 | 10 | 0 | 50 |  | Gamma | 10 |  | Alpha | 20 |  |  |  |  | Beta | 50 |  | Alpha | 20
2 | 20 | 0 | 0 | 0 | 0 | 20 |  | Delta | 10 |  | Zeta | 20 |  |  |  |  | Gamma | 10 |  | Delta | 60
3 | 0 | 0 | 0 | 0 | 0 | 0 |  | Zeta | 50 |  |  |  |  |  |  |  | Epsilon | 10
4 | 0 | 50 | 10 | 0 | 10 | 0
5 | 20 | 0 | 0 | 60 | 0 | 0
Spreadsheet: darrell_schoolcraft__7706__November 2002 Maint
Sheet: Sheet1

NOVEMBER 2002
2002-03-06 00:00:00
SUN | MON | TUE | WED | THU | FRI | SAT
 |  |  |  |  | 1 | 2
3 | 4 | 5 | 6 | 7 | 8 | 9
Mojave Topock PLC
10 | 11 | 12 | 13 | 14 | 15 | 16
Mojave Topock PLC
17 | 18 | 19 | 20 | 21 | 22 | 23
Mojave Topock PLC
24 | 25 | 26 | 27 | 28 | 29 | 30
Spreadsheet: 790901d1660055753-need-to-to-return-id-when-there-are-2-condition-2022-08-09-oeldere-harry-basra-sample-8-
Sheet: Sheet1

 | Name | system | ID Code |  |  |  |  | Maxi |  |  | SAP
 | HOLLYWELLN1 | Maxi | TEC-10001-000010 |  |  |  |  | HOLLYWELLN1 |  |  | HOLLYWELLN1
 | MAXWELLR16 | Maxi | TEC-10002-000001 |  |  |  |  | MAXWELLR16 |  |  | MAXWELLR16
 | MAXWELLR17 | Maxi | TEC-10002-000002 |  |  |  |  | MAXWELLR17 |  |  | MAXWELLR17
 | HOLLYWELLN1 | SAP | TEC-10001-000011 |  |  |  |  | HOLLYWELLN1 |  |  | HOLLYWELLN1
 | MAXWELLR118 | SAP | TEC-[PHONE] |  |  |  |  | MAXWELLR118 |  |  | MAXWELLR118
 | MAXWELLR119 | SAP | TEC-10002-000002 |  |  |  |  | MAXWELLR119 |  |  | MAXWELLR119
Spreadsheet: 738261d1624939323-char-64-column-for-columns-past-z-plus-linking-that-to-another-formula-ians-testing-sheet
Sheet: master sheet

 |  |  | Heading 1 |  | Heading 2 |  |  |  |  |  |  |  |  | Heading 3 |  |  |  |  |  |  | Heading 4 |  |  | OVERALL |  | Test 1 | test 2
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28
Spreadsheet: 59302d1259792978-drop-down-menus-studio-session-record-with-time-page-v2
Sheet: Item Form

 |  |  |  |  | Studio Session Record
 |  |  |  |  | Session Record No:
 |  | Client: |  |  | Date:
 |  |  |  |  | P.O. No:
 |  |  |  |  | Personnel:
 |  |  | Identification:
 |  | ProTools: | 7.4
 |  | kHz: | 44.1
 |  | Bit-Rate: | 24
 |  | Qty. | Code | Description |  | Disc. | Manual Over-Ride | Unit Cost | Extended Price
 |  | 1 | M208 | ADDITIONAL SPOT LINERS |  | 0.05 | 12 | 12 | 11.4
 |  | 1 | M222 | HOUR(s) KEYLINE/PASTE UP |  |  |  | 40 | 40
 |  | 1 | S307 | DAT AUDIO MASTER(S) |  |  | 0.21 | 0.21 | 0.21
 |  | 1 | M210 | HOUR(S) CLIENT CONSULTATI |  |  | 0.01 | 0.01 | 0.01
 |  | 1 | M208 | ADDITIONAL SPOT LINERS |  |  |  | 35 | 35
 |  | 1 | M270 | DINING GUIDE WEEK OF |  |  |  | 1580 | 1580
 |  | 30 | M206 | FIRST SPOT |  |  |  | 625 | 18750
 |  | 1 | M210 | HOUR(S) CLIENT CONSULTATI |  |  |  | 100 | 100
 |  | 1 | M208 | ADDITIONAL SPOT LINERS |  |  |  | 35 | 35
 |  | 1 | M206 | FIRST SPOT |  |  |  | 625 | 625
 |  | 1 | M207 | ADDITIONAL SPOTS |  |  |  | 475 | 475
 |  | 1 | M210 | HOUR(S) CLIENT CONSULTATI |  |  |  | 100 | 100
 |  | 2 | M207 | ADDITIONAL SPOTS |  |  |  | 475 | 950
 |  |  |  |  |  |  |  | Total: | 22701.62
 |  | Authorized By:
 |  | All properties left on our premises are stored at owner's risk.
Spreadsheet: 270207d1381415122-combining-two-excel-formulas-sample-2
Sheet: Sheet1

Formula A
[NAME]
Date | Project e.g. HFI | Task Number | CR/INFRA number | Task Description | CR Client | Assigned to | [NAME] (QA) | Expected Delivery from Dev to QA (i.e. [NAME] plus 1 day) | QA Target Completion Date (from Dev Plan QA Finish Date) to meet planned delivery deadline PRIORITY | "R" Ready for Testing | Task Status | Helper Column To Fetch CR Number Below formula is array formula after any change hold control and shift then hit enter | Column For Counting Unique Values which can be hidden after words | Picked up to Test | QA Plan Reviewed By | Defects Raised and Status
2009-09-29 00:00:00 | IF Only |  | CR1954 |  |  |  |  |  |  | R | P |  |  |  |  | 1222
2009-04-13 00:00:00 |  |  | INT006 |  |  |  |  |  |  | R | ON HOLD |  |  |  |  | 1133
2010-02-01 00:00:00 | IF Only |  | INT016 |  |  |  |  |  |  |  | P
2010-02-01 00:00:00 | IF only |  | INT019 |  |  |  |  |  |  | R | ON HOLD |  |  |  |  | 1323
 | IF |  | INT062 |  |  |  |  |  |  |  | P
2010-06-22 00:00:00 | WS |  | INT062 |  |  |  |  |  |  | R | P
2011-01-10 00:00:00 | BO |  | INT062 |  |  |  |  |  |  | R | P
2010-10-04 00:00:00 | BO/IF |  | INT062 |  |  |  |  |  |  | R | P |  |  |  |  | 133
2009-10-13 00:00:00 | ENC | Encore | ENC0013 |  |  |  |  |  |  | R
2009-11-12 00:00:00 | ENC | Encore | ENC0010 |  |  |  |  |  |  | R | P
2009-11-12 00:00:00 | ENC |  | ENC0012 |  |  |  |  |  |  | ? See comments
2011-08-01 00:00:00 | BO/IF |  | R172233 |  |  |  |  |  |  | R | P
2011-10-13 00:00:00 | WS |  | LSR-INT-030 |  |  |  |  |  |  | R | P |  |  |  |  | 12223
2012-01-17 00:00:00 |  |  | CR160 |  |  |  |  |  |  | R | P |  |  |  |  | 1224
2012-02-08 00:00:00 | IF |  | CR160 |  |  |  |  |  |  | R | P
2012-03-16 00:00:00 |  |  | CR160 |  |  |  |  |  |  | R | P
 |  |  |  |  |  |  |  |  |  |  | Results--->
Spreadsheet: 1d550d34-5c9b-4d6b-9172-5dec8ff55e45
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  | CLUB NAME: |  |  |  |  | CLUB CATEGORY:
 |  | CONTACT PERSON: |  |  |  |  | Small = < 50 members
 |  | ADDRESS: |  |  |  |  | Large = 50+ members
 |  | CITY:
 |  | STATE: |  |  | ZIP:
 |  | CLUB WEB SITE:
 | DATE: (below) | PHONE:
 |  | EMAIL:
 | LAST NAME | FIRST NAME | SEX | AGE | DOB | USAT Number | CITY | STATE
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
Spreadsheet: 455674d1460463480-formula-returning-results-for-two-separate-cells-iferror
Sheet: Sheet3

 |  |  |  |  | IMHO
 |  | -10
 |  | 10
 |  | abc
 |  | 1st
 |  | 2nd
 |  | Imho
Spreadsheet: 58372d1258635191-using-userform-to-update-cells-tlotm
Sheet: Weightings

January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
Priv Ult |  | Priv Ult |  | Priv Ult |  | Priv Ult |  | Priv Ult |  | Priv Ult |  | Priv Ult |  | Priv Ult |  | Priv Ult |  | Priv Ult |  | Priv Ult |  | Priv Ult
Priv NB |  | Priv NB |  | Priv NB |  | Priv NB |  | Priv NB |  | Priv NB |  | Priv NB |  | Priv NB |  | Priv NB |  | Priv NB |  | Priv NB |  | Priv NB
Priv Ren |  | Priv Ren |  | Priv Ren |  | Priv Ren |  | Priv Ren |  | Priv Ren |  | Priv Ren |  | Priv Ren |  | Priv Ren |  | Priv Ren |  | Priv Ren |  | Priv Ren
Priv MT |  | Priv MT |  | Priv MT |  | Priv MT |  | Priv MT |  | Priv MT |  | Priv MT |  | Priv MT |  | Priv MT |  | Priv MT |  | Priv MT |  | Priv MT
Priv MLP |  | Priv MLP |  | Priv MLP |  | Priv MLP |  | Priv MLP |  | Priv MLP |  | Priv MLP |  | Priv MLP |  | Priv MLP |  | Priv MLP |  | Priv MLP |  | Priv MLP
Priv GHC |  | Priv GHC |  | Priv GHC |  | Priv GHC |  | Priv GHC |  | Priv GHC |  | Priv GHC |  | Priv GHC |  | Priv GHC |  | Priv GHC |  | Priv GHC |  | Priv GHC
DL Ult |  | DL Ult |  | DL Ult |  | DL Ult |  | DL Ult |  | DL Ult |  | DL Ult |  | DL Ult |  | DL Ult |  | DL Ult |  | DL Ult |  | DL Ult
DL NB |  | DL NB |  | DL NB |  | DL NB |  | DL NB |  | DL NB |  | DL NB |  | DL NB |  | DL NB |  | DL NB |  | DL NB |  | DL NB
DL MLP |  | DL MLP |  | DL MLP |  | DL MLP |  | DL MLP |  | DL MLP |  | DL MLP |  | DL MLP |  | DL MLP |  | DL MLP |  | DL MLP |  | DL MLP
DL GHC |  | DL GHC |  | DL GHC |  | DL GHC |  | DL GHC |  | DL GHC |  | DL GHC |  | DL GHC |  | DL GHC |  | DL GHC |  | DL GHC |  | DL GHC
[NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME]
H+W |  | H+W |  | H+W |  | H+W |  | H+W |  | H+W |  | H+W |  | H+W |  | H+W |  | H+W |  | H+W |  | H+W
Compliance |  | Compliance |  | Compliance |  | Compliance |  | Compliance |  | Compliance |  | Compliance |  | Compliance |  | Compliance |  | Compliance |  | Compliance |  | Compliance
Audit |  | Audit |  | Audit |  | Audit |  | Audit |  | Audit |  | Audit |  | Audit |  | Audit |  | Audit |  | Audit |  | Audit
QM |  | QM |  | QM |  | QM |  | QM |  | QM |  | QM |  | QM |  | QM |  | QM |  | QM |  | QM
Ultilisation |  | Ultilisation |  | Ultilisation |  | Ultilisation |  | Ultilisation |  | Ultilisation |  | Ultilisation |  | Ultilisation |  | Ultilisation |  | Ultilisation |  | Ultilisation |  | Ultilisation
Comfort |  | Comfort |  | Comfort |  | Comfort |  | Comfort |  | Comfort |  | Comfort |  | Comfort |  | Comfort |  | Comfort |  | Comfort |  | Comfort
Spreadsheet: 857652d1706619382-create-a-contents-list-from-multiple-tabs-test-data
Sheet: Sheet6

Report Name | Work Task | Details | Reference | x-story | Due Date
Example 1 | Example 1 | Example 1 | MIS-6860 | Example 1 | 2024-02-29 00:00:00
Example 2 | Example 2 | Example 2 | MIS-6761 | Example 2 | 2024-01-31 00:00:00
Example 3 | Example 3 | Example 3 |  | Example 3
Example 4 | Example 4 | Example 4 | MIS-6848 | Example 4
Example 5 | Example 5 | Example 5 | MIS-6780 | Example 5 | 2024-01-31 00:00:00
Example 6 | Example 6 | Example 6 | MIS-6366 | Example 6 | 2024-01-31 00:00:00
Spreadsheet: 876879d1723592996-divide-number-of-months-to-add-to-columns-book2
Sheet: Sheet1

 |  | 2024-08-01 00:00:00
 |  | [NAME]. Building Work Days | Total of Floors | Total Building Work Days | Workdays in a month | Months
 |  | 39 | 24 |  | 20
 |  | 39 | 60 |  | 20
 |  | 39 | 70 |  | 20
 |  | 39 | 80 |  | 20
 |  | 39 | 90 |  | 20
 |  |  |  |  |  | The idea is that it will calculate the number of months from the 'total building work days', then divide that by 20(for the number of days in a month)
 |  |  |  |  |  | It will then get the 'total of floors' divid that by the number of 'months' and then roundup and fill in the quantity of months from the provided month
Spreadsheet: 92762d1292322619-creating-a-multi-criteria-drop-down-copy-of-temp2
Sheet: Sheet1

Program Name | Sales Value |  | Inventory Value |  | Impact on Product or Service quality |  | Impact on financial statement & reporting |  | Impact on Brand & market reputation
 | Criteria | Rating | Criteria | Rating | Criteria | Rating | Criteria | Rating | Criteria | Rating |  |  | criteria | rating
Protection of Information Assets |  |  |  |  |  |  |  |  |  |  |  | Impact on financial statement & reporting | Marginal | 1
Budgeting & Management reporting |  |  |  |  |  |  |  |  |  |  |  | Impact on financial statement & reporting | Low | 2
Intellectual property |  |  |  |  |  |  |  |  |  |  |  | Impact on financial statement & reporting | Medium | 3
Mobile phone policy & payments |  |  |  |  |  |  |  |  |  |  |  | Impact on financial statement & reporting | High | 4
Revenue |  |  |  |  |  |  |  |  |  |  |  | Impact on financial statement & reporting | Extreme | 5
Fixed Assets |  |  |  |  |  |  |  |  |  |  |  | Impact on Product or Service quality | Marginal | 1
 |  |  |  |  |  |  |  |  |  |  |  | Impact on Product or Service quality | Low | 2
 |  |  |  |  |  |  |  |  |  |  |  | Impact on Product or Service quality | Medium | 3
 |  |  |  |  |  |  |  |  |  |  |  | Impact on Product or Service quality | High | 4
 |  |  |  |  |  |  |  |  |  |  |  | Impact on Product or Service quality | Extreme | 5
 |  |  |  |  |  |  |  |  |  |  |  | Inventory Value | > 1 mio < 2 mio | 1
 |  |  |  |  |  |  |  |  |  |  |  | Inventory Value | > 2 mio < 3 mio | 2
 |  |  |  |  |  |  |  |  |  |  |  | Inventory Value | > 3 mio < 5 mio | 3
 |  |  |  |  |  |  |  |  |  |  |  | Inventory Value | > 5 mio | 4
 |  |  |  |  |  |  |  |  |  |  |  | Sales Value | > 1 mio < 2 mio | 1
 |  |  |  |  |  |  |  |  |  |  |  | Sales Value | > 2 mio < 3 mio | 2
 |  |  |  |  |  |  |  |  |  |  |  | Sales Value | > 3 mio < 5 mio | 3
 |  |  |  |  |  |  |  |  |  |  |  | Sales Value | > 5 mio | 4
Spreadsheet: 794530d1662099935-need-a-formula-to-find-the-most-recent-value-unless-its-zero-find-last-cell-bigger-than-0-aligw
Sheet: Sheet1

OVERVIEW
 | END - 2021 | END - JAN | END - FEB | END - MAR | END - APR | END - MAY | END - JUN | END - JUL | END - AUG | END - SEP | END - OCT | END - NOV | END - DEC | ANNUAL GROWTH
Assets
Liabilities
NET WORTH
 | This sample data isn't really very well thought out - all values are the same, so it isn't truly representative of your real data!
ASSET | END - 2021 | END - JAN | END - FEB | END - MAR | END - APR | END - MAY | END - JUN | END - JUL | END - AUG | END - SEP | END - OCT | END - NOV | END - DEC
Account 1 | 200 | 200 | 300 | 200 | 200 | 200 | 200 | 200 | 300
Account 2 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
Account 3 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
MONTHLY TOTAL
LIABILITY | END - 2021 | END - JAN | END - FEB | END - MAR | END - APR | END - MAY | END - JUN | END - JUL | END - AUG | END - SEP | END - OCT | END - NOV | END - DEC
Liability 1 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
Liability 2 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
Liability 3 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
MONTHLY TOTAL