tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 438353d1451935539-employee-timesheet-calculating-hours-worked-arbeitszeit_mitarbeiter_seepf-rdli_3
Sheet: January

January
Date | Start  Time | Break  Start | Break  End | End  Time | Total Hours Worked | Plus  Hours | Minus  Hours | Comments
2016-01-01 00:00:00 | 08:00:00 | 12:30:00 | 13:00:00 | 18:00:00
2016-01-02 00:00:00
2016-01-03 00:00:00
2016-01-04 00:00:00 | 08:00:00 | 12:00:00 | 12:30:00 | 16:00:00
2016-01-05 00:00:00 | 08:00:00 | 12:00:00 | 12:30:00 | 17:00:00 |  |  |  | other comments
2016-01-06 00:00:00 | 08:00:00 | 12:00:00 | 12:30:00 | 17:00:00
2016-01-07 00:00:00 | 08:00:00 | 12:00:00 | 12:30:00 | 17:00:00
2016-01-08 00:00:00 |  |  |  |  |  |  |  | Frei
2016-01-09 00:00:00
2016-01-10 00:00:00
2016-01-11 00:00:00 |  |  |  |  |  |  |  | ferien
2016-01-12 00:00:00 |  |  |  |  |  |  |  | Ferien
2016-01-13 00:00:00 |  |  |  |  |  |  |  | Ferien
2016-01-14 00:00:00 |  |  |  |  |  |  |  | Ferien
2016-01-15 00:00:00 |  |  |  |  |  |  |  | Frei
2016-01-16 00:00:00
2016-01-17 00:00:00
2016-01-18 00:00:00
2016-01-19 00:00:00 | 13:00:00 |  |  | 17:00:00
2016-01-20 00:00:00
2016-01-21 00:00:00 | 08:00:00 |  |  | 18:00:00
2016-01-22 00:00:00 |  |  |  |  |  |  |  | Frei
2016-01-23 00:00:00
2016-01-24 00:00:00
2016-01-25 00:00:00
2016-01-26 00:00:00
2016-01-27 00:00:00
2016-01-28 00:00:00
2016-01-29 00:00:00 |  |  |  |  |  |  |  | Frei
2016-01-30 00:00:00
2016-01-31 00:00:00
Total Hours Worked in Month
Spreadsheet: 887700d1738005953-help-with-y-axis-scaling-on-identical-graphs-y-axis
Sheet: Sheet1

6346.570000000001 | 6401.27 | 6436.670000000001 | 6477.190000000001 | 6538 | 6563.08 | 6581.139999999999 | 6608.550000000001 | 6658.33 | 6708.330000000001 | 6773.34 | 6817.909999999998 | 6853.199999999999 | 6888.42 | 6913.79 | 6959.71 | 7030.32 | 7075.59 | 7216.38 | 7261.81 | 7287.099999999999 | 7342.51 | 7367.980000000001 | 7427.270000000001 | 7464.81 | 7578.410000000001 | 7615.410000000001 | 7615.410000000001
6346.570000000001 | 6401.27 | 6436.670000000001 | 6477.190000000001 | 6538 | 6563.08 | 6581.139999999999 | 6608.550000000001 | 6658.33 | 6708.330000000001 | 6773.34 | 6817.909999999998 | 6853.199999999999 | 6888.42 | 6913.79 | 6959.71 | 7030.32 | 7075.59 | 7216.38 | 7261.81 | 7287.099999999999 | 7342.51 | 7367.980000000001 | 7427.270000000001 | 7464.81 | 7578.410000000001 | 7615.410000000001 | 7616.41
Spreadsheet: 885060d1734470565-formula-timeline-help-if-and-f-1-b2-f-1-c2-1-0-dashboard-help-bvj-2-
Sheet: query (6)

Status | WP ID | Work Package Name | Work Package Owner | Project Manager | Work Package Support | Dependency on another project | Start Date | Baseline End Date | Current End Date
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-03-28 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-04-30 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-01-31 00:00:00
 |  |  |  |  |  |  | 2025-05-01 00:00:00 | 2025-10-31 00:00:00 |  |  |  |  | popipipo
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-01-31 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-01-31 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-01-31 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-06-27 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2024-12-31 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2026-01-01 00:00:00
 |  |  |  |  |  |  | 2025-06-02 00:00:00 | 2025-06-30 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-06-30 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-12-31 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-01-31 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-02-28 00:00:00
 |  |  |  |  |  |  | 2025-04-01 00:00:00 | 2025-05-30 00:00:00
 |  |  |  |  |  |  | 2025-04-01 00:00:00 | 2025-07-31 00:00:00
 |  |  |  |  |  |  | 2025-03-02 00:00:00 | 2025-10-31 00:00:00
 |  |  |  |  |  |  | 2025-03-03 00:00:00 | 2025-12-31 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-03-28 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-01-31 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2025-12-31 00:00:00
 |  |  |  |  |  |  | 2024-12-02 00:00:00 | 2024-12-27 00:00:00
 |  |  |  |  |  |  | 2025-04-01 00:00:00 | 2025-12-31 00:00:00
Spreadsheet: 115816d1311308577-small-cross-worksheet-calculation-error-transaction-record-updated-
Sheet: Jay's Split Expenses

Month | Date | Amount ($) | Description |  | Total: | 1344.76
1 | 2011-01-01 00:00:00 | 55 | Flowers for [NAME]' [NAME] | must be set to Jan 1st
1 | 2011-01-01 00:00:00 | 185.43 | [NAME] gifts for [NAME] (minus my moms gift (46$), minus defective metal detector ($27.31) | must be set to Jan 1st
1 | 2011-01-04 00:00:00 | 22.5 | Breakfast with B at Orange
1 | 2011-01-04 00:00:00 | 70.9 | New Skates and Stick at Play it Again
1 | 2011-01-08 00:00:00 | 10 | Entrance to [NAME]'s hockey tournament
2 | 2011-02-08 00:00:00 | 25 | Dinner at Super Noodle with B
2 | 2011-02-18 00:00:00 | 15 | [NAME]'s school fee for trip
3 | 2011-03-28 00:00:00 | 20 | Lunch at chinese restaurant
4 | 2011-04-07 00:00:00 | 37 | chinese lunch with B
5 | 2011-05-10 00:00:00 | 85 | Benjamin's Day camp from Living Social
5 | 2011-05-10 00:00:00 | 140 | Benjamin's Dentist appointment + Fluoride tablets
5 | 2011-05-23 00:00:00 | 200 | Soccer Registration
5 | 2011-05-29 00:00:00 | 37 | Soccer Equipment at Play it Again
6 | 2011-06-03 00:00:00 | 38.78 | Lunch at Bangkok Express
6 | 2011-06-25 00:00:00 | 33.15 | Ye olde after dropping B off with your parents
6 | 2011-06-27 00:00:00 | 20 | [NAME] after Toys R Us
7 | 2011-07-07 00:00:00 | 350 | Benjamin's teeth spacers (Dentist cost)
Spreadsheet: 549795d1511927000-hyperlink-function-reference-is-not-valid-when-refering-to-another-sheet-in-same-file-doc3-v2
Sheet: A

No. | Template | [NAME]
~
01 | Sheet 01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Spreadsheet: 494220d1482256298-distributed-amount-based-on-cells-in-same-column-insurance-premium-example-rev2
Sheet: Sheet1

SSN | # of Accts | Life Amt. | FTE | Split | Old Formula | Expected Results | New Formula Works | Variance from Expected |  | Named: [NAME]
123456789 |  | 50000 | 0.3005464480874317 |  |  | 1.28 |  |  |  | Life Amt. | Premium
123456789 |  | 50000 | 0.5 |  |  | 2.13 |  |  |  | 50000 | 4.25
123456789 |  | 50000 | 0.1994535519125683 |  |  | 0.84
12345678 |  | 50000 | 0.5 |  |  | 2.13 |  |  |  | Total Should Equal
12345678 |  | 50000 | 0.5 |  |  | 2.12 |  |  |  | =4.25*4
1234567 |  | 50000 | 0.25 |  |  | 1.06
1234567 |  | 50000 | 0.25 |  |  | 1.06
1234567 |  | 50000 | 0.25 |  |  | 1.06
1234567 |  | 50000 | 0.25 |  |  | 1.07
123456 |  | 50000 | 1 |  |  | 4.25
Total
 |  | Old Formula | Expected
 | 123456789 |  | 4.25
 | 12345678 |  | 4.25
 | 1234567 |  | 4.25
 | 123456 |  | 4.25
Spreadsheet: 0268e56d-5d3b-4893-8a66-beaa9a99bb88
Sheet: DID - Kansas 

Vendor Information
Vendor name: | AT&T |  |  | Address: 12851 [NAME], St. Louis, MO 63131 |  |  | Contact Name: [NAME] |  | GSA Region 6 LSA         Solicitation # 6QTC-11-SH-001
Phone number:      [PHONE] |  |  | Fax number:  NA |  |  |  | Email: [EMAIL]
CLIN | Services Offered | Geographic Area Served | MINUS 10%   Month To Month | Month To Month | One-Time Installation Price | MINUS 10% One-Time Installation Price | Service Pricing Notes |  | Tariff
 | DID Information
 | DID Trunk Termination for Analog DID Trunks (USOC-NDT, NTP, NMD)
K03A24-DP** | Dial Pulse (DP) Signalling (NDT) | Kansas | 20 |  |  | 12 |  |  | GE-SECT 16
K03A24-MF** | Multi-Frequency (MF) Signalling (NTP) | Kansas | 20 |  |  | 12 |  |  | GE-SECT 16
K03A24 - DTMF** | Dual Tone Multi-Frequency (DTMF) Signalling (NMD) | Kansas | 20 |  |  | 12 |  |  | GE-SECT 16
 | DID Numbers (NON-ISDN)
K03A25 | 1st 100 DID (ND8) | Kansas | 10 |  |  | 212 |  |  | GE-SECT 16
K03A25 | Additional 100 DID (ND9) | Kansas | 15 |  |  | 112 |  |  | GE-SECT 16
K03A25-1 | 1st 10 DID (NDZ) | Kansas | 2.25 |  |  | 122 |  |  | GE-SECT 16
K03A25-1a | Additional 10 DID (NDA) | Kansas | 2.25 |  |  | 26 |  |  | GE-SECT 16
 | DID Numbers (ISDN)
K03A25 - 001I | 1st 100 DID (ZT8) | Kansas | 10 |  |  | 200 |  |  | GE-SECT 16
K03A25A - 001I | Additional 100 DID (ZT9) | Kansas | 24.5 |  |  | 100 |  |  | GE-SECT 16
K03A25-1- 001I | 1st 10 DID (ZT5) | Kansas | 2.18 |  |  | 110 |  |  | GE-SECT 16
K03A25-1a- 001I | Additional 10 DID (ZT6) | Kansas | 5 |  |  | 14 |  |  | GE-SECT 16
K03A25-1s- 001I | Individual DID Number (ZTN) | Kansas | 1 |  |  | 10.5 |  |  | GE-SECT 16
Spreadsheet: 125429d1319028434-excel-2007-moving-values-between-sheets-by-using-number-commands-copy-of-afhendingase-lar-and-loadinfo-1
Sheet: ULD13&14

Name of airline |  |  |  | Aircraft Position |  |  | Name of Airline |  |  |  | Aircraft Position
Built up by: | Hjortur |  | Origin | ULD Ident |  |  | Built up by: | Hjortur |  | Origin | ULD Ident
Total Pages: |  |  |  |  |  |  | Total Pages:
AWB | DEST | PCS | WEIGHT |  | Flight Number |  | AWB | DEST | PCS | WEIGHT |  | Flight Number
 |  |  |  |  | Offload Point |  |  |  |  |  |  | Offload Point
 |  |  |  |  | Final Dest |  |  |  |  |  |  | Final Dest
ULD Tare Weight: |  |  |  |  |  |  |  | ULD Tare Weight:
RMK | Total |  |  |  |  |  | RMK | Total
Spreadsheet: 877840d1724784478-multiparameter-if-formula-needed-book1
Sheet: Instrument #1, #2, #3

 | Site:
 | Instrument #1: |  |  | Instrument #2: |  |  | Instrument #3:
 | Fluid TNC Count |  |  |  |  | [NAME]
 |  | #1 | #2 | %DIF | DIF |  | #1 | #2 | %DIF | DIF
 | 1 | 100 | 105 |  |  | 1
 | 2 | 19 | 26 |  |  | 2
 | 3 | 500 | 510 |  |  | 3
 | Mean: |  |  |  |  | Mean:
 |  | TEa = ± | 0.15 | if <28 ± | 4 |  | TEa = ± | 0.15 | if <28000± | 4000
 |  | Within 1/2 TEa? |  |  |  |  | Within 1/2 TEa?
 | Fluid TNC Count |  |  |  |  | [NAME]
 |  | #1 | #3 | %DIF | DIF |  | #1 | #3 | %DIF | DIF
 | 1 |  |  |  |  | 1
 | 2 |  |  |  |  | 2
 | 3 |  |  |  |  | 3
 | Mean: |  |  |  |  | Mean:
 |  | TEa = ± | 0.15 | if <28 ± | 4 |  | TEa = ± | 0.15 | if <28000± | 4000
 |  | Within 1/2 TEa? |  |  |  |  | Within 1/2 TEa?
 | ** "N/A" = above or below TEa %, but may or may not be within ± absolute difference value. See note below
Performed By: |  |  |  |  |  |  |  | Date:
Reviewed By: |  |  |  |  |  |  |  | Date:
Spreadsheet: diana_scholtes__8543__Financial Power Terminated
Sheet: Sheet1

Financial Power Transactions Terminated
AIG [NAME], LLC | Deal # 616996.01
Allegheny Energy Supply Company, LLC | All trades
American Electric Power Service Corporation | All trades
Aquila Risk Management Corporation | All trades
BP Corporation North America Inc. | All trades
Calpine Energy Services L.P. | All trades
Cargill, Incorporated | Deal # 813178.01
Consolidated Edison Energy, Inc. | All trades
Coral Energy Holding, L.P. | All trades
Duke Energy Trading and Marketing, L.L.C. | All trades
El Paso Merchant Energy, L.P. | All trades
Engage Energy America LLC | All trades
Engage Energy Canada, L.P. | 633424.01, 633418.01
Entergy-Koch Trading, LP | All trades
Exelon Generation Company, LLC | All trades
Maclaren Energy Inc. | All trades
Mirant Americas Energy Marketing, LP | All trades
New Power Company, The | All trades
NRG Power Marketing, Inc. | All trades
PPL EnergyPlus, LLC | All trades
Tractebel Energy Marketing, Inc. | All trades
Williams Energy Marketing & Trading Company | All trades
Spreadsheet: 126048d1319491600-top-5-conditional-formatting-testsheet
Sheet: Sheet1

 | $/cc @ 1k samples | $/cc @ 1k samples | $/cc @ 2k samples | $/cc @ 2k samples | $/cc @ 3k samples | $/cc @ 3k samples | $/cc @ 4k samples | $/cc @ 4k samples
 | per crate | per unit | per crate | per unit | per crate | per unit | per unit | per crate
product 1 | 1541 | 1049 | 3099 | 2122 | 4669 | 3195 | 6222 | 4264
product 2 | 1008 | 1562 | 2045 | 3156 | 3080 | 4747 | 4105 | 6335
product 3 | 1465 | 1112 | 2970 | 2250 | 4464 | 3388 | 5961 | 4521
product 4 | 1203 | 1374 | 2441 | 2773 | 3676 | 4168 | 4900 | 5562
product 5 | 1368 | 1215 | 2756 | 2455 | 4156 | 3693 | 5551 | 4929
product 6 | 1292 | 1295 | 2601 | 2612 | 3922 | 3926 | 5227 | 5228
product 7 | 1474 | 1111 | 2965 | 2249 | 4469 | 3388 | 5956 | 4521
product 8 | 1099 | 1475 | 2228 | 2979 | 3348 | 4481 | 4471 | 5980
product 9 | 1574 | 1020 | 3165 | 2060 | 4768 | 3100 | 6355 | 4136
product 10 | 1032 | 1540 | 2082 | 3118 | 3126 | 4695 | 4175 | 6265
product 11 | 1476 | 1114 | 2968 | 2252 | 4470 | 3389 | 5959 | 4523
product 12 | 1450 | 1129 | 2940 | 2284 | 4415 | 3437 | 5896 | 4587
product 13 | 1220 | 1356 | 2455 | 2746 | 3700 | 4137 | 4931 | 5521
product 14 | 1142 | 1436 | 2313 | 2899 | 3473 | 4361 | 4639 | 5819
product 15 | 1310 | 1276 | 2636 | 2577 | 3972 | 3876 | 5295 | 5172
product 16 | 1103 | 1481 | 2221 | 2969 | 3350 | 4475 | 4474 | 5971
product 17 | 1586 | 1001 | 3194 | 2025 | 4815 | 3050 | 6419 | 4070
product 18 | 1023 | 1558 | 2059 | 3143 | 3103 | 4725 | 4136 | 6305
product 19 | 1636 | 943 | 3318 | 1910 | 4985 | 2879 | 6657 | 3841
[NAME]: | 1636 | 1562 | 3318 | 3156 | 4985 | 4747 | 6657 | 6335
Spreadsheet: 7ab08cef-83d0-4baa-82f7-8c2c2843a416
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
RTSP | Test | RTSP | Rat Serum Protein, IgE | Rat Serum Protein, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
RTSP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
RTSP | Result | RTSP | Rat Serum Protein, IgE | Rat Serum Protein, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6225-7 | Rat serum proteins [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 750899d1633713892-ddl-of-names-that-populate-other-cells-w-different-data-drivers
Sheet: Sheet1

 | [NAME]
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
Tractor
Trailer
Driver
 | Drivers | Tractor | Trailer
 | Harod | 510 | 23
 | Freamen | 278 | 11
 | [NAME] | 277 | 15
 | Nestor | 366 | 28
 | [NAME] | 325 | 16
 | Hector | 629 | 13
 | [NAME] | 6526 | 17
 | [NAME] | 509 | 20
 | [NAME] | 84 | 30
 | Terrell | 396 | 21
Spreadsheet: 587036d1534797761-adding-data-to-new-sheets-from-main-sheet-example
Sheet: Orange

Orange | BMW | Tusla | 457
Orange | Ford | Bangor | 245
Orange | Chevy | Bangor | 357
Orange | Dodge | New York City | 658
Orange | Dodge | Miami | 537
Orange | BMW | Tusla | 463
Orange | GMC | Bangor | 13564
Orange | Chevy | New York City | 345
Orange | Dodge | Miami | 468
Orange | GMC | Tusla | 75
Orange | Chevy | Bangor | 456
Orange | Dodge | New York City | 4563
Spreadsheet: 150649d1334650128-copying-data-to-another-worksheet-ist-database
Sheet: Instructor Database

FIRST NAME | INITIAL | LAST NAME | DEPARTMENT | DATE
Second new | A | Test Tuesday | Sales | 2012-04-17 00:00:00
 | A
 | A
New test | A | Tuesday :) | Sales | 2012-04-17 00:00:00
New test | A | Tuesday :) | Sales | 2012-04-17 00:00:00
New test | A | Tuesday :) | Sales | 2012-04-17 00:00:00
Todays 2nd | a | NEW sample | Sales | 2012-04-16 00:00:00
Todays first | A | NEW Sample | Sales | 2012-04-16 00:00:00
Another Last | A | Sample | Sales | 2012-04-13 00:00:00
Last | A | Sample | Sales | 2012-04-13 00:00:00
Fourth | A | Sample | Management | 2012-04-13 00:00:00
Third | A | Sample | Public Affairs | 2012-04-13 00:00:00
Second | A | Sample | Accounting | 2012-04-13 00:00:00
First | A | Sample | Sales | 2012-04-13 00:00:00
Spreadsheet: 148905d1333611249-formulas-no-longer-working-with-date-format-excel-example_change-in-date-format
Sheet: Downgraded Tickets 

Incident number | Severity Change | Downgraded? | Reason
INC000002829632 | 2 to 3 | Y | Incident was an error message on the AIX P700 server . These error messages are warnings and have no affect on the production environment or service as a whole. Customer was notified that the solution was to shutdown the server - awaiting shutdown on 15th Jan before closing incident.
INC000002829269 | 2 to 3 | Y | Incident was a backup failure caused by running backups at the same time as scheduled daily Infrastructure backups. Backups were successfully re-run and no further issues occurred. Resillience incidents of this nature are Severity 3 at best.
INC000002875044 | 2 to 3 | Y | Incident was a backup failure caused by running backups at the same time as scheduled daily Infrastructure backups. Backups were successfully re-run and no further issues occurred. Resillience incidents of this nature are Severity 3 at best.
INC000003023903 | 2 to 4 | Y | The ticket is a service request for new File Systems on Pre-Prod and [NAME] environment. Infosys have assigned the ticket as a severity 2, as the creation of the File Systems needs to be done relatively urgently however all service requests should be Severity 4 with the urgency specified in the Notes of the ticket.
Spreadsheet: 839334d1691846514-nested-if-else-with-nearest-match-demo
Sheet: Sheet1

Salary Structure:  [NAME]
Month/Year:  Aug/2023
SLNO | EMP ID. | Name | DA | HRA | CONVEYANCE | LUNCH | OTHERS | UNIFORM | BASIC. | RES CH PAY | Remarks
1 | AV00001 | Muruganandam D | 2837 |  |  |  |  |  | 16423 |  | 35000
 |  |  |  |  |  |  |  |  | 11588 |  | 15100
Spreadsheet: 706991d1606991591-removing-div-0-test
Sheet: Sheet1

2020-11-30 00:00:00 |  | NUMBER OF FTA P/W
STAFF NAME | WORKING DIARY  MINS/PW | 1st CC 30 mins | CC Review 30 mins | WSR 10 mins | WSR 20 mins | WSR PROGRESS REVIEW 30 mins | WFI 10 Mins | 2 WK EMPLOYMENT SKILLS REVIEW 20 MINS | OTHER 30 mins | NUMBER OF WHITE SPACE P/W 5 mins | NUMBER OF BLOCKED SPACE P/W (non customer app.) 5 mins | TOTAL MINS (FTA+Blocked +White Space) | TOTAL HOURS (FTA+Blocked+White Space) | % Customer Contact | % Non Customer Contact | COMMITMENTS
A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BLANK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
C | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
D | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
E | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL
Spreadsheet: 701748d1603906638-how-to-apply-offset-to-index-and-match-result-apply-offset-to-index-match-result
Sheet: Sheet3

F3 | F#3 | G3 | G#3 | A3 | A#3 | B3 | C4 | C#4 | D4 | D#4 | E4 | F4 | F#4 | G4 | G#4 | A4 | A#4 | B4 | C5 | C#5 | D5 | D#5 | E5 | F5 | F#5 | G5 | G#5 | A5 | A#5 | B5 | C6 | C#6 | D6 | D#6 | E6 | F6 | F#6 | G6 | G#6 | A6 | A#6 | B6 | C7 | C#7 | D7 | D#7 | E7
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
E5 | F5 | F#5 | G5 | G#5 | A5 | A#5 | B5 | C6 | C#6 | D6 | D#6 | E6 | F6 | F#6 | G6 | G#6 | A6 | A#6 | B6 | C7 | C#7 | D7 | D#7 | E7
B4 | C5 | C#5 | D5 | D#5 | E5 | F5 | F#5 | G5 | G#5 | A5 | A#5 | B5 | C6 | C#6 | D6 | D#6 | E6 | F6 | F#6 | G6 | G#6 | A6 | A#6 | B6
G4 | G#4 | A4 | A#4 | B4 | C5 | C#5 | D5 | D#5 | E5 | F5 | F#5 | G5 | G#5 | A5 | A#5 | B5 | C6 | C#6 | D6 | D#6 | E6 | F6 | F#6 | G6
D4 | D#4 | E4 | F4 | F#4 | G4 | G#4 | A4 | A#4 | B4 | C5 | C#5 | D5 | D#5 | E5 | F5 | F#5 | G5 | G#5 | A5 | A#5 | B5 | C6 | C#6 | D6
A3 | A#3 | B3 | C4 | C#4 | D4 | D#4 | E4 | F4 | F#4 | G4 | G#4 | A4 | A#4 | B4 | C5 | C#5 | #5 | D#5 | E5 | F5 | F#5 | G5 | G#5 | A5
E3 | F3 | F#3 | G3 | G#3 | A3 | A#3 | B3 | C4 | C#4 | D4 | D#4 | E4 | F4 | F#4 | G4 | G#4 | A4 | A#4 | B4 | C5 | C#5 | D5 | D#5 | E5
Spreadsheet: 328398d1403886940-solver-error-in-maximizing-a-correlation-coefficient-y-index-index-correlations-excelforum
Sheet: M

Country | Y Score | Rank | Standard Rank | Standard Score
ALGERIA
ARGENTINA
AUSTRALIA
AUSTRIA
AZERBAIJAN
BANGLADESH
BARBADOS
BELGIUM
[NAME]
BRAZIL
BULGARIA
CANADA
CHILE
CHINA
COLOMBIA
COSTA RICA
CROATIA
CYPRUS
CZECH REPUBLIC
DENMARK
DOMINICAN REPUBLIC
ECUADOR
EGYPT
EL SALVADOR
ESTONIA
FINLAND
FRANCE
GEORGIA
GERMANY
GREECE
HONDURAS
HONG KONG
HUNGARY
ICELAND
INDIA
INDONESIA
IRAN
IRELAND
ISRAEL
ITALY
JAMAICA
JAPAN
JORDAN
KAZAKHSTAN
KOREA, REP. OF
LATVIA
LITHUANIA
MACEDONIA, FYR
MALAYSIA
MAURITIUS
MEXICO
MOLDOVA
MOROCCO
MYANMAR
NETHERLANDS
NEW ZEALAND
NICARAGUA
NORWAY
PAKISTAN
PALESTINIAN TERRITORY
PANAMA
PARAGUAY
PERU
PHILIPPINES
POLAND
PORTUGAL
QATAR
ROMANIA
RUSSIAN FEDERATION
SAUDI ARABIA
SERBIA
SINGAPORE
SLOVAKIA
SLOVENIA
SOUTH AFRICA
SPAIN
SRI LANKA
SWEDEN
TAIWAN
THAILAND
TRINIDAD & TOBAGO
TUNISIA
TURKEY
UKRAINE
UNITED KINGDOM
UNITED STATES
URUGUAY
UZBEKISTAN
VENEZUELA
VIETNAM
Spreadsheet: 182234d1348377917-pivot-dates-not-sorting-september-2012-week-3
Sheet: Mar - 2012

Actual Production vs Production Capacity
Months | Mar
Row Labels | Sum of Quantity | Sum of Capacity | Sum of Percentage
11-Mar | 10416 | 20000 | 0.5208
12-Mar | 19900 | 20000 | 0.995
13-Mar | 76912 | 20000 | 3.8456
14-Mar | 10928 | 20000 | 0.5464
18-Mar | 30445 | 20000 | 1.52225
19-Mar | 37532 | 20000 | 1.8766
1-Mar | 9870 | 20000 | 0.4935
20-Mar | 30808 | 20000 | 1.5404
21-Mar | 45788 | 20000 | 2.2894
22-Mar | 1584 | 20000 | 0.0792
25-Mar | 11000 | 20000 | 0.55
26-Mar | 17806 | 20000 | 0.8903
27-Mar | 27442 | 20000 | 1.3721
28-Mar | 37498 | 20000 | 1.8749
29-Mar | 9206 | 20000 | 0.4603
[NAME] | 32776 | 20000 | 1.6388
5-Mar | 35848 | 20000 | 1.7924
6-Mar | 7524 | 20000 | 0.3762
7-Mar | 71232 | 20000 | 3.5616
8-Mar | 17148 | 20000 | 0.8574
Grand Total | 541663 | 400000 | 1.3541575
Average per day:
Spreadsheet: 145883d1331796944-text-and-numbers-that-i-want-sorted-numerically-sort
Sheet: Sheet1

SORT THIS COLUMN
 | MFM019_1_Split End_Will [NAME]
 | MFM019_10_Humanoid_Danny Widdicombe
 | MFM019_11_From Hell_Peter Christie
 | MFM019_12_From Hell_Peter Christie
 | MFM019_13_Ice [NAME]
 | MFM019_14_Ice [NAME]
 | MFM019_15_Low_Brad Wall
 | MFM019_16_Low_Brad Wall
 | MFM019_17_Moody_Luke Adams
 | [NAME]
 | MFM019_19_Under Craft_Peter Christie
 | MFM019_2_Split End_Will [NAME]
 | MFM019_20_Under Craft_Peter Christie
 | MFM019_21_In My Head_Peter Christie
 | MFM019_22_In My Head_Peter Christie
 | MFM019_23_Wires_Tim Pasmore
 | MFM019_24_Wires_Tim Pasmore
 | MFM019_25_Factory Slave_Ross [NAME]
 | MFM019_26_Factory Slave_Ross [NAME]
 | MFM019_27_Hear The Silence_Peter Christie
 | MFM019_28_Hear The Silence_Peter Christie
 | MFM019_29_Lost Lust_Peter Christie
 | [NAME] Click_Peter Christie
 | MFM019_30_Lost Lust_Peter Christie
 | MFM019_31_Pulp_Peter Christie
 | MFM019_32_Pulp_Peter Christie
 | MFM019_33_Rain Parade_Peter Christie
 | MFM019_34_Rain Parade_Peter Christie
 | MFM019_35_Abyss_Peter Christie
 | MFM019_36_Abyss_Peter Christie
 | MFM019_37_Light Flickers_Danny Widdicombe
 | MFM019_38_Light Flickers_Danny Widdicombe
 | MFM019_39_Old [NAME]
 | MFM019_4_Broken Click_Peter Christie
 | MFM019_40_Old [NAME]
 | MFM019_41_Extreme [NAME]
 | MFM019_42_Extreme [NAME]
 | MFM019_43_Darkness Visible_Rachael Selleck
 | MFM019_44_Darkness Visible_Rachael Selleck
 | MFM019_45_Secret Liason_Peter Christie
 | MFM019_46_Secret Liason_Peter Christie
 | MFM019_47_The Prophet_Mikal [NAME]
 | MFM019_48_The Prophet_Mikal Laguerre
 | [NAME]
 | MFM019_5_Bound_Peter Christie
 | MFM019_50_Traffic Grind_Ross [NAME]
 | MFM019_6_Bound_Peter Christie
 | MFM019_7_Cut Cold_Peter Christie
 | MFM019_8_Cut Cold_Peter Christie
 | MFM019_9_Humanoid_Danny Widdicombe