tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0a805602-a27a-4620-9383-c5440c47562a
Sheet: 18

Product* | January 3 | January 10 | January 17 | January 24 | January 31
Total**
Non-Deliverable Forwards | N/A | N/A | N/A | N/A | N/A
Options | N/A | N/A | N/A | N/A | N/A
Forwards | N/A | N/A | N/A | N/A | N/A
Swaps | N/A | N/A | N/A | N/A | N/A
OTHER | N/A | N/A | N/A | N/A | N/A
TOTAL
Gross notional amount outstanding, January 31 weekly snapshot, by product type, all participant types, tenors and currencies.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**These numbers are estimates.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 584718d1533339970-excel-filling-one-table-with-data-from-another-table-copy-of-d-ploiements-clients-erex-
Sheet: Données

Centrex | VoiceMangement | Data | Commercial | Facturation | Revendeur | Porta | Mandat | Facturation Porta | Verif Stock | UPS | DATA | [NAME] | Type Accès | [NAME] | Routeur | Tests | Zone tarifaire | Ressource Formation | [NAME] | Postes à facturer
OUI | OUI | OUI | AT | OK | Hexacom | OUI | RECU | faite | OK | https://wwwapps.ups.com/WebTracking/processInputRequest?AgreeToTermsAndConditions=yes&loc=fr_FR&tracknum= | Orange | NON | SDSL | En preparation | EdgeRouterPro8 | OK | [NAME] | AT | En cours | Location
NON | NON | NON | AB | Partielle | [NAME] | NON | NON RECU | Inclus | [NAME] |  | Ielo-Liazo | OUI Sur Bridge | ADSL | Prêt | EdgeRouteurX | NOK | [NAME] | CW | Stand-By | [NAME]
 |  |  | AVH | NON | Data Telecom |  |  | A faire | Non |  | SFR | Oui sur Equipement Client | Fibre | StandBy | [NAME] |  | Z3 Orange | MC | Attente retour Client | Client
 |  |  | ID | Inclus | UnifyTelecom |  |  |  |  |  | CMIN |  | VDSL |  |  |  | SFR C2E |  | Attente retour commercial | Softphones
 |  |  | LB | A faire | Ouest Consulting |  |  |  |  |  |  |  |  |  |  |  | SFR DSP |  | Livré | Revendeur
[NAME] | http://support.axialys.com/gestion/operations.php?id_ticket= |  | MD |  |  |  |  |  |  |  |  |  |  |  |  |  | IELO ADSL |  | Résilié
 |  |  | NB |  |  |  |  |  |  |  |  |  |  |  |  |  | IELO VDSL
 |  |  | TR |  |  |  |  |  |  |  |  |  |  |  |  |  | IELO Fibre
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IELO SDSL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CMIN Fibre
Spreadsheet: 881112d1729022240-sorting-by-oldest-to-newest-when-cells-are-blank-worksheet-sample-3-
Sheet: Sheet1

# | Title | Location | Comments | Trade | Due Date | Status | Assignee | Assignee's Company | Date Of Response
2 | x | x | , "Trade did x" - John Doe 09/30/24 08:35am EST, "" - John Doe 08/07/24 12:54pm EST | x | x | x | x | x
3 | x | x | , "Trade did x" - John Doe 09/27/24 08:35am EST, "" - John Doe 08/07/24 12:54pm EST | x | x | x | x | x
1 | x | x | , "" - John Doe 09/19/24 06:31am EST, "So and So completed x" - John Doe 09/06/24 05:23pm EST, "" - John Doe 08/07/24 12:53pm EST, "" - John Doe 08/07/24 12:51pm EST | x | x | x | x | x
4 | x | x | , "Trade did x" - John Doe 09/16/24 08:35am EST, "" - John Doe 08/07/24 12:54pm EST | x | x | x | x | x
Spreadsheet: 716883d1612405740-csv-numbers-change-into-date-in-excel-pq-import-for-michelle
Sheet: Sheet1

NAS | Numéro employé | [NAME] | Prenom | Sexe | Date Naissance | Corps emploi | Description corps emploi | Catégorie emploi | Description catégorie emploi | Classe emploi | Description classe emploi | Échelon Emploi | Statut Emploi | [NAME] | Heures par semaine | [NAME] | Salaire [NAME] | Code employeur | [NAME] | Employeur | Description CR | Région | Description Région | Adresse emploi | Ville, Province (emploi) | Code postal (emploi) | Adresse résidence (employé) | Ville, Province (employé) | Employé Code Postal | Unité Syndicale | Description Unité Syndicale | ID unique | Horaire de travail | [NAME] | Date Embauche | Nom Gestionnaire | Réserve Maladie | Tel. Gestionnaire | [NAME]. personnel | Cellulaire | Tel. Bureau | Courriel(s) personnel(s) | No ass. [NAME]
 | 583625 | SIROIS | MACHINE | [NAME] | 1970-01-02 00:00:00 | 1550 travailleuse sociale |  | 4 | TTTS |  |  |  | PTC | SALARIE A TEMPS COMPLET |  |  |  | 900501 | Hôpital | CSS de la Côte |  | 2021-06-04 00:00:00 | Côte | 45, rue Frère-Duvet | Sept-Iles QC | G4R 8N8 | 9, ROMERO-VARCHOT | ILES | GRR 0E4 | APTS |  | 317 |  | SER.MULTD.PGR.MULTCL | 14/05/2017 |  |  |  | (555) 555-5555 |  | (555) 555-5555, 4103
Spreadsheet: 722131d1615054047-add-1-to-a-given-value-in-every-3-years-based-on-a-range-of-dates-sample3
Sheet: Sheet1

 |  | From | To |  |  | From | To | Step |  |  | From | To | Step
 |  | 1980-09-02 00:00:00 | 2005-03-10 00:00:00 |  |  |  |  | 1
 |  |  |  |  |  | 1981-01-01 00:00:00 |  | 1
 |  |  |  |  |  | 1982-01-01 00:00:00 |  | 1
 |  |  |  |  |  | 1983-01-01 00:00:00 | 1983-09-01 00:00:00 | 1
 |  |  |  |  |  | 1983-09-02 00:00:00 | 1983-12-21 00:00:00 | 2
 |  |  |  |  |  | 1984-01-01 00:00:00 |  | 2
 |  |  |  |  |  | 1985-01-01 00:00:00 |  | 2
 |  |  |  |  |  | 1986-01-01 00:00:00 | 1986-09-01 00:00:00 | 2
There will be an additional 1 step in every 3 years but not exceeding 8 with font color red. The cells filled with green are the end dates in each period. |  |  |  |  |  | 1986-09-02 00:00:00 |  | 3
 |  |  |  |  |  | 1987-01-01 00:00:00 |  | 3
 |  |  |  |  |  | 1988-01-01 00:00:00 |  | 3
 |  |  |  |  |  | 1989-01-01 00:00:00 | 1989-09-01 00:00:00 | 3
 |  |  |  |  |  | 1989-09-02 00:00:00 |  | 4
 |  |  |  |  |  | 1990-01-01 00:00:00 |  | 4
 |  |  |  |  |  | 1991-01-01 00:00:00 |  | 4
 |  |  |  |  |  | 1992-01-01 00:00:00 | 1992-09-01 00:00:00 | 4
 |  |  |  |  |  | 1992-09-02 00:00:00 |  | 5
 |  |  |  |  |  | 1993-01-01 00:00:00 |  | 5
 |  |  |  |  |  | 1994-01-01 00:00:00 |  | 5
 |  |  |  |  |  | 1995-01-01 00:00:00 | 1995-09-01 00:00:00 | 5
 |  |  |  |  |  | 1995-09-02 00:00:00 |  | 6
 |  |  |  |  |  | 1996-01-01 00:00:00 |  | 6
 |  |  |  |  |  | 1997-01-01 00:00:00 |  | 6
 |  |  |  |  |  | 1998-01-01 00:00:00 | 1998-09-01 00:00:00 | 6
 |  |  |  |  |  | 1998-09-02 00:00:00 |  | 7
 |  |  |  |  |  | 1999-01-01 00:00:00 |  | 7
 |  |  |  |  |  | 2000-01-01 00:00:00 |  | 7
 |  |  |  |  |  | 2001-01-01 00:00:00 | 2001-09-01 00:00:00 | 7
 |  |  |  |  |  | 2001-09-02 00:00:00 |  | 8
 |  |  |  |  |  | 2002-01-01 00:00:00 |  | 8
 |  |  |  |  |  | 2003-01-01 00:00:00 |  | 8
 |  |  |  |  |  | 2004-01-01 00:00:00 |  | 8
 |  |  |  |  |  | 2005-01-01 00:00:00 | 2005-03-10 00:00:00 | 8
Spreadsheet: 707891d1607525718-how-to-assign-a-country-to-a-specific-area-dashboard-aligw
Sheet: USA

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: 003cb88b-50d1-46b2-b1fe-31524b1bb45a
Sheet: +55 MS 

BWF World Senior Championships 2013
MS 55 |  |  |  |  | Redrawn on 02nd September 2013
Badminton Tournament Planner - bwf.tournamentsoftware.com
 | Member ID | St. | Cnty | Flag | Round 1 | Round 2 | Round 3 | Quarterfinals | Semifinals | Final | Winner
1 | 578 |  | SCO |  | [NAME] [1]
2 |  |  |  |  | Bye 1
3 | 58886 |  | GER |  | [NAME]
4 |  |  |  |  | Bye 17
5 | 65524 |  | TUR |  | Nesim Yalvarici
6 |  |  |  |  | Bye 9
7 | 69958 |  | ITA |  | [NAME]
8 | 99003 |  | DEN |  | [NAME]
9 | 87496 |  | JPN |  | Toshio Kawaguchi [5/8]
10 |  |  |  |  | Bye 5
11 | 52500 |  | RUS |  | Igor Ponomarev
12 | 78474 |  | ENG |  | [NAME]
13 | 89158 |  | FRA |  | [NAME]
14 |  |  |  |  | Bye 13
15 | 77047 |  | SWE |  | [NAME]
16 | 87417 |  | IND |  | Kelhousithie Kire
17 | 88890 |  | RUS |  | Sergey Bushuev [3/4]
18 |  |  |  |  | Bye 3
19 | 71118 |  | ENG |  | [NAME]
20 | 57886 |  | FIN |  | [NAME]
21 | 78170 |  | IND |  | [NAME]
22 |  |  |  |  | Bye 11
23 | 78099 |  | SWE |  | Cheddi Liljestrom
24 | 65282 |  | POL |  | [NAME]
25 | 89962 |  | DEN |  | [NAME] [5/8]
26 |  |  |  |  | Bye 7
27 | 9669 |  | CZE |  | Jan Bednar
28 | 78196 |  | SUI |  | [NAME]
29 | 93706 |  | FRA |  | [NAME]
30 |  |  |  |  | Bye 15
31 | 76760 |  | TUR |  | [NAME]
32 | 93997 |  | MAS |  | [NAME]
33 | 82124 |  | ENG |  | [NAME]
34 | 80437 |  | FRA |  | [NAME]
35 |  |  |  |  | Bye 16
36 | 52510 |  | SCO |  | [NAME]
37 | 65243 |  | JPN |  | [NAME]
38 | 85493 |  | SWE |  | Stig [NAME]
39 |  |  |  |  | Bye 8
40 | 52503 |  | RUS |  | [NAME] [5/8]
41 | 70238 |  | GER |  | [NAME]
42 | 83556 |  | NOR |  | Morten Aarhus
43 |  |  |  |  | Bye 12
44 | 73837 |  | DEN |  | [NAME]
45 | 99789 |  | IND |  | Bendangnukshi Jamir
46 | 74586 |  | TUR |  | [NAME]
47 |  |  |  |  | Bye 4
48 | 483 |  | NED |  | Uun Setiawan Santosa [3/4]
49 | 71872 |  | GER |  | [NAME]
50 | 71603 |  | SWE |  | [NAME]
51 |  |  |  |  | Bye 14
52 | 81104 |  | IND |  | Sekhar Chandra Biswas
53 | 99283 |  | TUR |  | [NAME]
54 | 79096 |  | JPN |  | [NAME]
55 |  |  |  |  | Bye 6
56 | 136 |  | AUT |  | [NAME] [5/8]
57 | 93024 |  | ENG |  | [NAME]
58 | 8220 |  | DEN |  | [NAME]
59 |  |  |  |  | Bye 10
60 | 88444 |  | FRA |  | [NAME]
61 | 95465 |  | CZE |  | [NAME]
62 | 96891 |  | POL |  | [NAME]
63 |  |  |  |  | Bye 2
64 | 52504 |  | RUS |  | [NAME] [2]
Spreadsheet: 217150d1361993613-problems-with-index-and-match-formula-sample-worksheet_1
Sheet: Main

 | Letter | TableB
 | Period | Q3
 | Color | Yellow
 | Number
 |  | Q1
 |  | Q2
 |  | Q3
 |  | Q4
 |  |  |  | [NAME] |  | Yellow
 |  |  |  | TableB |  | Blue
 |  |  |  | TableC |  | Red
 |  |  |  |  |  | Green
 |  |  |  |  |  | Black
Spreadsheet: 887840d1738168568-summing-lookups-on-multiple-sheets-book1
Sheet: Sheet3

 | 1 |  |  |  | DEF-one
 | 5 |  |  |  | DEF-two
 | 0 |  |  |  | DEF-three
 | 4 |  |  |  | DEF-four
 | 3 |  |  |  | DEF-five
 | 2 |  |  |  | DEF-six
 | 0 |  |  |  | DEF-seven
 | 5 |  |  |  | DEF-eight
 | 5 |  |  |  | DEF-nine
 | 2 |  |  |  | DEF-ten
Spreadsheet: 814908d1674656523-changeable-gross-margin-sample
Sheet: Sheet1

Purchase Cost | List Price | Profit | GM %
100 | 140
50 | 65 |  |  |  |  |  |  |  | GM %
45 | 52
125 | 165
Spreadsheet: 67778d1268309915-pivot-table-layout-issue-moving-from-xl03-to-xl07-test-layout
Sheet: Source Data

Product | Customer | Qtr 1 | Qtr 2 | Qtr 3 | Qtr 4
[NAME] | ANTON |  | 702
[NAME] | BERGS | 312
[NAME] | BOLID |  |  |  | 1170
[NAME] | ALFKI |  |  |  | 60
[NAME] | BOTTM |  |  |  | 200
[NAME] | ERNSH |  |  |  | 180
Boston Crab Meat | ANTON |  | 165.6
Boston Crab Meat | BERGS |  | 920
Boston Crab Meat | BONAP |  | 248.4 | 524.4
[NAME] | ANATR |  |  | 340
[NAME] | AROUT |  |  |  | 510
[NAME] | BERGS |  |  | 680
Carnarvon Tigers | BLONP |  | 956.25
Carnarvon Tigers | BONAP | 1500
Carnarvon Tigers | FOLIG |  |  | 3125 | 1875
Spreadsheet: 207463d1358460035-timesheet-how-to-make-a-running-total-and-can-you-have-negative-time-timesheet_mod
Sheet: Sheet1

 |  |  |  |  | Timesheet: How to make a running total, and can you have "negative? time?
Hrs per day:
08:00:00 |  |  | Date | Hrs worked | Time over | Time  under | Running total | Manual math
 |  |  |  | 08:10:00 |  |  | 00:10:00 |  |  | All cels in range F9 to G26 contains formulas
 |  |  |  | 08:15:00 |  |  |  |  |  | but if a cell value is 0 it's shown as blank.
 |  |  |  | 08:15:00 |  |  |  | up 40
 |  |  | weekend |  |  |  |  |  |  | Go to -> Excel Options -> Advanced -> Display options for this worksheet
 |  |  |  |  |  |  |  |  |  | and unmark box "Show a zero in cells that have zero value.
 |  |  |  | 07:10:00 |  |  |  | 10 down
 |  |  |  | 08:30:00 |  |  |  | 20 up
 |  |  |  | 08:00:00
 |  |  |  | 07:50:00 |  |  |  | 10 up
 |  |  |  | 08:10:00 |  |  |  | 5 up
 |  |  | weekend
 |  |  |  | 08:45:00 |  |  |  | 50 up
 |  |  |  | 08:25:00 |  |  |  | 1:10 up
 |  |  |  | 08:20:00 |  |  |  | 1:30 up
 |  |  |  | 05:40:00 |  |  |  | 50 down
 |  |  |  | 00:00:00
 |  |  |  | 00:00:00
Spreadsheet: 30892d1226590696-autofilter-greyed-out-tapemanagementverification2
Sheet: Sheet3

[NAME] |  | SENT TO ERIC STROMBERG |  |  | Sent 2/3/2006
DC1720L1 |  | SENT TO ERIC STROMBERG |  |  | Sent 2/3/2006
DC2486L1 |  | SENT TO ERIC STROMBERG |  |  | Sent 2/3/2006
DC2490L1 |  | SENT TO ERIC STROMBERG |  |  | Sent 2/3/2006
DC2821L1 |  | SENT TO ERIC STROMBERG |  |  | Sent 2/3/2006
DC3934L1 |  | SENT TO ERIC STROMBERG |  |  | Sent 2/3/2006
DC4015L1 |  | SENT TO ERIC STROMBERG |  |  | Sent 2/3/2006
DC4016L1 |  | SENT TO ERIC STROMBERG |  |  | Sent 2/3/2006
DC4017L1 |  | SENT TO ERIC STROMBERG |  |  | Sent 2/3/2006
OC0053L1 |  | SENT TO ERIC STROMBERG |  |  | Sent 2/3/2006
Spreadsheet: 127653d1320442121-need-a-lookup-formula-forum1
Sheet: Sheet1

RETURN RANGE | SEARCH RANGE
4158581 | 1982180 | 1982182 |  |  |  |  |  | SEARCH RANGE |  |  |  |  | 1985266
4159661 | 1982905 | 1982906 |  |  |  |  |  | RETURN RANGE
4159790 | 1984643 | 1984644 | 1984645 | 1984646 | 1984647
4159790 | 1985060
4159795 | 1985055 | 1985056 | 1985057 | 1985058 | 1985059
4159800 | 1985132 | 1985134 | 1985202 | 1985204
4160816 | 1983557
4161139 | 1983840
4161242 | 1983904
4162481 | 1985310 | 1985311 | 1985312
4163417 | 1985011 | 1985013
4163687 | 1985170
4163799 | 1985266
4163994 | 1985386
4167211 | 1987258
4167305 | 1987278
4167336 | 1987328 | 1987329 | 1987718
4167428 | RDC
4167437 | 1987400
4167838 | 1987592 | 1987594
Please see the attached workbook. I need a formula that will do the following:
I want to be able to type any number from the "Search Range" into cell [NAME] and have it return the value of the "Return Range" in A4. I have tried the "lookup" function but the data in the "Search Range" is not in ascending order (and cannot be).
Spreadsheet: 684195d1593188560-need-formula-for-filtering-specific-values-and-moving-to-next-tab-askexcel
Sheet: Sheet1

ITEM | [NAME] | number
G 1 | well done | 1
F 5 | DISCUSSED CONTINUOS | 2
B 10 | See Below | 3
C-1 | TWO EMPLOYEE meet | 4
B  10 | See Below | 5
E 3 | drive a car | 6
Spreadsheet: 187555d1350505794-i-have-2-columns-a-and-b-need-to-compare-a-value-with-entire-b-and-print-count-new-column-c-book1
Sheet: Sheet1

A | B | C
89 | 10
10 | 63
55 | 63
89 | 63
63 | 8
9 | 2
10 | 6
Spreadsheet: 138567d1327720698-formula-needed-to-return-entire-column-under-header-on-second-sheet-bigtunelover-lookup-columns-based-on-headings
Sheet: Sheet1

Name | Address | Date | Zip
 |  | 2012-01-27 00:00:00 | 22182
Spreadsheet: 65548d1266273456-find-a-value-across-multiple-sheets-in-another-workbook-sales-orders_2010
Sheet: SalesFeb

Expected Sales Proceeds For JANUARY 2010
 |  |  |  |  |  |  | FX | 0.9135
 | INVOICE | INVOICE DATE | CUSTOMER | PRODUCT | Quantity | PRICE        USD / MT | AMOUNT (USD) | AMOUNT (AUD)
EXPORT
 | 100206 | 2010-02-01 00:00:00 | Customer1 | Product15 | 300 | 2.3 | 690 | 755.336617405583
 | 100207 | 2010-02-02 00:00:00 | Customer2 | Product25 | 400 | 2.125 | 850 | 930.4871373836892
 | 100208 | 2010-02-03 00:00:00 | Customer3 | Product35 | 500 | 2.02 | 1010 | 1105.637657361795
 | 100209 | 2010-02-04 00:00:00 | Customer4 | Product45 | 600 | 1.95 | 1170 | 1280.788177339901
 | 100210 | 2010-02-05 00:00:00 | Customer5 | Product55 | 700 | 1.9 | 1330 | 1455.938697318008
 | 100211 | 2010-02-06 00:00:00 | Customer6 | Product65 | 800 | 1.8625 | 1490 | 1631.089217296114
 | 100212 | 2010-02-07 00:00:00 | Customer7 | Product75 | 900 | 1.833333333333333 | 1650 | 1806.23973727422
 | 100213 | 2010-02-08 00:00:00 | Customer8 | Product85 | 1000 | 1.81 | 1810 | 1981.390257252326
 | 100214 | 2010-02-09 00:00:00 | Customer9 | Product95 | 1100 | 1.790909090909091 | 1970 | 2156.540777230432
DOMESTIC
Spreadsheet: 121435d1316052580-pivot-table-to-roll-up-data-and-display-in-pivot-chart-tickets
Sheet: Sheet1

Date | Request | Assigned To | Duration
2011-01-02 00:00:00 | Printer | [NAME] | 1.5
2011-01-02 00:00:00 | Toner | [NAME] | 1
2011-01-02 00:00:00 | [NAME] | [NAME] | 0.25
2011-01-02 00:00:00 | Keyboard | [NAME] | 0.5
2011-01-02 00:00:00 | Power Cable | [NAME] | 2
2011-01-03 00:00:00 | Missing mouse | [NAME] | 2
2011-01-03 00:00:00 | Printer | [NAME] | 4
2011-01-03 00:00:00 | Toner | [NAME] | 3
2011-01-03 00:00:00 | [NAME] | [NAME] | 2
2011-01-03 00:00:00 | Keyboard | [NAME] | 1
Spreadsheet: 63736d1264612393-solved-vlookup-or-index-function-book1-pe
Sheet: Ref Table

TAX ID | Billing Area | Practice Name | CITY | STATE | Facility ID | TAXONOMY | LINKED GROUP | MEDICARE #
121212 | 24 | AUSTIN OFFICE | AUSTIN | TX | 2222 | single | NO | 55
232323 | 37 | DALLAS OFFICE | DALLAS | TX | 3333 | single | YES | 66
 |  |  |  |  |  |  |  |  | INSERT > NAME > DEFINE to see the dynamic named ranges
 |  |  |  |  |  |  |  |  | that have been added on this sheet
Spreadsheet: michelle_lokay__26697__imball0111rev
Sheet: Mojave

56696
Day | Measured | Scheduled
1 | -25011 | -24793
2 | -20052 | -20000
3 | -20578 | -20000
4 | -21000 | -20000
5 | -20862 | -20000
6 | -20000 | -20000
7 | -20012 | -20000
8 | -20512 | -20000
9 | -20151 | -20000
10 | -20105 | -20000
11 | -20179 | -20000
12 | -20096 | -20000
13 | -19994 | -20000
14 | -20103 | -20000
15 | -20216 | -20000
16 | -20000 | -20000
17 | -20009 | -20000
18 | -20683 | -20000
19 | -20998 | -20000
20 | -20998 | -20000
21 | -21013 | -20000
22 | -21000 | -20000
23 | -19999 | -20000
24 | -19998 | -20000
25 | -18928 | -19471
26 | -20855 | -20000
27 | -20002 | -19943
28 | -20010 | -19910
29 | -20003 | -19770
30 | -19998 | -20000
31
2001-10-31 00:00:00 |  |  | 167466
2001-11-30 00:00:00
CBS Dollars
 |  |  | 158248.07
Spreadsheet: 139492d1328275337-moving-data-from-worksheet-to-columns-sample_nobleprince
Sheet: BEFORE

 |  | Helper | Result |  | UDF
[NAME] | Burn | xyz.com | xyz.com | IT Manager at xyz | xyz.com
[NAME] | Piers | test.com | test.com | Business Analyst at test | test.com
[NAME] | Rain | #N/A | - | Scientific Researcher | -
[NAME] | [NAME] | uvw.com | uvw.com | IT Analyst @ uvw | uvw.com
Spreadsheet: 09279f50-ca70-4529-a1b2-2d9bb8cc538b
Sheet: GhGE_Reductions

 | Vehicle Trips Saved Calculation
 | Total Vehicle Trips per year reduced for commuting to work only: 60,122
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 | Round Trip Length in miles | Number of Trips | Total Miles | Total Gas in gallons | Total Cost saved through gas reduction | Total CO2 Ton Emmissions | Value of CO2 Emissions Reductions- 2012 | Reduced NOx tons | Reduced SOx tons | Reduced VOC tons | Reduced PM10 tons | Value of Reduced Nox, Sox, VOC, PM10
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 14
 | 16
 | 20
 | Total | 60122
 | 1. Total Number of Trips is based on 289 new commuters x 4 days per week x 52 weeks per year
 | 3.  Gallons of gas is averaged at 20.3mpg using EPA MOBILE6.2 Fuel economy calculation
 | 4. Cost savings through reduced gas is calculated at $3.90/gallon - current Humboldt County Price is $4.03/gallon
 | 5. See below calculation for total CO2 emmissions
 | 6. Value for reduced CO2 emissions are generated using the Recommended Monetized Values listed in the TIGER BCA Resource Guide Page 6 -Social Cost of Carbon
 | 7-10. NOx, SOx, VOC and PM10 are calculated using ICLEI's emissions calculator software
 | 11. Values provided for reduced emissions are generated using the Recommended Monetized Values listed in the TIGER BCA Resource Guide Page 5
 | [NAME]
 | EPA MOBILE6.2 fuel economy numbers
 | Metric tons of CO2e for the average passenger vehicle =
 | (VMT/passenger vehicle avg. MPG) x CO2 per [NAME] (100/95) /1000 =
 | (12,000/20.3) x 8.8 x (100/95)/1000 =
 | 5.48 metric tons CO2e for the average passenger vehicle (1.49 metric tons CE)
 | NOx, SOx, VOC and PM10 are calculated using ICLEI's emissions calculator software
Spreadsheet: darrell_schoolcraft__7335__imball0203
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 94079 | 94300
2 | 93999 | 93800
3 | 94001 | 93800
4 | 78477 | 78052
5 | 87448 | 87521
6 | 79309 | 78221
7 | 78143 | 78221
8 | 78416 | 78219
9 | 78187 | 78221
10 | 78996 | 78221
11 | 78991 | 78221
12 | 79015 | 78221
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  | 21511.71
2002-03-12 00:00:00
CBS Volume
 |  |  | -45555
Spreadsheet: 761575d1641058663-conditional-workday-formula-test-file-1-
Sheet: Sheet1

Day | Date
Christmas Day | 2021-12-25 00:00:00
Boxing Day | 2021-12-26 00:00:00
Christmas Day (substitute day) | 2021-12-27 00:00:00
Year End holidays | 2021-12-28 00:00:00
Year End holidays | 2021-12-29 00:00:00
Year End holidays | 2021-12-30 00:00:00
Year End holidays | 2021-12-31 00:00:00
New Year’s Day (substitute day) | 2022-01-03 00:00:00
Good Friday | 2022-04-15 00:00:00
Easter Monday | 2022-04-18 00:00:00
Early May bank holiday | 2022-05-02 00:00:00
Summer bank holiday | 2022-08-29 00:00:00
Boxing Day | 2022-12-26 00:00:00
Christmas Day (substitute day) | 2022-12-27 00:00:00
Year End holidays | 2022-12-28 00:00:00
Year End holidays | 2022-12-29 00:00:00
Year End holidays | 2022-12-30 00:00:00
Spreadsheet: 44659a64-80c4-4259-8c60-d1f7cd35c53e
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
HCYSU | Test | HCYSU | Homocysteine, Total, [NAME] | Homocysteine, Total, U | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) Stable Isotope Dilution Analysis | [NAME]: Urine |  |  | 2 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 4 mL Collection Instructions: 1. Void and discard the first-morning urine specimen following an overnight fast. 2. Continue fasting, and collect the next random urine specimen. | 2.25 mL | Hemolysis	NA Thawing	Warm Reject; Cold OK Lipemia	NA Icterus	NA Other	NA | Adults: 0-9 mcmol/g creatinine | Monday through Friday; 12 p.m. | 2 days (not reported Sundays) | 5 days | 1 | 83090 |  |  |  |  | Rochester
HCYSU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
HCYSU | Result | 80378 | Homocysteine, Total, U | Homocysteine, Total, U | Numeric |  |  |  |  | mcmol/g Cr |  |  |  |  |  |  |  |  |  | 26582-7
Spreadsheet: 549043d1511429776-dynamic-cell-reference-creation-example
Sheet: Datadrop

Internal ID | Item Name |  | r | c
8279 | 8000342 |  | 1 | 2
8280 | 8000343 |  | 1 | 2
8281 | 8000344 |  | 1 | 1 |  |  |  |  |  |  |  |  |  | 8000342 | 8279
8282 | 8000345 |  | 1 | 1 |  |  |  |  |  |  |  |  |  | 8000342 | 8279
8283 | 8000346 |  | 2 | 2 |  |  |  |  |  |  |  |  |  | 8279 | 8000342
8284 | 8000347 |  | 2 | 2 |  |  |  |  |  |  |  |  |  | 8279 | 8000342
8285 | 8000348 |  | 2 | 1 |  |  |  |  |  |  |  |  |  | 8000343 | 8280
8286 | 8000373 |  | 2 | 1 |  |  |  |  |  |  |  |  |  | 8000343 | 8280
8288 | 8000380 |  |  |  |  |  |  |  |  |  |  |  |  | 8280 | 8000343
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8280 | 8000343