tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 164153d1340661117-converting-matrix-data-into-a-table-transfering-data-into-a-table
Sheet: Sheet2

BOX # | part name | part number | Qty | status
Box 1
 | 50 part name | part 50 | 4 | questionable
 | 69 part name | part 69 | 9 | Bad
 | 70 part name | part 70 | 6 | Good
 | 72 part name | part 72 | 31 | Good
 | 106 part name | part 106 | 8 | Bad
 | 108 part name | part 108 | 4 | Good
 | 133 part name | part 133 | 4 | Very Good
 | 143 part name | part 143 | 3 | Very Good
 | 177 part name | part 177 | 1 | Bad
 | 178 part name | part 178 | 3 | Bad
 | 191 part name | part 191 | 1 | Very Good
[NAME]
 | 32 part name | part 32 | 4 | Good
 | 54 part name | part 54 | 2 | Bad
 | 66 part name | part 66 | 2 | Good
 | 71 part name | part 71 | 2 | Good
 | 86 part name | part 86 | 2 | Very Good
 | 110 part name | part 110 | 2 | Very Good
 | 120 part name | part 120 | 2 | Very Good
 | 129 part name | part 129 | 1 | Very Good
 | 137 part name | part 137 | 4 | Very Good
 | 138 part name | part 138 | 3 | Very Good
 | 139 part name | part 139 | 4 | Very Good
 | 140 part name | part 140 | 8 | Very Good
 | 142 part name | part 142 | 4 | Very Good
 | 144 part name | part 144 | 2 | Very Good
 | 145 part name | part 145 | 2 | Very Good
 | 147 part name | part 147 | 2 | Very Good
 | 149 part name | part 149 | 2 | Very Good
 | 150 part name | part 150 | 2 | Very Good
 | 152 part name | part 152 | 2 | Very Good
 | 155 part name | part 155 | 6 | Very Good
 | 156 part name | part 156 | 6 | Very Good
 | 157 part name | part 157 | 2 | Very Good
 | 160 part name | part 160 | 12 | Very Good
 | 161 part name | part 161 | 3 | Very Good
 | 162 part name | part 162 | 1 | Very Good
 | 163 part name | part 163 | 1 | Very Good
 | 164 part name | part 164 | 3 | Very Good
 | 179 part name | part 179 | 1 | Bad
 | 184 part name | part 184 | 2 | Very Good
 | 195 part name | part 195 | 2 | Very Good
 | 200 part name | part 200 | 4
 | 201 part name | part 201 | 2
Box 3
Box 5
Box 7
Box 9
Box 11
Box 13
Box 15
Box 17
Box 19
Box 21
Box 23
Box 25
Spreadsheet: 271199d1381861499-perpetual-3-month-calendar-formulas-only-3-month-calendar
Sheet: 3 Month Calendar

 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  |  | 10 | / | 2013
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  |  | 11 | / | 2013
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  |  | 12 | / | 2013
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat
Spreadsheet: 124802d1318612441-sorting-blank-data-out-of-a-list-classeur1
Sheet: Feuil1

Declared Components (as entered) | Declared Components (no blanks)
Spreadsheet: d156e71e-75ce-477e-8e9a-7e59ae6c28a2
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
FOOD1 | Test | FOOD1 | Food-Nut Panel # 2 | Food-Nut Panel # 2 | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL Additional Information: See 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
FOOD1 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
FOOD1 | Result | FOOD1 | Food-Nut Panel # 2 | Food-Nut Panel # 2 | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 46707-6
Spreadsheet: 044aa192-1a62-484e-96c0-6ec346c93213
Sheet: PAG 6 - Table 2

LAN results |  |  | Currency Translation | Organic Growth |  | % As | %
R$ million | YTD10 | Scope |  |  | YTD11 | Reported | Organic
Volume ('000 hl) | 85136.7562071634 | -516.247892 | 0 | 589.1262495050038 | 85209.62456466841 | 0.0008558977432462367 | 0.006961979563049215
Net revenue | 12309.799 | -103.639 | -37.85600123065217 | 1030.484001230652 | 13198.788 | 0.07221799478610502 | 0.08442327490633025
Net revenue/hl | 144.5885367073012 | -0.3426530198743194 | -0.4442690766924104 | 11.09623956280436 | 154.8978541735389 | 0.07130107061742619 | 0.07692586629958406
[NAME] | -4037.876 | -1.303000000000011 | 25.1099479273807 | -283.7929479273812 | -4297.862000000001 | 0.0643868211901506 | 0.07151580428359096
[NAME]/hl | -47.42811659601677 | -0.304744863008608 | 0.2946844098382798 | -3.000514846916857 | -50.43869189610395 | 0.06347659397337369 | 0.06397713282231303
Gross profit | 8271.923 | -104.942 | -12.74605330327147 | 746.6910533032709 | 8900.926 | 0.07604072233264247 | 0.09064089150133084
Gross margin | 0.67197872199213 |  |  |  | 0.674374495597626 | 20 | 40
SG&A excl. deprec.&amort. | -3394.582 | 67.547 | 19.55680226780214 | -185.1368022678025 | -3492.615 | 0.02887925523672741 | 0.05564618414528325
SG&A deprec.&amort. | -342.989 | -15.987 | 2.730209801931972 | 35.80679019806801 | -320.439 | -0.06574554869106597 | -0.1065874959012318
SG&A total | -3737.571 | 51.56 | 22.2870120697341 | -149.3300120697333 | -3813.054 | 0.02019573674988351 | 0.04076743455923188
Other operating income | 380.176 | -2.011 | 0.2994932636480065 | 86.396506736352 | 464.861 | 0.2227520937670973 | 0.2284624614555869
Normalized EBIT | 4914.527999999999 | -55.39300000000002 | 9.840452030110644 | 683.7575479698896 | 5552.732999999999 | 0.1298608940675483 | 0.138046468294461
Normalized EBIT margin | 0.399237063090957 |  |  |  | 0.4207002188382751 | 210 | 200
Normalized EBITDA | 5596.151 | 29.319 | 5.349907486656122 | 653.1170925133442 | 6283.937 | 0.1229034027137581 | 0.1161000045353267
Normalized EBITDA margin | 0.4546094538180517 |  |  |  | 0.4760995479281885 | 210 | 130
Spreadsheet: 723522d1615751225-excel-drop-down-list-populated-based-on-number-in-cell-list
Sheet: Sheet1

Item | Total | Remainder | List Value |  |  | [NAME] in List
50000001 | 22 | 3 |  |  |  | 1
50000002 | 3 | 15 |  |  |  | 2
50000002 | 12 | 15 |  |  |  | 3 |  | 50000001 | 3
50000002 | 100 | 15 |  |  |  | 4
 |  |  |  |  |  | 5
 |  |  |  |  |  | 6
 |  |  |  |  |  | 7
 |  |  |  |  |  | 8
 |  |  |  |  |  | 9
 |  |  |  |  |  | 10
 |  |  |  |  |  | 11
 |  |  |  |  |  | 12
 |  |  |  |  |  | 13
 |  |  |  |  |  | 14
Spreadsheet: 713736d1610902359-formula-for-next-due-date-example-credit-cards
Sheet: Matt

[NAME] | Gold | Platinum | FF Plus | Lock Bank | Preferred | Xellence | Total
Interest Rate | 0.0899 | 0.0795 | 0.0499 | 0.0679 | 0.059 | 0.0549
Due Day | 6 | 8 | 19 | 20 | 23 | 27
Limit | 2500 | 15500 | 9000 | 25000 | 10000 | 8975
Balance | 235 | 128.35 | 130.5 | 229.12 | 98.58 | 120.12
Available
Utilization
Target @ 25%
Over Target
[NAME] 30%
Overutilization
Last Payment | 2020-12-31 00:00:00 | 2021-01-02 00:00:00 | 2021-01-17 00:00:00 | 2021-01-17 00:00:00 | 2021-01-17 00:00:00 | 2021-01-17 00:00:00
Spreadsheet: 190957d1351864033-how-to-display-only-unique-values-excelforum
Sheet: Sheet1

TITLE | ALBUM | ARTIST | GTIN | QUANTITY | NET RECEIVED FROM PARTNER | ROYALTY | TRANSACTION TYPE | LABEL | PARENT LABEL
(song name) | (album name) | [NAME] | CA123 | 5 | 0.0264 | 0.1056 | Sale | Yashar | [NAME]
(song name) | (album name) | [NAME] | CA456 | 5 | 0.0036 | 0.0144 | Sale | Yashar | [NAME]
(song name) | (album name) | [NAME] | CA456 | 5 | 0.0528 | 0.2112 | Sale | Yashar | [NAME]
(song name) | (album name) | [NAME] | CA456 | 5 | 0.0264 | 0.1056 | Sale | Yashar | [NAME]
(song name) | (album name) | [NAME] | CA456 | 5 | 0.0264 | 0.1056 | Sale | Yashar | [NAME]
(song name) | (album name) | [NAME] | CA456 | 5 | 0.0264 | 0.1056 | Sale | Yashar | [NAME]
(song name) | (album name) | [NAME] | CA456 | 5 | 0.0264 | 0.1056 | Sale | Yashar | [NAME]
(song name) | (album name) | [NAME] | CA456 | 10 | 0.0528 | 0.2112 | Sale | Yashar | [NAME]
(song name) | (album name) | [NAME] | CA456 | 15 | 0.0795 | 0.318 | Sale | Yashar | [NAME]
(song name) | (album name) | [NAME] | CA456 | 5 | 0.0264 | 0.1056 | Sale | Yashar | [NAME]
(song name) | (album name) | [NAME] | CA456 | 100 | 0.5559 | 2.2236 | Sale | Yashar | [NAME]
(song name) | (album name) | [NAME] | CA456 | 15 | 0.0108 | 0.0432 | Sale | Yashar | [NAME]
(song name) | (album name) | [NAME] | CA456 | 5 | 0.0264 | 0.1056 | Sale | Yashar | [NAME]
(song name) | (album name) | [NAME] | CA456 | 5 | 0.0318 | 0.1272 | Sale | Yashar | [NAME]
(song name) | (album name) | [NAME] | CA789 | 5 | 0.0318 | 0.1272 | Sale | Yashar | [NAME]
(song name) | (album name) | [NAME] | CA789 | 5 | 0.0156 | 0.0624 | Sale | Yashar | [NAME]
(song name) | (album name) | [NAME] | CA789 | 5 | 0.0267 | 0.1068 | Sale | Yashar | [NAME]
(song name) | (album name) | [NAME] | CA222 | 5 | 2.3406 | 9.362400000000001 | Sale | [NAME] | Making the world Awesome
(song name) | (album name) | [NAME] | CA222 | 5 | 2.3406 | 9.362400000000001 | Sale | [NAME] | Making the world Awesome
(song name) | (album name) | Kamakazi | CA555 | 5 | 2.3274 | 9.3096 | Sale | [NAME] | Making the world Awesome
(song name) | (album name) | [NAME] | CA345 | 5 | 2.259 | 9.036 | Sale | [NAME] | Making the world Awesome
(song name) | (album name) | [NAME] | [NAME] | 5 | 2.7804 | 11.1216 | Sale | [NAME] | Making the world Awesome
(song name) | (album name) | [NAME] | [NAME] | 5 | 2.7804 | 11.1216 | Sale | [NAME] | Making the world Awesome
(song name) | (album name) | [NAME] | 619061362721 | 5 | 27.9504 | 111.8016 | Sale | [NAME] | Making the world Awesome
 |  |  | I'd like to give all the unique values down here, from D32 onwards. In E32 I'd like to see all the unique values, in one cell, separated by a comma
Spreadsheet: 121498d1316099158-price-list-quotation-help-please-im-lost-price-list
Sheet: Sheet1

TC2071A
STYLE | S.NAME | DA/ | RS. |  | [NAME] | [NAME] | US$ | EURO
 |  | PA |  |  |  | CMS
Jcm2070 | ANJ | PA | 666 | PC | Queen duvet cover with | 89x91"
 |  |  |  |  | two pillow case(simons
 |  |  |  |  | comb.B) hunter green/
 |  |  |  |  | navy blue/cinnamoncheck
Pm2070A | ANJ |  | 242 | PC | Showercurtain hunter grn | 72x72"
 |  |  |  |  | navy/blue/cinnamoncheck
JCM-2071 | ANJ | PA |  |  | Double duvet cover with | 81x89"
 |  |  |  |  | 2pillow case yl/blue
 |  |  |  |  | check.(Simon comb. C)
TC2071A | ANJ |  |  |  | Shower curtain yl/blue/ | 72x72"
 |  |  |  |  | checks
Jcm-2072 | ANJ | PA | 441.5 | PC | Twin duvet cover with | 66x89"
 |  |  |  |  | 2 pillow covers cinnamon
 |  |  |  |  | burgendry/navy/yl chk in
 |  |  |  |  | front (same comb. Strips
 |  |  |  |  | at back)
[NAME] | ANJ | PA | 242 | PC | Shower curtain(cinnamon | 72x72"
 |  |  |  |  | burgendry/navy/yl checks
 |  |  |  |  | (Simons comb.D)
Jcm-2074 | ANJ | PA |  |  | Shower curtain(cinnamon | 72x72"
 |  |  |  |  | burgundy navy/yellow
 |  |  |  |  | strips ([NAME] comb.E)
Jcm2075A | Anjprj34 | DA/P | 15.91666666666667 | PC | Ribbed pla.mat charcoal
Spreadsheet: 537285d1504913586-this-operation-has-been-canceled-new-excel-error-budget
Sheet: How-to-use

Budget planner
 |  |  |  |  |  |  |  |  |  | Summary |  |  | Income | Outgoings |  |  | What's Left
 | [NAME] |  |  |  |  |  |  |  |  | Show results
 |  |  |  |  |  |  |  |  |  |  |  |  | 33276 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | Income
 |  |  |  |  |  |  |  |  |  | Income | 33276
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 7520 |  |  | 0
 |  |  |  |  |  |  |  |  | Total income: |  | 33276 |  | 0 | 7887 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 3824 |  |  | 0
 |  |  |  |  |  |  |  |  |  | Outgoings |  |  | 0 | 4440 |  | Select | 0
 |  |  |  |  |  |  |  |  |  | Financial comm. | 7520 |  | 0 | 777 | 2 | Weekly | 0
 |  |  |  |  |  |  |  |  |  | Home | 7887 |  | 0 | 1768 | 3 | Fortnightly | 0
 |  |  |  |  |  |  |  |  |  | Utilities | 3824 |  | 0 | 333 | 4 | Monthly | 0
 |  |  |  |  |  |  |  |  |  | Education | 4440 |  | 0 | 25 | 5 | Quarterly | 0
 |  |  |  |  |  |  |  |  |  | Health | 777 |  | 0 | 3996 | 6 | Annually | 0
 |  |  |  |  |  |  |  |  |  | Shopping | 1768 |  | 0 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | Transport | 333 |  | 0 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | Entertainment | 25
 |  |  |  |  |  |  |  |  |  | Eating out | 3996
 |  |  |  |  |  |  |  |  | Total outgoings: |  | 30570
 |  |  |  |  |  |  |  |  | What's left: |  | 2706 |  | 33276
 |  |  |  |  |  |  |  |  |  |  | per year
 |  |  |  |  |  |  |  |  |  |  |  |  | 30570
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: bd8cf470-d3ad-4c04-ad1a-2d9485d7e2bf
Sheet: Sheet1

Table S3 - Expressed genes and differentially expressed genes in Schistosomula treated with human TNF-alpha for 1 h | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Category | # of probes in the array | # of expressed probes (redundant set) | # of expressed genes (unique set) | # of differentially expressed genes | # of genes with higher expression in TNF-alpha treated schistosomula | # of genes with lower expression in TNF-alpha treated schistosomula
S. mansoni genes w/orthologs in other species | 8949 | 6957 | 4660 | 217 | 136 | 81
S. mansoni genes in japonicum only | 5502 | 3638 | 2725 | 98 | 54 | 44
S. mansoni genes w/ NoMatch in GenBank | 27258 | 9755 | 8970 | 233 | 119 | 114
Total | 41709 | 20350 | 16355 | 548 | 309 | 239
Spreadsheet: 841722d1693901202-listing-staff-and-roles-according-to-table-staff-operations-excel-test
Sheet: Staff Site Allocate

 | BRAND PARTNER DEMO | CATALINA BAY | CATALINA BAY CU | CINTRA | IMPERIAL GARDENS | NATONAL MINI | QUEEN STREET | SPENCER | STARBUCKS | STUDIO ONE | SUMMIT | T BUILD | UNITEC | VICTORIA AVE | WESTWOOD
[NAME] |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Leading Hand |  | [NAME], [NAME], Miku Torralba, [NAME], [NAME] |  | [NAME] | [NAME], [NAME], [NAME] |  | [NAME] | Conrad Beukes |  | [NAME] | [NAME] |  | [NAME], [NAME] Pajo | [NAME], [NAME], [NAME] | [NAME], [NAME]
[NAME] | [NAME], Waka Peehikura | [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], Pablo Munoz, [NAME], [NAME], [NAME], [NAME], [NAME] | [NAME], [NAME], [NAME], [NAME], Redelito Barnes, [NAME] | Arnel Abitan, Pepito Meneses | [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME] |  | [NAME], [NAME], [NAME], [NAME], [NAME] |  |  | [NAME], [NAME], Elmer Esteta | [NAME] | [NAME], [NAME] |  | [NAME], [NAME], Erano Obal, Graciano Balanta, [NAME], Juanito Crisostomo, [NAME], [NAME] | Ador Tabios, [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], Pravish [NAME], [NAME], [NAME]
# of Staff on this site
Spreadsheet: 786722d1657391967-npv-with-dynamic-range-npv-variable-range
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Proof of Concept
 |  |  |  | 2019 |  |  |  |  |  |  |  |  | NPV | Manual | NPV=[NAME]
 |  |  | Project 1 |  |  | -2 | 1 | 1 | 1 | 1 | 1
 |  |  | Project 2 |  | -0.5 | 0.3 | 0.4 | 0.5 | 0.5
 |  |  | Project 3 | -4 | 1 | 1 | 1 | 1 | 1
 |  |  | Project 4 |  |  | -1 | 0.3 | 0.5 | 0.5 |  | 0.5
Spreadsheet: thomas_martin__39770__May01
Sheet: Sheet1

 |  |  |  |  | May 01 Transportation Rates
 |  |  |  | HSP Minus |  | Deliveries |  |  | Deliveries
 |  | Receipts |  | Supply |  | Trnspt. | Delivered |  | Trnspt. | Delivered
 |  |  |  | Price |  | HSC Loop | Price |  | HSC - Beau | Price
King Ranch, Live Oak |  |  |  | -0.15 |  | 0.12
[NAME] |  |  |  | -0.15 |  | 0.12
[NAME] |  |  |  | -0.13 |  | 0.1
Oasis,Western & PG&E Katy |  |  |  | -0.035 |  | 0.01
Lonestar,Tailgate |  |  |  | -0.035 |  | 0.01
Texoma |  |  |  | -0.07 |  | 0.05
[NAME] |  |  |  | -0.06 |  | 0.03
Enerfin, M. Bluff, Devers, La Porte |  |  |  | -0.05 |  | 0.02
 |  |  |  |  |  | Add $.01 for CP&L
 |  |  |  |  |  | Deliveries
 |  | Receipts |  | Supply |  | Trnspt. | Delivered
 |  |  |  | Price |  | Corpus | Price
[NAME], King |  |  |  |  |  | 0.07
[NAME] |  |  |  |  |  | 0.06
Western & PG&E Katy,Oasis,lonestar,enerfin |  |  |  | 0 |  | 0
Tailgate |  |  |  | 0 |  | 0
[NAME], M. Bluff, Devers, La Porte |  |  |  | 0 |  | 0
Texoma |  |  |  | 0 |  | 0
Spreadsheet: 674025d1587638127-issue-with-excel-solver-for-optimizing-smoothning-constant-in-winthers-forecasting-model-forecasting-case-thomas
Sheet: Comparison Matrix 

 |  |  |  |  |  | TS Range(BP) |  | TS Range (CP)
 | Forecasting Method | MAD(BP) | MAD(CP) | MAPE (%)(BP) | MAPE (%)(CP) | Lowest | Highest | Lowest | Highest
 | Moving Average
 | Simple Exponential Smoothening
 | Holts
 | Winthers
Spreadsheet: 114ca152-bfc6-481b-a591-8120ec902124
Sheet: Sheet1

Farm Life | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
2009-11-22 00:00:00
60 Entrants
$264 Paid To Course
Grand Master (9)
GM | [NAME] |  | 59 | 53 | 112 | $25 & Trophy
GM | [NAME] ? |  | 56 | 56 | 112 | 15
GM | [NAME] |  | 61 | 54 | 115 | 9
GM | Stack |  | 57 | 60 | 117 | 8
GM | Kent |  | 60 | 61 | 121
GM | [NAME] |  | 60 | 62 | 122
GM | Ubin |  | 60 | 62 | 122
GM | Bear |  | 64 | 62 | 126
GM | [NAME] |  | 74 | 75 | 149
Pro (6)
P | [NAME] |  | 48 | 50 | 98 | $68 $ [NAME]
P | JL |  | 53 | 53 | 106 | 41
P | That Guy |  | 52 | 55 | 107
P | [NAME] |  | 56 | 52 | 108
P | [NAME] |  | 55 | 57 | 112
P | [NAME] |  | 57 | 55 | 112
Pro Master (9)
PM | [NAME] |  | 48 | 47 | 95 | $48 & Trophy
PM | [NAME] |  | 50 | 50 | 100 | 30
PM | [NAME] |  | 52 | 52 | 104 | 22
PM | TomA |  | 58 | 52 | 110 | 16
PM | [NAME] |  | 55 | 56 | 111
PM | [NAME] |  | 59 | 55 | 114
PM | Chuckster |  | 56 | 59 | 115
PM | Wheat |  | 57 | 62 | 119
PM | Stretch |  | 61 | 60 | 121
Advanced Women (1)
ADW | [NAME] |  | 65 | 59 | 124 | $13 & Trophy
Advanced (11)
ADV | [NAME] |  | 56 | 50 | 106 | $38 & Trophy
ADV | AJ Peaks |  | 57 | 50 | 107 | 31
ADV | [NAME] |  | 54 | 54 | 108 | 24
ADV | [NAME] |  | 59 | 51 | 110 | 21
ADV | [NAME] |  | 61 | 53 | 114 | 14
ADV | Garland |  | 61 | 55 | 116
ADV | [NAME] |  | 58 | 60 | 118
ADV | [NAME] |  | 57 | 63 | 120
ADV | [NAME] |  | 62 | 59 | 121
ADV | [NAME] |  | 61 | 63 | 124
ADV | [NAME] |  | 68 | 62 | 130
Advanced Master (3)
ADM | Grinder |  | 54 | 59 | 113 | $13 & Trophy
ADM | [NAME] |  | 59 | 63 | 122 | 11
ADM | MC-Hard |  | 66 | 67 | 133
Amateur Women (1)
AMW | [NAME] |  | 65 | 76 | 141 | $13 & Trophy
Amateur (11)
AM | Trashbaby |  | 56 | 52 | 108 | $39 & Trophy
AM | [NAME] |  | 56 | 56 | 112 | 26
AM | [NAME] |  | 58 | 57 | 115 | 19
AM | [NAME] |  | 58 | 62 | 120 | 19
AM | Cliff P |  | 64 | 61 | 125 | 14
AM | [NAME] |  | 59 | 67 | 126 | 11
AM | [NAME] |  | 60 | 67 | 127
AM | EJ Carpino |  | 71 | 70 | 141
AM | Boosty |  | 74 | 75 | 149
AM | [NAME] |  | 72 | 77 | 149
AM | [NAME] |  | 86 | 85 | 171
Amateur Master (9)
[NAME] | [NAME] |  | 62 | 57 | 119 | $35 & Trophy
[NAME] | [NAME] |  | 65 | 56 | 121 | 23
[NAME] | [NAME] |  | 63 | 61 | 124 | 16
[NAME] | [NAME] |  | 64 | 71 | 135 | 14
[NAME] | [NAME] |  | 71 | 64 | 135 | 14
[NAME] | JG |  | 69 | 67 | 136
[NAME] | Pee Wee |  | 67 | 70 | 137
[NAME] | [NAME] |  | 71 | 67 | 138
[NAME] | [NAME] |  | 69 | 77 | 146
Spreadsheet: 7d3cfa9f-9788-41e4-a694-c6a7c1a14552
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
6041 | 43608 | [NAME] | Kelly | USA | 605 | 00:00:00 | 00:00:00 | 00:39:53 | [NAME] | 00:21:42 | 1 | 01:07:10
Spreadsheet: 775287d1648985244-calculate-pay-rate-depending-on-the-time-of-day-help-1-etaf
Sheet: Summary

Week-Num | 7
Row Labels | Sum of Total
Feb | 450.1333333333333
06-Feb | 83.30000000000001
07-Feb | 74.96666666666665
08-Feb | 81.68333333333332
10-Feb | 79.51666666666667
11-Feb | 87.09999999999997
12-Feb | 43.56666666666671
Grand Total | 450.1333333333333
Spreadsheet: 838206d1690818207-calculate-a-value-based-on-several-conditions-dont-think-if-function-works-book1test
Sheet: Sheet1

NAME | MICROMARKET# | STORE QUALITY | MICROMARKET VALUE | STORE VALUE | VALUE BASED ON STORE QUALITY
STORE A | 1 | good | 46632.75468800001 |  |  |  |  | Category | Weight
STORE B | 1 | medium | 46632.75468800001 |  | 17487.283008 |  |  | Very Good | 1.5
STORE C | 2 | GOOD | 287956.669312 |  | 102841.6676114286 |  |  | Good | 1.25
STORE E | 2 | MEDIUM | 287956.669312 |  | 61705.00056685715 |  |  | Medium | 0.75
STORE F | 2 | MEDIUM | 287956.669312 |  | 61705.00056685715 |  |  | Poor | 0.5
STORE G | 2 | MEDIUM | 287956.669312 |  | 61705.00056685715
STORE H | 3 | POOR | 164148.24192 |  | 18238.69354666667
STORE I | 3 | MEDIUM | 164148.24192 |  | 27358.04032
STORE J | 3 | GOOD | 164148.24192 |  | 45596.73386666668
STORE K | 3 | POOR | 164148.24192 |  | 18238.69354666667
STORE L | 3 | MEDIUM | 164148.24192 |  | 27358.04032
STORE M | 3 | MEDIUM | 164148.24192 |  | 27358.04032
STORE O | 4 | GOOD | 42797.90195200001 |  | 13374.34436
STORE P | 4 | MEDIUM | 42797.90195200001 |  | 8024.606616000001
STORE Q | 4 | GOOD | 42797.90195200001 |  | 13374.34436
STORE R | 4 | MEDIUM | 42797.90195200001 |  | 8024.606616000001
Spreadsheet: 37246d1235176600-formula-using-worksheet-name-formula-using-worksheet-name
Sheet: Week3

Week | 3 |  |  | FOR EXAMPLE…
 |  |  |  | I have created 3 worksheets
 | Week1 | Total
Item 1 | 5 |  |  | How can I get C7 to get the value from previous week (week2) rather than Week1 worksheet, that would mean I have to change function every week when I copy to a new worksheet every week.
Item 2 | 4 |  |  | For example if Week4, it should look the value from Week 3 and so on…
Item 3 | 8 |  |  | More easier to use a function something like this on cell [NAME]…. |  |  |  |  | =SUM(B7+(Week&B3&-1)!C7) |  |  | I understand this is not correct function, could you help.
Item 4 | 6
Spreadsheet: 290156d1389804304-moving-target-item-match-between-two-sheets-itemmatchsheet
Sheet: Sheet1

 | QOH ON HAND | 2014-01-14 00:00:00 | 2014-01-15 00:00:00 | 2014-01-16 00:00:00 | 2014-01-17 00:00:00 | 2014-01-18 00:00:00 | 2014-01-19 00:00:00 | 2014-01-20 00:00:00 | 2014-01-21 00:00:00 | 2014-01-22 00:00:00 | 2014-01-23 00:00:00 | 2014-01-24 00:00:00 | 2014-01-25 00:00:00 | 2014-01-26 00:00:00 | 2014-01-27 00:00:00 | 2014-01-28 00:00:00 | 2014-01-29 00:00:00
ITEM1
ITEM2
ITEM3
ITEM4
ITEM5
ITEM6
ITEM7
ITEM8
ITEM9
ITEM10
ITEM11
ITEM12
ITEM13
ITEM14
ITEM15
ITEM16
ITEM17
ITEM18
ITEM19
ITEM20
ITEM21
ITEM22
ITEM23
ITEM24
ITEM25
ITEM26