tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 706370d1606665969-compare-json-data-and-splitting-into-corrected-codes-deleted-codes-and-added-codes-sample-data-for-added-deleted-corrected-queries-11292019
Sheet: Input 

Billid | Ctextid | [NAME] | user | created
2132 | 91156 | [   {     "description": "fabula ",     "dCode": "8901",     "CodeId": "90001",     "messages": [       ""     ],     "Number": 1   },   {     "description": "EXper ",     "dCode": "9034",     "CodeId": "88343",     "messages": [       ""     ],     "Number": 2   } ] | amt1 | 2020-08-03 17:07:37
2132 | 91156 | [   {     "description": "fabula ",     "dCode": "8901",     "CodeId": "90001",     "messages": [       ""     ],     "Number": 1   },   {     "description": "EXper ",     "dCode": "9034",     "CodeId": "88343",     "messages": [       ""     ],     "Number": 2   },  {     "description": "siluka ",     "dCode": "887756",     "CodeId": "883773",     "messages": [       ""     ],     "Number": 3   } ] | all1 | 2020-08-03 21:07:00
5678 | 99344 | [   {     "description": "TORYA ",     "dCode": "99002",     "CodeId": "988332",     "messages": [       ""     ],     "Number": 1   },   {     "description": "triact ",     "dCode": "90774",     "CodeId": "7800034",     "messages": [       ""     ],     "Number": 2   } ] | [NAME] | 2020-08-04 18:07:00
5678 | 99344 | [   {     "description": "TORYA ",     "dCode": "99002",     "CodeId": "988332",     "messages": [       ""     ],     "Number": 1   },   {     "description": "triact ",     "dCode": "90974",     "CodeId": "78034",     "messages": [       ""     ],     "Number": 2   } ] | jk2 | 2020-08-05 18:07:00
7789 | 60045 | [   {     "description": "ABNORMAL FINDINGS HELA ",     "dCode": "Z003345",     "CodeId": "288897",     "messages": [       ""     ],     "sequenceNumber": 1   },   {     "description": "IMPACTED  BILATERAL ",     "dCode": "U8923",     "CodeId": "7324",     "messages": [       ""     ],     "sequenceNumber": 2   },   {     "description": "IMMUNIZATION ",     "dCode": "H678",     "CodeId": "26519",     "messages": [       ""     ],     "sequenceNumber": 3   },   {     "description": " RUPT EAR DRUM ",     "dCode": "I0892",     "CodeId": "567123",     "messages": [       ""     ],     "sequenceNumber": 4   },   {     "description": "CHILDHOOD FEVER ",     "dCode": "Y98620",     "CodeId": "55467",     "messages": [       ""     ],     "sequenceNumber": 5   } ] | ec1 | 2020-08-07 06:07:00
7789 | 60045 | [   {     "description": "ABNORMAL FINDINGS HELA ",     "dCode": "Z8897645",     "CodeId": "288897",     "messages": [       ""     ],     "sequenceNumber": 1   },  {     "description": "IMMUNIZATION ",     "dCode": "H67891",     "CodeId": "26519",     "messages": [       ""     ],     "sequenceNumber": 2   },   {     "description": " RUPT EAR DRUM ",     "dCode": "I0892",     "CodeId": "567123",     "messages": [       ""     ],     "sequenceNumber": 3   },        {     "description": "Kirolo substaniss FEVER ",     "dCode": "J18907",     "CodeId": "66712",     "messages": [       ""     ],     "sequenceNumber": 4   } | ec2 | 2020-08-07 17:07:00
Spreadsheet: 749702d1632973847-calculate-unique-values-using-multiple-criteria-test1-4-
Sheet: S2

 | Required O/p |  |  |  |  |  |  |  | eTrade | Stock
Ticker | Cost Basis | Account |  |  |  |  |  |  | RobinHood | Option
 |  | eTrade
 |  | eTrade
 | Required: 3 Pie Charts for all 3 accounts showing Ticker and [NAME]
OFFICE 365 |  |  |  |  |  |  |  | https://www.excelforum.com/excel-formulas-and-functions/1360189-calculate-unique-values-using-multiple-criteria.html
ABML
ABNB
Spreadsheet: 757504d1638293693-get-results-from-large-data-in-excel-o365-tracking-1-
Sheet: Unknown Tickets O365

Problem - Office 365
Short description | Number | Created By
Spreadsheet: 169338d1342789069-simplified-way-of-displaying-data-for-training-and-information-house-clearance-log-sample2
Sheet: Raw Data

Customer Name | Customer Address | Date Enquiry Taken | Call Centre Member | Viewing Booked? Y/N | Viewing Date & Time | Viewer | Price Quoted | Clearance Booked? Y/N | Clearance Date | Clearance Time | [NAME]? Y/N | Amount Received |  |  |  |  |  |  |  |  |  |  |  | Viewing Booked | Viewers | Clearance Booked | Callcentre | Clearance Completed
Mr. [NAME] | 23 Acacia Avenue, Pontypandy, CF45 4GG | 2011-05-15 00:00:00 | Anne | yes | 2011-05-20 00:00:00 | Siôn | 300 | Yes | 2011-05-25 00:00:00 | 10am | Yes | 300 |  |  |  |  |  |  |  |  |  |  |  | Yes | Siôn | Yes | Anne | Yes
Mr. [NAME] | 24 Acacia Avenue, Pontypandy, CF45 4GG |  | Anne | yes | 2011-05-21 00:00:00 | Siôn | 200 | Yes | 2012-07-10 00:00:00 | 10am | Yes | 200 |  |  |  |  |  |  |  |  |  |  |  | No | Shaun | No | [NAME] | No
Ms. [NAME] | 25 Acacia Avenue, Pontypandy, CF45 4GG |  | Anne | yes | 2011-05-22 00:00:00 | Siôn | 250 | Yes | 2012-07-10 00:00:00 | 2pm | Yes | 250 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Leanne
 | 26 Acacia Avenue, Pontypandy, CF45 4GG |  | [NAME] | yes | 2011-05-23 00:00:00 | Siôn | 200 | Yes | 2012-07-12 00:00:00 | 10am | Yes | 200 |  | Total Prices Quoted |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 27 Acacia Avenue, Pontypandy, CF45 4GG |  | Leanne | yes | 2011-05-24 00:00:00 | Siôn | 300 | Yes | 2012-07-17 00:00:00 | 10am | Yes | 300 |  | Total Amounts Received |  |  |  |  |  |  |  |  |  |  |  |  | Sue
 | 28 Acacia Avenue, Pontypandy, CF45 4GG |  | Leanne | yes | 2011-05-25 00:00:00 | Siôn | 250 | Yes | 2012-07-26 00:00:00 | 10am | No | 0
Spreadsheet: 237786d1369311905-change-column-to-red-when-date-is-in-the-past-contractor-expiry-data
Sheet: Sheet1

Associate Name | [NAME] | Date of Expiry | Status
[NAME] | [EMAIL] | 2013-09-30 00:00:00
[NAME] | [EMAIL] | 2013-09-30 00:00:00
[NAME] | [EMAIL] | 2013-06-07 00:00:00 | 2013-05-23 12:25:07
[NAME] | [EMAIL] | 2013-12-31 00:00:00
[NAME] | [EMAIL] | 2013-05-31 00:00:00 | 2013-05-23 12:25:07
[NAME] | [EMAIL] | 2013-07-05 00:00:00
[NAME] | [EMAIL] | 2013-01-28 00:00:00 | 2013-05-23 11:49:40
[NAME] | [EMAIL] | 2013-06-30 00:00:00
[NAME] | [EMAIL] | 2013-05-31 00:00:00 | 2013-05-23 12:25:07
Conor Bradshaw | [EMAIL] | 2013-05-31 00:00:00 | 2013-05-23 12:25:07
[NAME] | [EMAIL] | 2013-12-31 00:00:00
[NAME] | [EMAIL] | 2013-05-31 00:00:00 | 2013-05-23 12:25:07
[NAME] | [EMAIL] | 2013-06-30 00:00:00
[NAME] | [EMAIL] | 2013-08-17 00:00:00
[NAME] | [EMAIL] | 2013-03-31 00:00:00 | 2013-05-23 11:49:40
[NAME] | [EMAIL] | 2013-06-15 00:00:00 | 2013-05-23 12:25:07
Iain Cornish | [EMAIL] | 2013-06-30 00:00:00
[NAME] | [EMAIL] | 2013-04-26 00:00:00 | 2013-05-23 11:49:40
[NAME] | [EMAIL] | 2013-05-31 00:00:00 | 2013-05-23 12:25:07
[NAME] | [EMAIL] | 2013-12-31 00:00:00
Lloyd Green | [EMAIL] | 2013-07-26 00:00:00
[NAME] | [EMAIL] | 2013-11-15 00:00:00
[NAME] | [EMAIL] | 2013-12-31 00:00:00
[NAME] | [EMAIL] | 2013-09-30 00:00:00
[NAME] | [EMAIL] | 2013-06-28 00:00:00
[NAME] | [EMAIL] | 2013-07-13 00:00:00
[NAME] | [EMAIL] | 2013-06-28 00:00:00
[NAME] | [EMAIL] | 2013-09-27 00:00:00
[NAME] | [EMAIL] | 2013-06-30 00:00:00
[NAME] | [EMAIL] | 2013-05-31 00:00:00 | 2013-05-23 12:25:07
[NAME] | [EMAIL] | 2013-06-28 00:00:00
[NAME] | [EMAIL] | 2013-05-24 00:00:00 | 2013-05-23 11:49:40
[NAME] | [EMAIL] | 2013-09-30 00:00:00
[NAME] | [EMAIL] | 2013-06-28 00:00:00
Siva [NAME] | [EMAIL] | 2013-07-31 00:00:00
Sriram [NAME] | [EMAIL] | 2013-12-31 00:00:00
[NAME] | [EMAIL] | 2014-07-30 00:00:00
[NAME] | [EMAIL] | 2013-06-14 00:00:00 | 2013-05-23 12:25:07
Vishal Pal | [EMAIL] | 20.05.2013 | 2013-05-23 12:05:30
Spreadsheet: 93123d1292614654-add-a-check-box-and-have-weight-added-when-box-is-checked-hiking-checklist-1-
Sheet: Sheet1

Hiking Checklist
Date(s) and Time(s):
Mountain(s):
Trail Description:
Driving Directions:
People:
 | Gear List |  | Weight |  |  |  |  |  | Weight Updates
 |  |  | Lbs | Oz |  |  |  |  | Lbs | Oz
 | ¨     Cold weather gear (Gloves, hat, sweater, thermals, ect)
 |  | 1 | 3 | 0 |  |  |  |  | 3 | 0
 |  | 1 | 4 | 2 |  |  |  |  | 4 | 2
 |  | 1 | 5 | 7 |  |  |  |  | 5 | 7
 |  | 1 | 0 | 3.5 |  |  |  |  | 0 | 3.5
 |  | 0 | 0 | 0 |  |  |  |  | 1 | 4
 |  | 1 | 2 | 10 |  |  |  |  | 2 | 10
 |  | 1 | 3 | 8 |  |  |  |  | 3 | 8
 |  | 1 | 0 | 5 |  |  |  |  | 0 | 5
 |  | 0 | 0 | 0 |  |  |  |  | 0 | 0
 |  | 0 | 0 | 0 |  |  |  |  | 0 | 3
 |  | 1 | 0 | 0 |  |  |  |  | 0 | 0
 |  | 0 | 0 | 0 |  |  |  |  | 0 | 4
 |  | 1 | 0 | 2 |  |  |  |  | 0 | 2
 |  | 1 | 0 | 0 |  |  |  |  | 0 | 0
 |  | 1 | 0 | 2 |  |  |  |  | 0 | 2
 |  | 0 | 0 | 0 |  |  |  |  | 4 | 0
 |  | 0 | 0 | 0 |  |  |  |  | 2 | 0
 |  | 1 | 5 | 12 |  |  |  |  | 5 | 12
 |  | 0 | 0 | 0 |  |  |  |  | 0 | 0
 |  | 0 | 0 | 0 |  |  |  |  | 0 | 0
 |  | 0 | 0 | 0 |  |  |  |  | 0 | 0
 |  | 0 | 0 | 0 |  |  |  |  | 0 | 0
 |  |  | Total Weight
 |  |  | 25 | 3.5
Spreadsheet: 58273328-6937-4705-9f08-5d81999bec50
Sheet: Sheet1

Supplemental Table 5. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
CG | Name | F/M | F/tra | F/dsxD | dsxD q-value | fru P1/M | [NAME] q-value
CG17820 | female-specific independent of transformer | 5.65864314 | 6.44760645 | 1.19997971 | 0.845160659 | 0.845655053 | 0.60952343
CG6416 | CG6416 | 1.45983538 | 1.62628721 | 1.41207692 | 0.316045283 | 1.00471693 | 0.734339289
CG16926 | CG16926 | 1.44616774 | 1.73154194 | 1.30358556 | 0.256304942 | 0.991685529 | 0.730002183
CG15261 |  | 1.41559009 | 1.48439133 | 1.3344417 | 0.314677175 | 0.950490292 | 0.647148627
CG33149 | Muscle LIM protein at 60A | 1.40948888 | 1.53872352 | 1.13610369 | 0.581428133 | 0.934422435 | 0.543769899
CG4898 | Tropomyosin 1 | 1.29410175 | 1.30046161 | 1.06788876 | 0.707035289 | 1.09206109 | 0.345171213
CG3350 | bigmax | 1.28172838 | 1.28009474 | 1.1430932 | 0.52019179 | 1.01442985 | 0.701101224
CG11590 | CG11590 | 1.2682122 | 1.27006527 | 0.86447874 | 1 | 0.915769409 | 0.413662326
CG7356 | CG7356 | 1.23697656 | 1.43673481 | 1.11399493 | 0.569594412 | 0.964604947 | 0.622361957
CG14207 | CG14207 | 1.20105686 | 1.31665452 | 1.15624792 | 0.415806109 | 1.01845005 | 0.682220021
CG14109 | CG14109 | 1.1983852 | 1.20709541 | 0.848672969 | 1 | 1.08966759 | 0.319004285
CG9521 | CG9521 | 1.1753145 | 1.24811289 | 1.05976487 | 0.755467307 | 1.03527168 | 0.615708054
CG40359 | CG40359 | 1.14771733 | 1.25653462 | 1.03988836 | 0.804304804 | 0.978369114 | 0.650435568
CG14963 | CG14963 | 0.848516838 | 0.755214278 | 1.00194784 | 0.966028597 | 1.00405628 | 0.728178792
CG4162 | lace | 0.842097173 | 0.813578978 | 0.900770305 | 0.459361226 | 1.08196972 | 0.341425312
CG1088 | Vacuolar H[+]-ATPase 26kD E subunit | 0.835687927 | 0.784993491 | 1.01807367 | 0.992639189 | 1.07641774 | 0.356295182
CG9674 | CG9674 | 0.830978878 | 0.842477762 | 1.04918162 | 1 | 1.02513674 | 0.635144257
CG10904 | CG10904 | 0.826649831 | 0.826593033 | 1.05161824 | 1 | 1.00493769 | 0.724353216
CG32451 | Secretory Pathway Calcium atpase | 0.818452725 | 0.688276482 | 0.819477888 | 0.286301687 | 0.981075084 | 0.693624459
CG11143 | Inos | 0.8006389 | 0.735069982 | 0.858151872 | 0.535708651 | 1.09547092 | 0.435746345
CG14868 | CG14868 | 0.771282844 | 0.681650637 | 1.0799018 | 1 | 1.02795156 | 0.621600156
CG6765 | CG6765 | 0.770500356 | 0.77096499 | 0.832639943 | 0.274672785 | 0.998959171 | 0.737940225
CG11711 | Mob1 | 0.758794535 | 0.807298027 | 0.955569928 | 0.835154693 | 1.10834562 | 0.266194548
CG13833 | CG13833 | 0.718184635 | 0.704210924 | 0.923918051 | 0.757905325 | 1.0380109 | 0.632699657
Spreadsheet: 0b539bf3-05fa-4db3-a80f-e245f04bc2a2
Sheet: Sheet1

Fecha | Cultivo | Variedad | T / DS | Cama mts. | # de surcos | [NAME] mts | Espaciado en el surco (centimetros) | # de plantas | Clave [NAME] cama | Notas
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
Spreadsheet: 700720d1603302489-if-formula-problems-clin-tracking-base-year-10012020lkf
Sheet: OBLIGATEDSERVICE

 |  |  |  | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
PR/PO # | VENDOR | DATE | AMOUNT | OCTOBER | NOVEMBER | DECEMBER | JANUARY | FEBRUARY | [NAME] | APRIL | MAY | [NAME] | JULY | AUGUST | SEPTEMBER | CLIN #
 |  | Total
 |  | 0.0868
 |  | Total
Spreadsheet: 880673d1728505969-reference-a-worksheet-using-cell-text-example
Sheet: Sheet2

Date | Transaction Type | Amount
2022-09-30 00:00:00 | Credit | 0.29
2022-08-31 00:00:00 | Credit | 0.3
2022-08-12 00:00:00 | Credit | 400
2022-07-31 00:00:00 | Credit | 0.29
2022-07-11 00:00:00 | Credit | 91.8
2022-07-05 00:00:00 | Credit | 400
2022-06-30 00:00:00 | Credit | 0.26
2022-06-17 00:00:00 | Credit | 3400
2022-05-31 00:00:00 | Credit | 0.26
2022-05-03 00:00:00 | Credit | 1688
2022-05-03 00:00:00 | Credit | 1095
2022-04-30 00:00:00 | Credit | 0.23
2022-04-20 00:00:00 | Credit | 25
2022-03-31 00:00:00 | Credit | 0.24
2022-03-21 00:00:00 | Debit | -127.5
Spreadsheet: 188097d1350675658-copying-3-sheets-into-one-sheet-mergeworksheetscode
Sheet: Sheet3

Header 1 | [NAME] | [NAME] | [NAME] | [NAME] | Header 6 | [NAME]
[NAME] of Sheet3 | Cell B2 of Sheet3 | Cell C2 of Sheet3 | Cell D2 of Sheet3 | Cell E2 of Sheet3 | Cell F2 of Sheet3 | Cell G2 of Sheet3
Cell A3 of Sheet3 | Cell B3 of Sheet3 | Cell C3 of Sheet3 | Cell D3 of Sheet3 | Cell E3 of Sheet3 | Cell F3 of Sheet3 | Cell G3 of Sheet3
Cell A4 of Sheet3 | Cell B4 of Sheet3 | Cell C4 of Sheet3 | Cell D4 of Sheet3 | Cell E4 of Sheet3 | Cell F4 of Sheet3 | Cell G4 of Sheet3
Spreadsheet: 135888d1326294485-easy-copy-only-written-cells-from-column-a-to-column-b-ef6_copy-of-mappe2-3-
Sheet: Tabelle1

1
2
3
4
5
6
7
Spreadsheet: e4a79be2-1a08-4412-b41c-aff8fac83e09
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Quelle: http://ergebnisse.vimentis.ch/
Frage:
Das AHV-Rentenalter wird erhöht.
 | [NAME] hoch ist das in Ihrem Haushalt zur Verfügung stehende Einkommen pro Monat?
Antwort | [NAME]. 3000.- | Fr. 3001.- bis 4500.- | Fr. 4501.- bis 6000.- | Fr. 6001.- bis 8000.- | Fr. 8001.- bis 12'000.- | [NAME]. 12'000.-
[NAME] | 0.24 | 0.25 | 0.26 | 0.32 | 0.37 | 0.5
Neutral/Weiss nicht | 0.14 | 0.13 | 0.13 | 0.13 | 0.12 | 0.1
[NAME] | 0.62 | 0.61 | 0.61 | 0.55 | 0.5 | 0.4
Angaben zu den [NAME]
Erhebungsjahr | 2010
Stichprobengrösse | 29292
Erhebungszeitraum | 02.10.2010 bis: 06.12.2010
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 784197d1655495904-trying-to-format-one-column-with-different-values-depending-on-another-column-sample
Sheet: Sheet1

1 | Campaign 1
1 | Campaign 1
2 | Campaign 2
2 | Campaign 2
3 | Campaign 3
3 | Campaign 3
3 | Campaign 3
4 | Campaign 4
4 | Campaign 4
5 | Campaign 5
Spreadsheet: 769699d1645639950-calculating-income-amounts-between-tax-band-breakpoints-tax_calculation_workbook_1
Sheet: Tax and NI

 | Taxable Income: |  |  |  |  | 70000
 | Tax | Breakpoint | Income Affected |  | Rate | Tax Amount
 | Personal Allowance | 0 | = the amount of taxable income (E1) between breakpoints (B4) and (B5) | 12570 | 0 | 0
 | Basic Rate | 12570 | = the amount of taxable income (E1) between breakpoints (B5) and (B6) | 37700 | 0.2 | 7540
 | Higher Rate | 50270 | = the amount of taxable income (E1) between breakpoints (B6) and (B7) | 19730 | 0.4 | 7892
 | Additional Rate | 150000 | = the amount of taxable income (E1) above breakpoint (B7) | 0 | 0.45 | 0
 | Total:
 | National Insurance | Breakpoint | Income Affected |  | Rate | NI Amount
 | Class 2 | 0 | = the amount of taxable income (E1) between breakpoints (B11) and (B12) | 6515 | 0 | 0
 | Class 2 | 6515 | = the amount of taxable income (E1) between breakpoints (B12) and (B13) | 3053 | £3.05 a week
 | Class 4 | 9568 | = the amount of taxable income (E1) between breakpoints (B13) and (B14) | 40702 | 0.1025 | 4171.96
 | Class 4 | 50270 | = the amount of taxable income (E1) above breakpoint (B14) | 19730 | 0.0325 | 641.23
 | Total:
 | Total Tax and NI Due:
Spreadsheet: 835308d1688489418-latest-data-copy-and-paste-in-sheet-2-latest-data-copy-and-paste
Sheet: Sheet2

TIME | PRODUCT NO | PRICE
2023-07-04 20:12:11.300000 | 19000
2023-07-04 20:12:11.300000 | 19050
2023-07-04 20:12:11.300000 | 19100
2023-07-04 20:12:11.300000 | 19150
2023-07-04 20:12:11.300000 | 19200
2023-07-04 20:12:11.300000 | 19250
2023-07-04 20:12:11.300000 | 19300 |  |  |  | Dear Sir
2023-07-04 20:12:11.300000 | 19350 |  |  |  | I have data in sheet 1 which has updating in specific time interval.The Data has content with Product Number and Product Price.
2023-07-04 20:12:11.300000 | 19400 |  |  |  | I want copy and paste the current Time Interval Product Price in Sheet 2 .
2023-07-04 20:12:11.300000 | 19450 |  |  |  | The Data will have updating in 1 minute time interval. and i want to copy and paste current time interval Price in respective product Number.
2023-07-04 20:12:11.300000 | 19500 |  |  |  | (In our example 8.12.11 PM Product Number of 19500  PRICE IS 200136 which should be copy and paste in sheet 2 at their respective Product Number)
2023-07-04 20:12:11.300000 | 19550 |  |  |  | The Sheet 2 will update when the new data will come in Sheet 1 after 1 minute time interval.
2023-07-04 20:12:11.300000 | 19600
2023-07-04 20:12:11.300000 | 19650
2023-07-04 20:12:11.300000 | 19700
2023-07-04 20:12:11.300000 | 19750
2023-07-04 20:12:11.300000 | 19800
2023-07-04 20:12:11.300000 | 19850
2023-07-04 20:12:11.300000 | 19900
2023-07-04 20:12:11.300000 | 19950
2023-07-04 20:12:11.300000 | 20000
Spreadsheet: 862566d1710255573-if-formula-when-value-is-a-text-example-file
Sheet: Data

Department | Worked Department | Location
010001 - Executive | 010001 - Executive
490043 - Southwest | 490043 - Southwest
180322 - Stockton | Southeast
140777 - Tello | AEG
010002 - North | 010002 - Executive
256987- RockyHIll | 256987-Rocky Hill
180322 - Stockton | Southeast
140777 - Tello | AEG
265987 - Danbury | Danbury
986514 - Windsor | Windsor
698745 - Montreal | 698745 - Montreal
Spreadsheet: 489315d1479209270-excel-report-from-multiple-excel-files-qrn-275-and-276
Sheet: Splice Elements

Identifiers | Wavelength (nm) | Element 2 |  |  | Element 3 |  |  | Element 4
 |  | Splice |  |  | Splice |  |  | Splice
 |  | 0.0787 (km) |  |  | 1.3071 (km) |  |  | 1.8086 (km)
 |  | Loss (dB) |  |  | Loss (dB) |  |  | Loss (dB)
 |  | A->B | B->A | [NAME]. | A->B | B->A | [NAME]. | A->B | B->A | [NAME].
QRN FC 12; 275 | 1310 | 0.26 | -0.125 | 0.068 | 0.097 | 0.005 | 0.051 | 0.134 | -0.101 | 0.016
 |  | Pass | Pass | Pass | Pass | Pass | Pass | Pass | Pass | Pass
QRN FC 12; 276 | 1310 | 0.323 | -0.266 | 0.028 | 0.129 | 0.046 | 0.088
 |  | Fail | Pass | Pass | Pass | Pass | Pass
QRN FC 12; 275 | 1490 | 0.264 | -0.142 | 0.061 | 0.086 | 0.008 | 0.047 | 0.149 | -0.122 | 0.013
 |  | Pass | Pass | Pass | Pass | Pass | Pass | Pass | Pass | Pass
QRN FC 12; 275 | 1550 | 0.271 | -0.165 | 0.053 | 0.081 | 0.02 | 0.05 | 0.147 | -0.119 | 0.014
 |  | Pass | Pass | Pass | Pass | Pass | Pass | Pass | Pass | Pass
QRN FC 12; 276 | 1490 | 0.374 | -0.272 | 0.051 | 0.107 | 0.051 | 0.079
 |  | Fail | Pass | Pass | Pass | Pass | Pass
QRN FC 12; 276 | 1550 | 0.398 | -0.292 | 0.053 | 0.097 | 0.05 | 0.074
 |  | Fail | Pass | Pass | Pass | Pass | Pass
 |  | Unknown |  | Unknown
Spreadsheet: scott_neal__37995__focus
Sheet: Sheet1

[NAME] | [NAME]
SCANA, Inc. | Florida Power & Light
Subs.  Public Service of North Carolina
South Carolina Pipeline | Florida Power Corporation
Carolina Power & Light | TECO
Sub.   North Carolina Natural Gas | Subs.   Peoples Gas System
 | Hardee Power Partners
Southern Company Services Inc. | Tampa Electric
Subs.  Georgia Power | TECO Power Services
Missisippi Power
Alabama Power | Orlando Utilities Commission
Savannah Gas and Electric
Gulf Power | City of Tallahassee
Atlanta Gas Light | Jacksonville Electric Authority
Subs.  Chattanooga Gas Company
Philadelphia Gas Works
Alabama Gas Corporation
Municipal Gas Authority of Georgia
Spreadsheet: 133159d1324238521-excel-2007-drop-lists-on-invoices-na-problem
Sheet: Cupcakes

 | Cupcakes
 |  |  | Price per Cupcake | Quantity | Total | Price per Figured Cupcake | Quantity | Total
 | Chocolate Cupcakes |  | 1.3 | 12 | 15.6 | 1 | 6 | 6
 | Vanilla Cupcakes |  | 1.3 | 0 | 0 | 1 | 0 | 0
 | Carrot and Orange Cupcakes |  | 1.7 | 0 | 0 | 1 | 0 | 0
 | Lemon Cupcakes |  | 1.3 | 0 | 0 | 1 | 0 | 0
 | Coffee and Walnut Cupcakes |  | 1.7 | 0 | 0 | 1 | 0 | 0
 | [NAME] |  | 1.7 | 0 | 0 | 1 | 0 | 0
 | Peanut Butter Cupcakes |  | 1.3 | 0 | 0 | 1 | 0 | 0
 | Totals |  |  |  | 15.6 |  |  | 6
 |  |  |  |  |  | Subtotal | 21.6
 | Frostings |  |  |  |  |  | Extra Costs
 |  |  | Price per Cupcake | Quantity | Total |  | Item | Unit | Cost per Unit | Units Used | Cost of Units
 | Buttercream |  | 0.3 | 0 | 0
 | Chocolate Ganache |  | 0.5 | 12 | 6 |  | Labour | Hour | 8 |  | 0
 | Cream Cheese Frosting |  | 0.5 | 0 | 0 |  | [NAME] | Hour | 5 |  | 0
 | Orange Buttercream |  | 0.3 | 0 | 0 |  | Delivery | Mile | 0.6 | 7 | 4.2
 | Coffee Buttercream |  | 0.3 | 0 | 0 |  | [NAME] | Per [NAME] | 6 | 0 | 0
 |  |  |  |  |  |  | Taken Deposit | Pounds | 1 | 6 | -6
 |  |  |  | Subtotal | 6 |  |  |  | Subtotal | 4.2
 | Cupcake Extras |  |  |  |  |  |  |  | Totals
 | Item | Size | Unit | Cost | Cost Per Unit | Units Used | Cost of Units |  | Cupcake Cost | 27.6
 |  |  |  |  |  |  |  |  | Delivery | 4.2
 | Food Colouring | 1 | pot | 2.79 | 2.79 |  | 0 |  | [NAME] | 0
 | Petal Dusts | 1 | pot | 2.29 | 2.29 |  | 0 |  | Taken Deposit | -6
 | Glitters | 1 | pot | 2.33 | 2.33 |  | 0
 | Sprinkles | 1 | pot | 2.1 | 2.1 |  | 0 |  | Grand Total | 25.8
 | [NAME] | 1 | pot | 6.45 | 6.45 |  | 0
 | Edible Glue | 1 | pot | 1.95 | 1.95 |  | 0
 | White Modelling Chocolate | 1000 | g | 26.5 | 0.0265 |  | 0
 | ModeLling chocolate | 1000 | g | 26.5 | 0.0265 |  | 0
 | Sugar Paste | 453 | g | 5.99 | 0.01322295805739514 |  | 0
 | Pouring Sugar Paste | 2000 | g | 12.99 | 0.006495 |  | 0
 | Flower Paste | 500 | g | 1.58 | 0.00316 |  | 0
 | [NAME] | 100 | g | 0.3 | 0.003 |  | 0
 | Milk Chocolate | 100 | g | 0.3 | 0.003 |  | 0
 | White Chocolate | 150 | g | 0.64 | 0.004266666666666667 |  | 0
 | [NAME] | 397 | g | 2.99 | 0.007531486146095718 |  | 0
 | Cupcake Wrappers | 144 | single | 5.53 | 0.03840277777777778 | 0 | 0
 | Lolly Sticks | 100 | single | 2 | 0.02 | 0 | 0
 | Icing Bags | 100 | single | 17.06 | 0.1706 | 0 | 0
 | Cutters | 1 | set | 2.92 | 2.92 |  | 0
 | Paint Brushes | 1 | set | 7.49 | 7.49 |  | 0
 | Ribbon | 2000 | cm | 8.99 | 0.004495 |  | 0
 | Parchment paper | 10 | m | 1.5 | 0.15 |  | 0
 |  |  |  |  | Subtotal | 0