tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 117381d1312751601-excel-2007-extracting-certain-weekdays-in-a-month-book1
Sheet: Sheet1

Select Year | 2011 | Select Month | September | Select Days | Tuesday,Thursday |  |  |  | 2011 | January | Monday
 |  |  |  |  |  |  |  |  | 2012 | February | Tuesday
 |  |  |  |  |  |  |  |  | 2013 | March | Wednesday
[NAME] |  |  |  |  |  |  |  |  |  | April | Thursday
Thu 01 Sep 2011 |  |  |  |  |  |  |  |  |  | May | Friday
Tue 06 Sep 2011 |  |  |  |  |  |  |  |  |  | June | Saturday
Thu 08 Sep 2011 |  |  |  |  |  |  |  |  |  | July | Sunday
Tue 13 Sep 2011 |  |  |  |  |  |  |  |  |  | August
Thu 15 Sep 2011 |  |  |  |  |  |  |  |  |  | September
Tue 20 Sep 2011 |  |  |  |  |  |  |  |  |  | October
Thu 22 Sep 2011 |  |  |  |  |  |  |  |  |  | November
Tue 27 Sep 2011 |  |  |  |  |  |  |  |  |  | December
Thu 29 Sep 2011
Spreadsheet: 845359d1696893294-formula-to-flip-the-first-5-characters-book6
Sheet: Sheet1

OrderDate (mm/dd/yyyy) |  |  |  |  |  | OrderDate (dd/mm/yyyy)
2023-09-10 16:33:39 |  |  |  |  |  | 2023-10-09 16:33:39
2023-09-10 16:32:17 |  |  |  |  |  | 2023-10-09 16:32:17
2023-09-10 16:31:58 |  | this cell formatting is in dd/mm/yyyy. However the date inside the cell is still in mm/dd/yyyy. Due to which in spite of formatting the cell to dd/mm/yyyy format, my computer still read this date as 10th Sept. Which is wrong. The correct date should be 9th October |  |  |  | 2023-10-09 16:31:58 |  | I did this manually to match my computer date. So whenever I calculate using date, I should get correct answer.
2023-09-10 16:28:55 |  |  |  |  |  | 2023-10-09 16:28:55
2023-09-10 15:48:03 |  |  |  |  |  | 2023-10-09 15:48:03
2023-09-10 15:29:50 |  |  |  |  |  | 2023-10-09 15:29:50
2023-09-10 15:27:50 |  |  |  |  |  | 2023-10-09 15:27:50
2023-09-10 15:21:36 |  |  |  |  |  | 2023-10-09 15:21:36
2023-09-10 15:12:01 |  |  |  |  |  | 2023-10-09 15:12:01
2023-09-10 15:07:29 |  |  |  |  |  | 2023-10-09 15:07:29
2023-09-10 14:49:13 |  |  |  |  |  | 2023-10-09 14:49:13
2023-09-10 14:39:34 |  |  |  |  |  | 2023-10-09 14:39:34
2023-09-10 14:36:50 |  |  |  |  |  | 2023-10-09 14:36:50
2023-09-10 14:36:49 |  |  |  |  |  | 2023-10-09 14:36:49
2023-09-10 14:20:54 |  |  |  |  |  | 2023-10-09 14:20:54
2023-09-10 14:19:49 |  |  |  |  |  | 2023-10-09 14:19:49
2023-09-10 14:14:52 |  |  |  |  |  | 2023-10-09 14:14:52
2023-09-10 14:10:02 |  |  |  |  |  | 2023-10-09 14:10:02
2023-09-10 13:48:01 |  |  |  |  |  | 2023-10-09 13:48:01
2023-09-10 13:27:49 |  |  |  |  |  | 2023-10-09 13:27:49
2023-09-10 12:32:34 |  |  |  |  |  | 2023-10-09 12:32:34
2023-09-10 12:30:02 |  |  |  |  |  | 2023-10-09 12:30:02
2023-09-10 12:29:16 |  |  |  |  |  | 2023-10-09 12:29:16
2023-09-10 12:25:35 |  |  |  |  |  | 2023-10-09 12:25:35
2023-09-10 12:25:16 |  |  |  |  |  | 2023-10-09 12:25:16
2023-09-10 12:23:02 |  |  |  |  |  | 2023-10-09 12:23:02
2023-09-10 12:21:32 |  |  |  |  |  | 2023-10-09 12:21:32
2023-09-10 12:21:06 |  |  |  |  |  | 2023-10-09 12:21:06
2023-09-10 12:19:44 |  |  |  |  |  | 2023-10-09 12:19:44
2023-09-10 11:47:35 |  |  |  |  |  | 2023-10-09 11:47:35
2023-09-10 11:42:33 |  |  |  |  |  | 2023-10-09 11:42:33
2023-09-10 11:32:34 |  |  |  |  |  | 2023-10-09 11:32:34
2023-09-10 11:24:54 |  |  |  |  |  | 2023-10-09 11:24:54
2023-09-10 11:24:43 |  |  |  |  |  | 2023-10-09 11:24:43
2023-09-10 10:29:03 |  |  |  |  |  | 2023-10-09 10:29:03
2023-09-10 10:03:20 |  |  |  |  |  | 2023-10-09 10:03:20
2023-09-10 09:40:34 |  |  |  |  |  | 2023-10-09 09:40:34
2023-09-10 09:21:15 |  |  |  |  |  | 2023-10-09 09:21:15
2023-09-10 09:19:31 |  |  |  |  |  | 2023-10-09 09:19:31
2023-09-10 09:07:03 |  |  |  |  |  | 2023-10-09 09:07:03
2023-09-10 09:00:46 |  |  |  |  |  | 2023-10-09 09:00:46
2023-09-10 08:59:58 |  |  |  |  |  | 2023-10-09 08:59:58
2023-09-10 08:58:45 |  |  |  |  |  | 2023-10-09 08:58:45
2023-09-10 08:34:01 |  |  |  |  |  | 2023-10-09 08:34:01
Spreadsheet: 27228d1220364940-help-creating-in-house-reporting-excel-doc-correct-kt-usage
Sheet: Totals

Agent Name | Score
0 | 0
0
0
Current T1 Agents
[NAME] | 0.12
[NAME]
[NAME]
[NAME]
Azeez Akande
[NAME] | 0.15
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] | 0
Dipin Nayee
Duane Greaves
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Imran Mukhtar
Jade Sandham
[NAME]
[NAME]
[NAME]
[NAME] | 0
[NAME]
[NAME]
Keith Davies
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Saima Younus
[NAME]
[NAME]
[NAME]
Spreadsheet: 328777d1404072452-copy-cells-in-another-sheet-if-1st-sheet-has-a-certain-color-in-a-specific-column-current-log-1
Sheet: Bid Log

 |  | Summary
Public | Bid Day | Bid Date | Bid Time | Counts | Project Name | Customers Requesting | Project Contact | Are We Bidding? | Location
Y
Y
Y |  | 2014-07-26 00:00:00
Spreadsheet: 96967d1296193475-looking-for-advice-to-improve-function-of-workbook-lab-stuff
Sheet: Chemical Tracking

Chemical Tracking Sheet
# | Name | Percent Remaining
1 | Acetone
2 | Ammonium nitrate
3 | distilled water
4 | Erythritol
5 | Ethanol
6 | Hexamine
7 | Nitric Acid
8 | potassium nitrate
9 | Sodium bicarbonate
10 | sulfuric acid
11 |  | 0
12 |  | 0
13 |  | 0
14 |  | 0
15 |  | 0
16 |  | 0
17 |  | 0
18 |  | 0
19 |  | 0
20 |  | 0
Spreadsheet: 0eb76dc4-6453-4ce0-a89b-3f4c79d3606f
Sheet: Table I.22

Table I.22 الجدول
Hypermatrix of Physical Water Flows in Egypt, 2009
مصفوفة التدفق المادي للمياه ، مصر، 2009
km3/year | Atmosphere | Inland water system | Sea | Rest of the world | Economic system | Consumption | Difference in stock | SUMS ARE EQUAL
Atmosphere |  | 1.3 |  |  |  |  |  | #REF!
Inland water system | 1.9 | 1 | 0.7 | 21.9 | 266.1 |  | -4.9 | 286.7
Sea |  |  |  |  | 0.02 |  |  | #REF!
Rest of the world (The Sudan) |  | 55.5 |  |  |  |  |  | #REF!
Economic system | 0.2 | 228.9 |  | 0.4 | 5.1 | 36.6 |  | 75.6
SUMS ARE EQUAL | 2.1 | 286.7 | 0.7 | 22.3 | 75.6 | 36.6 |  | #REF!
Source: | Technical Mission Report to Egypt, April 2010, ESCWA.
Spreadsheet: 845441d1696958058-pivot-with-multiple-tabs-as-range-forecasts-and-orders-10102023
Sheet: CHL

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
CHLORO WATER 12/16.9Z BTL | 11042
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
CHLORO WATER 12/16.9Z BTL | 11042
Spreadsheet: 749884d1633079094-formula-error-iferror-c2-b2-0-1-excel-example
Sheet: Sheet1

Product | 2021-09-23 00:00:00 | 2021-09-30 00:00:00 | wow dif
Board Accessories | 0.07655809184881289 | 0.1234681663253092
Teachers Desks | 0 | 0.1111111111111111
Welcome Signs | 0 | 0.1
Chalk Boards | 0 | 0.08333333333333333
Anti Static Chairs | 0.02597402597402598 | 0.07142857142857142
Panel Display Systems | 0.01587301587301587 | 0.0606060606060606
Display / Presentation | 0.01020408163265306 | 0.05952380952380953
Footrests | 0.06082011752069249 | 0.05792383528515462
Spreadsheet: 748845d1632385177-vba-i-need-to-store-data-instead-of-only-keeping-1-number-at-a-time-sample-fitness-tracker-deployment-2021-with-users-
Sheet: WEEK1

 | Total For Week 1 |  |  | Total For Week 2 |  |  | Total For Week 3 |  |  | Total for Week 4 |  |  | Monthly Progress
 |  | 20 |  |  | 20 |  |  | 20 |  |  | 20 |  |  | 80 | [NAME]
 | Activity 1 |  |  | Activity 2 |  |  | Activity 3 |  |  | Activity 4 |  |  | Activity 5 |  | Weekly Check
 | Stationary Cycling |  |  | None |  |  | None |  |  | None |  |  | None |  | False
Monday |  | 30 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | False
 | Points Earned |  |  | Points Earned |  |  | Points Earned |  |  | Points Earned |  |  | Points Earned |  | True
 | Activity 1 |  |  | Activity 2 |  |  | Activity 3 |  |  | Activity 4 |  |  | Activity 5 |  | Weekly Percentage Check
 | None |  |  | None |  |  | None |  |  | None |  |  | None
Tuesday |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | Points Earned |  |  | Points Earned |  |  | Points Earned |  |  | Points Earned |  |  | Points Earned
 | Activity 1 |  |  | Activity 2 |  |  | Activity 3 |  |  | Activity 4 |  |  | Activity 5
 | None |  |  | None |  |  | None |  |  | None |  |  | None
Wednesday |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | Points Earned |  |  | Points Earned |  |  | Points Earned |  |  | Points Earned |  |  | Points Earned
 | Activity 1 |  |  | Activity 2 |  |  | Activity 3 |  |  | Activity 4 |  |  | Activity 5
 | None |  |  | None |  |  | None |  |  | None |  |  | None
Thursday |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | Points Earned |  |  | Points Earned |  |  | Points Earned |  |  | Points Earned |  |  | Points Earned
 | Activity 1 |  |  | Activity 2 |  |  | Activity 3 |  |  | Activity 4 |  |  | Activity 5 |  | Monthly Percentage Check
 | None |  |  | None |  |  | None |  |  | None |  |  | None
Friday |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | Points Earned |  |  | Points Earned |  |  | Points Earned |  |  | Points Earned |  |  | Points Earned
 | Activity 1 |  |  | Activity 2 |  |  | Activity 3 |  |  | Activity 4 |  |  | Activity 5
 | None |  |  | None |  |  | None |  |  | None |  |  | None
Saturday |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | Points Earned |  |  | Points Earned |  |  | Points Earned |  |  | Points Earned |  |  | Points Earned
 | Activity 1 |  |  | Activity 2 |  |  | Activity 3 |  |  | Activity 4 |  |  | Activity 5
 | None |  |  | None |  |  | None |  |  | None |  |  | None
Sunday |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | Points Earned |  |  | Points Earned |  |  | Points Earned |  |  | Points Earned |  |  | Points Earned
Spreadsheet: 72196d1272906998-index-function-based-on-year-pdgvalueproposition
Sheet: Sheet1

Forethought Relationship
Average Final Expense | 1.45
Forethought Final  Expense | 1.35
Premium | 1000000
Initial Opportunity cost to AmeriLife
Persistency Rate
Medicare Supplement | 0.85
Final Expense | 0.75
Annuity | 0.85
Average Size | 1500
Potential Product Development Opportunities | Anticipated Premium | PDG Fee Year 1 | App fee | [NAME] | 1st Year Comp | Year 2 Comp | Year 3 Comp | Year 4 Comp | Year 5 Comp | Gross Income Per Product Line
Gerber | 0 | 0.005 | 0 | 0.005
Sentinel | 0 | 0.005 | 0 | 0.005
Pan American | 0 | 0.005 | 0 | 0.005
National Health | 0 | 0.005 | 0 | 0.005
Forethought | 0 | 0.005 | 0 | 0.005
Final Expense | 0 | 0.025 | 0 | 0.005
LTC/Annuity | 100000000 | 0.005 | 0 | 0
 |  |  |  | Total
*This does not reflect overrides the marketing companies would generate over the next 5 year on Med Supplement and additional products.
FE Average Size | 1
Annuity Average Size | 1
HSBC Relationship
Deposits | 300000000
Product 1 | 0.67
Product2 [NAME] | 0.33
Average Size | 20000
Annual Growth Factor | 0.1
Potential Product Development Opportunities | Anticipated Premium | PDG Fee Year 1 | App fee | [NAME] | 1st Year Comp | Year 2 Comp | Year 3 Comp | Year 4 Comp | Year 5 Comp | Gross Income Per Product Line
Market Linked CD 1 |  | 0.0025 | N/A | N/A
Market Linked CD 2* | 100000000 | 0.00125 | N/A | N/A
 |  |  |  | Total
*Without [NAME]
Spreadsheet: 771333d1646634775-highlight-cells-that-have-matching-sequences-of-letters-example
Sheet: Sheet1

x
A
B
B
B
B
A
B
A
B
B
A
A
A
B
A
B
B
A
B
B
A
A
A
A
B
B
A
A
A
A
B
B
A
A
A
B
A
B
B
A
A
x
A
A
A
A
A
Spreadsheet: mary_fischer__25606__31Z
Sheet: E15.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  031Z
COMPANY NAME    LINC
ANALYSIS OF MINORITY INTERESTS
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  | E-15
 |  |  |  | 12-31-2000 Balance
 |  |  |  | BEGINNING |  | AMOUNT |  |  |  |  |  | 12-31-2001
[NAME] OR ENTITY |  | ENRON'S |  | BALANCE |  | PER INCOME |  | OTHER |  |  |  | BALANCE
 |  | OWNERSHIP % |  | DR. (CR.) |  | STATEMENT |  | AMOUNT |  | (DESCRIBE) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Minority Interest | * |  |  |  |  |  |  |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 0855  DR/(CR)
Spreadsheet: 770988d1646375942-help-with-royalty-scale-calculation-royalty
Sheet: 2020

 |  |  |  |  |  |  |  |  |  | 2020
article | EAN | publishing date | retail price | net retail price | title | original title | series | printed copies | remaining copies from 2019 sales | sold copies | gross turnover at net retail price HUF | royalty up to 6000 copies: 8% on gross turnover HUF | royalty up to 6000 copies: 8% on gross turnover EUR | royalty up to 12.000 copies: 10% on gross turnover HUF | royalty up to 12.000 copies: 10% on gross turnover EUR | royalty thereafter: 12% on gross turnover HUF | royalty thereafter: 12% on gross turnover EUR | royalty total HUF | royalty total EUR | royalty advance paid (remaining from 2019) | royalty to be paid
 |  |  | 1699 |  | title 1 |  |  |  | 2878 | 1301
 |  |  | 1699 |  | title 2 |  |  |  | 491 | 337 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020 Total:
2020 | exchange rate (EUR/HUF): |  |  | 351.17
Spreadsheet: 668589d1584909736-hundreds-of-row-hundreds-of-tabs-there-has-to-be-a-faster-way-sample
Sheet: Index

Item # | CLIN | Line Name | QTY | LOA DTC | New DTC | Sole Source | Line Manager Code | Line Value | Line Manager | [NAME] | Phone # | Alternate Line Manager | [NAME] | Phone #
001 |  | [NAME] | 12 | - |  | [NAME] | 5B | 658963552 | [NAME] | [EMAIL] | [PHONE]
002 |  | XXX D model | 2 | - |  | [NAME] | 5B | 158965356 | [NAME] |  | [PHONE]
003 |  | GE-129 | 16 | 2/9 |  | [NAME] | 8A | 935589654 | The Rock |  | [PHONE]
004 |  | Improved Programmable Display Generator | 15 | 0.4 |  | [NAME] | 5B | 69853221 | [NAME] |  | [PHONE]
005 |  | XXXXXXXXXXXXX | 28 | 9 |  | [NAME] | 3A | 225454563 | [NAME] |  | [PHONE]
006 |  | XXXXXXXXX Guidance Section | 1 | 9 |  | [NAME] | 3A | 145865 | [NAME] |  | [PHONE]
007 |  | Multi-Purpose XXXXXXXXXXXXXX | 60 | 5 |  | [NAME] | 3L | 554785142 | The Rock |  | [PHONE]
008 |  | xxxxxxxxxxMM | 15 | 0.2222222222222222 |  | [NAME] | 3J | 554482 | [NAME] |  | [PHONE]
009 |  | XXXXXXXXXXXXX | 6 | 4 |  | [NAME] | 1C | 154520 | The Rock |  | [PHONE]
010 |  | xxxxxxxxxxxxxxxxx | 36 | 0.2222222222222222 |  | [NAME] | 3G | 255412523 | [NAME] |  | [PHONE]
Spreadsheet: 825748d1681490584-verify-characters-in-same-cell-on-multiple-sheets-are-the-same-copy-2-etaf2
Sheet: 5

 |  | Allotment
SITE | PROJECT | Project Number | Actual spent | P/R
 | 2022-07-15 00:00:00 | 33608600045 |  | R
 | 2022-07-31 00:00:00 | 33608600045 |  | P
 | 2022-08-15 00:00:00 | 33608600045 |  | P
 | 2022-08-31 00:00:00 | 33608600045 |  | P
 | 2022-09-15 00:00:00 | 33608600045 |  | R
 | 2022-09-30 00:00:00 | 33608600045 |  | P
 | 2022-10-15 00:00:00 | 33608600045 |  | P
 | 2022-10-31 00:00:00 | 33608600045 |  | P
 | 2022-11-15 00:00:00 | 33608600045 |  | P
 | 2022-11-30 00:00:00 | 33608600045 |  | P
 | 2022-12-15 00:00:00 | 33608600045 |  | P
 | 2022-12-31 00:00:00 | 33608600045 |  | P
Spreadsheet: 03d348a2-4105-4b06-bc0b-07255c870bbf
Sheet: Sheet1

Table 5--Corn: Food, seed, and industrial use (million bushels), 6/14/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Mkt year and qtr 1/ |  | High-fructose corn syrup (HFCS) | Glucose and dextrose | Starch | Alcohol for fuel | Alcohol for beverages and manufacturing | Cereals and other products | Seed | Total food, seed, and industrial use
2010/11 | Q1 Sep-Nov | 126.248 | 65.111 | 66.286 | 1240.169 | 33.02 | 49.115 | 0 | 1579.949
 | [NAME] | 116.275 | 59.718 | 62.534 | 1257.314 | 34.588 | 48.575 | 0 | 1579.004
 | [NAME] | 138.897 | 70.856 | 64.409 | 1259.428 | 36.164 | 49.655 | 20.24 | 1639.649
 | [NAME] | 139.635 | 76.694 | 64.697 | 1264.303 | 31.228 | 49.655 | 2.76 | 1628.972
 | MY Sep-Aug | 521.055 | 272.379 | 257.926 | 5021.214 | 135 | 197 | 23 | 6427.574
2011/12 | Q1 Sep-Nov | 119.607 | 77.97 | 64.635 | 1268.06 | 33.02 | 50.1 | 0 | 1613.392
 | [NAME] | 114.999 | 71.005 | 62.018 | 1304.439 | 34.588 | 50.1 | 0 | 1637.149
 | MY Sep-Aug | 495 | 300 | 250 | 5050 | 135 | 200.7 | 24.3 | 6455
2012/13 | MY Sep-Aug | 500 | 300 | 265 | 5000 | 135 | 202 | 23 | 6425
1/ September-August.  Latest data may be preliminary or projected. Source: Calculated by USDA, Economic Research Service.
Date run: 6/15/2012
Spreadsheet: 10688e21-50c7-42b3-9f2f-b7d2c537a667
Sheet: W

 | COURSES IN RED  ARE GENERAL EDUCATION COURSES FOR FALL  2012 |  | PURPLE  J-TERM         GREEN BOTH FALL  & J-TERM
Women's Studies | AOK designation | CAR designation | Comment
WMST 101 | Social Sciences-Women's Studies
WMST 102 | Social Sciences-Women's Studies
WMST 202 | Social Sciences-Women's Studies |  | cross-listed with SOCI 202
 | OR Social Sciences-Sociology
WMST 281 | Social Sciences-Women's Studies
WMST 282 | Social Sciences-Women's Studies
WMST 347 | Arts & Literature-Arts
WMST 361 | Social Sciences-Women's Studies |  | cross-listed with COMM 361
WMST 382 | Social Sciences-Women's Studies |  | J-Term 2006 and Spring 2006 ( Sex & Culture)
 | OR Social Sciences-Sociology
WMST 300 & 301 | WMST 300 only | Capstone; Experiential-Research | WMST 300 & WMST 301 have the research designation
WMST 300 & 450 | WMST 300 | Capstone; Experiential-Field Studies | WMST 450 is a Field Studies course
WMST 300 & 455 | WMST 300 | Capstone
Spreadsheet: 866805d1713726778-do-not-know-how-to-perform-this-task-or-amento
Sheet: Calculos 

Cálculos UPAC
Dados Instalação
Entrada |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PdC QE Cliente |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A |  |  | Potência Inversor |  |  |  |  |  |  |  |  |  |  |  |  | 4000 | W
Inversor
Marca |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | Saída AC
Parâmetros Rede |  |  |  |  |  |  |  | Parâmetros  Inversor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cálculo Ib Monofásico - Ib = P/Us x cos φ   Trifásico - Ib = P/√3 x UC x cos φ
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rede Mono - Ib = P/Us x cos φ Trifásico Ib = P/Us x cos φ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inversor
Umin |  |  | Umax |  |  |  |  | Umin |  |  |  |  |  |  | UC |  |  |  |  | Umax |  |  |  | UC |  |  |  |  |  |  | Umin |  |  |  |  |  |  | Umax |  |  |  |  |  |  |  |  |  | Umin |  |  |  |  |  |  |  | Umax
 | V |  |  |  |  | V |  | 195.5 |  |  |  |  | V |  |  |  |  | V |  | 265.5 |  | V |  |  |  |  |  |  | V |  | Ib |  |  |  |  | A |  | Ib |  |  |  |  |  |  |  | A |  | IB |  |  |  |  |  | A |  | IB |  |  |  | A
Calcular In ( Calibre da Protecção)    In >= Ibmax    Ibmax Entre (Umin /Ib ) e  (Umax /Ib ) do Inversor
Ibmax entre Umin/Ib e Umax/Ib Inversor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A |  |  | Usando o Quadro Calibres Disjuntores |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In |  |  |  | A
[NAME]       Ib  ≤  In [NAME] , I2 = 1.45 In e I2 ≤ 1.45 Iz
1º Condição        Ib  ≤  In [NAME]
Ib |  |  |  |  | In |  |  |  |  |  |  |  |  |  |  | Métodos |  |  |  |  | A |  |  |  |  |  | Iz |  |  | PVC |  |  |  | XLPE |  |  |  |  | Secção Cabo (mm²) |  |  |  |  |  |  |  | PVC |  |  | XLPE
2º [NAME]1.45 In e  I2  ≤  1.45 IZ
Spreadsheet: 696645d1600938134-hyperlink-with-vlookup-in-another-file-book1
Sheet: J58

DATE | 2020-09-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
CUST : | TEAMATICAL
ORDER | J58-FF7754
SHIPMENT: | TBA |  |  |  |  |  |  |  |  | TOTAL
JOB.NO. | STYLE NO. NAME | FABRIC | BATCH | BUYER |  | SIZE |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  | XS | S | M | L | XL | 2XL | 3XL | 4XL
M20-2534 | 27M
 |  |  |  |  | ORDER |  | 1
 |  |  |  |  | TOTAL
Spreadsheet: 42761d1241375155-conditional-formatting-sales-config
Sheet: Annexure A

ANNEXURE A
Hardware |  |  |  | AREAS
Item Required | Total Units Needed | Pricing Per Unit | Hardware Subtotal
Proffesional Services |  |  |  | AREAS
Item Required | Total Units Needed | Pricing Per Unit | PS Total
SUBTOTAL
Software (TimeKeeper / Avm Etc ) |  |  |  | AREAS
Item Required | Total Units Needed | Pricing Per Unit | PS Total
SUBTOTAL
Total Kilomtres To Site |  |  | Total kilometres Needed |  |  |  |  | Travel Time Rate |  |  |  |  |  | Total Travel Time |  |  |  | 0
GRAND TOTAL (EX VAT)
Spreadsheet: d23accac-28c8-43cf-a74c-9eac552f8f14
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: New Residential Construction
 |  | Housing Units Authorized in Permit-Issuing Places: United States
 |  | Seasonally Adjusted Single-family Units [Thousands of Units]
 |  | Period: 1959 to 2012
 |  | Data Extracted on: October 24, 2014 (9:38 pm)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
1959
1960
1961
1962
1963
1964
1965
1966
1967
1968
1969
1970
1971
1972
1973
1974
1975
1976
1977
1978
1979
1980
1981
1982
1983
1984
1985
1986
1987
1988
1989
1990
1991
1992
1993
1994
1995
1996
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
Spreadsheet: 269422d1381156877-need-formula-for-delimited-text-to-rows-is-it-possible-adavid02-v1
Sheet: Sheet1

ATA PO Number | Extarct 1 | Extarct 2 | Extarct 3 | Extarct 4
1/4/2013 112708
1/4/2013 112708
1/4/2013 112593;112169
1/3/2013 112220;112775
1/3/2013 112649
1/8/2013 112041-2
1/4/2013 112160
1/4/2013 112453
1/9/2013 112344
1/8/2013 112853
1/4/2013 112437;112742
1/4/2013 112209
1/4/2013 112715
1/4/2013 112591
1/4/2013 112591
1/4/2013 112774;112831
1/8/2013 112120
1/3/2013 112765
1/8/2013 112600
1/7/2013 112600
1/4/2013 112873
1/4/2013 112108
1/4/2013 112108
1/4/2013 112108
1/4/2013 111926;111927
1/7/2013 112660;112664;111990
1/3/2013 112352;111875;112746;112670
Spreadsheet: michelle_lokay__26576__Dec00pnr
Sheet: Summary

Transwestern Pipeline Company
Park n Ride Service
Actual Billing Summary
Billing Month | Buyer | Purchase Order # | Contract | POI | Volume | Rate | Imputed Rate | Rate_Type Daily/Total | Invoice Amount | Remaining Balance
2000-12-01 00:00:00 |  |  |  |  |  | 3.68 |  | Total | 52414.24
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 | TOTALS
Notes:
 | 1.) Invoiced amount reflects posted rates with following exceptions…
 | 2.) USGT @ 500615 - Nov.- Dec. deal @ $3.68/Dth
 | 3.) PNM @  500617 includes Ride for 2 days (Dec 19th & 20th) @ $0.45/Dth
 | 4.) Park charges were waived on December 8th because rides were restricted
Spreadsheet: 740272d1626263317-grouping-of-child-parts-and-sun-in-parent-in-hierarchy-multilevel-trail-1234
Sheet: Sheet1

 | Sr No | Level 1 | Level2 | Level3 | Level 4 | Recived Data | Result from Excel | Description | [NAME] as
 | 1 | K |  |  |  |  |  | Level 1 = additional of all level 2 qty only
 | 2 |  | A |  |  | 1 | 1 | Level 2 Qty | Level 4 : | Level 4 Contains child  item M and N with there quantity
 | 3 |  | B |  |  | 1 | 1 | Level 2 Qty | Level 3 : | Level 3 - Qty  of Q is sum  Qty  of M and N in Level 4 (Childs )
 | 4 |  | C |  |  |  |  | Level 2 Cost - Addition of all Level 3 qty | Level 2 : | Level 2 - Qty  of C is sum of P and Q in level 3 (Childs )
 | 5 |  |  | P |  | 3 | 3 |  | Level 1: | Top item k is sum of  all A to F Qty
 | 6 |  |  | Q |  |  |  | Level 3 Qty -Addition of Level 4 Qty
 | 7 |  |  |  | M | 2 | 2 |  | Remarks | [NAME]  of each level in the tree /Hierarchy
 | 8 |  |  |  | N | 3 | 3 |  |  | Should Not include blank as it appears in Pie charts graphs
 | 9 |  | D |  |  | 1 | 1 | Level 2 Qty |  | Can it possible to get pivot table report in hierarchy to connect in power view
 | 10 |  | E |  |  | 2 | 2 | Level 2 Qty
 | 11 |  | F |  |  | 1 | 1 | Level 2 Qty