tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 875745d1722353263-using-formula-to-calculate-weighted-average-by-getting-numbers-from-multiple-sheets-weighted-average-eba-2
Sheet: Consolidated

 |  | Month |  | 2024-06-01 00:00:00 | 30 | days |  |  |  |  | Month |  | 2024-06-01 00:00:00 | 30 | 30 | 30 | 30
 |  |  |  |  |  |  |  | Division A PL |  |  |  |  |  | DIV A | DIV B | DIV C | Consolidated
 |  | Clients (Funded) |  |  |  |  |  | Division A BS |  |  | Clients (Funded) |  |  | 24 | 27 | 28
 |  | Weekly Avg Fees Achieved (Funded) |  |  |  | Weighted Average |  | Division B PL |  |  | Weekly Avg Fees Achieved (Funded) |  |  | 450 | 375 | 550
 |  | Clients non Funded |  |  |  |  |  | Division B BS |  |  | Clients non Funded |  |  | 17 | 15 | 22
 |  | Weekly Avg Fees Achieved (Private) |  |  |  | Weighted Average |  | Division C PL |  |  | Weekly Avg Fees Achieved (Private) |  |  | 900 | 850 | 750
 |  | Total Clients |  |  |  |  |  | Division C BS |  |  | Total Clients |  |  | 41
 |  | Fee Billed - Funded |  |  |  |  |  |  |  |  | Fee Billed - Funded
 |  | Fee Billed - non Funded |  |  |  |  |  |  |  |  | Fee Billed - non Funded
 |  |  |  |  |  |  |  |  |  |  | Check
 |  |  |  |  |  |  |  |  |  |  | Fee Billed - Funded
 |  |  |  |  |  |  |  |  |  |  | Fee Billed - non Funded
Spreadsheet: 719741d1613773040-pull-data-from-a-closed-workbook-nyb-update-02_19_21
Sheet: Sheet1

Client ID | Client | [NAME] | [NAME] | Invoice Number | Profit Center | Comments
13131651 | Example | January,2021 | Example | 646879 | GLC | BD15
132165161 | Example | January,2021 | Example | 20006467 | GLC | BD15
 | Example | February,2021 | Example | 213460006 | GLC | BD15
31661651 | Example | February,2021 | Example | 3132130006 | MRT | BD15
797945 | Example | March,2021 | Example | 13213240007 | MRT | BD15
987978 | Example | March,2021 | Example | 1646584007 | MRT | BD15
Spreadsheet: 135748d1326216575-auto-transfer-data-from-master-sheet-to-individual-worksheets-nbastatistics
Sheet: Den

Denver |  |  |  |  | Den
Away Games |  | 5 | Home Games |  | 5
Points Scored | Points Allowed |  | Points Scored | Points Allowed
115 |  |  | 117
102 |  |  | 99
89 |  |  | 91
96 |  |  | 110
117 |  |  | 81
Spreadsheet: 757300d1638182556-income-tax-calculation-formula-turkey-income-tax-rates-2021-1-
Sheet: tax

Taxable Income Over... | ...And Up To... | Tax Rate | Rate Differential
0 |  | 0.15
24001 |  | 0.2
53001 |  | 0.27
190001 |  | 0.35
650001 |  | 0.4
Example Taxable Income | Total  Tax | Tax Breakdown By Bracket |  |  |  |  | Total Tax | Net Income After Tax | Average Tax Rate |  | Sumproduct
15000
25000
55000
192000
655000
Spreadsheet: 101687d1299766410-excel-2007-extracting-and-adding-numbers-absence
Sheet: Sheet1

Date | Empolyee | Code | Number | DOW
 | Emp1
 | Emp2
 | Emp3
 | Emp4 |  |  |  |  |  |  | Sum of Number | Column Labels
 | Emp5 |  |  |  |  |  |  | Row Labels | 2011-02-27 00:00:00 | 2011-02-28 00:00:00 | 2011-03-01 00:00:00 | 2011-03-03 00:00:00 | 2011-03-04 00:00:00 | 2011-03-05 00:00:00 | Grand Total
 | Emp6 |  |  |  |  |  |  | Emp1
 | Emp7 |  |  |  |  |  |  | A | 4 |  |  |  |  | 1 | 5
 | [NAME] |  |  |  |  |  |  | L |  | 2 |  |  |  |  | 2
 | Emp9 |  |  |  |  |  |  | N |  |  | 5 |  |  |  | 5
 | Emp1 |  |  |  |  |  |  | Emp1 Total | 4 | 2 | 5 |  |  | 1 | 12
 | Emp2 |  |  |  |  |  |  | Emp2
 | Emp3 |  |  |  |  |  |  | L | 2 |  |  |  |  |  | 2
 | Emp4 |  |  |  |  |  |  | U |  |  |  | 3 |  |  | 3
 | Emp5 |  |  |  |  |  |  | Emp2 Total | 2 |  |  | 3 |  |  | 5
 | Emp6 |  |  |  |  |  |  | Emp3
 | Emp7 |  |  |  |  |  |  | L |  | 1 |  |  |  |  | 1
 | [NAME] |  |  |  |  |  |  | U |  |  |  |  |  | 4 | 4
 | Emp9 |  |  |  |  |  |  | Emp3 Total |  | 1 |  |  |  | 4 | 5
 | Emp1 |  |  |  |  |  |  | Emp4
 | Emp2 |  |  |  |  |  |  | O |  |  |  | 5 |  |  | 5
 | Emp3 |  |  |  |  |  |  | Emp4 Total |  |  |  | 5 |  |  | 5
 | Emp4 |  |  |  |  |  |  | Emp6
 | Emp5 |  |  |  |  |  |  | S |  |  |  |  | 2 |  | 2
 | Emp6 |  |  |  |  |  |  | U | 2 |  |  |  |  |  | 2
 | Emp7 |  |  |  |  |  |  | Emp6 Total | 2 |  |  |  | 2 |  | 4
 | [NAME] |  |  |  |  |  |  | Emp7
 | Emp9 |  |  |  |  |  |  | O |  |  |  |  | 1 |  | 1
 | Emp1 |  |  |  |  |  |  | W |  | 1 |  |  |  |  | 1
 | Emp2 |  |  |  |  |  |  | Emp7 Total |  | 1 |  |  | 1 |  | 2
 | Emp3 |  |  |  |  |  |  | Emp9
 | Emp4 |  |  |  |  |  |  | R |  |  |  |  | 4 |  | 4
 | Emp5 |  |  |  |  |  |  | Emp9 Total |  |  |  |  | 4 |  | 4
 | Emp6 |  |  |  |  |  |  | Grand Total | 8 | 4 | 5 | 8 | 7 | 5 | 37
 | Emp7
 | [NAME]
 | Emp9
 | Emp1
 | Emp2
 | Emp3
 | Emp4
 | Emp5
 | Emp6
 | Emp7
 | [NAME]
 | Emp9
 | Emp1
 | Emp2
 | Emp3
 | Emp4
 | Emp5
 | Emp6
 | Emp7
 | [NAME]
 | Emp9
 | Emp1
 | Emp2
 | Emp3
 | Emp4
 | Emp5
 | Emp6
 | Emp7
 | [NAME]
 | Emp9
 | Emp1
 | Emp2
 | Emp3
 | Emp4
 | Emp5
 | Emp6
 | Emp7
 | [NAME]
 | Emp9
 | Emp1
 | Emp2
 | Emp3
 | Emp4
 | Emp5
 | Emp6
 | Emp7
 | [NAME]
 | Emp9
 | Emp1
 | Emp2
 | Emp3
 | Emp4
 | Emp5
 | Emp6
 | Emp7
 | [NAME]
 | Emp9
 | Emp1
 | Emp2
 | Emp3
 | Emp4
 | Emp5
 | Emp6
 | Emp7
 | [NAME]
 | Emp9
Spreadsheet: 75117d1275647571-excel-2007-auto-populating-payroll-deadlines-calculator-test-timetable
Sheet: Sheet1

PAY                  PERIOD | Sickness Input | HR Deadline all payroll changes. | Last minute changes deadline | Final payroll calculation agreed | Bacs file sent to Finance | Finance submit bacs | Payslips posted | PAY DATE | GL's emailed to Finance
 | 7 WD Before Bacs | 5 WD before Bacs | 1 WD after HR Deadline | 1 WD before Bacs | 2 WD before Pay Date | 2 WD before Pay Date | 2 WD before Pay Date | LWD of each month. | 2 WD before Pay Date
TIMELINES | COB | COB |  |  | COB
April
Period 01
May
Period 02
June
Period 03
July
Period 04
Aug
Period 05
Sep
Period 06
October
Period 07
November
Period 08
December
Period 09
January
Period 10
February
Period 11
March
Period 12
Spreadsheet: darrell_schoolcraft__7796__imbalsumm0107
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -85969
3531
60667
60749 |  | -12855
61206
61334 | -118903
62960
INDEX
2000-06-30 00:00:00 |  |  | 1010525.98
2001-07-22 00:00:00
Spreadsheet: 221969d1363719341-automatically-sort-data-by-highest-percentage-extracting_rank_desc
Sheet: Sheet1

Name | Percent | UniqueRanking | Rank |  | Rank Desc | percent
name1 | 0.02
[NAME] | 0.03
name3 | 0.05
name4 | 0.02
name5 | 0.03
name6 | 0.05
name7 | 0.0633333333333333
name8 | 0.0783333333333333
name9 | 0.0933333333333333
name10 | 0.108333333333333
name11 | 0.123333333333333
name12 | 0.138333333333333
name13 | 0.153333333333333
name14 | 0.168333333333333
[NAME] | 0.7
[NAME] | 1
Spreadsheet: 204524d1357564680-help-with-conditional-format-or-time-formula-master-plan-tracker-sample
Sheet: Implementation Plan

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Initial Issue: |  |  |  |  |  |  |  | 1 |  | Updated: |  |  |  |  | 2013-01-07 13:14:59
 | [NAME] AND STATUS |  |  |  |  |  | JANUARY |  |  |  | FEBRUARY |  |  |  | [NAME] |  |  |  |  | APRIL |  |  |  |  | MAY |  |  |  | [NAME] |  |  |  | JULY |  |  |  |  | AUGUST |  |  |  | SEPTEMBER |  |  |  |  | OCTOBER |  |  |  | NOVEMBER |  |  |  | DECEMBER |  |  |  | JANUARY |  |  |  | FEBRUARY |  |  |  | [NAME]
No. | Section | Ref. | OWNER | SUPPORTING | DUE | STATUS | 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 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
0 | ANALYSIS OF REQUIREMENTS
 |  | 0 |  |  | 2013-01-01 00:00:00
 |  | 0.1 |  |  | 2013-01-01 00:00:00
 |  | 0.2
 |  | 0.3
1 | Machines
 |  | 1
 |  | 1.1
 |  | 1.2
 |  | 1.3
 |  | 1.4
 |  | 1.5
 |  | 1.6
 |  | 1.7
2 | Tooling
 |  | 2
 |  | 2.1
 |  | 2.2
 |  | 2.3
 |  | 2.4
 |  | 2.5
 |  | 2.6
 |  | 2.7
 |  | 2.8
 |  | 2.9
 |  | 2.91
 |  | 2.92
 |  | 2.93
 |  | 2.94
3 | Fixtures
 |  | 3
 |  | 3.1
 |  | 3.2
 |  | 3.3
 |  | 3.4
 |  | 3.5
 |  | 3.6
 |  | 3.7
 |  | 3.8
 |  | 3.9
 |  | 3.91
 |  | 3.92
 |  | 3.93
 | Review Output milestone | 3.94
4 | Programming
 |  | 4
 |  | 4.1
 |  | 4.2
 |  | 4.3
 |  | 4.4
 |  | 4.5
 |  | 4.6
 |  | 4.7
 |  | 4.8
 |  | 4.9
 |  | 4.91
 |  | 4.92
 |  | 4.93
 |  | 4.94
 |  | 4.95
 |  | 4.96
 |  | 4.97
 |  | 4.98
 | Review Output milestone
5 | RESOURCE MANAGEMENT
 |  | 5
 |  | 5.1
 |  | 5.2
 |  | 5.3
 |  | 5.4
 |  | 5.5
6 | MEASUREMENT, ANALYSIS AND IMP.
 |  | 6
 |  | 6.1
 |  | 6.2
 |  | 6.3
 |  | 6.4
 |  | 6.5
 |  | 6.6
 |  | 6.7
 |  | 6.8
 |  | 6.9
 |  | 6.91
 |  | 6.92
 |  | 6.93
 |  | 6.94
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 20 Feb 2012

Daily Morning Staff |  |  |  |  | Monday
 | 07:30-14:30 |  | 2012-02-20 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Ralation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS
[NAME] | 4143 | Aircraft Team Leader | Annual | Annual | EFS | Annual
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME]
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS | [NAME] one day submitted to RMT
[NAME] | 4440 | Attendant | 08:00:00 | 14:00:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: 75084d1275610641-add-and-divide-previous-items-if-haden7-sum-since-last-1-issue
Sheet: Sheet1

Fillup/Add | Tank | [NAME] | Gallons | MPG | New MPG | [NAME] at fillups | [NAME] at previous fillup | [NAME] since previous fillup | Row number of previous fillup | Gallons since previous fillup | Gallons since previous fillup
Filled up | 1 | 12 | 12 | 1 | #N/A | 12 | 0 | 12 | #N/A | #N/A | #N/A
Added | 0 | 30 | 1 |  |  | 0 | 12 | 18 | 2 | 1 | 1
Added | 0 | 48 | 2 |  |  | 0 | 12 | 36 | 2 | 3 | 3
Added | 0 | 66 | 3 |  |  | 0 | 12 | 54 | 2 | 6 | 6
Added | 0 | 84 | 2 |  |  | 0 | 12 | 72 | 2 | 8 | 8
Added | 0 | 102 | 1 |  |  | 0 | 12 | 90 | 2 | 9 | 9
Filled up | 1 | 120 | 12 | 5.142857142857143 | 5.142857142857143 | 120 | 12 | 108 | 2 | 21 | 21
Added | 0 | 138 | 1 |  |  | 0 | 120 | 18 | 8 | 1 | 1
Added | 0 | 156 | 2 |  |  | 0 | 120 | 36 | 8 | 3 | 3
Added | 0 | 174 | 3 |  |  | 0 | 120 | 54 | 8 | 6 | 6
Added | 0 | 192 | 2 |  |  | 0 | 120 | 72 | 8 | 8 | 8
Added | 0 | 210 | 1 |  |  | 0 | 120 | 90 | 8 | 9 | 9
Added | 0 | 228 | 1 |  |  | 0 | 120 | 108 | 8 | 10 | 10
Filled up | 1 | 246 | 12 | 5.727272727272728 | 5.727272727272728 | 246 | 120 | 126 | 8 | 22 | 22
Added | 0 | 264 | 2 |  |  | 0 | 246 | 18 | 15 | 2 | 2
Added | 0 | 282 | 3 |  |  | 0 | 246 | 36 | 15 | 5 | 5
Added | 0 | 300 | 4 |  |  | 0 | 246 | 54 | 15 | 9 | 9
Filled up | 1 | 318 | 12 | 3.428571428571428 | 3.428571428571428 | 318 | 246 | 72 | 15 | 21 | 21
Spreadsheet: 548807d1511332797-calculation-of-days-and-month-based-on-hourly-data-ef-time-calc
Sheet: Sheet1

 |  | Months | A | B | C | D | E | F | G | H | Total Hours | Total Days
 |  | 2017-07-01 00:00:00 | 4 days, 2:27:00 | 0:00:00 | 1 day, 3:35:00 | 4 days, 3:30:00 | 0:54:00 | 0:00:00 | 1 day, 14:52:00 | 1:33:00
 |  | 2017-08-01 00:00:00 | 3 days, 3:18:00 | 0:00:00 | 1 day, 22:05:00 | 8:01:00 | 1:41:00 | 10:44:00 | 10:38:00 | 0:24:00
 |  | 2017-09-01 00:00:00 | 4 days, 4:57:00 | 0:00:00 | 1 day, 1:38:00 | 1 day, 23:03:00 | 1:22:00 | 1 day, 22:11:00 | 1 day, 15:44:00 | 11:37:00
 |  | 2017-10-01 00:00:00 | 3 days, 3:18:00 | 0:00:00 | 1 day, 22:05:00 | 8:01:00 | 1:41:00 | 10:44:00 | 10:38:00 | 0:24:00
 |  | Total
 |  | Total Months
Spreadsheet: 827026d1682437623-countifs-matchif-forumla-finding-criteria-on-two-sheets-then-comparing-then-count-countifs-or-matchif-help
Sheet: Report

Name | [NAME] | (desired output) # of Current Access items that match Agreed Access | (desired output) # of Current Access items that do not match Agreed Access
Smith | [EMAIL] | 4 | 1
[NAME] | [EMAIL] | 4 | 1
Adam | [EMAIL] | 4 | 1
[NAME] | [EMAIL] | 4 | 1
[NAME] | [EMAIL] | 4 | 1
 |  | I need the formula to find (person/email) on the Agreed Access sheet then count how many of his access rights match what is on the Current Access sheet. I've tried countifs, Matchif, and vlookup wrapped with countif, and all my attempts have resulted in excel telling me my argument is broken. | Inversely I need the formula to find (person/email) on the Current Access sheet then count how many of his access rights do not match what is on the Agreed Access sheet. I simplified it by adding the items in red on Current Access.
Spreadsheet: peter_keavey__28651__BMO Curve
Sheet: Sheet1

 | 2001-11-01 00:00:00
 | 2001-11-02 00:00:00
 | 2001-11-03 00:00:00 | 2.95
 | 2001-11-04 00:00:00 | 2.95
 | 2001-11-05 00:00:00 | 2.95
 | 2001-11-06 00:00:00 | 2.88
 | 2001-11-07 00:00:00 | 2.75
 | 2001-11-08 00:00:00
 | 2001-11-09 00:00:00
 | 2001-11-10 00:00:00
 | 2001-11-11 00:00:00
 | 2001-11-12 00:00:00
 | 2001-11-13 00:00:00
 | 2001-11-14 00:00:00
 | 2001-11-15 00:00:00 | 2.72
 | 2001-11-16 00:00:00
 | 2001-11-17 00:00:00
 | 2001-11-18 00:00:00
 | 2001-11-19 00:00:00
 | 2001-11-20 00:00:00
 | 2001-11-21 00:00:00
 | 2001-11-22 00:00:00
 | 2001-11-23 00:00:00
 | 2001-11-24 00:00:00
 | 2001-11-25 00:00:00
 | 2001-11-26 00:00:00
 | 2001-11-27 00:00:00
 | 2001-11-28 00:00:00
 | 2001-11-29 00:00:00
 | 2001-11-30 00:00:00
Spreadsheet: 136c6594-d14e-41f6-a1fb-2f581b66aa9f
Sheet: Sheet1

1 | 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
АААААААААААААААААААААА
 |  | [NAME] на предприятието, учреждението или организацията
 |  |  |  |  |  | З  А  П  О  В  Е  Д
 |  |  |  |  |  |  | № | 14 | 2008-05-12 00:00:00
 | На основание чл. |  | 325 | ал. |  | т. |  | от КТ във връзка с чл. | 325 | ал. |  | т.
 | на ПМС (РМС № |  |  | от |  | година)
 |  | П Р Е К Р А Т Я В А М   Т Р У Д О В И Я   Д О Г О В О Р
 | с | 2 3 4
 |  |  |  |  |  |  |  | трите имена по документ за самоличност
 |  |  |  |  |  |  |  |  | ЕГН/ЛНЧ |  |  | 1234567890
 | от
 |  |  |  |  |  |  |  | предприятие
 | с място на работа
 |  |  |  |  |  |  |  | цех, участък, бригада, дейност, отдел
 | в
 |  |  |  |  |  |  |  | (поделение, звено)
 | на длъжност |  | Шивач
 | считано от |  | 1900-01-01 00:00:00
 | Причини за прекратяване на трудовия договор
 | На [NAME] (служителя) да се изплатят следните обезщетения
 | 1) | —  на основание |  |  |  |  |  |  |  |  |  |  | 1 | лева
 | 2) | [NAME] [NAME] |  |  |  |  |  |  |  |  |  |  | 2 | лева
 |  | —  други условия |  |  |  |  |  |  |  |  |  |  | 3 | лева
 |  |  |  |  |  |  |  |  |  |  |  | Всичко: | 6 | лева
 | Препис от настоящата заповед да се връчи за сведение на ръководителя на звеното
 | и на лицето, и за изпълнение на „Личен състав", и на касиера.
 | Подготвил заповедта:................................       [NAME]:................................
 | Съгласувано  с: |  | Гл. счетоводител: |  |  |  |  | Юрисконсулт: | Ръководител ТРЗ:
 |  |  |  |  |  | (подпис) |  | (подпис) |  |  |  |  | (подпис)
 | Заповедта получих............ 20....год. |  |  |  |  |  |  | Лицето е напуснало...........   20...........год.
 | Подпис на лицето: |  |  | …………………………… |  |  |  | Зав.   „Личен  състав":......................
 |  |  |  |  | (подпис)
Spreadsheet: john_griffith__15682__05_15_01ON
Sheet: Sheet1

N
Commodity: | ON - NAT. GAS OPTS.
Month | STRIKE | BID | OFFER | Volatility | Future
M01-P/C | 450 | 33.5 | 34.5
N01-P/C | 455 | 65.5 | 67.5
Q01-P/C | 460 | 85 | 89
U01-P/C | 465 | 104 | 108
V01-P/C | 465 | 119 | 123
X01-P/C | 485 | 140 | 144
[NAME]-P/C | 500 | 158 | 163
F02-P/C | 505 | 173 | 179
G02-P/C | 495 | 179 | 183
H02-P/C | 475 | 165 | 170
J02-P/C | 440 | 122 | 130
K02-P/C | 430 | 113 | 123
M02-P/C | 430
U02-P/C | 430
Spreadsheet: 790771d1659984540-totalling-columns-dependent-upon-text-day-team-flexi-sheet
Sheet: Sep 22

'[NAME] |  |  |  |  |  |  |  |  | Name
FLEXIBLE WORKING HOURS RECORD |  |  |  |  |  |  |  |  | Month | September | 2022
 |  |  |  |  |  | Hours brought forward
 | MORNING |  | AFTERNOON |  | Credit | Debit | Excess | Excess |  | Totals
 | Start | Finish | Start | Finish | Hours | Hours | or [NAME] | > 10 hrs | Comments | Daily | Toil
2022-09-01 00:00:00 |  |  |  |  |  | 0:00:00
2022-09-02 00:00:00 |  |  |  |  |  | 0:00:00
2022-09-05 00:00:00 |  |  |  |  |  | 0:00:00
2022-09-06 00:00:00 |  |  |  |  |  | 0:00:00
2022-09-07 00:00:00 |  |  |  |  |  | 0:00:00
2022-09-08 00:00:00 |  |  |  |  |  | 0:00:00
2022-09-09 00:00:00 |  |  |  |  |  | 0:00:00
2022-09-12 00:00:00 |  |  |  |  |  | 0:00:00
2022-09-13 00:00:00 |  |  |  |  |  | 0:00:00
2022-09-14 00:00:00 |  |  |  |  |  | 0:00:00
2022-09-15 00:00:00 |  |  |  |  |  | 0:00:00
2022-09-16 00:00:00 |  |  |  |  |  | 0:00:00
2022-09-19 00:00:00 |  |  |  |  |  | 0:00:00
2022-09-20 00:00:00 |  |  |  |  |  | 0:00:00
2022-09-21 00:00:00 |  |  |  |  |  | 0:00:00
2022-09-22 00:00:00 |  |  |  |  |  | 0:00:00
2022-09-23 00:00:00 |  |  |  |  |  | 0:00:00
2022-09-26 00:00:00 |  |  |  |  |  | 0:00:00
2022-09-27 00:00:00 |  |  |  |  |  | 0:00:00
2022-09-28 00:00:00 |  |  |  |  |  | 0:00:00
2022-09-29 00:00:00 |  |  |  |  |  | 0:00:00
2022-09-30 00:00:00 |  |  |  |  |  | 0:00:00
Signed |  |  |  |  |  | Date |  |  | Net Hours Worked this period
Approved |  |  |  |  |  | Date |  |  | Flexitime credit/debit carried forward
 |  |  |  |  |  |  |  |  | Toil this month
 |  | Annual Leave remaining from previous month |  |  |  |  |  |  | Toil from previous month
 |  | Annual Leave taken this month |  |  |  |  |  |  | Toil taken |  | 0:00:00
 |  | Total Annual Leave remaining |  |  |  |  |  |  | Total toil
Spreadsheet: 190706d1351767228-multiple-if-statement-with-additional-requirements-query
Sheet: Sheet1

Client Attributor | Client ID | Start Date | Completion Date | Outcomes
B-F-20/04/1969-M | 1234 | 2012-08-09 00:00:00 | 2012-10-10 00:00:00 | Found house
 |  |  |  | Offer accepted
 |  |  |  | Moving in
D-B-11/06/1980-M | 1356 | 2012-08-09 00:00:00 |  | Found house
 |  |  |  | Offer accepted
 |  |  |  | Fell through
E-J-19/04/1988-F | 2589 | 2012-08-09 00:00:00 | 2012-10-14 00:00:00 | Bought Furniture
 |  |  |  | Found house
 |  |  |  | Moving in
L-G-16/10/1987-M | 3546 | 2012-08-09 00:00:00 |  | Found house
 |  |  |  | Offer accepted
M-T-30/06/1970-F | 4896 | 2012-08-09 00:00:00 |  | Found house
 |  |  |  | Offer accepted
N-G-14/03/1966-M | 1547 | 2012-08-09 00:00:00 | 2012-10-20 00:00:00 | Found house
 |  |  |  | Offer accepted
 |  |  |  | Moving in
 |  |  | `
Spreadsheet: 598755d1542703404-conditional-formatting-colouring-specific-cells-excel-forum-conditional-formatting
Sheet: Project Planner

 | [NAME]
 |  |  |  |  |  | In months
 | [NAME] | Product Number | Starting Year | Ending Year | Contribution Margin | Estimated Payback | Payback Index |  | Break Even Index |  | Years
 |  |  |  |  |  |  |  |  |  |  | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 |  |  |  |  |  |  |  |  |  |  | CM Calculations
 | Multi Frame:x | 1042 | 2015 | 2018 |  | 0 | 32.94709252325026 | 0 | 117.0281627186708 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0.5129441539572208
 | Flamingo HL | 1049 | 2016 |  |  | 0 | 553.9018368840237 | 0 | 5.800873981884131 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0.6582283154507
 | Wombat Living | 1058 | 2016 |  |  | 0 | 616.0233579288772 | 0 | 4.151428701954494 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0.7111614843837947
 | Stingray Upgrade |  | 2016 |  |  | 0 | 357.4360324261084 | 0 | 9.117761215403902 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0.2828301693214722
 | Cricket | 1046 | 2016 |  |  | 0 | 40.35515878784558 | 0 | 65.80912539285818 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0.4997246138538871
 | Scallop | 1051 | 2016 |  |  | 0 | 128.9612873680031 | 0 | 20.5932939963575 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0.5942439047124332
 | Heron w power | 1050 | 2017 |  |  | 0 | 59.34931069097519 | 0 | 28.67159406656851 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0.56742097252279
 | Meerkat | 1039 | 2018 |  |  | 14 | 15.09693925444703 | -1.096939254447026 | 66.23859201827517 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0.9538558295877286
 | x:panda facelift | 1059 | 2018 |  |  | 15 | 26 | -1.096939254447026 | 180 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0.9596564345205822
Spreadsheet: 165442d1341234135-if-cell-is-y-then-put-rows-information-into-certain-area-of-another-sheet-help-fulldailymold-try-to-copy-to-usage
Sheet: Disa 1

DATE: |  |  |  | DAILY MODLING PRODUCTION |  |  |  |  | PAGE: | 1 | OF | 1
EMP.NO: |  |  | NAME: |  |  |  | SHIFT: |  | WORK CTR: |  | MACH.NO: | 4000
START TIME | END TIME | OPER. NO. | PATTERN NO. | MOLDS MADE | MOLDS DESTROYED | MOLDS CLOSED | PART NO. | M.O. | PART RATE | IMP | PCS. MADE | DOWNTIME  (MINS) | CORED (Y/N)
20:00:00 | 21:00:00 | 20 | P111 | 400 |  | 5 | 11911 | M100077 | 250 | 2 | 790 |  | Y
 |  |  |  |  |  |  |  | M50025 |  |  |  |  | N
 |  |  |  |  |  |  |  | M95874 |  |  |  |  | Y
DATE: |  |  |  | DAILY MODLING PRODUCTION |  |  |  |  | PAGE: | 2 | OF | 2
EMP.NO: |  |  | NAME: |  |  |  | SHIFT: |  | WORK CTR: |  | MACH.NO: | 4000
START TIME | END TIME | OPER. NO. | PATTERN NO. | MOLDS MADE | MOLDS DESTROYED | MOLDS CLOSED | PART NO. | M.O. | PART RATE | IMP | PCS. MADE | DOWNTIME  (MINS) | CORED (Y/N)
 |  |  |  |  |  |  |  | m1212 |  |  |  |  | Y
 |  |  |  |  |  |  |  | M7777 |  |  |  |  | N
DATE: |  |  |  | DAILY MODLING PRODUCTION |  |  |  |  | PAGE: | 3 | OF | 3
EMP.NO: |  |  | NAME: |  |  |  | SHIFT: |  | WORK CTR: |  | MACH.NO: | 4000
START TIME | END TIME | OPER. NO. | PATTERN NO. | MOLDS MADE | MOLDS DESTROYED | MOLDS CLOSED | PART NO. | M.O. | PART RATE | IMP | PCS. MADE | DOWNTIME  (MINS) | CORED (Y/N)
Spreadsheet: 648997d1573377587-how-to-find-nearest-value-in-excel-nearest-point
Sheet: Sheet1

NEW DATA |  |  |  | NEAREST POINT |  |  |  |  |  | OLD DATA
GULLY_NO | FM_EASTING | FM_NORTHING |  | GULLY_NO | FM_EASTING | FM_NORTHING |  |  |  | GULLY_NO | Easting (X) | Northing (Y)
55/SA/33/G1 | 220738.544 | 387238.219 |  |  |  |  |  |  |  | 55/BD/1 | 222529.349 | 387863.667
55/WB/SA1A/G2 | 227316.391 | 391205.881 |  |  |  |  |  |  |  | 55/BD/2 | 222460.898 | 387652.85
ASF/5/1/1/G1A | 221820.297 | 387640.736 |  |  |  |  |  |  |  | 55/BD/3 | 221852.452 | 387640.789
ASF/5/1/1/G2 | 221852.384 | 387640.742 |  |  |  |  |  |  |  | 55/BD/4 | 221820.068 | 387628.96
ASF/5/1/1/G5 | 221844.918 | 387628.963 |  |  |  |  |  |  |  | 55/BD/5 | 221844.784 | 387628.926
ASF/5/1/1/G6 | 221821.016 | 387628.803 |  |  |  |  |  |  |  | 55/[NAME] | 222522.967 | 387868.383
ASF/5/1/1/G6A | 221820.414 | 387628.816 |  |  |  |  |  |  |  | 55/BD/7 | 222511.128 | 387856.551
ASF/5/1/G3 | 221965.634 | 387629.571 |  |  |  |  |  |  |  | 55/BD/8 | 222454.09 | 387842.85
ASF/5/1/G4 | 221915.21 | 387629.225 |  |  |  |  |  |  |  | 55/BD/9 | 222416.716 | 387839.652
ASF/5/10/G1 | 222445.005 | 387677.73 |  |  |  |  |  |  |  | 55/BD/10 | 221965.511 | 387629.604
ASF/5/10/G2 | 222460.823 | 387652.888 |  |  |  |  |  |  |  | 55/BD/11 | 222503.601 | 387863.156
ASF/5/13/1/G1 | 222459.856 | 387851.735 |  |  |  |  |  |  |  | 55/BD/12 | 221915.022 | 387629.329
ASF/5/13/1/G2 | 222454.046 | 387842.838 |  |  |  |  |  |  |  | 55/BD/13 | 222459.825 | 387851.675
ASF/5/13/1/G3 | 222436.785 | 387838.095 |  |  |  |  |  |  |  | 55/BD/14 | 221820.132 | 387640.596
ASF/5/13/1/G4 | 222416.509 | 387839.669 |  |  |  |  |  |  |  | 55/BD/15 | 221820.938 | 387628.995
[NAME] | 222523.037 | 387868.282 |  |  |  |  |  |  |  | 55/BD/16 | 222445.054 | 387677.866
ASF/5/13/2/G2 | 222529.394 | 387863.609 |  |  |  |  |  |  |  | 55/BD/17 | 222436.88 | 387838.154
ASF/5/13/2/G3 | 222511.09 | 387856.545 |  |  |  |  |  |  |  | 55/BD/18 | 220738.59 | 387237.87
ASF/5/13/2/G4 | 222503.597 | 387863.268 |  |  |  |  |  |  |  | 55/BD/19 | 227316.454 | 391205.907