tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 83767d1283810881-averages-and-vlookup-solution-book1
Sheet: Sheet1

 |  | TALBE OF "C" VALUES
 |  | Intensity | [NAME] (fi) |  |  |  |  |  |  |  |  |  |  |  | [NAME] (fi) |  | 0
 |  | (mm/hr) | 0 | 0.2 | 0.4 | 0.6 |  | 0.8 | 0.9 | 1
 |  | 39 | REFER ADDITIONAL TABLE. | 0.44 | 0.55 | 0.67 |  | 0.78 | 0.84 | 0.9 |  |  |  |  | INTENSITY (mm/hr) |  | 55
 |  | 45 |  | 0.49 | 0.6 | 0.7 |  | 0.8 | 0.85 | 0.9
 |  | 50 |  | 0.55 | 0.64 | 0.72 |  | 0.81 | 0.86 | 0.9 |  |  |  |  | "C" Value |  | Refer additional table
 |  | 55 |  | 0.6 | 0.68 | 0.75 |  | 0.83 | 0.86 | 0.9
 |  | 60 |  | 0.65 | 0.72 | 0.78 |  | 0.84 | 0.87 | 0.9
 |  | 65 |  | 0.71 | 0.76 | 0.8 |  | 0.85 | 0.88 | 0.9
 |  | 70 |  | 0.74 | 0.78 | 0.82 |  | 0.86 | 0.88 | 0.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Additional input | REQUIRED
 |  | TALBE OF "C" VALUES for ZERO FRACTION IMPERVIOUS (fi)
 |  | LAND DESCRIPTION | (1) Dense bushland |  |  |  | Medium density [NAME] or |  |  |  | Light cover bushland,or
 |  |  |  |  |  | (2) | Goog grass cover, or |  |  | (3) | Poor grass cover, or
 |  |  |  |  |  |  | High density pasture, or |  |  |  | Low density pature, or |  |  |  | [NAME] (1, 2 OR 3) |  | 1 |  | 1 | *=IF(R7="Refer additional table",IF(R21=1,INDEX(D25:F31,MATCH(LOOKUP(R5,C25:C31),C25:C31,0),MATCH(LOOKUP(R23,D24:F24),D24:F24,0))))
 |  |  |  |  |  |  | Zero tillage cropping |  |  |  | Low cover bare fallows |  |  |  |  |  |  |  | 2 | *=IF(R7="Refer additional table",IF(R21=2,INDEX(G25:J31,MATCH(LOOKUP(R5,C25:C31),C25:C31,0),MATCH(LOOKUP(R23,G24:J24),G24:[NAME]))))
 |  | Intensity | Soil permeability |  |  | Soil permeability |  |  |  | Soil permeability |  |  |  |  | Soil permeability |  | LOW |  | 3 | *=IF(R7="Refer additional table",IF(R21=3,INDEX(K25:N31,MATCH(LOOKUP(R5,C25:C31),C25:C31,0),MATCH(LOOKUP(R23,K24:N24),K24:N24,0))))
 |  | (mm/hr) | HIGH | MEDIUM | LOW | HIGH |  | MEDIUM | LOW | HIGH |  | MEDIUM | LOW
 |  | 39 | 0.08 | 0.24 | 0.32 | 0.16 |  | 0.32 | 0.4 | 0.24 |  | 0.4 | 0.48 |  | C Value |  | 0.13
 |  | 45 | 0.1 | 0.29 | 0.39 | 0.2 |  | 0.39 | 0.49 | 0.29 |  | 0.49 | 0.59
 |  | 50 | 0.12 | 0.35 | 0.46 | 0.23 |  | 0.46 | 0.58 | 0.35 |  | 0.58 | 0.69
 |  | 55 | 0.13 | 0.4 | 0.53 | 0.27 |  | 0.53 | 0.66 | 0.4 |  | 0.66 | 0.7
 |  | 60 | 0.15 | 0.44 | 0.59 | 0.3 |  | 0.59 | 0.7 | 0.44 |  | 0.7 | 0.7
 |  | 65 | 0.17 | 0.5 | 0.66 | 0.33 |  | 0.66 | 0.7 | 0.5 |  | 0.7 | 0.7
 |  | 70 | 0.18 | 0.53 | 0.7 | 0.35 |  | 0.7 | 0.7 | 0.53 |  | 0.7 | 0.7
 |  |  |  |  | I need to complete the formula in cell R25 similar to the R7 formula supplied by zbor
 |  |  |  |  | I have partially completed individual formulars for each land description (1, 2 & 3) but can't get it to refence the "high","medium" or "low" properlly
 |  |  |  |  | also, I then need to put each formula tegother
 |  |  |  |  |  |  | : INDICATES USER INPUT
Spreadsheet: 175372d1345503397-formula-to-lookup-and-sum-items-with-same-refrence-number-lookup-and-sum-item-with-same-refrence-numbers
Sheet: Sheet1

Item |  | AmT. | Selling
Num # | Item Name | Sold | Price
8030 | Large Pepsi | 72 | 90.13
8030 | Large Pepsi | 18 | 0
8060 | Large Grape | 32 | 90.13
8060 | Large Grape | 22 | 0
8050 | Large Cola | 55 | 0
8050 | Large Cola | 70 | 90.13
8050 | Large Cola | 20 | 0
8050 | Large Cola | 10 | 90.13
8050 | Large Cola | 40 | 90.13
8030 | Large Pepsi | 10 | 90.13
8030 | Large Pepsi | 100 | 0
8060 | Large Grape | 10 | 90.13
9000 | Large Beer | 50 | 0
9000 | Large Beer | 150 | 90.13
9000 | Large Beer | 30 | 90.13
 | Total Sold
Item Name | with sell price greater than Zero
Large Pepsi | 0
Large Grape | 0
Large Cola | 0
Large Beer | 0
Spreadsheet: 0e4171bf-82e0-4675-8eb9-14a0897d224c
Sheet: Sheet1

Release: BEA Regions Employment and Unemployment | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=138
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2013-05-23 11:53 AM [NAME]
 | Real-Time | Period
Name: | Start | End
BEA Regions Employment and Unemployment | 2007-07-20 00:00:00 | Current
Source:
Federal Reserve Bank of St. Louis | 2007-07-20 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2007-07-20 00:00:00
2007-08-17 00:00:00
2007-09-25 00:00:00
2007-10-19 00:00:00
2007-11-28 00:00:00
2007-12-21 00:00:00
2008-01-18 00:00:00
2008-03-11 00:00:00
2008-03-28 00:00:00
2008-04-18 00:00:00
2008-05-16 00:00:00
2008-06-20 00:00:00
2008-07-18 00:00:00
2008-08-15 00:00:00
2008-09-19 00:00:00
2008-10-21 00:00:00
2008-11-21 00:00:00
2008-12-19 00:00:00
2009-01-27 00:00:00
2009-02-27 00:00:00
2009-03-11 00:00:00
2009-03-27 00:00:00
2009-04-17 00:00:00
2009-05-22 00:00:00
2009-06-19 00:00:00
2009-07-17 00:00:00
2009-08-21 00:00:00
2009-09-18 00:00:00
2009-10-21 00:00:00
2009-11-20 00:00:00
2009-12-18 00:00:00
2010-01-22 00:00:00
2010-03-10 00:00:00
2010-03-26 00:00:00
2010-04-16 00:00:00
2010-05-21 00:00:00
2010-06-18 00:00:00
2010-07-20 00:00:00
2010-08-20 00:00:00
2010-09-21 00:00:00
2010-10-22 00:00:00
2010-11-23 00:00:00
2010-12-17 00:00:00
2011-01-25 00:00:00
2011-03-10 00:00:00
2011-03-25 00:00:00
2011-04-19 00:00:00
2011-05-20 00:00:00
2011-06-17 00:00:00
2011-07-22 00:00:00
2011-08-19 00:00:00
2011-09-16 00:00:00
2011-10-21 00:00:00
2011-11-22 00:00:00
2011-12-20 00:00:00
2012-01-24 00:00:00
2012-03-13 00:00:00
2012-03-30 00:00:00
2012-04-20 00:00:00
2012-05-18 00:00:00
2012-06-15 00:00:00
2012-07-20 00:00:00
2012-08-17 00:00:00
2012-09-21 00:00:00
2012-10-19 00:00:00
2012-11-20 00:00:00
2012-12-21 00:00:00
2013-01-18 00:00:00
2013-03-18 00:00:00
2013-03-29 00:00:00
2013-04-19 00:00:00
2013-05-17 00:00:00
Spreadsheet: 763595d1642261305-average-formula-for-unconventional-data-year-months-average
Sheet: Sheet1

Years/Months | Years/Months | Average
6/4 | 7/4
6/5 | 6/10
5/12 | 6/10
6/2
6/4 | 6/11
6/4 | 7/2
Spreadsheet: 673496d1587407903-help-with-sumifs-calculating-between-a-date-range-and-another-argument-ledger-project
Sheet: Ledger

Date | Income | Expense | Type | Description | Report Category | Remarks
2019-01-02 00:00:00 |  | 60 | [NAME] | CK 2418-Quarters for Bingo | Expenditure 2 - Veteran's Issues
2019-01-03 00:00:00 |  | 642 | Check | CK 2419-Jebs Designs | Income 3 - Product Donations
2019-01-17 00:00:00 |  | 50 | Debit Card | stamp for chapter | Expenditure 11 - Postage
2019-01-22 00:00:00 |  | 21.05 | Debit Card | earthlink | Expenditure 6 - NewsLetter/Web Site
2019-01-23 00:00:00 |  | 66.17 | Debit Card | walmart | Expenditure 10- Office Supplies
2019-01-24 00:00:00 | 53.49 |  | Deposit | square | Income 1 - Dues paid by Members
2019-02-15 00:00:00 |  | 60 | [NAME] | va bingo | Expenditure 2 - Veteran's Issues
2019-02-26 00:00:00 | 836 |  | Deposit | CK # 2425 Menbership dues | Income 1 - Dues paid by Members
2019-03-04 00:00:00 |  | 150 | [NAME] | freedom church for booth | Expenditure 16 - Donations made by Chapter
2019-03-05 00:00:00 |  |  | Debit Card | kings sign | Expenditure 3 - Chapter Products
2019-03-21 00:00:00 | 57.83 |  | Deposit | square | Income 2 - Fundraising Revenue
2019-03-22 00:00:00 | 43.23 |  | Deposit | square | Income 2 - Fundraising Revenue
2019-03-30 00:00:00 | 100 |  | Deposit | donation to chapter | Income 2 - Fundraising Revenue
2019-03-30 00:00:00 | 20 |  | Deposit | chapter product | Income 2 - Fundraising Revenue
2019-03-30 00:00:00 | 390 |  | Deposit | national dues | Income 1 - Dues paid by Members
2019-04-02 00:00:00 |  | 60 | Check | Ck # 2423 [NAME] (bingo) | Expenditure 2 - Veteran's Issues
2019-04-02 00:00:00 |  | 106.99 | Check | Ck # 2424 office 360 [NAME] | Expenditure 10- Office Supplies
2019-04-15 00:00:00 |  | 29 | Debit Card | ghozylab | Expenditure 6 - NewsLetter/Web Site
2019-04-25 00:00:00 |  | 43.81 | Check | ck #2426 [NAME] (bunker) | Expenditure 2 - Veteran's Issues
2019-04-26 00:00:00 |  | 100 | Check | ck # 2428 [NAME] (brick) | Expenditure 2 - Veteran's Issues
Spreadsheet: 145956d1331830045-finding-a-value-within-two-different-ranges-template
Sheet: Formula result

status | week |  |  |  | commentaire
On-Call | 9 |  |  |  | robert.germain, jeanf.mongrain
Night Shift | 10 |  |  |  | x
On-Call | 8 |  |  |  | dave.richard,luc.ladouceur
Vacance | 12 |  |  |  | x
On-Call | 10 | 40980
On-Call | 11 | 40980 | 8h00 | E1740
Completed | 3
On-Call | 12 | 40980 | 8h00 | E1758
On-Call | 1 | 40980 | 8h00 | E1958
On-Call | 2 | 40980 | 8h00 | E1958
On-Call | 3
On-Call | 4 | 40981 | 10h00 | E1758
On-Call | 5 | 40981 | 10h00 | E0170
On-Call | 6
On-Call | 7 | 40982 | 00h01 | E5368
Spreadsheet: 759217d1639426106-generating-multiple-arrays-inside-array-array_issue
Sheet: Array

[NAME] |  | This Array Formula
[NAME] |  |  | → | ROW(INDIRECT("1:"&LEN(A1)))
Shank |  | Results into {1,2,3,4} |  | Ctrl + Shift + Enter
Sid
[NAME]
[NAME] |  | Now
 |  |  | → | LEN(A1:A6)
 |  | Returns {4;7;5;3;6;5} |  | Ctrl + Shift + Enter
 |  | Combining those two formula
 |  |  |  | ROW(INDIRECT("1:"&LEN(A1:A6)))
 |  |  |  | Ctrl + Shift + Enter
 |  |  |  | Doesn't return desired result
 |  |  |  | DESIRED RESULT
 |  |  |  | {1,2,3,4;1,2,3,4,5,6,7;1,2,3,4,5;1,2,3;1,2,3,4,5,6;1,2,3,4,5}
Spreadsheet: 864329d1711546439-how-can-i-enhance-this-sumproduct-formula-to-only-counts-cells-greater-than-zero-sumproduct-question-2-
Sheet: SUMPRODUCT Question

Year | 2023 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2025 | 2025 | 2025 | 2025
Month | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00
Users | 25 |  | 26 | 21 | 29 | 34 | 33 | 35 | 31 | 27 | 27 | 25 | 23 | 22 | 27 | 29 | 31
Hours | 501 |  | 612 | 574 | 773 | 809 | 768 | 811 | 809 | 639 | 622 | 611 | 634 | 620 | 799 | 632 | 733
Avg of Monthly Hours
Year Selected ([NAME]) | 2024 |  |  |  |  |  |  | Average
Spreadsheet: 886744d1736857063-pulling-a-list-of-values-based-on-two-conditions-spesifikasyon
Sheet: Hata Tanımları

Hata No | Hata - Turkish | Defect - English | Hata Tipi | Proses
1 | Yanık | Burn | Major | Enjeksiyon
2 | Kabarcık/Habbe | Bubble | Minor | Pet-Şişirme
3 | İtici İzleri | Thrust Traces | Minor | Enjeksiyon
4 | Gramaj Ağır/Hafif | Weight Heavy-Light | Major | Enjeksiyon-Pet-Şişirme
5 | Sızdırma | Leakage | Critical | Pet-Şişirme
6 | Delik | Hole | Critical | Pet-Şişirme
7 | Katlanma | Folding | Minor | Enjeksiyon-Pet-Şişirme
8 | [NAME] | Dirty Ware | Minor | Enjeksiyon-Pet-Şişirme
9 | Pürüz | Rough | Minor | Enjeksiyon-Pet-Şişirme
10 | Dalgalı Görünüş | Washboard | Minor | Enjeksiyon-Pet-Şişirme
11 | [NAME] | Mold seam | Minor | Enjeksiyon-Pet-Şişirme
12 | [NAME] | [NAME] | Minor | Enjeksiyon-Pet-Şişirme
13 | İnce Dip | Thin ware | Minor | Pet-Şişirme
14 | [NAME] | Thick or heavy bottom | Minor | Pet-Şişirme
15 | Çapak | Burr | Minor | Enjeksiyon-Pet-Şişirme
16 | [NAME] | Ovality | Major | Enjeksiyon-Pet-Şişirme
17 | [NAME] | Missing print | Major | Enjeksiyon-Pet-Şişirme
18 | Etiket Hatası (Ters, Kaymış, Yanlış) | [NAME] | Minor | Enjeksiyon
19 | Barkod Etiket Hatası | [NAME] | Critical | Enjeksiyon-Pet-Şişirme
20 | Eğri (Kafa, Boyun, Gövde) | Curve (Finis, Neck, Body) | Minor | Pet-Şişirme
21 | Göçük | [NAME] | Minor | Pet-Şişirme
22 | Şiş Gövde/ Geniş çap | Bulged sides | Major | Pet-Şişirme
23 | Dip Oturmazlığı | Rocker bottom | Major | Pet-Şişirme
24 | Kontaminasyon | Contamination | Critical | Enjeksiyon-Pet-Şişirme
25 | [NAME] baskısı | Indistiınct serigraphy | Minor | Serigrafi
26 | Menteşe kopması | Hinge break | Major | Enjeksiyon
27 | Ezik | Crushed | Major | Enjeksiyon-Pet-Şişirme
28 | Şekil dışı | Freaks | Critical | Enjeksiyon-Pet-Şişirme
29 | [NAME] | Wounded mold | Major | Enjeksiyon-Pet-Şişirme
30 | [NAME] | Lock failure | Major | Enjeksiyon
31 | [NAME] | [NAME] isagreement | Major | Enjeksiyon-Pet-Şişirme
32 | [NAME] | Mold sweating | Minor | Şişirme
33 | [NAME] | Volume Inconsistency | Major | Pet-Şişirme
34 | Dar / Geniş Ağız | Undersized-Oversized bore | Major | Pet-Şişirme
35 | [NAME] | Packaging defects | Minor | Enjeksiyon-Pet-Şişirme
36 | [NAME] | Gasket- Foil defect | Minor | Enjeksiyon
37 | [NAME] hatası | Bore neatness | Major | Pet-Şişirme
38 | Çarpık | Crooked | Major | Enjeksiyon-Pet-Şişirme
39 | [NAME] | Split | Major | Enjeksiyon-Pet-Şişirme
40 | [NAME] | Scratch | Minor | Enjeksiyon-Pet-Şişirme
41 | Görsel Hata | Visual defects | Minor | Enjeksiyon-Pet-Şişirme
42 | İnce Cidar | Thin | Major | Pet-Şişirme
43 | Kırık | [NAME] | Major | Enjeksiyon-Pet-Şişirme
44 | Ölçüsel Hata | Dimensional defects | Major | Enjeksiyon-Pet-Şişirme
45 | Boy Kısa/ Uzun | [NAME] | Major | Enjeksiyon-Pet-Şişirme
46 | [NAME] | Colour defects | Major | Enjeksiyon-Pet-Şişirme
47 | [NAME] | Sleeve defects | Minor | Serigrafi
48 | [NAME] | Printing defects | Minor | Serigrafi
49 | [NAME] (ağızda) | Split lap (or fold) marks | Critical | Pet-Şişirme
50 | İpliklenme | Threading | Minor | Enjeksiyon-Pet-Şişirme
Spreadsheet: 849039d1699608379-sorting-data-and-labelling-data-and-preserving-the-labelling-for-other-data-sets-example-for-forum-10-nov-
Sheet: DATA

 |  | First | Second | Third | Fourth | Fifth
Publication 1 |  | An apparatus | An apparatus | A metrology tool | A lithographic apparatus | A litho cell
Publication 2 |  | An apparatus | An apparatus | A metrology tool | A lithographic apparatus | A litho cell
Publication 3 |  | A reticle stage | A lithographic apparatus | A lithographic system | A method of operating an EUV lithographic apparatus
Publication 4 |  | A reticle stage | A lithographic apparatus | A lithographic system | A method of operating an EUV lithographic apparatus
Publication 5 |  | A method for improving a nuisance rate | A system | A non-transitory computer readable medium storing …
Publication 6 |  | A height measurement sensor | A lithographic apparatus | An assessment system | A metrology system | A method for determining a focus plane
Publication 7 |  | A method for cleaning | A system | A system
Publication 8 |  | A membrane | A membrane | A pellicle | A patterning device and pellicle assembly | A lithographic apparatus
..
List continues >900
Spreadsheet: 832028d1686069683-populate-table-based-on-other-tables-values-foster-closet
Sheet: Boys

 |  | Boys
 |  | Item | Size/Type | Brand | Location
 |  | Footwear
 |  | Tennis Shoes/Sneakers | 3 T |  |  | User will select item from drop down list, and select size from drop down list. These totals auto sum on the 'List Data' tab.
 |  | Socks
 |  | Tall | Teen
 |  | Pants
 |  | Jeans | 2T
 |  | Shorts
 |  | Shirts
 |  | Sweatshirts
 |  | [NAME]
 |  | Jackets
 |  | Hats
 |  | Toys
Spreadsheet: 27e1dbf7-f1c1-411a-b889-7c91ea7ccb53
Sheet: 7a

Product1 | Cleared2 | Uncleared | TOTAL
Fixed-Float | 115485665 | 67454812
FRA | 50111996 | 5859118
OIS | 26703509 | 6565346
Swaption | - | 16876174
OTHER* | 5599885 | 24828166
TOTAL
* OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: 721453d1614711926-return-a-value-from-multiple-excel-sheets-into-one-excel-sheet-lc3p-7a048-ae-warranty-issue_c561g21050102972lc3p-7a048-ae
Sheet: Report

 | Calypso Measuring Result
 | Measurement Plan |  | Date |  | Order
 | LC3P-7A048-AE WARRANTY ISSUE |  | 2021-02-22 00:00:00 |  | WARRANTY ISSUE - BOB -N- WOW
 | Drawing No. |  | Time |  | Part No.
 |  |  | 01:55:33 |  | C561G21050102972LC3P 7A048 AE
 | Operator |  | CMM
 | Master
Characteristic | Actual | Nominal | Upper Tol | Lower Tol | Deviation
T19 at 12 clock | 0.1206953 | 0 | 0.175 | 0 | 0.1206953
T19 at 6 clock | 0.1514676 | 0 | 0.175 | 0 | 0.1514676
T19 at 3 clock | 0.1384648 | 0 | 0.175 | 0 | 0.1384648
T19 at 9 clock | 0.1882103 | 0 | 0.175 | 0 | 0.1882103
T263  Flat Spider 12oclk | 0.0632853 | 0 | 0.075 | 0 | 0.0632853
T263  Flat Spider 3oclk | 0.0575302 | 0 | 0.075 | 0 | 0.0575302
T263  Flat Spider 6oclk | 0.0822815 | 0 | 0.075 | 0 | 0.0822815
T263  Flat Spider 9oclk | 0.054208 | 0 | 0.075 | 0 | 0.054208
Spreadsheet: 802286d1666772580-display-and-count-values-in-an-array-that-do-not-match-values-another-array-display_count_unmatches_v2-aligw
Sheet: Feuil1

 | UNMATCHES:
 |  | (expected result)
 | list |  |  |  |  | authorized_values
 | black |  |  |  |  | green
 | black |  |  |  |  | white
 | black |  |  |  |  | light
 | black |  |  |  |  | yellow
 | transparent |  |  |  |  | transparent
 | gray,white |  |  |  |  | gray
 | white |  |  |  |  | red
 | white |  |  |  |  | [NAME]
 | light,yellow
 | dark,gray,black
 | black
 | white
 | black
 | black
 | green
 | red
 | red,brown
Spreadsheet: 762932d1641910845-cond-formatting-first-monday-on-the-month-sddo-vacation-tracker-2023
Sheet: Mar

Formation /Training
Congés / Leaves | V
Congés fériés / GC holidays
Fin de semaine / Weekend
T:  Tentative | T
Compressed Day / Journée comprimée
Assignment / Left
Half Day / Demie Journée
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
March | Dates of Leave |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023
03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Vacation
Employee Name | 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 |  | Replaced by:
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
(Vacant CS-03)
[NAME]
[NAME]
[NAME]
(Vacant team lead)
(Vacant CS-03)
Sameer [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
March Total
Spreadsheet: 78829d1279129212-sum-several-worksheets-in-same-workbook-tech-attendance
Sheet: ATTENDANCE Nov thru Jan

Last Name | First Name | Tech ID | Vacation | Personal | Sick | 2010-11-01 00:00:00 | 2010-11-02 00:00:00 | 2010-11-03 00:00:00 | 2010-11-04 00:00:00 | 2010-11-05 00:00:00 | 2010-11-06 00:00:00 | 2010-11-07 00:00:00 | 2010-11-08 00:00:00 | 2010-11-09 00:00:00 | 2010-11-10 00:00:00 | 2010-11-11 00:00:00 | 2010-11-12 00:00:00 | 2010-11-13 00:00:00 | 2010-11-14 00:00:00 | 2010-11-15 00:00:00 | 2010-11-16 00:00:00 | 2010-11-17 00:00:00 | 2010-11-18 00:00:00 | 2010-11-19 00:00:00 | 2010-11-20 00:00:00 | 2010-11-21 00:00:00 | 2010-11-22 00:00:00 | 2010-11-23 00:00:00 | 2010-11-24 00:00:00 | 2010-11-25 00:00:00 | 2010-11-26 00:00:00 | 2010-11-27 00:00:00 | 2010-11-28 00:00:00 | 2010-11-29 00:00:00 | 2010-11-30 00:00:00 | 2010-12-01 00:00:00 | 2010-12-02 00:00:00 | 2010-12-03 00:00:00 | 2010-12-04 00:00:00 | 2010-12-05 00:00:00 | 2010-12-06 00:00:00 | 2010-12-07 00:00:00 | 2010-12-08 00:00:00 | 2010-12-09 00:00:00 | 2010-12-10 00:00:00 | 2010-12-11 00:00:00 | 2010-12-12 00:00:00 | 2010-12-13 00:00:00 | 2010-12-14 00:00:00 | 2010-12-15 00:00:00 | 2010-12-16 00:00:00 | 2010-12-17 00:00:00 | 2010-12-18 00:00:00 | 2010-12-19 00:00:00 | 2010-12-20 00:00:00 | 2010-12-21 00:00:00 | 2010-12-22 00:00:00 | 2010-12-23 00:00:00 | 2010-12-24 00:00:00 | 2010-12-25 00:00:00 | 2010-12-26 00:00:00 | 2010-12-27 00:00:00 | 2010-12-28 00:00:00 | 2010-12-29 00:00:00 | 2010-12-30 00:00:00 | 2010-12-31 00:00:00 | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-01-07 00:00:00 | 2011-01-08 00:00:00 | 2011-01-09 00:00:00 | 2011-01-10 00:00:00 | 2011-01-11 00:00:00 | 2011-01-12 00:00:00 | 2011-01-13 00:00:00 | 2011-01-14 00:00:00 | 2011-01-15 00:00:00 | 2011-01-16 00:00:00 | 2011-01-17 00:00:00 | 2011-01-18 00:00:00 | 2011-01-19 00:00:00 | 2011-01-20 00:00:00 | 2011-01-21 00:00:00 | 2011-01-22 00:00:00 | 2011-01-23 00:00:00 | 2011-01-24 00:00:00 | 2011-01-25 00:00:00 | 2011-01-26 00:00:00 | 2011-01-27 00:00:00 | 2011-01-28 00:00:00 | 2011-01-29 00:00:00 | 2011-01-30 00:00:00 | 2011-01-31 00:00:00
Badreddine | Yabi | 897884 | 0 | 0 | 0
Berrospe | [NAME] | 717553 | 0 | 0 | 0
[NAME] | [NAME] | 670844 | 0 | 0 | 0
Ciran | [NAME] | 897124 | 0 | 0 | 0
Cory | [NAME] | 574517 | 0 | 0 | 0
Ditore | [NAME] | 823088 | 0 | 0 | 0
Garvey | [NAME] | 3897 | 0 | 0 | 0
Guzman | Saul | 918615 | 0 | 0 | 0
Heineman | Russ | 737502 | 0 | 0 | 0
Holland | Scott | 801597 | 0 | 0 | 0
Lopez | Javier | 498139 | 0 | 0 | 0
Mendez | Hector | 10538 | 0 | 0 | 0
Mendez | Hector | 10538 | 0 | 0 | 0
Pula | Elvis | 684779 | 0 | 0 | 0
[NAME] | [NAME] | 449397 | 0 | 0 | 0
Valle | [NAME] | 706481 | 0 | 0 | 0
[NAME] | [NAME] | 506097 | 0 | 0 | 0
Waitekus | [NAME] | 613091 | 0 | 0 | 0
Spreadsheet: 823489d1679991217-conditional-format-date-date-deadline-red-or-green-deadlines
Sheet: Sheet1

TEST LINE |  |  |  |  | 2 day deadline |  |  |  |  | 5 day deadline
 |  | 2023-03-01 00:00:00 |  | 2023-03-02 00:00:00
Pre-Permit Walk Round |  |  |  |  |  | Permit Approval |  |  |  |  | Permit Closed Perameters
ID | Name | Date | Name | Date | Comments | Permit Number | Date | Permit Issuer | Date | Comments | Permit Number | Date | Permit Issuer | Date | Comments
Pre-walk ID | Issuer | Raised | PTWO | Completed |  | Permit | Raised | Raised by | Approved |  | Permit | Closed | Closed by | Approver Sign
 |  | 2023-03-01 00:00:00 |  | 2023-03-04 00:00:00
 |  | 2023-03-01 00:00:00 |  | 2023-03-04 00:00:00
 |  | 2023-03-01 00:00:00 |  | 2023-03-01 00:00:00
Spreadsheet: 844652d1696402954-formula-for-text-string-listing-number-of-each-type-of-room-in-a-property-property-room-schedule
Sheet: Sheet1

Property address | Window reference | Room reference | Room type |  | Property address |  | Text string
1 Acacia Avenue | W1 | R1 |  |  | Value | [NAME] | Example text (formula required)
1 Acacia Avenue | [NAME] |  | Living room |  |  |  | 1 living room, 1 kitchen, 2 bedrooms
1 Acacia Avenue | W3 | R2 | Kitchen |  | 3 Acacia Avenue |  | 1 living room, 1 utility room, 2 bedrooms, 1 bathroom
1 Acacia Avenue | W4 | R3 | Bedroom
1 Acacia Avenue | W5 | R4 |  |  |  | 1 living room, 1 kitchen, 2 bedrooms
1 Acacia Avenue | W6 |  | Bedroom |  | 3 Acacia Avenue | 1 living room, 1 utility room, 2 bedrooms, 1 bathroom
3 Acacia Avenue | W1 | R1
3 Acacia Avenue | [NAME] |  | Living room
3 Acacia Avenue | W3 | R2 | Utility room
3 Acacia Avenue | W4 | R3 | Bedroom
3 Acacia Avenue | W5 | R4 | Bathroom
3 Acacia Avenue | W6 | R5 | Bedroom
Notes:
Columns C has some blank cells
Columns D contains formulae that returns some blanks.
Spreadsheet: 714179d1611131366-mark-cell-with-colour-with-largest-deviation-excel_deviation
Sheet: Tabelle1

 |  |  |  |  | Specification Value |  |  | Measurement Results
 |  | IQS Pos no. | DRW grid square | Cavity no. | Nominal  Value | Upper Tolerance | Lower Tolerance | [NAME] | Values myself
 |  | 16 |  | 1 / 1 | 73.6 | 73.75 | 73.44999999999999 | 73.069
 |  | 16 |  | 1 / 2 | 73.6 | 73.75 | 73.44999999999999 | 73.071
 |  | 16 |  | 1 / 3 | 73.6 | 73.75 | 73.44999999999999 | 73.072
 |  | 16 |  | 2 / 1 | 73.6 | 73.75 | 73.44999999999999 | 73.094
 |  | 16 |  | 2 / 2 | 73.6 | 73.75 | 73.44999999999999 | 73.091
 |  | 16 |  | 2 / 3 | 73.6 | 73.75 | 73.44999999999999 | 73.097
 |  | 18
 |  | 18
 |  | 18