tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 115825d1311320437-parsing-a-data-table-pivot
Sheet: data

date | location | species | count
2011-07-06 00:00:00 | [NAME] | red | 650
2011-07-06 00:00:00 | [NAME] | white | 14211
2011-07-06 00:00:00 | [NAME] | white | 340
2011-07-06 00:00:00 | Shepards Fork | red | 580
2011-07-08 00:00:00 | Shepards Fork | red | 10020
2011-07-08 00:00:00 | [NAME] | white | 1050
2011-07-08 00:00:00 | [NAME] | red | 360
2011-07-08 00:00:00 | [NAME] | white | 7830
2011-07-08 00:00:00 | [NAME] | white | 34
2011-07-15 00:00:00 | Shepards Fork | red | 61
2011-07-15 00:00:00 | Shepards Fork | red | 13541
2011-07-15 00:00:00 | [NAME] | red | 200
2011-07-15 00:00:00 | [NAME] | white | 1781
2011-07-15 00:00:00 | [NAME] | red | 160
2011-07-15 00:00:00 | [NAME] | white | 8301
2011-07-15 00:00:00 | [NAME] | white | 6754
2011-07-23 00:00:00 | Shepards Fork | red | 61
2011-07-23 00:00:00 | [NAME] | white | 432
2011-07-23 00:00:00 | [NAME] | white | 54
Spreadsheet: 145d192e-b3f6-4abc-8069-52f213d489ca
Sheet: Language

Language | Titles | Percent
French | 59
Spanish | 41
German | 35
Italian | 22
Swedish | 17
Japanese | 16
Russian | 16
Norwegian | 9
Turkish | 9
Arabic | 7
Chinese | 7
Dutch | 6
Polish | 6
Danish | 5
Greek | 4
Hebrew | 4
Icelandic | 4
Portuguese | 4
Bulgarian | 3
Catalan | 3
Hungarian | 3
Persian | 3
Finnish | 2
Various | 2
Afrikaans | 1
Azerbaijani | 1
Croatian | 1
Estonian | 1
Hindi | 1
Irish | 1
Korean | 1
Latvian | 1
Lithuanian | 1
Romanian | 1
Urdu | 1
Welsh | 1
Yiddish | 1
Spreadsheet: 27617d1221001956-adjacent-cells-in-non-adjacent-list-sample
Sheet: Sheet1

January | List 1 | List 2 | List 3 | List 4 | List 5 | List 6 |  | February | List 1 | List 2 | List 3 | List 4 | List 5 | List 6
[NAME] | 102 | 102 | 102 | 102 | 102 | 102 |  | [NAME] | 212 | 212 | 212 | 212 | 212 | 212
[NAME] | 103 | 103 | 103 | 103 | 103 | 103 |  | [NAME] | 213 | 213 | 213 | 213 | 213 | 213
Julie | 104 | 104 | 104 | 104 | 104 | 104 |  | Julie | 214 | 214 | 214 | 214 | 214 | 214
[NAME] | 105 | 105 | 105 | 105 | 105 | 105 |  | [NAME] | 215 | 215 | 215 | 215 | 215 | 215
[NAME] | 106 | 106 | 106 | 106 | 106 | 106 |  | [NAME] | 216 | 216 | 216 | 216 | 216 | 216
[NAME] | 107 | 107 | 107 | 107 | 107 | 107 |  | [NAME] | 217 | 217 | 217 | 217 | 217 | 217
[NAME] | 108 | 108 | 108 | 108 | 108 | 108 |  | [NAME] | 218 | 218 | 218 | 218 | 218 | 218
Lydia | 109 | 109 | 109 | 109 | 109 | 109 |  | Lydia | 219 | 219 | 219 | 219 | 219 | 219
Spreadsheet: 675653d1588404511-sumifs-multiple-conditions-with-numbers-stored-as-text-example
Sheet: Sheet

Example
 |  | Volume Bought per Shipment Period (SOYBEANS)
 |  | Branch\Shipment | 2020-01 | 2020-02 | 2020-03 | 2020-04 | 2020-05 | 2020-06 | 2020-07 | 2020-08 | 2020-09 | 2020-10 | 2020-11 | 2020-12
 |  | 501
 |  | 403
 |  | 402
 |  | 401
 |  | Volume Bought per Shipment Period (CORN)
 |  | Branch\Shipment | 2020-01 | 2020-02 | 2020-03 | 2020-04 | 2020-05 | 2020-06 | 2020-07 | 2020-08 | 2020-09 | 2020-10 | 2020-11 | 2020-12
 |  | 501
 |  | 403
 |  | 402
 |  | 401
Spreadsheet: 755856d1637147826-create-a-rolling-4-week-13-week-avaerage-only-taking-into-account-full-weeks-example
Sheet: Sheet1

Range | Target | Predicted | COM | Vs. Target | Vs. Predicted | Conversion
4 Week
13 Week
YTD
Week Ending | Target | Predicted | COM | Vs. RDT | Vs. Predicted | Conversion
2021-07-09 00:00:00 | 15 | 17 | 15
2021-07-16 00:00:00 | 14 | 16 | 14
2021-07-23 00:00:00 | 16 | 18 | 14
2021-07-30 00:00:00 | 12 | 15 | 12
2021-08-06 00:00:00 | 11 | 14 | 13
2021-08-13 00:00:00 | 12 | 16 | 14
2021-08-20 00:00:00 | 13 | 16 | 13
2021-08-27 00:00:00 | 14 | 14 | 13
2021-09-03 00:00:00 | 14 | 18 | 16
2021-09-10 00:00:00 | 14 | 17 | 17
2021-09-17 00:00:00 | 15 | 17 | 15
2021-09-24 00:00:00 | 14 | 18 | 15
2021-10-01 00:00:00 | 15 | 14 | 11
2021-10-08 00:00:00 | 15 | 15 | 14
2021-10-15 00:00:00 | 14 | 16 | 16
2021-10-22 00:00:00 | 13 | 16 | 14
2021-10-29 00:00:00 | 10 | 14 | 14
2021-11-05 00:00:00 | 13 | 15 | 14
2021-11-12 00:00:00 | 10 | 12 | 11
2021-11-19 00:00:00 | 14 | 16 | 12
2021-11-26 00:00:00
2021-12-03 00:00:00
2021-12-10 00:00:00
2021-12-17 00:00:00
2021-12-24 00:00:00
2021-12-31 00:00:00
2022-01-07 00:00:00
2022-01-14 00:00:00
2022-01-21 00:00:00
2022-01-28 00:00:00
2022-02-04 00:00:00
2022-02-11 00:00:00
2022-02-18 00:00:00
2022-02-25 00:00:00
2022-03-04 00:00:00
2022-03-11 00:00:00
2022-03-18 00:00:00
2022-03-25 00:00:00
Spreadsheet: 764500d1642770484-problem-comparing-differing-numerical-ranges-comparitive-mark-example
Sheet: Sheet1

Group 1 | Group 2 |  | Comparitive Mark Output
98.84615384615384 | 73.2191390991211
91.1651728553137 | 76.42401123046875
98.98305084745763 | 79.15064239501953
97 | 76.14583587646484
97.38562091503267 | 76.14583587646484
98.87640449438203 | 76.0658950805664
98.50523168908819 | 73.71666717529297
100 | 79.55745697021484
93.65384615384616 | 75.625
100 | 77.60948944091797
97.74266365688487 | 77.99458312988281
98.37837837837837 | 76.55228424072266
100 | 80.43553161621094
98.52941176470588 | 76.73228454589844
99.70282317979198 | 79.85133361816406
93.24522760646109 | 74.96975708007812
89.95363214837712 | 75.55640411376953
96.35416666666667 | 75.7622299194336
95.74468085106383 | 80.1224136352539
100 | 78.1505355834961
99.75579975579976 | 74.439453125
Spreadsheet: 729154d1618935772-aggregate-with-multiple-criterias-headcount-example
Sheet: Data

Soc Sec | Employee | Salary | Name | Emp rate | Unit | CC | FTE | Heads | KORR heads | KORR fte |  | Heads |  |  |  |  | #[NAME] mars 2021
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0 | 0
Spreadsheet: 071530eb-d07a-4a83-9d10-f259d74031f1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
CITY OF OCEANSIDE
ENGINEERING DIVISION
COMPLETE THE INFORMATION BELOW
Project Address: |  |  |  |  |  |  |  |  |  | APN:
Owner Name: |  |  |  |  |  |  |  |  |  | Phone:
Owner Signature: (Must be authorized to sign for owner) |  |  |  |  |  |  |  |  |  | Cell:
Mailing Address: |  |  |  |  |  |  |  |  |  | Fax:
City/State/Zip |  |  |  |  |  |  |  |  |  | E-Mail:
Detailed description of vacation area:
Please state why the easement should be vacated:
Are there existing facilities in the easement?   Yes  □    No  □
Will you be relocating facilities currently existing within the easement to be vacated?   Yes  □    No  □
Is there any existing easement(s) overlapping the proposed easement area to be vacated? Yes  □   No  □
If the answer is yes to the above question, please attach copy of recorded document(s).
If the easement to be vacated was granted to the City by separate document, please attach copy of the recorded document.
Is this vacation associated with a project?   Yes □   No □   List Project File No:                                Project Plan No:
Use back of the application or attach additional sheets if needed.
ENGINEER/SURVEYOR INFORMATION IS REQUIRED-PLEASE COMPLETE
Applicant (If different from owner) |  |  |  |  |  |  |  |  |  | Phone:
 |  |  |  |  |  |  |  |  |  | Cell:
Mailing Address: |  |  |  |  |  |  |  |  |  | Fax:
City/State/Zip |  |  |  |  |  |  |  |  |  | E-Mail:
Surveyor/Engineer/Company: |  |  |  |  |  |  |  |  |  | Phone:
Contact (If different from above) |  |  |  |  |  |  |  |  |  | Cell:
Mailing Address: |  |  |  |  |  |  |  |  |  | Fax:
City/State/Zip |  |  |  |  |  |  |  |  |  | E-Mail:
Submittal Check List: |  |  |  |  |  | □ | Conditions of Approval
□ | Easement Vacation Application |  |  |  |  | □ | Supporting Deeds/Reference Maps
□ | Assessor's [NAME] |  |  |  |  | □ | Plat Map, Legal Description (Exhibit A & B) 8 copies.
□ | Preliminary Title Report |  |  |  |  | □ | Traverse Closure
□ | Environmental Information Form (Planning) |  |  |  |  | □ | Pictures of the area
□ | Environmental Review Request (Planning) |  |  |  |  | □ | Copy of Grant of Easement to the City
□ | Clearance Letter from Utility Companies
Fee $ |  | Environmental Review fee        (When Applicable) |  |  |  | Received By: |  |  |  | Plan Checker:
Paid      □ Yes  □ No |  | Paid     □ Yes  □ No |  |  |  | Date Submitted: |  |  |  | Permit No. EASV
NOTE: The legal owner(s) of the parcel involved will be responsible for the accuracy of all information submitted in connection with this application. By accepting the application, the City of Oceanside, its officers, boards, commissioners, employees, agents and representatives, make no warranties, expressed or implied, that the application for easement dedication will be approved. The review fees are non-refundable.
Incomplete submittal will not be reviewed and will be sent back to the applicant.
Spreadsheet: 185301d1349632627-tricky-puzzle-sum-and-indirect-formula-issue-resource_allocation_asim
Sheet: ISP857

PAGE 5 |  | PROJECT RESOURCES
PROJ ID: |  | PROJ NAME: |  |  |  |  | PROJ MANAGER: | [NAME] |  |  | DIRECTORATE:
Resource Types & Named Individuals | Apr |  |  |  | May |  |  |  |  | Jun |  |  |  | Jul |  |  |  | Aug |  |  |  |  | Sep |  |  |  | Oct |  |  |  |  | Nov |  |  |  | Dec |  |  |  | Jan |  |  |  |  | Feb |  |  |  | Mar |  |  |  | Totals
 | 2012-04-08 00:00:00 | 2012-04-15 00:00:00 | 2012-04-22 00:00:00 | 2012-04-29 00:00:00 | 2012-05-06 00:00:00 | 2012-05-13 00:00:00 | 2012-05-20 00:00:00 | 2012-05-27 00:00:00 | 2012-06-03 00:00:00 | 2012-06-10 00:00:00 | 2012-06-17 00:00:00 | 2012-06-24 00:00:00 | 2012-07-01 00:00:00 | 2012-07-08 00:00:00 | 2012-07-15 00:00:00 | 2012-07-22 00:00:00 | 2012-07-29 00:00:00 | 2012-08-05 00:00:00 | 2012-08-12 00:00:00 | 2012-08-19 00:00:00 | 2012-08-26 00:00:00 | 2012-09-02 00:00:00 | 2012-09-09 00:00:00 | 2012-09-16 00:00:00 | 2012-09-23 00:00:00 | 2012-09-30 00:00:00 | 2012-10-07 00:00:00 | 2012-10-14 00:00:00 | 2012-10-21 00:00:00 | 2012-10-28 00:00:00 | 2012-11-04 00:00:00 | 2012-11-11 00:00:00 | 2012-11-18 00:00:00 | 2012-11-25 00:00:00 | 2012-12-02 00:00:00 | 2012-12-09 00:00:00 | 2012-12-16 00:00:00 | 2012-12-23 00:00:00 | 2012-12-30 00:00:00 | 2013-01-06 00:00:00 | 2013-01-13 00:00:00 | 2013-01-20 00:00:00 | 2013-01-27 00:00:00 | 2013-02-03 00:00:00 | 2013-02-10 00:00:00 | 2013-02-17 00:00:00 | 2013-02-24 00:00:00 | 2013-03-03 00:00:00 | 2013-03-10 00:00:00 | 2013-03-17 00:00:00 | 2013-03-24 00:00:00 | 2013-03-31 00:00:00
Week Ending | Hours forecast/worked per week
Project Management
Jonn glover | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 7.5
Unassigned
Total PM
Project Managers (signature):
DBA SQL
Insert names
Total DBA SQL
Resource Manager (signature):
DBA Oracle
Insert names
Unassigned
Total DBA Oracle
Resource Manager (signature):
Systems Admin
Insert names
Unassigned
Total Systems Admin
Resource Manager (signature):
Networking
Insert names
Unassigned
Total Networking
Resource Manager (signature):
Client Devices
Total Client Devices
Resource Manager (signature):
Business Applications - GIS
Insert names
Unassigned
Total Business Apps - GIS
Resource Manager (signature):
Business Applications - LLPG
Insert names
Unassigned
Total Business Apps - LLPG
Resource Manager (signature):
Business Applications - Core Apps
Insert names
Unassigned
Total Business Apps - Core Apps
Resource Manager (signature):
Business Applications - IMS
Insert names
Unassigned
Total Business Apps - IMS
Resource Manager (signature):
Core Services
Insert names
Unassigned
Total Core Services
Resource Manager (signature):
Security
Insert names
Unassigned
Total Security
Resource Manager (signature):
Systems Integration - Integration
Insert names
Unassigned
Total SI - Integration
Resource Manager (signature):
Systems Integration - App Development
Insert names
Unassigned
Total SI - App Development
Resource Manager (signature):
Spreadsheet: 289b27f3-ee27-41ed-9e56-88012f6c3301
Sheet: vols added monographs

Monograph Volumes Added FY11 and FY12
Monograph Volumes Added by Acquisition Type (Kingston only)
Acquisition Type | FY11 | FY12 | % change | % of total FY12 vols.
Approval Plan (Strand) | 3715 | 2371
Firm orders | 3901 | 3430
Standing orders | 151 | 182
Gifts | 2903 | 3039
TOTALS
Average Price of Monograph (Kingston only)
 | FY11 | FY12 | % change
Amount spent | 337819.13 | 328758.15
[NAME] purchased | 7767 | 5983
Average price paid per volume
Spreadsheet: 29457d1224496357-anyone-supply-a-formula-for-excel-2007-spreadsheet-book1
Sheet: Sheet1

1 |  | gym |  |  |  |  | I want column E to look like column K |  |  | gym
1 |  |  |  |  |  |  |  |  |  | gym
1 |  |  |  |  |  |  |  |  |  | gym
1 |  |  |  |  |  |  |  |  |  | gym
1 |  |  |  |  |  |  |  |  |  | gym
1 |  |  |  |  |  |  |  |  |  | gym
2 |  | shop |  |  |  |  |  |  |  | shop
2 |  |  |  |  |  |  |  |  |  | shop
2 |  |  |  |  |  |  |  |  |  | shop
2 |  |  |  |  |  |  |  |  |  | shop
3 |  | home |  |  |  |  |  |  |  | home
3 |  |  |  |  |  |  |  |  |  | home
3 |  |  |  |  |  |  |  |  |  | home
4 |  | work |  |  |  |  |  |  |  | work
4 |  |  |  |  |  |  |  |  |  | work
4 |  |  |  |  |  |  |  |  |  | work
4 |  |  |  |  |  |  |  |  |  | work
4 |  |  |  |  |  |  |  |  |  | work
Spreadsheet: 714252d1611154103-lookup-for-1st-2nd-3rd-etc-occurrences-from-list-book2
Sheet: Sheet1

 | SECTION A
 | ITEM 01
 | ITEM 02
 | ITEM 03
 | ITEM 04
 | SECTION B
 | ITEM 01
 | ITEM 02
 | ITEM 03
 | ITEM 04
 | ITEM 05
 | SECTION C
 | ITEM 01
 | ITEM 02
 | SECTION D
 | ITEM 01
 | ITEM 02
 | ITEM 03
 | ITEM 04
1st | SECTION A
2nd | SECTION B
3rd | SECTION C
4th | SECTION D
Spreadsheet: 838838d1691437434-need-help-creating-automated-school-report-form-system-assessment-reports-generator-_jt
Sheet: Reports 

 | [NAME] |  |  |  |  |  |  |  |  |  | Adm No. | 1
 | SCHOOL TERM SUMMATIVE REPORT
 | NAME:…………….…………………………………………. |  |  | GENDER:………….. |  |  | CLASS/GRADE…...…………..
 | ASSESSMENT NO.:…………………………………. |  |  | UPI NO:…………… |  |  | ADM NO.:………………………..
 | CLASS TEACHER:……………………………………. |  |  | YEAR:…………….. |  |  | TERM:……………………………..
 | S/No | Learning Areas | Fill in appropriately with 4, 3, 2 or 1 |  |  |  |  |  | Teacher's Name
 |  |  | 1st Assessment |  | 2nd Assessment |  | 3rd Assessment
 | 1 |  | 4 | EE
 | 2 |  | 4 | EE
 | 3 |  | 3 | ME
 | 4 |  | 3 | ME
 | 5 |  | 2 | AE
 | 6 |  | 1 | BE
 | 7 |  | 4 | EE
 | 8 |  | 4 | EE
 | 9 |  | 4 | EE
 | 10 |  | 3 | ME
 | 11 |  | 3 | ME
 | 12 |  | 4 | EE
 | 13 |  | 3 | ME
 | 14 |  | 1 | BE
 | [NAME]'s General Performance Level:………………..……………………………………………. |  |  |  |  | KEY
 |  |  |  |  |  | 4 | EE | Exceeding Expectation
 | Class Teacher's comments:……….……….…………………………………………………………… |  |  |  |  | 3 | ME | Meeting Expectation
 | …………...……………………………………………………………………………………………………….. |  |  |  |  | 2 | AE | Approaching Expectation
 | ………..……………….……………………………………………………………………………………………. |  |  |  |  | 1 | BE | Below Expectation
 | Fees Arrears:………………….……………………… |  |  |  | Next Term's Fees:………………………………………..
 | Closing Date:……………………………………….. |  |  |  | Next Term Begins on:…………………………………..
 | Class Teacher's Signature:…………………………….. |  |  |  | Principal's Signature:……..……………………………
Spreadsheet: 147730d1332949576-drop-down-list-reference-formula-machine-schedule-2
Sheet: ENTRY SHEET

Lathe |  | [NAME] |  | Broach |  |  | Project Manager
Quoted Time Minutes/pc
3.55
Part number |  |  |  | Job Number |  |  | Part Material
Revision
Due Date |  | 2012-01-10 00:00:00 |  | Qty | 100 | Release number | -1 | PO # for material
 |  | 2012-02-10 00:00:00 |  |  | 90 |  | -2
 |  | 2012-03-10 00:00:00 |  |  | 80 |  | -3
 |  | 2012-04-10 00:00:00 |  |  | 70 |  | -4
 |  | 2012-05-10 00:00:00 |  |  | 60 |  | -5
 |  | 2012-06-12 00:00:00 |  |  | 50 |  | -6
 |  | 2012-07-15 00:00:00 |  |  | 50 |  | -7
 |  | 2012-08-15 00:00:00 |  |  | 50 |  | -8
 |  | 2012-09-12 00:00:00 |  |  | 50 |  | -9
 |  | 2012-10-12 00:00:00 |  |  | 100 |  | -10
 |  | 2012-11-15 00:00:00 |  |  | 100 |  | -11
 |  | 2012-12-12 00:00:00 |  |  | 150 |  | -12
Customer
Next Process
Upper Assembly
Spreadsheet: 856197d1705540933-count-total-number-of-months-not-counting-overlapping-months-calculatemonths
Sheet: Sheet1

Project Name | Start Period | End Period
ABC | 2022-01-01 00:00:00 | 2022-12-31 00:00:00 |  | 365 |  | Total number of days taken |  |  | [How to calculate the total number of days, not counting overlapping period]
DDD | 2022-05-01 00:00:00 | 2023-02-03 00:00:00 |  | 34
EEE | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  | 332 |  | Total number of months
FFF | 2024-09-02 00:00:00 | 2024-12-31 00:00:00 |  | 121
EFG | 2000-01-01 00:00:00 | 2000-06-30 00:00:00 |  | 182
Spreadsheet: 712456d1610216312-lookup-or-loop-through-planning_example
Sheet: vlook

SubProjectTypeName |  |  |  |  |  |  |  |  | 7
AFDS | Software |  |  |  |  |  |  |  | SubProjectTypeName
Area User Notification | Operations |  |  |  |  |  |  |  | [NAME]
Assessment Services | Operations |  |  |  |  |  |  |  | Respond
Competency Assessment | Operations |  |  |  |  |  |  |  | H2CommandCentre
Conduct Audit | Operations
Contractor Management | Operations
Create ERP | Operations
Create EST Plan | Operations
Create Site Sections | Operations
Deliver Orientation Program | Operations
Develop Orientation Program | Operations
Distribute | Operations
EDS | Software
[NAME] | Software
EM Consulting | Operations
Environmental Reporting | Operations
EPZ Calculations | Engineering
ERM Tools | Operations
EST Training | Training
Expert Witness Services | Operations
Gap Analysis | Operations
GIS and Mapping | GIS
GIS and Mapping Services | GIS
Government Consultation | Operations
H2Notify | Software
[NAME] | Engineering
HSE MS Development | Operations
HSE MS Maintenance | Operations
ICS | Training
ICS 100 | Training
ICS 200 | Training
ICS 300 | Training
ICS Vests | ICS Vests
Incident Management | Operations
Indoctrination Program Development | Operations
Inspection | Operations
MARS | Software
[NAME] | GIS
Meetings | Operations
Mobilization Exercise | Training
Notifications | Operations
Orientation | Training
Other | Operations
Program Management | Operations
Public Involvement | PAS
Public Involvement Phone Update | PAS
Regulatory | Operations
Regulatory Reporting | Operations
Reproduction Services | Operations
Software | Software
[NAME] | Training
SOP Development | Operations
Support Services | Operations
Table Top | Training
Training | Training
Truck Books | Operations
Update ERP | Operations
Update EST Plan | Operations
Update Site Sections | Operations
Wildfire Plan | Operations
Financial | Operations
[NAME] | [NAME]
[NAME] | GIS
Respond | Software
H2CommandCentre | Software
PIMS | Software
Electronic ERP | Software
Response Support | Software
[NAME] | PAS
Spreadsheet: 48967d1248257359-modify-conditional-formatting-service-schedule-1
Sheet: Sheet1

SERVICE SCHEDULE |  |  |  |  |  | DUE WITHIN 4 WEEKS |  | LETTER SENT
 |  |  |  |  |  | OVERDUE
SERIAL No. | CUSTOMER NAME | MACHINE TYPE | CONTACT NAME | EMAIL ADDRESS LINK | INSTALLATION DATE | LAST SERVICED | SERVICE DUE DATE
1000 | METERMIX SYSYEMS LTD |  | [NAME] | [EMAIL] | 2009-07-21 00:00:00 | 2009-01-28 00:00:00 | 2009-07-28 00:00:00
1001 |  |  |  | [EMAIL] | 2009-07-21 00:00:00 | 2009-02-22 00:00:00 | 2009-08-22 00:00:00
1002 |  |  |  | [EMAIL] | 2009-07-21 00:00:00 | 2009-01-16 00:00:00 | 2009-07-16 00:00:00
1003 |  |  |  | [EMAIL] | 2009-07-21 00:00:00 | 2009-01-10 00:00:00 | 2009-07-10 00:00:00
1004 |  |  |  | [EMAIL] | 2009-07-21 00:00:00 | 2009-01-10 00:00:00 | 2009-07-10 00:00:00
1005 |  |  |  | [EMAIL] | 2009-07-21 00:00:00 | 2009-01-10 00:00:00 | 2009-07-10 00:00:00
1006 |  |  |  | [EMAIL] | 2009-07-21 00:00:00 | 2009-01-10 00:00:00 | 2009-07-10 00:00:00
1007 |  |  |  | [EMAIL] | 2009-07-21 00:00:00 | 2009-01-10 00:00:00 | 2009-07-10 00:00:00
1008 |  |  |  | [EMAIL] | 2009-07-21 00:00:00 | 2009-01-10 00:00:00 | 2009-07-10 00:00:00
1009 |  |  |  | [EMAIL] | 2009-07-21 00:00:00 | 2009-01-10 00:00:00 | 2009-07-10 00:00:00
1010 |  |  |  | [EMAIL] | 2009-07-21 00:00:00 | 2009-01-10 00:00:00 | 2009-07-10 00:00:00
1011 |  |  |  | [EMAIL] | 2009-07-21 00:00:00 | 2009-01-10 00:00:00 | 2009-07-10 00:00:00
1012 |  |  |  | [EMAIL] | 2009-07-21 00:00:00 | 2009-01-10 00:00:00 | 2009-07-10 00:00:00
1013 |  |  |  | [EMAIL] | 2009-07-21 00:00:00 | 2009-01-10 00:00:00 | 2009-07-10 00:00:00
1014 |  |  |  | [EMAIL] | 2009-07-21 00:00:00 | 2009-01-10 00:00:00 | 2009-07-10 00:00:00
Spreadsheet: 503207d1487675815-looking-for-a-formula-to-convert-american-dates-to-british-dates-example
Sheet: Sheet1

Raw Date | Converted Date
42593.44815972223
11/15/2016 2:22:12 PM
9/21/2016 11:44:13 AM
42593.49517361111
10/31/2016 11:20:42 AM
10/31/2016 11:20:42 AM
9/21/2016 5:23:52 PM
9/22/2016 9:09:40 AM
9/27/2016 9:40:23 AM
9/20/2016 1:38:48 PM
42561.51969907407
8/30/2016 10:24:05 AM
10/27/2016 1:51:17 PM
42653.51061342593
Spreadsheet: 855574d1705093739-add-year-in-an-if-statement-payments-example
Sheet: Sheet1

 | Due Date | Cycle
 | 2024-10-09 00:00:00 | M
 | 2024-01-12 00:00:00 | Y |  |  | I can't get my formula to work.  Using an IF statement to compare DAY in cell B4 to Todays date which is in cell A1.  If they match then put the words "Pay Now"  in A4 or else "No Pay" if they don't match.
 | 2024-01-12 00:00:00 | M
 | 1900-01-12 00:00:00 | M
 | 2024-01-14 00:00:00 | M
 | 2024-12-22 00:00:00 | Q
 | 2024-01-29 00:00:00 | M
 | 2024-01-30 00:00:00 | M
 | 2024-01-31 00:00:00 | Q