tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 774217d1648309008-how-to-de-duplicate-from-the-source-area-of-a-and-b-and-get-the-number-of-repetitions-3026
Sheet: Sheet1

Product | Code |  | Product | Code
CSC-Q3022 | 1000 |  | CSC-Q3022 | 3
CSC-Q3022 | 1001 |  | CSC-Q3023 | 3
CSC-Q3023 | 1000 |  | CSC-Q8611 | 2
CSC-Q8611 | 1000 |  | CSC-Q8617 | 2
CSC-Q8617 | 1000 |  | CSC-Q8811 | 5
CSC-Q8811 | 1000 |  | CSC-Q8812 | 4
CSC-Q8811 | 1000 |  | CSC-Q8813 | 4
CSC-Q8811 | 1000 |  | CSC-Q8815 | 5
CSC-Q8811 | 1003 |  | CSC-Q8816 | 4
CSC-Q8811 | 1003 |  | CSC-Q8817 | 4
CSC-Q8811 | 1001
CSC-Q8812 | 1004
CSC-Q8812 | 1005
CSC-Q8812 | 1003
CSC-Q8813 | 1003
CSC-Q8813 | 1001
CSC-Q8815 | 1004
CSC-Q8815 | 1000
CSC-Q8815 | 1003
CSC-Q8815 | 1003
CSC-Q8816 | 1004
CSC-Q8816 | 1003
CSC-Q8817 | 1004
CSC-Q8817 | 1004
CSC-Q8817 | 1000
CSC-Q8817 | 1000
CSC-Q8817 | 1003
CSC-Q3022 | 1005
CSC-Q3022 | 1000
CSC-Q8611 | 1005
CSC-Q8611 | 1000
CSC-Q8617 | 1000
CSC-Q8617 | 1001
CSC-Q8811 | 1005
CSC-Q8811 | 1000
CSC-Q8811 | 1000
CSC-Q8811 | 1003
CSC-Q8811 | 1001
CSC-Q8811 | 1001
CSC-Q8812 | 1000
CSC-Q8812 | 1003
CSC-Q8813 | 1005
CSC-Q8813 | 1000
CSC-Q8815 | 1000
CSC-Q8815 | 1001
CSC-Q8816 | 1005
CSC-Q8816 | 1000
CSC-Q8817 | 1000
CSC-Q3023 | 1006
CSC-Q8813 | 1003
CSC-Q8816 | 1004
CSC-Q8817 | 1000
CSC-Q8817 | 1003
CSC-Q3022 | 1005
CSC-Q3022 | 1000
CSC-Q3023 | 1005
CSC-Q3023 | 1000
CSC-Q8611 | 1000
CSC-Q8617 | 1000
CSC-Q8811 | 1004
CSC-Q8811 | 1005
CSC-Q8811 | 1005
CSC-Q8811 | 1000
CSC-Q8811 | 1000
CSC-Q8812 | 1005
CSC-Q8812 | 1005
CSC-Q8812 | 1000
CSC-Q8813 | 1005
CSC-Q8813 | 1000
CSC-Q8815 | 1005
CSC-Q8815 | 1005
CSC-Q8815 | 1000
CSC-Q8815 | 1000
CSC-Q8815 | 1000
CSC-Q8816 | 1005
CSC-Q8816 | 1005
CSC-Q8816 | 1000
CSC-Q8817 | 1005
CSC-Q8817 | 1000
Spreadsheet: 683959d1593072259-auto-update-data-forum
Sheet: Sheet1

Date | Time | A PARTY | b party | a party name | b party name
2020-01-02 00:00:00 | 11:01:50 | 455123123 | 455123144
2020-01-02 00:00:00 | 11:20:10 | 455123123 | 455123145
2020-01-03 00:00:00 | 11:38:30 | 455123123 | 455123146
2020-01-04 00:00:00 | 11:56:50 | 455123123 | 455123147
2020-01-05 00:00:00 | 12:15:10 | 455123123 | 455123148
2020-01-06 00:00:00 | 12:33:30 | 455123123 | 455123149
2020-01-07 00:00:00 | 12:51:50 | 455123123 | 455123150
2020-01-08 00:00:00 | 13:10:10 | 456123456 | 455123123
2020-01-09 00:00:00 | 13:28:30 | 456123457 | 455123123
2020-01-10 00:00:00 | 13:46:50 | 456123458 | 455123123
2020-01-11 00:00:00 | 14:05:10 | 456123459 | 455123123
2020-01-12 00:00:00 | 14:23:30 | 456123460 | 455123123
2020-01-13 00:00:00 | 14:41:50 | 456123461 | 455123123
2020-01-14 00:00:00 | 15:00:10 | 456123462 | 455123123
Spreadsheet: 703054d1604696910-grouping-using-values-in-a-column-and-comparing-data-within-each-grouping-excel-help-copy
Sheet: Sheet2

Color | Shoe Size | Sold | How can I create a formula that looks at Column A (essentially grouping the lines by color) and if there is a value of "no" in Column C (this is the variance) for that grouped color, then list the color in all associated cells in Column D
Green | 7 | Yes | Green | So cells D2 to D5 show Green because a different value (e.g. No) exists in the group (cell C4)
Green | 8 | Yes | Green
Green | 9 | No | Green
Green | 10 | Yes | Green
Blue | 7 | Yes | --
Blue | 8 | Yes | --
Blue | 9 | Yes | --
Pink | 5 | No | Pink
Pink | 6 | No | Pink
Pink | 7 | Yes | Pink
Pink | 8 | Yes | Pink
Pink | 9 | Yes | Pink
Pink | 10 | Yes | Pink
Spreadsheet: 692761d1598542702-payment-tracker-test-paymentsindexandsmall
Sheet: Results

 | Payment Status | Due
Invoice Date | Client Name | Service Type | Service Sub Type | From Date | To Date | Qty | Per Day | Invoice Amt
Spreadsheet: 118750d1313979214-count-games-played-2011-mls-standings-and-bracket
Sheet: Bracket

 |  |  |  |  | W1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E1
WC1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WC2
 |  |  |  |  | WC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WC
WC4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | West Conference |  |  |  | East Conference |  |  |  |  |  |  |  |  |  |  |  |  |  | WC3
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E2
 |  |  |  |  | W3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E3
Spreadsheet: 126783d1319918620-pulling-specific-rows-from-a-data-set-exman999
Sheet: Display

A | << Key | Items | 7
notion | translation | 168 | Not wanting to make a big deal of yesterday, I wave the notion away
cologne | translation | 171 | Our chest nearly touch and the spicy scent of his cologne fills my nostrils.
crotch | translation | 172 | I bring my knee straight up into his crotch
shaky | translation | 173 | He is shaky, still having trouble brathing
massacre | translation | 176 | It was a massacre
carnivores | translation | 178 | Then, the carnivores weren't far behind
[NAME] | translation | 180 | a person, animal or object which is believed to bring good luck, or which represents an organization
Spreadsheet: 835904d1688971497-date-time-subtracting-formula-time-calculation-beamer
Sheet: Sheet1

 | Emp. Name | Schedule delivery date | Actual Delivery Date | From station | To Station | Original Dep. Time | [NAME]. Time | Expected Arrival Time | [NAME] time | Car Model | Car Plate |  | Actual Parking Out date | Actual Parking Out Time | Actual Premises Out Date | Actual Premises Out time | Actual Parking Arrival Date | Actual Parking Arrival Time | Actual Premisis arrival Date | Actual Premisis arrival Time
 | [NAME] | 2027-07-06 00:00:00 | 2027-07-07 00:00:00 | STN | STM | 22:05:00 | 02:00:00 | 03:15:00 | 06:47:00 | Chev2. | CERKAA12 |  | 2027-07-07 00:00:00 | 01:56:00 | 2027-07-07 00:00:00 | 02:07:00 | 2027-07-07 00:00:00 | 06:37:00 | 2027-07-07 00:00:00 | 07:03:00
 | [NAME] | 2027-07-06 00:00:00 | 2027-07-06 00:00:00 | STN | STM | 00:05:00 | 00:05:00 | 02:15:00 | 02:08:00 | Chev2. | CERKAA123 |  | 2027-07-05 00:00:00 | 23:58:00 | 2027-07-06 00:00:00 | 00:14:00 | 2027-05-08 00:00:00 | 01:58:00 | 2027-07-06 00:00:00 | 02:06:00
 | [NAME] | 2027-05-08 00:00:00 | 2027-05-08 00:00:00 | STN | STM | 03:50:00 | 03:50:00 | 09:00:00 | 08:27:00 | Chev2. | CERKAA13 |  | 2027-05-08 00:00:00 | 03:49:00 | 2027-05-08 00:00:00 | 04:02:00 | 2027-05-08 00:00:00 | 08:17:00 | 2027-05-08 00:00:00 | 08:25:00
 |  | 2023-07-05 00:00:00 | 2023-07-06 00:00:00 | STN | STM | 22:05:00 | 02:00:00 | 03:15:00 | 06:47:00 | Chev2. | CERKAA12 |  | 2023-07-06 00:00:00 | 01:56:00 | 2023-07-06 00:00:00 | 02:07:00 | 2023-07-06 00:00:00 | 06:37:00 | 2023-07-06 00:00:00 | 07:03:00
 |  | 2023-07-05 00:00:00 | 2023-07-05 00:00:00 | STN | STM | 03:50:00 | 03:50:00 | 09:00:00 | 08:27:00 | Chev2. | CERKAA13 |  | 2023-07-05 00:00:00 | 03:49:00 | 2023-07-05 00:00:00 | 04:02:00 | 2023-07-05 00:00:00 | 08:17:00 | 2023-07-05 00:00:00 | 08:25:00
 |  | 2023-07-05 00:00:00 | 2023-07-05 00:00:00 | STN | STM | 03:55:00 | 03:55:00 | 10:00:00 | 09:29:00 | Chev2. | CERKAA14 |  | 2023-07-05 00:00:00 | 03:43:00 | 2023-07-05 00:00:00 | 04:14:00 | 2023-07-05 00:00:00 | 09:19:00 | 2023-07-05 00:00:00 | 09:29:00
 |  | 2023-07-05 00:00:00 | 2023-07-05 00:00:00 | STN | STM | 22:30:00 | 22:30:00 | 02:35:00 | 02:05:00 | Chev2. | CERKAA15 |  | 2023-07-05 00:00:00 | 22:20:00 | 2023-07-05 00:00:00 | 22:32:00 | 2023-07-06 00:00:00 | 01:55:00 | 2023-07-06 00:00:00 | 02:13:00
 |  | 2023-07-05 00:00:00 | 2023-07-05 00:00:00 | STN | STM | 18:00:00 | 18:00:00 | 19:50:00 | 19:35:00 | Chev2. | CERKAA16 |  | 2023-07-05 00:00:00 | 17:56:00 | 2023-07-05 00:00:00 | 18:06:00 | 2023-07-05 00:00:00 | 19:25:00 | 2023-07-05 00:00:00 | 19:33:00
Spreadsheet: 817750d1676425985-weekday-formula-weekday-spreadsheet
Sheet: Sheet1

 |  | 2023-02-12 00:00:00
 |  | 2023-02-13 00:00:00
 |  | 2023-02-14 00:00:00
 |  | 2023-02-15 00:00:00
 |  | 2023-02-16 00:00:00
 |  | 2023-02-17 00:00:00
 |  | 2023-02-18 00:00:00
 |  | 2023-02-19 00:00:00
 |  | 2023-02-20 00:00:00
 |  | 2023-02-21 00:00:00
 |  | 2023-02-22 00:00:00
 |  | 2023-02-23 00:00:00
 |  | 2023-02-24 00:00:00
 |  | 2023-02-25 00:00:00
 |  | 2023-02-26 00:00:00
 |  | 2023-02-27 00:00:00
Spreadsheet: 678498d1589917503-combine-multiple-columns-into-one-removing-blanks-delete-blanks
Sheet: Dropdowns

Plan Types |  |  | ABC Basic Menu
X |  |  | Passive
X |  |  | Core
X |  |  | Expanded
X
X |  |  | ABC TDF
X |  |  | aa
X |  |  | bb
X |  |  | cc
X |  |  | dd
X |  |  | ee
 |  |  | ff
Fund Lineup
X
X
ABC
X
Fiduciary Services
X
X
n/a
Spreadsheet: daren_farmer__6653__CES - April
Sheet: Avails 4-6

[NAME] (PennzEnergy) South Texas Properties
Effective: | 2000-04-06 00:00:00
Pipeline | Location | [NAME] | Base | Swing | Total | WIO | Grand Total | Comments
[NAME] | [NAME] | Gulf Plains Plant | 8718 | 459 |  | 0
 | [NAME] | Gulf Plains Plant | 3132 | 165 |  | 0
Carthage | American Central | Tailgate | 64255 | 7139 |  |  |  | 3500 makeup is taken out
 | [NAME] | Tailgate | 0 | 500 |  | 0
 | Ruby-Lacy | Tailgate | 0 | 250 |  | 0
 | [NAME] (Net of PVR)* | Tailgate | 9600 |  |  |  |  | Gathering nomination on [NAME] gathering system as Pennzoil's agent
Corpus Christi Gas Gath. | Virginia | 3358 | 1009 | 88 |  | 0
Delhi (Koch Midstream) | Volpe | LL-1-0027 | 1179 | 102 |  | 0
 | [NAME] | LL-1-0027 | 41 | 4 |  | 7
 | Comitas C.P. | LL-1-0030 | 631 | 55 |  | 315
 |  |  |  |  |  |  |  | Termed up with Delhi (evergreen)
Gulf Energy | [NAME] | 19-1043-00 | 439 | 33 |  | 0 |  | Termed up with Gulf Energy (evergreen)
 | Comitas South | 440-559 | 857 | 74 |  | 446
 | Tejas Plant | 29320 | 106 | 9 |  | 4
 | Jennings 63 Plant | 440-565 | 6642 | 578 |  | 0 |  | Termed up with Tejas thru 12/00
 | Haynes Plant | 440-557 | 180 | 16 |  | 30 |  | MTM - Terminate for 4/99
 | Haynes 17, 18 | 23-603-01 | 1592 | 138 |  | 283
 | [NAME] | 31-504-04 | 4478 | 389 |  | 361
 | Garza Plant | 440-552 |  |  |  | 0 |  | Trevino Plant gas is sometimes re-routed through Garza Plant
 | [NAME] | 21-022-08 | 0 | 71 |  | 0
Lone Star | Sandtrap | 178477 | 3805 | 423 |  | 702 |  | Termed up with TXU Energy thru 11/00
Midcon Texas | [NAME] / TOC | 5553 | 353 | 27 |  | 0
 | Hall Plant | 5576 | 703 | 61 |  | 0
 | Jennings Ranch | 446 | 1229 | 107 |  | 0
 | [NAME] at Carthage |  | 0.2192
 |  | Gross | PVR | Net
 | [NAME] | 13402
 | [NAME] | 1858
 |  |  |  |  | Deal #
 | Base |  |  |  | 139257
 | WIO
 | Swing |  |  |  | 143567
Since the WIO vols changed midmonth, instead of changing each one to reflect the net vol I only changed the following:
Am Central
144917 | From 554 to 454
142583 | From 119 to 98
[NAME]
142580 | From 1713 to 1306
Spreadsheet: 0c615d2f-0a88-40f4-9555-0a9516ef1db4
Sheet: Sheet1

SUMMARY OF SIGNIFICANT CHANGES TO THE CDS FOR 2008-09 | Unnamed: 1
The items listed below are shaded in yellow throughout the spreadsheet's worksheets.
CHANGED ITEMS
C8C: Add a column so SAT essay and ACT essay gathered separately:
Indicate how your institution will use the SAT essay or ACT essay component: check all that apply.
 | SAT Essay       ACT Essay
 | For admission
 | For placement
 | For advising
 | In place of an application essay
 | As a validity check on the application essay
 | No college policy as of now
 | Not using essay component
F1: Percentage of first-time, first-year (freshman) degree-seeking students and degree-seeking undergraduates enrolled in Fall 2008 who fit the following categories.
F4: Add two housing check-offs: Wellness housing and theme housing.
CDS H15.  If your institution has recently implemented any major financial aid policy, program, or initiative to make your institution more affordable to incoming students such as replacing loans with grants, or waiving costs for families below a certain income level please provide details below
PERMANENTLY DELETED OR TEMPORARILY DISCONTINUED ITEMS
C20 | Common Application Question – removed.
E4-E8 | The "Library Collections" section has been removed until a new Academic Libraries Survey is in the field.
Spreadsheet: 200272d1355482466-adding-1-darts-2013new
Sheet: jan_a

Jan 8 | LEGS | Home/Casa |  | Away/Afuera | LEGS | mixed Double |  |  |  | Bar 2 B
 |  |  |  |  |  |  |  |  |  | Queimada
 |  | Queimada | V | BYE |  |  |  |  |  | Anchor
 |  | Delfin | V | Anchor |  |  |  |  |  | Scandals
 |  | Bar 2 B | V | Village |  |  |  |  |  | Aloha A
 |  | Aloha B | V | Scandals |  |  |  |  |  | Aloha B
 |  | Casino | V | Aloha A |  |  |  |  |  | Casino
Jan 15 | LEGS | Home/Casa |  | Away/Afuera | LEGS | mixed Double |  |  |  | BYE
 |  |  |  |  |  |  |  |  |  | Village
 |  | Casino | V | BYE |  |  |  |  |  | Delfin
 |  | Village | V | Anchor
 |  | Aloha A | V | Aloha B
 |  | Delfin | V | Bar 2 B
 |  | Scandals | V | Queimada
Jan 22 | LEGS | Home/Casa |  | Away/Afuera | LEGS | mixed Double
 |  | Bar 2 B | V | BYE
 |  | Aloha B | V | Village
 |  | Casino | V | Delfin
 |  | Anchor | V | Scandals
 |  | Queimada | V | Aloha A
Jan 29 | LEGS | Home/Casa |  | Away/Afuera | LEGS | mixed Double
 |  | Anchor | V | BYE
 |  | Village | V | Queimada
 |  | Delfin | V | Aloha A
 |  | Aloha B | V | Casino
 |  | Bar 2 B | V | Scandals
Spreadsheet: 31157d1226960463-allocating-ot-hours-solved-ot-example
Sheet: Sheet1

Raw Data
Employee | Campaign | Week | Hours |  | Step 1: Sum of OT Hours by Week
Employee1 | Campaign1 | Week1 | 10 |  | Sum of OT_Hours
Employee1 | Campaign2 | Week1 | 15 |  | Employee | Week | Total
Employee1 | Campaign3 | Week1 | 16 |  | Employee1 | Week1 | 1
Employee1 | Campaign1 | Week2 | 22.5 |  |  | Week2 | 5.5
Employee1 | Campaign2 | Week2 | 23 |  | Employee2 | Week1 | 1
Employee2 | Campaign1 | Week1 | 18.5 |  |  | Week2 | 2
Employee2 | Campaign2 | Week1 | 22.5
Employee2 | Campaign1 | Week2 | 18
Employee2 | Campaign2 | Week2 | 20
Employee2 | Campaign3 | Week2 | 4
Step 2: Allocate OT Hours
Sum of Hours
Employee | Week | Campaign | Total | %Camp by Wk | Alloc OT Hours
Employee1 | Week1 | Campaign1 | 10 | 0.2439024390243902 | 0.24
 |  | Campaign2 | 15 | 0.3658536585365854 | 0.37
 |  | Campaign3 | 16 | 0.3902439024390244 | 0.39
 | Week1 Total |  | 41
 | Week2 | Campaign1 | 22.5 | 0.4945054945054945 | 2.72
 |  | Campaign2 | 23 | 0.5054945054945055 | 2.78
 | Week2 Total |  | 45.5
Employee2 | Week1 | Campaign1 | 18.5
 |  | Campaign2 | 22.5
 | Week1 Total |  | 41
 | Week2 | Campaign1 | 18
 |  | Campaign2 | 20
 |  | Campaign3 | 4
 | Week2 Total |  | 42
Grand Total |  |  | 169.5
Spreadsheet: 27380d1220550715-copy-and-paste-problem-book2
Sheet: Sheet1

10 | qqqqqqqqqq | pppppppppp11 | ent | Memory | D3-1066 512MB/64x8 CL7 | NA | N | 0.08
15 | [NAME] | ooooooooo55 | ent | Memory | D3-1066 1GB/64x8 | 4 | Y | 0.08
18 | aaaaaaaaaa | iiiiiiiiii66 | ent | Memory | D3-1066 1GB/128x8 | 4 | Y | 0.1
20 | zzzzzzzzzzzz | uuuuuuuu33 | ent | Memory | D3-1066 1GB/128x8 | 4 | Y | 0.1
28 | ccccccccccc | ttttttttttt777 | ent | Memory | D3-1066 2GB/128x8 | 9 | Y | 0.1
30 | rrrrrrrrrrr | rrrrrrrrr4 | ent | Memory | D3-1066 2GB/128x8 | NA | N | 0.13
80 | ttttttttttttttt | [NAME] | ent | Memory | D3-1333 512MB/64x8 CL9 | 3 | Y | 0.08
82 | uuuuuuuuuuu | sssssssssS22 | ent | Memory | 3-1333 1GB/128x8 CL9 | 4 | Y | 0.1
85 | ggggggggggg | vvvvvvvv444 | ent | Memory | D3-1333 1GB/128x8 CL9 | 4 | Y | 0.08
88 | nnnnnnnnn | bbbbbbbb55 | ent | Memory | D3-1333 1GB/64Mx8 CL9 | 4 | Y | 0.08
90 | mmmmmmmm | kkkkkkkkkkkk6 | ent | Memory | 2GB/128x8 | 8 | Y | 0.1
92 | bbbbbbbbbbb | fffffffffffffff66 | ent | Memory | D3-1333 2GB/128Mx | NA | N | 0.1
95 | vvvvvvvvvvvv | hhhhhhhhhhhhhhhh66 | ent | Memory | D3-1333 2GB/128x8 | 9 | Y | 0.1
200 | ppppppppppp |  | LEN |  | UPER RIGID (HEAT SINK) | NA | N | 0
212 | oooooooooooooooo | [NAME] | ent | Memory | D3-1066 1GB/128x | NA | N | 0.13
223 | yyyyyyyyyyyy | oooooo8888888 | ent | Memory | D3-1066 1GB/64x8 | NA | N | 0.13
Spreadsheet: 625250d1558422386-help-calendar-correction-employee-absence-schedule-current-v2
Sheet: Summary

 | Vacation Days Available
 | Employee Name | January | February | March | April | May | June | July | August | September | October | November | December | Year Total
 | [NAME]
 | Lynda
 | [NAME]
 | Heather
 | [NAME]
 | Emili
 | Amber
 | Meredith
 | Julie
 | Total Vacation  Days Taken
 | Employee Name | January | February | March | April | May | June | July | August | September | October | November | December
 | [NAME]
 | Lynda
 | [NAME]
 | Heather
 | [NAME]
 | Emili
 | Amber
 | Meredith
 | Julie
 | Total Days Picked up
 | Employee Name | January | February | March | April | May | June | July | August | September | October | November | December
 | [NAME]
 | Lynda
 | [NAME]
 | Heather
 | [NAME]
 | Emili
 | Amber
 | Meredith
 | Julie
 | Total Sick Days
 | Employee Name | January | February | March | April | May | June | July | August | September | October | November | December
 | [NAME]
 | Lynda
 | [NAME]
 | Heather
 | [NAME]
 | Emili
 | Amber
 | Meredith
 | Julie
Spreadsheet: d58d4bdc-05de-4389-be6e-921eb3ed0e59
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
BLW | Test | BLW | Walnut-Food, IgE | Walnut-Food, 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
BLW | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
BLW | Result | BLW | Walnut-Food, IgE | Walnut-Food, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6273-7
Spreadsheet: 707568d1607350623-finding-the-added-and-deleted-codes-out-of-the-two-sets-of-codes-entered-added-code-deleted-code-sample
Sheet: Sheet1

CodeA | CodeB | DeletedCode | AddedCode
99396,81002,96127,99213 | 99396,81002,96127 | 99213
99443 | 99214 | 99443 | 99214
99214,93306 | 99214 | 93306
99214,93000,99214,93000 | 99214,93000 | 99214,93000
99214,36415,J1940,96372,80053 | 99214,36415,96372,80053 | [NAME]
I700,I77811 | I700,I77811,I110,I5042 |  | I110,I5042
N049,Q210,Q211,I4519 | N049,Q210,Q211,I4510 | I4519 | I4510
I493,I491,E785,F329 | I10,E785,F329,M810 | I493,I491 | I10,M810
Z01419,E663,Z6836,G43909 | Z01419,E663 | Z6836,G43909
I2510,I358,E785,I10 | I2510,E785,I10,E1151 | I358 | E1151
Spreadsheet: 117125d1312467004-selective-columns-farthingstone-updated-old-format-
Sheet: lc

Leech. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 718297d1613074425-sum-three-columns-with-one-criteria-book20
Sheet: book2

Place | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
F100063 |  |  |  |  |  |  | 0 | 55 | 6985
F100064 |  |  |  |  |  |  | 0 | 0 | 0
F100065 |  |  |  |  |  |  | 0 | 0 | 0
F100066 |  |  |  |  |  |  | 0 | 0 | 0
F100067 |  |  |  |  |  |  | 0 | 0 | 0
F100068 |  |  |  |  |  |  | 0 | 0 | 0
F100069 |  |  |  |  |  |  | 0 | 0 | 0
F100070 |  |  |  |  |  |  | 0 | 0 | 0
F100071 |  |  |  |  |  |  | 55 | 0 | 66
F100072 |  |  |  |  |  |  | 0 | 0 | 0
F100073 |  |  |  |  |  |  | 0 | 0 | 0
F100074 |  |  |  |  |  |  | 0 | 0 | 0
F100075 |  |  |  |  |  |  | 0 | 0 | 0
F100076 |  |  |  |  |  |  | 0 | 0 | 0
F100077 |  |  |  |  |  |  | 0 | 77 | 0
F100078 |  |  |  |  |  |  | 0 | 0 | 0
[NAME] |  |  |  |  |  |  | 0 | 0 | 0
[NAME] |  |  |  |  |  |  | 5 | 0 | 11157
F100081 |  |  |  |  |  |  | 0 | 0 | 0
F100082 |  |  |  |  |  |  | 0 | 0 | 0
F100083 |  |  |  |  |  |  | 0 | 0 | 0
Spreadsheet: 766773d1644050862-i-have-a-formula-that-when-broken-down-shows-correct-value-but-shows-error-formula-issue
Sheet: A

 | Date | Name | Details | Income | Director's Loan Accounts |  | Bank Fess |  |  | customer services | Tools | Consumables | repairs | Registration | Total | Bank Balance
 |  |  |  |  | A | G | Acc Fee | Debit fee | Int fees
 | 2021-07-01 00:00:00 | Opening Bank Balance |  |  |  |  |  |  |  |  |  |  |  |  | 8.5
 | 2021-10-14 00:00:00 |  |  |  |  | 30
 | 2021-10-19 00:00:00 |  |  |  |  | -22
 | 2021-10-24 00:00:00 |  |  |  |  | 500
 | 2021-10-24 00:00:00 |  |  |  |  | -6.98
 | 2021-10-26 00:00:00 |  |  |  |  | -28.4
 | 2021-10-26 00:00:00 |  |  |  |  | -27.86
 | 2021-10-26 00:00:00 |  |  |  |  | -54
 | 2021-10-26 00:00:00 |  |  |  |  | -16.24
 | 2021-10-27 00:00:00 |  |  |  |  | -19
 | 2021-10-27 00:00:00 |  |  |  |  | -10
 | 2021-10-27 00:00:00 |  |  |  |  | -16.5
 | 2021-10-27 00:00:00 |  |  |  |  | -5.7
 | 2021-10-27 00:00:00 |  |  |  |  | -12
 | 2021-10-27 00:00:00 |  |  |  |  | 300
 | 2021-10-28 00:00:00 |  |  |  |  | -5
 | 2021-10-29 00:00:00 |  |  |  |  | -43
 | 2021-10-29 00:00:00 |  |  |  |  | -11.14
 | 2021-10-29 00:00:00 |  |  |  |  | -36
 | 2021-10-29 00:00:00 |  |  |  |  | -8
 | 2021-10-30 00:00:00 |  |  |  |  | -18
 | 2021-10-30 00:00:00 |  |  |  |  | -16
 | 2021-10-30 00:00:00 |  |  |  |  | -16
 | 2021-10-30 00:00:00 |  |  |  |  | -33
 | 2021-10-30 00:00:00 |  |  |  |  | -9.5
 | 2021-10-30 00:00:00 |  |  |  |  | -16
 | 2021-10-30 00:00:00 |  |  |  |  | -16
 | 2021-10-30 00:00:00 |  |  |  |  | -16
 | 2021-10-30 00:00:00 |  |  |  |  | -8.99
 | 2021-10-30 00:00:00 |  |  |  |  | -100
 | 2021-10-31 00:00:00 |  |  |  |  | -200
 | 2021-11-02 00:00:00 |  |  |  |  | -26.9
 | 2021-11-02 00:00:00 |  |  |  |  | -23.4
 | 2021-11-10 00:00:00 |  |  |  | 200
 | 2021-11-11 00:00:00 |  |  |  |  | -100
 | 2021-11-12 00:00:00 |  |  |  |  | 100
 | 2021-11-16 00:00:00 |  |  |  | -200
 | 2021-12-14 00:00:00 |  |  |  |  | 35
 | 2021-12-17 00:00:00 |  |  |  |  | -30.5
 | 2021-12-28 00:00:00 |  |  |  | 90
 | 2021-12-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 100
 | 2021-12-30 00:00:00 |  |  |  | 100
 | 2021-12-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 100
 | 2022-01-13 00:00:00 |  |  |  | 100
 | 2022-01-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 100
 | 2022-01-27 00:00:00 |  |  |  | 100
 | 2022-01-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 100
 | Totals
 |  |  |  |  | ROUND(P4+E28+F28+G28-SUM(H28:N28),2)