tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 865214d1712252988-sumifs-with-index-and-match-ef1634_pensionable-pt-hours
Sheet: ExcelForum

Payment Date | PThours1 | PThours2 | PThours3 | Expenditure Code1 | Expenditure Code2 | Expenditure Code3
2009-01-09 00:00:00 | 32 | 7.5 | 0 | 48579 | 48110 | 48577
2009-02-13 00:00:00 | 54.5 | 7.5 | 0 | 48579 | 48577 | 48577
2009-03-13 00:00:00 | 33.5 | 5 | 0 | 48577 | 46028 | 48110
2009-04-09 00:00:00 | 42 | 12 | 0 | 46028 | 48577 | 48110
2009-05-08 00:00:00 | 3 | 5 | 0 | 45994 | 48110 | 46533
2009-06-12 00:00:00 | 17 | 105.75 | 0 | 45994 | 48577 | 48577
2009-07-10 00:00:00 | 21.25 | 0 | 0 | 48577 | 46533 | 0
2009-08-14 00:00:00 | 44 | 6 | 0 | 48577 | 48552 | 46533
2009-10-09 00:00:00 | 25 | 1.5 | 2.5 | 45994 | 48110 | 46533
2009-12-14 00:00:00 | 56.5 | 10 | 0 | 48577 | 48110 | 48577
2010-01-08 00:00:00 | 16.5 | 41.5 | 7.5 | 48577 | 48577 | 45994
2010-02-12 00:00:00 | 13 | 2.5 | 0 | 48577 | 48110 | 0
2010-03-12 00:00:00 | 2 | 0 | 0 | 39300 | 0 | 0
2010-04-14 00:00:00 | 23 | 12.5 | 0 | 48577 | 48572 | 45994
2010-05-14 00:00:00 | 17 | 14 | 9.5 | 48577 | 48576 | 48572
2010-06-18 00:00:00 | 33 | 16.5 | 2.5 | 48577 | 48572 | 48110
2010-07-09 00:00:00 | 20 | 10 | 23.5 | 48577 | 48579 | 48577
2010-08-13 00:00:00 | 15 | 0 | 0 | 48577 | 0 | 0
2010-09-10 00:00:00 | 32 | 0 | 0 | 48577 | 0 | 0
2010-10-08 00:00:00 | 46 | 0 | 0 | 45994 | 48577 | 46900
2010-11-12 00:00:00 | 59 | 18 | 0 | 45994 | 48577 | 48110
2010-12-13 00:00:00 | 15 | 47 | 0 | 48110 | 47032 | 48577
2011-01-14 00:00:00 | 34 | 4 | 9 | 46900 | 48577 | 48110
2011-02-11 00:00:00 | 9 | 47 | 6.25 | 48110 | 45994 | 48577
2011-03-11 00:00:00 | 2 | 11.5 | 0 | 48110 | 48577 | 47032
2011-04-08 00:00:00 | 1 | 24.5 | 0 | 48110 | 48577 | 46500
2011-05-13 00:00:00 | 1 | 20.5 | 0 | 48110 | 48577 | 47032
2011-06-17 00:00:00 | 2 | 2 | 54.5 | 48110 | 48577 | 0
2011-07-08 00:00:00 | 7 | 28 | 0 | 48577 | 0 | 0
2011-11-11 00:00:00 | 32 | 0 | 0 | 48577 | 0 | 0
2011-12-09 00:00:00 | 20 | 0 | 0 | 48577 | 0 | 0
2012-01-13 00:00:00 | 27 | 0 | 0 | 48577 | 0 | 0
2012-02-10 00:00:00 | 15 | 3 | 0 | 48577 | 0 | 0
2012-03-09 00:00:00 | 10 | 5.5 | 0 | 48577 | 48579 | 0
2015-11-12 00:00:00 | 10 | 0 | 0 | 46500 | 0 | 0
2015-12-10 00:00:00 | 8 | 0 | 0 | 46500 | 0 | 0
2016-01-14 00:00:00 | 4 | 0 | 0 | 46500 | 0 | 0
2016-02-11 00:00:00 | 9 | 0 | 0 | 48572 | 0 | 0
2016-03-10 00:00:00 | 25.5 | 0 | 0 | 48577 | 20030 | 0
2016-04-14 00:00:00 | 12 | 0 | 0 | 44744 | 48572 | 0
2016-05-12 00:00:00 | 18.5 | 0 | 0 | 48572 | 44744 | 0
2016-06-09 00:00:00 | 18 | 0 | 0 | 44744 | 48572 | 0
2016-07-14 00:00:00 | 14 | 0 | 0 | 44744 | 48572 | 0
2016-08-11 00:00:00 | 6 | 0 | 0 | 44744 | 48572 | 0
2016-10-13 00:00:00 | 8.5 | 0 | 0 | 46500 | 0 | 0
2016-11-10 00:00:00 | 4 | 0 | 0 | 46500 | 0 | 0
2016-12-08 00:00:00 | 18 | 0 | 0 | 44744 | 20030 | 0
Spreadsheet: 37643d1235675339-grouping-duplicates-example-25
Sheet: Sheet3

id | name | desc
1 | martin1 | info1
1 | martin1 | info2
1 | martin3 | [NAME]
1 | martin4 | [NAME]
2 | fred1 | [NAME]
2 | fred2 | data2
2 | [NAME] | data3
3 | arthur1 | stuff
4 | steve1 | ex1
4 | steve2 | ex2
4 | steve3 | ex3
 |  | Sum of id
 |  | id | name | desc | Total |  |  |  | this is just the table copied then  paste /special/ values
 |  | 1 | martin1 | info1 | 1
 |  |  |  | info2 | 1 |  |  |  | id | name | desc
 |  |  | martin3 | [NAME] | 1 |  |  |  | 1 | martin1 | info1
 |  |  | martin4 | [NAME] | 1 |  |  |  |  |  | info2
 |  | 2 | fred1 | [NAME] | 2 |  |  |  |  | martin3 | [NAME]
 |  |  | fred2 | data2 | 2 |  |  |  |  | martin4 | [NAME]
 |  |  | [NAME] | data3 | 2 |  |  |  | 2 | fred1 | [NAME]
 |  | 3 | arthur1 | stuff | 3 |  |  |  |  | fred2 | data2
 |  | 4 | steve1 | ex1 | 4 |  |  |  |  | [NAME] | data3
 |  |  | steve2 | ex2 | 4 |  |  |  | 3 | arthur1 | stuff
 |  |  | steve3 | ex3 | 4 |  |  |  | 4 | steve1 | ex1
 |  |  |  |  |  |  |  |  |  | steve2 | ex2
 |  |  |  |  |  |  |  |  |  | steve3 | ex3
Spreadsheet: 103121d1300923697-sum-issue-test2
Sheet: Sheet1

 | Team A | Team B | Team C | Team D | All Teams
Employees Count | 10 | 25 | 34 | 19 | 88
wages | 5 | 6 | 4 | 7 | 5.329545454545454
travel | 3 | 2 | 9 | 5 | 5.465909090909091
insurance | 8 | 7 | 5 | 3 | 5.477272727272728
total cost per employee | 16 | 15 | 18 | 15 | 16.27272727272727
desired savings | 15.90909090909091 | 39.77272727272727 | 54.09090909090909 | 30.22727272727273 | 140
Employee Reduction | 0.9943181818181818 | 2.651515151515151 | 3.005050505050505 | 2.015151515151515 | 8.603351955307263 |  | 8.666035353535353
Spreadsheet: 819877d1677744724-copy-all-sheets-data-into-one-sheet-copy-all-sheets-into-one
Sheet: Sheet4

Column1 | Column2 | Column3
3 | 3 | 3
3 | 3 | 33
3 | 3 | 3
3 | 33 | 3
3 | 3 | 3
1 | 1 | 1
Spreadsheet: 98843d1297694361-need-a-formula-that-parses-and-totals-data-calculator
Sheet: Sheet1

Goal | Spaces on Data Sheet | Days Collected | Days Required | Total Blank Spaces | [NAME]
SAMPLE | 20 | 27 | 21 | 52 | 90% (488/540)
SAMPLE | 10 | 11 | 12 | 15 | 79% (95/120)
SAMPLE | 15 | 14 | 14 | 0 | 100% (210/210)
SAMPLE | 5 | 1 | 1 | 1 | 80% (4/5)
SAMPLE | 7 | 3 | 7 | 20 | 2% (1/49)
 |  |  |  |  | #N/A
 |  |  |  |  | #N/A
 |  |  |  |  | #N/A
 |  |  |  |  | #N/A
 |  |  |  | TOTAL | 99% (798/804) | < should be 86% (798/924)
Spreadsheet: 85374d1285405258-how-to-select-price-according-to-item-and-quantity-example
Sheet: Sheet1

Item | Item 1 | Item 2 | Item 3 | Item 4 |  | Price range
Price 1 | 4 | 5 | 4 | 8 |  | 1-9 | Price 1
Price 2 | 3 | 3 | 3 | 6 |  | 10-23 | Price 2
Price 3 | 2 | 2 | 2.5 | 4 |  | 24-47 | Price 3
Price 4 | 1 | 1 | 2 | 2 |  | 48-95 | Price 4
Order item | Qty | Price | Sum
Item 1 | 10 | 3
Item 3 | 5 | 4
Item 2 | 95 | 1
Item 4 | 46 | 4
Spreadsheet: 768952d1645210589-selecting-an-average-or-a-blank-based-on-a-list-of-numbers-help-excell-sample
Sheet: Sheet1

[NAME] | GPA2 | GPA3 | GPA AVG |  | GPA AVG
2.46 | 3.31
3.59 |  | 3.5
3.42 |  |  |  |  |  |  | IFERROR(CHOOSE(1,F5),(SUM(C5:E5)/COUNT(C5:E5))) | Both work if a number exists in column D but not if it's blank
 |  |  |  |  |  |  | IFERROR(CHOOSE(F6>=0,F6),(SUM(C6:E6)/COUNT(C6:E6)))
3.73
3.6
3.57
3.9 |  |  | 3.43
4
3.43 |  |  | 3.14
3.54
3.9 | 3.41
3.23 | 3.44
3.56 |  |  | 3.56
3.13
3.83 |  |  | 3.83
3.15
3.96 |  |  | 3.96
4 |  |  | 4
3.66 |  | 3.27 | 3.52
2.48
3.18 | 3.77 |  | 3.18
3.45
3.18
3.1 |  | 3.59
3.42
4
3.26 | 3.43
3.87
2.65 | 3.53
3.7
3.27 | 4 | 4
3.71
3.25
2.87 |  |  | 3.04
3.61
3.47 | 3.63 | 4 | 3.55
3.2
3.21 |  |  | 3.21
4
3.62 |  |  | 3.62
3.25 | 3.95
2.97
3.85 |  |  | 3.85
3.58 |  | 4
3.7 | 0 | 0
3.32 | 3.13
3.35 | 3.33
2.56
3.6 | 3.17 | 3.77 | 3.51
3.52
2.57
3.6 | 3.41
4
3.69 |  |  | 3.74
3.83
3.2
3.3
3.52 |  |  | 3.78
3.81 |  |  | 3.81
3.3 |  |  | 3.3
3.49
3.19 |  |  | 3.19
3.63 |  |  | 3.63
3.13 |  |  | 3.14
3.64 |  | 4 | 3.68
2.99 |  |  | 3.03
3.73 | 3.79
3.56 | 4 | 4 | 3.76
3.28 | 3.82 | 3.82 | 3.53
3.79 | 3.76 |  | 3.79
2.92 |  |  | 3.09
4
3.67 |  |  | 3.54
3.38 |  |  | 3.43
2.78 |  |  | 2.79
3.82 |  |  | 3.81
2.62 | 3.44
3.42 |  |  | 3.62
4 |  | 4 | 3.96
3.9 |  |  | 3.89
3.83 |  |  | 3.84
3.73 |  |  | 3.74
2.92 |  |  | 3.15
Spreadsheet: 0df50489-4173-4590-a5aa-85582309fdde
Sheet: Sheet1

Artist | Title | SubTitle | CatalogNumber | Category | Discs | [NAME] | Label | RetailPrice | UPC
VPI | [NAME] 33 RPM |  | S VPI 33 TUBE | Accessories for Record Cleaning Machines |  |  | Equipment | 30
VPI | 3128 Complete 45 rpm [NAME] (7&quot; discs) |  | S VPI 45KIT | Accessories for Record Cleaning Machines |  |  | Equipment | 90
VPI | 3129 Complete 78 rpm [NAME] (10" discs) |  | S VPI 78KIT | Accessories for Record Cleaning Machines |  |  | Equipment | 72
VPI | VPI Tube 45 RPM for 7&quot; Records |  | S VPI 45 TUBE | Accessories for Record Cleaning Machines |  |  | Equipment | 30
Spreadsheet: 121f91cb-2cee-4d2d-9c77-7805abefec1f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
0.125 |  | 0.25 |  |  | Total offerings
0.25 |  | 0.5 |  |  | Total oz equivalents
0.375 |  | 0.75
0.5 |  | 1
0.625 |  | 1.25
0.75 |  | 1.5
0.875 |  | 1.75
1 |  | 2
1.125
1.25
1.375
1.5
1.625
1.75
1.875
2
Spreadsheet: 471545d1469074160-add-new-row-in-another-excel-sheet-add-new-row-in-another-excel-sheet
Sheet: 01 Table

01 Table
Asset |  |  |  | Quantity | Date | Price per Unit | Total Price in Purchased Date | Depreciation Percentage | Depreciation Expense | Total Price
Asset | Brand | Gen. | Code
Spreadsheet: 48484d1247685362-calculating-total-forecasting-test
Sheet: DTO_HIS

PCGPO | LOB | Product | Accounts | Consolidated Product | Wgt | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | 2007-07-01 00:00:00 | 2007-08-01 00:00:00 | 2007-09-01 00:00:00 | 2007-10-01 00:00:00 | 2007-11-01 00:00:00 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 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 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00
DTO |  | Accounts |  | DTO | 1 | 10368 | 10329 | 10283 | 10214 | 10226 | 10151 | 10083 | 10100 | 12150 | 12209 | 12237 | 12241 | 12249 | 12263 | 12219 | 12237 | 12236 | 12086 | 12067 | 11936 | 11865 | 11843 | 11849 | 11834 | 11857 | 11870 | 11822 | 11818 | 11719 | 11592 | 11417 | 11388 | 11469 | 11341 | 11360 | 11379
ITC |  | Accounts |  | DTO | 1 | 136 | 136 | 137 | 138 | 130 | 130 | 131 | 127 | 125 | 124 | 125 | 126 | 130 | 130 | 130 | 130 | 130 | 131 | 131 | 131 | 131 | 131 | 137 | 137 | 136 | 135 | 131 | 131 | 131 | 131 | 129 | 129 | 130 | 129 | 129 | 129
HIS |  | Accounts |  | DTO | 1 | 16845 | 16965 | 17145 | 17355 | 17469 | 17769 | 18530 | 18592 | 18172 | 18295 | 18377 | 18732 | 18657 | 18804 | 18462 | 18576 | 18117 | 18348 | 18545 | 18699 | 18899 | 18824 | 19102 | 18819 | 18848 | 18906 | 19006 | 19074 | 19161 | 19195 | 19296 | 19464 | 19601 | 19382 | 19415 | 19448
DTO_HIS | Spare
DTO_HIS | Spare
DTO_HIS | Spare
DTO_HIS | Spare
DTO_HIS | Spare
DTO_HIS | Spare
 |  |  |  | TOTAL WGT VOL |  | 27349 | 27430 | 27565 | 27707 | 27825 | 28050 | 28744 | 28819 | 30447 | 30628 | 30739 | 31099 | 31036 | 31197 | 30811 | 30943 | 30483 | 30565 | 30743 | 30766 | 30895 | 30798 | 31088 | 30790 | 30841 | 30911 | 30959 | 31023 | 31011 | 30918 | 30842 | 30981 | 31200 | 30852 | 30904 | 30956
Spreadsheet: 862014d1709818039-reverse-calculation-retirment-calculator-excel
Sheet: Tax and deductions rates

 |  | Basic personal exemption | Surtax 1 | On tax owing above | Surtax 2 | On tax owing above | Tax bracket 1 | On income up to | Tax bracket 2 | On income up to | Tax bracket 3 | On income up to | Tax bracket 4 | On income up to | Tax bracket 5 | On income up to | Tax bracket 6 | On income up to | Tax bracket 7 | On income up to | Tax bracket 8 | On income up to
 | Federal | 15000 | 0 | 0 | 0 | 0 | 0.15 | 53359 | 0.205 | 106717 | 0.26 | 165430 | 0.29 | 235675 | 0.33 | 1000000000
 | BC | 11302 | 0 | 0 | 0 | 0 | 0.0506 | 45654 | 0.077 | 91310 | 0.105 | 104835 | 0.1229 | 127299 | 0.147 | 176602 | 0.168 | 240716 | 0.205 | 1000000000
 | AB | 19814 | 0 | 0 | 0 | 0 | 0.1 | 142292 | 0.12 | 170751 | 0.13 | 227668 | 0.14 | 341502 | 0.15 | 1000000000
 | SK | 17661 | 0 | 0 | 0 | 0 | 0.105 | 49720 | 0.125 | 142058 | 0.145 | 1000000000
 | MB | 15000 | 0 | 0 | 0 | 0 | 0.108 | 36842 | 0.1275 | 79625 | 0.174 | 1000000000
 | ON | 11865 | 0.2 | 5315 | 0.36 | 6802 | 0.0505 | 49231 | 0.0915 | 98463 | 0.1116 | 150000 | 0.1216 | 220000 | 0.1316 | 1000000000
 | QC | 17183 | 0 | 0 | 0 | 0 | 0.14 | 49275 | 0.19 | 98540 | 0.24 | 119910 | 0.2575 | 1000000000
 | NB | 12458 | 0 | 0 | 0 | 0 | 0.094 | 47715 | 0.14 | 95431 | 0.16 | 176756 | 0.195 | 1000000000
 | PEI | 13500 | 0 | 0 | 0 | 0 | 0.0965 | 32656 | 0.1363 | 64313 | 0.1665 | 105000 | 0.18 | 140000 | 0.1875 | 1000000000
 | NS | 8481 | 0 | 0 | 0 | 0 | 0.0879 | 29590 | 0.1495 | 59180 | 0.1667 | 93000 | 0.175 | 150000 | 0.21 | 1000000000
 | NL | 10382 | 0 | 0 | 0 | 0 | 0.087 | 41457 | 0.145 | 82913 | 0.158 | 148027 | 0.178 | 207239 | 0.198 | 264750 | 0.208 | 529500 | 0.213 | 1059000 | 0.218 | 1000000000
 | YK | 15000 | 0 | 0 | 0 | 0 | 0.064 | 53539 | 0.09 | 106717 | 0.109 | 165430 | 0.1293 | 235675 | 0.128 | 500000 | 0.15 | 1000000000
 | NWT | 16583 | 0 | 0 | 0 | 0 | 0.059 | 48326 | 0.086 | 96655 | 0.111 | 157139 | 0.1405 | 1000000000
 | NU | 17925 | 0 | 0 | 0 | 0 | 0.04 | 50877 | 0.07 | 101654 | 0.09 | 165429 | 0.115 | 1000000000
 |  | [NAME] pensionable/insurable | Rate
 | CPP | 66600 | 0.0595
 | EI | 61500 | 0.0163
 |  | Group A (joined before 2013) | Group B (joined after 2013)
 | Low (below CCP max insurable) | 0.0935 | 0.0793
 | High (above CPP [NAME] insurable) | 0.1237 | 0.1172
 | Quebec abatement (% of federal tax) | 0.165
 | PUBLIC PENSIONS
 | Current CPP maximum pension
 | Current maximum OAS benefit (ages 65 to 74)
 | Current maximum OAS benefit (age 75 and older)
 | Current OAS clawback threshold | 86912
 | OAS Clawback rate | 0.15
Spreadsheet: 828929d1683798282-search-a-text-from-an-array-of-values-s666-pq-search-a-text-from-an-array-of-values
Sheet: Sheet1

Text |  | Text | Result
1.  Hours and [NAME] (P311221) |  | 1.  Hours and [NAME] P311221 | P311221
1. RMA Revisions - P400511 (ZJDE0001) |  | 1. RMA Revisions - P400511 ZJDE0001 | P400511
6. Preference Profile (R40400) |  | 6. Preference Profile R40400 | R40400
12. Specify P4113 version to use (Recognize blank LOTS) custom PO's from P4113 to hold TO_LOCATION lot status even though it is blank.   Note - this option is used inline with above PO option value -1.    Default - ZJDE0001 |  | 12. Specify P4113 version to use Recognize blank LOTS custom PO's from P4113 to hold TO_LOCATION lot status even though it is blank.   Note - this option is used inline with above PO option value -1.    Default - ZJDE0001 | P4113
2. Enter Version for R04110ZA |  | 2. Enter Version for R04110ZA | R04110ZA
1. Enter Version for R47011 : |  | 1. Enter Version for R47011 : | R47011
3.  Enter the version for [NAME] (cvt to .txt) to call.       Blank = Version XBX0002 with the country        code defined here. |  | 3.  Enter the version for [NAME] cvt to .t t to call.       Blank = Version XBX0002 with the country        code defined here. | [NAME]
12. P42101 [NAME] |  | 12. P42101 [NAME] | P42101
1. R42565 Version |  | 1. R42565 Version | R42565
3. Test Results Revisions (P3711) |  | 3. Test Results Revisions P3711 | P3711
3.  [NAME] (P43512) |  | 8. Tickler Version P5900088 | P5900088
8. Tickler Version [P5900088]
Spreadsheet: 1bfd128e-c88c-4c60-b6f6-9c75c8f76150
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
261656 | 40701 | [NAME] | Rodriguez | ESP | 1 | 00:12:19 | 00:02:21 | 00:31:00 | 00:00:00 | 00:25:41 | 1 | 01:11:20
Spreadsheet: 162361d1339815595-calculate-an-even-spread-of-data-over-a-12-month-period-spread
Sheet: Sheet1

Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
125 |  |  |  |  |  |  |  |  |  |  | 483
Spreadsheet: 63694d1264579318-xl-2008-dynamic-chart-not-acting-dynamically-budget92_08
Sheet: Summary

beta v .91 | Years | (Show All) |  | R
 | Sum of Amt |  |  |  | Budget | [NAME]
 | Account | Date | Total
 | Awards | Feb | -201
 |  | Apr | -84
 | Awards Total |  | -285
 | Demolay | Jan | -54.4
 |  | Feb | -66
 |  | Apr | -78.95
 | Demolay Total |  | -199.35
 | Donations - from member | Feb | 100
 |  | Mar | 100
 | Donations - from member Total |  | 200
 | GL Comm Assis. | Feb | -3000
 |  | Mar | -55.5
 | GL Comm Assis. Total |  | -3055.5
 | GL fees | Apr | -99
 | GL fees Total |  | -99
 | IORG | Mar | -50
 | IORG Total |  | -50
 | Meals - Regular | Jan | -1000
 | Meals - Regular Total |  | -1000
 | Meals - Special | Jan | -878
 | Meals - Special Total |  | -878
 | Office Supplies | Feb | -987
 | Office Supplies Total |  | -987
 | Rent | Jan | -200
 | Rent Total |  | -200
 | Donations - from others | Apr | 75
 | Donations - from others Total |  | 75
 | Degree expense | Jan | -600
 |  | Feb | -49
 | Degree expense Total |  | -649
 | Donation - to [NAME] | Mar | -77
 | Donation - to MLA Total |  | -77
 | Grand Total |  | -7204.85
Spreadsheet: 847734d1698601513-using-a-formula-to-copy-cells-from-one-sheet-to-another-both-the-data-and-formatting-agenda-temp
Sheet: ALLDAYS

AGENDA - THURSDAY |  |  | 2024 |  |  | AGENDA - FRIDAY |  |  | 2024
START | END | SESSION 1 | SESSION 2 |  |  | START | END | SESSION 1 | SESSION 2
 |  |  |  |  |  | 06:30:00 | 07:15:00
 |  |  |  |  |  | 07:15:00 | 08:00:00
 |  |  |  |  |  | 08:00:00 | 09:30:00
 |  |  |  |  |  | 09:00:00 | 10:00:00
 |  |  |  |  |  | 10:05:00 | 11:05:00
 |  |  |  |  |  | 11:00:00 | 11:45:00
 |  | Concurrent Session (Medical) | Concurrent Session (Ethics) |  |  | 11:30:00 | 12:30:00
 |  | Concurrent Session (Medical) | Concurrent Session (Ethics) |  |  | 12:30:00 | 13:25:00
 |  | Networking Event / Hot Buffet |  |  |  | 13:30:00 | 14:30:00
 |  |  |  |  |  | 14:30:00 | 16:30:00
 |  |  |  |  |  | 14:45:00 | 15:45:00
 |  |  |  |  |  | 17:11:00
 |  |  |  |  |  | 17:15:00
 |  |  |  |  |  | 17:29:00
 |  |  |  |  |  | 18:30:00
 |  |  |  |  |  | 20:45:00 | 21:45:00
 |  |  |  |  |  | 21:45:00 | 23:45:00
 |  |  |  |  |  | 22:00:00 | 23:00:00
Spreadsheet: 736728d1623837340-automatically-apply-a-percentage-on-a-cell-sample-
Sheet: Feuil1

 | Belgium
DHL Parcel | 10 |  |  |  |  |  | [NAME] |  | Be aware that all carrier rates change every month, same for the fuel surcharge, and that my fuel surcharge fees are on another tab normally
PostNL | 10.5 |  |  |  |  | DHL Parcel | 0.0925
 |  |  |  |  |  | PostNL | 0
Lowest Price
Cheapest Carrier
[NAME]
Price with [NAME]
 | What I would like is the B3 cell, that it automatically applies the fuel surcharge there, let's say I receive a new offer for DHL Parcel and that is now 11€, when I type 11, it automatically applies the 9,25% additional fee there without having to type =11+11*0,0925, it might sound an odd request but you have to realise this table extends to all countries of Europe, a whole bunch of carriers, and this would be the rates just for a 30Kg box for example, I need to do extra tabs for ,5kg, 1kg, 2 kg, enveloppes, pallets, etc
Spreadsheet: 329511d1404325948-trouble-with-sumif-formula-on-totals-tab-example-payroll-2
Sheet: Pay Period 1

Starting Weekday | Ending Week Day
2014-06-23 00:00:00
 |  |  |  | Week 1 |  | Week 2 |  | Bi-Weekly Totals (ending on:) |  |  |  |  |  | Total Hours Billed
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Amount Payments Received
Trainer | Session Type | Fees | Client | Frequency | Dates | Frequency | Dates | Date Billed | Date Payment Received | Hours Billed | Payment Amount | Amount Paid to [NAME] |  | Total Amount Paid to Trainers
[NAME] | 60 Minute |  | Becky | 2 | 6/23, 6/25 | 2 | 7/1, 7/4 | 2014-07-06 00:00:00 | 2014-07-10 00:00:00 |  |  |  |  | Total Profit:
Ceci | 45 Minute |  | Kelly | 3 | 6/23, 6/26, 6/27 | 1 | 2014-07-01 00:00:00 | 2014-07-06 00:00:00 | 2014-07-10 00:00:00
Ceci | Class |  | [NAME] | 1 | 2014-06-23 00:00:00 | 2 | 7/1, 7/6 | 2014-07-06 00:00:00 | 2014-07-10 00:00:00
New Hire | 60 Minute |  | [NAME] | 2 | 6/23, 6/28 | 2 | 7/1, 7/6 | 2014-07-06 00:00:00 | 2014-07-10 00:00:00 |  |  |  |  | # 60 Minute Sessions
[NAME] | Office Work |  | Muffy | 1 | 2014-06-23 00:00:00 | 2 | 7/1, 7/6 | 2014-07-06 00:00:00 | 2014-07-10 00:00:00 |  |  |  |  | # 45 Minute Sessions
Kilee | 60 Minute |  | [NAME] | 1 | 2014-06-23 00:00:00 | 3 | 7/3, 7/5, 7/6 | 2014-07-06 00:00:00 | 2014-07-10 00:00:00 |  |  |  |  | # 30 Minute Sessions
Kilee | 30 Minute |  | Leo | 1 | 2014-06-27 00:00:00 | 4 | 7/1, 7/3, 7/5, 7/6 | 2014-07-06 00:00:00 | 2014-07-10 00:00:00 |  |  |  |  | # [NAME]
Kilee | 30 Minute |  | New | 3 | 6/27, 6/28, 6/29 | 1 | 2014-07-01 00:00:00 | 2014-07-06 00:00:00 | 2014-07-10 00:00:00 |  |  |  |  | # Hours Office Work
[NAME] | 60 Minute |  | New | 2 | 6/25, 6/27 | 2 | 7/1, 7/4 | 2014-07-06 00:00:00 | 2014-07-10 00:00:00 |  |  |  |  | # [NAME]
Ceci | 45 Minute |  | New | 2 | 6/25, 6/27 | 2 | 7/1, 7/6 | 2014-07-06 00:00:00 | 2014-07-10 00:00:00
New Hire | 45 Minute |  | New | 2 | 6/24, 6/28 | 2 | 7/1, 7/6 | 2014-07-06 00:00:00 | 2014-07-20 00:00:00
New Hire | 60 Minute |  | New | 3 | 6/23, 6/24, 6/27 | 3 | 7/1, 7/3, 7/6 | 2014-07-06 00:00:00 | 2014-07-20 00:00:00 |  |  |  |  | [NAME] | Total Hours | Total Amount Paid to [NAME]
Ceci | Class |  | New | 4 | 6/23, 6/25, 6/27, 6/29 | 1 | 2014-07-01 00:00:00 | 2014-07-06 00:00:00 | 2014-07-20 00:00:00 |  |  |  |  | Ceci
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Kilee
 |  |  |  |  |  |  |  |  |  |  |  |  |  | New Hire
 |  |  |  |  |  |  |  |  |  |  |  |  |  | New Hire
 |  |  |  |  |  |  |  |  |  |  |  |  |  | New Hire
 |  |  |  |  |  |  |  |  |  |  |  |  |  | New Hire
 |  |  |  |  |  |  |  |  |  |  |  |  |  | New Hire
 |  |  |  |  |  |  |  |  |  |  |  |  |  | New Hire
 |  |  |  |  |  |  |  |  |  |  |  |  |  | New Hire
 |  |  |  |  |  |  |  |  |  |  |  |  |  | New Hire
 |  |  |  |  |  |  |  |  |  |  |  |  |  | New Hire
 |  |  |  |  |  |  |  |  |  |  |  |  |  | New Hire
Spreadsheet: kimberly_watson__20552__imbalsumm0108
Sheet: DEFS

 | 23995 |  | 22051
 | 59687 |  | 10703
Day | Measured | Scheduled | Measured | Scheduled | Totals
1 |  |  | 17879 | 24612
2 |  |  | 15280 | 24612
3 |  |  | 22363 | 24612
4 |  |  | 22522 | 24612
5 |  |  | 25194 | 24612
6 |  |  | 25342 | 24612
7 |  |  | 26046 | 24612
8 | 11 |  | 24733 | 24612
9 | 22 |  | 26013 | 24612
10 | 1 |  | 25516 | 24612
11 |  |  | 25869 | 24612
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30 |  |  |  |  |  |  | CBS Volume | 23995 | 22051
31 |  |  |  |  |  |  |  | -178485 | -80532
 |  |  |  |  |  |  |  |  | 22864 | -24566
2001-07-31 00:00:00 | Balance | -1023166 |  | -496043.34 |  |  |  |  | 20379 | 2979
2001-08-11 00:00:00 | Balance |  |  |  |  |  |  |  | 21459 | 6776
 |  |  |  |  |  |  |  |  | 26357 | 26521
 |  |  |  |  |  |  |  |  | 21544 | 36108
 |  |  |  | Contract # |  |  |  |  | 24532 | 17769
 |  |  |  | 22864 | -58339.66 | Zia
 |  |  |  | 20379 | -51695.87 | Grayco/Artesia
 |  |  |  | 21459 | 10570.56
 |  |  |  | 26357 | 44144.84 | [NAME]
 |  |  |  | 21544 | 61340.16 | [NAME], [NAME]
 |  |  |  | 24532 | -762222.24 | 500211,500212,500219,500230 - Coburn points
 |  |  |  | Duke