tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 802719d1666986105-can-some-one-help-with-a-multi-criteria-index-match-excel-simple-array-logic-please
Sheet: (14 Dock)

Activity ID | Activity Name | At Completion Duration | Start | Finish | BL Project Start | BL Project Finish
A26320 | 7.20 - Subway Redundant Services Removal. [NAME] (T3) | 0 |  | 2022-09-29 00:00:00 |  | 2022-05-26 00:00:00
A26270 | 15.01 - NTR Turntable Returned to Service | 0 |  | 2022-10-11 00:00:00 |  | 2022-10-10 00:00:00
14D-CD-2395 | 10.01 - FG3.2.12 - SRC Fresh Water Main Replacement - Concept Design Complete - M1.2 (T3) | 0 |  | 2022-11-10 00:00:00 |  | 2022-07-14 00:00:00
14D-CD-2045 | 5.03 & 05.10 - G1.3.3 - C14 10 Year LIFEX & Caisson Chloride Ingress Review - Concept Design Complete - M1.2 (T3) | 0 |  | 2022-11-14 00:00:00 |  | 2022-08-19 00:00:00
14D-KD-1220 | 7.09 & 7.16 - FG1.1.6 - 14D General Life Extension & Structure Chloride Ingress Review - Concept Design Complete - M1.2 | 0 |  | 2023-01-17 00:00:00 |  | 2022-10-26 00:00:00
14D-DD-4730 | 7.02, 7.03, 7.04 & 7.08 - ONR Release Hold Point (T2) | 0 |  | 2023-02-15 00:00:00 |  | 2022-07-26 00:00:00
14D-SD-1135 | 7.14 - FG1.4.4 - North East Permanent Vehicle Impact Barrier - Scheme Design Complete - M1.3 (T2) | 0 |  | 2023-05-19 00:00:00 |  | 2023-04-27 00:00:00
14D-SD-1191 | 7.10 - FG5.8.1 - Wet Berth Pump House Remediation - Scheme Design Complete - M1.3 (T2) | 0 |  | 2023-03-29 00:00:00 |  | 2022-12-02 00:00:00
14D-CD-3400 | All Work Package Concept Designs Complete | 0 |  | 2023-05-30 00:00:00 |  | TBC
14D-SD-1947 | 12.08 - FG - 60hz - Scheme Design Complete - M1.3 (T3) | 0 |  | 2023-05-31 00:00:00 |  | 2023-06-23 00:00:00
Safety Case Programme TBC
Safety Case Programme TBC
14 Dock:
A18910 | A18910 | 14 Dock Concept Phase Gate 7 Review **CODE | Finish Milestone | 0 | 0 |  |  | 2022-12-05 00:00:00 | 2023-08-21 00:00:00 |  | 321 |  |  |  |  | DF23-RfP_Live Schedule.14D-x.x1 | [NAME]
A11269 | A11269 | 14 Dock Floodwall Completion Date | Start Milestone | 0 | 0 |  |  | 2023-06-22 00:00:00 | 2023-08-25 00:00:00 |  | 70 |  |  |  |  | DF23-RfP_Live Schedule.14D-x.x1 | [NAME]
14D-2.1.3.1.1_20570 | 14D-2.1.3.1.1_20570 | 14 Dock Safety Justification Report plus Modification Summary Complete | Finish Milestone | 0 | 0 |  |  | 2023-04-13 00:00:00 | 2023-08-04 00:00:00 |  | 76 | KPM.L1 |  |  |  | DF23-RfP_Live Schedule.14D-2.1.3.1.1 | Sub-Title: PSC-220-Phase 4 - 14Dk LDSC Safety Justification Report
I need to add one extra but the Level 1 and 2 aren’t suitable
Spreadsheet: 89222d1288970143-excel-2007-format-x-axis-from-dates-into-fiscal-quarters-752000
Sheet: For Chart

 |  | Days Complete | Days Remaining | FY09 | Q3 | Q4 | FY10 | Q1 | Q2 | Q3 | Q4 | FY11 | Q1 | Q2 | Q3 | Q4
 | 2009-05-01 00:00:00
Tasks | 2009-05-01 00:00:00
Spreadsheet: 746093d1630504583-solver-excel-problem-how-to-create-the-optimal-boxes-mix-to-respect-the-constrains-boxes-hydr-
Sheet: Solver

 | I want to pay the cheaper amount possible to send all the itens listed above (total 64). I have the freight value in the table below and I have the constraint that all boxes need to be less than $50 to avoid the import tax fee.
 | TAX FEE
 | All the boxes need to be less than $50, otherwise I will 60% of tax fee. |  |  |  |  | 50
 | Standard Freight
 | Pounds | Cost
 | 0 - 1 | 18.98
 |  | 28.98
 |  | 38.98
 |  | 48.98
 | The problem
 | Minimize the number of boxes to reduce freight costs and also avoid tax fee
 | Product | Quantity I have | Box1 | Box2 | Box3 | Box4 | Box5 | Box6 | Box7 | Box8 | Box9 | Box10 | Box11 | Box12 | [NAME] | Box14 | Box15 | Box16 | Unit Pounds | Total Pounds | Unite price | Total Cost
 | ITEM #1 | 6 | 0 | 2 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0.1433 |  | 4.99
 | ITEM #2 | 5 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0.2033 |  | 10
 | ITEM #3 | 3 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0.71 |  | 8.7
 | ITEM #4 | 3 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0.1467 |  | 34
 | ITEM #5 | 5 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0.356 |  | 29.5
 | ITEM #6 | 10 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 4 | 0 | 0 | 2 | 0 | 1 | 0 | 0.2033 |  | 7.2
 | ITEM #7 | 3 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0.1633 |  | 30
 | ITEM #8 | 3 | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1133 |  | 7.9
 | ITEM #9 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 2 | 0.376 |  | 9.99
 | ITEM #10 | 5 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0.278 |  | 7.7
 | ITEM #11 | 5 | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0.106 |  | 6.99
 | ITEM #12 | 3 | 0 | 0 | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.2033 |  | 5.9
 | ITEM #13 | 5 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0.166 |  | 9.99
 | ITEM #14 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0.2033 |  | 9.8
 | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | value
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | weight
Spreadsheet: d9acdf04-0a0e-4ca7-a818-c763aaaf5423
Sheet: Sheet1

Adults With Current Symptoms of Moderate or Severe Depression, by County & Public Health District, Maine 2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Unweighted Number | Weighted Number | % | LCL | UCL
Maine total |  | 346 | 94728.16667223276 | 9.38788867997042 | 7.878106301656546 | 10.89767105828429
County
 | Androscoggin | 22 | 5655.536788209923 | 7.630391196796019 | 3.846557188784014 | 11.41422520480802
 | Aroostook | DNR | DNR | DNR | DNR | DNR
 | Cumberland | 37 | 11852.10425609053 | 6.650434897777302 | 3.863100477599962 | 9.437769317954642
 | Franklin | NSD | NSD | NSD | NSD | NSD
 | Hancock | 23 | 5582.037423493187 | 11.18651903477959 | 5.146709686244846 | 17.22632838331432
 | Kennebec | 29 | 7415.646922844716 | 9.318428594851962 | 5.398372851153765 | 13.23848433855016
 | Knox | 10 | 1223.85172325725 | 3.955740405971054 | 1.263844021136925 | 6.647636790805183
 | Lincoln | 11 | 2072.512438679932 | 6.903831680634427 | 2.281467613237584 | 11.52619574803127
 | Oxford | 20 | 6712.469630502585 | 14.14733197241621 | 5.772918980084211 | 22.52174496474822
 | [NAME] | 39 | 11585.6530595789 | 11.67085368195896 | 6.882909451359436 | 16.45879791255848
 | Piscataquis | NSD | NSD | NSD | NSD | NSD
 | Sagadahoc | 10 | 2537.816866740922 | 8.915777555548491 | 1.621926281553261 | 16.20962882954372
 | Somerset | 16 | 3396.243170625814 | 8.38974340238185 | 3.840833764941948 | 12.93865303982175
 | [NAME] | DNR | DNR | DNR | DNR | DNR
 | Washington | 22 | 4178.384682192172 | 13.40129615952836 | 7.575632000437868 | 19.22696031861886
 | York | 43 | 10532.35651694785 | 7.742012273534495 | 5.028277912567203 | 10.45574663450179
Public Health District
 | Aroostook | DNR | DNR | DNR | DNR | DNR
 | Central | 45 | 10811.89009347053 | 9.005305257334388 | 5.986368794918534 | 12.02424171975024
 | Cumberland | 37 | 11852.10425609053 | 6.650434897777302 | 3.863100477599962 | 9.437769317954642
 | Downeast | 45 | 9760.422105685358 | 12.0382161625025 | 7.707713841342077 | 16.36871848366292
 | [NAME] | 50 | 11115.23104650364 | 8.86603660582244 | 5.187280019351054 | 12.54479319229383
 | Penquis | 44 | 12372.41009562078 | 10.83639923154536 | 6.605979681534137 | 15.06681878155658
 | Western | 47 | 13813.97125696256 | 9.46146766140009 | 5.94289960197905 | 12.98003572082113
 | York | 43 | 10532.35651694785 | 7.742012273534495 | 5.028277912567203 | 10.45574663450179
Source:  Behavioral Risk Factor Surveillance System
Based eight questions that comprise the PHQ8
% = Weighted percentage of respondents LCL= Lower 95% confidence level of the weighted percentage UCL= Upper 95% confidence level of the weighted percentage
All percentages are weighted to be more representative of the population of Maine and to adjust for non-response.
DNR:  Data not reliable.   Data is suppressed if confidence intervals are greater than 20 percentage points.
NSD:  Non-sufficient data.  Data is not available due to small or zero counts.
Spreadsheet: 0b984ffa-af23-4cb3-9e34-88976efcfd46
Sheet: General

GENERAL
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
 | Brief Title |  | Approval Deadline |  | Reason
 | Amending Chapter 60 of the |  | 2011-05-01 00:00:00 |  | Amending Chapter 60 of the Code of Ordinances
 | Code of Ordinances
Details |  |  |  |  | Positions/Recommendations
 | Reason for Legislation |  |  |  | Sponsor |  |  |  | Water Services Department
 |  |  |  |  | Programs,
 |  |  |  |  | Departments, |  |  |  | Sewers
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  |  |  | Water Services Department
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  |  |  | None Known
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  |  |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee |  |  |  | Do pass
 |  |  |  |  | Actions
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  | X |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  |  |  |  |  |  |  |  |  | $14,500,000
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes
 |  |  |  |  | (Use this space for further discussion, if necessary)
Applicable Dates:
 | Billings for usage prior to 5/1/11, FY10-11 rates shall apply.
 | Billings for usage on or after 5/1/11, the new rates shall apply.
Fact Sheet Prepared by:
 | [NAME]
 | Contract Administration Section
Reviewed by:
 | [NAME]
 | Acting Director of Water Services
Reference Numbers |  | Chapter 60 Code of Ordinances
Spreadsheet: 41296d1239792899-vlookup-from-multiple-sheets-shift-schedule
Sheet: SWP

SWP
[NAME]. | SAP NO. | NAME | SECTION
 | 1110 |  |  | A,
 | 2784 |  |  | A,
 | 2712 |  |  | A,
 | 1215 |  |  | A,
 | 2790 |  |  | A,
 | 1326 |  |  | A,
 | 14134 |  |  | A,
 | 14135 |  |  | A,
 |  | 'A' SHIFT
 |  | 'B' SHIFT
 |  | 'C' SHIFT
 |  | 'G' SHIFT
 |  | TOTAL:
Spreadsheet: 78289d1278672394-excel-as-a-calendar-need-help-with-date-projection-job-timetable
Sheet: Timetable

 |  | Employee
Day | Date | Man 1 | Man 2 | Man 3 | Man 4 | Man 5 | Man 6 | Man 7
Monday | 2010-08-01 00:00:00 | House 1 | House 1 | House 1 | House 2 | House 2 | House 2 | House 2
Tuesday | 2010-08-02 00:00:00
Wednesday | 2010-08-03 00:00:00
Thursday | 2010-08-04 00:00:00
Friday | 2010-08-05 00:00:00
Saturday | 2010-08-06 00:00:00
Sunday | 2010-08-07 00:00:00
Monday | 2010-08-08 00:00:00
Tuesday | 2010-08-09 00:00:00
Wednesday | 2010-08-10 00:00:00
Thursday | 2010-08-11 00:00:00
Friday | 2010-08-12 00:00:00
Saturday | 2010-08-13 00:00:00
Sunday | 2010-08-14 00:00:00
Monday | 2010-08-15 00:00:00
Tuesday | 2010-08-16 00:00:00
Wednesday | 2010-08-17 00:00:00
Thursday | 2010-08-18 00:00:00
Friday | 2010-08-19 00:00:00
Saturday | 2010-08-20 00:00:00
Sunday | 2010-08-21 00:00:00
Monday | 2010-08-22 00:00:00
Tuesday | 2010-08-23 00:00:00
Wednesday | 2010-08-24 00:00:00
Thursday | 2010-08-25 00:00:00
Friday | 2010-08-26 00:00:00
Saturday | 2010-08-27 00:00:00
Sunday | 2010-08-28 00:00:00
Monday | 2010-08-29 00:00:00
Tuesday | 2010-08-30 00:00:00
Wednesday | 2010-08-31 00:00:00
Spreadsheet: d23afd55-7045-463f-a03e-d1944176a661
Sheet: Sheet1

Artist | Title | SubTitle | CatalogNumber | Category | Discs | [NAME] | Label | RetailPrice | UPC
AudioQuest | Carbon USB cable Type A to Type B | 0.75m | W AQCAUSB.75 | USB Cables |  |  | Equipment | 129 | 92592086609
AudioQuest | Cinnamon USB cable Type A to Type B | 1.5m | W AQCIUSB1.5 | USB Cables |  |  | Equipment | 79 | 92592086579
AudioQuest | Carbon USB cable Type A to Type B | 1.5m | [NAME] | USB Cables |  |  | Equipment | 169 | 92592086616
AudioQuest | Optilink 3 - 1 meter |  | W OPTILINK3 | Optical |  |  | Equipment | 229 | 92592017054
AudioQuest | Optilink 5 - 1 meter |  | W OPTILINK5 | Optical |  |  | Equipment | 495
AudioQuest | Forest USB cable Type A to Type B | 1.5m | W AQFUSB1.5 | USB Cables |  |  | Equipment | 39 | 92592086548
AudioQuest | DragonTail USB 2.0 Extender |  | W DRAGONTAIL | USB Cables |  |  | Equipment | 16.95 | 92592077478
AudioQuest | Pearl USB cable Type A to Type B | 1.5m | W AQPUSB1.5 | USB Cables |  |  | Equipment | 29 | 92592076396
AudioQuest | Optilink 1 - 1 meter |  | W OPTILINK1 | Optical |  |  | Equipment | 89 | 92592016897
AudioQuest | Pearl USB cable Type A to Type B | 0.75m | W AQPUSB.75 | USB Cables |  |  | Equipment | 25 | 92592076389
AudioQuest | Forest USB cable Type A to Type B | 0.75m | W AQFUSB.75 | USB Cables |  |  | Equipment | 35 | 92592087255
AudioQuest | Cinnamon USB cable Type A to Type B | 0.75m | W AQCIUSB.75 | USB Cables |  |  | Equipment | 65 | 92592087262
Aqvox | Aqvox USB Cable | 1 Meter Length | W AQVOX USB1M | USB Cables |  |  | Equipment | 279
AudioQuest | Coffee USB cable Type A to Type B | 0.75m | W AQCOUSB.75 | USB Cables |  |  | Equipment | 279 | 92592086647
AudioQuest | Coffee USB cable Type A to Type B | 1.5m | W AQCOUSB1.5 | USB Cables |  |  | Equipment | 349 | 92592086654
AudioQuest | Diamond USB cable Type A to Type B | 0.75m | W AQDUSB.75 | USB Cables |  |  | Equipment | 549 | 92592086685
AudioQuest | Diamond USB cable Type A to Type B | 1.5m | W AQDUSB1.5 | USB Cables |  |  | Equipment | 699 | 92592086692
AudioQuest | USB B-TO-MICRO 2.0 ADAPTOR |  | W HUGOAD | USB Cables |  |  | Equipment | 9.95
Spreadsheet: 140000d1328582559-how-to-make-dashboard-scroll-table-dashboard-table-scroll
Sheet: Dashboard

 |  | [NAME] |  |  |  |  |  |  |  |  |  | this is a scrool bar from form control (developer menu)
 |  |  | 1 | ▲ | KPI 1 | KPI 2 | KPI 3 | [NAME] | KPI 5
 |  | 3 | Product Name 3 |  | 760 | 9 | 0.95 | -30 | 503.34
 |  | 4 | Product Name 4 |  | 366 | 388 | 0.35 | 47 | 367.9
 |  | 5 | Product Name 5 |  | 1345 | 130 | 0.58 | 74 | 477.47 |  |  |  |  | right click scrool bar then format control
 |  | 6 | Product Name 6 |  | 790 | 181 | 0.97 | -10 | 678.05
 |  | 7 | Product Name 7 |  | 1269 | 319 | 0.78 | 24 | 373.29 |  |  |  |  | cell link: point to initila value in calculation tab (1)
 |  | 8 | Product Name 8 |  | 107 | 16 | 0.59 | 61 | 532.21
 |  | 9 | Product Name 9 |  | 501 | 486 | 0.56 | 67 | 265
 |  | 10 | Product Name 10 |  | 953 | 259 | 0.05 | 74 | 855.81
 |  | 11 | Product Name 11 |  | 783 | 299 | 0.18 | -71 | 649.79
 |  | 12 | Product Name 12 |  | 669 | 124 | 0.22 | -61 | 983.54
 |  |  |  | ▼
 |  |  | use offset to display values here
 |  |  |  | OFFSET(Data!D5,Calculation!$D$5,0,1,1)
Spreadsheet: 861547d1709430316-taking-weekly-data-and-converting-to-monthly-formula-query-2-dc007c0231-
Sheet: Weekly Forecast

 | Opening Cash |  | Cash Flow Summary - Weekly
 | 3573315.55
 | Minimum Cash Balance
 | 100000
 | Week ending |  | 2023-09-03 00:00:00 | 2023-09-10 00:00:00 | 2023-09-17 00:00:00 | 2023-09-24 00:00:00 | 2023-10-01 00:00:00 | 2023-10-08 00:00:00 | 2023-10-15 00:00:00 | 2023-10-22 00:00:00 | 2023-10-29 00:00:00 | 2023-11-05 00:00:00 | 2023-11-12 00:00:00 | 2023-11-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | Cash balance at beginning of week
 | Helper
 | Cash Receipts
 | Deposit
 | Reg Fees
 | Advanced Fees
 | Sales Ledger
 | Donation
 | Commercial Activities
 | Trips
 | Commem
 | Investment Income
 | Childcare
 | Intercompany
 | Total Cash Receipts
 | Cash paid out
 | Council Tax
 | Bank Charges
 | Travel
 | TV
 | Management Fees
 | IT
 | Phone
 | Lease
 | Marketing
 | Subscription
 | Adhoc
 | VAT
 | Cleaning Contract
 | Purchase Ledger
 | Insurance
 | Credit Card
 | Loan
 | Water Rates
 | Energy
 | Gas
 | Pension
 | Payroll
 | INLAND
 | Capital Projects
 | Catering
 | Total Cash Paid Out
 | Cash balance at end of week
Spreadsheet: 89e8a8a8-9f79-4d42-8dcc-43de66fdb378
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
7985 | 46781 | Giovanni | [NAME] | ITA | 177 | 00:25:04 | 00:00:00 | [NAME] | 00:00:00 | 00:37:04 | 1 | 01:28:41
7985 | 10294 | Reinhardt | [NAME] | GER | 178 | 00:25:20 | 00:00:00 | 00:29:27 | 00:00:00 | 00:35:55 | 2 | 01:30:43
7985 | 55664 | Diego | Cicerale | ITA | 175 | 00:24:12 | 00:00:00 | 00:30:36 | 00:00:00 | [NAME] | 3 | 01:35:51
7985 | 25800 | [NAME] | [NAME] | GER | 179 | 00:26:46 | 00:00:00 | 00:32:51 | 00:00:00 | 00:39:15 | 4 | 01:38:53
7985 | 15696 | [NAME] | Borgonovo | ITA | 174 | 00:27:05 | 00:00:00 | 00:30:57 | 00:00:00 | 00:42:25 | 5 | 01:40:27
Spreadsheet: 88155d1288074160-excel-2010-conditional-formatting-across-mulitpe-colums-copy-of-patch
Sheet: Sheet1

DEVICE | PORT | DEVICE | PORT | DEVICE | PORT | DEVICE | PORT |  | checksum |  |  |  | total | dupe?
EDGE1 | 2/01 | R2C2-PPB | 1 | R5C4-PPA | 3 | CISCO-DWDM-BCT-BCC | SL17-UC
EDGE1 | 2/02 | R2C2-PPA | 19 | R5C4-PPA | 4 | CISCO-DWDM-BCT-BCC | SL8-UC
EDGE1 | 2/03 | R2C2-PPA | 20 | R1C4-PPA | 7 | BDC-NOC-ASA | 1
EDGE1 | 2/04 | R2C2-PPA | 22 |  |  | R1C0-NORTEL SWITCH | 9
EDGE1 | 2/05 | R2C2-PPA | 08 | R2C3-PPY | 2 | BCT-SW1 | 1
EDGE1 | 2/06 | R2C2-PPC | 10 | R1C4-PPA | 9 | BDC-NOC-SW1 | 7
EDGE1 | 2/07 | R2C2-PPA | 7 | R1C2-PPB | 3 | BCC-PIPN1 | GE0/1
EDGE1 | 2/09 | R2C2-PPA | 21
EDGE1 | 2/10 | R2C2-PPA | 11
EDGE1 | 2/12 | R2C2-PPC | 23
EDGE1 | 2/20 | R2C2-PPB | 3
EDGE1 | 2/21 | R2C2-PPC | 9
EDGE1 | 2/22 | R2C2-PPC | 8
EDGE1 | 2/25 | R2C2-PPA | 8
EDGE1 | 2/30 | R2C2-PPA | 13
EDGE1 | 2/37 | R2C2-PPC | 5
EDGE1 | 2/38 | R2C2-PPC | 6
EDGE1 | 2/43 | R2C2-PPC | 13
EDGE1 | 2/44 | R2C2-PPC | 3
EDGE1 | 2/45 | R2C2-PPB | 10
EDGE1 | 2/47 | R2C2-PPA | 23
EDGE1 | 2/48 | BCC-RR1
EDGE1 | 3/01
EDGE1 | 3/03
EDGE1 | 3/07
EDGE1 | 3/08
EDGE1 | 3/10
EDGE1 | 3/11
EDGE1 | 3/13
EDGE1 | 3/14
EDGE1 | 3/17
EDGE1 | 3/20
EDGE1 | 3/22
EDGE1 | 3/23
EDGE1 | 3/24
EDGE1 | 3/26
EDGE1 | 3/28
EDGE1 | 3/31
EDGE1 | 3/32
EDGE1 | 3/34
EDGE1 | 3/35
EDGE1 | 3/36
EDGE1 | 3/37
EDGE1 | 3/38
EDGE1 | 3/39
EDGE1 | 3/41
EDGE1 | 3/42
EDGE1 | 3/43
EDGE1 | 3/44
EDGE1 | 3/45
EDGE1 | 3/47
EDGE1 | 3/48
EDGE1 | 6/1
EDGE1 | 6/2
Spreadsheet: 758729d1639043246-excel-dashboard-help-sum-data-from-multiple-tabs-service-support-management-db_v2
Sheet: Data_Dashboard

 |  |  | CUSTOMER DELIVERY DASHBOARD
 | 1. Filter by manager
 |  |  |  |  |  |  | number of Client Projects by month
 |  |  | Total Client Projects |  | COUNT TOTAL CLIENT PROJECT (column b) AND CLIENT IS NOT N/A (column c)
 |  |  | Total Client Projects completed |  | COUNT TOTAL CLIENT PROJECT (column b) AND CLIENT IS NOT N/A (column c) & status (column G)
 |  |  | Total Client Projects 'not completed' |  | COUNT TOTAL CLIENT CALLS & CLIENT PROJECT (column b) AND CLIENT IS NOT N/A (column c)
 |  |  | Total Client Client Calls |  | COUNT TOTAL CLIENT CALLS & CLIENT PROJECT (column b) AND CLIENT IS NOT N/A (column c)
 |  |  | Total Client Calls completed |  | COUNT TOTAL CLIENT CALLS (column b) AND CLIENT IS NOT N/A (column c) & status (column G)
 |  |  | Total Client Calls 'not completed' |  | COUNT TOTAL CLIENT CALLS & CLIENT PROJECT (column b) AND CLIENT IS NOT N/A (column c)
 |  |  | Total Training Days |  | COUNT TOTAL holiday (column b)
 |  |  | Total Holidays |  | COUNT TOTAL training (column b)
 | 2. Filter by month
 |  |  |  |  |  |  | number of Client Calls by month
 | 3. Filter by Client
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | Client Information
 |  |  | Client Name
 |  |  | Total number of Client Calls |  | Total number of Client Proects
 |  |  | Average number of Client Calls |  | Average number of Client Projects
 |  |  | Not started |  | Not started
 |  |  | On hold |  | On hold
 |  |  | In progress |  | In progress
 |  |  | Completed |  | Completed
Spreadsheet: 176479d1345882711-how-to-get-sum-of-different-criterias-in-one-cell-sample-sheet-oeldere-
Sheet: Sheet1

Invoice | source code | material | sales area | Qty
1 | ABC | ERASER | pune | 10
2 | XYZ | PENCIL | nashik | 10 |  |  | Som [NAME] | Kolomlabels
3 | XYZ | PEN | pune | 10 |  |  | Rijlabels | ERASER | PEN | PEN | PENCIL | RULER | SCALE | Eindtotaal
4 | ABC | RULER | dhule | 10 |  |  | ABC | 10 |  |  | 10 | 10 |  | 30
5 | XYZ | PEN | satara | 10 |  |  | XYZ |  | 20 | 10 | 10 |  | 10 | 50
6 | XYZ | SCALE | nashik | 10 |  |  | Eindtotaal | 10 | 20 | 10 | 20 | 10 | 10 | 80
7 | ABC | PENCIL | pune | 10
8 | XYZ | PEN | satara | 10
 | abc |  | 30
 | If, I put invice or source code or material or sales area in cell B14 total should come in D14
 | please help its very important
Spreadsheet: 793543d1661526913-excel-formula-help-possible-nested-ifs-excel-formula-issue
Sheet: Sheet 1

Sale_Date | Cancelled Status | Sale Date Actual | Sale Date Actual Week Number
2022-03-29 00:00:00 | Quotation
2022-03-30 00:00:00 | Quotation
2022-04-09 00:00:00 | Installation in Progress
2022-04-11 00:00:00
2022-05-12 00:00:00 | Sale
2022-05-12 00:00:00 | Installation in Progress
2022-06-13 00:00:00 | Sale
Spreadsheet: 714443d1611228890-selecting-multiple-cells-with-ctrl-to-see-their-combined-total-overwrites-formulas-example-issue
Sheet: Sheet1

 | 1
 | 2 |  | Formula 1 | SUM(A2:A4)
 | 3
 | 4
 | 5 |  |  |  |  | Formula 2 | SUM(A2:A11)
 | 6
 | 7
 | 8
 | 9 |  |  |  | Formula 3 | A12*A5
 | 10
Spreadsheet: 831182d1685468191-how-to-rank-multi-criteria-by-group-uniquely-excel-17
Sheet: Sheet3

 | Criteria 1 |  | [NAME] | Criteria 3
Categories Ranking | Week No. | Date | Department | Categories | Sales
1 |  | 2023-01-11 00:00:00 | A | Apple | 50
3 |  | 2023-01-11 00:00:00 | A | Mango | 25
2 |  | 2023-01-11 00:00:00 | B | [NAME] | 15
2 |  | 2023-01-11 00:00:00 | A | Orange | 60
 |  | 2023-01-14 00:00:00 | A | Apple | 20
 |  | 2023-01-14 00:00:00 | A | Mango | 30
1 |  | 2023-01-14 00:00:00 | B | Watermelon | 20
1 |  | 2023-01-14 00:00:00 | C | Papaya | 75
2 |  | 2023-01-15 00:00:00 | C | Dragon fruits | 15
2 |  | 2023-01-18 00:00:00 | C | [NAME] | 60
2 |  | 2023-01-18 00:00:00 | A | Apple | 30
1 |  | 2023-01-18 00:00:00 | C | [NAME] | 70
4 |  | 2023-01-18 00:00:00 | C | Grapes | 30
5 |  | 2023-01-18 00:00:00 | C | Durian | 20
1 |  | 2023-01-18 00:00:00 | A | Orange | 55
2 |  | 2023-01-18 00:00:00 | B | [NAME] | 35
3 |  | 2023-01-18 00:00:00 | C | Pineaple | 55
 |  | 2023-01-19 00:00:00 | A | Orange | 10
1 |  | 2023-01-19 00:00:00 | B | Watermelon | 40
Spreadsheet: 54338d1254331514-sumif-product-formula-problem-sumif-problem
Sheet: Sheet2

 |  |  |  |  | 2005-01-01 00:00:00
NAME | HIRE DATE | TERM DATE | REHIRE DATE | BEGINNING BALANCE AT 1/1/05  PER M. CARDENEZ | ADJUSTED BEGINNING BAL AT 1/1/05 PER HANDBOOK | YRS OF SVC | 2005-01-21 00:00:00 | 2009-07-31 00:00:00 | 2005-02-04 00:00:00
Jones, [NAME] | 2008-01-21 00:00:00 | 2009-07-31 00:00:00 |  | 0 | 0 | 1.526027397260274
Cortes, [NAME] | 1973-03-19 00:00:00 | 2009-07-31 00:00:00 |  | 31.14 | 31.14 | 36.39178082191781
[NAME], Candelaria | 1994-12-19 00:00:00 | 2009-07-31 00:00:00 |  | 109.98 | 109.98 | 14.62465753424657
Fisher, Borat | 1990-03-14 00:00:00 | 2009-07-31 00:00:00 |  | 65.22 | 65.22 | 19.39452054794521
[NAME], [NAME] | 2007-11-12 00:00:00 | 2009-07-31 00:00:00 |  | 0 | 0 | 1.717808219178082