tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 158862d1338411558-results-summarizing-across-multiple-sheets-guest-comments-card
Sheet: Aquarius Data

Guest Comments Card |  |  | Very Satisfied | Satisfied | Dissatisfied | Does not Apply | 1
Name |  | Table reservation handling | Y
Company |  | Table service |  | Y
[NAME] |  | Variety of food and beverage menu |  | Y
E-mail |  | Server's knowledge of menu selection |  |  | Y
Date of birth |  | Quality and presentation of food | Y
Date of visit |  | Portion size of food |  |  | Y
 |  | Quality and presentation of beverage |  |  |  | Y
Meal | Lunch | Restaurant atmosphere |  | Y
Restaurant | Aquarius | [NAME] handling |  |  | Y
Comments
Guest Comments Card |  |  | Very Satisfied | Satisfied | Dissatisfied | Does not Apply
Name |  | Table reservation handling | Y
Company |  | Table service |  | Y
[NAME] |  | Variety of food and beverage menu |  |  | Y
E-mail |  | Server's knowledge of menu selection |  | Y
Date of birth |  | Quality and presentation of food | Y
Date of visit |  | Portion size of food |  |  | Y
 |  | Quality and presentation of beverage |  | Y
Meal | Dinner | Restaurant atmosphere |  | Y
Restaurant | Aquarius | [NAME] handling | Y
Comments
Guest Comments Card |  |  | Very Satisfied | Satisfied | Dissatisfied | Does not Apply
Name |  | Table reservation handling |  |  |  | Y
Company |  | Table service |  |  | Y
[NAME] |  | Variety of food and beverage menu | Y
E-mail |  | Server's knowledge of menu selection |  | Y
Date of birth |  | Quality and presentation of food |  | Y
Date of visit |  | Portion size of food | Y
 |  | Quality and presentation of beverage |  |  |  | Y
Meal | Dinner | Restaurant atmosphere |  |  | Y
Restaurant | Aquarius | [NAME] handling | Y
Comments
Guest Comments Card |  |  | Very Satisfied | Satisfied | Dissatisfied | Does not Apply
Name |  | Table reservation handling | Y
Company |  | Table service |  | Y
[NAME] |  | Variety of food and beverage menu |  |  | Y
E-mail |  | Server's knowledge of menu selection |  |  | Y
Date of birth |  | Quality and presentation of food |  | Y
Date of visit |  | Portion size of food | Y
 |  | Quality and presentation of beverage |  | Y
Meal | Lunch | Restaurant atmosphere | Y
Restaurant | Aquarius | [NAME] handling |  |  | Y
Comments
Spreadsheet: 804650d1668199572-date-range-check-formula-date-range-example
Sheet: Sheet1

Scheduled Start Date | Scheduled End Date | Freeze Start Date | Freeze End Date | Scheduled During Freeze?
2022-05-09 00:00:00 | 2022-05-16 00:00:00 | 2022-12-19 00:00:00 | 2023-07-31 00:00:00 | No
2022-02-21 00:00:00 | 2022-02-28 00:00:00 | 2022-12-19 00:00:00 | 2023-07-31 00:00:00 | No
2022-10-10 00:00:00 | 2022-10-14 00:00:00 | 2022-06-20 00:00:00 | 2022-12-31 00:00:00 | Yes
2023-03-01 00:00:00 | 2023-03-14 00:00:00 | 2023-01-16 00:00:00 | 2023-08-31 00:00:00 | Yes
Spreadsheet: 72612d1273306398-if-formula-material-submittal-logsheet
Sheet: Material Approval

2010-08-13 00:00:00
Material Submission/ Tracking Status |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I - Identified material |  |  |  |  |  |  |  |  |  |  | Revision No: | 0
Client |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S - Extrapolated Subcontracted
Consultant |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N - Extrapolated Not subcontracted |  |  |  |  |  |  |  |  |  |  | Date : | 2010-03-02 00:00:00
Main Contractor
S.No | No. | BT | Subcontract Package Description | HTCQ Submittal Ref No. | 1st Submission |  | Critical Items |  | Revised Planned Submittal Date | Critical Items | 2nd Submission |  | Critical Items |  | Final Status | Approval Type | Purchase Request/ Indent |  |  | Local Purchase Order (LPO) |  |  | Letter Of Credit                   (LC) |  |  | Factory Inspaction Date | Lead Period (days) | Expected Time of Arrival | Site Delivery |  | Installation Date | Remarks
 |  |  |  |  | Submission Date | Returned  Date |  | Status |  |  | Submission Date | Returned  Date |  | Status |  |  | Ref. No. | Critical Items | Date | Ref. No. | Critical Items | Date | Ref. No. | Critical Items | Date |  |  |  | Date Required at Site | Actual Delivery at Site
 |  |  |  |  |  |  | <7 |  |  | <7 |  |  | <7 |  |  |  |  | <7 |  |  | <7 |  |  | <7
 |  |  |  |  |  | 7 |  | C2 | 5 |  |  | 5 |  | [NAME] |  |  | 3 |  |  | 10 |  |  | 7 |  |  |  | Pragmatic |  | 4 days |  | P6
1
2 | 1 | BT 1 | [NAME] | MAT/T01-GEN/FAC/S17-P02/001 | 2010-06-10 00:00:00 |  |  |  |  |  | 2010-06-10 00:00:00
Spreadsheet: 836692d1689598718-automatic-top-10-ranking-by-date-reference-example
Sheet: Sheet1

 |  | Reason A | Reason B | Reason C | Reason D | Reason E | Reason F
Dates | Week #
2023-07-03 00:00:00 | 1 | 125 | 7 | 3 | 29 |  | 1
2023-07-04 00:00:00 | 1 | 97 | 9 | 9 | 24 | 1 | 4
2023-07-05 00:00:00 | 1 | 137 | 9 | 17 | 28 |  | 1
2023-07-06 00:00:00 | 1 | 84 | 8 | 8 | 32 | 1 | 2
2023-07-07 00:00:00 | 1 | 115 | 9 | 10 | 42 | 3 | 2
2023-07-08 00:00:00 | 1 | 80 | 3 | 4 | 12 | 3
2023-07-09 00:00:00 | 1 | 33 | 1 | 1 | 16 | 2
2023-07-10 00:00:00 |  | 127 | 6 | 9 | 35 |  | 2
2023-07-11 00:00:00 |  | 101 | 2 | 18 | 31 |  | 2
2023-07-12 00:00:00 |  | 63 | 2 | 13 | 24 |  | 1
2023-07-13 00:00:00 |  | 108 | 1 | 6 | 33 | 5
2023-07-14 00:00:00 |  | 74 | 4 | 6 | 22 | 2 | 1
2023-07-15 00:00:00 |  | 45 | 2 | 3 | 6 | 1 | 2
2023-07-16 00:00:00 |  | 71 | 3 | 4 | 5
Spreadsheet: 860747d1708728587-allocation-of-sales-visits-by-month-allocation-by-month
Sheet: Sheet1

 |  | Montly Visits Forecast
Client | Visits Forecast | January | February | March | April | May | June | July | August | September | October | November | December | Check
Store 1 | 12 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Store 2 | 24 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Store 3 | 4 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0
Store 4 | 124 | 11 | 10 | 10 | 11 | 10 | 10 | 11 | 10 | 10 | 11 | 10 | 10
Store 5 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
Store 6 | 200
Store 7 | 3
Store 8 | 7
Store 9 | 350
 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 |  |  | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0
 |  |  | 10 | 10 | 11 | 10 | 10 | 11 | 10 | 10 | 11 | 10 | 10
 |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
 |  |  | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 16 | 16 | 16 | 16
 |  |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0
 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 |  |  | 29 | 29 | 29 | 29 | 29 | 30 | 29 | 29 | 29 | 29 | 29
Spreadsheet: 7dc073b4-aa34-4df8-baac-076764844e1f
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FFTIH | Test | FFTIH | Total Inhibin | Total Inhibin | Enzyme-linked Immunosorbent Assay (ELISA) |  |  |  | 1.5 | mL | Container/Tube: Plain, red top [NAME]: 1.5 mL Additional Information: Date of birth is required. | 1 mL | Specimens other than	Serum Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Total Inhibin Reference: Females Normal menstrual cycle: 40-400 pg/mL Postmenopausal: <10 pg/mL Healthy males: 50-300 pg/mL  The inhibin test was developed and its performance characteristics determined by Women and Infants' Prenatal and Special Testing. It has not been cleared or approved by the U.S. Food and Drug Administration.   Test Performed by: Women and Infants AFP Laboratory, Second Floor 70 Elm Street Providence, RI 02903 | 1 time per week | 1 - 7 days | 9-11 days | 1 | 83520 |  |  |  |  | Women and Infants Hospital AFP Laboratory, Second Floor
FFTIH | [NAME] | SRED | Serum Red |  |  |  | Frozen
FFTIH | Result | Z1705 | Total [NAME] | Total [NAME] | Alphanumeric |  |  |  |  | pg/mL |  |  |  |  |  |  |  |  |  | 27174-2
Spreadsheet: 83186d1283229782-excel-2007-create-an-input-out-output-application-in-excel-for-selling-water-water1
Sheet: Sheet1

PURE WATER SALE RECORDS
Transaction # | C25 | C46 |  | M25 | M45
1 | 5 | 5 |  | 15 | 25
2 | 3 | 10 |  |  | 5
3 | 15 |  |  |  | 5 |  |  | Statistics:
4
5 |  |  |  |  |  |  |  | # 25c Gallons sold: |  |  | 23
6 |  |  |  |  |  |  |  | # 45c Gallons sold: |  |  | 15
7
8 |  |  |  |  |  |  |  | # Cash transactions:
9 |  |  |  |  |  |  |  | # Membership transactions:
10
11 |  |  |  |  |  |  |  | Daily dollar total:
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
Total:
Spreadsheet: 700207d1603054347-formula-to-identify-overdue-or-due-based-on-dates-book1-12-
Sheet: Sheet1

6 Month Point | 12 Month Point | 18 Month Point | 24 Month Point | Comments
2020-10-20 00:00:00
 |  | 2019-08-01 00:00:00
2018-08-01 00:00:00
2021-01-04 00:00:00
 |  |  | 2020-11-16 00:00:00
 | 2021-04-20 00:00:00
 |  |  |  | If date is in the past = "Overdue"
 |  |  |  | If date is in the next 30 days = "Due"
 |  |  |  | If date is more than a month (30 days) in the future = Blank
Spreadsheet: 886944d1737043577-i-want-to-widen-cells-down-the-line-without-widening-or-moving-cells-above-those-cells-merged-cell
Sheet: Sheet1

 | Date | QTY Ordered (1 = 10l) |  |  |  | Delivered QTY (1 = 10l) |  |  |  | QTY Taken to LR (1 = 10l) |  |  |  |  | Remaining QTY (1 = 10l) |  |  |  |  | Signature
 |  | Detergent | Destainer | [NAME] |  | Detergent | Destainer | [NAME] |  | Detergent | Destainer | [NAME] |  |  | Detergent | Destainer | [NAME]
 | 1st | 5 | 2 | 1
 | 2nd |  |  |  |  |  |  |  |  | 1 | 0 | 0 |  |  | 2 | 2 | 3
 | 3rd
 | 4th |  |  |  |  | 5 | 2 | 1 |  |  |  |  |  |  | 7 | 4 | 4
 | 5th
 | 6th
 | 7th
 | 8th
 | 9th
 | 10th
 | 11th
 | 12th
 | 13th
 | 14th
 | 15th
 | 16th
 | 17th
 | 18th
 | 19th
 | 20th
 | 21st
 | 22nd
 | 23rd
 | 24th
 | 25th
 | 26th
 | 27th
 | 28th
 | 29th
 | 30th
 | 31st
Spreadsheet: 678452d1589897053-index-based-on-time-period-and-value-return-value-based-on-time-period
Sheet: Sheet1

 | Name1 | [NAME] | Name3 |  |  |  |  |  |  |  | DATA
2020-05-18 00:00:00 |  |  |  | [NAME] to find "Event name" from data |  |  |  |  |  | Value | Start Date | End Date | Event name
 |  |  |  |  |  |  |  |  |  | Name1 | 2020-05-19 00:00:00 | 2020-05-24 00:00:00 | Event1
 |  |  |  |  |  |  |  |  |  | [NAME] | 2020-05-26 00:00:00 | 2020-06-03 00:00:00 | Event2
 |  |  |  |  |  |  |  |  |  | Name3 | 2020-05-19 00:00:00 | 2020-05-24 00:00:00 | Event3
 |  |  |  |  |  |  |  |  |  | Name1 | 2020-05-26 00:00:00 | 2020-06-04 00:00:00 | Event4
 |  |  |  |  |  |  |  |  |  | Name3 | 2020-06-02 00:00:00 | 2020-06-07 00:00:00 | Event5
 |  |  |  |  |  |  |  |  |  | Name3 | 2020-06-08 00:00:00 | 2020-06-08 00:00:00 | Event6
Spreadsheet: 144029d1330690753-excel-2007-military-time-and-count-if-question-response-time-summary
Sheet: Department

 | PMD Level |  | TOTALS by PMD |  | Within Response Time |  | Percent Within allowable Response
 | A |  | 9 |  | 8 |  | 88.88888888888889
 | B |  | 3 |  | 3 |  | 100
 | C |  | 10 |  | 5 |  | 50
 | D |  | 5 |  | 3 |  | 60
 | E |  | 0 |  | 0 |  | #N/A
 | O |  | 3 |  | 3 |  | 100
Spreadsheet: 488591d1478723748-counting-of-dates-test
Sheet: Sheet1

Region | Market | Approved | SR_T60_PCAND_APPV_AC | RFDS | TASK_325_PERMITS_APPROVED_AC | TASK_327_CLLI_SUBMIT_DATE_AC | TASK_329_CLLI_COMPLETE_DATE_AC | CIQ | TASK_398_AZP_COMPLETE_AC | [NAME] | TASK_500_3G_CNSTRCTN_CMPLT_AC | TASK_619_2500MHZ_OA_COM_SVC_AC | TASK_627_4G_800_ON_AIR_AC
Central | Central Illinois
Central | Central Iowa
Central | Chicago
Central | Cincinnati
Central | Cleveland
Central | Columbus
Central | Dakotas
Central | East Iowa
Central | East Kentucky
Central | East Michigan
Central | Ft. Wayne / South Bend
Central | Indianapolis
Central | Kansas
Central | Milwaukee
Central | Minnesota
Central | Missouri
Central | North Wisconsin
Central | Pittsburgh
Central | Toledo
Central | West Iowa / Nebraska
Central | West Kentucky
Central | West Michigan
Central | Western Pennsylvania
Central | West Virginia
Spreadsheet: 0073be2f-5a4b-4306-8f7d-b0a62ef7c37c
Sheet: Res 4 Blank

Washington Park Reservoir Improvements Project - Options Discussion Evaluation Framework - Preliminary September 2013
Rating Scale
Superior: | S | The option has significant benefits over other options for this goal
Acceptable: | A | The option meets the goal
Inferior: | I | The option is significantly less responsive to this goal than other options
Neutral: | N | No difference between options
 | Reservoir No. 4
Goals and Objectives | Reflecting Pool | Lawn | Habitat
Be Good Stewards of Public Funds
• Ensure costs provide the greatest community benefit
• Prudently spend public money & limit impact on ratepayers
[NAME] maintenance and operating costs low
Respect Historic Resources
• Minimize impacts to historic structures and features
• Maintain historic character of the site
[NAME] the historic function of the reservoirs in the context of the overall Portland water system
• Retain the sites reflective & tranquil character that is now created & heightened by the visual connection to an expansive water.
Be a Good Neighbor
• Reduce use of neighborhood parking by park visitors
• Avoid attraction of nuisance & illegal activities into the park & neighborhoods
• Enhance the quality of the park as an amenity for neighbors & visitors
• Minimize construction impacts
Enhance Park Experience
• Provide public access & opportunities for low-intensity recreation
• Retain the sites reflective & tranquil character that is now created & heightened by the visual connection to an expansive water.
• Enhance views into and from the area
• Provide people with ability to connect with nature in the city
• Maintain security of the park and water facilities
• Ensure the new visible features enhance current park uses and are compatible with future park uses
Support Sustainability
• Create sustainable landscapes that provide habitat for birds and other native wildlife
• Minimize climate change impacts due to construction, operations and maintenance.
• Promote wise use of our water resources through design, maintenance and education.
Spreadsheet: 145665d1331683274-how-do-i-make-a-name-count-as-a-number-schedule-help-2
Sheet: Sheet1

 |  |  | Exam Room 1 |  |  |  |  |  |  | Exam Room 2
 |  | exam code | 77771 |  |  |  |  |  | exam code | 77772
 | Appointment Times | Clinic 1 | Clinic 2 | Clinic 3 | Clinic 4 |  |  | Appointment Times | Clinic 1 | Clinic 2 | Clinic 3 | Clinic 4
 | 8am | Smith, S | 0 | 1 | 1 |  |  | 8am | 1 | 0 | 1 | 1
 | 9am | Fredrick,M | 1 | 0 | 2 |  |  | 9am | 0 | 1 | 1 | 0
 | 10am | [NAME],S | 1 | 0 | 1 |  |  | 10am | 1 | 1 | 1 | 0
 | 11am | 1 | 1 | 0 | 1 |  |  | 11am | 1 | 1 | 1 | 0
 | 1pm | 0 | 1 | 1 | 0 |  |  | 1pm | 1 | 1 | 1 | 0
 | 2pm | 1 | 1 | 1 | 0 |  |  | 2pm | 0 | 1 | 0 | 1
 | 3pm | 1 | 1 | 1 | 1 |  |  | 3pm | 0 | 0 | 0 | 1
 | 4pm | 1 | 0 | 1 | 1 |  |  | 4pm | 1 | 0 | 0 | 1
 | Totals |  |  |  |  |  |  | Totals
 |  |  | Exam Room 3 |  |  |  |  |  |  | Exam Room 4
 |  | exam code | 77773 |  |  |  |  |  | exam code | 77774
 | Appointment Times | Clinic 1 | Clinic 2 | Clinic 3 | Clinic 4 |  |  | Appointment Times | Clinic 1 | Clinic 2 | Clinic 3 | Clinic 4
 | 8am | 1 | 1 | 1 | 1 |  |  | 8am | 0 | 0 | 1 | 1
 | 9am | 1 | 0 | 0 | 0 |  |  | 9am | 1 | 0 | 1 | 0
 | 10am | 1 | 0 | 0 | 1 |  |  | 10am | 1 | 0 | 1 | 0
 | 11am | 1 | 0 | 1 | 1 |  |  | 11am | 1 | 0 | 1 | 1
 | 1pm | 0 | 1 | 1 | 1 |  |  | 1pm | 1 | 0 | 1 | 1
 | 2pm | 0 | 1 | 0 | 1 |  |  | 2pm | 1 | 0 | 1 | 1
 | 3pm | 1 | 1 | 0 | 1 |  |  | 3pm | 1 | 0 | 1 | 1
 | 4pm | 1 | 1 | 2 | 1 |  |  | 4pm | 1 | 0 | 0 | 1
 | Totals |  |  |  |  |  |  | Totals
 |  |  | Exam Room 5 |  |  |  |  |  |  | Exam Room 6
 |  | exam code | 77775 |  |  |  |  |  | exam code | 77776
 | Appointment Times | Clinic 1 | Clinic 2 | Clinic 3 | Clinic 4 |  |  | Appointment Times | Clinic 1 | Clinic 2 | Clinic 3 | Clinic 4
 | 8am | 1 | 0 | 1 | 1 |  |  | 8am | 0 | 2 | 1 | 1
 | 9am | 0 | 1 | 1 | 0 |  |  | 9am | 1 | 0 | 0 | 1
 | 10am | 0 | 1 | 1 | 0 |  |  | 10am | 1 | 0 | 1 | 0
 | 11am | 0 | 1 | 1 | 0 |  |  | 11am | 1 | 0 | 1 | 0
 | 1pm | 1 | 1 | 1 | 1 |  |  | 1pm | 1 | 1 | 0 | 1
 | 2pm | 1 | 1 | 1 | 1 |  |  | 2pm | 0 | 1 | 1 | 1
 | 3pm | 1 | 0 | 1 | 1 |  |  | 3pm | 0 | 1 | 1 | 1
 | 4pm | 1 | 0 | 0 | 1 |  |  | 4pm | 0 | 1 | 1 | 0
 | Totals |  |  |  |  |  |  | Totals
Spreadsheet: 855074d1704788184-filter-without-result-to-show-blank-for-vstack-filter-without-result-2-
Sheet: Sheet2

Code | Start | End | Prorate |  |  | 2023-06-30 00:00:00 |  | Code | Start | End | Cost
#1 | 2023-05-12 00:00:00 |  | 500 |  |  |  |  |  | 2023-06-11 00:00:00 |  | 150 |  | Basically, I want the top to be Code that start in the Month (E1) and bottom to show Code that end in the Month (E1)
#2 | 2023-05-27 00:00:00 | 2023-06-01 00:00:00 | 600 |  |  |  |  | #4 | 2023-06-26 00:00:00 | 2023-09-16 00:00:00 | 3600 |  | However, the formula only work nicely if the filter is a valid for both Start and End.
#3 | 2023-06-11 00:00:00 |  | 150 |  |  |  |  |  |  |  |  |  | How do I make a Iferror, then it will show blank?
#4 | 2023-06-26 00:00:00 | 2023-09-16 00:00:00 | 3600
#5 | 2023-07-11 00:00:00 |  | 800 |  |  |  |  |  |  |  |  |  | *If the eomonth of START = G1, den ((G1-Start)/day(G1))*column D
#6 | 2023-09-01 00:00:00 |  | 300 |  |  |  |  |  |  |  |  |  | if eomonth of [NAME], den ((Day(end)/Day(g1))*column D
#7 | 2023-09-16 00:00:00 |  | 600
#8 | 2023-10-01 00:00:00 |  | 900
#9 | 2023-10-16 00:00:00 | 2023-12-31 00:00:00 | 7500
#10 | 2023-10-31 00:00:00 |  | 3000
 |  |  |  |  |  |  |  | Code | Start | End | Cost
 |  |  |  |  |  |  |  |  | 2023-05-27 00:00:00 | 2023-06-01 00:00:00 | 600
 |  |  |  |  |  | 2023-05-31 00:00:00 |  |  |  |  |  |  |  | 2023-12-31 00:00:00
 |  |  |  |  |  |  | Expected |  |  |  |  |  |  |  | Expected
 |  |  |  |  |  |  |  | Code | Start | End | Cost |  |  |  |  | Code | Start | End | Cost
 |  |  |  |  |  |  |  | #1 | 2023-05-12 00:00:00 |  | 500 |  |  |  |  | #9 | 2023-10-16 00:00:00 | 2023-12-31 00:00:00 | 7500
 |  |  |  |  |  |  |  | #2 | 2023-05-27 00:00:00 | 2023-06-01 00:00:00 | 600
 |  |  |  |  |  |  |  | Code | Start | End | Cost | Prorate |  |  |  | Code | Start | End | Cost | Prorate
 |  |  |  |  |  |  |  | #1 | 2023-05-12 00:00:00 |  | 500 |  |  |  |  | #9 | 2023-10-16 00:00:00 | 2023-12-31 00:00:00 | 7500
 |  |  |  |  |  |  |  | #2 | 2023-05-27 00:00:00 | 2023-06-01 00:00:00 | 600
 |  |  |  |  |  | The month in G1 is like "For the Month of xxxxx". Not juz the day itself. Hence 31/5/2023 mean 1st to 31st May
 |  |  |  |  |  | *For the Prorate part, if [NAME] in the Month, the amt to prorate = ((Number of days in the month)-(Start Date)+1)/(Number of days in the month)* Monthly Rate
 |  |  |  |  |  | If it end on the month itself, then would be (Day end)/(Number of days in the month)* Monthly Rate
 |  |  |  |  |  | The formula is fine if the filter criteria is Valid for both Start and End (eg 30/06/2023), but it haywire if either one is error.
Spreadsheet: 109929d1306745297-excel-2007-about-networkdays-networkdays-help-ex
Sheet: Sheet1

Planned Date | DCC Sub. Date | C. Days in Adv,
2011-04-01 00:00:00 | 2011-04-01 00:00:00 | 0 | Completed |  |  |  |  |  |  |  | Data: D.L Selection
2011-04-01 00:00:00 | 2011-04-01 00:00:00 | 0 | Completed |  |  |  |  |  |  |  | ---
2011-04-01 00:00:00 | 2011-04-04 00:00:00 | -1 | Completed |  |  |  |  |  |  |  | W.I.P
2011-04-01 00:00:00 | 2011-04-04 00:00:00 | -1 | Completed |  |  |  |  |  |  |  | On-Hold
2011-04-01 00:00:00 | 2011-04-04 00:00:00 | -1 | Completed |  |  |  |  |  |  |  | Checking
2011-04-01 00:00:00 | 2011-04-04 00:00:00 | -1 | Completed |  |  |  |  |  |  |  | Completed
2011-04-06 00:00:00 | 2011-04-04 00:00:00 | 2 | Completed
2011-04-06 00:00:00 | 2011-04-04 00:00:00 | 2 | Completed
2011-04-06 00:00:00 | 2011-04-04 00:00:00 | 2 | Completed
2011-04-06 00:00:00 | 2011-04-04 00:00:00 | 2 | Completed
2011-04-06 00:00:00 | 2011-04-04 00:00:00 | 2 | Completed
2011-04-06 00:00:00 | 2011-04-04 00:00:00 | 2 | Completed
2011-04-20 00:00:00 | 2011-04-19 00:00:00 | 1 | Completed
2011-05-03 00:00:00 | 2011-05-03 00:00:00 | 0 | Completed
2011-05-06 00:00:00 | 2011-05-06 00:00:00 | 0 | Completed
2011-04-26 00:00:00 | 2011-04-26 00:00:00 | 0 | Completed
2011-04-28 00:00:00 | 2011-04-28 00:00:00 | 0 | Completed
2011-04-28 00:00:00 | 2011-04-28 00:00:00 | 0 | Completed
Spreadsheet: 145377d1331561658-help-choosing-minimum-price-if-in-stock-excelhelp
Sheet: input sheet

Price Watch | Projector | sk1 | sk2 | sk3 | sk4 | sk5 | supplier1 | supplier2 | supplier3 | supplier4 | [NAME]
man | product1 | 12 | 0 | 0 | 0 | 0 | 125 | 99999 | 877 | 325 | 15
man | product2 | 15 | 0 | 0 | 0 | 0 | 88888 | 529 |  | 99999 | 99999
man | product3 | 0 | 0 | 0 | 0 | 0 | 88888 | 226.88 |  | 125 | 99999
man | product4 | 116 | 0 | 0 | 0 | 0 | 88888 | 292.02 |  | 99999 | 99999
man | product5 | 1 | 0 | 0 | 17 | 0 | 88888 | 378.86 |  | 125 | 99999
man | product6 | 0 | 22 | 0 | 0 | 0 | 420 | 420 |  | 877 | 99999
Spreadsheet: 75260d1275846413-pivottables-showing-percent-instead-of-values-excelforum-example
Sheet: PivotTable

Row Labels | Sum of Revenue Act
EU DFDS | 60743.7450429848
DFDS Madrid | 60743.7450429848
AA | 43503.95519847074 |  | 1 | The task is to replace the amount for contracted
Contracted Volume | 35316.09411847073 |  | 0.81 | and non-contracted volues with percentage.
Non Contracted Volume | 8187.86108 |  | 0.19 | Like this
CA | 334.12554 |  | 1
Contracted Volume | 134.78818 |  | 0.4
Non Contracted Volume | 199.33736 |  | 0.6
KK | 1766.313795016155 |  | 1
Contracted Volume | 1392.776025016155 |  | 0.79
Non Contracted Volume | 373.53777 |  | 0.21
LL | 10756.6501 |  | 1
Contracted Volume | 9241.76357 |  | 0.86
Non Contracted Volume | 1514.88653 |  | 0.14
XL | 658.09454
Contracted Volume | 464.18896
Non Contracted Volume | 193.90558
OO | 713.08962
Contracted Volume | 573.23779
Non Contracted Volume | 139.85183
UU | 353.27072
Contracted Volume | 242.67385
Non Contracted Volume | 110.59687
WW | 2658.245529497908
Contracted Volume | 2289.746659497908
Non Contracted Volume | 368.49887
Grand Total | 60743.7450429848
Spreadsheet: 273015d1382577214-sumif-problem-117
Sheet: Trends by Day

 |  | Target | Actual | Target | Actual | Target | Actual | Target | Actual | Target | Actual | Target | Actual
Date |  | Daily Budget |  | Travalos |  | Premiers |  | Mailouts |  | Trans |  | Units
Store Goals
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Spreadsheet: benjamin_rogers__1240__Summary of Different Florida Scenarios
Sheet: Sheet1

 | Florida Site/Facility Analysis
 |  |  | Total Installed |  | Capacity |  | Spread Option
 |  |  | Cost ($) | Cost ($/kW) | Price ($/kW-mo.) | NPV | Pricing
 | Case 1:
 | Model with Nepco Fee |  | 152257 | 558.71 | 5.735 | 0
 | Model without Nepco Fee |  | 144273 | 528.47 | 5.497 | 0 | 4.81
 | Simple-Cycle Configuation
 | 30 Yr. [NAME]. With 10% Resid and
 | 7% Debt
 | 10,500 Heat Rate w/ Dual Fuel
 | Case 2:
 | Model with Nepco Fee |  | 213518 | 613.56 | 6.399 | 0
 | Model without Nepco Fee |  | 207831 | 597.21 | 6.27 | 0 | 5.4
 | Combine-Cycle Configuration
 | 30 Yr. [NAME]. With 10% Resid and
 | 7% Debt
 | 8,275 Heat Rate w/Dual Fuel
 | Case 3:
 | Year 1: Simple-Cycle (HR = 10,500)
 | Year 2-30: Combine-Cycle (HR = 8,275)
 | 30 Yr. [NAME]. With 10% Resid and
 | 7% Debt
 | Case 4:
 | Case 3 but with [NAME] of 80% of Capital Cost | 0.8
 | and 70% Capital Cost | 0.7
 | Notes: