tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__18203__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-03-06 00:00:00 |  | 309.17 | 20320 | 175.44 | 6728
 | 2001-03-05 00:00:00 |  | 276.65 | 9792 | 162.76 | 4656 | 215.88 | 4042 | 160.99 | 832
 | 2001-03-04 00:00:00 |  | 240 | 800 | 165 | 0 | 168.1 | 2613 | 141.45 | 365 |  | 163.88 | 14568
 | 2001-03-03 00:00:00 |  | 239.87 | 18240 | 148.58 | 7800 | 188.15 | 5032 | 117.4 | 2417
 | 2001-03-02 00:00:00 |  | 242.68 | 15680 | 149.84 | 6728 | 220.44 | 3332 | 159.56 | 867
 | 2001-03-01 00:00:00 |  | 254.01 | 12752 | 142.32 | 4776 | 234.93 | 3755 | 151.21 | 1609
 | 2001-02-28 00:00:00 |  | 178.77 | 16400 | 103.09 | 5920 | 271.72 | 2187 | 185.29 | 705
 | 2001-02-27 00:00:00 |  | 182.08 | 17920 | 98.83 | 5248 | 173.98 | 1198 | 145.57 | 1235
 | 2001-02-26 00:00:00 |  | 197.33 | 10400 | 128.16 | 4152 | 207.88 | 3693 | 115.94 | 1181
 | 2001-02-25 00:00:00 |  | 150 | 0 | 125 | 0 | 146.95 | 3690 | 109.13 | 1615 |  | 128.16 | 12456
 | 2001-02-24 00:00:00 |  | 183.8 | 14608 | 102.52 | 6472 | 184.67 | 3635 | 150.17 | 855
 | 2001-02-23 00:00:00 |  | 183.8 | 14608 | 102.52 | 6472 | 238.26 | 4340 | 143.66 | 910
 | 2001-02-22 00:00:00 |  | 216.97 | 18320 | 115.4 | 7080 | 206.96 | 2653 | 104.69 | 565
 | 2001-02-21 00:00:00 |  | 218.21 | 20720 | 137.88 | 10600 | 175.48 | 1613 | 94.66 | 1119
 | 2001-02-20 00:00:00 |  | 257.07 | 16960 | 162.15 | 8000 | 139.51 | 4942 | 140.75 | 1333
 | 2001-02-19 00:00:00 |  | 256.44 | 17088 | 163.04 | 8192 | 241.52 | 6020 | 167.98 | 773
 | 2001-02-18 00:00:00 |  | 345 | 400 | 242.5 | 0 | 168.63 | 565 | 156.11 | 1125 |  | 248.98 | 14640
 | 2001-02-17 00:00:00 |  | 317.77 | 5920 | 248.95 | 4888 | 281.44 | 2185 | 224.69 | 964
 | 2001-02-16 00:00:00 |  | 407.5 | 9600 | 255.33 | 3000 | 380.8 | 7853 | 212.12 | 765
 | 2001-02-15 00:00:00 |  | 407.5 | 9600 | 255.33 | 3000 | 429.36 | 8631 | 185.81 | 1490
 | 2001-02-14 00:00:00 |  | 260.6 | 15392 | 165.16 | 6200 | 368.89 | 6205 | 216.82 | 1085
 | 2001-02-13 00:00:00 |  | 204.61 | 28464 | 127.5 | 7152 | 213.1 | 4017 | 117.86 | 910
 | 2001-02-12 00:00:00 |  | 194.93 | 17552 | 141 | 4752 | 165.13 | 3805 | 115.9 | 481
 | 2001-02-11 00:00:00 |  | 153.75 | 112 | 150 | 56 | 134.71 | 1414 | 82.08 | 149 |  | 141.16 | 14856
 | 2001-02-10 00:00:00 |  | 150.49 | 27080 | 104.14 | 5240 | 140.81 | 430 | 173.37 | 178
 | 2001-02-09 00:00:00 |  | 150.65 | 32480 | 104.14 | 5240 | 171.89 | 2860 | 131.06 | 362
 | 2001-02-08 00:00:00 |  | 182.53 | 10624 | 115.29 | 7280 | 188.98 | 1327 | 99.67 | 694
 | 2001-02-07 00:00:00 |  | 165.65 | 16640 | 113.79 | 6040 | 170.48 | 1096 | 90.98 | 1046
 | 2001-02-06 00:00:00 |  | 156.9 | 18000 | 117.37 | 6400 | 125.6 | 1999 | 88.75 | 1161
 | 2001-02-05 00:00:00 |  | 151.48 | 12400 | 128.84 | 4400 | 113.86 | 1196 | 83.59 | 982
 | 2001-02-04 00:00:00 |  | 145 | 0 | 120 | 0 | 99.69 | 4662 | 101.68 | 220 |  | 128.84 | 13200
Spreadsheet: 722243d1615133442-modify-my-formula-to-to-check-the-values-and-enter-the-result-and-if-no-values-enter-a-m-missing-and-sum-gk-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | M | 2024-04-04 00:00:00 |  |  |  |  |  |  | P | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | if no value in the box get "M"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | we allocate a point system in order todetermine the strength of the box
 |  |  |  | 4 | 4 | 4 | 4 |  |  | 4 | 4 | 4 | 9 | 9 | 9 | 9 |  | 9 | 9 | 9 | 9 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | Date of Birth |  |  |  |  |  |  |  |  |  | box
 |  |  |  |  | 4 |  |  |  |  |  |  | 3 |  |  |  |  |  |  | P | L | K
 |  |  |  |  | 9 |  |  |  |  |  |  | M
 |  |  |  |  | 2 |  |  |  |  |  |  | 1
Spreadsheet: 844777d1696456728-array-cell-chunk-match-samplebook
Sheet: Sheet1

Preliminary Allocation Rule | Rounded Percentage | "Matched" Consolidated Rule |  | Preliminary Allocation Rule | Rounded Percentage | "Matched" Consolidated Rule |  | EXPECTED OUTPUT
1 | 0.0912 | 1 |  |  | 0.0912 |  |  | 1
1 | 0.1441 | 1 |  | 1 | 0.1441 |  |  | 1
1 | 0.6834 | 1 |  | 1 | 0.6834 |  |  | 1
1 | 0.0002 | 1 |  | 1 | 0.0002 |  |  | 1
1 | 0.0811 | 1 |  | 1 | 0.0811 |  |  | 1
2 | 0.0912 | 1 |  | 2 | 0.0912 |  |  | 1
2 | 0.1441 | 1 |  | 2 | 0.1441 |  |  | 1
2 | 0.6834 | 1 |  | 2 | 0.6834 |  |  | 1
2 | 0.0002 | 1 |  | 2 | 0.0002 |  |  | 1
2 | 0.0811 | 1 |  | 2 | 0.0811 |  |  | 1
3 | 0.0912 | 3 |  | 3 | 0.0912 |  |  | 3
3 | 0.1441 | 3 |  | 3 | 0.1441 |  |  | 3
3 | 0.6834 | 3 |  | 3 | 0.6834 |  |  | 3
3 | 0.0003 | 3 |  | 3 | 0.0003 |  |  | 3
3 | 0.081 | 3 |  | 3 | 0.081 |  |  | 3
4 | 0.5294 | 4 |  | 4 | 0.5294 |  |  | 4
4 | 0.4706 | 4 |  | 4 | 0.4706 |  |  | 4
5 | 0.0912 | 5 |  | 5 | 0.0912 |  |  | 5
5 | 0.1442 | 5 |  | 5 | 0.1442 |  |  | 5
5 | 0.6835 | 5 |  | 5 | 0.6835 |  |  | 5
5 | 0.0811 | 5 |  | 5 | 0.0811 |  |  | 5
6 | 0.5294 | 4 |  | 6 | 0.5294 |  |  | 4
6 | 0.4706 | 4 |  | 6 | 0.4706 |  |  | 4
7 | 0.5294 | 4 |  | 7 | 0.5294 |  |  | 4
7 | 0.4706 | 4 |  | 7 | 0.4706 |  |  | 4
8 | 0.5288 | 8 |  | 8 | 0.5288 |  |  | 8
8 | 0.0012 | 8 |  | 8 | 0.0012 |  |  | 8
8 | 0.47 | 8 |  | 8 | 0.47 |  |  | 8
9 | 0.5288 | 8 |  | 9 | 0.5288 |  |  | 8
9 | 0.0012 | 8 |  | 9 | 0.0012 |  |  | 8
9 | 0.47 | 8 |  | 9 | 0.47 |  |  | 8
10 | 0.5294 | 4 |  | 10 | 0.5294 |  |  | 4
10 | 0.4706 | 4 |  | 10 | 0.4706 |  |  | 4
11 | 0.5294 | 11 |  | 11 | 0.5294 |  |  | 11
11 | 0.4705 | 11 |  | 11 | 0.4705 |  |  | 11
11 | 0.0001 | 11 |  | 11 | 0.0001 |  |  | 11
Spreadsheet: 206490d1358199011-build-a-dynamic-named-range-from-criteria-dynamic-range-criteria-indiana-oeldere-
Sheet: Sheet1

Name | Manager | Role |  |  | Temp | Contract | Perm
a | [NAME] | Temp |  |  | In these columns, I need a list of Managers that will dynamicly update from the "raw" data, which in this case are columns a, b, and c.
b | [NAME] | Contract
c | [NAME] | Perm
d | [NAME] | Temp
e | [NAME] | Contract
f | Michelle | Perm
g | [NAME] | Temp |  |  | Aantal van Role | Kolomlabels
h | [NAME] | Temp |  |  | Rijlabels | Contract | Perm | Temp | Eindtotaal
i | [NAME] | Contract |  |  | [NAME] | 8 |  |  | 8
j | [NAME] | Perm |  |  | b | 2 |  |  | 2
k | [NAME] | Temp |  |  | i | 2 |  |  | 2
l | [NAME] | Contract |  |  | p | 2 |  |  | 2
m | Michelle | Perm |  |  | w | 2 |  |  | 2
n | [NAME] | Temp |  |  | [NAME] |  |  | 6 | 6
o | [NAME] | Temp |  |  | g |  |  | 2 | 2
p | [NAME] | Contract |  |  | n |  |  | 2 | 2
q | [NAME] | Perm |  |  | u |  |  | 2 | 2
r | [NAME] | Temp |  |  | [NAME] |  |  | 8 | 8
s | [NAME] | Contract |  |  | d |  |  | 2 | 2
t | Michelle | Perm |  |  | k |  |  | 2 | 2
u | [NAME] | Temp |  |  | r |  |  | 2 | 2
v | [NAME] | Temp |  |  | y |  |  | 2 | 2
w | [NAME] | Contract |  |  | [NAME] |  |  | 8 | 8
x | [NAME] | Perm |  |  | a |  |  | 2 | 2
y | [NAME] | Temp |  |  | h |  |  | 2 | 2
z | [NAME] | Contract |  |  | o |  |  | 2 | 2
a | [NAME] | Temp |  |  | v |  |  | 2 | 2
b | [NAME] | Contract |  |  | [NAME] | 8 |  |  | 8
c | [NAME] | Perm |  |  | e | 2 |  |  | 2
d | [NAME] | Temp |  |  | l | 2 |  |  | 2
e | [NAME] | Contract |  |  | s | 2 |  |  | 2
f | Michelle | Perm |  |  | z | 2 |  |  | 2
g | [NAME] | Temp |  |  | Michelle |  | 6 |  | 6
h | [NAME] | Temp |  |  | f |  | 2 |  | 2
i | [NAME] | Contract |  |  | m |  | 2 |  | 2
j | [NAME] | Perm |  |  | t |  | 2 |  | 2
k | [NAME] | Temp |  |  | [NAME] |  | 8 |  | 8
l | [NAME] | Contract |  |  | c |  | 2 |  | 2
m | Michelle | Perm |  |  | j |  | 2 |  | 2
n | [NAME] | Temp |  |  | q |  | 2 |  | 2
o | [NAME] | Temp |  |  | x |  | 2 |  | 2
p | [NAME] | Contract |  |  | Eindtotaal | 16 | 14 | 22 | 52
q | [NAME] | Perm
r | [NAME] | Temp
s | [NAME] | Contract
t | Michelle | Perm
u | [NAME] | Temp
v | [NAME] | Temp
w | [NAME] | Contract
x | [NAME] | Perm
y | [NAME] | Temp
z | [NAME] | Contract
Spreadsheet: 854472d1704336808-xirr-xnpv-discounting-xirr-xnpv-example
Sheet: Sheet1

 | Beginning Date |  | 2024-01-01 00:00:00
 | Ending Date
 | Year |  | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5
 | CASE I
 | Investment
 | CashFlows |  |  |  |  |  |  |  |  | 0 | 35 | 36 | 35 | 37 | 40 | 42 | 45 | 50 | 53 | 55 | 57 | 58
 | TOTAL
 | Req IRR | 0.06
 | Buyer IRR at Year 2
 | CASE II
 | Investment
 | CashFlows |  |  |  |  |  |  |  |  | 0 | 35 | 36 | 35 | 37 | 40 | 42 | 45 | 50 | 53 | 55 | 57 | 58
 | TOTAL
 | Req IRR | 0.06
 | Buyer IRR at Year 2
 | Assume a Buyer wants to acquire an asset that has the above QUARTERLY cashflows from year 3 onward. He is looking to get an annual 6% IRR. As mentioned before, he will receive quarterly cashflows. In order to calculate how much he should pay for those cashflows, I have used the xnpv value on col K. In Case I, I have discounted the 6% to arrive at a periodic quarterly discount rate (1+DR)^0.25-1. For Case II, I have left the disount rate at 6%. Obviously, the investment that he has to make differs in the two cases ($529 vs. $490). It seems to me that Case I correctly uses the XNPV by discounting the 6% to quarterly, but that requires that I annualize the XIRR result on cell C13 to arrive at the required annual 6%. Is that correct? Or is Case II the correct method to arrive at the investment i.e., without using a periodic rate when discounting ?
Spreadsheet: 765151d1643197182-formula-to-pick-out-a-bill-no-test
Sheet: Sheet1

Ref | [NAME] #
t1234567/1 | 1 |  | <- Longer than 8 digits and has /1 so put 1
W1642175 | 1 |  | <- Not longer than 8 digits so just put 1
HV63676 401 | 1 |  | <- Longe than 8 digits but space in wrong spot so just put 1
M2117967 | 1 |  | <- Not longer than 8 digits so just put 1
E2620942 | 1 |  | <- Not longer than 8 digits so just put 1
M2112559 | 1 |  | <- Not longer than 8 digits so just put 1
HV638565/1 | 1 |  | <- Longer than 8 digits and has /1 so put 1
[NAME] | 1 |  | <- Not longer than 8 digits so just put 1
T1839034/2 | 2 |  | <- Longer than 8 digits and has /2 so put 2
T1851003/3 | 3 |  | <- Longer than 8 digits and has /3 so put 3
Mw182936 | 1 |  | <- Not longer than 8 digits so just put 1
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Jan13-Jan19m

Main Arena
 | 2013-01-13 00:00:00 |  |  | Thru | 2013-01-19 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2013-01-13 00:00:00 | 2013-01-14 00:00:00 | 2013-01-15 00:00:00 | 2013-01-16 00:00:00 | 2013-01-17 00:00:00 | 2013-01-18 00:00:00 | 2013-01-19 00:00:00 |  |  |  | Blocks | Team | Hours
7:00AM | Silver Sticks |  |  |  |  |  |  | 7:00AM |  |  | 0 | 05 [NAME] | 0
 | Silver Sticks |  |  |  |  |  |  |  |  |  | 0 | 04 Flags | 0
[NAME] | Silver Sticks |  |  |  |  |  |  | [NAME] |  |  | 0 | 03 [NAME] | 0
 | Silver Sticks |  |  |  |  |  |  |  |  |  | 0 | 02 Flags | 0
[NAME] | Silver Sticks |  |  |  |  |  |  | [NAME] |  |  | 0 | 01 Flags | 0
 | Silver Sticks |  |  |  |  |  |  |  |  |  | 0 | 00 Flags | 0
10:00AM | Silver Sticks |  |  |  |  |  |  | 10:00AM |  |  | 0 | 99 Flags | 0
 | Silver Sticks |  |  |  |  |  |  |  |  |  | 0 | 98 Flags | 0
11:00AM | Silver Sticks |  |  |  |  |  |  | 11:00AM |  |  | 0 | Midget A | 0
 | Silver Sticks |  |  |  |  |  |  |  |  |  | 0 | Midget AA | 0
12:00PM | Silver Sticks |  |  |  |  |  |  | 12:00PM
 | Silver Sticks
1:00PM | Silver Sticks |  |  |  |  |  |  | 1:00PM
 | Silver Sticks
2:00PM | Silver Sticks |  |  |  |  |  |  | 2:00PM
 | Silver Sticks
3:00PM | Silver Sticks |  |  |  |  |  |  | 3:00PM
 | Silver Sticks
4:00PM | Silver Sticks |  |  |  |  |  |  | 4:00PM
 | Silver Sticks
5:00PM | Silver Sticks |  |  |  |  |  |  | 5:00PM
 | Silver Sticks
6:00PM | Silver Sticks |  |  |  |  |  |  | 6:00PM
 | Silver Sticks
7:00PM | Silver Sticks |  |  |  |  |  |  | 7:00PM
 | Silver Sticks
8:00PM | Silver Sticks |  |  |  |  |  |  | 8:00PM
 | Silver Sticks
9:00PM | Silver Sticks |  |  |  |  |  |  | 9:00PM
 | Silver Sticks
10:00PM | Silver Sticks |  |  |  |  |  |  | 10:00PM
 | Silver Sticks
11:00PM | Silver Sticks |  |  |  |  |  |  | 11:00PM
 | Silver Sticks
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: 694362d1599567977-copy-names-from-one-sheet-to-other-workbook-sheets-sample-scoring-spreadsheet1
Sheet: PROP 1

ORGANISATION NAME: |  | FIRST ROUND RESULT | Overall minimum threshold score is 60% | IS FURTHER INFORMATION REQUIRED?
NAME OF PROPOSAL:
 | Potential Impact - minimum threshold 42% | SCORE % | NOTES
 | Potential Impact Total
 | Capacities - minimum threshold 12% | SCORE % | NOTES
 | Capacities Total
 | Quality of the application to develop the plan - minimum threshold 6% | SCORE % | NOTES
 | Quality of the application to develop the plan Total
 | Total Score %
 | Overall minimum threshold score of 60%
Spreadsheet: 707607d1607362031-dollar-sign-issue-excel-formula-dollar-sign
Sheet: Sheet1

a | 1 | . | as | 11 | ,,
b | 2 | , | at | 22 | ..
c | 3 | > | au | 33 | ;;
d | 4 | ] | av | 44 | @@
e | 5 | [ | aw | 55 | --
[NAME] for Each Row
A2
$A$2
A$2
$A2
 | Expected Result
 |  | b | c | d | e
Spreadsheet: 793461d1661498876-remove-unwanted-0-from-a-contact-formula-book1
Sheet: Manhole BoQ

 |  |  |  |  |  |  | HYDROBREAKS |  | CHAINS |  | AMPS |  | Access Ladders (Greater than 3m) |  | BACK DROPS
 | Precast concrete manholes Precast concrete straight shaft manholes; excavation, disposal On site, earthwork support, levelling and compacting bottoms,  225 thick RC30 grade in-situ concrete bed, precast concrete chamber rings with proprietary bitumen or resin mastic sealant, 150 thick RC30 grade in situ concrete surround, formwork, benching and channels with high strength concrete  topping minimum 20 thick, heavy duty precast concrete cover slab on class B engineering brick raising courses, 150 high, bedded in cement mortar, galvanised mild steel step irons (unless ladder indicated in desc below) at 300 centres, backfilling with granular material; manhole cover and frame. |  |  |  |  |  | Type | Provide Cost | Type | Provide Cost | Type | Provide Cost | Y/N | From MH Rates | Type | [NAME] to Provide Cost |  | [NAME] from | Depth Range to
on this row the 1.5 needs to be rounded to 1.50 and the 2 also needs rounding to 2.00. Also where there are no [NAME], Chains, Amps, Ladders, Backdrops, the text needs to be blank and not show all the zeros |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.5 | 2
as above for the 1.50. where there ar no ladders or backdrop, it needs to show nothing and not the zeros, So it should only show Hydrobrake; AMPS and then nothing |  |  |  |  |  |  | Hydrobrake |  |  | 0 | AMPS |  |  |  |  |  |  | 1.25 | 1.5
Spreadsheet: 26301474-e1c5-4c4d-bf7b-dd57b42ab72f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 |  | Gross Business Income (GBI) and [NAME] (TRS);
 |  | 2005 to 2007 Growth Compared to Average Growth for the Previous Years
 |  | WA DOR asserts no cause and effect relationship between [NAME] and industry revenues.
 | Rows 1 through 28 on the following two sheets contain the raw, quarterly GBI and TRS data for gambling and the food and beverage industries.
 | Rows 31 through 37 on the following two sheets show calendar year summations for GBI and TRS quarterly data.
 | Rows 41 through 51 show annual changes, and compare the 2006 and 2007 growth rates with the average for the previous four years.
 | The GBI and TRS data show the following:
 |  | Gambling | -after declining in 2006, enjoyed a return to growth in 2007, particularly TRS for other gambling.  GBI and TRS
 |  |  | growth rates were down for non-Indian casinos in the two years after [NAME], but up for other gambling.
 |  | Food service as a whole: | -rapid GBI growth in both 2006 and 2007 (post [NAME]) while TRS had average growth (same as pre I-901 period.)
 |  | Full service restaurants: | -growth rates for 2006 and 2007 (post [NAME]) were the same (GBI) or higher (TRS) as in the pre I-901 period.
 |  | Limited service restaurants: | -GBI growth in 2006 and 2007 (post [NAME]) was much higher, but TRS growth was a little lower than before I-901.
 |  | Caterers, other special food: | -growth rates for GBI and TRS were slower after [NAME] than in the years before the measure's passage.
 |  | Bars and taverns: | -rapid growth of GBI and TRS in 2007 after a mediocre year in 2006.  This 2007 growth resulted in higher
 |  |  | growth rates in the two years after [NAME] than in the years preceding the ballot initiative.
 |  | DOR/Research
 |  | Jun 10, 2008
Spreadsheet: de00bb36-a4dc-42a4-a25c-6068e692f17f
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
9832 | Test | 9832 | Movat's Pentachrome Stain | Movat's Pentachrome ST | Includes acid fuchsin, [NAME], crocein scarlet, [NAME], pathology consultation, and safran. | Formalin-fixed, paraffin-embedded tumor tissue block. Include 1 H & E slide: FFPTHE |  |  |  | Varies | Container/Tube: Sterile container with 10% neutral buffered formalin or embedded in paraffin [NAME]: Entire collection Collection Instructions:  1. Collect a tissue specimen. 2. Include 1 hematoxylin-and-eosin slide. Additional Information: A pathology report and a brief history are required. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | The laboratory will provide a pathology consultation and stained slide. | Monday through Friday; 7 a.m. | 2 days | 7 days | 1 | 88313 |  |  |  |  | Rochester
9832 | [NAME] | TISSUE | Tissue |  |  |  | Ambient
9832 | Result | 9832 | Movat's Pentachrome ST | Movat's Pentachrome ST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10799-5
Spreadsheet: 823221d1679818481-make-a-cell-with-many-lines-into-order-example1
Sheet: Text

Text Operations
[NAME] for working with text
Text (input) | [NAME] |  | Text to the left | Text to the right | Extracted text
[NAME] |  |  | [NAME] | Doe
Length |  |  | [NAME]
Upper case |  |  |  | Doe
Lower case |  |  | [NAME]
Search | [NAME]
Replace | [NAME]
Result
Contains?
First Name
Last Name
Spreadsheet: 0bae6706-f527-4f77-a0b6-3b761d77f0da
Sheet: Notes

 | Notes
 | The "Before Taking Action" column represents an estimate of annual "business-as-usual" greenhouse gas emissions, if the classroom took no action to reduce its carbon footprint.
 | The "After Taking Action" column represents an estimate of what the annual CO2 emissions would be, if the classroom did take action to reduce its carbon footprint.
 | The "Potential savings per year" columns represents estimates of the CO2 emissions, electricity, and costs that this classroom could prevent or save this year, by taking action. Savings are based on the assumption that each classroom will maintain throughout a whole school year the climate-friendly actions they’ve adopted.
 | References
 |  | CALCULATING CO2 EQUIVALENTS
 |  | CAR
 |  | According to the U.S. Environmental Protection Agency, the combustion
 |  | of one gallon of gasoline generates |  |  | 19.4 | lbs of CO2
 |  | http://www.epa.gov/OMS/climate/420f05001.htm
 |  | Average car fuel efficiency: |  |  | 20 | mpg
 |  | http://www.epa.gov/RDEE/energy-resources/refs.html#vehicles
 |  | LIGHTBULB
 |  | Watts per standard incandescent lightbulb: |  |  |  | 100
 |  | Lbs CO2 per kWh (US average) |  |  |  | 1.39
 |  | Watts per kilowatt |  |  |  | 1000
 |  | TREE
 |  | According to the U.S. Environmental Protection Agency, growing one tree
 |  | seedling for 10 years sequesters |  |  |  | pounds of CO2
 |  | http://www.epa.gov/cleanenergy/energy-resources/refs.html#seedlings
Spreadsheet: 845875d1697195873-merge-columns-in-power-query-merge-columns-in-power-query
Sheet: Expected Result

Employee | Emp ID | Work order Number | Work order Description | Week Number | Days | Oct-2023 | Nov-2023 | Dec-2023 | Jan-2024 | Feb-2024 | Mar-2024
Jererome | UKJMA003 | 70009391-222
Jererome | UKJMA003 | 70087403-E20
Jererome | UKJMA003 | 70107938-BPG
Jererome | UKJMA003 | 70108172-211
Jererome | UKJMA003 | 99900014-001
Jererome | UKJMA003 | 70110010-211
Jererome | UKJMA003 | 70046361-2WL
Jererome | UKJMA003 | 70090296-251
Spreadsheet: 1b09c658-948a-4184-a432-a3c62bd9d0a4
Sheet: 14d

 | Swap Dealers/MSPs5 |  |  | Others
Product1 | HY6 | IG | Other | HY | IG | Other
Index Tranche | 6 | 4 | 0 | 2 | 2 | 0
Index | 2176 | 3514 | 4877 | 4178 | 4086 | 4192
OTHER* | 0 | 0 | 37 | 0 | 0 | 27
TOTAL | 2182 | 3518 | 4914 | 4180 | 4088 | 4219
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 30716d1226410721-inserting-rows-into-table-which-copy-the-color-of-up-down-rows-how-to-sampletable
Sheet: Sales Funnel

 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Cabinet
 | Sale # | Phase # | Date entered | Customer | Country | Est.date | Delivery date | Salesperson | Deal type | Revenue quarter | fat | slim | total | Probability | Install | Note
 |  |  |  |  |  |  |  |  |  |  | 5 |  |  | 100 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 80 | 0
 |  |  |  |  |  |  |  |  |  |  | 9 |  |  | 50 | 1
 |  |  |  |  |  |  |  |  |  |  |  | 12 |  | 30 | 0
 |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 50 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 30 | 1
 |  |  |  |  |  |  |  |  |  |  | 9 |  |  | 30 | 1
 |  |  |  |  |  |  |  |  |  |  | 3 |  |  | 30 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 30 | 1
 |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 30 | 1
 |  |  |  |  |  |  |  |  |  |  | 5 |  |  | 30 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 0
Spreadsheet: 874697d1721232856-if-function-to-compare-multiple-tabs-rswlaw67-bills-by-pay-cycle
Sheet: Due Array Solution

Pay Cycle | Amount Due
1
2 | 88.49
3 | 269.33
4 | 88.49
5 | 117.48
6 | 198.43
7 | 119.44
8 | 219.4
9 | 132.43
10 | 214.98
11 | 71.3
12 | 286.52
13 | 71.3
14 | 117.48
Spreadsheet: 858210d1706950510-looking-for-formula-to-create-number-series-creating-number-series_sample-aligw
Sheet: Sheet2

#s
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Spreadsheet: 190003d1351503268-merge-same-records-to-one-row-sample1-with-code_
Sheet: Sheet2

[NAME]
Problem No. | Problem |  | Action Taken | Done by | Done on
121 | Oil Leakage | a | Oil Changed | Ravi | 2012-10-01 00:00:00
121 | Oil Leakage | b | Oil Seal Replaced | Ravi | 2012-10-01 00:00:00
121 | Oil Leakage | c | Repared Part sent to Customer | Suresh | 2012-10-05 00:00:00
122 | abnormal Noise | a | [NAME] | Raj | 2012-10-10 00:00:00
122 | abnormal Noise | b | Repared Part sent to Customer | Srinivasan | 2012-10-13 00:00:00
[NAME]
Problem No. | Problem |  | Action Taken | Done by | Done on
121 | Oil Leakage | a b c | Oil Changed Oil Seal Replaced Repared Part sent to Customer | Ravi  Suresh | 01-Oct-12  05-Oct-12
122 | abnormal Noise | a b | [NAME] Part sent to Customer | Raj Srinivasan | 10-Oct-12 13-Oct-12
Macro Requirement :
a) select the ROWS with same PROBLEM No.
b) [NAME] values in each Column
c) For Each Column,   merge data from the rows in selection and puts each cell value on a new line.
d) Repeat for Next Problem No.
Note :The database is sorted based on Complaint No.
Spreadsheet: 60192d1260745414-multiple-if-statement-problem-putnum
Sheet: CurrentPayCheck

Pay Check | Date | Finger Print | Item Name | Categories | Tags | Tag Amount | Bank Amount | Comments
1301 | 2009-12-25 00:00:00 | 1 | Walmart |  |  |  | -270
 | 2009-12-25 00:00:00 | 1 | WalMart | Food | Food - Adam's Groceries | 90 |  | Bought Chicken
Left Over | 2009-12-25 00:00:00 | 1 | Walmart | Clothing | Clothing - Adam | 90 |  | Bought Underware
 | 2009-12-25 00:00:00 | 1 | WalMart | Auto | Auto - Maintenance - VW | 90 |  | windsheild washer vw
Filter |  | 2 | Sonic | Food | Food - Adam Eating Out | 2.23 | -2.23
1
Budget Check |  | 3 | RaceTrack | Auto | Auto - Gas - VW | 32.12 | -32.12 | Got Gas
Finger Print