tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 686504d1594659615-avoiding-deleting-information-as-the-year-begins-2020-07-13-oeldere-sunboy-pt-686478d1594650501-avoiding-deleting-information-as-the-year-begi
Sheet: Sheet1

ZW$ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year | 2019 |  |  | Month | January
Sales Journal
Date | Customer Code | Name | Vat Number | Invoice | Amount | Vat % | [NAME] | Amount incl [NAME] | Payment Terms | YEAR | MONTH | DAY |  | 1919-01-01 00:00:00 | 1919-02-01 00:00:00 | 1919-03-01 00:00:00 | 1919-04-01 00:00:00 | 1919-05-01 00:00:00 | 1919-06-01 00:00:00 | 1919-07-01 00:00:00 | 1919-08-01 00:00:00 | 1919-09-01 00:00:00 | 1919-10-01 00:00:00 | 1919-11-01 00:00:00 | 2020-12-01 00:00:00 | Year to date
2019-01-01 00:00:00 | C001 |  |  | 123 | 10000 | 0.15 |  |  | 20
1919-01-02 00:00:00 | C002 |  |  | 124 | 20000 |  |  |  | 30
1919-02-03 00:00:00 | C005 |  |  | 125 | 30000
1919-02-04 00:00:00 | C010 |  |  | 126 | 40000 |  |  |  |  |  |  |  |  | Question 1: |  | I want excel formula that when I click  at P2 and T2 to show the report for 2020, the Sales Journal has transcations for  2019
1919-03-05 00:00:00 | C001 |  |  | 127 | 5000 |  |  |  |  |  |  |  |  |  |  | and 2020 (in red). The above report is showing the report for 2019.
1919-06-06 00:00:00 | C002 |  |  | 128 | 10000 |  |  |  | 20
1919-04-07 00:00:00 | C005 |  |  | 129 | 15000 |  |  |  |  |  |  |  |  | Question 2: |  | Requesting for formula which will detect that the invoice number is already used in the sales Journal.
1919-05-08 00:00:00 | C010 |  |  | 130 | 20000 |  |  |  |  |  |  |  |  |  |  | and is it possible to have formula for incrementing invoice number?
1919-06-01 00:00:00 | C001 |  |  | 131 | 2000
1919-07-02 00:00:00 | C002 |  |  | 132 | 4000 |  |  |  | 10 |  |  |  | 2019 |  | INVOICE
1919-08-03 00:00:00 | C005 |  |  | 133 | 6000 |  |  |  |  |  |  |  | 2020
1919-09-04 00:00:00 | C010 |  |  | 134 | 8000 |  |  |  |  |  |  |  | 2021 |  | Name of Company |  |  |  |  | Date
1919-10-05 00:00:00 | C001 |  |  | 135 | 1000 |  |  |  |  |  |  |  | 2022 |  | Address
1919-11-06 00:00:00 | C002 |  |  | 136 | 2000 |  |  |  |  |  |  |  |  |  | Telephone |  |  |  |  | Invoice Number
1919-12-07 00:00:00 | C005 |  |  | 137 | 3000 |  |  |  |  |  |  |  | January
1920-01-08 00:00:00 | C010 |  |  | 138 | 4000 |  |  |  |  |  |  |  | February
2020-01-01 00:00:00 | C001 |  |  | 139 | 80000 | 0.15 |  |  | 20 |  |  |  | March |  | Product Code |  | Product |  | Qnty | Unity Price |  | Total
2020-01-02 00:00:00 | C002 |  |  | 140 | 10000 |  |  |  | 30 |  |  |  | April |  | A-001 |  | Bread |  | 7000 | 1
2020-02-03 00:00:00 | C005 |  |  | 141 | 30000 |  |  |  |  |  |  |  | June |  | S-020 |  | Sugar |  | 1500 | 2
2020-02-04 00:00:00 | C010 |  |  | 142 | 40000
2020-03-05 00:00:00 | C001 |  |  | 143 | 5000 |  |  |  |  |  |  |  |  |  | Total
2020-07-14 00:00:00 | C002 |  |  | 144 | 10000 |  |  |  | 20
Spreadsheet: 106274d1303439632-exclude-a-match-condition-between-two-data-fields-example
Sheet: Sheet1

 | April | May | Count
 | [PHONE] | [PHONE] | 1
 | [PHONE] | [PHONE] | 1
 | [PHONE] | [PHONE] | 1
 | [PHONE] | [PHONE] | 1
 | [PHONE] | [PHONE] | 1
 | [PHONE] | [PHONE] | 0
 | [PHONE] | [PHONE] | 0
 | [PHONE] | [PHONE] | 0
 | [PHONE] | [PHONE] | 0
 | [PHONE] | [PHONE] | 0
 |  |  | 5 | total of new tickets
 | Yellow indicates ticket carried over so should not be counted
 | Red indicates the ticket closed - therefore it should not be counted
 | Green indicates the new tickets
Spreadsheet: 758093d1638639566-return-value-based-on-more-or-less-than-0-sample-workbook_12042021
Sheet: Expected Output

Company | Account | AU | Sub Acct | CAAS | Currency | Amount
Spreadsheet: kevin_hyatt__19599__Derailment_Summary
Sheet: Commodity Dollars

Transwestern Pipeline Company
Train Derailment - Commodity Volumes Unable to Transport on Firm Contracts
OUTAGES
 |  | 2000-10-30 00:00:00 | 2000-10-31 00:00:00 |  | 2000-11-01 00:00:00 | 2000-11-02 00:00:00 | 2000-11-03 00:00:00 | 2000-11-04 00:00:00 |  | Total
Commodity [NAME] on Firm Contracts
Train Derailment
East of Thoreau to West |  | -538300 | -538300 |  | -538300 | -538300 | -538300 | -538300
San Juan to East |  | -100000 | -100000 |  | -100000 | -100000 | -100000 | -100000
[NAME] to El Paso |  | -131200 | -93300 |  | -101700 | -123100 | -100600 | -56200
San Juan to Thoreau
East of Thoreau to East of Thoreau
Volume Additions
Alternate points for East to West Contracts |  | 226100 | 303200 |  | 82800 | 196100 | 219800 | 269600
Rates
Train Derailment
East of Thoreau to West |  | 0.0268 | 0.0268 |  | 0.0268 | 0.0268 | 0.0268 | 0.0268
San Juan to East |  | 0.0104 | 0.0104 |  | 0.0104 | 0.0104 | 0.0104 | 0.0104
[NAME] to El Paso |  | 0.0011 | 0.0011 |  | 0.0011 | 0.0011 | 0.0011 | 0.0011
San Juan to Thoreau
East of Thoreau to West
Volume Additions
Alternate points for East to West Contracts |  | 0.0186 | 0.0186 |  | 0.0186 | 0.0186 | 0.0186 | 0.0186
Margins
Train Derailment
East of Thoreau to West
San Juan to East
[NAME] to El Paso
San Juan to Thoreau
East of Thoreau to West
Volume Additions
Alternate points for East to West Contracts
Total Lost Commodity Margins
Spreadsheet: 708978d1608116815-rounding-percentages-to-add-up-to-100-excel_help
Sheet: Sheet2

 | Aaa | Bbb | CCC | DDD |  | Aaa | Bbb | CCC | DDD | Total
 | 8.69 | 13.08 | 46.6 | 31.63
 | 2.58 | 7.05 | 89.13 | 1.24 |  |  |  |  |  | 100
 | 6.73 | 57.82 | 29.7 | 5.75 |  |  |  |  |  | 75 | note: does not add up to 100 causing problem, is there a way to solve this?
 | 6.88 | 15.55 | 72.31 | 5.25 |  |  |  |  |  | 100
 | 30.51 | 19.69 | 18.94 | 30.86 |  |  |  |  |  | 100
 | 31.3 | 25.26 | 19.73 | 23.72 |  |  |  |  |  | 100
 | 29.13 | 16.4 | 19.87 | 34.61 |  |  |  |  |  | 100
 | 21.62 | 28.69 | 24.58 | 25.12 |  |  |  |  |  | 100
 | 27.3 | 17.82 | 17.86 | 37.01 |  |  |  |  |  | 100
Spreadsheet: mary_fischer__25622__87P
Sheet: E14.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 087P
COMPANY NAME  EFS Water Treatment Services
ANALYSIS OF OTHER DEFERRED CREDITS
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
EXTENSION:[PHONE]
 |  | 12-31-2000 Balance |  |  |  | Charged to |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash (Pd) / Rec'd |  | Income Statement |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(1)  PROVIDE DETAIL OF INDIVIDUAL ITEMS IN EXCESS OF $200,000
(2)  USE COMMENTS SECTION TO PROVIDE AN EXPLANATION OF WHY ANY REVENUE
ITEMS ARE DEFERRED AND WHAT EVENT WILL CAUSE REVENUE RECOGNITION
OTHER DEFERRED CREDITS:
Total (Hyperion line 0860)
Asset/Expense Accts:  DR/(CR)
Reverse signs from Hyperion
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
Spreadsheet: 024d4d20-af3d-4eb4-9c53-e8d2a7b767e5
Sheet: Sheet1

Academic Program Plan for Practical Nursing - Diploma | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Last Name, First Name Middle: |  |  |  |  |  | Program code:  511613401
Student ID: |  |  |  |  |  | Date Admitted:  Fall 2014
Address:
Phone: |  |  |  | Projected Graduation Date:  Fall 2015, December
[NAME]:
Student Signature: |  |  |  |  |  | Date:
Advisor Signature: |  |  |  |  |  | Date:
Authorizing Signature: |  |  |  |  |  | Date:
General [NAME] |  |  |  | Credits | Semester Taken or Recommended
AHS 100 | Human Growth & Development OR |  |  | 2
PSY 110 | General Psychology AND |  |  | (3)
PSY 223 | Developmental Psychology |  |  | (3)
BIO 135 | Basic Anatomy & Physiology w/ Lab OR |  |  | 4
BIO 137 | Human Anatomy & Physiology I AND |  |  | (4)
BIO 139 | Human Anatomy & Physiology II |  |  | (4)
TEC 200 | Technical Communications OR |  |  | 3
COM 181 | Basic Public Speaking OR |  |  | (3)
COM 252 | Introduction to Interpersonal Communications OR |  |  | (3)
ENG 101 | Writing 1 |  |  | (3)
 | Practical Nursing Program Courses
NPN 100 | Nursing and Health Care |  |  | 2
NPN 105 | Caregiver Role |  |  | 6
NPN 110 | Pharmacology I |  |  | 2
NPN 201 | Childbearing Family |  |  | 3
NPN 125 | Mental Health |  |  | 3
[NAME] 130 | Pharmacology II |  |  | 3
[NAME] 135 | Intro to Health Deviations |  |  | 6
NPN 200 | Medical - Surgical 1 |  |  | 5
NPN 205 | Medical - Surgical 2 |  |  | 5
NPN 210 | Clinical Practicum |  |  | 4
NPN 215 | Nursing Trends and Issues |  |  | 1
Total hours for Diploma |  |  |  | 49
NOTE:  The Academic Program Plan (APP) is to be updated by the faculty advisor and reviewed with the student at the end of
each semester to ensure that the student is aware of all courses required for graduation.
1. FYE 105/GEN 100 is required for students who have no college credits (has college credits) Yes or No:
2.  If no previous college credits, then FYE 105 or GEN 100  -  TERM & GRADE:
Completed prior to PN enrollment; Digital (Computer) Literacy Course (3 credit hrs): TERM & GRADE:
1. Prior to enrollment into PN course; if not HST101, then State Registered Nurse Aide-Expiration Date:
2. Prior to enrollment into PN course; if not SRNA, then HST101, Basic Skills I-Term & Grade:
Minimum ACT scores are: |  |  |  | Reading-20 | [NAME] | Writing/English-18
ACT Scores:
Minimum Compass Scores are: |  |  |  | Reading-85 | Algebra-36 | Writing/English-74
Compass Scores:
After Admission |  | End of 1st Semester |  | Date | End of 2nd Semester |  |  | Date
Student Signature:
Advisor Signature:
 |  |  |  |  |  |  | Revised 01/2014
Spreadsheet: 796826d1663586269-adding-a-further-criterion-to-an-existing-formula-in-order-to-create-a-tiebreak-ramsey
Sheet:  Master

 |  | HOLE |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18 | Total |  |  |  | Stroke Index |  |  | RESULTS |  |  |  |  |  |  |  | HANDICAPPING ALTERATIONS
1 | PLAYER | PAR |  | 4 |  | 4 |  | 4 |  | 3 |  | 4 |  | 4 |  | 4 |  | 4 |  | 5 |  | 3 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 3 |  | 5 |  | 4 |  |  | PAR | PTS | Playing H'Cap |  |  | MASTERS | LAST | CAMB |  | HANDICAP | NEW |  |  | 36 | Winners | Other |  | H'cap |  | catagory
1 |  | S/I |  | 17 |  | 5 |  | 9 |  | 15 |  | 3 |  | 1 |  | 7 |  | 13 |  | 11 |  | 8 |  | 12 |  | 16 |  | 2 |  | 10 |  | 4 |  | 18 |  | 14 |  | 6 | GROSS | NETT | 3 |  | S/I 1 | S/I 2 | S/I 3 |  | CHANCE |  | POST | CHANGE | HANDICAP |  |  |  | Cuts | Cuts | Increase | Change
0 | ADAMS (Brian)
0 | ADAMS ([NAME])
1 | BATTERBEE ([NAME])
0 | BAXTER (Nick)
1 | BENNETT ([NAME])
0 | BROMLEY ([NAME])
0 | CURT ([NAME])
1 | CURT (Sean)
0 | DERBYSHIRE ([NAME])
1 | DONNELLY ([NAME]) |  | 4 |  | 6 |  |  |  |  |  |  |  | 4
0 | DOWNER ([NAME])
1 | [NAME] ([NAME]) |  | 4 |  | 6 |  |  |  |  |  |  |  | 5
0 | GELLMAN ([NAME])
0 | GIBOIN ([NAME])
1 | GROUT ([NAME])
0 | [NAME] (Stuart)
1 | [NAME])
1 | [NAME] ([NAME])
1 | [NAME] ([NAME])
0 | [NAME] ([NAME])
0 | [NAME] ([NAME])
1 | KOLEK ([NAME])
1 | KOLEK ([NAME])
1 | LEECH ([NAME])
1 | LEECH ([NAME])
1 | LEONARD ([NAME])
1 | LEONARD ([NAME])
1 | [NAME] ([NAME])
1 | LOOM (Scott)
1 | MARVESLEY ([NAME])
0 | MCGILLIVRAY ([NAME])
0 | MCINTYRE ([NAME])
0 | MCKENZIE ([NAME])
0 | MEMOLI ([NAME])
1 | MITCHELL ([NAME])
1 | MOSS ([NAME])
1 | MUNTING ([NAME])
0 | NOONS (Martin)
0 | [NAME] ([NAME])
0 | [NAME] ([NAME])
0 | PYM ([NAME])
0 | SMITH ([NAME])
1 | SMITH ([NAME])
0 | TAYLOR ([NAME])
1 | VANN (Martin)
0 | ANDREWS ([NAME])
0 | ATKINS (Allen)
0 | BUCKLE (Eugene)
0 | BURNETT ([NAME])
0 | CLARKE ([NAME])
0 | CRONIN ([NAME])
0 | [NAME] ([NAME])
0 | FAWCETT ([NAME])
0 | HAMMOND ([NAME])
0 | KING ([NAME])
0 | [NAME] (Trevor)
0 | MCDONALD ([NAME])
0 | PRESTON ([NAME])
0 | SPENCER ([NAME])
1 | THORPE ([NAME])
1 | VALENTINE ([NAME])
0 | WARREN (Derek)
0 | WEEKS ([NAME])
1 | WILLS (Stuart)
0 | WOODFORD ([NAME])
 | Number of Players
 | SKINS
 | 1
 |  | HOLE |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18 | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Cuts
 |  | PAR |  | 4 |  | 4 |  | 4 |  | 3 |  | 5 |  | 4 |  | 4 |  | 4 |  | 5 |  | 3 |  | 4 |  | 4 |  | 5 |  | 4 |  | 4 |  | 3 |  | 5 |  | 4
 |  | S/I |  | 16 |  | 4 |  | 18 |  | 14 |  | 10 |  | 8 |  | 2 |  | 12 |  | 6 |  | 7 |  | 15 |  | 13 |  | 5 |  | 9 |  | 1 |  | 17 |  | 11 |  | 3 | GROSS
 | Average Score
 | PARS
 | BIRDIES
 | Total Score
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Francis "Topper" McFaun

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
No response
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
No response
Health Care: Continuing System Reform
Agree
Explain your health care reform position, if you choose
My amendment to the state healthcare reform law ;as you remember my work with union reps; insured the
right to collective bargining concerning healthcare
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
No response
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
No response
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | 97 Sunset Rd  Barretown Vt.05641 | State Representative | Yes |  | Washington
Spreadsheet: 145704d1331719288-autofill-across-worksheets-ef57_sample-workbook
Sheet: Marketing Plan

 | MARKETING PLAN FORM
 |  |  |  | Year 3 |  |  |  | Year 4 |  |  |  | Year 5
 | Marketing Decisions |  | Qtr. 1 | Qtr. 2 | Qtr. 3 | Qtr. 4 | Qtr. 1 | Qtr. 2 | Qtr. 3 | Qtr. 4 | Qtr. 1 | Qtr. 2 | Qtr. 3 | Qtr. 4
1 | Product Price ($) | Market 1 | 375 | 370 | 360 | 370 | 370 | 350 | 350 | 350 | 355 | 345 | 345 | 340
2 |  | Market 2 | 330 | 325 | 330 | 350 | 360 | 340 | 345 | 345 | 350 | 340 | 340 | 350
3 |  | Market 3 | 290 | 300 | 320 | 340 | 350 | 330 | 335 | 335 | 345 | 335 | 335 | 340
4 | Advertising ($1000) | Market 1 | 325 | 350 | 380 | 380 | 400 | 450 | 450 | 410 | 440 | 450 | 500 | 585
5 |  | Market 2 | 325 | 370 | 380 | 380 | 380 | 400 | 400 | 400 | 430 | 440 | 485 | 575
6 |  | Market 3 | 300 | 410 | 410 | 410 | 410 | 450 | 430 | 415 | 420 | 440 | 500 | 600
7 | Salespersons | Market 1 | 19 | 20 | 27 | 28 | 28 | 29 | 30 | 27 | 24 | 24 | 20 | 18
8 |  | Market 2 | 24 | 25 | 17 | 19 | 20 | 24 | 29 | 27 | 27 | 27 | 27 | 27
9 |  | Market 3 | 12 | 10 | 12 | 20 | 22 | 25 | 29 | 27 | 22 | 20 | 18 | 20
10 | Product R&D ($1000) |  | 60 | 65 | 250 | 350 | 500 | 650 | 650 | 650 | 600 | 500 | 235 | 225
11 | [NAME]. (%) |  | 0.42 | 0.84 | 1.1 | 1.95 | 3.01 | 3.75 | 3.75 | 3.75 | 3.9 | 5 | 5.25 | 5.4
 | Forcasted Sales
12 | Sales in Units | Market 1
13 |  | Market 2
14 |  | Market 3
15 |  | Total
16 | Sales ($) | Market 1 | 63569 | 53999 | 69856 | 65288 | 55606 | 62513 | 74222 | 78365 | 86253 | 83647 | 123667 | 169099
17 |  | Market 2 | 63569 | 53999 | 69856 | 65288 | 55606 | 62513 | 74222 | 78365 | 86253 | 83647 | 123667 | 169099
18 |  | Market 3 | 63569 | 53999 | 69856 | 65288 | 55606 | 62513 | 74222 | 78365 | 86253 | 83647 | 123667 | 169099
19 |  | Total
Spreadsheet: 823564d1680016422-how-can-i-convert-this-google-sheet-formula-to-excel-test-stock-portfolio-trackergk
Sheet: Portfolio Summary

Total Portfolio Cost
Total Portfolio Value
Total Value Portfolio Cost
Total Value Portfolio Value
Total Value Portfolio Unrealised Gain/Loss
Total Value Portfolio Realised Gain/Loss
Total Value Portfolio Dividends Collected
Expected Value Portfolio Income
Expected Value Portfolio Income Yield on Cost
Total Special Situation Portfolio Cost
Total Special Situation Portfolio Value
Total Special Situation Portfolio Unrealised Gain/Loss
Total Special Situation Portfolio Realised Gain/Loss
Total Special Situation Portfolio Dividends Collected
Expected Special Situation Portfolio Income
Expected Special Situation Portfolio Income Yield on Cost
Total Growth Portfolio Cost
Total Growth Portfolio Value
Total Growth Portfolio Unrealised Gain/Loss
Total Growth Portfolio Realised Gain/Loss
Total Growth Portfolio Dividends Collected
Expected Growth Portfolio Income
Expected Growth Portfolio Income Yield on Cost
Total Dividend Portfolio Cost
Total Dividend Portfolio Value
Total Dividend [NAME] Gain/Loss
Total Dividend [NAME] Gain/Loss
Total Dividend Portfolio Dividends Collected
Expected Dividend Portfolio Income
Expected Dividend Portfolio Income Yield on Cost
Spreadsheet: 737533d1624457953-if-function-across-multiple-sheets-sample
Sheet: Week 1 & 2

 | Week 1/2 | Off Weekends | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Weekly Total | Call #
FT
1 | [NAME] |  | 6:30-2:30 | 6:30-2:30 | 6:30-2:30 |  |  | 6:30-2:30 | 6:30-2:30 | 6:30-2:30 | 6:30-2:30 | 6:30-2:30 |  |  | 6:30-2:30 | 6:30-2:30
 |  |  | 7.5 | 7.5 | 7.5 |  |  | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 |  |  | 7.5 | 7.5
 |  |  | A | A | A |  |  | A | A | A | A | A |  |  | A | A
2 | Jane A |  | 11:00-7:00 | 11:00-7:00 | 11:00-7:00 |  |  | 11:00-7:00 | 11:00-7:00 | 11:00-7:00 | 11:00-7:00 | 11:00-7:00 |  |  | 11:00-7:00 | 11:00-7:00
 |  |  | 7.5 | 7.5 | 7.5 |  |  | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 |  |  | 7.5 | 7.5
 |  |  | B | B | B |  |  | B | B | B | B | B |  |  | B | B
Spreadsheet: 868842d1715564596-custom-calendar-help-dynamic-calendar-3-
Sheet: JUL

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B | C | D
 |  | D |  | D |  | D |  | A |  | A |  | A
 |  | C |  | C |  | C |  | B |  | B |  | B
A |  | C |  | C |  | C |  | C |  | B |  | B
B |  | D |  | D |  | D |  | D |  | A |  | A
B |  | B |  | D |  | D |  | D |  | D |  | A
A |  | A |  | C |  | C |  | C |  | C |  | B
A |  | A |  | A |  | C |  | C |  | C |  | C
B |  | B |  | B |  | D |  | D |  | D |  | D
B |  | B |  | B |  | B
A |  | A |  | A |  | A
Spreadsheet: 109985d1306790396-sum-values-for-customers-values-in-multiple-worksheets-my-example
Sheet: Apr

Invoiced
Fiat | Sales | Invoice | PO | Ship Date | Ford | Sales | Invoice | PO | Ship Date
Customer 1 | 1500 | 667788 | 22 | 2011-03-15 00:00:00 | Customer 6 | 7000 | 345777 | 222 | 2011-01-01 00:00:00
Customer 3 | 8000 | 778899 | 101 | 2011-05-01 00:00:00 | Customer 3 | 8000 | 222222 | 108469 | 2011-02-01 00:00:00
Customer 5 | 1000 | 889910 | 105 | 2011-06-01 00:00:00 | Customer 1 | 90000 | 432324 | 108532 | 2011-05-24 00:00:00
Customer 3 | 20000 | 880099 | 89 | 2011-03-20 00:00:00 | Customer 6 | 2000 | 121212 | 333 | 2011-06-23 00:00:00
Open Orders
Fiat | Sales | Order No. | PO | Ship Date | Ford | Order No. | Proforma | PO | Ship Date
Customer 8 | 1375 | 334332 | 5469 |  | Customer 7 | 1375 | 445543 | 1231
Customer 7 | 191.95 | 1194504 | 2309 |  | Customer 6 | 191.95 | 1194504 | 2386
Spreadsheet: 670250d1585806051-complex-timesheet-template-sample-timesheet-fish31-_revised_2020-04-02
Sheet: Sheet2

 |  |  |  |  |  |  |  |  | Week End: | 2020-04-03 00:00:00
Date | Task | Date | Time In | Break Start | Break End | Time Out | Total Hrs | Hrs | [NAME] | Task B Hrs | Task B OT Hrs | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 |  | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00
Saturday |  |  | 09:00:00 | 12:30:00 | 13:30:00 | 18:00:00
 | Task B
Sunday |  |  | 09:00:00 | 12:30:00 | 13:30:00 | 18:00:00
 | Task B |  |  |  | 18:00:00 | 19:00:00
Monday |  |  |  |  | 13:30:00 | 17:00:00
 | Task B |  | 09:00:00 | 12:30:00 | 17:00:00 | 18:00:00
Tuesday |  |  | 09:00:00 | 12:30:00 | 13:30:00 | 18:00:00
 | Task B
Wednesday |  |  | 09:00:00 | 12:30:00 | 13:30:00 | 18:00:00
 | Task B
Thursday |  |  |  |  | 13:30:00 | 17:00:00
 | Task B |  | 09:00:00 | 12:30:00 | 17:00:00 | 18:00:00
Friday |  |  | 09:00:00 | 12:30:00 | 13:30:00 | 18:00:00
 | Task B
Spreadsheet: 772432d1647272673-excel-formula-to-display-top-10-most-recuurence-text-value-excel_book1
Sheet: Sheet1

 | 2022-03-02 00:00:00 | 2022-03-03 00:00:00 | 2022-03-04 00:00:00 | 2022-03-05 00:00:00 | 2022-03-06 00:00:00 | 2022-03-07 00:00:00 | 2022-03-08 00:00:00
MU | MU | B | A | B | C
F | B | B | C | B | A
RMIT | C | B | C | A | C
CASS | A | B | C | A | C
E | A | A | D | D | B
F | D | C | D | D | B
G | B | C | E | C | D
H | B | D | B | C | E
I | E | D | B | E | A
J | C | D | B | F | A
Top 10 Occurrence
Least Occurrence
Spreadsheet: 165370d1341203411-summing-linked-cells-july-sched-ed
Sheet: LEGS

100 | 101 | 102 | 103
02:45:00 | 18:45:00 | 03:00:00 | 18:45:00
[NAME] | GEO | YYZ | GEO
GEO | [NAME] | GEO | YYZ
08:15:00 | 01:00:00 | 09:00:00 | 01:30:00
Spreadsheet: 849841d1700222925-novice-attempting-a-work-schedule-shift-schedule
Sheet: hours

Cummings [NAME] | E | 08:00:00 | 17:00:00 |  |  |  | dec | E3 | 09:00:00 | 23:00:00
 | E1 | 08:00:00 | 15:00:00 |  |  |  |  | A2 | 16:00:00 | 23:00:00
 | A1 | 13:00:00 | 22:00:00 |  |  |  |  | E2 | 08:00:00 | 22:00:00
 | E2 | 08:00:00 | 22:00:00 |  |  |  |  | E | 08:00:00 | 17:00:00
 | A1 | 14:00:00 | 23:00:00 |  |  |  |  | A3 | 15:00:00 | 22:00:00
 | E2 | 08:00:00 | 22:00:00 |  |  |  |  | E2 | 08:00:00 | 22:00:00
 |  |  |  |  |  |  |  | E3 | 09:00:00 | 23:00:00
 |  |  |  | tot hrs | day average |  |  | A1 | 14:00:00 | 23:00:00
 | E3 | 09:00:00 | 23:00:00
 | A2 | 16:00:00 | 23:00:00
 | A3 | 15:00:00 | 22:00:00
Spreadsheet: 0b5104c5-e661-4462-abbd-9f854941edbf
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
2805 | 15406 | Alberto | Bethaz | ITA
2805 | 15405 | [NAME] | Winter | GER
Spreadsheet: 22238d1210862371-how-to-lock-an-image-clip-art-into-place-test-report
Sheet: Sheet1

 |  |  | BACKFLOW PREVENTION ASSEMBLY
 |  |  | TEST REPORT
 | Facility Name: |  |  |  |  |  |  |  |  |  |  |  | Date:
 | Bldg Address: |  |  |  |  |  |  |  |  |  |  |  | WO:
 | Owner: |  |  |  |  |  |  |  |  | Contact:
 | Ph: |  |  |  |  | Fax: |  |  |  | E-mail:
 | Device Location: |  |  |  |  |  |  |  |  |  |  | Existing         Replacement
 | Protection Type:    Domestic           Fire            Other |  |  |  |  |  |  |  |  |  | Type of Device:
 | Make |  |  |  |  | Model |  |  |  |  | Serial#
 | Device accessable:  Yes          No          Device free from external leaks or damage:   Yes          No               Past inspection reports available:   Yes          No
 | Forward Flow Testing for Fire Protection Devices
 | [NAME] |  |  |  | System Demand |  |  | gpm | [NAME] |  |  |  |  | gpm | Total |  |  | gpm
 | Residual Pressure |  |  |  | [NAME]
 | Static Pressure |  |  |  | [NAME] |  |  |  |  |  | Forward Flow Test Passed      Yes           No
Spreadsheet: 161925d1339673812-excel-2007-formula-counting-double-data-entries-as-one-copy-of-copy-of-copy-of-copy-of-count1-1
Sheet: Countif

 |  |  |  |  | Marcol |  |  | romperstomper |  |  | dewilk
 |  |  |  | Data | Counting | 17 |  | Counting | 17 |  | Expected Result | 8
 |  |  |  | 15 | 1 |  |  | 1 |  |  | 1
 |  |  |  | 15 | 1 |  |  | 1 |  |  | 1
 |  |  |  | 30 | 2 |  |  | 2 |  |  | 2
 |  |  |  | 30 | 2 |  |  | 2 |  |  | 2
 |  |  |  | 60 | 3 |  |  | 3 |  |  | 3
 |  |  |  | 110 | 4 |  |  | 4 |  |  | 4
 |  |  |  | 125 | 5 |  |  | 5 |  |  | 5
 |  |  |  | 125 | 5 |  |  | 5 |  |  | 5
 |  |  |  | 31 | 6 |  |  | 6 |  |  | 6
 |  |  |  | 0 | 7 |  |  | 7 |  |  | 7
 |  |  |  | 6 | 8 |  |  | 8 |  |  | 8
 |  |  |  |  | 9 |  |  | 9 |  |  | 8
 |  |  |  |  | 10 |  |  | 10 |  |  | 8
 |  |  |  |  | 11 |  |  | 11 |  |  | 8
 |  |  |  |  | 12 |  |  | 12 |  |  | 8
 |  |  |  |  | 13 |  |  | 13 |  |  | 8
 |  |  |  |  | 14 |  |  | 14 |  |  | 8
 |  |  |  |  | 15 |  |  | 15 |  |  | 8
 |  |  |  |  | 16 |  |  | 16 |  |  | 8
 |  |  |  |  | 17 |  |  | 17 |  |  | 8
Spreadsheet: 742179d1627568637-pulling-specific-dates-from-one-sheet-into-another-using-data-validation-drop-down-testsheet2-ans
Sheet: Day Breakdown

June
Date
Start of 1st
Date
Driving Hours:
Date
Driving Hours:
Date
Driving Hours:
Date
Driving Hours:
Date
Driving Hours:
Date
Driving Hours:
Date
Driving Hours:
Date
Driving Hours:
Date
Driving Hours:
Date
Driving Hours:
Date
Driving Hours:
Date
Driving Hours:
Date
Driving Hours:
Date
Driving Hours:
Date
Driving Hours:
Date
Driving Hours:
Date
Driving Hours:
Date
Driving Hours:
Date
Driving Hours:
Date
Driving Hours:
Date
Driving Hours: