tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: chris_stokley__3980__Enron True-Upcorrect
Sheet: Sheet1

Harbor True-Up Action Itens
 |  |  |  |  |  | Day Ahead less Gas | ISO | Services Desk Profit | Total | Payments | Net
July '00
 |  |  |  |  |  |  | 1683012.18 |  |  | 3179331.16
 |  |  |  | Gas Annuity = |  | 1336995.67
 |  |  |  | Services Desk Annuity = |  | 12843.83
Aug
1.  Enter annuity deal for Services Desk Profit |  |  |  |  |  |  | 2033138.06 | 143934.91 |  | 3412253.44
 |  |  |  | Gas Annuity = |  | 2211292.1
 |  |  |  | Services Desk Annuity = |  | 218934.91
Sep
1  Wait on ISO completion later this week and enter in |  |  |  |  |  |  | 760530.99 | 73284.24 |  | 1032095.36
ISO deal |  |  |  | Gas Annuity = |  | 1696221.18
2.  Recalc Services Profit |  |  |  | Services Desk Annuity =
2.  Reverse annuity in system (#442268)
3.  Enter annuity deal for Services Desk Profit
Oct |  |  |  |  |  |  | 163320.38 | 4554.8 |  | 371091.21
1.  Pay Day Ahead Amount less gas
2.  Complete ISO True-Up
3.  Recalc. Services Profit
4.  Enter Services Annuity
Nov |  |  |  |  |  |  | -364123 | 14135.28 |  | 410000
1.  Pay Day Ahead Amount less gas
2.  Complete ISO True-Up
3.  Recalc. Services Profit
4.  Enter Services Annuity
5.  Reverse Annuity Deals(# 460487, 460482, 482864, 461206, 462174)
Dec
1.  Pay Day Ahead Amount less gas |  |  |  |  |  |  |  | 0 |  | 0
2.  Complete ISO True-Up
3.  Recalc. Services Profit
4.  Enter Services Annuity
Jan
1.  Pay Day Ahead Amount less gas |  |  |  |  |  |  | 16401.56 | 20495.69 |  | 669376.7
2.  Complete ISO True-Up
3.  Recalc. Services Profit
4.  Enter Services Annuity
Feb
1.  Pay Day Ahead Amount less gas |  |  |  |  |  |  | 11787 | 0 |  | 27298.16
2.  Complete ISO True-Up
3.  Recalc. Services Profit
4.  Enter Services Annuity
Spreadsheet: dutch_quigley__9182__enron delta breakdown  12-3
Sheet: Sheet1

ENRON position breakdown (BOD 12-03-01)
Month | Futures | Options Delta | Overall Delta
F02 | -2292 |  | -145
G02 | 782 |  | 4
H02 | -1101 |  | 132
[NAME] | 3212 |  | 731
K02 | -662 |  | -47
M02 | -551 |  | -503
N02 | 143 |  | 134
Q02 | -331 |  | -378
U02 | -1137 |  | -1031
V02 | 76 |  | 76
X02 | 8 |  | 8
[NAME] | 75 |  | -211
H03 | 273 |  | -5
K03 | -212 |  | -212
M03 | 460 |  | 477
U03 | -54 |  | -47
V03 | 60 |  | 60
Z03 | 1523 |  | -81
G04 | 1228 |  | 1228
H04 | 125 |  | 0
 |  | Overall:
Spreadsheet: 709367d1608269289-data-validation-case-sensitive-issues-sample-workbook
Sheet: Lists

Personal Account Category
Clothing |  | clothing |  | Clothing | clothing
Education
Entertainment
Gifts
Toiletries
Medical
Linen
Equipment
Food - Personal
Food - Takeaway
Hairdressing
Subscriptions
Community Access Activity
Telephone - Personal
Transport
Travel
Bank Fees
Complimentary therapies
Animal care
[NAME] activities
Other
Pocket Money
Transfer to Trust Account
Refund
Cash Withdrawal
Deposit – Special Purchase
Deposit – Accumulated Funds
Unspent - Requested funds to be returned
Spreadsheet: tracy_geaccone__40512__EREC IC 0914
Sheet: Invoice

 | Enron Net Works
 | 1400 Smith Street
 | Houston, Texas 77002
 | 9/19/01 Intercompany billing for 2002
To: EREC
 | Accounting Contact: | [NAME]
 | Other Contact: | [NAME]
Description | Assessment Information | Amount
EnronOnlince | 2002 Assessments will be based on actuals | 0
Energy Operations | 2002 Assessments will be based on actuals | 0
IT eCommerce | 2002 Assessments will be based on actuals | 0
IT Development | 2002 Assessments will be based on actuals | 0
IT Infrastructure | 2002 Assessments will be plan with periodic true up
IT Infrastructure - Pass Throughs * | 2002 Assessments will be based on actuals
Total  IT Infrastructure
IT Enterprise Portal Solutions | 2002 Assessments will be based on actuals
 | TOTAL
Footnotes:
*Consistent with 2001, pass through billings (long distance, market data, WAN, etc.) will not be included in the
standard assessments ("8xxxxxxx" accounts).  They will be posted directly to direct expenses ("52020000" account)
at the cost center level.  This pass through number is only a high level place holder and is not intended to replace
the dollars already being budgeted for by each cost center owner.
Spreadsheet: 119987d1314903012-excel-2007-calculated-item-error-with-subtotals-and-grand-total-calculated-item-example
Sheet: Incorrect Calc Item Example

Sum of Volume | Column Labels
Row Labels | FY2011-01 | FY2012-01 | Month to Prior Year Month |  | Correct
Service Line X | 6617 | 5462 | -1.148791395081408 | << Not correct percent change
Facility1 | 219 | 240 | 0.09589041095890405
Facility2 | 392 | 304 | -0.2244897959183674
Facility3 | 1426 | 739 | -0.4817671809256662
Facility4 | 1995 | 1821 | -0.08721804511278197
Facility5 | 30 | 19 | -0.3666666666666667
Facility6 | 2555 | 2339 | -0.08454011741682976
Service Line Z | 8764 | 7027 | -1.109626065890162 | << Not correct percent change
Facility1 | 277 | 318 | 0.1480144404332131
Facility2 | 554 | 408 | -0.2635379061371841
Facility3 | 1900 | 966 | -0.491578947368421
Facility4 | 2600 | 2300 | -0.1153846153846154
Facility5 | 33 | 24 | -0.2727272727272727
Facility6 | 3400 | 3011 | -0.1144117647058823
Grand Total | 15381 | 12489 | -2.25841746097157 | << Not correct percent change
Spreadsheet: 849500d1699960446-round-off-time-in-a-cell-based-on-the-dropdown-list-and-a-formula-testing-5
Sheet: WMC CDO

 |  | Name | Area | Designation | SSS | Pag-ibig | Philhealth | TIN
 |  |  |  |  |  |  |  |  | Time In | Time Out | [NAME] | Proportion of 24hr day worked | Hours of work per day | Time In | Time Out | [NAME] | Proportion of 24hr day worked | Hours of work per day | Time In | Time Out | [NAME] | Proportion of 24hr day worked | Hours of work per day | Time In | Time Out | [NAME] | Proportion of 24hr day worked | Hours of work per day | Time In | Time Out | [NAME] | Proportion of 24hr day worked | Hours of work per day | Time In | Time Out | [NAME] | Proportion of 24hr day worked | Hours of work per day | Time In | Time Out | [NAME] | Proportion of 24hr day worked | Hours of work per day | Time In | Time Out | [NAME] | Proportion of 24hr day worked | Hours of work per day | Time In | Time Out | [NAME] | Proportion of 24hr day worked | Hours of work per day | Time In | Time Out | [NAME] | Proportion of 24hr day worked | Hours of work per day | Time In | Time Out | [NAME] | Proportion of 24hr day worked | Hours of work per day | Time In | Time Out | [NAME] | Proportion of 24hr day worked | Hours of work per day | Time In | Time Out | [NAME] | Proportion of 24hr day worked | Hours of work per day
 |  |  |  | OFFICE |  |  |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667
 |  |  |  | OFFICE |  |  |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667
 |  |  |  |  |  |  |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667 |  |  |  |  | 0.0416666666666667
 |  |  |  | OFFICE
 |  |  |  | OFFICE
 |  |  |  | OFFICE
 |  |  |  | WAREHOUSE DELIVERY
Spreadsheet: 725321d1616617161-excel-newbie-nested-if-functions-in-a-gantt-chart-stack-model-gantt-chart-help
Sheet: Example

 |  |  |  | 2020-01-06 00:00:00
 |  |  |  | 1
 |  |  |  | 2020-01-01 00:00:00 |  |  |  | 2020-02-01 00:00:00 |  |  |  | 2020-03-01 00:00:00 |  |  |  |  | 2020-04-01 00:00:00
Target at Budget | Current Target | Longstop to hit plan
2020-01-10 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00
2020-02-20 00:00:00 | 2020-02-20 00:00:00 | 2020-04-01 00:00:00
2020-05-01 00:00:00 | 2020-02-01 00:00:00 | 2020-05-01 00:00:00
Target at Budget | Current Target | Longstop to hit plan
2020-01-10 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00
2020-02-20 00:00:00 | 2020-02-20 00:00:00 | 2020-02-20 00:00:00
2020-05-01 00:00:00 | 2020-02-01 00:00:00 | 2020-05-01 00:00:00
 |  |  |  | BTL | Budget & Target & Longstop
 |  |  |  | BT_ | Budget & Target
 |  |  |  | B_L | Budget  & Longstop
 |  |  |  | B__ | Budget
 |  |  |  | _TL | Target & Longstop
 |  |  |  | _T_ | Target
 |  |  |  | __L | Longstop
 |  |  |  | ___
 |  |  |  |  |  | Hi Everyone,
 |  |  |  |  |  | I am trying to create [NAME] to track projects.
 |  |  |  |  |  | I have made my first attempt using the following methodology:
 |  |  |  |  |  | Step 1: Use Excel Formula to generate a value within the cell based on if the dates match those in Columns A-C "Budget/Target,Longstop" (See Row 6)
 |  |  |  |  |  | Step 2: Use Conditional Formatting to allocate a colour to the cell (See Row 6)
 |  |  |  |  |  | I would appreciate assistance with the following issues:
 |  |  |  |  |  | Issue 1: When the Target/Budget/Longstop dates are the same, I would like the cell to return a value showing "budget + target" if the budget and target dates were the same, "budget + longstop" if the budget and longstop dates were the same, and so on (See Row 7 and 8)
 |  |  |  |  |  | Issue 2: When there is no date in one of the columns A-C or there is a #N/A, I would like the formula to still work to pull in the data from the other columns (See Rows 12-14). In Row 13 I have attempted to create a formula but it hasn't worked and I am totally lost.
 |  |  |  |  |  | Please could someone help me create the appropriate formulas?
 |  |  |  |  |  | Thank you in advance.
Spreadsheet: 780037d1652264522-lookup-longest-date-of-completion-lookup-longest-date-aligw
Sheet: Sheet1

JOB | Balance | Comp. Dt. | 11.May | 12.May | 13.May | 14.May | 15.May | 16.May | 17.May | 18.May | 19.May | 20.May | 21.May | 22.May | 23.May | 24.May | 25.May | 26.May | 27.May | 28.May | 29.May | 30.May | 31.May
HY-0123 | 0.689 |  | 0.2 |  |  | 0.2 |  |  | 0.289
HY-0234 | 0.997 |  | 0.3 | 0.1 |  |  | 0.4 |  |  |  |  | 0.197
HY-0345 | 0.41
HY-0456 | 9.482 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.482
Spreadsheet: 219187d1362679444-automatically-updating-multiple-sheets-to-a-master-sheet-master-test
Sheet: 7.

Test |  |  |  |  |  |  | Target |  | Actual |  |  |  |  | 2011 |  |  |  |  |  |  |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014
Activity | Core | Stream | Task | Milestone | Accountable | External | Start | End | Actual | Actual End Date | Status | Funding | Notes/Location | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
7 | Main Title
7.1 | Title
7.1
7.1
7.1
7.1
7.1
7.1
7.1
Spreadsheet: 793249d1661363787-creating-a-results-list-of-multiple-races-finn-resultaten-2022-hd
Sheet: 8 mei

 |  | Column1 | 1e wedstrijd | 2e wedstrijd | 3e wedstrijd | 4e wedstrijd |  |  | Place | sailnumber | points | points overall | count
 |  | 1 | 151 | 13 | 151 | 151 |  |  | 1 |  | 6 | 14
 |  | 2 | 220 | 1015 | 131 | 63 |  |  | 2 | 220 | 15 | 13
 |  | 3 | 63 | 151 | 220 | 1015 |  |  | 3 | 113 | 19 | 12
 |  | 4 | 113 | 220 | 931 | 13 |  |  | 4 | 1015 | 22 | 11
 |  | 5 | 199 | 113 | 250 | 931 |  |  | 5 | 13 | 24 | 10
 |  | 6 | 131 | 199 | 1015 | 220 |  |  | 6 | 931 | 24 | 9
 |  | 7 | 931 | 250 | 13 | 199 |  |  | 7 | 63 | 25 | 8
 |  | 8 | 49 | 931 | 63 | 145 |  |  | 8 | 131 | 29 | 7
 |  | 9 | 145 | 131 | 49 | 250 |  |  | 9 | 199 | 29 | 6
 |  | 10 | 56 | 145 | 113 | 56 |  |  | 10 | 250 | 34 | 5
 |  | 11 | 1015 | 49 | 199 | 197 |  |  | 11 | 145 | 39 | 4
 |  | 12 | 13 | 63 | 145 | 131 |  |  | 12 | 49 | 41 | 3
 |  | 13 | 250 | 56 | 56 | 49 |  |  | 13 | 56 | 46 | 2
 |  | 14 | 197 | 197 | 197 |  |  |  | 14 | 197 | 53 | 1
 |  | 15 |  |  |  |  |  |  |  | 0 | 354
 |  | 16
 |  | 17
 |  | 18
 |  | 19
Spreadsheet: b876e504-718b-4b1b-9d5e-76f385871e44
Sheet: QTD Recon Q1FY12

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations
(in millions, except per share data)
 | Three Months Ended June 30, 2011
 | GAAP Results |  | Acquisition-related expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Restructuring and other |  | Stock-based compensation |  | Income tax adjustments |  | Non-GAAP Results
Net revenue | 999 |  | 0 |  | -475 |  | 0 |  | 0 |  | 0 |  | 524
Cost of revenue | 240 |  | -3 |  | 0 |  | 0 |  | -1 |  | 0 |  | 236
Gross profit | 759 |  | 3 |  | -475 |  | 0 |  | 1 |  | 0 |  | 288
Operating expenses:
Marketing and sales | 140 |  | 0 |  | 0 |  | 0 |  | -5 |  | 0 |  | 135
General and administrative | 74 |  | 0 |  | 0 |  | 0 |  | -9 |  | 0 |  | 65
Research and development | 285 |  | 0 |  | 0 |  | 0 |  | -23 |  | 0 |  | 262
Acquisition-related contingent consideration | 2 |  | -2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 13 |  | -13 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring and other | 18 |  | 0 |  | 0 |  | -18 |  | 0 |  | 0 |  | -
Total operating expenses | 532 |  | -15 |  | 0 |  | -18 |  | -37 |  | 0 |  | 462
Operating income (loss) | 227 |  | 18 |  | -475 |  | 18 |  | 38 |  | 0 |  | -174
Interest and other income (expense), net | 3 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 3
Income (loss) before provision for (benefit from) income taxes | 230 |  | 18 |  | -475 |  | 18 |  | 38 |  | 0 |  | -171
Provision for (benefit from) income taxes | 9 |  | 0 |  | 0 |  | 0 |  | 0 |  | -57 |  | -48
Net income (loss) | 221 |  | 18 |  | -475 |  | 18 |  | 38 |  | 57 |  | -123
Earnings per share |  |  |  |  |  |  |  |  | Loss per share
Basic | 0.67 |  |  |  |  |  |  |  | Basic and diluted |  |  |  | -0.37
Diluted | 0.66
Number of shares used in computation |  |  |  |  |  |  |  |  | Number of shares used in computation
Basic | 331 |  |  |  |  |  |  |  | Basic and diluted |  |  |  | 331
Diluted | 337
Spreadsheet: kate_symes__19110__NP 15 pages
Sheet: DJ NP15

 |  |  | Firm | Volume | Firm | Volume | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-04-16 00:00:00 |  | 286.52 | 25008 | 213.36 | 10232
 | 2001-04-15 00:00:00 |  |  |  |  |  | 213.36 | 30696
 | 2001-04-14 00:00:00 |  | 268.4 | 18720 | 236.7 | 9400
 | 2001-04-13 00:00:00 |  | 268.4 | 18720 | 236.7 | 9400
 | 2001-04-12 00:00:00 |  | 341.1 | 29680 | 318.17 | 10400
 | 2001-04-11 00:00:00 |  | 348.15 | 35136 | 310.12 | 10400
 | 2001-04-10 00:00:00 |  | 326.44 | 32608 | 301.85 | 13000
 | 2001-04-09 00:00:00 |  | 268.28 | 26320 | 225.55 | 9800
 | 2001-04-08 00:00:00 |  |  |  |  |  | 225.55 | 29400
 | 2001-04-07 00:00:00 |  | 258.22 | 28320 | 196.69 | 9000
 | 2001-04-06 00:00:00 |  | 258.22 | 28320 | 196.69 | 9000
 | 2001-04-05 00:00:00 |  | 301.84 | 30864 | 235.95 | 8200
 | 2001-04-04 00:00:00 |  | 278.15 | 35376 | 204.75 | 9232
 | 2001-04-03 00:00:00 |  | 245.99 | 21936 | 136.34 | 7512
 | 2001-04-02 00:00:00 |  | 228.71 | 17360 | 140.68 | 5000
 | 2001-04-01 00:00:00 |  |  |  |  |  | 142.24 | 15000
 | 2001-03-31 00:00:00 |  | 181.02 | 24000 | 93.46 | 3640
 | 2001-03-30 00:00:00 |  | 181.94 | 20800 | 93.46 | 3640
 | 2001-03-29 00:00:00 |  | 178.38 | 28864 | 87.16 | 10496
 | 2001-03-28 00:00:00 |  | 142.39 | 35120 | 78.18 | 4400
 | 2001-03-27 00:00:00 |  | 140.58 | 29520 | 76.2 | 4000
 | 2001-03-26 00:00:00 |  | 266.09 | 24560 | 155.06 | 6160
 | 2001-03-25 00:00:00 |  |  |  |  |  | 153.65 | 16680
 | 2001-03-24 00:00:00 |  | 270.02 | 21120 | 152.5 | 5840
 | 2001-03-23 00:00:00 |  | 270.02 | 21120 | 152.5 | 5840
 | 2001-03-22 00:00:00 |  | 294.15 | 12720 | 177.94 | 7200
 | 2001-03-21 00:00:00 |  | 406.47 | 10320 | 234.87 | 5400
 | 2001-03-20 00:00:00 |  | 391.63 | 25920 | 261.33 | 9000
 | 2001-03-19 00:00:00 |  | 362.59 | 19760 | 274.08 | 10440
 | 2001-03-18 00:00:00 |  |  |  |  |  | 262.23 | 32520
 | 2001-03-17 00:00:00 |  | 237.03 | 39120 | 176.44 | 8200
Spreadsheet: 542992d1508190016-if-function-when-price-above-700-and-ssd-is-y-how-to-bring-the-text-i-need-example-6
Sheet: Sheet2

Units | USD | Column1 | Brand Cluster | Gaming Y/N | SSD Y/N | Pure Premium
1 | 3038.105726872247 |  | Apple | Non Gaming | Y
1 | 2286.013215859031 |  | Apple | Gaming | Y
4 | 6723.348017621145 |  | ASUS | Gaming | Y
32 | 58763.05066079295 |  | ASUS | Gaming | Y
42 | 24244.43832599119 |  | ASUS | Non Gaming | Y
1801 | 1212859.170653908 |  | Dell | Non Gaming | Y
230 | 201450.5506607929 |  | Acer | Non Gaming | Y
27 | 21816.62995594714 |  | Apple | Non Gaming | Y
154 | 144003.3039647577 |  | Apple | Non Gaming | Y
8 | 4366.079295154185 |  | Apple | Non Gaming | Y
What I want to bring in column G:
Output "Pure Premium" in column F when:
 | -SSD "Y" and USD/Units =>700
 | Brand [NAME] is "Apple"
But if column "Gaming Y/N" is equal to "Gaming" output "Non Premium"
Taking as example cell C6, my result in G6 is "Premium", however, since this lines price is below $700, eventhough in SSD I have "Y", it should be classified as "Not Premium" due to being below $700.
Current formula: =IF(AND([@[Gaming Y/N]]="Gaming",OR([@USD]/[@Units]>=700,[@[Brand Cluster]]="Apple",[@[SSD Y/N]]="Y")),"Not Premium",IF(OR([@USD]/[@Units]>=700,[@[Brand Cluster]]="Apple",[@[SSD Y/N]]="Y"),"Premium","Not Premium"))
Spreadsheet: 881246d1729237144-req-formula-to-consolidate-time-worked-consolidate_time_worked
Sheet: Expected Result

Opened Date | Updated Date | Ticket Number | Assigned to | Time worked in Seconds | in Hours
2024-10-17 00:00:00 | 2024-10-17 06:00:05 | 19202641 | Jitu | 408
2024-10-10 00:00:00 | 2024-10-10 14:56:25 | 3183722 | Teju | 374
2024-10-07 00:00:00 | 2024-10-07 05:51:01 | 19164727 | Jitu | 1020
2024-10-07 00:00:00 | 2024-10-08 06:11:42 | 19164727 | Jitu | 2650
2024-10-03 00:00:00 | 2024-10-03 16:02:12 | 3170449 | Jitu | 373
2024-10-03 00:00:00 | 2024-10-04 05:23:56 | 3170449 | Jitu | 23
2024-10-02 00:00:00 | 2024-10-02 07:28:17 | 19150637 | Jitesh | 8098
2024-10-04 00:00:00 | 2024-10-17 09:46:18 | 3172544 | Jitesh | 27
2024-10-04 00:00:00 | 2024-10-04 05:17:47 | 3172544 | Jitesh | 6
2024-10-04 00:00:00 | 2024-10-08 14:53:36 | 3172544 | Jitesh
2024-10-04 00:00:00 | 2024-10-14 09:44:50 | 3172544 | Jitesh | 156
2024-10-04 00:00:00 | 2024-10-14 09:37:21 | 3172544 | Jitesh | 579
2024-10-01 00:00:00 | 2024-10-03 15:35:15 | 3165736 | Jitesh | 109
2024-10-01 00:00:00 | 2024-10-01 12:46:52 | 3165736 | Jitesh | 199
Spreadsheet: 94150d1294032229-formula-for-sport-rankings-wrestlingleage
Sheet: 119

Weight | Ranking | First Name | Last Name | School | Section | Grade
119 | 1 | Nahshon | Garrett | Chico | NS | 12 | reno 1
119 | 2 | [NAME] | Knoblauch | Clovis West | CS | 12 | reno 2
119 | 3 | Martin | [NAME] | [NAME] | SJ | 11
119 | 4 | [NAME] | Miranda | Poway | SD | 11 | reno 8
119 | 5 | Justin | Jauregui | Clovis East | CS | 12
119 | 6 | Tyler | Adams | Tesoro | SS | 12
119 | 7 | [NAME] | [NAME] | De La Salle | NC | 11 | reno 7
119 | 8 | [NAME] | [NAME] | El Camino Real | LA | 10
119 | 9 | Silverio | Esparza | Lemoore | CS | 10 | reno t12
119 | 10 | Javier | Gasca | Central | CS | 10 | zink 1
119 | 11 | [NAME] | Greybill | Ponderosa | SJ | 12
119 | 12 | [NAME] | Gaytan | Clovis | CS | 10 | zink 2
119 | 13 | [NAME] | Polonco | [NAME] | CC | 11
119 | 14 | Tyler | [NAME] | Nevada Union | SJ | 12
119 | 15 | Grant | Burkhalter | [NAME] | SJ | 12
119 | 16 | [NAME] | Palacios | Calvary Chapel | SS | 11
Spreadsheet: 820465d1678116583-if-statement-with-3-criteria-help
Sheet: Sheet1

 |  | date difference | DOC Monthly | DOC Weekly | FC Start of Month | FC Weekly | Name | DoC | FC Date | Customer ID
 |  |  | 2022-09-01 00:00:00 | 2022-09-19 00:00:00 | 2022-09-01 00:00:00 | 2022-09-26 00:00:00 | ACTON | 2022-09-23 00:00:00 | 2022-09-30 00:00:00 | 168e0311-09ff-4a90-af52-edd9a01fa00d
 |  |  | 2022-09-01 00:00:00 | 2022-09-19 00:00:00 | 2022-10-01 00:00:00 | 2022-10-03 00:00:00 | ACTON | 2022-09-22 00:00:00 | 2022-10-07 00:00:00 | 29ee19d4-3554-4158-be8c-b8e6fe0fd430
 |  |  | 2022-09-01 00:00:00 | 2022-09-19 00:00:00 | 2022-10-01 00:00:00 | 2022-10-03 00:00:00 | ACTON | 2022-09-25 00:00:00 | 2022-10-07 00:00:00 | d41eef85-38ef-46fb-ba61-bc642778d405
 | Want to show error |  | 2022-09-01 00:00:00 | 2022-09-26 00:00:00 | 2022-10-01 00:00:00 | 2022-10-10 00:00:00 | ACTON | 2022-09-28 00:00:00 | 2022-10-08 00:00:00
 |  |  | 2022-09-01 00:00:00 | 2022-09-26 00:00:00 | 2022-10-01 00:00:00 | 2022-10-10 00:00:00 | ACTON | 2022-09-28 00:00:00 | 2022-10-12 00:00:00 | da38e7b4-b884-482b-b538-4cd9286069a4
Spreadsheet: 94126d1293991572-excel-2007-populate-invoice-fields-based-on-invoice-number-sample_invoice-1-
Sheet: Sheet1

BUSINESS NAME
Industrial - Commercial - Domestic
Pest and Termite Control Services
Date:
 |  |  |  |  |  |  | TAX INVOICE NO: | 5010
 |  |  |  |  |  |  | Public Health Department No:
 |  |  |  |  |  |  | ABN:
Details |  |  |  |  | Amount:
 |  |  |  |  | GST @ 10%
 |  |  |  | INVOICE TOTAL
Please Note:
Should there be any reason that this invoice does not come under your agency's resposibility for payment, we would appreciate
your immediate advice to this office to enable us to change our records accordingly. If not, then we will assume that your office
accepts responsibility for payment.
If you prefer to make direct bank payments, our Bank details are as follows:
Please indicate your invoice number as a reference.
Bank:
Branch:
B S B:
Account No:
Account Name:
Terms: 14 Days |  |  |  |  | Please note our New Bank Details above!
 |  |  | " |  |  | "
REMITTANCE ADVICE
INVOICE No.
Name:
Please return this slip with remittance to :
 |  |  |  |  |  | Amount: