tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 716135d1612052549-function-to-add-a-date-every-time-a-cell-is-updated-with-a-project-status-example
Sheet: Sheet1

Scenario 1: Input in B4 |  |  |  |  |  |  |  |  |  | Result in M4, i.e. the date when input in B4 was made
Project | Status | Stage 1 | Stage 2 | Stage 3 | Stage 4 | Stage 5 | - - - - - - - - - - - - - - > |  |  | Project | Status | Stage 1 | Stage 2 | Stage 3 | Stage 4 | Stage 5
X |  |  |  |  |  |  |  |  |  | X | Stage 1
Scenario 2: "Stage 1" would have been in B11 originally, now changed to "Stage 2" |  |  |  |  |  |  |  |  |  | Result in N11, i.e. the date when input in B11 was made (assuming it was made on 30 Jan)
Project | Status | Stage 1 | Stage 2 | Stage 3 | Stage 4 | Stage 5 | - - - - - - - - - - - - - - > |  |  | Project | Status | Stage 1 | Stage 2 | Stage 3 | Stage 4 | Stage 5
X |  |  |  |  |  |  |  |  |  | X | Stage 1 | 2021-01-29 00:00:00
Scenario 3: "Stage 2" would have been in B18 originally, now changed to "Stage 5" (i.e. bypassing stages 3 and 4) |  |  |  |  |  |  |  |  |  | Result in O18:Q18, i.e. the dates when input in B18 was made (assuming it was made on 31 Jan), which is in the cell that matches the entry in B18, and all preceding cells that have not previously been filled, i.e. Stage 3 and 4
Project | Status | Stage 1 | Stage 2 | Stage 3 | Stage 4 | Stage 5 | - - - - - - - - - - - - - - > |  |  | Project | Status | Stage 1 | Stage 2 | Stage 3 | Stage 4 | Stage 5
X |  |  |  |  |  |  |  |  |  | X |  |  | 2021-01-31 00:00:00 |  | 2021-01-31 00:00:00 | 2021-01-31 00:00:00
Spreadsheet: 0d321075-a14f-49e5-b333-89f67c446862
Sheet: Sheet1

Name | Location | Interests | [NAME] | Application Submitted | EX [NAME] | [NAME]'s Vote | [NAME]'s Note
[NAME] | Portland, ME | NCAA | [EMAIL] | Yes | Non Voting | Non Voting | Non Voting
[NAME] | New York, NY |  | [EMAIL] | JM discussion | withdrew name.  Consider her in future
[NAME] | New York, NY | Fundraising, Women | [EMAIL] | Yes | Voting | Voting | Voting
[NAME] | New York, NY | Beginners, Women | [EMAIL] | Yes | Voting | Voting | Voting
[NAME] | New York, NY | Open | [EMAIL] | Yes | Non Voting | Non Voting | Non Voting
[NAME] | Norwalk, CT | NCCA | [EMAIL] | Yes | Voting | Voting | Voting
[NAME] |  |  | [EMAIL] | emailed 1/22 | Non Voting | Non Voting | Non Voting
Kat | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
Justin | Yes
[NAME] | Yes
[NAME] | Yes
Spreadsheet: 836662d1689576614-using-index-formula-to-summarise-training-database-index
Sheet: IR

CÔNG TY TNHH GE-SHEN VIỆT NAM |  |  |  |  |  |  |  |  |  | Form  :  HR-F02
GE-SHEN (VIETNAM) CO., LTD. |  |  |  |  |  |  |  |  |  | Rev    :  C
GHI CHÉP ĐÀO TẠO CÁ NHÂN/ NHÓM
GROUP / INDIVIDUAL TRAINING RECORD
Emp. No.: | 105320 |  |  |  |  |  | Name:
Dept: |  |  |  |  |  |  | Position:
Date Joined: |  |  |  |  |  |  | Year:
TT No. | Int/ Ext | Date |  |  | Time |  |  | Khóa đào tạo Training Course | Trained by | Ghi chú Remarks
1 |  |  |  |  |  |  |  |  |  |  |  | B7 | manually key in
2 |  |  |  |  |  |  |  |  |  |  |  | B8 | [NAME] in Employee name sheet, Column C
3 |  |  |  |  |  |  |  |  |  |  |  | B9 | [NAME] in Employee name sheet, Column E
4 |  |  |  |  |  |  |  |  |  |  |  | H7 | [NAME] in Employee name sheet, Column B
5 |  |  |  |  |  |  |  |  |  |  |  | H8 | [NAME] in Employee name sheet, Column D
6 |  |  |  |  |  |  |  |  |  |  |  | H9 | is it possible to tabulate data below base on year, i.e. if I keyed in 2022, the data will be show for year 2022 only, then if I change the year for 2023, it will tabulate the data for 2023
7 |  |  |  |  |  |  |  |  |  |  |  | B13 | list of training attended by by [NAME], lookup value in Database, Column D
8 |  |  |  |  |  |  |  |  |  |  |  | C13 | start date for 1st list training attended by by [NAME], lookup value in Database, Column E
9 |  |  |  |  |  |  |  |  |  |  |  | B14 to G42 | Other list of training attended by B7
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
Spreadsheet: 737947d1624696201-finding-top-3-largest-values-from-list-and-returning-value-to-left-da-excel-formula-help-aligw
Sheet: Sheet1

 |  | RESULT 1 | 19 |  |  |  |  | RESULT 1 | 19
 |  | RESULT 2 | 12 |  |  |  |  | RESULT 2 | 8
 |  | RESULT 3 | 16 |  | If top 3 results have 2 identical matches |  |  | RESULT 3 | 16 |  | If 3rd highest result has more than 1 match
 |  | RESULT 4 | 8 |  |  |  |  | RESULT 4 | 8
 |  | RESULT 5 | 16 |  | Desired Result |  |  | RESULT 5 | 8 |  | Desired Result
 | 1 | TOP 1 |  |  | RESULT 1 |  | 1 | TOP 1 |  |  | RESULT 1
 | 2 | TOP 2 | RESULT 5 |  | RESULT 3 |  | 2 | TOP 2 | RESULT 3 |  | RESULT 3
 | 3 | TOP 3 | RESULT 4 |  | RESULT 5 |  | 3 | TOP 3 | RESULT 2 |  | RESULT 2
 |  |  |  |  |  |  |  |  | RESULT 4 |  | RESULT 4
 |  |  |  |  |  |  |  |  | RESULT 5 |  | RESULT 5
Spreadsheet: 879327d1726818789-average-formula-in-conflict-with-vlookup-example
Sheet: 2

Production Line | Sep, 23 | Oct, 23 | Nov, 23 | Dec, 23
Cotton
Different date | 13 | 14 | 14 | 9
Different date | 15 | 14 | 13 | 15
Orange
Different date | 8 | 9 | 2 | 5
Different date | 9 | 12 | 4 | 10
Apple
Different date | 4 | 13 | 4 | 1
Different date | 12 | 3 | 11 | 14
Books
Different date | 8 | 12 | 14 | 3
Different date | 15 | 1 | 6 | 11
Machines
Different date | 2 | 8 | 8 | 5
Different date | 3 | 3 | 15 | 14
Spare parts
Different date | 12 | 11 | 9 | 12
Different date | 11 | 15 | 14 | 7
Total
Spreadsheet: 105533d1302854473-updating-the-changing-price-of-product-by-date-murphree-5-5h8-volume-accounting-sheet-in-edit-2
Sheet: Instructions

Keeping a blank copy of this spreadsheet will make it easier than deleting old information when starting a new well.
01) |  |  |  | All cells in Bright Yellow need to be updated every time a new well is started and should retain the same values for the duration of the well, with the exception of the "Finish Date" under the "Final Volumes" Tab which should be filled
 |  |  |  | out at the end of the well.
02) |  |  |  | All cells in beige require a manual daily input of data.
03) |  |  |  | For quick entry of repetitive data (such as "Daily Storage / Frac Tank Volumes") select the whole row (In beige) of the previous day's entry, "right-click" and "drag down" to the next row and select "Copy Here as Values Only".
 |  |  |  | Using the "Copy Here as Values Only" selection will prevent the changing of cell formatting such as "border lines" bold settings. If you accidently change it, use the undo option and try again.
04) |  |  |  | Enter the "Current Well Name" here
05) |  |  |  | The "Total Starting Well Volume" must equal the "Ending Well Volume" from the previous well. Any differences should be adjusted on the first day, including shortages transferring between locations from [NAME].
06) |  |  |  | If there are transfers of mud to or from the warehouse or other rigs during a rig move, account for these volumes on the FIRST DAY of the mud report and FIRST DAY of the volume accounting sheet.
07) |  |  |  | If the transfer has taken place during a rig move, note the ACTUAL DATE of the transaction in the "Comments" section of the "Mud Transfer Sheet" Tab, NOT under the "Date Column"
08) |  |  |  | Also, if the mud came from another rig, be sure to note the Rig Name & number, Well Name, AFE# and Reason, along with the [NAME] (recorded in the comments section) if transferred between jobs
09) |  |  |  | If the spudder rig filled the hole with [NAME] prior to rigging down, enter the volume added to the hole, on the first day's report under "Starting Hole Volume", DO NOT include this addtion in the "Total Starting well volume".
10) |  |  |  | Any "Losses" listed under the "Other" column should be explained in the "Comments" section.
11)
Spreadsheet: 120867d1315593385-summarizing-data-from-multiple-sheets-into-one-sheet-championship-score-sheet
Sheet: Results

 | Wed 7/09 | Fri 9/09 | Sat 10/09 | Wed 14/09 | Fri 16/09 | Sat 17/09 | Wed 21/09 | Fri 23/9 | Sat 24/09 | Wed 28/09
GROUP MEMBERS | SCORE | SCORE | SCORE | SCORE | SCORE | SCORE | SCORE | SCORE | SCORE | SCORE
Jen Rayoso
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Amanda Connelly
Amanda Turnbull
Anne-Rita le Riche
[NAME]
[NAME]
[NAME]
[NAME]
Chrissy Smith
Doreen Laws Heart
[NAME]
J T Patryck Voie
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Sandy Luchterhand
[NAME]
Stegzy Seckhold
[NAME]
[NAME]
[NAME]
Spreadsheet: 744475d1629268627-how-to-assign-continuous-numbers-to-column-vlaues-new-microsoft-excel-worksheet
Sheet: Sheet1

ID | To repeat | wish to have
1 | 2 | 1.1
2 | 3 | 1.2
1 | 3 | 2.1
2 | 2 | 2.2
 |  | 2.3
 |  | 1.3
 |  | 1.4
 |  | 1.5
 |  | 2.3
 |  | 2.4
Spreadsheet: 160980d1339350088-excel-2008-find-lower-price-from-multiple-sheets-book1-shokarta-oeldere-
Sheet: Sheet3

shop: | [NAME] | sheet 3
id | price
1 | 12 | sheet 3
2 | 324 | sheet 3
5 | 2 | sheet 3
4 | 43 | sheet 3
7 | 1 | sheet 3
Spreadsheet: 164208d1340689969-vlookup-and-count-unique-records-in-adjacent-column-0abook1-33-
Sheet: Sheet1

Name | Date | Mins |  |  |  |  |  |  |  | helper column
[NAME] | 2012-06-10 00:00:00 | 22
[NAME] | 2012-06-10 00:00:00 | 24
[NAME] | 2012-06-10 00:00:00 | 20
[NAME] | 2012-06-11 00:00:00 | 25
[NAME] | 2012-06-12 00:00:00 | 14
[NAME] | 2012-06-13 00:00:00 | 19
[NAME] | 2012-06-13 00:00:00 | 20
[NAME] | 2012-06-09 00:00:00 | 30
[NAME] | 2012-06-09 00:00:00 | 26
[NAME] | 2012-06-10 00:00:00 | 15
[NAME] | 2012-06-11 00:00:00 | 20
[NAME] | 2012-06-12 00:00:00 | 14
[NAME] | 2012-06-13 00:00:00 | 20
[NAME] | 2012-06-14 00:00:00 | 12
[NAME] | 2012-06-10 00:00:00 | 13
[NAME] | 2012-06-10 00:00:00 | 14
[NAME] | 2012-06-10 00:00:00 | 30
[NAME] | 2012-06-10 00:00:00 | 20
[NAME] | 2012-06-10 00:00:00 | 23
Name | Days Worked
[NAME] | 4 | Need these to be a formula
[NAME] | 6 | Need these to be a formula
[NAME] | 1 | Need these to be a formula
Spreadsheet: 849479d1699950632-colour-matching-first-cell-and-last-cell-in-a-row-inventory
Sheet: Tools

 |  | Job |  |  | Assembled |  |  | S
 |  | Location |  |  | On Site |  |  | O
 |  |  |  |  | In Use |  |  | A
TOOL INVENTORY |  |  |  |  | BACKLOADED |  |  | B
 |  |  |  |  | USED |  |  | U
2023-11-01 00:00:00 |  |  |  |  | STORED ON BOAT |  |  | W
 |  |  |  |  | STORED ONSHORE |  |  | X
 |  |  |  |  | READY FOR BACKLOAD |  |  | R
[NAME] | SERIAL NUMBER | ARRIVAL ON RIG | Basket S/N | BACKLOAD DATE |  |  |  |  |  | COMMENTS | 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
Motor | 1234 |  | 394412 |  |  |  |  |  |  |  |  | X | X | W | O | S | A | U | R | B
Motor | 5678 |  | 394402 |  |  |  |  |  |  |  |  | X | X | W | W | O | O | R | R | B
Spreadsheet: 863701d1711102476-info-from-one-sheet-to-another-it-services-stock-control-aligw
Sheet: Total Stock Demo 2

IT Services - Stock Control |  |  |  |  |  | [NAME].
Inventory ID | Product Name | Product Description | Quantity In Stock | Qty. When [NAME] is Required | Qty. Until Order Required | Previous [NAME]. | Administrator Notes
ITS001 | P2222 [NAME] | 22' Dell Monitors | 11 | 10
ITS002 | [NAME] | 27' Dell Monitors | 6 | 5
ITS003 | Logitech Webcams | Webcams | 10 | 10
ITS004 | Dell Keyboards | Wired Keyboards | 28 | 15
ITS005 | HP Mice | Wired Mice | 19 | 10
ITS006 | [NAME] | Wired Headphones | 20 | 10
Spreadsheet: 292131d1390498150-if-a-b-then-display-c-in-d-roster
Sheet: Sheet1

31MEU Roster | 2nd Battalion | 4th Marines |  |  |  |  |  |  |  |  |  | Legend
Squad roatation |  |  |  |  |  |  |  |  |  |  |  | CSO | Critical skills operator -
 |  |  |  |  |  |  |  |  |  |  |  |  | Granadier/AR/Marksman
 | Delta Company |  |  |  |  |  |  |  |  |  |  | Specialist | Breacher
Assignment No | Roster | Order | Penalty | Boon | 2-4 Devildogs |  | Assignment | Order
 | Pvt T.Sorensen |  |  |  | Squad leader |  | 1 | 1
 | Pvt P.Klaas |  |  |  | Corpsman |  | 6
 | Pvt N.Monahan |  |  |  | CSO/2nd Corpsman |  | 7
 | Pvt M.Kolster |  |  |  | CSO/Infantryman |  | 2
 | [NAME] |  |  |  | CSO |  | 4
 | HR P.Madden |  |  |  | Infantryman |  | 3
7 |  |  |  |  | Specialist |  | 5
8 |  |  |  |  | Infantryman/AT/AA |  | 8
 | Reserves
 | SSgt M.Ward
 | Pvt P.Lindsey
 | Pvt D.Pham
 | Pvt J.Karlsen
 | 2014-01-27 00:00:00
 | 2-4 Devildogs | Assignment | 2-4 Devildogs | Assignment | 2-4 Devildogs | Assignment
 | Squad leader | 1 | Squad leader | 1 | Squad leader | 1
 | Corpsman | 2 | Corpsman | 2 | Corpsman | 2
 | CSO/2nd Corpsman | 3 | CSO/2nd Corpsman | 3 | CSO/2nd Corpsman | 3
 | CSO/Infantryman | 4 | CSO/Infantryman | 4 | CSO/Infantryman | 4
 | CSO | 5 | CSO | 5 | CSO | 5
 | Infantryman | 6 | Infantryman | 6 | Infantryman | 6
 | Specialist | 7 | Specialist | 7 | Specialist | 7
 | Infantryman/AT/AA | 8 | Infantryman/AT/AA | 8 | Infantryman/AT/AA | 8
Spreadsheet: 875717d1722333837-how-to-make-this-if-formale-work-mobilisation-forecast
Sheet: Дата

Төслийн талбай
Нэр | Албан тушаал | Хэлтэс | Шууд удирдлага
 |  |  |  |  | Төслийн талбай
 |  |  |  |  | Улаанбаатар
 |  | TOTAL | 15
Улаанбаатар оффис
Нэр | Албан тушаал | Хэлтэс | Шууд удирдлага
 |  | TOTAL | 5
Spreadsheet: 756198d1637333641-how-to-average-the-first-5-non-zero-numbers-in-a-list-scoring-example1
Sheet: Handicap (2)

Name | Average Score | New Scores to be inserted before "C"
Player 1 |  | 0 | 84 | 0 | 86 | 87 | 0 | 84 | 85 | 86 | 87 | 0 | 99
Player 2 |  | 98 | 99 | 89 | 87 | 0 | 98 | 99 | 89 | 87 | 0
Player 3 |  | 84 | 0 | 90 | 0 | 0 | 84 | 0 | 90 | 0 | 0
Player 4 |  | 75 | 78 | 0 | 89 | 0 | 75 | 78 | 0 | 89 | 0
Player 5 |  | 89 | 98 | 85 | 91 | 0 | 89 | 98 | 85 | 91 | 0
Player 6 |  | 0 | 0 | 85 | 87 | 88 | 0 | 0 | 85 | 87 | 88
Player 7 |  | 84 | 0 | 90 | 0 | 0 | 84 | 0 | 90 | 0 | 0
Player 8 |  | 75 | 78 | 0 | 89 | 0 | 75 | 78 | 0 | 89 | 0
Player 9 |  | 89 | 98 | 85 | 91 | 0 | 89 | 98 | 85 | 91 | 0
Player 10 |  | 0 | 0 | 85 | 87 | 88 | 0 | 0 | 85 | 87 | 88
Spreadsheet: 845641d1697059811-formula-to-highlight-exceptions-of-multiple-criteria-w-multi-choices-for-multiple-states-multicriteriaformulahelp
Sheet: Sheet1

Reporting Status
Location | Training | Governance |  | Get State | Compliance
123 Main St Virginia Beach, VA 23462 | No | No |  |  |  |  |  | LET(x,(XLOOKUP($E3,$G$13:$G$19,$H$13:$H$19,,0)),IF(x="AffirmOnly",IF(B3<>"Yes","Out of Compliance","PASS"),IF(x="NegOnly",IF(B3="No","Out of Compliance","PASS"),"ChkNeg")))
123 Main St Anaheim, CA 92806 | Yes | Yes
123 Main St Tampa, FL 33619 | Yes | Yes
123 Main St New York, NY 10011 | Yes | Yes
123 Main St Atlanta, GA 30339 | Yes | Yes
123 Main St Chicago, IL 60611 | Yes | Yes
123 Main St Portland, OR 97035 | Yes | Yes
Criteria
Training | Acceptable Response | Yes | No | No response |  | List of States w/ Criteria
All locations must respond yes | NY, IL, GA, VA | X |  |  |  | VA | AffirmOnly
Fails <> Yes | NY, IL, GA, VA |  | X |  |  | NY | AffirmOnly
 | NY, IL, GA, VA |  |  | X |  | GA | AffirmOnly
 |  |  |  |  |  | IL | AffirmOnly
Some locations are ok to not respond | All States Excluding: NY, IL, GA, VA | X |  |  |  | CA | NegOnly
Fails = No | NY, IL, GA, VA |  | X |  |  | FL | NegOnly
 | NY, IL, GA, VA |  |  | X |  | OR | NegOnly
Governance | Acceptable Response | Yes | No | No response
All locations must respond yes | NY, IL, GA, VA | X
Fails <> Yes | NY, IL, GA, VA |  | X
 | NY, IL, GA, VA |  |  | X
Some locations are ok to not respond | All States Excluding: NY, IL, GA, VA | X
Fails = No | NY, IL, GA, VA |  | X
 | NY, IL, GA, VA |  |  | X
Result
LET(x,(XLOOKUP(E3,$G$13:$G$19,$I$13:$I$19,,0)),IF(x="AffirmOnly",IF(B3<>"Yes","FAIL","OK"),IF(x="NegOnly",IF(B3="No","FAIL","OK"),"ChkNeg")))
Spreadsheet: c563ecee-f155-4803-a3d4-da215a9f272b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | FORM 20B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Accounting for Advance
 |  |  |  |  |  |  |  |  |  |  |  |  | Ref:
Name:
Address:
Post Code:
School/Department:
Date of advance:
Cost Centre |  |  |  |  | Activity Code |  |  |  |  | Analysis Code |  |  | £ |  |  |  | p
Total Expenditure:
Less Amount of Advance: |  |  |  |  |  |  |  | DRX31
Balance to be paid/refunded
Notes:
1 | Expenditure should be allocated to the relevant codes.
2 | Total the expenditure and deduct the advance from the total.  If a refund to the College is
 | required then this can be made by cheque or by cash.
3 | Complete a "Claim for Expenses" form and attach to this form together with all receipts.
4 | Failure to provide proper receipts promptly may result in the full amount of the advance
 | being deducted from salary.
5 | Please send the completed forms to the Finance Office within 7 days of the end of the
 | official visit/field course.
Signed: |  |  |  |  |  |  |  |  | Authorised by:
Print Name: |  |  |  |  |  |  |  |  | Print Name:
Date: |  |  |  |  |  |  |  |  | Date:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Finance Ref: accountforadv
Spreadsheet: 70013d1270664578-360-degree-problem-deviation-help
Sheet: Sheet1

 |  | COPILOT COMPASS
[NAME] | ACTUAL | STAND BY |  |  | GYRO
COURSE | COURSE | COURSE | D | RD | COURSE | D | RD
360 | 2 | 358 | -356 |  |  | 2
90 |  |  | 0 |  |  | 0
180   c |  |  | 0 |  |  | 0
270   b |  |  | 0 |  |  | 0
Spreadsheet: 09bb5aaf-823e-46ff-82ce-f6475052bf36
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | February | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | CSA March 2014 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33 | Unnamed: 34 | Unnamed: 35 | Unnamed: 36 | Unnamed: 37 | April | Unnamed: 39 | Unnamed: 40 | Unnamed: 41 | Unnamed: 42 | Unnamed: 43 | Unnamed: 44 | Unnamed: 45
23 | 24 | 25 | 26 | 27 | 28 | 29 | 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 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
SueandBill 2/19 - 3/2
 |  |  | brennie 2/26 - 3-10
 |  |  |  |  |  |  |  | RobinH 3/2 - 12
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | hotsotchginger 3/5 - 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | jmac 3/12 - 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | monobrow1 3/12 - 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KC 3/13 - 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | andypapa 3/15 -18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | waynef 3/16 - 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fido 3/16 - 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | gibbyvaca 3-17 - 27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3/28 - 4/4
 |  |  |  |  |  |  |  |  |  |  | Celebrating a birthday
 |  |  |  |  |  |  |  |  |  |  | Celebrating an anniversary/honeymoon
 |  |  |  |  |  |  |  |  |  |  | Wedding in Paradise
Spreadsheet: 145148d1331316778-combine-formulas-book-2
Sheet: Sch

 |  |  |  |  | [NAME]
 | VLOOKUP |  |  |  | VLOOKUP(C2,Sch!B$6:D$8,3)
 | Code |  | Taxability
 | PLA |  | NT
 | PNC |  | T
 | UNC |  | T
 | EMD/TMD |  |  |  | IF(OR(C9="EMD",C9="TMD"),IF(SUMPRODUCT(COUNTIF(E9,"*"&Sch!B$13:$B$20&"*"))>0,"NT",""))
OK | ADVISORY | NT
OK | DSE | NT
OK | EMPLOYMENT | NT
OK | OCCUPATIONAL | NT
OK | TRAIN | NT
OK | VACCIN | NT
OK | VISA | NT
OK | VISIT | NT
 | TFG |  |  |  | IF(C14="TFG",IF(B14>50,IF(D14=" ",IF(SUMPRODUCT(COUNTIF(E14,"*"&Sch!B$25:B$26&"*"))>0,"NT","T"),"T"),"NT"))
OK | 25 YEAR | NT
OK | LONG SERVICE | NT
 | SEM |  |  |  | IF(C29="SEM",IF(SUMPRODUCT(COUNTIF(E29,"*"&Sch!$B$31:$B$33&"*"))>0,"T",IF(SUMPRODUCT(COUNTIF(E29,"*"&Sch!B$35:B$41&"*"))>0,"NT","")))
OK | BONUS | T
OK | LATE | T
OK | entertain | T
OK | CONFERENCE | NT
OK | COURSE | NT
OK | EXAM | NT
OK | RECRUITMENT | NT
OK | STUDY | NT
OK | SUMMIT | NT
OK | TRAINING | NT
 | OSM & RSM |  |  |  | IF(OR(C37="OSM",C37="RSM"),IF(SUMPRODUCT(COUNTIF(D37,"*"&Sch!B$45:B$50&"*"))>0,"NT",""))
OK | CONFERENCE | T
ok | CPA | T
OK | DRIVING | T
OK | DROP BOX | T
OK | STORAGE | T
OK | SURVEY | T
 | XTO |  |  |  | IF(C40="XTO",IF(SUMPRODUCT(COUNTIF(D40,"*"&Sch!B$55:B$60&"*"))>0,"T",IF(SUMPRODUCT(COUNTIF(D40,"*"&Sch!$B$63:$B$66&"*"))>0,"NT","")))
 | FOOTBALL | T
OK | GYM | T
OK | CAKE | T
 | KENNEL | T
OK | CHILDCARE | T
 | TOILETRIES | T
 | CONFERENCE | NT
OK | STATIONARY | NT
OK | PARKING | NT
 | OFFICE EUIPMENT | NT
 | LHP |  |  |  | IF(C47="LHP",IF(SUMPRODUCT(COUNTIF(E47,"*"&Sch!$B$71:$B$73&"*"))>0,"NT",""))
OK | BLACKBERRY | NT
OK | BUSINESS | NT
OK | BB | NT
 | RAU |  |  |  | IF(C51="RAU",IF(B51<600,"NT","T"))
 | less than 600 - NT
 | 600 and more - T
 | [NAME] |  |  |  | IF(C26="TOTTFG",IF(B26<=50,"NT",IF(B26>=250,"T","")))
 | 50 or less - NT
 | 250 and more - T
Spreadsheet: 805448d1668690358-a-woodworker-in-need-of-help-with-if-function-with-sum-as-a-condition-new-template-2022-v3
Sheet: Sheet Goods

 |  | Price per unit
 |  | 38
 |  | 24
Hinges | 4 | 6 |  |  |  |  |  |  | Dimensions
Push to open things | 2 | 8
Tooling | 1 | 30 |  |  |  |  |  | Quantity | Length | [NAME] | Thickness | m2
 |  | Total |  |  |  |  |  | 4 | 1.5 | 0.6 | 0.03
 |  |  |  |  |  |  |  | 7 | 0.8 | 0.6 | 0.02
Time |  | Price per minute |  |  |  |  |  | 0 | 1 | 1 | 0.04
Cutting | 1 | 40
Gluing | 0 | 40
Construction | 10 | 40
Routing | 4 | 40
Sanding | 3 | 40
Finish |  | 26
Installation | 0 | 40
Delivery | 0 | 50
Stacking | 0 | 0
 |  | Total |  |  |  |  | length | thickness | width | quantity | m2 | m3 | Price/m2 | Price | [NAME]
Shop Costs |  | 10 |  | MDF 30[NAME] |  |  | 2.5 | 0.019 | 1.25 | 3 |  |  | 48
 |  |  |  | MDF 19mm |  |  | 2.5 | 0.016 | 1.25 | 1 |  |  | 32
 |  | Construction Total |  | MDF 10mm |  |  | 0 | 0.01 | 1.25 | 1 |  |  | 14.2
 |  | Profit |  |  |  |  | 0 | 0.027 | 0.16 | 13 |  |  | 0
 |  | Total |  |  |  |  |  |  |  |  |  |  | Total meters
 |  | IVA
Spreadsheet: 187e4b12-9dea-4aeb-9175-5d4754c54e09
Sheet: Sheet1

First Name | Last Name | Middle Initial | Suffix (eg, Jr., III) | Credentials (MD, PHD, etc) | Credentials / Position | Sex (male/female) | E-mail Address | Department | Home Phone | Cell | Pager | Fax | Address | City | Province / State | Country | Postal Code | employee id | [NAME]