tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 881151d1729079318-distribution-of-items-based-on-actual-value-should-be-exact-excel-forum-actual-total-number-remains-2-
Sheet: Sheet1

 |  |  |  |  |  | Time (Hours) | Total Number of Items
 |  |  |  |  |  |  | Actual | Adjusted
 |  |  |  |  |  | 8 |  |  | <---- | we can retain the numbers here
 |  |  |  |  |  | 7 |  |  |  | or round down or round up..
 |  |  |  |  |  | 7 |  |  |  | so that the total in green is always equal to user entry value
 |  |  |  |  |  |  |  |  |  | in this example is user entry is 20
 |  |  |  |  |  |  | 20 |  |  | <--- this should also be 20
 |  |  |  |  |  |  | this will change based on user entry value | should be always equal to the total ACTUAL
 |  |  |  |  |  |  |  | meaning this should also be 20 based on the ACTUAL
Spreadsheet: 148379d1333378755-creating-a-formula-for-dining-analysis-brunos-dining-analysis
Sheet: Summary

 | Bruno's Dining Analysis
 | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Total
Dine-In
Pick-up
Delivery
Total
Spreadsheet: 732690d1621165901-comparing-unsorted-lists-across-multiple-sheets-fortune-500-problem-example
Sheet: 2011

Rank | Company | Revenues ($ millions) | Profits ($ millions) | Ticker symbol
1 | #[NAME]! | 421849 | 16389
2 | #[NAME]! | 354674 | 30460
3 | #[NAME]! | 196337 | 19024
4 | #[NAME]! | 184966 | 11358
5 | #[NAME]! | 153825 | -14014
6 | #[NAME]! | 151628 | 11644
7 | #[NAME]! | 136185 | 12967
8 | #[NAME]! | 135592 | 6172
9 | #[NAME]! | 134194 | -2238
10 | #[NAME]! | 128954 | 6561
11 | #[NAME]! | 126033 | 8761
12 | #[NAME]! | 124629 | 19864
13 | #[NAME]! | 115475 | 17370
14 | #[NAME]! | 111055 | 10602
15 | #[NAME]! | 108702 | 1263
16 | #[NAME]! | 106565 | 2549
17 | #[NAME]! | 104417 | 7786
18 | #[NAME]! | 99870 | 14833
19 | #[NAME]! | 98601.9 | 642.2
20 | #[NAME]! | 98368 | -14025
Spreadsheet: 330232d1404642526-stop-when-a-value-is-reached-oeldere-2-330221d1404631426-stop-when-a-value-is-reached-test-sheet-holidays
Sheet: Sheet1

 |  |  |  |  |  |  | Holidays | Total
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 5 |  |  | <<
 |  |  |  |  |  |  | 4
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 9
Spreadsheet: 66830d1267523841-help-needed-trying-to-match-values-helpv2
Sheet: Sheet1

Reporting Location | Sending Location | Receiving Location | Other Party | Equipment Code | Quantity | Shipment Date | Reference | Other Reference | Delivery Date | Del Point Code | Del Point Name
500511986 | 500511986 | 100389736 |  | 1 | 12 | 2008-12-18 00:00:00 | 11030971 | 137469 | 2008-12-18 00:00:00 | 5113003 | DBC (THATCHAM)
500511986 | 500511986 | [PHONE] |  | 1 | 4 | 2008-12-17 00:00:00 | 11030973 | EL1212N | 2008-12-17 00:00:00 | 8009001 | HYPERAMA PLC (CASH & CARRY DIV)
500511986 | 500511986 | [PHONE] |  | 1 | 4 | 2008-12-16 00:00:00 | 11030981 | 130940 | 2008-12-16 00:00:00 | 5529001 | CONTINENTAL WINE & FOOD LTD
500511986 | 500511986 | 100253886 |  | 1 | 5.013131313131313 | 2008-12-17 00:00:00 | 11030987 | 13467 | 2008-12-17 00:00:00 | 5511001 | GIBSONS WHOLESALE FOODS
500511986 | 500511986 | 100200450 |  | 1 | 6.466666666666668 | 2008-12-18 00:00:00 | 11031003 | ALISON 12.12.08 | 2008-12-18 00:00:00 | 5306001 | HUNTS FROZEN FOODS
500511986 | 500511986 | [PHONE] |  | 1 | 4.781818181818181 | 2008-12-17 00:00:00 | 11031006 | 44225 | 2008-12-17 00:00:00 | 5409001 | [NAME]
Spreadsheet: 126718d1319832879-running-average-productivity-2011adam
Sheet: Feb

February Valet Totals
PIPER |  |  |  |  | MAIN |  |  |  |  | TOTAL
Average Wait Time |  |  |  |  | Average Wait Time |  |  |  |  | Average Wait Time
Average Storage Length |  |  |  |  | Average Storage Length |  |  |  |  | Average Storage Length
 | Total Parked/            Returned | Average/hour | Scheduled Productive Hours |  |  | Total Parked/            Returned | Average/hour | Scheduled Productive Hours |  |  | Total Parked/            Returned | Average/hour | Scheduled Productive Hours
5:00am-5:59am |  |  | 1 |  | 5:00am-5:59am | 0 | 0 | 0 |  | 5:00am-5:59am | 0 | 0 | 1
6:00am-6:59am |  |  | 2 |  | 6:00am-6:59am | 0 | 0 | 0 |  | 6:00am-6:59am | 0 | 0 | 2
7:00am-7:59am |  |  | 3.5 |  | 7:00am-7:59am |  |  | 2 |  | 7:00am-7:59am | 0 | 0 | 5.5
8:00am-8:59am |  |  | 5 |  | 8:00am-8:59am |  |  | 2 |  | 8:00am-8:59am | 0 | 0 | 7
9:00am-9:59am |  |  | 5.5 |  | 9:00am-9:59am |  |  | 2 |  | 9:00am-9:59am | 0 | 0 | 7.5
10:00am-10:59am |  |  | 5 |  | 10:00am-10:59am |  |  | 3 |  | 10:00am-10:59am | 0 | 0 | 8
11:00am-11:59am |  |  | 5 |  | 11:00am-11:59am |  |  | 3 |  | 11:00am-11:59am | 0 | 0 | 8
12:00pm-12:59pm |  |  | 5 |  | 12:00pm-12:59pm |  |  | 2 |  | 12:00pm-12:59pm | 0 | 0 | 7
1:00pm-1:59pm |  |  | 5 |  | 1:00pm-1:59pm |  |  | 2 |  | 1:00pm-1:59pm | 0 | 0 | 7
2:00pm-2:59pm |  |  | 4.5 |  | 2:00pm-2:59pm |  |  | 3 |  | 2:00pm-2:59pm | 0 | 0 | 7.5
3:00pm-3:59pm |  |  | 3.5 |  | 3:00pm-3:59pm |  |  | 3 |  | 3:00pm-3:59pm | 0 | 0 | 6.5
4:00pm-4:49pm |  |  | 1.5 |  | 4:00pm-4:49pm |  |  | 2 |  | 4:00pm-4:49pm | 0 | 0 | 3.5
5:00pm-5:59pm |  |  | 1 |  | 5:00pm-5:59pm |  |  | 2 |  | 5:00pm-5:59pm | 0 | 0 | 3
6:00pm-6:59pm |  |  | 1 |  | 6:00pm-6:59pm |  |  | 2 |  | 6:00pm-6:59pm | 0 | 0 | 3
7:00pm-8:00pm | 0 | 0 | 0 |  | 7:00pm-8:00pm |  |  | 2 |  | 7:00pm-8:00pm | 0 | 0 | 2
 | 0 | 0 | 48.5 |  |  | 0 | 0 | 30 |  |  | 0 | 0 | 78.5
Spreadsheet: frank_ermis__11033__Expansion Offer Sheet
Sheet: Example

Example Offer
Wild Goose Storage Inc. |  |  | April 1, 2004 Expansion Open Season |  |  |  | Offer Sheet
Term | commencing at | 2004-04-01 00:00:00 | and ending on | 2010-03-31 00:00:00
Inventory Capacity : |  | 1000000 | Dth. |  |  | [NAME] is 2:00 MST, Tuesday May 22, 2001
 | Maximum | Injection | Injection | Inventory | Inventory | Maximum Daily | Withdrawal | Withdrawal | Monthly
 | Daily Injection | Demand | Demand | Demand | Demand | Withdrawal | Demand | Demand | Storage Demand
Month | Quantity | Rate | Charge (A) | Rate | Charge (B) | Quantity | Rate | Charge (C) | Charge
 |  |  |  |  |  |  |  |  | (A)+(B)+(C)
 | Dth/day/month | $US/Dth/day/month | $US/month | $US/Dth/month | $US/month | Dth/day/month | $US/Dth/day/month | $US/month | $US/month
Rack Rate: |  | 3 |  | 0.03 |  |  | 2
April | 10000 | 4 |  | 0.03 |  | 10000 | 2 |  |  |  | Rack Rate
May | 10000 | 4 |  |  |  | 10000 | 2
June | 10000 | 4 |  |  |  | 10000 | 2
July | 8000 | 3 |  |  |  | 10000 | 2
August | 8000 | 3 |  |  |  | 10000 | 2
September | 10000 | 3 |  |  |  | 10000 | 2
October | 10000 | 4 |  |  |  | 10000 | 2
November | 10000 | 3 |  |  |  | 15000 | 3
December | 8000 | 3 |  |  |  | 20000 | 3
January | 8000 | 3 |  |  |  | 20000 | 3
February | 8000 | 3 |  |  |  | 15000 | 3
March | 8000 | 3 |  |  |  | 15000 | 2
 |  |  |  |  | Total Storage Demand Charge (US$) |  |  |  |  | Annual Demand charge effective April 1, 2004
 |  |  |  |  | Rack Rate
Injection Commodity Rate: |  |  | 0.02 | $US/Dth | 0.02 | $US/Dth |  |  | of Rack Rate
Withdrawal Commodity Rate: |  |  | 0.02 | $US/Dth | 0.02 | $US/Dth
This offer is open for acceptance by Wild Goose Storage Inc. until 2:00 pm MST, Thursday June 28, 2001.
 |  |  |  |  |  | Fax Offer Sheets to: [PHONE]
 |  |  |  |  |  | Attention: [NAME]
Company Name
Per:
 |  |  |  |  |  |  |  | 3900, 421 - 7th Avenue S.W.
 |  |  |  |  |  |  |  | Calgary, Alberta
 |  |  |  |  |  |  |  | Canada
Name: |  |  |  |  |  |  |  | T2P 4K9
Title:
Spreadsheet: 698180d1601832515-using-weekday-function-to-get-average-if-criteria-range-equals-weekday-electric
Sheet: Sheet6

 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 4
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 6
Utility | Utility | Month | LMP(BGE) | LMP(PECO) | Onpeak BGE
BGE |  | 2016-01-01 00:00:00
PECO
Spreadsheet: 80420d1280627563-word-in-a-column-adds-number-in-another-2010_book1
Sheet: Sheet1

 |  |  |  |  |  |  | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY
Monday |  | RED |  |  |  |  | 3 | 5 | 4 | 3 | 3 | 1 | 6
Friday |  | BLUE
Wednesday |  | YELLOW |  |  |  |  | RED | BLUE | YELLOW | GREEN
Sunday |  | GREEN |  |  |  |  | 5 | 5 | 5 | 10
Thursday |  | BLUE
Tuesday |  | YELLOW
Saturday |  | GREEN
Wednesday |  | RED
Tuesday |  | GREEN
Monday |  | BLUE
Thursday |  | GREEN
Tuesday |  | YELLOW
Sunday |  | RED
Tuesday |  | BLUE
Monday |  | YELLOW
Wednesday |  | RED
Saturday |  | GREEN
Monday |  | GREEN
Thursday |  | RED
Saturday |  | GREEN
Sunday |  | GREEN
Saturday |  | BLUE
Saturday |  | YELLOW
Saturday |  | GREEN
Monday |  | GREEN
Spreadsheet: 105880d1303153830-how-to-add-last-number-entered-book2
Sheet: Sheet2

31.125 | 0 | 0
30.75 | 0 | 0
30.5 | 0 | 0
30 | 0 | 0
29.625 | 0 | 0
29.125 | 0 | 0
28.75 | 0 | 0
28.375 | 0 | 0
28 | 0 | 0
27.5 | 0 | 0
27.125 | 0 | 0
26.625 | 0 | 0
26.25 | 0 | 0
25.875 | 0 | 0
25.5 | 0 | 0
25 | 0 | 0
24.75 | 0 | 0
24.25 | 0 | 0
23.75 | 0 | 0
23.375 | 0 | 0
23 | 0 | 0
22.5 | 0 | 0
22 | 31.125 | 9.125 | 9.125 | formula
30.875 | 0 | 0
30.5 |  | 0.625
Spreadsheet: 473393d1470180622-auto-populate-calendar-from-list-of-events-in-2-tables-ef945_calendar_two_tables
Sheet: Activities

Ref | Activity | Date | Day | Lang |  | Key:
 |  |  |  |  |  | English |  | Formulae in columns A to E already copied down to row 100 - copy further as required
 |  |  |  |  |  | Chinese
 |  |  |  |  |  |  |  | Other than that, no further input required on this sheet
Spreadsheet: 715054d1611522777-populate-calendar-in-excel-from-list-help-calendar-1-
Sheet: Sheet1

Date
2021-01-02 00:00:00 | Birthday | [NAME]
2021-01-15 00:00:00 | Anniversary | [NAME] ♥
2021-01-15 00:00:00 | Meeting | [NAME]
2021-01-10 00:00:00 | Birthday | Limor
2021-01-10 00:00:00 | Meeting | Aging
2021-02-10 00:00:00 | Meeting | Forecast
2021-02-15 00:00:00 | [NAME] | [NAME] †
2021-01-11 00:00:00 | Meeting | [NAME] † | [NAME]
2021-01-31 00:00:00 | Birthday | Another [NAME]
date | occasion (doesn't need to be populated) | name (bottom left of calendar square) | meeting (top right of calendar square)
2021-01-09 00:00:00 | birthday | [NAME]
2021-01-09 00:00:00 | anniversary | [NAME]
2021-01-10 00:00:00 | birthday | [NAME]
2021-01-10 00:00:00 | [NAME] | [NAME] †
2021-01-10 00:00:00 | meeting |  | [NAME]
Spreadsheet: 152376d1335367053-tranpose-data-excelforum
Sheet: Sheet1

Have Following date
Company Name: ABC
Products: XYZ
product category : Cosmo
Use: Cleaning
Application : Personal
Company Name: ABC1
Products: XYZ1
product category : Agri
Use: Pesti
Application : Field
Company Name: [NAME]
Products: XYZ1
product category : Agri
Use: Pesti
Application : Field
Company Name: ABC3
Products: XYZ
product category : Agri
Use: Pesti
Application : Field
Looking for following formate
Company Name | Products | product category | Use | Application
ABC | XYZ | Cosmo | Cleaning | Personal
ABC1 | XYZ1 | Agri | Pesti | Field
[NAME] | XYZ1 | Agri | Pesti | Field
ABC3 | XYZ | Agri | Pesti | Field
Spreadsheet: 678519d1589931578-counting-over-several-pages-and-if-conditions-arent-met-then-blank-iauditor-dashboard-for-example
Sheet: 21 Oct 19 - 26 Oct 19

IAuditor Health & Safety Docs Dashboard
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Percentage
Daily Pre Start - Foremen | 2019-10-21 00:00:00 | 2019-10-22 00:00:00 | 2019-10-23 00:00:00 | 2019-10-24 00:00:00 | 2019-10-25 00:00:00 | 2019-10-26 00:00:00 | ❌ | ✓ |  | Weekly Workplace Inspection  - Foremen | 21/10/2019 - 26/10/2019
Dameon | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Dameon | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Harley | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Harley | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  | 1 |  | [NAME] | ✓
Nathan | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Nathan | ✓
[NAME] | ✓ | ✓ | *** | ✓ | ✓ |  | 0.2 | 0.8 |  | [NAME] | N/A
[NAME] | ✓ | ✓ | ✓ | ✓ | *** |  | 0.2 | 0.8 |  | [NAME] | ❌
Tyson | A/L | A/L | ✓ | ✓ | ✓ | ✓ |  | 1 |  | Tyson | ✓
Will | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Will | N/A
Daily Pre Start - Contractors |  |  |  |  |  |  |  |  |  | Weekly Workplace Inspection  - Contractors
[NAME] |  |  |  |  |  |  |  |  |  | [NAME]
Daniel - Jaydee Roofing | ✓ | ✓ | ✓ | ❌ | ❌ |  | 0.4 | 0.6 |  | Daniel - Jaydee Roofing | ❌
Sharn - Valley Art Roofing |  |  |  |  |  |  |  |  |  | Sharn - Valley Art Roofing
Edge Protection [NAME] |  |  | 21/10/2019 - 26/10/2019 |  |  |  |  |  |  | Fortnightly [NAME] Foremen | 21/10/2019 - 26/10/2019
Bunnings |  |  | ✓ |  |  |  |  |  |  | Dameon | ✓
Tokyo Foods? |  |  |  |  |  |  |  |  |  | [NAME] | ✓
134 Antigua |  |  | ✓ |  |  |  |  |  |  | [NAME] | ✓
Move |  |  | ❌ |  |  |  |  |  |  | [NAME] | ✓
Blum |  |  | ✓ |  |  |  |  |  |  | [NAME] | ✓
Northlink |  |  | ❌ |  |  |  |  |  |  | Harley | ✓
[NAME] |  |  | ❌ |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Nathan | ✓
*** Means received but had to ask for it |  |  |  |  |  |  |  |  |  | [NAME] | N/A
❌   Means did not get one at all |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Tyson | ✓
 |  |  |  |  |  |  |  |  |  | Will | N/A
 |  |  |  |  |  |  |  |  |  | Fortnightly [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Daniel - Jaydee Roofing | ❌
 |  |  |  |  |  |  |  |  |  | Sharn - Valley Art Roofing
Spreadsheet: 867557d1714396371-countif-not-following-standart-when-add-new-line-testes
Sheet: BRAZIL

Contagem de casos | Coluna5 | Coluna4 | Coluna3 | Coluna2 | Coluna1 | Coluna6 | Coluna7 | Coluna8 | Coluna9 | Coluna10 | Coluna11 | Coluna12 | Coluna13 | Coluna14 | Coluna15 | Coluna16 | Coluna17 | Coluna18 | Coluna19 | Coluna20 | Coluna21 | Coluna22 | Coluna23 | Coluna24 | Coluna25
 |  | BBB
 |  | AAA
 |  | AAA
 |  | CCC
 |  | [NAME]
 |  | AAA
 |  | AAA
 |  | AAA
 |  | CCC
 |  | ZZZ
 |  | ZZZ
 |  | ZZZ
 |  | ZZZ
 |  | VVV
 |  | AAA
 |  | AAA
 |  | AAA
 |  | VVV
 |  | BBB
 |  | BBB
 |  | BBB
 |  | BBB
 | 2024-04-29 00:00:00 | AAA |  | AAA | AAAA
 |  | AAA
 |  | CCC
 |  | CCC
 |  | AAA
Spreadsheet: louise_kitchen__23838__2QYTD Orig
Sheet: Canada Power

Canada Power
Mid Year 2001
Originator |  | Commodity |  | Team |  | Total |  | %Total
Biever |  | Power |  | Canada |  | 2283200
Devries |  | Power |  | Canada |  | 500000
[NAME] |  | Power |  | Canada |  | 2127333
Law |  | Power |  | Canada |  | 138233
Davies |  | Power |  | Canada
Total
Spreadsheet: 739979d1626109141-returning-a-value-to-a-summary-page-from-multiple-sheets-excel-tracker
Sheet: Overview

Date | 1 Point Value | Outlay (£) | Outlay (Points)
2021-07-01 00:00:00 | 20
2021-07-02 00:00:00 | 20
2021-07-03 00:00:00 | 20
2021-07-04 00:00:00 | 20
2021-07-05 00:00:00 | 20
2021-07-06 00:00:00 | 20
2021-07-07 00:00:00 | 20
2021-07-08 00:00:00 | 20
2021-07-09 00:00:00 | 20
2021-07-10 00:00:00 | 20
2021-07-11 00:00:00 | 20
2021-07-12 00:00:00 | 20
2021-07-13 00:00:00 | 20
2021-07-14 00:00:00 | 20
2021-07-15 00:00:00 | 20
2021-07-16 00:00:00 | 20
2021-07-17 00:00:00 | 20
2021-07-18 00:00:00 | 20
2021-07-19 00:00:00 | 20
2021-07-20 00:00:00 | 20
2021-07-21 00:00:00 | 20
2021-07-22 00:00:00 | 20
2021-07-23 00:00:00 | 20
2021-07-24 00:00:00 | 20
2021-07-25 00:00:00 | 20
2021-07-26 00:00:00 | 20
2021-07-27 00:00:00 | 20
2021-07-28 00:00:00 | 20
2021-07-29 00:00:00 | 20
2021-07-30 00:00:00 | 20
2021-07-31 00:00:00 | 20
July | 20
Spreadsheet: 723657d1615822989-if-isnumber-formula-update-cells-with-character-depending-on-dates-actygation-holiday-forms-2021
Sheet: Colleague 11

HOLIDAY FORM 2021
NAME: |  |  |  | 2021 BANK HOLIDAY DATES | TAKEN Y/N (IF NO ADD LIEU DAY TO TABLE)
2021 HOLIDAY ENTITLEMENT |  |  |  | 01/01/2021 (New Years Day) | Y
To be completed - |  |  |  | 02/04/2021 (Good Friday) | N
2021 ENTITLEMENT |  | 25 |  | 05/04/2021 (Easter Monday) | N
CARRIED OVER FROM 2020 |  | 8 |  | 03/05/2021 (May Bank Hol) | N
LIEU DAYS |  | 0 |  | 31/05/2021 (May Bank Hol) | N
BOUGHT HOLIDAYS FOR 2021 |  | 0 |  | 30/08/2021 (Aug Bank Hol) | N
OTHER ENTITLEMENT (PLEASE ADD DETAILS) |  | 0 |  | 27/12/2021 (Xmas Day) | N
Reason: |  |  |  | 28/12/2021 (Xmas BH Day) | N
TOTAL FOR 2021:
HOLIDAY BOOKING PROCESS
1) | Send a request for holiday dates to your line manager
2) | Once approval is gained, issue a meeting invite to your line manager and direct team so they are aware of holiday dates
2) | Update this holiday form yourself and re-save on the network once approved
FROM | TO | DAYS | DAYS | AUTHORISED | DATE OF APPROVAL
 | (INCLUSIVE) | TAKEN | LEFT | BY
 |  |  | 33
2021-01-07 00:00:00 | 2021-01-07 00:00:00 | 0.5
23/07/21 | 26/07/21 | 2
27/08/21 | 31/08/21 | 2
15/09/21 | 24/09/21 | 8
19/03/21 | 19/03/21 | 1
Spreadsheet: kate_symes__18399__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2000-12-28 00:00:00 |  | 219.29 | 5600 | 180 | 296
 | 2000-12-27 00:00:00 |  | 396.43 | 2800 | 255 | 200 | 176.08 | 3130 | 186.7 | 684
 | 2000-12-26 00:00:00 |  | 461.25 | 1600 | 442.5 | 0 | 185 | 65 | 200 | 0
 | 2000-12-25 00:00:00 |  |  |  |  |  |  |  | 300 | 600
 | 2000-12-24 00:00:00 |  |  |  |  |  |  |  | 336.11 | 450
 | 2000-12-23 00:00:00 |  | 470.93 | 3440 | 311.96 | 1528 | 500 | 825 | 250 | 25
 | 2000-12-22 00:00:00 |  | 474.38 | 3200 | 290.77 | 1408 | 484.27 | 1335 | 300 | 25
 | 2000-12-21 00:00:00 |  | 476.11 | 3600 | 290.77 | 1408 | 500 | 1175 | 450 | 600
 | 2000-12-20 00:00:00 |  | 465.71 | 2800 | 375 | 200 | 529.93 | 2100 | 550 | 200
 | 2000-12-19 00:00:00 |  | 450 | 2400 | 346.89 | 1608 | 477.03 | 1720 | 210 | 697
 | 2000-12-18 00:00:00 |  | 377 | 2000 | 325 | 400 | 593.64 | 3048 | 423.21 | 1126
 | 2000-12-17 00:00:00 |  |  |  |  |  |  |  | 551.77 | 2065 |  | 325 | 600
 | 2000-12-16 00:00:00 |  | 306.88 | 3200 | 255.53 | 1808 | 587.5 | 1400 | 537.5 | 1200
 | 2000-12-15 00:00:00 |  | 306.88 | 3200 | 255.53 | 1808 | 571.38 | 3975 | 517.59 | 3375
 | 2000-12-14 00:00:00 |  | 484.61 | 5200 | 256.22 | 1608 | 654.11 | 730 | 437.04 | 1340
 | 2000-12-13 00:00:00 |  | 688.24 | 6800 | 500 | 200 | 454.83 | 6475 | 350 | 100
 | 2000-12-12 00:00:00 |  | 818.75 | 3200 | 300 | 200 | 800 | 0 | 600 | 0
 | 2000-12-11 00:00:00 |  | 3200 | 2800 | 1187.5 | 400 | 597.15 | 1192 | 561.22 | 245
 | 2000-12-10 00:00:00 |  |  |  |  |  |  |  | 740.4 | 5823 |  | 1187.5 | 1200
 | 2000-12-09 00:00:00 |  | 714.44 | 3600 | 400 | 200 | 450 | 450 | 487.5 | 0
 | 2000-12-08 00:00:00 |  | 714.44 | 3600 | 400 | 200 | 325 | 630 | 487.5 | 0
 | 2000-12-07 00:00:00 |  | 679.17 | 2400 | 412.5 | 400 | 505.96 | 235 | 320.47 | 265
 | 2000-12-06 00:00:00 |  | 357.3 | 9600 | 275 | 800 | 342 | 858 | 237.5 | 200
 | 2000-12-05 00:00:00 |  | 278.47 | 7600 | 245 | 200 | 388 | 125 | 237.5 | 0
 | 2000-12-04 00:00:00 |  | 283.12 | 10000 | 255 | 400 | 281.5 | 0 | 255 | 0
 | 2000-12-03 00:00:00 |  |  |  |  |  |  |  | 224 | 375 |  | 255 | 1200
 | 2000-12-02 00:00:00 |  | 270.77 | 12400 | 215 | 200 | 220 | 50 | 200 | 250
 | 2000-12-01 00:00:00 |  | 270.23 | 12800 | 215 | 200 | 246.54 | 517 | 217.5 | 0
 | 2000-11-30 00:00:00 |  | 253.35 | 6800 | 197.33 | 600 | 241.09 | 238 | 205 | 200
 | 2000-11-29 00:00:00 |  | 255.5 | 7200 | 200 | 200 | 264.07 | 295 | 235 | 50
 | 2000-11-28 00:00:00 |  | 256 | 7200 | 212.5 | 0 | 255.63 | 160 | 212.5 | 0
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 793525d1661523244-creating-a-schedule-that-then-creates-a-list-use-if-index-vlookup-appended-book
Sheet: MAIN

Total Count
Player | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |  | Unique list of names | [NAME]
[NAME] | 1
[NAME] | 3 |  | 3
Arnie B | 4
Balazs G | 2 |  | 3
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] |  | 999
King [NAME]
[NAME] |  |  |  |  |  | 8
[NAME] |  |  |  | 666
Spreadsheet: 804644d1668195490-i-need-a-formula-for-an-avg-of-a-data-set-found-on-multiple-sheets-but-must-exclude-zeroes-mmjj-drivosity-scores-test
Sheet: 1355

First | Last | 4 week Score Avg | 4 week Incident per [NAME] | Week 41 Score | Week 41 Incidents Per Mile | Week 42 Score | Week 42 Incidents Per Mile | Week 43 Score | Week 43 Incidents Per Mile | Week 44 Score | Week 44 Incidents Per Mile
[NAME] | Edwards |  |  | 95 | 0.83 | 93 | 1.35 | 91 | 1.6 | 89 | 2.07
Cormae | [NAME] |  |  | 98 | 0.47 | 93 | 1.05 | 93 | 1.47 | 97 | 0.62
Destiny | Prine-Atkins |  |  | 98 | 0.56 | 95 | 0.49 | 98 | 0.45 | 98 | 0.54
 | Store Average
Spreadsheet: 71538d1272322685-changing-arrow-colors-with-conditional-formatting-conditionalfomatcolorchange
Sheet: Sheet1

 |  |  |  | current color |  | new color
 |  | -0.8927118749671388 |  | red | decrease | orange
 |  | -0.7538659959686035 |  | green | increase | blue
 |  | -0.737738252122478 |  | gray | neutral | purple
 |  | -0.07331378299120227
 |  | -0.8927118749671388
 |  | -0.8364269141531323
 |  | -0.7972885732730794
 |  | -0.7951299311381548
 |  | -0.7481175613310663
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | -0.7064724474371307
 |  | -0.6712980442497923
Spreadsheet: 220423d1363159811-excel-page-layout-copy-data-book1
Sheet: Sheet1

I.D | Acc. No | Name | Address | Phone. No | Date | Deposite | Withdraw | Acc. Bal | I.D | Acc. No | Name | Address | Phone. No | Date | Deposite | Withdraw | Acc. Bal | I.D | Acc. No | Name | Address | Phone. No | Date | Deposite | Withdraw | Acc. Bal
A001 | 123456789 | [NAME] | - | - | 2012-05-06 00:00:00 | 100000 | 5000 |  | A002 |  |  | - | - | 2012-05-06 00:00:00 | 100000 | 5000 |  | A003 |  |  | - | - | 2012-05-06 00:00:00 | 100000 | 5000
 |  |  |  |  | 2012-06-15 00:00:00 | 50000 | 0 |  |  |  |  |  |  | 2012-06-15 00:00:00 | 50000 | 0 |  |  |  |  |  |  | 2012-06-15 00:00:00 | 50000 | 0
 |  |  |  |  | 2012-08-20 00:00:00 | 100000 | 200000 |  |  |  |  |  |  | 2012-08-20 00:00:00 | 100000 | 200000 |  |  |  |  |  |  | 2012-08-20 00:00:00 | 100000 | 200000
I.D | Acc. No | Name | Address | Phone. No | Date | Deposite | Withdraw | Acc. Bal | I.D | Acc. No | Name | Address | Phone. No | Date | Deposite | Withdraw | Acc. Bal | I.D | Acc. No | Name | Address | Phone. No | Date | Deposite | Withdraw | Acc. Bal
A004 |  |  | - | - | 2012-05-06 00:00:00 | 100000 | 5000 |  | A005 |  |  | - | - | 2012-05-06 00:00:00 | 100000 | 5000 |  | A006 | 123456789 | [NAME] | - | - | 2012-05-06 00:00:00 | 100000 | 5000
 |  |  |  |  | 2012-06-15 00:00:00 | 50000 | 0 |  |  |  |  |  |  | 2012-06-15 00:00:00 | 50000 | 0 |  |  |  |  |  |  | 2012-06-15 00:00:00 | 50000 | 0
 |  |  |  |  | 2012-08-20 00:00:00 | 100000 | 200000 |  |  |  |  |  |  | 2012-08-20 00:00:00 | 100000 | 200000 |  |  |  |  |  |  | 2012-08-20 00:00:00 | 100000 | 200000
I.D | Acc. No | Name | Address | Phone. No | Date | Deposite | Withdraw | Acc. Bal | I.D | Acc. No | Name | Address | Phone. No | Date | Deposite | Withdraw | Acc. Bal | I.D | Acc. No | Name | Address | Phone. No | Date | Deposite | Withdraw | Acc. Bal
A007 |  |  | - | - | 2012-05-06 00:00:00 | 100000 | 5000 |  | A008 |  |  | - | - | 2012-05-06 00:00:00 | 100000 | 5000 |  | A009 |  |  | - | - | 2012-05-06 00:00:00 | 100000 | 5000
 |  |  |  |  | 2012-06-15 00:00:00 | 50000 | 0 |  |  |  |  |  |  | 2012-06-15 00:00:00 | 50000 | 0 |  |  |  |  |  |  | 2012-06-15 00:00:00 | 50000 | 0
 |  |  |  |  | 2012-08-20 00:00:00 | 100000 | 200000 |  |  |  |  |  |  | 2012-08-20 00:00:00 | 100000 | 200000 |  |  |  |  |  |  | 2012-08-20 00:00:00 | 100000 | 200000