tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 16c0646d-9f7b-4557-b1f0-b5748af1739e
Sheet: 20

دوره مالي ششماهه منتهي به 31 خرداد ماه 1390
يادداشتهاي [NAME] مالي
دوره مالي شش ماهه منتهي به 31 خرداد ماه 1390
-10 | داراييهای ثابت مشهود
جدول بهای تمام شده و استهلاک انباشته داراييهای ثابت مشهود به شرح زيراست:
 |  |  |  |  | بهای تمام شده -ريال |  |  |  |  |  |  |  |  |  | استهلاک انباشته -ريال |  |  |  |  |  |  |  |  |  | مبلغ دفتری  -ريال
شرح اقلام |  |  |  |  | مانده در |  | داراييهای اضافه شده |  | داراييهای فروخته |  | نقل و انتقالات و |  | مانده در |  | مانده در |  | استهلاک سال |  | استهلاک انباشته |  | نقل وانتقالات و |  | مانده در |  | مانده در |  | مانده در
 |  |  | یادداشت |  | 1389/09/30 |  | طی سال مالی |  | [NAME] سال مالی |  | سايرتعديلات |  | 1390/03/31 |  | 1389/09/30 |  | مالی |  | دارائيهای [NAME] |  | سايرتغييرات |  | 1390/03/31 |  | 1390/03/31 |  | 1389/12/29
زمين |  |  | 10_1 |  | 1733504656 |  |  |  |  |  | --- |  | 1733504656 |  | 6063021 |  | 125981 |  | 0 |  | --- |  | 6063021 |  |  |  | 1727441635
ساختمان |  |  | 10_2 |  | 6079978127 |  | --- |  | --- |  | --- |  | 6079978127 |  | 3281608920 |  | 105411172 |  | 0 |  | --- |  | 3325499372 |  |  |  | 2798369207
تاسيسات |  |  |  |  | 120255119 |  | 35200000 |  | --- |  | --- |  |  |  | 107522692 |  | 665981 |  | 0 |  | --- |  | 107522692 |  |  |  | 12732427
ماشين آلات وتجهيزات |  |  | 10-3 |  | 42114753780 |  | 1129133000 |  | - |  | --- |  |  |  | 31077423751 |  | 807395702 |  | 0 |  | --- |  | 31864845548 |  |  |  | 11037330029
[NAME] |  |  | 10-4 |  | 13107627370 |  | 986404000 |  | -100595000 |  | --- |  |  |  | 10329950542 |  | 413235163 |  | -95611558 |  | --- |  |  |  |  |  | 2777676828
[NAME] |  |  | 10-5 |  | 9596804960 |  | 2011469000 |  | -9665000 |  | --- |  |  |  | 4002381417 |  | 463645068 |  | -2638839 |  | --- |  | 4463387646 |  |  |  | 5594423543
وسايل نقليه |  |  | 10-6 |  | 15365096410 |  | 412944528 |  | -21271636 |  | --- |  |  |  | 14777950091 |  | 247895211 |  | -21154607 |  | --- |  | 15000356899 |  |  |  | 587146319
دارائی درجریان تکمیل - مهمانسرای مشهد |  |  |  |  | 2770049698 |  | 314008458 |  | --- |  | --- |  |  |  | --- |  | --- |  | --- |  | --- |  | --- |  | 3084058156 |  | 2770049698
دارائی درجریان تکمیل -  انبار خلیج فارس |  |  |  |  | 420000000 |  | 0 |  |  |  |  |  | 420000000 |  |  |  |  |  |  |  |  |  |  |  | 420000000 |  | 420000000
پيش پرداختهای سرمايه ای |  |  |  |  |  |  | 280000000 |  | 0 |  |  |  | 280000000 |  | --- |  | --- |  | --- |  | --- |  | --- |  | 280000000 |  | 823090720
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28548260406
داراييهای ثابت [NAME] خطرات ناشی ازحريق ،سيل،انفجار و زلزله معادل 38/4 ميلياردريال از پوشش بيمه ای برخوردار می باشند.
روش های حسابداری مربوط به تحصيل واستهلاک داراييهای ثابت مشهود دريادداشت شماره (3-3) خلاصه اهم رويه های حسابداری توصيف شده است .
شش دانگ سندساختمان مرکزی بابت بدهی به سازمان خصوصی نزد شرکت گسترش ونوسازی دررهن میباشد .
اسناد مالکِیت 4واحد از ویلاهای [NAME] نز د [NAME] شعبه [NAME] بیست میلیارد تسهیلات بانکی دررهن میباشد .
Spreadsheet: darrell_schoolcraft__7331__imball0203
Sheet: EPFS

 | El Paso/TW Eddy Rec
 | 78093
Day | Measured | Scheduled
1 | 39085 | 35000
2 | 38663 | 35000
3 | 38140 | 35000
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
2002-02-28 00:00:00 |  |  | 100916
2002-03-03 00:00:00
CBS Volume
 |  |  | 93375
Spreadsheet: 820703d1678261349-counting-available-beds-in-a-facility-sample
Sheet: Tabelle1

 | Room | Sex | Name | Infos | Planning |  | Available Beds
 | 1 | m | Mr. [NAME]
 | 2 |  |  |  |  |  | Female
 | 2 | f | Mrs. [NAME] |  |  |  |  | H5 should display the number of available female beds, in this example 1 in Room 2
 | 3
 | 3 |  |  |  |  |  | Male
 | 4 |  |  |  |  |  |  | H8 should display the number of available male beds, in this example 1 in room 4
 | 4 | m | Mr. [NAME]
 | 5 |  |  |  |  |  | Unisex
 | 6 | f | Mrs. [NAME] |  |  |  |  | H11 should display the number of available unisex beds, in this example 5 (room 3, 5, 7)
 | 7
 | 7
 | The ward has 7 rooms with a total of 11 beds.
Spreadsheet: 808092d1670282859-filtered-data-error-excel-help-6
Sheet: Jane

 | Name | Position | State | Clinic | Hiring Manager | Entity | Employment Type | Start Date
 | [NAME] | NER | WA | ERD | [NAME] | 1 | PPT | 2022-09-14 00:00:00
 | [NAME] | NER | WA | ERD | [NAME] | 1 | PFT | 2022-09-05 00:00:00
 | [NAME] | NER | WA | ERD | [NAME] | 1 | PFT | 2022-09-05 00:00:00
 | [NAME] | NER | WA | ERD | [NAME] | 1 | Casual | 2022-10-05 00:00:00
 | [NAME] | NER | WA | ERD | [NAME] | 1 | Fixed Casual | 2022-09-19 00:00:00
 | [NAME] | NER | WA | ERD | [NAME] | 1 | PPT | 2022-09-05 00:00:00
 | Essence Esparza | NER | WA | ERD | [NAME] | 1 | PPT | 2022-10-31 00:00:00
 | [NAME] | NER | WA | ERD | [NAME] | 1 | PFT | 2022-10-31 00:00:00
 | [NAME] | NER | WA | ERD | [NAME] | 1 | PFT | 2022-10-06 00:00:00
Spreadsheet: 672747d1586980908-excel-2016-contain-and-copy-question-sinca
Sheet: Sheet1

H1424 | 18mm | ST22 | LKSP H1424 ST22 [NAME] 18 mm | 003EGH1424ST2218 | IF G2:G99 contains Ax and Bx then copy here | [PHONE] Lamināts 25mm Onix Pelēks U960 ST9
H1733 | 18mm | ST9 | LKSP H1733 ST9 Mainau Bērzs 18 mm | 003EGH1733ST918 | [PHONE] Lamināts 18mm [NAME]  <----- to here if both Ax and Bx apply | [PHONE] Lamināts 25mm [NAME] U156 ST9
H2033 | 18mm | ST19 | LKSP H2033 ST19 [NAME] 18 mm | 003EGH2033ST1918 |  | [PHONE] Lamināts 25mm Ozols Beicēts H3304 ST9 (vecais)
H3326 | 18mm | ST28 | LKSP H3326 ST28 [NAME] ozols 18 mm | 003EGH3326ST2818 |  | [PHONE] Lamināts 25mm Kašmirs U702 ST2
H3395 | 18mm | ST12 | LKSP H3395 ST12 [NAME] 18 mm | 003EGH3395ST1218 |  | [PHONE] Lamināts 18mm Rieksts H3704 ST15 (vecais)
H3430 | 18mm | ST22 | LKSP H3430 ST22 Balta Aland Priede 18 mm | 003EGH3430ST2218 | From here ----> | [PHONE] Lamināts 18mm Kļava H1733 ST9
Spreadsheet: 126025d1319479798-display-rows-that-contains-certain-values-new-microsoft-excel-worksheet
Sheet: Sheet2

ID | probe_id
 |  |  |  | Criteria right now is if column D in Sheet1 is not blank(<>").
 |  |  |  | =IFERROR(INDEX(Sheet1!$A$2:$A$192,SMALL(IF(Sheet1!$D$2:$D$190<>"",ROW(Sheet1!$A$2:$A$190)-1),ROWS($A$1:A1))),"")
Spreadsheet: 173013d1344412359-sum-values-based-on-month-and-product-0a30trial-copy-1-2-
Sheet: Sheet1

 |  |  | Helper Columns |  |  | Budget |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | JAN |  |  | Fruits
 |  |  | You can hide these |  |  | Apple | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | FEB |  |  | Apple
 |  |  |  |  |  | Orange | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | MARTC |  |  | Orange
DATE | Commodity | PRIZE |  |  |  | Grapes | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | APR |  |  | Grapes
2012-06-01 00:00:00 | Apple | 2 |  |  | Annual Epenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | MAY |  |  | Water Melon
2012-06-03 00:00:00 | Orange | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | JUN |  |  | [NAME]
2012-07-08 00:00:00 | Grapes | 2 |  |  | Month | Commodity | Expenses | Above Budget | Below Budget |  |  |  |  |  |  |  |  |  |  |  | 7 | JUL |  |  | Kiwi
2012-07-10 00:00:00 | Water Melon | 5 |  |  |  | Orange |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | AUG
2012-07-16 00:00:00 | [NAME] | 5 |  |  |  | Apple |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | SEPT
2012-07-16 00:00:00 | Kiwi | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | OKT
2012-07-17 00:00:00 | Apple | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | NOV
2012-07-17 00:00:00 | Orange | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | DEC
2012-07-17 00:00:00 | Apple | 3
2012-07-17 00:00:00 | Orange | 5
2012-07-17 00:00:00 | Grapes | 2
2012-07-17 00:00:00 | Water Melon | 2
2012-07-21 00:00:00 | [NAME] | 4.8
2012-07-21 00:00:00 | Kiwi | 4.8
2012-07-22 00:00:00 | Apple | 10 |  |  |  |  | 2 |  | 8
 |  |  |  |  |  |  | 21 | 11
Spreadsheet: 885023d1734432816-track-employees-hourly-using-start-and-end-times-table
Sheet: employees

 | 2024-12-01 00:00:00 | 2024-12-02 00:00:00 | 2024-12-03 00:00:00 | 2024-12-04 00:00:00 | 2024-12-05 00:00:00 | 2024-12-06 00:00:00 | 2024-12-07 00:00:00 | 2024-12-08 00:00:00 | 2024-12-09 00:00:00 | 2024-12-10 00:00:00 | 2024-12-11 00:00:00 | 2024-12-12 00:00:00 | 2024-12-13 00:00:00 | 2024-12-14 00:00:00 | 2024-12-15 00:00:00 | 2024-12-16 00:00:00 | 2024-12-17 00:00:00 | 2024-12-18 00:00:00 | 2024-12-19 00:00:00 | 2024-12-20 00:00:00 | 2024-12-21 00:00:00 | 2024-12-22 00:00:00 | 2024-12-23 00:00:00 | 2024-12-24 00:00:00 | 2024-12-25 00:00:00 | 2024-12-26 00:00:00 | 2024-12-27 00:00:00 | 2024-12-28 00:00:00 | 2024-12-29 00:00:00 | 2024-12-30 00:00:00 | 2024-12-31 00:00:00
employee-1 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00 | 7:00-15:00
employee-2 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00
employee-3 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00
[NAME] | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00 | 23:00-7:00
employee-5 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15 | 15:30-22:15
Spreadsheet: 269966d1381334616-formula-to-add-the-above-number-cell-until-it-finds-0-book-example
Sheet: Sheet1

0
3
6
0
0 |  |  |  | So for example   Cell C5 would = A2 + A3 +A4 +A5 (but no cells above [NAME]) [NAME] would = A6 +A7 (but no cells above A5) Cell C10 would = A6 + A7 + A8 + A9 + A10 (but no cells above A5) Cell C17 would = [NAME] (but no cells above A15)
4
8
3
9
13
10
24
25
24
0
4
7
0
0
0
1
0
0
4
1
Spreadsheet: 035a7e1f-a17d-40a7-916c-2fae4c2c1bb0
Sheet: Data

 | 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 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00
Items to date | 150 | 153 | 163 | 201 | 217 | 230 | 240 | 252 | 287 | 331 | 339 | 348 | 365 | 380 | 397 | 450 | 451 | 495 | 644 | 974 | 1076 | 1361 | 1524 | 1730 | 1887 | 2182 | 2511 | 2597 | 2885 | 2934 | 3080 | 3149 | 3319 | 3466 | 3563 | 3607 | 3684 | 3756 | 3842 | 4017 | 4054 | 4172
Number of new items | X
Percent change | X
Downloads to date | 5029 | 6657 | 8626 | 10405 | 12004 | 13900 | 15916 | 18446 | 21339 | 25062 | 29031 | 33509 | 37137 | 41158 | 45640 | 50226 | 53908 | 58062 | 62237 | 68560 | 75704 | 82737 | 89647 | 98271 | 107420 | 118209 | 133608 | 148800 | 161375 | 169181 | 186242 | 204934 | 221799 | 237645 | 260759 | 277701 | 302185 | 339102 | 378445 | 422419 | 457918 | 493251
Downloads for month
Percent change | X
Total number of participants |  |  | 113 | 135 | 140 | 143 | 156 | 161 | 196 | 226 | 226 | 231 | 238 | 248 | 255 | 269 | 292 | 326 | 350 | 386 | 430 | 491 | 577 | 650 | 711 | 764 | 790 | 848 | 881 | 918 | 950 | 964 | 996 | 1057 | 1097 | 1115 | 1139 | 1160 | 1167 | 1187 | 1220 | 1231
Number of new participants | X | X | X |  | x
Percent change | X | x | x | x | x
Selected Works pages to date | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 43 | 55 | 59 | 65 | 72 | 81 | 83 | 85 | 89 | 91 | 122 | 123 | 125 | 127 | 127 | 127 | 127 | 127 | 127 | 130 | 133 | 131 | 131 | 131 | 131
Number of new SWPs | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
Number of ETDs | 59 | 60 | 63 | 64 | 75 | 75 | 76 | 77 | 94 | 142 | 155 | 158 | 162 | 168 | 173 | 180 | 196 | 215 | 230 | 245 | 300 | 314 | 319 | 377 | 410 | 433 | 454 | 549 | 576 | 601 | 622 | 639 | 665 | 732 | 768 | 789 | 798 | 814 | 822 | 852 | 867 | 877
Percent of ETDs to the whole
ETD downloads to date | 3674 | 4817 | 6152 | 7322 | 8254 | 9211 | 10398 | 11841 | 13534 | 15886 | 18504 | 21415 | 23207 | 25609 | 28254 | 30901 | 32970 | 35403 | 37532 | 40508 | 43707 | 47188 | 50312 | 54149 | 56996 | 60525 | 65577 | 71925 | 76246 | 79559 | 84471 | 90041 | 96931 | 104422 | 112590 | 118722 | 128301 | 143845 | 162125 | 181158 | 195381 | 210737
Percent of downloads that are ETDs
Downloads per item
 | Number for months represent total AT THE END OF THE MONTH
Spreadsheet: 175847d1345655212-excel-2007-find-first-and-last-in-a-series-find-2nd
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Aug 2009 | Jan/Apr 2010 | Aug 2010 | 2010-12-01 00:00:00 | 2011-04-01 00:00:00 | 2011-08-01 00:00:00 | 2011-12-01 00:00:00 | 2012-04-01 00:00:00 | 2012-08-01 00:00:00 |  | First | Second | Last
 |  |  |  |  |  |  |  |  |  |  |  | - | 1064 | 1463 | 1477 | - | - | - | - | -
 |  |  |  |  |  |  |  |  |  |  |  | - | 926 | 1298 | 1303 | - | - | - | - | -
 |  |  |  |  |  |  |  |  |  |  |  | 663 | 1135 | 1905 | 2377 | 2838 | 3263 | 3401 | 3823 | 3959
 |  |  |  |  |  |  |  |  |  |  |  | - | 717 | 1355 | 1410 | 1417 | - | - | - | -
 |  |  |  |  |  |  |  |  |  |  |  | - | 1198 | 1511 | 1516 | - | - | - | - | -
 |  |  |  |  |  |  |  |  |  |  |  | - | 962 | 1086 | - | - | - | - | - | -
 |  |  |  |  |  |  |  |  |  |  |  | - | 863 | 1526 | 1608 | 1620 | - | - | - | -
 |  |  |  |  |  |  |  |  |  |  |  | - | 533 | 780 | 788 | - | - | - | - | -
 |  |  |  |  |  |  |  |  |  |  |  | 317 | 807 | 1197 | 1243 | 1256 | - | - | - | -
Spreadsheet: 749707d1632975761-how-to-find-top-5-values-from-data-using-function-test
Sheet: Data

Name | Value
Norfolk | 10
Newark | 2
England | 14
NZ | 10
SA | 9
ZIM | 1
Pur | 3
USA | 1
Canada | 1
Belgium | 9
Spreadsheet: 784361d1655693891-conditional-formattiog-dynamic-calendar-conditional_formatting
Sheet: CALENDAR

 |  |  |  |  | CALENDAR FOR: |  |  |  |  |  |  |  |  |  | 2022
 |  |  | JANUARY |  |  |  |  |  |  |  | FEBRUARY |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | APRIL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JANUARY
 |  |  | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN |  |  |  |  |  |  |  |  |  | MON | TUE | WED | THU | FRI | SAT | SUN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | conditional formatting show only dates from 01 Jan to 31 Jan
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | conditional formatting highlight public holidays (list Intercalculation M12:M22)
 |  |  | MAY |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | JULY |  |  |  |  |  |  |  | AUGUST
 |  |  | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN
 |  |  | SEPTEMBER |  |  |  |  |  |  |  | OCTOBER |  |  |  |  |  |  |  | NOVEMBER |  |  |  |  |  |  |  | DECEMBER
 |  |  | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN
Spreadsheet: 760187d1640040488-help-with-multiple-formulas-for-inventory-tracking-inventory_sales2022
Sheet: January Inventory

January Inventory
Date | GRO | GRO+ | Sani32K | [NAME] | Sani64K | Oly32K | Oly48K | Evolv32K | Evolv48K
2022-01-01 00:00:00 | 20 | 20 | 10 | 10 | 10 | 10 | 10 | 2 | 2
2022-01-02 00:00:00
2022-01-03 00:00:00
2022-01-04 00:00:00
2022-01-05 00:00:00
2022-01-06 00:00:00
2022-01-07 00:00:00
2022-01-08 00:00:00
2022-01-09 00:00:00
2022-01-10 00:00:00
2022-01-11 00:00:00
2022-01-12 00:00:00
2022-01-13 00:00:00
2022-01-14 00:00:00
2022-01-15 00:00:00
2022-01-16 00:00:00
2022-01-17 00:00:00
2022-01-18 00:00:00
2022-01-19 00:00:00
2022-01-20 00:00:00
2022-01-21 00:00:00
2022-01-22 00:00:00
2022-01-23 00:00:00
2022-01-24 00:00:00
2022-01-25 00:00:00
2022-01-26 00:00:00
2022-01-27 00:00:00
2022-01-28 00:00:00
2022-01-29 00:00:00
2022-01-30 00:00:00
2022-01-31 00:00:00
Spreadsheet: 6263c4bb-6cb5-46d8-a66c-471cd878254d
Sheet: SW915

SW | SUV | PS# | Ln | Item | Description | UOM | $ | Cat | Cat Desc
SW915 | SCI | 3021 | 1 |  |  |  | 13.11 |  | Underpants
SW915 | SCI | 3021 | 2 |  |  |  | 13.11 |  | Underpants
SW915 | SCI | 3021 | 3 |  |  |  | 18.29 |  | Underpants
SW915 | SCI | 3021 | 4 |  |  |  | 32.78 |  | Brassieres
SW915 | SCI | 3021 | 5 |  |  |  | 41.5 |  | Brassieres
SW915 | SCI | 3021 | 6 |  |  |  | 41.5 |  | Brassieres
SW915 | SCI | 3021 | 7 |  |  |  | 250 |  | Brassieres
SW915 | SCI | 3021 | 8 |  |  |  | 250 |  | Brassieres
SW915 | SCI | 3021 | 9 |  |  |  | 250 |  | Brassieres
SW915 | SCI | 3021 | 10 |  |  |  | 258.5 |  | Brassieres
SW915 | SCI | 3021 | 11 |  |  |  | 250 |  | Brassieres
SW915 | SCI | 3021 | 12 |  |  |  | 228.47 |  | Brassieres
SW915 | SCI | 3021 | 13 |  |  |  | 13.5 |  | Underpants
SW915 | SCI | 3021 | 14 |  |  |  | 13.5 |  | Underpants
SW915 | SCI | 3021 | 15 |  |  |  | 13.5 |  | Underpants
SW915 | SCI | 3021 | 16 |  |  |  | 13.5 |  | Underpants
SW915 | SCI | 3021 | 17 |  |  |  | 15 |  | Underpants
SW915 | SCI | 3021 | 18 |  |  |  | 16.5 |  | Underpants
SW915 | SCI | 3021 | 19 |  |  |  | 14.35 |  | Underpants
Spreadsheet: 718619d1613238190-revenue-based-tiered-commission-formula-revenue-based-tiered-commission-
Sheet: Revenue Report Feb 12th

Day/ Date | Friday, February 12th 2021
[NAME] | Item | [NAME] | [NAME] | Amount | Sharing | Description
1 | Net Sales |  |  | 5540 |  | Net Sales Achieved
2 | [NAME] | 0 | 2700 | 2700 |  | Threshold at $2,700
 | 0% of Tier 1 |  |  |  |  | 0% of $0 - $2,700
3 | [NAME] | 2701 | 5999
 | 15% of Tier 2 |  |  |  |  | 15% of [NAME] 3
4 | Tier 3 | 5999 | 7999
 | 20%  of Tier 3 |  |  |  |  | 20% of [NAME]
7 | Amount to be Paid |  |  |  |  | [NAME], 5 and 6
We are paying out commission based on revenue reached, table as per below. Having difficulties doing the calculation. Logically I understand that I have to manually substract whatever is after $2700 but only UNTIL $5,999 but I want to have a formula that does it for me and changes based on my Net Sales, and the same for Tier 3.
 | Table
 | Amount | Percentage
 | $0- $2,700 | 0
 | $2,701-$5,999 | 0.15
 | $6,000-$7,999
Spreadsheet: 544689d1509002787-formula-required-to-extrapolate-values-test-excel-forum
Sheet: Sheet7

 |  | Company A |  | Company B |  | Company C |  | Company D
 |  | City 1 | City 2 | City 1 | City 2 | City 1 | City 2 | City 1 | City 2
 | 2017-10-01 00:00:00
 | 2017-10-02 00:00:00
 | 2017-10-03 00:00:00
 | 2017-10-04 00:00:00
 | 2017-10-05 00:00:00
 | 2017-10-06 00:00:00
 | 2017-10-07 00:00:00
 | 2017-10-08 00:00:00
 | 2017-10-09 00:00:00
 | 2017-10-10 00:00:00
Spreadsheet: 76552d1277114168-printing-hyperlinks-content-pdf-exsample-hyperlinks
Sheet: Sheet1

ID | NAME | KEYWORD | LINK 1 | LINK 2 | LINK 3
1 | 84569 | 1 | TEST1.PDF | TEST3.PDF | TEST5.PDF
2 | 54267 | 3 | TEST6.PDF | TEST4.PDF | TEST6.PDF
3 | 34582 | 1 | TEST3.PDF | TEST1.PDF | TEST1.PDF
4 | 31543 | 3 | TEST6.PDF | TEST4.PDF | TEST4.PDF
5 | 11547 | 1 | TEST3.PDF | TEST4.PDF | TEST1.PDF
6 | 48562 | 1 | TEST2.PDF | TEST3.PDF | TEST5.PDF
7 | 75648 | 2 | TEST2.PDF | TEST6.PDF | TEST1.PDF
8 | 81546 | 2 | TEST1.PDF | TEST9.PDF | TEST3.PDF
Spreadsheet: 845334d1696864207-filter-by-column-and-by-row-competence-matrix-filter-updated1
Sheet: Sheet2

 | Management |  |  |  | Operational |  |  |  | Technical |  |  |  | Languages |  |  |  | Solution Control
Name/skill | Business Dev | [NAME] | Project Manager | PMO | Finance | Manufacturing | Supply chain | Human Resources | Configuration | Lobbies | Data Migration | Developer | Dutch | English | French | German | Solution Architect | Process Design | [NAME] | ClickLearn
Marian | X |  |  | X | C | C | X | C |  | X |  | C |  | X |  | X
George | x |  | X | C | X | X | X | C | X |  | X | C | X |  | X | X | C | X |  | C
Alina |  | X | X |  | X |  | X | C |  |  |  |  |  | X
Radu |  |  | X |  |  |  | C | C |  | C |  |  | X |  |  | X |  |  | C
Cristian |  |  | C | C |  | X | C | C |  |  | C | X |  | X | X |  |  | C |  | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
 | Management |  |  | Operational |  |  | Technical |  |  | Languages |  |  | Solution |  |  | Certified
 | Business Dev | False |  | Finance | False |  | Configuration | True |  | Dutch | False |  | Solution Architect | False |  | C
 | [NAME] | False |  | Manufacturing | False |  | Lobbies | False |  | English | False |  | Process Design | True |  | X
 | Project Manager | True |  | Supply chain | True |  | Data Migration | False |  | French | True |  | [NAME] | False
 | PMO | False |  | Human Resources | False |  | Developer | False |  | German | False |  | ClickLearn | True