tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 822163d1679143972-index-match-from-two-columns-issue-excel-help2
Sheet: Sheet1

Menu Item Sales by Definition | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Date
Business Dates | 01/01/2023 - 31/01/2023 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00
Locations | Restaurant A |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00
Revenue Centers | All |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00
Menu Items | All |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00
Menu Item Name | Menu Item # | Menu Item Def | Price Level | [NAME] | Returns |  | Net VAT Before Disc. | Discounts VAT | Net VAT After [NAME]. |  | Gross Before Disc. | Discounts | Gross After [NAME]. | 2023-01-01 00:00:00
Totals: |  |  |  | 5356 | 0 |  | 222400 | -519.2 | 221880.8 |  | 278000 | -649 | 277351 | 2023-01-01 00:00:00
Coca Cola Zero | 300010002 | 1 | 1 | 41 | 0 |  | 48 | 0 | 48 |  | 60 | 0 | 60 | 2023-01-01 00:00:00
Piment/løgkompot | 10070007 | 1 | 1 | 5 | 0 |  | 40 | 0 | 40 |  | 50 | 0 | 50 | 2023-01-01 00:00:00
Frisk Chili | 100030001 | 1 | 1 | 9 | 0 |  | 36 | 0 | 36 |  | 45 | 0 | 45 | 2023-01-01 00:00:00 |  | Menu Item | Month | Result
Faxe Kondi | 30060003 | 1 | 1 | 2 | 0 |  | 32 | 0 | 32 |  | 40 | 0 | 40 | 2023-01-01 00:00:00 |  | 10070007 | 1
Faxe Kondi | 300010004 | 1 | 1 | 48 | 0 |  | 32 | 0 | 32 |  | 40 | 0 | 40 | 2023-01-01 00:00:00
Tuborg Pilsner | 30070002 | 1 | 1 | 3 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 2023-01-01 00:00:00
Business Dates | 01/02/2023 - 28/02/2023 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00
Locations | Restaurant A |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00
Revenue Centers | All |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00
Menu Items | All |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00
Menu Item Name | Menu Item # | Menu Item Def | Price Level | [NAME] | Returns |  | Net VAT Before Disc. | Discounts VAT | Net VAT After [NAME]. |  | Gross Before Disc. | Discounts | Gross After [NAME]. | 2023-02-01 00:00:00
Totals: |  |  |  | 6348 | 0 |  | 263859.2 | -794.4 | 263064.8 |  | 329824 | -993 | 328831 | 2023-02-01 00:00:00
[NAME] | 60020005 | 1 | 1 | 5 | 0 |  | 48 | 0 | 48 |  | 60 | 0 | 60 | 2023-02-01 00:00:00
[NAME] ([NAME] | 900010009 | 1 | 1 | 1 | 0 |  | 44 | 0 | 44 |  | 55 | 0 | 55 | 2023-02-01 00:00:00
[NAME] | 300010006 | 1 | 1 | 2 | 0 |  | 40 | 0 | 40 |  | 50 | 0 | 50 | 2023-02-01 00:00:00
Bestikk i Bambus | 20040002 | 1 | 1 | 10 | 0 |  | 40 | 0 | 40 |  | 50 | 0 | 50 | 2023-02-01 00:00:00
Frisk Chili | 100030001 | 1 | 1 | 9 | 0 |  | 36 | 0 | 36 |  | 45 | 0 | 45 | 2023-02-01 00:00:00
Piment/løgkompot | 10070007 | 1 | 1 | 4 | 0 |  | 32 | 0 | 32 |  | 40 | 0 | 40 | 2023-02-01 00:00:00
Coca Cola Zero | 100020002 | 1 | 1 | 2 | 0 |  | 32 | 0 | 32 |  | 40 | 0 | 40 | 2023-02-01 00:00:00
[NAME] | 700010014 | 1 | 1 | 5 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 2023-02-01 00:00:00
Spreadsheet: 733193d1621435649-combine-2-rows-into-1-cell-sample
Sheet: Sheet1

Data |  |  |  | Result
Employee | Family | Name |  | Employee | Spouse | Children
[NAME] | Wife | [NAME] |  | [NAME] | [NAME] | [NAME], [NAME]
[NAME] | Son | Mark |  | Jessica | Jeremy | Emily, [NAME]
[NAME] | Son | [NAME]
Jessica | Husband | Jeremy
Jeremy | Daughter | Emily
Jeremy | Son | [NAME]
Spreadsheet: 255d1d53-7ccd-4a35-bf07-699b18e73cc7
Sheet: 10b

Product1 | EUR3 | USD | GBP | [NAME] | AUD | CAD | OTHER | TOTAL
Cross-Currency Basis | 2268065 | 9803085 | 597224 | 854559 | 581805 | 147018 | 386179 | 14637935
Cross-Currency Fixed-Fixed | 74552 | 180306 | 61974 | 33939 | 9005 | 27263 | 33540 | 420579
Cross-Currency Fixed-Float | 163448 | 345532 | 44800 | 62431 | 52475 | 15787 | 613185 | 1297658
TOTAL | 2506065 | 10328923 | 703998 | 950929 | 643285 | 190068 | 1032904 | 16356172
Spreadsheet: 141539d1329321167-help-need-with-sum-if-upgraded-from-2003-to-2010-credit-card-ledger
Sheet: Sheet1

American Express
Month
Category | Sub-Category | Vendor |  | Description | Date | Amount
Household | Subscriptions |  |  |  |  | 100
Household | Haircutss |  |  |  |  | 100
Household | Groceries |  |  |  |  | 100
Household | Repairs |  |  |  |  | 100
Household | Groceries |  |  |  |  | 100
Household | Subscriptions |  |  |  |  | 100
Household | Haircutss |  |  |  |  | 100
Household | Groceries |  |  |  |  | 100
Household | Repairs |  |  |  |  | 100
Household | Groceries |  |  |  |  | 100
Household | Subscriptions |  |  |  |  | 100
Household | Haircutss |  |  |  |  | 100
Household | Groceries |  |  |  |  | 100
Household | Repairs |  |  |  |  | 100
Household | Groceries |  |  |  |  | 100
Household | Subscriptions |  |  |  |  | 100
Household | Haircutss |  |  |  |  | 100
Household | Groceries |  |  |  |  | 100
Household | Repairs |  |  |  |  | 100
Household | Groceries |  |  |  |  | 100
Category Totals
Household | Groceries
Household | Subscriptions
Household | Haircutss
Household | Groceries
Household | Repairs
Spreadsheet: 864514d1711648807-excel-counting-work-time-with-lookup-function-time2
Sheet: Sheet1

 |  | Format | Named cell / range | formula | Turn in date: (Range Name) T1ndate | Time (Range Name) T1me
 |  |  |  | Date: m/d/yy 1:30 PM --> | 2024-01-23 17:24:00 | 9.8 | <--- Number: 0.1 decimal
 |  |  |  | equal sign removed | 2024-01-24 16:26:00 | 8
REQUEST START: | 2024-03-28 07:00:00 | Custom: m/d/yyyy h:[NAME] | Date3 | - | 2024-02-29 16:17:00 | 1.6
Work Finished: | 2024-03-28 12:30:00 | Custom: m/d/yyyy h:[NAME] | Date5 | - | 2024-02-29 16:19:00 | 6.8
Time to complete task --> |  | Number: 0.1 decimal | Timec1 | (Date5-Date3)/0.0401 | 2024-03-21 07:16:00 | 1
Today's Date: |  | Custom: m/d/yy | Date1 | NOW() | 2024-03-21 07:14:00 | 2.2
Report Date: | 2024-03-28 00:00:00 | Date: m/d/yy | Date2 | - | 2024-03-21 10:15:00 | 1.8
Time stamp,  During Save: | 2024-03-28 14:00:00 | Custom: m/d/yyyy h:[NAME] | [NAME] | - | 2024-03-21 14:58:00 | 0.5
Hours worked Today: |  | Number: 0.1 decimal | T1dywrk | COUNTIFS(T1me,">="&Date1,T1me,"<"&Timec1)+Timec1 | 2024-03-21 15:07:00 | 3.1
This week |  | Number: 0.1 decimal | [NAME] | SUMIF(T1me, Date1,T1ndate) | 2024-03-21 15:12:00 | 1
This Month |  | Number: 0.1 decimal | [NAME] | SUMIFS(T1me,T1ndate,">="&Date1-@march) | 2024-03-21 15:37:00 | 1
Time needed  for 10 hours |  | Number: 0.1 decimal | - | T1dywrk-10 | 2024-03-25 07:54:00 | 10
Excel, counting time with lookup. I would like to use a lookup formula (T1ndate) & get hour time from (T1me) I’m having formula trouble looking up and adding time worked in one day, a week, and a month. I’ve tried many formulas and formats but can’t get the correct time worked. Using named ranges  for columns F & G are on a separate tab Formatting as shown |  |  |  |  | 2024-03-26 07:22:00 | 9.5
 |  |  |  |  | 2024-03-26 17:32:00 | 1
 |  |  |  |  | 2024-03-26 17:33:00 | 9.5
 |  |  |  |  | 2024-03-28 07:10:00 | 7.5
 |  |  |  |  | 2024-03-28 07:12:00 | 1.1
 |  |  |  |  | 2024-03-28 08:48:00 | 1
Spreadsheet: 87944d1287804797-pivottable-sum-with-calculated-pivotfield-pivtotable-question
Sheet: Sheet1

Job # | Employee | Start Time | End Time | RATE | Cost |  | EmpNum | EmpName | Rate
1000 | 1 | 09:00:00 | 12:00:00 |  |  |  | 1 | A | 1
1000 | 2 | 09:30:00 | 13:00:00 |  |  |  | 2 | B | 1
1000 | 3 | 09:30:00 | 13:00:00 |  |  |  | 3 | C | 1
1001 | 2 | 14:00:00 | 14:30:00 |  |  |  | 4 | D | 1
1001 | 4 | 09:00:00 | 14:00:00 |  |  |  | 5 | E | 1
1001 | 5 | 12:00:00 | 14:00:00
 |  |  | Values
 |  | Job # / Employee | Sum of Total Hours (Caclulated Field) | Sum of Cost from Table | Sum of Labor Cost (Caclulated Field)
 |  | 1000 | 10:00:00 | 10 | 29.99999999999999 | <<How to make this $10 from a calculated PivotTable Field?
 |  | 1 | 3:00:00 | 3 | 3 |  | Appears to be (hours)*(sum(rates)) = 10 * 3 = 30
 |  | 2 | 3:30:00 | 3.5 | 3.5
 |  | 3 | 3:30:00 | 3.5 | 3.5
 |  | 1001 | 7:30:00 | 7.5 | 22.5 |  | (hours)*(sum(rates))=7.5*3=22.50  When I need the answer to be $7.50
 |  | 2 | 0:30:00 | 0.4999999999999982 | 0.4999999999999982 |  | I would prefer to not have to store the calculated field "cost" in the Job Details table above
 |  | 4 | 5:00:00 | 5.000000000000001 | 5.000000000000001 |  | Suggestions??
 |  | 5 | 2:00:00 | 2.000000000000001 | 2.000000000000001
 |  | Grand Total | 17:30:00 | 17.5 | 105
Spreadsheet: 675199d1588191770-compare-4-columns-sample-2-
Sheet: DeviceInfo

User's Device | BIOS | Need update
Latitude 5591 | 1.7.4 | Yes | Since this is lower than the version available.
Latitude 5590 | 1.10.1 | Yes
Latitude 5491 | 1.10.1 | Yes
Latitude 5580 | 1.15.1 | Yes
Latitude 5491 | 1.8.1 | Yes
Latitude 5480 | 1.10.4 | Yes
Latitude 7480 | 1.16.1 | No | Since this matches the manufacturer current version no upate is needed.
Latitude 5491 | 1.6.1 | Yes
Latitude 5491 | 1.10.1 | Yes
Latitude 5580 | 1.16.0 | No | Since this matches the manufacturer current version no upate is needed.
Spreadsheet: 2dbca647-ee2a-4f38-bcf8-d237365a5031
Sheet: Avis de remise

COL_MSG | COL_CODE_DATES |  |  |  | COL_MNT_DATE_CHK
 | 66329
[NAME] | Acier Dion Inc.
 |  | Mois de remise |  | Mois de remise | 2013-02
Responsable facturation | [NAME] |  |  |  |  |  |  | Chèque
Service | Service de la paie | Total employé |  |  |  |  |  | Paiement électronique (Internet)
Entreprise |  | Total employeur |  |  |  |  |  | Virement bancaire
 |  | Total Autre
 |  | Total contribution
Remise couvrant la période du | 2013-01-30 au 2013-02-26 |  |  |  | 0
Période de remise corrigée |  | Montant du paiement
 |  | Date du paiement
Début 1ère période de paie couverte | 2011-01-23
Fin dernière période de paie couverte | 2011-02-19
 |  | Mode de paiement
Les remises du mois doivent être reçues au plus tard le 15 du mois suivant. Pour tout renseignement, n'hésitez pas à contacter le service aux employeurs au (514) 385-3723  ou de l'extérieur de Montréal au [PHONE]
Au Fonds de solidarité FTQ, on ne vous traite pas comme un numéro, mais on a quand même besoin du vôtre!  On aimerait bien vous [NAME] … [NAME] mille entreprises offrent la retenue sur le salaire à leurs employés.  Nous vous demandons [NAME] vouloir vous identifier systématiquement sur vos paiements et vos documents au moyen de votre NUMÉRO DE RÉFÉRENCE.  Pour nous c'est essentiel, [NAME]
Spreadsheet: 33883d1230744874-merging-rows-with-similar-information-addresses2
Sheet: Sheet3

[NAME] and [NAME] | Bloggs | 1 | Main Street
[NAME] | Cloggs | 2 | Main Street
[NAME], [NAME] and [NAME] | Floggs | 3 | Main Street
[NAME] | Jones | 4 | Main Street
[NAME] | Smith | 4 | Main Street
[NAME] and [NAME] | [NAME] | 5 | Main Street
[NAME] | Murphy | 5 | Main Street
Spreadsheet: tracy_geaccone__40272__AEL 06 01 (GBP)
Sheet: Acct. Rec.

Azurix Europe Ltd
Summary Accounts Receivable Aging
June 2001
(£ sterling millions)
 |  |  |  |  |  | Overdue |  | Overdue |  | Overdue |  | Overdue |  | Overdue >
Customer/Type |  | Balance |  | Current |  | 1 to 6 mths |  | 7 to 12 mths |  | 1 to 2 yrs |  | 2 to 3 yrs |  | 3 yrs
Unmeasured - instalments |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Unmeasured - summonsed |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Unmeasured - other |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Trade effluent |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Miscellaneous debt |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Measured debt |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
TOTAL
Others (in total)
Total current month
Total prior month
Spreadsheet: darrell_schoolcraft__7774__imbalsumm0106
Sheet: EPFS

 | El Paso/TW Eddy Rec
 | 78093
Day | Measured | Scheduled
1 | 24912 | 30000
2 | 36015 | 30000
3 | 42137 | 30000
4 | 32489 | 40000
5 | 39177 | 38000
6 | 39137 | 38000
7 | 29194 | 38000
8 | 34268 | 38000
9 | 33780 | 37999
10 | 33193 | 37999
11 | 2357 | 23999
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-05-31 00:00:00 |  |  | -112130.12
2001-06-13 00:00:00
Spreadsheet: 777402d1650370121-a-formula-to-find-a-replace-text-from-one-column-to-the-other-into-quotes-i-need-one-exampleworkbook
Sheet: vp_fr-ca.yml

title: "Sed ut perspiciatis unde omnis iste"
subtitle: "[NAME] ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et [NAME]."
title: "Can't find the job you're looking for?"
text: "We're always on the lookout for new talent. Join our talent cloud and if a position becomes available that we think will suit you, we'll be in touch!"
button: "Join our talent cloud"
privacy: "Privacy Policy"
cookies: "Cookies Settings"
de: "Delaware"
dc: "District of Columbia"
fl: "Florida"
ga: "Georgia"
hi: "Hawaii"
id: "Idaho"
il: "Illinois"
in: "Indiana"
ia: "Iowa"
ks: "Kansas"
ky: "Kentucky"
la: "Louisiana"
Spreadsheet: 763335d1642108105-xlookup-dual-criteria-book2
Sheet: allowances

ITEM | PLACE1 | PLACE2 | PLACE3 | PLACE4
PART1 | 1 | 3 | 5 | 7 |  |  | The gray numbers are the allowances by part and location.
PART2 | 2 | 9 | 9 | 6
PART3 | 4 | 27 | 17 | 5
PART4 | 8 | 81 | 33 | 4
PART5 | 16 | 243 | 65 | 3
PART6 | 32 | 729 | 129 | 2
PART7 | 64 | 2187 | 257 | 1
[NAME] | 28 | 61 | 13 | 0
PART9 | 56 | 83 | 25 | 0
PART10 | 12 | 49 | 49 | 0
Spreadsheet: 598554d1542587965-retail-inventory-calculating-multiple-items-in-a-sale-retail-inventory-23102018
Sheet: Orders_and_Inventory

INVENTORY AND SALES MANAGER - ORDERS AND INVENTORY |  |  |  |  |  |  |  |  | Products | Report | Terms
 | CURRENT INVENTORY LEVEL |  |  |  | CHOOSE PRODUCT |  | PRODUCTS WHERE CURRENT INVENTORY <= RE-ORDER POINT
 |  |  |  |  | P3 |  | Product | Current Inventory | Re-order Point | Pending Purchase Quantity
 |  |  |  |  |  |  |  |  |  |  | 27
 | PRODUCTS AVAILABLE | QUANTITY | PRODUCTS TO RE-ORDER | CURRENT INVENTORY
 | ORDER ITEMS THAT CANNOT BE FULFILLED* |  |  | RE-ORDER POINT
 |  |  |  | PENDING PURCHASE QUANTITY
 |  |  |  | PENDING SALES QUANTITY
 | CURRENT | FUTURE
 | *where Sale quantity is higher than Inventory available - highlighted with red border in the table below
ENTER YOUR ORDER DETAILS |  |  |  |  |  |  |  | these  columns are automatically calculated
Order Number | Order Date | Order Type | Expected Date | Partner | Product Name | Quantity | Unit Price | Amount | Product Category | YearMonth | Inventory Availability
100 | 2018-10-13 00:00:00 | Purchase | 2018-10-15 00:00:00 | SI | P1 | 10 | 5.99
101 | 2018-10-13 00:00:00 | Purchase | 2018-10-15 00:00:00 | SI | P2 | 10 | 5.68
102 | 2018-10-13 00:00:00 | Purchase | 2018-10-15 00:00:00 | SI | P3 | 3 | 5.09
103 | 2018-10-13 00:00:00 | Purchase | 2018-10-15 00:00:00 | SI | P4 | 10 | 5.09
104 | 2018-10-13 00:00:00 | Purchase | 2018-10-15 00:00:00 | SI | P5 | 10 | 5.23
105 | 2018-10-13 00:00:00 | Purchase | 2018-10-15 00:00:00 | SI | P6 | 10 | 4.97
106 | 2018-10-13 00:00:00 | Purchase | 2018-10-15 00:00:00 | SI | P7 | 10 | 5.3
107 | 2018-10-13 00:00:00 | Purchase | 2018-10-15 00:00:00 | SI | P8 | 10 | 4.76
108 | 2018-10-13 00:00:00 | Purchase | 2018-10-15 00:00:00 | SI | P9 | 10 | 4.49
109 | 2018-10-13 00:00:00 | Purchase | 2018-10-15 00:00:00 | SI | P10 | 10 | 4.49
Sale 1 | 2018-10-13 00:00:00 | Sale | 2018-10-15 00:00:00 | SI | Pack 1 | 2 | 50
Sale 2 | 2018-10-13 00:00:00 | Sale | 2018-10-15 00:00:00 | SI | Pack 2 | 2 | 70
110 | 2018-11-19 00:00:00 | Purchase | 2018-11-19 00:00:00 | SI | P3 | 5 | 5.09
Spreadsheet: kimberly_watson__20552__imbalsumm0108
Sheet: summary

TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES |  |  |  |  |  | index
 |  |  |  |  |  | SJ
Positive=due [NAME] |  | Negative = due operator |  |  |  | AVG
 |  |  |  |  |  | NTXPH
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
[NAME] |  |  |  | Volumetric | [NAME]
Conoco |  |  |  | Dollar Valued | [NAME] | [NAME] and Maljamar
NNG |  |  |  | Dollar Valued | [NAME]
EPFS / PG&E TX |  |  |  | Dollar Valued | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME]
NGPL |  |  |  | Volumetric | [NAME]
Amoco Abo |  |  |  | Dollar Valued | [NAME]
CIG |  |  |  | Dollar Valued | [NAME]
Mojave Pipeline |  |  |  | Volumetric | [NAME]
Duke/GPM |  |  |  | Dollar Valued | [NAME] | Crawford, Pecos Diamond, [NAME], Linam Ranch, Artesia
SoCal |  |  |  | Volumetric | [NAME]
Red Cedar |  |  |  | Volumetric | [NAME]
Mewborne |  |  |  | Dollar Valued | [NAME]
Amoco |  |  |  | Volumetric | [NAME]
Panhandle Eastern |  |  |  | Volumetric | [NAME] | Hansford
PNM |  |  |  | Dollar Valued | [NAME]
El Paso |  |  |  | Volumetric | [NAME] | Blanco and Window Rock
EOG |  |  |  | Dollar Valued | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME] | cashed out monthly
Lonestar |  |  |  | Volumetric | [NAME]
Oasis |  |  |  | Volumetric | [NAME]
PG&E Topock |  |  |  | Volumetric | [NAME]
Burlington |  |  |  | Dollar Valued | [NAME] | balance is cashed out monthly
Northwest |  |  |  | Volumetric | [NAME]
TransColorado |  |  |  | Dollar Valued | [NAME]
Receivable imbalances
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
Citizens Communications |  |  |  | Dollar Valued | [NAME]
North Star Steel |  |  |  | Dollar Valued | [NAME]
Citizens-Griffith |  |  |  | Dollar Valued | [NAME]
Agave |  |  |  | Dollar Valued | [NAME]
El Paso Field Services |  |  |  | Dollar Valued | [NAME]
Continental |  |  |  | Dollar Valued | [NAME]
Calpine |  |  |  | Dollar Valued | [NAME]
Payable imbalances
Net imbals
Note -  This report does not represent the total population of imbalances on Transwestern.
Spreadsheet: 2f55f4a3-d3b1-432f-8d68-b15bd77cbd0e
Sheet: GF Table

State of the State Budget: Five-Year Forecast for FY 2013-14 through FY 2017-18
 | Description | 2012-13 |  | 2013-14 | 2014-15 | 2015-16 | 2016-17 | 2017-18
1 | Revenues (under current tax structure) | 20177.9
2 | % Change from Prior Year
3
4 | Main Economic Drivers from Global Insight July/August 2012 Forecast (% Growth )
5 | Wages | 0.032 |  | 0.042 | 0.048 | 0.05 | 0.049 | 0.047
6 | Nonfarm Employment | 0.011 |  | 0.017 | 0.021 | 0.023 | 0.022 | 0.018
7 | Retail Sales | 0.032 |  | 0.033 | 0.034 | 0.039 | 0.047 | 0.042
8 | Corporate Profits | 0.075 |  | 0.016 | 0.028 | -0.001 | -0.02 | -0.005
9
10 | Expenditures
11 | Recurring Baseline Budget | 19937 |  | 20070 | 20070 | 20070 | 20070 | 20070
12
13 | Other Adjustments:
14 | CPI Inflation on Non-Salary and Health Expenses | 0 |  | 65.7
15 | Public School Enrollment | 62.4 |  | 56.9
16 | Community Colleges Enrollment | 5.2 |  | 18.8
17 | Medicaid (6% growth in out years) | 194.2 |  | 174
18 | State Health Plan Premiums (7.2% growth in out years) | 0 |  | 92
19 | Retirement System Contributions | 0 |  | 0 | 75.7
20 | Compensation Increases (1.9% each year) | 39 |  |  | 503.4 | 760 | 1021.4 | 1287.8
21 | Other | -59.9 |  | 0 | 0 | 0 | 0 | 0
22 | Subtotal
23
24 | Total Expenditures
25
26 | Balance Available
27
28 | Available Resources for UNC System
29 | Annual Increases - Continue as 13% of State Budget
30 | [NAME] as 13% of State Budget |  |  | 0
31 | Each Additional 1% Growth in Base Revenues
32 | [NAME] as 13% of State Budget
33 | Sources of Data:
34 | Economic Drivers -- Global Insight July/August 2012 Forecast; data provided by the Office of State Budget and Management
35 | Public School Enrollment -- Department of Public Instruction estimates
36 | Community Colleges Enrollment -- Department of Community Colleges estimates
37 | Medicaid -- average growth over last five years
38 | State Health Plan Premiums -- Fiscal Research Division from Department of State Treasurer information
39 | Retirement System Contributions -- Fiscal Research Division from Department of State Treasurer information
40 | Compensation Increases -- average increase over last ten years
Spreadsheet: 863501d1710955251-finding-matching-numbers-in-3-different-cells-find-numbers
Sheet: Sheet1

Lookup this: | 12,7,61
Identify  Row | HERE | if found.
In these columns: | A | B | C
 | 1 | 2 | 3
 | 2 | 3 | 4
 | 3 | 4 | 5
 | 4 | 5 | 6
 | 5 | 6 | 7
 | 6 | 7 | 8
 | 7 | 8 | 9
>>> | 61 | 12 | 7
 | 9 | 10 | 11
 | 10 | 11 | 12
 | 11 | 12 | 13
 | 12 | 13 | 14
 | 13 | 14 | 15
 | 14 | 15 | 16
 | 15 | 16 | 17
 | 16 | 17 | 18
 | 17 | 18 | 19
 | 18 | 19 | 20
Spreadsheet: 849126d1699649910-lookup-and-find-the-in-between-days-and-return-number-of-days-20231109
Sheet: Sheet2

Number | Date From | Date To | Number Of Days |  | Helper
30114 | 2021-09-02 00:00:00 | 2021-09-16 00:00:00
30114 | 2021-12-06 00:00:00 | 2021-12-12 00:00:00
30114 | 2022-01-10 00:00:00 | 2022-01-31 00:00:00
30114 | 2022-02-01 00:00:00 | 2022-02-13 00:00:00
30114 | 2022-04-25 00:00:00 | 2022-04-25 00:00:00
30153 | 2021-06-12 00:00:00 | 2021-06-30 00:00:00
30153 | 2021-07-01 00:00:00 | 2021-07-05 00:00:00
30153 | 2021-07-10 00:00:00 | 2021-07-31 00:00:00
30153 | 2021-08-01 00:00:00 | 2021-08-08 00:00:00
30153 | 2023-04-01 00:00:00 | 2023-04-30 00:00:00
30153 | 2023-05-01 00:00:00 | 2023-05-31 00:00:00
30153 | 2023-06-01 00:00:00 | 2023-06-30 00:00:00
30159 | 2021-08-23 00:00:00 | 2021-08-31 00:00:00
30159 | 2021-09-01 00:00:00 | 2021-09-16 00:00:00
30159 | 2022-01-17 00:00:00 | 2022-01-31 00:00:00
30159 | 2022-02-12 00:00:00 | 2022-02-19 00:00:00
30159 | 2022-02-20 00:00:00 | 2022-02-20 00:00:00
30159 | 2022-02-23 00:00:00 | 2022-02-28 00:00:00
30159 | 2022-03-01 00:00:00 | 2022-03-06 00:00:00
30165 | 2021-07-26 00:00:00 | 2021-07-31 00:00:00
30165 | 2021-09-18 00:00:00 | 2021-09-18 00:00:00
30165 | 2021-11-20 00:00:00 | 2021-11-25 00:00:00
30165 | 2021-11-26 00:00:00 | 2021-11-30 00:00:00
30165 | 2021-12-01 00:00:00 | 2021-12-02 00:00:00
30165 | 2021-12-13 00:00:00 | 2021-12-13 00:00:00
30165 | 2022-03-19 00:00:00 | 2022-03-31 00:00:00
30165 | 2022-04-01 00:00:00 | 2022-04-30 00:00:00
30165 | 2022-05-01 00:00:00 | 2022-05-01 00:00:00
30165 | 2022-06-06 00:00:00 | 2022-06-30 00:00:00
30165 | 2022-07-01 00:00:00 | 2022-07-31 00:00:00
30675 | 2021-08-19 00:00:00 | 2021-08-22 00:00:00
30675 | 2021-09-27 00:00:00 | 2021-09-30 00:00:00
30675 | 2021-10-01 00:00:00 | 2021-10-11 00:00:00
30675 | 2021-10-18 00:00:00 | 2021-10-24 00:00:00
30675 | 2022-03-22 00:00:00 | 2022-03-23 00:00:00
30675 | 2022-04-04 00:00:00 | 2022-04-17 00:00:00
30675 | 2022-05-30 00:00:00 | 2022-05-31 00:00:00
30675 | 2022-06-01 00:00:00 | 2022-06-12 00:00:00
Spreadsheet: 50315d1249676683-how-can-i-get-around-the-dv-drop-down-list-limit-test
Sheet: Tech IDs

[NAME] | T-095
[NAME] | T-209
[NAME] | T-290
Billy | T-294
[NAME] | T-382
[NAME] | T-428
[NAME] | T-459
Jessica | T-476
[NAME] | T-480
[NAME] | AMG
Debbie | BAN
[NAME] | FC
[NAME] | JAP
[NAME] | [NAME]
Sydney | [NAME]
Taj | LLS
Kelly | MOA
Jon | MC
[NAME] | PJ
[NAME] | RST
Eddie | SRC
Thorn | TAA
Peaches | PPP
Nickel | NNN
Yellow | YYY
Spreadsheet: 727560d1617964136-help-with-a-dynamic-filtering-table-book1
Sheet: Sheet1

List 1 | List 2 | List 3 | List 4 | List 5
Ant | 1 | A | AA | AAA
Ant | 2 | B | BB | BBB
Ant | 3 | C | CC | CCC
[NAME] | 4 | D | DD | DDD
[NAME] | 5 | E | EE | EEE
[NAME] | 6 | F | FF | FFF
Cat | 7 | G | GG | GGG
Cat | 8 | H | HH | HHH
Cat | 9 | I | II | III
Dog | 10 | J | JJ | JJJ
Dog | 11 | K | KK | KKK
Dog | 12 | L | LL | LLL
Spreadsheet: 154945d1336617560-excel-2007-need-help-to-count-and-identify-neighbour-text-cells-above-and-below-of-the-key-text-sample
Sheet: Sheet1

 | ZOO |  |  |  |  | Count
 | Panda |  |  |  | Panda
 | Lion |  |  |  | Giraffe
 | Giraffe |  |  |  | Camel
 | Camel |  |  |  | Ostrich
 | Panda |  |  |  | Zookeeper
 | Ostrich |  |  |  | Lion
 | Giraffe
 | Lion |  |  |  |  | Count
 | Ostrich |  |  |  | Panda | 1
 | Panda |  |  |  | Giraffe | 2
 | Giraffe |  |  |  | Camel | 0
 | Zookeeper |  |  |  | Ostrich | 1
 | Panda |  |  |  | Zookeeper | 0
 | Camel |  |  |  | Lion | 2
 | Panda
 | Ostrich