tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 811130d1672302054-hide-row-hide-empty-row
Sheet: Pivot

Helper | PRINT
No. | Name | Matric No. | Math | Sc | Arts | Eng | Geog | History
1 | [NAME] | 68751 | 92 | 85 | 78 | 82 | 77 | 74
8 | [NAME] | 21301 | 93 | 86 | 79 | 83 | 78 | 75
13 | [NAME] | 13064 | 94 | 87 | 80 | 84 | 79 | 76
23 | [NAME] | 21302 | 95 | 88 | 81 | 85 | 80 | 77
36 | [NAME] | 26160 | 93 | 86 | 79 | 83 | 78 | 75
39 | Anna | 96076 | 94 | 87 | 80 | 84 | 79 | 76
41 | [NAME] | 17902 | 96 | 89 | 82 | 86 | 81 | 78
45 | Carol | 80941 | 97 | 90 | 83 | 87 | 82 | 79
68 | [NAME] | 21305 | 98 | 91 | 84 | 88 | 83 | 80
70 | Anne | 89709 | 93 | 86 | 79 | 83 | 78 | 75
71 | [NAME] | 17904 | 92 | 85 | 78 | 82 | 77 | 74
72 | Ava | 90598 | 91 | 84 | 77 | 81 | 76 | 73
76 | [NAME] | 68756 | 92 | 85 | 78 | 82 | 77 | 74
1175 | Amelia | 76740 | 91 | 84 | 77 | 81 | 76 | 73
1190 | Amelia | 76741 | 92 | 85 | 78 | 82 | 77 | 74
1191 | [NAME] | 26237 | 93 | 86 | 79 | 83 | 78 | 75
1196 | [NAME] | 17979 | 92 | 85 | 78 | 82 | 77 | 74
1197 | Ava | 90673 | 91 | 84 | 77 | 81 | 76 | 73
1199 | [NAME] | 12766 | 90 | 83 | 76 | 80 | 75 | 72
1200 | Carol | 81018 | 89 | 82 | 75 | 79 | 74 | 71
Spreadsheet: 79625d1279830390-pivot-table-pivot-table
Sheet: Data

Code | Rate | Wk 01 Hours | Wk 01 Amount | Wk 02 Hours | Wk 02 Amount | Wk 03 Hours | Wk 03 Amount | Wk 04 Hours | Wk 04 Amount | Wk 05 Hours | Wk 05 Amount | Wk 06 Hours | Wk 06 Amount
111 | 79.22 | 1 | 79.22 | 2 | 158.44 | 3 | 237.66 | 1 | 79.22 | 5 | 396.1 | 6 | 475.32
777 | 20.25 | 20.25 | 1604.205 | 7 | 554.54 | 14.75 | 1168.495 | 4.5 | 356.49 | 4.5 | 356.49 | 7 | 554.54
222 | 56.33 | 10.5 | 831.81 | 8 | 633.76 | 16.5 | 1307.13 | 5 | 396.1 | 5 | 396.1 | 8 | 633.76
123 | 45.66 | 5 | 396.1 | 8.5 | 673.37 | 22.5 | 1782.45 | 5 | 396.1 | 7 | 554.54 | 8.5 | 673.37
111 | 22.33 | 6 | 475.32 | 10 | 792.2 | 7 | 554.54 | 6 | 475.32 | 8 | 633.76 | 10 | 792.2
333 | 88.99 | 7 | 554.54 | 5 | 396.1 | 8 | 633.76 | 7 | 554.54 | 8.5 | 673.37 | 5 | 396.1
111 | 56.66 | 8 | 633.76 | 4.5 | 356.49 | 8.5 | 673.37 | 8 | 633.76 | 10 | 792.2 | 4.5 | 356.49
444 | 45.55 | 8.5 | 673.37 | 25.5 | 2020.11 | 10 | 792.2 | 8.5 | 673.37 | 19.5 | 1544.79 | 2.5 | 198.05
111 | 48.99 | 10 | 792.2 | 37.5 | 2970.75 | 5 | 396.1 | 10 | 792.2 | 22.5 | 1782.45 | 3.5 | 277.27
456 | 45.66 | 5 | 396.1 | 22.5 | 1782.45 | 4.5 | 356.49 | 10.5 | 831.81 | 37.5 | 2970.75 | 4.5 | 356.49
111 | 78.99 | 4.5 | 356.49 | 19.5 | 1544.79 | 12.5 | 990.25 | 20.25 | 1604.205 | 3.75 | 297.075 | 19.75 | 1564.595
103 | 45.55 | 8.5 | 673.37 | 25.5 | 2020.11 | 10 | 792.2 | 8.5 | 673.37 | 19.5 | 1544.79 | 2.5 | 198.05
101 | 48.99 | 10 | 792.2 | 37.5 | 2970.75 | 5 | 396.1 | 10 | 792.2 | 22.5 | 1782.45 | 3.5 | 277.27
101 | 45.66 | 5 | 396.1 | 22.5 | 1782.45 | 4.5 | 356.49 | 10.5 | 831.81 | 37.5 | 2970.75 | 4.5 | 356.49
192 | 78.99 | 4.5 | 356.49 | 19.5 | 1544.79 | 12.5 | 990.25 | 20.25 | 1604.205 | 3.75 | 297.075 | 19.75 | 1564.595
456 | 20.25 | 20.25 | 1604.205 | 7 | 554.54 | 14.75 | 1168.495 | 4.5 | 356.49 | 4.5 | 356.49 | 7 | 554.54
999 | 56.33 | 10.5 | 831.81 | 8 | 633.76 | 16.5 | 1307.13 | 5 | 396.1 | 5 | 396.1 | 8 | 633.76
222 | 45.66 | 5 | 396.1 | 8.5 | 673.37 | 22.5 | 1782.45 | 5 | 396.1 | 7 | 554.54 | 8.5 | 673.37
248 | 22.33 | 6 | 475.32 | 10 | 792.2 | 7 | 554.54 | 6 | 475.32 | 8 | 633.76 | 10 | 792.2
777 | 88.99 | 7 | 554.54 | 5 | 396.1 | 8 | 633.76 | 7 | 554.54 | 8.5 | 673.37 | 5 | 396.1
123 | 78.99 | 4.5 | 356.49 | 19.5 | 1544.79 | 12.5 | 990.25 | 20.25 | 1604.205 | 3.75 | 297.075 | 19.75 | 1564.595
333 | 78.99 | 4.5 | 356.49 | 19.5 | 1544.79 | 12.5 | 990.25 | 20.25 | 1604.205 | 3.75 | 297.075 | 19.75 | 1564.595
 | Total | 171.5 | 13586.23 | 332.5 | 26340.65 | 238 | 18854.36 | 203 | 16081.66 | 255 | 20201.1 | 187.5 | 14853.75
Spreadsheet: andy_zipper__102__Sales Funnel2
Sheet: Sheet1

 | Prospect | Market | Contacted | Meeting Set
NGL | Huntsman Corporation | NGL | x
 | Enterprise Products Partners | NGL | x | x
 | [NAME] | NGL | x | x
 | [NAME] | NGL/Oil/Refined
 | [NAME] | NGL/Refined/Chemical | x | x
 | Chevron | NGL
 | Formosa | NGL
Oil & Refined | Conoco | Oil/Refined
 | [NAME] | Oil/Refined
 | Tosco/Phillips | Oil/Refined
 | [NAME] Shamrock | Oil/Refined
 | BP | Oil/Refined
 | Chevron/Texaco | Oil/Refined
 | Sunoco | Oil/Refined
 | [NAME] | Oil/Refined
 | Tauber | Oil/Refined/Petchem | x | x
 | Fortum (Neste) | Oil/Refined | x | x
Pulp & Paper | Pulp & Paper
 | Waste Management | Paper | x | x
 | Domtar | Paper | x
 | Smurfit Stone Container Corp. | Paper | x
 | [NAME] | Paper | x
 | Inland Paperboard & Packaging | Paper
 | Temple Inland | Lumber
Spreadsheet: 266963d1379880836-formula-for-classifying-data-excel-forum-sample
Sheet: Sheet1

Ang | Abang | Achari | [NAME]
Au | [NAME] | Acharya | Krishnan Ajit
Aw | Abdul | Adath | [NAME]
[NAME] | [NAME] | Ajit | Siti binte Abu
Bok | Abu | Ambumamee | [NAME]
Spreadsheet: 710061d1608697564-excel-formula-to-automaticaly-insert-date-if-column-c-is-filled-date-formula
Sheet: Sheet1

I am kindly asking for a excel formula to automatically write "1 Jan 21" on column A, if there is a name on column C
Date | ID | Name
2021-01-01 00:00:00 | CT 001 | [NAME]
2021-01-01 00:00:00 | CT 002 | [NAME]
2021-01-01 00:00:00 | CT 003 | Harvey
2021-01-01 00:00:00 | CT 004 | [NAME]
2021-01-01 00:00:00 | CT 005 | [NAME]
Desired Solution
Date | ID | Name
2021-01-01 00:00:00 | CT 001 | [NAME]
 | CT 002
2021-01-01 00:00:00 | CT 003 | Harvey
 | CT 004
2021-01-01 00:00:00 | CT 005 | [NAME]
Spreadsheet: 0ff25ebc-3fa2-4fc5-8904-a6fbbc9cd04d
Sheet: Encode_PES

Annex 1 - Performance Enhancement System (PES)
 |  | nENTRIES> | 16 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  |  | 23
DI# | [NAME] | Consortium  value is
DI01 | # Regional/local events organised | max(P)
DI02 | # Participants in regional/local events | sum(P)
DI03 | # SMEs/clients receiving individual advisory support | sum(P)
DI04 | # Brokerage events/company missions organised | sum(P)
DI05 | # SMEs/clients in brokerage events/company missions | sum(P)
DI06 | # Meetings at brokerage events/company missions | sum(P)
DI07 | # Partnership profiles produced | sum(P)
DI08 | # Expression of interests received | sum(P)
DI09 | # Expression of interests made | sum(P)
DI10 | # Clients in feed-back related actions | sum(P)
DI11 | # Clients mentored | sum(P)
DI12 | # [NAME] | sum(P)
DI13 | # SMEs/clients using digital services provided by the Network | sum(P)
DI14 | # Cooperation with local stakeholders | sum(P)
[NAME] | # [NAME] enquiries from Network partners | sum(P)
DI16 | # Active contributions to Network activities | sum(P)
Spreadsheet: 168474d1342467173-index-formula-not-working-or-advise-best-formula-index-formula-with-negative
Sheet: Exit Tracker Group Ops

 |  |  |  |  |  |  |  | Currently Average Budget by Grade |  |  |  | Run Rate Benefits Claimed - Split by CMU |  |  |  |  |  |  | Other Expected Run Rate Benefits to LBG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]:L22,3,FALSE)
 |  | Jan | Feb | Mar |  | Exits | Synergies | Severance | FTE | Run Rate Benefit |  | Run Rate Benefit | Run Rate Benefit | Run Rate Benefit |  | Run Rate Benefit |  |  | Run Rate Benefit | Run Rate Benefit | Run Rate Benefit | Run Rate Benefit
 |  | Plan | Plan | Plan
 |  |  |  |  |  |  |  |  |  |  |  | 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
 |  |  |  |  |  |  |  | VR/CR/CA Possible |  |  | EU | 0 | 0
 |  |  |  |  |  |  |  | VR/CR/CA Possible |  |  | EU | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | EU | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | EU | 0 | 0
 |  |  |  |  |  |  |  |  | -0.6 |  | EU
 |  |  |  |  |  |  |  |  | 0.9 |  | DU | 37387.283 | 17751.5
 |  |  |  |  |  |  |  | VR/CR/CA Possible | 1 |  | C | 27168.612 | 11275.5
 |  |  |  |  |  |  |  | VR/CR/CA Possible | 1 |  | C | 24451.7508 | 10147.95
 |  |  |  |  |  |  |  | VR/CR/CA Possible | 1 |  | EU | 50693.917 | 31090.5
 |  |  |  |  |  |  |  | VR/CR/CA Possible | 1 |  | EU | 30416.3502 | 18654.3
 |  |  |  |  |  |  |  | VR/CR/CA Possible | 1 |  | EU | 20277.5668 | 12436.2
 |  |  |  |  |  |  |  | VR/CR/CA Possible | 1 |  | EU | 30416.3502 | 18654.3
 |  |  |  |  |  |  |  | VR/CR/CA Possible | 1 |  | C | 27168.612 | 11275.5
 |  |  |  |  |  |  |  | VR/CR/CA Possible | 1 |  | C | 27168.612 | 11275.5
 |  |  |  |  |  |  |  | VR/CR/CA Possible | 1 |  | F | 76638.041 | 49335.5
 |  |  |  |  |  |  |  | VR/CR/CA Possible | 1 |  | DU | 37387.283 | 17751.5
 |  |  |  |  |  |  |  | VR/CR/CA Possible | 1 |  | G | 112452.039 | 95026
 |  |  |  |  |  |  |  | VR/CR/CA Possible | 1 |  | F | 45982.8246 | 29601.3
 |  |  |  |  |  |  |  | VR/CR/CA Possible | 1 |  | F | 45982.8246 | 29601.3
 |  |  |  |  |  |  |  | VR/CR/CA Possible | 1 |  | EU | 50693.917 | 31090.5
 |  |  |  |  |  |  |  | VR/CR/CA Possible | 1 |  | F | 76638.041 | 49335.5
 |  |  |  |  |  |  |  | VR/CR/CA Possible | 1 |  | EU | 50693.917 | 31090.5
 |  |  |  |  |  |  |  | VR/CR/CA Possible | 1 |  | EU |  |  |  |  |  | M48=46,077 & N48=27,829
 |  |  |  |  |  |  |  | N/A | -1 |  | G |  |  |  |  |  | M49 =DataD5=-86,867
 |  |  |  |  |  |  |  | N/A |  |  | DU | 37387.283 | 17751.5 |  |  |  | N49=DataD22-Data D5=-63,177
 |  |  |  |  |  |  |  | N/A |  |  | DU | 37387.283 | 17751.5
Spreadsheet: 68442d1268968509-array-search-trigger-issues2
Sheet: Cells

3 | 12 | A1:A7 | Should be | A1:A7
6 | 12 | A2:A6 |  | A2:A7
9 | 12 | A3:A5 |  | A3:A7
2 | 12 | A4:A4 |  | A4:A7
5 | 12 | A5:A3 |  | A5:A7
9 | 12 | A6:A2 |  | A6:A7
12 | 12 | A7:A1 |  | A7:A7
11 | 11 | A8:A1 |  | A8:A8
4 | 11 | A9:A4 |  | A9:A12
6 | 11 | A10:A3 |  | A10:A12
7 | 11 | A11:A2 |  | A11:A12
11 | 11 | A12:A1 |  | A12:A12
8 | #N/A | #N/A |  | #N/A
Spreadsheet: 868728d1715391339-two-way-anova-without-replication-help-excel-help
Sheet: Size Frequency

Class limits | Crest | Slope
0 - 7 | 1 | 3
8-15 | 1 | 3
16 - 23 | 3 | 5
24 - 31 | 3 | 5
32 - 39 | 1 | 2
40 - 47 | 0 | 2
54 - 61 | 0 | 0
62 - 69 | 1 | 0
Anova: Two-Factor Without Replication
SUMMARY | Count | Sum | Average | [NAME]
0 - 7 | 2 | 4 | 2 | 2
8-15 | 2 | 4 | 2 | 2
16 - 23 | 2 | 8 | 4 | 2
24 - 31 | 2 | 8 | 4 | 2
32 - 39 | 2 | 3 | 1.5 | 0.5
40 - 47 | 2 | 2 | 1 | 2
54 - 61 | 2 | 0 | 0 | 0
62 - 69 | 2 | 1 | 0.5 | 0.5
Crest | 8 | 10 | 1.25 | 1.357143
Slope | 8 | 20 | 2.5 | 3.714286
ANOVA
Source of Variation | SS | df | MS | F | P-value | F crit
Rows | 30.75 | 7 | 4.392857 | 6.473684 | 0.012417 | 3.787044
Columns | 6.25 | 1 | 6.25 | 9.210526 | 0.018983 | 5.591448
Error | 4.75 | 7 | 0.678571
Total | 41.75 | 15
Spreadsheet: 02e36d03-14a0-4c29-9e83-502963ef59c7
Sheet: 3-8T

 | Section 3: Cost
 | Table 3-8Trend:  Domestic and Foreign Cost Per Mile by Year
 | Vehicle Type | 2009 | 2010 | 2011 | 2012 | 2013
 | Domestic | 0.721372 | 0.871258 | 0.826514 | 0.833067 | 0.900218
 | Foreign | 1.072178 | 1.058834 | 1.15605 | 0.963254 | 1.237965
 | Overall | 0.746208 | 0.88377 | 0.846257 | 0.84191 | 0.922043
Spreadsheet: 25057d1216144116-excel-2007-how-do-you-count-cells-with-specific-fill-colors-blue-medal-tracker
Sheet: Sheet1

 |  | Close Out Date | Submit for New Medal? | Date Submitted for New Medal
Name | Rank | Of Last Medal |  |  | Comments
[NAME], [NAME] | [NAME] | 1909-01-12 00:00:00 | no | 2008-06-01 00:00:00 | Has Referal EPR for Fit Test
[NAME], [NAME] | SrA | 2006-01-01 00:00:00
Diggler, [NAME] | [NAME] | 2007-07-11 00:00:00
Gates, [NAME] | [NAME] | 1991-05-06 00:00:00
[NAME], [NAME] | Maj | 2002-02-01 00:00:00 | yes | 2008-07-01 00:00:00
Presely, [NAME] | AB | 2001-01-01 00:00:00 | yes
[NAME], [NAME] | TSgt | 1995-01-01 00:00:00 | no |  | Per Flight Chief
Bird, [NAME] | SMSgt | 2002-05-05 00:00:00
 |  |  | Quantity | Percentages
Personnel Assigned
Awaiting Consideration
Submitted for Medal
Not Recommended at This Time
Spreadsheet: 173423d1344546097-dynamically-changing-moving-sum-issue-example1
Sheet: Sheet1

Day | Input | 6 Day | 6 Day + Today
1 | 5 | -
2 | 6 | 5
3 | 3 | 11
4 | 8 | 14
5 | 0 | 22
6 | 1 | 22 | RESET
7 | 5 | 1
8 | 5 | 6
9 | 3 | 11
Spreadsheet: 269505d1381177292-dynamic-file-paths-help-collated-report-2262-vancouver-mall-dr-vancouver-wa-week-35-2013
Sheet: Petty Cash

PETTY CASH SUMMARY SHEET
Week Ending Date: |  | 09/03/2013
Store Location: |  | 2262 - Vancouver Mall Dr, Vancouver, WA
Store # |  | 2262
General Manager [NAME]:
Account | Account | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  | Monday |  | Tuesday |  | Account | Totals
Titles |  | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM
 |  | [NAME] |  | 08/29/2013 |  | 08/30/2013 |  | 08/31/2013 |  | 09/01/2013 |  | 09/02/2013 |  | 09/03/2013
Bread | 4311 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4311 | 0
Food | 4312 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4312 | 0
Sides | 4313 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4313 | 0
Paper | 4314 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4314 | 0
Produce | 4315 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4315 | 0
Beverages | 4316 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4316 | 0
Catering | 4320 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4320 | 0
Building Maintenance | 5243 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5243 | 0
Equipment Maintenance | 5244 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5244 | 0
Equipment Replacement | 5245 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5245 | 0
Office Supplies | 5230 |  |  |  |  |  |  |  |  |  |  |  |  | 46.05 |  | 5230 | 46.05
Operating Supplies | 5220 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5220 | 0
Cleaning Supplies | 5242 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5242 | 0
Miscellaneous | 5699 |  |  |  |  |  |  |  |  |  |  |  |  | 15.74 |  | 5699 | 15.74
Cash Over/Short | 5698 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5698 | 0
Outside Services | 5619 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5619 | 0
Travel + Lodging | 8630 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8630 | 0
Postage/Freight | 8645 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8645 | 0
Training Manager Meal | 2014 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014 | 0
Overrings | 3315 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3315 | 0
DMR | 5083 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.46 | 0 | 1.52 | 5083 | 1.98
ACCOUNT TOTALS
DAILY TOTALS |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.46 | 61.79 | 1.52 |  | 63.77
Spreadsheet: 729006d1618855327-get-total-of-specific-background-colored-cells-bkcolor_email
Sheet: Sheet1

 |  |  | GetColor
 | R | No clip
 | R | Light Clip
 | R | Heavy Clip |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  | R | R | R | R | R | R | R | R | R | R
 |  |  |  |  | R | R | R | R | R | R | R | R | R | R | 23
 |  |  |  |  | R | R | R | R | R | R | R | R | R | R | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  | R | R | R | R | R | R | R | R | R | R
Spreadsheet: 86936d1286892281-count-with-two-variables-test
Sheet: 126

DATE | 2010-09-23 00:00:00
TIME | 02:00:00
VEHICLE | 08C1234
DRIVER | PADDY MURPHY
[NAME] | YOUGHAL WASTE FACILITY
TRAILER NO
HELPER
THIRD PARTY NAME | JOHN DAY
ADDRESS | DUNLUECE ROAD, GOATSTOWN, DUBLIN 16
TELEPHONE NO | 01 456 235655
THIRD PARTY REG | 08C20111
TYPE OF VEHICLE | OPEL ASTRA
INSURANCE CO | QUINN DIRECT
POLICY NUMBER | MBQ-EMB-54777733
EXPIRY DATE | 2011-01-22 00:00:00
DAMAGE TO OUR VEHICLE | REAR BUMPER DAMAGED, MUDGUARD HAS TO BE REPLACED
DAMAGE TO THIRD PARTY VEHICLE | SQUASHED LHS DOOR
PHOTOS TAKEN | NO
ANY INJURED PARTIES | NO
INDEPENDENT WITNESS | PAT LYNCH
GARDA NAME & STATION | GER CONDON, YOUGHAL GARDA SYTATION 024 44544
DETAILS OF ACCIDENT FROM DRIVER | PARKED CAR WAS RESTRICTING VIEW OF TURNAROUND AREA IN TIPHEAD, REVERSED BACK NOT NOTICING THAT THERE WAS A SECOND PARKED CAR, HIT THE DOOR BEFORE HAD TIME TO STOP TRAILER
DATE REPORTED TO INSURER
TO [NAME]
BY [NAME]
CLAIM NUMBER
FURTHER DETAILS | DAMAGE TO CAR DOOR PAID FOR BY MHL
COST OF DAMAGE | 152
Spreadsheet: 101420d1299549675-regarding-conditional-if-statement-querry
Sheet: Sheet1

Assume other than R1Z as non residential for simplicity.
DESCRIPT0N | Classification
PUZ3 - Public Use - Health Community | [NAME]
PUZ7 - Public Use - Other Public Use | [NAME]
PPRZ - Public Park & Recreation
PUZ1 - Public Use - Service & Utility
PUZ4 - Public Use - Transport | Residential
[NAME]
PPRZ - Public Park & Recreation
PPRZ - Public Park & Recreation
IN1Z - Industrial 1
PUZ3 - Public Use - Health Community
[NAME] Use 2
PPRZ - Public Park & Recreation
PUZ4 - Public Use - Transport | Other
B2Z - Business 2
PUZ4 - Public Use - Transport
SUZ1 - Special Use 1
PUZ5 - Public Use - Cemetery/Crematorium
[NAME]
MUZ - Mixed Use
Spreadsheet: 545542d1509540346-sumif-formula-sumif-formula-sample-workbook
Sheet: Customerwise Summary

 | SALES MANAGER | CATEGORY |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales Manager | Category
 |  |  |  |  |  |  |  |  |  |  |  |  |  | All | All
 | Sales Manager | Total |  |  |  |  |  |  |  |  |  |  |  | A | Service Hours
 | A |  |  |  |  |  |  |  |  |  |  |  |  | B | [NAME] Rev
 | B |  |  |  |  |  |  |  |  |  |  |  |  | C | ASM
 | C |  |  |  |  |  |  |  |  |  |  |  |  |  | Pro-rated Invoiced ASM
 | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly License Fee
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly Hosting Fee
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Services Rev.
 | Customer | Partner | Sales Manager | Order Type | Product | Service Type | Service Hours | [NAME] Rev | ASM | Pro-rated Invoiced ASM | Monthly License Fee | Monthly Hosting Fee | Services Rev.
 | 123 | Direct | A |  | SAP |  | 1 | 10 | 11 | 16 | 21 | 25 | 30
 | 456 | Direct | C |  | GP |  | 2 | 5 | 12 | 17 | 22 | 26 | 31
 | 789 | ABC | B |  | BEM |  | 3 | 6 | 13 | 18 | 23 | 27 | 32
 | 1011 | DEF | A |  | ORACLE |  | 4 | 7 | 14 | 19 | 24 | 28 | 33
 | 1012 | Direct | B |  | GP |  | 5 | 8 | 15 | 20 | 25 | 29 | 34
Spreadsheet: chris_germany__2018__NGPL Status
Sheet: NGPL-Invoice Status

Pipeline | NGPL
Contact Name
Contact Number
Status
Legal
Commercial | [NAME]
ENA
 |  |  | Pre-Petition |  |  |  | Post Petition
Contract No. | Rate Schedule | Expiration | Other Past Due Amounts | Nov. 2001 | Dec. 2, 2001 | Total Pre-Petition | Dec. 3-31,2001 | Jan. 2002 | Feb.2002 | Mar.2002 | Total Post Petition | Notes
118731 | FT | 2002-03-01 00:00:00 |  | 48720.62 |  |  |  |  | Rejected
113413 | FT | 2008-10-01 00:00:00 |  | 45212.92 |  |  |  | 44349 | Rejected
 |  |  |  |  |  |  |  |  |  |  | 0
Other:
NGPL Post Petition claims | 178606
ENA Post Petition
Difference
Spreadsheet: 545443d1509468560-count-number-after-text-abscence-calendar-llnv1
Sheet: John, Doe

Day | January | Februrary | March | April | May | June | July | August | September | October | November | December
1 | PTO: 5
2
3
4
5
6 | PTO: 5
7
8 | PTO: 5
9 | U.PTO: 10
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 |  | I'd like for it to be able to distinguish the values from PTO:# and  U.PTO: #
 | PTO of JAN | PTO of FEB | PTO of MAR | PTO of APR | PTO of MAY | PTO of JUNE | PTO of July | PTO of AUG | PTO of SEPT | PTO of OCT | PTO of NOV | PTO of DEC
Values go here
 | Unexcused PTO of JAN | Unexcused PTO of FEB | Unexcused PTO of MAR | Unexcused PTO of APR | Unexcused PTO of MAY | Unexcused PTO of JUNE | Unexcused PTO of JULY | Unexcused PTO of AUG | Unexcused PTO of SEPT | Unexcused PTO of OCT | Unexcused PTO of NOV | Unexcused PTO of DEC
Spreadsheet: 865488d1712575943-how-to-look-up-both-vertically-and-horizontally-together-quote-help
Sheet: Sheet1

Lookup Section
 | 2023/24 | 2024/25 | 2025/26 | 2026/27 | 2027/28 | 2028/29 | 2029/30
Type1 | 12840 | 13353.6 | 13887.744 | 14443.25376 | 15020.9839104 | 15621.823266816 | 16246.69619748864
Type2 | 12840 | 13353.6 | 13887.744 | 14443.25376 | 15020.9839104 | 15621.823266816 | 16246.69619748864
[NAME] | 17610 | 18314.4 | 19046.976 | 19808.85504 | 20601.2092416 | 21425.257611264 | 22282.26791571456
Type4 | 17610 | 18314.4 | 19046.976 | 19808.85504 | 20601.2092416 | 21425.257611264 | 22282.26791571456
Type5 | 17610 | 18314.4 | 19046.976 | 19808.85504 | 20601.2092416 | 21425.257611264 | 22282.26791571456
Type6 | 24165 | 25131.6 | 26136.864 | 27182.33856 | 28269.6321024 | 29400.417386496 | 30576.43408195583
Type7 | 24165 | 25131.6 | 26136.864 | 27182.33856 | 28269.6321024 | 29400.417386496 | 30576.43408195583
Type8 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Type9 | 12840 | 13353.6 | 13887.744 | 14443.25376 | 15020.9839104 | 15621.823266816 | 16246.69619748864
Type10 | 24165 | 25131.6 | 26136.864 | 27182.33856 | 28269.6321024 | 29400.417386496 | 30576.43408195583
Results that should be displayed.
2024/25 | 2025/26 | 2026/27 | 2027/28
Type1 | Type2 | [NAME] | Type10
13353.6 | 13887.744 | 19808.85504 | 28269.63
0 | 0 | 0 | 0
0 | 0 | 0 | 0
13353.6 | 13887.744 | 19808.85504 | 28270
Spreadsheet: 757980d1638551031-return-different-values-based-on-column-contents-excel-problem
Sheet: Sheet1

[NAME] |  |  | NO*
Heavenly Milk Pistachio | YES | YES | NO
Evaporated Milk | NO | NO | NO
Condensed Milk | NO | NO | NO
Cream | NO | NO* | NO
[NAME] | NO | NO | NO*
[NAME] | YES | YES | NO
Spreadsheet: c4bb1fe0-44e0-4164-8201-cddff8882f21
Sheet: Sheet1

Unnamed: 0 | [NAME] | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21
 | NOTA MINTA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rujukan |  |  | :
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tarikh |  |  | :
 | Kepada |  | : | Pengetua / Guru Besar
 |  |  |  | Sek. Men. [NAME]. [NAME], 70300 Seremban, N.S
 | Daripada |  | : | [NAME] Shamsudin
 | Permohonan Mendapatkan Bekalan Peralatan Bagi Tahun 2011
 | Berhubung dengan perkara tersebut di atas, diharap [NAME] meluluskan permohonan mendapatkan
 | bekalan seperti berikut :-
 | Bil | [NAME] |  |  |  |  |  |  |  | Kuantiti |  |  | [NAME] |  |  | Tarikh [NAME] |  |  |  | [NAME]
 | 1 | [NAME] |  |  |  |  |  |  |  | 12 | pcs | 70 | 840
 | 2 | [NAME] |  |  |  |  |  |  |  | 5 | pcs | 205 | 1025
 |  |  |  |  |  |  |  |  |  |  |  |  | 1865
 | Peruntukan : |  |  |  |  |  |  |  |  | :
 | Subsidiari / Matapelajaran |  |  |  |  |  |  |  |  | : -
 | Baki Peruntukan Semasa |  |  |  |  |  |  |  |  | : RM
 | Sekian terima kasih
 | [NAME], |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Permohonan diatas
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Diluluskan / Tidak diluluskan
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T/Tangan Pengetua
 | (NORFAEZAH BT SHAMSUDIN) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (ABD HALIM BIN MD YUNUS)
 | Tarikh : |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tarikh :
 | [NAME] : AIMNET DISTRIBUTION
 | Alamat : No 566, [NAME], Oakland Commercial Centre, 70300 Seremban.
Spreadsheet: 329590d1404347684-formula-to-display-associated-matched-results-text
Sheet: Purchase_Orders

 |  |  | ARRIVAL | UPS TRACKING NUMBER | ORDERED | SHADE | COLOR | SEARCH BELOW - HIT ENTER | UPS TRACKING NUMBER | ORDERED | SHADE | COLOR | [NAME]
 |  |  | 2014-07-01 00:00:00 | 1 | 10 | A | red | GREEN | 2 | 20 | B | green
 |  |  | 2014-07-02 00:00:00 | 2 | 20 | B | green |  | 7 | 70 | A | green
 |  |  | 2014-07-03 00:00:00 | 3 | 30 | A | blue
 |  |  | 2014-07-04 00:00:00 | 4 | 40 | B | teal
 |  |  | 2014-07-05 00:00:00 | 5 | 50 | A | pink
 |  |  | 2014-07-06 00:00:00 | 6 | 60 | B | black
 |  |  | 2014-07-07 00:00:00 | 7 | 70 | A | green
 |  |  | 2014-07-08 00:00:00 | 8 | 80 | B | yellow
 |  |  | 2014-07-09 00:00:00 | 9 | 90 | A | purple
 |  |  | 2014-07-10 00:00:00 | 10 | 100 | B | teal
 |  |  | 2014-07-11 00:00:00 | 11 | 110 | A | white
 |  |  | 2014-07-12 00:00:00 | 12 | 120 | B | grey