tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 880617d1728436766-autopopulated-day-to-day-rate-table-using-specific-day-rate-week-rate-and-month-rates-equipment-day-week-month-rate-forcasted-cost-formula
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Click on all cells hilighted yellow for additional instructions (with exception to cells in row 1)
 |  |  |  |  |  |  |  |  |  | Project Duration
 |  |  |  |  |  |  |  |  |  | Start | End |  |  |  |  |  |  |  |  |  |  |  |  | Delivery - Return Fees
 |  |  |  |  |  |  |  |  |  | 2023-03-31 00:00:00 | 2023-04-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Day to Day Rate Table
 | Cost Code | Cost Type | Cost To-Date | Cost To Date (Last Updated) | Budgeted | Forecasted Spending | EAC |  |  | Supplier | Contract # | PO# | Cost Code | Description | Make | Equip# | Assign To | Delivered | Start Date | End Date | Rental Duration (Days) | Damage Cost | Tot. Act. Cost | Delivery Cost | Return Cost | Transferred (Y/N) | Damage/Transfer/Exchange Notes | Est. Start Date | Est. End Date | Est. Rental Duration (Days) | Tot. Est. Cost | Day/Wk/Mo | Day Rate | Week Rate | Month Rate | 2023-03-31 00:00:00 | 2023-04-01 00:00:00 | 2023-04-02 00:00:00 | 2023-04-03 00:00:00 | 2023-04-04 00:00:00 | 2023-04-05 00:00:00 | 2023-04-06 00:00:00 | 2023-04-07 00:00:00 | 2023-04-08 00:00:00 | 2023-04-09 00:00:00 | 2023-04-10 00:00:00 | 2023-04-11 00:00:00 | 2023-04-12 00:00:00 | 2023-04-13 00:00:00 | 2023-04-14 00:00:00
 | 701 |  |  |  |  |  |  |  |  | Supplier 1 | 127832180 | 7310890 | 713 | Buggy – 4 Seat | Kubota | 66153 | GF #1 | 2023-03-31 00:00:00 | 2023-04-01 00:00:00 | 2023-04-06 00:00:00 |  | 500 |  | 120 | 120 | N | 4.5.23 - Tire Replacement | 2023-04-03 00:00:00 | 2023-04-07 00:00:00 |  |  |  | 100 | 200 | 500 | 0 | 100 | 200 | 200 | 200 | 200 | 200 | 300
 | 702 |  |  |  |  |  |  |  |  | Supplier 1 | 128734779 | 7314328 | 711 | Forklift – 12K | JLG | 66523 | GF #2 | 4/2/23 | 4/3/23 |  |  | 1000 |  | 180 | 180 | Y | 4.5.23 - Transferred to GF #1 |  |  |  |  |  | 500 | 1500 | 3000 |  |  | $0 | 500 | 1000 | 1500 | 1500 | 1500
 | 703 |  |  |  |  |  |  |  |  | Supplier 2 | 130112384 | 7319947 | 730 | Truck – 3/4T | Dodge | 11156565 | GF #1 | 4/1/23 | 4/4/23 |  |  | 2500 |  | 1500 | 1500 | N | 4.11.23 - Window Replacement 4.9.23 - Tire Patch |  |  |  |  |  | 1100 | 1100 | 1100 |  |  |  | $0 | 1100 | 1100 | $1100 | 1100
 | 705
 | 707
 | 708
 | 709
 | 710
 | 711 | Forklifts |  |  | 20000
 | 712
 | 713 | Buggies |  |  | 10000
 | 714
 | 716
 | 718
 | 719
 | 720
 | 722
 | 723
 | 724
 | 725
 | 726
 | 728
 | 729
 | 730 | Trucks |  |  | 15000
 | 734
 | 735
 |  | Total:
Spreadsheet: 1305aee5-2454-4427-9c7f-1ae08e992ba0
Sheet: 1 Fiscal

1 | Fiscal Management:  Manage chapter revenue and expense according to council-lodge established procedures and leadership.
 |  | Establish financial target(s) for the chapter |  |  | [NAME] | 75
 |  | Meet the chapter’s financial target(s) |  |  | Silver | 100
 |  | Exceed the chapter’s financial target(s) |  |  | Gold | 200
 | Depending on lodge/council procedures, chapters may or may not have funds or develop annual budgets.  The key factor is:  Does your chapter follow your lodge’s and/or council’s budgeting and accounting procedures in establishing its budget or financial targets?  A financial target could be having and executing a budget for a specific chapter program/event, or it could be having and executing an annual chapter budget.  [NAME] points based on the chapter’s success at following lodge/council policies and in setting and/or achieving the established financial target.
 |  | What specific financial target(s) will the chapter meet? |  |  |  |  | Date Goal Made
 | Set the Goal
 |  | What steps must the chapter take before this item is accomplished?
 | Plan Acheivement
 |  | What steps did the chapter take to meet the chapter's financial target(s)? |  |  |  |  | Date Goal Met
 | Meet the Goal
 |  | What specifically contributed to the chapter exceeding its financial target(s)? |  |  |  |  | Date Goal Exceeded
 | Exceed the Goal
 |  | What specific financial target(s) should the chapter aim for next year?
 | Plan for Next Year | asdf
Spreadsheet: daren_farmer__6674__Midlothian Fuel Supply Contact
Sheet: Midlothian

Midlothian Power Plant
Fuel Supply Contact Information
Last Updated: | 2000-05-08 00:00:00
Steward of List: | [NAME]
Name | Work | Pager | Mobile | Home
ANP CO Team
[NAME] | [PHONE] |  | [PHONE] | [PHONE]
[NAME] | [PHONE] | [PHONE] | [PHONE] | [PHONE]
Midlothian O&M
Main # | [PHONE] | [PHONE]
[NAME] | [PHONE] |  | [PHONE]
[NAME] | [PHONE] |  | [PHONE]
[NAME] | [PHONE] |  | [PHONE] | [PHONE]
ABB Commissioning
[NAME] | [PHONE] |  | [PHONE] | [PHONE] Hotel
[NAME] | [PHONE] |  | [PHONE] | [PHONE]
Lone Star Pipeline
24 Hour Gas Control | [PHONE]
[NAME] | [PHONE]
[NAME] | [PHONE]
[NAME] | [PHONE]
[NAME] | [PHONE] |  | [PHONE]
[NAME] | [PHONE] | [PHONE]
[NAME] | [PHONE] |  | [PHONE]
JH Cathey | [PHONE]
PG&E TX Pipeline
Gas Control | [PHONE]
Gas Control | [PHONE]
[NAME] | [PHONE] | [PHONE] | [PHONE]
[NAME] | [PHONE] | [PHONE] | [PHONE]
[NAME] | [PHONE]
[NAME] | [PHONE] | [PHONE] | [PHONE]
[NAME] | [PHONE]
Houston P/L (Enron)
24 Hour Gas Control
[NAME] | [PHONE] | [PHONE] | [PHONE] | [PHONE]
[NAME] | [PHONE] | [PHONE] | [PHONE] | [PHONE]
[NAME] | [PHONE] | [PHONE] | [PHONE] | [PHONE]
[NAME] | [PHONE] | [PHONE] | [PHONE] | [PHONE]
Spreadsheet: 129894d1321965260-limits-for-using-vlookup-sales_help
Sheet: Saídas

Product Code | Product Name | Quantity | Base Value | VAT | Category | Destination | Date | Sales Tax | Sub Total Value | Final Value | Approval
COD001 | CD [NAME] | 300 | 30 | 0.06 | Música | Portugal | 2011-02-01 00:00:00 | 0.01 | 0.3 | 32.1 | Approved
COD003 | Magalhães | 160 | 16000 | 0.23 | Informática | UK | 2011-02-01 00:00:00 | 0.05 | 800 | 20480 | Approved
COD006 | DVD - Inception | 500 | 10000 | 0.23 | Cinema | USA | 2011-02-02 00:00:00 | 0.1 | 1000 | 13300 | Denied
COD004 | Portátil | 10 | 7000 | 0.23 | Informática | Espanha | 2011-02-03 00:00:00 | 0.02 | 140 | 8750 | Approved
COD004 | Portátil | 30 | 21000 | 0.23 | Informática | Portugal | 2011-02-03 00:00:00 | 0.01 | 210 | 26040 | Approved
COD008 | DVD - The Departed | 80 | 1360 | 0.23 | Cinema | China | 2011-02-05 00:00:00 | 0.1 | 136 | 1808.8 | Denied
COD001 | CD [NAME] | 1000 | 100 | 0.06 | Música | USA | 2011-02-07 00:00:00 | 0.1 | 10 | 116 | Approved
COD006 | DVD - Inception | 70 | 1400 | 0.23 | Cinema | Portugal | 2011-02-07 00:00:00 | 0.01 | 14 | 1736 | Approved
COD005 | Peluche | 18 | 360 | 0.23 | Brinquedos | UK | 2011-02-08 00:00:00 | 0.05 | 18 | 460.8 | Denied
COD004 | Portátil | 50 | 35000 | 0.23 | Informática | USA | 2011-02-09 00:00:00 | 0.1 | 3500 | 46550 | Denied
COD002 | Música Popular | 50 | 75 | 0.06 | Música | UK | 2011-02-09 00:00:00 | 0.05 | 3.75 | 83.25 | Denied
COD008 | DVD - The Departed | 25 | 425 | 0.23 | Cinema | UK | 2011-02-09 00:00:00 | 0.05 | 21.25 | 544 | Approved
COD002 | Música Popular | 100 | 150 | 0.06 | Música | Portugal | 2011-02-09 00:00:00 | 0.01 | 1.5 | 160.5 | Approved
COD001 | CD [NAME] | 2000 | 200 | 0.06 | Música | China | 2011-02-12 00:00:00 | 0.1 | 20 | 232 | Approved
COD006 | DVD - Inception | 1 | 20 | 0.23 | Cinema | UK | 2011-02-13 00:00:00 | 0.05 | 1 | 25.6 | Denied
COD005 | Peluche | 500 | 10000 | 0.23 | Brinquedos | Espanha | 2011-02-14 00:00:00 | 0.02 | 200 | 12500 | Approved
COD004 | Portátil | 70 | 49000 | 0.23 | Informática | UK | 2011-02-15 00:00:00 | 0.05 | 2450 | 62720 | Approved
COD007 | DVD - Blood Diamond | 60 | 1020 | 0.23 | Cinema | Espanha | 2011-02-15 00:00:00 | 0.02 | 20.4 | 1275 | Approved
 |  |  |  |  |  |  | Total approved |  | 134585.6
 |  |  |  |  |  |  |  | Espanha | 3
Spreadsheet: 0e7ce6ab-e5d2-4b10-8ef1-6b3562ae904a
Sheet: netLibrary

NetLibrary
2009-2010
COUNTER-Compliant?: | No
 | 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 | Total | 2009-2010 Price | Price per unit
NetLibrary
Total Accesses | 44 | 6 | 18 | 44 | 78 | 31 | 40 | 104 | 62 | 131 | 44 | 46 |  | 0 | N/A
Turnaways | 43 | 0 | 5 | 22 | 10 | 0 | 60 | 19 | 2 | 17 | 14 | 23
Note: We have 4,478 shared titles
Spreadsheet: 862978d1710525367-calendar-formulas-and-conditional-formatting-annual-calendar-dj
Sheet: July

 |  |  |  |  |  |  |  |  | JUL
 | NOTES
Spreadsheet: 96ff20b9-44fd-4427-ac4b-0f7010dd9f9f
Sheet: SPED End of Year defects

Special Education End of Year defect status 6/26/2014
Bug Number | Edit Number | Error or Warning | Edit Message | Summary | *please note upgrades to Data Pipeline are every Tuesday.
2762 | SY168 | E | If [NAME] for [NAME] in IEP Implementation [Path 2] is 01, then Eligibility and Services [Path 2] must be 00. | Fixed; moving to production on 7/1
3382 | SY226 | E | Hours of Special Education Services is required if Current Eligibility and Services is 02 or 03, unless an IEP was not implemented. | Fixed; moved to production on 6/26
2854 | SY250 | E | Calculated age is outside of the expected range for grade level.  Please verify that the grade and birth date are correct and refer to the Exception Request Instructions document on how to request a Grade-to-Age exception. | Fixed; moved to production on 6/26
1752 | SY267 | E | At least one Racial Category must be selected for each student. | Should be working?
2889 | SY268 | E | Grade level must be a valid grade level for the reported school based on the School Master Table. | Fixed; moving to production on 7/1
2896 | SY271 | E | SASID is required if Special Education/Part C Referral is 06. | Not fixed yet
Spreadsheet: lisa_gang__22227__EPE_MARCH_2002
Sheet: MARCH(21)

To: El Paso Marketing   -  fax # [PHONE]
El Paso Generation   -  fax # [PHONE]
 | 2002-03-21 00:00:00
HR ENDING | HR ENDING | FOUR CORNERS
Pacific | Mountain | SALE
Standard | Standard | EPMI
Time | Time | 22.25
 |  | CARRY OVER FROM 3/20
 |  | 3/1/02-3/31/02
 |  | EPMI TAG#41565 |  |  | TOTAL NET | NET PALO VERDE | NET FOUR CORNERS | NET EDDY
PST | MST | DIRECT BILL
2400 | 0100 | 25
0100 | 0200 | 0
0200 | 0300 | 0
0300 | 0400 | 0
0400 | 0500 | 0
0500 | 0600 | 0
0600 | 0700 | 0
0700 | 0800 | 0
0800 | 0900 | 0
0900 | 1000 | 0
1000 | 1100 | 0
1100 | 1200 | 0
1200 | 1300 | 0
1300 | 1400 | 0
1400 | 1500 | 0
1500 | 1600 | 0
1600 | 1700 | 0
1700 | 1800 | 0
1800 | 1900 | 0
1900 | 2000 | 0
2000 | 2100 | 0
2100 | 2200 | 0
2200 | 2300 | 0
2300 | 2400 | 0
2400 | 0100 | 0
 | MST Total |  |  |  |  |  |  |  | Today's Scheduled MWh
 |  |  | TOTAL SALES | TOTAL PURCHASES
 | PST TOTAL
 |  | EPE(G)4C
 |  | EPMI
 |  | AZPS(T)FC3/PPD2
 |  | WALC(T)PPD2/COOLIDGE
 |  | CRSP(L)COOLIDGE
Spreadsheet: 472913d1469837367-import-specific-cells-in-multiple-sheets-from-hundreds-of-identical-workbooks-imp_ds_templatefordb
Sheet: 9-Wall Thickness

Section 9.0 - Pipe Wall Thickness
Note: This table should be used to verify/determine nominal wall thickness.
The zero (0) foot axial reference is located at Station Number/Mile Post: |  |  |  |  |  |  |  |  | (Stationing)
Footage increasing toward downstream side.
All data in mils (thousandths of an inch) based on UT measurements.
Distance Looking Downstream | 0 ft. | 1 ft. | 2 ft. | 3 ft. | 4 ft. | 5 ft. | 6 ft. | 7 ft. | 8 ft. | 9ft. | 10 ft.
12 o'clock | 144 | 138
3 o'clock | 145 | 142
6 o'clock | 141 | 142
9 o'clock | 139 | 145
Distance Looking Downstream | 11 ft. | 12 ft. | 13 ft. | 14 ft. | 15 ft. | 16 ft. | 17 ft. | 18 ft. | 19 ft. | 20 ft. | 21 ft.
12 o'clock
3 o'clock
6 o'clock
9 o'clock
Distance Looking Downstream | 30 ft. | 38 ft. | 39 ft. | 40 ft. | 41 ft.
12 o'clock
3 o'clock
6 o'clock
9 o'clock
Comments:
Weld areas of parent metal scanned for laminations, minimum wall thickness found was .138, maximum wall thickness .156. No laminations found.
* Data Required
Spreadsheet: 154229d1336324459-help-with-a-chart-chart
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | pos 1 | pos 1_1 | pos 2 | pos 2_2 | pos 3 | pos 3_3
 |  |  |  |  |  |  |  | vat 1 | 15 | 15.1 | 15.3 | 15.7 | 15.6 | 15.9
 |  |  |  |  |  |  |  | vat 2 |  | 16.5 | 16.4 | 16.3 | 16.4 | 15.4
 |  |  |  |  |  |  |  | vat 3 |  | 16.2 | 16 | 15.8 | 15.4 | 15.2
Spreadsheet: 189781d1351347704-repeating-the-calculations-every-x-column-example
Sheet: Data

Unit 1 |  |  |  |  | Unit 2 |  |  |  |  | Unit 3 |  |  |  |  | Unit 4 |  |  |  |  | Unit 5 |  |  |  |  | Unit 6
A | B | C | D |  | A | B | C | D |  | A | B | C | D |  | A | B | C | D
1.02 | 1.76 | 4.8 | 10.2 |  | 1.54 | 2.1 | 5.2 | 29.7 |  | 32.25 | 38.75 | 232 | 213 |  | 4.45 | 5.6 | 27 | 41.5
1.32 | 1.82 | 4.3 | 11.3 |  | 1.58 | 2.02 | 6.9 | 17.2 |  | 34.25 | 36.75 | 201 | 232 |  | 5 | 6.2 | 34 | 31.3
1.26 | 1.92 | 4.5 | 12.8 |  | 1.6 | 2.51 | 28.8 | 17.5 |  | 35.25 | 43.5 | 298 | 266 |  | 4.95 | 5.75 | 34 | 26.5
1.56 | 1.82 | 6.7 | 11.7 |  | 2.06 | 2.48 | 20.1 | 20.3 |  | 42.75 | 52 | 247 | 283 |  | 5.05 | 6 | 32.3 | 29
1.33 | 1.64 | 5.8 | 12.8 |  | 2.16 | 2.46 | 13 | 17.7 |  | 35.75 | 49 | 216 | 208 |  | 5.1 | 5.9 | 36 | 29
1.32 | 1.46 | 5.8 | 13.2 |  | 2.32 | 3.04 | 18 | 26 |  | 38 | 45 | 275 | 252 |  | 4.9 | 5.65 | 28.4 | 28.1
1.25 | 1.54 | 6.1 | 1.1 |  | 2.5 | 3.1 | 18.3 | 30.7 |  | 39.25 | 48.75 | 329 | 256 |  | 4.16 | 5.55 | 27 | 25.7
1.01 | 1.4 | 6.6 | 15.8 |  | 2.19 | 2.96 | 7.4 | 26.2 |  | 38.75 | 46 | 263 | 284 |  | 3.26 | 4.46 | 25.9 | 24.9
0.72 | 1.56 | 5.9 | 18.8 |  | 2.09 | 3.12 | 11.3 | 26.2 |  | 41 | 49.12 | 250 | 262 |  | 3.24 | 4.7 | 9.4 | 24.9
1.5 | 2.78 | 12.7 | 24.4 |  | 2.75 | 3.45 | 15 | 25.6 |  | 41.42 | 49.94 | 239 | 256 |  | 4.43 | 6.52 | 19.1 | 43.6
Spreadsheet: 810076d1671534991-formula-which-will-help-me-to-work-on-commodities-required-as-per-consumption-sample
Sheet: Sheet1

 | Table 1: Summary |  |  |  |  | Table 2: Product Allocation per service |  |  |  |  |  | Table 3: Service Projection
 |  |  |  |  |  | Service Name---->
 | Product Name | Stock Available | Projection | Required |  | Product |  |  |  |  |  | Service name | Projection
 | A | 15 |  |  |  |  | 0.5 |  |  |  |  | 1 | 50
 | B | 25 |  |  |  |  |  | 0.5 | 0.3 |  |  | 2 | 60
 | C | 20 |  |  |  |  |  | 0.75 |  | 4.2 |  | 3 | 90
 | D | 30 |  |  |  |  |  |  |  |  |  | 4 | 10
 | E | 15 |  |  |  |  | 0.25 |  |  | 0.1
 | F | 15 |  |  |  |  |  | 0.1 |  | 1
 | G | 70 |  |  |  |  | 0.5 |  | 0.3 | 2
 | H | 60 |  |  |  |  | 0.5 | 0.1 | 0.4 | 0.7
 | Yellow highlight cell will show how much quantity will be used for projected numbers |  |  |  |  | Above table is showing that how much of product quantity used in a service
 | I have added simple formula but I have a long list of product and services therefore I want to use one formula which auto select product and service
Spreadsheet: 716275d1612141461-metric-to-determine-the-amount-of-quantity-for-a-certain-amount-of-allocated-funds-alloc-funds
Sheet: Issue (2)

Account | Unit Price | Quantity | Input Cost | Funds Allocated |  | Actual Quantity
ExampleName | 3.5e-05 |  |  | 84981
ExampleName | 3.5e-05 |  |  | 27534
ExampleName | 3.5e-05 |  |  | 479274
ExampleName | 3.5e-05 |  |  | 163675
ExampleName | 3.5e-05 |  |  | 42127
ExampleName | 3.5e-05 |  |  | 4083
ExampleName | 3.5e-05 |  |  | 42764
TOTAL
Rounded to whole units
Account | Unit Price | Quantity | Input Cost | Funds Allocated |  | Actual Quantity
ExampleName | 3.5e-05 |  |  | 84981
ExampleName | 3.5e-05 |  |  | 27534
ExampleName | 3.5e-05 |  |  | 479274
ExampleName | 3.5e-05 |  |  | 163675
ExampleName | 3.5e-05 |  |  | 42127
ExampleName | 3.5e-05 |  |  | 4083
ExampleName | 3.5e-05 |  |  | 42764
TOTAL
Rounded to thousands
Account | Unit Price | Quantity | Input Cost | Funds Allocated |  | Actual Quantity
ExampleName | 3.5e-05 |  |  | 84981
ExampleName | 3.5e-05 |  |  | 27534
ExampleName | 3.5e-05 |  |  | 479274
ExampleName | 3.5e-05 |  |  | 163675
ExampleName | 3.5e-05 |  |  | 42127
ExampleName | 3.5e-05 |  |  | 4083
ExampleName | 3.5e-05 |  |  | 42764
TOTAL
Spreadsheet: 98585d1297440310-interpolating-values-from-graph-samplequestion
Sheet: Sheet1

6 | 0.02661464155312751
13 | 0.04484544361147888
20 | 0.07110034331758838
27 | 0.06534108526171568
34 | 0.07626802776332205
41 | 0.07752878228552613
48 | 0.07366893298000443
55 | 0.08388156358673608
62 | 0.08925351725572947
69 | 0.1042645017884926
76 | 0.1047021103169578
83 | 0.109953503796897
90 | 0.1102754079092497
97 | 0.1179222555202736
104 | 0.1181769455176341
111 | 0.1208668052306281
118 | 0.1358952544873072
125 | 0.1360955997365683
132 | 0.1362748940899556
139 | 0.1413989745773557
146 | 0.1365824416220743 |  |  |  | enter X value
153 | 0.1367153652534069 |  |  |  | y value from interpolation
160 | 0.1368368213221456
167 | 0.1419298055702297
174 | 0.1520072888005675
181 | 0.1571019253611926
195 | 0.1622925591605711
223 | 0.1676275362968882
251 | 0.1829381729165283
279 | 0.1982400265447825
307 | 0.223595934321421
335 | 0.2540102053484257
363 | 0.2844584608525369
Spreadsheet: kate_symes__18140__Deal Correction 2-8
Sheet:  Current Day

Adjustment date | Date of applied calc | Deal Date | Desk | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
2001-02-07 00:00:00 | 2001-02-08 00:00:00 | 2001-02-06 00:00:00 | LTNW | EES | Houston | TFS | MW: from 25 to 50 | Deal reported incorrectly by EES | 515166/167 | MIDC/COB | Q2-01 | On [NAME] | 50 | 350/359.5 | EES
 |  |  | EES Count
2001-02-07 00:00:00 | 2001-02-08 00:00:00 | 2001-02-07 00:00:00 | LTNW | MS | MS | TFS | Entered late deals |  | 516687/688 | NP/PALO | Cal-03 | On [NAME] | 25 | 88/80 | Duke
2001-02-08 00:00:00 | 2001-02-08 00:00:00 | 2001-02-06 00:00:00 | LTNW | MS | Houston | N/A | On peak to Off peak |  | 515168/169 | MIDC/COB | H-01 | [NAME] | 25 | 300 | EES
2001-02-08 00:00:00 | 2001-02-08 00:00:00 | 2001-02-07 00:00:00 | LTNW | MS | Houston | Bloomberg | Delivery: from Mid-C to PV |  | 516651 | Palo Verde | H-01 | On [NAME] | 25 | 215 | Merrill
 |  |  | MS Count
2001-02-08 00:00:00 | 2001-02-08 00:00:00 | 2001-02-07 00:00:00 | LTNW | KS | MS | Prebon | Term: from H-01 to Q3-01 |  | 516611 | [NAME] | Q3-01 | [NAME] | 25 | 180 | PSCO
2001-02-08 00:00:00 | 2001-02-08 00:00:00 | 2001-02-07 00:00:00 | LTNW | KS | MS | Prebon | MW: from 10 to 16 |  | 516618 | MID-C | H-01 | [NAME] | 25 | 255 | [NAME]
 |  |  | KS Count
 |  |  | Grand Count
Spreadsheet: 529705d1500971173-return-list-with-non-blank-values-from-a-range-with-multiple-columns-testfile
Sheet: Solution multiple rows

bart | sofie | [NAME] | [NAME]
tom |  | george
piet | eline | tine | elise
 | [NAME] |  | [NAME]
jan | anne | joost | ann-sophie
 | inge |  | ine
[NAME] |  | [NAME]
hans |  | filip
 | leen |  | lore
[NAME] | hilke |  | hannelore
[NAME] | evelyn |  | lisabeth
 | isabelle
Spreadsheet: 166677d1341711804-calendar-month-and-year-lists-to-autofill-dates-aver-temp-example
Sheet: DATA

Month | Year
January | 2012
February | 2013
March | 2014
April | 2015
May | 2016
June | 2017
July | 2018
August | 2019
September | 2020
October | 2021
November | 2022
December | 2023
Spreadsheet: 735497d1623038024-working-out-dates-between-invoice-date-and-payment-date-excel-sample
Sheet: Summary

 | Week No. | 33 | 33 | 0.3181818181818182 | Week No. | 34 | 34 | 0.3 | Week No. | 46 | 46 | 0.125 | Week No. | 47 | 47 | 0.1481481481481481
Creditor No | No of Invoice | Inv $ | Pay $ | Longest date | No of Invoice | Inv $ | Pay $ | Longest date | No of Invoice | Inv $ | Pay $ | Longest date | No of Invoice | Inv $ | Pay $ | Longest date
L30668 |  | 0 | 0 |  |  | 0 | 0 |  | 1 | 89.1 | 89.1 | 1 | 1 | 201.71 | 201.71 | 3
L31003 | 1 | 319 | 0 | ?? |  | 0 | 319 | ?? | 1 | 1689.6 | 0 | ?? |  | 0 | 1689.6 | ??
Spreadsheet: 478382d1472756913-excel-2007-invoice-and-database-in-one-invoice-template-real-close-4
Sheet: Invoice

 |  |  |  |  |  |  | INVOICE
 |  |  |  |  | 2016-09-01 00:00:00 |  | Date: | 2016-09-01 00:00:00
 | Category |  | Item Number |  |  | Item Description | Unit of Mesure | QTY | Amount
 |  |  |  |  |  |  |  | 6 | #N/A
 |  |  |  |  |  |  |  | 5 | #N/A
 |  |  |  |  |  |  |  | 4 | #N/A
 |  |  |  |  |  |  |  | 6 | #N/A
 |  |  |  |  |  |  |  | 8 | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  | Sub total: |  |  |  | #N/A
 |  |  |  |  | Tax:
 |  |  |  |  | Total: |  |  |  | #N/A
Spreadsheet: 47033d1245942082-extracting-text-from-a-cell-vlookup-text
Sheet: Sheet1

Country | Code |  | Abbreviation | Country
Colombia | 307CO |  | AR | Argentina
 |  |  | BR | Brazil
Brazil | 103BR |  | CA | Canada
Brazil | 255BR |  | CL | Chile
 |  |  | CO | Colombia
 | 116PH (604052) |  | DK | Denmark
 | 139PH (604069) |  | JP | Japan
 | 360PH (604056) |  | MX | Mexico
 | [NAME] (604057) |  | MY | Malaysia
 | 165PH (604070) |  | PH | Philippines
 | 255PH (604071) |  | NZ | New Zealand
 |  |  | TW | Taiwan
Mexico | 125MX |  | TH | Thailand
Mexico | 137MX |  | VN | Vietnam
Mexico | 209MX |  | VE | Colombia
Mexico | 251MX
Mexico | 274MX
Spreadsheet: cd5c0721-909e-4d1f-893a-7a35f54cdf90
Sheet: New  Table 17

Table 17
Weekly Port Region Grain Ocean Vessel Activity (number of vessels)
 |  |  |  | Pacific | Vancouver
 | Gulf |  |  | Northwest | B.C.
 |  | Loaded | Due next
Date | In port | 7-days | 10-days | In port | In port
2013 range | (16..60) | (20..56) | (31..81) | (0..24) | n/a
2013 avg. | 32 | 33 | 51 | 12 | n/a
Source:  Transportation & Marketing Programs/AMS/USDA
Spreadsheet: 820997d1678378969-countifs-with-one-parameter-covering-multiple-columns-qmc-datix-data
Sheet: Overall Results

 |  |  | Department | No Pre Check Completed | No Post Check Completed | No User Name/Initials | No Theatre Number | No Patient Details | Single Fault on Sheet | 2 Faults on Sheet | 3 Faults on Sheet | 4 Faults on Sheet | 5 Faults on Sheet | % of Incidents
 |  |  | BURNS & PLASTICS
 |  |  | CARDIAC
 |  |  | COLORECTAL
 |  |  | COMBINED SPECIALITIES
 |  |  | DAY SURGERY
 |  |  | ELECTIVE ORTHOPAEDICS
 |  |  | EMERGENCY - CITY
 |  |  | EMERGENCY - QMC
 |  |  | ENT
 |  |  | GYNAE
 |  |  | HPB/GENERAL & VASCULAR
 |  |  | MATERNITY
 |  |  | MAX FAX
 |  |  | NEURO
 |  |  | OBSTETRICS
 |  |  | PAEDIATRIC
 |  |  | RECOVERY
 |  |  | SPINES
 |  |  | THORACICS
 |  |  | TRAUMA
 |  |  | UROLOGY (City)
Spreadsheet: 733158d1621424798-conditional-formatting-to-highlight-differences-between-two-datasets-example
Sheet: Sheet1

Data1
Driver1 | 2021-07-01 00:00:00 | 2021-07-02 00:00:00 | 2021-07-05 00:00:00 | 2021-07-06 00:00:00 | 2021-07-07 00:00:00 | 2021-07-08 00:00:00 | 2021-07-09 00:00:00 | 2021-07-23 00:00:00 | 2021-07-26 00:00:00 | 2021-12-29 00:00:00 | 2021-12-30 00:00:00 | 2021-12-31 00:00:00
Driver2 | 2021-06-28 00:00:00 | 2021-06-29 00:00:00 | 2021-06-30 00:00:00 | 2021-07-01 00:00:00 | 2021-07-02 00:00:00 | 2021-12-20 00:00:00 | 2021-12-21 00:00:00 | 2021-12-22 00:00:00 | 2021-12-23 00:00:00 | 2021-12-24 00:00:00 | 2021-12-29 00:00:00 | 2021-12-30 00:00:00
Driver3 | 2021-06-01 00:00:00 | 2021-06-02 00:00:00 | 2021-06-03 00:00:00 | 2021-06-04 00:00:00 | 2021-07-26 00:00:00 | 2021-07-27 00:00:00 | 2021-07-28 00:00:00 | 2021-07-29 00:00:00 | 2021-07-30 00:00:00 | 2021-08-23 00:00:00 | 2021-08-24 00:00:00 | 2021-08-25 00:00:00
Driver4 | 2021-06-08 00:00:00 | 2021-06-11 00:00:00 | 2021-07-26 00:00:00 | 2021-07-27 00:00:00 | 2021-07-28 00:00:00 | 2021-07-29 00:00:00 | 2021-07-30 00:00:00 | 2021-08-23 00:00:00 | 2021-08-24 00:00:00 | 2021-08-25 00:00:00 | 2021-08-26 00:00:00 | 2021-08-27 00:00:00
Data2
Driver4 | 2021-07-26 00:00:00 | 2021-07-27 00:00:00 | 2021-07-28 00:00:00 | 2021-07-29 00:00:00 | 2021-07-30 00:00:00
Driver1 | 2021-12-29 00:00:00 | 2021-12-30 00:00:00 | 2021-12-31 00:00:00
Driver2 | 2021-12-20 00:00:00 | 2021-12-21 00:00:00 | 2021-12-22 00:00:00 | 2021-12-23 00:00:00 | 2021-12-24 00:00:00 | 2021-12-29 00:00:00 | 2021-12-30 00:00:00
Driver3 | 2021-08-23 00:00:00 | 2021-08-24 00:00:00 | 2021-08-25 00:00:00