tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 884328d1733416949-conditional-adding-example_4
Sheet: Sheet1

Pair | Buy price | Size | Reserve
EURUSDTSHORT 16 | 6970.15924060414 | 732537.3
Add Reserve |  | 12153.28
EURUSDTLONG 20 | 7268.15279022877 | 708057.36
EURUSDTLONG 20 | 7446.54696768 | 737361.33
Add Reserve |  | 2114.03
EURUSDTLONG 20 | 8045.55126290948 | 1039588.44
Add Reserve |  | 96.78
EURUSDTLONG 20 | 8025.35258067907 | 1081895.74
Add Reserve |  | 589.56
EURUSDTLONG 12 | 8404.83306199336 | 709289.86
Add Reserve |  | 3128.24
EURUSDTLONG 20 | 8957.96784322828 | 1304639.74
EURUSDTSHORT 10 | 8640.86612497366 | 729218.57
Add Reserve |  | 399.08
EURUSDTLONG 10 | 8726.38974294753 | 741405.14
Add Reserve |  | 6765.54
EURUSDTLONG 24 | 9456.61284334023 | 2064336.08
EURUSDTSHORT 23 | 9262.93194490644 | 2091009.97
Add Reserve |  | 684.58
EURUSDTLONG 20 | 9394.79264656037 | 1928936.82
Add Reserve |  | 18102.94
EURUSDTSHORT 21 | 9997.07847676397 | 3056131.82
EURUSDTLONG 11 | 10251.7072986215 | 1805862.71
EURUSDTSHORT 11 | 9541.267034273 | 1850500.38
Add deposit |  | 44034.07
EURUSDTSHORT 19 | 9556.97402369288 | 2574577.56
Add Reserve |  | 72091.87
EURUSDTLONG 12 | 9095.8577753263 | 2609341.04
EURUSDTSHORT 20 | 8954.70146689864 | 4091802.3
Add Reserve |  | 50946.34
EURUSDTSHORT 14 | 7652.46242478179 | 5859823.21
Add deposit |  | 123038.22
EURUSDTSHORT 11 | 7615.79195159953 | 3940991.73
Add Reserve |  | 391380.37
Out |  | 1224068.03
Spreadsheet: 874470d1721062975-spill-error-on-excel-table-spill-error
Sheet: Transactions

 |  | Date | Bank / Cash | Details | I.D Number | Name | Amount
 |  | 2024-01-01 00:00:00 | Bank | Sales | CT 275 | [NAME] | 100
 |  | 2024-01-01 00:00:00 | Bank | Sales | CT 408 | [NAME] | 400
 |  | 2024-01-01 00:00:00 | Cash | Sales | CT 233 | [NAME] | 300
 |  | 2024-01-01 00:00:00 | Bank | Sales | CT 180 | Smith | 50
 |  | 2024-01-01 00:00:00 | Cash | Sales | CT 002 | [NAME] | 130
 |  | 2024-01-01 00:00:00 | Cash | Sales | CT 275 | [NAME] | 200
 |  | 2024-01-01 00:00:00 | Bank | Sales | CT 420 | [NAME] | 100
 |  | 2024-01-01 00:00:00 | Cash | Sales | CT 004 | [NAME] | 500
 |  | 2024-01-01 00:00:00 | Cash | Sales | CT 180 | Smith | 300
 |  | 2024-04-02 00:00:00 | Bank | Sales | CT 200 | [NAME] | 120
Spreadsheet: 845441d1696958058-pivot-with-multiple-tabs-as-range-forecasts-and-orders-10102023
Sheet: BIO

Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI |  | Order Date | PO | Description | Item Code | Qty
[NAME] BTL | 08900 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-08-07 00:00:00 | 297416 | [NAME] BTL | 08900 | 5 | ** Production Issues
BIOLYTE CITRUS 12/16Z BTL | 08899 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BIOLYTE CITRUS 12/16Z BTL | 08899 | 6
BIOLYTE MELON 12/16Z BTL | 09573 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BIOLYTE TROPIC 12/16Z BTL | 08901 | 8
BIOLYTE TROPIC 12/16Z BTL | 08901 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BIOLYTE PUNCH 12/16Z BTL | 10727 | 1
BIOLYTE PUNCH 12/16Z BTL | 10727
Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI
[NAME] BTL | 08900
BIOLYTE CITRUS 12/16Z BTL | 08899
BIOLYTE MELON 12/16Z BTL | 09573
BIOLYTE TROPIC 12/16Z BTL | 08901
BIOLYTE PUNCH 12/16Z BTL | 10727
Spreadsheet: 158347d1338196757-excel-vlookup-issue-skatcb_testsetup-3-_27may12_02
Sheet: Sheet1

 |  |  |  | Size | 54" 11.9'
Name | CH | LF | OP | Pan | Net Pan | Yds
WC-q | 8 | 453 | 1 | 34.84615384615385 | 35 | 95.45454545454545
 |  |  |  | note since all these values are the same the result will never change
Size | Result | Result2 | Factor
54" 8' | 4.333 | /11*30 | 0.3666666666666666
54" 9' | 4.333 | /9*30 | 0.3
54" 10' | 4.333 | /8*30 | 0.2666666666666667
54" 11' | 9 | /11*30 | 0.3666666666666666
54" 11.5' | 11 | /9*30 | 0.3
54" 11.9' | 13 | /8*30 | 0.2666666666666667
55" | 15 | /11*30 | 0.3666666666666666 |  | any time you want to add another row to this table,
56" | 17 | /9*30 | 0.3 |  | drag this little arrow down one row and then fill details for the new record,
57" | 19 | /8*30 | 0.2666666666666667 |  | or add a new row of record just below the last record of the table,
 |  |  |  |  | the table will automatically expand.
 |  |  |  |  | now, the SIZE Data Validation (cell F2) will automatically show new values.
 |  |  |  |  | the VLOOKUP will automatically accommodate the new records
 |  |  |  |  | start off by creating a Named [NAME] (in this case, SIZELIST) using the following syntax:
 |  |  |  |  | any new record added to the table automatically expands the table-size and thence the Named Range.
 |  |  |  |  | this Named [NAME] is used in cell F2.
Spreadsheet: 8b894d42-e3bd-4eff-84c3-e632456407ab
Sheet: Sheet1

[NAME] | Unnamed: 1
Quelle: http://ergebnisse.vimentis.ch/
Frage:
Ich bin bereit, länger zu arbeiten, damit meine [NAME] ist.
 | Kanton / Region
Antwort
Ja
Neutral / Weiss nicht
[NAME]
Regionen
Im [NAME] 2011 sind die [NAME] folgendermassen zusammengesetzt: NWS: JU, NE  NOS: TG, SH  OS: SG, AI, AR  SOS: GL, GR  ZS: UR, NW, OW, ZG
Angaben zu den [NAME]
Erhebungsjahr | 2011
Stichprobengrösse | 30565
Erhebungszeitraum | 05.11.2011 bis: 30.12.2011
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: richard_shapiro__32183__dc-headcount
Sheet: Sheet1

Enron Government Affairs - The Americas Cost Center 100042 - Robertson
2001-2003 OPERATING & STRATEGIC PLAN
Headcount Summary
 |  |  |  |  |  | Estimated |  | Year End Plan
 |  |  |  |  |  | 12/31/00 |  | 2001 |  | 2002 |  | 2003
Domestic Employees
 | Full Time |  |  |  |  | 10.5 |  | 21.5 |  | 24.5 |  | 24.5
 | Part Time
 | Temporary |  |  |  |  | 1 |  | 1 |  | 1 |  | 1
 | VOE / Student Learners
 | Open Positions
 |  | Total Employees
 | 3rd Party Contract |  |  |  |  | 1 |  | 1 |  | 1 |  | 1
 | Total
International Employees
 | Full Time
 | Part Time
 | Temporary
 | VOE / Student Learners
 | Open Positions
 |  | Total Employees
 | 3rd Party Contract
 | Total
Total Domestic & International
 | Full Time
 | Part Time
 | Temporary
 | VOE / Student Learners
 | Open Positions
 |  | Total Employees (1)
 | 3rd Party Contract (2)
 | Total  *
Location of Total Employees (1)
 | Domestic
 |  | 1400 Smith |  |  |  |  |  | 1 |  | 1 |  | 1
 |  | [NAME]
 |  | Omaha
 |  | Other |  |  |  | 11.5 |  | 21.5 |  | 24.5 |  | 24.5
 | Expatriates
 | International
 | Total
Location of 3rd Party Contractors (2)
 | Domestic
 |  | 1400 Smith
 |  | [NAME]
 |  | Omaha
 |  | Other |  |  |  | 1 |  | 1 |  | 1 |  | 1
 | Expatriates
 | International
 | Total
Total Employees by Location *
 | * Totals should tie.
Spreadsheet: 543905d1508664747-powerpivot-not-working-as-intended-question
Sheet: Buildings-Teams

Building ID | Building Name | Team ID | Team Name
BID001 |  | TID001 | Blue
BID001 |  | TID003 | Yellow
BID001 |  | TID001 | Blue
[NAME] |  | TID002 | Red
[NAME] |  | TID001 | Blue
BID003 |  | TID001 | Blue
BID003 |  | TID003 | Yellow
BID003 |  | TID002 | Red
Spreadsheet: robin_rodrigue__33295__P&LSum2001
Sheet: Recon to Houston

RECONCILATION TO HOUSTON REPORTED P&L
 |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
BY RISK TYPE:
Total Term
Total Cash
TOTAL CANADA
As reported by Houston
Difference
Spreadsheet: 704873d1605790743-editing-weekly-monthly-assignment-template-project-tracker-test-ans
Sheet: Input

 |  | Submission Deadlines Tracker |  |  |  |  |  | Color Codes
 |  | [NAME] | Category | Activity | Deadline |  |  |  | [NAME]
 |  |  |  |  | Latest | R0 |  |  | [NAME]
 |  | Test 1 | [NAME] | [NAME] | 2020-11-02 00:00:00
 |  | Test 2 | [NAME] | [NAME] | 2020-11-16 00:00:00
 |  | Test 3 | [NAME] | [NAME] | 2020-11-26 00:00:00 | 2020-11-16 00:00:00
 |  | Test 4 | [NAME] | [NAME] | 2020-11-08 00:00:00
 |  | Test 5 | [NAME] | Last Day of Bid Q&A | 2020-11-30 00:00:00
 |  | Test 5 | [NAME] | Bid Closing Date | 2020-12-17 00:00:00
 |  | Test 6 | [NAME] | Last Day of Bid Q&A | 2020-11-23 00:00:00
 |  | Test 8 | [NAME] | Bid Closing Date | 2020-12-13 00:00:00
 |  | Test 9 | [NAME] | Contractual Qual, HSE Exceptions & Tender | 2020-11-05 00:00:00 | 2020-10-29 00:00:00
 |  | Test 10 | [NAME] | [NAME] (Hard Copy) | 2020-11-09 00:00:00
 |  | Test 11 | [NAME] | 1st Tech Bid Submission | 2020-11-24 00:00:00 | 2020-11-05 00:00:00
 |  | Test 12 | [NAME] | [NAME] Tech Clarifications | 2020-12-01 00:00:00 | 2020-11-14 00:00:00
 |  | Test 13 | [NAME] | 2nd Tech Bid Submission | 2020-12-10 00:00:00
 |  | Test 14 | [NAME] | [NAME] | 2021-01-10 00:00:00
 |  | Test 15 | [NAME] | Contractual Qual, HSE Exceptions & Tender | 2020-11-05 00:00:00 | 2020-10-29 00:00:00
 |  | Test 15 | [NAME] | [NAME] (Hard Copy) | 2020-11-09 00:00:00
 |  | Test 17 | [NAME] | 1st Tech Bid Submission | 2020-11-24 00:00:00 | 2020-11-05 00:00:00
 |  | Test 18 | [NAME] | [NAME] Tech Clarifications | 2020-11-24 00:00:00 | 2020-11-14 00:00:00
 |  | Test 19 | [NAME] | 2nd Tech Bid Submission | 2020-12-10 00:00:00
 |  | Test 20 | [NAME] | [NAME] | 2020-12-10 00:00:00
Spreadsheet: 819728d1677668590-higlight-text-with-certain-parts-in-a-cell-eh_cf-text-with-colon
Sheet: Sheet2

Category: Amb- Continental Meats Definer: Amb Cnti- Jerky COP: Whole G4U: Beef | 1
Category: Amb- Continental Meats Definer: Amb Cnti- Other Ssg COP: Whole G4U: Pork | 1
Category: Amb- Continental Meats Definer: Amb Cnti- Pepperami COP: Whole G4U: Beef | 3
Category: Amb- Continental Meats Definer: Amb Cnti- Pepperami COP: Whole G4U: Pork | 20
Category: Chilled- Continental Meats Definer: Chl Cnti- Peperami COP: Roll G4U: Pork | 1
Category: Chilled- Finger Fd/Snack Definer: [NAME] -Brd/Btd COP: Fillet - Breast G4U: Chicken | 2
Category: Chilled- Finger Fd/Snack Definer: [NAME] -Brd/Btd COP: [NAME] G4U: Chicken | 1
Category: Chilled- Finger Fd/Snack Definer: [NAME] -Brd/Btd COP: Pieces - Chunks G4U: Chicken | 9
Category: Chilled- Finger Fd/Snack Definer: [NAME] -Unctd COP: Pieces - Chunks G4U: Chicken | 69
Category: Chilled- Finger Fd/Snack Definer: [NAME]: [NAME] G4U: Chicken | 109
Category: Chilled- Finger Fd/Snack Definer: [NAME]: [NAME] G4U: Duck | 1
Category: Chilled- Finger Fd/Snack Definer: [NAME]: [NAME] G4U: Mixed Meat Incl Chicken | 3
Category: Chilled- Finger Fd/Snack Definer: [NAME] COP: Not Applicable G4U: Chicken | 2
Category: Chilled- Finger Fd/Snack Definer: [NAME] COP: Not Applicable G4U: Pork | 1
Category: Chilled- Finger Fd/Snack Definer: [NAME] COP: Pieces - Chunks G4U: Chicken | 2
Category: Chilled- Finger Fd/Snack Definer: [NAME] COP: Pieces - Chunks G4U: Turkey | 1
Category: Chilled- Finger Fd/Snack Definer: [NAME] COP: Not Applicable G4U: Chicken | 3
Category: Chilled- Finger Fd/Snack Definer: [NAME] COP: Not Applicable G4U: Pork | 1
Category: Chilled- Ml Cntr Chicken Definer: [NAME] Ckn- Bites -Brd/Btd COP: Pieces - Chunks G4U: Chicken | 17
Category: Chilled- Ml Cntr Chicken Definer: [NAME] Ckn- Bites -Unctd COP: Pieces - Chunks G4U: Chicken | 8
Category: Chilled- Ml Cntr Chicken Definer: [NAME] Ckn- Diced COP: Pieces - Chunks G4U: Chicken | 2
Category: Chilled- Ml Cntr Chicken Definer: [NAME] Ckn- Finger -Brd/Btd COP: Not Applicable G4U: Chicken | 1
Category: Chilled- Ml Cntr Chicken Definer: [NAME] Ckn- Pops COP: Pieces - Chunks G4U: Chicken | 2
Category: Chilled- Ml Cntr Chicken Definer: [NAME] Ckn- Shapes COP: Not Applicable G4U: Chicken | 2
Category: Chilled- Ml Cntr Chicken Definer: [NAME] Ckn- Shapes COP: Pieces - Goujons G4U: Chicken | 1
Category: Chilled- Ml Cntr Chicken Definer: [NAME] Ckn- Shapes COP: Pieces - Strips G4U: Chicken | 1
Category: Chilled- Ml Cntr Turkey Definer: [NAME] Tky- Bites -Unctd COP: Pieces - Chunks G4U: Turkey | 1
Category: Frozen- Finger Fd/Snack Definer: Frz Fngr- Kbb/Skwr/Satay COP: [NAME] G4U: Chicken | 23
Category: Frozen- Finger Fd/Snack Definer: Frz Fngr- Other COP: [NAME] G4U: Chicken | 1
Category: Frozen- Ml Cntr Chicken Definer: Frz MC Ckn- Bites -Brd/Btd COP: Pieces - Chunks G4U: Chicken | 3
Category: [NAME]: [NAME] In Mrnd COP: Meatballs G4U: Pork | 1
Category: Frsh Pltry- Chicken AV Definer: [NAME] Ckn- In Mrnd COP: Meatballs G4U: Chicken | 3
Category: Frsh Pltry- Chicken AV Definer: [NAME] Ckn- In Mrnd COP: Portions - Drumsticks G4U: Chicken | 1
Spreadsheet: 269974d1381336603-help-with-an-special-weighted-average-formula-ebitda-3
Sheet: Sheet1

 | Impact | $ 50,000 | $ 30,000 | $ 20,000 | $ 100,000
 | Weight | 0.5 | 0.3 | 0.2
 |  | Strat1 | Strat2 | Strat3 | Avg
 | Manager 1 | 3.5 | 2 |  |  |  | SUMPRODUCT($C$2:$E$2,C5:E5)
 | Manager 2 |  | 4 | 2.5
 | Manager 3 |  | 3
Spreadsheet: 54901d1254942741-comparing-two-sets-of-data-spelling-and-reading
Sheet: Sheet1

Reading and Spelling Tests (Sept 09/Oct 09) |  |  |  | 01/10/2009 results |  | Difference in years and months
 | Surname | First name | age as October 2009 | Reading | Spelling | Reading | Spelling
 | west | Leah | 12.5 | 9.8 | 9.3
 | riddles | [NAME] | 12.11 | 12.6 | 12.8
 | tyson | Shona | 11.2 | 7.5 | 6.3
 | yeilders | [NAME] | 11.2 | 8.2 | 7.1
Spreadsheet: 177d7533-44e0-407b-be24-f1f7e11fb494
Sheet: Sheet1

TEXAS HIGHER EDUCATION COORDINATING BOARD | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Fiscal Year 2012 Report on Optional Retirement Program Participation
INSTRUCTIONS
1. | Enter your institution's name in this box:
 | (Name will be auto-completed on Pages 1 - 4.)
2. | Fill in data requested in yellow boxes/blue lines in accordance with instructions provided on each page.
 | (Some fields will be auto-completed, such as calculations of totals.)
3. | FUNDING SOURCE  (Page 1):
 | Universities, health-related institutions, state colleges and technical colleges that received General Revenue-Dedicated funds (e.g., tuition and fees) during FY12 should report some amount of employer contributions in the "Other E&G" category (does not apply to community colleges).  See Appendix A for definitions of each fund.
4. | COMMENTS:
 | Use the "Comments" sections for explanations or additional information.
5. | ELECTRONIC SUBMISSION:
 | Send completed Excel form by email to: | [NAME] | by November 1, 2012.
6. | CERTIFICATION  (Page 3--Part A Cert and Page 4--Part B Cert):
 | Preferred: Submit a scanned image of your signed Pages 3 & 4 to the email address in #5 above.
 | OR:  Fax Pages 3 & 4 to (512) 427-6510.
 | OR:  Mail hard copy of Pages 3 & 4 to: | Optional Retirement Program
 |  | Texas Higher Education Coordinating Board
 |  | P.O. Box 12788
 |  | [NAME]
7. | ATTACHMENTS:
 | Submit the following items by email to the address in #5 above.
 | (If not available electronically, submit scan, fax, or hard copy as described in #6 above.)
 | [NAME] of your institution's ORP companies that were authorized during FY12   (Page 3, item #4)
 | [NAME] of your institution's ORP-eligible positions during FY12   (Page 4, item #2)
8. | DUE DATE:   November 1, 2012
 | Don't delay submitting Part A (Pages 1 - 3) if Part B (Page 4) is not ready.
 | Part B can be submitted separately. An Excel file with Part B only is available for this purpose.
QUESTIONS?
 | Call Carri Whitfield at (512) 427-6191 or send an email to the address in #5 above.
Spreadsheet: 730379d1619681381-extracting-and-arranging-data-salary-1-ans-3
Sheet: Data

 | [NAME] (Salary) |  |  |  |  | JVN0711 | 3821.45
 | [NAME] (Pf) |  |  |  |  | JVN0711 | 518.21
 | [NAME] (Gt) |  |  |  |  | JVN0711 | 215.83 |  | Helper column C is used
 | Md Pintu [Salary] |  |  |  |  | JVN0711 | 3620.32
 | Md Pintu [Pf] |  |  |  |  | JVN0711 | 490.94
 | Md Pintu [Gt] |  |  |  |  | JVN0711 | 204.47
 | [NAME] [Salary] |  |  |  |  | JVN0711 | 2815.81
 | [NAME] [Pf] |  |  |  |  | JVN0711 | 381.84
 | [NAME] [Gt] |  |  |  |  | JVN0711 | 159.04
 | [NAME].[NAME] [Salary] |  |  |  |  | JVN0711 | 1206.77
 | [NAME].[NAME] [Pf] |  |  |  |  | JVN0711 | 136.65
 | [NAME].[NAME] [Gt] |  |  |  |  | JVN0711 | 68.16
 | Amit Choudhary (Salary) |  |  |  |  | JVN0084 | 12067.74
 | Amit Choudhary (PF) |  |  |  |  | JVN0084 | 1636.45
 | Amit Choudhary (Gratuity) |  |  |  |  | JVN0084 | 681.58
Spreadsheet: 56311d1256481238-plastic-injection-molding-production-calculator-production-calc-with-drop-down
Sheet: Part Data

Part # | Std. Cycle Secs | # of Cavities | Parts per carton
Blank | 0 | 0 | 0
AA | 30 | 6 | 720
A | 31 | 7 | 999
B | 32 | 8 | 1000
C | 33 | 9 | 1001
D | 34 | 10 | 1002
E | 35 | 11 | 1003
F | 36 | 12 | 1004
G | 37 | 13 | 1005
H | 38 | 14 | 1006
I | 39 | 15 | 1007
J | 40 | 16 | 1008
Spreadsheet: 759008d1639227905-data-split-blank-lines-issue-data-split-example
Sheet: For Markout

 | LX | [NAME] | -43000 | -4500 | 1T | 260 | 0 | 18M | 25M
 | LX | [NAME] | -43000 | 0 | 1T | 450 | 0 | 18M | 25M
 | LX | [NAME] 1 | 9500 | -13500 | 1T | 160 | 0 | 18M | 25M
 | LX | [NAME] 1 | 9500 | -10500 | 1T | 160 | 0 | 18M | 25M
 | LX | [NAME] 1 | 9500 | -7500 | 1T | 160 | 0 | 18M | 25M
 | LX | [NAME] 1 | 9500 | 4500 | 1T | 160 | 0 | 18M | 25M
 | LX | [NAME] 1 | 9500 | 10500 | 1T | 160 | 0 | 18M | 25M
 | LX | [NAME] | 7750 | -10500 | 2T | 160 | 0 | 18M | 25M
 | LX | [NAME] | 7750 | -7500 | 2T | 160 | 0 | 18M | 25M
 | LX | [NAME] | 7750 | -4500 | 2T | 610 | 0 | 18M | 25M
Spreadsheet: 217506d1362084670-consolidate-by-two-factors-new-problem
Sheet: May2012

 |  |  |  |  |  |  |  |  |  |  |  | 0.3
Customer | Name | Product | Description | Qty | m2 | Value | Av Price | Matl Cost | Yield AdJ | Purch Cost | Tot Matl Cost | ES Cost
3152 | Customer C | 101404 | 4mm Oriel Collection Brocade | 2 | 5.64 | 350.92 | 62.22 | 127.63 | 167.9342105263158 | 0 | 167.9342105263158 | 16.92
3152 | Customer C | 102604 | 4mm Oriel Collection Laurel st | 2 | 5.64 | 350.92 | 62.22 | 127.63 | 167.9342105263158 | 0 | 167.9342105263158 | 16.92
3152 | Customer C | 500044 | Insulight(TM) | 268 | 165.4 | 3101.16 | 18.75 | 728.57 | 958.6447368421053 | 0 | 958.6447368421053 | 496.2
3152 | Customer C | 500045 | Insulight(TM) | 16 | 7.54 | 213.84 | 28.36 | 55.64 | 73.21052631578948 | 0 | 73.21052631578948 | 22.62
3152 | Customer C | 500144 | Insulight(TM) Protect | 101 | 44.04 | 1249.1 | 28.36 | 212.7 | 279.8684210526316 | 0 | 279.8684210526316 | 132.12
3152 | Customer C | 500145 | Insulight(TM) Protect | 10 | 4.08 | 172.64 | 42.31 | 32.78 | 43.13157894736842 | 0 | 43.13157894736842 | 12.24
3152 | Customer C | 500148 | Insulight(TM) | 1 | 0.91 | 48.18 | 52.95 | 7.35 | 9.671052631578947 | 0 | 9.671052631578947 | 2.73
3152 | Customer C | 500166 | Insulight(TM) Protect | 2 | 3.37 | 151.01 | 44.81 | 18.6 | 24.47368421052632 | 0 | 24.47368421052632 | 10.11
3152 | Customer C | 500264 | Insulight(TM) Protect1 | 21 | 12.37 | 652.35 | 52.74 | 20.77 | 27.32894736842105 | 141.06 | 168.388947368421 | 37.11
3152 | Customer C | 500265 | Insulight(TM) Protect | 5 | 4.4 | 250.97 | 57.04 | 10.38 | 13.65789473684211 | 87.23 | 100.8878947368421 | 13.2
3152 | Customer C | 500280 | Insulight(TM) Protect | 7 | 7.17 | 276.54 | 38.57 | 22.75 | 29.93421052631579 | 51.5 | 81.43421052631578 | 21.51
3152 | Customer C | 500281 | Insulight(TM) Protect | 1 | 0.36 | 17.35 | 48.19 | 2.32 | 3.052631578947368 | 0 | 3.052631578947368 | 1.08
3152 | Customer C | 504261 | Insulight(TM) Triple | 1 | 0.19 | 9.45 | 49.74 | 1.73 | 2.276315789473684 | 0 | 2.276315789473684 | 0.5700000000000001
3152 | Customer C | 512246 | energiKare(TM) | 7 | 2.99 | 125.4 | 41.94 | 4.43 | 5.828947368421052 | 0 | 5.828947368421052 | 8.97
3152 | Customer C | 512272 | energiKare(TM) | 2 | 1.21 | 69.58 | 57.5 | 14.28 | 18.78947368421052 | 0 | 18.78947368421052 | 3.63
3152 | Customer C | 99999999 | Energy Surcharge | 0 | 0 | 1526.83 | 0 | 0 | 0 | 0 | 0 | 0
5203 | Customer H | 500145 | Insulight(TM) Protect | 1 | 0.78 | 47.31 | 60.65 | 6.41 | 8.43421052631579 | 0 | 8.43421052631579 | 2.34
5203 | Customer H | 99999999 | Energy Surcharge | 0 | 0 | 4.68 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 765944d1643684582-sum-partial-range-of-a-column-based-on-another-cell-value-book1
Sheet: Sheet3

Level | Dollars required | Current level attained | Dollars until goal
1 | 100 | 2
2 | 150
3 | 200
4 | 250
5 | 300
6 | 350
7 | 400
8 | 450
9 | 500
10 | 550
Spreadsheet: 845353d1696887798-automatically-insert-rows-for-each-value-that-is-returned-example-2
Sheet: Rate Data

Number | Quantity | Cost | Rate
 | 5 |  | 0.6
 | 10 |  | 0.8
2 | 15 |  | 0.6
2 | 4 |  | 0.6
3 | 20 |  | 1.5
4 | 25 |  | 0.6
4 | 4 |  | 0.6
4 | 21 |  | 0.5
4 | 5 |  | 0.5
4 | 30 |  | 0.8
4 | 35 |  | 1.5
4 | 40 |  | 0.53
4 | 16 |  | 0.53
5 | 45 |  | 0.6
6 | 50 |  | 0.6
7 | 55 |  | 0.6
 | 60 |  | 0.6
9 | 65 |  | 0.75
10 | 70 |  | 0.6
10 | 16 |  | 0.8
10 | 75 |  | 0.8
11 | 80 |  | 0.76
12 | 85 |  | 0.44
13 | 90 |  | 0.6
14 | 95 |  | 0.75
14 | 1 |  | 0.75
14 | 74 |  | 0.5
14 | 32 |  | 0.5
14 | 2 |  | 0.5
14 | 1 |  | 0.5
14 | 1 |  | 0.8
14 | 22 |  | 0.8
Spreadsheet: 941f2a80-b7c0-4249-816e-6478c1bb152d
Sheet: Björlanda-V3

%Lopnr | %Sidnr | %Ordnr | %Lysn1 | %Vdatum | %Mtitel | %Mfnamn | %Menamn | %Madress | %Nmadress | %Mforaldr | %Ktitel | %Kfnamn | %Kenamn | %Kadress | %Nkadress | %Kforaldr | %Ovr1 | %Ovr2 | %Ovr3 | %Uppdaterat
10 |  | 1 |  | 1936-02-02 | Hemmansägare Änkling | [NAME] | [NAME] | Alleby Skattegåred | Björlanda (O), [NAME] |  | Förest. | Elllen Adelaide Elisabet | [NAME] | Försörjningshemmet | Björlanda (O), Försörjningshemmet |  | [NAME] kh Mölndal Lysn.bev. [NAME] bev. Fr. Mölndal 7/2 | Han född 1900-03-12,  Hon född 1894-04-16
20 |  | 2 |  | 1936-06-23 | Hemmansägare | [NAME] | Olausson | A.5 i Lundby | [NAME] (O) |  | [NAME]. | Estrid Ingeborg | Persson | [NAME]. | Björlanda (O), [NAME] |  | [NAME] | Han född 1903-11-11,  Hon född 1908-04-10
30 |  | 3 |  | 1936-09-04 | [NAME] | Ernst Arne | Olsson | [NAME] | Björlanda (O), [NAME] |  | [NAME]. | [NAME] | [NAME] | [NAME]. | Björlanda (O), [NAME] |  | [NAME] | Han född 1911-09-10,  Hon född 1910-07-19
40 |  | 4 |  | 1936-11-27 | Hemmansäg. | [NAME] | Samuelsson | Alleby Skatteg. | Björlanda (O), [NAME] |  |  | Alma Viktoria | Landström | Lexby Östergård | Björlanda (O), Lexby syd Östergård |  | [NAME] | Han född 1891-08-13,  Hon född 1894-12-29
50 |  | 5 |  | 1936-12-30 | Fjärdingsman änkling | Per Edvin | Bengtsson | Röra Norg. | Björlanda (O), [NAME] |  | Hemmadotter | [NAME] | Olsson | [NAME]. | Björlanda (O), [NAME] |  | [NAME] | Han född 1889-04-29,  Hon född 1906-01-25
60 |  | 1 |  | 1937-03-05 | [NAME] | Per [NAME] | Olofsson | Röra Sörgård | Björlanda (O), [NAME] |  | Hemmadotter | [NAME] | Andersson | Låssby Sörgård | Björlanda (O), [NAME] |  | Kyrkoh. [NAME] | Han född 1911-11-06,  Hon född 1910-12-26
70 |  | 2 |  | 1937-04-06 | Jordbr.arb. | [NAME] | [NAME] | [NAME]. Säve | Säve (O), [NAME] |  | Hembiträde | [NAME] | Gadell | [NAME]. | Björlanda (O), [NAME] |  | [NAME] | Han född 1890-04-13,  Hon född 1892-04-29
80 |  | 3 |  | 1937-06-05 | [NAME] | [NAME] | Olsson | Häröd Norg. [NAME] 27 | [NAME] (O), [NAME] |  | Hemmadotter | Edit Viktoria | [NAME] | Röra Sörgård | Björlanda (O), [NAME] |  | [NAME] | Han född 1910-06-23,  Hon född 1911-07-29
90 |  | 4 |  | 1937-10-08 | Chaufför | Ivar Alexius | Andersson | Trastg. 7 Gamlestaden | [NAME] (O) |  | Hemmadotter | [NAME] | [NAME] | Björl. Mellang. | Björlanda (O), [NAME] |  | [NAME] | Han född 1910-06-22,  Hon född 1910-10-17
100 |  | 5 |  | 1937-11-11 | Hem.ägare | [NAME] | Berntsson | [NAME]. i Säve | Säve (O), Åseby Västergård |  | Hem.dotter | [NAME] | [NAME] | [NAME]. | Björlanda (O), [NAME] |  | [NAME] | Han född 1905-02-06,  Hon född 1911-11-13
110 |  | 6 |  | 1937-12-31 | Chokladarb. | Morgan | [NAME] | Lundby församl. | [NAME] (O) |  | Hem.dotter | [NAME] | [NAME] | Rödjan | Björlanda (O), Rödjan |  | [NAME] | Han född 1912-12-05,  Hon född 1914-04-17