tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 884518d1733756173-search-an-array-but-return-only-certain-cells-leetest
Sheet: AWG

 | [NAME] |  |  |  |  |  |  | Drawing Only, Drawing & Budget
 | Opportunity No' | Client Name | [NAME] | Equivs | Order % |  |  | Opportunity No' | Client Name | [NAME] | Equivs
 | OPP1234567 | ABC Lettering Company Ltd | [NAME] | 100 | 1 |  |  | OPP1234567 | ABC Lettering Company Ltd | [NAME] | 100
[NAME]
Spreadsheet: d3f6cc8a-73ca-42f3-b68d-b0932b393882
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
11/13/2009 | Women's Basketball | TOWSON | W, 79-42
11/16/2009 | Women's Basketball | MARIST | W, 55-50
11/19/2009 | Women's Basketball | at Ohio State | L, 69-92
11/24/2009 | Women's Basketball | at Duquesne | W, 73-52
11/27/2009 | Women's Basketball | vs. Iowa (Reno, Nev.) | W, 69-66
11/28/2009 | Women's Basketball | at Nevada | W, 66-41
12/02/2009 | Women's Basketball | RADFORD | W, 64-28
12/05/2009 | Women's Basketball | MAINE | W, 88-32
12/08/2009 | Women's Basketball | EASTERN KENTUCKY | W, 60-40
12/12/2009 | Women's Basketball | LONGWOOD | W, 74-43
12/19/2009 | Women's Basketball | FRESNO STATE | W, 72-52
12/22/2009 | Women's Basketball | UMBC | W, 79-45
12/30/2009 | Women's Basketball | SANTA CLARA | W, 78-55
01/02/2010 | Women's Basketball | at St. John's | W, 54-50
01/05/2010 | Women's Basketball | PITT | W, 63-59
01/09/2010 | Women's Basketball | DEPAUL | W, 64-57 (OT)
[NAME] | Women's Basketball | VILLANOVA | W, 45-41
01/17/2010 | Women's Basketball | at Pitt | W, 69-54
[NAME] | Women's Basketball | vs. [NAME] (Charleston, W.Va.) | W, 74-42
01/24/2010 | Women's Basketball | at Notre Dame | L, 66-74
[NAME] | Women's Basketball | SETON HALL | W, 55-31
01/30/2010 | Women's Basketball | LOUISVILLE | W,72-66
[NAME] | Women's Basketball | at Connecticut | L, 47-80
02/06/2010 | Women's Basketball | at Providence | W, 75-59
02/14/2010 | Women's Basketball | GEORGETOWN | W, 55-46
02/16/2010 | Women's Basketball | RUTGERS | W, 55-51
02/20/2010 | Women's Basketball | at USF | W, 54-45
02/23/2010 | Women's Basketball | at Cincinnati | W, 64-43
02/27/2010 | Women's Basketball | MARQUETTE | W, 69-56
03/01/2010 | Women's Basketball | at Syracuse | L, 48-67
[NAME] | Women's Basketball | vs. [NAME] | W, 47-41
03/08/2010 | Women's Basketball | vs. Rutgers | W, 56-49
03/09/2010 | Women's Basketball | vs. Connecticut | L, 62-30
03/21/2010 | Women's Basketball | vs. [NAME] | W, 58-43
03/23/2010 | Women's Basketball | vs. San Diego State | L, 55-64
Spreadsheet: 42231d1240841010-select-records-and-create-a-new-column-example
Sheet: Sheet1

WTR00305474 | WTR00052589 | WTR00305474 | 0 | 0 | 0
[NAME] | [NAME] | [NAME] | 0 | 0 | 0
WTR00305490 | WTR00029660 | WTR00305490 | 0 | 0 | 0
WTR00305508 | [NAME] | WTR00305508 | 0 | 0 | 0
WTR00305516 | WTR00185587 | #N/A | #N/A | 1 | WTR00305516
[NAME] | WTR00191379 | [NAME] | 0 | 0 | 0
[NAME] | [NAME] | [NAME] | 0 | 0 | 0
WTR00305680 | WTR00284661 | WTR00305680 | 0 | 0 | 0
WTR00305698 | WTR00058388 | WTR00305698 | 0 | 0 | 0
WTR00305714 | WTR00098947 | WTR00305714 | 0 | 0 | 0
[NAME] | [NAME] | #N/A | #N/A | 1 | [NAME]
WTR00305839 | WTR00029710 | #N/A | #N/A | 1 | WTR00305839
WTR00305904 | WTR00115188 | #N/A | #N/A | 1 | WTR00305904
WTR00305912 | WTR00182212 | #N/A | #N/A | 1 | WTR00305912
WTR00305920 | WTR00115527 | #N/A | #N/A | 1 | WTR00305920
WTR00305938 | WTR00058396 | #N/A | #N/A | 1 | WTR00305938
[NAME] | [NAME] | #N/A | #N/A | 1 | [NAME]
WTR00305953 | WTR00168195 | #N/A | #N/A | 1 | WTR00305953
WTR00305961 | WTR00152314 | #N/A | #N/A | 1 | WTR00305961
WTR00305979 | WTR00027441 | #N/A | #N/A | 1 | WTR00305979
WTR00306035 | WTR00238600 | WTR00306035 | 0 | 0 | 0
[NAME] | WTR00000018 | [NAME] | 0 | 0 | 0
WTR00306068 | WTR00016675 | #N/A | #N/A | 1 | WTR00306068
WTR00306142 | [NAME] | #N/A | #N/A | 1 | WTR00306142
WTR00306191 | WTR00175729 | WTR00306191 | 0 | 0 | 0
[NAME] | [NAME] | [NAME] | 0 | 0 | 0
Spreadsheet: 119392d1314365473-solving-index-match-duplicate-returns-simplified
Sheet: Sheet1

volume | part | helper |  | volume to look up>>> | 336 | item 105
106 | item 101 |  |  |  |  | item 118
484 | item 102 |  |  |  |  | item 121
655 | item 103 |  |  |  |  | item 131
426 | item 104
336 | item 105 | 6
534 | item 106
981 | item 107
372 | item 108
450 | item 109
127 | item 110
110 | item 111
539 | item 112
491 | item 113
487 | item 114
66 | item 115
192 | item 116
527 | item 117
336 | item 118 | 19
266 | item 119
130 | item 120
336 | item 121 | 22
532 | item 122
226 | item 123
763 | item 124
823 | item 125
765 | item 126
17 | item 127
288 | item 128
354 | item 129
814 | item 130
336 | item 131 | 32
881 | item 132
82 | item 133
823 | item 134
46 | item 135
237 | item 136
439 | item 137
833 | item 138
535 | item 139
784 | item 140
745 | item 141
572 | item 142
774 | item 143
701 | item 144
620 | item 145
870 | item 146
556 | item 147
990 | item 148
918 | item 149
537 | item 150
390 | item 151
878 | item 152
205 | item 153
29 | item 154
422 | item 155
532 | item 156
355 | item 157
62 | item 158
339 | item 159
1 | item 160
892 | item 161
880 | item 162
512 | item 163
126 | item 164
379 | item 165
329 | item 166
7 | item 167
411 | item 168
994 | item 169
Spreadsheet: 843288d1695184699-a-doosy-complex-logic-for-filtering-can-you-figure-it-out-test-formulas-smaller
Sheet: Report

 | Instruction: | - Select in the filter lists from the available values.
 |  | - To clear a filter cell, click in the cell and press 'Delete' key.
 |  | - You can also search by text via the text boxes.
 |  |  | Filters....
 | Vendor | Instrument Type | Application/Use | [NAME] Type
 | Number of matches: |  | Text Search....
 |  | Keyword search in library name: | Keyword search in library subgroup: | Keyword search in patch name:
 |  | Keyword search - Match any field: | Keywords to omit from results:
 | Results....
 | Vendor | Library | Library Group Name | Patch Name
 | 344 Audio | 344 Audio - Electric Organ |  | Electric Organ_DSN_GRITTY [NAME]
 | 344 Audio | 344 Audio - Electric Organ |  | Electric Organ_DSN_LARGE CATHEDRAL CHURCH ORGAN.nki
 | 344 Audio | 344 Audio - Electric Organ |  | Electric Organ_DSN_METALLIC TECHNO SEQUENCE.nki
 | 8Dio | 8Dio 1928 New Legacy [NAME] | Presets | 8Dio The New 1928 Piano - Down to Earth.nki
 | 8Dio | 8Dio 1928 New Legacy [NAME] | Presets | 8Dio The New 1928 Piano - Exprecussive Staccato MW.nki
 | 8Dio | 8Dio 1928 New Legacy [NAME] | Presets | 8Dio The New 1928 Piano - Glass.nki
 | 8Dio | 8Dio 1928 New Legacy [NAME] | Presets | 8Dio The New 1928 Piano - Leds.nki
 | 8Dio | 8Dio 1928 New Legacy [NAME] | Presets | 8Dio The New 1928 Piano - Organ-Like.nki
 | 8Dio | 8Dio 1985 Passionate [NAME] v1 | Presets | 8Dio 1985 Passionate [NAME] - Delayed Bass CC1.nki
 | 8Dio | 8Dio 1985 Passionate [NAME] v1 | Presets | 8Dio 1985 Passionate Piano - Driven Spots.nki
 | 8Dio | 8Dio 1985 Passionate [NAME] v1 | Presets | 8Dio 1985 Passionate [NAME]
 | 8Dio | 8Dio 1985 Passionate [NAME] v1 | Presets | 8Dio 1985 Passionate [NAME] CC1.nki
 | 8Dio | 8Dio 1985 Passionate [NAME] v1 | Presets | 8Dio 1985 Passionate [NAME] - Late Night Scoring Piano.nki
 | Cinesamples | Kontakt Designer Vol 1 Metallurgy | Odd Events | Spoiled Juwels.nki
 | Cinesamples | Kontakt Designer Vol 1 Metallurgy | Odd Events | Spooky Castle.nki
 | Cinesamples | Kontakt Designer Vol 1 Metallurgy | Odd Events | Submarine.nki
 | Cinesamples | Kontakt Designer Vol 1 Metallurgy | Odd Events | Sucked In.nki
 | Cinesamples | Kontakt Designer Vol 1 Metallurgy | Odd Events | Sweezy.nki
 | Cinesamples | Kontakt Designer Vol 1 Metallurgy | Odd Events | The Dentist.nki
Spreadsheet: f3dd6b73-335a-4aa3-9f00-91c658f6998c
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0014091 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | White Oak Trailer Wash Facility | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Bladen | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 1 |  | Field Name: |  | 2 |  | Field Name: |  | 3 |  | Field Name: |  | 4
 |  |  |  |  |  | Area (acres): |  | 2.22 |  | Area (acres): |  | 3.56 |  | Area (acres): |  | 3.81 |  | Area (acres): |  | 3.94
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.75 |  | [NAME] (in): |  | 0.75 |  | [NAME] (in): |  | 0.75 |  | [NAME] (in): |  | 0.75
 |  |  |  |  |  | Annual Rate (in): |  | 10.79 |  | Annual Rate (in): |  | 10.79 |  | Annual Rate (in): |  | 10.79 |  | Annual Rate (in): |  | 10.79
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 34759d1232082583-extracting-rows-of-data-suggestedforumsolution
Sheet: Green

Name | Stat B | Stat C | Stat D | Stat E | Stat F | Stat G | Stat H | Stat I | Stat J | Stat K | Stat L | Stat M
Green | Stat B Row 2 | Stat C Row 2 | Stat D Row 2 | Stat E Row 2 | Stat F Row 2 | Stat G Row 2 | Stat H Row 2 | Stat I Row 2 | Stat J Row 2 | Stat K Row 2 | Stat L Row 2 | Stat M Row 2
Spreadsheet: 34766d1232105873-sumif-for-2-criteria-in-different-columns-helpme
Sheet: Sheet1

DATE OF EVENT | Type | No
2009-01-07 00:00:00 | one | 2
2009-01-12 00:00:00 | two | 0
2009-01-12 00:00:00 | three | 3
2009-01-15 00:00:00 | one | 4
2009-02-18 00:00:00 | two | 2
2009-04-03 00:00:00 | seven | 1
2009-03-10 00:00:00 | six | 5
2009-01-07 00:00:00 | eight | 3
Spreadsheet: 760b28fc-b67c-4d69-8c78-39db03c93e86
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5602 | 25156 | [NAME] | Bik | USA | 0
5602 | 7984 | [NAME] | [NAME] | USA | 0
5602 | 7986 | [NAME] | Perkins | USA | 0
5602 | 7963 | Etienne | Caprin | FRA | 0
5602 | 7987 | Grant | [NAME] | CAN | 0
5602 | 7971 | Ruben | Grande | MEX | 0
Spreadsheet: 146039d1331868623-index-match-query-to-include-blank-entries-from-source-so-week-number-obvious-at-a-glance-roomrent2012
Sheet: MAR

DATES: | DAY: | BOARD  £: | PAID (Y or N) | REASON FOR UNPAID? | DATE of UNPAID to be PAID? | NOW PAID  (Y or N) | UNPAID totals
1st | THU | 20 | N | UNKNOWN |  |  | 1
2nd | FRI |  |  |  |  |  | 1
3rd | SAT |  |  |  |  |  | 1
4th | SUN |  |  |  |  |  | 1
5th | MON |  |  |  |  |  | 1
6th | TUE |  |  |  |  |  | 1
7th | WED |  |  |  |  |  | 1
8th | THU |  |  |  |  |  | 1
9th | FRI |  |  |  |  |  | 1
10th | SAT |  |  |  |  |  | 1
11th | SUN |  |  |  |  |  | 1
12th | MON | 20 | N | UNKNOWN |  |  | 2
13th | TUE |  |  |  |  |  | 2
14th | WED |  |  |  |  |  | 2
15th | THU |  |  |  |  |  | 2
16th | FRI |  |  |  |  |  | 2
17th | SAT |  |  |  |  |  | 2
18th | SUN |  |  |  |  |  | 2
19th | MON |  |  |  |  |  | 2
20th | TUE |  |  |  |  |  | 2
21st | WED |  |  |  |  |  | 2
22nd | THU |  |  |  |  |  | 2
23rd | FRI |  |  |  |  |  | 2
24th | SAT |  |  |  |  |  | 2
25th | SUN |  |  |  |  |  | 2
26th | MON | 20 |  | Wk finishs start of next month | 2012-04-01 00:00:00 |  | 2
27th | TUE |  |  |  |  |  | 2
28th | WED |  |  |  |  |  | 2
29th | THU |  |  |  |  |  | 2
30th | FRI |  |  |  |  |  | 2
31st | SAT |  |  |  |  |  | 2
TOTAL of PAID |  | 0
TOTAL of UNPAID |  | 40
 |  |  |  | UNKNOWN
Spreadsheet: 202291d1356484385-cell-reset-unit-6-spreadsheet
Sheet: Branch Prouduct Share

 |  |  | [NAME]
 |  |  | Branch Stock Quantities
Product ID | Product Name |  |  |  | Quantity Ordered to Main Office |  | Quantites to Each Branch
 |  |  |  |  |  |  | London | [NAME] | Birmingham | Brighton | [NAME]
1 | [NAME]
2 | IST Pro Ear Mask
3 | ScubaPro T-One BCD
4 | [NAME]
5 | ScubaPro X-Force BCD
6 | Suunto Zoop Dive Computer
7 | ScubaPro T-Black BCD
8 | Mares Nemo Wide
9 | [NAME] BCD
10 | UWATEC Galileo Sol (including [NAME])
11 | [NAME]
12 | Suunto D6i with USB
13 | Oceanic Probe HLC BCD
14 | ScubaPro Mens Everdry 4 Dry Suit
15 | [NAME]
16 | ScubaPro Womens Everdry 4 Dry Suit
17 | [NAME] BCD
18 | Fourth Element Mens Proteus Long Wetsuit
19 | [NAME]
20 | Forth Element Womens Proteus Long Wetsuit
21 | [NAME]
22 | Fourth Element Mens Proteus Short Wetsuit
23 | Hollis SMS 100 Sidemount Harness
24 | Forth Element Womens Proteus Short Wetsuit
25 | [NAME]
26 | ScubaPro 12 Litre 232 Bar Single Valve Cylinder
27 | ScubaPro X-One BCD
28 | ScubaPro 15 Litre 232 Bar Single Valve Cylinder
29 | Cressie S300 BCD
30 | [NAME]
31 | [NAME] BCD
32 | Mares X Stream Fins
33 | Oceanic Hera Ladies BCD
34 | TUSA X-Pert Evolution Full Foot Fins
35 | Oceanic Hera Ladies BCD
36 | [NAME]
37 | Mares Hybrid Pro Tec BCD
38 | Mares Avanti Quattro Plus Fins
39 | [NAME] Lady BCD
40 | Mares Quattro Excel Plus
41 | Mares i3 Mask
42 | [NAME] On Water Fins
43 | Mares X-VU Sunrise Liquidskin Mask
44 | Pro Force Force Fins
45 | Sherwood Scuba Allure  Mask
46 | ScubaPro Delta Zip Boots
47 | TUSA Freedom One Pro Mask
48 | ScubaPro EverFlex Gloves
49 | [NAME]
50 | TUSA Imprex Dive Slipper
51 | Hollis M1 Mask
52 | ScubaPro MK25 S600 Regulator
53 | Cressi Big Eyes Evolution Crystal Mask
54 | Apeks XTX 50 Octopus Regulator
55 | TUSA Geminus Mask
56 | Oceanic Alpha 9 CDX5 Regulator
Spreadsheet: 19d5be9c-4c4e-4c88-8c59-8c2b880281d9
Sheet: Sheet1

Table S3 Association of rs299290-C with germline HMMR over-expression (dataset [NAME], 2010) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Genotype | n | Log expression mean (standard error) | Difference (95% CI)
T/T | 31 | 11.45 (0.10) | ---
C/T | 26 | 11.70 (0.09) | 0.24 (-0.03 - 0.52)
C/C | 2 | 11.80 (0.27) | 0.35 (-0.40 - 1.10)
Trend |  |  | 0.22 (-0.01 - 0.46)*
*P value = 0.069 (two-tailed test)
HMMR Illumina Target ID ILMN_16900_840612
Spreadsheet: 482632d1475164273-simeltaneous-xirr-outputs-with-multiple-inputs-irr-question-example
Sheet: Sheet1

 |  | 2015-01-31 00:00:00
Cash Flow: |  |  | 1000
Sale Price: |  | -6000 |  |  |  |  |  |  |  |  |  | 5250
XIRR Month 1:
XIRR Month 2:
XIRR Month 3:
XIRR Month 4:
XIRR Month 5:
ETC…
*What I want formula to output: |  |  |  |  | XIRR 4 | XIRR 5 | XIRR 6 | XIRR 7 | XIRR 8 | XIRR 9 | XIRR 10 | XIRR 11
I want to be able to drag formula across columns C to M and have correct IRRs without having to create as many rows as there are columns (as I am doing in rows 7-12)
Spreadsheet: 32331d1228428817-formula-based-on-which-item-is-selected-in-combo-box-book1-1-
Sheet: Sheet2

Mustang | 3.2
Spyker | 2.5
Enzo | 2.8
Vulcan | 2.65
Echo | 3
Raptor | 6.4
Elise | 1.8
Veyron | 3.9
F430 | 3.2
S2000 | 2.2
R1 | 1.4
Spreadsheet: 682228d1591968595-split-surplus-funds-split-surplus-funds
Sheet: Sheet1

 |  |  | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8
 |  | Net Sales |  |  |  |  | 3000 | 4000 | 4000
 |  | opening balance | 0
 |  | drawdowns | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800
 |  | Payment
 |  | closing balance 1
 |  | Surplus Cash
 |  | Seeking Result
 |  |  | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8
 |  | Net Sales |  |  |  |  | 3000 | 4000 | 5000
 |  | opening balance | 0 |  |  |  |  |  |  |  | 1500
 |  | drawdowns | 800 | 800 | 800 | 800 | 800 | 800 | 2000 | 1500
 |  | Payment |  |  |  |  |  | -1800 | -2000
 |  | closing balance 1
 |  | Surplus Cash
 |  |  |  |  |  |  |  | (4000-1800) | (5000-800)
Spreadsheet: 766680d1643993771-calculate-total-raw-material-qty-required-by-one-formula-calculateraws
Sheet: Sheet1

Finished Goods | Raw Materials | Qty of Raw Material Required | Column1 |  | Finished Goods | FG Name |  |  | Raw Materials | RM Name
FG-W | RM-1 | 4 |  |  | FG-W | Warkanas |  |  | RM-1 | Almatorin
FG-W | RM-2 | 7 |  |  | FG-X | Xferenec |  |  | RM-2 | [NAME]
FG-W | RM-3 | 3 |  |  | FG-Y | [NAME] |  |  | RM-3 | Charmengenlo
FG-X | RM-1 | 8 |  |  | FG-Z | Zirkoman |  |  | RM-4 | Derthyvolo
FG-X | RM-2 | 11
FG-X | RM-3 | 12
FG-X | RM-4 | 14
FG-Y | RM-2 | 2
FG-Y | RM-4 | 3
FG-Z | RM-1 | 40
FG-Z | RM-2 | 12
FG-Z | RM-3 | 14
FG-Z | RM-4 | 15
Above table lists qty required to make one unit of ech FG.
Now if we want to make
Finished Goods | FG Name | FG to be produced
FG-W | Warkanas | 7000
FG-X | Xferenec | 8000
FG-Y | [NAME] | 9000
FG-Z | Zirkoman | 10000
How much of following Raw Materials required |  |  |  |  |  |  |  |  |  | Answer is  for verification
Raw Materials | RM Name | Qty Required | Column1 |  |  |  |  |  |  | Raw Materials | RM Name | Qty Required
RM-1 | Almatorin |  |  |  |  |  |  |  |  | RM-1 | Almatorin
RM-2 | [NAME] |  |  |  |  |  |  |  |  | RM-2 | [NAME]
RM-3 | Charmengenlo |  |  |  |  |  |  |  |  | RM-3 | Charmengenlo
RM-4 | Derthyvolo |  |  |  |  |  |  |  |  | RM-4 | Derthyvolo
Spreadsheet: 760299d1640125949-display-names-of-individuals-trained-small-sample
Sheet: Training List

Name | EMP ID | Run/Taxi | [NAME]
[NAME] | ****** | X | X
Suzy | ****** |  | X
[NAME] | ****** | X
Dale | ******
[NAME] | ****** |  | X
[NAME] | ****** | X
Spreadsheet: 55948d1256102095-added-number-in-between-comfuzzled
Sheet: Sheet1

 |  |  | Before |  |  |  |  |  |  |  |  |  | After
 | Guild name |  |  | [NAME] title [#1] |  |  |  |  |  |  | Guild name |  |  | [NAME] title [#1]
 | Guild Leader |  |  | [NAME] |  |  |  |  |  |  | Guild Leader |  |  | [NAME]
 | Level |  |  | Level |  | 35 |  |  |  |  | Level |  |  | Level |  | 35
 | Experience |  | 95400 |  | / |  |  |  |  |  | Experience |  | 95400 |  | / |  |  | <-- I just want 1 column for this if it is possible
 | Members |  | 50 |  | / |  |  |  |  |  | Members |  | 50 |  | /
 | Tressures |  | 1 ◊ | 5 ● |  | 15 ○ | 120 ◦ |  |  |  | Tressures |  | 1 ◊ | 5 ● |  | 15 ○ | 120 ◦
 |  |  |  |  |  |  |  | offset |  |  |  |  |  |  |  |  |  | offset | <--- this is wrong it should be 562,695
 |  |  |  |  |  |  |  |  |  |  | This calcs with the 81.55 |  |  |  |  |  |  |  | between lv 34-35
 | the red u can change |  |  |  |  |  |  |  |  |  | And I don’t want that
 | the blue if u have to its not a problem but I like the out come of the added numbers |  |  |  |  |  |  |  |  |  | so I tried with it (-1) in a new colum and it still didn’t add up
 | I need 9,989,875
 | and 9,427,180 |  | to get that gap in one column |  |  | its ez to get it in 2, but when I use 2 and use the 81.55 formula, it calcs that number form level 34 even tho it not supposed to, haha im maken no sence.
 |  |  | if this looks like crap you should see my room XD, if you can help me on this it would be so much apressiatied
Spreadsheet: 836242d1689198910-combination-countifs-sumifs-book1_r2
Sheet: Metrics

 | Forecast Finish | Completed As Planned | Missed Tasks | Completed Early | Monthly Efficiency | Unstatused Starts | Unstatused Finishes
Contacts |  |  |  |  |  |  |  | Project A | Project B | Project C | Project D | Project E
Doe, J.
Smith, M.
Vader, D.
[NAME], [NAME]
[NAME], P.
[NAME], R.
Lincoln, A.
[NAME], F.
Nuts, D.
Spreadsheet: 870467d1716977747-pull-in-field-that-matches-and-item-and-falls-in-date-range-excel-problem
Sheet: Sheet1

 | MATRIX |  |  |  |  |  |  |  | orders list
 |  |  |  |  |  |  |  |  | Order Number | ITEM | ORDER DATE |  | RESULT
 | ITEM | START | END | USE VALUE |  |  |  |  | 11111 | APPLES | 2023-12-14 00:00:00 | if this order date is greater than start and less then end then we need it
 | apples | 2023-12-13 00:00:00 | 2023-12-21 00:00:00 | 31.79 | True |  |  |  | 12222 | oranges | 2024-12-20 00:00:00 | No match as does not fall in date range | 0
 | apples | 2023-12-12 00:00:00 | 2024-01-23 00:00:00 | 63.57 | True |  |  |  | 33333 | pears | 2023-03-28 00:00:00 | One matche falls in date range | 31.79
 | oranges | 2023-11-29 00:00:00 | 2023-12-12 00:00:00 | 31.79
 | oranges | 2023-07-19 00:00:00 | 2023-09-12 00:00:00 | 50.71
 | oranges | 2023-08-23 00:00:00 | 2023-09-12 00:00:00 | 31.79
 | oranges | 2023-09-13 00:00:00 | 2023-09-26 00:00:00 | 82.5
 | pears | 2024-03-27 00:00:00 | 2024-04-23 00:00:00 | 31.79
 | pears | 2024-04-24 00:00:00 | 2024-05-28 00:00:00 | 56.76
 | pears | 2023-09-27 00:00:00 | 2023-10-24 00:00:00 | 50.71
Spreadsheet: 6df01878-7687-4eef-a618-309ec8887d48
Sheet: Budget Template

 |  |  | Title of Project
 |  |  | starting date-ending date
Key Personnel |  |  | AY or ACAD % FTE (Course Release)* |  |  |  |  | Summer Effort
Role/Title | Name | Institutional Base Salary | Y1 | Y2 | Y3 | Y4 | Y5 | #Months | Summer FTE | # Years
PI/PD | PI Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 3
Co-PI | Co-PI Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 3
Co-PI | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 3
Co-PI | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 3
Research Assistant | Staff Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 3
 | Cost of Living Adjustment (COLA)' |  | 1.03 |  | *Note: One academic course release is equivalent to 14.29% FTE or 1/7 of faculty time
 |  |  | Year 1 |  |  |  |  | Total
[NAME] Salaries
 | AY/ACAD
 | Summer
 | Subtotal
Co-PI | AY/ACAD
 | Summer
 | Subtotal
Co-PI | AY/ACAD
 | Summer
 | Subtotal
Co-PI | AY/ACAD
 | Summer
 | Subtotal
 | AY/ACAD
 | Summer
 | Subtotal
 |  | Total Key Personnel (Salary)
 |  |  |  |  |  |  |  |  | Student Wages*
B. Student Wages |  |  |  |  |  |  |  |  | Rate/Hr | Hrs/Wk | #[NAME] | #Students | Level
 |  | Students Level 1 |  |  |  |  |  |  | 9.9 | 0 | 0 | 0 | Level 1
 |  | Students Level 2 |  |  |  |  |  |  | 11 | 0 | 0 | 0 | Level 2
 |  | Students Level 3 |  |  |  |  |  |  | 12.05 | 0 | 0 | 0 | Level 3
 |  | Students Level 4 |  |  |  |  |  |  | 21.67 | 0 | 0 | 0 | Level 4
 |  | Total Student Wages
 |  |  |  |  |  |  |  |  | *Consult Student Financial Services for the
[NAME] Benefits |  |  |  |  |  |  |  |  | job details that match each wage level
 |  | Key Personnel (30.6%)
 |  | Total Key Personnel (Fringe)
D. Equipment
 |  | Equipment | 0 | 0 | 0 | 0 | 0
 |  | Total Equipment
E. Travel
 |  | Domestic Travel | 0 | 0 | 0 | 0 | 0
 |  | Foreign Travel | 0 | 0 | 0 | 0 | 0
 |  | Total Travel
[NAME]
 |  | Participant/Student Stipends | 0 | 0 | 0 | 0 | 0
 |  | Participant/Student Travel | 0 | 0 | 0 | 0 | 0
 |  | Subsistence | 0 | 0 | 0 | 0 | 0
 |  | Other | 0 | 0 | 0 | 0 | 0
 |  | Total Participant Support
G. Other Direct Cost
 |  | Materials/Supplies | 0 | 0 | 0 | 0 | 0
 |  | Publication and Documentation | 0 | 0 | 0 | 0 | 0
 |  | Other | 0 | 0 | 0 | 0 | 0
 |  | Other | 0 | 0 | 0 | 0 | 0
 |  | Subtotal Supplies/Other
 |  | Consultant 1 | 0 | 0 | 0 | 0 | 0
 |  | Consultant 2 | 0 | 0 | 0 | 0 | 0
 |  | Subtotal Consultants
 |  | Computer Services | 0 | 0 | 0 | 0 | 0
 |  | Subtotal Computer Services
 |  | Total Other Direct Cost
[NAME]
 |  | Sub-Award 1 | 0 | 0 | 0 | 0 | 0
 |  | Sub-Award 2 | 0 | 0 | 0 | 0 | 0
 |  | Total Sub-Awards
I. Total Direct Costs
J. Total Indirect Costs (IDC)** |  | 0.485
K. Total Costs
Indirect Cost Base (salary and wages only)
**Seattle University's federally negotiated indirect cost rate is 48.5% of salaries and wages only.
Spreadsheet: 116920d1312305760-selective-columns-farthingstone
Sheet: bf

Beadsmore. Russ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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