tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kam_keiser__17959__New Book Request TAGG PowerGas011002
Sheet: Sheet1

 | From: | Risk Management -Controls |  |  |  |  |  |  |  |  |  |  |  |  |  | Department: | Risk Management
 | Subject: | New Book Request |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
 | Requestor: | Casey Evans
 | COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  |  | BOOK INFORMATION |  |  |  |  | Reporting -Subledger
 |  |  | Type Of Transactions |  |  | Book Mapping
CP ID | Short Name | Long Name | Internal | External | Both | Code | Region | P | B | Idx | [NAME] | PHY | Y | Commodity/UOM/Curr | [NAME] | MTM/ACCRUAL | Reason For Book | Date Needed |  | MTM | Prud | Realized
166973 | PWR-GAS-MGMT | POWERGASMANAGEMENT | x |  |  | ME | NYMEX | x |  |  |  |  |  | NG/MMBTU/USD | [NAME] | MTM | Netco | ASAP
166961 | PWR-GAS-OPTION | POWERGASOPTION | x |  |  | ME | NYMEX | x |  |  |  |  |  | NG/MMBTU/USD | [NAME] | MTM | Netco | ASAP
166962 | PWR-GAS-NE | POWERGASNORTHEAST | x |  |  | ME | NYMEX | x |  |  |  |  |  | NG/MMBTU/USD | [NAME] | MTM | Netco | ASAP
166963 | PWR-GAS-MW | POWERGASMIDWEST | x |  |  | ME | NYMEX | x |  |  |  |  |  | NG/MMBTU/USD | [NAME] | MTM | Netco | ASAP
166964 | PWR-GAS-SE | POWERGASSOUTHEAST | x |  |  | ME | NYMEX | x |  |  |  |  |  | NG/MMBTU/USD | [NAME] | MTM | Netco | ASAP
166965 | PWR-GAS-ERCOT | POWERGASERCOT | x |  |  | ME | NYMEX | x |  |  |  |  |  | NG/MMBTU/USD | [NAME] | MTM | Netco | ASAP
 | (Note 1) Please ensure access to both production and stage to enter deals, calculate books and set the official flag.
 | *A unique portfolio/book code will be assigned to your book unless you request a specific portfolio/book code.
 | BOOK CANNOT BE SET UP IF THERE IS ANY MISSING INFORMATION.
 | ***Please provide login names for book administrators.***
 |  |  |  |  |  |  |  |  |  |  |  |  |  | RisktRAC Check List |  | Added (Y/N) | Processors ID
 | Book | Login |  |  |  |  |  |  |  |  |  |  |  | Created in RisktRAC
 | Administrator* | Names |  |  |  |  |  |  |  |  |  |  |  | Hierarchy
 | [NAME] | jlewis9 |  |  |  |  |  |  |  |  |  |  |  | Sent to GCP
 | [NAME] | adahlke |  |  |  |  |  |  |  |  |  |  |  | Created in TAGG/ERMS
 | Casey Evans | cevans |  |  |  |  |  |  |  |  |  |  |  | Cross-Commodity DBA
 | [NAME] | tcarter
 | [NAME] | swhite |  |  |  |  |  |  |  |  |  |  |  | PORTFOLIO NAME |  | Added (Y/N) | Processors ID
 | [NAME] | tchapm2 |  |  |  |  |  |  |  |  |  |  | ALL: | AGG-CREDIT
 | Israel Estrada | iestrada |  |  |  |  |  |  |  |  |  |  |  | AGG-PROD-DPR-BU
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AGG-PROD-DPR-CM
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DISCOUNTING USD
 |  |  |  |  |  |  |  |  |  |  |  |  | IF: | GDI
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AGG-GD-INDEX
 |  |  |  |  |  |  |  |  |  |  |  |  | IF: | Index
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AGG-INDEX
 |  |  |  |  |  |  |  |  |  |  |  |  | IF: | Gas
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AGG-GAS III & IV
Spreadsheet: darrell_schoolcraft__7792__imbalsumm0107
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 598893 | 621209
500232 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 | 542725 | 429444 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 | 653889 | 731875
500293 | 272209 | 367670
500302 |  | 6816
500303 | 120961 | 196874
500305 | 569590 | 812133
500307 | 79956 | 96425
500313 | 2540 | 1878
500314
500655 | 419870
500657 | 98579 | 108000
INDEX
2001-06-30 00:00:00 |  |  | 26156.73
2001-07-18 00:00:00
Spreadsheet: 153303d1335857767-sum-data-based-on-selection-on-dropdown-menu-excel-forum-monthly-dropdown-data
Sheet: Budget

 |  |  | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00
 | Code | Description | 2011001 | 2011002 | 2011003 | 2011004 | 2011005 | 2011006 | 2011007 | 2011008 | 2011009 | 2011010 | 2011011 | 2011012 | 2012001 | 2012002 | 2012003
Code1 | Code | Description | 2011/001 | 2011/002 | 2011/003 | 2011/004 | 2011/005 | 2011/006 | 2011/007 | 2011/008 | 2011/009 | 2011/010 | 2011/011 | 2011/012 | 2012/001 | 2012/002 | 2012/003 | Expense Category
511 | 511100 | Revenue 1 | 10117.268866 | 14808.282742 | 16522.643283 | 12305.978113 | 13585.275519 | 13390.719054 | 18252.458957 | 12711.941433 | 16192.834817 | 21084.740365 | 16313.976559 | 15175.15575749 | 1585.16862957 | 10504.924434 | 12274.5768593 | Revenue
511 | 511200 | Revenue 2 | -1.10771 | -1.26616 | -6.188016 | -1.64133 | -4.763593 | -0.37856 | -2.914215 | -3.89082 | -4.701676 | 0 | 0 | 0 | 0 | 0 | 0 | Revenue
511 | 511210 | Revenue 3 | -0.717934 | -4.683801 | -0.531143 | -5.056314 | -2.464905 | -0.957697 | -1.84393 | -1.464205 | -2.526491 | 0 | -14.576072 | -0.54928395 | 0 | -2.0433707 | 0 | Revenue
511 | 511300 | Expense 1 | 12100.516067 | 11738.453109 | 13985.480194 | 14626.776373 | 15810.85885 | 12667.030741 | 12424.523014 | 19048.240621 | 23818.118222 | 21482.48496 | 21833.536036 | 25177.90491049 | 6888.384003319999 | 15709.01866461 | 21163.15029411 | Cost 1
511 | 511601 | Expense 2 | 2624.800774 | 3134.668489 | 3939.492688 | 3668.537809 | 3831.242584 | 3735.780623 | 4013.336773 | 3463.918603 | 5093.80498 | 4502.406584 | 4347.977005 | 4691.20430824 | 1537.30298818 | 3684.6072457 | 4943.01954749 | Cost 1
511 | 511602 | Expense 3 | 4049.784368 | 4236.209767 | 5255.59007 | 5737.405905 | 5882.092259 | 4635.562802 | 4555.270073 | 7054.747206 | 7892.514632 | 7192.671982 | 7927.037343 | 9473.7987856 | 2656.10588963 | 5228.23926643 | 7178.2010205 | Cost 2
511 | 511701 | Expense 4 | -909.511773 | -1364.593421 | -1559.518719 | -861.554374 | -908.629983 | -3811.117975 | -914.773635 | -2018.151596 | -892.542879 | -3896.57136 | -1030.753325 | 249.64862754 | 0 | -883.0342034099999 | -254.07197166 | Cost 2
511 | 511702 | Expense 5 | -74.739311 | -70.175127 | -67.297455 | -64.876947 | -62.262657 | -60.193938 | -59.36356 | -114.373285 | 346.14183 | -4.940183 | -54.220692 | -46.126704 | 0 | -42.279445 | 0 | Cost 3
511 | 511710 | Expense 6 | 468.978153 | 433.393212 | 423.420424 | 437.028096 | 474.753389 | 434.517137 | 505.775163 | 367.895337 | 364.679888 | 542.574399 | 347.909261 | 263.16530241 | 0 | 261.27944721 | 274.03192251 | Cost 3
Spreadsheet: 707327d1607181150-use-of-filter-grouping-in-the-formula-loop-used-to-find-quartile-inc-excel-query
Sheet: Sheet2

Fund Name | Category | Returns | Desired Result |  |  |  | Original Data |  |  | Data Sorted by Category |  |  | Quartile Rank wihin category
ABLF | LF | 5.2 |  |  |  |  | Fund Name | Category | Returns | Fund Name | Category | Returns
ABLPF | LPF | 6.2 |  |  |  |  | ABLF | LF | 5.2 |  | LF | 5.2
CDLF | LF | 5.3 |  |  |  |  | ABLPF | LPF | 6.2 | CDLF | LF | 5.3
CDLPF | LPF | 6.3 |  |  |  |  | CDLF | LF | 5.3 | EFLF | LF | 5.6
EFLF | LF | 5.6 |  |  |  |  | CDLPF | LPF | 6.3 | GHLF | LF | 4.8
EFLPF | LPF | 6.1 |  |  |  |  | EFLF | LF | 5.6 | IJLF | LF | 3.6
GHLF | LF | 4.8 |  |  |  |  | EFLPF | LPF | 6.1 | KLLF | LF | 4.7
GHLPF | LPF | 5.8 |  |  |  |  | GHLF | LF | 4.8 | MNLF | LF | 5.1
IJLF | LF | 3.6 |  |  |  |  | GHLPF | LPF | 5.8 | OPLF | LF | 5.7
IJLPF | LPF | 5.6 |  |  |  |  | IJLF | LF | 3.6 | ABLPF | LPF | 6.2
KLLF | LF | 4.7 |  |  |  |  | IJLPF | LPF | 5.6 | CDLPF | LPF | 6.3
KLLPF | LPF | 6.8 |  |  |  |  | KLLF | LF | 4.7 | EFLPF | LPF | 6.1
MNLF | LF | 5.1 |  |  |  |  | KLLPF | LPF | 6.8 | GHLPF | LPF | 5.8
MNLPF | LPF | 6 |  |  |  |  | MNLF | LF | 5.1 | IJLPF | LPF | 5.6
OPLF | LF | 5.7 |  |  |  |  | MNLPF | LPF | 6 | KLLPF | LPF | 6.8
OPLPF | LPF | 6.2 |  |  |  |  | OPLF | LF | 5.7 | MNLPF | LPF | 6
 |  |  |  |  |  |  | OPLPF | LPF | 6.2 | OPLPF | LPF | 6.2
I am trying to create some calculations based on the quartile performance in each of the category.
Desired result arrived by sorting the data range using category and finding the quartiles for a specific category
I want to find the quartile ranks of based on the categories using formulas on the entire data range
Spreadsheet: 110833d1307435095-formula-for-counting-date-and-time-range-test-formula
Sheet: Data

Date & Time | [NAME] |  | Date | Daily Click Count
06/06/2011 08:59:06 | Opening Log File |  | 2011-06-06 00:00:00 | formula here to calculate how many pdf files were opened on this date
06/06/2011 08:59:06 | Index_File_Opened
06/06/2011 08:59:23 | PDF_File_Opened
06/06/2011 09:28:57 | PDF_File_Opened
06/06/2011 09:46:24 | Opening Log File
06/06/2011 09:46:24 | Index_File_Opened
06/06/2011 09:47:40 | PDF_File_Opened
06/06/2011 09:49:26 | PDF_File_Opened
06/06/2011 10:57:30 | PDF_File_Opened
06/06/2011 11:34:05 | Opening Log File
06/06/2011 11:34:05 | Index_File_Opened
06/06/2011 12:11:31 | Opening Log File
06/06/2011 12:11:31 | Index_File_Opened
06/06/2011 12:44:03 | Opening Log File
06/06/2011 12:44:03 | Index_File_Opened
06/06/2011 12:44:17 | Index_File_BeforeClose
06/06/2011 12:44:17 | Closing Log File
06/06/2011 14:27:54 | Opening Log File
06/06/2011 14:27:54 | Index_File_Opened
06/06/2011 14:28:18 | Index_File_BeforeClose
06/06/2011 14:28:18 | Closing Log File
06/06/2011 14:36:33 | PDF_File_Opened
06/06/2011 15:41:17 | Opening Log File
06/06/2011 15:41:17 | Index_File_Opened
06/06/2011 15:41:26 | Index_File_BeforeClose
06/06/2011 15:41:26 | Closing Log File
06/06/2011 16:21:52 | Opening Log File
06/06/2011 16:21:52 | Index_File_Opened
06/06/2011 16:22:10 | Index_File_BeforeClose
06/06/2011 16:22:10 | Closing Log File
06/06/2011 16:53:07 | Opening Log File
06/06/2011 16:53:07 | Index_File_Opened
06/06/2011 16:53:12 | Index_File_BeforeClose
06/06/2011 16:53:12 | Closing Log File
06/06/2011 17:05:09 | Index_File_BeforeClose
06/06/2011 17:05:09 | Closing Log File
Spreadsheet: 541f21ea-5399-4471-b7b1-c08eda845539
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (29 Entries):
 | 2 Analysis 2.8 Microscopes and optical image processing 2.8.1 Microscopy
No. | Company | Country | City | [NAME] | Hall/Booth
1 | 3DHISTECH Ltd | Hungary | Budapest | 1121 | A2.543
2 | AID Autoimmun Diagnostika GmbH | Germany | Straßberg | 72479 | A2.429
3 | [NAME] GmbH | Germany | Hamburg | 22297 | B1.121/220
4 | Bruker Optik GmbH | Germany | Ettlingen | 76275 | A2.331/432
5 | EO Elektronen-Optik- Service GmbH | Germany | Dortmund | 44319 | A2.522
6 | Fraunhofer-Institut für Angewandte Informationstechnik FIT | Germany | Sankt Augustin | 53757 | A1.433/530
7 | Fraunhofer-Institut für Integrierte Schaltungen IIS | Germany | Erlangen | 91058 | A1.433/530
8 | Fraunhofer-Institut für Physikalische Messtechnik IPM | Germany | Freiburg | 79110 | A1.433/530
9 | Hamamatsu Photonics Deutschland GmbH | Germany | Herrsching | 82211 | A2.415/514
10 | ibidi GmbH | Germany | Planegg/Martinsried | 82152 | A2.219
11 | Jasco Europe s.r.l. | Italy | Cremella | 23894 | A2.121/220
12 | Keyence Deutschland GmbH | Germany | Neu-Isenburg | 63263 | A2.326
13 | [NAME] | Germany | Wetzlar | 35578 | A2.205/306
14 | L&W Co., Ltd. | China | Guangzhou | 510095 | A1.241B
15 | Motic Europe - Motic Deutschland GmbH | Germany | Wetzlar | 35578 | A2.127
16 | NIKON GmbH Mikroskope | Germany | [NAME] | 40472 | A2.103/204
17 | Olympus Deutschland GmbH Mikroskopie | Germany | Hamburg | 20097 | A2.311/410
18 | [NAME] | Italy | [NAME] | 24010 | A2.316
19 | Optophase | France | Lyon | 69008 | A2.533
20 | PicoQuant GmbH | Germany | Berlin | 12489 | A2.510
21 | Prior Scientific Instruments GmbH | Germany | Jena | 07745 | A2.424
22 | Renishaw GmbH | Germany | [NAME] | 72124 | A2.520
23 | Sensovation AG | Germany | [NAME] | 78315 | A2.538
24 | SPI GmbH Scientific Precision Instruments GmbH | Germany | Oppenheim | 55276 | B2.526
25 | [NAME] | Germany | Meinerzhagen | 58540 | A2.143
26 | Thermo Scientific | Germany | Dreieich | 63303 | B1.101/202
27 | TOPTICA Photonic AG | Germany | Gräfelfing | 82166 | A1.400
28 | WITec GmbH | Germany | Ulm | 89081 | A2.406
29 | [NAME] MicroImaging GmbH | Germany | Jena | 07745 | A2.111/210
Spreadsheet: 126628d1319795174-sumproduct-looking-up-date-and-text-values-book1_squire82
Sheet: Sheet2

Month | Outcome | Total |  | Data Validation Lists > | Months |  | Outcomes
2012-04-01 00:00:00 | Review Declined |  |  |  | 2011-06-01 00:00:00 |  | Appointment Accepted
 |  |  |  |  | 2011-07-01 00:00:00 |  | Telephone Update
 |  |  |  |  | 2011-08-01 00:00:00 |  | Review Declined
 |  |  |  |  | 2011-09-01 00:00:00
 |  |  |  |  | 2011-10-01 00:00:00
 |  |  |  |  | 2011-11-01 00:00:00
 |  |  |  |  | 2011-12-01 00:00:00
 |  |  |  |  | 2012-01-01 00:00:00
 |  |  |  |  | 2012-02-01 00:00:00
 |  |  |  |  | 2012-03-01 00:00:00
 |  |  |  |  | 2012-04-01 00:00:00
 |  |  |  |  | 2012-05-01 00:00:00
Spreadsheet: 6472cf99-6759-41b5-bb21-f3a7360f5d7a
Sheet: Sheet1

Student Name and Site: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
[NAME]
Clinical Mental Health Counseling Log
 | Week 1 | Week 2 | Week 3 | Week 4
Activity | From: | From: | From: | From: | Totals
 | To: | To: | To: | To:
Individual Counseling (includes intake interviews) |  |  |  |  | 0
Group Counseling |  |  |  |  | 0
Family Counseling |  |  |  |  | 0
[NAME] |  |  |  |  | 0
Mental Status or Other Assessment/ Interpretation |  |  |  |  | 0
Other Direct |  |  |  |  | 0
Indirect Hours (e.g., case consultation, observation, paperwork, meetings, etc.) |  |  |  |  | 0
Individual/Triadic Supervision |  |  |  |  | 0
Group Supervision |  |  |  |  | 0
Total | 0 | 0 | 0 | 0 | 0
Monthly Totals | Direct |  | 0
 | Nondirect |  | 0
 | Supervision |  | 0
 | Direct Individual & Group |  | 0
Semester Totals To Date | Direct |  | 0
 | Nondirect |  | 0
 | Supervision |  | 0
 | Direct Individual & Group |  | 0
 | TOTAL HRS |  | 0
As the intern, my signature below verifies that I completed these hours AND during this time, I maintained
current liability insurance and clearances in accordance with the IUP Department of Counseling policy.
Intern's Signature: |  |  |  |  |  | Date:
Site [NAME]'s Signature: |  |  |  |  |  | Date:
Spreadsheet: 7e6bb2e4-26b1-4edc-aea3-bd0e98c2699a
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
VRID2 | Test | VRID2 | Culture Referred for Identification, Virus | Culture Referred for ID, Virus | Shell Vial Assay for Appropriate Virus and/or Tube Cell Culture | Infectious Container-Large (Supply T146) |  |  |  |  | [NAME]: Cell (viral) culture medium Specimen Volume: Isolate Collection Instructions: 1. Organism must be in pure culture, actively growing. 2. Place specimen in a large infectious container (Supply T146) and label as an etiologic agent. Additional Information: 1. Specimen source is required. 2. Isolate description is required: morphology, tests performed. 3. See Infectious Specimen Shipping Guidelines in Special Instructions for shipping information. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	Agar plate | Not applicable | Monday through Sunday; Varies | 14 days/Positives are reported when detected | 14 days |  |  |  |  |  |  | Rochester
VRID2 | [NAME] | VARIES | Varies |  |  |  | Ambient
VRID2 | Order Question | Q00M0066 | [NAME]) and Isolate Description-Morphology, tests performed (Required) |  | Plain Text
VRID2 | Result | VRID2 | Culture Referred for ID, Virus | Culture Referred for ID, Virus | Alphanumeric
Spreadsheet: 866513d1713445501-code-to-description-code-to-description-example
Sheet: Foreman Worksheet

Date |  | Vindustries Job ID #
 |  | Completion Date:
Customer: |  | Customer WO #
Contact:
[NAME]:
Code | Description | Qty
Scope of Work Detail:
Job Total
Spreadsheet: 27352d1220535587-multiple-criteria-formula-populate-based-on-criteria1
Sheet: Sheet1

 | DATA |  |  |  |  | [NAME]
 | Policy Number | Code | Date |  |  | Policy Number | Medical | Non Medical | Date
 | 11224578 | B21 | 2008-09-04 00:00:00 |  |  | 11224578 |  | 11224578 | 2008-09-15 00:00:00
 | 11224578 | B21 | 2008-09-05 00:00:00 |  |  | 11224579 |  | 11224579 | 2008-09-04 00:00:00
 | 11224578 | B21 | 2008-09-06 00:00:00 |  |  | 11224580 |  | 11224580 | 2008-09-05 00:00:00
 | 11224578 | B21 | 2008-09-07 00:00:00 |  |  | 11224581 |  | 11224581 | 2008-09-06 00:00:00
 | 11224578 | B21 | 2008-09-08 00:00:00 |  |  | 11224582 |  | 11224582 | 2008-09-10 00:00:00
 | 11224578 | B26 | 2008-09-09 00:00:00 |  |  |  | #N/A | #N/A | #N/A
 | 11224578 | B27 | 2008-09-10 00:00:00 |  |  |  | #N/A | #N/A | #N/A
 | 11224578 | B28 | 2008-09-11 00:00:00 |  |  |  | #N/A | #N/A | #N/A
 | 11224578 | B29 | 2008-09-12 00:00:00 |  |  |  | #N/A | #N/A | #N/A
 | 11224578 | B30 | 2008-09-13 00:00:00 |  |  |  | #N/A | #N/A | #N/A
 | 11224578 | B31 | 2008-09-14 00:00:00 |  |  |  | #N/A | #N/A | #N/A
 | 11224578 | B32 | 2008-09-15 00:00:00 |  |  |  | #N/A | #N/A | #N/A
 | 11224579 | B33 | 2008-09-04 00:00:00 |  |  |  | #N/A | #N/A | #N/A
 | 11224580 | B34 | 2008-09-05 00:00:00 |  |  |  | #N/A | #N/A | #N/A
 | 11224581 | B35 | 2008-09-06 00:00:00 |  |  |  | #N/A | #N/A | #N/A
 | 11224582 | B05 | 2008-09-07 00:00:00
 | 11224582 | B37 | 2008-09-08 00:00:00
 | 11224582 | B38 | 2008-09-09 00:00:00
 | 11224582 | [NAME] | 2008-09-10 00:00:00
Spreadsheet: 3fd01d6f-8e17-4709-92fa-e3338a5341b3
Sheet: NON-RESIDENTIAL 

 |  |  |  |  |  |  |  | CITY OF RIO RANCHO, NEW MEXICO
 |  |  |  |  |  |  |  | MARCH 2014 NON-RESIDENTIAL DATA
APPLICATION TYPE |  | ADDRESS |  |  |  | LEGAL DESCRIPTION |  |  | PERMIT NUMBER |  |  | SQUARE FOOTAGE | VALUATION | CONTRACTOR | NOTES | STAFF USE ONLY
 | Street Number | Street Name | Suffix | [NAME] | Unit | Block | Lot | Permit Year | Permit number | STATUS | YMMDD
NCOM | 1502 | UNSER | BLVD | SE | CBCM | A | 5A | 14 | 1641 | AP | 140312 | 5394 | 531363 | KLINGER CONSTRUCTORS LLC |  | restaurant
OFRE | 1601 | NM HIGHWAY 528 |  | SE | GN |  |  | 14 | 1611 | AP | 140312 | 5495 | 200000 | HART DESIGN & CONSTRUCTION INC
RCOM | 2300 | GRANDE | BLVD | SE | GS |  |  | 14 | 1417 | AP | 140305 | 1753 | 118465 | INSIGHT CONSTRUCTION LLC
RCOM | 4100 | HIGH RESORT | BLVD | SE | HR |  |  | 14 | 1936 | AP | 140324 | 4108 | 27000 | OUT TO BID
RCOM | 4330 | MEADOWLARK | LN | SE | CS | H |  | 14 | 1694 | AP | 140313 | 14011 | 722005 | OUT TO BID
RCOM | 2003 | SOUTHERN | BLVD | SE | SP |  |  | 14 | 1745 | AP | 140317 | 95000 | 374061 | ALL AMERICAN ENTERPRISES INC
RCOM | 2104 | SOUTHERN | BLVD | SE | U16 | H | 3A | 14 | 1959 | PC | 140325 | 2064 | 25554 | OUT TO BID
RCOM | 1908 | WELLSPRING | AVE | SE |  |  |  | 14 | 1558 | AP | 140311 | 3435 | 338382 | TANGLEWOOD CONSTRUCTION
TCOM | 7800 | ENCHANTED HILLS | BLVD | NE | CCCEH | E | 5A | 14 | 1609 | PC | 140311 | 16 | 30000 | OUT TO BID
TCOM | 110 | NM HIGHWAY 528 |  | NE | IPE | C | 3B | 14 | 1858 | AP | 140320 | 0 | 5000 | OUT TO BID
TCOM | 1322 | PROGRESS | BLVD | NE | U21 |  |  | 14 | 1610 | PC | 140311 | 16 | 30000 | OUT TO BID
Spreadsheet: 862049d1709833564-looking-for-a-way-to-automate-scheduling-duos-into-different-squads-sample-scheduling-bsweet0us-3-
Sheet: Squad schedule 2

Squad 1 | 2024-01-12 00:00:00 |  | Squad 2 | 2024-01-13 00:00:00 |  | Squad 3 | 2024-01-14 00:00:00 |  | Squad 4 | 2024-01-15 00:00:00 |  | Squad 5 | 2024-01-16 00:00:00 |  | Squad 6 | 2024-01-17 00:00:00
Squad 7 | 2024-01-18 00:00:00 |  | Squad 8 | 2024-01-19 00:00:00 |  | Squad 9 | 2024-01-20 00:00:00 |  | Squad 10 | 2024-01-21 00:00:00 |  | Squad 11 | 2024-01-22 00:00:00 |  | Squad 12 | 2024-01-23 00:00:00
Spreadsheet: 75895d1276512825-average-of-value-in-different-cells-in-multiple-worksheet-test-vsb-reco-201011-and-summary-sheet
Sheet: Apr'10

 |  | [NAME]
 |  | Monthly Reconciliation
 |  | 2010-04-30 00:00:00
 |  | Summary of Stocks
 |  | New Stock | Fully Paid |  | Int. Bearing |  | Free Funded |  | Totals
 |  |  | Units | Value | Units | Value | Units | Value | Units | Value
 |  |  | 20 | 299280.07 |  |  | 16 | 214749.26 | 36 | 514029.33
 |  |  | 20 | 299280.07 | 0 | 0 | 16 | 214749.26 | 36 | 514029.33
 |  | Used Stock | Fully Paid |  | Int. Bearing |  | Free Funded |  | Totals |  | Units over | % Of Stock
 |  |  | Units | Value | Units | Value | Units | Value | Units | Value | 70 Days | Overage
 |  | Stock 1 | 34 | 194896.23 |  |  |  |  | 34 | 194896.23 | 12 | 0.3529411764705883
 |  | Stock 2 | 15 | 167200 |  |  |  |  | 15 | 167200 | 9 | 0.6
 |  | Stock 3 | 1 | 6841.83 |  |  |  |  | 1 | 6841.83 | 1 | 1
 |  | Stock 4 | 2 | 18887.39 |  |  |  |  | 2 | 18887.39 | 2 | 1
 |  | Stock 5 | 15 | 129975.78 |  |  |  |  | 15 | 129975.78 | 4 | 0.2666666666666667
 |  | Stock 6 | 11 | 17150 |  |  |  |  | 11 | 17150 | 0 | 0
 |  | Totals | 78 | 534951.23 | 0 | 0 | 0 | 0 | 78 | 534951.23 | 28 | 0.358974358974359
Spreadsheet: 470138d1468350065-comparing-data-before-and-after-a-start-date-before-and-after
Sheet: Sheet1

Referral ID | Initiatior ID | Recipient ID | Referral Created Date | Date Joined | Referral Status | Referral Count | Referral Worked | Closed | No Sale | B  or A
1 | 123 | 456 | 2015-09-03 15:28:12 | 2016-02-01 00:00:00 | Closed No Sale | 1 | 1 | 0 | 1
11 | 124 | 301 | 2016-02-05 19:04:58 | 2015-07-01 00:00:00 | Assigned | 1 | 0 | 0 | 0
12 | 125 | 301 | 2015-10-24 19:32:40 | 2015-07-01 00:00:00 | Closed Sale | 1 | 1 | 1 | 0
43 | 126 | 456 | 2016-04-18 16:45:55 | 2016-02-01 00:00:00 | Closed Sale | 1 | 1 | 1 | 0
21 | 127 | 301 | 2016-03-23 20:48:15 | 2015-07-01 00:00:00 | Assigned | 1 | 0 | 0 | 0
15 | 128 | 301 | 2015-08-10 23:35:12 | 2015-07-01 00:00:00 | Assigned | 1 | 0 | 0 | 0
22 | 129 | 456 | 2016-01-28 19:20:28 | 2016-02-01 00:00:00 | Assigned | 1 | 0 | 0 | 0
63 | 130 | 222 | 2015-06-24 16:38:55 | 2015-12-01 00:00:00 | Closed No Sale | 1 | 1 | 0 | 1
98 | 131 | 222 | 2016-03-18 19:43:10 | 2015-12-01 00:00:00 | Closed Sale | 1 | 1 | 1 | 0
44 | 132 | 222 | 2016-01-27 21:41:16 | 2015-12-01 00:00:00 | Application Taken | 1 | 1 | 0 | 0
B  or A | (All)
Recipient ID | Sum of Referral Count | Worked% | Closed % | No Sale% | Pipeline%
222 | 3 | 1 | 0.3333333333333333 | 0.3333333333333333 | 0.3333333333333333
301 | 4 | 0.25 | 0.25 | 0 | 0
456 | 3 | 0.6666666666666666 | 0.3333333333333333 | 0.3333333333333333 | 0
Grand Total | 10 | 0.6 | 0.3 | 0.2 | 0.1