tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 69807d1270480119-date-formula-date-analysis-example-revised
Sheet: Sheet2

Analysis Year               Incept | Analysis   Valued                      As Of | Months of Development | What I want to see | YEARFRAC | DATEDIF
2008-10-01 00:00:00 | 2009-10-01 00:00:00 |  | 12
2008-10-01 00:00:00 | 2009-10-19 00:00:00 |  | 12
2008-10-01 00:00:00 | 2009-10-20 00:00:00 |  | 12
2008-10-01 00:00:00 | 2009-10-21 00:00:00 |  | 13
2008-10-01 00:00:00 | 2009-10-31 00:00:00 |  | 13
2008-10-01 00:00:00 | 2009-11-01 00:00:00 |  | 13
2008-10-01 00:00:00 | 2009-11-14 00:00:00 |  | 13
2008-10-01 00:00:00 | 2009-11-15 00:00:00 |  | 13
2008-10-01 00:00:00 | 2009-11-20 00:00:00 |  | 13
2008-10-01 00:00:00 | 2009-11-21 00:00:00 |  | 14
2008-10-01 00:00:00 | 2009-11-30 00:00:00 |  | 14
Spreadsheet: 270326d1381437839-can-offset-function-be-used-on-condition-offset-from-below
Sheet: Sheet2

 | Least 10 Performers
# | Login ID | Name | Final Score
1 | 7199 | Lydia Osei-Amoako | 94.44444444444444 |  | 1
2 | 7192 | [NAME] | 94.42028985507247 |  | 2
3 | 7200 | [NAME] | 94.42028985507247 |  | 3
4 | 7209 | [NAME] | 93.86473429951691 |  | 4
5 | 7255 | [NAME] | 92.86666666666667 |  | 5
6 | 7062 | Yvonne welbeck | 89.69806763285024 |  | 6
7 | 7214 | [NAME] | 88.75 |  | 7
8 | 7225 | [NAME] [NAME] | 79.72222222222223 |  | 8
9 | 7109 | [NAME] | 53.30917874396135 |  | 9
10 | 7238 | Patience Atanga | 15 |  | 10
Spreadsheet: 674492d1587874390-how-to-copy-a-row-based-an-input-into-a-specific-cell-and-paste-to-another-sheet-test-log-book
Sheet: TKR

2019-01-08 00:00:00 |  |  | 69 |  | F | OA Knee | L | [NAME] |  |  |  | F4 | T3 | I9 | P29
2019-09-08 00:00:00 |  |  | 70 |  | M | OA Knee | L | [NAME] |  |  |  | F5 | T5 | I9 | P32
13/8/2019 |  |  | 71 |  | F | OA Knee | L | [NAME] |  |  |  | F2 | T2 | I9 | P29
15/8/2019 |  |  | 78 |  | M | OA Knee | L | [NAME] |  |  |  | F7 | T6 | I9 | [NAME]
23/8/2019 |  |  | 64 |  | F | OA Knee | R | [NAME] | Robotic |  |  | F3 | T3 | I9 | P29
29/8/2019 |  |  | 65 |  | F | OA Knee | R | [NAME] |  |  |  | F5 | T6 | I9 | P32
30/8/2019 |  |  | 77 |  | F | OA Knee | L | [NAME] |  |  |  | F2 | T2 | I9 | P29
2019-03-09 00:00:00 |  |  | 72 |  | F | OA Knee | L | [NAME] |  |  |  | F5 | T4 | I9 | P35
10/9/2019 |  |  | 70 |  | M | OA Knee | R | [NAME] |  |  |  | F6 | T5 | I9 | P38
2019-12-09 00:00:00 |  |  | 61 |  | M | OA Knee | R | [NAME] |  |  |  | F5 | T5 | I9 | P32
2019-12-09 00:00:00 |  |  | 71 |  | F | OA Knee | R | [NAME] |  |  |  | F2 | T1 | I9 | P29
13/9/2019 |  |  | 71 |  | F | OA Knee | R | [NAME] |  |  |  | F5 | T5 | I9 | P32
13/9/2019 |  |  | 90 |  | M | OA Knee | R | [NAME] |  |  |  | F3 | T3 | I11 | P29
17/9/2019 |  |  | 59 |  | F | OA Knee | R | [NAME] |  |  |  | F4 | T4 | I9 | P32
17/9/2019 |  |  | 64 |  | M | OA Knee | L | [NAME] |  |  |  | F6 | T7 | I9 | P35
20/9/2019 |  |  | 74 |  | F | OA Knee | L | [NAME] |  |  |  | F4 | T4 | I9 | P29
30/9/2019 |  |  | 59 |  | M | OA Knee | L | [NAME] |  |  |  | F8 | T8 | I9 | P38 | PRESSFIT
2019-01-10 00:00:00 |  |  | 57 |  | F | OA Knee | R | [NAME] |  |  |  | F3 | T3 | I9 | P29
2019-01-10 00:00:00 |  |  | 60 |  | F | OA Knee | L | [NAME] |  |  |  | F4 | T4 | 1 11 | P29
2019-03-10 00:00:00 |  |  | 61 |  | F | OA Knee | R | [NAME] |  |  |  | F4 | T4 | I9 | P29 | PRESSFIT
2019-03-10 00:00:00 |  |  | 59 |  | M | OA Knee | R | [NAME] |  |  |  | F7 | T7 | I9 | P38 | PRESSFIT
2019-04-10 00:00:00 |  |  | 65 |  | F | OA Knee | L | [NAME] |  |  |  | F3 | T3 | I9 | P29
2019-04-10 00:00:00 |  |  | 62 |  | M | OA Knee | L | [NAME] |  |  |  | F7 | T7 | I9 | P35 | PRESSFIT
2019-04-10 00:00:00 |  |  | 62 |  | M | OA Knee | R | [NAME] |  |  |  | F7 | T7 | I9 | P35 | PRESSFIT
2019-10-10 00:00:00 |  |  | 71 |  | F | OA Knee | R | [NAME] |  |  |  | F3 | T4 | I9 | P29
2019-11-10 00:00:00 |  |  | 83 |  | F | OA Knee | L | [NAME] |  |  |  | F3 | T4 | I 11 | P29
2019-11-10 00:00:00 |  |  | 63 |  | M | OA Knee | L | [NAME] |  |  |  | F4 | T5 | I9 | P35
2019-11-10 00:00:00 |  |  | 74 |  | F | OA Knee | R | [NAME] |  |  |  | F4 | T3 | I9 | P29
18/10/2019 |  |  | 62 |  | M | OA Knee | L | [NAME] |  |  |  | F6 | T7 | I9 | P35 | ROBOTIC
Spreadsheet: 166249d1341507900-getting-a-cell-to-populate-when-it-sees-a-name-airframe-engine-log-sample-modified-by-tigeravatar-1-
Sheet: Engine Log

G-BSGL |  |  |  |  |  |  |  | ENGINE LOG
 |  | Time run since new |  | Time run since top |  | Cycle run since new
TOTAL B/F | 49 days, 5:35:00 | or complete overhaul |  | overhaul |  | or complete overhaul | Particulars of Maintenance or othewr work carried out.
Date |  | Hours | Minutes | Hours | Minutes
 | Running
 | Total
 | Running
 | Total
 | Running
 | Total
 | Running
 | Total
 | Running
 | Total
Spreadsheet: 862840d1710424278-is-there-a-formula-to-get-rid-of-the-dec-the-end-of-the-date-of-this-data-im-importin-sample-workbook-etaf
Sheet: Sheet1

Release Date | Time | Actual | Forecast | Previous
[NAME]) | 08:30:00 | 0.006 | 0.008 | -0.011
Feb 15, 2024 (Jan) | 09:30:00 | -0.008 | -0.002 | 0.004
Jan 17, 2024 (Dec) | 09:30:00 | 0.006 | 0.004 | 0.003
Dec 14, 2023 (Nov) | 09:30:00 | 0.003 | -0.001 | -0.002
Nov 15, 2023 (Oct) | 09:30:00 | -0.001 | -0.003 | 0.009
Oct 17, 2023 (Sep) | 08:30:00 | 0.007 | 0.003 | 0.008
Sep 14, 2023 (Aug) | 08:30:00 | 0.006 | 0.002 | 0.005
Spreadsheet: 288016d1389065248-how-to-identify-a-data-pattern-sales-per-q
Sheet: Summary

Sales Rep | Q1 | Q2 | Q3 | Q4 | Q5 | Q6 | Q7 |  | Average | Quota | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  | 250000
[NAME] |  |  |  |  |  |  |  |  |  | 250000
Jenifer Cogdill |  |  |  |  |  |  |  |  |  | 250000
[NAME] |  |  |  |  |  |  |  |  |  | 250000
Salley Jemison |  |  |  |  |  |  |  |  |  | 250000
Spreadsheet: 473523d1470249267-best-way-to-sort-my-data-into-a-graph-oeldere-473522d1470248671-best-way-to-sort-my-data-into-a-graph-call-stats
Sheet: Data

 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
 | Presented | Abandoned | Presented | Abandoned | Presented | Abandoned | Presented | Abandoned | Presented | Abandoned
8am -10am | 24 | 4 | 21 | 4 | 19 | 3 | 19 | 2 | 29 | 6
10am -12pm | 45 | 7 | 39 | 5 | 41 | 5 | 49 | 6 | 55 | 7
12pm -2 pm | 123 | 34 | 145 | 44 | 133 | 42 | 123 | 39 | 198 | 40
2-pm 4 pm | 54 | 20 | 45 | 12 | 44 | 15 | 56 | 15 | 77 | 20
4pm - 6 pm | 24 | 2 | 20 | 2 | 19 | 0 | 14 | 1 | 24 | 4
Spreadsheet: 836759d1689619867-by-what-percentage-did-the-gifts-clicks-ratio-improve-from-only-you-to-before-midnight-how-do-i-do-this
Sheet: Sheet2

Send date | Subject line | Sent count | Number of opens | Number of clicks | Number of gifts | Total Raised | Open rate (opens/sent) | Clicks/sent | Clicks/opens | Gifts/sent | [NAME]/opens | Gifts/clicks | Average gift (total raised/gifts)
2015-04-30 00:00:00 | Only You | 418328 | 62676 | 3486 | 103 | 3189
2015-04-26 00:00:00 | Before midnight | 417767 | 66396 | 2941 | 224 | 1478
4/23/2015 | Got a sec | 415714 | 64347 | 2289 | 71 | 1283
 | 1. By what percentage did the gifts/clicks ratio improve from “only you” to “before midnight”? Please show your math.
Spreadsheet: 768940d1645209148-extract-a-sting-of-alphanumeric-data-inside-parenthesis-and-delimited-by-commas-extract-a-sting-of-alphanumeric-data-inside-parenthesis-and-delimited-by-commas
Sheet: Sheet1

 | formulat to extract from  ( ) | formula to extract from comma delimiter
 | STEP 1 | STEP 2
(23, 1, 6, 2, 5, 7, 0, 4, 2, 1)
(23, 1)
(23, 1, 6, 2, 5, 7, 0, 4, 2, 1, 6, 4, 0, 8, 11)
 |  | [NAME] to extract from parenthesis and commas in one step ????
 |  | STEP 1
(23, 1, 6, 2, 5, 7, 0, 4, 2, 1)
(23, 1)
(23, 1, 6, 2, 5, 7, 0, 4, 2, 1, 6, 4, 0, 8, 11)
Spreadsheet: 721026d1614433742-lookup-and-if-combined-help
Sheet: Out

Timestamp | [NAME] | Unit | Signed Back In? | Sign In Time | Latest Time
2021-02-27 12:00:00 | [NAME] | 1791 |  |  | 2021-02-27 17:00:00
2021-02-27 11:41:00 | [NAME] | 1797 |  |  | 2021-02-27 16:41:00
2021-02-26 12:00:00 | [NAME] | 1791 |  |  | 2021-02-26 17:00:00
 | What I'd like to be able to do is read the sign in time from the "In" tab if the entry falls between the "Timestamp" & latest time, but taking into account the colleague & unit number ~(example of result below)
2021-02-26 12:00:00 | [NAME] | 1791 |  | 2021-02-26 17:00:00 | 2021-02-26 17:00:00
Spreadsheet: 1ec01c46-f624-4ef2-a05b-34126a590fe9
Sheet: Sheet1

Ext. | Name             1/30/12 | Cell Phone | [NAME]
282 | [NAME], HTML/CSS Programmer | [PHONE] | adewolfe@
218 | [NAME], Account Manager | [PHONE] | afarmanara@
 | [NAME], Sr. Account Executive, Cell | [PHONE] | ashley@
 | [NAME], Sr. Account Executive, Office | [PHONE] | ashley@
239 | [NAME], Project Manager | [PHONE] | bmauleon@
333 | [NAME], Sales Assistant | [PHONE] | cdonahue@
217 | [NAME], Network Administrator | [PHONE] | cguo@
248 | [NAME], Project Coordinator | [PHONE] | dluong@
256 | G.A. Sacramento, Assistant Production Manager | [PHONE] | gsacramento@
229 | [NAME], [NAME] | [PHONE] | glifshitz@
205 | [NAME], Project Manager | [PHONE] | jschatz@
249 | [NAME], Production Manager | [PHONE] | [NAME]
262 | [NAME], Programmer | [PHONE] | jvu@
242 | [NAME], Project Manager | [PHONE] | jyoon@
222 | [NAME], Programmer | [PHONE] | kcsantos@
207 | [NAME], Network Administrator | [PHONE] | kchen@
267 | [NAME], Lead Project Manager | [PHONE] | kristoffer@
 | [NAME], Sr. Account Executive, Cell | [PHONE] | lrogers@
281 | [NAME],  Account Manager [NAME] | [PHONE] | lbenton@
357 | Maureen Doherty, Office Assistant | [PHONE] | mdoherty@
 | Natalia Cudlip, [NAME] Name: | [NAME] | ncudlip@
217 | [NAME], Programmer | [PHONE] | nleung@
297 | [NAME], Project Manager | [PHONE] | rgillespie@
241 | [NAME], Office Manager | [PHONE] | rdevries@
 | Sathish Konda, Programmer | [PHONE] | skonda@
257 | [NAME], President | [PHONE] | steve@
222 | Tie Cui, Programmer | [PHONE] | tcui@
 | [NAME], Vice President, Cell | [PHONE] | tschmidt@
 | [NAME], Vice President, Office | [PHONE] | tschmidt@
 | [NAME], Project Manager | [PHONE] | tom@
356 | [NAME], Account Services Specialist | [PHONE] | tgreen@
 | [NAME], Sr. Account Executive, Cell | [PHONE] | tlease@
 | [NAME], Sr. Account Executive, Office | [PHONE] | tlease@
252 | Uriz Goldman, Project Manager | [PHONE] | ugoldman@
256 | [NAME], Programmer | [PHONE] | vhovsepyan@
249 | [NAME], Programmer | [PHONE] | vsakson@
 | Internal use to contact AM's |  | [NAME]
 | Clients who need to contact AM's |  | accountmanager@
Spreadsheet: 765555d1643384848-formula-for-missing-numbers-in-a-range-based-on-criteria-missing-number
Sheet: Sheet1

Report # | Version # | Item #
20-A-1 | 0 | 1
20-A-1 | 0 | 3
20-A-1 | 1 | 1
20-A-1 | 1 | 5
21-B-2 | 0 | 1
21-B-2 | 0 | 2
21-B-2 | 1 | 1
21-B-2 | 1 | 3
21-B-2 | 1 | 9
Spreadsheet: 51696d1251317925-template-formula-input
Sheet: Input

 | 2009-01-01 00:00:00 |  |  |  | 2009-02-01 00:00:00 |  |  |  | 2009-03-01 00:00:00 |  |  |  | 2009-04-01 00:00:00 |  |  |  | 2009-05-01 00:00:00 |  |  |  | 2009-06-01 00:00:00 |  |  |  | 2009-07-01 00:00:00 |  |  |  | 2009-08-01 00:00:00 |  |  |  | 2009-09-01 00:00:00 |  |  |  | 2009-10-01 00:00:00 |  |  |  | 2009-11-01 00:00:00 |  |  |  | 2009-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M | M | M | M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q | Q | Q | Q | Q | Q | Q | Q
 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y
Spreadsheet: louise_kitchen__22857__ena
Sheet: Sheet1

Name | Title | Group
[NAME] | VP | Texas Trading
[NAME] | VP | Texas Trading
[NAME] | Assoc | Texas Trading
[NAME] | Assoc | Texas Trading
[NAME] | Mngr | Texas Trading
[NAME] | [NAME] | Texas Trading
[NAME] |  | Texas Orig
[NAME] [NAME] |  | Texas Orig
[NAME] |  | Texas Orig
[NAME] | Assoc | Texas Orig
[NAME] |  | Texas Orig
[NAME] | Mngr | Texas Orig
[NAME] |  | Central Trading
[NAME] |  | Central Trading
[NAME] |  | Central Trading
[NAME] |  | Central Trading
[NAME] |  | Central Trading
[NAME] |  | Central Trading
[NAME] |  | Central Trading
Spreadsheet: 102609d1300559000-what-is-in-these-cells-whatisinthesecells
Sheet: Sheet1

 |  | Copy "A" & Paste Special Values to "D" > |  | ISBLANK | LEN | ISNUMBER | ISTEXT | ISNONTEXT | CLEAN | CODE | ISEMPTY UDF | ISNULL UDF |  |  | > 0 | CHAR(34)&CHAR(34)
 | 0 |  |  | 0 | 0 | 0 | 1 | 0 | 0 | #N/A | 0 | 0 | 1 | 0 | 1 | 0
 | 0 |  |  | 0 | 0 | 0 | 1 | 0 | 0 | #N/A | 0 | 0 | 1 | 0 | 1 | 0
 | 0 |  |  | 0 | 0 | 0 | 1 | 0 | 0 | #N/A | 0 | 0 | 1 | 0 | 1 | 0
1 | 0 |  | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 49 | 0 | 0 | 0 | 0 | 1 | 0
 | 0 |  |  | 0 | 0 | 0 | 1 | 0 | 0 | #N/A | 0 | 0 | 1 | 0 | 1 | 0
 | 0 |  |  | 0 | 0 | 0 | 1 | 0 | 0 | #N/A | 0 | 0 | 1 | 0 | 1 | 0
 | 0 |  |  | 0 | 0 | 0 | 1 | 0 | 0 | #N/A | 0 | 0 | 1 | 0 | 1 | 0
 | 0 |  |  | 0 | 0 | 0 | 1 | 0 | 0 | #N/A | 0 | 0 | 1 | 0 | 1 | 0
2 | 0 |  | 2 | 0 | 1 | 1 | 0 | 1 | 0 | 50 | 0 | 0 | 0 | 0 | 1 | 0
 | 0 |  |  | 0 | 0 | 0 | 1 | 0 | 0 | #N/A | 0 | 0 | 1 | 0 | 1 | 0
 | 0 |  |  | 0 | 0 | 0 | 1 | 0 | 0 | #N/A | 0 | 0 | 1 | 0 | 1 | 0
 | 0 |  |  | 0 | 0 | 0 | 1 | 0 | 0 | #N/A | 0 | 0 | 1 | 0 | 1 | 0
 | 0 |  |  | 0 | 0 | 0 | 1 | 0 | 0 | #N/A | 0 | 0 | 1 | 0 | 1 | 0
3 | 0 |  | 3 | 0 | 1 | 1 | 0 | 1 | 0 | 51 | 0 | 0 | 0 | 0 | 1 | 0
 | 0 |  |  | 0 | 0 | 0 | 1 | 0 | 0 | #N/A | 0 | 0 | 1 | 0 | 1 | 0
 | 0 |  |  | 0 | 0 | 0 | 1 | 0 | 0 | #N/A | 0 | 0 | 1 | 0 | 1 | 0
 | 0 |  |  | 0 | 0 | 0 | 1 | 0 | 0 | #N/A | 0 | 0 | 1 | 0 | 1 | 0
 | 0 |  |  | 0 | 0 | 0 | 1 | 0 | 0 | #N/A | 0 | 0 | 1 | 0 | 1 | 0
4 | 0 |  | 4 | 0 | 1 | 1 | 0 | 1 | 0 | 52 | 0 | 0 | 0 | 0 | 1 | 0
 | 0 |  |  | 0 | 0 | 0 | 1 | 0 | 0 | #N/A | 0 | 0 | 1 | 0 | 1 | 0
 | 0 |  |  | 0 | 0 | 0 | 1 | 0 | 0 | #N/A | 0 | 0 | 1 | 0 | 1 | 0
 |  |  |  | 1 | 0 | 0 | 0 | 1 | 0 | #N/A | 1 | 0 | 1 | 1 | 0 | 0
 |  |  |  | 1 | 0 | 0 | 0 | 1 | 0 | #N/A | 1 | 0 | 1 | 1 | 0 | 0
 |  |  |  | 1 | 0 | 0 | 0 | 1 | 0 | #N/A | 1 | 0 | 1 | 1 | 0 | 0
Spreadsheet: 818825d1677070772-help-searching-large-excel-workbook-and-returning-a-value-sample-workbook
Sheet: Sheet1

12/03/22 12:43:56 CST From:[NAME] To: [NAME], [NAME]
(system message) [NAME] started the conversation with [NAME] and [NAME] | Messages to [NAME]
12/03/22 12:43:56 CST From: [NAME] To: [NAME], [NAME]
please come see me after your shift
 | Messages From [NAME]
12/03/22 12:44:45 CST From: [NAME] To: [NAME], Goofy, [NAME]
this will be something we need to discuss
12/03/22 12:45:12 CST From: [NAME] To: [NAME], [NAME], Goofy
Thank you for your help guys
12/03/22 12:45:57 CST From: [NAME] To: [NAME]
Do you want me to see both?
12/03/22 12:48:31 CST From: [NAME] To: [NAME]
please go see [NAME]
12/03/22 12:48:46 CST From: [NAME] To: [NAME]
Okay
12/03/22 12:56:49 CST From: [NAME] To: [NAME], [NAME]
(system message) [NAME] started the conversation with Minnie Mouse and [NAME]
12/03/22 12:56:49 CST From: [NAME] To: Pluto, [NAME]
I need assistance in my room please
12/03/22 12:57:29 CST From: [NAME] To: Daffy, Goofy, [NAME]
(system message) [NAME] added  Daffy, Goofy, [NAME]
12/03/22 12:58:12 CST From: [NAME] To:  [NAME], Daffy, Goofy,
Message received!
12/03/22 13:00:24 CST From: [NAME] To: [NAME]
I've logged in
12/03/22 13:00:52 CST From: [NAME] To: [NAME]
Great
12/03/22 13:31:47 CST From: [NAME] To: [NAME], [NAME]
(system message) [NAME] started the conversation with [NAME] and [NAME]
12/03/22 13:31:47 CST From: [NAME] To: [NAME], [NAME]
I am on my way in
12/03/22 13:34:05 CST From: [NAME] To:  [NAME], [NAME],
Message received!
12/03/22 14:00:12 CST From: [NAME] To: [NAME]
(system message) [NAME] started the conversation with [NAME]
12/03/22 14:00:12 CST From: [NAME] To: [NAME]
I will go take a look at that last call
12/03/22 14:14:09 CST From: [NAME] To: [NAME]
(system message) [NAME] started the conversation with [NAME]
12/03/22 14:14:09 CST From: [NAME] To: [NAME]
can you call me?
Spreadsheet: 800489d1665683898-help-with-finding-percentages-and-pivots-da-excel-test
Sheet: Sheet13

Count of Course Title | Column Labels
 | N | N Total | Y |  | Y Total | Grand Total
Row Labels | N |  | N | Y
Bachelor of Arts (Honours) Advertising & Brand Communication | 8 | 8 | 1 | 21 | 22 | 30
Bachelor of Arts (Honours) Animation | 10 | 10 | 7 | 19 | 26 | 36
Bachelor of Arts (Honours) Architecture | 9 | 9 | 10 | 25 | 35 | 44
Bachelor of Arts (Honours) Arts and Media | 1 | 1 | 1 | 7 | 8 | 9
Bachelor of Arts (Honours) CG Arts and Animation | 9 | 9 | 1 | 7 | 8 | 17
Bachelor of Arts (Honours) Computer Games Arts |  |  | 3 | 6 | 9 | 9
Bachelor of Arts (Honours) Contemporary Jewellery | 1 | 1 | 2 | 8 | 10 | 11
Bachelor of Arts (Honours) Creative Arts for Theatre and Film | 1 | 1 | 2 | 20 | 22 | 23
Bachelor of Arts (Honours) Digital Film and Screen Arts | 4 | 4 | 3 | 6 | 9 | 13
Bachelor of Arts (Honours) Fashion | 21 | 21 | 16 | 44 | 60 | 81
Bachelor of Arts (Honours) Fashion Atelier | 8 | 8 | 6 | 12 | 18 | 26
Bachelor of Arts (Honours) Fashion Design | 16 | 16 | 8 | 27 | 35 | 51
Bachelor of Arts (Honours) Fashion Journalism | 17 | 17 | 9 | 36 | 45 | 62
Bachelor of Arts (Honours) Fashion Management and Marketing | 12 | 12 | 6 | 60 | 66 | 78
Bachelor of Arts (Honours) Fashion Promotion | 17 | 17 | 9 | 29 | 38 | 55
Bachelor of Arts (Honours) Fashion Promotion and Imaging | 25 | 25 | 7 | 74 | 81 | 106
Bachelor of Arts (Honours) Fashion Textiles: Print | 3 | 3 | 3 | 23 | 26 | 29
Bachelor of Arts (Honours) Film Production | 15 | 15 | 9 | 56 | 65 | 80
Bachelor of Arts (Honours) Fine Art | 18 | 18 | 10 | 60 | 70 | 88
Bachelor of Arts (Honours) Graphic Communication | 1 | 1 |  | 28 | 28 | 29
Bachelor of Arts (Honours) Graphic Design | 12 | 12 | 14 | 43 | 57 | 69
Bachelor of Arts (Honours) Graphic Design: New Media | 6 | 6 | 3 | 9 | 12 | 18
Bachelor of Arts (Honours) Graphic Design: Visual Communications |  |  | 4 |  | 4 | 4
Bachelor of Arts (Honours) Illustration | 11 | 11 | 4 | 24 | 28 | 39
Bachelor of Arts (Honours) Interior Architecture and Design | 13 | 13 | 3 | 36 | 39 | 52
Bachelor of Arts (Honours) Journalism | 5 | 5 | 3 | 14 | 17 | 22
Bachelor of Arts (Honours) Music Journalism | 7 | 7 | 3 | 18 | 21 | 28
Bachelor of Arts (Honours) Photography | 13 | 13 | 4 | 43 | 47 | 60
Bachelor of Arts (Honours) Photography (Contemporary Practice) | 7 | 7 |  | 23 | 23 | 30
Bachelor of Arts (Honours) Product Design | 1 | 1 | 2 | 7 | 9 | 10
Bachelor of Arts (Honours) Product Design and Interaction |  |  |  | 7 | 7 | 7
Bachelor of Arts (Honours) Silversmithing, Goldsmithing and Jewellery | 2 | 2 | 1 | 4 | 5 | 7
Bachelor of Arts (Honours) Sports Journalism | 2 | 2 | 1 | 12 | 13 | 15
Bachelor of Arts (Honours) Textiles for Fashion and Interiors | 3 | 3 | 2 | 25 | 27 | 30
Bachelor of Arts (Honours) Three Dimensional Design |  |  | 2 | 7 | 9 | 9
Grand Total | 278 | 278 | 159 | 840 | 999 | 1277
Spreadsheet: 679161d1590235563-help-need-on-date-function-date-function
Sheet: Sheet1

 |  |  | Target Month
 |  |  |  | As Is
 | Sr.No | Task Name | Frequency | To be Started by | To be completed by | Status |  |  |  | Holiday Calendar
 | 1 | Task 1 | Monthly | 1st business day of every month | 5th Business day of every month | Completed
 | 2 | Task 2 | Monthly | 8th busness day before the end of month | 8th busness day before the end of month | In Progress |  |  |  | 2020-04-17 00:00:00
 | 3 | Task 3 | Quarterly | 3 biz days before end of Mar/Jun/Sep/Dec | Last biz day of Mar/Jun/Sep/Dec | Not Required |  |  |  | 2020-04-27 00:00:00
 | 4 | Task 4 | Quarterly | 1st biz day of Jan/April/July/Oct | 15th biz day of Jan/April/July/Oct | Not Required |  |  |  | 2020-05-04 00:00:00
 | 5 | Task 5 | Half-Yearly | 1st biz day of Feb/Aug | Last biz day of Feb/Aug | Not Started |  |  |  | 2020-05-05 00:00:00
 | 6 | Task 6 | Half-Yearly | 10th biz day of May/Aug | End of June/Sept | Not Started |  |  |  | 2020-05-29 00:00:00
 | 7 | Task 7 | Yearly | 10th biz day of Oct | End of Nov | Not Started |  |  |  | 2020-06-15 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-07-28 00:00:00
 |  |  |  | To be |  |  |  |  |  | 2020-08-15 00:00:00
 | Sr.No | Task Name | Frequency | Start Date | End Date | Status |  |  |  | 2020-08-17 00:00:00
 | 1 | Task 1 | Monthly |  |  | Completed
 | 2 | Task 2 | Monthly |  |  | In Progress
 | 3 | Task 3 | Quarterly |  |  | Not Required
 | 4 | Task 4 | Quarterly |  |  | Not Required |  |  |  | Calendar
 | 5 | Task 5 | Half-Yearly |  |  | Not Started |  |  |  | QSet1 | QSet2
 | 6 | Task 6 | Half-Yearly |  |  | Not Started |  |  |  | 1 | 3
 | 7 | Task 7 | Yearly |  |  | Not Started |  |  |  | 4 | 6
 | Example 1 |  |  |  |  |  |  |  |  | 7 | 9
 |  |  |  |  |  |  |  |  |  | 10 | 12
 | 6 | Task 6 | Half-Yearly | 2020-05-18 00:00:00 | 2020-06-30 00:00:00 | In progress |  |  |  | HSet1
 |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  | 8
Spreadsheet: 690861d1597327367-multiple-if-and-forecasting-help-help-test-revenue
Sheet: Sheet2

Title | Forecast Total Value | Net Certainty (Rounded) | Project Duration (Months) | Project Start Date | Ongoing Data Mgmt? | Revenue started to be recognised | Project End Date | Monthly Value | ODM Opps Installation Months | ODM Opps ODM Months | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
Certainty >50%
Project 1 | 667400 | 80 | 12 | 2020-11-01 00:00:00 | Y
Project 2 | 294001 | 80 | 19 | 2020-12-01 00:00:00
Project 3 | 180000 | 90 | 6 | 2021-01-01 00:00:00
Project 4 | 160000 | 90 | 4 | 2020-10-31 00:00:00
Project 5 | 79250 | 60 | 12 | 2019-10-01 00:00:00 |  |  |  |  | 1 | 2
Project 6 | 55200 | 60 | 0 | 2020-07-27 00:00:00
Project 7 | 50000 | 50 | 3 | 2020-10-01 00:00:00 | Y
Project 8 | 40000 | 80 | 1 | 2020-08-15 00:00:00
Project 9 | 40000 | 90 | 3 | 2020-11-01 00:00:00 | Y
Project 10 | 20000 | 80 | 1 | 2020-07-20 00:00:00
Project 11 | 16917 | 50 | 54 | 2020-08-01 00:00:00
Project 12 | 15850 | 100 | 7 | 2020-09-01 00:00:00 | Y
Project 13 | 8840 | 60 | 3 | 2020-09-01 00:00:00
Project 14 | 8840 | 60 | 1 | 2020-09-01 00:00:00 | Y
Project 15 | 8552 | 100 | 0 | 2020-01-01 00:00:00
Project 16 | 7080 | 60 | 1 | 2020-08-17 00:00:00
Project 17 | 6900 | 60 | 4 | 2020-08-01 00:00:00
Project 18 | 6020 | 50 | 1 | 2020-11-02 00:00:00
Project 19 | 2000 | 80 | 3 | 2021-01-01 00:00:00
Project 20 | 1000 | 100 | 12 | 2020-06-09 00:00:00
Spreadsheet: 754878d1636552294-searching-a-value-different-tabs-using-some-conditionals-1636493371-busca-com-indireto-eba
Sheet: CALCULO GERAL

 |  | VALOR PROCURADO
 |  | CONDICIONAIS
 |  | LOCAL | VEÍCULO
 | SAÍDA | GO | CAMINHÃO TRUCK  (10m)
 | CHEGADA | SÃO PAULO - SP
 |  | DATA |  | O USUÁRIO VAI SELECIONAR 03 OPÇÕES (TIPO DE VEÍCULO / FILIAL DE ORIGEM / DESTINO) E INFORMAR AS DATAS
 | CARGA | 2021-12-05 00:00:00
 | DESCARGA | 2021-12-07 00:00:00 |  | A CONDICIONAL DA DATA SÓ VAI DEFINIR A QUANTIDADE DE VIAGENS SERÃO REALIZADAS
 |  |  |  | SE FOR NO MESMO DIA VAI CONSIDERAR 2 PERNAS E SE NÃO FOR VAI CONSIDERAR 4 PERNAS (NOMENCLATURA PARA CADA VIAGEM DO CAMINHÃO)
 | CUSTO |  | O VALOR SERÁ BUSCADO [NAME] O LOCAL DE SAÍDA FOR SP, O VALOR SERÁ PUXADO DA ABA SP LEVANDO EM CONTA A INFORMAÇÃO DE DATA, SE FOREM DIFERENTES PUXA UM VALOR, SE IGUAIS PUXAM OUTRO
 | VENDA |  | [NAME] O VALOR COM A MARGEM DE LUCRO JÁ EMBUTIDA