tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 528388d1500348454-how-to-move-data-from-a-single-row-to-multiple-columns-how-to-move-data-from-a-single-row-to-multiple-columns
Sheet: Query

Current Format
Product ID | Team Name | Path ID | Form  Title | STATUS | Date Completed | Questions | ANSWER
Product 1 | ABC TEAM | 12 | Evaluation Form | Completed | 2017-06-01 00:00:00 | Form Stage | Start
Product 1 | ABC TEAM | 12 | Evaluation Form | Completed | 2017-06-01 00:00:00 | Score 3: Quality | 9
Product 1 | ABC TEAM | 12 | Evaluation Form | Completed | 2017-06-01 00:00:00 | Score 1: Time | 8
Product 1 | ABC TEAM | 12 | Evaluation Form | Completed | 2017-06-01 00:00:00 | Score 2: Strength | 8
Product 1 | ABC TEAM | 12 | Evaluation Form | Completed | 2017-06-30 00:00:00 | Form Stage | Final
Product 1 | ABC TEAM | 12 | Evaluation Form | Completed | 2017-06-30 00:00:00 | Score 3: Quality | 9
Product 1 | ABC TEAM | 12 | Evaluation Form | Completed | 2017-06-30 00:00:00 | Score 1: Time | 8
Product 1 | ABC TEAM | 12 | Evaluation Form | Completed | 2017-06-30 00:00:00 | Score 2: Strength | 8
Product 2 | ABC TEAM | 14 | Evaluation Form | Completed | 2017-06-22 00:00:00 | Form Stage | Review
Product 2 | ABC TEAM | 14 | Evaluation Form | Completed | 2017-06-22 00:00:00 | Score 3: Quality | 5
Product 2 | ABC TEAM | 14 | Evaluation Form | Completed | 2017-06-22 00:00:00 | Score 1: Time | 7
Product 2 | ABC TEAM | 14 | Evaluation Form | Completed | 2017-06-22 00:00:00 | Score 2: Strength | 5
Product 3 | DEF TEAM | 16 | Evaluation Form | In Progress | 2017-06-29 00:00:00 | Form Stage | Start
Product 3 | DEF TEAM | 16 | Evaluation Form | In Progress | 2017-06-29 00:00:00 | Score 3: Quality | 8
Product 3 | DEF TEAM | 16 | Evaluation Form | In Progress | 2017-06-29 00:00:00 | Score 1: Time | 7
Product 3 | DEF TEAM | 16 | Evaluation Form | In Progress | 2017-06-29 00:00:00 | Score 2: Strength | 7
Product 3 | DEF TEAM | 16 | Evaluation Form | In Progress | 2017-07-10 00:00:00 | Form Stage | Final
Product 3 | DEF TEAM | 16 | Evaluation Form | In Progress | 2017-07-10 00:00:00 | Score 3: Quality | 10
Product 3 | DEF TEAM | 16 | Evaluation Form | In Progress | 2017-07-10 00:00:00 | Score 1: Time | 5
Product 3 | DEF TEAM | 16 | Evaluation Form | In Progress | 2017-07-10 00:00:00 | Score 2: Strength | 5
Desired Format
Product ID | Team Name | Path ID | Form  Title | STATUS | Date Completed | ANSWER | Score 1: Time | Score 2: Strength | Score 3: Quality
Desired Format
Product ID | Team Name | Path ID | Form  Title | STATUS | Date Completed | Form Stage | Score 1: Time | Score 2: Strength | Score 3: Quality
Product 1 | ABC TEAM | 12 | Evaluation Form | Completed | 2017-06-01 00:00:00 | Start | 8 | 8 | 9
Product 1 | ABC TEAM | 12 | Evaluation Form | Completed | 2017-06-30 00:00:00 | Final | 8 | 8 | 9
Product 2 | ABC TEAM | 14 | Evaluation Form | Completed | 2017-06-22 00:00:00 | Review | 7 | 5 | 5
Product 3 | DEF TEAM | 16 | Evaluation Form | In Progress | 2017-06-29 00:00:00 | Start | 7 | 7 | 8
Product 3 | DEF TEAM | 16 | Evaluation Form | In Progress | 2017-07-10 00:00:00 | Final | 5 | 5 | 10
Spreadsheet: 295044d1391577962-automatically-fitering-values-through-based-on-a-criteria-database-and-constituent-tabs
Sheet: NSW

 |  |  | Category | List A | List B | List C
 |  |  | Category | List A | List B | List C
 |  |  | A | 0.8451013965258007 | 0.4232240621275081 | 0.02194651506100243
 |  |  | B | 0.1173042878678868 | 0.6465767962754666 | 0.5645157664299879
 |  |  | C | 0.4963556320036083 | 0.5007580101696384 | 0.3530085434334198
 |  |  | D | 0.5288290663519298 | 0.4495786342779263 | 0.8550160712642259
 |  |  | E | 0.5298993254044969 | 0.5498010938624269 | 0.6092992868129393
 |  |  | F | 0.5784435286374845 | 0.6294835667158095 | 0.5514572090898321
 |  |  | G | 0.5435321913698196 | 0.5019708120547799 | 0.3936818627735323
 |  |  | H | 0.03695074451148106 | 0.8983198386127563 | 0.1670678800299645
 |  |  | I | 0.08673871967482638 | 0.2595955610229939 | 0.4300324232709879
Spreadsheet: 68259d1268786902-problem-creating-an-if-formula-data-sample-for-formula-problem
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
P1 |  | 33 |  |  |  | 12 | F5 | F4 | 1 | F4 |  |  | 2 | F5 | F4 |  |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 10 | 0 | 0 | 85
P2 | F7 |  | 27 | F4 | 14 |  |  |  |  |  | F4 | F6 |  |  |  | F5 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 5 | 6 | 7 | 70
P1 | F4 |  | 1 | 10 |  |  |  |  |  |  |  |  |  |  |  | 32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0 | 0 | 0 | 47
P2 |  | 5 |  |  | 1 | 24 | F4 | F4 | F4 | 1 | F4 | F4 | F4 | F4 | F4 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | 0 | 0 | 0 | 68
 | In Rows 2 and 3, I want a formula to ignore F7 in Cell B3 and find the first cell in a column which is numerical - in this example it is 33 in cell C2.
 | It should then look at the total in AJ2 and if that is greater than AJ3 it would return a Value of "1" or if it is smaller it would return a Value of "0".
 | Similarly in Rows 4 and 5, the formula needs to ignore the value of F4 in Cell B4 and find the value of 5 in cell C5. Then if AJ5 > AJ4 return "1" or "0"
 | if AJ4>AJ5.
Spreadsheet: gerald_nemec__11487__Netback calculation - Crescndo
Sheet: San Arroyo  Entrada

 | CURRENT PRICING CALCULATIONS
 | Field Name: | San Arroyo
 | Production Zone: | Entrada
 | Company: | Crescendo Energy, LLC
 | CALCULATED FROM INLET SIDE
 | Flow Rate |  | 10 | MMSCFD |  |  |  |  | MMSCFD
 | BTU Content |  | 0.68 | MMBTU/MSCF |  |  |  | 1.09 | MMBTU/MSCF
 | Flow Rate |  |  | MMBTU/D |  |  |  |  | MMBTU/D
 | Sales Price |  |  | /MMBTU |  |  |  |  | MMBTU
 | Processing Fee |  | 0.62 | /MSCF (INLET) |  |  |  |  | /MSCF (OUTLET)
 |  |  |  | /MMBTU (INLET) |  |  |  |  | /MMBTU (INLET)
 | Gathering Fee |  | 0.275 | /MSCF (INLET) |  |  |  |  | /MSCF (INLET)
 |  |  |  | /MMBTU (INLET) |  |  |  |  | /MMBTU (INLET)
 | FL&U and Plant Shrink |  |  | MMSCFD
 | (includes gathering/processing) |  |  | MMBTU/DAY
 | Adjusted Sale Price |  |  | /MSCF
 | Fuel Gas Adjustment |  |  | /MSCF
 |  |  |  |  |  | Gathering FL&U |  |  | 0.015
 | Net Back to Producer |  |  | /MSCF |  | Plant Shrink |  |  | 0.02
 |  |  |  |  |  | Plant Fuel Gas |  |  | 0.1
 |  |  |  |  |  | Total FL&U and Plant Shrink
 | Revenue per Day |  |  | /DAY
Spreadsheet: lisa_gang__22229__ENA_PGE_MARCH_22_23_2002
Sheet: SYS-JD OR GRIZZ BR

From: | EPMI
To: | PGE System Transactions
Date:
HE
ENDING |  |  |  |  | SINK | SINK | SINK | SINK | SINK
Pacific Prevailing
Time | SYS/SYS OUT AT GRIZZLY | SYS | PGE LOSSES | PGE LOSSES | EPMI COB S/N | PGE LOSSES | TO GRIZZLY | TO SYS | TO [NAME] | BUY/RESALE
(PPT) |  |  |  |  | LOSS RETURN |  |  |  |  | [NAME]
0100 |  |  | 0 |  |  | 0
0200 |  |  | 0 |  |  | 0
0300 |  |  | 0 |  |  | 0
0400 |  |  | 0 |  |  | 0
0500 |  |  | 0 |  |  | 0
0600 |  |  | 0 |  |  | 0
0700 |  |  |  | 0 |  | 0
0800 |  |  |  | 0 |  | 0
0900 |  |  |  | 0 |  | 0
1000 |  |  |  | 0 |  | 0
1100 |  |  |  | 0 |  | 0
1200 |  |  |  | 0 |  | 0
1300 |  |  |  | 0 |  | 0
1400 |  |  |  | 0 |  | 0
1500 |  |  |  | 0 |  | 0
1600 |  |  |  | 0 |  | 0
1700 |  |  |  | 0 |  | 0
1800 |  |  |  | 0 |  | 0
1900 |  |  |  | 0 |  | 0
2000 |  |  |  | 0 |  | 0
2100 |  |  |  | 0 |  | 0
2200 |  |  |  | 0 |  | 0
2300 |  |  | 0 |  |  | 0
2400 |  |  | 0 |  |  | 0
 |  |  | BPA(G) | AVISTA(G) CHELAN |  |  |  |  |  | SHOULD BE ZERO
 |  |  | AVISTA(PSE) | EPMI(PSE) | EPMI COB S/N | PGE LOSSES | TO COB' | TO COB' | TO COB'
 |  |  | EPMI(PSE) | SNPD(T) MIDC/PGE SYS | LOSS RETURN |  | SEE COB SHEET | SEE COB SHEET | SEE COB SHEET
 |  |  | SNPD(T) BPAP/PGE SYS | EPMI(PSE)
 |  |  | EPMI(PSE) | PGE@SYS   LOSSES
 | PGE(L,R)SYS/SYS OUT AT GRIZZLY | PGE(L,R)SYS   SYSTEM SALE | PGE@SYS   LOSSES
 |  | NOT A BUY/RESALE
Spreadsheet: 114861d1310562054-sumproduct-calculation-capex-and-opex-stock-distribution-spreadsheet-test
Sheet: Sheet1

 | A | B | C | D |  |  | E |  |  |  |  | F
 | Stock Out | Prod ID No. | Opex Stock in | Capex Stock In |  | ID No. | opex open stock | opex stock in | opex stock out | Opex Running Stock |  | capex open stock | capex stock in | capex stock out | Capex Running Stock |  | Total Running Stock
 |  | 001 |  |  |  | 001 | 50 | 0 |  | 50 |  | 10 | 0 | 0 | 10 |  | 60
 |  | 001
 |  | 001 |  |  |  | Spreadsheet needs to take stock out of capex stock first, and to take capex running stock to zero before stock starts to be taken out of the opex stock out column
 |  |  |  |  |  | A | This is the cumulative stock out for all items removed from the stock under the product id no. of 001 (this cannot be done with 2 columns for items being booked out.
 |  |  |  |  |  | B | The product id no. (the whole sheet will run from 001 to 1630)
 |  |  |  |  |  | C | Opex bought stock incoming
 |  |  |  |  |  | D | Capex bought stock incoming
 |  |  |  |  |  | E | Opex bought stock opening figure
 |  |  |  |  |  | F | Capex bought stock opening figure
Spreadsheet: 2e6cfb0d-7866-45d7-ba88-144c0e4a3990
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
2999 | 13378 | Frieda | Metz | GER | 944 | 00:45:17 | 00:01:53 | 01:13:39 | 00:02:29 | 00:26:54 | 1 | 02:30:11
2999 | 8141 | Celeste | Callahan | USA | 941 | 00:51:29 | 00:03:05 | 01:12:52 | 00:02:36 | 00:28:20 | 2 | 02:38:20
2999 | 15719 | Caroline | Campbell | AUS | 943 | 00:45:21 | 00:02:06 | 01:28:38 | 00:01:46 | 00:27:24 | 3 | 02:45:15
2999 | 8168 | Janice | Nicklas | USA | 942 | 01:10:05 | 00:03:53 | 01:23:11 | 00:03:15 | 00:40:14 | 4 | 03:20:37
Spreadsheet: 844549d1696336532-total-add-with-text-test
Sheet: Sheet3

Date | Milk | [NAME] | Tea Power | Sugar | Biscuts | Water
2023-09-01 00:00:00 | 11 L | 3 PKT | 2 PKT | 2 KG
2023-09-02 00:00:00 | NIL | NIL | NIL | NIL
2023-09-03 00:00:00 | NIL | NIL | NIL | NIL
2023-09-04 00:00:00 | 9 L | 3 PKT | 2 PKT | NIL
2023-09-05 00:00:00 | 10 L | 3 PKT | 2 PKT | 2 KG
2023-09-06 00:00:00 | 6 L | 2 PKT | 1 PKT | NIL
2023-09-07 00:00:00 | 8 L | 3 PKT | 2 PKT | NIL
Spreadsheet: 859623d1707945812-cell-has-a-finance-charge-that-needs-to-be-split-by-a-range-of-cells-sample-finance-charge
Sheet: Branch & Div Amount

Branch / Division | Monthly Amount
Beaumont
Beaumont - Industrial Services
Beaumont - T&D
Corpus Christi | 912.2
Corpus Christi - Environmental | 23554.67
Corpus Christi - Industrial Services
Corpus Christi - Mechanical | 3269.79
Corpus Christi - Soft Crafts | 1951.31
Corpus Christi - T&D
Corpus Christi - Turnaround
Houston
Houston - Corporate | 2197.39
Houston - Environmental
Houston - Industrial Services | 6820.18
Houston - Mechanical | 399.71
Houston - Sample Shipping | 779.64
Houston - Soft Crafts
Houston - T&D
Houston - Tank Cleaning | 3361.26
Houston - Vapor Control
[NAME] | 1119.03
Sulphur - Industrial Services
Sulphur - T&D
PERIOD TOTAL
Reactivation Fee | 50
Finance Charge | 7943.2
Spreadsheet: 109643d1306438166-count-unique-values-in-one-column-given-multiple-criteria-for-other-columns-unique-example
Sheet: Sheet1

1 | 4 | 3 | h
1 | g | 3 | y |  |  | Col B | Col C | Col D
1 | d | 3 | h |  |  | g | 3 | y
 | d |  | h
cat | 4 | 3 | h |  |  | Unique
4 | 3 | 2 | h
6 | 5 | 2 | h
2 | g | 2 | h
[NAME] | d | 2 | y
1 | 2 | 3 | y
2 | 1 | 3 | y
1 | 6 | 3 | y
cat | g | 3 | y
 | g | 3 | c
4 | d | 2 | c
6 | 0 | 2 | c
2 | -1 | 2 | c
[NAME] | 7 | 2 | c
cat | g | 3 | y
Spreadsheet: 53741d1253654593-general-ledger-template-general-ledger-wilverley
Sheet: Petty Cash

G/L Code | Date | Authoriser | Deposit | Withdrawel | Running Balance | Payee\Company Name | Description | Input Date | [NAME]
10 | 2009-01-01 00:00:00 | [NAME] | 1000 |  |  |  | Top Up Funds | 2009-01-01 00:00:00
10 | 2009-01-01 00:00:00 | M Harris |  | 100 |  | Schuh | New Shoes | 2009-01-01 00:00:00
10 | 2009-01-01 00:00:00 |  |  | 10
10 | 2009-01-01 00:00:00 |  |  | 100
10 | 2009-02-01 00:00:00 |  | 100
11 | 2009-01-01 00:00:00 |  | 100
Spreadsheet: 47865d1247036883-sorting-non-unique-rows-of-data-into-another-worksheet-example
Sheet: 110

Account | ID# | Src | Date | Memo/Payee | Debit | Credit | Code | Job No. | Job Name
01 | ID-2 | GJ | 1/2/2009 |  | 300 |  | 110
01 | ID-2 | GJ | 1/2/2009 |  | 300 |  | 110
01 | ID-2 | GJ | 1/2/2009 |  | 234 |  | 110
01 | ID-2 | GJ | 1/2/2009 |  | 234235 |  | 110
01 | ID-2 | GJ | 1/2/2009 |  | 534 |  | 110
Spreadsheet: 478721d1473012860-formula-for-joining-2-sheets-of-standings-classifica
Sheet: Calendario

 | [NAME] | Giornate |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Goal
 |  | 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
 | Matteo | 1
 | [NAME]
 | [NAME] | 2
 | Lorenzo
 | Alberto | 1
 | Giammarco | 3
 | [NAME]
 | Totali gol per giornata
Spreadsheet: 60dc6623-2ca8-4b2d-8dde-31cbeec7030a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | USD 428 | Unnamed: 5 | Unnamed: 6
 |  |  |  | Great Bend, KS
Test security and student confidentiality are of utmost importance to USD 428. As a participant in
providing the Read Aloud Accommodation, you have access to materials/information that must be
kept secure. Please treat all materials, including assessment information displayed electronically,
as confidential. You are asked not to reproduce any materials, directly or indirectly, and not to
disclose the content of these materials. USD 428 takes pride in ensuring equity for all students.
Therefore, please do not put any Kansas student at any unfair advantage by sharing information with
others. We are certain that you share our concern that all potential assessment material be
handled in a professional, secure, and confidential manner; and we ask your adherence to these
guidelines by signing below.
Participant Name (please print)_____________________________
Participant Signature_____________________________________ |  |  |  |  |  | Date___________
Check Out |  |  |  | Check In
Date | Time | Checked out by |  | Date | Time | Checked in by
Shredded by:                                                    Date:
Check Out |  |  |  | Check In
Date | Time | Checked out by |  | Date | Time | Checked in by
Shredded by:                                                    Date:
Check Out |  |  |  | Check In
Date | Time | Checked out by |  | Date | Time | Checked in by
Shredded by:                                                    Date:
Check Out |  |  |  | Check In
Date | Time | Checked out by |  | Date | Time | Checked in by
Shredded by:                                                    Date:
Check Out |  |  |  | Check In
Date | Time | Checked out by |  | Date | Time | Checked in by
Shredded by:                                                    Date:
Original copy to remain in building and one copy sent to Curriculum Director
Spreadsheet: 4366faee-2916-441d-9252-ddde780455a1
Sheet: Sheet1

Unnamed: 0 | Policy Recommendation Implementation Plan | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Policy #
 | Policy Recommendation:
 | Implementation Method:
 | Timeframe for Implementation:
 | PRIORITY:   (1 to 10, 1 being highest)
 | Implementation Mechanism:
 | Public Education Component (Y/N):
 | Estimated Benefit:
 | Water Savings ([NAME]):
 | Cost Savings:
 | Other:
 | Financial Impact (Y/N)
 | Cost Areas
 | Total Estimated Cost:
 | TASKS | Start | Duration (days) | Staff Time (hours) | Non-budgeted Costs
1
2
3
4
5 | TOTAL |  |  |  | 0
 | FY 2004 Cost: | 0
 | FY 2005 Cost: | 0
 | FY 2006 Cost: | 0
Spreadsheet: 83958d1283973508-excel-2007-transferring-cell-properties-across-sheets-with-live-updates-milk-book
Sheet: CustomersLiveWeeklyView

Address | Type |  | Monday | Wednesday | Friday | Total | Weekly bill
1 [NAME] | 1L ss |  | 1 | 3 | 2
3 Pusti Ave | 2L pas |  | 1 | 0 | 1
 | 1p OJ |  | 1 | 0 | 2
5 Twat Close | 1L ss org |  |  | 2 | 3
Spreadsheet: 329420d1404307948-show-data-from-cell-if-it-includes-a-certain-number-template-excel
Sheet: Sheet1

10003 | 9
10016 | 6
10019 | 10
10021 | 10
10022 | 10
10023 | 8
10027 | 9
10039 | 10
10040 | 10
10045 | 10
10047 | 10
10048 | 9
10049 | 8
10052 | 6
10056 | 10
10057 | 9
10059 | 10
10067 | 10
10068 | 10
10077 | 7
10087 | 9
10089 | 8
10096 | 8
10102 | 7
10106 | 9
10107 | 8
10109 | 10
10110 | 8
10113 | 7
10117 | 8
10119 | 10
Spreadsheet: 542313d1507805698-formatting-latitude-and-longitude-numbers-s666-sandbox-sheet-latlong-diff
Sheet: Worksheet

 | latitude | longitude | Cleansed latitude | Cleansed longitude
[NAME] | 515252891 | -0.3194179 | 5152530662 | -0.3193723
Loc2 | 51.4937169 | -0.1922681 | 51.49370229 | -0.19223323
Loc3 | 51.4616404 | -0.11585 | 51.46162452 | -0.11573601
Loc4 | 559492892 | -32180392 | 55.94930497 | -3.21805529
Loc5 | 55.9492892 | -3.2180392 | 55.94929521 | -3.21800433
Loc6 | 51.4833781 | -0.1856391 | 51.48338395 | -0.18564044
Loc7 | 51.4868038 | -0.2814827 | 51.48681549 | -0.28146929
Loc8 | 51.493007 | -0.2361278 | 51.49276652 | -0.23609293
Loc9 | 51.48033 | -0.258152 | 51.492753 | -0.23610961
Loc10 | 51.429274 | -0.170543 | 51.42927985 | -0.17053629
Loc11 | 51.4926399 | -0.1935221 | 51.49264449 | -0.19355227
Loc12 | 51.591244 | -0.0063247 | 51.59122984 | -0.0063475
Loc13 | 51.5083203 | -0.2061731 | 51.50972759 | -0.20679805
Loc14 | 53.64127 | -1.7977349 | 53.64120481 | -1.79791997
Loc15 | 51.6495303 | -0.0513738 | 51.64954777 | -0.05144354
Loc16 | 51.424418 | -0.334577 | 51.424418 | -0.334577
Loc17 | 50.5556074 | -3.5041805 | 50.55599508 | -3.50322161
Loc18 | 51.540692 | -1.915547 | 51.54067865 | -1.91552018
Loc19 | 51.5064885 | -0.1462095 | 51.5064885 | -0.1462095
Loc20 | 51.4922815 | -0.1922825 | 51.49227065 | -0.19235492
[NAME] | 50.7125814 | -1.9746151 | 50.71255338 | -1.9745239
[NAME] | 53.117281 | -2.798331 | 53.10489659 | -2.77811787
Loc23 | 51.4157273 | -0.3790132 | 51.4157273 | -0.3790132
Loc24 | 51.4620218 | -0.2257446 | 51.46363272 | -0.2298913
Loc25 | 52.74713 | 0.4357897 | 52.74712351 | 0.43618398
Loc26 | 51.5306325 | -0.0935696 | 51.53058077 | -0.09363666
Spreadsheet: 99383d1298023882-copy-and-paste-to-another-tab-main-stock-list
Sheet: Order Sheet 

Description | Qty
Starfish | 2
Fizzy Twin Cherries | 5 |  |  | I would want these to appear here based on the entries on the main list sheet
Spreadsheet: 177946d1346550600-need-help-with-a-table-and-finding-the-last-row-sample-2
Sheet: Sheet1

 |  |  |  | FT | In | Qt |  |  |  | FT | In | Qt |  |  | FT | In | Qt
 |  |  | Yesterday | 13 | 5 | 2 |  |  | Yesterday | 13 | 9 | 2 |  | Yesterday | 13 | 1 | 2
 |  |  | Ticket 1 Top | 13 | 5 | 1 |  |  | Ticket 1 Top |  |  |  |  | Ticket 1 Top | 13 | 2 | 2
 |  |  | Ticket 1 Bottom | 3 | 6 |  |  |  | Ticket 1 Bottom |  |  |  |  | Ticket 1 Bottom | 3 | 6
 |  |  | Ticket 2 Top |  |  |  |  |  | Ticket 2 Top |  |  |  |  | Ticket 2 Top | 14 | 0 | 1
 |  |  | Ticket 2 Bottom |  |  |  |  |  | Ticket 2 Bottom |  |  |  |  | Ticket 2 Bottom | 4 | 3
 |  |  | Today |  |  |  |  |  | Today |  |  |  |  | Today | 4 | 3
 |  |  |  | Answer |  |  |  |  |  | Answer |  |  |  |  | Answer
 |  |  |  | 3 | 6 | 0 |  |  |  | 13 | 9 | 2 |  |  | 4 | 3 | 0
Spreadsheet: 864170d1711460315-list-of-customers-with-products-ordered-map1
Sheet: customer list

week | 15
customer | bike A |  | Bike B
 | big | small | big | small
 | 0 | 2 | 4 | 0
customer b | 0 | 0 | 0 | 0
customer c | 0 | 0 | 5 | 0
[NAME] | 0 | 3 | 4 | 0
Spreadsheet: 0ae7e2ec-5471-4c51-9dfb-54ed026903a6
Sheet: Offsets

Offset cost estimates |  | Estimates made in Nov. 2009 by [NAME]
Information from Green Power Network, US DOE, October 2009:
Retail GHG Offset Products:  $3 to $20 per MT CO2e
Retail REC (Renewable Electricity Credit) Products:  $7 to $34 per MT CO2e ($0.004 to $0.02 per KWh, multiply by ca. 1,700 KWh/MT CO2e)
Note: costs are for residential; larger commercial buyers could negotiate lower premiums
UWO Campus Energy Independence Study, Dec. 2008:
Table 2-3, pg 2-7: 2007 electricity cost was $0.055 per KWh (11% REC)
[NAME], Pg G3: model assumes renewable energy cost is $0.08 per KWh
Therefore, a $0.03 per KWh premium, which = $51 per MT CO2e
BUT: recommendatios call for $190,000/yr to get to 100% REC
REC was 13% at time of study, therefore $190,000 for 87% of 30,000,000 KWh = $0.0073 per KWh premium = $12.40 per MT CO2e
source | 2008 GHG | Cost for offsets or REC in $ per MT CO2e averted
 | MT CO2e | 3 | 5 | 10 | 20 | 30 | 50
electricity | 18000
heating | 18000
commuting | 6000
other | 1000
TOTAL
Spreadsheet: 0268e56d-5d3b-4893-8a66-beaa9a99bb88
Sheet: Polycom Soundstation 

Vendor Information
 | AT&T |  |  | Address: 12851 [NAME], St. Louis, MO 63131 |  |  | Contact Name: [NAME]
Phone number:         [PHONE] |  |  | Fax number:  NA |  |  |  | Email: [EMAIL]
CLIN | Services Offered | Geographic Area Served | MINUS 10%   Month To Month | Month To Month | One-Time Installation Price | MINUS 10% One-Time Installation Price | Service Pricing Notes |  | Tariff
 | [NAME]
PC 16000 | Polycom Soundstation2 non-expandable Part #2200-16000-001 | Kansas / Missouri | N/A | N/A |  | 381.3 |  |  | N/A
PC 16200 | Polycom Soundstation2 expandable (w/o mics) Part # 2200-16200-001 | Kansas / Missouri | N/A | N/A |  | 449.06 |  |  | N/A
PC 16155 | Polycom Soundstation2 External Microphones Part #2200-16155-001 | Kansas / Missouri | N/A | N/A |  | 128.74 |  |  | N/A
 | Wireless
PC 07880 | Polycom Soundstation2W non- expandable Part #2200-07880-001 | Kansas / Missouri | N/A | N/A |  | 455.22 |  |  | N/A
PC 07840 | Polycom Soundstation2W expandable (w/o mics) Part #2200-07840-001 | Kansas / Missouri | N/A | N/A |  | 578.42 |  |  | N/A
PC 07800 | Polycom Soundstation2W External Microphones Part # 2200-07800-160 | Kansas / Missouri | N/A | N/A |  | 128.74 |  |  | N/A
Spreadsheet: 182320d1348424297-how-to-calculate-totals-by-page-break-when-printing-forum-sample
Sheet: Sheet1

State | Customer | Code | 2012-09-01 00:00:00 | 2012-09-02 00:00:00 | 2012-09-03 00:00:00 | 2012-09-04 00:00:00 | 2012-09-05 00:00:00 | 2012-09-06 00:00:00 | 2012-09-07 00:00:00 | 2012-09-08 00:00:00 | 2012-09-09 00:00:00 | 2012-09-10 00:00:00 | Totals
AL | a | 5xxx | x | x |  | x | x |  | x | x |  | x
 | b | 3xxx | x | x | x | x | x | x | x | x | x | x
 | c | 1xxx | x | x |  | x | x |  | x | x |  | x
 | d | 5xxx |  | x | x |  | x | x |  | x | x | x
 | e | 3xxx |  | x | x |  | x | x |  | x | x | x
 | f | 1xxx |  | x | x |  | x | x |  | x | x | x
 | g | 5xxx | x | x |  | x | x |  | x | x |  | x
 | h | 3xxx |  | x | x |  | x | x |  | x | x | x
 | i | 1xxx |  | x | x |  | x | x |  | x | x | x
 | j | 5xxx |  | x | x |  | x | x |  | x | x | x
 | k | 3xxx | x | x | x | x | x | x | x | x | x | x
 | l | 1xxx |  | x | x |  | x | x |  | x | x | x
 | m | 5xxx |  | x |  |  | x |  |  | x |  | x
NC | a | 5xxx |  | x | x |  | x | x |  | x | x | x
 | b | 3xxx |  | x | x |  | x | x |  | x | x | x
 | c | 1xxx | x | x | x | x | x | x | x | x | x | x
 | d | 5xxx |  | x |  |  | x |  |  | x |  | x
 | e | 3xxx |  | x | x |  | x | x |  | x | x | x
 | f | 1xxx |  | x |  |  | x |  |  | x |  | x
 | g | 5xxx |  | x |  |  | x |  |  | x |  | x
 | h | 3xxx |  | x |  |  | x |  |  | x |  | x
 | i | 1xxx |  | x |  |  | x |  |  | x |  | x
 | j | 5xxx | x | x |  | x | x |  | x | x |  | x
 | k | 3xxx |  | x |  |  | x |  |  | x |  | x
 | l | 1xxx |  | x |  |  | x |  |  | x |  | x
 | m | 5xxx |  | x |  |  | x |  |  | x |  | x
TN | a | 5xxx |  | x |  |  | x |  |  | x |  | x
 | b | 3xxx |  | x | x |  | x | x |  | x | x | x
 | c | 1xxx |  | x | x |  | x | x |  | x | x | x
 | d | 5xxx | x | x | x | x | x | x | x | x | x | x
 | e | 3xxx |  | x | x |  | x | x |  | x | x | x
 | f | 1xxx |  | x | x |  | x | x |  | x | x | x
 | g | 5xxx |  | x | x |  | x | x |  | x | x | x
 | h | 3xxx | x | x | x | x | x | x | x | x | x | x
 | i | 1xxx |  | x |  |  | x |  |  | x |  | x
 | j | 5xxx |  | x |  |  | x |  |  | x |  | x
 | k | 3xxx |  | x |  |  | x |  |  | x |  | x
 | l | 1xxx | x | x |  | x | x |  | x | x |  | x
 | m | 5xxx |  | x |  |  | x |  |  | x |  | x
 | n | 5xxx |  | x |  |  | x |  |  | x |  | x
 | o | 3xxx |  | x |  |  | x |  |  | x |  | x
 | p | 1xxx |  | x |  |  | x |  |  | x |  | x
 | q | 5xxx | x | x |  | x | x |  | x | x |  | x
 | r | 3xxx |  | x |  |  | x |  |  | x |  | x
Total Orders |  | 5
by Code |  | 3
 |  | 1
Grand Total Orders