tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 215316d1361342705-30k-rows-how-do-i-identify-duplicate-rows-across-5-columns-and-delete-both-rows-workbook2
Sheet: Sheet1

 | Name | Date | Employee # | Qty. | Meal
 | [NAME] | 2012-08-24 00:00:00 | JC10-05-891 | 1 | B |  | 17 Rows to start with, inclusive of duplicate rows
 | [NAME] | 2012-08-24 00:00:00 | JC10-05-891 | 1 | B
 | [NAME] | 2012-08-24 00:00:00 | JC10-05-891 | 1 | L |  | 6 Duplicate Rows found
 | [NAME] | 2012-08-25 00:00:00 | JC10-05-891 | 1 | B |  | Because we're deleting the duplicate row AND the row it duplicates,
 | [NAME] | 2012-08-25 00:00:00 | JC10-05-891 | 1 | B |  | = 12 Rows need to be deleted
 | [NAME] | 2012-08-25 00:00:00 | JC10-05-891 | 1 | D
 | [NAME] | 2012-08-25 00:00:00 | JC10-05-891 | 1 | D |  | 5 unique rows would remain
 | [NAME] | 2012-08-25 00:00:00 | JC10-05-891 | 1 | L
 | Maria | 2012-08-25 00:00:00 | MJ10-06-992 | 1 | L
 | [NAME] | 2012-08-25 00:00:00 | CK10-82-470 | 1 | B
 | [NAME] | 2012-08-25 00:00:00 | CK10-82-470 | 1 | D
 | [NAME] | 2012-08-25 00:00:00 | CK10-82-470 | 1 | D
 | [NAME] | 2012-08-25 00:00:00 | CK10-82-470 | 1 | L
 | [NAME] | 2012-08-26 00:00:00 | CK10-82-470 | 1 | D
 | [NAME] | 2012-08-26 00:00:00 | CK10-82-470 | 1 | D
 | [NAME] | 2012-08-26 00:00:00 | CK10-82-470 | 1 | L
 | [NAME] | 2012-08-26 00:00:00 | CK10-82-470 | 1 | L
 | The result should look like this (5 unique rows remain
 | Name | Date | Employee # | Qty. | Meal
 | [NAME] | 2012-08-24 00:00:00 | JC10-05-891 | 1 | L
 | [NAME] | 2012-08-25 00:00:00 | JC10-05-891 | 1 | L
 | Maria | 2012-08-25 00:00:00 | MJ10-06-992 | 1 | L
 | [NAME] | 2012-08-25 00:00:00 | CK10-82-470 | 1 | B
 | [NAME] | 2012-08-25 00:00:00 | CK10-82-470 | 1 | L
Spreadsheet: 375d5b60-5faa-41e8-a08e-d4ce8496ee62
Sheet: Sheet1

Release: Job Openings and Labor Turnover | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=192
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-12-19 2:18 PM CST
 | Real-Time | Period
Name: | Start | End
Job Openings and Labor Turnover | 2010-08-11 00:00:00 | Current
Link:
http://www.bls.gov/jlt/ | 2010-08-11 00:00:00 | Current
Source:
US. Bureau of Labor Statistics | 2010-08-11 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2010-08-11 00:00:00
2010-09-08 00:00:00
2010-10-07 00:00:00
2010-11-09 00:00:00
2010-12-07 00:00:00
2011-01-11 00:00:00
2011-02-08 00:00:00
2011-03-11 00:00:00
2011-04-13 00:00:00
2011-05-11 00:00:00
2011-06-07 00:00:00
2011-07-12 00:00:00
2011-08-10 00:00:00
2011-09-07 00:00:00
2011-10-12 00:00:00
2011-11-08 00:00:00
2011-12-13 00:00:00
2012-01-10 00:00:00
2012-02-07 00:00:00
2012-03-13 00:00:00
2012-04-10 00:00:00
2012-05-08 00:00:00
2012-06-19 00:00:00
2012-07-10 00:00:00
2012-08-07 00:00:00
2012-09-11 00:00:00
2012-10-10 00:00:00
2012-11-06 00:00:00
2012-12-11 00:00:00
2013-01-10 00:00:00
2013-02-12 00:00:00
2013-03-12 00:00:00
2013-04-09 00:00:00
2013-05-07 00:00:00
2013-06-11 00:00:00
2013-07-09 00:00:00
2013-08-06 00:00:00
2013-09-10 00:00:00
2013-10-24 00:00:00
2013-11-22 00:00:00
2013-12-10 00:00:00
2014-01-17 00:00:00
2014-02-11 00:00:00
2014-03-11 00:00:00
2014-04-08 00:00:00
2014-05-09 00:00:00
2014-06-10 00:00:00
2014-07-08 00:00:00
2014-08-12 00:00:00
2014-09-09 00:00:00
2014-10-07 00:00:00
2014-11-13 00:00:00
2014-12-09 00:00:00
Spreadsheet: 748845d1632385177-vba-i-need-to-store-data-instead-of-only-keeping-1-number-at-a-time-sample-fitness-tracker-deployment-2021-with-users-
Sheet: Data1

 |  |  |  |  |  | Week 1
 |  | Points | Distance (KM) | Points | Time (Minutes) | Activity 1 | Activity 2 | Activity 3 | Activity 4 | Activity 5
None | --- | 0 | 0 | 0 | 0
PSP Class | Time (Minutes) | 0 | 0 | 5 | 60
Weight Lifting | Time (Minutes) | 0 | 0 | 3 | 30
Running | Distance (KM) | 1 | 1 | 0 | 0
Walking/Jogging | Distance (KM) | 1 | 3 | 0 | 0
Stationary Cycling | Time (Minutes) | 0 | 0 | 3 | 30
Martial Arts/Kickboxing | Time (Minutes) | 0 | 0 | 4 | 30
Yoga/Stretching | Time (Minutes) | 0 | 0 | 1 | 30
Sports | Time (Minutes) | 0 | 0 | 3 | 30
 |  | For Graph |  |  |  | Tuesday
 | Archive | points | %
 | Total Month
 |  | 80
 | Week 1
 | Week 2
 | Week 3
 | Week 4
Select Member | percentages for chart WEEK 1 |  |  | checkbox
[NAME]
Douglass
Ensom
Evans | percentages for chart WEEK 2 |  |  | checkbox
Grant
Gravel
Guhit
Hofperson | percentages for chart WEEK 3 |  |  | checkbox
[NAME]
Kozlov
[NAME]
Tetreault | percentages for chart WEEK 4 |  |  | checkbox
Vaughter
[NAME]
Wollf
 | percentages for total chart
Spreadsheet: 542844d1508143293-how-to-change-data-from-awkward-column-form-to-list-form-suitable-for-macro-harrys
Sheet: After

1 | A
2 | A
3 | A
4 | A
5 | B
6 | B
7 | B
8 | B
9 | B
10 | B
11 | C
12 | C
13 | D
14 | E
15 | E
16 | E
17 | E
18 | E
19 | E
20 | E
21 | E
22 | E
23 | E
24 | E
25 | E
26 | E
27 | E
28 | E
29 | F
30 | F
31 | G
32 | G
33 | G
34 | G
35 | G
36 | G
37 | G
38 | G
39 | G
Spreadsheet: geir_solberg__11263__06-18
Sheet: Sheet1

DATE | HR BEGIN | HR END | TOTAL HOURS | DELIVERY POINT | SUPPLY | MW PER HOUR | TOTAL MW | BOUGHT/ SOLD | EES PRICE
2001-06-18 00:00:00 | 1 | 5 | 5 | SP15 | EES | 7 | 35 | sold | 35
2001-06-18 00:00:00 | 7 | 8 | 2 | SP15 | EES | 13 | 26 | sold | 35
2001-06-18 00:00:00 | 9 | 9 | 1 | SP15 | EES | 11 | 11 | sold | 35
2001-06-18 00:00:00 | 10 | 10 | 1 | SP15 | EES | 7 | 7 | sold | 35
2001-06-18 00:00:00 | 11 | 11 | 1 | SP15 | EES | 2 | 2 | sold | 80
2001-06-18 00:00:00 | 16 | 22 | 7 | SP15 | EES | 2 | 14 | sold | 90
2001-06-18 00:00:00 | 2 | 2 | 1 | SP15 | EES | 3 | 3 | sold | 40
2001-06-18 00:00:00 | 3 | 3 | 1 | SP15 | EES | 5 | 5 | sold | 40
2001-06-18 00:00:00 | 4 | 4 | 1 | SP15 | EES | 4 | 4 | sold | 40
2001-06-18 00:00:00 | 5 | 5 | 1 | SP15 | EES | 1 | 1 | sold | 40
2001-06-18 00:00:00 | 22 | 22 | 1 | SP15 | EES | 21 | 21 | sold | 70
2001-06-18 00:00:00 | 6 | 6 | 1 | PV/SP15 | EPE | 1 | 1 | bought | 30
2001-06-18 00:00:00 | 7 | 7 | 1 | SP15 | EES | 17 | 17 | sold | 35
2001-06-18 00:00:00 | 8 | 8 | 1 | SP15 | EES | 8 | 8 | sold | 35
Spreadsheet: darrell_schoolcraft__7297__imball0112
Sheet: Amoco Abo

 | [NAME] |  | Amoco Abo fuel del
Day | Measured | Scheduled | Measured | Scheduled | Imbal
1 | 12873 | 10932
2 | 13275 | 10932
3 | 15491 | 10932 | -1
4 | 14090 | 10932 | -2
5 | 14451 | 10932 | -6
6 | 13027 | 10932 | -56
7 | 11185 | 10932 | -97
8 | 10655 | 10866
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  |  |  | 392389.58
2001-12-08 00:00:00
CBS Volume
 |  |  | -260608
Spreadsheet: 797314d1663821294-lookup-data-on-another-sheet-by-matching-data-in-two-columns-acl-hamakua
Sheet: HMR ACL

HAMAKUA AREA COST LEDGER
DATE | AREA CODE | JOB CODE | HRS | OT HRS | LABOR | EQUIP. | M/S | C/S | TOTAL | REMARKS
 |  | 112
Spreadsheet: 178981d1346972592-sum-cells-for-different-customers-different-spreadsheets-example
Sheet: Sheet1

OVERDUE | 10 days | 20 days | 30 days | 40 days
Customer1 | 1000 |  | 200
Customer2 |  | 256
Customer5 | 10000
Customer10 |  | 456 |  | 122
Customer3 | 4560
Customer7 |  | 3245235
Customer11 |  |  | 235
Customer22 | 235 | 23537 | 325
Spreadsheet: fd936dd0-5faf-4108-a8c0-1ad1a23fffbe
Sheet: Sheet1

ALSO® Provider Course PARTICIPANTS Information Form | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
IMPORTANT: Include ALL participants (including nurses) on this worksheet. Must indicate [NAME] of each.
NOTE: Please ensure that all gray cells/columns are completed, throughout entire form.
After completing both worksheets and obtaining AAFP Accreditation Approval, submit this Excel file by e-mail attachment to the
ALSO Program Staff for this course at the AAFP (listing at btm of this sheet).
Course Information |  | Participant Totals |  | IMPORTANT NOTE:  Sponsor MUST complete online accreditation application and receive the AAFP Accreditation approval e-mail BEFORE returning this form to ALSO Program Coordinator.
Course Date |  | FP Res
Course Sponsor/Provider |  | FP
Address |  | Nurses
City/State/Zip |  | CNM
Phone Number |  | [NAME]
Course Director |  | OBs |  | AAFP Accreditation Application #:
Course Coordinator |  | ER Res |  | Is ALSO a mandatory part of your curriculum (yes or no)?
Course Director E-mail |  | Other
Course Coordinator E-mail |  | Please ensure the above info reflects  your individual entries, below.
 |  | Total | 0
PARTICIPANT Information  (ALL PARTICIPANTS - INCLUDING NURSES. MUST indicate [NAME], below.) |  |  |  |  |  |  | Testing Information
aAll fields, below, MUST be completed! Any incomplete field will delay the processing of the course. aTYPE NAMES AS THEY SHOULD APPEAR ON CERTIFICATES AND WALLET CARDS. Do not use nicknames.  aPlease proof for typos. The certificates and wallet cards will be merged from the information on this spreadsheet. |  |  |  |  |  |  | Please enter the number of correct answers, not the  rate of percent
NEW REQUIREMENT: The Kansas State Board of Nursing requires that the CNE contact hours and license numbers for each nurse be included on this participant list.  ALL COLUMNS MUST BE COMPLETED! |  |  |  |  | KSBN Provider #: SP1243-1013
AAFP # (completed by ALSO staff) | Name (First   Last) DO NOT include degree | Discipline (MD/RN/DO, etc) | [NAME]  (Required) | Address, City, St, Zip (If address is not provided the sponsor address  will be used) | License Number - NURSES only | CNE for this course | Written Exam | Mega Score | Pass/ Fail
E-mail this form as an attachment with Instructor Candidate Evaluations to one of the following coordinators:
(If nurse participants, your Nurse Roster should be completed and e-mailed to ALSO Staff Coordinator within one week of your course).
[NAME] --  [EMAIL] (all states except PA, TX, CA)
[NAME] – [EMAIL]   (PA, TX, CA only)
[NAME] – [EMAIL] (Navy/FISC)
Spreadsheet: 816089d1675357740-help-countif-sample
Sheet: Sheet1

 | Record | Reviewer (1st initial, last name) | Were Medications  reviewed | Has PMA been update within the last year | Is the urine drug screen up to date | Is SOAPP check up to date | Was risk assessment documented | Was [NAME] prescribed with instructions | Was BPI completed | Was pain rated and percent documented at time of discharge
1
2
3
4
5
6
7
8
9
10
11
12
13
14 |  |  | y
15 |  |  | yes
16 |  |  | yes | yes | y
17 |  |  | no | no | n
18
19
20
21
22
23
24
25
26
27
28
29
30
Spreadsheet: 848350d1699061444-bringing-shift-pattern-into-a-rolling-calendar-ef1617a_calendar-with-4-shifts
Sheet: Calendar

Calendar |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023
 | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN |  |  | A Shift
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Key:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NIGHT
 | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN
 | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN
 | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN
Spreadsheet: benjamin_rogers__1221__UAE latest O&M costs from Scott
Sheet: Mob_Estimate

O&M Pre-Mobilization / Mobilization Cost Estimate
 |  |  | US $
O&M Pre-Mobilization Expenses
Mobilization Payroll & Burden
Mobilization Operating Expenses
 | Employee Expenses
 | Recruiting Expenses
 | Relocation Expenses
 | Outside Services
 | Other Supplies & Expenses
 | Communications
 | Temporary Offices/Facilities
 | Training
 | Manuals & Procedures
 | Permits
 | Insurance
 | Operations Support Personnel
 | Total Mobilization Operating Expenses
Mobilization Procurement Expenses
 | Office Furnishings & Equipment
 | Safety & Environmental Equipment
 | Vehicles & Mobile Equipment (excluding switch engine)
 | Warehouse Furnishings & Equipment
 | Laboratory Equipment
 | Shop Tools & Equipment
 | Chemicals, Lubricants, Hydraulic Fluids
 | Total Mobilization Procurement Expenses
Total O&M Pre-Mobilization / Mobilization Expenses
Housing Colony Mobilization |  |  | 0
Commercial Office Mobilization
Owners' Engineer
Initial Operating Spares
OM&A Mobilization Fee (incl. Commercial Office)
Operator Overhead Charge (G&A)
Spreadsheet: 585864d1534032179-reconcile-sheets-with-calendar-dates-in-rows-vs-dates-in-columns-fruit-example
Sheet: Folha1

Date | Name | Fruit | Quantity |  | Name | Fruit | City | 2018-01-01 00:00:00 | 2018-01-02 00:00:00 | 2018-01-03 00:00:00
2018-01-01 00:00:00 | [NAME] | orange | 6 |  | [NAME] | orange | NY | 3 | 4 | 0
2018-01-01 00:00:00 | [NAME] | lemon | 4 |  | [NAME] | lemon | LA | 0 | 0 | 4
2018-01-01 00:00:00 | Marta | orange | 6 |  | [NAME] | orange | LA | 2 | 4 | 0
2018-01-01 00:00:00 | Marta | lemon | 2 |  | [NAME] | lemon | NY | 4 | 4 | 2
2018-01-02 00:00:00 | [NAME] | orange | 8 |  | Marta | orange | NY | 3 | 2 | 0
2018-01-02 00:00:00 | [NAME] | lemon | 4 |  | Marta | apple | NY | 0 | 0 | 6
2018-01-02 00:00:00 | Marta | orange | 2 |  | Marta | Lemon | LA | 2 | 0 | 0
2018-01-03 00:00:00 | [NAME] | lemon | 4 |  | Marta | orange | LA | 3 | 0 | 3
2018-01-03 00:00:00 | [NAME] | lemon | 2
2018-01-03 00:00:00 | Marta | apple | 6
Spreadsheet: 157561d1337791392-help-with-combobox-output-lookup1
Sheet: Master

Name | Home Phone | Business Phone | Cell Phone
C
Z
D
K
P
T
Y
Spreadsheet: chris_germany__1933__Tallahasse Swing Cash Flow
Sheet: Actual Gas Flows

Date |  | Volume | Zone | Supplier | Comments
Tue | 2002-01-01 00:00:00 | 0
Wed |  | 0
Thu |  | 0
Fri |  | 0
Sat |  | 0
Sun |  | 925 | Zone 3 | Sequent
Mon |  | 0
Tue |  | 0
Wed |  | 885 | Zone 3 | Sequent
Thu |  | 885 | Zone 3 | Sequent
Fri |  | 2000 | Zone 3 | Sequent
Sat |  | 2000 | Zone 3 | Sequent
Sun |  | 2000 | Zone 3 | Sequent
Mon |  | 2000 | Zone 3 | Sequent
Tue |  | 2000 | Zone 3 | Sequent
Wed |  | 2000 | Zone 3 | Sequent
Thu |  | 2000 | Zone 3 | Sequent
Fri |  | 2000 | Zone 3 | Sequent
Sat |  | 0
Sun |  | 0
Mon |  | 0
Tue |  | 2000 | Zone 3 | Sequent
Wed |  | 0
Thu |  | 0
Fri |  | 0
Sat |  | 0
Sun |  | 0
Mon |  | 0
Tue |  | 0
Wed |  | 0
Thu |  | 0
 |  |  | Total Sales for Jan 2002, Sitara deal #1192959
Fri |  | 2000 | Zone 3 | Sequent | Sequent decided that doing business with ENA was too administrative and would not sell ENA gas after 2/1/02
Sat |  | 2000 | Zone 3 | Tenn Bear Creek Storage | Negotiated Tenn IT discount of $.1021 plus fuel and diverted gas from Entex to Tallahassee
Sun |  | 2000 | Zone 3 | Tenn Bear Creek Storage | Negotiated Tenn IT discount of $.1021 plus fuel and diverted gas from Entex to Tallahassee
Mon |  | 2000 | Zone 3 | Tenn Bear Creek Storage | Negotiated Tenn IT discount of $.1021 plus fuel and diverted gas from Entex to Tallahassee
Tue |  | 2000 | Zone 3 | Tenn Bear Creek Storage | Negotiated Tenn IT discount of $.1221 plus fuel and diverted gas from Entex to Tallahassee
Wed |  | 2000 | Zone 3 | Tenn Bear Creek Storage | Negotiated Tenn IT discount of $.1221 plus fuel and diverted gas from Entex to Tallahassee
Thu |  | 2000 | Zone 2 | Reliant
Fri |  | 2000 | Zone 3 | Reliant
Sat |  | 0 | Zone 3 | Reliant | There was misscommunication between ENA, [NAME], and Tallahassee about the swing gas for Sat and Sun.
Sun |  | 0 | Zone 3 | Reliant | There was misscommunication between ENA, [NAME], and Tallahassee about the swing gas for Sat and Sun.
Mon |  | 2000 | Zone 3 | Reliant
Tue |  | 2000 | Zone 3 | Reliant
Wed |  | 2000 | Zone 3 | Reliant
Thu |  | 2000 | Zone 3 | Reliant
Fri |  | 2000 | Zone 2 | Reliant
Sat |  | 0 |  |  | Tallahassee requested 0 for this day.
Sun |  | 0 |  |  | Tallahassee requested 0 for this day.
Mon |  | 0 |  |  | Tallahassee requested 0 for this day.
Tue |  | 0 |  |  | Enron Holiday - Tallahassee requested 0 for this day.
Wed
Thu
Fri
Sat
Sun
Mon
Tue
Wed
Thu
Spreadsheet: 100200d1298609186-month-to-date-and-year-to-date-sample
Sheet: DAILY SNAPSHOT

SAFETY DAILY SNAPSHOT |  |  |  | 2011-02-25 00:00:00
SAFETY STATISTICS
RISK MANAGEMENT | 24 HOURS | WTD | MTD | YTD
Daily Inspection Checklist | 0
SAO's | 0
Hazard ID's | 0
Take Times's | 0
JSA's Written | 0
DRUG AND ALCOHOL TESTING
Number of Employees Tested - PASSED | 0
Number of Employees Tested - FAILED | 0
INCIDENT/INJURY
Number of Incidents Reported | 0
Number of Incidents Near Misses Reported | 0
Number of Environmental Incidents Reported | 0
Equipment/Plant Damage | 0
First Aid Injuries (FAI) | 0
Medically Treated Injuries (MTI) | 0
Lost Time Injuries (LTI) | 0
Restricted Work Injuries (RWI) | 0
Spreadsheet: 807855d1670107986-how-to-convert-numbers-with-different-numbers-of-dps-to-text-with-the-same-number-of-dps-s666-pq-convert-numbers-with-different-numbers-of-dps-to-text-with-the-same-number-of-dps
Sheet: Sheet1

Acid | pKa | DisplayAs | Result
Acetamide | 0.63 | [NAME] (0.63) | [NAME]  (0.63)
Acetic acid | 4.757 | Acetic acid (4.757) | Acetic acid (4.757)
Acetoacetic acid | 3.58 | Acetoacetic acid (3.58) | Acetoacetic acid  (3.58)
[NAME] aniline | 4.6 | [NAME] aniline | [NAME] aniline (4.6)
Benzenesulfonic acid | 0.7 | Benzenesulfonic acid (0.7) | Benzenesulfonic acid  (0.7)
Chromic acid | -0.2 | Chromic acid (-0.2) | Chromic acid (-0.2)
Ethylenediaminetetraacetic acid (EDTA) | -0.21 | Ethylenediaminetetraacetic acid (EDTA) (-0.21) | Ethylenediaminetetraacetic acid (EDTA) (-0.21)
Hydrogen bromide | -9 | Hydrogen bromide (-9) | Hydrogen bromide (-9)
Spreadsheet: 965bae72-d620-484d-9a0b-4290b60df287
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
38888864 | 2013-12-08 18:09:16 | AXIS | 1 | 5 | 3 | 890726 | jcpast78 | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
38889070 | 2013-12-08 18:25:24 | ALLIES | 0 | 2 | 5 | 890726 | jcpast78 | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
Spreadsheet: 135430d1326053592-sum-across-worksheets-mtg-cards
Sheet: Antiquities

Name | Rarity | # Owned | Total # Owned
Amulet of Kroog | C
[NAME] | R
[NAME] | C
Argothian Pixies | C
Argothian Treefolk | C
[NAME] | U
Artifact Blast | C
Artifact Possession | C
Artifact Ward | C
Ashnod's Altar | U
Ashnod's Battle Gear | U
Ashnod's Transmogrant | U
Atog | C
[NAME] | C
[NAME] | R
Candelabra of Tawnos | R
Circle of Protection: Artifacts | U
[NAME] | U
[NAME] | C
Clockwork Avian | R
Colossus of Sardia | R
Coral Helm | R
Crumble | C
[NAME] | U
Damping Field | U
Detonate | U
Drafna's Restoration | C
Dragon Engine | C
[NAME] | U
Energy Flux | U
Feldon's Cane | U
Gaea's Avenger | R
Gate to Phyrexia | U
[NAME] | U
[NAME] | R
Grapeshot Catapult | C
[NAME] | U
Hurkyl's Recall | R
Ivory Tower | U
Jalum Tome | U
Martyrs of Korlis | U
Mightstone | U
Millstone | U
Mishra's Factory | U
Mishra's War Machine | R
Mishra's Workshop | R
Obelisk of Undoing | R
Onulet | U
Orcish Mechanics | C
Ornithopter | C
[NAME] | C
Power Artifact | U
Powerleech | U
Priest of Yawgmoth | C
Primal Clay | U
Rakalite | U
Reconstruction | C
Reverse Polarity | C
Rocket Launcher | U
Sage of Lat-Nam | C
Shapeshifter | R
Shatterstorm | R
Staff of Zegon | C
Strip Mine | U
[NAME] | U
Tablet of Epityr | C
Tawnos's Coffin | R
Tawnos's Wand | U
Tawnos's [NAME] | U
Tetravus | R
The Rack | U
Titania's Song | U
Transmute Artifact | U
Triskelion | R
Urza's Avenger | R
Urza's Chalice | C
Urza's Mine | U
Urza's Miter | R
Urza's Power Plant | U
Urza's Tower | U
Wall of Spears | U
Weakstone | U
Xenic Poltergeist | U
Yawgmoth Demon | R
[NAME] | C
Spreadsheet: 790517d1659754257-how-to-auto-calculate-available-frequency-and-non-availability-hours-test
Sheet: Office

No | Year | Month | Product Name | In Time | Out Time | Hrs | single hrs | 2 hrs | 3 hrs
1 | 2022 | January | SUN | 2022-01-02 09:30:00 | 2022-01-02 17:00:00
2 | 2022 | January | SIRIUS | 2022-01-02 11:00:00 | 2022-01-03 13:00:00
3 | 2022 | January | SPLENDOR | 2022-01-04 10:00:00 | 2022-01-05 10:00:00 |  |  |  |  |  |  |  | Available Frequency
4 | 2022 | January | EAGLE | 2022-01-04 18:00:00 | 2022-01-05 10:00:00 |  |  |  |  |  | Year | Month | 0 Product Hrs | 1 Product | 1 Prod hrs | 2 Product | 2 Prod Hrs | 3 Product | 3 Prod Hrs
5 | 2022 | January | GRANDE | 2022-01-06 01:00:00 | 2022-01-06 22:20:00 |  |  |  |  |  | 2022 | January |  |  |  |  |  | 1
6 | 2022 | January | HOEGH | 2022-01-06 06:40:00 | 2022-01-07 17:00:00
7 | 2022 | January | NUT | 2022-01-06 15:00:00 | 2022-01-08 09:30:00
8 | 2022 | January | [NAME] | 2022-01-11 01:54:00 | 2022-01-11 09:34:00 |  |  |  |  |  | Suppose month starts at 01st 00:00 hrs and ends on the last day at 23:59 , Can I calculate data in to the summary  ?
9 | 2022 | January | UNITY | 2022-01-14 13:42:00 | 2022-01-15 09:40:00
 |  |  |  |  |  |  |  |  |  |  | Year =  identify the year/s of the selected data set
Data Display |  |  |  |  |  |  |  |  |  |  | Month =  identify the month/s of the selected data set
1 product (single product) |  |  |  |  |  |  | 2 |  |  |  | 0 Product hrs =  Calculate how many hours in the particular year/month had no(Zero) product is available.
1 product (single product) |  |  |  |  |  |  | 2 |  |  |  | 1 Product = Calculate how many times (count )only one single product is available in the selected data set
1 product (single product) |  |  |  |  |  |  | 1 |  |  |  | 1 Prod hrs = Calculate how many hours only one product is available in the selected data set
1 product (single product) |  |  |  |  |  |  | 2 |  |  |  | 2 Product = Calculate how many times (count )only two products are available in the selected data set
2 Products available |  |  |  |  |  |  | 1 |  |  |  | 2 Prod hrs= Calculate how many hours only two products are available in the selected data set
2 Products available |  |  |  |  |  |  | 1 |  |  |  | 3 Product = Calculate how many times (count )only three products are available in the selected data set
2 Products available |  |  |  |  |  |  | 1 |  |  |  | 3 Prod hrs= Calculate how many hours only three products are available in the selected data set
2 Products available |  |  |  |  |  |  | 1
3 Products available |  |  |  |  |  |  | 1
0 product hours
from date |  | To Date |  | Total Hours
2022-01-01 00:00:00 |  | 2022-01-02 09:30:00
2022-01-03 13:00:00 |  | 2022-01-04 10:00:00
2022-01-05 10:00:00 |  | 2022-01-06 01:00:00
2022-01-08 09:30:00 |  | 2022-01-11 01:54:00
2022-01-11 09:34:00 |  | 2022-01-14 13:42:00
2022-01-15 09:40:00 |  | 2022-01-31 23:59:00
Spreadsheet: 876421d1723109715-excel-count-sum-filter-functions-with-dates-excel_countifs_v3
Sheet: Hit Ratio month+cumulative

ASM | Month | QTY Quotation | [NAME] |  | ASM | Cumulative | QTY Quotation | [NAME]
Fehling | 2023-01-01 00:00:00 |  |  |  | Fehling | 2023
[NAME] |  |  |  |  | [NAME]
Rödhammer |  |  |  |  | Rödhammer
Fragoso |  |  |  |  | Fragoso
Harder |  |  |  |  | Harder
Willem |  |  |  |  | Willem
Segatto |  |  |  |  | Segatto
Whitlam |  |  |  |  | Whitlam
[NAME] |  |  |  |  | [NAME]
Vizuete |  |  |  |  | Vizuete
ASM | Month | QTY Quotation | [NAME] |  | ASM | Cumulative | QTY Quotation | [NAME]
Fehling | 2024-07-01 00:00:00 |  |  |  | Fehling | 2024
[NAME] |  |  |  |  | [NAME]
Rödhammer |  |  |  |  | Rödhammer
Fragoso |  |  |  |  | Fragoso
Harder |  |  |  |  | Harder
Willem |  |  |  |  | Willem
Segatto |  |  |  |  | Segatto
Whitlam |  |  |  |  | Whitlam
[NAME] |  |  |  |  | [NAME]
Vizuete |  |  |  |  | Vizuete