tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 103375d1301097216-build-new-list-copying-entire-registry-meeting-specific-criteria-from-another-list-example-analysis
Sheet: PostSaleTrend

COMPANY | COUNTRY | SURVEY RESPONSE SOURCE | DATE OF THE RESPONSE | OVERALL POST-SALES SATISFACTION | PROACTIVE ISSUE IDENTIFICATION/RESOLUTION | PROFESSIONALISM IN ALL ENGAGEMENTS | ABILITY TO DIAGNOSE ISSUES | EFFECTIVENESS OF PROBLEM ESCALATION | TIMELY CLOSURE OF SUPPORT PROBLEMS | EFFECTIVENESS OF PROFESSIONAL SERVICES | LESS THAN SATISFIED EXPLANATION | CONTACT NAME | CONTACT COMPANY | CONTACT EMAIL | CONTACT PHONE
Example | US | CISCO_ENTRY | 2010-05-11 00:00:00 | 5 | 5 | 5 | 5 | 5 | 4 | 5 |  | [NAME] | Car Company
Example | US | PAL_ENTRY | 2010-06-21 00:00:00 | 3 | 3 | 3 | 4 | 3 | 4 | 3 |  | Not Available | [NAME]
Example | US | PAL_ENTRY | 2010-08-04 00:00:00 | 5 | 4 | 4 | 5 | 4 | 4 | 5 |  | [NAME] | Insurance Co
Example | US | PAL_ENTRY | 2010-08-05 00:00:00 | 3 | 5 | 5 | 5 | 5 | 5 | 5 |  | [NAME] | TV Conglomerate
Example | US | PAL_ENTRY | 2010-08-07 00:00:00 | 4 | 4 | 4 | 4 | 4 | 3 | 4 |  | Arthur D | Bank
Example | US | PAL_ENTRY | 2010-08-09 00:00:00 | 2 | 5 | 5 | 5 | 5 | 5 | 4 |  | July W | Containers
Example | US | PAL_ENTRY | 2010-08-09 00:00:00 | 5 |  |  |  |  |  |  |  | [NAME] | Food Inc
Example | US | PAL_ENTRY | 2010-08-12 00:00:00 | 1 | 4 | 4 | 4 | 4 | 4 | 4 |  | [NAME] T | Milk and Stuff
Example | US | PAL_ENTRY | 2010-08-12 00:00:00 | 5 | 5 | 4 | 4 | 5 | 5 | 4 |  | [NAME] | Citrus
Example | US | PAL_ENTRY | 2010-08-16 00:00:00 | 3 | 4 | 4 | 4 | 4 | 3 | 4 |  | [NAME] | City Government
Example | US | PAL_ENTRY | 2010-08-19 00:00:00 | 2 | 3 | 4 | 4 | 4 | 4 | 4 |  | Not Available | City Government
Example | US | PAL_ENTRY | 2010-08-19 00:00:00 | 2 | 4 | 4 | 4 | 4 | 4 | 4 |  | [NAME] | Bank
Spreadsheet: 735422d1622979597-index-match-formula-to-conditionally-compile-missing-data-index-match-formula-to-pull-missing-data-example
Sheet: Issue Fee Analysis

 | *Column should only include data that starts with "Issue Fee"
 | Lookup
1
2 | Issue [NAME] B
3 | Issue FeeProduct ACustomer G
4 | Issue FeeProduct ACustomer H
5 | Issue [NAME] I
6 | Issue FeeProduct ACustomer A
7 | Issue [NAME]
8 | Issue FeeProduct CCustomer H
9 | Issue [NAME] I
10 | Issue FeeProduct CCustomer A
11
12
Spreadsheet: 691419d1597683925-formula-based-on-variable-cells-and-values-example1832
Sheet: P1

CELLS THIS COLOUR ARE TO BE TYPED IN
CELLS THIS COLOUR ARE DROP DOWN CHOICES
CELLS THIS COLOUR SELF POPULATE
 | Sprinkler Bracket Take-Off P1
Section 1: General Details
Contract Name: |  |  |  |  |  |  | Contract Number:
Delivery Address: |  |  |  |  |  |  | Post Code:
Completed By: |  |  |  |  |  |  | Designer:
Date: |  |  |  |  |  |  | Revision:
Standard:
Section 2: Designer Details
Drawing Number:
Drawing Area:
Drawing Approved By: |  |  |  |  |  |  | Approval Date:
Section 3: Bracket Requirements
Bracket Limitations & Restrictions:
Bracket Type Requirements: Variation 1 | Reference | Description |  |  |  |  | Quantity
 | A | [NAME] |  |  |  |  | 1
 | B | Allthread Rod |  |  |  |  | 200
 | C | Flange Nuts |  |  |  |  | 4
 | D | Filbows 25mm - 65mm |  |  |  |  | 1
Section 4: Component Quantities
Pipe Size: | 25 mm | 32 [NAME] | 40 mm | 50 mm | 65 mm | 80 mm | 100 mm | 150 mm | 200 mm | 250 mm | 300 mm | 350 mm | 400 mm
Number of Brackets: | 1 |  | 1 |  |  | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Section 5: Dimensions
Pipe Size: | 25 mm | 32 [NAME] | 40 mm | 50 mm | 65 mm | 80 mm | 100 mm | 150 mm | 200 mm | 250 mm | 300 mm | 350 mm | 400 mm
Length of X in mm: |  |  |  |  |  | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Section 6: Component Breakdown
Type | Stock Code |  |  | Stock Description |  |  |  | Quantity |  | Price | Qty Price | Location
Channel & Accessories |  |  |  | [NAME] |  |  |  |  |  | 0.01 |  | AA
Hangers |  |  |  | Filbows LPCB Approved 25 mm |  |  |  |  |  | 0.01 |  | AB
Hangers |  |  |  | Filbows LPCB Approved 32 [NAME] |  |  |  |  |  | 0.01 |  | AC
Hangers |  |  |  | Filbows LPCB Approved 40 mm |  |  |  |  |  | 0.01 |  | AD
Hangers |  |  |  | Filbows LPCB Approved 50 mm |  |  |  |  |  | 0.01 |  | AE
Hangers |  |  |  | Filbows LPCB Approved 65 mm |  |  |  |  |  | 0.01 |  | AF
Nuts & Washers |  |  |  | Flange Nuts |  |  |  |  |  | 0.01 |  | AG
Sets / Bolts/ Screws |  |  |  | Allthread Rod |  |  |  |  |  | 0.01 |  | AH
Total Price Per Bracket
Total Price Per Number of Brackets:
Spreadsheet: 477974d1472588042-conditional-formatting-comparing-two-sets-of-data-format-if-no-match-book1
Sheet: Sheet1

 | CLIENT |  |  |  | Rate |  |  |  |  |  |  | CL Code |  |  | %
 | CodeA |  |  |  | 0.17 |  |  |  |  |  |  | CodeA |  |  | 0.17
 | CodeF |  |  |  | 0.2 |  |  |  |  |  |  | CodeB |  |  | 0.18
 | CodeA |  |  |  | 0.17 |  |  |  |  |  |  | CodeC |  |  | 0.19
 | CodeB |  |  |  | 0.18 |  |  |  |  |  |  | CodeD |  |  | 0.18
 | CodeI |  |  |  |  |  |  |  |  |  |  | CodeE |  |  | 0.19
 | CodeG |  |  |  | 0.18 |  |  |  |  |  |  | CodeF |  |  | 0.2
 | CodeE |  |  |  | 0.19 |  |  |  |  |  |  | CodeG |  |  | 0.18
 | CodeC |  |  |  | 0.19 |  |  |  |  |  |  | CodeH |  |  | 0.19
 | CodeA |  |  |  | 0.71 |  |  |  |  |  |  | CodeI |  |  | 0.18
Spreadsheet: 409068d1437602825-hours-breakdown-ordinary-o-time-1-5-and-o-time-2-0-example
Sheet: Sheet1

Date | Name | Start | Finish | Ordinary | O/T 1.5 | O/T 2 | Total hrs
Wednesday 22 July 2015 | [NAME] | 22:00:00 | 05:00:00
2015-07-23 00:00:00 | [NAME] | 09:00:00 | 18:00:00
2015-07-24 00:00:00 | [NAME] | 06:00:00 | 20:00:00
2015-07-25 00:00:00 | [NAME] | 16:00:00 | 05:00:00
2015-07-26 00:00:00 | [NAME] | 16:00:00 | 05:00:00
Spreadsheet: 635937d1565088573-help-automatic-an-excel-calculation-example-rev-1
Sheet: Sales Price

Distributor Product Price | Selling Platform Fee | Tax on Sale | Profit | Profit % | Tax on Purchase | Net Sale | S+U:Uelling Price
100 |  |  |  |  |  |  | 140.86
100 |  |  |  | 0.1
25
50
75
100
125
150
175
200
Spreadsheet: 7532c513-de6e-4962-af64-4ef620c069d0
Sheet: Sheet1

Cell Type | Symbols | Lineage | Cell surface markers | Fig.3 | Fig.5
Hematopoietic Stem Cell | HSC1 | HSC | CD133+ CD34dim | Yes | Yes
Hematopoietic Stem Cell | HSC2 | HSC | CD38- CD34+ | Yes | No
Common Myeloid Progenitor | CMP | CMP | CD34+ CD38+ IL-3Rlo CD45RA- | Yes | Yes
[NAME]/Erythroid Progenitor | MEP | MEP | CD34+ CD38+ IL-3R- CD45RA- | Yes | Yes
Granulocyte-Monocyte Progenitor | GMP | GMP | CD34+ CD38+ IL-3Rlo CD45RA+ | Yes | Yes
Erythroid | [NAME] | ERY | CD34+ CD71+ GlyA- | Yes | Yes
Erythroid | ERY2 | ERY | CD34- CD71+ GlyA- | Yes | Yes
Erythroid | ERY3 | ERY | CD34- CD71+ GlyA+ | Yes | Yes
Erythroid | ERY4 | ERY | CD34- CD71lo GlyA+ | Yes | Yes
Erythroid | ERY5 | ERY | CD34- CD71- GlyA+ | Yes | Yes
Colony Forming Unit-Megakaryocytic (CFU-MK) | MEGA1 | MEGA | CD34+ CD41+ CD61+ CD45- | Yes | Yes
Megakaryocyte | MEGA2 | MEGA | CD34- CD41+ CD61+ CD45- | Yes | Yes
Colony Forming Unit-Granulocyte (CFU-G) | GRAN1 | GRAN | [NAME] CD45+ CD11b- CD16- | Yes | Yes
[NAME] | GRAN2 | GRAN | [NAME] CD45+ CD11b+ CD16- | Yes | Yes
Neutrophil | GRAN3 | GRAN | [NAME] CD16+ CD11b+ | Yes | Yes
Colony Forming Unit-Monocyte (CFU-M) | MONO1 | MONO | CD34- CD33+ CD13+ | Yes | Yes
Monocyte | MONO2 | MONO | [NAME] CD14+ CD45dim | Yes | Yes
Basophil | BASO1 | BASO | [NAME] CD22+ CD123+ CD33+/- CD45dim | Yes | Yes
[NAME] | EOS2 | EOS | [NAME] CD33dim+ | Yes | Yes
Early B Cells | PREB1 | PREB | CD34+ CD10+ CD19+ | Yes | Yes
Pro-B Cells | PREB2 | PREB | CD34- CD10+ CD19+ | Yes | Yes
Spreadsheet: john_zufferli__16821__Can Gas Stack & Website for New Version 121901
Sheet: CAN Gas - Stack

STACK MANAGER ACCESS |  |  |  | Read
Canada Gas |  |  |  | Execute
 |  |  |  | None
Name | User ID | Position | Tenor  (1-120 Months) | CAN Gas Fin BasSwap (1062) | CAN Gas Fin BasSwap East (1280) | CAN Gas Fin Option (1992) | CAN Gas Fin Swap (1063) | CAN Gas Fin Swap (Internal Only) (1984) | CAN Gas Fin Swap East (1278) | CAN Gas Straddle Option (2021) | CAN Gas Phy Basis East Spd <or= 1Mo (2131) | CAN Gas Phy Basis East Spd >1Mo<1Yr (2132) | CAN Gas Phy Basis Firm East <or= 1Mo (1184) | CAN Gas Phy Basis Firm East >1Mo<1Yr (1185) | CAN Gas Phy Basis Firm West <or= 1Mo (2128) | CAN Gas Phy Basis Firm West >1Mo<1Yr (2129) | CAN Gas Phy Fwd Firm East <or= 1Mo (1179) | CAN Gas Phy Fwd Firm East Spd <or= 1Mo (2193) | CAN Gas Phy Fwd Firm West <or= 1Mo (1182) | CAN Gas Phy Fwd Firm West >1Mo<1Yr (1183) | CAN Gas Phy Index Firm East <or= 1Mo (2114) | CAN Gas Phy Index Firm East >1Mo<1Yr (2115) | CAN Gas Phy Index Firm West <or= 1Mo (1186) | CAN Gas Phy Index Firm West >1Mo<1Yr (1187)
[NAME] | RWATT | AECO Cash Trader | 1 | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Execute | Read | Read | Read | Execute | Read | Read | Read | Execute | Read
[NAME] | MCOWAN | AECO Cash Trader | 36 | Execute | Read | Read | Execute | Execute | Read | Read | Read | Read | Read | Read | Execute | Execute | Read | Read | Execute | Execute | Read | Read | Execute | Execute
[NAME] | [NAME] | AECO Term Trader | 36 | Execute | Read | Read | Execute | Execute | Read | Read | Read | Read | Read | Read | Execute | Execute | Read | Read | Execute | Execute | Read | Read | Execute | Execute
Stephane Brodeur | [NAME] | BC Cash Trader | 1 | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Execute | Read | Read | Read | Execute | Read | Read | Read | Execute | Read
[NAME] | CCLARK5 | BC Cash Trader | 36 | Execute | Read | Read | Execute | Execute | Read | Read | Read | Read | Read | Read | Execute | Execute | Read | Read | Execute | Execute | Read | Read | Execute | Execute
[NAME] | CDORLAN | BC Term Trader | 36 | Execute | Read | Read | Execute | Execute | Read | Read | Read | Read | Read | Read | Execute | Execute | Read | Read | Execute | Execute | Read | Read | Execute | Execute
Lon Draper | LDRAPER | Options Trader | 24 | Read | Read | Execute | Read | Read | Read | Execute | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read
Cooper Richey | CRICHEY | Power Trader | 24 | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read
[NAME] | JZUFFER | VP-Canada Trading | [NAME] | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read
Spreadsheet: 769031d1645263206-invoices-collected-in-the-next-12-months-from-the-report-date-ex
Sheet: Collections

Collection date | Invoice number | Collected value
 | Other invoice
 | Other invoice
 | Other invoice
 | Other invoice
 | Other invoice
 | Other invoice
 | Other invoice
 | Other invoice
2019-06-17 00:00:00 | Invoice A | 100
2019-07-22 00:00:00 | Invoice B | 110
 | Other invoice
 | Other invoice
 | Other invoice
 | Other invoice
 | Other invoice
 | Other invoice
 | Other invoice
 | Other invoice
 | Other invoice
2020-01-04 00:00:00 | Invoice H | 170
 | Other invoice
Spreadsheet: 817504d1676287338-find-value-in-worksheet-then-copy-all-values-in-that-column-directly-below-sample-tenancy-schedules
Sheet: Sample 2

 | [NAME]
 | TENANT NAME | Area | Lease Start | Lease end | Break | Annual Rent | RENT PAYMENT DATE | NEXT PAYMENT DATE | S/C PER ANNUM | S/C PSF
 | Tenant 1 | 150 | 2018-09-01 00:00:00 | 2023-09-01 00:00:00 | 2022-09-01 00:00:00 | 10000 | EQD | 2021-03-25 00:00:00 | 164103.98
 | [NAME] | 250 | 2018-10-01 00:00:00 | 2023-10-01 00:00:00 | 2022-10-01 00:00:00 | 5000 | EQD | 2021-03-25 00:00:00 | 177059.26
 | Tenant 3 | 350 | 2018-11-01 00:00:00 | 2023-11-01 00:00:00 | 2022-11-01 00:00:00 | 10000 | EQD | 2021-03-25 00:00:00 | 206959.51
 | Vacant | 450 |  |  |  | 10000 | EQD | 2021-03-25 00:00:00 | 211509.55
 | [NAME] | 550 | 2019-01-01 00:00:00 | 2024-01-01 00:00:00 | 2023-01-01 00:00:00 | 5000 | EQD | 2021-03-25 00:00:00 | 218323.4
 | Tenant 5 | 650 | 2019-02-01 00:00:00 | 2024-02-01 00:00:00 | 2023-02-01 00:00:00 | 5000 | EQD | 2021-03-25 00:00:00 | 126201.93
 | Tenant 6 | 750 | 2019-03-01 00:00:00 | 2024-03-01 00:00:00 | 2023-03-01 00:00:00 | 10000 | EQD | 2021-03-25 00:00:00 | 90653.35
 | Tenant 7 | 850 | 2019-04-01 00:00:00 | 2024-04-01 00:00:00 | 2023-04-01 00:00:00 | 10000 | EQD | 2021-03-25 00:00:00 | 211307.82
 | Tenant 8 | 950 | 2019-05-01 00:00:00 | 2024-05-01 00:00:00 | 2023-05-01 00:00:00 | 10000 | EQD | 2021-03-25 00:00:00 | 146385.72
 | Reception | 1050 | 2019-06-01 00:00:00 | 2024-06-01 00:00:00 | 2023-06-01 00:00:00 | 5000 | EQD | 2021-03-25 00:00:00 | - | -
 | Tenant 9 | 1150 | 2019-07-01 00:00:00 | 2024-07-01 00:00:00 | 2023-07-01 00:00:00 | 10000 | EQD | 2021-03-25 00:00:00 | - | -
 | VACANT | 1250 |  |  |  | 5000 | EQD | 2021-03-25 00:00:00 | - | -
 | Tenant 10 | 1350 | 2019-09-01 00:00:00 | 2024-09-01 00:00:00 | 2023-09-01 00:00:00 | 10000 | EQD | 2021-03-25 00:00:00 | - | -
 | VACANT | 1450 |  |  |  | 5000 | EQD | 2021-03-25 00:00:00 | 44659.86
 | Tenant 11 | 1550 | 2019-11-01 00:00:00 | 2024-11-01 00:00:00 | 2023-11-01 00:00:00 | 5000 | EQD | 2021-03-25 00:00:00 | 58410.84
 | Tenant 12 | 1650 | 2019-12-01 00:00:00 | 2024-12-01 00:00:00 | 2023-12-01 00:00:00 | 10000 | EQD | 2021-03-25 00:00:00 | 28140.76
 | Vacant | 1750 |  |  |  | 5000
 | Management Office | 1850 | 2020-02-01 00:00:00 | 2025-02-01 00:00:00 | 2024-02-01 00:00:00 | 10000 | EQD | 2021-03-25 00:00:00 | - | -
 | SUBTOTAL
 | TOTAL
Spreadsheet: 189417d1351182703-ho-to-get-only-one-price-if-you-have-two-columns-with-diffident-prices-in-invoice
Sheet: Invoice

Cash
Check |  | Insert Company Information Here |  |  |  |  |  |  |  |  | Invoice No.
Credit
Other
 |  |  |  |  |  |  |  |  |  |  |  | Invoice
 |  | Customer |  |  |  |  |  |  |  |  | Misc |  |  |  | Client Name
 |  | Name |  |  |  |  |  |  |  |  | Date |  |  |  | 3
 |  | Address |  | Address 2 |  |  |  |  |  |  | Order No.
 |  | City |  |  |  | P code
 |  | Phone
 |  | Qty | Description |  |  |  |  |  |  | Sales Price | Unit Price | TOTAL |  |  | Product Code
 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  | =IF(A3="","",A3)
 |  |  |  |  |  |  |  |  |  |  | SubTotal
 |  |  |  |  |  |  |  |  |  |  | Shipping
 |  | Payment | Select One… |  |  |  |  |  | Tax Rate(s)
 |  | Comments |  |  |  |  |  |  |  |  | TOTAL
 |  | Name
 |  | CC # |  |  |  |  |  |  | Office Use Only
 |  | Expires
 |  | [NAME] Here
 |  |  | [NAME] Here
Spreadsheet: 713438d1610717756-hyperlink-formula-sample
Sheet: SHEET

CLIENT | Next Unpaid Link | 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 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48
[NAME] |  | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00
[NAME] |  | 2021-01-10 00:00:00
[NAME] |  | 2021-01-12 00:00:00
Spreadsheet: 40632d1239033146-excel-2007-excel-graph-axis-switching-flow-duration-curves-and-data1
Sheet: my problem

Cumulative Frequency (%) | Midpoints |  | Im trying to reverse the axis for the % on the X and midpoints on the Y and i have 100's of these to do
100 | 0.05
89.15318744053282 | 0.07500000000000001
73.17341879913866 | 0.15
56.4875557113526 | 0.35
30.97801592468326 | 0.75
16.99133657168611 | 1.25
10.67154088837698 | 1.75
7.22119284891582 | 2.25
5.012769793179428 | 2.75
3.710751665080875 | 3.25
2.76428464119385 | 3.75
1.988081526365867 | 4.25
1.482297561219891 | 4.75
1.156793029195253 | 5.5
0.6460013020181281 | 6.5
0.375582152336121 | 7.5
0.2453803395262657 | 8.5
0.1352095748410035 | 9.5
0.03505433421803796 | 11
0.01502328609344484 | 13
0.00500776203114828 | 15
0.00500776203114828 | 17
0 | 19
0 | 22.5
0 | 27.5
0 | 32.5
0 | 37.5
Spreadsheet: 721869d1614907674-calculate-communicated-wait-time-calculating-wait-times-for-batch-orders-jasperd-
Sheet: Sheet1

Time | [NAME]. | Baked | Avail |  | [NAME]. | 25 | 20 | 40 | 10 | 5
15 | 25 | 20 | -5
30 | 20 | 15 | -10
45 | 40 | 20 | -30
60 | 10 | 25 | -10
75 | 5 | 30 | 5
 |  |  |  |  | Wait time
Spreadsheet: 749121d1632513177-extract-data-from-sheet-to-another-sheet-based-on-selected-month-trial-version
Sheet: List2

Month | Aug
Name | Last name | Address | Adress | arival | departure
Spreadsheet: 069f88e0-465a-42d4-8321-75dd10e0e56a
Sheet: 검사배정상황부

일일업무계획
 |  |  |  |  |  |  |  |  |  |  | 계 | 주  무 | 소  장
 | 업무세부내역
 | * 총 검사건수 : 35건  * 건조식물 검역(수입) : 2건 * 냉동식물 검역(수입) : 11건(냉동고추 2건) * 수출검역 : 열처리 증명서 발급 6건, 무종자 1건 * 기타사항 : CIQ 1건, 검사제외 2건, 금지품제외 4건, 소독 7건, 각재 1건
평택사무소
2012-08-10 00:00:00
[ 오 전 검 사 ]
검사장소 | 접수번호 | [NAME] | 검 사 |  | 내용 | 수량(kg) | 비고(차량)
 |  |  | 수출입자 | 품목
동부두 | 7147 | 백상한 |  | 등나무 바구니 |  | 4개 | [NAME]
평택컨테이너터미널 | 7148 |  |  | 코푸라분말 |  | 23000 |  | 세림방역(주)
 | 7149 |  |  | [NAME] |  | 24000 | 서류검사 | (주)서해방역
 | 7150 |  |  | 냉동무청시래기 |  | 46000 |  | 대림방역(주)
 | 7151 |  |  | 냉동열무 |  | 23000
 | 7152 |  |  | 냉동고사리 |  | 21450 | 서류검사
 | 7153 |  |  | [NAME] |  | 20000 | 서류검사
 | 7154 |  |  | 밀짚모자 |  | 3779.5 | [NAME]
 | 7155 |  |  | 아카시아나무각재 |  | 83㎥
 | 7156 |  |  | 냉동단호박 |  | 7000 | Spot Check
 |  |  |  | 냉동근대 |  | 16000
돌코리아 | 6984 | 김재열 |  | 파인애플 | 1474 | 65520 | 무쏘 MB | 2012.08.10 11:00 | 돌로지스틱스보세창고
 | 6985 |  |  | 파인애플 | 1477 | 48360 |  | 2012.08.10 11:00 | 돌로지스틱스보세창고
 | 7029 |  |  | 파인애플 | 1480 | 17820 |  | 2012.08.10 11:00 | 돌로지스틱스보세창고
 | 6848 |  |  | 바나나 | 1423 | 7449 | EF | 2012.08.10 10:00 | 돌로지스틱스보세창고
 | 7027 |  |  | 바나나 | 1452 | 70200 |  | 2012.08.10 10:00 | 돌로지스틱스보세창고
 | 7031 |  |  | 바나나 | 1468 | 12636 |  | 2012.08.10 10:00 | 돌로지스틱스보세창고
스미후루 | 7061 |  |  | 바나나 | 7957 | 68640 | EF | 2012.08.10 10:30 | 스미후루코리아보세창고
[오 후 검 사]
검사장소 | 접수번호 | [NAME] | 검사 |  | 내용 | 수량(kg) | 비고(차량)
 |  |  | 수출입자 | 품목
스미후루 |  | 김재열 | 바나나, 파인애플 개방 |  |  |  | 무쏘
돌코리아
평택항만물류 | 7160 | 김윤정 |  | 미생물배양체(LACTIC ACID BACTERIA LGG) |  | 25 | 금지품제외
 | 7161 |  |  | [NAME]) |  | 6 | 금지품제외
 | 7162 |  |  | 미생물배양체(F-DVS BMY-01) |  | 96 | 금지품제외
 | 7163 |  |  | 미생물배양체(L10) |  | 4.6 | 금지품제외
경평물류 | 7120 |  |  | 들깨가루 |  | 30000
[NAME] | 7158 |  |  | 냉동고추 |  | 120000
영진보세창고 | 7157 |  |  | 냉동고추 |  | 66000
 | 7159 |  |  | 냉동다진마늘 |  | 48000 | 서류검사
슈퍼마린 | 7165 |  |  | 냉동부추 |  | 23000
 |  |  |  | 냉동대파 |  | 23000
합계 |  |  |  | 시간 | 총인원 | 상인
CIQ | 오승용 | 박종호 | 일조 | 14:30:00 | 526 | 7
 |  | 오승용 | 열처리증명서 6건
민원 |  | 내근자 | 민원업무처리
수출검사 |  | 내근자 | 무종자 일본수출검사 1건 (코레곤)
기타 | * [NAME], 박종호): 오전 (베르나)                                                                               * 검사장소 [NAME], 구윤모): 오후 (모닝)
* 김복섭, 정래동, 이상화 : 연가
Spreadsheet: 140010d1328584717-changing-a-cells-color-based-on-other-other-cell-values-conditional-formatting-based-on-cell
Sheet: Sheet1

Job Code | Job Description
GENUT1 | GENUT1   - General Utility
GENUT2 | GENUT2   - General Utility, [NAME]
GENUT3 | GENUT3   - General Utility, QC
GENUT4 | GENUT4   - General Utility, Forklift
GENUT5 | GENUT5   - General Utility, [NAME]
GRPLDR | GRPLDR   - Group Leader
GRPLDR3 | GRPLDR3  - Group Leader-QC
GRPLDR4 | GRPLDR4  - Group Leader-S/R
GRPLDR5 | GRPLDR5  - Group Leader, [NAME]
GRPLDR7 | GRPLDR7  - Group Leader-Maintenance
MECH | MECH     - Mechanic, Maintenance
GRNDKPR | [NAME]
Spreadsheet: 744864d1629500192-averaging-rents-based-on-two-criteria-tsprtn-excelforumsample
Sheet: Sheet1

Name | 5X10 | 10X10 | 10X15 | 10X20 | 10X30 | 5X5 CC | 5X10 CC | 10X10 CC | 10X15 CC | 10X20 CC | 10X30 CC | Impr. Rating |  |  | sq ft | market rent |  | subject impr. rating
Sq ft | 50 | 100 | 150 | 200 | 300 | 25 | 50 | 100 | 150 | 200 | 300 |  |  |  | 25 |  |  | B
 | 69 | 99 | 119 | 159 |  |  | 84 | 119 | 169 | 204 |  | A |  |  | 50
 |  |  | 117 |  |  |  | 82 |  |  |  |  | B |  |  | 100
 | 62 | 90 | 119 | 144 | 194 |  | 81 | 126 | 152 | 189 |  | A |  |  | 120
 |  |  |  |  |  |  | 84 | 125 | 158 | 215 |  | A |  |  | 150
 | 55 | 79 | 99 | 114 | 145 | 50 | 70 | 109 | 139 | 164 | 211 | A
 |  | 79 |  | 139 |  |  |  |  |  |  |  | C
Spreadsheet: 787927d1658158145-how-can-i-collect-and-join-data-corresponding-to-another-columns-data-book
Sheet: Sheet2

Year | Voucher Date | Sr. # | Debit Amount |  | Credit Amount
2022 | 01/07/2021 | 192103 | Invoice No. NHPL/SIN/0621/000119 Dated :01-JUN-21 Of |  | 300000
 |  |  | NISHAT HOTELS & PROPERTIES LIMITED (EMPORIUM
 |  |  | MALL)  FMO JUN-2021 Eid Range ( EF )-2021
2022 | 01/07/2021 | 192118 | INV# [PHONE],[PHONE] COMMISSION ON TVC |  | 17691
 |  |  | MEDIA ADS LINEN SUMMER(S)-VOL.1-2021
2022 | 01/07/2021 | 192118 | INV# |  | 589686
 |  |  | [PHONE],[PHONE],[PHONE],[PHONE],21052059
 |  |  | 27 TVC MEDIA ADS LINEN SUMMER(S)-VOL.1-2021
2022 | 14/07/2021 | 192104 | Invoice No. NHPL/SIN/0721/000001 Dated :01-JUL-21 Of |  | 300000
 |  |  | NISHAT HOTELS & PROPERTIES LIMITED (EMPORIUM
 |  |  | MALL)  FMO JUL-2021 Eid Range ( EA )-2021
2022 | 15/07/2021 | 192170 | Invoice No. Debit Note#NL/CR-N/P0020/06/2021 Date :30- |  | 0
 |  |  | JUN-21 Of DIAL ZERO (PRIVATE) LIMITED  ADJ. FOR
 |  |  | FACEBOOK REFUND LINEN ONLINE FMO APR-21
2022 | 24/07/2021 | 8422010098 | Invoice No. 024 Dated :12-JUL-21 Of HN ASSOCIATES |  | 280000
 |  |  | DASKA HOARDING RENT Eid Range ( EA )-2021
Spreadsheet: 0f8013a7-8cf7-425a-8fd0-6a95e3776892
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Cuadro 3.23-10-5
[NAME]
Egresos municipales de la región Suroeste por sub-región y provincia, según año, 1998-2007
(Valor en RD$)
[NAME] | Total egresos región sur oeste | Egresos según Sub Región Enrriquillo | Egresos según provincia Bahoruco | Egresos según provincia Barahona | Egresos según provincia [NAME] | Egresos según provincia Pedernales | Egresos según Sub Región del Valle | Egresos según provincia Azua | Egresos según provincia [NAME] | Egresos según provincia San Juan
1998 | 192539041 | 74844176 | 19790343 | 39192946 | 10607830 | 5253057 | 117694865 | 45278753 | 16771016 | 55645096
1999 | 203355728 | 85763218 | 22972851 | 45205370 | 12695677 | 4889320 | 117592510 | 44030268 | 14447671 | 59114571
2000 | 203352283 | 78265861 | 22755178 | 44333934 | 11176749 | … | 125086422 | 44422458 | 14525008 | 66138956
2001 | 205222751 | 57171720 | 29011812 | 19021295 | 8717351 | 421262 | 148051031 | 63437408 | 12559985 | 72053638
2002 | 64090162 | 15270715 | 1252602 | 10565213 | 3452900 | … | 48819447 | 48819447 | … | …
2003 | 112376035 | 62336494 | 44853710 | 6596241 | 10886543 | … | 50039541 | 50039541 | … | …
2004 | 379553819 | 215842146 | 20368555 | 128622168 | 48346184 | 18505239 | 163711673 | 79389675 | 32904607 | 51417391
2005 | 704479146 | 326817836 | 55221231 | 178682887 | 64943248 | 27970470 | 377661310 | 209133822 | 43227583 | 125299905
2006 | 741388843.55 | 441675235.79 | 79863886 | 243602231.91 | 79741274.02 | 38467843.86 | 299713607.76 | 186530381.76 | 50506329 | 62676897
2007P | 3080342614.59 | 486875027.71 | 93352100 | 283221094.05 | 16984640 | 93317193.66 | 2593467586.88 | 301288489.94 | 662179488 | 1629999608.94
(P): [NAME] preliminares
Fuentes: [NAME] y la Liga Municipal Dominicana
Spreadsheet: 169765d1343054999-excel-2007-need-cells-to-highlight-within-30-days-example
Sheet: Sheet1

account | appointment |  | training | training | inventory
1 | 2012-04-03 00:00:00 | [NAME] | N/A | 2012-04-05 00:00:00 | N/A
2 | 2011-09-20 00:00:00 | [NAME] | 2012-02-28 00:00:00 | 2012-02-29 00:00:00 | N/A
 | N/A | tom | N/A | N/A | N/A
3 | 2011-10-11 00:00:00 | [NAME] | 2012-03-07 00:00:00 | 2012-02-29 00:00:00 | 2011-10-13 00:00:00
4 | 2012-04-04 00:00:00 | sue | 2012-04-03 00:00:00 | 2012-04-03 00:00:00 | 2011-08-09 00:00:00
5 | 2011-10-06 00:00:00 | [NAME] | 2012-04-25 00:00:00 | 2012-03-07 00:00:00 | 2011-10-14 00:00:00