tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 539166d1505994324-multiple-columns-into-one-multiple-columnss-attachment
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 | Column5 | Column6
 | S |  | MY 13 |  | MY 14 |  |  | Solution Desired
N/C | Name | N/C | Name | N/C | Name
0010 | [NAME] | 1-0000 | Assets | 1-0000 | Assets
0011 | Leasehold Property | 1-1160 | Undeposited Funds | 1-1160 | Undeposited Funds
0020 | P&M | 1-2000 | Trade Debtors | 1-2000 | Trade Debtors
0021 | P&M Depreciation | 1-2400 | Direct Payment | 1-2300 | Cash
0030 | Office Equipment | 1-2500 | Cash | 1-2310 | Direct Payment
Spreadsheet: 31278d1227094365-data-in-columns-to-rows-not-transpose-whatiwanttodo
Sheet: Sheet1

THIS IS MY SOURCE DATA I NEED TO CLEAN UP
Jan 1 - Dec 31 2009 | Mon | Tue | Wed | Thu | Fri | Sat | Sun
Jan 7 - Jan 13 | 49 | 50 | 54 | 54 | 40 | 41 | 36
Jan 14 - Jan 20 | 49 | 61 | 56 | 47 | 34 | 42 | 42
Jan 21 - Jan 27 | 40 | 60 | 56 | 58 | 71 | 64 | 31
Jan 28 - Feb 3 | 39 | 42 | 51 | 73 | 83 | 82 | 45
Feb 4 - Feb 10 | 62 | 97 | 78 | 70 | 55 | 70 | 51
Feb 11 - Feb 17 | 45 | 62 | 79 | 72 | 82 | 79 | 50
Feb 18 - Feb 24 | 59 | 68 | 57 | 63 | 71 | 64 | 42
Feb 25 - Mar 2 | 44 | 52 | 64 | 70 | 73 | 64 | 50
[NAME] 9 | 57 | 82 | 95 | 87 | 99 | 89 | 71
[NAME] 16 | 83 | 91 | 103 | 104 | 102 | 109 | 100
[NAME] 23 | 104 | 71 | 79 | 72 | 92 | 89 | 78
THIS IS HOW I WOULD WANT IT TO BE
2009-01-07 00:00:00 | 49
2009-01-08 00:00:00 | 50
2009-01-09 00:00:00 | 54
2009-01-10 00:00:00 | 54
2009-01-11 00:00:00 | 40
2009-01-12 00:00:00 | 41 |  |  | I do not need to convert the text format dates above into Excel date format, I can do this manually.
2009-01-13 00:00:00 | 36
2009-01-14 00:00:00 | 49
2009-01-15 00:00:00 | 61
2009-01-16 00:00:00 | 56
2009-01-17 00:00:00 | 47
2009-01-18 00:00:00 | 34
2009-01-19 00:00:00 | 42
2009-01-20 00:00:00 | 42
2009-01-21 00:00:00 | 40
2009-01-22 00:00:00 | 60
2009-01-23 00:00:00 | 56
2009-01-24 00:00:00 | 58
2009-01-25 00:00:00 | 71
2009-01-26 00:00:00 | 64
2009-01-27 00:00:00 | 31
2009-01-28 00:00:00 | 39
2009-01-29 00:00:00 | 42
2009-01-30 00:00:00 | 51
2009-01-31 00:00:00 | 73
2009-02-01 00:00:00 | 83
2009-02-02 00:00:00 | 82
2009-02-03 00:00:00 | 45
 | … and so on…
Spreadsheet: 328469d1403904320-partially-transpose-rows-with-formula-test-transpoe-options
Sheet: Sheet1

Case | Field1 | Field2 | Filed3 | Field(n) | Option1 | Option2 | Option3
1 | B2 | C2 | D2 | .. | x1 | y1 | z1
2 | B3 | [NAME] | D3 | .. | x2
3 | B4 | C4 | D4 | .. | [NAME] | y3
4 | B5 | C5 | D5 | .. | x4 | y4
5 | B6 | C6 | D6 | .. | x5 | y5 | z5
..
I need a formula to somehow "transpose" the option fields with their repective rows, below I try to explain how the data should be represented:
Case | Field1 | Field2 | Filed3 | Field(n) | Option
1 | B2 | C2 | D2 | .. | x1 | (A14=A2, B14=B2,C14=C2,D14=D2;E14=E2;f14=F2)
1 | B2 | C2 | D2 | .. | y1 | if(G2)<>"" then (A15=A2, B15=B2,C15=C2;D15=D2,E15=E2, and F15=G2) else if (G2)="" then (A15[NAME], B15=B3,C15=C3,D15=D3,E15=E3, and F15=F3)
1 | B2 | C2 | D2 | .. | z1 | [NAME])<>"" then (A16=A2, B16=B2,C16=C2;D16=D2,E16=E2, and F16=H2) else if (H2)="" then (A16=A3, B16=B3,C16=C3,D16=D3,E16=E3, and F16=F3)
2 | B3 | [NAME] | D3 | .. | x2 | if(G3)<>"" then (A17=A3, B17=B3,C17=C3;D17=D3,E17=E3, and F17=G3) else if (G3)="" then (A17=A4, B17=B4,C17=C4,D17=D4,E17=E4, and F17=F4)
3 | B4 | C4 | D4 | .. | [NAME] | [NAME])<>"" then (A18=A3, B18=B3,C18=C3;D18=D3,E18=E3, and F18=H3) else if (H3)="" then (A18=A4, B18=B4,C18=C4,D18=D4,E18=E4, and F18=F4)
3 | B4 | C4 | D4 | .. | y3 | and so on
4 | B5 | C5 | D5 | .. | x4
4 | B5 | C5 | D5 | .. | y4
5 | B6 | C6 | D6 | .. | x5
5 | B6 | C6 | D6 | .. | y5
5 | B6 | C6 | D6 | .. | z5
.. | .. | .. | .. | ..
Spreadsheet: 293011d1390858786-comparing-most-recent-data-data-example-thirtytwo-1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 | 2 | yes |  |  | most recent | 5
 | 2 | no |  |  |  | yes | no
 | 2 | yes |  | K | 2
 | 2 | no |  | L | 3
 | 2 | yes |  | M | 4
 | 2 | no |  | N | 5
 | 2 | yes |  | O | 6
 | 2 | no |  | P | 8
 | 2 | yes |  | Q | 7
 | 2 | no |  | R | 9
 | 2 | yes
 | 2 | no
 | 2 | yes
 | 2 | no
 | 2 | yes
 | 2 | no
 | 2 | yes
 | 2 | yes
 |  | no
 | 2 | yes
 |  | no
 | 2 | yes
 |  | no
 | 2 | yes
 |  | no
 | 2 | yes
 |  | no
 | 2 | yes
 |  | no
 | 2 | yes
 |  | no
 |  | yes
 |  | no
 |  | yes
 |  | yes
 |  | no
 |  | yes
 |  | no
 |  | yes
 |  | no
 |  | yes
 |  | no
 |  | yes
 |  | no
 |  | yes
 |  | no
 |  | yes
 |  | no
 |  | yes
 |  | no
 |  | yes
 |  | yes
 |  | no
 |  | yes
 |  | no
 |  | yes
 |  | no
 |  | yes
 |  | no
 |  | yes
 |  | no
 |  | yes
 |  | no
 |  | yes
 |  | no
 |  | yes
 |  | no
 |  | yes
 |  | yes
 |  | no
 |  | yes
 |  | no
 |  | yes
 |  | no
 |  | yes
 |  | no
 |  | yes
 |  | no
 |  | yes
 |  | no
Spreadsheet: 130152d1322080479-rank-text-by-number-of-appearance-rating-text
Sheet: Sheet1

 | Name_1
 | Name_2
 | Name_2
 | Name_4
 | Name_1
 | Name_2
 | Name_7
 | Name_8
 | Name_3
 | Name_1
 | Name_11
 | Name_2
 | Name_13
 | Name_14
 | Name_15
 | Name_16
 | Name_17
 | Name_1
 | Name_19
 | Name_20
Spreadsheet: 179862d1347389559-formula-not-working-with-duplicate-information-12-13-student-test
Sheet: Reference List

Departments |  | Account |  | Program Code |  | Account Code |  | Titles
AG |  | 11000 - 301010 |  | 000000 |  | 231000 |  | [NAME]
ESA |  | 11000 - 301020 |  | 601000 |  | 241000 |  | [NAME]
BIOL |  | 11000 - 301030 |  | Other |  | 431000 |  | [NAME]
CHEM |  | 17800 - 301010 |  |  |  | 433000 |  | [NAME]
MCS |  | NO FUNDS GRANTED |  | 010200 |  | 441000 |  | [NAME]
NSD |  | POD FUNDS |  | 010210 |  | 451000 |  | Short Term
PENG |  | SPECIAL FUND |  | 010900 |  | 471000 |  | Prof Exp.
GRANTS |  | Animal |  | 040100 |  | 521000 |  | Sub
 |  | Anthropology |  | 220200 |  | 522000
Months |  | Biology |  | 083700 |  | 525000
Jan |  | Chemistry |  | 043000 |  | 531000
Feb |  | Earth Sciences |  | 190500 |  | 554500
Mar |  | Horticulture |  | 191100 |  | 564000
April |  | Math |  | 191400 |  | 564500
May |  | NSD |  | 191900 |  | 580000
Jun |  | Physics Engineering |  | 170100 |  | 581000
July |  | RVT |  | 070600 |  | 584000
Aug |  | Wildlife |  | 190100 |  | 589000
Sep |  | Student-Budget Holding |  | 090100 |  | 589010
Oct |  |  |  |  |  | 641200
Nov |  | Student Accounts |  |  |  | 641300
Dec |  | Animal |  |  |  | 641400
 |  | Anthropology |  |  |  | 641500
Rates |  | Biology |  |  |  | 641600
8 |  | Chemistry |  |  |  | 641700
8.75 |  | Earth Sciences |  |  |  | 642200
10 |  | Horticulture |  |  |  | 642300
11.25 |  | Math |  |  |  | 642400
12.5 |  | NSD |  |  |  | 642500
 |  | Physics Engineering |  |  |  | 642600
ü |  | RVT |  |  |  | 642700
 |  | Wildlife |  |  |  | 643200
 |  | Grants |  |  |  | 643300
 |  | Student-Budget Holding |  |  |  | 643400
 |  |  |  |  |  | 643500
 |  |  |  |  |  | 643600
 |  |  |  |  |  | 643700
 |  |  |  |  |  | 644200
 |  |  |  |  |  | 644300
 |  |  |  |  |  | 644400
 |  |  |  |  |  | 645200
 |  |  |  |  |  | 645300
 |  |  |  |  |  | 645300
 |  |  |  |  |  | 645400
Spreadsheet: 98124d1297173352-formula-for-dynamic-logical-condition-condition
Sheet: Sheet1

Package |  | One off £ | Cost per webcast |  |  |  | Require
1 |  | 500 | 500 |  |  |  | 4 | (How can I caculate 7*150 based on 6-10 package)
2 | to 5 | 1250 | 250
6 | to 10 | 1500 | 150
11 | to 25 | 3000 | 120
26 | to 50 | 5000 | 100
Number of webcast require |  |  |  |  | 12 | (this will be dynamic no by user)
Total up front cost for webcasts
Spreadsheet: 145211d1331379885-data-lookup-and-print-the-values-example-2
Sheet: Database

 |  | Part Number | Part description | Part removed | Value of parts removed | Value of each Part
 |  | [NAME] | sfjg | -16 | -9228.11 | 576.756875
 |  | YCHSCLTXXXXXX | dfhhf | -1002 | -47344.5 | 47.25
 |  | YCLNMTL4055XX | hdfhA | -28000 | -72313.70999999999 | 2.5826325
 |  | YDHTSHT2135XX | HDHF | -3000 | -8229 | 2.743
 |  | YGSNTAB90150X | NSDMFN | -2 | -1939.11 | 969.555
 |  | YINKGMNC000BX | NZDMFMND |  |  | #N/A
 |  | YINKGMNM000BX | sfjg |  |  | #N/A
 |  | YINKGMNY000BX | dfhhf |  |  | #N/A
 |  | YINKNLLC000BX | hdfhA | -2600 | -429789.35 | 165.3035961538461
 |  | YINKNLLCUV0EX | HDHF | -175 | -144795 | 827.4
 |  | YINKNLLK000BX | NSDMFN | -11000 | -842996.1799999999 | 76.63601636363636
 |  | YINKNLLKUV0EX | NZDMFMND | -300 | -248220 | 827.4
 |  | YINKNLLM000BX | sfjg | -3200 | -531938.3099999999 | 166.230721875
 |  | [NAME] | dfhhf | -175 | -144795 | 827.4
 |  | YINKNLLY000BX | hdfhA | -4400 | -732084.93 | 166.3829386363637
 |  | [NAME] | HDHF | -175 | -144795 | 827.4
 |  | YKFTPPR1950XX | NSDMFN | -15 | -353.67 | 23.578
 |  | YPLSTWNX000XX | NZDMFMND | -75 | -3622.5 | 48.3
 |  | YTEKAMRW000BX | sfjg | -3570 | -306389.77 | 85.8234649859944
 |  | [NAME] | dfhhf | -135 | -6561.7 | 48.60518518518519
 |  | YTEKCRNX000BX | hdfhA | -1890 | -136155.89 | 72.04015343915344
 |  | YTEKNWDP000AX | HDHF | -100 | -20563.71 | 205.6371
 |  | YTEKSLNX000XX | NSDMFN | -24 | -5623.24 | 234.3016666666666
 |  | YTEMTAP12550X | NZDMFMND | -88 | -17795 | 202.2159090909091
 |  | YTKNGMN250XXX | sfjg | -10 | -907.8 | 90.78
 |  | YUVNLLC0000BX | dfhhf | -50 | -41370 | 827.4
 |  | YUVNLLK0000BX | hdfhA | -50 | -41370 | 827.4
 |  | YUVNLLM0000BX | HDHF | -50 | -41370 | 827.4
 |  | YUVNLLY0000BX | NSDMFN | -50 | -41370 | 827.4
Spreadsheet: 81651d1281768341-how-to-enter-a-vlookup-function-with-vba-fgin-auto-test
Sheet: FGIN

FINISH GOODS ISSUE NOTE
 |  |  | Serial No: | 181
 | 3
 |  |  | 2014-11-28 00:00:00
 | Potato
Product ID | Product Name. | Quantity | Value
 | ab
 | z
 | Total
Approved By               :………………………….. |  | ( Stores Only)
Sales Officer / Cashier :………………………… |  | Store Keeper :………………………….
Above items Correctly Received By :……………………...… |  | Date             :…………………………..
 | (Customer Signature)
 |  | Security Officer :……………………….
Spreadsheet: 762828d1641839122-sumifs-criteria-matching-between-tables-help
Sheet: FTE

Difference in Available FTE and Required FTE
 |  | Available | Required
Role | Resource | [NAME] | [NAME] | [NAME] | FEB Rqd | [NAME] | [NAME] | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
Manager | [NAME] | 0.45 |  | 0.45 |  | 0.45
Manager | Fred Davies | 0.4 |  | 0.4 |  | 0.4
Manager | [NAME] | 0.45 |  | 0.45 |  | 0.45
Manager | [NAME] | 0.45 |  | 0.45 |  | 0.45
Manager | Horace Rumpole | 0.8 |  | 0.7 |  | 0.7
Manager | Lotus [NAME] | 0 |  | 0 |  | 0
Manager | [NAME] | 0.45 |  | 0.45 |  | 0.45
Manager | [NAME] | 0.9 |  | 0.9 |  | 0.9
Manager | [NAME] | 0.45 |  | 0 |  | 0
Manager | [NAME] | 0.45 |  | 0.45 |  | 0.45
Deputy Manager | [NAME] | 0.45 |  | 0.45 |  | 0.45
Deputy Manager | Fred Davies | 0 |  | 0 |  | 0
Deputy Manager | [NAME] | 0 |  | 0 |  | 0
Deputy Manager | [NAME] | 0.45 |  | 0.45 |  | 0.45
Deputy Manager | Horace Rumpole | 0.1 |  | 0.2 |  | 0.2
Deputy Manager | Lotus [NAME] | 0.9 |  | 0.9 |  | 0.9
Deputy Manager | [NAME] | 0 |  | 0 |  | 0
Deputy Manager | [NAME] | 0 |  | 0 |  | 0
Deputy Manager | [NAME] | 0.45 |  | 0 |  | 0
Deputy Manager | [NAME] | 0.45 |  | 0.45 |  | 0.45
Horse Doctor | [NAME] | 0.45 |  | 0.45 |  | 0.45
Window [NAME] | [NAME] | 0.45 |  | 0.45 |  | 0.45
Painter | [NAME] | 0.6 |  | 0.6 |  | 0.6
Painter | [NAME] | 0.1 |  | 0.1 |  | 0.1
Decorator | [NAME] | 0.3 |  | 0.3 |  | 0.3
Decorator | [NAME] | 0.3 |  | 0.3 |  | 0.3
Decorator | Emile Dunbar | 0.3 |  | 0.3 |  | 0.3
Fisherman | [NAME] | 0.1 |  | 0.1 |  | 0.1
Fisherman | [NAME] | 0.1 |  | 0.1 |  | 0.1
Fisherman | [NAME] | 0.1 |  | 0.1 |  | 0.1
Fisherman | [NAME] | 0.1 |  | 0.1 |  | 0.1
Grass | [NAME] | 0.05 |  | 0.05 |  | 0.05
Gladiator | [NAME] | 0.9 |  | 0.9 |  | 0.9
Gladiator | [NAME] | 0.3 |  | 0.3 |  | 0.3
Gladiator | TBC | 0.9 |  | 0.9 |  | 0.9
laundry | [NAME] | 0.1 |  | 0.1 |  | 0.1
Bagging | Nobody Inparticular | 0.1 |  | 0.1 |  | 0.1
Bagging | Isla Skye | 0.1 |  | 0.1 |  | 0.1
Bagging | [NAME] | 0.1 |  | 0.1 |  | 0.1
Bagging | [NAME] | 0.1 |  | 0.1 |  | 0.1
Files | [NAME] | 0.1 |  | 0.1 |  | 0.1
Sales | Captain [NAME] | 0.1 |  | 0.1 |  | 0.1
Sales | [NAME] | 0.1 |  | 0.1 |  | 0.1
Buyer | Ford Prefect | 0.3 |  | 0.3 |  | 0.3
Spreadsheet: 880569d1728373104-loop-in-sheet-test-kelder
Sheet: DATA

DRAAI | [NAME] | [NAME] | Materiaal | deurblad | CHAMBRANT | Paumel | aantal | Slot | [NAME] | Pomp | Deurstop | Deurrubbers | Makelaars | [NAME]
L | 40 | K/C | [NAME] | Tubespaan-Plamuur | Chambrant meranti primed trapezium 12/68 | Bestaand recupereren ! | 3 | Bestaand recupereren ! | Bestaand recupereren ! | [NAME] glijarm, grijs | Vloermodel- Tonic Line halve maal - rvs+rubber | [NAME], groef 3-3.6mm - transparant | [NAME] 40-18 Rood hout 2270x40x18 | kantschuif Artitec inox 200x17x13 mm / steenhuls 401 chroom [NAME]
R | 50 | K/WC | -- | ---- | Chambrant meranti primed RECHT 12/68 | -- | 4 | -- | -- | [NAME] glijarm zwart | Wandstop Tonic Line 0704 - diam 30mm-25mmL-zwarte rubber | [NAME], groef 3-3.6mm - zwart
L/R |  | K/BOL | MDF | HPL (nog te bepalen) |  | Paumel HDD [NAME] INOX | 5 | Insteekslot A26E1-27 DN CYL AR 60E - 72PZ - RVS / Vlakke sluitplaat PA80-27 RVS DN - 1mm - B48mm - EXCL Cylinder | [NAME] [NAME] - ronde rozetten - Cyl. Rozet rond - rvs | Assa Abloy DC350 glijarm grijs | -- | [NAME], groef 3-3.6mm - transparant
 |  | BOL/BOL | MTX | ----- |  | Paumel HDD [NAME] WIT | 6 | Insteekslot A26E1-27 DN CYL AR 60E - 72PZ - RVS / Vlakke sluitplaat PA80-27 RVS DN - 1mm - B48mm - INCL cylinder | Knop/Kruk Artitec [NAME] + [NAME] - ronde rozetten - Cyl. Rozet rond - rvs | -- | Deurstop  (vloer) Artitec 01992 - Dia30 [NAME]/zwart | --
 |  | K/K | BLOK | [NAME] |  | Paumel HDD [NAME] ZWART | 8 | [NAME]27 DN WC AR 60E - 78WC - RVS / Vlakke sluitplaat PA80-27 RVS DN - 1mm - B48mm - Vrij/bezet | [NAME] [NAME] - ronde rozetten - rvs - GEEN slot rozet | Dorma ITS96 glijarm - zilver |  | [NAME] 6577 BS - Deventer - zwart
 |  | SCHELP/SCHELP | GLAS | ------ |  | Paumel HDD [NAME] BRONS |  | --- | [NAME] [NAME] - ronde rozetten - Vrij/Bezet rozet rond - rvs | [NAME] glijarm - zilver
 |  |  | METAAL | [NAME] F0949 White Mat |  | --- |  | Elektrische sluitpl. Profix2 diode - 138.53,12V DC ruststrVoorpla - at el sluitplaat Profix2 - 66B35-01 - RVS | [NAME] [NAME] - ronde rozetten - GEEN slot rozet - ZWART | 2X Dorma ITS93 + glijarm - zilver
 |  |  | VOLKERN | ------- |  | Paumel HDD 86x100x3 Ø16mm INOX |  |  | [NAME] [NAME] - ronde rozetten - Vrij/Bezet rozet rond - ZWART | Dorma ITS96 glijarm - zwart
 |  |  |  | Resopal - EBONY - 10622-VE |  | Paumel HDD 86x100x3 Ø16mm WIT |  |  | --- | [NAME] glijarm - zwart
 |  |  |  |  |  | Paumel HDD 86x100x3 Ø16mm ZWART |  |  | Inkapschelp Tonic Line 602 - RVS
 |  |  |  | --------- |  | Paumel HDD 86x100x3 Ø16mm BRONS
 |  |  |  | Bestaand deurblad behouden - te schilderen |  | -----
 |  |  |  | Behouden |  | Argentclose paumel+veer 80/80 Ø14mm - 3.5mm - alu F1
 |  |  |  |  |  | -----
 |  |  |  |  |  | Paumel SYMONS voor met. deurkozijn - INOX
Spreadsheet: 538945d1505905024-auto-populate-data-from-an-existing-sheet-auto-populate
Sheet: Question Sheet

 | April'17 |  |  |  |  |  |  |  | May'17 |  |  |  |  |  |  |  | June'17 |  |  |  |  |  |  |  | July'17 |  |  |  |  |  |  |  | Aug'17
Division | A | B | C | D | E | F | G | H | A | B | C | D | E | F | G | H | A | B | C | D | E | F | G | H | A | B | C | D | E | F | G | H | A | B | C | D | E | F | G | H
Apple | 522 | 561 | 25693 | 143224 | 0 | 0 | 1 | 0.01340996168582376 | 1104 | 1485 | 62159 | 497703 | 245 | 360 | 2 | 0.003623188405797101 | 2 | 5 | 1 | 15 | 0 | 0 | 1 | 0 | 4 | 6 | 0 | 45 | 0 | 0 | 7 | 0 | 4 | 6 | 0 | 29.84 | 0 | 0 | 8 | 0
Orange | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 0 | 44 | 24 | 91 | 4087 | 0 | 0 | 2 | 0 | 1098 | 1484 | 64582 | 539438 | 143 | 226 | 2 | 0.01275045537340619 | 1105 | 1485 | 72353 | 510020 | 36 | 40 | 5 | 0.001809954751131222 | 1090 | 1485 | 61630 | 420886.2300000004 | 28 | 36 | 1 | 0.01192660550458716
Spreadsheet: 116957d1312362580-array-formula-or-possible-macro-to-match-and-calculate-between-multiple-sheets-testbook
Sheet: ProductRecipes

Ingredient | Amount | Unit | Falafel Wrap | [NAME] | Shrimp Wrap | Salmon Wrap
Falafel | 2 | OZ | 4 |  | 1 | 3
Marinated Chicken | 2 | OZ |  | 1 | 2 | 2
[NAME] Dough | 2 | OZ |  | 1
White Dough | 2 | OZ | 1
[NAME] | 2 | OZ |  |  | 4
[NAME] | 2 | OZ | 1 |  |  | 1 |  |  |  |  |  | match value in array  of row 1 of dishdatabase to array of row 1 of product recipes, if in product recipes there is value down the column of the matched value, get the name in corresponding cell in column A, match value in  array  of column A in ingredient recipes multiply corresponding  value in
Spreadsheet: darrell_schoolcraft__7816__imbalsumm0109
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 6447 | 6386 |  |  | 983 | 1674 | 1840 | 1258
2 | 6381 | 6386 |  |  | 971 | 1305 | 1770 | 1258
3 | 6244 | 6374 |  |  | 1013 | 1612 | 2100 | 1258
4 | 6471 | 6386 |  |  | 827 | 1674 | 2290 | 1258
5 | 6261 | 6386 |  |  | 967 | 1674 | 2209 | 1258
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2001-08-31 00:00:00 |  |  |  |  |  |  |  |  | 320982
2001-09-05 00:00:00
CBS Volume
 |  |  | 127683
Spreadsheet: darrell_schoolcraft__7254__saledoc02_13aTW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Astra Power
Deal Date: |  |  | 2/1122002 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 2002-02-13 00:00:00 |  |  | FAX Number:
Total Quantity |  |  | 51777 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 2.24
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
2/13/2002 | 2002-02-13 00:00:00 | 51777 |  | 51777 |  | 51777
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
WT Pool |  |  | 58646 |  | 51777 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
[NAME] [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 36a30ab8-1dc8-4a8a-af8a-730ff58196fd
Sheet: Sheet1

UL Short Circuit Rating of Open Components for use in Industrial Control Panels | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Product Group | Component Type |  | Description |  |  | Partial Catalog Number(s) |  | Maximum Horsepower Ratings |  |  |  |  |  |  | Standard Fault Short Circuit Rating
 |  |  |  |  |  |  |  | 1 Phase |  |  | 3 Phase
 |  |  |  |  |  |  |  | 110-120V | 220-240V | 480-600V | 110 - 120V | 200-208V | 440-480V | 550-600V
Miniature Controls | Non-reversing Contactor |  | 3 pole - pressure plate terminals |  |  | CE12BNC310* |  | 1/2 | 1 | - | 1 | 1 | 3 | 3 | 5kA
 |  |  |  |  |  | CE12BNC301* |  | 1/2 | 1 | - | 1 | 1 | 3 | 3
 |  |  | 4 pole - pressure plate terminals |  |  | CE12BNC400* |  | 1/2 | 1 | - | 1 | 1 | 3 | 3
 |  |  | 3 pole - pressure plate terminals |  |  | CE12CNC310* |  | 3/4 | 1.5 | 2 | 1 | 2 | 5 | 5
 |  |  |  |  |  | CE12CNC301* |  | 3/4 | 1.5 | 2 | 1 | 2 | 5 | 5
 |  |  | 4 pole - pressure plate terminals |  |  | CE12CNC400* |  | 3/4 | 1.5 | 2 | 1 | 2 | 5 | 5
 | Reversing Contactor |  | 3 pole - pressure plate terminals |  |  | CE52BNC310* |  | 1/2 | 1 | - | 1 | 1 | 3 | 3
 |  |  |  |  |  | CE52BNC301* |  | 1/2 | 1 | - | 1 | 1 | 3 | 3
 |  |  |  |  |  | CE52CNC310* |  | 3/4 | 1.5 | 2 | 1 | 2 | 5 | 5
 |  |  |  |  |  | CE52CNC301* |  | 3/4 | 1.5 | 2 | 1 | 2 | 5 | 5
Miniature Controls | Non-reversing Contactor |  | 3 pole - quick connect terminals |  |  | CE12BNB310* |  | 1/2 | 1 | - | 1 | 1 | 3 | 3 | 5kA
 |  |  |  |  |  | CE12BNB301* |  | 1/2 | 1 | - | 1 | 1 | 3 | 3
 |  |  | 4 pole - quick connect terminals |  |  | CE12BNB400* |  | 1/2 | 1 | - | 1 | 1 | 3 | 3
 |  |  | 3 pole - quick connect terminals |  |  | CE12CNB310* |  | 3/4 | 1.5 | 2 | 1 | 2 | 5 | 5
 |  |  |  |  |  | CE12CNB301* |  | 3/4 | 1.5 | 2 | 1 | 2 | 5 | 5
 |  |  | 4 pole - quick connect terminals |  |  | CE12CNB400* |  | 3/4 | 1.5 | 2 | 1 | 2 | 5 | 5
 | Reversing Contactor |  | 3 pole - quick connect terminals |  |  | CE52BNB310* |  | 1/2 | 1 | - | 1 | 1 | 3 | 3
 |  |  |  |  |  | CE52BNB301* |  | 1/2 | 1 | - | 1 | 1 | 3 | 3
 |  |  |  |  |  | CE52CNB310* |  | 3/4 | 1.5 | 2 | 1 | 2 | 5 | 5
 |  |  |  |  |  | CE52CNB301* |  | 3/4 | 1.5 | 2 | 1 | 2 | 5 | 5
Miniature Controls | Non-reversing Contactor |  | 3 pole - solder pin terminals |  |  | CE12BNP310* |  | 1/2 | 1 | - | 1 | 1 | 3 | 3 | 5kA
 |  |  |  |  |  | [NAME]* |  | 1/2 | 1 | - | 1 | 1 | 3 | 3
 |  |  |  |  |  | CE12CNP310* |  | 3/4 | 1.5 | 2 | 1 | 2 | 5 | 5
 |  |  |  |  |  | CE12CNP301* |  | 3/4 | 1.5 | 2 | 1 | 2 | 5 | 5
 | Reversing Contactor |  | 3 pole - solder pin terminals |  |  | CE52BNP310* |  | 1/2 | 1 | - | 1 | 1 | 3 | 3
 |  |  |  |  |  | CE52BNP301* |  | 1/2 | 1 | - | 1 | 1 | 3 | 3
 |  |  |  |  |  | CE52CNP310* |  | 3/4 | 1.5 | 2 | 1 | 2 | 5 | 5
 |  |  |  |  |  | CE52CNP301* |  | 3/4 | 1.5 | 2 | 1 | 2 | 5 | 5
Miniature Controls | [NAME] |  | Fixed heater, 3 pole, FLA Ranges from 0.10 to 12. 0 Amperes |  |  | C312ANA3* |  | - | - | - | - | - | - | - | 5kA
Spreadsheet: 478242d1472697962-attendance-sheet-how-to-best-summarise-data-attendance-sheet-how-to-best-summarise-data
Sheet: Sheet1

Date | Time | ID | Name | Check In/Check Out | Hours worked |  |  |  |  |  | ID | NAME
2016-08-28 00:00:00 | 20:00:00 | 15000 |  |  |  |  |  | The formula in E4 filled down is =IF(D2="","",IF(MOD(COUNTIF(D$2:D2,D2)-1,2),"Out","In")) |  |  | 13997 | [NAME]
2016-08-28 00:00:00 | 21:00:00 | 15000 |  |  |  |  |  |  |  |  | 15000 | [NAME]
2016-08-28 00:00:00 | 11:00:00 | 16000 |  |  |  |  |  |  |  |  | 16000 | [NAME]
2016-08-28 00:00:00 | 12:00:00 | 16000
2016-08-29 00:00:00 | 08:00:00 | 13997
2016-08-29 00:00:00 | 09:00:00 | 13997
2016-08-29 00:00:00 | 19:00:00 | 15000
2016-08-29 00:00:00 | 20:00:00 | 15000
2016-08-29 00:00:00 | 10:00:00 | 16000
2016-08-29 00:00:00 | 11:00:00 | 16000 |  |  |  |  |  |  |  |  | Summary
2016-08-30 00:00:00 | 08:00:00 | 13997 |  |  |  |  |  |  |  |  | 14:19:00 | 19:20:00
2016-08-30 00:00:00 | 09:00:00 | 13997
2016-08-30 00:00:00 | 19:00:00 | 15000
2016-08-30 00:00:00 | 20:00:00 | 15000
2016-08-30 00:00:00 | 10:00:00 | 16000
2016-08-30 00:00:00 | 11:00:00 | 16000
2016-08-31 00:00:00 | 12:00:00 | 13997
2016-08-31 00:00:00 | 14:00:00 | 13997
2016-08-31 00:00:00 | 20:00:00 | 15000
2016-08-31 00:00:00 | 21:00:00 | 15000
2016-08-31 00:00:00 | 11:00:00 | 16000
2016-08-31 00:00:00 | 12:00:00 | 16000
2016-09-01 00:00:00 | 06:30:00 | 13997
2016-09-01 00:00:00 | 07:00:00 | 16000
2016-09-01 00:00:00 | 07:30:00 | 15000
2016-09-01 00:00:00 | 14:00:00 | 16000
2016-09-01 00:00:00 | 15:30:00 | 13997
2016-09-01 00:00:00 | 16:20:00 | 15000